Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table shows the actual demand observed over the last 1 1 years: table [ [ Year , 1 , 2 , 3

The following table shows the actual demand observed over the last 11 years:
\table[[Year,1,2,3,4,5,6,7,8,9,10,11],[Demand,7,10,5,9,12,9,12,13,8,13,7]]
This exercise contains only parts b,c, and d.
b) Using the 3-year moving average, provide the forecast from periods 4 through 12(round your responses to one decimal place).
\table[[Year,4,5,6,7,8,9,10,11,12],[Forecast,7.3,8.0,8.7,10.0,11.0,11.3,11.0,11.3,9.3]]
c) Using the 3-year weighted moving average with weights 0.15,0.25, and 0.60, using 0.60 for the most recent period, provide the forecast from periods 4 through 12(round your responses to two decimal places).
\table[[Year,4,5,6,7,8,9,10,11,12],[Forecast,,,,,,,,,
image text in transcribed

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

Small Business Management Entrepreneurship and Beyond

Authors: Timothy s. Hatten

5th edition

538453141, 978-0538453141

More Books

Students also viewed these General Management questions

Question

Calculate the largest poverty percentage rate in cell J 1 7 . 1 0

Answered: 1 week ago