Highlighting when stock is low if there are several entries (batches) of same product

I'm working on a stock sheet which lists products, their batch numbers, number of products left, and various other information.

Sometimes there are several different entries of the same product number but with different batch numbers. (The number of entries for the same product can go up and down as stock is used up and more is bought in.)

For each product, there is a specific quantity when, if stock goes below that number, more stock should be ordered.

I want excel to highlight whenever a product goes below its specific quantity.

What is the best way to do this, when there are often several entries for the same product, and the number of entries can vary?

I'd really appreciate your help!
(Do say if I need to explain this in more detail.)

Thanks for replying. Here's a sample workbook.

The minimum quanties are in the same row as the the other product details.

There will be minimum quantities written for each product as they come in.

Yes the batches of the same product will all have the same minimum quantity. The minimum quantity will apply to all batches as a whole so if there are 2 batches of oranges each at 100kg, and the minimum quantity is 100kg, that is well above the minimum quantity; only once they reach a sum total of 100kg, e.g. 50kg of each batch, do I want it to be highlighted.

There won't be any negative quantities - the Qty. should say the actual amount of stock left. I added the total quantity column thinking it might be come in useful at some point for this job of highlighting when stock is low. I thought maybe a formula could automatically enter the total quantities in that column. But it may or may not be helpful.

I've updated the workbook with more information.

Everything's been entered manually but I would want it to automatically say Yes or in the Low Stock Column if appropriate.

For example,
Oranges: Min Qty = 60. There are 2 batches, 5 left of one, 50 left of the other. Total = 55, so I would like it to say yes in the Low Stock column.

Pears: Min Qty = 20. There are 2 batches, one batch has 10, one has 120. Total = 130, so I'd like it to say no in the Low Stock column.

Sorry I forgot to attach...

Thank you for your help, everything after the first formula is just what I need.

For the first part though, the number of batches of the one product can vary - at one time there may be one batch, at another there may be additional rows inserted for several batches.

Is there some way to make it search through the list for entries with the same product number and add up their quantities automatically?

Oh fantastic!! Thanks so much!