December 31, 2012 AWS
INVESTMENT REPORT On December 31st, the Town’s funds were in the Florida Local Government Surplus Trust Funds Investment Pool (Florida Prime and Fund B) and SunTrust, with the majority at SunTrust. As of the date of this memorandum, SunTrust continues to participate in the Qualified Public Depository (QPD) program where Town funds are guaranteed 100% above the $250k insured by the FDIC. Additionally, SunTrust possesses a three and a half-star rating from BauerFinancial which indicates the bank is in good financial condition. OTHER FUNDS This report does not incorporate some of the Town’s smaller special revenue and internal service funds. These funds include the Police Education, Police Forfeiture, Grants, and Insurance. If you would like a review of these funds, please contact me at (561) 540-5035. STATE BOARD OF ADMINISTRATION LOCAL GOVERNMENT SURPLUS TRUST FUNDS INVESTMENT POOL As of December 31st, $230,807 was in the Florida Prime account which is liquid and available for withdrawal. In Fund B, the Town’s balance was $185,450 which is not liquid nor is it available for withdrawal. While the total unrealized loss is $3,147 for all accounts, nothing has been realized (sold for a loss). This loss has actually decreased by almost $7,000 from the beginning of the fiscal year. If you have any questions, please do not hesitate to contact me.
-2-
BUDGET-IN-BRIEF as of December 31, 2012 (25% of year elapsed) YTD-Townwide Expense Allocation
Other Town Funds
Interfund Transfers, ‐ , 0%
Debt Capital $316,812 9% $351,701 10%
Wages $1,114,901
Budget 4,996,244 1,408,547 6,404,791 6,404,791
Year-to-Date 927,100 927,100 1,097,977
% 18.6% 0.0% 14.5% 17.1%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 2,761 1,839 4,600 4,600
Year-to-Date 862 862 214
% 31.2% 0.0% 18.7% 4.7%
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 8 1,261
% 0.0% 0.0%
Grants Fund *Revenues Appropriations & Carryover Total Revenues Total Expenses
Year-to-Date 1,410,234 1,410,234 13,441
% 422.7% N/A 422.7% 4.0%
Year-to-Date 88,859 88,859 185,179
% 22.3% N/A 22.3% 46.6%
32%
Operating & Maint. $1,015,782 30%
Benefits $639,957 19%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,376,125 1,849,863 Licenses & Permits 443,520 84,057 Intergovernmental Revenue 1,112,636 131,791 Charges for Services 1,602,398 353,952 Fines & Forfeitures 99,415 30,106 Misc. Revenue 653,873 138,796 Interfund Transfers Debt Proceeds Appropriations & Carryover 1,172,463 Total Revenues $ 9,460,430 $ 2,588,565
% 42.3% 19.0% 11.8% 22.1% 30.3% 21.2% 0.0% 0.0% 0.0% 27.4%
General Fund Expenditures Budget Year-to-Date 74,820 20,664 184,069 43,078 353,641 83,391 163,534 21,513 162,010 81,819 3,828,433 908,456
% 27.6% 23.4% 23.6% 13.2% 50.5% 23.7%
Expenditures Town Council Town Manager Finance Town Attorney Non-Departmental Police
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Development Services
605,680
139,873
23.1%
2,167,440 149,047
495,939 29,430
22.9% 19.7%
47,500
1,532
3.2%
Capital Outlay
1,294,106
177,513
13.7%
Debt Service Interfund Transfers Out General Contingency Total Expenditures
430,150 9,460,430
137,873 2,141,081
32.1% 0.0% 0.0% 22.6%
Operations Department Library Holiday Events
$
$
Budget 333,631 333,631 333,631
*(Revenues are a carryover of the PACE & 5-City Grant)
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Expenditures
YTD-Total Townwide Budget Budget Year-to-Date
Total Townwide Budget (not including Police Forfeiture Fund)
-3-
Budget 397,743 397,743 397,743
16,601,195
3,437,892
% 20.7%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) December 31, 2012 Prior Year
Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts Inventory Due from other funds Accrued revenues Other Total assets and other debits
$
$
Liabilities, Equity and Other Credits: Liabilities: Accounts payable Other liabilities Payable from restricted assets: Accrued wages payable Revenue refunding bonds Deferred revenue Total liabilities Fund balances: Assigned for Encumbrances Unassigned Total equity and other credits Total liabilities, equity and other credits
-4-
$
8,850,253 279,042 45,117 12,193 276,930 (13,677) 9,449,858
$
$
9,310,736 275,747 23,317 10,904 440,134 10,060,838
248,437 10,588
162,702 7,566
144,089 403,114
187,315 357,583
551,118 8,495,626 9,046,744 9,449,858
1,081,166 8,622,089 9,703,255 10,060,838
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended December 31, 2012
Revenues: Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeitures Miscellaneous Use of Fund Balance Total revenues Expenditures: Current: General government Public safety Development services Physical environment Culture and recreation Capital outlay Debt service: Principal & Interest General contingency Total expenditures Deficiency of revenues under expenditures Other financing sources: Sale of general fixed assets Operating transfers in Operating transfers out Use of Fund Balance-capital carryfwd Capital lease/Loan Proceeds Total other financing sources Deficiency of revenues and other financing sources under expenditures
Variance Favorable (Unfavorable)
Prior Year Actual
Budget
Actual
$ 4,376,125 443,520 1,112,636 1,602,398 99,415 647,873 99,670 8,381,637
$ 1,830,890 254,751 131,790 353,953 30,106 238,556 2,840,046
938,074 3,828,433 605,680 1,115,797 1,248,190 1,294,106
250,736 908,456 139,873 246,628 280,274 177,512
687,338 2,919,977 465,807 869,169 967,916 1,116,594
203,928 983,041 149,174 257,713 315,568 1,268,946
430,150 9,460,430
137,873 2,141,352
292,277 7,319,078
137,873 3,316,243
698,694
1,777,487
(1,078,793) 6,000 1,072,793 1,078,793
-
-
698,693 8,348,051 $ 9,046,744
Fund balance, beginning of year FUND BALANCE, END OF PERIOD
-5-
$ (2,545,235) (188,769) (980,846) (1,248,445) (69,309) (409,317) (5,441,921)
(6,000) (1,072,793) (1,078,793)
$ 1,870,944 226,323 134,015 356,044 51,334 181,707 2,820,367
(495,876) (495,871) 10,199,126 $ 9,703,255
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget
Actual
$ 2,120,000 666,158 999,853 325,605 264,509 4,376,125
$ 1,518,247 60,385 183,747 47,022 21,489 1,830,890
263,177 180,343 443,520
Intergovernmental revenues: Insurance Premium Tax-Police State revenue sharing Mobile home licenses Alcoholic beverage licenses Local government ½ cent sales tax Government grants Total intergovernmental revenues Charges for services: Sanitation and waste removal Recycling fees Public Safety Nature Preserve Maintenance Total charges for services
Taxes: Ad Valorem taxes Franchise taxes Utility service taxes Local Communications Services Tax Gasoline taxes Total taxes
Variance Favorable (Unfavorable) (601,753) (605,773) (816,106) (278,583) (243,020) (2,545,235)
$ 1,587,912 57,314 175,103 28,173 22,442 1,870,944
195,462 59,289 254,751
(67,715) (121,054) (188,769)
184,299 42,024 226,323
90,000 297,000 21,251 11,020 669,500 23,865 1,112,636
74,352 2,215 55,223 131,790
(90,000) (222,648) (19,036) (11,020) (614,277) (23,865) (980,846)
72,185 8,951 52,879 134,015
767,483 105,816 678,619 50,480 1,602,398
149,408 19,972 171,950 12,623 353,953
(618,075) (85,844) (506,669) (37,857) 1,248,445
149,649 20,200 173,856 12,339 356,044
99,415
30,106
(69,309)
51,334
Miscellaneous revenues: Interest Beach parking Contributions Leases Chancellor Academy Other Total miscellaneous revenues
11,080 119,736 478,397 38,660 647,873
4,477 30,984 172,478 7,986 22,631 238,556
(6,603) (88,752) (305,919) 7,986 (16,029) (409,317)
3,725 44,075 1,250 115,055 17,602 181,707
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Loan Proceeds Total other financing sources TOTAL REVENUES
6,000 1,072,793 99,670 1,178,463 $ 9,460,430
$ 2,840,046
(6,000) (1,072,793) (99,670) (1,178,463) $ (6,620,384)
$ 2,820,367
Licenses and permits: Business services taxes Building and other permits Total licenses and permits
Fines and forfeitures
-6-
$
Prior Year Actual
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget General government: Legislative: Personal services Operating Total Legislative
$
Actual
64,515 10,305 74,820
$
14,822 5,843 20,665
Variance Favorable (Unfavorable)
$
49,693 4,462 54,155
Prior Year Actual
$
20,641 5,330 25,971
Executive: Personal services Operating Capital Total Executive
102,290 12,789 3,850 118,929
23,945 2,729 3,851 30,525
78,345 10,060 (1) 88,404
29,114 4,070 33,184
Town Clerk: Personal services Operating Capital Total Town Clerk
45,925 23,065 68,990
11,283 5,391 16,674
34,642 17,674 52,316
12,747 2,301 15,048
Financial Administration: Personal services Operating Capital Total Financial Administration
239,480 114,161 41,760 395,401
54,096 29,295 1,851 85,242
185,384 84,866 39,909 310,159
53,870 38,594 4,559 97,023
Legal Counsel: Personal services Operating Total Legal Counsel
11,695 151,839 163,534
3,862 17,651 21,513
7,833 134,188 142,021
3,740 23,885 27,625
161,010 45,552 1,000 207,562 1,029,236
81,819 81,819 256,438
79,191 45,552 1,000 125,743 772,798
9,636 1,197,250 1,206,886 1,405,737
383,420 68,915 63,921 516,256
95,349 45,412 140,761
288,071 23,503 63,921 375,495
101,856 44,815 9,679 156,350
Non-Departmental Personal services Operating Capital Other Expenses Total Non-Departmental Total General Government Public Safety: Administration: Personal services Operating Capital Total Administration
-7-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
2,203,205 176,046 156,479 2,535,730
497,722 36,993 10,146 544,861
1,705,483 139,053 146,333 1,990,869
514,110 49,577 3,244 566,931
Services: Personal services Operating Capital Total Police Services
439,650 161,679 7,500 608,829
107,285 32,356 5,432 145,073
332,365 129,323 2,068 463,756
115,944 57,666 173,610
Uniform Patrol (Hypoluxo): Personal services Operating Capital Total Uniform Patrol (Hypoluxo)
374,265 21,253 2,950 398,468
88,942 4,397 93,339
285,323 16,856 2,950 305,129
95,821 3,252 1,617 100,690
4,059,283
924,034
3,135,249
997,581
172,260 15,259 2,538 190,057
42,015 3,380 1,173 46,568
130,245 11,879 1,365 143,489
43,902 4,710 48,612
Total Public Safety Development Services: Administration : Personal services Operating Capital Total Administration Building Inspections: Personal services Operating Capital Total Building Inspections Code Enforcement: Personal services Operating Capital Total Code Enforcement
121,150 109,067 12,000 242,217
28,820 23,914 52,734
92,330 85,153 12,000 189,483
31,359 26,153 6,212 63,724
169,195 18,749 187,944
39,507 2,237 41,744
129,688 16,512 146,200
40,873 2,177 43,050
Total Development Services
620,218
141,046
479,172
155,386
Physical Environment: Operations Administration Personal services Operating Capital Total Public Works Administration
119,625 13,928 133,553
28,850 3,277 32,127
90,775 10,651 101,426
30,922 2,608 1,237 34,767
64,160
15,368
48,792
14,369
Vehicle Maintenance: Personal services
-8-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget 13,088 4,000 81,248
Actual 1,842 3,461 20,671
Variance Favorable (Unfavorable) 11,246 539 60,577
Solid waste control services: Personal services Operating Capital Total Solid Waste Control Services
203,830 81,413 285,243
42,645 24,329 66,974
161,185 57,084 218,269
61,595 23,447 85,042
Trash Collection: Personal services Operating Capital Total Trash Collection
216,310 142,836 359,146
54,335 26,880 81,215
161,975 115,956 277,931
62,593 26,147 88,740
Recycling Collection: Personal services Operating Capital Total Recycling Collection
46,805 14,832 61,637
11,868 3,814 15,682
34,937 11,018 45,955
12,665 2,346 15,011
Streets & Highways: Personal services Operating Capital Total Streets & Highways
16,150 182,820 566,265 765,235
33,420 134,009 167,429
16,150 149,400 432,256 597,806
18,656 22,800 41,456
1,686,062
384,098
1,301,964
281,750
9,412 122,300 131,712
1,238 60,979 62,217
8,174 61,321 69,495
1,556 60,979 62,535
Library: Personal services Operating Capital Total library Services
105,180 43,867 16,200 165,247
25,130 4,300 3,555 32,985
80,050 39,567 12,645 132,262
25,600 6,004 3,411 35,015
Marine Services: Personal services Operating Capital Total Marine Services
262,430 14,541 43,000 319,971
64,700 2,526 6,932 74,158
197,730 12,015 36,068 245,813
84,577 2,710 1,237 88,524
Operating Capital Total Vehicle Maintenance
Total Physical Environment Cultural and Recreation: Sports complex: Personal services Operating Capital Debt service Total Sports Complex Services
-9-
Prior Year Actual 2,365 16,734
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Public Grounds & Forestry: Personal services Operating Capital Total Public Grounds & Forestry
305,465 155,011 191,274 651,750
79,038 28,648 888 108,574
226,427 126,363 190,386 543,176
86,055 27,726 5,435 119,216
Building Maintenance: Personal services Operating Capital Total Building Maintenance
168,695 136,089 136,817 441,601
42,038 31,124 6,214 79,376
126,657 104,965 130,603 362,225
46,066 33,177 12,265 91,508
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
47,500 47,500 1,757,781
1,532 1,532 358,842
45,968 45,968 1,398,939
2,097 2,097 398,895
Debt Service Transfers Out General Contingency TOTAL EXPENDITURES
307,850 9,460,430
76,894 2,141,352
230,956 7,319,078
76,894 3,316,243
$
- 10 -
$
$
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) December 31, 2012 Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts receivable Restricted Assets Other Total current assets
$
Fixed assets Land Buildings Improvements Machinery and equipment Intangibles Construction in progress
$
Liabilities, Equity and Other Credits: Liabilities: Accounts payable Notes Payable Other liabilities Payable from restricted assets: Accrued wages payable Deposits Revenue refunding bonds Deferred revenue Total liabilities Net Assets: Contributed capital Reserved Unreserved Total net assets Total liabilities, equity and other credits
- 11 -
$
4,300 509,892 20,486,913 810,847 19,142 193,821 22,024,915 (12,513,800) 9,511,115
Less accumulated depreciation & amortization Net fixed assets Unamortized bond costs Total assets and other debits
8,497,219 281,209 166,113 411,596 9,356,136
Prior Year
$
1,261,785 20,129,036
7,704,465 277,494 97,003 411,016 8,489,978 4,300 509,892 20,480,143 808,302 19,142 12,953 21,834,732 (11,757,547) 10,077,185
$
1,428,758 19,995,921
1,327,238 1,897,201 170,407
1,008,898 2,170,701 170,418
140,007 213,206 4,871,805 8,619,864
142,672 200,299 5,283,129 8,976,117
2,445,897 1,859,035 7,204,240 11,509,172
2,445,897 1,782,808 6,791,100 11,019,804
20,129,036
$
19,995,921
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget Revenues: Water sales Wastewater sales Miscellaneous Total operating revenues
$ (1,997,736) (1,959,334) (108,681) (4,065,751)
775,595 1,890,581 2,666,176
182,792 379,757 562,549
592,803 1,510,824 2,103,627
192,335 436,568 628,903
874,684
184,830
689,854
212,805
Debt Services Capital outlay
1,073,378 1,790,553 2,863,931
178,939 171,839 350,778
894,439 1,618,714 2,513,153
170,949 135,961 306,910
Total operating expenses
6,404,791
1,098,157
5,306,634
1,148,618
Administrative expenses
Operating income/(loss) Non-operating revenues (expenses) Investment income Sale of assets Contingency
2,445,022 2,402,110 140,671 4,987,803
(1,416,988)
$
Prior YTD Actual
447,286 442,776 31,990 922,052
Expenditures: Operating expenses Water/Sewer plant operations Personnel Current expenses Total
$
Actual
Variance Favorable (Unfavorable)
(176,105)
(9,372,385)
$
431,247 446,742 23,535 901,524
(247,094)
Retained Earnings-capital carryforward
8,441 1,408,547
5,045 -
(3,396) (1,408,547)
3,834 -
Total non-operating revenues (expenses)
1,416,988
5,045
(1,411,943)
3,834
Operating transfers out
Net income/(loss)
-
Net assets, beginning Net assets, ending
(171,060) 11,680,232 $ 11,509,172
- 12 -
(171,060)
(243,260) 11,263,064 $ 11,019,804
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget Administrative Legislative: Personal services Operating Total legislative Executive: Personal services Operating Capital
$
Actual
43,010 6,870 49,880
$
9,882 3,895 13,777
Variance Favorable (Unfavorable)
$
33,128 2,975 36,103
Prior Year Actual
$
13,761 3,553 17,314
102,285 12,789 115,074
23,944 2,744 26,688
78,341 10,045 88,386
27,253 4,022 31,275
Town Clerk: Personal services Operating
30,620 15,375
7,520 3,592
23,100 11,783
8,447 1,534
Total Town Clerk
45,995
11,112
34,883
9,981
393,020 170,877 4,983 568,880
82,402 35,479 2,349 120,230
310,618 135,398 2,634 448,650
95,034 44,576 139,610
2,950 80,655 83,605
971 9,477 10,448
1,979 71,178 73,157
935 10,932 11,867
11,250 11,250
2,575 2,575
8,675 8,675
2,758 2,758
874,684
184,830
689,854
212,805
Total executive
Financial administration: Personal services Operating Capital Total Financial Administration Legal: Personal services Operating Total Legal Non Departmental: Personal services Operating Capital Total Non Departmental Total Administrative
- 13 -
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget Operations/Utilities Utilities Administration Personal services Operating Capital
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
126,510 65,078 191,588
32,392 3,886 36,278
94,118 61,192 155,310
34,613 13,769 48,382
64,155 13,273 77,428
15,366 1,948 17,314
48,789 11,325 60,114
14,368 2,414 16,782
406,930 554,025 1,271,385 2,232,340
98,255 94,555 10,582 203,392
308,675 459,470 1,260,803 2,028,948
106,996 86,387 135,961 329,344
178,000 1,258,205 519,168 1,955,373
36,779 279,368 161,257 477,404
141,221 978,837 357,911 1,477,969
36,358 333,998 370,356
Total operations/utilities
4,456,729
734,388
3,722,341
764,864
Debt Services Transfers Out Contingency
1,073,378 -
178,939 -
894,439 -
170,949 -
$ 6,404,791
$ 1,098,157
5,306,634
$ 1,148,618
Total Public Works Administration Vehicle Maintenance Personal services Operating Capital Total Vehicle Maintenance Water/waterplant operations Personal services Operating Capital Total Water plant operations Wastewater operations Personal services Operating Capital Total Wastewater operations
TOTAL EXPENDITURES
- 14 -
$
TOWN OF LANTANA, FLORIDA Investment Earnings Quarter Closing December 31, 2012 FLORIDA STATE BOARD OF ADMINISTRATION (SBA) *EACH ACCOUNT COMBINES FLORIDA PRIME AND FUND B
SBA Rate General Fund Beginning Bal.
October
November
December
Total
0.29%
0.28%
0.25%
0.27%
177,217
Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
-
177,241 -
177,262 -
177,217 -
23
22
21
66
177,241
177,262
177,283
177,283
183,851
183,875
183,898
183,851
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal. Impact Fee Reserve
-
-
-
-
24
23
21
68
183,875
183,898
183,919
183,919
6,831
6,832
6,833
6,831
-
-
-
-
*
Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
1
1
3
6,832
6,833
6,833
6,833
27,404
27,407
27,411
27,404
-
-
-
-
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
4
3
3
10
27,407
27,411
27,414
27,414
4,017
4,018
4,018
4,017
-
-
-
-
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
0
0
1
4,018
4,018
4,019
4,019
- 15 -
October
November
December
Total
Bond Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
16,782
16,785
16,787
16,782
-
-
-
-
2
2
2
6
16,785
16,787
16,789
16,789
55 55
51 51
48 48
155 155
26 29
24 27
23 26
55
51
48
72 83 0 155
SBA TOTALS Total Investment Earnings Total Admin. Charges Net Investment Earnings
-
Investment Earnings Net of Admin. Charges General Fund Utility Fund Transportation Fund
SUNTRUST BANK ACCOUNTS Checking Account Earnings Investment Credit Per SunTrust General Fund Utility Fund Transportation Fund Recreation Fund Forfeiture Fund Bank Charges (net of interest credit)
0.100% 626 656 4 (231)
Investment Earnings
0.100% 576 642
0.100% 666 660
0.100% 1,869 1,958 0
4 (340)
4 (284)
12 (855)
1,056
882
1,046
Operating Water Plant Reserve
16,778,219 373,297
16,379,488 373,334
17,722,813 373,372
Ending Balances
17,151,516
16,752,821
18,096,185
2,984
Checking Account Ending Balances per Statement
TOTAL INVESTMENT EARNINGS BY FUND General Fund Utility Fund Forfeiture Fund $
651 686 4 1,342
- 16 -
$
600 669 4 1,274
$
689 685 4 1,378
$
1,941 2,040 12 3,994
-2-
BUDGET-IN-BRIEF as of December 31, 2012 (25% of year elapsed) YTD-Townwide Expense Allocation
Other Town Funds
Interfund Transfers, ‐ , 0%
Debt Capital $316,812 9% $351,701 10%
Wages $1,114,901
Budget 4,996,244 1,408,547 6,404,791 6,404,791
Year-to-Date 927,100 927,100 1,097,977
% 18.6% 0.0% 14.5% 17.1%
Police Education Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Budget 2,761 1,839 4,600 4,600
Year-to-Date 862 862 214
% 31.2% 0.0% 18.7% 4.7%
Police Forfeiture Fund* Budget Total Revenues Total Expenses *Per Florida Statute fund is not budgeted
Year-to-Date 8 1,261
% 0.0% 0.0%
Grants Fund *Revenues Appropriations & Carryover Total Revenues Total Expenses
Year-to-Date 1,410,234 1,410,234 13,441
% 422.7% N/A 422.7% 4.0%
Year-to-Date 88,859 88,859 185,179
% 22.3% N/A 22.3% 46.6%
32%
Operating & Maint. $1,015,782 30%
Benefits $639,957 19%
General Fund Revenues Revenues Budget Year-to-Date Taxes 4,376,125 1,849,863 Licenses & Permits 443,520 84,057 Intergovernmental Revenue 1,112,636 131,791 Charges for Services 1,602,398 353,952 Fines & Forfeitures 99,415 30,106 Misc. Revenue 653,873 138,796 Interfund Transfers Debt Proceeds Appropriations & Carryover 1,172,463 Total Revenues $ 9,460,430 $ 2,588,565
% 42.3% 19.0% 11.8% 22.1% 30.3% 21.2% 0.0% 0.0% 0.0% 27.4%
General Fund Expenditures Budget Year-to-Date 74,820 20,664 184,069 43,078 353,641 83,391 163,534 21,513 162,010 81,819 3,828,433 908,456
% 27.6% 23.4% 23.6% 13.2% 50.5% 23.7%
Expenditures Town Council Town Manager Finance Town Attorney Non-Departmental Police
Utility Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Development Services
605,680
139,873
23.1%
2,167,440 149,047
495,939 29,430
22.9% 19.7%
47,500
1,532
3.2%
Capital Outlay
1,294,106
177,513
13.7%
Debt Service Interfund Transfers Out General Contingency Total Expenditures
430,150 9,460,430
137,873 2,141,081
32.1% 0.0% 0.0% 22.6%
Operations Department Library Holiday Events
$
$
Budget 333,631 333,631 333,631
*(Revenues are a carryover of the PACE & 5-City Grant)
Insurance Fund Revenues Appropriations & Carryover Total Revenues Total Expenses
Expenditures
YTD-Total Townwide Budget Budget Year-to-Date
Total Townwide Budget (not including Police Forfeiture Fund)
-3-
Budget 397,743 397,743 397,743
16,601,195
3,437,892
% 20.7%
TOWN OF LANTANA, FLORIDA General Fund Balance Sheet (unaudited) December 31, 2012 Prior Year
Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts Inventory Due from other funds Accrued revenues Other Total assets and other debits
$
$
Liabilities, Equity and Other Credits: Liabilities: Accounts payable Other liabilities Payable from restricted assets: Accrued wages payable Revenue refunding bonds Deferred revenue Total liabilities Fund balances: Assigned for Encumbrances Unassigned Total equity and other credits Total liabilities, equity and other credits
-4-
$
8,850,253 279,042 45,117 12,193 276,930 (13,677) 9,449,858
$
$
9,310,736 275,747 23,317 10,904 440,134 10,060,838
248,437 10,588
162,702 7,566
144,089 403,114
187,315 357,583
551,118 8,495,626 9,046,744 9,449,858
1,081,166 8,622,089 9,703,255 10,060,838
$
TOWN OF LANTANA, FLORIDA General Fund Statement of Revenues, Expenditures and Changes in Fund Balance – Budget and Actual (unaudited) Period Ended December 31, 2012
Revenues: Taxes Licenses and permits Intergovernmental Charges for services Fines and forfeitures Miscellaneous Use of Fund Balance Total revenues Expenditures: Current: General government Public safety Development services Physical environment Culture and recreation Capital outlay Debt service: Principal & Interest General contingency Total expenditures Deficiency of revenues under expenditures Other financing sources: Sale of general fixed assets Operating transfers in Operating transfers out Use of Fund Balance-capital carryfwd Capital lease/Loan Proceeds Total other financing sources Deficiency of revenues and other financing sources under expenditures
Variance Favorable (Unfavorable)
Prior Year Actual
Budget
Actual
$ 4,376,125 443,520 1,112,636 1,602,398 99,415 647,873 99,670 8,381,637
$ 1,830,890 254,751 131,790 353,953 30,106 238,556 2,840,046
938,074 3,828,433 605,680 1,115,797 1,248,190 1,294,106
250,736 908,456 139,873 246,628 280,274 177,512
687,338 2,919,977 465,807 869,169 967,916 1,116,594
203,928 983,041 149,174 257,713 315,568 1,268,946
430,150 9,460,430
137,873 2,141,352
292,277 7,319,078
137,873 3,316,243
698,694
1,777,487
(1,078,793) 6,000 1,072,793 1,078,793
-
-
698,693 8,348,051 $ 9,046,744
Fund balance, beginning of year FUND BALANCE, END OF PERIOD
-5-
$ (2,545,235) (188,769) (980,846) (1,248,445) (69,309) (409,317) (5,441,921)
(6,000) (1,072,793) (1,078,793)
$ 1,870,944 226,323 134,015 356,044 51,334 181,707 2,820,367
(495,876) (495,871) 10,199,126 $ 9,703,255
TOWN OF LANTANA, FLORIDA General Fund Schedule of Revenues and Other Financing Sources – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget
Actual
$ 2,120,000 666,158 999,853 325,605 264,509 4,376,125
$ 1,518,247 60,385 183,747 47,022 21,489 1,830,890
263,177 180,343 443,520
Intergovernmental revenues: Insurance Premium Tax-Police State revenue sharing Mobile home licenses Alcoholic beverage licenses Local government ½ cent sales tax Government grants Total intergovernmental revenues Charges for services: Sanitation and waste removal Recycling fees Public Safety Nature Preserve Maintenance Total charges for services
Taxes: Ad Valorem taxes Franchise taxes Utility service taxes Local Communications Services Tax Gasoline taxes Total taxes
Variance Favorable (Unfavorable) (601,753) (605,773) (816,106) (278,583) (243,020) (2,545,235)
$ 1,587,912 57,314 175,103 28,173 22,442 1,870,944
195,462 59,289 254,751
(67,715) (121,054) (188,769)
184,299 42,024 226,323
90,000 297,000 21,251 11,020 669,500 23,865 1,112,636
74,352 2,215 55,223 131,790
(90,000) (222,648) (19,036) (11,020) (614,277) (23,865) (980,846)
72,185 8,951 52,879 134,015
767,483 105,816 678,619 50,480 1,602,398
149,408 19,972 171,950 12,623 353,953
(618,075) (85,844) (506,669) (37,857) 1,248,445
149,649 20,200 173,856 12,339 356,044
99,415
30,106
(69,309)
51,334
Miscellaneous revenues: Interest Beach parking Contributions Leases Chancellor Academy Other Total miscellaneous revenues
11,080 119,736 478,397 38,660 647,873
4,477 30,984 172,478 7,986 22,631 238,556
(6,603) (88,752) (305,919) 7,986 (16,029) (409,317)
3,725 44,075 1,250 115,055 17,602 181,707
Other financing sources: Sale of general fixed assets Interfund Transfers Capital Carryover Use of Fund Balance Loan Proceeds Total other financing sources TOTAL REVENUES
6,000 1,072,793 99,670 1,178,463 $ 9,460,430
$ 2,840,046
(6,000) (1,072,793) (99,670) (1,178,463) $ (6,620,384)
$ 2,820,367
Licenses and permits: Business services taxes Building and other permits Total licenses and permits
Fines and forfeitures
-6-
$
Prior Year Actual
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget General government: Legislative: Personal services Operating Total Legislative
$
Actual
64,515 10,305 74,820
$
14,822 5,843 20,665
Variance Favorable (Unfavorable)
$
49,693 4,462 54,155
Prior Year Actual
$
20,641 5,330 25,971
Executive: Personal services Operating Capital Total Executive
102,290 12,789 3,850 118,929
23,945 2,729 3,851 30,525
78,345 10,060 (1) 88,404
29,114 4,070 33,184
Town Clerk: Personal services Operating Capital Total Town Clerk
45,925 23,065 68,990
11,283 5,391 16,674
34,642 17,674 52,316
12,747 2,301 15,048
Financial Administration: Personal services Operating Capital Total Financial Administration
239,480 114,161 41,760 395,401
54,096 29,295 1,851 85,242
185,384 84,866 39,909 310,159
53,870 38,594 4,559 97,023
Legal Counsel: Personal services Operating Total Legal Counsel
11,695 151,839 163,534
3,862 17,651 21,513
7,833 134,188 142,021
3,740 23,885 27,625
161,010 45,552 1,000 207,562 1,029,236
81,819 81,819 256,438
79,191 45,552 1,000 125,743 772,798
9,636 1,197,250 1,206,886 1,405,737
383,420 68,915 63,921 516,256
95,349 45,412 140,761
288,071 23,503 63,921 375,495
101,856 44,815 9,679 156,350
Non-Departmental Personal services Operating Capital Other Expenses Total Non-Departmental Total General Government Public Safety: Administration: Personal services Operating Capital Total Administration
-7-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Uniform Patrol: Personal services Operating Capital Total Uniform Patrol
2,203,205 176,046 156,479 2,535,730
497,722 36,993 10,146 544,861
1,705,483 139,053 146,333 1,990,869
514,110 49,577 3,244 566,931
Services: Personal services Operating Capital Total Police Services
439,650 161,679 7,500 608,829
107,285 32,356 5,432 145,073
332,365 129,323 2,068 463,756
115,944 57,666 173,610
Uniform Patrol (Hypoluxo): Personal services Operating Capital Total Uniform Patrol (Hypoluxo)
374,265 21,253 2,950 398,468
88,942 4,397 93,339
285,323 16,856 2,950 305,129
95,821 3,252 1,617 100,690
4,059,283
924,034
3,135,249
997,581
172,260 15,259 2,538 190,057
42,015 3,380 1,173 46,568
130,245 11,879 1,365 143,489
43,902 4,710 48,612
Total Public Safety Development Services: Administration : Personal services Operating Capital Total Administration Building Inspections: Personal services Operating Capital Total Building Inspections Code Enforcement: Personal services Operating Capital Total Code Enforcement
121,150 109,067 12,000 242,217
28,820 23,914 52,734
92,330 85,153 12,000 189,483
31,359 26,153 6,212 63,724
169,195 18,749 187,944
39,507 2,237 41,744
129,688 16,512 146,200
40,873 2,177 43,050
Total Development Services
620,218
141,046
479,172
155,386
Physical Environment: Operations Administration Personal services Operating Capital Total Public Works Administration
119,625 13,928 133,553
28,850 3,277 32,127
90,775 10,651 101,426
30,922 2,608 1,237 34,767
64,160
15,368
48,792
14,369
Vehicle Maintenance: Personal services
-8-
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget 13,088 4,000 81,248
Actual 1,842 3,461 20,671
Variance Favorable (Unfavorable) 11,246 539 60,577
Solid waste control services: Personal services Operating Capital Total Solid Waste Control Services
203,830 81,413 285,243
42,645 24,329 66,974
161,185 57,084 218,269
61,595 23,447 85,042
Trash Collection: Personal services Operating Capital Total Trash Collection
216,310 142,836 359,146
54,335 26,880 81,215
161,975 115,956 277,931
62,593 26,147 88,740
Recycling Collection: Personal services Operating Capital Total Recycling Collection
46,805 14,832 61,637
11,868 3,814 15,682
34,937 11,018 45,955
12,665 2,346 15,011
Streets & Highways: Personal services Operating Capital Total Streets & Highways
16,150 182,820 566,265 765,235
33,420 134,009 167,429
16,150 149,400 432,256 597,806
18,656 22,800 41,456
1,686,062
384,098
1,301,964
281,750
9,412 122,300 131,712
1,238 60,979 62,217
8,174 61,321 69,495
1,556 60,979 62,535
Library: Personal services Operating Capital Total library Services
105,180 43,867 16,200 165,247
25,130 4,300 3,555 32,985
80,050 39,567 12,645 132,262
25,600 6,004 3,411 35,015
Marine Services: Personal services Operating Capital Total Marine Services
262,430 14,541 43,000 319,971
64,700 2,526 6,932 74,158
197,730 12,015 36,068 245,813
84,577 2,710 1,237 88,524
Operating Capital Total Vehicle Maintenance
Total Physical Environment Cultural and Recreation: Sports complex: Personal services Operating Capital Debt service Total Sports Complex Services
-9-
Prior Year Actual 2,365 16,734
TOWN OF LANTANA, FLORIDA General Fund Schedule of Expenditures and Other Financing Uses – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
Public Grounds & Forestry: Personal services Operating Capital Total Public Grounds & Forestry
305,465 155,011 191,274 651,750
79,038 28,648 888 108,574
226,427 126,363 190,386 543,176
86,055 27,726 5,435 119,216
Building Maintenance: Personal services Operating Capital Total Building Maintenance
168,695 136,089 136,817 441,601
42,038 31,124 6,214 79,376
126,657 104,965 130,603 362,225
46,066 33,177 12,265 91,508
Miscellaneous: Holiday events Total Miscellaneous Total Culture and Recreation
47,500 47,500 1,757,781
1,532 1,532 358,842
45,968 45,968 1,398,939
2,097 2,097 398,895
Debt Service Transfers Out General Contingency TOTAL EXPENDITURES
307,850 9,460,430
76,894 2,141,352
230,956 7,319,078
76,894 3,316,243
$
- 10 -
$
$
$
TOWN OF LANTANA, FLORIDA Utility Fund Balance Sheet (unaudited) December 31, 2012 Current Year Assets and Other Debits: Assets: Cash and cash equivalents Investments Accounts receivable Restricted Assets Other Total current assets
$
Fixed assets Land Buildings Improvements Machinery and equipment Intangibles Construction in progress
$
Liabilities, Equity and Other Credits: Liabilities: Accounts payable Notes Payable Other liabilities Payable from restricted assets: Accrued wages payable Deposits Revenue refunding bonds Deferred revenue Total liabilities Net Assets: Contributed capital Reserved Unreserved Total net assets Total liabilities, equity and other credits
- 11 -
$
4,300 509,892 20,486,913 810,847 19,142 193,821 22,024,915 (12,513,800) 9,511,115
Less accumulated depreciation & amortization Net fixed assets Unamortized bond costs Total assets and other debits
8,497,219 281,209 166,113 411,596 9,356,136
Prior Year
$
1,261,785 20,129,036
7,704,465 277,494 97,003 411,016 8,489,978 4,300 509,892 20,480,143 808,302 19,142 12,953 21,834,732 (11,757,547) 10,077,185
$
1,428,758 19,995,921
1,327,238 1,897,201 170,407
1,008,898 2,170,701 170,418
140,007 213,206 4,871,805 8,619,864
142,672 200,299 5,283,129 8,976,117
2,445,897 1,859,035 7,204,240 11,509,172
2,445,897 1,782,808 6,791,100 11,019,804
20,129,036
$
19,995,921
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Revenues, Expenses and Changes in Retained Earnings – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget Revenues: Water sales Wastewater sales Miscellaneous Total operating revenues
$ (1,997,736) (1,959,334) (108,681) (4,065,751)
775,595 1,890,581 2,666,176
182,792 379,757 562,549
592,803 1,510,824 2,103,627
192,335 436,568 628,903
874,684
184,830
689,854
212,805
Debt Services Capital outlay
1,073,378 1,790,553 2,863,931
178,939 171,839 350,778
894,439 1,618,714 2,513,153
170,949 135,961 306,910
Total operating expenses
6,404,791
1,098,157
5,306,634
1,148,618
Administrative expenses
Operating income/(loss) Non-operating revenues (expenses) Investment income Sale of assets Contingency
2,445,022 2,402,110 140,671 4,987,803
(1,416,988)
$
Prior YTD Actual
447,286 442,776 31,990 922,052
Expenditures: Operating expenses Water/Sewer plant operations Personnel Current expenses Total
$
Actual
Variance Favorable (Unfavorable)
(176,105)
(9,372,385)
$
431,247 446,742 23,535 901,524
(247,094)
Retained Earnings-capital carryforward
8,441 1,408,547
5,045 -
(3,396) (1,408,547)
3,834 -
Total non-operating revenues (expenses)
1,416,988
5,045
(1,411,943)
3,834
Operating transfers out
Net income/(loss)
-
Net assets, beginning Net assets, ending
(171,060) 11,680,232 $ 11,509,172
- 12 -
(171,060)
(243,260) 11,263,064 $ 11,019,804
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget Administrative Legislative: Personal services Operating Total legislative Executive: Personal services Operating Capital
$
Actual
43,010 6,870 49,880
$
9,882 3,895 13,777
Variance Favorable (Unfavorable)
$
33,128 2,975 36,103
Prior Year Actual
$
13,761 3,553 17,314
102,285 12,789 115,074
23,944 2,744 26,688
78,341 10,045 88,386
27,253 4,022 31,275
Town Clerk: Personal services Operating
30,620 15,375
7,520 3,592
23,100 11,783
8,447 1,534
Total Town Clerk
45,995
11,112
34,883
9,981
393,020 170,877 4,983 568,880
82,402 35,479 2,349 120,230
310,618 135,398 2,634 448,650
95,034 44,576 139,610
2,950 80,655 83,605
971 9,477 10,448
1,979 71,178 73,157
935 10,932 11,867
11,250 11,250
2,575 2,575
8,675 8,675
2,758 2,758
874,684
184,830
689,854
212,805
Total executive
Financial administration: Personal services Operating Capital Total Financial Administration Legal: Personal services Operating Total Legal Non Departmental: Personal services Operating Capital Total Non Departmental Total Administrative
- 13 -
TOWN OF LANTANA, FLORIDA Utility Fund Statement of Expenditures – Budget and Actual (unaudited) Period Ended December 31, 2012
Budget Operations/Utilities Utilities Administration Personal services Operating Capital
Actual
Variance Favorable (Unfavorable)
Prior Year Actual
126,510 65,078 191,588
32,392 3,886 36,278
94,118 61,192 155,310
34,613 13,769 48,382
64,155 13,273 77,428
15,366 1,948 17,314
48,789 11,325 60,114
14,368 2,414 16,782
406,930 554,025 1,271,385 2,232,340
98,255 94,555 10,582 203,392
308,675 459,470 1,260,803 2,028,948
106,996 86,387 135,961 329,344
178,000 1,258,205 519,168 1,955,373
36,779 279,368 161,257 477,404
141,221 978,837 357,911 1,477,969
36,358 333,998 370,356
Total operations/utilities
4,456,729
734,388
3,722,341
764,864
Debt Services Transfers Out Contingency
1,073,378 -
178,939 -
894,439 -
170,949 -
$ 6,404,791
$ 1,098,157
5,306,634
$ 1,148,618
Total Public Works Administration Vehicle Maintenance Personal services Operating Capital Total Vehicle Maintenance Water/waterplant operations Personal services Operating Capital Total Water plant operations Wastewater operations Personal services Operating Capital Total Wastewater operations
TOTAL EXPENDITURES
- 14 -
$
TOWN OF LANTANA, FLORIDA Investment Earnings Quarter Closing December 31, 2012 FLORIDA STATE BOARD OF ADMINISTRATION (SBA) *EACH ACCOUNT COMBINES FLORIDA PRIME AND FUND B
SBA Rate General Fund Beginning Bal.
October
November
December
Total
0.29%
0.28%
0.25%
0.27%
177,217
Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
-
177,241 -
177,262 -
177,217 -
23
22
21
66
177,241
177,262
177,283
177,283
183,851
183,875
183,898
183,851
Utility Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal. Impact Fee Reserve
-
-
-
-
24
23
21
68
183,875
183,898
183,919
183,919
6,831
6,832
6,833
6,831
-
-
-
-
*
Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
1
1
3
6,832
6,833
6,833
6,833
27,404
27,407
27,411
27,404
-
-
-
-
1998 Reserve Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
4
3
3
10
27,407
27,411
27,414
27,414
4,017
4,018
4,018
4,017
-
-
-
-
RR&I Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
1
0
0
1
4,018
4,018
4,019
4,019
- 15 -
October
November
December
Total
Bond Fund Beginning Bal. Transfers In (Out) Admin. Charges Investment Earnings Ending Bal.
16,782
16,785
16,787
16,782
-
-
-
-
2
2
2
6
16,785
16,787
16,789
16,789
55 55
51 51
48 48
155 155
26 29
24 27
23 26
55
51
48
72 83 0 155
SBA TOTALS Total Investment Earnings Total Admin. Charges Net Investment Earnings
-
Investment Earnings Net of Admin. Charges General Fund Utility Fund Transportation Fund
SUNTRUST BANK ACCOUNTS Checking Account Earnings Investment Credit Per SunTrust General Fund Utility Fund Transportation Fund Recreation Fund Forfeiture Fund Bank Charges (net of interest credit)
0.100% 626 656 4 (231)
Investment Earnings
0.100% 576 642
0.100% 666 660
0.100% 1,869 1,958 0
4 (340)
4 (284)
12 (855)
1,056
882
1,046
Operating Water Plant Reserve
16,778,219 373,297
16,379,488 373,334
17,722,813 373,372
Ending Balances
17,151,516
16,752,821
18,096,185
2,984
Checking Account Ending Balances per Statement
TOTAL INVESTMENT EARNINGS BY FUND General Fund Utility Fund Forfeiture Fund $
651 686 4 1,342
- 16 -
$
600 669 4 1,274
$
689 685 4 1,378
$
1,941 2,040 12 3,994
