A	B	C	E	G	H	J
1	WWPTG calculation for 3% increase justification
2	As of January 28, 2013
4			1113 LAB	1315 GBB
5			2011-13	2013-15
6	PS	Personal Services	12,107,767.00	13,556,149.00	11.96%
7	S&S	Services and Supplies	2,769,322.00	3,125,106.00	12.85%
8	CO	Contract	206,439.00	211,393.00	2.40%
9	SP	Special Payment	83,366.00	94,204.00	13.00%
10	IND	Indirect	1,845,282.00	1,778,011.00	-3.65%
11			17,012,176.00	18,764,863.00	10.30%
13		FTE	67.70	65.39	(2.31)
15		Per FTE	251,287.68	286,968.39	35,680.71	14.20%
17					Per year	7.10%
19						Annual increase	% of Total budget
20	PS	Personal Services	178,844.42	207,312.26	28,467.85	7.96%	72.24%
21	S&S	Services and Supplies	40,905.79	47,791.80	6,886.01	8.42%	16.65%
22	CO	Contract	3,049.32	3,232.80	183.48	3.01%	1.13%
23	SP	Special Payment	1,231.40	1,440.65	209.25	8.50%	0.50%
24	IND	Indirect	27,256.75	27,190.87	(65.88)	-0.12%	9.48%
25			251,287.68	286,968.39	35,680.71	7.10%
27	X:\YONGKIE\3 percent increase justification_10152012.xlsx

	B	C	D	E	G
2	11-13 LAB Working
3	TRANS_NO	(All)
5	Sum of CASHFLOW
6	PROG	OP_SUBPROG	MAJCAT	Total
7	002	WWPTG	1 - Revenue	17,713,090.00
8			7 - Indirect	(1,845,282.00)
9			2 - PS	(12,107,767.00)
10			3 - S&S	(2,769,322.00)
11			4 - CO	(206,439.00)
12			5 - SP	(83,366.00)	(17,012,176.00)
13			8 - FTE	67.70
14	Total			700,981.70
20	13-15 ARB
21	Program	002
22	FUND_TYPE	(All)
24	Sum of CASHFLOW
25	OP_SUBPROG	MAJCAT	Total
26	WWPTG	Revenue	19,462,871.00
27		Indirect	(1,813,543.00)
28		PS	(13,081,530.00)
29		S&S	(3,045,059.00)
30		CO	(211,393.00)
31		SP	(94,204.00)		(18,245,729.00)
32		FTE	62.39
33	Grand Total		1,217,204.39