Question: Use a goal programming model to determine the composition of sausage. EXCEL PLEASE! 6. Based on Steuer (1984). Deancorp produces sausage by blending beef head,

Use a goal programming model to determine the composition of sausage. EXCEL PLEASE!

6. Based on Steuer (1984). Deancorp produces sausage by blending beef head, pork chuck, mutton, and water. The cost per pound, fat per pound, and protein per pound for these ingredients are listed in the file P16_06.xlsx. Deancorp needs to produce 1000 pounds of sausage and has set the following goals, listed in order of priority: Goal 1: Sausage should consist of at least 15% protein. Goal 2: Sausage should consist of at most 8% fat. Goal 3: Cost per pound of sausage should not exceed $0.06. Use a goal programming model to determine the com- position of sausage. Problem. Solve problem 16.6 on p. 16-11 (a suggested template is presented below). Problem 16.6. Sausage production (p. 16-11) Protein Fat Cost ($) Beef 0.20 0.05 0.12 Pork 0.26 0.24 0.09 Mutton 0.08 0.11 0.08 Water 0 0 0 Beef Pork Mutton Water Total Required Used (lbs) Under Over Net Goal Goals Total Protein Total Fat Total Cost Achieved 0.000 0.000 0.000 Nominal goal 15% 8% $0.06 Deviations Already attained Protein Fat Cost Prionty 1 2 3

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!

Based on Steuer (1984). Deancorp produces sausage by blending beef head, pork chuck, mutton, and water. The cost per pound, fat per pound, and protein per pound for these ingredients are listed in...

Based on Steur (1984). Deancorp produces sausage by blending beef head, pork chuck, mutton, and water. The cost per pound, fat per pound, and protein per pound for these ingredients are listed in the...

If you solve by hand I'll downvote. Deancorp produces sausage by blending together beef head, pork chuck, mutton, and water. The cost per pound, fat per pound, and protein per pound for these...

5 Deancorp produces sausage by blending together beef head, pork chuck, mutton, and water. The cost per pound, fat per pound, and protein per pound for these ingredients is given in Table 5 9 ....

5 Deancorp produces sausage by blending together beef head, pork chuck, mutton, and water. The cost per pound, fat per pound, and protein per pound for these ingredients is given in Table 59....

Assume that Melesha Electronics must determine how many LCD TVs and Sound System Players to stock. It costs Melesha Birr 13,000.00 to purchase a LCD TV and Birr 12,000.00 to purchase a Sound System...

UNIT V STUDY GUIDE Programming and Transportation Course Learning Outcomes for Unit V Upon completion of this unit, students should be able to: 1. Identify the major steps in decision making for...

(a) Formulate a goal programming model for this problem. (b) Reformulate this model as a linear programming model. (c) Use the Excel Solver to solve this model. (Take print screen of your Excel...

Problem 14-03 (Algorithmic) The L. Young & Sons Marvutacturing Company produces two products, which have the following profit and resource requirement characteristics: Characteristic Product 1...

In a constant-cost industry each firms MC curve is upward sloping, yet all the firms togetherthe industryhave a hor-zontal supply curve. Explain why there is no contradiction.

Wilson's Auto, Inc., has 37 employees and a weekly payroll of $10,878. If each employee makes the same amount, how much does each make?

Shown below is the activity for one of the products of Random Creations: denuary 1 bslance. 8 5 units 9 $ 0 0 $ 5 , 1 0 0 Purchaser: denuary 1 8 : 7 7 units o $ 6 0 January 2 8 : 7 7 units e $ 6 1...

for the rational function r(x), which is defined as follows on the following domain R(x) = 2x^3+8x^2-19x+24/x^2+x-56 , domain is (,8)(8,7)(7,), explain why the values where there is a union at are...