Question & Answer: Care Clinic is preparing a worksheet for their staff. Their average starting salary is $60,000. Bene…..

Care Clinic is preparing a worksheet for their staff. Their average starting salary is $60,000. Benefits are 25% this year. They expect them to go up to 27% next year. They are expecting to give a raise of 5% next year. Care Clinic has 20 employees. Prepare a formatted Excel Spreadsheet for Care Clinic which projects total staff expense for next year.

Expert Answer

 

Care Clinic Budget for total staff expense for next year
Per Employee Total for 20 employees
Salary $63,000 $1,260,000
Benefits [27% of Salary] $17,010 $340,200
Total Budgeted Staff Expense for Next Year $1,600,200
Still stressed from student homework?
Get quality assistance from academic writers!