Application of Six-Sigma in Finance
Application of Six-Sigma in Finance
Application of Six-Sigma in Finance
Tirthadeep Gupta
Measure
capturing the flow of informationwhere and what information is needed. collecting data relevant to measuring the current process performance relative to the projects goals. The most important activities in this phase are the identification and validation of data accuracy.
Analyze
analyze the data to understand the key process input variables that affect the projects goal
Improve
conduct experiments (DOE) on a small scale list of all possible solutions should be developed, enabling the team to eliminate the root causes of problems.
Control
standardize and document the new process to support and sustain desired improvements.
Define
The Six Sigma team began by working with internal customers to define the objectives of the project, including the deliverable, opportunity statement, scope, schedule, budget, and constraints. The team defined the current problem as the process cannot produce all Financial Planning and Analysis (FP&A) requirements in the most efficient and effective manner. The primary objective of the project, therefore, was to streamline and document all cost elements in the planning process for the current financial system. Six Sigma team recognized two primary issues
Need to clarify and simplify the current financial reporting process for internal customers by identifying all nonvalue added and confusing steps to reduce reporting cycle time and cost. Need for a more improved process that results in more timely, complete, and accurate data for planning.
Massure
At this stage, the team conducted value stream mapping analysis to measure the performance of the current reporting process in terms of average hours required to complete the FP&A reports and the subsequent cost of preparing all the reports using activity based costing (ABC) methods. The existing cost and financial planning process was not clearly documented or consistently followed, which often resulted in rework and dual update loops. These loops inevitably create opportunities for nonvalue added activities Another problem with the existing process, step 5, was that the financial reporting for project definition was produced with data from the Business Information Warehouse, which is a combination of databases, and database management tools that are used to support management decision making. both SAP and BPS data bases were updated as needed. But inconsistently 150 hours to produce 10 internal Firm financial statements and 50 hours on 10 outside Non-Firm reports. for an overall cost of $360,000. With ABC costing in that cost they should have generated 36 reports in place of 20
Analyze
The team began this stage by creating a cause-and-effect diagram to identify possible root causes of why the process cannot produce all cost and FP&A requirements in the most efficient and effective manner. Mainly 3 major root causes:
Lack of complete Firm cost and financial plans Multiple sources of data and databases Lack of complete Non-Firm cost and financial plans
The team used VSM analysis to recommend the following actions for overall process performance improvement:
Identify all business divisions that require a baseline in the current financial database. Establish baseline data by resource, cost element, and time phasing for each project. Identify and eliminate all nonvalue added activities to improve the response time at all levels of management for a variety of cost analysis and FP&A requirements, including five-year plans, bookings forecasts, sales forecasts, and annual operating plans.
Improve
Six Sigma Team provided two solutions 1. implement all the actions identified through VSM analysis. 2. Redesign the process. Six Sigma team recommended the following actions 1. Develop initial cost-element plans by project for both internal and external contracts. 2. Regularly copy cost plans to various FP&A versions for fiveyear planning, sales forecasting, and bookings forecasting. 3. Update and maintain cost-element plans as new businesses are identified and funding is received. 4. Update and maintain financial plans. 5. Copy updated financial plans to various FP&A versions accordingly.
Improved Process
Old Process
Control
The goal of the project was to pull cost elements and financial plans from their various sources, organize them, and combine the information into one comprehensive report for analysis and monthly program presentations. Ongoing performance was monitored and became part of the formal performance evaluation process.
The success of Six Sigma Methodology implementation ultimately depends on executives continuing commitment to the program. To sustain improvement in the future, the processes and their associated metrics must be simple, transparent, understood, and accepted by all parties involved. Otherwise, none of it will be of any use, as people will not follow them, trust them, or use them.