In this assignment, you will work with a given dataset to construct a pay structure that maintains the

internal structure as much as you can and accommodate external market data to maintain external

alignment. For simplicity, we assume that the company targets the salary structure midpoints to the 50th

percentile of the market. The data file is attached Salary Data and Internal Grade for Assignment 2-

updated.xIsx

Please answer the following questions:

1. Based on the provided data, indicate the market position for each job provide (match, lead, or lag

the market)

2. When there is a discrepancy between internal pay and external market pay, what are your

recommendations? Please explain thoroughly given some following characteristics of the

organization:

Medium size organization in the gaming industry.

Organizational culture is espoused as innovation-focused, collegial, focusing on

developing employees, promoting equity and inclusion

Business strategy: providing online education games and game services through

innovation and in-depth understanding of customers.

3. What did you learn? How would your learning apply in your current or future work?

B22 X fx 136629.451039922 A B D H Job Market Data Salary at 50th percentile Internal Pay Grade 1 Grade 2. 3 3 4 5 5 Internal Pay Structure 0.50 Midpoint Min Midpoint Max Progression 1 24000 $ 30,000 36000 2 28800 S 36,000 43200 20% 3 34560 S 43,200 51840 20% 4 41472 $ 51,840 62208 20% 5 49766.4 $ 62,208 74649.6 20% 6 59719.68 $ 74,650 89579.52 20% 7 71663,616 $ 89,580 107495.424 2096 8 85996.3392 S 107,495 128994.5088 20% 9 103195,607 S 128,995 154793.4106 20% 10 123834.7284 $ 154,793 185752.0927 20% 11 148601.6741 $ 185,752 222902.5112 2096 12 178322.009 S 222,903 267483.0134 20% 5 5 3 Clerk 4 Service Rep! 5 Assistant 6 Service Rep It 7 Specialist 8 Accountant 9 Territory Sales 10 Sr. Service Rep 11 IT Tech 12 Sr. Accountant 13 Service Supv 14 IT Tech 11 15 District Sales 16 Marketer 17 IT Tech 18 Region Sales 19 Business Mgr 20 IT Manager 21 Sales Manager 22 Marketing Mer 20 24 6 $30,534 $36,725 $39,962 $46,153 $51,922 $53,048 $53,751 $55,018 $S7,691 $65,430 $69,089 $75,280 $77,391 $85,833 $93,713 $105,392 $113,975 $125,795 $135,082 $136,629 6 7 7 8 8 9 10 11 11 12 Sheet1 Rearly B22 X fx 136629.451039922 A B D H Job Market Data Salary at 50th percentile Internal Pay Grade 1 Grade 2. 3 3 4 5 5 Internal Pay Structure 0.50 Midpoint Min Midpoint Max Progression 1 24000 $ 30,000 36000 2 28800 S 36,000 43200 20% 3 34560 S 43,200 51840 20% 4 41472 $ 51,840 62208 20% 5 49766.4 $ 62,208 74649.6 20% 6 59719.68 $ 74,650 89579.52 20% 7 71663,616 $ 89,580 107495.424 2096 8 85996.3392 S 107,495 128994.5088 20% 9 103195,607 S 128,995 154793.4106 20% 10 123834.7284 $ 154,793 185752.0927 20% 11 148601.6741 $ 185,752 222902.5112 2096 12 178322.009 S 222,903 267483.0134 20% 5 5 3 Clerk 4 Service Rep! 5 Assistant 6 Service Rep It 7 Specialist 8 Accountant 9 Territory Sales 10 Sr. Service Rep 11 IT Tech 12 Sr. Accountant 13 Service Supv 14 IT Tech 11 15 District Sales 16 Marketer 17 IT Tech 18 Region Sales 19 Business Mgr 20 IT Manager 21 Sales Manager 22 Marketing Mer 20 24 6 $30,534 $36,725 $39,962 $46,153 $51,922 $53,048 $53,751 $55,018 $S7,691 $65,430 $69,089 $75,280 $77,391 $85,833 $93,713 $105,392 $113,975 $125,795 $135,082 $136,629 6 7 7 8 8 9 10 11 11 12 Sheet1 Rearly