Question: B D E F F G G H ] K L M N 0 A 1 Moving Average Forecasting QR S -NM Use the area

B D E F F G G H ] K L M N 0 A 1 Moving Average

B D E F F G G H ] K L M N 0 A 1 Moving Average Forecasting QR S -NM Use the area below to draw a line chart for the three-period moving average. Periods in moving average 3 Demand Forecast Error Error2 Formulas 5 6 7 Time Period 1 2 3 4 5 6 7 8 9 10 11 12 13 84 94 89 90 87 89 87 92 95 96 92 93 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 9 10 11 12 13 14 15 16 17 18 Next period forecast 19 20 21 22 23 24 Periods in moving average 25 #N/A #N/A #N/A #N/A #N/A #/ #N/A #N/A #N/A # #N/A #N/A #N/A #N/A #N/A #N/A #N/A F #NIA #N/A #N/A MSE #N/A Use the area below to draw a line chart for the four-period moving average. 4 8gwupBqsBnBgwangw8 Demand Forecast Error Error2 26 27 28 #N/A Time Period 1 2 3 4 5 6 7 8 8 9 9 10 11 12 13 84 94 89 90 87 89 87 92 95 96 92 93 #NIA #N/A #LIA 30 31 32 33 34 35 36 37 38 39 40 41 42 F F #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #NIA Next period forecast: MSE #N/A Which moving average is best? #N/A 43 44 X Open spreadsheet Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places 2. What is the MSE for the three-period moving average? Round your answer to two decimal places. 3. Choose the correct graph for the three-period moving average forecast -. The correct graph is 100 Three-Period Moving Average Poul Observation Forecast 95 90 A. 85 80 Time Peated 2 5 6 7 8 9 10 11 12 13 14 pasta Theo Three Period Moving Average Forecast 100 Observation Forecast 95 90 B 85 80 Time Pris 3 6 7 & 9 10 11 12 13 14 Three-Period Moving Average Forecast 100 Observation Forecast 95 90 . 85 80 Time Perlod 2 3 4 9 10 11 12 12 13 13 14 100 Observation Forecast Three Period Moving Average Forecast 95 90 D 85 80 Time Period 2 3 4 8 9 10 11 12 13 14 4. What is the forecast for the 13th period based on the four-period moving average? Round your answer to two decimal places. 5. What is the MSE for the four-period moving average? Round your answer to two decimal places 6. Choose the correct graph for the four-period moving average forecast . The correct graph is CV Three-Price Moving Average Pancut 100 Observation Forecast 6. Choose the correct graph for the four-period moving average forecast. The correct graph is Three-Period Moving Average Forecast 100 Observation Forecast 951 90+ A. 85+ 80 Time Period 2 3 4 S 6 7 8 9 10 11 12 13 14 Three-Period Moving Average Forecast 100 Observation Forecast 95 90+ B. 85 80+ Time Period 1 3 4 S 6 7 8 9 10 11 12 13 14 Observation Forecast Three-Period Moving Average Forecast 100 95 90 Matt C. 85 80 Time Period 2 3 4 S 6 7 8 9 10 11 12 13 14 Three-Period Moving Average Forecast 100 Observation Forecast 95 90 ^ D. 85 80+ Time Period 3 4 5 6 7 8 9 10 11 12 13 14 7. Which forecast is the best based on the MSE value

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!

FINAL PROJECT CASE STUDY Part 1 Table 2 Balanced Scorecard Branston Soda Company manufactures soda. In 20x0, Branston earned $12.0 million in operating income and had total capital of $74 million....

Have no idea where to start :( Home Insert Draw Page Layout Formulas Data Review View Shape Format Tell me Share Comments Calibri (Body) ' 14 ab Wrap Text = = = General Insert v Delete v Or 5 IA...

Bus299 Assignment: West Coast Sales (WCS) Database 1. Each employee at WCS has an email address which is always their L..e@wcs.com. Using text functions, put each employee's email address in column...

Please calculate cash to debt ratio for 8 quarters, days sales outstanding for 8 quarters, day's sales inventories ratio for 8 quarters, and the receivable days ratio for eight quarters. PLEASE,...

dAttached is the question, the excel and the template....help me come with a solution for it 100% G2 Wed Sep 23 10 23 E Word File Edit View Insert Format Tools Table Window Help 11:00 PM L...

Step 1: Collect the annual financial report of new jersey resources corporation. Step 2: Please calculate all ratios of that company. Calculate all the ratios in an Excel File. You need to show all...

L SECTION A QUESTION 1 [8] a. What are some of the questions that can be answered with PERT and CPM? (4) b. Describe, in your own words, the meaning of slack and discuss how it can be determined. (4)...

Develop a project AON network and calculate ES-LS, EF-LF for each activity. Identify the critical path(s) and the expected project duration. Will you be able to finish the project on time? What is...

3. Compute the quarterly sales (for four quarters) for each product carried. 4. On the Report sheet, provide the total quantity on hand for products in each Category. Do not use a Pivot Table - I...

Alice gifted stock to her son, Bob, in year 5. Alice bought the stock in year 1 for. The value of the stock on the date of gift was $6,400. Bob sold the stock in 7 for $15,800. What is Bob's...

Xexon7 is a specialist artificial intelligence (Al) development firm that develops algorithms for various on- line services. As part of its client service, it has a small (10-person) help-desk call...

I need help with this general accounting question using the proper accounting approach. If sales are $300,000, variable costs are 60% of sales, and operating income is $40,000, what is the operating...

What is an example of constructive feedback? provide reference