| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Months Supply Question
I have a spreadsheet with current inventory on hand and the sales for each
month from the last year. I want to figure how many months our inventory on hand will last based on the last years sales. For instance, WidgetA has 100 on hand and Mar, Apr, May, Jun & Jul sales were 5,10,15,40,60, respectively. I know that we have 4.5 months supply, but I have to manually figure this calculation. I have more than 400 items. This takes a long time to figure, is there any way to automate the figuring of the months supply? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3D reference question in inventory Worksheet | Excel Worksheet Functions | |||
| Inventory Spreadsheet Question | Excel Worksheet Functions | |||
| I need a template for my supply inventory | Excel Worksheet Functions | |||
| Inventory List Question | Excel Discussion (Misc queries) | |||
| How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
Threaded Mode
