The homework problems for Module 4 are: 2-24, 34, 36, 38 (you only have to do part A for these problems. You do not have to do the part B graphical solutions) and 3-10, 12 (parts B and C for Problem 12), 28, 30. Please use Excel solver function.

I posted an annotated solution to Problem 2-5. This problem is an examplar for both the chapter 2 and 3 problems. In this example I show how I typically set up a problem. First I set up the linear programming model and then develop a parallel set-up to use as input to the Solver add-in. I use this strategy because I first like to set up the problem solution before I worry about setting up the parameters for using Solver. 24. Universal Claims Processors processes insurance claims for large national insurance companies. Most claim processing is done by a large pool of computer operators, some of whom are perma-nent and some of whom are temporary. A permanent operator can process 16 claims per day, whereas a temporary operator can process 12 per day, and on average the company processes at least 450 claims each day. The company has 40 computer workstations. A permanent operator generates about 0.5 claim with errors each day, whereas a temporary operator averages about 1.4 defective claims per day. The company wants to limit claims with errors to 25 per day. A per-manent operator is paid $ 64 per day, and a temporary operator is paid $ 42 per day. The company wants to determine the number of permanent and temporary operators to hire in order to mini-mize costs. a. Formulate a linear programming model for this problem.

34. Gillian’s Restaurant has an ice- cream counter where it sells two main products, ice cream and frozen yogurt, each in a variety of flavors. The restaurant makes one order for ice cream and yogurt each week, and the store has enough freezer space for 115 gallons total of both products. A gallon of frozen yogurt costs $ 0.75 and a gallon of ice cream costs $ 0.93, and the restaurant budgets $ 90...

...RESEARCH PAPER ON
LINEARPROGRAMMING
Vikas Vasam
ID: 100-11-5919
Faculty: Prof. Dr Goran Trajkovski
CMP 561: Algorithm Analysis
VIRGINIA INTERNATIONAL UNIVERSITY
Introduction:
One of the section of mathematical programming is linearprogramming.
Methods and linearprogrammingmodels are widely used...

...Q.1. What is a linearprogramming problem ? Discuss the steps and role of linearprogramming is solving management problems. Discuss and describe the role of liner programming in managerial decision-making bringing out limitations, if any.
Ans : LinearProgramming is a mathematical technique useful for allocation of scarce or limited resources to several competing activities on the basis of...

...TOPIC – LINEARPROGRAMMINGLinearProgramming is a mathematical procedure for determining optimal allocation of scarce resources.
Requirements of LinearProgramming
• all problems seek to maximize or minimize some quantity
• The presence of restrictions or constraints
• There must be alternative courses of action
• The objective and constraints in...

...
LinearProgramming
After completing this chapter you should be able to:
identify a product which maximises the contribution per unit of scarce resource when there is only one scarce resource, and determine the optimum solution.
formulate an LP model to solve for the optimal product mix which maximises profits, or for cost minimisation problems to minimise costs.
solve 2 variable problems graphically.
use a spreadsheet to solve LP...

...LINEARPROGRAMMING
INTRODUCTION:
The term ‛programming′ means planning and it refers to a particular plan of action amongst several alternatives for maximizing profit or minimizing cost etc. Programming problems deal with determining optimal allocation of limited resources to meet the given objectives, such as cost, maximum profit, highest margin or least time, when resources have alternative uses.
The term...

...Spreadsheet Modeling and Excel Solver A mathematical model implemented in a spreadsheet is called a spreadsheet model. Major spreadsheet packages come with a built-in optimization tool called Solver. Now we demonstrate how to use Excel spreadsheet modeling and Solver to find the optimal solution of optimization problems. If the model has two variables, the graphical method can be used to solve the model. Very few real world problems...

...Method
of LinearProgramming
Tutorial Outline
CONVERTING THE CONSTRAINTS TO
EQUATIONS
SOLVING MINIMIZATION PROBLEMS
SETTING UP THE FIRST SIMPLEX TABLEAU
KEY TERMS
SIMPLEX SOLUTION PROCEDURES
SOLVED PROBLEM
SUMMARY OF SIMPLEX STEPS FOR
MAXIMIZATION PROBLEMS
DISCUSSION QUESTIONS
ARTIFICIAL AND SURPLUS VARIABLES
SUMMARY
PROBLEMS
3
T 3-2 O N L I N E T U T O R I A L 3
THE SIMPLEX METHOD
OF
L I N E A R P RO...