Show the constraints in given problem

Reference no: EM131845344

Question: Chandler Oil Company has 5,000 barrels of oil 1 and 10,000 barrels of oil 2. The company sells two products: gasoline and heating oil. Both products are produced by blending oil 1 and oil 2. The quality level of each oil is as follows: 10 for oil 1; 5 for oil 2. Gasoline must have an average quality level of at least 8, and heating oil at least 6. Demand for each product must be created by advertising. Each dollar spent advertising gasoline creates 5 barrels of demand and each dollar spent on heating oil creates 10 barrels of demand. Gasoline is sold for $25 per barrel, heating oil for $20. Formulate and solve an LP to help Chandler maximize profit. Assume that no oil of either type can be purchased. Please also clearly define the decision variables and solve in Microsoft Excel using the solver function. Clearly show the constraints.

Reference no: EM131845344

Questions Cloud

Compare and contrast two images of managing change : Change Management: As stated in Palmer, Dunford, and Akin (2009), "images we hold of organizations affect our interpretations of what we think is going on.

Faster in times of political upheaval : Things move much faster in times of political upheaval so why not pursue more ambitious goals? But it is also very common for there to be significant

Explanations of the development of the current world economy : Are the Marxist explanations of the development of the current world economy (dependency theory and world system theory) satisfying? Why or why not?

Summarize implementing biometric security : Why do you think the author elaborated on six different steps, only one of which is actually "Understanding Biometrics Measures"?

Show the constraints in given problem : Chandler Oil Company has 5,000 barrels of oil 1 and 10,000 barrels of oil 2. The company sells two products: gasoline and heating oil.

How would realist explain current american foreign policy : How would realist explain current American Foreign Policy? You can explain either Former President Obama's or President Trumps using the realism perspective.

In what ways did the time you spent online affect : In what ways did the time you spent online affect on your ability to manage school, work, or offline relationships?

Case studies of revolutionary nationalists : What are common themes in these case studies of revolutionary nationalists? (Patrice Lumumba, Fidel Castro, and Ho Chi Minh)

What you have learned about the position of a retail buyer : What you have learned about the position of a retail buyer, build two very detailedarguments supporting the decision to give PenAgain a trial period.

User Account

All Pages