Determine the total costs by vendor - Write a formula in cell C16, that can be copied down and across into cells C16:918, to determine how much of the costs of this department's equipment are paid to this vendor. For example in cell C16 would be the costs for the Engineering Group's system purchased from Microcenter. B G H R&D YOU AWN 299 1,409 . 59 299 2.066 $ (66) Customer Engineering 2 Finance Service Vendor Marketing 3 Monitor Microcenter $ 259 $ 659 $ 259 $ 4 Computer Dell $ 659 $ 859 $ 1,299 $ 789 $ 5 Software CompUSA $ 449 $ 449 $ 239 $ 499 Jump Drive Microcenter $ 59 $ 99 $ 7 Printer Microcenter $ 79 $ 55 $ 1,250 8 Addi Memory Dell $ 129 $ 299 $ 9 TOTAL $ 1.634 1,363 $ 3,447 $ 1,945 S 10 11 over/under budget s 366 $ 637 $ (1.447) $ 55 $ How many can 12 afford? 3 How much greater in % is R&D's cost vs. 13 Engr's 26.4% 14 15 totals: 16 Microcenter 17 Dell 18 CompUSA 19 20