Many times when a manager does a budget, they will take the budget for the previous year, and make adjustments to it as necessary for the following year. They also will need to include justification and/or explanations regarding the changes that they have made. That is what you will do in this assignment. You are given a budget for the previous year in the attached spreadsheets, and instructions on how you will adjust the budget for the following year in the attached Word document. You also will need to include a justification and explanation of the changes that you made.
Assignment:
- Create a budget and justify all of your calculations and recommendations. Use the attached documents to complete the assignment. Travel is from CT to where ever the AHIMA Confernce location is
Instructions:
- You will turn in three excel spreadsheet for your proposed budget (these should be completed as separate tabs within one spreadsheet document):
- Spreadsheet One: listing salaries
- Spreadsheet Two: a listing that is broken down by month
- Spreadsheet Three: an annual budget
- You will turn in a Word Document that justifies your expenses for every category in your budget.
- You will turn in a Word Document that identifies the equipment you would like to purchase, and a justification for that equipment. Attach any product description pages about your selection
I Create a budget for 2019 and justify all of your calculations and recommendations. Background: You have been assigned the task of completing the proposed budget for the next fiscal year for your Department. 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 1. You will tum in three excel spreadsheet for your proposed budget (these should be completed as separate tabs within one spreadsheet document): costs. Spreadsheet One: listing salaries Spreadsheet Two: a listing that is broken down by month You have been told to project a maximum 5% salary increase. You have been told to project an increase in supplies of 7%. You have been told to project a 5% increase in all other areas, except those discussed below. Spreadsheet Three: an annual budget (see examples provided) 2. You will tum in a Word Document that justifies your expenses for every category in your budget. You must also evaluate travel expenses, membership and dues. It is the policy of your facility to pay for the coder CCS annual maintenance, 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 for these costs) 3. You will tum in a Word Document that identifies the equipment you would like to purchase, and a justification for that equipment. Attach any product description pages about your selection Your presentation must be organized and well thought out. You need to budget to attend the AHIMA convention (use most current data). Be sure to estimate airfare, hotels, food, and registration fees for a 4 day convention. Attach appropriate document that details estimated expenses. (Yes, check actual airfare from your home city to Seattle Washington and include that. Estimate $160.00 a night for hotel and $55.00 a day for food). You typically host lunch for your staff during HIM week in November. You have 12 employees in your department and you usually plan to spend $10.00 per person. You need to budget for education. You know that you must provide education for your coders to include, at a minimum, FY coding updates (both ICD-10 and CPT). Additionally, your coders need a minimum of 10 CE's a year to maintain their coding certification and the hospital provides that education. (check AHIMA's web site, go to the book store, and check the price of audio seminars. Budget enough to cover the cost for approximately 10 hours) You have also been advised to make any capital requests at this time. You need a new scanner to scan records - needs to be professional model to take the workload. (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.) Based on 2080 hours working a year, what is your department's average hourly rate? What is the total average monthly expense for your Department each month? (total budget / 365 * days in month) . Assignment Instructions: A B 1 PUT THE NAME OF YOUR HOSPITAL HERE 2 HEALTH INFORMATION MANAGEMENT 3 4 ANNUAL BUDGET FOR 2019 5 6 SALARIES $471,040.00 7 EDUCATION $1,200.00 8 MAINTENANCE CONTRACTS $25,000.00 9 REPAIRS $3,500.00 10 FOOD $300.00 11 STORAGE $7,200.00 12 POSTAGE $1,200.00 13 OFFICE SUPPLIES $36,000.00 14 PROFESSIONAL DUES $250.00 15 TRAVEL $1,800.00 16 TOTAL $547,490.00 17 18 AVERAGE HOURLY RATE $18.87 19 20 REVENUE $78,000.00 21 nt 5 Alignment 5 Number TOTAL SALARIES FOR DEPARTMENT E A B D 1 THE NAME OF YOUR HOSPITAL HERE 2 2019 SALARIES 3 SALARY EXPENSES WORK SHEET 4 5 POSTON SALARY HOURLY RATE *2080 6 DIRECTOR $80,000.00 7 DRG COORDINATOR $28.00 $58,240.00 3 CODER $22.00 $45,760.00 9 CODER $22.00 $45,760.00 10 CODER $18.00 $37,440.00 11 SUPERVISOR $20.00 $41,600.00 12 CLERK $12.00 $24,960.00 13 CLERK $12.00 $24.960.00 14 CLERK $12.00 $24,960.00 15 ROI CLERK $15.00 $31,200.00 16 ROI CLERK $15.00 $31,200.00 17 VITAL STATS CLERK $12.00 $24,960.00 18 $391,040.00 19 TOR SALARY ADDED BACK IN $80,000.00 20 SALARIES FOR DEPARTMENT $471,040.00 21 A B 1 PUT THE NAME OF YOUR HOSPITAL HERE 2 HEALTH INFORMATION MANAGEMENT 3 4 ANNUAL BUDGET FOR 2019 5 6 SALARIES $471,040.00 7 EDUCATION $1,200.00 8 MAINTENANCE CONTRACTS $25,000.00 9 REPAIRS $3,500.00 10 FOOD $300.00 11 STORAGE $7,200.00 12 POSTAGE $1,200.00 13 OFFICE SUPPLIES $36,000.00 14 PROFESSIONAL DUES $250.00 15 TRAVEL $1,800.00 16 TOTAL $547,490.00 17 18 AVERAGE HOURLY RATE $18.87 19 20 REVENUE $78,000.00 21 I Create a budget for 2019 and justify all of your calculations and recommendations. Background: You have been assigned the task of completing the proposed budget for the next fiscal year for your Department. 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 1. You will tum in three excel spreadsheet for your proposed budget (these should be completed as separate tabs within one spreadsheet document): costs. Spreadsheet One: listing salaries Spreadsheet Two: a listing that is broken down by month You have been told to project a maximum 5% salary increase. You have been told to project an increase in supplies of 7%. You have been told to project a 5% increase in all other areas, except those discussed below. Spreadsheet Three: an annual budget (see examples provided) 2. You will tum in a Word Document that justifies your expenses for every category in your budget. You must also evaluate travel expenses, membership and dues. It is the policy of your facility to pay for the coder CCS annual maintenance, 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 for these costs) 3. You will tum in a Word Document that identifies the equipment you would like to purchase, and a justification for that equipment. Attach any product description pages about your selection Your presentation must be organized and well thought out. You need to budget to attend the AHIMA convention (use most current data). Be sure to estimate airfare, hotels, food, and registration fees for a 4 day convention. Attach appropriate document that details estimated expenses. (Yes, check actual airfare from your home city to Seattle Washington and include that. Estimate $160.00 a night for hotel and $55.00 a day for food). You typically host lunch for your staff during HIM week in November. You have 12 employees in your department and you usually plan to spend $10.00 per person. You need to budget for education. You know that you must provide education for your coders to include, at a minimum, FY coding updates (both ICD-10 and CPT). Additionally, your coders need a minimum of 10 CE's a year to maintain their coding certification and the hospital provides that education. (check AHIMA's web site, go to the book store, and check the price of audio seminars. Budget enough to cover the cost for approximately 10 hours) You have also been advised to make any capital requests at this time. You need a new scanner to scan records - needs to be professional model to take the workload. (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.) Based on 2080 hours working a year, what is your department's average hourly rate? What is the total average monthly expense for your Department each month? (total budget / 365 * days in month) . Assignment Instructions: A B 1 PUT THE NAME OF YOUR HOSPITAL HERE 2 HEALTH INFORMATION MANAGEMENT 3 4 ANNUAL BUDGET FOR 2019 5 6 SALARIES $471,040.00 7 EDUCATION $1,200.00 8 MAINTENANCE CONTRACTS $25,000.00 9 REPAIRS $3,500.00 10 FOOD $300.00 11 STORAGE $7,200.00 12 POSTAGE $1,200.00 13 OFFICE SUPPLIES $36,000.00 14 PROFESSIONAL DUES $250.00 15 TRAVEL $1,800.00 16 TOTAL $547,490.00 17 18 AVERAGE HOURLY RATE $18.87 19 20 REVENUE $78,000.00 21 nt 5 Alignment 5 Number TOTAL SALARIES FOR DEPARTMENT E A B D 1 THE NAME OF YOUR HOSPITAL HERE 2 2019 SALARIES 3 SALARY EXPENSES WORK SHEET 4 5 POSTON SALARY HOURLY RATE *2080 6 DIRECTOR $80,000.00 7 DRG COORDINATOR $28.00 $58,240.00 3 CODER $22.00 $45,760.00 9 CODER $22.00 $45,760.00 10 CODER $18.00 $37,440.00 11 SUPERVISOR $20.00 $41,600.00 12 CLERK $12.00 $24,960.00 13 CLERK $12.00 $24.960.00 14 CLERK $12.00 $24,960.00 15 ROI CLERK $15.00 $31,200.00 16 ROI CLERK $15.00 $31,200.00 17 VITAL STATS CLERK $12.00 $24,960.00 18 $391,040.00 19 TOR SALARY ADDED BACK IN $80,000.00 20 SALARIES FOR DEPARTMENT $471,040.00 21 A B 1 PUT THE NAME OF YOUR HOSPITAL HERE 2 HEALTH INFORMATION MANAGEMENT 3 4 ANNUAL BUDGET FOR 2019 5 6 SALARIES $471,040.00 7 EDUCATION $1,200.00 8 MAINTENANCE CONTRACTS $25,000.00 9 REPAIRS $3,500.00 10 FOOD $300.00 11 STORAGE $7,200.00 12 POSTAGE $1,200.00 13 OFFICE SUPPLIES $36,000.00 14 PROFESSIONAL DUES $250.00 15 TRAVEL $1,800.00 16 TOTAL $547,490.00 17 18 AVERAGE HOURLY RATE $18.87 19 20 REVENUE $78,000.00 21
