Using Microsoft Project for Implementation of Six Sigma

Using Microsoft Project for Implementation of Six Sigma Projects A Tools and Tips Presentation Nora Gessert, Pcubed

Six Sigma is Defined as… A problem scheduled for a solution that has a set of metrics that can be used to set project goals and monitor progress. ”

Sigma Parts per million 6 sigma 3. 4 defects per million 5 sigma 233 defects per million 4 sigma 6, 210 defects per million 3 sigma 66, 807 defects per million 2 sigma 308, 537 defects per million 1 sigma 690, 000 defects per million

Six Sigma Project Selection The project is linked to business priorities The problem is of major importance to the organization The project has a reasonable scope (3 -6 months) The project defines clear quantitative measures of success The projects’ importance is clear to the organization The project has the support and approval of management

A Project is Defined as…. “A temporary endeavor undertaken to create a unique product or service” PMBOK Initiate Plan Project Management Phases Execute Control Close

MSP Define Work Break down structure Phases (DMAIC) Milestones Durations (variation) UCL/LCL 6 Sigma Voice of the customer Project scope Cause and effect prioritization CTQ’s Identify process SIPOC

Measure 6 Sigma Plan for collecting data Validate measures Sample size Preliminary measures to provide direction Baseline measure of current performance Key process input variables Pareto, Histogram, Run charts Baseline Sigma level

Measure MSP Timing Resource Time & Material Cost Variation to Plan Earned Value (BCWP/ACWP) Graphical Analysis Baseline(s) Critical Path Items Baseline/Deadlines Spec Limits Cycle time PERT (Performance Evaluation & Review Techniques)

Analyze MSP Variation Baseline variations Milestone variation Task Errors/Variation Cycle time Hour/Week/Month Number of Defects (tasks)

Analyze 6 Sigma All things statistical Test hypothesis Look at variation and variables

DMAIC Process 1 st Round Define Measure Analyze Control Improve 2 nd Round

Improve 6 Sigma Brainstorm NGP Cost/Benefit Pilot Implement Plan Changes (revise) “Should Be” Plan

MSP Control Views with UCL/LCL by Task Audits Baseline tracking Milestone tracking Control plan as part of the project 6 Sigma Mistake proofing Control chart Update SOP Reaction Plan Corrective action Performance measures

Features Consolidated master project Resource management (BB allocation) Cost management Reporting Export to Excel, others Imbedded and Hyperlinked Documents

Sample Plans

Questions? Nora. Gessert@Pcubed. com 734 -741 -7770 ext. 259