Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please please answerr all please urgent work!! please E. Two Ports and Three Cities A company imports goods at two ports: Prince Rupert and Vancouver.
please please answerr all please urgent work!! please
E. Two Ports and Three Cities A company imports goods at two ports: Prince Rupert and Vancouver. Shipments of one product are made to customers in Burnaby, Kelowna and Smithers. For the next planning period, the supplies at each port, customer demand, and per-unit shipping costs per case from each port to each customer are as follows: We want to minimize the total cost while satisfying the demand and supply requirements. Here is the sensitivity report associated with finding the optimal solution using Excel Solver. The target cell of the Excel model, which contains the optimal value of the total profit, is 410.00 dollars. For sensitivity analysis questions, please consider each change in isolation. If there is not enough information in the sensitivity report to answer the question, type 9999 as the answer. Question 38 2 pts Suppose we change the per-unit cost from Price Rupert to Kelowna such that it becomes 5. What will happen to the optimal solution (red cells) and the optimal value (green cell)? The optimal solution does not change and the optimal value changes The optimat solution changes and the optimal value does not change. The optimal solution changes and the optimal value changes. The optimal solution does not change and the optimal value does not change. Question 39 2 pts Suppose we change the per-unit cost from Vancouver to Smithers such that it becomes 29 . What is the new value of the target cell? Suppose we change the per-unit cost from Price Rupert to Burnaby such that it becomes 14. What is the new value of the target cell? Question 41 2 pts Suppose Prince Rupert has 37 units available for shipping instead of 30 . What is the new value of the target cell? Question 42 2pts Suppose that we can no longer ship from Prince Rupert to Kelowna. Select all valid statements. The LP is infeasible. The amount shipped from Vancouver to Kelowna increases. The LP is unbounded. The total amount shipped from Vancouver is more than 20 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started