cellMatrix.net

Spreadsheet Modeling and Related Topics

Financial Crisis in Dallas Schools

As reported by the Dallas Morning News and CNN, 375 teachers were laid off, 450 reassigned to other schools, and 40 counselors and assistant principals were let go due to a massive miscalculation in the budget.

About two weeks ago, school officials said they'd found a $64 million shortfall in the 2007-08 budget. Since then, the district has said there will be a shortfall in the current 2008-09 budget that could grow to $84 million if no cuts are made.

You originally project a $64 million shortfall but now it's $84 million? Where did the other $20 million come from?

Mr. Lowe identified two root causes of the financial problems: "inadequate competence" in the district's finance and accounting offices, and an organizational structure that kept the payroll and accounting functions separate. "We had these different systems that weren't talking to each other".

I find it hard to believe that the finance and accounting staff would not have access to some type of salary data. And you're telling me that, after "X" amount of years that the school district has been in existence, we're just now discovering that we have systems in place that don't talk to each other? That's why we can't get the right salary data? If that's true, we seemed to get by with no problems in the past using these same systems - what's different now?

Dr. Hinojosa said the deficit occurred because administrators miscalculated average teacher salaries and did not realize exactly how many positions had been added during the year.

That's precisely why finance and accounting staff should build the budgets. The administrative function is to review and approve the budgets.

It's my guess that the finance and accounting staff had very little to do with building the budgets. And after they were created, the finance and accounting staff we're probably not asked to do a high-level review for reasonableness or a technical review for accuracy. After all, simple variance analysis techniques would have revealed a shortfall of this magnitude.

As seems to be more and more the norm these days, good hardworking people (in this case - the teachers and others) are punished due to the incompetence of management. It's management's job to put processes in place so that these types of things don't occur. But rather than management loosing their jobs, I'm betting that after it's all over and done they'll do just fine.

Posted on Friday, October 17, 2008 | Comments (0) | Permalink

Comment Entry Form

User Information

Name: (Required)

E-Mail Address: (Optional)

Location: (Optional)

Web Site Address: (Optional)

Comment Formatting Reference
Add VBA Code:
<pre>some code here</pre>
Linking:
[url]http://www.example.com/[/url]
[url=http://www.example.com/]my site[/url]
Text Formatting
[size=4]Some larger text[/size]
[color=green]Some green text[/color]
[b]Some bold text[/b]
[i]Some italic text[/i]
Enter Comment Below

Personalization Options
Remember my personal information
Notify me of follow-up comments?

Next entry: Download Stock Histories to Excel

Previous entry: Actual vs. Plan Crawl Chart

<< Back to main

Statistics

  • Total Entries - 136
  • Current Viewers - 29

Categories

Entries by Day

Sep - 2010
S M T W T F S
29 30 31 1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 1 2

Recent Comments

Syndicate