Revised_3.76_Attach_A13_Pricing_Spreadsheet.xlsm
XLSM spreadsheet 208 KB Posted
- Attached to
- M&M 3. 76 Asset Management Services
- Solicitation number
- 86544B18R00001
About this file
Revised 3.76 Attach A13 Pricing Spreadsheet
View the file
Other files
Show all 26
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
Management and Marketing Asset Manager 3.76 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. |
| Fill out the proposed unit prices highlighted in yellow with numbers with a maximum of two decimal |
| places. |
| CLIN 01 is automatically calculated as 10% more than the entered value for CLIN 02 for the base period |
| and all corresponding option periods. |
| Please use one of the save buttons at the top of each worksheet to save this spreadsheet. A check is |
| run on all entered unit prices to make sure there are no more than two decimal places entered, and |
| the spreadsheet is saved with the correct naming convention. |
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) | Estimated Quantity | Unit | Proposed Unit Price | Total Unit Price | |
| Base Period - Firm Fixed Price 12/1/2018 - 5/31/2019 (6 months) | Average Sales Price | $ - 0 | |||
| 01: Marketing Fee Percentage | Percentage | 0.00% | $ - 0 | ||
| 02: Marketing Fee Percentage | Percentage | 0.00% | $ - 0 | ||
| 03: Marketing Fee Percentage | Percentage | 0.00% | $ - 0 | ||
| 11: COR Directed Inspections | Each | $ - 0 | $ - 0 | ||
| 21: Appraisal Fee | 1 | Lot | Not to exceed | $ - 0 | |
| 31: Record Retention/File Delivery | 1 | Lot | Not to exceed | $ - 0 | |
| 41: Post Closing/Complaints | 1 | Lot | Not to exceed | $ - 0 | |
| 51: Negative Sales, HOA, Property Taxes, and Other Expenses | |||||
| Authorized by the COR | 1 | Lot | Not to exceed | $ - 0 | |
| Total Estimated Proposed Cost for Base Period | $ - 0 | ||||
| Option Period One - Firm Fixed Price 6/1/2019 - 5/31/2020 (12 months) | Average Sales Price | $ - 0 | |||
| 01: Marketing Fee Percentage | Percentage | 0.00% | $ - 0 | ||
| 02: Marketing Fee Percentage | Percentage | 0.00% | $ - 0 | ||
| 03: Marketing Fee Percentage | Percentage | 0.00% | $ - 0 | ||
| 12: COR Directed Inspections | Each | $ - 0 | $ - 0 | ||
| 22: Appraisal Fee | 1 | Lot | Not to exceed | $ - 0 | |
| 32: Record Retention/File Delivery | 1 | Lot | Not to exceed | $ - 0 | |
| 42: Post Closing/Complaints | 1 | Lot | Not to exceed | $ - 0 | |
| 52: Negative Sales, HOA, Property Taxes, and Other Expenses | |||||
| Authorized by the COR | 1 | Lot | Not to exceed | $ - 0 | |
| Total Estimated Proposed Cost for Option Period One | $ - 0 | ||||
| Special FAR Option - Firm Fixed Price 6/1/2020 - 11/30/2020 (6 months) | Average Sales Price | $ - 0 | |||
| 01: Marketing Fee Percentage | Percentage | 0.00% | $ - 0 | ||
| 02: Marketing Fee Percentage | Percentage | 0.00% | $ - 0 | ||
| 03: Marketing Fee Percentage | Percentage | 0.00% | $ - 0 | ||
| 13: COR Directed Inspections | Each | $ - 0 | $ - 0 | ||
| 23: Appraisal Fee | 1 | Lot | Not to exceed | $ - 0 | |
| 33: Record Retention/File Delivery | 1 | Lot | Not to exceed | $ - 0 | |
| 43: Post Closing/Complaints | 1 | Lot | Not to exceed | $ - 0 | |
| 53: Negative Sales, HOA, Property Taxes, and Other Expenses | |||||
| Authorized by the COR | 1 | Lot | Not to exceed | $ - 0 | |
| Total Estimated Proposed Cost for Special FAR Option | $ - 0 | ||||
| Total Estimated Proposed Contract Value* | $ - 0 |
Quantity
| 3A | |
| Contract Line Items (CLIN) | Estimated |
Quantity
| Base Period - Firm Fixed Price (duration 12 months) | |
| 01: Marketing Fee Percentage | 828 |
| 02: Marketing Fee Percentage | 355 |
| 03: Marketing Fee Percentage | 5 |
| 11: COR Directed Inspections | 75 |
| 21: Appraisal Fee | 1 |
| 31: Record Retention/File Delivery | 1 |
| 41: Post Closing Complaints | 1 |
| 51: Negative Sales, HOA, Property Taxes and Other Expenses Authorized by the COR | 1 |
| Total Estimated Proposed Cost for Base Period | |
| Option Period One - Firm Fixed Price (duration 12 months) | |
| 01: Marketing Fee Percentage | 1655 |
| 02: Marketing Fee Percentage | 709 |
| 03: Marketing Fee Percentage | 10 |
| 12: COR Directed Inspections | 150 |
| 22: Appraisal Fee | 1 |
| 32: Record Retention/File Delivery | 1 |
| 42: Post Closing Complaints | 1 |
| 52: Negative Sales, HOA, Property Taxes and Other Expenses Authorized by the COR | 1 |
| Total Estimated Proposed Cost for Option Period One | |
| Special FAR Option - Firm Fixed Price (duration 6 months) | |
| 01: Marketing Fee Percentage | |
| 02: Marketing Fee Percentage | |
| 03: Marketing Fee Percentage | |
| 13: COR Directed Inspections | |
| 23: Appraisal Fee | |
| 33: Record Retention/File Delivery | |
| 43: Post Closing Complaints | |
| 53: Negative Sales, HOA, Property Taxes and Other Expenses Authorized by the COR | |
| Total Estimated Proposed Cost for Special FAR Option | |
| Total Estimated Proposed Contract Value | |
| Average sales price | $ 73,366.65 |
| 21: Appraisal Fee Base | $ 602,077.85 |
| 22: Appraisal Fee Option 1 | $ 1,206,286.58 |
| 31: Record Retention/File Delivery | $ 100,000.00 |
| 41: Post Closing Complaints | $ 68,456.33 |
| 51: Negative Sales, HOA, Property Taxes and Other Expenses Authorized by the COR | $ 1,136,912.66 |
| Average sales price option year one | $ 77,034.98 |
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.