SUBMIT Homework 1 - Part II - see the instructions above and below
Eva Chan
TransportationProblem.xlsx
Sheet1
| | INPUTS | | | | | | | OBJECTIVE FUNCTION |
| | | | | | | | | Cost | $681,010 |
| | | Unit Shipment Cost | Warehouses |
| | | | CA | TX | OH | Supply |
| | Plants | CO | 1268 | 1083 | 1331 | 250 |
| | | SC | 2843 | 1194 | 605 | 400 |
| | | Demand | 225 | 240 | 185 |
| | DECISION VARIABLES |
| | | Amount Shipped | Warehouses | | | | | SUPPLY CONSTRAINT |
| | | | CA | TX | OH | | | Total Shipment | Constraint Sign | RHS |
| | Plants | CO | 225 | 25 | 0 | | | 250 | <= | 250 |
| | | SC | 0 | 215 | 185 | | | 400 | <= | 400 |
| | | DEMAND CONSTRAINT |
| | | Total Shipment | 225 | 240 | 185 |
| | | Constraint Sign | >= | >= | >= |
| | | RHS | 225 | 240 | 185 |