M9_1. The World Retailer Company is a apparel retailer with stores worldwide. It manufactures many of its items in four countries in Asia and transports them to four major ports in Japan, China, India, and Korea - where they are loaded into shipping containers for monthly shipment overseas to U.S. distribution. The company requires 100 total containers and the available containers at each port, the monthly leasing cost per container, the shipping time from each port to the United States, and the average percent damage historically incurred at each port are shown in the following table. The company wants the average shipping time per container to be 21 days or less and the average damaged per container to be 3.5 percent or less. (Hint if the average time per container is 24 days what would be total shipping time for all 100 containers?) How many containers should be shipped from each port to minimize costs? SOLUTION: The optimal solution, the value of the cost, should be $25,380. All decision variables should be integers (this is a constraint). Be sure to use standard LP template and include the formulation in your Excel file. Formulation: Formulate this problem by defining decision variables, objective function, and constraints in standard format as specified/demonstrated in videos. Questions: a) Based on your solution, what was the average travel time (in days) for the 100 containers? b) Based on your solution, what was the average percent damage for the 100 containers? c) Which countries did not ship out all their available containers? Why did these countries, as opposed to those who shipped out all their containers, not ship out more containers? Explain. Use the standard LP Template.xlsx provided to you. Solve the problem using Excel Solver, place the formulation and answers to the questions in the appropriate text boxes. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the problem if your Excel submission doesn't solve. If necessary, remove problem constraints so that your Excel file solves. It is better to get partial credit than no credit. Your Excel Solver solution must result in the follow dialog box for full credit for the solution. Note the highlighted text. M9_1. The World Retailer Company is a apparel retailer with stores worldwide. It manufactures many of its items in four countries in Asia and transports them to four major ports in Japan, China, India, and Korea - where they are loaded into shipping containers for monthly shipment overseas to U.S. distribution. The company requires 100 total containers and the available containers at each port, the monthly leasing cost per container, the shipping time from each port to the United States, and the average percent damage historically incurred at each port are shown in the following table. The company wants the average shipping time per container to be 21 days or less and the average damaged per container to be 3.5 percent or less. (Hint if the average time per container is 24 days what would be total shipping time for all 100 containers?) How many containers should be shipped from each port to minimize costs? SOLUTION: The optimal solution, the value of the cost, should be $25,380. All decision variables should be integers (this is a constraint). Be sure to use standard LP template and include the formulation in your Excel file. Formulation: Formulate this problem by defining decision variables, objective function, and constraints in standard format as specified/demonstrated in videos. Questions: a) Based on your solution, what was the average travel time (in days) for the 100 containers? b) Based on your solution, what was the average percent damage for the 100 containers? c) Which countries did not ship out all their available containers? Why did these countries, as opposed to those who shipped out all their containers, not ship out more containers? Explain. Use the standard LP Template.xlsx provided to you. Solve the problem using Excel Solver, place the formulation and answers to the questions in the appropriate text boxes. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the problem if your Excel submission doesn't solve. If necessary, remove problem constraints so that your Excel file solves. It is better to get partial credit than no credit. Your Excel Solver solution must result in the follow dialog box for full credit for the solution. Note the highlighted text