Attachment J.2(L3) SA3 Cost Template.xlsx

XLSX spreadsheet 192 KB Posted

Attached to
Safety & Mission Assurance, Audits, Assessments and Analysis (SA3) Services
Solicitation number
80GRC022R0029
Issued by

View the file

Other files

Show all 17

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

1 Total Tasks + IDIQ

TOTAL OF COST ELEMENTS

Base PeriodOption period
Cost ElementsYear 1Year 2Year 3Year 4Year 56 Month ExtensionTotal
Direct Labor$ -
Fringe$ -
Overhead$ -
Other Direct Costs$ -
Subcontractor Costs$ -
Material Handling$ -
G&A$ -
Facilities Capital Cost of Money$ -
Fixed Fee$ -
Total Estimated Cost Plus Fixed Fee$ -$ -$ -$ -$ -$ -$ -
IDIQ LABOR OVERHEAD RATES PROPOSED
BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 5
IDIQ MATERIAL HANDLING RATES PROPOSED
BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 5
IDIQ G&A RATES PROPOSED
BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 5
IDIQ FIXED FEE RATES PROPOSED
BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 5

2 Costs Total Cost Template

COST PLUS FIXED FEE

BASE PERIODOPTION PERIOD
ElementsYear 1Year 2Year 3Year 4Year 56 Month ExtensionTotal
Direct Labor Hours
Straightime Hours------
Overtime Hours------
Total Hours-------

Direct Labor Dollars from Labor Template $ - $ - $ - $ - $ - $ -

Overhead (List) Cost
1. (Name & Description of Base)$ -$ -$ -$ -$ -$ -
Overhead Rate0.00%0.00%0.00%0.00%0.00%0.00%
Overhead Cost$ -$ -$ -$ -$ -$ -$ -
2. (Name & Description of Base)$ -$ -$ -$ -$ -$ -
Overhead Rate0.00%0.00%0.00%0.00%0.00%0.00%
Overhead Cost$ -$ -$ -$ -$ -$ -$ -
Total Overhead Cost$ -$ -$ -$ -$ -$ -$ -
Other Direct Costs (ODCs)
1. (ODC Description)$ -$ -$ -$ -$ -$ -$ -
2. (ODC Description)$ -$ -$ -$ -$ -$ -$ -
3. (ODC Description)$ -$ -$ -$ -$ -$ -$ -
Total Other Direct Costs$ -$ -$ -$ -$ -$ -$ -
Subcontractor Costs
1. (Subcontractor Name)$ -$ -$ -$ -$ -$ -$ -
2. (Subcontractor Name)$ -$ -$ -$ -$ -$ -$ -
3. (Subcontractor Name)$ -$ -$ -$ -$ -$ -$ -
Total Subcontract Cost$ -$ -$ -$ -$ -$ -$ -
Material Handling (Pass through costs)
1. (Description of Material Handling Base)$ -$ -$ -$ -$ -$ -
M&H Rate0.00%0.00%0.00%0.00%0.00%0.00%
M&H Cost$ -$ -$ -$ -$ -$ -$ -
G&A Cost
1. (Description of G&A Base)$ -$ -$ -$ -$ -$ -
G&A Rate0.00%0.00%0.00%0.00%0.00%0.00%
G&A Cost$ -$ -$ -$ -$ -$ -$ -

Subtotal $ - $ - $ - $ - $ - $ - $ -

Facilities Capital Cost of Money (FCCOM)
1. (Description of FCCOM Base)$ -$ -$ -$ -$ -$ -
FCCOM Rate0.00%0.00%0.00%0.00%0.00%0.00%
FCCOM Cost$ -$ -$ -$ -$ -$ -$ -
Fixed Fee
1. Subcontractor$ -$ -$ -$ -$ -$ -
Fixed Fee Rate0.00%0.00%0.00%0.00%0.00%0.00%
Fixed Fee Amount$ -$ -$ -$ -$ -$ -$ -
2. (Description of Fee Base) less Subcontractor$ -$ -$ -$ -$ -$ -
Fixed Fee Rate0.00%0.00%0.00%0.00%0.00%0.00%
Fixed Fee Amount$ -$ -$ -$ -$ -$ -$ -
Total Fixed Fee Amount$ -$ -$ -$ -$ -$ -$ -

Total Estimated Cost Plus Fixed Fee $ - $ - $ - $ - $ - $ - $ -

3 Labor Labor Template

CONTRACT YEAR: ONE
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: TWO
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: THREE
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: FOUR
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: FIVE
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: SIX MONTH EXTENSION
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00

