1. Calculate amounts for EACH salary with the merit raise of 5%.

2. Calculate personnel budget including the above, budgeted OT, the new employee cost, and the fringe benefits.

A new approved analyst/coder/abstractor position goes into effect at the beginning of the new fiscal year with a salary of $48,500.00.

Fringe benefits of 30% of total salaries.

OT limits - $4000.00 for the year.

THERE SHOULD BE TWO SPREADSHEETS... ONE FOR PERSONEL AND THE OTHER FOR OPERATIONAL EXPENSES.

TABLE 6-31 Personnel Salary information Personnel Salary Information 1 1 1 Number of Employees Current Salaries Salaries for the Classification $79,450.00 Director $67,478.00 Assistant director 1 $55.971.00 Coding supervisor $31.502.00 Receptionist/clerk $56,800.00 Transcription supervisor 4 $46,000.00 Transcriptionists 3 $47,500.00 Coders 1 $50,000.00 Chart completion supervisor 2 $44.052.00 HIM technicians 1 "Analyst/coder/abstractor New position Salaries and fringe benefits Budgeted overtime Subtotal personnel Dette new approved position Operating Expenses Operations expenses are shown in Table 6-32 and should be allocated throughout the FY What would be the operations budget for the new FY, including line items given? LEF-22 Operations Expenses for New FY Operations Expenses for New FY Expense Budget Telephone Supplies Scanner $10,000.00 Equipment Copy Machine Education Total d $1,000.00 $10,500.00 cost $25,000.00 $8,000.00 $2,500.00 sa ooo Ekpennie Spreadsheet