File Home Insert Page Layout Formulas Data Review View Help Share Comme ? Solver Le From Text/CSV Le From Web From Table/Range Recent Sources le Existing Connections HAI MEH 21 AL Y clear Clear Te Reapply Advanced Queries & Connections B Properties Refresh All Edit Links Queries & Connections 5 ! Group Ungroup Subtotal + - Get Data Stocks Sort Geography Z 21 Filter Text to Columns EO What If Forecast Analysis Sheet Get & Transform Data Data Types Sort & Filter Data Tools Forecast Outline Analyze E6 Solver Parameters A B D E F G 0 R S T 1 Set Objective: SES6 d 2 Blue Ridge Hot Tubs To: 3 O Max O Min 0 O Value Of: 4 By Changing Variable Cells: Sb$5:$d$5 1 Constraint Avaliable 200 1566 Subject to the Constraints: SB$5:$DS5 >= 0 SESO:SE$11 . Wrap Text General 49 O 3 X Cut [ Format Painter Fill Paste BIU A ESE Ideas Insert Delete Format $ % -28 Merge & Center .00 .000 Sensitivity Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity 12 X H K L M N o P Q R S T U V w Y A B DE F G 1 Microsoft Excel 16.0 Limits Report 2 Worksheet: [MGMT414_Lab_Figure4.8_{mmakar).xlsx]Robust Solution 3 Report Created: 2/11/2021 1:08:42 PM 4 5 6 7 Objective Cell Name $E$6 Unit Profits Total Profit Value 66100 8 9 10 11 12 Lower Objective Limit Result 13 Variable Cell Name $B$5 Number to Make Aqua-Spas $C$5 Number to Make Hydro-Luxes $D$5 Number to Make Typhoon-Lagoons Value 122 78 0 Upper Objective Limit Result 122 66100 78 66100 0 66100 14 23400 42700 66100 0 15 0 0 16 17 18 19 20 21 22 23 24 25 26 27 28 20 | Answer Report 1 | Sensitivity Report 1 Limits Report 1 Sheet 1 # O Ready A + 100 File Home Insert Page Layout Formulas Data Review View Help Share Commer Calibri AutoSum 11 A A == y > Wrap Text General S IX X Cut LB Copy L Format Painter WE 47 0 Fill Paste BIU Ideas A Insert Delete Format $ -% -28 Sensitivity EE Merge & Center 000 Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity A1 X for Microsoft Excel 16.0 Sensitivity Report 1 J K L M N P Q R s T U Tv A B D E E F G H 1 Microsoft Excel 16.0 Sensitivity Report 2 Worksheet: [MGMT414_Lab_Figure4.8_{mmakar}.xlsx]Robust Solution 3 Report Created: 2/11/2021 1:08:41 PM 4 5 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $B$5 Number to Make Aqua-Spas 122 0 350 100 20 10 $C$5 Number to Make Hydro-Luxes 78 0 300 50 40 11 $D$5 Number to Make Typhoon-Lagoons 0 -13.33333333 320 13.33333333 1E+30 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $E$9 Pups Req'd Used 200 200 200 7 26 17 $E$10 Labor Req'd Used 1566 16.66666667 1566 234 126 18 $E$11 Tubing Req'd Used 2712 0 2880 1E+30 168 19 20 21 22 23 24 25 26 27 28 20 Answer Report 1 Sensitivity Report 1 Limits Report 1 Sheet 1 + u Ready FI + 10 File Home Insert Page Layout Formulas Data Review View Help Share Commen Calibri == AutoSum > . ab Wrap Text General 49 O 11 JAA CA X Cut [ Format Painter 3 Fill Paste .00 BIU Ideas SES $ % 8-23 Insert Delete Format Merge & Center Sensitivity Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity A1 X Microsoft Excel 16.0 Answer Report F H 1 J K L L M N o P o R S T U V A B C D E G 1 Microsoft Excel 16.0 Answer Report 2 Worksheet: [MGMT414_Lab_Figure4.8_{mmakar}.xlsx]Robust Solution 3 Report Created: 2/11/2021 1:08:41 PM 4 Result: Solver found a solution. All Constraints and optimality conditions are satisfied. 5 Solver Engine 6 Engine: Simplex LP 7 Solution Time: 0.125 Seconds. 8 Iterations: 2 Subproblems: 0 9 Solver Options 10 Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling 11 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative 12 13 14 Objective Cell (Max) 15 Cell Name Original Value Final Value 16 $E$6 Unit Profits Total Profit 66100 66100 17 122 18 19 Variable Cells 20 Cell Name Original Value Final Value Integer 21 $B$5 Number to Make Aqua-Spas 122 Contin 22 $C$5 Number to Make Hydro-Luxes 78 78 Contin 23 $D$5 Number to Make Typhoon-Lagoons 0 O Contin 24 25 26 Constraints 27 Cell Name Cell Value Formula Status 28 $E$9 Pups Req'd Used 200 $E$9