The text (Murphy & Knemeyer, 2018) 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,
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.).)
Round all answers to one decimal place.
APA format does not apply.
Neither a title page nor reference page is required.
Clients' Reviews about Our Services
Client ID 45637
U.S.A
Brilliant services. I ordered a 4 page essay and it was delivered in less than 24hours with every detail intact!
Client ID 45783
U.K
Aceassignment is the way to go. The writers are humble and patient with clients. I know this after using the website for about an year
Client ID 45214
U.K
My writer did a brilliant job. Not only did she delivered the paper on time and it was superb as my professor granted me an A without any criticism
Client ID 45009
CAD
I was running late with my assignment. I run into aceassignment on google, placed my order and within less than 18 hours my page essay was delivered. Thank you Aceassignment.
Client ID 45870
U.S.A
I've been using Aceassignment for about 2 years. My writer always delivers quality work. Mind you whenever I request for a revision it's always done ASAP and free of charge
Client ID 44218
U.S.A
At first, I was scared and hesitant about using this website. Didn't know if they would deliver, but they assured me they will. And for sure they did. I will definitely continue to use their service!
Client ID 45622
U.S.A
Easy to use website. You simply give your essay's instructions, make payment and before you known it the paper is delivered to you.
Client ID 43964
U.S.A
Unlike other platforms, this website is quite cheap and the quality is high. I have them manage my whole class and everything has been smooth this far.
Client ID 41996
U.K
Thanks for the excellent job. Swift and on the subject, just the way I like it. The Support team was quite nice to me, helped me with the order placing process.
Client ID 47654
AU
They are a marvel. I love their support team, they are so polite, it’s like speaking to a butler or something. Very pleasant people and good service of course.
Client ID 45670
FRA
Thank you for the help, I took my time and ordered a 14 days long essay. It came much earlier, around 7 days after I ordered it. Oh, and it was good, of course. I like the writer who did that, will definitely use again.
Client ID 22368
US
What I received was great. I forgot to mention in the instructions field that I needed reference page and by default, there was 0 in the number of references. I was surprised to see a full-fledged reference page in my paper with relevant citations. Bravo!
Client ID 46325
U.S.A
I was bombarding him with fine tuning and he handled it professionally. Thank you I will hire again the writer
Client ID 456820
U.S.A
Provided exceptional essay writing help in a short period of time. I plan to work with writer on many more projects!
Client ID 36890
UAE
Awesome paper in such a short amount of time. Was in a jam with another service who didn't deliver, but my writer did the job correctly. I will use her again to do my essays for sure!
Client ID 41427
U.K
Pretty good essay writer. I only made a couple of adjustments. She caught some instructions for the essay writing assignment that I didn't even notice, including them which was a pleasant surprise. Definitely recommend.
Client ID 45009
CAD
It was a very long paper, but the writer followed all the instructions, and she even finished the paper 5 days before the due date. Will write an essay with her again, thanks!
Client ID 36984
U.S.A
Writer was timely and proficient. I had to ask for a revision, but I got it back quickly with no other issues. Would use this essay writing service again.
Client ID 42960
CAD
Paper writing was prepared and submitted prior to the completed request date, and there were changes made quickly after I requested. This paper writer was accurate with numbers.
Client ID 31638
U.K
The first time I ordered here and it was a success. I received my order on time and according to my instructions. Thank you!
Client ID 46041
CAD
When I first discovered this website I was hesitant on whether they will deliver a plag free paper. The support team reassured me of their plagiarism policy. In deed they kept their word as the paper I got was authentic and plagiarism free.