Question
Weekly sales of Heartland multi-grain bread at the local Organnons Natural Market are provided in the table below. Based on these data, calculate the following.
Weekly sales of Heartland multi-grain bread at the local Organnons Natural Market are provided in the table below. Based on these data, calculate the following.
Week | Sales |
1 | 415 |
2 | 389 |
3 | 420 |
4 | 400 |
5 | 410 |
6 | 432 |
7 | 418 |
8 | 421 |
9 | 444 |
a. Forecast for the 10th week using a 4-week weighted moving average, with the weights of .8, .7, .4, and .3 (.8 applied to the most recent period): [ Select ] ["430.32", "450.78", "330.28", "422.21", "395.35"] . What is the MAD? [ Select ] ["8.30", "5.37", "9.42", "11.24", ".4"]
b. Forecast for the 12th week using Trend analysis: [ Select ] ["444.56", "425.61", "451.15", "418.89", "402.67"] . What is the MAD? [ Select ] ["20", "2.65", "10.84", "9.33", "7.46"]
c. Using exponential smoothing with an alpha of .67, and a first period forecast of 413. What is the forecast for week 10? [ Select ] ["416.45", "442.67", "436.30", "419.71", "420.67"] . What is the MAD? [ Select ] ["14.67", "12.33", "2.28", "13.64", "8.56"]
d. Based on the MAD analysis, which forecasting approach should Organnons utilize? [ Select ] ["either 4-week moving average, or trend would suffice based on MAD", "Cannot Determine based on the information given", "4-week weighted moving average", "exponential smoothing", "Trend Analysis"]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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