To improve their forecasting, two companies have agreed to enter into a CPFR relationship - A producer of bicycles, Marley Bikes, and their primary customer - Bike Store, Inc. Bike Store, Inc, currently has 40 retail outlets and has provided details to Marley Bikes about their upcoming store openings and promotions to help Marley Bikes develop their forecast for the coming year. Bike Store, Inc. is planning on opening up 5 new stores in March, 5 new stores in May and 5 new stores in August. They also expect that their sales will increase by 6% in May, 6% in June, 7% in July, 6% in August and by 5% in September. Marley Bikes has developed the following forecast for 2015 prior to considering this information from Bike Store, Inc.
Calculate an adjusted forecast for 2016 using the information provided above. Please show your work to receive full credit.
|
Month
|
Forecast
|
|
Jan
|
1000
|
|
Feb
|
2000
|
|
March
|
3000
|
|
April
|
2500
|
|
May
|
2000
|
|
June
|
4000
|
|
July
|
5000
|
|
August
|
4000
|
|
September
|
3000
|
|
October
|
2000
|
|
November
|
2000
|
|
December
|
1000
|