Solve using excel formulas and everything
Mark3433
Module4ProblemWorkbook.xlsxP5-43
| Traveling from New York to LA | ||||||||
| Labeling of nodes | ||||||||
| City | Index | |||||||
| New York | ||||||||
| Cleveland | ||||||||
| St. Louis | ||||||||
| Nashville | ||||||||
| Phoenix | ||||||||
| Dallas | ||||||||
| Salt Lake City | ||||||||
| Los Angeles | ||||||||
| Network formulation | Node balance constraints | |||||||
| Origin | Destination | Gallons | Flow | Node | Net inflow/outflow | Required | ||
| Gallons used |
P5-46
| Oil lease auction | |||||
| Bids for sites (dollars/acre) | |||||
| Site 1 | Site 2 | ||||
| Ewing | |||||
| Barnes | |||||
| Pickens | |||||
| Max % that can be sold to any bidder | |||||
| Number of acres sold to bidders | |||||
| Site 1 | Site 2 | Total | Max allowed | ||
| Ewing | |||||
| Barnes | |||||
| Pickens | |||||
| Total | |||||
| Available | |||||
| Revenue ($millions) |
Problem 4.8
P5-52
| Bidding on contracts | |||||||
| Bids on contracts (in $1000s) (large values mean contractor didn't bid for that job) | |||||||
| Job 1 | Job 2 | Job 3 | Job 4 | ||||
| Contractor 1 | |||||||
| Contractor 2 | |||||||
| Contractor 3 | |||||||
| Assignment of contractors to jobs | |||||||
| Job 1 | Job 2 | Job 3 | Job 4 | Total | Max | ||
| Contractor 1 | |||||||
| Contractor 2 | |||||||
| Contractor 3 | |||||||
| Total | |||||||
| Required | |||||||
| Total cost ($1000s) | |||||||
Problem 4.16
