Attachment_J._7_-_Cost_Matrix.xlsx
XLSX spreadsheet 140 KB Posted
- Attached to
- ACES Federal contract opportunity
- Solicitation number
- SOL-OAA-17-000103
About this file
This document contains a cost matrix template for a federal contract opportunity to provide accountability and governance support services. The template requires contractors to provide ceiling rates for international staffing categories including senior project managers, public administration specialists, democracy and governance specialists, social scientists, rule of law experts, and grants administrators. Ceiling rates are also required for consultants, subcontracts, subgrants, construction costs, and indirect cost rates. Contractors must commit to ceiling costs for personnel, fringe benefits, travel, equipment, supplies, and other direct costs for a five year period of performance. The resulting IDIQ contract will be awarded by USAID to provide accountability and governance programming through an approach focusing on both formal and informal accountability systems across development sectors.
Attachment J.7 in response to Amendment 5
View the file
Other files for this federal contract opportunity
Show all 24
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
Instructions Instructions:
While preparing this cost proposal, the contractor should be motivated by competition to reduce costs as much as possible, but also ensure to keep prices as realistic as possible. During performance your firm will be held to these ceilings, so ensure that they are realistic.
Plug figures are given, based on market research in an attempt to be able to effectively compare the cost proposals. They are not an indication that these numbers may be considered a "good" cost proposal for any specific task order in the future. These numbers do NOT correspond to the case study or any specific country.
| To complete the "Detail" worksheet, only the cells in yellow can/should be filled in as follows: |
| Personnel: |
| Rows 14 through 47, corresponding to international staff, meeting the qualifications in section B and C, should be filled in with unburdened ceiling daily rates for each position, for each year of performance. The contractor shall also complete the "Labor CDRs" worksheet with matching information. |
For the positions set forth below the price for these positions will be determined by using the CDR and the prime Offeror’s methodology for recovery of paid absences (leave and holidays). The Offeror must enter the appropriate labor cost and paid absences in the Sample Budget below. The budget narrative must clearly and accurately demonstrate the price and method of recovery for workdays and paid absences for all labor categories where applicable.
| Local staff is given as a plug figure for the purposes of this proposal. |
| Fringe: |
| In accordance with your firm's NICRA or other indirect cost agreement with the US government, the contractor shall fill in the cells in row 75, corresponding to Fringe for expatriates and HQ staff. |
| Consultants: |
| Rows 111 through 115 shall be filled in by the contractor as unburdened ceiling daily rates for subcontract consultants. |
| Indirect Costs: |
| Contractors are asked to submit and commit ceiling indirect cost rates for the period of this contract. Those rates shall be entered into rows 160 through 163, as needed. Furthermore, please fill out the "Indirect Ceilings" worksheet to match. |
| Fee: |
| The contractor shall commit to a ceiling on fee for the performance under this IDIQ. The fee ceiling for GUCs shall be calculated separately than the ceiling for all other costs. Offerors must use the proposed fixed fee percentage for grants under contract if NOT issued a letter of credit (per Section B.5.d). |
Detail Offeror: INSERT ORGANIZATION NAME
Offerors are to fill cells highlighted in yellow.
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||||||||||||||||||||||
| Running Total | 8,890,566 | 2017-2018 | 2018-2019 | 2019-2020 | 2020-2021 | 2021-2022 | Total Estimate (Columns I + P + W + AD + AK) | ||||||||||||||||||||||||||||||
| Description | Unit | No. of Units (based on 260 person-days, less paid absence days) | Unit Cost (USD) | Sub-Total (Column D * Column E) | Total Days of Paid Absence | Paid Absence not in Fringe Benefits ($ amount) | Year 1 Estimate (Column F + Column H) | Unit | No. of Units (based on 260 person-days, less paid absence days) | Unit Cost (USD) | Sub-Total (Column K * Column L) | Total Days of Paid Absence | Paid Absence not in Fringe Benefits ($ amount) | Year 2 Estimate (Column M + Column O) | Unit | No. of Units (based on 260 person-days, less paid absence days) | Unit Cost (USD) | Sub-Total Column R * Column S) | Total Days of Paid Absence | Paid Absence not in Fringe Benefits ($ amount) | Year 3 Estimate (Column T + Column V) | Unit | No. of Units (based on 260 person-days, less paid absence days) | Unit Cost (USD) | Sub-Total (Column Y * Column Z) | Total Days of Paid Absence | Paid Absence not in Fringe Benefits ($ amount) | Year 4 Estimate (Column AA + Column AC) | Unit | No. of Units (based on 260 person-days, less paid absence days) | Unit Cost (USD) | Sub-Total (Column AF * Column AG) | Total Days of Paid Absence | Paid Absence not in Fringe Benefits ($ amount) | Year 5 Estimate (Column AH + Column AJ) |
PERSONNEL
INTERNATIONAL STAFF
| Long Term Expatriate Staff | ||||||
| Senior Project Manager (Senior) | Day | Day | Day | Day | Day | |
| Public Administration/Public Finance Specialist | ||||||
| Public Administration/Public Finance Specialist (Senior) | Day | Day | Day | Day | Day | |
| Public Administration/Public Finance Specialist (Mid-Level ) | Day | Day | Day | Day | Day | |
| Democracy, Rights and Governance Specialist | ||||||
| Democracy, Rights and Governance Specialist (Senior) | Day | Day | Day | Day | Day | |
| Democracy, Rights and Governance Specialist (Mid-Level) | Day | Day | Day | Day | Day | |
| Social Scientist/Cultural Anthropologist | ||||||
| Social Scientist/Cultural Anthropologist (Senior) | Day | Day | Day | Day | Day | |
| Social Scientist/Cultural Anthropologist (Mid-Level) | Day | Day | Day | Day | Day | |
| Rule of Law and Human Rights Specialist | ||||||
| Rule of Law and Human Rights Specialist (Senior) | Day | Day | Day | Day | Day | |
| Rule of Law and Human Rights Specialist (Mid-Level) | Day | Day | Day | Day | Day | |
| Legislative/Parliamentary Development Specialist | ||||||
| Legislative/Parliamentary Development Specialist (Senior) | Day | Day | Day | Day | Day | |
| Legislative/Parliamentary Development Specialist (Mid-Level) | Day | Day | Day | Day | Day | |
| Grants Administrator | ||||||
| Grants Administrator (Senior) | Day | Day | Day | Day | Day | |
| Grants Administrator (Mid-Level) | Day | Day | Day | Day | Day | |
| Training Specialist | ||||||
| Training Specialist (Senior) | Day | Day | Day | Day | Day | |
| Training Specialist (Mid-Level) | Day | Day | Day | Day | Day | |
| Monitoring and Evaluation Specialist | ||||||
| Monitoring and Evaluation Specialist (Senior) | Day | Day | Day | Day | Day | |
| Monitoring and Evaluation Specialist (Mid-Level) | Day | Day | Day | Day | Day | |
| Gender Specialist | ||||||
| Gender Specialist (Senior) | Day | Day | Day | Day | Day | |
| Gender Specialist (Mid-Level) | Day | Day | Day | Day | Day | |
| Information Technology Specialist | ||||||
| Information Technology Specialist (Senior) | Day | Day | Day | Day | Day | |
| Information Technology Specialist (Mid-Level) | Day | Day | Day | Day | Day | |
| Project/Administrative Support Specialist | ||||||
| Project/Administrative Support Specialist (Senior) | Day | Day | Day | Day | Day | |
| Project/Administrative Support Specialist (Mid-Level) | Day | Day | Day | Day | Day |
| HQ Technical Staff | ||||||
| HQ IDIQ Manager | Day | Day | Day | Day | Day | |
| HQ TO Project Manager | Day | Day | Day | Day | Day |
SUBTOTAL INTERNATIONAL STAFF - - - - - -
LOCAL IN-COUNTRY STAFF
| <Head Office> |
| Program Staff |
Operational Staff
| <Field Office> |
| Program Staff |
| Operational Staff | |
| - |
SUBTOTAL NATIONAL STAFF 333,200 382,720 404,560 426,400 448,240 1,995,120
TOTAL PERSONNEL 333,200 382,720 404,560 426,400 448,240 1,995,120
| FRINGE BENEFITS | |||||||||||||||||
| Corporate Fringe Benefits - Expatriates & HQ Staff only | Percent | - | - | Percent | - | - | Percent | - | - | Percent | - | - | Percent | - | - | - | |
| All other Fringe Costs | 155,206 | 149,236 | 155,424 | 161,612 | 187,800 | 809,278 | |||||||||||
| TOTAL FRINGE BENEFITS | 155,206 | 149,236 | 155,424 | 161,612 | 187,800 | 809,278 |
TRAVEL
| International Travel |
| Local & Domestic Travel |
TOTAL TRAVEL 60,258 39,261 39,261 39,261 64,261 242,302
EQUIPMENT
| Vehicles (Restricted Item-Waivor Required) | |
| 4 v 4 vehicle | |
| Sedan vehicle | |
| Capital Equipment |
IT Equipment over $5000 (servers etc)
TOTAL EQUIPMENT 63,000 - 5,686 - - 68,686
SUPPLIES
| Laptops |
| Cell phones |
| Landlines |
TOTAL SUPPLIES 28,500 - - 16,980 - 45,480
CONTRACTUAL
| CONSULTANTS | ||||||||||||||||||||||
| Local | Day | 43 | 200 | 8,668 | Each | 43 | 200 | 8,668 | Each | 43 | 200 | 8,668 | Each | 43 | 200 | 8,668 | Each | 43 | 200 | 8,668 | 43,340 | |
| Expatriate | ||||||||||||||||||||||
| Public Administration/Public Finance Specialist (Senior) | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | - | ||||||
| Democracy, Rights and Governance Specialist (Senior) | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | - | ||||||
| Social Scientist/Cultural Anthropologist (Senior) | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | - | ||||||
| Rule of Law and Human Rights Specialist (Senior) | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | - | ||||||
| Legislative/Parliamentary Development Specialist (Senior) | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | Day | 5 | - | - |
SUBTOTAL CONSULTANTS 8,668 8,668 8,668 8,668 8,668 43,340
SUBCONTRACTS
| US Organizations | |
| General | |
| Local Organizations | |
| General |
SUBTOTAL SUBCONTRACTS 562,500 562,500 562,500 562,500 562,500 2,812,500
| SUBGRANTS | ||||||||||||||||||||||
| General | Each | 1 | 400,000 | 400,000 | Each | 1 | 400,000 | 400,000 | Each | 1 | 400,000 | 400,000 | Each | 1 | 400,000 | 400,000 | Each | 1 | 400,000 | 400,000 | 2,000,000 | |
| Local Organizations | ||||||||||||||||||||||
| SUBTOTAL SUBGRANTS | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 2,000,000 |
TOTAL CONTRACTUAL 971,168 971,168 971,168 971,168 971,168 4,855,840
CONSTRUCTION
| Construction - Program | ||||||||||||||||||||||
| Small Scale Construction (town hall, etc) | Each | 1 | 10,000 | 10,000 | Each | 1 | 10,000 | 10,000 | Each | 1 | 10,000 | 10,000 | Each | 1 | 10,000 | 10,000 | Each | 1 | 10,000 | 10,000 | 50,000 |
TOTAL CONSTRUCTION 10,000 10,000 10,000 10,000 10,000 50,000
OTHER DIRECT COSTS
<Head Office>
<Regional Office>
<Cross-Cutting ODCs>
TOTAL OTHER COSTS 134,437 156,265 166,516 177,523 189,119 823,860
DIRECT COSTS 1,755,769 1,708,650 1,752,615 1,802,944 1,870,588 8,890,566
| INDIRECT COSTS | ||||||||||||||||||||||
| Rate | Base | Rate | Base | Rate | Base | Rate | Base | Rate | Base | |||||||||||||
| Overhead | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - | |||||||||||
| G&A | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - | |||||||||||
| Other Rates1 | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - | |||||||||||
| Other Rates2 | Indirect | - | Indirect | - | Indirect | - | Indirect | - | Indirect | - | - |
TOTAL INDIRECT COSTS - - - - - -
| FEE-PROFIT | |||||||
| Fee on Grants Under Contract | - 0 | - 0 | - 0 | - 0 | - 0 | - | |
| Fee on Program and Operations Costs (non-GUC) | - 0 | - 0 | - 0 | - 0 | - 0 | - | |
| TOTAL FEE-PROFIT | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
TOTAL COSTS 1,755,769 1,708,650 1,752,615 1,802,944 1,870,588 8,890,566
Labor CDRs
| Ceiling Daily Rates | ||||||||
| Labor Category Groupings | Level | Years: 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Project Manager | Sr. | |||||||
| Public Administration/Public Finance Specialist | Sr. | |||||||
| Public Administration/Public Finance Specialist | Mid | |||||||
| Democracy, Rights and Governance Specialist | Sr. | |||||||
| Democracy, Rights and Governance Specialist | Mid | |||||||
| Social Scientist/Cultural Anthropologist | Sr. | |||||||
| Social Scientist/Cultural Anthropologist | Mid | |||||||
| Rule of Law and Human Rights Specialist | Sr. | |||||||
| Rule of Law and Human Rights Specialist | Mid | |||||||
| Legislative/Parliamentary Development Specialist | Sr. | |||||||
| Legislative/Parliamentary Development Specialist | Mid | |||||||
| Grants Administrator | Sr. | |||||||
| Grants Administrator | Mid | |||||||
| IDIQ Manager | Sr. | |||||||
| Training Specialist | Sr. | |||||||
| Training Specialist | Mid | |||||||
| Monitoring and Evaluation Specialist | Sr. | |||||||
| Monitoring and Evaluation Specialist | Mid | |||||||
| Gender Specialist | Sr. | |||||||
| Gender Specialist | Mid | |||||||
| Information Technology Specialist | Sr. | |||||||
| Information Technology Specialist | Mid | |||||||
| Project/Administrative Support Specialist | Sr. | |||||||
| Project/Administrative Support Specialist | Mid |
Indirect Ceilings
| Offeror | Fringe Rate% | Overhead Rate % | Overhead Ceiling Rate % | G&A Rate % | G&A Ceiling Rate % |
| PRIME (Insert Name) | |||||
| Base of Application | |||||
| Source: (insert) | |||||
| Period: (insert) |
File details come from the government source that posted it. Updated .