Compensation (human resources management)

profileaccursedarena
Home>Homework Answsers>Human Resource Management homework help
EXCEL

according to those data in Excel, answer few questions.

  • 3 years ago
  • 30
Report issue
files (2)

BasicsofPayStructures1.xlsx

Sheet1

Pay Policy Line Y = 7.5 + 0.3x
Y-intercept Pay Policy 7.5
Slope Pay Policy 0.3
Pay Grade Evaluation Point Min Evaluation Point Max Evluation Points Midpoint Spread Salary Midpoint (Based on Pay Policy Line) Salary Min Salary Max
A 0 50 25 20%
B 51 100 75.5 30%
Hourly Wage Position Evaluation Points Property Pay Grade Spread Salary Midpoint (Based on Pay Policy Line) MIN MAX Green Red Individual compa-ratio
$15.00 Front Desk Agent 25 San Antonio A 20% $ - 0 $ - 0 $ - 0
$16.00 Front Desk Agent 25 San Antonio A 20% $ - 0 $ - 0 $ - 0 Complete individually or in groups
$14.00 Front Desk Agent 25 San Antonio A 20% $ - 0 $ - 0 $ - 0 1) Calculuate the salary midpoint using the pay policy line
$14.50 Front Desk Agent 25 San Antonio A 20% $ - 0 $ - 0 $ - 0 2) Calculuate the min/max pay range for each pay grade
$18.00 Front Desk Agent 25 Austin A 20% $ - 0 $ - 0 $ - 0 3) Using IF statements, identify which employees are green/red circled
$12.50 Front Desk Agent 25 Austin A 20% $ - 0 $ - 0 $ - 0 4) Calculuate compa-ratio
$15.50 Front Desk Agent 25 Austin A 20% $ - 0 $ - 0 $ - 0 5) Create a Pivot Table, calculating each property's average compa-ratio
$16.50 Front Desk Agent 25 Austin A 20% $ - 0 $ - 0 $ - 0 6) Create a Pivot Table, calculuating each property's average salary
$16.00 Front Desk Agent 25 Austin A 20% $ - 0 $ - 0 $ - 0
$13.50 Front Desk Agent 25 Austin A 20% $ - 0 $ - 0 $ - 0
$40.50 Front Desk Supervisor 75 Austin B 30% $ - 0 $ - 0 $ - 0 Answer in groups
$14.00 Front Desk Clerk 35 Dallas A 20% $ - 0 $ - 0 $ - 0 1) Which property has the lowest average compa-ratio?
$15.50 Front Desk Clerk 35 Dallas A 20% $ - 0 $ - 0 $ - 0 2) How many green circled employee are there? What do you recommend doing with them?
$18.50 Front Desk Clerk 35 Dallas A 20% $ - 0 $ - 0 $ - 0 3) How many red circled employees are there? What do you recommend doing with them?
$13.50 Front Desk Clerk 35 Dallas A 20% $ - 0 $ - 0 $ - 0
$14.25 Front Desk Clerk 35 Dallas A 20% $ - 0 $ - 0 $ - 0
$15.50 Front Desk Clerk 35 Dallas A 20% $ - 0 $ - 0 $ - 0
$16.50 Front Desk Clerk 35 Dallas A 20% $ - 0 $ - 0 $ - 0
$14.50 Front Desk Clerk 35 Dallas A 20% $ - 0 $ - 0 $ - 0
$13.00 Front Desk Clerk 35 Ft. Worth A 20% $ - 0 $ - 0 $ - 0
$14.00 Front Desk Clerk 35 Ft. Worth A 20% $ - 0 $ - 0 $ - 0
$15.50 Front Desk Clerk 35 Ft. Worth A 20% $ - 0 $ - 0 $ - 0
$16.50 Front Desk Clerk 35 Ft. Worth A 20% $ - 0 $ - 0 $ - 0
$18.00 Front Desk Clerk 35 Ft. Worth A 20% $ - 0 $ - 0 $ - 0
$16.00 Front Desk Clerk 35 Ft. Worth A 20% $ - 0 $ - 0 $ - 0
$15.00 Front Desk Clerk 35 Ft. Worth A 20% $ - 0 $ - 0 $ - 0
$14.00 Front Desk Clerk 35 Ft. Worth A 20% $ - 0 $ - 0 $ - 0
$33.00 Front Office Manager 90 Ft. Worth B 30% $ - 0 $ - 0 $ - 0
$15.00 Front Desk Agent 25 Waco A 20% $ - 0 $ - 0 $ - 0
$14.00 Front Desk Agent 25 Waco A 20% $ - 0 $ - 0 $ - 0
$15.00 Front Desk Agent 25 Waco A 20% $ - 0 $ - 0 $ - 0
$15.50 Front Desk Agent 25 Waco A 20% $ - 0 $ - 0 $ - 0
$16.50 Front Desk Agent 25 Waco A 20% $ - 0 $ - 0 $ - 0
$16.00 Front Desk Agent 25 Waco A 20% $ - 0 $ - 0 $ - 0
$35.00 Front Desk Supervisor 75 Waco B 30% $ - 0 $ - 0 $ - 0