Question

In: Operations Management

The Molokai Nut Company (MNC) makes four different products from macadamia nuts grown in the Hawaiian...

The Molokai Nut Company (MNC) makes four different products from macadamia nuts grown in the Hawaiian Islands: chocolate-coated whole nuts (Whole), chocolate-coated nut clusters (Cluster), chocolate-coated nut crunch bars (Crunch), and plain roasted nuts (roasted). The company is barely able to keep up with the increasing demand for these products. However, increasing raw material prices and foreign competition are forcing MNC to watch its margins to ensure that it is operating in the most efficient manner possible. To meet marketing demands for the coming week, MNC needs to produce at least 1,000 pounds of the Whole product, between 400 and 500 pounds of the Cluster product, no more than 150 pounds of the Crunch product, and no more than 200 pounds of Roasted product. Each pound of the Whole, Cluster, Crunch and Roasted product contains, respectively, 60%, 40%, 20% and 100% macadamia nuts, with the remaining weight made up of chocolate coating. The company has 1,100 pounds of nuts and 800 pounds of chocolate available for use in the next week. The various products are made using four different machines that hull the nuts, roast the nuts, coat the nuts in chocolate (if needed), and package the products. The following table summarizes the time required by each product on each machine. Each machine has 60 hours of time available in the coming week.

Minutes Required per Pound

Machine

Whole

Cluster

Crunch

Roasted

Hulling

1.00

1.00

1.00

1.00

Roasting

2.00

1.50

1.00

1.75

Coating

1.00

0.70

0.20

0.00

Packaging

2.50

1.60

1.25

1.00

The selling price and variable cost associated with each pound of product is summarized below:

Per Pound Revenue and Costs

Whole

Cluster

Crunch

Roasted

Selling Price

$5.00

$4.00

$3.20

$4.50

Variable Cost

$3.15

$2.60

$2.16

$3.10

What is the optimal value the company could achieve?

Solutions

Expert Solution

The optimal value is determined by Solver as under:

Profit = Selling price - Variable cost

Formulas:

F2 =SUMPRODUCT(B2:E2,$B$16:$E$16) copy to F2:F12, F14

Optimal solution: the company should produce following quantities (in pounds) of the four variety of nuts

Whole = 1000

Cluster = 500

Crunch = 80

Roasted = 200

Total profit = $ 2913.20

keosha answered 1 year ago
Next > < Previous

Related Solutions

he Molokai Nut Company (MNC) makes four different products from macadamia nuts grown in the Hawaiian...
he Molokai Nut Company (MNC) makes four different products from macadamia nuts grown in the Hawaiian Islands: chocolate-coated whole nuts (Whole), chocolate-coated nut clusters (Cluster), chocolate-coated nut crunch bars (Crunch), and plain roasted nuts (Roasted). The company is barely able to keep up with the increasing demand for these products. However, increasing raw material prices and foreign competition are forcing MNC to watch its margins to ensure it is operating in the most efficient manner possible. To meet marketing demands...
Swifty’s Nut House is a processor and distributor of a variety of different nuts. The company...
Swifty’s Nut House is a processor and distributor of a variety of different nuts. The company buys nuts from around the world and roasts, seasons, and packages them for resale. Swifty’s Nut House currently offers 15 different types of nuts in one-pound bags through catalogs and gourmet shops. The company’s major cost is that of the raw nuts; however, the predominantly automated roasting and packing processes consume a substantial amount of manufacturing overhead cost. The company uses relatively little direct...
Nutty Nuts Company produces three nut mixers: Regular, Deluxe and Holiday. Currently Nutty Nuts has purchased...
Nutty Nuts Company produces three nut mixers: Regular, Deluxe and Holiday. Currently Nutty Nuts has purchased the following shipments of nuts at the prices shown Type of Nut Shipment Amount (lbs) Cost per Shipment Almond 6000 7500 Brazil 7500 7125 Filbert 7500 6750 Pecan 6000 7200 Walnut 7500 7875 The Regular Mix consists of 15% almonds, 25% Brazil nuts, 25% filberts, 10% pecans, and 25% walnuts. The Deluxe Mix consists of 20% of each type of nuts, the Holiday Mix...
Packages of mixed nuts made by a certain company contain four types of nuts. The percentages...
Packages of mixed nuts made by a certain company contain four types of nuts. The percentages of nuts of Types 1, 2, 3, and 4 are advertised to be 40%, 30%, 20%, and 10%, respectively. A random sample of nuts is selected, and each one is categorized by type. (a) If the sample size is n = 200 and the resulting test statistic value is X2 = 17.5, what conclusion would be appropriate for a significance level of 0.001? (Use...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average manufacturing cost of $49 per case (a case contains 24 cans of nuts). Kaune sold 155,000 cases last year to the following three classes of customer: Customer Price per Case Cases Sold Supermarkets $66   80,000   Small grocers 96   45,000   Convenience stores 88   30,000   The supermarkets require special labeling on each can costing $0.03 per can. They order through electronic data interchange (EDI), which costs...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average manufacturing cost of $51 per case (a case contains 24 cans of nuts). Kaune sold 160,000 cases last year to the following three classes of customer: Customer Price per Case Cases Sold Supermarkets $58   80,000   Small grocers 93   50,000   Convenience stores 93   30,000       The supermarkets require special labeling on each can costing $0.04 per can. They order through electronic data interchange (EDI), which costs...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average manufacturing cost of $50 per case (a case contains 24 cans of nuts). Kaune sold 153,000 cases last year to the following three classes of customer: Customer Price per Case Cases Sold Supermarkets $64   80,000   Small grocers 95   43,000   Convenience stores 89   30,000   The supermarkets require special labeling on each can costing $0.03 per can. They order through electronic data interchange (EDI), which costs...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average manufacturing cost of $50 per case (a case contains 24 cans of nuts). Kaune sold 154,000 cases last year to the following three classes of customer: Customer Price per Case Cases Sold Supermarkets $59 80,000 Small grocers 94 44,000 Convenience stores 91 30,000 The supermarkets require special labeling on each can costing $0.03 per can. They order through electronic data interchange (EDI), which costs...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average manufacturing cost of $51 per case (a case contains 24 cans of nuts). Kaune sold 160,000 cases last year to the following three classes of customer: Customer Price per Case Cases Sold Supermarkets $58   80,000   Small grocers 93   50,000   Convenience stores 93   30,000       The supermarkets require special labeling on each can costing $0.04 per can. They order through electronic data interchange (EDI), which costs...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average...
Costs of Different Customer Classes Kaune Food Products Company manufactures canned mixed nuts with an average manufacturing cost of $49 per case (a case contains 24 cans of nuts). Kaune sold 156,000 cases last year to the following three classes of customer: Customer Price per Case Cases Sold Supermarkets $63   80,000   Small grocers 96   46,000   Convenience stores 91   30,000   The supermarkets require special labeling on each can costing $0.02 per can. They order through electronic data interchange (EDI), which costs...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT