FMO Solicitation W91CRB-23-R-0023.pdf

PDF 814 KB Posted

Attached to
Financial Management Operations Support Services
Solicitation number
W91CRB-23-R-0023
Issued by

About this file

This is a solicitation for financial management operations support services. The Army Contracting Command Aberdeen Proving Ground is seeking proposals to provide technical and analytical support to the Deputy Assistant Secretary of the Army for Cost and Economics in areas such as developing cost estimating methodologies and databases, updating and supporting databases for the Civilian Rate Execution system and Army Military-Civilian Cost System, and developing data science products related to installations and personnel cost analyses. Proposals are due by 12:00 PM on December 18, 2023. The contract will have a 60-month period of performance with a 30-day phase-in period covered under CLIN 0001. Support will include tasks such as normalizing cost data, developing cost estimating relationships, and generating installation service requirements. The contractor must possess a SECRET facility clearance and comply with requirements of the DD Form 254.

View the file

Other files

File Type Posted
FMO Price Proposal Model-29NOV2023-UPDATED.xlsx XLSX spreadsheet
Industry Solicitation Questions.pdf PDF
Amend 1.pdf PDF
FMO CDRLs 1.pdf PDF
FMO Price Proposal Model.xlsx XLSX spreadsheet
FMO Performance Assessment Questionnaire.pdf PDF
FMO DD254.pdf PDF
FMO CDRLs 2.pdf PDF

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

SEE ADDENDUM

( No Col lect Cal ls )

W91CRB23R0023

b. TELEPHONE NUMBER

410-306-4721

8. OFFER DUE DATE/LOCAL TIME

12:00 PM 18 Dec 2023

5. SOLICITATION NUM BER 6. SOLICITATION ISSUE DATE

9-Nov-2023

AUTHORIZED FOR LOCAL REPRODUCTION

PREVIOUS EDITION IS NOT USABLE

STANDARD FORM 1449 (REV. 2/2012)

Prescribed by GSA – FAR (48 CFR) 53.212

(TYPE OR PRINT)

( SIGNATURE OF CONTRACTING OFFICER)

ADDENDA ARE

26. TOTAL AWARD AMOUNT (For Gov t . Use Only)

23.

CODE 10. THIS ACQUISI TION IS

SUCH ADDRESS IN OFFER

17b. CHECK IF REMITTANCE IS DIFFERENT AND PUT

BELOW IS CHECKED

TELEPHONE NO.

W91CRB9. ISSUED BY

18b. SUBMIT INVOICES TO ADDRESS SHOWN IN BLOCK 18a. UNLESS BLOCK

7. FOR SOLICITATION

INFORM ATION CALL:

a. NAM E

COURTNEY L. LONG

2. CONTRACT NO. 3. AWARD/EFFECTIVE DATE 4. ORDER NUMBER

(TYPE OR PRI NT)

30b. NAME AND TITLE OF SIGNER 30c. DATE SIGNED 31b. NAME OF CONTRACTING OFFICER

30a. SIGNATURE OF OFFEROR/CONTRACTOR 31a.UNITED STATES OF AMERICA

0 27a. SOLI CI TATION INCORPORATES BY REFERENCE FAR 52. 212-1. 52.212-4. FAR 52. 212-3. 52.212-5 ARE ATTACHED.

25. ACCOUNTING AND APPROPRI ATION DATA

1. REQUISITION NUMBER

20.

ADDI TIONAL SHEETS SUBJECT TO THE TERMS AND CONDI TIONS SPECIFIED.

OFFEROR TO COMPLETE BLOCKS 12, 17, 23, 24, AND 30

SOLICITATION/CONTRACT/ORDER FOR COMMERCIAL ITEMS

ARE NOT ATTACHED

27b. CONTRACT/PURCHASE ORDER INCORPORATES BY REFERENCE FAR 52. 212-4. FAR 52.212-5 IS ATTACHED. ADDENDA ARE ARE NOT ATTACHED

(BLOCK 5), INCLUDI NG ANY ADDITI ONS OR CHANGES WHICH ARE

SET FORTH HEREIN, I S ACCEPTED AS TO I TEMS:

. YOUR OFFER ON SOLI CI TATION

28. CONTRACTOR IS REQUIRED TO SIGN THI S DOCUMENT AND RETURN

% FOR:SET ASI DE:UNRESTRI CTED ORX

SMALL BUSINESS

17a.CONTRACTOR/ CODE FACILI TY

OFFEROR CODE

ACC - APG - W91CRB

BLDG 4310

6515 INTEGRITY COURT

ABERDEEN PROVING GROUND MD 21005-3013

18a. PAYMENT WILL BE MADE BY CODE

RATED ORDER UNDER

DPAS (15 CFR 700)

13a. THIS CONTRACT IS A

13b. RATI NG

CODE15. DELI VER TO CODE 16. ADMI NI STERED BY

SEE SCHEDULE

12. DI SCOUNT TERMS11. DELI VERY FOR FOB DESTI NA-

TION UNLESS BLOCK IS

MARKED

SEE SCHEDULE

14. METHOD OF SOLICITATION

RFQ IFB RFPX

FAX:

TEL: SERVI CE-DISABLED

VETERAN-OWNED

SMALL BUSI NESS

8(A)

HUBZONE SMALL

BUSINESS

SIZE STANDARD:

$24,500,000

NAI CS:

541611

X

OFFER DATED

29. AW ARD OF CONTRACT: REF.

DELIVER ALL ITEMS SET FORTH OR OTHERWI SE IDENTIFI ED ABOVE AND ON ANY

COPI ES TO ISSUI NG OFFI CE. CONTRACTOR AGREES TO FURNISH AND

