please show formulas

EXHIBIT 2.23 Cost Data Month Units Sold Total Cost January 30,000 $450,000 February 14,000 300,000 March 12,000 150,000 April 25,000 440,000 May 10,000 180,000 June 11,000 240,000 July 20,000 350.000 August 18,000 400,000 September 17.000 360,000 October 16.000 320,000 November 27.000 490,000 December 34.000 540.000 Now, using a blank MS Excel file, create a spreadsheet demonstrating application of the high-low method and regression method of estimating fixed and variable costs as follows: 1. Using the data in Exhibit 2.23 in the textbook, create a spreadsheet for each of the estimation methods: high-low method and regression. Create the data in a chart, show your calculations in words and numbers (meaning don't just show me the numbers, show the formula as well) and be certain to tie in your results to those in the textbook. Compare the results of the two methods for variable cost component and fixed cost component. 2. Now, that you have the hang of it, drop off the month of December from your calculations. Using only the 11 months of data (Jan - Nov), on new worksheet tabs, calculate again using the high-low method and the regression method. 3. Finally, using the results from the 11 month data estimation methods, calculate the expected total cost for the month of December (using the 34,000 units sold), applying the fixed and variable components for each method. How do the calculated expectations compare with the actual data (cost of $540,000). Which method is closer? What are the benefits of each method? What limitations exist with each method