| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| CALCULATE WITH AVERAGE ???? | Excel Discussion (Misc queries) | |||
| Negative Entry to calculate remaining inventory | Excel Discussion (Misc queries) | |||
| Calculate a 30-day moving average based on the last x number of entries and date | Excel Worksheet Functions | |||
| how do i set up a worksheet to calculate the inventory? | Excel Worksheet Functions | |||
Linear Mode