EMAIL:

TEL:

31c. DATE SIGNED

SEE SCHEDULE

SCHEDULE OF SUPPLIES/ SERVICESITEM NO. QUANTITY UNIT UNIT PRICE AMOUNT

24.22.21.19.

WOM EN-OWNED SMALL BUSINESS (WOSB)

ELIGIBLE UNDER THE WOM EN- OWNED

SM ALL BUSINESS PROGRAM

EDWOSB

32g. E-MAIL OF AUTHORIZED GOVERNMENT REPRESENTATIVE

SOLICITATION/CONTRACT/ORDER FOR COMMERCIAL ITEMS

(CONTINUED)

PAGE 2 OF67

ACCEPTED, AND CONFORMS TO THE CONTRACT, EXCEPT AS NOTED: ______________________________________________________

32a. QUANTI TY IN COLUMN 21 HAS BEEN

RECEI VED I NSPECTED

32b. SIGNATURE OF AUTHORI ZED GOVERNMENT

REPRESENTATIVE

32c. DATE 32d. PRINTED NAME AND TITLE OF AUTHORIZED GOVERNMENT

REPRESENTATI VE

32e. MAILI NG ADDRESS OF AUTHORIZED GOVERNMENT REPRESENTATIVE 32f . TELEPHONE NUMBER OF AUTHORI ZED GOVERNMENT REPRESENTATI VE

37. CHECK NUMBER

FI NALPARTI ALCOMPLETE

36. PAY MENT35. AMOUNT VERIFIED

CORRECT FOR

34. VOUCHER NUMBER

FINAL

33. SHI P NUMBER

PARTI AL

38. S/R ACCOUNT NUMBER 39. S/R VOUCHER NUMBER 40. PAI D BY

41a. I CERTIFY THIS ACCOUNT IS CORRECT AND PROPER FOR PAY MENT

41b. SIGNATURE AND TI TLE OF CERTIFYI NG OFFICER 41c. DATE

42a. RECEIVED BY (Print)

42b. RECEIVED AT (Location)

42c. DATE REC'D (YY/ MM/ DD) 42d. TOTAL CONTAI NERS

STANDARD FORM 1449 (REV. 2/2012) BACK

Prescribed by GSA – FAR (48 CFR) 53.212

AUTHORIZED FOR LOCAL REPRODUCTION

PREVIOUS EDITION IS NOT USABLE

SEE SCHEDULE

20.

SCHEDULE OF SUPPLIES/ SERVICES

21.

QUANTITY UNIT

22. 23.

UNIT PRICE

24.

AMOUNT

19.

ITEM NO.

Section A - Solicitation/Contract Form

ADDITIONAL INFORMATION

The guaranteed minimum is $1,000 and will be met via the first task order. The maximum ceiling will be set at the combined total of all CLINs.

Questions shall be submitted to the Contract Specialist listed in Section L of this solicictation via email no later than 12:00pm (noon), 28 November 2023.

Section B - Supplies or Services and Prices

ITEM

NO

SUPPLIES/SERVIC

ES

QUANTITY UNIT UNIT PRICE AMOUNT

0001 1 Months 30 Day Phase-In

FFP

Per PWS 1.18 Phase In FOB: Destination

PSC CD: R699

NET AMT

SUPPLIES/SERVIC

ES

QUANTITY UNIT UNIT PRICE AMOUNT

0002 59 Months

GENERAL LABOR

FFP

Months 2-60. Per Performance Work Statement attached, to provide Financial Management Operations Support Services FOB: Destination

SUPPLIES/SERVICE

S

QUANTITY UNIT UNIT PRICE AMOUNT

ODCs/Travel

COST

PER PWS 1.10, NTE $35,000. Months 1-60.

FOB: Destination

PSC CD: R699

ESTIMATED COST

ITEM

NO

SUPPLIES/SERVIC

ES

QUANTITY UNIT UNIT PRICE AMOUNT

CDRLs

FFP

In accordance with the PWS and Exhibit A, Contract Data Requirements List A001-A008. Months 1-60. Not Separately Priced.

FOB: Destination

Section C - Descriptions and Specifications

PERFORMANCE WORK STATEMENT

Financial Management Operations Support Services

PART 1

GENERAL INFORMATION

1. GENERAL: This is a non-personal services contract to provide Financial Management Operations

(FMO) support to the Army. The Government shall not exercise any supervision or control over the contract service providers performing the services herein. Such contract service providers shall be accountable solely to the Contractor who, in turn is responsible to the Government.

1.1 Introduction: The Deputy Assistant Secretary of the Army for Cost and Economics (DASA-CE) is the principal advisor to the Assistant Secretary of the Army (Financial Management and Comptroller) (ASA (FM&C)) on all Army cost and economic analysis activities. The DASA-CE mission is to provide the Army decision-makers with cost and economic analysis in the form of expertise, models, data, estimates, and analyses at all levels.

1.2 Objectives:

a) Develop models and estimates of the cost to provide Army installation services at various performance standards in support of the PPBES process – (Performed at the Contractor’s Site)

b) Develop cost factors and databases supporting the Army Military-Civilian Cost System (AMCOS) - (Performed at the Contractor’s Site)

c) Develop cost factors, databases, and web-based reports for Civilian Rate Execution (CRE) - (Performed at the Contractor’s Site)

d) Develop data science products supporting Installations and Personnel cost modeling and analyses

– Performed at the Contractor’s Site)

