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
Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: Care Clinic is preparing a worksheet for their staff. Their average starting salary is $60,000. Bene…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
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 |