PLEASE READ: I know the instructions look like this is a big problem but it's just a long description with only one question. please show me step-by-step how to complete this, I am being tested on it tonight. thank you!You are the new head of human resources for Flat Tire Rent- a-Car. You want to ensure that your staff are paid appropriately As such, you want to inspect the wage structure of the positions you are supervising and identify any problems (e.g., overpayment, underpayment ) Wage structures are made up of pay grades and, within them, step ranges (Fig. ) In this organization, one's pay grade is determined by their job title, and one's step range within the grade- is determined by their duration of employment with the organization The tables contained in this exercise provide several forms of pay data a pay grade table indicating job evaluation points and top of grade pay for each of four positions (Table )pay steps and promotion eligibility criteria Table 2), and a table of current employees, their job titles, tenure in weeks, and current pay (Table 3). Figure 2 shows a chart of the pay grades and pay step ranges As an example, as shown in Figure 2, Brown is a maintenance staff member and, thus belongs in Pay Grade 1 (which has a maximum pay rate of 50,000)However, Brown has over 250 completed weeks of service with the organization and, thus, Brown should be located within Step Range of Pay Grade Thus, according Table 2, Brown should be paid between $42,500 (which is % of 50,000) and $50,000 (which is 100% of 50,000)As shown in Figure 2 (and Table 3), Brown's current pay is 49,000. Thus, Brown is paid appropriately 1. Complete the chart shown in Figure 2 (i.e., draw the limits for Pay Grade 4 limits for all other pay grades are already provided ). 2. Insert each employee's name into the chart, noting which are overpaid, underpaid, and appropriately paid- or if any are green-circled or red-circled. ### Table 1: Pay Grade Data| Pay Grade | Job Evaluation Points | Top of Grade | Position ||-----------|-----------------------|--------------|---------------------|| 1 | 100—200 | $50,000 | Maintenance staff || 2 | 201—300 | $70,000 | Sales associate || 3 | 301—400 | $100,000 | Branch manager || 4 | 401—500 | $120,000 | District manager |### Table 2: Pay Step Data| Step Range | Lower Limit | Upper Limit | Promotion Eligibility Criterion ||------------|------------------------|------------------------|------------------------------------------------------------------------|| SR1 | >= 40% of top of grade | < 55% of top of grade | || SR2 | >= 55% of top of grade | < 70% of top of grade | (SR1 → SR2): 104 weeks of service with the organization || SR3 | >= 70% of top of grade | < 85% of top of grade | (SR2 → SR3): 156 weeks of service with the organization || SR4 | >= 85% of top of grade | <= 100% of top of grade | (SR3 → SR4): 208 weeks of service with the organization |### Table 3: Current Employee Data| Last Name | Position | Tenure (Weeks Completed) | Step Range (should be) | Current Annual Salary | Step Range (based on pay) ||-----------|-----------------|--------------------------|------------------------|-----------------------|---------------------------|| Brown | Maintenance | 285 | | $49,000 | || Reid | Maintenance | 190 | | $40,000 | || Webster | Maintenance | 250 | | $52,000 | || Carter | Maintenance | 62 | | $26,000 | || Sherman | Sales associate | 195 | | $52,000 | || Barrett | Sales associate | 52 | | $25,000 | || Snyder | Sales associate | 200 | The image is a box plot illustrating the distribution of annual salaries across different pay grades (Grade 1 to Grade 4).**Axes:**- The horizontal axis represents "Pay Grade," with four levels: Grade 1, Grade 2, Grade 3, and Grade 4.- The vertical axis represents "Annual Salary," ranging from $20,000 to $110,000, in increments of $2,000.**Box Plot Details:**- Each box plot reflects the salary range for a specific pay grade, showing the minimum, first quartile, median, third quartile, and maximum values. **Grade 1:**- The box plot for Grade 1 shows a relatively narrow salary range, approximately from $22,000 to $40,000.- The median salary is around $30,000.**Grade 2:**- For Grade 2, the salary range expands from about $36,000 to $64,000.- The median is higher, roughly at $48,000.**Grade 3:**- Grade 3 salaries range from approximately $52,000 to $78,000.- The median is around $62,000.**Grade 4:**- The salary range for Grade 4 is the widest, from roughly $66,000 to $102,000.- The median salary is about $84,000.**Additional Note:**- There is a note labeled “Brown” next to Grade 1, though its context requires further information for clarification. These box plots visually depict how salaries tend to increase with each pay grade, illustrating the potential salary growth associated with higher pay grades.

1. We have to complete the chart in the figure below for Pay Grade 4. We can see from Table 1, that for Pay Grade 4, the Top of Grade is $120,000. For Entry wage or the bottommost line, we mark the line at 40% of Top Grade (according to Table 2), that is, 40%×120000=48000 at $48000. From Table 2, Step Range 1 or SR1 has upper limit at 55% of Top Grade, which is 55%×120000=66000 at $66000. Step Range 2 has lower limit at 55% of Top Grade, which is $66000 and upper limit at 70% of Top Grade, which is 70%×120000=84000 at $84000.Similarly, Step Range 3 has lower limit at 70% of Top Grade, which is $84000 and upper limit at 85% of Top Grade, which is 85%×120000=102000 at $102000, and Step Range 4 has lower limit at 85% of Top Grade, which is $102000 and upper limit at 100% of Top Grade, which is at $120000. So, we have the chart with Pay Grade 4 :2. We will now decide whether an employee is overpaid, underpaid or paid appropriately. Reid is a maintenance staff member and, thus belongs in Pay Grade 1 (which has a maximum pay rate of 50,000). However, Reid has 190 completed weeks of service with the organization and, thus, Reid should be located within Step Range 3 of Pay Grade 1. Thus, according Table 2, Reid should be paid between $35,000 (which is 70% of 50,000) and $42,500 (which is 85% of 50,000). As shown in Figure 2 (and Table 3), Reid's current pay is 40,000. Thus, Reid is paid appropriately. Webster is a maintenance staff member and, thus belongs in Pay Grade 1 (which has a maximum pay rate of 50,000). However, Webster has 250 completed weeks of service with the organization and, thus, Webster should be located within Step Range 4 of Pay Grade 1. Thus, according Table 2, Webster should be paid between $42,500 (which is 85% of 50,000) and $50,000 (which is 100% of 50,000). As shown in Figure 2 (and Table 3), Webster's current pay is 52,000. Thus, Webster is overpaid. Carter is a maintenance staff member and, thus belongs in Pay Grade 1 (which has a maximum pay rate of 50,000). However, Carter has 62 completed weeks of service with the organization and, thus, Carter should be located within Step Range 1 of Pay Grade 1. Thus, according Table 2, Carter should be paid between $20,000 (which is 40% of 50,000) and $27,500 (which is 55% of 50,000). As shown in Figure 2 (and Table 3), Carter's current pay is 26,000. Thus, Carter is paid appropriately.Sherman is a Sales Associate and, thus belongs in Pay Grade 2 (which has a maximum pay rate of 70,000). However, Sherman has 195 completed weeks of service with the organization and, thus, Sherman should be located within Step Range 3 of Pay Grade. Thus, according Table 2, Sherman should be paid between $49,000 (which is 70% of 70,000) and $59,500 (which is 85% of 70,000). As shown in Figure 2 (and Table 3), Sherman's current pay is 52,500. Thus, Sherman is paid appropriately. Barrett is a Sales Associate and, thus belongs in Pay Grade 2 (which has a maximum pay rate of 70,000). However, Barrett has 52 completed weeks of service with the organization and, thus, Barrett should be located within Step Range 1 of Pay Grade 1. Thus, according Table 2, Barrett should be paid between $28,000 (which is 40% of 70,000) and $38,500 (which is 55% of 70,000). As shown in Figure 2 (and Table 3), Barrett's current pay is 25,000. Thus, Barrett is underpaid. Snyder is a Sales Associate and, thus belongs in Pay Grade 2 (which has a maximum pay rate of 70,000). However, Snyder has 200 completed weeks of service with the organization and, thus, Snyder should be located within Step Range 3 of Pay Grade 2. Thus, according Table 2, Snyder should be paid between $49,000 (which is 70% of 70,000) and $59,500 (which is 85% of 70,000). As shown in Figure 2 (and Table 3), Snyder's current pay is 68,000. Thus, Snyder is paid appropriately.Gomez is a Branch Manager and, thus belongs in Pay Grade 3 (which has a maximum pay rate of 100,000). However, Gomez has 150 completed weeks of service with the organization and, thus, Gomez should be located within Step Range 2 of Pay Grade 3. Thus, according Table 2, Gomez should be paid between $55,000 (which is 55% of 100,000) and $70,000 (which is 70% of 100,000). As shown in Figure 2 (and Table 3), Gomez's current pay is 68,000. Thus, Gomez is paid appropriately. Bennett is a Branch Manager and, thus belongs in Pay Grade 3 (which has a maximum pay rate of 100,000). However, Bennett has 110 completed weeks of service with the organization and, thus, Bennett should be located within Step Range 2 of Pay Grade 3. Thus, according Table 2, Bennett should be paid between $55,000 (which is 55% of 100,000) and $70,000 (which is 70% of 100,000). As shown in Figure 2 (and Table 3), Bennett's current pay is 41,000. Thus, Barrett is underpaid. Stanley is a District Manager and, thus belongs in Pay Grade 4 (which has a maximum pay rate of 120,000). However, Stanley has 55 completed weeks of service with the organization and, thus, Stanley should be located within Step Range 1 of Pay Grade 4. Thus, according Table 2, Stanley should be paid between $48,000 (which is 40% of 120,000) and $66,000 (which is 55% of 120,000). As shown in Figure 2 (and Table 3), Stanley's current pay is 46,000. Thus, Stanley is underpaid. Wade is a District Manager and, thus belongs in Pay Grade 4 (which has a maximum pay rate of 120,000). However, Wade has 225 completed weeks of service with the organization and, thus, Wade should be located within Step Range 4 of Pay Grade 4. Thus, according Table 2, Wade should be paid between $102,000 (which is 85% of 120,000) and $120,000 (which is 100% of 120,000). As shown in Figure 2 (and Table 3), Wade's current pay is 118,000. Thus, Wade is paid appropriately.