Assignment Objectives: Create a budget and various cost models Construct managerial reports Purpose: To learn the parts of a department budget and perform calculations associated with a budget Assignment Description: Develop a budget for the HIM Department for the next fiscal year (FY) at Herzing Hospital using the attachment given below. The FY begins July 1st. Utilize spreadsheet software like Excel to develop the budget parts and then develop the department budget for the next fiscal year. There are two parts to the budget: 1.Personnel 2.Operational Calculate the budget for each month and a total for the year. Line items to be included are identified in each of the two parts of the budget. Any limitations or instructions from administration are also provided. Parameters: Use Excel for this assignment. For each month you will have a total budget amount from adding personnel and operational costs, taking in consideration the limitations and instructions. You will also have a total budget for the entire year by adding all of the monthly budget amounts together. . .

HIM Department Budget Herzing Hospital Position Director Assistant Director Receptionist Clerk Coder Coder Scanning Clerk Transcriptionist Transcriptionist PartTime Clerk Personnel Budget Current Salary $45,000.00 $36,000.00 $18,000.00 $25,000.00 $22,500.00 $19,000.00 $25,000.00 $27,000.00 $6,500.00 Next FY Salary Line Items: (show monthly totals for each line item below) Salaries Benefits Overtime Instructions: Calculate benefits as 25% of monthly salary. A 5% raise will go into effect in October. Limitations: Overtime cannot exceed $4000.00 for the year. No new employees. *Use a spreadsheet like Excel to reflect the monthly personnel budget. Operational Budget Operation Next Fiscal Year Telephone Supplies Folders Equipment Copy Machine Education $2,000.00 $7,500.00 $15,000.00 $12,000.00 $5,000.00 $1,000.00 Limitations: Supply expense will need to be decreased by 20% for next fiscal year. *Operational budget amounts will need to be budgeted monthly and then added to personnel budget for a yearly budget total