Question

In: Operations Management

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 (percent)                

                                                                                    Cost Per            Maximum Availability

            Component                    1         2          3              Pound           Each Week (Pound)

_____________________________________________________________________________                                                                                                  

                 1                  80        0          20        $0.60        40,000

                 2                  50        15        35        $0.80        25,000

                 3                  0          40        60        $0.55        20,000

_____________________________________________________________________________  

            Wholesale Price/lb.       $1.25   $1.50   $1.40 _____________________________________________________________________________

Weekly capacity for the processor's plant is 100,000 pounds, and the company wishes to operate at capacity. There is no problem in selling the final blends, although there is a requirement that minimum production level of 10,000, 25,000 and 30,000 pounds, respectively, be met for blends 1, 2 and 3. The manufacturer wishes to determine the number of pounds of each component to be purchased so as to maximize total weekly profit.

Formulate the problem as an L.P. model.  

Solutions

Expert Solution

xij = number of pounds of component i used in final blend j, i= 1, 2,3,4; j =1,2,3.

            Therefore, we have

            ________________________________________________________________________                                                Final Blend number of pounds          

                                                                                                Cost Per          Maximum Availability

            Component                1             2          3                  Pound           Each Week (Pound)

            (pounds)                  ________________________________________________________________________                                                                                                                              

                 1                             x11          x12        x13              $0.60                     40,000

                 2                             x21          x22        x23              $0.80                     25,000

                 3                             x31           x32        x33              $0.55                     20,000

                

            _______________________________________________________________________

Wholesale Price/lb. $1.25 $1.50 $1.40                         ________________________________________________________________________

Objective fucntion=

Subject to=

For Blend Type 1=

x 11= .20(x11+x21+x31) i.e.           -0.8 x11 + 0.2 x21 + 0.2 x31 = 0

0.4 x11 - 0.6x21 + 0.4x31 = 0

0.15 x11 + 0.15 x21 -0.85 x31  = 0

0.25 x11 + 0.25 x21 + 0.25 x31 = 0

Final Blend of Type 2.

                                                -.65 x12 + .35 x22 + .35 x32 = 0

                                                .15 x12 - .85 x22 + .15 x32 = 0

                                                .20 x12 + .20 x22 - .80 x32 = 0

                                                .30 x12 + .30 x22 + .30 x32 = 0

            3.         Final Blend of Type 3.

                                                -.90 x13 + .10 x23 + .10 x33 = 0

                                                .35 x13 - .65 x23 + .35 x33 = 0

                                                .40 x13 + .40 x23 - .60 x33 = 0

                                                .15 x13 + .15 x23 + .15 x33 = 0

            4.         Plant Capacity.

            (x11 + x12 + x13) + (x21 + x22 + x23) + (x31 + x32 + x33) = 100,000

            5.         Component Availabilities.               

                                                x11 + x12 + x13 ≤ 40,000

                                                x21 + x22 + x23 ≤ 25,000

                                                x31 + x32 + x33 ≤ 20,000

  

            6.         Minimum Production Level Requirements.

                                                x11 + x21 + x31≥ 10,000

                                                x12 + x22 + x32 ≥ 25,000

                                                x13 + x23 + x33 ≥ 30,000

            Nonnegativity.           All   xij ≥ 0 for   1 = 1, 2, 3, j = 1, 2, 3.


Related Solutions

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...
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...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into the Roasting Department. From the Roasting Department, coffee beans are then transferred to the Packing Department. The following is a partial work in process account of the Roasting Department at July 31: ACCOUNT Work in Process—Roasting Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit July 1 Bal., 5,400 units, 2/5 completed 10,476 31 Direct materials, 243,000 units 437,400 447,876 31 Direct labor...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into the Roasting Department. From the Roasting Department, coffee beans are then transferred to the Packing Department. The following is a partial work in process account of the Roasting Department at July 31: ACCOUNT Work in Process—Roasting Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit July 1 Bal., 5,400 units, 2/5 completed 13,392 31 Direct materials, 243,000 units 558,900 572,292 31 Direct labor...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into the Roasting Department. From the Roasting Department, coffee beans are then transferred to the Packing Department. The following is a partial work in process account of the Roasting Department at July 31: ACCOUNT Work in Process—Roasting Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit July 1 Bal., 4,900 units, 4/5 completed 6,958 31 Direct materials, 220,500 units 264,600 271,558 31 Direct labor...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into the Roasting Department. From the Roasting Department, coffee beans are then transferred to the Packing Department. The following is a partial work in process account of the Roasting Department at July 31: ACCOUNT Work in Process—Roasting Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit July 1 Bal., 30,000 units, 10% completed 121,800 31 Direct materials, 155,000 units 620,000 741,800 31 Direct labor...
Gourmet Coffee has an exclusive contract with distributors of coffee beans. Two brands of coffee beans...
Gourmet Coffee has an exclusive contract with distributors of coffee beans. Two brands of coffee beans are imported, Arabica and Robusta, and sold to retail outlets.   The monthly budget for the contract is based on a combination of last year’s performance, a forecast of general industry sales, and the company’s expected share of the Canadian market for imported coffee. The following information is provided for the month of May: Budgeted Actual Arabica Robusta Arabica Robusta Price per kg. $10.00 $12.00...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into the Roasting Department. From the Roasting Department, coffee beans are then transferred to the Packing Department. The following is a partial work in process account of the Roasting Department at July 31: ACCOUNT Work in Process—Roasting Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit July 1 Bal., 30,000 units, 10% completed 121,800 31 Direct materials, 155,000 units 620,000 741,800 31 Direct labor...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into the Roasting Department. From the Roasting Department, coffee beans are then transferred to the Packing Department. The following is a partial work in process account of the Roasting Department at July 31: ACCOUNT Work in Process—Roasting Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit July 1 Bal., 4,100 units, 2/5 completed 13,366 31 Direct materials, 184,500 units 553,500 566,866 31 Direct labor...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into...
Hana Coffee Company roasts and packs coffee beans. The process begins by placing coffee beans into the Roasting Department. From the Roasting Department, coffee beans are then transferred to the Packing Department. The following is a partial work in process account of the Roasting Department at July 31: ACCOUNT Work in Process—Roasting Department ACCOUNT NO. Date Item Debit Credit Balance Debit Credit July 1 Bal., 5,200 units, 1/5 completed 13,832 31 Direct materials, 234,000 units 608,400 622,232 31 Direct labor...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT