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.
|Care Clinic Budget for total staff expense for next year|
|Per Employee||Total for 20 employees|
|Benefits [27% of Salary]||$17,010||$340,200|
|Total Budgeted Staff Expense for Next Year||$1,600,200|