Information technology expenditures report : for the period ended... |
Previous | 10 of 18 | Next |
|
small (250x250 max)
medium (500x500 max)
Large
Extra Large
large ( > 500x500)
Full Resolution
|
This page
All
|
NORTH CAROLINA INFORMATION TECHNOLOGY EXPENDITURES REPORT For the Period Ended June 30, 2007 Office of the State Controller Office of Information Technology Services Office of State Budget and Management State of North Carolina Office of the State Controller Michael F. Easley, Governor Robert L. Powell, State Controller October 1, 2007 MEMORANDUM TO: The Honorable Michael F. Easley, Governor The Honorable Marc Basnight, Senate President Pro Tempore The Honorable Joe Hackney, Speaker of the House of Representatives FROM: Robert L. Powell, State Controller David McCoy, State Budget Officer George Bakolia, State Chief Information Officer SUBJECT: Annual Information Technology Expenditures Report Transmittal To fulfill the reporting requirements of G.S. 147-33.87, the Office of the State Controller, Office of Information Technology Services and Office of State Budget and Management have prepared the Information Technology Expenditures Report which outlines the total information technology expenditures within the State. This annual report covers the period July 2006 through June 2007 and is available through the OSC web site at http://www.ncosc.net/financial/ITReport_06302007.pdf. This report shows total information technology (IT) expenditures, excluding the Office of Information Technology Services, of $1,017,543,419 for the fiscal year ending June 30, 2007. This is an increase of $75 million or 8.01% as compared to June 30, 2006. For the Office of Information Technology Services, total IT expenditures were $155,699,845. This is an increase of $25 million or 19.18% as compared to June 30, 2006. Project/Application specific financial costs are again presented using data input into the IT Portfolio Management System administered by the Office of Information Technology Services (ITS). Project/Application costs as reported for agencies subject to G.S. 147-33.87 (excluding ITS) for June 30, 2006 were $345,695,102 and represented 66.92% of total IT expenditures (excluding Administrative Office of the Courts, the NC Education Lottery, the UNC System and ITS). For June 30, 2007 this total is $366,506,720 and represents 67.42% of total IT expenditures. This is an increase of $20.8 million or 6.02% as compared to June 30, 2006. The next report to be published will be for the period from July 2007 through June 2008. For additional information about this report, please contact the Office of the State Controller. cc: Chief Executive Officers Chief Fiscal Officers Chief Information Officers Legislative Fiscal Research State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 TABLE OF CONTENTS Introduction .................................................................................................................................1 Overview of IT Expenditures .................................................................................................2 Report Methodology...............................................................................................................2 Categories..............................................................................................................................3 Summary of IT Expenditures.......................................................................................................4 Table 1-1 IT Expenditures......................................................................................................5 Table 1-2 IT Expenditures – IT Portfolio Management System Detail Cost Categories .......6 Table 1-3 IT Expenditures – UNC System Agencies.............................................................7 Table 1-4 Percentage of IT Expenditures to Total Expenditures............................................8 Expenditure Summary by Budget Code Type .............................................................................9 Table 2-1 IT Expenditures Summary for General Fund Budget Codes ...............................10 Table 2-2 IT Expenditures Summary for All Other Budget Codes ......................................11 Budget to Actual Comparison and Current vs. Prior Year .......................................................12 Table 3-1 IT Expenditures - Budget to Actual Comparison.................................................13 Table 3-2 IT Expenditures - Current versus Prior Year ......................................................14 Table 3-3 IT Expenditures - Current versus Prior Year – UNC System Agencies...............15 IT Related Contracted Personal Services...................................................................................16 Table 4-1 IT Related Contracted Personal Services.............................................................17 Table 4-2 IT Related Contracted Personal Services – UNC System Agencies ....................18 Salary and Fringe Benefit Calculations......................................................................................19 Table 5-1 Salary and Calculated Fringes for All IT Positions .............................................20 Table 5-2 Salary and Calculated Fringes for All IT Positions - UNC System Agencies .....21 Salary Cost by Position Status and Type....................................................................................22 Table 5-3 Total IT Salary and Fringe Amount by Position Status .......................................23 Table 5-4 Total IT Salary and Fringe Amount by Position Status - UNC System Agencies24 Table 5-5 Salary and Calculated Fringes by Banding Category for all IT Positions............25 FTE Comparison between IT Positions and All Positions .........................................................26 Table 5-6 IT FTE’s versus All FTE’s...................................................................................27 Portfolio Management ................................................................................................................28 Table 6-1 IT Expenditures – Projects...................................................................................33 Table 6-2 IT Expenditures – Projects by Source of Funds...................................................45 Table 6-3 IT Expenditures – Applications……………………………………….………...60 Table 6-4 IT Expenditures – Applications by Source of Funds……………..…………....124 THIS PAGE INTENTIONALLY LEFT BLANK State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 1 Introduction The purpose of this report is to provide total information technology (IT) expenditures within the State as required by G.S. 147-33.87 “Financial Reporting and Accountability for Information Technology Investments and Expenditures.” This statute requires an annual report of IT operations and projects expenditures coordinated by the Office of Information Technology Services with the Office of State Budget and Management and the Office of the State Controller. For this report, information technology is defined as “Electronic data processing goods and services, telecommunications goods and services, security goods and services, microprocessors, software, information processing, office systems, any services related to the foregoing, and consulting or other services for design or redesign of information technology supporting business processes (G.S. 147-33.81).” The General Assembly, the Administrative Office of the Courts, the North Carolina Education Lottery, and the UNC System are specifically exempted under G.S. 147-33.80 from these requirements; however, due to readily available financial data in the North Carolina Accounting System for the Administrative Office of the Courts, the North Carolina Education Lottery, and the UNC System, their information is included in this report to provide a more complete picture of information technology expenditures in the State. The General Assembly, the Administrative Office of the Courts, the North Carolina Education Lottery, and the UNC System are not included in the Information Technology Portfolio Management System reporting of project and application expenditures. The basis for this report is the statewide chart of accounts and the personnel classification system. The primary sources of this data are the North Carolina Accounting System (NCAS), the Personnel Management Information System (PMIS), and the Information Technology Portfolio Management System. This report covers the time period of July 2006 through June 2007 and includes all funding sources. In an ongoing effort to refine and improve IT expenditure reporting, several new tables have been added to this year’s report. Reporting of projects and applications was greatly expanded last year by moving from the project reporting in NCAS to the Information Technology Portfolio Management System. The project and application reporting has been expanded to include reporting by source of funds. Since the detail categories used in the Information Technology Portfolio Management System differ from those presented in the total summary reports, Table 1-2 was added to present the total expenditures using those detail categories. Comparison between the two was also enhanced by moving the Administrative Office of the Courts information below the totals line since they do not report project and application information. The banding of IT positions by the Office of State Personnel has made the presentation of IT salary and fringe amounts by pay grade less meaningful. It also led to a review of the class codes currently being included as IT positions. This resulted in the exclusion of 42 codes and represents a reduction of Salary and Benefits included as IT expenditures of $16.2 million. Total IT expenditures would have been 1.6% higher without this exclusion. Expenditures by pay grade have been replaced with a listing by IT Banding Categories. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 2 In the past current vs. prior year information was presented for universities only. Table 3-2 has been added to present this data for other agencies as well. In order to make the report more readable the tables have been reorganized to a more logical grouping and renumbered accordingly. Overview of IT Expenditures Total Information Technology Expenditures excluding ITS PMIS BUDGETED SALARY PLUS FRINGES 36% SERVER 5% MAINFRAME 10% APPLICATIONS DEVELOP AND OTHER 24% TELECOMM 13% LOCAL AREA NETWORK 3% WIDE AREA NETWORK 1% PERSONAL COMPUTER AND PRINTER 7% VIDEO TRANSMISSION 1% Total IT expenditures (excluding ITS) were $1,017,543,419 for fiscal year 2007. IT Expenditures for the Office of Information Technology totaled $155,699,845 during the same period. As can be seen in this chart, PMIS Budgeted Salaries plus Fringes continue to be the largest percentage of IT related expenditures at 36% of total IT expenditures. The next largest categories of expenditures are Applications Development and Other (24%), Telecommunication (13%), and Mainframe (10%). Remaining expenditures are broken down into the additional categories listed on Table 1-1 Information Technology Expenditures. Report Methodology Under the NCAS chart of accounts, most information technology operational costs are identified through specific account codes. The primary exception is personnel related costs that are recorded within NCAS in aggregate, without regard to the type of work performed by the position. These costs include salary, fringe benefits, and employee training expenses. To estimate salary and fringe benefit costs associated to information technology positions, this report utilizes the class code structure within PMIS. Budgeted salary for all permanent positions assigned an information technology specific class code is used to estimate each agency’s personal services obligation for this fiscal year. The budgeted salary amounts include both vacant and filled positions. Next year, this information will be taken from the new BEACON HR Payroll system. Upon full implementation of BEACON for a complete fiscal reporting period, actual costs will be reported rather than just budgeted amounts. Employee training costs for IT personnel cannot be compiled or estimated using NCAS or PMIS. These costs are not included in this report. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 3 All other non personnel costs are grouped into reporting categories as follows: Category Description Personal Computers and Printers Costs associated with the purchase, lease, and support of personal computers, software, and printers Local Area Network Costs associated with the purchase, lease, and support of hardware and wiring comprising a local area network Wide Area Network Costs associated with equipment and communication lines to provide video and data connectivity services across a large geographical area. Video Transmission Costs associated with the transmission of video images, including equipment, support, and North Carolina Information Highway (NCIH) charges. Video conferencing and distance education are primary uses of this technology. Server Costs associated with the purchase, lease, and support of servers and the software installed on the server. Mainframe Costs associated with the purchase, lease, and support of a mainframe computer and software. Costs include both purchased and developed software. Applications Development and Other Costs associated with computer related hardware, software, contractual services, or maintenance that has not been otherwise categorized. This category includes costs for development of new applications. Telecommunications Costs associated with providing voice and data communications. A detailed list of accounts in each category may be obtained by contacting the Office of the State Controller. The Department of Transportation (DOT) posts some work order based costs in aggregate as deferred charges or other assets within NCAS. To obtain a more complete picture of IT costs, non-personnel related costs for the Department of Transportation are from the DOT financial system. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 4 Summary of IT Expenditures Table 1-1 Information Technology Expenditures lists by agency, the total IT expenditures grouped into major cost categories. The amounts listed are total costs, without regard to the funding source. As a primary IT services vendor for most agencies, the Office of Information Technology Services is shown separately and is not included in the report totals. Table 1-2 Information Technology Expenditures – Information Technology Portfolio Management System Detail Cost Categories lists by agency, the total IT expenditures grouped into the detail cost categories used in the Information Technology Portfolio Management System. The amounts listed are total costs, without regard to the funding source. As a primary IT services vendor for most agencies, the Office of Information Technology Services is shown separately and is not included in the report totals. Table 1-3 Information Technology Expenditures - UNC System Agencies lists by university the total IT expenditures grouped into major cost categories. Costs are segregated into the same categories as used in Table 1-1. Personnel costs are estimated using PMIS data; however, UNC System agencies operating their own payroll systems are not required to enter EPA position information into PMIS. UNC General Administration provided EPA position summary data which was included in this report. Table 1-4 Percentage of IT Expenditures to Total Expenditures lists, by agency, the percentage of total IT expenditures compared to total expenditures, without regard to funding source. Information Technology expenditures represent 1.68% of total expenditures for all agencies listed (excluding the Office of Information Technology Services). The Office of Information Technology Services has IT expenditures totaling 86.90% of their total expenditures. Page 5 PMIS BUDGETED SALARY PLUS FRINGES PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Comprehensive Major Medical Plan 146,744 159,999 28,199 0 0 1,358 24,355 0 91,515 452,170 Community Colleges System Office 5,328,240 105,884 98,436 242 4,781 3,290,746 278,419 12,521,143 77,959 21,705,850 Department of Administration 1,555,235 220,091 851,737 9,965 135,133 87,066 861,365 454,949 642,487 4,818,028 Department of Agriculture & Consumer Services 2,521,447 871,005 415 108,629 1,032 196,231 106,426 247,810 864,483 4,917,478 Department of Commerce 3,113,972 709,057 325,083 20,320 315 441,996 570,679 1,995,157 761,909 7,938,488 Department of Correction 9,127,850 2,235,580 232,618 11,879 156,773 435,353 8,460,142 1,138,113 4,868,196 26,666,504 Department of Crime Control & Public Safety 4,497,230 2,693,098 71,054 385,138 71,960 1,142,196 351,599 22,413,897 17,999,666 49,625,838 Department of Cultural Resources 1,056,958 486,123 2,647 0 0 23,690 198,872 253,549 537,686 2,559,525 Department of Environment & Natural Resources 9,982,223 2,192,292 102,816 252,279 18,042 932,864 793,201 3,087,119 3,565,634 20,926,470 Department of Health and Human Services 29,405,385 4,388,367 14,632,024 566,076 5,159 2,912,482 21,152,808 82,625,892 11,989,964 167,678,157 Department of Insurance 1,603,208 187,648 26,257 58,811 0 467,519 47,662 126,832 367,541 2,885,478 Department of Justice 5,499,219 2,736 5,400 174,160 0 0 402,072 4,172,750 2,325,520 12,581,857 Department of Juvenile Justice & Delinquency Prevention 2,230,189 599,489 5,425 52,558 0 201,959 97,244 357,376 1,206,004 4,750,244 Department of Labor 723,466 120,274 60,850 52,608 0 17,394 45,152 92,488 371,783 1,484,015 Department of Public Instruction 11,013,156 1,111,580 1,735,489 2,958,957 1,848,011 2,170,569 1,439,081 7,698,982 3,004,123 32,979,948 Department of Revenue 8,266,285 1,087,437 360,526 60,462 6,835 1,422,909 7,313,653 3,903,398 2,698,938 25,120,443 Department of Secretary of State 828,501 127,260 62,160 24,109 0 119,846 135,676 50,829 114,261 1,462,642 Department of Transportation 30,954,547 3,650,341 22,007 17,887 44,225 144,261 27,527,463 11,979,597 16,771,057 91,111,385 Department of the State Treasurer 3,846,394 0 0 1,019 0 0 256,677 4,017,648 590,113 8,711,851 Employment Security Commission 8,956,746 806,407 366,832 14,921 0 824,573 3,091,943 2,180,097 2,716,155 18,957,674 NC Housing Finance Authority 593,879 0 0 0 0 0 12,563 1,132,118 52,655 1,791,215 NC School Science & Math 363,763 171,254 4,999 0 0 1,867 58,674 25,841 37,040 663,438 NC Wildlife Resources 1,424,078 306,767 267,552 239,337 927 46,264 333,513 1,731,011 848,971 5,198,420 Office of Administrative Hearings 65,734 56,135 0 (117) 0 9,093 5,194 0 44,703 180,742 Office of the Governor 894,018 64,420 13,905 504 0 60,802 173,329 62,987 115,405 1,385,370 Office of the Lieutenant Governor 0 0 12,002 0 0 1,759 3,675 4,368 14,695 36,499 Office of the State Auditor 585,654 123,025 8,083 0 0 65,945 111,482 109,707 63,515 1,067,411 Office of the State Controller 4,278,432 262,567 612,310 6,387 196 3,867,920 2,223,594 12,101,357 215,958 23,568,721 State Board of Elections 1,960,914 62,972 40,581 11,191 0 45,987 29,855 39,206 217,485 2,408,191 TOTAL w/out UNC System, Lottery, AOC & ITS 150,823,464 22,801,808 19,949,407 5,027,322 2,293,389 18,932,649 76,106,368 174,524,221 73,175,421 543,634,049 Administrative Office of the Courts 18,404,367 6,049,803 30,718 433,916 (19,554) 58,158 4,743,680 3,711,041 8,579,095 41,991,224 NC Education Lottery 1,795,010 178,067 92,235 114,653 0 69,088 6,395 69,090 612,258 2,936,796 UNC System 205,167,247 37,650,174 12,322,819 4,574,309 4,243,705 28,739,858 20,945,549 63,007,938 52,329,752 428,981,351 Total Without ITS 376,190,087 66,679,852 32,395,179 10,150,200 6,517,540 47,799,753 101,801,992 241,312,290 134,696,526 1,017,543,419 Office of Information Technology Services 37,494,460 924,947 2,636,937 5,230,655 2,037,059 23,795,475 24,667,543 9,756,408 49,156,361 155,699,845 Note: PMIS Budgeted salary amounts plus calculated fringe benefit cost amounts are used to represent total salary cost, which means that the cost is overstated by the amount of lapsed salaries generated by vacant IT positions. The overstatement could be as much as $49.8 million. Table 1-1 Information Technology Expenditures for Year Ended June 30, 2007 Page 6 INTERNAL PERSONNEL COSTS EXTERNAL PERSONNEL COSTS OTHER EXTERNAL COSTS HARDWARE COSTS SOFTWARE COSTS OTHER COSTS YTD TOTALS Comprehensive Major Medical Plan 146,744 40 140,040 122,352 42,994 0 452,170 Community Colleges System Office 5,328,240 12,538,248 386,496 192,054 3,253,071 7,741 21,705,850 Department of Administration 1,555,235 500,444 2,301,957 235,610 175,318 49,464 4,818,028 Department of Agriculture & Consumer Services 2,521,447 61,987 1,077,190 977,907 242,657 36,290 4,917,478 Department of Commerce 3,113,972 1,929,354 1,345,114 637,185 815,336 97,527 7,938,488 Department of Correction 9,127,850 81,121 12,486,074 3,461,890 1,272,403 237,166 26,666,504 Department of Crime Control & Public Safety 4,497,230 21,985,641 2,534,150 19,281,903 1,273,953 52,961 49,625,838 Department of Cultural Resources 1,056,958 229,001 762,895 430,369 77,406 2,896 2,559,525 Department of Environment & Natural Resources 9,982,223 2,384,336 4,087,054 2,483,932 1,738,374 250,551 20,926,470 Department of Health and Human Services 29,405,385 91,631,239 35,328,696 6,142,819 3,386,280 1,783,738 167,678,157 Department of Insurance 1,603,208 17,083 437,782 473,951 244,952 108,502 2,885,478 Department of Justice 5,499,219 572,986 2,780,232 1,727,082 1,641,343 360,995 12,581,857 Department of Juvenile Justice & Delinquency Prevention 2,230,189 120,418 1,202,283 845,200 171,575 180,579 4,750,244 Department of Labor 723,466 55,860 491,927 177,406 31,474 3,882 1,484,015 Department of Public Instruction 11,013,156 7,332,336 7,478,266 2,630,630 4,343,703 181,857 32,979,948 Department of Revenue 8,266,285 3,218,385 9,362,242 2,894,548 1,151,525 227,458 25,120,443 Department of Secretary of State 828,501 37,504 131,967 250,104 214,566 0 1,462,642 Department of Transportation 30,954,547 10,302,200 43,474,641 5,280,962 1,099,035 0 91,111,385 Department of the State Treasurer 3,846,394 1,696,110 844,717 955,412 1,323,964 45,254 8,711,851 Employment Security Commission 8,956,746 1,869,591 5,358,605 1,575,402 1,197,330 0 18,957,674 NC Housing Finance Authority 593,879 841,007 65,218 240,137 25,254 25,720 1,791,215 NC School Science & Math 363,763 0 95,714 177,133 26,828 0 663,438 NC Wildlife Resources 1,424,078 1,390,203 1,321,969 560,985 436,140 65,045 5,198,420 Office of Administrative Hearings 65,734 0 49,780 37,652 27,576 0 180,742 Office of the Governor 894,018 1,790 308,685 53,647 106,308 20,922 1,385,370 Office of the Lieutenant Governor 0 5,488 27,917 1,044 0 2,050 36,499 Office of the State Auditor 585,654 0 182,391 162,056 137,310 0 1,067,411 Office of the State Controller 4,278,432 12,338,944 2,549,406 1,078,169 3,295,182 28,588 23,568,721 State Board of Elections 1,960,914 52,553 269,380 100,360 23,242 1,742 2,408,191 TOTAL w/out UNC System, Lottery, AOC & ITS 150,823,464 171,193,869 136,882,788 53,187,901 27,775,099 3,770,928 543,634,049 Administrative Office of the Courts 18,404,367 2,219,711 4,375,569 9,691,228 7,229,203 71,146 41,991,224 NC Education Lottery 1,795,010 31,626 768,897 259,284 38,572 43,407 2,936,796 UNC System 205,167,247 6,994,834 70,531,069 83,898,068 45,601,088 16,789,045 428,981,351 Total Without ITS 376,190,087 180,440,040 212,558,323 147,036,481 80,643,962 20,674,526 1,017,543,419 Office of Information Technology Services 37,494,460 4,897,200 55,907,331 21,461,566 35,397,434 541,854 155,699,845 * Report revised 10/31/07 Note: PMIS Budgeted salary amounts plus calculated fringe benefit cost amounts are used to represent total salary cost, which means that the cost is overstated by the amount of lapsed salaries generated by vacant IT positions. The overstatement could be $49.8 million. Table 1-2 Information Technology Expenditures Grouped According to IT Portfolio Management System Detail Cost Categories* for Year Ended June 30, 2007 PMIS BUDGETED SALARY PLUS FRINGES PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Appalachian State University 7,951,315 0 0 52,458 18,672 0 25,270 6,238,811 1,235,524 15,522,050 East Carolina University 19,134,749 4,121,674 1,969,327 194,447 162,938 3,636,260 1,548,935 6,470,179 2,557,312 39,795,821 Elizabeth City State University 1,751,377 172,019 151,175 80,803 27,614 37,432 46,071 1,233,474 417,604 3,917,569 Fayetteville State University 2,232,406 532,487 224,743 182,421 1,440 250,337 61,890 951,082 685,672 5,122,478 NC A&T State University 4,562,812 101,164 3,084,846 76,954 104,595 981,077 69,638 2,535,574 1,066,828 12,583,488 NC Central University 3,741,857 0 0 745,558 69,645 0 20,199 4,232,460 1,268,491 10,078,210 NC School of Arts 894,024 845,371 5,604 1,018 0 94,055 57,673 148,169 396,680 2,442,594 NC State University 36,048,417 10,408,365 1,890,994 489,918 2,646,761 9,790,750 2,017,148 6,024,306 11,523,567 80,840,226 UNC Asheville 2,071,318 1,201,495 113,741 26,767 23,334 230,415 40,713 191,793 392,060 4,291,636 UNC Chapel Hill 72,390,434 -41,159 139,703 964,388 249,259 155,262 5,675,892 17,214,399 14,839,455 111,587,633 UNC Charlotte 12,880,910 5,460,786 1,632,296 224,731 251,720 2,839,217 98,482 4,091,813 3,444,435 30,924,390 UNC General Administration 4,260,363 848,501 122,886 1,114,929 14,483 225,082 9,344,258 590,525 718,130 17,239,157 UNC Greensboro 11,956,939 5,020,612 349,979 53,871 217,260 1,314,993 112,803 5,040,214 5,217,982 29,284,653 UNC Hospital 8,046,536 327,366 350,130 6,725 1,470 4,990,113 1,182,809 1,305,299 3,570,144 19,780,592 UNC Pembroke 2,334,861 1,535,823 48,075 17,606 0 727,163 102,847 1,686,121 575,250 7,027,746 UNC Wilmington 7,185,424 1,781,422 432,853 84,504 226,113 1,826,341 28,559 1,584,662 2,210,482 15,360,360 Western Carolina University 4,735,882 2,109,835 1,712,177 36,330 152,906 716,175 422,176 1,256,563 652,732 11,794,776 Winston-Salem State University 2,987,622 3,224,413 94,290 220,881 75,495 925,186 90,186 2,212,494 1,557,404 11,387,971 TOTAL UNC System 205,167,247 37,650,174 12,322,819 4,574,309 4,243,705 28,739,858 20,945,549 63,007,938 52,329,752 428,981,351 Table 1-3 Information Technology Expenditures UNC System Agencies for Year Ended June 30, 2007 Page 7 Page 8 Total IT Expenditures Total Expenditures % IT Expenditures to Total Expenditures Comprehensive Major Medical Plan 452,170 2,322,108,958 0.02% Community Colleges System Office 21,705,850 1,179,183,787 1.84% Department of Administration 4,818,028 207,194,190 2.33% Department of Agriculture & Consumer Services 4,917,478 118,871,098 4.14% Department of Commerce 7,938,488 329,555,623 2.41% Department of Correction 26,666,504 1,386,840,661 1.92% Department of Crime Control & Public Safety 49,625,838 440,730,410 11.26% Department of Cultural Resources 2,559,525 102,842,375 2.49% Department of Environment & Natural Resources 20,926,470 828,527,995 2.53% Department of Health and Human Services 167,678,157 15,184,014,120 1.10% Department of Insurance 2,885,478 92,598,277 3.12% Department of Justice 12,581,857 137,531,456 9.15% Department of Juvenile Justice & Delinquency Prevention 4,750,244 158,532,627 3.00% Department of Labor 1,484,015 27,698,998 5.36% Department of Public Instruction 32,979,948 9,043,165,880 0.36% Department of Revenue 25,120,443 3,181,388,679 0.79% Department of Secretary of State 1,462,642 11,330,915 12.91% Department of Transportation 91,111,385 3,686,087,640 2.47% Department of the State Treasurer 8,711,851 10,103,743,798 0.09% Employment Security Commission 18,957,674 1,090,853,536 1.74% NC Housing Finance Authority 1,791,215 59,881,643 2.99% NC School Science & Math 663,438 18,915,641 3.51% NC Wildlife Resources 5,198,420 132,013,055 3.94% Office of Administrative Hearings 180,742 3,135,891 5.76% Office of the Governor 1,385,370 140,287,769 0.99% Office of the Lieutenant Governor 36,499 869,277 4.20% Office of the State Auditor 1,067,411 16,286,908 6.55% Office of the State Controller 23,568,721 30,918,423 76.23% State Board of Elections 2,408,191 17,630,475 13.66% TOTAL w/out UNC System, Lottery, AOC & ITS 543,634,049 50,052,740,103 1.09% Administrative Office of the Courts 41,991,224 514,167,246 8.17% NC Education Lottery 2,936,796 558,611,172 0.20% UNC System 428,981,351 9,297,364,811 4.61% Total Without ITS 1,017,543,419 60,422,883,333 1.68% Office of Information Technology Services 155,699,845 179,179,661 86.90% Table 1-4 Percentage of IT Expenditures to Total Expenditures for Year Ended June 30, 2007 Note: Total Expenditures does not include Intragovernmental Transfers except Reimbursement Accounts beginning with 5382 and 5383. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 9 Expenditure Summary by Budget Code Type While Table 1-1 shows all IT expenditures for fiscal year 2007, a further analysis can be performed. The expenditures in Table 1-1 (excluding the Office of Information Technology Services) can be broken down by budget code as follows: IT Expenditures Percentage of Total General Fund Budget Codes $674,600,380 66.30% All Other Budget Codes $342,943,039 33.70% Total of all Budget Codes $1,017,543,419 100.00% Based on budget codes, 66.30% of the IT expenditures listed in Table 1-1 were incurred in General Fund Budget Codes. All other Budget Codes total 33.70% of all IT expenditures. Greater detail on these numbers is contained in the following schedules: − Table 2-1 Information Technology Expenditures for General Fund Budget Codes contains IT expenditures, by agency for all Budget Codes contained in the General Fund. − Table 2-2 Information Technology Expenditures for All Other Budget Codes contains IT expenditures, by agency for all Non-General Fund Budget Codes. PMIS BUDGETED SALARY PLUS FRINGES PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Comprehensive Major Medical Plan 0 0 0 0 0 0 0 0 0 0 Community Colleges System Office 5,328,240 105,884 98,436 242 4,781 3,290,746 278,419 12,521,143 77,959 21,705,850 Department of Administration 1,555,235 203,363 692,807 5,743 99,503 76,466 811,184 46,036 487,130 3,977,467 Department of Agriculture & Consumer Services 2,426,841 860,459 415 108,475 1,067 195,999 97,295 235,624 729,158 4,655,333 Department of Commerce 1,753,128 449,929 306,912 5,783 0 210,584 550,565 907,760 459,913 4,644,574 Department of Correction 8,423,449 1,831,525 187,774 1,235 386 436,683 8,460,142 758,871 4,674,233 24,774,298 Department of Crime Control & Public Safety 755,992 561,099 14,999 1,262 0 18,466 220,843 11,058,312 969,495 13,600,468 Department of Cultural Resources 1,056,958 484,251 2,437 0 0 22,907 195,005 253,549 520,732 2,535,839 Department of Environment & Natural Resources 7,901,683 1,891,173 76,872 225,383 17,972 773,387 695,814 2,107,673 3,212,222 16,902,179 Department of Health and Human Services 27,990,664 4,313,390 14,198,383 566,076 5,159 2,912,482 21,150,414 82,332,290 11,493,799 164,962,657 Department of Insurance 1,603,208 162,156 26,257 54,826 0 466,689 47,662 115,902 357,204 2,833,904 Department of Justice 5,499,219 0 5,400 172,231 0 0 312,841 3,348,602 2,254,602 11,592,895 Department of Juvenile Justice & Delinquency Prevention 2,230,189 573,491 5,425 52,558 0 201,959 97,244 352,223 1,203,267 4,716,356 Department of Labor 723,466 103,924 60,850 30,954 0 17,394 45,152 89,827 317,527 1,389,094 Department of Public Instruction 11,013,156 1,111,142 1,735,489 2,958,124 1,848,011 2,170,569 1,439,081 7,696,974 2,998,560 32,971,106 Department of Revenue 8,266,285 1,087,437 360,526 60,462 6,835 1,422,909 6,865,459 3,903,398 2,698,938 24,672,249 Department of Secretary of State 828,501 127,260 62,160 24,109 0 119,846 114,452 50,829 114,261 1,441,418 Department of Transportation 0 0 0 0 0 0 0 0 0 0 Department of the State Treasurer 3,846,394 0 0 372 0 0 256,677 3,736,243 563,551 8,403,237 Employment Security Commission 0 0 0 0 0 0 0 0 0 0 NC Housing Finance Authority 0 0 0 0 0 0 0 0 0 0 NC School Science & Math 363,763 169,955 4,999 0 0 1,867 58,674 25,841 37,040 662,139 NC Wildlife Resources 0 0 0 0 0 0 0 0 0 0 Office of Administrative Hearings 65,734 56,135 0 (117) 0 9,093 5,194 0 44,703 180,742 Office of the Governor 894,018 59,684 13,905 230 0 60,565 173,329 61,197 113,506 1,376,434 Office of the Lieutenant Governor 0 0 12,002 0 0 1,759 3,675 4,368 14,695 36,499 Office of the State Auditor 585,654 123,025 8,083 0 0 65,945 111,482 109,707 63,515 1,067,411 Office of the State Controller 4,278,432 196,002 584,135 6,387 196 2,415,299 2,075,778 277,293 204,511 10,038,033 State Board of Elections 1,960,914 62,972 40,581 11,191 0 45,987 29,855 39,206 217,485 2,408,191 TOTAL w/out UNC System, Lottery, AOC & ITS 99,351,122 14,534,256 18,498,847 4,285,526 1,983,910 14,937,601 44,096,236 130,032,868 33,828,006 361,548,372 Administrative Office of the Courts 14,754,020 5,108,097 5,650 422,789 94 132,706 4,734,442 3,066,232 8,550,635 36,774,665 NC Education Lottery 0 0 0 0 0 0 0 0 0 0 UNC System 136,518,467 30,563,441 8,127,421 2,807,613 2,976,151 20,508,652 13,084,098 40,342,447 21,349,053 276,277,343 Total Without ITS 250,623,609 50,205,794 26,631,918 7,515,928 4,960,155 35,578,959 61,914,776 173,441,547 63,727,694 674,600,380 Office of Information Technology Services 0 0 0 0 0 0 0 0 0 0 Table 2-1 Information Technology Expenditures for General Fund Budget Codes for Year Ended June 30, 2007 Page 10 PMIS BUDGETED SALARY PLUS FRINGES PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Comprehensive Major Medical Plan 146,744 159,999 28,199 0 0 1,358 24,355 0 91,515 452,170 Community C olleges System Office 0 0 0 0 0 0 0 0 0 0 Department of Administration 0 16,728 158,930 4,222 35,630 10,600 50,181 408,913 155,357 840,561 Department of Agriculture & Consumer Services 94,605 10,546 0 154 (35) 232 9,131 12,186 135,325 262,144 Department of Commerce 1,360,844 259,128 18,171 14,537 315 231,412 20,114 1,087,397 301,996 3,293,914 Department of Correction 704,400 404,055 44,844 10,644 156,387 (1,330) 0 379,242 193,963 1,892,205 Department of Crime Control & Public Safety 3,741,239 2,131,999 56,055 383,876 71,960 1,123,730 130,756 11,355,585 17,030,171 36,025,371 Department of Cultural Resources 0 1,872 210 0 0 783 3,867 0 16,954 23,686 Department of Environment & Natural Resources 2,080,540 301,119 25,944 26,896 70 159,477 97,387 979,446 353,412 4,024,291 Department of Health and Human Services 1,414,720 74,977 433,641 0 0 0 2,394 293,602 496,165 2,715,499 Department of Insurance 0 25,492 0 3,985 0 830 0 10,930 10,337 51,574 Department of Justice 0 2,736 0 1,929 0 0 89,231 824,148 70,918 988,962 Department of Juvenile Justice & Delinquency Prevention 0 25,998 0 0 0 0 0 5,153 2,737 33,888 Department of Labor 0 16,350 0 21,654 0 0 0 2,661 54,256 94,921 Department of Public Instruction 0 438 0 833 0 0 0 2,008 5,563 8,842 Department of Revenue 0 0 0 0 0 0 448,194 0 0 448,194 Department of Secretary of State 0 0 0 0 0 0 21,224 0 0 21,224 Department of Transportation 30,954,547 3,650,341 22,007 17,887 44,225 144,261 27,527,463 11,979,597 16,771,057 91,111,385 Department of the State Treasurer 0 0 0 647 0 0 0 281,405 26,562 308,614 Employment Security Commission 8,956,746 806,407 366,832 14,921 0 824,573 3,091,943 2,180,097 2,716,155 18,957,674 NC Housing Finance Authority 593,879 0 0 0 0 0 12,563 1,132,118 52,655 1,791,215 NC School Science & Math 0 1,299 0 0 0 0 0 0 0 1,299 NC Wildlife Resources 1,424,078 306,767 267,552 239,337 927 46,264 333,513 1,731,011 848,971 5,198,420 Office of Administrative Hearings 0 0 0 0 0 0 0 0 0 0 Office of the Governor 0 4,736 0 274 0 237 0 1,790 1,899 8,936 Office of the Lieutenant Governor 0 0 0 0 0 0 0 0 0 0 Office of the State Auditor 0 0 0 0 0 0 0 0 0 0 Office of the State Controller 0 66,565 28,175 0 0 1,452,621 147,816 11,824,064 11,447 13,530,688 State Board of Elections 0 0 0 0 0 0 0 0 0 0 TOTAL w/out UNC System, Lottery, AOC & ITS 51,472,342 8,267,552 1,450,560 741,796 309,479 3,995,048 32,010,132 44,491,353 39,347,415 182,085,677 Administrative Office of the Courts 3,650,347 941,706 25,068 11,127 (19,648) (74,548) 9,238 644,809 28,460 5,216,559 NC Education Lottery 1,795,010 178,067 92,235 114,653 0 69,088 6,395 69,090 612,258 2,936,796 UNC System 68,648,780 7,086,733 4,195,398 1,766,696 1,267,554 8,231,206 7,861,451 22,665,491 30,980,699 152,704,008 Total Without ITS 125,566,478 16,474,058 5,763,261 2,634,272 1,557,385 12,220,794 39,887,216 67,870,743 70,968,832 342,943,039 Office of Information Technology Services 37,494,460 924,947 2,636,937 5,230,655 2,037,059 23,795,475 24,667,543 9,756,408 49,156,361 155,699,845 Table 2-2 Information Technology Expenditures for All Other Budget Codes for Year Ended June 30, 2007 Page 11 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 12 Budget to Actual Comparison and Current vs. Prior Year Table 3-1 Information Technology Expenditures - Budget to Actual Comparison provides an indication of budget utilization for IT expenditures as of the end of the report period. A 100% utilization rate indicates that the agency spent their entire budget by fiscal year end. The total budget estimate is calculated using budgeted PMIS salary information and the authorized budget amounts as posted within NCAS for the non salary cost categories. Agency budgets are controlled at the certification level which is a more summarized level than the NCAS accounts within some IT expenditure categories. The State Budget Manual allows agencies flexibility to maintain their budgets at a different level than expenditures, and many agencies take advantage of this flexibility. This table does not include the UNC System agencies or the Department of Transportation. Department of Transportation does not provide budgetary data from their financial system at this time. UNC System agencies are allowed to post budgets at a highly summarized level; therefore, none of the budget can be identified within NCAS as related to IT cost categories. For the remaining agencies, the overall budget utilization percentage is 88.57% which is lower than the expected rate of 100%. This indicates that agencies, in total, continue to spend less than the budgeted amount. The Department of Correction and Department of the State Treasurer had expenditures in excess of 100% of budget. Table 3-2 Information Technology Expenditures – Current Year versus Prior Year provides a comparison to prior year expenditures. Total IT expenditures excluding the Office of Information Technology Services increased $75,425,881 and represent an 8.01% increase. Schematic class codes in the PMIS system were excluded from this year’s report which had previously been included. Therefore the year to year increase is slightly understated. Table 3-3 Information Technology Expenditures – Current Year versus Prior Year – UNC System Agencies provides a comparison to prior year expenditures for UNC System Agencies. In prior reports this information presented current expenditures as a percentage of prior year expenditures. The format has been changed to match that of Table 3-2. Expenditures are now reported as an increase or decrease of the prior year expenditures. Total expenditures for UNC System Agencies increased $34,471,851 and represent an 8.74% increase. PMIS ANNUAL BUDGETED SALARY AUTHORIZED BUDGET NON_SALARY ACCOUNTS TOTAL BUDGET ESTIMATE YTD ACTUAL ACTUAL as % of BUDGET Note 1 Comprehensive Major Medical Plan 146,744 404,800 551,544 452,170 81.98% Community Colleges System Office 5,328,240 16,880,099 22,208,339 21,705,850 97.74% Department of Administration 1,555,235 3,831,027 5,386,262 4,818,028 89.45% Department of Agriculture & Consumer Services 2,521,447 2,836,193 5,357,640 4,917,478 91.78% Department of Commerce 3,113,972 6,274,069 9,388,041 7,938,488 84.56% Department of Correction 9,127,850 17,368,354 26,496,204 26,666,504 100.64% Department of Crime Control & Public Safety 4,497,230 76,776,141 81,273,371 49,625,838 61.06% Department of Cultural Resources 1,056,958 1,633,736 2,690,694 2,559,525 95.13% Department of Environment & Natural Resources 9,982,223 14,733,706 24,715,929 20,926,470 84.67% Department of Health and Human Services 29,405,385 157,033,743 186,439,128 167,678,157 89.94% Department of Insurance 1,603,208 1,506,511 3,109,719 2,885,478 92.79% Department of Justice 5,499,219 8,321,501 13,820,720 12,581,857 91.04% Department of Juvenile Justice & Delinquency Prevention 2,230,189 2,822,009 5,052,198 4,750,244 94.02% Department of Labor 723,466 779,343 1,502,809 1,484,015 98.75% Department of Public Instruction 11,013,156 24,083,443 35,096,599 32,979,948 93.97% Department of Revenue 8,266,285 16,987,312 25,253,597 25,120,443 99.47% Department of Secretary of State 828,501 667,413 1,495,914 1,462,642 97.78% Department of the State Treasurer 3,846,394 4,840,782 8,687,176 8,711,851 100.28% Employment Security Commission 8,956,746 10,468,307 19,425,053 18,957,674 97.59% NC Housing Finance Authority 593,879 1,213,497 1,807,376 1,791,215 99.11% NC School Science & Math 363,763 355,327 719,090 663,438 92.26% NC Wildlife Resources 1,424,078 3,951,984 5,376,062 5,198,420 96.70% Office of Administrative Hearings 65,734 117,005 182,739 180,742 98.91% Office of the Governor 894,018 517,707 1,411,725 1,385,370 98.13% Office of the Lieutenant Governor 0 37,244 37,244 36,499 98.00% Office of the State Auditor 585,654 508,175 1,093,829 1,067,411 97.58% Office of the State Controller 4,278,432 19,316,939 23,595,371 23,568,721 99.89% State Board of Elections 1,960,914 984,663 2,945,577 2,408,191 81.76% TOTAL without DOT, AOC, Lottery & ITS 119,868,917 395,251,030 515,119,947 452,522,664 87.85% Administrative Office of the Courts 18,404,367 24,601,321 43,005,688 41,991,224 97.64% NC Education Lottery 1,795,010 1,757,136 3,552,146 2,936,796 82.68% Total Without DOT & ITS 140,068,293 421,609,487 561,677,780 497,450,683 88.57% Office of Information Technology Services 37,494,460 143,469,962 180,964,422 155,699,845 86.04% Table 3-1 Information Technology Expenditures - Budget to Actual Comparison for Year Ended June 30, 2007 Note 1: The State Budget Manual allows agencies some flexibility to maintain their budget at a different level than they post expenditures. Page 13 Page 14 Current Expenditures at 06/30/07 Total Expenditures at 06/30/06 Increase / (Decrease) % Change Comprehensive Major Medical Plan 452,170 244,038 208,131 85.29% Community Colleges System Office 21,705,850 17,797,261 3,908,589 21.96% Department of Administration 4,818,028 5,891,932 (1,073,905) -18.23% Department of Agriculture & Consumer Services 4,917,478 4,912,594 4,883 0.10% Department of Commerce 7,938,488 6,455,090 1,483,398 22.98% Department of Correction 26,666,504 29,946,890 (3,280,387) -10.95% Department of Crime Control & Public Safety 49,625,838 26,855,815 22,770,023 84.79% Department of Cultural Resources 2,559,525 2,556,898 2,627 0.10% Department of Environment & Natural Resources 20,926,470 20,283,419 643,051 3.17% Department of Health and Human Services 167,678,157 171,564,109 (3,885,952) -2.27% Department of Insurance 2,885,478 3,033,293 (147,816) -4.87% Department of Justice 12,581,857 14,740,824 (2,158,967) -14.65% Department of Juvenile Justice & Delinquency Prevention 4,750,244 5,222,653 (472,410) -9.05% Department of Labor 1,484,015 1,644,175 (160,160) -9.74% Department of Public Instruction 32,979,948 32,308,951 670,997 2.08% Department of Revenue 25,120,443 24,028,435 1,092,008 4.54% Department of Secretary of State 1,462,642 1,268,498 194,144 15.31% Department of the State Treasurer 8,711,851 8,886,162 (174,311) -1.96% Department of Transportation 91,111,385 89,859,797 1,251,588 1.39% Employment Security Commission 18,957,674 18,427,513 530,161 2.88% NC Housing Finance Authority 1,791,215 1,117,471 673,744 60.29% NC School Science & Math 663,438 591,314 72,124 12.20% NC Wildlife Resources 5,198,420 5,609,063 (410,644) -7.32% Office of Administrative Hearings 180,742 161,952 18,790 11.60% Office of the Governor 1,385,370 1,179,011 206,359 17.50% Office of the Lieutenant Governor 36,499 36,387 112 0.31% Office of the State Auditor 1,067,411 943,445 123,966 13.14% Office of the State Controller 23,568,721 18,717,495 4,851,227 25.92% State Board of Elections 2,408,191 2,288,502 119,689 5.23% TOTAL w/out UNC System, Lottery, AOC & ITS 543,634,049 516,572,987 27,061,062 5.24% Administrative Office of the Courts 41,991,224 29,747,295 12,243,928 41.16% NC Education Lottery 2,936,796 1,287,756 1,649,040 128.06% UNC System 428,981,351 394,509,500 34,471,851 8.74% Total Without ITS 1,017,543,419 942,117,538 75,425,881 8.01% Office of Information Technology Services 155,699,845 130,637,429 25,062,415 19.18% Table 3-2 Information Technology Expenditures - Current Year Versus Prior Year for Year Ended June 30, 2007 Note: A difference of approximately $1.3 million in total 2006 expenditures is due to the omission of the NC Education Lottery and workshop related IT expenditures from some agencies on the 2006 published report. These are included here for comparison purposes. NC Education Lottery PMIS data is not available for 2006. Current Expenditures at 06/30/07 Total Expenditures at 06/30/06 Increase / (Decrease) % Change Appalachian State University 15,522,050 16,316,020 (793,971) -4.87% East Carolina University 39,795,821 37,499,927 2,295,894 6.12% Elizabeth City State University 3,917,569 4,330,687 (413,118) -9.54% Fayetteville State University 5,122,478 4,731,123 391,356 8.27% NC A&T State University 12,583,488 11,655,758 927,730 7.96% NC Central University 10,078,210 9,636,510 441,700 4.58% NC School of Arts 2,442,594 2,175,881 266,713 12.26% NC State University 80,840,226 77,777,388 3,062,839 3.94% UNC Asheville 4,291,636 3,779,164 512,472 13.56% UNC Chapel Hill 111,587,633 107,186,500 4,401,133 4.11% UNC Charlotte 30,924,390 25,696,183 5,228,206 20.35% UNC General Administration 17,239,157 15,288,098 1,951,059 12.76% UNC Greensboro 29,284,653 23,066,302 6,218,350 26.96% UNC Hospital 19,780,592 19,061,895 718,697 3.77% UNC Pembroke 7,027,746 5,235,385 1,792,362 34.24% UNC Wilmington 15,360,360 12,099,373 3,260,987 26.95% Western Carolina University 11,794,776 10,615,814 1,178,962 11.11% Winston-Salem State University 11,387,971 8,357,494 3,030,477 36.26% TOTAL UNC Systems 428,981,351 394,509,500 34,471,851 8.74% Table 3-3 Information Technology Expenditures - Current Year Versus Prior Year for Year Ended June 30, 2007 UNC System Agencies Page 15 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 16 IT Related Contracted Personal Services Table 4-1 Information Technology Related Contracted Personal Services provides a breakdown of contracted personal services by the type of system on which the contracted services were utilized. Table 4-2 Information Technology Related Contracted Personal Services- UNC System Agencies provides a breakdown of contracted personal services by the type of system on which the contracted services were utilized. Page 17 PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Comprehensive Major Medical Plan 0 40 0 0 0 0 0 0 40 Community Colleges System Office 0 70,977 0 0 0 0 12,467,271 0 12,538,248 Department of Administration 1,888 181,983 0 0 0 0 316,573 0 500,444 Department of Agriculture & Consumer Services 0 0 0 0 3,863 0 58,124 0 61,987 Department of Commerce 0 308,461 0 0 0 0 1,620,893 0 1,929,354 Department of Correction 0 0 0 0 0 0 81,121 0 81,121 Department of Crime Control & Public Safety 0 38,086 1,200 0 646,908 108,650 21,190,797 0 21,985,641 Department of Cultural Resources 315 0 0 0 0 0 228,686 0 229,001 Department of Environment & Natural Resources 0 8,146 0 0 20,000 0 2,356,190 0 2,384,336 Department of Health and Human Services 0 11,824,724 14,534 0 0 0 79,791,981 0 91,631,239 Department of Insurance 0 7,189 0 0 0 0 9,894 0 17,083 Department of Justice 0 0 0 0 0 0 572,986 0 572,986 Department of Juvenile Justice & Delinquency Prevention 0 0 0 0 0 0 120,418 0 120,418 Department of Labor 0 55,860 0 0 0 0 0 0 55,860 Department of Public Instruction 2,310 17,032 0 0 646,665 0 6,666,329 0 7,332,336 Department of Revenue 433 0 0 0 0 0 3,217,952 0 3,218,385 Department of Secretary of State 0 37,504 0 0 0 0 0 0 37,504 Department of Transportation 0 0 0 295 0 0 10,301,905 0 10,302,200 Department of the State Treasurer 0 0 0 0 0 0 1,696,110 0 1,696,110 Employment Security Commission 0 0 0 0 4,320 0 1,865,271 0 1,869,591 NC Housing Finance Authority 0 0 0 0 0 0 841,007 0 841,007 NC School Science & Math 0 0 0 0 0 0 0 0 0 NC Wildlife Resources 0 21,200 130,494 0 0 0 1,238,509 0 1,390,203 Office of Administrative Hearings 0 0 0 0 0 0 0 0 0 Office of the Governor 0 0 0 0 0 0 1,790 0 1,790 Office of the Lieutenant Governor 0 3,170 0 0 0 0 2,318 0 5,488 Office of the State Auditor 0 0 0 0 0 0 0 0 0 Office of the State Controller 0 266,175 0 0 0 0 12,072,769 0 12,338,944 State Board of Elections 0 39,800 0 0 0 0 12,753 0 52,553 TOTAL w/out UNC System, Lottery, AOC & ITS 4,946 12,880,347 146,228 295 1,321,756 108,650 156,731,647 0 171,193,869 Administrative Office of the Courts 113,261 0 0 0 0 0 2,106,450 0 2,219,711 NC Education Lottery 0 0 21,263 0 2,073 0 8,290 0 31,626 UNC System 36,465 31,459 36,020 15,422 384,640 9,772 6,481,056 0 6,994,834 Total Without ITS 154,672 12,911,806 203,511 15,717 1,708,469 118,422 165,327,443 0 180,440,040 Office of Information Technology Services 0 222,402 0 0 44,973 0 4,629,825 0 4,897,200 Table 4-1 Information Technology Related Contracted Personal Services for Year Ended June 30, 2007 Page 18 PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Appalachian State University 0 0 6,000 0 0 0 0 0 6,000 East Carolina University 879 1,559 0 375 4,267 5,220 10,460 0 22,760 Elizabeth City State University 0 0 0 0 650 7 7,500 0 8,157 Fayetteville State University 0 0 0 0 0 0 0 0 0 NC A&T State University 0 0 0 0 1,671 0 0 0 1,671 NC Central University 0 0 0 0 0 0 130,353 0 130,353 NC School of Arts 0 0 0 0 0 0 0 0 0 NC State University 17,813 6,705 16,555 3,855 44,490 0 1,599,064 0 1,688,482 UNC Asheville 0 0 0 0 7,500 0 28,640 0 36,140 UNC Chapel Hill 0 0 13,415 1,200 0 0 1,682,943 0 1,697,558 UNC Charlotte 115 0 0 8,791 0 0 283,889 0 292,795 UNC General Administration 125 10,125 0 0 0 0 169,162 0 179,412 UNC Greensboro 5,310 0 50 206 19,288 2,545 18,235 0 45,634 UNC Hospital 0 6,400 0 0 286,426 1,200 987,105 0 1,281,131 UNC Pembroke 0 0 0 0 0 0 256,988 0 256,988 UNC Wilmington 0 0 0 0 9,956 0 3,000 0 12,956 Western Carolina University 12,223 6,670 0 0 3,900 800 1,595 0 25,188 Winston-Salem State University 0 0 0 995 6,492 0 1,302,122 0 1,309,609 TOTALS 36,465 31,459 36,020 15,422 384,640 9,772 6,481,056 0 6,994,834 Table 4-2 Information Technology Related Contracted Personal Services UNC System Agencies for Year Ended June 30, 2007 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 19 Salary and Fringe Benefit Calculations Table 5-1 Salary and Calculated Fringes for All IT Positions lists by agency, the total full-time equivalents (FTEs) for permanent, full-time and part-time IT positions and the current annual budgeted salary amount for these positions as of the end of the report period. Data for these tables come from PMIS and include both vacant and filled IT positions. A position is identified as IT related based on the position's PMIS class code. Table 5-2 Salary and Calculated Fringes for All IT Positions (UNC System Agencies) lists the same information described above but for universities. UNC System agencies which operate their own payroll systems are not required to enter EPA position information into PMIS, however this data has been provided and is incorporated into this report. Fringe benefit amounts are not maintained within PMIS and are calculated in these tables based on the following criteria: • OASDI – 6.2% of budgeted salary amount capped at $97,500 per FTE • HI – 1.45% of budgeted salary amount • Retirement – 7.14% of budgeted salary amount • Hospitalization – $3,795.96 per FTE (calculated as an average of the PPO cost and the Indemnity plan cost per FTE) Other fringe benefit costs such as longevity or overtime pay cannot be readily estimated and are not included. This report assumes that salary and fringe benefits calculated in Table 5-1 and Table 5-2 are paid evenly throughout the year. Page 20 TOTAL FTE'S ANNUAL BUDGETED SALARY OASDI HI RETIRE HOSPITAL TOTAL AVERAGE PER FTE Comprehensive Major Medical Plan 2.00 121,223 7,516 1,758 8,655 7,592 146,744 73,372 Community Colleges System Office 71.00 4,407,739 272,363 63,912 314,713 269,513 5,328,240 75,046 Department of Administration 22.00 1,282,101 79,490 18,590 91,542 83,511 1,555,235 70,692 Department of Agriculture & Consumer Services 38.75 2,068,432 128,243 29,992 147,686 147,093 2,521,447 65,070 Department of Commerce 41.00 2,578,303 158,558 37,385 184,091 155,634 3,113,972 75,951 Department of Correction 131.00 7,520,161 464,436 109,042 536,940 497,271 9,127,850 69,678 Department of Crime Control & Public Safety 63.00 3,709,584 229,847 53,789 264,864 239,145 4,497,230 71,385 Department of Cultural Resources 16.75 865,385 53,654 12,548 61,789 63,582 1,056,958 63,102 Department of Environment & Natural Resources 147.00 8,211,257 507,612 119,063 586,284 558,006 9,982,223 67,906 Department of Health and Human Services 402.00 24,290,782 1,502,048 352,216 1,734,362 1,525,976 29,405,385 73,148 Department of Insurance 19.05 1,333,648 82,686 19,338 95,222 72,313 1,603,208 84,158 Department of Justice 77.00 4,536,538 280,703 65,780 323,909 292,289 5,499,219 71,418 Department of Juvenile Justice & Delinquency Prevention 29.00 1,846,943 114,510 26,781 131,872 110,083 2,230,189 76,903 Department of Labor 11.00 593,876 36,820 8,611 42,403 41,756 723,466 65,770 Department of Public Instruction 134.75 9,152,926 562,488 132,717 653,519 511,506 11,013,156 81,730 Department of Revenue 105.25 6,855,771 422,078 99,409 489,502 399,525 8,266,285 78,540 Department of Secretary of State 11.00 685,503 42,358 9,940 48,945 41,756 828,501 75,318 Department of Transportation 390.00 25,680,056 1,588,149 372,361 1,833,556 1,480,424 30,954,547 79,371 Department of the State Treasurer 45.00 3,203,476 196,921 46,450 228,728 170,818 3,846,394 85,475 Employment Security Commission 106.00 7,455,702 458,228 108,108 532,337 402,372 8,956,746 84,498 NC Housing Finance Authority 7.00 494,213 30,641 7,166 35,287 26,572 593,879 84,840 NC School Science & Math 6.00 297,053 18,417 4,307 21,210 22,776 363,763 60,627 NC Wildlife Resources 19.00 1,177,891 72,883 17,079 84,101 72,123 1,424,078 74,951 Office of Administrative Hearings 1.00 53,958 3,345 782 3,853 3,796 65,734 65,734 Office of the Governor 10.00 746,001 45,976 10,817 53,264 37,960 894,018 89,402 Office of the Lieutenant Governor 0.00 0 0 0 0 0 0 0 Office of the State Auditor 7.00 487,401 29,813 7,067 34,800 26,572 585,654 83,665 Office of the State Controller 49.00 3,566,155 219,942 51,709 254,623 186,002 4,278,432 87,315 State Board of Elections 30.00 1,609,056 99,761 23,331 114,887 113,879 1,960,914 65,364 TOTAL w/out UNC System, Lottery, AOC & ITS 1,991.55 124,831,134 7,709,490 1,810,052 8,912,943 7,559,844 150,823,464 75,732 Administrative Office of the Courts 217.75 15,320,757 940,986 222,151 1,093,902 826,570 18,404,367 84,521 NC Education Lottery 25.00 1,483,006 89,714 21,504 105,887 94,899 1,795,010 71,800 UNC System 3,017.03 168,737,661 10,413,878 2,458,280 12,104,903 11,452,525 205,167,247 68,003 Total Without ITS 5,251.33 310,372,558 19,154,069 4,511,986 22,217,635 19,933,839 376,190,087 71,637 Office of Information Technology Services 424.00 31,284,841 1,912,763 453,630 2,233,738 1,609,487 37,494,460 88,430 Table 5-1 Salary and Calculated Fringes for All IT Positions Annual Budgeted Salary as reported June 30, 2007 TOTAL FTE'S ANNUAL BUDGETED SALARY OASDI HI RETIRE HOSPITAL TOTAL AVERAGE PER FTE Appalachian State University 128.00 6,505,207 401,428 94,326 464,472 485,883 7,951,315 62,120 East Carolina University 303.00 15,661,247 970,494 228,359 1,124,472 1,150,176 19,134,749 63,151 Elizabeth City State University 30.00 1,426,516 88,444 20,685 101,853 113,879 1,751,377 58,379 Fayetteville State University 40.50 1,811,224 111,862 26,263 129,321 153,736 2,232,406 55,121 NC A&T State University 76.00 3,725,114 229,218 54,014 265,973 288,493 4,562,812 60,037 NC Central University 59.00 3,066,391 188,101 44,463 218,940 223,962 3,741,857 63,421 NC School of Arts 14.00 732,538 45,417 10,622 52,303 53,143 894,024 63,859 NC State University 482.97 29,808,946 1,840,879 433,018 2,132,239 1,833,335 36,048,417 74,639 UNC Asheville 35.65 1,686,701 104,403 24,457 120,430 135,326 2,071,318 58,101 UNC Chapel Hill 1,004.20 59,695,859 3,701,874 874,524 4,306,275 3,811,903 72,390,434 72,088 UNC Charlotte 181.80 10,625,069 651,667 154,296 759,772 690,106 12,880,910 70,852 UNC General Administration 57.00 3,530,809 209,888 51,197 252,100 216,370 4,260,363 74,743 UNC Greensboro 181.42 9,822,739 599,644 142,788 703,105 688,663 11,956,939 65,908 UNC Hospital 138.00 6,553,440 406,313 95,025 467,916 523,842 8,046,536 58,308 UNC Pembroke 43.00 1,891,833 117,294 27,432 135,077 163,226 2,334,861 54,299 UNC Wilmington 114.50 5,885,494 359,729 85,340 420,224 434,637 7,185,424 62,755 Western Carolina University 82.00 3,856,554 236,781 55,920 275,358 311,269 4,735,882 57,755 Winston-Salem State University 45.99 2,451,980 150,441 35,554 175,071 174,576 2,987,622 64,962 TOTAL 3,017.03 168,737,661 10,413,878 2,458,280 12,104,903 11,452,525 205,167,247 68,003 Note: Total FTE's includes EPA position data provided by UNC General Administration Table 5-2 Salary and Calculated Fringes for All IT Positions Annual Budgeted Salary - UNC System Agencies as reported June 30, 2007 Page 21 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 22 Salary Cost by Position Status Table 5-3 Total IT Salary and Fringe Amount by Position Status segregates the current annual budgeted salary and fringes amount by position status within an agency. The position status determines whether a position is filled or vacant at the end of the report period (June 30, 2007.) With approval, lapsed salary generated by a vacant position can be re-budgeted to another category. Table 5-4 Total IT Salary and Fringe Amount by Position Status (UNC System agencies) lists this same information by university. Salary Cost by Position Type Table 5-5 Salary and Calculated Fringes by Banding Category for all IT Positions lists salary information by IT band. The information in this table reflects the transition of position from salary grades to IT salary bands for those agencies required to transition to IT salary bands. Summarized data for salaries not transitioned to IT bands is included for comparison purposes with other tables (Administrative Office of the Courts, North Carolina Education Lottery and UNC System). FILLED POSITIONS VACANT POSITIONS TOTAL POSITIONS % VACANT OF TOTAL Comprehensive Major Medical Plan 146,744 0 146,744 0.00% Community Colleges System Office 4,595,542 732,699 5,328,240 13.75% Department of Administration 1,330,938 224,297 1,555,235 14.42% Department of Agriculture & Consumer Services 2,275,832 245,614 2,521,447 9.74% Department of Commerce 2,863,789 250,183 3,113,972 8.03% Department of Correction 8,292,589 835,261 9,127,850 9.15% Department of Crime Control & Public Safety 4,120,876 376,354 4,497,230 8.37% Department of Cultural Resources 1,003,532 53,425 1,056,958 5.05% Department of Environment & Natural Resources 8,472,043 1,510,180 9,982,223 15.13% Department of Health and Human Services 25,391,941 4,013,444 29,405,385 13.65% Department of Insurance 1,444,072 159,136 1,603,208 9.93% Department of Justice 4,857,567 641,652 5,499,219 11.67% Department of Juvenile Justice & Delinquency Prevention 2,128,161 102,028 2,230,189 4.57% Department of Labor 723,466 0 723,466 0.00% Department of Public Instruction 10,154,802 858,354 11,013,156 7.79% Department of Revenue 7,152,520 1,113,765 8,266,285 13.47% Department of Secretary of State 828,501 0 828,501 0.00% Department of Transportation 23,304,060 7,650,487 30,954,547 24.72% Department of the State Treasurer 3,721,816 124,578 3,846,394 3.24% Employment Security Commission 8,291,021 665,726 8,956,746 7.43% NC Housing Finance Authority 514,643 79,236 593,879 13.34% NC School Science & Math 280,505 83,258 363,763 22.89% NC Wildlife Resources 1,424,078 0 1,424,078 0.00% Office of Administrative Hearings 65,734 0 65,734 0.00% Office of the Governor 757,867 136,151 894,018 15.23% Office of the Lieutenant Governor 0 0 0 N/A Office of the State Auditor 585,654 0 585,654 0.00% Office of the State Controller 4,181,656 96,776 4,278,432 2.26% State Board of Elections 1,960,914 0 1,960,914 0.00% TOTAL w/out UNC System, Lottery, AOC & ITS 130,870,862 19,952,602 150,823,464 13.23% Administrative Office of the Courts 16,879,670 1,524,697 18,404,367 8.28% NC Education Lottery 1,590,775 204,235 1,795,010 11.38% UNC System 181,208,602 23,958,645 205,167,247 11.68% Total Without ITS 330,549,908 45,640,179 376,190,087 12.13% Office of Information Technology Services 33,346,085 4,148,375 37,494,460 11.06% Table 5-3 Total IT Salary and Fringe Amount By Position Status Annual Budgeted Amounts as reported June 30, 2007 Page 23 FILLED POSITIONS VACANT POSITIONS TOTAL POSITIONS % VACANT OF TOTAL Appalachian State University 7,129,174 822,141 7,951,315 10.34% East Carolina University 16,728,553 2,406,196 19,134,749 12.58% Elizabeth City State University 1,466,538 284,838 1,751,377 16.26% Fayetteville State University 1,612,337 620,069 2,232,406 27.78% NC A&T State University 4,302,360 260,452 4,562,812 5.71% NC Central University 3,317,783 424,074 3,741,857 11.33% NC School of Arts 798,201 95,823 894,024 10.72% NC State University 33,332,917 2,715,500 36,048,417 7.53% UNC Asheville 1,818,166 253,151 2,071,318 12.22% UNC Chapel Hill 62,222,557 10,167,878 72,390,434 14.05% UNC Charlotte 12,003,461 877,449 12,880,910 6.81% UNC General Administration 3,309,251 951,112 4,260,363 22.32% UNC Greensboro 11,626,061 330,878 11,956,939 2.77% UNC Hospital 6,385,008 1,661,529 8,046,536 20.65% UNC Pembroke 2,003,529 331,332 2,334,861 14.19% UNC Wilmington 6,878,829 306,595 7,185,424 4.27% Western Carolina University 4,299,499 436,384 4,735,882 9.21% Winston-Salem State University 1,974,377 1,013,245 2,987,622 33.91% Total: 181,208,602 23,958,645 205,167,247 11.68% Table 5-4 Total IT Salary and Fringe Amount By Position Status UNC System Agencies Annual Budgeted Amounts as reported June 30, 2007 Page 24 FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes Comprehensive Major Medical Plan 1.00 101,367 0.00 0 0.00 0 0.00 0 1.00 45,376 Community Colleges System Office 10.00 1,011,951 9.00 671,705 1.00 82,852 38.00 2,787,343 13.00 774,390 Department of Administration 3.00 307,740 0.00 0 0.00 0 10.00 798,710 9.00 448,785 Department of Agriculture & Consumer Services 1.00 121,419 1.00 55,068 1.00 92,096 23.75 1,595,854 12.00 657,009 Department of Commerce 4.00 434,646 1.00 82,165 2.00 182,856 24.00 1,859,198 10.00 555,107 Department of Correction 14.00 1,491,655 4.00 261,240 29.00 1,973,889 33.00 2,918,957 51.00 2,482,109 Department of Crime Control & Public Safety 4.00 431,611 1.00 94,773 20.00 1,340,925 17.00 1,356,363 21.00 1,273,559 Department of Cultural Resources 1.00 94,557 0.00 0 2.00 152,312 5.00 329,226 8.75 480,862 Department of Environment & Natural Resources 11.00 1,140,316 1.00 77,359 1.00 85,880 65.00 4,700,364 69.00 3,978,303 Department of Health and Human Services 57.00 5,543,631 35.00 1,814,814 35.00 2,391,078 186.00 14,705,894 89.00 4,949,967 Department of Insurance 1.00 108,012 0.00 0 3.00 227,112 10.00 914,576 5.05 353,508 Department of Justice 14.00 1,448,128 9.00 745,688 6.00 370,625 24.00 1,694,406 24.00 1,240,371 Department of Juvenile Justice & Delinquency Prevention 4.00 423,455 3.00 259,954 2.00 163,026 7.00 512,942 13.00 870,812 Department of Labor 2.00 174,521 0.00 0 0.00 0 3.00 235,073 6.00 313,872 Department of Public Instruction 16.00 1,733,391 6.00 435,756 10.00 817,672 64.00 5,538,343 38.75 2,487,994 Department of Revenue 19.00 1,953,889 19.00 1,335,811 7.00 577,499 43.25 3,489,409 17.00 909,677 Department of Secretary of State 3.00 302,908 0.00 0 0.00 0 4.00 316,483 4.00 209,109 Department of Transportation 57.00 5,842,376 36.00 2,550,732 6.00 511,236 199.00 16,435,167 92.00 5,615,036 Department of the State Treasurer 3.00 376,825 7.00 428,659 2.00 206,468 21.00 2,022,438 12.00 812,003 Employment Security Commission 15.00 1,714,483 31.00 2,348,289 6.00 469,378 43.00 3,755,115 11.00 669,481 NC Housing Finance Authority 4.00 337,373 0.00 0 0.00 0 3.00 256,506 0.00 0 NC School Science & Math 1.00 95,797 1.00 75,691 0.00 0 0.00 0 4.00 192,275 NC Wildlife Resources 1.00 118,285 0.00 0 5.00 378,642 7.00 601,573 6.00 325,577 Office of Administrative Hearings 0.00 0 0.00 0 1.00 65,734 0.00 0 0.00 0 Office of the Governor 1.00 120,550 0.00 0 0.00 0 9.00 773,469 0.00 0 Office of the Lieutenant Governor 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 Office of the State Auditor 1.00 122,822 0.00 0 1.00 89,166 3.00 243,376 2.00 130,289 Office of the State Controller 10.00 1,113,371 4.00 263,036 2.00 154,404 28.00 2,423,175 5.00 324,446 State Board of Elections 3.00 302,650 1.00 94,624 0.00 0 10.00 690,432 16.00 873,209 TOTAL w/out UNC System, Lottery, AOC & ITS 261.00 26,967,729 169.00 11,595,364 142.00 10,332,848 880.00 70,954,394 539.55 30,973,128 Administrative Office of the Courts NC Education Lottery UNC System 170.01 15,772,772 449.97 32,235,814 228.50 15,901,089 801.54 59,387,190 1,089.50 59,458,494 Total Without ITS 431.01 42,740,501 618.97 43,831,179 370.50 26,233,938 1,681.54 130,341,584 1,629.05 90,431,621 Office of Information Technology Services 57.00 6,583,958 98.00 8,071,340 155.00 12,170,310 103.00 10,014,317 11.00 654,536 Non-banded positions included in Table 5-1: AOC 18,404,367 Univ 22,411,888 Lottery 1,795,010 NOTE: Non-banded positions for agencies not including AOC and Universities were classified according to similar banding positions based on the OSP crosswalk. Table 5-5 Salary and Calculated Fringes by Banding Category for All IT Positions Annual Budgeted Amounts as reported June 30, 2007 Information Technology Operations and Systems Networking Business and Technology Applications Technical Support Page 25 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 26 FTE Comparison between IT positions and All Positions Table 5-6 Information Technology FTEs versus All FTEs compares the FTE count for all IT positions to total FTEs by agency. The FTE count for IT positions is further divided by position status (filled or vacant) as of June 30, 2007. The agencies are grouped by legislative committee for this table. The North Carolina Education Lottery is also included for informational purposes. Page 27 Filled Information Technology Positions Vacant Information Technology Positions Total Information Technology Positions Total All Positions % IT of Total Education Community Colleges System Office 61.00 10.00 71.00 219.50 32.35% Department of Public Instruction 123.75 11.00 134.75 694.78 19.39% NC School Science & Math 4.00 2.00 6.00 110.00 5.45% UNC System 2,628.55 388.48 3,017.03 29,975.20 10.07% Education Total: 2,817.30 411.48 3,228.78 30,999.48 10.42% General Government Department of Administration 18.00 4.00 22.00 1,004.96 2.19% Department of Cultural Resources 15.75 1.00 16.75 815.48 2.05% Department of Insurance 17.00 2.05 19.05 413.04 4.61% Department of Revenue 92.25 13.00 105.25 1,548.25 6.80% Department of Secretary of State 11.00 0.00 11.00 187.00 5.88% Department of the State Treasurer 43.00 2.00 45.00 365.99 12.30% NC Housing Finance Authority 6.00 1.00 7.00 116.00 6.03% Office of Administrative Hearings 1.00 0.00 1.00 45.00 2.22% Office of the Governor 8.00 2.00 10.00 136.99 7.30% Office of the State Auditor 7.00 0.00 7.00 195.00 3.59% Office of the State Controller 48.00 1.00 49.00 135.75 36.10% State Board of Elections 30.00 0.00 30.00 59.00 50.85% General Government Total: 297.00 26.05 323.05 5,022.46 6.43% Human Resources Department of Health and Human Services 349.00 53.00 402.00 19,389.35 2.07% Human Resources Total: 349.00 53.00 402.00 19,389.35 2.07% Justice and Public Safety Administrative Office of the Courts 199.75 18.00 217.75 6,300.21 3.46% Department of Correction 118.00 13.00 131.00 21,055.50 0.62% Department of Crime Control & Public Safety 57.00 6.00 63.00 2,853.75 2.21% Department of Justice 67.00 10.00 77.00 1,341.14 5.74% Department of Juvenile Justice & Delinquency Prevention 28.00 1.00 29.00 1,988.75 1.46% Justice and Public Safety Total: 469.75 48.00 517.75 33,539.35 1.54% Natural and Economic Resources Department of Agriculture & Consumer Services 34.75 4.00 38.75 1,391.00 2.79% Department of Commerce 38.00 3.00 41.00 838.43 4.89% Department of Environment & Natural Resources 123.00 24.00 147.00 3,962.68 3.71% Department of Labor 11.00 0.00 11.00 429.75 2.56% Employment Security Commission 97.00 9.00 106.00 2,078.00 5.10% NC Wildlife Resources 19.00 0.00 19.00 649.50 2.93% Natural and Economic Resources Total: 322.75 40.00 362.75 9,349.36 3.88% Salaries and Benefits Retirement Comprehensive Major Medical Plan 2.00 0.00 2.00 36.50 5.48% Salaries Benefits Retirement Total: 2.00 0.00 2.00 36.50 5.48% Transportation Department of Transportation 292.00 98.00 390.00 14,683.00 2.66% Transportation Total: 292.00 98.00 390.00 14,683.00 2.66% NC Education Lottery NC Education Lottery 22.00 3.00 25.00 232.00 10.78% NC Education Lottery Total: 22.00 3.00 25.00 232.00 10.78% Office of Information Technology Services Office of Information Technology Services 376.00 48.00 424.00 509.00 83.30% Office of Information Technology Services Total: 376.00 48.00 424.00 509.00 83.30% Total: 4,947.80 727.53 5,675.33 113,760.50 4.99% Table 5-6 Information Technology FTEs versus All FTEs As Reported June 30, 2007 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 28 Portfolio Management For many years the State of North Carolina grappled with the question “How much does the state spend on information technology each year?” The General Assembly mandated that this joint report be prepared to begin answering this question. In 2004, the General Assembly directed the State Chief Information Officer (SCIO) to begin improving the management of information technology in state government. To do this, Information Technology Services (ITS) purchased new tools and began several new services. In accordance with the statutory authority of the SCIO and ITS, this section focuses only on the Executive Branch. No figures are given for the university system, the North Carolina Education Lottery, the Administrative Office of the Courts or the General Assembly. This section focuses on the concepts of Portfolio Management (PM). PM is the grouping of computer applications and projects to examine how an organization is spending its funds, its risk profile, and its future plans for technology. Just as one manages a personal retirement fund or budget by putting some dollars in short term investments, some in long term high risk investments, some in long term low risk investments and some in readily available funds, the state should manage its technology portfolio for the future. The state’s technology profile is composed of several key elements: people, hardware and software, projects and its existing applications. Other sections of this report give information on the costs of personnel and hardware and software. Project Portfolio Management focuses on new technology projects intended to improve the service delivery of existing services or to provide new services. Projects have a definite timeline, a budget, and a set of deliverables. When they are finished, the state should have a new service or improved infrastructure to build on for the future. Application Portfolio Management focuses on the state’s existing software applications, everything from food stamps to victim services to drivers’ licenses and boat registration. It looks at the age of the application, the technical health of the application, and the ability of the application to continue to meet business needs. Each application should have planned for the future—should the state continue to maintain it, should it be modified to use newer technology, or should it be replaced since it no longer meets the agency’s business needs? Last year was the first year that information for the IT Expenditures Report was taken from the Portfolio Management tool. It should be reiterated that while the cost categories were developed with the assistance and approval of the Office of the State Controller and the Office of State Budget and Management, the numbers reported below are based on self-reports from the agencies. The costs have not been audited, nor were they directly transferred to the PM system from the NCAS. Overall, approximately 67.42% of the costs shown in Table 1.1 (minus the AOC, University system, NC Education Lottery and Information Technology Services) are represented in the following tables. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 29 Projects The Enterprise Project Management Office monitored over 100 projects during FY 2007. As stated above, projects are new efforts with budgets, timelines and milestones. (Tracking and monitoring of projects less than $500,000 is not required, although if projects under $500,000 reported costs in the PM Tool, they are included in this report.) In FY 2006-07, approximately $156M was spent by state agencies, including ITS, on projects. Three state agencies spent a large proportion of those funds: OSC for the Beacon project, Crime Control and Public Safety for the VIPER project, and Health and Human Services for several key projects. The pie chart below shows the sources of funds for projects, excluding ITS: approximately 59% came from state funds and 33% came from federal. FY2007 Project Costs by Source of Funds Federal Funds; $41,737,819; 33% Local Funds; $1,012,030; 1% Non Federal Grants; $247,650; 0% Receipts User Fees; $9,362,216; 7% State Appropriations; $74,431,713; 59% The second pie chart shows the distribution of project funds statewide at a detailed cost level. The most significant observation that can be made from this chart is that approximately 34% of the project dollars were spent on external personnel costs. Only 12% of project costs were attributed to state internal personnel costs. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 30 FY2007 Project Costs by Detailed Cost Category Internal Personnel Costs $14,113,780 12% External Personnel Costs $39,735,678 34% Other External Costs $12,664,756 11% Hardware Costs $38,427,625 32% Software Costs $4,832,958 4% Other Costs $8,572,226 7% Table 6-1 shows the distribution of costs for projects by agency for 2007 by detailed cost category. Table 6-2 shows the distribution of costs for projects by agency for 2007 by source of funds. Applications State agencies, including ITS, have identified approximately 1,300 applications (including retired applications). As defined above, applications are on-going activities that support key business processes in state government, everything from the issuance of food stamps to vehicle registration and employee payroll. The state does not count commercially available software such as MS Word or Excel in its listing of applications. The focus is on specialized, often custom-developed applications serving many employees and enabling them to deliver services to citizens of North Carolina. Note: In February 2007, the SCIO prepared a report on the state’s legacy applications. That report provides additional details on the current condition of the state’s application portfolio. It can be found at http://www.scio.nc.gov under the “Management of Legacy Applications Report.” The pie chart below provides details of the source of funds for maintaining the state’s existing applications, exclusive of ITS. As the chart depicts, the ratio of state to federal funds increases compared to projects, with the state providing a higher percent (68%) of funding than federal (27%). State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 31 FY2007 Application Costs Source of Funds Federal Funds; $65,606,015; 27% Local Funds; $534,630; 0% Non Federal Grants; $604,127; 0% Receipts User Fees; $11,725,414; 5% State Appropriations; $161,245,107; 68% The second pie chart gives details on the distribution of costs in categories. The key finding from this chart is that internal state and external personnel percentages change significantly from the project percentages: 22% of the cost of maintaining applications comes from internal personnel. The use of external contractors for maintenance declines to only 18%. FY2007 Application Costs by Detailed Cost Category Internal Personnel Costs $53,279,503 22% External Personnel Costs $42,203,376 18% Other External Costs $93,862,947 39% Hardware Costs $21,793,108 9% Software Costs $15,984,914 7% Other Costs $12,591,454 5% State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 32 Table 6-3 provides additional information on state government application costs by agencies for 2007 by detailed cost category. Table 6-4 provides additional information on state government application costs by agencies for 2007 by source of funds. Key differences between FY2006 and FY2007 include: • The number of projects reporting costs, including ITS, increased from 75 in 2006 to 118 in 2007. Total project costs grew from $132M in 2006 to $156M in 2007. • The number of applications reporting costs, including ITS, went from 1,169 in 2006 to 1131 in 2007. However, this includes 53 FY2006 applications that were consolidated into 6 applications for reporting purposes in the Portfolio Management tool in FY2007 and the removal of 11 other 2006 applications incorrectly added to the tool in 2006. Total applications costs grew from $232M in 2006 to $250M in 2007. • Several commissions and offices report on their projects and applications separately in the Portfolio Management tool, but are combined in the other sections of this IT Expenditures report. For consistency, this year we have reported those costs in the same agency as used in other sections of this report. This includes: o Alcoholic Beverage Control Commission – included in Department of Commerce o Industrial Commission - Workers' Compensation - included in the Department of Commerce o Office of State Budget and Management - included in the Office of the Governor o Office of State Personnel - included in the Department of Administration. • Finally, this is the first year that we are reporting the source of funds for projects and applications (in Tables 6-2 and 6-4 respectively). Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Community Colleges System Office Administrative Information Systems 271,966 6,118,605 114,611 0 0 69,340 0 6,574,522 CIS Release 18 Infrastructure Migration 412,060 3,283,635 0 0 0 0 0 3,695,695 Improve Student Access to Services and 0 0 0 0 0 9,100 Optimize Registration Resources 0 9,100 Learning Object Repository Infrastructure 46,620 0 0 0 0 34,325 Project 0 80,945 Total Costs for Community Colleges System Office 730,646 9,402,240 114,611 0 0 112,765 0 10,360,262 Department of Administration Motor Fleet Management System (MFMS) 268,929 0 0 396 0 0 Project 41,487 310,812 NC FLEX Web-Based Enrollment System 21,988 0 0 0 456,719 0 Project 0 478,707 NC Works - Phase I 23,265 32,450 0 0 0 0 0 55,715 Total Costs for Department of Administration 314,182 32,450 0 396 456,719 0 41,487 845,234 Department of Commerce Application Development & Support 2,717 0 0 0 0 0 Services 0 2,717 CMS - Content Management System 160,963 361,571 0 13,254 43,253 0 0 579,041 Page 33 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Commerce Economic Development Intelligence 38,520 180,024 150 0 0 0 System Project 0 218,694 Industrial Commission Electronic 71,232 484,674 0 1,200 0 0 Document Management System (EDMS) Migration and Replacement Project 0 557,106 Terminal Operating System 6,300 0 0 0 0 0 0 6,300 Total Costs for Department of Commerce 279,732 1,026,269 150 14,454 43,253 0 0 1,363,858 Department of Correction DOC Sex Offender GPS 203,307 19,600 0 0 0 0 0 222,907 Total Costs for Department of Correction 203,307 19,600 0 0 0 0 0 222,907 Department of Crime Control and Public Safety Flood Inundation Mapping and Alert 19,958 41,283 0 0 0 0 Network (FIMAN) - (West) 0 61,241 Viper Strategic Solution Implementation 362,470 0 0 6,606,163 0 0 Project - Phase 0 0 6,968,633 VIPER Strategic Solution Implementation 224,697 227,200 0 23,637,000 0 0 Project - Phase 1 0 24,088,897 Total Costs for Department of Crime Control and Public Safety 607,125 268,483 0 30,243,163 0 0 0 31,118,771 Department of Environment and Natural Resources Central Reservation System 35,622 0 0 0 0 0 0 35,622 Page 34 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Environment and Natural Resources EEP Information Management System 58,132 1,067,620 0 0 0 0 0 1,125,752 Point of Sale System Replacement 196 5,200 0 0 0 0 0 5,396 Total Costs for Department of Environment and Natural 93,950 1,072,820 0 0 0 0 1,166,770 Resources 0 Department of Health and Human Services Central Region Psychiatric Hospital 29,714 188,998 936,325 1,433 0 21,664 Automation Program (CHAPS) Infrastructure Project 570,918 1,749,052 Client Services Data Warehouse Business 15,807 181,307 0 20,784 41,698 356,535 Objects XI Migration 0 616,131 Client Services Data Warehouse Hardware 0 1,502 0 0 0 0 Migration Project 0 1,502 Crossroads State Agency Model Project 100,330 140,633 0 0 0 0 (SAM) 0 240,963 DHHS Security Project 283,124 181,595 67,007 566 89 80,086 262,960 875,427 DHHS Disability Determination Services 6,249 47,114 0 134,350 26,764 0 Section - Telephony Upgrade 0 214,477 DHHS HIPAA National Provider 305,059 5,207,689 0 0 0 71,629 Identifier (NPI) Initiative 0 5,584,377 Division of Medical Assistance - Home 7,735 0 0 0 0 600 and Community Based Services Reforms Project 0 8,335 Division of Medical Assistance - Uniform 5,007 1,036,000 0 0 0 792 Screening Program 0 1,041,799 Page 35 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Health and Human Services 730,884 Health Information System 776,568 692,166 32,525 430,078 2,754,333 0 5,416,554 LIMS - Laboratory Information 0 307,389 369,155 251,922 72,377 0 Management System 0 1,000,843 Martin County Call Center Upgrade 28,018 3,042 0 0 0 10,298 0 41,358 NC Electronic Disease Surveillance 206,667 107,500 1,076,203 0 175,008 0 System (NC EDSS) 0 1,565,378 NC FAST Automated Interview (AI) 250,138 101,463 3,248 964 477 261,049 Integrator Selection Project 39,441 656,780 NC FAST Automated Interview Software 45,982 54,107 813 0 644 27,053 Selection 0 128,599 NC FAST Legacy Systems Analyses 318,970 39,213 0 0 0 97,053 Project 0 455,236 NC FAST Program Definition Project 16,026 968 1,468 0 0 0 119,187 137,649 NC FAST Service Delivery Interface 0 0 0 0 0 0 (SDI) Project 158,046 158,046 NC Information and Referral 0 26,964 142,562 0 0 12,282 88,400 270,208 NCMMIS Initiative 0 0 0 0 0 0 3,253,681 3,253,681 NCMMIS+ Program - Artifacts Review 486,581 141,570 3,305 14,001 6,095 28,144 and Update Project 0 679,696 Page 36 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Health and Human Services NCMMIS+ Program - Business Rules and 466,568 174,126 4,010 14,741 7,262 22,732 Analysis Project 0 689,439 NCMMIS+ Program – DHSR Business 344,501 118,552 0 12,843 6,326 17,653 Process Automation Project 0 499,875 NCMMIS+ Program Planning Project 637,223 283,562 0 15,194 7,483 21,169 0 964,631 NCMMIS+ Program–Medicaid 58,621 20,757 0 476 234 3,519 Accounting System (MAS) & Accounts Receivable / Payable Business Process 0 83,607 NCMMIS+ Replacement Strategy Project 263,845 28,316 0 9,640 4,748 12,846 for Provider Type and Provider Specialty 0 319,395 Vital Records and Statistics Automation 38,460 174,263 1,057 0 0 9,298 System 185,774 408,852 Total Costs for Department of Health and Human Services 4,645,509 9,343,198 3,297,319 509,439 779,283 3,808,735 4,678,407 27,061,890 Department of Justice Disaster Recovery (BCP/DR) 93,752 159,340 71,040 0 0 0 Implementation 0 324,132 Learning Management System Project 191,692 0 0 0 0 0 (formerly Training & Standards Learning Management ...) 0 191,692 SSN Replacement & Database Conversion 111,520 163,704 0 0 0 0 Project (formerly Training & Standards Conversion ...) 0 275,224 Statewide Automated Fingerprint 306,666 39,096 1,020,612 0 0 3,601 Identification System (SAFIS) Replacement Project 0 1,369,975 Total Costs for Department of Justice 703,630 362,140 1,091,652 0 0 3,601 0 2,161,023 Page 37 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Public Instruction CECAS 2007 Hosting 2,354 0 0 0 0 0 0 2,354 Child Nutrition Claims (CNC) 73,617 158,750 60,500 0 42,370 0 0 335,237 Child Nutrition Direct Certification and 16,993 0 0 0 0 0 Verification 0 16,993 Comprehensive Exceptional Children 372,767 480,361 0 39,645 0 0 Accountability System (CECAS) Initiative 179,585 1,072,358 DPI LAN Hardware and Wiring Upgrade 10,837 0 0 0 0 0 0 10,837 eSIS 9.1 Upgrade 107,525 68,396 0 0 0 0 0 175,921 K-Nect 16,186 219,500 10,150 16,000 2,000 0 0 263,836 NC WISE - Enhancements 11,560 0 0 0 0 0 0 11,560 NC WISE Wave 3 Deployment 32,470 0 0 0 0 0 106,845 139,315 NCWISE Reporting 135,500 1,671,948 24,067 0 0 0 0 1,831,515 NCWISE Wave 2 Deployment 520,735 655,076 0 0 0 0 1,620,199 2,796,010 Online Educational Services for Student 13,496 0 0 0 0 209,000 Achievement Improvement 0 222,496 Page 38 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Total Costs for Department of Public Instruction 1,314,040 3,254,031 94,717 55,645 44,370 209,000 1,906,629 6,878,432 Department of Revenue Motor Fuels Tracking System 2,051 8,422 0 0 0 0 1,151,966 1,162,439 Online Filing and Payments Services 72,001 259,645 0 0 0 0 495,597 827,243 Total Costs for Department of Revenue 74,052 268,067 0 0 0 0 1,647,563 1,989,682 Department of the StateTreasurer Integrated Document Managemt System - 100,415 164,775 0 96,947 168,193 0 Unclaimed Property Program (IDMS-UPP) 0 530,330 Integrated Retirement System Planning 634,370 884,440 3,893,129 0 0 0 0 5,411,939 Total Costs for Department of the StateTreasurer 734,785 1,049,215 3,893,129 96,947 168,193 0 0 5,942,269 Department of Transportation 511 Traveler Information System Phase II 6,000 0 367,000 123,000 0 0 0 496,000 Automated Testing System 5,795 9,209 0 369,200 426,700 0 0 810,904 Customer Traffic Management System 744 4,640 204,278 0 0 0 0 209,662 Customer Traffic Management Systems 0 1,280 435,747 0 0 0 Phase II 0 437,027 Page 39 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Transportation Database Cleansing of Legacy Photo 200 10,960 395,000 0 0 0 Images 0 406,160 DMV Call Center Relocation 10,967 11,145 2,140 20,310 0 0 0 44,562 DMV License Plate Recall 95,792 12,360 0 0 0 0 0 108,152 Enterprise Web Portal and Executive 30,756 168,532 0 566,000 0 0 Dashboard 0 765,288 ERP 2005 Upgrade 8,638 17,825 0 0 0 0 0 26,463 Facility Management Systems 121,546 234,711 0 0 0 0 0 356,257 Fleet Documentation 22,856 53,327 0 0 0 0 0 76,183 Grants in Contract Management (DBE) 3,548 10,460 0 0 0 0 119,738 133,746 Greenfield Center Infrastructure 33,949 19,468 0 286,166 0 0 0 339,583 HiCAMS Architecture Study 300 0 157,000 0 0 0 0 157,300 IputAccel Upgrade R5.2 24,011 3,788 300,806 0 0 0 0 328,605 IRP/MC & LITES Upgrades and Migration 24,632 1,000 0 0 0 0 960 26,592 Page 40 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Transportation Maintenance Management System (MMS) 1,470 603 12,084 4,749 547 -49,038 Handheld Systems 47,067 17,482 NCSmartlink 7,924 0 14,858 0 0 0 2,434 25,216 Notice, Storage and Theft System 9,829 0 0 0 0 0 120 9,949 Pavement Management System Project 122,621 109,000 1,553,600 0 0 0 Phase 2 (Implementation) 0 1,785,221 PreQualification Automation 140,253 197,709 0 0 0 0 0 337,962 SDLC and Requirements Management 21,786 34,723 0 0 0 0 0 56,509 Total Costs for Department of Transportation 693,617 900,740 3,442,513 1,369,425 427,247 -49,038 170,319 6,954,823 Employment Security Commission Initial Claims Call Center 488,715 265,433 0 10,203 4,660 4,162 0 773,173 UI Fraud & Identify Theft 35,734 0 0 0 0 0 0 35,734 VoIP Telephony Solution for ESC 85,870 5,100 6,119 12,349 0 0 Unemployment Insurance Division, Central Office Complex 0 109,438 Total Costs for Employment Security Commission 610,319 270,533 6,119 22,552 4,660 4,162 0 918,345 Page 41 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs NC Wildlife Resources Coastal Recreational Fishing License 95,215 316,380 0 0 78,690 0 Implementation 0 490,285 Phase 4 Online Licensing and Vessel 18,000 0 0 0 0 0 Registration Project 0 18,000 Total Costs for NC Wildlife Resources 113,215 316,380 0 0 78,690 0 0 508,285 Office of the State Auditor Non-Governmental Organization Grant 61,971 128,217 0 0 0 0 Compliance - Business Intelligence & Data Warehouse 0 190,188 Total Costs for Office of the State Auditor 61,971 128,217 0 0 0 0 0 190,188 Office of the State Controller BEACON-HR/PAYROLL 2,917,450 12,021,295 724,546 904,012 2,830,543 4,483,001 0 23,880,847 Total Costs for Office of the State Controller 2,917,450 12,021,295 724,546 904,012 2,830,543 4,483,001 0 23,880,847 State Board of Elections ERAPP (e-Pollbooks) 11,500 0 0 0 0 0 0 11,500 Voter Registration Server Upgrade 2,000 0 0 0 0 0 0 2,000 Voting Equipment Upgrade HAVA ( Help 0 0 0 5,211,592 0 0 America Vote Act ) 0 5,211,592 WBET - WEB Based Elections Tools 2,750 0 0 0 0 0 0 2,750 Page 42 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Total Costs for State Board of Elections 16,250 0 0 5,211,592 0 0 0 5,227,842 Total Costs for Non-ITS 14,113,780 39,735,678 12,664,756 38,427,625 4,832,958 8,572,226 8,444,405 126,791,428 Office of Information Technology Services Electronic Document Management Service 152,210 38,999 0 24,723 0 0 12,950 228,882 Enterprise Service Access Point (ESAP) 731,515 0 0 382,171 0 0 0 1,113,686 Intrusion Prevention System (IPS) for 13,480 0 0 0 0 0 State Infrastructure 0 13,480 IT Asset Management (ITAM) Project 141,109 164,117 0 0 371,200 9,743 Phase 1 0 686,169 IT Consolidation Phase II - Industrial 312,383 145,850 0 0 0 322 Commission 0 458,555 IT Consolidation Pilot Project 175,023 22,698 0 397,012 0 0 0 594,733 ITS On Boarding to Electronic Document 75,725 0 0 0 0 0 Management Service 0 75,725 ITS SQA Shared Service 71,195 17,480 0 0 647,220 0 0 735,895 Managed Platform - Server Virtualization 145,139 0 0 732,600 83,374 26,578 0 987,691 Page 43 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Office of Information Technology Services OEP Culminating Phases 608,699 425,267 63,915 0 0 0 0 1,097,881 Operational Excellence Program Phase I 467,804 263,529 13,500 0 0 0 0 744,833 Phase 1 ITS Data Warehouse Shared 100,856 0 0 0 0 0 Service 56,434 157,290 Polycom MGC-100 Video MCU 0 0 0 0 0 0 Procurement 900 900 Remedy Service Desk Implementation 55,256 64,000 0 0 250,754 8,310 0 378,320 SDC - Capacity Back Up Mainframe 8,000 0 0 0 0 0 0 8,000 Security Information and Event 44,800 0 0 324,800 0 0 Management (SIEM) Procurement & Implementation 0 369,600 Statewide Secondary Data Center 183,472 0 14,406,513 0 0 1,777,420 0 16,367,405 Upgrade of Disk Storage Infrastructure 32,470 211,000 0 1,734,897 491,093 0 0 2,469,460 Z9 Mainframe Upgrade 19,031 0 0 3,070,915 0 0 0 3,089,946 Total Costs for Office of Information Technology Services 3,338,167 1,352,940 14,483,928 6,667,118 1,843,641 1,822,373 70,284 29,578,451 Total Costs for ITS 3,338,167 1,352,940 14,483,928 6,667,118 1,843,641 1,822,373 70,284 29,578,451 Page 44 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Community Colleges System Office Administrative Information Systems 0 26,361 0 0 6,548,161 6,574,522 Community Colleges System Office CIS Release 18 Infrastructure Migration 0 0 0 0 3,695,695 3,695,695 Community Colleges System Office Improve Student Access to Services and Optimize Registration Resources 0 0 0 0 9,100 9,100 Community Colleges System Office Learning Object Repository Infrastructure Project 0 0 0 0 80,945 80,945 Total Costs for Community Colleges System Office 0 26,361 0 0 10,333,901 10,360,262 Department of Administration Motor Fleet Management System (MFMS) Project 0 0 0 229,980 80,832 310,812 Department of Administration NC FLEX Web-Based Enrollment System Project 0 0 0 0 478,707 478,707 Department of Administration NC Works - Phase I 0 0 0 0 55,715 55,715 Total Costs for Department of Administration 0 0 0 229,980 615,254 845,234 Department of Commerce Application Development & Support Services 0 2,717 0 0 0 2,717 Page 45 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Commerce CMS - Content Management System 9,000 0 0 0 570,041 579,041 Department of Commerce Economic Development Intelligence System Project 0 0 0 0 218,694 218,694 Department of Commerce Industrial Commission Electronic Document Management System (EDMS) Migration and Replacement 0 0 0 0 557,106 557,106 Department of Commerce Terminal Operating System 0 0 0 6,300 0 6,300 Total Costs for Department of Commerce 9,000 2,717 0 6,300 1,345,841 1,363,858 Department of Correction DOC Sex Offender GPS 68,632 0 0 0 154,275 222,907 Total Costs for Department of Correction 68,632 0 0 0 154,275 222,907 Department of Crime Control and Public Safety Flood Inundation Mapping and Alert Network (FIMAN) - (West) 0 0 0 0 61,241 61,241 Department of Crime Control and Public Safety Viper Strategic Solution Implementation Project - Phase 0 6,606,163 0 0 0 362,470 6,968,633 Department of Crime Control and Public Safety VIPER Strategic Solution Implementation Project - Phase 1 15,637,000 0 0 0 8,451,897 24,088,897 Page 46 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Total Costs for Department of Crime Control and Public Safety 22,243,163 0 0 0 8,875,608 31,118,771 Department of Environment and Natural Resources Central Reservation System 0 0 0 0 35,622 35,622 Department of Environment and Natural Resources EEP Information Management System 0 0 0 1,116,064 9,688 1,125,752 Department of Environment and Natural Resources Point of Sale System Replacement 0 0 0 5,200 196 5,396 Total Costs for Department of Environment and Natural Resources 0 0 0 1,121,264 45,506 1,166,770 Department of Health and Human Services Central Region Psychiatric Hospital Automation Program (CHAPS) Infrastructure Project 0 0 0 0 1,749,052 1,749,052 Department of Health and Human Services Client Services Data Warehouse Business Objects XI Migration 295,746 0 0 0 320,385 616,131 Department of Health and Human Services Client Services Data Warehouse Hardware Migration Project 721 0 0 0 781 1,502 Department of Health and Human Services Crossroads State Agency Model Project (SAM) 240,963 0 0 0 0 240,963 Department of Health and Human Services DHHS Security Project 11,743 0 0 0 863,684 875,427 Page 47 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Health and Human Services DHHS Disability Determination Services Section - Telephony Upgrade 214,477 0 0 0 0 214,477 Department of Health and Human Services DHHS HIPAA National Provider Identifier (NPI) Initiative 103,730 0 0 0 5,480,647 5,584,377 Department of Health and Human Services Division of Medical Assistance - Home and Community Based Services Reforms Project 0 0 0 0 8,335 8,335 Department of Health and Human Services Division of Medical Assistance - Uniform Screening Program 0 0 0 0 1,041,799 1,041,799 Department of Health and Human Services Health Information System 15,412 453,218 0 0 4,947,924 5,416,554 Department of Health and Human Services LIMS - Laboratory Information Management System 1,000,843 0 0 0 0 1,000,843 Department of Health and Human Services Martin County Call Center Upgrade 0 3,863 0 0 37,495 41,358 Department of Health and Human Services NC Electronic Disease Surveillance System (NC EDSS) 1,565,378 0 0 0 0 1,565,378 Department of Health and Human Services NC FAST Automated Interview (AI) Integrator Selection Project 251,415 0 0 0 405,365 656,780 Department of Health and Human Services NC FAST Automated Interview Software Selection 49,203 0 0 0 79,396 128,599 Page 48 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Health and Human Services NC FAST Legacy Systems Analyses Project 180,920 0 0 0 274,316 455,236 Department of Health and Human Services NC FAST Program Definition Project 53,382 0 0 0 84,267 137,649 Department of Health and Human Services NC FAST Service Delivery Interface (SDI) Project 62,212 0 0 0 95,834 158,046 Department of Health and Human Services NC Information and Referral 270,208 0 0 0 0 270,208 Department of Health and Human Services NCMMIS Initiative 2,859,050 0 0 0 394,631 3,253,681 Department of Health and Human Services NCMMIS+ Program - Artifacts Review and Update Project 611,291 0 0 0 68,405 679,696 Department of Health and Human Services NCMMIS+ Program - Business Rules and Analysis Project 620,491 0 0 0 68,948 689,439 Department of Health and Human Services NCMMIS+ Program – DHSR Business Process Automation Project 449,875 0 0 0 50,000 499,875 Department of Health and Human Services NCMMIS+ Program Planning Project 868,168 0 0 0 96,463 964,631 Department of Health and Human Services NCMMIS+ Program–Medicaid Accounting System (MAS) & Accounts Receivable / Payable Business Process 75,228 0 0 0 8,379 83,607 Page 49 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Health and Human Services NCMMIS+ Replacement Strategy Project for Provider Type and Provider Specialty 287,453 3,433 0 0 28,509 319,395 Department of Health and Human Services Vital Records and Statistics Automation System 2,763 0 0 391,679 14,410 408,852 Total Costs for Department of Health and Human Services 10,090,672 460,514 0 391,679 16,119,025 27,061,890 Department of Justice Disaster Recovery (BCP/DR) Implementation 0 50 0 0 324,082 324,132 Department of Justice Learning Management System Project (formerly Training & Standards Learning Management ...) 0 191,692 0 0 0 191,692 Department of Justice SSN Replacement & Database Conversion Project (formerly Training & Standards Conversion ...) 0 275,224 0 0 0 275,224 Department of Justice Statewide Automated Fingerprint Identification System (SAFIS) Replacement Project 0 0 0 0 1,369,975 1,369,975 Total Costs for Department of Justice 0 466,966 0 0 1,694,057 2,161,023 Department of Public Instruction CECAS 2007 Hosting 2,354 0 0 0 0 2,354 Department of Public Instruction Child Nutrition Claims (CNC) 279,967 0 0 0 55,270 335,237 Page 50 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Public Instruction Child Nutrition Direct Certification and Verification 13,704 0 0 0 3,289 16,993 Department of Public Instruction Comprehensive Exceptional Children Accountability System (CECAS) Initiative 1,072,358 0 0 0 0 1,072,358 Department of Public Instruction DPI LAN Hardware and Wiring Upgrade 0 602 0 0 10,235 10,837 Department of Public Instruction eSIS 9.1 Upgrade 0 0 0 0 175,921 175,921 Department of Public Instruction K-Nect 1,929 0 247,650 0 14,257 263,836 Department of Public Instruction NC WISE - Enhancements 0 0 0 0 11,560 11,560 Department of Public Instruction NC WISE Wave 3 Deployment 0 0 0 0 139,315 139,315 Department of Public Instruction NCWISE Reporting 0 0 0 0 1,831,515 1,831,515 Department of Public Instruction NCWISE Wave 2 Deployment 0 0 0 0 2,796,010 2,796,010 Department of Public Instruction Online Educational Services for Student Achievement Improvement 209,000 0 0 0 13,496 222,496 Page 51 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Total Costs for Department of Public Instruction 1,579,312 602 247,650 0 5,050,868 6,878,432 Department of Revenue Motor Fuels Tracking System 0 0 0 1,162,439 0 1,162,439 Department of Revenue Online Filing and Payments Services 0 0 0 0 827,243 827,243 Total Costs for Department of Revenue 0 0 0 1,162,439 827,243 1,989,682 Department of the StateTreasurer Integrated Document Managemt System - Unclaimed Property Program (IDMS-UPP) 0 0 0 530,330 0 530,330 Department of the StateTreasurer Integrated Retirement System Planning 0 0 0 5,411,939 0 5,411,939 Total Costs for Department of the StateTreasurer 0 0 0 5,942,269 0 5,942,269 Department of Transportation 511 Traveler Information System Phase II 396,800 0 0 0 99,200 496,000 Department of Transportation Automated Testing System 0 0 0 0 810,904 810,904 Department of Transportation Customer Traffic Management System 0 0 0 0 209,662 209,662 Page 52 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Transportation Customer Traffic Management Systems Phase II 0 0 0 0 437,027 437,027 Department of Transportation Database Cleansing of Legacy Photo Images 0 0 0 0 406,160 406,160 Department of Transportation DMV Call Center Relocation 0 0 0 0 44,562 44,562 Department of Transportation DMV License Plate Recall 0 41,680 0 0 66,472 108,152 Department of Transportation Enterprise Web Portal and Executive Dashboard 265,492 0 0 0 499,796 765,288 Department of Transportation ERP 2005 Upgrade 15,748 0 0 0 10,715 26,463 Department of Transportation Facility Management Systems 130,760 13,190 0 0 212,307 356,257 Department of Transportation Fleet Documentation 32,680 0 0 0 43,503 76,183 Department of Transportation Grants in Contract Management (DBE) 46,811 0 0 0 86,935 133,746 Department of Transportation Greenfield Center Infrastructure 27,491 0 0 0 312,092 339,583 Page 53 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Transportation HiCAMS Architecture Study 0 0 0 0 157,300 157,300 Department of Transportation IputAccel Upgrade R5.2 0 0 0 0 328,605 328,605 Department of Transportation IRP/MC & LITES Upgrades and Migration 0 0 0 0 26,592 26,592 Department of Transportation Maintenance Management System (MMS) Handheld Systems 129 0 0 0 17,353 17,482 Department of Transportation NCSmartlink 19,194 0 0 0 6,022 25,216 Department of Transportation Notice, Storage and Theft System 0 0 0 0 9,949 9,949 Department of Transportation Pavement Management System Project Phase 2 (Implementation) 535,568 0 0 0 1,249,653 1,785,221 Department of Transportation PreQualification Automation 144,430 0 0 0 193,532 337,962 Department of Transportation SDLC and Requirements Management 0 0 0 0 56,509 56,509 Total Costs for Department of Transportation 1,615,103 54,870 0 0 5,284,850 6,954,823 Page 54 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Employment Security Commission Initial Claims Call Center 773,173 0 0 0 0 773,173 Employment Security Commission UI Fraud & Identify Theft 35,734 0 0 0 0 35,734 Employment Security Commission VoIP Telephony Solution for ESC Unemployment Insurance Division, Central Office Complex 109,438 0 0 0 0 109,438 Total Costs for Employment Security Commission 918,345 0 0 0 0 918,345 NC Wildlife Resources Coastal Recreational Fishing License Implementation 0 0 0 490,285 0 490,285 NC Wildlife Resources Phase 4 Online Licensing and Vessel Registration Project 0 0 0 18,000 0 18,000 Total Costs for NC Wildlife Resources 0 0 0 508,285 0 508,285 Office of the State Auditor Non-Governmental Organization Grant Compliance - Business Intelligence & Data Warehouse 0 0 0 0 190,188 190,188 Total Costs for Office of the State Auditor 0 0 0 0 190,188 190,188 Office of the State Controller BEACON-HR/PAYROLL 0 0 0 0 23,880,847 23,880,847 Page 55 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Total Costs for Office of the State Controller 0 0 0 0 23,880,847 23,880,847 State Board of Elections ERAPP (e-Pollbooks) 0 0 0 0 11,500 11,500 State Board of Elections Voter Registration Server Upgrade 2,000 0 0 0 0 2,000 State Board of Elections Voting Equipment Upgrade HAVA ( Help America Vote Act ) 5,211,592 0 0 0 0 5,211,592 State Board of Elections WBET - WEB Based Elections Tools 0 0 0 0 2,750 2,750 Total Costs for State Board of Elections 5,213,592 0 0 0 14,250 5,227,842 Total Costs for Non-ITS 41,737,819 1,012,030 247,650 9,362,216 74,431,713 126,791,428 Page 56 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Office of Information Technology Services Electronic Document Management Service 0 0 0 0 228,882 228,882 Office of Information Technology Services Enterprise Service Access Point (ESAP) 0 0 0 1,113,686 0 1,113,686 Office of Information Technology Services Intrusion Prevention System (IPS) for State Infrastructure 0 0 0 13,480 0 13,480 Office of Information Technology Services IT Asset Management (ITAM) Project Phase 1 0 0 0 0 686,169 686,169 Office of Information Technology Services IT Consolidation Phase II - Industrial Commission 21,770 0 0 312,705 124,080 458,555 Office of Information Technology Services IT Consolidation Pilot Project 0 0 0 537,512 57,221 594,733 Office of Information Technology Services ITS On Boarding to Electronic Document Management Service 0 0 0 0 75,725 75,725 Office of Information Technology Services ITS SQA Shared Service 0 0 0 0 735,895 735,895 Office of Information Technology Services Managed Platform - Server Virtualization 0 0 0 815,974 171,717 987,691 Office of Information Technology Services OEP Culminating Phases 0 0 0 1,097,881 0 1,097,881 Page 57 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Office of Information Technology Services Operational Excellence Program Phase I 0 0 0 744,833 0 744,833 Office of Information Technology Services Phase 1 ITS Data Warehouse Shared Service 0 157,290 0 0 0 157,290 Office of Information Technology Services Polycom MGC-100 Video MCU Procurement 0 0 0 900 0 900 Office of Information Technology Services Remedy Service Desk Implementation 0 0 0 0 378,320 378,320 Office of Information Technology Services SDC - Capacity Back Up Mainframe 0 8,000 0 0 0 8,000 Office of Information Technology Services Security Information and Event Management (SIEM) Procurement & Implementation 0 0 0 369,600 0 369,600 Office of Information Technology Services Statewide Secondary Data Center 0 0 0 16,367,405 0 16,367,405 Office of Information Technology Services Upgrade of Disk Storage Infrastructure 0 0 0 2,469,460 0 2,469,460 Office of Information Technology Services Z9 Mainframe Upgrade 0 0 0 0 3,089,946 3,089,946 Total Costs for Office of Information Technology Services 21,770 165,290 0 23,843,436 5,547,955 29,578,451 Page 58 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Total Costs for ITS 21,770 165,290 0 23,843,436 5,547,955 29,578,451 Page 59 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Community Colleges System Office College Data Accounting System 9,034 0 0 1,802 4,618 0 15,454 Current GED System 5,155 0 0 1,622 4,608 0 11,385 Data Warehouse - 2 356,500 0 0 4,532 128,607 0 489,639 E-Leave (NCCCS) 0 0 0 180 911 0 1,091 Legacy GED System 0 0 3,743 0 0 0 3,743 SIRSI Library System 0 0 0 3,596 215,348 0 218,944 Total Costs for Community Colleges System Office 370,689 0 3,743 11,732 354,092 0 740,256 Department of Administration Applicant Tracking System - v1 DOA 6,800 0 0 0 0 0 6,800 APT Accounts Receivable 6,800 0 0 0 0 0 6,800 CAD Call Log 0 0 0 0 0 13,745 13,745 Courier Accounts Receivable 6,800 0 0 0 0 0 6,800 Courier Billing 6,800 0 0 0 0 0 6,800 DV & SA Statistical 6,800 0 0 0 0 0 6,800 Educational Talent Search 6,800 0 0 0 0 0 6,800 Energy Management Software 6,840 0 0 0 0 0 6,840 Federal Surplus Accounts Receivable DOA 6,800 0 0 0 0 0 6,800 Federal Surplus Property- Office DOA 12,000 0 0 0 0 0 12,000 Federal Surplus Property Sales DOA 6,800 0 0 0 0 0 6,800 Page 60 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Administration HUBSCO DOA 20,000 0 0 0 0 0 20,000 Interactive Purchasing and Vendor Link 20,000 0 0 0 0 0 20,000 Leave - DOA 6,800 0 0 0 0 0 6,800 Mail Center Billing - DOA 15,000 0 0 0 0 0 15,000 Mail List DOA 6,800 0 0 0 0 0 6,800 Motor Fleet Management DOA 0 230,400 0 80,000 0 0 310,400 MotorFleet Mgmt Travel Log 6,800 0 0 0 0 0 6,800 NC Motor Fleet System 13,600 0 0 0 0 0 13,600 NCDVA Scholarship Program 11,939 0 0 0 0 0 11,939 Personnel Management Information System 597,245 15,619 0 97,809 756,887 0 1,467,560 Phoenix Alarm Monitoring - DOA 2,707 0 0 0 0 0 2,707 Procurement Card DOA 6,800 0 0 0 0 0 6,800 Section 8 Housing 4,365 0 0 0 0 0 4,365 State Clearinghouse Intergovernmental Review Tracking 6,800 0 0 0 0 0 6,800 State Parking System 0 0 11,578 0 2,234 0 13,812 State Surplus Property DOA 30,000 0 0 0 0 0 30,000 Temporary Solution Accounts Receivable 6,800 0 0 0 0 0 6,800 Total Maintenance Management 6,000 0 0 0 0 0 6,000 Youth Registration System 6,800 0 0 0 0 0 6,800 Page 61 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 841,696 Total Costs for Department of Administration 246,019 11,578 177,809 759,121 13,745 2,049,968 Department of Agriculture and Consumer Services Agricultural Review System 1,400 0 0 0 0 0 1,400 Agronomic Lab Information System 63,200 32,000 250 4,100 0 0 99,550 Animal Health Programs Database (formerly NCHAMS) 8,400 0 0 0 0 0 8,400 Applicant Tracking 10,500 0 0 0 0 0 10,500 Aquatic Dealer Permit 700 0 0 0 0 0 700 Assessments System 6,720 0 30 0 0 0 6,750 Departmental Licensing System 61,600 0 3,200 0 0 0 64,800 Duplicating Services Chargeback System 15,400 0 20 0 0 0 15,420 F&V Terminal Market/Shipping Point 2,742 0 0 0 0 0 2,742 Feed Lab System 700 0 50 0 0 0 750 Feed Registration System 700 0 20 0 0 0 720 Feed Report System 700 0 10 0 0 0 710 Feed Tonnage System 700 0 20 0 0 0 720 Feed Transcript System 2,100 0 20 0 0 0 2,120 Fertilizer Lab System 700 0 25 0 0 0 725 Fertilizer Penalty System 700 0 10 0 0 0 710 Fertilizer Registration System 700 0 10 0 0 0 710 Page 62 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Agriculture and Consumer Services Fertilizer Tonnage System 1,400 0 20 0 0 0 1,420 Fertilizer Transcript System 700 0 10 0 0 0 710 Food Distribution Tracking System 69,000 26,271 0 0 0 0 95,271 FS Billing 6,763 0 0 0 0 0 6,763 Grain Grading Certificates 7,311 0 0 1,075 0 0 8,386 Horse Feed Assessments 1,120 0 0 0 0 0 1,120 Limestone Tonnage System 700 0 130 0 0 0 830 Market News Grain 2,520 0 0 0 0 0 2,520 Market News Livestock System 4,200 0 0 0 0 0 4,200 Market News Poultry System 2,240 0 0 0 0 0 2,240 Milled Peanut Certificates 11,516 0 884 6,450 0 0 18,850 Motor Fuel Registration System 2,800 0 250 0 0 0 3,050 Mountain State Fair Clogging, Mountain Music & Gospel Singing 2,100 0 0 0 0 0 2,100 Mountain State Fair Display Livestock 2,100 0 0 0 0 0 2,100 Mountain State Fair Div I&III 3,500 0 0 0 0 0 3,500 Mountain State Fair Exhibitor & Concessionaires 1,500 0 0 0 0 0 1,500 Mountain State Fair Flower & Garden 2,800 0 0 0 0 0 2,800 Mountain State Fair Livestock Show 3,500 0 0 0 0 0 3,500 Mountain State Fair Llama Show 2,100 0 0 0 0 0 2,100 Page 63 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Agriculture and Consumer Services Mountain State Fair Poultry & Pigeon Show 2,100 0 0 0 0 0 2,100 Mountain State Fair Rabbit Show 2,100 0 0 0 0 0 2,100 Multi-Hazard Threat database 24,000 0 0 37,000 1,000 0 62,000 NCForay (Cotton Boll Weevil Automated Acreage Assessment 0 1,248 0 0 0 0 1,248 Noxious Weed Phytosanitary Tracking State 700 0 0 0 0 0 700 Nursery Phytosanitary Tracking Federal 700 0 0 0 0 0 700 Nursery Phytosanitary Tracking State 700 0 0 0 0 0 700 Office Supplies Inventory System 700 0 20 0 0 0 720 Pesticide Inspector Activity System 700 0 0 0 0 0 700 Pesticide Recertification System 700 0 0 0 0 0 700 Pesticide Registration 28,000 0 400 0 0 0 28,400 Plant Conservation Permit Inspection Reporting System Online 650 0 0 0 0 0 650 Plant Conservation Permit Inspection Tracking System Online 1,350 0 0 0 0 0 1,350 Plant Conservation Permit Request System Online 2,050 0 0 0 0 0 2,050 Rhapsody 20,000 0 0 1,000 5,000 1,500 27,500 Seed Assessments System 4,200 0 0 0 0 0 4,200 Seed Germination Laboratory Information System 22,400 0 0 0 0 0 22,400 Seed Input Laboratory Information System 1,400 0 0 0 0 0 1,400 Seed Inspector Reporting System 7,000 0 0 0 0 0 7,000 Page 64 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Agriculture and Consumer Services Seed Planting Laboratory Information System 1,400 0 0 0 0 0 1,400 Seed Purity Laboratory Information System 11,200 0 0 0 0 0 11,200 Seed Reporting Laboratory Information System 15,400 0 0 0 0 0 15,400 Seed Tetrazolium Laboratory Information System 1,400 0 0 0 0 0 1,400 Soft Serve System 700 0 10 0 0 0 710 Standards Lab Scheduling System 10,350 0 0 0 0 0 10,350 State Fair Arts and Photo Exhibition 2,100 0 0 0 0 0 2,100 State Fair Entry System 1,400 0 0 0 0 0 1,400 State Fair Event Management System 3,080 0 0 0 0 0 3,080 State Fair Folk Festival 4,900 0 0 0 0 0 4,900 State Fair Livestock Exhibition 16,100 0 0 0 0 0 16,100 State Maillist System 1,400 0 30 0 0 0 1,430 Structural Pest Automated Inspection System 21,000 0 0 0 0 0 21,000 Structural Pest Control Inspection & Billing System 14,700 0 50 0 0 0 14,750 Structural Pest Control Recertification System 700 0 300 0 0 0 1,000 Temporary and Part-time Payroll System 2,800 0 0 0 0 0 2,800 Veterinary LIMS 95,000 0 0 65,500 51,000 0 211,500 Witchweed 1,400 0 0 0 0 0 1,400 WNC State Fair Event Management System 3,640 0 0 0 0 0 3,640 Page 65 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Total Costs for Department of Agriculture and Consumer 633,652 59,519 5,769 115,125 57,000 1,500 872,565 Services Department of Commerce 3m Core Grouping Inpatient Interactive Module 2,000 0 0 300 5,000 0 7,300 ABC Online(2) 0 43,275 0 5,221 16,309 0 64,805 ABC Permit System(2) 0 43,275 0 5,221 16,309 0 64,805 ABC Pricing System(2) 0 43,275 0 5,221 16,309 0 64,805 ABC Product Compliance System(2) 0 25,965 0 3,132 9,786 0 38,883 ABC Violation Tracking System(2) 0 17,310 0 2,088 6,524 0 25,922 Apptrack 7,252 0 0 1,539 659 0 9,450 Automated Time & Leave Accounting System (ATLAS) - v2 28,781 0 0 2,785 2,063 0 33,629 BLIO Consultant/Client Contact Tracking System 5,365 0 0 520 156 0 6,041 BLIO Permits/Licensing Information Management System 10,351 0 0 1,108 670 0 12,129 CDBG Grants Information System 42,193 0 0 265 39 0 42,497 Commerce Application Portfolio 15,593 0 0 2,488 1,859 0 19,940 Commerce CMS - Content Management System 6,381 0 0 375 789 0 7,545 Commerce Online Web Tools 42,604 0 0 1,756 2,108 0 46,468 Community Investment Reports 10,333 0 0 1,028 688 0 12,049 GroupWise - NCIC 40,000 0 752 1,000 1,000 0 42,752 Mainframe Host-on-Demand 80,000 66,212 81,602 1,000 1,000 0 229,814 Page 66 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Commerce Mediation 6,000 0 0 500 1,000 0 7,500 NCCOB Online 13,648 107,000 0 3,500 2,754 0 126,902 NCCOB Website 4,811 0 0 709 450 0 5,970 NCDWD FMIS Application 1,500 6,000 0 12,500 0 0 20,000 NCDWD Mobile Joblink Scheduling Application 28,861 0 0 400 542 0 29,803 NCDWD WIA Reporting Application For WF+ 50,000 0 0 0 0 0 50,000 NCDWD WorkforcePlus 40,000 0 40,000 25,000 0 0 105,000 NCIC Website Searchable Databases 6,000 0 0 500 400 0 6,900 PPD2 - Partial Permanent Disability 3,500 0 0 500 1,000 0 5,000 RightFax 15,000 0 0 2,500 1,800 0 19,300 Sites & Buildings 14,528 0 0 2,148 1,706 0 18,382 Track-It! 4,000 0 0 500 500 0 5,000 Web Based CDBG Accomplishments Reporting System 2,000 0 0 275 139 0 2,414 Total Costs for Department of Commerce 480,701 352,312 122,354 84,079 91,559 0 1,131,005 Department of Correction 7K Time and Leave 54,642 0 0 30,466 0 0 85,108 Applicant Tracking System 115,112 0 0 30,466 0 0 145,578 Business Information & Data System 136,500 0 0 106,636 0 0 243,136 Cashless on the Net 48,286 0 0 487,479 0 0 535,765 Page 67 Agency Application Name Internal Per
Object Description
Description
Title | Information technology expenditures report : for the period ended... |
Date | 2007-06-30 |
Description | June 30, 2007 |
Digital Characteristics-A | 766 KB; 191 p. |
Digital Format | application/pdf |
Full Text | NORTH CAROLINA INFORMATION TECHNOLOGY EXPENDITURES REPORT For the Period Ended June 30, 2007 Office of the State Controller Office of Information Technology Services Office of State Budget and Management State of North Carolina Office of the State Controller Michael F. Easley, Governor Robert L. Powell, State Controller October 1, 2007 MEMORANDUM TO: The Honorable Michael F. Easley, Governor The Honorable Marc Basnight, Senate President Pro Tempore The Honorable Joe Hackney, Speaker of the House of Representatives FROM: Robert L. Powell, State Controller David McCoy, State Budget Officer George Bakolia, State Chief Information Officer SUBJECT: Annual Information Technology Expenditures Report Transmittal To fulfill the reporting requirements of G.S. 147-33.87, the Office of the State Controller, Office of Information Technology Services and Office of State Budget and Management have prepared the Information Technology Expenditures Report which outlines the total information technology expenditures within the State. This annual report covers the period July 2006 through June 2007 and is available through the OSC web site at http://www.ncosc.net/financial/ITReport_06302007.pdf. This report shows total information technology (IT) expenditures, excluding the Office of Information Technology Services, of $1,017,543,419 for the fiscal year ending June 30, 2007. This is an increase of $75 million or 8.01% as compared to June 30, 2006. For the Office of Information Technology Services, total IT expenditures were $155,699,845. This is an increase of $25 million or 19.18% as compared to June 30, 2006. Project/Application specific financial costs are again presented using data input into the IT Portfolio Management System administered by the Office of Information Technology Services (ITS). Project/Application costs as reported for agencies subject to G.S. 147-33.87 (excluding ITS) for June 30, 2006 were $345,695,102 and represented 66.92% of total IT expenditures (excluding Administrative Office of the Courts, the NC Education Lottery, the UNC System and ITS). For June 30, 2007 this total is $366,506,720 and represents 67.42% of total IT expenditures. This is an increase of $20.8 million or 6.02% as compared to June 30, 2006. The next report to be published will be for the period from July 2007 through June 2008. For additional information about this report, please contact the Office of the State Controller. cc: Chief Executive Officers Chief Fiscal Officers Chief Information Officers Legislative Fiscal Research State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 TABLE OF CONTENTS Introduction .................................................................................................................................1 Overview of IT Expenditures .................................................................................................2 Report Methodology...............................................................................................................2 Categories..............................................................................................................................3 Summary of IT Expenditures.......................................................................................................4 Table 1-1 IT Expenditures......................................................................................................5 Table 1-2 IT Expenditures – IT Portfolio Management System Detail Cost Categories .......6 Table 1-3 IT Expenditures – UNC System Agencies.............................................................7 Table 1-4 Percentage of IT Expenditures to Total Expenditures............................................8 Expenditure Summary by Budget Code Type .............................................................................9 Table 2-1 IT Expenditures Summary for General Fund Budget Codes ...............................10 Table 2-2 IT Expenditures Summary for All Other Budget Codes ......................................11 Budget to Actual Comparison and Current vs. Prior Year .......................................................12 Table 3-1 IT Expenditures - Budget to Actual Comparison.................................................13 Table 3-2 IT Expenditures - Current versus Prior Year ......................................................14 Table 3-3 IT Expenditures - Current versus Prior Year – UNC System Agencies...............15 IT Related Contracted Personal Services...................................................................................16 Table 4-1 IT Related Contracted Personal Services.............................................................17 Table 4-2 IT Related Contracted Personal Services – UNC System Agencies ....................18 Salary and Fringe Benefit Calculations......................................................................................19 Table 5-1 Salary and Calculated Fringes for All IT Positions .............................................20 Table 5-2 Salary and Calculated Fringes for All IT Positions - UNC System Agencies .....21 Salary Cost by Position Status and Type....................................................................................22 Table 5-3 Total IT Salary and Fringe Amount by Position Status .......................................23 Table 5-4 Total IT Salary and Fringe Amount by Position Status - UNC System Agencies24 Table 5-5 Salary and Calculated Fringes by Banding Category for all IT Positions............25 FTE Comparison between IT Positions and All Positions .........................................................26 Table 5-6 IT FTE’s versus All FTE’s...................................................................................27 Portfolio Management ................................................................................................................28 Table 6-1 IT Expenditures – Projects...................................................................................33 Table 6-2 IT Expenditures – Projects by Source of Funds...................................................45 Table 6-3 IT Expenditures – Applications……………………………………….………...60 Table 6-4 IT Expenditures – Applications by Source of Funds……………..…………....124 THIS PAGE INTENTIONALLY LEFT BLANK State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 1 Introduction The purpose of this report is to provide total information technology (IT) expenditures within the State as required by G.S. 147-33.87 “Financial Reporting and Accountability for Information Technology Investments and Expenditures.” This statute requires an annual report of IT operations and projects expenditures coordinated by the Office of Information Technology Services with the Office of State Budget and Management and the Office of the State Controller. For this report, information technology is defined as “Electronic data processing goods and services, telecommunications goods and services, security goods and services, microprocessors, software, information processing, office systems, any services related to the foregoing, and consulting or other services for design or redesign of information technology supporting business processes (G.S. 147-33.81).” The General Assembly, the Administrative Office of the Courts, the North Carolina Education Lottery, and the UNC System are specifically exempted under G.S. 147-33.80 from these requirements; however, due to readily available financial data in the North Carolina Accounting System for the Administrative Office of the Courts, the North Carolina Education Lottery, and the UNC System, their information is included in this report to provide a more complete picture of information technology expenditures in the State. The General Assembly, the Administrative Office of the Courts, the North Carolina Education Lottery, and the UNC System are not included in the Information Technology Portfolio Management System reporting of project and application expenditures. The basis for this report is the statewide chart of accounts and the personnel classification system. The primary sources of this data are the North Carolina Accounting System (NCAS), the Personnel Management Information System (PMIS), and the Information Technology Portfolio Management System. This report covers the time period of July 2006 through June 2007 and includes all funding sources. In an ongoing effort to refine and improve IT expenditure reporting, several new tables have been added to this year’s report. Reporting of projects and applications was greatly expanded last year by moving from the project reporting in NCAS to the Information Technology Portfolio Management System. The project and application reporting has been expanded to include reporting by source of funds. Since the detail categories used in the Information Technology Portfolio Management System differ from those presented in the total summary reports, Table 1-2 was added to present the total expenditures using those detail categories. Comparison between the two was also enhanced by moving the Administrative Office of the Courts information below the totals line since they do not report project and application information. The banding of IT positions by the Office of State Personnel has made the presentation of IT salary and fringe amounts by pay grade less meaningful. It also led to a review of the class codes currently being included as IT positions. This resulted in the exclusion of 42 codes and represents a reduction of Salary and Benefits included as IT expenditures of $16.2 million. Total IT expenditures would have been 1.6% higher without this exclusion. Expenditures by pay grade have been replaced with a listing by IT Banding Categories. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 2 In the past current vs. prior year information was presented for universities only. Table 3-2 has been added to present this data for other agencies as well. In order to make the report more readable the tables have been reorganized to a more logical grouping and renumbered accordingly. Overview of IT Expenditures Total Information Technology Expenditures excluding ITS PMIS BUDGETED SALARY PLUS FRINGES 36% SERVER 5% MAINFRAME 10% APPLICATIONS DEVELOP AND OTHER 24% TELECOMM 13% LOCAL AREA NETWORK 3% WIDE AREA NETWORK 1% PERSONAL COMPUTER AND PRINTER 7% VIDEO TRANSMISSION 1% Total IT expenditures (excluding ITS) were $1,017,543,419 for fiscal year 2007. IT Expenditures for the Office of Information Technology totaled $155,699,845 during the same period. As can be seen in this chart, PMIS Budgeted Salaries plus Fringes continue to be the largest percentage of IT related expenditures at 36% of total IT expenditures. The next largest categories of expenditures are Applications Development and Other (24%), Telecommunication (13%), and Mainframe (10%). Remaining expenditures are broken down into the additional categories listed on Table 1-1 Information Technology Expenditures. Report Methodology Under the NCAS chart of accounts, most information technology operational costs are identified through specific account codes. The primary exception is personnel related costs that are recorded within NCAS in aggregate, without regard to the type of work performed by the position. These costs include salary, fringe benefits, and employee training expenses. To estimate salary and fringe benefit costs associated to information technology positions, this report utilizes the class code structure within PMIS. Budgeted salary for all permanent positions assigned an information technology specific class code is used to estimate each agency’s personal services obligation for this fiscal year. The budgeted salary amounts include both vacant and filled positions. Next year, this information will be taken from the new BEACON HR Payroll system. Upon full implementation of BEACON for a complete fiscal reporting period, actual costs will be reported rather than just budgeted amounts. Employee training costs for IT personnel cannot be compiled or estimated using NCAS or PMIS. These costs are not included in this report. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 3 All other non personnel costs are grouped into reporting categories as follows: Category Description Personal Computers and Printers Costs associated with the purchase, lease, and support of personal computers, software, and printers Local Area Network Costs associated with the purchase, lease, and support of hardware and wiring comprising a local area network Wide Area Network Costs associated with equipment and communication lines to provide video and data connectivity services across a large geographical area. Video Transmission Costs associated with the transmission of video images, including equipment, support, and North Carolina Information Highway (NCIH) charges. Video conferencing and distance education are primary uses of this technology. Server Costs associated with the purchase, lease, and support of servers and the software installed on the server. Mainframe Costs associated with the purchase, lease, and support of a mainframe computer and software. Costs include both purchased and developed software. Applications Development and Other Costs associated with computer related hardware, software, contractual services, or maintenance that has not been otherwise categorized. This category includes costs for development of new applications. Telecommunications Costs associated with providing voice and data communications. A detailed list of accounts in each category may be obtained by contacting the Office of the State Controller. The Department of Transportation (DOT) posts some work order based costs in aggregate as deferred charges or other assets within NCAS. To obtain a more complete picture of IT costs, non-personnel related costs for the Department of Transportation are from the DOT financial system. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 4 Summary of IT Expenditures Table 1-1 Information Technology Expenditures lists by agency, the total IT expenditures grouped into major cost categories. The amounts listed are total costs, without regard to the funding source. As a primary IT services vendor for most agencies, the Office of Information Technology Services is shown separately and is not included in the report totals. Table 1-2 Information Technology Expenditures – Information Technology Portfolio Management System Detail Cost Categories lists by agency, the total IT expenditures grouped into the detail cost categories used in the Information Technology Portfolio Management System. The amounts listed are total costs, without regard to the funding source. As a primary IT services vendor for most agencies, the Office of Information Technology Services is shown separately and is not included in the report totals. Table 1-3 Information Technology Expenditures - UNC System Agencies lists by university the total IT expenditures grouped into major cost categories. Costs are segregated into the same categories as used in Table 1-1. Personnel costs are estimated using PMIS data; however, UNC System agencies operating their own payroll systems are not required to enter EPA position information into PMIS. UNC General Administration provided EPA position summary data which was included in this report. Table 1-4 Percentage of IT Expenditures to Total Expenditures lists, by agency, the percentage of total IT expenditures compared to total expenditures, without regard to funding source. Information Technology expenditures represent 1.68% of total expenditures for all agencies listed (excluding the Office of Information Technology Services). The Office of Information Technology Services has IT expenditures totaling 86.90% of their total expenditures. Page 5 PMIS BUDGETED SALARY PLUS FRINGES PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Comprehensive Major Medical Plan 146,744 159,999 28,199 0 0 1,358 24,355 0 91,515 452,170 Community Colleges System Office 5,328,240 105,884 98,436 242 4,781 3,290,746 278,419 12,521,143 77,959 21,705,850 Department of Administration 1,555,235 220,091 851,737 9,965 135,133 87,066 861,365 454,949 642,487 4,818,028 Department of Agriculture & Consumer Services 2,521,447 871,005 415 108,629 1,032 196,231 106,426 247,810 864,483 4,917,478 Department of Commerce 3,113,972 709,057 325,083 20,320 315 441,996 570,679 1,995,157 761,909 7,938,488 Department of Correction 9,127,850 2,235,580 232,618 11,879 156,773 435,353 8,460,142 1,138,113 4,868,196 26,666,504 Department of Crime Control & Public Safety 4,497,230 2,693,098 71,054 385,138 71,960 1,142,196 351,599 22,413,897 17,999,666 49,625,838 Department of Cultural Resources 1,056,958 486,123 2,647 0 0 23,690 198,872 253,549 537,686 2,559,525 Department of Environment & Natural Resources 9,982,223 2,192,292 102,816 252,279 18,042 932,864 793,201 3,087,119 3,565,634 20,926,470 Department of Health and Human Services 29,405,385 4,388,367 14,632,024 566,076 5,159 2,912,482 21,152,808 82,625,892 11,989,964 167,678,157 Department of Insurance 1,603,208 187,648 26,257 58,811 0 467,519 47,662 126,832 367,541 2,885,478 Department of Justice 5,499,219 2,736 5,400 174,160 0 0 402,072 4,172,750 2,325,520 12,581,857 Department of Juvenile Justice & Delinquency Prevention 2,230,189 599,489 5,425 52,558 0 201,959 97,244 357,376 1,206,004 4,750,244 Department of Labor 723,466 120,274 60,850 52,608 0 17,394 45,152 92,488 371,783 1,484,015 Department of Public Instruction 11,013,156 1,111,580 1,735,489 2,958,957 1,848,011 2,170,569 1,439,081 7,698,982 3,004,123 32,979,948 Department of Revenue 8,266,285 1,087,437 360,526 60,462 6,835 1,422,909 7,313,653 3,903,398 2,698,938 25,120,443 Department of Secretary of State 828,501 127,260 62,160 24,109 0 119,846 135,676 50,829 114,261 1,462,642 Department of Transportation 30,954,547 3,650,341 22,007 17,887 44,225 144,261 27,527,463 11,979,597 16,771,057 91,111,385 Department of the State Treasurer 3,846,394 0 0 1,019 0 0 256,677 4,017,648 590,113 8,711,851 Employment Security Commission 8,956,746 806,407 366,832 14,921 0 824,573 3,091,943 2,180,097 2,716,155 18,957,674 NC Housing Finance Authority 593,879 0 0 0 0 0 12,563 1,132,118 52,655 1,791,215 NC School Science & Math 363,763 171,254 4,999 0 0 1,867 58,674 25,841 37,040 663,438 NC Wildlife Resources 1,424,078 306,767 267,552 239,337 927 46,264 333,513 1,731,011 848,971 5,198,420 Office of Administrative Hearings 65,734 56,135 0 (117) 0 9,093 5,194 0 44,703 180,742 Office of the Governor 894,018 64,420 13,905 504 0 60,802 173,329 62,987 115,405 1,385,370 Office of the Lieutenant Governor 0 0 12,002 0 0 1,759 3,675 4,368 14,695 36,499 Office of the State Auditor 585,654 123,025 8,083 0 0 65,945 111,482 109,707 63,515 1,067,411 Office of the State Controller 4,278,432 262,567 612,310 6,387 196 3,867,920 2,223,594 12,101,357 215,958 23,568,721 State Board of Elections 1,960,914 62,972 40,581 11,191 0 45,987 29,855 39,206 217,485 2,408,191 TOTAL w/out UNC System, Lottery, AOC & ITS 150,823,464 22,801,808 19,949,407 5,027,322 2,293,389 18,932,649 76,106,368 174,524,221 73,175,421 543,634,049 Administrative Office of the Courts 18,404,367 6,049,803 30,718 433,916 (19,554) 58,158 4,743,680 3,711,041 8,579,095 41,991,224 NC Education Lottery 1,795,010 178,067 92,235 114,653 0 69,088 6,395 69,090 612,258 2,936,796 UNC System 205,167,247 37,650,174 12,322,819 4,574,309 4,243,705 28,739,858 20,945,549 63,007,938 52,329,752 428,981,351 Total Without ITS 376,190,087 66,679,852 32,395,179 10,150,200 6,517,540 47,799,753 101,801,992 241,312,290 134,696,526 1,017,543,419 Office of Information Technology Services 37,494,460 924,947 2,636,937 5,230,655 2,037,059 23,795,475 24,667,543 9,756,408 49,156,361 155,699,845 Note: PMIS Budgeted salary amounts plus calculated fringe benefit cost amounts are used to represent total salary cost, which means that the cost is overstated by the amount of lapsed salaries generated by vacant IT positions. The overstatement could be as much as $49.8 million. Table 1-1 Information Technology Expenditures for Year Ended June 30, 2007 Page 6 INTERNAL PERSONNEL COSTS EXTERNAL PERSONNEL COSTS OTHER EXTERNAL COSTS HARDWARE COSTS SOFTWARE COSTS OTHER COSTS YTD TOTALS Comprehensive Major Medical Plan 146,744 40 140,040 122,352 42,994 0 452,170 Community Colleges System Office 5,328,240 12,538,248 386,496 192,054 3,253,071 7,741 21,705,850 Department of Administration 1,555,235 500,444 2,301,957 235,610 175,318 49,464 4,818,028 Department of Agriculture & Consumer Services 2,521,447 61,987 1,077,190 977,907 242,657 36,290 4,917,478 Department of Commerce 3,113,972 1,929,354 1,345,114 637,185 815,336 97,527 7,938,488 Department of Correction 9,127,850 81,121 12,486,074 3,461,890 1,272,403 237,166 26,666,504 Department of Crime Control & Public Safety 4,497,230 21,985,641 2,534,150 19,281,903 1,273,953 52,961 49,625,838 Department of Cultural Resources 1,056,958 229,001 762,895 430,369 77,406 2,896 2,559,525 Department of Environment & Natural Resources 9,982,223 2,384,336 4,087,054 2,483,932 1,738,374 250,551 20,926,470 Department of Health and Human Services 29,405,385 91,631,239 35,328,696 6,142,819 3,386,280 1,783,738 167,678,157 Department of Insurance 1,603,208 17,083 437,782 473,951 244,952 108,502 2,885,478 Department of Justice 5,499,219 572,986 2,780,232 1,727,082 1,641,343 360,995 12,581,857 Department of Juvenile Justice & Delinquency Prevention 2,230,189 120,418 1,202,283 845,200 171,575 180,579 4,750,244 Department of Labor 723,466 55,860 491,927 177,406 31,474 3,882 1,484,015 Department of Public Instruction 11,013,156 7,332,336 7,478,266 2,630,630 4,343,703 181,857 32,979,948 Department of Revenue 8,266,285 3,218,385 9,362,242 2,894,548 1,151,525 227,458 25,120,443 Department of Secretary of State 828,501 37,504 131,967 250,104 214,566 0 1,462,642 Department of Transportation 30,954,547 10,302,200 43,474,641 5,280,962 1,099,035 0 91,111,385 Department of the State Treasurer 3,846,394 1,696,110 844,717 955,412 1,323,964 45,254 8,711,851 Employment Security Commission 8,956,746 1,869,591 5,358,605 1,575,402 1,197,330 0 18,957,674 NC Housing Finance Authority 593,879 841,007 65,218 240,137 25,254 25,720 1,791,215 NC School Science & Math 363,763 0 95,714 177,133 26,828 0 663,438 NC Wildlife Resources 1,424,078 1,390,203 1,321,969 560,985 436,140 65,045 5,198,420 Office of Administrative Hearings 65,734 0 49,780 37,652 27,576 0 180,742 Office of the Governor 894,018 1,790 308,685 53,647 106,308 20,922 1,385,370 Office of the Lieutenant Governor 0 5,488 27,917 1,044 0 2,050 36,499 Office of the State Auditor 585,654 0 182,391 162,056 137,310 0 1,067,411 Office of the State Controller 4,278,432 12,338,944 2,549,406 1,078,169 3,295,182 28,588 23,568,721 State Board of Elections 1,960,914 52,553 269,380 100,360 23,242 1,742 2,408,191 TOTAL w/out UNC System, Lottery, AOC & ITS 150,823,464 171,193,869 136,882,788 53,187,901 27,775,099 3,770,928 543,634,049 Administrative Office of the Courts 18,404,367 2,219,711 4,375,569 9,691,228 7,229,203 71,146 41,991,224 NC Education Lottery 1,795,010 31,626 768,897 259,284 38,572 43,407 2,936,796 UNC System 205,167,247 6,994,834 70,531,069 83,898,068 45,601,088 16,789,045 428,981,351 Total Without ITS 376,190,087 180,440,040 212,558,323 147,036,481 80,643,962 20,674,526 1,017,543,419 Office of Information Technology Services 37,494,460 4,897,200 55,907,331 21,461,566 35,397,434 541,854 155,699,845 * Report revised 10/31/07 Note: PMIS Budgeted salary amounts plus calculated fringe benefit cost amounts are used to represent total salary cost, which means that the cost is overstated by the amount of lapsed salaries generated by vacant IT positions. The overstatement could be $49.8 million. Table 1-2 Information Technology Expenditures Grouped According to IT Portfolio Management System Detail Cost Categories* for Year Ended June 30, 2007 PMIS BUDGETED SALARY PLUS FRINGES PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Appalachian State University 7,951,315 0 0 52,458 18,672 0 25,270 6,238,811 1,235,524 15,522,050 East Carolina University 19,134,749 4,121,674 1,969,327 194,447 162,938 3,636,260 1,548,935 6,470,179 2,557,312 39,795,821 Elizabeth City State University 1,751,377 172,019 151,175 80,803 27,614 37,432 46,071 1,233,474 417,604 3,917,569 Fayetteville State University 2,232,406 532,487 224,743 182,421 1,440 250,337 61,890 951,082 685,672 5,122,478 NC A&T State University 4,562,812 101,164 3,084,846 76,954 104,595 981,077 69,638 2,535,574 1,066,828 12,583,488 NC Central University 3,741,857 0 0 745,558 69,645 0 20,199 4,232,460 1,268,491 10,078,210 NC School of Arts 894,024 845,371 5,604 1,018 0 94,055 57,673 148,169 396,680 2,442,594 NC State University 36,048,417 10,408,365 1,890,994 489,918 2,646,761 9,790,750 2,017,148 6,024,306 11,523,567 80,840,226 UNC Asheville 2,071,318 1,201,495 113,741 26,767 23,334 230,415 40,713 191,793 392,060 4,291,636 UNC Chapel Hill 72,390,434 -41,159 139,703 964,388 249,259 155,262 5,675,892 17,214,399 14,839,455 111,587,633 UNC Charlotte 12,880,910 5,460,786 1,632,296 224,731 251,720 2,839,217 98,482 4,091,813 3,444,435 30,924,390 UNC General Administration 4,260,363 848,501 122,886 1,114,929 14,483 225,082 9,344,258 590,525 718,130 17,239,157 UNC Greensboro 11,956,939 5,020,612 349,979 53,871 217,260 1,314,993 112,803 5,040,214 5,217,982 29,284,653 UNC Hospital 8,046,536 327,366 350,130 6,725 1,470 4,990,113 1,182,809 1,305,299 3,570,144 19,780,592 UNC Pembroke 2,334,861 1,535,823 48,075 17,606 0 727,163 102,847 1,686,121 575,250 7,027,746 UNC Wilmington 7,185,424 1,781,422 432,853 84,504 226,113 1,826,341 28,559 1,584,662 2,210,482 15,360,360 Western Carolina University 4,735,882 2,109,835 1,712,177 36,330 152,906 716,175 422,176 1,256,563 652,732 11,794,776 Winston-Salem State University 2,987,622 3,224,413 94,290 220,881 75,495 925,186 90,186 2,212,494 1,557,404 11,387,971 TOTAL UNC System 205,167,247 37,650,174 12,322,819 4,574,309 4,243,705 28,739,858 20,945,549 63,007,938 52,329,752 428,981,351 Table 1-3 Information Technology Expenditures UNC System Agencies for Year Ended June 30, 2007 Page 7 Page 8 Total IT Expenditures Total Expenditures % IT Expenditures to Total Expenditures Comprehensive Major Medical Plan 452,170 2,322,108,958 0.02% Community Colleges System Office 21,705,850 1,179,183,787 1.84% Department of Administration 4,818,028 207,194,190 2.33% Department of Agriculture & Consumer Services 4,917,478 118,871,098 4.14% Department of Commerce 7,938,488 329,555,623 2.41% Department of Correction 26,666,504 1,386,840,661 1.92% Department of Crime Control & Public Safety 49,625,838 440,730,410 11.26% Department of Cultural Resources 2,559,525 102,842,375 2.49% Department of Environment & Natural Resources 20,926,470 828,527,995 2.53% Department of Health and Human Services 167,678,157 15,184,014,120 1.10% Department of Insurance 2,885,478 92,598,277 3.12% Department of Justice 12,581,857 137,531,456 9.15% Department of Juvenile Justice & Delinquency Prevention 4,750,244 158,532,627 3.00% Department of Labor 1,484,015 27,698,998 5.36% Department of Public Instruction 32,979,948 9,043,165,880 0.36% Department of Revenue 25,120,443 3,181,388,679 0.79% Department of Secretary of State 1,462,642 11,330,915 12.91% Department of Transportation 91,111,385 3,686,087,640 2.47% Department of the State Treasurer 8,711,851 10,103,743,798 0.09% Employment Security Commission 18,957,674 1,090,853,536 1.74% NC Housing Finance Authority 1,791,215 59,881,643 2.99% NC School Science & Math 663,438 18,915,641 3.51% NC Wildlife Resources 5,198,420 132,013,055 3.94% Office of Administrative Hearings 180,742 3,135,891 5.76% Office of the Governor 1,385,370 140,287,769 0.99% Office of the Lieutenant Governor 36,499 869,277 4.20% Office of the State Auditor 1,067,411 16,286,908 6.55% Office of the State Controller 23,568,721 30,918,423 76.23% State Board of Elections 2,408,191 17,630,475 13.66% TOTAL w/out UNC System, Lottery, AOC & ITS 543,634,049 50,052,740,103 1.09% Administrative Office of the Courts 41,991,224 514,167,246 8.17% NC Education Lottery 2,936,796 558,611,172 0.20% UNC System 428,981,351 9,297,364,811 4.61% Total Without ITS 1,017,543,419 60,422,883,333 1.68% Office of Information Technology Services 155,699,845 179,179,661 86.90% Table 1-4 Percentage of IT Expenditures to Total Expenditures for Year Ended June 30, 2007 Note: Total Expenditures does not include Intragovernmental Transfers except Reimbursement Accounts beginning with 5382 and 5383. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 9 Expenditure Summary by Budget Code Type While Table 1-1 shows all IT expenditures for fiscal year 2007, a further analysis can be performed. The expenditures in Table 1-1 (excluding the Office of Information Technology Services) can be broken down by budget code as follows: IT Expenditures Percentage of Total General Fund Budget Codes $674,600,380 66.30% All Other Budget Codes $342,943,039 33.70% Total of all Budget Codes $1,017,543,419 100.00% Based on budget codes, 66.30% of the IT expenditures listed in Table 1-1 were incurred in General Fund Budget Codes. All other Budget Codes total 33.70% of all IT expenditures. Greater detail on these numbers is contained in the following schedules: − Table 2-1 Information Technology Expenditures for General Fund Budget Codes contains IT expenditures, by agency for all Budget Codes contained in the General Fund. − Table 2-2 Information Technology Expenditures for All Other Budget Codes contains IT expenditures, by agency for all Non-General Fund Budget Codes. PMIS BUDGETED SALARY PLUS FRINGES PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Comprehensive Major Medical Plan 0 0 0 0 0 0 0 0 0 0 Community Colleges System Office 5,328,240 105,884 98,436 242 4,781 3,290,746 278,419 12,521,143 77,959 21,705,850 Department of Administration 1,555,235 203,363 692,807 5,743 99,503 76,466 811,184 46,036 487,130 3,977,467 Department of Agriculture & Consumer Services 2,426,841 860,459 415 108,475 1,067 195,999 97,295 235,624 729,158 4,655,333 Department of Commerce 1,753,128 449,929 306,912 5,783 0 210,584 550,565 907,760 459,913 4,644,574 Department of Correction 8,423,449 1,831,525 187,774 1,235 386 436,683 8,460,142 758,871 4,674,233 24,774,298 Department of Crime Control & Public Safety 755,992 561,099 14,999 1,262 0 18,466 220,843 11,058,312 969,495 13,600,468 Department of Cultural Resources 1,056,958 484,251 2,437 0 0 22,907 195,005 253,549 520,732 2,535,839 Department of Environment & Natural Resources 7,901,683 1,891,173 76,872 225,383 17,972 773,387 695,814 2,107,673 3,212,222 16,902,179 Department of Health and Human Services 27,990,664 4,313,390 14,198,383 566,076 5,159 2,912,482 21,150,414 82,332,290 11,493,799 164,962,657 Department of Insurance 1,603,208 162,156 26,257 54,826 0 466,689 47,662 115,902 357,204 2,833,904 Department of Justice 5,499,219 0 5,400 172,231 0 0 312,841 3,348,602 2,254,602 11,592,895 Department of Juvenile Justice & Delinquency Prevention 2,230,189 573,491 5,425 52,558 0 201,959 97,244 352,223 1,203,267 4,716,356 Department of Labor 723,466 103,924 60,850 30,954 0 17,394 45,152 89,827 317,527 1,389,094 Department of Public Instruction 11,013,156 1,111,142 1,735,489 2,958,124 1,848,011 2,170,569 1,439,081 7,696,974 2,998,560 32,971,106 Department of Revenue 8,266,285 1,087,437 360,526 60,462 6,835 1,422,909 6,865,459 3,903,398 2,698,938 24,672,249 Department of Secretary of State 828,501 127,260 62,160 24,109 0 119,846 114,452 50,829 114,261 1,441,418 Department of Transportation 0 0 0 0 0 0 0 0 0 0 Department of the State Treasurer 3,846,394 0 0 372 0 0 256,677 3,736,243 563,551 8,403,237 Employment Security Commission 0 0 0 0 0 0 0 0 0 0 NC Housing Finance Authority 0 0 0 0 0 0 0 0 0 0 NC School Science & Math 363,763 169,955 4,999 0 0 1,867 58,674 25,841 37,040 662,139 NC Wildlife Resources 0 0 0 0 0 0 0 0 0 0 Office of Administrative Hearings 65,734 56,135 0 (117) 0 9,093 5,194 0 44,703 180,742 Office of the Governor 894,018 59,684 13,905 230 0 60,565 173,329 61,197 113,506 1,376,434 Office of the Lieutenant Governor 0 0 12,002 0 0 1,759 3,675 4,368 14,695 36,499 Office of the State Auditor 585,654 123,025 8,083 0 0 65,945 111,482 109,707 63,515 1,067,411 Office of the State Controller 4,278,432 196,002 584,135 6,387 196 2,415,299 2,075,778 277,293 204,511 10,038,033 State Board of Elections 1,960,914 62,972 40,581 11,191 0 45,987 29,855 39,206 217,485 2,408,191 TOTAL w/out UNC System, Lottery, AOC & ITS 99,351,122 14,534,256 18,498,847 4,285,526 1,983,910 14,937,601 44,096,236 130,032,868 33,828,006 361,548,372 Administrative Office of the Courts 14,754,020 5,108,097 5,650 422,789 94 132,706 4,734,442 3,066,232 8,550,635 36,774,665 NC Education Lottery 0 0 0 0 0 0 0 0 0 0 UNC System 136,518,467 30,563,441 8,127,421 2,807,613 2,976,151 20,508,652 13,084,098 40,342,447 21,349,053 276,277,343 Total Without ITS 250,623,609 50,205,794 26,631,918 7,515,928 4,960,155 35,578,959 61,914,776 173,441,547 63,727,694 674,600,380 Office of Information Technology Services 0 0 0 0 0 0 0 0 0 0 Table 2-1 Information Technology Expenditures for General Fund Budget Codes for Year Ended June 30, 2007 Page 10 PMIS BUDGETED SALARY PLUS FRINGES PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Comprehensive Major Medical Plan 146,744 159,999 28,199 0 0 1,358 24,355 0 91,515 452,170 Community C olleges System Office 0 0 0 0 0 0 0 0 0 0 Department of Administration 0 16,728 158,930 4,222 35,630 10,600 50,181 408,913 155,357 840,561 Department of Agriculture & Consumer Services 94,605 10,546 0 154 (35) 232 9,131 12,186 135,325 262,144 Department of Commerce 1,360,844 259,128 18,171 14,537 315 231,412 20,114 1,087,397 301,996 3,293,914 Department of Correction 704,400 404,055 44,844 10,644 156,387 (1,330) 0 379,242 193,963 1,892,205 Department of Crime Control & Public Safety 3,741,239 2,131,999 56,055 383,876 71,960 1,123,730 130,756 11,355,585 17,030,171 36,025,371 Department of Cultural Resources 0 1,872 210 0 0 783 3,867 0 16,954 23,686 Department of Environment & Natural Resources 2,080,540 301,119 25,944 26,896 70 159,477 97,387 979,446 353,412 4,024,291 Department of Health and Human Services 1,414,720 74,977 433,641 0 0 0 2,394 293,602 496,165 2,715,499 Department of Insurance 0 25,492 0 3,985 0 830 0 10,930 10,337 51,574 Department of Justice 0 2,736 0 1,929 0 0 89,231 824,148 70,918 988,962 Department of Juvenile Justice & Delinquency Prevention 0 25,998 0 0 0 0 0 5,153 2,737 33,888 Department of Labor 0 16,350 0 21,654 0 0 0 2,661 54,256 94,921 Department of Public Instruction 0 438 0 833 0 0 0 2,008 5,563 8,842 Department of Revenue 0 0 0 0 0 0 448,194 0 0 448,194 Department of Secretary of State 0 0 0 0 0 0 21,224 0 0 21,224 Department of Transportation 30,954,547 3,650,341 22,007 17,887 44,225 144,261 27,527,463 11,979,597 16,771,057 91,111,385 Department of the State Treasurer 0 0 0 647 0 0 0 281,405 26,562 308,614 Employment Security Commission 8,956,746 806,407 366,832 14,921 0 824,573 3,091,943 2,180,097 2,716,155 18,957,674 NC Housing Finance Authority 593,879 0 0 0 0 0 12,563 1,132,118 52,655 1,791,215 NC School Science & Math 0 1,299 0 0 0 0 0 0 0 1,299 NC Wildlife Resources 1,424,078 306,767 267,552 239,337 927 46,264 333,513 1,731,011 848,971 5,198,420 Office of Administrative Hearings 0 0 0 0 0 0 0 0 0 0 Office of the Governor 0 4,736 0 274 0 237 0 1,790 1,899 8,936 Office of the Lieutenant Governor 0 0 0 0 0 0 0 0 0 0 Office of the State Auditor 0 0 0 0 0 0 0 0 0 0 Office of the State Controller 0 66,565 28,175 0 0 1,452,621 147,816 11,824,064 11,447 13,530,688 State Board of Elections 0 0 0 0 0 0 0 0 0 0 TOTAL w/out UNC System, Lottery, AOC & ITS 51,472,342 8,267,552 1,450,560 741,796 309,479 3,995,048 32,010,132 44,491,353 39,347,415 182,085,677 Administrative Office of the Courts 3,650,347 941,706 25,068 11,127 (19,648) (74,548) 9,238 644,809 28,460 5,216,559 NC Education Lottery 1,795,010 178,067 92,235 114,653 0 69,088 6,395 69,090 612,258 2,936,796 UNC System 68,648,780 7,086,733 4,195,398 1,766,696 1,267,554 8,231,206 7,861,451 22,665,491 30,980,699 152,704,008 Total Without ITS 125,566,478 16,474,058 5,763,261 2,634,272 1,557,385 12,220,794 39,887,216 67,870,743 70,968,832 342,943,039 Office of Information Technology Services 37,494,460 924,947 2,636,937 5,230,655 2,037,059 23,795,475 24,667,543 9,756,408 49,156,361 155,699,845 Table 2-2 Information Technology Expenditures for All Other Budget Codes for Year Ended June 30, 2007 Page 11 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 12 Budget to Actual Comparison and Current vs. Prior Year Table 3-1 Information Technology Expenditures - Budget to Actual Comparison provides an indication of budget utilization for IT expenditures as of the end of the report period. A 100% utilization rate indicates that the agency spent their entire budget by fiscal year end. The total budget estimate is calculated using budgeted PMIS salary information and the authorized budget amounts as posted within NCAS for the non salary cost categories. Agency budgets are controlled at the certification level which is a more summarized level than the NCAS accounts within some IT expenditure categories. The State Budget Manual allows agencies flexibility to maintain their budgets at a different level than expenditures, and many agencies take advantage of this flexibility. This table does not include the UNC System agencies or the Department of Transportation. Department of Transportation does not provide budgetary data from their financial system at this time. UNC System agencies are allowed to post budgets at a highly summarized level; therefore, none of the budget can be identified within NCAS as related to IT cost categories. For the remaining agencies, the overall budget utilization percentage is 88.57% which is lower than the expected rate of 100%. This indicates that agencies, in total, continue to spend less than the budgeted amount. The Department of Correction and Department of the State Treasurer had expenditures in excess of 100% of budget. Table 3-2 Information Technology Expenditures – Current Year versus Prior Year provides a comparison to prior year expenditures. Total IT expenditures excluding the Office of Information Technology Services increased $75,425,881 and represent an 8.01% increase. Schematic class codes in the PMIS system were excluded from this year’s report which had previously been included. Therefore the year to year increase is slightly understated. Table 3-3 Information Technology Expenditures – Current Year versus Prior Year – UNC System Agencies provides a comparison to prior year expenditures for UNC System Agencies. In prior reports this information presented current expenditures as a percentage of prior year expenditures. The format has been changed to match that of Table 3-2. Expenditures are now reported as an increase or decrease of the prior year expenditures. Total expenditures for UNC System Agencies increased $34,471,851 and represent an 8.74% increase. PMIS ANNUAL BUDGETED SALARY AUTHORIZED BUDGET NON_SALARY ACCOUNTS TOTAL BUDGET ESTIMATE YTD ACTUAL ACTUAL as % of BUDGET Note 1 Comprehensive Major Medical Plan 146,744 404,800 551,544 452,170 81.98% Community Colleges System Office 5,328,240 16,880,099 22,208,339 21,705,850 97.74% Department of Administration 1,555,235 3,831,027 5,386,262 4,818,028 89.45% Department of Agriculture & Consumer Services 2,521,447 2,836,193 5,357,640 4,917,478 91.78% Department of Commerce 3,113,972 6,274,069 9,388,041 7,938,488 84.56% Department of Correction 9,127,850 17,368,354 26,496,204 26,666,504 100.64% Department of Crime Control & Public Safety 4,497,230 76,776,141 81,273,371 49,625,838 61.06% Department of Cultural Resources 1,056,958 1,633,736 2,690,694 2,559,525 95.13% Department of Environment & Natural Resources 9,982,223 14,733,706 24,715,929 20,926,470 84.67% Department of Health and Human Services 29,405,385 157,033,743 186,439,128 167,678,157 89.94% Department of Insurance 1,603,208 1,506,511 3,109,719 2,885,478 92.79% Department of Justice 5,499,219 8,321,501 13,820,720 12,581,857 91.04% Department of Juvenile Justice & Delinquency Prevention 2,230,189 2,822,009 5,052,198 4,750,244 94.02% Department of Labor 723,466 779,343 1,502,809 1,484,015 98.75% Department of Public Instruction 11,013,156 24,083,443 35,096,599 32,979,948 93.97% Department of Revenue 8,266,285 16,987,312 25,253,597 25,120,443 99.47% Department of Secretary of State 828,501 667,413 1,495,914 1,462,642 97.78% Department of the State Treasurer 3,846,394 4,840,782 8,687,176 8,711,851 100.28% Employment Security Commission 8,956,746 10,468,307 19,425,053 18,957,674 97.59% NC Housing Finance Authority 593,879 1,213,497 1,807,376 1,791,215 99.11% NC School Science & Math 363,763 355,327 719,090 663,438 92.26% NC Wildlife Resources 1,424,078 3,951,984 5,376,062 5,198,420 96.70% Office of Administrative Hearings 65,734 117,005 182,739 180,742 98.91% Office of the Governor 894,018 517,707 1,411,725 1,385,370 98.13% Office of the Lieutenant Governor 0 37,244 37,244 36,499 98.00% Office of the State Auditor 585,654 508,175 1,093,829 1,067,411 97.58% Office of the State Controller 4,278,432 19,316,939 23,595,371 23,568,721 99.89% State Board of Elections 1,960,914 984,663 2,945,577 2,408,191 81.76% TOTAL without DOT, AOC, Lottery & ITS 119,868,917 395,251,030 515,119,947 452,522,664 87.85% Administrative Office of the Courts 18,404,367 24,601,321 43,005,688 41,991,224 97.64% NC Education Lottery 1,795,010 1,757,136 3,552,146 2,936,796 82.68% Total Without DOT & ITS 140,068,293 421,609,487 561,677,780 497,450,683 88.57% Office of Information Technology Services 37,494,460 143,469,962 180,964,422 155,699,845 86.04% Table 3-1 Information Technology Expenditures - Budget to Actual Comparison for Year Ended June 30, 2007 Note 1: The State Budget Manual allows agencies some flexibility to maintain their budget at a different level than they post expenditures. Page 13 Page 14 Current Expenditures at 06/30/07 Total Expenditures at 06/30/06 Increase / (Decrease) % Change Comprehensive Major Medical Plan 452,170 244,038 208,131 85.29% Community Colleges System Office 21,705,850 17,797,261 3,908,589 21.96% Department of Administration 4,818,028 5,891,932 (1,073,905) -18.23% Department of Agriculture & Consumer Services 4,917,478 4,912,594 4,883 0.10% Department of Commerce 7,938,488 6,455,090 1,483,398 22.98% Department of Correction 26,666,504 29,946,890 (3,280,387) -10.95% Department of Crime Control & Public Safety 49,625,838 26,855,815 22,770,023 84.79% Department of Cultural Resources 2,559,525 2,556,898 2,627 0.10% Department of Environment & Natural Resources 20,926,470 20,283,419 643,051 3.17% Department of Health and Human Services 167,678,157 171,564,109 (3,885,952) -2.27% Department of Insurance 2,885,478 3,033,293 (147,816) -4.87% Department of Justice 12,581,857 14,740,824 (2,158,967) -14.65% Department of Juvenile Justice & Delinquency Prevention 4,750,244 5,222,653 (472,410) -9.05% Department of Labor 1,484,015 1,644,175 (160,160) -9.74% Department of Public Instruction 32,979,948 32,308,951 670,997 2.08% Department of Revenue 25,120,443 24,028,435 1,092,008 4.54% Department of Secretary of State 1,462,642 1,268,498 194,144 15.31% Department of the State Treasurer 8,711,851 8,886,162 (174,311) -1.96% Department of Transportation 91,111,385 89,859,797 1,251,588 1.39% Employment Security Commission 18,957,674 18,427,513 530,161 2.88% NC Housing Finance Authority 1,791,215 1,117,471 673,744 60.29% NC School Science & Math 663,438 591,314 72,124 12.20% NC Wildlife Resources 5,198,420 5,609,063 (410,644) -7.32% Office of Administrative Hearings 180,742 161,952 18,790 11.60% Office of the Governor 1,385,370 1,179,011 206,359 17.50% Office of the Lieutenant Governor 36,499 36,387 112 0.31% Office of the State Auditor 1,067,411 943,445 123,966 13.14% Office of the State Controller 23,568,721 18,717,495 4,851,227 25.92% State Board of Elections 2,408,191 2,288,502 119,689 5.23% TOTAL w/out UNC System, Lottery, AOC & ITS 543,634,049 516,572,987 27,061,062 5.24% Administrative Office of the Courts 41,991,224 29,747,295 12,243,928 41.16% NC Education Lottery 2,936,796 1,287,756 1,649,040 128.06% UNC System 428,981,351 394,509,500 34,471,851 8.74% Total Without ITS 1,017,543,419 942,117,538 75,425,881 8.01% Office of Information Technology Services 155,699,845 130,637,429 25,062,415 19.18% Table 3-2 Information Technology Expenditures - Current Year Versus Prior Year for Year Ended June 30, 2007 Note: A difference of approximately $1.3 million in total 2006 expenditures is due to the omission of the NC Education Lottery and workshop related IT expenditures from some agencies on the 2006 published report. These are included here for comparison purposes. NC Education Lottery PMIS data is not available for 2006. Current Expenditures at 06/30/07 Total Expenditures at 06/30/06 Increase / (Decrease) % Change Appalachian State University 15,522,050 16,316,020 (793,971) -4.87% East Carolina University 39,795,821 37,499,927 2,295,894 6.12% Elizabeth City State University 3,917,569 4,330,687 (413,118) -9.54% Fayetteville State University 5,122,478 4,731,123 391,356 8.27% NC A&T State University 12,583,488 11,655,758 927,730 7.96% NC Central University 10,078,210 9,636,510 441,700 4.58% NC School of Arts 2,442,594 2,175,881 266,713 12.26% NC State University 80,840,226 77,777,388 3,062,839 3.94% UNC Asheville 4,291,636 3,779,164 512,472 13.56% UNC Chapel Hill 111,587,633 107,186,500 4,401,133 4.11% UNC Charlotte 30,924,390 25,696,183 5,228,206 20.35% UNC General Administration 17,239,157 15,288,098 1,951,059 12.76% UNC Greensboro 29,284,653 23,066,302 6,218,350 26.96% UNC Hospital 19,780,592 19,061,895 718,697 3.77% UNC Pembroke 7,027,746 5,235,385 1,792,362 34.24% UNC Wilmington 15,360,360 12,099,373 3,260,987 26.95% Western Carolina University 11,794,776 10,615,814 1,178,962 11.11% Winston-Salem State University 11,387,971 8,357,494 3,030,477 36.26% TOTAL UNC Systems 428,981,351 394,509,500 34,471,851 8.74% Table 3-3 Information Technology Expenditures - Current Year Versus Prior Year for Year Ended June 30, 2007 UNC System Agencies Page 15 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 16 IT Related Contracted Personal Services Table 4-1 Information Technology Related Contracted Personal Services provides a breakdown of contracted personal services by the type of system on which the contracted services were utilized. Table 4-2 Information Technology Related Contracted Personal Services- UNC System Agencies provides a breakdown of contracted personal services by the type of system on which the contracted services were utilized. Page 17 PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Comprehensive Major Medical Plan 0 40 0 0 0 0 0 0 40 Community Colleges System Office 0 70,977 0 0 0 0 12,467,271 0 12,538,248 Department of Administration 1,888 181,983 0 0 0 0 316,573 0 500,444 Department of Agriculture & Consumer Services 0 0 0 0 3,863 0 58,124 0 61,987 Department of Commerce 0 308,461 0 0 0 0 1,620,893 0 1,929,354 Department of Correction 0 0 0 0 0 0 81,121 0 81,121 Department of Crime Control & Public Safety 0 38,086 1,200 0 646,908 108,650 21,190,797 0 21,985,641 Department of Cultural Resources 315 0 0 0 0 0 228,686 0 229,001 Department of Environment & Natural Resources 0 8,146 0 0 20,000 0 2,356,190 0 2,384,336 Department of Health and Human Services 0 11,824,724 14,534 0 0 0 79,791,981 0 91,631,239 Department of Insurance 0 7,189 0 0 0 0 9,894 0 17,083 Department of Justice 0 0 0 0 0 0 572,986 0 572,986 Department of Juvenile Justice & Delinquency Prevention 0 0 0 0 0 0 120,418 0 120,418 Department of Labor 0 55,860 0 0 0 0 0 0 55,860 Department of Public Instruction 2,310 17,032 0 0 646,665 0 6,666,329 0 7,332,336 Department of Revenue 433 0 0 0 0 0 3,217,952 0 3,218,385 Department of Secretary of State 0 37,504 0 0 0 0 0 0 37,504 Department of Transportation 0 0 0 295 0 0 10,301,905 0 10,302,200 Department of the State Treasurer 0 0 0 0 0 0 1,696,110 0 1,696,110 Employment Security Commission 0 0 0 0 4,320 0 1,865,271 0 1,869,591 NC Housing Finance Authority 0 0 0 0 0 0 841,007 0 841,007 NC School Science & Math 0 0 0 0 0 0 0 0 0 NC Wildlife Resources 0 21,200 130,494 0 0 0 1,238,509 0 1,390,203 Office of Administrative Hearings 0 0 0 0 0 0 0 0 0 Office of the Governor 0 0 0 0 0 0 1,790 0 1,790 Office of the Lieutenant Governor 0 3,170 0 0 0 0 2,318 0 5,488 Office of the State Auditor 0 0 0 0 0 0 0 0 0 Office of the State Controller 0 266,175 0 0 0 0 12,072,769 0 12,338,944 State Board of Elections 0 39,800 0 0 0 0 12,753 0 52,553 TOTAL w/out UNC System, Lottery, AOC & ITS 4,946 12,880,347 146,228 295 1,321,756 108,650 156,731,647 0 171,193,869 Administrative Office of the Courts 113,261 0 0 0 0 0 2,106,450 0 2,219,711 NC Education Lottery 0 0 21,263 0 2,073 0 8,290 0 31,626 UNC System 36,465 31,459 36,020 15,422 384,640 9,772 6,481,056 0 6,994,834 Total Without ITS 154,672 12,911,806 203,511 15,717 1,708,469 118,422 165,327,443 0 180,440,040 Office of Information Technology Services 0 222,402 0 0 44,973 0 4,629,825 0 4,897,200 Table 4-1 Information Technology Related Contracted Personal Services for Year Ended June 30, 2007 Page 18 PERSONAL COMPUTER AND PRINTER LOCAL AREA NETWORK WIDE AREA NETWORK VIDEO TRANS-MISSION SERVER MAINFRAME APPLICA-TIONS DEVELOP AND OTHER TELECOMM YTD TOTALS Appalachian State University 0 0 6,000 0 0 0 0 0 6,000 East Carolina University 879 1,559 0 375 4,267 5,220 10,460 0 22,760 Elizabeth City State University 0 0 0 0 650 7 7,500 0 8,157 Fayetteville State University 0 0 0 0 0 0 0 0 0 NC A&T State University 0 0 0 0 1,671 0 0 0 1,671 NC Central University 0 0 0 0 0 0 130,353 0 130,353 NC School of Arts 0 0 0 0 0 0 0 0 0 NC State University 17,813 6,705 16,555 3,855 44,490 0 1,599,064 0 1,688,482 UNC Asheville 0 0 0 0 7,500 0 28,640 0 36,140 UNC Chapel Hill 0 0 13,415 1,200 0 0 1,682,943 0 1,697,558 UNC Charlotte 115 0 0 8,791 0 0 283,889 0 292,795 UNC General Administration 125 10,125 0 0 0 0 169,162 0 179,412 UNC Greensboro 5,310 0 50 206 19,288 2,545 18,235 0 45,634 UNC Hospital 0 6,400 0 0 286,426 1,200 987,105 0 1,281,131 UNC Pembroke 0 0 0 0 0 0 256,988 0 256,988 UNC Wilmington 0 0 0 0 9,956 0 3,000 0 12,956 Western Carolina University 12,223 6,670 0 0 3,900 800 1,595 0 25,188 Winston-Salem State University 0 0 0 995 6,492 0 1,302,122 0 1,309,609 TOTALS 36,465 31,459 36,020 15,422 384,640 9,772 6,481,056 0 6,994,834 Table 4-2 Information Technology Related Contracted Personal Services UNC System Agencies for Year Ended June 30, 2007 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 19 Salary and Fringe Benefit Calculations Table 5-1 Salary and Calculated Fringes for All IT Positions lists by agency, the total full-time equivalents (FTEs) for permanent, full-time and part-time IT positions and the current annual budgeted salary amount for these positions as of the end of the report period. Data for these tables come from PMIS and include both vacant and filled IT positions. A position is identified as IT related based on the position's PMIS class code. Table 5-2 Salary and Calculated Fringes for All IT Positions (UNC System Agencies) lists the same information described above but for universities. UNC System agencies which operate their own payroll systems are not required to enter EPA position information into PMIS, however this data has been provided and is incorporated into this report. Fringe benefit amounts are not maintained within PMIS and are calculated in these tables based on the following criteria: • OASDI – 6.2% of budgeted salary amount capped at $97,500 per FTE • HI – 1.45% of budgeted salary amount • Retirement – 7.14% of budgeted salary amount • Hospitalization – $3,795.96 per FTE (calculated as an average of the PPO cost and the Indemnity plan cost per FTE) Other fringe benefit costs such as longevity or overtime pay cannot be readily estimated and are not included. This report assumes that salary and fringe benefits calculated in Table 5-1 and Table 5-2 are paid evenly throughout the year. Page 20 TOTAL FTE'S ANNUAL BUDGETED SALARY OASDI HI RETIRE HOSPITAL TOTAL AVERAGE PER FTE Comprehensive Major Medical Plan 2.00 121,223 7,516 1,758 8,655 7,592 146,744 73,372 Community Colleges System Office 71.00 4,407,739 272,363 63,912 314,713 269,513 5,328,240 75,046 Department of Administration 22.00 1,282,101 79,490 18,590 91,542 83,511 1,555,235 70,692 Department of Agriculture & Consumer Services 38.75 2,068,432 128,243 29,992 147,686 147,093 2,521,447 65,070 Department of Commerce 41.00 2,578,303 158,558 37,385 184,091 155,634 3,113,972 75,951 Department of Correction 131.00 7,520,161 464,436 109,042 536,940 497,271 9,127,850 69,678 Department of Crime Control & Public Safety 63.00 3,709,584 229,847 53,789 264,864 239,145 4,497,230 71,385 Department of Cultural Resources 16.75 865,385 53,654 12,548 61,789 63,582 1,056,958 63,102 Department of Environment & Natural Resources 147.00 8,211,257 507,612 119,063 586,284 558,006 9,982,223 67,906 Department of Health and Human Services 402.00 24,290,782 1,502,048 352,216 1,734,362 1,525,976 29,405,385 73,148 Department of Insurance 19.05 1,333,648 82,686 19,338 95,222 72,313 1,603,208 84,158 Department of Justice 77.00 4,536,538 280,703 65,780 323,909 292,289 5,499,219 71,418 Department of Juvenile Justice & Delinquency Prevention 29.00 1,846,943 114,510 26,781 131,872 110,083 2,230,189 76,903 Department of Labor 11.00 593,876 36,820 8,611 42,403 41,756 723,466 65,770 Department of Public Instruction 134.75 9,152,926 562,488 132,717 653,519 511,506 11,013,156 81,730 Department of Revenue 105.25 6,855,771 422,078 99,409 489,502 399,525 8,266,285 78,540 Department of Secretary of State 11.00 685,503 42,358 9,940 48,945 41,756 828,501 75,318 Department of Transportation 390.00 25,680,056 1,588,149 372,361 1,833,556 1,480,424 30,954,547 79,371 Department of the State Treasurer 45.00 3,203,476 196,921 46,450 228,728 170,818 3,846,394 85,475 Employment Security Commission 106.00 7,455,702 458,228 108,108 532,337 402,372 8,956,746 84,498 NC Housing Finance Authority 7.00 494,213 30,641 7,166 35,287 26,572 593,879 84,840 NC School Science & Math 6.00 297,053 18,417 4,307 21,210 22,776 363,763 60,627 NC Wildlife Resources 19.00 1,177,891 72,883 17,079 84,101 72,123 1,424,078 74,951 Office of Administrative Hearings 1.00 53,958 3,345 782 3,853 3,796 65,734 65,734 Office of the Governor 10.00 746,001 45,976 10,817 53,264 37,960 894,018 89,402 Office of the Lieutenant Governor 0.00 0 0 0 0 0 0 0 Office of the State Auditor 7.00 487,401 29,813 7,067 34,800 26,572 585,654 83,665 Office of the State Controller 49.00 3,566,155 219,942 51,709 254,623 186,002 4,278,432 87,315 State Board of Elections 30.00 1,609,056 99,761 23,331 114,887 113,879 1,960,914 65,364 TOTAL w/out UNC System, Lottery, AOC & ITS 1,991.55 124,831,134 7,709,490 1,810,052 8,912,943 7,559,844 150,823,464 75,732 Administrative Office of the Courts 217.75 15,320,757 940,986 222,151 1,093,902 826,570 18,404,367 84,521 NC Education Lottery 25.00 1,483,006 89,714 21,504 105,887 94,899 1,795,010 71,800 UNC System 3,017.03 168,737,661 10,413,878 2,458,280 12,104,903 11,452,525 205,167,247 68,003 Total Without ITS 5,251.33 310,372,558 19,154,069 4,511,986 22,217,635 19,933,839 376,190,087 71,637 Office of Information Technology Services 424.00 31,284,841 1,912,763 453,630 2,233,738 1,609,487 37,494,460 88,430 Table 5-1 Salary and Calculated Fringes for All IT Positions Annual Budgeted Salary as reported June 30, 2007 TOTAL FTE'S ANNUAL BUDGETED SALARY OASDI HI RETIRE HOSPITAL TOTAL AVERAGE PER FTE Appalachian State University 128.00 6,505,207 401,428 94,326 464,472 485,883 7,951,315 62,120 East Carolina University 303.00 15,661,247 970,494 228,359 1,124,472 1,150,176 19,134,749 63,151 Elizabeth City State University 30.00 1,426,516 88,444 20,685 101,853 113,879 1,751,377 58,379 Fayetteville State University 40.50 1,811,224 111,862 26,263 129,321 153,736 2,232,406 55,121 NC A&T State University 76.00 3,725,114 229,218 54,014 265,973 288,493 4,562,812 60,037 NC Central University 59.00 3,066,391 188,101 44,463 218,940 223,962 3,741,857 63,421 NC School of Arts 14.00 732,538 45,417 10,622 52,303 53,143 894,024 63,859 NC State University 482.97 29,808,946 1,840,879 433,018 2,132,239 1,833,335 36,048,417 74,639 UNC Asheville 35.65 1,686,701 104,403 24,457 120,430 135,326 2,071,318 58,101 UNC Chapel Hill 1,004.20 59,695,859 3,701,874 874,524 4,306,275 3,811,903 72,390,434 72,088 UNC Charlotte 181.80 10,625,069 651,667 154,296 759,772 690,106 12,880,910 70,852 UNC General Administration 57.00 3,530,809 209,888 51,197 252,100 216,370 4,260,363 74,743 UNC Greensboro 181.42 9,822,739 599,644 142,788 703,105 688,663 11,956,939 65,908 UNC Hospital 138.00 6,553,440 406,313 95,025 467,916 523,842 8,046,536 58,308 UNC Pembroke 43.00 1,891,833 117,294 27,432 135,077 163,226 2,334,861 54,299 UNC Wilmington 114.50 5,885,494 359,729 85,340 420,224 434,637 7,185,424 62,755 Western Carolina University 82.00 3,856,554 236,781 55,920 275,358 311,269 4,735,882 57,755 Winston-Salem State University 45.99 2,451,980 150,441 35,554 175,071 174,576 2,987,622 64,962 TOTAL 3,017.03 168,737,661 10,413,878 2,458,280 12,104,903 11,452,525 205,167,247 68,003 Note: Total FTE's includes EPA position data provided by UNC General Administration Table 5-2 Salary and Calculated Fringes for All IT Positions Annual Budgeted Salary - UNC System Agencies as reported June 30, 2007 Page 21 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 22 Salary Cost by Position Status Table 5-3 Total IT Salary and Fringe Amount by Position Status segregates the current annual budgeted salary and fringes amount by position status within an agency. The position status determines whether a position is filled or vacant at the end of the report period (June 30, 2007.) With approval, lapsed salary generated by a vacant position can be re-budgeted to another category. Table 5-4 Total IT Salary and Fringe Amount by Position Status (UNC System agencies) lists this same information by university. Salary Cost by Position Type Table 5-5 Salary and Calculated Fringes by Banding Category for all IT Positions lists salary information by IT band. The information in this table reflects the transition of position from salary grades to IT salary bands for those agencies required to transition to IT salary bands. Summarized data for salaries not transitioned to IT bands is included for comparison purposes with other tables (Administrative Office of the Courts, North Carolina Education Lottery and UNC System). FILLED POSITIONS VACANT POSITIONS TOTAL POSITIONS % VACANT OF TOTAL Comprehensive Major Medical Plan 146,744 0 146,744 0.00% Community Colleges System Office 4,595,542 732,699 5,328,240 13.75% Department of Administration 1,330,938 224,297 1,555,235 14.42% Department of Agriculture & Consumer Services 2,275,832 245,614 2,521,447 9.74% Department of Commerce 2,863,789 250,183 3,113,972 8.03% Department of Correction 8,292,589 835,261 9,127,850 9.15% Department of Crime Control & Public Safety 4,120,876 376,354 4,497,230 8.37% Department of Cultural Resources 1,003,532 53,425 1,056,958 5.05% Department of Environment & Natural Resources 8,472,043 1,510,180 9,982,223 15.13% Department of Health and Human Services 25,391,941 4,013,444 29,405,385 13.65% Department of Insurance 1,444,072 159,136 1,603,208 9.93% Department of Justice 4,857,567 641,652 5,499,219 11.67% Department of Juvenile Justice & Delinquency Prevention 2,128,161 102,028 2,230,189 4.57% Department of Labor 723,466 0 723,466 0.00% Department of Public Instruction 10,154,802 858,354 11,013,156 7.79% Department of Revenue 7,152,520 1,113,765 8,266,285 13.47% Department of Secretary of State 828,501 0 828,501 0.00% Department of Transportation 23,304,060 7,650,487 30,954,547 24.72% Department of the State Treasurer 3,721,816 124,578 3,846,394 3.24% Employment Security Commission 8,291,021 665,726 8,956,746 7.43% NC Housing Finance Authority 514,643 79,236 593,879 13.34% NC School Science & Math 280,505 83,258 363,763 22.89% NC Wildlife Resources 1,424,078 0 1,424,078 0.00% Office of Administrative Hearings 65,734 0 65,734 0.00% Office of the Governor 757,867 136,151 894,018 15.23% Office of the Lieutenant Governor 0 0 0 N/A Office of the State Auditor 585,654 0 585,654 0.00% Office of the State Controller 4,181,656 96,776 4,278,432 2.26% State Board of Elections 1,960,914 0 1,960,914 0.00% TOTAL w/out UNC System, Lottery, AOC & ITS 130,870,862 19,952,602 150,823,464 13.23% Administrative Office of the Courts 16,879,670 1,524,697 18,404,367 8.28% NC Education Lottery 1,590,775 204,235 1,795,010 11.38% UNC System 181,208,602 23,958,645 205,167,247 11.68% Total Without ITS 330,549,908 45,640,179 376,190,087 12.13% Office of Information Technology Services 33,346,085 4,148,375 37,494,460 11.06% Table 5-3 Total IT Salary and Fringe Amount By Position Status Annual Budgeted Amounts as reported June 30, 2007 Page 23 FILLED POSITIONS VACANT POSITIONS TOTAL POSITIONS % VACANT OF TOTAL Appalachian State University 7,129,174 822,141 7,951,315 10.34% East Carolina University 16,728,553 2,406,196 19,134,749 12.58% Elizabeth City State University 1,466,538 284,838 1,751,377 16.26% Fayetteville State University 1,612,337 620,069 2,232,406 27.78% NC A&T State University 4,302,360 260,452 4,562,812 5.71% NC Central University 3,317,783 424,074 3,741,857 11.33% NC School of Arts 798,201 95,823 894,024 10.72% NC State University 33,332,917 2,715,500 36,048,417 7.53% UNC Asheville 1,818,166 253,151 2,071,318 12.22% UNC Chapel Hill 62,222,557 10,167,878 72,390,434 14.05% UNC Charlotte 12,003,461 877,449 12,880,910 6.81% UNC General Administration 3,309,251 951,112 4,260,363 22.32% UNC Greensboro 11,626,061 330,878 11,956,939 2.77% UNC Hospital 6,385,008 1,661,529 8,046,536 20.65% UNC Pembroke 2,003,529 331,332 2,334,861 14.19% UNC Wilmington 6,878,829 306,595 7,185,424 4.27% Western Carolina University 4,299,499 436,384 4,735,882 9.21% Winston-Salem State University 1,974,377 1,013,245 2,987,622 33.91% Total: 181,208,602 23,958,645 205,167,247 11.68% Table 5-4 Total IT Salary and Fringe Amount By Position Status UNC System Agencies Annual Budgeted Amounts as reported June 30, 2007 Page 24 FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes Comprehensive Major Medical Plan 1.00 101,367 0.00 0 0.00 0 0.00 0 1.00 45,376 Community Colleges System Office 10.00 1,011,951 9.00 671,705 1.00 82,852 38.00 2,787,343 13.00 774,390 Department of Administration 3.00 307,740 0.00 0 0.00 0 10.00 798,710 9.00 448,785 Department of Agriculture & Consumer Services 1.00 121,419 1.00 55,068 1.00 92,096 23.75 1,595,854 12.00 657,009 Department of Commerce 4.00 434,646 1.00 82,165 2.00 182,856 24.00 1,859,198 10.00 555,107 Department of Correction 14.00 1,491,655 4.00 261,240 29.00 1,973,889 33.00 2,918,957 51.00 2,482,109 Department of Crime Control & Public Safety 4.00 431,611 1.00 94,773 20.00 1,340,925 17.00 1,356,363 21.00 1,273,559 Department of Cultural Resources 1.00 94,557 0.00 0 2.00 152,312 5.00 329,226 8.75 480,862 Department of Environment & Natural Resources 11.00 1,140,316 1.00 77,359 1.00 85,880 65.00 4,700,364 69.00 3,978,303 Department of Health and Human Services 57.00 5,543,631 35.00 1,814,814 35.00 2,391,078 186.00 14,705,894 89.00 4,949,967 Department of Insurance 1.00 108,012 0.00 0 3.00 227,112 10.00 914,576 5.05 353,508 Department of Justice 14.00 1,448,128 9.00 745,688 6.00 370,625 24.00 1,694,406 24.00 1,240,371 Department of Juvenile Justice & Delinquency Prevention 4.00 423,455 3.00 259,954 2.00 163,026 7.00 512,942 13.00 870,812 Department of Labor 2.00 174,521 0.00 0 0.00 0 3.00 235,073 6.00 313,872 Department of Public Instruction 16.00 1,733,391 6.00 435,756 10.00 817,672 64.00 5,538,343 38.75 2,487,994 Department of Revenue 19.00 1,953,889 19.00 1,335,811 7.00 577,499 43.25 3,489,409 17.00 909,677 Department of Secretary of State 3.00 302,908 0.00 0 0.00 0 4.00 316,483 4.00 209,109 Department of Transportation 57.00 5,842,376 36.00 2,550,732 6.00 511,236 199.00 16,435,167 92.00 5,615,036 Department of the State Treasurer 3.00 376,825 7.00 428,659 2.00 206,468 21.00 2,022,438 12.00 812,003 Employment Security Commission 15.00 1,714,483 31.00 2,348,289 6.00 469,378 43.00 3,755,115 11.00 669,481 NC Housing Finance Authority 4.00 337,373 0.00 0 0.00 0 3.00 256,506 0.00 0 NC School Science & Math 1.00 95,797 1.00 75,691 0.00 0 0.00 0 4.00 192,275 NC Wildlife Resources 1.00 118,285 0.00 0 5.00 378,642 7.00 601,573 6.00 325,577 Office of Administrative Hearings 0.00 0 0.00 0 1.00 65,734 0.00 0 0.00 0 Office of the Governor 1.00 120,550 0.00 0 0.00 0 9.00 773,469 0.00 0 Office of the Lieutenant Governor 0.00 0 0.00 0 0.00 0 0.00 0 0.00 0 Office of the State Auditor 1.00 122,822 0.00 0 1.00 89,166 3.00 243,376 2.00 130,289 Office of the State Controller 10.00 1,113,371 4.00 263,036 2.00 154,404 28.00 2,423,175 5.00 324,446 State Board of Elections 3.00 302,650 1.00 94,624 0.00 0 10.00 690,432 16.00 873,209 TOTAL w/out UNC System, Lottery, AOC & ITS 261.00 26,967,729 169.00 11,595,364 142.00 10,332,848 880.00 70,954,394 539.55 30,973,128 Administrative Office of the Courts NC Education Lottery UNC System 170.01 15,772,772 449.97 32,235,814 228.50 15,901,089 801.54 59,387,190 1,089.50 59,458,494 Total Without ITS 431.01 42,740,501 618.97 43,831,179 370.50 26,233,938 1,681.54 130,341,584 1,629.05 90,431,621 Office of Information Technology Services 57.00 6,583,958 98.00 8,071,340 155.00 12,170,310 103.00 10,014,317 11.00 654,536 Non-banded positions included in Table 5-1: AOC 18,404,367 Univ 22,411,888 Lottery 1,795,010 NOTE: Non-banded positions for agencies not including AOC and Universities were classified according to similar banding positions based on the OSP crosswalk. Table 5-5 Salary and Calculated Fringes by Banding Category for All IT Positions Annual Budgeted Amounts as reported June 30, 2007 Information Technology Operations and Systems Networking Business and Technology Applications Technical Support Page 25 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 26 FTE Comparison between IT positions and All Positions Table 5-6 Information Technology FTEs versus All FTEs compares the FTE count for all IT positions to total FTEs by agency. The FTE count for IT positions is further divided by position status (filled or vacant) as of June 30, 2007. The agencies are grouped by legislative committee for this table. The North Carolina Education Lottery is also included for informational purposes. Page 27 Filled Information Technology Positions Vacant Information Technology Positions Total Information Technology Positions Total All Positions % IT of Total Education Community Colleges System Office 61.00 10.00 71.00 219.50 32.35% Department of Public Instruction 123.75 11.00 134.75 694.78 19.39% NC School Science & Math 4.00 2.00 6.00 110.00 5.45% UNC System 2,628.55 388.48 3,017.03 29,975.20 10.07% Education Total: 2,817.30 411.48 3,228.78 30,999.48 10.42% General Government Department of Administration 18.00 4.00 22.00 1,004.96 2.19% Department of Cultural Resources 15.75 1.00 16.75 815.48 2.05% Department of Insurance 17.00 2.05 19.05 413.04 4.61% Department of Revenue 92.25 13.00 105.25 1,548.25 6.80% Department of Secretary of State 11.00 0.00 11.00 187.00 5.88% Department of the State Treasurer 43.00 2.00 45.00 365.99 12.30% NC Housing Finance Authority 6.00 1.00 7.00 116.00 6.03% Office of Administrative Hearings 1.00 0.00 1.00 45.00 2.22% Office of the Governor 8.00 2.00 10.00 136.99 7.30% Office of the State Auditor 7.00 0.00 7.00 195.00 3.59% Office of the State Controller 48.00 1.00 49.00 135.75 36.10% State Board of Elections 30.00 0.00 30.00 59.00 50.85% General Government Total: 297.00 26.05 323.05 5,022.46 6.43% Human Resources Department of Health and Human Services 349.00 53.00 402.00 19,389.35 2.07% Human Resources Total: 349.00 53.00 402.00 19,389.35 2.07% Justice and Public Safety Administrative Office of the Courts 199.75 18.00 217.75 6,300.21 3.46% Department of Correction 118.00 13.00 131.00 21,055.50 0.62% Department of Crime Control & Public Safety 57.00 6.00 63.00 2,853.75 2.21% Department of Justice 67.00 10.00 77.00 1,341.14 5.74% Department of Juvenile Justice & Delinquency Prevention 28.00 1.00 29.00 1,988.75 1.46% Justice and Public Safety Total: 469.75 48.00 517.75 33,539.35 1.54% Natural and Economic Resources Department of Agriculture & Consumer Services 34.75 4.00 38.75 1,391.00 2.79% Department of Commerce 38.00 3.00 41.00 838.43 4.89% Department of Environment & Natural Resources 123.00 24.00 147.00 3,962.68 3.71% Department of Labor 11.00 0.00 11.00 429.75 2.56% Employment Security Commission 97.00 9.00 106.00 2,078.00 5.10% NC Wildlife Resources 19.00 0.00 19.00 649.50 2.93% Natural and Economic Resources Total: 322.75 40.00 362.75 9,349.36 3.88% Salaries and Benefits Retirement Comprehensive Major Medical Plan 2.00 0.00 2.00 36.50 5.48% Salaries Benefits Retirement Total: 2.00 0.00 2.00 36.50 5.48% Transportation Department of Transportation 292.00 98.00 390.00 14,683.00 2.66% Transportation Total: 292.00 98.00 390.00 14,683.00 2.66% NC Education Lottery NC Education Lottery 22.00 3.00 25.00 232.00 10.78% NC Education Lottery Total: 22.00 3.00 25.00 232.00 10.78% Office of Information Technology Services Office of Information Technology Services 376.00 48.00 424.00 509.00 83.30% Office of Information Technology Services Total: 376.00 48.00 424.00 509.00 83.30% Total: 4,947.80 727.53 5,675.33 113,760.50 4.99% Table 5-6 Information Technology FTEs versus All FTEs As Reported June 30, 2007 State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 28 Portfolio Management For many years the State of North Carolina grappled with the question “How much does the state spend on information technology each year?” The General Assembly mandated that this joint report be prepared to begin answering this question. In 2004, the General Assembly directed the State Chief Information Officer (SCIO) to begin improving the management of information technology in state government. To do this, Information Technology Services (ITS) purchased new tools and began several new services. In accordance with the statutory authority of the SCIO and ITS, this section focuses only on the Executive Branch. No figures are given for the university system, the North Carolina Education Lottery, the Administrative Office of the Courts or the General Assembly. This section focuses on the concepts of Portfolio Management (PM). PM is the grouping of computer applications and projects to examine how an organization is spending its funds, its risk profile, and its future plans for technology. Just as one manages a personal retirement fund or budget by putting some dollars in short term investments, some in long term high risk investments, some in long term low risk investments and some in readily available funds, the state should manage its technology portfolio for the future. The state’s technology profile is composed of several key elements: people, hardware and software, projects and its existing applications. Other sections of this report give information on the costs of personnel and hardware and software. Project Portfolio Management focuses on new technology projects intended to improve the service delivery of existing services or to provide new services. Projects have a definite timeline, a budget, and a set of deliverables. When they are finished, the state should have a new service or improved infrastructure to build on for the future. Application Portfolio Management focuses on the state’s existing software applications, everything from food stamps to victim services to drivers’ licenses and boat registration. It looks at the age of the application, the technical health of the application, and the ability of the application to continue to meet business needs. Each application should have planned for the future—should the state continue to maintain it, should it be modified to use newer technology, or should it be replaced since it no longer meets the agency’s business needs? Last year was the first year that information for the IT Expenditures Report was taken from the Portfolio Management tool. It should be reiterated that while the cost categories were developed with the assistance and approval of the Office of the State Controller and the Office of State Budget and Management, the numbers reported below are based on self-reports from the agencies. The costs have not been audited, nor were they directly transferred to the PM system from the NCAS. Overall, approximately 67.42% of the costs shown in Table 1.1 (minus the AOC, University system, NC Education Lottery and Information Technology Services) are represented in the following tables. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 29 Projects The Enterprise Project Management Office monitored over 100 projects during FY 2007. As stated above, projects are new efforts with budgets, timelines and milestones. (Tracking and monitoring of projects less than $500,000 is not required, although if projects under $500,000 reported costs in the PM Tool, they are included in this report.) In FY 2006-07, approximately $156M was spent by state agencies, including ITS, on projects. Three state agencies spent a large proportion of those funds: OSC for the Beacon project, Crime Control and Public Safety for the VIPER project, and Health and Human Services for several key projects. The pie chart below shows the sources of funds for projects, excluding ITS: approximately 59% came from state funds and 33% came from federal. FY2007 Project Costs by Source of Funds Federal Funds; $41,737,819; 33% Local Funds; $1,012,030; 1% Non Federal Grants; $247,650; 0% Receipts User Fees; $9,362,216; 7% State Appropriations; $74,431,713; 59% The second pie chart shows the distribution of project funds statewide at a detailed cost level. The most significant observation that can be made from this chart is that approximately 34% of the project dollars were spent on external personnel costs. Only 12% of project costs were attributed to state internal personnel costs. State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 30 FY2007 Project Costs by Detailed Cost Category Internal Personnel Costs $14,113,780 12% External Personnel Costs $39,735,678 34% Other External Costs $12,664,756 11% Hardware Costs $38,427,625 32% Software Costs $4,832,958 4% Other Costs $8,572,226 7% Table 6-1 shows the distribution of costs for projects by agency for 2007 by detailed cost category. Table 6-2 shows the distribution of costs for projects by agency for 2007 by source of funds. Applications State agencies, including ITS, have identified approximately 1,300 applications (including retired applications). As defined above, applications are on-going activities that support key business processes in state government, everything from the issuance of food stamps to vehicle registration and employee payroll. The state does not count commercially available software such as MS Word or Excel in its listing of applications. The focus is on specialized, often custom-developed applications serving many employees and enabling them to deliver services to citizens of North Carolina. Note: In February 2007, the SCIO prepared a report on the state’s legacy applications. That report provides additional details on the current condition of the state’s application portfolio. It can be found at http://www.scio.nc.gov under the “Management of Legacy Applications Report.” The pie chart below provides details of the source of funds for maintaining the state’s existing applications, exclusive of ITS. As the chart depicts, the ratio of state to federal funds increases compared to projects, with the state providing a higher percent (68%) of funding than federal (27%). State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 31 FY2007 Application Costs Source of Funds Federal Funds; $65,606,015; 27% Local Funds; $534,630; 0% Non Federal Grants; $604,127; 0% Receipts User Fees; $11,725,414; 5% State Appropriations; $161,245,107; 68% The second pie chart gives details on the distribution of costs in categories. The key finding from this chart is that internal state and external personnel percentages change significantly from the project percentages: 22% of the cost of maintaining applications comes from internal personnel. The use of external contractors for maintenance declines to only 18%. FY2007 Application Costs by Detailed Cost Category Internal Personnel Costs $53,279,503 22% External Personnel Costs $42,203,376 18% Other External Costs $93,862,947 39% Hardware Costs $21,793,108 9% Software Costs $15,984,914 7% Other Costs $12,591,454 5% State of North Carolina Information Technology Expenditures Report For the Period July 2006 – June 2007 Page 32 Table 6-3 provides additional information on state government application costs by agencies for 2007 by detailed cost category. Table 6-4 provides additional information on state government application costs by agencies for 2007 by source of funds. Key differences between FY2006 and FY2007 include: • The number of projects reporting costs, including ITS, increased from 75 in 2006 to 118 in 2007. Total project costs grew from $132M in 2006 to $156M in 2007. • The number of applications reporting costs, including ITS, went from 1,169 in 2006 to 1131 in 2007. However, this includes 53 FY2006 applications that were consolidated into 6 applications for reporting purposes in the Portfolio Management tool in FY2007 and the removal of 11 other 2006 applications incorrectly added to the tool in 2006. Total applications costs grew from $232M in 2006 to $250M in 2007. • Several commissions and offices report on their projects and applications separately in the Portfolio Management tool, but are combined in the other sections of this IT Expenditures report. For consistency, this year we have reported those costs in the same agency as used in other sections of this report. This includes: o Alcoholic Beverage Control Commission – included in Department of Commerce o Industrial Commission - Workers' Compensation - included in the Department of Commerce o Office of State Budget and Management - included in the Office of the Governor o Office of State Personnel - included in the Department of Administration. • Finally, this is the first year that we are reporting the source of funds for projects and applications (in Tables 6-2 and 6-4 respectively). Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Community Colleges System Office Administrative Information Systems 271,966 6,118,605 114,611 0 0 69,340 0 6,574,522 CIS Release 18 Infrastructure Migration 412,060 3,283,635 0 0 0 0 0 3,695,695 Improve Student Access to Services and 0 0 0 0 0 9,100 Optimize Registration Resources 0 9,100 Learning Object Repository Infrastructure 46,620 0 0 0 0 34,325 Project 0 80,945 Total Costs for Community Colleges System Office 730,646 9,402,240 114,611 0 0 112,765 0 10,360,262 Department of Administration Motor Fleet Management System (MFMS) 268,929 0 0 396 0 0 Project 41,487 310,812 NC FLEX Web-Based Enrollment System 21,988 0 0 0 456,719 0 Project 0 478,707 NC Works - Phase I 23,265 32,450 0 0 0 0 0 55,715 Total Costs for Department of Administration 314,182 32,450 0 396 456,719 0 41,487 845,234 Department of Commerce Application Development & Support 2,717 0 0 0 0 0 Services 0 2,717 CMS - Content Management System 160,963 361,571 0 13,254 43,253 0 0 579,041 Page 33 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Commerce Economic Development Intelligence 38,520 180,024 150 0 0 0 System Project 0 218,694 Industrial Commission Electronic 71,232 484,674 0 1,200 0 0 Document Management System (EDMS) Migration and Replacement Project 0 557,106 Terminal Operating System 6,300 0 0 0 0 0 0 6,300 Total Costs for Department of Commerce 279,732 1,026,269 150 14,454 43,253 0 0 1,363,858 Department of Correction DOC Sex Offender GPS 203,307 19,600 0 0 0 0 0 222,907 Total Costs for Department of Correction 203,307 19,600 0 0 0 0 0 222,907 Department of Crime Control and Public Safety Flood Inundation Mapping and Alert 19,958 41,283 0 0 0 0 Network (FIMAN) - (West) 0 61,241 Viper Strategic Solution Implementation 362,470 0 0 6,606,163 0 0 Project - Phase 0 0 6,968,633 VIPER Strategic Solution Implementation 224,697 227,200 0 23,637,000 0 0 Project - Phase 1 0 24,088,897 Total Costs for Department of Crime Control and Public Safety 607,125 268,483 0 30,243,163 0 0 0 31,118,771 Department of Environment and Natural Resources Central Reservation System 35,622 0 0 0 0 0 0 35,622 Page 34 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Environment and Natural Resources EEP Information Management System 58,132 1,067,620 0 0 0 0 0 1,125,752 Point of Sale System Replacement 196 5,200 0 0 0 0 0 5,396 Total Costs for Department of Environment and Natural 93,950 1,072,820 0 0 0 0 1,166,770 Resources 0 Department of Health and Human Services Central Region Psychiatric Hospital 29,714 188,998 936,325 1,433 0 21,664 Automation Program (CHAPS) Infrastructure Project 570,918 1,749,052 Client Services Data Warehouse Business 15,807 181,307 0 20,784 41,698 356,535 Objects XI Migration 0 616,131 Client Services Data Warehouse Hardware 0 1,502 0 0 0 0 Migration Project 0 1,502 Crossroads State Agency Model Project 100,330 140,633 0 0 0 0 (SAM) 0 240,963 DHHS Security Project 283,124 181,595 67,007 566 89 80,086 262,960 875,427 DHHS Disability Determination Services 6,249 47,114 0 134,350 26,764 0 Section - Telephony Upgrade 0 214,477 DHHS HIPAA National Provider 305,059 5,207,689 0 0 0 71,629 Identifier (NPI) Initiative 0 5,584,377 Division of Medical Assistance - Home 7,735 0 0 0 0 600 and Community Based Services Reforms Project 0 8,335 Division of Medical Assistance - Uniform 5,007 1,036,000 0 0 0 792 Screening Program 0 1,041,799 Page 35 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Health and Human Services 730,884 Health Information System 776,568 692,166 32,525 430,078 2,754,333 0 5,416,554 LIMS - Laboratory Information 0 307,389 369,155 251,922 72,377 0 Management System 0 1,000,843 Martin County Call Center Upgrade 28,018 3,042 0 0 0 10,298 0 41,358 NC Electronic Disease Surveillance 206,667 107,500 1,076,203 0 175,008 0 System (NC EDSS) 0 1,565,378 NC FAST Automated Interview (AI) 250,138 101,463 3,248 964 477 261,049 Integrator Selection Project 39,441 656,780 NC FAST Automated Interview Software 45,982 54,107 813 0 644 27,053 Selection 0 128,599 NC FAST Legacy Systems Analyses 318,970 39,213 0 0 0 97,053 Project 0 455,236 NC FAST Program Definition Project 16,026 968 1,468 0 0 0 119,187 137,649 NC FAST Service Delivery Interface 0 0 0 0 0 0 (SDI) Project 158,046 158,046 NC Information and Referral 0 26,964 142,562 0 0 12,282 88,400 270,208 NCMMIS Initiative 0 0 0 0 0 0 3,253,681 3,253,681 NCMMIS+ Program - Artifacts Review 486,581 141,570 3,305 14,001 6,095 28,144 and Update Project 0 679,696 Page 36 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Health and Human Services NCMMIS+ Program - Business Rules and 466,568 174,126 4,010 14,741 7,262 22,732 Analysis Project 0 689,439 NCMMIS+ Program – DHSR Business 344,501 118,552 0 12,843 6,326 17,653 Process Automation Project 0 499,875 NCMMIS+ Program Planning Project 637,223 283,562 0 15,194 7,483 21,169 0 964,631 NCMMIS+ Program–Medicaid 58,621 20,757 0 476 234 3,519 Accounting System (MAS) & Accounts Receivable / Payable Business Process 0 83,607 NCMMIS+ Replacement Strategy Project 263,845 28,316 0 9,640 4,748 12,846 for Provider Type and Provider Specialty 0 319,395 Vital Records and Statistics Automation 38,460 174,263 1,057 0 0 9,298 System 185,774 408,852 Total Costs for Department of Health and Human Services 4,645,509 9,343,198 3,297,319 509,439 779,283 3,808,735 4,678,407 27,061,890 Department of Justice Disaster Recovery (BCP/DR) 93,752 159,340 71,040 0 0 0 Implementation 0 324,132 Learning Management System Project 191,692 0 0 0 0 0 (formerly Training & Standards Learning Management ...) 0 191,692 SSN Replacement & Database Conversion 111,520 163,704 0 0 0 0 Project (formerly Training & Standards Conversion ...) 0 275,224 Statewide Automated Fingerprint 306,666 39,096 1,020,612 0 0 3,601 Identification System (SAFIS) Replacement Project 0 1,369,975 Total Costs for Department of Justice 703,630 362,140 1,091,652 0 0 3,601 0 2,161,023 Page 37 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Public Instruction CECAS 2007 Hosting 2,354 0 0 0 0 0 0 2,354 Child Nutrition Claims (CNC) 73,617 158,750 60,500 0 42,370 0 0 335,237 Child Nutrition Direct Certification and 16,993 0 0 0 0 0 Verification 0 16,993 Comprehensive Exceptional Children 372,767 480,361 0 39,645 0 0 Accountability System (CECAS) Initiative 179,585 1,072,358 DPI LAN Hardware and Wiring Upgrade 10,837 0 0 0 0 0 0 10,837 eSIS 9.1 Upgrade 107,525 68,396 0 0 0 0 0 175,921 K-Nect 16,186 219,500 10,150 16,000 2,000 0 0 263,836 NC WISE - Enhancements 11,560 0 0 0 0 0 0 11,560 NC WISE Wave 3 Deployment 32,470 0 0 0 0 0 106,845 139,315 NCWISE Reporting 135,500 1,671,948 24,067 0 0 0 0 1,831,515 NCWISE Wave 2 Deployment 520,735 655,076 0 0 0 0 1,620,199 2,796,010 Online Educational Services for Student 13,496 0 0 0 0 209,000 Achievement Improvement 0 222,496 Page 38 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Total Costs for Department of Public Instruction 1,314,040 3,254,031 94,717 55,645 44,370 209,000 1,906,629 6,878,432 Department of Revenue Motor Fuels Tracking System 2,051 8,422 0 0 0 0 1,151,966 1,162,439 Online Filing and Payments Services 72,001 259,645 0 0 0 0 495,597 827,243 Total Costs for Department of Revenue 74,052 268,067 0 0 0 0 1,647,563 1,989,682 Department of the StateTreasurer Integrated Document Managemt System - 100,415 164,775 0 96,947 168,193 0 Unclaimed Property Program (IDMS-UPP) 0 530,330 Integrated Retirement System Planning 634,370 884,440 3,893,129 0 0 0 0 5,411,939 Total Costs for Department of the StateTreasurer 734,785 1,049,215 3,893,129 96,947 168,193 0 0 5,942,269 Department of Transportation 511 Traveler Information System Phase II 6,000 0 367,000 123,000 0 0 0 496,000 Automated Testing System 5,795 9,209 0 369,200 426,700 0 0 810,904 Customer Traffic Management System 744 4,640 204,278 0 0 0 0 209,662 Customer Traffic Management Systems 0 1,280 435,747 0 0 0 Phase II 0 437,027 Page 39 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Transportation Database Cleansing of Legacy Photo 200 10,960 395,000 0 0 0 Images 0 406,160 DMV Call Center Relocation 10,967 11,145 2,140 20,310 0 0 0 44,562 DMV License Plate Recall 95,792 12,360 0 0 0 0 0 108,152 Enterprise Web Portal and Executive 30,756 168,532 0 566,000 0 0 Dashboard 0 765,288 ERP 2005 Upgrade 8,638 17,825 0 0 0 0 0 26,463 Facility Management Systems 121,546 234,711 0 0 0 0 0 356,257 Fleet Documentation 22,856 53,327 0 0 0 0 0 76,183 Grants in Contract Management (DBE) 3,548 10,460 0 0 0 0 119,738 133,746 Greenfield Center Infrastructure 33,949 19,468 0 286,166 0 0 0 339,583 HiCAMS Architecture Study 300 0 157,000 0 0 0 0 157,300 IputAccel Upgrade R5.2 24,011 3,788 300,806 0 0 0 0 328,605 IRP/MC & LITES Upgrades and Migration 24,632 1,000 0 0 0 0 960 26,592 Page 40 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Department of Transportation Maintenance Management System (MMS) 1,470 603 12,084 4,749 547 -49,038 Handheld Systems 47,067 17,482 NCSmartlink 7,924 0 14,858 0 0 0 2,434 25,216 Notice, Storage and Theft System 9,829 0 0 0 0 0 120 9,949 Pavement Management System Project 122,621 109,000 1,553,600 0 0 0 Phase 2 (Implementation) 0 1,785,221 PreQualification Automation 140,253 197,709 0 0 0 0 0 337,962 SDLC and Requirements Management 21,786 34,723 0 0 0 0 0 56,509 Total Costs for Department of Transportation 693,617 900,740 3,442,513 1,369,425 427,247 -49,038 170,319 6,954,823 Employment Security Commission Initial Claims Call Center 488,715 265,433 0 10,203 4,660 4,162 0 773,173 UI Fraud & Identify Theft 35,734 0 0 0 0 0 0 35,734 VoIP Telephony Solution for ESC 85,870 5,100 6,119 12,349 0 0 Unemployment Insurance Division, Central Office Complex 0 109,438 Total Costs for Employment Security Commission 610,319 270,533 6,119 22,552 4,660 4,162 0 918,345 Page 41 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs NC Wildlife Resources Coastal Recreational Fishing License 95,215 316,380 0 0 78,690 0 Implementation 0 490,285 Phase 4 Online Licensing and Vessel 18,000 0 0 0 0 0 Registration Project 0 18,000 Total Costs for NC Wildlife Resources 113,215 316,380 0 0 78,690 0 0 508,285 Office of the State Auditor Non-Governmental Organization Grant 61,971 128,217 0 0 0 0 Compliance - Business Intelligence & Data Warehouse 0 190,188 Total Costs for Office of the State Auditor 61,971 128,217 0 0 0 0 0 190,188 Office of the State Controller BEACON-HR/PAYROLL 2,917,450 12,021,295 724,546 904,012 2,830,543 4,483,001 0 23,880,847 Total Costs for Office of the State Controller 2,917,450 12,021,295 724,546 904,012 2,830,543 4,483,001 0 23,880,847 State Board of Elections ERAPP (e-Pollbooks) 11,500 0 0 0 0 0 0 11,500 Voter Registration Server Upgrade 2,000 0 0 0 0 0 0 2,000 Voting Equipment Upgrade HAVA ( Help 0 0 0 5,211,592 0 0 America Vote Act ) 0 5,211,592 WBET - WEB Based Elections Tools 2,750 0 0 0 0 0 0 2,750 Page 42 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Total Costs for State Board of Elections 16,250 0 0 5,211,592 0 0 0 5,227,842 Total Costs for Non-ITS 14,113,780 39,735,678 12,664,756 38,427,625 4,832,958 8,572,226 8,444,405 126,791,428 Office of Information Technology Services Electronic Document Management Service 152,210 38,999 0 24,723 0 0 12,950 228,882 Enterprise Service Access Point (ESAP) 731,515 0 0 382,171 0 0 0 1,113,686 Intrusion Prevention System (IPS) for 13,480 0 0 0 0 0 State Infrastructure 0 13,480 IT Asset Management (ITAM) Project 141,109 164,117 0 0 371,200 9,743 Phase 1 0 686,169 IT Consolidation Phase II - Industrial 312,383 145,850 0 0 0 322 Commission 0 458,555 IT Consolidation Pilot Project 175,023 22,698 0 397,012 0 0 0 594,733 ITS On Boarding to Electronic Document 75,725 0 0 0 0 0 Management Service 0 75,725 ITS SQA Shared Service 71,195 17,480 0 0 647,220 0 0 735,895 Managed Platform - Server Virtualization 145,139 0 0 732,600 83,374 26,578 0 987,691 Page 43 Agency Project Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Project Costs Table 6-1 Information Technology Expenditures - Projects For the year ending June 30, 2007 Unalloted Costs Office of Information Technology Services OEP Culminating Phases 608,699 425,267 63,915 0 0 0 0 1,097,881 Operational Excellence Program Phase I 467,804 263,529 13,500 0 0 0 0 744,833 Phase 1 ITS Data Warehouse Shared 100,856 0 0 0 0 0 Service 56,434 157,290 Polycom MGC-100 Video MCU 0 0 0 0 0 0 Procurement 900 900 Remedy Service Desk Implementation 55,256 64,000 0 0 250,754 8,310 0 378,320 SDC - Capacity Back Up Mainframe 8,000 0 0 0 0 0 0 8,000 Security Information and Event 44,800 0 0 324,800 0 0 Management (SIEM) Procurement & Implementation 0 369,600 Statewide Secondary Data Center 183,472 0 14,406,513 0 0 1,777,420 0 16,367,405 Upgrade of Disk Storage Infrastructure 32,470 211,000 0 1,734,897 491,093 0 0 2,469,460 Z9 Mainframe Upgrade 19,031 0 0 3,070,915 0 0 0 3,089,946 Total Costs for Office of Information Technology Services 3,338,167 1,352,940 14,483,928 6,667,118 1,843,641 1,822,373 70,284 29,578,451 Total Costs for ITS 3,338,167 1,352,940 14,483,928 6,667,118 1,843,641 1,822,373 70,284 29,578,451 Page 44 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Community Colleges System Office Administrative Information Systems 0 26,361 0 0 6,548,161 6,574,522 Community Colleges System Office CIS Release 18 Infrastructure Migration 0 0 0 0 3,695,695 3,695,695 Community Colleges System Office Improve Student Access to Services and Optimize Registration Resources 0 0 0 0 9,100 9,100 Community Colleges System Office Learning Object Repository Infrastructure Project 0 0 0 0 80,945 80,945 Total Costs for Community Colleges System Office 0 26,361 0 0 10,333,901 10,360,262 Department of Administration Motor Fleet Management System (MFMS) Project 0 0 0 229,980 80,832 310,812 Department of Administration NC FLEX Web-Based Enrollment System Project 0 0 0 0 478,707 478,707 Department of Administration NC Works - Phase I 0 0 0 0 55,715 55,715 Total Costs for Department of Administration 0 0 0 229,980 615,254 845,234 Department of Commerce Application Development & Support Services 0 2,717 0 0 0 2,717 Page 45 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Commerce CMS - Content Management System 9,000 0 0 0 570,041 579,041 Department of Commerce Economic Development Intelligence System Project 0 0 0 0 218,694 218,694 Department of Commerce Industrial Commission Electronic Document Management System (EDMS) Migration and Replacement 0 0 0 0 557,106 557,106 Department of Commerce Terminal Operating System 0 0 0 6,300 0 6,300 Total Costs for Department of Commerce 9,000 2,717 0 6,300 1,345,841 1,363,858 Department of Correction DOC Sex Offender GPS 68,632 0 0 0 154,275 222,907 Total Costs for Department of Correction 68,632 0 0 0 154,275 222,907 Department of Crime Control and Public Safety Flood Inundation Mapping and Alert Network (FIMAN) - (West) 0 0 0 0 61,241 61,241 Department of Crime Control and Public Safety Viper Strategic Solution Implementation Project - Phase 0 6,606,163 0 0 0 362,470 6,968,633 Department of Crime Control and Public Safety VIPER Strategic Solution Implementation Project - Phase 1 15,637,000 0 0 0 8,451,897 24,088,897 Page 46 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Total Costs for Department of Crime Control and Public Safety 22,243,163 0 0 0 8,875,608 31,118,771 Department of Environment and Natural Resources Central Reservation System 0 0 0 0 35,622 35,622 Department of Environment and Natural Resources EEP Information Management System 0 0 0 1,116,064 9,688 1,125,752 Department of Environment and Natural Resources Point of Sale System Replacement 0 0 0 5,200 196 5,396 Total Costs for Department of Environment and Natural Resources 0 0 0 1,121,264 45,506 1,166,770 Department of Health and Human Services Central Region Psychiatric Hospital Automation Program (CHAPS) Infrastructure Project 0 0 0 0 1,749,052 1,749,052 Department of Health and Human Services Client Services Data Warehouse Business Objects XI Migration 295,746 0 0 0 320,385 616,131 Department of Health and Human Services Client Services Data Warehouse Hardware Migration Project 721 0 0 0 781 1,502 Department of Health and Human Services Crossroads State Agency Model Project (SAM) 240,963 0 0 0 0 240,963 Department of Health and Human Services DHHS Security Project 11,743 0 0 0 863,684 875,427 Page 47 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Health and Human Services DHHS Disability Determination Services Section - Telephony Upgrade 214,477 0 0 0 0 214,477 Department of Health and Human Services DHHS HIPAA National Provider Identifier (NPI) Initiative 103,730 0 0 0 5,480,647 5,584,377 Department of Health and Human Services Division of Medical Assistance - Home and Community Based Services Reforms Project 0 0 0 0 8,335 8,335 Department of Health and Human Services Division of Medical Assistance - Uniform Screening Program 0 0 0 0 1,041,799 1,041,799 Department of Health and Human Services Health Information System 15,412 453,218 0 0 4,947,924 5,416,554 Department of Health and Human Services LIMS - Laboratory Information Management System 1,000,843 0 0 0 0 1,000,843 Department of Health and Human Services Martin County Call Center Upgrade 0 3,863 0 0 37,495 41,358 Department of Health and Human Services NC Electronic Disease Surveillance System (NC EDSS) 1,565,378 0 0 0 0 1,565,378 Department of Health and Human Services NC FAST Automated Interview (AI) Integrator Selection Project 251,415 0 0 0 405,365 656,780 Department of Health and Human Services NC FAST Automated Interview Software Selection 49,203 0 0 0 79,396 128,599 Page 48 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Health and Human Services NC FAST Legacy Systems Analyses Project 180,920 0 0 0 274,316 455,236 Department of Health and Human Services NC FAST Program Definition Project 53,382 0 0 0 84,267 137,649 Department of Health and Human Services NC FAST Service Delivery Interface (SDI) Project 62,212 0 0 0 95,834 158,046 Department of Health and Human Services NC Information and Referral 270,208 0 0 0 0 270,208 Department of Health and Human Services NCMMIS Initiative 2,859,050 0 0 0 394,631 3,253,681 Department of Health and Human Services NCMMIS+ Program - Artifacts Review and Update Project 611,291 0 0 0 68,405 679,696 Department of Health and Human Services NCMMIS+ Program - Business Rules and Analysis Project 620,491 0 0 0 68,948 689,439 Department of Health and Human Services NCMMIS+ Program – DHSR Business Process Automation Project 449,875 0 0 0 50,000 499,875 Department of Health and Human Services NCMMIS+ Program Planning Project 868,168 0 0 0 96,463 964,631 Department of Health and Human Services NCMMIS+ Program–Medicaid Accounting System (MAS) & Accounts Receivable / Payable Business Process 75,228 0 0 0 8,379 83,607 Page 49 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Health and Human Services NCMMIS+ Replacement Strategy Project for Provider Type and Provider Specialty 287,453 3,433 0 0 28,509 319,395 Department of Health and Human Services Vital Records and Statistics Automation System 2,763 0 0 391,679 14,410 408,852 Total Costs for Department of Health and Human Services 10,090,672 460,514 0 391,679 16,119,025 27,061,890 Department of Justice Disaster Recovery (BCP/DR) Implementation 0 50 0 0 324,082 324,132 Department of Justice Learning Management System Project (formerly Training & Standards Learning Management ...) 0 191,692 0 0 0 191,692 Department of Justice SSN Replacement & Database Conversion Project (formerly Training & Standards Conversion ...) 0 275,224 0 0 0 275,224 Department of Justice Statewide Automated Fingerprint Identification System (SAFIS) Replacement Project 0 0 0 0 1,369,975 1,369,975 Total Costs for Department of Justice 0 466,966 0 0 1,694,057 2,161,023 Department of Public Instruction CECAS 2007 Hosting 2,354 0 0 0 0 2,354 Department of Public Instruction Child Nutrition Claims (CNC) 279,967 0 0 0 55,270 335,237 Page 50 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Public Instruction Child Nutrition Direct Certification and Verification 13,704 0 0 0 3,289 16,993 Department of Public Instruction Comprehensive Exceptional Children Accountability System (CECAS) Initiative 1,072,358 0 0 0 0 1,072,358 Department of Public Instruction DPI LAN Hardware and Wiring Upgrade 0 602 0 0 10,235 10,837 Department of Public Instruction eSIS 9.1 Upgrade 0 0 0 0 175,921 175,921 Department of Public Instruction K-Nect 1,929 0 247,650 0 14,257 263,836 Department of Public Instruction NC WISE - Enhancements 0 0 0 0 11,560 11,560 Department of Public Instruction NC WISE Wave 3 Deployment 0 0 0 0 139,315 139,315 Department of Public Instruction NCWISE Reporting 0 0 0 0 1,831,515 1,831,515 Department of Public Instruction NCWISE Wave 2 Deployment 0 0 0 0 2,796,010 2,796,010 Department of Public Instruction Online Educational Services for Student Achievement Improvement 209,000 0 0 0 13,496 222,496 Page 51 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Total Costs for Department of Public Instruction 1,579,312 602 247,650 0 5,050,868 6,878,432 Department of Revenue Motor Fuels Tracking System 0 0 0 1,162,439 0 1,162,439 Department of Revenue Online Filing and Payments Services 0 0 0 0 827,243 827,243 Total Costs for Department of Revenue 0 0 0 1,162,439 827,243 1,989,682 Department of the StateTreasurer Integrated Document Managemt System - Unclaimed Property Program (IDMS-UPP) 0 0 0 530,330 0 530,330 Department of the StateTreasurer Integrated Retirement System Planning 0 0 0 5,411,939 0 5,411,939 Total Costs for Department of the StateTreasurer 0 0 0 5,942,269 0 5,942,269 Department of Transportation 511 Traveler Information System Phase II 396,800 0 0 0 99,200 496,000 Department of Transportation Automated Testing System 0 0 0 0 810,904 810,904 Department of Transportation Customer Traffic Management System 0 0 0 0 209,662 209,662 Page 52 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Transportation Customer Traffic Management Systems Phase II 0 0 0 0 437,027 437,027 Department of Transportation Database Cleansing of Legacy Photo Images 0 0 0 0 406,160 406,160 Department of Transportation DMV Call Center Relocation 0 0 0 0 44,562 44,562 Department of Transportation DMV License Plate Recall 0 41,680 0 0 66,472 108,152 Department of Transportation Enterprise Web Portal and Executive Dashboard 265,492 0 0 0 499,796 765,288 Department of Transportation ERP 2005 Upgrade 15,748 0 0 0 10,715 26,463 Department of Transportation Facility Management Systems 130,760 13,190 0 0 212,307 356,257 Department of Transportation Fleet Documentation 32,680 0 0 0 43,503 76,183 Department of Transportation Grants in Contract Management (DBE) 46,811 0 0 0 86,935 133,746 Department of Transportation Greenfield Center Infrastructure 27,491 0 0 0 312,092 339,583 Page 53 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Department of Transportation HiCAMS Architecture Study 0 0 0 0 157,300 157,300 Department of Transportation IputAccel Upgrade R5.2 0 0 0 0 328,605 328,605 Department of Transportation IRP/MC & LITES Upgrades and Migration 0 0 0 0 26,592 26,592 Department of Transportation Maintenance Management System (MMS) Handheld Systems 129 0 0 0 17,353 17,482 Department of Transportation NCSmartlink 19,194 0 0 0 6,022 25,216 Department of Transportation Notice, Storage and Theft System 0 0 0 0 9,949 9,949 Department of Transportation Pavement Management System Project Phase 2 (Implementation) 535,568 0 0 0 1,249,653 1,785,221 Department of Transportation PreQualification Automation 144,430 0 0 0 193,532 337,962 Department of Transportation SDLC and Requirements Management 0 0 0 0 56,509 56,509 Total Costs for Department of Transportation 1,615,103 54,870 0 0 5,284,850 6,954,823 Page 54 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Employment Security Commission Initial Claims Call Center 773,173 0 0 0 0 773,173 Employment Security Commission UI Fraud & Identify Theft 35,734 0 0 0 0 35,734 Employment Security Commission VoIP Telephony Solution for ESC Unemployment Insurance Division, Central Office Complex 109,438 0 0 0 0 109,438 Total Costs for Employment Security Commission 918,345 0 0 0 0 918,345 NC Wildlife Resources Coastal Recreational Fishing License Implementation 0 0 0 490,285 0 490,285 NC Wildlife Resources Phase 4 Online Licensing and Vessel Registration Project 0 0 0 18,000 0 18,000 Total Costs for NC Wildlife Resources 0 0 0 508,285 0 508,285 Office of the State Auditor Non-Governmental Organization Grant Compliance - Business Intelligence & Data Warehouse 0 0 0 0 190,188 190,188 Total Costs for Office of the State Auditor 0 0 0 0 190,188 190,188 Office of the State Controller BEACON-HR/PAYROLL 0 0 0 0 23,880,847 23,880,847 Page 55 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Total Costs for Office of the State Controller 0 0 0 0 23,880,847 23,880,847 State Board of Elections ERAPP (e-Pollbooks) 0 0 0 0 11,500 11,500 State Board of Elections Voter Registration Server Upgrade 2,000 0 0 0 0 2,000 State Board of Elections Voting Equipment Upgrade HAVA ( Help America Vote Act ) 5,211,592 0 0 0 0 5,211,592 State Board of Elections WBET - WEB Based Elections Tools 0 0 0 0 2,750 2,750 Total Costs for State Board of Elections 5,213,592 0 0 0 14,250 5,227,842 Total Costs for Non-ITS 41,737,819 1,012,030 247,650 9,362,216 74,431,713 126,791,428 Page 56 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Office of Information Technology Services Electronic Document Management Service 0 0 0 0 228,882 228,882 Office of Information Technology Services Enterprise Service Access Point (ESAP) 0 0 0 1,113,686 0 1,113,686 Office of Information Technology Services Intrusion Prevention System (IPS) for State Infrastructure 0 0 0 13,480 0 13,480 Office of Information Technology Services IT Asset Management (ITAM) Project Phase 1 0 0 0 0 686,169 686,169 Office of Information Technology Services IT Consolidation Phase II - Industrial Commission 21,770 0 0 312,705 124,080 458,555 Office of Information Technology Services IT Consolidation Pilot Project 0 0 0 537,512 57,221 594,733 Office of Information Technology Services ITS On Boarding to Electronic Document Management Service 0 0 0 0 75,725 75,725 Office of Information Technology Services ITS SQA Shared Service 0 0 0 0 735,895 735,895 Office of Information Technology Services Managed Platform - Server Virtualization 0 0 0 815,974 171,717 987,691 Office of Information Technology Services OEP Culminating Phases 0 0 0 1,097,881 0 1,097,881 Page 57 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Office of Information Technology Services Operational Excellence Program Phase I 0 0 0 744,833 0 744,833 Office of Information Technology Services Phase 1 ITS Data Warehouse Shared Service 0 157,290 0 0 0 157,290 Office of Information Technology Services Polycom MGC-100 Video MCU Procurement 0 0 0 900 0 900 Office of Information Technology Services Remedy Service Desk Implementation 0 0 0 0 378,320 378,320 Office of Information Technology Services SDC - Capacity Back Up Mainframe 0 8,000 0 0 0 8,000 Office of Information Technology Services Security Information and Event Management (SIEM) Procurement & Implementation 0 0 0 369,600 0 369,600 Office of Information Technology Services Statewide Secondary Data Center 0 0 0 16,367,405 0 16,367,405 Office of Information Technology Services Upgrade of Disk Storage Infrastructure 0 0 0 2,469,460 0 2,469,460 Office of Information Technology Services Z9 Mainframe Upgrade 0 0 0 0 3,089,946 3,089,946 Total Costs for Office of Information Technology Services 21,770 165,290 0 23,843,436 5,547,955 29,578,451 Page 58 Agency Project Name Federal Funds Local Funds Non Federal Grants Receipts User Fees Appro-priations Total YTD Project Costs Table 6-2 Information Technology Expenditures - Projects By Source of Funds For the year ending June 30, 2007 Total Costs for ITS 21,770 165,290 0 23,843,436 5,547,955 29,578,451 Page 59 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Community Colleges System Office College Data Accounting System 9,034 0 0 1,802 4,618 0 15,454 Current GED System 5,155 0 0 1,622 4,608 0 11,385 Data Warehouse - 2 356,500 0 0 4,532 128,607 0 489,639 E-Leave (NCCCS) 0 0 0 180 911 0 1,091 Legacy GED System 0 0 3,743 0 0 0 3,743 SIRSI Library System 0 0 0 3,596 215,348 0 218,944 Total Costs for Community Colleges System Office 370,689 0 3,743 11,732 354,092 0 740,256 Department of Administration Applicant Tracking System - v1 DOA 6,800 0 0 0 0 0 6,800 APT Accounts Receivable 6,800 0 0 0 0 0 6,800 CAD Call Log 0 0 0 0 0 13,745 13,745 Courier Accounts Receivable 6,800 0 0 0 0 0 6,800 Courier Billing 6,800 0 0 0 0 0 6,800 DV & SA Statistical 6,800 0 0 0 0 0 6,800 Educational Talent Search 6,800 0 0 0 0 0 6,800 Energy Management Software 6,840 0 0 0 0 0 6,840 Federal Surplus Accounts Receivable DOA 6,800 0 0 0 0 0 6,800 Federal Surplus Property- Office DOA 12,000 0 0 0 0 0 12,000 Federal Surplus Property Sales DOA 6,800 0 0 0 0 0 6,800 Page 60 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Administration HUBSCO DOA 20,000 0 0 0 0 0 20,000 Interactive Purchasing and Vendor Link 20,000 0 0 0 0 0 20,000 Leave - DOA 6,800 0 0 0 0 0 6,800 Mail Center Billing - DOA 15,000 0 0 0 0 0 15,000 Mail List DOA 6,800 0 0 0 0 0 6,800 Motor Fleet Management DOA 0 230,400 0 80,000 0 0 310,400 MotorFleet Mgmt Travel Log 6,800 0 0 0 0 0 6,800 NC Motor Fleet System 13,600 0 0 0 0 0 13,600 NCDVA Scholarship Program 11,939 0 0 0 0 0 11,939 Personnel Management Information System 597,245 15,619 0 97,809 756,887 0 1,467,560 Phoenix Alarm Monitoring - DOA 2,707 0 0 0 0 0 2,707 Procurement Card DOA 6,800 0 0 0 0 0 6,800 Section 8 Housing 4,365 0 0 0 0 0 4,365 State Clearinghouse Intergovernmental Review Tracking 6,800 0 0 0 0 0 6,800 State Parking System 0 0 11,578 0 2,234 0 13,812 State Surplus Property DOA 30,000 0 0 0 0 0 30,000 Temporary Solution Accounts Receivable 6,800 0 0 0 0 0 6,800 Total Maintenance Management 6,000 0 0 0 0 0 6,000 Youth Registration System 6,800 0 0 0 0 0 6,800 Page 61 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 841,696 Total Costs for Department of Administration 246,019 11,578 177,809 759,121 13,745 2,049,968 Department of Agriculture and Consumer Services Agricultural Review System 1,400 0 0 0 0 0 1,400 Agronomic Lab Information System 63,200 32,000 250 4,100 0 0 99,550 Animal Health Programs Database (formerly NCHAMS) 8,400 0 0 0 0 0 8,400 Applicant Tracking 10,500 0 0 0 0 0 10,500 Aquatic Dealer Permit 700 0 0 0 0 0 700 Assessments System 6,720 0 30 0 0 0 6,750 Departmental Licensing System 61,600 0 3,200 0 0 0 64,800 Duplicating Services Chargeback System 15,400 0 20 0 0 0 15,420 F&V Terminal Market/Shipping Point 2,742 0 0 0 0 0 2,742 Feed Lab System 700 0 50 0 0 0 750 Feed Registration System 700 0 20 0 0 0 720 Feed Report System 700 0 10 0 0 0 710 Feed Tonnage System 700 0 20 0 0 0 720 Feed Transcript System 2,100 0 20 0 0 0 2,120 Fertilizer Lab System 700 0 25 0 0 0 725 Fertilizer Penalty System 700 0 10 0 0 0 710 Fertilizer Registration System 700 0 10 0 0 0 710 Page 62 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Agriculture and Consumer Services Fertilizer Tonnage System 1,400 0 20 0 0 0 1,420 Fertilizer Transcript System 700 0 10 0 0 0 710 Food Distribution Tracking System 69,000 26,271 0 0 0 0 95,271 FS Billing 6,763 0 0 0 0 0 6,763 Grain Grading Certificates 7,311 0 0 1,075 0 0 8,386 Horse Feed Assessments 1,120 0 0 0 0 0 1,120 Limestone Tonnage System 700 0 130 0 0 0 830 Market News Grain 2,520 0 0 0 0 0 2,520 Market News Livestock System 4,200 0 0 0 0 0 4,200 Market News Poultry System 2,240 0 0 0 0 0 2,240 Milled Peanut Certificates 11,516 0 884 6,450 0 0 18,850 Motor Fuel Registration System 2,800 0 250 0 0 0 3,050 Mountain State Fair Clogging, Mountain Music & Gospel Singing 2,100 0 0 0 0 0 2,100 Mountain State Fair Display Livestock 2,100 0 0 0 0 0 2,100 Mountain State Fair Div I&III 3,500 0 0 0 0 0 3,500 Mountain State Fair Exhibitor & Concessionaires 1,500 0 0 0 0 0 1,500 Mountain State Fair Flower & Garden 2,800 0 0 0 0 0 2,800 Mountain State Fair Livestock Show 3,500 0 0 0 0 0 3,500 Mountain State Fair Llama Show 2,100 0 0 0 0 0 2,100 Page 63 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Agriculture and Consumer Services Mountain State Fair Poultry & Pigeon Show 2,100 0 0 0 0 0 2,100 Mountain State Fair Rabbit Show 2,100 0 0 0 0 0 2,100 Multi-Hazard Threat database 24,000 0 0 37,000 1,000 0 62,000 NCForay (Cotton Boll Weevil Automated Acreage Assessment 0 1,248 0 0 0 0 1,248 Noxious Weed Phytosanitary Tracking State 700 0 0 0 0 0 700 Nursery Phytosanitary Tracking Federal 700 0 0 0 0 0 700 Nursery Phytosanitary Tracking State 700 0 0 0 0 0 700 Office Supplies Inventory System 700 0 20 0 0 0 720 Pesticide Inspector Activity System 700 0 0 0 0 0 700 Pesticide Recertification System 700 0 0 0 0 0 700 Pesticide Registration 28,000 0 400 0 0 0 28,400 Plant Conservation Permit Inspection Reporting System Online 650 0 0 0 0 0 650 Plant Conservation Permit Inspection Tracking System Online 1,350 0 0 0 0 0 1,350 Plant Conservation Permit Request System Online 2,050 0 0 0 0 0 2,050 Rhapsody 20,000 0 0 1,000 5,000 1,500 27,500 Seed Assessments System 4,200 0 0 0 0 0 4,200 Seed Germination Laboratory Information System 22,400 0 0 0 0 0 22,400 Seed Input Laboratory Information System 1,400 0 0 0 0 0 1,400 Seed Inspector Reporting System 7,000 0 0 0 0 0 7,000 Page 64 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Agriculture and Consumer Services Seed Planting Laboratory Information System 1,400 0 0 0 0 0 1,400 Seed Purity Laboratory Information System 11,200 0 0 0 0 0 11,200 Seed Reporting Laboratory Information System 15,400 0 0 0 0 0 15,400 Seed Tetrazolium Laboratory Information System 1,400 0 0 0 0 0 1,400 Soft Serve System 700 0 10 0 0 0 710 Standards Lab Scheduling System 10,350 0 0 0 0 0 10,350 State Fair Arts and Photo Exhibition 2,100 0 0 0 0 0 2,100 State Fair Entry System 1,400 0 0 0 0 0 1,400 State Fair Event Management System 3,080 0 0 0 0 0 3,080 State Fair Folk Festival 4,900 0 0 0 0 0 4,900 State Fair Livestock Exhibition 16,100 0 0 0 0 0 16,100 State Maillist System 1,400 0 30 0 0 0 1,430 Structural Pest Automated Inspection System 21,000 0 0 0 0 0 21,000 Structural Pest Control Inspection & Billing System 14,700 0 50 0 0 0 14,750 Structural Pest Control Recertification System 700 0 300 0 0 0 1,000 Temporary and Part-time Payroll System 2,800 0 0 0 0 0 2,800 Veterinary LIMS 95,000 0 0 65,500 51,000 0 211,500 Witchweed 1,400 0 0 0 0 0 1,400 WNC State Fair Event Management System 3,640 0 0 0 0 0 3,640 Page 65 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Total Costs for Department of Agriculture and Consumer 633,652 59,519 5,769 115,125 57,000 1,500 872,565 Services Department of Commerce 3m Core Grouping Inpatient Interactive Module 2,000 0 0 300 5,000 0 7,300 ABC Online(2) 0 43,275 0 5,221 16,309 0 64,805 ABC Permit System(2) 0 43,275 0 5,221 16,309 0 64,805 ABC Pricing System(2) 0 43,275 0 5,221 16,309 0 64,805 ABC Product Compliance System(2) 0 25,965 0 3,132 9,786 0 38,883 ABC Violation Tracking System(2) 0 17,310 0 2,088 6,524 0 25,922 Apptrack 7,252 0 0 1,539 659 0 9,450 Automated Time & Leave Accounting System (ATLAS) - v2 28,781 0 0 2,785 2,063 0 33,629 BLIO Consultant/Client Contact Tracking System 5,365 0 0 520 156 0 6,041 BLIO Permits/Licensing Information Management System 10,351 0 0 1,108 670 0 12,129 CDBG Grants Information System 42,193 0 0 265 39 0 42,497 Commerce Application Portfolio 15,593 0 0 2,488 1,859 0 19,940 Commerce CMS - Content Management System 6,381 0 0 375 789 0 7,545 Commerce Online Web Tools 42,604 0 0 1,756 2,108 0 46,468 Community Investment Reports 10,333 0 0 1,028 688 0 12,049 GroupWise - NCIC 40,000 0 752 1,000 1,000 0 42,752 Mainframe Host-on-Demand 80,000 66,212 81,602 1,000 1,000 0 229,814 Page 66 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Costs Table 6-3 Information Technology Expenditures - Applications For the year ending June 30, 2007 Department of Commerce Mediation 6,000 0 0 500 1,000 0 7,500 NCCOB Online 13,648 107,000 0 3,500 2,754 0 126,902 NCCOB Website 4,811 0 0 709 450 0 5,970 NCDWD FMIS Application 1,500 6,000 0 12,500 0 0 20,000 NCDWD Mobile Joblink Scheduling Application 28,861 0 0 400 542 0 29,803 NCDWD WIA Reporting Application For WF+ 50,000 0 0 0 0 0 50,000 NCDWD WorkforcePlus 40,000 0 40,000 25,000 0 0 105,000 NCIC Website Searchable Databases 6,000 0 0 500 400 0 6,900 PPD2 - Partial Permanent Disability 3,500 0 0 500 1,000 0 5,000 RightFax 15,000 0 0 2,500 1,800 0 19,300 Sites & Buildings 14,528 0 0 2,148 1,706 0 18,382 Track-It! 4,000 0 0 500 500 0 5,000 Web Based CDBG Accomplishments Reporting System 2,000 0 0 275 139 0 2,414 Total Costs for Department of Commerce 480,701 352,312 122,354 84,079 91,559 0 1,131,005 Department of Correction 7K Time and Leave 54,642 0 0 30,466 0 0 85,108 Applicant Tracking System 115,112 0 0 30,466 0 0 145,578 Business Information & Data System 136,500 0 0 106,636 0 0 243,136 Cashless on the Net 48,286 0 0 487,479 0 0 535,765 Page 67 Agency Application Name Internal Per |
OCLC number | 277228134 |