Information technology expenditures report : for the period ended... |
Previous | 1 of 13 | Next |
|
small (250x250 max)
medium (500x500 max)
large ( > 500x500)
Full Resolution
|
This page
All
Subset |
NORTH CAROLINA
INFORMATION
TECHNOLOGY
EXPENDITURES
REPORT
For the Period
Ended
June 30, 2011
Office of the State Controller
Office of Information Technology Services
Office of State Budget and Management
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
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 ................................................................................... 34
Table 6-2 IT Expenditures – Projects by Source of Funds ................................................... 47
Table 6-3 IT Expenditures – Applications ........................................................................... 62
Table 6-4 IT Expenditures – Applications by Source of Funds ......................................... 116
THIS PAGE INTENTIONALLY LEFT BLANK
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
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 project 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 NC 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 NC 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. Reporting at the project and
application level is not available for these exempt agencies since they do not provide this
information to ITS for inclusion in the Information Technology Portfolio Management
System.
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), the HR/Payroll System,
and the Information Technology Portfolio Management System. This report covers the time
period of July 2010 through June 2011 and includes all funding sources.
Overview of IT Expenditures
Total IT expenditures
(excluding ITS) were
$1,209,403,545 for fiscal
year 2011. IT
Expenditures for the
Office of Information
Technology totaled
$184,943,370 during the
same period.
BUDGETED SALARY
PLUS FRINGES
40.3%
PERSONAL
COMPUTER AND
PRINTER
6.2%
LOCAL AREA
NETWORK
2.3%
WIDE AREA
NETWORK
1.4%
VIDEO
TRANSMISSION
0.6%
SERVER
6.5%
MAINFRAME
9.1%
APPLICATIONS
DEVELOP AND OTHER
22.3%
TELECOMM
11.2%
Total Information Technology Expenditures
Excluding ITS
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
Page 2
As can be seen in this chart, Budgeted Salaries plus Fringes continue to be the largest
percentage of IT related expenditures at 40.3% of total IT expenditures.
The next largest categories of expenditures are Applications Development and Other
(22.3%), Telecommunications (11.2%), and Mainframe (9.1%). 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 and the HR/Payroll System.
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.
Employee training costs for IT personnel cannot be compiled or estimated using NCAS,
PMIS or the HR/Payroll System. These costs are not included in this report.
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.
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
Page 3
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. Non-personnel related costs for the
Department of Transportation are from the DOT financial system.
University EPA information as well as personnel position information for the NC Education
Lottery, NC Housing and Finance, and UNC Hospitals are provided by the agencies
themselves.
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
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. 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 $62
million. 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 UNC
System Agency 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. Total expenditures are calculated based on logic used to prepare the BD701-Agency
Management Budget Report. Intragovernmental transactions are not included in an effort to
avoid overstatement of total expenditures across funds.
The following ITS Programs are shown separately on this report: Information Technology
Fund, 911 Distribution, and the CGIA. These categories combined equal the ITS total as
reported on tables 1-1 and 1-2.
Page 5
Table 1-1 Information Technology Expenditures
for Year Ended June 30, 2011
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 164,906 45,962 0 0 0 0 23,292 0 54,594 288,754
Community Colleges System Office 5,435,718 77,919 50,293 275 1,557 7,290,317 36,666 1,337,750 4,585,422 18,815,917
Department of Administration 861,019 802,022 364,993 3,960 62,508 161,960 408,344 11,084,539 609,993 14,359,338
Department of Agriculture & Consumer Services 2,571,498 473,454 47,178 98,697 693 349,864 255,003 213,551 1,097,429 5,107,367
Department of Commerce 3,652,036 894,713 396,741 4,441 0 258,408 349,137 420,006 1,100,963 7,076,445
Department of Correction 11,738,065 3,684,490 113,183 17,419 9,991 802,827 13,534,374 285,859 9,071,959 39,258,167
Department of Crime Control & Public Safety 6,877,078 1,222,162 153,709 212,599 13,097 1,258,618 793,901 514,000 6,272,257 17,317,421
Department of Cultural Resources 633,591 262,748 360 0 0 0 10 1,353,502 1,091,606 3,341,817
Department of Environment & Natural
Resources 9,525,701 1,577,658 57,929 317,695 444 664,360 252,920 3,217,212 4,545,318 20,159,237
Department of Health and Human Services 33,285,079 5,486,109 2,784,726 217,415 4,020 5,282,058 21,147,142 118,307,053 11,296,888 197,810,490
Department of Insurance 1,799,970 353,976 0 34,706 0 290,262 19,555 109,515 313,991 2,921,975
Department of Justice 6,458,820 501,169 10,077 136,792 9,450 114,678 408,460 3,803,922 1,943,445 13,386,813
Department of Juvenile Justice & Delinq
Prevention 993,579 1,974,083 733,211 0 0 522,161 154,883 207,470 1,050,429 5,635,816
Department of Labor 804,799 283,710 7,559 44,357 0 46,906 7,450 28,175 334,980 1,557,936
Department of Public Instruction 13,066,409 632,074 4,578,564 6,060,125 1,826 2,268,442 1,446,183 4,911,288 3,660,509 36,625,420
Department of Revenue 9,462,284 311,908 126,876 48,414 0 1,593,210 7,899,615 18,388,609 2,402,403 40,233,319
Department of Secretary of State 945,426 146,281 48,862 39,978 0 102,543 68,903 30,804 128,305 1,511,102
Department of the State Treasurer 4,626,810 17,140 66,445 1,080 0 26,386 134,190 3,197,218 459,618 8,528,887
Department of Transportation 31,864,011 11,154,757 1,847,633 28,485 91,671 4,155,298 28,413,424 9,830,924 17,047,972 104,434,175
Employment Security Commission 9,752,487 1,174,416 862,481 3,757 0 2,019,417 3,775,877 1,620,588 7,219,094 26,428,117
NC Housing Finance Authority 952,797 0 0 0 0 0 3,642 1,415,942 81,382 2,453,763
NC School Science & Math 455,038 176,467 0 72,531 87,736 0 6,104 40,022 47,215 885,113
NC Wildlife Resources 1,670,273 240,902 15,126 321,057 0 126,570 353,380 163,730 1,233,410 4,124,448
Office of Administrative Hearings 79,874 42,765 56,413 0 0 5,486 37,898 0 21,745 244,181
Office of the Governor 1,003,628 196,898 397,244 1,239 0 887,928 310,398 1,692,465 146,129 4,635,929
Office of the Lieutenant Governor 0 13,945 16 0 0 3,884 0 6,164 17,248 41,257
Office of the State Auditor 651,419 114,787 14,932 0 0 80,004 86,916 205,700 45,861 1,199,619
Office of the State Controller 6,625,587 290,006 2,037,924 0 0 2,330,171 2,835,439 6,820,568 458,328 21,398,023
State Board of Elections 2,311,370 267,973 7,611 4,446 0 203,652 1,019 2,619 95,839 2,894,529
Total w/o AOC, Lottery, UNC System & ITS 168,269,272 32,420,494 14,780,086 7,669,468 282,993 30,845,410 82,764,125 189,209,195 76,434,332 602,675,375
Administrative Office of the Courts 23,125,557 3,775,984 21,377 1,969,950 249,636 1,460,265 9,215,000 4,022,492 5,853,087 49,693,348
NC Education Lottery 2,272,050 438,084 25,118 158,916 783 298,458 16,782 448,735 1,102,058 4,760,984
UNC System 293,870,701 38,450,380 12,947,907 7,695,411 6,296,739 46,270,147 17,987,756 76,293,420 52,461,378 552,273,839
Total Without ITS 487,537,579 75,084,942 27,774,488 17,493,745 6,830,151 78,874,280 109,983,663 269,973,842 135,850,855 1,209,403,545
Office of Information Technology Services 51,715,362 3,461,113 5,148,298 7,783,807 61,934 27,147,803 23,391,527 13,956,019 52,277,507 184,943,370
Page 6
INTERNAL
PERSONNEL
COSTS
EXTERNAL
PERSONNEL
COSTS
OTHER
EXTERNAL
COSTS
HARDWARE
COSTS
SOFTWARE
COSTS
OTHER
COSTS YTD TOTALS
Comprehensive Major Medical Plan 164,906 0 75,550 15,217 33,081 0 288,754
Community Colleges System Office 5,435,718 1,373,826 4,633,428 138,193 7,229,213 5,539 18,815,917
Department of Administration 861,019 808,656 12,224,588 25,362 412,776 26,937 14,359,338
Department of Agriculture & Consumer Services 2,571,498 63,202 1,496,916 542,568 386,670 46,513 5,107,367
Department of Commerce 3,652,036 1,010,250 1,781,256 262,945 322,037 47,921 7,076,445
Department of Correction 11,738,065 0 18,724,125 7,054,373 1,608,451 133,153 39,258,167
Department of Crime Control & Public Safety 6,877,078 14,128 4,324,961 4,739,579 1,324,391 37,284 17,317,421
Department of Cultural Resources 633,591 1,354,169 1,015,003 224,392 114,047 615 3,341,817
Department of Environment & Natural Resources 9,525,701 2,053,728 3,967,662 2,837,670 1,543,366 231,110 20,159,237
Department of Health and Human Services 33,285,079 117,181,042 35,110,141 5,593,871 5,187,199 1,453,158 197,810,490
Department of Insurance 1,799,970 43,402 413,847 374,607 224,111 66,038 2,921,975
Department of Justice 6,458,820 817,313 2,126,820 1,360,924 2,452,636 170,300 13,386,813
Department of Juvenile Justice & Delinq Prevention 993,579 2,574,393 1,814,482 73,275 81,562 98,525 5,635,816
Department of Labor 804,799 1,200 431,321 231,423 84,836 4,357 1,557,936
Department of Public Instruction 13,066,409 4,299,979 9,516,198 1,025,260 8,557,621 159,953 36,625,420
Department of Revenue 9,462,284 17,705,026 10,236,142 1,255,646 1,387,899 186,322 40,233,319
Department of Secretary of State 945,426 12,104 162,367 234,064 157,141 0 1,511,102
Department of the State Treasurer 4,626,810 121,830 653,005 1,424,519 1,696,428 6,295 8,528,887
Department of Transportation 31,864,011 12,342,712 43,195,559 7,895,411 8,278,242 858,240 104,434,175
Employment Security Commission 9,752,487 1,402,785 11,097,623 2,872,047 1,303,175 0 26,428,117
NC Housing Finance Authority 952,797 930,371 85,024 347,519 102,776 35,276 2,453,763
NC School Science & Math 455,038 19,300 52,119 231,467 127,189 0 885,113
NC Wildlife Resources 1,670,273 204,509 1,086,488 1,005,768 126,126 31,284 4,124,448
Office of Administrative Hearings 79,874 45,633 116,056 2,385 233 0 244,181
Office of the Governor 1,003,628 1,886,587 890,433 8,496 846,785 0 4,635,929
Office of the Lieutenant Governor 0 18,961 21,148 733 0 415 41,257
Office of the State Auditor 651,419 22,104 132,777 217,880 175,439 0 1,199,619
Office of the State Controller 6,625,587 7,231,343 4,899,673 23,818 2,611,099 6,503 21,398,023
State Board of Elections 2,311,370 7,611 189,825 287,149 96,453 2,121 2,894,529
Total w/o AOC, Lottery, UNC System & ITS 168,269,272 173,546,164 170,474,537 40,306,561 46,470,982 3,607,859 602,675,375
Administrative Office of the Courts 23,125,557 3,966,343 6,337,340 7,331,235 8,744,824 188,049 49,693,348
NC Education Lottery 2,272,050 163,323 1,120,549 916,371 240,799 47,892 4,760,984
UNC System 293,870,701 10,347,445 67,376,480 99,407,350 63,056,520 18,215,343 552,273,839
Total Without ITS 487,537,579 188,023,275 245,308,906 147,961,517 118,513,125 22,059,143 1,209,403,545
Office of Information Technology Services 51,715,362 6,772,585 62,362,663 21,061,200 42,989,212 42,348 184,943,370
Table 1-2 Information Technology Expenditures
Grouped According to IT Portfolio Management System Detail Cost Categories
for Year Ended June 30, 2011
Page 7
Table 1-3 Information Technology Expenditures
UNC System Agencies
for Year Ended June 30, 2011
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 12,935,342 435,182 0 495,690 0 695,966 33,088 7,758,404 995,801 23,349,473
East Carolina University 24,188,571 4,676,899 1,439,236 135,030 1,465,053 9,529,406 161,083 7,833,930 2,120,100 51,549,308
Elizabeth City State University 2,252,236 383,960 38,596 10,576 11,129 200,266 0 1,434,481 418,609 4,749,853
Fayetteville State University 2,362,656 700,271 728,203 127,942 8,556 542,846 144,782 1,503,178 551,002 6,669,436
NC A&T State University 7,110,352 154,441 2,663,360 402,626 204,526 554,145 11,167 2,216,924 731,846 14,049,387
NC Central University 6,264,898 0 0 1,320,256 949,401 0 0 3,982,037 1,377,680 13,894,272
NC School of Arts 1,099,255 615,160 213,168 304,127 86,743 234,282 285,931 490,170 291,385 3,620,221
NC State University 49,080,568 12,865,255 3,960,668 2,787,290 2,514,334 14,525,909 2,046,522 6,145,615 11,770,295 105,696,456
UNC Asheville 2,504,340 966,919 59,072 27,492 4,841 520,113 70,282 245,853 395,013 4,793,925
UNC Chapel Hill 97,476,428 22,450 101,432 753,291 120,622 124,414 6,947,327 25,356,249 14,528,079 145,430,292
UNC Charlotte 20,038,802 5,436,384 1,128,150 259,170 430,484 2,136,728 112,929 6,128,113 4,338,766 40,009,526
UNC General Administration 6,456,286 253,215 37,083 820,160 7,646 1,084,336 5,951,362 637,565 509,818 15,757,471
UNC Greensboro 15,579,740 6,113,901 257,127 59,107 3,773 1,246,476 95,005 4,350,880 2,737,964 30,443,973
UNC Hospital 21,323,131 430,553 329,997 17,153 27,157 8,064,352 1,542,820 1,006,317 4,079,432 36,820,912
UNC Pembroke 3,499,365 1,112,163 315,300 5,450 7,088 694,399 72,109 1,080,654 502,117 7,288,645
UNC Wilmington 9,907,495 1,836,665 637,658 70,922 351,751 2,928,079 30,762 1,565,598 4,498,457 21,827,387
Western Carolina University 6,695,228 764,323 683,547 50,562 41,799 1,377,278 112,250 1,888,956 1,225,658 12,839,601
Winston-Salem State University 5,096,008 1,682,639 355,310 48,567 61,836 1,811,152 370,337 2,668,496 1,389,356 13,483,701
TOTAL UNC System 293,870,701 38,450,380 12,947,907 7,695,411 6,296,739 46,270,147 17,987,756 76,293,420 52,461,378 552,273,839
Page 8
Total IT
Expenditures
Total
Expenditures
% IT
Expenditures to
Total
Expenditures
Comprehensive Major Medical Plan 288,754 2,649,596,840 0.01%
Community Colleges System Office 18,815,917 1,419,037,452 1.33%
Department of Administration 14,359,338 203,839,847 7.04%
Department of Agriculture & Consumer Services 5,107,367 151,661,567 3.37%
Department of Commerce 7,076,445 494,791,546 1.43%
Department of Correction 39,258,167 1,564,236,989 2.51%
Department of Crime Control & Public Safety 17,317,421 424,869,023 4.08%
Department of Cultural Resources 3,341,817 106,977,925 3.12%
Department of Environment & Natural Resources 20,159,237 790,975,871 2.55%
Department of Health and Human Services 197,810,490 16,985,938,261 1.16%
Department of Insurance 2,921,975 108,662,969 2.69%
Department of Justice 13,386,813 137,957,203 9.70%
Department of Juvenile Justice & Delinq Prevention 5,635,816 161,059,509 3.50%
Department of Labor 1,557,936 29,299,505 5.32%
Department of Public Instruction 36,625,420 10,101,428,409 0.36%
Department of Revenue 40,233,319 161,730,620 24.88%
Department of Secretary of State 1,511,102 13,299,109 11.36%
Department of the State Treasurer 8,528,887 966,005,977 0.88%
Department of Transportation 104,434,175 4,456,425,371 2.34%
Employment Security Commission 26,428,117 4,594,397,545 0.58%
NC Housing Finance Authority 2,453,763 168,462,040 1.46%
NC School Science & Math 885,113 20,121,305 4.40%
NC Wildlife Resources 4,124,448 78,281,987 5.27%
Office of Administrative Hearings 244,181 5,985,561 4.08%
Office of the Governor 4,635,929 1,083,350,260 0.43%
Office of the Lieutenant Governor 41,257 890,047 4.64%
Office of the State Auditor 1,199,619 16,099,660 7.45%
Office of the State Controller 21,398,023 33,439,644 63.99%
State Board of Elections 2,894,529 16,196,752 17.87%
Total w/o AOC, Lottery, UNC System & ITS 602,675,375 46,945,018,798 1.28%
Administrative Office of the Courts 49,693,348 612,900,146 8.11%
NC Education Lottery 4,760,984 1,027,157,424 0.46%
UNC System 552,273,839 11,835,462,512 4.67%
Total Without ITS 1,209,403,545 60,420,538,880 2.00%
Office of Information Technology Services 176,545,817 188,472,280 93.67%
Information Technology Fund 6,955,007 7,072,524 98.34%
E911 Board 211,789 82,357,657 0.26%
CGIA 1,230,758 1,709,515 71.99%
Table 1-4 Percentage of IT Expenditures to Total Expenditures
for Year Ended June 30, 2011
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
Page 9
Expenditure Summary by Budget Code Type
While Table 1-1 shows all IT expenditures for the fiscal year, 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 $718,009,856.5 59.37%
All Other Budget Codes $491,393,688.5 40.63%
Total of all Budget Codes $ 1,209,403,545 100.00%
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.
Page 10
Table 2-1 Information Technology Expenditures for General Fund Budget Codes
for Year Ended June 30, 2011
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,435,718 77,919 50,293 275 1,557 6,626,312 36,666 1,233,472 4,585,422 18,047,634
Department of Administration 861,019 479,079 212,671 2,159 39,108 131,263 269,500 180,481 437,387 2,612,667
Department of Agriculture & Consumer Services 2,443,123 442,896 47,018 94,829 693 334,822 61,267 198,925 739,713 4,363,286
Department of Commerce 1,941,201 515,369 131,636 2,083 0 117,767 133,867 97,527 659,849 3,599,299
Department of Correction 10,929,392 3,477,800 106,441 71 5,963 802,827 13,534,374 203,728 8,947,058 38,007,654
Department of Crime Control & Public Safety 1,519,966 276,283 36,374 45,821 13,097 385,327 56,426 262,898 1,434,527 4,030,719
Department of Cultural Resources 633,591 256,636 360 0 0 0 10 1,353,502 1,011,215 3,255,314
Department of Environment & Natural Resources 7,902,158 1,254,942 37,163 303,223 276 589,233 203,410 2,130,117 3,386,796 15,807,318
Department of Health and Human Services 29,642,043 4,788,967 2,081,378 217,370 4,020 3,537,913 20,781,272 74,693,005 10,831,536 146,577,504
Department of Insurance 1,799,970 346,895 0 34,351 0 289,067 19,555 90,026 305,369 2,885,233
Department of Justice 6,458,820 398,582 4,677 135,818 4,851 98,550 8,038 2,616,637 1,724,356 11,450,329
Department of Juvenile Justice & Delinq
Prevention 993,579 1,941,166 730,058 0 0 505,857 154,883 92,515 1,039,044 5,457,102
Department of Labor 804,799 283,710 7,559 44,357 0 46,906 7,450 28,175 334,980 1,557,936
Department of Public Instruction 13,066,409 630,688 4,328,107 6,034,870 1,826 2,260,490 1,402,330 4,426,882 3,658,037 35,809,639
Department of Revenue 9,462,284 288,722 107,516 47,457 0 1,069,755 7,133,568 715,003 2,371,687 21,195,992
Department of Secretary of State 945,426 110,883 41,602 39,978 0 101,450 27,206 18,697 108,639 1,393,881
Department of the State Treasurer 4,626,810 0 62,624 493 0 1,504 134,190 3,056,064 425,552 8,307,237
Department of Transportation 0 0 0 0 0 0 0 0 0 0
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 343,936 176,467 0 72,531 87,736 0 6,104 40,022 47,215 774,011
NC Wildlife Resources 0 0 0 0 0 0 0 0 0 0
Office of Administrative Hearings 79,874 42,765 56,413 0 0 5,486 37,898 0 21,745 244,181
Office of the Governor 1,003,628 196,298 394,946 1,229 0 882,170 309,920 1,690,863 144,892 4,623,946
Office of the Lieutenant Governor 0 13,945 16 0 0 3,884 0 6,164 17,248 41,257
Office of the State Auditor 651,419 114,787 14,932 0 0 80,004 86,916 205,700 45,861 1,199,619
Office of the State Controller 5,054,719 269,555 1,121,212 0 0 2,284,345 2,835,439 31,087 432,448 12,028,805
State Board of Elections 2,311,370 159,334 7,611 4,446 0 168,923 1,019 2,619 95,839 2,751,161
Total w/o AOC, Lottery, UNC System & ITS 108,911,254 16,543,688 9,580,607 7,081,361 159,127 20,323,855 47,241,308 93,374,109 42,806,415 346,021,724
Administrative Office of the Courts 20,361,468 2,807,227 21,377 1,969,931 248,536 1,460,265 8,032,371 1,171,297 4,344,478 40,416,950
NC Education Lottery 0 0 0 0 0 0 0 0 0 0
UNC System 167,946,285 30,212,758 8,766,228 5,087,937 3,241,690 32,506,970 9,788,928 51,773,414 22,246,973 331,571,183
Total Without ITS 297,219,007 49,563,673 18,368,212 14,139,229 3,649,353 54,291,090 65,062,607 146,318,820 69,397,866 718,009,857
Office of Information Technology Services 0 0 0 0 0 0 0 0 0 0
Page 11
Table 2-2 Information Technology Expenditures for All Other Budget Codes
for Year Ended June 30, 2011
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 164,906 45,962 0 0 0 0 23,292 0 54,594 288,754
Community Colleges System Office 0 0 0 0 0 664,005 0 104,278 0 768,283
Department of Administration 0 322,943 152,322 1,801 23,400 30,697 138,844 10,904,058 172,606 11,746,671
Department of Agriculture & Consumer Services 128,375 30,558 160 3,868 0 15,042 193,736 14,626 357,716 744,081
Department of Commerce 1,710,835 379,344 265,105 2,358 0 140,641 215,270 322,479 441,114 3,477,146
Department of Correction 808,672 206,690 6,742 17,348 4,028 0 0 82,131 124,901 1,250,512
Department of Crime Control & Public Safety 5,357,112 945,879 117,335 166,778 0 873,291 737,475 251,102 4,837,730 13,286,702
Department of Cultural Resources 0 6,112 0 0 0 0 0 0 80,391 86,503
Department of Environment & Natural Resources 1,623,544 322,716 20,766 14,472 168 75,127 49,510 1,087,095 1,158,522 4,351,920
Department of Health and Human Services 3,643,036 697,142 703,348 45 0 1,744,145 365,870 43,614,048 465,352 51,232,986
Department of Insurance 0 7,081 0 355 0 1,195 0 19,489 8,622 36,742
Department of Justice 0 102,587 5,400 974 4,599 16,128 400,422 1,187,285 219,089 1,936,484
Department of Juvenile Justice & Delinq
Prevention 0 32,917 3,153 0 0 16,304 0 114,955 11,385 178,714
Department of Labor 0 0 0 0 0 0 0 0 0 0
Department of Public Instruction 0 1,386 250,457 25,255 0 7,952 43,853 484,406 2,472 815,781
Department of Revenue 0 23,186 19,360 957 0 523,455 766,047 17,673,606 30,716 19,037,327
Department of Secretary of State 0 35,398 7,260 0 0 1,093 41,697 12,107 19,666 117,221
Department of the State Treasurer 0 17,140 3,821 587 0 24,882 0 141,154 34,066 221,650
Department of Transportation 31,864,011 11,154,757 1,847,633 28,485 91,671 4,155,298 28,413,424 9,830,924 17,047,972 104,434,175
Employment Security Commission 9,752,487 1,174,416 862,481 3,757 0 2,019,417 3,775,877 1,620,588 7,219,094 26,428,117
NC Housing Finance Authority 952,797 0 0 0 0 0 3,642 1,415,942 81,382 2,453,763
NC School Science & Math 111,101 0 0 0 0 0 0 0 0 111,101
NC Wildlife Resources 1,670,273 240,902 15,126 321,057 0 126,570 353,380 163,730 1,233,410 4,124,448
Office of Administrative Hearings 0 0 0 0 0 0 0 0 0 0
Office of the Governor 0 600 2,298 10 0 5,758 478 1,602 1,237 11,983
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 1,570,868 20,451 916,712 0 0 45,826 0 6,789,481 25,880 9,369,218
State Board of Elections 0 108,639 0 0 0 34,729 0 0 0 143,368
Total w/o AOC, Lottery, UNC System & ITS 59,358,017 15,876,806 5,199,479 588,107 123,866 10,521,555 35,522,817 95,835,086 33,627,917 256,653,650
Administrative Office of the Courts 2,764,090 968,757 0 19 1,100 0 1,182,629 2,851,195 1,508,609 9,276,399
NC Education Lottery 2,272,050 438,084 25,118 158,916 783 298,458 16,782 448,735 1,102,058 4,760,984
UNC System 125,924,416 8,237,622 4,181,679 2,607,474 3,055,049 13,763,177 8,198,828 24,520,006 30,214,405 220,702,656
Total Without ITS 190,318,573 25,521,269 9,406,276 3,354,516 3,180,798 24,583,190 44,921,056 123,655,022 66,452,989 491,393,689
Office of Information Technology Services 51,715,362 3,461,113 5,148,298 7,783,807 61,934 27,147,803 23,391,527 13,956,019 52,277,507 184,943,370
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
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 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.
Table 3-2 Information Technology Expenditures – Current Year versus Prior Year provides a
comparison to prior year expenditures.
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.
Page 13
ANNUAL
BUDGETED
SALARY
AUTHORIZED
BUDGET
NON_SALARY
ACCOUNTS
TOTAL BUDGET
ESTIMATE YTD ACTUAL
ACTUAL as
% of
BUDGET
Comprehensive Major Medical Plan 164,906 143,657 308,563 288,754 93.58%
Community Colleges System Office 5,435,718 16,210,417 21,646,135 18,815,917 86.93%
Department of Administration 861,019 20,901,776 21,762,795 14,359,338 65.98%
Department of Agriculture & Consumer Services 2,571,498 2,800,910 5,372,408 5,107,367 95.07%
Department of Commerce 3,652,036 5,717,747 9,369,783 7,076,445 75.52%
Department of Correction 11,738,065 27,889,002 39,627,067 39,258,167 99.07%
Department of Crime Control & Public Safety 6,877,078 20,179,830 27,056,908 17,317,421 64.00%
Department of Cultural Resources 633,591 2,898,598 3,532,189 3,341,817 94.61%
Department of Environment & Natural Resources 9,525,701 13,397,640 22,923,341 20,159,237 87.94%
Department of Health and Human Services 33,285,079 199,080,763 232,365,842 197,810,490 85.13%
Department of Insurance 1,799,970 1,532,386 3,332,356 2,921,975 87.68%
Department of Justice 6,458,820 8,214,897 14,673,717 13,386,813 91.23%
Department of Juvenile Justice & Delinq Prevention 993,579 5,280,001 6,273,580 5,635,816 89.83%
Department of Labor 804,799 1,733,562 2,538,361 1,557,936 61.38%
Department of Public Instruction 13,066,409 50,154,697 63,221,106 36,625,420 57.93%
Department of Revenue 9,462,284 53,150,284 62,612,568 40,233,319 64.26%
Department of Secretary of State 945,426 738,781 1,684,207 1,511,102 89.72%
Department of the State Treasurer 4,626,810 4,691,732 9,318,542 8,528,887 91.53%
Employment Security Commission 9,752,487 22,939,007 32,691,494 26,428,117 80.84%
NC Housing Finance Authority 952,797 1,666,040 2,618,837 2,453,763 93.70%
NC School Science & Math 455,038 459,552 914,590 885,113 96.78%
NC Wildlife Resources 1,670,273 2,947,584 4,617,857 4,124,448 89.32%
Office of Administrative Hearings 79,874 613,443 693,317 244,181 35.22%
Office of the Governor 1,003,628 9,606,156 10,609,784 4,635,929 43.69%
Office of the Lieutenant Governor 0 47,036 47,036 41,257 87.71%
Office of the State Auditor 651,419 612,897 1,264,316 1,199,619 94.88%
Office of the State Controller 6,625,587 15,618,563 22,244,150 21,398,023 96.20%
State Board of Elections 2,311,370 3,543,627 5,854,997 2,894,529 49.44%
Total w/o DOT, AOC, Lottery, UNC System & ITS 136,405,260 492,770,585 629,175,845 498,241,199 79.19%
Administrative Office of the Courts 23,125,557 27,490,532 50,616,089 49,693,348 98.18%
NC Education Lottery 2,272,050 4,425,938 6,697,988 4,760,984 71.08%
Total Without DOT, UNC System & ITS 161,802,867 524,687,055 686,489,922 552,695,531 80.51%
Office of Information Technology Services 51,715,362 139,174,182 190,889,544 184,943,370 96.89%
Table 3-1 Information Technology Expenditures - Budget to Actual Comparison
for Year Ended June 30, 2011
Page 14
Current Year
Expenditures at
06/30/11
Prior Year
Expenditures at
06/30/10
Increase /
(Decrease) % Change
Comprehensive Major Medical Plan 288,754 278,932 9,823 3.52%
Community Colleges System Office 18,815,917 11,974,433 6,841,484 57.13%
Department of Administration 14,359,338 3,279,904 11,079,434 337.80%
Department of Agriculture & Consumer Services 5,107,367 5,040,466 66,901 1.33%
Department of Commerce 7,076,445 6,644,356 432,089 6.50%
Department of Correction 39,258,167 38,892,829 365,338 0.94%
Department of Crime Control & Public Safety 17,317,421 20,400,897 (3,083,476) -15.11%
Department of Cultural Resources 3,341,817 3,332,891 8,927 0.27%
Department of Environment & Natural Resources 20,159,237 17,841,999 2,317,239 12.99%
Department of Health and Human Services 197,810,490 182,605,485 15,205,005 8.33%
Department of Insurance 2,921,975 3,007,894 (85,919) -2.86%
Department of Justice 13,386,813 13,997,393 (610,580) -4.36%
Department of Juvenile Justice & Delinq Prevention 5,635,816 3,547,687 2,088,128 58.86%
Department of Labor 1,557,936 1,598,787 (40,851) -2.56%
Department of Public Instruction 36,625,420 38,474,026 (1,848,606) -4.80%
Department of Revenue 40,233,319 33,437,307 6,796,012 20.32%
Department of Secretary of State 1,511,102 1,453,911 57,192 3.93%
Department of the State Treasurer 8,528,887 8,772,208 (243,321) -2.77%
Department of Transportation 104,434,175 91,357,049 13,077,127 14.31%
Employment Security Commission 26,428,117 28,392,334 (1,964,217) -6.92%
NC Housing Finance Authority 2,453,763 1,854,157 599,606 32.34%
NC School Science & Math 885,113 618,000 267,112 43.22%
NC Wildlife Resources 4,124,448 3,782,219 342,229 9.05%
Office of Administrative Hearings 244,181 237,137 7,044 2.97%
Office of the Governor 4,635,929 3,618,593 1,017,336 28.11%
Office of the Lieutenant Governor 41,257 47,294 (6,037) -12.76%
Office of the State Auditor 1,199,619 1,360,510 (160,891) -11.83%
Office of the State Controller 21,398,023 21,062,846 335,176 1.59%
State Board of Elections 2,894,529 3,443,200 (548,671) -15.93%
Total w/o AOC, Lottery, UNC System & ITS 602,675,375 550,354,743 52,320,632 9.51%
Administrative Office of the Courts 49,693,348 58,479,108 (8,785,759) -15.02%
NC Education Lottery 4,760,984 4,659,082 101,902 2.19%
UNC System 552,273,839 516,910,115 35,363,724 6.84%
Total Without ITS 1,209,403,545 1,130,403,047 79,000,498 6.99%
Office of Information Technology Services 184,943,370 189,942,710 (4,999,339) -2.63%
Table 3-2 Information Technology Expenditures - Current Year Versus Prior Year
for Years Ended June 30, 2011 and June 30, 2010
Page 15
Current Year
Expenditures at
06/30/11
Prior Year
Expenditures at
06/30/10
Increase /
(Decrease) % Change
Appalachian State University 23,349,473 21,047,852 2,301,621 10.94%
East Carolina University 51,549,308 44,855,094 6,694,214 14.92%
Elizabeth City State University 4,749,853 4,628,816 121,037 2.61%
Fayetteville State University 6,669,436 6,729,385 (59,949) -0.89%
NC A&T State University 14,049,387 15,302,346 (1,252,959) -8.19%
NC Central University 13,894,272 11,562,627 2,331,645 20.17%
NC School of Arts 3,620,221 3,726,455 (106,234) -2.85%
NC State University 105,696,456 95,038,137 10,658,320 11.21%
UNC Asheville 4,793,925 4,579,666 214,259 4.68%
UNC Chapel Hill 145,430,292 143,461,859 1,968,434 1.37%
UNC Charlotte 40,009,526 36,220,943 3,788,583 10.46%
UNC General Administration 15,757,471 14,511,021 1,246,450 8.59%
UNC Greensboro 30,443,973 33,306,369 (2,862,396) -8.59%
UNC Hospital 36,820,912 30,793,632 6,027,280 19.57%
UNC Pembroke 7,288,645 9,357,857 (2,069,212) -22.11%
UNC Wilmington 21,827,387 18,738,562 3,088,825 16.48%
Western Carolina University 12,839,601 12,771,298 68,303 0.53%
Winston-Salem State University 13,483,701 10,278,197 3,205,504 31.19%
TOTAL UNC System 552,273,839 516,910,115 35,363,724 6.84%
Table 3-3 Information Technology Expenditures - Current Year Versus Prior Year
for Years Ended June 30, 2011 and June 30, 2010
UNC System Agencies
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
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
Table 4-1 Information Technology Related Contracted Personal Services
for Year Ended June 30, 2011
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
Community Colleges System Office 0 41,915 0 0 0 0 1,331,911 0 1,373,826
Department of Administration 550,233 30,028 0 0 26,735 0 201,660 0 808,656
Department of Agriculture & Consumer Services 0 0 0 0 26,123 0 37,079 0 63,202
Department of Commerce 712,052 54,957 0 0 0 0 243,241 0 1,010,250
Department of Correction 0 0 0 0 0 0 0 0 0
Department of Crime Control & Public Safety 2,834 5,796 0 0 5,498 0 0 0 14,128
Department of Cultural Resources 4,100 0 0 0 0 0 1,350,069 0 1,354,169
Department of Environment & Natural Resources 0 12,864 0 0 0 720 2,040,144 0 2,053,728
Department of Health and Human Services 70 999,509 0 2,230 6,170 0 116,173,063 0 117,181,042
Department of Insurance 0 0 0 0 0 0 43,402 0 43,402
Department of Justice 0 0 0 0 0 0 817,313 0 817,313
Department of Juvenile Justice & Delinq
Prevention 1,884,157 397,998 0 0 187,568 0 104,670 0 2,574,393
Department of Labor 0 0 0 0 0 0 1,200 0 1,200
Department of Public Instruction 0 161,119 0 0 0 0 4,138,860 0 4,299,979
Department of Revenue 0 0 0 0 0 0 17,705,026 0 17,705,026
Department of Secretary of State 0 12,104 0 0 0 0 0 0 12,104
Department of the State Treasurer 16,815 30,092 0 0 0 0 74,923 0 121,830
Department of Transportation 3,563,573 361,036 0 0 216,421 1,428,838 6,772,843 0 12,342,711
Employment Security Commission 0 37,290 0 0 0 0 1,365,495 0 1,402,785
NC Housing Finance Authority 0 0 0 0 0 0 930,371 0 930,371
NC School Science & Math 0 0 19,300 0 0 0 0 0 19,300
NC Wildlife Resources 0 0 155,037 0 0 0 49,472 0 204,509
Office of Administrative Hearings 40,380 0 0 0 5,253 0 0 0 45,633
Office of the Governor 191,824 2,298 0 0 0 0 1,692,465 0 1,886,587
Office of the Lieutenant Governor 13,212 0 0 0 0 0 5,749 0 18,961
Office of the State Auditor 0 0 0 0 0 0 22,104 0 22,104
Office of the State Controller 292,263 21,176 0 0 104,787 0 6,813,117 0 7,231,343
State Board of Elections 0 7,611 0 0 0 0 0 0 7,611
Total w/o AOC, Lottery, UNC System & ITS 7,271,513 2,175,793 174,337 2,230 578,555 1,429,558 161,914,177 0 173,546,163
Administrative Office of the Courts 434,010 0 0 0 0 0 3,532,333 0 3,966,343
NC Education Lottery 0 0 71,813 0 28,111 0 63,399 0 163,323
UNC System 132,327 260,160 154,392 32,539 1,695,758 267,167 7,805,102 0 10,347,445
Total Without ITS 7,837,850 2,435,953 400,542 34,769 2,302,424 1,696,725 173,315,011 0 188,023,274
Office of Information Technology Services 916,471 122,558 215,567 0 0 0 5,517,989 0 6,772,585
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 50 0 0 0 6,604 0 6,654
East Carolina University 43,035 217,811 91,294 17,053 1,211,437 0 1,301,630 0 2,882,260
Elizabeth City State University 0 0 0 0 0 0 0 0 0
Fayetteville State University -3,112 1,188 130 396 2,067 144,087 2,049 0 146,805
NC A&T State University 0 1,000 0 0 0 1,993 12,844 0 15,837
NC Central University 0 0 0 0 0 0 0 0 0
NC School of Arts 0 0 0 0 0 0 105 0 105
NC State University 10,503 4,623 38,534 12,090 59,022 0 1,135,925 0 1,260,697
UNC Asheville 0 0 0 0 67,643 0 174,069 0 241,712
UNC Chapel Hill 0 0 0 0 0 0 2,088,057 0 2,088,057
UNC Charlotte 9,300 1,038 0 1,000 60 0 276,468 0 287,866
UNC General Administration 0 29,850 17,082 2,000 12,260 0 1,845 0 63,037
UNC Greensboro 1,363 0 0 0 236 354 11,373 0 13,326
UNC Hospital 69,174 900 0 0 292,077 120,733 764,942 0 1,247,826
UNC Pembroke 0 0 0 0 956 0 255,280 0 256,236
UNC Wilmington 0 0 0 0 0 0 30,366 0 30,366
Western Carolina University 2,064 3,750 7,302 0 0 0 5,939 0 19,055
Winston-Salem State University 0 0 0 0 50,000 0 1,737,606 0 1,787,606
TOTAL UNC System 132,327 260,160 154,392 32,539 1,695,758 267,167 7,805,102 0 10,347,445
Table 4-2 Information Technology Related Contracted Personal Services
UNC System Agencies
for Year Ended June 30, 2011
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
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 the HR/Payroll System as well as PMIS and include both vacant and
filled IT positions. A position is identified as IT related based on the position's class code.
NC Housing and Finance and the NC Education Lottery provide information for the report
that is not available in either of these systems.
Table 5-2 Salary and Calculated Fringes for All IT Positions-UNC System Agencies lists by
UNC System Agency the same information described above. Some of these agencies are not
required to enter all of their position information in PMIS. The additional needed
information has been provided by them and is incorporated into the report.
Actual fringe benefit amounts are not available but an estimate is calculated in these tables
based on the following criteria:
OASDI – 6.2% of budgeted salary amount capped at $106,800 per FTE
HI – 1.45% of budgeted salary amount
Retirement – 10.51% of budgeted salary amount
Hospitalization – $4,929.60 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
Table 5-1 Salary and Calculated Fringes for All IT Positions
Annual Budgeted Salary
as reported June 30, 2011
TOTAL
FTE'S
ANNUAL
BUDGETED
SALARY OASDI HI RETIRE HOSPITAL TOTAL
AVERAGE
PER FTE
Comprehensive Major Medical Plan 2.00 131,218 8,136 1,903 13,791 9,859 164,906 82,453
Community Colleges System Office 64.00 4,333,722 268,188 62,839 455,474 315,494 5,435,718 84,933
Department of Administration 11.00 682,797 42,333 9,901 71,762 54,226 861,019 78,274
Department of Agriculture & Consumer Services 34.00 2,034,438 126,135 29,499 213,819 167,606 2,571,498 75,632
Department of Commerce 39.00 2,929,383 180,045 42,476 307,878 192,254 3,652,036 93,642
Department of Correction 141.00 9,347,979 576,994 135,546 982,473 695,074 11,738,065 83,249
Department of Crime Control & Public Safety 92.00 5,436,319 337,052 78,827 571,357 453,523 6,877,078 74,751
Department of Cultural Resources 8.00 502,839 31,176 7,291 52,848 39,437 633,591 79,199
Department of Environment & Natural Resources 125.00 7,540,578 467,070 109,338 792,515 616,200 9,525,701 76,206
Department of Health and Human Services 389.15 26,550,223 1,641,096 384,978 2,790,428 1,918,354 33,285,079 85,533
Department of Insurance 19.00 1,444,065 89,532 20,939 151,771 93,662 1,799,970 94,735
Department of Justice 75.00 5,155,416 317,096 74,754 541,834 369,720 6,458,820 86,118
Department of Juvenile Justice & Delinq
Prevention 11.00 794,984 49,289 11,527 83,553 54,226 993,579 90,325
Department of Labor 11.00 635,218 39,384 9,211 66,761 54,226 804,799 73,164
Department of Public Instruction 146.75 10,449,356 643,891 151,516 1,098,227 723,419 13,066,409 89,039
Department of Revenue 106.25 7,567,497 465,945 109,729 795,344 523,770 9,462,284 89,057
Department of Secretary of State 11.00 754,505 46,457 10,940 79,298 54,226 945,426 85,948
Department of the State Treasurer 49.00 3,713,212 227,947 53,842 390,259 241,550 4,626,810 94,425
Department of Transportation 345.00 25,530,519 1,579,330 370,192 2,683,258 1,700,712 31,864,011 92,359
Employment Security Commission 106.00 7,811,399 484,307 113,265 820,978 522,538 9,752,487 92,005
NC Housing Finance Authority 10.00 764,642 47,408 11,087 80,364 49,296 952,797 95,280
NC School Science & Math 6.00 360,071 22,324 5,221 37,843 29,578 455,038 75,840
NC Wildlife Resources 19.00 1,334,577 82,418 19,351 140,264 93,662 1,670,273 87,909
Office of Administrative Hearings 1.00 63,426 3,932 920 6,666 4,930 79,874 79,874
Office of the Governor 10.00 807,773 49,949 11,713 84,897 49,296 1,003,628 100,363
Office of the Lieutenant Governor 0.00 0 0 0 0 0 0 0
Office of the State Auditor 7.00 522,099 32,370 7,570 54,873 34,507 651,419 93,060
Office of the State Controller 69.50 5,318,463 328,428 77,118 558,970 342,607 6,625,587 95,332
State Board of Elections 31.00 1,826,805 113,262 26,489 191,997 152,818 2,311,370 74,560
Total w/o AOC, Lottery, UNC System & ITS 1,938.65 134,343,523 8,301,494 1,947,982 14,119,504 9,556,769 168,269,272 86,797
Administrative Office of the Courts 245.75 18,551,944 1,143,352 269,003 1,949,809 1,211,449 23,125,557 94,102
NC Education Lottery 30.00 1,799,361 109,597 26,091 189,113 147,888 2,272,050 75,735
UNC System 3,583.75 233,912,856 14,315,410 3,391,738 24,584,242 17,666,454 293,870,701 82,001
Total Without ITS 5,798.15 388,607,684 23,869,853 5,634,814 40,842,668 28,582,560 487,537,579 84,085
Office of Information Technology Services 538.43 41,540,152 2,552,763 602,332 4,365,870 2,654,245 51,715,362 96,048
Page 21
Table 5-2 Salary and Calculated Fringes for All IT Positions
Annual Budgeted Salary - UNC System Agencies
as reported June 30, 2011
TOTAL
FTE'S
ANNUAL
BUDGETED
SALARY OASDI HI RETIRE HOSPITAL TOTAL
AVERAGE PER
FTE
Appalachian State University 156.75 10,296,658 634,489 149,302 1,082,179 772,715 12,935,342 82,522
East Carolina University 317.05 19,150,325 1,184,937 277,680 2,012,699 1,562,930 24,188,571 76,293
Elizabeth City State University 34.00 1,764,243 109,383 25,582 185,422 167,606 2,252,236 66,242
Fayetteville State University 35.00 1,854,528 113,790 26,891 194,911 172,536 2,362,656 67,504
NC A&T State University 97.00 5,616,552 343,889 81,440 590,300 478,171 7,110,352 73,303
NC Central University 86.00 4,946,696 302,631 71,727 519,898 423,946 6,264,898 72,848
NC School of Arts 14.00 872,228 53,694 12,647 91,671 69,014 1,099,255 78,518
NC State University 571.04 39,177,671 2,402,249 568,077 4,117,573 2,814,999 49,080,568 85,949
UNC Asheville 36.50 1,967,339 121,777 28,526 206,767 179,930 2,504,340 68,612
UNC Chapel Hill 1,153.81 77,725,156 4,767,521 1,127,015 8,168,914 5,687,822 97,476,428 84,482
UNC Charlotte 237.50 15,977,601 979,500 231,675 1,679,246 1,170,780 20,038,802 84,374
UNC General Administration 70.00 5,182,842 308,504 75,151 544,717 345,072 6,456,286 92,233
UNC Greensboro 199.80 12,361,987 754,325 179,249 1,299,245 984,934 15,579,740 77,977
UNC Hospital 219.00 17,170,173 1,019,823 248,968 1,804,585 1,079,582 21,323,131 97,366
UNC Pembroke 53.00 2,741,362 168,867 39,750 288,117 261,269 3,499,365 66,026
UNC Wilmington 139.30 7,808,385 478,534 113,222 820,661 686,693 9,907,495 71,123
Western Carolina University 97.00 5,264,349 323,091 76,333 553,283 478,171 6,695,228 69,023
Winston-Salem State
University 67.00 4,034,761 248,407 58,504 424,053 330,283 5,096,008 76,060
TOTAL UNC System 3,583.75 233,912,856 14,315,410 3,391,738 24,584,242 17,666,454 293,870,701 82,001
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
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, 2011.)
Table 5-4 Total IT Salary and Fringe Amount by Position Status-UNC System Agencies lists
this same information by UNC System Agency.
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 positions 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, NC Education Lottery, NC
Housing and Finance, and UNC System).
Page 23
FILLED
POSITIONS
VACANT
POSITIONS ALL POSITIONS
% VACANT OF
TOTAL
Comprehensive Major Medical Plan 164,906 0 164,906 0.00%
Community Colleges System Office 5,029,757 405,961 5,435,718 7.47%
Department of Administration 861,019 0 861,019 0.00%
Department of Agriculture & Consumer Services 2,433,446 138,052 2,571,498 5.37%
Department of Commerce 3,316,123 335,913 3,652,036 9.20%
Department of Correction 10,680,964 1,057,100 11,738,065 9.01%
Department of Crime Control & Public Safety 6,161,638 715,440 6,877,078 10.40%
Department of Cultural Resources 633,591 0 633,591 0.00%
Department of Environment & Natural Resources 8,419,206 1,106,496 9,525,701 11.62%
Department of Health and Human Services 30,073,523 3,211,557 33,285,079 9.65%
Department of Insurance 1,614,098 185,872 1,799,970 10.33%
Department of Justice 6,345,419 113,402 6,458,820 1.76%
Department of Juvenile Justice & Delinq Prevention 918,981 74,598 993,579 7.51%
Department of Labor 804,799 0 804,799 0.00%
Department of Public Instruction 11,340,531 1,725,878 13,066,409 13.21%
Department of Revenue 8,113,436 1,348,848 9,462,284 14.25%
Department of Secretary of State 945,426 0 945,426 0.00%
Department of the State Treasurer 4,399,791 227,018 4,626,810 4.91%
Department of Transportation 28,280,992 3,583,020 31,864,011 11.24%
Employment Security Commission 8,614,221 1,138,266 9,752,487 11.67%
NC Housing Finance Authority 952,797 0 952,797 0.00%
NC School Science & Math 455,038 0 455,038 0.00%
NC Wildlife Resources 1,670,273 0 1,670,273 0.00%
Office of Administrative Hearings 79,874 0 79,874 0.00%
Office of the Governor 919,781 83,846 1,003,628 8.35%
Office of the Lieutenant Governor 0 0 0 N/A
Office of the State Auditor 523,603 127,816 651,419 19.62%
Office of the State Controller 5,890,251 735,335 6,625,587 11.10%
State Board of Elections 2,252,583 58,787 2,311,370 2.54%
Total w/o AOC, Lottery, UNC System & ITS 151,896,068 16,373,204 168,269,272 9.73%
Administrative Office of the Courts 21,955,257 1,170,300 23,125,557 5.06%
NC Education Lottery 2,036,157 235,892 2,272,050 10.38%
UNC System 257,277,156 36,593,544 293,870,701 12.45%
Total Without ITS 433,164,639 54,372,940 487,537,579 11.15%
Office of Information Technology Services 44,571,611 7,143,752 51,715,362 13.81%
Table 5-3 Total IT Salary and Fringe Amount By Position Status
Annual Budgeted Amounts as reported June 30, 2011
Page 24
FILLED
POSITIONS
VACANT
POSITIONS ALL POSITIONS
% VACANT OF
TOTAL
Appalachian State University 12,125,845 809,498 12,935,342 6.26%
East Carolina University 21,963,947 2,224,624 24,188,571 9.20%
Elizabeth City State University 2,098,509 153,727 2,252,236 6.83%
Fayetteville State University 1,905,364 457,292 2,362,656 19.35%
NC A&T State University 5,607,646 1,502,706 7,110,352 21.13%
NC Central University 5,425,891 839,006 6,264,898 13.39%
NC School of Arts 1,099,255 0 1,099,255 0.00%
NC State University 44,036,208 5,044,360 49,080,568 10.28%
UNC Asheville 2,263,773 240,567 2,504,340 9.61%
UNC Chapel Hill 83,231,487 14,244,941 97,476,428 14.61%
UNC Charlotte 17,784,447 2,254,355 20,038,802 11.25%
UNC General Administration 5,385,593 1,070,693 6,456,286 16.58%
UNC Greensboro 15,081,874 497,866 15,579,740 3.20%
UNC Hospital 18,332,723 2,990,408 21,323,131 14.02%
UNC Pembroke 3,023,152 476,213 3,499,365 13.61%
UNC Wilmington 8,757,662 1,149,833 9,907,495 11.61%
Western Carolina University 5,419,649 1,275,579 6,695,228 19.05%
Winston-Salem State University 3,734,132 1,361,876 5,096,008 26.72%
Total UNC System 257,277,156 36,593,544 293,870,701 12.45%
Table 5-4 Total IT Salary and Fringe Amount By Position Status
UNC System Agencies
Annual Budgeted Amounts as reported June 30, 2011
Page 25
FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes
Comprehensive Major Medical Plan 1.00 109,383 0.00 0 0.00 0 0.00 0 1.00 55,523
Community Colleges System Office 8.00 882,827 9.00 741,481 1.00 98,158 36.00 3,048,105 10.00 665,147
Department of Administration 1.00 120,269 0.00 0 0.00 0 5.00 415,005 5.00 325,745
Department of Agriculture & Consumer Services 1.00 134,312 0.00 0 1.00 102,057 25.00 1,884,579 7.00 450,550
Department of Commerce 5.00 641,548 3.00 336,303 1.00 76,204 24.00 2,193,629 6.00 404,353
Department of Correction 13.00 1,624,702 5.00 406,792 30.00 2,395,633 39.00 4,104,699 54.00 3,206,240
Department of Crime Control & Public Safety 3.00 359,008 4.00 337,738 38.00 2,535,754 18.00 1,609,653 29.00 2,034,926
Department of Cultural Resources 1.00 104,764 0.00 0 1.00 82,619 5.00 371,903 1.00 74,306
Department of Environment & Natural Resources 9.00 1,015,495 0.00 0 1.00 95,219 55.00 4,453,853 60.00 3,961,135
Department of Health and Human Services 55.01 6,257,813 35.00 2,264,374 34.04 2,891,720 175.04 16,022,096 90.06 5,849,076
Department of Insurance 2.00 247,029 0.00 0 3.00 262,529 9.00 895,089 5.00 395,323
Department of Justice 13.00 1,602,816 9.00 913,896 5.00 338,911 26.00 2,212,088 22.00 1,391,109
Department of Juvenile Justice & Delinq Prevention 2.00 245,552 0.00 0 0.00 0 7.00 595,851 2.00 152,176
Department of Labor 2.00 197,234 0.00 0 0.00 0 3.00 257,605 6.00 349,960
Department of Public Instruction 12.00 1,468,326 8.00 620,779 10.00 885,935 73.00 7,049,208 43.75 3,042,161
Department of Revenue 15.00 1,820,614 19.00 1,601,844 7.00 664,235 46.25 4,221,145 19.00 1,154,446
Department of Secretary of State 3.00 364,809 0.00 0 0.00 0 4.00 337,740 4.00 242,878
Department of the State Treasurer 3.00 434,402 2.00 212,409 3.00 297,565 26.00 2,687,885 15.00 994,549
Department of Transportation 48.00 5,685,444 26.00 2,384,549 7.00 703,176 197.00 18,529,565 67.00 4,561,277
Employment Security Commission 12.00 1,454,267 31.00 2,593,039 6.00 514,913 47.00 4,520,577 10.00 669,692
NC Housing Finance Authority
NC School Science & Math 1.00 111,101 2.00 171,273 0.00 0 0.00 0 3.00 172,664
NC Wildlife Resources 3.00 386,758 0.00 0 4.00 309,701 8.00 718,713 4.00 255,101
Office of Administrative Hearings 0.00 0 0.00 0 1.00 79,874 0.00 0 0.00 0
Office of the Governor 2.00 254,252 0.00 0 0.00 0 8.00 749,375 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 127,816 0.00 0 1.00 98,835 3.00 276,239 2.00 148,529
Office of the State Controller 13.00 1,618,600 6.00 484,201 1.00 81,734 36.50 3,509,602 13.00 931,451
State Board of Elections 3.00 339,373 1.00 102,163 0.00 0 12.00 946,448 15.00 923,386
Total w/o AOC, Lottery, UNC System & ITS 232.01 27,608,513 160.00 13,170,841 155.04 12,514,769 887.79 81,610,651 493.81 32,411,701
Administrative Office of the Courts
NC Education Lottery
UNC System 211.90 24,078,343 488.75 43,046,760 208.00 16,730,105 1,047.88 89,871,776 1,262.38 80,386,903
Total Without ITS 443.91 51,686,856 648.75 56,217,601 363.04 29,244,874 1,935.67 171,482,427 1,756.19 112,798,604
Office of Information Technology Services 84.08 10,581,962 126.22 11,127,808 150.09 13,182,475 130.04 13,534,284 48.00 3,288,833
Non-banded positions include in Table 5-1: AOC 23,125,557 Univ 39,756,813 Lottery 2,272,050 Housing Finance Authority 952,797
Table 5-5 Salary and Calculated Fringes by Banding Category for All IT Positions
Annual Budgeted Amounts as reported June 30, 2011
Information
Technology Operations and Systems Networking
Business and Technology
Applications Technical Support
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
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, 2011. The agencies are grouped by legislative
committee for this table. The NC Education Lottery is also included for informational
purposes.
Page 27
Table 5-6 Information Technology FTEs versus All FTEs
As Reported June 30, 2011
Filled
Information
Technology
Positions
Vacant
Information
Technology
Positions
Total
Information
Technology
Positions
Total All
Positions
% IT of
Total
Education
Community Colleges System Office 59.00 5.00 64.00 212.00 30. 19%
Department of Public Instruction 127.75 19.00 146.75 1,443.31 10.17%
NC School Science & Math 6.00 0.00 6.00 192.24 3.12%
UNC System 3,098.74 485.01 3,583.75 33,103.50 10.83%
Education Total: 3,291.49 509.01 3,800.50 34,951.05 10.87%
General Government
Department of Administration 11.00 0.00 11.00 729.29 1.51%
Department of Cultural Resources 8.00 0.00 8.00 894.81 0.89%
Department of Insurance 17.00 2.00 19.00 444.41 4.28%
Department of Revenue 91.25 15.00 106.25 1,506.25 7.05%
Department of Secretary of State 11.00 0.00 11.00 202.75 5.43%
Department of the State Treasurer 47.00 2.00 49.00 378.00 12.96%
NC Housing Finance Authority 10.00 0.00 10.00 119.00 8.40%
Office of Administrative Hearings 1.00 0.00 1.00 42.00 2.38%
Office of the Governor 9.00 1.00 10.00 161.00 6.21%
Office of the State Auditor 6.00 1.00 7.00 193.00 3.63%
Office of the State Controller 62.00 7.50 69.50 224.25 30.99%
State Board of Elections 30.00 1.00 31.00 136.00 22.79%
General Government Total: 303.25 29.50 332.75 5,030.76 6.61%
Human Resources
Department of Health and Human Services 353.12 36.03 389.15 18,150.80 2.14%
Human Resources Total: 353.12 36.03 389.15 18,150.80 2.14%
Justice and Public Safety
Administrative Office of the Courts 232.75 13.00 245.75 6,948.12 3.54%
Department of Correction 128.00 13.00 141.00 21,747.00 0.65%
Department of Crime Control & Public Safety 82.00 10.00 92.00 3,108.75 2.96%
Department of Justice 74.00 1.00 75.00 1,378.63 5.44%
Department of Juvenile Justice & Delinq Prevention 10.00 1.00 11.00 1,876.25 0.59%
Justice and Public Safety Total: 526.75 38.00 564.75 35,058.75 1.61%
Natural and Economic Resources
Department of Agriculture & Consumer Services 32.00 2.00 34.00 1,375.50 2.47%
Department of Commerce 35.00 4.00 39.00 912.97 4.27%
Department of Environment & Natural Resources 110.00 15.00 125.00 3,923.61 3.19%
Department of Labor 11.00 0.00 11.00 410.28 2.68%
Employment Security Commission 93.00 13.00 106.00 2,449.48 4.33%
NC Wildlife Resources 19.00 0.00 19.00 658.13 2.89%
Natural and Economic Resources Total: 300.00 34.00 334.00 9,729.97 3.43%
Salaries and Benefits Retirement
Comprehensive Major Medical Plan 2.00 0.00 2.00 42.00 4.76%
Salaries Benefits Retirement Total: 2.00 0.00 2.00 42.00 4.76%
Transportation
Department of Transportation 306.00 39.00 345.00 13,584.00 2.54%
Transportation Total: 306.00 39.00 345.00 13,584.00 2.54%
NC Education Lottery
NC Education Lottery 26.00 4.00 30.00 244.98 12.25%
NC Education Lottery Total: 26.00 4.00 30.00 244.98 12.25%
Office of Information Technology Services
Office of Information Technology Services 465.41 73.02 538.43 631.43 85.27%
Office of Information Technology Services Total: 465.41 73.02 538.43 631.43 85.27%
Total: 5,574.02 762.56 6,336.58 117,423.74 5.40%
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
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 provided for the university system, the Administrative Office of the Courts or the
General Assembly.
What is Portfolio Management?
Portfolio Management (PM) is the grouping of computer applications and projects to examine an
organization’s spending, risk profile, and plans for technology. Just as one manages a personal
retirement fund or budget, the state manages its technology portfolio for the future. It does this by
managing IT investments from the agency, program (closely-related projects with common business
goals) and statewide perspectives to maximize citizen benefits and public value for costs within
acceptable risk profiles. The intent is to build and maintain project and application portfolios that
reflect the value of the investment and aid the agency in optimizing business decisions about
technology.
The state’s technology profile is composed of several key elements: projects, existing applications,
people, hardware and software. Other sections of this report give information on the costs of
personnel and hardware and software. This section addresses projects and existing applications.
Project Portfolio Management
Project Portfolio Management (PPM) focuses on new technology projects intended to improve the
delivery of existing services or to provide new services. Projects have a definite timeline, a budget,
and a set of deliverables. When they are completed, the state should have a new service or improved
infrastructure to build on for the future.
Application Portfolio Management
Application Portfolio Management (APM) focuses on the state’s existing software applications,
everything from food stamps to victim services to drivers’ licenses and boat registration. It assesses
applications in regards to their age, cost, risk, technical health, and ability to continue to meet
business needs. APM assists agencies in the development of plans for managing each application
over its production life cycle and transitioning the portfolio as a whole to a more business-responsive,
technically-controllable, financially-sustainable and risk-acceptable environment. It
attempts to answer questions such as: should the state continue to maintain the application, modify
the application to use newer technology, or replace it because it no longer meets the agency’s
business need. The result is agency IT organizations that are able to deliver business functions with
effective applications at acceptable costs.
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
Page 29
As in previous years, the information for this section of IT Expenditures Report is from the Portfolio
Management tool. 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, but the numbers are based
on self-reports from the agencies. The costs have not been audited, nor were they directly transferred
to the Portfolio Management system from the N.C. Accounting System. Overall, approximately
61.6% 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.
Projects:
The Enterprise Project Management Office, under the SCIO, monitored more than 120 projects
during FY 2011. Projects are new efforts with budgets, timelines and milestones. (Tracking and
monitoring is not required for projects costing less than $500,000, but those projects that reported
costs in the Portfolio Management tool are included in this report.) Approximately $139 million was
spent by state agencies, including ITS, on projects. This amount was slightly higher than last year’s
$123 million due in part because of the North Carolina Turnpike Toll Collection Management
System, which will be implemented this fall.
Chart 1.1 shows FY 2011 project costs by the source of funds (excluding ITS).
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
Page 30
Chart 1.2 shows the distribution of project funds statewide at a detailed cost level (excluding ITS). It
should be noted that hardware costs decreased by $12 million due mainly to a decrease in hardware
equipment spending for VIPER and the Tax Information Management System. The North Carolina
Turnpike Toll Collection Management System and the Tax Information Management System
projects were mainly responsible for a $19 million dollar increase in Other External Costs for the
vendor services provided for these systems.
Table 6-1 shows the distribution of costs for projects by agency for 2011 by detailed cost category.
Table 6-2 shows the distribution of costs for projects by agency for 2011 by source of funds.
Applications:
State agencies, including ITS, have reported on 1063 active applications. Of those 1063
applications, the application support cost was identified for 903 applications. Applications support
key business processes in state government, everything from the issuance of food stamps to vehicle
registration and employee payroll. The state application portfolio only includes business applications
and does not include office productivity software such as MS Word or Excel. The focus is on the life
cycle management of business applications and determination of the application strategy.
Approaches such as replace and retire, modify to incorporate newer technologies, enhance business
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
Page 31
capabilities or continue to maintain as is help to evaluate the application business value and improve
service delivery to the citizens of North Carolina.
Note: In February 2011, the State Chief Information Officer 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 “Legacy Application
Study 2011.”
Chart 1.3 provides details of the source of funds for maintaining the state’s existing applications
(excluding ITS). As the chart depicts, the state provides 62% of funding with 34% coming from
federal funding.
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
Page 32
Chart 1.4 gives details on the distribution of costs in IT cost categories (excluding ITS). 25% of the
cost of maintaining applications comes from internal personnel.
Table 6-3 provides additional information on state government application costs by agencies for
2010 by detailed cost category.
Table 6-4 provides additional information on state government application costs by agencies for
2010 by source of funds.
Key differences between FY2010 and FY2011 include:
The number of projects reporting costs, including ITS, decreased slightly from 129 in 2010
to 120 in 2011. Total project costs increased from $123M in 2010 to $138M in 2011. This
was due mainly to the work efforts for the North Carolina Turnpike Authority Toll
Collection Management System.
The number of applications reporting costs, including ITS, decreased from 1,157 in 2010 to
1,063 in 2011. Total applications costs went from $258M in 2010 to $269M in 2011.1 The
1 In the 2010 report, total applications costs were incorrectly reported as $242 million instead of $258 million.
State of North Carolina
Information Technology Expenditures Report
For the Period July 2010 – June 2011
Page 33
decrease was mainly a result of retirement of old applications that were replaced by other
modern systems. The increases were a result of growth in the use of the ITS Email service,
email archiving and improvements made to the North Carolina Identity Management
System.
Final note:
As was done last year, 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, 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.
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, 2011
Department of Administration E-Recruit Project 30,080 0 0 0 0 0 30,080
NC E-Procurement Upgrade 26,448 61,425 350,417 260,432 0 0 698,722
NCFlex Web Enrollment 6,400 7,843 0 0 0 0 14,243
Total Costs for Department of Administration 62,928 69,268 350,417 260,432 0 0 743,045
Department of Agriculture and
Consumer Services
Agronomic LIMS 87,146 191,003 0 0 0 0 278,149
Veterinary LIMS Project 46,805 4,675 0 16,087 145,542 0 213,109
Total Costs for Department of Agriculture and Consumer 133,951 195,678 0 16,087 145,542 0 491,258
Services
Department of Commerce Consolidated Case Management System 98,547 66,032 0 0 0 0
(CCMS) Vault Migration Project
164,579
Grants Management System (GMS) 9,450 32,920 0 0 0 0 42,370
NCIC Claims 2.0 7,651 14,047 0 0 0 0 21,698
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, 2011
Department of Commerce NCIC Electronic Data Interchange (EDI) 6,420 9,479 0 0 0 0 15,899
North Carolina Industrial Commission 4,500 0 0 16,908 130,310 1,400
Consolidated Case Management System
Program Overhead Project
153,118
Total Costs for Department of Commerce 126,568 122,478 0 16,908 130,310 1,400 397,664
Department of Correction DOC/ITS Exchange Migration Project 14,220 0 0 0 0 0 14,220
Total Costs for Department of Correction 14,220 0 0 0 0 0 14,220
Department of Crime Control
and Public Safety
Grants Enterprise Management System 96,360 20,206 0 0 0 0
(GEMS) - GCC
116,566
iRISK 42,135 0 309,101 0 0 0 351,236
New Joint Force Headquarters - State 44,240 15,217 71,384 828,644 47,000 1,100,000
Government Information Technology
Infrastructure and Network
2,106,485
VIPER Strategic Solution Implementation 111,061 12,195 0 0 0 0
Project - Phase 2
123,256
Total Costs for Department of Crime Control and Public Safety 293,796 47,618 380,485 828,644 47,000 1,100,000 2,697,543
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, 2011
Department of Cultural
Resources
Shared Integrated Library System 861 0 0 0 0 0 861
Total Costs for Department of Cultural Resources 861 0 0 0 0 0 861
Department of Environment
and Natural Resources
DENR Green Square Infrastructure 56,212 0 675,304 413,157 0 0 1,144,673
DENR Groundwater Decision Support 44,324 0 0 0 0 0
System
44,324
DWM UST Tank Information 308,000 1,589,937 0 0 0 0
Management System (TIMS)
1,897,937
Total Costs for Department of Environment and Natural 408,536 1,589,937 675,304 413,157 0 0 3,086,934
Resources
Department of Health and
Human Services
Crossroads State Agency Model 501,647 1,176,124 0 0 0 58,789
Implementation Project (SAM)
1,736,560
DCD Subsidized Early Education for 66,546 0 0 0 0 124,016
Kids (SEEK), aka ; Attendance
Reporting and Payment Delivery
190,562
DHHS - Electronic Pre-Assessment 145,811 222,943 25,919 0 0 30,865
Screening Service (ePASS) Phase 2 -
Food and Nutrition Services
425,538
DHHS Business Electronic Access 203,008 469,490 2,434,488 0 0 33,943
Management (BEAM) Project
3,140,929
DHHS Cherry Hospital Replacement 28,489 0 0 0 0 5,883
Project
34,372
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, 2011
Department of Health and
Human Services
Division of Medical Assistance - SAS 52,693 0 1,500,000 0 0 0
Medicaid Recipient Eligibility Solution
1,552,693
Division of Medical Assistance- Health 124,982 0 1,607,332 0 204,156 0
Analytics Initiative
1,936,470
DMH - HEARTS Upgrades - Precise ID 2,000 0 0 1,430 61,521 1,200 66,151
ePASS Phase 2 – Medicaid 24,026 12,887 0 0 0 4,789 41,702
Health Information System 712,195 3,097,145 547,655 0 115,520 137,339 4,609,854
NC FAST - Global Case Management and 1,215,159 1,482,927 7,037,070 0 0 208,840
Food and Nutrition Services (FNS)
9,943,996
NC FAST Automated Interview (AI) 40,459 0 0 0 0 3,421
Integrator Selection Project
43,880
NC FAST Case Management Program 303,477 106,799 398,929 372,114 1,891,743 609,378
Level Project
3,682,440
NC Health Choice (aka SCHIP) Business 49,678 185,747 0 0 0 0
Rules and Analysis Project
235,425
NCMMIS+ Program – DHSR Business 634,444 373,082 779,390 0 0 19,212
Process Automation System (BPAS)
Project
1,806,128
NCMMIS+ Program-Level Project 1,255,290 552,763 0 116,214 57,239 545,870 2,527,376
Replacement MMIS DDI Project 3,283,203 1,899,875 10,625,750 0 0 85,526 15,894,354
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, 2011
Department of Health and
Human Services
798,558 19,254 862,574 Replacement MMIS Reporting and 3,084 1,519 43,312
Analytics (R&A) Project
1,728,301
Vital Records and Statistics Automation 54,770 192,693 64,743 0 0 11,201
System
323,407
Total Costs for Department of Health and Human Services 9,496,435 9,791,729 25,883,850 492,842 2,331,698 1,923,584 49,920,138
Department of Justice Crime Data Integration (Captures) 102,003 110,660 0 0 0 279 212,942
Legal Services Case Management 88,339 21,681 416,770 0 0 0 526,790
Total Costs for Department of Justice 190,342 132,341 416,770 0 0 279 739,732
Department of Public
Instruction
AHR State Rollout 70,434 254,700 0 0 0 0 325,134
Budget and Amendment System (BAAS) 28,404 0 0 0 0 0 28,404
CECAS 2.0 177,345 96,248 0 35,308 326,635 0 635,536
CEDARS - Data Warehouse 179,956 527,903 0 0 0 0 707,859
CEDARS - Reporting 246,173 475,702 0 0 0 34,500 756,375
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, 2011
Department of Public
Instruction
4,676 Child Nutrition System Server and OS 12,366 0 16,894 4,880 0
Upgrade
38,816
Computerized Instructional Management 79,700 567,318 0 47,501 1,116,727 0
System
1,811,246
Computerized Instructional Management 9,201 0 0 0 34,000 0
System (CIMS Pilot)
43,201
GMS 100 - Comprehensive Continuous 106,395 82,547 0 12,586 1,343 0
Improvement Planning (CCIP)
202,871
Licensure Automation System 64,477 37,789 0 0 0 0 102,266
NC WISE 2008 Hardware Upgrade 143,226 58,737 0 0 0 153,592 355,555
NC WISE eSIS 12.1 Upgrade 273,432 101,789 0 0 7,952 0 383,173
NCDPI Email Migration Project 4,527 0 0 0 0 0
(Live@EDU) - formerly named
NCDPI/ITS Exchange Migration Project
4,527
Race to the Top - Instructional 149,040 0 0 0 0 0
Improvement System (IIS)
149,040
Race to the Top - NC Education Cloud 42,865 699,800 0 0 0 0
Planning
742,665
WCPSS and CMS NC WISE Integration 362,514 224,741 0 20,733 12,908 0 620,896
Total Costs for Department of Public Instruction 1,942,365 3,139,640 0 133,022 1,504,445 188,092 6,907,564
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, 2011
Department of Revenue 468,285 870,325 16,937,935 Tax Information Management System 294,872 951,658 0
(TIMS)
19,523,075
Total Costs for Department of Revenue 468,285 870,325 16,937,935 294,872 951,658 0 19,523,075
Department of Transportation 511 System - Solicit Vendors for Appl 39,573 0 109,220 0 0 0
Support (ITP.00153, BSIP, P4)
148,793
Access Control, Alarms, and Badge 26,380 0 0 0 0 0
Making Software (ITP.00213, IS)
26,380
ARPS - Automated Routing and 41,271 264,508 0 0 0 0
Permitting System Upgrade (ITP.00203,
ETS)
305,779
Asset Management System - Bridge 333,727 0 1,021,472 0 0 0
Management Addition (BMS, ITP.00183,
ETS, P1)
1,355,199
Back Office Software Solution (BOSS) 28,525 10,461 0 76,437 98,863 0 214,286
CDLIS Modernization (ITP.00209, DMV) 32,086 67,798 0 0 0 0 99,884
Criminal Justice Data Integration 77,935 0 0 0 0 0
Initiative (CJLEADS, ITP.00195, DMV)
77,935
DMV 2D Barcode (ITP.00174, DMV, P2) 12,704 0 0 42,750 0 0 55,454
DMV Commercial Drivers License (CDL) 19,442 21,739 0 0 0 0
2009 Improvements (ITP.00188, DMV)
41,181
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, 2011
Department of Transportation 11,786 78,424 DOT EIPT (Telephony) System Upgrade 0 295,419 64,020 3,000
Phase I (ITP.00163, IS, P1)
452,649
DOT Printing Project (ITP.00112, BSIP, 169,907 97,747 0 0 0 551,368
P1)
819,022
ECM - Enterprise Content Management 14,004 109,217 0 0 0 100,000
System (ITP.00177, BSIP, P1)
223,221
Electronic Crash Reporting (Non-TraCS) 17,556 208,244 0 0 0 0
(ITP.00198, DMV)
225,800
Emissions Services Request for Proposal 28,625 0 0 0 0 0
(RFP) (ITP.00096, DMV, P10)
28,625
Grants Management (ITP.00196, BSIP, 157,102 545,445 0 0 8,325 0
P1)
710,872
HB 1779 Vehicle Property Tax Collection 0 37,344 0 0 0 0
(ITP.00217, DMV)
37,344
HB1779 - Planning to Post 16,730 0 0 0 0 0
Implementation (PROG.0004, ITP.00129,
DMV, P1)
16,730
Implementation of SAVE via AAMVAnet 44,624 56,652 0 0 0 0
(ITP.00191, DMV)
101,276
Medical Certification Requirements as 36,250 67,043 0 0 0 0
Part of CDL (ITP.00210, DMV)
103,293
Motor Vehicle Inspection and Law 25,499 104,245 0 0 0 0
Enforcement System (MILES) ITP.00207,
DMV
129,744
Multi User Geodatabase (MUG, 259,655 478,281 0 0 0 0
ITP.00181, ETS)
737,936
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, 2011
Department of Transportation NCDOT Division 3 Telephone Upgrade 9,472 0 34,813 0 0 0
(ITP.00206, IS)
44,285
NCDOT Ferry Ticketing and Reservation 183,292 49,375 0 0 0 0
System (ITP.00186, IS)
232,667
NCDOT Laptop and Mobile Device 4,615 0 0 0 0 0
Encryption (ITP.00184, IS)
4,615
NCDOT Web Site Redesign and 59,864 27,984 0 0 0 0
Restructuring (ITP.00208, BSIP)
87,848
NCSmartlink (ITP.00066, ETS, P1) 45,943 0 24,800 0 0 0 70,743
Next Generation Secure Driver License 371,790 450,130 0 0 0 0
System(PROG.0003, ITP.00200, DMV)
821,920
PCI Compliance (ITP.00199, IS) 207,720 112,313 0 355,126 0 0 675,159
SAP Claims Management (ITP.00204, 90,772 117,129 0 0 64,605 0
BSIP, P1)
272,506
Spatial Data Viewer (SDV, ITP.00182, 543,531 241,110 0 127,868 40,200 0
ETS, P1)
952,709
SPOT Assistance - Prioritization 2.0 97,801 189,317 0 0 21,205 0
(ITP.00205, BSIP)
308,323
Stormwater Pollution Prevention Plan - 15,987 0 0 0 0 0
Spill Prevention (SPPP/SPCC) Website
(ITP.00201)
15,987
TraCS Software Upgrade to Release 10.0 22,657 0 0 0 0 0
(ITP.00215, DMV)
22,657
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, 2011
Department of Transportation Training Partner Integration (ITP.00202, 99,080 248 0 0 0 0
BSIP)
99,328
Trip Permits (ITP.00212, DMV) 47,362 0 0 0 0 0 47,362
Total Costs for Department of Transportation 3,193,267 3,334,754 1,190,305 897,600 297,218 654,368 9,567,512
Employment Security
Commission
ES Encryption of Staff & Partner PCs and 96,569 163,824 0 0 0 24,092
Career Resource Center (CRC) Upgrades
284,485
Southeast Consortium UI Modernization 425,260 300 0 27,319 6,262 67,489
Feasibility Study
526,630
UI Appeals Hosted Service for the 22,427 0 0 0 0 0
Integration of Digital Recording and
Teleconferencing
22,427
UI Chapanoke Expansion - St. Mary's 22,940 0 0 99,580 0 14,200
Relocation
136,720
UI Records Management Service (RMS) 7,980 32,760 0 0 0 3,350
Work Flow and Imaging System
44,090
UI Remote Service Center Relocation 12,506 0 0 43,238 0 0
Project
55,744
UI State Information Data Exchange 20,374 0 0 0 0 0
System (UI SIDES)
20,374
VoIP Telephony Replacement for ESC 22,042 0 0 0 0 0
Wade Avenue Complex
22,042
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, 2011
630,098 196,884 0 170,137 Total Costs for Employment Security Commission 6,262 109,131 1,112,512
North Carolina Turnpike
Authority
Toll Collection Management System 373,483 2,323,312 12,246,676 0 0 2,836,885
(TCMS)
17,780,356
Total Costs for North Carolina Turnpike Authority 373,483 2,323,312 12,246,676 0 0 2,836,885 17,780,356
Office of the Governor Budget and Performance Management 433,464 1,154,053 0 429,025 561,689 8,762
System - NC IBIS
2,586,993
Total Costs for Office of the Governor 433,464 1,154,053 0 429,025 561,689 8,762 2,586,993
Office of the State Controller BEACON Hardware Refresh/Disaster 105,018 0 0 1,112,575 0 0
Recovery Landscape Project
1,217,593
Criminal Justice Data Integration Pilot for 912,194 -688,663 3,008,968 2,438,991 2,004,186 206,364
Wake County
7,882,040
Total Costs for Office of the State Controller 1,017,212 -688,663 3,008,968 3,551,566 2,004,186 206,364 9,099,633
Total Costs for Non-ITS 18,785,811 22,279,354 61,090,710 7,504,292 7,980,008 7,028,865 124,669,040
Page 44
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, 2011
Office of Information
Technology Services
295,444 168,421 6,245,379 CGIA-NC Statewide Orthoimagery 2010 17,346 25,200 4,735 6,756,525
DNS Replacement 2010 170,423 345 436,282 0 0 0 607,050
E25K Retirement Project 6,478 0 0 0 0 0 6,478
Email Archiving 4,050 0 109,350 0 0 0 113,400
ESAP Remote Access VPN - Service 41,468 0 0 0 0 0
Introduction & Customer Migration
41,468
Exchange Service Improvement Project 125,603 202,752 4,400 310,000 183,000 13,200 838,955
Firewall/VPN - Service Refresh & 40,257 0 0 0 0 0
Customer Migration
40,257
Infrastructure Study & Assessment 740,237 1,114,567 0 0 0 0
(INSA) Project
1,854,804
IT Consolidation Phase III - DENR Green 130,969 0 0 327,986 0 0
Square Server Consolidation
458,955
Mainframe Software Toolset 51,227 485,860 354,418 0 725,511 0
Consolidation
1,617,016
NCID Next Generation Upgrade 411,171 170,961 0 747,768 95,475 0 1,425,375
Project Management/Resource 35,957 0 0 0 0 0
Management Tool
35,957
Page 45
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, 2011
Office of Information
Technology Services
Remote Office Backup Infrastructure 6,306 0 0 0 0 0 6,306
SONC Enterprise IVR SIP Migration 12,059 0 0 0 0 0 12,059
State Portal Initiative 19,460 18,532 75,000 0 0 0 112,992
Voice Mail Replacement - Lease 194,422 0 0 0 0 0 194,422
Total Costs for Office of Information Technology Services 2,285,531 2,161,438 7,224,829 1,403,100 1,029,186 17,935 14,122,019
Total Costs for ITS 2,285,531 2,161,438 7,224,829 1,403,100 1,029,186 17,935 14,122,019
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, 2011
Department of
Administration
E-Recruit Project 0 0 0 0 30,080 30,080
Department of
Administration
NC E-Procurement Upgrade 0 0 0 698,722 0 698,722
Department of
Administration
NCFlex Web Enrollment 0 0 0 0 14,243 14,243
Total Costs for Department of
Administration
0 0 0 698,722 44,323 743,045
Department of
Agriculture and
Consumer Services
Agronomic LIMS 191,003 0 0 0 87,146 278,149
Department of
Agriculture and
Consumer Services
Veterinary LIMS Project 0 0 0 0 213,109 213,109
Total Costs for Department of
Agriculture and
Consumer Services
191,003 0 0 0 300,255 491,258
Department of
Commerce
Consolidated Case Management
System (CCMS) Vault Migration Project
0 0 0 164,579 0 164,579
Department of
Commerce
Grants Management System (GMS) 42,370 0 0 0 0 42,370
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, 2011
Department of
Commerce
NCIC Claims 2.0 0 0 0 21,698 0 21,698
Department of
Commerce
NCIC Electronic Data Interchange (EDI) 0 0 0 15,899 0 15,899
Department of
Commerce
North Carolina Industrial Commission
Consolidated Case Management
System Program Overhead Project
0 0 0 153,118 0 153,118
Total Costs for Department of
Commerce
42,370 0 0 355,294 0 397,664
Department of
Correction
DOC/ITS Exchange Migration Project 0 0 0 0 14,220 14,220
Total Costs for Department of
Correction
0 0 0 0 14,220 14,220
Department of Crime
Control and Public
Safety
Grants Enterprise Management System
(GEMS) - GCC
116,566 0 0 0 0 116,566
Department of Crime
Control and Public
Safety
iRISK 0 0 0 0 351,236 351,236
Department of Crime
Control and Public
Safety
New Joint Force Headquarters - State
Government Information Technology
Infrastructure and Network
10,000 0 0 12,866 2,083,619 2,106,485
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, 2011
Department of Crime
Control and Public
Safety
VIPER Strategic Solution
Implementation Project - Phase 2
0 0 0 0 123,256 123,256
Total Costs for Department of Crime
Control and Public
Safety
126,566 0 0 12,866 2,558,111 2,697,543
Department of Cultural
Resources
Shared Integrated Library System 0 0 0 0 861 861
Total Costs for Department of
Cultural Resources
0 0 0 0 861 861
Department of
Environment and
Natural Resources
DENR Green Square Infrastructure 0 0 0 0 1,144,673 1,144,673
Department of
Environment and
Natural Resources
DENR Groundwater Decision Support
System
0 0 0 0 44,324 44,324
Department of
Environment and
Natural Resources
DWM UST Tank Information
Management System (TIMS)
1,170,359 0 0 0 727,578 1,897,937
Total Costs for Department of
Environment and
Natural Resources
1,170,359 0 0 0 1,916,575 3,086,934
Department of Health
and Human Services
Crossroads State Agency Model
Implementation Project (SAM)
1,736,560 0 0 0 0 1,736,560
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, 2011
Department of Health
and Human Services
DCD Subsidized Early Education for
Kids (SEEK), aka ; Attendance
Reporting and Payment Delivery
190,562 0 0 0 0 190,562
Department of Health
and Human Services
DHHS - Electronic Pre-Assessment
Screening Service (ePASS) Phase 2 -
Food and Nutrition Services
425,538 0 0 0 0 425,538
Department of Health
and Human Services
DHHS Business Electronic Access
Management (BEAM) Project
2,819,961 0 0 0 320,968 3,140,929
Department of Health
and Human Services
DHHS Cherry Hospital Replacement
Project
0 0 0 0 34,372 34,372
Department of Health
and Human Services
Division of Medical Assistance - SAS
Medicaid Recipient Eligibility Solution
0 0 0 0 1,552,693 1,552,693
Department of Health
and Human Services
Division of Medical Assistance- Health
Analytics Initiative
0 0 0 0 1,936,470 1,936,470
Department of Health
and Human Services
DMH - HEARTS Upgrades - Precise ID 0 0 0 0 66,151 66,151
Department of Health
and Human Services
ePASS Phase 2 – Medicaid 14,874 0 0 2,850 23,978 41,702
Department of Health
and Human Services
Health Information System 0 0 0 0 4,609,854 4,609,854
Department of Health
and Human Services
NC FAST - Global Case Management
and Food and Nutrition Services (FNS)
3,392,049 0 0 0 6,551,947 9,943,996
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, 2011
Department of Health
and Human Services
NC FAST Automated Interview (AI)
Integrator Selection Project
10,988 0 0 0 32,892 43,880
Department of Health
and Human Services
NC FAST Case Management Program
Level Project
1,925,476 0 0 0 1,756,964 3,682,440
Department of Health
and Human Services
NC Health Choice (aka SCHIP)
Business Rules and Analysis Project
211,887 0 0 0 23,538 235,425
Department of Health
and Human Services
NCMMIS+ Program – DHSR Business
Process Automation System (BPAS)
Project
1,160,558 0 0 0 645,570 1,806,128
Department of Health
and Human Services
NCMMIS+ Program-Level Project 2,243,239 31,388 0 0 252,749 2,527,376
Department of Health
and Human Services
Replacement MMIS DDI Project 14,428,754 0 0 0 1,465,600 15,894,354
Department of Health
and Human Services
Replacement MMIS Reporting and
Analytics (R&A) Project
1,555,472 0 0 0 172,829 1,728,301
Department of Health
and Human Services
Vital Records and Statistics Automation
System
0 0 0 0 323,407 323,407
Total Costs for Department of Health
and Human Services
30,115,918 31,388 0 2,850 19,769,982 49,920,138
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, 2011
Department of Justice Crime Data Integration (Captures) 79,224 0 0 0 133,718 212,942
Department of Justice Legal Services Case Management 0 0 0 0 526,790 526,790
Total Costs for Department of Justice 79,224 0 0 0 660,508 739,732
Department of Public
Instruction
AHR State Rollout 0 0 0 0 325,134 325,134
Department of Public
Instruction
Budget and Amendment System
(BAAS)
0 0 0 0 28,404 28,404
Department of Public
Instruction
CECAS 2.0 635,536 0 0 0 0 635,536
Department of Public
Instruction
CEDARS - Data Warehouse 527,903 0 0 0 179,956 707,859
Department of Public
Instruction
CEDARS - Reporting 510,202 0 0 0 246,173 756,375
Department of Public
Instruction
Child Nutrition System Server and OS
Upgrade
34,140 0 0 0 4,676 38,816
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, 2011
Department of Public
Instruction
Computerized Instructional
Management System
1,752,696 0 0 0 58,550 1,811,246
Department of Public
Instruction
Computerized Instructional
Management System (CIMS Pilot)
36,512 0 0 0 6,689 43,201
Department of Public
Instruction
GMS 100 - Comprehensive
Continuous Improvement Planning
(CCIP)
167,742 0 0 0 35,129 202,871
Department of Public
Instruction
Licensure Automation System 23,318 0 0 33,291 45,657 102,266
Department of Public
Instruction
NC WISE 2008 Hardware Upgrade 0 0 0 0 355,555 355,555
Department of Public
Instruction
NC WISE eSIS 12.1 Upgrade 0 0 0 0 383,173 383,173
Department of Public
Instruction
NCDPI Email Migration Project
(Live@EDU) - formerly named
NCDPI/ITS Exchange Migration Project
0 0 0 0 4,527 4,527
Department of Public
Instruction
Race to the Top - Instructional
Improvement System (IIS)
26,302 0 0 0 122,738 149,040
Department of Public
Instruction
Race to the Top - NC Education Cloud
Planning
556,760 0 0 0 185,905 742,665
Department of Public
Instruction
WCPSS and CMS NC WISE Integration 0 0 0 0 620,896 620,896
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, 2011
Total Costs for Department of Public
Instruction
4,271,111 0 0 33,291 2,603,162 6,907,564
Department of
Revenue
Tax Information Management System
(TIMS)
0 0 0 19,523,075 0 19,523,075
Total Costs for Department of
Revenue
0 0 0 19,523,075 0 19,523,075
Department of
Transportation
511 System - Solicit Vendors for Appl
Support (ITP.00153, BSIP, P4)
90,656 0 0 0 58,137 148,793
Department of
Transportation
Access Control, Alarms, and Badge
Making Software (ITP.00213, IS)
0 0 0 0 26,380 26,380
Department of
Transportation
ARPS - Automated Routing and
Permitting System Upgrade
(ITP.00203, ETS)
0 305,779 0 0 0 305,779
Department of
Transportation
Asset Management System - Bridge
Management Addition (BMS,
ITP.00183, ETS, P1)
1,084,160 0 0 0 271,039 1,355,199
Department of
Transportation
Back Office Software Solution (BOSS) 0 0 0 214,286 0 214,286
Department of
Transportation
CDLIS Modernization (ITP.00209, DMV) 0 0 0 0 99,884 99,884
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, 2011
Department of
Transportation
Criminal Justice Data Integration
Initiative (CJLEADS, ITP.00195, DMV)
0 23,654 0 0 54,281 77,935
Department of
Transportation
DMV 2D Barcode (ITP.00174, DMV, P2) 55,454 0 0 0 0 55,454
Department of
Transportation
DMV Commercial Drivers License
(CDL) 2009 Improvements (ITP.00188,
DMV)
41,181 0 0 0 0 41,181
Department of
Transportation
DOT EIPT (Telephony) System
Upgrade Phase I (ITP.00163, IS, P1)
0 0 0 0 452,649 452,649
Department of
Transportation
DOT Printing Project (ITP.00112, BSIP,
P1)
458,865 5,960 0 0 354,197 819,022
Department of
Transportation
ECM - Enterprise Content Management
System (ITP.00177, BSIP, P1)
0 0 0 0 223,221 223,221
Department of
Transportation
Electronic Crash Reporting (Non-
TraCS) (ITP.00198, DMV)
137,579 8,927 0 0 79,294 225,800
Department of
Transportation
Emissions Services Request for
Proposal (RFP) (ITP.00096, DMV, P10)
0 0 0 0 28,625 28,625
Department of
Transportation
Grants Management (ITP.00196, BSIP,
P1)
547,373 7,107 0 0 156,392 710,872
Department of
Transportation
HB 1779 Vehicle Property Tax
Collection (ITP.00217, DMV)
0 0 0 37,344 0 37,344
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, 2011
Department of
Transportation
HB1779 - Planning to Post
Implementation (PROG.0004,
ITP.00129, DMV, P1)
0 0 0 16,073 657 16,730
Department of
Transportation
Implementation of SAVE via AAMVAnet
(ITP.00191, DMV)
101,276 0 0 0 0 101,276
Department of
Transportation
Medical Certification Requirements as
Part of CDL (ITP.00210, DMV)
67,043 0 0 0 36,250 103,293
Department of
Transportation
Motor Vehicle Inspection and Law
Enforcement System (MILES)
ITP.00207, DMV
0 0 0 129,744 0 129,744
Department of
Transportation
Multi User Geodatabase (MUG,
ITP.00181, ETS)
737,936 0 0 0 0 737,936
Department of
Transportation
NCDOT Division 3 Telephone Upgrade
(ITP.00206, IS)
0 0 0 0 44,285 44,285
Department of
Transportation
NCDOT Ferry Ticketing and
Reservation System (ITP.00186, IS)
0 0 0 0 232,667 232,667
Department of
Transportation
NCDOT Laptop and Mobile Device
Encryption (ITP.00184, IS)
0 0 0 0 4,615 4,615
Department of
Transportation
NCDOT Web Site Redesign and
Restructuring (ITP.00208, BSIP)
0 0 0 0 87,848 87,848
Department of
Transportation
NCSmartlink (ITP.00066, ETS, P1) 2,618 0 0 0 68,125 70,743
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, 2011
Department of
Transportation
Next Generation Secure Driver License
System(PROG.0003, ITP.00200, DMV)
0 0 0 0 821,920 821,920
Department of
Transportation
PCI Compliance (ITP.00199, IS) 0 76,495 0 0 598,664 675,159
Department of
Transportation
SAP Claims Management (ITP.00204,
BSIP, P1)
209,846 2,722 0 0 59,938 272,506
Department of
Transportation
Spatial Data Viewer (SDV, ITP.00182,
ETS, P1)
952,709 0 0 0 0 952,709
Department of
Transportation
SPOT Assistance - Prioritization 2.0
(ITP.00205, BSIP)
237,409 3,081 0 0 67,833 308,323
Department of
Transportation
Stormwater Pollution Prevention Plan -
Spill Prevention (SPPP/SPCC) Website
(ITP.00201)
0 0 0 0 15,987 15,987
Department of
Transportation
TraCS Software Upgrade to Release
10.0 (ITP.00215, DMV)
0 0 0 0 22,657 22,657
Department of
Transportation
Training Partner Integration (ITP.00202,
BSIP)
0 0 0 0 99,328 99,328
Department of
Transportation
Trip Permits (ITP.00212, DMV) 0 23,600 0 0 23,762 47,362
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, 2011
Total Costs for Department of
Transportation
4,724,105 457,325 0 397,447 3,988,635 9,567,512
Employment Security
Commission
ES Encryption of Staff & Partner PCs
and Career Resource Center (CRC)
Upgrades
284,485 0 0 0 0 284,485
Employment Security
Commission
Southeast Consortium UI
Modernization Feasibility Study
526,630 0 0 0 0 526,630
Employment Security
Commission
UI Appeals Hosted Service for the
Integration of Digital Recording and
Teleconferencing
22,427 0 0 0 0 22,427
Employment Security
Commission
UI Chapanoke Expansion - St. Mary's
Relocation
136,720 0 0 0 0 136,720
Employment Security
Commission
UI Records Management Service
(RMS) Work Flow and Imaging System
44,090 0 0 0 0 44,090
Employment Security
Commission
UI Remote Service Center Relocation
Project
55,744 0 0 0 0 55,744
Employment Security
Commission
UI State Information Data Exchange
System (UI SIDES)
20,374 0 0 0 0 20,374
Employment Security
Commission
VoIP Telephony Replacement for ESC
Wade Avenue Complex
22,042 0 0 0 0 22,042
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, 2011
Total Costs for Employment Security
Commission
1,112,512 0 0 0 0 1,112,512
North Carolina
Turnpike Authority
Toll Collection Management System
(TCMS)
0 0 0 0 17,780,356 17,780,356
Total Costs for North Carolina
Turnpike Authority
0 0 0 0 17,780,356 17,780,356
Office of the Governor Budget and Performance Management
System - NC IBIS
0 0 0 0 2,586,993 2,586,993
Total Costs for Office of the
Governor
0 0 0 0 2,586,993 2,586,993
Office of the State
Controller
BEACON Hardware Refresh/Disaster
Recovery Landscape Project
0 0 0 0 1,217,593 1,217,593
Office of the State
Controller
Criminal Justice Data Integration Pilot
for Wake County
0 0 0 0 7,882,040 7,882,040
Total Costs for Office of the State
Controller
0 0 0 0 9,099,633 9,099,633
Total Costs for Non-ITS 41,833,168 488,713 0 21,023,545 61,323,614 124,669,040
Page 59
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, 2011
Office of Information
Technology Services
CGIA-NC Statewide Orthoimagery 2010 0 0 0 6,756,525 0 6,756,525
Office of Information
Technology Services
DNS Replacement 2010 0 0 0 0 607,050 607,050
Office of Information
Technology Services
E25K Retirement Project 0 0 0 0 6,478 6,478
Office of Information
Technology Services
Email Archiving 0 0 0 0 113,400 113,400
Office of Information
Technology Services
ESAP Remote Access VPN - Service
Introduction & Customer Migration
4,182 0 0 0 37,286 41,468
Office of Information
Technology Services
Exchange Service Improvement Project 0 0 0 72,339 766,616 838,955
Office of Information
Technology Services
Firewall/VPN - Service Refresh &
Customer Migration
0 0 0 0 40,257 40,257
Office of Information
Technology Services
Infrastructure Study & Assessment
(INSA) Project
0 0 0 0 1,854,804 1,854,804
Office of Information
Technology Services
IT Consolidation Phase III - DENR
Green Square Server Consolidation
0 0 0 458,955 0 458,955
Office of Information
Technology Services
Mainframe Software Toolset
Consolidation
0 0 0 1,617,016 0 1,617,016
Page 60
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, 2011
Office of Information
Technology Services
NCID Next Generation Upgrade 0 0 0 0 1,425,375 1,425,375
Office of Information
Technology Services
Project Management/Resource
Management Tool
0 0 0 0 35,957 35,957
Office of Information
Technology Services
Remote Office Backup Infrastructure 0 0 0 0 6,306 6,306
Office of Information
Technology Services
SONC Enterprise IVR SIP Migration 0 0 0 12,059 0 12,059
Office of Information
Technology Services
State Portal Initiative 0 0 0 0 112,992 112,992
Office of Information
Technology Services
Voice Mail Replacement - Lease 0 0 0 0 194,422 194,422
Total Costs for Office of Information
Technology Services
4,182 0 0 8,916,894 5,200,943 14,122,019
Total Costs for ITS 4,182 0 0 8,916,894 5,200,943 14,122,019
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, 2011
Community Colleges System
Office
College Data Accounting System 9,036 0 0 1,800 5,892 0 16,728
Current GED System 5,160 0 0 1,620 4,608 0 11,388
Data Warehouse - 2 356,496 0 0 4,992 172,774 0 534,262
Legacy GED System 0 0 18,715 0 0 0 18,715
SIRSI Library System 0 0 0 0 253,491 0 253,491
370,692 0 18,715 Total Costs for Community Colleges System Office 8,412 436,765 0 834,584
Department of Administration APT Accounts Receivable 7,729 0 0 0 0 0 7,729
APT SmartPlus 0 0 40,999 0 0 0 40,999
CFW DV & SA Statistical 3,865 0 0 0 0 0 3,865
CIA Bluemen Talent Search 0 0 249 0 0 0 249
CIA Section 8 Housing 4,176 0 0 0 0 0 4,176
DOA Mail List 3,865 0 0 0 0 0 3,865
DSP Federal Surplus Property 7,729 0 0 0 0 0 7,729
DSP Federal Surplus Property Sales 7,729 0 0 0 0 0 7,729
DSP State Surplus Property 46,376 0 0 0 0 0 46,376
FM Courier Accounts Receivable 7,729 0 0 0 0 0 7,729
FM Federal Surplus Accounts
Receivable
7,729 0 0 0 0 0 7,729
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, 2011
Department of Administration FM Temporary Solution Accounts
Receivable
7,729 0 0 0 0 0 7,729
HRM Applicant Tracking System 3,865 0 0 0 0 0 3,865
HUB HUBSCO 15,458 0 0 0 0 0 15,458
MFM NC Motor Fleet System 54,106 0 0 0 0 0 54,106
MIS Web Update Ticket System 12,270 0 0 0 0 0 12,270
MSC eSmart Mail Manager/Global 65 0 0 105,000 0 0 0 105,000
MSC eSmart Mail Manager/Global 77 0 0 125,000 0 0 0 125,000
MSC Global65 Courier Billing 34,951 0 0 0 0 0 34,951
MSC Heimann Systems/Xray Machine 0 0 1,000 0 0 0 1,000
MSC NetSort/Sabre 0 0 17,000 0 0 0 17,000
MSC USPS Billing 15,458 0 1,416 0 0 0 16,874
MSC WITS 1,800 0 0 0 0 0 1,800
NCVA Scholarship Program 3,063 0 0 0 0 0 3,063
P&C E-Procurement 0 0 10,825,036 0 0 0 10,825,036
P&C Interactive Purchasing and
Vendor Link
46,376 0 0 0 0 0 46,376
SEC State Clearinghouse
Intergovernmental Review Tracking
7,729 0 0 0 0 0 7,729
SPO Facility Information System (FIS) 0 0 9,017 0 0 0 9,017
SPO MAPIT 0 0 0 0 0 9,017 9,017
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, 2011
Department of Administration YAIO Youth Registration System 7,729 0 0 0 0 0 7,729
307,461 0 11,124,717 Total Costs for Department of Administration 0 0 9,017 11,441,195
Department of Agriculture and
Consumer Services
Agricultural Review System 1,550 0 0 0 0 0 1,550
Agronomic Lab Information System 29,255 0 44 0 0 1,046 30,345
Animal Health Programs Database
(formerly NCHAMS)
76,550 0 0 3,000 0 0 79,550
Applicant Tracking 5,100 0 0 0 0 0 5,100
Commissioners Correspondence
Tracking System
5,100 0 0 0 0 0 5,100
Commodity Assessments Program 11,100 0 0 0 0 0 11,100
Departmental Licensing System 10,100 0 640 0 0 0 10,740
F&V Terminal Market/Shipping Point 6,479 0 0 0 0 0 6,479
Farmer's Markets Gate Receipts System 7,670 1,211 0 0 0 0 8,881
Feed Label Review 2,400 0 0 0 0 0 2,400
Feed Report System 550 0 14 0 0 0 564
Feed Transcript System 1,800 0 37 0 0 0 1,837
Fertilizer Penalty System 110 0 16 0 0 0 126
Fertilizer Registration System 0 0 23 0 0 0 23
Fertilizer Transcript System 1,500 0 23 0 0 0 1,523
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, 2011
Department of Agriculture and
Consumer Services
Food and Drug LIMS 80,000 0 0 0 0 24,324 104,324
Food and Feed Firms 57,380 0 0 3,000 0 0 60,380
Food Distribution - Electronic
Commodity Ordering Portal
12,420 26,835 0 0 0 0 39,255
Food Distribution Tracking System 51,180 40,252 0 0 0 0 91,432
Food Sample Collection & Receiving 9,000 15,260 0 29,832 0 0 54,092
Forage Sample Login 300 0 0 0 0 0 300
FS Billing 4,165 0 0 0 0 0 4,165
Grain Grading and Billing 8,330 0 0 0 0 0 8,330
Grain Grading Certificates 8,021 0 0 0 0 0 8,021
Market News Grain 200 0 0 0 0 0 200
Market News Poultry System 450 0 0 0 0 0 450
Milled Peanut Certificates 2,468 0 0 0 0 0 2,468
Motor Fuel Registration System 200 0 11 0 0 0 211
Mountain State Fair Advanced Ticket
Sales
200 0 0 0 0 0 200
Mountain State Fair Exhibitor &
Concessionaires
318 0 0 0 0 0 318
Multi-Hazard Threat database 40,190 4,500 0 6,000 0 0 50,690
NCPlants 9,060 39,974 0 0 0 0 49,034
Office Supplies Inventory System 250 0 0 0 0 0 250
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, 2011
Department of Agriculture and
Consumer Services
Pesticide Inspection Forms (Miforms) 22,000 62,170 0 3,615 6,780 0 94,565
Pesticide Inspector Activity System 550 0 0 0 0 0 550
Pesticide Recertification System 250 0 0 0 0 0 250
Pesticide Registration 7,500 0 85 0 0 0 7,585
Rapid Entry Program for Market News 200 0 0 0 0 0 200
Seed Lab System 6,050 0 0 0 0 0 6,050
Standards Lab Scheduling System 293 0 0 0 0 0 293
State Fair Entry System 14,000 0 0 0 0 0 14,000
State Fair Event Management System 1,850 0 0 0 0 0 1,850
State Fair Folk Festival 4,500 0 0 0 0 0 4,500
State Maillist System 80 0 16 0 0 0 96
Structural Pest Automated Inspection
System
15,300 0 0 0 0 0 15,300
Structural Pest Control Recertification
System
350 0 20 0 0 0 370
Temporary and Part-time Payroll
System
5,300 0 0 0 0 0 5,300
Tonnage System 1,000 0 0 0 0 0 1,000
Veterinary LIMS 43,000 0 0 0 0 20,000 63,000
WebGT 10,500 0 0 0 0 0 10,500
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, 2011
576,119 190,202 929 45,447 Total Costs for Department of Agriculture and Consumer 6,780 45,370 864,847
Services
Department of Commerce !RET_AppTrack Application
Processing
17,613 0 0 5,156 2,424 0 25,193
!RET_AppTrack Position Posting 15,359 0 0 5,156 2,324 0 22,839
!RET_Commerce CMS - Content
Management System
27,549 0 0 10,107 2,883 0 40,539
!RET_Local Area Issuances 3,617 0 0 10,388 3,133 0 17,138
!RET_Tourism Economic Impact 3,617 0 0 8,811 3,892 0 16,320
!RET_Welcome Center Statistics 3,617 0 0 8,811 3,892 0 16,320
3m Core Grouping Inpatient Interactive
Module
2,000 0 0 1,000 5,600 0 8,600
ABC Online 23,375 0 0 0 0 0 23,375
ABC Permit System 23,375 0 0 0 0 0 23,375
ABC Pricing System 23,375 0 0 0 0 0 23,375
ABC Product Compliance System 14,025 0 0 0 0 0 14,025
ABC Violation Tracking System 9,350 0 0 0 0 0 9,350
Commerce CMS - Content
Management System (NEW)
95,774 0 0 5,574 7,458 0 108,806
Commerce Community Investment
Reports
49,535 0 0 3,544 2,502 0 55,581
Commerce CyberGrants 0 0 2,021 0 0 0 2,021
Commerce JobLink 15,979 0 0 5,156 2,424 0 23,559
Page 67
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, 2011
Department of Commerce Commerce Lyris ListManager 8,781 0 0 5,831 6,094 0 20,706
Commerce Redbook_BLIO
Permits/Licensing
10,006 0 0 10,388 5,247 0 25,641
Commerce Welcome Center Inventory
Management
5,606 0 0 5,301 2,514 0 13,421
Mainframe Host-on-Demand 110,000 3,557 0 7,000 0 0 120,557
Mediation 10,000 0 0 5,000 0 0 15,000
NCDWD FMIS Application 1,600 3,000 0 8,000 0 0 12,600
NCDWD Mobile Joblink Scheduling
Application
2,405 0 0 33 45 0 2,483
NCDWD ncwia web portal 250 0 0 33 42 0 325
NCDWD WIA Reporting Application
For WF+
4,167 0 0 92 171 0 4,430
NCDWD WorkforcePlus 3,333 0 3,667 2,333 0 4,167 13,500
NCIC Vault 10,000 0 109,636 5,000 0 0 124,636
NCIC Website Searchable Databases 12,000 0 0 5,000 6,080 0 23,080
PPD2 - Partial Permanent Disability 3,500 0 0 2,000 0 0 5,500
PRSP Economic Development
Intelligence System (EDIS)
9,600 417 0 10,517 0 8,583 29,117
RightFax 15,000 0 0 5,000 0 0 20,000
Scanning and Indexing 20,000 12,500 5,000 11,000 8,000 0 56,500
554,408 19,474 120,324 146,231 Total Costs for Department of Commerce 64,725 12,750 917,912
Page 68
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, 2011
Department of Correction Alcohol and Chemical Dependency
Program
38,400 0 0 165,484 0 0 203,884
Applicant Tracking System 24,659 0 0 26,309 0 0 50,968
Business Information & Data System 5,400 0 0 152,081 0 0 157,481
Cashless on the Net 24,659 0 0 599,692 0 0 624,351
Community Service 19,800 0 0 260,774 0 0 280,574
Criminal Justice Partnership 3,360 0 0 0 0 0 3,360
DOC Next Generation of OPUS 250,000 0 0 195,003 0 0 445,003
Drug Labs 2,400 0 0 22,977 0 0 25,377
Electronic House Arrest 0 0 0 1,669,774 0 0 1,669,774
Food Management System 35,400 0 0 141,267 0 0 176,667
Gate Log System 2,464 0 0 97 0 0 2,561
Inmates Telephone Pin # 1,639 0 0 9,930 0 0 11,569
Job Order System 33,840 0 0 15,272 0 0 49,112
Maintenance Management 5,640 0 0 75,454 0 0 81,094
Medical Operation Management 45,000 0 0 96,049 0 0 141,049
Offender Population Unified System 704,000 0 0 6,506,169 0 0 7,210,169
Offender Work Crew System 600 0 0 26,263 0 0 26,863
Optical 0 0 0 20,500 0 0 20,500
Page 69
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, 2011
Department of Correction OPUS web apps (Ext) 3,600 0 0 0 0 0 3,600
OPUS web apps (Int) 93,000 0 0 1,951,145 0 0 2,044,145
Pharmacy 0 0 0 37,334 0 205,640 242,974
PhotoID 48,000 0 0 23,184 0 0 71,184
Remedy 0 0 0 16,681 0 0 16,681
Roster Management 1,500 0 0 1,763 0 0 3,263
Safety and Environmental Health
Reporting System
42,000 0 0 1,399 0 0 43,399
Sex Offender GPS 0 0 0 980,661 0 0 980,661
1,385,361 0 0 12,995,262 Total Costs for Department of Correction 0 205,640 14,586,263
Department of Crime Control
and Public Safety
28 Day Work Cycle 16,640 7,105 0 33,333 0 0 57,078
Accident System 16,640 7,105 0 33,333 0 0 57,078
Activity Reports 16,640 7,105 0 33,333 0 0 57,078
ALE Case Tracking System (CTS - 1) 19,000 0 0 0 17,733 0 36,733
Aviation Documents 16,640 7,105 0 33,333 0 0 57,078
Aviation System 16,640 7,105 0 33,333 0 0 57,078
Bingo Licensing System 1,900 0 0 0 8,333 0 10,233
CAMEO/TIER II 11,100 0 0 0 0 0 11,100
Page 70
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, 2011
Department of Crime Control
and Public Safety
Canine Activity 36,640 0 0 33,333 0 0 69,973
CCPS Internet 15,600 0 0 0 8,333 0 23,933
Chemical Radiological 16,640 7,105 0 33,333 0 0 57,078
Citations 16,640 7,105 0 33,333 0 0 57,078
CJIN Mobile Data Switch 207,763 0 0 233,333 0 0 441,096
Collision Reconstruction 16,640 7,105 0 33,333 0 0 57,078
Computer Assisted Dispatch (CAD) 16,640 7,105 0 262,733 0 0 286,478
Contacts Database 15,600 0 0 0 8,333 0 23,933
Corrective Actions 16,640 7,105 0 33,333 0 0 57,078
Crime Victim Compensation 9,500 0 0 0 8,333 0 17,833
Daily Observation Reporting 16,640 7,105 0 33,333 0 0 57,078
Daily Operations Logs 16,640 7,105 0 33,333 0 0 57,078
DHS Grants Online 11,100 11,100 0 0 0 0 22,200
Disaster Tracking 11,100 11,100 0 0 0 0 22,200
DWI System 16,640 7,105 0 33,333 0 0 57,078
EM_GMS 1,900 0 0 0 8,333 0 10,233
EM_MOA 1,900 0 0 0 8,333 0 10,233
EMAP 11,100 11,100 0 0 0 0 22,200
Page 71
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, 2011
Department of Crime Control
and Public Safety
EMPG 11,100 11,100 0 0 0 0 22,200
Employee Holiday Time 16,640 7,105 0 33,333 0 0 57,078
Employee Roster 16,640 7,105 0 33,333 0 0 57,078
Employee Roster Report 16,640 7,105 0 33,333 0 0 57,078
Employee Transfer Regular and
Delayed
16,640 7,105 0 33,333 0 0 57,078
Employee Work Schedules 16,640 7,105 0 33,333 0 0 57,078
Excess Property Database 31,200 0 0 0 8,333 0 39,533
Firearms Tracking 36,640 0 0 33,333 0 0 69,973
Flood Inundation Mapping & Alert
Network
178,600 0 0 0 178,600 0 357,200
Flood Mapping Info System 2,000,000 0 0 0 2,000,000 0 4,000,000
Gas Mak Certification 36,640 0 0 33,333 0 0 69,973
Hazard Mitigation Planning 11,100 0 0 0 8,333 0 19,433
In-Service Class Registration 16,640 7,105 0 33,333 0 0 57,078
LESS Loan Program 15,600 0 0 0 8,333 0 23,933
Logistics Resources 16,640 7,105 0 33,333 0 0 57,078
Member Assistance team 16,640 7,105 0 33,333 0 0 57,078
Missing Persons Database 9,500 0 0 0 8,333 0 17,833
Mitigation Grants Management System 0 11,100 0 0 0 0 11,100
Page 72
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, 2011
Department of Crime Control
and Public Safety
NCDamp 0 11,100 0 0 0 0 11,100
NCEM Time & Attendance System 0 0 0 0 8,333 0 8,333
PAMS (Public Assistance Management
System)
0 11,100 0 0 0 0 11,100
Personal Information 16,640 7,105 0 33,333 0 0 57,078
Personnel Action 16,640 7,105 0 33,333 0 0 57,078
Physical Assessment Candidate
Selection
36,640 0 0 33,333 0 0 69,973
PIMA: Property & Inventory
Management
1,900 0 0 0 8,333 0 10,233
PreApp Reporting Database 0 0 0 0 8,333 0 8,333
Promotional Process 16,640 7,105 0 33,333 0 0 57,078
Recruiter Applicant 36,640 0 0 33,333 0 0 69,973
Retired Employees 16,640 7,105 0 33,333 0 0 57,078
Roster History 16,640 7,105 0 33,333 0 0 57,078
SAVAN VINE Court 0 0 822,790 0 0 0 822,790
SAVAN VINE Link/ VINE Watch/
VINE Photo
0 0 38,139 0 0 0 38,139
SAVAN VINE Sex Offender
Telephone Registry
0 0 66,000 0 0 0 66,000
SCP CAD Call Log 1,900 0 0 0 8,333 0 10,233
SCP Police PAK 1,900 0 0 0 8,333 0 10,233
Service Log 16,640 7,105 0 33,333 0 0 57,078
Page 73
Agency Application Name
Internal
Personnel
Costs
External
Personnel
Costs
Other
External
Costs
Hardware
Costs
Software
Costs
Other
Costs
Total YTD
Application
Cost
Object Description
Description
| Title | Information technology expenditures report : for the period ended... |
| Date | 2011 |
| Description | 2011 |
| Digital Characteristics-A | 1500 KB; 172 p. |
| Digital Format | application/pdf |
| Full Text | NORTH CAROLINA INFORMATION TECHNOLOGY EXPENDITURES REPORT For the Period Ended June 30, 2011 Office of the State Controller Office of Information Technology Services Office of State Budget and Management State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 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 ................................................................................... 34 Table 6-2 IT Expenditures – Projects by Source of Funds ................................................... 47 Table 6-3 IT Expenditures – Applications ........................................................................... 62 Table 6-4 IT Expenditures – Applications by Source of Funds ......................................... 116 THIS PAGE INTENTIONALLY LEFT BLANK State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 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 project 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 NC 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 NC 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. Reporting at the project and application level is not available for these exempt agencies since they do not provide this information to ITS for inclusion in the Information Technology Portfolio Management System. 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), the HR/Payroll System, and the Information Technology Portfolio Management System. This report covers the time period of July 2010 through June 2011 and includes all funding sources. Overview of IT Expenditures Total IT expenditures (excluding ITS) were $1,209,403,545 for fiscal year 2011. IT Expenditures for the Office of Information Technology totaled $184,943,370 during the same period. BUDGETED SALARY PLUS FRINGES 40.3% PERSONAL COMPUTER AND PRINTER 6.2% LOCAL AREA NETWORK 2.3% WIDE AREA NETWORK 1.4% VIDEO TRANSMISSION 0.6% SERVER 6.5% MAINFRAME 9.1% APPLICATIONS DEVELOP AND OTHER 22.3% TELECOMM 11.2% Total Information Technology Expenditures Excluding ITS State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 Page 2 As can be seen in this chart, Budgeted Salaries plus Fringes continue to be the largest percentage of IT related expenditures at 40.3% of total IT expenditures. The next largest categories of expenditures are Applications Development and Other (22.3%), Telecommunications (11.2%), and Mainframe (9.1%). 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 and the HR/Payroll System. 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. Employee training costs for IT personnel cannot be compiled or estimated using NCAS, PMIS or the HR/Payroll System. These costs are not included in this report. 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. State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 Page 3 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. Non-personnel related costs for the Department of Transportation are from the DOT financial system. University EPA information as well as personnel position information for the NC Education Lottery, NC Housing and Finance, and UNC Hospitals are provided by the agencies themselves. State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 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. 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 $62 million. 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 UNC System Agency 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. Total expenditures are calculated based on logic used to prepare the BD701-Agency Management Budget Report. Intragovernmental transactions are not included in an effort to avoid overstatement of total expenditures across funds. The following ITS Programs are shown separately on this report: Information Technology Fund, 911 Distribution, and the CGIA. These categories combined equal the ITS total as reported on tables 1-1 and 1-2. Page 5 Table 1-1 Information Technology Expenditures for Year Ended June 30, 2011 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 164,906 45,962 0 0 0 0 23,292 0 54,594 288,754 Community Colleges System Office 5,435,718 77,919 50,293 275 1,557 7,290,317 36,666 1,337,750 4,585,422 18,815,917 Department of Administration 861,019 802,022 364,993 3,960 62,508 161,960 408,344 11,084,539 609,993 14,359,338 Department of Agriculture & Consumer Services 2,571,498 473,454 47,178 98,697 693 349,864 255,003 213,551 1,097,429 5,107,367 Department of Commerce 3,652,036 894,713 396,741 4,441 0 258,408 349,137 420,006 1,100,963 7,076,445 Department of Correction 11,738,065 3,684,490 113,183 17,419 9,991 802,827 13,534,374 285,859 9,071,959 39,258,167 Department of Crime Control & Public Safety 6,877,078 1,222,162 153,709 212,599 13,097 1,258,618 793,901 514,000 6,272,257 17,317,421 Department of Cultural Resources 633,591 262,748 360 0 0 0 10 1,353,502 1,091,606 3,341,817 Department of Environment & Natural Resources 9,525,701 1,577,658 57,929 317,695 444 664,360 252,920 3,217,212 4,545,318 20,159,237 Department of Health and Human Services 33,285,079 5,486,109 2,784,726 217,415 4,020 5,282,058 21,147,142 118,307,053 11,296,888 197,810,490 Department of Insurance 1,799,970 353,976 0 34,706 0 290,262 19,555 109,515 313,991 2,921,975 Department of Justice 6,458,820 501,169 10,077 136,792 9,450 114,678 408,460 3,803,922 1,943,445 13,386,813 Department of Juvenile Justice & Delinq Prevention 993,579 1,974,083 733,211 0 0 522,161 154,883 207,470 1,050,429 5,635,816 Department of Labor 804,799 283,710 7,559 44,357 0 46,906 7,450 28,175 334,980 1,557,936 Department of Public Instruction 13,066,409 632,074 4,578,564 6,060,125 1,826 2,268,442 1,446,183 4,911,288 3,660,509 36,625,420 Department of Revenue 9,462,284 311,908 126,876 48,414 0 1,593,210 7,899,615 18,388,609 2,402,403 40,233,319 Department of Secretary of State 945,426 146,281 48,862 39,978 0 102,543 68,903 30,804 128,305 1,511,102 Department of the State Treasurer 4,626,810 17,140 66,445 1,080 0 26,386 134,190 3,197,218 459,618 8,528,887 Department of Transportation 31,864,011 11,154,757 1,847,633 28,485 91,671 4,155,298 28,413,424 9,830,924 17,047,972 104,434,175 Employment Security Commission 9,752,487 1,174,416 862,481 3,757 0 2,019,417 3,775,877 1,620,588 7,219,094 26,428,117 NC Housing Finance Authority 952,797 0 0 0 0 0 3,642 1,415,942 81,382 2,453,763 NC School Science & Math 455,038 176,467 0 72,531 87,736 0 6,104 40,022 47,215 885,113 NC Wildlife Resources 1,670,273 240,902 15,126 321,057 0 126,570 353,380 163,730 1,233,410 4,124,448 Office of Administrative Hearings 79,874 42,765 56,413 0 0 5,486 37,898 0 21,745 244,181 Office of the Governor 1,003,628 196,898 397,244 1,239 0 887,928 310,398 1,692,465 146,129 4,635,929 Office of the Lieutenant Governor 0 13,945 16 0 0 3,884 0 6,164 17,248 41,257 Office of the State Auditor 651,419 114,787 14,932 0 0 80,004 86,916 205,700 45,861 1,199,619 Office of the State Controller 6,625,587 290,006 2,037,924 0 0 2,330,171 2,835,439 6,820,568 458,328 21,398,023 State Board of Elections 2,311,370 267,973 7,611 4,446 0 203,652 1,019 2,619 95,839 2,894,529 Total w/o AOC, Lottery, UNC System & ITS 168,269,272 32,420,494 14,780,086 7,669,468 282,993 30,845,410 82,764,125 189,209,195 76,434,332 602,675,375 Administrative Office of the Courts 23,125,557 3,775,984 21,377 1,969,950 249,636 1,460,265 9,215,000 4,022,492 5,853,087 49,693,348 NC Education Lottery 2,272,050 438,084 25,118 158,916 783 298,458 16,782 448,735 1,102,058 4,760,984 UNC System 293,870,701 38,450,380 12,947,907 7,695,411 6,296,739 46,270,147 17,987,756 76,293,420 52,461,378 552,273,839 Total Without ITS 487,537,579 75,084,942 27,774,488 17,493,745 6,830,151 78,874,280 109,983,663 269,973,842 135,850,855 1,209,403,545 Office of Information Technology Services 51,715,362 3,461,113 5,148,298 7,783,807 61,934 27,147,803 23,391,527 13,956,019 52,277,507 184,943,370 Page 6 INTERNAL PERSONNEL COSTS EXTERNAL PERSONNEL COSTS OTHER EXTERNAL COSTS HARDWARE COSTS SOFTWARE COSTS OTHER COSTS YTD TOTALS Comprehensive Major Medical Plan 164,906 0 75,550 15,217 33,081 0 288,754 Community Colleges System Office 5,435,718 1,373,826 4,633,428 138,193 7,229,213 5,539 18,815,917 Department of Administration 861,019 808,656 12,224,588 25,362 412,776 26,937 14,359,338 Department of Agriculture & Consumer Services 2,571,498 63,202 1,496,916 542,568 386,670 46,513 5,107,367 Department of Commerce 3,652,036 1,010,250 1,781,256 262,945 322,037 47,921 7,076,445 Department of Correction 11,738,065 0 18,724,125 7,054,373 1,608,451 133,153 39,258,167 Department of Crime Control & Public Safety 6,877,078 14,128 4,324,961 4,739,579 1,324,391 37,284 17,317,421 Department of Cultural Resources 633,591 1,354,169 1,015,003 224,392 114,047 615 3,341,817 Department of Environment & Natural Resources 9,525,701 2,053,728 3,967,662 2,837,670 1,543,366 231,110 20,159,237 Department of Health and Human Services 33,285,079 117,181,042 35,110,141 5,593,871 5,187,199 1,453,158 197,810,490 Department of Insurance 1,799,970 43,402 413,847 374,607 224,111 66,038 2,921,975 Department of Justice 6,458,820 817,313 2,126,820 1,360,924 2,452,636 170,300 13,386,813 Department of Juvenile Justice & Delinq Prevention 993,579 2,574,393 1,814,482 73,275 81,562 98,525 5,635,816 Department of Labor 804,799 1,200 431,321 231,423 84,836 4,357 1,557,936 Department of Public Instruction 13,066,409 4,299,979 9,516,198 1,025,260 8,557,621 159,953 36,625,420 Department of Revenue 9,462,284 17,705,026 10,236,142 1,255,646 1,387,899 186,322 40,233,319 Department of Secretary of State 945,426 12,104 162,367 234,064 157,141 0 1,511,102 Department of the State Treasurer 4,626,810 121,830 653,005 1,424,519 1,696,428 6,295 8,528,887 Department of Transportation 31,864,011 12,342,712 43,195,559 7,895,411 8,278,242 858,240 104,434,175 Employment Security Commission 9,752,487 1,402,785 11,097,623 2,872,047 1,303,175 0 26,428,117 NC Housing Finance Authority 952,797 930,371 85,024 347,519 102,776 35,276 2,453,763 NC School Science & Math 455,038 19,300 52,119 231,467 127,189 0 885,113 NC Wildlife Resources 1,670,273 204,509 1,086,488 1,005,768 126,126 31,284 4,124,448 Office of Administrative Hearings 79,874 45,633 116,056 2,385 233 0 244,181 Office of the Governor 1,003,628 1,886,587 890,433 8,496 846,785 0 4,635,929 Office of the Lieutenant Governor 0 18,961 21,148 733 0 415 41,257 Office of the State Auditor 651,419 22,104 132,777 217,880 175,439 0 1,199,619 Office of the State Controller 6,625,587 7,231,343 4,899,673 23,818 2,611,099 6,503 21,398,023 State Board of Elections 2,311,370 7,611 189,825 287,149 96,453 2,121 2,894,529 Total w/o AOC, Lottery, UNC System & ITS 168,269,272 173,546,164 170,474,537 40,306,561 46,470,982 3,607,859 602,675,375 Administrative Office of the Courts 23,125,557 3,966,343 6,337,340 7,331,235 8,744,824 188,049 49,693,348 NC Education Lottery 2,272,050 163,323 1,120,549 916,371 240,799 47,892 4,760,984 UNC System 293,870,701 10,347,445 67,376,480 99,407,350 63,056,520 18,215,343 552,273,839 Total Without ITS 487,537,579 188,023,275 245,308,906 147,961,517 118,513,125 22,059,143 1,209,403,545 Office of Information Technology Services 51,715,362 6,772,585 62,362,663 21,061,200 42,989,212 42,348 184,943,370 Table 1-2 Information Technology Expenditures Grouped According to IT Portfolio Management System Detail Cost Categories for Year Ended June 30, 2011 Page 7 Table 1-3 Information Technology Expenditures UNC System Agencies for Year Ended June 30, 2011 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 12,935,342 435,182 0 495,690 0 695,966 33,088 7,758,404 995,801 23,349,473 East Carolina University 24,188,571 4,676,899 1,439,236 135,030 1,465,053 9,529,406 161,083 7,833,930 2,120,100 51,549,308 Elizabeth City State University 2,252,236 383,960 38,596 10,576 11,129 200,266 0 1,434,481 418,609 4,749,853 Fayetteville State University 2,362,656 700,271 728,203 127,942 8,556 542,846 144,782 1,503,178 551,002 6,669,436 NC A&T State University 7,110,352 154,441 2,663,360 402,626 204,526 554,145 11,167 2,216,924 731,846 14,049,387 NC Central University 6,264,898 0 0 1,320,256 949,401 0 0 3,982,037 1,377,680 13,894,272 NC School of Arts 1,099,255 615,160 213,168 304,127 86,743 234,282 285,931 490,170 291,385 3,620,221 NC State University 49,080,568 12,865,255 3,960,668 2,787,290 2,514,334 14,525,909 2,046,522 6,145,615 11,770,295 105,696,456 UNC Asheville 2,504,340 966,919 59,072 27,492 4,841 520,113 70,282 245,853 395,013 4,793,925 UNC Chapel Hill 97,476,428 22,450 101,432 753,291 120,622 124,414 6,947,327 25,356,249 14,528,079 145,430,292 UNC Charlotte 20,038,802 5,436,384 1,128,150 259,170 430,484 2,136,728 112,929 6,128,113 4,338,766 40,009,526 UNC General Administration 6,456,286 253,215 37,083 820,160 7,646 1,084,336 5,951,362 637,565 509,818 15,757,471 UNC Greensboro 15,579,740 6,113,901 257,127 59,107 3,773 1,246,476 95,005 4,350,880 2,737,964 30,443,973 UNC Hospital 21,323,131 430,553 329,997 17,153 27,157 8,064,352 1,542,820 1,006,317 4,079,432 36,820,912 UNC Pembroke 3,499,365 1,112,163 315,300 5,450 7,088 694,399 72,109 1,080,654 502,117 7,288,645 UNC Wilmington 9,907,495 1,836,665 637,658 70,922 351,751 2,928,079 30,762 1,565,598 4,498,457 21,827,387 Western Carolina University 6,695,228 764,323 683,547 50,562 41,799 1,377,278 112,250 1,888,956 1,225,658 12,839,601 Winston-Salem State University 5,096,008 1,682,639 355,310 48,567 61,836 1,811,152 370,337 2,668,496 1,389,356 13,483,701 TOTAL UNC System 293,870,701 38,450,380 12,947,907 7,695,411 6,296,739 46,270,147 17,987,756 76,293,420 52,461,378 552,273,839 Page 8 Total IT Expenditures Total Expenditures % IT Expenditures to Total Expenditures Comprehensive Major Medical Plan 288,754 2,649,596,840 0.01% Community Colleges System Office 18,815,917 1,419,037,452 1.33% Department of Administration 14,359,338 203,839,847 7.04% Department of Agriculture & Consumer Services 5,107,367 151,661,567 3.37% Department of Commerce 7,076,445 494,791,546 1.43% Department of Correction 39,258,167 1,564,236,989 2.51% Department of Crime Control & Public Safety 17,317,421 424,869,023 4.08% Department of Cultural Resources 3,341,817 106,977,925 3.12% Department of Environment & Natural Resources 20,159,237 790,975,871 2.55% Department of Health and Human Services 197,810,490 16,985,938,261 1.16% Department of Insurance 2,921,975 108,662,969 2.69% Department of Justice 13,386,813 137,957,203 9.70% Department of Juvenile Justice & Delinq Prevention 5,635,816 161,059,509 3.50% Department of Labor 1,557,936 29,299,505 5.32% Department of Public Instruction 36,625,420 10,101,428,409 0.36% Department of Revenue 40,233,319 161,730,620 24.88% Department of Secretary of State 1,511,102 13,299,109 11.36% Department of the State Treasurer 8,528,887 966,005,977 0.88% Department of Transportation 104,434,175 4,456,425,371 2.34% Employment Security Commission 26,428,117 4,594,397,545 0.58% NC Housing Finance Authority 2,453,763 168,462,040 1.46% NC School Science & Math 885,113 20,121,305 4.40% NC Wildlife Resources 4,124,448 78,281,987 5.27% Office of Administrative Hearings 244,181 5,985,561 4.08% Office of the Governor 4,635,929 1,083,350,260 0.43% Office of the Lieutenant Governor 41,257 890,047 4.64% Office of the State Auditor 1,199,619 16,099,660 7.45% Office of the State Controller 21,398,023 33,439,644 63.99% State Board of Elections 2,894,529 16,196,752 17.87% Total w/o AOC, Lottery, UNC System & ITS 602,675,375 46,945,018,798 1.28% Administrative Office of the Courts 49,693,348 612,900,146 8.11% NC Education Lottery 4,760,984 1,027,157,424 0.46% UNC System 552,273,839 11,835,462,512 4.67% Total Without ITS 1,209,403,545 60,420,538,880 2.00% Office of Information Technology Services 176,545,817 188,472,280 93.67% Information Technology Fund 6,955,007 7,072,524 98.34% E911 Board 211,789 82,357,657 0.26% CGIA 1,230,758 1,709,515 71.99% Table 1-4 Percentage of IT Expenditures to Total Expenditures for Year Ended June 30, 2011 State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 Page 9 Expenditure Summary by Budget Code Type While Table 1-1 shows all IT expenditures for the fiscal year, 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 $718,009,856.5 59.37% All Other Budget Codes $491,393,688.5 40.63% Total of all Budget Codes $ 1,209,403,545 100.00% 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. Page 10 Table 2-1 Information Technology Expenditures for General Fund Budget Codes for Year Ended June 30, 2011 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,435,718 77,919 50,293 275 1,557 6,626,312 36,666 1,233,472 4,585,422 18,047,634 Department of Administration 861,019 479,079 212,671 2,159 39,108 131,263 269,500 180,481 437,387 2,612,667 Department of Agriculture & Consumer Services 2,443,123 442,896 47,018 94,829 693 334,822 61,267 198,925 739,713 4,363,286 Department of Commerce 1,941,201 515,369 131,636 2,083 0 117,767 133,867 97,527 659,849 3,599,299 Department of Correction 10,929,392 3,477,800 106,441 71 5,963 802,827 13,534,374 203,728 8,947,058 38,007,654 Department of Crime Control & Public Safety 1,519,966 276,283 36,374 45,821 13,097 385,327 56,426 262,898 1,434,527 4,030,719 Department of Cultural Resources 633,591 256,636 360 0 0 0 10 1,353,502 1,011,215 3,255,314 Department of Environment & Natural Resources 7,902,158 1,254,942 37,163 303,223 276 589,233 203,410 2,130,117 3,386,796 15,807,318 Department of Health and Human Services 29,642,043 4,788,967 2,081,378 217,370 4,020 3,537,913 20,781,272 74,693,005 10,831,536 146,577,504 Department of Insurance 1,799,970 346,895 0 34,351 0 289,067 19,555 90,026 305,369 2,885,233 Department of Justice 6,458,820 398,582 4,677 135,818 4,851 98,550 8,038 2,616,637 1,724,356 11,450,329 Department of Juvenile Justice & Delinq Prevention 993,579 1,941,166 730,058 0 0 505,857 154,883 92,515 1,039,044 5,457,102 Department of Labor 804,799 283,710 7,559 44,357 0 46,906 7,450 28,175 334,980 1,557,936 Department of Public Instruction 13,066,409 630,688 4,328,107 6,034,870 1,826 2,260,490 1,402,330 4,426,882 3,658,037 35,809,639 Department of Revenue 9,462,284 288,722 107,516 47,457 0 1,069,755 7,133,568 715,003 2,371,687 21,195,992 Department of Secretary of State 945,426 110,883 41,602 39,978 0 101,450 27,206 18,697 108,639 1,393,881 Department of the State Treasurer 4,626,810 0 62,624 493 0 1,504 134,190 3,056,064 425,552 8,307,237 Department of Transportation 0 0 0 0 0 0 0 0 0 0 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 343,936 176,467 0 72,531 87,736 0 6,104 40,022 47,215 774,011 NC Wildlife Resources 0 0 0 0 0 0 0 0 0 0 Office of Administrative Hearings 79,874 42,765 56,413 0 0 5,486 37,898 0 21,745 244,181 Office of the Governor 1,003,628 196,298 394,946 1,229 0 882,170 309,920 1,690,863 144,892 4,623,946 Office of the Lieutenant Governor 0 13,945 16 0 0 3,884 0 6,164 17,248 41,257 Office of the State Auditor 651,419 114,787 14,932 0 0 80,004 86,916 205,700 45,861 1,199,619 Office of the State Controller 5,054,719 269,555 1,121,212 0 0 2,284,345 2,835,439 31,087 432,448 12,028,805 State Board of Elections 2,311,370 159,334 7,611 4,446 0 168,923 1,019 2,619 95,839 2,751,161 Total w/o AOC, Lottery, UNC System & ITS 108,911,254 16,543,688 9,580,607 7,081,361 159,127 20,323,855 47,241,308 93,374,109 42,806,415 346,021,724 Administrative Office of the Courts 20,361,468 2,807,227 21,377 1,969,931 248,536 1,460,265 8,032,371 1,171,297 4,344,478 40,416,950 NC Education Lottery 0 0 0 0 0 0 0 0 0 0 UNC System 167,946,285 30,212,758 8,766,228 5,087,937 3,241,690 32,506,970 9,788,928 51,773,414 22,246,973 331,571,183 Total Without ITS 297,219,007 49,563,673 18,368,212 14,139,229 3,649,353 54,291,090 65,062,607 146,318,820 69,397,866 718,009,857 Office of Information Technology Services 0 0 0 0 0 0 0 0 0 0 Page 11 Table 2-2 Information Technology Expenditures for All Other Budget Codes for Year Ended June 30, 2011 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 164,906 45,962 0 0 0 0 23,292 0 54,594 288,754 Community Colleges System Office 0 0 0 0 0 664,005 0 104,278 0 768,283 Department of Administration 0 322,943 152,322 1,801 23,400 30,697 138,844 10,904,058 172,606 11,746,671 Department of Agriculture & Consumer Services 128,375 30,558 160 3,868 0 15,042 193,736 14,626 357,716 744,081 Department of Commerce 1,710,835 379,344 265,105 2,358 0 140,641 215,270 322,479 441,114 3,477,146 Department of Correction 808,672 206,690 6,742 17,348 4,028 0 0 82,131 124,901 1,250,512 Department of Crime Control & Public Safety 5,357,112 945,879 117,335 166,778 0 873,291 737,475 251,102 4,837,730 13,286,702 Department of Cultural Resources 0 6,112 0 0 0 0 0 0 80,391 86,503 Department of Environment & Natural Resources 1,623,544 322,716 20,766 14,472 168 75,127 49,510 1,087,095 1,158,522 4,351,920 Department of Health and Human Services 3,643,036 697,142 703,348 45 0 1,744,145 365,870 43,614,048 465,352 51,232,986 Department of Insurance 0 7,081 0 355 0 1,195 0 19,489 8,622 36,742 Department of Justice 0 102,587 5,400 974 4,599 16,128 400,422 1,187,285 219,089 1,936,484 Department of Juvenile Justice & Delinq Prevention 0 32,917 3,153 0 0 16,304 0 114,955 11,385 178,714 Department of Labor 0 0 0 0 0 0 0 0 0 0 Department of Public Instruction 0 1,386 250,457 25,255 0 7,952 43,853 484,406 2,472 815,781 Department of Revenue 0 23,186 19,360 957 0 523,455 766,047 17,673,606 30,716 19,037,327 Department of Secretary of State 0 35,398 7,260 0 0 1,093 41,697 12,107 19,666 117,221 Department of the State Treasurer 0 17,140 3,821 587 0 24,882 0 141,154 34,066 221,650 Department of Transportation 31,864,011 11,154,757 1,847,633 28,485 91,671 4,155,298 28,413,424 9,830,924 17,047,972 104,434,175 Employment Security Commission 9,752,487 1,174,416 862,481 3,757 0 2,019,417 3,775,877 1,620,588 7,219,094 26,428,117 NC Housing Finance Authority 952,797 0 0 0 0 0 3,642 1,415,942 81,382 2,453,763 NC School Science & Math 111,101 0 0 0 0 0 0 0 0 111,101 NC Wildlife Resources 1,670,273 240,902 15,126 321,057 0 126,570 353,380 163,730 1,233,410 4,124,448 Office of Administrative Hearings 0 0 0 0 0 0 0 0 0 0 Office of the Governor 0 600 2,298 10 0 5,758 478 1,602 1,237 11,983 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 1,570,868 20,451 916,712 0 0 45,826 0 6,789,481 25,880 9,369,218 State Board of Elections 0 108,639 0 0 0 34,729 0 0 0 143,368 Total w/o AOC, Lottery, UNC System & ITS 59,358,017 15,876,806 5,199,479 588,107 123,866 10,521,555 35,522,817 95,835,086 33,627,917 256,653,650 Administrative Office of the Courts 2,764,090 968,757 0 19 1,100 0 1,182,629 2,851,195 1,508,609 9,276,399 NC Education Lottery 2,272,050 438,084 25,118 158,916 783 298,458 16,782 448,735 1,102,058 4,760,984 UNC System 125,924,416 8,237,622 4,181,679 2,607,474 3,055,049 13,763,177 8,198,828 24,520,006 30,214,405 220,702,656 Total Without ITS 190,318,573 25,521,269 9,406,276 3,354,516 3,180,798 24,583,190 44,921,056 123,655,022 66,452,989 491,393,689 Office of Information Technology Services 51,715,362 3,461,113 5,148,298 7,783,807 61,934 27,147,803 23,391,527 13,956,019 52,277,507 184,943,370 State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 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 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. Table 3-2 Information Technology Expenditures – Current Year versus Prior Year provides a comparison to prior year expenditures. 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. Page 13 ANNUAL BUDGETED SALARY AUTHORIZED BUDGET NON_SALARY ACCOUNTS TOTAL BUDGET ESTIMATE YTD ACTUAL ACTUAL as % of BUDGET Comprehensive Major Medical Plan 164,906 143,657 308,563 288,754 93.58% Community Colleges System Office 5,435,718 16,210,417 21,646,135 18,815,917 86.93% Department of Administration 861,019 20,901,776 21,762,795 14,359,338 65.98% Department of Agriculture & Consumer Services 2,571,498 2,800,910 5,372,408 5,107,367 95.07% Department of Commerce 3,652,036 5,717,747 9,369,783 7,076,445 75.52% Department of Correction 11,738,065 27,889,002 39,627,067 39,258,167 99.07% Department of Crime Control & Public Safety 6,877,078 20,179,830 27,056,908 17,317,421 64.00% Department of Cultural Resources 633,591 2,898,598 3,532,189 3,341,817 94.61% Department of Environment & Natural Resources 9,525,701 13,397,640 22,923,341 20,159,237 87.94% Department of Health and Human Services 33,285,079 199,080,763 232,365,842 197,810,490 85.13% Department of Insurance 1,799,970 1,532,386 3,332,356 2,921,975 87.68% Department of Justice 6,458,820 8,214,897 14,673,717 13,386,813 91.23% Department of Juvenile Justice & Delinq Prevention 993,579 5,280,001 6,273,580 5,635,816 89.83% Department of Labor 804,799 1,733,562 2,538,361 1,557,936 61.38% Department of Public Instruction 13,066,409 50,154,697 63,221,106 36,625,420 57.93% Department of Revenue 9,462,284 53,150,284 62,612,568 40,233,319 64.26% Department of Secretary of State 945,426 738,781 1,684,207 1,511,102 89.72% Department of the State Treasurer 4,626,810 4,691,732 9,318,542 8,528,887 91.53% Employment Security Commission 9,752,487 22,939,007 32,691,494 26,428,117 80.84% NC Housing Finance Authority 952,797 1,666,040 2,618,837 2,453,763 93.70% NC School Science & Math 455,038 459,552 914,590 885,113 96.78% NC Wildlife Resources 1,670,273 2,947,584 4,617,857 4,124,448 89.32% Office of Administrative Hearings 79,874 613,443 693,317 244,181 35.22% Office of the Governor 1,003,628 9,606,156 10,609,784 4,635,929 43.69% Office of the Lieutenant Governor 0 47,036 47,036 41,257 87.71% Office of the State Auditor 651,419 612,897 1,264,316 1,199,619 94.88% Office of the State Controller 6,625,587 15,618,563 22,244,150 21,398,023 96.20% State Board of Elections 2,311,370 3,543,627 5,854,997 2,894,529 49.44% Total w/o DOT, AOC, Lottery, UNC System & ITS 136,405,260 492,770,585 629,175,845 498,241,199 79.19% Administrative Office of the Courts 23,125,557 27,490,532 50,616,089 49,693,348 98.18% NC Education Lottery 2,272,050 4,425,938 6,697,988 4,760,984 71.08% Total Without DOT, UNC System & ITS 161,802,867 524,687,055 686,489,922 552,695,531 80.51% Office of Information Technology Services 51,715,362 139,174,182 190,889,544 184,943,370 96.89% Table 3-1 Information Technology Expenditures - Budget to Actual Comparison for Year Ended June 30, 2011 Page 14 Current Year Expenditures at 06/30/11 Prior Year Expenditures at 06/30/10 Increase / (Decrease) % Change Comprehensive Major Medical Plan 288,754 278,932 9,823 3.52% Community Colleges System Office 18,815,917 11,974,433 6,841,484 57.13% Department of Administration 14,359,338 3,279,904 11,079,434 337.80% Department of Agriculture & Consumer Services 5,107,367 5,040,466 66,901 1.33% Department of Commerce 7,076,445 6,644,356 432,089 6.50% Department of Correction 39,258,167 38,892,829 365,338 0.94% Department of Crime Control & Public Safety 17,317,421 20,400,897 (3,083,476) -15.11% Department of Cultural Resources 3,341,817 3,332,891 8,927 0.27% Department of Environment & Natural Resources 20,159,237 17,841,999 2,317,239 12.99% Department of Health and Human Services 197,810,490 182,605,485 15,205,005 8.33% Department of Insurance 2,921,975 3,007,894 (85,919) -2.86% Department of Justice 13,386,813 13,997,393 (610,580) -4.36% Department of Juvenile Justice & Delinq Prevention 5,635,816 3,547,687 2,088,128 58.86% Department of Labor 1,557,936 1,598,787 (40,851) -2.56% Department of Public Instruction 36,625,420 38,474,026 (1,848,606) -4.80% Department of Revenue 40,233,319 33,437,307 6,796,012 20.32% Department of Secretary of State 1,511,102 1,453,911 57,192 3.93% Department of the State Treasurer 8,528,887 8,772,208 (243,321) -2.77% Department of Transportation 104,434,175 91,357,049 13,077,127 14.31% Employment Security Commission 26,428,117 28,392,334 (1,964,217) -6.92% NC Housing Finance Authority 2,453,763 1,854,157 599,606 32.34% NC School Science & Math 885,113 618,000 267,112 43.22% NC Wildlife Resources 4,124,448 3,782,219 342,229 9.05% Office of Administrative Hearings 244,181 237,137 7,044 2.97% Office of the Governor 4,635,929 3,618,593 1,017,336 28.11% Office of the Lieutenant Governor 41,257 47,294 (6,037) -12.76% Office of the State Auditor 1,199,619 1,360,510 (160,891) -11.83% Office of the State Controller 21,398,023 21,062,846 335,176 1.59% State Board of Elections 2,894,529 3,443,200 (548,671) -15.93% Total w/o AOC, Lottery, UNC System & ITS 602,675,375 550,354,743 52,320,632 9.51% Administrative Office of the Courts 49,693,348 58,479,108 (8,785,759) -15.02% NC Education Lottery 4,760,984 4,659,082 101,902 2.19% UNC System 552,273,839 516,910,115 35,363,724 6.84% Total Without ITS 1,209,403,545 1,130,403,047 79,000,498 6.99% Office of Information Technology Services 184,943,370 189,942,710 (4,999,339) -2.63% Table 3-2 Information Technology Expenditures - Current Year Versus Prior Year for Years Ended June 30, 2011 and June 30, 2010 Page 15 Current Year Expenditures at 06/30/11 Prior Year Expenditures at 06/30/10 Increase / (Decrease) % Change Appalachian State University 23,349,473 21,047,852 2,301,621 10.94% East Carolina University 51,549,308 44,855,094 6,694,214 14.92% Elizabeth City State University 4,749,853 4,628,816 121,037 2.61% Fayetteville State University 6,669,436 6,729,385 (59,949) -0.89% NC A&T State University 14,049,387 15,302,346 (1,252,959) -8.19% NC Central University 13,894,272 11,562,627 2,331,645 20.17% NC School of Arts 3,620,221 3,726,455 (106,234) -2.85% NC State University 105,696,456 95,038,137 10,658,320 11.21% UNC Asheville 4,793,925 4,579,666 214,259 4.68% UNC Chapel Hill 145,430,292 143,461,859 1,968,434 1.37% UNC Charlotte 40,009,526 36,220,943 3,788,583 10.46% UNC General Administration 15,757,471 14,511,021 1,246,450 8.59% UNC Greensboro 30,443,973 33,306,369 (2,862,396) -8.59% UNC Hospital 36,820,912 30,793,632 6,027,280 19.57% UNC Pembroke 7,288,645 9,357,857 (2,069,212) -22.11% UNC Wilmington 21,827,387 18,738,562 3,088,825 16.48% Western Carolina University 12,839,601 12,771,298 68,303 0.53% Winston-Salem State University 13,483,701 10,278,197 3,205,504 31.19% TOTAL UNC System 552,273,839 516,910,115 35,363,724 6.84% Table 3-3 Information Technology Expenditures - Current Year Versus Prior Year for Years Ended June 30, 2011 and June 30, 2010 UNC System Agencies State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 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 Table 4-1 Information Technology Related Contracted Personal Services for Year Ended June 30, 2011 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 Community Colleges System Office 0 41,915 0 0 0 0 1,331,911 0 1,373,826 Department of Administration 550,233 30,028 0 0 26,735 0 201,660 0 808,656 Department of Agriculture & Consumer Services 0 0 0 0 26,123 0 37,079 0 63,202 Department of Commerce 712,052 54,957 0 0 0 0 243,241 0 1,010,250 Department of Correction 0 0 0 0 0 0 0 0 0 Department of Crime Control & Public Safety 2,834 5,796 0 0 5,498 0 0 0 14,128 Department of Cultural Resources 4,100 0 0 0 0 0 1,350,069 0 1,354,169 Department of Environment & Natural Resources 0 12,864 0 0 0 720 2,040,144 0 2,053,728 Department of Health and Human Services 70 999,509 0 2,230 6,170 0 116,173,063 0 117,181,042 Department of Insurance 0 0 0 0 0 0 43,402 0 43,402 Department of Justice 0 0 0 0 0 0 817,313 0 817,313 Department of Juvenile Justice & Delinq Prevention 1,884,157 397,998 0 0 187,568 0 104,670 0 2,574,393 Department of Labor 0 0 0 0 0 0 1,200 0 1,200 Department of Public Instruction 0 161,119 0 0 0 0 4,138,860 0 4,299,979 Department of Revenue 0 0 0 0 0 0 17,705,026 0 17,705,026 Department of Secretary of State 0 12,104 0 0 0 0 0 0 12,104 Department of the State Treasurer 16,815 30,092 0 0 0 0 74,923 0 121,830 Department of Transportation 3,563,573 361,036 0 0 216,421 1,428,838 6,772,843 0 12,342,711 Employment Security Commission 0 37,290 0 0 0 0 1,365,495 0 1,402,785 NC Housing Finance Authority 0 0 0 0 0 0 930,371 0 930,371 NC School Science & Math 0 0 19,300 0 0 0 0 0 19,300 NC Wildlife Resources 0 0 155,037 0 0 0 49,472 0 204,509 Office of Administrative Hearings 40,380 0 0 0 5,253 0 0 0 45,633 Office of the Governor 191,824 2,298 0 0 0 0 1,692,465 0 1,886,587 Office of the Lieutenant Governor 13,212 0 0 0 0 0 5,749 0 18,961 Office of the State Auditor 0 0 0 0 0 0 22,104 0 22,104 Office of the State Controller 292,263 21,176 0 0 104,787 0 6,813,117 0 7,231,343 State Board of Elections 0 7,611 0 0 0 0 0 0 7,611 Total w/o AOC, Lottery, UNC System & ITS 7,271,513 2,175,793 174,337 2,230 578,555 1,429,558 161,914,177 0 173,546,163 Administrative Office of the Courts 434,010 0 0 0 0 0 3,532,333 0 3,966,343 NC Education Lottery 0 0 71,813 0 28,111 0 63,399 0 163,323 UNC System 132,327 260,160 154,392 32,539 1,695,758 267,167 7,805,102 0 10,347,445 Total Without ITS 7,837,850 2,435,953 400,542 34,769 2,302,424 1,696,725 173,315,011 0 188,023,274 Office of Information Technology Services 916,471 122,558 215,567 0 0 0 5,517,989 0 6,772,585 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 50 0 0 0 6,604 0 6,654 East Carolina University 43,035 217,811 91,294 17,053 1,211,437 0 1,301,630 0 2,882,260 Elizabeth City State University 0 0 0 0 0 0 0 0 0 Fayetteville State University -3,112 1,188 130 396 2,067 144,087 2,049 0 146,805 NC A&T State University 0 1,000 0 0 0 1,993 12,844 0 15,837 NC Central University 0 0 0 0 0 0 0 0 0 NC School of Arts 0 0 0 0 0 0 105 0 105 NC State University 10,503 4,623 38,534 12,090 59,022 0 1,135,925 0 1,260,697 UNC Asheville 0 0 0 0 67,643 0 174,069 0 241,712 UNC Chapel Hill 0 0 0 0 0 0 2,088,057 0 2,088,057 UNC Charlotte 9,300 1,038 0 1,000 60 0 276,468 0 287,866 UNC General Administration 0 29,850 17,082 2,000 12,260 0 1,845 0 63,037 UNC Greensboro 1,363 0 0 0 236 354 11,373 0 13,326 UNC Hospital 69,174 900 0 0 292,077 120,733 764,942 0 1,247,826 UNC Pembroke 0 0 0 0 956 0 255,280 0 256,236 UNC Wilmington 0 0 0 0 0 0 30,366 0 30,366 Western Carolina University 2,064 3,750 7,302 0 0 0 5,939 0 19,055 Winston-Salem State University 0 0 0 0 50,000 0 1,737,606 0 1,787,606 TOTAL UNC System 132,327 260,160 154,392 32,539 1,695,758 267,167 7,805,102 0 10,347,445 Table 4-2 Information Technology Related Contracted Personal Services UNC System Agencies for Year Ended June 30, 2011 State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 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 the HR/Payroll System as well as PMIS and include both vacant and filled IT positions. A position is identified as IT related based on the position's class code. NC Housing and Finance and the NC Education Lottery provide information for the report that is not available in either of these systems. Table 5-2 Salary and Calculated Fringes for All IT Positions-UNC System Agencies lists by UNC System Agency the same information described above. Some of these agencies are not required to enter all of their position information in PMIS. The additional needed information has been provided by them and is incorporated into the report. Actual fringe benefit amounts are not available but an estimate is calculated in these tables based on the following criteria: OASDI – 6.2% of budgeted salary amount capped at $106,800 per FTE HI – 1.45% of budgeted salary amount Retirement – 10.51% of budgeted salary amount Hospitalization – $4,929.60 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 Table 5-1 Salary and Calculated Fringes for All IT Positions Annual Budgeted Salary as reported June 30, 2011 TOTAL FTE'S ANNUAL BUDGETED SALARY OASDI HI RETIRE HOSPITAL TOTAL AVERAGE PER FTE Comprehensive Major Medical Plan 2.00 131,218 8,136 1,903 13,791 9,859 164,906 82,453 Community Colleges System Office 64.00 4,333,722 268,188 62,839 455,474 315,494 5,435,718 84,933 Department of Administration 11.00 682,797 42,333 9,901 71,762 54,226 861,019 78,274 Department of Agriculture & Consumer Services 34.00 2,034,438 126,135 29,499 213,819 167,606 2,571,498 75,632 Department of Commerce 39.00 2,929,383 180,045 42,476 307,878 192,254 3,652,036 93,642 Department of Correction 141.00 9,347,979 576,994 135,546 982,473 695,074 11,738,065 83,249 Department of Crime Control & Public Safety 92.00 5,436,319 337,052 78,827 571,357 453,523 6,877,078 74,751 Department of Cultural Resources 8.00 502,839 31,176 7,291 52,848 39,437 633,591 79,199 Department of Environment & Natural Resources 125.00 7,540,578 467,070 109,338 792,515 616,200 9,525,701 76,206 Department of Health and Human Services 389.15 26,550,223 1,641,096 384,978 2,790,428 1,918,354 33,285,079 85,533 Department of Insurance 19.00 1,444,065 89,532 20,939 151,771 93,662 1,799,970 94,735 Department of Justice 75.00 5,155,416 317,096 74,754 541,834 369,720 6,458,820 86,118 Department of Juvenile Justice & Delinq Prevention 11.00 794,984 49,289 11,527 83,553 54,226 993,579 90,325 Department of Labor 11.00 635,218 39,384 9,211 66,761 54,226 804,799 73,164 Department of Public Instruction 146.75 10,449,356 643,891 151,516 1,098,227 723,419 13,066,409 89,039 Department of Revenue 106.25 7,567,497 465,945 109,729 795,344 523,770 9,462,284 89,057 Department of Secretary of State 11.00 754,505 46,457 10,940 79,298 54,226 945,426 85,948 Department of the State Treasurer 49.00 3,713,212 227,947 53,842 390,259 241,550 4,626,810 94,425 Department of Transportation 345.00 25,530,519 1,579,330 370,192 2,683,258 1,700,712 31,864,011 92,359 Employment Security Commission 106.00 7,811,399 484,307 113,265 820,978 522,538 9,752,487 92,005 NC Housing Finance Authority 10.00 764,642 47,408 11,087 80,364 49,296 952,797 95,280 NC School Science & Math 6.00 360,071 22,324 5,221 37,843 29,578 455,038 75,840 NC Wildlife Resources 19.00 1,334,577 82,418 19,351 140,264 93,662 1,670,273 87,909 Office of Administrative Hearings 1.00 63,426 3,932 920 6,666 4,930 79,874 79,874 Office of the Governor 10.00 807,773 49,949 11,713 84,897 49,296 1,003,628 100,363 Office of the Lieutenant Governor 0.00 0 0 0 0 0 0 0 Office of the State Auditor 7.00 522,099 32,370 7,570 54,873 34,507 651,419 93,060 Office of the State Controller 69.50 5,318,463 328,428 77,118 558,970 342,607 6,625,587 95,332 State Board of Elections 31.00 1,826,805 113,262 26,489 191,997 152,818 2,311,370 74,560 Total w/o AOC, Lottery, UNC System & ITS 1,938.65 134,343,523 8,301,494 1,947,982 14,119,504 9,556,769 168,269,272 86,797 Administrative Office of the Courts 245.75 18,551,944 1,143,352 269,003 1,949,809 1,211,449 23,125,557 94,102 NC Education Lottery 30.00 1,799,361 109,597 26,091 189,113 147,888 2,272,050 75,735 UNC System 3,583.75 233,912,856 14,315,410 3,391,738 24,584,242 17,666,454 293,870,701 82,001 Total Without ITS 5,798.15 388,607,684 23,869,853 5,634,814 40,842,668 28,582,560 487,537,579 84,085 Office of Information Technology Services 538.43 41,540,152 2,552,763 602,332 4,365,870 2,654,245 51,715,362 96,048 Page 21 Table 5-2 Salary and Calculated Fringes for All IT Positions Annual Budgeted Salary - UNC System Agencies as reported June 30, 2011 TOTAL FTE'S ANNUAL BUDGETED SALARY OASDI HI RETIRE HOSPITAL TOTAL AVERAGE PER FTE Appalachian State University 156.75 10,296,658 634,489 149,302 1,082,179 772,715 12,935,342 82,522 East Carolina University 317.05 19,150,325 1,184,937 277,680 2,012,699 1,562,930 24,188,571 76,293 Elizabeth City State University 34.00 1,764,243 109,383 25,582 185,422 167,606 2,252,236 66,242 Fayetteville State University 35.00 1,854,528 113,790 26,891 194,911 172,536 2,362,656 67,504 NC A&T State University 97.00 5,616,552 343,889 81,440 590,300 478,171 7,110,352 73,303 NC Central University 86.00 4,946,696 302,631 71,727 519,898 423,946 6,264,898 72,848 NC School of Arts 14.00 872,228 53,694 12,647 91,671 69,014 1,099,255 78,518 NC State University 571.04 39,177,671 2,402,249 568,077 4,117,573 2,814,999 49,080,568 85,949 UNC Asheville 36.50 1,967,339 121,777 28,526 206,767 179,930 2,504,340 68,612 UNC Chapel Hill 1,153.81 77,725,156 4,767,521 1,127,015 8,168,914 5,687,822 97,476,428 84,482 UNC Charlotte 237.50 15,977,601 979,500 231,675 1,679,246 1,170,780 20,038,802 84,374 UNC General Administration 70.00 5,182,842 308,504 75,151 544,717 345,072 6,456,286 92,233 UNC Greensboro 199.80 12,361,987 754,325 179,249 1,299,245 984,934 15,579,740 77,977 UNC Hospital 219.00 17,170,173 1,019,823 248,968 1,804,585 1,079,582 21,323,131 97,366 UNC Pembroke 53.00 2,741,362 168,867 39,750 288,117 261,269 3,499,365 66,026 UNC Wilmington 139.30 7,808,385 478,534 113,222 820,661 686,693 9,907,495 71,123 Western Carolina University 97.00 5,264,349 323,091 76,333 553,283 478,171 6,695,228 69,023 Winston-Salem State University 67.00 4,034,761 248,407 58,504 424,053 330,283 5,096,008 76,060 TOTAL UNC System 3,583.75 233,912,856 14,315,410 3,391,738 24,584,242 17,666,454 293,870,701 82,001 State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 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, 2011.) Table 5-4 Total IT Salary and Fringe Amount by Position Status-UNC System Agencies lists this same information by UNC System Agency. 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 positions 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, NC Education Lottery, NC Housing and Finance, and UNC System). Page 23 FILLED POSITIONS VACANT POSITIONS ALL POSITIONS % VACANT OF TOTAL Comprehensive Major Medical Plan 164,906 0 164,906 0.00% Community Colleges System Office 5,029,757 405,961 5,435,718 7.47% Department of Administration 861,019 0 861,019 0.00% Department of Agriculture & Consumer Services 2,433,446 138,052 2,571,498 5.37% Department of Commerce 3,316,123 335,913 3,652,036 9.20% Department of Correction 10,680,964 1,057,100 11,738,065 9.01% Department of Crime Control & Public Safety 6,161,638 715,440 6,877,078 10.40% Department of Cultural Resources 633,591 0 633,591 0.00% Department of Environment & Natural Resources 8,419,206 1,106,496 9,525,701 11.62% Department of Health and Human Services 30,073,523 3,211,557 33,285,079 9.65% Department of Insurance 1,614,098 185,872 1,799,970 10.33% Department of Justice 6,345,419 113,402 6,458,820 1.76% Department of Juvenile Justice & Delinq Prevention 918,981 74,598 993,579 7.51% Department of Labor 804,799 0 804,799 0.00% Department of Public Instruction 11,340,531 1,725,878 13,066,409 13.21% Department of Revenue 8,113,436 1,348,848 9,462,284 14.25% Department of Secretary of State 945,426 0 945,426 0.00% Department of the State Treasurer 4,399,791 227,018 4,626,810 4.91% Department of Transportation 28,280,992 3,583,020 31,864,011 11.24% Employment Security Commission 8,614,221 1,138,266 9,752,487 11.67% NC Housing Finance Authority 952,797 0 952,797 0.00% NC School Science & Math 455,038 0 455,038 0.00% NC Wildlife Resources 1,670,273 0 1,670,273 0.00% Office of Administrative Hearings 79,874 0 79,874 0.00% Office of the Governor 919,781 83,846 1,003,628 8.35% Office of the Lieutenant Governor 0 0 0 N/A Office of the State Auditor 523,603 127,816 651,419 19.62% Office of the State Controller 5,890,251 735,335 6,625,587 11.10% State Board of Elections 2,252,583 58,787 2,311,370 2.54% Total w/o AOC, Lottery, UNC System & ITS 151,896,068 16,373,204 168,269,272 9.73% Administrative Office of the Courts 21,955,257 1,170,300 23,125,557 5.06% NC Education Lottery 2,036,157 235,892 2,272,050 10.38% UNC System 257,277,156 36,593,544 293,870,701 12.45% Total Without ITS 433,164,639 54,372,940 487,537,579 11.15% Office of Information Technology Services 44,571,611 7,143,752 51,715,362 13.81% Table 5-3 Total IT Salary and Fringe Amount By Position Status Annual Budgeted Amounts as reported June 30, 2011 Page 24 FILLED POSITIONS VACANT POSITIONS ALL POSITIONS % VACANT OF TOTAL Appalachian State University 12,125,845 809,498 12,935,342 6.26% East Carolina University 21,963,947 2,224,624 24,188,571 9.20% Elizabeth City State University 2,098,509 153,727 2,252,236 6.83% Fayetteville State University 1,905,364 457,292 2,362,656 19.35% NC A&T State University 5,607,646 1,502,706 7,110,352 21.13% NC Central University 5,425,891 839,006 6,264,898 13.39% NC School of Arts 1,099,255 0 1,099,255 0.00% NC State University 44,036,208 5,044,360 49,080,568 10.28% UNC Asheville 2,263,773 240,567 2,504,340 9.61% UNC Chapel Hill 83,231,487 14,244,941 97,476,428 14.61% UNC Charlotte 17,784,447 2,254,355 20,038,802 11.25% UNC General Administration 5,385,593 1,070,693 6,456,286 16.58% UNC Greensboro 15,081,874 497,866 15,579,740 3.20% UNC Hospital 18,332,723 2,990,408 21,323,131 14.02% UNC Pembroke 3,023,152 476,213 3,499,365 13.61% UNC Wilmington 8,757,662 1,149,833 9,907,495 11.61% Western Carolina University 5,419,649 1,275,579 6,695,228 19.05% Winston-Salem State University 3,734,132 1,361,876 5,096,008 26.72% Total UNC System 257,277,156 36,593,544 293,870,701 12.45% Table 5-4 Total IT Salary and Fringe Amount By Position Status UNC System Agencies Annual Budgeted Amounts as reported June 30, 2011 Page 25 FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes FTE Salary/Fringes Comprehensive Major Medical Plan 1.00 109,383 0.00 0 0.00 0 0.00 0 1.00 55,523 Community Colleges System Office 8.00 882,827 9.00 741,481 1.00 98,158 36.00 3,048,105 10.00 665,147 Department of Administration 1.00 120,269 0.00 0 0.00 0 5.00 415,005 5.00 325,745 Department of Agriculture & Consumer Services 1.00 134,312 0.00 0 1.00 102,057 25.00 1,884,579 7.00 450,550 Department of Commerce 5.00 641,548 3.00 336,303 1.00 76,204 24.00 2,193,629 6.00 404,353 Department of Correction 13.00 1,624,702 5.00 406,792 30.00 2,395,633 39.00 4,104,699 54.00 3,206,240 Department of Crime Control & Public Safety 3.00 359,008 4.00 337,738 38.00 2,535,754 18.00 1,609,653 29.00 2,034,926 Department of Cultural Resources 1.00 104,764 0.00 0 1.00 82,619 5.00 371,903 1.00 74,306 Department of Environment & Natural Resources 9.00 1,015,495 0.00 0 1.00 95,219 55.00 4,453,853 60.00 3,961,135 Department of Health and Human Services 55.01 6,257,813 35.00 2,264,374 34.04 2,891,720 175.04 16,022,096 90.06 5,849,076 Department of Insurance 2.00 247,029 0.00 0 3.00 262,529 9.00 895,089 5.00 395,323 Department of Justice 13.00 1,602,816 9.00 913,896 5.00 338,911 26.00 2,212,088 22.00 1,391,109 Department of Juvenile Justice & Delinq Prevention 2.00 245,552 0.00 0 0.00 0 7.00 595,851 2.00 152,176 Department of Labor 2.00 197,234 0.00 0 0.00 0 3.00 257,605 6.00 349,960 Department of Public Instruction 12.00 1,468,326 8.00 620,779 10.00 885,935 73.00 7,049,208 43.75 3,042,161 Department of Revenue 15.00 1,820,614 19.00 1,601,844 7.00 664,235 46.25 4,221,145 19.00 1,154,446 Department of Secretary of State 3.00 364,809 0.00 0 0.00 0 4.00 337,740 4.00 242,878 Department of the State Treasurer 3.00 434,402 2.00 212,409 3.00 297,565 26.00 2,687,885 15.00 994,549 Department of Transportation 48.00 5,685,444 26.00 2,384,549 7.00 703,176 197.00 18,529,565 67.00 4,561,277 Employment Security Commission 12.00 1,454,267 31.00 2,593,039 6.00 514,913 47.00 4,520,577 10.00 669,692 NC Housing Finance Authority NC School Science & Math 1.00 111,101 2.00 171,273 0.00 0 0.00 0 3.00 172,664 NC Wildlife Resources 3.00 386,758 0.00 0 4.00 309,701 8.00 718,713 4.00 255,101 Office of Administrative Hearings 0.00 0 0.00 0 1.00 79,874 0.00 0 0.00 0 Office of the Governor 2.00 254,252 0.00 0 0.00 0 8.00 749,375 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 127,816 0.00 0 1.00 98,835 3.00 276,239 2.00 148,529 Office of the State Controller 13.00 1,618,600 6.00 484,201 1.00 81,734 36.50 3,509,602 13.00 931,451 State Board of Elections 3.00 339,373 1.00 102,163 0.00 0 12.00 946,448 15.00 923,386 Total w/o AOC, Lottery, UNC System & ITS 232.01 27,608,513 160.00 13,170,841 155.04 12,514,769 887.79 81,610,651 493.81 32,411,701 Administrative Office of the Courts NC Education Lottery UNC System 211.90 24,078,343 488.75 43,046,760 208.00 16,730,105 1,047.88 89,871,776 1,262.38 80,386,903 Total Without ITS 443.91 51,686,856 648.75 56,217,601 363.04 29,244,874 1,935.67 171,482,427 1,756.19 112,798,604 Office of Information Technology Services 84.08 10,581,962 126.22 11,127,808 150.09 13,182,475 130.04 13,534,284 48.00 3,288,833 Non-banded positions include in Table 5-1: AOC 23,125,557 Univ 39,756,813 Lottery 2,272,050 Housing Finance Authority 952,797 Table 5-5 Salary and Calculated Fringes by Banding Category for All IT Positions Annual Budgeted Amounts as reported June 30, 2011 Information Technology Operations and Systems Networking Business and Technology Applications Technical Support State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 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, 2011. The agencies are grouped by legislative committee for this table. The NC Education Lottery is also included for informational purposes. Page 27 Table 5-6 Information Technology FTEs versus All FTEs As Reported June 30, 2011 Filled Information Technology Positions Vacant Information Technology Positions Total Information Technology Positions Total All Positions % IT of Total Education Community Colleges System Office 59.00 5.00 64.00 212.00 30. 19% Department of Public Instruction 127.75 19.00 146.75 1,443.31 10.17% NC School Science & Math 6.00 0.00 6.00 192.24 3.12% UNC System 3,098.74 485.01 3,583.75 33,103.50 10.83% Education Total: 3,291.49 509.01 3,800.50 34,951.05 10.87% General Government Department of Administration 11.00 0.00 11.00 729.29 1.51% Department of Cultural Resources 8.00 0.00 8.00 894.81 0.89% Department of Insurance 17.00 2.00 19.00 444.41 4.28% Department of Revenue 91.25 15.00 106.25 1,506.25 7.05% Department of Secretary of State 11.00 0.00 11.00 202.75 5.43% Department of the State Treasurer 47.00 2.00 49.00 378.00 12.96% NC Housing Finance Authority 10.00 0.00 10.00 119.00 8.40% Office of Administrative Hearings 1.00 0.00 1.00 42.00 2.38% Office of the Governor 9.00 1.00 10.00 161.00 6.21% Office of the State Auditor 6.00 1.00 7.00 193.00 3.63% Office of the State Controller 62.00 7.50 69.50 224.25 30.99% State Board of Elections 30.00 1.00 31.00 136.00 22.79% General Government Total: 303.25 29.50 332.75 5,030.76 6.61% Human Resources Department of Health and Human Services 353.12 36.03 389.15 18,150.80 2.14% Human Resources Total: 353.12 36.03 389.15 18,150.80 2.14% Justice and Public Safety Administrative Office of the Courts 232.75 13.00 245.75 6,948.12 3.54% Department of Correction 128.00 13.00 141.00 21,747.00 0.65% Department of Crime Control & Public Safety 82.00 10.00 92.00 3,108.75 2.96% Department of Justice 74.00 1.00 75.00 1,378.63 5.44% Department of Juvenile Justice & Delinq Prevention 10.00 1.00 11.00 1,876.25 0.59% Justice and Public Safety Total: 526.75 38.00 564.75 35,058.75 1.61% Natural and Economic Resources Department of Agriculture & Consumer Services 32.00 2.00 34.00 1,375.50 2.47% Department of Commerce 35.00 4.00 39.00 912.97 4.27% Department of Environment & Natural Resources 110.00 15.00 125.00 3,923.61 3.19% Department of Labor 11.00 0.00 11.00 410.28 2.68% Employment Security Commission 93.00 13.00 106.00 2,449.48 4.33% NC Wildlife Resources 19.00 0.00 19.00 658.13 2.89% Natural and Economic Resources Total: 300.00 34.00 334.00 9,729.97 3.43% Salaries and Benefits Retirement Comprehensive Major Medical Plan 2.00 0.00 2.00 42.00 4.76% Salaries Benefits Retirement Total: 2.00 0.00 2.00 42.00 4.76% Transportation Department of Transportation 306.00 39.00 345.00 13,584.00 2.54% Transportation Total: 306.00 39.00 345.00 13,584.00 2.54% NC Education Lottery NC Education Lottery 26.00 4.00 30.00 244.98 12.25% NC Education Lottery Total: 26.00 4.00 30.00 244.98 12.25% Office of Information Technology Services Office of Information Technology Services 465.41 73.02 538.43 631.43 85.27% Office of Information Technology Services Total: 465.41 73.02 538.43 631.43 85.27% Total: 5,574.02 762.56 6,336.58 117,423.74 5.40% State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 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 provided for the university system, the Administrative Office of the Courts or the General Assembly. What is Portfolio Management? Portfolio Management (PM) is the grouping of computer applications and projects to examine an organization’s spending, risk profile, and plans for technology. Just as one manages a personal retirement fund or budget, the state manages its technology portfolio for the future. It does this by managing IT investments from the agency, program (closely-related projects with common business goals) and statewide perspectives to maximize citizen benefits and public value for costs within acceptable risk profiles. The intent is to build and maintain project and application portfolios that reflect the value of the investment and aid the agency in optimizing business decisions about technology. The state’s technology profile is composed of several key elements: projects, existing applications, people, hardware and software. Other sections of this report give information on the costs of personnel and hardware and software. This section addresses projects and existing applications. Project Portfolio Management Project Portfolio Management (PPM) focuses on new technology projects intended to improve the delivery of existing services or to provide new services. Projects have a definite timeline, a budget, and a set of deliverables. When they are completed, the state should have a new service or improved infrastructure to build on for the future. Application Portfolio Management Application Portfolio Management (APM) focuses on the state’s existing software applications, everything from food stamps to victim services to drivers’ licenses and boat registration. It assesses applications in regards to their age, cost, risk, technical health, and ability to continue to meet business needs. APM assists agencies in the development of plans for managing each application over its production life cycle and transitioning the portfolio as a whole to a more business-responsive, technically-controllable, financially-sustainable and risk-acceptable environment. It attempts to answer questions such as: should the state continue to maintain the application, modify the application to use newer technology, or replace it because it no longer meets the agency’s business need. The result is agency IT organizations that are able to deliver business functions with effective applications at acceptable costs. State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 Page 29 As in previous years, the information for this section of IT Expenditures Report is from the Portfolio Management tool. 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, but the numbers are based on self-reports from the agencies. The costs have not been audited, nor were they directly transferred to the Portfolio Management system from the N.C. Accounting System. Overall, approximately 61.6% 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. Projects: The Enterprise Project Management Office, under the SCIO, monitored more than 120 projects during FY 2011. Projects are new efforts with budgets, timelines and milestones. (Tracking and monitoring is not required for projects costing less than $500,000, but those projects that reported costs in the Portfolio Management tool are included in this report.) Approximately $139 million was spent by state agencies, including ITS, on projects. This amount was slightly higher than last year’s $123 million due in part because of the North Carolina Turnpike Toll Collection Management System, which will be implemented this fall. Chart 1.1 shows FY 2011 project costs by the source of funds (excluding ITS). State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 Page 30 Chart 1.2 shows the distribution of project funds statewide at a detailed cost level (excluding ITS). It should be noted that hardware costs decreased by $12 million due mainly to a decrease in hardware equipment spending for VIPER and the Tax Information Management System. The North Carolina Turnpike Toll Collection Management System and the Tax Information Management System projects were mainly responsible for a $19 million dollar increase in Other External Costs for the vendor services provided for these systems. Table 6-1 shows the distribution of costs for projects by agency for 2011 by detailed cost category. Table 6-2 shows the distribution of costs for projects by agency for 2011 by source of funds. Applications: State agencies, including ITS, have reported on 1063 active applications. Of those 1063 applications, the application support cost was identified for 903 applications. Applications support key business processes in state government, everything from the issuance of food stamps to vehicle registration and employee payroll. The state application portfolio only includes business applications and does not include office productivity software such as MS Word or Excel. The focus is on the life cycle management of business applications and determination of the application strategy. Approaches such as replace and retire, modify to incorporate newer technologies, enhance business State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 Page 31 capabilities or continue to maintain as is help to evaluate the application business value and improve service delivery to the citizens of North Carolina. Note: In February 2011, the State Chief Information Officer 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 “Legacy Application Study 2011.” Chart 1.3 provides details of the source of funds for maintaining the state’s existing applications (excluding ITS). As the chart depicts, the state provides 62% of funding with 34% coming from federal funding. State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 Page 32 Chart 1.4 gives details on the distribution of costs in IT cost categories (excluding ITS). 25% of the cost of maintaining applications comes from internal personnel. Table 6-3 provides additional information on state government application costs by agencies for 2010 by detailed cost category. Table 6-4 provides additional information on state government application costs by agencies for 2010 by source of funds. Key differences between FY2010 and FY2011 include: The number of projects reporting costs, including ITS, decreased slightly from 129 in 2010 to 120 in 2011. Total project costs increased from $123M in 2010 to $138M in 2011. This was due mainly to the work efforts for the North Carolina Turnpike Authority Toll Collection Management System. The number of applications reporting costs, including ITS, decreased from 1,157 in 2010 to 1,063 in 2011. Total applications costs went from $258M in 2010 to $269M in 2011.1 The 1 In the 2010 report, total applications costs were incorrectly reported as $242 million instead of $258 million. State of North Carolina Information Technology Expenditures Report For the Period July 2010 – June 2011 Page 33 decrease was mainly a result of retirement of old applications that were replaced by other modern systems. The increases were a result of growth in the use of the ITS Email service, email archiving and improvements made to the North Carolina Identity Management System. Final note: As was done last year, 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, 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. 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, 2011 Department of Administration E-Recruit Project 30,080 0 0 0 0 0 30,080 NC E-Procurement Upgrade 26,448 61,425 350,417 260,432 0 0 698,722 NCFlex Web Enrollment 6,400 7,843 0 0 0 0 14,243 Total Costs for Department of Administration 62,928 69,268 350,417 260,432 0 0 743,045 Department of Agriculture and Consumer Services Agronomic LIMS 87,146 191,003 0 0 0 0 278,149 Veterinary LIMS Project 46,805 4,675 0 16,087 145,542 0 213,109 Total Costs for Department of Agriculture and Consumer 133,951 195,678 0 16,087 145,542 0 491,258 Services Department of Commerce Consolidated Case Management System 98,547 66,032 0 0 0 0 (CCMS) Vault Migration Project 164,579 Grants Management System (GMS) 9,450 32,920 0 0 0 0 42,370 NCIC Claims 2.0 7,651 14,047 0 0 0 0 21,698 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, 2011 Department of Commerce NCIC Electronic Data Interchange (EDI) 6,420 9,479 0 0 0 0 15,899 North Carolina Industrial Commission 4,500 0 0 16,908 130,310 1,400 Consolidated Case Management System Program Overhead Project 153,118 Total Costs for Department of Commerce 126,568 122,478 0 16,908 130,310 1,400 397,664 Department of Correction DOC/ITS Exchange Migration Project 14,220 0 0 0 0 0 14,220 Total Costs for Department of Correction 14,220 0 0 0 0 0 14,220 Department of Crime Control and Public Safety Grants Enterprise Management System 96,360 20,206 0 0 0 0 (GEMS) - GCC 116,566 iRISK 42,135 0 309,101 0 0 0 351,236 New Joint Force Headquarters - State 44,240 15,217 71,384 828,644 47,000 1,100,000 Government Information Technology Infrastructure and Network 2,106,485 VIPER Strategic Solution Implementation 111,061 12,195 0 0 0 0 Project - Phase 2 123,256 Total Costs for Department of Crime Control and Public Safety 293,796 47,618 380,485 828,644 47,000 1,100,000 2,697,543 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, 2011 Department of Cultural Resources Shared Integrated Library System 861 0 0 0 0 0 861 Total Costs for Department of Cultural Resources 861 0 0 0 0 0 861 Department of Environment and Natural Resources DENR Green Square Infrastructure 56,212 0 675,304 413,157 0 0 1,144,673 DENR Groundwater Decision Support 44,324 0 0 0 0 0 System 44,324 DWM UST Tank Information 308,000 1,589,937 0 0 0 0 Management System (TIMS) 1,897,937 Total Costs for Department of Environment and Natural 408,536 1,589,937 675,304 413,157 0 0 3,086,934 Resources Department of Health and Human Services Crossroads State Agency Model 501,647 1,176,124 0 0 0 58,789 Implementation Project (SAM) 1,736,560 DCD Subsidized Early Education for 66,546 0 0 0 0 124,016 Kids (SEEK), aka ; Attendance Reporting and Payment Delivery 190,562 DHHS - Electronic Pre-Assessment 145,811 222,943 25,919 0 0 30,865 Screening Service (ePASS) Phase 2 - Food and Nutrition Services 425,538 DHHS Business Electronic Access 203,008 469,490 2,434,488 0 0 33,943 Management (BEAM) Project 3,140,929 DHHS Cherry Hospital Replacement 28,489 0 0 0 0 5,883 Project 34,372 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, 2011 Department of Health and Human Services Division of Medical Assistance - SAS 52,693 0 1,500,000 0 0 0 Medicaid Recipient Eligibility Solution 1,552,693 Division of Medical Assistance- Health 124,982 0 1,607,332 0 204,156 0 Analytics Initiative 1,936,470 DMH - HEARTS Upgrades - Precise ID 2,000 0 0 1,430 61,521 1,200 66,151 ePASS Phase 2 – Medicaid 24,026 12,887 0 0 0 4,789 41,702 Health Information System 712,195 3,097,145 547,655 0 115,520 137,339 4,609,854 NC FAST - Global Case Management and 1,215,159 1,482,927 7,037,070 0 0 208,840 Food and Nutrition Services (FNS) 9,943,996 NC FAST Automated Interview (AI) 40,459 0 0 0 0 3,421 Integrator Selection Project 43,880 NC FAST Case Management Program 303,477 106,799 398,929 372,114 1,891,743 609,378 Level Project 3,682,440 NC Health Choice (aka SCHIP) Business 49,678 185,747 0 0 0 0 Rules and Analysis Project 235,425 NCMMIS+ Program – DHSR Business 634,444 373,082 779,390 0 0 19,212 Process Automation System (BPAS) Project 1,806,128 NCMMIS+ Program-Level Project 1,255,290 552,763 0 116,214 57,239 545,870 2,527,376 Replacement MMIS DDI Project 3,283,203 1,899,875 10,625,750 0 0 85,526 15,894,354 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, 2011 Department of Health and Human Services 798,558 19,254 862,574 Replacement MMIS Reporting and 3,084 1,519 43,312 Analytics (R&A) Project 1,728,301 Vital Records and Statistics Automation 54,770 192,693 64,743 0 0 11,201 System 323,407 Total Costs for Department of Health and Human Services 9,496,435 9,791,729 25,883,850 492,842 2,331,698 1,923,584 49,920,138 Department of Justice Crime Data Integration (Captures) 102,003 110,660 0 0 0 279 212,942 Legal Services Case Management 88,339 21,681 416,770 0 0 0 526,790 Total Costs for Department of Justice 190,342 132,341 416,770 0 0 279 739,732 Department of Public Instruction AHR State Rollout 70,434 254,700 0 0 0 0 325,134 Budget and Amendment System (BAAS) 28,404 0 0 0 0 0 28,404 CECAS 2.0 177,345 96,248 0 35,308 326,635 0 635,536 CEDARS - Data Warehouse 179,956 527,903 0 0 0 0 707,859 CEDARS - Reporting 246,173 475,702 0 0 0 34,500 756,375 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, 2011 Department of Public Instruction 4,676 Child Nutrition System Server and OS 12,366 0 16,894 4,880 0 Upgrade 38,816 Computerized Instructional Management 79,700 567,318 0 47,501 1,116,727 0 System 1,811,246 Computerized Instructional Management 9,201 0 0 0 34,000 0 System (CIMS Pilot) 43,201 GMS 100 - Comprehensive Continuous 106,395 82,547 0 12,586 1,343 0 Improvement Planning (CCIP) 202,871 Licensure Automation System 64,477 37,789 0 0 0 0 102,266 NC WISE 2008 Hardware Upgrade 143,226 58,737 0 0 0 153,592 355,555 NC WISE eSIS 12.1 Upgrade 273,432 101,789 0 0 7,952 0 383,173 NCDPI Email Migration Project 4,527 0 0 0 0 0 (Live@EDU) - formerly named NCDPI/ITS Exchange Migration Project 4,527 Race to the Top - Instructional 149,040 0 0 0 0 0 Improvement System (IIS) 149,040 Race to the Top - NC Education Cloud 42,865 699,800 0 0 0 0 Planning 742,665 WCPSS and CMS NC WISE Integration 362,514 224,741 0 20,733 12,908 0 620,896 Total Costs for Department of Public Instruction 1,942,365 3,139,640 0 133,022 1,504,445 188,092 6,907,564 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, 2011 Department of Revenue 468,285 870,325 16,937,935 Tax Information Management System 294,872 951,658 0 (TIMS) 19,523,075 Total Costs for Department of Revenue 468,285 870,325 16,937,935 294,872 951,658 0 19,523,075 Department of Transportation 511 System - Solicit Vendors for Appl 39,573 0 109,220 0 0 0 Support (ITP.00153, BSIP, P4) 148,793 Access Control, Alarms, and Badge 26,380 0 0 0 0 0 Making Software (ITP.00213, IS) 26,380 ARPS - Automated Routing and 41,271 264,508 0 0 0 0 Permitting System Upgrade (ITP.00203, ETS) 305,779 Asset Management System - Bridge 333,727 0 1,021,472 0 0 0 Management Addition (BMS, ITP.00183, ETS, P1) 1,355,199 Back Office Software Solution (BOSS) 28,525 10,461 0 76,437 98,863 0 214,286 CDLIS Modernization (ITP.00209, DMV) 32,086 67,798 0 0 0 0 99,884 Criminal Justice Data Integration 77,935 0 0 0 0 0 Initiative (CJLEADS, ITP.00195, DMV) 77,935 DMV 2D Barcode (ITP.00174, DMV, P2) 12,704 0 0 42,750 0 0 55,454 DMV Commercial Drivers License (CDL) 19,442 21,739 0 0 0 0 2009 Improvements (ITP.00188, DMV) 41,181 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, 2011 Department of Transportation 11,786 78,424 DOT EIPT (Telephony) System Upgrade 0 295,419 64,020 3,000 Phase I (ITP.00163, IS, P1) 452,649 DOT Printing Project (ITP.00112, BSIP, 169,907 97,747 0 0 0 551,368 P1) 819,022 ECM - Enterprise Content Management 14,004 109,217 0 0 0 100,000 System (ITP.00177, BSIP, P1) 223,221 Electronic Crash Reporting (Non-TraCS) 17,556 208,244 0 0 0 0 (ITP.00198, DMV) 225,800 Emissions Services Request for Proposal 28,625 0 0 0 0 0 (RFP) (ITP.00096, DMV, P10) 28,625 Grants Management (ITP.00196, BSIP, 157,102 545,445 0 0 8,325 0 P1) 710,872 HB 1779 Vehicle Property Tax Collection 0 37,344 0 0 0 0 (ITP.00217, DMV) 37,344 HB1779 - Planning to Post 16,730 0 0 0 0 0 Implementation (PROG.0004, ITP.00129, DMV, P1) 16,730 Implementation of SAVE via AAMVAnet 44,624 56,652 0 0 0 0 (ITP.00191, DMV) 101,276 Medical Certification Requirements as 36,250 67,043 0 0 0 0 Part of CDL (ITP.00210, DMV) 103,293 Motor Vehicle Inspection and Law 25,499 104,245 0 0 0 0 Enforcement System (MILES) ITP.00207, DMV 129,744 Multi User Geodatabase (MUG, 259,655 478,281 0 0 0 0 ITP.00181, ETS) 737,936 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, 2011 Department of Transportation NCDOT Division 3 Telephone Upgrade 9,472 0 34,813 0 0 0 (ITP.00206, IS) 44,285 NCDOT Ferry Ticketing and Reservation 183,292 49,375 0 0 0 0 System (ITP.00186, IS) 232,667 NCDOT Laptop and Mobile Device 4,615 0 0 0 0 0 Encryption (ITP.00184, IS) 4,615 NCDOT Web Site Redesign and 59,864 27,984 0 0 0 0 Restructuring (ITP.00208, BSIP) 87,848 NCSmartlink (ITP.00066, ETS, P1) 45,943 0 24,800 0 0 0 70,743 Next Generation Secure Driver License 371,790 450,130 0 0 0 0 System(PROG.0003, ITP.00200, DMV) 821,920 PCI Compliance (ITP.00199, IS) 207,720 112,313 0 355,126 0 0 675,159 SAP Claims Management (ITP.00204, 90,772 117,129 0 0 64,605 0 BSIP, P1) 272,506 Spatial Data Viewer (SDV, ITP.00182, 543,531 241,110 0 127,868 40,200 0 ETS, P1) 952,709 SPOT Assistance - Prioritization 2.0 97,801 189,317 0 0 21,205 0 (ITP.00205, BSIP) 308,323 Stormwater Pollution Prevention Plan - 15,987 0 0 0 0 0 Spill Prevention (SPPP/SPCC) Website (ITP.00201) 15,987 TraCS Software Upgrade to Release 10.0 22,657 0 0 0 0 0 (ITP.00215, DMV) 22,657 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, 2011 Department of Transportation Training Partner Integration (ITP.00202, 99,080 248 0 0 0 0 BSIP) 99,328 Trip Permits (ITP.00212, DMV) 47,362 0 0 0 0 0 47,362 Total Costs for Department of Transportation 3,193,267 3,334,754 1,190,305 897,600 297,218 654,368 9,567,512 Employment Security Commission ES Encryption of Staff & Partner PCs and 96,569 163,824 0 0 0 24,092 Career Resource Center (CRC) Upgrades 284,485 Southeast Consortium UI Modernization 425,260 300 0 27,319 6,262 67,489 Feasibility Study 526,630 UI Appeals Hosted Service for the 22,427 0 0 0 0 0 Integration of Digital Recording and Teleconferencing 22,427 UI Chapanoke Expansion - St. Mary's 22,940 0 0 99,580 0 14,200 Relocation 136,720 UI Records Management Service (RMS) 7,980 32,760 0 0 0 3,350 Work Flow and Imaging System 44,090 UI Remote Service Center Relocation 12,506 0 0 43,238 0 0 Project 55,744 UI State Information Data Exchange 20,374 0 0 0 0 0 System (UI SIDES) 20,374 VoIP Telephony Replacement for ESC 22,042 0 0 0 0 0 Wade Avenue Complex 22,042 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, 2011 630,098 196,884 0 170,137 Total Costs for Employment Security Commission 6,262 109,131 1,112,512 North Carolina Turnpike Authority Toll Collection Management System 373,483 2,323,312 12,246,676 0 0 2,836,885 (TCMS) 17,780,356 Total Costs for North Carolina Turnpike Authority 373,483 2,323,312 12,246,676 0 0 2,836,885 17,780,356 Office of the Governor Budget and Performance Management 433,464 1,154,053 0 429,025 561,689 8,762 System - NC IBIS 2,586,993 Total Costs for Office of the Governor 433,464 1,154,053 0 429,025 561,689 8,762 2,586,993 Office of the State Controller BEACON Hardware Refresh/Disaster 105,018 0 0 1,112,575 0 0 Recovery Landscape Project 1,217,593 Criminal Justice Data Integration Pilot for 912,194 -688,663 3,008,968 2,438,991 2,004,186 206,364 Wake County 7,882,040 Total Costs for Office of the State Controller 1,017,212 -688,663 3,008,968 3,551,566 2,004,186 206,364 9,099,633 Total Costs for Non-ITS 18,785,811 22,279,354 61,090,710 7,504,292 7,980,008 7,028,865 124,669,040 Page 44 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, 2011 Office of Information Technology Services 295,444 168,421 6,245,379 CGIA-NC Statewide Orthoimagery 2010 17,346 25,200 4,735 6,756,525 DNS Replacement 2010 170,423 345 436,282 0 0 0 607,050 E25K Retirement Project 6,478 0 0 0 0 0 6,478 Email Archiving 4,050 0 109,350 0 0 0 113,400 ESAP Remote Access VPN - Service 41,468 0 0 0 0 0 Introduction & Customer Migration 41,468 Exchange Service Improvement Project 125,603 202,752 4,400 310,000 183,000 13,200 838,955 Firewall/VPN - Service Refresh & 40,257 0 0 0 0 0 Customer Migration 40,257 Infrastructure Study & Assessment 740,237 1,114,567 0 0 0 0 (INSA) Project 1,854,804 IT Consolidation Phase III - DENR Green 130,969 0 0 327,986 0 0 Square Server Consolidation 458,955 Mainframe Software Toolset 51,227 485,860 354,418 0 725,511 0 Consolidation 1,617,016 NCID Next Generation Upgrade 411,171 170,961 0 747,768 95,475 0 1,425,375 Project Management/Resource 35,957 0 0 0 0 0 Management Tool 35,957 Page 45 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, 2011 Office of Information Technology Services Remote Office Backup Infrastructure 6,306 0 0 0 0 0 6,306 SONC Enterprise IVR SIP Migration 12,059 0 0 0 0 0 12,059 State Portal Initiative 19,460 18,532 75,000 0 0 0 112,992 Voice Mail Replacement - Lease 194,422 0 0 0 0 0 194,422 Total Costs for Office of Information Technology Services 2,285,531 2,161,438 7,224,829 1,403,100 1,029,186 17,935 14,122,019 Total Costs for ITS 2,285,531 2,161,438 7,224,829 1,403,100 1,029,186 17,935 14,122,019 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, 2011 Department of Administration E-Recruit Project 0 0 0 0 30,080 30,080 Department of Administration NC E-Procurement Upgrade 0 0 0 698,722 0 698,722 Department of Administration NCFlex Web Enrollment 0 0 0 0 14,243 14,243 Total Costs for Department of Administration 0 0 0 698,722 44,323 743,045 Department of Agriculture and Consumer Services Agronomic LIMS 191,003 0 0 0 87,146 278,149 Department of Agriculture and Consumer Services Veterinary LIMS Project 0 0 0 0 213,109 213,109 Total Costs for Department of Agriculture and Consumer Services 191,003 0 0 0 300,255 491,258 Department of Commerce Consolidated Case Management System (CCMS) Vault Migration Project 0 0 0 164,579 0 164,579 Department of Commerce Grants Management System (GMS) 42,370 0 0 0 0 42,370 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, 2011 Department of Commerce NCIC Claims 2.0 0 0 0 21,698 0 21,698 Department of Commerce NCIC Electronic Data Interchange (EDI) 0 0 0 15,899 0 15,899 Department of Commerce North Carolina Industrial Commission Consolidated Case Management System Program Overhead Project 0 0 0 153,118 0 153,118 Total Costs for Department of Commerce 42,370 0 0 355,294 0 397,664 Department of Correction DOC/ITS Exchange Migration Project 0 0 0 0 14,220 14,220 Total Costs for Department of Correction 0 0 0 0 14,220 14,220 Department of Crime Control and Public Safety Grants Enterprise Management System (GEMS) - GCC 116,566 0 0 0 0 116,566 Department of Crime Control and Public Safety iRISK 0 0 0 0 351,236 351,236 Department of Crime Control and Public Safety New Joint Force Headquarters - State Government Information Technology Infrastructure and Network 10,000 0 0 12,866 2,083,619 2,106,485 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, 2011 Department of Crime Control and Public Safety VIPER Strategic Solution Implementation Project - Phase 2 0 0 0 0 123,256 123,256 Total Costs for Department of Crime Control and Public Safety 126,566 0 0 12,866 2,558,111 2,697,543 Department of Cultural Resources Shared Integrated Library System 0 0 0 0 861 861 Total Costs for Department of Cultural Resources 0 0 0 0 861 861 Department of Environment and Natural Resources DENR Green Square Infrastructure 0 0 0 0 1,144,673 1,144,673 Department of Environment and Natural Resources DENR Groundwater Decision Support System 0 0 0 0 44,324 44,324 Department of Environment and Natural Resources DWM UST Tank Information Management System (TIMS) 1,170,359 0 0 0 727,578 1,897,937 Total Costs for Department of Environment and Natural Resources 1,170,359 0 0 0 1,916,575 3,086,934 Department of Health and Human Services Crossroads State Agency Model Implementation Project (SAM) 1,736,560 0 0 0 0 1,736,560 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, 2011 Department of Health and Human Services DCD Subsidized Early Education for Kids (SEEK), aka ; Attendance Reporting and Payment Delivery 190,562 0 0 0 0 190,562 Department of Health and Human Services DHHS - Electronic Pre-Assessment Screening Service (ePASS) Phase 2 - Food and Nutrition Services 425,538 0 0 0 0 425,538 Department of Health and Human Services DHHS Business Electronic Access Management (BEAM) Project 2,819,961 0 0 0 320,968 3,140,929 Department of Health and Human Services DHHS Cherry Hospital Replacement Project 0 0 0 0 34,372 34,372 Department of Health and Human Services Division of Medical Assistance - SAS Medicaid Recipient Eligibility Solution 0 0 0 0 1,552,693 1,552,693 Department of Health and Human Services Division of Medical Assistance- Health Analytics Initiative 0 0 0 0 1,936,470 1,936,470 Department of Health and Human Services DMH - HEARTS Upgrades - Precise ID 0 0 0 0 66,151 66,151 Department of Health and Human Services ePASS Phase 2 – Medicaid 14,874 0 0 2,850 23,978 41,702 Department of Health and Human Services Health Information System 0 0 0 0 4,609,854 4,609,854 Department of Health and Human Services NC FAST - Global Case Management and Food and Nutrition Services (FNS) 3,392,049 0 0 0 6,551,947 9,943,996 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, 2011 Department of Health and Human Services NC FAST Automated Interview (AI) Integrator Selection Project 10,988 0 0 0 32,892 43,880 Department of Health and Human Services NC FAST Case Management Program Level Project 1,925,476 0 0 0 1,756,964 3,682,440 Department of Health and Human Services NC Health Choice (aka SCHIP) Business Rules and Analysis Project 211,887 0 0 0 23,538 235,425 Department of Health and Human Services NCMMIS+ Program – DHSR Business Process Automation System (BPAS) Project 1,160,558 0 0 0 645,570 1,806,128 Department of Health and Human Services NCMMIS+ Program-Level Project 2,243,239 31,388 0 0 252,749 2,527,376 Department of Health and Human Services Replacement MMIS DDI Project 14,428,754 0 0 0 1,465,600 15,894,354 Department of Health and Human Services Replacement MMIS Reporting and Analytics (R&A) Project 1,555,472 0 0 0 172,829 1,728,301 Department of Health and Human Services Vital Records and Statistics Automation System 0 0 0 0 323,407 323,407 Total Costs for Department of Health and Human Services 30,115,918 31,388 0 2,850 19,769,982 49,920,138 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, 2011 Department of Justice Crime Data Integration (Captures) 79,224 0 0 0 133,718 212,942 Department of Justice Legal Services Case Management 0 0 0 0 526,790 526,790 Total Costs for Department of Justice 79,224 0 0 0 660,508 739,732 Department of Public Instruction AHR State Rollout 0 0 0 0 325,134 325,134 Department of Public Instruction Budget and Amendment System (BAAS) 0 0 0 0 28,404 28,404 Department of Public Instruction CECAS 2.0 635,536 0 0 0 0 635,536 Department of Public Instruction CEDARS - Data Warehouse 527,903 0 0 0 179,956 707,859 Department of Public Instruction CEDARS - Reporting 510,202 0 0 0 246,173 756,375 Department of Public Instruction Child Nutrition System Server and OS Upgrade 34,140 0 0 0 4,676 38,816 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, 2011 Department of Public Instruction Computerized Instructional Management System 1,752,696 0 0 0 58,550 1,811,246 Department of Public Instruction Computerized Instructional Management System (CIMS Pilot) 36,512 0 0 0 6,689 43,201 Department of Public Instruction GMS 100 - Comprehensive Continuous Improvement Planning (CCIP) 167,742 0 0 0 35,129 202,871 Department of Public Instruction Licensure Automation System 23,318 0 0 33,291 45,657 102,266 Department of Public Instruction NC WISE 2008 Hardware Upgrade 0 0 0 0 355,555 355,555 Department of Public Instruction NC WISE eSIS 12.1 Upgrade 0 0 0 0 383,173 383,173 Department of Public Instruction NCDPI Email Migration Project (Live@EDU) - formerly named NCDPI/ITS Exchange Migration Project 0 0 0 0 4,527 4,527 Department of Public Instruction Race to the Top - Instructional Improvement System (IIS) 26,302 0 0 0 122,738 149,040 Department of Public Instruction Race to the Top - NC Education Cloud Planning 556,760 0 0 0 185,905 742,665 Department of Public Instruction WCPSS and CMS NC WISE Integration 0 0 0 0 620,896 620,896 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, 2011 Total Costs for Department of Public Instruction 4,271,111 0 0 33,291 2,603,162 6,907,564 Department of Revenue Tax Information Management System (TIMS) 0 0 0 19,523,075 0 19,523,075 Total Costs for Department of Revenue 0 0 0 19,523,075 0 19,523,075 Department of Transportation 511 System - Solicit Vendors for Appl Support (ITP.00153, BSIP, P4) 90,656 0 0 0 58,137 148,793 Department of Transportation Access Control, Alarms, and Badge Making Software (ITP.00213, IS) 0 0 0 0 26,380 26,380 Department of Transportation ARPS - Automated Routing and Permitting System Upgrade (ITP.00203, ETS) 0 305,779 0 0 0 305,779 Department of Transportation Asset Management System - Bridge Management Addition (BMS, ITP.00183, ETS, P1) 1,084,160 0 0 0 271,039 1,355,199 Department of Transportation Back Office Software Solution (BOSS) 0 0 0 214,286 0 214,286 Department of Transportation CDLIS Modernization (ITP.00209, DMV) 0 0 0 0 99,884 99,884 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, 2011 Department of Transportation Criminal Justice Data Integration Initiative (CJLEADS, ITP.00195, DMV) 0 23,654 0 0 54,281 77,935 Department of Transportation DMV 2D Barcode (ITP.00174, DMV, P2) 55,454 0 0 0 0 55,454 Department of Transportation DMV Commercial Drivers License (CDL) 2009 Improvements (ITP.00188, DMV) 41,181 0 0 0 0 41,181 Department of Transportation DOT EIPT (Telephony) System Upgrade Phase I (ITP.00163, IS, P1) 0 0 0 0 452,649 452,649 Department of Transportation DOT Printing Project (ITP.00112, BSIP, P1) 458,865 5,960 0 0 354,197 819,022 Department of Transportation ECM - Enterprise Content Management System (ITP.00177, BSIP, P1) 0 0 0 0 223,221 223,221 Department of Transportation Electronic Crash Reporting (Non- TraCS) (ITP.00198, DMV) 137,579 8,927 0 0 79,294 225,800 Department of Transportation Emissions Services Request for Proposal (RFP) (ITP.00096, DMV, P10) 0 0 0 0 28,625 28,625 Department of Transportation Grants Management (ITP.00196, BSIP, P1) 547,373 7,107 0 0 156,392 710,872 Department of Transportation HB 1779 Vehicle Property Tax Collection (ITP.00217, DMV) 0 0 0 37,344 0 37,344 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, 2011 Department of Transportation HB1779 - Planning to Post Implementation (PROG.0004, ITP.00129, DMV, P1) 0 0 0 16,073 657 16,730 Department of Transportation Implementation of SAVE via AAMVAnet (ITP.00191, DMV) 101,276 0 0 0 0 101,276 Department of Transportation Medical Certification Requirements as Part of CDL (ITP.00210, DMV) 67,043 0 0 0 36,250 103,293 Department of Transportation Motor Vehicle Inspection and Law Enforcement System (MILES) ITP.00207, DMV 0 0 0 129,744 0 129,744 Department of Transportation Multi User Geodatabase (MUG, ITP.00181, ETS) 737,936 0 0 0 0 737,936 Department of Transportation NCDOT Division 3 Telephone Upgrade (ITP.00206, IS) 0 0 0 0 44,285 44,285 Department of Transportation NCDOT Ferry Ticketing and Reservation System (ITP.00186, IS) 0 0 0 0 232,667 232,667 Department of Transportation NCDOT Laptop and Mobile Device Encryption (ITP.00184, IS) 0 0 0 0 4,615 4,615 Department of Transportation NCDOT Web Site Redesign and Restructuring (ITP.00208, BSIP) 0 0 0 0 87,848 87,848 Department of Transportation NCSmartlink (ITP.00066, ETS, P1) 2,618 0 0 0 68,125 70,743 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, 2011 Department of Transportation Next Generation Secure Driver License System(PROG.0003, ITP.00200, DMV) 0 0 0 0 821,920 821,920 Department of Transportation PCI Compliance (ITP.00199, IS) 0 76,495 0 0 598,664 675,159 Department of Transportation SAP Claims Management (ITP.00204, BSIP, P1) 209,846 2,722 0 0 59,938 272,506 Department of Transportation Spatial Data Viewer (SDV, ITP.00182, ETS, P1) 952,709 0 0 0 0 952,709 Department of Transportation SPOT Assistance - Prioritization 2.0 (ITP.00205, BSIP) 237,409 3,081 0 0 67,833 308,323 Department of Transportation Stormwater Pollution Prevention Plan - Spill Prevention (SPPP/SPCC) Website (ITP.00201) 0 0 0 0 15,987 15,987 Department of Transportation TraCS Software Upgrade to Release 10.0 (ITP.00215, DMV) 0 0 0 0 22,657 22,657 Department of Transportation Training Partner Integration (ITP.00202, BSIP) 0 0 0 0 99,328 99,328 Department of Transportation Trip Permits (ITP.00212, DMV) 0 23,600 0 0 23,762 47,362 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, 2011 Total Costs for Department of Transportation 4,724,105 457,325 0 397,447 3,988,635 9,567,512 Employment Security Commission ES Encryption of Staff & Partner PCs and Career Resource Center (CRC) Upgrades 284,485 0 0 0 0 284,485 Employment Security Commission Southeast Consortium UI Modernization Feasibility Study 526,630 0 0 0 0 526,630 Employment Security Commission UI Appeals Hosted Service for the Integration of Digital Recording and Teleconferencing 22,427 0 0 0 0 22,427 Employment Security Commission UI Chapanoke Expansion - St. Mary's Relocation 136,720 0 0 0 0 136,720 Employment Security Commission UI Records Management Service (RMS) Work Flow and Imaging System 44,090 0 0 0 0 44,090 Employment Security Commission UI Remote Service Center Relocation Project 55,744 0 0 0 0 55,744 Employment Security Commission UI State Information Data Exchange System (UI SIDES) 20,374 0 0 0 0 20,374 Employment Security Commission VoIP Telephony Replacement for ESC Wade Avenue Complex 22,042 0 0 0 0 22,042 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, 2011 Total Costs for Employment Security Commission 1,112,512 0 0 0 0 1,112,512 North Carolina Turnpike Authority Toll Collection Management System (TCMS) 0 0 0 0 17,780,356 17,780,356 Total Costs for North Carolina Turnpike Authority 0 0 0 0 17,780,356 17,780,356 Office of the Governor Budget and Performance Management System - NC IBIS 0 0 0 0 2,586,993 2,586,993 Total Costs for Office of the Governor 0 0 0 0 2,586,993 2,586,993 Office of the State Controller BEACON Hardware Refresh/Disaster Recovery Landscape Project 0 0 0 0 1,217,593 1,217,593 Office of the State Controller Criminal Justice Data Integration Pilot for Wake County 0 0 0 0 7,882,040 7,882,040 Total Costs for Office of the State Controller 0 0 0 0 9,099,633 9,099,633 Total Costs for Non-ITS 41,833,168 488,713 0 21,023,545 61,323,614 124,669,040 Page 59 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, 2011 Office of Information Technology Services CGIA-NC Statewide Orthoimagery 2010 0 0 0 6,756,525 0 6,756,525 Office of Information Technology Services DNS Replacement 2010 0 0 0 0 607,050 607,050 Office of Information Technology Services E25K Retirement Project 0 0 0 0 6,478 6,478 Office of Information Technology Services Email Archiving 0 0 0 0 113,400 113,400 Office of Information Technology Services ESAP Remote Access VPN - Service Introduction & Customer Migration 4,182 0 0 0 37,286 41,468 Office of Information Technology Services Exchange Service Improvement Project 0 0 0 72,339 766,616 838,955 Office of Information Technology Services Firewall/VPN - Service Refresh & Customer Migration 0 0 0 0 40,257 40,257 Office of Information Technology Services Infrastructure Study & Assessment (INSA) Project 0 0 0 0 1,854,804 1,854,804 Office of Information Technology Services IT Consolidation Phase III - DENR Green Square Server Consolidation 0 0 0 458,955 0 458,955 Office of Information Technology Services Mainframe Software Toolset Consolidation 0 0 0 1,617,016 0 1,617,016 Page 60 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, 2011 Office of Information Technology Services NCID Next Generation Upgrade 0 0 0 0 1,425,375 1,425,375 Office of Information Technology Services Project Management/Resource Management Tool 0 0 0 0 35,957 35,957 Office of Information Technology Services Remote Office Backup Infrastructure 0 0 0 0 6,306 6,306 Office of Information Technology Services SONC Enterprise IVR SIP Migration 0 0 0 12,059 0 12,059 Office of Information Technology Services State Portal Initiative 0 0 0 0 112,992 112,992 Office of Information Technology Services Voice Mail Replacement - Lease 0 0 0 0 194,422 194,422 Total Costs for Office of Information Technology Services 4,182 0 0 8,916,894 5,200,943 14,122,019 Total Costs for ITS 4,182 0 0 8,916,894 5,200,943 14,122,019 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, 2011 Community Colleges System Office College Data Accounting System 9,036 0 0 1,800 5,892 0 16,728 Current GED System 5,160 0 0 1,620 4,608 0 11,388 Data Warehouse - 2 356,496 0 0 4,992 172,774 0 534,262 Legacy GED System 0 0 18,715 0 0 0 18,715 SIRSI Library System 0 0 0 0 253,491 0 253,491 370,692 0 18,715 Total Costs for Community Colleges System Office 8,412 436,765 0 834,584 Department of Administration APT Accounts Receivable 7,729 0 0 0 0 0 7,729 APT SmartPlus 0 0 40,999 0 0 0 40,999 CFW DV & SA Statistical 3,865 0 0 0 0 0 3,865 CIA Bluemen Talent Search 0 0 249 0 0 0 249 CIA Section 8 Housing 4,176 0 0 0 0 0 4,176 DOA Mail List 3,865 0 0 0 0 0 3,865 DSP Federal Surplus Property 7,729 0 0 0 0 0 7,729 DSP Federal Surplus Property Sales 7,729 0 0 0 0 0 7,729 DSP State Surplus Property 46,376 0 0 0 0 0 46,376 FM Courier Accounts Receivable 7,729 0 0 0 0 0 7,729 FM Federal Surplus Accounts Receivable 7,729 0 0 0 0 0 7,729 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, 2011 Department of Administration FM Temporary Solution Accounts Receivable 7,729 0 0 0 0 0 7,729 HRM Applicant Tracking System 3,865 0 0 0 0 0 3,865 HUB HUBSCO 15,458 0 0 0 0 0 15,458 MFM NC Motor Fleet System 54,106 0 0 0 0 0 54,106 MIS Web Update Ticket System 12,270 0 0 0 0 0 12,270 MSC eSmart Mail Manager/Global 65 0 0 105,000 0 0 0 105,000 MSC eSmart Mail Manager/Global 77 0 0 125,000 0 0 0 125,000 MSC Global65 Courier Billing 34,951 0 0 0 0 0 34,951 MSC Heimann Systems/Xray Machine 0 0 1,000 0 0 0 1,000 MSC NetSort/Sabre 0 0 17,000 0 0 0 17,000 MSC USPS Billing 15,458 0 1,416 0 0 0 16,874 MSC WITS 1,800 0 0 0 0 0 1,800 NCVA Scholarship Program 3,063 0 0 0 0 0 3,063 P&C E-Procurement 0 0 10,825,036 0 0 0 10,825,036 P&C Interactive Purchasing and Vendor Link 46,376 0 0 0 0 0 46,376 SEC State Clearinghouse Intergovernmental Review Tracking 7,729 0 0 0 0 0 7,729 SPO Facility Information System (FIS) 0 0 9,017 0 0 0 9,017 SPO MAPIT 0 0 0 0 0 9,017 9,017 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, 2011 Department of Administration YAIO Youth Registration System 7,729 0 0 0 0 0 7,729 307,461 0 11,124,717 Total Costs for Department of Administration 0 0 9,017 11,441,195 Department of Agriculture and Consumer Services Agricultural Review System 1,550 0 0 0 0 0 1,550 Agronomic Lab Information System 29,255 0 44 0 0 1,046 30,345 Animal Health Programs Database (formerly NCHAMS) 76,550 0 0 3,000 0 0 79,550 Applicant Tracking 5,100 0 0 0 0 0 5,100 Commissioners Correspondence Tracking System 5,100 0 0 0 0 0 5,100 Commodity Assessments Program 11,100 0 0 0 0 0 11,100 Departmental Licensing System 10,100 0 640 0 0 0 10,740 F&V Terminal Market/Shipping Point 6,479 0 0 0 0 0 6,479 Farmer's Markets Gate Receipts System 7,670 1,211 0 0 0 0 8,881 Feed Label Review 2,400 0 0 0 0 0 2,400 Feed Report System 550 0 14 0 0 0 564 Feed Transcript System 1,800 0 37 0 0 0 1,837 Fertilizer Penalty System 110 0 16 0 0 0 126 Fertilizer Registration System 0 0 23 0 0 0 23 Fertilizer Transcript System 1,500 0 23 0 0 0 1,523 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, 2011 Department of Agriculture and Consumer Services Food and Drug LIMS 80,000 0 0 0 0 24,324 104,324 Food and Feed Firms 57,380 0 0 3,000 0 0 60,380 Food Distribution - Electronic Commodity Ordering Portal 12,420 26,835 0 0 0 0 39,255 Food Distribution Tracking System 51,180 40,252 0 0 0 0 91,432 Food Sample Collection & Receiving 9,000 15,260 0 29,832 0 0 54,092 Forage Sample Login 300 0 0 0 0 0 300 FS Billing 4,165 0 0 0 0 0 4,165 Grain Grading and Billing 8,330 0 0 0 0 0 8,330 Grain Grading Certificates 8,021 0 0 0 0 0 8,021 Market News Grain 200 0 0 0 0 0 200 Market News Poultry System 450 0 0 0 0 0 450 Milled Peanut Certificates 2,468 0 0 0 0 0 2,468 Motor Fuel Registration System 200 0 11 0 0 0 211 Mountain State Fair Advanced Ticket Sales 200 0 0 0 0 0 200 Mountain State Fair Exhibitor & Concessionaires 318 0 0 0 0 0 318 Multi-Hazard Threat database 40,190 4,500 0 6,000 0 0 50,690 NCPlants 9,060 39,974 0 0 0 0 49,034 Office Supplies Inventory System 250 0 0 0 0 0 250 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, 2011 Department of Agriculture and Consumer Services Pesticide Inspection Forms (Miforms) 22,000 62,170 0 3,615 6,780 0 94,565 Pesticide Inspector Activity System 550 0 0 0 0 0 550 Pesticide Recertification System 250 0 0 0 0 0 250 Pesticide Registration 7,500 0 85 0 0 0 7,585 Rapid Entry Program for Market News 200 0 0 0 0 0 200 Seed Lab System 6,050 0 0 0 0 0 6,050 Standards Lab Scheduling System 293 0 0 0 0 0 293 State Fair Entry System 14,000 0 0 0 0 0 14,000 State Fair Event Management System 1,850 0 0 0 0 0 1,850 State Fair Folk Festival 4,500 0 0 0 0 0 4,500 State Maillist System 80 0 16 0 0 0 96 Structural Pest Automated Inspection System 15,300 0 0 0 0 0 15,300 Structural Pest Control Recertification System 350 0 20 0 0 0 370 Temporary and Part-time Payroll System 5,300 0 0 0 0 0 5,300 Tonnage System 1,000 0 0 0 0 0 1,000 Veterinary LIMS 43,000 0 0 0 0 20,000 63,000 WebGT 10,500 0 0 0 0 0 10,500 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, 2011 576,119 190,202 929 45,447 Total Costs for Department of Agriculture and Consumer 6,780 45,370 864,847 Services Department of Commerce !RET_AppTrack Application Processing 17,613 0 0 5,156 2,424 0 25,193 !RET_AppTrack Position Posting 15,359 0 0 5,156 2,324 0 22,839 !RET_Commerce CMS - Content Management System 27,549 0 0 10,107 2,883 0 40,539 !RET_Local Area Issuances 3,617 0 0 10,388 3,133 0 17,138 !RET_Tourism Economic Impact 3,617 0 0 8,811 3,892 0 16,320 !RET_Welcome Center Statistics 3,617 0 0 8,811 3,892 0 16,320 3m Core Grouping Inpatient Interactive Module 2,000 0 0 1,000 5,600 0 8,600 ABC Online 23,375 0 0 0 0 0 23,375 ABC Permit System 23,375 0 0 0 0 0 23,375 ABC Pricing System 23,375 0 0 0 0 0 23,375 ABC Product Compliance System 14,025 0 0 0 0 0 14,025 ABC Violation Tracking System 9,350 0 0 0 0 0 9,350 Commerce CMS - Content Management System (NEW) 95,774 0 0 5,574 7,458 0 108,806 Commerce Community Investment Reports 49,535 0 0 3,544 2,502 0 55,581 Commerce CyberGrants 0 0 2,021 0 0 0 2,021 Commerce JobLink 15,979 0 0 5,156 2,424 0 23,559 Page 67 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, 2011 Department of Commerce Commerce Lyris ListManager 8,781 0 0 5,831 6,094 0 20,706 Commerce Redbook_BLIO Permits/Licensing 10,006 0 0 10,388 5,247 0 25,641 Commerce Welcome Center Inventory Management 5,606 0 0 5,301 2,514 0 13,421 Mainframe Host-on-Demand 110,000 3,557 0 7,000 0 0 120,557 Mediation 10,000 0 0 5,000 0 0 15,000 NCDWD FMIS Application 1,600 3,000 0 8,000 0 0 12,600 NCDWD Mobile Joblink Scheduling Application 2,405 0 0 33 45 0 2,483 NCDWD ncwia web portal 250 0 0 33 42 0 325 NCDWD WIA Reporting Application For WF+ 4,167 0 0 92 171 0 4,430 NCDWD WorkforcePlus 3,333 0 3,667 2,333 0 4,167 13,500 NCIC Vault 10,000 0 109,636 5,000 0 0 124,636 NCIC Website Searchable Databases 12,000 0 0 5,000 6,080 0 23,080 PPD2 - Partial Permanent Disability 3,500 0 0 2,000 0 0 5,500 PRSP Economic Development Intelligence System (EDIS) 9,600 417 0 10,517 0 8,583 29,117 RightFax 15,000 0 0 5,000 0 0 20,000 Scanning and Indexing 20,000 12,500 5,000 11,000 8,000 0 56,500 554,408 19,474 120,324 146,231 Total Costs for Department of Commerce 64,725 12,750 917,912 Page 68 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, 2011 Department of Correction Alcohol and Chemical Dependency Program 38,400 0 0 165,484 0 0 203,884 Applicant Tracking System 24,659 0 0 26,309 0 0 50,968 Business Information & Data System 5,400 0 0 152,081 0 0 157,481 Cashless on the Net 24,659 0 0 599,692 0 0 624,351 Community Service 19,800 0 0 260,774 0 0 280,574 Criminal Justice Partnership 3,360 0 0 0 0 0 3,360 DOC Next Generation of OPUS 250,000 0 0 195,003 0 0 445,003 Drug Labs 2,400 0 0 22,977 0 0 25,377 Electronic House Arrest 0 0 0 1,669,774 0 0 1,669,774 Food Management System 35,400 0 0 141,267 0 0 176,667 Gate Log System 2,464 0 0 97 0 0 2,561 Inmates Telephone Pin # 1,639 0 0 9,930 0 0 11,569 Job Order System 33,840 0 0 15,272 0 0 49,112 Maintenance Management 5,640 0 0 75,454 0 0 81,094 Medical Operation Management 45,000 0 0 96,049 0 0 141,049 Offender Population Unified System 704,000 0 0 6,506,169 0 0 7,210,169 Offender Work Crew System 600 0 0 26,263 0 0 26,863 Optical 0 0 0 20,500 0 0 20,500 Page 69 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, 2011 Department of Correction OPUS web apps (Ext) 3,600 0 0 0 0 0 3,600 OPUS web apps (Int) 93,000 0 0 1,951,145 0 0 2,044,145 Pharmacy 0 0 0 37,334 0 205,640 242,974 PhotoID 48,000 0 0 23,184 0 0 71,184 Remedy 0 0 0 16,681 0 0 16,681 Roster Management 1,500 0 0 1,763 0 0 3,263 Safety and Environmental Health Reporting System 42,000 0 0 1,399 0 0 43,399 Sex Offender GPS 0 0 0 980,661 0 0 980,661 1,385,361 0 0 12,995,262 Total Costs for Department of Correction 0 205,640 14,586,263 Department of Crime Control and Public Safety 28 Day Work Cycle 16,640 7,105 0 33,333 0 0 57,078 Accident System 16,640 7,105 0 33,333 0 0 57,078 Activity Reports 16,640 7,105 0 33,333 0 0 57,078 ALE Case Tracking System (CTS - 1) 19,000 0 0 0 17,733 0 36,733 Aviation Documents 16,640 7,105 0 33,333 0 0 57,078 Aviation System 16,640 7,105 0 33,333 0 0 57,078 Bingo Licensing System 1,900 0 0 0 8,333 0 10,233 CAMEO/TIER II 11,100 0 0 0 0 0 11,100 Page 70 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, 2011 Department of Crime Control and Public Safety Canine Activity 36,640 0 0 33,333 0 0 69,973 CCPS Internet 15,600 0 0 0 8,333 0 23,933 Chemical Radiological 16,640 7,105 0 33,333 0 0 57,078 Citations 16,640 7,105 0 33,333 0 0 57,078 CJIN Mobile Data Switch 207,763 0 0 233,333 0 0 441,096 Collision Reconstruction 16,640 7,105 0 33,333 0 0 57,078 Computer Assisted Dispatch (CAD) 16,640 7,105 0 262,733 0 0 286,478 Contacts Database 15,600 0 0 0 8,333 0 23,933 Corrective Actions 16,640 7,105 0 33,333 0 0 57,078 Crime Victim Compensation 9,500 0 0 0 8,333 0 17,833 Daily Observation Reporting 16,640 7,105 0 33,333 0 0 57,078 Daily Operations Logs 16,640 7,105 0 33,333 0 0 57,078 DHS Grants Online 11,100 11,100 0 0 0 0 22,200 Disaster Tracking 11,100 11,100 0 0 0 0 22,200 DWI System 16,640 7,105 0 33,333 0 0 57,078 EM_GMS 1,900 0 0 0 8,333 0 10,233 EM_MOA 1,900 0 0 0 8,333 0 10,233 EMAP 11,100 11,100 0 0 0 0 22,200 Page 71 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, 2011 Department of Crime Control and Public Safety EMPG 11,100 11,100 0 0 0 0 22,200 Employee Holiday Time 16,640 7,105 0 33,333 0 0 57,078 Employee Roster 16,640 7,105 0 33,333 0 0 57,078 Employee Roster Report 16,640 7,105 0 33,333 0 0 57,078 Employee Transfer Regular and Delayed 16,640 7,105 0 33,333 0 0 57,078 Employee Work Schedules 16,640 7,105 0 33,333 0 0 57,078 Excess Property Database 31,200 0 0 0 8,333 0 39,533 Firearms Tracking 36,640 0 0 33,333 0 0 69,973 Flood Inundation Mapping & Alert Network 178,600 0 0 0 178,600 0 357,200 Flood Mapping Info System 2,000,000 0 0 0 2,000,000 0 4,000,000 Gas Mak Certification 36,640 0 0 33,333 0 0 69,973 Hazard Mitigation Planning 11,100 0 0 0 8,333 0 19,433 In-Service Class Registration 16,640 7,105 0 33,333 0 0 57,078 LESS Loan Program 15,600 0 0 0 8,333 0 23,933 Logistics Resources 16,640 7,105 0 33,333 0 0 57,078 Member Assistance team 16,640 7,105 0 33,333 0 0 57,078 Missing Persons Database 9,500 0 0 0 8,333 0 17,833 Mitigation Grants Management System 0 11,100 0 0 0 0 11,100 Page 72 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, 2011 Department of Crime Control and Public Safety NCDamp 0 11,100 0 0 0 0 11,100 NCEM Time & Attendance System 0 0 0 0 8,333 0 8,333 PAMS (Public Assistance Management System) 0 11,100 0 0 0 0 11,100 Personal Information 16,640 7,105 0 33,333 0 0 57,078 Personnel Action 16,640 7,105 0 33,333 0 0 57,078 Physical Assessment Candidate Selection 36,640 0 0 33,333 0 0 69,973 PIMA: Property & Inventory Management 1,900 0 0 0 8,333 0 10,233 PreApp Reporting Database 0 0 0 0 8,333 0 8,333 Promotional Process 16,640 7,105 0 33,333 0 0 57,078 Recruiter Applicant 36,640 0 0 33,333 0 0 69,973 Retired Employees 16,640 7,105 0 33,333 0 0 57,078 Roster History 16,640 7,105 0 33,333 0 0 57,078 SAVAN VINE Court 0 0 822,790 0 0 0 822,790 SAVAN VINE Link/ VINE Watch/ VINE Photo 0 0 38,139 0 0 0 38,139 SAVAN VINE Sex Offender Telephone Registry 0 0 66,000 0 0 0 66,000 SCP CAD Call Log 1,900 0 0 0 8,333 0 10,233 SCP Police PAK 1,900 0 0 0 8,333 0 10,233 Service Log 16,640 7,105 0 33,333 0 0 57,078 Page 73 Agency Application Name Internal Personnel Costs External Personnel Costs Other External Costs Hardware Costs Software Costs Other Costs Total YTD Application Cost |
| OCLC number | 277228134 |
Tags
Add tags for Information technology expenditures report : for the period ended...
Comments
Post a Comment for Information technology expenditures report : for the period ended...
