199
EXERCISE 22
DEVELOPING A MERIT INCREASE BUDGET
Utilizing the software provided, students should be able to quickly calculate the $1,366,896 change in
base payroll as well as the $824,853 first fiscal year cost of the program described in this exercise.
Overall Dollars
Group Number of Employees Total
Salaries Spending
Percent Number of Months
Spending
Executives
14
$2,400,000
4.9%
448,020
Nonexempt
250
7,328,000
4.2%
Actual Cost
Group Number of Employees Total
Salaries Spending
Percent Number of Months
Spending
Executives
14
$2,400,000
4.9%
$153,888
Hourly
492
11,750,000
4.2%
