Information #1 04-20-2020Information
City of
Elk1O;Mftftft---
River
To: Mayor and City Council
From: Lori Ziemer, Finance Director
Date: April 20, 2020
Subject: March 2020 Monthly Financial Report
Memorandum
Tbis report is designed to provide summary information regarding the overall level of revenues and
expenditures in the General Fund, the Ice Arena Special Revenue Fund, and the Enterprise Funds.
These funds provide an important picture of the city's financial health.
For the month of March, actual revenues (excluding property taxes and transfers in) and
expenditures should run 25% of the annual budget. It is natural for some of the items to vary from
month -to -month, such as exceeding budget for Supplies but being below budget for Services. This is
not considered serious as long as the total expenditure budget amount is not overspent. Significant
variances from budget are highlighted below accompanied with a general discussion for the variance.
GENERAL FUND
Revenues:
■ Property taxes, our largest revenue source, will be received in July and December.
■ Overall, license & permit collections are about 13% of budget estimates, with building -
related permit collections about $18,000 over last year's collections at this time.
■ Charges for services are about 9% of budget. Police and fire service contracts were billed in
early April.
■ Transfers in consists of ERMU's 4% February electric revenues, the remaining transfers in
from other funds will be recorded mid -year.
Expenditures:
■ Total departmental expenditures are about 20% of budget and most departments are within
or below budget estimates.
■ Second quarter workers comp and property/liability insurance premiums are reflected in
many department's expenditures for March.
2020 Monthly Expenditures
$14,000
z $12,000
a
j $10,000
O
$8,000
• 111
Vm
111
$0
Jan Feb Mar Apr May Jun Jul
Actual $959 $2,202 $3,450
Budget $1,418 1 $2,837 $4,255 $5,673 $7,092 $8,510 $9,928 $1
ICE ARENA
Aug I Sep I Oct I Nov I Dec
$12,765I $14,183I $15,601I $17
Through the end of March, expenditures of $146,088 exceed revenues of $116,688 by $29,400. Due
to the cancellation of the spring hockey and skating programs, registration fee refunds were issued in
March.
ATTACHMENTS
■ General Fund Revenue & Expense Report
■ Enterprise Funds — Budget to Actual
■ Cash Report — All Funds
4-14-2020 12:42 PM CITY OF ELK RIVER PAGE: 1
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2020
101-GENERAL FUND
FINANCIAL SUMMARY 25.00o OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
REVENUE SUMMARY
General Fund 17,019,600.00 186,248.59 386,331.33 2.27 16,633,268.67 607,857.20
TOTAL REVENUES 17,019,600.00 186,248.59 386,331.33 2.27 16,633,268.67 607,857.20
EXPENDITURE SUMMARY
General Government
Mayor & Council
163,050.00
18,151.18
42,061.31
25.80
120,988.69
35,780.51
Communications
328,950.00
20f300.22
54,818.63
16.66
274,131.37
45,118.32
Administrative Services
568,850.00
42,770.87
117,945.47
20.73
450,904.53
108,569.34
Human Resources
305,800.00
34,535.52
63,181.49
20.66
242,618.51
62,062.20
Elections
83,200.00
18,211.00
32,456.96
39.01
50,743.04
6,300.00
Finance
648,700.00
41,276.18
125,893.07
19.41
522,806.93
134,976.71
Information Technology
556,300.00
46,589.83
95,368.55
17.14
460,931.45
98,177.79
Legal
240,000.00
20f856.77
43,888.56
18.29
196,111.44
34,052.93
Community Development
206,650.00
13,379.96
70f858.26
34.29
135,791.74
33,671.19
Planning
352,350.00
26,558.30
71,379.83
20.26
280,970.17
68,605.41
Building Maintenance
767,750.00
62,652.96
162,680.55
21.19
605,069.45
152,235.03
TOTAL General Government
4,221,600.00
345,282.79
880f532.68
20.86
3,341,067.32
779,549.43
Public Safety
Police Administration
893,700.00
91,054.62
265,800.09
29.74
627,899.91
249,638.55
Patrol
3,076,800.00
187,693.50
570f886.59
18.55
2,505,913.41
528,975.44
Investigations
1,226,800.00
69,848.38
189,541.08
15.45
1,037,258.92
210,283.72
Police Support Services
801,800.00
52,966.67
139,998.67
17.46
661,801.33
152,561.11
Police Reserves
18,050.00
0.00
348.08
1.93
17,701.92
496.94
Public safety building
169,600.00
15,825.88
35,000.84
20.64
134,599.16
36,044.60
Fire Administration
966,800.00
49,843.87
129,210.98
13.36
837,589.02
160,968.12
Fire Operations
410,700.00
50,811.01
100,431.29
24.45
310,268.71
104,563.11
Emergency Management
21,100.00
707.49
1,436.31
6.81
19,663.69
1,794.34
Building Safety
527,550.00
39,446.02
112,491.70
21.32
415,058.30
110,437.37
Code Enforcement
99,450.00
5,958.79
17,163.54
17.26
82,286.46
21,035.26
Environmental
53,150.00
4,189.95
10,946.52
20.60
42,203.48
6,255.37
TOTAL Public Safety
8,265,500.00
568,346.18
1,573,255.69
19.03
6,692,244.31
1,583,053.93
Public Works
Street Maintenance
1,386,700.00
105,878.02
242,917.24
17.52
1,143,782.76
192,079.75
Snow Removal
305,900.00
22,373.51
173,978.40
56.87
131,921.60
220,568.90
Equipment Services
231,200.00
18,089.31
42,752.37
18.49
188,447.63
54,857.53
Engineering
385,500.00
30,137.57
78,947.06
20.48
306,552.94
51,620.61
TOTAL Public Works
2,309,300.00
176,478.41
538,595.07
23.32
1,770,704.93
519,126.79
4-14-2020 12:42 PM CITY OF ELK RIVER PAGE: 2
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2020
101-GENERAL FUND
FINANCIAL SUMMARY
Culture & Recreation
Parks Department
Parks & Rec Admin
Recreation Programs
Farmers Market
Sr Citizen Programs
TOTAL Culture & Recreation
Economic Development
Economic Development
Energy City
TOTAL Economic Development
General
TOTAL EXPENDITURES
25.00o OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
1,272,700.00
86,666.41
215,074.66
16.90
1,057,625.34
196,889.48
592,000.00
46,631.30
153,128.27
25.87
438,871.73
141,821.48
129,100.00
3,203.39
15,069.54
11.67
114,030.46
16,739.86
0.00
22.63
79.19
0.00
( 79.19)
175.86
201,850.00
19,049.41
42,266.47
20.94
159,583.53
32,218.61
2,195,650.00
155,573.14
425,618.13
19.38
1,770,031.87
387,845.29
0.00
1,202.91
27,735.93
0.00
( 27,735.93)
25,226.87
27,550.00
1,600.74
4,296.06
15.59
23,253.94
5,577.12
27,550.00
2,803.65
32,031.99
116.27
( 4,481.99)
30f8O3.99
17,019,600.00 1,248,484.17 3,450,033.56 20.27 13f 569f 566. 44 3,300,379.43
REVENUES OVER/(UNDER) EXPENDITURES 0.00 ( 1,062,235.58)( 3,063,702.23) 3,063,702.23 ( 2,692,522.23)
4-14-2020 12:42 PM CITY OF ELK RIVER PAGE: 3
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2020
101-GENERAL FUND
25.00o OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
REVENUES BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
General Fund
Taxes
101-3-0000-3111
Current Ad Valorem Taxes
11,938,300.00
0.00
0.00
0.00
11,938,300.00
0.00
101-3-0000-3121
Gravel Tax
140,000.00
0.00
0.00
0.00
140,000.00
0.00
TOTAL Taxes
12,078,300.00
0.00
0.00
0.00
12,078,300.00
0.00
Licenses &
Permits
101-3-0000-3211
Liquor License
76,000.00
0.00
155.00
0.20
75,845.00
1,519.20
101-3-0000-3213
Cigarette License
3,000.00
0.00
0.00
0.00
3,000.00
0.00
101-3-0000-3214
Rental License
65,000.00
8,920.00
25,248.00
38.84
39,752.00
27,111.00
101-3-0000-3216
Mining License
25,000.00
0.00
0.00
0.00
25,000.00
0.00
101-3-0000-3217
Garbage Hauler License
2,000.00
0.00
360.00
18.00
1,640.00
120.00
101-3-0000-3218
Other Business License/Permit
12,000.00
270.00
3,160.00
26.33
8,840.00
2,770.00
101-3-0000-3229
NPDES Permit
20,000.00
1,778.25
3,178.25
15.89
16,821.75
2,625.00
101-3-0000-3231
Building Permit
475,000.00
22,358.05
51,416.15
10.82
423,583.85
39,138.50
101-3-0000-3232
Plumbing/Heating Permit
110,000.00
6,385.87
14,436.99
13.12
95,563.01
8,519.14
101-3-0000-3233
Permit Surcharge
500.00
471.58
1,342.05
268.41
( 842.05)
933.79
101-3-0000-3235
Animal License
0.00
0.00
315.00
0.00
( 315.00)
400.00
101-3-0000-3237
Other Non -Business Lic/Permit
10,000.00
1,110.00
3,130.00
31.30
6,870.00
2,040.00
TOTAL Licenses
& Permits
798,500.00
41,293.75
102,741.44
12.87
695,758.56
85f176.63
Intergovernmental
Rev
101-3-0000-3322
MV Credit
5,500.00
0.00
0.00
0.00
5,500.00
0.00
101-3-0000-3323
Fire State Aid
200,000.00
1,000.00
1,000.00
0.50
199,000.00
2,000.00
101-3-0000-3325
Police 20 Aid
295,000.00
0.00
0.00
0.00
295,000.00
0.00
101-3-0000-3326
Police Training Reimb
30,000.00
0.00
0.00
0.00
30,000.00
0.00
101-3-0000-3329
State Crime Prevention Grant
60,000.00
0.00
0.00
0.00
60,000.00
0.00
101-3-0000-3330
Other State Grants
21,000.00
0.00
0.00
0.00
21,000.00
0.00
TOTAL Intergovernmental
Rev
611,500.00
1,000.00
1,000.00
0.16
610,500.00
2,000.00
Charges for
Services
101-3-0000-3412
Planning & Zoning Fees
30,000.00
2,700.00
6,135.00
20.45
23,865.00
2,637.50
101-3-0000-3413
Plan Check Fee
215,000.00
10,454.63
23,540.85
10.95
191,459.15
21,484.41
101-3-0000-3415
Special Assessment Search
500.00
150.00
210.00
42.00
290.00
80.00
101-3-0000-3417
Copies
3,000.00
105.38
351.73
11.72
2,648.27
566.33
101-3-0000-3418
Other General Govt Services
1,500.00
0.00
0.00
0.00
1,500.00
13.00
101-3-0000-3430
Lockout Fees
5f500.00
260.00
1,220.00
22.18
4,280.00
1,540.00
101-3-0000-3431
Police Services
15,000.00
10.00
1,518.00
10.12
13,482.00
941.25
101-3-0000-3432
School Liaison
149,000.00
0.00
0.00
0.00
149,000.00
68,272.50
101-3-0000-3434
Animal Impound Fee
4,000.00
50.00
350.00
8.75
3,650.00
300.00
101-3-0000-3436
Fire Contracts
277,000.00
0.00
0.00
0.00
277,000.00
149,282.00
101-3-0000-3437
Fire Services
2,000.00
6,137.50
6,137.50
306.88
( 4,137.50)
10.00
101-3-0000-3451
Street Services
18,000.00
1,290.00
3,835.00
21.31
14,165.00
1,235.00
101-3-0000-3452
Engineering Services Reimb
75,000.00
5,802.23
5f802.23
7.74
69,197.77
1,233.61
101-3-0000-3461
Recreation Fees
80,000.00
5,042.50
6,477.50
8.10
73,522.50
25,296.90
101-3-0000-3462
Sr Center Activities
40,000.00 (
1,193.00)
9,963.00
24.91
30,037.00
11,493.01
4-14-2020 12:42 PM CITY OF ELK RIVER PAGE: 4
REVENUE & EXPENSE REPORT (UNAUDITED)
AS OF: MARCH 31ST, 2020
101-GENERAL FUND
REVENUES
101-3-0000-3463 Farmer's Market
101-3-0000-3469 Other Sales - RiverFest
101-3-0000-3472 Park Use Fee
101-3-0000-3475 Building Rent
101-3-0000-3483 Sewer Inspection Fee
101-3-0000-3484 Contractor License Check
TOTAL Charges for Services
Fines & Forfeits
101-3-0000-3510 Court Fines
101-3-0000-3511 Parking Fines
TOTAL Fines & Forfeits
Special Assessments
Other Revenue
101-3-0000-3621 Interest Income
101-3-0000-3625 Refunds & Reimbursements
101-3-0000-3626 Contributions
101-3-0000-3629 Miscellaneous Revenue
TOTAL Other Revenue
Transfers In
101-3-0000-3921 Transfers
101-3-0000-3930 Transfer -Development
101-3-0000-3942 Transfer-WWTS
101-3-0000-3943 Transfer -Liquor
101-3-0000-3944 Transfer -Garbage
101-3-0000-3945 Transfer -Utilities
101-3-0000-3946 Transfer-Stormwater
101-3-0000-3948 Transfer-EDA
101-3-0000-3949 Transfer-HRA
TOTAL Transfers In
25.00o OF YEAR COMPLETED
CURRENT CURRENT YEAR TO DATE o OF BUDGET PRIOR FY
BUDGET PERIOD ACTUAL BUDGET BALANCE YTD BALANCE
0.00
3,320.00
0.00
500.00
20,000.00
1,436.25
0.00
0.00
11,000.00
975.00
1,000.00
60.00
947,500.00
37,100.49
135,000.00 10,697.56
5,000.00 0.00
140,000.00 10,697.56
8,160.00
0.00 (
8,160.00)
5,239.00
1,000.00
0.00 (
1,000.00)
0.00
6,401.25
32.01
13,598.75
7,705.00
0.00
0.00
0.00
600.00
1,625.00
14.77
9,375.00
715.00
100.00
10.00
900.00
150.00
82,827.06
8.74
864,672.94
298,794.51
20,005.25 14.82 114,994.75 22,290.71
150.00 3.00 4,850.00 1,260.00
20,155.25 14.40 119,844.75 23,550.71
115,000.00
0.00
0.00
0.00
115,000.00
35,330.70
130,000.00 (
3,453.19)(
3,453.19)
2.66-
133,453.19 (
12.62)
25,000.00
0.00
0.00
0.00
25,000.00
1,000.00
6f500.00 (
514.52)
460.36
7.08
6,039.64
697.63
276,500.00 (
3,967.71)(
2,992.83)
1.08-
279,492.83
37,015.71
0.00
0.00
0.00
0.00
0.00
112.31
10,600.00
0.00
0.00
0.00
10,600.00
0.00
155,000.00
0.00
0.00
0.00
155,000.00
0.00
500,000.00
0.00
0.00
0.00
500,000.00
0.00
50,000.00
0.00
0.00
0.00
50,000.00
0.00
1,364,000.00
100,124.50
182,600.41
13.39
1,181,399.59
161,207.33
15,500.00
0.00
0.00
0.00
15,500.00
0.00
39,500.00
0.00
0.00
0.00
39,500.00
0.00
32,700.00
0.00
0.00
0.00
32,700.00
0.00
2,167,300.00
100f124.50
182,600.41
8.43
1,984,699.59
161,319.64
TOTAL General Fund 17,019,600.00 186,248.59 386,331.33 2.27 16,633,268.67 607,857.20
TOTAL REVENUE 17,019,600.00 186,248.59 386,331.33 2.27 16,633,268.67 607,857.20
Q
D
F
U
Qo
0 N
N
Q
J m �
W Q
LL
000
� W
~ LL =
U W Z
0
a
w
w
F
Z
W
0 0 0
0 0
0
0 0 0
0
w
O o
v
c•) o Ll) o
v ch o cl)o
L m
L() m
O
O
o v o
O O o
v
m
c
o
0 o o - o
N N
o
O M o
fV
m
N
i..
CO
CO O N
N f0
f0
f0
f0
(O
(O O V
V N
N
N
N
v+
r
w
N
N O Ln
Ln r
r
r
r
R
N
N N O
N c)
cl)
cl)
cl)
co
w 0
0
69
O "
O O O O O
O O
O
O O ' O
O
O
C y
O
O
O O O O O
O V M d) O
O O
O f0
O
O
O O O
O cc LO
O
O
" 'O
N W
M
M W
O
7 7
LO
d)
LO V V
V
O_ V
N
O
N
69
0 o
0 0 o o
o 0
o
o o o
o
G!
0 m
O O
o O
CO LO V
V N O CO
LO
CO N
O
O
O N O
O m O
M
N
c
o O
o N r
L(i co
O N O
N
m
N
N
N
M
W O
'
'
G1,
d) O O
N
(M 00
(D N
00
N
00
N
00
N
y
V
cl)d)
V c0 — V
N N
cl)
N
cl)
N
M
N
M
;...
w p
N
N N
N
Efl
O O '
O O O O '
O O
O '
O O -a
O
O
C y
O O
O O
O LO O O
O co V V
LP 10
00
O
O
O 10 O
O 00 O
10
00
10
00
_
M N
M N d) co
M
_
V
7 7
(O
(O V
cl)
LO
69
0 o L
o o 0 0 o
o 0
o o
0 0 0 o
o
G!
O) O Lo
I- O Ln
co oO
� co d) o O
O M
V r
O co
O V
N O
o I� O O
f0
N
o
o N ri
c6 Ln o o
0 0
o c6
o r v o
m
N N
N
(O
LOO I—N
OO r
co W
O
O m Ln
V
O f0
co Ln
Ln V LO LO
LO m
O
O m O
f0
O M
r
M N
V CO
II- V N
N (O LO V
CO 00
LO f0
M
O
co 10 O
O f0 V
cc
O
O M
O m
N D
}
I-N
Oo M M M
O m
N
N I- (D
V N
i%s
Efl
O O O
O O O O O
O O
O O
O O O O
O
o O
a+ y.
c y
O O O
o LO o
O O O O O
LO I— o N o
O O
O) a
O O
O M
O O O O
M r o o
O
r
O O
o r
O o
o m- o
m M
o o
O) N o L()
r
o r
M N
N
LO N N (O V
M I— N (DO
LO O
N
LO M
N
CO m O Ln
O
V
M r
V N
Um
N
N
M
....
.�
Efl
0 o
"o0
000o0
0
o
o 0 o
0
p—.
G!
O7
I- coI
cocoN
o
cocoN N
N O) O
N N I- O d) O
N
d) R
O
O
O O
O f0 O
f 0
O
c
M I--
W N
N V (O O
CO 00
O
O M O
m
N
co
N M
f 0
co
N
(O M
co O
O LO N O'
r f0
f0
f0
f0
0
I� O)
W O
O cod) N
V cl)
cl)
cl)M
y,
� c0
_
N (O
(O M LO
_ _
O 00
00
00
00
`
R R
M o
N
G (DV
V 00
00
00
00
w p
O
c0
N 10
10
10
10
�
J
69
O So
..o
o o o o o
o o
o'
o o -a
o
o
y� y.
y
O O
O O
O O
O_ O)
O LO O O O
O) O N O O
LO 10
N fR
O
O
O 10 O
O cc O
10
cc
10
cc
O
V
V N CO CO co
V
O
O V O
V
V
7
V CO
V N
(O
O (O N
O) N
10
M 00
(O
CO O
m r
N
N
U m
r Ln
N
Efl
_
N
N
N
�
C
�
N
Q
R
�
N
�
N N
n
G! N
O
7
R
r
VI
W
w o
O O
_
X C
V O
C
O
U
OD
N
U
R
� 1/1 N x
O
7 m
`!
N
N
R
m
_
O
C
7 N
O
m C N (L6 m
G! .0 U
N
N (p
N t/1 N
O
U
0
.J...
N
U N
d U
Q y w U 0 Q
c
C U
O
L
C
^2
.� E
Q
N
O 'm to N O
O)
X
R '� N C
:0..
.O 0
0
O
D
'R U
.�
N w U (6
'R .Q
s
'R
G! f/1 f/1 (6
N
o
d
R O
y o 00 i�
u
'N L~
y0
N O y0
G! N Q L ( F
N
2 N N y0
c N N F
0
C
Z
_0
O
NFU
N ((1)
0�00
La_U) 0
O
o
F
z
aim
z°
4-14-2020 03:24 PM CITY OF ELK RIVER PAGE: 1
POOLED CASH REPORT (FUND 999)
AS OF: MARCH 31ST, 2020
FUND ACCOUNT# ACCOUNT NAME
002-1010 Cash - Section 125
101-1010 Cash - General Fund
211-1010 Cash - Library
221-1010 Cash - Ice Arena
225-1010 Cash - Park Dedication
228-1010 Cash - Landfill
231-1010 Cash - Landfill Const Debris
240-1010 Cash - Micro Loan Fund
242-1010 Cash - State DEED
245-1010 Cash - Development Fund
290-1010 Cash - Capital Outlay Reserve
291-1010 Cash - Insurance Reserve
292-1010 Cash - Govt B1dgs Reserve
294-1010 Cash - Drug Forfeiture
295-1010 Cash - Severance Pay Reserve
296-1010 Cash - GRE Reserve
333-1010 Cash - 2010A GO Cap Imp Bonds
343-1010 Cash - 2019A Sales Tax Bonds
401-1010 Cash - Pavement Mgmt
403-1010 Cash - Street Improvement
406-1010 Cash - City Wide Trunk Util
410-1010 Cash - Equipment Replacement
420-1010 Cash - Active ER
440-1010 Cash - Park Improvement
463-1010 Cash - TIF 023 Pref Powder
602-1010 Cash - Wastewater Treatment
603-1010 Cash - Liquor
605-1010 Cash - Garbage
607-1010 Cash - Storm Water
801-1010 Cash - Interest
821-1010 Cash - Developer Escrow
TOTAL CLAIM ON CASH
BEGINNING
BALANCE
CURRENT CURRENT
ACTIVITY BALANCE
3,979.37
2,618.64
6,598.01
5,476,036.33 (
868,591.24)
4,607,445.09
424,630.80 (
9,176.08)
415,454.72
618,390.40 (
74,892.96)
543,497.44
434,423.22
64,166.85
498,590.07
207,871.14 (
566.75)
207,304.39
783,747.49
0.00
783,747.49
880,055.57
2,457.11
882,512.68
113,368.57
4,149.90
117,518.47
877,884.06
0.00
877,884.06
1,208,587.52
31,450.86
1,240,038.38
93,085.30 (
4,474.13)
88,611.17
2,302,331.72
211,328.85
2,513,660.57
39,824.14
3,194.38
43,018.52
76,572.32
0.00
76,572.32
2,080,030.30
0.00
2, 080, 030. 30
411,168.20
0.00
411,168.20
632,978.85
210,836.17
843,815.02
4,542,126.63 (
54,507.55)
4,487,619.08
792,202.74 (
18,958.40)
773,244.34
4,307,999.98
25,037.89
4,333,037.87
457,860.71 (
230,055.37)
227,805.34
21,682,162.24 (
2,231,413.99)
19,450,748.25
142,467.22 (
3,300.00)
139,167.22
4,552.54
0.00
4,552.54
4,913,655.54
102,330.75
5,015,986.29
4,627,832.25
188,184.70
4,816,016.95
371,471.02
24,620.04
396,091.06
799,617.76
35,289.88
834,907.64
183,994.98
35,888.92
219,883.90
693,047.22
107,982.00
801,029.22
60,183,956.13 (
2,446,399.53)
57,737,556.60