Chapter 8 Linear Programming Applications

Learning Objectives

After completing this chapter, students will be able to:

  1. 8.1 Formulate and solve LP problems with Excel Solver in marketing.

  2. 8.2 Formulate and solve LP problems with Excel Solver in production.

  3. 8.3 Formulate and solve LP problems with Excel Solver in the scheduling of employees.

  4. 8.4 Formulate and solve LP problems with Excel Solver in finance.

  5. 8.5 Formulate and solve LP problems with Excel Solver in the blending of ingredients.

  6. 8.6 Formulate and solve LP problems with Excel Solver in revenue management.

The graphical method of linear programming (LP) discussed in Chapter 7 is useful for understanding how to formulate and solve small LP problems. The purpose of this chapter is to go one step further and show how a large number of real-life problems can be modeled using LP. We do this by presenting examples of models in the areas of marketing research, media selection, production mix, labor scheduling, production scheduling, ingredient mix, and financial portfolio selection. We will solve many of these LP problems using Excel’s Solver and QM for Windows.

Although some of these models are relatively small numerically, the principles developed here are definitely applicable to larger problems. Moreover, this practice in “paraphrasing” LP model formulations should help you to develop skill in applying the technique to other, less common applications.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset