Official© Solutions Manual to Accompany Operations and Supply Chain Management,Jacobs,15e

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

Cost $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.

,