Assume that no oil of either type can be purchased

Assignment Help Operation Management

Reference no: EM131428030

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: EM131428030

Questions Cloud

Describe how each item listed above impacts the values : An example of symbols as an artifact of culture is Ashford University's shield that serves as our logo and is printed on transcripts, diplomas and letterhead paper. Submit a two- to three-page paper (excluding the title and reference pages) descri..

What was the community groups purpose or aims : Group purposes/aims: What was the community group's purpose/aims? What theory or group work model does the purpose/aim most closely link to? How is the purpose reflected in the group's activities

Make a complaint under the employment standards act : You are hired for the summer to paint houses for CK Inc. As part of your arrangement with CK, you sign a contract that states you are an “independent contractor”—you’re agreeing that you operate your own painting business. What arguments could you ma..

What does the leader do in the community group : What are the similarities in the purposes, OR leadership styles OR dynamics of the community groups - How do the community groups differ from one another in relation to their purposes, OR leadership OR dynamics? Why do you think there are differenc..

Assume that no oil of either type can be purchased : 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. Gasoline is sold for $25 per barrel, heating oil for $20. F..

Level for the foreseeable future : There are 10 million shares outstanding. What is the analyst's best estimate of the company's share price if the relevant risk-adjusted interest rate falls from 6 percent to 5 percent, and remains at that level for the foreseeable future?

Employment relations : Brad began working at Lay-Z-Guy in 1981 as a customer service manager. In 1995 his employer started requiring him and other salespeople to sign a series of one-year agreements that stated they could be terminated on 60 days’ notice. What arguments co..

How would you create a nested process : A Nested Process is identified as a concept of a process within a process. Meaning, processes can be broken down into subprocesses, which in turn can be broken down furher into more subprocesses. How would you create a “nested process”?

Typical criterion employed to identify winning contracts : In contracting, change control focuses on. Which of the following is not a typical criterion employed to identify winning contracts

User Account

All Pages