Carlton construction is supplying building materials for a new mall construction project in Kansas. Their contract calls for a total of 250,000 tons of material to be delivered over a three-week period. Carlton's supply depot has access to three modes of transportation: a trucking fleet, railway delivery, and air cargo transport. Their contract calls for 120,000 tons delivered by the end of week one, 80% of the total delivered by the end of week two, and the entire amount delivered by the end of week three. Contracts in place with the transportation companies call for at least 45% of the total delivered be delivered by trucking, at least 40% of the total delivered be delivered by railway, and up to 15% of the total delivered be delivered by air cargo. Unfortunately, competing demands limit the availability of each mode of transportation each of the three weeks to the following levels (all in thousands of tons):
The following is the LP model for this logistics problem.
What formula goes in cells F10, E3, E4, E5, and B6 of this Excel spreadsheet?
Correct Answer:
Verified
Q77: A company is planning production for
Q78: State Farm Supply has just received an
Q79: A grain store has six types
Q80: A hospital needs to determine how
Q81: Robert Hope received a welcome surprise
Q83: Project 3.1- The Diet Problem: Ordering Meals
Q84: The hospital administrators at New Hope,
Q85: The hospital administrators at New Hope,
Q86: The hospital administrators at New Hope,
Q87: Carlton construction is supplying building materials
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents