This is an excel solver problem

1. SMM is a Saskatoon based producer of emergency vehicles. It equips the produced vehicles with medical gears based on the received orders. To equip the vehicles, SMM requires eight standard medical devices. Due to high possibility of miscommunication with the suppliers, SMM wants to purchase all these devices at once. SMM has received bids from six suppliers; the offered prices are as follows. The prices are in dollars, and not all the manufacturers produce all the devices. For instance, supplier 1 does not produce device 1; the offered price of this supplier for one unit of device 2 is $8.20. Furthermore, the suppliers have assured SMM that they can provide as many devices as SMM needs if they receive the contract (given that they have bid on that device). 7 8 | 1 L 6 3.9 3.3 4.4 I Devices 1 2 3 4 5 L 8.2 7.8 5.4 1.8 8.2 6.3 4.8 L 8 5 6.8 7.2 | 6.4 | | 3.9 | 6.4 7 | 5.8 7.5 4.5 5.6 2000 / 1500 | 4000 | 3000 1000 - 3 4.9 5.6 / 3.6 Suppliers 6.7 42 | 5 6 | Amount Required | | 2.8 6 19001 200 3 4.2 1350 | a. Determine which suppliers should receive orders if SMM wants to minimize its purchasing costs. (10 points) b. Determine which suppliers should receive orders if SMM's goal is minimizing the purchasing costs. In addition, SMM wants to give each supplier at least one contract, but is not willing to sign with any of the suppliers more than two contracts. (20 points) 1. SMM is a Saskatoon based producer of emergency vehicles. It equips the produced vehicles with medical gears based on the received orders. To equip the vehicles, SMM requires eight standard medical devices. Due to high possibility of miscommunication with the suppliers, SMM wants to purchase all these devices at once. SMM has received bids from six suppliers; the offered prices are as follows. The prices are in dollars, and not all the manufacturers produce all the devices. For instance, supplier 1 does not produce device 1; the offered price of this supplier for one unit of device 2 is $8.20. Furthermore, the suppliers have assured SMM that they can provide as many devices as SMM needs if they receive the contract (given that they have bid on that device). 7 8 | 1 L 6 3.9 3.3 4.4 I Devices 1 2 3 4 5 L 8.2 7.8 5.4 1.8 8.2 6.3 4.8 L 8 5 6.8 7.2 | 6.4 | | 3.9 | 6.4 7 | 5.8 7.5 4.5 5.6 2000 / 1500 | 4000 | 3000 1000 - 3 4.9 5.6 / 3.6 Suppliers 6.7 42 | 5 6 | Amount Required | | 2.8 6 19001 200 3 4.2 1350 | a. Determine which suppliers should receive orders if SMM wants to minimize its purchasing costs. (10 points) b. Determine which suppliers should receive orders if SMM's goal is minimizing the purchasing costs. In addition, SMM wants to give each supplier at least one contract, but is not willing to sign with any of the suppliers more than two contracts. (20 points)