Question: You are given the following model formulation for a trans-shipment problem. We have Plants, Warehouses, and Customers Decision Variables: Units shipped from Plant 1 (1)

You are given the following model formulation for a trans-shipment problem. We have Plants, Warehouses, and Customers

You are given the following model formulation for

Decision Variables: Units shipped from Plant 1 (1) to I! Plant 2 (2) Plant 3 (3) - !! HI I! = IT X15 = X16= X25 = X26 = X35 = X36 X38 X45 = X46= X57 = X58 = X59= X67 = X68 X69 - Plant 4 (4) Warehouse 1 (5) Warehouse 2 (6) Warehouse 1 (5) Warehouse 2 (6) Warehouse 1 (5) Warehouse 2 (6) Customer 2 (8) Warehouse 1 (5) Warehouse 2 (6) Customer 1 (7) Customer 2 (8) Customer 3 (9) Customer 1 (7) Customer 2 (8) Customer 3 (9) 11 Warehouse 1 (5) - Warehouse 2 (6) I Objective Function: Min: 8X15 + 10X16+ 12x25 + 13X26 + 14X35 + 15X36 + 12X38 + 12X45 + 8X46 + 12X57 + 10X58 + 8X59 + 12X67 + 13X68 + 15X69 Subject to: C1 (Plant 1): 1X15 + 1X16 0 Part a) What is the minimum cost shipping plan? Label your answer in your Excel spreadsheet as "Total Shipping Cost." Part b (5 Points) Use the Simplified Sensitivity Analysis handout and show your work to the right of your original spreadsheet as shown in all of the Chapter 3 Sensitivity Analysis examples. What will the objective function equal if the coefficient of X46 is now 7.80? Note: If all you do is revise your original model and re-run it, you will receive 0 points. You must perform sensitivity analysis in your spreadsheet. Answer the following questions in your spreadsheet: How much is the Decrease? What is the Allowable Decrease? Is the Increase within the Allowable Decrease? What is the new objective function value? Parte (5 Points) Use the Simplified Sensitivity Analysis handout and show your work to the right of your original spreadsheet as shown in all of the Chapter 3 Sensitivity Analysis examples. What will the objective function equal if the coefficient of right-hand-side of Constraint 9 is now 655? Note: If all you do is revise your original model and re-run it, you will receive 0 points. You must perform sensitivity analysis in your spreadsheet. Answer the following questions in your spreadsheet: How much is the Decrease? What is the Allowable Decrease? Is the Decrease within the Allowable Decrease? What is the new objective function value

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Why is there no diffusion term in the mass continuity equation? Suppose that a fluid contains a binary mixture of dry air and water vapour. Show that the change in mass of a parcel of air due to the...

You are given the following model formulation for a trans-shipment problem. We have Plants, Warehouses, and Customers. Decision Variables: X15 = Units shipped from Plant 1 (1) to Warehouse 1 (5) X16...

You are given the following model formulation for a trans-shipment problem. We have Plants, Warehouses, and Customers Decision Variables: Units shipped from Plant 1 (1) to I! Plant 2 (2) Plant 3 (3)...

thank you! You are given the following model formulation for a trans-shipment problem. We have Plants, Warehouses, and Customers. Decision Variables: Units shipped from Plant 1 (1) to PF RP AF Plant...

3. a) At LMU Engine Corporation, production employees work ten hours per day, four consecutive days per week. Each day of the week, at least the following number of employees must be working: Monday...

Problem 2 ( 2 5 ) Given: A highway network with route capacities ( vehicles ? h r ) is illustrated in the figure below. ( All arcs are two - way, Capacity shown is veh / hr ) Find: Maximum traffic...

. Problem statement: For an existing supply network, identify the market assignment for each facility that minimizes the total cost. Wild D1 = 50,000 C1 = 200,000 $3 wil D2 = 100,000 $1 C2 = 60,000...

Problem 1 : ( 2 5 ) Problem 2 ( 2 5 ) Given: A highway network with route capacities ( vehicles ? h r ) is illustrated in the figure below. ( All arcs are two - way, Capacity shown is veh / hr )...

8. Lean System Design -Selecting Facilities and Routes in a Supply Network (20 points) For the class example of facility assignment, assume it is a new network design and the plants and...

Problem O.J. Juice Company sells bags of oranges and cartons of orange juice. Oranges are purchased from different suppliers, and then transported to O.J.s warehouses. At the warehouses, the oranges...

Chief Medical Inc. is a little-known producer of heart pacemakers. The earnings and dividend growth prospects of the company are disputed by analysts. Albert Bender is forecasting 5% growth in...

A vertical hydraulic cylinder has a 125-mm diameter piston with hydraulic fluid inside the cylinder and an ambient pressure of 1 bar. Assuming standard gravity, find the piston mass that will create...

Create a procedure named CalcGrade that receives an integer value between 0 and 100, and returns a single capital letter in the AL register. Preserve all other register values between calls to the...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...