RFP SPRPA121R006U Sole Source FlexFile Part 1 - Metadata and Structures_02 Sept 2021 Attachment 4 .xlsx
XLSX spreadsheet 42 KB Posted
- Solicitation number
- SPRPA121R006U0001
- Issued by
-
Defense Logistics Agency Aviation
About this file
This document contains a template for reporting cost and hour data related to a federal contract. The template includes worksheets for configuration of report metadata and structures, such as security classification, program name, reporting organization details, contract information, work breakdown structure, functional categories, units, reporting calendar, and allocation methods. Contractors are required to complete highlighted sections of the template, including report configuration, metadata, orders or lots, contract line items, end items, work breakdown structure, accounts, functional categories, units or sublots, reporting calendar, summary cost data, and allocation methods. Instructions are provided for what data each table contains and how to use the template for submissions.
View the file
Other files
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
Template Info
| CSDR Cost and Hour Report (Flex File) Alternative Submission Template |
| Part 1 - Metadata and Structures |
| Version 1.0 |
| March 5, 2019 |
| **FOR THE PURPOSE OF THIS SOLE SOURCE RFP, THE OFFEROR SHALL COMPLETE ALL WORKSHEETS HIGHLIGHTED IN GREEN ALONG WITH ITS CORRESPONDING COLUMNS ALSO HIGHLIGHTED IN GREEN. ALL TABS HIGHLIGHTED IN RED ARE NOT REQUIRED FOR THIS SOLE SOURCE RFP. |
| **THE CONTRACTOR IS STILL REQUIRED TO COMPLETE THE FLEXFILE REQUIREMENT IN ITS ENTIRETY ACCORDING TO THE COST AND HOUR DID, DD FORM 2794 (CSDR PLAN), AND OTHER FORMS AND GUIDANCE. |
| Part 1 – Metadata and Structures contains important information for configuring and organizing the cost-hour data being reported against the respective CSDR reporting requirements. |
For information about what data fields each table contains, and how to use them, refer to the Data Exchange Instructions (DEI).
Data for this part can be submitted using the “Part 1 - Metadata and Structures” XLSX template. The same data, subject to maintenance, can typically be re-used across multiple submissions.
| Worksheets: |
| Report Configuration |
| Report Metadata |
| Orders or Lots |
| CLINs |
| End Items |
| Work Breakdown Structure |
| Accounts |
| Functional Categories |
| Functional Overhead Categories |
| Units or Sublots |
| Reporting Calendar |
| Summary Cost Data |
| Allocation Methods |
| Allocation Components |
Report Configuration
| Report Configuration | |
| Field | Value |
| Detailed Standard Category |
Author: Supported values:
TRUE
FALSE
GA as Standard Category Author: Supported values:
TRUE
FALSE
FCCM as Standard Category Author: Supported values:
TRUE
FALSE
FAC by Nonrecurring/Recurring Author: Supported values:
TRUE
FALSE
FAC by Standard Category Author: Supported values:
TRUE
FALSE
Report Metadata
| Report Metadata | |
| Field | Value |
| Security Classification | |
| Proprietary Statement | |
| Program Name | |
| Phase or Milestone ID |
Author: Supported values:
PRE_A
A B
C_LRIP
C_FRP
O_AND_S
MULTIPLE
| Prime Mission Product |
| Commodity Type |
| Reporting Organization/Organization Name |
| Reporting Organization/Division Name |
| Reporting Organization/CAGE Code |
| Reporting Organization/Location/Street |
| Reporting Organization/Location/City |
| Reporting Organization/Location/State |
| Reporting Organization/Location/Zip Code |
| Reporting Organization/Location/Country |
| Approved Plan Number |
| Approved Plan Revision Number |
| Customer Name |
| Contract Type ID |
Author: Supported values:
CS
CPAF
CPFF
CPIF
CPIF_PI
FFP
FPIF
FPIST
FPIST_PI
FPIFT_PI
FPAF
FP_EPA
FP_PPR
FCP_RPR
FFP_LOET
IDIQ
LC
TM
OTHER
MULTIPLE
Author: Supported values:
PRE_A
A B
C_LRIP
C_FRP
O_AND_S
| MULTIPLE | Contract Price |
| Contract Ceiling | |
| Contract Number | |
| Period of Performance/Start Date | |
| Period of Performance/End Date | |
| Report Cycle ID |
Author: Supported values:
INITIAL
INTERIM
FINAL
| Submission Event/Number |
| Submission Event/Name |
| Submission Event/Is Wildcard |
Author: Supported values:
TRUE
FALSE
| Resubmission Number | |
| Report As Of | |
| Point of Contact/Name | |
| Point of Contact/Department | |
| Point of Contact/Telephone Number | |
| Point of Contact/Email Address | |
| Date Prepared | |
| Report Period ID | 1 |
Orders or Lots
| Orders or Lots | ||
| ID | Name | Phase or Milestone ID |
Author: Supported values:
PRE_A
A B
C_LRIP
C_FRP
O_AND_S
MULTIPLE Customer Name Contract Type ID Author: Supported values:
CS
CPAF
CPFF
CPIF
CPIF_PI
FFP
FPIF
FPIST
FPIST_PI
FPIFT_PI
FPAF
FP_EPA
FP_PPR
FCP_RPR
FFP_LOET
IDIQ
LC
TM
OTHER
| MULTIPLE | Contract Price | Contract Ceiling | Period of Performance |
| Start Date | Period of Performance | ||
| End Date | Appropriation Type ID |
Author: Supported values:
RDTE
PROCUREMENT
O_AND_M
CLINs
| CLINs | ||
| ID | Name | Contract Type ID |
Author: Supported values:
CS
CPAF
CPFF
CPIF
CPIF_PI
FFP
FPIF
FPIST
FPIST_PI
FPIFT_PI
FPAF
FP_EPA
FP_PPR
FCP_RPR
FFP_LOET
IDIQ
LC
TM
OTHER
MULTIPLE
End Items
| End Items | |
| ID | Name |
Work Breakdown Structure
| Work Breakdown Structure | |||
| Level | ID | Name | Parent ID |
Accounts
| Accounts | |
| ID | Name |
Functional Categories
| Functional Categories | |
| ID | Name |
Functional Overhead Categories
| Functional Overhead Categories | |
| ID | Name |
Units or Sublots
| Units or Sublots | ||||
| ID | End Item ID | First Unit Number | Last Unit Number | Order or Lot ID |
Reporting Calendar
| Reporting Calendar | ||
| ID | ||
| Author: Values must start at 1 and proceed sequentially (i.e. 1, 2, 3, etc.) | Start Date | End Date |
Summary Cost Data
| Summary Cost Data | ||||||||||||
| Order or Lot ID | Subtotal_TD | Subtotal_AC | GA_TD | GA_AC | UB | MR | FCCM_TD | FCCM_AC | Fee_TD | Fee_AC | Price_TD | Price_AC |
Allocation Methods
| Allocation Methods | |
| ID | Allocation Method |
Type ID Author: Supported values:
PERCENT
PRORATE Is Unit or Sublot Allocation Method Author: Supported values:
TRUE
FALSE Name
Allocation Components
| Allocation Components | |||||
| Allocation Method ID | Order or Lot ID | End Item ID | WBS Element ID | Unit or Sublot ID | Percent Value |
File details come from the government source that posted it. Updated .