$.,,$m$\backslash ]$m As the Director of the HIM Department, you have been assigned the task of completing the proposed budget for the next fiscal year for the HIM Department at Macomb Community Hospital. The fiscal year is from January $-$ December. As a tool, you have the budget from the previous year, the salary worksheet and the monthly expenses report. You will be using the historical data provided as well as considering your projections for future costs.

Currently Credentialed Employees in the HIM Department:

Yourself, Director of HIM and credentialed as a RHIA

$8$ RHIT$$s who are employed as coders $($of those $8,$ two also hold CCS credentials$)$

Data Integrity Analyst who is credentialed as a RHIA

Coding Manager who is credentialed as a RHIT, CCS

Budget assumptions for $2024$ are:

Project a maximum $4\%$ hourly increase for all employees $($except yourself$)$

Project an increase in supplies of $9\%.$

Project a $5\%$ increase in all other areas, except those discussed below. $($postage is included here$)$

Items for Expense Budget:

You must also evaluate travel expenses, membership and dues. It is the policy of your facility to pay, your AHIMA dues, and to reimburse any coder who successfully passes the CCS examination. You know that two of your coders plan to take the CCS exam next year. $($Check AHIMA$$s website for these costs$)$

You need to budget to attend the AHIMA$24$ Global convention. Be sure to estimate airfare, hotels, food, and registration fees for a $3$ day convention. Attach appropriate documents that detail your estimated expenses. $($Yes$,$ check actual airfare from Macomb Community Hospital to the site of the planned $2024$ convention and include that. You are also to research hotel prices and place that figure into your budget.$)$ Allow for $$42\mathrm{.}00$ a day for food. $($Remember$,$ you usually fly in the night before a conference is to start in order to be in attendance early in the morning.$)$

You typically host lunch for your staff during HIP week in March. You have $25$ employees in your department plus your new FTE$$s you plan to hire. You usually plan to spend $$12\mathrm{.}00$ per person. You can choose a small luncheon, small gifts, etc.... but the total cost cannot exceed what your budget is$.$ Make sure you document what you plan to do$.$

You also need to budget for education. You will need to show the number of CEU$$s per educational session. You know that you must provide education for your coders to include, the FY coding updates $($both ICD$-10$ and CPT$).$

Your coders need a minimum of $10$ CE$$s each year to maintain their RHIT certification and the hospital provides that education, so plan on $10$ CEU$$s for the budget. $($Check AHIMA$$s web site, go to the bookstore, and check the price of audio seminars, you can check local offerings, but typically, the coders do not get to travel a great distance for education$)$

$**$In order to have accurate budgeting, place the expenses in the month in which they will occur.

Items for Capital Budget:

You have also been advised to make any capital requests at this time. You need a new scanner$/$printer for the ROI Coordinator to take care of the increasing requests for records for disability claims. $($Check the internet, choose a model, see if you can find multiple sites with the same product and compare pricing, attach info to your budget.$)$ Write a justification as to how you will use the scanner in the daily work. You will also need to calculate if more FTEs are needed since the increase in disability claim requests has risen by $3,750$ per year. The ROI Coordinator currently processes $4$ claims per hour.

Based upon the increase, figure out how many FTEs will be needed to assist the ROI Coordinator in the next year to meet the increased demand. $($Salary for these FTE$$s will be $$17$ per hour. This information will be placed in the Salary Budget$).$

$($There are some help documents on Canvas on figuring out FTE$$s$)$

Items for Salary Budget:

$$ Based on $2080$ hours working a year, what is your department$$s average hourly rate?

$$ What is the total average monthly salary expense for your department each month?

Budget Pparation

$1.$ Create an Excel spreadsheet for your $2024$ expense budget. $($See examples of the $2023$ budget$)$

a$.$ The expense budget must be broken down by month and also on an annual basis.

b$.$ Justify all of your calculations and recommendations for each expense category.

c$.$ Supporting documentation must be typed in Word.

$2.$ A request for Event Expense also must be filled out for the Convention. The total expense is entered into your $2024$ expense budget for the month of travel. All expenses must have documentation to support your request.

$3.$ Create an Excel spreadsheet for your $2024$ salary budget.

a$.$ The salary budget must be on an annual basis and also broken down by month.

$4.$ Using Word, create a document that identifies the capital equipment you would like to purchase. Included in your document must be the cost o