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