HSFE60-16-R-0004_Attachment_C_dated_Aug_10_2016.xlsx

XLSX spreadsheet 26 KB Posted Aug 11, 2016

Attached to: National Flood Insurance Program (NFIP) Direct Servicing Agent (DSA) Federal contract opportunity
Solicitation number: HSFE60-16-R-0004
Issued by: Federal Emergency Management Agency Recovery Section

About this file

From the source

HSFE60-16-R-0004 A00002 Attachment C Price Evaluation Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to National Flood Insurance Program (NFIP) Direct Servicing Agent (DSA), newest first.
File	Type	Posted
HSFE60-16-R-0004_Corrected_Attachment_D_dated__8_14_2016.xlsx	XLSX spreadsheet	Aug 16, 2016
HSFE60-16-R-0004_Amendment_A00004_Aug_12_2016.pdf	PDF	Aug 16, 2016
HSFE60-16-R-0004_Amendment_A00003_final_Aug_15.pdf	PDF	Aug 15, 2016
2016_08_14_HSFE60-16-R-0004_A00003_Revised_Attachment_C.xlsx	XLSX spreadsheet	Aug 15, 2016
2016_08_14_HSFE60-16-R-0004_A00003_Attachment_D.pdf	PDF	Aug 15, 2016
2016_08_10_HSFE60-16-R-0004_Attachment_F_-_DSA_Call_Volume.pdf	PDF	Aug 11, 2016
2016_08_10_HSFE60-16-R-0004_Attachment_E_Historical_Policy_Information_C....pdf	PDF	Aug 11, 2016
2016_08_10_HSFE60-16-R-0004_Attachment_B_QASP_Revised.pdf	PDF	Aug 11, 2016
HSFE60-16-R-0004_Attachment_D_dated_Aug_10_2016.pdf	PDF	Aug 11, 2016
2016_06_21_HSFE60-16-R-0004_Attachment_G_DSA_Requirements_Traceability_M....pdf	PDF	Aug 11, 2016
2016_08_10_HSFE60-16-R-0004_Attachment_A_SOO_Revised.pdf	PDF	Aug 11, 2016
HSFE60-16-R-0004_A00002_posted.pdf	PDF	Aug 11, 2016
HSFE60-16-R-0004_A00001_posted_Aug_10.pdf	PDF	Aug 10, 2016
HSFE60-16-R-0004_Attachment_B.pdf	PDF	Jul 22, 2016
HSFE60-16-R-0004_Attachment_C.xlsx	XLSX spreadsheet	Jul 22, 2016
HSFE60-16-R-0004_Attachment_D.xlsx	XLSX spreadsheet	Jul 22, 2016
RFP_HSFE60-16-R-0004_posted_July_22.pdf	PDF	Jul 22, 2016
HSFE60-16-R-0004_Attachment_E.pdf	PDF	Jul 22, 2016
HSFE60-16-R-0004_Attachment_A.pdf	PDF	Jul 22, 2016

Show all 19

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.

Tab A - CX Lab Evaluated Price

HSFE60-16-R-0004 Attachment C Price Evaluation Worksheet August 10, 2016
Attachment C Price Worksheet Customer Experience Lab Price/Schedule and Evaluated Price Worksheet												Option Year 3
Tab A			Base Year			Option Year 1			Option Year 2	Option Year-3	Proposed Rate	Total Amount Column K x L
	Base Year	***Proposed Rate	Total Amount Column B X C	Option Year-1	Proposed Rate	Total Amount Column E X F	Option Year-2	Proposed Rate	Total Amount Column H X I	Evaluated Hours
