Bluegrass distillery produces custom-blended whiskey

Assignment Help Operation Management

Reference no: EM132201529

The Bluegrass 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 to this problem to receive credit.

Please solve in POM for Windows or please show constraints for excel solver step by step.

Reference no: EM132201529

Questions Cloud

How it increases or decreases the demand for money : What are the 4 influences on the demand for money? For each influence, tell how it increases or decreases the demand for money.

Create smartsheet dashboard for steering-sponsor committee : Create a smartsheet “dashboard” for the steering / sponsor committee.

What is fiscal policy : What is fiscal policy? Explain the multiplier effect.

Document of assumptions made while creating cost estimate : Create a google document of assumptions made while creating the cost estimate.

Bluegrass distillery produces custom-blended whiskey : The Bluegrass Distillery produces custom-blended whiskey. A particular blend consists of rye and bourbon whiskey.

Different snack products in large food products company : You supervise a team of marketing analysts who work on different snack products in a large food products company.

Spiritual perspectives into competitive business advantage : How can a manager turn the accommodation of employees’ religious and/or spiritual perspectives into a competitive business advantage?

Software solution for customer relationship management : You are running a project to engineer and implement a set of business processes and a software solution for customer relationship management.

What kind advertising takes place in the four industries : What kind (if any) advertising takes place in the four industries? Where is the advertising taken place - TV, Online, Facebook, Flyers, and/or radio?

User Account

All Pages