Appendix D: ERP Financial Project Expenditures By Year and Sub-Project

ERP Financial Project Expenditures By Year and Sub-Project - Through September 30, 2012
	Financials Release I FY 10	Financials Release I FY 11	Financials Release I FY 12	FY 12 TxDOT Prototype	Total

Participating Agencies Project Expense	$8,902,335.95	$10,514,632.76	$613,990.80	$452,840.73	$20,483,800.24
Total Project Expense	$8,902,335.95	$10,514,632.76	$613,990.80	$452,840.73	$20,483,800.24

Shared Costs: CPA and Participating Agencies
Training Cost	$810,501.60	$-	$-	$-	$810,501.60
PeopleSoft converted licenses and support	$1,034,343.42	$1,061,959.39	$-	$-	$2,096,302.81
	$1,844,845.02	$1,061,959.39	$-	$-	$2,906,804.41

Internal costs: CPA and Participating Agencies
Capital Outlay	$360,000.00	$-	$-	$-	$360,000.00
Communications & Utilities	$11,996.78	$11,688.82	$-	$-	$23,685.60
Other Expenditures	$4,178.79	$145.74	$-	$-	$4,324.53
Professional Fees and Services	$59,539.00	$-	$-	$-	$59,539.00
Rentals and Leases	$43,871.09	$58,833.88	$-	$-	$102,704.97
Repairs and Maintenance	$6,774.55	$-	$-	$-	$6,774.55
Supplies and Materials	$13,425.19	$15.00	$-	$-	$13,440.19
Travel	$4,600.35	$-	$-	$-	$4,600.35
Salary and Wages	$2,027,368.26	$2,674,877.46	$63,794.62	$194,629.03	$4,960,669.37
Total Internal Agencies’ Cost	$2,531,754.01	$2,745,560.90	$63,794.62	$194,629.03	$5,535,738.56

Total YTD Expenditures:	$13,278,934.98	$14,322,153.05	$677,785.42	$647,469.76	$28,926,343.21

ERP HR/Payroll Project Expenditures By Year and Sub-Project - Through September 30, 2012
	Statewide HR/PR FY 10	Statewide HR/PR FY 11	Statewide HR/PR FY 12	Statewide HR/PR FY 13	HHSC Sub-Project for Upgrade FY 11 - 13	Total

Participating Agencies Statewide HR/PR Project Expense	$7,363,532.93	$3,196,146.55	$2,023,171.05	$-	$-	$12,582,850.53
Total Statewide HR/PR Project Expense	$7,363,532.93	$3,196,146.55	$2,023,171.05	$-	$-	$12,582,850.53

Shared Costs: CPA and Participating Agencies
Training Cost	$294,038.42	$-	$-	$-	$-	$294,038.42
PeopleSoft converted licenses and support	$1,034,343.42	$1,061,959.39	$-	$-	$-	$2,096,302.81
	$1,328,381.84	$1,061,959.39	$-	$-	$-	$2,390,341.23

Internal costs: CPA and Participating Agencies
Capital Outlay	$-	$-	$-	$-	$-	$-
Communications & Utilities	$11,996.78	$11,688.82	$-	$-	$-	$23,685.60
Other Expenditures	$4,178.79	$145.74	$-	$-	$-	$4,324.53
Professional Fees and Services	$31,250.00	$7,913.00	$97,585.50	$-	$8,253,818.00	$8,390,566.50
Rentals and Leases	$43,871.09	$58,833.88	$-	$-	$-	$102,704.96
Supplies and Materials	$13,425.19	$15.00	$-	$-	$-	$13,440.19
Travel	$1,508.35	$327.00	$-	$-	$-	$1,835.35
Salary and Wages	$1,627,156.79	$1,709,175.44	$1,217,157.13	$120,828.82	$1,169,664.00	$5 ,843,982.18
Total Internal Agencies’ cost	$1,740,161.53	$1,788,098.87	$1,314,742.63	$120,828.82	$9,423,482.00	$14,387,313.85

Total YTD Expenditures:	$10,432,076.30	$6,046,204.81	$3,337,913.68	$120,828.82	$9,423,482.00	$29,360,505.61