2.2.4 Attachment 9 - Pricing Template Amendment 0001.xlsx

XLSX spreadsheet 28 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 for a Direct Lease Blanket Purchase Agreement (BPA) that includes multiple pricing sections. The template covers a base year (FY20) and four option years through FY24, with a total contract value of $75,319,468.80. The direct labor FFP component starts at $12,288,000 annually in the base year and escalates to $17,990,860.80 in option year 4. Travel costs are budgeted at $60,000 per year ($5,000 monthly) across all periods.

The template includes sections for direct lease pricing of furnished units (1-4 bedrooms), with fields for monthly rental rates, property management fees, and maintenance costs for 46 total units (18 one-bedroom, 19 two-bedroom, 7 three-bedroom, and 2 four-bedroom units) over 24 months. Additional line items cover ADA retrofitting, early termination fees, and damage/security deposits. A Letter of Credit section details historical costs including flood response ($136,356 annually), special travel ($60,000), postage ($3.6M), postal express services ($60,000), and litigation claims review ($120,000), totaling $3,976,356 annually.

View the file

Other files for this federal contract opportunity

Other files attached to DR4832TN Direct Lease BPA, newest first.
File Type Posted
Direct Lease RFQ Questions and Responses 4832-TN Final .pdf PDF
2.4.1 70FBR425Q00000044 Amendment 0002.pdf PDF
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.4.1 70FBR425Q00000044 Amendment 0001.pdf PDF
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 8 - DR-4832-TN End of Program Notice to Property Owner or Manager.docx DOCX document
2.2.1 Attachment 9 - Pricing Template.xlsx XLSX spreadsheet
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
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
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 HERE
CLINDescriptionQuantityMonthly Unit Rental RateProperty Management FeeMonthly Maintenance & UltilitiesTotal MonthsExtended Price
Direct Lease Overall Pricing Breakdown
00011 Bedroom Furnished Unit (inclusive of applicable fees) Firm Fixed Price18$ - 0$ - 0$ - 024$0.00
00022 Bedroom Furnished Unit (inclusive of applicable fees) Firm Fixed Price19$ - 0$ - 0$ - 024$0.00
00033 Bedroom Furnished Unit (inclusive of applicable fees) Firm Fixed Price7$ - 0$ - 0$ - 024$0.00
00044 Bedroom Furnished Unit (inclusive of applicable fees) Firm Fixed Price2$ - 0$ - 0$ - 024$0.00
0005ADA retrofit for units - One Time Install22NANANANA$ - 0
0006Early Termination Fee Adjustible FFP (Not to Exceed Two Months Rent Per Unit)46NANANANA$ - 0
0007Damage/Security Deposit Firm Fixed Price (Retained by FEMA) (Not to Exceed One Months Rent per Unit)46NANANANA$ - 0
Total Estimated BPA Value$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 .