4 Sample Task 1 Sample Task 1: Surveilance Support

Elements

Labor CategoryHours
Administrator
Auditor Level 2
Contracts Admin
Finance
Engineer 2
Engineer 3
IT Spec 3
Lead Auditor
Operations Manager
Program Manager
Tech Writer
Tech Inspector 2
Quality Analyst 2
Total- 0
Other Direct Costs (ODCs)Dollars
1. (ODC Description)$ -
2. (ODC Description)$ -
3. (ODC Description)$ -
Total Other Direct Costs$ -

5 Sample Task 2 Sample Task 2: Audit Support

Elements Hours

Labor Category
Administrator
Auditor Level 2
Contracts Admin
Finance
Engineer 2
Engineer 3
IT Spec 3
Lead Auditor
Operations Manager
Program Manager
Tech Writer
Tech Inspector 2
Quality Analyst 2
Total- 0
Other Direct Costs (ODCs)
1. (ODC Description)$ -
2. (ODC Description)$ -
3. (ODC Description)$ -
Total Other Direct Costs$ -

6a Indirect Rate

INDIRECT RATE TEMPLATE
A current DCAA Forward Pricing Rate Agreement may be provided in lieu of completing this template for the resepctive rates.
Duplicate Template for each Indirect Rate proposed
Company Name:_____________________________[ ] Prime[ ] Major Subcontractor
Indirect Rate Name:_____________________________
Application Base:_____________________________
Fiscal Year Begins:_____________________________
Fiscal Year Ends:_____________________________
ContractorContractorContractorContractorContractorContractorContractorContractor
Cost Elements withinFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
Indirect Rate PoolPrior Yr 3Prior Yr 2Prior Yr 1_____________________________________________
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
Total Pool Expenses$ -$ -$ -$ -$ -
Application Base ($)$ -$ -$ -$ -$ -
Contractor FY Rate (%)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
CONVERSION OF BURDEN RATE TO CONTRACT YEARContractContractContractContractContract
Year 1Year 2Year 3Year 4Year 5
Proposed Contract Year Rate0.00%0.00%0.00%0.00%0.00%

6b Indirect Rate

INDIRECT RATE TEMPLATE
A current DCAA Forward Pricing Rate Agreement may be provided in lieu of completing this template for the resepctive rates.
Duplicate Template for each Indirect Rate proposed
Company Name:_____________________________[ ] Prime[ ] Major Subcontractor
Indirect Rate Name:_____________________________
Application Base:_____________________________
Fiscal Year Begins:_____________________________
Fiscal Year Ends:_____________________________
ContractorContractorContractorContractorContractorContractorContractorContractor
Cost Elements withinFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
Indirect Rate PoolPrior Yr 3Prior Yr 2Prior Yr 1_____________________________________________
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
Total Pool Expenses$ -$ -$ -$ -$ -
Application Base ($)$ -$ -$ -$ -$ -
Contractor FY Rate (%)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
CONVERSION OF BURDEN RATE TO CONTRACT YEARContractContractContractContractContract
Year 1Year 2Year 3Year 4Year 5
Proposed Contract Year Rate0.00%0.00%0.00%0.00%0.00%

6c Indirect Rate

INDIRECT RATE TEMPLATE
A current DCAA Forward Pricing Rate Agreement may be provided in lieu of completing this template for the resepctive rates.
Duplicate Template for each Indirect Rate proposed
Company Name:_____________________________[ ] Prime[ ] Major Subcontractor
Indirect Rate Name:_____________________________
Application Base:_____________________________
Fiscal Year Begins:_____________________________
Fiscal Year Ends:_____________________________
ContractorContractorContractorContractorContractorContractorContractorContractor
Cost Elements withinFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
Indirect Rate PoolPrior Yr 3Prior Yr 2Prior Yr 1_____________________________________________
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -
Total Pool Expenses$ -$ -$ -$ -$ -
Application Base ($)$ -$ -$ -$ -$ -
Contractor FY Rate (%)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
CONVERSION OF BURDEN RATE TO CONTRACT YEARContractContractContractContractContract
Year 1Year 2Year 3Year 4Year 5
Proposed Contract Year Rate0.00%0.00%0.00%0.00%0.00%

7 Total Staffing

TOTAL STAFFING TEMPLATE (INCLUDES SUBCONTRACTOR LABOR)

BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 5
Offeror or Subcontractor NameLabor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsWYEsWYEsWYEsWYEs
TOTAL STAFFING
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
0.000.000.000.000.00
TOTAL:0.000.000.000.000.00

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