Attachment_J008_-_Pricing_Schedule_(5-22-2017).xlsx

XLSX spreadsheet 123 KB Posted May 22, 2017

Attached to: Public Assistance (PA) Technical Assistance Contracts (TAC) IV Federal contract opportunity
Solicitation number: HSFE80-17-R-0004
Issued by: Federal Emergency Management Agency Region 9

About this file

From the source

Attachment J008 - Pricing Schedule

View the file

Other files for this federal contract opportunity

Other files attached to Public Assistance (PA) Technical Assistance Contracts (TAC) IV, newest first.
File	Type	Posted
Attachment_J008_-_Pricing_Schedule_(5-25-2017).xlsx	XLSX spreadsheet	May 25, 2017
Amendment_0005.pdf	PDF	May 25, 2017
Amendment_0004.pdf	PDF	May 24, 2017
HSFE80-17-R-0004_(5-24-2017).pdf	PDF	May 24, 2017
Attachment_J008_-_Pricing_Schedule_(5-24-2017),_v2.xlsx	XLSX spreadsheet	May 24, 2017
HSFE80-17-R-0004_(5-22-2017).pdf	PDF	May 22, 2017
PA_TAC_IV_Final_Questions_&_Answers_5-22-2017.pdf	PDF	May 22, 2017
Attachment_J001_-_Performance_Work_Statement_(5-18-2017).pdf	PDF	May 22, 2017
Amendment_0003.pdf	PDF	May 22, 2017
Attachment_J008_-_Pricing_Schedule_(5-18-2017).xlsx	XLSX spreadsheet	May 18, 2017
Amendment_0002.pdf	PDF	May 18, 2017
Attachment_J001_-_Performance_Work_Statement_(5-18-2017).pdf	PDF	May 18, 2017
HSFE80-17-R-0004_(5-18-2017).pdf	PDF	May 18, 2017
Attachment_J003_-_Labor_Categories_Qualifications_(5-16-2017).xlsx	XLSX spreadsheet	May 17, 2017
Attachment_J005_-_Past_Performance_Questionnaire.pdf	PDF	May 17, 2017
Attachment_J002_-_Security_(5-16-2017).pdf	PDF	May 17, 2017
Questions_&_Answers_PA_TAC_IV.pdf	PDF	May 17, 2017
Attachment_J008_-_Pricing_Schedule_(5-16-2017).xlsx	XLSX spreadsheet	May 17, 2017
Attachment_J007_-_Technical_Evaluation_Worksheet.pdf	PDF	May 17, 2017
HSFE80-17-R-0004_(5-16-2017).pdf	PDF	May 17, 2017
Amd_0001_-_HSFE80-17-R-0004.pdf	PDF	May 17, 2017
Attachment_J006_-_Wage_Rate_Determination_(5-16-2017.pdf	PDF	May 17, 2017
Attachment_J001_-_Performance_Work_Statement_(5-16-2017).pdf	PDF	May 17, 2017
Attachment_J004_-_PRS_(5-16-2017).pdf	PDF	May 17, 2017
Attachment_J001_-_Performance_Work_Statement.pdf	PDF	May 1, 2017
Attachment_J008_-_Pricing_Schedule.xlsx	XLSX spreadsheet	May 1, 2017
Attachment_J006_-_Wage_Rate_Determination.pdf	PDF	May 1, 2017
Attachment_J007_-_Technical_Evaluation_Worksheet.pdf	PDF	May 1, 2017
Attachment_J003_-_Labor_Categories_&_Qualifications.xlsx	XLSX spreadsheet	May 1, 2017
Attachment_J004_-_PRS.pdf	PDF	May 1, 2017
HSFE80-17-R-0004.pdf	PDF	May 1, 2017
Attachment_J002_-_Security.pdf	PDF	May 1, 2017
Attachment_J005_-_Past_Performance_Questionnaire.pdf	PDF	May 1, 2017
Attachment_J003_Labor_Categories,_Qualifications_and_Tasks_(PA-TAC_IV).pdf	PDF	Mar 1, 2017
DRAFT_SOLICITATION_HSFE80-17-R-0004.pdf	PDF	Mar 1, 2017
Attachment_J001_Performance_Work_Statement.pdf	PDF	Mar 1, 2017
Attachment_J004_PRS.pdf	PDF	Mar 1, 2017
Attachment_J002_Security.pdf	PDF	Mar 1, 2017
Attachment_J007_Technical_Evaluation_Worksheet.pdf	PDF	Mar 1, 2017
Attachment_J005_Past_Performance_Questionnaire.pdf	PDF	Mar 1, 2017

Show all 40

On GovTribe

Work with this file on GovTribe

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

Attachment J008 Instructions to Offerors:

1. Management & Administration Annual Task Order under CLIN 0001 shall be priced a firm-fixed-price for each period of performance (ref tab labeled "Readiness") and shall be utilized throughout the life of the contract.

2. Tab labeled "Master Pricing," Offerors shall submit fully burdened labor hourly rates for each labor category, for each period of performance. The Master Pricing Sheets will be incorporated into IDIQ contracts and utilized to cross reference task order level pricing through out the life of the contract.

3. All other tabs, which are for labor categories or positions 1 thru 14.

3a. CLIN 0001 M&A has been provided for evaluation purposes only and it will automatically populate the extended cost based on labor categories below for each PoP.

3b. CLIN 0002 (yellow highlights) insert fully burden hourly rates for each PoP labor categories, ensure the extended cost is populated with correct total.

3c. CLIN 0003 Travel is a not-to-exceed and provided for evaluation purposes only.

3d. CLIN 0004 ODC is a reimbursable cost and provided for evaluation purposes only.

4. Roll-up tab will auto populate based on input from readiness and positions 1 thru 14. Offerors should review for accuracy.

5. Offerors will input their inflation rate for positions 1 thru 14.

6. NOTE: The Government reserves the right to order labor hours and categories in different quantities as required.

Master Pricing Master Pricing Schedule - All Labor Categories

		CLIN	DESCRIPTION		PERIOD OF PERFORMANCE & LABOR RATES
		0001	Management & Administrative (M&A)	Level	Base Year	Option
Year 1	Option
Year 2	Option
Year 3	Option

Year 4

		Labor Rates	Labor Rates	Labor Rates	Labor Rates	Labor Rates
Program Manager	Senior
Deputy Program Manager	Senior
Contract Manager	Senior
Readiness/Deployment Manager	Mid
General Planner	Mid
Administrative Assistant	Mid
Trainer	Mid

		CLIN	DESCRIPTION		PERIOD OF PERFORMANCE & LABOR RATES
		0002	Labor	Level	Base Period	Option
Year 1	Option
Year 2	Option
Year 3	Option

Year 4

		Labor Rates	Labor Rates	Labor Rates	Labor Rates	Labor Rates
Accountant	Mid
Appraiser	Mid
Appraiser	Senior
Archaeologist	First
Archaeologist	Mid
Archaeologist	Senior
Architect	First
Architect	Mid
Architect	Senior
Architectural Historian	Mid
Biologist	First
Biologist	Mid
Biologist	Senior
Certified Flood Plain Manager	Mid
Certified Public Accountant	First
Certified Public Accountant	Mid
Certified Public Accountant	Senior
Civil Engineer	First
Civil Engineer	Mid
Civil Engineer	Senior
Client Liaison	First
Client Liaison	Mid
Client Liaison	Senior
Coastal Engineer	Mid
Commercial Property Insurance Professional	First
Commercial Property Insurance Professional	Mid
Commercial Property Insurance Professional	Senior
Computer Specialist	Mid
Construction Manager	First
Construction Manager	Mid
Construction Manager	Senior
Construction or Building Inspector	First
Construction or Building Inspector	Mid
Construction or Building Inspector	Senior
Ecologist	Mid
Electrical Engineer	First
Electrical Engineer	Mid
Electrical Engineer	Senior
Engineering Technician	First
Engineering Technician	Mid
Engineering Technician	Senior
Environmental Engineer	Mid
Environmental Planner	First
Environmental Planner	Mid
Environmental Planner	Senior
Estimator	First
Estimator	Mid
Estimator	Senior
Financial Analyst	First
Financial Analyst	Mid
Financial Analyst	Senior
General Planner	First
General Planner	Senior
Geologist	First
Geologist	Mid
Geologist	Senior
Graphic Artist	Mid
Graphic Artist	Senior
Health Scientist	Mid
Historic Architect	Mid
Horticulturalist	Mid
Hydraulic Engineer	Mid
Hydrologist	First
Hydrologist	Mid
Hydrologist	Senior
Industrial Hygienist	Mid
Mechanical Engineer	First
Mechanical Engineer	Mid
Mechanical Engineer	Senior
Project Manager	First
Project Manager	Mid
Project Manager	Senior
Sanitary Engineer	Mid
Soil/Geotechnical Engineer	First
Soil/Geotechnical Engineer	Mid
Soil/Geotechnical Engineer	Senior
Structural Engineer	First
Structural Engineer	Mid
Structural Engineer	Senior
Technical Writer	Mid
Technical Writer	Senior
Water Quality Specialist	Mid
Wetlands Specialist	Mid

Roll-up

		M&A for Readiness
			Base
Extended Cost	OP 1
Extended Cost	OP 2
Extended Cost	OP 3
Extended Cost	OP 4

Extended Cost

CLIN 0001 M&A $0.00 $0.00 $0.00 $0.00 $0.00

Total M&A Base and Option Periods $0.00

		Disaster CLINs
			Base
Extended Cost	OP 1
Extended Cost	OP 2
Extended Cost	OP 3
Extended Cost	OP 4

Extended Cost

CLIN 0001 M&A $0.00 $0.00 $0.00 $0.00 $0.00

CLIN 0002 Labor $0.00 $0.00 $0.00 $0.00 $0.00

CLIN 0003 Travel $36,456,241.64 $37,110,194.03 $38,533,741.07 $40,812,125.58 $44,089,747.39

CLIN 0004 ODC $70,000.00 $71,260.00 $73,993.53 $78,368.55 $84,662.33

Total Disaster CLINs $36,526,241.64 $37,181,454.03 $38,607,734.61 $40,890,494.13 $44,174,409.71

Total Disaster Base and Option Periods $197,380,334.12

	Total M&A for Readiness and Disaster CLINs	$36,526,241.64	$37,181,454.03	$38,607,734.61	$40,890,494.13	$44,174,409.71
Total M&A and Disaster (Base and Option Periods)		$197,380,334.12

Readiness CLIN 0001 - M&A for Readiness

POSITION - LABOR CATEGORY/SKILL SET (Qty)	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
M&A READINESS / PMO Staff
Program Manager (1)						1	850	$0.00	$0.00	$0.00	$0.00	$0.00
Deputy Program Manager (1)						1	1900	$0.00	$0.00	$0.00	$0.00	$0.00
Contract Manager (1)						1	1100	$0.00	$0.00	$0.00	$0.00	$0.00
Readiness/Deployment Manager (1)						1	1320	$0.00	$0.00	$0.00	$0.00	$0.00
General Planner (1)						1	690	$0.00	$0.00	$0.00	$0.00	$0.00
Administrative Assistant (1)						1	720	$0.00	$0.00	$0.00	$0.00	$0.00
Train the Trainer (2)						2	500	$0.00	$0.00	$0.00	$0.00	$0.00
					Total Staff	8
							Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

ODCs		Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
Badging
Training
Project Management/Readiness
Reporting
Project Briefings
Travel
	Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

		Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
Material Handling Cost
	Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

Total $0.00 $0.00 $0.00 $0.00 $0.00

PDM

CLIN 0002 insert fully burden hourly rates for each PoP labor categories, ensure the extended cost is populated with correct total. CLIN 0001, CLIN 0003, and CLIN 0004 are provided for evaluation purpose.

Position # 1
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		PROGRAM DELIVERY MANAGERS - PDM (165)
		Client Liaison (75)	First						35	2080	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						30	2080	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						10	2080	$0.00	$0.00	$0.00	$0.00	$0.00
		Project Manager (50)	First						25	2080	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						20	2080	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						5	2080	$0.00	$0.00	$0.00	$0.00	$0.00
		Construction Manager (40)	First						20	2080	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						15	2080	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						5	2080	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	165
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00
CLIN 0003	Travel										Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
							Staff	Rate	Qty
		Airfare (roundtrip)					130	$750.00	4	trips	$390,000.00	$397,020.00	$412,249.69	$436,624.77	$471,690.11
		POV Travel Mileage (roundtrip)					130	$0.54	100	miles	$7,020.00	$7,146.36	$7,420.49	$7,859.25	$8,490.42
		Rental Car (weekly)					130	$175.00	52	weeks	$1,183,000.00	$1,204,294.00	$1,250,490.72	$1,324,428.48	$1,430,793.33
		Rental Car Fuel (weekly)					130	$50.00	52	weeks	$338,000.00	$344,084.00	$357,283.06	$378,408.14	$408,798.10
		Misc: Baggage Fees, Taxi, Metro					130	$50.00	4	trips	$26,000.00	$26,468.00	$27,483.31	$29,108.32	$31,446.01
		Lodging (days)					130	$267.00	364	days	$12,634,440.00	$12,861,859.92	$13,355,240.87	$14,144,896.19	$15,280,872.81
		Lodging Tax (days)					130	$41.39	364	days	$1,958,574.80	$1,993,829.15	$2,070,312.43	$2,192,723.80	$2,368,821.44
		M&IE					130	$74.00	356	days	$3,424,720.00	$3,486,364.96	$3,620,101.92	$3,834,147.69	$4,142,068.09
		M&IE (first and last)					130	$55.50	8	3/4 days	$57,720.00	$58,758.96	$61,012.95	$64,620.47	$69,810.14
										Subtotal	$20,019,474.80	$20,379,825.35	$21,161,595.45	$22,412,817.10	$24,212,790.44

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $20,024,474.80 $20,384,915.35 $21,166,880.70 $22,418,414.85 $24,218,837.75

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

SI (Min) Instructions to Offerors: CLIN 0001 insert % of M&A. It will automatically populate the extended cost based on labor categories below for each PoP. CLIN 0002 insert fully burden hourly rates for each PoP labor categories, ensure the extended cost is populated with correct total. CLIN 0003 and CLIN 0004 are provided for evaluation purpose. CLIN 0002 insert fully burden hourly rates for each PoP labor categories, ensure the extended cost is populated with correct total. CLIN 0001, CLIN 0003, and CLIN 0004 are provided for evaluation purpose.

Position # 2
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		SITE INSPECTOR - minor to medium damage (100)
		Construction or Building Inspector (60)	First						30	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						25	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						5	320	$0.00	$0.00	$0.00	$0.00	$0.00
		Civil Engineer (40)	First						20	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						15	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						5	320	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	100
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00
CLIN 0003	Travel										Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
							Staff	Rate	Qty
		Airfare (roundtrip)					196	$750.00	1	trips	$147,000.00	$149,646.00	$155,386.42	$164,573.95	$177,790.89
		POV Travel Mileage (roundtrip)					196	$0.54	100	miles	$10,584.00	$10,774.51	$11,187.82	$11,849.32	$12,800.94
		Rental Car (weekly)					196	$175.00	8	weeks	$274,400.00	$279,339.20	$290,054.65	$307,204.71	$331,876.32
		Rental Car Fuel (weekly)					196	$50.00	8	weeks	$78,400.00	$79,811.20	$82,872.76	$87,772.78	$94,821.81
		Misc: Baggage Fees, Taxi, Metro					196	$50.00	1	trips	$9,800.00	$9,976.40	$10,359.09	$10,971.60	$11,852.73
		Lodging (days)					196	$267.00	56	days	$2,930,592.00	$2,983,342.66	$3,097,783.68	$3,280,946.34	$3,544,439.14
		Lodging Tax (days)					196	$41.39	56	days	$454,296.64	$462,473.98	$480,214.48	$508,608.12	$549,454.44
		M&IE					196	$74.00	54	days	$783,216.00	$797,313.89	$827,898.85	$876,850.02	$947,269.85
		M&IE (first and last)					196	$55.50	2	3/4 days	$21,756.00	$22,147.61	$22,997.19	$24,356.95	$26,313.05
										Subtotal	$4,710,044.64	$4,794,825.44	$4,978,754.95	$5,273,133.79	$5,696,619.17

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $4,715,044.64 $4,886,313.92 $5,175,227.98 $5,590,847.10 $6,160,647.62

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

PACL

Position # 3
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		PUBLIC ASSISTANCE CREW LEADER - PACL (25)
		Project Manager (25)	First
			Mid						5	2080	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						20	2080	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	25
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	25	$750.00	4	trips	$75,000.00	$76,350.00	$79,278.79	$83,966.30	$90,709.64
		POV Travel Mileage (roundtrip)	25	$0.54	100	miles	$1,350.00	$1,374.30	$1,427.02	$1,511.39	$1,632.77
		Rental Car (weekly)	25	$175.00	52	weeks	$227,500.00	$231,595.00	$240,478.98	$254,697.79	$275,152.56
		Rental Car Fuel (weekly)	25	$50.00	52	weeks	$65,000.00	$66,170.00	$68,708.28	$72,770.80	$78,615.02
		Misc: Baggage Fees, Taxi, Metro	25	$50.00	4	trips	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
		Lodging (days)	25	$267.00	364	days	$2,429,700.00	$2,473,434.60	$2,568,315.55	$2,720,172.34	$2,938,629.39
		Lodging Tax (days)	25	$41.39	364	days	$376,649.00	$383,428.68	$398,137.01	$421,677.65	$455,542.59
		M&IE	25	$74.00	356	days	$658,600.00	$670,454.80	$696,173.45	$737,336.09	$796,551.56
		M&IE (first and last)	25	$55.50	8	3/4 days	$11,100.00	$11,299.80	$11,733.26	$12,427.01	$13,425.03
						Subtotal	$3,849,899.00	$3,919,197.18	$4,069,537.59	$4,310,157.13	$4,656,305.85

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $3,854,899.00 $3,994,924.35 $4,231,133.04 $4,570,932.53 $5,036,786.75

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

Proj Spc CLIN 0002 insert fully burden hourly rates for each PoP labor categories, ensure the extended cost is populated with correct total. CLIN 0001, CLIN 0003, and CLIN 0004 are provided for evaluation purpose.

Position # 4
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		PROJECT SPECIALIST - minor to medium damage (60)*
		Construction or Building Inspector (20)	First						10	1040	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						6	1040	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						4	1040	$0.00	$0.00	$0.00	$0.00	$0.00
		Civil Engineer (40)	First						20	1040	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						14	1040	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						6	1040	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	60
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	50	$750.00	2	trips	$75,000.00	$76,350.00	$79,278.79	$83,966.30	$90,709.64
		POV Travel Mileage (roundtrip)	50	$0.54	100	miles	$2,700.00	$2,748.60	$2,854.04	$3,022.79	$3,265.55
		Rental Car (weekly)	50	$175.00	26	weeks	$227,500.00	$231,595.00	$240,478.98	$254,697.79	$275,152.56
		Rental Car Fuel (weekly)	50	$50.00	26	weeks	$65,000.00	$66,170.00	$68,708.28	$72,770.80	$78,615.02
		Misc: Baggage Fees, Taxi, Metro	50	$50.00	2	trips	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
		Lodging (days)	50	$267.00	182	days	$2,429,700.00	$2,473,434.60	$2,568,315.55	$2,720,172.34	$2,938,629.39
		Lodging Tax (days)	50	$41.39	182	days	$376,649.00	$383,428.68	$398,137.01	$421,677.65	$455,542.59
		M&IE	50	$74.00	178	days	$658,600.00	$670,454.80	$696,173.45	$737,336.09	$796,551.56
		M&IE (first and last)	50	$55.50	4	3/4 days	$11,100.00	$11,299.80	$11,733.26	$12,427.01	$13,425.03
						Subtotal	$3,851,249.00	$3,920,571.48	$4,070,964.60	$4,311,668.53	$4,657,938.63

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $3,856,249.00 $3,996,323.39 $4,232,614.80 $4,572,533.29 $5,038,550.65

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

SI (Maj) CLIN 0002 insert fully burden hourly rates for each PoP labor categories, ensure the extended cost is populated with correct total. CLIN 0001, CLIN 0003, and CLIN 0004 are provided for evaluation purpose.

Position # 5
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		SITE INSPECTOR/PROJECT SPECIALIST - major damage (65)
		Civil Engineer (9)	First						5	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						3	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
		Electrical Engineer (8)	First						5	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
		Structural Engineer (8)	First						4	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						3	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
		Engineering Technician (7)	First						4	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
		Mechanical Engineer (6)	First						3	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
		Soil/Geotechnical Engineer (6)	First						3	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
		Architect (5)	First						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
		Geologist (5)	First						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
		Hydrologist (5)	First						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
		Coastal Engineer (1)	First
			Mid						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Environmental Engineer (1)	First
			Mid						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Hydraulic Engineer (1)	First
			Mid						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Sanitary Engineer (1)	First
			Mid						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Health Scientist (1)	First
			Mid						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Industrial Hygienist (1)	First
			Mid						1	120	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
								Total Staff	65
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	64	$750.00	1	trips	$48,000.00	$48,864.00	$50,738.42	$53,738.43	$58,054.17
		POV Travel Mileage (roundtrip)	64	$0.54	100	miles	$3,456.00	$3,518.21	$3,653.17	$3,869.17	$4,179.90
		Rental Car (weekly)	64	$175.00	2	weeks	$22,400.00	$22,803.20	$23,677.93	$25,077.94	$27,091.94
		Rental Car Fuel (weekly)	64	$50.00	2	weeks	$6,400.00	$6,515.20	$6,765.12	$7,165.12	$7,740.56
		Misc: Baggage Fees, Taxi, Metro	64	$50.00	1	trips	$3,200.00	$3,257.60	$3,382.56	$3,582.56	$3,870.28
		Lodging (days)	64	$267.00	14	days	$239,232.00	$243,538.18	$252,880.30	$267,832.35	$289,341.97
		Lodging Tax (days)	64	$41.39	14	days	$37,085.44	$37,752.98	$39,201.18	$41,519.03	$44,853.42
		M&IE	64	$74.00	12	days	$56,832.00	$57,854.98	$60,074.29	$63,626.31	$68,736.13
		M&IE (first and last)	64	$55.50	2	3/4 days	$7,104.00	$7,231.87	$7,509.29	$7,953.29	$8,592.02
						Subtotal	$423,709.44	$431,336.21	$447,882.27	$474,364.20	$512,460.39

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $428,709.44 $444,281.88 $470,551.03 $508,340.67 $560,149.05

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

CPA

Position # 6
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		CERTIFIED PUBLIC ACCOUNTANT (CPA), FINANCIAL ANALYST & ACCOUNTANT (17)
		Certified Public Accountant (3)	First						1	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						1	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	480	$0.00	$0.00	$0.00	$0.00	$0.00
		Financial Analyst (13)	First						3	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						6	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						4	480	$0.00	$0.00	$0.00	$0.00	$0.00
		Accountant (1)	First
			Mid						1	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
								Total Staff	17
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	37	$750.00	1	trips	$27,750.00	$28,249.50	$29,333.15	$31,067.53	$33,562.57
		POV Travel Mileage (roundtrip)	37	$0.54	100	miles	$1,998.00	$2,033.96	$2,111.99	$2,236.86	$2,416.50
		Rental Car (weekly)	37	$175.00	12	weeks	$77,700.00	$79,098.60	$82,132.82	$86,989.09	$93,975.18
		Rental Car Fuel (weekly)	37	$50.00	12	weeks	$22,200.00	$22,599.60	$23,466.52	$24,854.03	$26,850.05
		Misc: Baggage Fees, Taxi, Metro	37	$50.00	1	trips	$1,850.00	$1,883.30	$1,955.54	$2,071.17	$2,237.50
		Lodging (days)	37	$267.00	84	days	$829,836.00	$844,773.05	$877,178.54	$929,043.48	$1,003,654.96
		Lodging Tax (days)	37	$41.39	84	days	$128,640.12	$130,955.64	$135,979.10	$144,019.14	$155,585.31
		M&IE	37	$74.00	82	days	$224,516.00	$228,557.29	$237,324.75	$251,357.05	$271,543.53
		M&IE (first and last)	37	$55.50	2	3/4 days	$4,107.00	$4,180.93	$4,341.31	$4,597.99	$4,967.26
						Subtotal	$1,318,597.12	$1,342,331.87	$1,393,823.72	$1,476,236.33	$1,594,792.87

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $1,323,597.12 $1,371,675.46 $1,452,778.79 $1,569,450.49 $1,729,403.66

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

Cost.

Position # 7
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		COSTING SPECIALIST (6)
		Estimator (6)	First						1	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						3	480	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	6
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	20	$750.00	1	trips	$15,000.00	$15,270.00	$15,855.76	$16,793.26	$18,141.93
		POV Travel Mileage (roundtrip)	20	$0.54	100	miles	$1,080.00	$1,099.44	$1,141.61	$1,209.11	$1,306.22
		Rental Car (weekly)	20	$175.00	12	weeks	$42,000.00	$42,756.00	$44,396.12	$47,021.13	$50,797.40
		Rental Car Fuel (weekly)	20	$50.00	12	weeks	$12,000.00	$12,216.00	$12,684.61	$13,434.61	$14,513.54
		Misc: Baggage Fees, Taxi, Metro	20	$50.00	1	trips	$1,000.00	$1,018.00	$1,057.05	$1,119.55	$1,209.46
		Lodging (days)	20	$267.00	84	days	$448,560.00	$456,634.08	$474,150.56	$502,185.66	$542,516.19
		Lodging Tax (days)	20	$41.39	84	days	$69,535.20	$70,786.83	$73,502.22	$77,848.18	$84,100.17
		M&IE	20	$74.00	82	days	$121,360.00	$123,544.48	$128,283.65	$135,868.67	$146,780.29
		M&IE (first and last)	20	$55.50	2	3/4 days	$2,220.00
						Subtotal	$712,755.20	$723,324.83	$751,071.57	$795,480.18	$859,365.20

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $717,755.20 $741,526.30 $785,370.67 $848,443.27 $934,913.78

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

Mit.

Position # 8
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		MITIGATION SPECIALIST (5)
		Civil Engineer (5)	First						1	240	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	240	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						2	240	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	5
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	10	$750.00	1	trips	$7,500.00	$7,635.00	$7,927.88	$8,396.63	$9,070.96
		POV Travel Mileage (roundtrip)	10	$0.54	100	miles	$540.00	$549.72	$570.81	$604.56	$653.11
		Rental Car (weekly)	10	$175.00	12	weeks	$21,000.00	$21,378.00	$22,198.06	$23,510.56	$25,398.70
		Rental Car Fuel (weekly)	10	$50.00	12	weeks	$6,000.00	$6,108.00	$6,342.30	$6,717.30	$7,256.77
		Misc: Baggage Fees, Taxi, Metro	10	$50.00	1	trips	$500.00	$509.00	$528.53	$559.78	$604.73
		Lodging (days)	10	$267.00	84	days	$224,280.00	$228,317.04	$237,075.28	$251,092.83	$271,258.10
		Lodging Tax (days)	10	$41.39	84	days	$34,767.60	$35,393.42	$36,751.11	$38,924.09	$42,050.08
		M&IE	10	$74.00	82	days	$60,680.00	$61,772.24	$64,141.82	$67,934.34	$73,390.14
		M&IE (first and last)	10	$55.50	2	3/4 days	$1,110.00	$1,129.98	$1,173.33	$1,242.70	$1,342.50
						Subtotal	$356,377.60	$362,792.40	$376,709.11	$398,982.79	$431,025.10

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $361,377.60 $374,504.28 $396,647.67 $428,502.18 $472,173.70

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

Ins.

Position # 9
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		INSURANCE SPECIALISTS (4)
		Commercial Property Insurance Professional (4)	First						1	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						1	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						2	480	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	4
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	10	$750.00	1	trips	$7,500.00	$7,635.00	$7,927.88	$8,396.63	$9,070.96
		POV Travel Mileage (roundtrip)	10	$0.54	100	miles	$540.00	$549.72	$570.81	$604.56	$653.11
		Rental Car (weekly)	10	$175.00	12	weeks	$21,000.00	$21,378.00	$22,198.06	$23,510.56	$25,398.70
		Rental Car Fuel (weekly)	10	$50.00	12	weeks	$6,000.00	$6,108.00	$6,342.30	$6,717.30	$7,256.77
		Misc: Baggage Fees, Taxi, Metro	10	$50.00	1	trips	$500.00	$509.00	$528.53	$559.78	$604.73
		Lodging (days)	10	$267.00	84	days	$224,280.00	$228,317.04	$237,075.28	$251,092.83	$271,258.10
		Lodging Tax (days)	10	$41.39	84	days	$34,767.60	$35,393.42	$36,751.11	$38,924.09	$42,050.08
		M&IE	10	$74.00	82	days	$60,680.00	$61,772.24	$64,141.82	$67,934.34	$73,390.14
		M&IE (first and last)	10	$55.50	2	3/4 days	$1,110.00	$1,129.98	$1,173.33	$1,242.70	$1,342.50
						Subtotal	$356,377.60	$362,792.40	$376,709.11	$398,982.79	$431,025.10

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $361,377.60 $374,504.28 $396,647.67 $428,502.18 $472,173.70

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

EHP

Position # 10
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		ENVIRONMENTAL & HISTORIC PRESERVATION (EHP) SPECIALIST (25)
		Environmental Planner (8)	First						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						6	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
		Biologist (5)	First						2	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
		Archaeologist (5)	First						2	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid						2	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
		Architectural Historian (1)	First
			Mid						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Historic Architect (1)	First
			Mid						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Certified Flood Plain Manager (1)	First
			Mid						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Wetlands Specialist (1)	First
			Mid						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Water Quality Specialist (1)	First
			Mid						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Ecologist (1)	First
			Mid						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Horticulturalist (1)	First
			Mid						1	320	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
								Total Staff	25
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	13	$750.00	1	trips	$9,750.00	$9,925.50	$10,306.24	$10,915.62	$11,792.25
		POV Travel Mileage (roundtrip)	13	$0.54	100	miles	$702.00	$714.64	$742.05	$785.92	$849.04
		Rental Car (weekly)	13	$175.00	8	weeks	$18,200.00	$18,527.60	$19,238.32	$20,375.82	$22,012.21
		Rental Car Fuel (weekly)	13	$50.00	8	weeks	$5,200.00	$5,293.60	$5,496.66	$5,821.66	$6,289.20
		Misc: Baggage Fees, Taxi, Metro	13	$50.00	1	trips	$650.00	$661.70	$687.08	$727.71	$786.15
		Lodging (days)	13	$267.00	56	days	$194,376.00	$197,874.77	$205,465.24	$217,613.79	$235,090.35
		Lodging Tax (days)	13	$41.39	56	days	$30,131.92	$30,674.29	$31,850.96	$33,734.21	$36,443.41
		M&IE	13	$74.00	54	days	$51,948.00	$52,883.06	$54,911.66	$58,158.42	$62,829.12
		M&IE (first and last)	13	$55.50	2	3/4 days	$1,443.00	$1,468.97	$1,525.32	$1,615.51	$1,745.25
						Subtotal	$312,400.92	$318,024.14	$330,223.54	$349,748.67	$377,836.99

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $317,400.92 $328,930.19 $348,378.91 $376,356.99 $414,714.04

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

Comp CLIN 0002 insert fully burden hourly rates for each PoP labor categories, ensure the extended cost is populated with correct total. CLIN 0001, CLIN 0003, and CLIN 0004 are provided for evaluation purpose.

Position # 11
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002

Labor

POSITION - LABOR CATEGORY/SKILL SET (Qty)

Level

Base Rate

OP 1 Rate

OP 2 Rate

OP 3 Rate

OP 4 Rate

Qty

Total Hours

Base Extended Cost

OP 1 Extended Cost

OP 2 Extended Cost

OP 3 Extended Cost

OP 4 Extended Cost

DATABASE DEVELOPER (1)

Computer Specialist (1)

First

Mid

480

$0.00

Senior

Total Staff

Subtotal

$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	2	$750.00	1	trips	$1,500.00	$1,527.00	$1,585.58	$1,679.33	$1,814.19
		POV Travel Mileage (roundtrip)	2	$0.54	100	miles	$108.00	$109.94	$114.16	$120.91	$130.62
		Rental Car (weekly)	2	$175.00	12	weeks	$4,200.00	$4,275.60	$4,439.61	$4,702.11	$5,079.74
		Rental Car Fuel (weekly)	2	$50.00	12	weeks	$1,200.00	$1,221.60	$1,268.46	$1,343.46	$1,451.35
		Misc: Baggage Fees, Taxi, Metro	2	$50.00	1	trips	$100.00	$101.80	$105.71	$111.96	$120.95
		Lodging (days)	2	$267.00	84	days	$44,856.00	$45,663.41	$47,415.06	$50,218.57	$54,251.62
		Lodging Tax (days)	2	$41.39	84	days	$6,953.52	$7,078.68	$7,350.22	$7,784.82	$8,410.02
		M&IE	2	$74.00	82	days	$12,136.00	$12,354.45	$12,828.36	$13,586.87	$14,678.03
		M&IE (first and last)	2	$55.50	2	3/4 days	$222.00	$226.00	$234.67	$248.54	$268.50
						Subtotal	$71,275.52	$72,558.48	$75,341.82	$79,796.56	$86,205.02

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $76,275.52 $79,046.15 $83,719.93 $90,443.42 $99,661.11

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

Appr.

Position # 12
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		APPRAISER (2)
		Appraiser (2)	First
			Mid						1	318	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	318	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	2
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	2	$750.00	1	trips	$1,500.00	$1,527.00	$1,585.58	$1,679.33	$1,814.19
		POV Travel Mileage (roundtrip)	2	$0.54	100	miles	$108.00	$109.94	$114.16	$120.91	$130.62
		Rental Car (weekly)	2	$175.00	8	weeks	$2,800.00	$2,850.40	$2,959.74	$3,134.74	$3,386.49
		Rental Car Fuel (weekly)	2	$50.00	8	weeks	$800.00	$814.40	$845.64	$895.64	$967.57
		Misc: Baggage Fees, Taxi, Metro	2	$50.00	1	trips	$100.00	$101.80	$105.71	$111.96	$120.95
		Lodging (days)	2	$267.00	56	days	$29,904.00	$30,442.27	$31,610.04	$33,479.04	$36,167.75
		Lodging Tax (days)	2	$41.39	56	days	$4,635.68	$4,719.12	$4,900.15	$5,189.88	$5,606.68
		M&IE	2	$74.00	54	days	$7,992.00	$8,135.86	$8,447.95	$8,947.45	$9,666.02
		M&IE (first and last)	2	$55.50	2	3/4 days	$222.00	$226.00	$234.67	$248.54	$268.50
						Subtotal	$48,061.68	$48,926.79	$50,803.62	$53,807.49	$58,128.77

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $53,061.68 $54,989.09 $58,240.44 $62,917.69 $69,330.06

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

Doc-Tng Instructions to Offerors: CLIN 0001 insert % of M&A. It will automatically populate the extended cost based on labor categories below for each PoP. CLIN 0002 insert fully burden hourly rates for each PoP labor categories, ensure the extended cost is populated with correct total. CLIN 0003 and CLIN 0004 are provided for evaluation purpose. CLIN 0002 insert fully burden hourly rates for each PoP labor categories, ensure the extended cost is populated with correct total. CLIN 0001, CLIN 0003, and CLIN 0004 are provided for evaluation purpose.

Position # 13
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		DOCUMENT & TRAINING DEVELOPMENT SPECIALIST (6)
		General Planner (2)	First						1	645	$0.00	$0.00	$0.00	$0.00	$0.00
			Mid
			Senior						1	645	$0.00	$0.00	$0.00	$0.00	$0.00
		Technical Writer (2)	First
			Mid						1	645	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	645	$0.00	$0.00	$0.00	$0.00	$0.00
		Graphic Artist (2)	First
			Mid						1	645	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior						1	645	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	6
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	6	$750.00	1	trips	$4,500.00	$4,581.00	$4,756.73	$5,037.98	$5,442.58
		POV Travel Mileage (roundtrip)	6	$0.54	100	miles	$324.00	$329.83	$342.48	$362.73	$391.87
		Rental Car (weekly)	6	$175.00	16	weeks	$16,800.00	$17,102.40	$17,758.45	$18,808.45	$20,318.96
		Rental Car Fuel (weekly)	6	$50.00	16	weeks	$4,800.00	$4,886.40	$5,073.84	$5,373.84	$5,805.42
		Misc: Baggage Fees, Taxi, Metro	6	$50.00	1	trips	$300.00	$305.40	$317.12	$335.87	$362.84
		Lodging (days)	6	$267.00	112	days	$179,424.00	$182,653.63	$189,660.23	$200,874.27	$217,006.48
		Lodging Tax (days)	6	$41.39	112	days	$27,814.08	$28,314.73	$29,400.89	$31,139.27	$33,640.07
		M&IE	6	$74.00	110	days	$48,840.00	$49,719.12	$51,626.35	$54,678.86	$59,070.12
		M&IE (first and last)	6	$55.50	2	3/4 days	$666.00	$677.99	$704.00	$745.62	$805.50
						Subtotal	$283,468.08	$288,570.51	$299,640.07	$317,356.89	$342,843.82

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $288,468.08 $298,946.39 $316,622.26 $342,049.98 $376,910.58

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

CEF

Position # 14
CLIN 0001	M&A	Baseline for M&A is not to exceed 3% of Total Labor Cost	M&A	3%	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
				Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0002	Labor	POSITION - LABOR CATEGORY/SKILL SET (Qty)	Level	Base Rate	OP 1 Rate	OP 2 Rate	OP 3 Rate	OP 4 Rate	Qty	Total Hours	Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		COST ESTIMATING FORMAT (CEF) IMPLEMENTATION SPECIALIST (4)
		Technical Writer (1)	First
			Mid						1	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Graphic Artist (1)	First
			Mid						1	480	$0.00	$0.00	$0.00	$0.00	$0.00
			Senior
		Estimator (1)	First
			Mid
			Senior						1	240	$0.00	$0.00	$0.00	$0.00	$0.00
		General Planners (1)	First
			Mid
			Senior						1	240	$0.00	$0.00	$0.00	$0.00	$0.00
								Total Staff	4
										Subtotal	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 0003	Travel						Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
			Staff	Rate	Qty
		Airfare (roundtrip)	4	$750.00	1	trips	$3,000.00	$3,054.00	$3,171.15	$3,358.65	$3,628.39
		POV Travel Mileage (roundtrip)	4	$0.54	100	miles	$216.00	$219.89	$228.32	$241.82	$261.24
		Rental Car (weekly)	4	$175.00	12	weeks	$8,400.00	$8,551.20	$8,879.22	$9,404.23	$10,159.48
		Rental Car Fuel (weekly)	4	$50.00	12	weeks	$2,400.00	$2,443.20	$2,536.92	$2,686.92	$2,902.71
		Misc: Baggage Fees, Taxi, Metro	4	$50.00	1	trips	$200.00	$203.60	$211.41	$223.91	$241.89
		Lodging (days)	4	$267.00	84	days	$89,712.00	$91,326.82	$94,830.11	$100,437.13	$108,503.24
		Lodging Tax (days)	4	$41.39	84	days	$13,907.04	$14,157.37	$14,700.44	$15,569.64	$16,820.03
		M&IE	4	$74.00	82	days	$24,272.00	$24,708.90	$25,656.73	$27,173.73	$29,356.06
		M&IE (first and last)	4	$55.50	2	3/4 days	$444.00	$451.99	$469.33	$497.08	$537.00
						Subtotal	$142,551.04	$145,116.96	$150,683.65	$159,593.12	$172,410.04

CLIN 0004	ODC			Base Extended Cost	OP 1 Extended Cost	OP 2 Extended Cost	OP 3 Extended Cost	OP 4 Extended Cost
		Material Handling Cost		$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31
			Subtotal	$5,000.00	$5,090.00	$5,285.25	$5,597.75	$6,047.31

Total $147,551.04 $152,910.68 $161,951.86 $174,958.11 $192,789.26

Inflation Escalation	2018	2019	2020	2021
	1.018	1.03836	1.059127	1.08031

File details come from the government source that posted it. Updated Nov 14, 2017.