Question

Care Clinic is preparing a worksheet for their staff. Their average staring salary is $60,000. Benefits are 25% this year. They expect benefits 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

Answer 1

A formatted excel spreadsheet for Care Clinic's image is given below:

Step-by-step explanation:

Given,

Salary for 1 employee = $60,000

Benefits = 25% of employee's salary.

Next Year,

Salary for 1 employee = $60,000 + ($60,000 x 0.05%) = $63,000

Benefits = 27% of employee's salary.

The following image shows the answer: