J-6_CS_TAT_Cost_Price_Model_TAT2_Correct.xlsx

XLSX spreadsheet 219 KB Posted

Attached to
AFICA IAC CS TATs
Solicitation number
FA8075-14-R-0001
Issued by

About this file

Please disregard Attachment J-6 Cost Price Model included in the CS TAT RFP and use this stand alone version in its place. Note 1 Offerors are hereby informed that some CDRL Exhibits have attachments which can be found by clicking on the paperclip icon in the left margin of the individual CDRL Exhibit. Note 2 If you encounter problems opening the embedded .zip file follow these instructions. Offerors should double-click on the .zip file icon then select Open . If this feature does not work you may.

View the file

Other files

File Type Posted
CS_TAT_RFP_FBO_21Oct14.doc DOC document
CS_TAT_RFP_Q A.xlsx XLSX spreadsheet
CS_TAT_Draft_RFP_FBO_Posting_3Jul14.doc DOC document
CS_TAT_Q A_Posted_FBO_15Aug14.xlsx XLSX spreadsheet
DLA_Form_1818.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Directions

CS TAT COST PRICE MODEL
Request For Proposal FA8075-14-R-000121-Oct-2014
Assumptions:
1.The Fringe Benefit allocation base is total labor dollars.
2.The Labor Overhead allocation base is total direct labor dollars PLUS associated fringe benefit.
3.The G&A allocation base is total cost input.
4.DCAA audited FCCoM, is incorporated into the Cost Centers & other Loading Factors in TAB "Loading Factors.". Must Submit DD 1861.
5.Overtime for exempt personnel is based on a total time accounting concept. (Annual salary divided by total hours worked, equals the hourly rate.)
6.Overtime if used for labor category rates is 1.5 times the straight time rate.
7.The Government will rely on Offerors to tell us in their "Loading Factors" TAB what their Full Time Equivalent (FTE) hours are per year.
FTE hours can be different for each Offeror because they are based on that companies benefits (time off) and other factors.
8.Fixed Fee shall not be applied to Travel ODC.
9.Client site refers to work done at Government locations and per the Sample TATs approximately 90% of the work will be accomplished at a
Government location.
10.Offerors shall not change the subcontractor calculation in the TAB "Grand Total" to include their indirect rates (Pass through charges)
that they charge to subcontractor labor. (See inserted comments in the TAB "Grand Total" for the rows the Government doesn't want changed.)
11.Prime Contractors shall not submit subcontractors with a Cost Type contract that do not have an adequate accounting system.
Directions for PRIME:
1.Primes should delete TABs "SUB Labor Prime Fills in" before sending this Cost Model to their Subcontractors.
2.Primes shall manually fill in TAB "SUB Labor Prime Fills in", for their Subs labor category, hours and rate and type of contract (use dropdown menu).
Directions for both PRIME & SUB(s):
1.Fill in only the cells that are highlighted in yellow, beginning with the company name at the top of TAB "Loading Factors."
2.If the assumptions are not valid, modify appropriate loaded rates in the "Loading Factors" TAB, and if needed throughout the TABs. Identify changes by
highlighting (shading) the cells with changed formulas in Green and describe the changes as well as the reasons for those changes in the space provided at the
bottom of the "Loading Factors" TAB.
3.Complete cells highlighed in yellow in the TABs for the Sample TAT that you are bidding on. Ensure the Cost Centers that you input
into the TAB "Loading Factors" corresponds to the Cost Centers you input into the Sample TAT that you are bidding on
and are correctly matched with the Labor category you proposed.
4.For out years the direct labor rates will automatically be escalated based on inputs in the TAB "Loading Factors."
5.All Offerors shall propose for the first year at least $3,600 for the Management Reporting CLIN 0001 and shall not exceed $19,800 over the life of the contract.
Per Seciton L5.2 all annual dollar values for Management Reporting CLIN when divided by 12 shall be in whole dollars.
6.Travel and Material/Equipment ODC dollar values are provided for in the TAB "Grand Total" for the unrestricted Full & Open Sample TAT.
7.The partial SB set-aside will not have Travel and Material/Equipment ODCs for purposes of bidding.
8.Grand and sub totals are reflected in whole dollars and shall stay that way.
9.If applicable provide your proprietary statement in the footer of each TAB.
Directions for SUBs:
1.All Subcontractors must submit their TAB "SUB Labor Prime Fills in" which includes their Labor Categories, Burdened Rates and Hours for each period
to their Prime contractor so the Prime can fill in their own TAB "SUB Labor Prime Fills in" and thereby automatically filling in their TAB "Grand Total."
2.Subcontractors should submit the following TABs to the Prime Contractor in a sealed package or send them directly to the Contracting Officer no later
than the date and time established for receipt of proposals: Every TAB except "Sub Labor Prime Fills in" to the Contracting Officer
3.Note to Subs: Make sure your Labor Category rates in the Sample TAT TAB(s) are the exact same as the rates in the TAB "Sub Labor Prime Fills in."
Helpful Hints and Reminders:
1.For approved DCAA loaded rates not identified in the "Loading Factors" TAB you can include these changes by inserting or deleting new rows or
columns in the middle of ranges, the applicable formulas and references for computational cells can be input using the "click and drag" technique.
2.Use the checklist provided below to ensure your proposal is complete.
3.If your company has different approved indirect rates than provided in the TAB "Loading Factors", then by all means, please just replace the existing indirect
rates with your companies approved indirect rates and that way you don't have to change the formulas throughout the model just the naming convention.
Cost Model Checklist (Have the following been completed?)
Subs were sent the Pricing Model with all the TABs except "SUB Labor Prime Fills in" you bid on
Prime / Sub company names are entered on the "Loading Factors" TAB. (Company names automatically populate to the rest of the TABs)
Input your Indirect rates into the "Loading Factors" TAB.
If the pricing model formulas for applying the indirect rates are not consistent with company accounting practices,
the appropriate formulas have been modified,
the changed cells are highlighted in Green and the changes are explained at the bottom of the "Loading Factors" TAB.
Listed your cognizant DCAA and DCMA representatives in the "Loading Factors" TAB.
Provided your Department of Defense Activity Address Code (DoDAAC) in the "Loading Factors" TAB.
If rates/categories differ from the model, the differences are explained at the bottom of the "Loading Factors" TAB.
Labor Category, Employees if Applicable, Cost Center, Direct Labor and Hours are entered into the appropriate Sample TAT that you are bidding on.
Prime has manually filled in the TAB "SUB Labor Prime Fills in" with each one of the Subcontractor's Labor Categories, Hours & Rate.
Prime has filled in the TAB "Grand Total" their Travel and Material/Equipment ODCs indirect rates.
If applicable, supporting information for additional indirect rates are provided in the Cost Volume Narrative.
Supporting information for labor and indirect rates that you submitt are provided in another TAB. (For example for FCCoM the DD Form 1861).

&F

Loading Factors

LOADING FACTORS CS TAT MAC IDIQ
Prime Name:Prime
Subcontractor Name:Sub
Your Cost Center #
LOADING FACTORS:Base PeriodOpt 1, Yr 2Opt 1, Yr 3Opt 2, Yr 4Opt 2, Yr 5
Labor Escalation

Stanley.Stearns: Stanley.Stearns:

Depending on the Period of Performance a blended escalation rate can be used. Attach your worksheet to the end of this workbook in TAB "Esc Rate calcuation" reflecting how you calculated your escalation rate.0.00%0.00%0.00%0.00%
CLIENT (GOVERNMENT) SITE:
CC 1: Fringe1

Stanley.Stearns: Stanley.Stearns:

If you have them, input your own Cost Center numbers that you will be utilizing for this TAT.0.00%0.00%0.00%0.00%0.00%
CC 1: Overhead-Client (Government) Site10.00%0.00%0.00%0.00%0.00%
CC 1: FCCoM10.00%0.00%0.00%0.00%0.00%
CC 2: Fringe20.00%0.00%0.00%0.00%0.00%
CC 2: Overhead-Client (Government) Site20.00%0.00%0.00%0.00%0.00%
CC 2: FCCoM20.00%0.00%0.00%0.00%0.00%
CC 3: Fringe30.00%0.00%0.00%0.00%0.00%
CC 3: Overhead-Client (Government) Site30.00%0.00%0.00%0.00%0.00%
CC 3: FCCoM30.00%0.00%0.00%0.00%0.00%
CC 4: Fringe40.00%0.00%0.00%0.00%0.00%
CC 4: Overhead-Client (Government) Site40.00%0.00%0.00%0.00%0.00%
CC 4: FCCoM40.00%0.00%0.00%0.00%0.00%
CONTRACTOR SITE:
CC 5: Fringe50.00%0.00%0.00%0.00%0.00%
CC 5: Overhead-Contractor Site50.00%0.00%0.00%0.00%0.00%
CC5: FCCoM50.00%0.00%0.00%0.00%0.00%
CC 6: Fringe60.00%0.00%0.00%0.00%0.00%
CC 6: Overhead-Contractor Site60.00%0.00%0.00%0.00%0.00%
CC 6: FCCoM60.00%0.00%0.00%0.00%0.00%
OTHER LOADING FACTORS:
*Independent R&D / Bid & Proposal Rate0.00%0.00%0.00%0.00%0.00%
*IT (Computing) or Occupancy (OCC) or PMO Allocation0.00%0.00%0.00%0.00%0.00%
If you pool FCCoM as 1 pool: FCCoM, Direct Labor0.000%0.000%0.000%0.000%0.000%
If you pool FCCoM as 1 pool: FCCoM, G&A0.000%0.000%0.000%0.000%0.000%
General and Administrative (G&A) Rate0.00%0.00%0.00%0.00%0.00%
Material & Handling (Burden on ODC &/or Subs)0.00%0.00%0.00%0.00%0.00%
Fee on Sub Labor (Only Prime fills this in)0.00%0.00%0.00%0.00%0.00%
Fee on Material (Only Prime fills this in)0.00%0.00%0.00%0.00%0.00%
Fixed Fee Sample TAT 1 (Unrestricted Full & Open)0.00%0.00%0.00%0.00%0.00%
Fixed Fee Sample TAT 2 (Partial SB Set-aside)0.00%0.00%0.00%
** Annual salary is divided by 2080 for direct labor20802080208020802080
* If you have "OTHER LOADING FACTORS" and don't have one or both of the indirects listed above simply rename it.
*All offerors will use 2080 unless they have identified Uncompensated Overtime. (See FAR 52.237-10)
YESNO
Do you have a Forward Pricing Rate Agreement? (Provide if you do)
Do you have a Forward Pricing Rate Recommendation? (Provide if you do)
Do you have an Approved or Adequate Accounting System
If you have an Approved or Adequate Accting System provide Date & Audit #
Does the Prime have a DCMA Approved Purchasing System?
Provide the date DCMA approved your Purchasing System
Identify your company's Full Time Equivalent (FTE) Hours0
Subcontractor identify the type of contract you have with the Prime?Drop Down Menu
DCAA, DCMA, DoDAAC & CHANGES TO PRICE MODEL
Prime Name:Prime
Subcontractor Name:Sub
List your Cognizant DCAA and DCMA Representative or Branch:
Utilize the DCAA website to locate your audit office number at http://www.dcaa.mil/
The DCAA office listed below will be the same office the offeror sent their cost proposal to
Name & or Branch (If Branch, include Branch #):
Address:
Phone Number & Fax Number:Phone:Fax:
E-mail:
E-mail for DCAA is first name, a period, Last Name, @dcaa.mil OR you can use the DCAA branch number
dcaa-fao, Last 4 of the branch #@dcaa.mil Example: stanley.stearns@dcaa.mil OR dcaa-fao1621@dcaa.mil
Defense Contract Management Agency (DCMA) Cognizant office & DoDAAC:
Name & or Location:
Address:
Department of Defense Activity Address Code (DoDAAC):
Phone Number & Fax NumberPhone:Fax:
E-mail:
Note: The DoDAAC helps us identify your DFAS payment office so if you win an award we will have it for the contract.
CHANGES TO PRICING MODEL (ie.. Additional approved DCAA Loading Rates):
NOTE: If your company has different approved indirect rates than provided above, then by all means, please just replace the existing indirect rates with your
companies approved indirect rates and that way you don't have to change the formulas throughout the model just the naming convention.

Created by: Stanley F. Stearns, Sr Cost/Price Analyst AFICA/KD

SAMPLE TAT 1 F&O

Full & Open PRIME Name:Prime
Subcontractor Name:Sub
SAMPLE TAT 1 Unrestricted F&OCS TAT BASE PERIOD & TWO 2 YR OPTIONS, FULLY BURDENED RATES
Note: If your company applies Overhead to Direct only and not Direct Labor and Fringe then you will have to change the "OH" Formula my going in and deleting column & row F9 (Fringe for Client Site), and column and row F38 (Fringe for Contractor Site) in all three places. Then copy the formula down. You have to put in a Cost Center # for the formula to work.
BASE PERIOD YEAR 1
CLIN 0002 R&D (CPFF)YourCLIENT (Government) Site BASE PERIOD (01 Oct 15 - 30 Sept 16)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation

Stanley.Stearns: Stanley.Stearns:

If you have them, input your own Cost Center numbers that you will be utilizing for this TAT. Other wise use the numering system provided in the TAB "Loading Factors." Either way make sure they match to the Loading Factor you want for each Labor Category.0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
Client (Government) Site TOTAL0$ - 0$ - 0
CLIN 0002 R&D (CPFF)YourCONTRACTOR Site BASE PERIOD (01 Oct 15 - 30 Sept 16)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
Contractor Site TOTAL0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
Base Period, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
OPTION 1, YEAR 2
CLIN 0002 R&D (CPFF)YourCLIENT (Government) Site OPTION 1 YR 2 (01 Oct 16 - 30 Sept 17)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
Client (Government) Site TOTAL0$ - 0$ - 0
CLIN 0002 R&D (CPFF)YourCONTRACTOR Site OPTION 1 YR 2 (01 Oct 16 - 30 Sept 17)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
Contractor Site TOTAL0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
Option 1, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
OPTION 1, YEAR 3
CLIN 0002 R&D (CPFF)YourCLIENT (Government) Site OPTION 1 YR 3 (01 Oct 17 - 30 Sept 18)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
Client (Government) Site TOTAL0$ - 0$ - 0
CLIN 0002 R&D (CPFF)YourCONTRACTOR Site OPTION 1 YR 3 (01 Oct 17 - 30 Sept 18)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
Contractor Site TOTAL0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
Option 2, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
OPTION 2, YEAR 4
CLIN 0002 R&D (CPFF)YourCLIENT (Government) Site OPTION 2 YR 4 (01 Oct 18 - 30 Sept 19)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
Client (Government) Site TOTAL0$ - 0$ - 0
CLIN 0002 R&D (CPFF)YourCONTRACTOR Site OPTION 2 YR 4 (01 Oct 18 - 30 Sept 19)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
Contractor Site TOTAL0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
Option 2, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
OPTION 2, YEAR 5
CLIN 0002 R&D (CPFF)YourCLIENT (Government) Site OPTION 2 YR 5 (01 Oct 19 - 30 Sept 20)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
Client (Government) Site TOTAL0$ - 0$ - 0
CLIN 0002 R&D (CPFF)YourCONTRACTOR Site OPTION 2 YR 5 (01 Oct 19 - 30 Sept 20)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 PEO Space Systems Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Mobile User Objective System (MUOS) Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Remote Sensing Program(s) Office (RSPO) Analyses
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
Contractor Site TOTAL0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
Option 2, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
All YEARS, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0

&F

SAMPLE TAT 2 SB Set-aside

Partial SB Set-aside PRIME Name:Prime
Subcontractor Name:Sub
SAMPLE TAT 2 SB Set-asideCS TAT BASE PERIOD & TWO 1 YR OPTIONS, FULLY BURDENED RATES
Note: If your company applies Overhead to Direct only and not Direct Labor and Fringe then you will have to change the "OH" Formula my going in and deleting column and column & row F9 (Fringe for Client Site), and column and row F38 (Fringe for Contractor Site) in all three places. Then copy the formula down. You have to put in a Cost Center # for the formula to work.
BASE PERIOD YEAR 1
CLIN 0002 R&D (CPFF)YourCLIENT (Government) Site BASE PERIOD (01 Oct 15 - 30 Sept 16)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation

Stanley.Stearns: Stanley.Stearns:

If you have them, input your own Cost Center numbers that you will be utilizing for this TAT. Other wise use the numering system provided in the TAB "Loading Factors." Either way make sure they match to the Loading Factor you want for each Labor Category.0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 Preliminary Assessment & Contracting Management Planning
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Evaluate & Implement the Sustainment Portal
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Training Enhancements, Integration, Portal Capability Inprovements & Software Licensing Strategy Recommendations
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
Client (Government) Site TOTAL0$ - 0$ - 0
CLIN 0002 R&D (CPFF)YourCONTRACTOR Site BASE PERIOD (01 Oct 15 - 30 Sept 16)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 Preliminary Assessment & Contracting Management Planning
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Evaluate & Implement the Sustainment Portal
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Training Enhancements, Integration, Portal Capability Inprovements & Software Licensing Strategy Recommendations
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
Contractor Site TOTAL0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
Base Period, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
OPTION 1, YEAR 2
CLIN 0002 R&D (CPFF)YourCLIENT (Government) Site OPTION 1 YR 2 (01 Oct 16 - 30 Sept 17)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 Preliminary Assessment & Contracting Management Planning
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Evaluate & Implement the Sustainment Portal
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Training Enhancements, Integration, Portal Capability Inprovements & Software Licensing Strategy Recommendations
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
Client (Government) Site TOTAL0$ - 0$ - 0
CLIN 0002 R&D (CPFF)YourCONTRACTOR Site OPTION 1 YR 2 (01 Oct 16 - 30 Sept 17)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 Preliminary Assessment & Contracting Management Planning
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Evaluate & Implement the Sustainment Portal
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Training Enhancements, Integration, Portal Capability Inprovements & Software Licensing Strategy Recommendations
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
Contractor Site TOTAL0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
Option 1, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
OPTION 2, YEAR 3
CLIN 0002 R&D (CPFF)YourCLIENT (Government) Site OPTION 2 YR 3 (01 Oct 17 - 30 Sept 18)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 Preliminary Assessment & Contracting Management Planning
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Evaluate & Implement the Sustainment Portal
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Training Enhancements, Integration, Portal Capability Inprovements & Software Licensing Strategy Recommendations
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
Client (Government) Site TOTAL0$ - 0$ - 0
CLIN 0002 R&D (CPFF)YourCONTRACTOR Site OPTION 2 YR 3 (01 Oct 17 - 30 Sept 18)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Post Award Orientation
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 2 STI Relevance Assessment & Gap Analysis
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3 Preliminary Assessment & Contracting Management Planning
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4 Evaluate & Implement the Sustainment Portal
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 5 Training Enhancements, Integration, Portal Capability Inprovements & Software Licensing Strategy Recommendations
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Contractor Site TASK Sub-TOTAL0$ - 0$ - 0
Contractor Site TOTAL0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
Option 2, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
FTE EqualsTOTALTOTAL
EquivalentHOURSW/Out FCCoMWith FCCoM
All YEARS, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0

J-6_CS_TATs_Cost_Price_Model

SUB Labor Prime Fills in

PRIME Name:Prime
Subcontractor Name:0
CS TAT LABOR HOUR & COST BREAKDOWN BY SUB FOR EACH SAMPLE TAT
NOTE 1: Only Primes will submitt this TAB to the Contracting Officer. Subcontractors will submit this TAB to their Prime contractor.
NOTE 2: Subs make sure your Sample TAT TAB(s) fully burdened labor category rates equal the rates submitted in this TAB.
NOTE 3: Start with the 1st Labor Category for the 1st Sub you have in cell B16 and so on. The Tab "Grand Total" will add the burdens that you listed in the "Loading Factors" Tab.
NOTE 4: If you treat independent consultants as subcontracted labor then name one of the Subcontractor Names as "Independent Consultant(s)" and list the name(s) or Labor Category for each person under the "Labor Category" column.
SAMPLE TAT 1 (For Unrestricted Full & Open)
Identify The Type Of Contract The PRIME Has With Each SUBCONTRACTOR
Subcontractor NameType of Contract with Prime
Input 1st Sub Name here if UtlizedFFPLOE
Input 2nd Sub Name here if UtilizedDrop Down Menu
Input 3rd Sub Name here if UtilizedDrop Down Menu
Input 4th Sub Name here if UtilizedDrop Down Menu
CLIN 0002: R&D TATs (CPFF)BASE PERIODOPTION 1 YR 2OPTION 1 YR 3OPTION 2 YR 4OPTION 2 YR 5
Labor Category or Names if ApplicableHOURSRATECOSTHOURSRATECOSTHOURSRATECOSTHOURSRATECOSTHOURSRATECOST
TASK 1
00.00000.00000.00000.00000.000
00.00000.00000.00000.00000.000
Sub-Contractor Site TASK Sub-TOTAL0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
TASK 2
00.00000.00000.00000.00000.000
00.00000.00000.00000.00000.000
Sub-Contractor Site TASK Sub-TOTAL0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
TASK 3

This is the start of the file's text. The full file is on GovTribe.

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