By Douglas Reys, SPHR

Columbus Custom Carpentry is a small, successful company.  Recently, though, labor costs have risen faster than revenue. The company president has also found that human resource issues are taking up more and more of his time and frequently result in production problems. Both overtime and late shipments are increasing. Until now, the president’s administrative assistant handled all HR-related administrative activities. You are here as the newly-hired HR manager. You will learn about the company by reading the employee handbook; talking with various employees; and reviewing the human resources information system (HRIS) database. 

In this case, students will learn and create internal and external pay equity analyses; job grades and pay range/structure creation; market pricing using salary data; turnover; and job analysis and job description development. This case is presented as close as practical to the way students will encounter data in the working world. Materials include the instructor's manual with case study, an employee handbook, a HRIS database - instructor's version, a HRIS database - student version, and a PowerPoint presentation

Please note: you may need to maximize the HRIS database spreadsheets in order to view the multiple sheet tabs near the bottom of the screen.