Please show formulas used for each asnwer

1 Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0. 2 4 5 Activity-based Costing 6 Student Name: Section Number: 7 Activity Cost Data 8 9 10 11 12 Activity Production Setup Procurement Quality Control Materials Management Total Activity Cost 44,000.00 $ 13,500.00 $ 97,500.00 $ 84,000.00 $ 239,000.00 Activity Base Number of setups Number of purchase orders Number of Inspections Number of components 13 14 15 16 Activity Base Usage Data 17 18 19 Product Type Custom Standard Total Setups 290 110 400 Purchase orders 760 140 900 Inspections 1,200 300 1,500 Components 500 200 700 Unit Volume 2,000 2,000 4,000 20 21 22 23 Answer Section 24 A) Activity Rates 25 Production Setup FORMULA1 Procurement FORMULA2 Quality Control Materials Management FORMULA3 FORMULA4 26 27 28 29 B) Unit Costs Custom Units Standard Units = 30 Activity 31 Production Setup 32 Procurement 33 Quality Control Sheet1 Activity Base Usage FORMULA5 FORMULAS FORMULA11 Activity Rate FORMULA6 FORMULAS FORMULA12 Activity Cost FORMULA7 FORMULA10 FORMULA13 Activity Base Usage FORMULA17 FORMULA20 FORMULA23 Activity Rate FORMULA18 FORMULA21 FORMULA24 Activity Cost FORMULA19 FORMULA22 FORMULA25 + 22 Answer Section A) Activity Rates 23 24 25 26 27 28 Production Setup FORMULA1 Procurement FORMULA2 Quality Control Materials Management FORMULA3 FORMULA4 B) Unit Costs 29 Custom Units Standard Units X = 30 Activity 31 Production Setup 32 Procurement 33 Quality Control 34 Materials Management 35 Total Unit Cost 36 Unit Volume 37 Unit Cost Activity Base Usage FORMULA5 FORMULAS FORMULA11 FORMULA14 Activity Rate FORMULA6 FORMULAS FORMULA12 FORMULA15 Activity Cost FORMULA7 FORMULA10 FORMULA13 FORMULA16 FORMULA17 FORMULA18 FORMULA19 Activity Base Usage FORMULA17 FORMULA20 FORMULA23 FORMULA26 Activity Rate FORMULA18 FORMULA21 FORMULA24 FORMULA27 Activity Cost FORMULA19 FORMULA22 FORMULA25 FORMULA28 FORMULA29 FORMULA30 FORMULA31 38 39 40 41 42 43 44 45 46 47 48 49 50