B
bob
Hi,
I'm trying to come up with a template so i can forecast and rundown my
inventory. Basically, i've my current inventory and sell-out data. I'm going
to change to new product very soon, hence wanted to run down my inventory
before my new launch.
Need guidance on using IF or other formulas where it can tell me what should
be my forecast outer months.
For eg. I've inventory of 5000cs, my sell-out is only 4000cs. This means i'm
holding 1.25 month inventory or 37.5 inventory days. So, my plan is to launch
new product in july, i shouldn't buy anything this month, ie 0, then in Jan i
should buy 0.75*4000=3000cs only since i've 1000cs carried over.
Similarly in Feb, 4000cs, Mar 4000, Apr 4000cs, May 4000cs and June 4000cs.
In 2nd scenario, let's say i've inventory 12000cs, i've 3 months inventory,
this means it should be zero for next 3 months and 4000cs following.
But of course in both scenarios, we're not going to turn off the pipe
immediately to zero and repipeline in Feb onwards.
Maybe we try to reduce a little bit, 25%, 25% or so on to reduce the
inventory without affecting the sales.
Could anyone help.
thanks..
bob
I'm trying to come up with a template so i can forecast and rundown my
inventory. Basically, i've my current inventory and sell-out data. I'm going
to change to new product very soon, hence wanted to run down my inventory
before my new launch.
Need guidance on using IF or other formulas where it can tell me what should
be my forecast outer months.
For eg. I've inventory of 5000cs, my sell-out is only 4000cs. This means i'm
holding 1.25 month inventory or 37.5 inventory days. So, my plan is to launch
new product in july, i shouldn't buy anything this month, ie 0, then in Jan i
should buy 0.75*4000=3000cs only since i've 1000cs carried over.
Similarly in Feb, 4000cs, Mar 4000, Apr 4000cs, May 4000cs and June 4000cs.
In 2nd scenario, let's say i've inventory 12000cs, i've 3 months inventory,
this means it should be zero for next 3 months and 4000cs following.
But of course in both scenarios, we're not going to turn off the pipe
immediately to zero and repipeline in Feb onwards.
Maybe we try to reduce a little bit, 25%, 25% or so on to reduce the
inventory without affecting the sales.
Could anyone help.
thanks..
bob