Answer 1-A and 1-B PROBLEM 1: Bouncy Paws 2 Worksheet: [EXAM 1 excel.xdsx)1. Bou

Question

Answer 1-A and 1-B

PROBLEM 1: Bouncy Paws 2 Worksheet: [EXAM 1 excel.xdsx)1. Bouncy Paws 3Report Created: 10/24/2016 4:40:10 PM 4 Result: Solver found a solution. All constraints and optimality conditions are satisfied. 5 Engine: Standard LP/Quadratic 6 Solution Time: 00 Seconds 1-a. Which constraints have no excess? 8 Subproblems: 0 Incumbent Solutions: 0 9 1-b. Which constraints show slack? 2 Objective Cell (Max) 3 Cell 4 SES7 Unit Profits Total Profit Original Value 160 Name Final Value 160 7 Decision Variable Cells 8 Cell 9 SBS6 Number to Make Dog Treat 0 SC$6 Number to Make Cat Treat Original Value Final Value Type 16.6716.67 Normal Name 6.67 6.67 Normal 2 Constraints 3 Cell 4 SD$11 Chicken(oz) Used 5 SDS12 Soybeans (oz) Used 6 SD$13 Cranberries (oz) Used 7 SD$14 Dog treat demand Used 8 $D$15 Cat treat demand Used Cell Value Slack Formula 100.00 SD$11-SE$11 Bindi 120.00 SD$12 SES12 Bindi Name Status 133.33 SDS13

Explanation / Answer

Table 3 shows details on constraint:

1-a) No excess: Chicken and Soyabeans as the slack value is zero

1-b) Slack: Cranberries, Dog treat, Cat treat as all these three have slack

Also, the difference is in status. The items having Slack are non-binding and those without Slack are binding.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---