Purpose: The purpose of this assignment is to better understand how pay for performance (meritocracy) has an impact on individual employees within a corporation and to analyze if there any diversity, equity, and inclusion impacts. The goal is to understand in this single situation how all of the aspects of diversity discussed during the semester can impact these decisions within a workplace and in an individuals personal life. This will be a two to three-page paper that will address the following four parts: Part One: Review the Excel documents related to wages for two employees at a fictitious company (starting at bottom of this document). What observations do you notice about the differences in starting pay and the impact of pay on the pace of promotions? Part Two: Based on the readings and discussions, what groups are potentially impacted by pay disparity? Part Three: Review Diversity and Organizational Competitiveness on pages 16-26 (specifically, the categories of organizational competitiveness the author outlines). Where do you see pay fitting into Diversity and Organizational Competitiveness? Please list specific categories from this section of the book. Part Four: Based on the readings in the book, and your learnings this semester, what are three potential solutions that are recommended for minimizing pay disparity in organizations? The due date for this assignment is October 9, 2023 by 11:59pm CST. **Updated due date as of 9/26/23 Data for Part 1 Chapter 4, Question 3A Black Applicant, 4% annual raises White Applicant, 4% annual raises Starting Salary $ 30,000.00 $ 33,000.00 Year 1 $ 31,200.00 $ 34,320.00 Year 2 $ 32,448.00 $ 35,692.80 Year 3 $ 33,745.92 $ 37,120.51 Year 4 $ 35,095.76 $ 38,605.33 Year 5 $ 36,499.59 $ 40,149.55 Year 6 $ 37,959.57 $ 41,755.53 Year 7 $ 39,477.95 $ 43,425.75 Year 8 $ 41,057.07 $ 45,162.78 Year 9 $ 42,699.35 $ 46,969.29

Updated 8/9/23 by RJE Year 10 $ 44,407.33 $ 48,848.06 Year 11 $ 46,183.62 $ 50,801.98 Year 12 $ 48,030.97 $ 52,834.06 Year 13 $ 49,952.21 $ 54,947.43 Year 14 $ 51,950.29 $ 57,145.32 Year 15 $ 54,028.31 $ 59,431.14 Year 16 $ 56,189.44 $ 61,808.38 Year 17 $ 58,437.01 $ 64,280.72 Year 18 $ 60,774.50 $ 66,851.95 Year 19 $ 63,205.48 $ 69,526.02 Year 20 $ 65,733.69 $ 72,307.06 Chapter 4, Question 3B Black Employee, Promotion every 5 years White Employee, Promotion every 3 years Starting Salary 30,000 33,000 Year 1 $ 31,200.00 $ 34,320.00 Year 2 $ 32,448.00 $ 35,692.80 Year 3 $ 33,745.92 $ 40,689.79 Year 4 $ 35,095.76 $ 42,317.38 Year 5 $ 40,009.16 $ 44,010.08 Year 6 $ 41,609.53 $ 50,171.49 Year 7 $ 43,273.91 $ 52,178.35 Year 8 $ 45,004.87 $ 54,265.48 Year 9 $ 46,805.06 $ 61,862.65 Year 10 $ 53,357.77 $ 64,337.16 Year 11 $ 55,492.08 $ 66,910.64 Year 12 $ 57,711.76 $ 76,278.13 Year 13 $ 60,020.23 $ 79,329.26 Year 14 $ 62,421.04 $ 82,502.43 Year 15 $ 71,159.99 $ 94,052.77 Year 16 $ 74,006.39 $ 97,814.88 Year 17 $ 76,966.65 $ 101,727.48 Year 18 $ 80,045.31 $ 115,969.32 Year 19 $ 83,247.12 $ 120,608.10