Develop the HIM department operations budget on a spreadsheet for the next FY. Allocate the funding through- out the FY on a monthly basis. The FY at General Hospital begins July 1. First, create a spreadsheet folder with the salaries and wages information, and then create a spreadsheet folder with the operating expenses. Personnel Salaries and Wages-Calculate amounts for the following: 1. Salaries with fringe benefits 2. Allowed overtime Second, calculate total personnel budget. Use the information in Table 6-31, also available on the student companion website, to calculate the payroll costs for the new FY. New salaries include the following: 1. A new approved analyst/coder/abstractor position that will go into effect at the beginning of the new FY with a salary of $48,500.00. 2. Fringe benefits of 30% of monthly salaries. 3. A merit raise of 5% that will go into effect in December. 4. Overtime limits not to exceed $4,000.00 for the year. TABLE 6-31 Personnel Salary Information Classification Director Assistant director Coding supervisor Receptionist/clerk Transcription supervisor Transcriptionists Coders Chart completion supervisor HIM technicians *Analyst/coder/abstractor Salaries and fringe benefits Budgeted overtime Subtotal personnel *Denotes new approved position Personnel Salary Information Number of Employees Current Salaries Salaries for New FY 1 1 1 1 1 4 3 1 2 1 Operating Expenses Operations expenses are shown in Table 6-32 and should be allocated throughout the FY. $79,450.00 $67,478.00 $55,971.00 $31,502.00 $56,800.00 $46,000.00 $47,500.00 $50,000.00 $44,052.00 New position What would be the operations budget for the new FY, including line items given? TABLE 6-32 Operations Expenses for New FY Expense Telephone Supplies Scanner Equipment Copy Machine Education Total Operations Expenses for New FY Budget $1,000.00 $10,500.00 $10,000.00 $25,000.00 $8,000.00 $2,500.00