Attachment 2 - Pricing Worksheet.xlsx
XLSX spreadsheet 25 KB Posted
- Solicitation number
- 70Z02324Q93270001
About this file
This document is an Attachment 2 - Pricing Worksheet related to a federal contract opportunity for gym memberships for the U.S. Coast Guard's Waterways Commerce Cutter Project Resident Office.
The pricing worksheet provides instructions for completing a cost summary and pricing spreadsheet, including separate tabs for the contractor site and government site depending on the task order type (firm-fixed-price or time-and-materials). The worksheet requires the contractor to provide labor hours, travel, and other direct costs to perform the specified task order. The total costs will be calculated and carried forward to the ECS Submission tab. The federal contract opportunity has a performance period from May 20, 2024 to May 19, 2029, with one-year option periods. The solicitation number is 70Z02324Q93270001, the NAICS code is 713940 for Fitness and Recreational Sports Centers, and the contractor must be located within 10 miles of the design work sites and 20 miles of the production site. Offers are due on April 29, 2024 at 12:00PM Eastern time.
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
INSTRUCTIONS
| Estimated Cost Summary and Pricing Spreadsheet |
| The following spreadsheet has been developed to help manage the process of completing each spreadsheet. |
| TABLE OF CONTENTS | |
| 1. | TAB DEFINITIONS |
| 2. | INSTRUCTIONS |
| TAB DEFINITIONS | ||
| Worksheet | Purpose | |
| ECS Submission | SET-UP DATA ENTRY REQUIRED - Summarizes the input from the individual Worksheet - Cont'r Site and Worksheet - Gov't Site tabs for Submission to the Government. Allows for the entry of the Delivery Order Name, Task Order Number, and Type of Task. | |
| Worksheet - Cont'r Site | DATA ENTRY REQUIRED IF FFP TASK - Allows for the entry of hours, travel and other direct costs required to perform the specific task order. | |
| Worksheet - Gov't Site | DATA ENTRY REQUIRED IF T&M TASK - Allows for the entry of hours, travel and other direct costs required to perform the specific task order. | |
| INSTRUCTIONS | ||
| Step | Description | |
| 1 | (a) | Save the template as a new file. Use the following naming convention: DO XX-XXXX ECS and Pricing Sheet.xls. Where XX is the Fiscal Year and XXXX is the task number for the Delivery Order. |
| 2 | (a) | On the ECS Submission Tab, Complete the cells highlighted in yellow only - remaining cells are password protected. Enter the Delivery Order Name, Task Order Number and Type of Task in the corresponding cells. |
| 3 | (a) | If the Type of Task is FFP - Complete the cells highlighted in yellow on the Worksheet - Cont'r Site tab only. |
| (b) | If the Type of Task is T&M - Complete the cells highlighted in yellow on the Worksheet - Gov't Site tab only. | |
| (c) | If Type of Task is a mix of both FFP & T&M - both worksheets must be completed as instructed in step 4 below. | |
| 4 | (a) | Enter the number of hours required to perform the associated task per position. All costs will calculate automatically and carry forward to the ECS Submission tab. |
| (b) | Enter the travel data in the corresponding cells for each destination/location. Note, the Subcontractor will have to manually calculate the total travel per line as there are too many variables for it to calculate automatically. The G&A will calculate automatically. All costs will carry forward to the ECS Submission tab. | |
| (c) | Enter the ODC data in the corresponding cells for each item description - be as specific as possible. The total will calculate automatically and add the G&A. All costs will carry forward to the ECS Submission tab. | |
| 5 | (a) | Print file and sign each completed sheet. |
| (b) | Upload the Excel and signed .pdf file to SharePoint in the corresponding Delivery Order folder. |
1 plus 2 options
| Pricing Sheet Attachment 2 | |||||
| Base Period: May 20, 2024 – May 19, 2025 | |||||
| Requirement | Quantity | Rate | Monthly Amount | Discount | Base Total |
| Gym Meberships | 21 | $ - 0 | 0% | $ - 0 | |
| One time Sign Up Fee | 21 | $ - 0 | 0% | $ - 0 | |
| Sub-Total | 21 | $ - 0 | 0% | $ - 0 |
| Option Period 1: May 20, 2025 – May 19, 2026 | |||||
| Requirement | Quantity | Rate | Monthly Amount | Discount | Base Total |
| Gym Meberships | 21 | $ - 0 | 0% | $ - 0 | |
| Sub-Total | 21 | $ - 0 | 0% | $ - 0 |
| Option Period 2: May 20, 2026 – May 19, 2027 | |||||
| Requirement | Quantity | Rate | Monthly Amount | Discount | Base Total |
| Gym Meberships | 21 | $ - 0 | 0% | $ - 0 | |
| Sub-Total | 21 | $ - 0 | 0% | $ - 0 |
| Option Period 3: May 20, 2027 – May 19, 2028 | |||||
| Requirement | Quantity | Rate | Monthly Amount | Discount | Base Total |
| Gym Meberships | 21 | $ - 0 | 0% | $ - 0 | |
| Sub-Total | 21 | $ - 0 | 0% | $ - 0 |
| Option Period 4: May 20, 2028 – May 19, 2029 | |||||
| Requirement | Quantity | Rate | Monthly Amount | Discount | Base Total |
| Gym Meberships | 21 | $ - 0 | 0% | $ - 0 | |
| Sub-Total | 21 | $ - 0 | 0% | $ - 0 |
| Period of Perfromance | Total Dollar |
| Base Year Total: | $ - 0 |
| Option 1 Total: | $ - 0 |
| Option 2 Total: | $ - 0 |
| Option 3 Total: | $ - 0 |
| Option 4 Total: | $ - 0 |
| Total : | $ - 0 |
&P of &N Contractor Site Rates
File details come from the government source that posted it. Updated .