FMO_PWS_20181108.pdf

PERFORMANCE WORK STATEMENT

Financial Management Operations Support Services

PART 1 - GENERAL INFORMATION

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. Specific duties of the DASA-CE related to Financial Management Operations include: development, implementation and direction of policy, methods and procedures for the U.S. Army Cost and Economic Analysis Program as it relates to financial management activities;

development and maintenance of cost factors, models and estimates to determine requirements for Army installation base operations and civilian personnel in support of the Planning, Programming, Budgeting and Execution System (PPBES) processes.

1.2 Background: 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.1 Concerning the development of models and estimates of the cost of Army installation services and the corresponding support to PPBES process, the contactor must have demonstrated extensive direct experience utilizing the items listed below. Experience utilizing comparable items may also be acceptable.

1.2.1.1 Standard Service Costing (SSC);

1.2.1.2 Installation Status Report (ISR);

1.2.1.3 Stata;

1.2.1.4 PPBES processes supporting Program Objective Memorandum (POM) development for the Installations Program Evaluation Group (II PEG)

1.2.2 Concerning the annual update, analysis and support of the databases supporting the Army Military- Civilian Cost System (AMCOS) and the Civilian Rate Execution (CRE), the contactor must have demonstrated extensive direct experience in applying all the following listed below. Experience in comparable or equivalent systems and applications is also acceptable.

1.2.2.1 Army Training system and knowledge of the ATRM-159, including how to use this report to generate training costs across the Army;

1.2.2.2 Defense Manpower Data Center (DMDC) military and civilian inventory data to the Military Occupational Specialty (MOS) and civilian series level;

1.2.2.3 Knowledge of the Personnel Authorizations Module (PAM) for MOS changes;

1.2.2.4 Army budget exhibits and OPM pay tables;

1.2.2.5 Experience generating Army military and civilian pay rates;

1.2.2.6 Familiarity with other systems that support the Army budget mission, including the Integrated Resource Management Information System (IRMIS) and its civilian pay and civilian pay budget exhibit modules;

1.2.2.7 Developing and maintaining databases used to generate cost models;

1.2.2.8 Creating, updating, optimizing, and maintaining Microsoft SQL Server databases;

1.2.2.9 Creating, refactoring, optimizing, and debugging Microsoft ASP.NET web applications.

1.3 Objectives:

1.3.1 Develop models and estimates of the cost to provide Army installation services at various performance standards in support of the PPBES process - OFF SITE

1.3.2 Develop cost factors and databases supporting the Army Military-Civilian Cost System (AMCOS) - OFF

SITE.

1.3.3 Develop cost factors, databases and web-based reports for Civilian Rate Execution (CRE) - OFF SITE.

1.3.4 Develop performance metrics for ASA(FM&C) - ON SITE

1.4 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 cost data analysis models in support of performance management.

1.5 Reserved

1.6 General Information.

1.6.1 Quality Control: The contractor shall develop and maintain an effective quality control program to ensure services are performed in accordance with this 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 the means by which 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.6.2 Quality Assurance: The Government shall evaluate the performance of the Contractor in accordance with 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.6.3 Government Remedies: The contracting officer shall follow FAR 52.212-4, "Contract Terms and Conditions- Commercial Items" or 52.246-6, "Inspection of Labor Hour" for Contractor's failure to perform satisfactory services or failure to correct non-conforming services.

1.6.4 Reserved

1.6.5 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 at all times 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. The Contractor work force associated with objectives specified in Objectives Sections 1.3.1, 1.3.2, 1.3.3 and 1.3.4 will be performed at the contractor's facility. Contractor must be available to facilitate meetings, as necessary.

1.6.6 Reserved

1.6.7 Security Requirements: The Contractor supporting Tasks 5.2-5.4.6 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 Tasks 5.2-5.4.7 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. The Contractor supporting the Standard Service Costing (SSC) effort (Tasks 5.1-5.1.8 of the contract) is not required to possess a SECRET security clearance.

1.6.7.1 PHYSICAL Security. The Contractor shall be responsible for safeguarding all Government property provided including documents, data files, estimates, program information and other relevant government data provided for Contractor use. At the close of each work period, Government facilities, equipment and materials shall be secured.

