This exercise helps you visualize which initiatives should be prioritized based on their feasibility and importance, in effect, which ones will yield the greatest return on investment. Traditional ROI calculator templates rely on quantitative inputs. This ROI calculator template utilizes your team to vote on the initiatives they value the most to figure out which initiatives to prioritize.
Use this ROI calculator template
How to use this ROI calculator template
Step 1: List initiatives
Start by listing the set of initiatives that you want to prioritize. It is best to start with the list of items that do not have dependencies, otherwise you might prioritize an initiative above its dependency. If you do want to include items with dependencies, it’s best to consolidate the initiative and its dependencies as one item on your list.
Step 2: Allocate importance and feasibility “votes”
Then, assign each initiative a feasibility and importance rating. Typically, product management assigns the feasibility values with support from development; they know whether the idea can be built and what it would take. The “importance” column represents ratings that marketing and product management agree on.
The values you assign to each of the two criteria are based on a total budget of points. You can set any total budget; the more you allot, the higher fidelity the results will be. Of course, you would never distribute points evenly because the whole point is to show relative importance and feasibility. Remember, if you consolidate an initiative (to include a dependency) you must factor it into the cost of the initiative; so if the primary initiative costs 10 points and its dependency initiative costs 2, you must assign 12 points to its feasibility rating.
Step 3: Plot votes on a chart
Once you’ve plugged ratings into the table, you then plot the initiatives’ values on a chart. This exercise will give your teams a much better shared understanding of the initiatives and how they relate to each other. With these insights in hand, they’ll be better equipped to articulate a strategy that both product development and marketing can own and support.
In this exercise, it’s useful to have each participant come up with his or her own rating of feasibility or importance before sharing with the team. By concealing the results in this way, you avoid introducing the form of cognitive bias known as anchoring, in which the first number spoken aloud sets a precedent for subsequent estimates.
Get started:
Copy this doc and share this template with your team members by clicking Share in the top-right Each team member adds initiatives in Step 1 In Step 2, enter the number of total “votes” each person gets and have everyone allocate their Feasibility and Importance votes Review the ROI score, Avg. Feasibility, and Avg. Importance in Step 3 Delete the intro text (everything above the line below) ROI Calculator
Step 1: Add initiatives
Step 2: Vote privately
Enter total votes per person: Feasibility
You have votes remaining.
Importance
You have votes remaining.
Step 3: Review results