* Direct Labor	** Evaluated Hours			Evaluated Hours			Evaluated Hours			1260	$	$
Consultant 1	1,260	$	$	1260	$	$	1260	$	$	1260	$	$
Consultant 2 - Claims	1,260	$	$	1260	$	$	1260	$	$	1260	$	$
Consultant 3 - Underwriting	1,260	$	$	1260	$	$	1260	$	$	1260	$	$
Consultant 4 – Information Technology	1,260	$	$	1260	$	$	1260	$	$	1260	$	$
Consultant 5 – Risk Analysis	1,260	$	$	1260	$	$	1260	$	$	1260	$	$
Project Manager	1,260	$	$	1260	$	$	1260	$	$	980	$	$
Customer Experience SME	980	$	$	980	$	$	980	$	$	840	$	$
Engagement Director	840	$	$	840	$	$	840	$	$	644	$	$
Senior Executive	644	$	$	644	$	$	644	$	$	Total Evaluated Price Option Year-3		$
	Total Evaluated Price Base Year		$	Total Evaluated Price Option Year-1		$	Total Evaluated Price Option Year-2		$
												$
									Grand Total Evaluated Price -Base & all Option Years
* Only labor categories and rates set forth in the price schedule may be used for task order pricing. The Government reserves the right to negotiate additional labor categories to this schedule as needed for task orders.
** The specified hours for the base period and each option year are for evaluation purposes only. The actual number of hours needed will vary as set forth in task order requirements.
*** Proposed rates shall be fully burdened labor rates which shall apply to for pricing of all task orders during the specified period of performance.
**** All task orders for the customer experience laboratory will be issued on a fixed price basis. No material handling fee, G&A, or any fee of any sort shall be applied to any necessary other direct costs or travel negotiated for task orders.

Tab B- Contract Evaluated Price

HSFE60-16-R-0004 Attachment C Price Evaluation Worksheet August 10, 2016
Tab-B	Contract Price Evaluation Worksheet
Base Ordering Period: 12 months after effective date of contract award (ATO and Transition must be completed prior to issuing task orders for the following services)

	CLIN
Number	Sub
CLIN	Title	Tier	Description	Type	Unit of
Issuance	*Unit Rate	**Evaluated Quantity	Total Amount (column H x I)
	0001	0001A	Standard Flood Insurance Policies (SFIP)	Zero through 300,000	Administration and Servicing of Standard Flood Insurance Policies (SFIPs) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP provided as attachments A & B of the RFP for up to 6 months of performance as set forth in task orders during the base period of the contract	Fixed Rate	Per Policy/Per Month	$	6622	$
		0001B		300,001 through 450,000		Fixed Rate	Per Policy/Per Month	$	9933	$
		0001C		450,001 through 600,000		Fixed Rate	Per Policy/Per Month	$	82774	$
		0001D		600,001 through 750,000		Fixed Rate	Per Policy/Per Month	$	215211	$
		0001E		750,001 through 900,000		Fixed Rate	Per Policy/Per Month	$	9933	$
		0001F		900,001 and over		Fixed Rate	Per Policy/Per Month	$	6622	$
	0002	0002A	Group Flood Insurance Policies (GFIP)	Zero Through 10,000	Administration and Servicing of Group Flood Insurance Policies (GFIPs) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP of the RFP for up to 6 months of performance as set forth in task orders during the base period of the contract	Fixed Rate	Per Policy/Per Month	$	716	$
		0002B		10,001 through 20,000		Fixed Rate	Per Policy/Per Month	$	134	$
		0002C		20,001 and over		Fixed Rate	Per Policy/Per Month	$	45	$
	0003	0003A	Severe/Repetitive Loss Target Group Policies (S/RLTGP)	Zero Through 10,000	Administration and Servicing of Severe/Repetitive Loss Target Group Policies (S/RLTGP) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP of the RFP for up to 6 months of performance as set forth in task orders during the base period of the contract	Fixed Rate	Per Policy/Per Month	$	214	$
		0003B		10,001 through 20,000		Fixed Rate	Per Policy/Per Month	$	4930	$
		0003C		20,001 through 30,000		Fixed Rate	Per Policy/Per Month	$	5359	$
		0003D		30,001 and over		Fixed Rate	Per Policy/Per Month	$	214	$
	0004	N/A	Customer Experience Laboratory Support	N/A	All efforts needed to provide a laboratory environment to test the effectiveness of customer experience initiatives during the base period of the contract	Fixed Price	Fixed Priced per job as set forth in task orders	N/A	1	Insert total amount from Tab A for CX Base Period
	Total evaluated price for base ordering period (CLINS 0001 through 0004)									$
	Option I Ordering Period: 12 months after effective date of option exercise
	CLIN
