Tucson Mad-linery, Inc.. manufactures numerically controlled machines. which sell for an average price of $0.5 million each. Sales for these NCMs for...

Hey can you help

pleaseda aD d a fAD

DHUHDKN DN d i sadnd; d 'ad

Tucson Mad-linery, 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 THIS YEARoummv oumnwQUAR'I'ER (UNITS) QUARTER (UNITS)I 16 I 21u 22 u 2.3In so In 32w 20 IV 16 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 declmel places.) Y= 11571 + 1.1?9 I' b. Compute herd and seasonal factor from a linear regression line obtained with Excel. (Do not round lnterrnedlate celculatlone. Round your answers to 3 declmal places.) Period Trend FM Seward Fm Last Year I 12350 II III IVThis Year I II III IV c. Forecast sales for next year using the above seasonal factors. (Do not round Intermsdlete calculetlone. Round your answers to 2 declmal places.) Plbd Fuawut (Url'ls)Next Year III IIIm