Company packages and sells three different canned party

Assignment Help Operation Management

Reference no: EM132289450

A snack company packages and sells three different canned party mixes that contain a total of 1 lb. of nuts. These three different products (Plain Nuts, Mixed Nuts, and Premium Mix) include a mix of four possible types of nuts (peanuts, cashews, almonds, and walnuts). The table below show the number of lbs. of each ingredient in each product type, the amount of ingredient available, and the revenue generated by selling each type of product. What should their production plan be to maximize their revenue? There is on additional piece of information that impacts their production plan and should be included in your formulation. Past demand indicates customers purchase at least three times as many cans of Plain Nuts as Mixed Nuts. Your formulation should include a constraint that states that the number of cans of Plain Nuts produced should be at least three times the number of cans of Mixed Nuts produced. Formulate and solve the problem in Excel to determine the number of each product to produce that meets the requirements and maximizes revenues. (Note: Consider this an average amount of cans produced – the number of cans does not need to be an integer). PRODUCT INGREDIENTS PLAIN NUTS MIXED NUTS PREMIUM MIX INGREDIENT AVAILABILITY (lbs.) PEANUTS (lbs./can) 0.8 0.25 500 CASHEWS (lbs./can) 0.2 0.25 0.2 300 ALMONDS (lbs./can) 0.25 0.4 120 WALNUTS (lbs./can) 0.25 0.4 100 REVENUE ($/UNIT) $2.25 $5.65 $7.85 a) What is the maximum revenue based on your optimal solution (the value of the objective function)? b) How many cans of Plain Nuts should be produced based on your optimal solution (enter two decimal places)? c) How many cans of Mixed Nuts should be produced based on your optimal solution (enter two decimal places)?? d) How many cans of Premium Mix should be produced based on your optimal solution (enter two decimal places)?? e) After producing the number of cans of each product as suggested in your optimal solution, which of the ingredients has not been totally used by your production plan?

Reference no: EM132289450

Questions Cloud

Customer service strategy : What are the service advantages to customers when a business sets its goals and strategies based on the findings from a comprehensive SWOT analysis?

One way to ensure content is digestible : Centering you content around blogging provides the following benefits. One way to ensure content is digestible is to.

The indian service outsourcing firms supporting pfizer works : Describe what Pfizer had to accomplish when setting up and implementing the teams at the Indian service outsourcing firms supporting Pfizer works.

How should Roberts Cellars handle the TCA problem : How should Roberts Cellars handle the TCA problem? Why do you advocate this direction? ?What roles should Max, Sierra, Nick and Lara play in finalizing the TC

Company packages and sells three different canned party : A snack company packages and sells three different canned party mixes that contain a total of 1 lb. of nuts.

Hiring worker in perfect competitive market form : Explain graphically, at what point the firm should stop hiring worker in a perfect competitive market form.

When writing formal business report : When writing a formal business report, you should begin by __________.

Sold worthless stocks to unsuspecting customers : Two stockbrokers, in clear violation of the rules of their employer, sold worthless stocks to unsuspecting customers.

Discuss every Court in which Brett can file suit against GBC : GBC has its principal place of business and is incorporated in Wisconsin. Discuss every Court in which Brett can file suit against GBC?

User Account

All Pages