J-6a_IAC_MAC_Cost_Price_Table_Pool_3_TO4_3Oct17.xlsx

XLSX spreadsheet 146 KB Posted

Attached to
FA8075-17-R-0001, for DTIC $28B 9 Year IDIQ Information Analysis Center Multiple-Award Contract (IAC MAC)
Solicitation number
FA8075-17-R-0001
Issued by

About this file

This document provides a template and instructions for submitting cost and pricing information in response to solicitation number FA8075-17-R-0001 for the DTIC $28B 9 Year IDIQ Information Analysis Center Multiple-Award Contract. Relevant details include a period of performance from 2018 to 2022 across five sample task orders, with labor categories, direct rates, overhead rates, G&A rates, and fee percentages to be completed by offerors. The template also includes sections for prime and subcontractor labor hours and costs, other direct costs such as travel and materials, and a grand total summary. Instructions provide guidance on completing labor rates, indirect pools, and subcontractor information.

J-6a Cost Price Table for SAMPLE Task Order 4 for Pool 3

View the file

Other files

Show all 18

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

IAC MAC COST PRICE TABLE POOL 3
Request For Proposal FA8075-17-R-000115-Sep-2017
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, shall use their uncompensated overtime rate (see FAR 52.237-10)
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.
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.
12.The Cost/Price Table is a tool provided to establish uniformity in proposals. Offerors are solely responsible for the accuracy of all prices and
costs propsosed and annotated in the Cost/Price Table. Offeros should change the Cost/Price Table to ensure it accurately reflects their proposal.
Directions for PRIME with SUB(s):
1.Primes should notify their Sub(s) that the only data or portion of the Cost/Price Table they want back is the TAB "SUB Labor Prime Fills in". Primes can
get this data directly from their Sub(s) without the table but either way the Sub(s) will submitt the rest of the TABs in the Cost/Price Table to the Government.
2.Primes should ensure that their Sub(s) Cost/Price Table data gets submitted to the Government by the deadline specified in the RFP.
3.Primes for their proposal, shall manually fill in TAB "SUB Labor Prime Fills in", for their Subs burdened rate, labor category, hours, and type of contract.
Directions for both PRIME & SUB(s):
1.If the assumptions are valid, 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 TO. Ensure the Cost Centers that you input into the TAB "Loading Factors"
corresponds to the Cost Centers you input into the Sample TO(s) and are correctly matched with the Labor category you selected.
4.For out years the direct labor rates escalation rate will automatically be escalated based on inputs in the TAB "Loading Factors."
5.The Minimum Order Guarantee of $3,600.00 has already been included in the "Grand Total" TAB. This amount will go to award winners as the 1st Task Order.
6.Travel and Material/Equipment ODC dollar values are provided for in the TAB "Grand Total".
7.Grand and sub totals are reflected in whole dollars and shall stay that way.
8.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 understand that the TAB "SUB Labor Prime Fills in" should be removed and filled out separately so your TAB "Grand Total" is not double
counted. Primes can remove this TAB and send separately to their SUB(s) or have their SUB(s) do it. Primes can also get this data in another way if desired.
3.Subcontractors should submit all TABs to the place listed in Section L of the RFP before the date and time established for receipt of proposals. The
package should include on the cover who they are and who their Prime is so the Government knows who the SUB(s) are proposing with.
If Primes and SUB(s) agree to submit all cost/price directly to the Primes first instead of the SUB(s) sending directly to the Government (some do this to
ensure all the cost/price tables and Cost Volumes are submitted in a timely manner) then the SUB(s) should seal the package they submit to the Primes, that
way Primes can not see the SUB(s) proprietary data. The Primes only need the fully burden labor rates for the TAB "SUB Labor Prime Fills in"
to include their SUB(s) in their cost/price proposal.
4.Note to Subs: Make sure your burden Labor Category rates in the Sample TO 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 TAB "Loading Factors" 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.If your company has different types of 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.
3.If you need to make appropriate changes to any TAB you can, (i.e. you can add labor category rows). Please refer to helpful hint 1 and 2. on how to do it.
4.Use the checklist provided below to ensure your proposal is complete.
Cost Model Checklist (Have the following been completed?)
Subs were sent the Cost/Price Table with the notifiicatoin that the Prime only shall see the TAB "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 your type of indirect rates/categories & calculations 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 TO that you are bidding on.
Prime has manually filled in the TAB "SUB Labor Prime Fills in" with each one of the Subcontractor's Burdened Labor Categories, Hours & Rate.
Prime has filled in the TAB "Grand Total" their Travel and Material/Equipment ODCs indirect rates.
Supporting information for your type of indirect rates and your actual 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 Escalation, FCCoM the DD Form 1861, etc.)

&F

Loading Factors

LOADING FACTORS IAC MAC POOL 3 for SAMPLE TO 4
Prime Name:Prime
Subcontractor Name:Sub
Your Cost Center #
LOADING FACTORS:Base Year 1Year 2Year 3Year 4Year 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.000%0.000%0.000%0.000%0.000%
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.000%0.000%0.000%0.000%0.000%
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.000%0.000%0.000%0.000%0.000%
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.000%0.000%0.000%0.000%0.000%
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 TO 1 & 2 (Unrestricted Full & Open)0.00%0.00%0.00%0.00%0.00%
** Annual salary is divided by 2080 for direct labor rate20802080208020802080
* 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) to figure their direct rate.
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?
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 TO 4 CBRN Labs

CBRN Labs PRIME Name:Prime
Subcontractor Name:Sub
SAMPLE TO 4IAC MAC SAMPLE TO 4 LABOR 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 YEAR 1
CLIN 0001 R&D (CPFF)YourCLIENT (Government) BASE YEAR 1 (01 Jan 18 - 31 Dec 18)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management

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
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4
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
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 0001 R&D (CPFF)YourCONTRACTOR Site BASE YEAR 1 (01 Jan 18 - 31 Dec 18)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management
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
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
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
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
YEAR 1, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
YEAR 2
CLIN 0001 R&D (CPFF)YourCLIENT (Government) Site YEAR 2 (01 Jan 19 - 31 Dec 19)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management
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
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4
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
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 0001 R&D (CPFF)YourCONTRACTOR Site YEAR 2 (01 Jan 19 - 31 Dec 19)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management
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
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
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
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
YEAR 2, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
YEAR 3
CLIN 0001 R&D (CPFF)YourCLIENT (Government) Site YEAR 3 (01 Jan 20 - 31 Dec 20)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management
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
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4
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
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 0001 R&D (CPFF)YourCONTRACTOR Site YEAR 3 (01 Jan 20 - 31 Dec 20)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management
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
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
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
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
YEAR 3, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
YEAR 4
CLIN 0001 R&D (CPFF)YourCLIENT (Government) Site YEAR 4 (01 Jan 21 - 31 Dec 21)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management
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
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4
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
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 0001 R&D (CPFF)YourCONTRACTOR Site YEAR 4 (01 Jan 21 - 31 Dec 21)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management
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
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
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
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
YEAR 4, CUMULATIVE TOTAL of Client & Contractor SiteERROR:#DIV/0!0$ - 0$ - 0
YEAR 5
CLIN 0001 R&D (CPFF)YourCLIENT (Government) Site YEAR 5 (01 Jan 22 - 31 Dec 22)
If ApplicableCostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName Of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management
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
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 3
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
0.000.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Government) Site TASK Sub-TOTAL0$ - 0$ - 0
TASK 4
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
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 0001 R&D (CPFF)YourCONTRACTOR Site YEAR 5 (01 Jan 22 - 31 Dec 22)
If Applicable,CostDirectIT/occ/PMOFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryName of EmployeeCenterRateFringeOHB & PG&AFeeCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
TASK 1 Program Management
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
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
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
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
YEAR 5, 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:Sub
POOL 3 IAC MAC LABOR HOUR & COST BREAKDOWN BY SUB FOR EACH TASK
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 TO 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 TO 4 (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 0001: R&D TOs (CPFF)BASE YEAR 1YEAR 2YEAR 3YEAR 4YEAR 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
00.00000.00000.00000.00000.000
Sub-Contractor Site TASK Sub-TOTAL0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
TASK 3
00.00000.00000.00000.00000.000
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 4
00.00000.00000.00000.00000.000
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
Input 1st Sub Name here if Utlized0000000000
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
00.00000.00000.00000.00000.000
Sub-Contractor Site TASK Sub-TOTAL0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
TASK 3
00.00000.00000.00000.00000.000
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 4
00.00000.00000.00000.00000.000
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
Input 2nd Sub Name here if Utilized0000000000
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
00.00000.00000.00000.00000.000
Sub-Contractor Site TASK Sub-TOTAL0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
TASK 3
00.00000.00000.00000.00000.000
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 4
00.00000.00000.00000.00000.000
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
Input 3rd Sub Name here if Utilized0000000000
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
00.00000.00000.00000.00000.000
Sub-Contractor Site TASK Sub-TOTAL0$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 00$ - 0$ - 0
TASK 3
00.00000.00000.00000.00000.000
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 4
00.00000.00000.00000.00000.000
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
Input 4th Sub Name here if Utilized0000000000
Total of All SUBs by Period000$ - 00$ - 00$ - 00$ - 0
BASE YEAR 1YEAR 2YEAR 3YEAR 4YEAR 5
HOURSFTE EquivalantCOSTHOURSFTE EquivalantCOSTHOURSFTE EquivalantCOSTHOURSFTE EquivalantCOSTHOURSFTE EquivalantCOST
Cumulative Total of All SUBs0ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 0

Grand Total

PRIME Name:PrimeRFP: FA8075-17-R-0001
CLIN 0004 Firm Fixed Price (FFP)Minimum Order GuaranteeDo Not Change the Minimum Order Guarantee Dollar Amount or the Government could determine your Offer to be non-responsive
CLIN 0004 TOTAL:$3,600

Stanley.Stearns: Stanley.Stearns:

Shall bid the Minimum Order Quarantee of $3,600. This amount will be provided to all IAC MAC award winners as the first Task Order.

PRIME Name:Prime
Subcontractor Name:Sub
SAMPLE TO 4, CLIN 0001 R&D (CPFF, for POOL 3 CBRN Labs)
SAMPLE TO 4, CLIN 0001 R&D (CPFF, for POOL 3 CBRN Labs)BASE YEAR 1YEAR 2YEAR 3YEAR 4YEAR 5
1 Jan 18 - 31 Dec 18, Year 11 Jan 19 - 31 Dec 19, Year 21 Jan 20 - 31 Dec 20, Year 31 Jan 21 - 31 Dec 21, Year 41 Jan 22 - 31 Dec 22, Year 5TOTALPercentage
HoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCost
TASK 1 Prime Labor Hours & Cost- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 1st Sub Name here if Utlized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 2nd Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 3rd Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 4th Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Subcontractor TOTAL CLIN- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Prime M&H on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
Prime G&A on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
Prime Fee on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
FCCoM G&A on Sub0.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 0$ - 0ERROR:#DIV/0!
TASK 1 Sub Total- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
TASK 2 Prime Labor Hours & Cost- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 1st Sub Name here if Utlized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 2nd Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 3rd Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 4th Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Subcontractor TOTAL CLIN- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Prime M&H on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
Prime G&A on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
Prime Fee on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
FCCoM G&A on Sub0.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 0$ - 0ERROR:#DIV/0!
TASK 2 Sub Total- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
TASK 3 Prime Labor Hours & Cost- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 1st Sub Name here if Utlized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 2nd Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 3rd Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 4th Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Subcontractor TOTAL CLIN- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Prime M&H on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
Prime G&A on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
Prime Fee on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
FCCoM G&A on Sub0.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 0$ - 0ERROR:#DIV/0!
TASK 3 Sub Total- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
TASK 4 Prime Labor Hours & Cost- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 1st Sub Name here if Utlized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 2nd Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 3rd Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 4th Sub Name here if Utilized- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Subcontractor TOTAL CLIN- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Prime M&H on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
Prime G&A on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
Prime Fee on Sub Labor0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!
FCCoM G&A on Sub0.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 0$ - 0ERROR:#DIV/0!
TASK 4 Sub Total- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
TRAVEL ODC, CLIN 0002$ 64,000$ 64,000$ 64,000$ 64,000$ 64,000$ 320,000100.0%
Travel - Prime G&A0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 00.0%
Travel - Prime FCCoM G&A0.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 0$ - 00.0%
Travel - Prime Total$ 64,000$ 64,000$ 64,000$ 64,000$ 64,000$ 320,000100%
Material. ODC, CLIN 0001$ 640,000$ 640,000$ 640,000$ 640,000$ 640,000$ 3,200,000100.0%
Material - Prime M&H0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 00.0%
Material - Prime G&A0.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 00.0%
Material - Prime FCCoM G&A0.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 0$ - 00.0%
Material - Material Prime Fee0.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 00.000%$ - 0$ - 00.0%
Material - Prime Total$ 640,000$ 640,000$ 640,000$ 640,000$ 640,000$ 3,200,000100%
SAMPLE TO 4 TOTAL ODCs$ 704,000$ 704,000$ 704,000$ 704,000$ 704,000$ 3,520,000
BASE YEAR 1YEAR 2YEAR 3YEAR 4YEAR 5TOTALPercentage
HoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCost
TOTAL PRIME Hrs & Cost- 0$ 704,000- 0$ 704,000- 0$ 704,000- 0$ 704,000- 0$ 704,000- 0$ 3,520,000ERROR:#DIV/0!100%
TOTAL SUB Hrs & Cost- 0$ - 0

Stanley.Stearns: Stanley.Stearns:

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 for this year or the out years. - 0 $ - 0 Stanley.Stearns: Stanley.Stearns:

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 for this year or the out years. - 0 $ - 0 Stanley.Stearns: Stanley.Stearns:

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 for this year or the out years. - 0 $ - 0 Stanley.Stearns: Stanley.Stearns:

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 for this year or the out years. - 0 $ - 0 Stanley.Stearns: Stanley.Stearns:

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 for this year or the out years.- 0$ - 0ERROR:#DIV/0!0%
GRAND TOTAL BY YEAR- 0$ 704,000- 0$ 704,000- 0$ 704,000- 0$ 704,000- 0$ 704,000- 0$ 3,520,000ERROR:#DIV/0!100%
SAMPLE TO 4 FTEsBASE YEAR 1 FTEYEAR 2 FTEYEAR 3 FTEYEAR 4 FTEYEAR 5 FTEToral FTEsFTE %
FTE TOTAL PRIMEERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
FTE TOTAL SUBERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
FTE GRAND TOTAL:ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
GRAND TOTAL SUMMARY (Pool 3 for Sample Task Order 4)RFP: FA8075-17-R-0001
Sample TO 4:
CLINs X001, 0002, & 3000Base Year 1 Jan 18 - 31 Dec 18Year 2 1 Jan 19 - 31 Dec 19Year 3 1 Jan 20 - 31 Dec 20Year 4 1 Jan 21 - 31 Dec 21Year 5 1 Jan 22 - 31 Dec 22Sub Total Auto Calculated CLIN 3000TOTALPercentage
TOTAL PROPOSED PRICEHOURSPRICEHOURSPRICE
PRIME$707,600$704,000$704,000$704,000$704,000$388,538

STEARNS, STANLEY F GS-13 USAF AFICA/KD: STEARNS, STANLEY F.: CLIN 3000 is for 6 months in the starting at the end of the 9th year and is automatically calculated by taking the last years value and dividing it in half and then multiplying inflation of 2.5% a year which by end of the 9th year calculates to 10.38%. inflation.

- 0$ 3,912,138ERROR:#DIV/0!100%

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 .