Just received the current staffing levels mentioned above. The data file is employee by department, location, title and salary and totals $127,492,461 for the 1,864 heads. Just put some summary schedules together for the data provided.
First, the current salaries by salary range:
If you're like me and don't particular like staring at numbers, here's the data in chart form:
Now, if you look at this data, you'll see that there are 381 staff making over $100,000, which represents 20.1% of the heads and 32.5% of the dollars. The next 1,045 staff making $50,000 but less than $100,000 represent 55.2% of the staff and 59.7% of the dollars. Finally, the 468 staff making less than $50,000 represent 24.7% of the staff and7.8% of the dollars.
Here's what the staffing looks like by department in heads and dollars broken down into average, median, high and low salaries:
Here's what you get if you compare Super Dr. Richard 'Looking for the Exit Ramp' O'Malley's salary to the average salaries:
Por exemplo, he makes 2.6 times the average teacher's salary and 8.1 times more than the average para's and that's after his new contract which dropped his $222,854 base salary to $209,000 and moved it over to performance bonuses.
Finally, here's a picture of an interactive table in this Excel file which you can use to sort the data anyway you want to get at the info you're looking for. Unfortunately, this blog can't handle the table features but if you want a copy of the Excel file just drop me a note. You're welcome to it.
Anyhoo, it is what it is and it will stay that way until you start paying attention to what goes on over there on Mythomania Lane.
No comments:
Post a Comment