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. Solver Results X Solver found a solution. All Constraints and optimality conditions are satisfied Reports Answer Keep Solver Solution Sensitivity Limits Restore Original Values Return to Solver Parameters Dialog Outline ReportsM9_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 US. 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. Japan 34 305 22 3 Chi na 33 245 20 2.5 India 35 265 29 4 Koraa 31 225 19 3 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 525,330. 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 specifiedfdemonstrated 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. DV#1 DV#2 Decision Variables Objective Function Coefficient Constraints: LHS Sign RHS Constraint #1 Constraint #2 Constraint #3 Constraint #4 FORMULATION ANSWERS TO QUESTIONS (do not just put numbers - answers should be complete Decision Variables: sentences) a) Objective Function: b) Constraints