Attachment 11- Pricing Worksheet.xlsx

XLSX spreadsheet 67 KB Posted Feb 9, 2021

Attached to: W91RUS-21-R-0001 IMCS IV Solicitation Amendment 08
Solicitation number: W91RUS
Issued by: Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

View the file

Other files

File	Type	Posted
Attachment 8- Past Performance Questionnaire Cover Letter Amendment 8.pdf	PDF	Mar 25, 2021
W91RUS-21-R-0001 Amendment 08.pdf	PDF	Mar 25, 2021
Attachment 6- Past Performance Questionnaire- Amendment 8.docx	DOCX document	Mar 25, 2021
W91RUS-21-R-0001 Amendment 07.pdf	PDF	Mar 18, 2021
Attachment 4- Fort Combat Kansas Sample TO DD 254 Cont Amendment 6 15 March 2021.pdf	PDF	Mar 16, 2021
Questions Answer Spreadsheet Round 2 AMENDMENT 06.pdf	PDF	Mar 16, 2021
Attachment 8- Past Performance Questionnaire Cover Letter Amendment 6.pdf	PDF	Mar 16, 2021
Attachment 3- Fort Combat kansas Sample Task Order PWS Amendment 6 WITH TRACK CHANGES.pdf	PDF	Mar 16, 2021
W91RUS-21-R-0001 Amendment 06.pdf	PDF	Mar 16, 2021
Attachment 4- Fort Combat Kansas Sample TO DD 254 Cont Amendment 6 WITH TRACK CHANGES.pdf	PDF	Mar 16, 2021
Attachment 11- Pricing Worksheet- Amendment 6.xlsx	XLSX spreadsheet	Mar 16, 2021
Attachment 3- Fort Combat kansas Sample Task Order PWS Amendment 6 15 March 2021.pdf	PDF	Mar 16, 2021
Attachment 6- Past Performance Questionnaire- Amendment 6.docx	DOCX document	Mar 16, 2021
WITH NUMBERING Questions -Answers Spreadsheet- Amendment 3.pdf	PDF	Mar 16, 2021
W91RUS-21-R-0001 Amendment 05.pdf	PDF	Mar 9, 2021
W91RUS-21-R-0001 Amendment 04.pdf	PDF	Mar 5, 2021
Attachment 8- Past Performance Questionnaire Cover Letter Amendment 4.pdf	PDF	Mar 5, 2021
Attachment 3- Fort Combat Kansas Sample Task Order PWS- Amendment 3.pdf	PDF	Mar 5, 2021
W91RUS-21-R-0001 Amendment 03.pdf	PDF	Mar 5, 2021
Questions and Answers Amendment 03.pdf	PDF	Mar 5, 2021
Attachment 7- Past Performance Information- Amendment 3.docx	DOCX document	Mar 5, 2021
Attachment 11- Pricing Worksheet- Amendment 3.xlsx	XLSX spreadsheet	Mar 5, 2021
Attachment 6- Past Performance Questionnaire- Amendment 3.docx	DOCX document	Mar 5, 2021
Attachment 14- Fort Combat Kansas Sample Task Order DBA- Amendment 3.pdf	PDF	Mar 5, 2021
Attachment 5- Fort Combat Kansas Sample Task Order WD- Amendment 3.pdf	PDF	Mar 5, 2021
W91RUS-21-R-0001 Amendment 02.pdf	PDF	Feb 26, 2021
IMCS IV Solicitation W91RUS21R0001_Amendment 1.pdf	PDF	Feb 19, 2021
Amendment 01 Questions and Answer FCL.pdf	PDF	Feb 19, 2021
Attachment 13 - IDIQ PWS.pdf	PDF	Feb 9, 2021
Attachment 13-4 IDIQ Performance Matrix.pdf	PDF	Feb 9, 2021
Attachment 4- Fort Combat Kansas Sample Task Order DD 254 Cont Sheets.pdf	PDF	Feb 9, 2021
Attachment 2- Fort Combat Kansas Sample Task Order Instructions.pdf	PDF	Feb 9, 2021
Attachment 7- Past Performance Information.docx	DOCX document	Feb 9, 2021
Attachment 10- Subcontractor Consent Letter.docx	DOCX document	Feb 9, 2021
Attachment 3- Fort Combat kansas Sample Task Order PWS.pdf	PDF	Feb 9, 2021
Attachment 4- Fort Combat Sample Task Order DD 254.pdf	PDF	Feb 9, 2021
Attachment 5- Fort Combat Kansas Sample Task Order Wage Determination.pdf	PDF	Feb 9, 2021
Attachment 6- Past Performance Questionnaire.docx	DOCX document	Feb 9, 2021
Attachment 13-6 Deliverable Reports for IMCS IV IDIQ .pdf	PDF	Feb 9, 2021
IMCS IV Solicitation W91RUS21R0001.pdf	PDF	Feb 9, 2021
Attachment 1- IDIQ DD 254.pdf	PDF	Feb 9, 2021
Attachment 9- Client AuthorizationLetter.docx	DOCX document	Feb 9, 2021
Attachment 8- Past Performance Questionnaire Cover Letter.pdf	PDF	Feb 9, 2021
Attachment 1- IDIQ DD 254 Cont Sheets.pdf	PDF	Feb 9, 2021
Attachment 13-5 IDIQ Quality Assurance Surveillance Plan (QASP).pdf	PDF	Feb 9, 2021
Attachment 12- Questions Spreadsheet.xlsx	XLSX spreadsheet	Feb 9, 2021

Show all 46

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.

1. Instructions

Each Offeror shall complete each tab in the Pricing Worksheet in response to the solicitation. The Offeror shall show the rate build up for each labor category for the full five year option periods for the Sample Task Order (STO), to include overtime rates (Tabs 3-10).

Accompanying the Pricing Worksheet shall be back-up rationale that clearly identifies the methodology used to arrive at the fully loaded rates. Offeror shall depict how direct and indirect rates were derived for all fully burdened labor rates.

Should a contract be issued to the Offeror, the proposed fully burdened (Tabs 12 - 15), fixed price labor rates for all labor categories for each Contract Years provided on this Pricing Worksheet will be binding and incorporated into the resultant contract. These rates shall be the fully burdened, fixed-price labor rates allowable for the proposed labor category.

Adjustments to fully burdened Exempt labor rates will be subject to downward negotiation only.

Each Exempt labor category provided shall include a description of duties (Tab 13).

CLINs 0007 Overtime, CLINs 0008 Third Party Damages, and 0009 Special Projects/Davis Bacon, 0010 Other Direct Costs, 0011 Travel, 0012 Training, and 0013 Materials are firm fixed priced. The amounts provided by the Government for these CLINs are estimates and will be used for evaluation purposes by adding estimated cost reimbursable amounts to proposed costs to arrive at a total price. The contractor shall be reimbursed for allowable, allocable, and reasonable costs incurred. Material handling costs will be reimbursed for CLIN 0013, Materials and each corresponding option year.

2. Worksheet Contents

WORKSHEET CONTENTS

WORKSHEET TABS

TAB 1 -Instructions

TAB 2 - Worksheet Contents

TAB 3 -Sample Task Order Proposal Details

TAB 4 - Sample Task Order Wrap Up

TAB 5 - Sample Task Order Rate summary

TAB 6 - Sample Task Order Base Year Fringe and Direct Labor Calculations

TAB 7 - Sample Task Order Option Year 1 Fringe and Direct Labor Calculations

TAB 8 - Sample Task Order Option Year 2 Fringe and Direct Labor Calculations

TAB 9 - Sample Task Order Option Year 3 Fringe and Direct Labor Calculations

TAB 10 - Sample Task Order Option Year 1 Fringe and Direct Labor Calculations

TAB 11 - Teaming Information

TAB 12 - IDIQ Schedule B

TAB 13-IDIQ Labor Categories Descriptions

TAB 14- IDIQ Exempt fully burden rates (Will be incorporated into the IDIQ Contract

TAB 15- IDIQ Exempt Labor rate Build up

3. STO Proposal Details Pricing Summary [Insert Company Name HERE]

Escalation and Materials Purchases Indirect Rate
This field informs offerors to provide labor escalation rates and materials handling rates (if applicable) in the fields directly below (Exempt Personnel, Non-Exempt (SCA) Personnel, etc.).	Base Year	Option Year One	Option Year Two	Option Year Three	Option Year Four
Exempt Personnel	N/A	%	%	%	%
Non-Exempt (SCA) Personnel	N/A	%	%	%	%
Materials Purchases Indirect Cost Rate	%	%	%	%	%
Maintenance Agreements Indirect Cost Rate (if applicable)	%	%	%	%	%

Phase In
Performance Period	Unit Price	Quantity	Annual Price
PHASE IN IS NOT BEING EVALUATED AT THE SAMPLE TASK ORDER LEVEL	$ - 0	0	$ - 0
		Total:	$ - 0

CLIN 0001 Infrastracture Ops and Maint Support Services (PWS Paragrpahs C.2.3 and Subparagraphs)	Monthly Unit Price	Quantity	Annual Price
Base Period: 01 July 2021 to 30 June 2021	$ - 0	12	$ - 0
Option Year One: 01 July 2023 to 30 June 2023	$ - 0	12	$ - 0
Option Year Two: 01 July 2024 to 30 June 2024	$ - 0	12	$ - 0
Option Year Three: 01 July 2025 to 30 June 2025	$ - 0	12	$ - 0
Option Year Four: 01 July 2026 to 30 June 2026	$ - 0	12	$ - 0
52.217-8 Extension -6 Months 01 July 2026 - 31 December 2026	$ - 0	6	$ - 0
		Total:	$ - 0

CLIN 0002 ITS Support (PWS Paragraph 2.4 and subparagraphs)	Monthly Unit Price	Quantity	Annual Price
Base Period: 01July 2021 to 30 June 2021	$ - 0	12	$ - 0
Option Year One: 01 July 2023 to 30 June 2023	$ - 0	12	$ - 0
Option Year Two: 01 July 2024 to 30 June 2024	$ - 0	12	$ - 0
Option Year Three: 01 July 2025 to 30 June 2025	$ - 0	12	$ - 0
Option Year Four: 01 July 2026 to 30 June 2026	$ - 0	12	$ - 0
52.217-8 Extension -6 Months 01 July 2026 - 31 December 2026	$ - 0	6	$ - 0
		Total:	$ - 0

CLIN 0003 Telecommunication Support (PWS Paragraph 2.5 and subparagraphs)	Monthly Unit Price	Quantity	Annual Price
Base Period: 01 July 2021 to 30 June 2021	$ - 0	12	$ - 0
Option Year One: 01 July 2023 to 30 June 2023	$ - 0	12	$ - 0
Option Year Two: 01 July 2024 to 30 June 2024	$ - 0	12	$ - 0
Option Year Three: 01 July 2025 to 30 June 2025	$ - 0	12	$ - 0
Option Year Four: 01 July 2026 to 30 June 2026	$ - 0	12	$ - 0
52.217-8 Extension -6 Months 01 July 2026 - 31 December 2026	$ - 0	6	$ - 0
		Total:	$ - 0

CLIN 0004 Radio Systems Operations and Maintenance (PWS Paragraph 2.6 and subparagraphs)	Monthly Unit Price	Quantity	Annual Price
Base Period: 01 July 2021 to 30 June 2021	$ - 0	12.0	$ - 0
Option Year One: 01 July 2023 to 30 June 2023	$ - 0	12	$ - 0
Option Year Two: 01 July 2024 to 30 June 2024	$ - 0	12	$ - 0
Option Year Three: 01 July 2025 to 30 June 2025	$ - 0	12	$ - 0
Option Year Four: 01 July 2026 to 30 June 2026	$ - 0	12	$ - 0
52.217-8 Extension -6 Months 01 July 2026 - 31 December 2026	$ - 0	6	$ - 0
		Total:	$ - 0

CLIN 0005 Additional Technical Support (PWS Paragraph 2.7 and subparagraphs)	Monthly Unit Price	Quantity	Annual Price
Base Period: 01 July 2021 to 30 June 2021	$ - 0	12	$ - 0
Option Year One: 01 July 2023 to 30 June 2023	$ - 0	12	$ - 0
Option Year Two: 01 July 2024 to 30 June 2024	$ - 0	12	$ - 0
Option Year Three: 01 July 2025 to 30 June 2025	$ - 0	12	$ - 0
Option Year Four: 01 July 2026 to 30 June 2026	$ - 0	12	$ - 0
52.217-8 Extension -6 Months 01 July 2026 - 31 December 2026	$ - 0	6	$ - 0
		Total:	$ - 0

CLIN 0006 Other Support Services PWS Paragraph 2.8 and subparagraphs)
Monthly Unit Price		Quantity	Annual Price
Base Period: 01 July 2021 to 30 June 2021	$ - 0		12	$ - 0
Option Year One: 01 July 2023 to 30 June 2023	$ - 0		12	$ - 0
Option Year Two: 01 July 2024 to 30 June 2024	$ - 0		12	$ - 0
Option Year Three: 01 July 2025 to 30 June 2025	$ - 0		12	$ - 0
Option Year Four: 01 July 2026 to 30 June 2026	$ - 0		12	$ - 0
52.217-8 Extension -6 Months 01 July 2026 - 31 December 2026	$ - 0		6	$ - 0
			Total:	$ - 0

CLIN 0007 Overtime: The contractor will provide in the CLIN description detail labor categories and fully loaded labor rates.
Labor Category	Base Year	Option Year One	Option Year Two	Option Year Three	Option Year Four

(Information may be submitted on a separate Excel sheet or Tab )

Government Estimated Annual Amount $ 500,000.00 $ 500,000.00 $ 500,000.00 $ 500,000.00 $ 500,000.00

Total: $ 2,500,000.00 x

CLIN 0008 Third Party Damages:Refer to ID/IQ base contract, paragraph C.2.15, for requirements or as specified in individual task orders.
	Base Year	Option Year One	Option Year Two	Option Year Three	Option Year Four
Third Party Damages
Government Estimated Annual Amount	$100,000.00	$100,000.00	$100,000.00	$100,000.00	$100,000.00

Total: $ 500,000.00

CLIN 0009 Special Projects: Projects will be identified by the Government as required.
Labor Category	Base Year Rate	Option Year One Rate	Option Year Two Rate	Option Year Three	Option Year Four
Example: Electrician
(Information may be submitted on a separate Excel sheet or Tab )

Government Estimated Annual Amount	$ 2,500,000.00	$ 2,500,000.00	$ 2,500,000.00	$ 2,500,000.00	$ 2,500,000.00
SCA $25,000 DBA $25,000			Total:	$ 12,500,000.00

CLIN 0010 Other Direct Costs (Includes vehicles): This CLIN is for Other Direct Costs in support of CLINs 0001 - 0006. Profit is not authorized; however, material & handling rate may be applied but shall not to exceed the plug number.
	Base Year Rate	Option Year One Rate	Option Year Two Rate	Option Year Three	Option Year Four
List by description Example: External Maintenance Agreements	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
(Information may be submitted on a separate Excel sheet or Tab )	$ - 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
	$ 3,500,000.00	$ 3,500,000.00	$ 3,500,000.00	$ 3,500,000.00	$ 3,500,000.00
Total			Total:	$ 17,500,000.00

CLIN 0011 Travel: This CLIN is for Government directed travel in support of CLINs 0001 - 0006. All travel costs shall be in accordance with the Joint Travel Regulation and as specified in individual task orders. Profit is not authorized.
	Base Year	Option Year One	Option Year Two	Option Year Three	Option Year Four
Travel
Government Estimated Annual Amount	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00

Total: $50,000.00

CLIN 0012 Training: This CLIN is for training in support of CLINs 0001 - 0006. All training shall be IAW PWS Para. C.1.2 and as specified in individual task orders. Profit is not authorized.
	Base Year	Option Year One	Option Year Two	Option Year Three	Option Year Four
Training
Government Estimated Annual Amount	$ 100,000.00	$ 100,000.00	$ 100,000.00	$ 100,000.00	$ 100,000.00

Total: $ 500,000.00

CLIN 0013 Materials: Material handling costs are reimbursable. Application of indirect cost is allowable. Profit is not authorized.
Materials	Base Year	Option Year One	Option Year Two	Option Year Three	Option Year Four
Government Estimated Annual Amount	$ 2,250,000.00	$ 2,250,000.00	$ 2,250,000.00	$ 2,250,000.00	$ 2,250,000.00

Total: $ 11,250,000.00

CLIN 0014 Deliverables: This CLIN represents the Reports described in the PWS and are not separately priced (NSP). Associated costs are to be included in the fixed price portion of the contract.
	Base Year	Option Year One	Option Year Two	Option Year Three	Option Year Four
Deliverables (Reports)
Government Estimated Annual Amount	NSP	NSP	NSP	NSP	NSP
Not Separately Priced

Summary (Inclusive of ODCs, ATS/IT Support)	Base Year	Option Year One	Option Year Two	Option Year Three	Option Year Four
LABOR	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
All other	$ 8,860,000.00	$ 8,860,000.00	$ 8,860,000.00	$ 8,860,000.00	$ 8,860,000.00
Dash-8						$ - 0
	$ 8,860,000.00	$ 8,860,000.00	$ 8,860,000.00	$ 8,860,000.00	$ 8,860,000.00	$ - 0	$ 44,300,000.00	Double Check

	$ 44,800,000.00
TOTAL Evaluated Price (All Years/ODCs)
Additional Notes Regarding Proposal:
(example: Phase in notes, etc)
This spreadsheet is provided as proposal example spreadhseet. CONTRACTORS are responsible to confirm all formulas and totals proposed are accurate. Government is not responsible to confirm contractors proposal figures are correct.

4. STO Proposed & Est Wrap-up

TOTAL ANNUAL PROPOSED AND ESTIMATED COSTS
	Base Period	Option Period	Option Period	Option Period	Option Period	52.217-8 (6 months)	Total Base &
		One	Two	Three	Four	Opt to Extend Services	Option Periods
CLIN 0001 Infrastracture Ops and Maint Spt Services							$ - 0
CLIN 0002 Information Technology (IT) Systems Support							$ - 0
CLIN 0003Telecommunication Support Services							$ - 0
CLIN 0004 Radio Systems Operations and Maintenance							$ - 0
CLIN 0005 Additional Technical Support							$ - 0
CLIN 0006 Other Support Services							$ - 0
CLIN 0007 Overtime	$500,000.00	$500,000.00	$500,000.00	$500,000.00	$500,000.00	$0.00	$2,500,000.00
CLIN 0008 Third Party Damages	$100,000.00	$100,000.00	$100,000.00	$100,000.00	$100,000.00	$0.00	$500,000.00
CLIN 0009 Special Projects/Davis Bacon	$2,500,000.00	$2,500,000.00	$2,500,000.00	$2,500,000.00	$2,500,000.00	$0.00	$12,500,000.00
CLIN 0010 Other Direct Costs	$3,500,000.00	$3,500,000.00	$3,500,000.00	$3,500,000.00	$3,500,000.00	$0.00
CLIN 0011 Travel	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$0.00	$50,000.00
CLIN 0012 Training	$100,000.00	$100,000.00	$100,000.00	$100,000.00	$100,000.00	$0.00	$500,000.00
CLIN 0013 Materials	$2,250,000.00	$2,250,000.00	$2,250,000.00	$2,250,000.00	$2,250,000.00	$0.00	$11,250,000.00
CLIN 0014 Deliverables (Reports)							$0.00
CLIN 0015 Man Power Reporting							$0.00

5.STO Rate Summary

RATE SUMMARY
A. Labor Escalation Rate
	MGMT/	SCA
OPTION PERIOD	SCA EXEMPT
Option Period 1
Option Period 2
Option Period 3
Option Period 4

Rate Buildup Summary	FRINGE	OH	G&A	PROFIT	MATERIAL HANDLING FEE
Base Period
Option Period 1
Option Period 2
Option Period 3
Option Period 4

6. STO Base Period

Fringe and Direct Labor Calculations
Base Period	2080 Hours

EXAMPLE:
CLIN 0001 INFRASTRUCTURE OPS AND MAINT SERVICES									Base	Rate	Escal.	Holiday	VACATION	SICK	H&W	FICA	FUTA	SUTA	WORK	OTHER	Total	OH	G&A	Fee	Total Annual Price	Fully Burdened
FTE	Labor Category	SCA Labor Category	Title/Description	Total H&W Hours	Vac.	Hol.	Sick	Man Hours	Pay	Diff	0.00%				3.35	7.65%	7000*0.8%		COMP	FRINGE	Fringe	4.05%	9.14%	6%	Cost	Hourly Rate
1	Ex. Supervisory Cake Maker	Exempt	Site Manager	2080	160	80	0.0	1920	$32.01			$2,560.80	$5,121.60		$0.00	$54.26	$56.00	$952.00	$849.00	$0.00	$17,169.00	$3,184.44	$7,477.68	$5,357.42	$94,647.73	$49.30
2	Ex. Cake Maker	General Clerk	Frosting Decorator	2080	80	80	0	1920	$21.33			$1,706.40	$1,706.40		$6,432.00	$3,886.08	$56.00	$952.00	$849.00	$0.00	$15,343.38	$2,280.03	$5,353.94	$3,835.86	$67,766.80	$35.30

CLIN 0002 INFORMATION TECHONOLOGY SYSTEMS SUPPORT LABOR

CLIN 0003 TELECOMMUNICATIONS SUPPORT REQUIREMENTS LABOR

CLIN 0004 RADIO SYSTEMS OPERATIONS AND MAINTENANCE LABOR

CLIN 0005 ADDITIONAL TECHNICAL SUPPORT

CLIN 0006 OTHER SUPPORT SERVICES

Overtime Rate																						Fully Burdened Overtime Rate
	Ex. Supervisory Cake Maker	-	-	-	-	-	$30.99															$49.30
	Ex. Cake Maker	-	-	-	-		$21.33	-	-	-	$ 3.35	$ 2.70	$ 0.28	$ 3.96	$0.42	$0.00	$ 10.72	$ 1.73	$ 4.06	$ 2.91	$ 51.42	$51.42

DBA Rate

7. STO Option Period 1

Fringe and Direct labor Calculations
Option Period One	2080 Hours
CLIN 1001 INFRASTRUCTURE OPS AND MAINT SERVICES
EXAMPLE:									Base	Rate	Escal.	Holiday	VACATION	SICK	H&W	FICA	FUTA	SUTA	WORK	OTHER	Total	OH	G&A	Fee	Annual	Fully Burdened
FTE	Labor Category	SCA Labor Category	Title/Description	Total H&W Hours	Vac.	Hol.	Sick	Man Hours	Pay	Diff	0.00%				3.35	7.65%	7000*0.8%		COMP	FRINGE	Fringe	4.05%	9.14%	6%	Cost	Hourly Rate
1	Supervisory Cake Maker	Exempt	Site Manager	2080	160	80	0.0	1920	$32.01			$2,560.80	$5,121.60		$0.00	$54.26	$56.00	$952.00	$849.00	$0.00	$17,169.00	$3,184.44	$7,477.68	$5,357.42	$94,647.73	$49.30
2	Cake Maker	General Clerk	Frosting Decorator	2080	80	80	0	1920	$21.33			$1,706.40	$1,706.40		$6,432.00	$3,886.08	$56.00	$952.00	$849.00	$0.00	$15,343.38	$2,280.03	$5,353.94	$3,835.86	$67,766.80	$35.30

CLIN 1002 INFORMATION TECHONOLOGY SYSTEMS SUPPORT LABOR

CLIN1003 TELECOMMUNICATIONS SUPPORT REQUIREMENTS LABOR

CLIN 1004 RADIO SYSTEMS OPERATIONS AND MAINTENANCE LABOR

CLIN 1005 ADDITIONAL TECHNICAL SUPPORT

CLIN 1006 OTHER SUPPORT SERVICES

Overtime Rate																						Fully Burdened Overtime Rate
	Ex. Supervisory Cake Maker	-	-	-	-	-	$30.99															$49.30
	Ex. Cake Maker	-	-	-	-		$21.33	-	-	-	$ 3.35	$ 2.70	$ 0.28	$ 3.96	$0.42	$0.00	$ 10.72	$ 1.73	$ 4.06	$ 2.91	$ 51.42	$51.42

DBA Rate

8. STO Option Period 2 Fringe and Direct labor Calculations

Option Period Two	2080 Hours
CLIN 2001 INFRASTRUCTURE OPS AND MAINT SERVICES
EXAMPLE:									Base	Rate	Escal.	Holiday	VACATION	SICK	H&W	FICA	FUTA	SUTA	WORK	OTHER	Total	OH	G&A	Fee	Annual	Fully Burdened
FTE	Labor Category	SCA Labor Category	Title/Description	Total H&W Hours	Vac.	Hol.	Sick	Man Hours	Pay	Diff	0.00%				3.35	7.65%	7000*0.8%		COMP	FRINGE	Fringe	4.05%	9.14%	6%	Cost	Hourly Rate
1	Ex. Supervisory Cake Maker	Exempt	Site Manager	2080	160	80	0.0	1920	$32.01			$2,560.80	$5,121.60		$0.00	$54.26	$56.00	$952.00	$849.00		$17,169.00	$3,184.44	$7,477.68	$5,357.42	$94,647.73	$49.30
2	Ex. Cake Maker	General Clerk	Frosting Decorator	2080	80	80	0	1920	$21.33			$1,706.40	$1,706.40		$6,432.00	$3,886.08	$56.00	$952.00	$849.00		$15,343.38	$2,280.03	$5,353.94	$3,835.86	$67,766.80	$35.30

CLIN 2002 INFORMATION TECHONOLOGY SYSTEMS SUPPORT LABOR

CLIN 2003 TELECOMMUNICATIONS SUPPORT REQUIREMENTS LABOR

CLIN 2004 RADIO SYSTEMS OPERATIONS AND MAINTENANCE LABOR

CLIN 2005 ADDITIONAL TECHNICAL SUPPORT

CLIN 2006 OTHER SUPPORT SERVICES

Overtime Rate																						Fully Burdened Overtime Rate
	Ex. Supervisory Cake Maker	-	-	-	-	-	$30.99															$49.30
	Ex. Cake Maker	-	-	-	-		$21.33	-	-	-	$ 3.35	$ 2.70	$ 0.28	$ 3.96	$0.42	$0.00	$ 10.72	$ 1.73	$ 4.06	$ 2.91	$ 51.42	$51.42

DBA Rate

9. STO Option Period 3 Fringe and Direct labor Calculations

Option Period Three	2080 Hours
CLIN 3001 INFRASTRUCTURE OPS AND MAINT SERVICES
EXAMPLE:									Base	Rate	Escal.	Holiday	VACATION	SICK	H&W	FICA	FUTA	SUTA	WORK	OTHER	Total	OH	G&A	Fee	Annual	Fully Burdened
FTE	Labor Category	SCA Labor Category	Title/Description	Total H&W Hours	Vac.	Hol.	Sick	Man Hours	Pay	Diff	0.00%				3.35	7.65%	7000*0.8%		COMP	FRINGE	Fringe	4.05%	9.14%	6%	Cost	Hourly Rate
1	Ex. Supervisory Cake Maker	Exempt	Site Manager	2080	160	80	0.0	1920	$32.01			$2,560.80	$5,121.60		$0.00	$54.26	$56.00	$952.00	$849.00		$17,169.00	$3,184.44	$7,477.68	$5,357.42	$94,647.73	$49.30
2	Ex. Cake Maker	General Clerk	Frosting Decorator	2080	80	80	0	1920	$21.33			$1,706.40	$1,706.40		$6,432.00	$3,886.08	$56.00	$952.00	$849.00		$15,343.38	$2,280.03	$5,353.94	$3,835.86	$67,766.80	$35.30

CLIN 3002 INFORMATION TECHONOLOGY SYSTEMS SUPPORT LABOR

CLIN 3003 TELECOMMUNICATIONS SUPPORT REQUIREMENTS LABOR

CLIN 3004 RADIO SYSTEMS OPERATIONS AND MAINTENANCE LABOR

CLIN 3005 ADDITIONAL TECHNICAL SUPPORT

CLIN 3006 OTHER SUPPORT SERVICES

Overtime Rate																						Fully Burdened Overtime Rate
	Ex. Supervisory Cake Maker	-	-	-	-	-	$30.99															$49.30
	Ex. Cake Maker	-	-	-	-		$21.33	-	-	-	$ 3.35	$ 2.70	$ 0.28	$ 3.96	$0.42	$0.00	$ 10.72	$ 1.73	$ 4.06	$ 2.91	$ 51.42	$51.42

DBA Rate

10. STO Option Period 4 Fringe and Direct labor Calculations

Option Period Four	2080 Hours
CLIN 4001 INFRASTRUCTURE OPS AND MAINT SERVICES
EXAMPLE:									Base	Rate	Escal.	Holiday	VACATION	SICK	H&W	FICA	FUTA	SUTA	WORK	OTHER	Total	OH	G&A	Fee	Annual	Fully Burdened
FTE	Labor Category	SCA Labor Category	Title/Description	Total H&W Hours	Vac.	Hol.	Sick	Man Hours	Pay	Diff	0.00%				3.35	7.65%	7000*0.8%		COMP	FRINGE	Fringe	4.05%	9.14%	6%	Cost	Hourly Rate
1	Ex. Supervisory Cake Maker	Exempt	Site Manager	2080	160	80	0.0	1920	$32.01			$2,560.80	$5,121.60		$0.00	$54.26	$56.00	$952.00	$849.00	$0.00	$17,169.00	$3,184.44	$7,477.68	$5,357.42	$94,647.73	$49.30
2	Ex. Cake Maker	General Clerk	Frosting Decorator	2080	80	80	0	1920	$21.33			$1,706.40	$1,706.40		$6,432.00	$3,886.08	$56.00	$952.00	$849.00	$0.00	$15,343.38	$2,280.03	$5,353.94	$3,835.86	$67,766.80	$35.30

CLIN 4002 INFORMATION TECHONOLOGY SYSTEMS SUPPORT LABOR

CLIN 4003 TELECOMMUNICATIONS SUPPORT REQUIREMENTS LABOR

CLIN 4004 RADIO SYSTEMS OPERATIONS AND MAINTENANCE LABOR

CLIN 4005 ADDITIONAL TECHNICAL SUPPORT

CLIN 4006 OTHER SUPPORT SERVICES

Overtime Rate																						Fully Burdened Overtime Rate
	Ex. Supervisory Cake Maker	-	-	-	-	-	$30.99															$49.30
	Ex. Cake Maker	-	-	-	-		$21.33	-	-	-	$ 3.35	$ 2.70	$ 0.28	$ 3.96	$0.42	$0.00	$ 10.72	$ 1.73	$ 4.06	$ 2.91	$ 51.42	$51.42

DBA Rate

11. Teaming Information Subcontractor - XYZ Company CAGE - A12345 DUNS - 00099988 Size Standard - Small Performance Cost - $40,000 Percentage Cost - 30% Labor Category PWS Performance Area Exempt/ Non-Exempt Wage Determination Location (if applicable) Hourly Rate Fully Burdened Rate Opt Yr 1 Hourly Rate Opt Yr 1 Fully Burdened Rate Opt Yr 2 Hourly Rate Opt Yr 2 Fully Burdened Rate Opt Yr 3 Hourly Rate Opt Yr 3 Fully Burdened Rate Opt Yr 4 Hourly Rate Opt Yr 4 Fully Burdened Rate

