please help me answer the A and B question using excel

LO 3. 4 II I 1126 Windows R Us manufactures two product ranges: the standard range and the special range. During July, 300 standard windows and 50 specialised windows were manufactured and indirect production costs of $73 000 were incurred. An analysis of indirect costs reveals the following activities: Activity Cost driver Total Cost Materials handling Number of requisitions $25 000 Machine set-ups Number of setups 27 000 Quality inspections Number of inspections E Total $73 000 The cost driver volune for each product was as follows b. Cost driver Specialised Standard Total 3. Specialized Standard Mummi- of requisitions m 600 1 000 Material handling = 25,000/1,000 25 per requisitions 10.000 15.000 N m f t 150 300 450 Machine set up = 27,000/450 = 60 per set ups 9000 18.000 U 9'0 59 4195 Number of inspections = 21,000/500 35 per inspection 7000 14.000. Number of inspections 200 400 600 26300 47_ooo i 73.000 . per unit 520 157 Required a. Calculate the indirect activity cost rate for each activity. b. Allocate the indirect manufacturing overhead costs for July to the products using the activity