Appendix J - Key State of Connecticut Statistics

Appendix J - Key State of Connecticut Statistics

Excel Spreadsheet - Number of Administrative Users by Agency

 Transaction Volumes - Financials

 

Parameter Value
Financials Package  
General
 
Approximate number of locations
600
Approximate total number of users
2,300
Approximate number of "sets of books" by funds
500
Overall Yearly Organizational Growth
3-4%
   
Module: General Accounting
 
Average number of journal entries per month
2,000
Approximate number of ledgers
4,700
Number of chart of accounts key fields
8 segments
Approximate number of projects
10,000
Approximate number of grants
20,000
Average number of months of GL history retained
60 mo.
Average number of months of journal entries history
60 mo.
Average number of months of actual balances history
60 mo.
Average number of months of budget history
60 mo.
Average number of months of encumbrance balances history
60 mo.
Average number of months of project history
60 mo.
Average number of months of grants history
60 mo.
   
Module: Accounts Payable
 
Approximate number of vendors
80,000
Average number of AP invoices per month
41,500
Average number of Invoices per batch
8
Average number of lines per invoice/voucher
6
Average number of scheduled payments per invoice
1.1
Average number of checks cut per month
25,000
Average number of stop payments to vendors per month
130
% of 1099 vendors
12.5% (10,000)
Average number of 1099 records per 1099 vendor
4
Average number of months of AP vendor history retained
60 mo.
Average number of months of AP invoice history retained
60 mo.
Average number of months of AP payment history retained
60 mo.
   
Module: Revenues and Receipts
 
Average number of customers
12,000
Average number of invoices issued per month
15,000
Average number of receipts per month
15,000
Average number of drafts per month
5,300
Average number of direct debits per customer per month
2
Average number of months customer history
60 mo.
Average number of months of receivables history
60 mo.
Average number of months of payment retention
60 mo.
   
Module: Asset Management
 
Approximate number of asset records
675,000
Approximate number of books
5
Approximate number of depreciation books maintained
5
Approximate number of leases
600
Approximate number of departments/agencies
100
Number of chart fields
6
Approximate number of transfers per year
10,500
Approximate number of additions per year
32,000
Approximate number of Retirements per period
4,600
Average asset life (yrs)
10 yrs for Equip
40 yrs for Bldgs
   
Module: Projects and Grants
 
Average number of Accounting Entries created per month
8,500
Average number of projects & grants
30,000
Average Project Length
60 mo.
Average number of Costing Transactions per month
10,000
Average number of Billing Transactions per month
2,000
Average number of hierarchical rollup structures per month
30,000
Average number of manual transactions in Projects per month
500
Average number of Externally Interfaced Transactions per month
300
Average number of months of Transaction history retained
60 mo.
   
Module: Purchasing
 
Approximate number of Items
250,000
Approximate number of Vendors
57,000
Average number of Vendors per Item
4
Averaged number of Addressees per Vendor
2
Average number of Requisitions per month
5,000
Average number of Purchase Orders per month
10,000
Average number of Solicitations per month
3,000
Average number of Quotes/Bids per month
3,000
Average number of Lines per Receipt
8
Average number of months of Transaction history retained
48 mos
Average number of Purchase Order Lines per Purchase Order
4
Average number of Distribution Lines per Purchase Order Schedule
1
Average number of Requisition Lines per Requisition
4
Average number of Requisition Schedules per Requisition Line
1
Average number of Distribution Lines per Requisition Schedule
4
Approximate % of 1099 Vendors
12.5% (10,000)
Average number of 1099 records per 1099 vendor
1
Approximate number of Commodity Codes
1,100
Average number of Purchase Cards on File per month
12,000
Approximate number of Agencies using purchase cards
126
Average number of Purchase Card Transactions per month
1,260
Average number of Contract Documents created per year
65,000

Transaction Volumes - HRMS

Parameter Value
Human Resources Package  
General
 
Approximate number of locations
320
Approximate total number of users
2,100
Overall Yearly Organizational Growth
3-4%
   
Module: Payroll
 
Approximate number of employees
75,000
Number of Pay Periods per year
26, 24, 12
Average number of Checks per Year
800,000 cks
Approximate number of Direct Deposits per month
90,000
Approximate number of W-2s issued per year
90,000
Number of earnings types
97
Number of deduction types
146
Payroll processing done in house?
Yes
Payroll runs
2 batches done bi-weekly
Current time to run payroll (hh:mm)
8.5 hrs run time + print time
Expected time to run payroll (hh:mm)
2-4 hrs run time
Number of salary calculations run per month and time frame
12 runs - 6 hrs total run time
Approximate number of salary calculations per run
75,000
Approximate number of retroactive calculations/transactions per payroll
Max 18,000 / Avg 10 - 3,600
Average number of adjustments per payroll
Max 100 / Avg 50
Number of years of history retention
7
Average number of pay checks per employee per pay period (regular, overtime, bonus, etc.)
1
Average number of earnings an employee will have on the pay stub. (e.g. Regular, Overtime, Premium)
7
Average number of employee and employer deductions per check e.g. Parking, Charity, 401k, union dues, etc.
ee deds only - avg 4 excl. taxes (allows for 17)
Average number of Taxes an employee will have on the Pay Stub (Federal withholding, FICA, OASDI, State withholding, State OASDI)
3 (FICA/med combined)
Average number of labor department or accounts charged for earnings per check
Max 20 / Avg 4
Average number of Positions, Agencies or Pay groups an employee can be active at the same time
1.1
   
Module: Benefits Administration
 
Approximate number of benefit Packages
25
Length of open enrollment period
5 weeks
Benefits enrollment in house?
Yes
Exception processing y or n
Yes
Audit trails y or n
Yes
Years of history retention
7
   
Module: Personnel Administration
 
Approximate number of users
570
Amount of HR information captured
54,597 Appt. Records
Amount of HR history kept
1,742,365 appt. records
Approximate growth Rate
103 per month
Approximate number of ad hoc HR reports run per day
100
Average number of Positions per employee
1.001
Average number of changes per Empl-Position per year
3
Approximate number of new hires/month
456
Average number of job applicants per month
2,557
   
Module: Time and Attendance
 
Approximate number of employees
75,000
Approximate number of time and attendance transmissions
600,000 / pay period
Approximate number of time entries by employees per period
0-30
Average number of tasks per day
2
Average number of earnings per day
2-3
Average number of expenses reimbursement requests/pay period
1,400
Number of years of historical data retention
Duration of employment plus 30 years

Table of Contents
Index of Comptroller's RFPs
Comptroller's Home Page