ATTACHMENT 4 - SUMMARY COST WORKSHEETS.xls
XLS spreadsheet 81 KB Posted
- Solicitation number
- SOL-514-10-000001
About this file
ATTACHMENT 4 - SUMMARY COST WORKSHEETS.xls
View the file
Other files
Show all 16
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
Prime Costs (US$)
| BUDGET SUMMARY SPREADSHEET: PRIME COSTS (US$) | ||||||
| ITEMS | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL |
| A. DIRECT LABOR | ||||||
| Long-Term Expatriates | ||||||
| Long-Term Cooperating Country Nationals (CCNs) | ||||||
| Short-Term Expatriates | ||||||
| Short-Term Cooperating Country Nationals (CCNs) | ||||||
| Home Office Support Staff | ||||||
| Total Direct Labor | ||||||
| B. FRINGE BENEFITS | ||||||
| Total Fringe Benefits | ||||||
| C. TRAVEL, TRANSPORTATION, AND PER DIEM | ||||||
| Assignment to Post/Repatriation Travel | ||||||
| R&R Travel | ||||||
| Home Leave Travel | ||||||
| In-Country Travel | ||||||
| In-Country Per Diem | ||||||
| U.S. and Third Country Travel | ||||||
| U.S. and Third Country Per Diem | ||||||
| Shipment of Household Effects (HHE) (Ocean Shipment) | ||||||
| Shipment of Unaccompanied Baggage (UAB) (Air Freight) | ||||||
| Shipment of Privately-Owned Vehicle (POV) (Ocean Shipment) | ||||||
| Storage of HHE | ||||||
| Consumables Shipment | ||||||
| Total Travel, Transportation & Per Diem | ||||||
| D. ALLOWANCES | ||||||
| Post Differential | ||||||
| Temporary Quarters Subsistence Allowance (TQSA) | ||||||
| Living Quarters Allowance (LQA) | ||||||
| Housing Make-Ready (e.g., security upgrades, electrical work, generators, heating/air conditioning, water cooler, appliances, etc.) | ||||||
| Post (Cost of Living) Allowance | ||||||
| Educational Allowance | ||||||
| Educational Travel | ||||||
| Separate Maintenance Allowance (SMA) | ||||||
| Danger Pay | ||||||
| Total Allowances | ||||||
| E. TRAINING | ||||||
| In-Country Training | ||||||
| U.S. and Third Country Training | ||||||
| Total Training | ||||||
| F. EQUIPMENT | ||||||
| Vehicle(s) | ||||||
| Office Set-Ups (e.g., desks, chairs, tables, filing cabinets, etc.) | ||||||
| Office Computer Set-ups (CPU, monitor, printer, peripherals, UPS, etc.) | ||||||
| Telephone Sets and Cellular Phones | ||||||
| Fax machine(s) | ||||||
| Photocopier(s) | ||||||
| Household Furniture, Furnishings, and Appliances | ||||||
| Total Equipment and Supplies | ||||||
| G. SUBCONTRACTS | ||||||
| Local subcontracts | ||||||
| International subcontracts | ||||||
| Total Salary and Wages | ||||||
| H. GRANTS | ||||||
| Local grants | ||||||
| International grants | ||||||
| Grants Management Fee | ||||||
| Total Grants | $ 8,000,000.00 | $ 18,000,000.00 | $ 20,000,000.00 | $ 18,000,000.00 | $ 10,000,000.00 | $ 74,000,000.00 |
| I. SECURITY | ||||||
| Armored Vehicles | ||||||
| Labor for Guard Forces | ||||||
| Security Equipment | ||||||
| Other Miscellaneous Costs | ||||||
| Total Security | ||||||
| J. OTHER DIRECT COSTS | ||||||
| Passports/Visas | ||||||
| Medical Exams/Inoculations | ||||||
| DBA Insurance or Equivalent | ||||||
| Medevac Coverage | ||||||
| Project Vehicle Insurance | ||||||
| Project Vehicle Operating and Maintenance Costs | ||||||
| Office Rent and Utilities (Electric, Heating, etc.) | ||||||
| Office Make-Ready | ||||||
| Office Equipment Service Contracts/Repairs | ||||||
| Office Supplies | ||||||
| Telephone/Fax Charges | ||||||
| Internet Access | ||||||
| Postage/Courier | ||||||
| Publications/Subscriptions | ||||||
| Report Preparation and Reproduction | ||||||
| Seminars, Workshops and Conferences | ||||||
| Environmental Compliance/Management | ||||||
| Total Other Direct Costs | ||||||
| K. INDIRECT COSTS (OVERHEAD) | ||||||
| Total Indirect Costs (Overhead) | ||||||
| TOTAL ESTIMATED COST | ||||||
| FIXED FEE/PROFIT | ||||||
| TOTAL ESTIMATED COST PLUS FIXED FEE | ||||||
| *Please provide the information requested for each year of the contract. All amounts in US $. |
&L&"Garamond,Bold"&11 SOL-514-09-000004 &C&"Garamond,Bold"&11&F
Subcontractor Costs (US$)
| BUDGET SUMMARY SPREADSHEET: SUBCONTRACTOR COSTS (US$) | ||||||
| ITEMS | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL |
| A. DIRECT LABOR | ||||||
| Long-Term Expatriates | ||||||
| Long-Term Cooperating Country Nationals (CCNs) | ||||||
| Short-Term Expatriates | ||||||
| Short-Term Cooperating Country Nationals (CCNs) | ||||||
| Home Office Support Staff | ||||||
| Total Direct Labor | ||||||
| B. FRINGE BENEFITS | ||||||
| Total Fringe Benefits | ||||||
| C. TRAVEL, TRANSPORTATION, AND PER DIEM | ||||||
| Assignment to Post/Repatriation Travel | ||||||
| R&R Travel | ||||||
| Home Leave Travel | ||||||
| In-Country Travel | ||||||
| In-Country Per Diem | ||||||
| U.S. and Third Country Travel | ||||||
| U.S. and Third Country Per Diem | ||||||
| Shipment of Household Effects (HHE) (Ocean Shipment) | ||||||
| Shipment of Unaccompanied Baggage (UAB) (Air Freight) | ||||||
| Shipment of Privately-Owned Vehicle (POV) (Ocean Shipment) | ||||||
| Storage of HHE | ||||||
| Consumables Shipment | ||||||
| Total Travel, Transportation & Per Diem | ||||||
| D. ALLOWANCES | ||||||
| Post Differential | ||||||
| Temporary Quarters Subsistence Allowance (TQSA) | ||||||
| Living Quarters Allowance (LQA) | ||||||
| Housing Make-Ready (e.g., security upgrades, electrical work, generators, heating/air conditioning, water cooler, appliances, etc.) | ||||||
| Post (Cost of Living) Allowance | ||||||
| Educational Allowance | ||||||
| Educational Travel | ||||||
| Separate Maintenance Allowance (SMA) | ||||||
| Danger Pay | ||||||
| Total Allowances | ||||||
| E. TRAINING | ||||||
| In-Country Training | ||||||
| U.S. and Third Country Training | ||||||
| Total Training | ||||||
| F. EQUIPMENT | ||||||
| Vehicle(s) | ||||||
| Office Set-Ups (e.g., desks, chairs, tables, filing cabinets, etc.) | ||||||
| Office Computer Set-ups (CPU, monitor, printer, peripherals, UPS, etc.) | ||||||
| Telephone Sets and Cellular Phones | ||||||
| Fax machine(s) | ||||||
| Photocopier(s) | ||||||
| Household Furniture, Furnishings, and Appliances | ||||||
| Total Equipment and Supplies | ||||||
| G. SUBCONTRACTS | ||||||
| Local subcontracts | ||||||
| International subcontracts | ||||||
| Total Salary and Wages | ||||||
| H. GRANTS | ||||||
| Local grants | ||||||
| International grants | ||||||
| Grants Management Fee | ||||||
| Total Grants | ||||||
| I. SECURITY | ||||||
| Armored Vehicles | ||||||
| Labor for Guard Forces | ||||||
| Security Equipment | ||||||
| Other Miscellaneous Costs | ||||||
| Total Security | ||||||
| J. OTHER DIRECT COSTS | ||||||
| Passports/Visas | ||||||
| Medical Exams/Inoculations | ||||||
| DBA Insurance or Equivalent | ||||||
| Medevac Coverage | ||||||
| Project Vehicle Insurance | ||||||
| Project Vehicle Operating and Maintenance Costs | ||||||
| Office Rent and Utilities (Electric, Heating, etc.) | ||||||
| Office Make-Ready | ||||||
| Office Equipment Service Contracts/Repairs | ||||||
| Office Supplies | ||||||
| Telephone/Fax Charges | ||||||
| Internet Access | ||||||
| Postage/Courier | ||||||
| Publications/Subscriptions | ||||||
| Report Preparation and Reproduction | ||||||
| Seminars, Workshops and Conferences | ||||||
| Environmental Compliance/Management | ||||||
| Total Other Direct Costs | ||||||
| K. INDIRECT COSTS (OVERHEAD) | ||||||
| Total Indirect Costs (Overhead) | ||||||
| TOTAL ESTIMATED COST | ||||||
| FIXED FEE/PROFIT | ||||||
| TOTAL ESTIMATED COST PLUS FIXED FEE | ||||||
| *Please provide the information requested for each year of the contract. All amounts in US $. |
&L&"Garamond,Bold"&11 SOL-514-09-000004 &C&"Garamond,Bold"&11&F
Componets Costs (US$)
| BUDGET SUMMARY SPREADSHEET: COMPONENTS COSTS (US$) | ||||||
| ITEMS | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL |
| A. PROGRAM MANAGEMENT | ||||||
| B. TECHNICAL SUPPORT | ||||||
| C. REGIONAL OFFICES | ||||||
| 1. La Macarena | ||||||
| 2. Sur de Tolima | ||||||
| 3. Buenaventura | ||||||
| 4. Southern Chocó | ||||||
| 5. Valle de Cauca | ||||||
| D. ACTIVITY FUND | $ 8,000,000.00 | $ 18,000,000.00 | $ 20,000,000.00 | $ 18,000,000.00 | $ 10,000,000.00 | $ 74,000,000.00 |
| TOTAL | ||||||
| *Please provide the information requested for each year of the contract. All amounts in US $. |
&L&"Garamond,Bold"&11 SOL-514-09-000004 &C&"Garamond,Bold"&11&F
USAID:
Includes overall program management, procurement, contracts, etc. (COP, DCOP, Ops Mgr, Finance Manager, Grants and Contracts Manager, Procurement Mgr, etc.)
USAID:
Includes technical specialists that will support activities across regions. Also includes program monitoring specialists.
USAID:
Each regional office inclues a regional manager, a grants and contracts specialist, local project coordinators for each municipality in the region, a bookkeeper, a procurment assistant, 2 admin assistants, and a driver.
USAID:
Activity fund will be utilized by the regional offices as required for the consolidation efforts in each region.
Level of Effort
| BUDGET SUMMARY SPREADSHEET: LEVEL OF EFFORT (#DAYS) | ||||||
| ITEMS | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL |
| Long-Term Expatriates | ||||||
| Long-Term Cooperating Country Nationals (CCNs) | ||||||
| Short-Term Expatriates | ||||||
| Short-Term Cooperating Country Nationals (CCNs) | ||||||
| Home Office Support Staff | ||||||
| TOTAL LEVEL OF EFFORT | ||||||
| Please provide the estimated Person Level of Effort in number of Days. |
&L&"Garamond,Bold"&11 SOL-514-09-000004 &C&"Garamond,Bold"&11&F
Personnel List
| BUDGET SUMMARY SPREADSHEET: PERSONNEL PROPOSED | ||||
| Person/Name | Position | Current Annual Salary | Proposed Annual Salary | Commentary |
| Please list the personnel proposed, their job title, current annual salary and proposed starting annual salary. |
&L&"Garamond,Bold"&11 SOL-514-09-000004 &C&"Garamond,Bold"&11&F
File details come from the government source that posted it. Updated .