Draft Cost Model Workbook.xlsx

XLSX spreadsheet 300 KB Posted

Attached to
Army Training Models - DRAFT Solicitation
Solicitation number
W91CRB-26-R-A004
Issued by

About this file

This is a Draft Cost Model Workbook in Excel format designed as a template for offerors to submit cost and pricing proposals for the Army Training Models contract (Solicitation Number W91CRB-26-R-A004). The workbook provides a standardized structure for the Department of the Army to evaluate proposals based on FAR 15.404-1 cost realism and cost analysis criteria. The contract is a 5-year effort with four optional one-year periods and a 6-month extension under FAR 52.217-8, with a base period consisting of labor and Other Direct Costs (ODCs) including travel and training.

The workbook contains multiple integrated worksheets requiring offerors to populate: direct labor rates with cost realism justification, labor cost detail worksheets showing effort allocation between prime and subcontractors across 41 Full-Time Equivalents (FTEs) totaling 436,480 productive hours over the contract period, ODC cost detail with normalized travel and training costs of $25,000 per period ($12,500 for the 6-month extension), and indirect rate summary showing fringe, overhead, and G&A rates by contract period. Supporting documentation includes fringe benefit, overhead, and G&A worksheets with sample formats for historical and estimated expenses. The workbook automatically calculates total labor and ODC costs, ultimately projecting a total contract value of $137,500 based on ODC estimates alone, with labor rates to be populated by offerors. Proposed labor categories span multiple Army locations including the Pentagon (HQDA-DAMO-TR, DAMO-TRP), Fort Sill, Fort Moore, Fort Novosel, Fort Eisenhower, Fort Gregg-Adams, and Fort Eustis, requiring Secret security clearance. The template is mandatory for both prime offerors and major subcontractors performing 10 percent or more of contract hours.

View the file

Other files

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

Instructions

Instructions
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
Government Inputs
Solicitation Number:
Name of Action:Army Training Models
Period of Performance:5 years
Annual Productive Hours:1920
Offeror Inputs
Prime Contractor/Subcontractor Name/Division:

DRAFT

Section B

Section B - Supplies or Services Costs and/or Prices
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
(The format below is a sample. Propose in the actual format of the Section B contained in the solicitation)
BASE PERIOD
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
0001Base Period – Labor1Each$ - 0
FFP$ - 0From Cost Summary Worksheet
Estimated cost=$ - 0
Fixed Fee=$ - 0From Cost Summary Worksheet
Firm Fixed Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
0002Base Period –Travel/Training/ODCs1Each$ - 0
FFPEstimated cost=$ 25,000.00From ODC Cost Detail Worksheet
Burden/G&A =0.00%$ - 0From ODC Cost Detail Worksheet
Subtotal$ 25,000.00
OPTION PERIOD 1
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
1001Option Period 1 – Labor1Each$ - 0
FFP$ - 0From Cost Summary Worksheet
Estimated cost=$ - 0
Fixed Fee=$ - 0From Cost Summary Worksheet
Firm Fixed Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
1002Option Period 1- Travel/Training/ODCs1Each$ - 0
FFPEstimated cost=$ 25,000.00From ODC Cost Detail Worksheet
Burden/G&A =0.00%$ - 0From ODC Cost Detail Worksheet
Subtotal$ 25,000.00
OPTION PERIOD 2
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
2001Option Period 2 – Labor1Each$ - 0
FFP$ - 0From Cost Summary Worksheet
Estimated cost=$ - 0
Fixed Fee=$ - 0From Cost Summary Worksheet
Firm Fixed Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
2002Option Period 2 – Travel/Training/ODCs1Each$ - 0
FFPEstimated cost=$ 25,000.00From ODC Cost Detail Worksheet
Burden/G&A =0.00%$ - 0From ODC Cost Detail Worksheet
Subtotal$ 25,000.00
OPTION PERIOD 3
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
3001Option Period 3- Labor1Each$ - 0
FFP$ - 0From Cost Summary Worksheet
Estimated cost=$ - 0
Fixed Fee=$ - 0From Cost Summary Worksheet
Firm Fixed Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
3002Option Period 3- Travel/Training/ODCs1Each$ - 0
FFPEstimated cost=$ 25,000.00From ODC Cost Detail Worksheet
Burden/G&A =0.00%$ - 0From ODC Cost Detail Worksheet
Subtotal$ 25,000.00
OPTION PERIOD 4
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
4001Option Period 4 – Labor1Each$ - 0
FFP$ - 0From Cost Summary Worksheet
Estimated cost=$ - 0
Fixed Fee=$ - 0From Cost Summary Worksheet
Firm Fixed Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
4002Option Period 4 Travel/Training/ODCs1Each$ - 0
FFPEstimated cost=$ 25,000.00From ODC Cost Detail Worksheet
Burden/G&A =0.00%$ - 0From ODC Cost Detail Worksheet
Subtotal$ 25,000.00
FAR 52.217-8 Extension (6 Months)
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
50016 Month OES - Labor1Each$ - 0
FFP$ - 0From Cost Summary Worksheet
Estimated cost=$ - 0From Cost Summary Worksheet
Fixed Fee=$ - 0From Cost Summary Worksheet
Firm Fixed Price$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
50026 Month OES - Travel/Training/ODCs1Each$ - 0
FFPEstimated cost=$ 12,500.00From ODC Cost Detail Worksheet
Burden/G&A =0.00%$ - 0From ODC Cost Detail Worksheet
Subtotal$ 12,500.00
TOTAL
TOTAL
Estimated cost (FFP & COST) =$ 137,500.00
Fee =$ - 0
Total Price$ 137,500.00
Double check figure$ 137,500.00Total of clin totals
Double check figure$ 137,500.00Cost Summary Total
Double check figure$ 137,500.00Total from individual Worksheets

DRAFT

Cost Summary

Cost Summary Spreadsheet
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
Army Training ModelsBase PeriodOption 1Option 2Option 3Option 46 Month ExtensionTotal
Labor & Subcontract Labor Hours79,36079,36079,36079,36079,36039,680436,480From Labor Cost Detail Worksheet
Direct & Indirect Labor & Subcontract Labor Costs (less G&A)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Cost Detail Worksheet
G&A Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Cost Detail Worksheet
Direct & Indirect Labor & Subcontract Labor Costs (Less Fee)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Profit/Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Cost Detail Worksheet
Firm Fixed Labor Price$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs (ODCs) (Less Burden)$ 25,000.00$ 25,000.00$ 25,000.00$ 25,000.00$ 25,000.00$ 12,500.00$ 137,500.00From ODC Cost Detail Sheet
G&A Burden on ODCs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From ODC Cost Detail Sheet
ODCs$ 25,000.00$ 25,000.00$ 25,000.00$ 25,000.00$ 25,000.00$ 12,500.00$ 137,500.00
Total Labor & ODC Costs$ 25,000.00$ 25,000.00$ 25,000.00$ 25,000.00$ 25,000.00$ 12,500.00$ 137,500.00
Direct Labor$ - 0
Fringe$ - 0
Overhead$ - 0
Subcontracts
Labor Subtotal$ - 0
G&A$ - 0
Fee$ - 0
Firm Fixed Labor Price$ - 0
ODCs$ 137,500.00
ODC Burden$ - 0
Contract Total$ 137,500.00

DRAFT

Direct Labor Rate Schedule

