Module 4 Excel Spreadsheet Instructions Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update. For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Data set #1 Inputs: 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 3 A 5 6 7 Activity Cost Data Activity-based Costing Student Name: Section Number: 8 9 Activity. Activity Cost Activity Base 10 Production Setup $44,000.00 Number of setups 11 Procurement $13,500.00 Number of purchase orders 12 Quality Control $97,500.00 Number of Inspections 13 Materials Management $84,000.00 Number of components 14 Total $239,000.00 15 16 Activity Base Usage Data 17 18 Product Type Setups Purchase orders 19 Custom 290 760 Inspections 1,200 Components 500 Unit Volume 2,000 20 Standard 110 140 300 200 2,000 21 Total 400 900 1,500 700 4,000 22 23 24 A) Activity Rates 25 26 Production Setup FORMULA1 Procurement FORMULA2 Answer Section Quality Control Materials Managemen FORMULA3 FORMULA4 27 28 B) Unit Costs 29 30 Activity Activity Base Usage x 31 Production Setup 32 Procurement FORMULA5 FORMULA8 Custom Units Activity Rate FORMULA6 = FORMULA9 33 Quality Control FORMULA11 34 Materials Management FORMULA14 FORMULA12 FORMULA 15 Activity Cost FORMULA7 FORMULA 10 FORMULA13 Activity Base Usage x FORMULA17 Standard Units Activity Rate FORMULA18 = Activity Cost FORMULA19 FORMULA20 FORMULA21 FORMULA22 FORMULA23 FORMULA24 FORMULA25 FORMULA 16 FORMULA26 FORMULA27 FORMULA28 35 Total Unit Cost FORMULA17 FORMULA29 36 Unit Volume FORMULA18 FORMULA30 37 Unit Cost FORMULA 19 FORMULA31 38 39