Question

In your Using MS Excel in Logistics Activities assignment, enter the data provided in the scenario into a simple Microsoft Excel spreadsheet. In your spreadsheet,

Calculate the total volume of the products.

Calculate the total weight of the products.

Calculate the total weight of the shipment (ignore the shelving).

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

Calculate the total shipping cost from the Dell plant to the Oracle campus.

For this Assignment,

You must use MS Excel to perform all calculations. All work and equations must be visible within the cells. (For tutorials and assistance on how to use this software, see Microsoft’s Excel Training (Links to an external site.)Links to an external site..)

Round all answers to one decimal place.

APA format does not apply.

Neither a title page nor reference page is required.

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

Answer 1

1. Calculation of total volume of products = (L*W*H)* Total quantity

Desktop- 24*24*18*100= 1036800

Laptops- 18*18*12*200= 777600

Tablet= 12*12*9*300= 388800

Printer- 14*14*12*100= 235200

Monitor- 30*35*9*100= 945000

Total Volume = 3383400 inches.

2.Calculation of total weight = Single package weight*Quantity

Computer = 100*20= 2000

Laptop = 200*10= 2000

Tablet = 300*5= 1500

Printer = 100*7 = 700

Monitor = 100*12 = 1200

Total Weight= 7400 pounds.

3. Total weight of shipment = Total product weight+ Weight of container

= 7400+8000

15400 pounds

4. Calculation of total expenditure for transportation =

Cost for 35 miles per pound= 35*3 = 105 cents.

For 7400 pounds= 7400*105 = 777000 cents.

Thank you.