Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data Analysis ?, Solver New Get External Existing Refresh 21 Sort Filter Data Forecast Outline Query . Data - Connections All - Tools Get &
Data Analysis ?, Solver New Get External Existing Refresh 21 Sort Filter Data Forecast Outline Query . Data - Connections All - Tools Get & Transform Get External Data Connections Sort & Filter Analyze A1 X V Microsoft Excel 16.0 Answer Report A B C D E F G | H IJ K L Worksheet: [Example 10. 1.xIsx]Linear Programming Report Created: 2/15/2016 6:09:26 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.078 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $JK: Objective Function [Cj] 0 6900000 19 Variable Cells 20 Cell Name Original Value Final Value Integer 21 $B$ Solution (X] HMO 0 5000 Contin 22 $C$ Solution [Xi] Indemnity 1500 Contin 23 $D$ Solution [Xi] Decision Variables (Xi] 0 Contin 24 $E$ Solution [Xi] 0 0 Contin 25 $F$ Solution [Xi] 0 Contin 26 27 28 Constraints 29 Cell Name Cell Value Formula Status Slack $J$ Administrative support 1600000 $J$4=$H$5 Not Binding 18+06 32 $JSf Enrollees 5000 $J$6
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started