round: ve been assigned the task of completing the proposed budget for the next fiscal year r Department. The fiscal year is from January - December. As a tool, you have the from the previous year, the salary worksheet and the monthly expenses report. You using the historical data provided as well as considering your projections for future 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 liscussed below. st also evaluate travel expenses, membership and dues. It is the policy of your o pay for the coder CCS annual intenance, your AHIMA dues, and to reimburse er who successfully passes the CCS examination. You know that two of your lan to take the CCS exam next year. (Check AHIMA for these costs) to budget to attend the AHIMA convention (use 2008 cost date). Be sure to airfare, hotels, food, and registration fees for a 4 day convention. Attach ate document that details estimated expenses. (Yes, check actual airfare from your y to Seattle Washington and include that. Estimate $160.00 a night for hotel and day for food). cally host lunch for your staff during HIM week in November. You have 12 s in your department and you usually plan to spend $10.00 per person. to budget for education. You know that you must provide education for your include, at a minimum, FY coding updates (both ICD-9 and CPT). Additionally, rs need a minimum of 10 CE's a year to maintain their coding certification and al provides that education. (check AHIMA's web site, go to the book store, and price of audio seminars. Budget enough to cover the cost for approximately 10 also been advised to make any capital requests at this time. You need a new scan records - needs to be professional model to take the workload. (check the hoose a model, see if you can find multiple sites with the same product and ricing, attach info to your budget.) sed on 2080 hours working a year, what is your department's average hourly e? mat is the total average monthly expense for your Department each month? al budget / 365 * days in month) tructions: For 2017 and justify all of your calculations and recommendations. in three excel spreadsheet for your proposed budget (these should be arate tabs within one spreadsheet document): Pet One: listing salaries eet Two: a listing that is broken down by month eet Three: an annual budget (see examples provided) in a Word Document that justifies your expenses for every category in in a Word Document that identifies the equipment you would like to istification for that equipment. Attach any product description pages on. on must be organized and well thought out. E NAME OF YOUR HOSPITAL HERE INFORMATION MANAGEMENT BUDGET FOR 2016 SALARIES $471,040.00 EDUCATION $1,200.00 ENANCE CONTRACTS) $25,000.00 REPAIRS $3,500.00 FOOD $300.00 STORAGE $7,200.00 POSTAGE $1,200.00 OFFICE SUPPLIES $36,000.00 PROFESSIONAL DUES $250.00 TRAVEL $1,800.00 TOTAL $547,490.00 RAGE HOURLY RATE $18.87 REVENUE! $78,000.00 - YOUR HOSPITAL HERE ES ENSES WORK SHEET *2080 ON OR INATOR R R R SOR