Loading...
3.c Discussion on Classification and Compensation StudySalary Curve y = 118.48x + 23542 R² = 0.997 0 20,000 40,000 60,000 80,000 100,000 120,000 0 100 200 300 400 500 600 700 800Survey Mid-Point (y)SAFE Total Points (x) Scandia, Minnesota Compensation Survey CITY OF SCANDIA 2019 Pay Scale % Between Grades: 7% % Between Steps: 3.5% Starting midpoint: 32,900 Grade 1 2 3 4 5 6 7 8 9 1 28,670.45 29,673.92 30,712.50 31,787.44 32,900.00 34,051.50 35,243.30 36,476.82 37,753.51 2 30,534.03 31,602.72 32,708.81 33,853.62 35,038.50 36,264.85 37,534.12 38,847.81 40,207.48 3 32,518.74 33,656.90 34,834.89 36,054.11 37,316.00 38,622.06 39,973.83 41,372.92 42,820.97 4 34,632.46 35,844.59 37,099.16 38,397.63 39,741.54 41,132.50 42,572.13 44,062.16 45,604.33 5 36,883.57 38,174.49 39,510.60 40,893.47 42,324.74 43,806.11 45,339.32 46,926.20 48,568.62 6 39,281.00 40,655.84 42,078.79 43,551.55 45,075.85 46,653.51 48,286.38 49,976.40 51,725.58 7 41,834.27 43,298.46 44,813.91 46,382.40 48,005.78 49,685.98 51,424.99 53,224.87 55,087.74 8 44,553.49 46,112.86 47,726.81 49,397.25 51,126.16 52,915.57 54,767.62 56,684.48 58,668.44 9 47,449.47 49,110.20 50,829.06 52,608.07 54,449.36 56,355.09 58,327.51 60,368.98 62,481.89 10 50,533.68 52,302.36 54,132.95 56,027.60 57,988.57 60,018.17 62,118.80 64,292.96 66,543.21 11 53,818.37 55,702.02 57,651.59 59,669.39 61,757.82 63,919.35 66,156.52 68,472.00 70,868.52 12 57,316.57 59,322.65 61,398.94 63,547.90 65,772.08 68,074.10 70,456.70 72,922.68 75,474.98 13 61,042.15 63,178.62 65,389.87 67,678.52 70,047.27 72,498.92 75,036.38 77,662.66 80,380.85 14 65,009.89 67,285.23 69,640.21 72,077.62 74,600.34 77,211.35 79,913.75 82,710.73 85,605.60 15 69,235.53 71,658.77 74,166.83 76,762.67 79,449.36 82,230.09 85,108.14 88,086.93 91,169.97 16 73,735.84 76,316.59 78,987.67 81,752.24 84,613.57 87,575.04 90,640.17 93,812.58 97,096.02 17 78,528.67 81,277.17 84,121.87 87,066.14 90,113.45 93,267.42 96,531.78 99,910.39 103,407.26 18 83,633.03 86,560.19 89,589.79 92,725.44 95,970.83 99,329.80 102,806.35 106,404.57 110,128.73 19 89,069.18 92,186.60 95,413.13 98,752.59 102,208.93 105,786.24 109,488.76 113,320.87 117,287.10 20 94,858.67 98,178.73 101,614.98 105,171.51 108,852.51 112,662.35 116,605.53 120,686.72 124,910.76 21 101,024.49 104,560.34 108,219.96 112,007.65 115,927.92 119,985.40 124,184.89 128,531.36 133,029.96 Grade 1 2 3 4 5 6 7 8 9 1 13.78 14.27 14.77 15.28 15.82 16.37 16.94 17.54 18.15 2 14.68 15.19 15.73 16.28 16.85 17.44 18.05 18.68 19.33 3 15.63 16.18 16.75 17.33 17.94 18.57 19.22 19.89 20.59 4 16.65 17.23 17.84 18.46 19.11 19.78 20.47 21.18 21.93 5 17.73 18.35 19.00 19.66 20.35 21.06 21.80 22.56 23.35 6 18.89 19.55 20.23 20.94 21.67 22.43 23.21 24.03 24.87 7 20.11 20.82 21.55 22.30 23.08 23.89 24.72 25.59 26.48 8 21.42 22.17 22.95 23.75 24.58 25.44 26.33 27.25 28.21 9 22.81 23.61 24.44 25.29 26.18 27.09 28.04 29.02 30.04 10 24.30 25.15 26.03 26.94 27.88 28.85 29.86 30.91 31.99 11 25.87 26.78 27.72 28.69 29.69 30.73 31.81 32.92 34.07 12 27.56 28.52 29.52 30.55 31.62 32.73 33.87 35.06 36.29 13 29.35 30.37 31.44 32.54 33.68 34.86 36.08 37.34 38.64 14 31.25 32.35 33.48 34.65 35.87 37.12 38.42 39.76 41.16 15 33.29 34.45 35.66 36.91 38.20 39.53 40.92 42.35 43.83 16 35.45 36.69 37.97 39.30 40.68 42.10 43.58 45.10 46.68 17 37.75 39.08 40.44 41.86 43.32 44.84 46.41 48.03 49.72 18 40.21 41.62 43.07 44.58 46.14 47.75 49.43 51.16 52.95 19 42.82 44.32 45.87 47.48 49.14 50.86 52.64 54.48 56.39 20 45.61 47.20 48.85 50.56 52.33 54.16 56.06 58.02 60.05 21 48.57 50.27 52.03 53.85 55.73 57.69 59.70 61.79 63.96 Step Hourly - Step CITY OF SCANDIA Scale Grade Title Grade 1 2 3 4 5 6 7 8 9 Office Assistant - PT 4 34,632.46 35,844.59 37,099.16 38,397.63 39,741.54 41,132.50 42,572.13 44,062.16 45,604.33 Treasurer - PT 6 39,281.00 40,655.84 42,078.79 43,551.55 45,075.85 46,653.51 48,286.38 49,976.40 51,725.58 Deputy Clerk 8 44,553.49 46,112.86 47,726.81 49,397.25 51,126.16 52,915.57 54,767.62 56,684.48 58,668.44 Maintenance Worker 9 47,449.47 49,110.20 50,829.06 52,608.07 54,449.36 56,355.09 58,327.51 60,368.98 62,481.89 Director of Public Works 17 78,528.67 81,277.17 84,121.87 87,066.14 90,113.45 93,267.42 96,531.78 99,910.39 103,407.26 City Administrator/Clerk 19 89,069.18 92,186.60 95,413.13 98,752.59 102,208.93 105,786.24 109,488.76 113,320.87 117,287.10 Salary Survey vs Proposed Title Min % Diff Min % Diff Mid % Diff Max % Diff Office Assistant - PT 34936.067 -0.008767 34,936.07 -0.88% 39,214.95 1.34% 43,493.83 4.85% Treasurer - PT Deputy Clerk 41676.6 0.069029 41,676.60 6.90% 50,290.75 1.66% 60,629.33 -3.34% Maintenance Worker 46901.314 0.0116874 46,901.31 1.17% 53,858.87 1.10% 60,907.66 2.58% Director of Public Works 79930.448 -0.017851 79,930.45 -1.79% 89,315.41 0.89% 98,702.68 4.77% City Administrator/Clerk 90410.427 -0.015059 90,410.43 -1.51% 103,388.38 -1.15% 116,897.30 0.33% Title Min % Diff Mid % Diff Max % Diff Office Assistant - PT 32,177.60 7.63% 36,202.40 13.62% 40,227.20 13.37% Treasurer - PT Deputy Clerk 45,052.80 -1.12% 50,315.20 5.17% 55,577.60 5.56% Maintenance Worker 45,052.80 5.32% 50,315.20 12.00% 55,577.60 12.42% Director of Public Works 58,437.00 34.38% 65,741.50 41.87% 73,046.00 41.56% City Administrator/Clerk 73,320.00 21.48% 82,485.00 28.25% 91,650.00 27.97% Current vs Proposed Proposed - 2019 Salary Survey vs Proposed CITY OF SCANDIA Impact # of Staff Current Salary Proposed Salary Difference % Increase Totals 8 387,646.48$ 406,503.52$ 18,857.04$ 4.86% Employee Below Min 2 148,740.80$ 167,597.84$ 18,857.04$ 12.68% Employee Within Range 6 238,905.68$ 238,905.68$ -$ Employee Above Max 0 -$ -$ -$ For employees 8 387,646.48$ 406,503.52$ 18,857.04$ For union breakdown 10 743,704.00$ 837,989.22$ 94,285.22$ # of Staff Current Salary Proposed Salary Difference % Increase Totals 8 387,646.48$ 410,296.12$ 22,649.64$ 5.84%0 0 -$ Employee Below Min 2 148,740.80$ 167,597.84$ 18,857.04$ 12.68% Employee Within Range 6 238,905.68$ 242,698.28$ 3,792.60$ 1.59% Employee Above Max 0 -$ -$ -$ For employees 8 387,646.48$ 410,296.12$ 22,649.64$ For union breakdown 10 743,704.00$ 837,989.22$ 94,285.22$ # of Staff Current Salary Proposed Salary Difference % Increase Totals 8 387,646.48$ 455,728.33$ 68,081.85$ 17.56%0 0 -$ Employee Below Min 2 148,740.80$ 182,874.46$ 34,133.66$ 22.95% Employee Within Range 6 238,905.68$ 272,853.87$ 33,948.19$ 14.21% Employee Above Max 0 -$ -$ -$ For employees 8 387,646.48$ 455,728.33$ 68,081.85$ For union breakdown 10 743,704.00$ 914,372.30$ 170,668.30$ Option 1 - Move to Min Option 2 - Next Step Option 3 - Yrs of Svc