DECISION MATRIX AUTOMATION
A decision matrix is a list of values in rows and columns that allows an analyst to systematically identify, analyse, and rate the performance of relationships between sets of values and information. Elements of a decision matrix show decisions based on certain decision criteria.
When you’re faced with multiple choices and countless variables, a decision matrix can clear up confusion about the options and highlight points that may factor into the final call. This quantitative method can remove emotion as well as confusion to help you guide your business effectively. Unlike a simple list of pros and cons, a decision matrix allows you to place importance on each factor.
Creating a decision matrix
Decision matrices can help you select the best option, but also in prioritising tasks, problem-solving or even crafting arguments to defend a decision you’ve already made.
List your decision alternatives as rows, and the relevant factors affecting the decisions – such as cost, ease and effectiveness – as the columns. Then, establish a ratings scale to assess the value of each alternative/factor combination. Be sure that the rankings are consistent. For example, if you’re looking at pain points, be sure each issue is worded so it gets more points the worse it is.
Next, multiply your original ratings by the weighted rankings to get a score. All the factors under each option should then be added up. The option that scores the highest is the winning choice or the first item to work on.
Decision matrix example
Decision matrices can be used in a variety of sitwwwions, such as determining the best way to expand or to tackle a customer service issue. Here we use a decision matrix to determine the best location for a new restaurant:
Credit: Karina Fabian
In this example, a restaurant owner is considering four locations. She listed the factors she finds important and assigned weights that reflect how important she considers each aspect to be. Rent is a factor, but she’s decided market share, which determines how likely she is to get customers and regulars, is the most important issue. She also values someplace closer to her home so she can visit quickly if there are problems, but it’s a nice-to-have feature, not a vital one. Also important is the employee base – she wants to set up where she can find reliable workers. She did not consider floor plan, because she found all of them basically equal and intends to remodel anyway.
When our restaurateur ran the numbers, Locations 3 and 4 come up as close winners. However, looking at the individual numbers helped solidify her decision. Location 3, while the most expensive, offers the greatest opportunity to find qualified employees and attract diners. Thus, not only is it the best by overall score, but the individual factors she values help her justify the increased rent.
“The use of a weighted decision matrix and rudimentary analysis provide a simple tool set for rapid group decision making on complex subjects,” Krapohl wrote. [Need help making a business decision? Try these techniques and tools.]
A decision matrix is not the only decision-making tool available. Sometimes, a simple pros and cons list works. However, for a decision where you have multiple options and diverse features to consider, a decision matrix can shed light on the best choice.