Statement_of_Work_(SOW)_-DRAFT_7-16-2019_SCN_Review_7.26.19.pdf

ATTACHMENT 0001

STATEMENT OF WORK

GRANT ACCRUAL SUPPORT

BACKGROUND

The Federal Transit Administration (FTA) is one of the eleven modals of the United States (U.S.) Department of Transportation (DOT) which has a mission to “serve the United States by ensuring a fast, safe, efficient, accessible and convenient transportation system that meets our vital national interests and enhances the quality of life of the American people, today and into the future.

The FTA Office of Budget and Policy (TBP) administers all audit and internal controls, overall strategic planning and program review, performance management, policy, budget, program development, and financial and accounting control matters. This includes providing policy direction on legislation and regulations that relate to public transportation programs. TBP is also responsible for the formulation and execution of the FTA’s $9 billion annual budget and ensures that appropriated funds are obligated and expended in accordance with Executive Branch and congressional intent. TBP is also responsible for managing the development and implementation of the FTA strategic and program planning process, including the review and evaluation of programs to determine their effectiveness in meeting the U.S. Department of Transportation’s and FTA’s strategic goals and objectives.

The CFO (Chief Financial Officer) Act of 1990, as amended requires all Federal government agencies to submit financial statements on an annual and quarterly basis. The Office of the Secretary of Transportation (OST) required all Operating Administrations (OA) to submit their financial statements on a monthly basis (by the 10th day of the following month). The Office of Management and Budget (OMB) has also mandated that all Federal agencies submit their audited financial statements by November 15th of each year. In addition, the departmental CFO mandated the requirement for the development and maintenance of procedures to establish an accrual process for FTA grant awards for monthly financial statements beginning May 2003.

The purpose of this effort is to provide assistance with financial statement preparation and support services for the grant accrual estimation and validation process. This will assist FTA to comply with policies mandated by the CFO, and support the accelerated due dates for agency submission of unaudited financial statements and related packages imposed by U.S. DOT Office of the Secretary (OST), OMB, and U.S. Treasury. This effort will assist in ensuring that FTA can submit all required financial statements in a timely manner.

DESCRIPTION/SPECIFICATIONS

1. Assessment of Financial Data for Determining Monthly Grant Accrual:

• Review the current method for developing estimated accrual for grant liabilities and expenditures, and make changes, if necessary,

• Obtain the necessary cumulative grant obligations and disbursements reports as of the end of the period. Using the existing grant accrual methodology, calculate the monthly grant accrual estimates and prepare adjusting journal entries to be recorded in the general ledger for each appropriation account for financial statements and other monthly reporting.

• Perform revalidation of the Grant Accrual Methodology every three years using the pre-established procedures to survey a representative sample of grantees to obtain information about changes to their billing pattern and other information needed to enhance the methodology.

2. Validation of Grant Accrual Liabilities Estimate

• FTA has over 6000 active grants and cooperative agreement projects. Grantees are mandated by OMB guideline to submit quarterly SF 425 Federal Financial Reports (FFR) within 30 days after the end of the quarter. One of the key information that the grantees provide on the FFR for each grant project is the cumulative federal expenditures which grantees reports using the accrual basis of accounting (combination of paid and unpaid expenses). Additionally, FTA maintains a report with shows cumulative payments to the grantees by projects.

• Perform a look-back analysis on a quarterly basis, utilizing the expenditure information on the grantees’ quarterly FFR and the cumulative grants payments report to calculate FTA’s grants liabilities and compare it the estimated grant accrual liabilities presented in the financial statements to validate its reasonableness. Research and provide explanation for variances greater than 10 percent.

3. Reporting to the DOT OST on FTA’s portion of the DOT Consolidated Financial Statements:

• Assist with performing quarterly financial statements fluctuation (flux) analysis after all quarter-end adjustments and journal entries have been posted in the general ledger and financial statements has been generated.

• Assist with preparation of ad-hoc financial reports from the accounting system.

• Assist with researching other federal accounting issues that may arise during the financial accounting and reporting cycle related to the preparation of the financial statements.

3. Assistance in coordinating financial audits and reviews within the Office of Financial Management:

• Work with Office of Inspector General (OIG) contractor or FTA internal control review contractor to provide all documentation requests relating to the grant accrual process are provided in a timely manner.

• Develop corrective action plan to resolve audit or review findings relating to the grant accrual process.

INSPECTION AND ACCEPTANCE

The contractor will be required to comply with the requirements contained in description of tasks above. In addition, the contractor will be required to meet all schedules contained under “Deliveries or Performance” below. The COR will inspect the grant accrual methodology, monthly grant accrual calculations, and financial reports. If approved by the COR, acceptance will occur.

DELIVERIES OR PERFORMANCE

1. SCHEDULE AND DELIVERABLES

Throughout the process, the contractor will interface with the FTA Office of Financial Management staff, the OST, and the OIG auditors to address their questions and concerns about the financial data and audit related issues.

2. Deliverables and work products:

• Prepare grant accruals for review and approval by the designated Office of Financial

Management staff prior to final month-end trial balance.

• Assist the Office of Financial Management with coordination of the annual CFO Financial Statements audit due by November 15th.

• Assist the Office of Financial Management with coordination of Annual OMB Circular

A-123, Appendix B, Internal Controls and FMFIA assurance statement

PLACE OF PERFORMANCE:

The contractor shall be performing onsite at the FTA headquarters located at 1200 New Jersey Avenue, SE, Washington DC 20590.

PERIOD OF PERFORMANCE:

The anticipated contract shall have a 12-month base period and Four (4) 12 month option periods.

GOVERNMENT FURNISHED PROPERTY, IF APPLICABLE:

The Government will provide access to Government controlled facilities, equipment, and materials for daily business use of contractor personnel called for under this contract. This shall include office space, desk, telephone, chair, computer, shared printer, and requisite consumable materials.