determine the total costs by vendor. write a formula in cell c16 that can be copied down and across cells c16:g18 to determine how much of the costs of this deparments equipment are paid to this vendor. for example in cell c16 would be the costs for the engineering groups system purchased from microcenter.

Budget 2000 Vendor Engineering stomer Serv MarketingFinance Microcenter259 R&D Monitor 659 259 299 ComputerDell Software Jump Drive Printer Addi Memory TOTAL CompUSA S Microcenter Microcenter $ Dell 669 S859 1299S789S.409 59 299 299 449449 239 $ 499 59 79 S 99S 55 1,250 129 ls 1.634 1.363 3.441s 1 945 ls 1,945 S 2,066 overlunder budget 366.00 S 63700 (1447.00) S 55.00 (6600) 2 How many can afford? 13 reater in % is R&D'sco 26% 15 totals Microcenter 17 Dell 18 CompUSA