28 Mar The text (Murphy & Knemeyer, 2018) indicates tha
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.
MGT400 Assignments Week 1 – Assignment!
Week 1 – Assignment
Due Monday by 11:59pm Points 8 Submi!ng an external tool
This tool needs to be loaded in a new browser window
Using MS Excel in Logis!cs Ac!vi!es The text (Murphy & Knemeyer, 2018) indicates that a spreadsheet is the most relevant so"ware package for logis!cians, and the assigned ar!cle (Bartolacci, LeBlanc, Kayikci, & Grossman, 2012) provides some real-life, prac!cal examples of how Excel is applied in logis!cs. It is customary to use MS Excel in calcula!on of shipment volumes, weights, and costs. Our assignment this week provides a valuable introduc!on to the capabili!es and applica!ons of MS Excel in logis!cs..
Scenario:
Oracle Corpora!on is building a large new campus for cloud compu!ng support in Aus!n, Texas. They have selected Dell Computer Corpora!on, 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 ". long, 8 ". wide, and 8 ". 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 loca!on as secure storage during the startup stage of their opera!ons. 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 Quan"ty 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 Logis!cs Ac!vi!es assignment, enter the data provided in the scenario into a simple Microso" 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-" 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 calcula!ons. All work and equa!ons must be visible within the cells. (For tutorials and assistance on how to use this so"ware, see Microso"’s Excel Training .) Round all answers to one decimal place. APA format does not apply. Neither a !tle page nor reference page is required.
Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment.
Waypoint Assignment Submission
The assignments in this course will be submi#ed to Waypoint. Please refer to the instruc!ons below to submit your assignment.
1. Click on the Assignment Submission bu#on below. The Waypoint "Student Dashboard" will open in a new browser window. 2. Browse for your assignment. 3. Click Upload. 4. Confirm that your assignment was successfully submi#ed by viewing the appropriate week's assignment tab in Waypoint.
For more detailed instruc!ons, refer to the Waypoint Tutorial .
The session for this tool has expired. Please reload the page to access the tool again
"Previous Next#
03/22/2022 – UAGC Underg…
Home
Announcements
Syllabus
Modules
Grades
Course Policies
Wri!ng Center & Library
Course Resources
BigBlueBu#on
Student Support Center
Forbes Access
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Chat with us today! We are always waiting to answer all your questions.