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.
Salary per year
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?
Salary in September
Salary at 36 hrs/week
Step 3—How much did the company save by cutting back each position by 4hrs/week for the remainder of the year?
Salary at 40hrs/week
Salary at 36hrs/week
New Yearly Salary
Recently Asked Questions
- A social scientist claims that the average adult watches less than 26 hours of television per week. He collects data on 25 individuals television viewing
- The lifetime, X, of a ce rtain brand of engine h as a normal d istribution with a me an of 7 years anda standard deviation o f 1.2 years.a.If the warranty
- Of the 50 automobiles in a used-car lot, 10 are white. If 5 automobiles are selected to be sold at an auction, find the probability that exactly 2 will be