I want to project when inventory will zero out on an item.

[Mike]

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

 

[Pete_UK]

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

 

[Bob I]

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

 

[Gary''s Student]

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.