View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default 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