overview of the state employee workforce, compensation and …sfac.virginia.gov/pdf/general...

Overview of the State Employee Workforce Compensation and the State Employee Health Plan

Senate Finance and AppropriationsGeneral Government Sub-Committee

Emily S Elliott DirectorDepartment of Human Resource Management

January 282020

Topics for Discussion

bull Workforce Data

bull Compensation and Benefits

bull HR Systemsndash Recruitment Management Systemndash Cardinal Human Capital Management

DHRM 2January 28 2020

Workforce Data


Employment LevelsEmployee Resource Levels

(all position types)Majority of Executive Branch Employees are in Education

January 28 2020 DHRM 4

Source DHRM EPR Reports 11302019Source DHRM EPR Reports 11302019

STATEWIDE FTEs as of 11302019

SALARIED EMPLOYEES

Executive 10453067 9501

Legislative 52105 047

Judicial 332700 302

Independent 164280 149

Total Salaried 11002152 8256

WAGE EMPLOYEES

Executive 2301328 9905

Legislative 889 004

Judicial 13601 059


Total Temporary 2323391 1744

TOTAL EMPLOYEES 13325543 100

Executive Branch FTEs Education 5730751 5482

Public Safety amp Homeland Security 1734740 1660

Health and Human Resources 1242885 1189

Transportation 971745 930

Natural Resources 181612 174

Commerce amp Trade 152669 146

Finance 114651 110

Administration 100019 096

Veterans and Defense Affairs 104800 100

Agriculture amp Forestry 68210 065

Executive Offices 50985 049

TOTAL EXECUTIVE BRANCH 10453067 100

Classified State WorkforceEmployee Demographics

January 28 2020 DHRM ndash Data as of 06192019 5

Average Age

46

Average Age ofNew Hires

36

461539

Gender

Male Female

352

648

Race

Minority Non-Minority

78

922

Veterans

Veterans Non-Veterans2925

1830

1304

1065

964

950

556

308

097

Richmond

Other

Tidewater

Southside

Southwest

NOVA

Roanoke

Charlottesville

Winchester

Classified Employees by AreaClassified Workforce

58691



Telework Eligible

Positions

258

Employees Teleworking

187

3791

1627

1501

1025

767

525

764

0 to 5 years

5 to 10 years

10 to 15 years

15 to 20 years

20 to 25 years

25 to 30 years

30+ years

Years of State Experience

Average Years of Service

113

Classified State WorkforceJob Structure and Classification

January 28 2020 7

Occupational Family Career Groups Roles

Agencies also use work titles to further delineate jobs

Classified State WorkforceSalary Structure

January 28 2020 8

January 28 2020 9

STATE WORKFORCETOP TEN AGENCIES amp JOB ROLES

41 of classified workforce in 10 roles

Job Role Employees

1 Admin and Office Spec III 5805

2 Security Officer III 5730

3 Transportation Operator II 2278

4 Program Admin Specialist I 1737

5 Admin and Office Spec II 1604

6 Direct Service Associate II 1560

7 Program Admin Specialist II 1540

8 Probation Officer I 1225

9 Housekeeping ampor Apparel Worker I 1187

10 Financial Services Spec I 1175

23 of workforce in 10 Agencies

Agencies

1 University of Virginia Systems

2 Department of Corrections

3 VPI amp State University

4 Department of Transportation

5 Virginia Community College Systems

6 Virginia Commonwealth University

7 Dept of Behavioral Health amp Dev Services

8 George Mason University

9 Department of Health

10 James Madison University

DHRM

Classified State WorkforceHiring ndash New Employees and Rehires


Classified State WorkforceHiring - Counts and Starting Pay Band


Classified State WorkforceTurnover ndash Voluntary and In-Voluntary


Classified State WorkforceTurnover ndash Voluntary Resignations


Classified State WorkforceTurnover - Years of Service


Classified State WorkforceTurnover - Retirements


Exit Survey ResultsResponse Rate of Survey Completers

National Average for exit surveys is 20 The participation rate for the Commonwealth continues to climb

Commonwealth Net Promoter Score

Our net promoter score or what separating employees tell their friends and family about employment is improving steadily This is directly correlated with pay increases employee engagement initiatives and transparent communication

95 respondents58 respondents55 respondents 178 respondents

The reason individuals are separating transferring or retiring from the Commonwealth in Fiscal Year 2019 --------------------------------------------------------------------------------------------------------------

16January 28 2020 DHRM

Compensation


CompensationLookback at 2019

bull Effective January 10 2019 ndash special salary increases for distressed rolesndash Base salaries of Correctional Officers and Officer Seniors

increased by $2016 ndash Base salaries of Juvenile Correctional Officers and Officer

Seniors increased by $1846 ndash Virginia Marine Police with more than one year of service

on January 10 2019 shall be the greater of $43905 or their current salary adjusted for a 65 percent increase

ndash Base salaries for all DBHDS Direct Service Associates LPNs and RNs increased to within three percent of market median



bull Effective June 10 2019 - all employees in salaried positions as of March 10 2019 were eligible for a 275 increase subject to satisfactory performance

bull Salaried employees noted above also eligible for an additional 225 merit-based increase subject to satisfactory performancendash Under the Act Agencies had the authority to apply the merit-based increase

in a variable manner ndash Only 8 agencies chose to do so

bull Department of Forestrybull Science Museum of Virginiabull Longwood Universitybull Old Dominion Universitybull JamestownYorktown Commemorationbull JamestownYorktown Foundationbull State Council of Higher Education for Virginiabull Virginia Department of Small Business and Supplier Diversity

Faculty and wage employees increases managed locally


Compensation Industry Projections for 2020


Government Public Sector Industry

Salary Structure Adjustments 16 - 20

General Increases COLAs 19 - 24

Merit Increases 26 - 30

Total Projected Increases 30

General Industry




Total Projected Increases 32 - 33

Benefits ndash Health Insurance

21

Benefits ndash Health Insurancebull Office of Health Benefits provides oversight for the

state health plan that coversndash just over 201000 eligible state employees non-Medicare

retirees and their dependents ndash a local government health plan that covers 78000

participants ndash a Medicare retiree health plan that covers over 40000

members ndash a Line of Duty Act health program with 3000 members

bull In aggregate these plans have a total claims and administrative cost of approximately $2 Billion a year


Benefits ndash Health InsuranceLookback at 2019

bull May 2019 ndash utilized an online open enrollment system with 22000+ transactions processed online This was the first time the system had been back online in three years

bull July 1 2019 - new health benefit contracts in placendash Added a new regional plan for the Hampton Roads areandash Included one prescription drug administrator for all self insured

plansndash Included one dental plan administrator for all self insured plansndash New flexible spending program administrator

bull October 2019 - Premium holiday for Active state employees those with COBRA coverage and state retirees


Benefits ndash Premium Rewards

bull For COVA Care and COVA HealthAware premium rewards continued for FY20 and included in introduced budget for FY21ndash State employee and enrolled spouse are both

eligible for a premium reduction ndash By doing so state employee and spouse pay $17

less a month or $34 less when both met the requirement established

bull Requirement is the completion of a health assessment


Benefits ndash Premium Rewardsbull Participation in premium rewards has been stable in the last 2 years

bull About 31 of eligible population earn rewards leaving unearned premium rewards in the Health Insurance Fund

bull Excess premium rewards are factored into future premium rates to partially offset cost

62672

47721

33437

21156

34966 37475 37314 38584

0

10000

20000

30000

40000

50000

60000

70000

92013 92014 92015 92016 92017 92018 92019 122019

Number of EmployeesSpouses Receiving Rewards


BenefitsHealth Insurance Premiums


PLAN Current Monthly Cost (FY20) Proposed Monthly Change Proposed Monthly Cost (FY21)

COVA Care Basic Employee Only

Employee Plus One

Employee Plus

2 or More

Employee Only

Employee Plus One

Employee Plus 2 or More

Employee Only

Employee Plus One

Employee Plus

2 or More

Employee $75 $177 $253 + $2 + $4 + $7 $77 $181 $260

Employer $687 $1229 $1802 + $16 + $30 + $43 $703 $1259 $1845

TOTAL PREMIUM $ 762 $1406 $2055 $0 + $18 + $70 $ 780 $1440 $2105

COVA HealthAware Basic

Employee Only

Employee Plus One

Employee Plus

2 or More

Employee Only

Employee Plus One


Employee Only Employee Plus One

Employee Plus

2 or More

Employee $0 $24 $25 $0 - $24 - $25 $0 $0 $0

Employer $677 $1229 $1802 - $16 - $6 - $18 $661 $1223 $1784

TOTAL PREMIUM $677 $1253 $1827 - $16 - $30 - $43 $661 $12253 $1784

Source Department of Planning and Budget Schedule - December 2019

COVA Care Basic ndash FY 21 shows 241 increase in premiums COVA HealthAware Basic ndash FY 21 has 23 reduction in premiums

BenefitsHealth Insurance Fund


Active amp Early Retiree Plan Year End Balances

bull FY 2015 ndash $1323 millionbull FY 2016 - $946 millionbull FY 2017 - $1245 millionbull FY 2018 - $2606 millionbull FY 2019 - $3803 millionbull 122019 ndash $3864 million

0

50

100

150

200

250

300

350

400

450

2015 2016 2017 2018 2019 Dec-19

Mill

ions

Health Insurance Fund Year End Balances

HR Systems


Recruitment Management System

bull RMS is the system that facilitates the recruitment and filling of vacancies within the Commonwealth

bull Originally procured in 2006 one update in 2015bull Significant because in a given year over 15000+ jobs are

advertised and over 436000+ job applications are screened for potential interviews and hiringndash For individuals not currently employed in state government

RMS can be the first impression of state technology toolsbull Request for Proposal in October 2019 responses received

vendor presentations held final selection in progress ndash VITA is IT project lead DHRM business partnerndash Representatives from multiple state agencies involved

bull Anticipate go live date is November 2020


Human Capital Management (HCM) Project

Commonwealth of Virginia

Emily S Elliott DHRM and David Von Moll DOAJanuary 28 2020

bull Cardinal is an Enterprise Resource Planning (ERP) program managed by the Department of Accounts (DOA)

bull DOA and DHRM are partnering to replace legacy human resource health benefits time and attendance and payroll administrative systems with the Cardinal Human Capital Management application

bull Cardinal utilizes Oraclersquos PeopleSoft ERP software suite and expands upon the existing footprint of Cardinal Financials successfully implemented in 2016 to replace the Commonwealth Accounting and Reporting System (CARS)

31

What is Cardinal

Four high-level functional areas will be implemented across eight software modules addressing 17 business processes 49 sub-processes and 1482 requirements identified for HCM

Note Financial integration with General Ledger Accounts Payable Expense and Project Costing is also included

Cardinal HCM Project Scope

Area Cardinal PeopleSoft HCM Modules Business Processes

Human Resources

eProfile

Benefits Administration

eBenefits

Time and Labor

Absence Management

Payroll for North America

ePay

Human Resources

Payroll

Time amp Attendance


Setup and Maintain Employee HR Data Administer Salary Plans Maintain Additional HR DataBenefits Recon Administer Open Enrollment Administer Event Maintenance Administer COBRA ACA ReportingTampA Employee Setup TampA Capture TampA Approval and Processing Payroll Integration and Cost AllocationMaintain Employee Payroll Data Process Payroll Post Payroll Process Payroll Costing Periodic Regulatory Reporting

32

Modules-Reqs

PeopleSoft HCM modules

RICE

Cardinal HCM Implementation Timeline

33

Release 1 (R1) ndash March 2021

Release 2 (R2) ndash October 2021

Agency tasks split into Release 1 and Release 2 activitiesGo Live

We are here

34

Project Milestone Tracking

Milestone Planned Start Date

Actual Start Date

Planned End Date

Actual End Date

Planning and Analysis 5202019 5202019 6142019 6212019Design 5202019 5202019 10182019 10182019Construction 852019 7292019 6122020Release 1 System Test 462020 1152021User Test Execution 1112021 2122021Release 1 Training Delivery 1112021 2262021Release 1 Go-Live 312021 382021Release 1 Stabilization 382021 572021Release 2 System Test 452021 792021Release 2 Training Delivery 822021 1012021Release 2 Go-Live 1042021 10122021Release 2 Stabilization 1042021 1232021Project Closeout 522022 5312022

Milestones

bull Completed PeopleSoft Upgrade projectbull Completed the HCM project design phase and almost 50 done

with build phasebull Developed 50 of the custom Reports Interfaces Conversions

and Extensions (RICE) objectsbull Working with central and line agencies on new interfaces and

conducted detailed interface workshops bull Working with central and line agencies to complete Mock 1

conversion executionbull Published updated agency task list and monthly Master Agency

Readiness Scorecard (MaRS) to track agency readiness (All agencies have ldquoGreenrdquo statuses)

bull Completed training plan and curriculumbull Working with DHRM to review and finalize the locality

engagement planbull Established first HCM environment (development) on Oracle

Cloud Infrastructure (OCI) 35

Project Status

Project Budget Summary

Item Amount CommentAmount Spent as of FYE 2019 42500000$ Original Payroll Project HCM AnalysisAdditional HCM Project Costs 79320000 Required to complete implementationMove to Oracle Cloud Costs 10000000 Required for HCM

Total Projected Costs 131820000$ Current Working Capital Advance (WCA) (82400000) Additional WCA Required 49420000$

bull By comparison Cardinal Financials for Part 1 (VDOT) Part 2 (DOA) and Part 3 (Statewide Rollout) totaled $1144m for the replacement of CARS

bull NOTE As of December 31 2019 HCM Project is currently progressing on track from a budget perspective Anticipated change requests are expected to be handled through project contingency

36

Exec View

HCM Implementation

ampArialBoldCardinal UpgradeProject Budget Estimate

ampDampT

Payroll Project


ampDampT

HCM Project


ampDampT

SC

SOW12

SOW14

HR Estimate

Dependent Projectsbull Oracle Software Upgrade

ndash PeopleSoft Upgrade completed in December 2019 on time and within budget

bull Move to Cloud infrastructure and interim Cardinal training delivery management solution must be completed prior to Cardinal HCMndash Move to Oracle Cloud Infrastructure (OCI) included in HCM

implementation estimates to ensure timely completion First Cardinal OCI environment is operational Working with Oracle VITA and VITArsquos IT partners towards a May 2020 completion date but schedule is aggressive

ndash Cardinal training delivery management tool is included in HCM estimates Team is currently evaluated potential options

37

Project Challenges

Complex Agency Profilesbull Usage of central Human Resource Benefits Time and

Attendance and Payroll systems vary widely among varied mix of users

ndash State Executive Legislative and Judicial branch agencies and independent agencies

ndash Restructured Higher Education Institutions Community Collegesndash Local governmentsndash Classifiednon-classified employeesndash Retirees

bull Distinct business requirements demand a complex project and support model

ndash Leverage knowledge gained from HCM analysis phasendash Establish proven Change Network model including support team

dedicated to locality participantsndash Standardize processes where possible provide flexibility where

necessary and staff accordingly 38

Project Challenges (continued)




January 282020



Workforce Data

Employment Levels





Slide Number 9







Exit Survey Results

Compensation











HR Systems


Human Capital Management (HCM) Project Commonwealth of Virginia

What is Cardinal




Project Status


Project Challenges



Planning amp Implementation of PeopleSoft HR and Benefits

Detailed Planning Effort (COVA and Accenture) $2000000

Accenture Services for Implementation $9200000

COVA Services for Implementation $5600000

Hardware costs for HRBenefits $350000

Software costs (initial buy plus YR1 maintenance) $2000000

Other $250000

Planning and Implementation Costs $19400000

10 Contingency $1940000

Total Implementation Estimate $21340000

Del Phase Deliverable Name Due Date Deliverable Amount Date Paid Recon Outstanding

001 Analyze Plan Phase and Project Start Up 72418 $ 37500000

002 Analyze Project Management Services and Monthly Status Report (1) 72718 $ 7500000 83118 $ 45000000

Robinson Ray (DOA) Robinson Ray (DOA)Aug amp Sept total reported in Sept SC

004 Analyze As-Is Process Flow Designs 92118 $ 56000000

005 Analyze Project Management Services and Monthly Status Report (3) 92718 $ 7500000 103118 $ 63500000 $ - 0


007 Analyze Agency Assessment Survey Results 11918 $ 40000000


009 Analyze Project Management Services and Monthly Status Report (6) 122118 $ 6000000

010 Analyze As-Is Reports and Interfaces Inventory 122118 $ 27500000 123118 $ 35000000

011 Analyze Technology Roadmap 122718 $ 21000000 13119 $ 27000000 $ - 0


013 Analyze Application and Interface Disposition 13119 $ 14500000

014 Analyze iHubOkta Impacted Use Cases 13119 $ 17500000 $ - 0

015 Analyze To-Be Process Flow Designs 21519 $ 45000000

016 Analyze Reporting Analysis 22219 $ 10000000 33119 $ 53000000

017 Analyze Project Management Services and Monthly Status Report (8) 22819 $ 3000000 $ 13000000 $ - 0

018 Analyze Requirements 31519 $ 15000000

019 Analyze RICE Inventory 32219 $ 10000000

020 Analyze Project Management Services and Monthly Status Report (9) 32819 $ 3000000 $ 28000000

021 Analyze Implementation Estimate 41219 $ 14000000

022 Analyze RICE Functional Designs 41219 $ 10000000

023 Analyze Configuration Designs 41219 $ 10000000


$ 385000000

Del Phase Team Deliverable Name Due Date Deliverable Amount Date Paid Recon Outstanding

1 PlanAnalyze Project Management Microsoft Project Plan 81916 $ 10000000

2 PlanAnalyze Project Management Project Management Plan 82416 $ 10000000

3 PlanAnalyze Change Leadership Communication Plan 82416 $ 12500000

4 PlanAnalyze RICE Management Reporting Analysis 82616 $ 30000000

5 PlanAnalyze Project Management Project Management Services and Monthly Status Report (1) 83116 $ 22500000 93016 $ 85000000

6 Design Application Management Requirements Traceability Matrix 91616 $ 17500000

7 Design Test Management Test Approach 92316 $ 12500000

8 Design Technical Management Environment Plan 92316 $ 35000000

9 Design Change Leadership Readiness Approach 92316 $ 20000000 103116 $ 85000000

10 Design Project Management Project Management Services and Monthly Status Report (2) 93016 $ 22500000

11 Design Training Training Plan 102116 $ 20000000

12 Design Change Leadership Quarterly Communications Delivery (1) 102116 $ 4000000

13 Design Technical Management Technical Architecture Analysis 102816 $ 35000000

14 Design Project Management Project Management Services and Monthly Status Report (3) 102816 $ 22500000 113016 $ 69000000

15 Design Application Management Configuration and Security Design (1) 111816 $ 35000000

16 Design RICE Management RICE Functional Designs (1) 112116 $ 60000000


18 Design Training Training Curriculum Design 122316 $ 32500000

19 Design Project Management Project Management Services and Monthly Status Report (5) 123016 $ 22500000 13017 $ 115000000 $ - 0 Dec 16

20 Design Change Leadership Agency Readiness Outreach and Support - Design Phase 12017 $ 15000000

21 Design Technical Management Technical Architecture Design 12017 $ 35000000 43017 $ 59000000



24 Design Application Management Configuration and Security Design (2) 13017 $ 35000000 22817 $ 74000000 Jan 17

25 Build RICE Management RICE Functional Designs (2) 21017 $ 60000000 33117 $ 81400000

26 Build Application Management Updated Process Flows and Narratives 21717 $ 35000000

27 Build Test Management System Test Scripts - Cycle 0 22417 $ 10000000

28 Build Project Management Project Management Services and Monthly Status Report (7) 22417 $ 20000000 $ - 0 Feb 17


30 Build RICE Management RICE Technical Designs 32417 $ 65000000

31 Build Application Management Configuration and Security Build (1) 32417 $ 47500000

32 Build Project Management Project Management Services and Monthly Status Report (8) 33117 $ 20000000 $ - 0 Mar 17


34 Build Change Leadership Role Descriptions 42117 $ 10000000

35 Build Change Leadership Quarterly Communications Delivery (3) 42117 $ 4000000

36 Build RICE Management RICE BuildUnit Test (1) 42417 $ 65000000

37 Build Project Management Project Management Services and Monthly Status Report (9) 42817 $ 20000000 53117 $ 130500000

38 Build Test Management System Test Scripts - Cycle 3 42817 $ 10000000 $ - 0 Apr 17


40 Build Training Training Design 51917 $ 10000000


42 Build Application Management Configuration and Security Build (2) 51917 $ 40500000 63017 $ 89500000
Robinson Ray (DOA) Robinson Ray (DOA)went back to April and made the correction to remove the deliverable 50k

43 Build Test Management Parallel Test Approach 52317 $ 15000000

44 Build Project Management Project Management Services and Monthly Status Report (10) 53117 $ 20000000

45 Build Test Management System Test Scripts - Cycle 6 53117 $ 10000000 73017 $ 159000000 $ - 0 May 17


