Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
ACTUAL 111 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 January February 129 March April May June July August September 152 165 168 174 147 140 147 a. Forecast April through September using a three-month moving average. (Round your answers to 2 decimal places.) Month Three-Month Moving Average April May June July August September b. Use simple exponential smoothing with an alpha of 0.10 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.) Exponential Smoothing Month April May June July August September c-1. Calculate MAD for each method. (Round your answers to 2 decimal places.) MAD Three-month moving average Exponential smoothing Exponential smoothing c-2. Use MAD to decide which method produced the better forecast over the six-month period. Three-month moving average. Exponential smoothing

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

Trading Financial Derivatives

Authors: Kas Salazar ,Gunter Meissner

1st Edition

0536008280, 978-0536008282

More Books

Students also viewed these Finance questions