Forecasting Data Increases

[esi]

I have historical sales data for the last 3 years on a specific product.
I've just found out that due to a 1/1/05 contract pricing change our
projected sales will increase 125% by end of Q2 2005 on this product.
Currently, our volume is around 3,000 units per day. Does anyone have any
suggestions of how to forecast our "ramp up" to 6,750? The only info we
have been given is that our customers will be notified of contract pricing
changes in Q4 2004 and that we will not see a large increase in sales until
after our customers receive their first order in 2005 since, at that time
they will be financially affected by the pricing change and will make the a
product switch on their second order. The majority of our customers will
place their first order in Q1 2005.

I'm attempting to forecast by week our increase in volume.

 

[AlfD]

Hi!

One has to say, this not an Excel problem. This is a markettin
problem, because I guess only you know the pattern of sales and th
impact of pricing etc on your buyers' "habits". After all: they migh
even hold back buying if things are to get better for them...

Al