Attach_4_-_RFQ_Response_Pricing_Templates.xlsx

XLSX spreadsheet 47 KB Posted Dec 6, 2018

Attached to: NETC Library Support Services
Solicitation number: 70FA2019Q00000005
Issued by: Federal Emergency Management Agency Preparedness Section

About this file

From the source

Attach 4 - Pricing Template

View the file

Other files

File	Type	Posted
Attach_2_-_NETC_Library_PWS_Amend_0003.pdf	PDF	Feb 14, 2019
Attach_9_-_NETC_Library_Eval_Factor_Response_Instruct_&_Procedures_v.3_Amend_0003.pdf	PDF	Feb 14, 2019
Attach_1_-_RFQ_Clauses-Provisions-Addenda_Amend_0003.pdf	PDF	Feb 14, 2019
Attach_12_-_Gov._Responses_to_Questions.pdf	PDF	Feb 14, 2019
Attach_3_-_WD_No._2015-4269_Rev._No._8_as_of_2018.12.26_(first_posted_2019.01.01).pdf	PDF	Feb 14, 2019
Attach_4_-_RFQ_Response_Pricing_Templates_-_Amend_0003.xlsx	XLSX spreadsheet	Feb 14, 2019
Attach_6_-_NETC_Libray_PWS_Appendix_B_-_NETC_Library_Historical_LoE_&_Production.pdf	PDF	Dec 6, 2018
Attach_10_-_Responses_to_Solicitation_Provisions_and_Clauses.pdf	PDF	Dec 6, 2018
Attach_8_-_NETC_Library_PWS_Appendix_E_-_NETC_Library_Cataloging_SOP.pdf	PDF	Dec 6, 2018
Attach_1_-_RFQ_Clauses-Provisions-Addenda.pdf	PDF	Dec 6, 2018
Attach_9_-_NETC_Library_Eval_Factor_Response_Instruct_&_Procedures.pdf	PDF	Dec 6, 2018
Attach_7_-_NETC_Library_PWS_Appendix_D_-_NETC_Library_Collection_Development_SOP.pdf	PDF	Dec 6, 2018
Attach_2_-_NETC_Library_PWS.pdf	PDF	Dec 6, 2018
Attach_11_-_Questions_Template.docx	DOCX document	Dec 6, 2018
Attach_3_-_WD_No._2015-4269_Rev._No._7_as_of_2018.07.17_(first_posted_2018.07.24).pdf	PDF	Dec 6, 2018
Attach_5_-_NETC_Library_PWS_Appendix_A_-_NETC_Library_Glossary.pdf	PDF	Dec 6, 2018

Show all 16

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.

RFQ Summary

SUMMARY PRICING NETC LIBRARY SUPPORT
PoP	CLIN	Description	Qty	Unit	Unit $*	Amount
Base Period 03/01/19-02/29/20	0001	NETC Library Support Services (FFP) - Base	12	MO	$ 7,537.46	$ 90,449.50
	0002	NETC Library Support Services - Optional Holiday Weeks (FFP) - Base	3	EA	$ 1,884.36	$ 5,653.09
	0003	NETC Library Support Services - Option for EMI Advanced Academy (AA) Papers (FFP) - Base	12	MO	$ 196.25	$ 2,354.96
						$ 98,457.55
PoP	CLIN	Description				Amount
Option Period 1 03/01/20-02/28/21	1001	NETC Library Support Services (FFP) - OP1	12	MO	$ 7,537.46	$ 90,449.50
	1002	NETC Library Support Services - Optional Holiday Weeks (FFP) - OP1	3	EA	$ 1,884.36	$ 5,653.09
	1003	NETC Library Support Services - Option for EMI Advanced Academy (AA) Papers (FFP) - OP1	12	MO	$ 196.25	$ 2,354.96
						$ 98,457.55