47 Build Change Leadership Agency Readiness Outreach and Support - Build Phase 61617 $ 15000000

48 Build Change Leadership Business Process Workshops - Release 1 62317 $ 17500000 83117 $ 160014400



51 Build RICE Management Mock 1 Conversion Results 63017 $ 35000000

52 Build Test Management System Test Scripts - Cycle 9 63017 $ 10000000 $ - 0 June 17

53 Test RICE Management RICE BuildUnit Test (2) 7717 $ 65000000

54 Test Test Management System Test Scripts - Cycle 10 7717 $ 10000000

55 Test Training Test Training Approach 71417 $ 7500000

56 Test Test Management System Test Results - Cycle 0 72117 $ 10000000

57 Test Change Leadership Quarterly Communications Delivery (4) 72417 $ 4000000

58 Test Project Management Project Management Services and Monthly Status Report (12) 72817 $ 20000000 $ - 0 Jul 17

59 Test Test Management User Acceptance Test Plan 81117 $ 12500000


61 Test Training Training Build (1) 82417 $ 7500000

62 Test Project Management Project Management Services and Monthly Status Report (13) 83117 $ 20000000 93017 $ 32550000

63 Test RICE Management Mock 2 Conversion Results 83117
Oneill Edmond (DOA) Oneill Edmond (DOA)This really is 350kRR updated 91217 $ 35000000 $ - 0 Aug 17




67 Test Test Management System Test Results - Cycle 2 92917 $ - 0 $ - 0 Sep 17



70 Test Technical Management Performance Test Approach 102017 $ 12500000 113017 $ 85400000


72 Test Change Leadership Role Mapping - Release 1 102417 $ 10000000

73 Test Project Management Project Management Services and Monthly Status Report (15) 102717 $ 15000000

74 Test RICE Management Mock 3 Conversion Results 102717 $ 35000000 $ - 0 Oct 17

75 Test Test Management System Test Results - Cycle 6 111017 $ 10000000 123017 $ 170126000


77 Test RICE Management Batch Design 112117 $ 27500000

78 Test Project Management Project Management Services and Monthly Status Report (16) 113017 $ 15000000 $ - 0 Nov 17

79 Test Technical Management Performance Test Scripts 121517 $ 22500000


81 Test Project Management Project Management Services and Monthly Status Report (17) 122917 $ 15000000 13118 $ 57022000 $ 25000000 Dec 17

82 Test Test Management System Test Results - Cycle 8 11218 $ - 0

83 Test Change Leadership Agency Readiness Outreach and Support - Test Phase - Release 1 11918 $ 15000000

84 Test Training Test Training - Release 1 11918 $ 7500000


86 Test RICE Management Batch Build - Release 1 12418 $ 20000000


88 Test Project Management Project Management Services and Monthly Status Report (18) 13118 $ 15000000 22818 $ 196430000 $ 42500000 Jan 18

89 Deploy Technical Management Performance Test Results 21618 $ 20000000

90 Deploy Test Management Parallel Test Results ndash Release 1 21618 $ 20000000

91 Deploy Application Management Deployment Plan ndash Release 1 21618 $ - 0

92 Deploy Test Management UAT Test Results 22318 $ 20000000

93 Deploy Project Management Project Management Services and Monthly Status Report (19) 22818 $ 13000000 33018 $ 111019023 $ 82500000 Feb 18

94 Deploy Change Leadership Agency Readiness Outreach and Support - Deploy Phase - Release 1 31618 $ 10000000

95 Deploy Training Training Delivery ndash Release 1 32318 $ 20000000

96 Deploy Project Management Project Management Services and Monthly Status Report (20) 33018 $ 12500000 43018 $ 65930000 $ 102500000 Mar 18

97 Deploy Application Management Production Go-Live ndash Release 1 4218 $ 32500000

98 Stabilization Change Leadership Quarterly Communications Delivery (7) 42318 $ 4000000 53018 $ 108930000

99 Stabilization Project Management Project Management Services and Monthly Status Report (21) 42718 $ 7500000

100 Stabilization Application Management System Stabilization (1) ndash Release 1 42718 $ 47500000 $ 182500000 Apr 18

101 Stabilization Application Management System Stabilization (2) ndash Release 1 53118 $ 45000000

102 Stabilization Project Management Project Management Services and Monthly Status Report (22) 53118 $ 10000000 63018 $ 110128000 $ 182500000 May 18

103 Test RICE Management Mock 4 Conversion Results 62218 $ 35000000

104 Test Training Training Build - Release 2 62218 $ 3000000



107 Test Training Test Training and Train-the-Trainer - Release 2 7918 $ 5000000

108 Test Change Leadership Agency Readiness Outreach and Support - Test Phase - Release 2 71818 $ 5000000 $ 220500000 Jun 18

109 Test Change Leadership Business Process Workshop Refresh - Release 2 72418 $ 5000000


111 Test Test Management Supplemental Interface Test Results 72718 $ 22500000

112 Test Project Management Project Management Services and Monthly Status Report (24) 72718 $ 7500000 83118 $ 47550000 $ 278000000 Jul 18

113 Deploy Change Leadership Role Mapping Review - Release 2 81018 $ 5000000

114 Deploy Application Management Deployment Plan ndash Release 2 81718 $ 27500000

115 Deploy Test Management Parallel Test Results ndash Release 2 82418 $ - 0

116 Deploy Project Management Project Management Services and Monthly Status Report (25) 83118 $ 7500000 $ 318000000 Aug 18



119 Deploy Project Management Project Management Services and Monthly Status Report (26) 92818 $ 5000000 $ 20000000 Sep 18


121 Stabilization Change Leadership Quarterly Communications Delivery (9) 102418 $ 2500000


123 Stabilization Project Management Project Management Services and Monthly Status Report (27) 103118 $ 5000000 $ 35000000 Oct 18



126 Stabilization Application Management Successful Go-Live 113018 $ 4852900 $ 36352900 Nov 18

Orig Total $ 2261852900 23498529 $ 88000000

Plus CRs $ 2659102323

Change Requests

127 COA Support Feb-17 SOW12-CR027 22817 $ 1400000

128 COA Support Mar-17 SOW12-CR027 33117 $ 4000000

129 COA Support Apr-17 SOW12-CR027 42817 $ 4000000

130 COA Support May-17 SOW12-CR027 53117 $ 4000000

131 COA Support Jun-17 SOW12-CR027 63017 $ 4000000

132 COA Support Jul-17 SOW12-CR027 73117 $ 4000000

133 COA Support Aug-17 SOW12-CR027 81817 $ 2550000

134 App CR Tru Up Jul-17 SOW12-CR046 81817 $ 49514400

135 App CR Tru Up Nov-17 SOW12-CR046 81917 $ 39600000

136 Sched Change Oct-17 SOW12-CR056 103117 $ 18300000 $175k on Julies list

137 Sched Change Nov-17 SOW12-CR056 113017 $ 18300000 $175k on Julies list

138 Sched Change Dec-17 SOW12-CR056 122717 $ 18300000

139 Sched Change Jan-18 SOW12-CR056 13118 $ 18300000

140 Sched Change Feb-18 SOW12-CR056 22818 $ 18300000

141 Sched Change Mar-18 SOW12-CR056 33018 $ 18300000
Robinson Ray (DOA) Robinson Ray (DOA)changed to 183k from 175k per April Cardinal Query

142 Sched Change Apr-18 SOW12-CR056 42718 $ 18300000

143 Sched Change May-18 SOW12-CR056 53118 $ 17628000

144 CR059 App True up Func Designs CR059 App CR True Up Functional Designs 112917 $ 20000000

145 CR059 App True up Tech Design Bld CR059 App CR True Up TDBuild 121517 $ 13696000

146 ihub designs iHub Design 122517 $ 19592000

147 Okta ihub Arch Approach Feb-18 OktaiHub Architecture Approach 22218 $ 16000000

148 iHub Build Mar-18 iHub Build 31618 $ 12000000

149 Okta ihub use cases Mar-18 OktaiHub Use Cases 4618 $ 9000000

150 Okta iHub sys test scripts Mar-18 OktaiHub System Test Scripts 32318 $ 12500000

151 Okta iHub sys test results Apr-18 OktaiHub System Test Results 43018 $ 13800000

152 Conversion support month 1 Conversion Support ndash Month 1 121517 $ 4130000

153 Conversion support month 2 Jan-18 Conversion Support ndash Month 2 11518 $ 4130000

154 Conversion support month 3 Feb-18 Conversion Support ndash Month 3 21518 $ 4130000

155 Conversion support month 4 Mar-18 Conversion Support ndash Month 4 31518 $ 4130000

156 Conversion support month 5 Apr-18 Conversion Support ndash Month 5 41518 $ 4130000

157 Storm Runner Load Licenses Feb-18 Storm Runner Load Licenses 21518 $ 1219023

67a CR76 System Test Results - Cycle 2 72718 CR76 System Test Results - Cycle 2 72718 $ 23750000

67b CR76 System Test Results - Cycle 2 TBD CR76 System Test Results - Cycle 2 TBD $ 1250000

82a CR76 System Test Results - Cycle 8 73118 CR76 System Test Results - Cycle 8 73118 $ 13800000 93018 $ 13800000


91 CR76 Deployment Plan ndash Release 1 62218 CR76 Deployment Plan ndash Release 1 62218 $ 21450000

91b CR76 Deployment Plan ndash Release 1 TBD CR76 Deployment Plan ndash Release 1 TBD $ 11550000

115 CR76 Parallel Test Results ndash Release 2 62218 CR76 Parallel Test Results ndash Release 2 62218 $ 7500000

115b CR76 Parallel Test Results ndash Release 2 TBD CR76 Parallel Test Results ndash Release 2 TBD $ 7500000

158 CR76 Holdback Release 1 ($224693040) 81018 CR76 Holdback Release 1 ($224693040) 81018 $ - 0

total CRs $ 485249423

$ 2747102323

CR46 891144 24629173 ECO Note 9117 Current correct value of Accenture contract

OKTA

HCM Project

Cardinal HCM Analysis

Project Life To Date

Major Budget Category Budget Planned Actual Variance

Internal Staff Resources $ 1331432 $ 988809 $ 776250 $ 212559

Contractual Services $ 5796104 $ 4701310 $ 3942736 $ 758575

Software and Tools $ 5000 $ - 0 $ - 0 $ - 0

VITA Comprehensive $ 217588 $ 157588 $ 57500 $ 100089

Telecommunications $ 110482 $ 80482 $ 20455 $ 60027

IV and V $ 24000 $ 24000 $ 11890 $ 12110

Other $ 415393 $ 306191 $ 113101 $ 193091

Contingency $ 1100000 $ - 0 $ - 0 $ - 0

Total $ 9000000 $ 6258381 $ 4921931 $ 1336451

Payroll Project

Cardinal Payroll Project



Internal Staff Resources $ 1739341 $ 1739341 $ 1852871 $ (113530)


Software and Tools $ - 0 $ - 0 $ - 0 $ - 0


Telecommunications $ 142117 $ 133117 $ 138767 $ (5650)

IV and V $ 44283 $ 44283 $ 56173 $ (11890)

Other $ 676030 $ 652318 $ 627544 $ 24774

Contingency $ 200000 $ - 0 $ - 0 $ - 0

Total $ 34000000 $ 33453656 $ 33023592 $ 430064

Totals

Cardinal Payroll and HCM Analysis Projects Total

Total Project Project Life To Date







IV and V $ 68283 $ 68283 $ 68063 $ 220

Other $ 1091423 $ 958509 $ 740645 $ 217865

Contingency $ 1300000 $ - 0 $ - 0 $ - 0

Total $ 43000000 $ 39712037 $ 37945523 $ 1766514

43000000

$ 0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 HCM Costs for Steering Committee

HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM HCM

Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 TOTALS

COVA Overtime

10

Employees Role

Stacy McCracken Business Manager 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 173 173 173 173 173 173 173 173 173 173 0 1730

Kim White Functional Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 173 173 173 173 173 173 173 173 173 173 0 2050

Laura Swecker Payroll Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 173 173 173 173 173 173 173 173 173 173 0 2050

Rob Ramey HRBen Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 173 173 173 173 173 173 173 173 173 173 0 2050

Lora George Functional SME 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 173 173 173 173 173 173 173 173 173 173 0 2050

Donna BrownAlex Morgan AP Integration 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 173 173 173 173 173 173 173 173 173 173 0 2050

LaTayna ForemanKaren Jones Security Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 173 173 173 173 173 173 173 173 173 173 0 2050

Lance Kaeberle Interface Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 173 173 173 173 173 173 173 173 173 173 0 2050

Pam TauerLeonard Nottingham Technical Manager 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 173 173 173 173 173 173 173 173 173 173 0 2050

Employee - Total Hours Employee - Total Hours 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1280 1280 1557 1557 1557 1557 1557 1557 1557 1557 1557 1557 0 18130

Consultant Role

Ned ONeill Program Manager 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 176 176 176 176 176 176 176 176 176 176 176 176 0 2112

Ray Robinson PMO Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 0 1920

Sharon ArtisPam Watson Payroll Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80 120 120 120 120 120 120 120 120 120 0 0 1160

Anne Looney TA Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

James BlantonRon Gotshall TA Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Connie FisherLiz Lake COA Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Wilson Parks Conv Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 0 1920

Saadya Russell Conversion Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 0 1920

Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Allison Patrick SPO Liaison 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Sridhar Kamatala BatchInterface 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Steve WeastParkhurst Tech Support 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

M DaughtryJolene Christensen CM Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 176 176 176 176 176 176 176 176 176 176 176 176 0 2112

Angela GrayZampolin Trainer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 0 1920

Stuart Handlan Trainer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Andrea Garrison Trainer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Robyn Maitland Trainer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Helen Ardman Trainer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 0 1920

LaShawn Hunter CM Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Frank OverbeyMohan Sareddy CM Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Ajit SawantFralin Liaison 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Heather Simpkins Liaison 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Pat Reddington Liaison 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Janeen Wall Liaison 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Minoj Ravapati Absence Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Consultant - Total Hours 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1152 1232 1272 1272 1272 1272 1272 1272 1272 1272 1272 1152 0 14984

Total Employee and Consultant Hours 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2432 2512 2829 2829 2829 2829 2829 2829 2829 2829 2829 2709 0 33114

Loaded Rate Per Hour Loaded Rate Per Hour

Employees Role

Stacy McCracken Business Manager 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472 9472

Kim White Functional Lead 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364 8364

Laura Swecker Payroll Lead 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900 5900

Rob Ramey HRBen Lead 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513 3513

Lora George Functional SME 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908 7908

Donna BrownAlex Morgan AP Integration 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6501 6584 6584 6584 6584 6584 6584 6584 6584 6584 6584 6584 6584 6584

LaTayna ForemanKaren Jones Security Lead 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 5385 6464 6464 6464 6464 6464 6464 6464 6464 6464 6464 6464 6464 6464

Lance Kaeberle Interface Lead 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610 8610

Pam TauerLeonard Nottingham Technical Manager 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 8769 9201 9201 9201 9201 9201 9201 9201 9201 9201 9201 9201 9201 9201

Consultants Role

Ned ONeill Program Manager 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616

Ray Robinson PMO Lead 7008 7008 7008 7008 7008 7008 7008 7008 7008 7008 7008 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359

Sharon ArtisPam Watson Payroll Analyst 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 13688 9208 9208 9208 9208 9208 9208 9208 9208 9208 9208 9208 9208

Anne Looney TA Lead 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632 10632

James BlantonRon Gotshall TA Analyst 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 3614 3614 3614 3614 3614 3614 3614 4216 4216 4216 4216 4216 4216 4216 4216 4216 4216 4216 4216 4216 4216 4216 4216 4216 4216

Connie FisherLiz Lake COA Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000

Wilson Parks Conv Analyst 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011 3011

Saadya Russell Conversion Lead 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068 18068

Tests 1 2 3 4 Testers 1 2 3 4 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 10000 10000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000

Allison Patrick SPO Liaison 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227

Sridhar Kamatala BatchInterface 12413 12413 12413 12413 12413 12413 12413 12413 12413 12413 12413 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655 13655

Steve WeastParkhurst Tech Support 10548 10548 10548 10548 10548 10548 10548 10548 10548 10548 10548 10548 10548 10548 10548 10548 10548 10548 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409 2409

M DaughtryJolene Christensen CM Lead 12467 12467 12467 12467 12467 12467 12467 12467 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521 17521

Angela GrayZampolin Trainer 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106

Stuart Handlan Trainer 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035 12035

Andrea Garrison Trainer 12484 12484 12484 12484 12484 12484 12484 12484 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878 15878

Robyn Maitland Trainer 9400 9400 9400 9400 9400 9400 9400 9400 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236 14236

Helen Ardman Trainer 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600 11600

LaShawn Hunter CM Analyst 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926

Frank OverbeyMohan Sareddy CM Analyst 6444 6444 6444 6444 6444 6444 6444 6444 6444 6444 6444 6444 6444 6444 6444 6444 6444 6444 8400 8400 8400 8400 8400 8400 8400 8400 8400 8400 8400 8400 8400 8400 8400 8400 8400 8400

Ajit SawantFralin Liaison 9308 9308 9308 9308 9308 9308 9308 16500 16500 16500 16500 16500 16500 16500 16500 16500 16500 16500 3614 3614 3614 3614 3614 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106 4106

Heather Simpkins Liaison 9860 9860 9860 9860 9860 9860 9860 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623

Pat Reddington Liaison 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733 7733

Janeen Wall Liaison 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308 9308

Minoj Ravapati Absence Analyst 16021 16021 16021 16021 16021 16021 16021 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951 10951

Cost Per Resource Cost Per Resource

Employees Role










Consultants
rayrobinson rayrobinsonadd Helen Ardman Role

Ned ONeill Program Manager 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Robinson Ray (DOA) Robinson Ray (DOA)No consultant charges this month 0
Robinson Ray (DOA) Robinson Ray (DOA)No consultant charges this month 0 35370 31275
Robinson Ray (DOA) Robinson Ray (DOA)Sept 2018 37046
Robinson Ray (DOA) Robinson Ray (DOA)Oct 2018 23270
Robinson Ray (DOA) Robinson Ray (DOA)Nov 2018 28482
Robinson Ray (DOA) Robinson Ray (DOA)Dec 2018 36487
Robinson Ray (DOA) Robinson Ray (DOA)Jan 2019 32764 32764 32764 0 290223

Ray Robinson PMO Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12952 10965

Sharon ArtisPam Watson Payroll Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7408 6053



Connie FisherLiz Lake
rayrobinson rayrobinsonreplaced Gray with Ryan since we never get charges for Gray
Robinson Ray (DOA) Robinson Ray (DOA)No consultant charges this month
Robinson Ray (DOA) Robinson Ray (DOA)Sept 2018
Robinson Ray (DOA) Robinson Ray (DOA)Oct 2018
Robinson Ray (DOA) Robinson Ray (DOA)Nov 2018
Robinson Ray (DOA) Robinson Ray (DOA)Dec 2018
Robinson Ray (DOA) Robinson Ray (DOA)Jan 2019
Robinson Ray (DOA) Robinson Ray (DOA)Jan 2019 COA Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Wilson Parks Conv Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6105 5127

Saadya Russell Conversion Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29921 25932
Robinson Ray (DOA) Robinson Ray (DOA)Jan 2019 27262

Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0




M DaughtryJolene Christensen CM Lead 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24755 27284

Angela GrayZampolin Trainer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5913 5215




Helen Ardman Trainer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21924 13920
Robinson Ray (DOA) Robinson Ray (DOA)Oct 2018 0 0 0 18560 18560 18560 0 106807








Employee Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries $3792332 $3789112 plus mileage $981 151648 76835
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries Oct $3792396 amp Nov $3789365 plus mileage $101726 75517
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries $4342000 $3791564 plus mileage $$1403 77982
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries $4124522 $3672723 plus mileage $981 150964
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries $7548118 DHRM salaries $7545867 mileage $2447 167130
Robinson Ray (DOA) Robinson Ray (DOA)DOA amp DHRM Salaries plus mileage 76173
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries mileage amp employee development 114208 114208 114208 0 1118873 1118873 COVA Staff

Consultant Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 144348 125770 139587 102551 105619 124861 145281 145281 134232 250000 1417529 1417529 COVA Consultants

Total COVA Resource Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 151648 221183 201287 217569 253515 272749 201034 259489 259489 248439 250000 2536402 2536402

COVA Support

Advisory Services (Research Studies) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Services

SME Support 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Services

IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890
Robinson Ray (DOA) Robinson Ray (DOA)IVampV 12110 0 0 0 24000
rayrobinson rayrobinsonmust stay $288k 24000 IV and V

VITA Charges 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp bill 0 0 11412
Robinson Ray (DOA) Robinson Ray (DOA)VITA Comp Charges 12675
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp bill 11858
Robinson Ray (DOA) Robinson Ray (DOA)VITA bill $1149423 plus eVA fees $36408 10740
Robinson Ray (DOA) Robinson Ray (DOA)VITA Comp charges 10814
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp bill 102500 20000 20000 0 200000 200000 VITA Charges

Facilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Robinson Ray (DOA) Robinson Ray (DOA)Paragon rent 0
Robinson Ray (DOA) Robinson Ray (DOA)Paragon Lease 0 20343
Robinson Ray (DOA) Robinson Ray (DOA)Paragon Lease 20343
Robinson Ray (DOA) Robinson Ray (DOA)paragon lease 18021
Robinson Ray (DOA) Robinson Ray (DOA)Paragon lease 16468
Robinson Ray (DOA) Robinson Ray (DOA)partial paragon lease 128734 30000 30000 0 300000 300000 Facilities

Telecommunications 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill June amp July
Robinson Ray (DOA) Robinson Ray (DOA)VITA Comp Charges
Robinson Ray (DOA) Robinson Ray (DOA)Paragon Lease
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp bill
Robinson Ray (DOA) Robinson Ray (DOA)Paragon Lease 0 0 0 8576
Robinson Ray (DOA) Robinson Ray (DOA)VITA telephone bill 4087
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill 3857
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill 59545 10000 10000 0 100000 100000 Telecommunications

Training 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Other Services

Other (including Trainers UAT Xerox) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Robinson Ray (DOA) Robinson Ray (DOA)Employee prof cert
Robinson Ray (DOA) Robinson Ray (DOA)VITA bill $1149423 plus eVA fees $36408
Robinson Ray (DOA) Robinson Ray (DOA)eVA fees
Robinson Ray (DOA) Robinson Ray (DOA)IVampV
Robinson Ray (DOA) Robinson Ray (DOA)VITA Comp charges
Robinson Ray (DOA) Robinson Ray (DOA)paragon lease
Robinson Ray (DOA) Robinson Ray (DOA)VITA telephone bill
Robinson Ray (DOA) Robinson Ray (DOA)Paragon lease
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill
Robinson Ray (DOA) Robinson Ray (DOA)partial paragon lease
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill 0 0 0 0 0 0 58000 6000 6000 1202 73036 73036 Other Services

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 0 0 1100000 1100000 Contingency Need to eat 277k for overage on Planning initiative

Total Planned Cost for COVA Support 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1834 20343 31755 39906 33382 32618 43106 360889 1166000 66000 1202 1797036 1797036

System

cross ref against julies number

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 0 5000 5000 Software 23498529

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Hardware 3936304

Accenture 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 dels 1 amp 2 525000
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 Dels 1 2 amp 3 reported for Oct SC meeting adjustment made to payroll budget 635000
Robinson Ray (DOA) Robinson Ray (DOA)SOW14 Dels 4 amp 5 75000
Robinson Ray (DOA) Robinson Ray (DOA)SOW14 Del 6 350000
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 Dels 12 13 14 amp 15 530000
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 Dels 7 16 amp 17 280000 370000 50000 0 3900000 3900000 Accenture
Oneill Edmond (DOA) Oneill Edmond (DOA)Estimated contract value with new scope CRs added 27434833

Total Planned Cost for HW SW Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 525000 635000 75000 350000 270000 815000 530000 280000 370000 55000 0 3905000 3905000

Totals

Totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 678483 876526 308042 607475 556898 1120366 774140 900378 1795489 369439 251202 8238438 8238438

Cumulative totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 678483 1555009 1863051 2470526 3027424 4147790 4921931 5822308 7617797 7987236 8238438 8238438

Major Budget Category FY17 FY18 FY19 Total

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 151648 76835 75517 77982 150964 167130 76173 114208 114208 114208 0 1118873 Internal Staff Resources 0 0 1118873 1118873

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 525000 779348 200770 489587 372551 920619 654861 425281 515281 184232 250000 5317529 Services 0 0 5317529 5317529

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 0 5000 Software Tools 0 0 5000 5000

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11412 12675 11858 10740 10814 102500 20000 20000 0 200000 Hardware 0 0 200000 200000

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8576 4087 3857 3934 59545 10000 10000 0 100000 Telecommunications 0 0 100000 100000

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890 12110 0 0 0 24000 IV and V 0 0 24000 24000

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1834 20343 20343 18655 17437 18021 16468 186734 36000 36000 1202 373037 Other 0 0 373037 373037

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 0 0 1100000 Contingency 0 0 1100000 1100000

Total Major Budget Category 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 678483 876526 308042 607475 556898 1120366 774140 900378 1795489 369439 251202 8238438 Total Major Budget Category 0 0 8238438 8238438

0

Major Budget Category - CUMULATIVE
rayrobinson rayrobinsonactual costs to date for CTP status
rayrobinson rayrobinsonmust stay $288k
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 dels 1 amp 2
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 Dels 1 2 amp 3 reported for Oct SC meeting adjustment made to payroll budget
Robinson Ray (DOA) Robinson Ray (DOA)SOW14 Dels 4 amp 5
Robinson Ray (DOA) Robinson Ray (DOA)SOW14 Del 6
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 Dels 12 13 14 amp 15
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 Dels 7 16 amp 17
Oneill Edmond (DOA) Oneill Edmond (DOA)Estimated contract value with new scope CRs added

Internal Staff Resources 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 151648 228483 304000 381983 532947 700077 776250 890458 1004665 1118873 1118873 1118873

Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 525000 1304348 1505118 1994705 2367256 3287875 3942736 4368017 4883298 5067529 5317529 5317529

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 5000 5000

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11412 24087 35946 46686 57500 160000 180000 200000 200000 200000

Telecommunications 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8576 12664 16521 20455 80000 90000 100000 100000 100000

IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890 24000 24000 24000 24000 24000

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1834 22177 42520 61175 78612 96633 113101 299835 335835 371835 373037 373037

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 1100000 1100000 1100000

0

Cumulative Totals - Major Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 678483 1555009 1863051 2470526 3027424 4147790 4921931 5822308 7617797 7987236 8238438 8238438

rayrobinson rayrobinsonthis figure should match the grand total in Stacys Cardinal query report
rayrobinson rayrobinsonshould match grand total from cardinal query

Major Budget Category


Contractual Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Robinson Ray (DOA) Robinson Ray (DOA)1017 lowered planned $ for Oct to bal out $43M
rayrobinson rayrobinsonshould match grand total from cardinal query 0 0 0 0 0 0 0 0 0 654343 855281 220281 620281 690281 510281 725281 425281 515281 195281 134232 250000 5796104

Software and Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 0 5000

VITA Comprehensive 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17588 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 217588


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12000 0 0 0 12000 0 0 0 0 24000

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21240 22951 46000 36000 36000 36000 36000 36000 36000 36000 36000 36000 1202 415393

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 0 0 1100000

Total Major Budget Category 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 134771 781188 1045489 400489 812489 870489 690489 905489 617489 695489 1475489 319439 251202 9000000

0



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 654343 1509624 1729905 2350186 3040467 3550748 4276029 4701310 5216592 5411873 5546104 5796104 5796104

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 5000 5000

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17588 37588 57588 77588 97588 117588 137588 157588 177588 197588 217588 217588 217588


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 24000 24000 24000 24000 24000 24000

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21240 44191 90191 126191 162191 198191 234191 270191 306191 342191 378191 414191 415393 415393

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Robinson Ray (DOA) Robinson Ray (DOA)removed $2M from here for Sept SC 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 1100000 1100000 1100000

0


850092 1237743 1405639 1019241 1166273 992494 1672404 1544478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524271 125668807 678483 876526 308042 607475 556898 1120366 774140

SDM Recon Line -850092
Robinson Ray (DOA) Robinson Ray (DOA)sb= 0
rayrobinson rayrobinsonshould match grand total from cardinal query -1237743
Robinson Ray (DOA) Robinson Ray (DOA)removed $2M from here for Sept SC -1166273
Robinson Ray (DOA) Robinson Ray (DOA)sb= 0 -992494
Robinson Ray (DOA) Robinson Ray (DOA)sb= 0 0

VARIANCE


Internal Staff Resources 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -113531 -189355 -151914 -189287 -227978 -264203 -227447 -174525 -212559 -212559 -212559 -212559 -212559 -212559

Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -654343 -984624 -425557 -845068 -1045762 -1183492 -988155 -758575 -848575 -528575 -478575 -478575 -478575

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -17588 -37588 -57588 -66176 -73501 -81643 -90903 -100089 -17589 -17589 -17589 -17589 -17589

Telecommunications 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -10482 -20482 -30482 -40482 -41906 -47818 -53961 -60027 -10482 -10482 -10482 -10482 -10482

IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -12000 -12000 -12000 -12000 -12110 0 0 0 0 0

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -21240 -44191 -88357 -104014 -119671 -137016 -155580 -173559 -193091 -42357 -42357 -42357 -42357 -42357

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Cumulative Totals - Major Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -134771 -915960 -1282965 -806929 -1311375 -1574388 -1707979 -1493102 -1336451 -1131562 -811562 -761562 -761562 -761562

69685 69685 69685 69685

686011 686011 686011 686011

8333 8333 8333 8333

24750 24750 24750 24750

166667 166667 166667 166667

1887425 139371 209056 278741

29822121 1372022 2058033 2744043

2000000 0 0

590454 16667 25000 33333

0 0

0 0

700000 49500 74250 99000

5000000 333333 500000 666667

920799
Robinson Ray (DOA) Robinson Ray (DOA)total from Oct Cardinal Query 850092

-920799
Robinson Ray (DOA) Robinson Ray (DOA)should equal $0 -850092
Robinson Ray (DOA) Robinson Ray (DOA)should equal $0

209056 69685

2058033 686011

25000 8333

74250 24750

500000 166667

139371 69685 209056

1372022 686011 2058033

0

16667 8333 25000

0

SDM Recon Line should = 0 0

49500 24750 74250

333333 166667 500000

8238438


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36

Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll Payroll

COVA Overtime

10

Employees Role











Consultant Role









Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 480 480 480 480 480 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2400




















Employees Role










Consultants Role









Tests 1 2 3 4 Testers 1 2 3 4 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 10000 10000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000


















Employees Role










Consultants

Ned ONeill Program Manager 0 0 0 0 0 0 0 0 0 0 0 0 35929
Robinson Ray (DOA) Robinson Ray (DOA)June 17 33509
Robinson Ray (DOA) Robinson Ray (DOA)July 17 38349
Robinson Ray (DOA) Robinson Ray (DOA)Aug 17 25690
Robinson Ray (DOA) Robinson Ray (DOA)Feb 18 40583
Robinson Ray (DOA) Robinson Ray (DOA)March 2018 74464
Robinson Ray (DOA) Robinson Ray (DOA)April amp May 2018 0
Robinson Ray (DOA) Robinson Ray (DOA)All Consultants July 2018 0 0 0 0 0 0 0 0 0 0 470240

Ray Robinson PMO Lead 0 0 0 0 0 0 0 0 0 0 12194
Robinson Ray (DOA) Robinson Ray (DOA)May 17 0 9531
Robinson Ray (DOA) Robinson Ray (DOA)April amp May 2018 0 10008
Robinson Ray (DOA) Robinson Ray (DOA)June 2018 12363 0 0 0 0 0 0 0 0 0 0 170708

Sharon ArtisPam Watson Payroll Analyst 0 0 0 0 84831
Robinson Ray (DOA) Robinson Ray (DOA)Artis Oct amp Sept 16 ($5913216 amp $2569922) 25597
Robinson Ray (DOA) Robinson Ray (DOA)May 17 55573
Robinson Ray (DOA) Robinson Ray (DOA)Oct 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 374264

Anne Looney TA Lead 0 0 0 0 26048
Robinson Ray (DOA) Robinson Ray (DOA)Oct 2016 0 0 0 0 0 11802

James BlantonRon Gotshall TA Analyst 0 0 0 0 0 0 0 0 0 0 5891
Robinson Ray (DOA) Robinson Ray (DOA)August 17 0 0 0 3795
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall Dec 17 4698
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall Jan 18 6018
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall Feb 18 7083
Robinson Ray (DOA) Robinson Ray (DOA)June 2018 6408 5481 6387

Robinson Ray (DOA) Robinson Ray (DOA)Artis Oct amp Sept 16 ($5913216 amp $2569922)
Robinson Ray (DOA) Robinson Ray (DOA)Feb 17
Robinson Ray (DOA) Robinson Ray (DOA)May 17
Robinson Ray (DOA) Robinson Ray (DOA)June 17
Robinson Ray (DOA) Robinson Ray (DOA)April amp May 17 COA Lead 0 0 0 0 0 0 0 0 0 0 0 0 14740
Robinson Ray (DOA) Robinson Ray (DOA)Hynes - June 17 14051
Robinson Ray (DOA) Robinson Ray (DOA)Linette Jones July 17 2331
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall Aug 17 0 0 4554
Robinson Ray (DOA) Robinson Ray (DOA)Fralin Nov 17 14349
Robinson Ray (DOA) Robinson Ray (DOA)Lake Dec 17 17907
Robinson Ray (DOA) Robinson Ray (DOA)Lake Jan 18 17159
Robinson Ray (DOA) Robinson Ray (DOA)Lake Feb 18 17386

Wilson Parks Conv Analyst 0 0 0 0 0 0 0 0 1337

Saadya Russell Conversion Lead 0 0 0 0 0 16261
Robinson Ray (DOA) Robinson Ray (DOA)Russell Nov 2016
Robinson Ray (DOA) Robinson Ray (DOA)July 17
Robinson Ray (DOA) Robinson Ray (DOA)Russell Dec 2016
Robinson Ray (DOA) Robinson Ray (DOA)Aug 17
Robinson Ray (DOA) Robinson Ray (DOA)April 17 0 40472

Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 771
Robinson Ray (DOA) Robinson Ray (DOA)Parkhurst Aug 17 9656
Robinson Ray (DOA) Robinson Ray (DOA)Sept 17 Gotshall $580047 amp Parkhurst $385600 14990
Robinson Ray (DOA) Robinson Ray (DOA)Fralin $505057 Parkhurst $404880 Gotshall $589082 Oct 17 8879
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall $531258 amp Parkhurst $356680 Nov 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34297

Allison Patrick SPO Liaison 0 0 0 0 0 0 0 0 0 0 0 0 15511

Sridhar Kamatala BatchInterface 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25535

Steve WeastParkhurst Tech Support 0 0 0 0 16033
Robinson Ray (DOA) Robinson Ray (DOA)Hynes - June 17
Robinson Ray (DOA) Robinson Ray (DOA)April 17 14345
Robinson Ray (DOA) Robinson Ray (DOA)August 17
Robinson Ray (DOA) Robinson Ray (DOA)Linette Jones July 17
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall Aug 17
Robinson Ray (DOA) Robinson Ray (DOA)March 2018
Robinson Ray (DOA) Robinson Ray (DOA)April amp May 17
Robinson Ray (DOA) Robinson Ray (DOA)Fralin Nov 17
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall Dec 17
Robinson Ray (DOA) Robinson Ray (DOA)Parkhurst Aug 17
Robinson Ray (DOA) Robinson Ray (DOA)July 17 0 18564
Robinson Ray (DOA) Robinson Ray (DOA)Parkhurst Feb 18 4049

M DaughtryJolene Christensen CM Lead 0 0 0 0 0 0 0 0 0 0 40824
Robinson Ray (DOA) Robinson Ray (DOA)Jolene April amp May 17 0 28384

Angela GrayZampolin Trainer 0 0 0 0 0 0 0 0 0 0 21038
Robinson Ray (DOA) Robinson Ray (DOA)Jenna Hynes May 17 0 0 0 0 0 0 0 0 0 0 2546

Stuart Handlan Trainer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4499
Robinson Ray (DOA) Robinson Ray (DOA)Fralin Sept 17 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4499

Andrea Garrison Trainer 0 0 0 0 0 0 0 20880
Robinson Ray (DOA) Robinson Ray (DOA)Feb 17 0 92960
Robinson Ray (DOA) Robinson Ray (DOA)April amp May 2018 0 0 0 0 0 0 0 0 0 0 0 0 0 464029

Robyn Maitland Trainer 0 0 0 0 0 0 16514
Robinson Ray (DOA) Robinson Ray (DOA)Lake Dec 17
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall Jan 18
Robinson Ray (DOA) Robinson Ray (DOA)Sept 17 Gotshall $580047 amp Parkhurst $385600
Robinson Ray (DOA) Robinson Ray (DOA)Jenna Hynes May 17
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall Feb 18
Robinson Ray (DOA) Robinson Ray (DOA)Lake Jan 18
Robinson Ray (DOA) Robinson Ray (DOA)Fralin $505057 Parkhurst $404880 Gotshall $589082 Oct 17
Robinson Ray (DOA) Robinson Ray (DOA)Lake Feb 18
Robinson Ray (DOA) Robinson Ray (DOA)All Consultants July 2018
Robinson Ray (DOA) Robinson Ray (DOA)Gotshall $531258 amp Parkhurst $356680 Nov 17

Helen Ardman Trainer 0 0 0 0 0 0 0 0 0 0 0 0 16994


Frank OverbeyMohan Sareddy CM Analyst 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14784
Robinson Ray (DOA) Robinson Ray (DOA)Sareddy Feb 18 17976

Ajit SawantFralin Liaison 0 0 0 0 0 0 15538
Robinson Ray (DOA) Robinson Ray (DOA)Aug 17 0 14280
Robinson Ray (DOA) Robinson Ray (DOA)Sareddy Oct 17 14280
Robinson Ray (DOA) Robinson Ray (DOA)Sareddy Nov 17 3840
Robinson Ray (DOA) Robinson Ray (DOA)Fralin Dec 17 4969
Robinson Ray (DOA) Robinson Ray (DOA)March 2018 0 0 0 0 0 0 0 0 0 0 0 0 0 0 328518

Heather Simpkins Liaison 0 0 0 0 28924
Robinson Ray (DOA) Robinson Ray (DOA)Simpkins Oct 2016
Robinson Ray (DOA) Robinson Ray (DOA)Simpkins Nov 2016 38316

Pat Reddington Liaison 0 0 0 0 10498
Robinson Ray (DOA) Robinson Ray (DOA)Nov 2016 0 0 11136

Janeen Wall Liaison 0 0 0 0 16966
Robinson Ray (DOA) Robinson Ray (DOA)Oct16 17346

Minoj Ravapati Absence Analyst 0 0 0 0 32042
Robinson Ray (DOA) Robinson Ray (DOA)Manoj Kumar Oct 16 25634
Robinson Ray (DOA) Robinson Ray (DOA)Ravipati Nov 2016 25634

Employee Costs 0 94694
Robinson Ray (DOA) Robinson Ray (DOA)Sept DOA salaries
Robinson Ray (DOA) Robinson Ray (DOA)DOA SalariesNOV $3933610OCT $5549971SEP ($3223550)
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 111616 $4065615 plus 12116 $4201875 plus McCabe mileage $7614 + VonMoll mileage $050
Robinson Ray (DOA) Robinson Ray (DOA)Fralin Sept 17
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 126 $4221559 plus 1230 $3824155 plus williams mileage $2938
Robinson Ray (DOA) Robinson Ray (DOA)DOA Salaries $8010049 ($4074220 + $3935829) plus travel $1454
Robinson Ray (DOA) Robinson Ray (DOA)Parkhurst Feb 18
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 21617 $3938292 plus 3117 $3943970
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 316 $4032301 331 $3955727 plus travel McCabe Porter VonMolll $16101 total
Robinson Ray (DOA) Robinson Ray (DOA)414 $3940290 plus 51 $3937831 plus mileage $11896
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 516 $3940289 61 $4616956 plus travel $9435
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries $3882561 plus $12780 travel exps 126263 85137
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 816 $4255566 91 $4252913 plus mileage $5183 85250
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 1016 $8508483 plus employee certification $375 plus mileage $4707 85447
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries $8892877 plus travel $18122 76603
Robinson Ray (DOA) Robinson Ray (DOA)116 $3773888 amp 21 $3886404 76257
Robinson Ray (DOA) Robinson Ray (DOA)DOA Salaries $3851827 (316) $3770678 (330) plus mileage $37934 76551
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 41618 $3814035 plus 5118 $3825001 plus mileage $16110 75800
Robinson Ray (DOA) Robinson Ray (DOA)DOA employees June 18 113530 75814
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries $3792332 $3789112 plus mileage $981 -75814 0 0 0 0 0 0 0 0 0 0 1727606 0 COVA Staff


Total COVA Resource Costs 0 94694 62642 82752 295829 218391 260185 327749 328372 331492 657994 126263 498978 403128 457328 391149 462955 386555 371049 441184 451117 456674 748772 113530 280157 144365 94918 88251 97841 73582 67395 94900 99544 99544 99544 0 9083557

COVA Support



IV and V 0 0 0 0 0 17400
Robinson Ray (DOA) Robinson Ray (DOA)IVampV Intial Plng $1421000 plus Proj Plan Review $319000 0 3103
Robinson Ray (DOA) Robinson Ray (DOA)IVampV review 1 0 0 0 0 11890
Robinson Ray (DOA) Robinson Ray (DOA)IVV progress report 2 0 0 0 0 0 0 0 11890
Robinson Ray (DOA) Robinson Ray (DOA)IVampV 0 0 0 0 0 0 0 0 0 0 56173

VITA Charges 0 2508
Robinson Ray (DOA) Robinson Ray (DOA)Sept VITA bill
Robinson Ray (DOA) Robinson Ray (DOA)Sareddy Oct 17
Robinson Ray (DOA) Robinson Ray (DOA)Sept VITA Bill $313145Oct VITA Bill $287 4186
Robinson Ray (DOA) Robinson Ray (DOA)VITA charges 8973
Robinson Ray (DOA) Robinson Ray (DOA)VITA comprehensive Nov 16 $844154 plus 111 $53138 7180
Robinson Ray (DOA) Robinson Ray (DOA)VITA charges 12116 467
Robinson Ray (DOA) Robinson Ray (DOA)VITA services Jan 2017 7091
Robinson Ray (DOA) Robinson Ray (DOA)VITA comprehensive charge 8224
Robinson Ray (DOA) Robinson Ray (DOA)VITA comprehensive charge 17168 17804
Robinson Ray (DOA) Robinson Ray (DOA)VITA Comp charge 246
Robinson Ray (DOA) Robinson Ray (DOA)VITA Comp charge 71 18832
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp charges 19116
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp charges 91 19658
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp 101 $1936792 111 $29050 18363
Robinson Ray (DOA) Robinson Ray (DOA)VITA Comp 3118 20545
Robinson Ray (DOA) Robinson Ray (DOA)VITA charges $2049679 plus eVA fees $1574 plus software $3221 40384
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp charge $4027500 plus eVA fee $108 0 17588 16106
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp charge 3042
Robinson Ray (DOA) Robinson Ray (DOA)VITA Bill 5000 5000 5000 0 378423 62970 VITA Charges

Facilities 0 3705
Robinson Ray (DOA) Robinson Ray (DOA)Sareddy Nov 17
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 816 $4255566 91 $4252913 plus mileage $5183
Robinson Ray (DOA) Robinson Ray (DOA)Oct Paragon Lease 6166
Robinson Ray (DOA) Robinson Ray (DOA)Nov Paragon Lease 6021
Robinson Ray (DOA) Robinson Ray (DOA)paragon lease 12116 10716
Robinson Ray (DOA) Robinson Ray (DOA)paragon lease Feb 2017 11941
Robinson Ray (DOA) Robinson Ray (DOA)Paragon lease 31 13124
Robinson Ray (DOA) Robinson Ray (DOA)Paraon Lease $2779390 plus Role Mapping facility rental $169000 29071
Robinson Ray (DOA) Robinson Ray (DOA)Paragon lease $2832060 plus facility rental $75000 28237
Robinson Ray (DOA) Robinson Ray (DOA)paragon lease $2768097 51 plus facilities rental $750 27296
Robinson Ray (DOA) Robinson Ray (DOA)Paragon Lease 0 0 4664
Robinson Ray (DOA) Robinson Ray (DOA)partial paragon lease 4359
Robinson Ray (DOA) Robinson Ray (DOA)Partial paragon lease 4505
Robinson Ray (DOA) Robinson Ray (DOA)partial Paragon lease 3390

Telecommunications 0 865
Robinson Ray (DOA) Robinson Ray (DOA)july telephone charges
Robinson Ray (DOA) Robinson Ray (DOA)Fralin Dec 17
Robinson Ray (DOA) Robinson Ray (DOA)IVampV Intial Plng $1421000 plus Proj Plan Review $319000
Robinson Ray (DOA) Robinson Ray (DOA)VITA comprehensive Nov 16 $844154 plus 111 $53138
Robinson Ray (DOA) Robinson Ray (DOA)Nov Paragon Lease
Robinson Ray (DOA) Robinson Ray (DOA)Sareddy Feb 18
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 1016 $8508483 plus employee certification $375 plus mileage $4707
Robinson Ray (DOA) Robinson Ray (DOA)paragon lease 12116 0 1388
Robinson Ray (DOA) Robinson Ray (DOA)Sept Telephone charges 1921
Robinson Ray (DOA) Robinson Ray (DOA)VITA telephone 101 1952
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone charges 8390
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone charges Dec 2016 $236023 plus Jan 2017 $602952 2359
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill 112017 2774
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill 41 $333771 amp 51 $599978 0 0 0 0 12566
Robinson Ray (DOA) Robinson Ray (DOA)VITA Telecom 91$651127 amp 101 $633337 6108
Robinson Ray (DOA) Robinson Ray (DOA)11117 VITA phone bill 12691
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill 1118 $633914 2118 $635164 6448
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone April $222600 May $1028200 0 10482
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill June amp July 4102
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill 17661 0 2035

Training 0 0 0 65600
Robinson Ray (DOA) Robinson Ray (DOA)Oracle Payroll tng $32800 plus Oracle Ptools tng $32800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 65600 0 Other Services

Other (including Trainers UAT Xerox) 0 30
Robinson Ray (DOA) Robinson Ray (DOA)prof memebership req $30
Robinson Ray (DOA) Robinson Ray (DOA)IVampV review 1
Robinson Ray (DOA) Robinson Ray (DOA)VITA services Jan 2017
Robinson Ray (DOA) Robinson Ray (DOA)VITA telephone 101
Robinson Ray (DOA) Robinson Ray (DOA)Oracle Payroll tng $32800 plus Oracle Ptools tng $32800 1111
Robinson Ray (DOA) Robinson Ray (DOA)Aug Telephone bill $85179Check Point Learning $259
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries $8892877 plus travel $18122
Robinson Ray (DOA) Robinson Ray (DOA)VITA comprehensive charge
Robinson Ray (DOA) Robinson Ray (DOA)paragon lease Feb 2017
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone charges
Robinson Ray (DOA) Robinson Ray (DOA)116 $3773888 amp 21 $3886404
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone charges Dec 2016 $236023 plus Jan 2017 $602952
Robinson Ray (DOA) Robinson Ray (DOA)DOA Salaries $3851827 (316) $3770678 (330) plus mileage $37934
Robinson Ray (DOA) Robinson Ray (DOA)VITA Comp charge
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries 41618 $3814035 plus 5118 $3825001 plus mileage $16110
Robinson Ray (DOA) Robinson Ray (DOA)IVV progress report 2
Robinson Ray (DOA) Robinson Ray (DOA)Paragon Lease 0 0 0 0 30
Robinson Ray (DOA) Robinson Ray (DOA)Employee development
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill 41 $333771 amp 51 $599978
Robinson Ray (DOA) Robinson Ray (DOA)DOA employees June 18
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp charges
Robinson Ray (DOA) Robinson Ray (DOA)CCWA August facility rental 1767
Robinson Ray (DOA) Robinson Ray (DOA)facility rental $750 eVA fees $71634 software $30072 6419
Robinson Ray (DOA) Robinson Ray (DOA)Facility rental $5350 plus supplies $106860 159
Robinson Ray (DOA) Robinson Ray (DOA)office supplies 1
Robinson Ray (DOA) Robinson Ray (DOA)eVA fees 078 25816
Robinson Ray (DOA) Robinson Ray (DOA)DHRM PMIS System Updates $24k plus other charge $181618 5536
Robinson Ray (DOA) Robinson Ray (DOA)Printing $187600 plus Employee Prof Certifications $366000 214
Robinson Ray (DOA) Robinson Ray (DOA)Employee Certification $60 Eva Fees $2109 Supplies $13293 0 2702
Robinson Ray (DOA) Robinson Ray (DOA)Employee prof certification 3143
Robinson Ray (DOA) Robinson Ray (DOA)supplies $294268 plus employee certification $20000 0 1165
Robinson Ray (DOA) Robinson Ray (DOA)Employee prof cert 0 0 0 0 0 0 0 14000 712 0 0 65684 15877 Other Services

Contingency 0 0 0 0 0 0 0 0 0 0 0
Oneill Edmond (DOA) Oneill Edmond (DOA)62717 -moved 500k to COVA Resources line 500K to ACCN line for CRs 0
Oneill Edmond (DOA) Oneill Edmond (DOA)Moved $1m to ACCN line for CRs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200000 0 200000 200000 Contingency Need to eat 277k for overage on Planning initiative


System




Accenture 0 850000
Robinson Ray (DOA) Robinson Ray (DOA)SOW 12 Dels 1-5
Robinson Ray (DOA) Robinson Ray (DOA)DOA salaries $3792332 $3789112 plus mileage $981
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp 101 $1936792 111 $29050
Robinson Ray (DOA) Robinson Ray (DOA)SOW 12 Dels 6 through 9
Robinson Ray (DOA) Robinson Ray (DOA)CCWA August facility rental
Oneill Edmond (DOA) Oneill Edmond (DOA)Moved $1m to ACCN line for CRs 690000
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 16 18 amp 19
Robinson Ray (DOA) Robinson Ray (DOA)Paraon Lease $2779390 plus Role Mapping facility rental $169000
Robinson Ray (DOA) Robinson Ray (DOA)VITA Telecom 91$651127 amp 101 $633337
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 20 22 23 amp 24
Robinson Ray (DOA) Robinson Ray (DOA)VITA Comp 3118
Robinson Ray (DOA) Robinson Ray (DOA)Paragon lease $2832060 plus facility rental $75000
Robinson Ray (DOA) Robinson Ray (DOA)11117 VITA phone bill
Robinson Ray (DOA) Robinson Ray (DOA)VITA charges $2049679 plus eVA fees $1574 plus software $3221
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone bill 1118 $633914 2118 $635164
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp charge $4027500 plus eVA fee $108
Robinson Ray (DOA) Robinson Ray (DOA)paragon lease $2768097 51 plus facilities rental $750
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 dels 27 31 34 35 37 amp 129
Robinson Ray (DOA) Robinson Ray (DOA)Employee Certification $60 Eva Fees $2109 Supplies $13293 895000
Robinson Ray (DOA) Robinson Ray (DOA)SOW 12 Dels 130 40 42 43 amp 44 SOW 11 Del 63 $50k adjustment from SDM- went back to April and adjusted there (see June Cardinal Query)
Robinson Ray (DOA) Robinson Ray (DOA)Paragon rent
Robinson Ray (DOA) Robinson Ray (DOA)VITA phone April $222600 May $1028200 1590000
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 29303845475052 131
Robinson Ray (DOA) Robinson Ray (DOA)SOW 12 Dels 39 48 51 55 57 58 59 132 amp 134
Robinson Ray (DOA) Robinson Ray (DOA)supplies $294268 plus employee certification $20000 325500
Robinson Ray (DOA) Robinson Ray (DOA)VITA comp charge
Robinson Ray (DOA) Robinson Ray (DOA)Employee prof cert 854000
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 127 144 145 152 33 60 60 69 75 amp 78
Robinson Ray (DOA) Robinson Ray (DOA)Partial paragon lease
Robinson Ray (DOA) Robinson Ray (DOA)VITA Bill
Robinson Ray (DOA) Robinson Ray (DOA)partial Paragon lease
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 36 49 64 65 72 77 83 85 88 139 amp 154
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 41 61 74 76 93 140 147 amp 157
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 94 96 141 148 149 amp 155 1089300
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 79 86 90 98 99 142 150 amp 156 1101280
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 53 68 71 102 amp 143 389500
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 91 105 amp 115 925500
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 dels 1 amp 2 plus SOW12 dels 110 112 151 amp 67 -312000
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Del 82 (138k) plus SOW 14 adjustment (450k) 0 0 0 0 0 0 0 0 0 0 22927494 3900000 Accenture

Total Planned Cost for HW SW Services 0 850000 850000 690000 925000 1150000 740000 814000 590000 1305000 895000 1590000 1600144 325500 550000 854000 1701260 570220 1964300 1110190 659300 1089300 1101280 389500 925500 -312000 0 0 0 0 0 0 0 0 0 0 22927494

Totals

Totals 0 951803 920799 850092 1237743 1405639 1019241 1166273 942494 1672404 1594478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524272 1256688 -114241 112579 90637 107645 82005 76184 101579 128544 115256 314544 0 33581936 5374820


Major Budget Category Major Budget Category FY17 FY18 FY19 Total

Internal Staff Resources 0 94694 62642 82752 80487 80115 78823 80041 78900 85667 38953 126263 85137 85250 85507 85447 89110 76603 76257 76604 76551 75800 37739 113530 75814 -75814 0 0 0 0 0 0 0 0 0 0 1852871 Internal Staff Resources 763074 976267 113530 1852871

Contractual Services 0 850000 850000 690000 1140342 1288276 921363 1061707 839472 1550825 1514040 1590000 2013985 643378 921821 1159702 2075105 880173 2259092 1474770 1033866 1470174 1812314 389500 1129843 -91821 94918 88251 97841 73582 67395 94900 99544 99544 99544 0 30283445 Services 10706025 17334379 2243041 30283445

Software and Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Software Tools 0 0 0 0

VITA Comprehensive 0 250825 341845 418636 897292 718024 46661 709054 822428 1716774 1780391 24600 2389296 1883168 1911575 1965842 1836290 1916932 1926068 1975151 1921656 2054474 4038354 000 1758839 1610610 000 238672 310580 304156 326290 247842 500000 500000 500000 0 378423 Hardware 77019 238434 62970 378423

Telecommunications 0 865 0 1388 1921 1952 8390 2359 2774 3007 9337 0 0 0 0 12566 0 12845 6108 12691 6448 6475 12508 0 10482 4102 17661 0 2035 1022 1021 810 3000 3000 3000 0 147767 Telecommunications 31993 69642 46132 147767

IV and V 0 0 0 0 0 17400 0 3103 0 0 0 0 11890 0 0 0 0 0 0 0 11890 0 0 0 0 11890 0 0 0 0 0 0 0 0 0 0 56173 IV and V 20503 23780 11890 56173

Other 0 3735 4738 71766 6021 10716 10199 11971 13124 15737 14343 27845 30230 29266 33795 27011 26879 53637 35020 29285 28237 31132 30439 21241 22961 21297 0 0 4664 4359 4505 3390 21000 7712
Robinson Ray (DOA) Robinson Ray (DOA)101617 inserted to balance out $43M 7000 0
Robinson Ray (DOA) Robinson Ray (DOA)101617 inserted to balance out $43M 663256 Other 162351 382775 118130 663256

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200000 0 200000 Contingency 0 0 200000 200000

Total Major Budget Category 0 951803 920799 850092 1237743 1405639 1019241 1166273 942494 1672404 1594478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524272 1256688 -114241 112579 90637 107645 82005 76184 101579 128544 115256 314544 0 33581936 Total Major Budget Category 11760966 19025278 2795693 33581936

0

Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Dels 53 68 71 102 amp 143
Robinson Ray (DOA) Robinson Ray (DOA)SOW 14 dels 1 amp 2 plus SOW12 dels 110 112 151 amp 67
Robinson Ray (DOA) Robinson Ray (DOA)SOW12 Del 82 (138k) plus SOW 14 adjustment (450k)


Contractual Services 0 850000 1700000 2390000 3530342 4818618 5739981 6801688 7641160 9191985 10706025 12296025 14310011 14953388 15875209 17034912 19110016 19990189 22249281 23724051 24757917 26228091 28040404 28429904 29559747 29467926 29562844 29651095 29748936 29822518 29889913 29984813 30084357 30183901 30283445 30283445 30283445




IV and V 0 0 0 0 0 17400 17400 20503 20503 20503 20503 20503 32393 32393 32393 32393 32393 32393 32393 32393 44283 44283 44283 44283 44283 56173 56173 56173 56173 56173 56173 56173 56173 56173 56173 56173 56173

Other 0 3735 8473 80239 86260 96976 107176 119147 132271 148008 162351 190196 220425 249691 283487 310497 337376 391014 426034 455318 483556 514688 545127 566368 589329 610626 610626 610626 615289 619648 624154 627544 648544 656256 663256 663256 663256

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200000 200000 200000

0



Robinson Ray (DOA) Robinson Ray (DOA)101617 inserted to balance out $43M
rayrobinson rayrobinsonshould match grand total from cardinal query Major Budget Category






IV and V 0 0 0 0 0 17400 0 3103 0 0 0 0 11890 0 0 0 0 0 0 0 11890 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 44283

Other 0 3735 4738 71766 6021 10716 10199 11971 13124 15737 14343 27845 30230 29266 33795 27011 26879 53637 35020 29285 28237 31132 30439 21240 22951 9000 9000 9000 9000 9000 9000 9000 9000 7712 7000 0 669030

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200000 0 0








IV and V 0 0 0 0 0 17400 17400 20503 20503 20503 20503 20503 32393 32393 32393 32393 32393 32393 32393 32393 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283

Other 0 3735 8473 80239 86260 96976 107176 119147 132271 148008 162351 190196 220425 249691 283487 310497 337376 391014 426034 455318 483556 514688 545127 566367 589318 598318 607318 616318 625318 634318 643318 652318 661318 669030 676030 676030 676030

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0


850092 1237743 1405639 1019241 1166273 992494 1672404 1544478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524271 125668807 -114241 112579 90637 107645 82005 76184 101579

SDM Recon Line -0
rayrobinson rayrobinsonshould match grand total from cardinal query 0

VARIANCE



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 450000 -451365 -455991 -467284 -468987 -494949 -527098 -531742 -531742 -531742 -531742 -531742 -531742

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11106 6106 3493 1599 -360 -2097 -4619 -4619 -4619 -4619 -4619 -4619


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890 11890 11890 11890 11890 11890 11890 11890 11890 11890 11890 11890

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 11 12308 3308 -5692 -10029 -14670 -19164 -24774 -12774 -12774 -12774 -12774 -12774

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Cumulative Totals - Major Budget 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 113531 639355 -301429 -305394 -331301 -340199 -374739 -415099 -430064 -418064 -418064 -418064 -418064 -418064

69685 69685 69685 69685

686011 686011 686011 686011

8333 8333 8333 8333

24750 24750 24750 24750

166667 166667 166667 166667

1887425 139371 209056 278741

29822121 1372022 2058033 2744043

2000000 0 0

590454 16667 25000 33333

0 0

0 0

700000 49500 74250 99000

5000000 333333 500000 666667

920799

-0
Robinson Ray (DOA) Robinson Ray (DOA)should equal $0 0

209056 69685

2058033 686011

25000 8333

74250 24750

500000 166667

139371 69685 209056

1372022 686011 2058033

0

16667 8333 25000

0


49500 24750 74250

333333 166667 500000

5374820

May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 TOTALS

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

COVA Overtime

10

Employees Role

Stacy McCracken Business Manager emp 0 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 120 0 0 3600

Kim White Application Lead emp 0 173 173 173 173 173 173 173 173 173 173 173 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 0 0 5519

Laura Swecker HR Lead emp 0 173 173 173 173 173 173 173 173 173 173 173 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 0 0 5519

DHRM - HR Analyst HR Analyst emp 0 173 173 173 173 173 173 173 173 173 173 173 190 190 190 190 190 190 190 190 190 190 80 0 0 0 0 0 0 0 0 0 0 3886

Lora George Payroll Benefits Lead emp 0 173 173 173 173 173 173 173 173 173 173 173 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 0 0 5519

Rob Ramey Benefits Analyst emp 0 173 173 173 173 173 173 173 173 173 173 173 190 190 190 190 190 190 190 190 190 190 80 0 0 0 0 0 0 0 0 0 0 3886

Jean Turlington Payroll Analyst emp 0 173 173 173 173 173 173 173 173 173 173 173 190 190 190 190 190 190 190 190 190 190 80 0 0 0 0 0 0 0 0 0 0 3886

DHRM - Ben Analyst Benefits Analyst emp 0 173 173 173 173 173 173 173 173 173 173 173 190 190 190 190 190 190 190 190 190 190 80 80 80 80 80 80 80 80 80 0 0 4526

LaTanya Foreman Security Lead emp 0 0 0 0 40 40 0 0 40 40 40 0 0 0 0 0 0 0 40 40 40 40 40 0 0 0 0 40 40 0 0 0 0 480

Lance Kaeberle Interface Lead emp 0 173 173 173 173 173 173 173 173 173 173 173 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 190 0 0 5519

Pam Tauer CTO emp 0 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 0 0 300

John Willard Technical Manager emp 0 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 40 0 0 1200

Hema Krishnakumar Developer emp 0 0 0 80 80 80 80 173 173 173 173 173 190 190 190 190 190 190 190 190 190 190 80 0 0 0 0 0 0 0 0 0 0 3165

Employee - Total Hours Employee - Total Hours 0 1554 1554 1634 1674 1674 1634 1727 1767 1767 1767 1727 1882 1882 1882 1882 1882 1882 1922 1922 1922 1922 1371 1011 1011 1011 1011 1051 1051 1011 1011 0 0 47004

Consultant Role

Ned ONeill Project Director cc 0 90 90 90 90 90 90 90 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 0 0 4678

Ray Robinson PMO Lead cc 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 4800

TBD - Zampolin HR Analyst cc 0 160 160 160 160 160 160 160 160 160 170 160 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 0 0 5114

TBD Payroll Lead cc 0 0 80 160 160 160 160 160 160 160 170 160 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 0 0 4874

