- Introduction
- Project
- Analytics Templates
- Pre-Process Data
- Basic Charts
- Hierarchical Cluster
- Kmeans Cluster
- Correspondence Analysis
- Conditional Tree
- Recursive Tree
- Discriminant Analysis
- Exploratory Factor Analysis
- Generalized Linear Model
- Heat Map
- KNN
- Marginal Plot
- Naive Bayes
- Network Plot
- Neural Networks
- Random Forest
- Scatter Matrix
- Tree Map
- Word Cloud
- XGBoost Analysis

- Change Templates
- Lean Templates
- 30-60-90 Plans
- 5 Why Analysis
- 5S+1 Audit
- Lean Maturity Assessment
- Hoshin Analysis
- Kanban Analysis
- Leader Standard Work
- OEE Analysis
- A3 Report
- Kaizen Report
- One Point Lesson
- SMED Analysis
- Spaghetti Diagram
- Standard Work
- TAKT Time
- Time Study
- True North
- Value Stream Map
- Waste Analysis
- Work Combination
- Workload Balance

- Graph Templates
- Projects Templates
- Balanced Scorecard
- Benefit Effort Plot
- C&E Diagram
- C&E Matrix
- Closure Form
- Check Sheet
- Control Plan
- Design Scorecard
- FMEA Analysis
- Fault Tree Analysis
- Financial Benefits
- Is - Is Not Analysis
- Kano Analysis
- Process Map
- Relationship Diagram
- Meeting Minutes
- Project Charter
- Project Filter
- GANTT Chart
- Implementation Plan
- QFD Analysis
- SIPOC Analysis
- Pugh Analysis
- Solution Matrix
- Tree Diagram
- TRIZ Analysis

- Stats Templates
- Format Data
- Basic Stats
- Capability Analysis
- Compare Data Sets
- Control Charts
- Correlation Analysis
- DOE - Factorial Design
- DOE - Taguchi Design
- Distribution Identification
- Probability Calculations
- Monte Carlo Simulation
- MSA - Linearity & Bias
- MSA - Gage R&R
- Normality Analysis
- Normality - Transform Data
- Optimization
- Generate Random Data
- Sample from Columns
- Regression Analysis
- Reliability Analysis
- Lot Acceptance Plan
- Sample Size Analysis
- Time Series Analysis

- Analysis
- Miscellaneous

Sigma Magic Help Version 15

This tool can be added to your active workbook by clicking on

1 | Analysis Type:
Specify the tool format for this analysis. This selection is not enabled since there is only one format available.
| ||||||||

2 | Monetary Units:
Specify the currency to use for this analysis. The following options are available:
| ||||||||

3 | View Example:
Click on this button to open the example file. You can view the example to get an idea of how to fill out this tool or you can use the example as a starting point and modify it to meet your project needs.
| ||||||||

4 | Help Button: Click on this button to open the help file on this topic. | ||||||||

5 | Cancel Button: Click on this button to exit without saving any changes. | ||||||||

6 | OK Button: Click on this button to save changes and update your analysis results. |

- Enter any incremental revenue you have realized as a result of your project.
- Enter the overall average gross margin % for the products/services related to your project.
- Enter any costs incurred on the project (do not include sunk costs)
- Enter any impact on assets due to your project (such as reduction in inventories).
- Enter any impact on liabilities due to your project
- Add an effective date for each row to indicate when the benefits are expected to be realized.
- Add any comments to describe the logic behind the numbers entered.
- For the soft benefits, indicate the potential savings in the area of cost avoidance (such as penalty avoidance), opportunity costs and capacity increase.
- For any other non-quantifiable benefits where you cannot estimate any financial numbers add the comments at the bottom of the report.

- Per Six Sigma guidelines, only the first year of benefits can be usually claimed. Hence, this form supports reporting benefits for a period of 1 year only.
- Currently, this tool does not support NPV calculation.

- Use the Benefits Report to document the benefits for a project that improves the delivery performance (Benefits 1.xlsm).