Calculate the salary budget for the fiscal year ending June 30, 20X8. The budgeted volume is planned
Question:
Calculate the salary budget for the fiscal year ending June 30, 20X8. The budgeted volume is planned to be 108,000 procedures. Each FTE can do 8,500 units a year. A pay raise will be given to all staff on May 1st of each year at a rate of 10 percent. The July 1, 20X7 rate of pay for new hires is set at $34.00/hour regardless of the hire date. The following are the current staff with FTE values and hourly rates of pay as of October 1, 20X6:
Employee/FTE value/Pay rate
Anderson/0.5/ $34.50
Baker/1.0/$31.25
Carson/1.0/29.35
Davis/1.0/32.65
Evans/ 0.5/24.75
Flinton/0.5/36.20
Gates/1.0/31.00
Hayes/0.5/29.00
The following information may or may not be needed to solve this problem. In examining the payroll and personnel records of your department, you have determined that productive time is 85 percent of total paid time. New staff cannot be hired in less that half time FTE increments (e.g., if you calculate a need for 12.3 additional, new FTEs, 12.5 FTEs must be hired).
Government and Not for Profit Accounting Concepts and Practices
ISBN: 978-1118983270
7th edition
Authors: Michael Granof, Saleha Khumawala, Thad Calabrese, Daniel Smith