M M_3.8_FSM_Price_Proposal_Revised_6-25-14.xlsm

XLSM spreadsheet 207 KB Posted Jun 26, 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 Pricing Spreadsheet 6-25-14

View the file

Other files

File	Type	Posted
Amendment_4.PDF	PDF	Jun 26, 2014
M M_3.8_FSM_Price_Proposal_14-06-18.xlsm	XLSM spreadsheet	Jun 19, 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 Inspection, 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 Inspection, 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 Inspection, 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 Inspection, 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 Inspection, 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 Inspection, 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	5348	9528	2341	1599	2899	1841	3568	4409
0003: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	20	20	20	20
0004: Initial Services	HUD-Owned, Vacant	Each	5348	9528	2341	1599	2899	1841	3568	4409
0005: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	39679	67651	18041	11335	21055	15341	24667	34609
0005AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	85972	146578	39090	24558	45618	33240	53446	74985
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	20	120	120	120	120	120	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	5348	9528	2341	1599	2899	1841	3568	4409
0012: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	20	20	20	20
0013: Initial Services	HUD-Owned, Vacant	Each	5348	9528	2341	1599	2899	1841	3568	4409
0014: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	39679	67651	18041	11335	21055	15341	24667	34609
0014AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	85972	146578	39090	24558	45618	33240	53446	74985
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	20	120	120	120	120	120	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	5348	9528	2341	1599	2899	1841	3568	4409
0021: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	20	20	20	20
0022: Initial Services	HUD-Owned, Vacant	Each	5348	9528	2341	1599	2899	1841	3568	4409
0023: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	39679	67651	18041	11335	21055	15341	24667	34609
0023AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	85972	146578	39090	24558	45618	33240	53446	74985
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	20	120	120	120	120	120	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	5348	9528	2341	1599	2899	1841	3568	4409
0030: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	20	20	20	20
0031: Initial Services	HUD-Owned, Vacant	Each	5348	9528	2341	1599	2899	1841	3568	4409
0032: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	39679	67651	18041	11335	21055	15341	24667	34609
0032AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	85972	146578	39090	24558	45618	33240	53446	74985
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	20	120	120	120	120	120	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	5348	9528	2341	1599	2899	1841	3568	4409
0039: Hud Property Inspection/Initial Services	Vacant Lot	Each	20	20	20	20	20	20	20	20
0040: Initial Services	HUD-Owned, Vacant	Each	5348	9528	2341	1599	2899	1841	3568	4409
0041: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	39679	67651	18041	11335	21055	15341	24667	34609
0041AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	85972	146578	39090	24558	45618	33240	53446	74985
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	20	120	120	120	120	120	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	2674	4764	1171	800	1450	921	1784	2205
0048: Hud Property Inspection/Initial Services	Vacant Lot	Each	10	10	10	10	10	10	10	10
0049: Initial Services	HUD-Owned, Vacant	Each	2674	4764	1171	800	1450	921	1784	2205
0050: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	19840	33826	9021	5668	10528	7671	12334	17305
0050AA: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Bi-Weekly	42986	73289	19545	12279	22809	16620	26723	37493
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	10	60	60	60	60	60	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.