Attachment E - E(b) GRC 533 Template.xlsx

XLSX spreadsheet 1 MB Posted

Attached to
Professional, Administrative, Computational, and Engineering Services contract (PACE V) Federal contract opportunity
Solicitation number
80GRC020R0010
Issued by
National Aeronautics and Space Administration Glenn Research Center

About this file

Written by GovTribe AI ·

This document provides details for a federal solicitation from the National Aeronautics and Space Administration Glenn Research Center. The solicitation seeks proposals for the Professional, Administrative, Computational, and Engineering Services contract (PACE V) to continue providing the highest quality information technology solutions to customers across institutional, programmatic, research, engineering, and facilities domains while ensuring alignment with NASA's missions. Proposals are due by the date listed in solicitation number 80GRC020R0010 to provide IT services anticipated to change in response to the Center's requirements, with the goal of awarding a follow-on contract to the incumbent.

View the file

Other files for this federal contract opportunity

Other files attached to Professional, Administrative, Computational, and Engineering Services contract (PACE V), newest first.
File Type Posted
Additional Questions and Answers for 80GRC020R0010 Amendment 04.pdf PDF
80GRC020R0010 Amendment 04.pdf PDF
Additional Questions and Answers for PACE V RFP 80GRC020R0010.pdf PDF
80GRC020R0010 Amendment 03.pdf PDF
80GRC020R0010 Amendment 02.pdf PDF
Attachment M - Historical Other Direct Costs updated.xlsx XLSX spreadsheet
Attachment C - Historical WYE and ODC by Work Area updated.pdf PDF
Attachment B - Pricing Spreadsheet MS Excel Workbook Template updated.xlsx XLSX spreadsheet
Questions and Answers for 80GRC020R0010.pdf PDF
Attachment K - Historical Labor Category Descriptions Updated.pdf PDF
80GRC020R0010 Amendment 01.pdf PDF
Attachment TS - 2 PACE V Technical Scenario 2.pdf PDF
80GRC020R0010 Rquest for Proposals (RFP).pdf PDF
Attachment K - Historical Labor Category Descriptions.pdf PDF
Attachment I - Past Performance Questionnaire.doc DOC document
Attachment IS - 2 PACE V Innovation Scenario 2.pdf PDF
Attachment E - E(d) GRC Baseline Template.xlsx XLSX spreadsheet
Attachment E - E(e) GRC Headcount Template.xlsx XLSX spreadsheet
Attachment IS - 1 PACE V Innovation Scenario 1.pdf PDF
Attachment M - Historical Other Direct Costs.xlsx XLSX spreadsheet
Attachment L - Cognizant Audit Office Template.xlsx XLSX spreadsheet
Attachment J - Sample Work Orders.pdf PDF
Attachment P - Government Furnished Property.xlsx XLSX spreadsheet
Attachment D - IT Master Plan 2020.pdf PDF
Attachment A - Statement of Work.pdf PDF
Attachment TS - 1 PACE V Technical Scenario 1.pdf PDF
Attachment H - Client Authorization Letter (CAL).doc DOC document
Attachment E - E(c) GRC Accounting Calendar Template.xlsx XLSX spreadsheet
Attachment B - Pricing Spreadsheet MS Excel Workbook Template.xlsx XLSX spreadsheet
Attachment N - Data Center Information.xlsx XLSX spreadsheet
Attachment Q - Large File Transfer User Guide.pdf PDF
Attachment C - Historical WYE and ODC by Work Area.pdf PDF
Attachment E - E(a) GRC 533 Supplemental Cost Report Template.xlsx XLSX spreadsheet
Attachment O - ITS-HBK_2810_ 06_2B.pdf PDF
Show all 34

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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 accross 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 24 detail records for each header record, since there are 23 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 24 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 23 Reporting Categories.

It is required to be electronically submitted with the 533M each month in Excel or CSV format.

HEADERINSTRUCTIONSMax Field Length
HEADER Tab title must always remain in same format (Spelling, Spacing, etc.) and be first tab of the workbook.
RECORD TYPEShould always be "H"1
REPORTING YEARCalendar year for the reporting period (example: 2015)4
REPORTING MONTHCalendar month number for the reporting period end (example: January would be 1, February would be 2, etc)2
REPORT VERSIONInitial submission each month is 1, incrementing by 1 for each (if any) revised reports submitted1
OUTLINE AGREEMENTNASA Outline Agreement number10
CLINNASA CLIN (contract line item number) if applicable, if not leave blank1
TASK AWARDNASA Task Order/Delivery Order (TO/DO) number if applicable, if not leave blank.10
CAPITAL ASSETEnter "Yes" if the TO/DO is for a capital asset, if not leave blank3
CONTRACT TYPEType of contract. See contract type worksheet for possible abbreviations.2
SCOPE OF WORKDescription\name of contract or task (maximum 255 characters)255
LATEST DEFINITIZED MOD #Number of latest definitized modification received by contractor2
REPORT FOR PERIOD ENDINGDate of accounting period end for reporting period (mm/dd/yyyy)10
NUMBER OF WORKING DAYSNumber of working days for the reporting period2
CONTRACT VALUE COSTRounded to the nearest whole dollar - The total dollar value of definitized cost of all currently authorized work to be performed under the contract14
CONTRACT VALUE FEERounded to the nearest whole dollar - The total dollar value of definitized fee of all currently authorized work to be performed under the contract14
FUND LIMITATIONRounded to the nearest whole dollar - The total dollar value of funds obligated on the contract14
INVOICE AMTS BILLEDRounded to the nearest whole dollar - The total dollar value of invoices billed against the contract14
TOTAL PAYMENTSRounded to the nearest whole dollar - The total dollar value of payments received for the contract14
533 DATAINSTRUCTIONS
533 Data Tab title must always be in same format (Spelling, Spacing, etc) and be second tab of the workbook
RECORD TYPEShould always be "D"1
REPORTING YEARCalendar year for the reporting period (example: 2015)4
REPORTING MONTHCalendar month number for the reporting period end (example: January would be 1, February would be 2, etc)1 or 2 depending on month
REPORT VERSIONInitial submission each month is 1, incrementing by 1 for each (if any) revised reports submitted1
OUTLINE AGREEMENTNASA Outline Agreement number10
CLINNASA CLIN (contract line item number) if applicable, if not leave blank1
TASK AWARDNASA Task Order/Delivery Order (TO/DO) number if applicable, if not leave blank10
CAPITAL ASSETEnter "Yes" if the TO/DO is for a capital asset, if not leave blank3
CATEGORYCATEGORY (ABV) - See Reporting Category worksheet for values to be provided.3
REPORTING CATEGORYREPORTING CATEGORY (ABV) - See Reporting Category worksheet for values to be provided.3
Cost/Hours

7a

CURRENT MONTH ACTUALEnter 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 PLANNEDEnter 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 ACTUALEnter 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 PLANNEDEnter 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 ESTIMATEEnter 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 ESTIMATEEnter 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 ESTIMATEEstimate 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 ESTIMATEEnter 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 ESTIMATEEnter 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 VALUEEnter the distribution of the Contract Value to the reporting categories, consistent with the amount reported on the 533M report.14
Cost
UNFILLED ORDERS OUTSTANDINGAs 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
Sample Worksheet Contained in this Spreadsheet
A sample has been provided to help you understand what is needed. A fictitious NF533M has been prepared, consisting in this spreadsheet of three pages: The Example 533 Summary worksheet, the Example 533 - CLIN 1 worksheet, and the Example 533 - CLIN 2. This would simulate a simple NF533M report with two tasks and a summary page.

For this fictitious NF533M, the GRC 533 Template would need to be prepared each month. Two worksheets would need to be populated on the template: the Header worksheet, and the 533 Data worksheet.

The Header worksheet gathers and presents information from the top of each of the three pages on the fictitious NF533M, and puts them on one worksheet. The 533 Data worksheet likewise gathers information from the bottom of each of the three pages of the fictitious NF533M and presents them on one worksheet.

To show you how these two worksheets would be populated from the fictitious NF533M, we have included an example.

The Header worksheet is the template to be prepared monthly. The Header-Example Preparation worksheet is how that worksheet would be prepared using the fictitious NF533M contained here.

Likewise, the 533 Data is the other worksheet in this template to be prepared monthly. The 533 Data-Example Preparation Worksheet worksheet shows how that worksheet would be prepared using the fictitious NF533M contained here.

Reporting Categories

Provide these valuesProvide these values
Numerical Indicator (NI)CategoryCategory
(Abbrev)Reporting CategoryReporting Category
(Abbrev)Notes
1Direct Labor HoursDLHPrimePRM
2Major Subcontractor Labor HoursSLHSub1 [Name]Sub1 Contract Name1First four characters of Reporting Category should always be Sub1 (No Space)
3Major Subcontractor Labor HoursSLHSub2 [Name]Sub2 Contract Name2First four characters of Reporting Category should always be Sub2 (No Space)
4Major Subcontractor Labor HoursSLHSub3 [Name]Sub3 Contract Name3First four characters of Reporting Category should always be Sub3 (No Space). Not limited to 3, should be consistent with what is reported on 533
5Direct Labor CostDLCPrimePRM
6Major Sub Labor CostSLCSub1 [Name]Sub1 Contract Name1Report fully burdened sub-contract labor
7Major Sub Labor CostSLCSub2 [Name]Sub2 Contract Name2Report fully burdened sub-contract labor
8Major Sub Labor CostSLCSub3 [Name]Sub3 Contract Name3Report fully burdened sub-contract labor
9Prime Indirect Labor CostILCFringeFRG
10Prime Indirect Labor CostILCOverheadOH
12Prime Indirect Labor CostILCOther Indirect LaborOTH
13Other Direct CostODCSmall SubcontractorsSUB
14Other Direct CostODCConsultantsCON
15Other Direct CostODCFacility and Lease CostsFAC
16Other Direct CostODCTrainingTRN
17Other Direct CostODCTravelTRV
18Other Direct CostODCEquipmentEQP
19Other Direct CostODCMaterials and SuppliesMS
20Other Direct CostODCLicensesLIC
21Other Direct CostODCOtherOTH
22Indirect CostICOther IndirectOTH
23Indirect CostICMaterial Overhead and Material G&AMOGReport Material Handling, and/or Material Overhead, and/or Material G&A
24Indirect CostICLabor G & AGA
25Indirect CostICCOMCOMFacilities Capital Cost of Money
26FeeFEEFeeFEE
TOTALTOTTOTALTOT

Reporting Categories

&P of &N

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

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

Contract Type

Contract TypeProvide these values
Cost Plus Award FeeAF
Cost SharingCS
Cost Plus Fixed FeeFF
Fixed Price Plus Incentive FeeFI
Firm Fixed PriceFP
Contract HybridHY
Indefinite DeliveryID
Cost Plus Incentive FeeIF
Labor HoursLH
Cost Type - No FeeNF
Small Business Innovative Research - Phase IISC
Time and MaterialsTM

Header-Example Preparation

RECORD TYPEREPORTING YEAR [CY]REPORTING MONTHREPORT VERSIONOUTLINE AGREEMENTCLINTASK AWARDCAPITAL ASSETCONTRACT TYPESCOPE OF WORKLATEST DEFINITIZED MOD #REPORT FOR PERIOD ENDINGNUMBER OF WORKING DAYSCONTRACT VALUE COSTCONTRACT VALUE FEEFUND LIMITATIONINVOICE AMTS BILLEDTOTAL PAYMENTS
H201681NNC16ZZ01B1FFExample Contract - CLIN 118/31/1620$ 5,812,355$ 43,846$6,249,227$4,220,224$3,756,662
H201681NNC16ZZ01B2FFExample Contract - CLIN 218/31/1620$ 8,119,603$ 62,488$9,113,743$5,145,099$4,553,869
H201681NNC16ZZ01BTotalFF533 Example Contract - Total18/31/1620$ 13,931,958$ 106,334$15,362,970$9,365,323$8,310,531

533 Data-Example Preparation 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

D201681NNC16ZZ01B1DLHPRM2,7511,99125,44218,0062,6492,92911,89242,91229,087- 0- 0
D201681NNC16ZZ01B1SLHSub1 XYZ Corp3,8033,14332,99428,4223,4363,79815,42255,65045,915- 0- 0
D201681NNC16ZZ01B1SLHSub2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1SLHSub3- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1DLCPRM99,63291,228972,770820,346106,441128,112483,9511,691,2741,328,050- 0- 0
D201681NNC16ZZ01B1SLCSub1 XYZ Corp277,747203,2892,385,4321,828,912261,017285,6181,186,7464,118,8132,960,260- 0- 0
D201681NNC16ZZ01B1SLCSub2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1SLCSub3- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1ILCFRG42,10629,770323,904267,83336,05244,697177,230581,883433,509- 0- 0
D201681NNC16ZZ01B1ILCOH5,5038,43152,57675,8547,4349,21736,547105,774122,778- 0- 0
D201681NNC16ZZ01B1ILCOTH- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1ODCSUB- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1ODCCON- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1ODCFAC- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1ODCTRN15,280- 045,854- 0- 0- 015946,013- 0- 0- 0
D201681NNC16ZZ01B1ODCTRV1,904- 021,460- 01,927- 048,78372,170- 0- 0- 0
D201681NNC16ZZ01B1ODCEQP- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1ODCMS8,23332,310433,825289,19020,19931,805550,1091,035,938469,000- 0- 0
D201681NNC16ZZ01B1ODCLIC- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1ODCOTH1,567- 015,143- 0- 0- 0- 015,143- 0- 0- 0
D201681NNC16ZZ01B1ICOTH- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1ICMOG1,7452,96440,98526,5281,6572,38244,86989,89343,021- 0- 0
D201681NNC16ZZ01B1ICGA28,11831,297295,914281,56731,54535,873144,584507,916455,737- 0- 0
D201681NNC16ZZ01B1ICCOM- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B1FEEFEE3,3543,01130,95827,0883,5174,36117,29256,12843,846- 0- 0
D201681NNC16ZZ01B1TOTTOT485,191402,3004,618,8233,617,318469,789542,0652,690,2708,320,9475,856,201- 0- 0
D201681NNC16ZZ01B2DLHPRM2,7663,03624,91927,4582,4952,44911,38241,24644,359- 0- 0
D201681NNC16ZZ01B2SLHSub1 XYZ Corp4,5454,57642,55741,1744,2624,18217,06868,06966,641- 0- 0
D201681NNC16ZZ01B2SLHSub2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2SLHSub3- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2DLCPRM109,773129,5281,033,1771,165,087106,130130,427557,3721,827,1061,885,936- 0- 0
D201681NNC16ZZ01B2SLCSub1 XYZ Corp359,038308,8273,308,0792,797,412339,813313,1581,338,2675,299,3184,516,100- 0- 0
D201681NNC16ZZ01B2SLCSub2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2SLCSub3- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2ILCFRG46,44642,428346,226381,70834,80834,518142,768558,320617,830- 0- 0
D201681NNC16ZZ01B2ILCOH6,07012,01656,346108,1087,1787,11829,441100,083174,981- 0- 0
D201681NNC16ZZ01B2ILCOTH- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2ODCSUB- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2ODCCON19,500- 0165,248- 06,5006,50065,000243,248- 0- 0- 0
D201681NNC16ZZ01B2ODCFAC- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2ODCTRN- 0- 011,714- 0- 0- 05,03216,746- 0- 0- 0
D201681NNC16ZZ01B2ODCTRV5,843- 030,665- 0- 0- 016,20446,869- 0- 0- 0
D201681NNC16ZZ01B2ODCEQP- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2ODCMS26,17415,653237,430140,04029,3811,016,600839,5012,122,912227,150- 0- 0
D201681NNC16ZZ01B2ODCLIC- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2ODCOTH- 0- 021,819- 0- 0- 0- 021,819- 0- 0- 0
D201681NNC16ZZ01B2ICOTH- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2ICMOG3,3281,43636,51612,8452,68776,63069,338185,17120,836- 0- 0
D201681NNC16ZZ01B2ICGA34,41846,356375,797418,79037,39637,177158,462608,832676,770- 0- 0
D201681NNC16ZZ01B2ICCOM- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01B2FEEFEE3,7004,29133,05538,6083,3973,36713,93053,74962,488- 0- 0
D201681NNC16ZZ01B2TOTTOT614,291560,5355,656,0725,062,598567,2901,625,4953,235,31511,084,1728,182,091- 0- 0
D201681NNC16ZZ01BTotalDLHPRM5,5175,02750,36145,4645,1455,37823,27484,15873,446- 0- 0
D201681NNC16ZZ01BTotalSLHSub1 XYZ Corp8,3487,71975,55169,5967,6977,98032,490123,719112,556- 0- 0
D201681NNC16ZZ01BTotalSLHSub2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalSLHSub3- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalDLCPRM209,405220,7562,005,9471,985,433212,572258,5391,041,3223,518,3803,213,986- 0- 0
D201681NNC16ZZ01BTotalSLCSub1 XYZ Corp636,785512,1165,693,5124,626,324600,829598,7762,525,0149,418,1317,476,360- 0- 0
D201681NNC16ZZ01BTotalSLCSub2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalSLCSub3- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalILCFRG88,55372,198670,131649,54170,86079,215319,9981,140,2041,051,339- 0- 0
D201681NNC16ZZ01BTotalILCOH11,57320,447108,922183,96214,61216,33565,988205,857297,759- 0- 0
D201681NNC16ZZ01BTotalILCOTH- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalODCSUB- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalODCCON19,500- 0165,248- 06,5006,50065,000243,248- 0- 0- 0
D201681NNC16ZZ01BTotalODCFAC- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalODCTRN15,280- 057,568- 0- 0- 05,19162,759- 0- 0- 0
D201681NNC16ZZ01BTotalODCTRV7,748- 052,126- 01,927- 064,987119,040- 0- 0- 0
D201681NNC16ZZ01BTotalODCEQP- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalODCMS34,40747,963671,255429,23049,5801,048,4051,389,6103,158,850696,150- 0- 0
D201681NNC16ZZ01BTotalODCLIC- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalODCOTH1,567- 036,962- 0- 0- 0- 036,962- 0- 0- 0
D201681NNC16ZZ01BTotalICOTH- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalICMOG5,0734,40077,50139,3734,34579,012114,207275,06463,857- 0- 0
D201681NNC16ZZ01BTotalICGA62,53777,653671,711700,35768,94173,050303,0461,116,7481,132,507- 0- 0
D201681NNC16ZZ01BTotalICCOM- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
D201681NNC16ZZ01BTotalFEEFEE7,0537,30264,01365,6966,9147,72831,222109,877106,334- 0- 0
D201681NNC16ZZ01BTotalTOTTOT1,099,482962,83510,274,8958,679,9161,037,0802,167,5605,925,58519,405,11914,038,292- 0- 0

