Statement of Work_Final.pdf

STATEMENT OF WORK

Department of the Navy (DoN)

Strategic Systems Programs (SSP)

Statement of Work for the

Budget and Financial Data Analytics and Visualization Support of Program Management

June 23, 2025

TABLE OF CONTENTS

1.0 General

2.0 Specific Requirements/Tasks

3.0 Delivery or Deliverables

4.0 Meetings

5.0 Required Travel and Other Direct Costs (ODCs)

6.0 Government Furnished Property/Equipment/Information

7.0 Special Instructions

8.0 Glossary of Abbreviations and Acronyms

Statement of Work (SOW) for the

Data Analytics and Visualization Support

1.0 General

1.1 Background

The mission of the Department of the Navy is to completely transform its nuclear-powered submarine fleet and maintain its critical undersea advantage. The mission of the Strategic Systems Programs (SSP) is to deter strategic attack by providing credible and affordable nuclear and non-nuclear strategic solutions to the warfighter, underwriting the nation's security through 2084.

SSP requires specialized support to address persistent challenges in financial management, reporting, and asset management; areas critical to achieving and sustaining readiness. While ongoing efforts have laid important groundwork, the complexity of financial operations and the demand for automation and modernization continue to strain internal resources. These factors have impacted the efficiency and integration of key functions, particularly in financial tracking and asset accountability.

The Contractor will have experience with the Financial Management Office (FMO) and Financial Management Systems (FMS), which will assist in delivering targeted solutions that enhance readiness, improve data accuracy, and streamline financial processes across SSP operating systems. The selected organization will be expected to provide experienced personnel capable of navigating the unique requirements of Department of Defense (DoD) financial environments and driving lasting, independent improvements.

1.2 Objective

The objective is to obtain specialized financial management and audit remediation support services that will enhance SSP’s ability to achieve and sustain audit readiness, improve asset tracking and accountability, and modernize financial operations. The Contractor shall provide expert personnel with demonstrated experience in DoD audit remediation and Navy accounting systems. The ultimate goal is to strengthen internal controls, ensure data integrity, and drive innovation through automation within SSP’s financial environment.

A key focus of this effort is the development of an automated reporting capability that consolidates data from multiple systems to produce standardized, actionable reports.

These reports will highlight critical financial and asset data points needed to support informed decision making, improve visibility, and strengthen controls. The ultimate goal is to improve data integrity, drive operational efficiency, and advance innovation through automation.

1.3 Scope of Work

The Contractor shall provide all resources necessary to accomplish the tasks and deliverables described in this Statement of Work (SOW). The Contractor shall develop and deliver a standard operating procedure to automate report capabilities that synthesize financial and asset data from multiple internal systems to support readiness, financial oversight, and operational decision making. These reports will identify key financial indicators to include the availability, expiring, and canceling of funds; unbilled performance; problem disbursements; candidates for contract closeout; candidates whose burn rate is too high or too low, obligations approaching limitation of funds thresholds, and more. The solution shall allow users to filter and analyze data by fiscal year, appropriation, funding status (approved, allocated, obligated, committed, expended, and available), and view data by budget package, program, and performer.

The Contractor shall allow the process of the generation of these reports to be handed off to Navy personnel at the completion of the contract.

1.4 Period of Performance

The period of performance of this contract is one (1) base period with two (2) option periods.

1.5 Place of Performance

The Washington Navy Yard 1250 10th St SE, Washington, DC 20374 Building 200

1.6 Applicable Documents

DoD Financial Management Regulations DoD 7000.14-R, Financial Management Regulation https://comptroller.defense.gov/FMR/

DON Financial Policy Manual CurrentFMPM.pdf

2.0 Specific Requirements/Tasks

