Attachment J.1-F – 533M Sample.xlsx
XLSX spreadsheet 1 MB Posted
- Attached to
- Safety and Mission Assurance (SMA) Engineering and Technical Services (SETS) Draft RFP Federal contract opportunity
- Solicitation number
- 80GRC021R0011
About this file
This document provides a draft request for proposal for Safety and Mission Assurance Engineering and Technical Services. The National Aeronautics and Space Administration Glenn Research Center plans to issue a solicitation seeking administrative support services, communication and professional development services, and technical knowledge services. The anticipated release date of the request for proposal is January 3rd, 2022, with an offer due date of February 2nd. The acquisition is set aside for woman-owned small businesses under North American Industry Classification System code 611430 for professional and management development training, with a size standard of $12,000,000. Potential offerors are encouraged to attend a virtual industry day on November 17th and monitor the System for Award Management website for the issuance and any amendments to the solicitation.
View the file
Other files for this federal contract opportunity
Show all 17
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
Instructions
| GENERAL INSTRUCTIONS |
| This supplemental report should be consistent with the 533M reported each month. Total amounts by Task, and for the Contract as a whole should match those on the 533M. This template is designed to accomodate the 533M reports submitted by all of the contractors each month. Since these formats have variations, and are not reported consistently across contracts, there may be columns or records that may not apply to a specific contract. Sometimes a 533M will report data at a lower level than this template requires--in those cases, records may have to be aggregated and reported at a summarized level in order to get the totals to match between the report. |
| This template is divided into two parts. The header record contains information in the top part of each page of the 533M. There will be one header record for each page of the 533M. The detail records contain the information on the bottom of each part of the 533M. The number of detail records will vary by page for each contract, but they will correspond to the possible Reporting Categories listed. There is a maximum of 27 detail records for each header record, since there are 26 possible Reporting Categories listed, plus a total record. Many contracts will not report all of the Reporting Categories listed, so they may have fewer than 27 detail records. Other contracts may report more than 23 Reporting Categories on the 533M, if so, some of those will have to be aggregated to fit into these more generic reporting categories. After aggregation, there will be at most 26 Reporting Categories. |
It is required to be electronically submitted with the 533M each month in Excel or CSV format.
| HEADER | INSTRUCTIONS | Max Field Length |
| HEADER Tab title must always remain in same format (Spelling, Spacing, etc.) and be first tab of the workbook. | ||
| RECORD TYPE | Should always be "H" | 1 |
| REPORTING YEAR | Calendar year for the reporting period (example: 2015) | 4 |
| REPORTING MONTH | Calendar month number for the reporting period end (example: January would be 1, February would be 2, etc) | 2 |
| REPORT VERSION | Initial submission each month is 1, incrementing by 1 for each (if any) revised reports submitted | 1 |
| OUTLINE AGREEMENT | NASA Outline Agreement number | 10 |
| CLIN | NASA CLIN (contract line item number) if applicable, if not leave blank | 1 |
| TASK AWARD | NASA Task Order/Delivery Order (TO/DO) number if applicable, if not leave blank. | 10 |
| CAPITAL ASSET | Enter "Yes" if the TO/DO is for a capital asset, if not leave blank | 3 |
| CONTRACT TYPE | Type of contract. See contract type worksheet for possible abbreviations. | 2 |
| SCOPE OF WORK | Description\name of contract or task (maximum 255 characters) | 255 |
| LATEST DEFINITIZED MOD # | Number of latest definitized modification received by contractor | 2 |
| REPORT FOR PERIOD ENDING | Date of accounting period end for reporting period (mm/dd/yyyy) | 10 |
| NUMBER OF WORKING DAYS | Number of working days for the reporting period | 2 |
| CONTRACT VALUE COST | Rounded to the nearest whole dollar - The total dollar value of definitized cost of all currently authorized work to be performed under the contract | 14 |
| CONTRACT VALUE FEE | Rounded to the nearest whole dollar - The total dollar value of definitized fee of all currently authorized work to be performed under the contract | 14 |
| FUND LIMITATION | Rounded to the nearest whole dollar - The total dollar value of funds obligated on the contract | 14 |
| INVOICE AMTS BILLED | Rounded to the nearest whole dollar - The total dollar value of invoices billed against the contract | 14 |
| TOTAL PAYMENTS | Rounded to the nearest whole dollar - The total dollar value of payments received for the contract | 14 |
| 533 DATA | INSTRUCTIONS | |
| 533 Data Tab title must always be in same format (Spelling, Spacing, etc) and be second tab of the workbook | ||
| RECORD TYPE | Should always be "D" | 1 |
| REPORTING YEAR | Calendar year for the reporting period (example: 2015) | 4 |
| REPORTING MONTH | Calendar month number for the reporting period end (example: January would be 1, February would be 2, etc) | 1 or 2 depending on month |
| REPORT VERSION | Initial submission each month is 1, incrementing by 1 for each (if any) revised reports submitted | 1 |
| OUTLINE AGREEMENT | NASA Outline Agreement number | 10 |
| CLIN | NASA CLIN (contract line item number) if applicable, if not leave blank | 1 |
| TASK AWARD | NASA Task Order/Delivery Order (TO/DO) number if applicable, if not leave blank | 10 |
| CAPITAL ASSET | Enter "Yes" if the TO/DO is for a capital asset, if not leave blank | 3 |
| CATEGORY | CATEGORY (ABV) - See Reporting Category worksheet for values to be provided. | 3 |
| REPORTING CATEGORY | REPORTING CATEGORY (ABV) - See Reporting Category worksheet for values to be provided. | 3 |
| Cost/Hours |
7a
| CURRENT MONTH ACTUAL | Enter the total actual cost incurred/hours worked for the accounting period being reported, consistent with the amount reported on the 533M report. | 14 |
| Cost/Hours |
7b
| CURRENT MONTH PLANNED | Enter the total planned cost/hours worked for the accounting period being reported, the planned cost is obtained from the time-phased baseline plan which includes the original contract value plus authorized changes, consistent with the amount reported on the 533M report. | 14 |
| Cost/Hours |
7c
| CUMULATIVE ACTUAL | Enter the total cumulative to date actual cost incurred/hours worked through the accounting period being reported, consistent with the amount reported on the 533M report. | 14 |
| Cost/Hours |
7d
| CUMULATIVE PLANNED | Enter the total cumulative to date planned cost/hours worked through the accounting period being reported, the planned cost is obtained from the time-phased baseline plan which includes the original contract value plus authorized changes, consistent with the amount reported on the 533M report. | 14 |
| Cost/Hours |
8a
| PERIOD 1 ESTIMATE | Enter current estimate for the next reporting period for performing authorized work included in the most recently executed contract modification, plus additional authorized work (directions to proceed) for which execution of modifications is pending, consistent with the amount reported on the 533M report. The estimates will be for planning purposes only and not be binding on the contractor or NASA. | 14 |
| Cost/Hours |
8b
| PERIOD 2 ESTIMATE | Enter current estimate for the reporting period, following the reporting period in 8a, for performing authorized work included in the most recently executed contract modification, plus additional authorized work (directions to proceed) for which execution of modifications is pending, consistent with the amount reported on the 533M report. The estimates will be for planning purposes only and not be binding on the contractor or NASA. | 14 |
| Cost/Hours | ||
| BALANCE OF FISCAL YEAR ESTIMATE | Estimate for remaining months after 8b PERIOD 2 ESTIMATE thru and including September of current fiscal year. Examples: If Period 1 estimate is for January, Period 2 would be February, BALANCE OF FISCAL YEAR ESTIMATE would be for months March thru and including September. Different Example: If Period 1 is for August, Period 2 would be for September, BALANCE OF FISCAL YEAR ESTIMATE would be zero. | 14 |
| Cost/Hours |
8c
| BALANCE OF CONTRACT ESTIMATE | Enter cost/hour data for the balance of the contract not including 8a and 8b and BALANCE OF FISCAL YEAR ESTIMATE, consistent with the amount reported on the 533M report. Example: We are reporting June 2015 for a contract ending September 2017. PERIOD 1 ESTIMATE is for July 2015, PERIOD 2 ESTIMATE is for August 2015, BALANCE OF FISCAL YEAR ESTIMATE is for September 2015, BALANCE OF CONTRACT ESTIMATE is for October 2015 through September 2017. | 14 |
| Cost/Hours |
9a
| FINAL CONTRACTOR ESTIMATE | Enter the total estimated cost/hours for completion of the contracted effort (this will equal the sum of columns 7c, 8a, 8b, BALANCE OF FISCAL YEAR ESTIMATE, and 8c), consistent with the amount reported on the 533M report. | 14 |
| Cost/Hours |
9b
| CONTRACT VALUE | Enter the distribution of the Contract Value to the reporting categories, consistent with the amount reported on the 533M report. | 14 |
| Cost |
UNFILLED ORDERS OUTSTANDING As directed by the NASA Contracting Officer, enter the total of unfilled orders outstanding, consistent with the amount reported on the 533M report. This should be blank unless directed by the Contracting Officer. 14
Reporting Categories
| Provide these values | Provide these values | |||||
| Numerical Indicator (NI) | Category | Category | ||||
| (Abbrev) | Reporting Category | Reporting Category | ||||
| (Abbrev) | Notes | |||||
| 1 | Direct Labor Hours | DLH | Prime | PRM | ||
| 2 | Major Subcontractor Labor Hours | SLH | Sub1 [Name] | Sub1 Boeing | First four characters of Reporting Category should always be Sub1 (No Space) | |
| 3 | Major Subcontractor Labor Hours | SLH | Sub2 [Name] | Sub2 Honeywell | First four characters of Reporting Category should always be Sub2 (No Space) | |
| 4 | Major Subcontractor Labor Hours | SLH | Sub3 [Name] | Sub3 Rolls Royce | First four characters of Reporting Category should always be Sub3 (No Space). Not limited to 3, should be consistent with what is reported on 533 | |
| 5 | Direct Labor Cost | DLC | Prime | PRM | ||
| 6 | Major Sub Labor Cost | SLC | Sub1 [Name] | Sub1 Boeing | Report fully burdened sub-contract labor | |
| 7 | Major Sub Labor Cost | SLC | Sub2 [Name] | Sub2 Honeywell | Report fully burdened sub-contract labor | |
| 8 | Major Sub Labor Cost | SLC | Sub3 [Name] | Sub3 Rolls Royce | Report fully burdened sub-contract labor | |
| 9 | Prime Indirect Labor Cost | ILC | Fringe | FRG | ||
| 10 | Prime Indirect Labor Cost | ILC | Overhead | OH | ||
| 12 | Prime Indirect Labor Cost | ILC | Other Indirect Labor | OTH | ||
| 13 | Other Direct Cost | ODC | Small Subcontractors | SUB | ||
| 14 | Other Direct Cost | ODC | Consultants | CON | ||
| 15 | Other Direct Cost | ODC | Facility and Lease Costs | FAC | ||
| 16 | Other Direct Cost | ODC | Training | TRN | ||
| 17 | Other Direct Cost | ODC | Travel | TRV | ||
| 18 | Other Direct Cost | ODC | Equipment | EQP | ||
| 19 | Other Direct Cost | ODC | Materials and Supplies | MS | ||
| 20 | Other Direct Cost | ODC | Licenses | LIC | ||
| 21 | Other Direct Cost | ODC | Other | OTH | ||
| 22 | Indirect Cost | IC | Other Indirect | OTH | ||
| 23 | Indirect Cost | IC | Material Overhead/Material G&A | MOG | Report Material Handling, and/or Material Overhead, and/or Material G&A | |
| 24 | Indirect Cost | IC | Labor G & A | GA | ||
| 25 | Indirect Cost | IC | COM | COM | Facilities Capital Cost of Money | |
| 26 | Fixed Price | FP | Fixed Price | FP | Report each line at the CLIN/Task order level | |
| 27 | Fee | FEE | Fee | FEE | ||
| TOTAL | TOT | TOTAL | TOT |
Contract Type
| Contract Type | Provide these values |
| Cost Plus Award Fee | AF |
| Cost Sharing | CS |
| Cost Plus Fixed Fee | FF |
| Fixed Price Plus Incentive Fee | FI |
| Firm Fixed Price | FP |
| Contract Hybrid | HY |
| Indefinite Delivery | ID |
| Cost Plus Incentive Fee | IF |
| Labor Hours | LH |
| Cost Type - No Fee | NF |
| Small Business Innovative Research - Phase II | SC |
| Time and Materials | TM |
Header
| RECORD TYPE | REPORTING YEAR [CY] | REPORTING MONTH | REPORT VERSION | OUTLINE AGREEMENT | CLIN | TASK AWARD | CAPITAL ASSET | CONTRACT TYPE | SCOPE OF WORK | LATEST DEFINITIZED MOD # | REPORT FOR PERIOD ENDING | NUMBER OF WORKING DAYS | CONTRACT VALUE COST | CONTRACT VALUE FEE | FUND LIMITATION | INVOICE AMTS BILLED | TOTAL PAYMENTS |
| H | 2020 | 10 | 1 | 80GRC021EX001 | Total | HY | 533 Example Contract - Total | 1 | 10/31/20 | 20 | 102,357,458.60 | 106,334.00 | 102,463,791.60 | 13,330,952.12 | 10,293,345.56 | ||
| H | 2020 | 10 | 1 | 80GRC021EX001 | 1 | FP | Example Contract - CLIN 1 | 1 | 10/31/20 | 20 | 68,680,000.00 | - 0 | 68,680,000.00 | 2,549,471.82 | 1,274,735.91 | ||
| H | 2020 | 10 | 1 | 80GRC021EX001 | 2 | FF | Example Contract - CLIN 2 | 1 | 10/31/20 | 20 | 8,119,602.60 | 62,488.00 | 8,182,090.60 | 5,145,099.00 | 4,553,869.00 | ||
| H | 2020 | 10 | 1 | 80GRC021EX001 | 3 | FF | Example Contract - CLIN 3 | 1 | 10/31/20 | 20 | 5,812,355.00 | 43,846.00 | 5,856,201.00 | 4,220,224.00 | 3,756,662.00 | ||
| H | 2020 | 10 | 1 | 80GRC021EX001 | 4 | FP | Example Contract - CLIN 4 | 1 | 10/31/20 | 20 | 16,320,000.00 | - 0 | 16,320,000.00 | 576,013.96 | 288,006.98 | ||
| H | 2020 | 10 | 1 | 80GRC021EX001 | 5 | FP | Example Contract - CLIN 5 | 1 | 10/31/20 | 20 | 570,000.00 | - 0 | 570,000.00 | 173,145.90 | 86,572.95 | ||
| H | 2020 | 10 | 1 | 80GRC021EX001 | 6 | 80GRC020F0005 | FP | Example Contract - CLIN 6 Task Order 1 | 1 | 10/31/20 | 20 | 1,010,000.00 | 1,010,000.00 | 313,319.30 | 156,659.65 | ||
| H | 2020 | 10 | 1 | 80GRC021EX001 | 6 | 80GRC020F0007 | FP | Example Contract - CLIN 6 Task Order 2 | 1 | 10/31/20 | 20 | 1,117,500.00 | 1,117,500.00 | 164,728.16 | 82,364.08 | ||
| H | 2020 | 10 | 1 | 80GRC021EX001 | 7 | FP | Example Contract - CLIN 7 | 1 | 10/31/20 | 20 | 728,000.00 | - 0 | 728,000.00 | 188,949.98 | 94,474.99 |
533 Data RECORD TYPE REPORTING YEAR REPORTING MONTH REPORT VERSION OUTLINE AGREEMENT CLIN TASK AWARD CAPITAL ASSET CATEGORY (ABV) REPORTING CATEGORY (ABV) Cost/Hours 7a CURRENT MONTH ACTUAL Cost/Hours 7b CURRENT MONTH PLANNED Cost/Hours 7c CUMULATIVE ACTUAL Cost/Hours 7d CUMULATIVE PLANNED Cost/Hours 8a PERIOD 1 ESTIMATE Cost/Hours 8b PERIOD 2 ESTIMATE Cost/Hours BALANCE OF FISCAL YEAR ESTIMATE Cost/Hours 8c BALANCE OF CONTRACT ESTIMATE Cost/Hours 9a FINAL CONTRACTOR ESTIMATE Cost/Hours 9b CONTRACT VALUE Cost
UNFILLED ORDERS OUTSTANDING
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | DLH | PRM | 5,517.10 | 5,027.00 | 50,361.20 | 45,464.00 | 5,144.69 | 5,377.67 | - 0 | 23,274.46 | 84,158.02 | 73,446.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | SLH | Sub1 | 8,348.00 | 7,719.00 | 75,550.90 | 69,596.00 | 7,697.31 | 7,980.33 | - 0 | 32,490.37 | 123,718.91 | 112,556.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | SLH | Sub2 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | SLH | Sub3 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | DLC | PRM | 209,405.27 | 220,756.00 | 2,005,947.30 | 1,985,433.00 | 212,571.65 | 258,538.56 | - 0 | 1,041,322.10 | 3,518,379.61 | 3,213,986.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | SLC | Sub1 | 636,785.49 | 512,116.00 | 5,693,511.67 | 4,626,324.00 | 600,829.35 | 598,776.44 | - 0 | 2,525,013.90 | 9,418,131.36 | 7,476,360.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | SLC | Sub2 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | SLC | Sub3 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ILC | FRG | 88,552.64 | 72,198.00 | 670,130.74 | 649,541.00 | 70,860.00 | 79,215.00 | - 0 | 319,998.00 | 1,140,203.74 | 1,051,339.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ILC | OH | 11,573.17 | 20,447.00 | 108,921.89 | 183,962.00 | 14,612.00 | 16,335.00 | - 0 | 65,988.00 | 205,856.89 | 297,759.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ILC | OTH | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ODC | SUB | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ODC | CON | 19,500.00 | - 0 | 165,247.50 | - 0 | 6,500.00 | 6,500.00 | - 0 | 65,000.00 | 243,247.50 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ODC | FAC | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ODC | TRN | 15,280.00 | - 0 | 57,568.09 | - 0 | - 0 | - 0 | - 0 | 5,191.00 | 62,759.09 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ODC | TRV | 7,747.61 | - 0 | 52,125.50 | - 0 | 1,927.00 | - 0 | - 0 | 64,987.00 | 119,039.50 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ODC | EQP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ODC | MS | 34,407.46 | 47,963.00 | 671,254.96 | 429,230.00 | 49,580.00 | 1,048,405.00 | - 0 | 1,389,610.00 | 3,158,849.96 | 696,150.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ODC | LIC | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | ODC | OTH | 1,567.44 | - 0 | 36,962.12 | - 0 | - 0 | - 0 | - 0 | - 0 | 36,962.12 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | IC | OTH | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | IC | MOG | 5,073.09 | 4,400.00 | 77,500.51 | 39,373.00 | 4,344.73 | 79,012.38 | - 0 | 114,206.62 | 275,064.25 | 63,857.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | IC | GA | 62,536.60 | 77,653.00 | 671,711.46 | 700,357.00 | 68,941.00 | 73,050.00 | - 0 | 303,046.00 | 1,116,748.46 | 1,132,507.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | IC | COM | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | FP | FP | 1,982,814.56 | 2,058,908.41 | 3,965,629.12 | 4,117,816.82 | 1,924,364.14 | 1,897,138.68 | - 0 | 80,302,408.24 | 88,089,540.19 | 88,425,500.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | FEE | FEE | 7,053.48 | 7,302.00 | 64,012.90 | 65,696.00 | 6,914.00 | 7,728.00 | - 0 | 31,222.00 | 109,876.90 | 106,334.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | Total | TOT | TOT | 3,082,296.81 | 3,021,743.41 | 14,245,281.64 | 12,797,732.82 | 2,961,443.87 | 4,064,699.07 | - 0 | 86,227,992.87 | 107,499,417.45 | 102,463,792.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 1 | FP | FP | 1,274,735.91 | 1,244,485.86 | 2,549,471.82 | 2,488,971.72 | 1,159,655.28 | 1,161,058.60 | - 0 | 63,560,452.80 | 68,430,638.50 | 68,680,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 1 | TOT | TOT | 1,274,735.91 | 1,244,485.86 | 2,549,471.82 | 2,488,971.72 | 1,159,655.28 | 1,161,058.60 | - 0 | 63,560,452.80 | 68,430,638.50 | 68,680,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | DLH | PRM | 2,766.30 | 3,036.00 | 24,919.50 | 27,458.00 | 2,495.40 | 2,448.87 | - 0 | 11,382.49 | 41,246.26 | 44,359.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | SLH | Sub1 | 4,545.00 | 4,576.00 | 42,557.00 | 41,174.00 | 4,261.60 | 4,182.13 | - 0 | 17,068.34 | 68,069.07 | 66,641.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | SLH | Sub2 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | SLH | Sub3 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | DLC | PRM | 109,773.06 | 129,528.00 | 1,033,177.46 | 1,165,087.00 | 106,130.15 | 130,426.56 | - 0 | 557,371.59 | 1,827,105.76 | 1,885,936.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | SLC | Sub1 | 359,038.07 | 308,827.00 | 3,308,079.34 | 2,797,412.00 | 339,812.85 | 313,158.44 | - 0 | 1,338,267.41 | 5,299,318.04 | 4,516,100.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | SLC | Sub2 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | SLC | Sub3 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ILC | FRG | 46,446.31 | 42,428.00 | 346,226.41 | 381,708.00 | 34,808.00 | 34,518.00 | - 0 | 142,768.00 | 558,320.41 | 617,830.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ILC | OH | 6,070.19 | 12,016.00 | 56,345.65 | 108,108.00 | 7,178.00 | 7,118.00 | - 0 | 29,441.00 | 100,082.65 | 174,981.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ILC | OTH | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ODC | SUB | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ODC | CON | 19,500.00 | - 0 | 165,247.50 | - 0 | 6,500.00 | 6,500.00 | - 0 | 65,000.00 | 243,247.50 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ODC | FAC | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ODC | TRN | - 0 | - 0 | 11,714.42 | - 0 | - 0 | - 0 | - 0 | 5,032.00 | 16,746.42 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ODC | TRV | 5,843.32 | - 0 | 30,665.17 | - 0 | - 0 | - 0 | - 0 | 16,204.00 | 46,869.17 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ODC | EQP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ODC | MS | 26,174.35 | 15,653.00 | 237,429.63 | 140,040.00 | 29,381.00 | 1,016,600.00 | - 0 | 839,501.00 | 2,122,911.63 | 227,150.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ODC | LIC | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | ODC | OTH | - 0 | - 0 | 21,818.62 | - 0 | - 0 | - 0 | - 0 | - 0 | 21,818.62 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | IC | OTH | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | IC | MOG | 3,328.04 | 1,436.00 | 36,515.67 | 12,845.00 | 2,687.49 | 76,630.19 | - 0 | 69,337.70 | 185,171.05 | 20,836.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | IC | GA | 34,418.40 | 46,356.00 | 375,797.03 | 418,790.00 | 37,396.00 | 37,177.00 | - 0 | 158,462.00 | 608,832.03 | 676,770.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | IC | COM | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | FEE | FEE | 3,699.57 | 4,291.00 | 33,054.97 | 38,608.00 | 3,397.00 | 3,367.00 | - 0 | 13,930.00 | 53,748.97 | 62,488.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 2 | TOT | TOT | 614,291.31 | 560,535.00 | 5,656,071.87 | 5,062,598.00 | 567,290.49 | 1,625,495.19 | - 0 | 3,235,314.70 | 11,084,172.25 | 8,182,090.60 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | DLH | PRM | 2,750.80 | 1,991.00 | 25,441.70 | 18,006.00 | 2,649.29 | 2,928.80 | - 0 | 11,891.97 | 42,911.76 | 29,087.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | SLH | Sub1 | 3,803.00 | 3,143.00 | 32,993.90 | 28,422.00 | 3,435.71 | 3,798.20 | - 0 | 15,422.03 | 55,649.84 | 45,915.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | SLH | Sub2 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | SLH | Sub3 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | DLC | PRM | 99,632.21 | 91,228.00 | 972,769.84 | 820,346.00 | 106,441.50 | 128,112.00 | - 0 | 483,950.51 | 1,691,273.85 | 1,328,050.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | SLC | Sub1 | 277,747.42 | 203,289.00 | 2,385,432.33 | 1,828,912.00 | 261,016.50 | 285,618.00 | - 0 | 1,186,746.49 | 4,118,813.32 | 2,960,260.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | SLC | Sub2 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | SLC | Sub3 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ILC | FRG | 42,106.33 | 29,770.00 | 323,904.33 | 267,833.00 | 36,052.00 | 44,697.00 | - 0 | 177,230.00 | 581,883.33 | 433,509.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ILC | OH | 5,502.98 | 8,431.00 | 52,576.24 | 75,854.00 | 7,434.00 | 9,217.00 | - 0 | 36,547.00 | 105,774.24 | 122,778.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ILC | OTH | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ODC | SUB | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ODC | CON | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ODC | FAC | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ODC | TRN | 15,280.00 | - 0 | 45,853.67 | - 0 | - 0 | - 0 | - 0 | 159.00 | 46,012.67 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ODC | TRV | 1,904.29 | - 0 | 21,460.33 | - 0 | 1,927.00 | - 0 | - 0 | 48,783.00 | 72,170.33 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ODC | EQP | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ODC | MS | 8,233.11 | 32,310.00 | 433,825.33 | 289,190.00 | 20,199.00 | 31,805.00 | - 0 | 550,109.00 | 1,035,938.33 | 469,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ODC | LIC | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | ODC | OTH | 1,567.44 | - 0 | 15,143.50 | - 0 | - 0 | - 0 | - 0 | - 0 | 15,143.50 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | IC | OTH | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | IC | MOG | 1,745.05 | 2,964.00 | 40,984.84 | 26,528.00 | 1,657.24 | 2,382.19 | - 0 | 44,868.92 | 89,893.20 | 43,021.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | IC | GA | 28,118.20 | 31,297.00 | 295,914.43 | 281,567.00 | 31,545.00 | 35,873.00 | - 0 | 144,584.00 | 507,916.43 | 455,737.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | IC | COM | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | FEE | FEE | 3,353.91 | 3,011.00 | 30,957.93 | 27,088.00 | 3,517.00 | 4,361.00 | - 0 | 17,292.00 | 56,127.93 | 43,846.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 3 | TOT | TOT | 485,190.94 | 402,300.00 | 4,618,822.77 | 3,617,318.00 | 469,789.24 | 542,065.19 | - 0 | 2,690,269.92 | 8,320,947.13 | 5,856,201.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 4 | FP | FP | 288,006.98 | 426,502.70 | 576,013.96 | 853,005.40 | 249,062.23 | 363,853.95 | - 0 | 15,074,687.47 | 16,263,617.61 | 16,320,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 4 | TOT | TOT | 288,006.98 | 426,502.70 | 576,013.96 | 853,005.40 | 249,062.23 | 363,853.95 | - 0 | 15,074,687.47 | 16,263,617.61 | 16,320,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 5 | FP | FP | 86,572.95 | 79,677.39 | 173,145.90 | 159,354.78 | 80,664.36 | 60,443.45 | - 0 | 254,446.61 | 568,700.32 | 570,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 5 | TOT | TOT | 86,572.95 | 79,677.39 | 173,145.90 | 159,354.78 | 80,664.36 | 60,443.45 | - 0 | 254,446.61 | 568,700.32 | 570,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 6 | 80GRC020F0005 | FP | FP | 156,659.65 | 156,238.36 | 313,319.30 | 312,476.72 | 152,139.27 | 137,638.27 | 402,282.37 | 1,005,379.21 | 1,010,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 6 | 80GRC020F0005 | TOT | TOT | 156,659.65 | 156,238.36 | 313,319.30 | 312,476.72 | 152,139.27 | 137,638.27 | 402,282.37 | 1,005,379.21 | 1,010,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 6 | 80GRC020F0007 | FP | FP | 82,364.08 | 114,230.91 | 164,728.16 | 228,461.82 | 94,360.00 | 79,854.00 | - 0 | 760,539.00 | 1,099,481.16 | 1,117,500.00 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 6 | 80GRC020F0007 | TOT | TOT | 82,364.08 | 114,230.91 | 164,728.16 | 228,461.82 | 94,360.00 | 79,854.00 | - 0 | 760,539.00 | 1,099,481.16 | 1,117,500.00 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 7 | FP | FP | 94,474.99 | 37,773.19 | 188,949.98 | 75,546.38 | 188,483.00 | 94,290.41 | - 0 | 250,000.00 | 721,723.39 | 728,000.00 | - 0 | |
| D | 2020 | 10 | 1 | 80GRC021EX001 | 7 | TOT | TOT | 94,474.99 | 37,773.19 | 188,949.98 | 75,546.38 | 188,483.00 | 94,290.41 | - 0 | 250,000.00 | 721,723.39 | 728,000.00 | - 0 |
Example 533 Summary
| 2. REPORT FOR MONTH ENDING AND NUMBER OF OPERATING DAYS | ||||||||||||
| MONTHLY CONTRACTOR FINANCIAL MANAGEMENT REPORT | October 31, 2020 | 20 | Days | |||||||||
| TO: | FROM: | 3. CONTRACT VALUE | ||||||||||
| NASA Glenn Research Center | a. COST | b. FEE | ||||||||||
| Mail Stop 60-1 | $ 102,357,458 | $ 106,334 | ||||||||||
| Cleveland, OH 44135 | ||||||||||||
| 1. DESC. | a. TYPE | b.CONTRACT NO. AND LATEST DEFINITIZED AMEND. NO. | 4. FUND LIMITATION | $14,345,195 | ||||||||
| OF | Cost Plus Fixed Fee | 80GRC021EX001 | 5. BILLING | |||||||||
| CONTRACT | c. SCOPE | d. AUTH. CONTR. REP. | a. INVOICE AMOUNTS BILLED: | b. TOTAL PAYMENTS RECEIVED: | ||||||||
| 533 Example Contract - Total | $13,330,952 | $10,293,346 | ||||||||||
| 7. COST INCURRED / HOURS WORKED | 8.EST.COST/HRS TO COMPLETE | 9. ESTIMATED FINAL | 10. UNFILLED ORDERS OUTSTANDING | |||||||||
| DURING MONTH | CUM. TO DATE | DETAIL | BALANCE | COST / HOURS | ||||||||
| 6. REPORTING | OF | CONTRACTOR | CONTRACT | |||||||||
| CATEGORY | ACTUAL | PLANNED | ACTUAL | PLANNED | September | October | CONTRACT | ESTIMATE | VALUE | |||
| a. | b. | c. | d. | a. | b. | c. | a. | b. | ||||
| HOURS | ||||||||||||
| Prime Labor Hours | 5,517.10 | 5,027.00 | 50,361.20 | 45,464.00 | 5,144.69 | 5,377.67 | 23,274.46 | 84,158.02 | 73,446.00 | - 0 | ||
| Subcontractor Labor Hours | 8,348.00 | 7,719.00 | 75,550.90 | 69,596.00 | 7,697.31 | 7,980.33 | 32,490.37 | 123,718.91 | 112,556.00 | - 0 | ||
| TOTAL LABOR HOURS | 13,865.10 | 12,746.00 | 125,912.10 | 115,060.00 | 12,842.00 | 13,358.00 | 55,764.83 | 207,876.93 | 186,002.00 | - 0 |
| LABOR | ||||||||||
| Prime Labor Cost | 209,405.27 | 220,756.00 | 2,005,947.30 | 1,985,433.00 | 212,571.65 | 258,538.56 | 1,041,322.10 | 3,518,379.61 | 3,213,986.00 | - 0 |
| Subcontractor Labor Costs | 636,785.49 | 512,116.00 | 5,693,511.67 | 4,626,324.00 | 600,829.35 | 598,776.44 | 2,525,013.90 | 9,418,131.36 | 7,476,360.00 | - 0 |
| TOTAL LABOR COSTS | 846,190.76 | 732,872.00 | 7,699,458.97 | 6,611,757.00 | 813,401.00 | 857,315.00 | 3,566,336.00 | 12,936,510.97 | 10,690,346.00 | - 0 |
| PRIME LABOR Indirect Cost | ||||||||||
| Fringe | 88,552.64 | 72,198.00 | 670,130.74 | 649,541.00 | 70,860.00 | 79,215.00 | 319,998.00 | 1,140,203.74 | 1,051,339.00 | - 0 |
| Overhead | 11,573.17 | 20,447.00 | 108,921.89 | 183,962.00 | 14,612.00 | 16,335.00 | 65,988.00 | 205,856.89 | 297,759.00 | - 0 |
| Total Indirect Cost | 100,125.81 | 92,645.00 | 779,052.63 | 833,503.00 | 85,472.00 | 95,550.00 | 385,986.00 | 1,346,060.63 | 1,349,098.00 | - 0 |
| Labor G&A | ||||||||||
| General and Administrative | 62,536.60 | 77,653.00 | 671,711.46 | 700,357.00 | 68,941.00 | 73,050.00 | 303,046.00 | 1,116,748.46 | 1,132,507.00 | - 0 |
| Total G&A Cost | 62,536.60 | 77,653.00 | 671,711.46 | 700,357.00 | 68,941.00 | 73,050.00 | 303,046.00 | 1,116,748.46 | 1,132,507.00 | - 0 |
| ODC's | ||||||||||
| Materials | 34,407.46 | 47,963.00 | 671,254.96 | 429,230.00 | 49,580.00 | 1,048,405.00 | 1,389,610.00 | 3,158,849.96 | 696,150.00 | - 0 |
| Consultant | 19,500.00 | - 0 | 165,247.50 | - 0 | 6,500.00 | 6,500.00 | 65,000.00 | 243,247.50 | - 0 | - 0 |
| Other | 1,567.44 | - 0 | 36,962.12 | - 0 | - 0 | - 0 | - 0 | 36,962.12 | - 0 | - 0 |
| Training | 15,280.00 | - 0 | 57,568.09 | - 0 | - 0 | - 0 | 5,191.00 | 62,759.09 | - 0 | - 0 |
| Travel | 7,747.61 | - 0 | 52,125.50 | - 0 | 1,927.00 | - 0 | 64,987.00 | 119,039.50 | - 0 | - 0 |
| SUBTOTAL ODC's | 78,502.51 | 47,963.00 | 983,158.17 | 429,230.00 | 58,007.00 | 1,054,905.00 | 1,524,788.00 | 3,620,858.17 | 696,150.00 | - 0 |
| - 0 | ||||||||||
| Material G & A | 5,073.09 | 4,400.00 | 77,500.51 | 39,373.00 | 4,344.73 | 79,012.38 | 114,206.62 | 275,064.25 | 63,857.00 | - 0 |
| TOTAL ODC's | 83,575.60 | 52,363.00 | 1,060,658.68 | 468,603.00 | 62,351.73 | 1,133,917.38 | 1,638,994.62 | 3,895,922.42 | 760,007.00 | - 0 |
| - 0 | ||||||||||
| SUBTOTAL COSTS | 1,092,428.77 | 955,533.00 | 10,215,639.62 | 8,614,220.00 | 1,030,165.73 | 2,159,832.38 | 5,894,362.62 | 19,300,000.36 | 13,931,958.00 | - 0 |
COM Dollars - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Fixed Price 1,982,814.56 2,058,908.41 3,965,629.12 4,117,816.82 1,924,364.14 1,897,138.68 80,302,408.24 88,089,540.19 88,425,500.00
| FEE | ||||||||||
| Fee | 7,053.48 | 7,302.00 | 64,012.90 | 65,696.00 | 6,914.00 | 7,728.00 | 31,222.00 | 109,876.90 | 106,334.00 | - 0 |
TOTAL COST AND FEE 3,082,296.81 3,021,743.41 14,245,281.64 12,797,732.82 2,961,443.87 4,064,699.07 86,227,992.87 107,499,417.45 102,463,792.00 - 0
Example 533 - Fixed Price
| Fixed Price Reporting | |||||||
| 6. REPORTING CATEGORY | 7. COST INCURRED/HOURS WORKED | 8. ESTIMATED COST/HOURS TO COMPLETE | 9. ESTIMATED FINAL COST/HOURS | 10. UNFILLED ORDERS OUTSTANDING | |||
| DURING MONTH | CUM. TO DATE | DETAIL | BALANCE OF FISCAL YEAR ESTIMATE | ||||
| c. | BALANCE OF |
CONTRACT
d.
| CLIN | TASK | Task Line Item Number | ACTUAL | |
| a. | PLANNED | |||
| b. | ACTUAL | |||
| c. | PLANNED | |||
| d. | MONTH |
(September)
a. MONTH (October)
b. CONTRACTOR
ESTIMATE
a. CONTRACT
VALUE
B.
| CLIN 1 | 1,274,736 | 1,244,486 | 2,549,472 | 2,488,972 | 1,159,655 | 1,161,059 | - 0 | 63,560,453 | 68,430,639 | 68,680,000 | ||
| CLIN 4 | 288,007 | 426,503 | 576,014 | 853,005 | 249,062 | 363,854 | - 0 | 15,074,687 | 16,263,618 | 16,320,000 | ||
| CLIN 5 | 86,573 | 79,677 | 173,146 | 159,355 | 80,664 | 60,443 | 254,447 | 568,700 | 570,000 | |||
| 6 | 80GRC020F0005 | 156,660 | 156,238 | 313,319 | 312,477 | 152,139 | 137,638 | 402,282 | 1,005,379 | 1,010,000 | ||
| 6 | 80GRC020F0007 | 1 | 43,638 | 59,650 | 87,276 | 119,300 | 31,580 | 37,587 | 372,687 | 529,130 | 540,000 | |
| 6 | 80GRC020F0007 | 2 | 38,726 | 54,581 | 77,452 | 109,162 | 62,780 | 42,267 | 387,852 | 570,351 | 577,500 | |
| 7 | 80GRC020F0020 | 94,475 | 37,773 | 188,950 | 75,546 | 188,483 | 94,290 | - 0 | 250,000.00 | 721,723 | 728,000 | |
| Total | 1,982,815 | 2,058,908 | 3,965,629 | 4,117,817 | 1,924,364 | 1,897,139 | - 0 | 80,302,408 | 88,089,540 | 88,425,500 |
82,364 114,231 164,728 228,462 94,360 79,854 - 0 760,539 1,099,481 1,117,500
Example 533 - CLIN 2
| 2. REPORT FOR MONTH ENDING AND NUMBER OF OPERATING DAYS | ||||||||||||
| MONTHLY CONTRACTOR FINANCIAL MANAGEMENT REPORT | October 31, 2020 | 20 | Days | |||||||||
| TO: | FROM: | 3. CONTRACT VALUE | ||||||||||
| NASA Glenn Research Center | a. COST | b. FEE | ||||||||||
| Mail Stop 60-1 | $ 8,302,753 | $ 62,488 | ||||||||||
| Cleveland, OH 44135 | ||||||||||||
| 1. DESC. | a. TYPE | b.CONTRACT NO. AND LATEST DEFINITIZED AMEND. NO. | 4. FUND LIMITATION | $ 8,365,241 | ||||||||
| OF | Cost Plus Fixed Fee | CLIN 2 | 5. BILLING | |||||||||
| CONTRACT | c. SCOPE | d. AUTH. CONTR. REP. | a. INVOICE AMOUNTS BILLED: | b. TOTAL PAYMENTS RECEIVED: | ||||||||
| Example Contract - CLIN 2 | $5,145,099 | $4,553,869 | ||||||||||
| 7. COST INCURRED / HOURS WORKED | 8.EST.COST/HRS TO COMPLETE | 9. ESTIMATED FINAL | 10. UNFILLED ORDERS OUTSTANDING | |||||||||
| DURING MONTH | CUM. TO DATE | DETAIL | BALANCE | COST / HOURS | ||||||||
| 6. REPORTING | OF | CONTRACTOR | CONTRACT | |||||||||
| CATEGORY | ACTUAL | PLANNED | ACTUAL | PLANNED | September | October | CONTRACT | ESTIMATE | VALUE | |||
| a. | b. | c. | d. | a. | b. | c. | a. | b. | ||||
| HOURS | ||||||||||||
| Prime Labor Hours | 2,766.30 | 3,036.00 | 24,919.50 | 27,458.00 | 2,495.40 | 2,448.87 | 11,382.49 | 41,246.26 | 44,359.00 | |||
| Subcontractor Labor Hours | 4,545.00 | 4,576.00 | 42,557.00 | 41,174.00 | 4,261.60 | 4,182.13 | 17,068.34 | 68,069.07 | 66,641.00 | |||
| TOTAL LABOR HOURS | 7,311.30 | 7,612.00 | 67,476.50 | 68,632.00 | 6,757.00 | 6,631.00 | 28,450.83 | 109,315.33 | 111,000.00 |
| LABOR | |||||||||
| Prime Labor Cost | 109,773.06 | 129,528.00 | 1,033,177.46 | 1,165,087.00 | 106,130.15 | 130,426.56 | 557,371.59 | 1,827,105.76 | 1,885,936.00 |
| Subcontractor Labor Costs | 359,038.07 | 308,827.00 | 3,308,079.34 | 2,797,412.00 | 339,812.85 | 313,158.44 | 1,338,267.41 | 5,299,318.04 | 4,516,100.00 |
| TOTAL LABOR COSTS | 468,811.13 | 438,355.00 | 4,341,256.80 | 3,962,499.00 | 445,943.00 | 443,585.00 | 1,895,639.00 | 7,126,423.80 | 6,402,036.00 |
| PRIME LABOR Indirect Cost | |||||||||
| Fringe | 46,446.31 | 42,428.00 | 346,226.41 | 381,708.00 | 34,808.00 | 34,518.00 | 142,768.00 | 558,320.41 | 617,830.00 |
| Overhead | 6,070.19 | 12,016.00 | 56,345.65 | 108,108.00 | 7,178.00 | 7,118.00 | 29,441.00 | 100,082.65 | 174,981.00 |
| Total Indirect Cost | 52,516.50 | 54,444.00 | 402,572.06 | 489,816.00 | 41,986.00 | 41,636.00 | 172,209.00 | 658,403.06 | 792,811.00 |
| Labor G&A | |||||||||
| General and Administrative | 34,418.40 | 46,356.00 | 375,797.03 | 418,790.00 | 37,396.00 | 37,177.00 | 158,462.00 | 608,832.03 | 676,770.00 |
| Total G&A Cost | 34,418.40 | 46,356.00 | 375,797.03 | 418,790.00 | 37,396.00 | 37,177.00 | 158,462.00 | 608,832.03 | 676,770.00 |
| ODC's | |||||||||
| Materials | 26,174.35 | 15,653.00 | 237,429.63 | 140,040.00 | 29,381.00 | 1,016,600.00 | 839,501.00 | 2,122,911.63 | 227,150.00 |
| Consultant | 19,500.00 | - 0 | 165,247.50 | - 0 | 6,500.00 | 6,500.00 | 65,000.00 | 243,247.50 | - 0 |
| Other | - 0 | - 0 | 21,818.62 | - 0 | - 0 | - 0 | - 0 | 21,818.62 | - 0 |
| Training | - 0 | - 0 | 11,714.42 | - 0 | - 0 | - 0 | 5,032.00 | 16,746.42 | - 0 |
| Travel | 5,843.32 | - 0 | 30,665.17 | - 0 | - 0 | - 0 | 16,204.00 | 46,869.17 | - 0 |
| SUBTOTAL ODC's | 51,517.67 | 15,653.00 | 466,875.34 | 140,040.00 | 35,881.00 | 1,023,100.00 | 925,737.00 | 2,451,593.34 | 227,150.00 |
| Material G & A | 3,328.04 | 1,436.00 | 36,515.67 | 12,845.00 | 2,687.49 | 76,630.19 | 69,337.70 | 185,171.05 | 20,836.00 |
| TOTAL ODC's | 54,845.71 | 17,089.00 | 503,391.01 | 152,885.00 | 38,568.49 | 1,099,730.19 | 995,074.70 | 2,636,764.39 | 247,985.60 |
SUBTOTAL COSTS 610,591.74 556,244.00 5,623,016.90 5,023,990.00 563,893.49 1,622,128.19 3,221,384.70 11,030,423.28 8,119,602.60
COM Dollars
| FEE | |||||||||
| Fee | 3,699.57 | 4,291.00 | 33,054.97 | 38,608.00 | 3,397.00 | 3,367.00 | 13,930.00 | 53,748.97 | 62,488.00 |
TOTAL COST AND FEE 614,291.31 560,535.00 5,656,071.87 5,062,598.00 567,290.49 1,625,495.19 3,235,314.70 11,084,172.25 8,182,090.60
Example 533 - CLIN 3
| 2. REPORT FOR MONTH ENDING AND NUMBER OF OPERATING DAYS | ||||||||||||
| MONTHLY CONTRACTOR FINANCIAL MANAGEMENT REPORT | October 31, 2020 | 20 | Days | |||||||||
| TO: | FROM: | 3. CONTRACT VALUE | ||||||||||
| NASA Glenn Research Center | a. COST | b. FEE | ||||||||||
| Mail Stop 60-1 | $ 5,936,108 | $ 43,846 | ||||||||||
| Cleveland, OH 44135 | ||||||||||||
| 1. DESC. | a. TYPE | b.CONTRACT NO. AND LATEST DEFINITIZED AMEND. NO. | 4. FUND LIMITATION | $ 5,979,954 | ||||||||
| OF | Cost Plus Fixed Fee | CLIN 3 | 5. BILLING | |||||||||
| CONTRACT | c. SCOPE | d. AUTH. CONTR. REP. | a. INVOICE AMOUNTS BILLED: | b. TOTAL PAYMENTS RECEIVED: | ||||||||
| Example Contract - CLIN 1 | $4,220,224 | $3,756,662 | ||||||||||
| 7. COST INCURRED / HOURS WORKED | 8.EST.COST/HRS TO COMPLETE | 9. ESTIMATED FINAL | 10. UNFILLED ORDERS OUTSTANDING | |||||||||
| DURING MONTH | CUM. TO DATE | DETAIL | BALANCE | COST / HOURS | ||||||||
| 6. REPORTING | OF | CONTRACTOR | CONTRACT | |||||||||
| CATEGORY | ACTUAL | PLANNED | ACTUAL | PLANNED | September | October | CONTRACT | ESTIMATE | VALUE | |||
| a. | b. | c. | d. | a. | b. | c. | a. | b. | ||||
| HOURS | ||||||||||||
| Prime Labor Hours | 2,750.80 | 1,991.00 | 25,441.70 | 18,006.00 | 2,649.29 | 2,928.80 | 11,891.97 | 42,911.76 | 29,087.00 | - 0 | ||
| Subcontractor Labor Hours | 3,803.00 | 3,143.00 | 32,993.90 | 28,422.00 | 3,435.71 | 3,798.20 | 15,422.03 | 55,649.84 | 45,915.00 | - 0 | ||
| TOTAL LABOR HOURS | 6,553.80 | 5,134.00 | 58,435.60 | 46,428.00 | 6,085.00 | 6,727.00 | 27,314.00 | 98,561.60 | 75,002.00 | - 0 |
| LABOR | ||||||||||
| Prime Labor Cost | 99,632.21 | 91,228.00 | 972,769.84 | 820,346.00 | 106,441.50 | 128,112.00 | 483,950.51 | 1,691,273.85 | 1,328,050.00 | - 0 |
| Subcontractor Labor Costs | 277,747.42 | 203,289.00 | 2,385,432.33 | 1,828,912.00 | 261,016.50 | 285,618.00 | 1,186,746.49 | 4,118,813.32 | 2,960,260.00 | - 0 |
| TOTAL LABOR COSTS | 377,379.63 | 294,517.00 | 3,358,202.17 | 2,649,258.00 | 367,458.00 | 413,730.00 | 1,670,697.00 | 5,810,087.17 | 4,288,310.00 | - 0 |
| PRIME LABOR Indirect Cost | ||||||||||
| Fringe | 42,106.33 | 29,770.00 | 323,904.33 | 267,833.00 | 36,052.00 | 44,697.00 | 177,230.00 | 581,883.33 | 433,509.00 | - 0 |
| Overhead | 5,502.98 | 8,431.00 | 52,576.24 | 75,854.00 | 7,434.00 | 9,217.00 | 36,547.00 | 105,774.24 | 122,778.00 | - 0 |
| Total Indirect Cost | 47,609.31 | 38,201.00 | 376,480.57 | 343,687.00 | 43,486.00 | 53,914.00 | 213,777.00 | 687,657.57 | 556,287.00 | - 0 |
| Labor G&A | ||||||||||
| General and Administrative | 28,118.20 | 31,297.00 | 295,914.43 | 281,567.00 | 31,545.00 | 35,873.00 | 144,584.00 | 507,916.43 | 455,737.00 | - 0 |
| Total G&A Cost | 28,118.20 | 31,297.00 | 295,914.43 | 281,567.00 | 31,545.00 | 35,873.00 | 144,584.00 | 507,916.43 | 455,737.00 | - 0 |
| ODC's | ||||||||||
| Materials | 8,233.11 | 32,310.00 | 433,825.33 | 289,190.00 | 20,199.00 | 31,805.00 | 550,109.00 | 1,035,938.33 | 469,000.00 | - 0 |
| Consultant | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Other | 1,567.44 | - 0 | 15,143.50 | - 0 | - 0 | - 0 | - 0 | 15,143.50 | - 0 | - 0 |
| Training | 15,280.00 | - 0 | 45,853.67 | - 0 | - 0 | - 0 | 159.00 | 46,012.67 | - 0 | - 0 |
| Travel | 1,904.29 | - 0 | 21,460.33 | - 0 | 1,927.00 | - 0 | 48,783.00 | 72,170.33 | - 0 | - 0 |
| SUBTOTAL ODC's | 26,984.84 | 32,310.00 | 516,282.83 | 289,190.00 | 22,126.00 | 31,805.00 | 599,051.00 | 1,169,264.83 | 469,000.00 | - 0 |
| Material G & A | 1,745.05 | 2,964.00 | 40,984.84 | 26,528.00 | 1,657.24 | 2,382.19 | 44,868.92 | 89,893.20 | 43,021.00 | - 0 |
| TOTAL ODC's | 28,729.89 | 35,274.00 | 557,267.67 | 315,718.00 | 23,783.24 | 34,187.19 | 643,919.92 | 1,259,158.03 | 512,021.00 | - 0 |
SUBTOTAL COSTS 481,837.03 399,289.00 4,587,864.84 3,590,230.00 466,272.24 537,704.19 2,672,977.92 8,264,819.20 5,812,355.00 - 0
COM Dollars - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
| FEE | ||||||||||
| Fee | 3,353.91 | 3,011.00 | 30,957.93 | 27,088.00 | 3,517.00 | 4,361.00 | 17,292.00 | 56,127.93 | 43,846.00 | - 0 |
TOTAL COST AND FEE 485,190.94 402,300.00 4,618,822.77 3,617,318.00 469,789.24 542,065.19 2,690,269.92 8,320,947.13 5,856,201.00 - 0
File details come from the government source that posted it. Updated .