This is a variation of the preceding exercise. The head of the programming support group realizes that not all of the programmers in the group can work on each of the fourteen proposed projects. Specifically, three types of programming are required for the projects: Excel programming, Access programming, and C programming. Not all of programmers know each of these types of programming.

The following table shows the number of hours of each type of programming required for each project. There is a total of 9000 potential hours of Excel programming available, a total of 7200 potential hours of Access programming available, and a total of 3600 potential hours of C programming available. In addition, 9100 hours of total programming time are available to distribute across the three types of programming. Assume that the total benefit for a portfolio of projects is equal to the sum of the values for each project in the portfolio.

 

Transcribed Image Text:

Project 1. Mail list upgrade 2. Contact reporting 3. Com fix 4. Router bug Time Requirements Excel Access C Benefit 0.08 0.20 0.19 0.21 0.27 1000 5. Accounting interface 6. Scheduler A 0.15 600 7. Scheduler B 19 0.37 1500 0.44 3000 0.40 0.32 0.50 1000 3000 0.51 2000 1000 1200 0.76 8. On-line manuals 9. WAN upgrade 10. Print queue fix 11. EIS prototype 12. GDSS prototype 13. Contact management 0.45 14. Real-time sales CONSTRAINTS: 9000 200 500 250 400 1000 500 2700 1000 2700 350 3000 1500 7200 3600 Determine the portfolio of projects that provides the largest benefit sub- ject to the constraints on the amount of programming time of each type that is available in addition to the constraint on the total number of hours of programming time that is available. Project 1. Mail list upgrade 2. Contact reporting 3. Com fix 4. Router bug Time Requirements Excel Access C Benefit 0.08 0.20 0.19 0.21 0.27 1000 5. Accounting interface 6. Scheduler A 0.15 600 7. Scheduler B 19 0.37 1500 0.44 3000 0.40 0.32 0.50 1000 3000 0.51 2000 1000 1200 0.76 8. On-line manuals 9. WAN upgrade 10. Print queue fix 11. EIS prototype 12. GDSS prototype 13. Contact management 0.45 14. Real-time sales CONSTRAINTS: 9000 200 500 250 400 1000 500 2700 1000 2700 350 3000 1500 7200 3600 Determine the portfolio of projects that provides the largest benefit sub- ject to the constraints on the amount of programming time of each type that is available in addition to the constraint on the total number of hours of programming time that is available.

Answer rating: 100% (QA)

Solution The optimal solution for this problem is Scheduler A and B The portfolio of projects consis... View the full answer