Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a. Given the data shown above, beginning in Quarter 1 of year 2 , use a moving average based on four quarters to predict the
a. Given the data shown above, beginning in Quarter 1 of year 2 , use a moving average based on four quarters to predict the demand in each quarter. (Leave no cells blank - be certain to enter "0" wherever required. Negative answers should be indicated by a minus sign. Round your forecast answers to 1 decimal place. Then, starting with quarter 1 of year 2 , use these rounded forecast values to compute the error and absolute error answers. Enter those answers to 1 decimal place also.) \begin{tabular}{|l|l|l|l|l|l|} \hline Year 5 & Q1 & 40 & & & \\ \hline & Q2 & 40 & & & \\ \hline & Q3 & 55 & & & \\ \hline & Q4 & 50 & & & \\ \hline Year 6 & Q1 & 66 & & & \\ \hline & Q2 & 64 & & & \\ \hline & Q3 & 60 & & & \\ \hline & Q4 & 56 & & & \\ \hline Year 7 & Q1 & 64 & & & \\ \hline & Q2 & 69 & & & \\ \hline & Q3 & 68 & & & \\ \hline & Q4 & 71 & & & \\ \hline Year 8 & Q1 & 66 & & & \\ \hline & Q2 & 76 & & & \\ \hline & Q3 & 70 & & & \\ \hline & Q4 & 68 & & & \\ \hline & & & & & \\ \hline & & & & MFE & MAD \\ \hline \end{tabular} b. Using the same data, forecast demand using exponential smoothing. You are given an initial forecast for year 1 , quarter 1 of 17 . When generating your forecasts, assume that the smoothing coefficient is 0.10. (Leave no cells blank - be certain to enter "0" wherever required. Negative answers should be indicated by a minus sign. Round your forecast answers to 1 decimal place. Then, starting with quarter 1 of year 2, use these rounded forecast values to compute the error and absolute error answers. Enter those answers to 1 decimal place also.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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