Question

The data below shows the number of goods manufactured in one year. ($ billion). Calculate forecasts...

The data below shows the number of goods manufactured in one year. ($ billion). Calculate forecasts for years 6 through 13 using a 5-year moving average. Then, calculate forecasts for years 6 through 13 using a 5-year weighted moving average. Weight the most recent year by 6, the previous year by 4, the year before that by 2, and the other years by 1. Be sure to show the entire table in the work area of the template. Answer the following questions: a) What is the forecast for year 13 based on the 5-year moving average? b) What is the forecast for year 13 based on the 5-year weighted moving average? c) What is the MAD for the moving average forecast? d) What is the MAD for the weighted moving average forecast? e) Which forecasting model that you calculated is better? Why? Year Factory orders 1 2,512.70 2 2,739.20 3 2,874.90 4 2,934.10 5 2,865.70 6 2,978.50 7 3,092.40 8 3,052.60 9 3,145.20 10 3,114.10 11 3,257.40 12 3,654.00 13

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The data below shows the number of goods manufactured in one year. ($ billion). Calculate forecasts...
The data below shows the number of goods manufactured in one year. ($ billion). Calculate forecasts for years 6 through 13 using a 5-year moving average. Then, calculate forecasts for years 6 through 13 using a 5-year weighted moving average. Weight the most recent year by 6, the previous year by 4, the year before that by 2, and the other years by 1. Be sure to show the entire table in the work area of the template. Answer the...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple...
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. The actual values for 12 periods (shown in order) are: (1) 45  (2)...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods...
The actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal places. A. The...
The CEO requested forecasts based on the given historical data.  Put your final answers in the table....
The CEO requested forecasts based on the given historical data.  Put your final answers in the table. Round answers to 3 decimals for each method. Show work for full credit. Period Actual Demand 3 Month Moving Average Moving Average Tracking Signal 3 Month Weighted Average Weighted Average Tracking Signal 1 62 X X X X 2 59 X X X X 3 48 X X X X 4 57 56.33 59.4 5 60 54.66 54.4 6 56 55 52.83 MAD X...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel,...
Instructions The Data contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two...
Can you please answer number 6! Its the only one i need thanks!!! The actual values...
Can you please answer number 6! Its the only one i need thanks!!! The actual values for 12 periods (shown in order) are: (1) 45  (2) 52 (3) 48 (4) 59  (5) 55  (6) 55  (7) 64  (8) 58  (9) 73  (10) 66  (11) 69  (12) 74 Using a 5 period simple moving average, the forecast for period 13 will be: QUESTION 2 Using the 4 period weighted moving average, the forecast for period 13 will be: QUESTION 3 With exponential smoothing, the forecast for period 13 will be:...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create...
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods.  Round all numerical answers to two decimal...
The table below shows the actual demand and the forecasted amounts (where available). Use this table...
The table below shows the actual demand and the forecasted amounts (where available). Use this table to answer questions. Actual Forecast 1 100 - 2 95 - 3 102 - 4 100 105 5 110 111 6 120 115 7 112 115 8 130 125 9 130 128 What is the mean absolute deviation for the forecast? 3.5 2.33 3.89 2.86 What is the mean squared error for the forecast (round to two decimal point)? 89.12 9.94 14.83 4.72 The...
Your manager is trying to determine what forecasting method to use. Based upon the following historical...
Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. - PLEASE show all work in Excel including formulas. a. Calculate the simple three-month moving average forecast for periods 4-12. b. Calculate the weighted three-month moving average using weights of 0.50, 0.30, and 0.20 for periods 4-12. c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F1)...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT