excel spreadsheets - instructor's version

Columbus Custom Carpentry - Active EmployeesFirst Name Last Name Sex Age EEO FT/PT Status LOS Job Title Department Salary FLSA

Anthony Fox M 60 W Full-Time A 3.2 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $26,886 NonexemptChad Chafins M 22 W Full-Time A 1.8 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $24,886 NonexemptJeffrey Green M 38 B Full-Time A 13.7 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $28,239 NonexemptMolly Maynard F 29 W Full-Time FMLA 2.7 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $25,886 NonexemptDaniel Murray M 25 W Full-Time A 1.8 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $24,886 NonexemptBrook Reed M 40 W Full-Time A 1.9 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $24,886 NonexemptJames Reeves M 56 B Full-Time A 33.4 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $32,989 NonexemptBrian Kelley M 61 W Full-Time A 22.4 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $31,585 NonexemptScott Scott M 42 W Full-Time A 1.9 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $24,886 NonexemptRonnie Specht M 47 W Full-Time A 20.9 WAREHOUSE SUPERVISOR RAW MATERIALS WAREHOUSE $42,635 ExemptTerry Evans M 37 W Full-Time A 13.7 MACHINE OPERATOR PREPROCESSING $33,256 NonexemptStephen Hicks M 45 W Full-Time A 7.3 MACHINE OPERATOR PREPROCESSING $31,921 NonexemptBenny Woods M 45 W Full-Time A 0.9 MACHINE OPERATOR PREPROCESSING $28,000 NonexemptDon Rose M 47 W Full-Time A 2.0 MACHINE OPERATOR PREPROCESSING $29,862 NonexemptRoger Freck M 38 W Full-Time A 2.0 MACHINE OPERATOR PREPROCESSING $29,862 NonexemptChristopher Leffing M 62 W Full-Time A 9.6 MACHINE OPERATOR PREPROCESSING $32,254 NonexemptRaven Tatman M 58 W Full-Time A 3.6 MACHINE OPERATOR PREPROCESSING $30,326 NonexemptBrian Auer M 48 W Full-Time A 8.3 MACHINE OPERATOR PREPROCESSING $32,000 NonexemptNikki Messer F 36 W Full-Time FMLA 13.7 MACHINE OPERATOR PREPROCESSING $33,529 NonexemptTheresa Maynard F 44 W Full-Time A 1.0 MACHINE OPERATOR PREPROCESSING $28,000 NonexemptCheryl Rouse F 40 H Full-Time A 3.8 MACHINE OPERATOR PREPROCESSING $30,326 NonexemptKermit Justice M 51 W Full-Time A 20.0 MACHINE OPERATOR PREPROCESSING $37,232 NonexemptAnthony Glenn M 63 W Full-Time A 17.0 MACHINE OPERATOR PREPROCESSING $35,111 NonexemptLindsey Spaulding F 45 W Full-Time A 12.8 MACHINE OPERATOR PREPROCESSING $33,458 NonexemptLiam Porter M 50 B Full-Time A 7.8 MACHINE OPERATOR PREPROCESSING $31,667 NonexemptBarbara Houston F 38 W Full-Time A 10.6 MACHINE OPERATOR PREPROCESSING $32,642 NonexemptJacquelyn Davy F 41 W Full-Time A 11.1 MACHINE OPERATOR PREPROCESSING $32,789 NonexemptJoseph Dye M 32 W Full-Time A 1.8 MACHINE OPERATOR PREPROCESSING $29,644 NonexemptScott Locke M 61 W Full-Time A 20.9 MACHINE OPERATOR PREPROCESSING $37,232 NonexemptAndre Wagner M 37 W Full-Time A 1.9 MACHINE OPERATOR PREPROCESSING $29,421 NonexemptKelly Keeton F 29 W Full-Time A 1.6 CUSTOMER SERVICE MARKETING $32,000 ExemptAdam Howell M 55 W Full-Time A 2.6 CUSTOMER SERVICE MARKETING $33,000 ExemptJoann Thomas F 61 W Full-Time A 16.0 CUSTOMER SERVICE MARKETING $40,200 ExemptRosalie Maddox F 43 W Full-Time A 3.6 CUSTOMER SERVICE MARKETING $34,000 Exempt

Columbus Custom Carpentry - Active EmployeesFirst Name Last Name Sex Age EEO FT/PT Status LOS Job Title Department Salary FLSAJocelyn Ryan F 41 W Full-Time A 1.7 CUSTOMER SERVICE MARKETING $32,000 ExemptKevin Lindsey M 54 W Full-Time A 17.7 CUSTOMER SERVICE MARKETING $42,100 ExemptRoland Fleige M 29 W Full-Time A 1.9 CUSTOMER SERVICE MARKETING $30,098 ExemptDanielle Woods F 55 W Full-Time A 34.2 CUSTOMER SERVICE MARKETING $39,500 ExemptBrandon Swift M 47 W Full-Time A 14.9 MARKETING MANAGER MARKETING $110,000 ExemptCharles Watkins M 62 W Full-Time A 19.6 PRODUCT DESIGNER MARKETING $65,428 ExemptSteven Mauger M 54 W Full-Time A 24.8 PRODUCT DEVELOPMENT TECH MARKETING $30,285 ExemptClayton Starkey M 46 B Full-Time A 27.0 SALES MARKETING $52,566 ExemptKevin Roberts M 61 W Full-Time A 20.9 SALES (Inside) MARKETING $62,098 ExemptTony Lester M 59 W Full-Time A 28.2 SALES MARKETING $75,964 ExemptJames Monford M 52 W Full-Time A 29.6 SALES MARKETING $76,901 ExemptDerwin Bowyer M 63 W Full-Time A 11.3 MANUFACTURING MANAGER MANUFACTURING MANAGEMENT $103,000 ExemptMichael Respress M 36 B Full-Time A 18.3 MANUFACTURING SUPERVISOR MANUFACTURING MANAGEMENT $57,232 ExemptChad Dent M 48 W Full-Time A 2.0 MANUFACTURING SUPERVISOR MANUFACTURING MANAGEMENT $53,722 ExemptJohn Brown M 40 W Full-Time A 7.7 MANUFACTURING SUPERVISOR MANUFACTURING MANAGEMENT $54,266 ExemptKim Koranteng F 50 W Full-Time A 9.4 MANUFACTURING SUPERVISOR MANUFACTURING MANAGEMENT $55,414 ExemptStephen Stout M 60 W Full-Time A 8.2 PRODUCTION SCHEDULING SUPER MANUFACTURING MANAGEMENT $54,900 ExemptKaren Webb F 35 W Full-Time A 2.1 PURCHASING MANAGER MANUFACTURING MANAGEMENT $53,500 ExemptJames Bailey M 57 B Full-Time A 6.5 PAINT ROOM TECH FINISHING $35,175 NonexemptRose Orahood M 43 W Full-Time A 10.3 PAINT ROOM TECH FINISHING $36,300 NonexemptDouglas Muck M 38 W Full-Time A 9.8 PAINT ROOM TECH FINISHING $35,483 NonexemptDavid Hatfield M 43 W Full-Time A 11.1 PAINT ROOM TECH FINISHING $36,500 NonexemptBrian Barnett M 49 W Full-Time A 7.7 PAINT ROOM TECH FINISHING $35,950 NonexemptNikki Vasko F 40 W Full-Time A 14.6 PAINT ROOM TECH FINISHING $36,960 NonexemptGregory Howard M 34 B Full-Time A 3.7 PAINT ROOM TECH FINISHING $34,200 NonexemptAngela Lukas F 52 W Full-Time A 11.6 PAINT ROOM TECH FINISHING $36,963 NonexemptMichael Heselden M 34 W Full-Time A 8.1 PAINT ROOM TECH FINISHING $35,026 NonexemptCharles Junker M 48 B Full-Time A 1.1 PAINT ROOM TECH FINISHING $32,163 NonexemptLowell Gullett M 41 W Full-Time A 1.8 CRATER FINISHED GOODS WAREHOUSE $21,850 NonexemptTimothy Hemingway M 32 W Full-Time A 0.2 CRATER FINISHED GOODS WAREHOUSE $20,800 NonexemptDavid Coleman M 27 B Full-Time A 0.4 CRATER FINISHED GOODS WAREHOUSE $20,800 NonexemptRobert Kimber M 40 W Full-Time A 2.2 CRATER FINISHED GOODS WAREHOUSE $23,214 NonexemptMary Mccomas F 32 W Full-Time A 11.3 CRATER FINISHED GOODS WAREHOUSE $32,000 NonexemptMary Spencer F 21 W Full-Time A 0.3 CRATER FINISHED GOODS WAREHOUSE $20,800 NonexemptDaniel Dundon M 26 W Full-Time A 0.6 CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Columbus Custom Carpentry - Active EmployeesFirst Name Last Name Sex Age EEO FT/PT Status LOS Job Title Department Salary FLSALeigh Holdrieth M 34 W Full-Time A 1.7 CRATER FINISHED GOODS WAREHOUSE $22,880 NonexemptCharles Mahlman M 36 W Full-Time A 0.7 CRATER FINISHED GOODS WAREHOUSE $20,800 NonexemptSteven Weaver M 21 W Full-Time A 0.3 CRATER FINISHED GOODS WAREHOUSE $20,800 NonexemptRichard Griffin M 36 W Full-Time A 8.1 CRATER FINISHED GOODS WAREHOUSE $28,210 NonexemptVesta Bailey F 25 W Full-Time A 0.1 CRATER FINISHED GOODS WAREHOUSE $20,800 NonexemptStephen Moore M 33 W Full-Time A 0.4 CRATER FINISHED GOODS WAREHOUSE $20,800 NonexemptThomas Nechovski M 33 W Full-Time A 1.5 CRATER FINISHED GOODS WAREHOUSE $22,880 NonexemptDouglas Stange M 23 W Full-Time A 0.8 CRATER FINISHED GOODS WAREHOUSE $20,800 NonexemptMichelle Doss F 56 B Full-Time A 10.6 FORKLIFT FINISHED GOODS WAREHOUSE $32,800 NonexemptEdward Marcum M 40 W Full-Time A 9.7 FORKLIFT FINISHED GOODS WAREHOUSE $32,300 NonexemptAmy Hunt F 50 W Full-Time A 18.1 FORKLIFT FINISHED GOODS WAREHOUSE $34,426 NonexemptSherry Shipley F 22 W Full-Time A 3.0 FORKLIFT FINISHED GOODS WAREHOUSE $25,877 NonexemptBrooke Vasko F 30 W Full-Time FMLA 6.6 FORKLIFT FINISHED GOODS WAREHOUSE $27,110 NonexemptDonna Miles F 35 W Full-Time A 1.4 FORKLIFT FINISHED GOODS WAREHOUSE $24,886 NonexemptJunella Van Gundy F 47 W Full-Time A 3.2 FORKLIFT FINISHED GOODS WAREHOUSE $27,538 NonexemptKerry Wortman M 40 W Full-Time A 1.9 FORKLIFT FINISHED GOODS WAREHOUSE $24,886 NonexemptJohnny Herold M 49 W Full-Time A 5.2 FORKLIFT FINISHED GOODS WAREHOUSE $26,312 NonexemptHeidi Bobbs F 53 W Full-Time A 8.1 FORKLIFT FINISHED GOODS WAREHOUSE $31,255 NonexemptCary Dobbins M 62 W Full-Time A 1.9 WAREHOUSE MANAGER FINISHED GOODS WAREHOUSE $61,887 ExemptPaul Fusco M 60 W Full-Time A 20.0 CRATING SUPERVISOR FINISHED GOODS WAREHOUSE $59,681 ExemptShirley Swingle F 43 W Full-Time A 13.3 WAREHOUSE SUPERVISOR FINISHED GOODS WAREHOUSE $49,692 ExemptJohn Essen M 62 H Full-Time A 9.0 BUILDING SUPERVISOR CORPORATE SERVICES $43,119 ExemptLorenzo Tention M 38 H Full-Time A 10.5 CUSTODIAN CORPORATE SERVICES $34,726 ExemptDrew Morris M 38 W Full-Time A 7.5 HANDYMAN CORPORATE SERVICES $37,145 ExemptDaniel Gray M 65 B Full-Time A 28.3 MAIL/SHIPPING CLERK CORPORATE SERVICES $27,726 ExemptOpen Position M 50 W Full-Time A 21.1 DIRECTOR OF HR CORPORATE $70,000 ExemptBarbara Duff F 55 W Full-Time A 1.6 ADMINISTRATIVE ASSISTANT CORPORATE $52,394 ExemptAnthony Cooney M 58 W Full-Time A 30.6 PRESIDENT CORPORATE $145,000 ExemptDesiree Jones F 51 W Full-Time A 8.5 RECEPTIONIST/OFFICE CLERK CORPORATE $38,214 ExemptJennifer Reen F 35 W Full-Time A 2.6 RECEPTIONIST/OFFICE CLERK CORPORATE $31,000 ExemptJacquelin Campbell F 26 B Full-Time A 1.7 PRODUCTION TECH ASSEMBLY $28,500 NonexemptDonald Mccarty M 34 W Full-Time A 1.8 PRODUCTION TECH ASSEMBLY $28,500 NonexemptJohn Charles M 39 W Full-Time A 1.8 PRODUCTION TECH ASSEMBLY $28,500 NonexemptChristina Phillips F 45 W Full-Time A 1.8 PRODUCTION TECH ASSEMBLY $28,500 NonexemptMichael Oswalt M 37 W Full-Time A 1.8 PRODUCTION TECH ASSEMBLY $28,500 Nonexempt

