Formulate algebraically the linear programming model

Reference no: EM132465212

The Mill Mountain Coffee Shop blends coffee on the premises for its customers. It sells three basic blends in 1-pound bags, Special, Mountain Dark, and Mill Regular. It uses four different types of coffee to produce the blends - Brazilian, mocha, Columbian, and mild. The shop used the following blend recipe requirements.

blend:

special : at least 40% columbian, at least 30% mocha
dark : at least 60% Brazilian, no more than 10% mild
regular : no more than 60% mild, at least 60% Brazilian

selling price per pound of each blend

special = $6.50
dark = $5.25
regular = $3.75

The cost of Brazilian coffee is $2.00 per pound, the cost of mocha is $2.75 per pound, the cost of Columbian is $2.90 per pound, and the cost of mild is $1.70 per pound. The shop has 110 pounds of Brazilian coffee, 70 pounds of mocha, 80 pounds of Columbian, and 150 pounds of mild coffee available per week. The shop wants to know the amount of each blend it should prepare each week to maximize the NET profit.

a. Formulate algebraically the Linear Programming (LP) model for this problem.

b. Formulate this same linear programming problem on a spreadsheet and SOLVE using Excel Solver (Provide the corresponding "Excel Spreadsheet" and the "Sensitivity Report"). Include "managerial statements" that communicate the results of the analyses.

c. Are there multiple optimal solutions? Justify

Reference no: EM132465212

Questions Cloud

What has the impact only on the balance sheet : You prepay $600 in January towards insurance for the year. By how much will your net worth have been affected if you cancel your policy after 6 months?

Discuss the social and historical context matters : In your response, discuss whether knowing the social and historical context matters when determining whether an object should be classified as a work of art.

What is the numerical value of the correlation : What is the numerical value of the correlation r between percent of classes attended and grade index?

How evangelical impulses may have undercut arguments : For this essay, you will draw on the primary source documents linked below, especially the section entitled "Motives and Attitudes," to explain the arguments.

Formulate algebraically the linear programming model : Formulate algebraically the Linear Programming (LP) model for this problem.

Relationship between steroid injection-decreased pain level : Can the researcher claim there is a causal relationship between the steroid injection and decreased pain level?

What would motivate to be a whistleblower : What would motivate you to be a Whistleblower?If you worked for a publicly held company and knew of fraud in your company, would you be a whistleblower?

Customer satisfaction and health plan type : In order to study the relationship between customer satisfaction and health plan type, an insurance company surveyed 100 members from each of its 5 health plans

Calculate and interpret an effect-size estimate : Was the difference in mean length of sentence in part (2e) in the predicted direction? Calculate and interpret an effect-size estimate for this obtained F.

User Account

All Pages