Answer 2-A and 2-B Problem 2: Cool Dorm Design 1 Microsoft Excel 16.0 Answer Rep
ID: 348821 • Letter: A
Question
Answer 2-A and 2-B
Problem 2: Cool Dorm Design 1 Microsoft Excel 16.0 Answer Report 2 Worksheet: [EXAM 1 excel.xlsx]Cool Dorm 3 Report Created: 10/25/2016 10:00:42 AM 4 Result: Solver found a solution. All constraints and optimality conditions are satisfied 5 Engine: Standard LP/Quadratic 6 Solution Time: 00 Seconds 7 Iterations: 0 8 Subproblems: 0 9 Incumbent Solutions: 0 10 2-a. Which constraints have no excess? 2-b. Which constraints show slack? 12 Objective Cell (Max) 13 Cell 14 $ES9 Unit Profits Total Profit 15 16 17 Decision Variable Cells 18 Cell 19 $B$8 Number to Make Stand 20 SC$8 Number to Make Cubes 21 22 Constraints 23 Cell Original Value 250 Name Final Value 250 Name Original Value Final Value Type 0.00 Normal 5.00 Normal 0.00 5.00 Name lue Formula Status Slack SD$12 Mold Processing Used2 20.00 $D$12 SE$12 Not Binding 16 0 5 SDS13 Finishing Used 6 SDS14 Stands Demand Used 7 $B$8 Number to Make Stand 28 $C$8 Number to Make Cubes 0.00 SD$13-SE$13 Binding 5.00 SD$14-SE$14 Not Binding 5 0.00 SBS8>=0 5.00 $C$8>=0 Binding Not Binding 5 0Explanation / Answer
Refer third table of constraints. Those who are binding have no excess and others have slack
2-a) No excess: Finishing used and Number to make stand
2-b) Have slack: Mold processing used, Stands demand used, Number to make cubes