Formulate the linear programming model

Assignment Help Operation Management
Reference no: EM132201463

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 show calculations in excel

Reference no: EM132201463

Questions Cloud

How job advertisement addresses any legal issues : Explain how a job advertisement addresses any legal issues required for a position. What would be your recommendations?
Marketers utilize digital media to improve business : How can marketers utilize digital media to improve business? Define accessibility, addressability, connectivity, interactivity, and control.
Key elements of leading the strategy execution process : Identify four actions that are key elements of leading the strategy execution process.
Emotional intelligence in personal project management : Write a three to five-page essay discussing the importance of emotional intelligence in personal project management.
Formulate the linear programming model : Formulate the linear programming model for this problem providing the objective function and the constraints and the definition of the variables.
Culture performs several important functions in organization : Culture performs several important functions in organizations. Clarifying and reinforcing standards of behavior is one of these.
Conflict among team members as they work in this arena : Select one of the arenas where change is needed to promote teamwork. What are potential sources of conflict among team members as they work in this arena?
The most difficult part of locating quality sources : What was the most difficult part of locating quality sources on your topic in Module 6? What was the most rewarding?
Describe how this technology could improve communication : Describe how this technology could improve communication. What are some barriers to use?

Reviews

Write a Review

 

Operation Management Questions & Answers

  What one major organizational subsystem needs to be changed

What one major organizational subsystem needs to be changed in RSPS. Justify your choice. How will that subsystem change affect two other subsystems within the organization and how will you realign the total system

  Discuss the behavioural implications of planning

Discuss the behavioural implications of planning and control when a company's management employs:

  What must media planners consider before they begin

What must media planners consider before they begin? What are the elements of message strategy and how does it differ from advertising (or creative) strategy?

  What is the principle of an inventory control system

What Is the Principle of an Inventory Control System? What are the goals and objectives of an Inventory Control System? What is a Push Inventory System? What is a Pull Inventory System?

  What conflicts or controversies does it raise

Using academic scholarly research, find an article that addresses an ethical dilemma from the past five years and annotate it thoroughly.

  Difference between building cohesiveness in project teams

In your view, what is the difference between building cohesiveness in project teams in contrast to traditional/permanent teams? How do permanent teams build cohesiveness in contrast to project teams which tend to be temporary structures?

  Compare and contrast presentation methods

Compare and contrast presentation methods (e.g., Web based, lecture, or video) with hands-on methods of training (e.g., OJT, case study, role-play). What are the implications of using technology in training? What are the specific challenges associate..

  Developing nations create for international businesses

What opportunities might current IMF lending policies to developing nations create for international businesses?

  Analyze the manner in which each of these causes

Determine the main reasons why a greater involvement in employees' personal lives, as opposed to non-involvement, is inevitable in many international HRM activities, especially in developing countries. Provide one (1) example to support your answe..

  Discuss factors affecting contractual capacity

Briefly discuss factors affecting contractual capacity. Briefly discuss how a contract can be terminated.

  What options does mcadams company have

McAdams Company, a TV manufacturer and supplier in Minnesota, received an email offer from Discount TVs, What options does McAdams Company have?

  Write the equations expressing this information

Write the equations expressing this information. Solve the problem using the Excel Solver, giving the amount of each fuel to be used. State any assumptions necessary to solve the problem.

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