2.2.1 Attachment 9 - Pricing Template.xlsx

31 KB Posted

Attached to
DR4832TN Direct Lease BPA
Solicitation number
70FBR425Q00000044
Issued by

About this file

Written by GovTribe AI ·

This is a pricing template spreadsheet containing multiple sections for cost breakdowns related to FEMA's Direct Lease program for Tropical Storm Helene disaster housing. The template includes a five-year breakdown (base year plus four option years) of direct labor costs totaling $75,019,468.80, with annual travel costs of $60,000, reaching a total contract value of $75,319,468.80.

The template also includes detailed pricing tables for direct lease housing units, broken down by bedroom size (1-4 bedrooms) with separate line items for furnished monthly rent, management fees (10%), and utilities. Additional CLINs cover ADA retrofitting, early termination fees, and security deposits. A Letter of Credit section outlines historical monthly costs including Flood Response and Claims ($136,356/year), special travel ($60,000/year), postage ($3.6M/year), postal express services ($60,000/year), and litigation claims review ($120,000/year), totaling approximately $3.97M annually.

View the file

Other files

File Type Posted
Direct Lease RFQ Questions and Responses 4832-TN Final .pdf PDF
2.4.1 70FBR425Q00000044 Amendment 0002.pdf PDF
2.2.1 Attachment 1 - DR-4832-TN Direct Lease Property Tracking Sheet.xlsx XLSX spreadsheet
2.4.1 70FBR425Q00000044 Amendment 0001.pdf PDF
2.2.4 Attachment 2 - DR-4832-TN Direct Lease Rental Resource FMR.xlsx XLSX spreadsheet
1.1.4 Direct Lease BPA Statement of Work.pdf PDF
2.2.4 Attachment 9 - Pricing Template Amendment 0001.xlsx XLSX spreadsheet
2.2.1 Attachment 1 - DR-4832-TN Direct Lease Property Tracking Sheet.xlsx XLSX spreadsheet
2.2.1 Attachment 2 - DR-4832-TN Direct Lease Rental Resource FMR.xlsx XLSX spreadsheet
2.2.1 Attachment 5 - DR-4832-TN Direct Lease Occupant Lease Agreement.docx DOCX document
2.2.1 Request for Quote 70FBR425Q00000044 Direct Lease Final.pdf PDF
2.2.1 Attachment 4 - DR-4832-TN Direct Lease Contract Terms and Conditions.pdf PDF
2.2.1 Attachment 7 - DR-4832-TN Temporary Housing Agreement.pdf PDF
2.2.1 Attachment 6 - DR-4832-TN Direct Lease - Lease Addendum Final.docx DOCX document
2.2.1 Attachment 8 - DR-4832-TN End of Program Notice to Property Owner or Manager.docx DOCX document
2.2.1 Attachment 3 - DR-4832-TN Direct Lease Property Inspection Checklist.pdf PDF
2.2.1 Attachment 10 - RFQ Provision Fill-ins.docx DOCX document
Show all 17

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.

Overview IGCE

Base Year (FY20)OY 1 (FY21)OY2 (FY22)OY3 (FY23)OY4 (FY24)Totals
CLINMonthlyAnnualMonthlyAnnualMonthlyAnnualMonthlyAnnualMonthlyAnnual
Direct Labor
FFP LaborERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Transition in
Other Direct Costs
Travel$5,000.00$60,000.00
Other Allowable Costs
LOC
Disaster Support
Related Expenses
Subcontractor Support

Total Cost per Year

