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