Question
You are required to answer the following questions. Some questions require a description of the process. Other questions require that you show calculations and answers.
You are required to answer the following questions. Some questions require a description of the process. Other questions require that you show calculations and answers.
- What is an outlier and how you would deal with outliers.
- Discuss what is meant by job matching. Use the following criteria for job matches: Benchmark Jobs 1, 2 and 3 must match at 80%; Benchmark Jobs 4 and 5 must match at 70%. Eliminate data that does not meet the criteria. Indicate what data has been eliminated.
- Describe "aging the data" and then age the remaining data. Use an annual inflation rate of 5.8%. The effective date of your new wage schedule will be June 1, 2023. Present the aged job rates.
- Average the data for each benchmark job using the weighted mean. Show your work and show the weighted mean for each benchmark job.
- For the Market Line, what are the labels and values on the Y -axis and the labels and values on the X-axis.
- You have decided to use the "Match" pay policy. For Pay Line One, what are the labels and values on the Y-axis and X-axis. Run the regression program on your computer. What are the values of the y-intercept and the slope of the regression line?
- For Pay Line Two, using the values in the Job Evaluation System Table below, what are the labels and values on the Y-axis and the X-axis.
Using the "regression equation" and data from the Pay Line Two, calculate the New Job Rate for each of the five pay grades.
- Create the Wage Schedule for the hourly Job Family clearly indicating five specific wage ranges and overlaps. You determine the spread within each Pay Grade. The effective date will be June 1, 2023. Show all appropriate labels on the new wage schedule. Below the Wage Schedule but not part of the Wage Schedule, also include a brief explanation regarding the design of your new wage schedule: decisions that you made regarding how long to reach Job Rates; range overlaps; minimum rates.
| Job Evaluation System Table Pay Grade | Job Evaluation Point Spread | Actual Job Evaluation Points of Benchmark Jobs | Median Job Evaluation Points of each Pay Grade | |
| 5 | 800-1000 | 860 | 900 | |
| 4 | 601-799 | 650 | 700 | |
| 3 | 450-600 | 520 | 550 | |
| 2 | 301-449 | 340 | 375 | |
| 1 | 190-300 | 290 | 245 |
Wages Survey Response for Job 1
| Company A | Company B | Company C | Company D | Company E | |
| Match % | 100 | 95 | 90 | 85 | 90 |
| Job Rate | $15.65/hr | $15.50 | $16 | $15.95 | $16.25 |
| # Employees | 20 | 25 | 5 | 2 | 15 |
| Benefits % | 25 | 30 | 30 | 20 | 35 |
| Last Incr. Date | Sept '22 | Oct '22 | Nov '22 | Dec '22 | Jan '23 |
| Company F | Company G | Company H | Company I | Company J | |
| Match % | 70 | 80 | 100 | 90 | 80 |
| Range | $16.30 | $15.80 | $15.60 | $16.25 | $16.50 |
| # Employees | 4 | 20 | 11 | 21 | 30 |
| Benefits % | 36 | 30 | 20 | 30 | 35 |
| Last Incr. Date | Feb '23 | June '22 | April '22 | May '22 | June '22 |
Wages Survey Response for Job 2
| Company A | Company B | Company C | Company D | Company E | |
| Match % | 80 | 70 | 70 | 80 | 90 |
| Job Rate | $17.50/hr | $17 | $16.50 | $18.50 | $17.75 |
| # Employees | 8 | 6 | 10 | 5 | 3 |
| Benefits % | 25 | 30 | 30 | 20 | 35 |
| Last Incr. Date | Sept '22 | Oct '22 | Nov '22 | Dec '22 | Jan '23 |
| Company F | Company G | Company H | Company I | Company J | |
| Match % | 100 | 100 | 80 | 60 | 75 |
| Job Rate | $17.25 | $18.70 | $17.90 | $18.90 | $20 |
| # Employees | 12 | 14 | 20 | 22 | 25 |
| Benefits % | 36 | 30 | 20 | 30 | 35 |
| Last Incr. Date | Feb '23 | June '22 | April '22 | May '22 | June '22 |
Wages Survey Response for Job 3
| Company A | Company B | Company C | Company D | Company E | |
| Match % | 70 | 75 | 65 | 80 | 80 |
| Job Rate | $18/hr | $19 | $18.75 | $19.50 | $19.80 |
| # Employees | 4 | 5 | 3 | 7 | 6 |
| Benefits % | 25 | 30 | 30 | 20 | 35 |
| Last Incr. Date | Sept '22 | Oct '22 | Nov '22 | Dec '22 | Jan '23 |
| Company F | Company G | Company H | Company I | Company J | |
| Match % | 90 | 80 | 75 | 90 | 90 |
| Job Rate | $17.50/hr | $18.80 | $18.65 | $17.90 | $19 |
| # Employees | 15 | 9 | 2 | 7 | 14 |
| Benefits % | 36 | 30 | 20 | 30 | 35 |
| Last Incr. Date | Feb '23 | June '22 | April '22 | May '22 | June '22 |
Wages Survey Response for Job 4
| Company A | Company B | Company C | Company D | Company E | |
| Match % | 70 | 70 | 75 | 80 | 80 |
| Job Rate | $ 22/hr | $20 | $22 | $20 | $24 |
| # Employees | 1 | 3 | 2 | 5 | 6 |
| Benefits % | 25 | 30 | 30 | 20 | 35 |
| Last Incr. Date | Sept '22 | Oct '22 | Nov '22 | Dec '22 | Jan '23 |
| Company F | Company G | Company H | Company I | Company J | |
| Match % | 85 | 80 | 90 | 95 | 80 |
| Job Rate | $21/hr | $19.75 | $23 | $21 | $22.75 |
| # Employees | 4 | 3 | 8 | 5 | 12 |
| Benefits % | 36 | 30 | 20 | 30 | 35 |
Wages Survey Response for Job 5
| Company A | Company B | Company C | Company D | Company E | |
| Match % | 70 | 75 | 90 | 95 | 50 |
| Job Rate | $25 | $26.75 | $24 | $25 | $27 |
| # Employees | 1 | 3 | 5 | 2 | 4 |
| Benefits % | 25 | 30 | 30 | 20 | 35 |
| Last Incr. Date | Sept '22 | Oct '22 | Nov '22 | Dec '22 | Jan '23 |
| Company F | Company G | Company H | Company I | Company J | |
| Match % | 50 | 65 | 75 | 70 | 80 |
| Job Rate | $28 | $28 | $26 | $27.50 | $25.50 |
| # Employees | 3 | 1 | 1 | 3 | 2 |
| Benefits % | 36 | 30 | 20 | 30 | 35 |
| Last Incr. Date | Feb '23 | June '22 | April '22 | May '22 | June '22 |
Step by Step Solution
3.39 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
Certainly Lets address each question What is an outlier and how would you deal with outliers An outlier is a data point that significantly deviates fr...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Income Tax Fundamentals 2013
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
31st Edition
1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516
