Examlex
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 values would you enter in the Risk Solver Platform (RSP) task pane for the cells in this Excel spreadsheet implementation of this problem?
Objective Cell:
Variables Cells:
Constraints Cells:
Standard Hours Allowed
The number of hours that should have been worked for the units produced, based on preset standards.
Units of Product
The quantity of product items or goods produced.
Actual Hours Worked
This refers to the total hours an employee has been physically present and working at their job within a specific period.
Direct Labor Costs
The wages and benefits paid to employees who are directly involved in the production of goods or services.
Q13: A company is developing its weekly
Q18: You have been given the following
Q31: Top managers are responsible for (1) creating
Q38: Refer to Exhibit 10.5. What formulas should
Q44: You have been given the following
Q47: Which of the following categories of modeling
Q49: Refer to Exhibit 10.1. What number of
Q70: Binding constraints have<br>A) zero slack.<br>B) negative slack.<br>C)
Q73: Which of the following management theorists believed
Q76: A contractor was feeling defeated because the