Use solver to answer question

Question 1 Part A

H55 is a Saskatoon based producer of emergency.I vehicles. It equips the produced vehicles with medical gears based on the received orders. To equip the vehicles. H55 requires eight standard medical devices. Due to high possibility' of miscommunication with the suppliers, H55 wants to purchase all these devices at once. H55 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 $13.20. Furthermore, the suppliers have assured H55 that thev can provide as manv devices as H55 needs if thev receive the contract {given that they have bid on that device]. Determine the optimum cost if H55 wants to minimize the purchasing costs. Mention the optimum cost here. Devices 2 4 5 6 7 DO 18.20 7.80 5.40 3.90 2.80 8.20 6.30 3.30 4.90 Suppliers 4.80 4.40 5.60 3.60 8.00 5.00 6.80 6.70 4.20 7.20 6.40 3.90 6.40 5.80 3.00 7.00 5.80 7.50 4.50 5.60 6.00 7.20 Demand 4,000 3,500 4.000 3.000 1,900 1.900 200 1.350In the H55 question, determine the optimum cost if HSS's goal is minimizing the purchasing costs. In addition+ H55 wants to give each supplier at least one contract. but is not willing to sign with anv of the suppliers more than two contracts. Hint: vou will either give the entire contract for a specic device to a supplier or select a different supplier. In other words+ partial contracts are not allowed. Mention the optimum cost here.