1.6.7.2 Key Control. The Contractor shall establish and implement methods of making sure all keys/key cards issued to the Contractor by the Government are not lost or misplaced and are not used by unauthorized persons.

NOTE: All references to keys include key cards. No keys issued to the Contractor by the Government shall be duplicated. The Contractor shall develop procedures covering key control that shall be included in the Quality Control Plan. Such procedures shall include turn-in of any issued keys by personnel who no longer require access to locked areas. The Contractor shall immediately report any occurrences of lost or duplicate keys/key cards to the Contracting Officer. For Contractor work force associated with Objectives Sections 1.3.1, 1.3.2, 1.3.3 and

1.3.4 which are not located in the Pentagon, key control is not applicable.

1.6.7.3 Lock Combinations. N/A

1.6.7.4 Conservation of Utilities. N/A

1.6.8 Special Qualifications: N/A

1.6.9 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.6.10 Contracting Officer Representative (COR): 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 with regard to 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 contract.

1.6.11 Reserved

1.6.12 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.6.13 Contractor Travel: The Contractor may be required to travel CONUS to conduct briefings, attend meetings, or attend training, as required by the Government. Contractor travel shall be consistent with 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.6.14 Reserved

1.6.15 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.6.16 Organizational Conflict of Interest (OCI): Contractor and subcontractor personnel performing work under this contract may receive or have access to proprietary information which may create a current or subsequent 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.6.17 Anti-terrorism / Operations Security;

1.6.17.1 AT Level 1 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 45 calendar days after contract start date or effective date of incorporation of this requirement into the contract, whichever is applicable. The contractor shallsubmit certificates of completion for each affected contractor employee and subcontractor employee, to the COR or to the contracting officer, if a COR is not assigned, within 45 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.6.17.2 Access and general protection/security policy and procedures. Contractor and all associated sub-contractors 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 (FAR clause 52.204-9, Personal Identity Verification of Contractor Personnel) as directed by DOD, 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.6.17.3 For contractors requiring Common Access Card (CAC). Before CAC issuance, the contractor employee requires, at a minimum, a favorably adjudicated National Agency Check with Inquiries (NACI) or an equivalent or higher investigation in accordance with Army Directive 2014-05. The contractor employee will be issued a CAC only if duties involve one of the following: (1) Both physical access to a DoD facility and access, via logon, to DoD networks on-site or remotely; (2) Remote access, via logon, to a DoD network using DoD-approved remote access procedures; or (3) Physical access to multiple DoD facilities or multiple non- DoD federally controlled facilities on behalf of the DoD on a recurring basis for a period of 6 months or more.

At the discretion of the sponsoring activity, an initial CAC may be issued based on a favorable review of the FBI fingerprint check and a successfully scheduled NACI at the Office of Personnel Management.

1.6.17.4 Army Training Certification Tracking System (ATCTS) registration for contractor employees who http://jko.jten.mil/ 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.17.5 For information assurance (IA)/information technology (IT) training. All contractor employees and associated sub-contractor employees must complete the DoD IA awareness training before issuance of network access and annually thereafter. All contractor employees working IA/IT functions must comply with DoD and Army training requirements in DoDD 8570.01, DoD 8570.01-M and AR 25-2 within six months of appointment to IA/IT functions.

1.6.17.6 For information assurance (IA)/information technology (IT) certification. Per DoD 8570.01-M , DFARS 252.239.7001 and AR 25-2, the contractor employees supporting IA/IT functions shall be appropriately certified upon contract award. The baseline certification as stipulated in DoD 8570.01-M must be completed upon contract award.

(1) For contracts that require handling or access to classified information. Contractor shall comply with FAR 52.204-2, Security Requirements. This clause involves access to information classified "Confidential," "Secret," or "Top Secret" and requires contractors to comply with- The Security Agreement (DD Form 441), including the National Industrial Security Program Operating Manual (DoD 5220.22-M); (2) any revisions to DOD 5220.22-M, notice of which has been furnished to the contractor.

1.6.17.7 Threat Awareness Reporting Program. For all contractors with security clearances. Per AR 381-12 Threat Awareness and Reporting Program (TARP),contractor employees must receive annual TARP training by a CI agent or other trainer as specified in 2-4b.

1.6.18 SECTION 508 Compliance Requirements.

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 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 of 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.

