DASS_RFP_Attachment_5_Excel_Pricing_Model_(EPM)_P00005.xlsx

XLSX spreadsheet 77 KB Posted Apr 2, 2020

Attached to: Dual Administrative Support Services (DASS)
Solicitation number: 80SSC020R0007
Issued by: National Aeronautics and Space Administration Stennis Space Center

View the file

Other files

File	Type	Posted
80SSC020R0007P00006 - SF30.PDF	PDF	Apr 7, 2020
DASS_RFP_Attachment_4.12_Fully_Burdened_Rates_IDIQ_Pricing_Table_P00006.xlsx	XLSX spreadsheet	Apr 7, 2020
80SSC020R0007_DASS_RFP_Amend_P00005.pdf	PDF	Apr 2, 2020
80SSC020R0007P00005 - SF30.pdf	PDF	Apr 2, 2020
80SSC020R0007P00004-SF30.pdf	PDF	Mar 30, 2020
DASS_RFP_Attachemnt_4.17_Historical_Pricing_Data_P00004.pdf	PDF	Mar 30, 2020
80SSC020R0007_P00003 - SF30.pdf	PDF	Mar 27, 2020
DASS_RFP_Attachment_4.8_SLC_Job_Description_Guidelines_P00003.pdf	PDF	Mar 27, 2020
DASS_RFP_Attachment_4.17_Historical_Pricing_Data_P00003.pdf	PDF	Mar 27, 2020
80SSC020R0007_P00003_DASS_Questions_and_Answers(123-292).pdf	PDF	Mar 27, 2020
DASS_RFP_Attachment_4.1_SOW_P00003.pdf	PDF	Mar 27, 2020
DASS_RFP_Attachment_5_Excel_Pricing_Model_(EPM)_P00003.xlsx	XLSX spreadsheet	Mar 27, 2020
80SSC020R0007_DASS_RFP_P00003.pdf	PDF	Mar 27, 2020
DASS_RFP_Attachment_4.4_DRD_1_Safety_and_Health_Plan_P00003.pdf	PDF	Mar 27, 2020
80SSC020R0007P00002 - SF30.pdf	PDF	Mar 18, 2020
DASS_Preproposal_Conference_P00001_Attachemnt.pptx	PPTX presentation	Mar 13, 2020
80SSC020R0007P00001_DASS_RFP.pdf	PDF	Mar 13, 2020
80SSC020R0007P00001_DASS_SF30.PDF	PDF	Mar 13, 2020
DASS_RFP_Attachment_5_Excel_Pricing_Model_(EPM)_P00001.xlsx	XLSX spreadsheet	Mar 13, 2020
DASS_RFP_Attachment_4.4_DRD_8_Phase-in-Plan_P00001.pdf	PDF	Mar 13, 2020
DASS PPC Sign-in Sheet_P00001_Attachment.pdf	PDF	Mar 13, 2020
DASS_RFP_Questions_AND_Answers_P00001_(1-122).pdf	PDF	Mar 13, 2020
DASS_RFP_Attachment_5_EPM-Instructions_P0001.pdf	PDF	Mar 13, 2020
DASS_RFP_Attachment_4.3_DRL.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.9_Glossary.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.1_SOW.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_5_Consent_Letter.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_5_MATRIX.docx	DOCX document	Feb 18, 2020
DASS_RFP_Attachment_4.7_WD_15-5447_Rev_9.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_5_Excel_Pricing_Model_(EPM).xlsx	XLSX spreadsheet	Feb 18, 2020
DASS_RFP_Attachment_5_EPM-Instructions.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.4_DRD_2_DASS_How-to-Resource-Guide.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.17_Historical_Pricing_Data.pdf	PDF	Feb 18, 2020
80SSC020R0007 DASS RFP.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.8_SLC_Job_Description_Guidelines.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.4_DRD_4_DASS_Monthly_Management_Report.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.11_PIV.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.4_DRD_5_Task_Order_Staffing_Summary.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.6_WD_15-5233_Rev_14.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.4_DRD_3_DASS_OCI_Plan.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.4_DRD_7_Reprocurement_Data_Package.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.4_DRD_6_Wage_Salary_and_Fringe_Benefit_Data.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.4_DRD_9_IT_Security_Management.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.5_WD_15-5147_Rev_10.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.16_Reference_Documents.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_5_PPQ.docx	DOCX document	Feb 18, 2020
DASS_RFP_Attachment_4.2_Performance_Requirements_Summary.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.4_DRD_1_Safety_and_Health_Plan.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.4_DRD_8_Phase-in-Plan.pdf	PDF	Feb 18, 2020
DASS_RFP_Attachment_4.10_Installation_Accountable_Government_Property.pdf	PDF	Feb 18, 2020

