Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Logistics

Authors: Paul R. Murphy, Michael Knemeyer

11th edition

132953463, 2900132953466, 978-0132953467

More Books

Students also viewed these General Management questions

Question

1.9. Why is foreign exchange considered an asset class?

Answered: 1 week ago