Attachment 10 Revised MM_3_6_FSM_Price_Proposal.xlsm

XLSM spreadsheet 179 KB Posted Jul 6, 2012

Attached to: Field Service Management (FSM) 3. 6 - HUD Management and Marketing Services
Solicitation number: DU-204-SB-12-R-0001
Issued by: Department of Housing and Urban Development CPO Atlanta Operations Branch

About this file

From the source

Attachment 10 Pricing Spreadsheet

View the file

Other files

File	Type	Posted
Amendment 0003 to DU204SB-12-R-0001.pdf	PDF	Jul 6, 2012
Attachment 11.xlsx	XLSX spreadsheet	Jul 6, 2012
FSM Section J-Attachment 3 Revised.pdf	PDF	Jul 6, 2012
Attachment 12 MM_3_6_QA_Final.pdf	PDF	Jul 6, 2012
Amendment 0002 to DU204SB-12-R-0001.PDF	PDF	Jul 3, 2012
Amendment 0001 to DU204SB-12-R-0001.pdf	PDF	Jun 12, 2012
DU204SB-12-R-0001-000001.pdf	PDF	Jun 12, 2012
MM_3_6_FSM_Price_Proposal.xlsm	XLSM spreadsheet	Jun 12, 2012
FSM_Section_J-Attachment_7.pdf	PDF	May 25, 2012
FSM_Section_J-Attachment_5.pdf	PDF	May 25, 2012
FSM_Section_J-Attachment_6.pdf	PDF	May 25, 2012
FSM_Section_J-_Attachment_4.pdf	PDF	May 25, 2012
M M 3.6 FSM Price Proposal.xlsm	XLSM spreadsheet	May 25, 2012
FSM_Section_J_Attachment_1B.pdf	PDF	May 25, 2012
Cover Page Standard Form 33.PDF	PDF	May 25, 2012
FSM_Section_J-Attachment_9.pdf	PDF	May 25, 2012
FSM_Section_J-Attachment_8.pdf	PDF	May 25, 2012
FSM_Section_J-Attachment_2.pdf	PDF	May 25, 2012
DU204SB-12-R-0001.pdf	PDF	May 25, 2012
FSM_Section_J-Attachment_3.pdf	PDF	May 25, 2012
FSM_3_6_Area_Map_Attachment_1A.PNG	PNG image	May 25, 2012
FSM_3_6_pws_REV_3-8-2012.pdf	PDF	Mar 30, 2012
Attachment 1 FSM Area Map.PNG	PNG image	Mar 30, 2012

Show all 23

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.6 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 each worksheet to save this spreadsheet.

Excel 2010:

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	Estimated Unit	Proposed Unit
Price	Total Unit

Price

