2016_08_14_HSFE60-16-R-0004_A00003_Revised_Attachment_C.xlsx

XLSX spreadsheet 23 KB Posted Aug 15, 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 A00003 Revised Attachment C

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_Amendment_A00004_Aug_12_2016.pdf	PDF	Aug 16, 2016
HSFE60-16-R-0004_Corrected_Attachment_D_dated__8_14_2016.xlsx	XLSX spreadsheet	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_Attachment_D.pdf	PDF	Aug 15, 2016
2016_08_10_HSFE60-16-R-0004_Attachment_B_QASP_Revised.pdf	PDF	Aug 11, 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_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_Attachment_C_dated_Aug_10_2016.xlsx	XLSX spreadsheet	Aug 11, 2016
HSFE60-16-R-0004_Attachment_D_dated_Aug_10_2016.pdf	PDF	Aug 11, 2016
HSFE60-16-R-0004_A00001_posted_Aug_10.pdf	PDF	Aug 10, 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
HSFE60-16-R-0004_Attachment_B.pdf	PDF	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 14, 2016
Tab A: Customer Experience (CX) Lab evaluated price and fully burdened labor rates established for the contract
			Base Year			Option Year 1			Option Year 2		Option Year 3
	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	Option Year 3	Proposed Rate	Total Amount Column K x L
* Direct Labor	* Evaluated Hours			Evaluated Hours			Evaluated Hours			Evaluated Hours
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			1260
Customer Experience SME	980			980			980			980
Engagement Director	840			840			840			840
Senior Executive	644			644			644			644
	Evaluated Price Base Year		$	Evaluated Price Option-1		$	Evaluated Price Option-2		$	Evaluated Price Option-3		$

Total Evaluated Price -Base & Options $

* 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 options 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 based on the fully burdened labor rates set forth herein and any other direct costs (ODCs).

* No material handling fee, G&A, or fee of any sort shall be applied to other direct costs (ODCs) including travel negotiated for CX lab task orders.

* The fully burdened labor rates shall include all indirect costs and profit. No additional profit or fee shall be applied to CX Lab task orders.

Tab B Total Eval Price

HSFE60-16-R-0004 Attachment C- Price Evaluation Worksheet dated August 14, 2016
Tab-B	Total Evaluated Price for all CLINS pursuant to Section E.10 of the RFP

	CLIN
Number	Title	Description	Type	Unit of
Issuance	Unit Price	Quantity	Total Amount (column F x G)
	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 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
	0005 Optional Item	Task Order 0001 Optional Transition Support (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
	0006 Optional Item	Task Order 0001 Optional 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 Evaluated Amount and actual Task Order 0001 Price CLINS 0001 through 0006)							$
	CLIN
Number	Sub
CLIN	Title	Tier	Description	Type	Unit of
Issuance	Unit Rate	Evaluated Quantity	Total Amount (column H x I)
	0007	0007A	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
		0007B		300,001 through 450,000		Fixed Rate	Per Policy/Per Month		9933
		0007C		450,001 through 600,000		Fixed Rate	Per Policy/Per Month		82774
		0007D		600,001 through 750,000		Fixed Rate	Per Policy/Per Month		215211
		0007E		750,001 through 900,000		Fixed Rate	Per Policy/Per Month		9933
		0007F		900,001 and over		Fixed Rate	Per Policy/Per Month		6622
	0008	0008A	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
		0008B		10,001 through 20,000		Fixed Rate	Per Policy/Per Month		134
		0008C		20,001 and over		Fixed Rate	Per Policy/Per Month		45
	0009	0009A	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
		0009B		10,001 through 20,000		Fixed Rate	Per Policy/Per Month		4930
		0009C		20,001 through 30,000		Fixed Rate	Per Policy/Per Month		5359
		0009D		30,001 and over		Fixed Rate	Per Policy/Per Month		214
	0010	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	See Tab A	Insert total amount from Tab A for CX Lab Base Period
	Total evaluated amount for base ordering period (CLINS 0007 through 0010)									$
	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	N/A	See Tab A	Insert total amount from Tab A for CX Lab Option Period 1
	Total evaluated amount 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	Unit 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	N/A	See Tab A	Insert total amount from Tab A for CX Lab Option Period 2
	Total evaluated amount 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	Unit 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	N/A	See Tab A	Insert total amount from Tab A for CX Lab Option Period 3
	Total evaluated amount for Option Ordering Period -3 (CLINs 3001 - 3005)									$
	*Total evaluated price for CLINS 0001 through 3005									$
	* Total Evaluated Price to be used for source selection purposes under Section E.10, 52.212-12, Evaluation Commercial Items, of the RFP.
	*The evaluated price for TO 0001 is the actual pricing for task order 0001 which will be awarded concurrently with the contract.
	* All proposed unit pricing in the Price Evaluation Worksheet shall match and be the same as proposed under Section B.3,Price Schedule of the RFP. All proposed amounts for the fixed priced CLINs in the Price Worksheet shall match and be the same as proposed under Section B.3 of the RFP.
	* With the exception of CLINs 0001 through 0006 for task order 0001, all quantities populated by the Government in the Price Evaluation Worksheet are for evaluation purposes only. The contractor will be paid for the actual polices administered which will vary from the quantities used in the worksheet.
	* Bulk Rate Billing applies. Policy type shall be billed at one rate (SUBCLIN) per month. The number of policies being administered at the end of the monthly invoice period shall determine which rate (SUBCLIN) shall be utilized during each invoice billing period.
	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.

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