Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period.

MONTH ACTUAL
January 112
February 128
March 145
April 168
May 169
June 181
July 148
August 141
September 139

a. Forecast April through September using a three-month moving average. (Round your answers to 2 decimal places.)

b. Use simple exponential smoothing with an alpha of 0.40 to estimate April through September, using the average of January through March as the initial forecast for April. (Round your answers to 2 decimal places.)

c-1. Calculate MAD for each method. (Round your answers to 2 decimal places.)

c-2. Use MAD to decide which method produced the better forecast over the six-month period.

multiple choice

  • Exponential smoothing.
  • Three-month moving average.

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

Horngrens Accounting The Financial Chapters

Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura

10th Edition

0133117561, 978-0133117561

More Books

Students also viewed these Accounting questions

Question

5. How can I help others in the network achieve their goals?

Answered: 1 week ago