Linear Programming Model Assignment Questions
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
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