Please fill in the spread sheet 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 Number of inspection hours 250,000 Number of setups 150,000 Number of TV commercials 650,000 Number of machine hours TR: 15,000 hours; BR: 10,ooo hours TR: 80 setups; BR: 45 setups TR:4; BR:1 TR: 30,000 hours; BR: 35,000 hours $1,800,oo0 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. b. 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 Batch Product 1-Facility Total Unit 10 al- Cost Pool Cost Drivers Rate ennis et Product Facility Total Unit Batch Weight x Rate Allocation Allocation for Badminton Racquet Unt Batch ProductFacility x Rate Allocation Overhead cost per unit Tennis Raquet Total OH Cost ! # units | OH Cost punt ! = Type of Product Badminton Raquet Combined Totals Cost per unit computation Direct Materiald Direct Labor I t Alocated OH !=Total Type fProduct Tennis Raquet Badminton Raquet b. The price of the badminton raquet should be determined as follows