Employee dataset excel

Equal Pay Assessment for Mell Industries, Inc.

1. Project Overview

The activities in this project are designed to provide experience performing data analysis using Microsoft Excel 2016.

You will use assorted functions, calculations, and pivot tables in this project to evaluate employee data and also create an executive summary and visualization.

2. Company Background

Mell Industries is a national manufacturing firm based in Chicago that specializes in textiles. Mell Industries started out as a small factory in Warrenville, Illinois and experienced steady growth over the past twenty-four years. In this time, Mell Industries opened warehouses and factories in the areas surrounding Michigan and Indianapolis, eventually moving their headquarters to Chicago. Mell Industries is at the peak of its growth cycle and seeks to improve its corporate risk management program.

In recent years, Mell Industries has been accused of equal pay discrimination. The accusation originated from a disgruntled employee who leaked sensitive payroll information to the media highlighting the pay disparity between her salary and the salary of a co-worker with the same title, time in grade, and equivalent work history and educational qualifications. Negative public perception can severely impact corporate accomplishments, market share and stock value.

Your specific role in the project

Given the sensitivity of this issue, Mell Industries has hired Cal Poly Pomona to conduct an independent assessment using a sample set of 747 employee records. The company has also offered Cal Poly Pomona bonus compensation for any promising information provided. Mell Industries intends to use these findings to design business controls for ensuring equity in all pay scales and functional roles. These improvements will guide all future employee compensation reviews.