| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weeks of Supply Calculation
I am looking for a way to calculate a Weeks of Supply number based on
inventory level as well as a time-phase demand row WITHOUT just using the average of the demand. Anyone? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Weeks of Supply Calculation
It's difficult to give a definitive answer without seeing how your data is
laid out and some example data. But I suspect that either a variation of a SUMPRODUCT() [Excel 2007, 2003 and earlier] or SUMIFS() [Excel 2007 only] formulas may provide a solution. "Rob Williamson PSU" wrote: I am looking for a way to calculate a Weeks of Supply number based on inventory level as well as a time-phase demand row WITHOUT just using the average of the demand. Anyone? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does anyone have aformula for Weeks Supply? | Excel Discussion (Misc queries) | |||
| Does anyone have a formula for Days or Weeks Supply? | Excel Discussion (Misc queries) | |||
| Weeks of Supply Function | Excel Worksheet Functions | |||
| return calculation every four weeks | Excel Discussion (Misc queries) | |||
| Weeks of Supply Calculation | Excel Discussion (Misc queries) | |||
![Rob Williamson PSU[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
