Question

In: Statistics and Probability

Solve the following transportation problem: A company has refinery plants that produce gasoline with the following...

  1. Solve the following transportation problem: A company has refinery plants that produce gasoline with the following capacities
  • Houston: 27000 gallons per day
  • New Mexico: 35000 gallons per day

The company supplies the following states:

  • California: 32000 gallons per day
  • Louisiana: 12000 gallons per day
  • Mississippi: 15000 gallons per day

Following are the transportation costs per gallon between each refinery and each customer.

Distribution centers

Plants

California

Louisiana

Mississippi

Houston

0.75

0.40

0.65

New Mexico

0.50

0.70

0.80

  1. Build a transportation network
  2. Write down a linear program that optimizes transportation
  3. Solve the lp and explain its solution

Solutions

Expert Solution


Related Solutions

Solve the following transportation problem: A company has refinery plants that produce gasoline with the following...
Solve the following transportation problem: A company has refinery plants that produce gasoline with the following capacities Houston: 27000 gallons per day New Mexico: 35000 gallons per day The company supplies the following states: California: 32000 gallons per day Louisiana: 12000 gallons per day Mississippi: 15000 gallons per day Following are the transportation costs per gallon between each refinery and each customer. Distribution centers Plants California Louisiana Mississippi Houston 0.75 0.40 0.65 New Mexico 0.50 0.70 0.80 Build a transportation...
Tanura Co. is building a refinery to produce four products: diesel, gasoline, lubricants, and jet fuel....
Tanura Co. is building a refinery to produce four products: diesel, gasoline, lubricants, and jet fuel. The minimum demand (in bbl/day) for each of these products is 14.000, 30.000, 10.000, and 8.000, respectively. Oman and Dubai are under contract to ship crude to Tanura Co. Because of the production quotas, the new refinery can receive at least 40% of its crude from Oman and the remaining amount from Dubai. The specifications of the two crude oils lead to different product...
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 (4 points) Volume Shipped from Source A __________ (4 points) Volume Shipped from Source B __________ (4 points) Volume Shipped from Source C __________ (3 points) Minimum...
Given the following information set up the problem in a transportation table and solve for the...
Given the following information set up the problem in a transportation table and solve for the minimum-cost plan: PERIOD 1 2 3   Demand    550       700      750         Capacity                 Regular    500       500      440           Overtime    50       50      50           Subcontract    120       120      100         Beginning inventory    100            Costs           Regular time $   60 per unit     Overtime $   80 per unit     Subcontract $   90 per unit       Inventory...
Given the following information set up the problem in a transportation table and solve for the...
Given the following information set up the problem in a transportation table and solve for the minimum-cost plan: PERIOD 1 2 3 Demand 550 700 750 Capacity Regular 500 500 440 Overtime 50 50 50 Subcontract 120 120 100 Beginning inventory 100 Costs Regular time $ 60 per unit Overtime $ 80 per unit Subcontract $ 90 per unit Inventory carrying cost $ 1 per unit per month Back-order cost $ 3 per unit per month Suppose that an inventory...
Given the following information set up the problem in a transportation table and solve for the...
Given the following information set up the problem in a transportation table and solve for the minimum-cost plan: PERIOD 1 2 3 Demand 550 700 750 Capacity Regular 500 500 440 Overtime 50 50 50 Subcontract 120 120 100 Beginning inventory 100 Costs Regular time $ 60 per unit Overtime $ 80 per unit Subcontract $ 90 per unit Inventory carrying cost $ 1 per unit per month Back-order cost $ 3 per unit per month Suppose that an inventory...
Create a transportation problem Select an initial feasible solution ( any method). Solve the transportation problem...
Create a transportation problem Select an initial feasible solution ( any method). Solve the transportation problem using the method of multipliers.
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...
Petro Refinery, Inc., located in Houston, TX, has separate divisions for “Unleaded Gasoline” and “Jet Fuel”....
Petro Refinery, Inc., located in Houston, TX, has separate divisions for “Unleaded Gasoline” and “Jet Fuel”. The variable costs are as follows: ■ Unleaded Gasoline division: $1.75 per gallon of unleaded gasoline ■ Jet Fuel division: $1.95 per gallon jet fuel Assume that there is no loss in processing unleaded gasoline into jet fuel. Unleaded Gasoline can be sold at $2.25 per gallon. Jet Fuel can be sold at $3.95 per gallon. Required: Should Petro Refinery process the unleaded gasoline...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT