Question: Problem 4 : Using the data below: Period Sales 1 2 0 1 2 2 1 3 3 2 1 0 4 2 2 2

Problem 4:
Using the data below:
Period Sales
1
201
2
213
3
210
4
222
5
234
6
246
a) Find the forecast for period 7 based on a three-period moving average. b) Find the forecast for period 7 based on a five-period moving average.
c) Find the forecast for period 2 using the nave method.
d) Find the forecast for period 7 based on a four-period weighted moving average using the following weights:
1 period prior
0.4
2 periods prior
0.3
3 periods prior
0.2
4 periods prior
0.1
e) Find the forecast for period 7 based on exponential smoothing with alpha =0.6 and assuming that the forecast for period 5 was 222.
Problem 5:
Given the following data, find the seasonal relatives for all four quarters.
Period
Sales
Q12024
668
Q22024
712
Q32024
648
Q42024
1089
Q12025
686
Q22025
806
Q32025
809
Q42025
1080

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!