Example 533 Summary

2. REPORT FOR MONTH ENDING AND NUMBER OF OPERATING DAYS
MONTHLY CONTRACTOR FINANCIAL MANAGEMENT REPORTAugust 31, 201620Days
TO:FROM:3. CONTRACT VALUE
NASA Glenn Research Centera. COSTb. FEE
Mail Stop 60-1$ 13,931,958$ 106,334
Cleveland, OH 44135
1. DESC.a. TYPEb.CONTRACT NO. AND LATEST DEFINITIZED AMEND. NO.4. FUND LIMITATION$15,362,970
OFCost Plus Fixed FeeNNC16ZZ01B5. BILLING
CONTRACTc. SCOPEd. AUTH. CONTR. REP.a. INVOICE AMOUNTS BILLED:b. TOTAL PAYMENTS RECEIVED:
533 Example Contract - Total$9,365,323$8,310,531
7. COST INCURRED / HOURS WORKED8.EST.COST/HRS TO COMPLETE9. ESTIMATED FINAL10. UNFILLED ORDERS OUTSTANDING
DURING MONTHCUM. TO DATEDETAILBALANCECOST / HOURS
6. REPORTINGOFCONTRACTORCONTRACT
CATEGORYACTUALPLANNEDACTUALPLANNEDSeptemberOctoberCONTRACTESTIMATEVALUE
a.b.c.d.a.b.c.a.b.
HOURS
Prime Labor Hours5,5175,02750,36145,4645,1455,37823,27484,15873,446- 0
Subcontractor Labor Hours8,3487,71975,55169,5967,6977,98032,490123,719112,556- 0
TOTAL LABOR HOURS13,86512,746125,912115,06012,84213,35855,765207,877186,002- 0
LABOR
Prime Labor Cost209,405220,7562,005,9471,985,433212,572258,5391,041,3223,518,3803,213,986-
Subcontractor Labor Costs636,785512,1165,693,5124,626,324600,829598,7762,525,0149,418,1317,476,360-
TOTAL LABOR COSTS846,191732,8727,699,4596,611,757813,401857,3153,566,33612,936,51110,690,346-
PRIME LABOR Indirect Cost
Fringe88,55372,198670,131649,54170,86079,215319,9981,140,2041,051,339-
Overhead11,57320,447108,922183,96214,61216,33565,988205,857297,759-
Total Indirect Cost100,12692,645779,053833,50385,47295,550385,9861,346,0611,349,098-
Labor G&A
General and Administrative62,53777,653671,711700,35768,94173,050303,0461,116,7481,132,507-
Total G&A Cost62,53777,653671,711700,35768,94173,050303,0461,116,7481,132,507-
ODC's
Materials34,40747,963671,255429,23049,5801,048,4051,389,6103,158,850696,150-
Consultant19,500-165,248-6,5006,50065,000243,248--
Other1,567-36,962----36,962--
Training15,280-57,568---5,19162,759--
Travel7,748-52,126-1,927-64,987119,040--
SUBTOTAL ODC's78,50347,963983,158429,23058,0071,054,9051,524,7883,620,858696,150-
-
Material G & A5,0734,40077,50139,3734,34579,012114,207275,06463,857-
TOTAL ODC's83,57652,3631,060,659468,60362,3521,133,9171,638,9953,895,922760,007-
- 0
SUBTOTAL COSTS1,092,429955,53310,210,8828,614,2201,030,1662,159,8325,894,36319,295,24213,931,958-

