Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $10.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUANTITY (UNITS) QUANTITY (UNITS QUARTER LAST YEAR I II III IV 10 17 23 QUARTER THIS YEAR 1 11 III IV 19 22 26 17 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) Answer is complete and correct. 13.357 1.143 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 Last Year 1 11 III IV Answer is not complete. Trend Forecast Seasonal Factors 14.500 1.003 X 15.643 16.786 17.929 19.072 20.215 21.358 22.501 This Year 1 II HID IV c. Forecast sales for next year using the above seasonal factors. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Forecast (Units) Period 1 Next Year 11 III IV