Direct Labor Rate Schedule
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
Proposed RatesCLIN 0001: Base Period - 12 MonthsCLIN 1001: Option Period 1 (12 Months)CLIN 2001: Option Period 2 (12 Months)CLIN 3001: Option Period 3 (12 Months)CLIN 4001: Option Period 4 (12 Months)CLIN 5001: 6 Month Extension
Labor CategoriesLocationClearanceLabor TypeProposed Labor RateCost Realism Basis for Rate ProposedProposed Labor RateEscalationProposed Labor RateEscalationProposed Labor RateEscalationProposed Labor RateEscalationProposed Labor RateEscalationProposed Labor Rate
Government Site
Program Manager (Vendor's Location)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Task Leader (Vendor's location)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Functional Analyst (Vendor's location)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Analyst (Vendor's location)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Systems Analyst (Vendor's location)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Programmer Analyst (Vendor's location)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst (Pentagon, HQDA – DAMO-TR)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst (Pentagon, HQDA – DAMO-TR)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Analyst (Pentagon, HQDA – DAMO-TR)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst (Pentagon, HQDA – DAMO-TRP)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Senior Analyst (Pentagon, HQDA – DAMO-TRP)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Knowledge Manager (Pentagon, HQDA-DAMO-TR)Washington, DCSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst (Fort Sill, Oklahoma / Ft Leonard Wood, Missouri)Ft. Still, OKSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst (Maneuver CoE - Fort Moore, Georgia)Ft. Moore, GASecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst (Aviation CoE - Fort Novosel, Alabama)Ft. Novosel, ALSecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst (Cyber CoE - Fort Eisenhower, Georgia)Ft. Eisenhower, GASecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst (Fort Gregg-Adams, Virginia)Ft. Gregg-Adams, VASecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Analyst (HQ TRADOC, Fort Eustis, VA)Ft Eustis, VASecretProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Please enter all the corresponding labor categories proposed in the labor cost detail spreadhseets.

For cost realism purposes indicate the basis of the proposed rates and provide documentation to substantiate the rates, such as pay stubs, signed employee letters of intent, etc. If the rates are based on estimates please provide salary survey data and other data to corroborate the realism of the rates.

Please provide the basis of escalation.

Labor Cost Detail

