i AM LOOKING FOR THE THE EXCEL SET UP NOT INDIVIDUAL. The production planner for Fine...
i AM LOOKING FOR THE THE EXCEL SET UP NOT INDIVIDUAL.
The production planner for Fine Coffees, Inc. produces two coffee blends: American (A) and British (B). He can only get 300 pounds of Colombian beans per week and 200 pounds of Dominican beans per week. Each pound of American blend coffee requires 12 ounces of Colombian beans and 4 ounces of Dominican beans, while a pound of British blend coffee uses 8 ounces of each type of bean. Profits for the American blend are $2.00 per pound, and profits for the British blend are $1.00 per pound. The goal of Fine Coffees, Inc. is to maximize profits.
Solve the LP problem in Excel and also perform sensitivity analysis.
Homework Answers
EXCEL SETUP is following
FORMULAS:
| American (A) | British (B) | ||||||
| Result | |||||||
| Profit | 2 | 1 | =SUMPRODUCT(B5:C5,$B$3:$C$3) | ||||
| Colombian beans | 12 | 8 | =SUMPRODUCT(B7:C7,$B$3:$C$3) | <= | =300*16 | ounces | 1 lb = 16 ounces |
| Dominican beans | 4 | 8 | =SUMPRODUCT(B8:C8,$B$3:$C$3) | <= | =200*16 | ounces |
Enter Solver Parameters
Click Solve button to generate the optimal solution
In the Solver results window, check Sensitivity and click OK to generate the sensitivity report
Solution:
Quantity of American (A) blend to be produced = 400 pounds
Quantity of British (B) blend to be produced = 0 pounds
Total profit = 2*400+1*0 = $ 800
Add Answer to:
i AM LOOKING FOR THE THE EXCEL SET UP
NOT INDIVIDUAL.
The production planner for Fine...
The production planner for Fine Coffees, Inc. produces two coffee blends: American (A) and British (B)....
The production planner for Fine Coffees, Inc. produces two coffee blends: American (A) and British (B). Two of his resources are constrained: Columbia beans, of which he can get at most 300 pounds (4,800 ounces) per week; and Dominican beans, of which he can get at most 200 pounds (3,200 ounces) per week. Each pound of American blend coffee requires 10 ounces of Colombian beans and 4 ounces of Dominican beans, while a pound of British blend coffee uses 6...
1. Phi Upsilon Nu, a student social organization, has two different locations under consideration for constructing...
1. Phi Upsilon Nu, a student social organization, has two different locations under consideration for constructing a new chapter house. PhUN's president, a POM student, estimates that due to differing land costs, utility rates, etc., both fixed and variable costs would be different for each of the proposed sites, as follows: ANNUAL OPERATING COSTS LOCATION FIXED VARIABLE Alpha Ave. $5,000 $200 per person Beta Blvd. $8,000 $150 per person What would be total annual costs for either location at the...
Problem 4-13 (Algorithmic) Romans Food Market, located in Saratoga, New York, carries a variety of specialty...
Problem 4-13 (Algorithmic) Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as-needed basis for a purchased from price...
Problem 4-13 (Algorithmic) Romans Food Market, located in Saratoga, New York, carries a variety of specialty...
Problem 4-13 (Algorithmic) Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans Decaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as-needed basis for a...
Problem 4-13 (Algorithmic) Romans Food Market, located in Saratoga, New York, carries a variety of specialty...
Problem 4-13 (Algorithmic) Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans Decaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as-needed basis for a...
Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular...
Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as needed basis for a price 10%...
Please provide the decision variables, objective function, and constraints. Ideally on paper and not excel. A...
Please provide the decision variables, objective function, and
constraints. Ideally on paper and not excel.
A small, but exclusive, coffee blender produces three blends of coffee during the holiday season. She produces these blends by mixing four types of coffee beans in various amounts for each particular blend. Although she tries to satisfy the demands of all her customers, she rarely has enough coffee beans to meet this demand. But, she must meet at least 70% of the demand for...
Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of t...
Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the stores leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Columbian mild coffee beans, which are purchased from a distributor from New York City. Because Romans purchases large quantities the coffee beans may be purchased om an as need basis for the price of 10%...
Coffee Cravers Ignoring Bean-Price Surge for Caffeine Fix by Marvin G. Perez and Lynn Doan Coffee...
Coffee Cravers Ignoring Bean-Price Surge for Caffeine Fix by Marvin G. Perez and Lynn Doan Coffee Cravers Ignoring Bean-Price Surge for Caffeine Fix Marvin G. Perez and Lynn Doan March 13, 2014, 5:17 PM EDT Doreen Cappelli is so hooked on her morning cappuccino that she says she’d pay a lot more to get it. “I don’t drink wine and alcohol,” Cappelli, 52, said after buying the $3.25 drink at Blue Bottle Coffee at San Francisco’s Ferry Building, in the...
do SWOT analysis. CASE 01 Mystic Monk Coffee connect . David L. Turnipseed University of South...
do SWOT analysis.
CASE 01 Mystic Monk Coffee connect . David L. Turnipseed University of South Alabama . wishing to donate to the monks' cause. Father Prior Daniel Mary did not have a great deal of experience in business matters but considered to what extent the monastery could rely on its Mystic Monk Coffee operations to fund the purchase of the ranch. If Mys- tic Monk Coffee was capable of making the vision a reality, what were the next steps...
Problem 4-13 (Algorithmic) Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as-needed basis for a purchased from price...
Problem 4-13 (Algorithmic) Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans Decaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as-needed basis for a...
Problem 4-13 (Algorithmic) Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans Decaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as-needed basis for a...
Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leading products use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of Brazilian Natural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases large quantities, the coffee beans may be purchased on an as needed basis for a price 10%...
Please provide the decision variables, objective function, and
constraints. Ideally on paper and not excel.
A small, but exclusive, coffee blender produces three blends of coffee during the holiday season. She produces these blends by mixing four types of coffee beans in various amounts for each particular blend. Although she tries to satisfy the demands of all her customers, she rarely has enough coffee beans to meet this demand. But, she must meet at least 70% of the demand for...
do SWOT analysis.
CASE 01 Mystic Monk Coffee connect . David L. Turnipseed University of South Alabama . wishing to donate to the monks' cause. Father Prior Daniel Mary did not have a great deal of experience in business matters but considered to what extent the monastery could rely on its Mystic Monk Coffee operations to fund the purchase of the ranch. If Mys- tic Monk Coffee was capable of making the vision a reality, what were the next steps...
Most questions answered within 3 hours.
-
Which amino acid has a basic R group?
A) tyrosine
B) Isoleucine
C) Glutamic Acid
D)...
asked 1 minute ago -
Is there the need for the government to have hackers. Please
share your thoughts.
asked 5 minutes ago -
Explain why you should not lose any LDH activity when you
centrifuge a crude sample at...
asked 13 minutes ago -
An AA battery (object), standing on end, is placed to the left
of a diverging lens...
asked 14 minutes ago -
After you measure the self-inductance of a coil, you unwind it
and then rewind one third...
asked 15 minutes ago -
1. Which of the following best describes a transistor?
A) a small electrical circuit made from...
asked 16 minutes ago -
Use generating function to find the number of distributions of
20 people into four different rooms...
asked 31 minutes ago -
The following data set consists the number of minutes a sample
of 25 people run every...
asked 35 minutes ago -
Suppose vacuum cleaners are part of the market basket used to
compute the CPI. Suppose also...
asked 47 minutes ago -
What intermediate results after the addition of H3O+ to
E-3-methyl-2-pentane?
pentene*
asked 52 minutes ago -
Potassium hydrogen phthalate is a solid, monoprotic acid
frequently used in the laboratory to standardize strong...
asked 1 hour ago -
1-Describe the 3 major classes of ownerships of retailers
2-What are the differences between consumer and...
asked 54 minutes ago