Salaries Dept Total Salary for Dept 2321100 $69,514 2325100 $21,348 2325200 $93,331 2325600 $136,035 2325300 $27,744 2325400 $30,823 2325500 $25,010 2325700 $27,277 2321300 $9,375 2321400 $86,169 2321500 $51,935 2321600 $81,400 2327100 $7,016 2327200 $80,384 2327300 $12,162 2327400 $84,416 2341400 $55,105 2341200 $47,626 2341300 $22,540 2346200 $42,726 2346400 $34,279 2346100 $108,080 2346300 $71,770 2331300 $97,599 2331500 $25,550 2333100 $22,227 2333200 $64,292 2333300 $47,922 2335100 $23,322 2335200 $72,996 2335300 $52,456 2335400 $9,776 2337100 $38,819 2337300 $67,615 2337400 $54,085 2301100 $44,319

Headcount Dept Total Headcount for Dept 2321100 5 2325100 1 2325400 3 2325500 2 2325700 2 2321300 2 2327100 1 2327200 8 2325200 8 2325600 10 2325300 3 2341300 2 2346200 4 2346400 4 2346100 6 2341400 6 2321400 8 2321500 5 2321600 7 2327300 1 2327400 7 2341200 5 2335100 2 2335200 11 2335300 6 2346300 7 2331300 11 2331500 2 2333100 2 2333200 7 2333300 5 2337400 6 2301100 4 2335400 1 2337100 3 2337300 7 174

Dept Total Headcount for Dept 2321100 5 2325100 1 2325400 3 2325500 2 2325700 2 2321300 2 2327100 1 2327200 8 2325200 8 2325600 10 2325300 3 2341300 2 2346200 4 2346400 4 2346100 6 2341400 6 2321400 8 2321500 5 2321600 7 2327300 1 2327400 7 2341200 5 2335100 2 2335200 11 2335300 6 2346300 7 2331300 11 2331500 2 2333100 2 2333200 7 2333300 5 2337400 6 2301100 4 2335400 1 2337100 3 2337300 7 174

---------------------------------------- Dept Employee Category Location 2301100 Nurse Island 2321100 Teacher Rural 2321300 Salesman Rural 2321400 Construction Worker Rural 2321500 Doctor Rural 2321600 Nurse Rural 2325100 Fireman Rural 2325200 Accountant Rural 2325300 Politician Rural 2325400 Printer Rural 2325500 Car Dealer Rural 2325600 Police Rural 2325700 Dog Catcher Rural 2327100 Teacher City 2327200 Fireman City 2327300 Accountant City 2327400 Police City 2331300 Nurse City 2331500 Teacher Island 2333100 Fireman Island 2333200 Accountant Island 2333300 Police Island 2335100 Politician Island 2335200 Printer Island 2335300 Car Dealer Island 2335400 Dog Catcher Island 2337100 Salesman Island 2337300 Construction Worker Island 2337400 Doctor Island 2341200 Printer City 2341300 Car Dealer City 2341400 Politician City 2346100 Construction Worker City 2346200 Dog Catcher City 2346300 Doctor City 2346400 Salesman City 2721500 Construction Worker Rural 2725400 Baseball Rural 2725700 Police Rural 2727400 Fireman Rural 2731300 Accountant City 2735300 Salesman City 2741300 Doctor City

Tab Description Tab 1 Compensation: Total department salary by department number Tab 2 Headcount: Total headcount by department number Required Questions o Please provide an average salary per headcount for each location : Rural, City, \& Island Tab Description Tab 1 Compensation: Total department salary by department number Tab 2 Headcount: Total headcount by department number Required Questions o Please provide an average salary per headcount for each location : Rural, City, \& Island