Calculate the total volume of the products

Assignment Help Business Management
Reference no: EM133103142

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.

Reference no: EM133103142

Questions Cloud

Categories of cultural differences : What are some of the categories of cultural differences that help make one country or region of the world different from another? Pick two or more countries, de
What is the firm net new long-term debt : If spending on net fixed assets and net working capital was zero, and if no new stock was issued during the year, what is the firm's net new long-term debt
Type of impact did the loreal campaign : What type of impact did the LOreal campaign have on you? It could be positive or negative
Infibeam internet retailing : How feasible is it for "Infibeam Internet Retailing" to extend the retailing services in B2B space?
Calculate the total volume of the products : Oracle Corporation is building a large new campus for cloud computing support in Austin, Texas. They have selected Dell Computer Corporation, located in neighbo
What was the cash coverage ratio for the year : The firm paid $3,425 in total interest expense and deducted $2,149 in depreciation expense. What was the cash coverage ratio for the year
What the ethical issues faced by nestle : 1. What the ethical issues faced by Nestle 2. Discuss and evaluate the ethical issues faced by Nestle from the point of
Development of effective relationships : Identify three factors affecting parents and teachers that may act as barriers to the development of effective relationships.
Determine his gross pay : Kyle Forman worked 47 hours during the week for Erickson Company at two different jobs. His pay rate was $13.80 for the first 40 hours, Determine his gross pay

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd