{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chap002A

Chap002A - Chapter 02A Linear Programming Using the Excel...

This preview shows pages 1–4. Sign up to view the full content.

Chapter 02A - Linear Programming Using the Excel Solver CHAPTER 2A LINEAR PROGRAMMING USING THE EXCEL SOLVER Problems Problem Type of Problem Difficulty New Problem Modified Problem Check Figure in Appendix A Excel Graphical Formu- lation 1 Yes Easy 2 Yes Easy Yes 3 Yes Yes Moderate 4 Yes Yes Moderate Yes 5 Yes Yes Moderate 6 Yes Yes Difficult 7 Yes Yes Moderate 8 Yes Moderate 9 Yes Moderate 10 Yes Moderate *Solution procedure modified. 13

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Chapter 02A - Linear Programming Using the Excel Solver 1. Excel Solution X Y Total Decision 6 0 Profit \$3 \$1 \$18 Resources X Y Used Capacity 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. 14
Chapter 02A - Linear Programming Using the Excel Solver 2. A B Total Decision 15 10 Profit \$2 \$4 \$70 Resources A B Used Capacity 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.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 9

Chap002A - Chapter 02A Linear Programming Using the Excel...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online