| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Months of supply
I need to calculate months of supply. Supplied data is on-hand inventory and
a use forecast. For example: Inventory 30 Use: Mo1 Mo2 Mo3 Mo4 ... 10 15 10 10 Answer: 2.5 The forecast may "use" more inventory than currently on hand since it may be replenshied, but that is not part of this analysis. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inventory Months Supply Question | Excel Worksheet Functions | |||
| Supply and Demand Charting | Charts and Charting in Excel | |||
| Autofilter - Supply Criteria | Excel Discussion (Misc queries) | |||
| I need a template for my supply inventory | Excel Worksheet Functions | |||
| supply requisition | Excel Discussion (Misc queries) | |||
Threaded Mode
