1.1.4 SOW Attachment 11 - Pricing CLIN Structure Spreadsheet_DR-4724-HI.xlsx
XLSX spreadsheet 68 KB Posted
- Attached to
- Direct Lease DR4724 Hawaii Federal contract opportunity
- Solicitation number
- 70FBR923Q00000061
About this file
This document contains a statement of work attachment and pricing structure spreadsheet for a direct lease solicitation from the Federal Emergency Management Agency Region 9 related to disaster support in Hawaii. The solicitation seeks monthly rental rates for furnished and unfurnished one, two, three and four bedroom units on a firm-fixed-price basis for an initial 12-month base period and one six-month option period. The spreadsheet details cost estimates for property management and maintenance fees calculated as percentages and one-time fees for set-up and early termination. It also includes a letter of credit section outlining estimated monthly and annual expenses for flood response coordination, special travel allowance, postage and postal express services, and litigation claims review totaling over $3.9 million annually.
View the file
Other files for this federal contract opportunity
Show all 15
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
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
| TYPE YOUR COMPANY NAME HERE | Base Period (12 Months) | Option Period 1 (6 Months) | ||||||||||
| CLIN | Description | POP | Cost | Total | Quantity | Base Period Total | CLIN | POP | Cost | Total | Quantity | Option Period 1 Total |
| Direct Lease Overall Pricing Breakdown | ||||||||||||
| 0001 | CLIN 0001 Monthly Rent (Informational CLIN Only) | 1001 | CLIN 1001 Monthly Rent (Informational CLIN Only) | |||||||||
| See subCLINs for Pricing | ||||||||||||
| 0001AA | 1 Bedroom Un-Furnished Monthly Rent FFP | 12 | $ - 0 | 1 | $ - 0 | 1001AA | 6 | $ - 0 | 1 | $ - 0 | ||
| 0001AB | 1 Bedroom Furniture Cost FFP | 12 | $ - 0 | 1 | $ - 0 | 1001AB | 6 | $ - 0 | 1 | $ - 0 | ||
| 0001AC | 1 Bedroom Utilities Monthly FFP | 12 | $ - 0 | 1 | $ - 0 | 1001AC | 6 | $ - 0 | 1 | $ - 0 | ||
| 0002AA | 2 Bedroom Un-Furnished Monthly Rent FFP | 12 | $ - 0 | 1 | $ - 0 | 1002AA | 6 | $ - 0 | 1 | $ - 0 | ||
| 0002AB | 2 Bedroom Furniture Cost FFP | 12 | $ - 0 | 1 | $ - 0 | 1002AB | 6 | $ - 0 | 1 | $ - 0 | ||
| 0002AC | 2 Bedroom Utilities Monthly FFP | 12 | $ - 0 | 1 | $ - 0 | 1002AC | 6 | $ - 0 | 1 | $ - 0 | ||
| 0003AA | 3 Bedroom Un-Furnished Monthly Rent FFP | 12 | $ - 0 | 1 | $ - 0 | 1003AA | 6 | $ - 0 | 1 | $ - 0 | ||
| 0003AB | 3 Bedroom Furniture Cost FFP | 12 | $ - 0 | 1 | $ - 0 | 1003AB | 6 | $ - 0 | 1 | $ - 0 | ||
| 0003AC | 3 Bedroom Utilities Monthly FFP | 12 | $ - 0 | 1 | $ - 0 | 1003AC | 6 | $ - 0 | 1 | $ - 0 | ||
| 0004AA | 4 Bedroom Un-Furnished Monthly Rent FFP | 12 | $ - 0 | 1 | $ - 0 | 1004AA | 6 | $ - 0 | 1 | $ - 0 | ||
| 0004AB | 4 Bedroom Furniture Cost FFP | 12 | $ - 0 | 1 | $ - 0 | 1004AB | 6 | $ - 0 | 1 | $ - 0 | ||
| 0004AC | 4 Bedroom Utilities Monthly FFP | 12 | $ - 0 | 1 | $ - 0 | 1004AC | 6 | $ - 0 | 1 | $ - 0 | ||
| 0005 | Property Management Fee (Calculate using Mgt %) FFP | 12 | 1005 | 6 | ||||||||
| 0006 | Maintenance Fee (Calculate using Maint %) FFP | 12 | 1006 | 6 | ||||||||
| 0007 | One Time Set Up Fee | 1 | $ - 0 | 1 | $ - 0 | |||||||
| 0008 | Early Termination Fee FFP | 1 | $ - 0 | 1 | $ - 0 | |||||||
| 0009 | Security Deposit (Retained by FEMA) | 1 | $ - 0 | 1 | $ - 0 |
Total $0.00 $0.00 $0.00 $0.00
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 .