Show 40 more

50 files 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

Try for free Login

Text version

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

FBR

FULLY BURDENED RATES (FBR) TEMPLATE

Identify Whether the Company is a:

[ ] Prime Offeror

[ ] Major Subcontractor

Contract Year 1 FBR Development

Prime Offeror Completes the area below this green row

Major Subcontractors complete the area below this red row

Subcontract Price Input Area (inputted here by prime)

NASA

% Incumbents

Direct Labor

Overhead

G&A

Composite

Composite Overtime

Offeror's Labor Category

NASA Standard Labor Category (SLC)

Retained

% usage

Rate

Cost

Rate

Cost

FCCOM

Profit (sub only)

Other

Prime or Major Subcontractor FBR per hr

Subcontractor "A" FBR/hr *

Subcontractor "B" FBR/hr *

Subcontractor "C" FBR/hr *

Prime Burdens Rate Percent **

Subcontractor "A" FBR + Prime Burdened Rate/hr

Subcontractor "B" FBR + Prime Burdened Rate/hr

Subcontractor "C" FBR + Prime Burdened Rate/hr

% Usage Prime

% Usage Subcontractor "A"

% Usage Subcontractor "B"

% Usage Subcontractor "C"

Prime & Sub FBR /hr

Prime's Profit Rate

Prime & Sub FBR /hr ***

Prime & Sub FBR /hr

Example:

Secretary Junior

75%

28.75

MAJOR SUBCONTRACTOR STOPS HERE & PROVIDES FBR TO PRIME

- 0

Secretary Intern

25%

25.25

- 0

JSC Secretary I

90%

100%

27.88

75%

20.91

2.93

- 0

51.71

59.50

55.00

61.00

$ 63.07

$ 58.30

$ 64.66

70%

Author: Author:

The total percentage usage for the prime offeror and all subcontractors for each SLC shall equal 100%. 20% Author: Author:

The total percentage usage for the prime offeror and all subcontractors for each SLC shall equal 100%. 5% Author: Author:

The total percentage usage for the prime offeror and all subcontractors for each SLC shall equal 100%. 54.96 Author: Author:

This is an example of a Prime Offeror's FBR Template. For a subcontractor, entries into this template would have ended in column M. 8% 59.35 89.03

Program Manager

Supervisor

Training Specialist

SSC Secretary I

SSC Secretary II

SSC Secretary III

SSC Administrative Assistant

SSC Administrative Assistant I

SSC Administrative Assistant II

JSC Secretary I

JSC Secretary II

JSC Secretary III

JSC Administrative Assistant

JSC Administrative Assistant I

JSC Administrative Assistant II

JSC Administrative Assistant III

WSTF Secretary I

WSTF Secretary II

WSTF Secretary III

WSTF Administrative Assistant

WSTF Administrative Assistant I

WSTF Administrative Assistant II

Other

* These columns represent the proposed major and minor subcontractor(s) fully burdened rates (FBR) by SLC. Identify subcontractors by name in the template.

** The Prime contractor may apply a burden rate to the major and minor subcontractor(s) FBR if applicable.

*** This column represents the composite FBR for the prime offeror and all its proposed subcontractor(s) by SLC. These composite FBRs shall match the FBRs in Section 1 of the contract. IMPORTANT: If subcontractors are proposed, include a formula in this column showing the calculation of the composite rates.

NOTE: PLEASE REMEMBER TO REMOVE EXAMPLE FORMULAS FROM TEMPLATES

Contract Year 2 FBR Development

Escalation Rate

3.46%

Note: Escalation should only be applied to exempt/non-FLA/SCA/CBA positions.

Prime Completes the area below this green row

Major Subcontractor completes the area below this red row

Subcontract Price Input Area (inputted here by prime)

NASA

% Incumbents

Direct Labor

Overhead

G&A

Composite

Composite Overtime

Offeror's Labor Category

NASA Standard Labor Category (SLC)

At Current DL Rates

% usage

Rate

Cost

Rate

Cost

FCCOM

Fee (sub only)

Other

Prime or Major Subcontractor FBR per hr

Subcontractor "A" FBR/hr *

Subcontractor "B" FBR/hr *

Subcontractor "C" FBR/hr *

Prime Burdens Rate /hr **

Subcontractor "A" FBR + Prime Burdened Rate/hr

Subcontractor "B" FBR + Prime Burdened Rate/hr

Subcontractor "C" FBR + Prime Burdened Rate/hr

% Usage Prime

% Usage Subcontractor "A"

% Usage Subcontractor "B"

% Usage Subcontractor "C"

Prime & Sub FBR /hr

Prime's Profit Rate

Prime & Sub FBR /hr ***

Example:

IT Staff IV

75%

29.74

MAJOR SUBCONTRACTOR STOPS HERE & PROVIDES FBR TO PRIME

- 0

IT Professional

25%

26.12

- 0

IT Professional II

100%

28.84

75%

21.63

3.03

- 0

53.50

59.50

55.00

61.00

$ 63.07

$ 58.30

$ 64.66

70%

20%

56.21

Author: Author:

This is an example of a Prime Offeror's FBR Template. For a subcontractor, entries into this template would have ended in column M. 8% 60.71 91.06

Program Manager

Supervisor

Training Specialist

SSC Secretary I

SSC Secretary II

SSC Secretary III

SSC Administrative Assistant

SSC Administrative Assistant I

SSC Administrative Assistant II

JSC Secretary I

JSC Secretary II

JSC Secretary III

JSC Administrative Assistant

JSC Administrative Assistant I

JSC Administrative Assistant II

JSC Administrative Assistant III

WSTF Secretary I

WSTF Secretary II

WSTF Secretary III

WSTF Administrative Assistant

WSTF Administrative Assistant I

WSTF Administrative Assistant II

Other

* These columns represent the proposed major and minor subcontractor(s) fully burdened rates (FBR) by SLC. Identify subcontractors by name in the template.

** The Prime contractor may apply a burden rate to the major and minor subcontractor(s) FBR if applicable.

NOTE: PLEASE REMEMBER TO REMOVE EXAMPLE FORMULAS FROM TEMPLATES

Contract Year 3 FBR Development

Escalation Rate

3.19%

Note: Escalation should only be applied to exempt/non-FLA/SCA/CBA positions.

Prime Completes the area below this green row

Major Subcontractor completes the area below this red row

Subcontract Price Input Area (inputted here by prime)

NASA

% Incumbents

Direct Labor

Overhead

G&A

Composite

Composite Overtime

Offeror's Labor Category

NASA Standard Labor Category (SLC)

At Current DL Rates

% usage

Rate

Cost

Rate

Cost

FCCOM

Fee (sub only)

Other

Prime or Major Subcontractor FBR per hr

Subcontractor "A" FBR/hr *

Subcontractor "B" FBR/hr *

Subcontractor "C" FBR/hr *

Prime Burdens Rate /hr **

Subcontractor "A" FBR + Prime Burdened Rate/hr

Subcontractor "B" FBR + Prime Burdened Rate/hr

Subcontractor "C" FBR + Prime Burdened Rate/hr

% Usage Prime

% Usage Subcontractor "A"

% Usage Subcontractor "B"

% Usage Subcontractor "C"

Prime & Sub FBR /hr

Prime's Profit Rate

Prime & Sub FBR /hr ***

Example:

IT Staff IV

75%

30.69

MAJOR SUBCONTRACTOR STOPS HERE & PROVIDES FBR TO PRIME

- 0

IT Professional

25%

26.96

- 0

IT Professional II

100%

29.76

75%

22.32

3.12

- 0

55.20

59.50

55.00

61.00

$ 63.07

$ 58.30

$ 64.66

70%

20%

57.40

Author: Author:

This is an example of a Prime Offeror's FBR Template. For a subcontractor, entries into this template would have ended in column M.

Author: Author:

The total percentage usage for the prime offeror and all subcontractors for each SLC shall equal 100%.

Author: Author:

This is an example of a Prime Offeror's FBR Template. For a subcontractor, entries into this template would have ended in column M.

Author: Author:

The total percentage usage for the prime offeror and all subcontractors for each SLC shall equal 100%.

Author: Author:

The total percentage usage for the prime offeror and all subcontractors for each SLC shall equal 100%.

Author: Author:

The total percentage usage for the prime offeror and all subcontractors for each SLC shall equal 100%.

This is an example of a Prime Offeror's FBR Template. For a subcontractor, entries into this template would have ended in column M. 8% 62.00 93.00

Program Manager

Supervisor

Training Specialist

SSC Secretary I

SSC Secretary II

SSC Secretary III

SSC Administrative Assistant

SSC Administrative Assistant I

SSC Administrative Assistant II

JSC Secretary I

JSC Secretary II

JSC Secretary III

JSC Administrative Assistant

JSC Administrative Assistant I

JSC Administrative Assistant II

JSC Administrative Assistant III

WSTF Secretary I

WSTF Secretary II

WSTF Secretary III

WSTF Administrative Assistant

WSTF Administrative Assistant I

WSTF Administrative Assistant II

Other

* These columns represent the proposed major and minor subcontractor(s) fully burdened rates (FBR) by SLC. Identify subcontractors by name in the template.

** The Prime contractor may apply a burden rate to the major and minor subcontractor(s) FBR if applicable.

NOTE: PLEASE REMEMBER TO REMOVE EXAMPLE FORMULAS FROM TEMPLATES

Contract Year 4 FBR Development

Escalation Rate

2.98%

Note: Escalation should only be applied to exempt/non-FLA/SCA/CBA positions.

Prime Completes the area below this green row

Major Subcontractor completes the area below this red row

Subcontract Price Input Area (inputted here by prime)

NASA

% Incumbents

Direct Labor

Overhead

G&A

Composite

Composite Overtime

Offeror's Labor Category

NASA Standard Labor Category (SLC)

At Current DL Rates

% usage

Rate

Cost

Rate

Cost

FCCOM

Fee (sub only)

Other

Prime or Major Subcontractor FBR per hr

Subcontractor "A" FBR/hr *

Subcontractor "B" FBR/hr *

Subcontractor "C" FBR/hr *

Prime Burdens Rate /hr **

Subcontractor "A" FBR + Prime Burdened Rate/hr

Subcontractor "B" FBR + Prime Burdened Rate/hr

Subcontractor "C" FBR + Prime Burdened Rate/hr

% Usage Prime

% Usage Subcontractor "A"

% Usage Subcontractor "B"

% Usage Subcontractor "C"

Prime & Sub FBR /hr

Prime's Profit Rate

Prime & Sub FBR /hr ***

Example:

IT Staff IV

75%

31.61

MAJOR SUBCONTRACTOR STOPS HERE & PROVIDES FBR TO PRIME

- 0

IT Professional

25%

27.76

- 0

IT Professional II

100%

30.65

75%

22.98

3.22

- 0

56.85

59.50

55.00

61.00

$ 63.07

$ 58.30

$ 64.66

70%

20%

58.56

This is an example of a Prime Offeror's FBR Template. For a subcontractor, entries into this template would have ended in column M. 8% 63.24 94.86

Program Manager

Supervisor

Training Specialist

SSC Secretary I

SSC Secretary II

SSC Secretary III

SSC Administrative Assistant

SSC Administrative Assistant I

SSC Administrative Assistant II

JSC Secretary I

JSC Secretary II

JSC Secretary III

JSC Administrative Assistant

JSC Administrative Assistant I

JSC Administrative Assistant II

JSC Administrative Assistant III

WSTF Secretary I

WSTF Secretary II

WSTF Secretary III

WSTF Administrative Assistant

WSTF Administrative Assistant I

WSTF Administrative Assistant II

Other

* These columns represent the proposed major and minor subcontractor(s) fully burdened rates (FBR) by SLC. Identify subcontractors by name in the template.

** The Prime contractor may apply a burden rate to the major and minor subcontractor(s) FBR if applicable.

NOTE: PLEASE REMEMBER TO REMOVE EXAMPLE FORMULAS FROM TEMPLATES

Contract Year 5 FBR Development

Escalation Rate

2.93%

Note: Escalation should only be applied to exempt/non-FLA/SCA/CBA positions.

Prime Completes the area below this green row

Major Subcontractor completes the area below this red row

Subcontract Price Input Area (inputted here by prime)

NASA

% Incumbents

Direct Labor

Overhead

G&A

Composite

Composite Overtime

Offeror's Labor Category

NASA Standard Labor Category (SLC)

At Current DL Rates

% usage

Rate

Cost

Rate

Cost

FCCOM

Fee (sub only)

Other

Prime or Major Subcontractor FBR per hr

Subcontractor "A" FBR/hr *

Subcontractor "B" FBR/hr *

Subcontractor "C" FBR/hr *

Prime Burdens Rate /hr **

Subcontractor "A" FBR + Prime Burdened Rate/hr

Subcontractor "B" FBR + Prime Burdened Rate/hr

Subcontractor "C" FBR + Prime Burdened Rate/hr

% Usage Prime

% Usage Subcontractor "A"

% Usage Subcontractor "B"

% Usage Subcontractor "C"

Prime & Sub FBR /hr

Prime's Profit Rate

Prime & Sub FBR /hr ***

Example:

IT Staff IV

75%

32.53

MAJOR SUBCONTRACTOR STOPS HERE & PROVIDES FBR TO PRIME

- 0

IT Professional

25%

28.57

- 0

IT Professional II

100%

31.54

75%

23.66

3.31

- 0

58.51

59.50

55.00

61.00

$ 63.07

$ 58.30

$ 64.66

70%

20%

59.72

Author: Author:

This is an example of a Prime Offeror's FBR Template. For a subcontractor, entries into this template would have ended in column M.

This is an example of a Prime Offeror's FBR Template. For a subcontractor, entries into this template would have ended in column M. 8% 64.50 96.75

Program Manager

Supervisor

Training Specialist

SSC Secretary I

SSC Secretary II

SSC Secretary III

SSC Administrative Assistant

SSC Administrative Assistant I

SSC Administrative Assistant II

JSC Secretary I

JSC Secretary II

JSC Secretary III

JSC Administrative Assistant

JSC Administrative Assistant I

JSC Administrative Assistant II

JSC Administrative Assistant III

WSTF Secretary I

WSTF Secretary II

WSTF Secretary III

WSTF Administrative Assistant

WSTF Administrative Assistant I

WSTF Administrative Assistant II

Other

* These columns represent the proposed major and minor subcontractor(s) fully burdened rates (FBR) by SLC. Identify subcontractors by name in the template.

** The Prime contractor may apply a burden rate to the major and minor subcontractor(s) FBR if applicable.

*** This column represents the composite FBR for the prime Offeror and all its proposed subcontractor(s) by SLC. These composite FBRs shall match the FBRs in Section 1 of the contract. IMPORTANT: If subcontractors are proposed, include a formula in this column showing the calculation of the composite rates.

NOTE: PLEASE REMEMBER TO REMOVE EXAMPLE FORMULAS FROM TEMPLATES

SPT

Summary Price Template (SPT)

Required of the Prime Contractor Only

Prime Contractor's Name:

NASA - Standard Labor Category (SLC)			Base Contract
Straight-Time Hours	Work Year Equivalent (WYE)	Productive Hours (Conversion Factor)	Contract Year 1 Hours	Contract Year 2 Hours	Contract Year 3 Hours	Contract Year 4 Hours	Contract Year 5 Hours	Total 1-5
Full-Time
Program Manager
Supervisor
Training Specialist
SSC Secretary I	- 0		0	0	0	0	0	0
SSC Secretary II	- 0		0	0	0	0	0	0
SSC Secretary III	2.0		0	0	0	0	0	0
SSC Administrative Assistant	13.0		0	0	0	0	0	0
SSC Administrative Assistant I	- 0		0	0	0	0	0	0
SSC Administrative Assistant II	- 0		0	0	0	0	0	0
JSC Secretary I	- 0		0	0	0	0	0	0
JSC Secretary II	33.0		0	0	0	0	0	0
JSC Secretary III	65.0		0	0	0	0	0	0
JSC Administrative Assistant	23.0		0	0	0	0	0	0
JSC Administrative Assistant I	7.0		0	0	0	0	0	0
JSC Administrative Assistant II	2.0		0	0	0	0	0	0
JSC Administrative Assistant III	1.0		0	0	0	0	0	0
WSTF Secretary I	- 0		0	0	0	0	0	0
WSTF Secretary II	- 0		0	0	0	0	0	0
WSTF Secretary III	5.0		0	0	0	0	0	0
WSTF Administrative Assistant	1.0		0	0	0	0	0	0
WSTF Administrative Assistant I	- 0		0	0	0	0	0	0
WSTF Administrative Assistant II	- 0		0	0	0	0	0	0
Other	- 0		0	0	0	0	0	0
	152.0		0	0	0	0	0	0

Contract Rates (From FBR-FT)	Contract Fully Burdened Labor Rates (From FBR-FT)
Full-Time	Year 1	Year 2	Year 3	Year 4	Year 5
Program Manager
Supervisor
Training Specialist
SSC Secretary I
SSC Secretary II
SSC Secretary III
SSC Administrative Assistant
SSC Administrative Assistant I
SSC Administrative Assistant II
JSC Secretary I
JSC Secretary II
JSC Secretary III
JSC Administrative Assistant
JSC Administrative Assistant I
JSC Administrative Assistant II
JSC Administrative Assistant III
WSTF Secretary I
WSTF Secretary II
WSTF Secretary III
WSTF Administrative Assistant
WSTF Administrative Assistant I
WSTF Administrative Assistant II
Other

Labor Cost	Fully-Burdened Labor Cost
Full- Time	Year 1	Year 2	Year 3	Year 4	Year 5	Total 1-5
Program Manager						0
Supervisor						0
Training Specialist						0
SSC Secretary I						0
SSC Secretary II						0
SSC Secretary III						0
SSC Administrative Assistant						0
SSC Administrative Assistant I						0
SSC Administrative Assistant II						0
JSC Secretary I						0
JSC Secretary II						0
JSC Secretary III						0
JSC Administrative Assistant						0
JSC Administrative Assistant I						0
JSC Administrative Assistant II						0
JSC Administrative Assistant III
WSTF Secretary I						0
WSTF Secretary II						0
WSTF Secretary III						0
WSTF Administrative Assistant						0
WSTF Administrative Assistant I						0
WSTF Administrative Assistant II						0
Other						0
Total Fully-Burdened Labor Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Travel	$ 18,269	$ 18,817	$ 19,381	$ 19,963	$ 20,562	$ 96,991
Indirect Cost Applied to Travel (Identify Indirect Rate Used)						$ - 0
Subtotal - Travel Plus Indirect on Travel	$ 18,269	$ 18,817	$ 19,381	$ 19,963	$ 20,562	$ 96,991
Profit on (Travel + Indirect on Travel) (Identify Profit Rate)						$ - 0
Total Travel Cost + Profit on Travel	$ 18,269	$ 18,817	$ 19,381	$ 19,963	$ 20,562	$ 96,991

