Calculating Staffing Budgets Assignment BC

pdf

School

Dutchess Community College *

*We aren’t endorsed by this school

Course

MISC

Subject

Accounting

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by ChefSandpiperMaster652

HIT 210 Module 11 Calculating Staffing Budgets Feel free to print out this assignment and fill it in legibly by hand if that is what you prefer! You can submit by uploading a clearly viewable file in jpeg or PDF format. You are preparing the Coding Department’s portion of the HIM Department’s personnel budget for the next fiscal year. You must account for your department’s staffing budget with the projected raises. A decision from the board of Broome Community Hospital resulted in higher raises in an attempt to assist with employee retention after a few years of heavy turnover. Full-time staff will be getting a raise of 4.2%. Part-time staff will be getting a raise of 2.5%. All full-time staff work a full 40-hour week, Part time employees get 20 hours weekly. Hint: How many weeks are in a year? 1. Complete the chart below: Coder Status Current Rate (per/hour) Current Salary Raise Amount Next Year’s Salar y Inpatient Coder 1 FTE 24.00 49,920$ 2,096.64$ 52,016.64$ Inpatient Coder 2 FTE 22.50 46,800$ 1,965.60$ 48,765.60$ Inpatient Coder 3 FTE 21.85 45,448$ 1,908$ 47,356$ Outpatient Coder 1 FTE 19.75 41,080$ 1,725.36$ 42,805.36$ Outpatient Coder 2 FTE 19.75 41,080$ 1,725.36$ 42,805.36$ ER Coder 1 FTE 18.25 37,960$ 1,594.32$ 39,524.32$ ER Coder 2 PT 18.25 37,960$ 949$ 38,909$ Ancillary Coder 1 FTE 17.50 36,400$ 1,638$ 38,038$ Ancillary Coder 2 PT 17.50 36,400$ 910$ 37,310$ Next Year’s Salary Total for Coders: 9,453,055.32

For questions 2-4 please show your work for full credit! 2. “ Fringe Benefits costs refer to those disbursements incurred by the State for the benefit of its employees and includes the costs to the State, as an employer, for Retirement plans, Social Security, Health Insurance, Dental Insurance, Worker's Compensation, Survivor's Benefits, Unemployment Insurance and the State's contribution to the Employee Benefit Funds pursuant to agreements with the various bargaining units. ” 1 Calculate next year’s fringe benefit costs for the coding department which account for 32% of the total salary. 9,453,055.32\ 32% = 30,249,777.24 3. SUNY Broome Community Hospital is switching EHR systems next year. This is projected to result in 40 hours of overtime per full-time coder. What is the total projected cost of overtime for the coding department? Hint 1: What does New York State require for overtime rates for hourly non-exempt employees? Hint 2: If it helps you, feel free to make a chart like the one above! Use as much space as you need to map it out. 24.00X1.5= 36.00 X 40 = 1,440 $ 22.50X1.5= 33.75 X 40= 1,350 $ 21.85 X 1.5= 32.775X40 = 1,311$ 19.75X1.5= 29.625X40= 1,185$ 19.75X1.5= 29.625X40=1,185$ 18.25X1.5= 27.375X40= 1,095$ 17.50X1.5= 26.25X40= 1,050$ Total: 8,616 $ for overtime 4. Accounting for total salary with raises, fringe benefit costs, and projected overtime what is the total amount of the coding department’s staffing budget? 30,249,777.24 + 8,616= 30,258,393,24 $ 1 Office of the New York State Comptroller. 2019

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version