I need help in this, Please do it correctly. Frirst you need to crate the graph and then you need to create the table and answer the questions in second part. Please do it correctly.
Instructions: You have been provided a partially completed pay structure (see graph linked with this assignment) for three positions at Lansdale Tutoring & Testing, Inc.:| Pay Grade Job Evaluation Top of Grade Position Points 1 100-200 $18,000 Elementary Tutor (K-6) 2 201-300 $19,500 Secondary Education Tutor (8-12). humanities 3 301-400 $23.750 Secondary Education Tutor (8-12). math or science Part I: Complete the pay structure for the remaining pay grades by constructing steps based on the guidelines below for time in service in each grade (you may round totals to the nearest $10): Pay Step Data: Entry wage = 65.5% of top for each pay grade o For example, on the graph you have been provided, the bottom of Grade 1 is equal to $18,000 x 655 = $11,790 Step 1: After 1 year within the pay grade = 70% of top Step 2: After 3 years within the pay grade = 75% of top Step 3: After 5 years within the pay grade = 82% of top Step 4: After 8 years within the pay grade = 90% of top Top of grade: After 10 years within pay grade (refer to table for specific amounts) o Hint: First, establish both top of grade and entry wage information for each pay grade using the information below. Next, use the information provided above to calculate pay steps within each grade. . Part II: Please consider the following employees in each pay grade and their current salaries. Using the pay step data above, please indicate (a) if each individual is above (overpaid), below (underpaid), or within step (paid correctly) for his or her pay grade, and (b) how you know this. For example, Charles Hamilton is an Elementary Instructor (shown below). Looking at the table on page 1, we know that these workers are in Grade 1. Steps are based on years of service (Part I, above). If Charles has worked at the company for 6 years, he should be in Step 3 (but below Step 4). Step 3 ranges from $14,760 to $16,200. Charles pay of $15,109 is within that range, meaning his pay is within step" in comp and benefits terminology. Elementary Instructor (K-6): (1) Charles Hamilton, 6 years' service - paid $15,109 (2) Mary Richardson, 10 years' service - paid $16,300 Secondary Education Instructor (8-12), humanities: (3) Jerry Smith - 2 years' service paid $18.700 (4) Theresa Jones 5 years' service - paid $15.800 Secondary Education Instructor (8-12), math or science: (5) Alicia Wadsworth - 5 years' service - paid $21,475 (6) Connie Johnston 7 years' service - paid $20,650 27,000 26,000 25,000 24,000 23,000 22,000 21,000 20,000 19,000 Wage Rate GRADE 1 $18,000 18,000 17,000 16,000 15,000 14,000 13,000 12,000 $11,790 11,000 Acti Go to 500 100 200 400 300 Points Instructions: You have been provided a partially completed pay structure (see graph linked with this assignment) for three positions at Lansdale Tutoring & Testing, Inc.:| Pay Grade Job Evaluation Top of Grade Position Points 1 100-200 $18,000 Elementary Tutor (K-6) 2 201-300 $19,500 Secondary Education Tutor (8-12). humanities 3 301-400 $23.750 Secondary Education Tutor (8-12). math or science Part I: Complete the pay structure for the remaining pay grades by constructing steps based on the guidelines below for time in service in each grade (you may round totals to the nearest $10): Pay Step Data: Entry wage = 65.5% of top for each pay grade o For example, on the graph you have been provided, the bottom of Grade 1 is equal to $18,000 x 655 = $11,790 Step 1: After 1 year within the pay grade = 70% of top Step 2: After 3 years within the pay grade = 75% of top Step 3: After 5 years within the pay grade = 82% of top Step 4: After 8 years within the pay grade = 90% of top Top of grade: After 10 years within pay grade (refer to table for specific amounts) o Hint: First, establish both top of grade and entry wage information for each pay grade using the information below. Next, use the information provided above to calculate pay steps within each grade. . Part II: Please consider the following employees in each pay grade and their current salaries. Using the pay step data above, please indicate (a) if each individual is above (overpaid), below (underpaid), or within step (paid correctly) for his or her pay grade, and (b) how you know this. For example, Charles Hamilton is an Elementary Instructor (shown below). Looking at the table on page 1, we know that these workers are in Grade 1. Steps are based on years of service (Part I, above). If Charles has worked at the company for 6 years, he should be in Step 3 (but below Step 4). Step 3 ranges from $14,760 to $16,200. Charles pay of $15,109 is within that range, meaning his pay is within step" in comp and benefits terminology. Elementary Instructor (K-6): (1) Charles Hamilton, 6 years' service - paid $15,109 (2) Mary Richardson, 10 years' service - paid $16,300 Secondary Education Instructor (8-12), humanities: (3) Jerry Smith - 2 years' service paid $18.700 (4) Theresa Jones 5 years' service - paid $15.800 Secondary Education Instructor (8-12), math or science: (5) Alicia Wadsworth - 5 years' service - paid $21,475 (6) Connie Johnston 7 years' service - paid $20,650 27,000 26,000 25,000 24,000 23,000 22,000 21,000 20,000 19,000 Wage Rate GRADE 1 $18,000 18,000 17,000 16,000 15,000 14,000 13,000 12,000 $11,790 11,000 Acti Go to 500 100 200 400 300 Points
