Laserfiche WebLink
CITY OF SANTA ANA <br /> h. Reporting capability on position changed between different budget versions and <br /> scenario analysis. <br /> i. Calculate Full-Time Equivalent (FTE) counts by departments and divisions and display <br /> FTE counts in forms, reports, and published documents. <br /> j. Calculate percentage-based benefits using total wages. <br /> 4. General Budget Development <br /> a. Enter revenue estimates and expenses by account, fund, department and program. <br /> b. Model multiple years of forecast data of revenues and expenses utilizing methods such <br /> as trend analyses, Consumer Price Index (CPI), contracted services and commodities <br /> with varying annual percent increases. <br /> c. Automate consolidation of departmental budgets into one consolidated budget. <br /> d. Stage and lock scenarios in the software throughout the budget process as the budget <br /> moves from department requested and throughout the approval process. <br /> e. Roll up revenue and expense data to the fund and/or functional area. <br /> f. Provide an audit trail for data entry that records prior field values, user who made the <br /> change and the date/time of the change. <br /> g. Populate next year's budget using growth assumptions applied to the prior year budget. <br /> h. Allow users to enter and edit text, financial or performance information (i.e. paragraph, <br /> tables, graphs) and maintain version control of the document components. ) <br /> 5. Data Visualization and Transparency <br /> a. Data visualization tool that provides stakeholders with budget information via interactive <br /> charts, bars and graphs. <br /> b. Includes text descriptions and information pop-ups and multimedia capabilities <br /> c. GIS Mapping Capabilities <br /> d. Publish multi-year actual performance data online in graphical form <br /> e. Dashboard and other graphical display of performance data <br /> 6. Reporting Requirements <br /> a. Flexibility in generating custom reports including creating ad hoc reports. <br /> b. Drill down from summary level data and/or detail data imported from the General Ledger <br /> in forms and reports <br /> c. Report template development and built-in templates for standard government reports <br /> d. Publish or export reports in multiple forms including but not limited to Excel, Word, <br /> PowerPoint, CSV, PDF, HTML, and XML <br /> e. Display report data in graphical forms <br /> 7. Workflow Capabilities <br /> a. Set workflow notifications as follows: <br /> i. Allows for approvals and status of budget preparation <br /> ii. Process to move documents, e.g., position requests, through the process <br /> iii. Know the status of a budget request <br /> iv. Reject the submission of an unbalanced budget <br /> v. Customize each individual user's view <br /> vi. Support the City's accounting structure and various roll-ups <br /> vii. Includes comments or notes function <br /> viii. Include attachments of supporting documents <br /> ix. Allows for reviewers and approvers to comment on decision of budget change <br /> requests. <br /> x. Provides for email notifications to relevant users <br /> 8. Budget Monitoring Features <br /> a. Comparative analysis of budget to actuals (e.g. prorated year-end projections, historical <br /> trend analyses) <br /> b. Display of actual expenditure and revenue data by month, quarter, and year <br /> City of Santa Ana RPP No.25-020 Page 17 of 32 <br />