Developing the Health Information Management Department Budget Develop a budget for the HIM department for the next FY at Sea Crest Healthcare Center. The FY begins on July 1. Utilize spreadsheet software to develop the budget parts and then develop the department budget for the next FY. There are three parts to the budget as follows: . Personnel (see Table 6-33) Operational (see Table 6-34) Capital equipment (see Table 6-35, Figure 6-3, and Figure 6-4) 1. Calculate the budget for each month and a total for the year. Line items to be included are identified in each of the three parts of the budget. Any limitations/instructions from administration are also provided. Personnel Budget The FY personnel budget is indicated in Table 6-36. Remember that the salary raises will not go into effect until October of the FY. Instructions: Limitations: Calculate fringe benefits as 25% of monthly salary. A 5% raise will go into effect in October. Overtime cannot exceed $4,000.00 for the year. No new employees. Use a spreadsheet to calculate and reflect the monthly personnel budget. O TABLE 6-33 Information for Salary Budget Position 20XX-20XX Salary Director Assistant director Receptionist/clerk Analyst/coder/abstractor Analyst/coder/abstractor HIM clerk Transcriptionist Transcriptionist Part-time HIM clerk Personnel Budget Current Salary $82,000.00 $74,000.00 $31,000.00 $46,000.00 $48,500.00 $30,000.00 $45,000.00 $47,000.00 $16,500.00 Line items total salaries Total salaries and fringe benefits Overtime Developing the Health Information Management Department Budget Develop a budget for the HIM department for the next FY at Sea Crest Healthcare Center. The FY begins on July 1. Utilize spreadsheet software to develop the budget parts and then develop the department budget for the next FY. There are three parts to the budget as follows: . Personnel (see Table 6-33) Operational (see Table 6-34) Capital equipment (see Table 6-35, Figure 6-3, and Figure 6-4) 1. Calculate the budget for each month and a total for the year. Line items to be included are identified in each of the three parts of the budget. Any limitations/instructions from administration are also provided. Personnel Budget The FY personnel budget is indicated in Table 6-36. Remember that the salary raises will not go into effect until October of the FY. Instructions: Limitations: Calculate fringe benefits as 25% of monthly salary. A 5% raise will go into effect in October. Overtime cannot exceed $4,000.00 for the year. No new employees. Use a spreadsheet to calculate and reflect the monthly personnel budget. O TABLE 6-33 Information for Salary Budget Position 20XX-20XX Salary Director Assistant director Receptionist/clerk Analyst/coder/abstractor Analyst/coder/abstractor HIM clerk Transcriptionist Transcriptionist Part-time HIM clerk Personnel Budget Current Salary $82,000.00 $74,000.00 $31,000.00 $46,000.00 $48,500.00 $30,000.00 $45,000.00 $47,000.00 $16,500.00 Line items total salaries Total salaries and fringe benefits Overtime