TBD TA Lead cc 0 0 0 80 160 160 160 160 160 160 170 160 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 0 0 4714

Ron Gotshall TA Analyst cc 0 0 0 80 160 160 160 160 160 160 170 160 176 176 176 176 176 176 176 176 176 176 80 80 80 80 80 80 80 0 0 0 0 3690

Allison Patrick Benefits Analyst cc 0 160 160 160 160 160 160 160 160 160 170 160 176 176 176 176 176 176 176 176 176 176 80 80 80 80 80 80 80 0 0 0 0 4090

Tony Spears Conversion lead cc 0 160 160 160 160 160 160 160 160 160 170 160 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 80 0 0 5018

Pam Watson Conversion Analyst cc 0 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 96 0 0 2880

Janeen Wall Conversion Analyst cc 0 160 160 160 1260 160 160 160 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 5910

Sridhar Kamatala InterfaceConvBatch cc 0 0 0 0 0 0 0 80 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 80 0 0 3690

Saadya Russell Conversion Designer cc 0 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1440

Liz Lake COAFin Integration Lead cc 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 0 0 0 0 3200

Saadya Russell Tester SME cc 0 0 0 0 0 0 0 0 0 0 160 160 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 0 0 3664

Tester 1 Tester cc 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 2560

Tester 2 Tester cc 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 2560

Tester 3 Tester cc 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 2560

Tester 4 Tester cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 0 0 0 0 0 0 0 0 0 0 0 0 0 960

Rogers Brewbaker Technical SME cc 0 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 0 0 2400

Jolene Christensen Change Manager cc 0 120 120 120 120 120 120 120 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 4530

TBD AGR Lead cc 0 80 160 160 160 160 160 160 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 4730

Dan Walsh Agency Liaison 1 cc 0 0 0 160 160 160 160 160 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 4490

TBD Agency Liaison 2 cc 0 0 0 160 160 160 160 160 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 4490




TBD Training Lead cc 0 0 0 0 0 0 0 0 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 3690

Karen Gholson Trainer 1 cc 0 0 0 0 0 0 0 0 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 3690

Angela Ward Trainer 2 cc 0 0 0 0 0 0 0 0 120 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 3650

TBD Trainer 3 cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 2080

TBD Trainer 4 cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 2080

TBD Trainer 5 cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 2080

TBD Benefits TLC Analyst cc 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 0 0 0 0 3200


TBD Communications Lead cc 0 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 160 160 160 160 160 160 160 160 160 0 0 3120

LaShawn Hunter Communications Analyst cc 0 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 80 0 0 0 2320

Consultant - Total Hours 0 1586 1746 3186 4526 3426 3426 3506 4152 4192 4372 4672 4784 4784 4944 4944 4944 4944 5424 5424 5264 5264 5152 4832 4832 4832 4832 4352 4352 4192 3776 0 0 130662

Total Employee and Consultant Hours 0 3140 3300 4820 6200 5100 5060 5233 5919 5959 6139 6399 6666 6666 6826 6826 6826 6826 7346 7346 7186 7186 6523 5843 5843 5843 5843 5403 5403 5203 4787 0 0 177666


Employees Role

Stacy McCracken Business Manager 9664 9664 9954 9954 9954 9954 9954 9954 9954 9954 9954 9954 9954 9954 10253 10253 10253 10253 10253 10253 10253 10253 10253 10253 10253 10253 10560 10560 10560 10560 10560 10560 10560

Kim White Application Lead 9541 9541 9827 9827 9827 9827 9827 9827 9827 9827 9827 9827 9827 9827 10122 10122 10122 10122 10122 10122 10122 10122 10122 10122 10122 10122 10426 10426 10426 10426 10426 10426 10426

Laura Swecker HR Lead 6185 6185 6371 6371 6371 6371 6371 6371 6371 6371 6371 6371 6371 6371 6562 6562 6562 6562 6562 6562 6562 6562 6562 6562 6562 6562 6759 6759 6759 6759 6759 6759 6759

DHRM - HR Analyst HR Analyst 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000

Lora George Payroll Benefits Lead 9273 9273 9551 9551 9551 9551 9551 9551 9551 9551 9551 9551 9551 9551 9838 9838 9838 9838 9838 9838 9838 9838 9838 9838 9838 9838 10133 10133 10133 10133 10133 10133 10133

Rob Ramey Benefits Analyst 4363 4363 4494 4494 4494 4494 4494 4494 4494 4494 4494 4494 4494 4494 4629 4629 4629 4629 4629 4629 4629 4629 4629 4629 4629 4629 4768 4768 4768 4768 4768 4768 4768

Jean Turlington Payroll Analyst 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500 9500

DHRM - Ben Analyst Benefits Analyst 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000

LaTanya Foreman Security Lead 5952 5952 6131 6131 6131 6131 6131 6131 6131 6131 6131 6131 6131 6131 6314 6314 6314 6314 6314 6314 6314 6314 6314 6314 6314 6314 6504 6504 6504 6504 6504 6504 6504

Lance Kaeberle Interface Lead 8728 8728 8990 8990 8990 8990 8990 8990 8990 8990 8990 8990 8990 8990 9260 9260 9260 9260 9260 9260 9260 9260 9260 9260 9260 9260 9537 9537 9537 9537 9537 9537 9537

Pam Tauer CTO 9500 9500 9785 9785 9785 9785 9785 9785 9785 9785 9785 9785 9785 9785 10079 10079 10079 10079 10079 10079 10079 10079 10079 10079 10079 10079 10381 10381 10381 10381 10381 10381 10381

John Willard Technical Manager 7994 7994 8234 8234 8234 8234 8234 8234 8234 8234 8234 8234 8234 8234 8481 8481 8481 8481 8481 8481 8481 8481 8481 8481 8481 8481 8735 8735 8735 8735 8735 8735 8735

Hema Krishnakumar Developer 7500 7500 7725 7725 7725 7725 7725 7725 7725 7725 7725 7725 7725 7725 7957 7957 7957 7957 7957 7957 7957 7957 7957 7957 7957 7957 8195 8195 8195 8195 8195 8195 8195

Consultants Role

Ned ONeill Project Director 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616 18616

Ray Robinson PMO Lead 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359 7359

TBD - Zampolin HR Analyst 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000

TBD Payroll Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000

TBD TA Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000

Ron Gotshall TA Analyst 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000

Allison Patrick Benefits Analyst 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227 9227

Tony Spears Conversion lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000

Pam Watson Conversion Analyst 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034 9034

Janeen Wall Conversion Analyst 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841 10841

Sridhar Kamatala InterfaceConvBatch 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500 14500

Saadya Russell Conversion Designer 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623

Liz Lake COAFin Integration Lead 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300 9300

Saadya Russell Tester SME 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623 16623

Tester 1 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Tester 2 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Tester 3 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Tester 4 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Rogers Brewbaker Technical SME 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285 18285

Jolene Christensen Change Manager 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069 18069

TBD AGR Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000

Dan Walsh Agency Liaison 1 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636 9636

TBD Agency Liaison 2 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000




TBD Training Lead 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500

Karen Gholson Trainer 1 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405 11405

Angela Ward Trainer 2 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000 13000

TBD Trainer 3 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500

TBD Trainer 4 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500

TBD Trainer 5 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500

TBD Benefits TLC Analyst 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000


TBD Communications Lead 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500

LaShawn Hunter Communications Analyst 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926 6926


Employees Role

Stacy McCracken Business Manager 0 11597 11945 11945 11945 11945 11945 11945 11945 11945 11945 11945 11945 11945 12303 12303 12303 12303 12303 12303 12303 12303 12303 12303 12303 12303 12672 12672 12672 12672 12672 0 0 365930

Kim White Application Lead 0 16506 17001 17001 17001 17001 17001 17001 17001 17001 17001 17001 18701 18701 19262 19262 19262 19262 19262 19262 19262 19262 19262 19262 19262 19262 19840 19840 19840 19840 19840 0 0 554267

Laura Swecker HR Lead 0 10700 11021 11021 11021 11021 11021 11021 11021 11021 11021 11021 12123 12123 12487 12487 12487 12487 12487 12487 12487 12487 12487 12487 12487 12487 12861 12861 12861 12861 12861 0 0 359306

DHRM - HR Analyst HR Analyst 0 13840 13840 13840 13840 13840 13840 13840 13840 13840 13840 13840 15224 15224 15224 15224 15224 15224 15224 15224 15224 15224 6400 0 0 0 0 0 0 0 0 0 0 310880

Lora George Payroll Benefits Lead 0 16042 16524 16524 16524 16524 16524 16524 16524 16524 16524 16524 18176 18176 18721 18721 18721 18721 18721 18721 18721 18721 18721 18721 18721 18721 19283 19283 19283 19283 19283 0 0 538698

Rob Ramey Benefits Analyst 0 7548 7774 7774 7774 7774 7774 7774 7774 7774 7774 7774 8552 8552 8808 8808 8808 8808 8808 8808 8808 8808 3703 0 0 0 0 0 0 0 0 0 0 176566

Jean Turlington Payroll Analyst 0 16435 16435 16435 16435 16435 16435 16435 16435 16435 16435 16435 18079 18079 18079 18079 18079 18079 18079 18079 18079 18079 7600 0 0 0 0 0 0 0 0 0 0 369170

DHRM - Ben Analyst Benefits Analyst 0 13840 13840 13840 13840 13840 13840 13840 13840 13840 13840 13840 15224 15224 15224 15224 15224 15224 15224 15224 15224 15224 6400 6400 6400 6400 6400 6400 6400 6400 6400 0 0 362080

LaTanya Foreman Security Lead 0 0 0 0 2452 2452 0 0 2452 2452 2452 0 0 0 0 0 0 0 2526 2526 2526 2526 2526 0 0 0 0 2602 2602 0 0 0 0 30093

Lance Kaeberle Interface Lead 0 15099 15552 15552 15552 15552 15552 15552 15552 15552 15552 15552 17108 17108 17621 17621 17621 17621 17621 17621 17621 17621 17621 17621 17621 17621 18150 18150 18150 18150 18150 0 0 507037

Pam Tauer CTO 0 950 979 979 979 979 979 979 979 979 979 979 979 979 1008 1008 1008 1008 1008 1008 1008 1008 1008 1008 1008 1008 1038 1038 1038 1038 1038 0 0 29977

John Willard Technical Manager 0 3198 3294 3294 3294 3294 3294 3294 3294 3294 3294 3294 3294 3294 3392 3392 3392 3392 3392 3392 3392 3392 3392 3392 3392 3392 3494 3494 3494 3494 3494 0 0 100898

Hema Krishnakumar Developer 0 0 0 6180 6180 6180 6180 13364 13364 13364 13364 13364 14678 14678 15118 15118 15118 15118 15118 15118 15118 15118 6365 0 0 0 0 0 0 0 0 0 0 248204

Employee Total Costs 0 125755 128204 134384 136837 136837 134384 141569 144021 144021 144021 141569 154081 154081 157247 157247 157247 157247 159773 159773 159773 159773 117789 91194 91194 91194 93738 96340 96340 93738 93738 0 0 3953109

Consultants Role

Ned ONeill Project Director 0 16754 16754 16754 16754 16754 16754 16754 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 32764 0 0 870856

Ray Robinson PMO Lead 0 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 11774 0 0 353232

TBD - Zampolin HR Analyst 0 24000 24000 24000 24000 24000 24000 24000 24000 24000 25500 24000 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 0 0 767100

TBD Payroll Lead 0 0 12000 24000 24000 24000 24000 24000 24000 24000 25500 24000 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 0 0 731100

TBD TA Lead 0 0 0 12000 24000 24000 24000 24000 24000 24000 25500 24000 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 0 0 707100

Ron Gotshall TA Analyst 0 0 0 4000 8000 8000 8000 8000 8000 8000 8500 8000 8800 8800 8800 8800 8800 8800 8800 8800 8800 8800 4000 4000 4000 4000 4000 4000 4000 0 0 0 0 184500

Allison Patrick Benefits Analyst 0 14763 14763 14763 14763 14763 14763 14763 14763 14763 15686 14763 16240 16240 16240 16240 16240 16240 16240 16240 16240 16240 7382 7382 7382 7382 7382 7382 7382 0 0 0 0 377384

Tony Spears Conversion lead 0 24000 24000 24000 24000 24000 24000 24000 24000 24000 25500 24000 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 12000 0 0 752700

Pam Watson Conversion Analyst 0 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 8673 0 0 260179

Janeen Wall Conversion Analyst 0 17346 17346 17346 136597 17346 17346 17346 17346 17346 18430 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 17346 0 0 640703

Sridhar Kamatala InterfaceConvBatch 0 0 0 0 0 0 0 11600 23200 23200 24650 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 23200 11600 0 0 535050

Saadya Russell Conversion Designer 0 26597 26597 26597 26597 26597 26597 26597 26597 26597 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 239371

Liz Lake COAFin Integration Lead 0 0 0 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 14880 0 0 0 0 0 0 0 0 0 0 297600

Saadya Russell Tester SME 0 0 0 0 0 0 0 0 0 0 26597 26597 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 29256 0 0 609067

Tester 1 Tester 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 192000

Tester 2 Tester 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 192000

Tester 3 Tester 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 192000

Tester 4 Tester 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 0 0 0 0 0 0 0 72000

Rogers Brewbaker Technical SME 0 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 14628 0 0 438840

Jolene Christensen Change Manager 0 21683 21683 21683 21683 21683 21683 21683 28910 28910 30717 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 28910 0 0 818526

TBD AGR Lead 0 12000 24000 24000 24000 24000 24000 24000 24000 24000 25500 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 0 0 709500

Dan Walsh Agency Liaison 1 0 0 0 15418 15418 15418 15418 15418 15418 15418 16381 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 15418 0 0 432656

TBD Agency Liaison 2 0 0 0 16000 16000 16000 16000 16000 16000 16000 17000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 0 0 449000




TBD Training Lead 0 0 0 0 0 0 0 0 20000 20000 21250 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 461250

Karen Gholson Trainer 1 0 0 0 0 0 0 0 0 18248 18248 19389 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 18248 0 0 420845

Angela Ward Trainer 2 0 0 0 0 0 0 0 0 15600 20800 22100 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 20800 0 0 474500

TBD Trainer 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 260000

TBD Trainer 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 260000

TBD Trainer 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 260000

TBD Benefits TLC Analyst 0 0 0 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 16000 0 0 0 0 0 0 0 0 0 0 320000


TBD Communications Lead 0 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 390000

LaShawn Hunter Communications Analyst 0 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 5541 0 0 0 160683

Consultants Total Costs 0 207759 231759 378056 521307 402056 402056 413656 502342 507542 529459 543542 558078 558078 570078 570078 570078 570078 630078 630078 618078 618078 614420 583540 583540 583540 583540 547540 547540 536158 488617 0 0 15600743

Employee Costs 0 125755 128204 134384 136837 136837 134384 141569 144021 144021 144021 141569 154081 154081 157247 157247 157247 157247 159773 159773 159773 159773 117789 91194 91194 91194 93738 96340 96340 93738 93738 0 0 3953109

Consultant Costs 0 207759 231759 378056 521307 402056 402056 413656 502342 507542 529459 543542 558078 558078 570078 570078 570078 570078 630078 630078 618078 618078 614420 583540 583540 583540 583540 547540 547540 536158 488617 0 0 15600743

Total COVA Resource Costs 0 333514 359963 512441 658144 538893 536441 555225 646362 651562 673480 685110 712158 712158 727325 727325 727325 727325 789851 789851 777851 777851 732208 674734 674734 674734 677278 643880 643880 629896 582356 0 0 19553851

COVA Support

Advisory Services (Research Studies) 0 0 20000 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40000 Other Services

Move to Cloud 0 0 0 0 0 0 0 0 0 0 0 0 0 5000000 0 0 0 0 0 0 0 0 0 5000000 0 0 0 0 0 0 0 0 0 10000000 COV PS Admin included in 10m Other Services

IV and V 0 0 40000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 12000 136000 IV and V

VITA Charges 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 600000 includes current services plus 5k month telecon VITA Charges

Facilities 0 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 37500 0 0 1125000 Facilities

Telecommunications 0 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 0 0 225000 Telecommunications

Training (Psoft Oracle Tech) 0 0 50000 0 0 0 0 0 0 0 50000 0 0 0 0 0 50000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 150000 Other Services

Other (including Trainers Expenses) 0 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 0 0 450000 office supplies xerox team travel meals refreshments facility rental printing Other Services

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8500000 0 0 8500000 Contingency

Total Planned Cost for COVA Support 0 80000 190000 80000 80000 80000 92000 80000 80000 80000 142000 80000 80000 5080000 92000 80000 150000 80000 92000 80000 80000 80000 92000 5080000 80000 80000 92000 80000 80000 80000 8592000 0 12000 21226000

System


Software Tools Okta (410k per year LMS 1m total Psoft 5m) 0 5000 5000000 0 0 0 0 0 0 0 0 5000 500000 410000 1100000 130000 0 0 0 0 0 0 0 5000 500000 422000 1100000 134000 0 0 500000 0 0 9811000 Okta - 410k 422k 15m LMS 5m Oracle PS 11m YR2 YR3 Support GH 264k 5kyr other Software 23498529

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Hardware 3936304

Accenture 0 0 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 500000 0 0 42500000 Accenture 27434833

Total Planned Cost for HW SW Services 0 5000 6500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1505000 2000000 1910000 2600000 1630000 1500000 1500000 1500000 1500000 1500000 1500000 1500000 1505000 2000000 1922000 2600000 1634000 1500000 1500000 1000000 0 0 52311000

Totals

Totals 0 418514 7049963 2092441 2238144 2118893 2128441 2135225 2226362 2231562 2315480 2270110 2792158 7702158 3419325 2437325 2377325 2307325 2381851 2369851 2357851 2357851 2324208 7259734 2754734 2676734 3369278 2357880 2223880 2209896 10174356 0 12000 93090851

Cumulative totals 0 418514 7468477 9560917 11799061 13917954 16046394 18181619 20407981 22639544 24955024 27225134 30017292 37719451 41138775 43576100 45953425 48260750 50642600 53012451 55370301 57728152 60052360 67312094 70066828 72743563 76112840 78470720 80694599 82904496 93078851 93078851 93090851 93090851

Major Budget Category Major Budget Category FY19 FY20 FY21 FY22 Total

Internal Staff Resources 0 125755 128204 134384 136837 136837 134384 141569 144021 144021 144021 141569 154081 154081 157247 157247 157247 157247 159773 159773 159773 159773 117789 91194 91194 91194 93738 96340 96340 93738 93738 0 0 3953109 Internal Staff Resources 125755 1694007 1659452 473894 3953109

Contractual Services 0 207759 1751759 1878056 2021307 1902056 1902056 1913656 2002342 2007542 2029459 2043542 2058078 7058078 2070078 2070078 2090078 2070078 2130078 2130078 2118078 2118078 2114420 7083540 2083540 2083540 2083540 2047540 2047540 2036158 988617 0 0 68140743 Services 207759 28567930 30161660 9203394 68140743

Software and Tools 0 5000 5000000 0 0 0 0 0 0 0 0 5000 500000 410000 1100000 130000 0 0 0 0 0 0 0 5000 500000 422000 1100000 134000 0 0 500000 0 0 9811000 Software Tools 5000 5915000 2157000 1734000 9811000

VITA Comprehensive 0 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 0 0 225000 Hardware 7500 90000 90000 37500 225000

Telecommunications 0 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 0 0 225000 Telecommunications 7500 90000 90000 37500 225000

IV and V 0 0 40000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 12000 136000 IV and V 0 64000 36000 36000 136000

Other 0 52500 102500 52500 52500 52500 52500 52500 52500 52500 102500 52500 52500 52500 52500 52500 102500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 0 0 1725000 Other 52500 730000 680000 262500 1725000

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8500000 0 0 8500000 Contingency 0 0 0 8500000 8500000

Total Major Budget Category 0 406014 7037463 2079941 2225644 2106393 2115941 2122725 2213862 2219062 2302980 2257610 2779658 7689658 3406825 2424825 2364825 2294825 2369351 2357351 2345351 2345351 2311708 7247234 2742234 2664234 3356778 2345380 2211380 2197396 10161856 0 12000 92715851 -185806703 Total Major Budget Category 406014 37150937 34874112 20284789 92715851

-12500


Internal Staff Resources 0 125755 253959 388344 525180 662017 796401 937970 1081990 1226011 1370032 1511601 1665681 1819762 1977009 2134256 2291503 2448750 2608523 2768296 2928069 3087842 3205631 3296825 3388020 3479214 3572952 3669292 3765632 3859370 3953109 3953109 3953109 3953109

Contractual Services 0 207759 1959517 3837574 5858881 7760937 9662993 11576649 13578991 15586533 17615992 19659534 21717611 28775689 30845766 32915844 35005922 37075999 39206077 41336154 43454232 45572310 47686729 54770269 56853809 58937348 61020888 63068428 65115967 67152126 68140743 68140743 68140743 68140743

Software and Tools 0 5000 5005000 5005000 5005000 5005000 5005000 5005000 5005000 5005000 5005000 5010000 5510000 5920000 7020000 7150000 7150000 7150000 7150000 7150000 7150000 7150000 7150000 7155000 7655000 8077000 9177000 9311000 9311000 9311000 9811000 9811000 9811000 9811000

VITA Comprehensive 0 7500 15000 22500 30000 37500 45000 52500 60000 67500 75000 82500 90000 97500 105000 112500 120000 127500 135000 142500 150000 157500 165000 172500 180000 187500 195000 202500 210000 217500 225000 225000 225000 225000

Telecommunications 0 7500 15000 22500 30000 37500 45000 52500 60000 67500 75000 82500 90000 97500 105000 112500 120000 127500 135000 142500 150000 157500 165000 172500 180000 187500 195000 202500 210000 217500 225000 225000 225000 225000

IV and V 0 0 40000 40000 40000 40000 52000 52000 52000 52000 64000 64000 64000 64000 76000 76000 76000 76000 88000 88000 88000 88000 100000 100000 100000 100000 112000 112000 112000 112000 124000 124000 136000 136000

Other 0 52500 155000 207500 260000 312500 365000 417500 470000 522500 625000 677500 730000 782500 835000 887500 990000 1042500 1095000 1147500 1200000 1252500 1305000 1357500 1410000 1462500 1515000 1567500 1620000 1672500 1725000 1725000 1725000 1725000

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8500000 8500000 8500000 8500000

0

Cumulative Totals - Major Budget 0 406014 7443477 9523417 11749061 13855454 15971394 18094119 20307981 22527044 24830024 27087634 29867292 37556951 40963775 43388600 45753425 48048250 50417600 52774951 55120301 57465652 59777360 67024594 69766828 72431063 75787840 78133220 80344599 82541996 92703851 92703851 92715851 92715851

1887425 139371 209056 ERRORREF

29822121 1372022 2058033 ERRORREF

2000000 0 ERRORREF

590454 16667 25000 ERRORREF

0 ERRORREF

0 0

700000 49500 74250 0

5000000 333333 500000 0

920799 850092

6116664 1229849

209056 69685

2058033 686011

25000 8333

74250 24750

500000 166667

139371 69685 209056

1372022 686011 2058033

0

16667 8333 25000

0


49500 24750 74250

333333 166667 500000

ERRORVALUE

Item Amount Comment

Amount Spent as of FYE 2019 $ 42500000 Original Payroll Project HCM Analysis

Additional HCM Project Costs 79320000 Required to complete implementation

Move to Oracle Cloud Costs 10000000 Required for HCM

Total Projected Costs $ 131820000

Current Working Capital Advance (WCA) (82400000)

Additional WCA Required $ 49420000

Milestone Planned Start Date Actual Start Date Planned End Date Actual End Date

Planning and Analysis 52019 52019 61419 62119

Design 52019 52019 101819 101819

Construction 8519 72919 61220

Release 1 System Test 4620 11521

User Test Execution 11121 21221

Release 1 Training Delivery 11121 22621

Release 1 Go-Live 3121 3821

Release 1 Stabilization 3821 5721





Project Closeout 5222 53122

RICE Type HR PY TA BN FI Tech Total

New Reports 48 3 1 45 0 0 97

Existing Reports 6 57 40 20 0 0 123

New Interfaces 13 1 0 25 0 0 39

Existing Interfaces 3 8 4 13 0 0 28

New Conversions 3 0 0 3 1 0 7

Existing Conversions 5 5 7 3 1 0 21

New Extensions 29 4 2 15 4 0 54

Existing Extensions 3 15 24 3 11 8 64 Agency Survey Results Applied to New Agency Interfaces

Total 110 93 78 127 17 8 433 Interfaces Count Comments

HR006 - Position Upload 26 8 of the agencies were interfacing HR006 in Payroll

HR003 - Employee Data Upload 27 Includes two instances for VRS (agencyretiree populations are in two different systems)8 agencies interfaced in Payroll

Position Extract 42 Includes 1 count for each DBHDS instance

Employee Data Extract 45 Includes two instances for VRS (agencyretiree populations are in two different systems)Includes 1 count for each DBHDS instance

Benefits Enrollment Extract 18

Benefits Dependent Extract 13

PeopleSoft HCM Applications Planned use for Cardinal HCM

1 Absence Management x

2 Benefits Solutions x

3 Compensation

4 Directory Interface

5 eBenefits x

6 ELM

7 ePay x

8 HelpDesk for HR

9 Human Resources e modules included in HR applications x

10 eDevelopment

11 eProfile x

12 eProfile Manager Desktop

13 Global Payroll

14 Payroll for North America x

15 Payroll Interface

16 Pension Administration

17 Performance Management

18 Recruiting Solutions

19 Succession Planning

20 Time and Labor x

Total 20 8


Human Resources Human Resources Setup and Maintain Employee HR Data Administer Salary Plans Maintain Additional HR Data

eProfile

Benefits Administration Benefits Administration Benefits Recon Administer Open Enrollment Administer Event Maintenance Administer COBRA ACA Reporting

eBenefits

Time amp Attendance Time and Labor TampA Employee Setup TampA Capture TampA Approval and Processing Payroll Integration and Cost Allocation

Absence Management

Payroll Payroll for North America Maintain Employee Payroll Data Process Payroll Post Payroll Process Payroll Costing Periodic Regulatory Reporting

ePay


bull Workforce Data

bull Compensation and Benefits

bull HR Systemsndash Recruitment Management Systemndash Cardinal Human Capital Management


Workforce Data







SALARIED EMPLOYEES

Executive 10453067 9501


Judicial 332700 302



WAGE EMPLOYEES


Legislative 889 004

Judicial 13601 059










Finance 114651 110








Average Age

46


36

461539

Gender

Male Female

352

648

Race


78

922

Veterans


1830

1304

1065

964

950

556

308

097

Richmond

Other

Tidewater

Southside

Southwest

NOVA

Roanoke

Charlottesville

Winchester


58691



Telework Eligible

Positions

258


187

3791

1627

1501

1025

767

525

764

0 to 5 years

5 to 10 years

10 to 15 years

15 to 20 years

20 to 25 years

25 to 30 years

30+ years



113


January 28 2020 7




January 28 2020 8

January 28 2020 9



Job Role Employees












Agencies











DHRM




















Compensation























General Industry






21























62672

47721

33437

21156

34966 37475 37314 38584

0

10000

20000

30000

40000

50000

60000

70000

92013 92014 92015 92016 92017 92018 92019 122019







Employee Plus One

Employee Plus

2 or More

Employee Only

Employee Plus One


Employee Only

Employee Plus One

Employee Plus

2 or More

Employee $75 $177 $253 + $2 + $4 + $7 $77 $181 $260

Employer $687 $1229 $1802 + $16 + $30 + $43 $703 $1259 $1845

TOTAL PREMIUM $ 762 $1406 $2055 $0 + $18 + $70 $ 780 $1440 $2105


Employee Only

Employee Plus One

Employee Plus

2 or More

Employee Only

Employee Plus One



Employee Plus

2 or More

Employee $0 $24 $25 $0 - $24 - $25 $0 $0 $0

Employer $677 $1229 $1802 - $16 - $6 - $18 $661 $1223 $1784

TOTAL PREMIUM $677 $1253 $1827 - $16 - $30 - $43 $661 $12253 $1784







0

50

100

150

200

250

300

350

400

450

2015 2016 2017 2018 2019 Dec-19

Mill

ions


HR Systems
















31

What is Cardinal





Human Resources

eProfile


eBenefits

Time and Labor

Absence Management


ePay

Human Resources

Payroll

Time amp Attendance



32

Modules-Reqs


RICE


33




We are here

34



Actual Start Date

Planned End Date

Actual End Date


Milestones










Project Status






36

Exec View

HCM Implementation


ampDampT

Payroll Project


ampDampT

HCM Project


ampDampT

SC

SOW12

SOW14

HR Estimate






37

Project Challenges













January 282020



Workforce Data

Employment Levels





Slide Number 9







Exit Survey Results

Compensation











HR Systems



What is Cardinal




Project Status


Project Challenges









Other $250000





























$ 385000000
































































































































Orig Total $ 2261852900 23498529 $ 88000000

Plus CRs $ 2659102323

Change Requests









































total CRs $ 485249423

$ 2747102323


OKTA

HCM Project









IV and V $ 24000 $ 24000 $ 11890 $ 12110

Other $ 415393 $ 306191 $ 113101 $ 193091

Contingency $ 1100000 $ - 0 $ - 0 $ - 0

Total $ 9000000 $ 6258381 $ 4921931 $ 1336451

Payroll Project









IV and V $ 44283 $ 44283 $ 56173 $ (11890)

Other $ 676030 $ 652318 $ 627544 $ 24774

Contingency $ 200000 $ - 0 $ - 0 $ - 0

Total $ 34000000 $ 33453656 $ 33023592 $ 430064

Totals









IV and V $ 68283 $ 68283 $ 68063 $ 220

Other $ 1091423 $ 958509 $ 740645 $ 217865

Contingency $ 1300000 $ - 0 $ - 0 $ - 0

Total $ 43000000 $ 39712037 $ 37945523 $ 1766514

43000000

$ 0




COVA Overtime

10

Employees Role











Consultant Role









Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0




















Employees Role










Consultants Role









Tests 1 2 3 4 Testers 1 2 3 4 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 10000 10000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000


















Employees Role










Consultants









Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

















Employee Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0



COVA Support



IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890

VITA Charges 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Facilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0






System




Accenture 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


Totals

Totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 678483 876526 308042 607475 556898 1120366 774140 900378 1795489 369439 251202 8238438 8238438




0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 525000 779348 200770 489587 372551 920619 654861 425281 515281 184232 250000 5317529 Services 0 0 5317529 5317529

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 0 5000 Software Tools 0 0 5000 5000

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11412 12675 11858 10740 10814 102500 20000 20000 0 200000 Hardware 0 0 200000 200000


0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890 12110 0 0 0 24000 IV and V 0 0 24000 24000

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1834 20343 20343 18655 17437 18021 16468 186734 36000 36000 1202 373037 Other 0 0 373037 373037

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 0 0 1100000 Contingency 0 0 1100000 1100000


0



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 525000 1304348 1505118 1994705 2367256 3287875 3942736 4368017 4883298 5067529 5317529 5317529

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 5000 5000

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11412 24087 35946 46686 57500 160000 180000 200000 200000 200000


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890 24000 24000 24000 24000 24000

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1834 22177 42520 61175 78612 96633 113101 299835 335835 371835 373037 373037

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 1100000 1100000 1100000

0









IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12000 0 0 0 12000 0 0 0 0 24000

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21240 22951 46000 36000 36000 36000 36000 36000 36000 36000 36000 36000 1202 415393

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 0 0 1100000


0



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 654343 1509624 1729905 2350186 3040467 3550748 4276029 4701310 5216592 5411873 5546104 5796104 5796104

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 5000 5000

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17588 37588 57588 77588 97588 117588 137588 157588 177588 197588 217588 217588 217588


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 24000 24000 24000 24000 24000 24000

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21240 44191 90191 126191 162191 198191 234191 270191 306191 342191 378191 414191 415393 415393

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0


850092 1237743 1405639 1019241 1166273 992494 1672404 1544478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524271 125668807 678483 876526 308042 607475 556898 1120366 774140


VARIANCE



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -654343 -984624 -425557 -845068 -1045762 -1183492 -988155 -758575 -848575 -528575 -478575 -478575 -478575

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -17588 -37588 -57588 -66176 -73501 -81643 -90903 -100089 -17589 -17589 -17589 -17589 -17589


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -12000 -12000 -12000 -12000 -12110 0 0 0 0 0

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -21240 -44191 -88357 -104014 -119671 -137016 -155580 -173559 -193091 -42357 -42357 -42357 -42357 -42357

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


69685 69685 69685 69685

686011 686011 686011 686011

8333 8333 8333 8333

24750 24750 24750 24750

166667 166667 166667 166667

1887425 139371 209056 278741

29822121 1372022 2058033 2744043

2000000 0 0

590454 16667 25000 33333

0 0

0 0

700000 49500 74250 99000

5000000 333333 500000 666667

920799

-920799

209056 69685

2058033 686011

25000 8333

74250 24750

500000 166667

139371 69685 209056

1372022 686011 2058033

0

16667 8333 25000

0


49500 24750 74250

333333 166667 500000

8238438


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36


COVA Overtime

10

Employees Role











Consultant Role









Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 480 480 480 480 480 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2400




















Employees Role










Consultants Role









Tests 1 2 3 4 Testers 1 2 3 4 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 10000 10000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000


















Employees Role










Consultants









Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 771




















COVA Support



IV and V 0 0 0 0 0 17400

VITA Charges 0 2508

Facilities 0 3705




Contingency 0 0 0 0 0 0 0 0 0 0 0


System




Accenture 0 850000


Totals

Totals 0 951803 920799 850092 1237743 1405639 1019241 1166273 942494 1672404 1594478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524272 1256688 -114241 112579 90637 107645 82005 76184 101579 128544 115256 314544 0 33581936 5374820








IV and V 0 0 0 0 0 17400 0 3103 0 0 0 0 11890 0 0 0 0 0 0 0 11890 0 0 0 0 11890 0 0 0 0 0 0 0 0 0 0 56173 IV and V 20503 23780 11890 56173

Other 0 3735 4738 71766 6021 10716 10199 11971 13124 15737 14343 27845 30230 29266 33795 27011 26879 53637 35020 29285 28237 31132 30439 21241 22961 21297 0 0 4664 4359 4505 3390 21000 7712



0







IV and V 0 0 0 0 0 17400 17400 20503 20503 20503 20503 20503 32393 32393 32393 32393 32393 32393 32393 32393 44283 44283 44283 44283 44283 56173 56173 56173 56173 56173 56173 56173 56173 56173 56173 56173 56173

Other 0 3735 8473 80239 86260 96976 107176 119147 132271 148008 162351 190196 220425 249691 283487 310497 337376 391014 426034 455318 483556 514688 545127 566368 589329 610626 610626 610626 615289 619648 624154 627544 648544 656256 663256 663256 663256

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200000 200000 200000

0









IV and V 0 0 0 0 0 17400 0 3103 0 0 0 0 11890 0 0 0 0 0 0 0 11890 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 44283

Other 0 3735 4738 71766 6021 10716 10199 11971 13124 15737 14343 27845 30230 29266 33795 27011 26879 53637 35020 29285 28237 31132 30439 21240 22951 9000 9000 9000 9000 9000 9000 9000 9000 7712 7000 0 669030

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200000 0 0








IV and V 0 0 0 0 0 17400 17400 20503 20503 20503 20503 20503 32393 32393 32393 32393 32393 32393 32393 32393 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283

Other 0 3735 8473 80239 86260 96976 107176 119147 132271 148008 162351 190196 220425 249691 283487 310497 337376 391014 426034 455318 483556 514688 545127 566367 589318 598318 607318 616318 625318 634318 643318 652318 661318 669030 676030 676030 676030

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0


850092 1237743 1405639 1019241 1166273 992494 1672404 1544478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524271 125668807 -114241 112579 90637 107645 82005 76184 101579

SDM Recon Line -0

VARIANCE



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 450000 -451365 -455991 -467284 -468987 -494949 -527098 -531742 -531742 -531742 -531742 -531742 -531742

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11106 6106 3493 1599 -360 -2097 -4619 -4619 -4619 -4619 -4619 -4619


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890 11890 11890 11890 11890 11890 11890 11890 11890 11890 11890 11890

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 11 12308 3308 -5692 -10029 -14670 -19164 -24774 -12774 -12774 -12774 -12774 -12774

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


69685 69685 69685 69685

686011 686011 686011 686011

8333 8333 8333 8333

24750 24750 24750 24750

166667 166667 166667 166667

1887425 139371 209056 278741

29822121 1372022 2058033 2744043

2000000 0 0

590454 16667 25000 33333

0 0

0 0

700000 49500 74250 99000

5000000 333333 500000 666667

920799

-0

209056 69685

2058033 686011

25000 8333

74250 24750

500000 166667

139371 69685 209056

1372022 686011 2058033

0

16667 8333 25000

0


49500 24750 74250

333333 166667 500000

5374820


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

COVA Overtime

10

Employees Role











Pam Tauer CTO emp 0 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 0 0 300




Consultant Role





TBD TA Lead cc 0 0 0 80 160 160 160 160 160 160 170 160 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 0 0 4714










Tester 1 Tester cc 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 2560

Tester 2 Tester cc 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 2560

Tester 3 Tester cc 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 2560

Tester 4 Tester cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 0 0 0 0 0 0 0 0 0 0 0 0 0 960



TBD AGR Lead cc 0 80 160 160 160 160 160 160 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 4730









TBD Trainer 3 cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 2080

TBD Trainer 4 cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 2080

TBD Trainer 5 cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 2080








Employees Role











Pam Tauer CTO 9500 9500 9785 9785 9785 9785 9785 9785 9785 9785 9785 9785 9785 9785 10079 10079 10079 10079 10079 10079 10079 10079 10079 10079 10079 10079 10381 10381 10381 10381 10381 10381 10381



Consultants Role




TBD Payroll Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000

TBD TA Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000










Tester 1 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Tester 2 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Tester 3 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Tester 4 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500



TBD AGR Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000









TBD Trainer 3 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500

TBD Trainer 4 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500

TBD Trainer 5 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500






Employees Role











Pam Tauer CTO 0 950 979 979 979 979 979 979 979 979 979 979 979 979 1008 1008 1008 1008 1008 1008 1008 1008 1008 1008 1008 1008 1038 1038 1038 1038 1038 0 0 29977




Consultants Role




TBD Payroll Lead 0 0 12000 24000 24000 24000 24000 24000 24000 24000 25500 24000 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 0 0 731100

TBD TA Lead 0 0 0 12000 24000 24000 24000 24000 24000 24000 25500 24000 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 0 0 707100










Tester 1 Tester 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 192000

Tester 2 Tester 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 192000

Tester 3 Tester 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 192000

Tester 4 Tester 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 0 0 0 0 0 0 0 72000



TBD AGR Lead 0 12000 24000 24000 24000 24000 24000 24000 24000 24000 25500 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 0 0 709500









TBD Trainer 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 260000

TBD Trainer 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 260000

TBD Trainer 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 260000






Employee Costs 0 125755 128204 134384 136837 136837 134384 141569 144021 144021 144021 141569 154081 154081 157247 157247 157247 157247 159773 159773 159773 159773 117789 91194 91194 91194 93738 96340 96340 93738 93738 0 0 3953109



COVA Support



IV and V 0 0 40000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 12000 136000 IV and V








System






Totals

Totals 0 418514 7049963 2092441 2238144 2118893 2128441 2135225 2226362 2231562 2315480 2270110 2792158 7702158 3419325 2437325 2377325 2307325 2381851 2369851 2357851 2357851 2324208 7259734 2754734 2676734 3369278 2357880 2223880 2209896 10174356 0 12000 93090851








IV and V 0 0 40000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 12000 136000 IV and V 0 64000 36000 36000 136000

Other 0 52500 102500 52500 52500 52500 52500 52500 52500 52500 102500 52500 52500 52500 52500 52500 102500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 0 0 1725000 Other 52500 730000 680000 262500 1725000



-12500







IV and V 0 0 40000 40000 40000 40000 52000 52000 52000 52000 64000 64000 64000 64000 76000 76000 76000 76000 88000 88000 88000 88000 100000 100000 100000 100000 112000 112000 112000 112000 124000 124000 136000 136000

Other 0 52500 155000 207500 260000 312500 365000 417500 470000 522500 625000 677500 730000 782500 835000 887500 990000 1042500 1095000 1147500 1200000 1252500 1305000 1357500 1410000 1462500 1515000 1567500 1620000 1672500 1725000 1725000 1725000 1725000

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8500000 8500000 8500000 8500000

0


1887425 139371 209056 ERRORREF

29822121 1372022 2058033 ERRORREF

2000000 0 ERRORREF

590454 16667 25000 ERRORREF

0 ERRORREF

0 0

700000 49500 74250 0

5000000 333333 500000 0

920799 850092

6116664 1229849

209056 69685

2058033 686011

25000 8333

74250 24750

500000 166667

139371 69685 209056

1372022 686011 2058033

0

16667 8333 25000

0


49500 24750 74250

333333 166667 500000

ERRORVALUE

Item Amount Comment









Design 52019 52019 101819 101819













New Reports 48 3 1 45 0 0 97


















3 Compensation


5 eBenefits x

6 ELM

7 ePay x

8 HelpDesk for HR


10 eDevelopment

11 eProfile x


13 Global Payroll







20 Time and Labor x

Total 20 8



eProfile


eBenefits


Absence Management


ePay

Workforce Data







SALARIED EMPLOYEES

Executive 10453067 9501


Judicial 332700 302



WAGE EMPLOYEES


Legislative 889 004

Judicial 13601 059










Finance 114651 110








Average Age

46


36

461539

Gender

Male Female

