Read Skill Builder $75,$Developing a Wage Structure,$$ on pp$.229$ & $230$ of Human Resource Management Applications.

Recreate Exhibit $4\mathrm{.}6$ in an Excel spreadsheet, and complete the instructions.

Create the plot using SmartArt add$-$on in a Word document. Review Figure $11\mathrm{.}2$ and Table $11\mathrm{.}6$ on p$.508$ of Human Resource Management for an example.

Include a brief explanation of the following: If these positions were organized by a union, what effect would you expect on the wage structure?

Support your response by using the relevant HRM and legal concepts, as appropriate, from the texts. Cite your supporting sources using APA formatting.

Format your response according to APA guidelines, and include a title and reference page.

Submit your spreadsheet, plot, and response to your instructor via the LMS$.$