ProjectONE Report to the 82nd Legislature
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.