Generator quote sheet.xlsx
XLSX spreadsheet 44 KB Posted
- Solicitation number
- 70Z028-285-Q-0000169
About this file
The document is a Generator quote sheet Excel template providing detailed instructions for developing an Independent Government Estimate (IGE) for generator maintenance services. The template guides users through creating performance maintenance (PM) tabs, calculating technician and supervisor labor costs, filter expenses, and developing cost estimates for a base year and four option years with a 5% annual inflation factor. The template includes specific tabs for PM breakout by location, filter breakout, and cost calculations for base and option years, with placeholders for Station Port Canaveral and Marathon locations.
The associated federal contract opportunity is a Small Business Set-Aside solicitation (70Z028-285-Q-0000169) by the US Coast Guard for generator maintenance services at Coast Guard Station Fort Myers Beach, FL. The firm fixed-price contract will be awarded using Lowest Price Technically Acceptable (LPTA) methodology, with quotes due by 3 p.m. on 06 June 2025. The performance period includes a base year and four option years, with work expected to commence within 5 days of award. Vendors must be registered in SAM, provide past performance documentation, submit a price breakdown for monthly maintenance and service calls, and are encouraged to conduct a site visit prior to proposal submission.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Generator quote sheet.xlsx | XLSX spreadsheet | |
| FFP Service Clause.pdf | ||
| 15-4529.txt | TXT text file | |
| 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 sample | |||||||
| Section 5.4 from PWS | |||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | ||
| 00001A | Elevator PM Services: STA PORT CANAVERAL Multi-Mission Building | 12 | MO | $0.00 | |||
| Section 5.5 from PWS | |||||||
| CLIN | Schedule of Services | Est Qty | Unit | Unit Price | Total Amount | ||
| 00002A | STA PORT CANAVERAL MMB Corrective Service Hours | 40 | EA | $0.00 | |||
| 00002B | STA PORT CANAVERAL MMB Corrective Repair Parts | NTE | EA | NTE | |||
| Base Period Subtotal: | $0.00 | ||||||
| 2% Contractor Access Fee: | $0.00 | ||||||
| BASE PERIOD TOTAL: | $0.00 |
| Option Year 1 |
| Option Year 2 |
| Option Year 3 |
| Option Year 4 |
Total Contract $0.00
IGE-Option Year 1
| INDEPENDENT GOVERNMENT ESTIMATE - OPTION YEAR 1 | ||||||||
| Section 5.4 from PWS | Inflation Percentage | |||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | 5% | ||
| 00001A | Elevator PM Services: STA MARATHON UPH | 12 | EA | $0.00 | $0.00 | |||
| Section 5.5 from PWS | Unit Price | Total Amount | ||||||
| CLIN | Schedule of Services | Est Qty | Unit | $200.00 | $8,000.00 | |||
| 00002A | STA PORT CANAVERAL MMB Corrective Service Hours | 40 | EA | NTE | $5,000.00 | |||
| 00002B | STA PORT CANAVERAL MMB Corrective Repair Parts | NTE | EA | $13,000.00 | ||||
| Option Year 1 Subtotal: | $260.00 | |||||||
| 2% Contractor Access Fee: | $13,260.00 | |||||||
| OPTION YEAR 1 TOTAL: |
IGE-Option Year 2
| INDEPENDENT GOVERNMENT ESTIMATE - OPTION YEAR 2 | ||||||||
| Section 5.4 from PWS | ||||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | Inflation Percentage | ||
| 00001A | Elevator PM Services: STA MARATHON UPH | 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 PORT CANAVERAL MMB Corrective Service Hours | 40 | EA | $200.00 | $8,000.00 | |||
| 00002B | STA PORT CANAVERAL MMB Corrective Repair Parts | NTE | EA | NTE | $5,000.00 | |||
| Option Year 2 Subtotal: | $13,000.00 | |||||||
| 2% Contractor Access Fee: | $260.00 | |||||||
| OPTION YEAR 2 TOTAL: | $13,260.00 |
IGE-Option Year 3
| INDEPENDENT GOVERNMENT ESTIMATE - OPTION YEAR 3 | ||||||||
| Section 5.4 from PWS | ||||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | Inflation Percentage | ||
| 00001A | Elevator PM Services: STA MARATHON UPH | 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 PORT CANAVERAL MMB Corrective Service Hours | 40 | EA | $200.00 | $8,000.00 | |||
| 00002B | STA PORT CANAVERAL MMB Corrective Repair Parts | NTE | EA | NTE | $5,000.00 | |||
| Option Year 3 Subtotal: | $13,000.00 | |||||||
| 2% Contractor Access Fee: | $260.00 | |||||||
| OPTION YEAR 3 TOTAL: | $13,260.00 |
IGE-Option Year 4
| INDEPENDENT GOVERNMENT ESTIMATE - OPTION YEAR 4 | ||||||||
| Section 5.4 from PWS | ||||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | Inflation Percentage | ||
| 00001A | Elevator PM Services: STA MARATHON UPH | 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 PORT CANAVERAL MMB Corrective Service Hours | 40 | EA | $200.00 | $8,000.00 | |||
| 00002B | STA PORT CANAVERAL MMB Corrective Repair Parts | NTE | EA | NTE | $5,000.00 | |||
| Option Year 4 Subtotal: | $13,000.00 | |||||||
| 2% Contractor Access Fee: | $260.00 | |||||||
| OPTION YEAR 4 TOTAL: | $13,260.00 |
File details come from the government source that posted it. Updated .