The corporation may decide to only fund either the Engineering Group or the R&D (Research and Development) Group. Originally their decision was to fund the Engineering Group only but now you hear that they might decide to fund R&D instead. You just know someone will ask you who's cost more and by how much on a percentage basis. Thus, in Cell B13, which formula would show the percent difference in total costs between the original choice - Engineering, and the alternative option - R&D's system

Transcribed Image Text:

File Dv C12 1 Budget 234 5 6 7 8 9 10 11 12/ 13 14 Home < A Insert Arial x fx Monitor Computer Software Jump Drive Printer Addl Memory TOTAL 15 16 Microcenter 17 Dell 18 CompUSA 19 20 21 22 23 24 25 26 37 over/under budget How many can afford? totals: How much greater in % is R&D's cost vs. Engr'g Draw B Dell $ Page Layout Vendor Microcenter $ $ > = computer costs + 10 2000 Dell CompUSA Microcenter $ Microcenter $ $ Calculation Mode: Automatic Workbook Statistics 3 22 Engineering LA LA LA LA LA LA $ $ B $ C Formulas H Av 259 659 $ 449 $ 59 79 $ 129 1,634 $ 366.00 $ D Customer Service Data $ 859 $ 449 $ Marketing 55 $ E 1,363 $ Review 659 $ 1,299 $ 239 $ $ 1,250 $ 3,447 $ 637.00 $ (1,447.00) $ Accessibility Reminder Evab F Finance 299 $ 1,945 $ G 55.00 $ General 259 $ 299 789 $ 1,409 499 99 $ R&D 59 299 2,066 (66.00) H View I Automate .0 .00 -.0 .00 J Help K File Dv C12 1 Budget 234 5 6 7 8 9 10 11 12/ 13 14 Home < A Insert Arial x fx Monitor Computer Software Jump Drive Printer Addl Memory TOTAL 15 16 Microcenter 17 Dell 18 CompUSA 19 20 21 22 23 24 25 26 37 over/under budget How many can afford? totals: How much greater in % is R&D's cost vs. Engr'g Draw B Dell $ Page Layout Vendor Microcenter $ $ > = computer costs + 10 2000 Dell CompUSA Microcenter $ Microcenter $ $ Calculation Mode: Automatic Workbook Statistics 3 22 Engineering LA LA LA LA LA LA $ $ B $ C Formulas H Av 259 659 $ 449 $ 59 79 $ 129 1,634 $ 366.00 $ D Customer Service Data $ 859 $ 449 $ Marketing 55 $ E 1,363 $ Review 659 $ 1,299 $ 239 $ $ 1,250 $ 3,447 $ 637.00 $ (1,447.00) $ Accessibility Reminder Evab F Finance 299 $ 1,945 $ G 55.00 $ General 259 $ 299 789 $ 1,409 499 99 $ R&D 59 299 2,066 (66.00) H View I Automate .0 .00 -.0 .00 J Help K