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