The contractor shall indicate for each product or service provided in support of this Statement of Work 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.

§ 1194.21 Software applications and operating systems § 1194.22 Web-based Intranet and Internet information and applications § 1194.23 Telecommunications products http://www.section508.gov/

§ 1194.24 Video and multimedia products § 1194.25 Self-contained, closed products § 1194.26 Desktop and portable computers

§ 1194.31 Functional Conformance Criteria

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 in order to assess any potential accessibility impact, determine which commercial-off-the-shelf (COTS) products could be used to solve the particular 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.

PART 3 - GOVERNMENT FURNISHED PROPERTY, EQUIPMENT AND SERVICES

3.1 GENERAL

3.1.1 The Government will provide reasonable access to its facilities, key people, 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.

3.2 Equipment: Government-furnished equipment will not be provided for Sections 1.3.1, 1.3.2,

1.3.3 and 1.3.4 for the Contractor work force outside of the Pentagon.

3.3 Services: 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 4 - CONTRACTOR FURNISHED ITEMS AND SERVICES

4.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.

4.2 Secret Facility Clearance: The Contractor shall possess or be eligible to receive and maintain "FOR OFFICIAL USE ONLY" from the Defense Security Service in accordance with PWS, Para 1.6.7. 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 upon award of 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

The contractor will be required to safeguard all data and equipment in its possession and report to the appropriate Government organization any incidents involving unauthorized access.

The contractor shall comply with FAR Clause 52.204-2 Security Requirements.

PART 5 - SPECIFIC TASKS

5. BASIC SERVICES: 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). DASA-CE and its staff is hereafter referenced as "the customer".

5.1. 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.

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

Deliverable 1 (CDRL A001)

5.1.1.1 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, SAFM-CES-S 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, by the Chief, SAFM-CES-S or COR. The Contractor must complete this process by May 1st of each year, or as directed by the Government.

5.1.1.2 The Contractor shall provide electronic Microsoft 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 equations, formulas, transformations, intermediate calculations, or other adjustments performed for normalization. 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 Microsoft Access and Excel within 30 calendar days after receiving a request for update from the Chief, SAFM- CES-S 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 COR and the Chief, SAFM-CES-S 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; the dates included in the data set; 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.

5.1.1.3 The Contractor shall supply to the Chief, SAFM-CES-S all indices used in the transformation of data, including but not limited to: inflation indices, regional adjustment indices, any service-based adjustments and installation specific indices. The Contractor shall adjust these indices as directed by SAFM-CES-S personnel.

5.1.1.4 The Contractor shall supply a report of business rules used for each transformation. The initial 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 COR and the Chief SAFM-CES-S no later than April, or as directed by the Government. All of the business rules supplied must be approved by the Chief SAFM-CES-S before the contractor shall use these rules to transform any data. Should a new business rule be developed or discovered after the initial submission and approval of business rules, the Contractor shall submit the proposed business rule in writing to the Chief SAFM-CES-S. Upon approval, the new rule shall be incorporated into the normalization process.

This report shall contain at a minimum:

A numeric identifier for the business rule; a category for the business rule;

Any data that is removed from the corrected data and the rationale for removing this data; 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 amounts, the records affected and the rationales and amounts for any 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.

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

5.1.1.5 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 STANFINS and GFEBS. Other sources of information may be specified by SAFM-CES-S personnel.

5.1.1.6

Deliverable 2 (CDRL A002)

5.1.1.6.1 The Contractor shall develop cost estimating relationships (CERs). The Contractor shall utilize data from at least the previous four fiscal years unless directed otherwise by government personnel. The contractors shall also use, at a minimum, the following data: historical cost information, quantitative data from the ISR, performance data from the ISR, population data from ASIP and infrastructure data from HQIIS. The Contractor shall also utilize data from other sources as directed by the COR or designated representative from SAFM-CES- S. Cost estimating relationships shall be developed annually, in batches, with all batches developed by 30 September. All CER's are subject to review and approval by the Chief, SAFM-CES-S 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, both improved and unimproved. The Contractor shall also test variations, modifications, or alternate forms of variables as directed by the COR.

