Get documents about "Creating Salary Increase Spreadsheet
Description
Creating Salary Increase Spreadsheet document sample
Document Sample
Index
AL
Accountants, 18 term of service, 10, 11
Accounting titles, 10
RI
fund accounting, 20 voting and nonvoting, 10
revenue sources, 20, 21 working with, 126
TE
Acquisitions, 3 Board of directors, 8. See also Board members
Administrative overhead, 9 Board of regents, 8. See also Board members
Age, grouping employees by, 30, 31 Board of supervisors, 8. See also Board
MA
Americans with Disabilities Act, 63 members
Ancillary pay, 82 Board of trustees, 8. See also Board members
Appointments Broadbanding, 85
full-time, part-time, and variable-time, 29 Budget. See also Revenue
D
terms, 29, 30 annual budget cycle, 18–19
Art and cultural groups, 2 defined, xxii
TE
Associations, professional, 2 managers, meeting with, 18
and exempt employees, 30 and performance management, 103, 104
Authority structure. See Governance process
GH
defined, xxii
Base pay, 109 formal budget request process, 19
exempt employees, 46, 47 and revenue, 15–16
RI
nonexempt employees, 55 revenue predictions, 22, 23
Benchmarking, 94 and role of governing body, 11
Benefits
PY
health benefits, 48, 56, 57 Calendar year, 19
pension and retirement, 48, 57 Certifications, 4
perquisites, 48, 49, 57, 58 Chief executive officer (CEO), 8
CO
Board members. See also Governance Civil Rights Act, Title VII, 71
and compensation authority, 39, 49, 58, 59 Classification plan, defined, xxiii
contact with, advantages and Clients, 4
disadvantages of, 8, 9 COLA. See Cost-of-living adjustment
elected and appointed. See Elected and (COLA)
appointed officials Collective bargaining. See also Unions
ex officio, 10 and confidential employees, 44
financial assistance, 9, 10 contracts, 29
meetings, 11 person-based pay, 56
number of, 9 Commission-based salary, 86, 93
quorum, 9–11 COMP spreadsheet. See Current
role of, 11, 12 compensation (COMP) spreadsheet
salaries of and employee salary limits, 10, 22 Compensable factors, 71, 72
191
192 index
Compensation, current point method, xxiii
authority for compensation approval, 39, ranking, 70
49, 58, 59 salary increases, xxiii, xxiv
average years in job, 37 seniority, xxiv
employee groups, 36, 37 whole job, xxii
human resources information system Directors. See also Board members
(HRIS), 35, 36 governing board, 8
job descriptions, 38 Discrimination, 37
number of employees per group, 37 age, 30, 31
pay structure, 37, 38 EEO complaints, 28, 29
performance management system, 38. See Donors
also Performance management budget considerations, 21
salaries as public information, 38 and commission-based salary structures, 86
salary increase date, 39 database, 21
spreadsheet. See Current compensation and exempt employee job performance,
(COMP) spreadsheet 45, 46
union information, 37 revenue sources, 17, 21, 22
Compensation authority, 39, 49, 58, 59
Compensation structure, 46 Education requirements, 4
new compensation. See New EEO. See Equal employment opportunity
compensation structure (EEO)
and role of governing body, 11, 12 Elected and appointed officials, 8, 10. See also
Compensation system, 101 Voters and voting
Consumer Price Index, 23 Employees
Cost-of-living adjustment (COLA), 46, 55 age, 30, 31
Current compensation (COMP) spreadsheet confidential, 44
contents of, 36–39 demographics. See Workforce
purpose of, 36 demographics
sample pages, 40, 41, 150, 151 employment at will, 29
employment contracts, 29
Databases, 21 exempt. See Exempt employees
Definitions, xxii–xxiv full-time, 29
budget, xxii grouping, 27, 28, 36, 37, 44, 54, 64, 92,
budget process, xxii 108
classification plan, xxiii changes to group, 116, 117
employer, xxii revision of and new compensation
factor comparison, xxiii structure, 81
governing body, xxii nonexempt. See Nonexempt employees
incentive (variable) pay, xxiv nonprofit organizations, 8
job analysis, xxii number of, 37, 69
job classification, 70 overtime, 27, 28. See also Exempt
job evaluation, xxii employees
longevity, xxiv part-time, 29
merit salary increases, xxiii performance reviews. See Performance
nonprofit employer, xxiii management
nonprofit organizations, 2 promotions, importance of, 107
pay grade, xxiii unions. See Unions
performance management, xxiii variable-time appointments, 29
person-based pay, xxiv years of service, 30
index 193
Employer, defined, xxii Focus of operations, 3, 17
Equal employment opportunity (EEO) For-profit organizations
average age of workforce, 30, 31 revenue compared to nonprofit or public
average salaries, 31 organization, 123, 124
complaints, basis for, 28, 29 revenue sources, 16
and grouping employees, 44 Full-time equivalent (FTE) workers, 53
reporting categories, 28 Funding, 17. See also Revenue
and years of service, 30 government, 22
Equal Pay Act, 71 stipulations as to use of funds, 103
Ex officio board members, 10 Fundraising
Excel, use of, xxi revenue sources, 21
Executive directors, 8 and role of governing body, 11
Exempt employee (EXMPT) spreadsheet
contents of, 44–49 Goods and services, providing, 17
revenue impact, 65 GOV spreadsheet. See Governance (GOV)
sample pages, 50, 51, 152, 153 spreadsheet
Exempt employees, 27 Governance
base pay, 46, 47 board finances, 9, 10
compensation authority, 49 board meetings, number of, 11
and compensation manager, 43, 44 board members. See Board members
employee group information, 44 elected or appointed officials, 8, 10
full-time equivalent, 53 governing board, 8, 9
health benefits, 48 name of governing board, 8
and job description, 65 organization chart, 7
jobs, 45 quorum, 9–11
and new compensation spreadsheet, 92 role of governing body, 11, 12
pension and retirement benefits, 48 spreadsheet. See Governance (GOV)
perquisites, 48, 49 spreadsheet
person-based pay, 47 Governance (GOV) spreadsheet
and professional associations, 30 elements of, 9–12
revenue impact of each job, 45, 46 sample pages, 13, 146
spreadsheet. See Exempt employee Governing body
(EXMPT) spreadsheet defined, xxii
variable pay, 47 Government entities, 2
EXMPT spreadsheet. See Exempt employee operational focus, 3
(EXMPT) spreadsheet reporting, 20
revenue sources and voter influence, 23
Factor comparison Government funding, 22
defined, xxiii Grants
method of job evaluation, 71, 73, 74 government agencies, 17, 18
Fair Labor Standards Act (FLSA), 27 and salary increases, 102
exempt and nonexempt employees. See Growth and job analysis, 69, 70
Exempt employees; Nonexempt GuideStar, xvii, 20
employees
Fay, Charles, 85 Health benefits, 48
Fiscal year, 16, 19 nonexempt employees, 56, 57
Flat rates, 82, 83, 93 Healthcare organizations, 2
adjusting, 91, 92 Historic preservation societies, 2
for jobs in series, 83 History of organization, 4
194 index
Human Resource Information System Job evaluation, 68–70, 118
(HRIS), 101 defined, xxii
data elements nonquantitative methods, 70, 71
applicant tracking, 184–187 job classification, 70, 71
person-related, 166–173 ranking, 70
position-related, 174–179 other methods, 74, 75
recruitment, 182, 183 quantitative methods, 71–74
training and development, 180, 181 Job listings
developing, 36, 165 and compensation structure, 92, 93
elements of, 35 exempt employees, 44, 45
and payroll, 36 and job analysis, 64
Human resources (HR) maintenance, 117
and organization chart, 7 nonexempt employees, 54
policies and practices, 1 and performance management, 108
Hutton, Stan, 2 Job stability, 4
Jobs, status of, 117
Incentive (variable) pay, 87, 88, 94, 109 JOBS spreadsheet. See Job analysis ( JOBS)
defined, xxiv spreadsheet
exempt employees, 47
nonexempt employees, 56 Labor market
Internal Revenue Code § 501(c)(3) evaluating, 115
organizations, 2 external, effect of, 18, 88, 89
Internal Revenue Service (IRS), 2 Labor unions. See Unions
and mission statement, 3 Lawler, Edward E., III, 103, 106
Location of organization, 4
Job analysis Longevity, 55
defined, xxii defined, xxiv
employee groups, 64 and salary ranges, 84
importance of, 63, 64
incumbents, number of, 64 MAINT spreadsheet. See Maintenance
job descriptions. See Job descriptions (MAINT) spreadsheet
job evaluation. See Job evaluation Maintenance (MAINT) spreadsheet
job listing, 64 contents of, 116–119
job specifications, 67, 68 purpose of, 116
revenue impact, 65 sample pages, 120–122, 162, 163
spreadsheet. See Job analysis ( JOBS) Maintenance of compensation structure
spreadsheet changes to pay and changes to
Job analysis ( JOBS) spreadsheet compensation structure, 113, 114
contents of, 64–75 compensation arrangement, 118
purpose of, 63, 64 employee groups, 116, 117
sample pages, 76, 77, 156, 157 impact of changes, 118
Job classification, defined, 70 job description, 117
Job descriptions, 117 job evaluation, 118
and changes in job, 66 jobs, 117
creating, 67 management issues, 118, 119
elements of, 65, 66 need for, obtaining acceptance of, 114, 115
employee perspective, 63, 67, 68 revision, reasons for, 114
existence of, 38 spreadsheet. See Maintenance (MAINT)
and job analysis, 66, 67 spreadsheet
index 195
status of jobs, 117 steps in salary range, 93
turnover, 118 variable pay, 87, 88, 94
Management, 8 NewCOMP spreadsheet. See New
and changes to compensation structure, compensation (NewCOMP)
118, 119 spreadsheet
and exempt employees, 43, 44 NONEX spreadsheet. See Nonexempt
senior management jobs, analyzing, 64 employee (NONEX) spreadsheet
supervisors, 105, 106 Nonexempt employee (NONEX)
working with, 126 spreadsheet
Martocchio, Joseph J., 91 contents of, 54–59
Mergers, 3 revenue impact, 65
Merit salary increases, 46, 47, 55 sample pages, 60, 61, 154, 155
defined, xxiii use of, 53
and salary ranges, 84 Nonexempt employees, 28
Mission statement base pay, 55
binding nature of, 3 compensation authority, 58, 59
as part of each spreadsheet, 3, 6 full-time equivalent, 53
Mohrman, Allan M., Jr., 103, 106 grouping employees, 54
MS Office Excel, use of, xxi health benefits, 56, 57
and job description, 65
Negotiated salary rates, 86, 87 job listings, 54
New compensation (NewCOMP) spreadsheet and new compensation spreadsheet, 92
contents of, 89–95 number of, 53
purpose of, 81 pension and retirement benefits, 57
sample pages, 96–98, 158, 159 perquisites, 57, 58
New compensation structure person-based pay, 56
ancillary pay, 82 revenue impact, 54, 55
benchmark jobs, 94 spreadsheet. See Nonexempt employee
commission-based, 86, 93 (NONEX) spreadsheet
employee group, 92 variable pay, 56
exempt and nonexempt employees, 92 Nonprofit and public organizations
and external labor market, 88, 89 characteristics of, 2
flat rates, 82, 93 employees. See Employees
adjusting, 91, 92 for-profit revenue compared, 16, 17, 123,
for jobs in series, 83 124
job listing, 92, 93 governing board. See Governance
negotiation, 86, 87 operational focus, 3
person-based pay, 94 and reasons for new compensation
primary influence for salary rate, 94, 95 structure, 79–81
range code, 92 revenue sources. See Revenue
reasons for, 79–81 Nonprofit employer, defined, xxiii
salary range, 93 Nonquantitative job evaluation
salary ranges, 83, 84 job classification, 70, 71
broadband, 85 ranking, 70
constructing, 89–91
with steps, 84, 85 Operational year, 19
spread percentage, 93 Operations
spreadsheet. See New compensation description of, 4, 5
(NewCOMP) spreadsheet focus of, 3
196 index
Organization system for, 38, 101
culture, 104, 105 techniques for performance review, 109
history of, 4 variable pay, 109
location, 4 variables, 101
mission statement, 3. See also Mission Performance management (PerfMgt)
statement spreadsheet
operational focus, 3, 17 contents of, 108, 109
operations, 4, 5 purpose of, 101
size of and job evaluation, 68, 69 sample pages, 110–112, 160, 161
spreadsheet. See Organization (ORG) Permanently restricted funds, 20
spreadsheet Perquisites, 48, 49
type of, 1, 2 nonexempt employees, 57, 58
Organization chart, 7 Person-based pay, 94
Organization (ORG) spreadsheet defined, xxiv
elements of, 1–5 exempt employees, 47
sample pages, 6, 145 nonexempt employees, 56
Overhead, 9 Phillips, Frances, 2
Overtime, 82. See also Nonexempt employees Plachy, Roger J., 107
Plachy, Sandra J., 107
Pay grade, defined, xxiii Point method
Pay structure, 37, 38 defined, xxiii
Pension and retirement benefits, 48 point-factor method of job evaluation,
nonexempt employees, 57 71–73
PerfMgt spreadsheet. See Performance Primary influence for salary rate, 94, 95
management (PerfMgt) spreadsheet Priorities, organizational, xix
Performance appraisal, 99 Private sector, 2
Performance evaluation, 99 Privately-held companies, 2
Performance management Profit-sharing, 18
base salary increase, 109 Promotions, 107, 125
budget impact, 103, 104 Public agencies, 8
compensation arrangement, 109 funding, 22
defined, xxiii and reasons for new compensation
employee groups, 108 structure, 79, 90
employee’s perspective, 101 Public companies, 2
internal and external authorities, 101–103 Public events, 4
job listing, 108 Public relations and public access to salary
measurement basis, 106, 107, 109 information, 38
and organizational culture, 104, 105 Public sector, 2
pay for performance in nonprofit and Public trust and reasonable compensation, 18
public organizations, 99, 100, 125 Public utilities, 2
performance appraisal, 99
performance evaluation, 99 Quantitative job evaluation
performance review schedule, 108 factor-comparison method, 71, 73, 74
promotions, importance of, 107 point-factor method, 71–73
reasons for, 104 Quorum, 11
revenue impact, 108, 124, 125 and ex officio members, 10
salary increase schedule, 108 importance of, 9
spreadsheet. See Performance
management (PerfMgt) spreadsheet Ranking, defined, 70
supervisory attitudes, 105, 106 Regents, 8
index 197
Religious institutions, 2 base pay, 46
and modification of governance base pay increases, 46, 47
spreadsheet, 7 person-based pay, 47
Reporting variable pay, 47
research grants, 17, 18 and external labor market. See Labor
revenue sources, 20 market
Resnick-West, Susan M., 103, 106 increases. See Salary increases
Retirement plans. See Pension and offers, authority of hiring managers, 84
retirement benefits public information, 38
REV spreadsheet. See Revenue (REV) ranges, 93
spreadsheet broadband, 85
Revenue. See also Budget; Funding code, 92
accounting, 20, 21 constructing, 83, 84, 89–91
budget and negotiation, 86, 87
annual budget cycle, 18, 19 new salary range, 93
formal budget request process, 19 spread percentage, 93
and revenue, 15, 16 with steps, 84, 85, 93
custodial nature of, 124 Salary increases
donors, 21, 22 date for, 39
exempt employees, impact of on revenue, defined, xxiii, xxiv
45, 46 limits on, 10, 22
for-profit and nonprofit compared, 16, 17, nonprofit organizations, 102, 103
123, 124 and performance management, 104. See
funding, 17 also Performance management
fundraising, 21 schedule for, 108
government funding, 22 Salary surveys, 115
information on, obtaining, 18 Schedules
jobs, impact of on revenue, 65 performance review, 108
nonexempt workers, impact on revenue, salary increase, 108
54, 55 Seniority, 55
nonprofit and public organizations, 15–18, defined, xxiv
123, 124 and salary ranges, 84
and organizational success, 124, 125 Services provided and description of
predictions, 22–23 operations, 5
reporting, 20 SHRM. See Society for Human Resource
and salary ranges, 83 Management (SHRM)
spreadsheet. See Revenue (REV) Skill mastery
spreadsheet degrees of, 72
types of, 124 skilled trades and flat rates, 83
and voter influence, 23 Society for Human Resource Management
Revenue (REV) spreadsheet (SHRM), 1
contents of, 18–23 and job classification systems, 71
purpose of, 18 job descriptions, elements of, 65, 66
sample pages, 24, 25, 147 Learning System, 71
Risks and description of operations, 4 Spreadsheets
COMP. See Current compensation
Salaries (COMP) spreadsheet
approval authority, 39, 49, 58, 59, 84 EXMPT. See Exempt employee
average salary of employees, 31 (EXMPT) spreadsheet
exempt employees GOV. See Governance (GOV) spreadsheet
198 index
Spreadsheets (cont.) Turnover, 118
JOBS. See Job analysis ( JOBS) spreadsheet Types of organizations, 1, 2
MAINT. See Maintenance (MAINT) misconceptions, 2
spreadsheet
NewCOMP. See New compensation Unions, 30, 37
(NewCOMP) spreadsheet and changes to employee groups, 116
NONEX. See Nonexempt employee and flat rate salaries, 82
(NONEX) spreadsheet and job analysis, 69, 70, 72
ORG. See Organization (ORG) United States Postal Service, 8, 53
spreadsheet Universities, 2
PerfMgt. See Performance management research grants, 17, 18
(PerfMgt) spreadsheet Unrestricted funds, 20
REV. See Revenue (REV) spreadsheet
spreadsheet 1. See Organization (ORG) Variable pay. See Incentive (variable) pay
spreadsheet Variable-time appointments, 29
spreadsheet 2. See Governance (GOV) Voters and voting
spreadsheet effect of on revenue, 23
spreadsheet 3. See Revenue (REV) and external labor market, 88
spreadsheet and public agencies, 101, 102
spreadsheet 4. See Workforce and reasons for new compensation
(WRKFRC) spreadsheet structure, 79, 80
spreadsheet 5. See Current compensation recall of officials, 10
(COMP) spreadsheet salary information, access to, 38
spreadsheet 6. See Exempt employee
(EXMPT) spreadsheet Whole job
spreadsheet 7. See Nonexempt employee defined, xxii
(NONEX) spreadsheet Workforce demographics. See also
spreadsheet 8. See Job analysis ( JOBS) Employees
spreadsheet appointment terms, 29, 30
spreadsheet 9. See New compensation average age, 30, 31
(NewCOMP) spreadsheet average salary, 31
spreadsheet 10. See Performance average years of service, 30
management (PerfMgt) spreadsheet employee groups, 27, 28
spreadsheet 11. See Maintenance full-time employees, 29
(MAINT) spreadsheet male/female subcategories, 28, 29
and structure of book, xxi part-time employees, 29
use of MS Office Excel, xxi spreadsheet. See Workforce (WRKFRC)
WRKFRC. See Workforce (WRKFRC) spreadsheet
spreadsheet unions, 30
Supervisors and performance management, variable-time appointments, 29
105, 106 Workforce (WRKFRC) spreadsheet
Surveys contents of, 27–31
compensation survey, xvi, xvii purpose of, 27
questionnaire, 129–143 sample pages, 32, 33, 148, 149
WRKFRC spreadsheet. See Workforce
Tax considerations, 2, 3, 17 (WRKFRC) spreadsheet
Temporarily restricted funds, 20
Tenure and tenure track appointments, 29 Years in job, 37
Trustees, 8 Years of service, 30, 37
Related docs
