Finding total Volume and Weight Using Excel for Logistics Activities

Anonymous
timer Asked: Sep 30th, 2018
account_balance_wallet $30

Question Description

Week 1 - Assignment

Using MS Excel in Logistics Activities

The text (Murphy & Knemeyer, 2015) indicates that a spreadsheet is the most relevant software package for logisticians, and the assigned article (Bartolacci, LeBlanc, Kayikci, & Grossman, 2012) provides some real-life, practical examples of how Excel is applied in logistics. It is customary to use MS Excel in calculation of shipment volumes, weights, and costs. Our assignment this week provides a valuable introduction to the capabilities and applications of MS Excel in logistics..

Scenario:

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

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,

Tutor Answer

SkilledTutorZiss
School: Carnegie Mellon University

Attached is the full assignmentIt was a pleasure working with you on yo...

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors