2.2.1 Attachment 9 - Pricing Template.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
DR4832TN Direct Lease BPA Federal contract opportunity
Solicitation number
70FBR425Q00000044
Issued by
Federal Emergency Management Agency

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 for this federal contract opportunity

Other files attached to DR4832TN Direct Lease BPA, newest first.
File Type Posted
2.4.1 70FBR425Q00000044 Amendment 0002.pdf PDF
Direct Lease RFQ Questions and Responses 4832-TN Final .pdf PDF
2.4.1 70FBR425Q00000044 Amendment 0001.pdf PDF
2.2.1 Attachment 1 - DR-4832-TN Direct Lease Property Tracking Sheet.xlsx XLSX spreadsheet
1.1.4 Direct Lease BPA Statement of Work.pdf PDF
2.2.4 Attachment 2 - DR-4832-TN Direct Lease Rental Resource FMR.xlsx XLSX spreadsheet
2.2.4 Attachment 9 - Pricing Template Amendment 0001.xlsx XLSX spreadsheet
2.2.1 Attachment 2 - DR-4832-TN Direct Lease Rental Resource FMR.xlsx XLSX spreadsheet
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
2.2.1 Request for Quote 70FBR425Q00000044 Direct Lease Final.pdf PDF
2.2.1 Attachment 1 - DR-4832-TN Direct Lease Property Tracking Sheet.xlsx XLSX spreadsheet
2.2.1 Attachment 4 - DR-4832-TN Direct Lease Contract Terms and Conditions.pdf PDF
2.2.1 Attachment 5 - DR-4832-TN Direct Lease Occupant Lease Agreement.docx DOCX document
2.2.1 Attachment 6 - DR-4832-TN Direct Lease - Lease Addendum Final.docx DOCX document
2.2.1 Attachment 7 - DR-4832-TN Temporary Housing Agreement.pdf PDF
Show all 17

On GovTribe

Work with this file on GovTribe

  • 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 .