Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $0.5 million each Sales for these NCMs for the past two years were as follows: Use Exhibit 18.10, LAST YEAR QUANTITY QUARTER (UNITS) 1 18 II 20 III 30 IV 19 THIS YEAR QUANTITY QUARTER (UNITS) 1 18 II 26 111 29 IV 23 a. Find the equation of a simple linear regression fine using Excel (Round your answers to 3 decimal places.) b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round Intermediate calculations, Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year 1 11 IV This Year 1 11 III IV c. Forecast sales for next year using the above seasonal factors. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Period Forecast (Units) Next Year 11 111 IV Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $0.5 million each Sales for these NCMs for the past two years were as follows: Use Exhibit 18.10, LAST YEAR QUANTITY QUARTER (UNITS) 1 18 II 20 III 30 IV 19 THIS YEAR QUANTITY QUARTER (UNITS) 1 18 II 26 111 29 IV 23 a. Find the equation of a simple linear regression fine using Excel (Round your answers to 3 decimal places.) b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round Intermediate calculations, Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year 1 11 IV This Year 1 11 III IV c. Forecast sales for next year using the above seasonal factors. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Period Forecast (Units) Next Year 11 111 IV