Atch 2 - Contractor Worksheet.xlsx
XLSX spreadsheet 24 KB Posted
- Solicitation number
- FA461324R0005
About this file
This document is a fillable Contractor Worksheet for Solicitation #FA461324R0005 for Active Vehicle Barrier Maintenance at F.E. Warren AFB, WY. The Contractor shall provide all personnel, labor, equipment, supplies, tools, materials, supervision, and other items and services necessary to provide regular periodic inspection, maintenance, and emergency repair for barriers at the Air Force base.
The worksheet includes pricing templates for the base year and four option years, covering full preventative maintenance and inspection, over and above routine and emergency service calls, and painting/corrosion control. The solicitation has a site visit request due by April 5, 2024, post-site visit questions due by April 11, 2024, and proposals due by April 26, 2024. The worksheet is one of six attachments to the solicitation, which also includes the Performance Work Statement, Mission Essential Contractor Service Plan, and Wage Determination.
View the file
Other files
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
Fillable
| Solicitation # FA461324R0005 | Active Vehicle Barrier Maintenance - Fillable Breakdown Sheet | |||
| **NOTICE: All hours listed in this sheet are estimates and do NOT guarantee actual service hours for each service year.** | ||||
| Base Year | ||||
| CLIN 0001/0004 - Full Preventative Maintenance and Inspection (FPMI) - Instructions: Please input the hourly wage rate in blocks C6-C7 for their respective Job Titles. This will automatically multiply against the estimated hours and populate the extended prices. The sum is calculated in E8 for total per barrier. | ||||
| Regular Hourly Wage | Regular Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 2.00 | $ - 0 |
| Engineer Technician II | 2.00 | $ - 0 |
| Total per Barrier | $ - 0 | |
| CLIN 0002 - Over and Above - Instructions: |
Routine: Please input the hourly wage rate in blocks C11-C12 for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee in C13.
Trip Fee: A firm fixed-price flat fee, for the cost of responding during business hours and diagnosis of the issue.
Emergency: Please input the hourly wage rate in blocks C16-C17 for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee in C18.
Trip Fee: A firm fixed-price flat fee, for the cost of responding outside of business hours and diagnosis of the issue.
| Routine Service Call Hourly Wage | |||
| (Respond within 72 hrs) | Routine Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 16.00 | $ - 0 | |||
| Engineer Technician II | 16.00 | $ - 0 | |||
| Trip Fee | 1 Visit | $ - 0 | |||
| Total per Barrier | $ - 0 | ||||
| Emergency Service Call Hourly Wage | |||||
| (Respond within 24 hrs) | Emergency Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 10.00 | $ - 0 | ||
| Engineer Technician II | 10.00 | $ - 0 | ||
| Trip Fee | 1 Visit | $ - 0 | ||
| Total per Barrier | $ - 0 | |||
| CLIN 0003 - Painting - Instructions: Please input the cost of labor and materials for all barriers per the task. | ||||
| Painting/Corrosion Control | ||||
| (Estimated Avg. Cost of Labor & Materials) | Category Total |
| Sandblast & Repaint of Ten (10) Barriers | |
| Total | $ - 0 |
| Option Year One (1) | ||||
| CLIN 1001 - FPMI - Instructions: Please input the hourly wage rate for their respective Job Titles. This will automatically multiply against the estimated hours and populate the extended prices. The sum is calculated for total per barrier. | ||||
| Regular Hourly Wage | Regular Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 2.00 | $ - 0 |
| Engineer Technician II | 2.00 | $ - 0 |
| Total per Barrier | $ - 0 | |
| CLIN 1002 - Over and Above - Instructions: |
Routine: Please input the hourly wage rate for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee.
Trip Fee: A firm fixed-price flat fee, for the cost of responding during business hours and diagnosis of the issue.
Emergency: Please input the hourly wage rate for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee.
Trip Fee: A firm fixed-price flat fee, for the cost of responding outside of business hours and diagnosis of the issue.
| Routine Service Call Hourly Wage | |||
| (Respond within 72 hrs) | Routine Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 16.00 | $ - 0 | |||
| Engineer Technician II | 16.00 | $ - 0 | |||
| Trip Fee | 1 Visit | $ - 0 | |||
| Total per Barrier | $ - 0 | ||||
| Emergency Service Call Hourly Wage | |||||
| (Respond within 24 hrs) | Emergency Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 10.00 | $ - 0 | ||
| Engineer Technician II | 10.00 | $ - 0 | ||
| Trip Fee | 1 Visit | $ - 0 | ||
| Total per Barrier | $ - 0 | |||
| CLIN 1003 - Painting - Instructions: Please input the cost of labor and materials for all barriers per the task. | ||||
| Painting/Corrosion Control | ||||
| (Estimated Avg. Cost of Labor & Materials) | Category Total |
| Repaint of Ten (10) Barriers | $ - 0 |
| Total | $ - 0 |
| Option Year Two (2) | ||||
| CLIN 2001 - FPMI - Instructions: Please input the hourly wage rate for their respective Job Titles. This will automatically multiply against the estimated hours and populate the extended prices. The sum is calculated for total per barrier. | ||||
| Regular Hourly Wage | Regular Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 2.00 | $ - 0 |
| Engineer Technician II | 2.00 | $ - 0 |
| Total per Barrier | $ - 0 | |
| CLIN 2002 - Over and Above - Instructions: |
Routine: Please input the hourly wage rate for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee.
Trip Fee: A firm fixed-price flat fee, for the cost of responding during business hours.
Emergency: Please input the hourly wage rate for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee.
Trip Fee: A firm fixed-price flat fee, for the cost of responding outside of business hours.
| Routine Service Call Hourly Wage | |||
| (Respond within 72 hrs) | Routine Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 16.00 | $ - 0 | |||
| Engineer Technician II | 16.00 | $ - 0 | |||
| Trip Fee | 1 Visit | $ - 0 | |||
| Total per Barrier | $ - 0 | ||||
| Emergency Service Call Hourly Wage | |||||
| (Respond within 24 hrs) | Emergency Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 10.00 | $ - 0 |
| Engineer Technician II | 10.00 | $ - 0 |
| Trip Fee | 1 Visit | $ - 0 |
| Total per Barrier | $ - 0 | |
| CLIN 2003 - Painting - Instructions: Please input the total cost of labor and materials for 10 barriers. |
| Painting/Corrosion Control | ||
| (Estimated Avg. Cost of Labor & Materials) | Category Total |
| Repaint of Ten (10) Barriers | $ - 0 |
| Total | $ - 0 |
| Option Year Three (3) | ||||
| CLIN 3001 - FPMI - Instructions: Please input the hourly wage rate for their respective Job Titles. This will automatically multiply against the estimated hours and populate the extended prices. The sum is calculated for total per barrier. | ||||
| Regular Hourly Wage | Regular Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 2.00 | $ - 0 |
| Engineer Technician II | 2.00 | $ - 0 |
| Total per Barrier | $ - 0 | |
| CLIN 3002 - Over and Above - Instructions: |
Routine: Please input the hourly wage rate for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee.
Trip Fee: A firm fixed-price flat fee, for the cost of responding during business hours and diagnosis of the issue.
Emergency: Please input the hourly wage rate for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee.
Trip Fee: A firm fixed-price flat fee, for the cost of responding outside of business hours and diagnosis of the issue.
| Routine Service Call Hourly Wage | |||
| (Respond within 72 hrs) | Routine Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 16.00 | $ - 0 | |||
| Engineer Technician II | 16.00 | $ - 0 | |||
| Trip Fee | 1 Visit | $ - 0 | |||
| Total per Barrier | $ - 0 | ||||
| Emergency Service Call Hourly Wage | |||||
| (Respond within 24 hrs) | Emergency Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 10.00 | $ - 0 |
| Engineer Technician II | 10.00 | $ - 0 |
| Trip Fee | 1 Visit | $ - 0 |
| Total per Barrier | $ - 0 | |
| CLIN 3003 - Painting - Instructions: Please input the total cost of labor and materials for 10 barriers. |
| Painting/Corrosion Control | ||
| (Estimated Avg. Cost of Labor & Materials) | Category Total |
| Repaint of Ten (10) Barriers | $ - 0 | |||
| Total | $ - 0 | |||
| Option Year Four (4) | ||||
| CLIN 4001 - FPMI - Instructions: Please input the hourly wage rate for their respective Job Titles. This will automatically multiply against the estimated hours and populate the extended prices. The sum is calculated for total per barrier. | ||||
| Regular Hourly Wage | Regular Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 2.00 | $ - 0 |
| Engineer Technician II | 2.00 | $ - 0 |
| Total per Barrier | $ - 0 | |
| CLIN 4002 - Over and Above - Instructions: |
Routine: Please input the hourly wage rate for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee.
Trip Fee: A firm fixed-price flat fee, for the cost of responding during business hours and diagnosis of the issue.
Emergency: Please input the hourly wage rate for their respective Job Titles. This will automatically populate the the extended prices. Next, input the Trip Fee.
Trip Fee: A firm fixed-price flat fee, for the cost of responding outside of business hours and diagnosis of the issue.
| Routine Service Call Hourly Wage | |||
| (Respond within 72 hrs) | Routine Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 16.00 | $ - 0 | |||
| Engineer Technician II | 16.00 | $ - 0 | |||
| Trip Fee | 1 Visit | $ - 0 | |||
| Total per Barrier | $ - 0 | ||||
| Emergency Service Call Hourly Wage | |||||
| (Respond within 24 hrs) | Emergency Hourly Wage | Estimated Avg. Hours (per Barrier) | Category Total |
(per Barrier)
| Engineer Technician Lead III | 10.00 | $ - 0 |
| Engineer Technician II | 10.00 | $ - 0 |
| Trip Fee | 1 Visit | $ - 0 |
| Total per Barrier | $ - 0 | |
| CLIN 4003 - Painting - Instructions: Please input the total cost of labor and materials for 10 barriers. |
| Painting/Corrosion Control | ||
| (Estimated Avg. Cost of Labor & Materials) | Category Total |
| Repaint of Ten (10) Barriers | $ - 0 |
| Total | $ - 0 |
| **Notice: All CLIN totals in Option Year Four will be used to populate the six (6) Month Extension on the next sheet. The 6 Month Extension is not a guaranteed option, but will still be considered in the Total Evaluated Price calculation.** |
BY+4OY+6Mo
| Active Vehicle Barrier (AVB) Maintenance (MX) CLIN Structure | ||||||
| **Please do not change any inputs. All items will populate from inputs on "Fillable" sheet.** | ||||||
| Year | CLIN | Description | Quantity | Unit Type | Unit Price | Extended Price |
| Base Year | 0001 | Preventative Maintenance (10 Barriers) | 3 | Month | $ - 0 | $ - 0 |
| 0002 | Over and Above | 1 | Job | $ - 0 | $ - 0 | |
| 0003 | Sandblast and Repaint (10 Barriers) | 1 | Job | $ - 0 | $ - 0 | |
| 0004 | Preventative Maintenance (7 Barriers) | 3 | Month | $ - 0 | $ - 0 | |
| Base Year Total | $ - 0 | |||||
| Option Year One | 1001 | Preventative Maintenance (10 Barriers) | 6 | Month | $ - 0 | $ - 0 |
| 1002 | Over and Above | 1 | Job | $ - 0 | $ - 0 | |
| 1003 | Repaint (10 Barriers) | 1 | Job | $ - 0 | $ - 0 | |
| Option Year One Total | $ - 0 | |||||
| Option Year Two | 2001 | Preventative Maintenance (10 Barriers) | 6 | Month | $ - 0 | $ - 0 |
| 2002 | Over and Above | 1 | Job | $ - 0 | $ - 0 | |
| 2003 | Repaint (10 Barriers) | 1 | Job | $ - 0 | $ - 0 | |
| Option Year Two Total | $ - 0 | |||||
| Option Year Three | 3001 | Preventative Maintenance (10 Barriers) | 6 | Month | $ - 0 | $ - 0 |
| 3002 | Over and Above | 1 | Job | $ - 0 | $ - 0 | |
| 3003 | Repaint (10 Barriers) | 1 | Job | $ - 0 | $ - 0 | |
| Option Year Three Total | $ - 0 | |||||
| Option Year Four | 4001 | Preventative Maintenance (10 Barriers) | 6 | Month | $ - 0 | $ - 0 |
| 4002 | Over and Above | 1 | Job | $ - 0 | $ - 0 | |
| 4003 | Repaint (10 Barriers) | 1 | Job | $ - 0 | $ - 0 | |
| Option Year Four Total | $ - 0 | |||||
| Six (6) Month Extension | 5001 | Preventative Maintenance (10 Barriers) | 3 | Month | $ - 0 | |
| 5002 | Over and Above | 1 | Job | $ - 0 | ||
| 5003 | Repaint (10 Barriers) | 1 | Job | $ - 0 | ||
| Six (6) Month Extension Total |
(Base Year + 4 Option Year + 6 Month Extension) Total Evaluated Price $ - 0
File details come from the government source that posted it. Updated .