Labor Cost Detail Spreadsheet
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
Annual Productive Hours: 1920
Direct CostIndirect Cost
CLIN 0001: Base Period - 12 Months0.00%0.00%0.00%0.00%
LocationLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTEs (Note 3)Productive Hrs./Yr. (Note 4)Total Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
Washington, DCProfessionalProgram Manager (Vendor's Location)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalTask Leader (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalFunctional Analyst (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Vendor's location)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSystems Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalProgrammer Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TRP)Enter P or S4.001,940.007,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TRP)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalKnowledge Manager (Pentagon, HQDA-DAMO-TR)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Still, OKProfessionalAnalyst (Fort Sill, Oklahoma / Ft Leonard Wood, Missouri)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Moore, GAProfessionalAnalyst (Maneuver CoE - Fort Moore, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Novosel, ALProfessionalAnalyst (Aviation CoE - Fort Novosel, Alabama)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Eisenhower, GAProfessionalAnalyst (Cyber CoE - Fort Eisenhower, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Gregg-Adams, VAProfessionalAnalyst (Fort Gregg-Adams, Virginia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft Eustis, VAProfessionalAnalyst (HQ TRADOC, Fort Eustis, VA)Enter P or S4.001,920.007,680.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4179,360$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,936$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 1001: Option Period 1 (12 Months)0.00%0.00%0.00%0.00%
LocationLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTEs (Note 3)Productive Hrs./Yr. (Note 4)Total Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
Washington, DCProfessionalProgram Manager (Vendor's Location)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalTask Leader (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalFunctional Analyst (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Vendor's location)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSystems Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalProgrammer Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TRP)Enter P or S4.001,940.007,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TRP)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalKnowledge Manager (Pentagon, HQDA-DAMO-TR)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Still, OKProfessionalAnalyst (Fort Sill, Oklahoma / Ft Leonard Wood, Missouri)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Moore, GAProfessionalAnalyst (Maneuver CoE - Fort Moore, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Novosel, ALProfessionalAnalyst (Aviation CoE - Fort Novosel, Alabama)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Eisenhower, GAProfessionalAnalyst (Cyber CoE - Fort Eisenhower, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Gregg-Adams, VAProfessionalAnalyst (Fort Gregg-Adams, Virginia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft Eustis, VAProfessionalAnalyst (HQ TRADOC, Fort Eustis, VA)Enter P or S4.001,920.007,680.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4179,360$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,936$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 2001: Option Period 2 (12 Months)0.00%0.00%0.00%0.00%
LocationLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTEs (Note 3)Productive Hrs./Yr. (Note 4)Total Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
1,600
Washington, DCProfessionalProgram Manager (Vendor's Location)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalTask Leader (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalFunctional Analyst (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Vendor's location)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSystems Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalProgrammer Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TRP)Enter P or S4.001,940.007,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TRP)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalKnowledge Manager (Pentagon, HQDA-DAMO-TR)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Still, OKProfessionalAnalyst (Fort Sill, Oklahoma / Ft Leonard Wood, Missouri)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Moore, GAProfessionalAnalyst (Maneuver CoE - Fort Moore, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Novosel, ALProfessionalAnalyst (Aviation CoE - Fort Novosel, Alabama)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Eisenhower, GAProfessionalAnalyst (Cyber CoE - Fort Eisenhower, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Gregg-Adams, VAProfessionalAnalyst (Fort Gregg-Adams, Virginia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft Eustis, VAProfessionalAnalyst (HQ TRADOC, Fort Eustis, VA)Enter P or S4.001,920.007,680.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4179,360$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,936$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 3001: Option Period 3 (12 Months)0.00%0.00%0.00%0.00%
LocationLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTEs (Note 3)Productive Hrs./Yr. (Note 4)Total Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
1,600
Washington, DCProfessionalProgram Manager (Vendor's Location)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalTask Leader (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalFunctional Analyst (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Vendor's location)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSystems Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalProgrammer Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TRP)Enter P or S4.001,940.007,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TRP)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalKnowledge Manager (Pentagon, HQDA-DAMO-TR)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Still, OKProfessionalAnalyst (Fort Sill, Oklahoma / Ft Leonard Wood, Missouri)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Moore, GAProfessionalAnalyst (Maneuver CoE - Fort Moore, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Novosel, ALProfessionalAnalyst (Aviation CoE - Fort Novosel, Alabama)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Eisenhower, GAProfessionalAnalyst (Cyber CoE - Fort Eisenhower, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Gregg-Adams, VAProfessionalAnalyst (Fort Gregg-Adams, Virginia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft Eustis, VAProfessionalAnalyst (HQ TRADOC, Fort Eustis, VA)Enter P or S4.001,920.007,680.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4179,360$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,936$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 4001: Option Period 4 (12 Months)0.00%0.00%0.00%0.00%
LocationLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTEs (Note 3)Productive Hrs./Yr. (Note 4)Total Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
Washington, DCProfessionalProgram Manager (Vendor's Location)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalTask Leader (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalFunctional Analyst (Vendor's location)Enter P or S5.001,940.009,700.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Vendor's location)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSystems Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalProgrammer Analyst (Vendor's location)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S2.001,940.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.001,940.005,820.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TRP)Enter P or S4.001,940.007,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TRP)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalKnowledge Manager (Pentagon, HQDA-DAMO-TR)Enter P or S1.001,940.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Still, OKProfessionalAnalyst (Fort Sill, Oklahoma / Ft Leonard Wood, Missouri)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Moore, GAProfessionalAnalyst (Maneuver CoE - Fort Moore, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Novosel, ALProfessionalAnalyst (Aviation CoE - Fort Novosel, Alabama)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Eisenhower, GAProfessionalAnalyst (Cyber CoE - Fort Eisenhower, Georgia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Gregg-Adams, VAProfessionalAnalyst (Fort Gregg-Adams, Virginia)Enter P or S1.001,920.001,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft Eustis, VAProfessionalAnalyst (HQ TRADOC, Fort Eustis, VA)Enter P or S4.001,920.007,680.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4179,360$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1,936$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct CostIndirect Cost
CLIN 5001: 6 Month Extension0.00%0.00%0.00%0.00%
LocationLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTEs (Note 3)Productive Hrs./Yr. (Note 4)Total Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total CostFeeTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdefghijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
960
Washington, DCProfessionalProgram Manager (Vendor's Location)Enter P or S1.00970.00970.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalTask Leader (Vendor's location)Enter P or S5.00970.004,850.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalFunctional Analyst (Vendor's location)Enter P or S5.00970.004,850.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Vendor's location)Enter P or S3.00970.002,910.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSystems Analyst (Vendor's location)Enter P or S2.00970.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalProgrammer Analyst (Vendor's location)Enter P or S2.00970.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.00970.002,910.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TR)Enter P or S2.00970.001,940.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TR)Enter P or S3.00970.002,910.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalAnalyst (Pentagon, HQDA – DAMO-TRP)Enter P or S4.00970.003,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalSenior Analyst (Pentagon, HQDA – DAMO-TRP)Enter P or S1.00970.00970.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Washington, DCProfessionalKnowledge Manager (Pentagon, HQDA-DAMO-TR)Enter P or S1.00970.00970.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Still, OKProfessionalAnalyst (Fort Sill, Oklahoma / Ft Leonard Wood, Missouri)Enter P or S1.00960.00960.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Moore, GAProfessionalAnalyst (Maneuver CoE - Fort Moore, Georgia)Enter P or S1.00960.00960.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Novosel, ALProfessionalAnalyst (Aviation CoE - Fort Novosel, Alabama)Enter P or S1.00960.00960.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Eisenhower, GAProfessionalAnalyst (Cyber CoE - Fort Eisenhower, Georgia)Enter P or S1.00960.00960.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft. Gregg-Adams, VAProfessionalAnalyst (Fort Gregg-Adams, Virginia)Enter P or S1.00960.00960.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Ft Eustis, VAProfessionalAnalyst (HQ TRADOC, Fort Eustis, VA)Enter P or S4.00960.003,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4139,680$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:968$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Total:436,480$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!

DRAFT

ODC Cost Detail

ODC Cost Detail Spreadsheet
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
CLINDescriptionODCs (Note 10)Burden/G&A RateG&ATotal ODC Cost
abcde = c x df = c + e
0002Base Period - Travel/Training/ODCs$ 25,000.00$ - 0$ 25,000.00
1002Option Period 1 - Travel$ 25,000.00$ - 0$ 25,000.00
2002Option Period 2 - Travel$ 25,000.00$ - 0$ 25,000.00
3002Option Period 3 - Travel$ 25,000.00$ - 0$ 25,000.00
4002Option Period 4 - Travel$ 25,000.00$ - 0$ 25,000.00
500252.217-8 OES - Travel$ 12,500.00$ - 0$ 12,500.00
Total$ 137,500.00$ - 0$ 137,500.00
(To Section B)

DRAFT

Indirect Rate Summary

Indirect Rate Summary Spreadsheet
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
EntityContract TypeFringe RateOverhead RateG&A RateProposed Fee Rate% of Effort Performed by Prime and Subs Based on Labor Hours
Base Period
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%
SUBCONTRACTOR 20.00%
SUBCONTRACTOR 30.00%
ETC0.00%
0.00%(i.e. 100%)
Option Year 1
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%
SUBCONTRACTOR 20.00%
SUBCONTRACTOR 30.00%
ETC0.00%
0.00%(i.e. 100%)
Option Year 2
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%
SUBCONTRACTOR 20.00%
SUBCONTRACTOR 30.00%
ETC0.00%
0.00%(i.e. 100%)
Option Year 3
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%
SUBCONTRACTOR 20.00%
SUBCONTRACTOR 30.00%
ETC0.00%
0.00%
Option Year 4
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%
SUBCONTRACTOR 20.00%
SUBCONTRACTOR 30.00%
ETC0.00%
0.00%
6 Month Extension (FAR 52.217-8)
PRIME CONTRACTORFFP0.00%
SUBCONTRACTOR 10.00%
SUBCONTRACTOR 20.00%
SUBCONTRACTOR 30.00%
ETC0.00%
0.00%

Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods.

Subcontractors may provide data separately in the above format for proprietary reasons.

Provide the necessary narrative describing how the rates were derived and applied, the composition of the allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports.

If rates proposed are based on other than actual rates, please state the reason(s).

Sample Fringe, Overhead, and G&A worksheet schedules follow this tab.

DRAFT

Fringe Benefit Worksheet

Fringe Benefit Worksheet
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
Weighted Average Fringe RateERROR:#DIV/0!
Total Fringe Expense$ - 0
Statutory Fringe Benefits:*Enter %**
FICA0.00%
FUTA0.00%
SUTA0.00%
Workman's Compensation0.00%
Etc - Enter Additional Categories As Needed0.00%
Fringe Benefits:*Fringe benefit offered to all professional employees? (Yes/No) (Explain, if no)Employer ShareEmployee Share, if applicableEnter %**Describe fringe benefit and enter any additional comments
Paid Leave/Vacation0%
Holidays0%
Sick Leave0%
Jury Duty0%
Military Leave0%
Bereavement Leave0%
Health Insurance0%
Health/Flexible Spending Account0%
Dental Insurance0%
Vision Insurance0%
Health Reimbursement0%
Disability Insurance Short & Term0%
Disability Insurance Long Term0%
Life insurance0%
401K or retirement plan0%
Profit sharing0%
Tuition Reimbursement0%
Etc - Enter Additional Categories As Needed0%

Paid Leave/Vacation (PTO, Sick, Military, etc.) Years of Experience Hours Alloted Per Year

*Please enter all the fringe benefit categories to be offered to professional FLSA exempt employees under this contract. Please complete this sheet for each fringe benefit pool if multiple pools exist.
**What % of the fringe benefit category contributes to the overall fringe benefit rate?

DRAFT

Fringe Worksheet

Fringe Rate Worksheet
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
Fringe Expenses:FY2023 ActualFY2024 ActualFY2025 ActualEstimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
Indirect payroll$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Vacation (PTO)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Holiday$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sick Leave$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Health/Disability Ins$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Workmans Compensation/Defense Base Act$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Bonuses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Retention Pay$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
401k Match$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mil Leave$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Breavement$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Insurance$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Cost
Entertainment, etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Net Allowable cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Overhead Worksheet

Overhead Rate Worksheet
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
Overhead Expenses:FY2023 ActualFY2024 ActualFY2025 ActualEstimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Cost
Entertainment, etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Net Allowable cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

G&A Worksheet

G&A Rate Worksheet
Solicitation Number:
Name of Action: Army Training Models
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 5 years
G&A Expenses:FY2023 ActualFY2024 ActualFY2025 ActualEstimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subscriptions$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Postage$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Printing$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Supplies$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Telephone$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Misc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Recruiting$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Maint$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Equip$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Consultants$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Prof fees$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Filings$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Legal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total G&A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Costs
Interest$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contributions$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Advertising, etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A Pool After Deducting Unallowable Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Allocation Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead (including any unallowable cost)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs (inclusing any unallowable cost)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total G&A Allocation Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Microsoft_Word_Document.docx General

Each offeror is to provide a cost/price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed workbook shall be part of the cost/price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any major subcontractors (performing 10% or more of hours) proposed to perform effort in response to this solicitation. The information will be evaluated for fairness, reasonableness, based on the cost/price analysis, and cost realism analysis (on cost CLINS) criteria in FAR 15.404-1.

Overall Instructions

1. The worksheets are designed to automatically compute and populate other cells in the Excel workbook.

2. The worksheet tabs shaded green have inputs required on that worksheet.

3. More detailed instructions follow number 9 below.

4. Type the appropriate name of the Prime Contractor/Subcontractor/Division in Cell H14 on the Instructions worksheet of the LOE Workbook. It will carry through the remaining worksheets.

5. Please enter the requested data in the green shaded areas on the Direct Labor Rate Schedule, which includes the proposed labor rates, the cost realism basis for the rate proposed and the escalation rate used. The direct rate information feeds into the Labor Cost Detail worksheet.

6. Please enter the requested data in the green shaded areas on the Labor Cost Detail worksheet, which includes which entity will be performing the work (columns D and E). Column L will only need inputs if the prime offeror is inputting a subcontractor’s fully burdened labor rate into that column.

7. Please enter the requested data in the green shaded areas on the ODC Cost Detail worksheet. For the purposes of proposal, the Government has input normalized values for the ODCs. These numbers are to be used. The offerors may add any burden and/or G&A as appropriate. Since these are estimated amounts that may or may not occur, no fixed fee will be allowed on the ODCs.

8. Please enter the requested data in the green shaded areas on the Indirect Rate Summary worksheet.

9. Please enter the requested data in the green shaded areas on the Fringe, Overhead, and G&A worksheets. These worksheets assist in calculating the indirect rates. This will enable the cost evaluation team to analyze the indirect costs. PLEASE NOTE: The rates at the bottom DO NOT carry over to the Indirect Rate Summary.

Section B Worksheet

The Section B worksheet imports data from the Cost Summary, Labor Cost Detail, and ODC Cost Detail worksheets and is used as a basis for the proposed formal Section B. Please note that there are three cells that may turn green. THESE ARE NOT INPUTS. It is a different shade of green and is only used as a check to ensure the final price on the Section B worksheet agrees with the summations pulled from the other worksheets.

Cost Summary Worksheet

This worksheet is for Government analysis purposes. It is populated from the Labor Cost Detail and ODC Cost Detail worksheets.

Direct Labor Rate Schedule Worksheet

Enter the requested data in the green shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes. For offerors supporting realism with salary survey data, Government required percentiles are pre-populated in column F. For offerors providing alternate realism support (such as payroll data), column F cells may be adjusted.

Labor Cost Detail Worksheet

Enter the requested data in the green shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for cost/price analysis and contract administration purposes. For specific instructions, see the Notes that follow.

NOTE 1: NOT USED.

NOTE 2: Column C of the Labor Cost Detail worksheet contains several labor categories. During contract performance these categories may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a ‘P’ in column D if the effort is to be performed by the prime contractor and a ‘S’ if performed by another division or subcontractor. Enter the name of the division or subcontractor in column E. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the FTEs in column F and the hours in columns G and H for the individual category in column C for the original and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours provided by the Government for the respective labor category.

NOTE 3: For the purposes of this solicitation, the hours worked under a FTE shall consist of the hours worked by an individual employee and not multiple employees (i.e. 1 FTE = 1 employee). One FTE shall not be split among two or more employees.

NOTE 4: Do not modify the productive hour amounts in this column. The productive hours in this column are estimated productive hours that may or may not be ordered by the Government during the contract and are based on a 1,920 hour work year per FTE. Productive hours are the total hours in a work year less any days not actually worked (i.e. not including holidays, sick days, vacations, etc). Productive hours are hours that will actually be worked and billed to the contract. For the purposes of this solicitation please assume a 40 hour work week NOT to include overtime or uncompensated overtime.

NOTE 5: The hourly base pay rate copies over from the Direct Labor Rate Schedule. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reason, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror. Escalation on wages in out years for Service Contract Act positions is unallowable except where the Collective Bargaining Agreement and/or Wage Determinations indicate otherwise.

NOTE 6a: Apply fringe to prime offeror derived rates. ‘Fringe Worksheet’ provides a sample to be used to compute the fringe rate. Provide a schedule and describe all elements included in the fringe benefit rate. Fringe shall include social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc). If the offeror's accounting system applies fringe and overhead together, use only one of the worksheets and clearly indicate this in the proposal. The rate will carry over from the Indirect Rate Summary.

NOTE 6b: Apply overhead to prime offeror derived rates. ‘Overhead Worksheet’ provides a sample to be used to compute the overhead rate. Provide a schedule and describe all elements included in the overhead rate.

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 .