Forecasting simulation pearson answers

– (1-1) Forecast the quarterly demand for Year 4 (periods 13, 14, 15, and 16) using mixed static method

– (1-2) Compare MSE, MAD, MAPE, bias, and TS at period 12 between mixed static method and moving average method

– (1-3) Discuss which of the two methods is a better forecasting method for this demand

I've attached an excel sheet and a PDF with the question.Exclude pages 185-187 and 194-199 but include Figure 7-7 in page 194 • Handouts – TECH-492-592_2019Su-0709_Ch7-Figure_71_to_Figure_7-4_and_Figure_7-7_rev.xlsx TECH 492/592 – Manufacturing Distribution Applications • Assignments / Announcements (Due) – Read Ch. 7 – Assignment 5 (Due 7/16, 11:59 PM) • Questions in the next slide • Submit Excel file that contains your analysis • You may modify the provided Excel file for this assignment July 9, 2019 – TECH-492-592_2019Su-0709_Ch7-Figure_7-1_to_Figure_74_and_Figure_7-7_rev.xlsx Load the Analysis ToolPak & Use Regression Assignment 5 • Modified Ch. 7 Exercise 1 “ABC Corporation” Year, Qtr Period Demand • ABC corporation uses mixed static method for t Dt demand forecasting 1,1 1 18,000 • ABC corporation decided to use quarterly 1,2 2 20,000 demand instead of monthly demand for demand forecasting 1,3 3 48,000 • The table in the right lists quarterly demand of 1,4 4 62,000 the most recent three years 2,1 5 20,000 • Questions 2,2 6 21,000 – (1-1) Forecast the quarterly demand for Year 4 (periods 13, 14, 15, and 16) using mixed static method – (1-2) Compare MSE, MAD, MAPE, bias, and TS at period 12 between mixed static method and moving average method – (1-3) Discuss which of the two methods is a better forecasting method for this demand 2,3 2,4 3,1 3,2 3,3 3,4 7 8 9 10 11 12 • Excel 2010, 2013 – Click the File tab, click Options, and then click the Add-Ins category – In the Manage box, select Excel Add-ins and then click Go – In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK – Tip: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it • If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it 60,000 72,000 15,000 23,000 57,000 75,000 – After you load the Analysis ToolPak, click Data Analysis in the Analysis group on the Data tab • Select Regression in the Data Analysis menu and click OK • This opens Regression dialog box • Hint: create/use two error analysis tables (for example, use two “Figure7.7_rev” sheets) – one for mixed static method and one for moving average method Topics: Demand Forecasting in a Supply Chain • The role of forecasting in a supply chain • Components of a forecast and forecasting methods