Elevator quote sheet.xlsx
XLSX spreadsheet 44 KB Posted
- Solicitation number
- 70Z028-25-Q-0000
About this file
This document is an elevator quote sheet for an HVAC maintenance contract for the US Coast Guard Station in Fort Myers Beach, Florida. The solicitation (Number 70Z028-25-Q-0000) is a small business set-aside for elevator maintenance services, with a base award and four option years. The contract is a firm fixed-price service with a lowest price, technically acceptable (LPTA) evaluation approach.
The quote sheet details pricing for preventative maintenance services and corrective service hours, with a base period total of $5,100.00 and an inflation rate of 5% for option years. Quotes are due by 3 p.m. on 06 June 2025, with an anticipated award date of 10 business days after solicitation close. Performance is expected to commence within 5 days of award, with work limited to Monday through Friday, 8 a.m. to 3 p.m. Vendors must be registered in SAM, provide past performance documentation, and include a price breakdown of monthly preventative maintenance and hourly service call costs.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Updated PWS Elevator - Ft. Myers FINAL 5.13.25.docx | DOCX document | |
| SF30-16c.pdf | ||
| FFP Service Clause.pdf | ||
| PWS Elevator - Ft. Myers FINAL.docx | DOCX document | |
| 86-0277.txt | TXT text file |
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
| Elevator quote sheet Station Fort Myers Beach Base quote | |||||||
| Section 5.4 from PWS | |||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | ||
| 00001A | Elevator Preventative Maintenance Services | 12 | MO | $0.00 | |||
| Section 5.5 from PWS | |||||||
| CLIN | Schedule of Services | Est Qty | Unit | Unit Price | Total Amount | ||
| 00002A | STA Fort Myers Beach Corrective Service Hours | 40 | EA | $0.00 | |||
| 00002B | STA Fort Myers Beach Corrective Repair Parts | NTE | EA | NTE | $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 |
Base Award Total Contract $5,100.00
IGE-Option Year 1
| Elevavator quote sheet Station Fort Myers Beach Option YR 1 | ||||||||
| Section 5.4 from PWS | Inflation Percentage | |||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | 5% | ||
| 00001A | Elevator Preventative Maintenance Services | 12 | EA | $0.00 | ||||
| Section 5.5 from PWS | Unit Price | Total Amount | ||||||
| CLIN | Schedule of Services | Est Qty | Unit | $0.00 | ||||
| 00002A | STA Fort Myers Beach Corrective Service Hours | 40 | EA | NTE | $5,000.00 | |||
| 00002B | STA Fort 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
| Elevavator quote sheet Station Fort Myers Beach Option YR 2 | ||||||||
| Section 5.4 from PWS | ||||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | Inflation Percentage | ||
| 00001A | Elevator Preventative Maintenance Services | 12 | EA | $0.00 | 5% | |||
| Section 5.5 from PWS | ||||||||
| CLIN | Schedule of Services | Est Qty | Unit | Unit Price | Total Amount | |||
| 00002A | STA Fort Myers Beach Corrective Service Hours | 40 | EA | $0.00 | ||||
| 00002B | STA Fort 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
| Elevavator quote sheet Station Fort Myers Beach Option YR 3 | ||||||||
| Section 5.4 from PWS | ||||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | Inflation Percentage | ||
| 00001A | Elevator Preventative Maintenance Services | 12 | EA | $0.00 | 5% | |||
| Section 5.5 from PWS | ||||||||
| CLIN | Schedule of Services | Est Qty | Unit | Unit Price | Total Amount | |||
| 00002A | STA Fort Myers Beach Corrective Service Hours | 40 | EA | $0.00 | ||||
| 00002B | STA Fort 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
| Elevavator quote sheet Station Fort Myers Beach Option YR 4 | ||||||||
| Section 5.4 from PWS | ||||||||
| CLIN | Schedule of Services | Qty | Unit | Unit Price | Total Amount | Inflation Percentage | ||
| 00001A | Elevator Preventative Maintenance Services | 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 Fort Myers Beach Corrective Service Hours | 40 | EA | $0.00 | ||||
| 00002B | STA Fort 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 .