Loading...
Agenda Item 4ATotal Restricted Cash $8,099,299 Total Unrestricted Cash $10,871,129 Cash and Investments Annual Prior Current Dollar Percent Account Yield 03/31/13 04/30/13 Change Change Bank of America - Depository Columbia US Government MTG A Guggenheim Floating Rate A Invesco floating Rate A Loomis Investment Grade Bond A Loomis Sayles Limited Gov an Agency Lord Abbett Income A Delaware Diversified Income Fund Lord Abbett Short Duration Fund Invesco Corporate Bond A Pioneer Strategic Income A Legg Mason WA Cash Reserve Fund Nuveen Total Return Bond Fund A MFS Bond Fund A MSSB Money Market/Cash SBA - Florida Prime Cash on Hand Police Pension Investments General Pension Investments * Denotes the 30 day SEC Yield Anualized 0.24% City of Atlantic Beach FINANCIAL REPORT April 2013 $2,868,249 AGENDA ITEM # 4A JULY 8, 2013 - 20.87% Cash Balances 1,004,794 0 (1,004,794) N/A Prior Current Dollar Percent Fund(s) 03/31/13 04/30/13 Change Change General $7,561,464 $7,328,090 ($233,374) -3.09% Tree Replacement 6,493 6,493 0 0.00% Convention Development Tax 66,718 67,391 673 1.01% Local Option Gas Tax 186,371 207,115 20,744 11.13% Better Jax 1/2 Cent Sales Tax 256,834 282,448 25,614 9.97% Police Training, Forfeiture, Grants, etc. 163,913 172,238 8,325 5.08% Community Development Block & ARRA Grants 166,279 166,279 0 0.00% Debt Service 40,487 46,872 6,385 15.77% Capital Projects 2,790,518 2,818,651 28,133 1.01% Utility 5,672,744 5,171,059 (501,685) -8.84% Sanitation 701,529 718,892 17,363 2.47% Building Code Enforcement 94,187 100,540 6,353 6.74% Storm Water 1,505,300 1,528,769 23,468 1.56% Pension - Police 22,091 14,859 (7,232) - 32.74% Pension - General 299,470 340,733 41,263 13.78% Total $19,534,399 $18,970,428 ($563,972) -2.89% Total Restricted Cash $8,099,299 Total Unrestricted Cash $10,871,129 Cash and Investments Annual Prior Current Dollar Percent Account Yield 03/31/13 04/30/13 Change Change Bank of America - Depository Columbia US Government MTG A Guggenheim Floating Rate A Invesco floating Rate A Loomis Investment Grade Bond A Loomis Sayles Limited Gov an Agency Lord Abbett Income A Delaware Diversified Income Fund Lord Abbett Short Duration Fund Invesco Corporate Bond A Pioneer Strategic Income A Legg Mason WA Cash Reserve Fund Nuveen Total Return Bond Fund A MFS Bond Fund A MSSB Money Market/Cash SBA - Florida Prime Cash on Hand Police Pension Investments General Pension Investments * Denotes the 30 day SEC Yield Anualized 0.24% $3,624,861 $2,868,249 ($756,611) - 20.87% 1,004,794 0 (1,004,794) N/A 3.75% * 0 1,001,116 1,001,116 N/A 4.28% * 0 990,514 990,514 N/A 2.28% * 1,535,864 1,567,803 31,939 2.08% 999,491 0 (999,491) N/A 3.62% * 1,529,862 1,556,404 26,542 1.73% 2.21% * 1,698,098 1,721,422 23,324 1.37% 2.26% * 1,015,939 1,021,173 5,234 0.52% 2.49% * 1,890,015 1,924,751 34,737 1.84% 3.49% * 1,920,176 1,944,070 23,894 1.24% 0.01% * 1,001,376 1,001,466 90 0.01% 4.00% * 1,996,728 2,037,131 40,402 2.02% 1.94% * 1,313,706 1,332,833 19,128 1.46% 0.00% 0 3 3 N/A 0.22% * 341 341 0 0.00% 0.00% 3,150 3,150 0 0.00% Subtotal 19,534,399 18,970,428 (563,972) -2.89% 7,341,658 7,419,571 77,913 1.06% 13,086,309 13,168,772 82,463 0.63% Subtotal 20,427,967 20,588,343 160,376 0.79% Total $39,962,366 $39,558,771 ($403,595) -1.01% City of Atlantic Beach FINANCIAL REPORT AGENDA ITEM # 4A April 2013 JULY 8, 2013 Revenues Fund / (Footnote) Annual Estimate YTD - 58% of Estimate YTD Actual Dollar Variance Percent Variance General (1) $10,994,301 $6,413,342 $7,863,882 $1,450,540 22.62% Convention Development Tax 70,000 40,833 48,090 7,257 17.77% Local Option Gas Tax 433,655 252,965 244,563 (8,402) -3.32% Better Jax 1/2 Ct Sales Tax 657,738 383,681 387,232 3,551 0.93% Police Training, Forfeiture & Grants, etc. 109,860 64,085 90,987 26,902 41.98% Grants - (3) 108,866 63,505 216,560 153,055 241.01% Debt Service 71,900 41,942 42,109 167 0.40% Capital Projects 5,000 2,917 39,785 36,868 1264.05% Utility -(4) 8,610,929 5,023,042 4,897,762 (125,280) -2.49% Sanitation 1,814,950 1,058,721 1,063,348 4,627 0.44% Building Code Enforcement - (5) 282,600 164,850 174,814 9,964 6.04% Storm Water 1,097,430 640,168 667,406 27,238 4.25% Pension - Police (2) 1,233,745 719,685 641,068 (78,616) - 10.92% Pension - General (2) 2,174,392 1,268,395 1,258,363 10,033 -0.79% Total $27,665,366 $16,138,130 $17,635,969 $1,497,839 9.28% Analysis of Major Variances (1) The positive variance in the General Fund is mostly a result of having received property taxes. Those taxes began to arriving in November. The bulk of the receipts came in December. Also contributing to the large variance is the receipt of the donation for the land purchase. Most other revenue categories are near budget estimates. (2) The $78,616 negative variance in the Police Employee Pension Fund & the $10,033 negative variance in the General Employee Pension Fund resulted from changes in market values of the investments of less than the assumed amount. (3) Grant revenues are higher than the budget because C.D.B.G. and F.E.M.A. Wind retro -fit grant proceeds related to last year's grant expenditures were received this year. (4) Utility sales were well under budget for Year to Date through April for both Water and Sewer. Base charges are below budget by about 7% and volume sales are below projections by about 16% in water and 8% in sewer. These are partially off -set by the receipt of a rebate from electric energy savings from JEA of $142,066. Water and sewer volume sales should increase over the summer months. (5) Building Permit fee revenues continue to run about 6% above projections. City of Atlantic Beach FINANCIAL REPORT AGENDA ITEM # 4A April 2013 JULY 8, 2013 Personnel Services (5) Operating Expenses (2) Capital Outlay (1) & (2) Debt Service (4) Transfers Total $9,549,191 Annual YTD - 58% YTD Dollar Percent Department / (Footnote) Estimate of Estimate Actual Variance Variance Governing Body $42,645 $24,876 $23,167 $1,709 6.87% City Administration 2,413,735 1,408,012 1,322,997 85,015 6.04% General Government (2) 900,361 525,211 708,106 (182,895) - 34.82% Planning and Building 443,666 258,805 227,627 31,178 12.05% Public Safety (1,5 ) 5,592,274 3,262,160 2,892,624 369,536 11.33% Recreation and Special Events 397,376 231,803 228,266 3,537 1.53% Public Works (3) 6,078,591 3,545,845 2,580,267 965,578 27.23% Public Utilities (4) 9,351,075 5,454,794 5,446,493 8,300 0.15% Pension - Police 653,056 380,949 399,938 (18,989) -4.98% Pension - General 789,485 460,533 506,178 (45,646) -9.91% Total $26,662,264 $15,552,987 $14,335,663 $1,217,324 Annual YTD - 58% YTD Dollar Percent Resource Allocation Estimate of Estimate Actual Variance Variance Personnel Services (5) Operating Expenses (2) Capital Outlay (1) & (2) Debt Service (4) Transfers Total $9,549,191 $5,570,361 $5,045,923 $524,438 9.41% 10,189,249 5,943,729 5,147,760 795,969 13.39% 3,074,958 1,793,726 1,269,797 523,928 29.21% 2,519,412 1,469,657 2,094,504 (624,847) - 42.52% 1,329,454 775,515 777,679 (2,164) -0.28% $26,662,264 $15,552,987 $14,335,663 $1,217,324 Analysis of Major Variances (1) The positive variance in the Public Safety divisions is partly due to paying for the fire contract services quarterly to Jacksonville. This is about $249,000 per quarter. The Lifeguard expenses have just begun and the deferral of the budgeted expenditures on the Police Building add to that variance - see Project Activity Schedule. (2) The negative variance in General Government results from the purchase of land in November and in March totaling $328,665. Another part of this variance is the prepayment of Insurance at the beginning of the year. (3) The variance in the Public Works Department is due to project activity budgeted that has not been completed. The department has spent about 27% of its project budget - see Project Activity Schedule. (4) The negative variance in the Public Utilities divisions results from paying the majority of the annual debt service payments and insurance at the beginning of the year. The department has spent approximately 40% of its project budget. (5) The positive variance in the Personnel Services resulted from vacant positions that have not been filled. The City budgets full employment, so any vacancy contributes to a positive variance. The Lifeguards are typically seasonal employees working May through September. City of Atlantic Beach FINANCIAL REPORT AGENDA ITEM # 4A April 2013 JULY 8, 2013 Project Activity - Current Year Activity Only Project YTD YTD Project Name Number Budget Actual Balance Status Public Safety Police Building Renovation /Design /Construction PS0504 60,000 0 60,000 DE $ 60,000 $ - $ 60,000 Public Utilities: TMDL - Lift Station /Main Transfer Flow PU0906 9,282 5,933 3,349 C TMDL Upgrade /Construction - WWTP #1 PU1106 147,862 81,644 66,218 C TMDL Sludge /Odor Improvements PI-11110 144,606 15,591 129,015 C Water Main -12th Street at Ocean Blvd /Beach Ave PU1204 36,962 34,121 2,841 C Water Main - 14th & 15th Street at Ocean Boulevard PU1205 201,657 190,619 11,038 C Rehab of Interior of Tank #1 PU 1301 41,500 41,500 1 Recoat Both Ground Storage Tanks WP #3 PU1303 55,000 55,000 I Replace the Water Main on Pine Street PU1304 90,000 5,877 84,123 1 Replace 4" Water ?Main at Wonderwood and Finegan PU1305 180,000 11,771 168,229 I PT Repair at Lift Station C PU 1306 40,000 40,000 I PT Repair at West 6th and Stock PU1307 55,000 19,891 35,109 C Repair 24" Effluent Force Main PU1308 86,000 86,000 I Repair 12" Force Main PU1309 56,000 56,000 I Replace Yard Pump PU1310 18,435 18,435 I Sewer Rehabilitation 2013 PU1311 202,300 189,669 12,631 C Subtotal $ 1,364,604 $ 555,116 $ 809,489 Public Works: Marsh Master Plan Signs PM1301 38,700 38,700 I Marsh Master Plan Project Design PM1303 34,000 10,200 23,800 E Rose Park Development PM1302 225,000 11,350 213,650 E Dutton Island Road Sidewalks PW1301 79,064 79,064 E Sidewalk and Curb Replacements PW 1302 25,000 6,041 18,959 1 City Hall Parking Lot Lights PW 1303 32,000 32,000 B Irregation Improvements Atlantic Blvd. PW1304 4,600 4,600 0 C Sidewalk on West 9th Street PW1305 33,000 25,669 7,331 C East Coast Drive Drainage Improvements PW 1306 360,000 360,000 E Subtotal $ 831,364 $ 57,860 $ 773,504 Total $2,255,968 $ 612,976 $1,642,994 Status Key A - Bid Advertised E - Design Phase B - Bid Awarded I - Project In- progress C - Project Completed N - Complete /Non - Capital D - Design Completed R - Re- budget Next Fiscal Year OR Re- Evaluated DE - Deferred X - Project Cancelled AlihNllA 11hM IT 4A JULY 8, 20I3 I r w fn N ~ N e ti V- tD CD Lt1 07 O 0 N O VLL W a w a — - N ? N ti 0 U 00 J a z Q D Z OF r. wZ�ma ? J m J w a w O _ O°0 00 °c a °o w °o °o . 00 00 IL �ao o C� wN M ti r ti 0) N o O C >Lf) N Z N N r t0 LI � � } >- M N a N Q M 0 z O N v+ a W 61). 61). R�t�0t,6& ��6& - tttA 0 0 0 0 o 0 p� Z N o 0 O J Z O N f71 c0a N r N M U) W o r O �'— V+ W O N t70 Oc Z O = N N } w w O O o. O o .. 0 00000000 0 0 0 0 0 0 _ 0 I O o, 0 x0000000 0 0 0 0 0 0 0 O 0 5 a ^ LL O LL LL �o (q le to r QMroo�oo t`WNMW MMleWT"WM ewM to N Dwowoo00� OMMrle �tDre'Mrrle NMM ti O N 1.�. a D Ole et CC G a. G vi Vl EA to Gel Vj F- ? N M el Nr� N a0w � CO) LLB O CO) wa ❑ a. W N 6,6es40 6j)- 4f,�v). 64rV) -6e sr is 6964W 6At&40 ja 6tato to tOOco OcI le M C IL W ❑ a W o'M O N O O r N � N� N N N O r O lh Cl) N G> le N tD etl CO - LL W 0 N a T" w N DD O O 0 Ol M 0 Z m Q r 00 to Z _ Z 0 Z O � LL0 00 OG N U O W � W13J tAQ LL U)A W } a. J �Z J }gaZQQV J x J J J J U) �_ J J w O z 0 w– z w Q Qa �(� �waaaa <-ip O(.) -Qaa �Ot9 00 0OVwZ -' - z()Iwi >- a LL wxow J�O�W wW LLa. wmwwww_ Jmo���gvxx2ILo0m2ILaZV��z� ZwWW0- -- zzz(� Mz95ara� wW } �� c7 0! Oa22x Z� (7�vn�22�w()()>OZ2?u:VZ w w U 7 z– a' W m O W a U)aWO0 w 0 P z FnzWt)0(.)( w w O O O w J LuE2(LW J 0– W aw0.0avnu.m�u5a W W W W 0 AGENDA ITEM # 4A JULY 8, 2013 PREPARED 6/16/13, 8:05:50 LICENSE ACTIVITY REPORT BY BUSINESS NAME City of Atlantic Beach NEW LICENSES FOR YEAR: 2013 BETWEEN: 05/01/13 TO 05/31/13 PROGRAM OL122L DEPT: ALL DEPARTMENTS CLASS: ALL CLASSES -------- - - - - -- — --------------------------------------------------------------------------------------------- LIC # BUSINESS NAME ISSUED TYPE CLASSIFICATION BUSINESS ADDRESS 0 BR: BUS PHONE # 13- 00007673 ADVANCED COOLING TOWER SYSTEMS 5/20/13 NEW MISCELLANEOUS SALES, OTHER THAN LIST 343 AHERN ST 15 904 - 249 -0303 ATLANTIC BEACH.FL 32233 13- 00007697 AUTO SALON MOBILE DETAILING 5/2B/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS 30 ARDELLA RD 904 -2B8 -1384 ATLANTIC BEACH FL 32233 13- 00007706 BASKIN PRESSURE WASHING AND DE 5/31/13 NEW MISC. SERVICE ESTABLISHMENT, NOT LIS 1111 SCHEIDEL CT 904 -629 -1179' ATLANTIC BEACH FL 32233 13- 00007687 CANTINA MAYA SPORTS BAR & GRIL 5/20/13 NEW RESTAURANTS(INC. SNACK BARS & TAKE 0 1021 ATLANTIC BLVD 904- 247 -3227 ATLANTIC BEACH FL 32233 13- 000076B1 HEALTHY BEACH GIRL 5/20/13 NEW CONSULTANT, NOT OTHERWISE CLASSIFIED 2236 BAREFOOT TRAC 904- 885 -2152 ATLANTIC BEACH FL 32233 13- 00007702 HORIZON INNOVATIONS 5/21/13 NEW SOLICITATION, DOOR TO DOOR OUTSIDE CITY 904 - 525 -5419 ATLANTIC BEACH FL 32233 13- 00007703 HORIZON INNOVATIONS 5/21/13 NEW SOLICITATION, DOOR TO DOOR OUTSIDE CITY 904 -525 -5419 ATLANTIC BEACH FL 32233 13- 00007664 JURIJ P. OZIMKOVSKI 5/20/13 NEW AUTO: CAR WASH 1110 MAYPORT RD 904- 742 -0642 ATLANTIC BEACH FL 32233 13- 00007698 MATHIEU BUILDERS 5/20/13 NEW BUILDING CONTRACTOR (FIRM /CORP.) 675 ATLANTIC BLVD 681 904 - 813 -3661 ATLANTIC BEACH FL 32233 13- 00007700 MATHIEU BUILDERS 5/20/13 NEW BUILDING CONTRACTOR 675 ATLANTIC BLVD 681 904- 813 -3661 ATLANTIC BEACH FL 32233 13- 00007704 MAYPORT WIRELESS INC 5/2B/13 NEW COMMUNICATIONS EQPT. /CELL PHONES /BEE 1197 MAYPORT RD 904- 755 -8236 ATLANTIC BEACH FL 32233 13- 00007701 RLC BUILDING INC. 5/20/13 NEW MINOR CONTRACTOR (MISC. ODD JOBS /REP B01 JASMINE ST 904 - 704 -5614 ATLANTIC BEACH FL 32233 13- 00007680 SUBWAY #B32 5/20/13 NEW RESTAURANTS(INC. SNACK BARS & TAKE 0 469 ATLANTIC BLVD UNIT 13 904 - 247 -6B48 ATLANTIC BEACH FL 32233 13- 00007682 WONDERFULLY LONG MASSAGE 5/20/13 NEW MASSAGE ESTABLISHMENT 535 ATLANTIC BLVD 904- 563 -2583 ATLANTIC BEACH FL 32233 13- 00007683 WONDERFULLY LONG MASSAGE 5/20/13 NEW MASSAGE THERAPIST 535 ATLANTIC BLVD 904 - 563 -2583 ATLANTIC BEACH FL 32233 GRAND TOTALS -------- - - - - -- NEW LICENSES ------- - - - - -- AC: 15 PP: 0 IN: 0 V0: 0 PG: 0 BR: 0 OB: 0 UC: 0 LIC: 15 AGENDA ITEM # 4A JULY 8, 2013 City of Atlantic Beach, Fl. Utility Sales Report L May 2013 May 2012 MHONtix .t , _ } _ Gallons Actual Revenue Gallons Actual Revenue x Water Sales Accounts 0000 Revenue Per 1,000 g1 Accounts 0000 Revenue Per o0o gi a Atlantic Beach 5,617 38,044 $141,588 $3.72 5,610 41,721 $153,260 $3.67 Buccaneer � 2,469 17,024 $87,170 $5.12 2,453 15,928 $85,406 $536 Total Water Sales 8,086 55,068 $228,758 $4.15'--1 8,063 57,649 $238,666 $4.14 NO - 1"Yyr� „,r.'^.`:..+�, -x_. 1�.. w.....e ,.r , r.+-4> ..�_ . ->z.. vi.„ , m.. '� o., ,-, r=' /',.d ..__n...� %- ..�... -4 'm- =sr,, ..,:.r✓ .,.- >._- v.; --z�: Gallons Gallons Water Plant Production 0000 0000 Atlantic Beach 47,119 53,177 Buccaneer 18,078 21,023 Total Production 65,197 74,200 Total Water Billed 55,068 57,649 C Water Loss for month: 10,129 16,551 Percentage Loss 15.54% iffl 22.31% Total 12 mo. Avg. Loss r N 10.78% r 16.73% N NA Gallons Actual Revenue Gallons Actual Revenue Sewer Sales Accounts 0000 Revenue Per 1,000 gi Accounts 0000 Revenue Per 1,000 gi r� Atlantic Beach 5,204 31,889 $240,554 $7.54 5,194 32,809 $243,210 $7.41 Buccaneer 2,361 18,727 $177,670 $9.49 2,350 18,233 $173,534 $9.52", Total Sewer Sales ,ffl 7,565 50,616 $418,224 $8.26, 7,544 51,042 $416,744 $8.16111111- Actual Revenue Gallons Actual Revenue Gallons Sewer Treatment 0000 Revenue Per 1,000 gi 0000 Revenue Per 1,000 gi Atlantic Beach 62.024 $418,224 $6.74 38.051 $243,210 $6 39 16.129 $173,534 $10.76 1 Total Sewer Treated 62.024 $418,224 $6.74 54.180 $416,744 $7.69