1.3 Scope: The contractor shall provide support services to the DASA-CE in the areas of 1) the development of methodologies and databases to estimate the cost of services being provided by Army installations for the purpose of supporting the Planning, Programming, Budgeting and Execution System (PPBES) process, 2) updates, analysis and support of the databases supporting the Civilian Rate Execution (CRE), 3) updates, analysis and support of the databases supporting the Army Military-Civilian Cost System (AMCOS) and 4) the development of data science products in support of Installations and Personnel cost analyses.

1.4 General Information:

1.4.1 Quality Control: The contractor shall develop and maintain an effective quality control program to ensure services are performed in accordance with this Performance Work Statement (PWS). The contractor shall develop and implement procedures to identify, prevent and ensure non-recurrence of defective services. The contractor's quality control program is how he assures himself that his work complies with the requirement of the contract. As a minimum, the contractor shall develop quality control procedures that address the areas identified in Technical Exhibit 1, "Performance Requirements Summary". Any changes to quality control shall receive the contracting officer's acceptance in writing.

1.4.2 Quality Assurance: The Government shall evaluate the performance of the Contractor in accordance with the Performance Requirements Summary and the Quality Assurance Surveillance Plan (QASP). The QASP primarily ensures the Government, that the Contractor has performed its tasks in accordance with the performance standards. It defines how the performance standards will be applied, the frequency of surveillance and the minimum acceptable defect rate(s).

1.4.3 Hours of Operation/Place of Performance: The contractor is responsible for conducting work between the hours of 0600 hours to 1800 hours Monday thru Friday except Federal holidays or when the Government facility is closed due to local or national emergencies, administrative closings, or similar Government directed facility closings. The Contractor must always maintain an adequate work force for the uninterrupted performance of all tasks defined within this statement of work. When hiring personnel, the Contractor shall keep in mind that the stability and continuity of the work force are essential.

1.4.4 Holidays: Work shall not be performed on U.S. Federally recognized holidays occurring during the normal workweek unless otherwise directed by the Contracting Officer. When a U.S. holiday occurs on a Saturday or a Sunday, the holiday is observed on the preceding Friday or following Monday, respectively.

New Year’s Day – 1 January Martin Luther King Jr. Day – 3rd Monday in January Presidents Day – 3rd Monday in February Memorial Day – Last Monday in May Juneteenth Day – 19 June Independence Day – 4 July Labor Day – 1st Monday in September Columbus Day – 2nd Monday in October Veterans Day – 11 November Thanksgiving Day – 4th Thursday in November Christmas Day – 25 December

Any Federal Holidays declared by the Government after the issuance of this contract shall be automatically incorporated into this list.

1.5 Security Requirements: The Contractor supporting shall possess or be eligible to receive and maintain a SECRET facility clearance from the Defense Security Service. The Contractor's employees, performing work in support of this contract, shall have been granted a SECRET security clearance from the Defense Industrial Security Clearance Office at time of contract award. Security requirements shall be in accordance with the attached DD254.

1.5.1 Antiterrorism Operations Security (AT/OPSEC): Contractor shall fulfill all AT/OPSEC requirements included herein, and any applicable source selection evaluation criteria for antiterrorism (AT) and other related protection matters to include, but not limited to: AT, operations security (OPSEC), information assurance (IA), physical security, law enforcement, intelligence, foreign disclosure.

1.5.2 AT Level I Training: All contractor employees, to include subcontractor employees, requiring access Army installations, facilities and controlled access areas shall complete AT Level I awareness training within 30 calendar days after contract start date or effective date of incorporation of this requirement into the contract, whichever is applicable. The contractor shall submit certificates of completion for each affected contractor employee and subcontractor employee, to the Contracting Officer’s Representative (COR) or to the contracting officer, if a COR is not assigned, within 30 calendar days after completion of training by all employees and subcontractor personnel. AT level I awareness training is available at the following website: http://jko.jten.mil

1.5.3 Access and general protection/security policy and procedures: Contractor and all associated sub-contracted employees shall provide all information required for background checks to meet installation access requirements to be accomplished by installation Provost Marshal Office, Director of Emergency Services or Security Office. Contractor workforce must comply with all personal identity verification requirements (Federal Acquisition Regulation (FAR) clause 52.204-9, Personal Identity Verification of Contractor Personnel) as directed by the Department of Defense (DOD), Headquarters, Department of the Army (HQDA) and/or local policy. In addition to the changes otherwise authorized by the changes clause of this contract, should the Force Protection Condition (FPCON) at any individual facility or installation change, the Government may require changes in contractor security matters or processes.

1.5.4 iWATCH Training: The contractor and all associated sub-contractors shall brief all employees on the local iWATCH program (training standards provided by the requiring activity ATO). This local developed training will be used to inform employees of the types of behavior to watch for and instruct employees to report suspicious activity to the COR. This training shall be completed within 30 calendar days of contract award and within 30 calendar days of new employees commencing performance with the results reported to the COR no later than (NLT) 45 calendar days after contract award.

1.5.5 Army Training Certification Tracking System (ATCTS) registration for contractor employees who require access to government information systems. All contractor employees with access to a government info system must be registered in the ATCTS (Army Training Certification Tracking System) at commencement of services and must successfully complete the DOD Information Assurance Awareness prior to access to the IS and then annually thereafter.

1.6 Post Award Conference/Periodic Progress Meetings: The Contractor agrees to attend any post award conference convened by the contracting activity or contract administration office in accordance with Federal Acquisition Regulation Subpart 42.5. The Contracting Officer, Contracting Officers Representative (COR) and other Government personnel, as appropriate, may meet periodically with the Contractor to review the Contractor's performance. At these meetings the Contracting Officer will explain to the Contractor how the Government views the Contractor's performance. Subsequently, the Contractor will explain to the Government any issues or problems, if any, being experienced. Appropriate action shall be taken to resolve outstanding issues.

