Develop the HIM Department operations budget on this spreadsheet for the next fiscal year (FY). Allocate the funding throughout the FY on a monthly basis. The FY at Seattle Grace Hospital begins July 1. We are currently in the current FY.

IMPORTANT POINTS TO CONSIDER

Fiscal Year 2015 (Current FY) = July 1 2014 - June 30 2015 THIS TEMPLATE IS PROVIDED FOR YOUR CONVIENENCE. YOU DO NOT HAVE TO USE IT BUT

Fiscal Year 2016 (Next FY) = July 1 2014 - June 30 2015 IT IS HIGHLY SUGGESTED YOU DO SO FOR FORMULA ASSISTANCE. REMEMBER THAT =SUM()

Fringe Benefits = 30% of monthly salaries IS HOW YOU BEGIN A FORMULA IN A CELL. CHECK OUT THE LINK BELOW FOR HELP ON FORMULAS.

Overtime limits not to exceed $4,000 for the year http://office.microsoft.com/en-001/excel-help/overview-of-formulas-HP010342750.aspx

Overtime only applies to non-exempt staff

Merit raise = 5% beginning December 1, 2014

A new approved Analyst/Coder/Abstractor position will go into effect in the new FY with a salary of $48,500 Color Coding Key

New position is not eligible for merit pay Example for Reference

Student Solves

SECTION 1: PERSONNEL SALARIES AND WAGES

Director Asst Dir Coding SUP Receptionist/Clerk Transcription SUP Transcriptionist Coder Chart Compl SUP HIM Tech New Position Subtotal

FTE # 1 1 1 1 1 4 3 1 2 1 n/a

Previous Annual Salary $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 $48,500.00 n/a

Salary with Merit Incr. $83,422.50 $70,851.90 $58,769.55 $33,077.10 $59,640.00 $48,300.00 $49,875.00 $52,500.00 $46,254.60 $48,500.00 $551,190.65

Monthly w FTEs (July-15) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (Aug-15) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (Sept-15) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (Oct-15) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (Nov-15) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (Dec-15) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (Jan-16) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (Feb-16) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (Mar-16) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (Apr-16) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (May-16) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

Monthly w FTEs (June-16) $6,951.88 $5,904.33 $4,897.46 $2,756.43 $4,970.00 $16,100.00 $12,468.75 $4,375.00 $7,709.10 $4,041.67 $70,174.60

FY 15-16 SALARY $83,422.50 $70,851.90 $58,769.55 $33,077.10 $59,640.00 $193,200.00 $149,625.00 $52,500.00 $92,509.20 $48,500.00 $842,095.25

Fringe Benefits $25,026.75 $92,107.47 $76,400.42 $43,000.23 $77,532.00 $251,160.00 $194,512.50 $68,250.00 $27,752.76 $63,050.00 $918,792.13

SUBTOTAL $108,449.25 $162,959.37 $135,169.97 $76,077.33 $137,172.00 $444,360.00 $344,137.50 $120,750.00 $120,261.96 $111,550.00 $1,760,887.38

TOTAL SAL&BEN $1,760,887.38

OVERTIME $4,000.00

TOTAL PERSONNEL $1,764,887.38

SECTION 2: OPERATING EXPENSES

Operations expenses are shown in the table below:

Telephone Supplies Folders Equipment Copy Machine Education Subtotal

Operating Expenses $1,000.00 $10,500.00 $10,000.00 $25,000.00 $8,000.00 $2,500.00 $57,000.00

Jul-15 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Aug-15 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Sep-15 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Oct-15 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Nov-15 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Dec-15 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Jan-16 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Feb-16 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Mar-16 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Apr-16 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

May-16 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

Jun-16 $83.33 $875.00 $833.33 $2,083.33 $666.67 $208.33 $4,750.00

SUBTOTAL $1,000.00 $10,500.00 $10,000.00 $25,000.00 $8,000.00 $2,500.00 $57,000.00

TOTAL $57,000.00

SECTION 3: TOTAL EXPENSES

What would be the operations budget for the new FY, including line items given? The answer goes in box B78

Jul-15 $721,297.85

Aug-15 $721,297.85

Sep-15 $721,297.85

Oct-15 $721,297.85

Nov-15 $721,297.85

Dec-15 $721,297.85

Jan-16 $721,297.85

Feb-16 $721,297.85

Mar-16 $721,297.85

Apr-16 $721,297.85

May-16 $721,297.85

Jun-16 $721,297.85

SUBTOTAL $8,655,574.14

OVERTIME $4,000.00

Total 15-16 FY $8,659,574.14

SECTION 4: Budget Variences

Explore the idea of budget variences and answer the following questions:

(1) What is a budget varience?

(2) In your opinion, what can you do mitigate variences?