2.1 Task One – Financial Data Integration, Report Development, and Visualization The Contractor shall design, develop, and assist in maintaining a system-based Tableau reporting capability to generate automated program, financial, and contract reports, including supporting tables and visualizations. This capability shall serve SSP business managers, project managers, and other non-business operations managers by providing clear, actionable insights; aligned to current DON financial budget execution and audit https://comptroller.defense.gov/FMR/ https://www.secnav.navy.mil/fmc/Documents/CurrentFMPM.pdf requirements. All reports and underlying data shall be stored and maintained on the SSP Network, in compliance with DoD, DON, and SSP Security requirements.

2.1.1 Data Consolidation

The Contractor shall utilize data from Navy ERP and JUPITER internal systems to enable centralized reporting to Program Managers, ensuring consistent visibility and traceability across financial and programmatic elements; including the Navy’s Commanders Enterprise Research Management Council (CERMC) and periodic program and execution reviews.

2.1.2 Report Generation and Visualization

The Contractor shall develop automated reports and visual dashboard on the Tableau based capability that:

• Begin at the fiscal year and appropriation level, allowing drill-down to the funding document level.

• Include detailed financial data such as: appropriations, approved funding, received funding to date, commitments, obligations, expenditures, periods of performance (start and end dates), billing activity, funding document numbers, purchase request numbers, contract details, and contract line items.

• Roll up individual funding document data into higher-level categories including fiscal year, appropriation, appropriation project group, budget packages, suffix level, and performer/Contractor/Contract Line Item Number (CLIN).

• Identify and highlight key financial indicators including: available funds, expiring funds, and canceling funds; unbilled performers/Contractors; candidates for contract closeout; burn rate anomalies (i.e. performer/Contractors whose burn rate is too high, or has dormant billing); funding approaching limitation of funds clause;

spending trends; and problem disbursement.

• Reports required currently exist in a Microsoft Excel format based on Navy ERP data.

• Tableau reports generation shall support updates on not less than a weekly basis.

• JUPITER is the required data source for Tableau reports.

• Reports Generation shall include a desk-guide, be teachable/trainable, and able to be successfully completed without the assistance of the Contractor (CDRL to be determined).

• Reports shall be hosted and assessable on the SSP internal network and assessable by SSP employees.

o SSP holds Tableau creator licenses for SSP Government employees.

• Contractor shall provide technical support for the developed reports as necessary and required by the Government.

• Two initial training on use of the Tableau automated reporting capability that consolidates data from multiple systems to produce standardized, actionable reports.

• Additional training courses may be required up to 2-4 per year, delivered in person or virtually, with approximately 10-20 participants per session.

2.1.3 Data Filtering and Slicing - The Contractor shall ensure the reporting tools enable filtering by key financial attributes including fiscal year, appropriation, approved funding, allocated funding, obligated funding, committed funding, expended funding, and available balances. Users shall be able to view and organize data by budget packages, program, performer/Contractor, contract number, and making the data fully interactive, manipulable, and editable.

Primary Data Source is DON JUPITER data platform supported by Navy ERP and SSP Tools & Resources for Budget Optimization (TRBO) Budgeting system.

2.1.4 Travel Financial Execution Status Dashboard

The Contractor shall create a Tableau version of the existing Microsoft Excel Financial Travel Report based upon standard defense travel system reports and locally developed budget plans (CDRL to be determined).

3.0 Delivery or Deliverables

3.1 Front page of Tableau application site with links to subordinate summary report pages containing the reports enumerated below.

3.2 All general financial reports shall include the following:

3.2.1 Amount approved by SSP Board of Directors (BOD)

3.2.2 Amount released by Comptroller to date

3.2.3 Commitments

3.2.4 Obligations

3.2.5 Expenditures

3.2.6 Available Balance (To released amount)

3.2.7 Percent Committed (To released amount)

3.2.8 Percent Obligated (To released amount)

3.2.9 Percent Expended (To released amount)

3.2.10 Percent Unobligated (To released amount)

3.2.11 Colored coded to SSP financial execution benchmarks

