HomeMy WebLinkAbout2010-07-21 PACKET 04.I.REQUEST OF CITY COUNCIL ACTION COUNCIL AGENDA
MEETING ITEM #
DATE 7/21/10
PREPARED BY Finance Robin Roland
ORIGINATING DEPARTMENT DEPARTMENT HEAD
COUNCIL ACTION REQUEST
Receive June 30, 2010 financial report.
611fAIZ2 7xK�7��1�1 �1�7_�1[�P►p
no action necessary
BUDGET IMPLICATION
Id0l1010:11 %WTIkTAi[6P1P11
ACTUAL AMOUNT
ADVISORY COMMISSION ACTION
❑ PLANNING
❑PUBLIC SAFETY
❑ PUBLIC WORKS
❑ PARKS AND RECREATION
❑ HUMAN SERVICES /RIGHTS
❑ ECONOMIC DEV. AUTHORITY
SUPPORTING DOCUMENTS
F
REVIEWED
El
El
El
APPROVED
DENIED
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
❑
® MEMO /LETTER:
❑ RESOLUTION:
❑ ORDINANCE:
❑ ENGINEERING RECOMMENDATION:
❑ LEGAL RECOMMENDATION:
® OTHER: Financial analysis reports - General, Special Revenue and Enterprise Funds
ADMINISTRATORS COMMENTS
QS )(,A ` i0
City Administrator Date
* * * * * * * * * * * * * * * W W W W * W W * W * W W W W W W W * W * W * * * * * * * * * * * *
COUNCIL ACTION TAKEN: [ ❑ DENIED ® 'OTHER
A /1
H1Council items \City Council Action Form.doc
City of Cottage Grove ri1
Finance Department
TO: Honorable Mayor and City Council
Ryan Schroeder, City Administrator
FROM: Robin Roland, Finance Director+
DATE: July 15, 2010
RE: June 30, 2010 Financial Report
Introduction
Attached are financial reports giving budget to actual analysis for the General Fund, Special
Revenue and Enterprise funds for the six months ended June 30, 2010 with comparison data
for the same period in 2009.
Discussion
General Fund
The budget to actual analysis is presented with Revenues by type and Expenditures by
division.
As is normal for the June 30 financial report, total revenues are significantly less than 50%
received for the year, as the property tax settlement from the County does not arrive until the
first week in July. Other revenue sources including permits and charges for services are close
to the 50% anticipated for the half way point in the year. Investment income currently exceeds
our total annual budgeted amount due to stronger than anticipated revenues which exceed the
conservative budget for this line item.
Total General Fund expenditures are at 45.87% through June 30 4% less than the expected
50 %. The "% of budget" column should be used to evaluate how each division is doing at the
mid -point of the year. Some divisions, such as City Clerk, will see a greater expense in the
second half of the year (with elections) and should therefore be at significantly less than the
50 %. Other divisions, such as Legal /Assessing and Forestry, may be over the 50% due to
fees or charges which are paid in full for the entire year in a lump sum early on (and not
amortized each month).
Please note that the Engineering division has not yet been adjusted this year to apply the
appropriate wage costs to non - General fund projects. This adjustment has been done
quarterly in the past (as reflected in the 2009 comparison numbers) but has not been done yet
this year. When the allocation of wages and benefits to projects is done, the division expense
(and total General Fund expenditures) will be reduced to within budgeted levels.
Honorable Mayor, City Council, and Ryan Schroeder
Page 2 of 2
Special Revenue Funds
The Special Revenue Funds are presented as total revenues by fund and total expenditures by
fund, exclusive of transfers in or out.
Due to their nature, Special Revenue Funds are less predictable than the General fund. An
assumption that at the half way point in the year revenues or expenditures should also be at
50% would be inaccurate. For example, the Sealcoating fund relies on Franchise fees as
revenue, which are paid quarterly and which have not yet been received for the second quarter
of 2010. As a result, the Sealcoat fund only reflects that 21% of its budgeted revenues have
been received.
Enterprise Funds
The Enterprise Funds are presented as total revenues by fund and total expenditures by fund,
exclusive of transfers in or out.
Enterprise funds are less volatile than Special Revenue funds and because they do not
depend on property taxes as a source of revenue, the assumption can be made that the
percentage of revenues received and expenditures expended should be closely related to the
percentage of time elapsed in the year. The only exception to this would be the Golf Course
fund which is of a more seasonal nature.
As Enterprise funds are those operations most comparable to a business, each fund should be
evaluated based on where revenues are in relation to expenses in that fund. For example, at
June 30 the EMS fund shows $581,727 in revenues and $451,542 in expenses, reflecting a
positive position.
More detailed information on any of the funds operations is available from the Finance
department upon request.
Requested Action
For information only.
O
O
N
M
W
z
7
h 0
Z
Sao
0 LU
ir K K
uj aa
uj 6 U
- Z =
0 LL h
U
0 J 3
L
} W O
U Q ro
W
Z
0
0
r
O
O
ti
n
0000�>
aoeeeeeev000000 >o o o°aeeeee
O r O W O O
'O O M m Q` Q N M M t0 r t0 N c N n M V M
� D OJ O l0 (O M V N tp OJ M O
M M M m M r (
O V O
a
o
`o
0
O N
E
O O O m N N V
h (p N t f
O O m m N O
M O th N M n O N 0 0 0 N E
M N N M M O N c0 N h t0 m N M M M 10 M c0 O M
N N
O
N
M M VJ N n M O
N M Q Q r m M t° M t0 O M h m OJ M M N �- 'n t0 O N O t0 m
O O
O
j
v
G1
O
di
fry
' r_ V O_ n_ M_ r_
O_ h_ N_ M_ O)_ O_ M_ M_ r_
rn m m
M M O M M m
N M uJ N M rn M N M C N M N e- N Q N O M M O M M M N m
N O O
O
❑
M
M
O N N O M M N V
N N N
Q
fA
Eq
o O O O O O O
O O O M O O O o O M o 0 0 o p O O O O O O O O o 0 0 0
0 0 0
o M Q O O Q m
M M m M N M M M o (D M V M M (O Q l0 m m m M rn r
m N I
Q Q
<o t0 0 0
M o m 5 'o m m
v a � cd ai co v c6 v w � c6 � m N of v,"
m
d3
di
o a o o o 0
0 0 o e a e a e e e e a a o 0 0 o e e e a e e e
o 0 0
�
O c0 O t0 1h
O N n O M h CJ
M M O M n t0 n t0 M m r C^ N M t0 OJ M M M Q Q M n O m O
N M m
rn
o o N cu ui �+i v�
�6 n co o vi v n o ui �6 ` v n N o �6 o v �fi ci a o co �v o o
vi ri n
J
a
o
`o
o a ca m of o o
� N� c m n v m a o m v co r. m m m n w c m co m co o N o
R co N
a
0 0 o M o Q
M n M m N r M
M M M O O (O M h M o N o^ M M V m m t0 W I0 t0 M rn 0
n M M O 10 Q M V M M N ti N (O N M O n M M N c0 N M M O)
N n
O n V
t0
N
m
ri of of ai ui ai ro
cv Ni r vi r co Sri of 10, of o ai
o
r ,
' M n M n n N
m N V N N t M N t "I V O
M M n M n M M V V
N
OI O l(J Q Q
c0 N M h O N r (O V N m YJ N M M M d' M M M V c0 t0 M
(O OJ W
rn
V (0 r m (D (O
O Q •- �0 m Q rn O N � M M e- V Q O^ M M h r Q M M
(O t0 O
(p
J'
N
to V
V
0 0 0 0 0 0 O
O O O LO O O O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O
l0 l(Y �
M o M c0 0 o rn
1 n q
t0 M m O V V M M N M O M n o n t0 t0 M O o Vl M n o d' O m
N M M N O (O O O O O m h Q Q (O M N (O N 0) M l0
N n n
ry
m
n Q n n C 10
N (O i0 m N
Cp r V M O M
n N O N M N V Q n M m V M M O) M
M Y Q
a
O
N V
N
m
�
lA
N
N
N G
N i
N
G R •J
m E
R
O U
Q
✓� N R y N C C C O N C R O N G N
E G O
O Y LL N T j p N N
O R O
C M O N N a J N T C rn C N
E p m m c ,R
'R
y .- a� ° o°
i R R d � c 0 LL c U
9
m m
m y o m x5 E ! m atl Yn a`r c Q J m c u R d Zm R rn m `m
C
K m N> R C V N N� K C¢
c
LL
C 1 V1 C p� ( x w m m
N R R W
N
R U L J p O E O C C C J O N N O O
F J- U LL C: R a Q U u. d G J U U LL S W 6 Q ii W N [0 U) d LL d K LL U ry -p
m O
H
K W L Z Z
O
O
ti
n
e°e°000
eoavoeo
o e
�
M M O N N O
N V O 01 M
V N M M V T
N h N N (D M A
rn
N
N O
M O
O
0
N OJ W M CO
O h h O> M N
O
O O
O
M OJ O V 6J M
O O M h O
O
O O
O
rn M N M N
M M
rn
O O
O
U
V t0 N N N N
N V M O (O
O
N N
M
O
�
M
O
O rn N O O
O rn N O M N rn
0
O O
O
N N N M N M
M h OJ N (p rn N
M
O O
O
N (O N h M OJ
M M 6J Of N C' N
f�
M N
N
V
N N N
N
N
M
0 0 0 0 0 0
0 0 0 0 0 0 0
0
O O
O
0 0 0 0 0 0
0 0 0 0 0 0 0
0
O O
O
O V O V C O
N O OJ N N M
N
O O
O
�-
a
m
va
»
0 0 0 o e o
0 0 0 0 0 0
0
0 0
M r O> t0 N
O h V t0 h OJ V
M
6J O
d
'
O
0
W h N� m tp
r
N
h
M h rn (O N N
O O N O N M rn
M
N N
O
N t0 V V h N
O V M .- M V h
O)
O V
V
V N
01 N rn
(D M M N V OJ N
V
N
V
�
In co M m co
V c0
O M M N M rn m
N,
M
I� m
@
IV
O
�
�
O
N
O (O OJ W rn f0
OJ N N M N � N
W
M
N
M N O M V C
rn O> h 0
(O
h h
O
h h (p N N c'
rn O (O O O V N
M 0
OJ
OJ N
h
of N o o co
v N a m vi w Sri
m
v v
m
v
K
V3
0 0 0 0 0 0
0 0 0 0 0 0 0
0
O N
N
0 0 0 0 0 0
0 O N O O O O
N
�U N
rn
N V O O O
O 'C+ O N W rn M
M
OJ
N
h N N (O N N
E N N N 01 h W
C
[9 O
N
n
r
N
m
M
M
N
N
_N
@
C G r
N @ N N
N
N
N
N N p
'
N N
N C N
x X
C
@ C C N C@ C C C p
Y Y
N W N N @
O
U
N F N F N 9 C
K W l Z Z
0000e >o
eooa000
0 0
0)
M V (D (SJ M M
N V O N (p M V
V V O
W i0
d
O
0
OJ M N M O V
O O
M 47 l0 F
N C J t0 W W 6J
M �. m O M N 40 M
O W O
f0 F t0
47
N
V F
F F t0 M
N 6J OJ V O N (p
�O N m
F
V F F O M OJ
N N O W M OJ W
N O
W
C
T
O
U!
M
O
� Cl li O N
O �@ O M � M
W N F F M O
(O � fO O F N F
F _ O
O Lp
(O
o
F M h M N W
N (p r N t0 M
M T
O
M M N N F fO
(O (O O N F 10
M N
M
M
to
0 0 0 0 0 0
0 0 0 0 0 0 0
0 O O
O
O 0 0 0 0 0
0 O C N M O
OJ M O
W
o of v c co ui
10 (O
to C h N
V N
(O M
M1
O)
N O
(O V F (D tD N
O W
M �O M (O (O N N
(O M
N
a
J
N N � e-
01 N N N �
OI ✓
m
0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0
N
Of
M1 � N l0 t0 t0
O O O m F M N
O 01 O
O
0
M O> O V m
O O (O m W m M
O O O
m
F N OJ h F
M N M V O N (D
h V O
V
0
tD V O M (O O
M M W M t0_ F M
N �[l t0
O
U
W F O [t M
V N M O N Q7
t0 10
f0
O
yi
fp
O
N m N M N M
OJ F V (p M h
M O
Y
6J m N N F t0
(O N O_ N F V
M
t0
M
�O
EA
4A
O O O O O O
O O �O O t0 O O
O O O
O
0 0 0 0
0 M1 O N M 1
O O O
O
0 0
t0 N M 0
O t0 (O �- M O
h O _
F
Q7
m N
O M N
M m
F N M
O
m
N
m n
OJ r' M V (O F
N N
N 6 M N O � 0
0 h M
m
M
pI
V M (O t0 (O N
O F t0 F (O N V
N N
N
✓
67
M
fA
N
N
N
N � �
N y-
@ @ N C N
m J E
3 0¢
N
@
N O O O Ct @ W
A
N
"'i N N in C7 w m a w N CD w m a
G
y
J O C p J J
d 0 N N
C
0 x N N N
W
K w K Z Z