Number	Sub
CLIN	Title	Tier	Description	Type	Unit of
Issuance	*Unit Rate	**Evaluated Quantity	Total Amount (column H x I)
	1001	1001a	Standard Flood Insurance Policies (SFIP)	Zero through 300,000	Administration and Servicing of Standard Flood Insurance Policies (SFIPs) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP provided as attachments A & B of the RFP for up to 12 months of performance as set forth in task orders during optional period 1 ordering period	Fixed Rate	Per Policy/Per Month	$	13,244	$
		1001b		300,001 through 450,000		Fixed Rate	Per Policy/Per Month	$	19,866	$
		1001c		450,001 through 600,000		Fixed Rate	Per Policy/Per Month	$	165,547	$
		1001d		600,001 through 750,000		Fixed Rate	Per Policy/Per Month	$	430,423	$
		1001e		750,001 through 900,000		Fixed Rate	Per Policy/Per Month	$	19,866	$
		1001f		900,001 and over		Fixed Rate	Per Policy/Per Month	$	13,244	$
	1002	1002a	Group Flood Ins Policies (GFIP)	Zero Through 10,000	Administration and Servicing of Group Flood Insurance Policies (GFIPs) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP of the RFP for up to 12 months of performance as set forth in task orders during option period 1 ordering period	Fixed Rate	Per Policy/Per Month	$	1,431	$
		1002b		10,001 through 20,000		Fixed Rate	Per Policy/Per Month	$	268	$
		1002c		20,001 and over		Fixed Rate	Per Policy/Per Month	$	89	$
	1003	1003a	Repetitive Loss Target Group Policies (S/RLTGP)	Zero Through 10,000	Administration and Servicing of Severe/Repetitive Loss Target Group Policies (S/RLTGP) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP of the RFP for up to 12 months of performance as set forth in task orders during option period 1 ordering period	Fixed Rate	Per Policy/Per Month	$	429	$
		1003b		10,001 through 20,000		Fixed Rate	Per Policy/Per Month	$	9,860	$
		1003c		20,001 through 30,000		Fixed Rate	Per Policy/Per Month	$	10,718	$
		1003d		30,001 and over		Fixed Rate	Per Policy/Per Month	$	429	$
	1004	N/A	Customer Experience Laboratory Support	N/A	All efforts needed to provide a laboratory environment to test the effectiveness of customer experience initiatives as set forth in task orders during option period 1 ordering period	Fixed Price	Fixed Priced per job as set forth in task orders	$		Insert total amount from Tab A for CX Option Period 1
	Total evaluated price for Option Ordering Period-1 (CLINs 1001 - 1004)									$
	Option 2 Ordering Period: 12 months after effective date of option exercise
	CLIN
