Spreadsheet, revised

[Roger Hultgren]

Attached is a revision to the spreadsheet I sent out on Saturday.  Please replace that spreadsheet with this one.

 

I added a summary (which prints on page 4 of this version) that shows the percentage of total revenues for all villages combined, by category (allocation, lease, tuition, etc.) by year.  This is essentially the revenue side of what I did before for the expenses.

 

I also found an error – a stray word – on the version I sent out Saturday, which I removed.  And, the totals in a couple of columns did not add correctly, so I corrected that.

 

Full disclosure – I took one shortcut on the revenues – I ignored the line of item of gain or loss from disposal of assets.  This is a minor category that I did not include in my earlier work.  There have been only a handful of transactions reported:  $61 gain in FY2000 (that is across all villages), $842 loss in FY2001, $300 gain in FY2002, $3,978 loss in FY2003, $958 loss in FY2004, $25 gain in FY2007, and $1,737 loss in FY2009.  I think those numbers are so minimal that they would not significantly affect the percentages.

 

Again, my purpose here is to help inform our discussion with the village managers.

 

 

*****

Roger Hultgren

 

[Bnardj...@aol.com]

Thank you very much Roger.

Bernard

[Chick Rhodehamel]

Dear FAC Team,

As of this afternoon the Village Manager count for this week's meeting is:

6 are coming

3 who are unable to attend are sending their thoughts/challenges/issues with the 6 attending

1 unable to attend (Patricia laidig TC) but has not indicated if other will bring her info along.

 

Should be good turn out.

Chick

---

From: ca-...@googlegroups.com on behalf of Bnardj...@aol.com
Sent: Mon 12/13/2010 5:41 PM
To: ca-...@googlegroups.com
Subject: Re: [ca-fac] Spreadsheet, revised

[Bnardj...@aol.com]

Thanks. I will do my best to make it also.

Bernard