M M_3.8_FSM_Price_Proposal_14-06-18.xlsm

XLSM spreadsheet 208 KB Posted Jun 19, 2014

Attached to: Field Service Management 3. 8
Solicitation number: DU204SA-13-R-0004
Issued by: Department of Housing and Urban Development CPO Atlanta Operations Branch

About this file

From the source

Revised Attachment 9 Pricing Spreadsheet

View the file

Other files

File	Type	Posted
M M_3.8_FSM_Price_Proposal_Revised_6-25-14.xlsm	XLSM spreadsheet	Jun 26, 2014
Amendment_4.PDF	PDF	Jun 26, 2014
SF30.PDF	PDF	Jun 19, 2014
Attachment_1_HOC_Map.pdf	PDF	Jun 13, 2014
Solicitation_changes.pdf	PDF	Jun 13, 2014
Attachment_10_Past_Performance_questionaire_FSM_3_8_revised.pdf	PDF	Jun 13, 2014
SF30.PDF	PDF	Jun 13, 2014
DU204SA-13-R-0004_MM_3_8_solicitation_Q_and_As.pdf	PDF	Jun 13, 2014
Amendment_1.PDF	PDF	Jun 12, 2014
Attch_3_elimination_of_lead_base.pdf	PDF	May 22, 2014
Attch_4_rental_procedures.pdf	PDF	May 22, 2014
Attch_2_applicable_documents.pdf	PDF	May 22, 2014
Attachment_1_HOC_Map.pdf	PDF	May 22, 2014
Attachment_13-MM_3_8.pdf	PDF	May 22, 2014
Attch_7_property_inspection_form.pdf	PDF	May 22, 2014
Attachment_12-MM_3_8.pdf	PDF	May 22, 2014
Attch_5_allowable_pass_through.pdf	PDF	May 22, 2014
SF_33 1 .pdf	PDF	May 22, 2014
Attch_6_HPIR.pdf	PDF	May 22, 2014
Attachment_10_Past_Performance_questionaire_FSM_3_8_revised.pdf	PDF	May 22, 2014
Attch_8_property_maintenance_form.pdf	PDF	May 22, 2014
Attachment_11.pdf	PDF	May 22, 2014
Attch_9_M M_3.8_FSM_Price_Proposal_14-05-14.xlsm	XLSM spreadsheet	May 22, 2014
DU204SA-13-R-0004.rtf	RTF text file	May 22, 2014
M M_3.8_Master_Presentation.pptx	PPTX presentation	Apr 17, 2014
MM_3_8_Industry_Day_Questions.docx	DOCX document	Apr 17, 2014
FSM_3__8_Synopsis_2_11_14_Amended.doc	DOC document	Apr 11, 2014
MM_3_8_Electronic_Registration.docx	DOCX document	Dec 23, 2013
MM_Industry_Day_Flier_Color-3_8.pdf	PDF	Dec 23, 2013

Show all 29

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.

Instructions

Management and Marketing Field Service Manager 3.8 Price Proposal

Instructions:

Please make sure macros are enabled in Microsoft Excel, or this spreadsheet will not work.

Use the screenshots below the start button as a guide to enable macros.

Click the start button to begin the process. This button can also be used to restart or edit the

process if exited before completed, or the Edit button on the Company Information tab can be

used.

Please use one of the save buttons at the top of the following worksheets to save this spreadsheet.

Excel 2010 and 2013:

Click the Enable Content button as shown above to enable the macros.

Excel 2007:

Click the Options… button as shown above and click the Enable this content radio button on the

next screen to enable macros.

Start

Company Information

Company Information:

Company Name:

Point of Contact:

Phone Number:

Email Address:

Submitting proposal(s) for the following geographic area(s):

Note: Use the edit button to change company information or areas.

Edit Save

CLINS

	Contract Line Items (CLIN)	Supplies or Services	Estimated
Quantity	Unit	Proposed Unit
Price	Total Unit Price
	Base Period - Firm Fixed Price (Date of Award - May 31, 2015)
	0001: Pre-Conveyance	Pre-Conveyance Inspections		Each	$ - 0	$ - 0
	0002: Hud Property Inspections Report	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0003: Hud Property Inspection/Initial Services	Vacant Lot		Each	$ - 0	$ - 0
	0004: Initial Services	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0005: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
	0005AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Bi-Weekly	$ - 0	$ - 0
	0006: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly	$ - 0	$ - 0
	0007: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly	$ - 0	$ - 0
	0009: Pass Through Expenses	See solicitation	Actual Cost Incurred	Job	Not to exceed	$ - 0
	Total Estimated Proposed Cost for Base Year					$ - 0
	Option Period One - Firm Fixed Price (duration 12 months)
	0010: Pre-Conveyance	Pre-Conveyance Inspections		Each	$ - 0	$ - 0
	0011: Hud Property Inspections Report	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0012: Hud Property Inspection/Initial Services	Vacant Lot		Each	$ - 0	$ - 0
	0013: Initial Services	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0014: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
	0014AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Bi-Weekly	$ - 0	$ - 0
	0015: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly	$ - 0	$ - 0
	0016: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly	$ - 0	$ - 0
	0018: Pass Through Expenses	See solicitation	Actual Cost Incurred	Job	Not to exceed	$ - 0
	Total Estimated Proposed Cost for Option Period One					$ - 0
	Option Period Two - Firm Fixed Price (duration 12 months)
	0019: Pre-Conveyance	Pre-Conveyance Inspections		Each	$ - 0	$ - 0
	0020: Hud Property Inspections Report	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0021: Hud Property Inspection/Initial Services	Vacant Lot		Each	$ - 0	$ - 0
	0022: Initial Services	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0023: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
	0023AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Bi-Weekly	$ - 0	$ - 0
	0024: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly	$ - 0	$ - 0
	0025: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly	$ - 0	$ - 0
	0027: Pass Through Expenses	See solicitation	Actual Cost Incurred	Job	Not to exceed	$ - 0
	Total Estimated Proposed Cost for Option Period Two					$ - 0
	Option Period Three - Firm Fixed Price (duration 12 months)
	0028: Pre-Conveyance	Pre-Conveyance Inspections		Each	$ - 0	$ - 0
	0029: Hud Property Inspections Report	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0030: Hud Property Inspection/Initial Services	Vacant Lot		Each	$ - 0	$ - 0
	0031: Initial Services	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0032: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
	0032AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Bi-Weekly	$ - 0	$ - 0
	0033: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly	$ - 0	$ - 0
	0034: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly	$ - 0	$ - 0
	0036: Pass Through Expenses	See solicitation	Actual Cost Incurred	Job	Not to exceed	$ - 0
	Total Estimated Proposed Cost for Option Period Three					$ - 0
	Option Period Four - Firm Fixed Price (duration 12 months)
	0037: Pre-Conveyance	Pre-Conveyance Inspections		Each	$ - 0	$ - 0
	0038: Hud Property Inspections Report	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0039: Hud Property Inspection/Initial Services	Vacant Lot		Each	$ - 0	$ - 0
	0040: Initial Services	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0041: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
	0041AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Bi-Weekly	$ - 0	$ - 0
	0042: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly	$ - 0	$ - 0
	0043: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly	$ - 0	$ - 0
	0045: Pass Through Expenses	See solicitation	Actual Cost Incurred	Job	Not to exceed	$ - 0
	Total Estimated Proposed Cost for Option Period Four					$ - 0
	Special FAR Option - Firm Fixed Price (duration 6 months)
	0046: Pre-Conveyance	Pre-Conveyance Inspections		Each	$ - 0	$ - 0
	0047: Hud Property Inspections Report	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0048: Hud Property Inspection/Initial Services	Vacant Lot		Each	$ - 0	$ - 0
	0049: Initial Services	HUD-Owned, Vacant		Each	$ - 0	$ - 0
	0050: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
	0050AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Bi-Weekly	$ - 0	$ - 0
	0051: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly	$ - 0	$ - 0
	0052: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly	$ - 0	$ - 0
	0054: Pass Through Expenses	See solicitation	Actual Cost Incurred	Job	Not to exceed	$ - 0
	Total Estimated Proposed Cost for Special FAR Option					$ - 0
	Total Estimated Proposed Contract Value					$ - 0

Note:

This is only an estimate. The Government is assuming a nine (9) month

base period for resulting awards, however the actual base period will be

from the award date to May 31st, 2015. The Government reserves the

right to adjust quantities based on the actual award date.

Quantity

				1D	2D	4D	5D	1P	3P	4P	5P
	Contract Line Items (CLIN)	Supplies or Services	Unit	Estimated
Quantity	Estimated
Quantity	Estimated
Quantity	Estimated
Quantity	Estimated
Quantity	Estimated
Quantity	Estimated
Quantity	Estimated

Quantity