5.1.1.6.2 For each cost estimating relationship (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;

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

5.1.1.6.3 For each cost estimating relationship (CER), the Contractor shall test the derived relationship against at least three years of historical input data, unless direction or approval is given by the Chief SAFM-CES-S or personnel designated by the Chief SAFM-CES-S. The Contractor shall identify variables to categorize installations for analysis. The contractor shall conduct analysis and derive categories based on variables identified by SAFM- CES-S 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-CES-S for approval. Contractor shall conduct exploratory testing using various statistical methods for the purposes of developing requirements as directed by the Chief SAFM-CES-S or the COR.

5.1.1.7 The Contractor shall provide electronic Stata and Microsoft EXCEL analyses for each service cost estimate and cost estimating relationship. The Chief, SAFM-CES-S or COR will provide the schedule and priority order for generating CERs. As scheduled, the Contractor shall brief the results, inputs and all equations and goodness-of-fit statistics to the Chief, SAFM-CES-S, COR or designated representative. Each analysis should include electronic and hard copy documentation provided for in sections 5.1.1.5 - 5.1.1.6. The Contractor shall review this information with personnel identified by the Chief, SAFM-CES-S.

Documentation must be sufficient for identified personnel to be able 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-CES-S personnel.

5.1.1.8 The Contractor shall provide Microsoft 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 transactions. Mapping rules include but are not limited to: mappings to services, mappings to installations, mappings to commands or organizations.

5.1.1.9 All mapping rules are subject to review and modification by the Chief SAFM-CES-S prior to their use in generating adjusted or normalized data or cost estimating relationships.

Deliverable 3 (CDRL A003)

5.1.1.10 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.

5.1.1.11 The Contractor shall refine and build adjustment table(s) for de-normalization of data and application of performance adjustments. De-normalization of data is required to add in Installation-specific factors, remove non- Operations and Maintenance appropriation direct dollars and ultimately generate an Installation-unique requirement.

5.1.1.12 The Contractor shall provide query support as identified by the Chief, SAFM-CES-S. The Contractor shall provide any source data, tables, procedures, statistical packages, and any historical data, including the data, procedures, business rules, or outputs of SSC costing efforts from prior cycles.

Deliverable 4 (CDRL A004)

5.1.2 The Contractor shall develop a database for Base Operations Support requirements. The contractor shall create a table structure, input forms and output reports.

5.1.2.1 The contractor shall provide no later than Nov 1st 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 any filter, conditioning, or formatting applying to the output reports;

and all processes used to calculate Base Operations Support requirements and any tables and data elements containing costing factors or assumptions.

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

5.1.3.1 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 COR and Chief SAFM-CES-S no later than November 15th of each year, or as directed by the Chief, SAFM-CES-S.

5.1.3.2 The Contractor shall prepare data input tables necessary to develop POM requirements as directed by the Chief, SAFM-CES-S.

5.1.3.3 The Contractor shall support validation of outputs from models, compare results with past model outputs and historical costs. The contractor shall provide additional analysis and data to support validation as directed by the Chief, SAFM-CES-S. The Contractor shall provide a spreadsheet report documenting changes to models and outputs from prior year(s).

5.1.3.4 The Contractor shall develop and/or update all SSC documentation, as directed by the COR or Chief

SAFM-CES-S.

5.1.4 The Contractor shall provide general cost estimating and database management support.

5.1.4.1 The Contractor shall conduct ad-hoc cost analysis as directed by SAFM-CES-S personnel. The Contractor shall provide documentation of all estimates derived in support of such efforts, including data sources, calculations and assumptions.

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

5.1.5 The Contractor shall provide monthly status report that summarizes the work performed during the month. Contractor reports shall be submitted in writing to the COR and the Chief SAFM-CES-S or designated representative.

Reports shall contain at a minimum:

The status of cost estimating relationships for each service;

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

Issues encountered with calculations for service costs, cost estimating relationships or BOS requirements; The number and methodology used to validate Cost Estimating Relationships; The status of review and acceptance of Contractor Generated Products and Reports by SAFM-CES-S personnel; The number and nature of ad hoc support analysis and validation performed in support of SAFM-CES-S;

The dates of the last refreshes and updates to databases and tables for cost estimating relationships and applicable business intelligence reports; and The number of hours billed to perform the above tasks by individual by month and the associated rate. The Contractor shall tie hours billed back to the appropriate PWS items above.

5.1.6 Contractor shall notify the COR and Chief SAFM-CES-S 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 government 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.

5.2 Update, analyze and support the databases used in Civilian Rate Execution (CRE).

Deliverable 5 (CDRL A005)

5.2.1 The Contractor shall maintain and upgrade web reports as well as web applications that make up the Civilian Rate Execution Tool 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 in order to meet manpower controls, create budget exhibits and produce civilian pay rates.

5.2.1.1 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.

5.2.1.2 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.

5.2.1.3 The Contractors shall maintain the Civilian Rate 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 SAFM- CES-S personnel. 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.

5.2.1.4 The Civilian Rate 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 Rate Execution Tools 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 Rate Execution Tools 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.

5.2.1.5 The Contractor shall provide monthly status reports for the items in 5.2.1. The contractor shall provide a written report to the COR and the Chief, SAFM-CES-S containing at a minimum: The status and projected completion dates of all requested modifications to web based tools and reports; the status of completion of the rates and major products leading up to the rates. The status of completion of all budget exhibits; Any outstanding data issues or discrepancies requiring resolution; Any projected outages or unavailability of tools or reports; Any rates that have been contested by Army organizations; and Any logic changes affecting rates, tools, or reports.

5.2.2 The Contractor shall provide comprehensive analysis and support to help the COR ensure all pay and benefits rates are defendable and acceptable to the Civilian Pay Working Group (CPWG). The Contractor will provide analysis and support to explain how rate changes impact the budget and budget exhibits.

5.2.3 The Contractor shall be responsible for obtaining data from source systems and shall use source systems as directed by government personnel. In the event that the Contractor is unable to obtain this data, the Contractor shall notify the Chief SAFM-CES-S immediately. The Contractor shall provide source data to SAFM-CES-S personnel upon request.

Deliverable 6 (CDRL A006)

5.2.4 For rate generation and execution exercises, the Contractor shall provide a report to the COR, the Chief, SAFM-CES-S and the Personnel Costing Team Lead containing: 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).

