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. LAST YEAR QUANTITY QUARTER (UNITS) THIS YEAR QUANTITY QUARTER (UNITS) + exhibit_3.10.jpg (601x573) x + CD https://ezte-cf-mediam... Crime Reports Login - Ubiquiti Ace Home - Nest U Business O Blackboard Leam 28 18 16 IV Computing a Seasonal Factor from the Actual Data and Trend Line 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 oblained with Excel. (Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year This Year - 2 years ago - last year - ACTUAL AMOUNT PEON TREND FOLATION FIT,= 176.1 + 52.3t RATOR ACTUAL + TREND SEASONAL FACTOR (AVERAGE OF SAMS QUARTOS EN BOTH YEARS) QUARTE 2 years ago c. Forecast sales for next year using the above seasonal factors. (Round your answers to 2 decimal places.) 2783 2806 200 220 3851 Period Forecast (Units) 125 11079 110.70 Next Year last year 2ND 489.6 5419 IV 700 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. LAST YEAR QUANTITY QUARTER (UNITS) THIS YEAR QUANTITY QUARTER (UNITS) + exhibit_3.10.jpg (601x573) x + CD https://ezte-cf-mediam... Crime Reports Login - Ubiquiti Ace Home - Nest U Business O Blackboard Leam 28 18 16 IV Computing a Seasonal Factor from the Actual Data and Trend Line 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 oblained with Excel. (Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year This Year - 2 years ago - last year - ACTUAL AMOUNT PEON TREND FOLATION FIT,= 176.1 + 52.3t RATOR ACTUAL + TREND SEASONAL FACTOR (AVERAGE OF SAMS QUARTOS EN BOTH YEARS) QUARTE 2 years ago c. Forecast sales for next year using the above seasonal factors. (Round your answers to 2 decimal places.) 2783 2806 200 220 3851 Period Forecast (Units) 125 11079 110.70 Next Year last year 2ND 489.6 5419 IV 700