1.8 Contracting Officer Representative (COR): The COR will be appointed in the Joint Appointment

Model after contract award, and a copy of the appointment letter will be furnished to the Contractor.

The COR monitors all technical aspects of the contract and assists in contract administration. The COR is authorized to perform the following functions: assure that the Contractor performs the technical requirements of the contract; perform inspections necessary in connection with contract performance; maintain written and oral communications with the Contractor concerning technical aspects of the contract; issue written interpretations of technical requirements, including Government drawings, designs, specifications; monitor Contractor's performance and notifies both the Contracting Officer and Contractor of any deficiencies; coordinate availability of government furnished property, and provide site entry of Contractor personnel. A letter of designation issued to the COR, a copy of which is sent to the Contractor, states the responsibilities and limitations of the COR, especially about changes in cost or price, estimates or changes in delivery dates. The COR is not authorized to change any of the terms and conditions of the resulting order.

1.9 Identification of Contractor Employees: All contract personnel attending meetings, answering

Government telephones and working in other situations where their contractor status is not obvious to third parties are required to identify themselves as such to avoid creating an impression in the minds of members of the public that they are Government officials. They must also ensure that all documents or reports produced by contractors are suitably marked as contractor products or that contractor participation is appropriately disclosed. Contractor shall ensure that their status as a contractor is clearly known whenever the contractor or its representatives gain access to the proprietary information of other organizations or contractors. Contractor is reminded that prior to obtaining such proprietary information, they must comply with the requirements of FAR 9.505-4(b) relating to obtaining agreements with the other companies to protect their information and properly provide copies of such agreements to the Contracting Officer. The Contractor shall have all personnel to fill out the necessary paperwork to obtain Common Access Cards (CAC) and building passes for access to the Pentagon.

1.10 Contractor Travel: The Contractor may be required to travel the continental U.S. (CONUS) to conduct briefings, attend meetings, or attend training, as required by the Government. Contractor travel shall be consistent with FAR Part 31.205-46, the amounts and limitations specified in the Joint Travel Regulations, as they are amended from time to time and the limitation of funds specified in this contract. All contractor travel to be charged to the government under this contract must be approved in advance by the COR.

1.11 Data Rights: The Government has sole right of ownership to all documents/material produced under this contract. These documents and materials may not be used or sold by the contractor without written permission from the Contracting Officer. If specified in the contract, the Government may require the contractor to return data at the end of the contract. All materials supplied to the Government shall be the sole property of the Government and may not be used for any other purpose.

This right does not abrogate any other Government rights under the applicable contract.

1.12 Organizational Conflict of Interest (OCI): Contractor and subcontractor personnel performing work under this contract may receive, have access to, or participate in the development of proprietary or source selection information (e.g., cost or pricing information, budget information or analyses, specifications, or work statements, etc.) or perform evaluation services which may create a current or subsequent Organizational Conflict of Interests (OCI) as defined in FAR Subpart 9.5. The Contractor shall notify the Contracting Officer immediately whenever it becomes aware that such access or participation may result in any actual or potential OCI and shall promptly submit a plan to the Contracting Officer to avoid or mitigate any such OCI. The Contractor’s mitigation plan will be determined to be acceptable solely at the discretion of the Contracting Officer and in the event the Contracting Officer unilaterally determines that any such OCI cannot be satisfactorily avoided or mitigated, the Contracting Officer may affect other remedies as he or she deems necessary, including prohibiting the Contractor from participation in subsequent contracted requirements which may be affected by the OCI.

1.13 Section 508 Compliance Requirements

1.13.1 All Electronic and Information Technology (EIT) products and services proposed shall fully comply with Section 508 of the Rehabilitation Act of 1973, per the 1998 Amendments and the Architectural and Transportation Barriers Compliance Board's Electronic and Information Technology Accessibility Standards at 36 Code of Federal Regulations (CFR) 1194. The Contractor shall identify all EIT products and services proposed, identify the technical standards applicable to all products and services proposed and state the degree of compliance with the applicable standards.

Additionally, the Contractor shall be compliant within 30 days of contract award and must clearly indicate where the information pertaining to Section 508 compliance can be found (e.g., Vendor's or other exact web page location). The Contractor must ensure that the list is easily accessible by typical users within 30 days of contract award. The Contractor must ensure that all EIT products and services proposed that are less than fully compliant, are offered pursuant to extensive market research, which ensures that they are the most compliant products available to satisfy the solicitation's requirements.

If any such EIT product or service proposed is not fully compliant with all the standards, the Contractor shall specify each specific standard that is not met; provide a detailed description as to how the EIT product or service does not comply with the identified standard(s); and shall also indicate the degree of compliance. The contractor shall ensure that all electronic and information technology (EIT) procured meet the applicable accessibility standards at 365 CFR 1194. 36 CFR 1194 implements Section 508 of the Rehabilitation Act of 1973, as amended. This standard is viewable at http://www.section508.gov.

1.13.2 The contractor shall indicate for each product or service provided in support of this Performance

Work Statement that it is compliant or non-compliant with the following technical standards extracted from 36 CFR 1194. This is a generic list. The contractor shall conform to this requirement as appropriate for the products or services delivered.

1.13.3 For all EIT products and/or services supported, the contractor shall analyze and present to the

Government in a Product Accessibility Report, the potential accessibility challenges presented by the product and recommendations for solving them. The contractor shall use the Product Accessibility Template (available at http://www.section508.gov.) as the basis for the report to assess any potential accessibility impact, determine which commercial-off-the-shelf (COTS) products could be used to solve the accessibility challenges, and provide a recommended solution to remedy any potential accessibility difficulties to the Government for approval. These recommendations shall incorporate market research into the availability of Commercial-off-the-shelf (COTS) products that could be used to make these items accessible to persons with disabilities. Further, the proposed solution shall indicate where full details of compliance demonstration can be found (e.g., vendor's web site or other exact location). Upon receipt of Government approval of a specific accessibility solution, the contractor shall incorporate this accessibility solution into any applicable documentation related to that system and implement the accessibility solution when the system is implemented.

1.14 Key Personnel: The following labor categories have been designated as key. Key personnel may be multifunctional.

1.14.1 Installation Service Cost Analyst Lead / Subject Matter Expert (SME): Key Personnel.

Requires bachelor’s degree in Statistics, Operations Research, Economics, Finance, or related field.

Requires at least 7 years of related experience with at least 5 years directly related to service sector cost analysis. Must have extensive experience analyzing financial data originating from the Defense Finance and Accounting System (DFAS) and/or General Fund Enterprise Business System (GFEBS), with an understanding of the Department of Defense (DoD) Planning, Programming, Budgeting, and Execution (PPBE) process. Should have at least 5 years of experience in parametric modeling and the ability to clearly present the results. Proficiency in visualization techniques and data management is desired. Advanced degree in related field may substitute for years of experience.

1.14.2 Personnel Cost Analyst Lead / Subject Matter Expert (SME): Key Personnel. Requires a

Bachelor’s degree and 10 years of experience, at least 5 of which involved leading a software development team. Experience in cost analysis, manpower analysis, data extraction, transformation, and load (ETL) processes, automated testing, and Structured Query Language (SQL) Server are desired. Advanced degree or more specialized training and experience may substitute for years of experience.

1.14.3 Lead Developer: Key Personnel. Requires at least 10 years of programming experience developing web-based applications using Microsoft Active Server Pages Network Enabled Technologies (ASP.Net), developing database solution using SQL Server relational databases, and ETL processes. At least 5 years of experience working with Army Civilian Pay or pay system of comparable complexity is highly desired. Additional specialized training or experience may substitute for years of experience.

1.14.4 System Architect: Key Personnel. Requires at least 10 years of experience developing complex systems and processes using Microsoft ASP.Net and SQL Server. At least 5 years of experience working with Army Civilian Pay or pay system of comparable complexity is highly desired.

Additional specialized training or experience may substitute for years of experience.

1.15 Education Requirements and Qualifications for Other Labor Categories:

1.15.1 Senior Cost Analyst: Possess a bachelor’s degree and at least 7 years of experience. Experience in cost analysis, manpower analysis, ETL processes, automated testing, and SQL Server are desired.

Advanced degree or specialized training may substitute for years of experience.

1.15.2 Senior Programmer / Database Analyst (DBA): Possess a bachelor’s degree and at least 7 years’ experience. Experience with Microsoft ASP.NET software development and SQL Server; with developing secure applications in accordance with the Risk Management Framework; and, with design of business applications on complex systems for large scale computers and client-server environments, version control, and configuration management are desired. Advanced degree or more specialized training and experience may substitute for experience.

1.15.3 Data Analyst: Requires a bachelor’s degree in Statistics, Operations Research, Engineering, Economics, Data Science, or related field. At least 4 years of relevant experience with parametric modeling, visualization techniques, data management, and other analytic methods are desired.

Advanced degree in related field or specialized training may substitute for years of experience.

1.15.4 Associate Data Analyst: Requires a bachelor’s degree in Statistics, Operations Research, Engineering, Economics, Data Science, or related field and 2 years of experience. Experience with data management, analysis, and visualization are desired. Advanced degree or specialized training may substitute for years of experience.

1.15.5 Senior Database Administrator / Architect: Possess a bachelor’s degree and 10 years of experience with relational database installation, architecture, optimization, and security in a secure Government environment and 10 years of experience with complex data ETL activities in SQL Server. Experience with data architecture for complex software systems required. Additional relevant education or specialized experience may substitute for years of experience.

1.15.6 Test Lead / Programmer: Possess 10 years of experience with complex Government web-based applications and websites, including at least 5 with Microsoft ASP.NET, testing for compliance and defects as well as resolving defects. 10 years of experience developing test plans and user manuals.

Additional relevant education or specialized experience may substitute for years of experience.

1.15.7 Senior Analyst / Quality Assurance and Configuration Management (QACM): Possess 7 years of experience implementing Quality Assurance and Configuration Management in a CMMI, ISO9000 certified Quality Management System or equivalent structured environment and demonstrated experience in implementing CMMI Level 3 practices desired. Additional relevant education or specialized experience may substitute for years of experience.

1.16 Contractor Manpower Reporting (CMR): Contractor Manpower Reporting (CMR): The contractor shall report all contractor and subcontractor labor hours required for performance of services provided under this contract via a secure data collection site. The contractor is required to complete all required data fields using the following web address: https://www.sam.gov. Reporting inputs will be for the labor executed during the period of performance by each Government fiscal year (FY), which runs 01 October through 30 September. While inputs may be reported anytime during the FY, all data shall be reported no later than 31 October of each calendar year. Contractors may direct questions to the help desk by clicking on “Send an email” which is located under the Help Resources ribbon on the right side of the login page of the applicable Service/Component’s Contractor Manpower Reporting website.

1.17 CAC Access to Government Computers/Systems: All Contractor personnel are required to acquire and maintain a Common Access Card (CAC). CACs will be used for building access and DoD/Army network access. The Trusted Agent is responsible for validating CAC issuance using the Contractor Verification System.

Contractor eligibility remains in force during employment under the contract for those employees who have a valid and recurring requirement for access to Army facilities or automation systems to perform those duties stipulated in the contract. CACs shall be returned to the Trusted Agent when the Contractor employee’s employment is terminated or upon expiration of the contract. The CACs expire when Contractor eligibility terminates or three years from the issuance date, whichever occurs first.

1.18 Phase-In/Phase-Out Period: The Contractor shall provide a detailed phase in/phase out plan to include timelines and measurable results. The plan should describe the processes and procedures required to ensure a seamless and successful transition that minimizes disruption of services and support. To minimize any disruptions, decreases in productivity and to prevent possible negative impacts on additional services, the Contractor shall identify key personnel and have all personnel on board, during the phase in / phase out periods.

The Contractor must recognize that services under this contract must continue without interruption and that upon contract expiration, a successor, either the Government or another Contractor, may continue services. The Contractor shall exercise its best effort and cooperate effectively in an orderly and efficient transition to any successor contractor.

a) Phase-In: During the phase in period, while working the incumbent Contractor, the successor Contractor shall become familiar with all equipment, services provided and performance requirements to commence full performance of services at the end of the phase in period. The Contractor shall identify issues or concerns and provide to the government representative.

The Contractor shall develop and propose solutions for issues or concerns.

b) Phase-Out: The Contractor shall ensure that contractor personnel are onsite and providing support until the end of the contract performance period specified in Section F. During the phase out period, the incumbent Contractor shall assist the successor Contractor with all equipment services provided and performance requirements to maintain uninterrupted services through the end of the phase out period. The Contractor phase out plan will provide a detailed plan to transfer sensitive information such as passwords and combinations and processes and documentation of processes or procedures in use by the Contractor to provide services and support.

