Question: please answer a through g, show all steps everything necessary to amswer the question A manufacturing company produces cat food products. These products are produced

please answer a through g, show all steps everything necessary to amswer the question
please answer a through g, show all steps
please answer a through g, show all steps
A manufacturing company produces cat food products. These products are produced in batches and kept at a warehouse then shipped to pet stores. The manager has developed a LP model of the process for the company's three raw materials: M, M3 and M. The LP algebraic formulation is given below: Let Mi - number of bags of raw material i, where i=1, 2 and 3. Minimize 2 - 540M + $30M, SSOM, (Cost) Subject to 2M; + Mz+ 2M, 2 600 pounds (Fat Requirement) 2.5M; +4M3+ 3M, 2 794 pounds (Protein Requirement) 3M + 2Mz+ 4M: 2 300 pounds (Fiber Requirement) Ms, M3, M: 20 The manager did obtain the Excel Solver Sensitivity Report for the model. Variable Cells Final Reduced Objective Allowable Allowable Name Value Coefficient Increase Decrease $8$2 Solutions Bags of Raw Material 1 292 40 9 21.25 $C$2 Solutions Bags of Raw Material 2 30 34 10 $D$2 Solutions Bags of Raw Material 3 8.182 50 1E30 8.182 Cell Cost 0 0 16 0 Constraints Cell Name $E$6 Fat Constraint Total $E$7 Protein Constraint. Total $E$8 Fiber Constraint Total Final Value 600 794 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 15.455 600 35.2 4015 794 1606 44 0 300 608 1E430 3.636 908 Answer all the following questions about the model. Note that each question below is to be considered independently of all others. (a) How many pounds of protein are available in ONE bag of Material 2? (2 points) (b) What is the optimal value of the objective function, and what are the optimal values of the decision variables? (4 points) (c) Which constraint() has(ve) slack/surplus and how much? (3 points) (d) What effect would a decrease of $5 in the cost per bag of raw material 2 have on the optimal solution and its cost? Justify. (4 points) (e) If the requirement for protein increases to 1000 pounds. What would be the impact on the optimal solution and its cost? Justify and show your calculations for impact on the objective function. (5 points) () The manager wants to see some use of raw material 3 into the process. If she/he can negotiate a better cost for procuring raw material 3, then what is the cost per bag that she/he should target? Justify (3 points) (g) The manager is considering reducing EACH Right-Hand Side (RHS) by 4% and is asking you to provide information on how that would impact the total cost. If you can determine what the new optimal value of the objective function is then do so, explaining why your approach is correct. If you cannot determine the new optimal value of the objective function, explain why. (6 points)

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!