Calculate the percentage of increase or decrease in salaries

Assignment Help Accounting Basics

Reference no: EM134007585

Problem

Objectives

1) Perform variance analysis (percentage of change) between specified HIM budget line items from FY2024 and FY2025
2) Develop an operating budget for the HIM department for FY2026
3) Use Excel to document and submit the FY2026 operating budget
4) Create formulas in an Excel spreadsheet
5) Write a budget justification

Instructions

Review the following case study and Excel spreadsheet template to calculate variances as indicated in the scenario. Use the spreadsheet template and assumptions to complete the proposed FY2026 budget. Include formulas for calculating all affected columns in the Excel template. Give a budget justification for presentation to a budget committee.

Scenario

As the health information management director at Mission Baptist Hospital, you are responsible for developing the department's annual budget. Prior to meeting with your coding and transcription supervisors, you reviewed the budget data for FY2024 and FY2025. In the meeting with supervisors, you discuss the needs of their areas and projected volume statistics for FY2026. It is now time to develop the budget for FY2026. You have been instructed by the budget department to use the spreadsheet provided to submit your FY2026 budget. You will attach a written budget justification of your finalized budget to the Mission Baptist Hospital budget review committee.

Calculate the following: (show your calculations and round to the nearest tenth)

I. Calculate the percentage of increase or decrease in the total salaries/wages/benefits for the entire HIM department from FY2024 to FY2025.

II. Calculate the percentage of increase or decrease in the coders' total salaries/wages/benefits for all coding positions combined (I, II, III) from FY2024 to FY2025.

III. Calculate the percentage of increase or decrease in the use of outsourced coding services from FY2024 to FY2025.

IV. Calculate the percentage of increase or decrease in the use of outsourced transcription services from FY2024 to FY2025.

V. Calculate the percentage of increase in the ROI copying fees from FY2024 to FY2025. Get the instant assignment help.

VI. Calculate the percentage of increase in the physician office coding contract from FY2024 to FY2025.

Reference no: EM134007585

Questions Cloud

Calculate the balance of the property tax payable : Kellman Jerkirer Inc. has a December 31 year-end. Calculate the balance of the property tax payable or prepaid property tax account as at May 31, 2022.

Considered unacceptable by society and secondly : Criminal law serves two purposes: firstly, it identifies behaviors that are considered unacceptable by society, and secondly,

Legal standards and admissibility of forensic evidence : Legal Standards and Admissibility of Forensic Evidence: Examine the legal standards and criteria governing the admissibility of forensic evaluations

Analyze the type of pretrial publicity that occurred : what was the basis for it and what was the outcome? Analyze the type of pretrial publicity that occurred

Calculate the percentage of increase or decrease in salaries : Calculate the percentage of increase or decrease in the total salaries/wages/benefits for the entire HIM department from FY2024 to FY2025.

Non-compliance with the Pregnant Workers Fairness Act : What are the penalties and fines associated with non-compliance with the Pregnant Workers Fairness Act?

What are resources and materials that can be used : What are resources and materials that can be used for this 6th special education science lesson on converting metric units based on these learning standards?

Identify at least five potential stakeholders from the case : Identify at least five potential stakeholders from the case above and discuss how they were affected by the actions of Scott London?

What internal control component does action most align with : A board sub-committee met to study how a recently passed property tax exemption by the state. What internal control component does this action most align with?

User Account

All Pages