USA: +1 (725) 712-1730 
Sign in
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 | ||
