Attachment 5- Price Workbook_12SAD226Q0003.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Foreclosure Legal Services & Related Technical Support for the States of North Carolina, South Carolina, and Arkansas
Solicitation number
12SAD226Q0003
Issued by

About this file

This is a pricing workbook template for the USDA Rural Development Request for Quotation (RFQ) 12SAD226Q0003 for Foreclosure Legal Services & Related Technical Support across North Carolina, South Carolina, and Arkansas. Offerors must submit pricing in Microsoft Excel format using the provided workbook structure, with mandatory entries limited to the "Offeror's Name" field and yellow-highlighted cells only; any formula alterations will result in elimination from consideration. The workbook contains separate pricing tabs for three states (Arkansas, North Carolina, and South Carolina), with contractors required to propose unit prices for nine Contract Line Item Numbers (CLINs) spanning uncontested foreclosure services, contested judicial foreclosure services, Chapter 7 and Chapter 13 bankruptcy services, mediation, eviction, case removal/recall fees, over-and-above legal fees (not-to-exceed $25,000), and reimbursable elements (not-to-exceed $257,500).

The government has established estimated quantities of 100 cases per state for evaluation purposes only, with base year pricing structured as follows: uncontested foreclosure services use a firm fixed price unit, contested foreclosure services are priced at labor hours, bankruptcy and mediation services utilize firm fixed pricing with estimated quantities of 10 and 20 respectively, eviction services are priced at 5 units, and case removal fees are estimated at 10 units. The total evaluated price for each state is $282,500 in the base year, composed of the contractor's pricing for CLINs 0001-0007 plus the government-provided plug-in amounts for over-and-above fees and reimbursable elements. The workbook automatically calculates extended pricing and totals, with contractors required to complete equivalent pricing tabs for each contract period (Base Pricing, Ordering Period 1, and Ordering Period 2).

View the file

Other files

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.
1Pricing Instructions: Offerors shall use this workbook to submit all proposed pricing to USDA Rural Development.
2All Microsoft Excel spreadsheets shall be submitted in Microsoft Excel format (no PDF).
3Offerors must fill in required cells in the following tabs, TEP, Base Pricing, Ordering Period 1, and Ordering Period 2.

II. TEP Tab Instructions

1Contractors 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).
2There 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.
3Labor 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
CLINCLIN DESCRIPTIONBASE YEAR
CLIN X001Uncontested 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 X002Contested Foreclosure Services Judicial:
Legal services required once a foreclosure becomes contested, including litigation support, hearings, motions and related actions.$ - 0
CLIN X003Bankruptcy Services Chapter 7:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.$ - 0
CLIN X004Bankruptcy Services Chapter 13:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.$ - 0
CLIN X005Mediation$ - 0
CLIN X006Eviction$ - 0
CLIN X007Removed / Recalled Case Fee / (if required)$ - 0
CLIN X008Over and Above Legal Fees, NTE $25,000.00$ 25,000.00
CLIN X009Reimbursable Elements, NTE $257,500.00$ 257,500.00
TOTAL EVALUATED PRICE (TEP)$ 282,500.00
CLIN PRICING FOR NORTH CAROLINA
CLINCLIN DESCRIPTIONBASE YEAR
CLIN X001Uncontested 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 X002Contested Foreclosure Services Judicial:
Legal services required once a foreclosure becomes contested, including litigation support, hearings, motions and related actions.$ - 0
CLIN X003Bankruptcy Services Chapter 7:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.$ - 0
CLIN X004Bankruptcy Services Chapter 13:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.$ - 0
CLIN X005Mediation$ - 0
CLIN X006Eviction$ - 0
CLIN X007Removed / Recalled Case Fee / (if required)$ - 0
CLIN X008Over and Above Legal Fees, NTE $25,000.00$ 25,000.00
CLIN X009Reimbursable Elements, NTE $257,500.00$ 257,500.00
TOTAL EVALUATED PRICE (TEP)$ 282,500.00
CLIN PRICING FOR SOUTH CAROLINA
CLINCLIN DESCRIPTIONBASE YEAR
CLIN X001Uncontested 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 X002Contested Foreclosure Services Judicial:
Legal services required once a foreclosure becomes contested, including litigation support, hearings, motions and related actions.$ - 0
CLIN X003Bankruptcy Services Chapter 7:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.$ - 0
CLIN X004Bankruptcy Services Chapter 13:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.$ - 0
CLIN X005Mediation$ - 0
CLIN X006Eviction$ - 0
CLIN X007Removed / Recalled Case Fee / (if required)$ - 0
CLIN X008Over and Above Legal Fees, NTE $25,000.00$ 25,000.00
CLIN X009Reimbursable Elements, NTE $257,500.00$ 257,500.00
TOTAL EVALUATED PRICE (TEP)$ 282,500.00

Base Pricing

PRICING WORKSHEET - BASE PERIOD
STATE OF ARKANSASCONTRACTOR ONLY INPUTSTATE OF NORTH CAROLINACONTRACTOR ONLY INPUTSTATE OF SOUTH CAROLINACONTRACTOR ONLY INPUT
CLINCLIN DESCRIPTIONUNITEST. QTY (#)UNIT PRICECLINCLIN DESCRIPTIONUNITEST. QTY (#)UNIT PRICECLINCLIN DESCRIPTIONUNITEST. QTY (#)UNIT PRICE
CLIN 0001Uncontested 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 Price100$ - 0CLIN 0001Uncontested 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 Price100CLIN 0001Uncontested 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 Price100
CLIN 0001 Invoicing Increment 1Judicial FCL (40%) Review of Title and preceding actions (If applicable)$ - 0CLIN 0001AJudicial FCL (40%) Review of Title and preceding actions (If applicable)$ - 0CLIN 0001AJudicial FCL (40%) Review of Title and preceding actions (If applicable)$ - 0
CLIN 0001 Invoicing Increment 2Judicial FCL (60%) Foreclosure sale held/Documents recorded (If applicable)$ - 0CLIN 0001BJudicial FCL (60%) Foreclosure sale held/Documents recorded (If applicable)$ - 0CLIN 0001BJudicial FCL (60%) Foreclosure sale held/Documents recorded (If applicable)$ - 0
CLIN 0001 Invoicing Increment 3Non-Judicial FCL (65%) Review of Title and preceding actions (If applicable)$ - 0CLIN 0001CQuasi Judicial FCL (65%) Review of Title and preceding actions (If applicable)$ - 0CLIN 0001CNon-Judicial FCL (65%) Review of Title and preceding actions (If applicable)$ - 0
CLIN 0001 Invoicing Increment 4Non-Judicial FCL (35%) Foreclosure sale held/Documents recorded (If applicable)$ - 0CLIN 0001DQuasi Judicial FCL (35%) Foreclosure sale held/Documents recorded (If applicable)$ - 0CLIN 0001DNon-Judicial FCL (35%) Foreclosure sale held/Documents recorded (If applicable)$ - 0
CLIN 0002Contested Foreclosure Services Judicial:
Legal services required once a foreclosure in Arkansas becomes contested, including litigation support, hearings, motions and related actions.Labor Hour1CLIN 0002Contested Foreclosure Services Judicial:
Legal services required once a foreclosure in North Carolina becomes contested, including litigation support, hearings, motions and related actions.Labor Hour1CLIN 0002Contested Foreclosure Services Judicial:
Legal services required once a foreclosure in South Carolina becomes contested, including litigation support, hearings, motions and related actionsLabor Hour1
CLIN 0003Bankruptcy Services Chapter 7:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.Firm Fixed Price10CLIN 0003Bankruptcy Services Chapter 7:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.Firm Fixed Price10CLIN 0003Bankruptcy Services Chapter 7:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.Firm Fixed Price10
CLIN 0004Bankruptcy Services Chapter 13:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.Firm Fixed Price10CLIN 0004Bankruptcy Services Chapter 13:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.Firm Fixed Price10CLIN 0004Bankruptcy Services Chapter 13:
Bankruptcy-related legal services aligned with Fannie Mae/Freddie Mac fee schedules.Firm Fixed Price10
CLIN 0005MediationFirm Fixed Price20CLIN 0005MediationFirm Fixed Price20CLIN 0005MediationFirm Fixed Price20
CLIN 0006EvictionFirm Fixed Price5CLIN 0006EvictionFirm Fixed Price5CLIN 0006EvictionFirm Fixed Price5
CLIN 0007Removed / Recalled Case Fee / (if required)Firm Fixed Price10CLIN 0007Removed / Recalled Case Fee / (if required)Firm Fixed Price10CLIN 0007Removed / Recalled Case Fee / (if required)Firm Fixed Price10
CLIN 0008Over and Above Legal Fees, NTE $25,000.00 (Gov. plug-in)Lump Sum1$ 25,000.00CLIN 0008Over and Above Legal Fees, NTE $25,000.00 (Gov. plug-in)Lump Sum1$ 25,000.00CLIN 0008Over and Above Legal Fees, NTE $25,000.00 (Gov. plug-in)Lump Sum1$ 25,000.00
CLIN 0009Reimbursable Elements, NTE $257,500.00 (Gov. plug-in)Lump Sum1$ 257,500.00CLIN 0009Reimbursable Elements, NTE $257,500.00 (Gov. plug-in)Lump Sum1$ 257,500.00CLIN 0009Reimbursable Elements, NTE $257,500.00 (Gov. plug-in)Lump Sum1$ 257,500.00
TOTALS158$ 282,500.00158$ 282,500.00158$ 282,500.00

File details come from the government source that posted it. Updated .