FOCS_Price_Cost_Worksheet_(3).xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- SOL-263-15-000004
About this file
Sample budget EXCEL sheet with formulas.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| FBO_Notice.docx | DOCX document | |
| FOCS_Amendment_1.pdf | ||
| FOCS_RFP_FINAL.pdf | ||
| FOCS_RFP_FINAL.pdf |
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
SUMMARY BUDGET
SUMMARY BUDGET
| Cost Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total All Years | |
| LINE 1 | Transition Period | ||||||
| LINE 2 | Recurring Monthly FP | ||||||
| LINE 3 | Supplies/Materials | ||||||
| LINE 4 | Vehicles | ||||||
| LINE 5 | Special Projects | ||||||
| LINE 6 | Award Fee Ceiling | ||||||
| CEILING | TOTALS |
FFP DETAIL
Inflation Factors General Assumptions for Inflation Only
| Annual Salary Increase: | 5% |
| Cost Inflation Factor: |
| Cost Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total All Years | ||||
| LABOR | Hours per year | Hourly Rate | Annual Rate | |||||||
| PERSONNEL | ||||||||||
| Monthly Fixed Price | Project/ technical manager | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| NOB Crew Supervisor | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Maintenance Crew Supervisor | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Accountant/ payroll | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Utilities clerk | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Janitors’ supervisor | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Gardening supervisor (Part Time) | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Gardeners (3) | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Car washer | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Technicians (3) | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| NOB technicians (7) | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Customer coordinator | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Janitors (13) | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Supply clerk | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Receiving agent | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Business center porter | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Photocopying agent | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Purchase agent | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | |||
| Driver | 2080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| Transition Period | one month | 7040 | 0 | 0 | ||||||
| Total Personnel | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| FRINGE BENEFITS | ||||||||||
| Benefits for local staff | 40% of total direct labor and fringe | 0 | 0 | 0 | 0 | 0 | 0 | |||
| FRINGE TOTAL | 0 | 0 | 0 | 0 | 0 | 0 |
| OTHER DIRECT COSTS | ||||||
| Supplies | 820,000 | 820,000 | 820,000 | 820,000 | 820,000 | 4,100,000 |
| Vehicles | 300,000 | 300,000 | ||||
| Special Jobs Labor | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 1,500,000 | 7,500,000 |
| OTHER DIRECT COSTS TOTAL | 2,620,000 | 2,320,000 | 2,320,000 | 2,320,000 | 2,320,000 | 11,900,000 |
| TOTAL DIRECT COSTS | 2,620,000 | 2,320,000 | 2,320,000 | 2,320,000 | 2,320,000 | 11,900,000 | |
| INDIRECT COSTS | |||||||
| Overhead | 40% ot total cost | 1,048,000 | 928,000 | 928,000 | 928,000 | 928,000 | 4,760,000 |
| INDIRECT COSTS TOTAL | 1,048,000 | 928,000 | 928,000 | 928,000 | 928,000 | 4,760,000 |
| TOTAL COSTS | 3,668,000 | 3,248,000 | 3,248,000 | 3,248,000 | 3,248,000 | 16,660,000 | |
| Award Fee | 4% | 146720 | 129920 | 129920 | 129920 | 129920 | 666400 |
| FEE/PROFIT | 146720 | 129920 | 129920 | 129920 | 129920 | 666400 |
GRAND TOTAL 3,814,720 3,377,920 3,377,920 3,377,920 3,377,920 17,326,400
SPECIAL PROJECTS DETAIL
| ITEM 4 - SPECIAL PROJECTS LABOR DETAIL | |||||||
| Load Factors | Annual Escalation Rate | ||||||
| Note: These load and escalation factors are illustrative. This tab should be customized based on the offeror's NICRA (if applicable), price quote, and reflect information provided in the price narrative. | |||||||
| Overhead: | Inflation: | ||||||
| G&A: | Performance: | ||||||
| Profit: | |||||||
| Fringe: | |||||||
| Labor Category | Base Year Daily Salary Rate | Base Year 1 Fully Loaded Rate | Base Year 2 Fully Loaded Rate | Option Year 1 Fully Loaded Rate | Option Year 2 Fully Loaded Rate | Option Year 3 Fully Loaded Rate | |
| Project Manager |
Engineer Level I
Engineer Level II
Painter
Electrician
Plumber
Carpenter
Laborer Level I
Laborer Level II
Other SME as Required
Program Assistant
AWARD FEE DETAIL
| ITEM 5 - AWARD FEE CEILING DETAIL | ||||
| POOL | UNIT | # of UNITS | RATING | AVAILABLE FEE |
| Excellent | 91%-100% | |||
| Very Good | 76%-90% | |||
| Good | 51%-75% | |||
| Satisfactory | No Greater Than 50% | |||
| Unsatisfactory | 0% |
| Pool = Total Possible Award Fee per Performance Period |
| Unit = Length of Performance Period (monthly, quarterly, etc.) |
| # of Units = Performance Periods per Year |
| Rating = Award-Fee Adjectival Rating |
| Available Fee = Percentage of Award Fee Contractor will Receive Based on Rating |
| NOTE: THIS TABLE CAN BE REPLACED OR CUSTOMIZED IN ACCORDANCE WITH OFFEROR's PROPOSAL |
File details come from the government source that posted it. Updated .