An excerpt from my latest book, Everything is a Process. Available on Amazon.

I have twenty potential projects at my company. Which are the ones that provide the greatest benefit to the company and should be completed first?

Most people have heard a quote similar to that above. Where is the best place to spend effort to achieve results? This simple Excel tool provides a way of visually seeing all the projects and the value they bring based on a set of benefit and effort questions that are completed by a team of people in your organization.

Start with the Benefit Table

You start by looking at the Benefit Table worksheet. This table defines seven different benefits of a project.

  • Revenue enhancement ($) – Will this positively impact the revenue of the company?
  • Reduce Cost or Cost Avoidance within Company – Will this reduce costs within the Company by decreasing or avoiding time, labor, supplies, travel?
  • Increase speed of delivery – Will this improve our ability to deliver results to our customers faster?
  • Strategic Importance – Is this aligned with the Company strategy?
  • Amount of Client Services “Pain” – What is the level of negative impact the process currently has on client services?
  • Client Value – Does this deliver additional value to our clients? Or does this deliver savings to our client?
  • Business Unit Impact – What is the scope of the project/project impact across business units?

Benefit Priority Worksheet

Benefit – for each of the below measures, rate the relative impact that the project will have on the respective measure by rating as 0, 3, 6 or 9. Benefits are annualized.

MeasureDescription0369
Revenue enhancement ($)Will this positively impact the revenue of the Company?No impactSmall < $500,000Medium $500,000 – $5,000,000Large > $5,000,000
Reduce Cost or Cost Avoidance within CompanyWill this reduce costs within the Company by decreasing or avoiding time, labor, supplies, travel?No impactSmall < $50,000Medium $50,000 – $500,000Large > $500,000
Increase speed of delivery (i.e., process bills faster)Will this improve our ability to deliver results to our customers faster?No impactSmallMediumLarge
Strategic ImportanceIs this aligned with the Company product strategy of. Insert your strategy such as: reducing cost, increasing speed, reducing errors, regulatory, etc.Not linked to product or strategyLinked to two itemsLinked to three itemsLinked to all four items
Amount of Client Services “Pain”Level of negative impact process currently has on client servicesNo impactSmallMediumLarge
Client ValueDoes this deliver additional value to our clients? OR Does this deliver savings to our client?Client not aware of any additional valueClient sees that this will add value to their offering from the companyClient considers this critical as it brings great value to there offering from the company. Without this, there is a potential for client attrition.Client considers this critical. Without this, client attrition is eminent.
Business Unit ImpactThe scope of the project/project impact across business unitsNo impactImpact across two departments in a single business unitImpact on an entire Business UnitImpact across two or more Business Units
Table 1: Benefit Priority Worksheet

Rank each of these benefits for your projects. The ranking is a score of 0, 3, 6, or 9. For example, revenue enhancement is broken out as follows:

  • Score of 0 – no impact
  • Score of 3 – Impact < $500,000
  • Score of 6 – Impact > $500,000 and < $5,000,000
  • Score of 9 – Impact > $5,000,000

In this example, with an expected benefit of greater than $5,000,000 it would be scored as 9. If the trigger values do not work for your organization, change them to be more meaningful. For example, maybe $5,000,000 is too much and $700,000 would be more appropriate as the highest figure. Then change the trigger values to fit. You do this for each of the benefits shown in the table.

Effort Table

Next, you want to review the Effort Table. The effort table describes six different types of effort:

  • Personnel Requirements – What are the average number of FTE’s (full time equivalent people) required to execute the project (independent of project duration)
  • Project Duration – what are the number of weeks from start date to end date of the project?
  • Budget Available – Are there budgeted funds available to support this effort?
  • Capital Investment ($MM) – Are there any incremental capital expenditures or other costs that are required to implement the project?
  • Risk Projection – What is the probability of not succeeding due to issues with respect to schedule, budget, customer requirements, etc.?
  • Business Unit Impact – What is the effort and coordination required across departments and Business Units?

Effort – For each category below, rate the relative level of effort (using a 0, 3, 6, or 9) required to meet the projects requirements. Lower scores Indicate that less effort is required.

MeasureDescription0369
Personnel RequirementsThe average number of FTEs (full time equivalent people) required to execute the project (independent of project duration)1-33-66-12>12
Project DurationThe number of weeks from start date to end date of the project.< 6 weeks7-12 weeks13-25 weeks26 weeks
Budget AvailableAre there budgeted funds available to support this effort?Fully covered in current baseline budgetBusiness case funded by $ in the baseline budgetBudget approved but not yet fundedNo current funding
Capital Investment ($MM)Are there any incremental capital expenditures or other costs that are required to implement the project? No capitalSmall <$1,000Medium $1,000-$10,000Large >$10,000
Risk ProjectionWhat is the probability of not succeeding due to issues with respect to schedule, budget, customer requirements, etc.?NoneLowMediumHigh
Business Unit ImpactWhat is the effort and coordination required across departments and Business Units?NoneTwo department in a single Business UnitEntire Business UnitMore than one Business Unit
Table 2: Effort Table Worksheet

For example, personnel requirements are defined as follows:

  • Score of 0 – 1-3 people
  • Score of 3 – 3-6 people
  • Score of 6 – 6-12 people
  • Score of 9 – > 12 people

If the project requires 7 people it would be scored as a 6. You continue this activity for each benefit in the table.

Project Rating Worksheet

Copy your scores into the project rating worksheet. There is a weighting factor shown in red at the top of each column that I use as a default. If you want more exact weighting factors for your business, I suggest you perform the Analytical Hierarchy Process to calculate your own.

Project Rating Worksheet
Figure 1: Project Rating Worksheet

Benefit/Effort Chart

Once you have your scores in the project rating worksheet the software will automatically plot each project. The results will look something like what is shown in Figure 2. Now you have your projects in a pictorial format showing the benefit and effort for each project. The dotted box in the top middle represents the sweet spot. These are projects that are low to medium effort with medium to high benefit. The dotted box on the far left identifies those projects which would be suitable for a Kaizen effort (very low effort). Projects 1, 2, 3, 8 and 9 should be executed first. Projects 5 and 7 have little value and may not be done at all, unless they are regulatory or quality related. Project 4 may be a candidate for a Kaizen event.

Figure 2 Project Rating Chart

3 responses to “The Benefit Effort Matrix – A Tool to Determine Where to Apply Your Resources”

  1. Madmax Avatar

    thanks ALCAN

  2. Larry W Dyer Avatar
    Larry W Dyer

    Looks great Juan.

  3. Mido Avatar

    Thanks a lot

Leave a Reply

Your email address will not be published. Required fields are marked *