Question

In: Operations Management

Delicious Candy Company manufactures three types candy bars-Chompers, Smerks, and Delicious Chocolate. All three candies come...

Delicious Candy Company manufactures three types candy bars-Chompers, Smerks, and Delicious Chocolate. All three candies come in one-ounce size while Delicious Chocolate also comes in a one pound minibar bag. The basic ingredients used are chocolate, peanuts, and caramel. Delicious Chocolate is all chocolate, while Chompers consists of chocolate and caramel, and Smerks consists of chocolate, caramel and peanuts. Chompers’ recipe allows for the amount of caramel to be anywhere between 18% and 28% of the candy bar’s weight with chocolate making up the rest. Smerk’s recipe calls for an equal amount of caramel, and peanuts, with chocolate making up between 20% and 40% of the bar’s weight For each one-ounce bar, labor and packaging costs $0.012 while labor and packaging for the one-pound bag costs $0.039. The company has production facilities for making up to 20,000 one-ounce bars and up to 1000 one-pound bag daily. Delicious has contracts to produce at least 3000 one-ounce bars of each type of candy daily. Also the difference between the Chompers and the number of Smerks produced must be less than 10% of the total number of Chompers and Smekers made. The present prices for chocolate, caramel, and peanuts are $1.60, $0.95, and $1.40 per pound respectively. The company has contracts which will supply it with at least 1,000 pounds of chocolate, exactly350 pounds of caramel, and at most 500 pounds of peanuts daily. The company currently sells Chompers one-ounce bars for $ 0.14, Smerks one-ounce bars for $0.16, Delicious Chocolate one-ounce bars for $0.15, and Delicious Chocolate one-pound bags for $2.30. Formulate a linear program that would determine the optimal daily production schedule and ingredients required. (HINT: Variables must be established for each product type and the amount of each ingredient in each product.

Solutions

Expert Solution

Before making Linear Programing we have to fix the formulation of three candys. For that the best way is to keep the highest price ingradient to minimum % with in given range. Then the formula become

Ingradient for 1 pound cost for 1 ounce cost Chomper Smerk Delicious Chocolate-1O Delicious Chocolate-1P
Chocolate 1.6 0.1 72 20 100 100
Caramel 0.95 0.059375 28 40 0 0
Peanut 1.4 0.0875 0 40 0 0
Ingradient cost 0.088625 0.07875 0.1 1.6

Ingradients are in %

1ounce cost = 1pound cost/16

Now we can use Linear programming method to solve this

Quantiy of each variant in ounce can be denoted by

C- Chomper

S- Smerks

DO- Delicious Chocolate -1 ounce

DP- Delicious Chocolate -1 pound

Then Objective funtion should be

Max R = 0.14 xC + 0.16 x S + 0.15 x DO + DP/16 x 2.3

Constraints

0.72 C + 0.2 S+ 1.0 DO + 1.0DP <= 16000( 1000 pound =16000ounce)

0.28 C+ 0.40 S <= 5600

40S <=8000

C+S+DO <=20000

DP <=1000

C>=3000

S>=3000

DO>=3000

C-S <= 0.1 X (C+S)

This Problem can be solved by excel solver. For that we have to make tables like this

Variants Chomper Smerk Delicious Chocolate-1O Delicious Chocolate-1P
Qty
Rate 0.14 0.16 0.15 0.14375
Sale 0 0 0 0
Revenue 0
Chomper Smerk Delicious Chocolate-1O Delicious Chocolate-1P Total supply in pound supply in ounce
Chocolate 72 20 100 100 0 1000 16 16000
Caramel 28 40 0 0 0 350 16 5600
Peanut 0 40 0 0 0 500 16 8000

Here Revenue = sum of sale values. This is the target value in excel solver

Then select Max,

Variable cells are qty cells

Then enter the constraints as said above.

Then the Solution is

No. of Chomper one ounce pack = 3000

No. of Smerk one ounce Pack = 11900

No. of Delicious Chocolate one ounce pack =5100

No. of Delicious Chocolate one pound pack =397


Related Solutions

Chocolate Bars, Inc. (CBI), manufactures creamy deluxe chocolate candy bars. The firm has developed three distinct...
Chocolate Bars, Inc. (CBI), manufactures creamy deluxe chocolate candy bars. The firm has developed three distinct products: Almond Dream, Krispy Krackle, and Creamy Crunch. CBI is profitable, but management is quite concerned about the profitability of each product and the product costing methods currently employed. In particular, management questions whether the overhead allocation base of direct labor-hours accurately reflects the costs incurred during the production process of each product. In reviewing cost reports with the marketing manager, Steve Hoffman, who...
Chocolate Bars, Inc. (CBI), manufactures creamy deluxe chocolate candy bars. The firm has developed three distinct...
Chocolate Bars, Inc. (CBI), manufactures creamy deluxe chocolate candy bars. The firm has developed three distinct products: Almond Dream, Krispy Krackle, and Creamy Crunch. CBI is profitable, but management is quite concerned about the profitability of each product and the product costing methods currently employed. In particular, management questions whether the overhead allocation base of direct labor-hours accurately reflects the costs incurred during the production process of each product. In reviewing cost reports with the marketing manager, Steve Hoffman, who...
The sugar bear candy factory makes two types of chocolate candy bars milk chocolate and milk...
The sugar bear candy factory makes two types of chocolate candy bars milk chocolate and milk chocolate with almonds. In a typical day, 40% of the candy bars are being made of milk chocolate with almonds and the rest is plain milk chocolate. At the end of the day, a quality control expert randomly chooses 14 candy bars for inspection. a. What is the probability that fewer than 6 of the candy bars contained almonds? b.What is the probability that...
4) TURRONITIS S.A. It is a Valencia-based company that produces delicious hazelnuts and chocolate candies. The...
4) TURRONITIS S.A. It is a Valencia-based company that produces delicious hazelnuts and chocolate candies. The company decided to sell 200,000 boxes of candy products in Mexico. To this end, the administrator signed an agreement with 5 import companies that involves a profit margin of 15 % over the price charged to retailers. The agreement fixes FOB prices (in Valencia) in Euro. In addition, we know: Freight and insurance Valencia-Veracruz: € 1,202.02 Import duties: 9% over CIF value (Veracruz) Land...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by...
Cost of Production Report Venus Chocolate Company processes chocolate into candy bars. The process begins by placing direct materials (raw chocolate, milk, and sugar) into the Blending Department. All materials are placed into production at the beginning of the blending process. After blending, the milk chocolate is then transferred to the Molding Department, where the milk chocolate is formed into candy bars. The following is a partial work in process account of the Blending Department at March 31, 2016: ACCOUNT...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT