Attachment 12 - Pricing CLIN Structure Spreadsheet DR-4630-KY.xlsx
XLSX spreadsheet 72 KB Posted
- Attached to
- DIRECT LEASE PROGRAM-FOR DR-4630-KY
- Solicitation number
- 70FBR422Q0000036
View the file
Other files
Show all 15
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
Overview IGCE
| Base Year (FY20) | OY 1 (FY21) | OY2 (FY22) | OY3 (FY23) | OY4 (FY24) | Totals | ||||||
| CLIN | Monthly | Annual | Monthly | Annual | Monthly | Annual | Monthly | Annual | Monthly | Annual | |
| Direct Labor | |||||||||||
| FFP Labor | ERROR:#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 | ||||||
| CLIN | Monthly | Annual | Monthly | Annual | Monthly | Annual | Monthly | Annual | Monthly | Annual | |
| 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 | |||||||||||
| LOC | N/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
| Base Period (12 Months) | Option Period 1 (3 Months) | Option Period 2 (3 Months) | |||||||||||||||
| Description | POP | Monthly Rent | Total | Quantity | Base Period Total | POP | Monthly Rent | Total | Quantity | Option Period 1 Total | POP | Monthly Rent | Total | Quantity | Option Period 2 Total | ||
| Part A Standard Operations | |||||||||||||||||
| CLIN 0001 Monthly Rent | $1.03 | Note: Labor Rates have 3% escalation each year. | 1.03 | ||||||||||||||
| Monthly Rental Cost | 0 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 0001AA Furnished Monthly Rent | Note: Labor Rates have 3% escalation each year. | 1.03 | |||||||||||||||
| 1 Bedroom Furnished FFP | 12 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 0001AB Furnished Monthly Rent | Note: Labor Rates have 3% escalation each year. | 1.03 | |||||||||||||||
| 2 Bedroom Furnished FFP | 12 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 0001AC Furnished Monthly Rent | Note: Labor Rates have 3% escalation each year. | 1.03 | |||||||||||||||
| 3 Bedroom Furnished FFP | 12 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 0001AD Furnished Monthly Rent | Note: Labor Rates have 3% escalation each year. | 1.03 | |||||||||||||||
| 4 Bedroom Furnished FFP | 12 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 0002 Property Management Fee NTE 10% | |||||||||||||||||
| Management Fee (Calculate using Mgt %) FFP | 12 | $0.00 | $0.00 | 10% | $0.00 | ||||||||||||
| CLIN 0003 Maintenace Fee NTE 7% | |||||||||||||||||
| Property Maintenance Fee FFP | 12 | $0.00 | $0.00 | 7% | $0.00 | ||||||||||||
| CLIN 0004 Set Up | |||||||||||||||||
| One Time Set Up Fee (*Indicates No monthly fee) FFP | 1 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 0005 Early Termination Fee | |||||||||||||||||
| Early Termination Fee FFP | 1 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 0006 Negotiated Month to Month Rent | |||||||||||||||||
| Month to Month FFP | 1 | $0.00 | $0.00 | 3 | $0.00 | ||||||||||||
| CLIN 0007 Security Deposit | |||||||||||||||||
| Security Deposit (Retained by FEMA) | 1 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 1001 Option 1 Monthly Rent | |||||||||||||||||
| Monthly Rental Cost | 0 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 1001AA Option 1 Furnished Monthly Rent | |||||||||||||||||
| One (1) Bedroom Furnished FFP | 3 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 1001AB Option 1 Furnished Monthly Rent | |||||||||||||||||
| Two (2) Bedroom Furnished FFP | 3 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 1001AC Option 1 Furnished Monthly Rent | |||||||||||||||||
| Three (3) Bedroom Furnished FFP | 3 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 1001AD Option 1 Furnished Monthly Rent | |||||||||||||||||
| Four (4) Bedroom Furnished FFP | 3 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 1002 Property Management Fee NTE 10% | |||||||||||||||||
| Property Management Fee FFP | 3 | $0.00 | $0.00 | 10% | $0.00 | ||||||||||||
| CLIN 1003 Maintenance Fee NTE 7% | |||||||||||||||||
| Property Maintenance Fee FFP | 3 | $0.00 | $0.00 | 7% | $0.00 | ||||||||||||
| CLIN 2001 Option 2 Monthly Rent | |||||||||||||||||
| Monthly Rental Cost | 0 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 2001AA Option 2 Furnished Monthly Rent | |||||||||||||||||
| One (1) Bedroom Furnished FFP | 3 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 2001AB Option 2 Furnished Monthly Rent | |||||||||||||||||
| Two (2) Bedroom Furnished FFP | 3 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 2001AC Option 2 Furnished Monthly Rent | |||||||||||||||||
| Three (3) Bedroom Furnished FFP | 3 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 2001AD Option 2 Furnished Monthly Rent | |||||||||||||||||
| Four (4) Bedroom Furnished FFP | 3 | $0.00 | $0.00 | 1 | $0.00 | ||||||||||||
| CLIN 2002 Option 2 Property Management Fee | |||||||||||||||||
| Property Management Fee (NTE 10%) FFP | 3 | $0.00 | $0.00 | 10% | $0.00 | ||||||||||||
| CLIN 2003 Maintenanc Fee NTE 7% | |||||||||||||||||
| Property Management Fee FFP | 3 | $0.00 | $0.00 | 7% | $0.00 |
| Total | ||||||||
| 76 | $0.00 | 18 | 0 | $0.00 | 18 | 0 | $0.00 | |
| PROJECT TOTAL |
Letter of Credit - Historical
LETTER OF CREDIT
| Expense Description | Monthly | Annual | Note: 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 .