Question

In: Operations Management

Consider the following transportation problem. Formulate this problem as a linear programming model and solve it...

Consider the following transportation problem. Formulate this problem as a linear programming model and solve it using the MS Excel Solver tool.

Shipment Costs ($), Supply, and Demand:

Destinations

Sources

1

2

3

Supply

A

6

9

100

130

B

12

3

5

70

C

4

8

11

100

Demand

80

110

60
  1. (4 points) Volume Shipped from Source A __________
  1. (4 points) Volume Shipped from Source B __________
  1. (4 points) Volume Shipped from Source C __________
  1. (3 points) Minimum cost __________

Solutions

Expert Solution

Answer:

Volume Shipped from Source A = 80

Volume Shipped from Source B = 70

Volume Shipped from Source C = 100

Minimum cost = 1530

Solution:

Excel LP Formation:

Formula:

Excel Solver Parameters:

Solution:

keosha answered 6 months ago
Next > < Previous

Related Solutions

A manager is applying the Transportation Model of linear programming to solve an aggregate planning problem....
A manager is applying the Transportation Model of linear programming to solve an aggregate planning problem. Demand in period 1 is 100 units, and in period 2, demand is 150 units. The manager has 125 hours of regular employment available for $10/hour each period. In addition, 50 hours of overtime are available for $15/hour each period. Holding costs are $2 per unit each period. a. How many hours of regular employment should be used in period 1? (Assume demand must...
Formulate but do not solve the following exercise as a linear programming problem. Kane Manufacturing has...
Formulate but do not solve the following exercise as a linear programming problem. Kane Manufacturing has a division that produces two models of fireplace grates, x units of model A and y units of model B. To produce each model A requires 2 lb of cast iron and 8 min of labor. To produce each model B grate requires 5 lb of cast iron and 5 min of labor. The profit for each model A grate is $2.50, and the...
Solve this linear programming (LP) problem using the transportation method. Find the optimal transportation plan and...
Solve this linear programming (LP) problem using the transportation method. Find the optimal transportation plan and the minimum cost. (Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) Minimize 8x11 + 2x12 + 5x13 + 2x21 + x22 + 3x23 + 7x31 + 2x32 + 6x33 Subject to x11 + x12 + x13 = 90 x21 + x22 + x23 = 105 x31 + x32 + x33 = 105 x11...
Formulate the problem as a linear programming model use excel and show your excel work. Thank...
Formulate the problem as a linear programming model use excel and show your excel work. Thank you. To (cost, in 100's) From New york Philadelphia Chicago Boston Supply Tampa $9 $14 $12 $17 200 Miami 11 10 6 10 200 Fresno 12 8 15 7 200 Demand 130 170 100 50
Formulate the situation as a linear programming problem by identifying the variables, the objective function, and...
Formulate the situation as a linear programming problem by identifying the variables, the objective function, and the constraints. Be sure to state clearly the meaning of each variable. Determine whether a solution exists, and if it does, find it. State your final answer in terms of the original question. A rancher raises goats and llamas on his 400-acre ranch. Each goat needs 2 acres of land and requires $100 of veterinary care per year, and each llama needs 5 acres...
​Formulate the linear programming model for the issue​ algebraically by stating the: 1) Definition of Decision...
​Formulate the linear programming model for the issue​ algebraically by stating the: 1) Definition of Decision Variables, 2) Objective Function Equation, 3) Constraints Equations. ​​Set up and solve the problem using Excel. Provide your answers and recommendations to the Manager of the company General organization and formatting. 1. Richelieu Specialty Paints Richelieu Specialty Paints is a company run by Amanda Richelieu. She is an artist and earned a BA degree with a major in Art and Design. The company was...
Please give one example of REAL LIFE problem that can be formulate as linear programming problem....
Please give one example of REAL LIFE problem that can be formulate as linear programming problem. Make sure you have clear statement about background, the decision variables, objective function and constraints.
Consider the following linear programming problem:                   Maximize Profit    30X + 50Y          &
Consider the following linear programming problem:                   Maximize Profit    30X + 50Y                   Subject to              4X +   5Y = 40,000                                                                X ≥   3,000                                                                Y ≥   4,000                                                     X ≥ 0 and Y ≥ 0 Use a graph to show each constraint and to identify feasible region. Identify the optimal solution point on your graph. What are the values of X and Y at the optimal solution? From your graph, what is the optimal value of...
Consider the following linear programming problem:                   Maximize Profit    30X + 50Y          &
Consider the following linear programming problem:                   Maximize Profit    30X + 50Y                   Subject to              4X +   5Y = 40,000                                                                X ≥   3,000                                                                Y ≥   4,000                                                     X ≥ 0 and Y ≥ 0 Use a graph to show each constraint and to identify feasible region. Identify the optimal solution point on your graph. What are the values of X and Y at the optimal solution? From your graph, what is the optimal value of...
Solve the following linear programming problem using the dual simplex method: max ? = −?1 −...
Solve the following linear programming problem using the dual simplex method: max ? = −?1 − 2?2 s.t. −2?1 + 7?2 ≤ 6 −3?1 + ?2 ≤ −1 9?1 − 4?2 ≤ 6 ?1 − ?2 ≤ 1 7?1 − 3?2 ≤ 6 −5?1 + 2?2 ≤ −3 ?1,?2 ≥ 0
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT