Attachment 5- Price Workbook.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- 1231ME26Q0001
About this file
This is a pricing workbook template for submitting quotations on foreclosure legal services across three states (Arkansas, North Carolina, and South Carolina) under USDA Rural Development's RFQ 1231ME26Q0001. Contractors must enter unit pricing for nine CLINs per state in the designated yellow-highlighted cells, with estimated quantities of 100 cases per state for evaluation purposes only. The pricing structure includes firm fixed price CLINs for uncontested foreclosure services (with separate breakouts for judicial and non-judicial phases), contested foreclosure services priced per labor hour, bankruptcy services (Chapter 7 and 13) at firm fixed prices, mediation, eviction, and case removal/recall fees. Two additional CLINs establish government plug-in amounts of $25,000 for over-and-above legal fees and $257,500 for reimbursable elements, each capped at their stated not-to-exceed limits.
The workbook is structured with separate tabs for each state's base pricing and subsequent ordering periods, with formulas automatically calculating extended prices by multiplying unit prices by estimated quantities and generating a total evaluated price (TEP) across all CLINs. Contractors must not alter any formulas or rules within the workbook, as doing so constitutes an exception to the task order terms and conditions and may result in elimination from consideration. All submissions must be provided in native Microsoft Excel format (not PDF), with the contractor required to enter only the offeror name in the TEP tab and populate all mandatory pricing cells across the Base Pricing, Ordering Period 1, and Ordering Period 2 tabs to ensure accurate bid evaluation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1231ME26Q0001_0003.pdf | ||
| Attachment 1- Solicitation Terms and Conditions_0003.pdf | ||
| Attachment 5- Price Workbook_0003.xlsx | XLSX spreadsheet | |
| Exhibit A- Question and Answer Form_0003.pdf | ||
| 1231ME26Q0001_0002.pdf | ||
| Attachment 1- Solicitation Terms and Conditions_0002.pdf | ||
| Exhibit A- Question and Answer Form_0001.pdf | ||
| Attachment 1- Solicitation Terms and Conditions_0001.pdf | ||
| 1231ME26Q0001_0001.pdf | ||
| 1231ME26Q0001.pdf | ||
| Attachment 4 - QASP.docx | DOCX document | |
| Attachement 3 - Invoice Template.xlsx | XLSX spreadsheet | |
| Attachment 1- Solicitation Terms and Conditions.docx | DOCX document | |
| Attachment 2- Performance Work Statement (PWS).docx | DOCX document | |
| Exhibit A- Question and Answer Form.xlsx | XLSX spreadsheet | |
| Exhibit B- Past Performance Questionnaire.docx | DOCX document |
Show all 16
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 to Contractors Pricing Workbook Instructions to Contractors
I. Introduction
| This tab explains how the required information should be entered. It is VERY IMPORTANT that respondents follow these instructions carefully as incorrect use of the workbook could result in incorrect bids. | |
| Note that alteration of any of the formulas or rules in this workbook shall be considered to be an exception to the task order terms and conditions and may result in elimination of the contractor from consideration. Columns F, L & R contain the pricing formulas. | |
| 1 | Pricing Instructions: Offerors shall use this workbook to submit all proposed pricing to USDA Rural Development. |
| 2 | All Microsoft Excel spreadsheets shall be submitted in Microsoft Excel format (no PDF). |
| 3 | Offerors must fill in required cells in the following tabs, TEP, Base Pricing, Ordering Period 1, and Ordering Period 2. |
II. TEP Tab Instructions
| 1 | Contractors shall limit their data entry to the "Offerors Name" field in row 1 in the TEP tab and the workbook cells highlighted in yellow (all other cells shall not be modified). |
| 2 | There are no other cells to populate on this tab. The TEP is automatically calculated as the sum of the extended pricing of tabs Base Pricing Pricing. |
| 3 | Labor rate shall include salary, fringe benefits, indirect costs, profit, plus out-year escalation, as applicable, for the base year and option years. |
III. Workbook Structure
1 The estimated quantity apon award is 100 cases per state. A quantity of 1 for each pricing element is used for evaluation purposes only.
IV. Base Pricing Pricing Tab Instructions
1 The "Base Pricing" tab contains yellow highlighted cells for entry of Offerors unit pricing by CLINs for each State for the ordering period. The Government has provided anticipated quantities for each CLIN for evaluation purposes only. Offerors must enter a proposed unit price for each and every CLIN and for each contract period. Proposed unit prices will be multiplied by the Government quantity to develop an Extended Price for each CLIN. CLIN extended prices will be automatically totaled to develop the Extended Price for each CLIN.
TEP
| Offerors Name: | |||
| CLIN PRICING FOR ARKANSAS | |||
| CLIN | CLIN DESCRIPTION | BASE YEAR | |
| CLIN X001 | Uncontested Foreclosure Services: | ||
| Flat fee legal services for uncontested non-judicial foreclosure services, including all required filings, notices, court or trustee actions and standard reporting. | $ - 0 | ||
| CLIN X002 | Contested Foreclosure Services Judicial: | ||
| Legal services required once a foreclosure becomes contested, including litigation support, hearings, motions and related actions. | $ - 0 | ||
| CLIN X003 | Bankruptcy Services Chapter 7: | ||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | $ - 0 | ||
| CLIN X004 | Bankruptcy Services Chapter 13: | ||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | $ - 0 | ||
| CLIN X005 | Mediation | $ - 0 | |
| CLIN X006 | Eviction | $ - 0 | |
| CLIN X007 | Removed / Recalled Case Fee / (if required) | $ - 0 | |
| CLIN X008 | Over and Above Legal Fees, NTE $25,000.00 | $ 25,000.00 | |
| CLIN X009 | Reimbursable Elements, NTE $257,500.00 | $ 257,500.00 | |
| TOTAL EVALUATED PRICE (TEP) | $ 282,500.00 |
| CLIN PRICING FOR NORTH CAROLINA | |||
| CLIN | CLIN DESCRIPTION | BASE YEAR | |
| CLIN X001 | Uncontested Foreclosure Services: | ||
| Flat fee legal services for uncontested non-judicial foreclosure services, including all required filings, notices, court or trustee actions and standard reporting. | $ - 0 | ||
| CLIN X002 | Contested Foreclosure Services Judicial: | ||
| Legal services required once a foreclosure becomes contested, including litigation support, hearings, motions and related actions. | $ - 0 | ||
| CLIN X003 | Bankruptcy Services Chapter 7: | ||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | $ - 0 | ||
| CLIN X004 | Bankruptcy Services Chapter 13: | ||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | $ - 0 | ||
| CLIN X005 | Mediation | $ - 0 | |
| CLIN X006 | Eviction | $ - 0 | |
| CLIN X007 | Removed / Recalled Case Fee / (if required) | $ - 0 | |
| CLIN X008 | Over and Above Legal Fees, NTE $25,000.00 | $ 25,000.00 | |
| CLIN X009 | Reimbursable Elements, NTE $257,500.00 | $ 257,500.00 | |
| TOTAL EVALUATED PRICE (TEP) | $ 282,500.00 |
| CLIN PRICING FOR SOUTH CAROLINA | |||
| CLIN | CLIN DESCRIPTION | BASE YEAR | |
| CLIN X001 | Uncontested Foreclosure Services: | ||
| Flat fee legal services for uncontested non-judicial foreclosure services, including all required filings, notices, court or trustee actions and standard reporting. | $ - 0 | ||
| CLIN X002 | Contested Foreclosure Services Judicial: | ||
| Legal services required once a foreclosure becomes contested, including litigation support, hearings, motions and related actions. | $ - 0 | ||
| CLIN X003 | Bankruptcy Services Chapter 7: | ||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | $ - 0 | ||
| CLIN X004 | Bankruptcy Services Chapter 13: | ||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | $ - 0 | ||
| CLIN X005 | Mediation | $ - 0 | |
| CLIN X006 | Eviction | $ - 0 | |
| CLIN X007 | Removed / Recalled Case Fee / (if required) | $ - 0 | |
| CLIN X008 | Over and Above Legal Fees, NTE $25,000.00 | $ 25,000.00 | |
| CLIN X009 | Reimbursable Elements, NTE $257,500.00 | $ 257,500.00 | |
| TOTAL EVALUATED PRICE (TEP) | $ 282,500.00 |
Base Pricing
| PRICING WORKSHEET - BASE PERIOD | |||||||||||||||
| STATE OF ARKANSAS | CONTRACTOR ONLY INPUT | STATE OF NORTH CAROLINA | CONTRACTOR ONLY INPUT | STATE OF SOUTH CAROLINA | CONTRACTOR ONLY INPUT | ||||||||||
| CLIN | CLIN DESCRIPTION | UNIT | EST. QTY (#) | UNIT PRICE | CLIN | CLIN DESCRIPTION | UNIT | EST. QTY (#) | UNIT PRICE | CLIN | CLIN DESCRIPTION | UNIT | EST. QTY (#) | UNIT PRICE | |
| CLIN 0001 | Uncontested Foreclosure Services: | ||||||||||||||
| Flat fee legal services for uncontested non-judicial foreclosure services in Arkansas, including all required filings, notices, court or trustee actions and standard reporting. | Firm Fixed Price | 100 | $ - 0 | CLIN 0001 | Uncontested Foreclosure Services: | ||||||||||
| Flat fee legal services for uncontested quasi-judicial foreclosure services in North Carolina, including all required filings, notices, court or trustee actions and standard reporting. | Firm Fixed Price | 100 | CLIN 0001 | Uncontested Foreclosure Services: | |||||||||||
| Flat fee legal services for uncontested judicial foreclosure services in South Carolina, including all required filings, notices, court or trustee actions and standard reporting. | Firm Fixed Price | 100 | |||||||||||||
| CLIN 0001A | Judicial FCL (40%) Review of Title and preceding actions (If applicable) | $ - 0 | CLIN 0001A | Judicial FCL (40%) Review of Title and preceding actions (If applicable) | $ - 0 | CLIN 0001A | Judicial FCL (40%) Review of Title and preceding actions (If applicable) | $ - 0 | |||||||
| CLIN 0001B | Judicial FCL (60%) Foreclosure sale held/Documents recorded (If applicable) | $ - 0 | CLIN 0001B | Judicial FCL (60%) Foreclosure sale held/Documents recorded (If applicable) | $ - 0 | CLIN 0001B | Judicial FCL (60%) Foreclosure sale held/Documents recorded (If applicable) | $ - 0 | |||||||
| CLIN 0001C | Non-Judicial FCL (65%) Review of Title and preceding actions (If applicable) | $ - 0 | CLIN 0001C | Quasi Judicial FCL (65%) Review of Title and preceding actions (If applicable) | $ - 0 | CLIN 0001C | Non-Judicial FCL (65%) Review of Title and preceding actions (If applicable) | $ - 0 | |||||||
| CLIN 0001D | Non-Judicial FCL (35%) Foreclosure sale held/Documents recorded (If applicable) | $ - 0 | CLIN 0001D | Quasi Judicial FCL (35%) Foreclosure sale held/Documents recorded (If applicable) | $ - 0 | CLIN 0001D | Non-Judicial FCL (35%) Foreclosure sale held/Documents recorded (If applicable) | $ - 0 | |||||||
| CLIN 0002 | Contested Foreclosure Services Judicial: | ||||||||||||||
| Legal services required once a foreclosure in Arkansas becomes contested, including litigation support, hearings, motions and related actions. | Labor Hour | 1 | CLIN 0002 | Contested Foreclosure Services Judicial: | |||||||||||
| Legal services required once a foreclosure in North Carolina becomes contested, including litigation support, hearings, motions and related actions. | Labor Hour | 1 | CLIN 0002 | Contested Foreclosure Services Judicial: | |||||||||||
| Legal services required once a foreclosure in South Carolina becomes contested, including litigation support, hearings, motions and related actions | Labor Hour | 1 | |||||||||||||
| CLIN 0003 | Bankruptcy Services Chapter 7: | ||||||||||||||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | Firm Fixed Price | 10 | CLIN 0003 | Bankruptcy Services Chapter 7: | |||||||||||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | Firm Fixed Price | 10 | CLIN 0003 | Bankruptcy Services Chapter 7: | |||||||||||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | Firm Fixed Price | 10 | |||||||||||||
| CLIN 0004 | Bankruptcy Services Chapter 13: | ||||||||||||||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | Firm Fixed Price | 10 | CLIN 0004 | Bankruptcy Services Chapter 13: | |||||||||||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | Firm Fixed Price | 10 | CLIN 0004 | Bankruptcy Services Chapter 13: | |||||||||||
| Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules. | Firm Fixed Price | 10 | |||||||||||||
| CLIN 0005 | Mediation | Firm Fixed Price | 20 | CLIN 0005 | Mediation | Firm Fixed Price | 20 | CLIN 0005 | Mediation | Firm Fixed Price | 20 | ||||
| CLIN 0006 | Eviction | Firm Fixed Price | 5 | CLIN 0006 | Eviction | Firm Fixed Price | 5 | CLIN 0006 | Eviction | Firm Fixed Price | 5 | ||||
| CLIN 0007 | Removed / Recalled Case Fee / (if required) | Firm Fixed Price | 10 | CLIN 0007 | Removed / Recalled Case Fee / (if required) | Firm Fixed Price | 10 | CLIN 0007 | Removed / Recalled Case Fee / (if required) | Firm Fixed Price | 10 | ||||
| CLIN 0008 | Over and Above Legal Fees, NTE $25,000.00 (Gov. plug-in) | Lump Sum | 1 | $ 25,000.00 | CLIN 0008 | Over and Above Legal Fees, NTE $25,000.00 (Gov. plug-in) | Lump Sum | 1 | $ 25,000.00 | CLIN 0008 | Over and Above Legal Fees, NTE $25,000.00 (Gov. plug-in) | Lump Sum | 1 | $ 25,000.00 | |
| CLIN 0009 | Reimbursable Elements, NTE $257,500.00 (Gov. plug-in) | Lump Sum | 1 | $ 257,500.00 | CLIN 0009 | Reimbursable Elements, NTE $257,500.00 (Gov. plug-in) | Lump Sum | 1 | $ 257,500.00 | CLIN 0009 | Reimbursable Elements, NTE $257,500.00 (Gov. plug-in) | Lump Sum | 1 | $ 257,500.00 | |
| TOTALS | 158 | $ 282,500.00 | 158 | $ 282,500.00 | 158 | $ 282,500.00 |
File details come from the government source that posted it. Updated .