1. Review and answer the following questions on page 354 in Chapter 9 of your textbook: a. use forecast methodologies to predict unit sales of mowers and tractors in each marketing region for the month of January 2019. b. use forecast methodologies to predict total sales of mowers and tractors in each marketing region for the month of January 2019. c. use forecast methodologies to predict unit production costs for mowers and tractors for the month of January 2019. 2. Summarize and write a two (2) page formal report related to your findings. Hint: We strongly suggest that Analytic Solver be used, especially for Holt-Winters models. This provides the ability to find the best model parameters of Alpha, Beta, and Gamma. Chapter Nine Instructions: CASE: PERFORMANCE LAWN EQUIPMENT An important part of planning manufacturing capac- future increases in production costs. Using the data in ity is baving a good forecast of sales. Elizabeth Burke is the Performance Lewn Equipment Database, develop interested in forecasting sales of mowers and tractors in forecasting models for these data and prepare a report of each marketing region as well as industry sales to assess. your results with appropriate charts and output from Excel. future changes in market share, She also wants to forecast Open recovered workbooks? Your recent changes were saved. Do you Open recovered workbooks? Your recent changes were save Open recovered workbooks? Your recent changes were saved. Do you wan A1. A A fx Industry Mower Total Sales \begin{tabular}{l|llllllll} A & B & C & D & D & B & F & H \end{tabular} Industryl Mower Total Sales 4 b Industry Mower Total Sales Industry Tractor Total Saion Ready Tgaccessiblity= Bood to 90 Home Insert Draw Pagelayout Formulas Data , Revie Open recovered workbooks? Your recent changes were saved. Do you wan A1 ^fx Industry Mower Total Sales 4 lisdustry Mower Total Salos Ready 49 Arcessibility Good ta 90 Industry Tractor Total Sales Home Insert Draw Page Layout Formulas Open recovered workbooks? Your recent changes were saved. Do you want A1 7 A x Industry Tractor TotalSales Industry Tractor Totar Sales Home Insert Draw Page Layout Formulas Data Review Open recovered workbooks? Your recent changes were saved. Do you want to c A1 Ffx Industry Tractor Total Sales 4 b induatry Mower Total Sales Industry Tractor Total Sales 1. Review and answer the following questions on page 354 in Chapter 9 of your textbook: a. use forecast methodologies to predict unit sales of mowers and tractors in each marketing region for the month of January 2019. b. use forecast methodologies to predict total sales of mowers and tractors in each marketing region for the month of January 2019. c. use forecast methodologies to predict unit production costs for mowers and tractors for the month of January 2019. 2. Summarize and write a two (2) page formal report related to your findings. Hint: We strongly suggest that Analytic Solver be used, especially for Holt-Winters models. This provides the ability to find the best model parameters of Alpha, Beta, and Gamma. Chapter Nine Instructions: CASE: PERFORMANCE LAWN EQUIPMENT An important part of planning manufacturing capac- future increases in production costs. Using the data in ity is baving a good forecast of sales. Elizabeth Burke is the Performance Lewn Equipment Database, develop interested in forecasting sales of mowers and tractors in forecasting models for these data and prepare a report of each marketing region as well as industry sales to assess. your results with appropriate charts and output from Excel. future changes in market share, She also wants to forecast Open recovered workbooks? Your recent changes were saved. Do you Open recovered workbooks? Your recent changes were save Open recovered workbooks? Your recent changes were saved. Do you wan A1. A A fx Industry Mower Total Sales \begin{tabular}{l|llllllll} A & B & C & D & D & B & F & H \end{tabular} Industryl Mower Total Sales 4 b Industry Mower Total Sales Industry Tractor Total Saion Ready Tgaccessiblity= Bood to 90 Home Insert Draw Pagelayout Formulas Data , Revie Open recovered workbooks? Your recent changes were saved. Do you wan A1 ^fx Industry Mower Total Sales 4 lisdustry Mower Total Salos Ready 49 Arcessibility Good ta 90 Industry Tractor Total Sales Home Insert Draw Page Layout Formulas Open recovered workbooks? Your recent changes were saved. Do you want A1 7 A x Industry Tractor TotalSales Industry Tractor Totar Sales Home Insert Draw Page Layout Formulas Data Review Open recovered workbooks? Your recent changes were saved. Do you want to c A1 Ffx Industry Tractor Total Sales 4 b induatry Mower Total Sales Industry Tractor Total Sales
