Village revenue & expense

[Roger Hultgren]

Attached is a spreadsheet I put together over the last couple of days.

 

This should print on 3 pages, in landscape.

 

The data on pages 1 and 2 and the first third or so of page 3 show village revenue sources for FY2000 – FY2010 by category (the allocation, lease & rental, tuition & enrollment, etc.) for each village and for each year.  I think there are a few things to note:

 

n  The allocation is a major source of revenue for each village, but you should note that the allocation varies a lot among the villages.  It is obviously not as simple as the formula in the budget document would make it appear.  I suspect there is a lot of give and take between each village and CA on the number each year.

n  Long Reach and Wilde Lake get a lot of money through tuition and enrollment.  Both of those villages sponsor classes and camps.

n  Harper’s Choice, Long Reach, and Town Center get a good portion of their funds from leases.

n  Interest, special events, and fees are of minor importance, although Oakland Mills got a lot of money from fees in the early 2000s.

n  River Hill, Oakland Mills, and Town Center are big users of the “Miscellaneous” category.  For Oakland Mills, the rise in use of “Miscellaneous” corresponds to a decline in the use of “Fees”.

 

After reviewing the expense part of the village financial reports, I decided on a much simpler presentation of that data, which is on the lower part of page 3.  Basically, the villages’ major expense is labor -- staff salaries, janitorial expenses, and staff benefits.  The data on the lower portion of page 3 summarizes village expenses for each category as a percentage of total expenses.

 

I hope this spreadsheet will help inform our discussion with the village managers.

 

 

*****

Roger Hultgren