please explain the answers and use the spreadsheet provided

Horten Sporting Goods Corporation makes two types of racquets, tennis and badminton. The company uses the same facility to make both products even though the processes are quite different. The company has recently converted its cost accounting system to activity-based costing. The following are the cost data that Jane Price, the cost accountant, prepared for the third quarter of 2018 (during which Horten made 70,000 tennis racquets and 30,000 badminton racquets). Direct Cost Direct materials Direct labor Tennis Racquet (TR) Badminton Racquet (BR) $28 per unit $20 per unit 34 per unit 28 per unit Category Unit level Batch level Product level Facility level Total Estimated Cost Cost Driver Amount of Cost Driver $ 750,000 250,000 150,000 650,000 $1,800,oo0 Number of inspection hoursTR: 15,000 hours; BR: 10,ooo hours Number of setups Number of TV commercials Number of machine hours TR: 80 setups; BR: 45 setups TR:4; BR:1 TR: 30,000 hours; BR: 35.000 hours Inspectors are paid according to the number of actual hours worked, which is determined by the number of racquets inspected. Engineers who set up equipment for both products are paid monthly salaries. TV commercial fees are paid at the beginning of the quarter. Facility-level cost includes depreciation of all production equipment. Required Round your figures to two decimal points a. Compute the cost per unit for each product. If management wants to price badminton racquets 30 percent above cost, what price should the company set? The market price of tennis racquets has declined substantially because of new competitors entering the market. Management asks you to determine the minimum cost of producing tennis racquets in the short term. Provide that information. c. 5-18 a. Overhead Cost Allocation Under ABC Unit Batch Product Facility Total Cost Pool Cost Drivers Rate Allocation for Tennis Racquet Unit Batch Product Facility Total Weight x Rate Allocation Allocation for Badminton Racquet Unit Batch ProductFacility x Rate Allocation Overhead cost per unit Tennis Raquet Type of Product Total OH Cost # units | -OH Cost punt ! + Badminton Raquet Combined Totals Cost per unit computation: Type of Product Direct Materials +Direct Labor Allocated OH Total Tennis Raquet Badminton Raquet b. The price of the badminton raquet should be determined as follows