Introduction
Lindsay Ferguson is the operations manager for Aeroflex, a small freight forwarding company with its operating base in the Dallas-Fort Worth area.
Lindsay is planning the consolidation of an LD3 container (see picture) destined to Dubai, containing shipments from several of Aeroflex customers.
The pre-booked shipments (subject to confirmation) are listed below. Lindsay will have to decline some of the bookings, as the net capacity of the LD3 container is only 1,500 kilograms or 3.8 cubic meters. Lindsay knows she cannot exceed any of these measures.
The freight rates that Aeroflex has negotiated with its customers for the segment between Dallas-Fort Worth and Dubai is $3.00 per kilogram or $1,860 per cubic meter, whichever yields a greater charge.
Evidently, Lyndsay wants to maximize the revenue for Aeroflex from this consolidation and needs to determine which shipments to confirm and which to decline.
Assignment Instructions.
Create the proper optimization model to support Lindsay with this decision.
Attach the Excel file and a Word document(1 paragraph)with the description of the process and with your recommendation to Lyndsay.
PLACE THIS ORDER OR A SIMILAR ORDER WITH NURSING TERM PAPERS TODAY AND GET AN AMAZING DISCOUNT
