Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2008 10-20 CCP Joint Work Session with Financial Commission
AGENDA JOINT MEETING CITY COUNCIL AND FINANCIAL COMMISSION OCTOBER 20, 2008 COUNCIL CHAMBERS CITY HALL 6:30 P.M. 1. Call to Order 2. Budget Review Enterprise Funds a. Water Utility Fund b. Sanitary Sewer Utility Fund c. Storm Drainage Utility Fund d. Street Light Utility Fund e. Recycling Fund Centerbrook Golf Course Fund g. Liquor Operations Fund h. Earle Brown Heritage Center Fund 3. Adjourn Budgets remaining for first review November 17, 2008 Capital Improvements Plan Capital Proj ect Funds o Capital Improvements Fund o Municipal State Aid Fund o Infrastructure Construction Fund o EBHC Capital Projects Fund o Street Reconstruction Fund o Technology Fund Internal Service Funds Special Revenue Funds I .*v,� 3 ��M,,, x T �F n.; f x �r. 3 A.. s ��E r.,_.. g �x. ���s, a �FU .r..,.. F<� i:?� r .3�, r .,..a a 3 ..6. �i :3'� M a. �a.. ,5 8 A E.,h,. �i s .4. 3 k:-.., n: ;ui� .r:. S.` r _r i x �s�,..... .c,. s� 13 3 3 35..; 4��a r �a`^ .N..:�.:: 3 s ,.:,.:,.r �t �:;,,i� q� E z�' r_, n' 1 ��Y.: i ..s.,..,.,. 1 f .w��,; A �y,.,;::: m^., .i. a.,:�. v. /��i ..�u ...r .,2.. v.a;; ".v F 1 F .:.m: v Y... �.,•„...,fi"'F', t fl �Z ..,....,,a s 3 .43' v I �.k:, ^�""bR 4d.,.�?„/, i:»,.. �;:'iv... r. �l .u... ...a*��.., ,,...a� .n e ::Y'._ .�..,,.a. .y,..,:,.�wj 1 -a3 .y x, .,.5�]^ ,I k v a. Y„ ..u. ,a, .,3r S .�r�� �i a.. 4�., y 3 1' d, r. t „�7P ,...3.. i r c� s..,A".,�r,,.. .f ,��,,.f ,...o ...v�4. �e "i3' Z:.. i�. 3 yZy ',',Sa_.. F 3 ;3, S-'; •4.,.. .��.,,t 'Y., ....n. ,,,3x x.�.: ...'t� :b` sF n...,Y .,,nl.. n. �3 ...,�l, 9, �'s�Z d... �G ..?i �x., 4�.: u ...x ,1 .a.. n'r. n F �.�i, Y "2'�,s .m... i....;.,.. Tu ,.i,. n h,. f ...r'.�, v s �::.5 :f.x€ „r.. Er,..... a,..� �,+�w._�. .r,1i 3 s�., ,v..;,�:� ."A,,, ...,tl.. H. ..r,. a�;�.:, ,c. Ft,a. �..t� r o L .4. b ar r. w� w�, d r ,.a ,n�. �.:1� a r 3 n ..r.,, i H .3 I y� Y A£'� ,.y ay, l k ,xr3�.;.� .k.. :.;q Z, t e,. ...N' ,r:...-€ n ,.1� z•.:. I} �.�v. f,.,-:,.. �3,.�m:� I::. A �..c:ea 4'� sN,„ c r 7 a.x t....' �.....,.�d >5w �3�'.. •1' z q, nt ;.sT" r_.a k �,.,..,r.... F ,i. .5...a ,f a� .,L a 3,� �56 e.� 3mm�+ 2" l a� �i-, i ,Fz, 9. ,c.. .a g� .,,t�„ ,311�,. �,z,� ��13 ,.r�^!. �Y ,Y� .�..3 C 3� .s`. ?r�,. f,� 1: a� 3� t a�..: �:=a� ,;:�:w�`,�:! ,n± ._;z?z. ..7 L c i`'. 9 a .x'�i ..,�1��,' S ��.R F:,<, t �k.,.� „�Yi d s dl t .:�ri.. 3... .§r.: a� �'r a.,,.. d 3 eE.� �i.... k� n t ...,-.y,:.>,.....,. k ..x.n ._t.,-',".,,. „r..�: M.. �,a .�x,e,r i r .�•..:z x F�. r, t:,.: z;.� :.u� .,3 ,,v ;e r ,v.,,. s..,. z� ..s =.s,� n�:�� ."..'i. .m a ,p,,. „a:..�.� e� P:-.: ..c,g.�,.,a�• �ai,. k .,�:a '�s�.,: o.,- �isa�<. J•�. ..3-. ..�c�.,.., z:x.,P's,Y�; ...,,F3.� r e �'-�_R_ ,s a,s 1', 1 �z,;:,�. 1, s .>a, ,�T: 9 .F e r.,_ -:z v;,.., �f ,i �"3., z g rkN':� _.:,sx ?.c,s n. .�_3 f z,. x. t�..�' r�., E�,�.:.. .v �r �..,c; 'b 3 i� v�:..:: t .3; N,�:� .;t'Y,,;;• R �e'�.�<:�E, 9 k'.: y, r; f.. v g, n�_ ,s.i �,+�„i�i, i '�'R .6-,. .c�a 57. ��3 ,.i,y,' a .:;i v.� "$r.:. z,r.s :n,;i rd z`1,.;� :✓f,�. ��^e ,I.s. �V Y',�; �;r, ;���F�a 3 .,y`��, .P l. F .a,',fr' ti �,s�,� d. ,�;,,,1 ,g ,Z� r .�a t. ru i��. c 5... .,.a a f r s ,t .,x �.w �Fr Yy 5 m a w� .z�'� «'r, r,�'��,; =,z� f .Nr .s�P4, ,3;a 'f a� «�a' i a`�:. a d�' t� "r. a a- d §b 3. .':"YSffs' i S. �5 f i�1 ....5� h- �i, a ���.,t a�,'. a x `kv-- ti 1 "�a.. a..y, �,v. _xs,� s 't �fl J�;. .sl:� s �.n� nt.9> r f .�».n s:�3 +Y '3 3� 3' 1R H"5�/� 3^ .6 J. R', 'F F�. ,�z! Y �fA ,3„ '��3:. �S�f?:-� "A, mK t:.9 �`'�i1' i y Y„�., .a s:,'- ,S a:: .d�e 3 i� W �x s,�� �s a� a. �.�.a a., i 3 �i.�.. <rc? `�5 i? �3. ...k a'�A3 /r.. Ya:, z k... .�:c��✓ ,n�,, 371 ,3„ ;�.a m7 ».a.. 51 �f'. ,N�.:��.Y ,_,..;r,�.�. �s� ;?x_._.., .,a,: x s �h .....,�i �f,.��'^ �.�,f ._..7;..,..?.' '.l 3 ..,n..,�. q, ...,6 .3 b. 3. n�... t ,i.. ti,..a .u: 3 Y�%' 1 u .:;0¢ 'L/ �a', ..",M,,, f. 3.� :..9 ..I.. .Cu.a ..3 i� �3 e N� S` ...x.,.¢,:��- S'. r>' k.:... .1 i,. ib.,.3...._. �b h" .nr: „r..' 'a. A �t d �T,.:� l:?'1J' ';i �R�i .H� .$il�.. .Ik. ...:s�, r� �'a .`�3 .T�3 :..•�n� 4 .'i�! a '�.::E''.�E •:`�.)X' e 4 r E:.. ...��r:, i.., >,.3` ,;�i� iYw s d< 1 »:.y„ �a y s�' e» J �1.,...n. .o„uu ?u�st �Ye.e. j w ,,,c ,..0 „'i, °U,.. 3..r 7 �S" „a t v.:. xa..:.. i.. s.�. .f. �r y.t� ,o-,,. t'Y'� �a� i ..�.f 3 dz.� u., r a.. ,'a*.,, _a �7i� S� .�u... .a�.;r .,.1s" ;..,a 9.0 t�� a >ar. r t �i� s 3 a s ,E.�! *3 ."a'.S' 5 >J, ..F��' a>.s�. »3 i t .a f,.. C: Jp.. ,N �b.,..< .:�N v i A ::.E a.. �R. .i:' z x.. �,o.v:, �.n�. o ,.,..rt 'S -3 �.y'�""3. .��1 "c� �y �I';i .�I,.. ,1».v .,,..J ""i x a r..;• m,-..� Sr�.� n ,_s,..,.. ka,,, -�.al 3,. .0 a "ti,ar: :=,..a. d:'...;t r .�3 ..i�`, �s,';.� y, •c ,:.sv s,::.. .:x� ;.3> ;:.s;,; *F; ..f:r� w.,.� ,.:,,x, w .a. J.,_ ,�,5�,. i �d. a:' vti"'� ,.:or �:.fr.�.,.�i' .M� �`a 1� �.;u 7 1 a v 4 i_s ?3. 'F x:::,S �i. ;7-.rr�;, 3 ...,:�n si',.,,:'" r�,_ d f�Y X „^•r<:, K. I�,�n ,t�; t f� ,a,�� ,,,r, E a ..�s. az i�� 1 r .r,� �w lr ,k�r,.. r�:. ,t _a¢. -m.� r, a� 3, ,3„. u. �.r .1 '�9 r... 'r z .'�...v ,4�, +a... ..n fA 3.. a... �i .,:xu fii. l n= n`� 3 '3'� �Sa' ,',d f x e... e,.. ,..a. n ."�t 1',', l ;z. S 3 3�'�'% 2 ..:r�. '4 I�. ...,��ir k d ae.^,:�+r,� C �r.3:.., �....3 u r,✓ �«...�ll? �'�ii ....,h>u a 3 A, s..., �4- ..s z,'., x:_.;;�, r M;:'; 3 i� �`M'�;�, �9q�; i... if t �i e>> .,'r.,, ���F. �it��.� �'i;,... .ra� p r r a %�S �.u,� r, i :a: "-5�:... ,�v :.:.s�'�' z:.:.:i P�:;����.�� a"... r.�, 3�, a ._a .�...c.-- ..a. a w, i S ^a :...�v sY' 1'�^�z°a*r ^u�` 3 '�..i.. �b.�� �3a ,a.�'�.wa .F.�'� r� r. Cit of Brookyn Center y for the fiiscal year ending December 31, 2009 a Enter r se Funds p Enter rise Funds are funds that c �ar e fees as t �eir primary p g source of revenues. n return, some type of direct product or service is rovided. Genera y, Enterprise Fund fees cover p the costs of providing Enterprise Fund services. �1► �a Enter r se Fu nds p Uti ity Funds Wate r Sanitary Sewer Storm Drainage or Storm Sewer Street Li hts g Recycling Centerbrook Gof Course BC Liquor Eare Brown Heritage Center 3 F n Water �.t t u d y Pump, treat and de ivercean, potab e waterto residents and businesses. Wells Fluoride and Chlorine treatments Water Tower Storage Trunk lines and Mains for distribution Hydrants for emergency access and maintenance 4 W ter .�t� �t Fu nd a y Staffi ng Supervisor of Public Utilities (1) Maintenance II Technicians (4) Seasonal/Part-time staffing (3) Engineering Technician Utility Billing services provided by Fiscal Support Services department 5 r �t Fund Wate t y 2009 Water Uti ity ssues Rising cost of treatment chemicals Unknowns in maintenance of wells Time and effort forAutomated Meter Reading project Capita Projects Aldrich Neighborhood 205,000 Watermain Replacement 190,000 Capital Bldg Maintenance 56,100 6 Water Cash Flows Rate Increase 3.00% 7.25% 6.25% 3.00'� 5.75% 5J5% 10.00% 6.00% 6.25% Rate/1,000 gallons 1.11 1.19 1.25 1.29 1.36 1.44 1.58 1.68 1.78 Actuai Actual Estimated Proposed Projected Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 2014 Revenues Water Service 1,464,236 1,677,557 1,630,628 1,679,547 1,776,121 1,878,248 2,066,073 2,190,037 2,326,914 Misc.Operating 433,742 387,726 348,958 352,658 356,358 360,058 363,758 367,458 371,158 Misc. Non-operating 75,753 77,315 59,477 49,606 72,263 57,786 52,911 48,182 42,673 Total Revenues 1,973,731 2,142,598 2,039,063 2,081,811 2,204,742 2,296,091 2,482,741 2,605,677 2,740,745 Expenditu res Personal Services 377,214 425,870 442,905 457,508 475,808 494,841 514,634 535,220 556,628 Supplies 142,842 156,404 161,096 164,185 169,111 174,184 179,409 184,792 190,335 I Services 408,602 549,129 565,603 593,883 623,577 654,756 687,494 721,869 757,962 �I Depreciation 578,159 586,462 610,214 644,800 660,920 677,443 694,379 711,739 729,532 Debt Service Interest Fees 112,125 108,891 103,500 97,679 91,425 Total Expenditures 1,506,817 1,717,865 1,779,818 1,860,376 2,041,541 2,110,115 2,179,417 2,251,297 2,325,883 less: Non-Cash Depreciation 578,159 586,462 610 644,800 660,920 677,443 694,379 711,739 729,532 plus: Debt Service Principal 56,250 93,750 101,250 108,750 112,500 pius: Transfers 259,678 89,582 plus: Cash Capital Outlay 692,064 576,661 954,000 441,705 1.250.463 932,171 1,054,065 1.140,996 1.076,319 Total Cash Requirement 1,880,400 1,797,646 2,123,604 1,657,281 2.687,334 2,458,593 2-640.352 2,789,305 2,785,170 Beginning Cash Balance 1,718,178 1,811,509 2,068,788 1,984,247 2,408,777 1,926,185 1,763,684 1,606,073 1,422,445 Changes in Assets/Liabilities (87,673) Cash Received 1,973,731 2,142,598 2,039,063 2,081,811 2,204,742 2,296,091 2,482,741 2,605,677 2,740,745 Cash Spent (1,880,400) (1,797,646) (2,123,604} (1,657,281) (2,687,334) (2,458,593) (2,640,352) (2,789,305) (2,785,170) Ending Cash Balance 1,811,509 2,068,788 1,984,247 2,408,777 1,926,185 1,763,684 1,606,073 1,422,445 1,378,020 Cash ReserveTarget(step) 1,000,000 1,000,000 1,000,000 1,000,000 1,200,000 1,200,000 1,300,000 1,300,000 1,300,000 Cash ReserveTarget(5%/yr) 1,000,000 1,050,000 1,102,500 1,157,625 1,215,506 1,276,282 1,340,096 7 Water Rate per 1,000 Gallons $2.40 $2.20 $2.00 $1.80 I I �1.60 $t.40 $1.20 $1.00 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 20t6 2017 2018 2019 2020 2021 2022 2023 0% 3% 6.25% 8 Water Fund Cash Changes ��,000,000 $soo,000 �r $600,000 'f ��s d �3„ $400,000 e t ��k� I� I 'L h; y 3� v 1 �s� i 3 �tl �20����� k �ut I fN E p„ r '�3 ^r u c 3,:> aa� „�s 3 :5,a 3:: ".a -:.F.: E,; ,�`:.ri &;,;.v ,;;v', ...s b",� ..i� re �a� 3. s'�� i'.�"� r F Y�' f 3 r,. .�.,,.r �.�a�� /.x 'ti �'v�'�' a w Y f v .ila �Y' rc.:s ��2�����0� ��'r w^ x t $(400,000) $(600,000) 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 9 Sa n ta r Sewer .�t Fu nd y y Co ect wastewater from residents and businesses Convey wastewater to N etropo itan Counci Environmenta Services for treatment Mains and trunks Force mains Lift stations 10 Sa n�ta r Sewe r,� t� �t Fu n d y y Staffing: Maintenance II Technicians (2) Seasonal/Part-time Staffing (2) Engineering Technician Utility Billing services provided by Fiscal Support Services department 11 w r t� �t Fu n d San tar Se e y y 2009 Sanitary Sewer Uti ity issu�s: 3.9% increase in MCES charges Reline 27" concrete main along Mississippi River Capita Projects Aldrich Neighborhood 285,000 Sewer Lining at 694 51,000 Bypass for Lift Station #6 102,000 Capital Bldg Maintenance 19,900 12 Sanitary Sewer Cash Flows Rate Increase 2.80% 2J5% 2.00'� 1.00'� 1.00'� 4.00% 4.00% 4.00% 4.00% Monthty Residential Fee 19.82 20.37 20.87 21.08 21.29 22.14 23.03 23.95 24.99 Actual Actual Estimated Proposed Projected Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 2014 Revenues Sewer Charges 2,910,510 3,411,210 3,141,800 3,173,218 3,204,950 3,333,148 3,466,474 3,605,133 3,749,338 Misc.Operating 93,811 117,939 72,805 12,000 12,000 12,000 12,000 12,000 12,000 Misc. Non-operating 106,275 462,149 61,301 57,607 66,693 44,918 35,789 45,061 33,823 Total Revenues 3,110,596 3,991,298 3,275,906 3,242,825 $'�,283,643 3,390,066 3,514,263 3,662,195 3,795,161 Expenditures Personal Services 147,615 170,587 178,263 186,285 193,737 201,486 209,546 217,927 226,645 Supplies 11,466 16,262 16,750 25,616 26,384 27,176 27,991 28,831 29,696 Services 1,958,604 2,784,515 2,423,763 2,324,499 2,394,234 2,466,061 2,540,043 2,616,244 2,694,731 Depreciation 503,231 525,655 552,540 577,900 515,000 515,000 515,000 515,000 515,000 Debt Service Interest Fees 37,375 36,297 34,500 32,560 30,475 Total Expenditures 2,620,916 3,497,019 3,171,316 3,114,300 3,166,730 3,246,020 3,327,080 3,410,563 3,496,547 less: Non-Cash Depreciation 503,231 525,655 552,540 577,900 515,000 515,000 515,000 515,000 515,000 pius: Debt Service Principal 18,750 31,250 33,750 36,250 37,500 plus: CashCapitalOutlay 658,069 436,649 1,201,000 403,565 1,339,002 932,089 359,359 1,105,000 1,12Q748 Total Cash Requirement 2,775,754 3,408,013 3,819,776 2,939,965 4,009,482 3,694,359 3,205,189 4,036,813 4,139,795 Beginning Cash Balance 1,597,283 1,926,733 2,464,116 1,920,246 2,223,106 1,497,267 1,192,974 1,502,049 1,127,431 �I Changes in Assets/Liabilities (5,392) (45,902) Cash Received 3,110,596 3,991,298 3,275,906 3,242,825 3,283,643 3,390,066 3,514,263 3,662,195 3,795,161 I Cash Spent (2,775,754) (3,408.0131 (3,819,776) (2,939,965) (4,009,4821 (3,694,359) (3,205,189) (4,036,813) (4,139,795) 4 4116 1 920 246 2 223106 1 497,267 1,192,974 1,502,049 1,127,431 782,797 in C sh Balance 1 926 733 2 6 End g a Cash Reserve Target 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 Cash Reserve Target (5°/a/yr) 950,000 997,500 1,047,375 1,099,744 1,154,731 1,212,467 13 Monthly Residential Sanitary Sewer Rates $31.00 29.00 27.00 25.00 23.00 $21.00 $19.00 $17.00 I $15.00 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 20t6 2017 2018 2019 2020 2021 2022 2023 3% 0% 1% 14 Sewer Fund Cash Changes 800,000 $600,000 �400,000 $200,000 i $(200,000) $(400,000) $(600,000) I �I (800,000) 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 15 Storm �ra na e �t t Fu nd y Co ect and passive y treat surface water runoff in ponds and structures Inlets and grates Mains and trunks Treatment structures Ponds Settlement structures i Com iance wit� State and Federa requirements p Street sweeping 16 Storm �ra na e �t t Fu nd y Staffing: Maintenance I I Technician (1) Engineering Technician Ut�lity Billing services provided by Fiscal Support Services department 17 I Sto r m ra na e..t t Fu nd y 2009 Storm Drainage Uti ity issues: Maintain cash flows in years of high cash use Capita Projects Aldrich Neighborhood $1,447,000 Twin Ryan Lakes Water 165,800 Dredge two retention ponds 110,000 18 Storm Drainage Cas� Flows Rate Increase 0.00% 4.00'� 7.00'� 3.00% 3:00% 3.00% 0.00% 0.00% 3.00% Per Residentiai Lot 11.85 12.86 13.78 14.19 14.62 15.06 15.06 15.06 15.51 Actual Actual Estimated Proposed Projected Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 2014 Revenues Storm Sewer Fees 1,273,153 1,413,605 1,512,557 1,557,934 1,604,672 1,652,812 1,652,812 1,652,812 1,702,397 Misc.Operating Misc. Non-operating 70,739 92,298 45.000 10-000 10,000 10,000 10,000 10.000 10,000 Total Revenues 1,343,892 1,505,903 1,557,557 1,567,934 1,614,672 1,662,812 1,662,812 1,662,812 1,712,397 Expenditures Personal Services 59,048 85,590 95,179 87,190 91,550 96,127 100,933 105,980 111,279 Supplies 18,638 9,626 10,778 11,101 11,434 11,777 12,131 12,495 12,869 Services 342,637 194,737 231,397 238,339 245,489 252,854 260,439 268,253 276,300 Depreciation 540,962 734,525 762,145 838,360 863,511 889,416 916,099 943,582 971,889 Debt Service Interest Fees Total Expenditures 961,285 1,024,478 1,099,499 1,174,990 1,211,984 1,250,174 1,289,602 1,330,309 1,372,338 less: Non-Cash Depreciation 540,962 734,525 762,145 838,360 863,511 889,416 916,099 943,582 971,889 plus: Cash Transfer to GF 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 plus: Debt Service Principal plus: Cash Capital Outlay 571,589 1,090,487 1,145,000 1,722,800 1,826,000 1,011,000 950,000 895,000 1,034,000 Total Cash Requirement 1,091,912 1,480,440 1,582,354 2,159,430 2,274,473 1,471,758 1,423,503 1,381,727 1,534,449 Beginning Cash Balance 1,060,877 1,353,496 1,380,820 1,356,023 764,527 104,726 295,780 535,089 816,174 Changes in Assets/Liabilities 40,639 1,861 Cash Received 1,343,892 1,505,903 1,557,557 1,567,934 1,614,672 1,662,812 1,662,812 1,662,812 1,712,397 CashSperrt (1,091,912) (1,480,440) (1,582,354) (2,159,430) (2,274,473) (1,471,758) (1,423,503) (1,381,727) (1,534,449) Ending Cash Balance 1,353,496 1,380,820 1,356,023 764,527 104,726 295,780 535,089 816,174 994,122 Cash Reserve Target 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 19 Storm Water Charges per residential lot per quarter $19.00 $18.00 �17.00 $16.00 I $15.00 I I $14.00 $13.00 $12.00 $11.00 �10.00 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2008 Plan 2009 Plan 2� Storm Water Fund Cash Changes $1,500,000 $1,000,000 $500,000 I S- 'w°r I $(500,000) $(1,000,000) 2006 2007 2008 2009 2010 2011 2012 20t3 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 21 Street ht t t Fu n d y Accounts for street i �t maintenance and uti ity use for ights g owned by Xce Energy (about 879). Operation and maintenance of City owned street ights (about 109) Operation and maintenance of ornamenta street ights on Brookyn Bou evard, Shing e Creek Parkway, Eare Brown Drive and Xerxes Avenue (about 203) 22 Street ht t� �t Fu n d y Staffi ng no staff are assigned to this activity 2009 Street Li ht Uti ity issues: g Maintain ornamental inventory Standardization of ornamental light fixture style Capita Projects Aldrich Neighborhood 38,000 23 Street Light Cash Flows Rate Increase 7.50% 5.00'� 5.00% 2.00'� 3.00% 3.00'� 3.00% 2.00% 2.00% Quarterly Rate per Dweiiing Unit 3.48 3.65 3.73 3.84 3.95 4.07 4.15 4.24 Actual Actual Estimated Proposed Projected Projected Projecfed Projeded Projected 2006 2007 2008 2009 2010 2011 2012 2013 2014 Revenues Street Light Fee 220,801 234,828 241,216 246,040 253,422 261,024 268,855 274,232 279,717 Misc.Operating Misc. Non-operating 5,625 7,669 7,500 4,000 4,000 4,000 4 000 4,000 4,000 Total Revenues 226,426 242,497 248,716 250,040 257,422 265,024 272,855 278,232 283,717 Expenditures Personal Services Supplies 794 822 2,900 2,987 3,077 3,169 3,264 3,362 3,463 Services 183,033 163,013 188,269 193,917 199,735 205,727 211,898 218,255 224,803 Depreciation Debt Service or Transfer Total Expenditures 183,827 163,835 191,169 196,904 202,811 208,896 215,162 221,617 228,266 Capital Outlay 31,296 26,810 71,400 38,000 78,000 67,000 40,000 79,000 52,000 TotalCash Requirement 215,123 190,645 262,569 234,904 280,811 275,896 255,162 300617 280,266 Beginning Cash Balance 90,936 102,239 154,091 140,238 155,374 131,985 121,113 138,806 196,420 Changes in Assets/Liabilities Revenues 226,426 242,497 248,716 250,040 257,422 265,024 272,855 278,232 283,717 Expenditures (215,123) (190,645) (262,569) (234,904) (280,811) (275,896) (255,162) (300,617) (280,266) Depreciation Add-Back I Ending Cash Balance 102,239 154,091 140,238 155,374 131,985 121,113 138,806 116,420 119,871 Cash Reserve Target 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 24 R n t� �t Fu n d ecy.c y Operates t�e City's recyc ing program in cooperation with Brook n Park, New Hope and Crysta Hennepin Recyc ing Y Group (HRG) Staffing: No personnel are assigned to this activity 25 Rec c n t t Fu n d y y 2009 Recyc ing Utility issues: Possible inclusion of the curbside cleanup collection in Brooklyn Center fees Staff is assemblin information about the costs and benefits of g the annual curbside cleanup program Estimated additional cost is $11.00 to $12.00 per year per household 26 Recycling Cash Flows Rate increase 5.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Quarteriy Residential Rate 7.35 7.57 7.80 8.03 8.27 8.52 8.78 Actual Actual Estimated Proposed Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 i Revenues Recycling Fee 242,588 251,886 257,362 265,083 273,035 281,226 289,663 298,353 Misc.Operating Misc. Non-operating 1,409 1,069 1,200 1,200 1,2fl0 1,200 1,200 1,200 Tot�al Revenues 243,997 252,955 258,562 266,283 274,235 282,426 290,863 299,553 i i Expend itu res Personal Services Supplies Services 245,852 257,615 258,458 266,212 274,198 282,424 290,897 299,624 Depreciation Debt Service Total Expenditures 245,852 257,615 258,458 266,212 274,198 282,424 290,897 299,624 CapitalOutlay Total Cash Requirement 245,852 257,615 258,458 266,212 274,198 282,424 290,897 299,624 I I I Beginning Cash Balance 15,068 5,429 769 873 944 981 984 950 Changes in Assets/Liabilities (7,784) Revenues 243,997 252,955 258,562 266,283 274,235 282,426 290,863 299,553 Expenditures (245,852) (257,615) (258,458) (266,�12) (274,198) (282,424) (290,897) (299,624) Depreciation Add-Back Ending Cash Balance 5,429 769 873 944 981 984 950 880 Cash Reserve Target 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 27 Centerbrook Go f Cou rse Fu nd Public recreational amenity; 9 hole executive golf course built in 1987 21,000 to 25,000 rounds of golf played each year. 2009 budget built on 22,000 rounds Began running the beer concession at the annual Dudley softball tournament to supplement income for the Fund Outstanding Capital Fund amount; 792,488 2009 Centerbrook issues: Capital investment in the course and buildings Increasing the number of rounds •W eather •Price sensitivity •Leagues Zs Centerbrook Cash Flows Actual Actual Estimated Proposed Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 Revenues Course Fees 250,339 252,620 254,091 274,000 295,000 295,000 295,000 295,000 Misc.Operating 118 Misc. Non-operatmg 51,357 3,445 1,005 1,200 1,200 1,200 1,200 1,200 Total Revenues 301,696 256,183 255,096 275,200 296,200 296,200 296,200 296,200 Expenditures Personal Services 130,070 139,027 136,160 140,245 144,452 148,786 153,249 157,847 Supplies 14,895 18,243 14,225 14,652 15,091 15,544 16,010 16,491 Services 113,929 103,203 106,346 109,536 112,822 116,207 119,693 123,284 Depreciation 27,170 27,170 27,194 27,738 28,293 28,858 29,436 30,024 Debt Transfer 7,512 Total Expenditures 293,576 287,643 283,925 292,171 300,659 309,395 318,389 327,646 CapitalOutlay 26,475 28,000 18,�00 27,000 24,900 16,000 16,000 Total Cash Requirement 293,576 314,118 311,925 310,671 327,659 334,295 334,389 343,646 Beginning Cash Balance 46,249 81,900 50,970 21,335 13,602 10,436 1,199 (7,554) Changes in Assets/Liabilities 361 (165) Revenues 301,696 256,183 255,096 275,200 296,200 296,200 296,200 296,200 Expenditures (293,576) (314,118) (311,925) (310,671) (327,659) (334,295) (334,389) (343,646) Depreciation Add-Back 27,170 27,170 27,194 27,738 28,293 28,858 29,436 30,024 Ending Cash Balance 81,900 50,970 21,335 13,602 10,436 1,199 (7,554) (24,975) 29 BC uor Fu nd a Operate 2 retail liquor stores 5625A Xerxes Avenue (near Cub Foods.) 9 years 6930 Brooklyn Boulevard (Blvd. Market) 6 years Profits used to fund park maintenance and improvements that would otherwise be paid by property taxes 2008 and 2009 amounts allocated to fund Building Maintenance Improvements Staffi n g Liquor Operations Manager (1) Store Manager (2) Assistant Manager (1) Office Manager (1) Part-time sales and floor staff 30 r F nd BC uo u a 2009 BC Liquor issues: Replacement of cash register/inventory system hardware and software Addition of 1,350 square feet of space at Xerxes Avenue store. Additional 30,187 in rents and utilities Exercise of second ten-year option for lease No change in originally negotiated costs Savings through discounted volume purchases of product and single point shipping Wine Club growth 31 BC Liquor Cash Flows Actual Actual Estimated Proposed Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 Revenues Customer Receipts 5,159,152 5,473,017 5,690,823 5,500,000 5,555,000 5,610,550 5,666,656 5,723,322 Misc.Operating 7,894 13,275 4,385 9,800 9,800 9,800 9,800 9,800 Misc. Non-operating 37,095 53,219 32,750 24,000 29,075 30,068 30,330 29,805 Total Revenues 5,204,141 5,539,511 5,727,958 5,533,800 5,593,875 5,650,418 5,706,785 5,762,927 Expenditures PersonalServices 468,976 527,273 632,803 656,878 683,153 710,479 738,898 768,454 Supplies 25,291 24,279 31,966 60,942 62,770 64,653 66,593 68,591 Services 442,208 451,159 471,416 510,010 525,310 541,070 557,302 574,021 I Costof Good Sold 3,911,016 4,125,817 4,268,117 4,054,115 4,082,925 4,123,754 4,164,992 4,206,642 Depreciation 26,359 26,359 26,382 26,500 26,500 26,500 26,500 26,500 Debt Transfer Total Expenditures 4,873,850 5,154,887 5,430,684 5,308,445 5,380,659 5,466,456 5,554,285 5,644,208 I Capital Transfer 125,000 125,000 346,470 265,490 200,000 200,000 200,000 200,000 Total Cash Requirement 4,998,850 5,279,887 5,777,154 5,573,935 5.580,659 5,666,456 5,754,285 5,844,208 Beginning Cash Balance 720,417 949,471 1,199,465 1,176,651 1,163,016 1,202,733 1,213,195 1,192,195 Changes in Assets/Liabilities (2,596) (35,989) Revenues 5,204,141 5,539,511 5,727,958 5,533,800 5,593,875 5,650,418 5,706,785 5,762,927 Expenditures (4,998,850) (5,279,887) (5,777,154) (5,573,935) (5,580,659) (5,666,456) (5,754,285) $(5,844,208) Depreciation Add-Back 26,359 26,359 26,382 26,500 26,500 26.500 26,500 26,500 Ending Cash Balance 949,471 1,199,465 1,176,651 1,163,016 1,202,733 1,213,195 1,192,195 1,137,414 32 r Fund Ea r e Bro wn Herta e Cente An event and conference center of 36,000 square feet accommodatin roups from 20 to 2,000. gg 18 different meeting rooms Office s ace is eased to a rovider of audio/visua services p p Catering and iquor avai ab e New o portunities beginning ate in 2009 with the opening of p the Embass Suites hote adjacent to the comp ex y •"D" Barn is eased to Embass Suites for deve opment of a spa Y 33 n r Fund Ea r e B row n H e r ta e Ce te Staffi ng General Manager (1) Operations Supervisor (1) Sales Director (1) Sales Managers (2) Secretar /Rece tionist 1 I Y p C) Secretary/Billing Clerk (1) Maintenance Custodian (2) Crew Chief (1) Various Part-time stafffor event set-up and facility maintenance 34 Ea r e Brow n Her�ta e Center Fu nd 2009 Heritage Center issues: Consolidation of Inn and "D" Barn as lease op�rations Economic slowdown will affect catering revenues and some facility rentals Reexamination of Capital Replacement Plans after insurance payments for roof replacement Maintaining cash flows to the Capital Replacement Fund 35 Earle Brown Heritage Center Cash Flows Actual Actual Estimated Proposed Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 Revenues Customer Receipts 4,203,921 4,219,457 4,247,491 4,182,230 4,289,966 4,332,866 4,376,194 4,419,956 Misc.Operating 37,644 4,812 4,385 9,800 9,800 9,800 9,800 9,800 Misc. Non-operating 46,479 54,331 30,921 28,000 29 713 30,440 30,082 28,561 Total Revenues 4,288,044 4,278,600 4,282,797 4,220,030 4,329,479 4,373,105 4,416,076 4,458,317 Expenditures Personal Services 879,033 909,140 940,712 964,507 1,003,087 1,043,211 1,084,939 1,128,337 Supplies 156,069 142,428 159,855 161,500 166,345 171,335 176,475 181,770 Services 802,323 802,619 785,321 819,135 839,613 860,604 882,119 904,172 Costof Good Sold 2,128,951 2,162,075 2,162,822 2,071,487 2,091,358 2,112,272 2,133,395 2,154,729 Depreciation 578,401 577,535 578,062 26,500 26,500 26,500 26,500 26,500 Debt Transfer Total Expenditures 4,544,777 4,593,797 4,626,772 4,043,129 4,126,904 4,213,922 4,303,428 4,395,507 I Capital Transfer 300,000 230,000 200,000 200,000 200,000 200,000 200,000 200,000 Total Cash Requirement 4,844,777 4,823,797 4,826,772 4,243,129 4,326,904 4,413,922 4,503,428 4,595,507 BeginningCash Balance 1,061,898 1,141,255 1,151,030 1,185,197 1,188,518 1,217,592 1,203,276 1,142,424 Changes in Assets/Liabilities 57,689 (22,563) Revenues 4,288,044 4,278,600 4,282,797 4,220,030 4,329,479 4,373,105 4,416,076 4,458,317 Expenditures (4,844,777) (4,823,797) (4,826,772) (4,243,129) (4,326,904) (4,413,922) (4,503,428) $(4,595,507) Depreciation Add-Back 578,401 577,535 578,062 26,500 26,500 26,500 26,500 26,500 Ending Cash Balance 1,141,255 1,151,030 1,185,117 1,188,518 1,217,592 1,203,276 1,142,424 1,031,734 36 _.......__.............__.......,................................._.....................................�.........k..........._....._...........__.............. EBHC Cash Flows Before and Transfer 450,000 400,000 350,000 300,000 250,000 200,000 I 150,000 100,000 I 50,000 (50,000) (100,000) 2003 2004 2005 2006 2007 Net Cash Flow Net Cash Flow after transfer 37 Earle Brown Heritage Center Cash Balances 1,400,000 1,200,000 1,000,000 800,000 600,000 �I 400,000 200,000 L' y s��, �a s r� i. E 2Q03 2004 2005 2006 2007 l� Operating Fund Cash Capital Fund CasH 38 ues �ons ommen s ����h. .r s ��'�����Vi��� ,'�i��u F I�, w�y ,g �,4;,, i��'�V��I j i i ih i;r 3:�. .s�.cs,.�h.c ��"Y�y 39 Sc h ed u e 17 November 2408 Joint Work Session Capital Improvement Plan Capital�lmprovement Funds Internal Service Funds j Special Revenue Funds 1 December 2008 Truth in Taxation Hearing 8 December 2008 Regu ar City� Counci Meeting Adopt Final Tax Levy Adopt Final Budgets for 2009 40 City of Brooklyn Center Water Utility Cash Flows PROJECTIONS WITH BOND ISSUE FOR AMR Rate Increase 3.00% 7.25% 6.25% 3:00% 5J5% 5.75% 1b.00k 6.00% 6.25% 6.50% 6.25% 6.25% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% RateN,000gallons 1.91 1.19 1.25 1.29 1.36 1.44 1.58 1.68 1J8 1.90 202 2.14 2.14 2.14 2.14 2.]4 2.14 2.14 Actual Actual Estimated Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2006 2007 2008 2D09 2010 2011 20'12 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Revenues Water Service 1,464,236 1;677,557 1,630,628 1,679,547 1,776,121 1,878,248 2,066,073 2,190,037 2,326,914 2,478,164 2,633,049 2,797,614 2,797,614 2,797,614 2,797,614 2,797,614 2,797,614 2,797,614 Misc.Operating 433,742 387,726 348,958 352,658 356,358 360,058 363,758 367,458 371,158 374,858 378,558 362,258 385,956 389,658 393,358 397,058 404,458 408,158 Misc. Non-operating 75,753 77,315 59,477 49,606 72,263 57,786 52,911 48,182 42,673 41,341 32,322 34,690 34,217 48,037 52,393 46,873 73,438 97,730 Total Revenues 1,973,731 2,142,598 2,039,063 2,081,811 2,204,742 2,296,091 2,482,741 2,605,677 2,740,745 2,894,362 3,043,929 3,214,562 3,217,789 3,235,310 3,243,365 3,241,546 3,275,511 3,303,502 Expenditures PersonalServices 377,214 425,870 442,905 457,508 475,808 494,841 514,634 535,220 556,628 578,894 602,049 626,131 651,177 677,224 704,313 732,485 792,256 823,946 Supplies 142,842 156,404 161,096 164,185 169,111 174,184 179,409 184,792 190,335 196,045 201,927 207,985 2'14,224 220,651 227,270 234,089 248,345 255,795 Services 408,602 549,129 565,603 593,883 623,577 654,756 687,494 721,869 757,962 795,860 835,653 877,436 921,307 967,373 1,015,741 1,066,529 1,175,848 1,234,640 Depreciation 578,159 586,462 610,214 644,800 66D,920 677,443 694,379 711,739 729,532 747,770 766,465 785,626 805,267 825,399 846,033 867,184 911,086 933,863 Debt Service Interest Fees 112,12fr 108,891 103,500 97,679 9�,425 84,956 78,272 71,372 64,256 56,710 48,731 40,322 31,697 22,425 Total Expenditures 1,506,817 1,717,865 1,779,818 1,860,376 2,041,541 2,110,115 2,179,417 2,251,297 2,325,883 2,403,525 2,484,366 2,568,550 2,656,231 2,747,356 2,842,089 2,940,608 3,159,231 3,270,669 I I less: Non-Cash De preciation 576,159 586,462 610,214 644,800 660,920 677,443 694,379 7 1 1, 7 3 9 7 2 9, 5 3 2 74 7,770 7 6 6 4 6 5 7 8 5 6 2 6 8 0 5 2 6 7 8 2 5 3 9 9 8 4 6 0 3 3 8 6 7 1 8 4 9 1' 1 0 8 6 9 3 3 8 6 3 plus: Debt Service Principal 56,250 93,750 101,250 108,750 112,500 116,250 120,000 123,75D 131,250 136,750 146,250 150,000 161,250 187,500 plus: Transfers 259,678 89,582 g plus: Cash Capital Outlay 692,064 576,661 954,000 441,705 1,250,463 932,171 1,054,065 1,140,996 1,076,319 1,422,978 1,127,095 1,323,663 774,888 1,029,428 1,285,034 541,000 56,391 216,456 Total Cash Requirement 1,880,400 1,797,646 2,123,604 1.657,281 2,687,334 2,458,593 2,640,352 2.789,305 2,785,�70 3,194,983 2,964,996 3,230,337 2,757,102 3,090,135 3,427,339 2,764,424 2,465,786 2,740,762 Beginning Cash Balance $'1,718,178 1,811,509 2,066,788 1,984,247 2,408,777 1,926,185 1,763,684 1,606,073 1,422,445 1,378,020 1,077,400 7,156,332 1,140,558 1,601,245 1,746,419 1,562,444 2,447,940 3,257,664 Changes in Assets/Liabilities (87,fi73) g g g g Cash Received 1,973,73� 2,142,598 2,039,063 2,081,811 2,204,742 2,296,091 2,482,741 2,605,677 2,740,745 2,894,362 3,043,929 3,214,562 3,217,789 3,235,310 3,243,365 3,241,546 3,275,511 3,303,502 Cash Spent (1,880,400) (1,797,646) (2,123,604) (1,657,281) (2,687,334) (2,458,593) (2,640,352) (2,789,305) (2,785,170) (3,194,983) (2,964,996) (3,230,337) (2,757,102) (3,090,135) (3,427,339) (2,764,424) (2,465,786) (2,740,762) Ending Cash Balance 1,811,509 2,068,788 1,984,247 a 2,408,777 7,926,185 5 1,763,684 y 1,606,073 1,422,445 1,378,02D 1,077,400 1,156,332 S 1,140,558 E 1,601,245 1,746,419 1,562,444 3 2,039.566 S 3,257,664 3,820,404 Cash Reserve Target (step) 1,000,000 1,000,000 1,000,000 1,000,000 1,200,000 1,200,000 1,300,000 1,300,000 1,300,000 1,400,000 1,400,000 1,400,000 1,400,000 1,400,000 1,500,000 1,500,000 �,500,000 1,500,000 Cash Reserve Target (5%tyr) 1,000,000 1,050,000 7,102,500 1,157,625 1,215,506 1,276,282 1,340,096 1,407,100 1,477,455 1,551,328 1,628,895 1,710,339 1,795,856 1,885,649 2,078,928 2,182,875 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation and do not include provisions for changes in balance sheet ite from year to year that may affect cash balances. Revenues Rate increases would be as indicated each year and based on a stable customer base and stable consumption Expenditures Personnel Costs increase at a rate of 4% per year Supplies increase at a rete of 3% perannum. Services increase at a rate of 5% per year Depreciation increases at a rate of approximately 2.5% per annum. City of Brooklyn Center Sanitary Sewer Utility Cash Flows PROJECTIONS W1TH BOND ISSUE FOR AMR Rate Increase 2.80% 2.75% 2.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3:00% 3.00% 0.00% 0.00% 0.00% 0.00% Actual Actual Estimated Proposed Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Revenues SewerCharges 2,910,510 3,411,210 3,141,600 3,236,054 3,333,136 3,433,130 3,536,124 3,642,207 3,75�,474 3,864,018 3,979,938 4,099,336 4,222,316 4,348,986 4,348,986 4,348,986 4,348,986 4,348,986 Misc.Operating 93,811 117,939 72,805 12,000 12,000 12,000 12,000 12,000 12,000 12,000 72,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 Misc. Non-opereting 106,275 462,149 61,301 57,607 68,578 50,705 44,749 56,380 46,593 36,701 30,981 28,462 32,445 33,222 27,306 14,020 27,491 43,534 TotalRevenues 3,�10,596 3,991,298 3,275,906 3,305,661 3,413,714 3,495,835 3,592,873 3,710,587 3,810,067 3,912,719 4,D22,919 4,139,799 4,266,761 4,394,208 4,388,291 4,375,006 4,388,477 4,404,520 Expenditures Personal Services 147,615 170,587 178,263 186,285 193,737 201,486 209,546 217,927 226,645 235,710 245,139 254,944 265,142 275,748 286,776 298,249 310,179 322,586 Supplies 11,466 16,262 16,750 25,616 26,384 27,176 27,991 28,831 29,696 30,587 31,504 32,450 33,423 34,426 35,459 36,522 37,618 38,746 Services 1,958,604 2,784,515 2,423,763 2,324,499 2,394,234 2,466,061 2,540,043 2,616,244 2,694,731 2,775,573 2,858,641 2,944,606 3,032,944 3,123,932 3,217,650 3,314,180 3,413,605 3,516,013 Depreciation 503,231 525,655 552,540 577,900 515,000 515,000 515,000 515,000 515,000 515,000 515,000 515,000 515,000 515,000 515,000 515,000 515,000 515,000 Debt Service Interest Fees 37,375 36,297 34,500 32,560 30,475 28,319 26,091 23,791 21,419 18,903 16,244 13,441 10,566 7,475 Total Expenditures 2,620,916 3,497,019 3,171,316 3,114,300 3,166,730 3,246,020 3,327,080 3,410,563 3,496,547 3,585,190 3,676,575 3,770,791 3,667,928 3,968,009 4,07'1,130 4,177,392 4,286,968 4,399,821 less: Non-Cash Depreciation 503,231 525,655 552,540 577,900 515,000 515,000 515,000 515,000 515,000. 515,000 515,000 515,000 515,000 575,000 515,000 515,000 515,000 515,000 ptus: Debt Service Principal 18,750 31,250 33,750 36,250 37,500 38,750 40,000 41,250 43,750 46,250 48,750 50,000 53,750 62,500 plus: Cash Capital Outlay 658,069 436,649 7,201,000 403,565 1,339,002 932,089 359,359 1,105,000 1,120,748 994,464 905,303 710,000 844,189 1,092,155 1 213,575 28,025 208,275 Total Cash Requirement 2,775,754 3,408,013 3,819,776 2,939,965 4,009,482 3,694,359 3,205,189 4,036,813 4,139,795 4,103,404 4,106,678 4,007,041 4,240,867 4,591,414 4,831,131 3,925,967 3,853,743 4,155.596 Beginning Cash Balance 1,597,283 1,926,733 2,464,116 1,920,246 2,285,942 1,690,174 1,491,649 1,879,334 1,553,108 1,223,380 1,032,696 948,737 1,081,495 1,107,389 910,183 467,343 916,383 1,451,1'IS Changes in Assets/Liabilities (5,392) (45,902) g g g g Cash Received 3,110,596 3,991,298 3,275,906 3,305,661 3,413,714 3,495,835 3,592,873 3,710,567 3,810,067 3,912,719 4,022,919 4,139,799 4,266,761 4,394,208 4,388,291 4,375,006 4,388,477 4,404,520 Cash Spent (2,775,754) (3,408,013) (3,819,776) (2,939.965) (4,009,482) (3,694,359) (3,205,'189) (4,036,813) (4,139,795) (4,103,404) (4,106,878) (4,007,041) (4,240,867) (4,591,414) (4,831,131) (3,925,967) $(3,853,743) (4,155,596) Ending Cash Balance 1,926,733 2,464,116 1,920,246 2,285,942 S 1,690,174 S 1 491 649 1 879 334 5 1 553 108 7 223 380 S 1 032 696 948 737 S 1 081 495 1 107 389 910.183 S 467.343 916,383 S 1.451.118 S 1,700,042 Cash Reserve Target 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 950,000 Cash Reserve Target (5%/yr) 950,000 997,500 1,047,375 1,099,744 1,154,731 1,212,467 1,273,091 1,336,745 1,403,563 1,473,762 1,547,450 1,624,622 1,706,064 1,791,367 1,880,935 Assumptions. Cash basis All assumptions are predicted on Cash Basis presentation and do not indude provisions for changes in balance sheet items. Revenues Rate increases would be as indicated per year and are based on a stable customer base with stable usage. Expenditures Personnel costs increase at a rate of 4% per year Supplies increase at a rate of 3% per year. Serices increase at a rate of 3% per year Depreciation increases at a rate of 2% per year Capital outlay is from the 2009 CIP i City of Brooklyn Center Storm Water Utility Cash Flows Rate Increase 0.00% 4.00% 7.00% 3.00% 3.00% 3.00% 0.00% 0.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 0.00% D.00% 0.00% 0.00% Per Residential Lot 12.86 13.78 14.19 14.62 15.06 15.06 75.06 15.51 15.97 16.45 76.95 17.46 17.98 17.98 17.98 17.98 17.98 Adual Actual Estimated Proposed Projected Projected Projeded Projected Projected Projected Projeded Projected Projected Projected Projected Projected Projeded Projeded 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Revenues StormSewerFees 1,273,153 1,473,605 1,512,557 1,557,934 1,604,672 1,652,812 1,652,812 1,652,812 1,702,397 1,753,469 1,806,073 1,860,255 1,916,062 1,973,544 1,973,544 1,973,544 1,973,544 1,973,544 Misc.Operating S S Misc. Non-operating 70,739 92.298 45,000 10,000 10,000 10,000 10.000 10,000 10,000 10,000 10.000 10,000 10,000 10,000 70,000 10,000 10,000 10,000 Total Revenues 1,343,892 1,505,903 1,557,557 1,567,934 1,614,672 1,662,812 1,662,812 1,662,812 1,712,397 1,763,469 1,876,073 1,870,255 1,926,062 1,983,544 1,983,544 1,983,544 7,983,544 1,983,544 Expendltures Personal Services 59,048 85,590 95,179 87,190 91,550 96,127 t00,933 105,980 111,279 176,843 122,685 128,819 135,260 142,023 149,124 156,581 164,410 172,630 Supplies 78,638 9,626 10,778 11,101 11,434 11,777 12,131 12,495 12,869 13,256 73,653 14,063 14,485 74,919 15,367 15,828 16,303 16,792 Services 342,637 194,737 231,397 238,339 245,489 252,854 260,439 268,253 276,300 284,589 293;127 301,921 310,978 320,308 329,917 339,614 350,009 360,509 Depreciation 540,962 734,525 762,145 838,360 863,511 889,416 916,099 943,582 971,889 1,001,046 1,031,077 1,062,009 1,093,870 1,126,686 1,160,486 1,160,486 1,160,486 1,160,486 Debt Service Interest 8 Fees Total Expenditures 961,265 1,024,478 1,099,499 1,174,990 1,211,984 1,250,174 1,289,602 1,330,309 1,372,338 1,415,733 1,460,542 1,506,812 1,554,593 1,603,936 1,654,894 1,672,709 1,691,207 1,710,417 less: Non-Cash Depreciation 540,962 734,525 762,145 838,360 863,511 889,416 916,099 943,582 971,889 1,001,046 1,031,077 1,D62,009 1,093,870 1,726,686 1,160,486 1,160,486 1,160,466 1,160,486 plus: Cash Transfer to GF 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,OD0 plus: Debt Service Principal plus: Cash Capital Outlay 571,589 1,090,487 1,145,000 1.722,800 1,826,000 1,011,000 950,000 895,000 1.034,000 937,000 1,267,000 1.500,000 2,116,000 1,670.000 1,465,000 437,000 35,000 198,200 Total Cash Requirement 1,091,912 1,480,440 1,582.354 2,159,430 2.274,473 1,471,758 1,423,503 1,381.727 1,534,449 1,451,688 1,796,465 2,044,803 2,676.723 2,247,250 2,059,408 1,049.223 665,721 S 848.131 V Beginning Cash Balance 1,060,877 1,353,496 1,380,620 1,356,023 764,527 104,726 295,780 535,089 816,174 994,122 1,305,903 1,325,511 1,150,963 400,302 136,596 &0,732 995,053 2,312,877 Changes in Assels/Liabilities 40,639 1,861 Cash Received 1,343,892 1,505,903 7,557,557 1,567,934 1,614,672 1,662,812 1,662,872 1,662,812 1,712,397 1,763,469 1,816,073 1,870,255 1,926,062 1,983,544 1,983,544 1,983,544 1,983,544 1,983,544 Cash Sperrt (1,091,912) (1,480,440) (1,582,354) (2,159,430) (2,274,473) (1,471,758) (1,423,503) (1,381,7271 (1,534,449) (1.451,688) (1,796,465) (2,044,603) (2,676,723) (2,247,250) (2,059,408) (1,049,223) (665,721) (848,131) Ending Cash Balance S 7,353,496 S 1.380,820 S 1.356.023 S 764,527 S 104,726 5 295,780 S 535,089 816,174 994,122 S 1,305,903 S 1,325.511 1,150,963 400.302 136,596 8 60,732 S 995.053 2,312.877 S 3,448.290 Cash Reserve Target 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 540,000 Assumptions: Cash basis All assumptions are predicted on Cash Basis preseMafion with no provisions made ior changes in balance sheet items that may affect cash balances. Revenues Rate increase reflect additions to the gross income based on ordinance charges Expenditures Personnel Costs increase at a rate of 5% per yeac Supplies and.Services increase at a rate of 3% per year. Depreciation increases at a rate of approximately 3% per yeac Capital outlay is from the 2009 CIP C I Puti l ityratres2009thru2023.x1s Y City of Brooklyn Center Street Light Utility pund Rate Analysis Rate Increase 7.50% 5.00% 5.00% 2.00% 3.00% 3.00% 3.00% 2.00% 2.00% 3.00;6 3.00% 3.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Quarterly Rate per Dweliing Unit 3.48 3.65 3J3 3.84 3.95 4.07 4.15 4.24 4.36 4.50 4.63 4.72 4.82 4.91 5.01 5.11 5.21 Actual Actual Estimaied Proposed Projeded Projected Projected Projected Projeded Projected Projected Projected Projected Projected Projeded Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Revenues StreetLightFee 220,801 234,828 241,216 246,040 253,422 261,024 268,855 274,232 279,717 288,108 296,751 305,654 371,767 316,002 324,362 330,850 337,467 344,276 Misc.Operating Misc. Non-operating 5,625 7,669 7.500 4,000 4,000 4,000 4,000 4,000 4,000 4.000 4,000 4,000 4,000 4,000 4.000 4,000 4,000 4,000 Total Revenues 226,426 242,497 248,716 250,040 257,422 265,024 272,855 278,232 283,717 292,108 300,751 309,654 315,767 322,002 326,362 334,850 341,467 348,216 Expenditures Personal Services Supplies 794 822 2,900 2,987 3,077 3,169 3,264 3,362 3,463 3,567 3,674 3,784 3,897 4,014 4,135 4,259 4,387 4,518 Services 183,033 163,013 186,269 193,917 799,735 205,727 211,898 216,255 224,803 231,547 238,494 245,648 253,018 260,608 268,427 276,479 284,774 293,317 Depreciation Debt Service or Transfer S Total Expenditures 183,827 163,835 191,169 196,904 202,811 208,896 215,162 221,617 226,266 235,114 242,167 249,432 256,915 264,623 272,567 280,738 289,160 297,835 Capital Outlay 31,296 26,810 71,400 38,000 78,000 67,000 40,000 79,000 52,000 98,000 50,000 65.000 70,000 48,000 104,000 32,000 58.700 Total Cash Requirement 215,123 190,645 262,569 234,904 280,811 275,896 255,162 300,617 280,266 333,714 292,167 314,432 326,915 312,623 376,561 312,738 289,160 356,535 Beginning Cash Balance 90,936 102,239 154,091 140,236 155,374 131,985 121,113 138,806 116,420 119,871 78,666 87,450 62,672 71,524 80,903 32,704 54,816 107,122 N Changes in Assets/Liabilities S S S Revenues 226,426 242,497 248,716 250,040 257,422 265,024 272,855 278,232 283,717 292,108 300,751 309,654 315,767 322,002 328,362 334,850 347,467 348,216 Expenditures 3 (215,123) (190,645) (262,569) (234,904) (280,811) (275,896) (255,162) (300,617) (280,266) (333,114) (292,167) (314,432) (326,915) (372,623) (376,561) (312,738) (289,160) (356,535) Depreciation Add-Back S Ending Cash Balance 102,239 S 154,097 140,238 S 155,374 131.985 g 121,113 136,806 S 116,420 S 119,871 S 78,866 87,450 g 82,672 71.524 S 80.903 32,704 S 54,816 107,122 S 98.803 Cash Reserve Target 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Assumptions. Cash basis All assumptions are predicted on Cash Basis ptesentation with no provisions made for changes in balance sheet items that may occur from year to year. Revenues Rate increases are based on cusiomer count of 8,415 residential customers and 538 others. Expenditures Supplies and Services increase at a total rate of 3% per annum. Depreciation increases at a rate of approximately 3% per annum. Capital outlay is from the 2086 CIP EBHC Cash Flows Before and After Transfer 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 (50,000) (100,000) 2003 2004 2005 2006 2007 Net Cash Flow Net Cash Flow after transfer 1 Earle Brown Heritage Center Cash Balances 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 �e:.: ,�'�:;�:.X,'�, t w 2�0��0� y_ "",f'1,' F iry K3; n.��... `��r i i i 2003 2004 2005 2006 2007 Operating Fund Cash Capital Fund Cash Of 2009 Budget FUND: Water Utility Fund 60100 DEPT/ACTIVITY/PROJECT: Operations 49141 PROFILE The Water Utility Division provides for the distribution of potable water to customers. This division includes the operations, administration and utility billing for the utility. The division is managed by the Public Works Director, except for the utility billing component which is managed by the Fiscal Services Department. The City has approximately 115 miles of water main, 1,377 water valves, and 975 fire hydrants providing service to 7,314 metered single-family residential connections and 1,635 metered apartments/townhouses/commerciaUindustrial customers. Water is supplied from nine municipal wells. Also included in this division is the maintenance of meters, locating water mains and services, testing of the municipal water supply throughout the system as required, preventative maintenance, and emergency repairs to the City's distribution system and its appurtenances. The utility billing operation prepaxes and sends out utility bills, receives meter readings and makes estimated readings, and administers collections and assessment for non- payment. Substantial water main improvements are generally completed in association with the neighborhood street reconstruction program or other improvement projects. 2009 projects consist of reconstruction of some mains in the Aldrich neighborhood, replacement of a watermail traversing the Centerbrook golf course, and building maintenance projects at Lift Station 2 and Municipal Wells 6 and 9. DEPARTMENTAL GOALS Provide routine and 24-hour emergency on-call maintenance service for the public water supply system. Change, read and repair residential and commercial water meters as necessary. Provide timely locating services as per Gopher State One Call. Work together with the Engineering Division in reconstruction areas to inspect new water services, mains and disconnects, and provide assistance to customers in construction areas who are receiving new water services. Provide fire flow information and assist insurance companies in gathering additional infortnation as needed (i.e., assist in fire flow testing). Maintain weekly bacteria testing and daily fluoride testing and reports as required by the State Health Department. Conduct lead and copper testing as required, and in-house testing for iron, manganese, zinc and calcium/magnesium hardness. 1 Maintain training sponsored by the Minnesota Department of Health, as well as in house training in right to know, confined space entry and work zone safety. Continue routine maintenance and emergency repair of fire hydrants, system valves and water mains, and seasonal and routine flushing of water mains. Prepare and disseminate to all customers EPA-required Consumer Confidence Reports. Routine anci emergency maintenance of wells, continued monitoring of static/pumping levels and well depths. Maintain chemical feed equipment so as to comply with state guidelines for disinfection, fluoridation and corrosion controL Preventative maintenance and emergency repairs of electrical controls, telemetry system and building and grounds. Routine maintenance and repair of the interiors/exteriors of the City's water towers providing for proper seasonal level fluctuation to avoid possible structural damage. Perform, in a cost-effective manner, water system improvements as a part of neighborhood street reconstruction or other improvement projects. Repair, rehabilitate, or reconstruct water facilities as necessary to provide for efficient and effective operations. EXPENDITURE DETAILS 6204 Stationary Supplies Water Utility portion of the cost for billing envelopes. Cost distribution: 1/3 Water, 1/3 Sewer, 1/9 Storm Drainage, 1/9 Street Light and 1/9 Recycling Utility. 6216 Chemical Products Chemicals for the water distribution system to provide for disinfection, fluoridation, reduced corrosivity, and to hold the naturally-occurring nuisance mineral manganese in solution. 6219 Operating Supplies Materials and supplies, such as chemical feed equipment, pumps, motors and scales to maintain operation of the water system. 6227 Paint Supplies Paint supplies for Gopher State One Call utility locates. 6235 Utility System Supplies Routine replacement of water meters. Meters are systematically replaced, during maintenance calls and in the street and utility improvement project areas. 6239 Repair Maintenance Supplies Various supplies used in the maintenance of the distribution system, such as valve box extensions, gate valves, sensors, supplies needed for repairing water main breaks, and repair or replacement of inechanical equipment in the pump houses. 2 6242 Minor Equipment Replacement of equipment used for Water system operations. 2 Chlorine Chemical Scales 1,590.00 SCADA System Components 6,300.00 Diffuser Assembly (Hydrant Flush) 1,450.00 2 Office Chairs 900.00 6302 Architect, Engineering and Planning Design assistane with SCADA system components, leak detection, Water tower structural analysis for tower antennae, technical assistance with the water system model. 6321 Telephone/Pagers The cost for two on-call utility pagers, three on-call utility cellular telephones and the telephone connection serving the city's SCADA system. 6322 Postage Includes the water utility's share of the cost of postage to mail utility bills and meter reading cards. The EPA-required Consumer Confidence Report is now distributed in the City newsletter reducing the posta.ge necessary as the postage costs are now shared for the issue containing the EPA required report. 6351 Printing The cost of printing water meter reading cards for all users of City water. 6381 Utility Service-Electric The electrical power cost of pumping water. Actual amount will depend on water demand, which is influenced by annual rainfall amounts. 6402 Repair and Maintenance Svs Routine ehabilitation of well pump controls, chlorine and fluoride feed systems for water system and removal and servicing of Well No. 10 ($36,200.00). 6403 Building Facilities Maintenance Services Routine building and HVAC maintenance and repairs for municipal well buildings. Cost previously included in CARS budget. Also includes cost for cleaning exterior of elevated storage tanks. 6441 Licenses, Taxes, and Fees The cost for the State of Minnesota Water Testing Fee (a charge per water connection totaling approx. $58,970 per year) and the Water Appropriation Permit fee charged by the DNR for the pumping of groundwater from the Jordan Aquifer (approx. $14,500). This object code also includes the cost for Water Operator licensing fees ($150 per year). 6449 Other Contractual Service The cost of obtaining assistance from private contractors to repair water main breaks, such as to provide dewatering or specialized equipment not owned by the City. Also 3 includes water utility portion of payment for Gopher State One Call charges, monthly bacteria testing of water system, water utility portion of bill stuffing services, and repairs to communication control systems. 6530 Improvements Water Utility portion of street and utility improvement projects scheduled for 2008 within the Capital Improvement Program and capital outlay costs }�rovided below. PERSONNEL LEVELS 1-Supervisor of Public Utilities 4-Maintenance II 3-Seasonal/Part-Time One Engineering Technician is distributed over the Water, Sanitary Sewer and Storm Sewer utilities. CAPITAL OUTLAY �ee 2009 Capita�. �mprovement Program Suinmary 4 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30t2008 2009 20Q9 Actual Actual Final YTD Recommended Approved Object Code Description Amount Amount Budget Actual Budget Budget 60100 WATER UTILITY FUND 49141 WATER UT�UTY-OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4601 SPECIAL ASSESSMENTS 21,193- 4603 INTEREST EARNINGS 66,940- 77,315- 59,477- 37,970- 46,280- 46,280- 4604 CHECK PROCESSING FEES 750. 630- 390- 4605 UNREALIZED INVESTMENT GAIN/LOS 417- 1,353- 4606 OTHER REVENUE 62- 4,520- 14 4607 SPEC ASSESS INTEREST 309- 16,695- 340. 4600 MISCELLANEOUS REVENUE 89,670- 102,514- 59,477- 38,686- 46,280- 46,280- 4599 MISCELLANEOUS REVENUE 89,670- 102,514- 59,477- 38,686- 46,260- 46,280- 4700 WATER UTILITY FUND 4701 WATER SALES 1,464,236- 1,677,557- 1,475,333- 913,152- 1,519,600- 1,519,600- 4702 FIRE LWES 6,964- 8,937- 9,6D0- 5,324- 9,600- 9,600- 4703 WATER METER SALES 19,379- 17,612- 22,500- 5,771- 11,250- 11,250- 4704 WATER METER RENTALS 5,232- 3,220- 2,000- 226- 2,000- 2,000- 4705 SERVICE RESTORATION FEES 93- 297- 250- 3,433- 700- 700- 4706 CONNECTION CHARGES 26,550- 13,500- 20,000- 1,U00- 10,000- 10,000- 707 PENALTIES 175,457- 158,049- 112,000- 66,871- 150,000- 150,000- 708 TOWER RENTAL FEES 176,135- 122,819- 128,960- 130,960- 135,408- 135,408- 4709 CERTIFICATION CHARGES 19,912- 47,340- 20,000- 58,980- 30,000- 30,000- 4700 WATER UTILITY FUND 1,897,978- 2,049,331- 1,790,643- 1,185,717- 1,868,558- 1,866,558- 4900 OTHER FINANCING SOURCES 4916 CAPITAL ASSET TRANSFER 102,337 4919 GAIN ON FIXED ASSET DISPOSAL 2,359 4921 REFUNDS 8 REIMBURSEMENTS 13,917 9,246 1,302- 4900 OTHER FINANCING SOURCES 116,254 9,246 1,057 4001 REVENUES 1,871,395- 2,142,599- 1,850,120- 1,223,345- 1,914,838- 1,914,83& 6001 EXPENDITURESIEXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES SALARIES-FT EMPLOYEES 243,408 272,603 283,242 2D0,939 293,253 293,253 6102 OVERTIME-FT EMPLOYEES 30,403 34,472 32,000 26,882 32,960 32,960 6103 WAGES-PART TIME EMPLOYEES 15,968 15,125 15,300 17,200 15,950 15,950 6100 WAGES AND SALARIES 289,779 322,200 330,542 245,020 342,163 342,163 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 2,599 2,958 6110 OTHER PAYMENTS-NON INSURANCE 2,599 2,958 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 16,429 19,172 21,485 14,796 23,096 23,096 6125 FICA 16,028 20,017 20,328 14,854 21,215 21,215 6126 MEDICARE CONTRIBUTIONS 4,216 4,681 4,958 3,474 4,961 4,961 6120 RETIREMENT CONTRIBUTIONS 38,673 43,670 46,771 33,124 49,272 49,272 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 37,566 46,743 48,533 34,546 54,124 54,124 5 CITY OF BROOKLYN CENTER BudgetReport 2006 2007 2008 9/30/2008 2009 2009 Adual Actual Final YTD Recommended Approved Object Code I Description Amount Amount Budget Actual Budget Budget 6130 INSURANCE BENEFITS 37,566 46,743 48,533 34,548 54,124 54,124 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 8,448 10,099 12,858 9,236 11,949 11,949 6150 WORKER'S COMPENSATION 8,448 10,099 12,858 9,236 11,949 11,949 6099 PERSONAL SERVICES 377,065 425,870 436,764 321,928 457,5�8 457,508 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 111 81 3,000 185 1,800 1,800 6203 BOOKS/REFERENCE MATERIALS 48 300 116 300 300 6204 STATIONARY SUPPLIES 1,256 1,200 743 1,295 1�295 6200 OFFICE SUPPLIES 111 1,365 4,500 1,045 3,395 3,395 6210 OPERATWG SUPPLIES 6214 CLOTHING PERSONAL EQUIPMENT 160 50 150 150 6216 CHEMICALS/CHEMICAL PRODUCTS 82,375 92,471 82,900 75,427 95,250 95,250 6277 SAFETY SUPPLIES 642 93 1,500 643 1,200 1,200 6219 GENERAL OPERATING SUPPLIES 10,866 7,765 9,470 3,998 9,650 9,650 6210 OPERATING SUPPLIES 93,883 700,528 93,870 80,199 106,250 106,250 6220 REPAIR MAINT SUPPLIES 6223 BUILDINGS 8 FACILITIES 105 3,000 1,500 1,500 6224 STREET MAINT MATERIALS 1,243 1,000 1,025 1,025 6227 PAINT SUPPLIES 309 94 750 568 750 750 6220 REPAIR MAINT SUPPLIES 414 1,337 4,750 568 3,275 3,275 6230 REPAIR MAINT SUPPLIES-OTHER 6235 UTIIITY SYS7EM SUPPLIES 30,691 24,571 50,000 7,162 20,000 20,000 6239 OTHER REPAIR MAINT SUPPLIES 75,679 21,512 18,250 7,394 18,800 18,800 6230 REPAIR MAINT SUPPLIES-OTHER 46,370 46,083 68,250 14,556 38,600 38,800 6240 SMALL TOOLS MINOR EQUIPMENT 6241 SMALL TOOLS 468 228 500 500 500 6242 MINOR EQUIPMENT 1,576 5,480 6,940 4,116 10,240 10,240 6243 MINOR COMPUTER EQUIPMENT 1,362 1,917 1,725 1,725 6240 SMALL TOOLS MINOR EQUIPMENT 2,064 7,071 7,440 6,034 12,465 12,465 6199 SUPPLIES 142,842 156,404 178,810 102,322 164,1$5 164,185 6299 OTHER CHARGES SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT FIN'L SERVICES 1,574 1,800 1,850 1,664 1,850 1,850 6302 ARCH, ENG PLANNING 25,680 21,324 17,500 17,435 18,100 18,100 6303 LEGAL SERVICES 1,001 315 6307 PROFESSIONAL SERVICES 1,804 2,403 2,760 5,831 8,720 6,720 6300 PROFESSIONAL SERVECES 30,059 25,527 22,110 25,246 28,670 28,670 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 934 1,310 1,365 910 1,440 1,440 6322 POSTAGE 18,426 20,905 18,500 14,522 19,055 19,055 6329 OTHER COMMUNICATION SERVICES 112 575 575 6320 COMMUMCAtIONS 19,360 22,215 19,865 15,544 21,070 21,070 6330 TRANSPORTATION 6 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2009 2009 Actual Actual Final YTD Recommended Appraved Object Code Description Amount Amount Budget Actual Budget Budget 6331 TRAVEL EXPENSE/MILEAGE 168 252 150 119 155 155 6333 FREIGHT/DRAYAGE 36 9 50 11 50 50 6330 TRANSPORTATION 204 261 200 130 205 205 6340 ADVERTISING 6341 PERSONNECADVERTISING 603 6342 LEGAL NOTICES 129 89 100 363 100 100 6340 ADVERTISING 732 89 100 363 100 100 6350 PRINTING AND DUPLICATING 6351 PRINTING 2,678 2,921 2,575 223 2,680 2,680 6350 PRINTING AND DUPUCATING 2,678 2,921 2,575 223 2,680 2,680 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 10,594 10,285 10,875 8,098 11,150 11,150 6362 PROPERTY INSURANCE 1,732 1,838 1,880 1,697 1,930 1,930 6366 MACHINERY BREAKDOWN INSURANCE 460 466 460 408 480 480 6360 INSURANCE 12,787 12,589 13,235 10,203 13,560 13,560 I 6360 UTI�ITY SERVICES 6381 ELECTRIC 136,697 135,175 122,180 89,964 139,230 139,230 6382 GAS 8,431 9,291 8,150 8,600 9,570 9,570 6385 SEWER 239 246 300 125 300 300 366 STORM SEWER 5,117 5,534 5,250 2,914 5,700 5,700 6388 HAZARDOUS WASTE DISPOSAI 1,000 1,000 1,000 6389 STREET LIGHTS 944 991 1,050 574 1,025 1,025 6380 UTIUTY SERVICES 151,428 151,237 137,930 102,117 156,825 156,625 6400 REPAIR MAINT SERVICES 6402 EQUIPMENT SERVICES 30,552 32,239 42,100 78,214 42,275 42,275 6403 BLDGS/FACILITIES MAINT SERVICE 6,783 10,960 27,000 1,344 24,500 24,500 6408 COMMUNICATION/INFO SYSTEMS 276 48 580 560 580 6400 REPAIR MAINT SERVICES 37;611 43,246 69,660 79,559 67,355 67,355 6410 RENTALS 6415 OTHER EQUIPMENT 748 6417 UNIFORMS 586 602 560 468 610 610 6410 RENTALS 733 602 560 468 610 610 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 18 6422 SOFTWARE MAINT 370 380 364 354 388 388 6423 LOGIS CHARGES 18,350 21,754 21,584 13,700 32,155 32,155 6420 IS SERVICES/UCENSES/FEES 18,720 22,134 21,948 14,235 32,543 32,543 6430 MISCELLANEOUS 6432 CONFERENCESAND SCHOOLS 1,007 1,200 2,450 710 2,450 2,450 6434 DUES SUBSCRIPTIONS 1,528 1,617 3,270 1,663 1,665 1,665 6436 UNCOLLECTIBLE CHECKS/DEBTS 1,643 6436 CASH SHORT (OVER) 27 1,285 5 �430 MISCELLANEOUS 2,561 5,746 5,720 2,396 4,115 4;115 6440 OTHER EXPENSES 6441 LICENSES, TAXES FEES i1,001 74,154 65,845 61,607 73,620 73,620 6449 OTHER CONTRACTUAL SERVICE 23,954 67,810 37,405 28,575 38,300 38,300 6440 OTHER EXPENSES 94,955 141,964 103,250 90,182 111,920 111,920 7 I CITY OF BROOKLYN CENTER BudgetReport 2006 2007 2006 9/30/2008 2009 2009 Actual Actual Final YTD Rewmmended Approved Object Code Description Amount Amount Budget Actual Budget Budget 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 5,066 5,535 6,230 5,808 8,457 8,45� 6462 FIXED CHARGES 20,669 6,756 6,982 5,121 7,738 7,738 6463 REF'Alf� MAINT CHARGES 15,258 12,637 17,300 10,080 17,300 17,300 6465 REPLACEMENTCHARGES 16,756 18,792 14,341 19,972 �9.9�2 6460 CENTRAL GARAGE CHARGES 40,993 41,685 49,304 35,350 53,467 53,467 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 74,364 76,595 61,055 45,791 57,883 57,883 6470 TRANSFERS AND OTHER USES 74,364 76,595 61,055 45,791 57,883 57,863 6490 OTHER MISC CO5TSlEXPENSES 6494 DEPRECIATION EXPENSE 576,159 586,462 614,100 457,661 644,600 644,800 6499 EXPENSES REIMBURSED 78,584 649� OTHER MISC COSTS/EXPENSES 499,575 586,462 614,100 457,661 644,800 644,800 6299 OTHER CHARGES SERVICES 986,761 1,133,272 1,121,632 879,471 1,195,803 1,195,803 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 49,042 954,000 441,705 441,705 6545 OTHER EQUIPMENT 2,319 .6501 CAPITAL OUTLAY 49,042 2,319 954,000 441,705 441,705 6500 CAPITAL OUTLAY 49,042 2,319 954,000 441,705 441,705 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 1,555,711 1,717,865 2,693,146 1,303,720 2,259,201 2,259,201 4000 REVENUES AND EXPENSES 315,684 424,734- 843,026 80,375 344,363 344,363 49141 WATER UTIUTY-OPERATIONS 315,684 424,734- 843,Q26 80,375 344,363 344,363 g i CNy of Brooklyn Center water Utfliry Cash Flows PROJECTIONS WITH 80ND ISSUE FOR AMR Rate Inerease 3.00% Z25% 6.25% 3.00% 5S5% 575% f0.00% 6.00% 6.25% 6.50% 6.25% 625% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% RateN,000gallons 1.11 1.19 f.25 1.29 1.36 1.44 1.58 1.68 1.78 1.90 2A2 2.14 2.14 2.14 2J4 2J4 2.14 2J4� �AClual Actual Estimated Proposed Projecled Projected Projected Projected Projected Projected ProJedetl Projecled Projected Projecled ProJecled Projeded Projecled Projected 2006 2007 2008 2009 2010 2017 2012 2013 2014 2095 2016 2017 2018 2019 �2020 2021 2022 2023 Revenues Wate�Service 3 1,464,236 S 7,677,557 E 1,83Q,628 S 1,879.547 1,776,121 S 1,878.248 S 2,066,073 2,190,037 5 2.326,914 E 2.478,164 5 2,633,049 3 2,797,614 2.797.614. 3 2,797,614 5 2,797,614 j 2,797,614 S 2.797.614 E 2,797,674 Misc.Opetaling 433,742 E 387,726 S 348,958 S 352,658 5 356.358 360,058 5 363,758 367 5 371,158 374,858 S 378,558 S 382,258 S 385,958 S 399.658 S 393,358 397,U5B E 404,458 408,158 Totai Revenues tln9 S 1,973,731 2.142,598 2; 39,063 2,089 818 2,204,742 S 2.296 097 S 2,482,741 S 2,605 677 S 2.740,745 S 2,894 362 S 3,043 9 9 E 3,214,562 3,217.769 S 3.235,3t0 5 3,243,365 3,246 546 S 3,275,578 3,303 502 Expentlitures Personai Servlces 377,274 425,870 442,905 457,508 S 475,808 494,841 514,634 S 535,220 S 556,628 S 578,894 602,049 626.737 657,177 877,224 E 704,313 732,485 S 792,256 823,946 Supplies S 142.842 156.404 S 167,096 164.185 169.111 174.184 179,409 784.792 S 190,335 S 196,045 201.927 207.885 S 214224 S 220.651 S 227,270 S 234,089 248.345 255,795 Services 4U8,602 549,129 565,603 593,883 623,577 S 654,756 BB7,494 721,869 S 757,962 795,860 S 835,653 S 877.436 921,307 967,373 E 7.,015.741 1,066,529 S 1.175,848 1.234,640 Depreciation 578,159 586,462 3 610,214 644,800 660,920 677,443 894,379 S 711.739 729,532 S 747,770 766,465 785,626 S 805,267. 825,399 848,033 867.184 911.088 933,863 DeM Service Interesl Fees S S 8 S S 112.125 S 108.891 S 103.500 97.679 S 91.425 S 84.956 E 78272 5 71.372 S 64256 8 56.710 48.731 8 40.322 37.697 E 22.425 Total Expentlilures 7.506,877 1.777,865 1,779,818 1,880,376 2,041,541 2,110,115� S 2,779.417 S 2.251297 2,325.883 5 2.403,525 E 2.484,366 S 2.568,550 2,656,231 2,747.356 S 2.842,089 2,940,608 3,159,237 3,270,669 Iass:�Non•CashDepreciation 578,159 586,462 S 610,214 644,800 S 660,920 S 677.443� S 694,379 711.739 729,532 747,770 S 766,465 S 785,626 E 805,267 825,399 S 846,033 867.164 5 911.086 933,863 plus: De6t Service Principal 8 S S S 56,250 8 93,750 E 101.250 5 108,750 112,500 176,250 120,000 8 12a,750 S 131,250 S 738,750 S 146,250 150,000 f 161,250 18Z,500 S 8 S S S S S plus: Transfers 8 259.678 89,582 plus: Cesh Capitei OuUay E 692.064 S 576.661 954.000 441705 S 1250.463 S Z 458 593 5 2 640 352 _3 2,789,30 _E 2,785,1�0_,. S_3 194,983 S 2.964,9% S„3 230 J37 2.754.802 S 3 090.135 S 3.427.339 2.764 424 2.465.786 8 2 740762 ToWI Cash Requiremant 8 1.880.400 5 1797.646 S 2.123.604 E 7.657 281 2.687,334 5 Beglnni�g Cash Balance 5 1.718.178 S 1.871,509 E 2.068,788 E 1,984,247 S 2,008,777 5 1,926,185 5 1,763,684 1.806,073 S 1.422,445 5 1,378,U20 E 1.077,400 S 1,756,332 S 1,140,558 S 1.601,245 S 1.746,419 1,562.444 E 2.447,940 S� 3,257,664 Changes in AssetslLiabflities E S (87,873) S S S E S S S a a s a a s Cash Receivetl S 1,973,731 2,142,598 S 2,039,083 S 2.081,871 5 2204.742 2,296,091 5 2.482,741 2,605.877 2,740,745 E 2.894,362 S 3,043,929 S 3.214.562 S 3,217,789 3,235,310 S 3,243,365 S 3,241,548 5 3,275,511 E 3,303,502 CashSpent S(1.880.400) S(1.797.8461 $(2.123.6041 8f1.6572811 E(2.687.334� Sf2.458.593 E(2.640.352 Ef2.789.305 S(2.785.170 S(3.194.9831 E(2.964.998� E(3.230.33T S(2.757.1021 S(3.090.135 5f3.427.3391 E(2.784.4241 E(2.465.786) S(2.740.762� Ending Cash Balance 5�7.877,509 S 2„068.,788 S 2 408 777 S 7,926 785 S 1,769 �684 S 1 S 7 422.145 S 1,378.020., S 7„077-400 S 7 1, 56,3�2 S L740.558 S 1,601.215 S 7.748.419 S 7 562 5 2 OS9 588, S_3.257.664 E 3 820104 Cash Reserva Taryet (step) S 1,000,000 S 7,000,000 5 1,000,000 S 1,000,000 S� 1.200.000 5 1,200,000 E 1.300,000 S 1.300,000 E 1,300,000 S 1.400,000 S 1,400,000 S 1,400,000 S 1.400,000 S 1.400,000 S 1.500.000 f 1,500,000 1,500,000 E 1.500,000 Cash Reserve Tereat�5YdyQ S 1.000,000 E 1.050,000 f 1,102,500 5 1.157,625 S 1.275,506 S 1.276,282 S 1.340,D96 S 1,407,100 S 1,477,455 S 1,551,928� S 1,628,895 S 1,710,339 E 7,795,856 S 1.885,649 E 2.078,928 S 2,182,875 Assumotiona: Cash basis I All essumplions are predicled on Cash Basis presentation and do nof include provlsions for chenges in balance sheet i from year to year ihat may aflecl cash balances. Revenues Rate inereases wouid be as indicatetl eacb year and based on e stable cuslomer base and. stable consump0un Expendttures Personnel Costs increase at a rele of 4% per year Supplies increase at a rate ot 3% perannum. Services increase at e rele ot 5% peryear Depreciation Increases at a rete oi approximalery 2.5% per annum. �'i�j' of Broo�,,yC n Cente�' 2009 Budget FUND: Sanitary Sewer Utility Fund 60200 DEPT/ACTIVITY/PROJECT: Operations 49251 PROFILE This division provides for the collection and conveyance of wastewater through a system of mains and lift stations. Sewage is treated by the Metropolitan Council Environmental Services, whose fees account for approximately 75% of this fund's expenditures. This division is managed by the Public Works Director, except for the utility billing component, which is managed by the Fiscal and Support Services Department. The City has approximately 106 miles of sanitary sewer ranging in size from 8" to 24" in diameter, and 8,798 service connections. Included in this division is the routine and preventative maintenance of the City's collection system and its appurtenances, monitoring of inflow and infiltration, television inspection of the interiors of mains, and customer service such as providing sewer locations. This activity involves the operation and maintenance of the City's ten wastewater lift stations, which includes buildings, equipment, and property. Sewer system improvements are made as part of the neighborhood street reconstruction program or other improvement projects. DEPARTMENTAL GOALS Provide timely locating services as per Gopher State One Ca1L Work together with the Engineering Division in reconstruction areas to inspect new installations as well as repairs on mains and services. Continue root sawing program to maintain conveyance capacity. Maintain routine line cleaning of known trouble spots, as well as regular routine cleaning to remove grit, grease and roots. Televise all project areas and trouble spots as identified by city staff and establish repairs and/or repair projects from information obtained. Monitor inflow and infiltration rates. Continue established preventative and regular maintenance program on electrical controls, buildings, and grounds. Monitor inflow and pump efficiency. Perform, in a cost-effective manner, sewer system improvements as a part of neighborhood street reconstruction or other improvement projects. Repair, rehabilitate, or reconstruct sanitary sewer facilities as necessary to provide for efficient and effective operations. 10 ILS EXPENDITURE DETA 6204 Stationary Supplies Sanitary Sewer Utility portion of the cost for billing envelopes. Cost distribution: 1/3 Water, 1/3 Sewer, l/9 Storm Drainage, 1/9 Street Light and l/9 Recycling Utility. 6216 Chemical Products Degreaser and root remover chemicals used at lift stations. 6219 Operating Supplies Marking paint, marking flags, sewer jet parts, blades, motors, etc. Item includes the cost for miscellaneous parts to repair sanitary sewer maintenance equipment. 6239 Other Repair Maintenance Supplies The cost of check valves, sump pumps, float, switches and replacement of lift station contol valves at Lift Station No. 1 6302 Arch, Eng Planning Technical assistance by a corYsultant to assist u�ith lift station operational issues that may arise throughout the year. 6307 Professional Services Engineering for SCADA system maintenance and for OSHA training consultant.. 6321 Telephone/Pager The cost of one cellular telephone and two pagers for on-call personnel. 6381 Utility Services-Electric The electrical cost of operating lift station pumps. 6391 Met Council Environmental Services Charges by the Metropolitan Council Environmental Services for processing the City's wastewater. Brooklyn Center is billed 1.21% of the total metropolitan wastewater charges from MCES (percent of $161,322,000) for 2009. 6403 Repair and Maintenance Svs-Buildings and Facilities Maint Svs Routine electrical repairs to lift stations and annual building maintenance of Lift Station Nos. 1 and 2 formerly funded through CARS budget. 6409 Repair and Maintenance Svs-Other Annual maintenance for emergency generators ($7,930) miscellaneous unscheduled repairs for sanitary sewer failures ($3,600) and initiation of a program for annual sanitary sewer televising inspections ($53,000). 11 ervice 6449 Other Contractual S Routine oxygen sensor calibration, gas monitor maintenance, inspection of lift station pumps, generator load banking, etc. This item also includes specialized contractual services such as pump rewinding and isolated sewer repairs that are not part of the scheduled improvements included in the CIP. 6530 CapitalOutlay Sewer Utility portion of street and utility improvement projects scheduled for 2009 within the Capital Improvement Program. PERSONNEL LEVELS 2 Maintenance II 2 Seasonal/Part-Time One Engineering Technician is distributed over the Water, Sanitary Sewer and Storm Sewer utilities. CAPITAL OUTLAY See 2009 Capital Improvement Program Summary 12 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30l2008 2009 2009 Actuai Actual Final YTD Recommended Approved Object Code Description Amount Amount Budget Actual Budget Budget 60200 SEWER UTILITY FUND 49251 SEWER UTILITY-OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4310 FEDERALREVENUE 4599 MISCELLANEOUS REVENUE 4600 MISCEILANEOUS REVENUE 4601 SPECIAL ASSESSMENTS 4603 INTEREST EARNINGS 105,B34 114,396- 71,750- 54,604- 66,500- 66,500- 4605 UNREALIZED INVESTMENT GAIN/LOS 441- 1,560- 4606 OTHER REVENUE 38� 4607 SPEC ASSESSINTEREST 166- 4707 PENALTIES 20,641- 61,301- 4600 MISCELLANEOUS REVENUE 106,459- 136,762- 71,750- 116,292- 66,500- 66,500- 4599 MISCELLANEOUS REVENUE 106,459- 136,762- 71,750- 116,292- 66,500- 66,500- 4720 SEWER UTILITY FUND 4721 SEWER SERVICE 3,092,574- 3,251,887- 3,141,800- 1,861,112- 3,209,820- 3,209,820- 4720 SEWER UTILITY FUND 3,092,574- 3,251,887- 3,141,800- 1,861,112- 3,209,820- 3,209,820- 4900 OTHER FINANCING SOURCES 915 TRANSFERS IN 461,723- 916 CAPITAL ASSET TRANSFER 16,684- 4921 REFUNDS REIMBURSEMENTS 93,811- 1,984- 4900 OTHER FINANCING SOURCES 110,495- 463,707- 4001 REVENUES 3,309,528- 3,652,356- 3,213,550- 1,977,404- 3,276,320- 3,276,320- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES SALARIES-FT EMPLOYEES 88,987 �02,873 1D9,269 70,869 113,643 113,643 6102 OVERTIME-FT EMPLOYEES 17,640 17,630 19,500 12,421 19,500 19,500 6103 WAGES-PART TIME EMPLOYEES 5,477 7,012 5,410 6,612 5,575 5,575 6100 WAGES AND SALARIES 112,104 127,516 134,179 89,902 138,718 138,718 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 2,095 772 6110 OTHER PAYMENTS-NON INSURANCE 2,095 772 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 6,398 7,520 8,722 5,410 9,363 9,363 6125 FICA 7,189 8,093 8,252 5,638 8,601 8,601 6126 MEDICARE CONTRIBUTIONS 1,681 1,893 2,013 1,319 2,012 2,012 6120 RETIREMENT CONTRIBUTIONS 15,268 17,506 18,987 12,367 19,976 19,976 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 16,139 20,213 21,233 13,824 23,468 23,488 .6130 INSURANCE BENEFITS 16,139 20,213 21,233 13,624 23,488 23,488 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 3,206 3,774 5,220 3,378 4,543 4,543 6150 WORKER'S COMPENSATION 3,206 3,774 5,220 3,378 4,543 4,543 13 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2009 2009 Actual Actual Final YTD Recommended Approved Object Code Description Amount Amount Budget Actual Budget Budget 6099 PERSONAL SERVICES 148,811 169,781 179,619 119,471 166,725 186,725 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 100 100 100 6203 BOOKSlREFERENCE MATERIALS 200 200 200 6204 STATtONARY SUPPLIES 2,260 1,200 1,337 1,236 1,236 62D0 OFFICE SUPPLIES 2,260 1,SD0 1,337 1,536 1,536 6210 OPERATING SUPPLIES 6214 CLOTHING PERSONAL EQUIPMENT 100 105 50 50 6216 CHEMICALS/CHEMtCAL PRODUCTS 2,876 2,276 5,000 2,559 5,000 5,000 6217 SAFETY SUPPUES 3,203 180 2,500 638 2,500 2,500 6219 GENERAL OPERATING SUPPLIES 3,147 1,438 2,750 4,394 2,830 2,830 6210 OPERATING SUPPLIES 9,326 3,894 10,355 7,591 10,380 10,380 6220 REPAIR MAINT SUPPLIES 6227 PAINT SUPPLIES 309 163 300 88 300 300 6220 REPAIR MAINT SUPPLIES 309 163 300 88 300 300 6230 REPAIR MAINT SUPPLIES-OTHER 6239 OTHER REPAIR MAINT SUPPLIES 893 9,384 12,900 411 12,900 12,900 6230 REPAIR MAINT SUPPLIESATHER 893 9,384 12,900 411 12,900 12,900 6240 SMALL TOOLS 8 MINOR EQUIPMENT 6241 SMALL TOOLS 468 228 SDO 500 500 6242 MINOR EQUIPMENT 470 6243 MINOR COMPUTER EQUIPMENT 33Z �'942 6240 SMALL TOOLS MINOR EQUIPMENT 938 560 500 1,942 500 500 6199 SUPPLIES 11,466 16,262 25,555 11,369 25,616 25,616 6299 OTHER CHARGES SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT FIN'L SERVICES 1,574 1,615 '1,750 1,574 1,750 1,750 6302 ARCH, ENG 8 PLANNING 655 1,925 1,850 1,900 1,900 6303 LEGAL SERVICES 4,101 6307 PROFESSIONAL SERVICES 2,068 2,795 3,204 2,116 3,700 3,700 6300 PROFESSIONAL SERVICES 8,398 6,335 6,804 3,690 7,350 7,350 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 273 319 340 241 400 400 6322 POSTAGE 5,238 6,129 5,500 4,654 5,665 5,665 632D COMMUNICATIONS 5,510 6,448 5,840 4,895 6,065 6,065 6330 TRANSPORTATION 6340 ADVERTISING 6342 LEGAL NQTICES 39 6340 ADVERTISING 39 6350 PRINTING AND DUPLICATING 6351 PRINTING 146 100 375 100 375 375 6350 PRINTING AND DUPLICATING 146 100 375 100 375 375 14 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/20D8 2009 2009 Actual Actual Final YTD Recommended Approved Object Code 1 Description Amount Amount Budget Actual Budget Budget 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 4,983 4,543 4,790 3,500 4,930 4,930 6362 PROPERTY INSURANCE 564 601 630 556 640 640 6366 MACHINERY BREAKDOWN INSURANCE 182 185 195 162 195 195 6360 INSURANCE 5,729 5,329 5,615 4,218 5,765 5,765 6380 UTILITY SERVICES 6381 ELECTRIC 30,934 35,572 31,820 24,372 34,250 34,250 6380 UTILITY SERVICES 30,934 35,572 31,820 24,372 34,250 34,250 6390 CONTRACT UTILITY SERVICES 6391 MET COUNCIL ENVIRON SVCS 1,612,362 2,439,046 1,B45,262 1,591,263 1,917,364 1,917,384 6390 CONTRACT UTILITY SERVICES 1,612,382 2,439,046 1,845,262 1,591,283 1,917,384 1,917,384 6400 REPAIR 8 MAINT SERVICES 6403 BLDGSIFACILITIES MAtNT SERVICE 1,647 1,208 7,D00 4D0 7,000 7,000 6408 COMMUNICATION/INFO SYSTEMS 276 591 560 560 560 6409 OTIiER REPAIR MAINT SVCS 27,689 16,025 66,200 4,620 64,530 64,530 6400 REPAIR 8 MAINT SERVICES 29,611 17,824 73,760 5,020 72,090 72,090 6410 RENTALS 420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE LICENSE 18 6423 LOGIS CHARGES 18,272 21,712 21,584 13,700 22,752 22,752 6420 IS SERVICES/UCENSES/FEES �8.2�2 2�,��2 2�,584 �3 22 22 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,350 1,230 1,425 1,190 1,525 1,525 6434 DUES SUBSCRIPTIONS 74 1,700 23 100 100 6430 MISCELlANEOUS 1,424 1,230 3,125 1,213 1,625 1,625 6440 OTHER EXPENSES 6441 LICENSES, TAXES FEES 5,207 112 2 6449 OTHER CONTRACTUAL SERVICE 15,986 32,377 24,800 17,005 25,160 25,160 6440 OTHER EXPENSES 21,193 32,488 24,800 17,007 25,160 25,160 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 13,236 14,612 18,500 14,684 22,704 22,704 6462 FIXED CHARGES 40,083 11,151 11,746 8,339 12,224 12,224 6463 REPAIR MAINT CHARGES 24,958 21,745 31,200 16,661 32,000 32,000 6465 REPLACEMENT CHARGES 53,531 54,257 41,038 56,872 56,872 6460 CENTRAL GARAGE CHARGES 78,276 101,040 115,703 80,722 123,800 123,800 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 129,760 133,653 95,225 71,419 57,883 57,883 6470 TRANSFERS AND OTHER USES 129,76� 133,653 95,225 71,419 57,883 57,883 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 503,231 525,655 550,425 414,405 577,900 577,900 6499 EXPENSES REIMBURSED 147,936- 6490 OTHER MISC COSTS/EXPENSES 355,293 525,655 550,425 414,405 577,900 577,900 6299 OTHER CHARGES SERVICES 2,296,969 3,326,432 2,780,338 2,232,227 2,852,399 2,852,399 15 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2009 2009 Actual Actual Final YTD Recommended Approved Object Code Description Amount Amount Budget Actual Budget Budget 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMENTS 1,201,000 403,565 403,565 6501 CAPITAL OUTLAY 1,201,000 403,565 403,565 6500 CAPITAL OUTLAY 1,201,000 403,565 403,565 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 2,457,246 3,512,475 4,186,512 2,363,067 3,468,305 3,468,305 4000 REVENUES AND EXPENSES 852,262- 339,881- 972,962 385,663 191,985 191,985 49251 SEWER UTILITY-OPERATIONS 852,282- 339,861- 972,962 385,663 191,985 191,965 16 Clty of 8rooklyn Center SanNary sewer UtIINy Caah Flows PROJECTIONS WITH BOND ISSUE FOR AMR Ratelncrease 2.80% 2J5% 2.00% 3.00% 3.00% 3.00% 3.00% �3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 0.00% 0.00% 0.00% 0.00% AcWal Actual Estimated Proposed Projected Projecled Projected Pmjected Projected Projecled Projected Projecled Projecled Projecled Projecled Projected Projected Pmjected 2006 2007 2008 2009 2010 2011 2072 2013 2014 2015 2016 2017 2018 2019 2020 2027 2022 2023 Revenues SewerCharges 2,970,510 5 3,411,210 3,141,800 3,236,054 3�3,333.136 S 3,433,130 E 3.536,724 E 3,642,207 S 3,751,474 5 3,864,018 S 3,979,936 E 4.099,336 E 4,222,316 S 4,348,986 S 4.348,986 4,348.986 4,348,986 E 4,348,986 Misc. Operaling E 93,811 E 177.939 S 72.805 E 12.000 12,000 E 12.000 8 72,000 S 72,000 12.000 S 12,000 S 72,000 S 12,000 12,000 S 12,000 S 12.000 E 12.D00 S 12,000 E 12,000 Misc. Non-operaling S 106275 462.149 S 67.301 S 57.607 S 68.578 E 50.705 3 44.749 3 56,380 S 46.593 E 38.701 S 30.981 S 28.462 S 32.445 S 33.222 E 27.306 S 14.020 E 27.491 3 43.534 TWaI Revenues 3,110,596 3,991,298 3,275,906 3,305,661 S 3,413,714 3,495,835 3,592,873 3,710,587 3,810.067 8 3,972,719 E 4.022,979 5 4.739,799 4,266.761 4,394,208 4,388,291 A,375,006 4,388,477 S 4,4Q4.520 Expenditures PersonalServices S 147,615 770,587 E 178,263 S 186,285 E 193,737 5 201,486 S 209,546 E 217.927 S 226,845 3 235,710 245,139 5 254.944 S 265,142 275,748 286,778 S 298,249 8 310,779 S 322,586 Supplies S 11,466 16,262 S 18,750 S 25,616 S 26,384 5 27,176 E 27,991 S 28,831 S 29.696 30,587 S 31,504 E 32,450 33,423 S 34,428 S 35,459 S 36,522 S 37.618 38,746 Services 1,958,604 2,784.515 S 2.423,763 2.324,499 2,394,234 E 2,466,081 S 2.540,043 2,616.244 2,694,737 2.775,573 2,858.841 2,944,606 5 3,032,944 S 7.123,932 3 3,217,650 3,314,180 S 3,413,605 E 3,516,013 Depreciation 5 503,231 S 525,655 S 552,540 S 577,900 8 575,000 S 515,000 3 575,000 515,000 S 515,000 E 515,000 f 515,000 515,000 S 575.000 515,000 515,000 515,000 8 575,000 515,000 DeM Service Interest 8 Fees S S f S S 37.375 S 36.297 8 34.500 S 32.560 S 30.475 S 28.319 S 26.097 E 23.791 E 21.419 S 18.903 S 75244 S 13.441 S 10.566 S 7.475 Total Expenditures 2,620,916 S 3,497,079 3,171,318 5 3,114.300 3,166,730 S 3,246,020 S 3,327.080 3,410,563 .S 3.496,567 S 3,585,190 8 3,676,575 S 3,770,781 f 3,867,828 S 3,968,009 4,W1,190 4,177,392 S 4.286,968 4,399,827 less: Non-Cash Depreciation S 503,231 S 525,655 S 552,540 S 577,900 S 575,000 E 515,000 5 515,000 575,000 S 515,000 515,000 S 575,000 515,000 515,000 S 515,000 S 515,000 S 575,000 S 515,000 5 575.000 plus: Debt Service Principal 18.750 31,250 S 33,750 S 36,250 S 37,500 38,750 8 40,000 5 47,250 a 43,750 46,250 S 48.750 S 50,000 S 53,750 62,500 plus: Cash Cepital OWlay S 658.069 S 436.649 S 1.201.�00 S 403.565 1.339.002 S 932,089 S 359.359 E 1.105,000 5 1.120,748 S 994.464 S 905.303 8 710.000 S 844.189 8 1.092.155 S 1226 25? S 273.575 S 28,025 S 208275 Total Cash Requirement 8 2.775754 S 3.406,019 S 3,819,776 S 2,939,965 8 4,009.482 S 3,694,359_. 5 3,_205-,189 3 4.036.813 4.739.795 S 4.103.404 S 4.106.878 S 4,007.041 5 4240,867 S 4,59L414 S 4.831 137 S 3,925,967__ S 3.853.743 _S 4.755.596 Beginning Cash Balance S 1.597.283 1,926.733 S 2,464,118 1,920,246 2,285,942 S 7.690,174 E 1.491.649 5 1,879,334 E 1,553,108 S 1,229,380 S 1,032,696 E 948,737 1,081,495 S 1,107,389 S 910,183 S 467,343 S 916,383 1,451.118 Changes in AsselslLiabilftles S (5,392) (45,902) a a a a s a s a a s a a a a a Cash Received E 3,170,596 S 3.981,298 3,275,908 3,305.661 3,413,714 S 3,495,835 3,592,873 3,710,587 3,810,067 E 3,912,719 4.022,919 8 4,139,799 S 4266,761 4,394,208 4,388,291 4,375,006 4,388,477 4,404,520 CaShSpent S(2.7753541 2f3,408,0131 S(3,819.7761 5f2.939.9651 S(4.009.4821 S(3.694.359? S(3.205J891 S(4.036.8131 E(4.139.7951 8(4.103.404� Sf4.706.878 $(4.007.041� $f4.240.8671 E(4.581.414� E(4.831.7311 E(3.925.96T S(3.8537431 $(4J55.5961_ EndingCash Balanee S 1.926,733 S 2�464,716 5 S 2,285942 S 1.690774 S 1�491.649 S 1553108 S 1223380 S 7.032.696 S 948,737 S 7087.495 5 1AW.�89 S 970-183 S 487.343 S 918.383 S 1.451,178 51.700,042 Cash Reserve Target S� 950.000 S 950,000 S 950,000 S g50,000 S 997,500 5 1.047,3�75 S 1 099,�7M S 1 154,731 S 1 212.67 S 7 273, E 1 736,745 E 1,403,583 S 7 473 762 S 1,547,450 E 1,624 822 5/,706,OG4 E 1,791,387 S 1 8 0,935 Ceah Reserve Target (SY.lyr) r+ Assumptions: -J Cash basis All assumpliona are proOlded on Caah Basla preseMatfon and do nol Include provisions for changes in balance sheel ftema. i Revenues �I Rate increases wouid be as intlicated per year and are based on a slabla customer base wilh stable usage. I I Expendltures I Personnel costs increase at a 2le ot 4% per year Supplies increase at a rete of 3% per yeac I Serices Increase al a rate ot 3% per year Deprecialion increases at a rete of 2% per yeat Capital outlay is from tAe 2009 CIP I I I C't�► of Bf'00�'�I1Z C�'ltt�'1' 2009 Budget FUND: Storm Drainage Utility Fund 65100 DEPT/ACTIVITY/PROJECT: Operations 49411 PROFILE This division provides for the collection and management of stormwater throughout the city in compliance with State and Federal regulatory requirements. The Storm Drainage Utility operates and maintains approximately 84 miles of storm sewers and 85 storm water management ponds or treatment devices. The Storm Drainage Utility also provides for street sweeping operations and the City's participation in two joint powers Watershed Commissions, which provide for regional planning, surface water quality monitoring, and Wetlands Conservation Act compliance. DEPARTMENTAL GOALS Perform street sweeping operations to reduce sediment discharge to surface waters. Televise storm sewer pipe to identify damaged or failed pipe segments. Repair deteriorated drainage pipes and structures. Clean and inspect outfalls, skimmers, ponds and sediment structures per NPDES requirements. Inspect public and private ponds and treatment systems. EXPENDITURE DETAILS 6239 Repair and Maintenance Supplies-Other Provides for supplies when city employees perform the maintenance and repairs on system structures and facilities as part of ongoing maintenance items. 6409 Repair and Maintenance Svs-Other Provides for repair services on the Shingle Creek weir as part of the ongoing maintenance in this area. Additional amounts are provided for unscheduled maintenance as issues and problems arise in and along the city's drainage system. This item would provide funding for the cost of replacement castings, rip rap, catch basins and other isolated pipe materials needed to address unscheduled repairs to the maintenance system. 6434 Dues Subscriptions Annual dues of the Shingle Creek and West Mississippi Watershed Management Organizations. 6461 Fuel Charges Fuel costs for operating 1-Ton utility truck and two street sweepers assigned to the Storm Sewer Utility Budget. 18 6462 Fixed Charges Replacement and overhead charges for 1-Ton utility truck and two street sweepers assigned to the Storm Sewer Utility Budget. 6463 Repair Maintenance Charges Repair and maintenance charges for 1-Ton utility truck and two street sweepers assigned to the Storm Sewer Utility Budget. 6530 CapitalOutlay Reimbursement for Storm Sewer Utility portion of annual street and utility improvement project costs. PERSONNEL LEVELS 1 Full-Time Maintenance II One Engineering Technician is distributed over water, sewer and storm sewer utilities. CAPITAL OUTLAY See 2009 Capital Improvement Program Summary. 19 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2D09 2009 Actual Adual Final YTD Recommended Approved Object Code Description Amount AmouM Budget Actua! Budget Sudget 65100 STORM SEWER UTILITY FUND 49411 STORM SEWER UTILITY-OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4300 INTERGOVERNMENTAL REVENUE 4340 STATE REVENUE 4370 OTHER GRANTSIAID 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 7D,430- 91,459- 42,000- 34,449- 38,000- 38,000- 4605 UNREAL{ZED INVESTMENT GA1NlLOS 310- 840- 4612 DONATIONS 8 CONTRIBUTIONS Z��" 4707 PENALTIES 6,4�8- �B��Za" 4600 MISCELLANEOUS REVENUE 70,739- 96,777- 42,000- 52,770- 38,000- 38,OOD- 4599 MISCELLANEOUS REVENUE 7D,739- 98,777- 42,000- 52,770. 38,000- 38,000- 4730 STORM SESM1IER UTILITY FUND 4731 STORM DRAINAGE FEES 1,323,607- 1,406,070- 1,472,910- 904;802- 1,524,462- 1,524,462- 4730 STORM SEWER UTILITY FUND 1,323,607- 1,406,070- 1,472,910- 904,802- 1,524,462- 1,524,462- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 324,771- 193,157- 4921 REFUNDS REIMBURSEMENTS 157- 4900 OTHER FINANCING SOURCES 324,771- 193,314 4001 REVENUES 1,719,117- 1,698,160- 1,514,910- 957,572- 1,562,462- 1,562,462- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES 8 SALARIES-FT EMPLOYEES 45,242 61,334 66,967 29,679 59,897 59,897 6102 OVERTIME-FT EMPLOYEES 437 1,355 975 187 1,004 1,004 '6100 WAGES AND SALARIES 45,679 62,689 67,942 29,866 60,901 60,901 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 282- 637 6110 OTHER PAYMENTS-NON WSURANCE 282- 637 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 2,741 3,908 4,450 1,939 4,112 4,112 6125 FICA 2,923 4,112 4,178 1,869 3,776 3,776 6126 MEDICARE CONTRIBUTIONS 684 962 1,019 437 883 883 6120 RETIREMENT CONTRIBUTIONS 6,347 8,983 9,647 4,245 8,771 8,771 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 4,164 10,159 12,134 5,407 14,297 14,297 6130 INSURANCE BENEFITS 4,164 10,159 12,134 5,407 14,297 14,297 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 3,254 3,475 5,456 2,431 3;221 3,221 6150 WORKER'S COMPENSATION 3,254 3,475 5,456 2,431 3,221 3,221 2� CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9I3D/2008 2D09 2009 Adual Adual Final YTD Recommended Approved Object Code Description Amount Amount Budget AGual Budget Budget 6099 PERSONAL SERVICES 59,162 85,943 95,179 41,948 87,190 87,190 6199 SUPPUES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 244 400 400 400 6204 STATIONARY SUPPUES 1,256 770 743 1,290 1.290 6200 OFFICE SUPPLIES 244 1,256 1,170 743 1,690 1,690 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES 68 500 624 500 500 6210 OPERATING SUPPLIES 68 500 624 500 500 6230 REPAIR MAINT SUPPLIES-OTHER 6239 OTHER REPAIR MAINT SUPPLIES 18,394 8,112 20,OD0 7,494 20,000 20,000 6230 REPAIR MAINT SUPPLIES-OTHER 16,394 6,112 20,000 7,494 20,OD0 20,000 i 6240 SMALL TOOLS MINOR EQUIPMENT 6243 MINOR COMPUTER EQUIPMEN7 190 1,917 6240 SMALI TOOLS MINOR EQUIPMENT 190 1,917 6199 SUPPLIES 18,638 9,626 21,670 10,778 22,190 22,190 6299 OTHER CHARGES SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT 8 FIN'L SERVICES 1,574 1,615 1,750 1,574 1,750 1,750 6302 ARCH, ENG 8� PLANNING 20,251 4,302 22,400 8,726 28,500 28,500 6303 LEGAL SERVICES 1,508 788 6307 PROFESSIONAL SERVICES 56,047 4,810 203 240 240 6300 PROFESSIONAL SERVICES 79,380 11,516 24,150 10,504 30,490 30,490 6320 COMMUMCATIONS 6322 POSTAGE 2,000 2,000 2,000 6320 COMMUNICATIONS 2,000 2,000 2,000 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/M�LEAGE 16 18 6330 TRANSPORTATION 16 1$ 6340 ADVERTISING 6342 LEGAL NOTICES 32 32 6340 ADVERTISING 32 32 6350 PRINTING AND DUPLICATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 2,577 2,780 2,600 2,132 2,841 2,841 6360 INSURANCE 2,577 2,780 2,600 2,132 2,&41 2,841 6400 REPAIR MAINT SERVICES 6409 OTHER REPAIR MAINT SVCS 6,232 2,133 20,000 1,539 20,000 20,000 6400 REPAIR MAINT SERVICES 6,232 2,133 20,D00 1,539 20,000 20,000 6420 IS SER1/ICES/LICENSES/FEES 6421 SOFTWARE LICENSE 6423 LOGIS CHARGES 10,441 12,406 12,334 7,827 13,001 13,001 I 21 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2009 2009 Adual Adual Final YTD Recommended Approved Object Code Description Amount Amount Budget Actuai Budget Budget 6420 IS SERVICES/UCENSES/FEES 10,441 12,406 12,334 8,008 13,001 13,001 6430 MISCELLANEOUS 6434 DUES 8 SUBSCRIPTIONS 47,942 51,850 52,910 49,501 50,980 50,980 6430 MISCELLANEOUS 47,942 51,850 52,910 49,501 50,980 50,980 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICE 4,105 6440 OTHER EXPENSES 4,105 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 3,238 4,420 5,200 4,991 7,569 7,569 6462 FIXED CHARGES 30,417 3,623 3,813 2,810 4,224 4,224 6463 REPAIR 8 MAINT CHARGES 9,326 17,451 12,400 8,748 16,000 16,000 6465 REPLACEMENT CHARCES 35,446 48,456 36,448 49,758 49,758 6460 CENTRAL GARAGE CHARGES 42,981 60,940 69,869 52,997 77,551 77,551 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERV�CE TRANSFE 47,534 48,960 47,534 35,651 57,883 57,883 6473 STORM SEWER?RANSFER 100,000 100,000 1D0,000 75,000 100,000 100,000 6482 MISC TRANSFER OUT 176,011 6470 TRANSFERS AND OTHER USES 323,545 148,960 147,534 110,651 157,883 157,883 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 540,962 734,525 615,300 571,609 838,360 838,360 6499 EXPENSES REIMBURSED 202,684 2,399,14& 6490 OTHER MISC COSTS/EXPENSES 338,279 1,664,623- 615,300 571,609 838,360 838,360 6299 OTHER CHARGES SERVICES 851,408 1,369,886- 946,697 806,957 1,193,106 1,193,106 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6530 IMPROVEMEN7S 1,145,200 1,722,800 1,722,800 6501 CAPITAL OUTLAY 1,145,200 1,722,800 1,722,800 6500 CAPITAL OUTLAY 1,145,200 1,722,800 1,722,8D0 6600 DEBT SERVICE 6001 EXPENDITURESlEXPENSES 929,208 1,274,317- 2,2D8,746 859,683 3,025,286 3,025,286 4000 REVENUES AND EXPENSES 789,909- 2,972,477- 693,836 97,889- 1,462,824 1,462,824 49411 STORM SEWER UTILITY-OPERATIONS 789,909- 2,972,477- 693,836 97,889- 1,462,824 1,462,824 22 CRy of Brooktyn CeMer Storm Water Utflfty Cash Flows Rete Increase 0.00% 4.00% 7.00% 3.00% 3.00% 3.00% 0.00% 0.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 0.00% 0.00% 0.00% 0.00% PerResfdentialLot 12.88 13.78 14.19 14.62 15.08 75.08 15.08 15.51 15.97 16.45 78.95 17.48 17.98 77.98 77.98 17.98 17.98 Adual Aclua� Estimated Proposetl Pmjeded Projeded ProJecled Pmjecled Pmjeded Projected. Projectetl Pro�eGed ProJecled Projecled Projected Projecled Projeaed Projecled 2008 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Revenues S�ortn Sewef FBCS S 1,273,153 E 1,413,805 1,512,557 3 1,557,934 S 7,604,672 1,852,812 5 1,652,812 S 1,652,872 S 1.702,397 S 1,753,489 S 1,806,073 S 1.BBD,255 S 1.918.082 S 1.973,544 E 7,973,544 1,973,544 5 7,973,544 S 1.973.544 Misc.Operating T 5 s s s s s s a s a a s a s a a s Misc. Non-opereting S 70339 3 92.298 45.000 S 70.000 S 10.000 S 70.000 8 10.000 S 10.000 8 10.000 S 10.000 E 10.000 S 10.000 S 70.000 S 1D,000 10.000 S 10,000 S 10.000 S� 10,000 Total Revenues 1,343,892 S 1.505,903 S 1,557,557 S 7,567,934 1,614,672 S 1,662,872 7.682,812 S 1.862,812 5 1.112,397 S 1,783;489 1,816,073 S 1,870.255 S 1,926,062 1.983,544 1,983.544 S 1,983,544 1,963,544 1,963,544 ExpendRures Personal Services S 59,048 S 85.590 S 95,178 S 87,790 91,550 S 98,127 E 100,933 S 105,980 111,279 5 118,943 E 122,885 S 128,Bi9 S 135,280 E 142,023 S 149,124 5 758,581 5 164,410 E 172.830 Supplies 18,638 S 9.826 70,778 8 11.101 11,434 11,777 8 12.131 S 12,495 S 72.869 5 13,258 5 13,653 E 14,083 S 14,485 14,919 15,387 5 15,828 S 16,303 16.792 Services S 342,637 S 794,737 231,397 2a8,339 245,468� 252,654 260,439 S 288,253 S 278,300 284,589 293,127 S 301,921 370,978 320,308 S 329.917 S 339,814 S 350,009 S 380,509 Depreciatlon 540,862 S 734,525 S 762,145 S 838,360 883,571 889,418 916,099 S 943,582 E 971,889 7,001,046 1,031,077 1.062,009 1,093,870 1.126.688 1,180,486 1,160,486 3 1,160,486 1.780,486 De61 Service Interest 3 Fees S S s a a s z s a Total Expentlitures 5 967.285. S 1,024,478 S 1,099,499 5 1,174.990 E 1.211.984 S 1.250,174 S 1.289,602 S 1,330,309 S 7,372,338 S 1.415,733 S 1,460,542 S 1.508,812 f 1,554,593 E 1,803,938 7,854,894 S 1,872,709 S�1.691,207 5 1,710,417 less: Non•Cash DepreciaUon S 540,982 5 734,525 5 782,145 838,380 S 863,511 S 889,418 E 918p99 5 943,582 S 977.889 S 1.007,046 5 1,037,077 $�1,062,009 1,093;870 S 7,728.688 5 1J60.488 5 7,180,488 E 1.780,486 S 7,180,486 plus: Cash Trensferto GF 100,OOD E 100,000 8 100,000 E 100,000 E 700,000 S 700,000 5 100,000 S 100,000 S 100,000 S 100,000 S 100,000 S 100,000 E 100,000 5 700,000 S 100.000 E 100,000 E 100,000 S 100,000 pius: Debt Service PdnGpal a s s s s a a s S S S S S S S E plu5: CaSh CapNal Oullay E 571.589 S 1.090.487 5 1.145.000 S 1.722.800 S 1.826.000 8 1.011.000 E 950.000 S 895.000 S 1.034.000 5 937.000 E 1.267.000 S 1.500,000 3 2.116.000 S 1.810.000 E� 1.485.000 5 437.000 35.000 S 198.200 Total Cash Requirement E 1.091.912 S 1 480 440 S 7,582,354 8 2,159.430 S 2.274.473 S 1.471758 5 7.423,503 S 1,381,727 5._ 1,534,449 5 1,451,888 S 1 796.485 S 2.044.803 S 2.676723 2�4Z250 5 2A58.408 E 1.048.223 6_ 865.721_ S 848J31 I Beginning Cas� Balence S 1,060,877 E 1,353,496 S 1,380,820 S 1.356,023 E 764,527 S 104,728 S 295.78� S 535,069 S 876.174 S 994,122 5 1,305,903 S 7.325,SN 5 1,150,993 Y 400,302 S 136,598 5 60,732 995,053 S 2,372.877 I Chenges in Assets/Liabililies S �0,839 E 1,881 s s a s s s s s s� s s s a s s s Cash Receivetl S 1,349,892 5 1,505,903 S 7,557,557 S 1.567,834 S 1,814,672 S 1.682,812 5 7.882.812 S 1.882,872 S 1.712,397 S 1.783,469 5 1,818,075 S 1.870,255 5 7.928.062 S 1,983,544 E 1.983,544 S 1,983,544 S 1.983,544 S 1,983,544 Cesh Spenl S f7.091-972) S(1.480,4401 S(1,582.3541 S(2.159.430� S(2.274.4731 S(1.4T7.7581 E(7.423.5031 S(7.381.727� S(7.534.449) E(1.451.888) 5(7796.4651 S(2.044.8031 S(2.676723) 5(2247250� S(2.059.4081 S(1.049.2231 S (665.721� S 848.1311 Ending Cash Balance 5 1,767-4% S 1.78U,820 5 7.358 029 S 764�527 5 704.726 f 295�80 S 635.089 i___ Et_8 174. S 994.121 E 73U5.90J S 1 726.517 S 7.760 963 S 400-1tl2. i 136 S96 S.. 60-772 S 986.Ob3 3 2.J12 677 S_ 7 44g280 Cash Reserve Target S 540,000 f 540,000 S 510,000 5 540,000 5 540.000 S 540.000 S 540,000 S 540,000 S 540,000 E 540,000 S 540,000 S 540,000 S 510,000 S 540,000 S 540,000 S 540,000 S 540,000 E 540,000 N W Assumotionr. Cash basis All assumptions ere predicted on Cash Basis pr8sentation witb no provisions made for changes In balance sheel Nems Iha1 may aftecl cash balances. Revenues i Rate increase re0ecl etltli�ions to i�e gross income besed on ordinance charges Expenditures Personnel Cosls increase et a rale of 5% per yeer. Supplies and Services increase at e rate of 3% per yeac Depredation increases at a tate of approximately 3% per yeac i Capital outlay is from the 2009 CIP I ClPutilityratres2009ihru2023.x15 City of BrookCyn Center 2009 Budget FUND: Street Light Utility Fund 65200 DEPT/ACTIVITY/PROJECT: Street Lights 49571 PROFILE The Street Light Utility provides for electrical and maintenance fees paid to Xcel Energy/NSP for street lights owned by Xcel Energy/NSP. It also provides for electrical service, maintenance, repair, and replacement of lights owned by the City. The City owns approximately 71 ornamental lights, primarily in the Earle Brown commercial area, 85 ornamental lights on Brooklyn Boulevard, and leases about 915 lights from NSP. Another 971ights owned by the City are located on tr�c signal posts and mast arms. DEPARTMENTAL GOALS Maintain and operate the City's street light system. EXPENDITURE DETAILS 6239 Repair and Maintenan�e Supplies-OtheX Provides for maintenance supplies for City owned and operated street lights in and along the Earle Brown Center, Brooklyn Blvd and intersection lighting at intersections with semaphores. 6381 Utility Service-Electric Electric utility costs for street lights. 6409 Repair and Maintenance Svs-Other Provides for contractual services for maintenance of those street lights that are not Xcel Energy's responsibilities for service. 6530 Improvements Reimbursement for Street Light Utility portion of annual street and utility improvement project costs. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY See 2009 Capital Improvement Program Summary 24 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9130I2008 2009 2009 Adual Aduai Final YTD Recommended Approved Object Code Description Amount Amount Budget Actual Budget Budget 65200 STREET LIGHT UT ILITY FUND 49571 STREET LIGHT-OPERATIONS 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 5,601- 7,572- 7,500- 3,225 7,500- 7,500- 4605 UNREALIZED INVESTMENT GAIN/LOS 23- 9�- 4606 OTHER REVENUE 1,380. 47D7 PENALTIES 1,376- 3,821- 46D0 MISCELLANEOUS REVENUE 5,625- 10,425- 7,SOa 7,047- 7,500- 7,500. 4599 MISCELLANEOUS REVENUE 5,625- 10,425- 7,500- 7,047- 7,500- 7,500- 474D STREET LIGHT UTIIITY FUND 4741 STREET LIGHT SERVICE CHARGE 221,341- 231,475 241,216- 146,349- 249,65& 249,658- 4740 STREET LIGHT UTILITY FUND 221,341- 231,475- 241,216- 146,349- 249,656- 249,65& 4900 OTHER FINANCWG SOURCES 4�01 REVENUES 226,966- 241,900- 248,716- 153,396- 257,158- 257,15& 6001 EXPENDITURES/EXPENSES 6199 SUPPLIES 62D0 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 400 400 400 6204 STATIONARY SUPPUES 126 59 6200 AFFICE SUPPLIES 126 400 59 400 400 6230 REPAIR MAINT SUPPLIES-OTHER 6Z39 OTHER REPAIR 8 MAINT SUPPLIES 794 695 2,500 212 2,500 2,500 6230 REPAIR MAINT SUPPLIES-OTHER 794 695 2,500 212 2,500 2,500 6240 SMALL TOOLS MINOR EQUIPMENT 6199 SUPPLIES 794 822 2,900 271 2,900 2,900 6299 OTHER CHARGES SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT FIN'L SERVICES 500 500 500 6307 PROFESSIONAL SERVICES 104 100 93 6300 PROFESSIONAL SERVICES 104 100 500 93 500 500 6320 COMMUNICATIONS 6322 POSTAGE 1,500 1,50D 1,500 6320 COMMUNICATIONS 1,500 1,500 1,500 6330 TRANSPORTATION 6350 PRINTWG AND DUPUCATWG 6360 INSURANCE 6361 GENERAL LIABIUTY INSURANCE 1,367 1,291 1,410 949 1,450 1,450 6360 INSURANCE 1,367 1,291 1,410 949 1,450 1,450 25 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9l30/2008 2009 2009 Actual Adual Final YTD Recommended Approved Object Code Description Amount Amourrt Budget Adual Budget Budget 6380 UTILITY SERVICES 6381 ELECTRIC 145,536 167,037 161,800 105,091 172,048 172,048 6380 UTILITY SERVICES 145,536 167,037 161,800 105,091 172,048 172,048 6400 REPAIR 8 MAINT SERVICES 6409 OTHER REPAIR MAINT SVCS 9,256 18,125 8,150 6,218 13,300 13,300 6400 REPAIR 8 MAINT SERVICES 9,256 18,125 8,150 6,218 13,300 13,300 642D IS SERVICES/LICENSES/FEES 6440 OTHER EXPENSES 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVESERVICETRANSFE 4,161 4,286 14,909 11,182 15,553 15,553 6482 MISC TRANSFER OUT 31,296 26,810 6470 TRANSFERS AND OTHER USES 35,457 31,096 14,909 11,182 15,553 15,553 6490 OTHER MISC COSTSIEXPENSES 6299 OTHER CHARGES SERVICES 191,721 217,648 188,269 123,532 204,351 204,351 6500 CAPITAL OUTLAY 650t CAPITAL OUTLAY 6530 IMPROVEMENTS 71,400 36,000 36,000 6501 CAPITAL OUTLAY 71,400 36,000 36,000 6500 CAPITAL OUTLAY 71,400 36,000 36,000 6041 EXPEND{TURESIEXPENSES 192,515 218,470 262,569 123,804 243,251 243,251 4000 REVENUES AND EXPENSES 34,451- 23,430- 13,853 29,592- 13,907- 13,907- 13 853 29 592- 13 907- 13 907- 49571 STREET LIGHT OPERATIONS 34,451- 23,430. 65200 STREET iIGHT UTILITY FUND 34,451- 23,430. 13,853 29,592- 13,907- 13,907- i 26 3 Cily of Brooklyn Center Street Light Utility Fund Rale Malysis Rate Increase 7.50% 5.00% 5.009G 2.00% 3.00% 3.00% 3.0094 2.00% 2.0096 3.00% 3.00% 3.00% 2.00% 2.00% 2.0096 2.00% 2.0�% 2.00"G Duarterty Rate per Dwelling UnR 3.48 3.65 3.73 3.84 3.95 4.01 4.75 4.24 4.36 4.50 4.63 4.72 4.82 4.91 5.07 5.11 5.27 Actuai Actual Estimated Proposed Pro�ected Projected Pro�ected Projected Projected Pmjeded Proiedad Projected Pro)eded ProjeMed Pro�eded Pro�ected ProjeMed. Projedad .2006 2007 2006 2008 2010 2077 2012 2013 2014 2015 2018 2017 2078 2019 2020 2021 2022 2023 Revenues Sireet Lighl Fee S 220.801 S 234.828 E 241,218 246,040 S 257,422 261.024 S 268,855 S 274,232 279,717 S 288,108 S 296,751 S 305,654 317.787 S 318,002 S 324,362 S 330,850 337,487 344,218 Misc.OPeratin9 8 S S S S S 8 S S S S S S S S MISC.Nan-opere5ng 5.625 S 7.669 7.500 S 4.000 5 4.000. S 4.000 5 4.000 S 4.000 4.000 4.000� 4.000 S 4A00 S 4.000 4.000 S 4.000 S 4.000 S 4.000 E 4,000 TotalRevenues 228,426 242,487 248,778 250,040 S �257,422 265,024 272,855 S 278,232 283,717 292,tOB 300,751 S 309,654 315,767 S 322,002 328,362 334,850 S 341,667 5 348216 ExPendNures y S Persanal Services S E S Supplies 794 S 822 S 2,900 S 2,987 S 3,077 3,169 S 3,284 S 3,362 3,463 S 3,567 5 3,674 S 3.784 3.697 E 4,074 S 4,135 S 4.259 4.387 S� 4,518 Services 183,033 163,013 788,289 193,917 E 199.735 S 205,727 E 211,898 S 218,255 S 224,803 S 231,547 S 236,494 S 245,848 S 253,018 S 280,608 S 288,427 S 278,478 284,774 S 293,317 DePreciaBon E S S s s a s s S s S S Dabt 5ervice or Transfer S S s s a s a s s a s a s s a a s s Total Expendilures 183,827 163,835 S 191,169 196,904 E 202,811 208,896 S 215,182 S 221,617 S 228,266 S 235,114 5 242.167 S 249,432 S 256.975 S 264,623 272,561 S 280,738 289,160 S 297,835 CapNal Outley 31296 S 26.870 71.400 S 38.000 78.000 E 87 000 5 40.000 S 79.000 S 52.000 S 98.000 S 50 000 5 85.000 S 70.000 S 48.000 104.000 S 32.000 S S 58700 ToWICaBhRequireme�t S 2 15.123 5 18U.645 y Z62 .569 S 234904_ 5 28U,811 5 275,896 S 255,162 5 300,617 S Z80,Z66 E 333,114 28Z,167 5 314,432 S 326815 S__ 31Z,623 378.561_ _E 312,739 S 298.1b0 5 356535 Beginning Cash Balence 90,938 102,239 154,097 S 140,238 155,374 131,985 121,113 138,808 716,420 179,871 78,868 87,450 82,672 5 71,524 80,903 E 32,704 54.816 107,122 Changes in Pssets/IJabilities S E b S S S S S E Revenues 228,426 242,497 S 248,716 250,04� S 257,422 S 265,024 S 272,855 S 278,232 5 283.717 292,108 300,751 E 309,854 E 315,767 322,002 328,362 334,850 341,467 E 348,216 i ExPendRures S (275.123) 5 (190,645) (262,589) S (234,904) S (280,811) (275.896) (255,162) S (300,817) S R80,266) S (333,114) E (292,16� (314,432) S (326,915) S (312,623) S Ci76,581) S (312.738) S (288.160) (358.535) DeDreciation Add-Back E S S S S x S S R S F S x S S S S a EndingCeshBalanCe S 10Z.Z39 S S 190,236 5 iS5376 5 131985 S_ 13171J,., 5 1.8�806 S 716,{ZO S 718.tl77 S 76,968 5 67,450 S 62672 5 71�6Z4 5 80.907 S 12_704 b4.616 S 107„7_LZ S 88.807 Cash Reserva Terget f 50,000 S� 50,000 E 50,000 5 50,000 50,000 S 50,000 50,000 S 50,000 S 50,000 S 50,000 E 50,000 S 50,000 E 50,000 E SO,ODO E 50,000 S 50,000 SO,o00 S 50,000 Assumplions. Cash basis N All essumptlons era predicled on Cash Basis vresentadon wtth no proWsiona mede tor changes in balence sheet items lhat mey occur from year W year. Revenues Rale increases are based on customer count of 8,415 residenUal customers aM 538 oMers. Expend'Aures SuDP�ies and Services in�rease al e total rale of 3% per annum. Depreciauon increasea at a rate of approximetely 3% per annum. CapRal oul�ey is irom Ne 2088 CIP Ci�j► of Brool�C�m Center 2009 Budget FUND: Recycling Fund 65300 DEPT/ACTIVITY/PROJECT: Recycling Fund 49311 PROFILE The recycling fund accounts for tlie operation and administration of the City's state- mandated curbside recycling program. Revenues are from customer service fees with expenses comprised of amounts paid to the Hennepin Recycling Group (HRG), a four cities consortium for recycling services. DEPARTMENTAL GOALS To provide bi-weekly collection of recyclables. To continue an effective curbside recycling program while keeping rates as affordable as possible. To identify �rogram needs and develop funding mechanisms that provide sufficient revenues. REVENUE DETAILS i 4751 Recycling Service Fees Projection is based on monthly rate of 2.60 per household 7.80 per quarter) for bi- weekly pickup of recyclables. Staff is examining inclusion of the curbside cleanup collection. Initial projection is that the fee would be 3.60 per household 10.80 per quarter) for including an annual curbside pickup of non-hazardous materials. EXPENDITURE DETAILS 6449 Other Contractual Services Projection is based on a monthly chazge of 2.60 per household from Hennepin Recycling Group (HRG) for pickup and processing of recyclables by Waste Management plus an administrative fee for HRG operations. PERSONNEL LEVELS No personnel are assigned to this activity. CAPITAL OUTLAY None requested. 28 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30l2008 2D09 2009 Adual Adual Final YTD Recommended Approved Object Code 1 Description Amount Amount Budget Adual Budget Budget 65300 RECYCLING FUND 49311 RECYCLING 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 1,40& 1,068- 1,200- 102- 100. 100- 4605 UNREALIZED INVESTMENT GAINILOS 4707 PENALTIES 1,983- 6,387- 4600 MISCELLANEOUS REVENUE 1,409- 3,051- 1,200- 6,489- 100- 100- 4599 MISCELLANEOUS REVENUE 1,409- 3,051- 1,200- 6,489- 100- 100- 4750 RECYCLING FUND 4751 RECYCLING SERVICE FEES 242,588- 243,274- 257,362- 150,793 267,656- 267,656- 4750 RECYCLING FUND 242,58& 243,274 257,362- 150,793 267,656- 267,656- 4900 OTHER FINANCING SOURCES 4001 REVENUES 243,997- 246,325 258,562- 157,282- 267,75& 267,756- 6D01 EXPENDITURES/EXPENSES 6199 SUPPLIES 6200 OFFICE SUPPLIES 6204 STATIONARY SUPPLIES �z5 89 6200 OFFICE SUPPLIES �ZS 89 6240 SMALL TOOLS MINOR EQU�PMENT 6243 MINOR COMPUTER EQUIPMENT 95 6240 SMALL TOOLS MINOR EQUIPMENT 95 6199 SUPPLIES 220 89 6299 OTHER CHARGES SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 145 254 275 128 120 120 6300 PROFESSIONAL SERVICES 145 254 275 126 120 120 6320 COMMUNICATIONS 6330 TRANSPORTATION 6350 PRINTING AND DUPUCATING 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 1,975 1,790 2,157 1,293 2,150 2,150 6360 INSURANCE 1,975 1,790 2,157 1,293 2,150 2,150 6420 IS SERVICESlLICENSESlFEES 6423 LOGIS CHARGES 5,221 6,207 6,167 3,914 6,501 6,501 6420 IS SERVICES/LICENSESIFEES 5,221 6,207 6,167 3,914 6,501 6,501 6440 OTHER EXPENSES 6449 OTHER CONTRACTUAL SERVICE 228,335 238,349 234,950 182,331 244,350 244,350 6440 OTHER EXPENSES 228,335 238,349 234,950 182,331 244,350 244,350 29 CITY OF BROOKLYN CENTER Budget Report 2D06 2007 2008 9130I2008 2009 2DD9 Adual Actual Final YTD Recommended Approved Object Code Description Amount Amount Budget Adual Budget Budget 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 10,176 10,481 14,909 11,182 15,553 15,553 6470 TRANSFERS AND OTHER USES 10,176 10,481 14,909 11,182 15,553 15,553 6299 OTHER CHARGES SERVICES 245,852 257,081 258,458 198,847 268,674 268,674 6001 EXPENDITURES/EXPENSES 245,852 257,301 258,456 198,936 268,674 268,674 4000 REVENUES AND EXPENSES 1,855 10,976 104 41,655 918 918 49311 RECYCLING 1,855 10,976 104 41,655 918 918 65300 RECYCLING FUND 1,855 10,976 104- 41,655 918 918 30 City of Brooklyn Center Recycling Fund Rate Analysis Rate Increase 5.00% 3.00% 3.00% 3.00% 3.0�% 3.0090 3.00% 3.00% Quarterly Residential Rate 7.35 7.57 7.80 8.03 $•2� $-52 Actuat Actual EsGmated Proposed Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 Revenues Recycling Fee 242,588 251,886 257,362 265,083 273,035 281,226 289,663 298,353 Misc.Operating Misc. Non-operating 243 999 252,955 258,562 266 283 274 235 282,426 290,863 299 553 Total Revenues Expenditures Personal Services Supplies Services 245,852 257,615 258,458 266,212 274,198 282,424 290,897 299,624 Depreciation g g Debt Service Total Expenditures 245,852 257,615 258,458 266,212 274,198 282,424 29�.89� 299,624 Capital0utlay Total Cash Requirement 245,852 257,615 258,458 266,212 274,198 282,424 290,897 299,624 Beginning Cash Balance 15,068 5,429 769 873 944 981 984 950 Changes in Assets/Liabilities (7,784) Revenues 243,997 252,955 258,562 266,283 274,235 282,426 290,863 299,553 Expenditures (245,852) (257,615) (258,458) (266,212) (274,198) (282.424) (290.897) (299.624) Depreciation Add-Back Ending Cash Balance 5,429 769 873 944 981 984 950 880 Cash Reserve Target 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Revenues Rate increases will have to be 3.0% in 2009 in order for the fund to break even based on customer base of 8,415 residential customers and 538 others. All other revenues would remain flat over the five year period. Expenditures Supplies and Services increase at a total rate of 3%o annum. Depreciation increases at a rate of approximately 3% per annum. Cash Reserve Target The cash reserve target is established by estimating 2 months' service charges from Hennepin Recyciing Group 31 �'ity of Broo� Center 2009 Budget FUND: Centerbrook Golf Course 61300 DEPT/DIVISION/ACTIVITY: Centerbrook Golf Course 49721 PROFILE Centerbrook Golf Course is a nine (9) hole, par three (3) course, owned by the City of Brooklyn Center. It was built in 1986-87 with a loan from the Capital Improvements Fund. It opened for business in the spring of 1988 and was established as an enterprise fund entity. Enterprise funds were established to account for the financing of self- supporting activities of the City, which render services on a user charge basis to the general public. Each year between 21,000 and 25,000 rounds of golf are played at Centerbrook. In addition, about 250 people will take lessons. As a result of recent experience, rounds projections for 2009 budget have been reduced to 22,000. For the 2009 budget, the revenues and expenses related to beer sales at the Dudley softball tournament are included in this fund. DEPARTMENTAL GOALS Enhance marketing efforts (including cross marketing activities with area courses) to aitract additional golfers. Assure that the course and clubhouse is clean and well maintained, so as to compliment marketing efforts. Pursue cost saving strategies with neighboring golf courses. Expand league and lesson offerings to raise the number of persons participating. Continue analysis of inerchandise selection, pricing and display for changes that would increase revenues. EXPENDITURE DETAILS 6103 Part-Time $64,000 Clubhouse staff, rangers, part-time golf professional, seasonal golf course m�.nager, and maintenance workers. 6212 Motor Fuels $2,000 Fuel for mowers and other golf course equipment. 6216 Chemical Products $6,000 Herbicides, insecticides, snow mold treatment and other chemical used to maintain the fairways and greens. 32 i 6219 Operating Supplies $1,200 The cost of various supplies such as scorecards, towels, cleaning materials, etc. 6225 Landscape Materials $5,000 Fertilizer, grass seed, sod, etc, plus the cost of flowers in the various planters throughout the course and at the clubhouse. 6415 Rentals $4,500 The cost of leasing golf carts for rental to patrons. PERSONNEL LEVELS 1-Grounds Supervisor CAPITAL OUTLAY 6520 Buildings and Facilities $12,000 Bathroom remodeling 33 i CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/20D8 2009 2009 AGual Adual Finai YTD Recommended Approved Object Code Description Amount Amourrt Budget Actual Budget Budget 61300 CENTERBROOK GOLF COURSE 49721 CENTERBROOK GOLF COURSE 4000 REVENUES ANp EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 fNTEREST EARNWGS 2,244 3,413- 2,500- 754- 1,000- 1,000- i 4604 CHECK PROCESSING FEES 30- 4605 UNREALIZED INVESTMENT GAINlLOS 33- 4600 MISCELLANEOUS REVENUE 2,252- 3,475 2,500. 754 1,OOa 1,000- 4599 MISCELLANEOUS REVENUE 2,252- 3,475- 2,500- 754- 1,000. 1,000- 4770 CENTERBROOK GOLF COURSE 4771 GOLF LESSONS 2,128- 2,180- 2 ,soa 1,580- 1,500- 1,500- 4773 GREEN FEES 163,005- 147,053- 180,000- 138,714 160,000- 160,000- 4778 PASSBOOK 23,606 26,379- 26,000- 22,331- 25,000. 25,000- 4782 RENTALS 12,106- 12,723- 13,000- 12,329- 13,000- 13,000- 4785 LEAGUE 14,19U- 12,416- 16,000- 12,368- 15,000- 15,000- 4786 BEER WINE COOLER REVENUES 9,232- 26,592- 34,000- 31,902- 34,000- 34,000- 4787 FOOD 8 BEVERAGE REVENUES 7,346- 7,941- 8,000- 6,863- 8,000- 8,OOa 4788 TAXABLE MERCHANDISE 2,149- 2,151- 2,000- 1,441- 2,000- 2,000- 4789 NON TAXABLE MERCHANDISE 14,253- 12,944 10,OD0- 12,299- 13,000- 13,000- 4790 MISCELLANEOUS 325- 309- 500- 479- 500- 500- 4791 BOTTLED WATER SALES 1,79& 1,930- 2,250- 1,685- 2,000- 2,000- 4770 CENTERBROOK GOLF COURSE 250,33& 252,619- 294,250- 241,992- 274,000- 274,000- 4900 OTHER FINANCING SOURCES 4915 TRANSFERS W 49,000- 4921 REFUNDS REIMBURSEMENTS 10S 8& 4900 OTHER FINANCING SOURCES 49,105- 8& 5550 DIRECT COST OF SALES 558D COST OF GOODS SOLD 4D01 REVENUES 301,695- 256,183- 296,750. 242,746- 275,OOD- 275,000- 6D01 EXPENDITURES/EXPENSES 6099 PERSONALSERVICES 6100 WAGES AND SALARIES 6101 WAGES 8 SALARIES-FT EMPLOYEES 44,913 46,452 47,661 35,562 49,090 49,090 6103 WAGES-PART TIME EMPLOYEES 61,757 66,639 64,000 60,131 64,000 64,000 6104 OVERTIME-PARTTIMEEMPLOYEES 1,000 1,533 1,D00 1,676 1,200 1,200 61D0 WAGES AND SALARIES 107,671 114,624 112,661 97,371 114,290 114,290 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 1,155 1,257 6110 OTHER PAYMENTS-NON INSURANCE 1,155 1,257 6'120 RETIREMENT CONTRIBUT�ONS 6122 PERA COORDINATED PLAN 3,251 4,368 7,323 3,932 7,715 7,715 i 6125 FICA 6,583 6,967 6,929 5,858 7,086 7,086 370 1 657 1,657 1 690 1, 6126 MEDICARE CONTRIBUTIONS 1,539 1,629 6120 RETIREMENT CONTRIBUTIONS 11,373 12,964 15,942 11,160 16,458 16,458 34 CITY OF BROOKLYN CENTER Budget Report 2D06 2007 2008 9l30I2008 2009 20D9 Actual Adual Finai YTD Recommended Approved Objecl Code Description Amount AmouM Budget Actual Budget Budget 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 6,040 8,820 9,100 6,912 10,212 10,212 6130 INSURANCE BENEFITS 8,040 8,820 9,100 6,912 10,212 10,212 6140 UNEMPLOYMENT COMPENSATION 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 1,832 1,678 1,909 1,710 1,8z8 ��8z8 6150 WORKER'SCOMPENSATION 1,832 1,678 1,909 1,710 1,828 1�828 6099 PERSONAL SERVICES 130,070 139,344 139,612 117,153 142,788 142,786 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPUES 219 251 500 355 500 500 62D0 OFFICE SUPPUES 219 251 500 355 500 500 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLt�:� 138 44 200 35 200 200 6212 MOTOR FUELS 2,607 3,677 3,100 1,506 2,000 2,000 6213 LUBRICANTS ADDITIVES 103 95 100 33 200 200 6214 CLOTHING PERSONAL EQUIPMENT 200 200 200 6215 SHOP MATERIALS 204 225 123 250 250 6216 CHEMICALS/CHEMICAL PRODUCTS 3,632 3,613 6,000 840 6,000 6,000 6217 SAFETY SUPPLIES 123 104 200 14 800 800 6219 GENERAL OPERATING SUPPLIES 1,639 1,586 1,75D 1,135 1,200 1,200 6210 OPERATING SUPPLIES 8,241 9,325 11,775 3,686 10,850 10,850 6220 REPAIR MAINT SUPPLIES 6221 MOTOR VEHICLES 1,517 1,602 1,600 333 1,600 1,600 6223 BUILDWGSBFACIUTIES 1,528 1,343 1,500 2,727 3,000 3,000 6225 PARK LANDSCAPE MATER�ALS 2,269 4,465 5,000 1,948 5,000 5,000 6227 PAINT SUPPLIES 12 173 200 91 200 200 6220 REPAIR MAINT SUPPLIES 5,325 7,584 8,300 5,098 9,800 9,8D0 6230 REPAIR MAWT SUPPLIES-OTHER 6239 OTHER REPAIR MAINT SUPPLIES 501 500 263 500 500 6230 REPAIR MAINT SUPPUES-OTHER 501 50D 263 500 500 6240 SMALL TOOLS MINOR EQUIPMENT 6241 SMALL TOOLS 441 71 500 171 500 500 6242 MINOR EQUIPMENT 511 600 169 650 650 6243 MINOR COMPUTER EQUIPMENT 668 1,100 925 1,000 1,000 6240 SMALL TOOLS 8 MINOR EQUIPMENT 1,109 583 2,200 1,265 2,150 2,150 6199 SUPPLIES 14,895 18,243 23,275 10,668 23,800 23,800 6299 OTHER CHARGES 8 SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 593 817 750 473 750 750 6300 PROFESSIONAL SERVICES 593 817 750 473 750 750 6320 COMMUNICATIONS 6321 TELEPHONEIPAGERS 2,651 3,158 3,300 2,119 3,300 3,300 6320 COMMUNICATIONS 2,651 3,158 3,300 2,119 3,300 3,300 35 CITY OF BROOKLYN CENTER Budget Report 2�06 2007 2008 9/30/2008 2D09 2D09 Adual Adual Final YTD Recommended Approved Object Code Description Amount Amount Budget Adual Budget Budget 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 49 50 50 50 6330 TRANSPORTATION 49 50 50 50 6340 ADVERTISING 6349 OTHERADVERTISING 2,238 2,347 3,000 1,027 2,000 2,000 634U ADVERTISING 2,238 2,347 3,000 1,027 2,�00 2,000 6350 PRINTING AND DUPLICATING 6351 PRINTWG 210 1,039 1,000 852 1,000 1,000 6350 PRINTING AND DUPLICATING 210 1,039 1,000 852 1,000 1,Q00 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 5,709 4,893 6,410 3,385 5,60U 5,fi00 6362 PROPERTY 1NSURANCE 1,422 1,406 1,598 1,301 2,150 2,150 6364 DRAM SHOPINSURANCE 24 19 27 17 30 30 6366 MACHINERY BREAKDOWN INSURANCE 278 282 315 248 410 410 6360 WSURANGE 7,433 6,600 8,350 4,950 8,190 8,190 6360 UTILITY SERVICES 6381 ELECTRIC 6,378 6,383 6,250 5,344 6,250 6,250 6382 GAS 1,707 1,393 2,200 1,404 2,200 2,200 6383 WATER 7,501 8,851 4,500 5,866 5,000 5,000 6364 REFUSE DISPOSAL 1,932 1,849 1,800 1,535 1,800 1,800 6385 SEWER 525 591 550 376 600 600 6386 STORM SEWER 830 9D1 850 724 900 900 6380 UTILITY SERVICES 18,873 19,969 16,150 15,249 16,750 16,750 64D0 REPAIR MAINT SERVICES 6402 EQUIPMENT SERVICES 1,150 750 750 750 6403 BLDC',S/FACILITIES MAINT SERVICE 4,843 2,127 2,000 2,079 2,000 2,000 6408 COMMUNICATION/INFO SYSTEMS 233 6400 REPAIR MAINT SERVICES 5,992 2,360 2,750 2.079 2,75D 2,750 6410 RENTALS 6415 OTHER EQUIPMENT 4,061 4,806 5,000 3,910 4,500 4,500 6410 RENTALS 4,061 4,806 5,000 3,910 4,500 4,500 6420 IS SERVICESlLICENSES/FEES 6422 SOFTWARE MAINT 304 314 209 302 211 211 6423 LOGIS CHARGES 1,709 2,415 2,846 1,565 3,357 3,357 6420 IS SERVICES/LICENSES/FEES 2,013 2,729 3,055 1,867 3,566 3,568 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 65 313 300 288 350 350 6434 DUES SUBSCRIPTIONS 876 516 350 732 600 600 6435 CREDIT CARD FEES 2,596 2,040 2,000 2,225 2,100 2,100 6436 UNCOLLECTIBLE CHECKS/DEBTS 1 6438 CASH SHORT (OVER) 2 32- 3S 6430 MISCELLANEOUS 3,539 2,837 2,650 3,210 3,050 3,Q50 6440 OTHER EXPENSES 6441 LICENSES, TAXES FEES 4,933 186 250 205 200 200 6449 OTHER CONTRACTUAL SERVICE 5,851 1,261 3,000 810 2,000 2,000 6440 OTHER EXPENSES 10,784 1,447 3,25fl 1,015 2,200 2,200 36 CITY OF BROOKLYN CENTER Budget RepoR 2006 2007 2008 9/30l2008 2009 2009 Actual Adual Final YTD Recommended Approved Object Code Descrip6on Amount AmouM Budget Actual Budget Budget 6460 CENTRAL GARAGE CHARGES 6461 FUEL CHARGES 487 473 530 863 950 950 6462 FIXED CHARGES 17,176 6,518 6,690 4,974 7,615 7,615 6463 REPAIR 8� MA1NT CHARGES 6,948 7,302 6,000 3,819 5,800 5,800 6465 REPLACEMENT CHARGES 10,065 12,901 10,424 13,115 13,115 646D CENTRAL GARAGE CHARGES 24,611 24,358 26,121 20,081 27,480 27,480 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 6,000 6,180 6,420 4,815 9,375 9,375 6470 TRANSFERS AND OTHER USES 6,000 6,180 6,420 4,815 9,375 9,375 6490 OTHER MISC COSTS/EXPENSES 6491 MERCHANDISE FOR RESALE 24,932 24,328 24,500 23,097 24,000 24,000 6494 DEPRECIATION EXPENSE 27,170 27,170 30,483 20,396 29,900 29,900 6490 OTHER MISC COSTSIEXPENSES 52,102 51,498 54,983 43,493 53,900 53,900 6299 OTHER CHARGES SERVICES 141,100 130,193 136,829 105,139 138,863 138,863 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6520 BUI�DINGS FACILITIES 26,475 28,000 12,000 12,000 6540 EQUIPMENT MACHINERY 6,500 6,500 6501 CAPITAL OUTLAY 26,475 28,000 18,500 18,500 6500 CAPITAL OUTLAY 26,475 28,000 18,500 18,500 6600 DEBT SERVICE 6001 EXPENDITURESlEXPENSES 286,065 314,255 327,716 232,960 323,951 323,951 4000 REVENUES AND EXPENSES '15,630- 58,072 30,966 9,786- 48,951 48,951 49721 CENTERBROOK GOLF COURSE 15,630- 58,072 30,966 9,78E 48,951 45,951 61300 CENTERBROOK GOLF COURSE 15,630- 58,072 30,966 9,786- 48,951 48,951 37 City of Brooklyn Center Centerbrook Golf Course Cash Flows Actual Actual Estimated Proposed Projected Projected Proje�ted Projected 2006 2007 2008 2009 2010 2011 2012 2013 Revenues Course Fees 250,339 252,620 254,091 274,OOd 295,000 295,000 295,000 295,000 Misc.Operating 118 Misc. Non-operating 51,357 3,445 1,005 1,200 1,200 1,200 1,200 1,200 Total Revenues 301,696 256,183 255,096 275,200 296,200 296,200 296,200 296,200 Expenditures Personal Services 130,070 139,027 136,160 140,245 144,452 148,786 153,249 157,847 Supplies 14,895 18,243 14,225 14,652 15,091 15,544 16,010 16,491 Services 113,929 103,203 106,346 109,536 112,822 116,207 119,693 123,284 Depreciation 27,170 27,170 27,194 27,738 28,293 28,858 29,436 30,024 Debt Transfer 7,512 w Total Expenditures 293,576 287,643 283,925 292,171 300,659 309,395 318,389 327,646 I CapitalOutlay 26,475 28,000 18,500 27,000 24,900 16,000 16,000 Total Cash Requirement 293,576 314,118 311,925 310,671 327,659 334,295 334,389 343,646 Beginning Cash Balance 46,249 81,900 50,970 21,335 13,602 10,436 1,199 (7,554) Changes in Assets/Liabilities 361 (165) Revenues 301,696 256,183 255,096 275,200 296,200 296,200 296,200 296,200 Expenditures (293,576) (314,118) (311,925) (310,671) (327,659) (334,295) (334,389) (343,646) Depreciation Add-Back 27,170 27,170 27,194 27,738 28,293 28,858 29,436 30,024 Ending Cash Balance 81,900 50,970 21,335 13,602 10,436 1,199 (7,554) $(24,975�� Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. C'ity of �roo� Center 2009 Budget FUND: Liquor Operations Fund 60900 DEPT/ACTIVITY/PROJECT: Liquor Store Operations 49611 and 49612 PROFILE This year will represent the ninth full year of operations at the Xe�es Avenue (Store #1) site, and the sixth year at the 69�` and Brooklyn Boulevard (Store #2) site, which opened in January 2004. The profits from the City's retail liquor operations are used to support the costs of park maintenance and expansion, building maintenance and expansion, and other activities that would otherwise require property tax levy increases. DEPARTMENTAL GOALS Continued growth in sales volume through promotion and sales activities. Increase the cash equity in the fund in anticipation of replacement or enhancement to keep the facilities looking fresh and clean Continue the wine club and other marketing efforts to add growth in the area of greatest profitability Build on recently implemented staff training and development efforfs to improves customers service and satisfaction Addition of 1,350 square feet of space at the Xer�ces Avenue (Store #1) site. This space will be used primarily for storage and staging of larger orders between the two stores. The additional space will allow more volume purchasing of stock in order to lower product costs. It will also allow some reduction of floor stock which obstructs traffic and sightlines for security purposes. Additional costs are estimated at 21,465 per year in base rent and 8,722 in additional utilities, common area costs and maintenance. In exchange for the expansion the landlord, Welsh Companies, is asking the City to exercise its option on the location for the full term of the lease, through 2019, at the rates currently agreed upon in the existing lease. Routine replacement of hardware for the cash registers and inventory management system. Additional capital is requested for replacement of the software for cash registers and inventory management (point of sale software) as the software is outdated and inefficient. EXPENDITURE DETAILS 6471 Administrative Service Transfer Out $53,546 Provides for costs of services from personnel provided for in other funds for administrative, financial and support services (information technology, central garage and HR). 39 6476 Capital Project Fund Transfer $265,490 Provides for a base transfer of 135,000 to the Capital Projects Fund to support park and other infrastructure improvements in the City. Also includes a one-time transfer of 130,490 for implementation of building capital maintenance for City Hall, Community Center, Centerbrook golf course and various park structures as allocated by earlier City Council action. PERSONNEL LEVELS 1-Operations Manager 2-Store Managers 1-Assistant Store Manager 1-Office Manager Part-time and seasonal as necessary CAPITAL OUTLAY None requested. 40 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30l2008 2009 20Q9 Actual Actual Final YTD Recommended Approved Object Code Description Amount Amount Budget Actual Budget Budget 60900 BROOKLYN CENTER LIQUOR 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 36,885- 52,468- 30,000- 24,563- 24 ,00a 24,000- 4605 UNREALIZED INVESTMENT GAIN/LOS 211- 752- 4606 OTHER REVENUE 2,039- 6,837- 1,000- 46D0 MISCELLANEOUS REVENUE 39,135- 60,056- 30,000. 25,563- 24,000- 24,000- 4599 MISCELLANEOUS REVENUE 39,135- 60,056- 30,000- 25,563- 24,000- 24,000- 4760 LIQUOR STORE OPERATIONS 4761 LIQUOR SALES 1,801,434 1,953,382- 2,072,300- 1,459,606- 1,994,500- 1,994,500- 4762 WINE SALES 610,760- 640,000- 690,700- 438,054- 596,500- 596,500- 4763 BEER SALES 2,551,885- 2,688,262- 2,820,600- 1,993,049- 2,712,500- 2,712,500- 4764 SALES-NON TAXABLE 109,510- 95,648- 85,000- 78,229- 105,500- 105,500- 4765 SALES-TAXABLE 77,749- 97,322- 87,800- 65,548- 91 ,00a 91,000- 4766 MISCELLANEOUS SALES 8,830- 4767 BOTTLE DEPOSIT REVENUE 1,183 4760 LIQUOR STORE OPERAT�ONS 5,158,986- 5,474,634 5,756,400- 4,D31,486- 5,500,000- 5,500,000- 4900 OTHER FINANCING SOURCES 21 REFUNDS REIMBURSEMENTS 3,217- 3,284- 1,079- 700- 700- 22 PROJECTADMINISTRATION 2,639- 3,155- 2,60D- 2,306- 2,600. 2,600- 4900 OTHER FINANCING SOURCES 5,855- 6,439- 2,600- 3,385- 3,300- 3,300- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5581 COST OF SALES-LIQUOR 1,324,657 1,422,564 1,519,000 1,013,566 1,381,670 1,381,670 5582 COST OF SALES-WINE 419,402 438,279 473,800 296,045 415,745 415,745 5563 COST OF SALES-BEER 1,992,213 2,100,076 2,197,200 1,517,422 2,088,625 2,088,625 5584 OTHER COSTS OF SALE-NONTAXABLE 68,539 61,694 55,100 SD,765 68,575 68,575 5585 OTHER COSTS OF SALE-TAXABLE 55,032 65,807 60,500 44,552 62,500 62,500 5586 COST OF SAIES-MISC 5,450 5587 INVENTORY VARIANCES 21,927 13,293 6,226 15,000 15,000 5589 DEGVERY CHARGES 23,595 24,104 20,500 17,764 22,000 22,000 5580 COST OF GOODS SOLD 3,911,016 4,125,817 4,326,100 2,946,360 4,054,115 4,054,115 5550 DIRECT COST OF SALES 3,911,016 4,125,817 4,326,100 2,946,360 4,054,115 4,054,115 4001 REVENUES 1,292,959- 1,415,312- 1,462,900- 1,114,074- 1,473,185- 1,473,185- 6001 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARfES 6101 WAGES SALARIES-FT EMPLOYEES 174,584 215,177 276,367 187,423 277,615 277,615 6103 WAGES-PARTTIMEEMPLOYEES 225,646 214,109 224,800 163,643 238,000 238,000 6104 OVERTIME-PART TIME EMPLOYEES 4,371 3,758 3,000 4,942 4,000 4,000 6100 WAGES AND SALARIES 404,601 433,044 504,167 356,208 519,615 519,6'IS •6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 14,081- 2,882 6110 OTHER PAYMENTS-NON INSURANCE 14,081- 2,682 6120 RETIREMENT CONTRIBUTIONS 41 CITY OF BROOKLYN CENTER Budget Report 2006 20D7 2008 9/30l2008 2009 2009 Actual Actual Final YTD Recommended Approved Objeet Code Description Amount Amount Budget Actual Budget Budget 6122 PERA COORDINATED PLAN 23,567 25,495 32,771 22,383 35,073 35,Q73 6125 FICA 24,354 27,820 31,006 22,293 32,217 32.2�7 6126 MEDICARE CONTRIBUTIONS 5,696 6,506 7,562 5,214 7,533 7,533 I 6120 RETIREMENT CONTRIBUTIONS 53,617 59,821 71,339 49,889 74,823 74,823 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 16,483 25,506 45,500 25,628 51,060 51,060 6130 INSURANCE BENEFITS 16,483 25,506 45,500 25,628 51,060 51,060 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 6 6140 UNEMPLOYMENTCOMPENSATlON 6 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 6,576 8,713 11,797 8,405 11,380 11,380 6150 WORKER'S COMPENSATION 6,576 8,713 11,797 8,405 11,380 11,380 6099 PERSONAL SERVICES 469,202 529,966 632,803 440,130 656,878 656,876 6199 SUPPLIES 6200 OFFICE SUPPLIES 1 400 6201 OFFICE SUPPLIES 1,622 1,205 550 1,173 1,400 6202 COPYING SUPPUES 414 175 61 100 100 203 BOOKS/REFERENCE MATERIALS 32 6200 OFFICE SUPPLIES 2,268 1,205 725 1,233 1,500 1,500 6210 OPERATING SUPPLIES 6214 CLOTHING PERSONAL EQUIPMENT 1,132 1,874 1,750 474 1,&00 1,6D0 6219 GENERAL OPERATING SUPPLIES 14,283 15,008 14,OOU 10,813 14,000 14,000 6210 OPERATING SUPPLIES 15,415 16,682 15,750 11,286 15,600 15,600 6220 REPAIR MAINT SUPPLIES 6223 BUILD�NGS FACILITIES �,55� 3�Z I 6220 REPAIR 8 MAINT SUPPLIES 1,557 3�2 6230 REPAIR 8 MAINT SUPPUES-OTHER 32 6237 LAUNDRY SUPPLIES 6230 REPAIR MAINT SUPPUES-OTHER 32 6240 SMALL TOOLS MINOR EQUIPMENT 6242 MINOR EQUIPMENT 1,763 5,430 6,000 145 12,000 12,000 1500 4,229 31,842 31,642 4 761 I 288 6243 MWOR COMPU TER EQUIPMENT 6240 SMALL TOOLS MINOR EQUIPMEN7 6,051 6,191 7,500 4,374 43,842 43,842 6199 SUPPUES 25,291 24,279 23,975 17,239 60,942 60.942 6299 OTHER CHARGES SERVICES 6300 PROFESSIONAL SERVICES i 6301 ACCTG, AUDIT FIN'L SERVICES 3,149 3,253 5,000 4,498 5,000 5,OD0 1 500 6303 LEGAL SERVICES 6307 PROFESSIONAL SERVICES z�899 799 1,000 198 12,350 12, 350 6,047 4,052 7,500 4,696 17,350 17,350 63DD PROFESSIONAL SERVICES 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 5,237 5,179 5,448 3,542 5,400 5,400 5 400 5,400 6320 COMMUNiCATIONS 5,237 5,178 5,44a 3,542 42 CITY OF BROOKLYN CENTER Budget Report 20D6 2�07 2008 9/30/2008 2009 2009 Actual Actual Finai YTD Recommended Approved Objeet Code Description Amount Amount Budget Actual Budget Budget 6330 TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 313 527 750 337 750 750 6330 TRANSPORTATION 313 527 750 337 750 750 6340 ADVERTISING 6341 PERSONNELADVERTiSWG 937 766 1,250 1,702 1,700 1,700 6349 OTHER ADVERTISING 14,096 13,972 17,000 6,253 14,000 14,000 6340 ADVERTISING 15,033 14,738 18,250 7,955 15,700 15,700 6350 PRINTING AND DUPLICATING 6351 PRINTING 67 750 6350 PRINTING AND DUPLICATING 87 750 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 1,015 931 1,100 742 1,100 1,100 6362 PROPERTY INSURANCE 1,254 1,328 1,350 1,229 1,795 1,795 6364 DRAM SHOP INSURANCE 8,556 8,860 9,500 6,870 10,135 10,135 6366 MACHINERY BREAKDOWN INSURANCE 405 409 475 359 535 535 6360 INSURANCE 11,229 11,527 12,425 9,201 13,565 13,565 6380 UTILITY SERVICES 6381 ELECTRIC 28,362 29,396 29,000 23,926 29,000 29,000 382 GAS 8,744 7,273 9,500 7,368 8,500 8,500 360 UTILITY SERVICES 37,106 36,669 38,500 31,294 37,500 37,500 6400 REPAIR MAINT SERVICES 6402 EQUIPMENT SERVICES 248 532 1,500 953 1,000 1,000 6403 BLDGS/FAGILITIES MAINT SERVICE 964 2,080 2,000 2,229 2,500 2,500 6409 OTHER REPAIR MAINT SVCS 341 508 6400 REPAIR 8 MAINT SERVICES 1,553 3,120 3,500 3,182 3,5D0 3,500 6410 RENTALS 6412 BLDGS/FACIUTIES 242,801 245,407 243,360 183,472 243,360 243,360 641D RENTALS 242,501 245,407 243,360 183,472 243,360 243,360 6420 IS SERVICES/LICENSESlFEES 6421 SOFTWARE LICENSE 400 593 15,657 15,657 6422 SOFTWARE MAINT 3,321 1,295 839 821 3,410 3,410 6423 LOGIS CHARGES 6,491 9,367 10,056 7,596 13,106 13,106 6428 PROTECTiON SERVICES 1,062 667 535 6420 IS SERVICES/LICENSES/FEES 10,874 11,729 10,895 9,545 32,173 32,173 643D MISCELLANEOUS 6431 SPECIAL EVENTS 4,545 5,082 5,100 2,847 6,300 6,300 6432 CONFERENCES AND SCHOOLS 1,031 1,158 1,700 1,143 1,800 1,800 6434 DUES SUBSCRIPTIONS 2,770 2,463 3,900 2,126 3,700 3,700 6435 CREDIT CARD FEES 56,479 56,866 52,000 45,106 62,000 62,000 6438 CASH SHORT (OVER) 190 2,670 1,000 757 1,350 1,350 6430 MISCELLANEOUS 65,015 68,240 63,700 51,978 75,150 75150 �6440 OTHER EXPENSES 6441 LICENSES, TAXES FEES 1,660 1,400 1,400 1,400 6449 OTHER CONTRACTUAL SERVICE 4,838 6,848 6,500 6,856 6,500 6,500 6440 OTHER EXPENSES 6,498 6,848 7,900 6,856 7,900 7,900 43 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2006 2009 2009 Actual Actual Final YTD Recommended Approved Object Code Description Amount Amount Budget Actual Budget Budget 6460 CENTRAL GARAGE CHARGES 450 450 6461 FUELCHARGES 129 63 225 349 967 940 1,529 716 1,060 1,060 6462 FIXED CHARGES 400 400 6463 REPAIR MAINT CHARGES 296 1,771 283 6465 REPLACEMENT CHARGES 155 2,037 1,569 2.206 2,206 6460 CENTRAL GARAGE CHARGES 1,392 2,928 3,791 2,938 4,116 4,116 6470 TRANSFERS AND OTHER USES 39,023 40,194 51,420 38,565 53,546 53,546 6471 ADMINISTRATIVE SERVICE TRANSFE Z65,490 265,490 6476 CAPITAL PROJECT FUND TRANSFER 125,000 125,000 135,000 6470 TRANSFERS AND OTHER USES 164,023 165,194 186,420 38,565 319,036 319,036 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 26,359 26,359 27,600 19,787 26,500 26,500 6490 OTHER MISC COSTS/EXPENSES 26,359 26,359 27,600 19,787 26,500 26,500 6299 OTHER CHARGES SERVICES 593,567 602,518 630,789 373,349 802,000 802,000 6500 CAPITAL OUTLL:'I 6501 CAPITAL OUTLAY 600 DEBT SERVICE 001 EXPENDITURES/EXPENSES 1,088,061 1,156,763 1,287,567 830,718 1,519,820 1,519,820 4000 REVENUES AND EXPENSES 204,898- 258,550- 175,333- 283,356- 46,635 46,635 60900 BROOKLYN CENTER LIQUOR 204,896- 258,550- 175,333- 283,356- 46,635 46,635 44 City of Brooklyn Center BC Liquor Cash Flows Actual Actual Estimated Proposed Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 Revenues Customer Receipts 5,159,152 5,473,017 5,690,823 5,500,000 5,555,000 5,610,550 5,666,656 5,723,322 Misc.Operating 7,894 13,275 4,385 9,800 9,800 9,800 9,800 9,800 Misc. Non-operating 37,095 53,219 32,750 24,000 29,075 30,068 30,330 29,805 Total Revenues 5,204,141 5,539,511 5,727,958 5,533,800 5,593,875 5,650,418 5,706,785 5,762,927 Expenditures Personal Senrices 468,976 527,273 632,803 656,878 683,153 710,479 738,898 768,454 Supplies 25,291 24,279 31,966 60,942 62,770 64,653 66,593 68,591 Services 442,208 451,159 471,416 510,010 525,310 541,070 557,302 574,021 Cost of Good Sold 3,911,016 4,125,817 4,268,117 4,054,115 4,082,925 4,123,754 4,164,992 4,206,642 Depreciation 26,359 26,359 26,382 26,500 26,500 26,500 26,500 26,500 Debt Transfer Total Expenditures 4,873,850 5,154,887 5,430,684 5,308,445 5,380,659 5,466,456 5,554,285 5,644,208 Capital Transfer 125,000 125,000 346,470 265,490 200,000 200,000 200,000 200,000 Total Cash Requirement 4,998,850 5,279,887 5,777,154 5,573,935 5,580,659 5,666,456 5,754,285 5,844,208 Beginning Cash Balance 720,417 949,471 1,199,465 1,176,65� 1,163,016 1,202,733 1,213,195 1,192,195 Changes in Assets/Liabilities (2,596) (35,989) Revenues 5,204,141 5,539,511 5,727,958 5,533,800 5,593,875 5,650,418 5,706,785 5,762,927 'I Expenditures (4,998,850) (5,279,887) (5,777,154) (5,573,935) (5,580,659) (5,666,456) (5,754,285) $(5,844,208) Depreciation Add-Back 26,359 26,359 26,382 26,500 26,500 26,500 26,500 26,500 Ending Cash Balance 949,471 1,199,465 1,176,651 1,163,016 1,202,733 1,213,195 1,192,195 1,137,414 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. L'Z�10f B1'DO� C��' 2009 Budget FUND: Earle Srown Heritage Center 61700 DEPT/ACTIVITY/PROJECT: Summary 49851, 49852, 49853, 49854, 49855 PROFILE The following pages provide a summary presentation of the budget plan for tlie entire Earle Brown Heritage Center operation. Following the suirunary axe the individual divisional plans that make up the summary plan. 46 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9l30/2008 2009 2009 Adual Adual Final YTD Recommended Approved Objed Code Description Amount Amourrt Budget AGuai Budget Budget 61700 EARLE BROWN HERITAGE CENTER 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCEILANEOUS REVENUE 4603 INTEREST EARNINGS 46,220- 53,606- 40,000- 23,191- 28,004 28,000- 4605 UNREALIZED INVESTMENT GAIN/LOS 259- 725- 4606 OTHER REVENUE fi73- 2,05& 196- 4609 UNCOLLECTIBLE WRITE OFFS 13,764 4600 MISCELLANEOUS REVENUE 47,152- 42,621- 40,000. 23,387- 28,000- 28,OOa 4599 MISCELLANEOUS REVENUE 47,152- 42,621- 40,000- 23,387- 28,000- 28,000- 4800 EBHC 4810 INN ON THE FARM 4811 GUEST ROOM RENTALS 46,950- 35,210- 33,000- 8,470- 4812 FACILIN RENTALS 6,550- 7,610- 7,400- 175- 4814 EQUIPMENT RENTALS 2,575- 1,782- 2,000- 30. 4815 MISCELLANEOUS 200- 12- 200- 4810 INN ON THE FARM 56,275- 44,614 42,600- 8,675- 4820 CONVENTION CENTER 4821 ROOM RENTALS 536,820- 625,516- 660,OOa 458,804- 600,000- 600,000- 4821.1 CMP ROOM RENTALS 28,334- 35,080- 47,600- 52,492- 50,000- 50,000- 4821 ROOM RENTALS 565,154- 660,596- 707,600- 511,296- 650,000- 650,000- 4822 LABOR CHARGES '15,625- 13,922- 12,000- 10,498- 10,500- 10,50a 4823 EQUIPMENT RENTALS 259,542- 277,749- 260,000- 211,576- 260,OOa 260,000- 4823.1 CMP EQUIPMENT RENTALS 9,929- 13,355- 22,600- 25,435 22,600. 22,600- 4823 EQUIPMENT RENTALS 269,471- 291,104- 282,600- 237,011- 282,60o- 282,600- 4826 DANCE FLOOR RENTALS 26,275- 23,556- 29,800- 8,360- 22,400- 22,40a 4827 SECURITY SERVICES 30,245 27,035- 22,500- 16,700- 20,500- 20,500- 4828 CLIENT SERVICES 36,057- 39,027- 42,000- 25,156- 35,500- 35,500- 4829 MISCELLANEOUS 3,474- 3,601- 3,500- 1,826- 3,500- 3,500- 4820 CONVENTION CENTER 946,301- 1,058,842- 1,100,OD0- 810,846- 1,025,000- 1,025,000- 4830 OFFICE RENTAL 4831 OFFICE RENTALS 66,254- 68,390- 62,691- 47,494- 81,030. 81,030- 4830 OFFICE RENTAL 66,254 68,390- 62,691- 47,494 81,030- 81,030. 4840 CATERING SERVICES 4842 SERVICE CHARGES 479,41& 476,529- 514,200- 298,857- 514,200- 514,200- 4844 FOOD BEVERAGE SALES 2,290,647- 2,299,987- 2,276,500- 1,485,023- 2,203,350. 2,203,350. 4844.1 FOOD BEVERAGE SALES, INN 1D,655- 13,433- 166- 4845 LIQUOR/WINE/BEER SALES 371,41G 336,324 375,000- 198,009- 375,OOa 375,000- 4845.1 LIQUOR/WWE/BEER SALES, INN 452- 370- 4848 MISCELLANEOUS SALES 37,635 39,58& 16,500- 34,302- 11,650- 11,650- 4849 MISCELLANEOUS SALES-NON TAXABL 1,114 982- 840- 4840 CATERING SERVICES 3,191,33& 3,167,214 3,182,200- 2,017,198- 3,104,200- 3,1D4,200- �4800 EBHC 4,260,168- 4,339,060- 4,367,491- 2,884,212- 4,210,230- 4,210,230- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 40,903 4921 REFUNDS REIMBURSEMENTS 36,972- 2,759- '1,551- 47 CITY OF BROOKLYN CENTER Budget Repat I 2D06 2007 2006 9/30/2008 2009 2009 AGuaI Adual Final YTD Rec:ommended Approved ObjeG Code Description Amount Amount Budget AGual Budget Budget 4900 OTHER FINANCING SOURCES 77,874 2,75& 1,551- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD 5586 COST OF SALES-MISC 35 5580 COST OF GOODS SOLD 35 5590 EBHC CONTRACT EXPENSES 5591 COST OF SALES-LABOR 1,273,968 1,339,691 1,333,984 755,298 1,296,185 1,296,185 5592 COST OF SALES-FOOD 565,565 553,048 581,975 290,649 522,600 522,600 5593 COST OF SALES-SUPPLIES 149,419 154,336 168,625 94,502 147,702 147,702 140 000 115 000 1D0,000 68,400 105,00 0 105 000 5594 COST OF SALES-MGMT FEES S590 EBHC CONTRACT EXPENSES 2,128,951 2,162,075 2,184,584 1,208,848 2,071,487 2,071,487 5550 DIRECT COST OF SALES 2,128,951 2,162,075 2,184,584 1,208,884 2,071,487 2,071,487 4001 REVENUES 2,256,243 2,222,364 2,242,907- 1,700,267- 2,166,743- 2,166,743- 6001 EXPENDITURESIEXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES SALARIES-FT EMPLOYEES 501,785 509,693 537,056 377,236 543,671 543,671 6102 OVERTIME-FT EMPLOYEES 1,175 1,373 950 1,113 6103 WAGES-PARTTIMEEMPLOYEES 179,466 192,432 208,000 134,968 182,000 182,000 6104 OVERTIME-PART TIME EMPLOYEES 304 245 400 400 400 6100 WAGES AND SALARIES 682,730 7D3,743 746,406 513,318 726,071 726,077 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 5,108 3,606 6110 OTHER PAYMENTS-NON INSURANCE 5,108 3,606 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 38,115 40,059 48,517 30,936 49,085 49,085 6125 FICA 42,301 44,162 45,904 32,564 45,084 45,084 6126 MEDICARE CONTRIBUTIONS 9,893 10,328 11,197 7,616 10,544 10,544 6120 RETIREMENT CONTRIBUTIONS 9D,309 94,549 105,618 71,115 104,713 104,713 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 84,567 89,132 1D0,100 65,513 112,332 112,332 6130 INSURANCE BENEFITS 84,567 89,132 100,100 65,513 112,332 112,332 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 6140 UNEMPLOYMENT COMPENSATION 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 18,864 18,302 12,548 16,373 21,391 21,391 6150 WORKER'S COMPENSATION 18,864 18,302 12,548 16,373 21,391 21,391 6D99 PERSONAL SERVICES 681,578 909,332 964,672 666,388 964,507 964,507 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFF4CE SllPPLIES 3,315 3,908 3,400 1,388 3,400 3,400 6202 COPYING SUPPLIES 1,839 2,210 Z,O50 1,955 2,500 2,500 6203 BOOKS/REFERENCE MATERIALS 31 6200 OFFICE SUPPLIES 5,154 6,118 5,450 3,374 5,900 5,90D 48 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2006 9l30l2008 2009 2009 Actual Adual Final YTD Recommended Approved Object Code Description Amount AmouM Budget Actual Budget Budget 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 5,101 7,529 6,700 3,670 6,450 6,450 6212 MOTOR FUELS 10 50 50 50 6214 CLOTHING PERSONAL EQUIPMENT 1,210 431 1,200 856 1,200 1,200 6215 SHOP MATERIALS 790 379 800 54 b50 550 6216 CHEMICAIS/CHEMIGAL PRODUCTS 4,207 3,969 5,100 3,146 5,700 5,700 988 2411 880 957 1,35 0 1 350 1 AFETY SUPPLIES 62 7 S 6219 GENERAL OPERATING SUPPLIES 35,039 28,560 31,950 18,445 30,100 30,100 6210 OPERATING SUPPLIES 47,335 43,310 46,680 27,127 45,400 45,400 6220 REPAIR MAINT SUPPLIES 6223 BUILDINGS 8 FACILITIES 21,942 33,666 34,850 17.074 29,450 29,450 6225 PARK LANDSCAPE MATERIALS 3,402 2,294 3,800 1,559 3,800 3,600 6226 SIGNS STRIPING MATERIALS 331 76 800 900 900 6227 PAINT SUPPLIES 2,858 1,600 2,600 1,756 2,200 2,200 6220 REPAIR MAINT SUPPLIES 28,533 37,636 42,056 20,388 36,350 36,350 6230 REPAIR MAWT SUPPLIES-OTHER 6237 LAUNDRY SUPPLIES 181 265 175 28 100 100 6239 OTHER REPAIR MAINT SUPPLIES 6,183 5,943 6,750 4,637 6,700 6,70D 6230 REPAIR MAINT SUPPLIES-OTHER 6,364 6,208 6,925 4,666 6,800 6,800 6240 SMALL TOOLS MINOR EQUIPMENT 6241 SMALLTOOLS 981 970 950 746 1,050 1,050 6242 M1NOR EQUIPMENT 51,538 41,778 66,500 18,661 61,500 61,500 6243 MINOR COMPUTER EQUIPMENT 16,164 6,408 4,637 4,500 4,SD0 6240 SMALL TOOLS MINOR EQUIPMENT 68,683 49,157 67,450 24,044 67,050 67,050 6199 SUPPLIES 156,069 142,428 168,555 79,598 161,500 161,500 6299 OTHER CHARGES SERVICES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT FIN'l SERVICES 3,672 3,323 3,600 3,238 3,400 3,400 6303 LEGAL SERVICES 2,741 1,645 1,200 98 1,200 1,20� 63D7 PROFESSIONAL SERVICES 16,OD7 9,302 44,500 10,251 19,800 19,800 6319 07HER PROFESSIONAL SERVICES s 6300 PROFESSIONAL SERVICES 22,420 14,276 49,300 13,587 24,400 24,400 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 9,065 6,599 9,520 5,627 8,260 8,260 6322 POSTAGE 2,960 3,072 3,800 1,950 3,400 3,400 6320 COMMUNICATIONS 12,025 11,671 13,320 7,577 11,660 11,660 6330 TRANSPORTATtON 6331 TRAVEL EXPENSE/MILEAGE 1,025 1,127 875 720 925 925 6333 FREIGHT/DRAYAGE 123 86 205 252 450 450 6330 TRANSPORTATION 1,148 1,213 1,080 972 1,375 1,375 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 2,546 3,596 2,600 2,227 2,300 2,300 6349 OTHER ADVERTISING 70,322 83,209 70,000 59,523 62,000 62,000 4 300 6340 ADVERTISING 72,868 66,804 72,600 61,750 64,300 6, 6350 PRINTING AND DUPLICATING 6351 PRINTING 6,916 9,971 7,700 7,571 9,000 9,000 49 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2009 2009 Actual Actual Final YTD Recommended Approved Object Code Description Amount Amount Budget Actual Budget Budgei 6350 PRINTING AND DUPUCATWG 6,916 9,971 7,700 7,571 9,000 9,000 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 16,505 18,036 17,784 11,616 18,100 18,100 6362 PROPERTY WSURANCE 26,138 28,150 26,148 20,767 32,025 32,025 6364 DRAM SHOP INSURANCE 545 6366 MACHINERY BREAKDOWN INSURANCE 1,997 1,993 1,456 1,488 2,295 2,295 6360 WSURANCE 44,640 48,179 45,933 33,871 52,420 52,420 6380 UTILITY SERVICES 6381 ELECTRIC 130,825 138,349 144,500 98,611 143,300 143,300 6362 GAS 68,962 62,455 78,800 6D,351 105,500 105,500 6383 WATER 2,224 1,971 3,200 697 1,950 1,950 6384 REFUSE DISPOSAL 11,840 10,812 10,700 6,946 10,500 10,500 6385 SEWER 4,283 3,334 4,750 1,077 2,550 2,550 6386 STORM SEWER 2,703 2,975 3,600 1,719 2,900 2,900 6389 STREET LIGHTS 505 535 670 305 550 550 6380 UTILITY SERVICES 221,342 220,430 246,220 169,706 267,250 267,250 6400 REPAIR 8 MAINT SERVICES 6402 EQUIPMENT SERVICES 73,731 56,435 52,000 47,660 56,700 56,700 6403 BLDGS/FACILITIES MAINT SERVICE 5,640 13,317 6,500 4,447 7,500 7,500 6408 COMMUNICATIONlINFO SYSTEMS 1,047 97 236 6409 OTHER REPAIR MAINT SVCS 1,462 1,699 2,350 988 1,900 1,900 6400 REPAIR MAINT SERVICES 81,881 71,548 60,850 53,331 66,100 66,100 6410 RENTALS 6413 OFFICE EQUIPMENT 9,762 6,590 8,500 3,498 5,300 5,300 6415 OTHER EQUIPMENT 138,560 139,856 133,000 109,008 140,000 140,000 6410 RENTALS 148,323 146,446 141,500 112,507 145,300 145,300 6420 IS SERVICES/LICENSES/F£ES 6421 SOFTWARE LICENSE 211 6422 SOFTWARE MAINT 2,667 2,733 2,718 2,649 3,632 3,632 6423 LOGIS CHARGES 14,288 13,790 17,255 8,500 18,647 18,647 6428 PROTECTION SERVICES 2D,513 23,067 21,100 9,597 15,000 15,000 6420 IS SERVICES/LICENSESlFEES 37,678 39,590 41,073 20,747 37,279 37,279 643D MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 7,157 7,468 14,100 6,222 14,100 14,100 6433 MEETING EXPENSES 293 677 450 778 500 500 6434 DUES SUBSCRIPTIONS 3,084 4,396 3,800 3,286 3,600 3,800 6435 CREDIT CARD FEES 23,738 16,696 22,139 12,038 19,650 19,650 6436 UNCOLLECTIBLE CHECKS/DEBTS 1,900- 12,466- 6438 CASH SHORT (OVER) 24a 280 47- 6430 MISCELLANEOUS 32,132 17,051 40,489 22,276 38,050 38,050 6440 OTHER EXPENSES 6441 LICENSES, TAXES 8 FEES 24,180 19,400 19,950 13,920 6,8DD 6,800 6442 COURT AWARDS/SETTLEMENTS 2,960 1,247 6449 OTHER CONTRACTUAL SERVICE 26,285 28,704 26,850 20,182 27,200 27,200 6440 OTHER EXPENSES 53,425 49,351 46,800 34,102 34,000 34,000 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 83,582 86,089 67,994 50,996 68,001 68,001 6476 CAPITAL PROJECT FUND TRANSFER 300,000 230,000 200,000 200,000 200,000 50 CITY OF BROOKLYN CEN7ER Budget Report 2009 2009 2006 2007 2008 9/30/2008 Aduai Actual Final YTD Rewmmended Approved Object Code Description Amount Amourrt Budget Actual Budget Budget 6470 TRANSFERS AND OTHER USES 383,582 316,089 267,994 50,996 268,001 268,001 6490 OTHER MISC COSTSIEXPENSES 6494 DEPRECIATION EXPENSE 576,401 577,535 583,492 433,547 492,635 492,635 6490 OTHER MISC COSTSIEXPENSES 578,401 577,535 583,492 433,547 492,635 492,635 6299 OTHER CHARGES SERVICES 1,696,780 1,610,154 1,618,351 1,022,538 1,511,770 1,511,770 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 2,734,427 2,661,914 2,751,578 1,768,525 2,637,777 2,637,777 40D0 REVENUES AND EXPENSES 476,184 439,550 508,671 68,258 471,034 471,034 61700 EARLE BROWN HERITAGE CEIVTER 478,184 439,S5U SD8,671 68,258 471,034 471,034 51 Cit�y of �roo� Center 2009 Budget FUND: Earle Brown Heritage Center 61700 DEPT/ACTIVITY/PROJECT: Administration 49851 PROFILE The Administration division provides overall administrative duties for the entire complex including, but not limited to, commercial office, convention center, catering and the Inn on the Farm. DEPARTMENTAL GOALS Oversee and support the work of the various divisions within the complex. Provide a high level of customer service to guests and vendors. EXPENDITURE DETAILS 6307 Professional Services $1,800 Insurance Service fee from T.C. Field and Company 6432 Conferences and Schools $4,100 Professional development for General Manager through IAAM (International Association of Assembly Managers) and for educational speakers related to training for facility staff. 6422 Software Maintenance $2,732 Covers anti-spyware software, extends license agreements and internet filtering. 6423 Logis Charges $18,647 Includes an 2.5% increase in charges for system support PERSONNEL LEVELS 1-EBHC Manager 1- Secretary/Receptionist 1-SecretaryBilling Clerk CAPITAL OUTLAY See Capital Projects Fund 52 CITY OF BROOKLYN CENTER Budget Report 2006 2D07 2008 9/30/20D8 2D09 20Q9 Aetual Adual Final YTD Recommended Approved Objed Code Description Amount Amount Budget Actual Budget Budget 61700 EARLE BROWN HERITAGE CENTER 49851 EBHC-ADMINISTRATION 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4603 INTEREST EARNINGS 46,220- 53,60& 40,000- 23,191- 28,000- 28,000- 4605 UNREALIZED INVESTMENT GAINILOS z59- �25' 4600 MISCELLANEOUS REVENUE 46,479- 54,331- 40,000- 23,191- 28,OOa 28,000- 4599 MISCELLANEOUS REVENUE 46,479- 54,331- 40,000- 23,191- 28,000- 28,000- 4900 OTHER FINANCING SOURCES 4921 REFUNDS REIMBURSEMENTS 483- 55- 72 49D0 OTHER FINANCING SOURCES 483- SS �Z' 4D01 REVENUES 46,962- 54,386- 40,000- 23,263- 28,000- 28,000- 6�01 EXPEUDITURES/EXPENSES 6099 PERSONALSERVICES 6100 WAGES AND SALARIES 6101 WAGES SALARIES-FT EMPLOYEES 150,056 154,487 161,300 110,189 161,200 161,200 6100 WAGES AND SALARIES 150,056 154,487 161,300 110,189 161,200 161,200 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 1,383 1,022 6110 OTHER PAYMENTS-NON INSURANCE 1,383 1,022 6120 RETIREMEM CONTRIBUTIONS 6122 PERA COORDINATED PLAN 9,003 9,648 10,485 7,156 10,881 10,881 6125 FICA 9,490 9,726 9,920 6,858 9,995 9,995 6126 MEDICARE CONTRIBUTIONS 2,219 2,275 2,420 1,604 2,337 2.337 6120 RETIREMENT CONTRIBUTIONS 20,712 21,648 22,825 15,618 23,213 23,213 6130 WSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 24,119 26,460 27,300 18,856 30,636 30,636 6130 INSURANCE BENEFITS 24,119 26,460 27,300 18,858 30,636 30,636 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 900 1,027 2,581 962 1,161 1,161 6150 WORKER'S COMPENSATION 900 1,027 2,581 962 1,161 1,161 6099 PERSONAL SERVICES 197,171 204,644 214,006 145,628 216,210 216,210 6199 SUPPLIES 6200 OFFICE SUPPLIES 620'I OFFICE SUPPLIES d 6200 OFFiCE SUPPLIES 47 6210 OPERATING SUPPLIES 6219 GENERAL OPERATING SUPPLIES �8� Zs� 6210 OPERATING SUPPLIES 181 261 6220 REPAIR MAINT SUPPLIES 6240 SMALL TOOLS MINOR EQUIPMENT 53 CITY OF BROOKLYN CENTER Budget Report 2006 2D07 2008 9/30/2008 2�09 2009 Actual Adual Final YTD Recommended Approved Object Code Description Amount Amount Budget Adual Budget Budget 6243 MINOR COMPUTER EQUIPMENT 9,370 1,402 3,000 3,000 6240 SMALL TOOLS 8 MINOR EQUIPMENT 9,370 1,402 3,000 3,000 6199 SllPPLIES 9,551 1,710 3,000 3,000 6299 OTHER CHARGES 8 SERVECES 6300 PROFESSIONAL SERVICES 6301 ACCTG, AUDIT FIN'L SERVICES 3,672 3,323 3,600 3,238 3,400 3,400 6303 LEGAL SERVICES 1,575 1,200 98 1,200 1,200 6307 PROFESSIONAL SERVICES 1,477 1,779 1,500 2,200 1,800 1,800 6300 PROFESSIONAL SERVICES 5,149 6,677 6,300 5,536 6,400 6,400 6330 TRANSPORTATION 6340 ADVERTISING 6341 PERSONNEL ADVERTISING �,�68 6340 ADVERTISING 1,166 6350 PRINTING AND DUPLICATING I'' 636o INSURANCE 6361 GENERAL IIABILITY INSURANCE 3,988 4,129 4,226 2,772 4,600 4,600 6362 PROPERTY (NSURANCE 5,612 6,806 6,475 5,074 8,400 8,400 6366 MACHWERY BREAKDOWN INSURANCE 429 472 498 361 60D 600 6360 (NSURANCE 10,028 11,407 11,199 8,208 13,600 13,600 6400 REPAIR MAINT SERVICES 6408 COMMUNICATIONIINFO SYSTEMS 1,047 39 236 6400 REPAIR MAWT SERVICES 1,047 39 236 6420 IS SERVICES/LICENSES/FEES 6421 SOFTWARE UCENSE 211 6422 SOFTWARE MAINT 2,667 2,733 2,718 2,649 3,632 3,632 6423 LOGIS CHARGES 12,360 12,974 17,255 8,500 18,647 18,647 6420 IS SERVIGES/LICENSES/FEES 15,237 15,707 19,973 11,149 22,279 22,279 6430 MISCELLANEOUS 6432 CONFERENCES AND SCHOOLS 1,200 1,673 4,100 1,720 4,100 4,100 6430 MISCELLANEOUS 1,200 1,673 4,100 1,720 4,100 4,100 6440 OTHER EXPENSES 6470 TRANSFERS AND OTHER USES 6471 ADMINISTRATIVE SERVICE TRANSFE 83,582 86,089 67,994 50,996 68,001 68,001 6476 CAPITAL PROJECT FUND TRANSFER 300,000 230,000 200,000 200,000 2Q0,00� 647U TRANSFERS AND OTHER USES 383,582 31fi 267,994 50,996 268,001 268,001 6490 OTHER MISC COSTSIEXPENSES 6494 DEPRECIATION EXPENSE 30,808 30,808 36,292 23,127 30,835 30,835 6490 OTHER MISC COSTS/EXPENSES 30,808 30,808 36,292 23,127 30,835 30,835 6299 OTHER CHARGES SERVICES 447,051 382,400 345,858 102,140 345,215 345,215 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 54 i CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9130/2006 2009 2009 Adual Actual Final YTD Recommended Approved Objed Code Description Amount Amount Budget Actual Budget Budget 6600 DEBT SERVICE 6001 EXPENDITURES/EXPENSES 653,773 588,754 559,864 247,768 564,425 564,425 4000 REVENUES AND EXPENSES 606,812 534,368 519,864 224,504 536,425 536,425 49851 EBHC-ADMINISTRATION 606,812 534,368 519,864 224,504 536,425 536,425 55 G`ity of Broo� Center 2009 Budget FUND: Earle Brown Heritage Center 61700 DEPT/ACTIVITY/PROJECT: Convention Center 49852 PROFILE The Convention Center, in conjunction with the Catering Department, provides a fiill service conference and event location. The business mix is 65% corporate, 8% social, 2% shows, 5% government/health, and 19% weddings. Economic impact directly affecting Brooklyn Center includes hotel, restaurant, shopping and convention service related business activity (floral, printing, rental, etc.) DEPARTMENTAL GOALS Promote the facility in accordance with the 2009 Marketing Plan. Participate in five industry associations to network far referral business. Add a minimum of ten new corporate clients. Participate in four trade show opportunities to promote the Heritage Center in the marketplace. Combine out-state and out-of-state advertising with the Visit Minneapolis North Convention and Visitor's Bureau to attract new business. i Actively work with the new Embassy Suites for future business development complimentary and lucrative to both facilities EXPENDITURE DETAILS 6307 Professional Services $18,000 Funds for agency development and production of advertising. 6381 and 6382 Electric and Gas Utilities $115,000 and 530,000 Increased electric budget and gas budget due to projected economic costs. PERSONNEL LEVELS 1- Sales Director 2- Sales Managers 1- Maintenance/Operations Supervisar 2- Maintenance Custodians 2- Crew Chiefs Plus part-time staff positions which include set-up crew, custodians, and maintenance. CAPITAL OUTLAY See Capital Projects Fund 56 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2009 2009 Actuai Actual Final YTD Recommended Approved Object Code DescripGOn AmouM AmouM Budget Adual Budget Budget 49852 EBHGCONVENTION CENTER 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 46D0 MISCELLANEOUS REVENUE 4606 OTHER REVENUE 232- 2,053- 196 4609 UNCOLLECTIBLE WRITE OFFS 5 4600 MISCELLANEOUS REVENUE 232- 3,124 196 4599 MISCELLANEOUS REVENUE 232- 3,124 �96'' 4800 EBHC 4820 CONVENTION CENTER 4821 ROOM RENTALS 536,820- 625,516- 660,000- 458,804 600,000- 600,000- 4821.1 CMP ROOM RENTALS 28,334- 35,080- 47,60a 52,492- 50,000- 50,000. 4821 ROOM RENTALS 565,154- 660,596- 707,60D- 511,296- 650,000- 650,000- 4822 LABOR CHARGES 15,625- 13,922- 12,000- 10,498- 10,500- 10,500. 4823 EQUIPMENT RENTALS 259,542- 277,749- 260,000- 211,576- 260 260,OOa 4823.1 CMP EQIIIPMENT RENTALS 9,92& 13,355- 22,600- 25,435- 22,600- 22,600- 4823 EQUIPMENT RENTALS 269,471- 291,104 282,600- 237,011- 282,600- 282,600- 4826 DANCE FLOOR RENTALS 26,275- 23,556- 29,800- 8,360- 22,400- 22,400- 4827 SECURITY SERVICES 3D,245- 27,035- 22,500- 16,700- 20,500- 20,500- 4828 CLIENT SERVICES 36,057- 39,027- 42,000- 25,156- 35,500- 35,500- 4629 MISCELLANEOUS 3,474 3,601- 3,500- 1,826 3,500- 3,500- 4620 CONVENTION CENTER 946,301- 1,058,842- 1,100,000- 810,846- 1,025,000- 1,025,000- 4800 EBHC 946,301- 1,058,842- 1,1D0,000- 810,84E 1,025,000- 1,025,000- 4900 OTHER FINANCING SOURCES 4921 REFUNDS REIMBURSEMENTS 17,763- 2,512- 4900 OTHER FINANCING SOURCES 17,783- 2,512- 5550 DIRECT COST OF SALES 5560 COST OF GOODS SOLD 4001 REVENUES 964,316 1,058,230- 1,100,000- 811,042- 1,025,000- 1,025,000- 6001 EXPENDITURES/EXPENSES 6099 PERSONALSERVICES 61A0 WAGES AND SALARIES 6101 WAGES SALARIES-FT EMPLOYEES 321,302 326,174 375,756 244,466 382,471 382,471 6102 OVERTIME-FT EMPLOYEES 799 1,078 950 913 6103 WAGES-PARTTIME EMPLOYEES 107,972 127,031 127,000 95,070 127,000 127,000 6104 OVERTIME-PART TIME EMPLOYEES 304 245 400 400 400 6100 WAGES AND SALARIES 430,376 454,528 504,106 340,449 509,87b 509,871 6110 OTHER PAYMENTS-NON INSURANCE 6111 SEVERANCE PAY 3,724 2,584 6110 OTHER PAYMENTS-NON INSURANCE 3,724 2,584 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 24,372 26,184 32,767 20,612 34,491 34,491 6125 FICA 26,605 28,556 31,002 21,825 31,679 31,679 6126 MEDICARE CONTRIBUTIONS 6,222 6,678 7,562 5,105 7,409 7,409 57 C1TY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2D09 2Q09 Actual Actual Final YTD Rewmmended Approved Object Code Description Amount Amourrt Budget AGual Budget Budget 6120 RETIREMENT CONTRIBUTIONS 57,199 61,419 71,331 47,542 73,579 73,579 6130 INSURANCE BENEFITS 6131 CAFETERIA PLAN CONTRIBUTIONS 60,448 62,672 72,800 46,655 81,696 81,696 6130 INSURANCE BENEFITS 60,448 62,672 72,800 46,655 81,696 81,696 6140 UNEMPLOYMENT COMPENSATION 6141 UNEMPLOYMENT COMPENSATION 6140 UNEMPLOYMENT COMPENSATION 70 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 13,992 13,784 8,671 12,508 17,634 17,634 6150 WORKER'S COMPENSATION 13,992 13,784 8,671 12,508 17,634 17,634 6099 PERSONAL SERVICES 565,739 594,986 656,908 447,223 682,780 682,780 6199 SUPPLIES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 1,909 2,586 2,000 638 2,000 2,000 6202 COPYING SUPPLIES 1,157 1,196 1,150 1,275 1,600 1,600 6203 BOOKSIREFERENCE MATERIALS 31 6200 OFFICE SUPPLIES 3,066 3,782 3,150 1,944 3,600 3,600 6210 OPERATWG SUPPLIES 6211 CLEANING SUPPLIES 4,894 7,294 6,300 3,666 6,300 6,300 6212 MOTOR FUELS 10 50 50 50 6214 CLOTHING PERSONAL EQUIPMENT 1,21D 431 1,200 856 1,200 1,200 8215 SHOP MATERIALS 739 379 750 54 500 500 6216 CHEMICALS/CHEMICAL PRODUCTS 4,207 3,831 4,600 3,146 5,400 5,400 6217 SAFETY SUPPLIES 672 2,156 700 414 700 700 6219 GENERAL OPERATING SUPPLIES 30,595 25,036 29,800 17,382 29,800 29,800 6210 OPERATING SUPPLIES 42,317 39,138 43,400 25,517 43,950 43,950 6220 REPAIR MAINT SUPPUES 6223 BUILDINGS 8 FACIUTIES 16,971 27,633 26,450 12,448 26,450 26,450 6225 PARK LANDSCAPE MATERIALS 3,218 1,596 3,500 1,559 3,500 3,500 6226 SIGNS 8� STRIPING MATERlAtS 296 76 600 600 6U0 6227 PAINT SUPPLIES 1,611 1,398 2,000 1,741 2,000 2,000 6220 REPAIR MAINT SUPPLIES 22,097 30,702 32,550 15,749 32,550 32,550 6230 REPAIR MAINT SUPPUES-OTHER 6237 LAUNDRY SUPPLIES 57 169 1�0 100 100 6239 OTHER REPAIR MAINT SUPPLIES 5,240 5,141 5,200 3,812 5,200 5,200 6230 REPAIR MAINT SUPPLIES-OTHER 5,297 5,310 5,300 3,812 5,300 5,300 6240 SMALL TOOLS MINOR EQUIPMENT 6241 SMALL TOOLS 981 970 950 746 1,D50 1,050 6242 MINOR EQUIPMENT 32,348 29,972 34,SD0 4,248 34,500 34,500 6243 MINOR COMPUTER EQUIPMENT 5,814 1,637 4,637 6240 5MALL TOOLS MINOR EQUIPMENT 39,144 32,579 35,450 9,631 35,550 35,550 6199 SUPPLIES 111,921 111,510 119,850 56,652 120,950 120,950 6299 OTHER CHARGES SERVICES 6300 PROFESSIONAL SERVICES 6303 'LEGAL SERVICES 2,741 70 58 CITY OF BROOKLYN CENTER BudgetReport 2006 2007 2008 9I30/20D8 2009 20D9 Actual Adual Final YTD Recommended Approved Object Code Description Amount Amourrt Budget Actual Budget Budget 6307 PROFESSIONAL SERVICES 14,481 6,458 43,000 8,051 18,000 18,000 6300 PROFESSIONAL SERVICES 17,222 6,528 43,000 8,051 18,000 18,000 6320 COMMUNICATIONS 6321 TELEPHONElPAGERS 6,617 6,087 6,840 4,150 6,840 6,840 6322 POSTAGE 2,619 2,698 3,400 1,752 3,000 3,000 6320 COMMUNICATIONS 9,236 8,785 10,240 5,902 9,&40 9,840 633D TRANSPORTATION 6331 TRAVEL EXPENSE/MILEAGE 1,025 1,109 675 720 925 925 6333 FREIGHTIDRAYAGE 103 65 175 177 350 350 6330 TRANSPORTATION 1,126 1,174 1,050 897 1,275 1,275 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 1,567 3,381 2,300 1,059 2,300 2,300 6349 OTHER ADVERTISING 46,843 60,954 45,000 31,375 40,000 40,000 6340 ADVERTISING 48,410 64,335 47,300 32,434 42,300 42,300 6350 PRINTING AND DUPLICATING 6351 PRINTING 6,369 9,398 6,500 3,828 6,500 6,500 6350 PRINTING AND DUPLICATING 6,369 9,398 6,500 3,828 6,500 6,500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 6,OOD 6,957 7,062 3,674 6,075 6,075 6362 PROPERTY INSURANCE 6,082 8,021 7,146 6,047 9,975 9,975 6366 MACHINERY BREAKDOWN INSURANCE 465 559 549 432 720 720 6360 INSURANCE 12,547 15,537 14,757 10,153 16,770 16,770 6380 UTILITY SERVICES 6381 ELECTRIC 104,104 111,486 110,000 79,182 115,UOU 115,000 6382 GAS 29,127 26,255 30,000 25,240 50,000 50,000 6383 WATER 853 703 1,200 319 1,200 1,200 6384 REFUSE DISPOSAL 3,135 1,901 2,000 1,310 2,000 2,000 6385 SEWER 1,898 1,216 2,000 576 2,000 2,000 6386 STORM SEWER 1,359 1,380 1,800 959 1,800 1,800 6389 STREET LIGHTS 251 248 300 171 300 300 6380 UTILITY SERVICES 140,727 143,189 147,300 107,757 172,30D 172,300 6400 REPAIR MAINT SERViCES 6402 EQUIPMENT SERVICES 52,704 36,263 35,700 26,160 35,700 35,700 6403 BLDGSlFACILITIES MAINT SERVICE 2,820 10,471 3,000 1,871 3,000 3,000 6408 COMMUNICATION/INFO SYSTEMS 58 6409 OTHER REPAIR MAINT SVCS 500 BOU 116 SDO 500 6400 REPAIR MAINT SERVICES 55,524 47,292 39,500 28,148 39,200 39,200 6410 RENTALS 6413 OFFICE EQUIPMENT 5,330 3,722 4,000 2,200 3,500 3,500 6415 OTHER EQUIPMENT 138,560 139,856 132,900 108,465 139,000 139,OD0 6410 RENTALS 143,890 143,578 136,900 110,665 142,SOD 142,500 6420 IS SERVICES/LICENSES/FEES 6423 LOGIS CHARGES 1,928 816 6428 PROTECTION SERVICES 19,427 19,896 18,800 8,656 15,000 15,000 6420 IS SERVICES/LICENSES/FEES 21,356 20,714 18,800 8,656 15,000 15,000 6430 MISCELLANEOUS 59 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2009 2009 Adual Adual Final YTD Recommended Approved Objed Code Description Amount Amourrt Budget Actual Budget Budget 6432 CONFERENCES AND SCHOOLS 4,515 4,560 8,500 3,942 8,500 8,500 6433 MEETING EXPENSES 293 677 450 778 500 500 6434 DUES SUBSCRIPTIONS 3,084 4,376 3,800 3,286 3,800 3,800 6435 CREDIT CARD FEES 2,575 3,024 1,772 2,600 2,600 6436 UNCOLLECTIBLE CHECKSlDESTS 114 2,412- 6438 CASH SHORT (OVER) 22' 6430 MISCELLANEOUS 10,33'I 10,226 12,750 9,778 15,400 15,400 6440 OTHER EXPENSES 6441 LICENSES, TAXES FEES 29� 235 195 6442 COURT AWARDS/SETTLEMENTS 2,96D 1,247 6449 OTHER CONTRACTUAL SERVICE 13,180 14,314 13,500 10,278 14,000 14,000 6440 OTHER EXPENSES 16,437 15,795 13,500 10,473 14,000 14,000 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 266,996 264,104 265,000 198,259 265,D00 265,000 6490 OTHER MISC COSTS/EXPENSES 266,996 264,104 265,000 198,259 265,000 265,000 6299 OTHER CHARGES SERVICES 750,173 750,655 756,597 535,002 758,085 758,085 6500 CAPITAL OUTLAY 6600 DEBT SERVICE �6D01 EXPENDITURESIEXPENSES 1,427,832 1,457,152 1,533,355 1,038,876 1,561,815 1,561,815 4000 REVENUES AND EXPENSES 463,517 398,921 433,355 227,634 536,815 536,815 49852 EBHGCONVENTION CENTER 463,517 398,921 433,355 227,834 536,815 536,815 60 S �'it�y of BrookCyn Center 2009 Budget FUND: Earle Brown Heritage Center 61700 DEPT/ACTIVITY/PROJECT: Catering 49853 PROFILE 'The Catering Division of the Heritage Center prepares, and services all food and beverage-related activity. A management contract exists with Flik International, Rye Brook, New York, to oversee this division at the direction of the Heritage Center General Manager. Flik creates menus, determines food pricing, hires staff, and provides food and beverage to facility clients. Contractually, Flik Internationa.l maintains an inventory of food and small wares, maintains the kitchen and service areas, and services all food-related functions. DEPARTMENTAL GOALS Provide a high level of qua.lity product to facility clients. Continue to create menu solutions that meet client needs. Maintain competitive purchase pricing. Develop new menu items and increase pricing competitive with the marketplace. Maintain a clean and safe work environment. EXPENDITURE DETAILS Object codes 5591, 5592, 5593 and 5595 are Flik costs for catering. A base contracted management fee of $100,000 is paid to Flik International. All other object codes used reflect catering related expenses paid by the Earle Brown Heritage Center. 6252 Minor Equipment $27,000 Purchase of china, glass, silver plus purchase of a stack oven 6243 Minor Computer Equipment $1,500 Replacement of one catering sales computer with Notebook Computer. PERSONNEL LEVELS All food preparation and food service management staff are provided for under an agreement with Flik. Wages, benefits and other employee costs in this division are City employees that provide direct services to the Catering operation. CAPITAL OUTLAY See Capital Projects Fund 61 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2009 2009 Adual Actual Final YTD Recommended Approved Object Code Description Amount Amourrt Budget Acluai Bud9et Budget 49853 EBHGCATERING OPERATIONS A000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4606 OTHER REVENUE 441- 4609 UNCOLLECTIBLE WRITE OFFS 8,586 4600 MISCELLANEOUS REVENUE 441- 8,586 4599 MISCELLANEOUS REVENUE 441- 8,586 4800 EBHC 4840 CATERING SERVICES 4842 SERVICE CHARGES 479,418- 476,529- 514,200. 298,857- 514,200- 514,200- 4844 FOOO 8 BEVERAGE SALES 2,290,647- 2,299,967- 2,276,500. 1,485,023- 2,2D3,350. 2,203,350- 4844.1 FOOD BEVER,4GE SAIES, INN 10,655- 13,433- 166- 4845 LIQUORIWINElBEER SALES 371,416- 336,324- 375,OOa 198,009- 375,000- 375,000- 4845.1 LIQUOR/1MNEIBEER SALES, INN 452- 370- 4848 MISCELLANEOUS SALES 37,635- 39,58& 16,500- 34,302- 11,650. 11,650- 4849 M�SCELLANEOUS SALES-NON TAXABL 1,114 982- 840- 484D CATERING SERVICES 3,191,33& 3,167,214 3,182,200- 2,017,198- 3,104,200- 3,104,200- 4800 EBHC 3,197,338- 3,167,214 3,182,200- 2,017,198- 3,104,200. 3,104,200- 4900 OTHER FINANCING SOURCES 4912 CAPITAL CONTRIBUTIONS 40,903- 4921 REFUNDS 8 REIMBURSEMENTS 11,197- 147- 4900 OTHER FINANCING SOURCES 52,100- 147- 5550 DIRECT COST OF SALES 5586 COST OF SALES-MISC 35 5590 EBHC CONTRACT EXPENSES 5591 COST OF SALES-LABOR 1,273,968 1,339,691 1,333,954 755,298 1,296,185 1,296,185 5592 COST OF SALES-FOOD 565,565 553,048 561,975 290,649 522,600 522,600 5593 COST OF SALES-SUPPLIES 149,419 154,336 168,625 94,502 147,702 147,702 5594 COST OF SALES-MGMT FEES 140,000 115,000 1D0,000 68,400 105,000 105,000 5590 EBHC CONTRACT EXPENSES 2,126,951 2,162,075 2,164,584 1,2D8,848 2,071,487 2,071,487 5550 DIRECT COST OF SALES 2,128,951 2,162,075 2,184,584 1,208,884 2,071,487 2,071,487 4001 REVENUES 1,114,927- 996,700- 997,616- 808,314 1,032,713- 1,032,713- 6D01 EXPENDITURES/EXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES 8 SALARIES-FT EMPLOYEES 23,171 22,813 14,598 6102 OVERTIME-FT EMPLOYEES 238 202 6103 WAGES-PARTTIME EMPLOYEES 45,421 45,490 60,D00 30,128 50,000 50,000 6100 WAGES AND SALARIES 68,830 68,505 60,000 44,727 50,000 50,000 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PIAN 2,883 2,844 3,900 2,031 3,375 3,375 6125 FICA 4,242 4,249 3,690 2,770 3,100 3,100 6126 MEDICARE CONTRIBUTIONS 992 994 900 648 725 725 6120 RETIREMENT CONTRIBUTIONS 8,117 8,087 8,490 5,448 7,200 7,200 6130 INSURANCE BENEFITS 62 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2009 2D09 AGual Adual Final YTD Recommended Approved Object Code Description Amounl AmouM Budget Adual Budget Budget 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 3,055 2,796 960 2,137 2,360 2,360 6150 WORKER'S COMPENSATION 3,055 2,796 960 2,137 2,360 2,360 6099 PERSONAL SERVICES 80,002 79,388 69,450 52,312 59,560 59,560 6199 SUPPUES 6200 OFFICE SUPPLIES 6201 OFFICE SUPPLIES 1,406 1,275 1,400 750 1,400 1,400 6202 COPYING SUPPLIES 683 1,014 900 680 900 900 620D OFFICE SUPPLIES 2,088 2,289 2,300 1,430 2,300 2,300 6210 OPERATING SUPPLIES 6211 CLEANING SUPPLIES 170 150 150 150 6215 SHOP MATERIALS 39 50 50 50 6216 CHEMICALS/CHEMICAL PRODUCTS 156 300 300 300 6217 SAFETY SUPPLIES 315 255 180 543 650 650 6219 GENERAL OPERATING SUPPLIES 207 14 150 383 300 300 62'10 OPERATING SUPPLIES 561 597 830 926 1,450 1,450 6220 REPAIR 8� MAINT SUPPLIES 6223 BUILDINGS FACILITIES 2,019 1,383 2,600 584 2,000 2,000 622� PAINT SUPPLIES 11 100 100 100 6220 REPAIR MAINT SUPPLIES 2,019 1,394 2,7D0 584 2,100 2,100 6230 REPAIR MAINT SUPPLIES-OTHER 6239 OTHER REPAIR 8 MAINT SUPPLIES 833 723 1,400 825 1,500 1,500 6230 REPAIR 8 MAINT SUPPUES-OTHER 833 723 1,400 825 1,500 1,500 6240 SMALL TOOLS 8 MINOR EQUIPMENT 6242 MINOR EQUIPMENT 18,593 11,807 32,000 13,641 27,000 27,000 6243 MINOR COMPUTER EQUIPMENT 979 3,369 1,500 1,500 6240 SMALL TOOLS 8� MINOR EQUIPMENT 19,571 15,176 32,000 13,641 28,500 28,500 6199 SUPPLIES 25,073 20,178 39,230 17,406 35,850 35,850 6299 OTHER CHARGES 8 SERVICES 6300 PROFESSIONAL SERVICES 6307 PROFESSIONAL SERVICES 50 1,065 6319 OTHER PROFESSIONAL SERVICES 6 6300 PROFESSIONAL SERVICES SD 1,071 6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 1,248 1,312 1,420 777 1,420 1,420 6322 POSTAGE 341 373 400 199 400 400 6320 COMMUNICATIONS 1,569 1,685 1,820 975 1,820 1,820 6330 TRANSPORTATION 6331 TRAVEL EXPENSElMILEAGE 18 6333 FREIGHT/DRAYAGE 20 21 30 75 100 100 6330 TRANSPORTATION 20 39 30 75 100 100 6340 ADVERTfSING 6349 OTHER ADVERTISING 23,478 22,255 25,000 28,148 22,000 22,000 6340 ADVERTISING 23,478 22,255 25,000 28,148 22,000 22,000 63 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9I30/2008 2009 2D09 Actual Adual Finai YTD R�.......�,.ended Approved Object Code Description Amount AmouM Budget Aaual Budget Budget 6350 PRINTING AND DUPLICATING 6351 PRINTING 465 463 1,200 3,742 2,500 2,500 6354 PRfNTWG AND Dl1PLICATING 465 463 1,200 3,7d2 2,500 2,500 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 5,116 5,538 5,606 4,183 6,900 6,900 6362 PROPERTY INSURANCE 6,D62 8,456 7,090 7,522 12,400 12,400 6364 DRAM SHOP INSURANCE 6366 MACHINERY BREAKDOWN INSURANCE 465 607 542 890 890 6360 INSURANCE 11,665 14,601 13,241 12,246 20,190 20,190 6380 UTILITY SERVICES 6381 ELECTRIC 18,371 19,674 25,OD0 13,973 25,000 25,000 6382 GAS 29,127 26,255 35,000 25,240 50,500 SU,500 6383 WATER 1,056 667 1,500 178 550 550 6384 REFUSE DISPOSAL 7,427 7,962 7,500 4,660 7,500 7.500 6385 SEWER 1,898 1,566 2,000 226 350 350 6366 STORM SEWER 1,344 1,596 1,800 759 1,100 1,100 6389 STREET LIGHTS 255 267 370 135 250 25D 6380 UTILITY SERVICES 59,477 58,207 73,170 45,172 85,250 85,250 6400 REPAIR MAINT SERVICES 6402 EQUIPMENT SERVICES 10,195 15,979 12,000 13,474 19,500 19,500 6403 BLDGS/FACILITIES MAWT SERVICE 1,980 2,006 2.500 2,296 4,000 4,000 6409 OTHER REPAIR MAINT SVCS 1,308 1,199 1,400 872 1,400 1,400 64D0 REPAIR MAINT SERVICES 13,483 19,184 15,900 16,642 24,900 24,900 6410 RENTALS 6413 OFFICE EQUIPMENT 4,432 2,868 4,500 1,298 1,800 1.800 6415 OTHER EQUIPMENT 543 1,000 1,000 6410 RENTALS 4,432 2,868 4,500 1,841 2,800 2,800 6430 MISCELL'ANEOUS 6432 CONFERENCES AND SCHOOLS 1,442 1,235 1,500 559 1,500 1,500 6d34 DUES 8 SUSSCR1PT10NS 2 6435 CREDIT CARD FEES 20,262 13,254 21,500 10,180 17,050 17,050 6436 UNCOLLECTIBLE CHECKSIDEBTS 1,806- 10,029- 6438 CASH SHORT (OVER) 218- 280 47 6430 MISCELLANEOUS 19,680 4,760 23,000 10,692 18,550 18,550 6440 OTHER EXPENSES 6441 UCENSES, TAXES FEES 3,942 50 35 6449 OTHER CONTRACTUAL SERVICE 6,066 6,728 6,30D 4,524 6,70D 6,700 6440 OTHER EXPENSES 10,028 6,778 6,300 4,559 6,700 6,700 6490 OTHER MI5C COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 156,307 158,334 158,000 118,859 160,000 160,000 6490 OTHER MISC COSTSfEXPENSES 156,307 158,334 158,000 118,859 160,000 160,000 6299 OTHER CHARGES SERVICES 300,676 290,244 322,161 242,951 344,810 344,810 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6001 EXPENDITURES/EXPENSES 405,751 389,610 430,841 312,670 440,220 440,220 64 i CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9I3012008 2009 2009 Adual Adual Final YTD Recommended Approved Object Code Description Amount Amourrt Budget AGual Budget Budget 4000 REVENUES AND EXPENSES 709,176- 606,889- 566,775- 495,644 592,493- 592,493- I 49853 EBHGCATERING OPERATIONS 709,176 606,889- 566,775- 495,644- 592,493 592,493- i 65 �ity of Brool��yn Center 2009 Budget FUND: Earle Brown Heritage Center 61700 ROJECT: Office Rental 49854 DEPT/ACTIVITY/P PROFILE The D Barn (commercial office building) will have a new tenant as Oliver and Company, the Embassy Suites hotel owner, converts the building into a Salon and Spa to compliment the hotel and convention center guests. Innovative Presentations has moved into a portion of the Inn following that conversion from bed and breakfast to meeting and commercial office space. DEPARTMENTAL GOALS Provide maintenance to building. Respond to tenant concerns in a timely manner. EXPENDITURE DETAILS, 6223 Repair and Maintenance Supplies-Buildings and �acilities $1,000 Provides for repair and maintenance supplies for maintenance of the office axeas within the EBHC and includes filter, cleaning equipment pars, etc. PERSONNEL LEVELS Maintenance and custodial care provided by facility staff under the direction of the Maintenance Supervisor. CAPITAL OUTLAY See Capital Projects Fund 66 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9I3012008 2009 2009 Actual Adual Finai YTD Recommended Approved Object Code Description Amount Amourrt Budget Actual Budget Budg'et 49854 EBHC-OFFICE RENTAL 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4800 EBHC 4830 OFFICE RENTAL 4831 OFFICE RENTALS 66,254 68,390- 62,691- 47,494 81,030. 81,030- 4830 OFFICE RENTAL 66,254- 68,390- 62,691- 47,494 81.030- 81,030- 4800 EBHC 66,254 68,390. 62,691- 47,494 81,030- 81,030- 49D0 OTHER FINANCING SOURCES 4921 REFUNDS REIMBURSEMENTS 16- 4900 OTHER FINANCING SOURCES �6- 4001 REVENUES 66,254- 68,407- 62,691- 47,494- 81,030-. 81,030- I �I 6001 EXPENDITURESlEXPENSES 6099 PERSONALSERVICES 6100 WAGES AND SALARIES 6101 WAGES SALARIES-FT EMPLOYEES 2,719 1,991 1,685 6102 OVERTIME-FT EMPLOYEES 83 6103 WAGE&PART TIME EMPLOYEES 4,417 2,509 3,000 2,847 5,000 5,000 6100 WAGES AND SALARIES 7,219 4,500 3,000 4,532 5,000 5,000 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 433 281 195 295 338 338 6125 FICA 428 273 185 282 310 310 6126 MEDICARE CONTRIBUTIONS 100 64 45 66 73 73 6120 RETIREMENT CONTRIBUTIONS 961 618 425 643 721 721 6130 INSURANCE BENEFITS 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP �NSURANCE 343 196 48 224 236 236 6150 WORKER'S COMPENSATION 343 196 46 224 236 236 6099 PERSONAL SERVICES 8,524 5,314 3,473 5,399 5,957 5,957 6199 SUPPLIES 6210 OPERATWG SUPPUES 6219 GENERAL OPERATING SUPPLIES 64 147 6210 OPERATING SUPPLIES 64 147 6220 REPAIR 8 MAINT SUPPLIES 6223 BUILDINGS FACILITIES 325 335 1,000 1,D09 1,000 1,000 6225 PARK LANDSCAPE MATERIALS 50 300 300 6226 SIGNS 8 STRIPING MATERIALS 50 300 300 6227 PAINT SUPPLIES 1,102 100 14 100 100 6220 REPAIR MAINT SUPPLIES 1,427 335 1,200 1,023 1,700 1,700 6230 REPAIR MAINT SUPPLIES-OTHER 6240 SMALL TOOLS 8� MINOR EQUIPMENT 67 CfTY OP BROOKLYN CENTER Budget Report 2006 2007 2008 9l30/2008 2D09 2009 Aduai Actual Final YTD Recommended Approved Objed Code Description AmouM Amourrt Budget Adual Budget Budget 6199 SUPPLIES 1,427 399 1,200 1,170 1,700 1,700 6289 OTHER CHARGE5 SERVICES 6300 PROFESSIONAL SERVICES 6320 COMMUNICATIONS 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 511 461 343 318 525 525 6362 PROPERTY INSURANCE 3,233 1,876 2,016 737 1,250 1,25D 6366 MACHINERY BREAKDOWN INSURANCE 247 131 155 51 85 85 6360 INSURANCE 3,992 2,469 2,514 1,106 1,660 1,860 6380 UTIUTY SERVICES 6381 ELECTR�C 3,300 3,300 6382 GAS 2,091 1,920 3,300 1,901 5,000 5,000 6383 WATER 93 141 200 78 200 200 6384 REFUSE DISPOSAL 9A8 790 1,D00 860 1,000 1,000 6385 SEWER 192 260 400 155 200 200 6380 UTILITY SERVICES 3,324 3,112 4,90D 2,994 9,700 9,700 6400 REPAIR MAtNT SERVICES 6402 EQUIPMENT SERVICES 4,083 853 1,500 204 1,500 1,500 6403 BLDGS/FACILITIES MAINT SERVICE 360 360 500 120 500 500 6400 REPAIR MAINT SERVICES 4,443 1,213 2,000 324 2,000 2,000 6410 RENTALS 6420 IS SERVICES/LICENSES/FEES 6440 OTHER EXPENSES 6441 LICENSES, TAXES FEES 6,859 6,541 6,983 4,694 6,800 6,800 6449 OTHER CONTRACTUAL SERVICE 4,283 4,7'18 4,300 3,193 6,500 6,500 6440 OTHER EXPENSES 11,142 11,260 11,283 7,887 13,300 13,3D0 6490 OTHER MISC COSTS/EXPENSES 6494 DEPRECIATION EXPENSE 35,775 35,775 35,700 26,856 36,800 36,800 649D OTHER MISC COSTS/EXPENSES 35,775 35,775 35,700 26,856 36,800 36,800 6299 OTHER CHARGES SERVICES 58,675 53,828 56,397 39,167 63,660 63,660 6001 EXPENDITURES/EXPENSES 68,625 59,540 61,070 45,736 71,317 71,317 4000 REVENUES AND EXPENSES 2,371 8,866- 1,621- 1,75& 9,713- 9,713- 49854 EBHC-OFFICE RENTAL 2,371 8,666- 1,621- 1,758- 9,713- 9,713- 68 City of �roo� Center. 2009 Budget FUND: Earle Brown Heritage Center 61700 DEPT/ACTIVITY/PROJECT: Inn on the Farna 49855 PROFILE Formerly a bed and breakfast, the Inn has been converted into meeting space and commercial office space. All revenue and expenses will be divided into convention center and commercial office categories. This Inn on the Farm business unit ceased to exist at the end of 2008. 69 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9/30/2008 2D09 2009 Adual Adual Fina� YTD Recommended Approved Objed Code Description Amount Amourrt Budget Actual Budget Budget 49855 EBHGINN ON THE FARM 4000 REVENUES AND EXPENSES 4001 REVENUES 4599 MISCELLANEOUS REVENUE 4600 MISCELLANEOUS REVENUE 4800 EBHC 4810 INN ON THE FARM 4811 GUEST ROOM RENTALS 46,950- 35,210- 33,000- 8,470- 4812 FACILITY RENTALS 6,SSa 7,610- 7,400- 17S 4814 EQUIPAAENT RENTALS 2,575- 1,782- 2,000- 30- 4815 MISCELLANEOUS 20a 12- 200- 4810 (NN ON THE FARM 56,275- 44,614 42,60a 8,675- 48D0 EBHC 56,275- 44,614 42,600- 8,675 4900 OTHER FINANCING SOURCES 4921 REFUNDS 8� REIMBURSEMENTS 7,509- 28- 1,47& 4900 OTHER FINANCING SOURCES 7,50& 2& 1,473- 5550 DIRECT COST OF SALES 5580 COST OF GOODS SOLD •4001 REVENUES 63,784- 44,641- 42,600- 10,15M 6001 EXPENDITURESlEXPENSES 6099 PERSONAL SERVICES 6100 WAGES AND SALARIES 6101 WAGES SALARIES-FT EMPLOYEES 4,537 4,227 6,299 6102 OVERTIME-FT EMPLOYEES 56 93 200 6103 WAGES-PART TIME EMPLOYEES 21,657 17,402 18,000 6,923 6100 WAGES AND SALARIES 26,249 21,723 18,000 13,422 6120 RETIREMENT CONTRIBUTIONS 6122 PERA COORDINATED PLAN 1,423 1,102 1,170 842 6125 FICA 1,537 1,358 1,107 828 6126 MEDICARE CONTRIBUTIONS 359 318 270 193 6120 RETIREMENT CONTRIBUTIONS 3,319 2,778 2,547 1,864 6130 INSURANCE BENEFITS 6140 UNEMPLOYMENT COMPENSATION 6150 WORKER'S COMPENSATION 6151 WORKER'S COMP INSURANCE 574 500 288 541 6150 WORKER'S COMPENSATION 574 500 288 541 6099 PERSONAL SERVICES 30,142 25,000 20,835 15,827 6199 SUPPLIES 6200 OFFICE SUPPLIES 6 1 PERATIN PPUES 2 0 O GSU 6211 CLEANING SUPPLIES 207 65 250 4 6215 SHOP MATERIALS 12 6216 CHEMICALS/CHEMICAL PRODUCTS 200 7� CITY OF BROOKLYN CENTER Budget Report 2006 2007 20D8 9/30/20D8 2009 2009 Actual Actual Final YTD Recommended Approved Objed Code Description Amount Amount 8udget Adual Budget Budget 6219 GENERAL OPERATING SUPPUES 4,056 3,186 2,OD0 533 6210 OPERATING SUPPUES 4,276 3,251 2,450 538 6220 REPAIR MAINT SUPPLIES 6223 BUILDINGS FACILITIES 2,627 4,315 4,800 3,032 6225 PARK LANDSCAPE MATERIALS 184 697 250 6226 SIGNS STRIPING MATERIALS 35 150 6227 PAINT SUPPLIES 145 192 400 6220 REPAIR 8 MAINT SUPPLIES 2,990 5,205 5,600 3,032 6230 REPAIR MAINT SUPPLIES-OTHER 6237 IAUNDRY SUPPLIES 124 97 75 28 6239 OTHER REPAIR MAINT SUPPLIES 110 78 150 6230 REPAIR MAINT SUPPLIES-OTHER 234 175 225 28 6240 SMALL TOOLS 8 MINOR EQUIPMENT 6242 MINOR EQUIPMENT 597 772 6240 SMALL TOOLS MINOR EQUIPMENT 597 n 6199 SUPPLIES 8,097 6,631 8,275 4,370 6299 OTHER CHARGES SERVICES 6300 PROFESSIONAL SERVICES .6320 COMMUNICATIONS 6321 TELEPHONE/PAGERS 1,200 1,200 1,260 700 6320 COMMUNICATIONS 1,200 1,200 1,260 700 6340 ADVERTISING 6341 PERSONNEL ADVERTISING 979 215 300 6340 ADVERTISING 979 215 300 6350 PRINTWG AND DUPLICATING 6351 PRINTWG 81 110 6350 PRINTING AND DUPUCATING $1 6360 INSURANCE 6361 GENERAL LIABILITY INSURANCE 888 951 547 669 6362 PROPERTY INSURANCE 5,129 2,990 3,421 1,387 6366 MACHINERY BREAKDOWN INSURANCE 391 223 2'S4 102 636D INSURANCE 6,408 4,165 4,222 2,157 6380 UTILITY SERVICES 6361 ELECTRIC 8,35� 7,189 9,500 5,456 6382 GAS 8,618 8,024 10,500 7,968 6383 WATER 222 260 300 122 6384 REFUSE DISPOSAL 330 159 200 116 6385 SEWER 294 290 350 121 6380 UTILITY SERVICES 17,814 15,922 20,850 13,783 6400 REPAIR MAINT SERVICES 6402 EQUIPMENT SERVICES 6,750 3,340 2,800 7,822 6403 BLOGS/FACILITIES MAINT SERVICE 480 480 500 160 6409 OTHER REPAIR MAINT SVCS 154 150 6400 REPAIR MAINT SERVtCES 7,384 3,820 3,450 7,982 71 CITY OF BROOKLYN CENTER Budget Report 2006 2007 2008 9130l2008 2D09 2D09 Actual Adual Final YTD Recommended Approved Object Code Description Amount Amount Budget AGual Budget Budget 6410 RENTALS 6415 OTHER EQUIPMENT 100 6410 RENTALS 100 6420 IS SERVICES/LICENSES/FEES 6428 PROTECTION SERVICES 1,085 3,168 2,300 941 6420 IS SERVICESILICENSESlFEES 1,085 3,168 2,300 941 6430 MISCELLANEOUS 6435 CREDIT CARD FEES 900 41 S 639 86 6436 UNCOLLECTIBLE CHECKS/DEBTS 20 25- 6430 MISCELLANEOUS 920 393 639 86 6440 OTHER EXPENSES 6441 LICENSES, TAXES FEES 13,082 12,574 12,967 8,996 6449 OTHER CONTRACTUAL SERVICE 2,736 2,944 2,750 2,187 6440 OTHER EXPENSES 15,818 15,518 15,717 11,183 6490 OTHER MISC COSTSlEXPENSES 6494 DEPRECIATION EXPENSE 88,515 88,515 88,500 66,4d7 6490 OTHER MISC COSTS/EXPENSES 88,515 88,515 88,500 66,447 .6299 OTHER CHARGES SERVICES 140,206 133,027 137,338 103,279 6500 CAPITAL OUTLAY 6501 CAPITAL OUTLAY 6001 EXPENDITURESIEXPENSES 178,445 166,658 166,448 123,476 4000 REVENUES AND EXPENSES 114,661 122,016 123,848 113,322 49855 EBHC-INN ON THE FARM 114,661 122,016 123,848 113,322 61700 EARLE BROWN HERITAGE CENTER 478,184 439,550 508,671 68,258 471,034 471,034 �2 City of Brooklyn Center Earle Brown Heritage Center Cash Flows Actual Actual Estimated Proposed Projected Projected Projected Projected 2006 2007 2008 2009 2010 2011 2012 2013 Revenues Customer Receipts 4,203,921 4,219,457 4,247,491 4,182,230 4,289,966 4,332,866 4,376,194 4,419,956 Misc. Opera ting 3 7, 6 4 4 4, 8 1 2 4, 3 8 5 9,800 9,800 9,800 9,800 9,800 Misc. Non-operating 46,479 5 4, 3 3 1 3 0, 9 2 1 28,000 29,713 30,440 30,082 2 8, 5 6 1 Total Revenues 4,288,044 4,278,600 4,282,797 4,220,030 4,329,479 4,373,105 4,416,076 4,458,317 Expenditures Personal Services 879,033 909,140 940,712 964,507 1,003,087 1,043,211 1,084,939 1,128,337 Supplies 156,069 142,428 159,855 161,500 166,345 171,335 176,475 181,770 Services 802,323 802,619 785,321 819,135 839,613 860,604 882,119 904,172 Cost of Good Sold 2,128,951 2,162,075 2,162,822 2,071,487 2,091,358 2,112,272 2,133,395 2,154,729 Depreciation 578,401 577,535 578,062 26,500 26,500 26,500 26,500 26,500 i Debt Transfer W Total Expenditures 4,544,777 4,593,797 4,626,772 4,043,129 4,126,904 4,213,922 4,303,428 4,395,507 Capital Transfer 300,000 230,000 200,000 200,000 200,000 200,000 200,000 200,000 1 Total Cash Requirement 4,844,777 4,823,797 4,826,772 4,243,129 4,326,904 4,413,922 4,503,428 4,595,507 Beginning Cash Balance 1,061,898 1,141,255 1,151,030 1,185,117 1,188,518 1,217,592 1,203,276 1,142,424 Changes in Assets/Liabiiities 57,689 (22,563) Revenues 4,288,044 4,278,600 4,282,797 4,220,030 4,329,479 4,373,105 4,416,076 4,458,317 Ex enditures (4,844,777) (4,823,797) (4,826,772) (4,243,129) (4,326,904) (4,413,922) (4,503,428) $(4,595,507) p 26 5 0 0 2 6, 5 0 0 26 500 500 26 500 Depreciation Add-Back 578,401 577,535 578,062 26, Ending Cash Balance 1,141,255 1,151,030 1,185,117 1,188,518 1,217,592 1,203,276 1,142,424 1,031,734 Assumptions: Cash basis All assumptions are predicted on Cash Basis presentation. Water Rate per 1,000 Gallons sz.ao S2.zo $2.00 I Ss.so $1.60 $1.40 $1.20 $1.00 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 0% 3% 6.25 �I Water Fund Cash Changes SZ,000,000 Ssoo,000 $600,000 $400,000 $200,000 T-- $(200,000) �I $(400,000) $(600,000) 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Monthly Residential Sanitary Sewer Rates $31.00 $29.00 $27.00 $25.00 $23.00 $21.00 $19.00 $17.00 $15.00 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 3% 0% 1% Sewer Fund Cash Changes Saoo,000 S600,o00 $400,000 $200,000 11� $(200,000) $(400,000) $(600,000) $(800,000) 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Storm Water Charges per residential lot per quarter 19 18 17 16 15 14 13 12 11 10 2006 2007 2008 2009 2010 20 11 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2008 Plan 2009 Plan Storm Water Fund Cash Changes Ss,soo,000 $1,000,000 $500,000 s r- $(500,000) i $(1,000,000) 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023