Ability to use modeling tools to leverage historical data in order to create spending plans Required Ability to support zero-based budgeting Required Ability to allocate charges based on statistical criteria in order to create revenue and expenditure budgets Required Ability to use performance measures or statistical values to allocate amounts to specific chart of accounts components Required Ability to allocate amounts based on the relative distribution of other data Desired Ability to provide a budget pool for a particular class of expenditures. Required Ability to adjust cash flow forecasts Required Ability to provide financial projection tools to forecast data based on user-defined formulas Required Reorganizations Required The ability to change accounting structures associated with proposed reorganizations centrally and by agency without affecting existing accounting structures Required Ability to make structural modifications (including name changes) to take effect on a future date Required Ability to automatically integrate new data keyed to original structure to the new structure after a reorganization, COA change etc. Required Personnel Budget Management Required Ability for multiple employees to be assigned to a single position record at the same time Required Ability to vacant, filled, authorized, funded, and unfunded positions Required Ability to use start and end dates associated with positions to generate salary and benefit cost projections Required Ability to provide flexibility to project salary and benefit costs for new positions by pay band or by entered salary Required Ability to override individual benefit defaults by position Required Ability to calculate average salary increases for defined staff categories during budget development, including effective dates Required For each position, ability to budget hours or percent by Agency, program, object, etc., using all levels of the CoA Required Ability to budget salaries and benefits by position description code Required Ability to provide a methodology for calculating FTE, taking into consideration starting and ending dates, funding percentages, and hours per day Required
Ability to automatically populate Required Ability to provide the capability to lock or unlock budget forms for data entry by budget phase and user Required Ability to support entry of a legal section symbol (§) in text fields Desired Ability to provide text fields that support spell checking with a custom dictionary Required Ability to attach documents to forms Required Ability to make notation comments to both line items and the total budget Required Ability to provide text formatting controls such as font type and size, paragraph, indentation, numbering and bulleting, bold, italics and underline Required Reporting and Publication Required Ability to design report formats without the need for computer programming expertise Required Ability to design report layouts to include customization of page size, page orientation, page margins, page headers, page footers, page numbering, font size, colors, inclusion of graphics, and data field labels Required Ability to sort or filter by any data object including but not limited to Budget Cycle Phase, Budget Scenario, Fiscal Year, Calendar Year, Agency, Unit, Program, Object, Comptroller Object/Agency Object, Fund Type, Fund Source, Approval Status or any other data or calculated field within scope of the report Required Ability to pre-define the default data sort (ascending and descending), and filter settings included within the report by data dimensions including but not limited to Budget Cycle Phase, Budget Scenario, Fiscal Year, Calendar Year, Agency, Unit, Program, Sub-Program, Object, Comptroller Object/Agency Object, Fund Type, Fund Source, Approval Status or any other data or calculated field within scope of the report Required Ability to calculate variance of any data values irrespective of budget fiscal year, data source or approval status Required Ability to calculate trend lines for multiple years’ data, including current year variance from trend Desired Ability to determine whether line items not included in filter are included in section totals Desired Ability to format individual elements on the report (font, bold, italic, size, color, currency signs, commas, etc.) Required Ability to specify numeric rounding by element, including decimals, numbers, thousands, and millions. Required Ability to indicate non-zero numbers below the rounding threshold Desired Ability to define conditional formatting background, color) for data values included in the report Desired Ability to combine data fields and calculated values Required Ability to support drill-down where summary data is composed of detailed information Required