ABC Manufacturing Co. reported the following production costs for the 12 months January through December.

Perform the following:

• 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.

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