Atch_14_Pricing_Model_Rev6_16Jul13_(2).xlsm

XLSM spreadsheet 174 KB Posted

Attached to
NIDS III Amendment
Solicitation number
FA4600-11-R-0012
Issued by

About this file

NIDS III Atch 14 Pricing Model v6 for Amend A017

View the file

Other files

File Type Posted
Amend_A018.doc DOC document
Atch_14_Pricing_Model_Rev_7_17Jul13.xlsm XLSM spreadsheet
conformed_as_of_A018.doc DOC document
Amend_A017.doc DOC document

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

PRCE MODEL DIRECTIONS FOR
RFP FA4600-11-R-0012
NIDS III Pricing Model, Ver. 5.0 Dated 04/16/13
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 Facilities Capital Cost of Money (FCCoM), is incorporated 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). Overtime for labor category rates is 1.5 times the straight time rate.
7.The Government will rely on Offerors to tell us in the TAB "Loading Factors" what their annual Full Time Equivalent (FTE) is per year.
8.Fixed Fee is not applied to ODCs Travel and Materials.
9.Client site refers to work done at Government locations.
10.Per PWS Section 6 the government furnishes the equipment and maintenance at any offsite location in the local area.
Directions for PRIME:(ONLY FILL IN AREAS HIGHLIGHTED IN YELLOW)
1.Primes should delete TABs SUB Labor Prime Fills in, Grand Total, and CPIF SHAREs before sending to their Subcontractors.
2.Primes shall manually fill in TAB SUB Labor Prime Fills in, for their Subs the labor category, hours, rate and type of contract (use dropdown menu).
3Primes will bid ODC Travel & Material/Equipment costs at the Dollar amount provided. The total amount for all years is $53,091. Includes all burdens.
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 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 TAB CLIN X001 & CLIN X006. Once you input the Labor Categories, direct rates, and hours the remaining TAB columns and rows will automatically fill in.
4.The labor rates will automatically be adjusted based on Offerors inputs in the Loading Factors TAB.
5.Complete TAB CLIN 0001 Option Yr Breakdown and TAB CLIN 006 Option Yr Breakdown. These tabs have descriptions in the column headings
comment boxes and further breakdown each major labor category into hours of specific tasks listed in this tab. All hours totals for each major labor
category and the grand total of hours will equal to the total hours on the corresponding CLIN TAB(s).
6.Per PWS Section 6. "All equipment and maintenance is furnished."
7.Complete TAB Benefit Summary for the employee compensation plan. Completion of this TAB is mandatory and staisfies the
requirement for the 52.222-46 clause for Employee Compensation Plan. No additional information is required, but supplementary data may be provided.
8.Shall have no more than two rounding places. We understand minor rounding errors. (Amounts in TAB Grand Total will be to the nearest whole dollar.)
9.If applicable provide your proprietary statement in the footer of each TAB.
`10.Subcontractors that have a cost plus arrangement with the prime must submit a cost proposal if they have a Basis Of Estimate of 10% or more of the
Prime contractors total proposed cost. (If you have Subs that will be submitting a cost proposal, ensure they have an approved accounting system.)
Directions for SUBs:
1Subcontractors must submit to 55th Contracting the following TABs Loading Factors, CLIN X001, CLIN X006, CLIN 0001 & 0006 Base Yr
Breakdown, CLINs X007 X009 FFP, and Benefit Summary.
(Only if Subs have a Basis Of Estimate of 10% or more of the Primes total proposed cost)
2Subcontractors must submit to their PRIMES their fully burden rates by Labor Category and hours for all CLINs so that the PRIMES can fill in the
TAB called SUB Labor Prime Fills in.
Helpful Hints and Reminders:(Please keep in mind that we had to create this cost model with more labor categories rows than will most likely be needed)
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.
Pricing Model Checklist
√Have the following been completed?
Subs were sent the Pricing Model with these nine TABs: Directions, Loading Factors, all the CLIN Tabs, Sub ODC, & Benefit Summary
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 cognizant DCAA and DCMA representatives in the Loading Factors TAB.
If rates/categories differ from the model, the differences are explained at the bottom of the Loading Factors TAB.
Base year direct rates and hours are entered into TABS CLIN X001, CLIN X006 and loaded in your hours and rates for TAB CLINs X007 X009 FFP.
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 manually input Subcontractor names and amounts in the Grand Total TAB for their associated ODC costs if any.
If applicable, supporting information for labor, indriect rates and or ODCs are provided in your Cost Volume Narrative. (Example: FCCoM DD Form 1861)
Supporting information for labor and indirect rates is provided in your Cost Volume narrative.
Ensure the Target, Adj, Final Cost in TAB CPIF SHAREs agrees with what you intended to submit for a Total Final Price for CLINS X001 & X006.
Benefits Summary TAB completed.

FA4600-11-R-0009, Section J, Attachment, TAB Directions

Loading Factors

Annual salary is divided by 2080 for direct labor*
Prime Name:
Subcontractor Name:
BaseOption 1Option 2Option 3Option 4Option 5
LOADING FACTORS:TransitionYearYear 1Year2Year3Year4Year5
Labor Escalation0.00%0.00%0.00%0.00%0.00%N/A
CONTRACTOR SITE:
Fringe - Contractor Site0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Overhead - Contractor Site0.00%0.00%0.00%0.00%0.00%0.00%0.00%
FCCoM - Contractor Site0.00%0.00%0.00%0.00%0.00%0.00%0.00%
CLIENT (GOVERNMENT) SITE:
Fringe - Client (Government) Site0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Overhead-Client (Government) Site0.00%0.00%0.00%0.00%0.00%0.00%0.00%
FCCoM - Client (Government) Site0.00%0.00%0.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%0.00%0.00%
IT (Computing)0.00%0.00%0.00%0.00%0.00%0.00%0.00%
If you pool FCCom as 1 pool: FCCoM, Direct Labor0.00%0.00%0.00%0.00%0.00%0.00%0.00%
If you pool FCCom as 1 pool: FCCoM, G&A0.00%0.00%0.00%0.00%0.00%0.00%0.00%
General and Administrative (G&A) Rate0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Material & Handeling (Burden on ODC &/or Subs)0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Target Fee6.50%6.50%6.50%6.50%6.50%6.50%6.50%
Max Fee8.00%8.00%8.00%8.00%8.00%8.00%8.00%
Min Fee2.00%2.00%2.00%2.00%2.00%2.00%2.00%
Profit on Sub Labor (Only Prime fills this in)0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Profit0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Annual salary is divided by 2080 for direct labor*2080208020802080208020802080
Wrap Rate W/O fee Contractor Site (Auto calculated)-------
Wrap Rate W/O fee Client Site (Auto calculated)-------
*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?
If Cost Plus agreement with Sub(s) do they have a DCAA deemed adequate accting sys.
Identify your company's Full Time Equivalent (FTE) hours.0
Subcontractor identify the type of contract you have with the Prime?Drop Down Menu
DCAA, DCMA & CHANGES TO PRICE MODEL
Prime Name:0
Subcontractor Name:0
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

DCAA, DCMA & CHANGES TO PRICE MODEL, Cont.

Defense Contract Management Agency (DCMA) Cognizant office:
Name & or Location:
Address:
Phone Number & Fax NumberPhone:Fax:
E-mail:

CHANGES TO PRICING MODEL (ie.. Additional approved DCAA Loading Rates):

FA4600-11-R-0012, Section J, Attachment 14, TAB Loading Factors

CLIN X001

Prime Name:0
Sub Name:0
CLIN X001 Maintenance & Sustainment:
Contractor SiteDirectFringeOHB & PITG & AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
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
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
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
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
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 TOTAL0$ - 0$ - 0
Client (Goverment) SiteDirectFringeOHB & PITG&AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Govt.) Site TOTAL0$ - 0$ - 0
FTEs
TOTALS =ERROR:#DIV/0!0$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:Base Year FY14
Contractor SiteDirectFringeOHB & PITG & AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
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
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
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
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
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 TOTAL0$ - 0$ - 0
Client (Government) SiteDirectFringeOHB & PITG&AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Govt.) Site TOTAL0$ - 0$ - 0
FTEs
Base Year TOTALS =ERROR:#DIV/0!0$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:OPTION 1, YEAR 1 FY15
Contractor SiteDirectFringeOHB & PITG & AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
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
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
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
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
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 TOTAL0$ - 0$ - 0
Client (Govt) SiteDirectFringeOHB & PITG&AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Govt.) Site TOTAL0$ - 0$ - 0
FTEs
OPTION 1, Year 1 TOTALS =ERROR:#DIV/0!0$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:OPTION 2, YEAR 2 FY16
Contractor SiteDirectFringeOHB & PITG & AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
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
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
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
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
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 TOTAL0$ - 0$ - 0
Client (Government) SiteDirectFringeOHB & PITG&AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Govt.) Site TOTAL0$ - 0$ - 0
FTEs
OPTION 2, Year 2 TOTALS =ERROR:#DIV/0!0$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:OPTION 3, YEAR 3 FY17
Contractor SiteDirectFringeOHB & PITG & AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
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
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
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
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
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 TOTAL0$ - 0$ - 0
Client (Govt) SiteDirectFringeOHB & PITG&AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Govt.) Site TOTAL0$ - 0$ - 0
FTEs
OPTION 3, Year 3 TOTALS =ERROR:#DIV/0!0$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:OPTION 4, YEAR 4 FY18
Contractor SiteDirectFringeOHB & PITG & AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
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
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
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
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
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 TOTAL0$ - 0$ - 0
Client (Govt) SiteDirectFringeOHB & PITG&AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Govt.) Site TOTAL0$ - 0$ - 0
FTEs
OPTION 4, Year 4 TOTALS =ERROR:#DIV/0!0$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:OPTION 5, YEAR 5 FY19
Contractor SiteDirectFringeOHB & PITG & AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
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
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
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
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
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 TOTAL0$ - 0$ - 0
Client (Govt) SiteDirectFringeOHB & PITG&AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Govt.) Site TOTAL0$ - 0$ - 0
FTEs
OPTION 5, Year 5 TOTALS =ERROR:#DIV/0!0$ - 0$ - 0
FTEs
BASE & ALL 5 OPTIONS + Ext TOTAL =ERROR:#DIV/0!0$ - 0$ - 0

&12FA4600-11-R-0012 Section J, Attachment, TAB CLIN X001

&"Times New Roman,Regular" &"Times New Roman,Regular"&P / &N

NOT USED

CLIN 0001 Opt 1 Breakdown

Prime Name:0
Sub Name:0
CLIN 0001 Maintenance & Sustainment BREAKDOWNBASE PERIOD
(See details in comment boxes)TECHNICALPMO
Contractor SiteSystem Engineering

Stanley.Stearns: Stanley.Stearns:

Tasks include requirement analysis, operational concept development, system analysis and modeling, preliminary design, and inspection of requirements and operational concepts. Additionally, the task includes Internal Software Requirements Reviews and Software Requirements Review. Data Base Stanley.Stearns: Stanley.Stearns:

Tasks include database design, database performance tuning, database administration, and a understanding of the implementation language and environment.

Detailed Design Stanley.Stearns: Stanley.Stearns:

Design of specific software components and patterns within the context of the established software Architecture Based Design artifacts and architectural guidelines. Code Stanley.Stearns: Stanley.Stearns:

Develop the operational source code to include the input and/or output of a programming language conversion process, such as machine code, object code, and source code. Unit Test Stanley.Stearns: Stanley.Stearns:

Task includes the testing of individual units of source code to determine if they fit for use. A unit is the smallest testable part of an application. Code Reviews Stanley.Stearns: Stanley.Stearns:

Review of the code and unit test outputs to validate operational suitability and determine action Items. All new and modified code as well as modified generated code is to be reviewed. Code review is not necessary for unmodified generated code. Defect Workoff Stanley.Stearns: Stanley.Stearns:

Corrects the defects that are found in the coding process after unit test and code reviews. Other Stanley.Stearns: Stanley.Stearns:

SubTotal for the following functional categories: Unit Test, Code Reviews, and Defect Workoff Information Assurance Stanley.Stearns: Stanley.Stearns:

Tasks include the processes, procedures and reviews that allow developed software access to the STRATCOM environment. Data/CDRLS Stanley.Stearns: Stanley.Stearns:

Development, production, and delivery efforts required to provide CDRL Data Items in accordance with contract instructions. Examples include: Software Delivery – Delivery of raw source code tape that accounts for changes as a result of the delivery; Program Management Plan; Risk Management Plan; and Integrated Master Schedule (IMS). Config Mgt/Data Mgt Stanley.Stearns: Stanley.Stearns:

Creates and maintains the data/equipment repositories and processes to accomplish configuration auditing, and manage the program baseline. Tracks and maintains the technical baseline for each software delivery. Quality Assurance Stanley.Stearns: Stanley.Stearns:

Tasks include processes necessary to determine the adequacy of the developed source code and the products/services meet technical requirements/system performance specifications. Product Integration Stanley.Stearns: Stanley.Stearns:

Tasks include integration of newly developed software with existing software. System integration involves integrating existing (often disparate) subsystems with new software. The subsystems will have interfaces. Integration involves joining the subsystems together. Contractor Dev Test & Eval Stanley.Stearns: Stanley.Stearns:

Contractor testing of soon to be delivered software according to the contractor test plan with a focus on updated software. Verifies the status of technical progress, minimizes design risks, validates achievement of contract technical performance, and determines the readiness of developed software for Government operational testing. Normally includes some tasks for correction of defects found. Govt Dev Test & Eval Stanley.Stearns: Stanley.Stearns:

Tasks include the contractor activities to support government acceptance testing of delivered software according to test plan criteria. Normally includes some tasks for correction of defects found. System Test Stanley.Stearns: Stanley.Stearns:

SubTotal for the following functional categories: Contractor Development Test & Evaluation and Government Development Test & Evaluation.

Testing conducted on a complete, integrated system to evaluate the system's compliance with its specified requirement. Tasks include the time to create the test plans. Training Stanley.Stearns: Stanley.Stearns:

Task includes the development and updating of training materials for initial/intermediate/and advanced users. Prog Mgmt / Proj Control Stanley.Stearns: Stanley.Stearns:

Responsible for controlling overall project technical effort and budget within schedule and resources. PM normally provides appropriate cost and progress/performance reporting to the customer. Admin Stanley.Stearns: Stanley.Stearns:

Provides necessary support to organize and facilitate overall program technical and support efforts. Sub Contratracts Stanley.Stearns: Stanley.Stearns:

Task ensures that subcontracts are properly solicited, negotiated, and administered according to government regulations and prime contract requirements. Security Stanley.Stearns: Stanley.Stearns:

Task include ensuring the adequacy of contractor security processes and procedures that provide support for personnel security clearances and all facility access. Contracts Stanley.Stearns: Stanley.Stearns:

Primary role is to ensure the adequacy of changes to existing contracts to meet the contract requirements and allow for successful technical and financial performance. Administers the contract to ensure compliance with all contract provisions, laws, regulations and corporate policies. Chief Architect Stanley.Stearns: Stanley.Stearns:

Tasked with providing the technical guidance to the software development activities in the areas of Architecture, Design, Implementation and Product/System Integration, including prototypes and/or trade studies in these areas.Chief Engineer / Task Lead
Stanley.Stearns: Stanley.Stearns: Task ensures adherence to the contractor software development life cycles and engineering processes.Financial Management

Stanley.Stearns: Stanley.Stearns:

Tasked with the responsibility for providing business related oversight of financial management efforts. Provides guidance on cost, billing, financial management, and coordination of outside reviews. Processing Engineering Stanley.Stearns: Stanley.Stearns:

Responsible for the setup and maintenance of GFE computer systems. Tasks also includes the tracking of GFE computer equipment. System Administration Stanley.Stearns: Stanley.Stearns:

Tasks ensures the design, maintenance, and operation of the software development process is effective and efficient.TOTAL
Labor CategoryHOURS
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
Contractor Site TOTAL0000000000000000000000000000
TECH TOTAL0PMO TOTAL0
Client (Goverment) SiteTOTAL
Labor CategoryHOURS
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
Client (Govt.) Site TOTAL0000000000000000000000000000
TECH TOTAL0PMO TOTAL0GRAND
GRAND TECH TOTAL0GRAND PMO TOTAL0TOTAL Hrs
0
FTEs
BASE PERIOD FTEs TOTALS =ERROR:#DIV/0!
NOTE: Each Labor Category hour totals in column AC shall equal the total hours in the "CLIN 0001" Tab

FA4600-11-R-0009, Section J, Attachment 14, TAB CLIN 0001 Base Yr Breakdown

CLIN X006

Prime Name:0
Sub Name:0
CLIN X006 Pre-Priced Option TaskCONTRACTOR BASE PERIOD
Contractor SiteDirectFringeOHB & PITG & AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
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
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
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
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
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 TOTAL0$ - 0$ - 0
Client (Goverment) SiteDirectFringeOHB & PITG&AFCCoMFCCoMFCCoMTOTALTOTALTOTAL
Labor CategoryRateCostCostCostCostCostCCDLG&ARATEHOURSW/Out FCCoMWith FCCoM
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
0.000.000.000.000.000.000.000.000.000.000$ - 0$ - 0
Client (Govt.) Site TOTAL0$ - 0$ - 0
FTEs
BASE PERIOD, CUMULATIVE TOTAL of Contractor Site & Govt SiteERROR:#DIV/0!0$ - 0$ - 0

FA4600-11-R-0012, Section J, Attachment 14, TAB CLIN X006

CLIN 0006 Opt 1 Breakdown

Prime Name:0
Sub Name:0
CLIN 0006 Pre-Priced Option Task BREAKDOWNBASE PERIOD
(See details in comment boxes)TECHNICALPMO
Contractor SiteSystem Engineering

Stanley.Stearns: Stanley.Stearns:

Tasks include requirement analysis, operational concept development, system analysis and modeling, preliminary design, and inspection of requirements and operational concepts. Additionally, the task includes Internal Software Requirements Reviews and Software Requirements Review. Data Base Stanley.Stearns: Stanley.Stearns:

Tasks include database design, database performance tuning, database administration, and a understanding of the implementation language and environment.

Detailed Design Stanley.Stearns: Stanley.Stearns:

Design of specific software components and patterns within the context of the established software Architecture Based Design artifacts and architectural guidelines. Code Stanley.Stearns: Stanley.Stearns:

Develop the operational source code to include the input and/or output of a programming language conversion process, such as machine code, object code, and source code. Unit Test Stanley.Stearns: Stanley.Stearns:

Task includes the testing of individual units of source code to determine if they fit for use. A unit is the smallest testable part of an application. Code Reviews Stanley.Stearns: Stanley.Stearns:

Review of the code and unit test outputs to validate operational suitability and determine action Items. All new and modified code as well as modified generated code is to be reviewed. Code review is not necessary for unmodified generated code. Defect Workoff Stanley.Stearns: Stanley.Stearns:

Corrects the defects that are found in the coding process after unit test and code reviews. Other Stanley.Stearns: Stanley.Stearns:

SubTotal for the following functional categories: Unit Test, Code Reviews, and Defect Workoff Information Assurance Stanley.Stearns: Stanley.Stearns:

Tasks include the processes, procedures and reviews that allow developed software access to the STRATCOM environment. Data/CDRLS Stanley.Stearns: Stanley.Stearns:

Development, production, and delivery efforts required to provide CDRL Data Items in accordance with contract instructions. Examples include: Software Delivery – Delivery of raw source code tape that accounts for changes as a result of the delivery; Program Management Plan; Risk Management Plan; and Integrated Master Schedule (IMS). Config Mgt/Data Mgt Stanley.Stearns: Stanley.Stearns:

Creates and maintains the data/equipment repositories and processes to accomplish configuration auditing, and manage the program baseline. Tracks and maintains the technical baseline for each software delivery. Quality Assurance Stanley.Stearns: Stanley.Stearns:

Tasks include processes necessary to determine the adequacy of the developed source code and the products/services meet technical requirements/system performance specifications. Product Integration Stanley.Stearns: Stanley.Stearns:

Tasks include integration of newly developed software with existing software. System integration involves integrating existing (often disparate) subsystems with new software. The subsystems will have interfaces. Integration involves joining the subsystems together. Contractor Dev Test & Eval Stanley.Stearns: Stanley.Stearns:

Contractor testing of soon to be delivered software according to the contractor test plan with a focus on updated software. Verifies the status of technical progress, minimizes design risks, validates achievement of contract technical performance, and determines the readiness of developed software for Government operational testing. Normally includes some tasks for correction of defects found. Govt Dev Test & Eval Stanley.Stearns: Stanley.Stearns:

Tasks include the contractor activities to support government acceptance testing of delivered software according to test plan criteria. Normally includes some tasks for correction of defects found. System Test Stanley.Stearns: Stanley.Stearns:

SubTotal for the following functional categories: Contractor Development Test & Evaluation and Government Development Test & Evaluation.

Testing conducted on a complete, integrated system to evaluate the system's compliance with its specified requirement. Tasks include the time to create the test plans. Training Stanley.Stearns: Stanley.Stearns:

Task includes the development and updating of training materials for initial/intermediate/and advanced users. Prog Mgmt / Proj Control Stanley.Stearns: Stanley.Stearns:

Responsible for controlling overall project technical effort and budget within schedule and resources. PM normally provides appropriate cost and progress/performance reporting to the customer. Admin Stanley.Stearns: Stanley.Stearns:

Provides necessary support to organize and facilitate overall program technical and support efforts. Sub Contratracts Stanley.Stearns: Stanley.Stearns:

Task ensures that subcontracts are properly solicited, negotiated, and administered according to government regulations and prime contract requirements. Security Stanley.Stearns: Stanley.Stearns:

Task include ensuring the adequacy of contractor security processes and procedures that provide support for personnel security clearances and all facility access. Contracts Stanley.Stearns: Stanley.Stearns:

Primary role is to ensure the adequacy of changes to existing contracts to meet the contract requirements and allow for successful technical and financial performance. Administers the contract to ensure compliance with all contract provisions, laws, regulations and corporate policies. Chief Architect Stanley.Stearns: Stanley.Stearns:

Tasked with providing the technical guidance to the software development activities in the areas of Architecture, Design, Implementation and Product/System Integration, including prototypes and/or trade studies in these areas.Chief Engineer / Task Lead
Stanley.Stearns: Stanley.Stearns: Task ensures adherence to the contractor software development life cycles and engineering processes.Financial Management

Stanley.Stearns: Stanley.Stearns:

Tasked with the responsibility for providing business related oversight of financial management efforts. Provides guidance on cost, billing, financial management, and coordination of outside reviews. Processing Engineering Stanley.Stearns: Stanley.Stearns:

Responsible for the setup and maintenance of GFE computer systems. Tasks also includes the tracking of GFE computer equipment. System Administration Stanley.Stearns: Stanley.Stearns:

Tasks ensures the design, maintenance, and operation of the software development process is effective and efficient.TOTAL
Labor CategoryHOURS
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
Contractor Site TOTAL0000000000000000000000000000
TECH TOTAL0PMO TOTAL0
Client (Goverment) SiteTOTAL
Labor CategoryHOURS
0000000000000000000000000000
0000000000000000000000000000
0000000000000000000000000000
Client (Govt.) Site TOTAL0000000000000000000000000000
TECH TOTAL0PMO TOTAL0GRAND
GRAND TECH TOTAL0GRAND PMO TOTAL0TOTAL Hrs
0
FTEs
BASE PERIOD, FTEs TOTALS =ERROR:#DIV/0!
NOTE: Each Labor Category hour totals in column AC shall equal the total hours in the "CLIN 0006" Tab

FA4600-11-R-0012, Section J, Atachment 14, TAB CLIN X006 Opt Pd Yr Breakdown

CLINs X007, X009 FFP

Prime Name:0
Sub Name:0
CLINs X007 & X009 LABOR HOUR & COST BREAKDOWN
CLIN: X007 (FFP)NOT USEDCLIN X007-BASE YEARCLIN 1007-Option Period1CLIN2007-Option Period2CLIN 3007-Option Period3CLIN 4007-Option Period4CLIN 5007-Option Period5
On-Site SupportBASE YEAROption 1, Year 1Option 2, Year 2Option 3, Year 3Option 4, Year 4Option 5, Year 5
Labor Category Contractor SiteHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCost
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Labor Category Client (Govt) Site
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Subtotal with FTE CLIN X0070ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 0
Cumulative Subtotal with FTE CLIN X0070ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 0
CLIN: X009 (FFP)CLIN 0009 - Transition
Transition Phase In
Labor Category Contractor SiteHoursRateCost
00.000.00
00.000.00
00.000.00
00.000.00
00.000.00
00.000.00
00.000.00
00.000.00
00.000.00
00.000.00
00.000.00
00.000.00
Labor Category Client (Govt) Site
00.000.00
00.000.00
00.000.00
Subtotal with FTE CLIN X0090ERROR:#DIV/0!$ - 0
Cumulative Subtotal with FTE CLIN X009

&"Times New Roman,Bold"&12FA4600-10-R-0012, Section J, Attachment 14, TAB CLINs X007 & X009

&"Times New Roman,Bold"&14

&A

&"Times New Roman,Regular"&P / &N

SUB Labor Prime Fills in

PRIME NAME:0
FILLED IN BY PRIMELABOR HOUR & COST BREAKDOWN BY SUB
NOTE: Primes will fill this Tab out. You can add rows to the spreadsheet or delete them. However,IDENTIFY THE TYPE OF CONTRACT THE PRIME HAS WITH EACH SUBCONTRACTOR
don't delete any Sub Totals or total rows. The subs will fill out tabs "CLIN X001", "CLIN X006", &Subcontractor NameType of Contract with Prime
& "CLINs X007, X009 FFP" just like the Prime will. The subs will send their tabs to the Prime (WithoutInput 1st Sub Name hereDrop Down Menu
their burdens) and the Primes will utilize those tabs to fill in this tab. Primes fill in the LaborInput 2nd Sub Name hereDrop Down Menu
Categories, hours and rates. Start with the 1st labor category for the 1st Sub you have so on for each Sub.Input 3rd Sub Name hereDrop Down Menu
The tab "Grand Total" will include the burdens that the Prime listed in the "Loading Factors" tab.Input 4th Sub Name hereDrop Down Menu
CLIN: X001 (CPIF)NOT USEDCLIN 0001 - BASE PERIODCLIN 1001-Option Period1CLIN 2001-Option Period2CLIN 3001-Option Period3CLIN 4001-Option Period4CLIN 5001-Option Period5
Maintenance & SustainmentOption 1, Year 1Option 2, Year 2Option 3, Year 3Option 4, Year 4Option 5, Year 5
Labor CategoryHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCost
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Input 1st Sub Name here0$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Input 2nd Sub Name here0$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Input 3rd Sub Name here0$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Input 4th Sub Name here0$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0
Subtotal with FTE CLIN X0010ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 0
Cumulative total w/FTE CLIN X0010ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 0
CLIN: X006 (CPIF)CLIN 0006
Pre-Priced Option Task
Labor CategoryHoursRateCost
00.000.00
00.000.00
00.000.00
00.000.00
Input 1st Sub Name here0$ - 0
00.000.00
00.000.00
00.000.00
00.000.00
Input 2nd Sub Name here0$ - 0
00.000.00
00.000.00
00.000.00
00.000.00
Input 3rd Sub Name here0$ - 0
00.000.00
00.000.00
00.000.00
00.000.00
Input 4th Sub Name here0$ - 0
Subtotal with FTE CLIN X0060ERROR:#DIV/0!$ - 0
Cumulative total w/FTE CLIN X006
CLIN: X007 (FFP)NOT USEDCLIN 0007 - BASE PERIODCLIN 1007-Option Period1CLIN 2007-Option Period2CLIN 3007-Option Period3CLIN 4007-Option Period4CLIN 5007-Option Period5
On-Site SupportBase Year 1Option 1, Year 1Option 2, Year 2Option 3, Year 3Option 4, Year 4Option 5, Year 5
Labor CategoryHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCost
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Input 1st Sub Name here0$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Input 2nd Sub Name here0$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Input 3rd Sub Name here0$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0
00.000.0000.000.0000.000.0000.000.00000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Input 4th Sub Name here0$ - 00$ - 00$ - 00$ - 00$ - 00$ - 00$ - 0
Subtotal with FTE CLIN X0070ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 0
Cumulative total w/FTE CLIN X0070ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 00ERROR:#DIV/0!$ - 0
CLIN: X009 (FFP)CLIN 0009 - Transition
Phase-In TransitionTransition
Labor CategoryHoursRateCost
00.000.00
00.000.00
00.000.00
00.000.00
00.000.00
Input 1st Sub Name here0$ - 0
00.000.00
00.000.00
00.000.00
00.000.00
Input 2nd Sub Name here0$ - 0
00.000.00
00.000.00
00.000.00
00.000.00
Input 3rd Sub Name here0$ - 0
00.000.00
00.000.00
00.000.00
Input 4th Sub Name here0$ - 0
Subtotal with FTE CLIN X0090ERROR:#DIV/0!$ - 0
Cumulative total w/FTE CLIN X009

&"Times New Roman,Bold"&12FA4600-11-R-0012, Section J, Attachment 14, TAB Sub Labor Prime Fills in

&"Times New Roman,Regular"&P / &N

Grand Total

Prime Name:NIDS III
Base YearOPTION 1OPTION 2OPTION 3OPTION 4OPTION 5
Note: All Cost figures are rounded to nearest dollar.FY14 1 Oct 13 - 30 Sep 14Year 1 FY15 1 Oct 14 - 30 Sep 15Year 2 FY16 1 Oct 15 - 30 Sep 16Year 3 FY17 1 Oct 16 - 30 Sep 17Year 4 FY18 1 Oct 17 - 30 Sep 18Year 5 FY19 1 Oct 18 - 31 Mar 19TOTALPercentage
HoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCostHoursCost
CLIN X001 Maint & SustainNot Used
Prime Labor Hours & Cost- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 1st Sub Name here- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 2nd Sub Name here- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 3rd Sub Name here- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Input 4th Sub Name here- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0ERROR:#DIV/0!ERROR:#DIV/0!
Subcontractor TOTAL CLIN X001- 0$ - 0- 0$ - 0- 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%$ - 00.00%$ - 00.00%$ - 0$ - 0ERROR:#DIV/0!

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 .