Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute the sales forecast for July using the approaches given below. Do not round intermediate calculations. Round your answers to the nearest whole number. a

Compute the sales forecast for July using the approaches given below. Do not round intermediate calculations. Round your answers to the nearest whole number.
a three-month moving average
computers
a weighted three-month moving average using 0.40 for June, 0.40 for May, and 0.20 for April
computers
a linear trend equation
computers
exponential smoothing with \alpha (smoothing constant) equal to 0.40, assuming a February forecast of 23,000
computers
Calculate the MAD for each of the four techniques in part b. Use only the last 3 months to compare the same number of months for all methods. Do not round intermediate calculations. Round your answers to the nearest whole number.
MAD (three-month moving average):
computers
MAD (weighted three-month moving average):
computers
MAD (linear trend equation):
computers
MAD (exponential smoothing):
computers
Which is the best? Why?
-Select-
is better because it provides the
-Select-
MAD.

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

Facilities Planning

Authors: James A. Tompkins, John A. White, Yavuz A. Bozer, J. M. A. Tanchoco

4th Edition

0470444045, 978-0470444047

More Books

Students also viewed these General Management questions

Question

9-3. Describe the sampling design process.

Answered: 1 week ago