Attachment 6_Cost Model Spreadsheet.xlsx

XLSX spreadsheet 54 KB Posted Nov 29, 2022

Attached to: The United States Army Security Assistance Command (USASAC) has a requirement for Repair and Return Services of non-standard military and commercial assets for the Army Security Assistance Enterprise (ASAE) Foreign Military Sales (FMS) customers.
Solicitation number: W91CRB-23-R-0003
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

Written by GovTribe AI · Dec 31, 2023

This document package includes a cost model spreadsheet and related federal contract opportunity solicitation for repair and return services. The cost model spreadsheet provides instructions for offerors to complete pricing details for sourcing and management services for repair of non-standard military and commercial assets for the Army Security Assistance Enterprise Foreign Military Sales customers. Offerors must provide labor categories, rates, and pricing for a five year period of performance. The related solicitation is from the U.S. Army Security Assistance Command and seeks proposals for the required repair and return services of FMS customer assets, including repairs, maintenance, modifications, overhauls, inspections, and engineering services. The opportunity is a negotiated procurement with an anticipated award date in 2023. Offerors should carefully review proposal submission requirements in Sections L and M of the solicitation.

View the file

Other files

File	Type	Posted
W91CRB-23-R-0003 Amendment 0003.pdf	PDF	Dec 23, 2022
W91CRB-23-R-0003-0002.pdf	PDF	Dec 16, 2022
W91CRB-23-R-0003-0001.pdf	PDF	Dec 1, 2022
Attachment 2 _ DD254_Updated.pdf	PDF	Dec 1, 2022
Attachment 4 - Small Business Participation Form.xlsx	XLSX spreadsheet	Nov 29, 2022
Attachment 3 _ Past Performance Evaluation Form.docx	DOCX document	Nov 29, 2022
Attachment 2 _ DD254.pdf	PDF	Nov 29, 2022
Attachment 1 - Quality Assurance Surveillance (QASP).docx	DOCX document	Nov 29, 2022
Exhibit A_CDRLs_ A001 - A019 (Combined).pdf	PDF	Nov 29, 2022
Solicitation W91CRB-23-R-0003.pdf	PDF	Nov 29, 2022
Attachment 5 - Purchase System Review.xlsx	XLSX spreadsheet	Nov 29, 2022

Show all 11

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions Instructions for completing the R&R Price Spreadsheet

1. There are nine tabs in this document. The offeror shall provide price information on each 'green' tab and each 'green' cell .

2. The formulas will calculate all total costs automatically. Do not enter information in any other columns or alter formulas in any way.

Tabs:

Section B - input proposed Sourcing & Managemet price per unit

Indirect Rate Summary - Offerors shall input current indirect rates. Supporting narrative shall be provided separately.

Sourcing & Management Detail - Offerors shall provide a proposed labor mix and breakout for each year, with totals mirroring the proposed per unit price proposed in Section B.

Fringe Benefit Worksheet - In accordance with FAR 52.222-46 offerors shall outline the fringe benefits/total compensation package provdided to employees.

Fringe, Overhead, G&A Worksheets - In the abssence of approved Forward Pricing Rate Agreements or current provisional billing rates, offerors shall provide 3 years of historical indirect rate data as well as projections for the life of this effort.

Rollup - Summary tab; Do NOT enter info on this tab.

Section B Cost Detail Worksheet

YEAR 1

	CLIN	Type	Estimated Number of Repairs	Total PER UNIT	TOTAL
Sourcing and Management Unit Cost	0001	FFP	1,292		$ - 0
Repair Cost	0002	Cost	1,292	$ 85,623,218.00	$ 85,623,218.00
					$ 85,623,218.00

YEAR 2

	CLIN	Type	Estimated Number of Repairs	Total PER UNIT	TOTAL
Sourcing and Management Unit Cost	1001	FFP	1,422		$ - 0
Repair Cost	1002	Cost	1,422	$ 101,035,397.24	$ 101,035,397.24
					$ 101,035,397.24

YEAR 3

	CLIN	Type	Estimated Number of Repairs	Total PER UNIT	TOTAL
Sourcing and Management Unit Cost	2001	FFP	1,563		$ - 0
Repair Cost	2002	Cost	1,563	$ 103,809,589.50	$ 103,809,589.50
					$ 103,809,589.50

YEAR 4

	CLIN	Type	Estimated Number of Repairs	Total PER UNIT	TOTAL
Sourcing and Management Unit Cost	3001	FFP	1,600		$ - 0
Repair Cost	3002	Cost	1,600	$ 102,563,088.11	$ 102,563,088.11
					$ 102,563,088.11

YEAR 5

	CLIN	Type	Estimated Number of Repairs	Total PER UNIT	TOTAL
Sourcing and Management Unit Cost	4001	FFP	1,890		$ - 0
Repair Cost	4002	Cost	1,890	$ 102,539,822.50	$ 102,539,822.50
					$ 102,539,822.50

Indirect Rate Summary

Indirect Rate Summary Spreadsheet

Solicitation Number:

Name of Action:

Prime Contractor/Subcontractor Name/Division:

Period of Performance:

Entity	Contract Type	Fringe Rate	Overhead Rate	G&A Rate	Proposed Fee Rate	% of Effort Performed by Prime and Subs Based on Labor Hours
Year 1
PRIME CONTRACTOR	FFP	0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%	(i.e. 100%)
Year 2
PRIME CONTRACTOR	FFP	0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%	(i.e. 100%)
Year 3
PRIME CONTRACTOR	FFP	0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%	(i.e. 100%)
Year 4
PRIME CONTRACTOR	FFP	0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%	(i.e. 100%)
Year 5
PRIME CONTRACTOR	FFP	0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 1		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 2		0.00%	0.00%	0.00%	0.00%	0.00%
SUBCONTRACTOR 3		0.00%	0.00%	0.00%	0.00%	0.00%
ETC		0.00%	0.00%	0.00%	0.00%	0.00%
						0.00%	(i.e. 100%)

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.

Sourcing & Mgmt Detail Labor Cost Detail Spreadsheet

Direct Labor

Indirect Cost

CLIN 0001: Year 1 Sourcing & Management

0.00%

Labor Categories

Effort To Be Performed By The Prime (P) or Subcontractor (S)

If Column D=S, Enter Name of Subcontractor(s)

FTEs

Total Productive Hours

Hourly Base Pay Rate

Fringe

Overhead

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A

Total Cost

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

i = f + g + h

j = e x i

l = j + k

n = l + m

o = n/e

p = o/f

Labor Cat 1 (example)	Enter P or S	1.00	2,087.00	$ 20.00	$ - 0	$ - 0	$ 20.00	$ 41,740.00	$ - 0	$ 41,740.00	$ - 0	$ 41,740.00	$ 20.00	0.00%
	Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		1.00	2,087.00	$ 41,740.00	$ - 0	$ - 0	$ 41,740.00	$ 41,740.00	$ - 0	$ 41,740.00	$ - 0	$ 41,740.00	$ 41,740.00
			2,087.00	$ 20.00	$ - 0	$ - 0	$ 20.00	$ 20.00	$ - 0	$ 20.00	$ - 0	$ 20.00	$ 20.00	0.00%

Direct Cost

Indirect Cost

CLIN 2001:Year 2 Sourcing & Management

0.00%

Labor Categories

Effort To Be Performed By The Prime (P) or Subcontractor (S)

If Column D=S, Enter Name of Subcontractor(s)

FTEs

Total Productive Hours

Hourly Base Pay Rate

Fringe

Overhead

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A

Total Cost

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

i = f + g + h

j = e x i

l = j + k

n = l + m

o = n/e

p = o/f

Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0.00	0.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!

Direct Cost

Indirect Cost

CLIN 3001: Year 3 Sourcing & Management

0.00%

Labor Categories

Effort To Be Performed By The Prime (P) or Subcontractor (S)

If Column D=S, Enter Name of Subcontractor(s)

FTEs

Total Productive Hours

Hourly Base Pay Rate

Fringe

Overhead

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A

Total Cost

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

i = f + g + h

j = e x i

l = j + k

n = l + m

o = n/e

p = o/f

Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0.00	0.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!

Direct Cost

Indirect Cost

CLIN 4001: Year 4 Sourcing & Management

0.00%

Labor Categories

Effort To Be Performed By The Prime (P) or Subcontractor (S)

If Column D=S, Enter Name of Subcontractor(s)

FTEs

Total Productive Hours

Hourly Base Pay Rate

Fringe

Overhead

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A

Total Cost

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

i = f + g + h

j = e x i

l = j + k

n = l + m

o = n/e

p = o/f

Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0.00	0.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!

Direct Cost

Indirect Cost

CLIN 5001: Year 5 Sourcing & Management

0.00%

Labor Categories

Effort To Be Performed By The Prime (P) or Subcontractor (S)

If Column D=S, Enter Name of Subcontractor(s)

FTEs

Total Productive Hours

Hourly Base Pay Rate

Fringe

Overhead

Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate)

Total Prime & Sub Labor Before Prime G&A & Fee

G&A

Total Cost

Profit

Total Price

Proposal Fully Burdened Hourly Billing Rate

Wrap Rate

i = f + g + h

j = e x i

l = j + k

n = l + m

o = n/e