352

648

Race


78

922

Veterans


1830

1304

1065

964

950

556

308

097

Richmond

Other

Tidewater

Southside

Southwest

NOVA

Roanoke

Charlottesville

Winchester


58691



Telework Eligible

Positions

258


187

3791

1627

1501

1025

767

525

764

0 to 5 years

5 to 10 years

10 to 15 years

15 to 20 years

20 to 25 years

25 to 30 years

30+ years



113


January 28 2020 7




January 28 2020 8

January 28 2020 9



Job Role Employees












Agencies











DHRM




















Compensation























General Industry






21























62672

47721

33437

21156

34966 37475 37314 38584

0

10000

20000

30000

40000

50000

60000

70000

92013 92014 92015 92016 92017 92018 92019 122019







Employee Plus One

Employee Plus

2 or More

Employee Only

Employee Plus One


Employee Only

Employee Plus One

Employee Plus

2 or More

Employee $75 $177 $253 + $2 + $4 + $7 $77 $181 $260

Employer $687 $1229 $1802 + $16 + $30 + $43 $703 $1259 $1845

TOTAL PREMIUM $ 762 $1406 $2055 $0 + $18 + $70 $ 780 $1440 $2105


Employee Only

Employee Plus One

Employee Plus

2 or More

Employee Only

Employee Plus One



Employee Plus

2 or More

Employee $0 $24 $25 $0 - $24 - $25 $0 $0 $0

Employer $677 $1229 $1802 - $16 - $6 - $18 $661 $1223 $1784

TOTAL PREMIUM $677 $1253 $1827 - $16 - $30 - $43 $661 $12253 $1784







0

50

100

150

200

250

300

350

400

450

2015 2016 2017 2018 2019 Dec-19

Mill

ions


HR Systems
















31

What is Cardinal





Human Resources

eProfile


eBenefits

Time and Labor

Absence Management


ePay

Human Resources

Payroll

Time amp Attendance



32

Modules-Reqs


RICE


33




We are here

34



Actual Start Date

Planned End Date

Actual End Date


Milestones










Project Status






36

Exec View

HCM Implementation


ampDampT

Payroll Project


ampDampT

HCM Project


ampDampT

SC

SOW12

SOW14

HR Estimate






37

Project Challenges













January 282020



Workforce Data

Employment Levels





Slide Number 9







Exit Survey Results

Compensation











HR Systems



What is Cardinal




Project Status


Project Challenges









Other $250000





























$ 385000000
































































































































Orig Total $ 2261852900 23498529 $ 88000000

Plus CRs $ 2659102323

Change Requests









































total CRs $ 485249423

$ 2747102323


OKTA

HCM Project









IV and V $ 24000 $ 24000 $ 11890 $ 12110

Other $ 415393 $ 306191 $ 113101 $ 193091

Contingency $ 1100000 $ - 0 $ - 0 $ - 0

Total $ 9000000 $ 6258381 $ 4921931 $ 1336451

Payroll Project









IV and V $ 44283 $ 44283 $ 56173 $ (11890)

Other $ 676030 $ 652318 $ 627544 $ 24774

Contingency $ 200000 $ - 0 $ - 0 $ - 0

Total $ 34000000 $ 33453656 $ 33023592 $ 430064

Totals









IV and V $ 68283 $ 68283 $ 68063 $ 220

Other $ 1091423 $ 958509 $ 740645 $ 217865

Contingency $ 1300000 $ - 0 $ - 0 $ - 0

Total $ 43000000 $ 39712037 $ 37945523 $ 1766514

43000000

$ 0




COVA Overtime

10

Employees Role











Consultant Role









Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0




















Employees Role










Consultants Role









Tests 1 2 3 4 Testers 1 2 3 4 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 10000 10000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000


















Employees Role










Consultants









Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

















Employee Costs 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0



COVA Support



IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890

VITA Charges 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Facilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0






System




Accenture 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


Totals

Totals 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 678483 876526 308042 607475 556898 1120366 774140 900378 1795489 369439 251202 8238438 8238438




0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 525000 779348 200770 489587 372551 920619 654861 425281 515281 184232 250000 5317529 Services 0 0 5317529 5317529

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 0 5000 Software Tools 0 0 5000 5000

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11412 12675 11858 10740 10814 102500 20000 20000 0 200000 Hardware 0 0 200000 200000


0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890 12110 0 0 0 24000 IV and V 0 0 24000 24000

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1834 20343 20343 18655 17437 18021 16468 186734 36000 36000 1202 373037 Other 0 0 373037 373037

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 0 0 1100000 Contingency 0 0 1100000 1100000


0



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 525000 1304348 1505118 1994705 2367256 3287875 3942736 4368017 4883298 5067529 5317529 5317529

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 5000 5000

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11412 24087 35946 46686 57500 160000 180000 200000 200000 200000


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890 24000 24000 24000 24000 24000

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1834 22177 42520 61175 78612 96633 113101 299835 335835 371835 373037 373037

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 1100000 1100000 1100000

0









IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12000 0 0 0 12000 0 0 0 0 24000

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21240 22951 46000 36000 36000 36000 36000 36000 36000 36000 36000 36000 1202 415393

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1100000 0 0 1100000


0



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 654343 1509624 1729905 2350186 3040467 3550748 4276029 4701310 5216592 5411873 5546104 5796104 5796104

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5000 5000 5000

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17588 37588 57588 77588 97588 117588 137588 157588 177588 197588 217588 217588 217588


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 24000 24000 24000 24000 24000 24000

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21240 44191 90191 126191 162191 198191 234191 270191 306191 342191 378191 414191 415393 415393

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0


850092 1237743 1405639 1019241 1166273 992494 1672404 1544478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524271 125668807 678483 876526 308042 607475 556898 1120366 774140


VARIANCE



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -654343 -984624 -425557 -845068 -1045762 -1183492 -988155 -758575 -848575 -528575 -478575 -478575 -478575

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -17588 -37588 -57588 -66176 -73501 -81643 -90903 -100089 -17589 -17589 -17589 -17589 -17589


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -12000 -12000 -12000 -12000 -12110 0 0 0 0 0

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -21240 -44191 -88357 -104014 -119671 -137016 -155580 -173559 -193091 -42357 -42357 -42357 -42357 -42357

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


69685 69685 69685 69685

686011 686011 686011 686011

8333 8333 8333 8333

24750 24750 24750 24750

166667 166667 166667 166667

1887425 139371 209056 278741

29822121 1372022 2058033 2744043

2000000 0 0

590454 16667 25000 33333

0 0

0 0

700000 49500 74250 99000

5000000 333333 500000 666667

920799

-920799

209056 69685

2058033 686011

25000 8333

74250 24750

500000 166667

139371 69685 209056

1372022 686011 2058033

0

16667 8333 25000

0


49500 24750 74250

333333 166667 500000

8238438


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36


COVA Overtime

10

Employees Role











Consultant Role









Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 480 480 480 480 480 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2400




















Employees Role










Consultants Role









Tests 1 2 3 4 Testers 1 2 3 4 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 5000 10000 10000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000 4000


















Employees Role










Consultants









Tests 1 2 3 4 Testers 1 2 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 771




















COVA Support



IV and V 0 0 0 0 0 17400

VITA Charges 0 2508

Facilities 0 3705




Contingency 0 0 0 0 0 0 0 0 0 0 0


System




Accenture 0 850000


Totals

Totals 0 951803 920799 850092 1237743 1405639 1019241 1166273 942494 1672404 1594478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524272 1256688 -114241 112579 90637 107645 82005 76184 101579 128544 115256 314544 0 33581936 5374820








IV and V 0 0 0 0 0 17400 0 3103 0 0 0 0 11890 0 0 0 0 0 0 0 11890 0 0 0 0 11890 0 0 0 0 0 0 0 0 0 0 56173 IV and V 20503 23780 11890 56173

Other 0 3735 4738 71766 6021 10716 10199 11971 13124 15737 14343 27845 30230 29266 33795 27011 26879 53637 35020 29285 28237 31132 30439 21241 22961 21297 0 0 4664 4359 4505 3390 21000 7712



0







IV and V 0 0 0 0 0 17400 17400 20503 20503 20503 20503 20503 32393 32393 32393 32393 32393 32393 32393 32393 44283 44283 44283 44283 44283 56173 56173 56173 56173 56173 56173 56173 56173 56173 56173 56173 56173

Other 0 3735 8473 80239 86260 96976 107176 119147 132271 148008 162351 190196 220425 249691 283487 310497 337376 391014 426034 455318 483556 514688 545127 566368 589329 610626 610626 610626 615289 619648 624154 627544 648544 656256 663256 663256 663256

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200000 200000 200000

0









IV and V 0 0 0 0 0 17400 0 3103 0 0 0 0 11890 0 0 0 0 0 0 0 11890 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 44283

Other 0 3735 4738 71766 6021 10716 10199 11971 13124 15737 14343 27845 30230 29266 33795 27011 26879 53637 35020 29285 28237 31132 30439 21240 22951 9000 9000 9000 9000 9000 9000 9000 9000 7712 7000 0 669030

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 200000 0 0








IV and V 0 0 0 0 0 17400 17400 20503 20503 20503 20503 20503 32393 32393 32393 32393 32393 32393 32393 32393 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283 44283

Other 0 3735 8473 80239 86260 96976 107176 119147 132271 148008 162351 190196 220425 249691 283487 310497 337376 391014 426034 455318 483556 514688 545127 566367 589318 598318 607318 616318 625318 634318 643318 652318 661318 669030 676030 676030 676030

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0


850092 1237743 1405639 1019241 1166273 992494 1672404 1544478 1744353 2165135 776726 1060239 1304384 2209456 1042427 2395738 1613101 1176209 1604127 1933383 524271 125668807 -114241 112579 90637 107645 82005 76184 101579

SDM Recon Line -0

VARIANCE



Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 450000 -451365 -455991 -467284 -468987 -494949 -527098 -531742 -531742 -531742 -531742 -531742 -531742

Software Tools 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Hardware 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11106 6106 3493 1599 -360 -2097 -4619 -4619 -4619 -4619 -4619 -4619


IV and V 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 11890 11890 11890 11890 11890 11890 11890 11890 11890 11890 11890 11890

Other 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 11 12308 3308 -5692 -10029 -14670 -19164 -24774 -12774 -12774 -12774 -12774 -12774

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0


69685 69685 69685 69685

686011 686011 686011 686011

8333 8333 8333 8333

24750 24750 24750 24750

166667 166667 166667 166667

1887425 139371 209056 278741

29822121 1372022 2058033 2744043

2000000 0 0

590454 16667 25000 33333

0 0

0 0

700000 49500 74250 99000

5000000 333333 500000 666667

920799

-0

209056 69685

2058033 686011

25000 8333

74250 24750

500000 166667

139371 69685 209056

1372022 686011 2058033

0

16667 8333 25000

0


49500 24750 74250

333333 166667 500000

5374820


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

COVA Overtime

10

Employees Role











Pam Tauer CTO emp 0 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 0 0 300




Consultant Role





TBD TA Lead cc 0 0 0 80 160 160 160 160 160 160 170 160 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 176 0 0 4714










Tester 1 Tester cc 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 2560

Tester 2 Tester cc 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 2560

Tester 3 Tester cc 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 0 0 0 0 2560

Tester 4 Tester cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 0 0 0 0 0 0 0 0 0 0 0 0 0 960



TBD AGR Lead cc 0 80 160 160 160 160 160 160 160 160 170 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 4730









TBD Trainer 3 cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 2080

TBD Trainer 4 cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 2080

TBD Trainer 5 cc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 160 160 160 160 160 160 160 160 160 160 160 160 0 0 2080








Employees Role











Pam Tauer CTO 9500 9500 9785 9785 9785 9785 9785 9785 9785 9785 9785 9785 9785 9785 10079 10079 10079 10079 10079 10079 10079 10079 10079 10079 10079 10079 10381 10381 10381 10381 10381 10381 10381



Consultants Role




TBD Payroll Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000

TBD TA Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000










Tester 1 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Tester 2 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Tester 3 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500

Tester 4 Tester 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500 7500



TBD AGR Lead 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000 15000









TBD Trainer 3 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500

TBD Trainer 4 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500

TBD Trainer 5 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500






Employees Role











Pam Tauer CTO 0 950 979 979 979 979 979 979 979 979 979 979 979 979 1008 1008 1008 1008 1008 1008 1008 1008 1008 1008 1008 1008 1038 1038 1038 1038 1038 0 0 29977




Consultants Role




TBD Payroll Lead 0 0 12000 24000 24000 24000 24000 24000 24000 24000 25500 24000 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 0 0 731100

TBD TA Lead 0 0 0 12000 24000 24000 24000 24000 24000 24000 25500 24000 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 26400 0 0 707100










Tester 1 Tester 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 192000

Tester 2 Tester 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 192000

Tester 3 Tester 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 192000

Tester 4 Tester 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12000 12000 12000 12000 12000 12000 0 0 0 0 0 0 0 0 0 0 0 0 0 72000



TBD AGR Lead 0 12000 24000 24000 24000 24000 24000 24000 24000 24000 25500 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 24000 0 0 709500









TBD Trainer 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 260000

TBD Trainer 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 260000

TBD Trainer 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 20000 0 0 260000






Employee Costs 0 125755 128204 134384 136837 136837 134384 141569 144021 144021 144021 141569 154081 154081 157247 157247 157247 157247 159773 159773 159773 159773 117789 91194 91194 91194 93738 96340 96340 93738 93738 0 0 3953109



COVA Support



IV and V 0 0 40000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 12000 136000 IV and V








System






Totals

Totals 0 418514 7049963 2092441 2238144 2118893 2128441 2135225 2226362 2231562 2315480 2270110 2792158 7702158 3419325 2437325 2377325 2307325 2381851 2369851 2357851 2357851 2324208 7259734 2754734 2676734 3369278 2357880 2223880 2209896 10174356 0 12000 93090851








IV and V 0 0 40000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 0 0 12000 0 12000 136000 IV and V 0 64000 36000 36000 136000

Other 0 52500 102500 52500 52500 52500 52500 52500 52500 52500 102500 52500 52500 52500 52500 52500 102500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 52500 0 0 1725000 Other 52500 730000 680000 262500 1725000



-12500







IV and V 0 0 40000 40000 40000 40000 52000 52000 52000 52000 64000 64000 64000 64000 76000 76000 76000 76000 88000 88000 88000 88000 100000 100000 100000 100000 112000 112000 112000 112000 124000 124000 136000 136000

Other 0 52500 155000 207500 260000 312500 365000 417500 470000 522500 625000 677500 730000 782500 835000 887500 990000 1042500 1095000 1147500 1200000 1252500 1305000 1357500 1410000 1462500 1515000 1567500 1620000 1672500 1725000 1725000 1725000 1725000

Contingency 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8500000 8500000 8500000 8500000

0


1887425 139371 209056 ERRORREF

29822121 1372022 2058033 ERRORREF

2000000 0 ERRORREF

590454 16667 25000 ERRORREF

0 ERRORREF

0 0

700000 49500 74250 0

5000000 333333 500000 0

920799 850092

6116664 1229849

209056 69685

2058033 686011

25000 8333

74250 24750

500000 166667

139371 69685 209056

1372022 686011 2058033

0

16667 8333 25000

0


49500 24750 74250

333333 166667 500000

ERRORVALUE

Item Amount Comment









Design 52019 52019 101819 101819













New Reports 48 3 1 45 0 0 97


















3 Compensation


5 eBenefits x

6 ELM

7 ePay x

8 HelpDesk for HR


10 eDevelopment

11 eProfile x


13 Global Payroll







20 Time and Labor x

Total 20 8



eProfile


eBenefits


Absence Management


ePay

	Planning amp Implementation of PeopleSoft HR and Benefits

	Detailed Planning Effort (COVA and Accenture)			$2000000

	Accenture Services for Implementation			$9200000

	COVA Services for Implementation			$5600000

	Hardware costs for HRBenefits			$350000

	Software costs (initial buy plus YR1 maintenance)			$2000000

	Other			$250000

	Planning and Implementation Costs			$19400000

	10 Contingency			$1940000

	Total Implementation Estimate			$21340000

Del	Phase	Deliverable Name	Due Date	Deliverable Amount	Date Paid		Recon		Outstanding

001	Analyze	Plan Phase and Project Start Up	72418	$ 37500000

002	Analyze	Project Management Services and Monthly Status Report (1)	72718	$ 7500000	83118		$ 45000000

003	Analyze	Project Management Services and Monthly Status Report (2)	83018	$ 7500000	93018		$ 52500000 Robinson Ray (DOA) Robinson Ray (DOA)Aug amp Sept total reported in Sept SC

004	Analyze	As-Is Process Flow Designs	92118	$ 56000000

005	Analyze	Project Management Services and Monthly Status Report (3)	92718	$ 7500000	103118		$ 63500000		$ - 0

006	Analyze	Project Management Services and Monthly Status Report (4)	102618	$ 7500000	113018		$ 7500000		$ - 0

007	Analyze	Agency Assessment Survey Results	11918	$ 40000000

008	Analyze	Project Management Services and Monthly Status Report (5)	112918	$ 7500000	123118		$ 40000000		$ - 0

009	Analyze	Project Management Services and Monthly Status Report (6)	122118	$ 6000000

010	Analyze	As-Is Reports and Interfaces Inventory	122118	$ 27500000	123118		$ 35000000

011	Analyze	Technology Roadmap	122718	$ 21000000	13119		$ 27000000		$ - 0

012	Analyze	Project Management Services and Monthly Status Report (7)	13119	$ 4500000	22819		$ 81500000

013	Analyze	Application and Interface Disposition	13119	$ 14500000

014	Analyze	iHubOkta Impacted Use Cases	13119	$ 17500000			$ - 0

015	Analyze	To-Be Process Flow Designs	21519	$ 45000000

016	Analyze	Reporting Analysis	22219	$ 10000000	33119		$ 53000000

017	Analyze	Project Management Services and Monthly Status Report (8)	22819	$ 3000000		$ 13000000		$ - 0

018	Analyze	Requirements	31519	$ 15000000

019	Analyze	RICE Inventory	32219	$ 10000000

020	Analyze	Project Management Services and Monthly Status Report (9)	32819	$ 3000000		$ 28000000

021	Analyze	Implementation Estimate	41219	$ 14000000

022	Analyze	RICE Functional Designs	41219	$ 10000000

023	Analyze	Configuration Designs	41219	$ 10000000

024	Analyze	Project Management Services and Monthly Status Report (10)	41219	$ 3000000		$ 37000000

		$ 385000000

Del		Phase	Team		Deliverable Name		Due Date		Deliverable Amount	Date Paid	Recon	Outstanding

1		PlanAnalyze	Project Management		Microsoft Project Plan		81916		$ 10000000

2		PlanAnalyze	Project Management		Project Management Plan		82416		$ 10000000

3		PlanAnalyze	Change Leadership		Communication Plan		82416		$ 12500000

4		PlanAnalyze	RICE Management		Reporting Analysis		82616		$ 30000000

5		PlanAnalyze	Project Management		Project Management Services and Monthly Status Report (1)		83116		$ 22500000	93016	$ 85000000

6		Design	Application Management		Requirements Traceability Matrix		91616		$ 17500000

7		Design	Test Management		Test Approach		92316		$ 12500000

8		Design	Technical Management		Environment Plan		92316		$ 35000000

9		Design	Change Leadership		Readiness Approach		92316		$ 20000000	103116	$ 85000000

10		Design	Project Management		Project Management Services and Monthly Status Report (2)		93016		$ 22500000

11		Design	Training		Training Plan		102116		$ 20000000

12		Design	Change Leadership		Quarterly Communications Delivery (1)		102116		$ 4000000

13		Design	Technical Management		Technical Architecture Analysis		102816		$ 35000000

14		Design	Project Management		Project Management Services and Monthly Status Report (3)		102816		$ 22500000	113016	$ 69000000

15		Design	Application Management		Configuration and Security Design (1)		111816		$ 35000000

16		Design	RICE Management		RICE Functional Designs (1)		112116		$ 60000000

17		Design	Project Management		Project Management Services and Monthly Status Report (4)		113016		$ 22500000	123116	$ 92500000

18		Design	Training		Training Curriculum Design		122316		$ 32500000

19		Design	Project Management		Project Management Services and Monthly Status Report (5)		123016		$ 22500000	13017	$ 115000000	$ - 0		Dec 16

20		Design	Change Leadership		Agency Readiness Outreach and Support - Design Phase		12017		$ 15000000

21		Design	Technical Management		Technical Architecture Design		12017		$ 35000000	43017	$ 59000000

22		Design	Change Leadership		Quarterly Communications Delivery (2)		12417		$ 4000000

23		Design	Project Management		Project Management Services and Monthly Status Report (6)		12717		$ 20000000

24		Design	Application Management		Configuration and Security Design (2)		13017		$ 35000000	22817	$ 74000000		Jan 17

25		Build	RICE Management		RICE Functional Designs (2)		21017		$ 60000000	33117	$ 81400000

