MM_3_6_FSM_Price_Proposal.xlsm

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.

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.

CLINS

Price

Base Year Period - Firm Fixed Price (duration 12 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

3A 4A 5A 6A 7A 8A 4D 5D 3S 4S 5S 6S

Quantity

Base Year Period - Firm Fixed Price (duration 12 months)

0001: Pre-Conveyance Pre-Conveyance Inspections One (1) 882 1026 1041 1751 2345 992 595 676 959 439 916 585

0002: Hud Property Inspections Report HUD-Owned, Vacant One (see solicitation) 8823 10259 10406 17513 23450 9920 5951 6755 9587 4391 9161 5849

0003: Hud Property Inspection/Initial Services Vacant Lot One (1) 88 103 104 175 235 99 60 68 96 44 92 58

0004: Initial Services HUD-Owned, Vacant One (1) 8823 10259 10406 17513 23450 9920 5951 6755 9587 4391 9161 5849

0005: On-Going Property Management (PM) Fee, HUD-Owned Vacant HUD-Owned, Vacant Monthly 52938 61551 62438 105080 140702 59517 35708 40532 57519 26343 54963 35096

0006: Inspection, Initial Services, On-Going PM for Custodial Properties Custodial Properties Monthly (see solicitation) 88 103 104 175 235 99 60 68 96 44 92 58

0007: On-Going PM Fee, Vacant Lot Vacant Lot Monthly until sold 529 616 624 1051 1407 595 357 405 575 263 550 351

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 7499550 8719300 8845100 14886050 19932500 8432000 5059200 5741750 8148950 3732350 7786850 4972500

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

image1.jpeg image2.gif image3.gif