3.3 Financial Reports by:

3.3.1 Appropriation by Fiscal Year

3.3.2 Budget Package by Fiscal Year

3.3.3 SP28 Section by Fiscal Year

3.3.4 United Kingdom Funding

3.3.5 Performer

3.3.6 Contract Number and CLIN

3.4 Command format

3.4.1 Monday Morning Meeting

3.4.2 Checkbook reports by Budget Package

3.4.3 Checkbook reports by Management Account

3.4.4 Checkbook reports by Funding Document

3.5 Expiring Funds automated and recurring reporting capabilities

3.5.1 By Appropriation

3.5.2 By Budget Package

3.5.3 By Management Account

3.5.4 By Funding Document

3.5.5 By Performer

3.6 Cancelling Funds

3.6.1 By Appropriation

3.6.2 By Budget Package

3.6.3 By Management Account

3.6.4 By Funding Document

3.6.5 By Performer

3.7 Invoicing/Billing by Document

3.7.1 No billing in last 60 days

3.7.2 No billing in last 90 days

3.7.3 No billing in last 120 days

3.7.4 Expenditures more than 10% off benchmark (+/-)

3.8 Travel Financial Execution Status Dashboard

3.8.1 Funding status for the branch

3.8.2 Funding status by unit

3.8.3 Funding status by traveler

3.8.4 Funding status by location

3.9 Approved Budget vs. Execution Report

4.0 Meetings

4.1. Post-award Kickoff Meeting

Within 15 business days of contract award, the Government will conduct an in-person, post-award kickoff meeting.

4.2. Intermittent Project Status Reviews

Intermittent project reviews shall be conducted bi-weekly.

4.3. Monthly Project Status Reviews

Informal monthly status meetings shall be conducted on the first working Tuesday of each month. The Contractor is responsible for reporting the current development activities (including any risks, issues, or concerns, and actual or recommended actions for their mitigation), and projected activities for the following month.

4.4. Program Management Review

The Government shall conduct quarterly program management reviews at Washington Navy Yard, the contractor’s facility, or virtually, to review the progress of the program, identify any risks, issues, or concerns, and provide feedback on the Contractor’s progress and performance. The Contractor shall provide written data and verbal presentations as to the financial status of the

Budget and Financial Data Analytics and Visualization Support of Program Management (CDRL to be determined) (projected vs. incurred costs), any identified risks, issues, or concerns (and their mitigation plans.)

5.0 Required Travel and Other Direct Costs (ODCs)

The principal place of performance is at SPHQ located on the Washington Navy Yard.

Accordingly, reimbursable travel and per diem for the Contactor staff performing work on a regular basis at this place of performance is not authorized. Any changes to principal place of performance shall be approved in writing by the Contracting Officer.

6.0 Government Furnished Property/Equipment/Information

Government Furnished Property/Equipment/Information will be determined at time of award. All SSP Government Information must reside on an SSP issued technology/ equipment. The Government will provide up to four SSP network laptops and the requisite budget and financial execution data to complete this effort

7.0 Special Instructions

Templates, reports, automation, desk guides, and/or other documentation may be shared within the Government.

8.0 Glossary of Abbreviations and Acronyms

BOD Board of Directors CDRL Contractor Data Requirements List CERMC Commanders Enterprise Research Management Council CLIN Contract Line-Item Number CPFF Cost Plus Fixed-Fee DoD Department of Defense DoN Department of the Navy FM&C Financial Management & Comptrollership FMC Navy's Budget Office FMO Financial Management Office FMS Financial Management Systems FP Unit Price GFE Government Furnished Equipment GFI Government Furnished Information GFP Government Furnished Property Navy ERP Navy Enterprise Resource Planning ODCs Other Direct Costs

PSC Product Service Code SOW Statement of Work SSP Strategic Systems Programs TRBO Tools & Resources for Budget Optimization UK United Kingdom