Question
Weekly sales of Ten-Grain Bread at the local organic food market are in the table below. Week Sales 1 415 2 389 3 420 4
Weekly sales of Ten-Grain Bread at the local organic food market are in the table below. Week Sales
1 415
2 389
3 420
4 382
5 410
6 432
7 405
8 421 Required:
1. Plot the weekly sales data of Ten-Grain Bread. (20 marks)
2. Forecast the week 9 sales using each of the following:
a. Naive method. (10 marks)
b. A five-week moving average. (20 marks)
c. A four-week weighted average using 0.1, 0.2, 0.3, 0.4, with the heaviest weights applied to the most recent months. (25 marks)
d. Compute the forecast for the week 9 using exponential smoothing with a forecast for week 5 of 410 and =0.2=0.2. (25 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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