26		Build	Application Management		Updated Process Flows and Narratives		21717		$ 35000000

27		Build	Test Management		System Test Scripts - Cycle 0		22417		$ 10000000

28		Build	Project Management		Project Management Services and Monthly Status Report (7)		22417		$ 20000000		$ - 0	Feb 17

29		Build	Test Management		System Test Scripts - Cycle 1		31717		$ 25000000

30		Build	RICE Management		RICE Technical Designs		32417		$ 65000000

31		Build	Application Management		Configuration and Security Build (1)		32417		$ 47500000

32		Build	Project Management		Project Management Services and Monthly Status Report (8)		33117		$ 20000000		$ - 0	Mar 17

33		Build	Test Management		System Test Scripts - Cycle 2		41417		$ 25000000

34		Build	Change Leadership		Role Descriptions		42117		$ 10000000

35		Build	Change Leadership		Quarterly Communications Delivery (3)		42117		$ 4000000

36		Build	RICE Management		RICE BuildUnit Test (1)		42417		$ 65000000

37		Build	Project Management		Project Management Services and Monthly Status Report (9)		42817		$ 20000000	53117	$ 130500000

38		Build	Test Management		System Test Scripts - Cycle 3		42817		$ 10000000		$ - 0	Apr 17

39		Build	Test Management		System Test Scripts - Cycle 4		51017		$ 10000000

40		Build	Training		Training Design		51917		$ 10000000

41		Build	Test Management		System Test Scripts - Cycle 5		51917		$ 10000000

42		Build	Application Management		Configuration and Security Build (2)		51917		$ 40500000	63017	$ 89500000 Robinson Ray (DOA) Robinson Ray (DOA)went back to April and made the correction to remove the deliverable 50k

43		Build	Test Management		Parallel Test Approach		52317		$ 15000000

44		Build	Project Management		Project Management Services and Monthly Status Report (10)		53117		$ 20000000

45		Build	Test Management		System Test Scripts - Cycle 6		53117		$ 10000000	73017	$ 159000000	$ - 0		May 17

46		Build	Test Management		System Test Scripts - Cycle 7		61417		$ 25000000

47		Build	Change Leadership		Agency Readiness Outreach and Support - Build Phase		61617		$ 15000000

48		Build	Change Leadership		Business Process Workshops - Release 1		62317		$ 17500000	83117	$ 160014400

49		Build	Test Management		System Test Scripts - Cycle 8		62317		$ 15000000

50		Build	Project Management		Project Management Services and Monthly Status Report (11)		63017		$ 20000000

51		Build	RICE Management		Mock 1 Conversion Results		63017		$ 35000000

52		Build	Test Management		System Test Scripts - Cycle 9		63017		$ 10000000		$ - 0	June 17

53		Test	RICE Management		RICE BuildUnit Test (2)		7717		$ 65000000

54		Test	Test Management		System Test Scripts - Cycle 10		7717		$ 10000000

55		Test	Training		Test Training Approach		71417		$ 7500000

56		Test	Test Management		System Test Results - Cycle 0		72117		$ 10000000

57		Test	Change Leadership		Quarterly Communications Delivery (4)		72417		$ 4000000

58		Test	Project Management		Project Management Services and Monthly Status Report (12)		72817		$ 20000000		$ - 0	Jul 17

59		Test	Test Management		User Acceptance Test Plan		81117		$ 12500000

60		Test	Test Management		System Test Results - Cycle 1		82417		$ 25000000

61		Test	Training		Training Build (1)		82417		$ 7500000

62		Test	Project Management		Project Management Services and Monthly Status Report (13)		83117		$ 20000000	93017	$ 32550000

63		Test	RICE Management		Mock 2 Conversion Results		83117 Oneill Edmond (DOA) Oneill Edmond (DOA)This really is 350kRR updated 91217		$ 35000000		$ - 0	Aug 17

64		Test	Test Management		System Test Results - Cycle 3		91317		$ 10000000

65		Test	Test Management		System Test Results - Cycle 4		92217		$ 12500000

66		Test	Project Management		Project Management Services and Monthly Status Report (14)		92917		$ 20000000	103117	$ 55000000

67		Test	Test Management		System Test Results - Cycle 2		92917		$ - 0		$ - 0	Sep 17

68		Test	Test Management		System Test Results - Cycle 5		101317		$ 10000000

69		Test	Change Leadership		Quarterly Communications Delivery (5)		101717		$ 4000000

70		Test	Technical Management		Performance Test Approach		102017		$ 12500000	113017	$ 85400000

71		Test	Training		Training Build (2)		102417		$ 7500000

72		Test	Change Leadership		Role Mapping - Release 1		102417		$ 10000000

73		Test	Project Management		Project Management Services and Monthly Status Report (15)		102717		$ 15000000

74		Test	RICE Management		Mock 3 Conversion Results		102717		$ 35000000		$ - 0	Oct 17

75		Test	Test Management		System Test Results - Cycle 6		111017		$ 10000000	123017	$ 170126000

76		Test	Test Management		System Test Results - Cycle 9		112017		$ 10000000

77		Test	RICE Management		Batch Design		112117		$ 27500000

78		Test	Project Management		Project Management Services and Monthly Status Report (16)		113017		$ 15000000		$ - 0	Nov 17

79		Test	Technical Management		Performance Test Scripts		121517		$ 22500000

80		Test	Test Management		System Test Results - Cycle 7		121817		$ 25000000

81		Test	Project Management		Project Management Services and Monthly Status Report (17)		122917		$ 15000000	13118	$ 57022000	$ 25000000		Dec 17

82		Test	Test Management		System Test Results - Cycle 8		11218		$ - 0

83		Test	Change Leadership		Agency Readiness Outreach and Support - Test Phase - Release 1		11918		$ 15000000

84		Test	Training		Test Training - Release 1		11918		$ 7500000

85		Test	Change Leadership		Quarterly Communications Delivery (6)		12318		$ 4000000

86		Test	RICE Management		Batch Build - Release 1		12418		$ 20000000

87		Test	Test Management		System Test Results - Cycle 10		12618		$ 10000000

88		Test	Project Management		Project Management Services and Monthly Status Report (18)		13118		$ 15000000	22818	$ 196430000	$ 42500000		Jan 18

89		Deploy	Technical Management		Performance Test Results		21618		$ 20000000

90		Deploy	Test Management		Parallel Test Results ndash Release 1		21618		$ 20000000

91		Deploy	Application Management		Deployment Plan ndash Release 1		21618		$ - 0

92		Deploy	Test Management		UAT Test Results		22318		$ 20000000

93		Deploy	Project Management		Project Management Services and Monthly Status Report (19)		22818		$ 13000000	33018	$ 111019023	$ 82500000		Feb 18

94		Deploy	Change Leadership		Agency Readiness Outreach and Support - Deploy Phase - Release 1		31618		$ 10000000

95		Deploy	Training		Training Delivery ndash Release 1		32318		$ 20000000

96		Deploy	Project Management		Project Management Services and Monthly Status Report (20)		33018		$ 12500000	43018	$ 65930000	$ 102500000		Mar 18

97		Deploy	Application Management		Production Go-Live ndash Release 1		4218		$ 32500000

98		Stabilization	Change Leadership		Quarterly Communications Delivery (7)		42318		$ 4000000	53018	$ 108930000

99		Stabilization	Project Management		Project Management Services and Monthly Status Report (21)		42718		$ 7500000

100		Stabilization	Application Management		System Stabilization (1) ndash Release 1		42718		$ 47500000		$ 182500000	Apr 18

101		Stabilization	Application Management		System Stabilization (2) ndash Release 1		53118		$ 45000000

102		Stabilization	Project Management		Project Management Services and Monthly Status Report (22)		53118		$ 10000000	63018	$ 110128000	$ 182500000		May 18

103		Test	RICE Management		Mock 4 Conversion Results		62218		$ 35000000

104		Test	Training		Training Build - Release 2		62218		$ 3000000

105		Test	Project Management		Project Management Services and Monthly Status Report (23)		62918		$ 10000000	73018	$ 38950000

106		Test	RICE Management		Batch Build - Release 2		7618		$ 20000000

107		Test	Training		Test Training and Train-the-Trainer - Release 2		7918		$ 5000000

108		Test	Change Leadership		Agency Readiness Outreach and Support - Test Phase - Release 2		71818		$ 5000000		$ 220500000	Jun 18

109		Test	Change Leadership		Business Process Workshop Refresh - Release 2		72418		$ 5000000

110		Test	Change Leadership		Quarterly Communications Delivery (8)		72418		$ 2500000

111		Test	Test Management		Supplemental Interface Test Results		72718		$ 22500000

112		Test	Project Management		Project Management Services and Monthly Status Report (24)		72718		$ 7500000	83118	$ 47550000	$ 278000000		Jul 18

113		Deploy	Change Leadership		Role Mapping Review - Release 2		81018		$ 5000000

114		Deploy	Application Management		Deployment Plan ndash Release 2		81718		$ 27500000

115		Deploy	Test Management		Parallel Test Results ndash Release 2		82418		$ - 0

116		Deploy	Project Management		Project Management Services and Monthly Status Report (25)		83118		$ 7500000		$ 318000000	Aug 18

117		Deploy	Change Leadership		Agency Readiness Outreach and Support - Deploy Phase - Release 2		92118		$ 5000000

118		Deploy	Training		Training Delivery ndash Release 2		92118		$ 10000000

119		Deploy	Project Management		Project Management Services and Monthly Status Report (26)		92818		$ 5000000		$ 20000000	Sep 18

120		Deploy	Application Management		Production Go-Live ndash Release 2		10118		$ 20000000

121		Stabilization	Change Leadership		Quarterly Communications Delivery (9)		102418		$ 2500000

122		Stabilization	Application Management		System Stabilization (1) ndash Release 2		103118		$ 7500000

123		Stabilization	Project Management		Project Management Services and Monthly Status Report (27)		103118		$ 5000000		$ 35000000	Oct 18

124		Stabilization	Project Management		Project Management Services and Monthly Status Report (28)		113018		$ 5000000

125		Stabilization	Application Management		System Stabilization (2) ndash Release 2		113018		$ 5000000

126		Stabilization	Application Management		Successful Go-Live		113018		$ 4852900		$ 36352900	Nov 18

			Orig Total		$ 2261852900		23498529		$ 88000000

			Plus CRs		$ 2659102323

	Change Requests

127		COA Support	Feb-17		SOW12-CR027		22817		$ 1400000

128		COA Support	Mar-17		SOW12-CR027		33117		$ 4000000

129		COA Support	Apr-17		SOW12-CR027		42817		$ 4000000

130		COA Support	May-17		SOW12-CR027		53117		$ 4000000

131		COA Support	Jun-17		SOW12-CR027		63017		$ 4000000

132		COA Support	Jul-17		SOW12-CR027		73117		$ 4000000

133		COA Support	Aug-17		SOW12-CR027		81817		$ 2550000

134		App CR Tru Up	Jul-17		SOW12-CR046		81817		$ 49514400

135		App CR Tru Up	Nov-17		SOW12-CR046		81917		$ 39600000

136		Sched Change	Oct-17		SOW12-CR056		103117		$ 18300000	$175k on Julies list

137		Sched Change	Nov-17		SOW12-CR056		113017		$ 18300000	$175k on Julies list

138		Sched Change	Dec-17		SOW12-CR056		122717		$ 18300000

139		Sched Change	Jan-18		SOW12-CR056		13118		$ 18300000

140		Sched Change	Feb-18		SOW12-CR056		22818		$ 18300000

141		Sched Change	Mar-18		SOW12-CR056		33018		$ 18300000 Robinson Ray (DOA) Robinson Ray (DOA)changed to 183k from 175k per April Cardinal Query

142		Sched Change	Apr-18		SOW12-CR056		42718		$ 18300000

143		Sched Change	May-18		SOW12-CR056		53118		$ 17628000

144		CR059 App True up Func Designs		CR059 App CR True Up Functional Designs		112917		$ 20000000

145		CR059 App True up Tech Design Bld		CR059 App CR True Up TDBuild		121517		$ 13696000

146		ihub designs		iHub Design		122517		$ 19592000

147		Okta ihub Arch Approach	Feb-18		OktaiHub Architecture Approach		22218		$ 16000000

148		iHub Build	Mar-18		iHub Build		31618		$ 12000000

149		Okta ihub use cases	Mar-18		OktaiHub Use Cases		4618		$ 9000000

150		Okta iHub sys test scripts	Mar-18		OktaiHub System Test Scripts		32318		$ 12500000

151		Okta iHub sys test results	Apr-18		OktaiHub System Test Results		43018		$ 13800000

152		Conversion support month 1		Conversion Support ndash Month 1		121517		$ 4130000

153		Conversion support month 2	Jan-18		Conversion Support ndash Month 2		11518		$ 4130000

154		Conversion support month 3	Feb-18		Conversion Support ndash Month 3		21518		$ 4130000

155		Conversion support month 4	Mar-18		Conversion Support ndash Month 4		31518		$ 4130000

156		Conversion support month 5	Apr-18		Conversion Support ndash Month 5		41518		$ 4130000

157		Storm Runner Load Licenses	Feb-18		Storm Runner Load Licenses		21518		$ 1219023

67a		CR76 System Test Results - Cycle 2	72718		CR76 System Test Results - Cycle 2		72718		$ 23750000

67b		CR76 System Test Results - Cycle 2	TBD		CR76 System Test Results - Cycle 2		TBD		$ 1250000

82a		CR76 System Test Results - Cycle 8	73118		CR76 System Test Results - Cycle 8		73118		$ 13800000	93018	$ 13800000

82b		CR76 System Test Results - Cycle 8	TBD		CR76 System Test Results - Cycle 8		TBD		$ 1200000

91		CR76 Deployment Plan ndash Release 1	62218		CR76 Deployment Plan ndash Release 1		62218		$ 21450000

91b		CR76 Deployment Plan ndash Release 1	TBD		CR76 Deployment Plan ndash Release 1		TBD		$ 11550000

115		CR76 Parallel Test Results ndash Release 2	62218		CR76 Parallel Test Results ndash Release 2		62218		$ 7500000

115b		CR76 Parallel Test Results ndash Release 2	TBD		CR76 Parallel Test Results ndash Release 2		TBD		$ 7500000

158		CR76 Holdback Release 1 ($224693040)	81018		CR76 Holdback Release 1 ($224693040)		81018		$ - 0

			total CRs		$ 485249423

				$ 2747102323

		CR46	891144			24629173		ECO Note 9117 Current correct value of Accenture contract

		OKTA

HCM Project


	Cardinal HCM Analysis

				Project Life To Date

	Major Budget Category		Budget		Planned	Actual	Variance

	Internal Staff Resources		$ 1331432		$ 988809	$ 776250	$ 212559

	Contractual Services		$ 5796104		$ 4701310	$ 3942736	$ 758575

	Software and Tools		$ 5000		$ - 0	$ - 0	$ - 0

	VITA Comprehensive		$ 217588		$ 157588	$ 57500	$ 100089

	Telecommunications		$ 110482		$ 80482	$ 20455	$ 60027

	IV and V		$ 24000		$ 24000	$ 11890	$ 12110

	Other		$ 415393		$ 306191	$ 113101	$ 193091

	Contingency		$ 1100000		$ - 0	$ - 0	$ - 0

	Total		$ 9000000		$ 6258381	$ 4921931	$ 1336451


Payroll Project


	Cardinal Payroll Project

				Project Life To Date

	Major Budget Category		Budget		Planned	Actual	Variance

	Internal Staff Resources		$ 1739341		$ 1739341	$ 1852871	$ (113530)

	Contractual Services		$ 30815187		$ 30516555	$ 29984813	$ 531742

	Software and Tools		$ - 0		$ - 0	$ - 0	$ - 0

	VITA Comprehensive		$ 383042		$ 368042	$ 363423	$ 4619

	Telecommunications		$ 142117		$ 133117	$ 138767	$ (5650)

	IV and V		$ 44283		$ 44283	$ 56173	$ (11890)

	Other		$ 676030		$ 652318	$ 627544	$ 24774

	Contingency		$ 200000		$ - 0	$ - 0	$ - 0

	Total		$ 34000000		$ 33453656	$ 33023592	$ 430064


Totals


	Cardinal Payroll and HCM Analysis Projects Total

		Total Project		Project Life To Date

	Major Budget Category		Budget		Planned	Actual	Variance

	Internal Staff Resources		$ 3070773		$ 2728150	$ 2629121	$ 99029

	Contractual Services		$ 36611291		$ 35217865	$ 33927549	$ 1290317

	Software and Tools		$ 5000		$ - 0	$ - 0	$ - 0

	VITA Comprehensive		$ 600630		$ 525630	$ 420923	$ 104707

	Telecommunications		$ 252599		$ 213599	$ 159222	$ 54377

	IV and V		$ 68283		$ 68283	$ 68063	$ 220

	Other		$ 1091423		$ 958509	$ 740645	$ 217865

	Contingency		$ 1300000		$ - 0	$ - 0	$ - 0

	Total		$ 43000000		$ 39712037	$ 37945523	$ 1766514


		43000000

		$ 0

Item	Amount	Comment

Amount Spent as of FYE 2019	$ 42500000	Original Payroll Project HCM Analysis

Additional HCM Project Costs	79320000	Required to complete implementation

Move to Oracle Cloud Costs	10000000	Required for HCM

Total Projected Costs	$ 131820000

Current Working Capital Advance (WCA)	(82400000)

Additional WCA Required	$ 49420000

Milestone	Planned Start Date	Actual Start Date		Planned End Date	Actual End Date

Planning and Analysis	52019	52019		61419	62119

Design	52019	52019		101819	101819

Construction	8519	72919		61220

Release 1 System Test	4620		11521

User Test Execution	11121		21221

Release 1 Training Delivery	11121		22621

Release 1 Go-Live	3121		3821

Release 1 Stabilization	3821		5721

Release 2 System Test	4521		7921

Release 2 Training Delivery	8221		10121

Release 2 Go-Live	10421		101221

Release 2 Stabilization	10421		12321

Project Closeout	5222		53122

RICE Type	HR	PY	TA	BN		FI		Tech		Total

New Reports	48	3	1	45		0		0		97

Existing Reports	6	57	40	20		0		0		123

New Interfaces	13	1	0	25		0		0		39

Existing Interfaces	3	8	4	13		0		0		28

New Conversions	3	0	0	3		1		0		7

Existing Conversions	5	5	7	3		1		0		21

New Extensions	29	4	2	15		4		0		54

Existing Extensions	3	15	24	3		11		8		64	Agency Survey Results Applied to New Agency Interfaces

Total	110	93	78	127		17		8		433	Interfaces	Count	Comments

					HR006 - Position Upload		26		8 of the agencies were interfacing HR006 in Payroll

					HR003 - Employee Data Upload		27		Includes two instances for VRS (agencyretiree populations are in two different systems)8 agencies interfaced in Payroll

					Position Extract		42		Includes 1 count for each DBHDS instance

					Employee Data Extract		45		Includes two instances for VRS (agencyretiree populations are in two different systems)Includes 1 count for each DBHDS instance

					Benefits Enrollment Extract		18

					Benefits Dependent Extract		13

	PeopleSoft HCM Applications	Planned use for Cardinal HCM

1	Absence Management	x

2	Benefits Solutions	x

3	Compensation

4	Directory Interface

5	eBenefits	x

6	ELM

7	ePay	x

8	HelpDesk for HR

9	Human Resources e modules included in HR applications	x

10	eDevelopment

11	eProfile	x

12	eProfile Manager Desktop

13	Global Payroll

14	Payroll for North America	x

15	Payroll Interface

16	Pension Administration

17	Performance Management

18	Recruiting Solutions

19	Succession Planning

20	Time and Labor	x

Total	20	8

Area		Cardinal PeopleSoft HCM Modules	Business Processes

Human Resources		Human Resources	Setup and Maintain Employee HR Data Administer Salary Plans Maintain Additional HR Data

	eProfile

Benefits Administration		Benefits Administration	Benefits Recon Administer Open Enrollment Administer Event Maintenance Administer COBRA ACA Reporting

	eBenefits

Time amp Attendance		Time and Labor	TampA Employee Setup TampA Capture TampA Approval and Processing Payroll Integration and Cost Allocation

	Absence Management

Payroll		Payroll for North America	Maintain Employee Payroll Data Process Payroll Post Payroll Process Payroll Costing Periodic Regulatory Reporting

	ePay

overview of the state employee workforce, compensation and …sfac.virginia.gov/pdf/general...

Documents

Modules-Reqs

PeopleSoft HCM modules

RICE

Milestones

Exec View

HCM Implementation

Payroll Project

HCM Project

SC

SOW12

SOW14

HR Estimate

Modules-Reqs

PeopleSoft HCM modules

RICE

Milestones

Exec View

HCM Implementation

Payroll Project

HCM Project

SC

SOW12

SOW14

HR Estimate

Modules-Reqs

PeopleSoft HCM modules

RICE

Milestones

Exec View

HCM Implementation

Payroll Project

HCM Project

SC

SOW12

SOW14

HR Estimate