Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Fundamentals Of Project Management

Authors: Joseph Heagney

4th Edition

0814417485, 978-0814417485

More Books

Students also viewed these General Management questions

Question

What do U.S. managers usually mean by Chapter 11 and Chapter 7?

Answered: 1 week ago