Examlex
Exhibit 7.4
The following questions are based on the problem below.
Robert Gardner runs a small, local-only delivery service. His fleet consists of three smaller panel trucks. He recently accepted a contract to deliver 12 shipping boxes of goods for delivery to 12 different customers. The box weights are: 210, 160, 320, 90, 110, 70, 410, 260, 170, 240, 80 and 180 for boxes 1 through 12, respectively. Since each truck differs each truck has different load capacities as given below: Robert would like each truck equally loaded, both in terms of number of boxes and in terms of total weight, while minimizing his shipping costs. Assume a cost of $50 per item for trucks carrying extra boxes and $0.10 per pound cost for trucks carrying less weight.
The following integer goal programming formulation applies to his problem.
Y1 = weight loaded in truck 1; Y2 = weight loaded in truck 2; Y3 = weight loaded in truck 3;
Xi,j = 0 if truck i not loaded with box j; 1 if truck i loaded with box j. Given the following spreadsheet solution of this integer goal programming formulation, answer the following questions.
-Refer to Exhibit 7.4. What formulas should go in cell E26 of the spreadsheet?
Defendant
One against whom a lawsuit is brought, or the accused person in a criminal proceeding.
Jurisdiction
The authority of a court to hear a case and decide a specific action.
Uniform Commercial Code
A set of laws that provide legal rules and regulations governing commercial or business dealings and transactions in the United States.
Common Law
Law that is derived from judicial decisions rather than statutes, emphasizing the role of courts in interpreting law.
Q13: Refer to Exhibit 10.3. What formulas should
Q14: A company wants to locate a new
Q24: Refer to Exhibit 9.1. What is the
Q28: Best case analysis is a(n) _ view
Q38: Jim Johnson operates a bus service
Q44: The solution to an LP problem is
Q46: An analyst has identified 3 independent
Q67: Leaves of a decision tree are also
Q83: Refer to Exhibit 3.4. Which cells are
Q88: Refer to Exhibit 3.3. What formula should