please help me do my homework

Part 1: Make or Buy Decisions Mobility Partners makes wheelchairs and other assistive devices. For years it has made the rear wheel assembly for its wheelchairs. A local bicycle manufacturing firm, Trailblazers, Inc., offered to sell these rear wheel assemblies to Mobility. If Mobility makes the assembly, its cost per rear wheel assembly is as follows (based on annual production of 2,000 units): $ Direct materials Direct labor Variable overhead Fixed overhead Total 30 52 21 52 155 $ Trailblazers has offered to sell the assembly to Mobility for $110 each. The total order would amount to 2,000 rear wheel assemblies per year, which Mobility's management will buy instead of make if Mobility can save at least $20,000 per year. Accepting Trailblazers's offer would eliminate annual fixed overhead of $41,100. Required: a. Using Excel, prepare a schedule that shows the total differential costs. Indicate if the differential cost is higher, lower or no effect under the assumption that Status Quo is the base. b. Should Mobility make rear wheel assemblies or buy them from Trailblazers? Why? Be sure to provide a complete justification for your decision. Part 2: Classic Company is interested in establishing the relationship between utility costs and machine hours. Data has been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Month January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August 2021 September 2021 October 2021 November 2021 December 2021 January 2022 February 2022 March 2022 Machine Electricity Hours Costs 2,470 16,200 5,330 29,700 4,810 31,200 3,250 22,080 5,460 33,300 3,770 25,200 4,940 33,900 4,030 27,600 6,110 37,200 2.600 18,600 4,550 27,300 4,290 26.400 6,450 38,900 3,175 26,500 2,785 18.500 Required: a. Using Excel, perform a regression analysis on the above data and generate a summary output. (Follow the instructions in your text book on pages 197-202) b. What is the equation for utility costs using the regression analysis? c. Prepare an estimate of utility costs for a month when 3,000 machine hours are worked