Excel Sheet Download 30820 | 09 Revised Data Sample

Partial file snippet.

Sheet 1: Overview

	
	
	
	
	
	
	
	
		

		

		Revised Sampling Plan - Overview
		

		

		

		

		

		

	
	
		

		

		Cost Data Integrity Project
		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Initial Sampling
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		The entire portfolio of IT projects were sampled together resulting in some unusual frequency distributions
		

		

		

		

		

		

		

		

	
	
		as noted in the Histograms. It was determined that each IT project is unique and the defect or error rates
		

		

		

		

		

		

		

		

	
	
		on one project may be considerably different on another project. Therefore, samples on a project by project
		

		

		

		

		

		

		

		

	
	
		basis will be conducted going forward. 
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		The Core Team discussed their results with the IT Governance members (some of which are Six Sigma Black
		

		

		

		

		

		

		

		

	
	
		Belts) and they suggested that those projects with "material costs" involved should be sampled on a 
		

		

		

		

		

		

		

		

	
	
		continous basis until you can arrive at useful data for control purposes. XmR Charts were recommended by
		

		

		

		

		

		

		

		

	
	
		the Governance Board. Additionally, the Governance Board agreed with the Core Team to focus on two
		

		

		

		

		

		

		

		

	
	
		critical processes within the Project Management System (PMS):
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		Critical Defect No. 1 - Vendor Invoices posted to PMS in a timely manner
		

		

		

		

		

		

		

	
	
		

		Critical Defect No. 2 - Timesheets posted to PMS in a timely manner
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Projects to be Sampled
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		The portfolio of developmental IT projects consists of:
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		Project
		Jan 07 Labor
		Jan 07 Vendor
		Total
		% of
		

		

		

	
	
		Count
		ID Number
		Costs
		Invoice Costs
		Costs
		Total
		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		1
		D001139HT03
		167,515 
		383,921
		551,436
		4%
		

		

		

	
	
		2
		D001196QC02
		3,244,101 
		1,230,672
		4,474,773
		30%
		30%
		

		

	
	
		3
		D001893SG01
		347,566 
		23,525
		371,091
		3%
		

		

		

	
	
		4
		D002743LB02
		488,961 
		1,911,891
		2,400,852
		16%
		16%
		

		

	
	
		5
		D002784NC01
		290,077 
		147,913
		437,990
		3%
		

		

		

	
	
		6
		D002784NC02
		303,113 
		361,775
		664,888
		4%
		

		

		

	
	
		7
		D002889YL02
		88,164 
		11,300
		99,464
		1%
		

		

		

	
	
		8
		D002965YL02
		13,642 
		4,449
		18,091
		0%
		

		

		

	
	
		9
		D002977BA01
		41,672 
		13,214
		54,886
		0%
		

		

		

	
	
		10
		D002981BR02
		264,581 
		18,098
		282,679
		2%
		

		

		

	
	
		11
		D003671MT03
		509,462 
		77,432
		586,894
		4%
		

		

		

	
	
		12
		D006122YV02
		28,516 
		5,631
		34,147
		0%
		

		

		

	
	
		13
		D007566MJ03
		0 
		1,982
		1,982
		0%
		

		

		

	
	
		14
		D008632JS02
		101,681 
		32,656
		134,337
		1%
		

		

		

	
	
		15
		D008763VM01
		648,707 
		1,258,811
		1,907,518
		13%
		13%
		

		

	
	
		16
		D009441GS02
		840,203 
		1,021,327
		1,861,530
		13%
		13%
		

		

	
	
		17
		D018322HE01
		101,687 
		251,938
		353,625
		2%
		

		

		

	
	
		18
		M005912LQ02
		96,711 
		153,594
		250,305
		2%
		

		

		

	
	
		19
		M005912LQ03
		62,331 
		246,299
		308,630
		2%
		

		

		

	
	
		

		Totals
		7,638,690 
		7,156,428
		14,795,118
		100%
		72%
		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Based on a review of the actual costs incurred, four projects are driving most of the IT portfolio costs. Conduct
		

		

		

		

		

		

		

		

	
	
		sampling of these four projects going forward.
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Sample Plan
		

		

		

		

		

		

		

		

	
	
		Follow the same type steps and procedures as the initial sample. The time frame for sampling may need to
		

		

		

		

		

		

		

		

	
	
		extend into next year 2008 since the sample size taken in 2007 may not be sufficient.  
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		Statistical Process Control
		

		

		

		

		

		

		

		

	
	
		Use eight XmR Charts to track and control process performance:
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		 
		XmR Chart
		Critical
		Project
		% of Jan 07
		

		

		

		

	
	
		

		Number
		Defect
		(last 4 #'s)
		Costs
		

		

		

		

	
	
		

		1
		1 - Invoices
		QC02
		17%
		
 
		
		

		

		

	
	
		

		2
		1 - Invoices
		LB02
		27%
		Sample covers 76% of vendor costs
		

	
	
		

		3
		1 - Invoices
		VM01
		18%
		

	
	
		

		4
		1 - Invoices
		GS02
		14%
		

		

		

	
	
		

		5
		2 - Timesheets
		QC02
		42%
		
 
		
		

		

		

	
	
		

		6
		2 - Timesheets
		LB02
		6%
		Sample covers 67% of labor costs
		

	
	
		

		7
		2 - Timesheets
		VM01
		8%
		

	
	
		

		8
		2 - Timesheets
		GS02
		11%

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet overview revised sampling plan cost data integrity project initial the entire portfolio of it projects were sampled together resulting in some unusual frequency distributions as noted histograms was determined that each is unique and defect or error rates on one may be considerably different another therefore samples a by basis will conducted going forward core team discussed their results with governance members which are six sigma black belts they suggested those quot material costs involved should continous until you can arrive at useful for control purposes xmr charts recommended board additionally agreed to focus two critical processes within management system pms no vendor invoices posted timely manner timesheets developmental consists jan labor total count id number invoice dht dqc dsg dlb dnc dyl dba dbr dmt dyv dmj djs dvm dgs dhe mlq totals based review actual incurred four driving most conduct these sample follow same type steps procedures time frame need extend into n...

Related files

Share

Help

		Revised Sampling Plan - Overview
		Cost Data Integrity Project

Initial Sampling

The entire portfolio of IT projects were sampled together resulting in some unusual frequency distributions
as noted in the Histograms. It was determined that each IT project is unique and the defect or error rates
on one project may be considerably different on another project. Therefore, samples on a project by project
basis will be conducted going forward.

The Core Team discussed their results with the IT Governance members (some of which are Six Sigma Black
Belts) and they suggested that those projects with "material costs" involved should be sampled on a
continous basis until you can arrive at useful data for control purposes. XmR Charts were recommended by
the Governance Board. Additionally, the Governance Board agreed with the Core Team to focus on two
critical processes within the Project Management System (PMS):

	Critical Defect No. 1 - Vendor Invoices posted to PMS in a timely manner
	Critical Defect No. 2 - Timesheets posted to PMS in a timely manner

Projects to be Sampled

The portfolio of developmental IT projects consists of:

	Project	Jan 07 Labor	Jan 07 Vendor	Total	% of
Count	ID Number	Costs	Invoice Costs	Costs	Total

1	D001139HT03	167,515	383,921	551,436	4%
2	D001196QC02	3,244,101	1,230,672	4,474,773	30%	30%
3	D001893SG01	347,566	23,525	371,091	3%
4	D002743LB02	488,961	1,911,891	2,400,852	16%	16%
5	D002784NC01	290,077	147,913	437,990	3%
6	D002784NC02	303,113	361,775	664,888	4%
7	D002889YL02	88,164	11,300	99,464	1%
8	D002965YL02	13,642	4,449	18,091	0%
9	D002977BA01	41,672	13,214	54,886	0%
10	D002981BR02	264,581	18,098	282,679	2%
11	D003671MT03	509,462	77,432	586,894	4%
12	D006122YV02	28,516	5,631	34,147	0%
13	D007566MJ03	0	1,982	1,982	0%
14	D008632JS02	101,681	32,656	134,337	1%
15	D008763VM01	648,707	1,258,811	1,907,518	13%	13%
16	D009441GS02	840,203	1,021,327	1,861,530	13%	13%
17	D018322HE01	101,687	251,938	353,625	2%
18	M005912LQ02	96,711	153,594	250,305	2%
19	M005912LQ03	62,331	246,299	308,630	2%
	Totals	7,638,690	7,156,428	14,795,118	100%	72%

Based on a review of the actual costs incurred, four projects are driving most of the IT portfolio costs. Conduct
sampling of these four projects going forward.


Sample Plan
Follow the same type steps and procedures as the initial sample. The time frame for sampling may need to
extend into next year 2008 since the sample size taken in 2007 may not be sufficient.


Statistical Process Control
Use eight XmR Charts to track and control process performance:

	XmR Chart	Critical	Project	% of Jan 07
	Number	Defect	(last 4 #'s)	Costs
	1	1 - Invoices	QC02	17%
	2	1 - Invoices	LB02	27%		*Sample covers 76% of vendor costs*
	3	1 - Invoices	VM01	18%		*Sample covers 76% of vendor costs*
	4	1 - Invoices	GS02	14%
	5	2 - Timesheets	QC02	42%
	6	2 - Timesheets	LB02	6%		*Sample covers 67% of labor costs*
	7	2 - Timesheets	VM01	8%		*Sample covers 67% of labor costs*
	8	2 - Timesheets	GS02	11%

Related files

Share

Share to social media

Help

Login Area