Question: Excel's Solver tool has been used in the spreadsheet below to solve a linear programming problem with a maximization objective function and all < =

Excel's Solver tool has been used in the spreadsheet below to solve a linear programming problem with a maximization objective function and all <= constraints.
Input Section
Objective Function Coefficients
X
Y
4
6
Constraints
Avail.
#1
3
5
60
#2
3
2
48
#3
1
1
20
Output Section
Variables
13.333333
4
Profit
53.333333
24
77.333333
Constraint
Usage
Slack
#1
60
1.789E-11
#2
48
-2.69E-11
#3
17.333333
2.6666667

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!