Question: (Using the same problem) Calculate the MAD for the Weighted Moving Average 2 periods (weights of 2 for most recent and 1 for time period

(Using the same problem) Calculate the MAD for

(Using the same problem) Calculate the MAD for the Weighted Moving Average 2 periods (weights of 2 for most recent and 1 for time period before..... previously done) and the Exponential Smoothing with alpha .3 and starting forecast of 75 ... previously done) forecasts. What is the MAD for the most accurate forecast? Consulting income at Kate Walsh Associates for the period of January - July has been as follows: MONTH Error Error INCOME (1000) Weighted Moving Average Exponential Smoothing Alpha .3 75.0 January February March April May June July August O A. 4.575 70.0 68.5 64.8 76.2 71.3 72.8 78.8 OB. 4.42 O C.3.6241 O D.5.2954

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!

The department manager using a combination of methods has forecast sales of toasters at a local department store. Calculate the MAD for the manager's forecast. Compare the manager's forecast against...

1) The department manager using a combination of methods has forecast sales of toasters at a local department store. Calculate the MAD for the manager's forecast. Compare the manager's forecast...

The attached Excel spreadsheet contains time-series data capturing the weekly average of crude oil imports of a small country in thousands of barrels per day. Your task is to use this historical data...

Tires for You, Inc. Tires for You, Inc. (TFY), founded in 1987, is an automotive repair shop specializing in replacement tires. Located in Altoona, Pennsylvania, TFY has grown successfully over the...

Question C, please do not neglect it Task 3 - Demand Forecasting Data is given for the sales of a leading mobile company across Oman. The sales of the mobile company over the past 12-month period for...

. Gasoline Sales Time Series Week Sales (1000s of gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 Refer again to the gasoline sales time series data in the above table. 1....

Problem 1. (10 points) A manager recorded the number of gallons of ice cream sold for the past six periods. He asked you to choose a forecasting model to predict the demand for gallons of ice cream...

A milk vendor wants to predict the demand for the 11 th month using the actual sales of last 10 months. The manager subjectively used 0.40,0.30,0.30 respectively for the most recent, recent and...

13 EXCEL ASSIGNMENT 1-NXX(1) AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 A A Wrap Text Paste B 1 U v A Merge & Center G28 Q1 a g Share Comments...

=10-34 Using the data in Solved Problem 10-3, develop a spreadsheet for a 2-period weighted moving average forecast with weights of 0.6 (w1)for the most recent period and 0.4 (w2) for the other...

A system operating at steady state and consisting of an adiabatic throttling valve, a well- insulated turbine, and an adiabatic mixing chamber is shown below. Water/steam is the working fluid and...

What are the Critical path and its purpose?

The Folio column shows: Group of answer choices In which journal the entry originated In which ledger the entry originated Additional details about the entry that are relevant The name of the account

What is an example of constructive feedback? provide reference