$\backslash$table$[[$Employee Category,Headcount $($FTE$)],[$Administrative$/$Leadership$,40],[$Instructor$,240],[$Support Staff$/$Clerical$,120],[$Custodial$/$Maintenance$,60],[$Total Head Count,$460]]$

Voluntary turnover is estimated at $7\%$ for all employee categories except support staff, which is estimated at $4\%.$

Involuntary turnover, is expected to be $2\%,$ except for Administrative$/$Leadership$,$ which is estimated at $0\%.$

Employee promotions are expected to be as follows:

$\backslash$table$[[$Category$,$Number,Promoted To:$],[$Instructors$,5,$Administrative$/$Leadership$],[$Support Staff,$2,$Administrative$/$Leadership$]]$

Staffing levels of job categories can increase by hiring new employees or promoting existing ones.

Promotions to a new category causes a need or replacement from those being promoted.

The cost to hire at each category is as follows:

$\backslash$table$[[$Administrative$/$Leadership$,$$$12,000$

Given the information and assumptions listed above, complete the following table for this year. Round up to the next whole number when performing calculations. Do not change the numbers in the highlighted cells. Submit your completed worksheet to Canvas.

$\backslash$table$[[$Category$,\backslash$table$[[$Administrative$/],[$Leadership$]],$Instructor,$\backslash$table$[[$Support Staff$/],[$Clerical$]],\backslash$table$[[$Custodial$/],[$Maintenance$]]],[$Beginning$,40,240,120,60],[\backslash$table$[[$Voluntary$],[$Turnover$]],,,,],[\backslash$table$[[$Involuntary$],[$Turnover$]],,,,],[\backslash$table$[[$Promotions$],[($Adds$)]],,,,],[\backslash$table$[[$Promotions$],[($Losses$)]],45,230,125,],[\backslash$table$[[$Projected Total$],[$Available$]],,,,],[\backslash$table$[[$Estimated Total$],[$Required$]],,,,],[\backslash$table$[[$New External$],[$Hires Required$]],,,,],[$Cost of Hire,$$12,000,,,],[\backslash$table$[[$Total Cost of$],[$Hire$]],,,,]]$