Number	Sub
CLIN	Title	Tier	Description	Type	Unit of
Issuance	*Rate	**Evaluated Quantity	Total Amount (column H x I)
	2001	2001a	Standard Flood Insurance Policies (SFIP)	Zero through 300,000	Administration and Servicing of Standard Flood Insurance Policies (SFIPs) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP provided as attachments A & B of the RFP for up to 12 months of performance as set forth in task orders during optional period 2 ordering period	Fixed Rate	Per Policy/Per Month	$	13,244	$
		2001b		300,001 through 450,000		Fixed Rate	Per Policy/Per Month	$	19,866	$
		2001c		450,001 through 600,000		Fixed Rate	Per Policy/Per Month	$	165,547	$
		2001d		600,001 through 750,000		Fixed Rate	Per Policy/Per Month	$	430,423	$
		2001e		750,001 through 900,000		Fixed Rate	Per Policy/Per Month	$	19,866	$
		2001f		900,001 and over		Fixed Rate	Per Policy/Per Month	$	13,244	$
	2002	2002a	Group Flood Ins Policies (GFIP)	Zero Through 10,000	Administration and Servicing of Group Flood Insurance Policies (GFIPs) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP of the RFP for up to 12 months of performance as set forth in task orders during option period 2 ordering period	Fixed Rate	Per Policy/Per Month	$	1,431	$
		2002b		10,001 through 20,000		Fixed Rate	Per Policy/Per Month	$	268	$
		2002c		20,001 and over		Fixed Rate	Per Policy/Per Month	$	89	$
	2003	2003a	Repetitive Loss Target Group Policies (S/RLTGP)	Zero Through 10,000	Administration and Servicing of Severe/Repetitive Loss Target Group Policies (S/RLTGP) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP of the RFP for up to 12 months of performance as set forth in task orders during option period 2 ordering period	Fixed Rate	Per Policy/Per Month	$	429	$
		2003b		10,001 through 20,000		Fixed Rate	Per Policy/Per Month	$	9,860	$
		2003c		20,001 through 30,000		Fixed Rate	Per Policy/Per Month	$	10,718	$
		2003d		30,001 and over		Fixed Rate	Per Policy/Per Month	$	429	$
	2004	N/A	Customer Experience Laboratory Support	N/A	All efforts needed to provide a laboratory environment to test the effectiveness of customer experience initiatives as set forth in task orders during option period 2 ordering period	Fixed Price	Fixed Priced per job as set forth in task orders	$		Insert total amount from Tab A for CX Option Period 2
	Total evaluated price for Option Ordering Period -2 (CLINs 2001 - 2004)									$
	Option 3 Ordering Period: 12 months after effective date of option exercise
	CLIN
Number	Sub
CLIN	Title	Tier	Description	Type	Unit of
Issuance	*Rate	**Evaluated Quantity	Total Amount (column H x I)
	3001		Transition Period - Phase Out	N/A	Full support of the transitional efforts from the incumbent contract to the awardee in accordance to the DSA SOO.	Fixed Price for the job (1 lot)	Lot	$	1	$
	3002	3002a	Standard Flood Insurance Policies (SFIP)	Zero through 300,000	Administration and Servicing of Standard Flood Insurance Policies (SFIPs) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP provided as attachments A & B of the RFP for up to 12 months of performance as set forth in task orders during optional period 3 ordering period	Fixed Rate	Per Policy/Per Month	$	13,244	$
		3002b		300,001 through 450,000		Fixed Rate	Per Policy/Per Month	$	19,866	$
		3002c		450,001 through 600,000		Fixed Rate	Per Policy/Per Month	$	165,547	$
		3002d		600,001 through 750,000		Fixed Rate	Per Policy/Per Month	$	430,423	$
		3002e		750,001 through 900,000		Fixed Rate	Per Policy/Per Month	$	19,866	$
		3002f		900,001 and over		Fixed Rate	Per Policy/Per Month	$	13,244	$
	3003	3003a	Group Flood Ins Policies (GFIP)	Zero Through 10,000	Administration and Servicing of Group Flood Insurance Policies (GFIPs) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP of the RFP for up to 12 months of performance as set forth in task orders during option period 3 ordering period	Fixed Rate	Per Policy/Per Month	$	1,431	$
		3003b		10,001 through 20,000		Fixed Rate	Per Policy/Per Month	$	268	$
		3003c		20,001 and over		Fixed Rate	Per Policy/Per Month	$	89	$
	3004	3004a	Repetitive Loss Target Group Policies (S/RLTGP)	Zero Through 10,000	Administration and Servicing of Severe/Repetitive Loss Target Group Policies (S/RLTGP) - regardless if policies are new, current or endorsed in accordance with the DSA/SOO & QASP of the RFP for up to 12 months of performance as set forth in task orders during option period 3 ordering period	Fixed Rate	Per Policy/Per Month	$	429	$
		3004b		10,001 through 20,000		Fixed Rate	Per Policy/Per Month	$	9,860	$
		3004c		20,001 through 30,000		Fixed Rate	Per Policy/Per Month	$	10,718	$
		3004d		30,001 and over		Fixed Rate	Per Policy/Per Month	$	429	$
	3005	N/A	Customer Experience Laboratory Support	N/A	All efforts needed to provide a laboratory environment to test the effectiveness of customer experience initiatives as set forth in task orders during option period 3 ordering period	Fixed Price	Fixed Priced per job as set forth in task orders	$		Insert total amount from Tab A for CX Option Period 3
	Total evaluated price for Option Ordering Period -3 (CLINs 3001 - 3005)									$
	Grand Total evaluated price for CLINS 0001 through 3005									$

