Please help with formula or a method to calculate per employee job level salary cost for different departments when we only have is total salary cost employee for entire dept. We are also given average salary for each level of employee.

Below are the details

Average salary per Job level per month

JL 1 - 200 $

JL 2 - 300 $

JL 3 - 400 $

JL 4 - 550 $

JL 5 - 700 $

JL 6 - 900 $

Total actual cost for a department - 20000 $

Below are the actual headcount given

JL 1 - 35

JL 2 - 25

JL 3 - 15

JL 4 - 7

JL 5 - 2

JL 6 - 1

We need to find per employee salary cost with reference to total cost given @ 20 K USD and with reference to average salary cost given per job level.

Please help.

Thanks