Base Year Period - Firm Fixed Price (duration 9 months)
0001: Pre-Conveyance	Pre-Conveyance Inspections		One (1)	$ - 0	$ - 0
0002: Hud Property Inspections Report	HUD-Owned, Vacant		One (see solicitation)	$ - 0	$ - 0
0003: Hud Property Inspection/Initial Services	Vacant Lot		One (1)	$ - 0	$ - 0
0004: Initial Services	HUD-Owned, Vacant		One (1)	$ - 0	$ - 0
0005: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
0006: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly (see solicitation)	$ - 0	$ - 0
0007: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly until sold	$ - 0	$ - 0
0009: Pass Through Expenses	See solicitation	Actual Cost Incurred	Each 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		One (1)	$ - 0	$ - 0
0011: Hud Property Inspections Report	HUD-Owned, Vacant		One (see solicitation)	$ - 0	$ - 0
0012: Hud Property Inspection/Initial Services	Vacant Lot		One(1)	$ - 0	$ - 0
0013: Initial Services	HUD-Owned, Vacant		One(1)	$ - 0	$ - 0
0014: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
0015: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly (see solicitation)	$ - 0	$ - 0
0016: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly until sold	$ - 0	$ - 0
0018: Pass Through Expenses	See solicitation	Actual Cost Incurred	Each 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		One (1)	$ - 0	$ - 0
0020: Hud Property Inspections Report	HUD-Owned, Vacant		One (see solicitation)	$ - 0	$ - 0
0021: Hud Property Inspection/Initial Services	Vacant Lot		One(1)	$ - 0	$ - 0
0022: Initial Services	HUD-Owned, Vacant		One(1)	$ - 0	$ - 0
0023: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
0024: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly (see solicitation)	$ - 0	$ - 0
0025: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly until sold	$ - 0	$ - 0
0027: Pass Through Expenses	See solicitation	Actual Cost Incurred	Each 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		One (1)	$ - 0	$ - 0
0029: Hud Property Inspections Report	HUD-Owned, Vacant		One (see solicitation)	$ - 0	$ - 0
0030: Hud Property Inspection/Initial Services	Vacant Lot		One(1)	$ - 0	$ - 0
0031: Initial Services	HUD-Owned, Vacant		One(1)	$ - 0	$ - 0
0032: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
0033: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly (see solicitation)	$ - 0	$ - 0
0034: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly until sold	$ - 0	$ - 0
0036: Pass Through Expenses	See solicitation	Actual Cost Incurred	Each 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		One (1)	$ - 0	$ - 0
0038: Hud Property Inspections Report	HUD-Owned, Vacant		One (see solicitation)	$ - 0	$ - 0
0039: Hud Property Inspection/Initial Services	Vacant Lot		One(1)	$ - 0	$ - 0
0040: Initial Services	HUD-Owned, Vacant		One(1)	$ - 0	$ - 0
0041: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant		Monthly	$ - 0	$ - 0
0042: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties		Monthly (see solicitation)	$ - 0	$ - 0
0043: On-Going PM Fee, Vacant Lot	Vacant Lot		Monthly until sold	$ - 0	$ - 0
0045: Pass Through Expenses	See solicitation	Actual Cost Incurred	Each Job	Not to exceed	$ - 0
Total Estimated Proposed Cost for Option Period Four					$ - 0
Total Estimated Proposed Contract Value					$ - 0

Quantity

Contract Line Items

(CLIN)

Supplies or

Services

Estimated Unit

Estimated

Quantity

Estimated

Quantity

Estimated

Quantity

Estimated

Quantity

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	One (1)	662	770	781	1313	1759	744	446	507	719	329	687	439
0002: Hud Property Inspections Report	HUD-Owned, Vacant	One (see solicitation)	6617	7694	7805	13135	17588	7440	4463	5066	7190	3293	6871	4387
0003: Hud Property Inspection/Initial Services	Vacant Lot	One (1)	66	77	78	131	176	74	45	51	72	33	69	44
0004: Initial Services	HUD-Owned, Vacant	One (1)	6617	7694	7805	13135	17588	7440	4463	5066	7190	3293	6871	4387
0005: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	39704	46163	46829	78810	105527	44638	26781	30399	43139	19757	41222	26322
0006: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly (see solicitation)	66	77	78	131	176	74	45	51	72	33	69	44
0007: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly until sold	397	462	468	788	1055	446	268	304	431	197	413	263
0009: Pass Through Expenses	See solicitation	Each 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	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	One (1)	706	821	833	1401	1876	794	476	540	767	351	733	468
0011: Hud Property Inspections Report	HUD-Owned, Vacant	One (see solicitation)	7058	8207	8325	14011	18760	7936	4761	5404	7669	3512	7328	4679
0012: Hud Property Inspection/Initial Services	Vacant Lot	One(1)	71	82	83	140	188	79	48	54	77	35	73	47
0013: Initial Services	HUD-Owned, Vacant	One(1)	7058	8207	8325	14011	18760	7936	4761	5404	7669	3512	7328	4679
0014: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	42350	49241	49950	84064	112561	47614	28566	32425	46015	21074	43970	28076
0015: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly (see solicitation)	71	82	83	140	188	79	48	54	77	35	73	47
0016: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly until sold	424	492	500	841	1126	476	286	324	460	211	440	281
0018: Pass Through Expenses	See solicitation	Each 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	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	One (1)	847	985	999	1681	2251	952	571	649	920	421	879	562
0020: Hud Property Inspections Report	HUD-Owned, Vacant	One (see solicitation)	8470	9848	9990	16813	22512	9523	5713	6485	9203	4215	8794	5615
0021: Hud Property Inspection/Initial Services	Vacant Lot	One(1)	85	98	100	168	225	95	57	65	92	42	88	56
0022: Initial Services	HUD-Owned, Vacant	One(1)	8470	9848	9990	16813	22512	9523	5713	6485	9203	4215	8794	5615
0023: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	50820	59089	59940	100876	135073	57136	34279	38910	55218	25289	52764	33692
0024: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly (see solicitation)	85	98	100	168	225	95	57	65	92	42	88	56
0025: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly until sold	508	591	599	1009	1351	571	343	389	552	253	528	337
0027: Pass Through Expenses	See solicitation	Each 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	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	One (1)	1016	1182	1199	2018	2701	1143	686	778	1104	506	1055	674
0029: Hud Property Inspections Report	HUD-Owned, Vacant	One (see solicitation)	10164	11818	11988	20175	27015	11427	6856	7782	11044	5058	10553	6738
0030: Hud Property Inspection/Initial Services	Vacant Lot	One(1)	102	118	120	202	270	114	69	78	110	51	106	67
0031: Initial Services	HUD-Owned, Vacant	One(1)	10164	11818	11988	20175	27015	11427	6856	7782	11044	5058	10553	6738
0032: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	60985	70907	71928	121052	162088	68564	41135	46692	66262	30347	63317	40430
0033: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly (see solicitation)	102	118	120	202	270	114	69	78	110	51	106	67
0034: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly until sold	610	709	719	1211	1621	686	411	467	663	303	633	404
0036: Pass Through Expenses	See solicitation	Each 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	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	One (1)	1220	1418	1439	2421	3242	1371	823	934	1325	607	1266	809
0038: Hud Property Inspections Report	HUD-Owned, Vacant	One (see solicitation)	12197	14181	14386	24210	32418	13713	8227	9338	13252	6069	12663	8086
0039: Hud Property Inspection/Initial Services	Vacant Lot	One(1)	122	142	144	242	324	137	82	93	133	61	127	81
0040: Initial Services	HUD-Owned, Vacant	One(1)	12197	14181	14386	24210	32418	13713	8227	9338	13252	6069	12663	8086
0041: On-Going Property Management (PM) Fee, HUD-Owned Vacant	HUD-Owned, Vacant	Monthly	73181	85088	86314	145262	194506	82276	49362	56031	79514	36417	75981	48516
0042: Inspection, Initial Services, On-Going PM for Custodial Properties	Custodial Properties	Monthly (see solicitation)	122	142	144	242	324	137	82	93	133	61	127	81
0043: On-Going PM Fee, Vacant Lot	Vacant Lot	Monthly until sold	732	851	863	1453	1945	823	494	560	795	364	760	485
0045: Pass Through Expenses	See solicitation	Each 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	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred	Actual Cost Incurred
Total Estimated Proposed Cost for Option Period Four
Total Estimated Proposed Cost for Proposal
	Pass Through Expenses	Base Year Period	5624663	6539475	6633825	11164538	14949375	6324000	3794400	4306313	6111713	2799263	5840138	3729375
		Option Period One	5999300	6975950	7076250	11909350	15946000	6745600	4046850	4593400	6518650	2985200	6229650	3978000
		Option Period Two	7199500	8370800	8491500	14291050	19135200	8094550	4856050	5512250	7822550	3582750	7474900	4773600
		Option Period Three	8639400	10045300	10189800	17149600	22961900	9713800	5826750	6614700	9387400	4299300	8970050	5728150
		Option Period Four	10367450	12054700	12228100	20579350	27554450	11656900	6992950	7938150	11265050	5159500	10764400	6873950

Completed

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

image1.jpeg image2.gif image3.gif

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