Question

Determine the number of 40-ft containers required to ship the order.

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	Quantity	Single Package Dimensions LxWxH (inches)	Single Package Weight (pounds)
Desktop Computer	100	24x24x18	20
Laptop Computer	200	18x18x12	10
Tablet Computer	300	12x12x9	5
Printer	100	14x14x 12	7
Monitor	100	30x35x9	12

Product	Quantity	Single Package Dimensions LxWxH (inches)	Single Package Weight (pounds)	Total Volume (L*W*H)*Total quantity	Calculation of total weight = Single package weight*Quantity	Total weight of shipment = Total product weight+ Weight of container	Calculation of total expenditure for transportation =
Desktop Computer	100	24x24x18	20	1036800	2000	15400	777000
Laptop Computer	200	18x18x12	10	777600	2000
Tablet Computer	300	12x12x9	5	388800	1500
Printer	100	14x14x 12	7	235200	700		For 7400 pounds= 7400*105 = 777000 cents.
Monitor	100	30x35x9	12	945000	1200
				3383400	7400

Answer 1

Product	Quantity	Single Package Dimensions LxWxH (inches)	Single Package Weight (pounds)	Total Volume (L*W*H)*Total quantity	Calculation of total weight = Single package weight*Quantity	Total weight of shipment = Total product weight+ Weight of container	Calculation of total expenditure for transportation =	Cost in $
Desktop Computer	100	24x24x18	20	1036800	2000	15400	777000	7770
Laptop Computer	200	18x18x12	10	777600	2000
Tablet Computer	300	12x12x9	5	388800	1500
Printer	100	14x14x 12	7	235200	700		For 7400 pounds= 7400*105 = 777000 cents.	(105= 3 cents * 35 miles)
Monitor	100	30x35x9	12	945000	1200
				3383400	7400

Capacity required		3383400
Total Capacity of truck= 40*8*8.5*12*12*12		4700160
Available Capacity of truck= 0.8*Tot Cap		3760128
Utilization volume		0.899810	(So 1 Truck)
Weight required		7400
Weight Capacity		55126
Utilization weight		0.134238	(So 1 Truck)

Hence 1 truck is required.