Please formulate a model first and solve it using Excel Solver. Thanks!

Problem 3 (35 points) A typhoon just hit the Philippines with devastating consequences. You work for a local disaster relief organization and you need to act fast to save lives. The following are the immediate needs of the different affected islands (all measured in tons). If you bring more supplies than listed below, the extra supplies will not help save lives. Bohol Cebu Leyte Food 14 5 15 Drinking Water 12 10 5 Medical Equipment 7 6 8 You have 6 boats at your disposal in the island of Luzon, which was not affected by the typhoon. Each boat can transport 10 tons of supplies. You have plenty of food, drinking water and medical equipment in Luzon, so there is no constraint regarding what you can load on the boats. A ton of food can save 100 lives. A ton of drinking water can save 200 lives. A ton of medical equipment can save 500 lives. a) (15 points) You are planning to send 2 boats to Bohol, 2 boats to Cebu and 2 boats to Leyte. What supplies should you load on each boat in order to maximize the number of lives saved? Formulate a linear optimization problem to answer this question. b) (20 points) Consider now the general problem. You can decide how many boats to send to each island and what supplies to load on each of those boats. Formulate a linear integer optimization to decide how many boats to send to each island and what supplies to load onto the boats in order to maximize the number of lives saved