Question

Oracle Corporation is building a large new campus for cloud computing support in Austin, Texas. They have selected

Dell Computer Corporation, located in neighboring Round Rock, Texas, to supply various devices for the campus. The distance from the Dell facility to the Oracle campus is 35 miles. The specified shipping mode is by truck, which costs three cents per pound, per mile. Oracle has requested that all shipments be made in 40-foot containers with interior dimensions of 40 ft. long, 8 ft. wide, and 8 ft. 6 in. high. A container weighs 8,000 pounds and has a maximum payload (cargo weight) of 55,126 pounds. Oracle intends to leave the containers at their location as secure storage during the startup stage of their operations. Because the containers will serve as mini-warehouses, adequate room to move around inside the container is needed. Dell will construct lightweight, inexpensive wooden shelving for storage instead of using pallets. This requirement will limit the useable volume of the container to 80% of its normal maximum.

The order is summarized in the following table:

Product Desktop Computer

Quantity 100

Single Package Dimensions LxWxH (inches) 24x24x18

Single Package Weight (pounds) 20

Product Laptop Computer

Quantity 200

Single Package Dimensions LxWxH (inches) 18x18x12

Single Package Weight (pounds) 10

Product Tablet Computer

Quantity 300

Single Package Dimensions LxWxH (inches) 12x12x9

Single Package Weight (pounds) 5

Product Printer

Quantity 100

Single Package Dimensions LxWxH (inches) 14x14x 12

Single Package Weight (pounds) 7

Product Monitor

Quantity 100

Single Package Dimensions LxWxH (inches) 30x35x9

Single Package Weight (pounds) 12

in excel.