Attachment 5 _ CLIN Spreadsheet.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- USAID/Southern Africa Organizational Development
- Solicitation number
- 72067423Q00002
About this file
This document contains a cost proposal template for the solicitation number 72067423Q00002 from the US Agency for International Development South Africa seeking organizational development services. The template includes five cost reimbursable contract line item numbers (CLINs) covering a five-year period of performance. CLIN 0001 is a firm-fixed price CLIN for year one deliverables including various planning documents, reports, and evaluations. CLINs 0002 through 0005 are time-and-materials CLINs for years two through five, with escalation rates to be applied to ceiling hourly labor rates. Offerors are required to complete the template by providing proposed ceiling hourly rates by labor category and total estimated costs for each CLIN.
View the file
Other files
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
Cover Tab RFP # 72061519R00007 - USAID/Southern Africa Organizational Development
CLIN Spreadsheet
To be completed by Offerors and submitted as part of cost proposals
| Tab 1 | Summary CLINS |
| Tab 2 | CLIN 0001 - Firm fixed price CLIN |
| Tab 3 | CLIN 0002 - CLIN 0005 |
Tab 1 - Summary CLINs Summary of CLINs
| CLIN # | Contract Line Item | Price |
| CLIN 0001 | Firm-Fixed-Price | $ - 0 |
| CLIN 0002 | T&M Year 2 | $ 15,750.00 |
| CLIN 0003 | T&M Year 3 | $ 16,550.00 |
| CLIN 0004 | T&M Year 4 | $ 17,350.00 |
| CLIN 0005 | T&M Year 5 | $ 18,320.00 |
| TOTAL | $ 67,970.00 | |
| *Amounts in this tab will auto populate based on amounts in other tabs |
Tab 2 - CLIN #0001 FIXED PRICE Labor CLIN #1 – Fixed Price CLIN
| Contract Line Item | Year 1 | ||||
| Firm-Fixed-Price - TOTAL | $ - 0 | ||||
| YEAR ONE DELIVERABLES | |||||
| # | Title & Description | Due Date | Deliverable Amount | VAT AMOUNT | Total of Deliverable + VAT |
| 1 | Pre Retreat Diagnostics Plan: Plan identifying how and when data will be collected, and by whom. The plan must also describe how the data will be analyzed. It should include a timeframe for completion of major milestones in the diagnostic process. | [MM/DD/ YY] | $TBD | ||
| 2 | Retreat Agenda: (1) abbreviated version for handout/distribution to all staff and (2) detailed retreat plan including facilitator name, description of participants (e.g. who / what offices participate in each session), description of session objectives and activities, and allocated time factoring in a morning and afternoon break and lunch. | [MM/DD/ YY] | $TBD | ||
| 3 | Retreat Report for Mission Leadership: Report providing a full description record of retreat proceedings, evaluation results and clear and specific recommended action items for Mission leadership, teams and staff resulting from retreat sessions. This should include an Annex with a Summary Retreat Report for distribution to all staff. | [MM/DD/ YY] | $TBD | ||
| 4 | Retreat Evaluation Tool: Description of what information will be collected, how it will be collected, and how it will be analyzed post retreat. | [MM/DD/ YY] | $TBD | ||
| 5 | Retreat Evaluation Report: Report describing feedback received from the Evaluation Tool. It should include the number and type of respondents (disaggregated by employment type, gender and any other factors agreed upon with the COR). The report should include recommendations on how to address issues raised during the retreat. | [MM/DD/ YY] | $TBD | ||
| 6 | Mid-year Office-specific Check-in Facilitation Plan and Report: This includes a brief plan of engagement with various offices. Following completion, the report will include a read out of what information was collected and how, during the check in process. The report should analyze information collected and consider how it should best be addressed. | [MM/DD/ YY] | $TBD | ||
| Ad Hoc Reports | |||||
| 1 | Organizational Development Support Reports - The contractor must provide a concise monthly report on ongoing and recently completed ad- hoc services. The report should include the amount of LOE spent on each ad-hoc request and the amount of LOE remaining overall. If there are no ongoing or completed ad-hoc requests within the past month no report is required. | [MM/DD/ YY] | $TBD |
Tab 3 - T&M
CLIN #0002 - 0005 INSTRUCTIONS
Insert Burdened Rates
| Year 2 | ||||||
| Contract Labor Category | Senior Level Ceiling Hourly Rate 1 | Mid Level Ceiling Hourly Rate 2 | Junior Level Ceiling Hourly Rate 3 | Maximum Hours | Total | |
| Organizational Development Specialist | 133 | $ - 0 | Complete only the yellow highlighted cells. Replace the text in Column A as applicable. The totals will auto populate based on the senior level rates and the maximum number of hours inserted in Column E. | |||
| Data Entry Specialist | 9 | $ - 0 | ||||
| General Adminstrative Support Specialist | 9 | $ - 0 | ||||
| Local and International Travel | $ 15,000.00 | |||||
| Misc Expenses | $ 750.00 | |||||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | |||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | |||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL YEAR 2 | $ 15,750.00 | Total will auto populate |
| Insert escalation rate for Year 3 | Insert percentage only. |
| Insert escalation rate for Year 4 | |
| Insert escalation rate for Year 5 |
| Year 3 | ||||||
| Contract Labor Category | Senior Level Ceiling Rate7 | Mid Level Ceiling Rate7 | Junior Level Ceiling Rate7 | Maximum Hours | Total | |
| Organizational Development Specialist | $ - 0 | $ - 0 | $ - 0 | 133 | $ - 0 | Complete only the yellow highlighted cells. Replace the text in Column A as applicable. The totals will auto populate based on the senior level rates and the maximum number of hours inserted in Column E. |
| Data Entry Specialist | $ - 0 | $ - 0 | $ - 0 | 9 | $ - 0 | |
| General Adminstrative Support Specialist | $ - 0 | $ - 0 | $ - 0 | 9 | $ - 0 | |
| Local and International Travel | $ 15,750.00 | |||||
| Misc Expenses | $ 800.00 | |||||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL YEAR 3 | $ 16,550.00 | Total will auto populate |
| Year 4 | ||||||
| Contract Labor Category | Senior Level Ceiling Rate9 | Mid Level Ceiling Rate9 | Junior Level Ceiling Rate9 | Maximum Hours | Total | |
| Organizational Development Specialist | $ - 0 | $ - 0 | $ - 0 | 133 | $ - 0 | Complete only the yellow highlighted cells. Replace the text in Column A as applicable. The totals will auto populate based on the senior level rates and the maximum number of hours inserted in Column E. |
| Data Entry Specialist | $ - 0 | $ - 0 | $ - 0 | 9 | $ - 0 | |
| General Adminstrative Support Specialist | $ - 0 | $ - 0 | $ - 0 | 9 | $ - 0 | |
| Local and International Travel | $ 16,500.00 | |||||
| Misc Expenses | $ 850.00 | |||||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL YEAR 4 | $ 17,350.00 | Total will auto populate |
| Year 5 | ||||||
| Contract Labor Category | Senior Level Ceiling Rate9 | Mid Level Ceiling Rate9 | Junior Level Ceiling Rate9 | Maximum Hours | Total | |
| Organizational Development Specialist | $ - 0 | $ - 0 | $ - 0 | 133 | $ - 0 | Complete only the yellow highlighted cells. Replace the text in Column A as applicable. The totals will auto populate based on the senior level rates and the maximum number of hours inserted in Column E. |
| Data Entry Specialist | $ - 0 | $ - 0 | $ - 0 | 9 | $ - 0 | |
| General Adminstrative Support Specialist | $ - 0 | $ - 0 | $ - 0 | 9 | $ - 0 | |
| Local and International Travel | $ 17,400.00 | |||||
| Misc Expenses | $ 920.00 | |||||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| [Offeror may Propose Additional Position] | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL YEAR 5 | $ 18,320.00 | Total will auto populate |
NOTES
| 1Offeror to provide rate for corresponding senior level positions. Must be supported in the budget narrative. |
| 2Offeror to provide rate for corresponding mid level positions. Must be supported in the budget narrative. |
| 3Offeror to provide rate for corresponding junior level positions. Must be supported in the budget narrative. |
| 4. Offerors may propose additional positions as necessary. |
| 5 & 6 Offerors must insert escalation rate, which will be used to automatically calculate hourly rates for Year 2 and Year 3 for corresponding Year 1 positions. |
File details come from the government source that posted it. Updated .