Information technology expenditures report : for the period ended ...

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