Attachment 0001 Pricing Workbook.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Maintenance of Natural Gas Pipeline
- Solicitation number
- W912GY22R0002
View the file
Other files
Show all 17
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
| Solicitation: W912GY22R0002 | |
| Attachment 0001 - Pricing Workbook | |
| Instructions | |
| 1 | Cells that require inputs are highlighted in yellow |
| 2 | All cells highlighted in yellow must be completed. |
| 3 | Do not adjust formulas or otherwise manipulate any of the non-yellow highlighted cells |
| 4 | Do not alter or make changes to this attachment except for entering values in the cells highlighted in yellow. |
| 5 | For evaluation purposes, all dollar amounts proposed will be displaced as rounded to the nearest $0.01 |
| 6 | Preventative maintenance should be quoted to include all the labor, equipment and material costs associated with maintaining the natural gas pipeline in accordance with the details provided in the performance work statement; the repair tabs and additional work/installation tab should be limited to fully loaded labor rate. |
Preventative Maintenance
| PREVENTATIVE MAINTENANCE SERVICES (FFP) | |||
| Preventative Maintenance | Year | Annual PM | Monthly Rate |
| CLIN 1001 - Year One | 2022-2023 | $0.00 | $0.00 |
| CLIN 2001 - Year Two | 2023-2024 | $0.00 | $0.00 |
| CLIN 3001 - Year Three | 2024-2025 | $0.00 | $0.00 |
| Ordering Period One: (CLIN 1001) | |||
| Preventative Maintenance | Price per Year | ||
| 01 Mar 2022 - 28 Feb 2023 |
| Ordering Period Two: (CLIN 2001) | |
| Preventative Maintenance | Price per Year |
| 01 Mar 2023 - 29 Feb 2024 |
| Ordering Period Three: (CLIN 3001) | |
| Preventative Maintenance | Price per Year |
| 01 Mar 2024 - 28 Feb 2025 | |
| Annual price for preventative maintenance should include two full time employees and include all labor, equipment and material costs to conduct all maintenance activities in PWS paragraphs 5.2.3.1 - 5.2.3.11 | |
| 2 Full Time Employees working 40 hours per week at SIAD 1980 hours per year. | |
| Preventative Maintenance will be invoice and paid on a monthly basis at 1/12th the annual. |
Standard Repair Services
| REPAIR SERVICES (FFP) | |||
| Repair Services | Year | Price | |
| CLIN 1002 - Year One | 2022-2023 | $0.00 | |
| CLIN 2002 - Year Two | 2023-2024 | $0.00 | |
| CLIN 3002 - Year Three | 2024-2025 | $0.00 | |
| Ordering Period One: (CLIN 1002) | |||
| Position | Job Title | Fully Loaded | |
| Labor Rate | Estimated | ||
| Hours (year) | Extended Labor |
Costs
| Labor 1 | 60 | $0.00 | |||
| Labor 2 | 60 | $0.00 | |||
| Ordering Period Two: (CLIN 2002) | |||||
| Position | Job Title | Fully Loaded | |||
| Labor Rate | Estimated | ||||
| Hours (year) | Extended Labor |
Costs
| Labor 1 | 60 | $0.00 | |||
| Labor 2 | 60 | $0.00 | |||
| Ordering Period Three: (CLIN 3002) | |||||
| Position | Job Title | Fully Loaded | |||
| Labor Rate | Estimated | ||||
| Hours (year) | Extended Labor |
Costs
| Labor 1 | 60 | $0.00 |
| Labor 2 | 60 | $0.00 |
| For evaluation purposes, the Government will calculate Extended Labor costs as follows: | ||
| 2 Full Time Employees x fully loaded labor rate x estimated hours (60). |
Emergency Repair Services
| EMERGENCY SERVICES (T&M) | |||
| Emergency Services | Year | Price | |
| CLIN 1003 - Year One | 2022-2023 | $0.00 | |
| CLIN 2003 - Year Two | 2023-2024 | $0.00 | |
| CLIN 3003 - Year Three | 2024-2025 | $0.00 | |
| Ordering Period One: (CLIN 1003) | |||
| Position | Job Title | Fully Loaded | |
| Labor Rate | Estimated | ||
| Hours (year) | Extended Labor |
Costs
| Labor 1 | 60 | $0.00 | |||
| Labor 2 | 60 | $0.00 | |||
| Ordering Period Two: (CLIN 2003) | |||||
| Position | Job Title | Fully Loaded | |||
| Labor Rate | Estimated | ||||
| Hours (year) | Extended Labor |
Costs
| Labor 1 | 60 | $0.00 | |||
| Labor 2 | 60 | $0.00 | |||
| Ordering Period Three: (CLIN 3003) | |||||
| Position | Job Title | Fully Loaded | |||
| Labor Rate | Estimated | ||||
| Hours (year) | Extended Labor |
Costs
| Labor 1 | 60 | $0.00 |
| Labor 2 | 60 | $0.00 |
| For evaluation purposes, the Government will calculate Extended Labor costs as follows: | ||
| 2 Full Time Employees x fully loaded labor rate x estimated hours (60). |
Material
| MATERIAL COST (T&M) | ||
| Material | Year | Price |
| CLIN 1004 - Year One | 2022-2023 | $6,861.00 |
| CLIN 2004 - Year Two | 2023-2024 | $7,204.00 |
| CLIN 3004 - Year Three | 2024-2025 | $7,564.00 |
| Ordering Period One: (CLIN 1004) | ||
| Rate | Dollars | |
| Direct Material Price* | $6,861.00 | |
| Indirect Rate (to include material handling, overhead, G&A, etc.) | $0.00 | |
| Profit | $0.00 | |
| Ordering Period One Material Price | $6,861.00 |
| Ordering Period Two: (CLIN 2004) | Rate | Dollars |
| Direct Material Price* | $7,204.00 | |
| Indirect Rate (to include material handling, overhead, G&A, etc.) | $0.00 | |
| Profit | $0.00 | |
| Ordering Period Two Material Price | $7,204.00 |
| Ordering Period Two: (CLIN 2004) | Rate | Dollars |
| Direct Material Price* | $7,564.00 | |
| Indirect Rate (to include material handling, overhead, G&A, etc.) | $0.00 | |
| Profit | $0.00 | |
| Ordering Period Three Material Price | $7,564.00 | |
| *Direct material prices entered are used for evaluation purposes only |
Additional Work Installation
| Additional Work/Installation Services (FFP) | |||
| Installation Services | Year | Price | |
| CLIN 1005 - Year One | 2022-2023 | $0.00 | |
| CLIN 2005 - Year Two | 2023-2024 | $0.00 | |
| CLIN 3005 - Year Three | 2024-2025 | $0.00 | |
| Ordering Period One: (CLIN 1005) | |||
| Position | Job Title | Fully Loaded | |
| Labor Rate | Estimated | ||
| Hours | Extended Labor |
Costs
| Installation/Service Connector Laborer 1 | 80 | $0.00 | |||
| Installation/Service Connector Laborer 2 | 80 | $0.00 | |||
| Ordering Period Two: (CLIN 2005) | |||||
| Position | Job Title | Fully Loaded | |||
| Labor Rate | Estimated | ||||
| Hours | Extended Labor |
Costs
| Installation/Service Connector Laborer 1 | 80 | $0.00 | |||
| Installation/Service Connector Laborer 2 | 80 | $0.00 | |||
| Ordering Period Three: (CLIN 3005) | |||||
| Position | Job Title | Fully Loaded | |||
| Labor Rate | Estimated | ||||
| Hours | Extended Labor |
Costs
| Installation/Service Connector Laborer 1 | 80 | $0.00 |
| Installation/Service Connector Laborer 2 | 80 | $0.00 |
| For evaluation purposes, the Government will calculate Extended Labor costs as follows: | ||
| 2 laborers qualified to perform installation/service connections described in PWS paragraphs 5.2.3.12 and 5.2.3.13 x fully loaded labor rate x estimated hours (80). |
Total Evaluated Price
| Description | Year 1 Pricing | Year 2 Pricing | Year 3 Pricing | Subtotal |
| Summary - Preventative Maintenance | $0.00 | $0.00 | $0.00 | $0.00 |
| Summary - Standard Repair Services | $0.00 | $0.00 | $0.00 | $0.00 |
| Summary - Emergency Repair Services | $0.00 | $0.00 | $0.00 | $0.00 |
| Summary - Material | $6,861.00 | $7,204.00 | $7,564.00 | $21,629.00 |
| Summary - Additional Work - Installation Services | $0.00 | $0.00 | $0.00 | $0.00 |
| Subtotal by year | $6,861.00 | $7,204.00 | $7,564.00 |
Total Evaluated Price $21,629.00
File details come from the government source that posted it. Updated .