Do Homework - Bridgette Bradley - Google Chrome Secure | https://www.mathxl.com/

Question

Do Homework - Bridgette Bradley - Google Chrome Secure | https://www.mathxl.com/Student/PlayerHomework.aspx?homeworkId-460020838&questionid;=1&flushed-false;&cld-4787172;&centerwin;=yes Operations Management- Online Bridgette Bradley | 1/27/18 4:38 PM Homework: Chapter 4 Score: 0 of 1 pt Problem 4.2b 3 of 8 (1 complete) HW Score: 8.33%, 0.67 of 8 pts Question Help The following table shows the actual demand observed over the last 11 years Demand Year 1 2 3 4 5 6 7 89 10 11 14 Demand 8 10 4 10 13 9 12 13 9 9 8 The plotted graph for actual demand shows CXA. cycles O B. a trend D. randomness C. seasonality Using the 3-year moving average, the following forecast for periods 4 through 12 has been developed 4 4 Year Forecast 7.3 8.0 9.0 10.7 11.3 Year Forecast 11.3 11.3 10.3 8.7 2 10 12 4 9 10 11 12 Using the point drawing tool, plot the forecasts for years 8 through 12 (based on the 3-year moving average in the table above) Year Red Dots Forecasts for 3-year Moving Average for Years 4-7 Note: Carefully follow the instructions above and only draw the required objects. Use the arrow keys to precisely move a selected point. Click the graph, choose a tool in the palette and follow the instructions to create your graph All parts showing Clear All Check Answer

Explanation / Answer

Excel formualtion

Please rate

year demand forecast 1 8 2 10 3 4 4 10 7.333333 5 13 8 6 9 9 7 12 10.66667 8 13 11.33333 9 9 11.33333 10 9 11.33333 11 8 10.33333 8.666667

Excel formualtion

year demand forecast 1 8 =1+A2 10 =1+A3 4 =1+A4 10 =AVERAGE(B2:B4) =1+A5 13 =AVERAGE(B3:B5) =1+A6 9 =AVERAGE(B4:B6) =1+A7 12 =AVERAGE(B5:B7) =1+A8 13 =AVERAGE(B6:B8) =1+A9 9 =AVERAGE(B7:B9) =1+A10 9 =AVERAGE(B8:B10) =1+A11 8 =AVERAGE(B9:B11) =AVERAGE(B10:B12)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.