PART 2

2.0 GOVERNMENT FURNISHED PROPERTY, EQUIPMENT AND SERVICES

2.1 General: The Government will provide reasonable access to its facilities, key personnel, data, and documents in support of the project during the contractor visits. The Contractor shall furnish all supplies, equipment, facilities, and services required to perform the required work under this contract.

2.2 Equipment: Government-furnished equipment will not be provided for the Contractor’s workforce outside of the Pentagon.

2.3 The Government will provide financial data from applicable Enterprise Resource Planning (ERP) Systems such as the General Fund Enterprise Business System (GFEBS) as necessary. The government will provide other unclassified source data appropriate to this contract. The government will also provide appropriate guidance and feedback related to the performance of the tasks in this contract.

PART 3

3.0 CONTRACTOR FURNISHED ITEMS AND SERVICES

3.1 General: Except for those items specifically stated to be government furnished in Part 3, the contractor shall furnish everything required to perform this PWS.

3.2 Secret Facility Clearance: The Contractor shall possess or be eligible to receive and maintain a “SECRET” Security Clearance for the duration of this contract. The acquisition will require the contractor to comply with the requirements of the Contract Security Classification Specification (DD Form 254), which will be incorporated into the contract.

W91CRB23R0023

PART 4: SPECIFIC TASKS

4.1 The Contractor shall provide technical and analytical support services to support DASA-CE's

Standard Service Costing (SSC), Civilian Rate Execution (CRE), and Army Military-Civilian Cost System (AMCOS). The Contractor shall develop methods, databases, and reports to estimate the cost of services to be provided at Army installations for the purpose of supporting the Planning, Programming, Budgeting and Execution System (PPBES) process.

4.2 The Contractor shall develop SSC cost estimating relationships (CERs) and cost estimates for use in generating Army Installation service requirements.

4.2.1 The Contractor shall normalize cost data.

a) The Contractor shall normalize Army Installation Status Report - Services (ISR-S) cost data as well as related or substitute cost data as directed by the Chief, Secretary of the Army Financial Management for Cost Economics Installations (SAFM-CEI) or COR. The Contractor shall normalize cost data by adjusting for inflation, regional differences, foreign currencies, or other factors as directed in DASA-CE's published guidance, SSC Standard Operating Procedure (SOP), and by SAFM-CEI personnel. The Contractor must complete this process by May 1st of each year, or as directed by the Chief, SAFM-CEI or COR.

b) The Contractor shall provide to the Chief, SAFM-CEI or COR, electronic Microsoft (MS)

Access and Excel databases for each installation service containing at a minimum:

A complete set of raw data.

A complete set of normalized data.

A set of records of any data that was removed or altered as part of the normalization process, as well as annotation of rules and assumptions that were applied.

Any indices or tables used for normalization; and Any transformations, intermediate calculations, or other adjustments performed for normalization.

c) Annotation must be provided for each record indicating what rule or assumption was applied.

It must be noted if multiple rules or assumptions were applied to a given record. The Contractor must provide a complete set of normalized data in both MS Access and Excel within 7 calendar days after receiving a request for update from the Chief, SAFM-CEI or COR. The Contractor shall provide to the COR and any government personnel designated by the COR copies of all raw data that was processed in the format that it was originally received by the Contractor. The Contractor shall also provide a report to the Chief, SAFM-CEI and COR containing at a minimum:

The source system(s) from which data is derived.

If data is provided by government personnel, the name, position, and organization of the person(s) providing the data.

The date on which data is provided to the Contractor for transformation.

Any query parameter(s) used to extract the initial data set; and A record of and rationale for any data that is excluded from the corrected data.

d) The Contractor shall supply a report of business rules to be used for normalization. The initial report shall be submitted prior to data normalization and subsequent reports shall be submitted along with normalized or otherwise transformed data. The initial report shall be supplied to the Chief, SAFM-CEI or COR no later than May 1st, unless otherwise directed by SAFM-CEI personnel. All the business rules supplied must be approved by the Chief, SAFM-CEI or COR before the Contractor shall use these rules to transform any data. Should a new business rule be developed after initial submission and approval of business rules, the Contractor shall submit the proposed business rule in writing to SAFM-CEI personnel for approval. Upon approval, the new rule shall be incorporated into the normalization process.

This report shall contain at a minimum:

A numeric identifier and a category for the business rule.

Any data that is removed from the corrected data and the rationale for removal.

Any data element(s) that are transformed and a mapping of the original data element(s) to the transformed data elements(s).

Any adjustments made to numerical values, the records affected, and the rationales for adjustments.

The rules used to map data to a specific service.

Any assumptions used to transform or correct data.

The name, position, and organization of any SME or personnel providing a specific business rule; and The elements within any given transaction that are used to link that transaction to a particular index, rate, process, mapping, or procedure.

e) The Contractor shall provide all tables and procedures designed to process or link transactions to indices, rates, or observations. This includes all tables, calculations, and procedures used to normalize and “de-normalize” data.

f) The Contractor shall be responsible for normalizing and analyzing data from sources including but not limited to: ISR, ASIP, HQIIS, and Army financial systems including GFEBS. The Contractor shall incorporate other sources of information as specified by SAFM-CEI personnel.

4.2.2 The Contractor shall develop CERs.

a) Unless directed otherwise by SAFM-CEI personnel, the Contractor shall utilize data from at least the previous four fiscal years including at a minimum:

Historical cost data, pacing items, and performance measures from the ISR.

Population data from ASIP; and Infrastructure data from HQIIS.

b) The Contractor shall utilize data from other sources as directed by SAFM-CEI personnel.

CERs shall be developed annually in batches. All batches shall be delivered by 30 September unless otherwise directed by Chief, SAFM-CEI or COR. All CERs are subject to review and approval by the Chief, SAFM-CEI or COR. During CER development, testing for relation to cost must be performed on at least the following variables: the population of soldiers and civilians on an installation; the square footage of buildings on an installation; the acreage of land on an installation; and any pacing or performance measure data elements reported. The Contractor shall also test variations, modifications, or alternate forms of variables as directed by SAFM-CEI personnel. The Contractor shall include alternate CERs where applicable or as directed by SAFM-CEI personnel.

c) For each CER the Contractor shall provide documentation stating at a minimum:

The source(s) of data used to create the CER.

Any data tables or elements used to create the CER.

Any query parameters or conditions used to generate the CER.

All code used in development of CER, including custom-built functions.

The equations for the CER, including coefficients and intercepts; and Summary statistics for the CER including adjusted R2 and coefficient of variation.

d) The Contractor shall identify variables to categorize installations for analysis. The Contractor shall conduct analysis and derive categories based on variables identified or as directed by SAFM-CEI personnel. The Contractor shall use derived categories in the creation of CER's and report output by these categories. The Contractor shall provide a list of all categories and the specific variables used to derive them to the Chief, SAFM-CEI or COR for approval. The Contractor shall conduct exploratory testing using various statistical methods for the purposes of developing requirements as directed by the Chief, SAFM-CEI or COR.

e) The Contractor shall use Python for CER development, unless otherwise directed by Chief, SAFM-CEI or COR. The Contractor shall provide Jupyter Notebook files documenting CER development. The Contractor shall provide MS Excel files documenting requirements for each service generated using developed CERs. The Contractor shall propose a schedule for generating CERs and requirements for approval or modification by Chief, SAFM-CEI or COR. As scheduled, the Contractor shall review and brief the results, inputs, and all equations and goodness-of-fit statistics to the Chief, SAFM-CEI, COR, or representative(s) designated by Chief, SAFM-CEI or COR. Each analysis should include electronic documentation provided for in sections 4.2.2(a) – (f). Documentation must be sufficient for SAFM-CEI personnel to trace the development of the CER and reproduce the results submitted by the Contractor. The Contractor shall have five business days to make all directed modifications following review by SAFM-CEI personnel. The Contractor shall provide consolidated report containing updated documentation and procedures for all analyses at the end of the cycle. The Contractor shall provide hard copies of the report upon request by the Chief, SAFM-CEI or COR.

f) The Contractor shall provide MS Excel spreadsheets for all mapping rules. The Contractor shall indicate the source data used in the mapping, the rules to map, and any calculations or allocations used to map all or part of a cost or transaction. Mapping rules include but are not limited to mappings to services, mappings to installations, and mappings to commands or organizations. All mapping rules are subject to review and modification by the Chief, SAFM-CEI or COR prior to their use in adjusting or normalizing data or in generating CERs.

4.2.3 The Contractor shall “de-normalize” the cost data.

a) The Contractor shall de-normalize data to reflect each command, component, or major organization's applicable costs. The Contractor shall provide a report indicating the amount of costs for each service attributed to each command and installation, as well as the business rules used to identify or allocate these amounts.

b) The Contractor shall provide an electronic MS Access or Excel databases for each installation service containing at a minimum:

A complete set of normalized data.

A complete set of de-normalized data.

Annotation of rules and assumptions that were applied.

Any indices or tables used for de-normalization; and Any transformations, intermediate calculations, or other adjustments performed for de-normalization.

c) The Contractor shall generate adjustment table(s) for de-normalization of data and application of performance adjustments. De-normalization includes escalation to POM years, adjustment for Installation-specific factors, adjustment from full cost estimate to Operations and Maintenance direct requirement, and ultimately generation of Installation-unique requirements.

d) The Contractor shall provide query support as identified by the Chief, SAFM-CEI or COR.

The Contractor shall provide any source data, tables, procedures, or process-specific code, as well as any historical data, including the data, procedures, business rules, or outputs of SSC from prior cycles.

