View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default I want to project when inventory will zero out on an item.

Take current inventory, divide by the 10 weeks left in the year. Use
that many per week.

Mike wrote:

I have inventory going back 6 weeks. The item is going away at the end of
the year. I would like to project how I can bring this item to zero by the
end of the year by using the current inventory levels. Do I need projected
orders, POS? Any help would be appreciated

My version is Office 2003