Attachment 7 -NUWCDIVNPT Cost Proposal Spreadsheet.xlsx

XLSX spreadsheet 225 KB Posted

Attached to
Payload Control System (PCS) Federal contract opportunity
Solicitation number
N6660426R0063
Issued by
Department of the Navy Naval Sea Systems Command

About this file

This document is a Cost Proposal Spreadsheet (Attachment 7) for a federal contract opportunity with Naval Undersea Warfare Center Division Newport (NUWCDIVNPT). The spreadsheet provides a detailed template for contractors to submit labor cost proposals, with specific instructions for completing the input tabs. Key features include guidance for entering labor categories using eCRAFT categories, calculating fringe and overhead rates, and applying mid-point escalation for the entire five-year period of performance (January 2024 - December 2028). The spreadsheet is designed to accommodate contractors' accounting systems while maintaining specific calculation requirements, with a 3.30% proposed annual escalation rate and a total escalation to midpoint of 8.59%. Contractors must use intact formulas and clearly show any alterations to the spreadsheet format, with warnings that proposals without proper formula documentation may be deemed ineligible.

View the file

Other files for this federal contract opportunity

On GovTribe

Work with this file on GovTribe

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

Text version

INSTRUCTIONS TO OFFERORS

INSTRUCTIONS TO OFFERORS

1 The yellow part of the spreadsheet is for input. The white part of the spreadsheet is formulated.

2 The Offeror shall provide hours by labor category, including subcontractor labor categories using eCRAFT categories. Offerors shall use the drop down menu on the Input Tab spreadsheet (Column B) to cite labor categories.

3The FRG (fringe) code (cell E4 on the Input Tab) correlates to the fringe code (cells W7:W14) identified in the INDIRECT BURDEN section of the Input Tab spreadsheet.
4The OVD (overhead) code (cell F4 in Input Tab) correlates to the overhead code (cells W15:W22) identified in the INDIRECT BURDEN section of the Input Tab spreadsheet.
5Contractors and subcontractors may alter the format and formulas of the Input Tab spreadsheet for the sole purpose of accommodating their own accounting systems.
> Offerors shall clearly show how the spreadsheet was altered.
> All spreadsheet tabs, either in the Government format or contractor format, shall contain intact formulas used to calculate any aspect of the proposal (e.g., burdened labor rates, fee, etc.).
> All spreadsheet tabs provided without intact formulas are unacceptable and may render an Offeror’s proposal ineligible for award. However, prime contractors and subcontractors shall provide a single spreadsheet supporting the total amount of all CLINs listed in Section B of the solicitation.
6The Input Tab spreadsheet is set up to calculate mid-point escalation for the entire period of performance.
> The offeror may alter the Input Tab spreadsheet to propose escalation on an annual basis by entering the proposed escalation rate in cell AE61.
> If the offeror elects to calculate escalation on an annual basis, the Input Tab spreadsheet can be copied for each successive year proposed.
> If offeror elects to calculate escalation on an annual basis, a summary "rollup" spreadsheet is required.

7 The "Key Personnel Wage Data" section on the Input Tab spreadsheet (cells AE5:AK35) does not factor into other calculations on the sheet and is for notation purposes only; it is not a mandatory section.

Summary

CPFF
CategoryCLINProposedEvaluatedDelta
LABOR2100, 6100-6400$ -$ -$ -
ODCs3100, 7100-7400$ -$ -$ -
TOTAL CPFF$ -$ -$ -
Check
FFP
CategoryCLINProposedEvaluatedDelta
LABOR1100, 5100-5400$ -$ -$ -
TOTAL FFP$ -$ -$ -
CPFF & FFP
CategoryCLINProposedEvaluatedDelta
LABOR CPFF2100, 6100-6400$ -$ -$ -
ODCs3100, 7100-7400$ -$ -$ -
LABOR FFP$ -$ -$ -
GRAND TOTAL$ -$ -$ -
PRIME TOTAL BID AMOUNT$ - 0
$ - 0

Input

LABORCONTRACTBASISTOTALFRGOVDLABORMIDPOINTESCALATEDTOTALFRINGEFRINGEOVRHDOVERHEADMISC INDMISC INDRG&AG&ATOTALLOADEDPERIOD OF PERFORMANCE1 JAN 2024 - 31 DEC 2028KEY PERSONNEL WAGE DATA#VALCOL4
CATEGORYLABOR CATEGORYOFHOURSCDECDERATEESC.LABORLABORRATECOSTRATECOSTRATE*COST*RATE*COST*EST COSTCOST/HRCONTRACTOR FY START ISJAN 1CONTRACTCOMPOSITE00FALSE
CODEESTIMATECOL4FACTORw/ feePRIME CONTRACTORFISCAL YRFISCAL YRFISCAL YRFISCAL YRFISCAL YRFISCAL YRLABORKEYHOURSWAGELABORRATE/COL4
0.00%$0.00$00.00%$00.00%$0

Paul Simone: Overhead cost is a result of applying the overhead rate to labor cost and fringe cost. If overhead rate if not applied to fringe cost then formula must be changed.

0.00%$00.00%$0$0$0.00FY202420252026202720282029COMPOSITECATEGORYPERSONNELPROPOSEDRATECOSTSCATEGORYFALSE
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00# MONTHS1212121212060$0.00COL4
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00INDIRECT BURDENINDIRECT CODE$0.00FALSE
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FRINGE (FULL-TIME)10.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00COL4
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FRINGE (PART-TIME)20.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00FALSE
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FRINGE30.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00COL4
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FRINGE40.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00FALSE
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FRINGE50.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00COL4
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FRINGE60.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00FALSE
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FRINGE70.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00COL4
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FRINGE80.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00FALSE
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00OVRHD KR SITE - (FULL TIME)90.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00COL4
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00OVRHD GOV SITE - (FULL TIME)100.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00FALSE
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00OVRHD KR SITE - (PART TIME)110.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00OVRHD GOV SITE - (PART TIME)120.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00OVRHD130.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00OVRHD140.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00OVRHD150.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00OVRHD160.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00MAT'L BURD'N PARTS/SUBK0.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00MISC INDIRECT/PARTS-SUBK0.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00MISC INDIRECT*RATE IN WORKSHEET0.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00GENERAL & ADMIN*RATE IN WORKSHEET0.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00G&A - OTHER0.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00G&A - OTHER0.00%0.00%0.00%0.00%0.00%0.00%0.00%$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - LABOR90.000000.000000.000000.000000.000000.000000.00000$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - LABOR100.000000.000000.000000.000000.000000.000000.00000$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - LABOR110.000000.000000.000000.000000.000000.000000.00000$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - LABOR120.000000.000000.000000.000000.000000.000000.00000$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - LABOR130.000000.000000.000000.000000.000000.000000.00000$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - LABOR140.000000.000000.000000.000000.000000.000000.00000$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - LABOR150.000000.000000.000000.000000.000000.000000.00000$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - LABOR160.000000.000000.000000.000000.000000.000000.00000FEE SUMMARYPROPOSED
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - MATERIAL170.000000.000000.000000.000000.000000.000000.000000.00%PRIME FEE on PRIME labor$0
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00FCCM - G&A BASE180.000000.000000.000000.000000.000000.000000.000000.00%Prime FEE on subcontracts$0
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00TOTAL FIXED FEE$0
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00SUMMARYPROPOSEDEVALUATEDDIFFERENCE
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00Direct Labor$0$0$0
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00CONTRACT ESCALATIONFringe$0$0$0
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00'MM/DD/YRCALENDAR YEARRATE/YEAROverhead$0$0$0
0.00%$0.00$00.00%$00.00%$00.00%$00.00%$0$0$0.00DATE OF ACTUALS1/1/2445292.0202344927.03.30%Misc Indirect (on labor)$0$0$0
TOTALSTOTAL HOURS0$0$0$0$0$0$0START1/1/2445292.0202445292.03.30%G&A (on labor)$0$0$0
Govt Site0COMPLETION12/31/2847118.0202545658.03.30%SUBTOTAL:$0$0$0
KTR Site0MATL OVHDMATL OVHDSUB HDLGSUB HDLGG&AG&ATOTAL#CONTRACT YRS5.00202646023.03.30%Travel$0$0$0
OTHER DIRECT COSTSAMOUNTRATECOSTRATECOSTRATEAMOUNTCOSTBRD202746388.03.30%Material$0$0$0
TRAVEL$0$00.00%$00.00%$0$0FCCMBASECTRFACTORAMOUNT202846753.03.30%Other Direct Costs$0$0$0
MATERIAL$00.00%$00.00%$00.00%$0$0ENG LABOR CC 9$090.00000$0202947119.03.30%Material Overhead$0$0$0
ODCs$00.00%$00.00%$00.00%$0$0ENG LABOR CC 10$0100.00000$0CYDAYSRATE/YRFACTORG&A (on Trvl/Matl/ODC)$0$0$0
Sub 10$0$00.00%$00.00%$0$0ENG LABOR CC 11$0110.00000$0DATA TO START202300.00%Sub 1$0$0$0
Sub 20$0$00.00%$00.00%$0$0ENG LABOR CC 12$0120.00000$0DATA TO START202400.00%1.000Sub 2$0$0$0
Sub 30$0$00.00%$00.00%$0$0ENG LABOR CC 13$0130.00000$0START TO END OF YR20243653.30%1.0171.017Sub 3$0$0$0
$0$00.00%$00.00%$0$0ENG LABOR CC 14$0140.00000$0FIRST CY OF PERF20253653.30%1.0501.050Sub Handling$0$0$0
$0$00.00%$00.00%$0$0ENG LABOR CC 15$0150.00000$0SECOND CY OF PERF20263653.30%1.0851.085G&A (on Subs)$0$0$0
$0$00.00%$00.00%$0$0ENG LABOR CC 16$0160.00000$0THIRD CY OF PERF20273653.30%1.1201.120FCOM$0$0$0
$0$00.00%$00.00%$0$0MATERIAL$0170.00000$0FOURTH CY OF PERF20283663.31%1.1581.161ESTIMATED COST$0$0$0
$0$00.00%$00.00%$0$0G&A$0

Paul Simone: Base amount includes material costs. If material costs have separate factor applied then they should be taken out of G&A base.

Paul Simone: Name of Prime contractor180.00000$0FIFTH CY OF PERF202900.00%1.1760.000FIXED FEE$0$0$0
$0$00.00%$00.00%$0$0$0ESCALATION TO MIDPOINT8.59%TOTAL CPFF$0$0$0
TOTALSTOTAL SUBCONTRACTOR LABOR HOURS0$0$0$0$0$0Fee Rate (prime labor)0.00%
TOTAL PRIME & SUBCONTRACTOR HOURS0Bid Amount$0
Delta$0

&"Times New Roman,Bold"&18Contractor Name

&D "SOURCE SELECTION INFORMATION - SEE FAR 3.104"

Labor Categories

LABOR_CATEGORY_DESCLABOR_CATEGORY_CODELABOR_CATEGORY_SECTIONLabor Category Sections
ACCOUNTING CLERK I01011ADMIN SUPPORT/CLERICALADMIN SUPPORT/CLERICAL
ACCOUNTING CLERK II01012ADMIN SUPPORT/CLERICALENGINEER/SCIENTIST
ACCOUNTING CLERK III01013ADMIN SUPPORT/CLERICALINFORMATION TECHNOLOGY
ACQUISITION MANAGEMENT SUPPORT IAMS1PROFESSIONALPROFESSIONAL
ACQUISITION MANAGEMENT SUPPORT IIAMS2PROFESSIONALTECHNICIAN
ACQUISITION MANAGEMENT SUPPORT IIIAMS3PROFESSIONALWAGE
ADMINISTRATIVE ASSISTANT01020ADMIN SUPPORT/CLERICALOTHER
AEROSPACE STRUCTURAL WELDER23010WAGE
AIR TRAFFIC CONTROL SPECIALIST, CENTER (HFO)30010WAGE
AIR TRAFFIC CONTROL SPECIALIST, STATION (HFO)30011WAGE
AIR TRAFFIC CONTROL SPECIALIST, TERMINAL (HFO)30012WAGE
AIRCRAFT LOGS AND RECORDS TECHNICIAN23019TECHNICIAN
AIRCRAFT MECHANIC HELPER (Airframe and Power plant Mechanic
Helper)23040WAGE
AIRCRAFT MECHANIC I23021WAGE
AIRCRAFT MECHANIC II23022WAGE
AIRCRAFT MECHANIC III23023WAGE
AIRCRAFT SERVICER (Airport Utility Worker)23060WAGE
AIRCRAFT SURVIVAL FLIGHT EQUIPMENT TECHNICIAN23070TECHNICIAN
AIRCRAFT WORKER23080WAGE
AIRCRAFT, PAINTER23050WAGE
AIRCREW LIFE SUPPORT EQUIPMENT (ALSE) MECHANIC I23091WAGE
AIRCREW LIFE SUPPORT EQUIPMENT (ALSE) MECHANIC II23092WAGE
AIRCREW TRAINING DEVICES INSTRUCTOR (NON-RATED)15010INFORMATION TECHNOLOGY
AIRCREW TRAINING DEVICES INSTRUCTOR (PILOT)15030INFORMATION TECHNOLOGY
AIRCREW TRAINING DEVICES INSTRUCTOR (RATED)15020INFORMATION TECHNOLOGY
AIRPLANE PILOT31010OTHER
ALARM MONITOR27004WAGE
AMBULANCE DRIVER12010WAGE
ANALYST, FINANCIAL SYSTEMS IANFS1PROFESSIONAL
ANALYST, FINANCIAL SYSTEMS IIANFS2PROFESSIONAL
ANALYST, FINANCIAL SYSTEMS IIIANFS3PROFESSIONAL
ANALYST, FINANCIAL SYSTEMS IVANFS4PROFESSIONAL
ANALYST, MANAGEMENT IANM1PROFESSIONAL
ANALYST, MANAGEMENT IIANM2PROFESSIONAL
ANALYST, MANAGEMENT IIIANM3PROFESSIONAL
ANALYST, OPERATIONS IANP1PROFESSIONAL
ANALYST, OPERATIONS IIANP2PROFESSIONAL
ANALYST, OPERATIONS IIIANP3PROFESSIONAL
APPLIANCE MECHANIC23110WAGE
AQUISITION COST ESTIMATOR IACE1PROFESSIONAL
AQUISITION COST ESTIMATOR IIACE2PROFESSIONAL
AQUISITION COST ESTIMATOR IIIACE3PROFESSIONAL
ARCHEOLOGICAL TECHNICIAN I30021TECHNICIAN
ARCHEOLOGICAL TECHNICIAN II30022TECHNICIAN
ARCHEOLOGICAL TECHNICIAN III30023TECHNICIAN
ASSEMBLER16010WAGE
AUDIO VISUAL ANIMATORAVAPROFESSIONAL
AUDIO VISUAL DIRECTOR / PRODUCER IAVDP1PROFESSIONAL
AUDIO VISUAL DIRECTOR / PRODUCER IIAVDP2PROFESSIONAL
AUDIO VISUAL SCRIPT WRITERAVSWPROFESSIONAL
AUTOMOBILE BODY REPAIRER, FIBERGLASS05005WAGE
AUTOMOTIVE ELECTRICIAN05010WAGE
AUTOMOTIVE GLASS INSTALLER (Auto Glass Worker)05040WAGE
AUTOMOTIVE WORKER05070WAGE
BACKGROUND INVESTIGATOR27006WAGE
BAGGAGE INSPECTOR27007WAGE
BAKER07010WAGE
BARBER24510WAGE
BEAUTICIAN (Cosmetologist)24540WAGE
BICYCLE REPAIRER23120WAGE
BLOCKER AND BRACER29010WAGE
BOAT OPERATORBOOTHER
BOATSWAINS (Bosun)47010WAGE
BOILER TENDER25010WAGE
BREATH ALCOHOL TECHNICIAN (BAT)12011WAGE
BRIDGE TENDER25020WAGE
BRUSH/PRECOMMERCIAL THINNER08010WAGE
BUS AIDE31020WAGE
BUS DRIVER31030WAGE
CABIN SAFTEY SPECIALIST99025WAGE
CABLE SPLICER23125WAGE
CARNIVAL EQUIPMENT OPERATOR28041WAGE
CARNIVAL EQUIPMENT REPAIRER28042WAGE
CARNIVAL WORKER28043WAGE
CARPENTER, MAINTENANCE23130WAGE
CARPET LAYER23140WAGE
CARTOGRAPHIC TECHNICIAN30030TECHNICIAN
CASE MANAGER24550OTHER
CASHIER99030ADMIN SUPPORT/CLERICAL
CERTIFIED OCCUPATIONAL THERAPIST ASSISTANT12012WAGE
CERTIFIED PHYSICAL THERAPIST ASSISTANT12015WAGE
CHEMIST ICHEM1ENGINEER/SCIENTIST
CHEMIST IICHEM2ENGINEER/SCIENTIST
CHEMIST IIICHEM3ENGINEER/SCIENTIST
CHIEF COOK/STEWARD (CHIEF COOK; CHIEF STEWARD/STEWARD-
COOK/STEWARD-BAKER)47020WAGE
CHILD CARE ATTENDANT24570OTHER
CHILD CARE CENTER CLERK24580OTHER
CHOKER SETTER08040WAGE
CHORE AIDE24610OTHER
CIVIL ENGINEERING TECHNICIAN30040TECHNICIAN
CLEANER, VEHICLES11030WAGE
COLLECTION SPECIALIST01030ADMIN SUPPORT/CLERICAL
COMPUTER BASED TRAINING SPECIALIST / INSTRUCTOR15050INFORMATION TECHNOLOGY
COMPUTER OPERATOR I14041INFORMATION TECHNOLOGY
COMPUTER OPERATOR II14042INFORMATION TECHNOLOGY
COMPUTER OPERATOR III14043INFORMATION TECHNOLOGY
COMPUTER OPERATOR IV14044INFORMATION TECHNOLOGY
COMPUTER OPERATOR V14045INFORMATION TECHNOLOGY
COMPUTER PROGRAMMER I14071INFORMATION TECHNOLOGY
COMPUTER PROGRAMMER II14072INFORMATION TECHNOLOGY
COMPUTER PROGRAMMER III14073INFORMATION TECHNOLOGY
COMPUTER PROGRAMMER IV14074INFORMATION TECHNOLOGY
COMPUTER SYSTEMS ANALYST I14101INFORMATION TECHNOLOGY
COMPUTER SYSTEMS ANALYST II14102INFORMATION TECHNOLOGY
COMPUTER SYSTEMS ANALYST III14103INFORMATION TECHNOLOGY
CONTRACTS MANAGEMENT ANALYST ICMA1
CONTRACTS MANAGEMENT ANALYST IICMA2
CONTRACTS MANAGEMENT ANALYST IIICMA3
COOK I07041WAGE
COOK II07042WAGE
COOK-BAKER/SECOND COOK/SECOND COOK-BAKER/ASSISTANT
COOK47021WAGE
CORRECTIONS OFFICER27008WAGE
COUNSELORCNSLRPROFESSIONAL
COUNTER ATTENDANT (Service Establishment Attendant)16030ADMIN SUPPORT/CLERICAL
COURT REPORTER01035ADMIN SUPPORT/CLERICAL
COURT SECURITY OFFICER27010WAGE
CRYOGENIC TECHNICIAN I30051TECHNICIAN
CRYOGENIC TECHNICIAN II30052TECHNICIAN
CUSTOMER SERVICE REPRESENTATIVE I01041ADMIN SUPPORT/CLERICAL
CUSTOMER SERVICE REPRESENTATIVE II01042ADMIN SUPPORT/CLERICAL
CUSTOMER SERVICE REPRESENTATIVE III01043ADMIN SUPPORT/CLERICAL
DATA ENTRY OPERATOR I01051ADMIN SUPPORT/CLERICAL
DATA ENTRY OPERATOR II01052ADMIN SUPPORT/CLERICAL
DATA SCIENTIST IDSC1
DATA SCIENTIST IIDSC2
DATA SCIENTIST IIIDSC3
DATABASE MANAGEMENT ANALYST IDMA1
DATABASE MANAGEMENT ANALYST IIDMA2
DATABASE MANAGEMENT ANALYST IIIDMA3
DECK HAND47030WAGE
DENTAL ASSISTANT12020WAGE
DENTAL HYGIENIST12025OTHER
DESK CLERK99050ADMIN SUPPORT/CLERICAL
DETECTION DOG HANDLER27030WAGE
DETENTION OFFICER27040WAGE
DISHWASHER07070WAGE
DISPATCHER, MOTOR VEHICLE (Motor Vehicle Utilization Assistant)01060ADMIN SUPPORT/CLERICAL
DIVER47040WAGE
DIVER TENDER47041WAGE
DOCUMENT PREPARATION CLERK (Document Preparer)01070ADMIN SUPPORT/CLERICAL
DRAFTER/CAD OPERATOR I30061TECHNICIAN
DRAFTER/CAD OPERATOR II30062TECHNICIAN
DRAFTER/CAD OPERATOR III30063TECHNICIAN
DRAFTER/CAD OPERATOR IV30064TECHNICIAN
DRIVER COURIER31043WAGE
DRY CLEANER16040WAGE
DUPLICATING MACHINE OPERATOR (Photocopy Machine Operator;
Reproduction Worker)01090ADMIN SUPPORT/CLERICAL
EDUCATIONAL TECHNOLOGIST15060INFORMATION TECHNOLOGY
EKG TECHNICIAN12030OTHER
ELECTRICIAN (CHIEF ELECTRICIAN; ELECTRICIAN/SECOND47050WAGE
ELECTRICIAN, MAINTENANCE23160WAGE
ELECTRONEURODIAGNOSTIC TECHNOLOGIST12035OTHER
ELECTRONICS TECHNICIAN MAINTENANCE I23181TECHNICIAN
ELECTRONICS TECHNICIAN MAINTENANCE II23182TECHNICIAN
ELECTRONICS TECHNICIAN MAINTENANCE III23183TECHNICIAN
ELECTROSTATIC SPRAY PAINTER09010WAGE
ELEVATOR OPERATOR11060WAGE
ELEVATOR REPAIRER23210WAGE
ELEVATOR REPAIRER HELPER23220WAGE
EMBALMER99095OTHER
EMERGENCY MEDICAL TECHNICIAN (EMT)12040OTHER
ENGINE UTILITYMAN47060WAGE
ENGINEER IE1ENGINEER/SCIENTIST
ENGINEER IIE2ENGINEER/SCIENTIST
ENGINEER IIIE3ENGINEER/SCIENTIST
ENGINEER IVE4ENGINEER/SCIENTIST
ENGINEER, ACOUSTICAL IEA1ENGINEER/SCIENTIST
ENGINEER, ACOUSTICAL IIEA2ENGINEER/SCIENTIST
ENGINEER, ACOUSTICAL IIIEA3ENGINEER/SCIENTIST
ENGINEER, ACOUSTICAL IVEA4ENGINEER/SCIENTIST
ENGINEER, COMPUTER IEC1ENGINEER/SCIENTIST
ENGINEER, COMPUTER IIEC2ENGINEER/SCIENTIST
ENGINEER, COMPUTER IIIEC3ENGINEER/SCIENTIST
ENGINEER, COMPUTER IVEC4ENGINEER/SCIENTIST
ENGINEER, CYBERSECURITY ICSE1
ENGINEER, CYBERSECURITY IICSE2
ENGINEER, CYBERSECURITY IIICSE3
ENGINEER, DESIGN IED1ENGINEER/SCIENTIST
ENGINEER, DESIGN IIED2ENGINEER/SCIENTIST
ENGINEER, DESIGN IIIED3ENGINEER/SCIENTIST
ENGINEER, DESIGN IVED4ENGINEER/SCIENTIST
ENGINEER, ELECTRICAL/ELECTRONICS IEE1ENGINEER/SCIENTIST
ENGINEER, ELECTRICAL/ELECTRONICS IIEE2ENGINEER/SCIENTIST
ENGINEER, ELECTRICAL/ELECTRONICS IIIEE3ENGINEER/SCIENTIST
ENGINEER, ELECTRICAL/ELECTRONICS IVEE4ENGINEER/SCIENTIST
ENGINEER, HUMAN SYSTEM INTEGRATION IEHSI1ENGINEER/SCIENTIST
ENGINEER, HUMAN SYSTEM INTEGRATION IIEHSI2ENGINEER/SCIENTIST
ENGINEER, HUMAN SYSTEM INTEGRATION IIIEHSI3ENGINEER/SCIENTIST
ENGINEER, HUMAN SYSTEM INTEGRATION IVEHSI4ENGINEER/SCIENTIST
ENGINEER, HUMAN SYSTEM INTEGRATION VEHSI5ENGINEER/SCIENTIST
ENGINEER, MECHANICAL IEM1ENGINEER/SCIENTIST
ENGINEER, MECHANICAL IIEM2ENGINEER/SCIENTIST
ENGINEER, MECHANICAL IIIEM3ENGINEER/SCIENTIST
ENGINEER, MECHANICAL IVEM4ENGINEER/SCIENTIST
ENGINEER, STRUCTURAL IEST1ENGINEER/SCIENTIST
ENGINEER, STRUCTURAL IIEST2ENGINEER/SCIENTIST
ENGINEER, STRUCTURAL IIIEST3ENGINEER/SCIENTIST
ENGINEER, STRUCTURAL IVEST4ENGINEER/SCIENTIST
ENGINEER, SYSTEMS IESY1ENGINEER/SCIENTIST
ENGINEER, SYSTEMS IIESY2ENGINEER/SCIENTIST
ENGINEER, SYSTEMS IIIESY3ENGINEER/SCIENTIST
ENGINEER, SYSTEMS IVESY4ENGINEER/SCIENTIST
ENGINEERING TECHNICIAN I30081TECHNICIAN
ENGINEERING TECHNICIAN II30082TECHNICIAN
ENGINEERING TECHNICIAN III30083TECHNICIAN
ENGINEERING TECHNICIAN IV30084TECHNICIAN
ENGINEERING TECHNICIAN V30085TECHNICIAN
ENGINEERING TECHNICIAN VI30086TECHNICIAN
ENVIRONMENTAL TECHNICIAN30090TECHNICIAN
EVENT PLANNEREPADMIN SUPPORT/CLERICAL
EVIDENCE CONTROL SPECIALIST30095ADMIN SUPPORT/CLERICAL
EXHIBITS SPECIALIST I13011ADMIN SUPPORT/CLERICAL
EXHIBITS SPECIALIST II13012ADMIN SUPPORT/CLERICAL
EXHIBITS SPECIALIST III13013ADMIN SUPPORT/CLERICAL
FABRIC WORKER23260WAGE
FALCONER/BIRD ABATEMENT91150OTHER
FALLER/BUCKER08070WAGE
FAMILY READINESS AND SUPPORT SERVICES COORDINATOR24620OTHER
FAST FOOD SHIFT LEADER (Crew chief, Team leader)07080WAGE
FAST FOOD WORKER (Crew person, Team member, Associate)07090WAGE
FINISHER, FLATWORK, MACHINE16070WAGE
FIRE ALARM SYSTEM MECHANIC23290WAGE
FIRE EXTINGUISHER REPAIRER23310WAGE
FIRE LOOKOUT08100WAGE
FIRE WARDENFWPROFESSIONAL
FIRE WATCH99100WAGE
FIREFIGHTER27070WAGE
FIREMAN-WATER TENDER47070WAGE
FISH MARKER91200OTHER
FISHERY OBSERVER I91401OTHER
FISHERY OBSERVER II91402OTHER
FISHERY OBSERVER III91403OTHER
FITNESS MANAGERFMOTHER
FLIGHT ENGINEER31051OTHER
FLIGHT FOLLOWER99130WAGE
FLIGHT INSTRUCTOR (PILOT)15070WAGE
FOOD SERVICE WORKER (Cafeteria Worker)07130WAGE
FOREIGN LANGUAGE TRANSLATOR30110ADMIN SUPPORT/CLERICAL
FORESTRY EQUIPMENT OPERATOR (Includes Tractor Operator,
Planting; Tractor Operator, Site Preparation; and Tractor Operator, Thinning)08130WAGE
FORESTRY TECHNICIAN08190WAGE
FORESTRY TRUCK DRIVER08200WAGE
FORESTRY/LOGGING HEAVY EQUIPMENT OPERATOR (Loader
Operator, Skidder Operator)08160WAGE
FORKLIFT OPERATOR21020WAGE
FUEL DISTRIBUTION SYSTEM MECHANIC23311WAGE
FUEL DISTRIBUTION SYSTEM OPERATOR23312WAGE
FULLY QUALIFIED NAVY VALIDATOR IFQNV1INFORMATION TECHNOLOGY
FULLY QUALIFIED NAVY VALIDATOR IIFQNV2INFORMATION TECHNOLOGY
FULLY QUALIFIED NAVY VALIDATOR IIIFQNV3INFORMATION TECHNOLOGY
FULLY QUALIFIED NAVY VALIDATOR IVFQNV4INFORMATION TECHNOLOGY
FURNITURE HANDLER09040WAGE
FURNITURE REFINISHER09080WAGE
FURNITURE REFINISHER HELPER09090WAGE
FURNITURE REPAIRER, MINOR09110WAGE
GARDENER11090WAGE
GATE ATTENDANT/GATE TENDER28210WAGE
GENERAL CLERK I01111ADMIN SUPPORT/CLERICAL
GENERAL CLERK II01112ADMIN SUPPORT/CLERICAL
GENERAL CLERK III01113ADMIN SUPPORT/CLERICAL
GENERAL FORESTRY LABORER08250WAGE
GENERAL MAINTENANCE WORKER23370WAGE
GENERAL VESSEL ASSISTANT47080WAGE
GRAPHIC ARTIST15080ADMIN SUPPORT/CLERICAL
GROUND SUPPORT EQUIPMENT MECHANIC23380WAGE
GROUND SUPPORT EQUIPMENT SERVICER23381WAGE
GROUND SUPPORT EQUIPMENT WORKER23382WAGE
GUARD I27101WAGE
GUARD II27102WAGE
GUNSMITH I23391WAGE
GUNSMITH II23392WAGE
GUNSMITH III23393WAGE
HATCH TENDER29020WAGE
HAZARDOUS WASTE/MATERIAL HANDLERHWHPROFESSIONAL
HEATING, VENTILATION AND AIR-CONDITIONING MECHANIC23410WAGE
HEATING, VENTILATION AND AIR-CONDITIONING MECHANIC
(Research Facility)23411WAGE
HEAVY EQUIPMENT MECHANIC23430WAGE
HEAVY EQUIPMENT OPERATOR23440WAGE
HELICOPTER PILOT31061OTHER
HOMEMAKER24630OTHER
HOUSEKEEPING AIDE11122WAGE
HOUSING REFERRAL ASSISTANT01120ADMIN SUPPORT/CLERICAL
ILLUSTRATOR I13041ADMIN SUPPORT/CLERICAL
ILLUSTRATOR II13042ADMIN SUPPORT/CLERICAL
ILLUSTRATOR III13043ADMIN SUPPORT/CLERICAL
INFORMATION SYSTEM SECURITY MANAGER IISSM1INFORMATION TECHNOLOGY
INFORMATION SYSTEM SECURITY MANAGER IIISSM2INFORMATION TECHNOLOGY
INFORMATION SYSTEM SECURITY MANAGER IIIISSM3INFORMATION TECHNOLOGY
INSPECTOR99240OTHER
INSTALLATION ANALYST IINS1
INSTALLATION ANALYST IIINS2
INSTALLATION ANALYST IIIINS3
INSTRUMENT MECHANIC23460WAGE
INTEGRATED MASTER SCHEDULER IIMS1
INTEGRATED MASTER SCHEDULER IIIMS2
INTEGRATED MASTER SCHEDULER IIIIMS3
INTELLIGENCE SPECIALIST IIMS1
INTELLIGENCE SPECIALIST IIIMS2
INTELLIGENCE SPECIALIST IIIIMS3
INTERMEDIATE LEVEL NAVY VALIDATOR IILNV1INFORMATION TECHNOLOGY
INTERMEDIATE LEVEL NAVY VALIDATOR IIILNV2INFORMATION TECHNOLOGY
INTERMEDIATE LEVEL NAVY VALIDATOR IIIILNV3INFORMATION TECHNOLOGY
INTERMEDIATE LEVEL NAVY VALIDATOR IVILNV4INFORMATION TECHNOLOGY
INTERPRETER (Sign Language)30130ADMIN SUPPORT/CLERICAL
JANITOR11150WAGE
LABORATORY ANIMAL CARETAKER I99251OTHER
LABORATORY ANIMAL CARETAKER II99252OTHER
LABORATORY TECHNICIAN (Laboratory Tester)30210TECHNICIAN
LABORATORY/SHELTER MECHANIC23465WAGE
LABORER23470WAGE
LABORER, GROUNDS MAINTENANCE11210WAGE
LATENT FINGERPRINT TECHNICIAN I30221TECHNICIAN
LATENT FINGERPRINT TECHNICIAN II30222TECHNICIAN
LIBRARIAN13047ADMIN SUPPORT/CLERICAL
LIBRARY AIDE/CLERK13050ADMIN SUPPORT/CLERICAL
LIBRARY INFORMATION TECHNOLOGY SYSTEMS ADMINISTRATOR13054ADMIN SUPPORT/CLERICAL
LIBRARY TECHNICIAN13058ADMIN SUPPORT/CLERICAL
LICENSED PRACTICAL NURSE I12071OTHER
LICENSED PRACTICAL NURSE II12072OTHER
LICENSED PRACTICAL NURSE III12073OTHER
LIFEGUARD28310OTHER
LINE HANDLER29030WAGE
LIVESTOCK CARETAKER91610OTHER
LOCKSMITH23510WAGE
LOGISTICIAN ILGT1PROFESSIONAL
LOGISTICIAN IILGT2PROFESSIONAL
LOGISTICIAN IIILGT3PROFESSIONAL
LOGISTICIAN IVLGT4PROFESSIONAL
MACHINERY MAINTENANCE MECHANIC23530WAGE
MACHINE-TOOL OPERATOR (TOOL ROOM)19010WAGE
MACHINIST, MAINTENANCE23550WAGE
MAID OR HOUSEMAN11240WAGE
MAINTENANCE TEST PILOT FIXED WING.JET/PROP15085WAGE
MAINTENANCE TEST PILOT ROTOARY WING15086WAGE
MAINTENANCE TRADES HELPER23580WAGE
MANAGER, ADMINISTRATIVE IMANA1PROFESSIONAL
MANAGER, ADMINISTRATIVE IIMANA2PROFESSIONAL
MANAGER, ADMINISTRATIVE IIIMANA3PROFESSIONAL
MANAGER, ADMINISTRATIVE IVMANA4PROFESSIONAL
MANAGER, OPERATIONS IMANO1PROFESSIONAL
MANAGER, OPERATIONS IIMANO2PROFESSIONAL
MANAGER, OPERATIONS IIIMANO3PROFESSIONAL
MANAGER, OPERATIONS IVMANO4PROFESSIONAL
MANAGER, PROGRAM/PROJECT IMANP1PROFESSIONAL
MANAGER, PROGRAM/PROJECT IIMANP2PROFESSIONAL
MANAGER, PROGRAM/PROJECT IIIMANP3PROFESSIONAL
MARINE SURVEYORMRSPROFESSIONAL
MARKETING ANALYST99260ADMIN SUPPORT/CLERICAL
MATERIAL COORDINATOR21030ADMIN SUPPORT/CLERICAL
MATERIAL EXPEDITER21040ADMIN SUPPORT/CLERICAL
MATERIAL HANDLING LABORER21050WAGE
MATHEMATICAL TECHNICIAN30240TECHNICIAN
MATHEMATICIAN IMATH1ENGINEER/SCIENTIST
MATHEMATICIAN IIMATH2ENGINEER/SCIENTIST
MATHEMATICIAN IIIMATH3ENGINEER/SCIENTIST
MEAT CUTTER07210WAGE
MEDIA SPECIALIST I13061ADMIN SUPPORT/CLERICAL
MEDIA SPECIALIST II13062ADMIN SUPPORT/CLERICAL
MEDIA SPECIALIST III13063ADMIN SUPPORT/CLERICAL
MEDICAL ASSISTANT12100OTHER
MEDICAL LABORATORY TECHNICIAN (Clinical Laboratory Assistant;
Registered Medical Technician)12130OTHER
MEDICAL RECORD CLERK12160OTHER
MEDICAL RECORD TECHNICIAN (Medical Record Administrator)12190OTHER
MEDICAL TRANSCRIPTIONIST12195OTHER
MESSENGER COURIER01141ADMIN SUPPORT/CLERICAL
METROLOGY TECHNICIAN I23591TECHNICIAN
METROLOGY TECHNICIAN II23592TECHNICIAN
METROLOGY TECHNICIAN III23593TECHNICIAN
MILLWRIGHT23640WAGE
MOBILE EQUIPMENT SERVICER05110WAGE
MODEL BASED SYSTEMS ENGINEER IMBS1
MODEL BASED SYSTEMS ENGINEER IIMBS2
MODEL BASED SYSTEMS ENGINEER IIIMBS3
MORTICIAN (Funeral Director)99310OTHER
MOTOR EQUIPMENT METAL MECHANIC (Motor Vehicle Body Repairer)05130WAGE
MOTOR EQUIPMENT METAL WORKER05160WAGE
MOTOR VEHICLE MECHANIC05190WAGE
MOTOR VEHICLE MECHANIC HELPER05220WAGE
MOTOR VEHICLE UPHOLSTERY WORKER05250WAGE
MOTOR VEHICLE WRECKER (Tow Truck Operator; Wrecker Operator)05280WAGE
NAIL TECHNICIAN24710WAGE
NAVAL ARCHITECTNARENGINEER/SCIENTIST
NON-MAINTENANCE TEST PILOT/CO-PILOT15087WAGE
NUCLEAR MEDICINE TECHNOLOGIST12210OTHER
NURSERY SPECIALIST08280WAGE
NURSING ASSISTANT I12221OTHER
NURSING ASSISTANT II12222OTHER
NURSING ASSISTANT III12223OTHER
NURSING ASSISTANT IV12224OTHER
OFFICE APPLIANCE REPAIRER23710WAGE
OILER/DIESEL OILER47090WAGE
OPERATIONS SUPPORT IOS1PROFESSIONAL
OPERATIONS SUPPORT IIOS2PROFESSIONAL
OPERATIONS SUPPORT IIIOS3PROFESSIONAL
OPERATIONS SUPPORT IVOS4PROFESSIONAL
OPTICAL DISPENSER12235OTHER
OPTICAL TECHNICIAN12236OTHER
ORDER CLERK I01191ADMIN SUPPORT/CLERICAL
ORDER CLERK II01192ADMIN SUPPORT/CLERICAL
ORDER FILLER21071WAGE
OUTFITTER/PACKER91710WAGE
PAINTER, AUTOMOTIVE05310WAGE
PAINTER, MAINTENANCE23760WAGE
PARALEGAL/LEGAL ASSISTANT I30361ADMIN SUPPORT/CLERICAL
PARALEGAL/LEGAL ASSISTANT II30362ADMIN SUPPORT/CLERICAL
PARALEGAL/LEGAL ASSISTANT III30363ADMIN SUPPORT/CLERICAL
PARALEGAL/LEGAL ASSISTANT IV30364ADMIN SUPPORT/CLERICAL
PARK ATTENDANT (AIDE)28350WAGE
PARKING AND LOT ATTENDANT31260WAGE
PERIPHERAL EQUIPMENT OPERATOR14150INFORMATION TECHNOLOGY
PERSONAL COMPUTER SUPPORT TECHNICIAN14160INFORMATION TECHNOLOGY
PERSONNEL ASSISTANT (Employment) I01261ADMIN SUPPORT/CLERICAL
PERSONNEL ASSISTANT (Employment) II01262ADMIN SUPPORT/CLERICAL
PERSONNEL ASSISTANT (Employment) III01263ADMIN SUPPORT/CLERICAL
PEST CONTROLLER (Exterminator)99410WAGE
PETROLEUM SUPPLY SPECIALIST30375WAGE
PHARMACY TECHNICIAN12250OTHER
PHLEBOTOMIST12280OTHER
PHOTOFINISHING WORKER (Photo Lab Technician, Dark Room
Technician)99510TECHNICIAN
PHOTOGRAPHER I13071ADMIN SUPPORT/CLERICAL
PHOTOGRAPHER II13072ADMIN SUPPORT/CLERICAL
PHOTOGRAPHER III13073ADMIN SUPPORT/CLERICAL
PHOTOGRAPHER IV13074ADMIN SUPPORT/CLERICAL
PHOTOGRAPHER V13075ADMIN SUPPORT/CLERICAL
PHOTO-OPTICS TECHNICIAN30390TECHNICIAN
PIPEFITTER, MAINTENANCE23790WAGE
PLUMBER, MAINTENANCE23810WAGE
PLUMBER-MACHINIST47101WAGE
PNEUDRAULIC SYSTEMS MECHANIC23820WAGE
POLICE OFFICER I27131WAGE
POLICE OFFICER II27132WAGE
PRESSER, HAND16090WAGE
PRESSER, MACHINE, DRYCLEANING16110WAGE
PRESSER, MACHINE, SHIRTS16130WAGE
PRESSER, MACHINE, WEARING APPAREL, LAUNDRY16160WAGE
PRODUCTION CONTROL CLERK01270ADMIN SUPPORT/CLERICAL
PRODUCTION LINE WORKER (FOOD PROCESSING)21080WAGE
PRUNER11260WAGE
PUMPMAN, CHIEF PUMPMAN, QMED/PUMPMAN, SECOND PUMPMAN,
SECOND PUMPMAN/ENGINE MECHANIC47201WAGE
QA OVERSIGHT REPRESENTATIVE IQAOR1ENGINEER/SCIENTIST
QA OVERSIGHT REPRESENTATIVE IIQAOR2ENGINEER/SCIENTIST
QUALITY CONTROL INSPECTOR99610TECHNICIAN
RADIATION CONTROL TECHNICIAN30395TECHNICIAN
RADIATOR REPAIR SPECIALIST05340WAGE
RADIO FREQUENCY ENGINEER IRFE1PROFESSIONAL
RADIO FREQUENCY ENGINEER IIRFE2PROFESSIONAL
RADIO FREQUENCY ENGINEER IIIRFE3PROFESSIONAL
RADIOLOGIC TECHNOLOGIST12305OTHER
RECREATION AIDE/HEALTH FACILITY ATTENDANT28510OTHER
RECREATION SPECIALIST28515OTHER
RECYCLING LABORER99710WAGE
RECYCLING SPECIALIST99711WAGE
REFRIGERATION ENGINEER47301WAGE
REFUSE COLLECTOR99730WAGE
REGISTERED NURSE I12311OTHER
REGISTERED NURSE II12312OTHER
REGISTERED NURSE II, SPECIALIST12313OTHER
REGISTERED NURSE III12314OTHER
REGISTERED NURSE III, ANESTHETIST12315OTHER
REGISTERED NURSE IV12316OTHER
RENTAL CLERK01290ADMIN SUPPORT/CLERICAL
RETAIL AUTOMOTIVE DETAILER06500WAGE
RETAIL AUTOMOTIVE HELPER06510WAGE
RETAIL AUTOMOTIVE TECHNICIAN06520WAGE
RETAIL LUBRICATION TECHNICIAN06530WAGE
RETAIL TIRE SERVICE WORKER06540WAGE
RIGGER23850WAGE
SALES CLERK99810ADMIN SUPPORT/CLERICAL
SCALE MECHANIC23870WAGE
SCHEDULER (Drug and Alcohol Testing)12317OTHER
SCHEDULER, MAINTENANCE01300ADMIN SUPPORT/CLERICAL
SCHOOL CROSSING GUARD99820OTHER
SCIENTIST IS1ENGINEER/SCIENTIST
SCIENTIST IIS2ENGINEER/SCIENTIST
SCIENTIST IIIS3ENGINEER/SCIENTIST
SEAMAN (ABLE SEAMAN, WATCH ; ABLE SEAMAN, MAINTENANCE;ABLE SEAMAN, DAY/DECK UTILITY; ORDINARY
SEAMAN)47401WAGE
SECRETARY I01311ADMIN SUPPORT/CLERICAL
SECRETARY II01312ADMIN SUPPORT/CLERICAL
SECRETARY III01313ADMIN SUPPORT/CLERICAL
SECURITY PROGRAM MANAGER ISPM1PROFESSIONAL
SECURITY PROGRAM MANAGER IISPM2PROFESSIONAL
SECURITY PROGRAM MANAGER IIISPM3PROFESSIONAL
SENIOR RETAIL AUTOMOTIVE TECHNICIAN06550WAGE
SERVICE ORDER DISPATCHER01320ADMIN SUPPORT/CLERICAL
SEWAGE PLANT OPERATOR25040WAGE
SEWING MACHINE OPERATOR16190WAGE
SHEET-METAL WORKER, MAINTENANCE23890WAGE
SHIP COST ESTIMATORSCEPROFESSIONAL
SHIPPING PACKER21110WAGE
SHIPPING/RECEIVING CLERK21130ADMIN SUPPORT/CLERICAL
SHUTTLE BUS DRIVER (Van Driver)31290WAGE
SINGLE POINT ENTRY MONITOR27210WAGE
SLASH PILER/BURNER08310WAGE
SMALL ENGINE MECHANIC23910WAGE
SOFTWARE ENGINEER ISEGIPROFESSIONAL
SOFTWARE ENGINEER IISEG2PROFESSIONAL
SOFTWARE ENGINEER IIISEG3PROFESSIONAL
SPECIALIST, CONFIGURATION MANAGEMENT ISCM1PROFESSIONAL
SPECIALIST, CONFIGURATION MANAGEMENT IISCM2PROFESSIONAL
SPECIALIST, CONFIGURATION MANAGEMENT IIISCM3PROFESSIONAL
SPECIALIST, CORROSION CONTROL ISCC1ENGINEER/SCIENTIST
SPECIALIST, CORROSION CONTROL IISCC2ENGINEER/SCIENTIST
SPECIALIST, CORROSION CONTROL IIISCC3ENGINEER/SCIENTIST
SPECIALIST, EMERGENCY MANAGEMENTSEMPROFESSIONAL
SPECIALIST, IA COMPLIANCE ISIAC1INFORMATION TECHNOLOGY
SPECIALIST, IA COMPLIANCE IISIAC2INFORMATION TECHNOLOGY
SPECIALIST, IA COMPLIANCE IIISIAC3INFORMATION TECHNOLOGY
SPECIALIST, INFORMATION SYSTEM SECURITY ISISS1INFORMATION TECHNOLOGY
SPECIALIST, INFORMATION SYSTEM SECURITY IISISS2INFORMATION TECHNOLOGY
SPECIALIST, INFORMATION SYSTEM SECURITY IIISISS3INFORMATION TECHNOLOGY
SPECIALIST, PUBLIC AFFAIRS ISPA1PROFESSIONAL
SPECIALIST, PUBLIC AFFAIRS IISPA2PROFESSIONAL
SPECIALIST, PUBLIC AFFAIRS IIISPA3PROFESSIONAL
SPECIALIST, QUALITY CONTROL ISQC1PROFESSIONAL
SPECIALIST, QUALITY CONTROL IISQC2PROFESSIONAL
SPECIALIST, QUALITY CONTROL IIISQC3PROFESSIONAL
SPECIALIST, QUALITY CONTROL IVSQC4PROFESSIONAL
SPECIALIST, SECURITY ISS1PROFESSIONAL
SPECIALIST, SECURITY IISS2PROFESSIONAL
SPECIALIST, SECURITY IIISS3PROFESSIONAL
SPECIALIST, TRAINING IST1PROFESSIONAL
SPECIALIST, TRAINING IIST2PROFESSIONAL
SPECIALIST, TRAINING IIIST3PROFESSIONAL
SPORTS OFFICIAL28630OTHER
STATIONARY ENGINEER25070WAGE
STEVEDORE I29041WAGE
STEVEDORE II29042WAGE
STEWARD ASSISTANT/GALLEY UTILITYMAN/MESSMAN47501WAGE
STOCK CLERK (Shelf Stocker; Store Worker II)21150WAGE
STORE WORKER I21140WAGE
STUDENTSTUOTHER
SUBSAFE PROGRAM DIRECTORSPDPROFESSIONAL
SUBSTANCE ABUSE TREATMENT COUNSELOR12320OTHER
SUPPLY TECHNICIAN01410ADMIN SUPPORT/CLERICAL
SURVEY PARTY CHIEF (Chief of Party)99830WAGE
SURVEY WORKER (Interviewer)01420ADMIN SUPPORT/CLERICAL
SURVEYING AIDE99831WAGE
SURVEYING TECHNICIAN (Instrument Person; Surveyor Assistant,99832WAGE
SWIMMING POOL OPERATOR28690OTHER
SWITCHBOARD OPERATOR/RECEPTIONIST01460ADMIN SUPPORT/CLERICAL
SYSTEM SUPPORT SPECIALIST14170INFORMATION TECHNOLOGY
SYSTEMS ADMINISTRATOR ISA1INFORMATION TECHNOLOGY
SYSTEMS ADMINISTRATOR IISA2INFORMATION TECHNOLOGY
SYSTEMS ADMINISTRATOR IIISA3INFORMATION TECHNOLOGY
SYSTEMS ADMINISTRATOR IVSA4INFORMATION TECHNOLOGY
TAILOR16220WAGE
TAX PREPAIRER30410ADMIN SUPPORT/CLERICAL
TAX PREPAIRER (SENIOR)30411ADMIN SUPPORT/CLERICAL
TAXI DRIVER31310WAGE
TECHNICAL EDITOR, SUPERVISORY ITES1
TECHNICAL EDITOR, SUPERVISORY IITES2
TECHNICAL EDITOR, SUPERVISORY IIITES3
TECHNICAL INSTRUCTOR15090ADMIN SUPPORT/CLERICAL
TECHNICAL INSTRUCTOR/COURSE DEVELOPER15095ADMIN SUPPORT/CLERICAL
TECHNICAL ORDER LIBRARY CLERK13090ADMIN SUPPORT/CLERICAL
TECHNICAL WRITER I30461TECHNICIAN
TECHNICAL WRITER II30462TECHNICIAN
TECHNICAL WRITER III30463TECHNICIAN
TECHNICAL WRITER, SUPERVISORYTECWPROFESSIONAL
TELECOMMUNICATIONS MECHANIC I23931INFORMATION TECHNOLOGY
TELECOMMUNICATIONS MECHANIC II23932INFORMATION TECHNOLOGY
TELEPHONE LINEMAN23950INFORMATION TECHNOLOGY
TEST PROCTOR15110ADMIN SUPPORT/CLERICAL
TIRE REPAIRER05370WAGE
TOOL AND DIE MAKER19040WAGE
TOOLS AND PARTS ATTENDANT (Tool Crib Attendant)21210WAGE
TRACTOR OPERATOR11270WAGE
TRAIL MAINTENANCE WORKER11330WAGE
TRANSMISSION REPAIR SPECIALIST05400WAGE
TRAVEL CLERK I01531ADMIN SUPPORT/CLERICAL
TRAVEL CLERK II01532ADMIN SUPPORT/CLERICAL
TRAVEL CLERK III01533ADMIN SUPPORT/CLERICAL
TREE CLIMBER08340WAGE
TREE PLANTER08370WAGE
TREE PLANTER, MECHANICAL08400WAGE
TRUCK DRIVER, HEAVY31363WAGE
TRUCK DRIVER, LIGHT31361WAGE
TRUCK DRIVER, MEDIUM31362WAGE
TRUCK DRIVER, TRACTOR-TRAILER31364WAGE
TRUCKDRIVER31360WAGE
TUG BOAT OPERATOR/ENGINEER47601WAGE
TUTOR15120ADMIN SUPPORT/CLERICAL
UNEXPLODED (UXO) SAFETY ESCORT30494TECHNICIAN
UNEXPLODED (UXO) SWEEP PERSONNEL30495TECHNICIAN
UNEXPLODED ORDNANCE (UXO) TECHNICIAN I30491TECHNICIAN
UNEXPLODED ORDNANCE (UXO) TECHNICIAN II30492TECHNICIAN
UNEXPLODED ORDNANCE (UXO) TECHNICIAN III30493TECHNICIAN
UNLICENSED JUNIOR ENGINEER/QUALIFIED MEMBER OF THE
ENGINE DEPARTMENT [QMED]/DECK ENGINE MECHANIC47701WAGE
UPHOLSTERER09130WAGE
VENDING MACHINE ATTENDANT99840WAGE
VENDING MACHINE REPAIRER (Coin Machine Service Repairer)99841WAGE
VENDING MACHINE REPAIRER HELPER99842WAGE
VENTILATION EQUIPMENT TENDER25190WAGE
VIDEO TELECONFERENCE TECHNICIAN13110INFORMATION TECHNOLOGY
WAITER/WAITRESS07260WAGE
WAREHOUSE SPECIALIST (Warehouse Worker)21410WAGE
WASHER, MACHINE (Washman)16250WAGE
WATER TREATMENT PLANT OPERATOR25210WAGE
WEATHER FORECASTER I30501OTHER
WEATHER FORECASTER II30502OTHER
WEATHER OBSERVER, COMBINED UPPER AIR OR SURFACE
PROGRAMS (Meteorological Technician)30620TECHNICIAN
WEATHER OBSERVER, SENIOR (Meteorological Technician, Senior)30621TECHNICIAN
WEB AND DIGITAL INTERFACE DESIGNER IWDD1
WEB AND DIGITAL INTERFACE DESIGNER IIWDD2
WEB AND DIGITAL INTERFACE DESIGNER IIIWDD3
WELDER, COMBINATION, MAINTENANCE23960WAGE
WELL DRILLER23965WAGE
WILDLIFE TECHNICIAN91750TECHNICIAN
WINDOW CLEANER11360WAGE
WIPER47801WAGE
WOODCRAFT WORKER23970WAGE
WOODWORKER23980WAGE
WORD PROCESSOR I01611ADMIN SUPPORT/CLERICAL
WORD PROCESSOR II01612ADMIN SUPPORT/CLERICAL
WORD PROCESSOR III01613ADMIN SUPPORT/CLERICAL
WRANGLER I91811OTHER
WRANGLER II91812OTHER

MIDPOINT ESCALATION DEMO

NUWC Pricing Sheet

Colored = input cells
CONTRACT ESCALATION
'MM/DD/YRCALENDAR YEARRATE/YEAR
DATE OF ACTUALS1/1/24
Corey, Barbara J CIV NUWC NWPT: DATE OF ACTUALS: Based on labor rate effective date: (payroll, category averages, FPRR, SCLS etc.)45292.0202344927.03.30%

Corey, Barbara J CIV NUWC NWPT: RATE/YEAR: Proposed escalation rate is applied for each calendar year

START (Contract Start Date)1/1/2445292.0202445292.03.30%
COMPLETION (Contract End Date)12/31/2847118.0202545658.03.30%
# CONTRACT YEARS5.00202646023.03.30%
202746388.03.30%
202846753.03.30%
202947119.03.30%
CY

Corey, Barbara J CIV NUWC NWPT: CY = Calendar Year

DAYS

Corey, Barbara J CIV NUWC NWPT: DAYS = Number of days applicable for that calendar year. In this example CY 2024 has 365 days since the contract start date is 1/1/2024

RATE/YR

Corey, Barbara J CIV NUWC NWPT: RATE/YEAR = Based on number of DAYS applicable - prorated escalation rate calculated for each CY. For example: CY 2024 = 365 days a year multiplied by 3.30%

FACTOR

Corey, Barbara J CIV NUWC NWPT: FACTOR = Annual factor is determined by RATE/YR multiplied by prior RATE/YR. Resultant is multiplied by DAYS and FACTOR to determine DAILY rate

DAILY
DATA TO START202300.00%
DATA TO START202400.00%1.000
START TO END OF YR20243653.30%1.0171.017

Corey, Barbara J CIV NUWC NWPT: ESCALATION TO MIDPOINT: Sum of DAILY factors divided by number of contract years minus 1 = 8.59% for the period of performance

Corey, Barbara J CIV NUWC NWPT: DATE OF ACTUALS: Based on labor rate effective date: (payroll, category averages, FPRR, SCLS etc.)

Corey, Barbara J CIV NUWC NWPT: RATE/YEAR: Proposed escalation rate is applied for each calendar year

FIRST CY OF PERF20253653.30%1.0501.050
SECOND CY OF PERF20263653.30%1.0851.085
THIRD CY OF PERF20273653.30%1.1201.120
FOURTH CY OF PERF20283663.31%1.1581.161
FIFTH CY OF PERF202900.00%1.1760.000
ESCALATION TO MIDPOINT:8.59%
Midpoint escalation is calculated based on the "DATE OF ACTUALS."
- Date of Actuals is based on the labor rate effective date. (i.e. payroll, category averages, FPRRs, SCA, etc.)
The "START DATE" is contract start date.
The "COMPLETION DATE" is contract end date.
For cost realism purposes, the higher escalation rate: proposed or current NUWCDIVNPT Global Insight Rate (GIR) of 3.60% is applied in RATE/YR column
Calculation of the mid-point escalation factor for Non-SCLS rates is based on the effective date of the labor rates proposed.
Calculation of the mid-point escalation factor for SCLS rates is based on the planned award date.

image1.emf

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