5.2.5 The Contractor shall provide separate business rules for end of year execution and rate execution. For all rate generation and execution exercises, where the business rules change, the Contractor shall provide a list of all data processing rules and transformations containing at a minimum: Definitions of all data elements used, Processing rules for each subgroup within the data, Any exceptions to normal rules, and Source code with documentation for all processing.

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

For all rate generation and execution exercises, where the business rules change, the Contractor shall provide a list of all data processing rules and transformations containing at a minimum: Definitions of all data elements used, Processing rules for each subgroup within the data, Any exceptions to normal rules, and Source code with documentation for all processing.

Deliverable 7 (CDRL A007)

5.2.7 The Contractor shall review all data extraction and processing rules with the Chief SAFM-CES-S or a designated representative and the Civilian Pay Working Group at mid-year, before end of year execution, after end of year execution and before the creation of the POM pay rates or as required by the CPWG. The Contractor shall make any changes to its processes as designated by SAFM-CES-S personnel, and clearly document the changes.

5.3 Update, analysis and support of the databases supporting the Army Military-Civilian Cost System (AMCOS).

5.3.1 The Contractor shall update the AMCOS database with the annually revised pay tables and inventory for civilians and military, inflation indices, Treasury discount rates, zip codes, military MOSs and civilian series by March 31 each year. If indices are not received, the "Spring" Update delivery will proceed on-time without new indices/rates.

5.3.2 The Contractor shall review all data used to update AMCOS tables for completeness and consistency.

Any transactions or values that fall outside of historical trends or are infeasible shall be brought to the attention of the Chief, SAFM-CES-S or a designated representative. The contractor shall provide a list of all values that are either infeasible, or vary more than 15% from prior years values. The Contractor shall adjudicate data issues as directed by SAFM-CES-S personnel.

