calculate number of day to deplete inventory without average
 

Hi,

If I have 5,000 of an item in stock today and I forecast to sell:
1,000 the following day
1,200 after that
800 after that
1,050 after that
700 after that
1,200 after that
what formula would I use to know that in 6 days I will be out of stock using
actuals, not average?
Thanks!

calculate number of day to deplete inventory without average
 

Hi xavier,

Pls see the following formula helps or not:
A B C
1 Stock 5000
2
3 Forecast sell Remain formula
4 Day 1 1000 4000 =C2-C5
5 Day 2 1200 2800 =D5-C6
6 Day 3 800 2000 =D6-C7
7 Day 4 1050 950 =D7-C8
8 Day 5 700 250 =D8-C9
9 Day 6 1200 (950.00) =D9-C10
10 Day 7


"xavier" wrote:

Hi,

If I have 5,000 of an item in stock today and I forecast to sell:
1,000 the following day
1,200 after that
800 after that
1,050 after that
700 after that
1,200 after that
what formula would I use to know that in 6 days I will be out of stock using
actuals, not average?
Thanks!