Appendix A - Pricing Spreadsheet 19FS1A22R0002_FINAL.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- Administrative and Training Program Support Services, Amendment 012 Federal contract opportunity
- Solicitation number
- 19FS1A22R0002
- Issued by
- Department of State
About this file
This document contains a pricing spreadsheet and related solicitation for administrative and training program support services. The pricing spreadsheet details over 50 labor categories across instructional, management, and other support functions. It includes details on labor hours, rates, and estimated costs for a base period and four option years. The related solicitation is from the Department of State seeking these administrative and training services. The submission deadline is June 6, 2022, with an anticipated award period from October 31, 2022 to August 30, 2023. Services will be provided on both an hourly and firm-fixed price basis, and the document includes pricing templates for labor hours, firm-fixed price labor, and management categories to be completed by offerors.
View the file
Other files for this federal contract opportunity
Show all 31
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
Pricing Sheet
| Company Name: | Appendix A - FSI Training: Administrative and Professional Services |
| Pricing Spreadsheet | |
| Foreign Service Institute: Administrative Support Services | |
| Date: |
| Services (Labor Hour) | Labor Category Type | Approx hours Base Period Approx Award 10/31/2022-8/30/2023 | Avg Annual Hours - Option Years | Estimated No. Positions | Base Period - CLIN 0001A | |||||||||||||||||||||||||||||||
| Approx Award Date 10/31/2022-8/30/2023 | Option Year 1 - CLIN 1001A | Option Year 2 - CLIN 2001A | Option Year 3 - CLIN 3001A | Option Year 4 - CLIN 4001A | ||||||||||||||||||||||||||||||||
| Unloaded Rate | Loaded Rate | Evaluated Cost | OT Rate (if applicable) | Sunday Pay (if applicable) | Night Differential (if applicable) | Unloaded Rate | Loaded Rate | Evaluated Cost | OT Rate (if applicable) | Sunday Pay (if applicable) | Night Differential (if applicable) | Unloaded Rate | Loaded Rate | Evaluated Cost | OT Rate (if applicable) | Sunday Pay (if applicable) | Night Differential (if applicable) | Unloaded Rate | Loaded Rate | Evaluated Cost | OT Rate (if applicable) | Sunday Pay (if applicable) | Night Differential (if applicable) | Unloaded Rate | Loaded Rate | Evaluated Cost | OT Rate (if applicable) | Sunday Pay (if applicable) | Night Differential (if applicable) | |||||||
| Administrative Assistant | Administrative Support | 1752 | 1912 | 24 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Program Assistant I | Administrative Support | 1752 | 1912 | 24 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Program Assistant II | Administrative Support | 1752 | 1912 | 71 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Teaching Assistant | Instructional Support | 1752 | 1912 | 6 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Course Chair/Instructor | Instruction | 1752 | 1912 | 3 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Resilience Instructor (General) | Instruction | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Resilience Instructor (Mental Health Professional) | Instruction | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Curriculum Specialist/Instructional Designer I | Instructional Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Curriculum Specialist/Instructional Designer II | Instructional Support | 1752 | 1912 | 4 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Curriculum Specialist/Instructional Designer III | Instructional Support | 1752 | 1912 | 6 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Accounting Clerk | Management Support | 1752 | 1912 | 3 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Budget & Fiscal Operations Support Analyst | Management Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Businesss Operational Specialist I | Management Support | 1752 | 1912 | 5 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Businesss Operational Specialist II | Management Support | 1752 | 1912 | 5 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Graphic Artist | Management Support | 1752 | 1912 | 2 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Management Analyst I | Management Support | 1752 | 1912 | 3 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Management Analyst II | Management Support | 1752 | 1912 | 2 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Media Specialist | Management Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Support Service Specialist | Management Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Communications Advisor | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Communications Specialist | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Data Analyst I | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Data Analyst II | Other | 1752 | 1912 | 3 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Data Analyst III | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Educational Technology Advisor I | Instructional Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Educational Technology Advisor II | Instructional Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Educational Technology Specialist | Instructional Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Evaluation Specialist I | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Evaluation Specialist II | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Evaluation Specialist III | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Knowledge Management Specialist I | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Knowledge Management Specialist II | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Office of the Historian - Proofreader I | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Office of the Historian - Proofreader II | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Research Analyst | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Systems Analyst | Instructional Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Technical Writer and SharePoint Administrator | Instructional Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Technology Systems Specialist | Instructional Support | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| LE Staff Training Instructor | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Emergency Management Specialist | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| CMT-CLL Communications Specilaist | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| CMT-CLL Research Analyst | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| HR Instructor | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Communication Skills Training Expert | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Journey Maps and Learning path Instructor | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| TC - Training Instructor | Other | 1752 | 1912 | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||
| Total Annul Cost - Labor Hour Positions | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||
| Services (Firm-Fixed Price) | Labor Category Code | Avg Annual Hours (Base Period) | Avg Annual Hours | Estimated No. Positions | Base Period - CLIN 0001B | Option Year 1 - CLIN 1001B | Option Year 2 - CLIN 2001B | Option Year 3 - CLIN 3001B | Option Year 4 - CLIN 4001B | |||||||||||||||||||||||||||
| Annual Cost Per Position | Annual Total Cost | Annual Cost Per Position | Annual Total Cost | Annual Cost Per Position | Annual Total Cost | Annual Cost Per Position | Annual Total Cost | Annual Cost Per Position | Annual Total Cost | |||||||||||||||||||||||||||
| SLS Evaluation Specialist - Language Testing | Other | Annual | 1 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||
| SLS Evaluation Specialist - Education Program Evaluation | Other | Annual | 2 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||
| SLS Evaluation Specialist - Learning Analytics | Other | Annual | 2 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||
| Total Annul Cost - Labor Hour Positions | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||
| Management (Firm-Fixed Price) | Labor Category Code | Avg Annual Hours (Base Period) | Avg Annual Hours | Number of Positions | Base Period - CLIN 0001B | Option Year 1 - CLIN 1001B | Option Year 2 - CLIN 2001B | Option Year 3 - CLIN 3001B | Option Year 4 - CLIN 4001B | FAR clause 52.217-8 |
Six Month Extension
| Annual Cost Per Position | Annual Total Cost | Annual Cost Per Position | Annual Total Cost | Annual Cost Per Position | Annual Total Cost | Annual Cost Per Position | Annual Total Cost | Annual Cost Per Position | Annual Total Cost | M.4.3.1 - OY4 divided by 2 | |||||||||
| Program Manager | PM | Annual | 2 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||
| Total Evaluated Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Notes:
File details come from the government source that posted it. Updated .