Eron formulas met be und Phase be sure to tubint your fin as an Excel file. Any submusikens in numbers format, witte com a Activity-based Coating 7 Activity Coat Data Student Name: Section Number: Activity Cost 44,000.00 $ 13,500.00 3 97,500.00 5 84,000.00 5 239,000.00 Activity Base Number of setups Number of purchase orders Number of inspections Number of components Activity Base Usage Data Activity 10 Production Setup 11 Procurement 12 Quality Control 13 Materials Management 14 Total 15 16 17 18 Product Type 19 Custom 20 Standard 21 Total 22 23 24A) Activity Rates 25 26 27 20 D) Unit Costs 29 Inspections 1.200 Setup 290 110 400 Purchase orders 760 140 900 Components 500 200 700 Unit Volume 2,000 2000 4.000 300 1.500 Answer Section Production Setup FORMULA Procurement FORMULAZ Quality Control FORMULAI Materials Management FORMULA Custom Units Standard Units * Activity Base Usage FORMULAS FORMULAR FORMULA11 FORMULA 14 30 Activity 31 Production Setup Procurement 33 Quality Control 34 Materials Management 35 Total Unit Cost Unit Volume 32 Unit Cost 16 19 Activity Rate FORMULA FORMAS FORMULA 12 FORMULA 15 Activity Cost FORMULAT FORMULA 10 PORMULAI FORMULATO FORMULA17 FORMULAR FORMULA 19 Activity Base Usage FORMULA 17 FORMULA20 FORMULAS FORMULAR Activity Rate FORMULAR FORMULA 1 PORMULA FORMULARY Activity Cost FORMULA19 FORMULA22 FORMULA FORMULA PORMULA20 FORMASO FORMULASI 1 Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in numbers 2 3 Activity-based Coating Activity Coat Data Student Name: Section Number: 5 6 7 8 9 10 11 12 13 14 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 $ $ $ Activity Base Usage Data 15 16 17 18 19 20 21 Setups Product Type Custom Standard Total 290 110 400 Purchase orders 760 140 900 Inspections 1,200 300 1,500 Components 500 200 700 Answer Section A) Activity Rates 22 23 24 25 26 27 28 29 Production Setup FORMULA1 Procurement FORMULA2 Quality Control FORMULAS Materials Management FORMULA4 B) Unit Costs Custom Units X 30 33 32 33 34 35 36 37 38 39 Activity Production Setup Procurement Quality Control Materials Management Total Unit Cost Unit Volume Unit Cost Activity Base Usage FORMULAS FORMULAS FORMULA 11 FORMULA14 Activity Rate FORMULA6 FORMULAS FORMULA12 FORMULA15 Activity Cost FORMULA7 FORMULA10 FORMULA13 FORMULA16 FORMULA17 FORMULA18 FORMULA19 Activity Base Usage FORMULA17 FORMULA20 FORMULA23 FORMULA26 41 52 E F G H K L M be used. Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0. Activity-based Costing ata Student Name: Section Number: Cost 4,000.00 3,500.00 7,500.00 5,000.00 9,000.00 Activity Base Number of setups Number of purchase orders Number of Inspections Number of components Activity Base Usage Data ups 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 Answer Section Lion Setup MULA1 Procurement FORMULA2 Quality Control FORMULA3 Materials Management FORMULA Custom Units Standard Units X X a ity Base sage MULAS MULAB MULA11 MULA14 Activity Rate FORMULAG FORMULA9 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
