Please answer using excel and please dont use image/screenshoot

Question 5 [15 points] A Tshirt factory produce two type of products: standard and personalized. During the year 2020, the factory produce 1,200 ton standard Tshirt and 200 ton personalized Tshirt. Total indirect cost was $292,000. An analysis of indirect cost reveals the following activies: mm Materials handling Number of requisitions S 100,000 Number of setups 108,000 Quality inspections Number of inspections 84,000 292 one The cost driver volume for each product was as follows: Number of requisitions 1200 Number ofsetups _msllm Required: a. Calculate the indirect activity cost rate for each activity [3 points} b. Allocate the indirect manufacturing overhead cost for the year 2020 to the product using activity based costing {12 points)