Response-Form-3-Functional-Requirements.xlsx
XLSX spreadsheet 314 KB Posted
- Solicitation number
- RFP 26-00268-AHAC
- Issued by
- Philadelphia County, Philadelphia City, Pennsylvania
About this file
This document is a functional requirements response form for SEPTA's (Southeastern Pennsylvania Transportation Authority) ERP Implementation & Integration Services RFP, specifically covering Finance module requirements. The spreadsheet contains detailed functional requirements organized by main process areas including Budgeting & Planning, Grants Management, Project Management, Fixed Assets, Treasury & Cash Management, and Accounts Payable. Proposers must evaluate each requirement using standardized response codes (Y for standard out-of-box, C for configurable, F for future release, 3 for third-party solution, N for not supported/custom) and provide module names, customization complexity ratings (High/Medium/Low), and mandatory comments for non-standard responses. Selected requirements are marked for live demonstration during vendor presentations, with specific focus areas including budget consolidation, capital planning, grant tracking, project lifecycle management, asset capitalization, cash flow forecasting, and compliance reporting.
The requirements emphasize SEPTA's need for comprehensive grant management capabilities including tracking multiple funding sources (Federal, State, Local), compliance with Uniform Guidance and OMB requirements, SEFA reporting for federal grants, and integration across financial modules. The system must support SEPTA's multimodal transportation operations with capabilities for tracking capital projects through complete lifecycles, managing work-in-progress and assets under construction, handling complex depreciation scenarios, processing federal reimbursement requests, and maintaining audit trails for grant-funded assets. Requirements specify integration touchpoints with external systems including HR, Payroll, Purchasing, Time & Labor, and GIS, while supporting SEPTA's organizational hierarchy (departments, divisions, clients, cost centers) and multiple fiscal year reporting periods (SEPTA fiscal year, Federal fiscal year, State fiscal year). The document establishes that proposers must preserve all requirement IDs and structure without modification, address both Required and Preferred priority items, and provide complete transparency in capability responses to support SEPTA's evaluation process.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Response-Form-1-QA-Submission.xlsx | XLSX spreadsheet | |
| Attachment-03B-Software-Price-Proposal.xlsx | XLSX spreadsheet | |
| RFP-26-00268-AHAC-for-ERP-Software-and-Implementation-Services.pdf | ||
| Exhibit-C-Reports-Inventory.xlsx | XLSX spreadsheet | |
| Appendix-2B-Exit-Services.pdf | ||
| Attachment-03A-Price-Proposal-for-SI-Services.xlsx | XLSX spreadsheet | |
| Invitation-to-Propose-ERP-SI.pdf | ||
| Response-Form-2-Proposer-Information.xlsx | XLSX spreadsheet | |
| Appendix-2C-Performance-Management.pdf | ||
| Exhibit-B-Key-Personnel.pdf | ||
| Response-Form-4-Non-Functional-Requirements.xlsx | XLSX spreadsheet | |
| Exhibit-A-Applications-Interfaces-Inventory-1.xlsx | XLSX spreadsheet |
Show all 12
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| SEPTA ERP Implementation & Integration Services |
| Response Form 3: Functional Requirements — Instructions & Proposer Guidance |
Proposers responding to SEPTA's RFP must use the guidance provided in this sheet to review and respond to the detailed requirements in the subsequent tabs. Proposers are required to evaluate each functional requirement, designate their software capability response codes (Y/C/F/3/N), indicate customization complexity and provide concise narrative comments. Complete, accurate, and transparent responses are critical for SEPTA's proposal evaluation.
| 1. REQUIREMENT COLUMNS & VENDOR RESPONSE DEFINITIONS | |||
| Column Header | Functional Meaning & Description | Proposer Instructions & Allowed Response Values | |
| ReqID | Unique alphanumeric identifier assigned to each functional requirement. Used for cross-referencing during evaluation, vendor demonstrations, and contract scope drafting. | Pre-populated by SEPTA. Proposers must NOT modify, renumber, or delete any ReqID. | |
| Main Process / Topic | High-level operational functional domain or sub-system within SEPTA's organization structure. | Pre-populated by SEPTA. Categorizes the requirement within the functional hierarchy. | |
| Sub-Process / Topic | Specific business process or workflow area under the Main Process. | Pre-populated by SEPTA. Defines the granular functional area. | |
| Requirement | Detailed description of the specific software functionality, technical interface, compliance rule, or operational feature required by SEPTA. | Pre-populated by SEPTA. Read carefully to assess software capability. | |
| Would like to see in a demo | |||
| (Demo Readiness) | Indicates SEPTA's preference to see a demonstration of this capability during vendor oral presentations and software demonstration sessions. Additional details on a potential demostration agenda will be provided at a later date. SEPTA reserves the right to add additional capabilities / use cases to the demo agenda. | Pre-populated by SEPTA: |
• X — Indicates SEPTA's preference to see capability demonstrated in oral presentation / demonstration
| Priority | |
| (Pref or Req) | SEPTA's baseline priority level for the requirement: |
• Req (Required): Mandatory capability required for core operational go-live.
| • Pref (Preferred): Highly desirable capability; evaluated for value-add and operational optimization. | Pre-populated by SEPTA. Proposers must address both Required and Preferred items. | |
| Solution Response Code | ||
| (Y / C / F / 3 / N) | Primary compliance rating code indicating how the proposed solution satisfies SEPTA's requirement. | Proposers MUST enter exactly ONE of the following codes for every row: |
• Y — Standard Out-of-the-Box: Fully supported in current commercial release without code modification.
• C — Configurable: Supported via standard system setup/tables/tools without custom coding.
• F — Future Release: Supported in a future release (must specify target release date in Comments).
• 3 — Third-Party / ISV: Provided via integrated 3rd-party software (must specify product name in Comments).
• N — Not Supported / Custom: Not available or requires custom code modification.
| Module/ Solution | Identifies the specific software module, application suite component within the proposer's proposed architecture that satisfies and delivers the requirement. | Proposers must specify the exact software product, suite component, or module name providing the requested capability for each requirement line item. | |
| Customization Complexity | |||
| (H / M / L) | Estimated level of effort/complexity to deliver the requirement if rated C, F, 3, or N. | Proposers must enter one of the following: |
• L — Low: Minor parameter setup, standard report, or simple workflow.
• M — Medium: Moderate configuration, multi-step workflow, or standard API setup.
• H — High: Complex custom software development, custom data schema, or bespoke integration.
• Leave Blank if Response Code is 'Y' (Standard).
Comments Explanatory notes, assumptions, software module names, partner products, or technical clarifications regarding the requirement response. MANDATORY for any row coded C, F, 3, or N.
• For 'C': Explain configuration effort.
• For 'F': State committed release date.
• For '3': Name 3rd-party product & integration method.
• For 'N': Describe proposed workaround, if any.
| 2. GENERAL PROPOSER INSTRUCTIONS & COMPLIANCE RULES | |
| 1. Single Response Code: | Proposers must provide exactly ONE response code (Y, C, F, 3, or N) per requirement line item. Blank responses or dual codes will be scored as non-compliant. |
| 2. Mandatory Narrative Comments: | Any requirement marked as Configurable (C), Future Release (F), Third-Party (3), or Not Supported (N) MUST include explanatory narrative in the Comments column. |
| 3. Sheet Preservation: | Do not delete, insert, reorder, or alter rows, columns, requirement descriptions, or ReqIDs in the requirements tab. |
Finance SEPTA ERP Implementation & Integration Services
| One Response Per Requirement | Module/ Solution | Customization Complexity | Comments | |||||||
| # | Main Process/ Topic | Sub-Process / Topic | Requirement | Would like to see in a demo | Priority | |||||
| Pref or Req | Y | C | F | 3 | N | H / M / L | ||||
| FA.BP.001 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to rollover or re-program unused project dollars into other projects and track the dollars based on the original and rollover/reprogram projects over multiple years. This includes the ability to manually perform or bypass the rollover process in sync with grant accounting process. | Req | ||||||
| FA.BP.002 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall support reorganization by moving and merging all actual, budget, and historical data when an entity is renumbered. | Req | ||||||
| FA.BP.003 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to transfer budget funds between accounts/account groups/summary values with appropriate audit trail (for example, budget transfer journals) in sync with grant accounting process. | Req | ||||||
| FA.BP.004 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to automatically roll forward unused budgets into next budget year in sync with Grant Accounting. | Req | ||||||
| FA.BP.005 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to develop and save budgets based on a stage in the budget development cycle. | Req | ||||||
| FA.BP.006 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to manage stages reflecting multiple iterations of the Operating & Capital budget, including but not limited to "Call, Request, Tentative, Preliminary, Adopted, Amended", with the ability to track and progress from one stage to the next stage. | X | Req | |||||
| FA.BP.007 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability for each organizational unit (Client ) to develop and modify a Operating budget at any level of the organizational structure during the Request stage of the budget development process. Changes will be approved and certified via workflow. | Req | ||||||
| FA.BP.008 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to approve changes to the budgeted amounts based on a user defined process in sync with Grant Accounting. | Req | ||||||
| FA.BP.009 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability for mass changes and/or allocations across budget categories, based on user-defined criteria. | Req | ||||||
| FA.BP.010 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide ability to allow for the input and editing of specific budgeted amounts for each account by defined cost center or department. | Req | ||||||
| FA.BP.011 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to change projections for future year projections including, but not limited to, revenue and expenditure, at any time during the fiscal year. | Req | ||||||
| FA.BP.012 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall have Global Consolidation functionality (for Capital Budget - "Federal" / "State" / "Local" and for Operating Budget - "Total SEPTA" / "Department" / "Company" / "Management Center" / Bargaining Unit, i.e. union) | Req | ||||||
| FA.BP.013 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to export and merge data and text for the production of budget documents. | X | Req | |||||
| FA.BP.014 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to integrate carryover data with the budget process, including but not limited to unspent or remaining budget, open commitments & encumbrances, unpaid obligations & accruals, project balances, grants or funding balances, budget documents, budget forecasting, etc. | X | Req | |||||
| FA.BP.015 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall support tracking and storage of multiple budget versions and budget simulations for both Capex [projects] and Opex. | X | Req | |||||
| FA.BP.016 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to perform budget adjustments and transfers to an approved budget affecting the current Client fiscal year budget and to distinguish the amounts from the original budget. | Req | ||||||
| FA.BP.017 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to track transactions, including but not limited to: |
- Original budgeted revenues and expenditures
| - Adjustments to budgeted revenues and expenditures by the detailed level by transaction code | Req | ||||
| FA.BP.018 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to add, stop or change any entry during the year. | Req | |
| FA.BP.019 | Manage Budgeting & Planning | Consolidate & Revise Budgets | The system shall provide the ability to accumulate budgets, revenue or expenditures at any attribute associated with the account or organizational structure and multiple years. | Req | |
| FA.BP.020 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall be able to load budgets and projections from outside sources and calculate variances. | Req | |
| FA.BP.021 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to integrate the revenue and expense plans into short term and long term financial forecasts, incorporating the following capabilities: |
— Scenario ("What-If") Modeling
— Cash Generation
| — Capital and Expense Projects (CapEx) | X | Req | ||
| FA.BP.022 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to classify and track budgets including but not limited to: |
- Period budgets (annual vs. multi-year)
- Project budgets by planned, original, approved and required
- Character of budget (both operating vs. capital)
- Legal authority budgets (appropriated vs. financial-planning)
- Variability budgets (flexible vs. fixed)
- Other User defined criteria
- This period versus last year
- Year-to-date and quarter versus last year and last year quarter
- Year-to-date and quarter versus budget
- Variance analysis with dollars and percentages
- Consolidate multiple departments
- Departments
- Functional Units (Client/)
- Managers
- Divisions
- Cost centers
- Fund #
- Project #
- Projects/jobs responsibility reporting
- trend analysis and projections
- regression analysis
- exponential smoothing
- what-if scenarios (e.g., forecasting payroll costs based on current civil Service Titles and anticipated promotion steps, grades and dates)
- Budgeted Expenditures
| - Budgeted Revenues | Req | |||||
| FA.BP.023 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the capabilities to develop annual and multi-year Operating & Capital plans, budgets and forecasts for Client, utilizing inputs from strategy, scenario planning analysis, asset management and other core business processes, where appropriate. Measure and report on variance of forecasts to actuals. | X | Req | |
| FA.BP.024 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall allow accounts flagged for Budget use only. | Req | ||
| FA.BP.025 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall allow departments flagged for Budget use only. | Req | ||
| FA.BP.026 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support budget input from other data warehouse systems; not limited to spreadsheets (i.e., spreadsheets entered into a system once). | Req | ||
| FA.BP.027 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support multiple data types (for example, actual, budget and statistical). | Req | ||
| FA.BP.028 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to provide a budget model or framework for forecasting purposes. | Req | ||
| FA.BP.029 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to support inter-department and intra-department collaborative budget & planning process (e.g. Client s). | Req | ||
| FA.BP.030 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to support multiple calculation engines within the planning & budgeting process at the Unit level (Department/Division/Client s) | Req | ||
| FA.BP.031 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall integrate with the following modules: |
— Human Resources
— General Ledger
— Projects
— Payroll
— Cash Management
— AR
— AP
— Purchasing
— Fixed/Capital Assets
| — Grants | Req | ||||
| FA.BP.032 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to define budget worksheets based on user defined criteria. | Req | |
| FA.BP.033 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to integrate user defined budget worksheets with budget entry screens. | Req | |
| FA.BP.034 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to analyze information at any stage of the budget development cycle including, but not limited to, the following information: |
— Any level within Client's organizational hierarchy
— Prior year actual expenditures and revenue
— Prior year budget
— Carry-Over
— Current YTD actual expenditures and revenue with percentages
— Budgeted revenue and expenditures
| — Proposed budget amount - adopted and adjusted (multiple years) | Req | ||||
| FA.BP.035 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall capture the assumptions that were made when developing the different Budget Planning scenarios. | Req | |
| FA.BP.036 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to maintain a budget history at a department (Client ) and at the enterprise level. | Req | |
| FA.BP.037 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to maintain budget narrative with the ability to export into word processing tools. | Req | |
| FA.BP.038 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to produce the budget document and all reports in PDF and Excel formats, and view in a web browser. | Req | |
| FA.BP.039 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to include in the budget document organizational unit data at any level of the organizational structure including, but not limited to: |
— Objectives
— Accomplishments
— Graphics
— Text
— Organization Charts
— Financial charts and graphs
| — Table | Req | ||||
| FA.BP.040 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide annotation of changes and revisions. | Req | |
| FA.BP.041 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to generate budgeted expenditures and revenues in comparison to prior year actual and budgeted expenditures and revenues. | Req | |
| FA.BP.042 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to generate expenditures or revenues by any level within the organizational structure to include, but not limited to, current or prior year history. | Req | |
| FA.BP.043 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to develop and manage Monthly Budget Plan based on user-defined criteria. | Pref | |
| FA.BP.044 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to establish budget revenues, expenditures, and allocations at the line item level. | Req | |
| FA.BP.045 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to project budget based upon percentage, dollar amount for each pay, benefits, enrollment, square footage, and any other user defined criteria. | Req | |
| FA.BP.046 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to "lock out" organizational units (Client ) based on user defined criteria. | Req | |
| FA.BP.047 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall take into account any Budget Planning conditions for the local, Pennsylvania state and federal financial, and regulatory requirements, including but not limited to tracking the deadline for budget submissions. | Req | |
| FA.BP.048 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to print budget reports at any level within Client, including but not limited to, the following information: |
— Prior year actual revenue and expenditures and percentage
— Any named version of the budget
— Current YTD actual revenue and expenditures
— Carry Overs
— Estimated actual
— Proposed budget (add amount - adopted and adjusted)
| — Multi-year comparisons | Req | ||||
| FA.BP.049 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support user defined flexible periods (e.g., different Client fiscal years, Client's seasonal budgets, etc.). | Req | |
| FA.BP.050 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support importing spreadsheet data from multiple sources, including but not limited to: |
— database
— other forecasts
| — models | Req | ||||
| FA.BP.051 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall have the flexibility to have multiple budget hierarchies and maintain historical hierarchies for simulation purposes. | Req | |
| FA.BP.052 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to save salary planning data for each phase of the project. | Req | |
| FA.BP.053 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to establish user-defined budgetary and cash controls that include, but are not limited to, the following levels: |
- Client Department
- Client Program
- Object
- Client Project
- Sub-Project
| - Other user defined criteria, such as Program Class and Program Category. | Req | |||||
| FA.BP.054 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to handle multiple budget entities with different closing requirements. | Pref | ||
| FA.BP.055 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall integrate with the billing module to get internal billing amounts that can be used in budget projections and creation. | Req | ||
| FA.BP.056 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to perform Position Budgeting and forecasting. Any changes to data will be saved at each stage of the budgeting process. | X | Req | |
| FA.BP.057 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide lists of last years budget, current budget, current YTD actual, prior YTD actual, projected actual, and rolling actual for user defined time horizons. |
| The system shall provide configurable reports and data views that present, for user-defined time horizons, the prior-year budget, current-year budget, current-year year-to-date (YTD) actuals, prior-year YTD actuals, projected actuals, and rolling actuals. Users shall be able to define the reporting period, fiscal year, organizational or accounting dimensions, and level of detail. | X | Req | |||
| FA.BP.058 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support financial and statistical functions. | Req | |
| FA.BP.059 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to save multiple number of forecasting models. | Req | |
| FA.BP.060 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide a Mid-Year Projection Report. | Req | |
| FA.BP.061 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the functionality to apply a probability factor to a forecast indicating the degree of confidence with a specific forecast. | Pref | |
| FA.BP.062 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support automatic forecasting adaptation based on most recent patterns and historical data. | Req | |
| FA.BP.063 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system should allow users to create forecasts both for the entire SEPTA (for example, overall staffing or budget plans) and for individual departments (for example, planning for specific roles or items); system should be flexible to generate these forecasts. | Pref | |
| FA.BP.064 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support standard forecasting calculations for Client to help identify the best fit forecast model based on historical and current data as part of the planning process. | Req | |
| FA.BP.065 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support top / down forecasting / allocation. | Req | |
| FA.BP.066 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support bottom / up forecasting percolation. | Req | |
| FA.BP.067 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support middle / out forecasting. | Req | |
| FA.BP.068 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support user defined forecasting spreadsheet formats. | Req | |
| FA.BP.069 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support multiple forecasting techniques including, but not limited to: |
— exponential smoothing
— straight line fit
— exponent forecast
| — best forecast | Req | ||||
| FA.BP.070 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system should be able to measure and report on errors in forecasts, including errors from statistical methods like forecasting and multiple regression analysis. | Pref | |
| FA.BP.071 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support tracking of forecast accuracy, including but not limited to actual versus plan. | Req | |
| FA.BP.072 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support forecasts tracking signals for forecast error and activity behind user-defined threshold levels. | Pref | |
| FA.BP.073 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support rolling forward previous period forecasts into future user-defined periods. | Pref | |
| FA.BP.074 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the capabilities to create forecasts; monitor, analyze and optimize the cash flow (receipts – expenses). | Req | |
| FA.BP.075 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide forecast techniques such as: |
- trend analysis and projections
- regression analysis
- exponential smoothing
| - what-if scenarios (e.g., forecasting payroll costs based on current civil Service Titles and anticipated promotion steps, grades and dates) | Req | |||||
| FA.BP.076 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall provide the ability to produce multi-year, long range forecasts, for user defined time horizons e.g. 12 / 20 years for Capital Budger. | X | Req | |
| FA.BP.077 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support comparison of actual historical data to the forecast for a user-defined time period. | Req | ||
| FA.BP.078 | Manage Budgeting & Planning | Create Budgetary Estimates, Plans & Forecasts | The system shall support computation types: |
— computations
— row calculation
— smoothing
— regression
| — miscellaneous | Req | |||||
| FA.BP.079 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to hold approved budget amounts against user-defined groups of GL accounts | Req | ||
| FA.BP.080 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to hold approved budget amounts against hierarchy node values | Req | ||
| FA.BP.081 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide real-time available funds checking for any expense transaction, including but not limited to GL journal entries, AP invoice entries, or other types of expenditures. | Req | ||
| FA.BP.082 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to define user-defined journal/invoice warning/rejection tolerances | Req | ||
| FA.BP.083 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to establish budget control at any level of the organizational account structure. | Req | ||
| FA.BP.084 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to record audit trail information when changes are made to budget information within a stage of the budget development cycle. | Req | ||
| FA.BP.085 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to record audit trail information when information is moved from one stage of the budget development cycle to another stage. | Req | ||
| FA.BP.086 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to manage allocations based on user-defined criteria. | Req | ||
| FA.BP.087 | Manage Budgeting & Planning | Manage Financial Performance | The system shall support comparative reporting on prior year budget history, including downloading and merging of data-to-data and/or data-to-text. | Req | ||
| FA.BP.088 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide a Budget Forecast Report for user defined time period. | Req | ||
| FA.BP.089 | Manage Budgeting & Planning | Manage Financial Performance | The system shall support automated over-budgeting checks and associated workflow notifications for over-budget items, including but not limited to payroll related expenses. | Req | ||
| FA.BP.090 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide real-time comparison of budget to actual performance by any level within the Client organizational structure and project structure. | X | Req | |
| FA.BP.091 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to prepare a budget analysis based on a calendar or Client fiscal year. | Req | ||
| FA.BP.092 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to override budget controls during processing. | Req | ||
| FA.BP.093 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide online budgetary controls of expenditures and revenues and provide automated warnings when users approach budget thresholds based on user-defined criteria. | Req | ||
| FA.BP.094 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide the ability to identify budgetary versus non-budgetary transactions. | Req | ||
| FA.BP.095 | Manage Budgeting & Planning | Manage Financial Performance | The system shall validate all financial transactions against available budget prior to posting (encumbrance accounting), with controls at fund/program/project/grant levels and cash control budgets. | Req | ||
| FA.BP.096 | Manage Budgeting & Planning | Manage Financial Performance | The system shall provide earmarked funds (reservations, pre-commitments, commitments) including forecast of revenue; consume budget at due date or posting date; substitution/derivation for budget documents; project hierarchy budget checks. | Req | ||
| FA.BP.097 | Manage Budgeting & Planning | Perform Capital Planning | The system shall Integrate with Financial Planning & Analysis for Capex budget tracking, planning, and forecasting; in sync with Grant Accounting that is the source of fund for projects | X | Req | |
| FA.BP.098 | Manage Budgeting & Planning | Perform Capital Planning | The system shall be able to support creation of different project profiles for different categories of capital improvement project [CIP] e.g. Construction of Property, Plant & Equipment, Refurbishment of Existing Fixed Asset, Dismantling & Decommissioning of Old Assets etc. | Req | ||
| FA.BP.099 | Manage Budgeting & Planning | Perform Capital Planning | The system shall be able to support creation of different project templates for each category of CIP e.g. Feasibility, Planning & Design, Construction-Installation-Commisioning ; define individual templates for better processing | Req | ||
| FA.BP.100 | Manage Budgeting & Planning | Perform Capital Planning | The system shall support the creation of a portfolio of individual projects based on criteria e.g. source of funds, departments, etc. to evaluate and prioritize for qualitative and quantitive parameters and determine allocation of funds. | Req | ||
| FA.BP.101 | Manage Budgeting & Planning | Perform Capital Planning | The system shall provide the ability to create both Capex and Opex cost elements within the same project and map to the respective fund source | Req | ||
| FA.BP.102 | Manage Budgeting & Planning | Perform Capital Planning | The system shall be able to create a network of tasks & activities that roll up into Work Breakdown Structure [WBS] elements for each project type [capital or operational]. Each task should have the following characteristics: |
- Start date & end date
- Sequence based on relationship [Start-to-Start, Start-to-Finish etc].
- Resources needed for carrying out the tasks [materials, human resrouces]
| - Cost elements mapped to cost centers | Pref | |||||
| FA.BP.103 | Manage Budgeting & Planning | Perform Capital Planning | The system shall integrate Budgeting and Grants with Projects for set-up and tracking consumption in near time so that budget controls can be effectively deployed - decisions made to move fund sources, additional funds etc. | X | Req | |
| FA.BP.104 | Manage Budgeting & Planning | Perform Capital Planning | The system shall enable monitoring investment by continuously tracking - ROI, NPV, Payback etc; configure a project level dashboard for PMO | Pref | ||
| FA.BP.105 | Manage Budgeting & Planning | Perform Capital Planning | The system should be able to support financial modeling capabilities to support scenario planning, sensitivity analysis to score risk and analyze returns to prioritize work | Pref | ||
| FA.BP.106 | Manage Budgeting & Planning | Perform Capital Planning | The system shall support capital budget plan that spans over multiple financial periods comprising material and labor costs spread | Req | ||
| FA.BP.107 | Manage Budgeting & Planning | Perform Capital Planning | The system should support the ability to plan and map multiple funding sources to a project [Capex or Opex]; manage fund flow across external (Grants) and internal (accruals) sources and establish controls for encumbrance accounting | Req | ||
| FA.BP.108 | Manage Budgeting & Planning | Perform Capital Planning | The system shall have the ability to forecast depreciation amount for pre-determined fiscal period based on capitalization as well as future investements planned; Client should be able to modify investment plan for which either a project may or may not exist | Req | ||
| FA.BP.109 | Manage Budgeting & Planning | Perform Capital Planning | The system shoud support "capital budget" carryover over financial time horizons based on unspent capital appropriations per established business rules. | X | Req | |
| FA.BP.110 | Manage Budgeting & Planning | Perform Capital Planning | The system shall provide the ability to indicate if the project is in the capital budget. | Req | ||
| FA.GM.001 | Manage Grants | Manage & Pursue Grant Opportunities | The system shall provide the ability to track grant applications by Department and/or individual requestor within SEPTA, as applicable | Req | ||
| FA.GM.002 | Manage Grants | Manage & Pursue Grant Opportunities | The system should enable pre-award opportunity intake and tracking, capturing solicitation details, eligibility criteria, due dates, proposal budgets, and submission status with role-based workflows. | Req | ||
| FA.GM.003 | Manage Grants | Manage & Pursue Grant Opportunities | The system should maintain award purpose, types, Assistance Listing Number (ALN) / Catalog of Federal Domestic Assistance (CFDA) number - needed for SEFA reporting, certifications, and terms & conditions to drive eligibility and compliance during the pursuit and award setup stages. | Req | ||
| FA.GM.004 | Manage Grants | Manage & Pursue Grant Opportunities | The system should manage sponsors and funding sources master data, contacts, proposal references, and keywords to support search and reporting across pursued and awarded grants. | Req | ||
| FA.GM.005 | Manage Grants | Manage & Pursue Grant Opportunities | The system should support proposal budget versions, indirect cost estimates, and routing of submission packages for approvals with auditable workflows. | Req | ||
| FA.GM.006 | Manage Grants | Manage & Pursue Grant Opportunities | The system should support managing pre-award activities including but not limited to: |
- Configuration of sponsor-specific rules (e.g., allowable pre-award costs, time limits, cost types)
- Enforce sponsor and institutional policies on allowable pre-award spending periods (e.g., 90 days before award)
- Workflow for requesting, reviewing, and approving pre-award spending, including justification and documentation.
- Record and track expenses incurred prior to formal award acceptance (e.g., proposal development, pre-award research activities)
| - Transferring pre-award expenses to the official award/project once funded, with proper justification and controls. | X | Req | ||||
| FA.GM.007 | Manage Grants | Manage Administration & Performance | The system shall provide a central repository to store, view ,manage and track all grants from setup through completion, including but not limited to time-based expenses (internal and external), material-based expenses, milestone-based services, expense allocations, multiple funding sources, revenue receipt tracking and grant-specific spend tracking against approval amount or budget. | X | Req | |
| FA.GM.008 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to store the grant agreement. | Req | ||
| FA.GM.009 | Manage Grants | Manage Administration & Performance | The system shall provide the functionality for accounting, tracking and reporting of revenues for grant purposes, both due and received. | Req | ||
| FA.GM.010 | Manage Grants | Manage Administration & Performance | The system shall provide functionality associated with grant reimbursement requests, and the reporting, tracking and accounting of grant receivables. | Req | ||
| FA.GM.011 | Manage Grants | Manage Administration & Performance | The system shall provide ability to track budget and cost at any level of the organizational structure by user-defined categories, including but not limited to the following: |
- Grant code/pin #
- Grant hiearchy level
- Organization hiearchy level
- Project Code
- Line item/Expense element
- Sub-task/sub-activity
| - Fund Code | Req | |||||
| FA.GM.012 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to track all salary as well as non-salary costs. | Req | ||
| FA.GM.013 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to rollover or re-program unused grant dollars into other grants and track the dollars based on the original and rollover/reprogram grants and the related projects over multiple years. This includes the ability to manually perform or bypass the rollover process. | X | Req | |
| FA.GM.014 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to record grant/cost center-related transactions by fiscal period. | Req | ||
| FA.GM.015 | Manage Grants | Manage Administration & Performance | The system shall maintain grant/cost center detail information on both a fiscal year-to-date, job-to-date and inception-to-date basis. | Req | ||
| FA.GM.016 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to record miscellaneous adjustments, reclassifications and interfund transfers associated with grants/cost centers based on role based security granted to the user. | Req | ||
| FA.GM.017 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to calculate, view and report on grant balances and/or fund code based on a user-defined time period. | Req | ||
| FA.GM.018 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to identify and structure a grant in multiple phases over multiple years with associated budgets. | Req | ||
| FA.GM.019 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to monitor the status of grant related receivables and deferrals. | Req | ||
| FA.GM.020 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to perform budgetary control checks and edits prior to entering and posting transactions. | Req | ||
| FA.GM.021 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to perform edits to determine whether transactions submitted for processing fall within time frames for which specific budgets are active and may be expended. | Req | ||
| FA.GM.022 | Manage Grants | Manage Administration & Performance | The system shall provide the ability at year end to report grants & expenses by code which have closed during the fiscal year. | Req | ||
| FA.GM.023 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to prevent costs from being charged to closed grants or closed grant phases. | Req | ||
| FA.GM.024 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to retain original budget and budget changes detail through the grant life. | Req | ||
| FA.GM.025 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to track grants by, including but not limited to, the following information: |
- Department/Division/Sub unit
- Fund code
- Grant code/pin #
- Line item/Expense element
- Grant manager
- Grant phase
- Granting Agency
| - CFDA Number | Req | ||||
| FA.GM.026 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to retain all accounting transactions relating to grants online throughout the grant life. | Req | |
| FA.GM.027 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to display a warning message when trying to close a grant with outstanding charges, open or outstanding purchase orders, or which has been over expended. | Req | |
| FA.GM.028 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to reject transactions that would result in expenses exceeding the authorized grant budget; the system shall allow for different workflows based on OPEX (rejection) or CAPEX (authorization / review required) | Req | |
| FA.GM.029 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to compare actual expenditures to forecasts across different financial periods e.g.SEPTA's fiscal year, Federal fiscal year | Req | |
| FA.GM.030 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to establish multiple contracts and POs under a single grant. | Req | |
| FA.GM.031 | Manage Grants | Manage Administration & Performance | The system shall provide access to multiple years of data. | Req | |
| FA.GM.032 | Manage Grants | Manage Administration & Performance | The system shall provide layers of cost centers (e.g., department, location) that roll up to an unlimited number of summary totals with totals by any level within the organizational structure. | Req | |
| FA.GM.033 | Manage Grants | Manage Administration & Performance | The system shall support both Capital and Operating Expense accounting functionality for Grant Management. | Req | |
| FA.GM.034 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to designate or assign Grant Administrator(s) to specific grant projects and allow Grant Administrators to access information only from the grant projects they are assigned to | Pref | |
| FA.GM.035 | Manage Grants | Manage Administration & Performance | The system shall provide capability to track and report on grant budget vs. actuals at the detailed budget level | Req | |
| FA.GM.036 | Manage Grants | Manage Administration & Performance | The system shall provide tracking, automated alerts and reporting capabilities sent / made available to authorized SEPTA employees associated with the grant, included but not limited to: |
— Grant completion due date (i.e., early warning of grant due date; substantial grant budget amounts remaining)
— Quarterly Grant Progress
— Grant Goal Compliance / Utilization (e.g., MWBE, SDVOB, Davis-Bacon, Buy America, DBE, etc.)
| — Grant Final Close Out | X | Req | ||||
| FA.GM.037 | Manage Grants | Manage Administration & Performance | The system shall provide early alerts of potential grant over-spending (e.g., higher actual vs. planned burn rates while still within overall budget) and significant variances that could impact period-end financial reporting and disclosures. | Req | ||
| FA.GM.038 | Manage Grants | Manage Administration & Performance | The system shall provide robust out-of-box, ad-hoc (user controlled) queries, and dashboard reporting to show grant health. Allows ability to show portfolio view by business unit, department, owner, grant category, grant type, etc. | Req | ||
| FA.GM.039 | Manage Grants | Manage Administration & Performance | The system shall provide a master grant listing, including status information (e.g., open, closed) and PDF and MS Excel grant status report export capability. | Req | ||
| FA.GM.040 | Manage Grants | Manage Administration & Performance | The system shall provide a grant listing, including but not limited to the project manager, department/division, organizational unit, grant number/name, total budget cycle, outstanding POs, reimbursement invoices, (grant) revenue & expenses to date/percent, expended this month, percent complete by phase, remaining, contract, phase, etc. | Req | ||
| FA.GM.041 | Manage Grants | Manage Administration & Performance | The system shall provide grant, and cost center (e.g., project, department) detail transaction reports, including but not limited to, grant number/name, grant manager, transaction date, reference number/source, entered by, journal entry number, transaction code, vendor, year(s), period(s), invoice/receipt, description, PO number, check number, amount and outstanding POs, comparisons of actual to budget, available by revenue and expense categories by period or year to date as requested, by Fund etc. | Req | ||
| FA.GM.042 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to separate prior year expenditures and prior year budget by Fund Code for generally accepted accounting principles (GAAP) reporting, Federal fiscal year, State fiscal year, calendar year, etc. (view life-to-date budget, remaining budget, single year and monthly, etc. for GAAP reporting). | Req | ||
| FA.GM.043 | Manage Grants | Manage Administration & Performance | The system shall produce status reports by grant and cost center (e.g., department) for any time period, including detailed revenues and expenditures. | Req | ||
| FA.GM.044 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to generate financial reporting and payment requisition forms by any level within the organizational structure, by grant number and other unique identifiers. | Req | ||
| FA.GM.045 | Manage Grants | Manage Administration & Performance | The system shall provide year-to-date grant information. | Req | ||
| FA.GM.046 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to report fiscal year-to-date expenditures and allocations for multiple year grants. | Req | ||
| FA.GM.047 | Manage Grants | Manage Administration & Performance | The system shall support creation of the SEFA reports required for Federal Grants as required by the OMB (Circular 133A) as well as Federal & State requirements | X | Req | |
| FA.GM.048 | Manage Grants | Manage Administration & Performance | The system shall provide workflow enabled to support transparency, approvals and visibility to status of grant creation and approvals. | Req | ||
| FA.GM.049 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to capture grant attributes such as: grant requestor (department), grant type, grant category, grant description, grant owner, and grant amount, grant agency and Project Manager. | Req | ||
| FA.GM.050 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to indicate whether this is for asset replacement so that this triggers notification of asset disposal. | Req | ||
| FA.GM.051 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to capture expected grant start date and completion/expiration date to obtain an NTE extension to use the funds. | Req | ||
| FA.GM.052 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to indicate if the grant is in the capital budget. | Pref | ||
| FA.GM.053 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to assign a valid expense element to the grant. | Req | ||
| FA.GM.054 | Manage Grants | Manage Administration & Performance | The system shall support reusable grant templates based on grant type. Will automatically create template when grant type is entered. | Req | ||
| FA.GM.055 | Manage Grants | Manage Administration & Performance | The system shall integrate with A/P for grant booking of expenses when invoices paid and integration with cash receipts/revenue for booking revenue. (separate from other operating expenses and revenue) | Req | ||
| FA.GM.056 | Manage Grants | Manage Administration & Performance | The system shall integrate Grants to Projects and finally Fixed Assets to account for / trigger asset valuation, asset disposal, depreciation start and asset transfers. | Req | ||
| FA.GM.057 | Manage Grants | Manage Administration & Performance | The system shall integrate with Financial Planning & Analysis for capital expenditure budget tracking, planning, and forecasting. | Req | ||
| FA.GM.058 | Manage Grants | Manage Administration & Performance | The system shall integrate with time entry system (either external or part of your solution) and provide the ability to view and print the actual employee time card (with redacted personnel information) to attach to grant-related payment reimbursement requests. | Req | ||
| FA.GM.059 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to track hours expended for all grants by organizational unit, pay period, employee, contractor, account number, etc. | Req | ||
| FA.GM.060 | Manage Grants | Manage Administration & Performance | The system shall provide ability to retrieve data from historical time period or closed grants. | Req | ||
| FA.GM.061 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to track all labor and benefits costs reported on timecards and entered into a time system that is integrated. | Req | ||
| FA.GM.062 | Manage Grants | Manage Administration & Performance | The system shall provide the ability to track SEPTA Employee Time for all grants by grant project code through integration with the Time & Labor Module. | Req | ||
| FA.GM.063 | Manage Grants | Manage Administration & Performance | The system shall manage full grant lifecycle with allowable cost rules, indirect rate tracking, alerts for overspending and compliance violations, and SEFA/federal reporting. | Req | ||
| FA.GM.064 | Manage Grants | Manage Administration & Performance | The system shall support tracking fringe amounts charged to projects (benefits based on labor costs, calculated based on a pre-determined fiscal year rate) with the ability to override for some projects | Pref | ||
| FA.GM.065 | Manage Grants | Manage Award & Oversight | The system should enable award lifecycle management with statuses and amendments (funding, dates, terms), including validation rules and audit trails. | Req | ||
| FA.GM.066 | Manage Grants | Manage Award & Oversight | The system should provide award templates and interactive funding matrices to preview/add funding per period and sponsored project while preventing overspending with budget checks at point of entry. | X | Pref | |
| FA.GM.067 | Manage Grants | Manage Award & Oversight | The system should integrate grant account assignment into projects/WBS with one-to-one and many-to-many relationships, posting to the universal ledger without reconciliation. | Req | ||
| FA.GM.068 | Manage Grants | Manage Award & Oversight | The system should support multi-sponsor and multi-award funding patterns, distribute payroll using labor schedules, and allocate project costs based on award funding patterns. | Req |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .