Question
After graduating from college, you and your friends start selling birdhouses made from recycled plastic. The idea has caught on, as shown by the following
After graduating from college, you and your friends start selling birdhouses made from recycled plastic. The idea has caught on, as shown by the following sales figures.
LOADING...
Click the icon to view the sales data.Part 2a. Prepare forecasts for June through September by using a three-period moving average model (enter your responses rounded to the nearest whole number).
Month | Demand | Forecast |
March | 200 | |
April | 2,310 | |
May | 1,830 | |
June | 3,760 | 14471447 |
Part 3
July | 3,640 | 26332633 |
Part 4
August | 4,540 | 30773077 |
Part 5
September | 39803980 |
Part 6
b.
Prepare forecasts for June through September by using an exponential smoothing model with
=0.7.
Assume that the forecast for May was
1,800
(enter your responses rounded to the nearest whole number).
Month | Demand | Forecast |
March | 200 | |
April | 2,310 | |
May | 1,830 | 1,800 |
June | 3,760 | 18211821 |
Part 7
July | 3,640 | 31783178 |
Part 8
August | 4,540 | 35013501 |
Part 9
September | 42284228 |
Part 10
c.
Prepare forecasts for June through September by using an adjusted exponential smoothing model with
=0.7
and
=0.2.
Assume that the unadjusted forecast
Ft
for May was
1,800
and the trend factor
Tt
for May was
800
(enter your responses rounded to the nearest whole number).
Month | Demand | Unadjusted forecast | Adjusted forecast |
March | 200 | ||
April | 2,310 | ||
May | 1,830 | 1,800 | |
June | 3,760 | 1,821 | 2,465 |
Part 11
July | 3,640 | 3,178 | enter your response here |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started