Solution Matrix Example

Solution Matrix Example

Problem Statement

Use a solution selection matrix to select the best software.

#

Notes

1

Software A is the fastest to deploy followed by B & D

2

Software B is the cheapest followed by A & D

3

Software A has medium impact on results (others are lower)

4

Weightage is same for time, cost, impact, and risk

How to perform analysis

Step 1: Open Sigma Magic
  1. Click on the Sigma Magic button on the Excel toolbar.
  2. Click on the New button to create a new project.
Step 2: Add the analysis template
  1. Click on the Tool Wizard to add the analysis template.
  2. Click on Project and then Solution Matrix.


Step 3: Specify analysis options
A new worksheet will be added to your workbook. Analysis Setup will be automatically opened, in the setup tab specify the following details.



Click on the AHP Weights based on the relative weights specified by the user for two factors, the software translates them into an overall score for each factor. These weights can then be used to determine the overall score of each project.



Step 4: Enter the details in worksheet
Click Create, the worksheet will created and then enter all the details. A sample is provided below:




Step 5: Generate analysis results
Finally, click on Verify tab and then click Analyze to ensure all the inputs are okay and shown in a green checkmark.



Interpretating Results

Top-Ranked Solution:

  • Software A has the highest total score (98) and is ranked #1, making it the most favorable option.
  • It has balanced performance across all criteria, with particularly high time impact (9), which might be a crucial factor in decision-making.

 Close Competitor:

  • Software B follows closely behind with a score of 88 and is ranked #2.
  • It has the highest cost impact (9) among all options, indicating that it might be an expensive choice. However, its overall benefits are still significant.

 Moderate Performing Solutions:

  • Software D ranks #3 with a score of 68, meaning it is a viable option but less effective than A and B.
  • The scores indicate a balance between cost and time impact but a lower overall impact compared to the top two solutions.

 Lower-Ranked Options:

  • Software C and Software E scored 48 and 28, ranking #4 and #5, respectively.
  • These solutions may not be optimal due to lower scores in multiple impact factors, making them less favorable for selection.

  Decision Factors:

  • Time Impact appears to be a key factor in the ranking, as Software A (ranked 1st) has the highest score in this area (9).
  • Cost Impact also plays a significant role, with Software B excelling in this category but still ranking below Software A.
  • Sigma Impact and Other Impact are relatively similar across the options, meaning their effect on the ranking is minimal.

 Final Recommendation:

  • Software A is the best choice, offering high impact across all parameters, particularly in time efficiency.
  • Software B could be an alternative, especially if cost impact is a critical consideration.
  • Software D might be a backup option, while Software C and E are not recommended due to their lower scores.

    • Related Articles

    • Solution Matrix Overview

      A Solution Matrix is a decision-making tool used to evaluate multiple potential solutions against a set of defined criteria. It helps individuals or teams systematically compare different options, prioritize them, and select the most effective one ...

    • Solution matrix frequently asked questions

      What is Solution Matrix in Sigma Magic? Solution Matrix is a structured framework used in Sigma Magic for problem-solving, decision-making, and selecting the best possible solution among multiple alternatives. How is Solution Matrix used in Six Sigma ...

    • Matrix Plot Example

      Problem Statement The following variables are data from three distributions (normal, rayleigh, and uniform). Can you check if the variables are correlated using a matrix plot? How to perform analysis Step 1: Open Sigma Magic Click on the Sigma Magic ...

    • CE Matrix Example

      Problem Statement Use the C&E Matrix to determine which are the most important causes decline in sales. The team wants to evaluate these causes based on the following criteria: Generation of Sales, Cost, Quality. Use the C&E matrix to determine the ...

    • Scatter Matrix Example

      Problem Statement The data shown in the data tab contains info on adv spend vs. sales revenue. Create a scatter plot between the two variables and draw any conclusions from this exercise. How to perform analysis Step 1: Open Sigma Magic Click on the ...