PLEASE ANSWER ON EXCEL. IF YOU ANSWER ONE, TWO, IT IS. PLEASE I NEED HELP MUCH.

Costa Rico, and El Salvador and have them finalized before final shipment to American distributors in California, Nebraska, and Arkansas. The unit cost ($) of the finalized drones plus tariffs and shipment costs from the European plants directly to the American distributors and supply and demand are as follows: American Distributors European Plants | 7. California 8. Nebraska 9.Arkansas Supply 1. Polland 260 190 230 5100 2. Netherlands 220 210 260 6200 3. Spain 180 220 250 4400 Demand 2000 3600 7700 Alternatively, the unit costs of shipping drone parts to factories for finalizing before transshiping them to the American distributors are as follows: European Plants 4. Honduras 1. Polland 140 2. Netherlands 160 3. Spain 150 Factories 5. Costa Rico 6. El Salvador 120 110 110 90 140 120 Factories 4. Honduras 5. Costa Rico 6. El Salvador American Distributors 7. California 8. Nebraska 9. Arkansas 80 70 90 60 80 110 90 70 120 a) Formulate a model to determine the optimal shipments of drones that will meet demands of the American distributors at the minimum total cost. (15 points) b) Build a spreadsheet model and find the minimum total cost using 'Solver'. (15 points) c) How would the optimum solution change if the demands of California were 2200? (5 points) d) If parts necessary for exactly 50 number of drones need to be shipped from Netherlands to Costa Rica as matter of company policy, how would this affect the optimal solution? (5 points) a) Mathematical Model b) Spreadsheet Model c) Answer: d) Answer: Costa Rico, and El Salvador and have them finalized before final shipment to American distributors in California, Nebraska, and Arkansas. The unit cost ($) of the finalized drones plus tariffs and shipment costs from the European plants directly to the American distributors and supply and demand are as follows: American Distributors European Plants | 7. California 8. Nebraska 9.Arkansas Supply 1. Polland 260 190 230 5100 2. Netherlands 220 210 260 6200 3. Spain 180 220 250 4400 Demand 2000 3600 7700 Alternatively, the unit costs of shipping drone parts to factories for finalizing before transshiping them to the American distributors are as follows: European Plants 4. Honduras 1. Polland 140 2. Netherlands 160 3. Spain 150 Factories 5. Costa Rico 6. El Salvador 120 110 110 90 140 120 Factories 4. Honduras 5. Costa Rico 6. El Salvador American Distributors 7. California 8. Nebraska 9. Arkansas 80 70 90 60 80 110 90 70 120 a) Formulate a model to determine the optimal shipments of drones that will meet demands of the American distributors at the minimum total cost. (15 points) b) Build a spreadsheet model and find the minimum total cost using 'Solver'. (15 points) c) How would the optimum solution change if the demands of California were 2200? (5 points) d) If parts necessary for exactly 50 number of drones need to be shipped from Netherlands to Costa Rica as matter of company policy, how would this affect the optimal solution? (5 points) a) Mathematical Model b) Spreadsheet Model c) Answer: d)