• Perform a regression analysis using Excel.
• Using the results from the regression analysis, use the cost equation in the form Y = f + vX.
• Assume that ABC Manufacturing Co. will produce 450 units next month. Calculate total production costs for the month using the regression analysis method.
• Using the data in Table 1, use the high-low method to calculate total production costs. Assume that ABC Manufacturing will produce 400 units.
• Using the data in Table 1, use the scatterplot method to calculate total production costs. Assume that ABC Manufacturing will produce 500 units.

Month Total production Units produced costs $450,000 290,000 490,000 525,000 550,000 325,000 450,000 450,000 525,000 240,000 710,000 500,000 350 220 330 390 410 240 290 320 380 150 450 350 January February March April May June July August September October November December