MPACS_RFP_Sec_J_Atch_14_Price_Model_Amend_14.xls

XLS spreadsheet 532 KB Posted

Attached to
Mission Planning and Analysis Common Services (MPACS) formerly Automated Quality Review and Analysis Software Support II (AQRASS II) & VAQRSS
Solicitation number
FA4600-11-R-0006_VAQRSS
Issued by

About this file

Attachment 14 revised Pricing model for Amendment 0014

View the file

Other files

File Type Posted
FA4600-14-D-0002.pdf PDF
20131114_Q A.docx DOCX document
20131003_Q A.docx DOCX document
FA4600-11-R-0006_A0021_SF30.doc DOC document
FA4600-11-R-0006_A0021_Conform_SF33.doc DOC document
20131002_Q A.docx DOCX document
20130930_Q A.docx DOCX document
20130927_Q A.docx DOCX document
20130926_Q A.docx DOCX document
Information_for_Offerors.docx DOCX document
FA4600-11-R-0006_A0020_Conform_SF33.doc DOC document
FA4600-11-R-0006_A0020_SF30.doc DOC document
FA4600-11-R-0006_A0019_Conform_SF33.docx DOCX document
FA4600-11-R-0006_A0019.docx DOCX document
MPACS_RFP_Sec_J_Atch_14_Price_Model_Amend0019.xlsx XLSX spreadsheet
FA4600-11-R-0006_A0018_Conform_SF33.docx DOCX document
FA4600-11-R-0006_Amendment_0018_SF30.docx DOCX document
FA4600-11-R-0006_Amendment_0017_SF30.docx DOCX document
FA4600-11-R-0006_A0016_Conform_SF33.docx DOCX document
FA4600-11-R-0006_A0016_SF30.doc DOC document
FA4600-11-R-0006_A0015_Conform_SF33.doc DOC document
MPACS_RFP_Sec_J_Atch_14_Price_Model_Amend0015.xls XLS spreadsheet
FA4600-11-R-0006_Amendment_0015_SF30.doc DOC document
FA4600-11-R-0006_A0014.doc DOC document
Q A.docx DOCX document
Amend_13_-_16May13.doc DOC document
FA4600-11-R-0006_Conform.pdf PDF
Assumption_Gov_Reply.xlsx XLSX spreadsheet
Amend_11.doc DOC document
Released_RFP_Questions.docx DOCX document
Conformed_Amend_11.doc DOC document
Amendment_10.doc DOC document
Conformed_Amendment_10.doc DOC document
Conformed_Amend_09.doc DOC document
11-R-0006_A009.doc DOC document
Amend 08.doc DOC document
Conformed Amend 08.doc DOC document
MPACS_Amend 06.doc DOC document
MPACS_Conformed Amend 06.doc DOC document
MPACS_Amendment 05 Conformed.doc DOC document
MPACS_Amendment 05.doc DOC document
MPACS_RFP_Sec_J_Atch_14_Price_Model_Amend 05.xls XLS spreadsheet
MPACS_Amend 04.doc DOC document
Sec_J_Atch_14_Price_Model _Amend_2(2).xls XLS spreadsheet
MPACS_Conformed Amend 3.doc DOC document
MPACS Amend 03.doc DOC document
FA4600-11-R-0006-Amend 2.doc DOC document
Q A Amend 2.doc DOC document
Sec J Atch 14_Price Model Amend 2.xls XLS spreadsheet
FA4600-11-R-0002 Amend 1Conformed.doc DOC document
Show 40 more

Latest 50 of 79 listed here. See the rest on GovTribe.

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-0006
MPACS Pricing Model, Ver. 4.0 Dated 03/15/11
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.Total includes $32,000 a year with a 3% escalation for total of $226,094. for ODC & Travel cost. The dollar figure includes all burdens.
11.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 0006 & CLIN 0010. 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 Base Yr Breakdown, TAB CLIN 0006 & CLIN 0010 Base 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 0006, & CLIN 0010 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.
Sec J, Atch 14

&L

Loading Factors