Columbus Custom Carpentry - Active EmployeesFirst Name Last Name Sex Age EEO FT/PT Status LOS Job Title Department Salary FLSAGwen Wildermuth F 29 W Full-Time A 2.1 PRODUCTION TECH ASSEMBLY $29,500 NonexemptAndre Riley M 39 H Full-Time A 2.1 PRODUCTION TECH ASSEMBLY $29,500 NonexemptJeffrey Weiland M 26 W Full-Time A 3.0 PRODUCTION TECH ASSEMBLY $30,500 NonexemptCharles Kalb M 23 W Full-Time A 3.1 PRODUCTION TECH ASSEMBLY $30,500 NonexemptJohn Carver M 24 W Full-Time A 3.3 PRODUCTION TECH ASSEMBLY $30,500 NonexemptToni Jones F 30 W Full-Time FMLA 3.4 PRODUCTION TECH ASSEMBLY $30,942 NonexemptKelly Hicks F 42 W Full-Time A 3.4 PRODUCTION TECH ASSEMBLY $30,921 NonexemptJoe Samczuk M 37 W Full-Time A 3.4 PRODUCTION TECH ASSEMBLY $32,121 NonexemptTerry Montavon M 56 H Full-Time A 3.6 PRODUCTION TECH ASSEMBLY $32,224 NonexemptShawn Webb M 43 W Full-Time A 5.2 PRODUCTION TECH ASSEMBLY $33,417 NonexemptKimberly Smith F 35 W Full-Time A 5.2 PRODUCTION TECH ASSEMBLY $32,417 NonexemptMichael Pierce M 48 W Full-Time A 5.2 PRODUCTION TECH ASSEMBLY $33,621 NonexemptDaniel Brown M 40 W Full-Time A 5.3 PRODUCTION TECH ASSEMBLY $33,511 NonexemptGregory Foreman M 41 W Full-Time A 7.9 PRODUCTION TECH ASSEMBLY $34,998 NonexemptBrian Riley M 48 W Full-Time A 8.4 PRODUCTION TECH ASSEMBLY $34,815 NonexemptDeanna Diles F 30 W Full-Time A 9.2 PRODUCTION TECH ASSEMBLY $32,417 NonexemptGregory Ward M 53 W Full-Time A 10.1 PRODUCTION TECH ASSEMBLY $35,256 NonexemptRichard Williams M 36 W Full-Time A 10.4 PRODUCTION TECH ASSEMBLY $35,500 NonexemptYancey Staats M 42 W Full-Time A 10.9 PRODUCTION TECH ASSEMBLY $35,918 NonexemptBobby Mox M 40 W Full-Time A 11.1 PRODUCTION TECH ASSEMBLY $36,959 NonexemptStephen Hand M 29 W Full-Time A 11.3 PRODUCTION TECH ASSEMBLY $36,989 NonexemptCarla Klinedinst F 37 W Full-Time A 14.8 PRODUCTION TECH ASSEMBLY $37,294 NonexemptRonald Bowen M 39 W Full-Time A 15.6 PRODUCTION TECH ASSEMBLY $37,345 NonexemptJoey Jackson M 43 W Full-Time A 22.1 PRODUCTION TECH ASSEMBLY $38,232 NonexemptNathan Smith M 55 B Full-Time A 26.4 PRODUCTION TECH ASSEMBLY $38,875 NonexemptBonnie Blair F 43 W Full-Time A 1.5 AP CLERK ACCOUNTING $27,200 ExemptSue Ranke F 64 W Full-Time A 25.5 AR CLERK ACCOUNTING $29,293 ExemptJacquetta Guinn F 62 B Full-Time A 13.9 AR CLERK ACCOUNTING $28,688 ExemptMichael Cooney M 31 W Full-Time A 3.3 CFO ACCOUNTING $87,250 ExemptMatthew Lee M 41 A Full-Time A 9.7 DATABASE MANAGER ACCOUNTING $57,000 ExemptYolanda Harris F 48 W Full-Time A 12.4 STAFF ACCOUNTANT ACCOUNTING $49,528 Exempt

Columbus Custom Carpentry - Terminated EmployeesFirst NameLast NameSex Age EEO Status Rehire Hiredate LOS Term Date Term Reason Job Title Department Salary FLSASandra Chatman F 29 W T No 9/21/1999### 5.0 9/19/2004 Work Rule Violation FORKLIFT RAW MATERIALS WAREHOUSE $30,056 Nonexempt

Mark Karr M 41 W T Yes 12/26/1995### 8.8 9/26/2004 Accepted New Job FORKLIFT RAW MATERIALS WAREHOUSE $32,800 Nonexempt

Todd Collver M 57 W T No 6/25/2003### 1.3 9/26/2004 Poor Job Fit FORKLIFT RAW MATERIALS WAREHOUSE $25,110 Nonexempt

Maggie Hyer F 48 W T No 11/21/2000### 3.9 10/10/2004 Poor Performance FORKLIFT RAW MATERIALS WAREHOUSE $27,538 Nonexempt

Angela West F 44 W T Yes 12/7/1996### 7.9 11/14/2004 Accepted New Job FORKLIFT RAW MATERIALS WAREHOUSE $31,426 Nonexempt

Paula Day F 50 W T No 5/13/2004### 0.6 12/4/2004 Job Abandonment FORKLIFT RAW MATERIALS WAREHOUSE $25,877 Nonexempt

Daniel Davis M 47 B T Yes 2/9/1988### 16.8 12/4/2004 Accepted New Job FORKLIFT RAW MATERIALS WAREHOUSE $31,255 Nonexempt

Karen Nair F 35 W T No 10/20/2004### 0.1 12/6/2004 Poor Attendance FORKLIFT RAW MATERIALS WAREHOUSE $24,886 Nonexempt

Craig Johnson M 43 W T Yes 2/18/2003### 1.8 12/7/2004 Medical - Non-Job Related FORKLIFT RAW MATERIALS WAREHOUSE $26,333 Nonexempt

Timothy Davis M 31 W T Yes 9/24/2002### 2.3 1/2/2005 Accepted New Job FORKLIFT RAW MATERIALS WAREHOUSE $28,056 Nonexempt

Julius Deichman M 42 W T Yes 12/28/1999### 5.0 1/2/2005 Accepted New Job FORKLIFT RAW MATERIALS WAREHOUSE $30,056 Nonexempt

Larry Dunlap M 23 W T No 8/31/2004### 0.4 1/8/2005 Poor Attendance FORKLIFT RAW MATERIALS WAREHOUSE $26,312 Nonexempt

Kenneth Pomeroy M 65 W T Yes 10/6/1971### 33.3 2/7/2005 Retirement - Normal FORKLIFT RAW MATERIALS WAREHOUSE $42,619 Nonexempt

Stephen Johnson M 43 B T Yes 11/23/2004### 0.2 2/16/2005 Accepted New Job FORKLIFT RAW MATERIALS WAREHOUSE $24,886 Nonexempt

Peter Stickle M 42 W T Yes 5/21/1998### 6.7 2/16/2005 Accepted New Job WAREHOUSE SUPERVISOR RAW MATERIALS WAREHOUSE $44,932 Exempt

Paula Moore F 23 W T No 12/20/2005### 0.2 3/7/2006 Poor Attendance MACHINE OPERATOR PREPROCESSING $26,000 Nonexempt

Carmen Mcclintock F 25 W T No 11/22/2005### 0.3 3/7/2006 Job Abandonment MACHINE OPERATOR PREPROCESSING $26,000 Nonexempt

Donald Conley M 24 W T No 2/1/2006### 0.1 3/12/2006 Poor Performance MACHINE OPERATOR PREPROCESSING $26,000 Nonexempt

Jerry Hairston M 39 W T No 3/7/2006### 0.0 3/13/2006 Job Dissatisfaction MACHINE OPERATOR PREPROCESSING $26,000 Nonexempt

Daniel Processes apM 26 W T No 1/10/2006### 0.2 3/20/2006 Job Dissatisfaction MACHINE OPERATOR PREPROCESSING $26,000 Nonexempt

Jason Mann M 23 W T No 2/21/2006### 0.1 4/10/2006 Poor Performance MACHINE OPERATOR PREPROCESSING $26,000 Nonexempt

James Wheeler M 28 W T No 12/8/2005### 0.4 4/17/2006 Poor Performance MACHINE OPERATOR PREPROCESSING $26,000 Nonexempt

Sylvia Responsibili F 33 I T Yes 9/23/1997### 6.5 4/7/2004 Career Change CUSTOMER SERVICE Marketing $36,292 Exempt

Ryan Satterfield M 67 W T Yes 9/8/1981### 22.6 4/7/2004 Retirement - Early CUSTOMER SERVICE Marketing $38,000 Exempt

Marsha Kennedy F 36 A T Yes 4/1/1997### 7.1 5/4/2004 Pay CUSTOMER SERVICE Marketing $28,500 Exempt

Donald Holmes M 37 W T Yes 10/15/1996### 7.6 5/12/2004 Pay CUSTOMER SERVICE Marketing $32,647 Exempt

Johnnie Wormack M 39 W T Yes 2/21/1987### 17.3 5/24/2004 Career Change CUSTOMER SERVICE Marketing $35,651 Exempt

Todd Lamb M 42 W T No 5/25/1990### 14.0 6/8/2004 Work Rule Violation CUSTOMER SERVICE Marketing $34,378 Exempt

John Assembles prM 51 W T Yes 6/27/1996### 8.0 6/30/2004 Pay SALES Marketing $37,088 Exempt

Misty Hu F 47 A T Yes 10/4/2000### 3.8 7/21/2004 Pay SALES Marketing $35,090 Exempt

Michael Houtz M 46 W T No 5/16/2006### 0.1 6/24/2006 Poor Performance MANUFACTURING SUPERVISOR MANUFACTURING MANAGEMENT $57,123 Nonexempt

William Chambers M 34 W T Yes 5/9/2006### 0.2 7/15/2006 Accepted New Job MANUFACTURING SUPERVISOR MANUFACTURING MANAGEMENT $57,123 Exempt

Columbus Custom Carpentry - Terminated EmployeesFirst NameLast NameSex Age EEO Status Rehire Hiredate LOS Term Date Term Reason Job Title Department Salary FLSAJames Barnett M 36 W T Yes 6/9/1998### 5.7 2/17/2004 Pay PAINT ROOM TECH FINISHING $28,891 Nonexempt

Rebecca Same as asseF 48 W T No 2/24/2004### 0.0 3/1/2004 Pay PAINT ROOM TECH FINISHING $26,000 Nonexempt

Bradley Godwin M 54 W T No 2/2/1999### 5.1 3/24/2004 Violence - Threat/Act PAINT ROOM TECH FINISHING $29,000 Nonexempt

Laura Heath F 66 W T No 4/29/1986### 17.9 3/31/2004 Medical - Job Related PAINT ROOM TECH FINISHING $29,290 Nonexempt

Lewis Colling M 52 B T No 5/13/2001### 2.7 2/2/2004 Resigned in lieu of Term CRATER FINISHED GOODS WAREHOUSE $21,850 Nonexempt

ChristopherCrabtree M 67 W T Yes 3/16/1993### 10.9 2/2/2004 Pay CRATER FINISHED GOODS WAREHOUSE $26,112 Nonexempt

Joshua Same as asseM 43 W T No 3/8/2003### 0.9 2/10/2004 Resigned in lieu of Term CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Kendra Mcfarland F 39 W T Yes 7/20/1992### 12.0 7/21/2004 Pay CRATER FINISHED GOODS WAREHOUSE $26,333 Nonexempt

Rick Tribby M 57 B T Yes 7/24/2001### 3.0 7/28/2004 Pay CRATER FINISHED GOODS WAREHOUSE $22,880 Nonexempt

Sheila Brown F 52 W T Yes 12/19/2002### 1.6 7/28/2004 Pay CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Lee Chinn M 42 A T No 4/19/1984### 20.3 7/28/2004 Pay CRATER FINISHED GOODS WAREHOUSE $28,891 Nonexempt

Lisa Porter F 30 W T No 5/21/2002### 2.2 8/2/2004 Work Rule Violation CRATER FINISHED GOODS WAREHOUSE $22,880 Nonexempt

Malcolm Trapp M 33 W T Yes 10/29/2002### 1.8 8/8/2004 Career Change CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Stephen Farmer M 52 W T No 8/13/2003### 1.0 8/21/2004 Poor Performance CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Michael Harshman M 44 W T No 11/5/2002### 1.8 8/30/2004 Accepted New Job CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Darrin Read M 51 B T No 3/16/2004### 0.5 9/1/2004 Job Abandonment CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Robert Ball M 48 W T No 4/4/2000### 4.4 9/15/2004 Work Rule Violation CRATER FINISHED GOODS WAREHOUSE $28,371 Nonexempt

Brendan Hughes M 52 W T Yes 11/16/2004### 0.5 5/23/2005 Accepted New Job CRATER FINISHED GOODS WAREHOUSE $18,720 Nonexempt

Aaron Palmer M 51 W T Yes 9/24/1996### 8.7 5/25/2005 Pay CRATER FINISHED GOODS WAREHOUSE $28,210 Nonexempt

