Help Manual
Contents
- Introduction
- Project
- Analytics Templates
- Basic Charts
- Bagging Models
- Bayesian Models
- Boosted Models
- Correspondence Analysis
- Decision Trees
- Discriminant Analysis
- Exploratory Factors
- Heat Map
- Hierarchical Clusters
- Kmeans Clusters
- Make Predictions
- Marginal Plot
- Model Selection
- Network Plot
- Neural Networks
- Pre-Process Data
- Prototype Models
- Regression Models
- Scatter Matrix
- Support Vectors
- Tree Map
- Word Cloud
- 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 17
Financial Benefits
Overview
The Financial Benefits Report tool can be used to document the quantifiable financial benefits realized on projects. Quantifiable financial benefits are classified into two categories: impact on Net Income or Earnings and impact on Balance Sheet.This tool can be added to your active workbook by clicking on Project and then selecting Financial Benefits.
Inputs
Click on Analysis Setup to open the menu options for this tool.Setup
A sample screenshot of the setup menu is shown below.
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. | ||||||||
6a | Create Button: Click on this button to save changes and update the worksheet. You can go to the worksheet and enter the requested details. | ||||||||
6b | OK Button: Click on this button to save changes and update your analysis results. |
Worksheet
Enter the following information in the worksheet:- Enter any incremental revenue you have realized from 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 comments describing the logic behind the numbers entered.
- For the soft benefits, indicate the potential savings in cost avoidance (such as penalty avoidance), opportunity costs, and capacity increase.
- For other non-quantifiable benefits where you cannot estimate financial numbers, add the comments at the bottom of the report.
Verify
If you click the Verify button, the software will perform some checks on the data you entered. A sample screenshot of the dialog box is shown in the figure below.
The software checks if you have correctly specified the input options and entered the required data on the worksheet. The results of the analysis checks are listed on the right. If the checks are passed, they are shown as green-colored checkmarks. If the verification checks fail, they are shown as a red-colored cross. If the verification checks result in a warning, they are shown in the orange exclamation mark, and finally, any checks that are required to be performed by the user are shown as blue info icons.
1 | Item: The left-hand side shows the major tabs and the items checked within each section |
2 | Status: The right-hand side shows the status of the checks. |
3 | Overall Status: The overall status of all the checks for the given analysis is shown here. The overall status check shows a green thumps-up sign if everything is okay and a red thumps-down sign if any checks have not passed. Note that you cannot proceed with generating analysis results for some analyses if the overall status is not okay. |
Outputs
Click on Compute Outputs to update the output calculations. The analysis results calculate the impact on net income and the impact on the balance sheet.
A sample output message that is displayed on successful completion of the analysis is shown below.
The report summarizes the total savings from the income statement and the balance sheet. Once this sheet has been completed, forward this report to your designated financial controller and get their signature.
Notes
Here are a few pointers regarding this analysis:- Per Six Sigma guidelines, only the first year of benefits can be usually claimed. Hence, this form supports reporting benefits for one year only.
- Currently, this tool does not support NPV calculation.
Examples
The following examples are in the Examples folder.- Use the Benefits Report to document the benefits of a project that improves the delivery performance (Benefits 1.xlsx).
© Rapid Sigma Solutions LLP. All rights reserved.