PoP	CLIN	Description				Amount
Option Period 2 03/01/21-02/28/22	2001	NETC Library Support Services (FFP) - OP2	12	MO	$ 7,537.46	$ 90,449.50
	2002	NETC Library Support Services - Optional Holiday Weeks (FFP) - OP2	3	EA	$ 1,884.36	$ 5,653.09
	2003	NETC Library Support Services - Option for EMI Advanced Academy (AA) Papers (FFP) - OP2	12	MO	$ 196.25	$ 2,354.96
						$ 98,457.55
PoP	CLIN	Description				Amount
Option Period 3 03/01/22-02/28/23	3001	NETC Library Support Services (FFP) - OP3	12	MO	$ 7,537.46	$ 90,449.50
	3002	NETC Library Support Services - Optional Holiday Weeks (FFP) - OP3	3	EA	$ 1,884.36	$ 5,653.09
	3003	NETC Library Support Services - Option for EMI Advanced Academy (AA) Papers (FFP) - OP3	12	MO	$ 196.25	$ 2,354.96
						$ 98,457.55
PoP	CLIN	Description				Amount
Option Period 4 03/01/23-02/29/24	4001	NETC Library Support Services (FFP) - OP4	12	MO	$ 7,537.46	$ 90,449.50
	4002	NETC Library Support Services - Optional Holiday Weeks (FFP) - OP4	3	EA	$ 1,884.36	$ 5,653.09
	4003	NETC Library Support Services - Option for EMI Advanced Academy (AA) Papers (FFP) - OP4	12	MO	$ 196.25	$ 2,354.96
						$ 98,457.55

GRAND TOTAL	$ 492,287.77
*Unit price of XXX1 CLINs based on minimum service level of 48 operational weeks in each PoP.

RFQ# 70FA2019Q00000005

Attachment 4

Summary 1

DETAILED SUMMARY - NETC LIBRARY
Item w/%'s	Base Year	Option 1	Option 2	Option 3	Option 4	Totals
LABOR	$ 93,276.23	$ 93,276.23	$ 93,276.23	$ 93,276.23	$ 93,276.23	$ 466,381.15
0.00%

Keller, Gregory: %'s in highlighted yellow cell are example amounts only.

Overhead	$ 932.76	$ 932.76	$ 932.76	$ 932.76	$ 932.76	$ 4,663.81
1.00%

Total w/OH $ 94,208.99 $ 94,208.99 $ 94,208.99 $ 94,208.99 $ 94,208.99 $ 471,044.96

G&A	$ 942.09	$ 942.09	$ 942.09	$ 942.09	$ 942.09	$ 4,710.45
1.00%

Total w/G&A $ 95,151.08 $ 95,151.08 $ 95,151.08 $ 95,151.08 $ 95,151.08 $ 475,755.41

Profit	$ 951.51	$ 951.51	$ 951.51	$ 951.51	$ 951.51	$ 4,757.55
1.00%

Grand Total	$ 96,102.59	$ 96,102.59	$ 96,102.59	$ 96,102.59	$ 96,102.59	$ 480,512.97
Weekly Amount (based on 51 weeks)	$ 1,884.36	$ 1,884.36	$ 1,884.36	$ 1,884.36	$ 1,884.36

DETAILED SUMMARY - EMI AA Papers

Item w/%'s Base Year Option 1 Option 2 Option 3 Option 4 Totals

LABOR	$2,285.70	$ 2,285.70	$ 2,285.70	$ 2,285.70	$ 2,285.70	$ 11,428.51
0.00%

Overhead	$ 22.86	$ 22.86	$ 22.86	$ 22.86	$ 22.86	$ 114.29
1.00%

Total w/OH $ 2,308.56 $ 2,308.56 $ 2,308.56 $ 2,308.56 $ 2,308.56 $ 11,542.80

G&A	$ 23.09	$ 23.09	$ 23.09	$ 23.09	$ 23.09	$ 115.43
1.00%

Total w/G&A $ 2,331.64 $ 2,331.64 $ 2,331.64 $ 2,331.64 $ 2,331.64 $ 11,658.22

Profit	$ 23.32	$ 23.32	$ 23.32	$ 23.32	$ 23.32	$ 116.58
1.00%

Grand Total $ 2,354.96 $ 2,354.96 $ 2,354.96 $ 2,354.96 $ 2,354.96 $ 11,774.81

NETC Library Support Services

LABOR DETAIL - NETC LIBRARY

Max # of Weeks Open	51	Reference Attach 1 - FAR Provisions Inc. Full Text \| Addendum to 52.212-1 \| Offer Assumptions
H&W	$4.18	H&W rate of $4.18/hr based on this requirement being subject to EO 13706 Establishing Paid SL for Fed Contractors per applicable WD as will be awarded after 1/1/17.
OASDI	6.20%	Gov. expectation is that these %'s won't change.
Medicare	1.45%
FUTA	0.60%	Example inputs only and please note formulas include respective caps.
SUTA/SUI	7.50%
Workers/Comp	0.55%	Gov. expectation is that Offerors will either use a % input in B9 OR remove formula reference in Column N to B9 and instead insert amounts in respective Column N rows.

Labor Position SCLS Classification No. of FTE's Hourly Rate Weekly Hours Annual Hours Salary Total H & W Salary & H&W Total OASDI MEDICARE FUTA SUTA/SUI Workers Comp Total Annual Labor Cost

Example	Only	0.98	$35.00	40.00	2,040	$71,400.00	$8,527.20	$79,927.20	$4,955.49	$1,158.94	$42.00	$637.50	$439.60	$87,160.73
		0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$42.00	$637.50	$0.00	$679.50
		0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$42.00	$637.50	$0.00	$679.50
		0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$42.00	$637.50	$0.00	$679.50
		0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$42.00	$637.50	$0.00	$679.50
		0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$42.00	$637.50	$0.00	$679.50
		0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$42.00	$637.50	$0.00	$679.50
		0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$42.00	$637.50	$0.00	$679.50
		0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$42.00	$637.50	$0.00	$679.50
		0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$42.00	$637.50	$0.00	$679.50

	Grand Total		0.98		40.00
Keller, Gregory: This sum must not be less than 245.00 (see Attach 2 - PWS \| Section 2.1)	2,040	$71,400.00	$8,527.20	$79,927.20	$4,955.49	$1,158.94	$420.00	$6,375.00	$439.60	$93,276.23

Library Support - EMI AA Papers EMI Advanced Academy Papers DETAILED

# of Papers	230	Reference Attach 1 - Section C \| FEMA Clauses/T&C \| OP Exercises & Option CLIN Funding AND Section E \| FAR Provisions Inc. Full Text \| Addendum to 52.212-1 \| Offer Assumptions
H&W	$4.18	H&W rate of $4.18/hr based on this requirement being subject to EO 13706 Establishing Paid SL for Fed Contractors per applicable WD as will be awarded after 1/1/17.
OASDI	6.20%	Gov. expectation is that these %'s won't change.
Medicare	1.45%
FUTA	0.60%	Example inputs only and please note formulas do not include respective caps as not expected to be applicable.
SUTA/SUI	7.50%
Workers/Comp	0.55%	Gov. expectation is that Offerors will either use a % input in B9 OR remove formula reference in Column N to B9 and instead insert amounts in respective Column N rows.

Labor Position SCLS Classification No. of FTE's Hourly Rate Per Paper Hours Total Hours Salary Total H & W Salary & H&W Total OASDI MEDICARE FUTA SUTA/SUI Workers Comp Total Annual Labor Cost

	EXAMPLE	ONLY	0.03	$30.00	0.25
Keller, Gregory: So if 15 minutes task, then correlates to .25 i.e. 15 / 60	58	$1,725.00	$240.35	$1,965.35	$121.85	$28.50	$11.79	$147.40	$10.81	$2,285.70
			0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
			0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
			0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
			0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
			0.00			0	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

Grand Total 0.03 0.25 58 $1,725.00 $240.35 $1,965.35 $121.85 $28.50 $11.79 $147.40 $10.81 $2,285.70

1.13 Avg. Weekly Hours based on 51 operational weeks

Fully Loaded Hourly Rate $40.96

File details come from the government source that posted it.