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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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. 15
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/17/2011 for the course MBA 587 taught by Professor None during the Spring '11 term at Missouri (Mizzou).

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 Right Arrow Icon
Ask a homework question - tutors are online