Generator quote sheet.xlsx
XLSX spreadsheet 44 KB Posted
- Solicitation number
- 70Z028-285-Q-0000169
About this file
This document is a generator quote sheet for a federal contract opportunity for generator maintenance services at the US Coast Guard Station in Fort Myers Beach, Florida. The solicitation (Number 70Z028-285-Q-0000169) is a small business set-aside contract for a firm fixed-price generator maintenance service, with a base year and four option years. The contract requires monthly generator maintenance, corrective repair parts, and emergency service calls, with a base period total of $5,100.00 and each subsequent option year priced at $5,100.00 with a 5% inflation adjustment.
Key contract details include a performance period commencing within 5 days after award, work hours limited to Monday through Friday from 0800-1500, and a quote submission deadline of 06 June 2025 at 3 p.m. The contract will be awarded using a Lowest Price Technically Acceptable (LPTA) approach, with vendors required to provide past performance documentation, pricing breakdowns for monthly maintenance and service calls, and be registered in the System for Award Management (SAM) with an active status. The government anticipates awarding the contract within 10 business days after the solicitation closes, with a final contract expiration date of 20 June 2025.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| FFP Service Clause.pdf | ||
| 15-4529.txt | TXT text file | |
| Generator quote sheet.xlsx | XLSX spreadsheet | |
| PWS Generator - Ft Myers FINAL with MPCs.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
Instructions
| Instructions on How "HVAC PWS-IGE Template" Example was Developed / Used | |
| PM Tab for Each Location | |
| 1 | Create a PM tab for each location to be included in the contract and copy the equipment list charts from their respective PWS Technical Exhibits into each tab |
| 2 | Using a Pivot Table or other means, determine the job plans numbers associated with each location as well as the number of times each job plan occurs at that location |
| 3 | The job plan numbers and respective quantities for each will be used on another tab as referenced below |
| PM Breakout by Location Tab | |
| 1 | Determine the appropriate HVAC Technician and HVAC Supervisor burdened hourly rate to use for the PWS and fill in these rates in Cell K1 and M1 respectively on the "PM Breakout by Location" tab |
| 2 | Copy the job plan numbers for each location into Column B of the "PM Breakout by Location" tab. |
| 3 | The data for the Hours Per Job Plan (Column C) and Times Per Year Per Job Plan (Column D) is pulled from the "PM Hour and Frequency Table" tab using the VLOOKUP function |
| 4 | Copy the quantities per job plan numbers for each location into Column E of the "PM Breakout by Location" tab. |
| 5 | Column F calculates the total number of hours for a given job plan at each location (ie hours per job plan (Column C) x times per year per job plan (Column D) x number of locations with the same job plan (Column E)) |
| 6 | Column G calculates the total annual cost for an HVAC Technician for a particular job plan at a particular location (Hourly rate (K1) x total annual hours per job plan (Column F)) |
| 7 | Column H calculates the total annual cost for a HVAC Supervisor for a particular job plan at a particular location based on the assumption that the supervisor will spend approximately 1/3 of the amount of time spent by technicians. If the assumption changes, the formula needs to change accordingly (Hourly rate (M1) x total annual hours per job plan (Column F) x 0.33) |
| 8 | The sum total for the Total HVAC Technician Cost Per Job Plan (Column G) and Total HVAC Supervisor Cost Per Job Plan (Column H) columns for each unit will be used on the IGE summary page as referenced below |
| Filter Breakout by Location Tab | |
| 1 | Copy the equipment list charts from their respective PWS Technical Exhibits |
| 2 | Determine the appropriate cost per filter and include this cost in Column E |
| 3 | Calculate the Total Cost Per Filter Type (Column F) based on the quantity (Column B) and cost per filter (Column E) |
| 4 | The sum total for the Total Cost Per Filter Type (Column F) for each unit will be used on the IGE summary page as referenced below |
| 5 | List the type/manufacturer of the control system or put N/A if it does not apply in Column I |
| 6 | If mechanical control system exists (shown in Column I), answer yes or no in Column J. If there is no mechanical control system, put N/A in Column J |
| IGE-Base Year Tab | |
| 1 | Add the sum total for the Total HVAC Technician Cost Per Job Plan (Column G of the PM Breakout by Location tab) and Total HVAC Supervisor Cost Per Job Plan (Column H of the PM Breakout by Location tab) and put this total in Column G (PM Total) for each unit |
| 2 | Put the sum total for the Total Cost Per Filter Type (Column F of the Filter Breakout by Location tab) in Column G (Filter Total) for each unit |
| 3 | Add the PM Total (Column F) and Filter Total (Column G) and place this total in Column H |
| 4 | Take the Total PM Services Cost Per Unit (Column H) and Divide by the Unit of Measure (Column C) to Calculate the Unit Price (Column E) for each unit |
| 5 | Determine the flat rate fee for each emergency service call per unit location and use this fee in Column G for each unit |
| 6 | For the Regular HVAC Technician Rate, use the rate listed in Cell K1 on the "PM Breakout by Location" tab. Input this information in Column G for each unit |
| 7 | For the Overtime HVAC Technician Rate, use the rate listed in Cell K1 on the "PM Breakout by Location" tab and multiply it by 1.5. Input this information in Column G for each unit |
| 8 | For the estimated quantities to use in Column E, contact each unit to determine the number of during duty hour and after duty hour calls based on their knowledge and historical records. The estimated quanitities in the example are based on the number of expected calls multiplied by an assumption of 3 hours per call however this can be adjusted |
| 9 | To calculate the Total Amounts (Column H) for Emergency Service Calls, Regular HVAC Technician hours, and Overtime HVAC Technician Hours, multiply the Unit Price (Column G) and Estimated Quanitities (Column E) |
| 10 | To calculate the Total Cost for the Base Year of the Contract, add the total cost of all PM Services for every unit as well as the total costs for every units Emergency Service Calls, Regular HVAC Technician hours, and Overtime Technician hours. |
| IGE-Option Year Tabs | |
| 1 | The option year cost tabs in this example were based on multiplying each line item from the previous year by an inflation factor. The inflation factor used was updated in Cell J3 of each tab and the cost were recalcualted accordingly |
| NOTE: | The data used in this example for each location is not indicative of the information actually included in the Sector New Orleans contract. The data is included in this template for example purposes only |
IGE-Base Year Quote sheet Generator PMS Sta Fort Myers Beach
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | ||
| 00001A | Station Fort Myers Beach Generator Maintenance | 12 | MO | $0.00 | |||
| Section 5.5 from PWS | |||||||
| CLIN | Schedule of Services | Est Qty | Unit | Unit Price | Total Amount | ||
| 00002A | STA Ft Myers Beach monthly maintenance | 12 | mo | $0.00 | |||
| 00002B | STA Ft Myers Beach Corrective Repair Parts | 1 | EA | $5,000.00 | $5,000.00 | ||
| Base Period Subtotal: | $5,000.00 | ||||||
| 2% Contractor Access Fee: | $100.00 | ||||||
| BASE PERIOD TOTAL: | $5,100.00 |
| Option Year 1 |
| Option Year 2 |
| Option Year 3 |
| Option Year 4 |
Total Contract $5,100.00
IGE-Option Year 1
| Quote sheet Generator PMS Sta Fort Myers Beach - OPTION YEAR 1 | ||||||||
| Section 5.4 from PWS | Inflation Percentage | |||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | 5% | ||
| 00001A | Station Fort Myers Beach Generator Maintenance | 12 | EA | $0.00 | $0.00 | |||
| Section 5.5 from PWS | Unit Price | Total Amount | ||||||
| CLIN | Schedule of Services | Est Qty | Unit | $0.00 | ||||
| 00002A | STA Ft Myers Beach monthly maintenance | 40 | EA | NTE | $5,000.00 | |||
| 00002B | STA Ft Myers Beach Corrective Repair Parts | NTE | EA | $5,000.00 | ||||
| Option Year 1 Subtotal: | $100.00 | |||||||
| 2% Contractor Access Fee: | $5,100.00 | |||||||
| OPTION YEAR 1 TOTAL: |
IGE-Option Year 2
| Quote sheet Generator PMS Sta Fort Myers Beach - OPTION YEAR 2 | ||||||||
| Section 5.4 from PWS | ||||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | Inflation Percentage | ||
| 00001A | Station Fort Myers Beach Generator Maintenance | 12 | EA | $0.00 | $0.00 | 5% | ||
| Section 5.5 from PWS | ||||||||
| CLIN | Schedule of Services | Est Qty | Unit | Unit Price | Total Amount | |||
| 00002A | STA Ft Myers Beach monthly maintenance | 40 | EA | $0.00 | ||||
| 00002B | STA Ft Myers Beach Corrective Repair Parts | NTE | EA | NTE | $5,000.00 | |||
| Option Year 2 Subtotal: | $5,000.00 | |||||||
| 2% Contractor Access Fee: | $100.00 | |||||||
| OPTION YEAR 2 TOTAL: | $5,100.00 |
IGE-Option Year 3
| Quote sheet Generator PMS Sta Fort Myers Beach - OPTION YEAR 3 | ||||||||
| Section 5.4 from PWS | ||||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | Inflation Percentage | ||
| 00001A | Station Fort Myers Beach Generator Maintenance | 12 | EA | $0.00 | $0.00 | 5% | ||
| Section 5.5 from PWS | ||||||||
| CLIN | Schedule of Services | Est Qty | Unit | Unit Price | Total Amount | |||
| 00002A | STA Ft Myers Beach monthly maintenance | 40 | EA | $0.00 | ||||
| 00002B | STA Ft Myers Beach Corrective Repair Parts | NTE | EA | NTE | $5,000.00 | |||
| Option Year 3 Subtotal: | $5,000.00 | |||||||
| 2% Contractor Access Fee: | $100.00 | |||||||
| OPTION YEAR 3 TOTAL: | $5,100.00 |
IGE-Option Year 4
| Quote sheet Generator PMS Sta Fort Myers Beach - OPTION YEAR 4 | ||||||||
| Section 5.4 from PWS | ||||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | Inflation Percentage | ||
| 00001A | Station Fort Myers Beach Generator Maintenance | 12 | EA | $0.00 | $0.00 | 5% | ||
| Section 5.5 from PWS | ||||||||
| CLIN | Schedule of Services | Est Qty | Unit | Unit Price | Total Amount | |||
| 00002A | STA Ft Myers Beach monthly maintenance | 40 | EA | $0.00 | ||||
| 00002B | STA Ft Myers Beach Corrective Repair Parts | NTE | EA | NTE | $5,000.00 | |||
| Option Year 4 Subtotal: | $5,000.00 | |||||||
| 2% Contractor Access Fee: | $100.00 | |||||||
| OPTION YEAR 4 TOTAL: | $5,100.00 |
File details come from the government source that posted it. Updated .