Question: C-2. Use MAD to decide which method produced the better forecast over the six-month period. O Exponential smoothing. Three-month moving average. Problem 18-17 (Algo) Here

C-2. Use MAD to decide which method produced the

C-2. Use MAD to decide which method produced the better forecast over the six-month period. O Exponential smoothing. Three-month moving average. Problem 18-17 (Algo) 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 March April May June July August September ACTUAL 118 135 156 175 166 183 145 136 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.30 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.) Month Exponential Smoothing 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Problem 18-17 (Algo) 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...

After using your forecasting model for six months, you decide to test it using MAD and a tracking signal. Here are the forecast and actual demands for the six-month period: PERIOD May June July...

Problem 3-17 (Algo) 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...

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...

2 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...

Q2. Imagine you are the Procurement Manager and your company is planning to replace some of its office furniture. You are required to write a letter (in Full block format, following closed...

A radio talk-show host asked listeners to respond either yes or no to the question Is the candidate who spends the most on a campaign the most likely to win? Fifteen people called in and nine said...

The sustainable growth rate represents what rate at which the firm can grow?

What is an example of constructive feedback? provide reference