Day 29

Task:

You handle vendor selection for a manufacturing company's procurement team. Four vendors have been scored out of 10 on quality, price and delivery, and the weight each criterion carries toward the final decision sits in row 2 — 40% quality, 35% price, 25% delivery. Work out each vendor's overall weighted score in column E, in one formula that pairs each vendor's three scores with the matching weights.