Skip to Content

close window

Cost Analysis: Project Costs — HR/Payroll

Category Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Total
Agency Personnel and Contractor Costs
Agency Personnel Services - Implementation
Project Management/Administraion 0 0 0 0 0 0 0 0 0 0 -
Policy and Procedures 0 0 0 0 0 0 0 0 0 0 -
Requirements 0 0 0 0 0 0 0 0 0 0 -
Design 0 0 0 0 0 0 0 0 0 0 -
Development/Programming 0 0 0 0 0 0 0 0 0 0 -
System Test 0 0 0 0 0 0 0 0 0 0 -
Training 0 0 0 0 0 0 0 0 0 0 -
Conversion 0 0 0 0 0 0 0 0 0 0 -
Implementation 0 0 0 0 0 0 0 0 0 0 -
Database Administration 0 0 0 0 0 0 0 0 0 0 -
Systems Operations 0 0 0 0 0 0 0 0 0 0 -
Technical Support 0 0 0 0 0 0 0 0 0 0 -
Help Desk Personnel 0 0 0 0 0 0 0 0 0 0 -
Network Administration 0 0 0 0 0 0 0 0 0 0 -
Total of all agencies’ personnel costs
(including CPA, HHS agencies, TxDOT and DIR)
1,595,150 1,914,180 1,148,508 0 0 0 0 0 0 0 4,657,838
Subtotal Agency Personnel-Implementation 1,595,150 1,914,180 1,148,508 0 0 0 0 0 0 0 4,657,838
Agency Personnel Services - Maintenance
IT Staff 0 0 0 0 0 0 0 0 0 0 -
Business Staff 0 0 0 0 0 0 0 0 0 0 -
Subtotal Agency Personnel-Maintenance 0 0 0 0 0 0 0 0 0 0 -
Agency Personnel Fringe Benefits 474,398 569,277 341,566 0 0 0 0 0 0 0 1,385,241
Total Agency Personnel Costs 2,069,548 2,483,457 1,490,074 0 0 0 0 0 0 0 6,043,079
Contract/Consultant Services - Implementation
Project Management/Administration (FY10 - STA + 25% Deloitte) 1,064,741 1,804,518 2,932,366 426,518 0 0 0 0 0 0 6,228,143
Requirements (FY10 - 60% of Deloitte + 60% of Staff Aug) 1,603,039 2,279,555 511,822 0 0 0 0 0 0 0 4,394,416
Design (FY10 - 40% of net Deloitte + 40% of net Staff Aug) 1,068,693 1,423,650 1,302,344 0 0 0 0 0 0 0 3,794,687
Development/Programming 0 2,464,500 3,797,287 0 0 0 0 0 0 0 6,261,787
System Test 0 0 1,773,644 0 0 0 0 0 0 0 1,773,644
Training 294,037 0 1,535,466 0 0 0 0 0 0 0 1,829,503
Conversion 0 0 2,785,466 0 0 0 0 0 0 0 2,785,466
Implementation 0 0 761,822 0 0 0 0 0 0 0 761,822
Documentation 0 0 511,822 0 0 0 0 0 0 0 511,822
Technical Support 0 0 0 0 0 0 0 0 0 0 -
Benchmarking 0 0 0 0 0 0 0 0 0 0 -
Warranty/Maintenance Period 0 0 0 1,279,555 0 0 0 0 0 0 1,279,555
Subtotal Contract/Consultant-Implementation 4,030,510 7,972,223 15,912,037 1,706,073 0 0 0 0 0 0 29,620,843
Contract/Consultant Services - Maintenance
IT Staff 0 0 4,038,964 4,038,964 4,422,485 4,422,485 4,555,160 4,555,160 4,691,814 4,691,814 35,416,846
Business Staff 0 0 1,379,978 1,379,978 1,585,976 1,585,976 1,633,555 1,633,555 1,682,562 1,682,562 12,564,142
Subtotal Contract/Consultant - Maintenance 0 0 5,418,942 5,418,942 6,008,461 6,008,461 6,188,715 6,188,715 6,374,376 6,374,376 47,980,988
Total Contract/Consultant Services Costs 4,030,510 7,972,223 21,330,979 7,125,015 6,008,461 6,008,461 6,188,715 6,188,715 6,374,376 6,374,376 77,601,831
Total Agency and Contract Personnel Costs 6,100,057 10,455,680 22,821,053 7,125,015 6,008,461 6,008,461 6,188,715 6,188,715 6,374,376 6,374,376 83,644,910
Hardware/Systems Costs
Procurement - Hardware
Hardware - Mainframe 0 0 0 0 0 0 0 0 0 0 -
Hardware - Unix Server (New maintenance environment in FY12) 836,990 0 1,500,000 0 32,625 1,348,792 0 0 0 1,416,232 5,134,640
Hardware - Internal Server 0 0 0 0 7,200 7,200 7,200 7,200 7,200 7,200 43,200
Hardware - Storage (Universal Storage V Disk Array and Brocade - DW storage in FY 12) 233,882 0 750,000 0 3,125 55,837 60,000 60,000 60,0000 60,000 1,282,844
Hardware - Desktop (leased laptops) 1,875 3,750 3,750 3,750 0 0 0 0 0 0 13,125
Hardware - Network (Cisco Equipment) 72,241 0 0 0 5,460 5,460 5,460 5,460 5,460 5,460 105,501
Subtotal Hardware Procurement 1,145,488 3,750 2,253,750 3,750 48,410 1,417,289 72,660 72,660 72,660 1,488,892 6,579,310
Maintenance - Hardware
Hardware - Mainframe 0 0 0 0 0 0 0 0 0 0 -
Hardware - Unix Server (P595s) 0 0 122,781 122,781 236,280 225,000 231,750 231,750 238,703 238,703 1,647,748
Hardware - Intel Server 0 0 0 0 0 0 0 0 0 0 -
Hardware - Storage (Universal Storage V Disk Array and Brocade - DW storage in FY 12) 0 29,235 29,235 29,423 34,195 34,508 35,543 35,543 36,609 36,609 300,901
Hardware - Desktop 0 0 0 0 0 0 0 0 0 0 -
Hardware - Network (Cisco Equipment) 0 5,460 5,460 5,460 5,460 5,460 5,624 5,624 5,793 5,793 50,133
Subtotal Hardware Maintenance 0 34,695 157,477 157,664 275,935 264,968 272,917 272,917 281,104 281,104 1,998,781
Procurement - Software
Software - Mainframe 0 0 0 0 0 0 0 0 0 0 -
Software - Unix Server (New maintenance environment in FY 12) 1,469,089 540,000 2,108,005 1,000,000 819,950 0 0 0 0 0 5,937,043
Software - Intel Server 0 0 0 0 0 0 0 0 0 0 -
Software - Storage 110,828 0 0 0 0 0 0 0 0 0 110,828
Software - Desktop 1,245 5,700 18,300 8,220 9,720 8,520 8,520 8,520 8,520 8,520 85,785
Software - Network 0 0 0 0 0 0 0 0 0 0 -
Subtotal Software Procurement 1,581,162 545,700 2,126,305 1,008,220 829,670 8,520 8,520 8,520 8,520 8,520 6,133,656
Maintenance - Software
Software - Mainframe 0 0 0 0 0 0 0 0 0 0 -
Software - Unix Server 1,866,509 2,025,895 2,489,656 2,489,656 2,234,303 2,242,811 2,242,811 2,310,096 2,379,399 2,450,781 22,731,915
Software - Intel Server 0 0 0 0 5,155 5,155 5,155 5,310 5,469 5,633 31,879
Software - Storage 0 0 22,166 22,166 33,367 33,864 33,864 34,880 35,927 37,004 253,238
Software - Desktop 0 0 0 0 243 243 243 251 258 266 1,505
Software - Network 0 0 0 0 0 0 0 0 0 0 -
Subtotal Software Maintenance 1,866,509 2,025,895 2,511,821 2,511,821 2,273,069 2,282,074 2,282,074 2,350,537 2,421,053 2,493,684 23,018,537
Other Costs
Data Communications 0 0 0 0 0 0 0 0 0 0 -
Voice Communications 9,256 11,108 11,108 11,108 11,108 11,108 11,108 11,108 11,108 11,108 109,226
Equipment Rental/Supplies and Materials 5,150 6,180 6,180 6,180 6,180 6,180 6,180 6,180 6,180 6,180 60,766
Facilities Rental/Supplies and Materials (Misc) 48,482 53,331 53,331 53,331 53,331 53,331 53,331 53,331 53,331 53,331 528,459
Disaster Recovery 0 200,000 276,940 276,940 276,940 276,940 285,248 285,248 285,248 285,248 2,448,753
Travel 1,180 0 0 0 0 0 0 0 0 0 1,180
  4,052 0 0 0 0 0 0 0 0 0 4,052
Subtotal Other Costs 68,121 270,618 347,558 347,558 347,558 347,558 355,866 355,866 355,866 355,866 3,152,437
Total Hardware/Systems/Other Costs 4,661,280 2,880,658 7,369,910 4,029,013 3,774,642 4,320,409 2,992,037 3,060,500 3,139,203 4,628,067 40,882,721
Subtotal Project Costs 10,761,337 13,336,338 30,217,964 11,154,028 9,783,103 10,328,870 9,180,752 9,249,215 9,513,580 11,002,443 124,527,630
Contingency 0 2,400,000                 2,400,000
Total Project Costs 10,761,337 15,736,338 30,217,964 11,154,028 9,783,103 10,328,870 9,180,752 9,249,215 9,513,580 11,002,443 126,927,630

Note: The preceding report detailing project costs for the HR/Payroll component of CAPPS is provided monthly to the Quality Assurance Team as part of the quality assurance review required for all state agency technology projects in Texas. This particular report was submitted in November 2010.