Problem 3 27 Tucson Machinery Inc Manufactures Numerically Controlled Machines Sell Averag Q34640129

Problem 3-27 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 3.10 QUANTITY (UNITS) 19 25 QUARTER (UNITS)QUARTER 13 19 17 a. Find the equation of a simple linear regression line 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 Last Year This Year c. Forecast sales for next year using the above seasonal factors. (Do not round intermediate calculations. Round your answers to 2 decimal places.) PeriodForecast (Units) Next Year Show transcribed image text