I have filter media that I need to order every week and some filter medias I
have too much of. I need a formula that can tell me the exact date I need to
order and how much. I have an example of what I have so far:

C9 is Weekly Usage 2,000
D9 is Actual Inventory Date 10/06/05 20,000
E9 Firm Future Receipts week ending 10/10/05 0
F9 Projected Inventory weeking ending 10/10/05 18,000
G9 Days on hand Projected 10 days
My lead time is 60 days

Can anyone please help me with a formula that can calculate the exact date
and quantity I need to order?

Thank you,
Angie