Attachment C- Financial M. Reporting FINAL.pdf
PDF 256 KB Posted
- Attached to
- MECHANICAL INTEGRATED SERVICES AND TECHNOLOGIES (MIST II) Federal contract opportunity
- Solicitation number
- 80GSFC20R0006
About this file
This attachment provides the financial reporting requirements for a NASA contract. The contractor must submit NASA Form 533 reports on a monthly and quarterly basis with detailed direct labor hours and costs by labor category and subcontractor. Variances exceeding 10% between estimated and actual hours and costs require a narrative explanation. Reports are due by the 10th day of each month for the prior month and the 15th day preceding the quarter for the quarterly report. The reports must include direct labor hours and costs by labor category and subcontractor for onsite, offsite, and computer telecommunications facility work, as well as overhead, other direct costs, and fee information. This attachment defines the data elements and formatting requirements for cost and task data files the contractor must submit to NASA's CORTS application on a monthly basis.
View the file
Other files for this federal contract opportunity
Show all 50
MECHANICAL INTEGRATED SERVICES AND TECHNOLOGIES (MIST II) has more files on GovTribe.
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
80GSFC20R0006
SEPTEMBER 2019
ATTACHMENT C
FINANCIAL MANAGEMENT REPORTING
REQUIREMENTS
DRFP
CONTRACT TBD
Contract TBD
Attachment C
(06/2014) 2
FINANCIAL MANAGEMENT REPORTING REQUIREMENTS
Financial Management Reports shall be submitted by the Contractor on the NASA 533 series reports, in accordance with the instructions on the reverse of the forms, NASA
Procedural Requirements NPR 9501.2E entitled "NASA Contractor Financial
Management Reporting,” dated May 27, 2011, and additional instructions issued by the
Contracting Officer.
a. Level of Detail
An individual 533 Report shall be provided for each Task Order in addition to a cumulative 533 Report summarizing all Task Orders issued. The reports shall contain a breakdown of hours and costs by the elements of cost categories listed in Section d below.
b. Variance Narrative Reporting
In accordance with Section 3.6 of NPR 9501.2, the Contractor shall include a narrative explanation for variances exceeding plus or minus 10%, (+/- 10%) between the Total
Direct Labor Hours (prime and subcontractors) and/or Total Estimated Cost amount shown in the prior month and the Actual Total Direct Labor Hours and/or Actual Total
Cost amount shown in the current month for each individual task order. (For example, the Total Estimated Cost amount shown for June in column 8a in the May NF 533M and the Actual June Total Cost amount shown in column 7a in the June NF 533M.)
Each variance narrative shall explain the: (1) reason for the variance, (2) impact(s) on the individual task order, and (3) specific corrective action(s) being taken or to be taken.
c. Distribution
The Contractor shall distribute 533 reports to each addressee indicated in the contract clause entitled, "Financial Management Reporting." The Contractor shall submit an initial report in the NF 533Q format within 30 working days after contract award.
After the initial report, the NF 533M reports shall be distributed not later than the tenth
(10th) working day following the close of the contractors' monthly accounting period.
The 533Q reports shall be distributed not later than the fifteenth (15th) day of the month preceding the quarter being reported. The NF 533M need not be submitted in months in which an NF 533Q is submitted.
Submit To Contract RA: .txt upload files monthly (see attached sheets) not later than the tenth (10th) working day following the close of the contractors' monthly accounting period.
d. Reporting Requirements
(06/2014) 3
Each individual report shall, at a minimum, provide cost data by the following elements of cost categories:
1. Prime Direct Labor Hours:
Prime Direct Labor Hours – Onsite
(List applicable labor categories)
Prime Direct Labor Hours – Offsite
Prime Direct Labor CTF – Offsite hours
Total Prime Direct Labor Hours
2. Subcontractor Direct Labor Hours:
Subcontractor A Direct Labor Hours – Onsite
Subcontractor A Direct Labor Hours – Offsite
(List applicable labor categories)
Subcontractor A CTF – Offsite hours
Subcontractor B Direct Labor Hours – Onsite
Subcontractor B Direct Labor Hours – Offsite
(List applicable labor categories)
Subcontractor B CTF – Offsite hours
Subcontractor C Direct Labor Hours – Onsite
Subcontractor C Direct Labor Hours – Offsite
(List applicable labor categories)
Subcontractor C CTF – Offsite hours
Total Subcontractors Direct Labor Hours – Onsite
Total Subcontractors Direct Labor Hours – Offsite
Total Subcontractors Direct Labor Hours – CTF Offsite
Total Subcontractors Direct Labor Hours
(06/2014) 4
3. Total Prime and Subcontractors Direct Labor Hours:
Total Prime and Subcontractors Hours – Onsite
Total Prime and Subcontractors Hours – Offsite
Total Prime and Subcontractors Hours – CTF Offsite
Total Prime and Subcontractors Direct Labor Hours
4. Prime Direct Labor Costs:
Prime Direct Labor Costs - Onsite
Prime Direct Labor Costs – Offsite
Prime Direct Labor CTF – Offsite Costs
Total Prime Direct Labor Costs
5. Prime Overhead Expenses:
Onsite Overhead
Offsite Overhead
Total Prime Overhead
Total Loaded Prime Direct Labor Cost
6. Other Direct Costs (ODCs):
a. Subcontracts (list separately, Subcontractor A, B, C, etc.)
To be broken down by Onsite, Offsite, CTF Offsite and a Total for each
Subcontractor
Total Subcontractors Direct Costs
Total Labor Hours = Prime Total + Sub Total
b. Material – broken out by Each Sub
c. Travel – broken out by Each Sub
d. Other (specify) – broken out by Each Sub
(06/2014) 5
Sample: Subcontractor A – Materials
Subcontractor A – Travel
Subcontractor A – Other ODCs
Total Subcontractor A – ODCs
Total ODCs
7. Subtotal (Direct Labor, Overhead & ODCs)
8. G&A Cost
9. Total Estimated Cost
10. Fixed Fee
11. Total Cost-Plus-Fixed-Fee (CPFF)
(06/2014) 6
Requirements for Contractor Cost Import File with Task Value
The contractor cost data for import into the CORTS application will come from the contractor as a comma-delimited text file. The layout of this import file is shown in the table below.
Only one contract can be included in one import file.
Two types of data will be included in the import file: column title and column data.
Column titles must be provided in the first row for each data column in the import file. The name and order of each column title must be exactly the same as illustrated in the “Column
Title in File” column in the table below, with a comma as a delimiter. NOTE: Do not use the names in the “Data Element Name” column as the column titles for the data columns in the file being sent for import.
Column data will be provided beginning with the second row. A data element must be in each column/row in the import file. The order of each column data must be exactly the same as illustrated in the “Column Title in File” column in the table below, with a comma as a delimiter.
All columns are mandatory and must have a value.
The Report Ending Date is in the MM/YYYY format and must be the previous month of the current import date.
Two tables will be updated in CORTS: Subtask and Subtask Detail.
When a task/subtask number exists, the subtask will be treated as an existing subtask and the associated subtask accrued cost amount fields will be overwritten with the corresponding amounts in the import file. The pro-rate rules will then be applied to all subtask detail records
When a subtask number does not exist, a new subtask record and associated subtask detail record will be created with a default value of ‘999999999’ for both fund and WBS.
No deletion will be performed in this process.
(06/2014) 7
Data Element Name Column Title In File Type Size Value
(0-optional, 9-mandatory)
Comments
Report Ending Date ReportDate Text 7 99/9999 Must be the previous month of the current import date.
Contract Number ContractNo Text 10 XXXXXXXXXX NNG07CA18C
Task Number TaskNumber Text 6 XXXXXX Must be the same as it’s defined in CORTS Web.
Subtask Number SubTask Text 6 XXXXXX Must be the same as it’s defined in CORTS Web.
Cumulative Cost CumCost Numeric 13.2 0000000000009.00
Accrued Cost AccruedCost Numeric 13.2 0000000000009.00
Cost Estimate CostEstimate Numeric 13.2 0000000000009.00
Hours Estimated EstHours Numeric 7.2 0000009.00
On Site Hours OnSiteHours Numeric 7.2 0000009.00
Off Site Hours OffSiteHours Numeric 7.2 0000009.00
Task Value TaskValue Numeric 13.2 0000000000009.00
File details come from the government source that posted it. Updated .