LOADING FACTORS MPACS
Prime Name:TEST
Subcontractor Name:Sub
6 Month
Extension
LOADING FACTORS:Base YearOpt 1Opt 2Opt 3Opt 4Opt 5
Labor Escalation0.00%0.00%0.00%0.00%N/A
CONTRACTOR SITE:
Fringe - Contractor Site0.00%0.00%0.00%0.00%0.00%10.00%
Overhead - Contractor Site0.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%
CLIENT (GOVERNMENT) SITE:
Fringe - Client (Government) Site0.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%
FCCoM - Client (Government) Site0.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%
IT (Computing)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%
If you pool FCCom as 1 pool: FCCoM, G&A0.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%
Material & Handeling (Burden on ODC &/or Subs)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%
Max Fee8.00%8.00%8.00%8.00%8.00%8.00%
Min Fee2.00%2.00%2.00%2.00%2.00%2.00%
Profit on Sub Labor (Only Prime fills this in)10.00%0.00%0.00%0.00%0.00%0.00%
Profit5.00%0.00%0.00%0.00%0.00%0.00%
Annual salary is divided by 1920 for direct labor*192019201920192019201920
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:TEST
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
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):

&LRFP FA4600-11-R-0006

&RSec J, Atch 14

CLIN X001

Prime Name:TEST
Sub Name:Sub
CLIN X001 Maintenance & Sustainment: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 TOTALS =0.000$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:OPTION 1
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 1 TOTALS =0.000$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:OPTION 2
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 2 TOTALS =0.000$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:OPTION 3
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 3 TOTALS =0.000$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:OPTION 4
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 TOTALS =0.000$ - 0$ - 0
CLIN X001 Maintenance & Sustainment:6 MONTH EXTENSION NO ESCALATION
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
6 MONTH EXTENSION TOTALS =0.000$ - 0$ - 0
FTEs
BASE & ALL 4 OPTIONS + Ext TOTAL =0.000$ - 0$ - 0
Sec J, Atch 14

&LRFP FA4600-11-R-0006

CLIN 0001 Base Yr Breakdown

Prime Name:TEST
Sub Name:Sub
CLIN 0001 Maintenance & Sustainment BREAKDOWNBASE PERIOD ONLY
(See details in comment boxes)TECHNICALPMO
Contractor SiteSystem EngineeringData BaseDetailed DesignCodeUnit TestCode ReviewsDefect WorkoffOtherInformation AssuranceData/CDRLSConfig Mgt/Data MgtQuality AssuranceProduct IntegrationContractor Dev Test & EvalGovt Dev Test & EvalSystem TestTrainingProg Mgmt / Proj ControlAdminSub ContratractsSecurityContractsChief ArchitectChief Engineer / Task LeadFinancial ManagementProcessing EngineeringSystem AdministrationTOTAL
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 =0.00
NOTE: Each Labor Category hour totals in column AC shall equal the total hours in the "CLIN 0001" Tab

&LRFP FA4600-11-R-0006

&RSec J, Atch 14 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.

Stanley.Stearns:

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

Stanley.Stearns:

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

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.

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.

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.

Stanley.Stearns:

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

Stanley.Stearns:

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

Tasks include the processes, procedures and reviews that allow developed software access to the STRATCOM environment.

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).

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.

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.

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.

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.

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.

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.

Stanley.Stearns:

Task includes the development and updating of training materials for initial/intermediate/and advanced users.

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.

Stanley.Stearns:

Provides necessary support to organize and facilitate overall program technical and support efforts.

Stanley.Stearns:

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

Stanley.Stearns:

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

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.

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.

Stanley.Stearns: Task ensures adherence to the contractor software development life cycles and engineering processes.

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.

Stanley.Stearns:

Responsible for the setup and maintenance of GFE computer systems. Tasks also includes the tracking of GFE computer equipment.

Stanley.Stearns:

Tasks ensures the design, maintenance, and operation of the software development process is effective and efficient.

CLIN 0006

Prime Name:TEST
Sub Name:Sub
CLIN 0006 Pre-Priced Option TaskCONTRACTOR Site 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 Site0.000$ - 0$ - 0

&LRFP FA4600-11-R-0006

&RSec J, Atch 14

CLIN 0006 Base Yr Breakdown

Prime Name:TEST
Sub Name:Sub
CLIN 0006 Pre-Priced Option Task BREAKDOWNBASE PERIOD ONLY
(See details in comment boxes)TECHNICALPMO
Contractor SiteSystem EngineeringData BaseDetailed DesignCodeUnit TestCode ReviewsDefect WorkoffOtherInformation AssuranceData/CDRLSConfig Mgt/Data MgtQuality AssuranceProduct IntegrationContractor Dev Test & EvalGovt Dev Test & EvalSystem TestTrainingProg Mgmt / Proj ControlAdminSub ContratractsSecurityContractsChief ArchitectChief Engineer / Task LeadFinancial ManagementProcessing EngineeringSystem AdministrationTOTAL
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 =0.00
NOTE: Each Labor Category hour totals in column AC shall equal the total hours in the "CLIN 0006" Tab

&LRFP FA4600-11-R-0006

