HomeMy WebLinkAbout2000 10-16 CCP Work Session r.
AGENDA
CITY COUNCIL WORK SESSION
October 16, 2000
6:00 P.M.
CONFERENCE ROOM B
1. Preliminary Discussion of Utility Rate Study
2. Golf Course 2001 Draft Budget
3. Earle Brown Heritage Center Preliminary 2001 Budget
4. Liquor Stores Draft 2001 Budget
5. Miscellaneous
6. Adjourn
City of Brooklyn Center
A great place to start. A great place to stay.
To: Mayor Kragness and Council Members Hilstrom, Lasman, Nelson and Peppe
From: Michael I McCauley
City Manager
Date: October 12, 2000
Re: Draft Public Utility Rate Study
This item is on the agenda for a preliminary discussion. The scheduled discussion of the utility rates
is set for the November 20th Work Session. Greater than expected costs of utility replacements in
the neighborhood street projects has impacted the projected fiind balances and the need for additional
revenues to continue the neighborhood street projects. The Financial Commission has been asked
to re- examine the cash balance targets for the water fund. As indicated in the draft materials, the
water fund will not approach the current targets.
ry
i
6301 Shingle Creek Pkwy, Brooklyn Center, MN 55430 -2199 • City Hall & TDD Number (612) 569 -3300
Recreation and Community Center Phone & TDD Number (612) 569 -3400 • FAX (612) 569 -3494
An Affirmative Action /Equal Opportunities Employer
_ y W
3 C-'
BROOKLYN
CFIVTER Public Works Department
MEMORANDUM
TO:. Michael J. McCauley, City Manager
Streets
ITO FROM: Diane Spector, Director of Public Wor
Parka SUBJ: Draft Public Utility Rate Study
Public DATE: October 11, 2000
Utilities
Central
Garage Attached is a draft of the 2001 Public Utilities Rate Study. The proposed rates are those
which would be necessary to:
Watershed • Meet operating costs;
Management • Complete programmed utility construction projects; and
• Maintain or move toward the target minimum cash balance target.
: ry
It is proposed to raise the water, sanitary, and storm drainage rates; the recycling rate will not change for
2001. Overall, the average annual utility bill for a family would increase 4.6 percent, or about $4.35 per
quarter. For an average senior customer, the rate would increase 4.3 percent, or about $2.12 per quarter.
These increases compare to the current 3.4 percent rate of inflation. The Social Security COLA for 2001 will
be announced October 18; it is expected to be about 3.3 percent. While the proposed increase is greater than
the inflation rate, it should be pointed out that in previous years the rate increases were at or less than
inflation. For example, last year's increase was 1.8 percent, or 1.1 percent for seniors.
Short Term Outlook
Even with these higher than inflation rate increases, for the next few years at least the cash balances fall
below the minimum cash balance targets. In the latter part of the five year period studied, the cash balances
do increase. This is because the Neighborhood Street and Utiity Improvement Program continues to target
neighborhoods with the worst combination of problems, usually meaning that there are substantial water,
sanitary, and storm drainage improvements to be made. In the latter part of the five year period, the size of
projects is reduced and thus the expected capital outlay is reduced.
Long Term Outlook
In the storm drainage utility, the bonds which were sold to finance the Bob Cahlander Regional Pond and
Park will in 2005 be retired, ending debt service of about $240,000 per year. Additional long term planning
could show that those rates could be lowered. Likewise, sanitary sewer rates appear to be stabilizing.
In the next few years, it is likely that the Council will have to seriously consider a water treatment plant for
iron and manganese removal. Such an expense (estimated at $8 million) would be financed by water utility
revenue bonds. Rates may have to increase above $2 per 1000 gallons to pay operating, capital, and debt
service expenses.
City of Brooklyn Center
DRAFT
2001 Public Utilities Rate Study
The City Council annually reviews public utility rates to ensure their adequacy in meeting financial
goals. The Public Works Department strives to meet these goals while keeping rates as affordable as
possible. The total utility bill paid by a resident of Brooklyn Center continues to be lower than in most
area communities.
Water Utility:
>va "`t >` zoao 2001
The schedule labeled Water Utility Rate Study: 2001
<ts
.................... Is > >< e Charge Char
g shows the projected effect of increases in rates for
2001 and ubse ue
s nt Y ears.
Recycling $25.80 $25.80 With the exception of the periodic painting of water
Water $122.20 $127.40 towers and the possible need for a water treatment
facility in the future, most capital outlays in the water
Sanitary Sewer $t90.o0 $200.00 utility will be main replacements associated with
Storm Drainage $40.00 $43.00 neighborhood street improvements and other
infrastructure rep air.
Total $378.80 $396.20 It is recommended that the Council adopt a rate
Dollar Increase s ' $ 17.40 increase of 4.25 %, or an increase from $0.94 per
1,000 gallons to $0.98.
Percent Increase 1.8% 4.6%
Major improvement projects scheduled for 2001
include water main replacement associated with the
2001 neighborhood street reconstruction in the Garden City North Neighborhood and with the Brooklyn
-. Boulevard project, and rehabbing the exterior of Wellhouse #4..
Sanitary Sewer Utility:
The table Sanitary Sewer Rate Study: 2001 shows the projected effect of a modest increase for 2001.
Considerable expenditures have been made from this fund in the past several years, however, this cycle
of large facility expenditures, is coming to an end. Aside from facility improvements, neighborhood
street projects have required substantial sanitary sewer main replacements and repairs, and will continue
to do so. In most neighborhood projects, the majority of sewer main has been found to be in need of
replacement.
Capital improvements for 2001 will include: replacement of all the sanitary sewer lines as a part of the
2001 neighborhood street improvement program in the Garden City North Neighborhood. Detailed
analysis of future capital needs for all utilities can be found in the Capital Improvements Plan.
It is recommended that the Council adopt a rate increase of 2.1 %, and increase rates from $47.50 per
quarter (residential rate) to $50.00 per quarter. There was no rate increase in 2000.
Storm Drainage Utility:
The table Storm Drainage Utility Rate Study: 2001 shows a 7.5 % increase in 2001 rates, with smaller
or no increases in the following four years.
A financial management priority for the storm
drainage utility is the accumulatio t
cash balance of $540,000. This b s
��' eta "'e':einr`lltil7 ` >'» 00 2001
9;:...; ;:......Y 20 to provide for adequate cash flow and provide
<'£tae; >_;:« Charge Charge
flexibility in P ro ammin projects. Substantial
1 g P J
. e as
e
Palmer Lake basin as well
................................................................... .
.. ..
........... ...............................
im rovements to th
Recycling $25.80 $25.80 construction of additional regional detention ponds
are expected to become a priority over the next
Water $28.00 $28.00 several years.
Sanitary Sewer $104.52 $110.00
Capital improvements scheduled for 2001 include:
Stone Drains a $40.00 $43.00 storm sewer work associated with the neighborhood
in the Garden City orth
ri
.................. _ street reconstruction Neighborhood, miscellaneous structure
Total $198.32 $208.80 improvements, and participation in a potential
Dollar Increase $8.48 project to improve water quality in Upper Twin
Lake.
Percentlncrease 1.1% 4.3%
It is recommended that the Council adopt a rate
increase of 7.5 %, or an increase from $10.00 per
quarter (residential rate) to $10.75 per quarter.
Recycling Utility:
The Htnnepin Recycling 'Group (HRG) has adopted their budget for 2001 and it maintains current
service levels with no increase in fees-for 2001. Rates will remain at $2.15 per month, or $6.45 per
quarter.
Utility Connection Charges:
The new utility connection charges would be effective January 1, 2001, at the rates previously discussed
by the Council and shown on the utility rate schedule.
Summary:
Staff recommends increases in water, sanitary sewer and storm drainage rates for 2001. If the
recommended rates are adopted, the annual utility bill of the average customer would increase by
approximately 4.6 %. The annual bill of a senior customer would increase by 4.3 % . This compares to the
current rate of inflation.of 3.4 percent.
WATER UTILITY RATE STUDY: 2001
11- Oct -00 Budget budget
.{ W..v r... .. n; :. vv v: • •. • ry +rr.:
..3� ... , x'' , tryyf..+ {• • }'•�.;,': v;:' . r,:,, {::k ;3:,',{. • {fr: �''.' arc:.. .,::d;�•: ;,'•'k•'.s>• {.,r.• .. Zr :•. } ,`• : : : {:C {•}.:,}.; / } INN! }.,;;.; :��.•t'�.'. : v:::1-1 :::: .k
Start of Year Cash & Investments
EXPENDITURES
Operations •
Personal Service $414,306 $445,938 $459,316 $473,096 $487,288 $501,907
Contractual Service 201,195 210,290 216,599 223,097 229,790 236,683
Supplies & Materials 145,000 147,000 151,410 155,952 160,631 165,450
Utilities/Insurance 117,100 119,475 123,059 126,751 130,554 134,470
Depreciation 372,042 412,055 420,000 425,000 430,000 435,000
TOTAL EXPENDITURES $1,249,643 $1,334,758 $1,370,384 $1,403,896 $1,438,262 $1,473,510
REVENUES
Billing Revenues $1,128,000 $1 $1,224,000 $1,320,000 $1,416,000 $1,488,000
Miscellaneous Operating 150,000 155,000 160,000 165,000 170,000 175,000
Bond proceeds
Change in Fair Market Value of Inv
Miscellaneous Non - operating 20,000 20,000 20,000 20,000 20,000 20,000
TOTAL REVENUES $1,298,000 $1,351,000 $1,404,000 $1,505,000 $1,606,000 $1,683,000
.Net Income or Loss $48,357 $16,242 $33,616 $101,104 $167,738 $209,490
Depreciation Add -Back $372,042) $412,055 I $420,000 I $425,000 $430,000 $435,000
.. r.. .,, n. ..1r ... .. 4•. {... v}l+l... f. .....v........ .v 6 {''- "kti " F S.
{•::.;•:.vrr••:••r.� - } }• +xr ? ••.:ry }x.: :} ..}}: •,• „x} .. ..... l fr•v .:.: .. {: {.:: : . l.. : :.... ....... ..: • /r+k:•... ^:d' ?:. {:' {• }:•' "s�:'s •:'.k }. . ,:# {. ,
^ . v r•f$'} M v .. .. ::...:: x}:: �v:. .f .v:.•, +i{?ry:. •.•. ? .`..::..+. ... .v .n..v}yrr: w• . - }: 2•.•. p� • •v�v k•;•;•,
:: •:.•. .. ;{ :.. k:. }•' �,:v}, >''.' "•. {.. .:. k :r : fr.. .:: :. .;.,%:.; ..:: : ?: ? ... \. .rv: \.�vv :C { .v, \• :
:f .. . . .{�' ? w..C.l .yry •H ., +••, :••.•:. kk•Y?.•. . y ^� ..1+C'•:.. f.?�(/�y{� v.\
_ � .. ..; � r.:..: .v }: v r :? v': • n .:: ik :v ..: .��.-}- ��•��: :: v k•;': : 'ki �'• :�>
• }'.. ...•:. , n: 't� ..�.... }:,.'��.
= ��R�F1: -� �f1M4R: "'SC� .'+�7.. .�: v.:: L:rr::4 { .... /. 3 :•.'7.•.Sw.'R!! .. .v :.v .f: �' k': �: n:: n..........: v�. r.:........ �5:{•}. �i}.. H....�....::..:�v.v::.v:.:;.�., .} :::.:Or: \.{.... :..... jv,.v.,:...0. f.•.':• h.. iv:{•} 4. 6.... n�.::. vv:wv.,Sa:.. \ ................:n .
_ w:: v rr::::::.: ��• x::::: h... v...+ f.:..... xr.: n...:.:. v ....nn.........:%v.•.. i'3r.Y..........,... n.�.v. \ ry �.....r.r •• -
.
:tt•'Lti{•:r. v? ^ rytix; : ?:.:•:•: ::• }y• {S {? r. { {t.:):}v' 4 . ' :; .• :,•� :, r.r. ..:A:.; : :.;: "{:: ?: } }::;$Jk ikv:.}r;ryi {xx•:v:, . .,' .•:{$<;:;
4
}i. C4:k.:; }:. ,rnf•::::.v; ?,.} 5 <}.. ? n:�? : :' Y' %•: } ;'. } : r., n n \.?.r
.n {.:.. t� :. 4,.. ?:.iC{:'k •:•:• } { {: •w },y�{�.,.y,. .• Y•.:.v.:. ♦A,� k i•:•:•'.' k : }'� a,.}.•'s' Ti>•::,{•:ok$';�,c4,'; :• }::v'r ' .•t.,{k \v.: v•.
::$: .'f.•: }:? • ��rr�� • rr}.•: 4:? v::{.i::� : ':irr.. // ... \ ''YM�:. }.: ,: S: }. k•S.'•:i {• ��{� vL
M; {•$.w:. ••.:v .•?;,., • �..'!�':•.v.{{v: kki4}: [ i ' .... (:: r.. ..:,Y}. .; .�:'r' v.; x ,.,..: v 1�•} vv{}}}}. 4tii: li rv{.. vv:.,: i .•:.• ^•..•.'•?: {k.}X•:t:r. ?. {k•
::::::. {.{ +.....v.... r..• ................,...v ....:•: {v.'.�`.• .•..R;.,...kv....... }:• }. <ii•.:i:::::• :`f.., {{::::v : n ::: •:�. �: i ^ }::.,v. ,.,.v:.•.� ��T��.:. vv�}:{. 8.}: r..% .. :.v.. + .{::. 7 k.,.....
-Non Operating Expenditures
Capital Outlay $910,605 $1,128,540 $1,295,945 $525,728 $693,508 $375,728
Debt Service $56,300 $56,300 $56,300
Non Operating Revenues
Interest Earnings $141,108 $120,838 $89,053 $48,574 $51,021 $48,784,
Total Net Effect on Fund Balance ($405,398) ($635,705) ($809,577) $48,950 ($44,749) $317,545"
End of Year Cash & Investments
For Information
Proposed Cash Balance Target $1,700,000 $1,700,000 $1,700,000 $1,700,000 $1,700,000
.: ...:::: .::. .... rr.... . . .. .. r. .r.. .....: fi::%{v: ^•.. }:...v,,. ..... l::•.v:.:.:r... F.f .. .............} . .. .. ... :. ... .. .. }\:.: :.:....; . ; \, {.:::: r : r : r ..........: •:k::: . ,{: }r. \: f.
...•......... : r .: r • • :::• . ............., ... .{ r 1. ........... .............,r:.:•.,., p,•:: .: k- :'ry.. {,.'`.'t+r} •::.:.., : : `r. ;••'.t }:. ••::•: } } }:::.
? }. .. ?,... r...., i \•:C
•x ?:.•.vilr. ?. .v v:},•: .. .}- •'J.: ?•i} ?iiY { {.. }Y{- .u.+ •.:•k..}
n.k.. • ?iS. v .. •: w: :{.. }: >.•:•:• r•: {::•.:... \.w: r•:::: ?•: r: rY.ryv. r.... T.'A { :• ik
... . .... .........:.....l. x.. ? v................. ..v:::::::::..::....:. r..... .....h:.vv.... n.:...... 'i. vv}::::,v}; . :....... .n + •k'•i: 'P <:• } ::kkv:ti :k:;::i. .•,:' •:l:Y. } :;::kkin::::::: :•: rr ;....: �:i '. r.•.
.. 0 ...dal ... .:.......... .........r..,.................. i� . ......................:..:..::. ��.{.:.. �.:.....:.,....... �".. �...... :............:.......:.....'...
1�! 1�...... �........!. Q. �k :...............:..... v.......................... r......................................................:....:}..{......,....,.....................:..........,..... .......:r: ::.:..:vv..r:�. }::.:: r:.....,:..,.:::.::::::: r:>::::::.,::::::::... .r:....:::.:,:�::.:r:r:: }::::::
.. ........................... ...........................:...
Number of gallons (in 1000s) 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000 1,200,000
SANITARY SEWER RATE STUDY: 2001
11 -Oct -00 Budget Budget
Start of Year Cash & Investments
EXPENDITURES
Operations
Personal Service $196,426 $208,729 $214,991 $221,441 $228,084 $234,926
Contractual Service 130,691 132,288 138,902 145,848 153,140 160,797
Supplies & Materials 17,000 16,500 16,995 17,905 18,030 18,571
Utilities /Insurance 29,250 32,380 33,999 35,699 37,484 39,358
Depreciation 213,024 234,237 240,000 245,000 250,000 255,000
Subtotal: City O&M Expense $586,391 $624,134 $644,887 $665,492 $686,738 $708,652
MCES Charges $1,410,000 $1,425,000 $1,439,250 $1,453,643 $1,468,179 $1,482,861
TOTAL EXPENDITURES $1,996,391 $2,049,134 $2,084,137 $2,119,134 $2.154,917 $2,191,513
REVENUES
Billing Revenues $2,376,644 $2,510,901 $2,647,386 $2,685,765 $2,725,245 $2,766,045
Miscellaneous Operating 0 0 0 0 0 0
Change in Fair Market Value of Inv
Miscellaneous Non-operating 1,000 1,000 1,000 1,000 1,000 1,000
TOTAL REVENUES $2,377,344 $2,511,901 $2,648,386 $2,686,765 $2,726,245 $2,767,045
-Net Income or Loss $380,653 I $462,767 I $564,2491 $567,631 $571,328 $575.532
$213,0 $23 $240,000 1 $245,000 $250,000
'Depreciation Add-Back $255.000
...... ............
K
. . . ....................
....
X ....
Non Operating Expenditures
Capital Outlay $1,164,782 $775,600 $1,223,640 $654,765 $661,649 $354,765
Non Operating Revenues
Interest Earnings $79,953 $42,070 $40,244 $21,287 $30,244 $39,740
Total Net Effect on Fund Balance ($491,152) ($36,526) ($379,147) $179,152 $189,924 $515,507
oft"
%.j
End of Year Cash & Investments
For information Proposed Cash Balance Target $950,000 $950.000 $950,000 $950,000 $950,000 $950,000
Residential Accounts
Senior Accounts
STORM DRAINAGE UTILITY RATE STUDY: 2001
11 -Oct -00 budget budget
.. •.::,• , vv,•Fnri... FF: v:r .{ .. .,. • : •:.:..a ..:
1,11 .. f. .. S:i /:: } } } x�:::: . }:, ..;, •:'.•iinv �i:i:.. 7}X•} �{ ?:v}. \r}:iz} :if:'• • {5 ` , `••;. .;> : t}.�3'•'`y'{�:- {. } :.:.•:f •:: +
+ All? F.•fn} v.{• . `';:4'.;F.:•'•:i;• : ' v 'i• `, y .':4:v. •. ;:};•xn} x�x!�y�
:...:. ......::..v }••;,: :{ar.•;:. }, }, .: #�?�'','y� ::T%}}:: : }. ; s „}• • •?} }� }: : ...,;,�rF{'ti. . n•`: c.: ��' .,: }..? r.}} }:...':4•.k }•:.:} :: %::
Start of Year Cash 8r Investments
EXPENDITURES
Operations
Personal Service $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Contractual Service 52,878 56,879 58,927 61,048 63,246 65,523
Supplies & Materials, 1,000 500 1,100 '1,100 1,200 1,200
Utilities/insurance 2,200 3,200 3,315 3,435. 3,558 3,686
Depreciation 108,868 164,902 170,000 180,000 190,000 200,000
TOTAL EXPENDITURES $264,946 $325,481 $333,342 $345,583 $358,004 $370,409
REVENUES
Billing Revenues $1,040,000 $1,118,000 $1,196,000 $1,196,000 $1,040,000 $936,000
Change in Fair market value .7'
Miscellaneous Operating 0 0 0 0 0 0
Miscellaneous Non - operating 2,500 2,500 2,500 2,500 2,500 2,500
TOTAL REVENUES $1,042,500 $1,120,500 $1,198,500 $1,198,500 $1,042,500 $938,500
Net Income or Loss $777,5541 $795,0191 $865,1581 $852,917 $684,496 $568,091
Depreciation Add -Back $108,868 $164,902 $170,000 $180,000 $190,000 $200;000
- . ..::.:.v r {, r{ Fnn : {v %•: • :::. }: ::..:. \... :v .. f ..: : %vrr }:; • .. :.. ,.: vi
... rx.:.• ry} JC'•. m:,,•. .F.: }v:.0.. {.;. } :, 1. .. :.::.�;; r i5�4i n :''i'{•'•:• }. �}.
•• .. ... fr. f F...} }: i•: •n.. �,.v,..: ? .: • }.. N.•...: } :.v. ... }'p ., :.
... :. .. � . • n i.. n..n...• ...:. : {• +..:: {'•} v:v.:. •.. : v ms�s{{.. ,�X }
_��i': I ��3 #iZ• }C � .. . . . � .. ...� .: {:r:. {. ...r.+� ............... : {vi..ni•.:......�+�.... }. .•...'. �.. n. �' ��i` �.......... rx.....:.. 3....:. �x. n. ....: ..c.:....�.►....��F.�.;•,: n : n} : fi:.:'::r.:.,......::.x::�.:::.
�C +,'i +i :!1: • % :Q }%: }:.. } i {{: ' } }} : : r :i. i \ \v: } i.. i •:iv{: S£{ :. 4•C}} x } } � • { �: } :: } i:�ti' } }: : , • }iti•;v,:
v: \.i:: 6 ti' }%i,'. :{ ?{ : < % \• \,` }`.:: :. •,f{i ::'r':: $: .,�n: k.} f, .;r.,.; .... ,: \: •}. ,;} },L.,¢v, � .n v }q{:•• {� ' }tiv:::':'•i \•:
.•',�fy :•:Y, ,. ..< {.:F :.<,.. ry �.::}s. co..{ �'y�!� . :.e ?., n: :'}�.,' •n >, }.. -. k\.c•'•'`' };.? :..1t%;,:i?{•: }:}., {r{
•..Y:::S? %:::.:v}� n.. #?';'• }.l••.. '��i!:�:�::;:t: �f:. •..., •- .�Ri•.... r..n.♦ }#::KS }} ••' V4�!1+�::".;..:�::} ;2:. }•�. ;..- .�'}...:.. '. • • : • };4 }:: }.. �....
:,:.,t... r.,.. �,:..:? 6: �C:::.,. tf:: C{.:..<...:, � ::..:::::::..:£,.::: r,.,:::..::.:} .?:.�.. >.2:.��lef...�:: {:.::: n.:::::x•.,i.- ::,n,.. F., }: ....,... r<..... �.,:..}...:..... �C....+ 5.,.. �..:`: . }• }•• .�.............,, ......xx:::.r,r.,..
Non Operating Expenditures
Capital Outlay $704,310 $576,917 $959,653 $478,405 $517,323 $336,078
Debt Service .$240,460 $240,950 $241,100 $240,540 $239,250 $237,210
Non Operating Revenues
Interest Earnings $12,030 $9,714 $17,303 $9,888 $26,081 $33,282
Total N et Effect on Funo Balance ($46,317) $151,769 ($148,292) $323,861 $144,004 $228,085
End of Year Cash & Investments
For Information
Proposed . Balance Target $540,000 $540,000 $540,000 $540,000 $540,000 $540,000
.......................:.v::: n .......... . .: v •: n.: x,.::: n: .............. .. ......... . ..r::v:rvn,•.:.v: •.• :.w::.v: n••n v:::::: r.::.i ?': { {: n'n+U'f.':i{3.... J • {i:,r •. }, •N• y ; : v.,..: -.. •...:.v: }::. w..... {•
r. }:::: }:}: F A:, J nv. ; % .... %r .$ .: :; : ... .. .n v .• } }} { }: :••}
.......;. n..,.: {, ..r ; i:.: �1� } }:•% { {n }:ti :•} }:....... :F : •x •: {.: x::vnnv r::: (� j� ,yy��(
r: .:.. :f,.::: •v: }nvv: •: w::;i.: { ......... {... .. � . {.... { :n ?: } ;:;.;i : :: }:: }$::: r. '•:�:H :�: } hti{{:;.:b }:v } }}; }}, } }. n } G� r:: :.•. } }}• {}{
.. :. n �n f.0 :••.. ... . ... : • .' . .... v: x::: { {:: { {i• } }'.. :. AI!T}R�. � w:: }'•: r.
*Ol!•.S- �i�... . ...... ..... ..r... ...... ..... n . r.r .... ...,....v.. t.....n .. w:...... \x...:....:' {� }-.::. . } }i �:: }• iii..L n�tii
. ....... :T... x.......:....:... r.. :.....r}.. .:} .. f.. r r . .... . .: ... ... ... ...... .4nx.vxx: rtiv� ...... .................... y..... ,.,.,,..: •n.'
{.•;..•x:::: n:A.:xxrrr:::::: l•:::}::,•: x: n .................... r. f.... r.. ...}x...n: {{.....v.:�.r.:...::v r....nr.... r. r. n......:.... ...............n...:,...,.w:: x::::: x:::x ::: v::. w: n•. vn. v.•: n{•. A: vi:... i '::,vn.v1:':•: %::v..r.Ox:....4. n.n ifi:4::v
Residential rate per lot $10.00 $10.75 $11.50 $11.50 $10.00 $9.00
Schools & govt buildings per acre $50.00 $53.75 $57.50 $57.50 $50.00 $45.00
Multiple family & churches per acre $120.00 $129.00 $138.00 $138.00 $120.00 $108.00
Commercial and industrial per acre $200.00 $215.00 $230.00 $230.00 $200.00 $180.00
City of Brooklyn Center
A great place to start. A great place to stay.
To: Mayor Kragness and Council Members Hilstrom, Lasman, Nelson and Peppe
From: Michael J. McCauley .
City Manager
Date: October 12, 2000
Re: Golf Course 2001 Draft Budget
The draft golf course budget contains modest increases in revenues and expenditures based on a
continuation of current activities. The draft budget meets the financial plan for the golf course and
its repayment of the construction loan principle. If operations continue on course, the golf course will
may be possible in 2002. We are also
eased loan repayments
reach its cash balance targets and increased Y P
reviewing final results for possible additional payments against principle.
6301 Shingle Creek Pkwy, Brooklyn Center, MN 55430 -2199 • City Hall & TDD Number (612) 569 -3300
Recreation and Community Center Phone & TDD Number (612) 569 -3400 • FAX (612) 569 -3494
An Affirmative Action /Equal Opportunities Employer
CENTERBROOK GOLF COURSE
2001 BUDGET
Dept
Actual Actual Adopted Requested
Budget 1998 1999 2000 2001
REVENUES:
Green Fees $218,562 $269,653 $279,211 $292,109
Rentals 10,402 12,791 12,250 12,000
Leagues 7,972 12,125 13,700 15,950
Beer 10,983 13,194 11,500 12,500
Concessions 14,627 16,816 15,950 15,550
Golf Lessons 5,487 2,918 7,500 6,300
Other Merchandise 19,975 24,691 20,000 20,000
Pop Machine 1,232 1,599 2,000 1,600
Interest Earnings 3,271 2,598 3,530 6,406
Miscellaneous 1,414 1,747 500 600
Total Revenues $293,925 $358,132 $366,141 $383,015
Less: Cost of Sales Beer $3,446 $3,446 $3,500 $4,100
Cost of Sales Concessions 11,384 11,384 14,000 14,500
Cost of Sales Merchandise 18,708 18,708 15,000 15,000
Cost of League Banquets 2,673 2,673 2,500 2,500
Total Cost of Sales $36,211 $36,211 $35,000 $36,100
Gross Profit $257,714 $321,921 $331,141 $346,915
EXPENDITURES:
Personnel $116,354 $145,159 $139,611 $148,088
Supplies 18,484 25,703 21,200 21,850
Other Contractual Services 23,802 31,075 20,308 23,505
Central Garage 25,588 20,331 21,612 12,750
Insurance 6,280 6,877 7,926 9,350
Utilities 14,141 13,320 11,250 13,530
Administrative Service Transfer 5,128 5,292 5,332 5,496
Depreciation 12,697 13,847 14,567 14,850
Total Expenditures $222,474 $261,610 $241,806 $249,419
Operating Income $35,240 $60,311 $89,335 $97,496
Capital Outlay $11,660 $4,358 $11,000 $13,800
Loan Repayment $50,000 $50,000 $50,000 $50,000
Available Resources ($26,420) $5,953 $28,335 $33,696
10112/00 11:21 AM
CITY OF BROOM .N CENTER
REVENUE BUDGET WORKSHEET BY FUND Page 1
2001 BUDGET
1999 2000 2000 2001
1998 AS OF 1999 ADOPTED AS OF REQUEST
3ject Code & Description ACTUAL 08/31/99 ACTUAL BUDGET 08/31/00 BUDGET
.e x sa mx x xx a xna axxx x x xx xa x xxx a e xx = exec a xaxx ax a exx x xx x x a x exxxx a x aaxx xx x e x a a e x_= xx a x a a x e xx xx xx x x x xx x xe x xx e x x x a a x a a a x x x x x x x x x a
'JND GOLF COURSE FUND 052
3467 Sale of Property 215 0 0 0 0 0
3471 Cash Over and (Short) 424 651 816 0 464 0
3472 Check Processing Fee 73 61 61 0 30 0
iscellaneous Revenues TOTAL 713 711 877 0 494 0
x xxxxxxa a x x e x x x ax x x xaxx x x x x xax a x ca xa x x e x x x x x x x xx xx x a x x 'I
3541 Weekend Rate 55,777 65,732 79,234 75,120 64,988 81,341
3542 Adult Rate 68,108 78,488 96,156 98,125 86,783 103,290
3543 Senior Rate 30,214 27,465 32,906 41,504 29,981 40,142
3544 Junior Rate 10,490 13,781 14,098 14,367 13,941 16,057
3545 Second Round 35,188 14,100 25,206 23,475 15,171 26,856
3551 Adult Passbook 6,127 8,130 8,774 8,028 7,289 8,451
3552 Senior - Junior Passbook 10,571 11,2.25 11,713 14,367 12,593 13,310
3554 Weekend Passbook 2,087 1,236 1,566 4,225 845 2,662
3556 Hand Cart Rental 4,606 4,360 5,443 5,000 4,239 5,000
3557 Club Rental 1,565 1,759 2,184 2,250 1,526 2,000
3558 Motor Cart Rental 4,231 4,094 5,165 5,000 4,328 5,000
3561 Couples League 540 239 239 0 1,500 1,500
3562 Mena League 1,147 3,217 2,870 3,200 3,540 3,200
3563 Womens League 3 5,734 5,153 5,500 4,924 5,000
3564 Womens Second League 480 817 717 1 1,860 1,500
3565 Senior League 1,612 2,229 1,875 2,500 2,200 2,500
I
CITY OF BROOKLYN CENTER
REVENUE BUDGET WORKSHEET BY FUND Page 2
2001 BUDGET
1999 2000 2000 2001
1998, AS OF 1999 ADOPTED AS OF REQUEST
bject Code & Description ACTUAL 08/31/99 ACTUAL BUDGET 08/31/00 BUDGET
ax xa ca as aasax as aaxx xa a xa a aaa mmaaa mm :aa as aaa mm aaaaa as aaa as s ease a xaaaa a xaa a a a :o x ca a a a a a a a x x xaxax ax a xa x as x as s a aax a a a a a a as a a mm aax a
3566 Junior League 763 1,294 1,272 1,500 3,084 2,250
3571 Beer 10,904 10,457 13,061 11,500 13,402 12,500
3572 Beer Pitcher 79 130 133 0 368 0
3573 Small Pop 2,578 1,556 1,862 2,500 1,750 2,000
3574 Large Pop 8,131 8,601 10,158 9,000 8,416 9,000
3575 Coffee 694 513 709 750 493 750
3576 Lemonade 75 17, 17 0 0 0
3581 Cookies 637 409 491 500 931 600
3582 Ice Cream 90 98 100 100 98 100
3583 Chips 388 443 506 500 509 500
3584 Candy 552 827 949 800 925 850
3585 Brats 347 192 200 300 170 200
3586 Cookie 3 packs 5 473 601 0 25 50
3587 Hot Dogs 1,131 1,015 1,226 1,500 1,453 1,500
3591 Golf Lessons 4,759 2,466 2,428 6,000 4,425 5,000
3592 Private Lessons 728 450 490 1,500 1,130 1,300•
3594 Taxable Merchandise 4,226 6,768 7,755 7,000 2,665 5,000
3595 Non Taxable Merchandise 15,749 13,509 16,936 13,000 10,060 15,000
3597 Pop Machine 1,232 1,316 1,599 2,000 1,015 1,600
3599 Miscellaneous 701 760 870 500 457 600
olf Course Revenues TOTAL 289,941 293,896 354,657 362,611 307,084 376,609.
xaaa as mmaa x xxaxa as a as sa saaa a mmx aaas aaa a s ax as a a x as a a x a x a a
CITY OF BROO.. A CENTER
REVENUE BUDGET WORKSHEET BY FUND Page 3
2001 BUDGET
r
1999 2000 2000 2001
1998 AS OF 1999 ADOPTED AS OF REQUEST
)ject Code & Description ACTUAL 08/31/99 ACTUAL BUDGET 08/31/00 BUDGET
caaaaaaaassaaaaaaaassassaaaaaaaasasaaa aaaaaassssaaaa asssssssaassss saasaaasaaaaaa asa--- �- -aaaaa as ��---- - - -aaa ssssaasasaaass
3800 Interest Earnings 2,993 0 4,270 3,530 0 6,406
3808 Unrealized Gain or Loss on Inv 278 0 -1,672 0 0 0
Lvestment Earnings TOTAL 3,271 0 2,598 3,530 0 6,406
a s s a y sss a saaa a sa as s a g a s aaa s a s s sa as s s a s ac a s .s s a s as s s ssa
)LF COURSE FUND TOTAL 293,925 294,607 358,132 366,141 307,578 383,015
s assn s say ss a a a a a as a sass a as a a as a a a a a s
I
CITY OF BROOb_.N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 1
2001 BUDGET
2000 2001
ject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
xxxxxxxxxxxxxxxxxxxxxxxaxxaaaaa :a asaaaxaxaaxaaa aasaaxamaaaaax xxaxxxxxxxxxxx xxxxxxxxxxxxxx xxaaaaa�xasaax xxxxaaxxxxxxxx
V CENTERBROOK GOLF 654
00 Wages Regular Employees 27,094 16,890 31,071 36,451 22,473 38,780
12 Overtime Regular Employee 0 378 0 0 0 0
30 Wages Part -time Employees 85,629 78,854 89,827 81,648 68,918 86,830
31 Overtime of Part -time Emp 1,599 2,536 1,027 0 674 0
33 Vacation Pay 1,458 1,435 �, 1,474 0 0 0
1 ,34 Holiday Pay 1,259 1,292 1,233 0 1,260 0
35 Sick Leave Pay' 0 0 2,988 0 687 0
laries and Wages TOTAL 117,039 101,385 127,619 118,099 94,011 125,610
aaaaaxaaa xxxxxxxxx aaaamaaaa xxxxxcaa: xxxsaasax aamxxxxxx A l i
42 PERA Coordinated Plan 2,465 1,543 2,352 6,118 1,761 6,507
46 FICA 8,772 7,711 9,346 9,035 7,091 9,609
50 Employee Benefits 3,570 4,340 4,400 4,762 3,176 5,004
51 Health Insurance 647 0 0 0 0 0
52 Life Insurance 3 0 0 0 0 0
53 Dental Insurance 60 0 0 0 0 0
54 Workers Comp Insurance 479 1,375 1,441 1,597 851 1,358
inge Benefits TOTAL 16,000 14,969 17,540 21,512 12,879 22,478
aaaaxxxx� xxaaxaamm xxxaaaxxx aaasaaxxx axxxxxxxa aasaxxxxx
10 Office Supplies 71 173 368 250 541 500
12 Printed Forms 373 0 85 0. 0 0
S
20 Operating Supplies 9,254 5,490 9,867 8,000 5,342 8,000
21 Motor Fuels 1,078 789 794 1,300 1,079 1,300-
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 2
2001 BUDGET
2000 2001
oject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
222 Lubricants & Additives 0 0 23 0 0 0
226 Chemical Products 6,277 853 734 3,000 0 3,000
230 Repair & Maint Supplies 548 50 517 500 1,128 750
231 Equipment Parts 702 0 21 250 95 250
233 Building Repair Supplies 0 1,164 798 1,000 216 1,000
235 Landscaping Materials 4,409 9,010 9,803 6,000 1,782 6,000
236 Signs & Striping Material 0 0 a° 0 0 190 0
237 Paint Supplies 0 0 0 0 59 0
240 Small Tools 0 43 431 100 607 200
241 Laundry 862 913 1,175 800 797 850
271 Minor Equipment 0 0 1,087 0 0 0
applies TOTAL 23,513 18,484 25,703 21,200 11,835 21,850
as a a a a as r, aaaaaa as a a= aaa a aaa aaa aaa as a a as aaa a a a == a s as as a
310 Professional Services 487 375 219 500 167 500
1313 Audit & Financial Service 79.8 825 500 520 510 530
318 Casual Labor 178 0 0 0 0 0
archased Services TOTAL 1,462 1,200 719 1,020 677 1,030
a a a a aaa a s a s aaa a as a a a a aaaa as aaa as as as a aaaa aaa a as a a a aaa a
321 Postage 0 54 0 .. 100 0 100
322 Telephone Services 4,348 4,611 5,023 4,200 4,459 5,000
334 Use of Personal Auto 0 12 0 0 0 0
340 Advertising 5,096 5,623 6,322 5,000 4,366 5,000
350 Printing 0 660 0 0 0 0
CITY OF BROO,. _9 CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 3
2001 BUDGET
2000 2001
eject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
:s aaccasaxacasaxxcasssxxssaxxsaaxs xxxssaaxacsass saxssaxxssasxs ssxacasaxxsass axssasaaxassss xxsasssaascxas aaascsassaaass
immunications TOTAL 9,443 10,960 11,345 9,300 8,825 10,100
• s ass sax c s s ssa x sas a c c s xsa a xc ss c a a a c s s s as a s as cx cs a s s s saa
80 Repair & Maint Contract 918 5,451 3,975 0 274 300
82 Equipment Repair & Maint 4,713 2,223 3,576 3,000 3,461 3,000
85 Landscaping Services - 0 789 0 0 0
.89 Maintenance Contracts J 50 0 0 0 0
.90 Rentals 590 437 1,073 2,000 522 0
.93 Equipment Rentals 3,403 0 4,780 0 3,216 3,500
t97 Logis Charges 1,863 1,442 1,522 1 1,573 2,200
;98 Protective Services 206 206 214 200 309 250
;pair Rental & Maint TOTAL 11,700 9,809 15,930 7,038 9,355 9,250
sasaascss cssssascc xcsassssa sasxxxxcc axsccssss aaaxsssas
100 Other Contractual Service 47 0 20 250 0 0
:01 Credit Card Fees 0 0 578 750 607 750
:02 Uncollectible Checks 79 48 9 0 10 0
111 Conferences and Schools 95 95 179 250 35 250
113 Dues & Subscriptions 534 556 718 500 384 500
114 Licenses, Taxes, & Fees 1'A 108 20 0 122 125
121 Janitorial Service 795 1,026 1,557 1,200 966 1,500
;her Contractual Sery TOTAL 1,723 1,833 3,081 2,950 2,123 3,125
saaxss aats ssa sxcssa asaxccssa casass asa cxxcccaxx aaacxaaac
140 Fuel Charges 343 415 280 450 131 276'
141 Fixed Charges 20,438 18,952 16,547 15,003 4,908 8,892
142 Repair & Maint Charges 4,322 6,221 3,510 6,159 2,151 3,582
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 4
2001 BUDGET
2000 2001
abject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
a a s x x x as xx ax x ssx x x a a a x caa s xx x xss s sass xxxa a s s xxx x a a x x x s a sxa x a x xxxxss s xxxa a s a x as as x ax x x a a a s x xa xa sss x x x x x x x a a sxx x x x a ax as
'entral Garage Rentals TOTAL 25,102 25,588 20,337 21,612 7,190 12,750
sxxxaxxsa axsaaaaxx xxasxxxxa xaaaassxx xxxxxssas aaaxsxxxx
461 Gen Liability Insurance 4,404 5,058 4,435 5,272 4,916 7,000
462 Property Insurance 2¢6 165 737 876 715 1,000
463 Machinery Breakdown Ins 54 57 136 161 167 250
469 Liquor Liability Ins 900 1 1,570 1,617 737 1,100
nsurance TOTAL 5,624 6,280 6,877 7,926 6,535 9,350
xxxxa s xxx sxc x x s ssx i' xxxa x x ss x a xxxx xxx x x x xx x a a x a x x x x a as a x
481 Electric Service 4,675 4,914 6,096 5,000 3,434 6,500
;482 Gas Service 1,248 870 616 1,200 539 1,500
.484 Water Service 4,081 6,133 4,690 3,100 3,400 3,500
485 Sanitary Sewer Service 175 181 194 200 143 200
487 Solid Waste Disposal 895 1,413 1,058 1,100 456 1,150
488 Storm Water Drainage 578 631 666 650 526 680
Itilities TOTAL 11,652 14,142 13,320 11 8,498 13,530
s x x xx x ssa xaas x x s ax x x x x x a x s s x a as s ssxs x ax a xs ss a x xx x x x x x s
520 Buildings 0 0 9,000 4,250 0
552 Other Equipment 0 0 0 2,000 0 13,800
'apital Outlays TOTAL R 0 0 11,000 4,250 13,800
611 Interest 57,500 0 0 0 0 0
iebt Service TOTAL 57,500 0 0 0 0 0
702 Administrative Sery Trans 4,722 5 5,292 5,332 3,556 5,496
CITY OF BR00.. _N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 5
2001 BUDGET
2000 2001
)ject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
ec sx a cc c cc c cac xxc as ca e c c cc � x ac c ca a a s cccccccc c cas a ccaeac a c c c c ea c c x cx a c cc c cc cc m a s s ac s as as a ca c se = cc ccc c cc cc c c c c c c ccc c c c oc
tministrative Service TOTAL 4,721 5 5,292 5,332 3,556 5,496
aaasacacx aaaaacccc xcccccccc caacxaaca ccccccccc ccccccccc
,123 Beer Cost of Sales 3,361 3,446 3,834 3,500 4,024 4,100
140 Merchandise for Resale 19,639 18,708 19,119 15,000 10,239 15,000
141 Merchandise Cost of Sales 302 0 0 0 0 0
142 Food Cost of Sales Guests 13,949 11,384 7,078 14,000 13,235 14,500
143 Banquet Expenses 2,655 2,673 a� 1,830 2,500 1,980 2,500
)st of Sales TOTAL 39,906 36,211 31,860 35,000 29,478 36,100
camcc xccc cccaacaac cccccccca ccccxcxcc xxcxsxxaa xccccccas
►20 Depreciation Expense 17,250 12,697 13,847 14,567 9,224 14,850
!preciation TOTAL 17,250 12,697 13,847 14,567 9,224 14,850
- a xx c x as as cccccc c c c cx x x x cax c xaxx x a x a a cc c c c cc c c x c x c ax x a x
-,NTERBROOK GOLF TOTAL 342,698 258,686 293,470 287,806 208,437 299,319
)LF COURSE FUND TOTAL 342,698 258,686 293,470 287,806 208,437 299,319
I
J
o
City of Brooklyn Center
A great place to start. A great place to stay.
To: Mayor Kragness and Council Members Hilstrom, Lasman, Nelson and Peppe
From: Michael J. McCauley
City Manager
Date: October 12, 2000
Re: Earle Brown Heritage Center Preliminary 2001 Budget
Attached are the preliminary budget sheets and the August 2000 Financial Statements for the Earle
Brown Heritage Center. At the end of August, revenues and expenditures are on course to meet the
2000 budget. The preliminary budget remains to be balanced on the capital expenditure side. This
will occur over the next month.
The preliminary 2001 budget projects an increase in revenue over 2000 of 4.85 %. $1 Million of
business is already booked for 2001.
There are several personnel requests in the preliminary budget that are being reviewed. There are
requests for 2 re- classifications and one request to have a full -time maintenance custodian in place
of part-time custodians due to the labor shortage.
Work is needed on the beam in the link that has rotted at the Inn. This is a $50,000 repair and
.replacement.
The "A" list of capital and equipment reflects the prioritization b the EBHC staff of capital and
P P Y P
equipment needs. The relimin budget is close to supp that level of expenditure. As with
P �'Y g PP g P
this year, the bulk of the discretionary items would be deferred until actua perfbrm-ance in - 2001
would indicate that the budget projections will be achieved. Some computer equipment and the link
work would be undertaken earlier. As the final results for 2000 become more certain, we may
propose doing some of the computer replacement in 2000 from actual cash in hand from 2000
operations. As indicated above, the budget will balanced in the later iterations. Operations are
currently balanced against revenues and finalizing capital and resolving the personnel requests will
bring the budget into balance.
6301 Shingle Creek Pkwy, Brooklyn Center, MN 55430 -2199 • City Hall & TDD Number (612) 569 -3300
Recreation and Community Center Phone & TDD Number (612) 569 -3400 • FAX (612) 569 -3494
An Affirmative Action 1 Equal Opportunities Employer
i
CITY OF BROOKLYN CENTER
EARLE BROWN HERITAGE ENTE
C R
FINANCIAL STATEMENTS
For the One and Eight Months Ended August 31, 2000 and 1999
Finance Department
EARLE BROWN HERITAGE CENTER
BALANCE SHEETS
August 31, 2000 and 1999
ASSETS 2000 1999
CURRENT ASSETS -
Cash and Investments $ 449,493 $ (39,751)
Accounts Receivable
Convention Center 196,870 256,718
Inn on the Farm 123 7,606
Office Rent Receivable 0
Allowance for Uncollectible Accounts (18,987) (3,097)
Total Accounts Receivable 178,006 261,227
Inventory - Flik 36,742 28,164
Prepaid Expenses 12,702 12,686
TOTAL CURRENT ASSETS 676,943 262,326
NONCURRENT ASSETS
Fixed Assets:
-Land, Buildings, and Equipment 14,187,871 12,790,943
Accumulated Depreciation (3,052,768) (2,747,643)
Total Fixed Assets 11,135,103 10,043,300
TOTAL NONCURRENT ASSETS 11,135,103 10,043,300
TOTAL ASSETS $ 11,812,046 $ 10,305,626
LIABILITIES
CURRENT LIABILITIES
Accounts Payable $ 263,092 $ 327,242
Interest Payable 343 0
Deposits Payable 263,327 141,808
Deferred Revenue 2,753 3,111
Accrued Payroll 11,900 - 5,836
Accrued Vacation and Sick Leave 22,316 26,605
Due to Hennepin County - Special Assessment 21,733 0
Revolving Loan Payable to City 545,000 385,000
TOTAL CURRENT LIABILITIES 1,130,464 889,602
TOTAL LIABILITIES 1,130,464 889,602
FUND EQUITY
Contributed Capital 10,760,155 9,764,687
Retained Earnings (Deficit):
As of January 1, 2000 and 1999 (260,633) (134,766)
Income (Loss) to Date 182,060 (213,897)
Total Retained Earnings (Deficit) (78,573) (348,663)
TOTAL FUND EQUITY 10,681,582 9,416,024
$ 11,812,046 $ 10,305,626
Earle Brown Heritage Center
Statement of Revenues & Expenses
For the One and Eight Months Ended August 31, 2000 and 1999
August August YTD YTD
2000 1999 2000 1999
Operating Revenues
Convention Center $ 104,303 $ 71,163 $ 610,514 $ 423,636
Catering Operations 227,936 187,817 1,733,427 1,301,044
Inn on the Farm 29,331 18,995 138,471 133,983
Earles 0 0 0 (755)
Commercial Office Rentals 5,012 4,711 40,092 32,090
Total Revenues 366,582 282,686 2,522,504 1,889,998
Operating Expenses
Catering Expenses 199,940 165,407 1,422,236 1,154,262
Personal Services 69,415 68,615 500,776 519,347
Services & Other Charges 35,679 33,982 204,067 211,468
Supplies 10,408 15,470 62,026 62,616
Utilities 11,940 12,325 80,769 77,522
Property Taxes 1,388 2,938 11,103 23,515
Interest Expense 1,303 1,366 22,504 16,133
Administrative Services 4,620 4,879 36,963 39,032
Total Expenses 334,693 304,982 2,340,444 2,103,895
Income (Loss)
Before Capital Outlay $ 31,889 $ (22,296) $ 182,060 $ (213,897)
Capital Outlay 0 3,822 45,354 53,567
Net Income (Loss) $ 31,889 $ (26,118) $ 136,706 $ (267,464)
*FliWs claimed expenses at 8 -31 -00 are $7,685 more than stated on the financial statements. If these expenses
are deemed to be acceptable by the city, catering expenses and net income will be impacted accordingly.
.
Earle Brown Heritage Center
Catering Operations and Convention Center
Statement of Revenues & Expenses
For the One and Eight Months Ended August 31, 2000 and 1999
August August YTD YTD
2000 1999 2000 1999
Revenues
Food and Beverage $ 169,177 $ 127,605 $ 1,292,394 $ 990,654
Liquor 28,359 37,362 204,087 170,903
Room Rentals 64,606 37,455 389,477 267,991
Equipment Rentals 34,951 30,132 182,396 127,966
Event Labor & Services 3,360 3,350 34,807 25,823
Service charges 29,702 22,418 232,232 128,395
Miscellaneous 2,084 658 8,548 12,948
Total Revenues 332,239 258,980 2,343,941 1,724,680
Expenses
Catering Cost of Sales 44,925 51,574 338,316 309,835
Payroll and Employee Benefits 126,453 96,099 869,710 729,736
Tips 26,242 16,803 183,334 96,057
Supplies, Laundry & Rentals 25,490 18,408 130,547 103,936
Marketing 2,154 3,973 30,462 43,843
General & Administrative 3,444 6,944 45,794 31,146
Utilities 9,564 13,053 73,631 73,226
Equipment Leases 12,699 14,683 48,907 48,257
Insurance 502 1,167 8,559 12,648
Professional Services 3,324 0 5,067 427
Repair & Maintenance 3,546 3,791 25,866 25,160
Contractual Services 2,766 1,398 14,358 11,581
Interest Expense 626 683 11,046 8,066
EBHC Catering Expenses:
Payroll & Benefits 6,077 7,875 53,122 57,915
Supplies 1,075 421 4,909 7,344
Communications 609 350 8,891 15,344
Contractual Services 5,680 7,915 49,333 '9,571
Utilities 2,867 2,155 27,250 13,322
Total Expenses 278,043 247,292 1,929,102 1,637,414
Income before Management Fee 54,196 11,688 414,839 87,266
Base Management Fee 8,333 8,333 66,666 67,499
Incentive Fee 0 0 0 11,676
Total Management Fees 8,333 8,333 66,666 79,175
Income (Loss)
Before Capital Outlay $ 45,863 $ 3,355 $ 348,173 $ 8,091
Capital Outlay 0 3,822 45,354 15,452
Net Income (Loss) $ 45,863 $ (467) $ 302,819 $ (7,361)
'Flik's claimed expenses at 8 -31 -00 are $7,685 more than stated on the financial statements. If these expenses
are deemed to be acceptable by the city, catering expenses and net income will be impacted accordingly.
August 1999, YTD 2000, & YTD 1999 have been adjusted to include tips collected and paid out. The effect of
this adjustment on net income is zero.
r r
Earle Brown Heritage Center
Inn on the Farm
Statement of Revenues & Expenses
For the One and Eight Months Ended August 31, 2000 and 1999
August August YTD YTD
2000 1999 2000 1999
Operatinq Revenues
Room Rentals $ 27,894 $ 17,867 $ 121,437 $ 117,810
Facility Rentals 1,000 864 12,587 13,285
Equipment Rentals 230 169 3,325 1,921
Meal Sales 76 22 147 340
Meal Service Charge 0 0 0 25
Other 131 73 975 602
Total Revenues 29,331 18,995 138,471 133,983
Operatinq Expenses
Personal Services
Salaries & Wages 12,477 14,152 81,217 103,219
Payroll Taxes 1,732 2,057 11,479 14,979
Employee Benefits 0 367 0 2,936
Total Personal Services 14,209 16,576 92,696 121,134
Supplies
General Operating Supplies 966 1,475 5,080 7,594
Repair & Maint. Supplies 117 194 3,276 867
Total Supplies 1,083 1,669 8,356 8,461
Services & Other Charges
Food & Beverages 1,942 1,306 7,024 10,841
Telephone Services 466 284 3,222 3,565
Advertising 568" 56 3,984 3,548
Repair & Maintenance 1,773 207 3,526 3,657
Contractual Services 981 397 5,520 3,694
Property Taxes 927 1,155 7,417 9,247
Insurance - 341 261 2,534 2,466
Other 309 418 4,565 4,977
Total Services/Charges 7,307 4,084 37,792 41,995
Utilities 1,523 1,547 13,322 11,859
Interest Expense 677 683 11,458 8,067
Total Expenses 24,799 24,559 163,624 191,516
Income (Loss)
Before Capital Outlay $ 4,532 $ (5,564) $ (25,153) $ (57,533)
Capital Outlay 0 0 0 0
Net Income (Loss) $ 4,532 $ (5,564) $ (25,153) $ (57,533)
Earle Brown Heritage Center
_ Earies
Statement of Revenues & Expenses
For the One and Eight Months Ended August 31, 2000 and 1999
August August YTD YTD
2000 1999 2000 1999
Operating Revenues
Food Sales $ 0 $ 0 $ 0 $ (752)
Liquor Sales 0 0 0 (3)
Total Revenues 0 0 0 (755)
Operating Expenses
Personal Services
Salaries & Wages 0 0 0 0
Payroll Taxes 0 0 0 0
D'Amico's Wages/Beneflts 0 0 0 0
Total Personal Services 0 0 0 0
Supplies
General Operating Supplies 0 0 .0 0
a�
Total Supplies 0 0 0 0
Services & Other Charges
Professional Services 0 0 0 0
Repair & Maintenance 0 0 0 0
Contractual Services 0 0 0 0
Food/Liquor COS 0 0 0 0
Insurance 0 0 0 0
Taal ScrdicestCharges 0 0 0 0
Total Expenses 0 0 0 0
Net Income (Loss) $ 0 $ 0 $ 0 $ (755)
Earle Brown Heritage Center
Commercial Office Rentals
Statement of Revenues & Expenses
For the One and Eight Months Ended August 31, 2000 and 1999
August August YTD YTD
2000 1999 2000 1999
Operating Revenues
Office Rent $ 5,012 $ 4,711 $ 40,092 $ 32,090
Total Revenues 5,012 4,711 40,092 32,090
Operating Expenses
Personal Services
Salaries & Wages 338 787 3,951 5,044
Payroll Taxes 52 122 600 794
Total Personal Services 390 909 4,551 5,838
Supplies
General Operating Supplies 0 66 68 467
Repair & Maint. Supplies 60 259 781 1,403
0
Total Supplies 60 325 849 1,870
0
Services & Other Charges
Property Taxes 461 790 3,686 6,322
Professional Services 0 0 0 0
Repair & Maintenance 0 0 563 1,549
Contractual Services 87 298 2,623 2,591
Insurance 174 229 1,875 2,683
Other 0 55 0 967
Total Services /Charges 722 1,372 8,747 14,112
Utilities 2,244 61 5,499 5,715
Total Expenses 3,416 2,667 19,646 27,535
Income (Loss)
Before Capital Outlay $ 1,596 $ 2,044 $ 20,446 $ 4,555
Capital Outlay 0 0 0 38,115
Net Income (Loss) $ 1,596 $ 2,044 $ 20,446 $ (33,560)
Earle Brown Heritage Center
E.B.H.C. Administration
Statement of Expenses
For the One and Eight Months Ended August 31, 2000 and 1999
August August YTD YTD
_ 2000 1999 2000 1999
Expenses:
Personal Services
Salaries & Wages $ 9,982 $ 10,461 $ 80,086 $ 83,286
Employee Benefits 2,395 2,368 19,166 18,874
Total Personal Services 12,377 12,829 99,252 102,160
Services & Other Charges
Audit & Professional Services 148 23 4,305 2,343
Logis Charges 2,484 1,897 16,659 12,679
Property Tax - H Barn 0 993 0 7,946
Other Charges 473 1,510 4,227 4,095
Administrative Service Transfer 4,620 4,879 36,963 39,032
Total Services/Charges 7,725 9,302 62,154 66,095
Total Expenses $ 20,102 $ 22,131 $ 161,406 $ 168,255
� 1
Earle Brown Heritage Center
_ Convention Center
Statement of Revenues & Expenses
For the One and Eight Months Ended August 31, 2000 and 1999
• August August YTD YTD
2000 1999 2000 1999
Operating Revenues
Room Rentals $ 64,606 $ 37,455 $ 389,477 $ 267,991
Equipment Rentals 34,951 30,132 182,396 127,966
Event Labor & Services 3,360 3,350 34,807 25,823
Other 1,386 226 3,834 1,856
Total Revenues 104,303 71,163 610,514 423,636
Operating Expenses
Personal Services
Salaries & Wages 35,175 31,336 247,808 235,912
Payroll Taxes 5,034 4,417 35,517 34,872
Employee Benefits 2,230 2,548 20,952 19,431
Total Personal Services 42,439 38,301 304,277 290,215
Supplies '
General Operating Supplies 5,332 6,217 29,245 28,920
Repair & Maint. Supplies 3,460 5,749 19,349 19,270
Total Supplies 8,792 11,966 48,594 48,190
Services & Other Charges
Professional Services 3,324 0 5,067 427
Telephone Services 1,391 2,336 11,683 13,278
Advertising/Printing 2,154 3,973 30,462 43,843
Repair & Maintenance 3,546 3,720 25,514 24,692
Equipment Rental 12,699 14,300 44,838 46,777
Contractual Services 2,766 1,398 14,358 11,581
Insurance 145 373 5,136 5,785
Other 381 2,451 10,609 9,525
Total Services /Charges 26,406 28,551 147,667 155,908
Utilities 8,173 10,717 61,948 59,948
Interest Expense 626 683 11,046 8,066
Total Expenses 86,436 90,218 573,532 562,327
Income (Loss)
Before Capital Outlay $ 17,867 $ (19,055) $ 36,982 $ (138,691)
Capital Outlay 0 " 0 24,743 4,200
Net Income (Loss) $ 17,867 $ (19,055) $ 12,239 $ (142,891)
Earle Brown Heritage Center
Catering Operations
Statement of Revenues & Expenses
For the One and Eight Months Ended August 31, 2000 and 1999
August August YTD YTD
2000 1999 2000 1999
Revenues
Food $ 169,177 $ 127,605 $ 1,292,394 $ 990,654
Liquor 28,359 37,362 204,087 170,903
Service Charges 29,702 22,418 232,232 128,395
Miscellaneous 698 432 4,714 11,092
Total Revenues 227,936 187,817 1,733,427 1,301,044
Cost of Sales 44,925 51,574 338,316 309,835
Gross Profit 183,011 136,243 1,395,111 991,209
Expenses
Payroll 68,280 49,724 449,317 377,951
Tips 26,242 16,803 183,334 96,057
Employee Benefits 15,734 8,074 116,116 61,570
Supplies, Laundry & Rentals 16,698 6,442 81,953 55,746
General & Administrative 3,063 4,493 35,185 21,621
Repair & Maintenance 0 71 352 468
Equipment Leases 0 383 4,069 1,480
Insurance 357 794 3,423 6,863
EBHC Catering Expenses: 0
Payroll & Benefits 6,077 7,875 53,122 57,915
Supplies 1,075 421 4,909 7,344
Communications 609 350 8,891 15,344
Contractual Services 5,680 7,915 49,333 39,571
Utilities 2,867 2,155 27,250 23,322
Total Expenses 146,682 105,500 1,017,254 765,252
Income before Management Fee 36,329 30,743 377,857 225,957
I
Base Management Fee 8,333 8,333 66,666 67,499
Incentive Fee 0 0 0 11,676
Total Management 8,333 8,333 66,666 79,175
Income (Loss)
Before Capital Outlay $ 27,996 $ 22,410 $ 311,191 $ 146,782
Capital Outlay 0 3,822 20,611 11,252
Net Income (Loss) $ 27,996 $ 18,588 $ 290,580 135,530
Fliks claimed expenses at 8 -31 -00 are $7,685 more than stated on the financial statements. If these expense
P $, P
are deemed to be acceptable by the city, catering expenses and net income will be impacted accordingly.
August 1999, YTD 2000, & YTD 1999 have been adjusted to include tips collected and paid out. The effect of
this adjustment on net income is zero.
EARLE BROWN HERITAGE CENTER
2001 BUDGET
Dept
Actual Actual Adopted p Requested
Budget 1998 1999 2000 2001
REVENUES:
Convention and Catering $2,282,559 $3,229,570 $3,300,000 $3,446,100
Inn on the Farm 207,665 210,136 210,000 212,000
Earles 19,064 (552) 0 0
Office Rentals 30,797 51,538 37,337 61,425
Total Revenues $2,540,085 $3,490,692 $3,547,337 $3,719,525
Less: Cost of Sales $410,628 $559,005 $614,555 $697,550
Gross Profit $2,129,457 $2,931,687 $2,932,782 $3,021,975
EXPENDITURES:
Personnel $1,335,746 $1,902,029 $1,782,565 $1,823,345
Supplies o 159,879 196,101 236,730 228,725
Other Contractual Services 491,981 634,717 527,513 534,234
Insurance 24,503 27,125 33,361 34,210
Utilities 136,827 149,678 175,976 173,830
Interest Expense 20,006 23,232 23,700 23,700
Administrative Service Transfer 62,767 58,548 55,443 59,035
Depreciation 8,384 65,831 18,699 9,999
Total Expenditures $2,240,093 $3,057,261 $2,853,987 $2,887,078
Operating Income ($110,636) ($125,574) $78,795 $134,897
Capital Outlay $84,883 $50,390 $48,530 $145,700
Available Resources ($195,519) ($175,964) $30,265 ($10,803)
CITY OF BROOKLYN CENTER
REVENUE BUDGET WORKSHEET BY FUND Page 4'
2001 BUDGET
1999 2000 2000 2001
1998 AS OF 1999 ADOPTED AS OF REQUEST
)bject Code & Description ACTUAL 08/31/99 ACTUAL BUDGET 08/31/00 BUDGET
x as z zz s x sx a z z z s sx sx a zz z as z zz z z za zz zz z a x aazz z zs s s s sa z zz z z s sxx z z z zz sasz z z z zz s ss s a zzz z z z zz s x s ss s xa a xa z z z z z z zz z z s s s ss s s s x s x x a
'UND EARLE BROWN HERITAGE CTR 053
3471 Cash Over and (Short) 0 1 0 0 0 0
3472 Check Processing Fee 0 0 0 0 60 0
fiscellaneous Revenues TOTAL 0 1 0 0 60 0
3600 Guest Room Rentals 185,647 117,809 185,673 190,200 121,438 190,200
3601 Facility Rentals 16,113 13,285 19,800 17,000 12,586 17,000
v
3602 Merchandise Sales 780 603 777 800 494 800
3605 Equipment. Rentals 2,842 1,896 3,881 2,000 3,325 4,000
I
3606 Miscellaneous 80 5 5 0 544 0
:.B.H.C. Bed & Breakfast Rev. TOTAL 205,462 133,598 210,136 210,000 138,38,7 212,000
sss s s s s ax z zz zz zs s s z z z z z zz z z s s s x a a ss s s x s a s x a x s s s s s s s s s x
I
3620 Room Rentals 408,577 245,260 397,504 550,000 336,653 570,000
3621 Labor Charges 7,459 2,932 4,017 9,000 3,836 7,000
3622 CMP Room Rentals 13,717 22,729 49,284 23,700 52,824 30,500
3624 CMP Equipment Rentals 4,483 5,443 12,102 7,200 34,025 14,000
3625 Equipment Rentals 150,288 92,838 265,240 157,000 120,622 170,500
3626 Dance Floor /Staging Rentals 47,073 29,685 47,709 47,000 27,749 47,000
3627 Event Supplies Charges 1,429 1,262 2,047 2,400 2,673 3,000
3628 Client Requested Services 27,414 17,492 21,797 29,400 22,070 29,400
3630 Security Services 5,243 5,400 10,500 6,200 8,900 10,500
3638 Miscellaneous 2,298 593 1,002 2,400 1,025 2,400
CITY OF BROOt,-.N CENTER
REVENUE BUDGET WORKSHEET BY FUND Page 5
2001 BUDGET
1999 2000 2000 2001
1998 AS OF 1999 ADOPTED AS OF REQUEST
)ject Code & Description ACTUAL 08/31/99 ACTUAL BUDGET 08/31/00 BUDGET
exxxxxxsxxxxxxxxxxsxxxxxxs :xxxxaaaxsxx axxxxxxaxxxxxx xxxxssxxxxxxss xxxxxxsxsxxaxx xxxaaxxxxxxxax xxxassaxxssxxx xxxxxxxxxxxxss
.B.H.C. Convention Revenues TOTAL 667,981 423,635 811,202 834,300 610,377 884,300
x x x x x x x ss xxx sxxx x x xx x xxxx xx sx s xx a s s x x x xx xx x x x x sxxxxxx a
3640 Commercial Office Rentals 30,797 24,892 51,538 37,337 40,092 61,425
3646 Miscellaneous 0 7,200 0 0 0 0
.B.H.C. Office Rental Revenue TOTAL 30,797 32,092 51,538 37,337 40,092 61,425
assxs�xxs asxsxxxas xsxaxxmas xxssxxsxs xaxxxxsxx xxsssxxss
3603 Meal Sales 1,922 256 ,� 256 0 131 0
3604 Service Charges 281 20 20 0 3,896 0
3657 Food & Beverage, Inn Event 0 0 0 0 17,371 0
3658 Concessions 0 0 0 30,000 0 9,500
3659 Food & Beverage Revenue 1,351,407 990,656 1,796,222 1,863,000 1,275,023 1,875,000
3660 Wine Sales 73.030 11,738 11,738 0 0 0
3661 Liquor Sales 112.846 148,099 274,409 253,600 202,786 301,000
3662 Beer Sales 57,685 11,066 11,066 0 0 0
3663 Service Charges 10,465 172,987 318,102 314,100 228,337 370,000
I
3664 Misc. Sales 7,804 3,093 5,690 5,000 4,654 4,200
3665 Misc.Sales -Non Taxable 1,340 605 770 0 75 800
3671 Liquor Sales at Inn 4,400 80 95 0 1,316 1,300
itering Operations TOTAL 1,621,181 1,338,601 2,418,368 2,465,700 1,733,588 2,561,800
xxa xxxxx x x xxxsxx sx axes sm ss s s x sxxxx x x xs x x xx s x x x x x x ss xxx
3670 Meal Sales 14,614 -752 -752 0 0 0
3673 Miscellaneous Sales 50 0 200 0 0 0
' I
CITY OF BROOKLYN CENTER
REVENUE BUDGET WORKSHEET BY FUND Page 6
2001 BUDGET
1999 2000 2000 2001
1998 AS OF 1999 ADOPTED AS OF REQUEST
)bject Code & Description ACTUAL 08/31/99 ACTUAL BUDGET 08/31/00 BUDGET
ca as a x as a ms s a xa xa as a a a aaaaaasx aaaaa aamx as a aaa a aaa m a a a a s msaca a as a s as a a a s s s s sxs axax a s aaa a a a as a as a a a x xaxa a a x as a s ssa s s m a a m s as va
3arle's at EBHC TOTAL 14,664 -752 -552 0 0 0
x a a a a a as a saaaaa a a a smsasa sa m aaaa aaaa s aaa m m s sa s a aaa a a a a a
3901 Transfers from General Fund 0 4,357 4,357 0 0 0
Pransfers from other Funds TOTAL 0 4,357 4,357 0 0 0
as aaaa sa aaaaaaaaa amsm a a a a a aaaa a aaa a a a a c a m s a m a s aaa a as a
MRLE BROWN HERITAGE CTR TOTAL 2,540,086 1,931,531 3,495,049 3,547,337 2,522,504 3,719,525
aaaa a_ s s m aaa xaaaaa a c a a a as a m as m m s s a m a m a a a a a a a a a a a as a x a x
� J li
EARLE BROWN HERITAGE CENTER
2001 BUDGET
Division: CONVENTION CENTER & CATERING OPERATIONS
Dept
Actual Actual Adopted Requested
1998 1999 2000 2001
REVENUES:
Rentals and Charges $2,282,559 $3,229,570 $3,300,000 $3,446,100
Less: Cost of Sales $384,913 $543,069 $597,255 $684,250
Gross Profit $1,897,646 $2,686,501 $2,702,745 $2,761,850
EXPENDITURES:
Personnel $979,789 $1,559,010 $1,471,878 $1,518,520
Supplies 139,990 182,174 215,920 212,090
Other Contractual Services 399,465 545,617 440,949 448,183
Insurance 16,297 16,241 17,458 23,357
Utilities 116,509 128,945 151,951 149,745
Interest Expense 10,089 11,616 14,000 14,000
Depreciation 8,384 62,202 18,699 9,999
Total Expenditures $1,670,523 $2,505,805 $2,330,855 $2,375,894
Net Income $227,123 $180,696 $371,890 $385,956
Capital Outlay 84,883 50,390 46,280 87,500
Available Resources $142,240 $130,306 $325,610 $298,456
EARLE BROWN HERITAGE CENTER
2001 BUDGET
Division: CONVENTION CENTER
Dept
Actual Actual Adopted Requested
1998 1999 2000 2001
REVENUES:
Rentals and Charges $667,981 $811,202 $834,300 $884,300
Less: Cost of Sales $1,539 $271 $500 $950
Gross Profit $666,442 $810,931 $833,800 $883,350
EXPENDITURES:
Personnel $425,605 $431,620 $533,703 $584,369
Supplies 57,254 77,187 86,775 85,930
Other Contractual Services 194,759 314,822 236,745 242,870
Insurance 5,923 7,063 7,319 6,238
Utilities 86,755 94,709 113,001 104,900
Interest Expense 9,917 11,616 14,000 14,000
Depreciation 0 36,741
Total Expenditures $780,213 $973,758 $991,543 $1,038,307
Net Income ($113,771) ($162,827) ($157,743) ($154,957)
Capital Outlay 50,390 50,390 21,100 67,600
Available Resources ($164,161) ($213,217) ($178,843) ($222,557)
i t
EARLE BROWN HERITAGE CENTER
2001 BU_ DGET
Division: CATERING OPERATIONS
Dept
Actual Actual Adopted Requested
1998 1999 2000 2001
REVENUES:
Rentals and Charges $1,614,578 $2,418,368 $2,465,700 $2,561,800
Less: Cost of Sales $383,374 $542,798 $596,755 $683,300
Gross Profit $1,231,204 $1,875,570 $1,868,945 $1,878,500
EXPENDITURES:
Personnel $554,184 $1,127,390 $938,175 $934,151
Supplies 82,736 104,987 129,145 126,160
Other Contractual Services 204,706 230,795 204,204 205,313
Insurance 10,374 9,178 10,139 17,119
Utilities 29,754 34,236 38,950 44,845
Interest Expense 172 - 0
Depreciation 8,384 25,461 18,699 9,999
Total Expenditures $890,310 $1,532,047 $1,339,312 $1,337,587
Net Income $340,894 $343,523 $529,633 $540,913
Capital Outlay 34,493 25,180 19,900
Available Resources $306,401 $343,523 $504,453 $521,013
EARLE BROWN HERITAGE CENTER
2001 BUDGET
Division: INN ON THE FARM
Dept
Actual Actual Adopted Requested
1998 1999 2000 2001
REVENUES:
Rentals and Charges $207,665 $210,136 $210,000 $212,000
Less: Cost of Sales $17,421 $15,936 $17,300 $13,300
Gross Profit $190,244 $194,200 $192,700 $198,700
EXPENDITURES:
Personnel $191,265 $178,538 $145,561 $140,653
Supplies 16,378 11,436 17,210 16,235
Other Contractual Services 51,131 42,849 51,230 44,250
Insurance 3,291 3,041 4,004 4,173
Utilities 14,317 17,411 17,900 21,300
Interest Expense 9,917 11,616 9,700 9,700
Depreciation 0 3,629
Total Expenditures 6 $286,299 $268,520 $245,605 $236,311
Net Income ($96,055) ($74,320) ($52,905) ($37,611)
Capital Outlay 55,950
Net Income ($96,055) ($74,320) ($52,905) ($93,561)
EARLE BROWN HERITAGE CENTER
2001 BUDGET
Division: OFFICE RENTALS
Dept
Actual Actual Adopted Requested
1998 1999 2000 2001
REVENUES:
Rentals and Charges $30,797 $51,538 $37,337 $61,425
Total Revenues $30,797 $51,538 $37,337 $61,425
EXPENDITURES:
Personnel $8,489 $8,701 $1,167 $4,460
Supplies 3,227 1,627 1,200 400
Other Contractual Services 30,099 15,570 12,460 8,462
Insurance 4,771 3,118 4,412 2,283
Utilities 6,001 3,322 2,675 2,785
Total Expenditures $52,587 $32,338 $21,914 $18,390
Net Income ($21,790) $19,200 $15,423 $43,035
Capital Outlay
Available Resources ($21,790) $19,200 $15,423 $43,035
i
i
EARLE BROWN HERITAGE CENTER
2001 BUDGET
Division: ADMINISTRATION
Dept
Actual Actual Adopted Requested
1998 1999 2000 2001
REVENUES:
Rentals and Charges $0 $0 $0 $0
Total Revenues $0 $0 $0 $0
EXPENDITURES:
Personnel $142,292 $155,780 $163,959 $159,712
Supplies 0 864 2,400 0
Other Contractual Services 8,812 30,681 22,874 33,339
Insurance 0 4,725 7,487 4,397
Utilities 0 0 3,450
Interest Expense 0 0 0
Administrative Service Transfer 62,767 58,548 55,443 59,035
Total Expenditures $213,871 $250,598 $255,613 $256,483
Capital Outlay 0 0 2,250 2,250
Total Outlays ($213,871) ($250,598) ($257,863) ($258,733)
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 6
2001 BUDGET
2000 2001
abject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
: xxxxxxxaxxxaxxxxxsaxxaxaaxaxxxxxxx sxxxxxxxxxxxxx xaxxxxxxxx xxxa asaaaaaaaaaaaa xaaaxaxxxxxxxx xxxxxxamamaxxx xxxxxxxxaaaxxx
iIV CONVENTION CENTER 655
100 Wages Regular Employees' 175,079 204,829 211,990 293,140 146,402 331,999
112 Overtime Regular Employee 1,424 1,582 -2,806 2,029 913 1,897
130 Wages Part -time Employees 112,048 105,026 102,595 133,179 80,466 133,179
131 Overtime of Part -time Emp 945 653 1,451 0 839 1,200
133 Vacation Pay 9,490 11,706 14,248 0 8,043 0
134 Holiday Pay 9,701 11,151 11,646 0 5,634 0
135 Sick Leave pay 7,079 10,070 6,315 0 5,017 0
197 Temporary Services 0 0 0 0 495 0
alaries and Wages TOTAL 315,767 345,016 351,049 428,348 247,808 468,275
x x xxxxx x:x a m a ax a a x a x x xx x x x x x a aaa x a xa s x x x x x x x a a x x x a x x xxx
142 PERA Coordinated Plan 13,993 17,119 16,887 22,188 12,319 24,257
143 PERA Police & Fire Plan 129 78 72 0 21 0
146 FICA 23,820 25,801 26,789 32,769 18,592 35,823
150 Employee Benefits 18,621 28,583 28,670 38,096 20,952 45,036
151 Health Insurance 1,938 0' 0 0 0 0
152 Life Insurance 15 0 0 0 0 0
153 Dental Insurance 165 0 0 0 0 0
154 Workers Comp Insurance 2,298 9,008 8,154 12,302 4,585 10,978
ringe Benefits TOTAL 60,969 80,589 80,571 105,355 56,469 116,094
xxaxxxxaa xxxxxxxxx aaaaxxxxx xxxxxxxxx xaxxxxxxa aaxxxaaax
210 Office Supplies 3,798 3,781 4,104 4,000 1,817 4,000
ti
220 Operating Supplies 21,780 23,124 30,884 27,900 20,694 27,900
• III
CITY OF BROO�-.N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 7
2001 BUDGET
2000 2001
)ject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
x x x x x x x x x x x s x x c x =xs x x xx x x x xx xxx x x x xxx xxx x xx x x x x c xa x x xx x =x xxxx = =x x x xx = x xx xxx x x xxx = xx = x= xx x axx x x x x xx x x xx = x x x xx . c c x xxxx =
!21 Motor Fuels 10 5 0 25 22 30
!23 Cleaning Supplies 5,004 8,719 9,066 8,500 5,671 8,750
!24 Clothing & Personal Equip 406 1,082 1,363 1,400 849 1,400
!25 Shop Supplies 537 165 326 500. 310 500
!26 Chemical Products 1,534 1,589 2,058 1 1,825 1,458 1,900
!27 Safety Supplies 173 181 ,� 242 250 192 350
!28 Guest Supplies .1 20 0 0 0 0
!30 Repair & Maint Supplies 3,879 3,766 6,921 8,700 4,641 8,700
!31 Equipment Parts 3,340 5,255 6,222 17,000 4,094 17,000
!33 Building Repair Supplies 8,455 5,998 7,225 10,700 6,394 10,700
!35 Landscaping Materials 2,116 2,018 3,768 3,400 1,806 3,000
!36 Signs & Striping Material 490 506 2,897 1,650 170 900
!40 Small Tools 624 809 699 800 473 800
141 Laundry 0 0 -2 125 0 0
!71 Minor Equipment 0 238 1,414 0 0 0
applies TOTAL 52,147 57,254 77,187 86,775 48,594 85,930
909 Energy Management Services 0 10,598 0 0 0 0
910 Professional Services 690 2,367 0 0 0 0
912 Legal Services 3,219 2,291 1,315 3,000 346 1,500
916 Security Services 137 72 10,538 5,000 4,721 8,000
irchased Services TOTAL 4,046 15,329 11,853 8,000 5,067 9,500
xxxx =xxx= == xxcxxxx xxxx =xxx axxxx =xxs xxxxxxxxx xxxxxxx ==
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 8
2001 BUDGET
2000 2001
abject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
: xxaaaxxxaxaaaaaaaaaaaaacaxsxsaxxsx xaaasaaxxxxxxa aaxaxaax xxsxsa aaaaaaaaaaaaaa aaaaaaaaxaasax axaaasaaaaaaaa xas aaaaaaaaaaa
:320 Communications 0 644 0 0 0 0
:321 Postage 3,422 4,800 2,280 3,600 2,533 4,200
:322 Telephone Services 13,995 16,391 18,632 18,000 11,683 18,000
:324 Delivery Service 288 215 62 125 124 200
:334 Use of Personal Auto 1,069 1,067 652 700 442 700
:340 Advertising 21,581 19,760 22,961 35,000 15,905 35,000
:341 Employment Advertising 721 1,902 4,538 2,450 3,548 4,500
:345 Advertising - Agency 2,886 0 3,346 6 0 6,000
1347 Trade Show Promotions 4,363 4,555 7,092 5,650 3,086 5,650
:350 Printing 10,643 8,028 12,475 12,000 7,927 13,500
'ommunications TOTAL 58,959 57,361 72,039 83,525 45,248 87,750
xsxsaaasa aaaaaaxaa aaxaaaaaa aaaaaaaax aaxasaxaa aaassaxaa
:379 Lower Level Improvements 5,504 0 0 0 0 0
;380 Repair & Maint Contract 8,393 7,667 8,172 8,930 5,107 8,930
:382 Equipment Repair & Maint 23,708 14,265 33,935 31,000 19,735 31,000
:383 Buildings Repairs 0 0 0 0 672 0
:385 Landscaping Services 0 267 0 0 0 0
390 Rentals 42,1:-7 68,446 155,746 74,000 44,838 74,000
:391 Dewatering Services 45,564 4,079 0 0 0 0
:395 Client Request Rent Chrg 16,372 6,189 5,202 4,100 395 1
,397 Logis Charges 2,683 65 0 0 0 0
1398 Protective Services 205 205 297 0 359 0
• I
II
CITY OF BROO1 -N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 9
2001 BUDGET
2000 2001
eject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
:pair Rental & Maint TOTAL 144,585 101,183 203,352 118,030 71,107 -- 114,930
x xx x x axx x a x x x a = x x a a x x xa a xx a x a x a xxx a s xx x a a x x xx x xa a s ax
00 Other Contractual Service 12,100 13,909 15,741 16,000 13,605 20,000
.01 Credit Card Fees 739 569 818 1,200 1,121 1,700
:02 Uncollectible Checks 2,507 -95 3,649 0 0 0
:03 Cash (Over) and Short -5i -40 -135 0 -1 0
:10 Tuition Reimbursement 0 0 2 0 0 0
:11 Conferences and Schools 3,291 3,078 2,945 5,000 2,146 4,000
112 Meeting Expenses 628 760 461 850 241 850
i13 Dues & Subscriptions 3,643 2,444 3,508 3,850 2,716 3,850
115 Claims Payment 0 0 362 0 0 0
117 Books /Reference Materials 34 263 19 290 0 290
127 Tree Removal Contract 188 0 0 0 0 0
:her Contractual Sery TOTAL 23,073 20,886 27,370 27,190 19,828 30,690
x x x a x x xx x x xxx a aax x a a x x xxx a x xx xxa a s xx x xxa a x x x a a xx x x x a x x
142 Repair & Maint Charges 0 0 208 0 0 0
antral Garage Rentals TOTAL 0 0 208 0 0 0
161 Gen Liability Insurance 5,725 4,232 5,520 5,317 3,874 4,155
162 Property Insurance 2,254 1,415 1,304 1,678 1,094 1,859
163 Machinery Breakdown Ins 456 276 240 324 168 224
zsurance TOTAL 8,435 5,923 7,063 7,319 5,136 6,238
a x x x a a xx x x x x axxxa a a x x ax x x x s a xxxaa a x x x xx x x x a x x a x xx xx x xa
181 Electric Service 61,513 69,546 75,830 79,000 47,522 79,000
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 10
2001 BUDGET
2000 2001
bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
aaaxzzzaaaazzaxxxxzzzzaaaaaxxxzaaz asasazxxaxaaux aazzaaaazaaxax zaaaaaaazsaaxa axaxxazsszaaaz zzzaaaaaaaaaaz aaaazzazzzazzz
482 Gas Service 18,402 11,485 12,888 26,000 10,974 20,000
484 Water Service 1,280 1,095 961 1,825 589 1,100
485 Sanitary Sewer Service 2,377 2,024 1,949 3,016 1,119 1,900
487 Solid Waste Disposal 1,495 1,618 2,197 2,000 1,290 2,000
488 Storm Water Drainage 1,026 987 885 1,160 452 900
tilities TOTAL 86,093 86,755 94,709 113,001 61,947 104,900
zzzzzzzzz aaaazaxax zzaaazaaa aazazaaaa sxzzzazaa aazzzzzaz
�v
530 Other Improvements 0 0 0 2,000 0 0
548 Computer Equipment 0 0 0 6,400 5,262 41,350
550 Furniture & Fixtures 0 0 0 6,000 19,482 0
552 Other Equipment 0 0 0 6,700 0, 26,250
apital Outlays TOTAL 0 0 0 21,100 24,744 67,600
axes a aaa a seas x x xs a xa x z azx s a a s oa a as z z xa as a a z a a x x x a a a as a
611 Interest 13,574 9,917 11,616 14,000 11,046 14,000
ebt Service TOTAL 13,574 9,917 11,616 14,000 11,046 14,000
as axa ass a a z az a zs z s as aaa a s zz a xa z a z z z z a za a z a za a a a a za za z z
841 Merchandise Cost of Sales 78 48 0 0 0 0
842 Food Cost of Sales Guests -299 -1,263 271 500 633 950
844 Food Cost of Sales Events 55 2,754 0 0 652 0
ost of Sales TOTAL -166 1,539 271 500 1,284 950
as z az a z z z aazaz x z z z a zaz z zzzz z zzsxaaaa z z as x a a a a sa a a z zzz z i
920 Depreciation Expense 0 0 36,741 0 0 0
epreciation TOTAL 0 0 36,741 0 0 0,
aaazszazz xxxxxaxxa zzxzzzxxa aaaaazzaa axazzxaaa aazzxxxxs ,
ONVENTION CF'-"TER TOTAL 767,491 781,7= 974,030 1,013,143 598,277 1,106,857
CITY OF BROOi_.._fi CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 11
2001 BUDGET
2000 2001
)ject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
[V CATERING OPERATIONS 656
IL00 Wages Regular Employees 2,847 11,685 18,574 0 11,406 0
,L12 Overtime Regular Employee 299 95 524 0 68 0
L15 Lump Sum Payments 0 0 - 20,948 0 0 0
L30 Wages Part -time Employees 35,201 36,044 66,769 60,976 34,718 63,812
L31 Overtime of Part -time Emp 145 127 ,� 208 0 204 500
L32 Flik Employee Wages 343,276 395,977 759,209 619,993 596,648 671,376
L33 Vacation Pay 0 3,919 9,174 0 0 0
L38 Severance Pay 0 1,365 0 0 0 0
L97 Temporary Services 0 6,792 153,742 128,078 36,003 54,000
ilaries and Wages TOTAL 381,768 456,003 987,252 809,047 679,048 789,688
L42 PERA Coordinated Plan 1,661 2,275 3,228 3,159 2,045 3,331
L43 PERA Police & Fire Plan 34 0 15 0 0 0
L46 FICA 2,909 3,606 5,956 4,665 3,475 4,920
L50 Employee Benefits 0 0 113,355 0 116,116 0
'L51 Health Insurance 103 5,700 3,200 0 0 0
L52 Life Insurance 1 0 0 0 0 0
L53 Dental Insurance 11 0 0 0 0 0
L54 Workers Comp Insurance 429 1,830 2,550 2,305 1,205 1,936
L96 Flik Employee Benefits 81,853 84,770 11,833 118,999 0 134,276
inge Benefits TOTAL 87,002 98,181 140,138 129,128 122 144,463
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 12
2001 BUDGET
2000 2001
)bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
oacce�em =o�maaa�asaa�e�acoaoo =aaa� as3 =soo�a�m�a:o aeeeeeoo�acaaa aeace�s��x�oea �o�aeme.aaesem m�ee000 =ee�eaa enmece�a��xasa
:210 Office Supplies 3,346 2,259 5,372 2,660 1,967 2,660
:213 Kitchen Supplies 0 2,054 8,066 40,012 14,215 20,100
:214 Dining Room Supplies 0 4,018 4,479 0 6,342 4,500
:215 Bar Supplies 0 0 9 0 0 0
:216 China, Glass, Silver 0 2,926 72 8,250 0 10,500
:217 Paper Supplies 0 1,440 10,098 12,266 6,826 12,200
:220 Operating Supplies 70,444 57,433 a 8,110 5,117 1,206 1,200
:223 Cleaning Supplies 0 2,917 13,985 13,280 13,550 14,500
:224 Clothing & Personal Equip 0 89 2,974 0 0 0
225 Shop Supplies 0 0 15 0 28 50
:226 Chemical Products 205 -204 0 0 0 0_
:227 Safety Supplies 0 164 157 180 89 300
.230 Repair & Maint Supplies 275 223 92 0 0 0
231 Equipment Parts 0 87 336 300 639 1,550
233 Building Repair Supplies 575 1,296 825 600 841 1,300
:235 Landscaping Materials 0 0 229 300 0 300
:238 Flowers /Decorations .0 580 526 1,502 0 0
241 Laundry 0 7,175 49,442 44,678 40,332 56,000
.271 Minor Equipment 0 0 200 0 829 1,000
supplies TOTAL 74,844 82,457 104,987 129,145 86,861 126,160
as = = =eozs� v.. � = =��_ o�amaam =a oaaam�aa= aeeem ao �� so =eeaa s� i
310 Professional Services 1,085 0 6,776 0 9,276 O
312 Legal SP -vices 0 6., 8^'^ , 100 0 0 0
CITY OF BROOD. --N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 13
2001 BUDGET
2000 2001
eject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
313 Audit & Financial Service 75 0 0 12,000 0 0
316 Security Services 1,940 3,119 0 0 0 0
1327 Flik DMF Fees 0 0 16,634 0 4,296 5,200
.irchased Services TOTAL 3,100 9,919 23,510 12,000 13,572 5,200
320 Communications 0 0 887 0 332 900
321 Postage 2,941 172 1,917 1,668 1,542 2,100
322 Telephone Services 6,063 6,673 4,561 5,200 2,790 3,842
324 Delivery Service 0 19 659 0 0 0
325 Teleprocessing Services 1,500 2,173 8,966 0 8 12,000
326 Contract Cleaning /Exterminatin 0 279 0 0 0 0
340 Advertising 2,125 6,408 6,824 8,200 5,373 8,200
341 Employment Advertising 655 615 1,626 2,016 829 2,016
346 Advertising - Print 92 0 0 0 0 0
347 Trade Show Promotions 5,508 589 296 0 0 300
148 Catering Promotions 0 3,626 1,354 0 0 0
350 Printing 574 2,527 4,217 800 676 800
hmmunications TOTAL 19,457 23,081 31,308 17,884 19,542 30,158
380 Repair & Maint Contract 5,28'2 3,943 7,715 5,000 5,140 7,800
382 Equipment Repair & Maint 14,954 11,474 10,007 14,000 5,486 10,000
390 Rentals 0 7,880 9,575 3,200 4,652 9,575
393 Equipment Rentals 3,121 1,674 0 0 0 0
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 14
2001 BUDGET
2000 2001
)bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
_ sxssssaaaxsxssssaaaxxxxxxsaasaxsss saaxaasaxxxx:sa ssxaaaaamxzxaz aazaaaxxxmxssa saaaazaaaxxxzx zazxxxxzxxzxsx xsssszzszxsxxa
1395 Client Request Rent Chrg 1,501 170 320 0 0 0
tepair Rental & Maint TOTAL 24,859 25,140 27,617 22,200 15,278 27,375
asax x a x x x z zz¢xz za z a zzx z z x as x a zzzm x zz z z z z zz ssa z zz s ss zxs
1400 Other Contractual Service 124,860 132,343 122,205 140,000 73,762 122,000
1401 Credit Card Fees 4,733 5,520 6,768 5,520 7,384 11,500
1 11402 Uncollectible Checks 5,367 1,066 11,684 0 0 0'
1403 Cash (Over) and Short 2,096 2,340 800 0 -127 0
v°
1411 Conferences and Schools 137 0 54 300 0 780
1412 Meeting Expenses 0 50 64 400 20 400
1413 Dues & Subscriptions 850 276 0 700 51 700
1414 Licenses, Taxes, & Fees 6,322 5,220 6,786 5,200 4,433 7,200
1417 Books /Reference Materials 0 30 0 0 0 0
)ther Contractual Sery TOTAL 144,3b5 146,845 148,360 152,120 85,522 142,580
zzazzzzsz asasxzsza xzxxmsxsz zxzzxxzaa xzxxsxaaa xaxxaaaxa 1
1460 Insurance 0 1,266 4,826 5,000 3,424 5,000
1461 Gen Liability Insurance 8,976 4,772 571 753 2,260 5,910
1462 Property Insurance 1,828 2,976 3,047 3,696 3,045 5,541
1463 Machinery Breakdown Ins 369 581 561 690 436 668
1469 Liquor Liability Ins 543 780 174 0 0 0
Insurance TOTAL 11,716 10,374 9,178 10,139 9,164 17,119
aasaaaa�a saazaaaaa zzxazaaaa aszxxaxsz aaassssxa xsaasssxs
1481 Electric Service 10,917 11,169 14,777 11,000 8,343 14,700
1482 Gas Service 5,324 11,027 10,949 18,500 10,974 18,506
1484 Water Service 241 2 1 %Q., 462 400 589 885
CITY OF BROO,._,N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 15
2001 BUDGET ►
2000 2001
ject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
- -- --
---- ---- - - - - -- - -- - -- -
35 Sanitary Sewer Service 425 346 955 450 1,119 1,680
37 Solid Waste Disposal 6,728 6,830 6,715 8,400 5,773 8,400
38 Storm Water Drainage 186 173 379 200 452 680
ilities TOTAL 23,821 29,754 34,236 38,950 27,250 44,845
a aaaa s s a a a a a a ssaaa = a a a a as as a aaaaaaaa a aaa aaaa s as a a a a a a a
18 Computer Equipment 0 0 0 3,200 3,200 4,000
50 Furniture & Fixtures 0 0 0 21,980 0 5,900
52 Other Equipment 0 0 0 0 17,411 10,000
Dital Outlays TOTAL 0 0 0 25,180 20,611 19,900
a a a a a a a a a s s a a a aaa a s s s s s s s a a a aaaaaaa a a aaaaaaa x a aaa a s s s a
11 Interest 0 172 0 0 0 0
Dt Service TOTAL 0' 172 0 0 0 0
a a a a as a s h s ss a a a a a a aaa s x s aaa s s ass s a s s a s s ass a a a c a c a s c c s a
)0 Inventory Variances 0 0 3,182 0 0 0
21 Liquor Cost of Sales 8,859 11,717 51,764 53,957 41,027 56,300
22 Wine Cost of Sales 15,157 20,902 2,930 0 0 0
23 Beer Cost of Sales 13,240 16,476 4,067 0 0 0
42 Food Cost of Sales Guests 289,171 334,248 480,804 542,798 297,288 627,000
44 Food Cost of Sales Events 0 32 50 0 0 0
st of Sales TOTAL 326,426 383,374 542,798 596,755 338,316 683,300
20 Depreciation Expense 798 6,446 17,127 8,700 18,176 0
21 Amortization Expense 7,750 1,937 8,333 9 6,667 9,999
preciation TOTAL 8,548 8,384 25,461 18,699 24,842 9,999
aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaa aaa aaaaaa
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 16
2001 BUDGET
2000 2001
bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
aaa ¢a ¢ a c s as a aaa a s ¢aaa ¢a a¢ a a a a as as a a s seas a s ¢sea as ¢aaaaaaa as as a s amaaaa a a a as a as a s aaa ¢ a¢a a¢ a¢ a a ¢aa as a a a¢¢ ¢a a a a a a a a a a a c a a a a
ATERING OPERATIONS TOTAL 1,105,905 1,273,683 2,074,844 1,961,247 1,442,847 2,040,787
I
CITY OF BROOi�_.LN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 17
2001 BUDGET
2000 2001
abject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division.Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
-xxx x x x x x x x xx x x x x xs xxxxx xx x xx x x xx x x x xxx x a x x x x xxx x xx xx x xxx xx x x x xxxx xx xxax xx xx xx x xx x xx xxx xxx x x xx x x xxa a x a x x x x x xx x x xx x x x xx
, IV OFFICE RENTALS 657
100 Wages Regular Employees 4,630 2,930 2,672 500 1,347 0
,112 Overtime Regular Employee 38 0 0 0 0 0
130 Wages Part -time Employees 6,466 4,368 4,843 500 2,605 3,850
alaries and Wages TOTAL 11,135 7,298 7,514 1,000 3,951 3,850
a7
142 PERA Coordinated Plan 486 378 389 52 205 199
146 FICA 831 534 556 77 291 295
151 Health Insurance 84 0 0 0 0 0
152 Life Insurance 1 0 0 0 0 0
153 Dental Insurance 10 0 0 0 0 0
154 Workers Comp Insurance 125 279 242 38 104 116
ringe Benefits TOTAL 1,536 1,191 1,187 167 600 610
220 Operating Supplies 2,076 1,269 527 200 68 200
223 Cleaning Supplies 687 447 -500 0 0 0
225 Shop Supplies 6 0 0 0 0 0
230 Repair & Maint Supplies 435 239 32 150 0 150
231 Equipment Parts 88 57 0 0 671 0
233 Building Repair Supplies 1,626 655 638 400 111 0
235 Landscaping Materials 609 288 400• 400 0 0
236 Signs & Striping Material 0 126 30 50 0 50
240 Small Tools 60 148 501 0 0 0
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 18
2001 BUDGET
2000 2001
abject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
a axxc x a x ax z a x ax as z z z a a a z z s a azzz z ax z zs z a xa x z z z s a s xx zzz z z x as a z zz axz z z zaa a xz z zz saa xxz z as a a a a a a x a z x x z a z a a as a a a a a x x x z z z z a as
supplies TOTAL 5,,5F 3,227 1,627 1,200 849 400
zzaaaaxxx sazzzzaax xxzzsaaaa assxxzzzz asxxaxzzz xxxaxxzaa
310 Professional Services 2,273 0 0 0 0 0
312 Legal Services 0 1,853 0 0 0 0
- urchased Services TOTAL 2,273 1,853 0 0 0 0
x a x zzsa sea s x a x x x z s a aaxxzzsz a z s as a s xx z a as x x x z zz a x zzz z a z a
322 Telephone Services 2,099 2,310 0 0 0 0
'ommunications TOTAL 2,099 2,310 0 0 0 0
z x aazaaaa xaaxx x z a a zxz a as s x x a s ssa a ax a z a a a a a a a a z z z z c x= as
380 Repair & Maint Contract 629 292 744 200 154 0
382 Equipment Repair & Maint 2,014 234 1,329 400 409 600
397 Logis Charges 434 0 0 0 0, 0
398 Protective Services 206 206 299 360 360 0
epair Rental & Maint TOTAL 3,283 732 2,372 960 924 600
aaaaaaaxa zzaaaaxxz aaaaxzzzz azaaaxaaa zzxxzzzzz xxxzxxzzz
400 Other Contractual Service 3,839 3,874 3,713 1,500 2,262 3,362
403 Cash (Over) and Short 14 0 0 0 0 0
414 Licenses, Taxes, & Fees 23,423 21,330 9,485 10,000 3,684 4,500
-they Contractual Sery TOTAL 27,276 25,204 13,198 11,500 5,946 7,862
a s xxxxxc x a ax aax x z s zzzaa caa a z zs as s a za az a z z a a a a a z z a a a a= a
461 Gen Liability Insurance. 551 292 118 60 181 402
462 Property Insurance 792 4,287 2,534 3,886 1,464 1,679
463 Machinery Breakdown Ins 160 192 466 466 231 202
nsurance TOTAL 1,503 4,771 3,118 4,412 1,876 2,283'
CITY OF BROOs—.N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 19
2001 BUDGET
2000 2001
eject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 06/31/00 REQUESTED
a a x x x s s s s a a as as a s s a y as a a a as a s s as as s aaa a s as s a as a c sxa as as aaaaass a as as s a a x a s s as a aaa ax x sx xa a as a aaa a s as ass a c x a a a a a s a a a a as a x a
181 Electric Service 4,320 3,809 991 0 4,079 0
1182 Gas Service 971 861 864 1,250 736 1,400
184 Water Service 238 232 143 200 80 160
185 Sanitary Sewer Service 375 335 303 200 129 200
187 Solid Waste Disposal 762 764 1,021 1,025 476 1,025
A lities TOTAL 6,665 6,001 ,� 3,322 2,675 5,500 2,785
a a_ as as x a s s s sassy a s s s s as a as a cca a asaa s c c a s x x s a ss c x xx x c s
MICE RENTALS TOTAL 61,357 52,587 32,338 21,914 19,646 18,390
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 20
2001 BUDGET
2000 2001
bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
s x s s s a s x x ss x s s s s s s s a as x xxss s a� a :a s s s s s saes s s s a a a ax ax sxxxxssssx x x x s s s s x x s s s s s s s a as s xa x x ax s a x xa xxx x x x x x x a x x xs x x x x x x x a x a a
IV INN ON THE FARM 658
100 Wages Regular Employees 61,56 50,797 38,234 41,265 5,571 24,132
112 Overtime Regular Employee 1,902 712 193 0 91 0
130 Wages Part -time Employees 102,407 104,303 107,881 81,725 75,201 94,701
131 Overtime of Part -time Emp 1,177 544 871 0 355 0
133 Vacation Pay 2,927 2,027 5,482 0 0 0
134 Holiday Pay 2,821 1,675 a' 944 0 0 0
135 Sick Leave Pay 3,065 2,058 -1,668 0 0 0
alaries and Wages TOTAL 175,887 162,117 151,937 122,990 81,217 118,833
x s xxxsss s s sss ssss a xx a xxx s xx x x xa ax asx s s s s ss s x x a xx x s a a a a
142 PERA Coordinated Plan 7,716 8,289 7,822 6,371 4,162, 6,156
146 FICA 13,351 12,443 12,196 9,409 6,163 9,091
150 Employee Benefits 5,141 5,299 4,034 4,762 0 5,004
151 Health Insurance 676 0 0 0 0 0
152 Life Insurance 7 0 0 0 0 0
153 Dental Insurance 62 0 0 0 0 0
154 Workers Comp Insurance 943 3,117 2,549 2,029 1,154 1,569
ringe Benefits TOTAL 27,897 29,148 26,601 22,571 11,479 21,820
axxaaxaxx axxaaaxxx xsssxsxxx axxxaaxaa sssxxxaas xaasassaa
210 Office Supplies 344 216 210 250 199 250
220 Operating Supplies 6,523 8,956 6,861 9,000 3,308 8,000
223 Cleaning Supplies 247 497 641 350 570 350,
224 Clothing & Personal Equip 80 0 0 175 69 175
CITY OF BROOi—N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 21
2001 BUDGET
2000 2001
eject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
as a a a a a a a a as a as a a a as a a a aaa a aaa a s a aaa a as aaa aaa a a a a a a a aaaaaaa _ aaa a aaa aaaasas a aaaaaaaa aaac as saa aaaaaaaaoaa a a a c as a a a a a a a a
25 Shop Supplies 7 0 0 0 0 0
:26 Chemical Products 0 0 202 175 181 200
27 Safety Supplies 274 157 316 210 159 210
28 Guest Supplies 1,114 2,386 1,471 2,100 166 2,100
30 Repair & Maint Supplies 1,205 681 77 800 302 800
31 Equipment Parts 85 0 v� 164 175 20 175
33 Building Repair Supplies 2,565 2,193 220 2,500 947 2,500
:35 Landscaping Materials 617 276 420 400 930 400
:36 Signs & Striping Material 48 0 0 100 0 100
40 Small Tools 98' 122 29 100 0 100
;41 Laundry 1,023 893 825 875 608 875
:71 Minor Equipment 0 0 0 0 895 0
ipplies TOTAL 14,230 16,378 11,436 17,210 8,353 16,235
aaaaaaaa a aaaaaaaa a aaa a .aaa a a aaac a s as a aaaaaaa a a aaaaaaa a
.16 Security Services 0 0 0 0 122 0
trchased Services TOTAL 0 0 0 0 122 0
aaa a as a s a a aaaaaaa a aaa a a a c as aaaaaaaa a as a a a aaa a a aaaaa a a c
,20 Communications 0 473 0 0 0 0
,21 Postage 1,173 929 213 525 146 350
t22 Telephone Services 6,623 7,479 4,784 6,500 3,222 5
t24 Delivery Service 0 34 0 50 0 50
t34 Use of Personal Auto 99 137 0 125 0 50
140 Advertising 3,967 5,303 2,960 5,500 2,162 3,500
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 22
2001 BUDGET
2000 2001
bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
xxxxaaaaaxaaxxmxxxxxxxxaaasaaamxam xxxxxmmaxxxmxx saxaaaamaaaaaa aaxxxxxxmxmxaa xaaxaaaaaaaaaa aax¢xmxxmxxxmx xaxxxxmmmaxxax
341 Employment Advertising 181 1,224 1,719 1,500 1,787 2,000
347 Trade Show Promotions 0 221 0 300 0 300
349 Inn room booking commissions 0 0 36 0 36 100
350 Printing 1,77 2,847 2,806 2,250 2,008 3,000
ommunications TOTAL 13,816 18,648 12,519 16,750 9,361 14,350
a x a axa a xx m ma a a¢ a a a x x x m a m x¢ x a xm ax x x x x xx axx xx a s m mam a a a a a
380 Repair & Maint Contract 2,334 1,747 1,543 2,500 396 2,000
382 Equipment Repair & Maint 7,329 5,558 3,387 5,500 3,130 5,000
390 Rentals 30 612 930 900 0 500
397 Logis Charges 1,066 0 0 0 0 0
398 Protective Services 205 205 297 180 359, 0
epair Rental & Maint TOTAL 10,964 8,122 6,157 9,080 3,885 7,500
aaxaa a s s es a¢a :a m a xa a x xx x a xm m a m a a¢ a a x a a as a a x s x x
aaxxxxxxx
400 Other Contractual Service 4,867 4,881 5,565 5,000 5,037 6,000
401 Credit Card Fees 5,699 4,678 3,169 4,800 2,021 3,800
402 Uncollectible Checks 11 -134 557 0 0 0
403 Cash (Over) and Short 90 -91 102 0 -52 0
404 Collection Fees 25 0 0 0 0 0
411 Conferences and Schools 230 99 150_ 450 0 450
412 Meeting Expenses 35 51 0 100 0 0
413 Dues & Subscriptions 613 827 761 650 444 650
414 Licenses, Taxes, & Fees 15,595 14,022 13,869 14,400 7,419 11,500
417 Books /Reference Materials 0 30 0 0 0 0
CITY OF BROO, -.LN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 23
2001 BUDGET
2000 2001
)ject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
. aaaaaxxxxxxsaaaaaaxxxxxxaxaaaxxaa xxaCxxaxxxxxxx oaaxxaasaxxxxx xaxxaxxxxxxxxx aamaaxxxxsxxxx xxxxxxmxxxxxxx cxaxxx= xxx¢o.x
:her Contractual Sery TOTAL 27,165 24,361 24,173 25,400 14,868 22,400
• xx x xxxxxx a a C x x x x x x x x x x xx �xa xx xxa xx x x x xa a s ax x m a xx xx m ax s
:61 Gen Liability Insurance 2,212 1,420 684 1,267 665 1,216
:62 Property Insurance 971 1,659 1,991 2,348 1,629 2,639
:63 Machinery Breakdown Ins 196 213 367 389 240 318
isurance TOTAL 3,379 3,292 3,041 4,004 2,534 4,173
a= a a x as . x x x c x a a a a a ' , xxxx xx xx x a a a aaaa as s e c a s a xa s a x x x x x c x x
181 Electric Service 7,424 7,281 9,863 9,000 7,494 12,000
182 Gas Service 5,761 4,531 4,755 6,000 4,143 6,500
184 Water Service 696 578 591 700 353 600
185 Sanitary Sewer Service 1,222 1,099 1,136 1,200 648 1,200
187 Solid Waste Disposal 963 828 1,067 1 684 1,000
,ilities TOTAL 16,066 14,317 17,411 17,900 13,322 21,300
i20 Buildings 0 0 0 0 0 50,000
i50 Furniture & Fixtures . 0 0 0 0 0 5,950
ipital Outlays TOTAL 0 0 0 0 0 55,950
as a s xx x x x as a s aaaaa s aaxa x x a x a a a a as s a a a as a a a a a ex as c x x a a a a
ill Interest 13,574 9,917 11,616 9,700 11,458 9,700
Bbt Service TOTAL 13,574 9,917 11,616 9,700 11,458 9,700
xxx x x xxx x. x xx xx xx xx s x x x x x x x a a s x x= x xx x a a x x x as a s a ax x x x a a x
321 Liquor Cost of Sales 0 13 0 0 0 0
322 Wine Cost of Sales 0 248 0 0 0 0
341 Merchandise Cost of Sales 626 624 957 800 0 800
342 Food Cost of Sales Guests 18,200 16,531 14,978 16,500 7,025 12,500
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 24
2001 BUDGET
2000 2001
bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
mass =s .=sass saaams a aas = as m =sm.a= am as. a == s= amm m======== a m m s s as a==-===
844 Food Cost of Sales Events 0 4 0 0 0 0
ost of Sales TOTAL 18,826 17,421 15,936 17,300 7,025 13,300
asss.assx assss.asa assxxaaaa .asaa..aa ssa.aasas ssxx.asss
920 Depreciation Expense 0 0 3,629 0 0 0
epreciation TOTAL 0 0 3,629 0 0 0
m..asmaaa sax =sss.. sma. =aaaa assaaaaaa ssam..ass sxa. =ass.
NN ON THE FARM TOTAL 321,803 303,720 284,457 262,905 163,624 305,561
a °
I
I
CITY OF BROOK -,N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 25
2001 BUDGET
I
2000 2001
ject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
J EARLES RESTAURANT 659
)0 Wages Regular Employees' 47 0 0 0 0 0
30 Wages Part -time Employees 1,265 27 0 0 0 0
32 Flik Employee Wages 18,805 11,863 0 0 0 0
i
laries and Wages TOTAL 20,118 11,890 0 0 0 0
xxx xx xxxx x x x xxx x x x x x x x x x x x x x x x xx xx ax -x x x x x x x x x x x x xx x x x
32 PERA Coordinated Plan 5^ 1 0 0 0 0
46 FICA 100 2 0 0 0 0
51 Health Insurance 86 0 0 0 0 0
52 Life Insurance 1 0 0 0 0 0
53 Dental Insurance 0 0 0 0 0
I
54 Workers Comp Insurance 6 0 0 0 0 0
)6 Flik Employee Benefits 3,194 2,017 0 0 0 0
Inge Benefits TOTAL 3,454 2,021 0 0 0 0
20 Operating Supplies 1,530 155 0 0 0 0
23 Cleaning Supplies 518 61 0 0 0 0
124 Clothing & Personal Equip 80 68 0 0 0 0
I ?plies TOTAL 2,127 284 0 0 0 0
21 Postage 114 0 0 0 0 0
22 Telephone Services 933 490 0 0 0 0
30 Transportation 41 0 0 0 0 0
40 Advertising 1,908 1,034 0 0 0 0
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 26
2001 BUDGET
2000 2001
3ject Code & Description. 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
e e s s v m a s m s s m am a s a a ss ss s a s s sssa s sa x ammsssms zaa s s s x x ssss s s s zs s m a aaaaa as ssxs x x s sss maaax sax s xs s a s as a a s sx s sa a_ s x s x x s s as s x s a s
350 Printing 722 387 0 0 0 0
mmunications TOTAL 3,718 1,911 0 0 0 0
smszm assn xxsxmssss sxsss ssxa xmxsssssm mssss ssss saasxxssa
380 Repair & Maint Contract 141 70 0 0 0 0
390 Rentals 1,096 493 0 0 0 0
,;pair Rental & Maint TOTAL 1,23E 563 0 0 0 0
masassazs assssaaas xxxssxsaa xxssssaaa maasxssss xxmsasmsa
114 Licenses, Taxes, & Fees 330 0 a 0 0 0 0
:her Contractual Sery TOTAL 330 0 0 0 0 0
assaaxsxs axssxxxaa aasxaasaa sssmsaaas ssxsssasx aaxxxsasx
161 Gen Liability Insurance 10 144 0 0 0 0
isurance TOTAL 109 144 0 0 0 0
mxxxsmxam saaxasxxx aaasxsxxs sssaasaxm sss =assxm ssssxxsxx
121 Liquor Cost of Sales 5,647 2,462 0 0 0 0
142 Food Cost of Sales Guests 12,539 .5,832 0 0 0 0
)st of Sales TOTAL 18,186 8,294 0 0 0 0
s a a x x s x s s x x x s s s a s a s x ssms s s x as x s s sa as s .s sa a c x s ssa a s xx x s
MLES RESTAURANT TOTAL 49,278 25,107 0 0 0 0
I
- I
. I
CITY OF BROOD.. _N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 27
2001 BUDGET
2000 2001
eject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
aaaxxxxxaaaaaaaaaaaaaaaax= aaaaaaa maaaaaaaaaaaaa aaaaaxaxxxxxa_ _aa___x_xxxa =� a��_____�a__aa aaxaxxxxxxaxax aaxxxxx sxxacxa
V EBHC ADMINISTRATION 660
00 Wages Regular Employees 87,20.6 87,253 96,176 114,535 67,029 122,193
1 12 Overtime Regular Employee 77 75 19 0 0 0
30 Wages Part -time Employees 13,027 15,011 16,057 17,114 4,811 5,500
33 Vacation Pay 5,513 4,698 5,511 0 3,546 0
i
34 Holiday Pay 4,213 4,907 a 5,049 0 2,383 0
35 Sick Leave Pay 4,492 5,027 4,531 0 2,316 0
laries and Wages TOTAL 114,528 116,973 127,343 131,649 80,086 127,693
" a a a a xx a c x a s axa a a a a a a a a as a as as a a a as as a a a a xa a a a a a x x a ax xa
42 PERA Coordinated Plan 4,868 6,060 6,512 6,819 4,148 6,614
46 FICA 8,697 9,063 9,576 10,071 6,108 9,769
50 Employee Benefits 6,831 9,220 11,393 14,286 8,346 15,012
51 Health Insurance 1,531 0 0 0 0 0
52 Life Insurance 10 0 0 0 0 0
53 Dental Insurance 165 15 0 0 0 0
54 Workers Comp Insurance 174 703 635 795 337 624
58 Disability Insurance 257 257 320 339 227 0
inge Benefits TOTAL 22,53 5 25,319 28,437 32,310 19,166 32,019
20 Operating Supplies 0 0 364 300 41 0
23 Cleaning Supplies 0 0 501 250 0 0
24 Clothing & Personal Equip 0 0 0 100 0 0
25 Shop Supplies 0 0 0 100 0 0
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 28
2001 BUDGET
2000 2001
oject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
c o x s s a s s s s s x xxxa s as ss s x xx x x x as a as a x s vxa a s as a s xp s x s ssxaxa xsaxaa x sx s x xax a x a as x a aaa x sa x a x xxx a a s xx a x xx xxx xaa x x x x x x x x xx x x xx
226 Chemical Products •0 0 0 100 0 0
227 Safety Supplies 0 0 0 50 0 0
230 Repair & Maint Supplies 0 0 0 350 0 0
231 Equipment Parts 0 0 0 100 0 0
233 Building Repair Supplies 0 0 0 300 0 0
235 Landscaping Materials 0 0 0 500 0 0
236 Signs & Striping Material 0 0 �° 0 200 0 0
240 Small Tools +'> 0 0 50 0 0
.applies TOTAL 0 0 864 2,400 41 0
axxxaxxaa xxsxaxxxa axaaaxaaa xaxaxaxax aaasxsxxx aasxaxaxs I
310 Professional Services 0 0 70 0 01 0
312 Legal Services 0 0 435 0 1,628 2,200
313 Audit & Financial Service 2,128 2,200 2,250 2,730 2,678 2,783
archased Services TOTAL 2,128 2,200 2,755 2,730 4,305 4,983
x x as s s xxx aasaas a a a s a s s as aaa xxaxx xs s s axs x x s s a x s a x es ax x x a II
350 Printing 0 0 0 0 8 0
Dmmunications TOTAL 0 0 0 0 8 0
s a xs x a s x s a a s aas a a a s s s a s s as a ssss ass sa sss a as a a x a x x a x s s s x i
397 Logis Charges 0 6,613 15,104 18,344 16,659 23,856
:pair Rental & Maint TOTAL 0 6,613 15,104 18,344 16,659 23,856
sn aaa a as x x x x x x x x x x x x x a xx x x a a a a axisp a x a a x sa aax s xs x x a a a x I,
103 Cash (Over) and Short 0 0 902 0 0 0
k11 Conferences and Schools 0 0 0 1,800 0 4,500,
I
114 Licenses, Taxes, & Fees 0 0 11,919 0 0 0
I
CITY OF BROOD,. -9 CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 29
2001 BUDGET
2000 2001
ject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
her Contractual Sery TOTAL 0 0 12,822 1,800 0 4,500
61 Gen Liability Insurance 0 0 526 845 573 1,117
62 Property Insurance 0 0 3,546 5,616 2,296 2,927
63 Machinery Breakdown Ins 0 0 653 1,026 349 353
surance TOTAL 0 0 4,725 7,487 3,218 4,397
81 Electric Service 0 0 0 2,500 0 0
B4 Water Service - 0 0 0 200 0 0
85 Sanitary Sewer Service 0 0 0 250 0 0
87 Solid Waste Disposal 0 0 0 500 0 0
ilities TOTAL 0 0 0 3,450 0 0
50 Furniture & Fixtures 0-, 0 0 2,250 0 2,250
pital Outlays TOTAL 0 0 0 2,250 0 2,250
11 Interest 0 0 0 0 961 0
of Service TOTAL 0 0 0 0 961 0
D2 Administrative Sery Trans 52,797 62,767 58,548 55,443 36,963 59,035
ninistrative Service TOTAL 52,79 62,767 58,548 55,443 36,963 59,035
IC ADMINISTRATION TOTAL 191,988 213,871 250,597 257,863 161,406 258,733
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 30
2001 BUDGET
2000 2001
bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 08/31/00 REQUESTED
IV UNDEFINED 999
399 Contractual Reimbursed 0 0 4,357 0 0 0
epair Rental & Maint TOTAL 0 0 4,357 0 0 0
920 Depreciation Expense 378,615 346,206 318,712 0 0 0
3preciation TOTAL 378,615 346,206 318,712 0 0 0
MEFINED TOTAL 378,615 346,206 v ° 323,069 0 0 0
4RLE BROWN HERITAGE CTR TOTAL 2,876,438 2,996,927 3,939,335 3,517,072 2,385,800 3,730,328
Division: Convention Center
Budget Code: 655
Program Number: 5950
PROFILE:
The Convention Center in conjunction with the Catering Department provides a full service conference and event
location. EBHC's economic impact directly affects Brooklyn Center via hotel, restaurant, shopping and convention
service related business activity (floral, printing, rental, etc,.). EBHC provides a high level of customer service and
maintains a significant amount of repeat business among its corporate clientele.
DEPARTMENTAL GOALS:
• Focus marketing endeavors on large, multi-day events that will minimiz labor, maximize food and beverage
revenue potential and increase city lodger's tax receipts. .
• Promote websites (www.earlebrown.com and www.innonthefann.com) thereby allowing the staff to react to
requests for information faster and less expensive than mailing printed materials.
• Participate in trade show opportunities to inform the public of EBHC's presence and renovation.
• Aggressively sell food and beverage events that shows the highest profit margin.
• Add minimum of ten new corporate clients per year.
• Provide food and beverage service rivaling the premier Twin City event facilities.
ry
• Participate in industry associations to network for referral business from our industry peers.
• In conjunction with the North Metro Minneapolis Convention and Visitors Bureau, host association meetings
on -site such as MSAE, MPI and SGMP.
PERSONNEL LEVELS:
1 Sales Director
3 Sales Manager
1 - Maintenance/Operations Supervisor
1 Maintenance Custodian
2 Crew Chief
Part-time positions include Set -Up Crew, Custodians, and Maintenance Staff.
SPECIFIC CODE EXPENDITURE DETAIL
Obiect Number ExDlanation Amount
4400 Increased snow removal costs due to additional $ 20,100
parking area.
4411 IAAM National Meeting, IAAM District 111 $ 4,000
meeting in St. Paul
CAPITAL OUTLAY — A LIST _
Item Anticipated Units Cost Use se i Need
Purchase Date
Shades for Carriage Hall 1/01 2 $9,000 Replacement of "black out"
and Captain's windows. shades for large windows in
Carriage Hall and Captain's.
Lazar Jet Printer First Quarter 2001. 1 $800 Replacement of Billing Clerk
printer.
Computers First Quarter 2001 3 $6,000 Replacements of computers
because of inefficiency.
SQL Server 2000 1/01 1 $11,800 Replaces Access as support
for Hodges reservation and
catering system
Intel 330T Hub 1/01 1 $750 Replace aging 10 mg hub
with hub capacity of 100 mq
Outdoor Sound System 1/01 1 $1,550 Amplification for outdoor
ceremonies and events
Two way Radios 4/01 4 $3,200 Replacement of old radios
and use as rental item
Wde Area Vacuum 6 \01 1 $1,700 Replacement of old
equipment.
Security video system in 6/01 1 $8,000 Allow us to monitor what's
storage area, dock area- going out the door because
and employee entrance. of theft.
Cisco 2620 Single First Quarter 2001 2 each $7,100 Replacement of eight year
Ethernet 10/100 with old bridge equipment
IP /lPX Software and between City Hall & EBHC
Serial Wics
Data and Voice Cabling First Quarter 2001 $15,700 Replacement of existing
cable not meeting network
specifications
TOTAL $65,600 '
CAPITAL OUTLAY — B LIST
Blackout Covers for West 2 $10,000 Replacement of non -
Doors in Carriage Hall repairable blackout panels
Oval Tables
30 $4,300 Equipment needed for H and
Table Carts 3 G Barn function space
Acton Stacker Chairs and 100 $16,750 Replacement of broken
Chair Dollies 5 chairs and additional chairs
for H and & Bam space
Large Fountain Liner 1 $7,500 Liner for large fountain in the
courtyard
Water Heater 1 $4,000 Replacement of ten -year old
equipment
Total $42.550
f -.usersr bergeland /budget/capoutoverview.doc
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Div. # 655 Object #: 4552
2. Give description and quantity of item requested. Indicate date desired.
Replacement of "black out" shades on large in both Carriage Hall
And Captain's
3. Describe the necessity for and /or benefits or savings expected from this item.
Audio visual productions require covering all exterior light sources. The
existing screens are ten years old, have been repaired several times, and the motor is
going out on the Carriage Hall screen.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.'•
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
May require additional electrical =.i Carriage Hall. General budget will cover expense.
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
Discard
7. . Estimated Net Cost: $ 9,000
Quantity Unit Cost Total Cost Trade -in Net Total Cost
2 $4,500 $9,000 $0 $9,000
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Div. # 655 Object #: 4548
2. Give description and quantity of item requested. Indicate date desired.
One lazer jet printer purchased first quarter 2001.
3. Describe the necessity for and /or benefits or savings expected from this item.
This printer will replace an old lazer jet currently in the billing clerk's office where
there is heavy printing demand of invoices and correspondence. The printer
being replaced will go to the General Manager's office.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A =
- 6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
Existing printer being moved to the General Manager's office.
7. Estimated Net Cost: $ 800
Quantity Unit Cost Total Cost Trade -in Net Total Cost
1 $800 $800 $0 $800
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL-OUTLAYS REQUESTS
1. Division: Earle Brown Heritage Center Div. 055/656 Object #4548
2. Give description and quantity of item requested. Indicate date desired.
Five (5) Desktop Computer Workstations
2nd Quarter, 2001
3. Describe the necessity for and /or benefits or savings expected from this item.
Hodges & Irvine Technologies, provider of ESP2000 software (Sales and
Catering System), recommends for optimal performance the minimum computer
workstation be a Pentium 11 400 MHz with a 128MB of RAM. The computers
requested for replacement are below the recommended configuration.
The following computers would be replaced:
Two (2) Pentium 233 with 32MB of RAM
Three (3) Pentium 266 with ' 28MB of RAM
4. If the item requires an increase in personal services for the activity, state the job
titles contingent upon the item.
Information Technology Coordinator to configure and install.
5. Indicate any expenses necessary to place this item in operation and whether
these expenses are included in your budget request.
None.
6. List any item which will be replaced by this purchase. State recommendations
for disposition of this item. For example, trade -in salvage, discard, etc.
One (1) computer would replace the Inn computer, which is a Pentium 75. The
other four computers would be placed in City inventory, replacing older
computers.
7. Estimated Net Cost: $10.000
Quantity Unit Cost Total Cost Trade -in Net Total
Cost
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: - Earle Brown Heritage Center Div. #655 Object # 4548
2. Give description and quantity of item requested. Indicate date desired.
One (1) HP Netserver LC2000 running Microsoft NT and SQL Server 2000
(Current Model - Model Number May Change)
I" Quarter, 2001
3. Describe the necessity for and /or benefits or savings � utngs expected from this item.
Earle Brown Heritage Center currently uses ESP2000 software (Sales and
Catering System) provided by Hodges & Irvine Technologies. This software was
installed in January 1998: At the time of the installation, it was recommended
that the Heritage Center use the Microsoft Access version of ESP2000. The MS
Access version is designed for less than five (5) concurrent users /workstations.
At most times the Heritage Center has between 10 -14 concurrent users utilizing
the ESP2000 software. Users experience significantly slow performance of the
software. Oftentimes users have to take 2 -3 times the amount of time to enter
information. This affects the sales personnel's ability to provide acceptable
customer sg.rvice.. Most times
sales personnel cannot conduct business
er calls and over the
phone. For example, a customer to look a
t
dates for.
an event.
The sales personnel has to write down the dates the
client is interested '
d m .check
the ESP2000 software, and call them back, oftentimes playing "telephone tag".
Sales personnel should be able to handle this client request on the initial
telephone conversation. Because of errors associated wit current software
configuration, most users have to re -boot their computers 3 -6 times a day.
The recommendation from Hodges & Irvine Technologies is to move to the
Microsoft SQL Server version of ESP2000. The costs associated with this would
be the purchase of a NT Server running MS SQL Server. LOGIS would assist'
the Information Technology Coordinator with the hardware set -up. Hodges &
Irvine Technologies support would move the MS Access database to the NT
server converting the data to MS SQL Server. There would be no additional cost
from Hodges & Irvine Technologies.
4. If the item requires an increase in personal services for the activity, state the job
titles contingent upon the item.
- Information Technology Coordinator oordinator to work
with LOGIS an
Technologies to configure and install. d Hodges &Irvine
5. Indicate any expenses necessary to place this item in operation and whether
these expenses are included in your budget request.
LOGIS support of 20 hours for configuration and installation. Budgeted as part
of request.
6. List any item which will be replaced by this purchase. State recommendations
for disposition of this item. For example, trade -in
P � salvage, discs
9 , rd, etc.
N/A
7. Estimated Net Cost: $1' .800
Quantity Unit Cost - Total Cost Trade -in Net Total Cost
Server
$10.400 $10.400 $0 $10.400
Hardware/Software
LOGIS Support $1.400 $1.400 N/A $1.400
20. Hours -
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
I. Division: Earle Brown Heritage Center Div. #655 Object # 4548
2. Give description and quantity of item requested. Indicate date desired.
One (1) Intel 330T Hub
(Current Model - Model Numbers May Change)
1 81 Quarter, 2001
3. Describe the necessity for and /or benefits or savings expected this item.
To replace the 10MB Hub at the Earle Brown Heritage Center. The current Hub
is between seven and nine years old. The Hub speed would increase to 100MB.
4. If the item requires an increase in personal services for the activity, state the job.
titles contingent upon the item.
Information Technology Coordinator to work with LOGIS to configure and install.
5. Indicate any expenses necessary to place this item in operation and whether
these expenses are included in your budget request.
LOGIS support of two hours for configuration and installation. Budgeted as part
of request.
6. List any item which will be replaced by this purchase. State recommendations
for disposition of this item. For example; trade -in salvage, discard, etc.
Discard Intel 10MB Hub.
7. Estimated Net Cost: 890
Quantity Unit Cost Total Cost Trade -in Net Total Cost
1 $ 750 $ 750 $0 $ 750
Hub
LOGIS SuDoort 140 140 N/A 140
2 Hours
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Div. # 655 _ Object #: 4552
2. Give description and quantity of item requested. Indicate date desired.
One outdoor sound system (mixer, speakeres and stands) including:
1 mixer @ $495
2 speakers @ $235
2 speaker stands @ $85
3. Describe the necessity for and /or benefits or savings expected from this item.
Rented to clients, particularly weddings, to amplify sound during wedding ceremonies
Or any other outdoor event requiring amplification. Rentals will cover cost of system
Within six months and then becomes a source of revenue.
P
O
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation. and-whether these
expenses are included in your budget request.
N/A
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
7. Estimated Net Cost: $ 1,550
Quantity Unit Cost Total Cost Trade -in Net Total. Cost
See above See above $1550 $0 $1,550
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Div. # 655. Object #: 4552
2. Give description and quantity of item requested. Indicate date desired.
Two way communication portable radios. Purchase April 2001
3. Describe the necessity for and /or benefits or savings expected from this item.
Replacement of old, worn -out radios. Will use as rental to client also.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
n
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
6. List any item which will be replaced by this purcha: Su►te a cco,:rmendai.ions for
disposition of this item. For example, trade -in salvage, discard, etc.
N/A
7. Estimated Net Cost: $ 3,200
Quantity Unit Cost Total Cost Trade -in Net Total Cost
4 $800 $3,200 $0 $3,200
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC
Div. # 655 Object /#: 4552
2. Give description -and quantity of item requested. Indicate date desired.
One wide area vacuum. Purchase June 2001
3. Describe the necessity for and /or benefits or savings expected from this item.
Replacement for existing older worn out vacuum.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
'
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
6.. List any item which will be replaced by :pis- purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
Possible trade -in, or salvage for parts.
7. Estimated Net
Cost: $ 1,700
Quantity Unit Cost Total Cost Trade -in Net Total Cost
1 $1,700 $1,700 $0 $1,700
. r
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: ERHC Div. # 655. Object #: 4552
2. Give description and quantity of item requested. Indicate date desired.
Put a security video system in storage areas and employee entrance and dock areas.
-
3. Describe the necessity for and /or benefits or savings expected from this item.
Theft of audiovisual equipment, carts, other vendor's equipment, etc. is occurring
more frequently the busier the facility is. This system will deter some of the
temptation and allow us to trace what's going out the door.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
Electrical connection included --n the projected -cost: - -
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
7. Estimated Net Cost: $ 8,000
Quantity Unit Cost Total Cost Trade -in Net Total Cost
1 $7,748 $7,748 $0 $7,748
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: Earle Brown Heritage Center Div. # 655 Object # 4548
2. Give description and quantity of item requested. Indicate date desired.
Two (2) Cisco 2620 Single Ethernet 10/100 with IP /IPX Software and Two '(2)
Serial Wics (Current Model - Model Number May Change)
1 Quarter, 2001
3. Describe the necessity for and /or benefits or savings expected from this item.
City Hall and Earle Brown Heritage Center are linked by a T1 data line
connection. Hardware that currently allows this communication is called a
Bridge. A "Bridge" is located at both ends, one at City Hall, the other at the
Heritage Center.
ID
The Bridge equipment is over eight years old. Bridge technology is considered
obsolete and is being replaced by router technology.
4. If the item requires an increase in personal services for the activity, state the job
titles contingent upon the item.
Information Technology Coordinator to work with LOGIS to configure and install.
5. Indicate any expenses necessary to place this item in operation and whether
these expenses are included in your budget request.
LOGIS support of 10 hours for configuration and installation. Budgeted as part
of request.
6. List any item which will be replaced by this purchase. State recommendations
for disposition of this item. For example, trade -in salvage, discard, etc.
Discard HP 28674A Remote Bridge.
7. Estimated Net Cost: $7
Quantity Unit Cost Total Cost Trade -in Net Total Cost
2 $ 3.200 $ 6.400 $0 $ 6,400
LOGIS Su000rt 700 700 N/A 700
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: Earle Brown Heritage Center Div. # 655 Object # 4548
2. Give description and quantity of item requested. Indicate date desired.
Data and Voice Cabling for all Office Locations
1st Quarter, 2001
3. Describe the necessity for and /or benefits or savings expected from this item.
Much of the data and voice cabling is between eight and ten years old. The data
cabling does not meet network specifications. The Heritage Center has
experienced down time due to cabling related issues. The'infrastructure of the
network is in need of re- design. Network equipment is in several locations,
causing network management, performance, and security problems. The re-
design would put all network equipment in one secure location. Users will see a
better performing network.
4.• - If the item requires an increase in personal services for the activity, state the job
titles contingent upon the item.
Information Technology Coordinator to work with LOGIS and vendor in
designing, configuring and installing data and voice cabling in all office locations.
5. indicate any expenses necessary to place this item in operation and whether
these expenses are included in your budget request.
LOGIS support of 10 hours for configuring, moving, and installing network
equipment (servers, hubs, switches, and routers). Budgeted as part of request.
6. List any item which will be replaced by this purchase. State recommendations
for disposition of this item. For example, trade -in salvage, discard, etc.
Old cabling to be removed. Included.
7. Estimated Net Costr $15.700
Quantity Unit Cost Total Cost Trade -in Net Total Cost
Cablina $ 15.000 $ 15.000 $0 $ 15.000
LOGIS SuDoort 700 700 N/A 700
4n U^tire
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPI'T'AL OUTLAYS REQUESTS
1. Division: EBHC Div. # 655 Object #: 4552
2. Give description and quantity of item requested. Indicate date desired.
Blackout covers for West doors (2) in Carriage Hall.
3. Describe the necessity for and /or benefits or savings expected from this item.
Replacement of old, worn-out blackout panels. Original system will no longer
support itself as originally constructed. Is becoming dangerous to install and is
no longer repairable.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
6. List any item which will replaced by this purchase. State recommendations for
disposition -
of this item. For example, p e, trade in salvage, discard, etc.
Discard
7. Estimated Net Cost: $ 10,000
Quantity Unit Cost Total Cost Trade -in Net Total Cost
2 $5,000 $10,000 $0 $10,000
' I
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Div. # 655 Object #: 4550
2. Give description and quantity of item requested. Indicate date desired.
30 oval tables and three storage /transport carts.
3. Describe the necessity for and /or benefits or savings expected from this item.
Due to additional meeting space and breakage of some original tables, we are in need
of purchasing more tables. These will be flat storage, same top color but will store
on carts, ten to a cart for easy moving/handling.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item
n
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
N/A
7. Estimated Net Cost: $ 4,300
Quantity Unit Cost Total Cost Trade -in Net Total Cost
30 ovals $100 $3,000 $0
3 carts $200 $ 600 $0 $4,300
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Div. # 655 Object #: 4550
2. Give description and quantity of item requested. Indicate date desired.
100 Acton stacker chairs and 5 chair dollies
3. Describe the necessity for and /or benefits or savings expected from this item.
Due to additional meeting space and breakage of some original chairs, we are in need
of purchasing more chairs.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A %
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
'6. List. any item which will bti replaced.by- ..this. purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
N/A
7. Estimated Net Cost: $ 16,750
Quantity Unit Cost Total Cost Trade -in Net Total Cost
100 $140 $14,000 $0
5 $100 $ 500 $16,750
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Div. # 655 Object #: 4552
2. Give description and quantity of item requested. Indicate date desired.
Liner for bottom of large outdoor fountain.
3. Describe the necessity for and /or benefits or savings expected from this item.
On a yearly basis we've been spending approximately $1,600 for a rubberized sealer
that is painted on, but peals off and have to be reapplied yearly. Labor for the work
Is in addition to dollars noted. This new liner should last about ten years.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item;
a
N/A -
5.
.Indicate any expenses necessary to place this item in operation and whether these
expenses are included in our budget request.
Y g qu
N/A
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
N/A
7. Estimated Net Cost: $ 7,500
Quantity Unit Cost Total Cost Trade -in Net Total Cost
1 $7,500 $7,500 $0 $7,500
5 $100 $ 500 $16,750
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Div. # 655 Object #: 4552
2. Give description and quantity of item requested. Indicate date desired.
100 Gallon, 2,000 BTU Water Heater
3. Describe the necessity for and /or benefits or savings expected from this item.
Replacement of ten year old existing water heater.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.,
3
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
'N /A
7. Estimated Net Cost: $ 4,000
Quantity Unit Cost Total Cost Trade -in Net Total Cost
1 $4,000 $ 4,000 $0 $4,000
5 $100 $ 500
$16,750
CITY OF BROOKLYN CENTER
2001 BUDGET
REQUEST FOR A CHANGE IN JOB CLASSIFICATION
1. Division Name: Earle Brown Heritage Center
2. Division Number: 655
3. Position Title:
From Maintenance Supervisor _ To: Operations Manager
4. Pay Grade
From: C20G To: C25D
5. Salary or Wage Range:
From: Step A: $3,454 Step G. $4,203
To: Step A: $3,908 Step G: $4,756
6. 1 st Year Cost: $ 2 1 556 plus applicable benefit increases
7. Indicate Need for Positions)
( x) Market Rate Increases ( x) Increased Skill Levels or Responsibilities
8. List below the job duties to be performed in the requested position(s).
Supervises cleaning and maintenance of EBHC, sets priorities for all related
duties (eleven buildings on eleven acres)
Responsible for scheduling and supervision of maintenance and conference
services staff
Responsible for maintenance of complete heating and cooling systems for
eleven buildings
Supervises control of courtyard fountain mechanical systems
Purchases all supplies for maintenance and cleaning of buildings and
grounds
Scheduled preventive maintenance on building equipment and facility
On call 24 hours daily, seven days a week
Responsible for staff training, evaluation of maintenance, custodial and
conference service staff including recommending discipline, promotions or pay
increases
Assists in budget development. Responsible for spending control on
maintenance and facilities areas
Responsible for all audio /visual equipment and supplies
Develops and maintains vendor contracts
Functions as General Manager in GM's absence
9. Specify how the above listed job duties are currently performed.
In the same manner as specified above
10. Explain the need for this change in detail.
The amount of meeting space has more than doubled since opening the
facility. The volume of business has gone from minimal to over $3.5 million a
year. The staff has grown to support the increased business. -This requires longer
hours and greater ability on the part of the Operations Manager to meet client
needs. It is a position that requires a high level of customer service ability in a
highly competitive meetings environment.
CITY OF13ROOKLYN CENTER
2001 BUDGET
REQUEST FOR ADDITIONAL PERSONNEL
1. Division Name: Earle Brown Heritage Center
2. Division Number: 655
3. Position Title: Maintenance Custodian
4. Number Required: One Additional 5. Pay Grade D17
6. Salary or Wage Range: From $13.347 To $16.242 per hour
7. 1 st Year Cost: $27,868 plus benefits of approximately $6,270
Currently $27,144 plus related benefits are expended for part-time staff
8. Indicate Need for Position(s)
( ) New Operation ( },Expanded Services () Increased Work
(X)On going inability to hire part-time maintenance staff.
Any increased cost in converting from part-time to full -time in this position will be
offset by savings in employment advertising and constant training due to turnover.
9. List below the job duties to be performed in the requested position(s).
Performs carpentry work as needed throughout the buildings
Performs minor electrical duties and various plumbing tasks
Dandles maintenance of mechanical equipment
Keeps cleaning equipment in good working order
Maintains logs on equipment and repairs, recommends equipment
replacement
Repairs building and equipment as needed
Monitors building heating nd cooling units to determine \correct problems
g g P
Performs preventative maintenance
Performs landscaping duties as requested by maintenance supervisor
Shovels sidewalks and removes ice from building walkways
Caulks and tuckpoints brick, block, window and door spaces
Handles inventory control
Develops and follows preventative maintenance schedules
Assists with maintenance of courtyard fountains and exterior fixtures
Works with customers on set -up and maintenance as needed.
10. Specify how the above listed job duties are currently performed.
Currently there is one full -time maintenance custodian who performs these
tasks with the assistance of part-time custodians.
11. Explain the need for this position in detail.
Conversion of part-time custodial hours (ten a day five days a week) into
one full-time custodial position will decrease employment advertising costs, lower
the investment in training hours /dollars and eliminate the problem of being without
full custodial staff. The facility is frequently without part-time hours due to
inability to hire and/or retain personnel in today's labor market. Adding one more
full -time person to this existing position which is benefit paying should eliminate
the constant hole the facility has experienced because we have been unable to find
qualified part-time help.
12. Additional cost associated with requested position(s): N\A
Contractual Services $ Supplies $
Capital Outlays $
Division: Catering Operations
Budget Code: 656
Program No: 8900, 8909
PROFILE
The Catering Division of the Heritage Center sells, prepares, and services all food and beverage - related activity. A
management contract exists with Flik Intemational, Rye Brook, New York, to oversee this division at the direction
of the Heritage Center General Manager. There is also a joint sales effort between facility and catering sales
personnel.
Flik creates menus, determines food pricing, hires staff, provides food and beverage to facility clients, and
maintains an inventory of food and small wares, maintains the kitchen and service areas, and services all food -
related functions.
This division is responsible for 2.5 million in gross revenues.
DEPARTMENTAL GOALS
• Provide the finest quality of food and beverage available to facility clients.
• Develop additional revenue through the creation of new menus and increased menu pricing.
• Maintain competitive purchase pricing.
• Continue to eliminate duplicity of effort between the facility and catering systems.
• Continue aggressive marketing by facility and catering sales staff to existing and new corporate/social clients.
PERSONNEL LEVELS
Contracted through Flik International: Food and Beverage Director, Assistant Food and Beverage Director, Catering
Sales Managers, Executive Chef, Sous Chefs, Cooks, Bartenders, Banquet Manager, Banquet Captains, Banquet
Servers, and Service Staff.
SPECIFIC EXPENDITURE DETAIL
Obiect Number Expenditure Amount
4213 Redistributed to 4214 and 4216.
4220 Redistributed.
4231 Age of equipment creates additional $1,550
repair costs. _
4233 Age of equipment creates additional $1,300
repair costs.
4241 Increased laundry due to increased $56,000
business.
4271 Knives, slicer blades, mixer blades $ 1,000
CAPITAL OUTLAY — A LIST
Item Anticipated Units Cost(s) Use / Need
Purchase Date
Ductwork Insulation First Quarter $5,900 Insulation of ductwork due to
condensation dripping into
food prep areas
Computers First Quarter 2 $4,000 Replacement of existing
equipment See justification
Page under Convention Ctr
Carter Hoffman Hot January and October 4 $3,600 Replacements of two boxes
Boxes and increase of two to
support H & G Sams.
Queen Mary's January and October 4 $3,200 Used for transport of dishes.
(Mobile transport racks) Needed for increased volume
Proof Boxes 1101 3 $1,950 Replacement of current
equipment.
Convention Oven January and October 2 $2,250 Replacement of steamers
TOTAL $20,900
CAPITAL OUTLAY B LIST
Mixer /Cutter June 2001 1 $7,500 Production of dressings and
sauces in quantities
f: usersr bergeland /budget/capoutcatering.doc
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF. CAPITAL OUTLAYS REQUESTS
1. Division: Catering Div. # 656 Object #: 4550
2. Give description and quantity of item requested. Indicate date desired.
Insulation of ceiling heating /cooling ducts in the kitchen
3. Describe the necessity for and /or benefits or savings expected from this item.
Moisture accumulates on the duct work and then drips into the ceiling tile, down
onto the food prep and plate wash areas. Creates unsanitary and unsafe working
conditions in the kitchen.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item'.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
Included in bid.
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
N/A
7. Estimated Net Cost: $ 5,900
Quantity Unit Cost Total Cost Trade -in Net Total Cost
1 $5,900 - $5,900 $0 $5,900
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: Catering Div. # 656 Object #:.4552
2. Give description and quantity of item requested. Indicate date desired.
Four Carter Hoffrnan Hot Boxes for holding and transporting heated food.
Purchase two in January and two in October
3. Describe the necessity for and /or benefits or savings expected from this item.
Replacement for two worn boxes (ten years old). Addition of two new boxes due to
volume.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
6. List any item which will be replaced by this purchase.. State .recommendations fox
disposition of this item. For example, trade -in salvage, discard, etc.
Two existing Carters will be replaced. If condition permits, will use as tradein for
new.
7. Estimated Net Cost: $ 3,600
Quantity Unit Cost Total Cost Trade -in Net Total Cost
4 $900 $3,600 $3,600
I _ CITY OF BROOKLYN CENTER .
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: Catering Div. # 656 Object #: 4552
2. Give description and quantity of item requested. 'Indicate date desired.
Four Queen Mary's. Large shelved mobile racks for transpoting both clean
And soiled dishware. Purchase two in Janua and two in October.
3. Describe the necessity for and /or benefits or savings expected from this item.
Currently not enough Queen Mary's, carts, plate containers or tubs to transport
Dishes on high volume days. Dishes can be taken downstairs for washing earlier
In the evening to expedite the washing /clean up process. Will result in fewer
Stewarding hours.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. - For example, trade -in salvage, discard, etc. .
N/A
7. Estimated Net Cost: $ 3,200
Quantity Unit Cost Total Cost Trade -in Net Total Cost
4 $800 $3,200 $3,200
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: Catering Div. # 656 Object #: 4552
2. Give description and quantity of item requested. Indicate date desired.
Three Proof Boxes to be purchased in January 2001
3. Describe the necessity for and /or benefits or savings expected from this item.
Used for proofing of goods to be baked - cookies, breads, etc. Also for transport
Of hot and cold foods. Will replace existing aged equipment.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necexssary to place this item in operation and whether these,
expenses are included in your budget request.
N/A
6. List an item which will be replaced b this purchase. State recommendations Y p y p for
disposition of this item. For example, trade-in salvage, discard, etc.
N/A
7. Estimated -Net Cost: $ 1,950
Quantity Unit Cost Total Cost Trade -in Net Total Cost
3 $650 $1,950 $1,950
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: Catering Div. # 656 Object #: 4552
2. Give description and quantity of item requested. Indicate date desired..
Two convection ovens. One purchased in January and One in October.
3.. Describe the necessity for and /or benefits or savings expected from this item.
Replacing existing steamers with convection ovens. Ensures quality of hot good
for increased capacity and shortens cooking time thereby saving labor hours.
Currently there is insufficient cooking capacity for large groups.
.4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate an � y e xpenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
6. List any hem which wil! be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
Possible trade in with Palm Brothers. Can expect $.20 on $1 for steam cabinets
7. Estimated Net Cost: $ 2,250
Quantity Unit Cost Total Cost' Trade -in Net Total Cost
2 $1,300 $2,600 $350 $2,250
�I
- CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: Catering Div. # 656 Object #: 4552
2.. Give description and quantity of item requested. Indicate date desired.
One large mixer /cutter. Purchase in June 2001
3. Describe the necessity for and /or benefits or savings expected from this item.
Ability to produce quantities of dressings and sauces from scratch (rather than
producing small amounts through the day). Savings of six labor hours ($12 each)
per day, at least two days per week.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
Maintenance or electrical labor hours (8 -16) to hard wire. Expense not included
In the budget.
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
Possible trade in with Palm Brothers. Can expect $.20 on $1 for steam cabinets
7. Estimated Net Cost: $ 7,500
Quantity Unit Cost. Total Cost Trade -in Net Total Cost
1 $7,500 $7,500 $7,500
Division: Office Rentals
Budget Code: 657
Program No: 8930
PROFILE:
n -
Approximately seventy percent of the D Barn is currently designed to provide commercial office rental space and is occupied under a
long term lease with Blumental's Architecture. The Heritage Center staff, under the direction of the General Manager, provides
maintenance and custodial services, lawn care, and snow removal. Leases are negotiated by the General Manager. The remaining
ground level square footage (approximately 1000 square feet) provides storage area for audiovisual equipment, which supports the
meeting areas.
DEPARTMENT GOALS
• Continue to provide appropriate maintenance at current high standards to tenant.
• Respond to tenant concerns, if any, in a timely manner. .
PERSONNEL LEVELS
General Manager oversees entity. Maintenance:and custodial care provided by Heritage Center staff under the direction of the
Maintenance Supervisor.
Division: Inn on the Farm
Budget Code: 658
Program No: 8910
PROFILE:
The Inn on the Farm is a showcase of the community's commitment to historic preservation. It is a working
Country Inn providing overnight accommodations to social, corporate, and travel clientele doing business and/or
visiting the North Metro area. It provides small meeting accommodations for approximately 175 corporate clients
yearly, as well as introducing them to the larger meeting facilities at Earle Brown Heritage Center.
DEPARTMENTAL GOALS
• To complement Heritage Center Events with superior on -site lodging.
• To continue to develop and support the corporate client base which provides approximately 55% of the
overnight occupancy.
• To continue to provide a high level of service to clients thereby assuring continued repeat business levels which
lead to increased client base.
• To continue efficient use of staff through cross training.
• To continue introducing new corporate clients to the Inn and the Heritage Center by promotion of small
meetings and overnight accommodations.
PERSONNEL LEVELS
Supervision of the Inn by one full -time Assistant Innkeeper who reports to the General Manager.
Part-time positions include Hostess/Cooks, Housekeepers, and Night Desk Clerks. Maintenance and repair of the
Inn (interior and exterior) are provided by the convention center maintenance staff under the direction of the
Maintenance Supervisor and billed to the Inn budget.
CAPITAL OUTLAY
Item Anticipated Units Cost(s) Use / Need
Purchase Date
Mattress/Box Spring Sets January 2001 10 _ $4,000 Replacement of ten year old
mattress sets.
Overstuffed Chairs March 2001 2 $1,500 Replacement of wom and
stained fumiture
Repair of rotted link beam . January 2001 1 $50,000 Repair /replacement of rotten
structural beam in Link
F:\usa-sjbergeland\budget\capoudnnovemew.doe
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Inn Div. # 658 Object #: 4550
2. Give description and quantity of item requested. Indicate date desired.
Ten mattress/box spring sets for sleeping rooms. Purchase January 2001
3. Describe the necessity for and /or benefits or savings expected from this item.
Existing mattresses are ten years old. Clients are complaining about discomfort.
Mattresses are beginning to feel lumpy, are beginning to sag, or guests complain
about being able to feel the springs.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
Please old mattresses on City auction or discard.
7. 'Estimated Net Cost: $ 4,000
Quantity Unit Cost Total Cost Trade -in Net Total Cost
10 $ 400 $ 4,000 $0 $ 4,450
CITY OF BROOKLYN CENTER - -
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Inn Div. # 658 Object #: 4550
2. Give description and quantity of item requested. Indicate date desired.
Replacement of two overstuffed chairs in Jess Howe room.
3. Describe the necessity for and /or benefits or savings expected from this item.
Chairs are ten years old, badly stained, and will not come clean. Guests are
Commenting on their appearance.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
R
n
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A .
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
Will reuppolister and use in other areas of the complex if cost efficient. Otherwise
items will go to City auction.
7. Estimated Net Cost: $1,500
Quantity Unit Cost Total Cost Trade -in Net Total Cost
2 $ 750 $ 1,500 $0 $ 1,500
CITY OF BROOKLYN CENTER - -
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division:. EBHC Inn Div. # 658 Object #: 4520
2. Give description and quantity of item requested. Indicate date desired.
Repair or replacement of rotted beam in the Inn link
3. Describe the necessity for and /or benefits or savings expected from this item.
Left untended the beam will eventually rot through and become a structural hazard.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
Included in cost estimate.
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
N/A
7. Estimated Net Cost: $ 50,000
Quantity Unit Cost Total Cost Trade -in Net Total Cost
1 $ 50,000. $ 50,000 $0 $ 50,000
Division: Administration
Budget Code: 660
Program No: 8999
PROFILE
To provide overall administrative duties for the complex which is Earle Brown Heritage Center, including, but not
limited to, commercial. office, Convention Center, catering, and Inn on the Farm. .
DEPARTMENTAL GOALS
• To oversee and support the work of the various divisions which make up the Earle Brown Heritage Center.
SPECIFIC EXPENDITURE CODE DETAIL
Obiect Number Expenditure Amount
4411 Conferences and schools annual $ 4,500
professional development for
General Manager.
PERSONNEL LEVELS
Number Position
1 EBHC Manager
Secretary/Receptionist
1 Secretary/Billing Clerk -
1 Part -time Clerk/Typist (currently vacant)
CITY OF BROOKLYN CENTER
2001 BUDGET
REQUEST FOR A CHANGE IN JOB CLASSIFICATION
1. Division Name: Earle Brown Heritage Center
2. Division Number: 660
3. Position Title:
From: Secretary/Billing Clerk To: Secretary/Billing Clerk
4. Pay Grade
From: D13D To: D17D
5. Salary or Wage Range:
From: Step A $12.091 Step G. $14.715
To: Step A $13.347 Step G. $16.242
6. 1 st Year Cost: $ $2,962.87 plus benefits on same amount
7. Indicate Need for Positions)
( X ) Market Rate Increases (X ) Increased Skill Levels or Responsibilities
8. List below the job duties to be performed in the requested position(s).
Process event billing into ESP2000 and IFAS
Process invoices for accounts receivable
Process daily cash receipts and enter into ESP2000 (deposits) and IFAS
Verify and deposit cash bar and concession stand monies
Verify credit references
Collect past due accounts
Collect and collate conference services electrical/telephone /etc payments
Process returned contracts
Update monthly aging reports
Provide admin support to General Manager and Sales Staff
On -site contact for Groupwise e-mail system
Respond to customer questions and concerns
Maintain petty cash fund
Provide backup for receptionist
Administer event insurance
Code invoices for payment.
9. Specify how the above listed job, duties are currently performed.
Job duties are currently performed as listed above.
10. Explain the need for this change in detail.
Many functions now performed by this position were performed by the staff
accountant in finance or by the former catering management firm. This position
handles all invoicing and receipt of payments for the convention center and
catering operation — approximately $3.2 million annually. The classification
requested is consistent with the duties and classification of the Accounting
Technician II and Utilities Technician II positions at City Hall.
CITY OF BROOKLYN CENTER
2001 BUDGET
JUSTIFICATION OF CAPITAL OUTLAYS REQUESTS
1. Division: EBHC Div. # 660 Object #: 4552
2. Give description and quantity of item requested. Indicate date desired.
Replacement of three reception room chairs. Second quarter 2001
3. Describe the necessity for and /or benefits or savings expected from this item.
Existing reception room area chairs are ten years, have been cleaned many times, and
reglued to keep stable. It is not possible to repair them any more.
4. If the item requires an increase in personal services for the activity, state the job titles
contingent upon the item.
N/A
5. Indicate any expenses necessary to place this item in operation and whether these
expenses are included in your budget request.
N/A r
6. List any item which will be replaced by this purchase. State recommendations for
disposition of this item. For example, trade -in salvage, discard, etc.
City auction or discard.
7. Estimated Net Cost: $ 2,250
Quantity Unit Cost Total Cost Trade -in Net Total Cost
3 $ 750 $ 2,250 $0 $ 2,250
City of Brooklyn Center
A great place to start. A great place to stay.
To: Mayor Kragness and Council Members Hilstrom, Lasman, Nelson and Peppe
From: Michael J. McCaule
City Manager
Date: October 12, 2000
Re: Liquor Stores Draft 2001 Budget
The draft liquor stores budget is based on conservative estimates of revenues. The budget meets
transfer requirements. We are still waiting to see the operating results during the holiday period at
the new store and the longer term impacts on the Northbrook store of the new store. So far, sales
levels at the Northbrook store have not seemed to have been impacted as much as anticipated. When
we are closer to December's budget adoption, we may revise these budget numbers upward if actual,
results warrant.
6301 Shingle Creek Pkwy, Brooklyn Center, MN 55430 -2199 • City Hall & TDD Number (612) 569 -3300
Recreation and Community Center Phone & TDD Number (612) 569 -3400 • FAX (612) 569 -3494
An Affirmative Action /Equal Opportunities Employer
LIQUOR STORES
2001 BUDGET
Dept
Actual Actual Adopted Requested
Budget 1998 1999 2000 2001
REVENUES:
Liquor Sales $1,013,415 $1,137,459 $1,136,800 $1,060,030
Wine Sales 320,163 346,561 383,200 . 363,620
Beer Sales 1,670,663 1,852,012 1,824,300 1,693,650
Other Sales 204,800 231,200 243,900 229,700
Investment Earnings 13,267 11,645 15,000 15,000
Total Revenues $3,222,308 $3,578,877 $3,603,200 $3,362,000
Less: Cost of Sales $2,433,185 $2,694,622 $2,711,933 . $2,525,964
Gross Profit $789,123 $884,255 $891,267 $836,036
EXPENDITURES: a
Personnel $370,953 $387,260 - $418,412 $424,609
Supplies 11,698 16,133 18,090 15,420
Other Contractual Services 54,524 59,667 53,771 56,359
Building Rent 55,003 69,922 170,379 156,600
Insurance 9,679 8,146 10,926 10,544
Utilities 24,572 25,433 22,006 16,660
Interest Expense 4,691 2,593 0 0
Administrative Service Transfer 25,435 26,256 25,486 26,761
Depreciation 40,787 39,821 38,541 33,800
Total Expenditures $597,342 $635,231 ' $757,611 $740,753
Operating Income $191,781 $249,024 $133,656 $95,283
Capital Outlay 39,421 1,972 10,000 0
General Fund Transfer 0 0 0 0
Capital Improvements Fund Transfer 75,000 75,000. 75,000 75,000
Available Resources $77,360 $172,052 $48,656 $20,283
8/29 100 2:48 PM
LIQUOR STORES
2001 BUDGET
Division: Brooklyn Center Liquor Store
Dept
Actual Actual Adopted Requested
1998 1999 2000 2001
REVENUES:
Liquor Sales $612,200 $704,030
Wine Sales 226,800 260,820
Beer Sales 931,000 1,070,650
Other Sales 130,000 149,500
Investment Earnings 10,000 10,000
Total Revenues $0 $0 $1,910,000 $2,195,000
Less: Cost of Sales $1,432,346 $1,645,489
Gross Profit $0 $0 $477,654 $549,511
EXPENDITURES:
Personnel $206,438 $272,436
Supplies K. 9,425 9,750
Other Contractual Services 26,374 - 35,1
Building Rent 117,600 117,600
Insurance 5,526 6,841
Utilities 8,410 8,410
Administrative Service Transfer ,.16,141 17,228
Depreciation 20,000 28,700
Total Expenditures $0 $0 • $409,914 $496,127
Operating Income $0 $0 $E7,740 _ $53,3884
Capital Outlay
General Fund Transfer
Capital improvements Fund Transfer 50,000 ,000
Available Resources $0 $0 $17,740 C- : 0 3 1 .rM
MAW 2:48 PM
LIQUOR STORES
2001 BUDGET
Division: NORTHBROOK STORE
Dept
Actual Actual Adopted Requested
1998 1999 2000 2001
REVENUES:
Liquor Sales $394,84.7 $447,521 $356,000 $356,000
Wine Sales 114,104 122,753 102,800 102,800
Beer Sales 692,249 759,399 623,000 623,000
Other Sales 88,696 97,752 80,200 80,200
Investment Earnings. 4,423 3,882 5,000 5,600
Total Revenues $1,294,319 $1,431,307 $1,167,000 $1,167,000
Less: Cost of Sales $978,1 $1,078,454 $880,300 $880,475
Gross Profit $316,211 $352,853 $286,700 $286,525
EXPENDITURES:
Personnel $122,769 $133,018 $142,975 $152,173
Supplies 3,733 6,485 5,655 5,670
Other Contractual Services 16,072 18,766 17,382 21,197
Building Rent 35,713 37,213 39,000 39,000
Insurance 3,478 2,973 3,490 3,703
Utilities 7,194 7,705 7,705 8,250
Administrative Service Transfer 10,174 9,912 9,345 9,533
Depreciation 6,023 6,023 8,000 5,100
Total Expenditures $205,156 $222,095 $233,552 $244,626
Operating income $111,055 $130;758 $53;148 $41,890
Capital Outlay 10,000
General Fund Transfer
Capital Improvements Fund Transfer 25,000 25,000 25,000 25,000
Available Resources $86,055 $105,758 $18,148 $16,899
8/29100 2:48 PM
CITY OF BROOKLYN CENTER
LIQUOR STORE REVENUES
Brooklyn Center Liquor
2000 2001 Gross. Liquor
Est Est Profit Cost Liab Ins
Revenues Revenues Percent Of Sales 0.00225
Liquor 3521 612,200 704,030 26.38 % - . 518,307 1,584.07
Wine - 3522 226,800 260,820 29.79% 183,122 586.85
Beer 3523
Bottle Deposit 3527
Beer Total 3523 931,000 1,070,650 22.49 %' 829,861 2,408.96
Mix NT 3524 11,000 12,100 30.55% 8,403 27.23
Mix Taxable 3525 26,600 30,400 25.77% 22,566 68.40
Miscellaneous 3526 87,000 100,000 27.17 72,830 225.00
Other Revenue 3461 4,700 6,000
Check Process 3472 700 1,000
130,000 149,500
1,900,000 2,185,000 1,635,089 4,900.50
I
nextbdgtldept51 MEVENUEXLS BC store 8/2910011:26 AM
BC store
8/29/00
CITY OF BROOKLYN CENTER, MINNESOTA DEPARTMENT: LIQUOR
PROJECTED 2001 WAGES & BENEFITS, DEPARTMENT REQUESTED DEPT. NO. 511
TOTAL COMPENSATION PROJECTION
3.00% 4142
ANNUAL PERA 4146 4150 4154 TOTAL
Increase COORD FICA CAFE W/C FRINGE TOTAL
POSITION EMPLOYEE Projected 5.1W 7.65% PLAN INSUR BENEFITS COMPENS
Liquor Operations Mgr Olson 45,518 2 3,482 5,004 407 11,251 56,769
Liquor Store Manager Mueller 45,917 2,379 3,513. 5,004 423 11,318 57,235
Liquor Store Manager LaChance 0 0 0'.' 0 0 0 0
Asst Store Manager LaRose 34,163 1,770 2,613 5,004 325 9,712 43,875
- - - - -- - - - - -- - - - - -- . ------
TOTAL FULL -TIME 125,599 6,506 9,608 15,012 1 32,281 157,880
Brooklyn Center STORE PART HOURS
Cashier /Asst Level G 1,600 18,672 967 1,428 0 155 2,551 21,222
Clerk Level G 2,650 26,285 1,362 2,011 0 218 3,591 29,876 .
Clerk Level F 1,040 9,5,44 494 730 0 79 1,304 10,848
Clerk Level E 0 0 0 0 0 0 0 0
Clerk Level D 0 0 0 0 0 0 0 0
Clerk Level C 1,586 12,•987 673 994 0 108 1,774 14,761
Clerk Level B 1,352 10,583 548 810 0 88 1,446 12,029
Clerk Level A 3,042 22,716 1,177 1,738 0 189 3,103 25,819
STORE TOTAL 11,270 100,788 5,221 7,710 0 837 13,768 114,555
----------------------------- - - - - -- - - - - - -- - - - - -- - - - - -- - - - - -- - - - -- - - - - -- - - - - - --
226,386 11,727 17,319 15,012 .1,991 46,049 272,435
deptsum 8/29/00 11:19 AM
CITY OF BROOKLYN CENTER, MINNESOTA DEPARTMENT: LIQUOR
PROJECTED 2001 WAGES & BENEFITS, DEPARTMENT REQUESTED DEPT. NO. 511
TOTAL COMPENSATION PROJECTION
2,088 3.00% 4142
ANNUAL HOURS ANNUAL PERA 4146 4150 4154 TOTAL
GRADE MONTHLY ANNUAL Increase COORD FICA CAFE W/C FRINGE TOTAL
POSITION EMPLOYEE CURR PROJ HOURLY Projected Projected 5.18% 7.65% PLAN INSUR BENEFITS COMPENS
Liquor Operations Mgr Olson T29G T2cjG 5,261 M 63,132 65,026 3,368 4,974 5,004 581 13,928 78,954
Liquor Store Manager Mueller C16E C16F 3,715 M' 44,580 45,917 2,379 3,513 5,004 423 11,318 57,235
Liquor Store Manager LaChance C16D C16E 3,625 M 43,500 44,805 2,321 3,428 5,004 413 11,166 55,971
Asst Store Manager LaRose C9A C9B 2,764 M 33,168 34,163 1,770 2,613 5,004 325 9,712 43,875
TOTAL FULL -TIME 184,380 189,911 9,837 14,528 20,016 1,742 46,124 236,035
' a
Brooklyn Center STORE PART HOURS
Cashier /Asst Level G.' 1,600 11.330 H 18,128 18,672 .967 1,428 155 2,551 21,222
Clerk Level G 2,650 9.630 H 25,520 26,285 1,362 2,011 218 3,591 29,876
Clerk Level F 1,040 8.910 H 9,266 9,544 494 730 79 1,304 10,848
Clerk Level E 0 8.450 H 0 0 0 0 0 .0 0
Clerk Level D 0 8.200 H 0 0 0 0 0 0 0
Clerk Level C 1,586 7.950 H 12,609 12,987 673 994 108 1,774 14,761
Clerk Level B 1,352 7.600 H 10,275 10,583 548 810 Be '1,446 12,029
C1erk,Level A 3_042 7.250 H 22,055 22,716 1,177 1,738 189 3,103 25,819
- - - -- - - - -- - --
STORE #1 TOTAL 11,270 97,852 100,788 5,221 7,710 837 13,768 114,555
STORE #3 PART -TIME HOURS
Clerk Level G 1 9.630 H ' 15,408 15,870 822 1,214 132 2,168 18,038
Clerk Level F 1,600 8.910 H 14,256 14,684 761 1,123 122 2,006 16,689
Clerk Level E 800 8.450 H 6,760 6,963 361 533 58 951 7,914
Clerk Level D 0 8.200 H 0 0 0 0 0 0 0
Clerk Level C 0 7.950 H 0 0 0 0 0 0 0
Clerk Level B 2,000 7.600 H 15,200 15,656 811 1,198 130 2,139 17,795
Clerk Level A 1,600 7.250 H 11„600 11,948 619 914 99 1,632 13,580
STORE #3 TOTAL 7,600 63,224 65,121 3,373 4,982 541 8,895 74,016
-------------------- ----------------------------- - - - - -- - - - - - -- - - - - - -- - - - - -- - - - - -- ------ - - - -- - - - - -- - - - - - -- .
TOTAL 345,456 355,820 18,431 27,220 20,016 3,119 68,787 424,607
store #3 8/25/00
CITY OF BROOKLYN CENTER, MINNESOTA DEPARTMENT: LIQUOR
PROJECTED 2001 WAGES & BENEFITS, DEPARTMENT REQUESTED DEPT. NO. 511
TOTAL COMPENSATION PROJECTION
\ 3.00 4142
ANNUAL PERA 4146 4150 4154 TOTAL
Increase COORD FICA CAFE W/C FRINGE TOTAL
POSITION EMPLOYEE Projected 5.18% 7.65% PLAN INSUR BENEFITS COMPENS
Liquor Operations Mgr Olson - ou l l9 1 508 1,011 1 0 174 2,677 22,185
Liquor Store Manager Mueller 0 0 0 0 0 0 0
Liquor Store.Manager LaChance 44,805 2,321 3,428 5,004 413 11,166 55,971
Asst Store Marlager LaRose 0 0 .0 0 0 0 0
TOTAL FULL -TIME 64,313 3,331 4,920 5 588 13,843 78,156
STORE #3 PART -TIME HOURS
Clerk Level G 1,600 15,870 822 1,214 0 132 2,168 18,038
Clerk Level F 1 14 761 1,123 0 122 2, 006 16,689
Clerk Level E 800 6,963 361 533 0 58 951 7,914
Clerk Level D 0 0 0 0 0 .0 0 0
Clerk Level C 0 0 0 0. 0 0 0 0
Clerk Level B 2 15,656 811 1,198 0 130' 2,139 17,795
Clerk Level A 1,600 11,948 619 914 01 99 1,632 13,580
STORE TOTAL 7,600 65,121 3,373 4,982 0 541 8,895 74,016
----------------------------- - - - - -- - - - - - -- - - - - -- - - - - --
129,434 6,705 9 5,004 1,128 22,739 152,172
• ccc =ccc car -...c ceccsas caac.a - -__. -- cccscam
CITY OF BROOKLYN CENTER 08/29/00 A D H O C R E P O R T Page 1
TUE, AUG 29, 2000, 11s42 AM - -req: CHARLIE -- -leg: GL -- - -loc: BC- FINCE- -jobs 75823 #S6965 ---- progs TF500 <1.62 >-- report id: RXREPOR7
* *
*
AD HOC R E P O R T WRITER
* Requester's Name: CHARLIE HANSEN
* Requester's Location: BC -FINCE
* Current Date:•TUE, AUG 29, 2000, 11:42 AM
* Name of Report Files RXBGDVDR.RDF.BCFS.
* Report Title: CITY OF BROOKLYN CENTER
*
SELECT FUND s 051
• r
CITY OF BROO..,. A CENTER .. '
BUDGET REQUEST WORKSHEET BY DIVISION. Page 1
.2001 BUDGET
2000 2001
)bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
ssssassmasaasss ssssasssssssssasss ssssssssssaasss sssssssssssssas ssssasssssa :ss ssssssssmsss :a :ass :ssassaama asaaaaaammam =m
)IV HUMBOLDT LIQUOR 651
1100 Wages Regular Employees 23,316 24,884 25,460 7,892 11,507 0
1112 Overtime Regular Employee 0 209 0 0 0
1130 Wages Part -time Employees 66,252 67,476 69,872 23,397 28,341 0
1131 Overtime of Part -time Emp 0 134 38 0 0 0
1133 Vacation Pay 4,584 5,115 5,809 0 470 0
k134 Holiday Pay 2,696 2,290 2,159 0 704 0
1135 Sick Leave Pay 1,153 848 1,255 0 0 0
Salaries and Wages .,TOTAL 98,001 100,745 104,802 31,289 41,021 0
sssssssss sssssssss sssssssss sssssssss s :sas : :ss assssa :mm
:142 PERA Coordinated Plan 3,722 4,218 4,305 1,621 1,677 0
1143 PERA Police & Fire Plan 0 0 19 0 0• 0
1146 FICA 7,349 7, ,566 7,786 2,394 3,145 0
1150 Employee Benefits 2,045 2,649 2,593 1,191 1,242 0
1151 Health Insurance 282 0 0 0 0 0
1152 Life Insurance . 3.. 0 0 0 0 0
1153 Dental Insurance 23 0 0 0 0 0
1154 Workers Comp Insurance 284 1,069 926 335 310 0
1156 Unemployment Compensation 0 787 880 0 801 0
1158 Disability Insurance -291 291 345 95 184 0
Fringe Benefits TOTAL 13,997 16,580 16,854 5,636 7,358 0
sssssssss sssssssss sssssssss sssssssss sssssssss asssaasar'p
1210 Office Supplies 37 0 136 65 0 0
. '
CITY OF BROOKLYN CENTER
BL'=ET REQUEST WORKSHEET BY DIVISION Page , 2
2001 BUDGET
2000 2001
p
Object
Code & Descrip
1997 1998 1999•
ADOPTED AS OF
DEPT
Di v i sion j iss :.xxexa D ss :e i p ssi :. s :..: as �asssssss :s. : :� : :s.. s =. :A :mm.� : =x= Ms:MBUDGET:ss. sis 07 /31 /OO REQUESTED
aax x =xxm
4217 Paper Supplies 32 51 49 167 0 0
4220 Operating Supplies 2,348 2,379 2,447 665 948 0'
4223 Cleaning Supplies 318 0 0 0 0 0
4224 Clothing & Personal Equip 0 200 180 100 0 0
4230'Repair & Maint Supplies 339 296 236 300 0 0
4231 Equipment Parts 559 0 0 0 0 0
4233 Building Repair Supplies 699 0 64 335 0 0
4241 Laundry 105 106 161 65 55 0
4271 Minor Equipment 226 0 1,229 0 0 0
Supplies' TOTAL 4,664 3,031 4,499 1,697 1,003 0
sssssssss sasssssss sssssssss sssssssss asssssa,ss sssssssss
I
4310 Professional Services 325 186 0 100 464 0
4313 Audit & Financial Service 798 825 750 0 638 0
0
Purchased Services TOTAL, 1,123 1,011 750 100 1,102 0
sssssssss sssssssss sssssssss sssssssss sssssssss xass :saxs
4322 Telephone Services 1,699 1,810 1,697 609 764 0
4340 Advertising 0 200 0 0 0 0
( '4346 Advertising - Print 1,405 798 2,202 500 384 0
Communications TOTAL 3,104 2,808 3,899 1,109 1,148 0
• sssssssss :sss :.ssss sssssssss sssssssss asssssx :s sssssssss
4380 Repair & Maint Contract 1 1,415 1,221 500 0 0
4382 Equipment Repair & Maint 1,6%;10 575 1,910 500 916 0
4383 Buildings Repairs 190 2,965 457 0 0 0
4388 Electrical. Repairs 0 3,7n., 557. 165 0 .• 0
CITY OF BROO..,...N CENTER -•
BUDGET REQUEST WORKSHEET BY DIVISION Page 3
.2001 BUDGET
2000 2001
)bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
: ssaasassamasa :sasssssssssasaaass +sssssssasssssa sssssssssssa :s: ++++ss+++sas :a ssssssasssaass +ssssassasssas as :aaaaaoaaas:
4397 Logis Charges 1,909 1,795 2,014 500 1,388 0
4398 Protective Services 410 410 721 137 360 0
i
tepair Rental & Maint TOTAL 6,08 7,530 6,879 2,664 0
sssssssss sssssssss sssssssss s+sss +sas sssssssss aassaaass
4400 Other Contractual Service 289 432 443 665, 210 0
1401 Credit Card Fees 963 1,590 3,073 935 1,666 0
( '1402 Uncollectible Checks -5 639 948 200 313 0
1403'Cash (Over) and Short 1,247 1,946 1,920 400 1,004 0
1404 Collection Fees 3 21' 0 0 0 0
1405 Check Verification Fees 881 1,473 1,985 165 250 0
I
1411 Conferences and Schools 39 0 0 0 '0 0
1413 Dues & Subscriptions 175 175 205 60 0 0
1414 Licenses, Taxes, & Fees 148 103' 103 50 0 0
eA •
1421 Janitorial Service 91 10 42 0 13 0
)ther Contractual Sery TOTAL 3,830 6,389 8,720 2,475 3,455 0
• sasssss+is +ss +aas+a sasssasas sessassa assassas ssaasssas '.
1440 Fuel Charges 73 82 80 35 46 0
1441 Fixed Charges 666 283 266 103 103 0
1442 Repair & Maint Charges 206 243 385 55 174 0
ventral Garage Rentals TOTAL 945 608 731 193, 323 0
• ssssssssss ssasasssa sssssssss sssssssss sssssssss a +oa :a :aa
1461 Gen Liability Insurance 467 630 341 191 562 0
1462 Property Insurance 284 371 447 200 706 0
1463 Machinery Breakdown Ins 5,7 61 106 33 172 4
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page . 4
2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 , ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
aaaasaoassaasassasasssasm :a= :ssss ssssma :sasssmtss sssmmassasassss smssssasamsssa seas :ssssmssm: ssssmssmmssaam samaaaaaaaamaa
4469 Liquor Liability Ins 3,542 1,697 1 652 545 0
Insurance TOTAL 4,350 2,759 2,549 1,076 1,986 0
' asssaas.aa arias :ama ssss :sass • ssaasaaas sssa :aaaa asmaaaaaa
4481 Electric Service 7,927 7,188 8,123 2,665 3,887 0
4482 Gas Service 507 453 418 335 359 0
4484 Water Service 486 526 455 200 -18 0
4485 Sanitary Sewer Service 893 1,009 883 235 144 0
4487 Solid Waste Disposal 515 545 545 420 1,164 0
4488 Storm Water Drainage 196 209 224 100 174 0
Utilities TOTAL 10,525 9,929 10,648 3,955 5,710 0
sssssssss asss :ssss sssssssss sssssssss sssssssss s :a :sssaa
4611 Interest 6,936 4,691 2,593 0 515 0
Debt Service TOTAL 6,936 4,691 2,593 0 515 0
sssssssss smmmsaass •smsasssaie saasssmsm a :smmsmam sssaa sssa
4701 Transfers to General Fund 100,000' 0 0 0 0 0
4725 Capital Proj Fund Trans 0• 75,000 75,000 0 0 0
Transfer to other Fund TOTAL 100,000 75,000 75,000 0 0 0
' s : :s :ssss sssssssss saes :sssa asss :ssss asssas :am saaaaaaaa
4702 Administrative Sery Trans 9,064 7,122 7,452 0 3,010 0
Administrative Service TOTAL 9,084 7,122 7,452 0 3,010 0
s :sssssaa ss :sssa :o ssss :sssa asses : :as ssaaaaaas aaaaaaaaa
4800 Inventory Variances 2,909 2,495 2,781 665 956 0
4801 Merchandise Breakage 266 39 232 100 73 0•
4802 Delivery Charge C. O. S. 2,907 3,402 3,703 1,265 827 0
4821 Liquor Vnst of Sales 2109,6is 213,7An, 229,336 68,727 95,660 , 0
CITY OF BROO. ..d CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 5
.2001 BUDGET
2000 2001
>bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Di imisiosmCm mmssass mmmmummummsmmsmm mmmsms • BUDGET :::: sms :s /31 /00mss smREQUE$TEDmas
,822 Wine Cost of Sales 61,741. 63,977 65,778 20,590 27,393 0
,823 Beer Cost of Sales 335,744 361,278 395,574 115,954 159,826 0
+824 Non Tax Mix Cost of Sales 3,323 4,021 4,317 1,283 1,534 0
.825 Taxable Mix Cost of Sales 8,134 8,239 8,174 2,573 3,742 0
,826 Misc Cost of Sales 22,753 27,095 28,352 8 11,536 0
host of Sales TOTAL sm 647 , 4 72
:m 684,327 mm 738,248 mm 219,845 sm301,547 aaassma0
:920 Depreciation Expense 12,459 10,900 11,273 0 3,352 0
lepreciation TOTAL i m.m 10,900, .ms11,273 ms :mssss msss 3,,352 :smmsmms
1UMBOLDT LIQUOR TOTAL 922,5E8 933,431 994,897 269,177 374,194 0
e
i
5 '
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 6
.2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
sasasmmsmmmasaaaaassaasssssesssss assss :sss+Tas :sassasssssssss sssssassssssas sssss :ssaassss ssmsass :samsma s :m�sssamasmma
DIV BOULEVARD LIQUOR 652
4100 Wages Regular Employees 45,203 47,379 49,844 13,055 32,871 0
4112 Overtime Regular Employee 0 0 185 0 0 0
4130 Wages Part -time Employees 54,727 57,351 56,123 14,262 27,823 0
4131'Overtime of Part -time Emp 0 1,771 471 0 222 0
4133 Vacation Pay 2,522 3,075 3,578 0 1,224 0
4134 Holiday Pay 1,602 1,583 1,905 0 326 0
4135 Sick Leave Pay 654 938 11098 0 0 0
Salaries and Wages TOTAL aa 104,708 am 112 a 097 aa113i204 sas27 aaa assaaaaa
4142 PERA Coordinated Plan 4,122 5,417 5,150 1,415 3,057 0
4143 PERA Police & Fire Plan 0 0 17 0 0 0
4146 FICA 7,830 8,408 8,601 2,090 4,788 0
. rA
4150 Employee Benefits 2,570 3,740 4,400 952 2,6 26 0
4151 Health Insurance 421 0 0 0 0 0
4152 Life Insurance . 4 0 0 0 0 0
4153 Dental'Insurance 3.4 0 0 0, 0 0
4154 Workers Comp Insurance 306' 1,196 1,035 300 469 0
4156 Unemployment Compensation 0'• 0 178 0 -9 0
Fringe Benefits TOTAL 15,286 18,762 19,382 4,757 10,932 0
sssssssaas :ssssssss saasamaaa sssssssss masasamas ammmmasam
4210 Office Supplies ',6 0 136 50 0 0
4217 Paper Supplies 48 51 46 125 0 0
i
CITY OF BROOa. . N CENTER
BULLET REQUEST WORKSHEET BY DIVISION Page 7
.2001 BUDGET
2000 2001
abject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
s: :assasaaassassssssssssssssa :sss asssssarrssasas rrrrrsararsrraa aaaaasasaaaaaa ass :sssaaasass sssssaasaasas� aaaamaaaasaaaa
4220 Operating Supplies 2,685 3,356 3,052 725 1,638 0
4224 Clothing & Personal Equip 0 200 299 100 0 0
4230 Repair & Maint Supplies 0 122 109 125 0 0
4231 Equipment Parts 123 0 0 0 0 0
4233 Budding Repair Supplies 6 679 0 125 0 0
4241 Laundry 23 182 214 63 73 0
1271 Minor Equipment 595 345 1,293 0 0 0
Supplies TOTAL 3,607 4,934 5,149 1,313 1,711 0
• ssssasssr ssrssssss sssr srsss =ssssssss sassasssa asraasssa
1310 Professional Services 170 2,141 0 100 0 0
1312 Legal Services 0 197 768. 0 0 0
4313 Audit & Financial Service 798 825 750 0 638 0
?urchased Services TOTAL 968 3, 1,518 100 638 0
ssrssasslr sssssJesss arssssras s *srsssss ssssrssaa rsssarrss
4322 Telephone Services 1,485 1,990 1,6901 413 903 0
4324 Delivery Service .0 19 0 0 0 0
1340 Advertising 42 407 0 0 0 0
1346 Advertising - Print 2,701 2,672 2,605 5.00 909 0
communications TOTAL 4,228 5,087 4,296 913, 1,812 0
• arsssrsss' asrsssass sssrsasss s :assssss ssasaasrs raaaar :aa
4380 Repair & Maint Contract 1,959 1,830 1,221 - 375 0 0
4382 Equipment Repair & Maint 362 805 709 375 1,976 0
.. s
4383 Buildings Repairs 0 1,068 192 0 0 0
4386 Communication Systems 0 534 0 0 0 -0
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 8
..2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & ]description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
sssaaaasaassaaasamasasaas sss:ssss sssasasassssssa :sass :asasaaaas :ass :sss :sass smssssass : :sss sss: :sas :aaaaa sasaasssssasaa
4392 Building Rentals 0 19,290 32,709 13,779 20,141 0
4397 Logis Charges 1,!909 1,795 2,014 400 1,657 0
4398 Protective Services 4.90 391 772 142 363 0
Repair Rental & Maint TOTAL 4,e20 25,713 37,618 15,071 24,138 0
sssssseiss sas :sssss sassssama sssssasss mssssassm sasaaasaa
4400 Other Contractual Service 291 353 717 500 207 0
r
4401 Credit Card Fees 1,463 2,118 4,247 900 2,602 0
4402 Uncollectible Checks 363 -24 9531 125 338 0
4403 Cash (Over) and Short -196 474 89 150 225 0
4404 Collection Fees 2 47 0 0 0 0
4405 Check Verification Fees 1,471 .1,548 1,999 125 250 0
4411 Conferences and Schools 118 0 99 0 .0 0
4413 Dues & Subscriptions 175 175 205 . 50 0 0
4414 Licenses, Taxes, & Fees 148 c` 123 103 38 .0 0
4421 Janitorial Service 90 13 55 0 17 0
Other Contractual Sery TOTAL msss 3,925 ssaa mmmm mmms 1, sss msms3 ssmammmm
4440 Fuel Charges 73 82 s0 25 65 0
4441 Fixed Charges 665 283 266 77 134 0
4442 Repair.& Maint Charges 323 243 385 41 174 0
Central Garage Rentals TOTAL 1,062 608 731 143 373 0
' sssssasss sss :sasms sass: :sas s :sssssas ::asasaas ssmsasass
4461 Gen Liability Insurance 5 ,40 752 - 380 160 660 0
4462 Property-.Insurance 2$8 794., 391 120 620 0
CITY OF BROO, J CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 9
.2001 BUDGET
2000 2001
)bject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
saaaoaasmaaasassasasmaassssmasaas ass =sssmmslswa= ssasssmmaasssma =sslaaass =sass s =sass= =masssm asmss=sassmsss saasssaaaaa :aa
1463 Machinery Breakdown Ins 54 58 93 25 151 0
1469 Liquor Liability Ins 3,93q' 1,838 1,760 529 441 0
[assurance TOTAL 4,791 3,442 2,624 834 1,873 0
sssssms= =Mumma=== smmses==m sss=ls==s lssas=asm mm :aasaa:
1481 Service 5,904 5,403 5,328 1,300 2,628 0
1482 Gas Service 1,744 1,513 1,188 500 1,250 0
1484 Water Service 16 10 0 0 0 0
1485 Sanitary Sewer Service 153 40 0 0 0 0
1487 Solid Waste Disposal 257 483 565 136 301 0
itilities TOTAL 7,984 7,449 7,080 1,936 4,179 0
' ssssmsatis sasssasss sa=ss= :a= al=====as ssssa :sas :sassaaaa
1520 Buildings 0 0 0 0 331 0
:apital Outlays TOTAL 0 0 0 0 331 0
s=as=sam= sa :sssa :! as=sasssa s==ass :sa aasasaa :=
e
1702 Administrative Oery Trans 9 8,139 8,892 0 4,314 0
administrative Service. TOTAL 9,660 8,139 8,892 0 4,314 0
==aai!! == liailaati =!liiii == sisal =ass iii =i =im= aam=maa =a
1800 Inventory Variances 1,694 2;401 992 75 -283 0
1801 Merchandise Breakage 190 84 122 75 0 0
1802 Delivery Charge C. O. S. 3,409 4,238 3,987 950 1,341 0
1821 Liquor Cost of Sales '246,503 245,130 277,761 56,624 141,049 0
4822 Wine Cost of Sales 88,11'+ 83,209 90,713 17,786 44,013 0
4823 Beer Cost of Sales 390,403. 396,118 452,466 93,438 228,842 .0
4824 Non Tax Mix Cost of Sales 3,840 3,793 4,861 986 2,593 .0
a
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 10
.2001 BUDGET
' r
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
sassssssssssa :ssssasssssssssassss sssassmmsasssam ssss :sass: :ssss sasssasaaassss seas :seam :ms :s assssasasssmma mamacssasammma
4825 Taxable Mix Cost of Sales 10,578 9,225 11,165 2,226 5,551 0
4826 Misc Cost of Sales 33,668 26,553 35,853 7,282 18,264 0
Cost of Sales TOTAL' 778,+'.03 770,750 877,920 179,442 441,370 0
ssss :seas ssss: :sae masssssss : :ssss :a samsmsmmm amaasaaam
4920 Depreciation Expense 5,c54 15,628 22,525 10,541 4,816, 0
4922 I;oss Fixed Asset Disposal 0 8,236 0 0 0 0
Depreciation TOTAL 5,4.64 23,864 22,525 10,541 4,816 0
• smsmaass,aa sssssssss mssssssss mamssasam massssss: sasasasas
BOULEVARD LIQUOR TOTAL 944,505' 988,834 1,109,407 244,255 562,592 0
f: s i
CITY OF BROO. _.N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 11
.2001 BUDGET
2000 2001
abject Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
ss : :aasass :asss : :sasaassssssa :sss asssssssssasssj sssasssasssssas sssassssa :ssss ssasasssassass ssssss :aassaaa asa :ssaaa :ease
3IV NORTHBROOK LIQUOR 653
4100 Wages Regular Employees 44,720 48,208 49,488 58,215 30,541 64,313
4112 Overtime Regular Employee 0 0 209 0 0 0
4130 Wages Part -time Employees 49,732 51,516 58,153'` 63,098 35,804 65,121
1131 Overtime of Part -time Emp 5 168 309 0 570 0
1133 Vacation Pay J 2,091 2,703 2,648 0 2,548 0
1134 Holiday Pay 1,602 1,427 1,845 0 641 0
1135 Sick Leave Pay 609' 824 957 0 0 0
a
3alaries and Wages ,TOTAL 98,758 == 104,845 ss 113,610 121,3133 == .70,102 129,434
1142 PERA Coordinated Plan 4,039 4,808 .5,110 6,283 3,212 6,705
1143 PERA Police & Fire Plan 0 0 19 0 0- 0
4146 FICA 7,28 7, 8,312 9,280 5,192 9,902
1150 Employee Benefits 3,570 4,340 4,400 4,762 2,779 5,004
1151 Health Insurance 753 0 0 0 0 0
1152 Life Insurance 4 0 0 0 0 0
4153 Dental Insurance 4 0 0 0 0 0
1154 Workers Comp Insurance ,291 1,128 1,038 1,337 526 1,128
1156 Unemployment Compensation 1 0 529 0 308 0
Fringe Benefits TOTAL 15,973 17,924 19,409 21,662 12,016 22,739
sssssssas ='===sass ''=sa==ss sasssssss asssssaas sasaassaa
4210 Office Supplies 30 0 136 200 0 290
1217 Paper Supplies 15 34 47 500 0 540
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION„ Page 12
.2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
aaaaasmaasasaaaaa sa :ssassasssssaa s :sa :sssssssss: ssa :assssaaamaa ssmsassamssasa sas :oaasssssss ssssasmas :mass sssa :ammsmaamm
4220 Operating Supplies 2,514 3,219 3,511 3,565 2,438 3,570
4224 Clothing & Personal Equip 0 215 351 400 0 400
4230 Repair & Maint Supplies 34 89 156 500 0 500
4231 Equipment Parts '�9 0 0 0 0 0
4233'Building Repair Supplies 0 0 95. 0 209 0
4241 Laundry 178 178 354 490 115 500
4271 Minor Equipment s02 0 1,836 0 0 0
Supplies TOTAL 3,63 3,733 6,486 5,655 2,762 5,670
sssssssss sssssssss sssssssss sss :sssss :ssmaamsa samamasas
4310 Professional Services 105 188 0 250 0 300
4312 Legal Services 0 131 745 0 123 0
4313 Audit & Financial Service 798 825 750 650 638 708
Purchased Services TOTAL 903 1,144 1,495, 900 761 1,008
sssssssss sss"ssaa :sssa :sas as :sssssa saaassss: amassammm
4322 Telephone Services 1,562 1,603 1,634 1,575 1,005 1,580
4340 Advertising 0 216 0 0 0 500
4346 Advertising - Print' 1,125 1,039 2,072 11500 1,205 3,000
Communications TOTAL 2,687 2,858 3,706 3,075 2,210 5,080
sssssssss sssssssss sssssssss sssssssss saasmsaas smmasasmm
4380 Repair & Maint Contract 1,405 1,415 1,221. 1,500 0 1,500
4382 Equipment Repair & Maint 1,055 869 1,564 1,500 331 1,500
4383 Buildings Repairs 0 87 as 0 0 0
4388 Electrical Repairs 0 0 0 250 0 250
4392 Buildino Rentals 38,133 35,7, 37,213 39,000 22,978 . »A, 39,000
i
CITY OF BROO..: -N CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 13
.2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
aasaass : :as :asaaaasaaasaasass :sas sss :asssssssssa assassssss :saes ass :asassss :ss assess :asssa :s 'sssaa :s :sasses aaasaaaaaaaaaa
4397 Logis Charges 1,909 1,795 2,014, 2,582 1,657 3,025
4398 Protective Services 598 598 879 600 179 600
Repair Rental & Maint TOTAL 43,100 40,477 42,976 45,431 25,145 45,875
ss :assess sea :asses ssasasssg ::seas :ss ::::eases aasaaaaa:
4400 Other Contractual Service 200 353 417 1,000 74 1,000
4401 Credit Card Fees 1,153 1,915 3,821 3,000 2,635 4,000
4402 Uncollectible Checks -56 151 382 600 307 600
4403 Cash (Over) and Short 182 321 439 600 13 600
4404 Collection Fees 7 42 0 0 0 0
4405 Check Verification Fees 1,7 1 3,616 1,629 500 250 375
4411 Conferences and Schools 39 0 0 0 0 0
4413 Dues & Subscriptions 180 180 210 210 220 250
4414 Licenses, Taxes, & Fees 148 1 103 103 150 125 150
4421 Janitorial Service 91 16 69 0 21 100
Other Contractual Sery TOTAL 3,695 6,698 7,071 6,060 3,645 7,075
saasasse�s sssssssss sassssssa assssaasa ss :assess aaaaaaaaa
4440 Fuel Charges 73 82 80 102 89 100
4441 Fixed Charges 66 283 266 321 165 639
4442 Repair & Maint Charges 89 243 385 493 352 420
Central Garage Rentals TOTAL 827 608 731 916 605 1,159
ssaassses :sass: :as sasses sssessaa sea :asaa saaaassaa
4461 Gen Liability Insurance 65: 839 485 532 312 623
4462 Property Insurance 15A 235 283 300 176 37.0
4463 Machinery Breakdown Ins 30 32 64 50 37 100
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page 14
.2001 BUDG ET
2000 2001 /
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
ss aaaax axammassasasssasasssssssss ssssassmssssssm ssas :ss :s,isasss s :sssaaaasassa ssassassasass: as :asssamaxaas mmaaaaxxaaseax
4469 Liquor Liability Ins 4.376 2.372 2,141 2.608 1,128. 2,610
Insurance TOTAL 5,207 3,478 2,973 3,490 1,652 3,703
• sssssamas ssasssaas ssassssas sssssssss asmassa :s asxm :aaxa
4481 Electric Service 6 6,036 6,569 6,160 3,749 6,200
4482 Gas Service 620 613 590 1,000 395 1,500
4484 Water Service 29 0 0 0 0 0
4487 Solid Waste Disposal !15 545 545 545 324 550
Utilities TOTAL 8,049 7,194 7,705 7,705 4,468 8,250
ssssssanss sssssssss sssssssss sssssssss sssssssss saasesmss
4552 Other Equipment 0 0 0 10,000 22,189 0
Capital Outlays TOTAL 0 0 0 10,000 22,189 0
sssssssss sssssssss sssssssss :sssssses s :.sssfsss .sss : :aam
4725 Capital Proj Fund Trans 0 0 0 25,000 0 25,000
Transfer to other Fund TOTAL 0 0 0 25,000 0 25,000
A
ss :masse: saaa�sssss sssssssss sssassaas assasssna :asaaxaaa
4702 Administrative Sery Trans 11,340 10,174 9,912 9 6,578 9,533
Administrative Service TOTAL 11,340 X10,174 9,91n -, 9,345 6,578 9,533
sssssssss s :ssmms :s sssssssss saa :ss :ss ss :s :s : :a saaxxaass
4800 Inventory Variances 3,069 2,835 1,777 2, 100 614 2,100
4801 Merchandise'Breakage 228 0 108 250 0 250
4802 Delivery Charge C. O. S. 3,634 4,322 4,496 4,325 2,862 4,500
4821 Liquor Cost of Sales 264,176 293,023 327,916 262,087 169,471 262,087
4822 Wine Cost of Sales 77,711 80,463 85,236 72,176 41,382 72,176
4823 Beer Cost of Sales 468,251 535,354 589,356 482,887 304,901 482,887
4824 Non Tax-Mix Cost of Sales 3,904 4,3 5 3,820 2,426 a 3,820
`• CITY OF BRM..._N CENTER -
BUDGET REQUEST WORKSHEET BY DIVISION• Page 15
.2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
saasaaaaasssasassasa : :sssssasasas sasasssasasssaa asssssasssasasa asssassssssass ssssa :sssssssa sasassaas :sass ssasssaaaaaasa
4825 Taxable Mix Cost of Sales 11,301 12,927 13,606 11,506 •6,588 11,506
4826 Misc Cost of Sales 37,556 44,877 50,950 41,149 25,103 41,149
Cost of Sales TOTAL 869,830 978,108 1;078,454 880,300 553,348 880,475
sassassss s :ssa :sas =assassas sasssssss sssssaass s :aa :aaaa
4920.Depreciation Expense 6,805 6,023 6,023 8,000 682 5
Depreciation TOTAL 6,805 6,023 6,023 8,000 682 5,100
sasssssaa asssssass ssssssssa sasssaaas asssasaaa aaaaaasaa
q
NORTHBROOK LIQUOR TOTAL 1,070,809 1,183,262 1,300,549 1,148,852 706,164 1,150,101
t
- r
• s e
d
• • I
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION page 36
2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL, BUDGET 07/31/00 REQUESTED
= aaaaaaaaaasaaaaaaxaasssassamssss assssamasma :sss sssasssasaaasaa sssssmaamass :: ssaaa :saaaaaaa s :asammassaaas ns = =a = = = = = = =aa
DIV BROOKLYN CENTER LIQUOR 664
4100 Wages Regular Employees 0 0 0 101,309 13,208 125,599
4130 Wages Part -time Employees 0 0 0 69,023 10,484 100,788
4131 Overtime of Part -time Emp 0 0 0 0 25 0
Salaries and Wages TOTAL 0 0 0 170,332 23,718 226,387
' saaaasmss ssasssssa' ssssssaas ssssssass ssssaaaaa sssaaa =m=
4142 PERA Coordinated Plan 0 0 U 0 8,823 1,136 11,727
4146 FICA 0 0 0 13,030 1,885 17,319
4150 Employee Benefits 0 0 0 12,143 1,142 15,012
4154 Workers Comp 'Insurance 0 0 0 1,906 179 1,991
4158 Disability Insurance 0 0 0 204 31 0
Fringe Benefits TOTAL 0 0 0 36,106 4,372 46,049
asssaaasa sasssmssa ssssassss ssssssssa ssasaasaa = :aaaa==a
4210 Office Supplies 0 c ° 0 0 _225 0 250
4217 Paper Supplies 0 0 0 450 0 500
4220 Operating Supplies 0 0 0 7,000 1,752 7,000
4224 Clothing & Personal Equip 0 0 0 500 604 750
4230 Repair & Maint Supplies 0 0 0 . 500 0 • 500
4240 Small Tools 0 0 0 0 421 0
4241 Laundry 0 0 0 750 0 750
Supplies TOTAL 0 0 0 9,425 2,776 9,750
sass:: : :s ssasaassa saasas :as sssassam: ssamaasaa amaaaasaa
4310 Professional Services 0 0 0 1,200 5,820 0
4313 Audit & Financial Service 0 0 1,300 0 ,,,. 1,280
N.
CITY OF BROO. -N CENTER -
BUDGET REQUEST WORKSHEET BY DIVISION Page 17
2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
meaaaaaaamasaasssseamaasssss :seas sssssesasesasss asssemasesesssa ssseassssssesa : :sass :::sass: is esassisaaa :m ssaameaamaaasa
Purchased'Services TOTAL •0 0 0 2,500 5,820 1,280
sssesasa.ur sssssssss esseeeess sssssssss ssssasssa saaaaaaaa
4322 Telephone Services 0 0 0 3,000 1,064 3,000
4340 Advertising .0 0 0 1,500 0 0
4346,Advertising - Print 0 0 0 3,000 1,514 6,000
- ommunications TOTAL 0 0 0 7,500 2,578 9,000
sss :asses ssssasssa sassassss ssssasssa sassassss aseaasmsa
4382 Equipment Repair & Maint 0 0 0 500 0 500
4392 Building Rentals 0 0 0 117,600 14,915 117,600
4397 Logis Charges, 0 0 0, 3,559 0 5,468
4398 Protective Services 0 0 0 600 0 600
Repair Rental & Maint TOTAL 0 0 0' 122,259 14,915 124,168
sseassss sssssssss sssssssss,i aasasass sssessa� a :assess
4400 Other Contractual Service ,10 e 0 0 1,000 7 1,000
. AP
4401 Credit Card Fees 0 0 0 6,000 0 12,000
4402 Uncollectible Checks 0 0 0 500 0 500
4403 Cash (Over) and Short 0 0 0 900 -29 900
4405 Check Verification Fees 0 0 0 375 0 1,125•
4411 Conferences and Schools 0 0 0 210 0. 0
4413 Dues & Subscriptions 0 0 0 150 400 400
4414 Licenses, Taxes; & Fees 0 0 0 0 145 0
4421 Janitorial Service 0 0 0 1,200 51 300
Other Contractual Sery TOTAL 0 0 0 10,335 575 16,2x5
s ::sasses ss :aa :sss ssssasssa assess: :s ss:sesaae ssaoaaasa
t ,
CITY OF BROOKLYN CENTER
BUDGET REQUEST WORKSHEET BY DIVISION Page .18
2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 01/31/00 REQUESTED
sasi saaasaassss :s :assassssssassssa mssssassasaaasa ssaaa :sosasssaa sabers :::::seas ss :aaoass :aasa mmasmmsamaaams assoaasmeamaaa
4440 Fuel Charges 0 0 0 160 23 175
4441 Fixed Charges 0 0 0 480 31 1,155
4442 Repair & Maint Charges 0 0 0 740 178 759
Central Garage Rentals TOTAL 0 0 0 1,380 232 2,089
sssssssss sssssssss msssss :sm sass:: : :s aosssasma sammsammm
4461 Gen Liability Insurance 0 0 0 689 0 1,140
4462 Property Insurance 0 0 a 0 450 0 600
4463 Machinery Breakdown Ins 0 0 0 125 0 200
4469 Liquor Liability Ins 0 0 0 4,262 0 4,901
Insurance TOTAL 0 0 0 5,526 0 6,841
• massmm�rss sssssssss msmsmssss sssssssss mmmasssss :ssaaamss
4481 Electric Service 0 0 0 6,000 203 6,000
4482 Gas Service 0 0 0 2,000 0 2,000
4487 Solid Waste Disposal 0 ��° 0 0 410 574 410
Utilities TOTAL. ;0 0 0 8,410 776 8,410
aassmmsmm maamaaa :a assasseas mm : : : :a :s smaaaemaa aaasmssam
4520 Buildings 0 0 0 0 60,348 0
4,550 Furniture & Fixtures 0 0 0 0 277 0
4552 Other Equipment 0 0 0 0 123,907 0
Capital Outlays TOTAL 0 0 0 0 184,532 0
ssssssssr sssssssss sssssssss sssssssss mmmsssmmm mama smm no
4725 Capital Proj Fund Trans 0 0• 0 50,000 0 50,000
Transfer to other Fund TOTAL 0 0 0 50,000 0 50,000
msssss: :m massasass sasmsmsra msssssm�m mssmssasm saaaammmm
4702 Administ native Sery Trans 0 ,••�•,� 0 16,141 969 U rn.•, q 17, 228
4
CITY OF BROO,. A CENTER
.J ••
BUDGET REQUEST WORKSHEET BY DIVISION Page 19
.2001 BUDGET
2000 2001
Object Code & Description 1997 1998 1999 ADOPTED AS OF DEPT
Division Code & Description ACTUAL ACTUAL ACTUAL BUDGET 07/31/00 REQUESTED
aamaaass :ma :ammmmamaasssossssssaa :sssasssaa :asaa sasaasmsss :ease asasaasssassss assasaasssasas ssasssaaaaasam ssssaaasammmmm
Administrative Service TOTAL .0 0 0, 16,141 969 17,228
. sssssssas sas :sasas sasssaams smasasssa ssaasa :a: maammm :am
4800 Inventory Variances 0 0 0 900 0 1,200
r
R
4801 Merchandise Breakage 0 0 0 500 0 500
4802,Delivery Charge C. O. S. •0 0 0 8,643 1,737 8,700
4821 Liquor Cost of Sales 0 0 0 450,702 0 518,307
4822 Wine Cost of Sales 0 0 0, 159,236 0 183,122
4823 Beer Cost of Sales 0 0 0 721,618 0 829,861
4824 Non Tax Mix Cost of Sales •0 0 0 7,640 0 8,403
4825 Taxable Mix Cost of Sales 0 0 0 19,745 0 22,566
4826 Misc Cost of Sales 0 0 0 63,362 0 72,830
Cost of Sales TOTAL 0 0 0 1,432,346 1,737 1,645,489
• sssaossss :ssasssss :ssssssa: ssaaassaa asassaaas aasaaaasa
4920 Depreciation Expense 0 4 0 0 20000 0 28,700
Depreciation TOTAL 0 0 0 20,000 0 28,700
sasssaaais sssssasss sssasasas sssssssas saassssaa am---aaas
BROOKLYN CENTER LIQUOR TOTAL 0 0 0 1,892,260 243,000 2,191,616
LIQUOR STORES FUND TOTAL 2,937,902 3,105,528 3,404,853 3,55 1,885,951 3,341,717
4
r