Alice Long F 33 W T No 7/19/2000### 4.9 6/7/2005 Resigned in lieu of Term CRATER FINISHED GOODS WAREHOUSE $22,880 Nonexempt

ChristopherRhoades M 40 W T Yes 1/7/1997### 8.5 7/17/2005 Medical - Non-Job Related CRATER FINISHED GOODS WAREHOUSE $28,210 Nonexempt

Dennis Perrigo M 29 H T Yes 12/1/1998### 6.7 8/3/2005 Career Change CRATER FINISHED GOODS WAREHOUSE $23,689 Nonexempt

Toni Mehling F 47 W T Yes 10/3/2001### 3.9 8/10/2005 Pay CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

David Connell M 55 W T No 9/3/1996### 9.0 8/20/2005 Resigned in Lieu of Termina CRATER FINISHED GOODS WAREHOUSE $23,214 Nonexempt

Laura Handles mor F 27 W T Yes 4/15/2003### 2.4 8/31/2005 Accepted New Job CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Mohan Schroeder M 40 W T Yes 6/6/1995### 10.2 8/31/2005 Accepted New Job CRATER FINISHED GOODS WAREHOUSE $25,016 Nonexempt

Todd Seevers M 67 W T Yes 3/25/1986### 19.4 9/2/2005 Pay CRATER FINISHED GOODS WAREHOUSE $27,123 Nonexempt

Michael Rieck M 37 W T No 3/30/2001### 4.5 10/3/2005 Poor Performance CRATER FINISHED GOODS WAREHOUSE $22,318 Nonexempt

John Sellner M 68 W T Yes 6/30/1998### 7.3 10/3/2005 Retirement - Normal CRATER FINISHED GOODS WAREHOUSE $24,665 Nonexempt

Chip Chang M 33 H T Yes 11/19/2002### 2.9 10/5/2005 Personal Reasons CRATER FINISHED GOODS WAREHOUSE $23,036 Nonexempt

Carolyn Same as ForkF 29 W T No 7/18/2000### 5.2 10/12/2005 Work Rule Violation CRATER FINISHED GOODS WAREHOUSE $23,085 Nonexempt

Octavia Richardson F 31 W T Yes 12/12/2000### 4.8 10/12/2005 Accepted New Job CRATER FINISHED GOODS WAREHOUSE $22,880 Nonexempt

Columbus Custom Carpentry - Terminated EmployeesFirst NameLast NameSex Age EEO Status Rehire Hiredate LOS Term Date Term Reason Job Title Department Salary FLSAGeorge Hurles M 45 W T Yes 1/4/2005### 0.8 10/19/2005 Accepted New Job CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Matthew Lozier M 45 W T Yes 2/13/2003### 2.7 10/26/2005 Accepted New Job CRATER FINISHED GOODS WAREHOUSE $22,880 Nonexempt

Bradford Performs maiM 54 W T No 3/1/1988### 17.7 11/2/2005 Poor Performance CRATER FINISHED GOODS WAREHOUSE $27,123 Nonexempt

Phillip West M 54 W T No 5/19/1981### 24.5 11/12/2005 Deceased CRATER FINISHED GOODS WAREHOUSE $30,950 Nonexempt

John Morris M 28 W T Yes 7/7/1998### 7.4 11/29/2005 Career Change CRATER FINISHED GOODS WAREHOUSE $24,150 Nonexempt

Carl M 43 W T Yes 11/24/1998### 7.0 12/7/2005 Accepted New Job CRATER FINISHED GOODS WAREHOUSE $24,247 Nonexempt

Dwight Lane M 43 W T Yes 11/29/2005### 0.0 12/10/2005 Work Conditions/RequiremeCRATER FINISHED GOODS WAREHOUSE $18,720 Nonexempt

John Everett M 57 W T No 3/9/1993### 12.8 12/18/2005 Medical - Non-Job Related CRATER FINISHED GOODS WAREHOUSE $30,950 Nonexempt

Lance Nichols M 53 W T No 1/17/2006### 0.1 2/8/2006 Personal Reasons CRATER FINISHED GOODS WAREHOUSE $20,800 Nonexempt

Suzette Baker F 43 W T No 8/25/1998### 6.6 3/30/2005 Personal Reasons WAREHOUSE MANAGER FINISHED GOODS WAREHOUSE $65,813 Exempt

James Carpenter M 49 W T No 9/8/1987### 17.4 2/19/2005 Medical - Job Related WAREHOUSE SUPERVISOR FINISHED GOODS WAREHOUSE $49,619 Exempt

Jennifer F 34 W T Yes 6/27/2002### 2.8 3/28/2005 Employee Relocation WAREHOUSE SUPERVISOR FINISHED GOODS WAREHOUSE $47,600 Exempt

Terrance Brown M 43 B T Yes 3/7/2006### 0.3 6/29/2006 Accepted New Job CUSTODIAN CORPORATE SERVICES $30,150 Nonexempt

Richard Ables M 39 W T No 3/21/2006### 0.3 6/25/2006 Poor Attendance MAIL/SHIPPING CLERK CORPORATE SERVICES $30,950 Exempt

Crystal Performs inf F 43 W T Yes 12/2/1997### 8.8 9/12/2006 Accepted New Job Receptionist/Clerk Corporate $34,230 Exempt

Eric Smith M 43 W T No 4/11/2006### 0.0 4/18/2006 Failed Drug/Alcohol Screen PRODUCTION TECH ASSEMBLY $27,123 Nonexempt

Jerry Mowbray M 27 W T Yes 9/23/2003### 2.6 4/26/2006 Accepted New Job PRODUCTION TECH ASSEMBLY $30,700 Nonexempt

Brett Morris M 31 W T No 2/21/2006### 0.2 5/3/2006 Poor Performance PRODUCTION TECH ASSEMBLY $30,950 Nonexempt

John Howard M 41 W T Yes 4/22/1988### 18.1 5/24/2006 Career Change PRODUCTION TECH ASSEMBLY $35,712 Nonexempt

Kamila Roberts F 50 H T Yes 7/6/1989### 16.9 5/31/2006 Personal Reasons PRODUCTION TECH ASSEMBLY $35,653 Nonexempt

Michael Hall M 54 W T No 12/13/2005### 0.5 6/3/2006 Poor Attendance PRODUCTION TECH ASSEMBLY $30,950 Nonexempt

Louis M 55 W T No 5/9/2006### 0.1 6/18/2006 Poor Job Fit PRODUCTION TECH ASSEMBLY $30,950 Nonexempt

Timothy Lemaster M 29 W T Yes 2/1/2006### 0.5 7/19/2006 Accepted New Job PRODUCTION TECH ASSEMBLY $30,950 Nonexempt

Linda Smith F 35 W T Yes 8/8/2000### 6.0 7/30/2006 Accepted New Job PRODUCTION TECH ASSEMBLY $31,680 Nonexempt

Scott Boling M 36 W T No 10/27/1992### 13.8 8/23/2006 Work Rule Violation PRODUCTION TECH ASSEMBLY $33,886 Nonexempt

ChristopherSwingle M 56 W T No 12/15/1999### 6.7 8/23/2006 Poor Performance PRODUCTION TECH ASSEMBLY $31,886 Nonexempt

Amy Perkins F 63 W T Yes 4/21/1992### 14.1 6/8/2006 Retirement - Early AR CLERK Accounting $36,150 Nonexempt

Works to ensure offices and other specified areas are kept in a clean and orderly condition. May require a high school diploma or its equivalent. No experience necessary. Has knowledge of commonly used concepts, practices and procedures within a particula r field. Relies on instructions and pre-established guidelines to perform the functions of the job. Works under immediate supervision. Typically reports to a supervisor.

Designs and administers human resource policies in a small company or in limited functional areas of a larger company. Analyzes HR data and makes recommendations to management regarding solutions to identified problems. Processes HR or payroll-related pap erwork. Prepares internal employee communications. Requires a bachelor's degree or related experience. Must have knowledge of HR practices and legal issues. Performs a variety of tasks. May lead and direct the work of nonmanagement employees. May report to a senior HR manager or directly to a line executive.

Creates nonstandard jigs, fixtures, clamps and special tools for manufacturing operations. Tests jigs for function and tolerances. Responsible for determining production methods and sequence of operations and assists with establishing standard procedures for work to be performed using these jigs or fixtures. Requires a high school diploma or GED and at least 5 years of experience. Relies on experience and judgment to performs a variety of tasks. A high degree of creativity and latitude is required.

Effective dates of collected dataA=Oct 1 of the year prior to the case year

B=April 1 of the year 3 years prior to the case yearC=Oct 1 of the year prior to the case yearD = April 1, 2 years prior to the case year

Salary DataInformation compiled by the administrative assistant Source 25th 50th 75th Accounting Clerk A-2 Accounting Clerk $ 27,640 $ 31,220 $ 34,810

B-19 Accounting Clerk $ 25,200 $ 28,000 $ 30,700 C-26 Accounting Clerk $ 28,240 $ 30,410 $ 32,790

Accountant, General A-1 Accountant, General $ 46,350 $ 51,810 $ 57,790

B-1 Accountant, General $ 36,900 $ 40,300 $ 44,100 C-1 Accountant, General $ 42,050 $ 49,320 $ 55,050

Accounting Manager A-3 Accounting Manager $ 76,940 $ 91,640 $ 106,340

B-20 Accounting Manager $ 61,000 $ 67,000 $ 74,900 C-27 Accounting Manager $ 68,130 $ 78,090 $ 89,840

Accounts Payable Clerk A-4 AP Clerk $ 29,920 $ 35,110 $ 39,940

B-1 AP Clerk $ 26,200 $ 29,200 $ 32,700

Accounts Receivable Clerk A-5 AR Clerk $ 30,550 $ 35,100 $ 39,640

B-2 AR Clerk $ 26,200 $ 29,200 $ 32,700

Accounts Receivable Clerk, Sr. A-6 AR Clerk Sr. $ 35,140 $ 40,460 $ 45,370

Performs routine accounting activities following established procedures such as maintenance posting of journal entries in the general ledger and preparation of various accounting statements and financial reports. Prepares bank account reconciliations. Completes month-end closing procedures. High school diploma or GED.

Computes and prepares balance sheets, profit and loss statements and other financial reports. Responsibilities also include analyzing trends and costs incurred to predict future expenses. Assists with the preparation of financial statements, ledgers, reports and taxes. Bachelor’s degree or equivalent. Performs a variety of tasks working only under general supervision.

Manages the general accounting functions and accounting staff. Ensures compliance with generally accepted accounting procedures. Oversees the completion of ledger accounts and financial statements. Requires a bachelor's degree in a related area and 6-7 years of experience in the field. Designation of CPA may be required.

Pays bills for the company and maintains the accounts payable ledger and/or processes. Maintains all payment records. Requires a high school diploma or GED. Typically reports to a manager.

Processes incoming payments and sends requests for payment on overdue accounts. Duties include keeping records of all accounts, data entry and assisting with general accounting activities. Requires a high school diploma or GED.



Salary DataInformation compiled by the administrative assistant Source 25th 50th 75th

AR Clerk Sr.

Accounting Director A-7 Accounting Director $ 101,910 $ 127,660 $ 152,130

Accounting Director

Administrative Assistant III A-8 Administrative Assistan $ 38,420 $ 42,660 $ 46,470

Administrative Assistant III

Assembler I A-9 Assembler I $ 23,370 $ 26,750 $ 29,600

B-3 Assembler I $ 21,500 $ 24,100 $ 27,600 C-1 Assembler I $ 23,140 $ 25,250 $ 26,570 D-1 Assembler I $ 22,770 $ 24,990 $ 28,270

Assembler II A-10 Assembler II $ 26,870 $ 31,520 $ 35,540 Same as assembler but has at least of 2 years experience and is fully trained in the position. B-4 Assembler II $ 25,200 $ 28,400 $ 33,400

C-2 Assembler II $ 31,730 $ 34,440 $ 37,590 D-2 Assembler II $ 26,520 $ 29,550 $ 37,570

Assembler III A-11 Assembler III $ 33,740 $ 41,290 $ 47,610

B-5 Assembler III $ 29,500 $ 33,500 $ 38,000 C-3 Assembler III $ 38,390 $ 42,820 $ 47,230

Processes applications for credit. Duties include keeping records of all delinquent accounts and credit problems. Requires a high school diploma or GED. Normally has 3 more years of experience than a regular AR Clerk

Responsibilities include managing all the accounting functions. Requires a bachelor's degree with at least 8 years of experience in the field. Performs a variety of tasks personally while leading others. Typically reports to upper management.

Performs a variety of administrative functions. Schedules appointments, writes memos, compiles reports and handles multiple projects. May assist with annual budgets. Requires a high school diploma or GED with at least 5 years of experience. Performs a variety of tasks. May direct and lead the work of others. Typically reports to a senior manager or department head.

Assembles pre-fabricated parts at work stations. May test product to quality specifications or tolerance levels and makes repairs as necessary. Uses hand and/or power tools to assemble units. Uses instructions and standardized procedures to assemble the units to product specifications. Requires a high school diploma or GED. Position-specific formal training may be required. Less than of 2 years experience in this position; may also be called a trainee or apprentice..

Same as assembler but has at least 5 years of experience and is fully trained in the position. May be assigned training or lead duties.




D-3 Assembler III $ 30,160 $ 34,270 $ 39,460

Building and Grounds Supervisor I A-12 Building and Grounds $ 44,680 $ 53,090 $ 63,090

C-4 Building and Grounds $ 49,490 $ 52,080 $ 55,320

Cost Accountant

B-6 Cost Accountant $ 44,500 $ 50,000 $ 56,000

Custodian

B-7 Custodian $ 19,200 $ 21,700 $ 24,900

Design Engineer

B-23 Design Engineer $ 45,100 $ 51,300 $ 58,000

Customer Service Representative II A-39 Customer Service Repr$28,484 $32,590 $36,695

C-5 Customer Service Repr $ 31,000 $ 32,320 $ 34,000

Supervises and trains building and grounds maintenance staff. Oversees landscaping activities; the maintenance of sidewalks and parking areas; and the removal of trash and snow. May be responsible for the housekeeping staff. A Level I Supervisor is considered a working supervisor with little authority for personnel actions. Requires a high school diploma or its equivalent in area of specialty. Familiar with a variety of the field's concepts, practices and procedures. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. A certain degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department.

Tracks information regarding the costs of manufacturing activity, such as raw material purchases, inventory, labor, etc. Analyzes changes in raw materials, manufacturing methods, rate schedules to determine effects on costs. Compares factors affecting prices and profitability of products or services. BS in accounting required.

Performs housekeeping and janitorial duties to keep offices, restrooms and public areas in clean and orderly fashion. Removes trash from offices and other work areas. May do minor repairs. May do outside maintenance including lawns and snow removal by hand or power equipment. Follows established routine. No HS or GED requirement but may be required to read and or speak English to understand instructions and cleaning product information.

Designs new or improves design of existing products. Develops specifications and oversees prototype development and testing. Bachelors degree expected.

Handles more complex customer inquiries and higher-value or non-routine transactions. Average of 6 years of experience and high school diploma or GED.



Salary DataInformation compiled by the administrative assistant Source 25th 50th 75th Forklift II B-8 Forklift II $ 23,700 $ 26,300 $ 29,800

C-6 Forklift II $ 26,850 $ 27,990 $ 29,440

Forklift 1Same as Forklift II above but with no experience; company must provide forklift training and certification. C-7 Forklift 1 $ 21,320 $ 22,230 $ 23,390

D-4 Forklift 1 $ 27,740 $ 31,500 $ 35,030

General Maintenance Worker I A-13 General Maintenance $ 28,220 $ 32,440 $ 37,630

D-5 General Maintenance $ 34,310 $ 39,380 $ 45,380

Housekeeper A-14 Housekeeper $ 20,430 $ 21,940 $ 24,110

Human Resources Manager A-15 Human Resources Ma $ 69,930 $ 90,110 $ 108,490

B-21 Human Resources Ma $ 55,900 $ 65,000 $ 71,800

Human Resources Generalist III A-16 Human Resources Gene $ 61,200 $ 71,000 $ 80,100

Operates a powered forklift, cherry picker or hydraulic lift in a warehouse or manufacturing area and between departments, buildings and outside storage areas. Collects and delivers materials while following established safety procedures. Delivers materials to work areas as directed; stacks materials in storage areas and loads outgoing shipments into trailers; unloads incoming shipments. High school education or GED and forklift certification required. Report to shipping supervisor.

Performs maintenance service and repairs in the areas of plumbing, carpentry, painting, plastering, machine servicing, electrical or vehicle servicing. Is knowledgeable in the procedures and safety measures in area(s) of specialty. Requires 0-2 years of experience in the field or in a related area. Has knowledge of commonly used concepts, practices and procedures within a particular field. Relies on instructions and pre-established guidelines to perform the functions of the job. Works under immediate supervision. Primary job functions do not typically require exercising independent judgment. Typically reports to a supervisor or manager.

Works to ensure offices and other specified areas are kept in a clean and orderly condition. May require a high school diploma or its equivalent. No experience necessary. Has knowledge of commonly used concepts, practices and procedures within a particular field. Relies on instructions and pre-established guidelines to perform the functions of the job. Works under immediate supervision. Typically reports to a supervisor.

Designs and implements HR policies involving employment, compensation, benefits, employee relations, training and safety. Requires a bachelor's degree. May supervise other employees in HR or corporate administrative or service functions.




Information Technology Generalist A-17 Information Technolog $ 44,680 $ 53,280 $ 60,810

B-22 Information Technolog $ 44,500 $ 51,000 $ 58,600

Janitor, Sr. A-18 Janitor, Sr. $ 25,760 $ 29,200 $ 33,530

C-8 Janitor, Sr. $ 25,810 $ 26,950 $ 29,120 D-5 Janitor, Sr. $ 25,710 $ 28,470 $ 32,330

Jig and Fixture Builder A-19 Jig and Fixture Builde $ 55,650 $ 61,980 $ 70,160

Mail Clerk A-20 Mail Clerk $ 23,540 $ 27,090 $ 29,560

Designs and administers human resource policies in a small company or in limited functional areas of a larger company. Analyzes HR data and makes recommendations to management regarding solutions to identified problems. Processes HR or payroll-related paperwork. Prepares internal employee communications. Requires a bachelor's degree or related experience. Must have knowledge of HR practices and legal issues. Performs a variety of tasks. May lead and direct the work of nonmanagement employees. May report to a senior HR manager or directly to a line executive.

Performs information systems administrative procedures and maintains documentation that covers two or more functional areas, including data control, applications training, data coordination and scheduling, data security administration, etc. Requires a bachelor's degree and 0-3 years of experience in the field or in a related area. Has knowledge of commonly used concepts, practices and procedures within a particular field. Relies on instructions and pre-established guidelines to perform the functions of the job. Works under immediate supervision. Typically reports to a supervisor.

Cleans and maintains buildings/facilities. May be expected to make basic repairs. May require a high school diploma or its equivalent with 3-5 years of experience in the field or in a related area. Familiar with a variety of the field's concepts, practices and procedures. Relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. Directs and leads the work of others. A certain degree of creativity and latitude is required. Typically reports to a supervisor/manager.

Creates nonstandard jigs, fixtures, clamps and special tools for manufacturing operations. Tests jigs for function and tolerances. Responsible for determining production methods and sequence of operations and assists with establishing standard procedures for work to be performed using these jigs or fixtures. Requires a high school diploma or GED and at least 5 years of experience. Relies on experience and judgment to performs a variety of tasks. A high degree of creativity and latitude is required.




B-9 Mail Clerk $ 20,900 $ 23,400 $ 26,100

Machine Operator/Tender Machine Operator/TenderTends automated machines in a continuous production environment. D-6 Machine Operator/Te $ 29,070 $ 34,300 $ 40,010

Machine Tool Operator

D-7 Machine Tool Operato $ 30,330 $ 36,600 $ 44,520

Manufactures' Sales Representative A-40 Manufactures' Sales R $ 65,300 $ 82,600 $ 99,900

C-9 Manufactures' Sales R $ 74,890 $ 81,150 $ 89,250

Materials Handler I A-21 Materials Handler I $ 24,650 $ 28,840 $ 32,450

D-8 Materials Handler I $ 24,040 $ 26,600 $ 30,050

Materials Handler II A-22 Materials Handler II $ 26,720 $ 30,710 $ 34,090

B-10 Materials Handler II $ 22,400 $ 25,100 $ 28,600 D-9 Materials Handler II $ 27,580 $ 30,550 $ 34,840

Materials Handler III A-23 Materials Handler III $ 35,370 $ 41,770 $ 46,080

B-11 Materials Handler III $ 30,100 $ 32,700 $ 36,000 D-10 Materials Handler III $ 32,950 $ 36,060 $ 40,210

Materials Supervisor I A-24 Materials Supervisor I $ 37,090 $ 43,570 $ 51,350

Distributes and collects incoming mail. Collects and processes outgoing mail. Responsibilities include sending registered mail and packages. Requires a high school diploma or GED.

Operates manual or attends automated machine tools. Tools may include but are not limited to hydraulic presses, drill presses, forming, milling, grinding or special purpose assembly or filling machines. Work is repetitive in nature. Senior operators are expected to set up and adjust machines.

Sells products to wholesale or direct customers. Detailed product knowledge required. Compensation is usually a combination of salary and commission.

Loads and unloads material within a warehouse. Utilizes hand trucks, powered forklifts (either gas or electric), powered hoists or other equipment to move materials. Follows detailed instructions and procedures. Require a high school diploma or GED and less than 3 years of experience.

Same as Material Handler I but with 2-5 years of experience. Has knowledge of standard practices and procedures within the job. May perform a wider variety of tasks than Level I.

Same as Material Handler II but with 5 or more years of experience. Has knowledge of standard practices and procedures within the job. May perform a wider variety of tasks than Level II. May act as a lead or trainer for Levels I and II; may take on additional responsibilities for recordkeeping, production or quality control.




Materials Supervisor II A-25 Materials Supervisor I $ 48,550 $ 59,110 $ 71,450

Model Maker D-11 Model Maker $ 48,140 $ 52,880 $ 56,850

Mold Maker

C-10 Mold Maker $ 32,060 $ 33,630 $ 35,650

Office Services Assistant A-26 Office Services Assist $ 31,730 $ 37,740 $ 44,490

D-12 Office Services Assist $ 23,960 $ 27,520 $ 31,250

Order Puller Order Puller

Responsible for overseeing warehousing, shipping, receiving and materials handling. A Level I supervisor is considered a working supervisor with little authority for personnel actions. May require a bachelor's degree in area of specialty. Familiar with a variety of the field's concepts, practices and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department.

Responsible for overseeing warehousing, shipping, receiving and materials handling. A Level II Supervisor has authority for personnel actions and oversees most day-to-day operations of group. May require a bachelor's degree in area of specialty. Familiar with a variety of the field's concepts, practices and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department.

Builds prototype models requiring a high degree of accuracy. Creates special tools, fixtures or jigs. A high degree of independent action is expected.

Performs a variety of tasks required to set up molds that other employees will use to craft the product. May assemble metal casting frames. Most commonly used in foundry or ceramic industries. Excludes the artist of craftsman creating the original which is being copied. HS diploma or GED not specifically required.

Collects, sorts and distributes incoming mail and collects and prepares outgoing mail for shipping using postage meter, scales etc. Prepare packages for outside pick-up. Maintains shipping records. Operates mailroom equipment including inserters, calculator and postage meters. Provides support duties to the organization as needed. High school diploma or GED. General duties may include copying documents, getting office and kitchen supplies. Performs general maintenance of the facility and office equipment. Typically reports to a supervisor.




B-12 Order Puller $ 21,700 $ 24,300 $ 27,400

Packer, Packer-Crater or Crater-Shipper A-27 Packer, Packer-Crater $ 26,040 $ 28,310 $ 30,910

B-13 Packer, Packer-Crater $ 21,100 $ 23,900 $ 27,200 C-11 Packer, Packer-Crater $ 24,380 $ 26,540 $ 29,000

Paint Technician

C-12 Paint Technician $ 42,520 $ 46,720 $ 51,500 D-13 Paint Technician $ 35,000 $ 39,230 $ 47,980

Plant Manager II A-28 Plant Manager II $ 104,170 $ 119,420 $ 138,250

Production General Laborer

C-13 Production General L $ 21,100 $ 21,930 $ 22,990

Production Painter I or Painter-Spray I A-29 Production Painter I o $ 24,690 $ 28,390 $ 32,950

Assembles customer orders from in-stock finished goods and places orders in drop areas prepared for loading. May use automated order systems. May pull from reserve stock areas. PC skills may be required for inputting pulled orders and shipping information into software system. High school diploma or GED.

Prepares and packs product for shipment. Constructs nonstandard boxes, crates/containers when standard containers are not available. May construct custom pallets. Selects materials for packing as appropriate for protection of the product and methods of bracing/blocking to prevent damage while in transit. High school diploma or GED. Usually reports to a shipping supervisor.

Similar to Production Painter but has responsibility for mixing paint colors using special glazes and setting up machines for different applications. 12 years experience.

Manages and oversees overall plant operations, which may include finance; manufacturing; manufacturing engineering; materials; quality assurance/control; human resources; and information systems. Makes recommendations to improve productivity, quality and efficiency of operations. May be required to meet certain certifications in field. Requires a bachelor's degree and 7-10 years of experience in the field or in a related area. Familiar with a variety of the field's concepts, practices and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. A wide degree of creativity and latitude is required. Typically reports to top management.

Performs tasks in a production environment that require little training or experience. Most work is physical in nature and often involves lifting, carrying, loading or unloading, packing or unpacking. May pick up and deliver parts or materials to work stations from bins or warehouse areas. Does not usually include driving forklift or using other automated equipment. No GED required.




C-14 Production Painter I o $ 24,870 $ 27,140 $ 29,740 D-14 Production Painter I o $ 23,820 $ 28,340 $ 30,610

Production Painter II or Painter-Spray II A-30 Production Painter II o $ 31,660 $ 33,510 $ 38,700 Same as Production Painter I but averages 6 years experience. C-15 Production Painter II o $ 29,670 $ 33,280 $ 37,290

D-15 Production Painter II o $ 30,140 $ 32,340 $ 37,260

Production Scheduler

D-16 Production Scheduler $ 43,020 $ 50,030 $ 57,100

Production Supervisor I A-31 Production Supervisor $ 41,410 $ 45,670 $ 54,490

C-16 Production Supervisor $ 41,120 $ 45,570 $ 50,580

Production Supervisor II A-32 Production Supervisor $ 55,700 $ 60,260 $ 70,840


Production Supervisor III A-33 Production Supervisor $ 68,650 $ 78,960 $ 90,060


Receptionist A-34 Receptionist $ 26,100 $ 29,720 $ 32,750

Operates spray equipment on assembly line to coat manufactured items with paint or other coatings. May perform preparation work including cleaning, grinding, sanding or filling. Mounts and masks work. Fills and cleans spray equipment.

Schedules the flow of work and supplies within a manufacturing area. Established priorities and revises schedules to take best advantage of available materials, supplies and labor.

Supervises the activities of production personnel engaged in manufacturing. Supervises the use of hand tools, jigs and various power equipment at floor assembly or bench workstations. Leads or working foreman may report to this level. A bachelor's degree is usually an option but not a requirement. Performs a variety of tasks. Typically reports to the department manager.

Similar to Level I but averages 7 years of experience and may have a larger span of control and more freedom of action.

Supervises the activities of personnel engaged in all parts of the manufacturing process. A Level III Supervisor has full authority and may be considered management. A bachelor's degree in area of specialty and more than 10 year experience. A wide degree of latitude is granted. May be the head of a sub-unit of the manufacturing department and may supervise more junior supervisors.




B-14 Receptionist $ 21,900 $ 24,700 $ 27,300

Sawing Machine Operator I

C-19 Sawing Machine Opera $ 25,140 $ 26,290 $ 27,770

Sawing Machine Operator II

C-20 Sawing Machine Operat $ 30,450 $ 31,840 $ 33,620

Secretary I A-34 Secretary I $ 28,650 $ 32,700 $ 37,140

Shipper

B-15 Shipper $ 24,100 $ 26,700 $ 30,000 C-20 Shipper $ 24,030 $ 26,650 $ 28,630

Spray Coating and Painting Machine Operator A-35 Spray Coating and Pa $ 25,350 $ 32,620 $ 39,240

Greets and screens job applicants and other visitors and directs them to the appropriate office. Operates the phone system to route incoming calls and does paging. Requires a high school diploma or GED.

Operates table, bench, jig, hand or band saws. Makes cross cuts, miter, slots, groves, etc. in wood, plastic or metal stock. Installs appropriate blades, adjusts tension, blade speed, cutting speed (feed rate) and orientation of blade to material. May mark stock to be cut using drawings or forms. May use jigs, blocks, clamps or spacers during cutting. Less than 2 years of experience.

Operates table, bench, jig, hand or band saws. May operate shadow-line multiple-head sawing machine. Makes cross cuts, miter, slots, groves, etc. in wood, plastic or metal stock. Installs appropriate blades, adjusts tension, blade speed, cutting speed (feed rate) and orientation of blade to material. May mark stock to be cut using drawings or forms. May use jigs, blocks, clamps or spacers during cutting. More than 5 years of experience, HS diploma or GED required.

Performs clerical duties such as filing, word processing and copying. May operate phone systems or substitute for a receptionist. Arranges meetings and travel. Orders office supplies. Requires a high school diploma or GED with computer skills in MS Office or other common software. Follows standard office procedures and instructions or pre-established guidelines to produce reports and perform the regular job functions.

Prioritizes workload and expedites shipments. Measures and weighs orders. Completes necessary bills of lading. Must lift heavy items. Picks and packs orders. Operates forklift, doorplate and other warehouse equipment. High school diploma or GED. Less than 3 years of experience.




D-17 Spray Coating and Pa $ 30,150 $ 34,170 $ 38,290

Tool and Die MakerConstructs and repairs industrial tools, fixtures or jigs. D-18 Tool and Die Maker $ 44,820 $ 51,090 $ 58,100

Warehouse Manager A-36 Warehouse Manager $ 54,980 $ 64,620 $ 74,910

B-16 Warehouse Manager $ 61,400 $ 68,000 $ 78,500

C-21 Warehouse Manager $ 63,020 $ 70,990 $ 77,800

Warehouse Supervisor A-37 Warehouse Superviso $ 41,440 $ 51,890 $ 61,300

B-17 Warehouse Superviso $ 38,500 $ 43,000 $ 47,800 C-22 Warehouse Superviso $ 48,770 $ 53,580 $ 59,050

Warehouse Worker (All Levels) A-38 Warehouse Worker (Al $ 22,560 $ 28,130 $ 33,700

B-18 Warehouse Worker (Al $ 22,700 $ 25,800 $ 28,900 C-23 Warehouse Worker (Al $ 25,850 $ 29,200 $ 32,870

Utilizes a sprayer or spraying machine to apply paint. Requires a high school diploma or its equivalent. Uses standard procedures, instructions and pre-established guidelines to perform the functions of the job. Works under immediate supervision.

Manages all warehouse activities. Manages the warehouse to ensure the receipt, coordination and safety of goods coming through a warehouse. Also ensures that orders arrive and are dispatched on time to the appropriate destinations and in the expected quantities. Requires a high school diploma or its equivalent with 5-7 years of experience in the field or in a related area. Familiar with a variety of the field's concepts, practices and procedures. Relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. A degree of creativity and latitude is required. Leads and directs the work of others. Typically reports to a senior manager.

Supervises the receiving, storing, packing and shipping of merchandise or materials. Maintains stock records and schedules. Requires a high school diploma or its equivalent with at least 4 years of experience in the field or in a related area. Familiar with a variety of the field's concepts, practices and procedures. Relies on experience and judgment to plan and accomplish goals. Performs a variety of complicated tasks. A certain degree of creativity and latitude is required. Typically reports to a manager.

Receives, checks and stores materials. Fills internal or external requisitions and orders. May take materials to or from storage areas and assembly lines. Operates fork lift. Requires a high school diploma or its equivalent.




Woodworking Machine Operator II

C-24 Woodworking Machine $ 30,230 $ 31,330 $ 26,250

Woodworking Machine Operator ISame as above but with less than 2 years of experience. C-25 Woodworking Machine $ 23,760 $ 24,860 $ 26,250

Performs cutting planning, sanding, shaping, finishing and cleaning of wood products with hand or power tools. Stacks raw materials in staging or storage areas. Mounts hooks or wire to ready product for spray or dip coatings. Applies glues and may clamp pieces for joining. May nail, screw or bolt lumber pieces into assemblies. May do quality inspections to predetermined tolerances. Dismantles incoming shipping crates. Prepares lumber for cutting by attaching to jigs or by making patterns on the pieces. Loads and unloads materials from truck or rail cars as needed. 6 years average length of experience.

Columbus Custom CarpentryJob Descriptions

Corporate Unit

PresidentAdministrative Assistant

HR Manager New position; no description prepared yet.

Receptionist/Clerk(2)

Accounting

CFO

Staff Accountant

Database Manager

Corporate Services

Building Supervisor No description available.

Handyman No description available.

Mail/Shipping Clerk

Custodian No description available.

The administrative assistant supervises the receptionists and provides the president with general office management services, including the preparation of sales and manufacturing reports, meeting arrangements, correspondence and special projects.

The receptionists staff the reception desk and provide general office support, including data entry, filing and special projects.

Supervises the accounting function and specializes in reporting and compliance with GAAP standards. Responsible for approving credit extensions to customers and coordinating with the outside accounting firm on compiling the tax returns.

General accounting duties with special emphasis on cost accounting for the manufacturing function. Responsible for the month-end closing cycle.

General accounting duties with special emphasis on report preparation and computer systems. Runs data backup and system security. Serves as the computer expert for the company.

Accounts Payable (AP)Clerk (1)

Responsible for general accounting clerk duties with special focus on generation of accounts payable transactions.

Accounts Receivable (AR) Clerk (2)

Responsible for general accounting clerk duties with special focus on billing and collections activity.

Collects and distributes incoming and outgoing mail. Responsibilities include processing and recording postage on all types of mail and packages. Performs a wide variety of other office support services, including assisting with custodial or handyman duties and keeping the break rooms and copier area stocked as needed. Requires a high school diploma or GED. Requires a valid driver's license, a clean driving record and insurance. May be required to use personal car or truck to run errands. Reports to the building supervisor.


MarketingManagement and SupervisionNo description available.

Sales

Inside Sales

Customer Service

Product Development

Attends trade/home shows, contacts builders and architects to increase awareness and sales of our products. Distributes literature. May work directly on special projects or large sales. Maintains relationships with current customers. Develops leads and contacts to create new customers.

Contacts builders and architects by phone or mail to increase awareness and sales of our products. Uses direct mail marketing to expand the knowledge of our products to noncurrent customers. May work directly on special projects or large sales. Maintains relationships with current customers not assigned to a field sales representative. Develops leads and contacts to create new customers. Works in the main office, primarily taking calls from builders to set up accounts, special promotions or to answer product questions of a sales rather than service nature. Responsible for dealers and prospects outside the Ohio, Michigan and Indiana area. Covers calls for field sales personnel while they are on vacation.

Takes incoming calls for sales orders or problem resolution on existing orders. May make outgoing calls to follow up on previous inquiries. Computer literate, HS diploma or GED, 3 years of customer service experience in a call center. Excellent voice communications, including diction.

The product development function is made up of a designer and a prototype, tool and jig maker.


ManufacturingManagement and Supervision

Manufacturing Manager No description available.

Supervisors

Preprocessing

Machine Operators

Assembly

Production Techs

Finishing

Paint Room Techs

WarehouseManagement and Supervision

Warehouse ManagerSupervisors The three warehouse supervisors are in raw materials, crating and distribution.

Raw Materials

Forklift

Finished Goods

Forklift See above.

Craters

Manufacturing supervisors are distributed by materials/buyer, production planner, saw room, assembly (2) and finishing.

Picks up materials from the raw material staging area. Completes assigned sawing, planning, shaving, sanding, drilling or finishing operations. Stores ready-for-assembly pieces in the staging area for pick up by assembly. Responsible for strict quality and production standards. Responsible for complying with all safety controls. Requires a high school diploma or GED. Reports to the saw room supervisor.

Moves raw material from the staging area and places the individual pieces into the production jigs. Completes assembly process according to established procedures. Responsible for quality control of assembled units. Moves completed unit to finished good holding area. Reports to assembly supervisor.

Utilizes the automated sprayer to apply paint or stain to finished products. Mounts product to hangers. Moves product into sprayer area and after coating into the drying area. Requires a high school diploma or equivalent. Reports to finishing room supervisor.

Warehouse forklift operators may work in a receiving area unloading raw materials from trucks or in the distribution area loading trucks. Distribution operators must pull customer orders from stock based on "pull tickets." They are responsible for the accuracy of the assembled orders and the protection of materials in transit. All operators also move stock to and from the packaging or manufacturing areas as needed. An OSHA forklift operator's certification is required. HS or GED.

Craters take finished product from the manufacturing or finishing areas and build wooden shipping frames/crates to protect the units during storage and transport. Detailed procedures for crating are posted in the crating area. HS diploma or GED.

Columbus Custom Carpentry TerminationsHead Count Report Current Current Last PreviousDepartment Job Titles Headcount Year Year YearOffice Group

Corporate Unit 5 0 1 0PresidentAdministrative AssistantHR ManagerReceptionist/ClerkReceptionist/Clerk

Accounting 6 1 0 0CFOStaff AccountantDatabase ManagerAP Clerk (1)AR Clerk (2)

Corporate Services 4 1 1 0Building SupervisorHandymanMail/Shipping ClerkCustodian

MarketingManagement and Supervi 1 0 0 0Sales 4 1 1 0Customer Service 8 3 2 1Product Development 2 0 0 0


Manufacturing Manager 1 0 0 0Supervisors 6 1 0 1

PreprocessingMachine Operators 20 3 2 2

AssemblyProduction Techs 30 5 4 4

FinishingPaint Room Techs 10 1 2 1

WarehouseManagement and Supervision 4 1 1 1

Warehouse ManagerSupervisors

Raw MaterialsForklift 9 3 3 2

Finished GoodsForklift 10 4 3 2Craters 15 12 9 7

Companywide

Headcount and Terminations 135 36 29 21

Note: This sheet is part of the instructor's version only.

Columbus Custom Carpentry Terminations Turnover RateCurrent Current Last Previous Three Year Current Last Previous

Department Job Titles Headcount Year Year Year Average Year Year YearOffice Group

Corporate Unit 5 0 1 0 7% 0% 20% 0%PresidentAdministrative AssistantHR ManagerReceptionist/ClerkReceptionist/Clerk

Accounting 6 1 0 0 6% 17% 0% 0%CFOStaff AccountantDatabase ManagerAP Clerk (1)AR Clerk (2)

Corporate Services 4 1 1 0 17% 25% 25% 0%Building SupervisorHandymanMail/Shipping ClerkCustodian

MarketingManagement and Supervision 1 0 0 0 0% 0% 0% 0%

Sales 4 1 1 0 17% 25% 25% 0%Customer Service 8 3 2 1 25% 38% 25% 13%

Product Development 2 0 0 0 0% 0% 0% 0%


Manufacturing Manage 1 0 0 0 0% 0% 0% 0%Supervisors 6 1 0 1 11% 17% 0% 17%

PreprocessingMachine Operators 20 3 2 2 12% 15% 10% 10%

AssemblyProduction Techs 30 5 4 4 14% 17% 13% 13%

FinishingPaint Room Techs 10 1 2 1 13% 10% 20% 10%

WarehouseManagement and Supervision 4 1 1 1 25% 25% 25% 25%

Warehouse ManagerSupervisors

Raw MaterialsForklift 9 3 3 2 30% 33% 33% 22%

Finished GoodsForklift 10 4 3 2 30% 40% 30% 20%Craters 15 12 9 7 62% 80% 60% 47%

Company Wide 21% 27% 21% 16%

Headcount and Terminations 135 36 29 21

Turnover Report

Note: This sheet is part of the instructor's verson only.

Columbus Custom Carpentry Raw Market Data Aged Market DataCurrent Data Matched Percentile Study Percentile

Departme Job Titles Headcount Source Job Title 25th 50th 75th Year 25th 50th 75th

Office GroupCorporate Unit 5

President 1Administrative Assistant 1 A-8 Administrative Assistant III $ 38,420 $ 42,660 $ 46,470 A $ 39,573 $ 43,940 $ 47,864

HR Manager 1 A-15 Human Resource Manager $ 69,930 $ 90,110 $ 108,490 A $ 72,028 $ 92,813 $ 111,745

A-16 Human Resource Generalist III $ 61,200 $ 71,000 $ 80,100 A $ 63,036 $ 73,130 $ 82,503

Receptionist/Clerk 2 A-34 Receptionist $ 26,100 $ 29,720 $ 32,750 A $ 26,883 $ 30,612 $ 33,733

B-14 Receptionist $ 21,900 $ 24,700 $ 27,300 B $ 24,200 $ 25,441 $ 28,119 A-34 Secretary I $ 28,650 $ 32,700 $ 37,140 A $ 29,510 $ 33,681 $ 38,254

Accounting 6

CFO A-3 Accounting Manager $ 76,940 $ 91,640 $ 106,340 A $ 79,248 $ 94,389 $ 109,530 B-20 Accounting Manager $ 61,000 $ 67,000 $ 74,900 B $ 67,405 $ 69,010 $ 77,147 C-27 Accounting Manager $ 68,130 $ 78,090 $ 89,840 C $ 70,174 $ 80,433 $ 92,535 A-7 Accounting Director $ 101,910 $ 127,660 $ 152,130 A $ 104,967 $ 131,490 $ 156,694

Staff Accountant 1 A-1 Accountant, General $ 46,350 $ 51,810 $ 57,790 A $ 47,741 $ 53,364 $ 59,524 B-1 Accountant, General $ 36,900 $ 40,300 $ 44,100 B $ 40,775 $ 41,509 $ 45,423 C-1 Accountant, General $ 42,050 $ 49,320 $ 55,050 C $ 43,312 $ 50,800 $ 56,702 B-6 Cost Accountant $ 44,500 $ 50,000 $ 56,000 B $ 49,173 $ 51,500 $ 57,680

Database Manager 1 A-17 Information Technology Generalist $ 44,680 $ 53,280 $ 60,810 A $ 46,020 $ 54,878 $ 62,634

B-22 Information Technology Generalist $ 44,500 $ 51,000 $ 58,600 B $ 49,173 $ 52,530 $ 60,358 $ 57,000

AP Clerk (1) 1 A-4 Accounts Payable Clerk $ 29,920 $ 35,110 $ 39,940 A $ 30,818 $ 36,163 $ 41,138



Departme Job Titles Headcount Source Job Title 25th 50th 75th Year 25th 50th 75thB-1 Accounts Payable Clerk $ 26,200 $ 29,200 $ 32,700 B $ 28,951 $ 30,076 $ 33,681

AR Clerk (2) 2 A-5 Accounts Receivable Clerk $ 30,550 $ 35,100 $ 39,640 A $ 31,467 $ 36,153 $ 40,829

B-2 Accounts Receivable Clerk $ 26,200 $ 29,200 $ 32,700 B $ 28,951 $ 30,076 $ 33,681

$ 28,394 Corporate Services 4

Building Supervisor 1 A-12 Building and Grounds Supervisor I $ 44,680 $ 53,090 $ 63,090 A $ 46,020 $ 54,683 $ 64,983 C-4 Building and Grounds Supervisor I $ 49,490 $ 52,080 $ 55,320 C $ 50,975 $ 53,642 $ 56,980

Handyman 1 A-13 General Maintenance Worker I $ 28,220 $ 32,440 $ 37,630 A $ 29,067 $ 33,413 $ 38,759

D-5 General Maintenance Worker I $ 34,310 $ 39,380 $ 45,380 D $ 36,883 $ 40,561 $ 46,741

Mail/Shipping Clerk 1 A-20 Mail Clerk $ 23,540 $ 27,090 $ 29,560 A $ 24,246 $ 27,903 $ 30,447

B-9 Mail Clerk $ 20,900 $ 23,400 $ 26,100 B $ 23,095 $ 24,102 $ 26,883 A-26 Office Services Assistant $ 31,730 $ 37,740 $ 44,490 A $ 32,682 $ 38,872 $ 45,825 D-12 Office Services Assistant $ 23,960 $ 27,520 $ 31,250 D $ 25,757 $ 28,346 $ 32,188

Custodian 1 B-7 Custodian $ 19,200 $ 21,700 $ 24,900 B $ 21,216 $ 22,351 $ 25,647

A-14 Housekeeper $ 20,430 $ 21,940 $ 24,110 A $ 21,043 $ 22,598 $ 24,833 A-18 Janitor, Sr. $ 25,760 $ 29,200 $ 33,530 A $ 26,533 $ 30,076 $ 34,536 C-8 Janitor, Sr. $ 25,810 $ 26,950 $ 29,120 C $ 26,584 $ 27,759 $ 29,994 D-5 Janitor, Sr. $ 25,710 $ 28,470 $ 32,330 D $ 27,638 $ 29,324 $ 33,300

Marketing

Management and Supervision 1 A-40 Manufactures' Sales Representative $ 65,300 $ 82,600 $ 99,900 A $ 67,259 $ 85,078 $ 102,897 Sales 4 C-9 Manufactures' Sales Representative $ 74,890 $ 81,150 $ 89,250 C $ 77,137 $ 83,585 $ 91,928

$ 66,882



Departme Job Titles Headcount Source Job Title 25th 50th 75th Year 25th 50th 75th

Customer Service 8 C-5 Customer Service Representative II $ 31,000 $ 32,320 $ 34,000 C $ 31,930 $ 33,290 $ 35,020 A-39 Customer Service Representative II $ 28,484 $ 32,590 $ 36,695 A $ 29,339 $ 33,568 $ 37,796

$ 35,362 Product Development 2

Designer 1 B-23 Design Engineer $ 45,100 $ 51,300 $ 58,000 B $ 49,836 $ 52,839 $ 59,740

Tool and Jig Maker 1 A-19 Jig and Fixture Builder $ 55,650 $ 61,980 $ 70,160 A $ 57,320 $ 63,839 $ 72,265 D-11 Model Maker $ 48,140 $ 52,880 $ 56,850 D $ 51,751 $ 54,466 $ 58,556 D-18 Tool and Die Maker $ 44,820 $ 51,090 $ 58,100 D $ 48,182 $ 52,623 $ 59,843

Management and Supervision

Manufacturing Manager 1 A-28 Plant Manager II $ 104,170 $ 119,420 $ 138,250 A $ 107,295 $ 123,003 $ 142,398

Production Coordinator 1 D-16 Production Scheduler $ 43,020 $ 50,030 $ 57,100 D $ 46,247 $ 51,531 $ 58,813

Supervisors 6 A-31 Production Supervisor I $ 41,410 $ 45,670 $ 54,490 A $ 42,652 $ 47,040 $ 56,125 C-16 Production Supervisor I $ 41,120 $ 45,570 $ 50,580 C $ 42,354 $ 46,937 $ 52,097 A-32 Production Supervisor II $ 55,700 $ 60,260 $ 70,840 A $ 57,371 $ 62,068 $ 72,965 C-17 Production Supervisor II $ 52,760 $ 57,760 $ 63,500 C $ 54,343 $ 59,493 $ 65,405

$54,839

Machine Operators C-19 Sawing Machine Operator I $ 25,140 $ 26,290 $ 27,770 C $ 25,894 $ 27,079 $ 28,603 C-20 Sawing Machine Operator II $ 30,450 $ 31,840 $ 33,620 C $ 31,364 $ 32,795 $ 34,629 C-25 Woodworking Machine Operator I $ 23,760 $ 24,860 $ 26,250 C $ 24,473 $ 25,606 $ 27,038 C-24 Woodworking Machine Operator II $ 30,230 $ 31,330 $ 26,250 C $ 31,137 $ 32,270 $ 27,038

$ 31,928

A-9 Assembler I $ 23,370 $ 26,750 $ 29,600 A $ 24,071 $ 27,553 $ 30,488 B-3 Assembler I $ 21,500 $ 24,100 $ 27,600 B $ 23,758 $ 24,823 $ 28,428 C-1 Assembler I $ 23,140 $ 25,250 $ 26,570 C $ 23,834 $ 26,008 $ 27,367



Departme Job Titles Headcount Source Job Title 25th 50th 75th Year 25th 50th 75thD-1 Assembler I $ 22,770 $ 24,990 $ 28,270 D $ 24,478 $ 25,740 $ 29,118 A-10 Assembler II $ 26,870 $ 31,520 $ 35,540 A $ 27,676 $ 32,466 $ 36,606 B-4 Assembler II $ 25,200 $ 28,400 $ 33,400 B $ 27,846 $ 29,252 $ 34,402 C-2 Assembler II $ 31,730 $ 34,440 $ 37,590 C $ 32,682 $ 35,473 $ 38,718 D-2 Assembler II $ 26,520 $ 29,550 $ 37,570 D $ 28,509 $ 30,437 $ 38,697

$ 32,938

Finishing Paint Room Techs 10 A-35 Spray Coating, and Painting Machine Oper $ 25,350 $ 32,620 $ 39,240 A $ 26,111 $ 33,599 $ 40,417 D-17 Spray Coating, and Painting Machine Oper $ 30,150 $ 34,170 $ 38,290 D $ 32,411 $ 35,195 $ 39,439 A-29 Production Painter I or Painter-Spray I $ 24,690 $ 28,390 $ 32,950 A $ 25,431 $ 29,242 $ 33,939 C-14 Production Painter I or Painter-Spray I $ 24,870 $ 27,140 $ 29,740 C $ 25,616 $ 27,954 $ 30,632 D-14 Production Painter I or Painter-Spray I $ 23,820 $ 28,340 $ 30,610 D $ 25,607 $ 29,190 $ 31,528 A-30 Production Painter II or Painter-Spray II $ 31,660 $ 33,510 $ 38,700 A $ 32,610 $ 34,515 $ 39,861 C-15 Production Painter II or Painter-Spray II $ 29,670 $ 33,280 $ 37,290 C $ 30,560 $ 34,278 $ 38,409 D-15 Production Painter II or Painter-Spray II $ 30,140 $ 32,340 $ 37,260 D $ 32,401 $ 33,310 $ 38,378

Warehouse

Management and Supervision 4 A-36 Warehouse Manager $ 54,980 $ 64,620 $ 74,910 A $ 56,629 $ 66,559 $ 77,157 Warehouse Manager B-16 Warehouse Manager $ 61,400 $ 68,000 $ 78,500 B $ 67,847 $ 70,040 $ 80,855

C-21 Warehouse Manager $ 63,020 $ 70,990 $ 77,800 C $ 64,911 $ 73,120 $ 80,134

Supervisors $42,635 A-24 Materials Supervisor I $ 37,090 $ 43,570 $ 51,350 A $ 38,203 $ 44,877 $ 52,891 A-25 Materials Supervisor II $ 48,550 $ 59,110 $ 71,450 A $ 50,007 $ 60,883 $ 73,594 A-37 Warehouse Supervisor $ 41,440 $ 51,890 $ 61,300 A $ 42,683 $ 53,447 $ 63,139 B-17 Warehouse Supervisor $ 38,500 $ 43,000 $ 47,800 B $ 42,543 $ 44,290 $ 49,234 C-22 Warehouse Supervisor $ 48,770 $ 53,580 $ 59,050 C $ 50,233 $ 55,187 $ 60,822

Raw Materials

Forklift 9 A-21 Materials Handler I $ 24,650 $ 28,840 $ 32,450 A $ 25,390 $ 29,705 $ 33,424 D-8 Materials Handler I $ 24,040 $ 26,600 $ 30,050 D $ 25,843 $ 27,398 $ 30,952 A-22 Materials Handler II $ 26,720 $ 30,710 $ 34,090 A $ 27,522 $ 31,631 $ 35,113



Departme Job Titles Headcount Source Job Title 25th 50th 75th Year 25th 50th 75thB-10 Materials Handler II $ 22,400 $ 25,100 $ 28,600 B $ 24,752 $ 25,853 $ 29,458 D-9 Materials Handler II $ 27,580 $ 30,550 $ 34,840 D $ 29,649 $ 31,467 $ 35,885 C-7 Forklift 1 $ 21,320 $ 22,230 $ 23,390 C $ 21,960 $ 22,897 $ 24,092 D-4 Forklift 1 $ 27,740 $ 31,500 $ 35,030 D $ 29,821 $ 32,445 $ 36,081 B-8 Forklift II $ 23,700 $ 26,300 $ 29,800 B $ 26,189 $ 27,089 $ 30,694 C-6 Forklift II $ 26,850 $ 27,990 $ 29,440 C $ 27,656 $ 28,830 $ 30,323 A-38 Warehouse Worker (All Levels) $ 22,560 $ 28,130 $ 33,700 A $ 23,237 $ 28,974 $ 34,711 B-18 Warehouse Worker (All Levels) $ 22,700 $ 25,800 $ 28,900 B $ 25,084 $ 26,574 $ 29,767 C-23 Warehouse Worker (All Levels) $ 25,850 $ 29,200 $ 32,870 C $ 26,626 $ 30,076 $ 33,856

$27,237

Finished Goods A-22 Materials Handler II $ 26,720 $ 30,710 $ 34,090 A $ 27,522 $ 31,631 $ 35,113 Forklift 10 B-10 Materials Handler II $ 22,400 $ 25,100 $ 28,600 B $ 24,752 $ 25,853 $ 29,458

D-9 Materials Handler II $ 27,580 $ 30,550 $ 34,840 D $ 29,649 $ 31,467 $ 35,885 B-8 Forklift II $ 23,700 $ 26,300 $ 29,800 B $ 26,189 $ 27,089 $ 30,694 C-6 Forklift II $ 26,850 $ 27,990 $ 29,440 C $ 27,656 $ 28,830 $ 30,323 B-15 Shipper $ 24,100 $ 26,700 $ 30,000 B $ 26,631 $ 27,501 $ 30,900 C-20 Shipper $ 24,030 $ 26,650 $ 28,630 C $ 24,751 $ 27,450 $ 29,489 A-38 Warehouse Worker (All Levels) $ 22,560 $ 28,130 $ 33,700 A $ 23,237 $ 28,974 $ 34,711 B-18 Warehouse Worker (All Levels) $ 22,700 $ 25,800 $ 28,900 B $ 25,084 $ 26,574 $ 29,767 C-23 Warehouse Worker (All Levels) $ 25,850 $ 29,200 $ 32,870 C $ 26,626 $ 30,076 $ 33,856 B-12 Order Puller $ 21,700 $ 24,300 $ 27,400 B $ 23,979 $ 25,029 $ 28,222

Craters A-27 Packer, Packer-Crater, or Crater-Ship $ 26,040 $ 28,310 $ 30,910 A $ 26,821 $ 29,159 $ 31,837 B-13 Packer, Packer-Crater, or Crater-Ship $ 21,100 $ 23,900 $ 27,200 B $ 23,316 $ 24,617 $ 28,016 C-11 Packer, Packer-Crater, or Crater-Ship $ 24,380 $ 26,540 $ 29,000 C $ 25,111 $ 27,336 $ 29,870


Columbus Custom Carpentry

Departme Job Titles

Office GroupCorporate Unit

PresidentAdministrative Assistant

HR Manager

Receptionist/Clerk

AccountingCFO

Staff Accountant

Database Manager

AP Clerk (1)

Combined Market Data Assigned CCCLeveling Percentile Grade Salary Grades

25th 50th 75th Range Minimum Midpoint Maximum

100% $ 39,573 $ 43,940 $ 47,864 5 $ 40,000 $ 44,000 $ 48,000

100% $ 72,028 $ 92,813 $ 111,745 100% $ 63,036 $ 73,130 $ 82,503

$ 67,532 $ 82,972 $ 97,124 9 $ 70,000 $ 82,500 $ 95,000

100% $ 26,883 $ 30,612 $ 33,733 100% $ 24,200 $ 25,441 $ 28,119 100% $ 29,510 $ 33,681 $ 38,254

$ 26,864 $ 29,911 $ 33,369 2 $ 28,000 $ 31,000 $ 34,000

100% $ 79,248 $ 94,389 $ 109,530 100% $ 67,405 $ 69,010 $ 77,147 100% $ 70,174 $ 80,433 $ 92,535

0% $ - $ - $ - $ 72,276 $ 81,277 $ 93,071 9 $ 70,000 $ 82,500 $ 95,000

100% $ 47,741 $ 53,364 $ 59,524 100% $ 40,775 $ 41,509 $ 45,423 100% $ 43,312 $ 50,800 $ 56,702 100% $ 49,173 $ 51,500 $ 57,680

$ 45,250 $ 49,293 $ 54,832 6 $ 45,000 $ 50,500 $ 56,000

100% $ 46,020 $ 54,878 $ 62,634 100% $ 49,173 $ 52,530 $ 60,358

$ 47,596 $ 53,704 $ 61,496 7 $ 50,000 $ 57,500 $ 65,000

100% $ 30,818 $ 36,163 $ 41,138



Departme Job Titles

AR Clerk (2)

Corporate ServicesBuilding Supervisor

Handyman

Mail/Shipping Clerk

Custodian

MarketingManagement and Supervision

Sales


25th 50th 75th Range Minimum Midpoint Maximum100% $ 28,951 $ 30,076 $ 33,681

$ 29,884 $ 33,120 $ 37,410 3 $ 30,000 $ 33,500 $ 37,000

100% $ 31,467 $ 36,153 $ 40,829 100% $ 28,951 $ 30,076 $ 33,681

$ 30,209 $ 33,115 $ 37,255 3 $ 30,000 $ 33,500 $ 37,000

100% $ 46,020 $ 54,683 $ 64,983 100% $ 50,975 $ 53,642 $ 56,980

$ 48,498 $ 54,163 $ 60,981 7 $ 50,000 $ 57,500 $ 65,000

100% $ 29,067 $ 33,413 $ 38,759 100% $ 36,883 $ 40,561 $ 46,741

$ 32,975 $ 36,987 $ 42,750 4 $ 34,000 $ 38,000 $ 42,000

100% $ 24,246 $ 27,903 $ 30,447 100% $ 23,095 $ 24,102 $ 26,883 100% $ 32,682 $ 38,872 $ 45,825 100% $ 25,757 $ 28,346 $ 32,188

$ 26,445 $ 29,806 $ 33,836 1 $ 26,000 $ 29,000 $ 32,000

0% $ - $ - $ - 0% $ - $ - $ -

100% $ 26,533 $ 30,076 $ 34,536 100% $ 26,584 $ 27,759 $ 29,994 100% $ 27,638 $ 29,324 $ 33,300

$ 26,918 $ 29,053 $ 32,610 1 $ 26,000 $ 29,000 $ 32,000

100% $ 67,259 $ 85,078 $ 102,897 100% $ 77,137 $ 83,585 $ 91,928

$ 72,198 $ 84,331 $ 97,412 9 $ 70,000 $ 82,500 $ 95,000



Departme Job Titles

Customer Service

Product DevelopmentDesigner

Tool and Jig Maker

Management and SupervisionManufacturing Manager

Production Coordinator

Supervisors

Machine Operators


25th 50th 75th Range Minimum Midpoint Maximum

100% $ 31,930 $ 33,290 $ 35,020 100% $ 29,339 $ 33,568 $ 37,796

$ 30,634 $ 33,429 $ 36,408 3 $ 30,000 $ 33,500 $ 37,000

100% $ 49,836 $ 52,839 $ 59,740 $ 49,836 $ 52,839 $ 59,740 7 $ 50,000 $ 57,500 $ 65,000

100% $ 57,320 $ 63,839 $ 72,265 100% $ 51,751 $ 54,466 $ 58,556 100% $ 48,182 $ 52,623 $ 59,843

$ 52,417 $ 56,976 $ 63,554 7 $ 50,000 $ 57,500 $ 65,000

100% $ 107,295 $ 123,003 $ 142,398 11 $ 100,000 $ 120,000 $ 140,000

100% $ 46,247 $ 51,531 $ 58,813 7 $ 50,000 $ 57,500 $ 65,000

100% $ 42,652 $ 47,040 $ 56,125 100% $ 42,354 $ 46,937 $ 52,097 100% $ 57,371 $ 62,068 $ 72,965 100% $ 54,343 $ 59,493 $ 65,405

$ 49,180 $ 53,884 $ 61,648 7 $ 50,000 $ 57,500 $ 65,000

100% $ 25,894 $ 27,079 $ 28,603 100% $ 31,364 $ 32,795 $ 34,629 100% $ 24,473 $ 25,606 $ 27,038 100% $ 31,137 $ 32,270 $ 27,038

$ 28,217 $ 29,437 $ 29,327 2 $ 28,000 $ 31,000 $ 34,000

100% $ 24,071 $ 27,553 $ 30,488 100% $ 23,758 $ 24,823 $ 28,428 100% $ 23,834 $ 26,008 $ 27,367



Departme Job Titles

Finishing Paint Room Techs

WarehouseManagement and Supervision

Warehouse Manager

Supervisors

Raw MaterialsForklift


25th 50th 75th Range Minimum Midpoint Maximum100% $ 24,478 $ 25,740 $ 29,118 100% $ 27,676 $ 32,466 $ 36,606 100% $ 27,846 $ 29,252 $ 34,402 100% $ 32,682 $ 35,473 $ 38,718 100% $ 28,509 $ 30,437 $ 38,697

$ 26,607 $ 28,969 $ 32,978 1 $ 26,000 $ 29,000 $ 32,000

100% $ 26,111 $ 33,599 $ 40,417 100% $ 32,411 $ 35,195 $ 39,439 100% $ 25,431 $ 29,242 $ 33,939 100% $ 25,616 $ 27,954 $ 30,632 100% $ 25,607 $ 29,190 $ 31,528 100% $ 32,610 $ 34,515 $ 39,861 100% $ 30,560 $ 34,278 $ 38,409 100% $ 32,401 $ 33,310 $ 38,378

$ 28,843 $ 32,160 $ 36,575 2 $ 28,000 $ 31,000 $ 34,000

100% $ 56,629 $ 66,559 $ 77,157 100% $ 67,847 $ 70,040 $ 80,855 100% $ 64,911 $ 73,120 $ 80,134

$ 63,129 $ 69,906 $ 79,382 8 $ 60,000 $ 70,000 $ 80,000

100% $ 38,203 $ 44,877 $ 52,891 90% $ 45,006 $ 54,795 $ 66,234

100% $ 42,683 $ 53,447 $ 63,139 100% $ 42,543 $ 44,290 $ 49,234 100% $ 50,233 $ 55,187 $ 60,822

$ 43,733 $ 50,519 $ 58,464 6 $ 45,000 $ 50,500 $ 56,000

100% $ 25,390 $ 29,705 $ 33,424 100% $ 25,843 $ 27,398 $ 30,952 100% $ 27,522 $ 31,631 $ 35,113



Departme Job Titles

Finished GoodsForklift

Craters


25th 50th 75th Range Minimum Midpoint Maximum100% $ 24,752 $ 25,853 $ 29,458 100% $ 29,649 $ 31,467 $ 35,885 110% $ 24,156 $ 25,187 $ 26,501 100% $ 29,821 $ 32,445 $ 36,081 100% $ 26,189 $ 27,089 $ 30,694 100% $ 27,656 $ 28,830 $ 30,323 100% $ 23,237 $ 28,974 $ 34,711 100% $ 25,084 $ 26,574 $ 29,767 100% $ 26,626 $ 30,076 $ 33,856

$ 26,327 $ 28,769 $ 32,230 1 $ 26,000 $ 29,000 $ 32,000

100% $ 27,522 $ 31,631 $ 35,113 100% $ 24,752 $ 25,853 $ 29,458 100% $ 29,649 $ 31,467 $ 35,885 100% $ 26,189 $ 27,089 $ 30,694 100% $ 27,656 $ 28,830 $ 30,323 100% $ 26,631 $ 27,501 $ 30,900 100% $ 24,751 $ 27,450 $ 29,489 100% $ 23,237 $ 28,974 $ 34,711 100% $ 25,084 $ 26,574 $ 29,767 100% $ 26,626 $ 30,076 $ 33,856 100% $ 23,979 $ 25,029 $ 28,222

$ 26,007 $ 28,225 $ 31,674 1 $ 26,000 $ 29,000 $ 32,000

100% $ 26,821 $ 29,159 $ 31,837 100% $ 23,316 $ 24,617 $ 28,016 100% $ 25,111 $ 27,336 $ 29,870

$ 25,083 $ 27,038 $ 29,908 1 $ 26,000 $ 29,000 $ 32,000

Note: This sheet is part of the instructor's version only.

Columbus Custom CarpentryCCC

Salary Grades AssociatedMinimum Midpoint Maximum Job Titles

1 $ 26,000 $ 29,000 $ 32,000 Assembler, Materials Handler, Crater, Office Services, Custodian2 $ 28,000 $ 31,000 $ 34,000 Preprocessors, Finishers and Receptionists3 $ 30,000 $ 33,500 $ 37,000 Accounting Clerks and Customer Service4 $ 34,000 $ 38,000 $ 42,000 General Maintenance 5 $ 40,000 $ 44,000 $ 48,000 Administrative Assistant 6 $ 45,000 $ 50,500 $ 56,000 General Accountant, Warehouse Supervisors7 $ 50,000 $ 57,500 $ 65,000 Production Supervisors, Design and Prototype Builder, IT/Accounting Role,

Building and Grounds Supervisor, Purchasing and Scheduling Supervisors8 $ 60,000 $ 70,000 $ 80,000 Warehouse Manager9 $ 70,000 $ 82,500 $ 95,000 HR and Accounting Managers, Sales Reps

10 $ 85,000 $ 102,500 $ 120,000 Open Grade11 $ 100,000 $ 120,000 $ 140,000 Manufacturing Manager

of 40

Columbus Custom Carpentry - EEO Analysis (active employees only)Note: This sheet is part of the instructor's version only.Last Name Sex Age EEO LOS Job Title Department Salary Group Average LOS

Blair F 43 W 1.5 AP CLERK ACCOUNTING $27,200 Ranke F 64 W 25.5 AR CLERK ACCOUNTING $29,293 Guinn F 62 B 13.9 AR CLERK ACCOUNTING $28,688 Cooney M 31 W 3.3 CFO ACCOUNTING $87,250 Lee M 41 A 9.7 DATABASE MANAGER ACCOUNTING $57,000 Harris F 48 W 12.4 STAFF ACCOUNTANT ACCOUNTING $49,528 Campbell F 26 B 1.7 PRODUCTION TECH ASSEMBLY $28,500 Phillips F 45 W 1.8 PRODUCTION TECH ASSEMBLY $28,500 Wildermuth F 29 W 2.1 PRODUCTION TECH ASSEMBLY $29,500 Jones F 30 W 3.4 PRODUCTION TECH ASSEMBLY $30,942 Hicks F 42 W 3.4 PRODUCTION TECH ASSEMBLY $30,921 Smith F 35 W 5.2 PRODUCTION TECH ASSEMBLY $32,417 Diles F 30 W 9.2 PRODUCTION TECH ASSEMBLY $32,417 Klinedinst F 37 W 14.8 PRODUCTION TECH ASSEMBLY $37,294 $ 31,311 4.89 Avg Female Production Techs

Mccarty M 34 W 1.8 PRODUCTION TECH ASSEMBLY $28,500 $ 33,467 7.91 Avg Male Production Techs

Charles M 39 W 1.8 PRODUCTION TECH ASSEMBLY $28,500 $ 32,275 8.44 Average Minority Production Techs

Oswalt M 37 W 1.8 PRODUCTION TECH ASSEMBLY $28,500 Riley M 39 H 2.1 PRODUCTION TECH ASSEMBLY $29,500 Weiland M 26 W 3.0 PRODUCTION TECH ASSEMBLY $30,500 Kalb M 23 W 3.1 PRODUCTION TECH ASSEMBLY $30,500 Carver M 24 W 3.3 PRODUCTION TECH ASSEMBLY $30,500 Samczuk M 37 W 3.4 PRODUCTION TECH ASSEMBLY $32,121 Montavon M 56 H 3.6 PRODUCTION TECH ASSEMBLY $32,224 Webb M 43 W 5.2 PRODUCTION TECH ASSEMBLY $33,417 Pierce M 48 W 5.2 PRODUCTION TECH ASSEMBLY $33,621 Brown M 40 W 5.3 PRODUCTION TECH ASSEMBLY $33,511 Foreman M 41 W 7.9 PRODUCTION TECH ASSEMBLY $34,998 Riley M 48 W 8.4 PRODUCTION TECH ASSEMBLY $34,815 Ward M 53 W 10.1 PRODUCTION TECH ASSEMBLY $35,256 Williams M 36 W 10.4 PRODUCTION TECH ASSEMBLY $35,500 Staats M 42 W 10.9 PRODUCTION TECH ASSEMBLY $35,918 Mox M 40 W 11.1 PRODUCTION TECH ASSEMBLY $36,959 Hand M 29 W 11.3 PRODUCTION TECH ASSEMBLY $36,989 Bowen M 39 W 15.6 PRODUCTION TECH ASSEMBLY $37,345 Jackson M 43 W 22.1 PRODUCTION TECH ASSEMBLY $38,232

of 40


Smith M 55 B 26.4 PRODUCTION TECH ASSEMBLY $38,875 Duff F 55 W 1.6 ADMINISTRATIVE ASSISTANTCORPORATE $52,394

M 50 W 21.1 DIRECTOR OF HR CORPORATE $70,000 Cooney M 58 W 30.6 PRESIDENT CORPORATE $145,000 Jones F 51 W 8.5 RECEPTIONIST/OFFICE CLE CORPORATE $38,214 Reen M 35 W 2.6 RECEPTIONIST/OFFICE CLE CORPORATE $31,000 Essen M 62 H 9.0 BUILDING SUPERVISOR CORPORATE SERVICES $43,119 Tention M 38 H 10.5 CUSTODIAN CORPORATE SERVICES $34,726 Morris M 38 W 7.5 HANDYMAN CORPORATE SERVICES $37,145 Gray M 65 B 28.3 MAIL/SHIPPING CLERK CORPORATE SERVICES $27,726 Mccomas F 32 W 11.3 CRATER FINISHED GOODS WAREHOUSE $32,000 Spencer F 21 W 0.3 CRATER FINISHED GOODS WAREHOUSE $20,800 Bailey F 25 W 0.1 CRATER FINISHED GOODS WAREHOUSE $20,800 Gullett M 41 W 1.8 CRATER FINISHED GOODS WAREHOUSE $21,850 Hemingway M 32 W 0.2 CRATER FINISHED GOODS WAREHOUSE $20,800 Coleman M 27 B 0.4 CRATER FINISHED GOODS WAREHOUSE $20,800 Kimber M 40 W 2.2 CRATER FINISHED GOODS WAREHOUSE $23,214 Dundon M 26 W 0.6 CRATER FINISHED GOODS WAREHOUSE $20,800 Holdrieth M 34 W 1.7 CRATER FINISHED GOODS WAREHOUSE $22,880 Mahlman M 36 W 0.7 CRATER FINISHED GOODS WAREHOUSE $20,800 Weaver M 21 W 0.3 CRATER FINISHED GOODS WAREHOUSE $20,800 Griffin M 36 W 8.1 CRATER FINISHED GOODS WAREHOUSE $28,210 Moore M 33 W 0.4 CRATER FINISHED GOODS WAREHOUSE $20,800 Nechovski M 33 W 1.5 CRATER FINISHED GOODS WAREHOUSE $22,880 Stange M 23 W 0.8 CRATER FINISHED GOODS WAREHOUSE $20,800 Fusco M 60 W 20.0 CRATING SUPERVISOR FINISHED GOODS WAREHOUSE $59,681 Doss F 56 B 10.6 FORKLIFT FINISHED GOODS WAREHOUSE $32,800 Hunt F 50 W 18.1 FORKLIFT FINISHED GOODS WAREHOUSE $34,426 Shipley F 22 W 3.0 FORKLIFT FINISHED GOODS WAREHOUSE $25,877 Vasko F 30 W 6.6 FORKLIFT FINISHED GOODS WAREHOUSE $27,110 Miles F 35 W 1.4 FORKLIFT FINISHED GOODS WAREHOUSE $24,886 Van Gundy F 47 W 3.2 FORKLIFT FINISHED GOODS WAREHOUSE $27,538 Bobbs F 53 W 8.1 FORKLIFT FINISHED GOODS WAREHOUSE $31,255 Marcum M 40 W 9.7 FORKLIFT FINISHED GOODS WAREHOUSE $32,300 Wortman M 40 W 1.9 FORKLIFT FINISHED GOODS WAREHOUSE $24,886

of 40


Herold M 49 W 5.2 FORKLIFT FINISHED GOODS WAREHOUSE $26,312 Dobbins M 62 W 1.9 WAREHOUSE MANAGER FINISHED GOODS WAREHOUSE $61,887 Swingle F 43 W 13.3 WAREHOUSE SUPERVISOR FINISHED GOODS WAREHOUSE $49,692 Vasko F 40 W 14.6 PAINT ROOM TECH FINISHING $36,960 Lukas F 52 W 11.6 PAINT ROOM TECH FINISHING $36,963 Bailey M 57 B 6.5 PAINT ROOM TECH FINISHING $35,175 Orahood M 43 W 10.3 PAINT ROOM TECH FINISHING $36,300 Muck M 38 W 9.8 PAINT ROOM TECH FINISHING $35,483 Hatfield M 43 W 11.1 PAINT ROOM TECH FINISHING $36,500 Barnett M 49 W 7.7 PAINT ROOM TECH FINISHING $35,950 Howard M 34 B 3.7 PAINT ROOM TECH FINISHING $34,200 Heselden M 34 W 8.1 PAINT ROOM TECH FINISHING $35,026 Junker M 48 B 1.1 PAINT ROOM TECH FINISHING $32,163 Bowyer M 63 W 11.3 MANUFACTURING MANAGER MANUFACTURING MANAGEMENT $103,000 Koranteng F 50 W 9.4 MANUFACTURING SUPERVIS MANUFACTURING MANAGEMENT $55,414 Respress M 36 B 18.3 MANUFACTURING SUPERVIS MANUFACTURING MANAGEMENT $57,232 Dent M 48 W 2.0 MANUFACTURING SUPERVIS MANUFACTURING MANAGEMENT $53,722 Brown M 40 W 7.7 MANUFACTURING SUPERVIS MANUFACTURING MANAGEMENT $54,266 Stout M 60 W 8.2 PRODUCTION SCHEDULING MANUFACTURING MANAGEMENT $54,900 Webb F 35 W 2.1 PURCHASING MANAGER MANUFACTURING MANAGEMENT $53,500 Keeton F 29 W 1.6 CUSTOMER SERVICE MARKETING $32,000 Thomas F 61 W 16.0 CUSTOMER SERVICE MARKETING $40,200 Maddox F 43 W 3.6 CUSTOMER SERVICE MARKETING $34,000 Ryan F 41 W 1.7 CUSTOMER SERVICE MARKETING $32,000 Woods F 55 W 34.2 CUSTOMER SERVICE MARKETING $39,500 Howell M 55 W 2.6 CUSTOMER SERVICE MARKETING $33,000 Lindsey M 54 W 17.7 CUSTOMER SERVICE MARKETING $42,100 Fleige M 29 W 1.9 CUSTOMER SERVICE MARKETING $30,098 Swift M 47 W 14.9 MARKETING MANAGER MARKETING $110,000 Watkins M 62 W 19.6 PRODUCT DESIGNER MARKETING $65,428 Mauger M 54 W 24.8 PRODUCT DEVELOPMENT T MARKETING $30,285 Starkey M 46 B 27.0 SALES MARKETING $52,566 Roberts M 61 W 20.9 SALES MARKETING $62,098 Lester M 59 W 28.2 SALES MARKETING $75,964 Monford M 52 W 29.6 SALES MARKETING $76,901

of 40


Messer F 36 W 13.7 MACHINE OPERATOR PREPROCESSING $33,529 Maynard F 44 W 1.0 MACHINE OPERATOR PREPROCESSING $28,000 Rouse F 40 H 3.8 MACHINE OPERATOR PREPROCESSING $30,326 Spaulding F 45 W 12.8 MACHINE OPERATOR PREPROCESSING $33,458 Houston F 38 W 10.6 MACHINE OPERATOR PREPROCESSING $32,642 Davy F 41 W 11.1 MACHINE OPERATOR PREPROCESSING $32,789 Evans M 37 W 13.7 MACHINE OPERATOR PREPROCESSING $33,256 Hicks M 45 W 7.3 MACHINE OPERATOR PREPROCESSING $31,921 Woods M 45 W 0.9 MACHINE OPERATOR PREPROCESSING $28,000 Rose M 47 W 2.0 MACHINE OPERATOR PREPROCESSING $29,862 Freck M 38 W 2.0 MACHINE OPERATOR PREPROCESSING $29,862 Leffing M 62 W 9.6 MACHINE OPERATOR PREPROCESSING $32,254 Tatman M 58 W 3.6 MACHINE OPERATOR PREPROCESSING $30,326 Auer M 48 W 8.3 MACHINE OPERATOR PREPROCESSING $32,000 Justice M 51 W 20.0 MACHINE OPERATOR PREPROCESSING $37,232 Glenn M 63 W 17.0 MACHINE OPERATOR PREPROCESSING $35,111 Porter M 50 B 7.8 MACHINE OPERATOR PREPROCESSING $31,667 Dye M 32 W 1.8 MACHINE OPERATOR PREPROCESSING $29,644 Locke M 61 W 20.9 MACHINE OPERATOR PREPROCESSING $37,232 $31,791 8.83 Female Machine Operators

Wagner M 37 W 1.9 MACHINE OPERATOR PREPROCESSING $29,421 $31,985 8.34 Male Machine Operators

Maynard F 29 W 2.7 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $25,886 Fox M 60 W 3.2 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $26,886 Chafins M 22 W 1.8 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $24,886 Green M 38 B 13.7 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $28,239 Murray M 25 W 1.8 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $24,886 Reed M 40 W 1.9 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $24,886 Reeves M 56 B 33.4 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $32,989 $30,614 23.53 Black Material Handlers

Kelley M 61 W 22.4 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $31,585 $26,272 5.12 White Material Handlers

Scott M 42 W 1.9 MATERIALS HANDLER RAW MATERIALS WAREHOUSE $24,886 Specht M 47 W 20.9 WAREHOUSE SUPERVISOR RAW MATERIALS WAREHOUSE $42,635

135Males 94 $ 38,627.37 $ 3,630,973 Females 41 135 $ 33,662.42 $ 1,380,159

White 115 8.39 $ 37,414.05 $ 4,302,616 Black 14 13.77 $ 34,401.51 $ 481,621

of 40


Other 6 6.43 $ 37,815.83 $ 226,895

Hidden columns include first name, Active status, FT/PT and FLSA These were reduced to limit the number of printed pages

excel spreadsheets - instructor's version

Documents