Reading Solver Output Target Cell (Max) Cell Name Original Value Final Value $B$
ID: 3266078 • Letter: R
Question
Reading Solver Output
Target Cell (Max)
Cell
Name
Original Value
Final Value
$B$12
Net profit to be maximized
0
85800
Adjustable Cells
Cell
Name
Original Value
Final Value
$B$10
Number of units Stock
0
9600
$C$10
Number of units Money Market
0
3000
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$B$15
Funds available
780000
$B$15<=$D$15
Not Binding
420000
$B$16
Min. Annual Income
60000
$B$16<=$D$16
Binding
0
$B$17
Min units in Money Market
3000
$B$17>=$D$17
Binding
0
How many decision variables are there?
How many constraints are there?
What is the value of the optimal solution?
What is the value of the objective function at the optimal solution?
Which are the binding constraints? (e.g., 1st, 2nd, etc.)
What is (are) the value(s) of the slack/surplus variable(s)?
Is (are) your answer(s) in 6. slack or surplus variable(s)? Why?
(sorry, there is something wrong with how i copied and pasted the problem so the questions are formatted like this)
Target Cell (Max)
Cell
Name
Original Value
Final Value
$B$12
Net profit to be maximized
0
85800
Adjustable Cells
Cell
Name
Original Value
Final Value
$B$10
Number of units Stock
0
9600
$C$10
Number of units Money Market
0
3000
Constraints
Cell
Name
Cell Value
Formula
Status
Slack
$B$15
Funds available
780000
$B$15<=$D$15
Not Binding
420000
$B$16
Min. Annual Income
60000
$B$16<=$D$16
Binding
0
$B$17
Min units in Money Market
3000
$B$17>=$D$17
Binding
0
How many decision variables are there?
How many constraints are there?
What is the value of the optimal solution?
What is the value of the objective function at the optimal solution?
Which are the binding constraints? (e.g., 1st, 2nd, etc.)
What is (are) the value(s) of the slack/surplus variable(s)?
Is (are) your answer(s) in 6. slack or surplus variable(s)? Why?
(sorry, there is something wrong with how i copied and pasted the problem so the questions are formatted like this)
Explanation / Answer
1) 2 decision variables are there:
Number of units Stock and Number of units Money Market
2) Number of constraints = 3
Value at optimal = 9600 and 3000
3) Obj function value = 85800
4) If a constraint is binding, then the corresponding slack or surplus value will equal zero.
So, constraint 2 and 3 are binding.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.