Question

Step 1—Each position will get a merit increase in January. Calculate their new base salary. 

Note: You may practice manually if you'd like to see if you get the same answer when you complete it in the spreadsheet. Formulas MUST be used in MS Excel for any cells requiring calculations.

Position

Salary per year

% Raise

New Salary

ER Coder

$40,000

2%

 

Analyst

$28,500

2.5%

 

File clerk

$22,375

4%

 

 

Step 2—They will need to reduce the number of hours for the department to 36 hours per position for the remaining 15 weeks of the year. What is the new salary for each position?

Position

Salary in September

Salary at 36 hrs/week

New Salary

ER Coder

 

 

 

Analyst

 

 

 

File Clerk

 

 

 

 

Step 3—How much did the company save by cutting back each position by 4hrs/week for the remainder of the year?

Position

Salary at 40hrs/week

Salary at 36hrs/week

New Yearly Salary

Company Savings

ER Coder

 

 

 

 

Analyst

 

 

 

 

File Clerk

 

 

 

 

                                                                                                                                                               TOTAL:

Step 1Each position will get a merit increase in January.Calculate their new base salary. Note:You may practice manually if you'd like to see if you...
Get unstuck

372,107 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses