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

  Why are factors of production important in economics

Economics embodies the concepts, theories and applications regarding individual and big-picture production, consumption and transfer of wealth.

  Federal aviation administration and the civil aviation

What are the differences between the Federal Aviation Administration and the Civil Aviation Authority

  Leading change for goodsport

Briefly explain Good Sport. What organizational structure is in place at the organization and what type of culture exists

  Key areas covered by the estate agents act and regulations

List three key areas covered by the Estate Agents Act and Regulations. List three key areas covered by the Sale of Land Act Regulations.

  Analyze key elements of richard bransons leadership style

Analyze the key elements of Richard Branson's leadership style and the impact that those elements have had on his business success.

  Accurate mathematical computations

The size of a register is important in accurate mathematical computations (refer to problem 1.33 for registers explanation)

  Analyze the nature of the products-services

Select an Organization that has diversified products/services (For Example UNILEVER, P&G, etc.) And,

  What is covid-19

What is Covid-19 and why is the effectiveness of "herd immunity" so hotly debated within the scientific community? Explain your response.

  Describe a current problem facing your department

Describe a current problem facing your department, organization, or industry that would indicate the need for a simulation model. How best would this problem

  An individual level

What are the ethical issues that need to be addressed on: An individual level? An organizational level? A societal level?

  Describe the history of healthcare information systems.

Describe the history of healthcare information systems. Identify and analyze at least five driving forces in the emergence and adoption of HIT.

  Encounter quality on customer satisfaction

An annotated bibliography is a preliminary exercise to a major project, in which the author selects sources, reviews them, and takes notes to decide.

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