Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

table [ [ 1 , Month,Demand for Samsung M 1 1 ] , [ 2 , January, 4 2 0 ] , [ 3

\table[[1,Month,Demand for Samsung M11],[2,January,420],[3,February,340],[4,March,520],[5,April,600],[6,May,450],[7,June,550],[8,July,700],[9,August,780],[10,September,800],[11,October,840],[12,November,910],[13,December,880]]
a) Calculate the 3-monthly moving average from January to December.
Calculate the 4-monthly moving average from January to December
Calculate the 3-month weighted moving average for all the months if the weightings are given as
Month Weights
Month 1(two months before the current month)0.2
Month 2(one month before the current month)0.3
Month 3(Most current month)0.5Calculate the 4-month weighted moving average for all the months if the weightings are given as
Month Weights
Month 1(three months before the current month)0.15
Month 2(two months before the current month)0.25
Month 3(one month before the current month)0.3
Month 4(Most current month)0.3
[4 Marks]
e) Explain what happens when you increase the number of periods in a moving average forecast. [1.5 Mark]
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

Step: 3

blur-text-image

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

Public Finance In Canada

Authors: Harvey S. Rosen, Wen, Snoddon

4th Canadian Edition

0070071837, 978-0070071834

More Books

Students also viewed these Finance questions

Question

Define facework and identify three primary facework strategies

Answered: 1 week ago