I would have a running total for each product.

I would start by getting all outstanding orders for the first product and
get a count of the stock quantity for that product.

the 1str row of the speadsheet would contain just the Stock quantity. the
columns of the spreadsheett would be as follows

Production Rate is the number made each day
I would use conditional formating on column D to make the column a different
color depending on the number of days to fill and order. For example
Anything less than 5 days make Green
Anything between 5 to 10 days Yellow
Anything greatter than 10 days red.

Row
1 Production 75
Rate
2
Order Quantity Total in Days to
3 Number Ordered Stock Fill Order

4 125

5 14678 24 =C4-B5 if(c5=0,1,C5/B$1)

6



"Rohin Bhatia" wrote:

I use pivot tables to compile order quantity data from different
customers.The orders are for different products with paramaters like style ,
colour , size etc.
For all such products we have stock quantity ready with us and also under
production(fixed total quantity )
As different customer orders come in - HOW can I allocate stock / production
on some priority basis for these customers - And thus to know if we have
overbooked in some colours / sizes .
Can anyone please help
Thanks Rohin