2.2.4 Attachment 9 - Pricing Template Amendment 0001.xlsx

28 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 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

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.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 9 - Pricing Template.xlsx XLSX spreadsheet
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 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 .