Duplicate SKUs to Result in YES/NO Based on Other Columns

I have a list of SKUs and locations. The master report that I get this data from is based on locations. So any given SKU may be listed multiple times in the report depending on how many locations that SKU can be found in the warehouse. I'm creating a spreadsheet to help me determine which SKUs need to be restocked. Overstock (excess stock) locations start with a Z. We pull stock from those locations to restock regular bins/locations. My spreadsheet is formulated to tell me if that location is a regular bin or an overstock location. I can set my minimum qty threshold and my spreadsheet will then tell me which SKUs are below that level and might need to be restocked. I can only restock a bin, though, if there is available overstock.

In my sample spreadsheet provided, you'll see a small list of SKUs. Some reflect that they need to be restocked but we don't have any overstock for them so they can't be restocked. There is one SKU that appears in this list twice (I manually highlighted it in red) - once for each location that product can be found and one of those locations is an overstock location. That means I can restock the regular bin with product from the overstock location.

The problem is creating a formula that recognizes the SKU is listed multiple times, it has an overstock location, AND it is below the threshold - that then means that it indeed can be restocked.

Could you help me with this? I'm game to create add'l helper formula columns if one formula in the "Can it be Restocked?" column isn't going to work.

Columns A-C are from the raw data report. Columns D and E are my additions to the report/spreadsheet. Column F is where I would like a YES or NO to appear if it can for real be restocked. And I know how to formulate that if the SKU, D's Yes/No and E's Yes/No were all on the same line. But with the SKU being on multiple lines putting D's/E's Yes/No on multiple lines, too - I'm stuck. That's why I don't know if I need another helper/formula column or if there's actually a formula that can go in Column F to accomplish this task.

@Vraag en antwoord
Ideally I should only have one TRUE result - one SKU that can actually be restocked - 1284-10073. But when I plug your formula into my worksheet, I get 4 TRUEs - 1284-10070, 1284-10073, 1284-10075, and 1284-10076.

@etaf That worked!! Thank you so much!!!