Hello, I'm a final-year engineering student. I need to train on exercises involving the integration of the AHP version of the rating model with a resource allocation problem.

Can you help me to solve this exercise, by detailing well your reasoning so that I can realize my errors and be ready for my future exam. (You'll need to provide the files or tools you used to solve the exercises, and if you add any assumptions to your calculations, please mention them).

BMGT DecisionWare Inc. (BDW) is a software consulting company that supplies services to business and government. It has a fairly active research program directed towards improving the company's internal operations. BDW is now going through its planning cycle to determine which internal information system projects suggested by its managers it should fund. Out of the 30 projects that were originally proposed, BDW's Software Development Board has selected 11 projects that it feels are meritorious candidates for funding. Of course, there is not enough money to do all 11! Also, each project requires an estimated level of programmer hours to complete, and it is clear that there are not enough programmer hours available to do all 11 projects. The Board needs some way of selecting a subset of the 11 that would be of most value to the company. The student is the analyst in this case. The Board wants to evaluate the projects in terms of the following three criteria: - Improving accuracy in its clerical operations. - Improving general information processing efficiency. - Promoting organizational learning. Figure 2.3 Intensity Levels for Probability of Success Figure 2.4 Intensity Levels for Market Share A further concern deals with the cost of each project and the number of programmer hours each project uses. For each of the projects, the project managers, working with the Board, have determined the following characteristics for each of the projects that are code-named P1, P2, .., P11. - The impact of each project with respect to its ability to improve accuracy evaluated in terms of High, Above Average, or Good. - The impact of each project with respect to improving efficiency evaluated in terms of Excellent, Very Good, Good, or Fair. - The impact of each project with respect to promoting organizational learning evaluated in terms of Yes, Maybe, or SoSo. The project managers have also estimated the cost of each project and the number of programmer hours required. A summary of the information on the projects is given in Table 2.2 . BDW has a budget of $500,000 and 7,500 programmer hours to allocate to the eleven internal projects. The student is to rank the eleven projects and determine the associated weights using the EC ratings mode, and then select the "best" subset of the eleven projects that does not exceed the total budget and available programmer hours by solving a twoconstraint 0-1 maximizing optimization (knapsack) problem. 2.3.1. Approach. The analysis of these 11 projects is carried out using the AHP and a subset of selected projects is presented to the Board. The Board approved the analysis and voted to accept the recommendations. 2.3.2. The Addition of a 12th Project. After the presentation, the President of BDW calls the student's Boss and asks the Boss to consider a twelfth project P12. P12 was proposed as one of the original 30 , but did not meet the initial cut. The manager who would run P12 is the President's daughter-inlaw. Also, the President's daughter-in-law believes that there is an excess of programmer hours and she is concerned that some programmers will have to be fired if only a subset of projects P1-P11 are selected. P12 has a low cost, but uses a lot of programmer hours (it uses low-level programmers who are at the low-end of the pay scale). The Boss wants the student to furnish some ammunition to shoot P12 down, as the Boss does not think much of the project. The information on P12 is the given in Table 2.3. The analysis is now repeated with the twelve projects. The student should compare both solutions and make a recommendation to the Boss. Question: Should the Boss shoot down P12