5.3.3 The Contractor shall assist SAFM-CES-S personnel in documenting calculations for pay, benefits and training rates. The contractor shall research code and document each cost element process, update the Cost Element Data Dictionary's cost element description, business logic, basis of computations, and data source for existing (where necessary) and new cost elements in the AMCOS "Big Book" reference Guide The Contractor shall provide necessary information to SAFM-CES-S personnel sufficient to identify in detail how all calculations and outputs are produced. The Contractor shall update this information at a minimum every 6 months or as requested by the Chief SAFM-CES-S or the Personnel Costing Team Lead. The Contractor shall indicate: The tables that provide source information for use in generating rates; If there are any conditions or stratifying variables; Any hard-coded rules or variables; and Any assumptions or variables contained within tables and what outputs they impact.

5.3.4 The Contractor shall make all changes necessary to AMCOS, including but not limited to: tables, calculations, reports, web applications, or source code necessary to ensure that AMCOS functionality and designs comply with requirements and methodologies established by SAFM-CES-S personnel. Upon receipt of design, functional requirements or methodologies for provided by SAFM-CES-S personnel, the Contractor shall have one month or shall complete identified changes and upgrades based on a timeline provided by the Chief SAFM-CES-S to make necessary modifications to AMCOS. The Contractor shall notify the COR and the Chief SAFM-CES-S when these modifications are complete. Upon request, the Contractor shall furnish the table structures and code used in the relevant calculations.

5.3.5 The Contractor shall ensure that AMCOS tables and products are maintained in Microsoft SQL Server and compatible products unless directed otherwise by the COR or Chief SAFM- CES-S.

5.3.6 The Contractor shall ensure that all AMCOS code is in compliance with the DODI 8510.01 Risk Management Framework (RMF) for DoD Information Technology (IT) or Government security/risk requirements that supersede RMF.

Deliverable 8 (CDRL A008)

5.3.7 The Contractor shall be accredited at CMMI-DEV Maturity Level 3.

5.3.8 The Contractor shall work with DASA-CE to implement enhancements to the AMCOS system. This includes participating in discussions/working groups, providing feedback to the customer on complexity and level of effort for the enhancements, and ultimately implementing the enhancements on schedule as directed to by COR.

Deliverable 8 (CDRL A008)

5.3.9 The contractor shall update the structured cost database for AMCOS. This update includes identifying, collecting and processing all the cost data for the fall update by 30 September each year unless the data is available sooner and then may be included in the A007 deliverable.

5.3.10 The Contractor shall provide AMCOS data in Microsoft SQL Server compatible software that is accessible through the DASA-CE and AMCOS web sites. The Contractor shall also maintain and update the AMCOS web sites as well as relevant links on the DASA-CE web sites. The Contractor shall make changes to the presentation and outputs on the websites as directed by SAFM-CES-S personnel. The Contractor shall make necessary changes, test and implement these changes. All changes shall be documented and approved by the Chief SAFM-CES-S. Changes may include but are not limited to: changes in pick lists, filter fields, report formats, interfaces, features and graphics. The Contractor shall implement all such modifications within 2 weeks.

5.3.11 Contractor shall support SAFM-CES-S personnel with external data requests, provide any necessary data from AMCOS tables, files, or information on rates or outputs calculated by AMCOS.

5.3.12 The Contractor shall attend meetings that are relevant to AMCOS or personnel costing as directed by the Chief, SAFM-CES-S as needed. All necessary travel expenses shall be identified in advance and submitted to the COR consistent with Federal guidance and regulations. Travel and all associated costs will be approved prior to any actual trips are undertaken. The Contractor shall not represent any government entity, nor make any decisions or obligate any government personnel or entities to a course of action, when attending meetings.

5.3.13 The contractor shall ensure that all cost and inventory information can be extracted from the AMCOS website into a Microsoft Excel spreadsheet. The Contractor shall provide a Microsoft Access database within a week of a major update as requested by Chief SAFM-CES-S and the Personnel Costing Team Lead.

The database shall contain:

All inventory tables for all civilians and military personnel;

All pay, allowance and benefits related costs for military, civilians and contractors, segmented by component, pay plan, grade, years of service, MOS or occupational series and locality (if applicable);

All non-DOD costs for soldiers and civilians; and All associated operational costs necessary to provide a fully burdened cost estimate.

5.3.14 The Contractor shall provide Customer/Tech Support for the web site and applications in support of AMCOS. The Contractor shall maintain a helpdesk. The helpdesk shall: field inquiries from users and respond within 48 hours 95 percent of the time; maintain account creation process and instructions and facilitate the creation of accounts;…