Weeks of Supply Calculation

  • Thread starter Rob Williamson PSU
  • Start date
R

Rob Williamson PSU

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?
 
J

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Turn Rate to Weekly Supply 11
Calculate weeks cover 2
How do I set more than 1 target cell using MS Solver? 5
Weeks of Supply Function 1
Excel Count If Rolling Sum 3
Inventory Months Supply Question 13
Weeks of Supply Calculation 5
"Backsolve" Poisson function 4

Top