Examlex
Exhibit 6.2
The following questions pertain to the problem, formulation, and spreadsheet implementation below.
A certain military deployment requires supplies delivered to four locations. These deliveries come from one of three ports. Logistics planners wish to deliver the supplies in an efficient manner, in this case by minimizing total ton-miles. The port-destination data, along with destination demand is provided in the following table. The ports are supplied by one of two supply ships. These ships travel to a particular port where their supplies are off-loaded and shipped to the requesting destinations. Ship S1 carries 1200 tones of supplies while Ship S2 carries 1120 tons of supplies. These ships can only go to a single port and each port can only accommodate one ship. Assume the costs for a ship to travel to a port are not part of the objective function.
The following is the ILP formulation and a spreadsheet model for the problem.
-Refer to Exhibit 6.2. What formula would go into cell E14?
El Paso
A city located in West Texas, known for its significant cultural and historical ties to both the United States and Mexico.
Ellis Island
Reception center in New York Harbor through which most European immigrants to America were processed from 1892 to 1954.
Social Scientists
Professionals who study and analyze various aspects of human society, including cultural, economic, and political phenomena.
Q12: Which command is equivalent to =SUMPRODUCT(A1:A3,B1:B3)?<br>A) =SUM(PRODUCT((A1:A3,B1:B3))<br>B)
Q19: Problems which have only integer solutions are
Q28: Refer to Exhibit 11.12. What is the
Q37: Refer to Exhibit 11.10. What is the
Q38: If a company produces Product 1,
Q44: Refer to Exhibit 11.8. What formula should
Q54: If there is no way to simultaneously
Q82: A grain store has six types
Q87: Refer to Exhibit 3.1. Which cells should
Q119: Refer to Amazon.com. Which traditional management function