Can you help me plug in the correct amounts in the spreadsheet below? I'm unsure what numbers and information to include in the budget. Can you help assist me with this assignment?

Today is your first day as the new Director of HIM.You were hired directly out of college.The budget is due next week and according to the CEO"there are no exceptions."Your predecessor has retired after 42 years.The Assistant quit because he was not promoted to Director.He was being paid $45,000 and will not be replaced.All other supervisory staff members are relatively new and serving as working supervisors.Because you are an RHIA rather than an RHIT, you are being paid $10,000 more than your predecessor.The Budget Data provided is the only data available because you cannot find anything in the "disaster" of an office that your predecessor left.

For this assignment, you are to prepare the 12-month budget for FY 2022 (7/1/21-6/30/22).Display your 12 months budget on a single Excel spreadsheet showing all line items.Each month should be clearly labeled with all months on the same sheet.

Your assignment should include the budget assignment spreadsheet (see modules section of canvas), a memo, and a written explanation of budget assumption below.The memo and explanations should be submitted as one or two word document(s).

DO NOT EMBED NOTES IN THE SPREADSHEET THAT YOU WANT ME TO CONSIDER

In addition to the Budget Assumptions (see below) and the Prior Year's Actual Data, the Budget Manager has given the following guidelines:

Your overall budget must decrease by at least 10% from last year because there have been volume declines.

You should not add any new expense accounts/line items.

Salary increases are anticipated for the next fiscal year and are not expected to exceed 2% due to the poor economy.

The Budget Manager expects you to give him the 12-month budget for all line items.

If you increase or reduce any of these line items, you must thoroughly explain why.

You cannot transfer costs to another department.

Prepare a written summary of the basis for the changes to each account for the CFO to accompany your budget.

Budget Assumptionsfor FY 2022:

1.Paper goods are expected to increase 2%.

2.The imaging/scanning project is fullyimplemented and 2 FTEs (1 of which is an analyst) and all temporary workerswho were paid by the hospital will be eliminated.Average hourly compensation is $14.50/hour.

3.Prior to the scanning project being fullyimplemented you had 7 analysts.

4.Your coding consultant indicates that theconsulting fees for her services will increase by 3%.She will do her audits in the Spring andFall.She is the only consultant youuse at this time.

5.The imaging project has replaced the needfor microfilming.

6.The CFO states that all travel, training,dues, books, and employee relations budgets must be zero-based. (READ YOUR TEXTS TO ENSURE YOU PROVIDE AZERO-BASED EXPLANATION.)A detailedexplanation for these items must be provided showing the cost of each and howthe cost was derived (see page 143-145 of your text).You have 9 AHIMAcredentialed coders, 2 credentialed cancer registrars, and 4 supervisors (2are AHIMA credentialed members).

7.This is your year to go to the National AHIMA meeting.Only the Director is allowed to go to theNational meeting and you are going!Your CFO has asked you to learn as much as possible about implementingICD-10 and an EHR system.The meetingis in Baltimore, MD.

8.Each week you are responsible for buyingcandy and assorted small sport items as giveaways for the Medical Staff.Cost is expected to increase by 2%.

9.There is no change expected in the rates applied by the Federal Government.The FICA can be calculated as a percentage of salaries.

10.During this past year it was decided thatfood would no longer be provided at Medical Staff meetings.Therefore, you no longer need to budgetcatered food for the Cancer Conferences or for the Medical RecordsCommittee.

11.You will have a catered lunch from Dietaryfor HIM Week in November.You willhave 50 employees in the department during HIM Week and 3 Volunteers.Additionally, you intend to invite your CFOand the President of the Medical Staff.No other catered meals are expected.In addition to a free lunch for HIM Week you will purchased alogo-line item from AHIMA.

12.You will continue to have employeeincentive plans for your analysts and coders.These are flat payments made for achieving goals regardless of theemployee's rate of pay and are not tied to any compensation increase.The incentives are paid quarterly.

13.A full-time equivalent employee (FTE) isconsidered as one who could be paid 2,080 hours/year.

14.Temporary staff is not eligible forbenefits.

15.Incentive compensation is not eligible forbenefits.

16.Maintenance contracts are to be budgeted inthe month they are due to be paid.

17.Your contracted release of information firmdoes not intend to make any changes to their services nor does it intend to raiseits charges to you.Their 2 staffmembers are included in your "employee" count for HIM week.

18.The FICA amount is based on regular andtemporary salaries as well as incentive compensation.