NEW Attachment 2 - Pricing Spreadsheet.xlsx
XLSX spreadsheet 27 KB Posted
- Solicitation number
- 70Z02325QMER30001
About this file
The file is a Pricing Spreadsheet for Request for Quote (RFQ) #70Z02325QMER30001 for U.S. Coast Guard Academy Internship Support Services. The document outlines a multi-year pricing structure covering a base period and four option periods from 5/12/2025 to 5/11/2030, each lasting approximately 12 months. The pricing template requires contractors to complete details for key positions including Lead Principal Investigator and Instructors, with line items for General & Administrative costs, indirect costs, materials, and equipment, and includes a 0.75% Contract Access Fee.
The solicitation seeks scientific and technical support for Coast Guard Academy cadet internships, specifically focused on research and professional development within the Great Lakes region. The internship program will occur within Michigan, with activities centered in Ann Arbor and Sault Ste. Marie. The government anticipates additional scientific support through potential call orders, which may include lab technician work, literature reviews, equipment and facilities access, and data analysis support. Cost is identified as a primary selection factor, and proposals must include lab use fees, faculty advisor expenses, and supply costs. The contract is issued by the Department of Homeland Security US Coast Guard and aims to advance research needs in the Great Lakes region.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Compiled - Questions or Clarifications 3-27-25.xlsx | XLSX spreadsheet | |
| Performance Work Statement_Cadet_Internship.pdf | ||
| Technical Proposal Cover Page.pdf | ||
| Solicitation 70Z02325QMER30001.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
RFQ Pricing Spreadsheet
| Company Name: [PLEASE INSERT] | ||||||||
| DUNS or UEI: [PLEASE INSERT] | ||||||||
| NOTE: Spreadsheet is authorized to be changed to reflect contractor information | ||||||||
| BPA No. or GSA Contract No.: [PLEASE INSERT] | ||||||||
| BASE PERIOD (Estimated 5/12/2025 to 5/11/2026) [Appx. 12 Months] | ||||||||
| CLIN | Government Anticipated Positions | Anticipated Contractor | Contractor Proposed Labor Category | Monthly Unit of Issue | Contractor Proposed FTE (monthly) | Contractor Proposed Task Order Labor Rate (including any applicable discounts) | Total Monthly Price | Total Annual Price |
| 0001 | Lead Principal Investigator (PI) (Key) | Senior | 12 | $0.00 | $0.00 | |||
| 0002 | Instructors (Key) | 12 | $0.00 | $0.00 | ||||
| 0003 | G&A | 12 | $0.00 | $0.00 | ||||
| 0004 | Indirect Cost/Other Direct Cost | 12 | $0.00 | $0.00 | ||||
| 0005 | Material and Equipment Cost | 12 | 0.00 | $0.00 | $0.00 | |||
| Base Period Firm Fixed-Price Contract Access Fee (CAF)0.75% CLIN 0002 TOTAL | $0.00 | $0.00 |
BASE PERIOD TOTAL: $0.00
FTE = Hours
| OPTION PERIOD (Estimated 5/12/2026 to 5/11/2027[12 Months] | ||||||||
| CLIN | Government Anticipated Positions | Anticipated Contractor | Contractor Proposed Labor Category | Monthly Unit of Issue | Contractor Proposed FTE (monthly) | Contractor Proposed Task Order Labor Rate (including any applicable discounts) | Total Monthly Price | Total Annual Price |
| 1001 | Lead Principal Investigator (PI) (Key) | Senior | 12 | $0.00 | $0.00 | |||
| 1002 | Instructors (Key) | 12 | $0.00 | $0.00 | ||||
| 1003 | G&A | 12 | $0.00 | $0.00 | ||||
| 1004 | Indirect Cost/Other Direct Cost | 12 | $0.00 | $0.00 | ||||
| 1005 | Material and Equipment Cost | 0.00 | $0.00 | $0.00 | ||||
| Base Period Firm Fixed-Price Contract Access Fee (CAF)0.75% CLIN 0002 TOTAL | $0.00 | $0.00 |
OPTION PERIOD TOTAL: $0.00
FTE = Hours
| OPTION PERIOD (Estimated 5/12/2027 to 5/11/2028) [12 Months] | ||||||||
| CLIN | Government Anticipated Positions | Anticipated Contractor | Contractor Proposed Labor Category | Monthly Unit of Issue | Contractor Proposed FTE (monthly) | Contractor Proposed Task Order Labor Rate (including any applicable discounts) | Total Monthly Price | Total Annual Price |
| 2001 | Lead Principal Investigator (PI) (Key) | Senior | 12 | $0.00 | $0.00 | |||
| 2002 | Instructors (Key) | 12 | $0.00 | $0.00 | ||||
| 2003 | G&A | 12 | $0.00 | $0.00 | ||||
| 2004 | Indirect Cost/Other Direct Cost | 12 | $0.00 | $0.00 | ||||
| 2005 | Material and Equipment Cost | 0.00 | $0.00 | $0.00 | ||||
| Base Period Firm Fixed-Price Contract Access Fee (CAF)0.75% CLIN 0002 TOTAL | $0.00 | $0.00 |
| OPTION PERIOD TOTAL: | $0.00 |
| FTE = Hours |
| OPTION PERIOD (Estimated 5/12/2028 to 5/11/2029) [12 Months] | ||||||||
| CLIN | Government Anticipated Positions | Anticipated Contractor | Contractor Proposed Labor Category | Monthly Unit of Issue | Contractor Proposed FTE (monthly) | Contractor Proposed Task Order Labor Rate (including any applicable discounts) | Total Monthly Price | Total Annual Price |
| 3001 | Lead Principal Investigator (PI) (Key) | Senior | 12 | $0.00 | $0.00 | |||
| 3002 | Instructors (Key) | 12 | $0.00 | $0.00 | ||||
| 3003 | G&A | 12 | $0.00 | $0.00 | ||||
| 3004 | Indirect Cost/Other Direct Cost | 12 | $0.00 | $0.00 | ||||
| 3005 | Material and Equipment Cost | 0.00 | $0.00 | $0.00 | ||||
| Base Period Firm Fixed-Price Contract Access Fee (CAF)0.75% CLIN 0002 TOTAL | $0.00 | $0.00 |
OPTION PERIOD TOTAL: $0.00
| FTE = Hours | ||||||||
| OPTION PERIOD (Estimated 5/12/2029 to 5/1/20/2030 [12 Months] | ||||||||
| CLIN | Government Anticipated Positions | Anticipated Contractor | Contractor Proposed Labor Category | Monthly Unit of Issue | Contractor Proposed FTE (monthly) | Contractor Proposed Task Order Labor Rate (including any applicable discounts) | Total Monthly Price | Total Annual Price |
| 4001 | Lead Principal Investigator (PI) (Key) | Senior | 12 | 0.00 | $0.00 | $0.00 | ||
| 4002 | Instructors (Key) | 12 | 0.00 | $0.00 | $0.00 | |||
| 4003 | G&A | 12 | 0.00 | $0.00 | $0.00 | |||
| 4004 | Indirect Cost/Other Direct Cost | 12 | 0.00 | $0.00 | $0.00 | |||
| 4005 | Material and Equipment Cost | 0.00 | $0.00 | $0.00 | ||||
| Base Period Firm Fixed-Price Contract Access Fee (CAF)0.75% CLIN 0002 TOTAL | $0.00 | $0.00 |
| OPTION PERIOD TOTAL: | $0.00 | |
| FTE = Hours | ||
| TASK ORDER TOTAL EVALUATED PRICE (TEP) | $0.00 |
ATTACHMENT 2 - PRICING SPREADSHEET
RFQ #: 70Z02325QMER30001
CG-MER-3 Contractor Internship Support Services
&P
Labor Category Descriptions
| Title | Position Description |
| Project Manager - Senior | Responsible for all aspects of the development and implementation of assigned projects and provides a single point of contact for those projects. Takes projects from original concept through final implementation. Interfaces with all areas affected by the project including end users, computer services, and client services. Defines project scope and objectives. Develops detailed work plans, schedules, project estimates, resource plans, and status reports. Conducts project meetings and is responsible for project tracking and analysis. Ensures adherence to quality standards and reviews project deliverables. Manages the integration of vendor tasks and tracks and reviews vendor deliverables. Provides technical and analytical guidance to project team. Recommends and takes action to direct the analysis and solutions of problems. |
| Documentation Specialist - Senior | Under general supervision, is responsible for preparing and/or maintaining systems, programming, and operations documentation, procedures, and methods including user manuals and reference manuals. Maintains a current internal documentation library. Provides or coordinates special documentation services as required. Competent to work at the highest level of all phases of documentation. May act as project leader for large positions. |
| Database Administator | Participates in the design, creation, and maintenance of computerized databases. Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data. Works with management to develop database strategies to support company needs. Consults with and advises users on access to various databases. Works directly with users to resolve data conflicts and inappropriate data usage. Directs the maintenance and use of the corporate data dictionary. Typically requires two to four years of experience. |
File details come from the government source that posted it. Updated .