Base Year (FY20)OY 1 (FY21)OY2 (FY22)OY3 (FY23)OY4 (FY24)Totals
CLINMonthlyAnnualMonthlyAnnualMonthlyAnnualMonthlyAnnualMonthlyAnnual
Direct Labor
FFP Labor$1,024,000.00$12,288,000.00$1,126,400.00$13,516,800.00$1,239,040.00$14,868,480.00$1,362,944.00$16,355,328.00$1,499,238.40$17,990,860.80$75,019,468.80
Transition in
Other Direct Costs
Travel$5,000.00$60,000.00$5,000.00$60,000.00$5,000.00$60,000.00$5,000.00$60,000.00$5,000.00$60,000.00$300,000.00
Other Allowable Costs
LOCN/A
Disaster Support
Related Expenses
Subcontractor Support

Total Cost per Year $12,348,000.00 $13,576,800.00 $14,928,480.00 $16,415,328.00 $18,050,860.80 $75,319,468.80

Direct Lease Pricing

TYPE YOUR COMPANY NAME HEREBase Period (12 Months)Option Period 1 (6 Months)Option Period 2 (6 Months)
CLINDescriptionPOPCostTotalQuantityBase Period TotalCLINPOPCostTotalQuantityOption Period 1 TotalCLINPOPCostTotalQuantityOption Period 1 Total
Direct Lease Overall Pricing Breakdown
0001CLIN 0001 Monthly Rent (Informational CLIN Only)1001CLIN 1001 Monthly Rent (Informational CLIN Only)2001CLIN 2001 Monthly Rent (Informational CLIN Only)
See subCLINs for Pricing
0001AA1 Bedroom Furnished Monthly Rent FFP12$ - 045$ - 01001AA6$ - 045$ - 02001AA6$ - 045$ - 0
0001AB1 Bedroom Management Fee @10%12$ - 045$ - 01001AB6$ - 045$ - 02001AB6$ - 045$ - 0
0001AC1 Bedroom Utilities Monthly FFP12$ - 045$ - 01001AC6$ - 045$ - 02001AC6$ - 045$ - 0
0002AA2 Bedroom Furniture Cost FFP12$ - 035$ - 01002AA6$ - 035$ - 02002AA6$ - 035$ - 0
0002AB2 Bedroom Management Fee @10%12$ - 035$ - 01002AB6$ - 035$ - 02002AB6$ - 035$ - 0
0002AC2 Bedroom Utilities Monthly FFP12$ - 035$ - 01002AC6$ - 035$ - 02002AC6$ - 035$ - 0
0003AA3 Bedroom Furniture Cost FFP12$ - 015$ - 01003AA6$ - 015$ - 02003AA6$ - 015$ - 0
0003AB3 Bedroom Management Fee @10%12$ - 015$ - 01003AB6$ - 015$ - 02003AB6$ - 015$ - 0
0003AC3 Bedroom Utilities Monthly FFP12$ - 015$ - 01003AC6$ - 015$ - 02003AC6$ - 015$ - 0
0004AA4 Bedroom Furniture Cost FFP12$ - 05$ - 01004AA6$ - 05$ - 02004AA6$ - 05$ - 0
0004AB4 Bedroom Property Management Fee @10%12$ - 05$ - 01004AB6$ - 05$ - 02004AB6$ - 05$ - 0
0004AC4 Bedroom Utilities Monthly FFP12$ - 05$ - 01004AC6$ - 05$ - 02004AC6$ - 05$ - 0
0005ADA retrofit for units - One Time Install20$ - 01$ - 0
0006Early Termination Fee FFP100$ - 01$ - 0
0007Damage/Security Deposit (Retained by FEMA)100$ - 01$ - 0

Total $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Letter of Credit - Historical

LETTER OF CREDIT

Expense DescriptionMonthlyAnnualNote: The estimate for the Flood Response and Claims Coordinating Office's line is based on an average flood season and historical costs.
Flood Response and Claims Coordinating Office$11,363.00$136,356.00
Special Travel Allowance$5,000.00$60,000.00
Postage Expenses$300,000.00$3,600,000.00
Postal Express Services$5,000.00$60,000.00
Litigation Claims Review$10,000.00$120,000.00
Total$331,363.00$3,976,356.00

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