Transcript Bartlett Fire Protection District

Fox River and Countryside Fire/Rescue District
Financial Analysis
For the 2 Month(s) Ended June 30, 2014
Revenue Highlights
17% of Budget Year
• 38% of Total Budget
• Property Taxes
– Collected 49% of Budgeted Property Taxes (1st Installment from
Kane and DuPage County)
• Ambulance Fees
– Collected $40,007 or 13% of Budget
• Rental Revenues
– Collected $4,113 or 18% of Budget
2
Revenues
Account Description
Total Actual
Total Budget
% of
Budget
Inc/(Dec)
from Last
Year
Last Year
Property Taxes
1,153,360
2,351,500
49%
1,117,997
3%
Interest Income
115
3,000
4%
485
-76%
Personal Property Replacement Tax
2,515
11,000
23%
2,914
-14%
Rental Income
4,113
22,300
18%
4,023
2%
40,007
297,300
13%
40,499
-1%
Fire Recovery
-
7,500
0%
-
n/a
Other Income
-
25,100
0%
925
-100%
1,200,109
2,717,700
44%
1,166,843
3%
-
430,000
n/a
-
n/a
355,837
970,538
37%
349,413
n/a
Actual Revenues
1,555,947
4,118,238
38%
1,516,256
3%
Budgeted Revenues
4,118,238
% Diff
38%
Ambulance/CPR Fees
Subtotal
Debt Proceeds/Sale of Building
Transfers-In
3
Revenues
Year-to-Date - Jun
Rental Income
0,3%
Interest Income
Ambulance/CPR
0,0%
Fees
Personal Property
3,3%
Replacement Tax
0,2%
Property Taxes
96,1%
4
PBS Collections
Month
FY2015
FY2014
May
20,986
20,424
Jun
18,661
20,074
Jul
21,271
Aug
14,834
Sept
28,937
Oct
32,058
Nov
26,924
Dec
28,223
Jan
29,756
Feb
29,630
Mar
21,083
April
27,097
Total
300,312
Collections
35 000
30 000
25 000
20 000
FY2015
15 000
FY2014
10 000
5 000
May Jun Jul Aug Sept Oct Nov Dec Jan Feb Mar April
AVG.
19,823
25,026
Budget
Avg.
24,583
23,333
5
Expenditure Highlights
17% of Budget Year
• 21% of Total Budget
• Operating Expenditures
– 22% of Budget
• Fire Services Contract
– 16% of Budget
• Capital Outlay & Debt Service
– 13% of Budget
–
–
George Kay & Assoc $23,780
Alexis Fire Equipment $30,981
6
Expenditures
Account Description
Total Actual
Total Budget
% of
Budget
Inc/(Dec)
from Last
Total Actual
Year
OPERATING EXPENDITURES
Personnel
57,520
364,000
16%
57,115
1%
280,235
1,790,883
16%
264,319
6%
3,214
9,800
33%
4,564
-30%
10,274
13,950
74%
547
1778%
-
3,000
0%
167
-100%
25,155
176,750
14%
33,312
-24%
355,837
970,538
37%
349,413
2%
Actual Expenditures
732,235
3,328,921
22%
709,437
3%
Budgeted Expenditures
3,328,921
% Diff
22%
Contractual Services
Office Supplies and Expenses
Property Expenses
Public Training and Education
Fire Station
Transfers-Out
DEBT AND CAPITAL EXPENDITURES
Debt Expenditures
15,846
489,538
3%
9,929
60%
Capital Outlay
61,227
100,750
n/a
77,304
-21%
Actual Expenditures
77,073
590,288
13%
87,233
-12%
Budgeted Expenditures
384,538
% Diff
20%
Expenditures
Year-to-Date - Jun
Capital Outlay
13,5%
Personnel
12,7%
Debt Expenditures
3,5%
Fire Station
5,5%
Property Expenses
2,3%
Office Supplies and
Expenses
0,7%
Contractual Services
61,8%
8
Revenue, Expenditure & Fund Balance
For the 2 Month Ended June 30, 2014
General
Ambulance
Emergency and
Rescue
Debt Service
Total Actual
TOTAL SURPLUS /
(DEFICIT)
823,712
-
(77,073)
-
746,639
BEGINNING FUND
BALANCE
238,287
-
-
-
238,287
-
-
-
-
-
1,061,999
-
(77,073)
-
984,926
Residual Equity Transfer
ENDING FUND BALANCE
1 400 000
1 400 000
1 200 000
1 200 000
1 000 000
1 000 000
800 000
800 000
600 000
600 000
400 000
400 000
200 000
200 000
-
FY2013
Revenues
FY2014
Expenditures
FY2015
FY2013
Revenues
FY2014
FY2015
Expenditures
9
Investments
Bank
Description
Current Rate
Bank Balance
BMO Harris
Public Funds Checking #4887
BMO Harris
Business Prime Money Market #7301
0.35%
912,917
BMO Harris
Public Funds Interest Checking #0403
0.16%
7,502
Suburban Bank & Trust
Checking #9767
n/a
49,607
n/a
$
98,591
1,068,617
BMO Harris Public Funds
Checking #4887 n/a
BMO Harris Business Prime
Money Market #7301 0.35%
BMO Harris Public Funds
Interest Checking #0403
0.16%
Suburban Bank & Trust
Checking #9767 n/a
10