Subcontractor - ACME LLC CAGE - X01234 DUNS - 11122233 Size Standard - Large Performance Cost - $20,000 Percentage Cost - 10% Labor Category PWS Performance Area Exempt/ Non-Exempt Wage Determination Location Hourly Rate Fully Burdened Rate Opt Yr 1 Hourly Rate Opt Yr 1 Fully Burdened Rate Opt Yr 2 Hourly Rate Opt Yr 2 Fully Burdened Rate Opt Yr 3 Hourly Rate Opt Yr 3 Fully Burdened Rate Opt Yr 4 Hourly Rate Opt Yr 4 Fully Burdened Rate

Subcontractor - ABC Company CAGE - B54321 DUNS - 99900055 Size Standard - Small Performance Cost - $15,000 Percentage Cost - 5% Labor Category PWS Performance Area Exempt/ Non-Exempt Wage Determination Location Hourly Rate Fully Burdened Rate Opt Yr 1 Hourly Rate Opt Yr 1 Fully Burdened Rate Opt Yr 2 Hourly Rate Opt Yr 2 Fully Burdened Rate Opt Yr 3 Hourly Rate Opt Yr 3 Fully Burdened Rate Opt Yr 1 Hourly Rate Opt Yr 3 Fully Burdened Rate

Additional Notes: Proposals containing subcontractors shall adhere to the provisions of FAR Clause 52.219-14, Limitations on Subcontracting.

If the rates are the same for each contract period, provide one schedule and state that the schedule applies to all contract periods. If the rates are different for each contract period, unhide columns H through O for each contract period.

Labor breakdown is not expected for subcontracted work. Offerors are not required to provide the proprietary indirect rates (i.e. G&A, fringe, OH, etc.). However, the Government is requiring that Offerors provide the subcontractors' hourly labor rate and fully burdened labor rate to verify the subcontractor's labor pricing complies with the SCA WD, CBA, and the Prime's Exempt labor category ceiling rate, as applicable.

12. IDIQ Schedule B

Ordering Period 15 December 2021 through 14 December 2026
ITEM NO	SUPPLIES/SERVICES	MAX QUANTITY	UNIT	UNIT PRICE	MAX AMOUNT
0001	Administrative Telephone Services (Includes Sample TO PWS C.2.3)	60	Months
0002	Information Technology (IT) Systems Support (Includes Sample TO PWS C.2.5)	60	Months
0003	Telecommunications Support Requirements (Includes Sample TO PWS C.2.6)	60	Months
0004	Radio Systems Operations and Maintenance (Includes Sample TO PWS C.2.7)	60	Months
0005	Additional Technical Support (Includes Sample TO PWS C.2.15- Cable Audit)	60	Months
0006	Other Support Services (Includes Sample TO PWS C.2.16)	60	Months
0007	Overtime	60	Months	$500,000.00	$ 30,000,000.00
0008	Third Party Damages	60	Months	$100,000.00	$ 6,000,000.00
0009	Special Projects/Davis Bacon	60	Months	$2,500,000.00	$ 150,000,000.00
0010	Other Direct Costs	60	Months	$3,500,000.00	$ 210,000,000.00
0011	Travel	60	Months	$10,000.00	$ 600,000.00
0012	Training	60	Months	$100,000.00	$ 6,000,000.00
0013	Materials	60	Months	$2,250,000.00	$ 135,000,000.00
0014	Deliverables (Reports)	60	Months	$0.00
0015	Manpower Reporting	60	Months	$0.00
	TOTAL BASE YEAR				$ 537,600,000.00

13.ExemptLabor Cat Descriptions

LABOR CATEGORY DESCRIPTION

14. Exempt Burdened Hrly Rates

Exempt FULLY BURDENED HOURLY LABOR RATES
LABOR CATEGORY	Contract Year 1	Contract Year 2	Contract Year 3	Contract Year 4	Contract Year 5

15. Exempt Labor Rate Buildup

EXEMPT Labor Catergory Build-Up
									Base	Rate	Escal.	Holiday	VACATION	SICK	H&W	FICA	FUTA	SUTA	WORK	OTHER	Total	OH	G&A	Fee	Total Annual Price	Fully Burdened
FTE	Labor Category	Labor Category	Title/Description	Total H&W Hours	Vac.	Hol.	Sick	Man Hours	Pay	Diff	0.00%				3.35	7.65%	7000*0.8%		COMP	FRINGE	Fringe	4.05%	9.14%	6%	Cost	Hourly Rate
1	Ex. Supervisory Cake Maker	Exempt	Site Manager	2080	160	80	0.0	1920	$32.01			$2,560.80	$5,121.60		$0.00	$54.26	$56.00	$952.00	$849.00	$0.00	$17,169.00	$3,184.44	$7,477.68	$5,357.42	$94,647.73	$49.30

File details come from the government source that posted it. Updated Feb 9, 2021.