Ashford University Oracle Corporation Logistics Management Excel Spreadsheet

User Generated

Qbzb1104

Business Finance

Description

PLEASE SEE ATTACHED FOR SCREENSHOTS OF ACTUAL ASSIGNMENT DIRECTIONS


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.

Unformatted Attachment Preview

11:46 1 Search lLTE < Back Assignment Details MGT400: Logistics Management (MGH2033A) 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. Iong, 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 Single Package Weight Launch External Tool < Previous Next OOO DOO Dashboard Calendar To Do Notifications Inbox 11:46 1 Search nullLTE < Back Assignment Details MGT400: Logistics Management (MGH2033A) The order is summarized in the following table: Product Quantity Single Package Dimensions LxWxH (inches) Single Package Weight (pounds) 100 24x24x18 20 Desktop Computer 200 18x18x12 10 Laptop Computer 300 12x12x9 5 Tablet Computer 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 Launch External Tool < Previous Next OOO DOO Dashboard Calendar To Do Notifications Inbox 11:47 9 l LTE Search < Back Assignment Details MGT400: Logistics Management (MGH2033A) 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.) • Round all answers to one decimal place. • APA format does not apply. • Neither a title page nor reference page is required. Carefully review the Grading Rubric for the criteria that will be used to evaluate your assignment. Waypoint Assignment Submiss Launch External Tool < Previous Next OOO DOO Dashboard Calendar To Do Notifications Inbox
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please find attached the solution. Let me know if you need anything else.

Product
Desktop Computer
Laptop Computer
Tablet Computer
Printer
Monitor
Total

Quantity
100
200
300
100
100

Dimension o...

Similar Content

Related Tags