8. Payroll Administrator Administers and processes all employee payroll, generating payroll and maintaining general ledger entries. Submits deposits. Completes all quarterly, annual, and other related payroll reports. Completes all year-end reconciliations. Associate's degree with a minimum of 3 years' related work experience. D. The above range now becomes the salary range for the job in this example. Further information regarding the structure of the range is shown in the below diagram. Go to next page. Employee Compensation \& Benefits Class - 3 3. Events Coordinator Plans, organizes, coordinates, promotes, and facilitates special events. Schedules and maintains communication with speakers, vendors, and participants. Coordinates and monitors event timelines. Reviews and analyzes evaluations. Assists in the preparation of a variety of publications, materials, and programs for events. Associate's degree with a minimum of one-year related experience. Bachelor's Degree preferred. Experience working with budgets preferred. 4. HR Director Leads the Human Resources function for the company. Develops strategies to increase organization success through its people via different programs such as Talent Acquisition, Compensation and Benefits, Performance Management \& Development, Success Planning. Oversee employee surveys and regularly measures the organization culture and engagement along with other analytics to assess gaps and identify solutions. Advises the Executive Director on critical HR decisions and leads the HR team providing direction, guidance and coaching to ensure goal achievement. 5. HR Generalist 6. Marketing \& Comm Mgr 7. Network Admin Assist in the development and implementation of Human Resources policies, programs, practices, and processes that include but not limited to: recruitment and selection; employment processing; compensation, benefits; training and development; records management; employee and labor relations; employee engagement and retention; performance management; and EEO compliance. Provides support, consultation and services in all these areas to managers and employees. Bachelor's Degree with a minimum of 3 years related experience; SHRMCP or SHRM-SCP credential preferred. Manages the production of the company's magazine and newsletters to customers, manages all social media; designs, produces and manages the development of all marketing related materials including signage, displays, brochures, and all print/on-line materials for events, conferences, meetings and specialty societies. Supervises the photography and/or filming of events and manages / maintains the company's website. Designs graphics for the website, publications, social platforms and events maintaining consistency and alignment with branding / messaging standards. Bachelor's Degree in Marketing Communications or related field with a minimum five years' related experience. Maintains efficient operation of wireless network and wireless equipment. Troubleshoots and corrects minor equipment malfunctions. Prepares computer and other equipment for operation; sets up and loads computers with specified applications. Provides technology support on a variety of servers, printers, and software; ensures all computers are protected by anti-virus software. Bachelor's Degree in related field with 1-2 years related experience. SALARY MARKET ANALYSIS JOB DESCRIPTION SUMMARIES JOB TITLE 1. Executive Asst 2. Executive Director DESCRIPTION SUMMARY Serves as the primary point of contact for internal employees and external contacts on all matters pertaining to the President and CEO; provides executive support to the Executive Team while serving as a liaison to the board of directors and Executive Team; Completes a broad array of administrative tasks for the President and CEO including, managing active calendar appointments; completing expense reports; composing and preparing correspondence. Assists in developing budgets and tracking expenditures. Communicates directly, and on behalf of the President and CEO with Board members, customers or clients, and staff on matters related to the President and CEO's initiatives, projects, or activities. Manages inquiries and refers to appropriate parties or handles accordingly or refers to CEO when necessary. Bachelor's degree with a minimum of five years' experience and experience supporting C-Level executives. Top position in organization. Oversees all program planning, development, goals, and organization operations. Leads team in accomplishing organization mission. Collaborates with Board of Directors on assessing financials and determining actions to increase funding sources. Bachelor's Degree with a minimum of ten years related experience; five years in management experience; master's level education strongly preferred. Experience in presenting to large audiences and working with the community in creating a larger presence for the organization. NON-PROFIT SALARY SURVEY DATA Salary data effective 01/01/2023 Salarv Market Analvsis Table Worksheet Once done, go to the next page for Part II. assignment), price 8 jobs from the list on the next page against the survey data (in Canvas) to determine the market average salary. Below are the step-by-step instructions: 1. Go to the job summaries folder for this assignment in Canvas and review the job summaries. 2. Open the survey data file. You are to select one of two salary averages most appropriate for job based on level, wither Midwest or lowa. a. Guide: Typically jobs that are support, professional, 1st line supervisory will be matched to city or state date. Higher level jobs such as directors and Vice Presidents tend to be matched to regional level data. Managers can be more localized or regionalized depending on the company and their recruiting scope. For this assignment, determine which data cut is the better match. b. Select the weighted market average for each job you deem most appropriate for job and input on the worksheet Column C. (Sheet is on next page of this worksheet) 3. The next step is to age the market date to January 1,2024 by applying the age factor of 1.041 . Multiply the age factor to the weighted market average. Input your answer in Column D. * Important: The aged salary average now becomes the new market salary average while the Column C average is now obsolete and no longer viable. 4. Once you have the updated salary average, compare the employee's salary to the market salary using one of the two formulas listed below: - When employee salary is higher than the market salary average, use the following equation: (employee salary - market salary average) / market average salary = (convert to percentage) - When employee salary is lower than the market salary average, use the following equation: (employee salary - market salary average)/employee salary = (convert to percentage) Move the decimal two points to the right to convert from a number to percentage. Example: .045=4.5% Take the percentage out one number past the decimal point. Completing your calculations in Excel will convert the number automatically once you set the cells for one decimal point. 5. Once you have calculated the percentage difference between the employee's salary and the market salary, input the percentage in column F. Note: Make sure to remember to include the minus sign before the number if your answer is a negative number. JOB BENCHMARKING \& SALARY ANALYSIS WORKSHEET - PART II For part II of this assignment, you will be creating a market-priced salary range for each job, determine the employee's comparatio along with the employee salary differential to market and assess whether the employee's pay is aligned or mis-aligned externally to market and internally. You are to create salary ranges for the eight organization jobs you analyzed showing the minimum, midpoint, and maximum salary. The structure of the ranges you will be creating are the most commonly used at a 50% spread. For more information on salary range structure see the diagram at the bottom of the page. Follow steps A-C in creating salary ranges. The next page further describes the instructions for this part of the assignment. A. Market Average Salary =$75,000. The $75,000 becomes the midpoint of the salary range. B. The minimum pay for this job is calculated by taking the midpoint and multiplying by 80 . $75,000.80=$60,000 C. The maximum pay for this job is calculated by taking the midpoint and multiplying that number by 1.20 . $75,0001.20=$90,000 D. The above range now becomes the salary range for the job in this example. Further information regarding the structure of the range is shown in the below diagram. Employee Salary Comparison Table to Midpoint and Market SALARY TO MARKET COMPARISON GUIDELINES While comparing employee salaries to the average market salaries, the following guidelines help companies better assess and determine whether salary actions are needed for better alignment to market so they are within acceptable pay parameters. - Salaries within 5% of survey compensation averages are considered at market. - Salaries within 10% of survey compensation averages are in the market zone. - Salaries within 20% of survey compensation averages are within acceptable market parameters; however, salaries within 16%20% of salary market averages may require further review as they near being outside of the acceptable market differential range. - Salaries exceeding 20% (above or below) of survey compensation averages tend to be outside of acceptable market parameters and require further review. B. Then input the employee's salary differential percentage to market based on your findings from part I of this assignment. C. If the comparatio is either less than .80 or greater than 1.20 , the employee's salary will be outside of internal guidelines. If the percentage differential to market is greater than + or 20%, the employee's salary is outside of acceptable pay parameters. If either of these statements is true, then state OUTSIDE in Column D. If both statements are not true, then state WITHIN in column D. D. Any employee salary that is labeled as outside in column D is to be noted as YES in column E. The remaining columns can be left blank or labeled as NO. Go to next page. JOB BENCHMARKING \& SALARY ANALYSIS WORKSHEET - PART II Instructions: Create a salary range for each of the 8 job salaries you analyzed in comparison to the market using the formula described on the previous page. NEXT STEP Analyze employee salaries determining the employee comparatio and the percent of difference of the employee's salary to market. Fill in the table on the next page using these steps. A. Calculate the employee comparatio by taking the employee's salary and dividing it by the salary range midpoint in the above table