Total Price $ 18,269 $ 18,817 $ 19,381 $ 19,963 $ 20,562 $ 96,991

The FBR-FT provided here shall agree with the FBR-FT provided in Section One of the Contract

The FBR-FT in this template shall be linked from the FBR-FT template

The estimated annual travel cost is provided. These amounts are to be included unchanged in the total price.

If appropriate, apply indirect cost and profit on the travel cost in accordance with your Accounting System and Accounting Policies.

The formulae in this worksheet is provided to assist in developing the final proposed price. However, it is the Offeror's responsibility to verify formulae and to provide an accurate proposal.

80SSC020R0007, P00003

&F &A &P

TC(a) Compensation Template (a): Salaries and Wages Non-Exempt

NON-EXEMPT

Salaries and Wages Non-Exempt

[ ] Prime Contractor:

[ ] Major Subcontractor:

Actual Incumbent Labor Rate (For Incumbent's Use Only) Department of Labor (DOL) Covered Personnel Rate Contract Year 1 Actual Proposed Labor Rate FTEs

LABOR CATEGORY MAPPING
		Category as per	Proposed Labor Escalation %
Government SLC *	Offeror's	DOL WD or CBA	Yr2	Yr3	Yr4	Yr5	Source

Example:
Technician 1	Electronic Technician I	Electronic Technician II	$ 13.00	$ - 0	$ 13.00	1
	Mechanical Technician II	Mechanical Technician II			$ 13.00	5
	Test Technician II	Non destructive Test Technician III		$ 14.00	$ 15.00	3	DOL2005-2516

COMPOSITE (Weighted Average) $ 13.67

SSC Secretary I

SSC Secretary II

SSC Secretary III

SSC Administrative Assistant

SSC Administrative Assistant I

SSC Administrative Assistant II

JSC Secretary I

JSC Secretary II

JSC Secretary III

JSC Administrative Assistant

JSC Administrative Assistant I

JSC Administrative Assistant II

JSC Administrative Assistant III

WSTF Secretary I

WSTF Secretary II

WSTF Secretary III

WSTF Administrative Assistant

WSTF Administrative Assistant I

WSTF Administrative Assistant II

Other

&12 80SSC020R0007, P00003

TC(b)

Fringe Benefits Analysis of Compensation Plan (FBACP)

Prime Contractor Name:

Major Subcontractor Name:

Minor Subcontractor Name:

Labor Category Type
[ ] Exempt
[ ] Non-Exempt Non-Union	NUMBER OF PROPOSED PERSONNEL (WYE):
[ ] Non-Exempt Union	NUMBER OF DIRECT LABOR HOURS:
		DIRECT LABOR COST:

	COST OF	PERCENT	AVERAGE
	FRINGE	OF DIRECT	COST PER
CATEGORY	BENEFIT	LABOR COST	LABOR HOUR	DESCRIPTION OF BENEFIT

	HEALTH AND WELFARE:
	LIFE INSURANCE		0.00%	$0.00
	DISABILITY INSURANCE		0.00%	$0.00		Number of
	HEALTH INSURANCE		0.00%	$0.00		Days Per Year
	DENTAL INSURANCE		0.00%	$0.00
	CIVIC AND PERSONAL LEAVE
(Jury Duty, Subpoenaed Court Appearance, Bereavement, etc.)	0.00%	$0.00		________
	OTHER LEAVE		0.00%	$0.00		________
	RETIREMENT		0.00%	$0.00
	SAVINGS/THRIFT PLAN		0.00%	$0.00
	SEVERENCE PAY		0.00%	$0.00
	OTHER (Identify)		0.00%	$0.00
	TOTAL HEALTH AND WELFARE	$0.00	0.00%	$0.00
						Number of
	VACATION, HOLIDAY, AND SICK LEAVE:				Eligibility	Days Per Year

VACATION	0%	$0.00	______ Years to ______ Years	________
			______ Years to ______ Years	________
			______ Years to ______ Years	________
			______ Years to ______ Years	________
			______ Years to ______ Years	________
			______ Years to ______ Years	________
HOLIDAYS	0.00%	$0.00		________
SICK LEAVE	0.00%	$0.00		________

TOTAL VACATION, HOLIDAY, AND SICK LEAVE $0.00 0.00% $0.00 ________

OTHER FRINGE BENEFITS
TUITION REIMBURSEMENT	0.00%	$0.00
RELOCATION EXPENSES	0.00%	$0.00
OTHER (Identify)	0.00%	$0.00

TOTAL OTHER FRINGE BENEFITS $0.00 0.00% $0.00

TOTAL FRINGE BENEFITS $0.00 0.00% $0.00

80SSC020R0007, P00005

This template is required of the prime Offeror, each major subcontractor and all subcontractor(s).

A separate template is required per labor category type (exempt, non-exempt non-union, and non-exempt union). It should be noted that the minimum hourly fringe benefits rate cannot be less than the DOL specified minimum rate listed in the RFP under Section J for non-exempt employees.

Number of Proposed (WYE) Input the TOTAL number of proposed personnel (WYE) per labor catergory type for this contract

Number of Direct Labor Hours Input the TOTAL direct labor hours per labor category type for this contract

Direct Labor Cost:

Input the TOTAL direct labor dollars per labor category type for this contract

Cost of Fringe Benefit This column shall include the cost, not rate, associated with the fringes specified (i.e. life insurance, disability insurance, etc.) that are proposed on this contract for each of the related personnel type (exempt, non-exempt non-union, and non-exempt union).

Percent of Direct Labor Cost Shall include the percentage of each of the related specified fringe costs as a percent of direct labor cost.

Average Cost Per Labor Hour Shall include hourly rates based on the average cost per labor hour proposed per specified fringe element.

This template is required of the prime Offeror, each major subcontractor and all subcontractor(s).

Number of Proposed (WYE) Input the TOTAL number of proposed personnel (WYE) per labor catergory type for this contract.

Number of Direct Labor Hours Input the TOTAL direct labor hours per labor category type for this contract. Per 29 CFR 4.175(a), “… unless specified otherwise in the applicable determination such payments are due for all hours paid for, including paid vacation, sick leave, and holiday hours, up to a maximum of 40 hours per week and 2,800 hours per year on each contract.”

Direct Labor Cost:

Input the TOTAL direct labor dollars per labor category type for this contract.

Percent of Direct Labor Cost Shall include the percentage of each of the related specified fringe costs as a percent of direct labor cost.

Average Cost Per Labor Hour Shall include hourly rates based on the average cost per labor hour proposed per specified fringe element.

Health and Welfare This list is inclusive but not exhaustive of possible fringe benefits that are considered "bone fide" fringe benefits in accordance with 29 CFR § 4.171 - “Bona fide” fringe benefits.

PIT

PHASE-IN TEMPLATE (PIT)

Prime Offeror Company Name:

Cost Element	Hours	Rate	Cost
Direct Labor (DL):
Skill mix: (identify from SLC or Other Labor Category)

Total Direct Labor

Indirect Cost:

Overhead

Other Indirect (If Applicable)

Total Indirect Cost

Major Subcontractor Total Cost (list):

Total Major Subcontractor Cost

Minor Subcontractor Total Cost:

Total Minor Subcontractor Costs

Prime Non-Labor Resources (NLR):

Material/Supplies/Equipment

Travel/Training

Service Agreements, Outsourcing & Consultant Fees

Other

Total Non-Labor Resources Cost

Subtotal Direct Labor, Subcontractors, Indirect Cost & NLR Cost

Prime Total G&A Cost

Subtotal Estimated Cost

Profit

Total Estimated (Price) Cost & Profit

Note: PIT shall be proposed on a fixed price basis.

80SSC020R0007, P00003

File details come from the government source that posted it. Updated Apr 2, 2020.