calculate number of day to deplete inventory without average

  • Thread starter Thread starter xavier
  • Start date Start date
X

xavier

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate rolling average using last 30 values greater than 0. 3
Average of last 30 days 9
14 Day Average 4
Weighted averaging of dates 3
Convert Number of Month to Number of days 4
Available to sell 1
Calculating averages but without the extreme/exceptional data points 2
Access Updating inventory levels 0

Back
Top