Attachment_01B_Levels_of_Performance_OFFEROR_COMPLETE.xlsx
XLSX spreadsheet 31 KB Posted
- Attached to
- OPERATION AND MAINTENANCE OF YDP, IDIQ
- Solicitation number
- 140R3026R0012
- Issued by
- Not on record
About this file
This is a Levels of Performance staffing matrix for an Operation and Maintenance (O&M) contract (140R3026R0012) with the Department of the Interior Bureau of Reclamation for the Young Dry Project (YDP) under an Indefinite Delivery/Indefinite Quantity (IDIQ) vehicle. The spreadsheet outlines proposed Full-Time Equivalent (FTE) staffing levels across 16 contract line items (CLINs) and three functional categories: Administration, Operations, and Maintenance.
The staffing model specifies FTE requirements for exempt-level positions (Contract Manager, QA & Safety Officer, Plant Superintendent, Finance/Personnel Administrator) and non-exempt roles across three primary operational areas. Administration personnel range from 7 to 10 FTEs per CLIN and include engineering technicians, drafters, data entry clerks, secretaries, and supply technicians. Operations staffing scales from 10 to 23 FTEs depending on the CLIN, comprising plant operators, shift leads, control board operators, and chemical operators. Maintenance personnel constitute the largest category, ranging from 9 to 33 FTEs, including electrical and instrumentation mechanics, instrument mechanics, machinery maintenance mechanics, millwrights, welders, HVAC technicians, and environmental technicians. The grand total FTE allocation spans from 26 personnel for CLIN 1 to a maximum of 65 FTEs for CLIN 3.2, with variations across CLINs reflecting different operational scope levels. All positions reference applicable Service Contract Act (SCA) occupation codes and wage classifications.
View the file
Other files
Show all 39
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
O&M FTE Data Entry
| 140R3026R0012 | ||||||||||||||||||
| Proposed Classification | SCA Occupation Code | SCA Title | ||||||||||||||||
| << enter SCA wage rate updates here>> | CLIN 1 | CLIN2.1 | CLIN 3.1 | CLIN3.2 | CLIN3.3 | CLIN3.4 | CLIN4.1 | CLIN 4.2 | CLIN4.3 | CLIN5.1 | CLIN5.2 | CLIN5.3 | CLIN5.4 | CLIN6.1 | CLIN6.2 | CLIN6.3 |
| Contract Manager | EXEMPT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| QA & Safety Officer | EXEMPT | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Safety Officer | EXEMPT | Safety Specialist | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |
| QA/QC Officer | EXEMPT | Quality Assurance Officer | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |
| Engineering Tech III | 30083 | Engineering Tech III/Drafter II | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Drafter III | 30063 | Drafter/CAD Operator III | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Maint Mgt Tech & Supply Technician | 01410 | Supply Technician | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Maintenance Mgt Tech (MAXIMO) | 14043 | Computer Operator III | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Supply Technician (PLANNER) | 01410 | Supply Technician | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Data Entry Clerk/Librarian | 01052 | Data Entry Operator II | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| SecretaryIII/Payroll Clerk | 01313 | Secretary III | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Finance/Personnel Administrator | EXEMPT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
ADMINISTRATION SUB TOTAL 7 8 9 10 10 10 10 10 10 9 10 10 10 10 10 10
| Plant Superintendent | EXEMPT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Foreman - Operations | 25210 | Water Treatment Plant Op. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Senior Plant Operator | 25210 | Water Treatment Plant Op. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Plant Operator - Relief | 25210 | Water Treatment Plant Op. | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Shift Lead Plant Operator | 25210 | Water Treatment Plant Op. | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 2 | 2 | 2 | 2 | 4 | 4 | 4 |
| Plant Operator | 25210 | Water Treatment Plant Op. | 4 | 4 | 4 | 4 | 4 | 4 | 8 | 8 | 8 | 4 | 4 | 4 | 4 | 8 | 8 | 8 |
| Control Board Operator | 25210 | Water Treatment Plant Op. | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 0 | 0 | 0 | 0 | 4 | 4 | 4 |
| Bulk Chemical Operator - Driver | 25210 | Water Treatment Plant Op. | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 2 | 3 |
| Research Technician (General Operator) | 25210 | Water Treatment Plant Op. | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
OPERATIONS SUB TOTAL 10 12 12 12 12 12 21 22 23 10 10 10 10 21 22 23
| Foreman - Electrical & Instrumentation | 23530 | Machinery Maintenance Mechanic - Electrical | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |
| Electrician | 23160 | Electrician Maintenance | 1 | 2 | 2 | 3 | 4 | 4 | 3 | 4 | 4 | 2 | 3 | 4 | 4 | 3 | 4 | 4 |
| GMW - Electrical | 23370 | General Maintenance Worker - Electrical | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Machinery Maintenance Mechanic- Electrical | 23530 | Machinery Maintenance Mechanic - Electrical | 0 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| Machinery Maintenance Mechanic- Instrument | 23530 | Machinery Maintenance Mechanic - Instrument | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Lead Instrument Mechanic | 23460 | Instrument Mechanic | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Instrument Mechanic | 23460 | Instrument Mechanic | 1 | 3 | 2 | 3 | 4 | 4 | 3 | 4 | 4 | 2 | 2 | 3 | 3 | 2 | 3 | 3 |
| GMW - Instrumentation | 23370 | General Maintenance Worker - Instrumentation | 0 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Foreman - Mechanical | 23530 | Machinery Maintenance Mechanic | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Machinery Maintenance Mechanic | 23530 | Machinery Maintenance Mechanic | 2 | 4 | 6 | 9 | 10 | 10 | 8 | 9 | 9 | 8 | 8 | 9 | 9 | 7 | 7 | 8 |
| GMW - Mechanical | 23370 | General Maintenance Worker Mechanical | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| Millwright | 23640 | Millwright | 0 | 1 | 2 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 2 | 3 | 3 | 2 | 3 | 3 |
| Welder | 23960 | Welder, Combination, Maintenance | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 2 |
| HVAC Tech | 23411 | HVAC Mechanic (Research Facility) | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Environmental Tech | 30090 | Environmental Tech | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
| Engineering Tech IV | 30084 | Engineering Tech IV | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
MAINTENANCE SUB TOTAL 9 18 22 28 32 33 28 32 32 23 26 30 31 26 29 30
HISTORICAL GRAND TOTAL 26 38 43 50 54 55 59 64 65 42 46 50 51 57 61 63
| Legend: |
| Currently above SCA |
| Exempt |
Sheet1
File details come from the government source that posted it. Updated .