Base Year Period - Firm Fixed Price (duration 12 months)
0001: Pre-Conveyance	Pre-Conveyance Inspections	Each	2000	2000	2000	2000	2000	2000	2000	2000
0002: Hud Property Inspections Report	HUD-Owned, Vacant	Each	10242	13032	3147	1936	5694	13815	7032	12828
0003: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	50	20	50	20
0004: Initial Services	HUD-Owned, Vacant	Each	10242	13032	3147	1936	5694	13815	7032	12828
0005: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	55115	70128	16935	10418	30641	74342	37841	69030
0005AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	110230	140256	33870	20836	61282	148684	75682	138060
0006: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly	200	200	200	200	200	200	200	200
0007: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly	20	120	120	120	300	120	300	120
0009: Pass Through Expenses	See solicitation	Job	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred
Total Estimated Proposed Cost for Base Year
Option Period One - Firm Fixed Price (duration 12 months)
0010: Pre-Conveyance	Pre-Conveyance Inspections	Each	2000	2000	2000	2000	2000	2000	2000	2000
0011: Hud Property Inspections Report	HUD-Owned, Vacant	Each	9270	11586	2740	1714	4116	11659	5576	10887
0012: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	50	20	50	20
0013: Initial Services	HUD-Owned, Vacant	Each	9270	11586	2740	1714	4116	11659	5576	10887
0014: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	49884	62347	14745	9223	22149	62740	30006	58586
0014AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	99768	124694	29490	18446	44298	125480	60012	117172
0015: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly	200	200	200	200	200	200	200	200
0016: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly	20	120	120	120	300	120	300	120
0018: Pass Through Expenses	See solicitation	Job	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred
Total Estimated Proposed Cost for Option Period One
Option Period Two - Firm Fixed Price (duration 12 months)
0019: Pre-Conveyance	Pre-Conveyance Inspections	Each	2000	2000	2000	2000	2000	2000	2000	2000
0020: Hud Property Inspections Report	HUD-Owned, Vacant	Each	9503	11508	2707	1745	3426	11185	5088	10365
0021: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	50	20	50	20
0022: Initial Services	HUD-Owned, Vacant	Each	9503	11508	2707	1745	3426	11185	5088	10365
0023: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	51138	61927	14567	9390	18436	60189	27380	55776
0023AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	102276	123854	29134	18780	36872	120378	54760	111552
0024: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly	200	200	200	200	200	200	200	200
0025: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly	20	120	120	120	300	120	300	120
0027: Pass Through Expenses	See solicitation	Job	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred
Total Estimated Proposed Cost for Option Period Two
Option Period Three - Firm Fixed Price (duration 12 months)
0028: Pre-Conveyance	Pre-Conveyance Inspections	Each	2000	2000	2000	2000	2000	2000	2000	2000
0029: Hud Property Inspections Report	HUD-Owned, Vacant	Each	10306	12194	2733	1866	3256	10768	4758	10094
0030: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	50	20	50	20
0031: Initial Services	HUD-Owned, Vacant	Each	10306	12194	2733	1866	3256	10768	4758	10094
0032: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	55459	65619	14707	10041	17521	57945	25604	54318
0032AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	110918	131238	29414	20082	35042	115890	51208	108636
0033: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly	200	200	200	200	200	200	200	200
0034: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly	20	120	120	120	300	120	300	120
0036: Pass Through Expenses	See solicitation	Job	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred
Total Estimated Proposed Cost for Option Period Three
Option Period Four - Firm Fixed Price (duration 12 months)
0037: Pre-Conveyance	Pre-Conveyance Inspections	Each	2000	2000	2000	2000	2000	2000	2000	2000
0038: Hud Property Inspections Report	HUD-Owned, Vacant	Each	9436	10900	2404	1804	2753	8979	3927	8853
0039: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	50	20	50	20
0040: Initial Services	HUD-Owned, Vacant	Each	9436	10900	2404	1804	2753	8979	3927	8853
0041: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	50777	58655	12936	9708	14815	48318	21132	47640
0041AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	101554	117310	25872	19416	29630	96636	42264	95280
0042: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly	200	200	200	200	200	200	200	200
0043: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly	20	120	120	120	300	120	300	120
0045: Pass Through Expenses	See solicitation	Job	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred
Total Estimated Proposed Cost for Option Period Four
Special FAR Option - Firm Fixed Price (duration 6 months)
0046: Pre-Conveyance	Pre-Conveyance Inspections	Each	1000	1000	1000	1000	1000	1000	1000	1000
0047: Hud Property Inspections Report	HUD-Owned, Vacant	Each	4718	5450	1202	902	1377	4490	1964	4427
0048: Hud Property Inspection/Initial Services	Vacant Lot	Each	10	10	10	10	25	10	25	10
0049: Initial Services	HUD-Owned, Vacant	Each	4718	5450	1202	902	1377	4490	1964	4427
0050: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	25389	29328	6468	4854	7408	24159	10566	23820
0050AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	50778	58656	12936	9708	14816	48318	21132	47640
0051: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly	100	100	100	100	100	100	100	100
0052: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly	10	60	60	60	150	60	150	60
0053: Pass Through Expenses	See solicitation	Job	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred
Total Estimated Proposed Cost for Option Period Four
Total Estimated Proposed Contract Value
Pass Through Expenses	See solicitation	Job	7500000	7500000	1500000	2000000	4000000	2500000	2500000	4000000

Completed

	Area	Completed?	Complete
2=Yes 1=No	# of Areas	# of Completed	All Complete?

image1.jpg image2.gif image3.gif

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