New Excel Priority System from Lee Merkhofer Consulting and S.Chapel Associates
This is an opportunity to: (1) learn what a state of art priority systems look like, (2) learn about Multi-Objective Systems, (3) try our system at no cost or obligation, and (4) purchase the system at a fraction of the cost of other systems.
- Excel Priority System Software: Our system is based on Multi Objective Decision Analysis (MODA) and is implemented in Excel.
- For information on the MODA approach see the software brochure (link below) and Lee Merkhofer's website. Lee Merkhofer Consulting
- Demo Software is Available: Click here to Request Demo Software
- Excel Priority System Brochure: The brochure summarizes our approach to Project Priority Management MODA-Based Priority System
- Implementation: requires a minimum amount of outside help.
- State of Art: Project value based on Multi-Objective Decision Analysis (MODA)
- Inexpensive software license & free demo with no commitment obligation.
System Details: Choose the topics below:
Implementation Steps Model Setup Project Data Scoring Projects Analyzing Results
Implmentation requires a number of steps. These steps are described in detail in the software and include (1) setting up the software to reflect your organizations particular objectives and values and (2) organizing a team responsible for your Project Portfolio Management. Implementation also requires entering project data, scoring projects and analyzing the results.
The figure below is a screen shot from the Steps sheet in the software.
A MODEL SETUP
Model setup has five steps: 1. Specify Portfolio Objectives, 2. Define Project Types, 3. Identify Project Scorers, 4. Identify Project Contacts, and 5. Assign Weights. The model setup sheet has detailed instructions for each of these steps. There is also a "calibration" sheet that that is used to define the value associated with each score level. There are detailed instructions for calibration.
The figure below is a screen shot from the Model Setup sheet in the software.
Entering project data has five steps: 1. Specify the Budget Year, 2. List the Projects to be Prioritized, 3. Specify Contacts & Project Types,4. Identify Mandated Projects, and 5. Estimate Project Costs. Detailed instruction are provided on the Projects sheet.
The figure below is a screen shot from the Projects sheet in the software.
Scoring projects has two parts, MODA scoring and Quantitative scoring, MODA scoring has five steps and Qualitative scoring has six steps. Detailed instructions are provided on the MODA and Quantitative sheets.
The MODA scoring steps are: 1. Assemble the Team for MODA Scoring, 2. Identify Impacted Objectives, 3. Score Financial Impact, 4. Score Impacts on Other Objectives, and 5. Observe Computed Project Values. The Quantitative scoring steps are: 1. Assemble the Team for Quantitative Scoring, 2. Consider Using the MODA Ranking Score, 3. Assign Ranking Scores, 4. Assign Risk/Confidence Scores, 5. Assign Urgency Scores, and 6. Assign Benefit Timing Scores
The figure below is a screen shot from the MODA scoring sheet in the software.
Analysis is performed on the Priorities sheet and has seven recommended steps: 1. Set the Target Budget, 2. Explore the Value-Maximizing Portfolio, 3. Explore Selected Project Portolios , 4. Review the Charts, 5. Look for Scoring Errors, 6. Conduct Sensitivity Analyses, and 7. Report Results. Detailed instruction are provided on the sheet.
The figure below is a screen shot from the Priorities sheet in the software.