Skip to Content

close window

Cost Analysis: Project Costs — Financials

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/Administration 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 -
System Opera3ons 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,973,313 2,367,975 1,420,785 0 0 0 0 0 0 0 5,762,073
Subtotal Agency Personnel-Implementation 1,973,313 2,367,975 1,420,785 0 0 0 0 0 0 0 5,762,073
Agency Personnel Services - Maintenance
IT Staff 0 0     0 0 0 0 0 0 -
Business Staff 0 0     0 0 0 0 0 0 -
Subtotal Agency Personnel - Maintenance 0 0 0 0 0 0 0 0 0 0 0
Agency Personnel Fringe Benefits 586,863 704,236 422,541 0 0 0 0 0 0 0 1,713,641
Total Agency Personnel Costs 2,560,176 3,072,211 1,843,326 0 0 0 0 0 0 0 7,475,714
Contract/Consultant Services - Implementation
Project Management/Administration (FY10, 11, 12 - STA + 25% Deloitte (less Development) (Year 2 includes Amendment 3 and Year 3 includes Amendment 4) 1,360,030 1,706,785 3,499,150 0 0 0 0 0 0 0 6,565,965
Requirements (FY10 - 60% of remaining Deloitte (less Development costs) + 60% of Staff Aug) 1,190,642 0 0 0 0 0 0 0 0 0 1,190,642
Design (FY10 - 40% of remaining Deloitte (less Development costs) + 40% of Staff Aug) 793,761 0 0 0 0 0 0 0 0 0 793,761
Development/Programming (FY10, 11, 12 - Based on hours used for develop) 1,230,000 2,460,000 2,091,000 0 0 0 0 0 0 0 5,781,000
System Test (FY11, 12 - 37.5% of remaining Deloitte (less Development and project management)) 0 1,671,793 3,600,169 0 0 0 0 0 0 0 5,271,961
Training (FY11, 12 - 12.5% of remaining Deloitte (less Development and project management) 810,501 561,750 1,200,056 0 0 0 0 0 0 0 2,572,307
Conversion (FY11, 12 - 25% of remaining Deloitte (less Development and project management)) 0 1,123,625 2,400,113 0 0 0 0 0 0 0 3,523,738
Implementation (FY11, 12 - 12.5% of remaining Deloitte (less Development and project management)) 0 561,813 1,200,056 0 0 0 0 0 0 0 1,761,869
Documentation (FY11, 12 - 12.5% of remaining Deloitte (less Development and project management)) 0 561,813 1,200,056 0 0 0 0 0 0 0 1,761,869
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 (FY13 - 2 months post implementation support at $300k @ month) 0 0 0 600,000 0 0 0 0 0 0 600,000
Subtotal Contract/Consultant-Implementation 5,384,934 8,647,578 15,190,600 600,000 0 0 0 0 0 0 29,823,112
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 5,384,934 8,647,578 20,609,542 6,018,942 6,008,461 6,008,461 6,188,715 6,188,715 6,374,376 6,374,376 77,804,100
Total Agency and Contract Personnel Costs 7,945,110 11,719,788 22,452,868 6,018,942 6,008,461 6,008,461 6,188,715 6,188,715 6,374,376 6,374,376 85,279,813
Hardware/Systems Costs
Procurement - Hardware
Hardware - Mainframe 0 0 0 0 0 0 0 0 0 0 -
Hardware - Unix Server (New maintenance environment in FY 12) 1,255,486 0 1,526,500 0 32,625 1,348,792 0 0 0 1,416,232 5,579,635
Hardware - Intel Server (leased servers) 0 0 7,200 7,200 7,200 7,200 7,200 7,200 7,200 7,200 57,600
Hardware - Storage (Universal Storage V Disk Array and Brocade - DW storage in FY 12) 350,823 0 1,875 0 3,125 55,837 60,000 60,000 60,000 60,000 651,659
Hardware - Desktop (leased laptops) 1,875 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 3,750 35,625
Hardware - Network (Cisco Equipment) 72,741 0 5,460 5,460 5,460 5,460 5,460 5,460 5,460 5,460 116,421
Subtotal Hardware Procurement 1,680,924 3,750 1,544,785 16,410 52,160 1,421,039 76,410 76,410 76,410 1,492,642 6,440,941
Maintenance - Hardware
Hardware - Mainframe 0 0 0 0 0 0 0 0 0 0 -
Hardware - Unix Server (P595s) 0 0 122,781 225,000 236,280 225,000 231,750 231,750 238,703 238,703 1,749,966
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 259,883 275,935 264,968 272,917 272,917 281,104 281,104 2,101,000
Procurement - Software
Software - Mainframe 0 0 0 0 0 0 0 0 0 0 -
Software - Unix Server (New maintenance environment in FY 12; ongoing payment of) 1,944,355 540,000 2,108,005 1,000,000 819,950 0 0 0 0 0 6,412,310
Software - Intel Server 0 0 0 0 0 0 0 0 0 0 -
Software - Storage 153,687 0 0 0 0 0 0 0 0 0 153,687
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 2,099,287 545,700 2,126,305 1,008,220 829,670 8,520 8,520 8,520 8,520 8,520 6,651,782
Maintenance - Software
Software - Mainframe 0 0 0 0 0 0 0 0 0 0 -
Software - Unix Server 1,866,509 1,061,960 2,014,270 2,211,395 2,234,303 2,242,811 2,242,811 2,310,096 2,379,399 2,450,781 21,014,334
Software - Intel Server 0 0 3,988 5,155 5,155 5,155 5,155 5,310 5,469 5,633 41,022
Software - Storage 0 0 30,544 30,965 33,367 33,864 33,864 34,880 35,927 37,004 270,417
Software - Desktop 0 0 110 243 243 243 243 251 258 266 1,858
Software - Network 0 0 0 0 0 0 0 0 0 0 -
Subtotal Software Maintenance 1,866,509 1,061,960 2,048,912 2,247,759 2,273,069 2,282,074, 2,282,074 2,350,537 2,421,053 2,493,684 21,327,630
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/Maintenance Expense (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 4,471 4,471 0 0 0 0 0 0 0 0 8,942
Other Costs 4,052 4,052 0 0 0 0 0 0 0 0 8,105
Subtotal Other Costs 71,412 279,142 347,558 347,558 347,558 347,558 355,866 355,866 355,866 355,866 3,164,251
Total Hardware/Systems/Other Costs 5,718,132 1,925,246 6,225,036 3,879,830 3,778,392 4,324,159 2,995,787 3,064,250 3,142,953 4,631,817 39,685,603
Subtotal Project Costs 13,663,243 13,645,035 28,677,904 9,898,772 9,786,853 10,332,620 9,184,052 9,252,965 9,517,330 11,006,193 124,965,416
Contingency 0 2,000,000                 2,000,000
Total Project Costs 13,663,243 15,645,035 28,677,904 9,898,772 9,786,853 10,332,620 9,184,502 9,252,965 9,517,330 11,006,193 126,965,416

Note: The preceding report detailing project costs for the Financials 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.