Attachment E - E(d) GRC Baseline Template.xlsx

XLSX spreadsheet 35 KB 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 contains a baseline template for tracking labor, costs and performance on a federal contract. The template provides standardized cost categories for reporting direct labor hours and costs for prime and major subcontractors. It also includes categories for reporting indirect labor costs, other direct costs, indirect costs and fees. The template will be used to submit initial baseline data and track performance against the baseline for a contract between the National Aeronautics and Space Administration Glenn Research Center and an unnamed contractor. The goal of the contract is to continue providing information technology solutions and services to meet the research center's changing requirements while supporting the agency's missions.

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(e) GRC Headcount Template.xlsx XLSX spreadsheet
Attachment IS - 1 PACE V Innovation Scenario 1.pdf PDF
Attachment E - E(b) GRC 533 Template.xlsx XLSX spreadsheet
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.

Baseline

YesJanuary
Contract NumberNoFebruary
Contract Line Item Number (If Applicable)March
Contract Task Order (If Applicable)April
Baseline VersionMay
Contract/Task Start YearJune
Contract/Task Start MonthJuly
Capital AssetYear:0ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AAugust
Month:ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/ASeptember
CategoryCategory
(Abbrev)Reporting CategoryReporting Category
(Abbrev)CY 1
Month 1CY 1
Month 2CY 1
Month 3CY 1
Month 4CY 1
Month 5CY 1
Month 6CY 1
Month 7CY 1
Month 8CY 1
Month 9CY 1
Month 10CY 1
Month 11CY 1
Month 12CY 1 TOTALCY 2
Month 1CY 2
Month 2CY 2
Month 3CY 2
Month 4CY 2
Month 5CY 2
Month 6CY 2
Month 7CY 2
Month 8CY 2
Month 9CY 2
Month 10CY 2
Month 11CY 2
Month 12CY 2 TOTALCumulative Through CY 2CY 3
Month 1CY 3
Month 2CY 3
Month 3CY 3
Month 4CY 3
Month 5CY 3
Month 6CY 3
Month 7CY 3
Month 8CY 3
Month 9CY 3
Month 10CY 3
Month 11CY 3
Month 12CY 3 TOTALCumulative Through CY 3CY 4
Month 1CY 4
Month 2CY 4
Month 3CY 4
Month 4CY 4
Month 5CY 4
Month 6CY 4
Month 7CY 4
Month 8CY 4
Month 9CY 4
Month 10CY 4
Month 11CY 4
Month 12CY 4 TOTALCumulative Through CY 4CY 5
Month 1CY 5
Month 2CY 5
Month 3CY 5
Month 4CY 5
Month 5CY 5
Month 6CY 5
Month 7CY 5
Month 8CY 5
Month 9CY 5
Month 10CY 5
Month 11CY 5
Month 12CY 5 TOTALTOTAL CONTRACTOctober
Direct Labor HoursDLHPrimePRM0.000.000.000.000.000.000.000.000.00November
Subcontractor Labor HoursSLHSub1 [Name]Sub1 [Name]0.000.000.000.000.000.000.000.000.00December
Subcontractor Labor HoursSLHSub2 [Name]Sub2 [Name]0.000.000.000.000.000.000.000.000.00
Subcontractor Labor HoursSLHSub3 [Name]Sub3 [Name]0.000.000.000.000.000.000.000.000.00
Total Labor Hours0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Direct Labor CostDLCPrimePRM$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontractor Labor CostSLCSub1 [Name]Sub1 [Name]$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontractor Labor CostSLCSub2 [Name]Sub2 [Name]$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subcontractor Labor CostSLCSub3 [Name]Sub3 [Name]$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0April4
Total Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0August8
December12
Prime Indirect Labor CostILCFringeFRG$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0February2
Prime Indirect Labor CostILCOverheadOH$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0January1
Prime Indirect Labor CostILCOtherOTH
Total Indirect Labor Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0July7
June6
Other Direct CostODCSmall SubcontractorsSUB$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0March3
Other Direct CostODCConsultantsCON$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0May5
Other Direct CostODCFacility and Lease CostsFAC$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0November11
Other Direct CostODCTrainingTRN$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0October10
Other Direct CostODCTravelTRV$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0September9
Other Direct CostODCEquipmentEQP$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct CostODCMaterials and SuppliesMS$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct CostODCLicensesLIC$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct CostODCOtherOTH$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Other Direct Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Indirect CostICOther IndirectOTH$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Indirect CostICLabor G & AGA$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Indirect CostICCOMCOM$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Indirect CostICMaterial G&A/Material OverheadMOG$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Indirect Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
FeeFEEFeeFEE$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTALTOTTOTALTOT$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

CY = Contract Year

Instructions

Instructions:
Complete the baseline template tab for the contract. If the contract has multiple Contract Line Item Number or Task Orders complete a tab for each item and no summary contract page is required.
Fill out the information in the upper left corner as follows:
Contract Number: Enter contract number of the contract
Contract Line Item Number: Enter if contract has multiple Contract Line Item numbers. Leave blank if not applicable
Contract Task Order: Enter if providing information for a task order under the contract. Leave blank if not applicable
Baseline Version: For initial baseline submittal enter 1, for each re-baseline increment the version number by 1.
Contract/Task Start Year: Enter the calendar year the contract period of performance is scheduled to begin
Contract/Task Start Month:Select from the dropdown list the month the contract period of performance is scheduled to begin
Capital Asset: Indicate with the drop down list if the award is for a capital asset.
Cost Reporting Categories:
The template utilizes standardized cost reporting categories. Refer to the Reporting Categories tab for additional information on what to report on each line. If a reporting category is not applicable, then leave the row blank.

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 Subcontractor Name1First four characters of Reporting Category should always be Sub1 (No Space)
3Major Subcontractor Labor HoursSLHSub2 [Name]Sub1 Subcontractor Name1First four characters of Reporting Category should always be Sub2 (No Space)
4Major Subcontractor Labor HoursSLHSub3 [Name]Sub2 Subcontractor Name2First 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 Subcontractor Name1Report fully burdened sub-contract labor
7Major Sub Labor CostSLCSub2 [Name]Sub1 Subcontractor Name1Report fully burdened sub-contract labor
8Major Sub Labor CostSLCSub3 [Name]Sub2 Subcontractor Name2Report 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/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

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