p = o/f

Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Enter P or S				$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	0.00	0.00	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!

			2,087	$ 41,740.00	$ - 0	$ - 0	$ 41,740.00	$ 41,740.00	$ - 0	$ 41,740.00	$ - 0	$ 41,740.00	$ 41,740.00
				$ 20.00	$ - 0	$ - 0	$ 20.00	$ 20.00	$ - 0	$ 20.00	$ - 0	$ 20.00	$ 20.00	ERROR:#DIV/0!
	Sourcing/Mgmt Costs	Units	Price/Unit
Year 1	$ 41,740.00	1,292	$ 32.31
Year 2	$ - 0	1,422	$ - 0
Year 3	$ - 0	1,563	$ - 0
Year 4	$ - 0	1,600	$ - 0
Year 5	$ - 0	1,890	$ - 0

Fringe Benefit Worksheet

Fringe Benefit Worksheet
Weighted Average Fringe Rate:	0.00%
Total Fringe Expense:	$ - 0
Statutory Fringe Benefits:*	Enter %**
FICA	0.00%
FUTA	0.00%
SUTA	0.00%
Workman's Compensation	0.00%
Etc - Enter Additional Categories As Needed	0.00%
Fringe Benefits:*	Fringe benefit offered to all professional employees? (Yes/No) (Explain, if no)	Employer Share	Employee Share, if applicable	Enter %**	Describe fringe benefit and enter any additional comments
Paid Leave/Vacation				0%
Holidays				0%
Sick Leave				0%
Jury Duty				0%
Military Leave				0%
Bereavement Leave				0%
Health Insurance				0%
Health/Flexible Spending Account				0%
Dental Insurance				0%
Vision Insurance				0%
Health Reimbursement				0%
Disability Insurance Short & Term				0%
Disability Insurance Long Term				0%
Life insurance				0%
401K or retirement plan				0%
Profit sharing				0%
Tuition Reimbursement				0%
Etc - Enter Additional Categories As Needed				0%

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?

Fringe

Fringe Rate Worksheet
Fringe Expenses:	FY2016 Actual	FY2017 Actual	FY2019 Actual	FY2020 Actual	FY2021 Actual	Estimated Year 1	Estimated Year 2	Estimated Year 3	Estimated Year 4	Estimated Year 5
Indirect payroll	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Vacation (PTO)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Holiday	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Sick Leave	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Health/Disability Ins	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Workmans Compensation/Defense Base Act	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Bonuses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Retention Pay	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
401k Match	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Mil Leave	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Breavement	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Insurance	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Pool	$ - 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	$ - 0	$ - 0
Total Unallowable Costs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Net Allowable cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Labor Base
Direct Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
OH Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
B&P Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Labor Base	$ - 0	$ - 0	$ - 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! ERROR:#DIV/0! ERROR:#DIV/0!

Overhead

Overhead Rate Worksheet
Overhead Expenses:	FY2016 Actual	FY2017 Actual	FY2019 Actual	FY2020 Actual	FY2021 Actual	Estimated Year 1	Estimated Year 2	Estimated Year 3	Estimated Year 4	Estimated 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	$ - 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	$ - 0	$ - 0
Total Unallowable Costs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Net Allowable cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Labor Base
Direct Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
OH Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
B&P Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Labor Base	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

8 ERROR:#DIV/0! ERROR:#DIV/0! 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 G&A Rate Worksheet

G&A Expenses:	FY2016 Actual	FY2017 Actual	FY2019 Actual	FY2020 Actual	FY2021 Actual	Estimated Year 1	Estimated Year 2	Estimated Year 3	Estimated Year 4	Estimated Year 5
Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fringe	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Subscriptions	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Postage	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Printing	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Supplies	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Telephone	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Travel	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Misc	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Training	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Recruiting	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Maint	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equip	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Consultants	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Prof fees	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Filings	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Legal	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total G&A	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Less: FAR 31 Unallowable Costs
Interest	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Contributions	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Advertising, etc.	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Unallowable Costs	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
G&A Pool After Deducting Unallowable Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Allocation Base
Direct Labor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Fringe	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Overhead (including any unallowable cost)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Other Direct Costs (inclusing any unallowable cost)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total G&A Allocation Base	$ - 0	$ - 0	$ - 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! ERROR:#DIV/0! ERROR:#DIV/0!

ROLLUP

TOTAL CONTRACT COST
Total Year 1	$ 85,623,218.00
Total Year 2	$ 101,035,397.24
Total Year 3	$ 103,809,589.50
Total Year 4	$ 102,563,088.11
Total Year 5	$ 102,539,822.50

Total FFP	$ - 0	(TOTAL EVALUATED)
Total Cost	$ 495,571,115.35
Profit Year 1	$ - 0
Profit Year 2	$ - 0
Profit Year 3	$ - 0
Profit Year 4	$ - 0
Profit Year 5	$ - 0
	$ - 0

File details come from the government source that posted it. Updated Nov 29, 2022.