Question: Once a contractor’s order has been completed, Blue Construction stores it on a pallet in its warehouse until the contractor requests delivery to the jobsite. All deliveries are made using a flatbed truck that can transport up to 6000 lbs. of material. Blue Construction wants to make as few trips to the jobsite as possible and cannot transport more than ten orders on the first trip. The orders that have been requested for delivery and their respective weights are provided in Table F6.

1. Develop a load plan that Blue Construction should follow for the first and any subsequent trip(s). Include Excel output and clearly indicate any constraints, which orders should be delivered on the first trip, which orders should be delivered on subsequent trip(s), the number of orders for each trip(s), and the total weight for each trip(s).

Price: $2.99

Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document