Dear All,

I would like to do the following in Excel:

I have a chemical product (compound) that is evenly brought into the production process. It is available in two different strengths:

Product X, strength 10 (available package sizes: 25, 50 und 100)
Product X, strength 30 (available package sizes: 50 und 100)

The planner shall at first enter the available quantities (bought, ordered or in stock):

Quantity product X, strength 10: To be entered
Quantity product X, strength 30: To be entered

The production eeds exactly a dose of strength 50 every day. This is done by using one unit of strength 30 and two units of strengt 10.

The user shall now enter the production start date (example: 1 January). Excel should then calculate the date when the last unit will be used in order to forecast when we run out of stock. Depending on the quanitities, it might be the case that only one of either strenghts would run out. In this case it should calculate the last day where the product can be produced.

Ideas anyone?

Thank you in advance

PP81