Scheduled Work Bid Form YUM FY26 2-18-26.xlsx
XLSX spreadsheet 64 KB Posted
- Solicitation number
- 20154783
About this file
This is a Scheduled Work Bid Form for the Yuma (YUM) sector maintenance contract under the CBP's Technical Infrastructure (TI) Maintenance Solicitation (20154783). The form requires offerors to complete pricing for a base period (04/01/26 - 03/31/27) and four option periods through 03/31/31. Offerors must populate yellow-highlighted cells with proposed costs for unscheduled maintenance, which currently show government estimates of $4,096,666.93 for the base period, escalating annually to $4,610,834.72 in Option Period 4, with a five-year total of $21,749,761.10. The form also requires offerors to propose a coefficient percentage for scheduled maintenance, unscheduled maintenance, and program management costs; however, all scheduled maintenance line items currently show $0 pricing. Scheduled maintenance covers routine maintenance of 25 motorized sliding gates, 4 motorized swing gates, 10 manual lift gates, 18 salinity canal gates, 1 bridge inspection/certification, and 253 border lighting circuit panels, each with specified quantities and event frequencies. The form automatically transfers scheduled amounts to a summary sheet to calculate total evaluated price.
View the file
Other files
Show all 34
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 YUM
| PMO Scheduled Work Bid Form |
| The Offeror shall complete the sheets for the Base Period, Option Period 1, Option Period 2, Option Period 3, and Option Period 4 for YUM by filling the cells highlighted in YELLOW. In addition, the offeror shall propose the co-efficient price by completing Row 11-17, and propose its coefficient % on the Summary sheet. For the Base, OY1, OY2, & OY3 the Scheduled amounts will transfer automatically to the summary sheet to give the total evaluated price. |
Summary
| Yuma Sector (YUM) | |||||||
| Requirement | Base Period: | ||||||
| 04/01/26 - 03/31/27 | Option 1: | ||||||
| 04/01/27 - 03/31/28 | Option 2: | ||||||
| 04/01/28 - 03/31/2029 | Option 3: | ||||||
| 04/01/29 - 03/31/2030 | Option 4: | ||||||
| 04/01/30 - 03/31/2031 | Total | ||||||
| Scheduled Maintenance (YUM)- FFP | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Unscheduled Maintenance (YUM) | $ 4,096,666.93 | $ 4,219,566.94 | $ 4,346,153.95 | $ 4,476,538.56 | $ 4,610,834.72 | ` | |
| Subtotal: | $ 4,096,666.93 | $ 4,219,566.94 | $ 4,346,153.95 | $ 4,476,538.56 | $ 4,610,834.72 | $ 21,749,761.10 | |
| Scheduled Maintenance Co-Efficient ($) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Unscheduled Maintenance Co-Efficient ($) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Program Management Costs - Co-Efficient Subtotal: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Estimated Cost: | $ 4,096,666.93 | $ 4,219,566.94 | $ 4,346,153.95 | $ 4,476,538.56 | $ 4,610,834.72 | $ 21,749,761.10 |
| Co-Efficient Factor (YUM) - Percentage % |
| Summary of Co-Efficient Value: |
| Overhead |
| G&A |
| Bond Rate |
| Fee |
| Use Tax |
| Scheduled Maintenance referenced in SOW C.4.1, C.5.1 |
| Coefficient referenced in SOW C.5.4 |
BASE Period (YUM)
| Category | BASE PERIOD: YUM SCHEDULED MAINT [FFP] | Description of Service | Qty of Asset | Count of Events | Duration | Total Cost | Cost/Event | Labor ($) | *Equipment ($) | *Material ($) | ODC ($) |
| F&G | SLU/ BMGR Maintenance Motorized Sliding Gates | Routine: Excercise, Clean (pests and debris), Lubricate and Inspect | 25 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Motorized Swing Gates | Routine: Exercise , Clean (pests and debris), Lubricate and Inspect | 4 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Sanchez Canal Channel Manual Lift Gates | Routine: Open /Close gates to inspect for damage/ operation and remove any debris caught in bollards. | 10 ea | 26 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Salinity Canal Gates | Routine: Exercise, Inspect and Lubricate | 18 ea | 6 | $0 | $0.00 | |||||
| R&B | Sanchez Canal Bridge Inspection/ Certification | Routine: Inspect and Certify 125 foot Steel Bridge | 1 ea | 1 | $0 | $0.00 | |||||
| L&E | Maintenance SLU Border Lighting Circuit Panels | Routine: Inspect, clean and check for failed components , ie fuses, breakers and photocells | 253 ea | 6 | $0 | $0.00 | |||||
| Scheduled Totals: | $ - 0 |
OPT Period 1 (YUM)
| Category | Opt PERIOD 1: YUM SCHEDULED MAINT [FFP] | Description of Service | Qty of Asset | Count of Events | Duration | Total Cost | Cost/Event | Labor ($) | *Equipment ($) | *Material ($) | ODC ($) |
| F&G | SLU/ BMGR Maintenance Motorized Sliding Gates | Routine: Excercise, Clean (pests and debris), Lubricate and Inspect | 25 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Motorized Swing Gates | Routine: Exercise , Clean (pests and debris), Lubricate and Inspect | 4 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Sanchez Canal Channel Manual Lift Gates | Routine: Open /Close gates to inspect for damage/ operation and remove any debris caught in bollards. | 10 ea | 26 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Salinity Canal Gates | Routine: Exercise, Inspect and Lubricate | 18 ea | 6 | $0 | $0.00 | |||||
| R&B | Sanchez Canal Bridge Inspection/ Certification | Routine: Inspect and Certify 125 foot Steel Bridge | 1 ea | 1 | $0 | $0.00 | |||||
| L&E | Maintenance SLU Boarder Lighting Circuit Panels | Routine: Inspect, clean and check for failed components , ie fuses, breakers and photocells | 253 ea | 6 | $0 | $0.00 | |||||
| Scheduled Totals: | $0.00 |
OPT Period 2 (YUM)
| Category | Opt PERIOD 2: YUM SCHEDULED MAINT [FFP] | Description of Service | Qty of Asset | Count of Events | Duration | Total Cost | Cost/Event | Labor ($) | *Equipment ($) | *Material ($) | ODC ($) |
| F&G | SLU/ BMGR Maintenance Motorized Sliding Gates | Routine: Excercise, Clean (pests and debris), Lubricate and Inspect | 25 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Motorized Swing Gates | Routine: Exercise , Clean (pests and debris), Lubricate and Inspect | 4 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Sanchez Canal Channel Manual Lift Gates | Routine: Open /Close gates to inspect for damage/ operation and remove any debris caught in bollards. | 10 ea | 26 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Salinity Canal Gates | Routine: Exercise, Inspect and Lubricate | 18 ea | 6 | $0 | $0.00 | |||||
| R&B | Sanchez Canal Bridge Inspection/ Certification | Routine: Inspect and Certify 125 foot Steel Bridge | 1 ea | 1 | $0 | $0.00 | |||||
| L&E | Maintenance SLU Boarder Lighting Circuit Panels | Routine: Inspect, clean and check for failed components , ie fuses, breakers and photocells | 253 ea | 6 | $0 | $0.00 | |||||
| Scheduled Totals: | $0.00 |
OPT Period 3 (YUM)
| Category | Opt PERIOD 3: YUM SCHEDULED MAINT [FFP] | Description of Service | Qty of Asset | Count of Events | Duration | Total Cost | Cost/Event | Labor ($) | *Equipment ($) | *Material ($) | ODC ($) |
| F&G | SLU/ BMGR Maintenance Motorized Sliding Gates | Routine: Excercise, Clean (pests and debris), Lubricate and Inspect | 25 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Motorized Swing Gates | Routine: Exercise , Clean (pests and debris), Lubricate and Inspect | 4 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Sanchez Canal Channel Manual Lift Gates | Routine: Open /Close gates to inspect for damage/ operation and remove any debris caught in bollards. | 10 ea | 26 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Salinity Canal Gates | Routine: Exercise, Inspect and Lubricate | 18 ea | 6 | $0 | $0.00 | |||||
| R&B | Sanchez Canal Bridge Inspection/ Certification | Routine: Inspect and Certify 125 foot Steel Bridge | 1 ea | 1 | $0 | $0.00 | |||||
| L&E | Maintenance SLU Boarder Lighting Circuit Panels | Routine: Inspect, clean and check for failed components , ie fuses, breakers and photocells | 253 ea | 6 | $0 | $0.00 | |||||
| Scheduled Totals: | $0.00 |
OPT Period 4 (YUM)
| Category | Opt PERIOD 3: YUM SCHEDULED MAINT [FFP] | Description of Service | Qty of Asset | Count of Events | Duration | Total Cost | Cost/Event | Labor ($) | *Equipment ($) | *Material ($) | ODC ($) |
| F&G | SLU/ BMGR Maintenance Motorized Sliding Gates | Routine: Excercise, Clean (pests and debris), Lubricate and Inspect | 25 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Motorized Swing Gates | Routine: Exercise , Clean (pests and debris), Lubricate and Inspect | 4 ea | 12 | $0 | $0.00 | |||||
| F&G | SLU Sanchez Canal Channel Manual Lift Gates | Routine: Open /Close gates to inspect for damage/ operation and remove any debris caught in bollards. | 10 ea | 26 | $0 | $0.00 | |||||
| F&G | SLU Maintenance Salinity Canal Gates | Routine: Exercise, Inspect and Lubricate | 18 ea | 6 | $0 | $0.00 | |||||
| R&B | Sanchez Canal Bridge Inspection/ Certification | Routine: Inspect and Certify 125 foot Steel Bridge | 1 ea | 1 | $0 | $0.00 | |||||
| L&E | Maintenance SLU Boarder Lighting Circuit Panels | Routine: Inspect, clean and check for failed components , ie fuses, breakers and photocells | 253 ea | 6 | $0 | $0.00 | |||||
| Scheduled Totals: | $0.00 |
File details come from the government source that posted it. Updated .