&RSec J, Atch 14 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.

Stanley.Stearns:

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

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.

Stanley.Stearns:

SubTotal for the following functional categories: Unit Test, Code Reviews, and Defect Workoff 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.

Stanley.Stearns:

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

Stanley.Stearns:

Tasks include the processes, procedures and reviews that allow developed software access to the STRATCOM environment.

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).

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.

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.

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.

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.

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.

Stanley.Stearns:

Responsible for the setup and maintenance of GFE computer systems. Tasks also includes the tracking of GFE computer equipment.

Stanley.Stearns:

Tasks ensures the design, maintenance, and operation of the software development process is effective and efficient.

Stanley.Stearns:

Task includes the development and updating of training materials for initial/intermediate/and advanced users.

Stanley.Stearns: Task ensures adherence to the contractor software development life cycles and engineering processes.

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.

Stanley.Stearns:

Provides necessary support to organize and facilitate overall program technical and support efforts.

Stanley.Stearns:

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

Stanley.Stearns:

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

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.

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.

Stanley.Stearns:

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

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.

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.

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.

CLINs X007, X009 FFP

Prime Name:TEST
Sub Name:Sub
CLINs X007 & X009 LABOR HOUR & COST BREAKDOWN
CLIN: X007 (FFP)CLIN 0007 - BASE PERIODCLIN 1007-Option Period1CLIN 2007-Option Period2CLIN 3007-Option Period3CLIN 4007-Option Period46 Month
On-Site SupportBase YearOption 1Option 2Option 3Option 4Extension
Labor Category Contractor SiteHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCost
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.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.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00
Subtotal with FTE CLIN X00700$ - 000$ - 000$ - 000$ - 000$ - 000$ - 0
Cumulative Subtotal with FTE CLIN X00700$ - 000$ - 000$ - 000$ - 000$ - 0
CLIN: X009 (FFP)CLIN 0009 - BASE PERIOD
Transition Phase InBase Year
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 X00900$ - 0
Cumulative Subtotal with FTE CLIN X009

&LRFP FA4600-11-R-0006

&RSec J, Atch 14

CLIN 0010

Prime Name:TEST
Sub Name:Sub
CLIN X010 Pre-Priced Option TaskCONTRACTOR Site 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 Site0.000$ - 0$ - 0

CLIN 0010 Base Yr Breakdown

Prime Name:TEST
Sub Name:Sub
CLIN 0010 Pre-Priced Option Task BREAKDOWNBASE PERIOD ONLY
(See details in comment boxes)TECHNICALPMO
Contractor SiteSystem EngineeringData BaseDetailed DesignCodeUnit TestCode ReviewsDefect WorkoffOtherInformation AssuranceData/CDRLSConfig Mgt/Data MgtQuality AssuranceProduct IntegrationContractor Dev Test & EvalGovt Dev Test & EvalSystem TestTrainingProg Mgmt / Proj ControlAdminSub ContratractsSecurityContractsChief ArchitectChief Engineer / Task LeadFinancial ManagementProcessing EngineeringSystem AdministrationTOTAL
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 =0.00
NOTE: Each Labor Category hour totals in column AC shall equal the total hours in the "CLIN 0010" Tab

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.

Stanley.Stearns:

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

Stanley.Stearns:

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

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.

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.

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.

Stanley.Stearns:

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

Stanley.Stearns:

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

Tasks include the processes, procedures and reviews that allow developed software access to the STRATCOM environment.

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).

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.

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.

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.

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.

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.

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.

Stanley.Stearns:

Task includes the development and updating of training materials for initial/intermediate/and advanced users.

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.

Stanley.Stearns:

Provides necessary support to organize and facilitate overall program technical and support efforts.

Stanley.Stearns:

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

Stanley.Stearns:

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

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.

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.

Stanley.Stearns: Task ensures adherence to the contractor software development life cycles and engineering processes.

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.

Stanley.Stearns:

Responsible for the setup and maintenance of GFE computer systems. Tasks also includes the tracking of GFE computer equipment.

Stanley.Stearns:

Tasks ensures the design, maintenance, and operation of the software development process is effective and efficient.

SUB Labor Prime Fills in

PRIME NAME:TEST
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)CLIN 0001 - BASE PERIODCLIN 1001-Option Period1CLIN 2001-Option Period2CLIN 3001-Option Period3CLIN 4001-Option Period46 Month
Maintenance & SustainmentBase YearOption 1Option 2Option 3Option 4Extension
Labor CategoryHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCostHoursRateCost
00.000.0000.000.0000.000.0000.000.0000.000.0000.000.00

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 .