Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to project when inventory will zero out on an item.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to project when inventory will zero out on an item.
Suppose you sold 30 items in the last 6 weeks and that you have 50 left in
stock. Based on your past performance you sell them at 5 items per week on average, so it will take you another 10 weeks to sell the remaining items - this will take you beyond the end of the year, so you need to sell them at a faster rate. Is this what you meant? You give no details of how your data is laid out, so I can only generalise to you. Pete "Mike" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to project when inventory will zero out on an item.
Lets assume that we will not be adding to the inventory.
We can come up with a reasonably accurate way of modelling the inventory reduction as follows: Put the current inventory in A1 (say 1234 units) Put the current week number in A2 (say week #42) In A3 the formula: =A1/(53-A2) this displays slight larger than 112 This means that if we sell off inventory at the rate of about 112 units per week, we can achieve the goal. The beauty of this approach is that we can update it as time goes on. If we see the required inventory depletion increasing week-by-week, we know that the goal is in danger. -- Gary''s Student - gsnu200810 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
To project inventory rundown and forecast | Excel Worksheet Functions | |||
How do I build a excel sheet that counts item in an inventory | Excel Worksheet Functions | |||
How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
How list inventory item codes so that they will be sorted correctl | Excel Discussion (Misc queries) |