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): Trailblazers has offered to sell the absembly 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 feast $20,000 per year Accepting Traiblazers'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. 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: 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