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