Question

In: Advanced Math

CNY Coffee Inc. uses three types of coffee beans (Columbia, Java, and Brazil) as mixtures to...

CNY Coffee Inc. uses three types of coffee beans (Columbia, Java, and Brazil) as mixtures to manufacture its two coffee products (Energy, and Everyday). The cost per pound, the availability, and rating information of the coffee beans are as follows.

Coffe Bean Cost Per Pound Caffeine Rating Taste Ratting Aroma Rating Available Pounds
Columbia $2.25 68 90 88 695
Java $1.70 78 63 77 880
Brazil $1.95 85 80 95 955

Coffee product tests are used to provide ratings on a scale of 0-100, with higher ratings indicating higher product performance. Here are the two coffee products and their product information:

Coffee Product Selling Price per Pound Product Segment Product Information
Energy $4.95 High Caffeine Caffeine level rates at least 75 or higher; Taste level rates at least 77 or higher; No Aroma level requirement
Everyday $3.15 Low Price No requirement on caffeine level; Tastes level rates between 70 and 75; Aroma level rates no more than 85.

Due to the popular demand of the low-price segment, at least 920 pounds of Everyday must be produced.

Set up and list the linear programming model for the above problem. (You do not need to solve the listed model).

Solutions

Expert Solution

The objective should be to minimize the cost price of "Everyday" cofee product :

Let the number of pounds of Columbia, Java & Brazil Coffee Bean used be X1 , X2 & X3 respectively to make "Everyday" cofee product.

Then we have to minimize the following function in order to keep the cost price lowest:

z = 2.25X1 + 1.7X2 + 1.95X3

The main constraints are as follows :

1) 0 X1 695 (Maximum available pounds for Columbia)

2) 0 X2 880 (Maximum available pounds for Java)

3) 0 X3 955 (Maximum available pounds for Brazil)

4) X1 + X2 + X3 920 (Atleast 920 pounds of "Everyday" cofee must be produced)

5) 88X1 + 77X2 + 95X3 (85*920 = 78200) (Aroma level rate should not be more than 85)

6) (70*920 = 64400) 90X1 + 63X2 + 80X3 (75*920 = 69000) (Tastes level rate between 70 & 75)


Related Solutions

This is the only information provided Columbia Coco Beans Inc. sells two types of coffee, Regular...
This is the only information provided Columbia Coco Beans Inc. sells two types of coffee, Regular and Decaf. The monthly budget for Canadian coffee sales is based on a combination of last year's performance, a forecast of industry sales, and the company's expected share of the Canadian market. The following information is provided for October: Budgeted Actual Regular Decaf Regular Decaf Price per kilogram $50 $60 $52 $60 Variable cost per kilogram 24 26 24 28 Contribution margin $26 $34...
In Brazil, coffee beans are cultivated by a very large number of small farms that all...
In Brazil, coffee beans are cultivated by a very large number of small farms that all produce beans of similar quality and taste at similar costs. Land is still plentiful, and the equipment required is affordable enough to allow new farming businesses to start up under current market conditions. However, better production techniques, especially alternatives to polluting fertilisers and deforestation, are needed in this industry. Using the theory and models of industry structure, examine this industry. Should government be worried...
Java Coffee Co is looking for a supplier for Coffee beans for the next 4 years....
Java Coffee Co is looking for a supplier for Coffee beans for the next 4 years. They have a demand for 130,000 bags of coffee beans per year. Your company is submitting a bid for this project. This project requires initial investment of $765,000 in specialized machinery. This machinery will be depreciated using straight-line to zero over the life of the project (4 years). This machinery can be sold for $375,000 at the end of the project. Your fixed production...
A coffee manufacturer blends three component coffee beans into three final blends of coffee. The Table...
A coffee manufacturer blends three component coffee beans into three final blends of coffee. The Table below summarizes the very precise recipes for the final coffee blends, the cost and availability information for the three components, and the wholesale price per pound of the final blends. The percentages in the body of the table indicate the percentage of each component to be used in each blend. Table: Percentage of each component to be used in each blend _____________________________________________________________________________                                    Final Blend...
Coffee Blending Model: A coffee manufacturer blends three component coffee beans into three final blends of...
Coffee Blending Model: A coffee manufacturer blends three component coffee beans into three final blends of coffee. The Table below summarizes the very precise recipes for the final coffee blends, the cost and availability information for the three components, and the wholesale price per pound of the final blends. The percentages in the body of the table indicate the percentage of each component to be used in each blend. Table: Percentage of each component to be used in each blend...
Coffee Bean Inc. (CBI) processes and distributes a variety of coffee. CBI buys coffee beans from...
Coffee Bean Inc. (CBI) processes and distributes a variety of coffee. CBI buys coffee beans from around the world and roasts, blends, and packages them for resale. Currently, the firm offers 15 coffees to gourmet shops in 1-pound bags. The major cost is direct materials; however, a substantial amount of factory overhead is incurred in the predominantly automated roasting and packing process. The company uses relatively little direct labor. Some of the coffees are very popular and sell in large...
Coffee Bean Inc. (CBI) processes and distributes a variety of coffee. CBI buys coffee beans from...
Coffee Bean Inc. (CBI) processes and distributes a variety of coffee. CBI buys coffee beans from around the world and roasts, blends, and packages them for resale. Currently, the firm offers 15 coffees to gourmet shops in 1-pound bags. The major cost is direct materials; however, a substantial amount of factory overhead is incurred in the predominantly automated roasting and packing process. The company uses relatively little direct labor. Some of the coffees are very popular and sell in large...
Coffee Bean Inc. (CBI) processes and distributes a variety of coffee. CBI buys coffee beans from...
Coffee Bean Inc. (CBI) processes and distributes a variety of coffee. CBI buys coffee beans from around the world and roasts, blends, and packages them for resale. Currently, the firm offers 15 coffees to gourmet shops in 1-pound bags. The major cost is direct materials; however, a substantial amount of factory overhead is incurred in the predominantly automated roasting and packing process. The company uses relatively little direct labor. Some of the coffees are very popular and sell in large...
Coffee Bean Inc. (CBI) processes and distributes a variety of coffee. CBI buys coffee beans from...
Coffee Bean Inc. (CBI) processes and distributes a variety of coffee. CBI buys coffee beans from around the world and roasts, blends, and packages them for resale. Currently, the firm offers 15 coffees to gourmet shops in 1-pound bags. The major cost is direct materials; however, a substantial amount of factory overhead is incurred in the predominantly automated roasting and packing process. The company uses relatively little direct labor. Some of the coffees are very popular and sell in large...
Resource allocation. A coffee manufacturer uses Colombian and Brazilian coffee beans to produce two? blends, robust...
Resource allocation. A coffee manufacturer uses Colombian and Brazilian coffee beans to produce two? blends, robust and mild. A pound of the robust blend requires 12 ounces of Colombian beans and 4 ounces of Brazilian beans. A pound of the mild blend requires 6 ounces of Colombian beans and 10 ounces of Brazilian beans. Coffee is shipped in 138pound burlap bags. The company has 65 bags of Colombian beans and 30 bags of Brazilian beans on hand. How many pounds...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT