Attachment_11_Cost_Sheet_-_Bay_Area_(Addendum_7).xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- 23-189492. FMD. Elevator Repair & Maintenance
- Solicitation number
- 0000031772
About this file
This document is a Cost Sheet Attachment for a state and local government contract opportunity for Elevator Repair and Maintenance Services in the Bay Area region of California. The contract requires Preventive Maintenance services on gearless, geared, and hydraulic elevators for two state-owned buildings - the 402 Ronald M. George State Building in San Francisco and the 602 Elihu Harris Building in Oakland. The contract also includes Foreseeable Repair Services and Unforeseeable Repair Services for the elevator equipment. The total bid amount for the 5-year contract term is $180,000 for the 402 Ronald M. George State Building, while the 602 Elihu Harris Building has a $0 bid amount.
The Cost Sheet details the per-service rates, equipment quantities, and annual totals for Preventive Maintenance, Foreseeable Repairs, and Unforeseeable Repairs. Parts and labor rates are provided, with a 0% markup on parts. The contract will be awarded to the responsive and responsible bidder who submits the lowest total bid amount. This contract opportunity is part of solicitation 23-189492 issued by the California Facilities Management Division.
View the file
Other files
Show all 24
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
Summary Cost Sheet
| ATTACHMENT 11 |
| PLEASE NOTE: |
The summary cost sheet is included for evaluation purposes only; it will not be included in the final contract.
COST SHEET INSTRUCTIONS:
This Excel workbook is designed for Bidders to input their information in the designated (white) cells and formulas will automatically calculate totals. All other cells are locked to prevent accidential overwriting of formulas.
Bidders will NOT enter totals on this Summary Cost Sheet tab. The Summary Cost Sheet will automatically calculate totals from each Building's Cost Sheet located on this Excel Workbook Tabs 11-A through 11-B.
Bidders need to enter the following information onto each Building's Cost Sheet tab included on this Excel workbook:
- Table 1 Preventive Maintenance (Rates)
- Table 2 Foreseeable Repairs Services (Normal Business Hourly Rate, # of Technician Hours, and Parts Replacement Amount)
- Table 3 Unforeesable Repairs (Hourly Rates and Parts Markup Percentage)
After entering all the information as specified above, Bidders must print out a hardcopy of the entire workbook (must include each tab of the Excel workbook) to include with their bid submission.
| SUMMARY COST SHEET | ||||
| Bay Area | ||||
| The Total Bid Amount identified on the Cost Sheet Summary on Attachments | ||||
| 11-A through 11-B are summarized below: | ||||
| (A) | (B) | (C) | (D) | |
| COST SHEET | BUILDING # AND NAME | ADDRESS | TOTAL COST | |
| 11-A | 402 | Ronald M. George State Building | 455 Golden Gate Avenue, San Francisco | $ 180,000.00 |
| 11-B | 602 | Elihu Harris Building | 1515 Clay Street, Oakland | $ - 0 |
TOTAL CONTRACT LOCATION BID AMOUNT (Sum of Column D) $ 180,000.00
11-A (402)
| ATTACHMENT | 11-A | ||||||
| COST SHEET | |||||||
| (402) | Ronald M. George State Building | ||||||
| 1. Preventive Maintenance | |||||||
| Description | (A) | (B) | (C) | (D) | |||
| Service/Maintenance | Frequency of Service | Rate | # of Equipment | # of times per year | Annual Total Calculated Amount (A x B x C) | ||
| Gearless Elevators1 | Monthly | $ - 0 | 2 | 12 | $ - 0 | ||
| Geared Elevator1 | Monthly | $ - 0 | 1 | 12 | $ - 0 | ||
| Testing as specified in Exhibit A Section 8.F.7 & Section 8.F.8 - Annual, No Load1 | Annually | $ - 0 | 3 | 1 | $ - 0 | ||
| Fire Recall Testing as specified in Exhibit A Section 8.F.7.g1 | Monthly | $ - 0 | 3 | 12 | $ - 0 | ||
| Housekeeping as specified in Exhibit A Section 8.F.101 | Quarterly | $ - 0 | 3 | 4 | $ - 0 | ||
| Semi-Annually | $ - 0 | 3 | 2 | $ - 0 | |||
| Weekly Incident Report as specified in Exhibit A Section 8.F.11.f1 | Weekly | $ - 0 | 3 | 52 | $ - 0 | ||
| Geared Elevators | Monthly | $ - 0 | 10 | 12 | $ - 0 | ||
| Hydraulic | Monthly | $ - 0 | 3 | 12 | $ - 0 | ||
| Testing as specified in Exhibit A Section 8.F.7 & Section 8.F.8 - Annual, No Load | Annually | $ - 0 | 13 | 1 | $ - 0 | ||
| Fire Recall Testing as specified in Exhibit A Section 8.F.7.g | Monthly | $ - 0 | 13 | 12 | $ - 0 | ||
| Housekeeping as specified in Exhibit A Section 8.F.10 | Quarterly | $ - 0 | 13 | 4 | $ - 0 | ||
| Semi-Annually | $ - 0 | 13 | 2 | $ - 0 | |||
| Weekly Incident Report as specified in Exhibit A Section 8.F.11.f | Weekly | $ - 0 | 13 | 52 | $ - 0 | ||
| ANNUAL TOTAL | |||||||
| (Sum of Column D)1 | $ - 0 | ||||||
| ANNUAL TOTAL | |||||||
| (Sum of Column D) | $ - 0 | ||||||
| Calculated Preventive Maintenance Subtotal (Annual Total x 4)1 | $ - 0 | ||||||
| Calculated Preventive Maintenance Subtotal (Annual Total x 5) | $ - 0 | ||||||
| Service/Maintenance | Frequency of Service | Rate | # of Equipment | # of times per contract term | |||
| Full Load, full speed test | |||||||
| (as specified in Exhibit A Section 8.F.7.c) | Once per 5 year term | $ - 0 | 16 | 1 | $ - 0 | ||
| Preventive Maintenance Total (Sum of Calculated Preventive Maintenance Subtotal + Full Load/Full Speed test) | $ - 0 | ||||||
| 1 Table 1:Preventative Maintenance. Rows 1-7 idenitfy 3 existing elevators that will only require preventative maintenance services for 4 years, as these 3 elevators are under warranty through August, 31, 2025. |
| 2. Foreseeable Repairs Services1 | |||||||
| (A) | (B) | (C) | (D) | (E) | |||
| TYPE | Description | ||||||
| (Remove and Replace) | Normal Business Hourly Rate2 | # of Technician Hours for Repair | Calculated Labor Amount | ||||
| (A x B) | Parts Replacement Amount3 | Total Combined Replacement Amount |
(C + D)
| Door Operator | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Door Interlock | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Signal Fixture | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Car Operating Panel (COP) | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Geared & Gearless | Entrance Door Landing | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 |
| Elevator Door | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Ventilation Fan | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Breaker | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Hydraulic Pump | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Main Valve | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Tank Unit/Power Unit | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Piston | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Hydraulic | Door Operator | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 |
| Door Interlock | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Signal Fixture | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Car Operating Panel (COP) | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Entrance Door Landing | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Elevator Door | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Ventilation Fan | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Breaker | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| General | Diamond Plate Wall Paneling (per car) | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Foreseeable Repairs (Sum of Column E) | $ - 0 | |||||
| 1 Table 2: Foreseeable Repair Services amounts are used for evaluation purposes. Cost Sheet amounts are not a guarantee of service, but shall be used should these services become necessary during the term of the Agreement. | ||||||
| 2 Table 2: The State will pay the Foreseeable Repair Services at the fixed price specified as the Total Combined Replacement Amount (Column E) based on the calculations with the Normal Business Hourly Rate. Should FMD require that the repairs be performed outside of normal business hours, the Foreseeable Repairs Normal Business Hourly Rate (Column A) shall be replaced by the applicable Per Hourly Rate from Table 3 Unforeseeable Repair Services to calculate the Total Combined Replacement Amount (Column E). The State will not pay a separate hourly rate and/or parts replacement amount. | ||||||
| 3 Table 2: The Parts Replacement Amount (column D) in the Foreseeable Repair Services (Table 2) are all inclusive, including tax, mark up, etc. The Parts Replacement is included in the Total Combined Replacement Amount and will not be paid separately. |
| 3. Unforeseeable Repairs1 | ||||||
| Description | (A) | (B) | (C) | |||
| Type of Service | ||||||
| Hourly Labor Type | Per Hourly Rate2 | Estimated # of Technician Hours for Repair | Annual Calculated Amount |
(A x B)
| Normal Business Hours as identified in Exhibit A, Scope of Work, Section 5.A.1. | $ - 0 | 80 | $ - 0 | |||
| Weekday Outside of Normal Business Hours as identified in Exhibit A, Scope of Work, Section 5.A.1. | $ - 0 | 20 | $ - 0 | |||
| Weekend Emergency Labor Rate (Requires response as identified in Exhibit A, Scope of Work Section 11.B) | $ - 0 | 15 | $ - 0 | |||
| Holiday Emergency Labor Rate (Requires response as identified in Exhibit A, Scope of Work Section 11.B) | $ - 0 | 15 | $ - 0 | |||
| Parts Allowance | $ 36,000.00 | |||||
| Parts Markup3 | 0% | $36,000.00 | $ - 0 | |||
| ANNUAL TOTAL (Sum of Column C) | $ 36,000.00 | |||||
| CALCULATED UNFORESEEABLE REPAIR SERVICES TOTAL (Annual Total x 5) | $ 180,000.00 | |||||
| 1 Table 3: Unforeseeable Repair Services amounts are used for evaluation purposes. Cost Sheet amounts are not a guarantee of service, but shall be used should these services become necessary during the term of the Agreement. | ||||||
| 2 Table 3: Unforeseeable Repair Services is for one (1) Service Technician. Should the Contractor require more than one (1) Service Technician to perform services, approval must be obtained by the Facilities Management Division (FMD) Contract Administrator or FMD Designated Representative prior to commencement of service. | ||||||
| 3 Table 3: Any Unforeseeable Repair Services requiring an unforeseeable repair part shall require actual receipt for the part when invoicing FMD. A Purchase Order or Purchase Estimate is not to be used in place of a receipt. | ||||||
| COST SHEET SUMMARY | ||||||
| (A) | (B) | |||||
| Table | Bid Amount | |||||
| 1 | PREVENTIVE MAINTENANCE TOTAL | |||||
| (Sum of Calculated Preventive Maintenance Subtotal + Full Load/Full Speed test) | $ - 0 | |||||
| 2 | Foreseeable Repair Services | |||||
| CALCULATED FORESEEABLE REPAIR SERVICES TOTAL | $ - 0 |
| 3 | Unforseeable Repair Services | |||
| CALCULATED UNFORSEEABLE REPAIR SERVICES TOTAL (Annual Total x 5) | $ 180,000.00 | |||
| Total Bid Amount | ||||
| (Sum of Column B) | $ 180,000.00 | |||
| NOTES: | ||||
| The State will not pay for fees not listed on Exhibit B, Attachment 1, Cost Sheet (i.e., travel, freight, trip, tax, and/or fuel surcharges, etc.). | ||||
| Contractor shall be responsible for supplying miscellaneous materials (i.e., grease, lubrications, gloves, etc.) incidental to service, including safety materials needed or required to perform service, at no additional charge to the State. | ||||
| Each building shall be invoiced separately for services/repairs provided to each building in accordance with Exhibit A, Attachment 1, Conveyance Equipment Description. |
11-B (602)
| ATTACHMENT | 11-B | |||||
| COST SHEET | ||||||
| (602) | Elihu Harris Building | |||||
| 1. Preventive Maintenance | ||||||
| Description | (A) | (B) | (C) | (D) | ||
| Service/Maintenance | Frequency of Service | Rate | # of Equipment | # of times per year | Annual Total Calculated Amount (A x B x C) |
| Gearless Elevators | Monthly | $ - 0 | 9 | 12 | $ - 0 |
| Geared Elevators | Monthly | $ - 0 | 6 | 12 | $ - 0 |
| Hydraulic | Monthly | $ - 0 | 2 | 12 | $ - 0 |
| Testing as specified in Exhibit A Section 8.F.7 & Section 8.F.8 - Annual, No Load | Annually | $ - 0 | 17 | 1 | $ - 0 | ||
| Fire Recall Testing as specified in Exhibit A Section 8.F.7.g | Monthly | $ - 0 | 17 | 12 | $ - 0 | ||
| Housekeeping as specified in Exhibit A Section 8.F.10 | Quarterly | $ - 0 | 17 | 4 | $ - 0 | ||
| Semi-Annually | $ - 0 | 17 | 2 | $ - 0 | |||
| Weekly Incident Report as specified in Exhibit A Section 8.F.11.f | Weekly | $ - 0 | 17 | 52 | $ - 0 | ||
| ANNUAL TOTAL | |||||||
| (Sum of Column D) | $ - 0 | ||||||
| Calculated Preventive Maintenance Subtotal (Annual Total x 5) | $ - 0 | ||||||
| Service/Maintenance | Frequency of Service | Rate | # of Equipment | # of times per contract term | |||
| Full Load, full speed test | |||||||
| (as specified in Exhibit A Section 8.F.7.c) | Once per 5 year term | $ - 0 | 17 | 1 | $ - 0 | ||
| Preventive Maintenance Total (Sum of Calculated Preventive Maintenance Subtotal + Full Load/Full Speed test) | $ - 0 |
| 2. Foreseeable Repairs Services1 | |||||||
| (A) | (B) | (C) | (D) | (E) | |||
| TYPE | Description | ||||||
| (Remove and Replace) | Normal Business Hourly Rate2 | # of Technician Hours for Repair | Calculated Labor Amount | ||||
| (A x B) | Parts Replacement Amount3 | Total Combined Replacement Amount |
(C + D)
| Door Operator | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Door Interlock | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Signal Fixture | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Car Operating Panel (COP) | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Geared & Gearless | Entrance Door Landing | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 |
| Elevator Door | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Ventilation Fan | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Breaker | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Hydraulic Pump | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Main Valve | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Tank Unit/Power Unit | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Piston | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Hydraulic | Door Operator | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 |
| Door Interlock | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Signal Fixture | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Car Operating Panel (COP) | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Entrance Door Landing | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Elevator Door | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Ventilation Fan | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| Breaker | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | |
| General | Diamond Plate Wall Paneling (per car) | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Foreseeable Repairs (Sum of Column E) | $ - 0 | |||||
| 1 Table 2: Foreseeable Repair Services amounts are used for evaluation purposes. Cost Sheet amounts are not a guarantee of service, but shall be used should these services become necessary during the term of the Agreement. | ||||||
| 2 Table 2: The State will pay the Foreseeable Repair Services at the fixed price specified as the Total Combined Replacement Amount (Column E) based on the calculations with the Normal Business Hourly Rate. Should FMD require that the repairs be performed outside of normal business hours, the Foreseeable Repairs Normal Business Hourly Rate (Column A) shall be replaced by the applicable Per Hourly Rate from Table 3 Unforeseeable Repair Services to calculate the Total Combined Replacement Amount (Column E). The State will not pay a separate hourly rate and/or parts replacement amount. | ||||||
| 3 Table 2: The Parts Replacement Amount (column D) in the Foreseeable Repair Services (Table 2) are all inclusive, including tax, mark up, etc.. The Parts Replacement is included in the Total Combined Replacement Amount and will not be paid separately. |
| 3. Unforeseeable Repairs1 | ||||||
| Description | (A) | (B) | (C) | |||
| Type of Service | ||||||
| Hourly Labor Type | Per Hourly Rate2 | Estimated # of Technician Hours for Repair | Annual Calculated Amount |
(A x B)
| Normal Business Hours as identified in Exhibit A, Scope of Work, Section 5.A.1. | $ - 0 | 280 | $ - 0 | |||
| Weekday Outside of Normal Business Hours as identified in Exhibit A, Scope of Work, Section 5.A.1. | $ - 0 | 60 | $ - 0 | |||
| Weekend Emergency Labor Rate (Requires response as identified in Exhibit A, Scope of Work Section 11.B) | $ - 0 | 40 | $ - 0 | |||
| Holiday Emergency Labor Rate (Requires response as identified in Exhibit A, Scope of Work Section 11.B) | $ - 0 | 15 | $ - 0 | |||
| Parts Allowance | $ 100,000.00 | |||||
| Parts Markup3 | 0% | $100,000.00 | $ - 0 | |||
| ANNUAL TOTAL (Sum of Column C) | $ 100,000.00 | |||||
| CALCULATED UNFORESEEABLE REPAIR SERVICES TOTAL (Annual Total x 5) | ||||||
| 1 Table 3: Unforeseeable Repair Services amounts are used for evaluation purposes. Cost Sheet amounts are not a guarantee of service, but shall be used should these services become necessary during the term of the Agreement. | ||||||
| 2 Table 3: Unforeseeable Repair Services is for one (1) Service Technician. Should the Contractor require more than one (1) Service Technician to perform services, approval must be obtained by the Facilities Management Division (FMD) Contract Administrator or FMD Designated Representative prior to commencement of service. | ||||||
| 3 Table 3: Any Unforeseeable Repair Services requiring an unforeseeable repair part shall require actual receipt for the part when invoicing FMD. A Purchase Order or Purchase Estimate is not to be used in place of a receipt. | ||||||
| COST SHEET SUMMARY | ||||||
| (A) | (B) | |||||
| Table | Bid Amount | |||||
| 1 | PREVENTIVE MAINTENANCE TOTAL | |||||
| (Sum of Calculated Preventive Maintenance Subtotal + Full Load/Full Speed test) | $ - 0 | |||||
| 2 | Foreseeable Repair Services | |||||
| CALCULATED FORESEEABLE REPAIR SERVICES TOTAL | $ - 0 |
| 3 | Unforseeable Repair Services | |||
| CALCULATED UNFORSEEABLE REPAIR SERVICES TOTAL (Annual Total x 5) | $ - 0 | |||
| Total Bid Amount | ||||
| (Sum of Column B) | $ - 0 | |||
| NOTES: | ||||
| The State will not pay for fees not listed on Exhibit B, Attachment 1, Cost Sheet (i.e., travel, freight, trip, tax, and/or fuel surcharges, etc.). | ||||
| Contractor shall be responsible for supplying miscellaneous materials (i.e., grease, lubrications, gloves, etc.) incidental to service, including safety materials needed or required to perform service, at no additional charge to the State. | ||||
| Each building shall be invoiced separately for services/repairs provided to each building in accordance with Exhibit A, Attachment 1, Conveyance Equipment Description. |
File details come from the government source that posted it. Updated .