Question: state the optimal blending and the optimal profit. Include the excel file you generated ( sensitivity report, answer report, excel model). The Mill Mountain Coffee

state the optimal blending and the optimal profit. Include the excel file you generated ( sensitivity report, answer report, excel model).

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 Neill Regular. It uses four different types of coffee to produce the blendsBrazilian, mocha, Colombian, and mild. The shop has the following blend recipe requirements: Blend Selling Price/Pound Special Dark Regular Mix Requirements At least 10% Columbian, at least 30% mocha At least 60% Brazilian, no more than 10% mild No more than 60% mild, at least 30% Brazilian $6.50 5.25 3.75 The cost of Brazilian coffee is $2.00 per posad, the cost of mocha : $2.75 per pound, the cost of Colombiar is $2.90 per pound, and the cost of mild is $170 per pound. The shop has 110 pounds of Brazilian coffee. 0 pounds of mocha, 80 pounds of Colombian, 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 profit a. Formulate a linear programming model for this

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Following are the auditor's calculations of several key ratios for Cragston Star Products. The primary purpose of this information is to understand the client's business and assess the risk of...

Solve the linear programming model formulated in Question 5 of General Midterm Review doc- ument located in itslearning (the coffee blending example) by using Excel. State the optimal blending and...

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...

1. A textile company produces two types of silk wearsties and shirts. Shirt is a heavier grade of silk cloth and, as such, requires 8.5 pounds of raw silk per yard, whereas tie requires 6 pounds of...

1. A textile company produces two types of silk wears ties and shirts. Shirt is a heavier grade of silk cloth and, as such, requires 8.5 pounds of raw silk per yard, whereas tie requires 6 pounds of...

A textile company produces two types of silk wears-ties and shirts. Shirt is a heavier grade of silk cloth and, as such, requires 8.5 pounds of raw silk per yard, whereas tie requires 6 pounds of raw...

Please write clearly.. 1. A textile company produces two types of silk wearsties and shirts. Shirt is a heavier grade of silk cloth and, as such, requires 8.5 pounds of raw silk per yard, whereas tie...

1. A textile company produces two types of silk wears-ties and shirts Shirt is a heavier grade of silk cloth and, as such, requires 8.5 pounds of raw silk per yard, whereas tie requires 6 pounds of...

no more information. Please help me solve this Due date: 12 April 2021, 23:59 1. A textile company produces two types of silk wearsties and shirts Shirt is a heavier grade of silk cloth and, as such,...

. A textile company produces two types of silk wears ties and shirts. Shirt is a heavier grade ofsilk cloth and, as such, requires 8.5 pounds of raw silk per yard, whereas tie requires 6 poundsof raw...

Alvamar Company has the following data for the weekly payroll ending January 31 Employees are paid 112 times the regular hourly rate for all hours worked in excess of 40 hours per week. FICA taxes...

Develop two approaches using reference group theory to reduce drug, alcohol, or cigarette consumption among teenagers.

The decision whether to use the historical cost principle or the fair value principle depends on both relevance and faithul representation. only relevance. only fastuful representation. neither...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...