COM Dollars - - - - - - - - - -

FEE
Fee7,0537,30264,01365,6966,9147,72831,222109,877106,334-

TOTAL COST AND FEE 1,099,482 962,835 10,274,895 8,679,916 1,037,080 2,167,560 5,925,585 19,405,119 14,038,292 -

&"Palatino,Regular"&9 533M Page &P &"Palatino,Regular"&9&D

Example 533 - CLIN 1

2. REPORT FOR MONTH ENDING AND NUMBER OF OPERATING DAYS
MONTHLY CONTRACTOR FINANCIAL MANAGEMENT REPORTAugust 31, 201620Days
TO:FROM:3. CONTRACT VALUE
NASA Glenn Research Centera. COSTb. FEE
Mail Stop 60-1$ 5,812,355$ 43,846
Cleveland, OH 44135
1. DESC.a. TYPEb.CONTRACT NO. AND LATEST DEFINITIZED AMEND. NO.4. FUND LIMITATION$ 6,249,227
OFCost Plus Fixed FeeNNC16ZZ01T -- CLIN 15. BILLING
CONTRACTc. SCOPEd. 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 WORKED8.EST.COST/HRS TO COMPLETE9. ESTIMATED FINAL10. UNFILLED ORDERS OUTSTANDING
DURING MONTHCUM. TO DATEDETAILBALANCECOST / HOURS
6. REPORTINGOFCONTRACTORCONTRACT
CATEGORYACTUALPLANNEDACTUALPLANNEDSeptemberOctoberCONTRACTESTIMATEVALUE
a.b.c.d.a.b.c.a.b.
HOURS
Prime Labor Hours2,7511,99125,44218,0062,6492,92911,89242,91229,087- 0
Subcontractor Labor Hours3,8033,14332,99428,4223,4363,79815,42255,65045,915- 0
TOTAL LABOR HOURS6,5545,13458,43646,4286,0856,72727,31498,56275,002- 0
LABOR
Prime Labor Cost99,63291,228972,770820,346106,441128,112483,9511,691,2741,328,050-
Subcontractor Labor Costs277,747203,2892,385,4321,828,912261,017285,6181,186,7464,118,8132,960,260-
TOTAL LABOR COSTS377,380294,5173,358,2022,649,258367,458413,7301,670,6975,810,0874,288,310-
PRIME LABOR Indirect Cost
Fringe42,10629,770323,904267,83336,05244,697177,230581,883433,509-
Overhead5,5038,43152,57675,8547,4349,21736,547105,774122,778-
Total Indirect Cost47,60938,201376,481343,68743,48653,914213,777687,658556,287-
Labor G&A
General and Administrative28,11831,297295,914281,56731,54535,873144,584507,916455,737-
Total G&A Cost28,11831,297295,914281,56731,54535,873144,584507,916455,737-
ODC's
Materials8,23332,310433,825289,19020,19931,805550,1091,035,938469,000-
Consultant----------
Other1,567-15,143----15,143--
Training15,280-45,854---15946,013--
Travel1,904-21,460-1,927-48,78372,170--
SUBTOTAL ODC's26,98532,310516,283289,19022,12631,805599,0511,169,265469,000-
Material G & A1,7452,96440,98526,5281,6572,38244,86989,89343,021-
TOTAL ODC's28,73035,274557,268315,71823,78334,187643,9201,259,158512,021-

