Determine an optimal shipping plan

Assignment Help Marketing Management
Reference no: EM131859943

Question: The Crazy Crude oil company can produce 1500 barrels per day from one of its fields and 1210 from the other. From there the crude oil can be piped to either of their two tank farms, one at Axel and the other at Bull. Axel then trucks oil on to the Crazy Crude refinery at $0.40 per barrel to help meet its daily demand of 2000 barrels. Bull trucks to the refinery at $0.33 per barrel. It costs Crazy Crude $0.10 per barrel to pipe from field 1 to Axel and $0.35 per barrel to pipe from field 1 to Bull. Corresponding values for field 2 are $0.25 and $0.56. Also, the tank farms can truck between themselves at $0.12 per barrel.

a. Formulate the LP problem to determine an optimal shipping plan (Hint: a visual of the problem may help)

b. Use MS Excel to compute the optimal solution for part a (attach a print-out of your spreadsheet and conditions)

Reference no: EM131859943

Questions Cloud

Define challenges to the overall success of the project : Do you think multicultural teams bring more benefits or more challenges to the overall success of the project? Why?
What is the err of the project : If the company's external investment rate is the same as its MARR at 15%, what is the ERR of the project?
Relationship between hr and the business organizations : Craft a list of questions to be used to interview a senior manager in HR to explore each interviewee's thoughts about the changing role of HR.
Identify your focal firm and its mission : Identify your focal firm and its mission (directly cite the mission statement or any available "About" information). Identify who your firm will target
Determine an optimal shipping plan : The Crazy Crude oil company can produce 1500 barrels per day from one of its fields and 1210 from the other. From there the crude oil can be piped.
Firms selling bonds in private placements is potential : A major appeal for U.S. firms selling bonds in private placements is potential:
Importance of understanding and effective management : Discuss the importance of understanding and effective management of this specific area to achieving your financial
Explain situation if the customers complaints were justified : CP Inc. has been using a specific process to produce a special component. Last year, several customers complained about inconsistencies on the 'weight'.
What is the market value of equity if the free cash flow : What is the market value of equity if the free cash flow to equity is projected to grow at 3% indefinitely and the cost of equity is 12%?

Reviews

Write a Review

Marketing Management Questions & Answers

  What are the advantages of internal alignment

Describe the post purchase evaluation process for a high involvement product. What are the likely marketing outcomes from met expectations? What are the likely marketing outcomes from unmet expectations?

  How maintain validity and reliability of quantitative data

An explanation of how you would maintain validity and reliability of the quantitative data being collected. A statement identifying methods for overcoming the kinds of problems you would expect as you collect the qualitative and quantitative data f..

  Are you defending mises theory or galbraiths theory

The debate over Consumer Sovereignty is nearly 70 years old. Are you defending Mises' theory or Galbraith's theory

  Global engagement in an interconnected world

Global Engagement in an interconnected world, it is additional file which is given by profesor.

  Pizza hut is the world''s largest pizza chain

It's no surprise that Pizza Hut is the world's largest pizza chain with more than 10,000 restaurants in 100 countries.

  Discuss the primary research instrument you will develop to

500 words all new content 2 referencesdiscuss the primary research instrument you will develop to determine how to

  Principles of cybersecurity

We can learn some of the principles of cybersecurity through something we are all almost instinctively familiar with - home security. There are "bad guys" out there trying to break into your house to steal stuff, or even to do something worse, to ..

  How to read the warning signs that a project is at risk

Unit 5 Discussion: Project Termination You may be surprised to hear that 40% of IT application development projects are canceled before they are completed. And, 33% of the remaining IT projects experience cost and schedule overruns and/or changes in ..

  Describe the german business environment

Describe the German business environment when Wal-Mart entered the German market. Why did Wal-Mart fail in Germany

  What is another industry that also uses loyalty programs

What is another industry that also uses loyalty programs to reduce buyer power? How does that industry use loyalty programs to do so?

  Identify which factors of external environment influenced

Identify which factors of the external environment influenced the company's decision. Pay close attention to customers, suppliers, competition, technology, socioeconomic trends, legislation, and economic trends

  What storage and handling cost per unit does it need

The importer estimates its annual demand to be 1400 units. What storage and handling cost per unit does it need to achieve in order to minimize its inventory cost?

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