HW Solutions Trans Model

HW Solutions Trans Model - Transportation Problem, #7...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Transportation Problem, #7 Balanced, Supply = Demand Destinations from/to Hospital 1 Hospital 2 Hospital 3 Hospital 4 Shipped Supply Excess Supply Sources Bank 1 50 50 Bank 2 80 80 Bank 3 120 120 Received Sums 250 Demand 90 70 40 50 250 Shortage 90 70 40 50 Cost Matrix Hospital 1 Hospital 2 Hospital 3 Hospital 4 Bank 1 8 9 11 16 Balanced Bank 2 12 7 5 8 Bank 3 14 10 6 7 Min Cost Objective Max = 2880 Trans Model, Problem 13 Supply Exceeds Demand Destinations from/to Pittsburgh St. Louis Denver Shipped Capacity Excess Supply Sources Los Angeles 150 150 150 8.52680E-010 New Orleans 99.9999999996 100 200 225 25 Philadelphia 50 300 350 350-1.1369E-009 Received 200 99.9999999996 400 Sums 725 Demand 200 100 400 700 Shortage 8.526513E-010 4.263256E-010 -2.27374E-009 Cost Matrix Pittsburgh St. Louis Denver Los Angeles 100 75 50 New Orleans 80 60 90 Unbalanced Philadelphia 40 50 90 Min Cost Objective 59000 Solver Setup: If Demand > Supply, Received Row <= Demand Row If Supply > Demand, Shipped Column <= Supply Column Destinations from/to Pittsburgh St. Louis Denver Shipped Capacity Excess Supply Sources Los Angeles 75 50 125 150 25 New Orleans 200 25 225 225 Seattle 350 350 350 Received 200 100 400 Sums 725 Demand 200 100 400 700 Shortage Cost Matrix Pittsburgh St. Louis Denver Los Angeles 100 75 50 New Orleans 80 60 90 Seattle 110 70 30 Min Cost Objective 36125 Choose Seattle Trans Model, Assignment Problem, #7 Part A COURSE Staff\Course Stat Mgt Fin Econ Assigned Fisher 1 1 Golhar 1 1 Hug 1 1 Rustagi 1 1 Assigned 1 1 1 1 Time Matrix Stat Mgt Fin Econ Fisher 90 65 95 40 Golhar 70 60 80 75 Hug 85 40 80 60 Rustagi 55 80 65 55 Max Ratings Objective 335 a. b. Fisher will teach finance as rthe best choice, so blocking him from teaching Statistics will not cause anything to change. Trans Model, Handout Solution Demand Exceeds Supply Warehouse Destinations from/to Atlanta, GA New Orleans Jackson,MS Birmingham, AL Raleigh, NC Columbia, SC Orlando, FL Maimi, FL Jacksonville, FL Charlotte NC Mobile, AL Shipped Capacity Excess Supply S Columbus, GA 200 200 O Ocala, FL 300 300 U Augusta, GA 400 400 R Stuart, FL 200 200 C Biloxi, MS 350 350 E Starkville, MS 400 400 S Durham, NC 500 500 Received Sums 2350 Demand 150 125 150 150 200 300 250 300 300 150 300 2375 Shortage 150 125 150 150 200 300 250 300 300 150 300 Cost Matrix Atlanta, GA New Orleans Jackson,MS Birmingham, AL Raleigh, NC Columbia, SC Orlando, FL Maimi, FL Jacksonville, FL Charlotte NC Mobile, AL S Columbus, GA 3 5 4 3 6 8 9 10 8 11 4 O Ocala, FL 4 6 5 5 7 7 2 3 2 7 5 U Augusta, GA 1 4 3 2 6 8 7 9 6 9 3 R Stuart, FL 3 5 2 6 5 6 2 2 3 5 6 C Biloxi, MS 4 1 4 3 8 10 7 13 9 8 2 E Starkville, MS 3 3 1 2 6 6 6 8 7 8 3 S Durham, NC 4 8 8 7 2 2 6 8 5 2 8 Min Cost Objective Initial Tariff Solution Modified Tariff, Interstate Add $1, IntraState Subtract Subtract $1....
View Full Document

Page1 / 9

HW Solutions Trans Model - Transportation Problem, #7...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online