Provide your linear programming solution

Assignment Help Operation Management

Reference no: EM13742270 , Length: 1

The Kentucky Distillery produces custom-blended whiskey. A particular blend consists of rye and bourbon whiskey. The company has received an order for a minimum of 400 gallons of the custom blend. The customer specified that the order must contain at least 40 percent rye and not more than 250 gallons of rye. The blend cannot contain more than 45% bourbon. The distillery can produce no more than 500 gallons per week, regardless of the blend. The production manager wants to complete the order in one week. The blend is sold for $12 per gallon. The distillery company's cost per gallon is $4 for rye and $2 for bourbon. The company wants to determine the blend mix that will meet customer requirements and maximize profits.

If a calculated quantity is a fractional amount, leave it as a fractional amount.

a) Formulate the linear programming model for this problem providing the objective function and the constraints and the definition of the variables.

b) Using linear programming, solve the problem for the optimal answer and provide the value of the objective function and the variables at optimality. Provide your linear programming solution.

c) Using the sensitivity analysis output from your solution in b), provide any two sensitivity analysis interpretations. One of the interpretations must relate to the objective function and the second one must relate to one of the constraints.

d) Now suppose that the company wants to minimize the cost of production. It also wants to ensure that the profit is at least $3,500. Provide the changes to the formulation in part a) that would need to be made for these modifications. You do not need to solve for the optimal answer but only need to changes to the formulation you provided in a).

You must submit your linear programming formulation and show the linear programming software solution.

Reference no: EM13742270

Questions Cloud

Critically analyze possible exception of national security : For many years, Western scholars and academics within the mainstream were very reluctant to categorize U.S. foreign policy as being self-serving in any area, with the possible exception of national security.

How many reams should be ordered at a time : How many reams should be ordered at a time - Suppose the information technology department of the university only has space to hold 35 reams of paper at any time. How many reams should be ordered at a time?

Explain the movement or lack of movement of protein : Explain the movement or lack of movement of protein and glucose across the dialysis bag membrane

Effects on debt service : Support your recommendations with detailed spreadsheets that simulate the effects on debt service (and profitability) under the following scenarios:

Provide your linear programming solution : Formulate the linear programming model for this problem providing the objective function and the constraints and the definition of the variables.

Subtracting cost of goods sold and administrative expense : Which of the following is calculated by subtracting the cost of goods sold and administrative expense from net sales?

Write an essay on the ancient greece and rome : Write an essay on the Ancient Greece and Rome. It is art project and I need 2 pages duble spaces and 3 resource.

Describe the anatomy and physiology of a plant : Describe the anatomy (structure) and physiology (function) of a plant. Is the structure of your plant a modification from the standard root, stem, leaf, or flower

Discuss events in which technology was an important factor : Discuss three events we have studied this semester in which technology was an important factor. Be sure to select events from three different units.

User Account

All Pages