Question: Write a linear programming formulation for the following problem and solve it in Excel. The Silly Nut Company makes two mixtures of nuts: Mixture A

Write a linear programming formulation for the following problem and solve it in Excel.
The Silly Nut Company makes two mixtures of nuts: Mixture A and Mixture B. A pound of Mixture A contains 12 oz of peanuts, 3 oz of almonds and 1 oz of cashews and sells for $4. A pound of Mixture B contains 12 oz of peanuts, 2 oz of almonds and 2 oz of cashews and sells for $5. The company has 1080 lb. of peanuts, 240 lb. of almonds, 160 lb. of cashews. How many pounds of each of mixtures A and B should the company make to maximize profit?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

4) The Silly Nut Company makes two mixtures of nuts: Mixture A and Mixture B. A pound of Mixture A contains 12 oz of peanuts, 3 oz of almonds and 1 oz of cashews and sells for $4. A pound of Mixture...

Q:

In the rest of this chapter, we lead the reader through the formulation of several more complicated linear programming models. The most important step in formulating an LP model is the proper choice...

Q:

A security company has been commissioned to provide private security to five valuable assets (a1,a5). The company has currently five emplovees, as listed below: [ To provide security for an asset,...

Q:

The Crazy Nut Company sells two mixtures of nuts, Mixture A and Mixture B. A kilo of Mixture A contains 750g of peanuts, 187.5g of filberts and 62.5g of cashews and sells for 4. A kilo of Mixture B...

Q:

A company makes two mixtures of nuts: Mixture A and Mixture B. Mixture A contains 30% peanuts, 30% almonds and 40% cashews and sells for $5.00 per pound. Mixture B contains 30% peanuts, 60% almonds...

Q:

A company makes two mixtures of nuts: Mixture A and Mixture B. Mixture A contains 30% peanuts, 30% almonds and 40% cashews and sells for $3.25 per pound. Mixture B contains 30% peanuts, 60% almonds...

Q:

A company makes two mixtures of nuts: Mixture A and Mixture B . Mixture A contains 3 0 % peanuts, 3 0 % almonds and 4 0 % cashews and sells for $ 4 . 5 0 per pound. Mixture B contains 3 0 % peanuts,...

Q:

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Q:

My tutor that I Have been using for the past 5 weeks bailed on me with an assignment due tomorrow by 9PM Central USA time. There is 3 weeks left in this course. I am looking for someone that is...

Q:

3. Sweet Co. produces two types of candies; Energy candy and Happy candy. Ingredients for both candies are sugar, nuts and chocolate. Currently, the company has 100kg of sugar, 20kg of nuts and 30kg...

Q:

Write a note on Camp David agreements. A peace treaty between Egypt and Israel in which you need to address the following: Critically evaluate the criteria used to compare types of government,...

Q:

The financial information for Laurel Electronics referred to in Problem 3.5 is all at book value. Suppose marking to market reveals that the market value of the firms inventory is 20 percent below...

Q:

Mitchell Coach Manufacturing Company, Inc., produces motor homes and sells them to other retail dealers and directly to customers. Ronny Stephens was a customer. WW , Inc., bought and sold motor...

Q:

Assume it is Monday, May 1, the first business day of the month, and you have just been hired as the accountant for Colo Company, which operates with monthly accounting periods. All of the companys...