4.2.4 The Contractor shall develop a database for Base Operations Support (BOS) requirements. The Contractor shall create a table structure, input forms, and output reports.

a) The Contractor shall provide no later than Nov 1st annually, documentation identifying:

• Input forms, including data elements and formats.

• All database tables, including data elements, keys, and relationships between tables.

• Output reports, including data elements and filters, conditioning, or formatting applying to the output reports; and

• All processes used to calculate BOS requirements and any tables and data elements containing costing factors or assumptions;

b) The Contractor shall be responsible for updating variable input tables for SAFM-CEI modeling and reporting tools. The Contractor must complete this process by November 1st of each year or as directed by the Chief, SAFM-CEI or COR.

• The Contractor shall develop variable input tables for reporting tools and support the validation of CER's and BOS cost estimates. These tables shall be provided to the Chief, SAFM-CEI and COR no later than November 15th of each year, or as directed by the Chief, SAFM-CEI or COR.

• The Contractor shall prepare data input tables necessary to develop POM requirements as directed by the Chief, SAFM-CEI or COR.

• The Contractor shall support validation of outputs from models and compare results with past model outputs and historical costs. The Contractor shall provide additional analyses, data to support validation, and a report documenting changes to models and outputs from prior year(s) as directed by the Chief, SAFM-CEI or COR.

c) The Contractor shall develop and/or update SSC documentation and procedures, including the SOP, as directed by the Chief, SAFM-CEI or COR.

d) The Contractor shall provide general cost estimating and database support.

• The Contractor shall conduct ad hoc cost analysis as directed by SAFM-CEI personnel.

The Contractor shall provide documentation of all estimates derived in support of such efforts, including data sources, calculations, and assumptions.

The Contractor shall support the tracking and preparation of information coinciding with the PPBES process, meeting planning support, briefing development, speaker logistics, and preparation of meeting minutes and follow-on activities.

e) The Contractor shall provide a monthly status report (MSR) that summarizes the work performed during the month. The MSR shall be submitted in writing to the Chief, SAFM-CEI and COR. The MSR shall contain at a minimum:

The status of CER development for each service for current batch.

The status of data collection efforts and any data that is outstanding.

Issues encountered with data normalization, CER development, or requirements generation.

The methodologies used to validate CERs.

The nature of ad hoc support analyses and validations performed.

The dates of the last updates to databases, tables, and related reports; and The number of hours billed to perform the above tasks by month and the associated rate.

The Contractor shall tie hours billed back to the appropriate PWS items.

f) Contractor shall notify the Chief, SAFM-CEI and COR if there are any periods when there is anticipated to be a shortfall in available support. The Contractor shall ensure that at least one individual is available and can be reached by SAFM-CEI personnel to address any of the PWS items noted above. The Contractor shall also identify any periods of time where fewer than two individuals will be available to perform work associated with the above PWS items.

4.3 Update, analyze and support Civilian Rates and Execution (CRE) System

4.3.1 The Contractor shall maintain and upgrade the web application, reports, database, and programming code that make up the Civilian Rates and Execution System and the Civilian Pay Rate Website. These tools shall support the Army Budget Office, G-1, and DASA-CE by allowing them to process, compare and adjust data to meet manpower controls, create budget exhibits and produce civilian pay rates.

a) The Contractor shall be responsible for obtaining execution data and business rule data from

Army Budget Office, the Corps of Engineers, G-1, DASA-CE, or any additional data from organizations directed by the COR. If the Contractor is unable to obtain this data, the Contractor shall notify the COR or Chief SAFM-CEI immediately. The Contractor shall provide source data to SAFM-CEI personnel upon request.

b) The Contractor shall be responsible for any necessary software modifications to the CRE tool or Civilian Pay Website. The Contractor shall also be responsible for updating logic in the tools and reports as indicated by COR. The contractor shall document all requested changes to these web tools, indicating at a minimum: the individual requesting the change, the nature of the change, the report or tool changed, the date the request was received, and the date the request was implemented.

c) The Contractor shall maintain all web based CRE reports, including the following: Rate

Approximation, Rate Version Comparison, Rate Remapping, Bounding, Rate Version, Definition, Execution, and Pay Adjustment.

d) The Contractors shall maintain the Civilian Rates and Execution tool so that it allows users to upload and download information using spreadsheet templates to make the rates, budget exhibits and manage manpower controls. The elements stored in this tool shall be defined by the Civilian Pay Working Group with the COR directing the changes. Users shall be able to use the tool to compare data sets of previous rates and rates being developed as well as use this tool to research and retrieve information that went into the creation of the previous budget exhibits, manpower controls.

e) The Civilian Rates Execution Tools will be used to create rate and execution data used in

Army Budget Exhibits. Should the budget exhibits required, or the data required for the budget exhibits change, the Contractor shall make all necessary adjustments to the Civilian Rates Execution Tool by the completion date specified by the Government. If the adjustments cannot be made by the date specified, the contractor must inform the COR immediately. The Civilian Rates Execution Tool shall provide data for budget exhibits including but not limited to: OP-32, OP-8, OP-5, and OP-9 reports. The Contractor shall help analyze the impact of any rate or execution data on the budget exhibits the data is used in.

f) For rate generation and execution exercises, the Contractor shall provide a report to the COR and the Chief, SAFM-CEI upon request: The data source(s) used to gather data, including system and organization if applicable; The individual and contact information for that individual who is providing this data; The source tables and data elements; The reports or tools that were used to extract the data; and any code or queries used to extract data including SQL (if applicable).

g) The Contractor shall provide separate business rules for end of year execution and rate execution.

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 .