Case Study: Developing the Health Information Management Operations Budget

Develop the HIM department operations budget on a spreadsheet for the next FY$.$ Allocate the funding throughout the fiscal year $($FY$)$ monthly. The FY at General Hospital begins July $1.$

$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:

a$)$ Salaries with fringe benefits

b$)$ Allowed overtime

$2.$ Second, calculate total personnel budget.

Use the information from the spreadsheet provided, to calculate the payroll costs for the new FY$.$ New salaries include the following:

a$)$ 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\mathrm{.}00.$

b$)$ Fringe benefits of $30\%$ of monthly salaries.

c$)$ A merit raise of $5\%$ that will go into effect in December.

d$)$ Overtime limits shall not exceed $$4,000\mathrm{.}00$ per person for the year.

Operating Expenses Operations expenses below should be allocated throughout the FY$.$

Table below shows Operations Expenses for New FY Operations Expenses for New FY

Expense$$ Budget

Telephone$$$$1,000\mathrm{.}00$

Supplies $$$$10,500\mathrm{.}00$

Scanner $$$$10,000\mathrm{.}00$

Equipment $$$$25,000\mathrm{.}00$

Copy Machine $$$$8,000\mathrm{.}00$

Education $$$$2,500\mathrm{.}00$ Total

$3.$ Create a voice$-$over PowerPoint to present to your Finance$/$Budget Manager making a case for your operations budget for the new Fiscal Year, including line items given. Identify the tools you would use to track your budget for the new year.

CASE $6-26$

$-$ Developing the Health Information Management Operations Budget

omeliap the HiM department oparatiens budget an a spreadshere for the neat FK$.$ Allocate the finding throughout me Fr on a monthly bash. The FY at Deneral Hospital begita Jady $1.$

Fint, create a spreadsheet folder with the salaries enid wapes intormation, and then croate a sprestaheet folder wilf the operating erpenses:

Avsomnel Satiries and Wages$-$Calloulate amounts for the foliowing

f$.$ Salaries with fringe benetits

$2.$ Allowed overtime

Sochnd, caiculate total personnal budget:

Use the inlormation in Table $\backslash (6-31\backslash ),$ also ovaltable on the stubent companion website, to calculate the payroll costs for the new FY$,$ New sataries include the following:

$1.$ A new epproved analyst$/$coder$/$abstractor position that will go inta effect at the beginning of the new Fy with a salary of $\backslash (\backslash$$ $48,500\mathrm{.}00\backslash ).$

$2.$ Fringe benefits of $\backslash (30\backslash \%\backslash )$ of monthly salaries.

$3.$ A merit ralse of $\backslash (5\backslash \%\backslash )$ that will go into effect in December.

$4.$ Dvertime limits not to excoed $\backslash (\backslash$$ $4,000,00\backslash )$ for the year $352$

Sectimi $-$ Leatrosup

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{4\}\{|$r$|\}\{$Pensonnet Salary information$\}\backslash \backslash$

$\backslash$hline Classification & Number of Employees & Current Salaries & Saiariestor New FY $\backslash \backslash$

$\backslash$hline Director & $1$ & $579,450\mathrm{.}00$ & $\backslash \backslash$

$\backslash$hline Assistant direction & $1$ & $567,47800$ & $\backslash \backslash$

$\backslash$hline Coding supervisor & $1$ & $555,971,00$ & $\backslash \backslash$

$\backslash$hline Receptionigt$/$clerk & $1$ & $531,502,00$ & $\backslash \backslash$

$\backslash$hline Transcriptions supervisor & $1$ & $\backslash$$$56,5000\mathrm{.}00$ & $\backslash \backslash$

$\backslash$hline Traniscriptionists & $4$ & $\backslash$$$46,000,00$ & $\backslash \backslash$

$\backslash$hline Codera & $3$ & $\backslash$$$47,500\mathrm{.}00$ & $\backslash \backslash$

$\backslash$hline Chart completion supervisor & $1$ & $550,000,00$ & $\backslash \backslash$

$\backslash$hline HiM technicians & $2$ & $564,052,00$ & $\backslash \backslash$

$\backslash$hline "Analyst$/$coder$/$abstractor & $1$ & New position & $\backslash \backslash$

$\backslash$hline Salaries and fringe benefits & & & $\backslash \backslash$

$\backslash$hline Budgeted overtime & & & $\backslash \backslash$

$\backslash$hline Subtotal personnel & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

thenatex new aqponver pesoin

Operating Eypenses

Operations expenses are shown in Table $\backslash (6-12\backslash )$ and should to allocated throughout the FY$,$

What would be the operations budget for the few FI$,$ including line bemp gien?

WEE $6-$w Opernises Eigution tort Tin FT

$\backslash$begin$\{$tabular$\}\{|$l$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{2\}\{|$c$|\}\{$ Operations Expenses for New FY $\}\backslash \backslash$

$\backslash$hline Expense & Budget $\backslash \backslash$

$\backslash$hline Telephone & $\backslash (\backslash$$ $1,000,00\backslash )\backslash \backslash$

$\backslash$hline Supplies. & $\backslash (\backslash$$ $10,500\mathrm{.}00\backslash )\backslash \backslash$

$\backslash$hline Scanner & $\backslash (\backslash$$ $10,000\mathrm{.}00\backslash )\backslash \backslash$

$\backslash$hline Equipment & $\backslash (\backslash$$ $25,000,00\backslash )\backslash \backslash$

$\backslash$hline Copy Machine & $\backslash (\backslash$$ $8,000\mathrm{.}00\backslash )\backslash \backslash$

$\backslash$hline Education & $\backslash (\backslash$$ $2,500\mathrm{.}00\backslash )\backslash \backslash$

$\backslash$hline Total & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$