Question: I need help answering this problem and specifically help with using excel formula to type it in excel Office Update To keep up-to-date with security


Office Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates Xfx Activity Cost Data D Activity based Coating Activity Cost Data Student Name: Section Number Activity Production Setup Procurement Quality Control Materials Management Total $ 5 Activity Cost 44,000.00 13,500.00 97.500.00 114,000.00 229,000.00 Activity Base Number of setups Number of purchase orders Number of inspections Number of components 5 10 11 12 11 14 15 10 17 11 13 30 21 Activity Base Usage Data Setups Product Type Custom Standard Total 290 110 400 Purchase orders 760 140 inspections 1,200 300 1,500 Components 500 200 500 Unit Volume 2.000 2.900 4000 Answer Section A) Activity Rates 23 24 25 26 27 20 Production Setup FORMULA1 Procurement FORMULA2 Quality Control FORMULAS Materials Management FORMULA B) Unit Costs Custom Units Standard Units 30 X Activity Production Setup Procurement Quality Control Materials Management Total Unit Cost Unit Volume Unit Cost Activity Base Usage FORMULAS FORMULAB FORMULA 11 FORMULA14 Activity Rate FORMULAG FORMULAS FORMULA12 FORMULA15 Activity Cest FORMULA7 FORMULA 10 FORMULA13 FORMULA16 FORMULA17 FORMULA10 FORMULA 10 Activity Base Usage ) FORMULA17 FORMULA20 FORMULAS FORMULA20 Activity Rate FORMULA1B FORMULA21 FORMULA24 FORMULA27 Activity Cost FORMULA 19 FORMULA22 FORMULA25 FORMULA20 FORMULA20 FORMULAJO FORMULA31 14 15 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: Activity Cost Data Section Number Activity Production Setup Procurement Quality Control Materials Management Total Activity Cost 44,000.00 13,500.00 97,500.00 34,000.00 230.000.00 Activity Base Number of setups Number of purchase orders Number of inspections Number of componenta 5 S 5 Activity Base Usage Data Setups Product Type Custom Standard Total 200 Purchase orders 760 110 400 140 Inspections 1.200 300 1,500 Components 500 200 700 Unit Volume 2.000 2.000 000 900 Check figure (custom per unit cost): 90.65
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