* The unit rates prosed for CLINS 0001 through 3005 (inclusive of SUBCLIN unit prices) shall serve as fixed unit pricing for contract award and shall be consistent with the proposed pricing under Section B.3 of the RFP.

** The evaluated quantities are for evaluation purposes only. The actual number of policies administered will vary. The contractor will only be paid for actual polices administered.

No price adjustment will be granted due to variation in the quantity of actual polices administered since SUBCLINS allow for different unit pricing for each tiers.

Tab C- TO 0001 Eval Price

	HSFE60-16-R-0004 Attachment C Price Evaluation Worksheet August 10, 2016
	Tab-C		Task Order 0001 Price Evaluation Worksheet (Actual Task Order 0001 Price)
	Task Order 0001 Price
	CLIN
Number	Title	Description	Type	Unit of
Issuance	Unit Price	Quantity	Total Amount (column H x I)
	0001	Transition Period –to be provided under Task Order 0001 for a Phase- in period of 6-months after date of task order award	Migration and transition efforts in accordance with the DSA/SOO and QASP provided as attachments A & B of the RFP	Fixed Price for the job (1 lot)	Lot	$	1	$
	0002	Certification and Accreditation (C&A) to be provided under Task Order 0001 for a 6-month period of performance after task order award.	All effort required to complete system security Certification and Accreditation efforts resulting in a FEMA Authorization to Operate (ATO), in accordance to the DSA/SOO and QASP provided as attachments A & B of the RFP. This is inclusive of DSA data migration in accordance to SOO	Fixed Price for the job (1 lot)	Lot	$	1	$
	0003
Optional Item	Task Order 0001 Optional Transition Period (up to 3 months of continued transition support	Extended optional timeframe to complete transition as described under CLIN 0001	Fixed Unit Rate	Per Month	$	3	$
	0004 Optional Item	Task Order 0001 Optional Transition Period (up to 3 additional months of continued transition support	Extended optional timeframe to complete transition as described under CLIN 0001	Fixed Unit Rate	Per Month	$	3	$
	0005 Optional Item	Task Order 0001 Certification and Accreditation (up to 3 months of continued C&A support).	Extended optional timeframe to complete C&A as described under CLIN 0002	Fixed Unit Rate	Per Month	$	3	$
	0006 Optional Item	Task Order 0001 Certification and Accreditation (up to 3 additional months of continued C&A support).	Extended optional timeframe to complete C&A as described under CLIN 0002	Fixed Unit Rate	Per Month	$	3	$
	*Total Amount & Evaluated Price for Task Order 0001 with options (CLINS 0001 through 0006)							$
			*The evaluated price for TO 0001 is the actual price and the unit and fixed pricing proposed above shall be the same as proposed under Section B.3 of the RFP

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