Using the GPRC and salary survey data provided above (i.e. the first two tables, not the third), construct a line chart that displays GPRC's pay structure relative to the external market. In your chart, create two lines for the external market. The first external market line should include survey data from all sources. The second external market line should include data from all sources except the Bureau of Labor and Statistics (BLS). Be sure to use weighted averages to create your market lines. The gray, blue, and orange lines on the chart are based on completely different data. However, your X axis should display Pay Grades 1 through 8 and your Y axis should be in dollars.

4 Pay Grade 1 1 2 2 6 N N 3 3 3 4 Average Annual Number of Wages Employees $ 20,384 4 $ 19,760 3 $ 25,168 2 $ 24,128 16 $ 24,710 6 $ 26,624 5 $ 31,200 3 $ 27,456 26 $ 30,680 3 $ 29,640 2 $ 33,280 2 $ 42,640 3 $ 37,440 1 $ 54,080 2 $ 41,600 1 $ 66,560 1 $ 63,232 1 $ 56,160 $ 87,360 1 $ 90,064 1 $ 85,010 1 $ 91,520 1 $ 105,019 1 Golden Pond Job Title Custodian Dishwasher Activities Assistant Dietary Server Housekeeper Security Assistant Cook Personal Care Assistant Receptionist Administrative Assistant Admissions Clerk Cook Development Clerk Mechanic Activities Director Dietary Supervisor Facilities Supervisor Housekeeping Supervisor Admissions Coordinator Business Manager Personal Care Director Development Director Executive Director 4 4 4 4 N 5 5 5 5 5 6 6 6 N 7 1 8 1. Cou Survey State Healthcare Salaries Survey State Healthcare Salaries Survey State Healthcare Salaries Survey State Healthcare Salaries Survey Local Chamber of Commerce Survey Local Chamber of Commerce Survey Local Chamber of Commerce Survey Local Chamber of Commerce Survey Local Chamber of Commerce Survey Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics SHRM Survey SHRM Survey SHRM Survey SHRM Survey Trade Association Survey Trade Association Survey Trade Association Survey Trade Association Survey Trade Association Survey Trade Association Survey Compensation Consultant Survey Compensation Consultant Survey Compensation Consultant Survey Compensation Consultant Survey Average Survey Pay Annual Sample Grade Wages Size 2 22,594 2.420 See below to 3 $ 28,721 4,51 learn how this 4 $ 42,593 1,180 value was 5 $ 54,998 1,477 calculated. 4 $ 46,530 122 5 $ 59,475 126 6 $ 96,811 91 7 $ 106,492 74 8 $ 149,348 13 1 $ 19,802 25,251 2 $ 24,554 36,440 3 $ 36,439 78,122 4 $ 50,850 54,682 5 $ 61,500 24,008 6 $ 100,641 48,987 7 $ 103,920 18,111 8 $ 125,530 18,407 5 $ 74,885 3,720 6 $102,829 2,987 7 $ 129,615 2,673 8 $196,510 3,147 1 $ 26,522 452 2 $ 32,382 884 3 $ 37,369 1,253 4 $ 51,937 1,288 5 $ 72,688 1,261 6 $ 99,074 449 5 $ 69,746 150 6 $ 85,537 150 7 $ 92,677 150 8 $ 110,041 150 4 Pay Grade 1 1 2 2 6 N N 3 3 3 4 Average Annual Number of Wages Employees $ 20,384 4 $ 19,760 3 $ 25,168 2 $ 24,128 16 $ 24,710 6 $ 26,624 5 $ 31,200 3 $ 27,456 26 $ 30,680 3 $ 29,640 2 $ 33,280 2 $ 42,640 3 $ 37,440 1 $ 54,080 2 $ 41,600 1 $ 66,560 1 $ 63,232 1 $ 56,160 $ 87,360 1 $ 90,064 1 $ 85,010 1 $ 91,520 1 $ 105,019 1 Golden Pond Job Title Custodian Dishwasher Activities Assistant Dietary Server Housekeeper Security Assistant Cook Personal Care Assistant Receptionist Administrative Assistant Admissions Clerk Cook Development Clerk Mechanic Activities Director Dietary Supervisor Facilities Supervisor Housekeeping Supervisor Admissions Coordinator Business Manager Personal Care Director Development Director Executive Director 4 4 4 4 N 5 5 5 5 5 6 6 6 N 7 1 8 1. Cou Survey State Healthcare Salaries Survey State Healthcare Salaries Survey State Healthcare Salaries Survey State Healthcare Salaries Survey Local Chamber of Commerce Survey Local Chamber of Commerce Survey Local Chamber of Commerce Survey Local Chamber of Commerce Survey Local Chamber of Commerce Survey Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics Bureau of Labor and Statistics SHRM Survey SHRM Survey SHRM Survey SHRM Survey Trade Association Survey Trade Association Survey Trade Association Survey Trade Association Survey Trade Association Survey Trade Association Survey Compensation Consultant Survey Compensation Consultant Survey Compensation Consultant Survey Compensation Consultant Survey Average Survey Pay Annual Sample Grade Wages Size 2 22,594 2.420 See below to 3 $ 28,721 4,51 learn how this 4 $ 42,593 1,180 value was 5 $ 54,998 1,477 calculated. 4 $ 46,530 122 5 $ 59,475 126 6 $ 96,811 91 7 $ 106,492 74 8 $ 149,348 13 1 $ 19,802 25,251 2 $ 24,554 36,440 3 $ 36,439 78,122 4 $ 50,850 54,682 5 $ 61,500 24,008 6 $ 100,641 48,987 7 $ 103,920 18,111 8 $ 125,530 18,407 5 $ 74,885 3,720 6 $102,829 2,987 7 $ 129,615 2,673 8 $196,510 3,147 1 $ 26,522 452 2 $ 32,382 884 3 $ 37,369 1,253 4 $ 51,937 1,288 5 $ 72,688 1,261 6 $ 99,074 449 5 $ 69,746 150 6 $ 85,537 150 7 $ 92,677 150 8 $ 110,041 150