APPENDIX A
LINEAR PROGRAMMING USING THE EXCEL SOLVER
1. Excel Solution
X Y Total
Decision 6 0
Profit $3 $1 $18
Resources
X Y Used Capacit
y
A 12 14 72 <= 85
B 3 2 18 <= 18
C 1 0 <= 4
Graphical solution--the problem requested the Excel solution, but the following graphical
solution is provided for classroom use if desired.
,
,2.
A B Total
Decision 15 10
Profit $2 $4 $70
Resources
A B Used Capacit
y
A 4 6 120 >= 120
B 2 6 90 >= 72
C 1 10 >= 10
Graphical solution--the problem requested the Excel solution, but the following graphical
solution is provided for classroom use if desired.
,
LINEAR PROGRAMMING USING THE EXCEL SOLVER
1. Excel Solution
X Y Total
Decision 6 0
Profit $3 $1 $18
Resources
X Y Used Capacit
y
A 12 14 72 <= 85
B 3 2 18 <= 18
C 1 0 <= 4
Graphical solution--the problem requested the Excel solution, but the following graphical
solution is provided for classroom use if desired.
,
,2.
A B Total
Decision 15 10
Profit $2 $4 $70
Resources
A B Used Capacit
y
A 4 6 120 >= 120
B 2 6 90 >= 72
C 1 10 >= 10
Graphical solution--the problem requested the Excel solution, but the following graphical
solution is provided for classroom use if desired.
,