SUBTOTAL COSTS 481,837 399,289 4,587,865 3,590,230 466,272 537,704 2,672,978 8,264,819 5,812,355 -

COM Dollars - - - - - - - - - -

FEE
Fee3,3543,01130,95827,0883,5174,36117,29256,12843,846-

TOTAL COST AND FEE 485,191 402,300 4,618,823 3,617,318 469,789 542,065 2,690,270 8,320,947 5,856,201 -

&"Palatino,Regular"&8 533M &8Page &P &"Palatino,Regular"&8&D

Example 533 - CLIN 2

2. REPORT FOR MONTH ENDING AND NUMBER OF OPERATING DAYS
MONTHLY CONTRACTOR FINANCIAL MANAGEMENT REPORTAugust 31, 201620Days
TO:FROM:3. CONTRACT VALUE
NASA Glenn Research Centera. COSTb. FEE
Mail Stop 60-1$ 8,119,603$ 62,488
Cleveland, OH 44135
1. DESC.a. TYPEb.CONTRACT NO. AND LATEST DEFINITIZED AMEND. NO.4. FUND LIMITATION$ 9,113,743
OFCost Plus Fixed FeeNNC16ZZ01T - CLIN 25. BILLING
CONTRACTc. SCOPEd. 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 WORKED8.EST.COST/HRS TO COMPLETE9. ESTIMATED FINAL10. UNFILLED ORDERS OUTSTANDING
DURING MONTHCUM. TO DATEDETAILBALANCECOST / HOURS
6. REPORTINGOFCONTRACTORCONTRACT
CATEGORYACTUALPLANNEDACTUALPLANNEDSeptemberOctoberCONTRACTESTIMATEVALUE
a.b.c.d.a.b.c.a.b.
HOURS
Prime Labor Hours2,7663,03624,92027,4582,4952,44911,38241,24644,359
Subcontractor Labor Hours4,5454,57642,55741,1744,2624,18217,06868,06966,641
TOTAL LABOR HOURS7,3117,61267,47768,6326,7576,63128,451109,315111,000
LABOR
Prime Labor Cost109,773129,5281,033,1771,165,087106,130130,427557,3721,827,1061,885,936
Subcontractor Labor Costs359,038308,8273,308,0792,797,412339,813313,1581,338,2675,299,3184,516,100
TOTAL LABOR COSTS468,811438,3554,341,2573,962,499445,943443,5851,895,6397,126,4246,402,036
PRIME LABOR Indirect Cost
Fringe46,44642,428346,226381,70834,80834,518142,768558,320617,830
Overhead6,07012,01656,346108,1087,1787,11829,441100,083174,981
Total Indirect Cost52,51754,444402,572489,81641,98641,636172,209658,403792,811
Labor G&A
General and Administrative34,41846,356375,797418,79037,39637,177158,462608,832676,770
Total G&A Cost34,41846,356375,797418,79037,39637,177158,462608,832676,770
ODC's
Materials26,17415,653237,430140,04029,3811,016,600839,5012,122,912227,150
Consultant19,5000165,24806,5006,50065,000243,2480
Other0021,819000021,8190
Training0011,7140005,03216,7460
Travel5,843030,66500016,20446,8690
SUBTOTAL ODC's51,51815,653466,875140,04035,8811,023,100925,7372,451,593227,150
Material G & A3,3281,43636,51612,8452,68776,63069,338185,17120,836
TOTAL ODC's54,84617,089503,391152,88538,5681,099,730995,0752,636,764247,986

SUBTOTAL COSTS 610,592 556,244 5,623,017 5,023,990 563,893 1,622,128 3,221,385 11,030,423 8,119,603

COM Dollars

FEE
Fee3,7004,29133,05538,6083,3973,36713,93053,74962,488

TOTAL COST AND FEE 614,291 560,535 5,656,072 5,062,598 567,290 1,625,495 3,235,315 11,084,172 8,182,091

File details come from the government source that posted it. Updated .