Attachment 05_Average Labor Rate Sheet RFP_eCRAFT.xlsx

685 KB Posted

Attached to
APPLICATION ARSENAL (AA) ENTERPRISE ENGINEERING AND LIFECYCLE SUPPORT _*SEAPORT CONTRACT HOLDERS ONLY
Solicitation number
N6600126R3507
Issued by

About this file

Written by GovTribe AI ·

This is an Average Labor Rate Sheet template for the Application Arsenal (AA) Enterprise Engineering and Lifecycle Support RFP under the SEAPORT contract vehicle. The document is designed for SEAPORT contract holders to submit pricing information for personnel resources supporting full lifecycle systems engineering and software sustainment services for the Naval Information Warfare Center-Pacific (NIWC-PAC) Command and Control Systems Division, Code 53200.

The labor rate sheet serves as a pricing template requiring contractors to detail average labor rates by labor category and skill level for personnel who will perform engineering, software development, sustainment, and related technical support tasks. This document is essential for competitive evaluation of proposals, as it establishes the contractor's pricing structure for all labor resources required to execute the Statement of Work. The template enables the Government to compare labor cost proposals across competing SEAPORT contractors and assess the reasonableness of pricing for various workforce categories involved in the Application Arsenal platform's engineering and lifecycle support activities.

View the file

Other files

File Type Posted
Solicitation Amendment N6600126R35070002 SF 30.pdf PDF
Solicitation Amendment - N6600126R35070002 (conformed).pdf PDF
Solicitation Amendment - N6600126R35070001 (Conformed).pdf PDF
Exhibit A_Contract Data Requirements List (CDRL) Amend 0001.pdf PDF
Solicitation Amendment N6600126R35070001 SF 30.pdf PDF
Attachment 01_Statement of Work.pdf PDF
Attachment 02_Contract Security Classification Specification DD 254.pdf PDF
Attachment 03_Wage Determination 2015-5635 Amend 0001.pdf PDF
Attachment 04_Oral Presentation Guidelines Amend 0001.pdf PDF
Attachment 05_Average Labor Rate Sheet RFP_eCRAFT Amend 0001.xlsx XLSX spreadsheet
Attachment 06_Cost Proposal Format Amend 0001.xlsx XLSX spreadsheet
Attachment 02_Contract Security Classification Specification DD 254.pdf PDF
Solicitation - N6600126R3507.pdf PDF
Attachment 01_Statement of Work.pdf PDF
Attachment 03_Wage Determination 2015-5635.pdf PDF
Attachment 04_Oral Presentation Guidelines.docx DOCX document
Attachment 06_Cost Proposal Format.xlsx XLSX spreadsheet
Exhibit A_Contract Data Requirements List (CDRL).pdf PDF
Show all 18

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Tab 1 - Instructions Version: 03-28-2024 Average Labor Rate Sheet RFP Attachment

Step Instructions: The Prime Offeror shall complete and submit this table in MS Excel format. The prime's submission must cover both the prime and subcontractor proposed categories. The Prime Offeror shall complete and submit this excel workbook which includes the average proposed/bid rates (fully loaded) by labor category and work site/area combination per period of performance (PoP) (i.e., the base and each option period will have separate average rates by labor category and work site/area combinations). The average proposed/bid rates submitted combine both prime contractor and subcontractor labor rates by labor category and work site/area combination.

Note: Do not edit all fields. Fields that can be edited are white cells. All gray cells are auto-populated and non-editable except for those in “Tab 2 – POP Dates.” Red cells under "Tab 3 - INPUT" indicate an error with Labor Category and/or Work Site input. The workbook has embedded instructions that will detail what information is required for specific data fields.

1 Use the final solicitation and final proposed cost to fill in Tabs 2 and 3.

2On Tab 2 - enter the Start and End Dates for each Period of Performance (PoP) for the entire life of the contract. Ensure there are no gaps or overlaps between periods. If there is not multiple periods of performance, enter the Contract Start Date and Contract End Date under Period of Performance (PoP) # 1 only. Enter PoP data consistent with the solicitation details with regard to option period descriptions and time frames (e.g., Base period, Option Period 1, Option Period 2).
3On Tab 3 - Ensure only eCRAFT specific labor categories are specified as provided in the final conformed solicitation. Enter Labor Categories in column E either by copying data from final proposed cost spreadsheet, or selecting from cell drop-down arrow. When entering information into the spreadsheet, the Prime Offeror must enter a line item for each employee (both prime and subcontractor) addressed in the final proposed cost proposal.
4On Tab 3 - In column F, enter the Work Site for the corresponding Labor Category to indicate place of performance. Work Site must start with a G or K as follows:

- G: Should be selected when the contractor proposes to perform at a Government facility

- K: Should be selected when the contractor proposes to perform at their own facility

5On Tab 3 - In columns G and H, enter the Estimated Hours and Fully Loaded Labor Rate for each Labor Category/Work Site under PoP 1.
6On Tab 3 - Repeat Step 6, filling in Estimated Hours and Fully Loaded Labor Rate columns for each PoP referenced in Tab 2 as applicable to the final proposal (e.g., Columns J & K, M & N). Each Labor Category must have Estimated Hours and a Fully Loaded Labor Rate entered for at least one PoP. PoPs without estimated hours and a Fully Loaded Labor Rate will be highlighted in orange.
7On Tab 4 -Tab 4 is locked and will be automatically filled-in and calculated based on data entry inputs from Tab 2 and Tab 3. All labor categories with common work-sites are consolidated automatically to create a weighted average in “Tab 4 – UPLOAD.” Verify data populated into Tabs 4 accurately.
8Save this file and submit with the final cost proposal as instructed in the solicitation.
HOW TO PASTE VALUES ------>
1. Select down arrow from PASTE menu
2. Select the first option from the PASTE VALUES section

Tab 2 - POP Dates

POP #Start DateEnd DateDescription
1WarningStart dates highlighted in red don't have a start date immediately after the previous POP's End Date (i.e., gap in dates).

End dates highlighted in red have an end date before the POP Start Date of their respective period.

2
3
4
5
6
7
8
9
10

Tab 3 - INPUT

Master List of E2 Labor Categories and Codes Listing (for reference only)This column will auto-fill based on the selected labor category (for reference only)INPUT INFORMATION HERE (STARTING ON ROW 6)INPUT INFORMATION HEREINPUT INFORMATION HEREINPUT INFORMATION HERE (STARTING ON ROW 6)INPUT INFORMATION HERE (STARTING ON ROW 6)INPUT INFORMATION HERE (STARTING ON ROW 6)INPUT INFORMATION HERE (STARTING ON ROW 6)INPUT INFORMATION HERE (STARTING ON ROW 6)INPUT INFORMATION HERE (STARTING ON ROW 6)INPUT INFORMATION HERE (STARTING ON ROW 6)INPUT INFORMATION HERE (STARTING ON ROW 6)
Labor categories can be selected from the drop down, typed, or pasted in this column. Note that the Labor Category Names must match exactly as the master list names (Column B) or they will not upload properly.Enter the Work Site for each Labor Category here. Each location must start with either a "G" for Government or "K" for Contractor.Enter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this columnEnter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this columnEnter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this columnEnter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this columnEnter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this columnEnter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this columnEnter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this columnEnter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this columnEnter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this columnEnter the estimated hours for each Labor Category in this columnEnter the fully loaded labor rate (defined as direct labor plus all applicable indirects plus fixed fee) for each Labor Category in this column
POP 1 Dates:POP 2 Dates:POP 3 Dates:POP 4 Dates:POP 5 Dates:POP 6 Dates:POP 7 Dates:POP 8 Dates:POP 9 Dates:POP 10 Dates:
Red highlighted cells are Labor Categories not included in the Master List, and cannot be used.Red highlighted cells are unapproved Work Sites and cannot be used. Work Site must start with G or K.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.Orange highlighted cells indicate POPs where the estimated hours and the fully loaded labor rate have been left blank. If hours/fully loaded labor rate have been entered for another POP fields can be left blank.
CodeLabor CategoryLabor Category CodeLabor CategoryWork SitePOP 1 Estimated HoursPOP 1 Fully Loaded Labor RatePOP 2 Estimated HoursPOP 2 Fully Loaded Labor RatePOP 3 Estimated HoursPOP 3 Fully Loaded Labor RatePOP 4 Estimated HoursPOP 4 Fully Loaded Labor RatePOP 5 Estimated HoursPOP 5 Fully Loaded Labor RatePOP 6 Estimated HoursPOP 6 Fully Loaded Labor RatePOP 7 Estimated HoursPOP 7 Fully Loaded Labor RatePOP 8 Estimated HoursPOP 8 Fully Loaded Labor RatePOP 9 Estimated HoursPOP 9 Fully Loaded Labor RatePOP 10 Estimated HoursPOP 10 Fully Loaded Labor Rate
ACE1ACQUISITION COST ESTIMATOR I
ACE2ACQUISITION COST ESTIMATOR II
ACE3ACQUISITION COST ESTIMATOR III
AMS1ACQUISITION MANAGEMENT SUPPORT I
AMS2ACQUISITION MANAGEMENT SUPPORT II
AMS3ACQUISITION MANAGEMENT SUPPORT III
ANFSANALYST, FINANCIAL SYSTEMS I
ANFS2ANALYST, FINANCIAL SYSTEMS II
ANFS3ANALYST, FINANCIAL SYSTEMS III
ANFS4ANALYST, FINANCIAL SYSTEMS IV
ANM1ANALYST, MANAGEMENT I
ANM2ANALYST, MANAGEMENT II
ANM3ANALYST, MANAGEMENT III
ANP1ANALYST, OPERATIONS I
ANP2ANALYST, OPERATIONS II
ANP3ANALYST, OPERATIONS III
AVAAUDIO VISUAL ANIMATOR
AVDP1AUDIO VISUAL DIRECTOR / PRODUCER I
AVDP2AUDIO VISUAL DIRECTOR / PRODUCER II
AVSWAUDIO VISUAL SCRIPT WRITER
BOBOAT OPERATOR
CHEM1CHEMIST I
CHEM2CHEMIST II
CHEM3CHEMIST III
CMA1CONTRACTS MANAGEMENT ANALYST I
CMA2CONTRACTS MANAGEMENT ANALYST II
CMA3CONTRACTS MANAGEMENT ANALYST III
CNSLRCOUNSELOR
CSE1CYBERSECURITY ENGINEER I
CSE2CYBERSECURITY ENGINEER II
CSE3CYBERSECURITY ENGINEER III
DMA1DATABASE MANAGEMENT ANALYST I
DMA2DATABASE MANAGEMENT ANALYST II
DMA3DATABASE MANAGEMENT ANALYST III
DSC1DATA SCIENTIST I
DSC2DATA SCIENTIST II
DSC3DATA SCIENTIST III
E1ENGINEER I
E2ENGINEER II
E3ENGINEER III
E4ENGINEER IV
EA1ENGINEER, ACOUSTICAL I
EA2ENGINEER, ACOUSTICAL II
EA3ENGINEER, ACOUSTICAL III
EA4ENGINEER, ACOUSTICAL IV
EC1ENGINEER, COMPUTER I
EC2ENGINEER, COMPUTER II
EC3ENGINEER, COMPUTER III
EC4ENGINEER, COMPUTER IV
ED1ENGINEER, DESIGN I
ED2ENGINEER, DESIGN II
ED3ENGINEER, DESIGN III
ED4ENGINEER, DESIGN IV
EE1ENGINEER, ELECTRICAL/ELECTRONICS I
EE2ENGINEER, ELECTRICAL/ELECTRONICS II
EE3ENGINEER, ELECTRICAL/ELECTRONICS III
EE4ENGINEER, ELECTRICAL/ELECTRONICS IV
EHSI1ENGINEER, HUMAN SYSTEM INTEGRATION I
EHSI2ENGINEER, HUMAN SYSTEM INTEGRATION II
EHSI3ENGINEER, HUMAN SYSTEM INTEGRATION III
EHSI4ENGINEER, HUMAN SYSTEM INTEGRATION IV
EHSI5ENGINEER, HUMAN SYSTEM INTEGRATION V
EM1ENGINEER, MECHANICAL I
EM2ENGINEER, MECHANICAL II
EM3ENGINEER, MECHANICAL III
EM4ENGINEER, MECHANICAL IV
EPEVENT PLANNER
EST1ENGINEER, STRUCTURAL I
EST2ENGINEER, STRUCTURAL II
EST3ENGINEER, STRUCTURAL III
EST4ENGINEER, STRUCTURAL IV
ESY1ENGINEER, SYSTEMS I
ESY2ENGINEER, SYSTEMS II
ESY3ENGINEER, SYSTEMS III
ESY4ENGINEER, SYSTEMS IV
FMFITNESS MANAGER
FQNV1FULLY QUALIFIED NAVY VALIDATOR I
FQNV2FULLY QUALIFIED NAVY VALIDATOR II
FQNV3FULLY QUALIFIED NAVY VALIDATOR III
FQNV4FULLY QUALIFIED NAVY VALIDATOR IV
FWFIRE WARDEN
HWHHAZARDOUS WASTE/MATERIAL HANDLER
ILNV1INTERMEDIATE LEVEL NAVY VALIDATOR I
ILNV2INTERMEDIATE LEVEL NAVY VALIDATOR II
ILNV3INTERMEDIATE LEVEL NAVY VALIDATOR III
ILNV4INTERMEDIATE LEVEL NAVY VALIDATOR IV
IMS1INTEGRATED MASTER SCHEDULER I
IMS2INTEGRATED MASTER SCHEDULER II
IMS3INTEGRATED MASTER SCHEDULER III
INS1INSTALLATION ANALYST I
INS2INSTALLATION ANALYST II
INS3INSTALLATION ANALYST III
INT1INTELLIGENCE SPECIALIST I
INT2INTELLIGENCE SPECIALIST II
INT3INTELLIGENCE SPECIALIST III
ISSM1INFORMATION SYSTEM SECURITY MANAGER I
ISSM2INFORMATION SYSTEM SECURITY MANAGER II
ISSM3INFORMATION SYSTEM SECURITY MANAGER III
LGT1LOGISTICIAN I
LGT2LOGISTICIAN II
LGT3LOGISTICIAN III
LGT4LOGISTICIAN IV
MANA1MANAGER, ADMINISTRATIVE I
MANA2MANAGER, ADMINISTRATIVE II
MANA3MANAGER, ADMINISTRATIVE III
MANA4MANAGER, ADMINISTRATIVE IV
MANO1MANAGER, OPERATIONS I
MANO2MANAGER, OPERATIONS II
MANO3MANAGER, OPERATIONS III
MANO4MANAGER, OPERATIONS IV
MANP1MANAGER, PROGRAM/PROJECT I
MANP2MANAGER, PROGRAM/PROJECT II
MANP3MANAGER, PROGRAM/PROJECT III
MATH1MATHEMATICIAN I
MATH2MATHEMATICIAN II
MATH3MATHEMATICIAN III
MBS1MODEL BASED SYSTEMS ENGINEER I
MBS2MODEL BASED SYSTEMS ENGINEER II
MBS3MODEL BASED SYSTEMS ENGINEER III
MRSMARINE SURVEYOR
NARNAVAL ARCHITECT
OS1OPERATIONS SUPPORT I
OS2OPERATIONS SUPPORT II
OS3OPERATIONS SUPPORT III
OS4OPERATIONS SUPPORT IV
QAOR1QA OVERSIGHT REPRESENTATIVE I
QAOR2QA OVERSIGHT REPRESENTATIVE II
RFE1RADIO FREQUENCY ENGINEER I
RFE2RADIO FREQUENCY ENGINEER II
RFE3RADIO FREQUENCY ENGINEER III
S1SCIENTIST I
S2SCIENTIST II
S3SCIENTIST III
SA1SYSTEMS ADMINISTRATOR I
SA2SYSTEMS ADMINISTRATOR II
SA3SYSTEMS ADMINISTRATOR III
SA4SYSTEMS ADMINISTRATOR IV
SCC1SPECIALIST, CORROSION CONTROL I
SCC2SPECIALIST, CORROSION CONTROL II
SCC3SPECIALIST, CORROSION CONTROL III
SCECOST ESTIMATOR
SCM1SPECIALIST, CONFIGURATION MANAGEMENT I
SCM2SPECIALIST, CONFIGURATION MANAGEMENT II
SCM3SPECIALIST, CONFIGURATION MANAGEMENT III
SEG1SOFTWARE ENGINEER I
SEG2SOFTWARE ENGINEER II
SEG3SOFTWARE ENGINEER III
SEMSPECIALIST, EMERGENCY MANAGEMENT
SIAC1SPECIALIST, IA COMPLIANCE I
SIAC2SPECIALIST, IA COMPLIANCE II
SIAC3SPECIALIST, IA COMPLIANCE III
SISS1SPECIALIST, INFORMATION SYSTEM SECURITY I
SISS2SPECIALIST, INFORMATION SYSTEM SECURITY II
SISS3SPECIALIST, INFORMATION SYSTEM SECURITY III
SPASPECIALIST, PUBLIC AFFAIRS I
SPA2SPECIALIST, PUBLIC AFFAIRS II
SPA3SPECIALIST, PUBLIC AFFAIRS III
SPDSUBSAFE PROGRAM DIRECTOR
SPM1SECURITY PROGRAM MANAGER I
SPM2SECURITY PROGRAM MANAGER II
SPM3SECURITY PROGRAM MANAGER III
SQC1SPECIALIST, QUALITY CONTROL I
SQC2SPECIALIST, QUALITY CONTROL II
SQC3SPECIALIST, QUALITY CONTROL III
SQC4SPECIALIST, QUALITY CONTROL IV
SS1SPECIALIST, SECURITY I
SS2SPECIALIST, SECURITY II
SS3SPECIALIST, SECURITY III
ST1SPECIALIST, TRAINING I
ST2SPECIALIST, TRAINING II
ST3SPECIALIST, TRAINING III
STUSTUDENT
TECWTECHNICAL WRITER, SUPERVISORY
TES1TECHNICAL EDITOR, SUPERVISORY I
TES2TECHNICAL EDITOR, SUPERVISORY II
TES3TECHNICAL EDITOR, SUPERVISORY III
WDD1WEB AND DIGITAL INTERFACE DESIGNER I
WDD2WEB AND DIGITAL INTERFACE DESIGNER II
WDD3WEB AND DIGITAL INTERFACE DESIGNER III
01011ACCOUNTING CLERK I
01012ACCOUNTING CLERK II
01013ACCOUNTING CLERK III
01020ADMINISTRATIVE ASSISTANT
01030COLLECTION SPECIALIST
01035COURT REPORTER
01041CUSTOMER SERVICE REPRESENTATIVE I
01042CUSTOMER SERVICE REPRESENTATIVE II
01043CUSTOMER SERVICE REPRESENTATIVE III
01051DATA ENTRY OPERATOR I
01052DATA ENTRY OPERATOR II
01060DISPATCHER, MOTOR VEHICLE (MOTOR VEHICLE UTILIZATION ASSISTANT)
01070DOCUMENT PREPARATION CLERK (DOCUMENT PREPARER)
01090DUPLICATING MACHINE OPERATOR (PHOTOCOPY MACHINE OPERATOR; REPRODUCTION WORKER)
01111GENERAL CLERK I
01112GENERAL CLERK II
01113GENERAL CLERK III
01120HOUSING REFERRAL ASSISTANT
01141MESSENGER COURIER
01191ORDER CLERK I
01192ORDER CLERK II
01261PERSONNEL ASSISTANT (EMPLOYMENT) I
01262PERSONNEL ASSISTANT (EMPLOYMENT) II
01263PERSONNEL ASSISTANT (EMPLOYMENT) III
01270PRODUCTION CONTROL CLERK
01290RENTAL CLERK
01300SCHEDULER, MAINTENANCE
01311SECRETARY I
01312SECRETARY II
01313SECRETARY III
01320SERVICE ORDER DISPATCHER
01410SUPPLY TECHNICIAN
01420SURVEY WORKER (INTERVIEWER)
01460SWITCHBOARD OPERATOR/RECEPTIONIST
01531TRAVEL CLERK I
01532TRAVEL CLERK II
01533TRAVEL CLERK III
01611WORD PROCESSOR I
01612WORD PROCESSOR II
01613WORD PROCESSOR III
05005AUTOMOBILE BODY REPAIRER, FIBERGLASS
05010AUTOMOTIVE ELECTRICIAN
05040AUTOMOTIVE GLASS INSTALLER (AUTO GLASS WORKER)
05070AUTOMOTIVE WORKER
05110MOBILE EQUIPMENT SERVICER
05130MOTOR EQUIPMENT METAL MECHANIC (MOTOR VEHICLE BODY REPAIRER)
05160MOTOR EQUIPMENT METAL WORKER
05190MOTOR VEHICLE MECHANIC
05220MOTOR VEHICLE MECHANIC HELPER
05250MOTOR VEHICLE UPHOLSTERY WORKER
05280MOTOR VEHICLE WRECKER (TOW TRUCK OPERATOR; WRECKER OPERATOR)
05310PAINTER, AUTOMOTIVE
05340RADIATOR REPAIR SPECIALIST
05370TIRE REPAIRER
05400TRANSMISSION REPAIR SPECIALIST
06500RETAIL AUTOMOTIVE DETAILER
06510RETAIL AUTOMOTIVE HELPER
06520RETAIL AUTOMOTIVE TECHNICIAN
06530RETAIL LUBRICATION TECHNICIAN
06540RETAIL TIRE SERVICE WORKER
06550SENIOR RETAIL AUTOMOTIVE TECHNICIAN
07010BAKER
07041COOK I
07042COOK II
07070DISHWASHER
07080FAST FOOD SHIFT LEADER (CREW CHIEF, TEAM LEADER)
07090FAST FOOD WORKER (CREW PERSON, TEAM MEMBER, ASSOCIATE)
07130FOOD SERVICE WORKER (CAFETERIA WORKER)
07210MEAT CUTTER
07260WAITER/WAITRESS
08010BRUSH/PRECOMMERCIAL THINNER
08040CHOKER SETTER
08070FALLER/BUCKER
08100FIRE LOOKOUT
08130FORESTRY EQUIPMENT OPERATOR (INCLUDES TRACTOR OPERATOR, PLANTING; TRACTOR OPERATOR, SITE PREPARATION; AND TRACTOR OPERATOR, THINNING
08160FORESTRY/LOGGING HEAVY EQUIPMENT OPERATOR (LOADER OPERATOR, SKIDDER OPERATOR)
08190FORESTRY TECHNICIAN
08200FORESTRY TRUCK DRIVER
08250GENERAL FORESTRY LABORER
08280NURSERY SPECIALIST
08310SLASH PILER/BURNER
08340TREE CLIMBER
08370TREE PLANTER
08400TREE PLANTER, MECHANICAL
09010ELECTROSTATIC SPRAY PAINTER
09040FURNITURE HANDLER
09080FURNITURE REFINISHER
09090FURNITURE REFINISHER HELPER
09110FURNITURE REPAIRER, MINOR
09130UPHOLSTERER
11030CLEANER, VEHICLES
11060ELEVATOR OPERATOR
11090GARDENER
11122HOUSEKEEPING AIDE
11150JANITOR
11210LABORER, GROUNDS MAINTENANCE
11240MAID OR HOUSEMAN
11260PRUNER
11270TRACTOR OPERATOR
11330TRAIL MAINTENANCE WORKER
11360WINDOW CLEANER
12010AMBULANCE DRIVER
12011BREATH ALCOHOL TECHNICIAN (BAT)
12012CERTIFIED OCCUPATIONAL THERAPIST ASSISTANT
12015CERTIFIED PHYSICAL THERAPIST ASSISTANT
12020DENTAL ASSISTANT
12025DENTAL HYGIENIST
12030EKG TECHNICIAN
12035ELECTRONEURODIAGNOSTIC TECHNOLOGIST
12040EMERGENCY MEDICAL TECHNICIAN (EMT)
12071LICENSED PRACTICAL NURSE I
12072LICENSED PRACTICAL NURSE II
12073LICENSED PRACTICAL NURSE III
12100MEDICAL ASSISTANT
12130MEDICAL LABORATORY TECHNICIAN (CLINICAL LABORATORY ASSISTANT; REGISTERED MEDICAL TECHNICIAN)
12160MEDICAL RECORD CLERK
12190MEDICAL RECORD TECHNICIAN (MEDICAL RECORD ADMINISTRATOR)
12195MEDICAL TRANSCRIPTIONIST
12210NUCLEAR MEDICINE TECHNOLOGIST
12221NURSING ASSISTANT I
12222NURSING ASSISTANT II
12223NURSING ASSISTANT III
12224NURSING ASSISTANT IV
12235OPTICAL DISPENSER
12236OPTICAL TECHNICIAN
12250PHARMACY TECHNICIAN
12280PHLEBOTOMIST
12305RADIOLOGIC TECHNOLOGIST
12311REGISTERED NURSE I
12312REGISTERED NURSE II
12313REGISTERED NURSE II, SPECIALIST
12314REGISTERED NURSE III
12315REGISTERED NURSE III, ANESTHETIST
12316REGISTERED NURSE IV
12317SCHEDULER (DRUG AND ALCOHOL TESTING)
12320SUBSTANCE ABUSE TREATMENT COUNSELOR
13011EXHIBITS SPECIALIST I
13012EXHIBITS SPECIALIST II
13013EXHIBITS SPECIALIST III
13041ILLUSTRATOR I
13042ILLUSTRATOR II
13043ILLUSTRATOR III
13047LIBRARIAN
13050LIBRARY AIDE/CLERK
13054LIBRARY INFORMATION TECHNOLOGY SYSTEMS ADMINISTRATOR
13058LIBRARY TECHNICIAN
13061MEDIA SPECIALIST I
13062MEDIA SPECIALIST II
13063MEDIA SPECIALIST III
13071PHOTOGRAPHER I
13072PHOTOGRAPHER II
13073PHOTOGRAPHER III
13074PHOTOGRAPHER IV
13075PHOTOGRAPHER V
13090TECHNICAL ORDER LIBRARY CLERK
13110VIDEO TELECONFERENCE TECHNICIAN
14041COMPUTER OPERATOR I
14042COMPUTER OPERATOR II
14043COMPUTER OPERATOR III
14044COMPUTER OPERATOR IV
14045COMPUTER OPERATOR V
14071COMPUTER PROGRAMMER I
14072COMPUTER PROGRAMMER II
14073COMPUTER PROGRAMMER III
14074COMPUTER PROGRAMMER IV
14101COMPUTER SYSTEMS ANALYST I
14102COMPUTER SYSTEMS ANALYST II
14103COMPUTER SYSTEMS ANALYST III
14150PERIPHERAL EQUIPMENT OPERATOR
14160PERSONAL COMPUTER SUPPORT TECHNICIAN
14170SYSTEM SUPPORT SPECIALIST
15010AIRCREW TRAINING DEVICES INSTRUCTOR (NON-RATED)
15020AIRCREW TRAINING DEVICES INSTRUCTOR (RATED)
15030AIRCREW TRAINING DEVICES INSTRUCTOR (PILOT)
15050COMPUTER BASED TRAINING SPECIALIST / INSTRUCTOR
15060EDUCATIONAL TECHNOLOGIST
15070FLIGHT INSTRUCTOR (PILOT)
15080GRAPHIC ARTIST
15085MAINTENANCE TEST PILOT FIXED WING.JET/PROP
15086MAINTENANCE TEST PILOT ROTOARY WING
15087NON-MAINTENANCE TEST PILOT/CO-PILOT
15090TECHNICAL INSTRUCTOR
15095TECHNICAL INSTRUCTOR/COURSE DEVELOPER
15110TEST PROCTOR
15120TUTOR
16010ASSEMBLER
16030COUNTER ATTENDANT (SERVICE ESTABLISHMENT ATTENDANT)
16040DRY CLEANER
16070FINISHER, FLATWORK, MACHINE
16090PRESSER, HAND
16110PRESSER, MACHINE, DRYCLEANING
16130PRESSER, MACHINE, SHIRTS
16160PRESSER, MACHINE, WEARING APPAREL, LAUNDRY
16190SEWING MACHINE OPERATOR
16220TAILOR
16250WASHER, MACHINE (WASHMAN)
19010MACHINE-TOOL OPERATOR (TOOL ROOM)
19040TOOL AND DIE MAKER
21020FORKLIFT OPERATOR
21030MATERIAL COORDINATOR
21040MATERIAL EXPEDITER
21050MATERIAL HANDLING LABORER
21071ORDER FILLER
21080PRODUCTION LINE WORKER (FOOD PROCESSING)
21110SHIPPING PACKER
21130SHIPPING/RECEIVING CLERK
21140STORE WORKER I
21150STOCK CLERK (SHELF STOCKER; STORE WORKER II)
21210TOOLS AND PARTS ATTENDANT (TOOL CRIB ATTENDANT)
21410WAREHOUSE SPECIALIST (WAREHOUSE WORKER)
23010AEROSPACE STRUCTURAL WELDER
23019AIRCRAFT LOGS AND RECORDS TECHNICIAN
23021AIRCRAFT MECHANIC I
23022AIRCRAFT MECHANIC II
23023AIRCRAFT MECHANIC III
23040AIRCRAFT MECHANIC HELPER (AIRFRAME AND POWER PLANT MECHANIC HELPER)
23050AIRCRAFT, PAINTER
23060AIRCRAFT SERVICER (AIRPORT UTILITY WORKER)
23070AIRCRAFT SURVIVAL FLIGHT EQUIPMENT TECHNICIAN
23080AIRCRAFT WORKER
23091AIRCREW LIFE SUPPORT EQUIPMENT (ALSE) MECHANIC I
23092AIRCREW LIFE SUPPORT EQUIPMENT (ALSE) MECHANIC II
23110APPLIANCE MECHANIC
23120BICYCLE REPAIRER
23125CABLE SPLICER
23130CARPENTER, MAINTENANCE
23140CARPET LAYER
23160ELECTRICIAN, MAINTENANCE
23181ELECTRONICS TECHNICIAN MAINTENANCE I
23182ELECTRONICS TECHNICIAN MAINTENANCE II
23183ELECTRONICS TECHNICIAN MAINTENANCE III
23210ELEVATOR REPAIRER
23220ELEVATOR REPAIRER HELPER
23260FABRIC WORKER
23290FIRE ALARM SYSTEM MECHANIC
23310FIRE EXTINGUISHER REPAIRER
23311FUEL DISTRIBUTION SYSTEM MECHANIC
23312FUEL DISTRIBUTION SYSTEM OPERATOR
23370GENERAL MAINTENANCE WORKER
23380GROUND SUPPORT EQUIPMENT MECHANIC
23381GROUND SUPPORT EQUIPMENT SERVICER
23382GROUND SUPPORT EQUIPMENT WORKER
23391GUNSMITH I
23392GUNSMITH II
23393GUNSMITH III
23410HEATING, VENTILATION AND AIR-CONDITIONING MECHANIC
23411HEATING, VENTILATION AND AIR-CONDITIONING MECHANIC (RESEARCH FACILITY)
23430HEAVY EQUIPMENT MECHANIC
23440HEAVY EQUIPMENT OPERATOR
23460INSTRUMENT MECHANIC
23465LABORATORY/SHELTER MECHANIC
23470LABORER
23510LOCKSMITH
23530MACHINERY MAINTENANCE MECHANIC
23550MACHINIST, MAINTENANCE
23580MAINTENANCE TRADES HELPER
23591METROLOGY TECHNICIAN I
23592METROLOGY TECHNICIAN II
23593METROLOGY TECHNICIAN III
23640MILLWRIGHT
23710OFFICE APPLIANCE REPAIRER
23760PAINTER, MAINTENANCE
23790PIPEFITTER, MAINTENANCE
23810PLUMBER, MAINTENANCE
23820PNEUDRAULIC SYSTEMS MECHANIC
23850RIGGER
23870SCALE MECHANIC
23890SHEET-METAL WORKER, MAINTENANCE
23910SMALL ENGINE MECHANIC
23931TELECOMMUNICATIONS MECHANIC I
23932TELECOMMUNICATIONS MECHANIC II
23950TELEPHONE LINEMAN
23960WELDER, COMBINATION, MAINTENANCE
23965WELL DRILLER
23970WOODCRAFT WORKER
23980WOODWORKER
24510BARBER
24540BEAUTICIAN (COSMETOLOGIST)
24550CASE MANAGER
24570CHILD CARE ATTENDANT
24580CHILD CARE CENTER CLERK
24610CHORE AIDE
24620FAMILY READINESS AND SUPPORT SERVICES COORDINATOR
24630HOMEMAKER
24710NAIL TECHNICIAN
25010BOILER TENDER
25020BRIDGE TENDER
25040SEWAGE PLANT OPERATOR
25070STATIONARY ENGINEER
25190VENTILATION EQUIPMENT TENDER
25210WATER TREATMENT PLANT OPERATOR
27004ALARM MONITOR
27006BACKGROUND INVESTIGATOR
27007BAGGAGE INSPECTOR
27008CORRECTIONS OFFICER
27010COURT SECURITY OFFICER
27030DETECTION DOG HANDLER
27040DETENTION OFFICER
27070FIREFIGHTER
27101GUARD I
27102GUARD II
27131POLICE OFFICER I
27132POLICE OFFICER II
27210SINGLE POINT ENTRY MONITOR
28041CARNIVAL EQUIPMENT OPERATOR
28042CARNIVAL EQUIPMENT REPAIRER
28043CARNIVAL WORKER
28210GATE ATTENDANT/GATE TENDER
28310LIFEGUARD
28350PARK ATTENDANT (AIDE)
28510RECREATION AIDE/HEALTH FACILITY ATTENDANT
28515RECREATION SPECIALIST
28630SPORTS OFFICIAL
28690SWIMMING POOL OPERATOR
29010BLOCKER AND BRACER
29020HATCH TENDER
29030LINE HANDLER
29041STEVEDORE I
29042STEVEDORE II
30010AIR TRAFFIC CONTROL SPECIALIST, CENTER (HFO)
30011AIR TRAFFIC CONTROL SPECIALIST, STATION (HFO)
30012AIR TRAFFIC CONTROL SPECIALIST, TERMINAL (HFO)
30021ARCHEOLOGICAL TECHNICIAN I
30022ARCHEOLOGICAL TECHNICIAN II
30023ARCHEOLOGICAL TECHNICIAN III
30030CARTOGRAPHIC TECHNICIAN
30040CIVIL ENGINEERING TECHNICIAN
30051CRYOGENIC TECHNICIAN I
30052CRYOGENIC TECHNICIAN II
30061DRAFTER/CAD OPERATOR I
30062DRAFTER/CAD OPERATOR II
30063DRAFTER/CAD OPERATOR III
30064DRAFTER/CAD OPERATOR IV
30081ENGINEERING TECHNICIAN I
30082ENGINEERING TECHNICIAN II
30083ENGINEERING TECHNICIAN III
30084ENGINEERING TECHNICIAN IV
30085ENGINEERING TECHNICIAN V
30086ENGINEERING TECHNICIAN VI
30090ENVIRONMENTAL TECHNICIAN
30095EVIDENCE CONTROL SPECIALIST
30110FOREIGN LANGUAGE TRANSLATOR
30130INTERPRETER (SIGN LANGUAGE)
30210LABORATORY TECHNICIAN (LABORATORY TESTER)
30221LATENT FINGERPRINT TECHNICIAN I
30222LATENT FINGERPRINT TECHNICIAN II
30240MATHEMATICAL TECHNICIAN
30361PARALEGAL/LEGAL ASSISTANT I
30362PARALEGAL/LEGAL ASSISTANT II
30363PARALEGAL/LEGAL ASSISTANT III
30364PARALEGAL/LEGAL ASSISTANT IV
30375PETROLEUM SUPPLY SPECIALIST
30390PHOTO-OPTICS TECHNICIAN
30395RADIATION CONTROL TECHNICIAN
30410TAX PREPAIRER
30411TAX PREPAIRER (SENIOR)
30461TECHNICAL WRITER I
30462TECHNICAL WRITER II
30463TECHNICAL WRITER III
30491UNEXPLODED ORDNANCE (UXO) TECHNICIAN I
30492UNEXPLODED ORDNANCE (UXO) TECHNICIAN II
30493UNEXPLODED ORDNANCE (UXO) TECHNICIAN III
30494UNEXPLODED (UXO) SAFETY ESCORT
30495UNEXPLODED (UXO) SWEEP PERSONNEL
30501WEATHER FORECASTER I
30502WEATHER FORECASTER II
30620WEATHER OBSERVER, COMBINED UPPER AIR OR SURFACE PROGRAMS (METEOROLOGICAL TECHNICIAN)
30621WEATHER OBSERVER, SENIOR (METEOROLOGICAL TECHNICIAN, SENIOR)
31010AIRPLANE PILOT
31020BUS AIDE
31030BUS DRIVER
31043DRIVER COURIER
31051FLIGHT ENGINEER
31061HELICOPTER PILOT
31260PARKING AND LOT ATTENDANT
31290SHUTTLE BUS DRIVER (VAN DRIVER)
31310TAXI DRIVER
31360TRUCKDRIVER
31361TRUCK DRIVER, LIGHT
31362TRUCK DRIVER, MEDIUM
31363TRUCK DRIVER, HEAVY
31364TRUCK DRIVER, TRACTOR-TRAILER
47010BOATSWAINS (BOSUN)
47020CHIEF COOK/STEWARD (CHIEF COOK; CHIEF STEWARD/STEWARD-COOK/STEWARD-BAKER)
47021COOK-BAKER/SECOND COOK/SECOND COOK-BAKER/ASSISTANT COOK
47030DECK HAND
47040DIVER
47041DIVER TENDER
47050ELECTRICIAN (CHIEF ELECTRICIAN; ELECTRICIAN/SECOND
47060ENGINE UTILITYMAN
47070FIREMAN-WATER TENDER
47080GENERAL VESSEL ASSISTANT
47090OILER/DIESEL OILER
47101PLUMBER-MACHINIST
47201PUMPMAN, CHIEF PUMPMAN, QMED/PUMPMAN, SECOND PUMPMAN, SECOND PUMPMAN/ENGINE MECHANIC
47301REFRIGERATION ENGINEER
47401SEAMAN (ABLE SEAMAN, WATCH ; ABLE SEAMAN, MAINTENANCE;ABLE SEAMAN, DAY/DECK UTILITY; ORDINARY SEAMAN)
47501STEWARD ASSISTANT/GALLEY UTILITYMAN/MESSMAN
47601TUG BOAT OPERATOR/ENGINEER
47701UNLICENSED JUNIOR ENGINEER/QUALIFIED MEMBER OF THE ENGINE DEPARTMENT [QMED]/DECK ENGINE MECHANIC
47801WIPER
91150FALCONER/BIRD ABATEMENT
91200FISH MARKER
91401FISHERY OBSERVER I
91402FISHERY OBSERVER II
91403FISHERY OBSERVER III
91610LIVESTOCK CARETAKER
91710OUTFITTER/PACKER
91750WILDLIFE TECHNICIAN
91811WRANGLER I
91812WRANGLER II
99025CABIN SAFTEY SPECIALIST
99030CASHIER
99050DESK CLERK
99095EMBALMER
99100FIRE WATCH
99130FLIGHT FOLLOWER
99240INSPECTOR
99251LABORATORY ANIMAL CARETAKER I
99252LABORATORY ANIMAL CARETAKER II
99260MARKETING ANALYST
99310MORTICIAN (FUNERAL DIRECTOR)
99410PEST CONTROLLER (EXTERMINATOR)
99510PHOTOFINISHING WORKER (PHOTO LAB TECHNICIAN, DARK ROOM TECHNICIAN)
99610QUALITY CONTROL INSPECTOR
99710RECYCLING LABORER
99711RECYCLING SPECIALIST
99730REFUSE COLLECTOR
99810SALES CLERK
99820SCHOOL CROSSING GUARD
99830SURVEY PARTY CHIEF (CHIEF OF PARTY)
99831SURVEYING AIDE
99832SURVEYING TECHNICIAN (INSTRUMENT PERSON; SURVEYOR ASSISTANT,
99840VENDING MACHINE ATTENDANT
99841VENDING MACHINE REPAIRER (COIN MACHINE SERVICE REPAIRER)
99842VENDING MACHINE REPAIRER HELPER

Data Tab

This worksheet is locked and used for calculation purposes only using data derived from Tab 2 and Tab 3.POP1POP2POP3POP4POP5POP6POP7POP8POP9POP10
Unique Labor Categories/SitesAll Labor Categories/SitesLabor CategorySiteLab RateEstimated HoursTotal Estimated Hours% of Estimated HoursRate * Hours %Lab RateEstimated HoursTotal Estimated Hours% of Estimated HoursRate * Hours %Lab RateEstimated HoursTotal Estimated Hours% of Estimated HoursRate * Hours %Lab RateEstimated HoursTotal Estimated Hours% of Estimated HoursRate * Hours %Lab RateEstimated HoursTotal Estimated Hours% of Estimated HoursRate * Hours %Lab RateEstimated HoursTotal Estimated Hours% of Estimated HoursRate * Hours %Lab RateEstimated HoursTotal Estimated Hours% of Estimated HoursRate * Hours %Lab RateEstimated HoursTotal Estimated Hours% of Estimated HoursRate * Hours %Lab RateEstimated HoursTotal Estimated Hours% of Estimated HoursRate * Hours %Lab Rate

Tab 4 - UPLOAD

Table will be automatically be filled based on entries to Tab 3 - Input. Be sure table doesn't include blank rows. You must leave the headers in place or the worksheet will not upload properly.
Labor Category CodeLabor CategoryWork SitePOP 1 Estimated HoursPOP 1 Weighted AveragePOP 2 Estimated HoursPOP 2 Weighted AveragePOP 3 Estimated HoursPOP 3 Weighted AveragePOP 4 Estimated HoursPop 4 Weighted AveragePOP 5 Estimated HoursPOP 5 Weighted AveragePOP 6 Estimated HoursPOP 6 Weighted AveragePOP 7 Estimated HoursPOP 7 Weighted AveragePOP 8 Estimated HoursPOP 8 Weighted AveragePOP 9 Estimated HoursPOP 9 Weighted AveragePOP 10 Estimated HoursPOP 10 Weighted Average

image1.png

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .