102201 Liquor Comm AgP
'i
Meeting Notice
The ShorewoodLiquor Committee
will meet
Monday, October 22,2001 at 5:30 p.m.
in the Conference Room
5755 Country Club Road
Shorewood, MN
The purpose of this meeting is to discuss the status of the liquor operations.
A majority of the City Council members may be present at this meeting.
Craig W. Dawson,
City Administrator/Clerk
CITY OF SHOREWOOD
5755 COUNTRY CLUB ROAD
LIQUOR COMMITTEE MEETING
MONDAY, OCTOBER 22, 2001
5:30 P.M.
AGENDA
1. REVIEW 2002 LIQUOR STORE BUDGETS
2. LEASE UPDATES-TONKABAY ANDWATERFORD STORES
3. OTHER BUSINESS
4. ADJOURN
\
,
" t
~
l
,,"'"
,;cl
CITY OF SHOREWOOD,
MINNESOTA
2002 LIQUOR OPERATIONS BUDGET
October 17, 2001
~~..
~~
FUND:
Liquor
SUBFUND:
FUND NO:
640
DESCRIPTION <?F ACTIVITY:
MISSION:
To control the sale and distribution of
packaged alcholic beverages within the
City and to provide property tax relief
the use of operation profits.
Provides for the sale of packaged alcoholic beverages to the general public.
OBJECTIVES:
- Effectively control the sale of packaged alcoholic beverages in the City
- Reduce rent in Waterford Store through reduction of floor space
- Produce a reasonable net profit
- Find a new location for Tonka Bay Store
- Remodel Plaza Store
HIGHLIGHTS/COMMENTS'
Revenues:
Estimated liquor sales: approximately the same as 2001
Expenses:
Staffing:
1.00 Operations Manager
5.00 Assistant Managers
.15 Senior Accounting Clerk
14.00 Part time Sales Clerks
Supplies/Materials:
Office Supplies, Bags, Postage
Services & Charges:
Finance and Auditing Services
Contractual Rug Service
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental
Advertising
Credit Card Service Charges
Leasing:
Possible down-sizing of Waterford Store has potential
of reducing lease expense by est $30,000 annually
Capital Outlay: Shorewood Plaza Store Improvements ($40,000)
Transfers Out:
Transfer to General Fund
Misc. Revenue/Expenditures:
Interest Income & Service Charges
2
.
bbA...~... '
'~Pt
FUND: # 640 SUBFUND: Liquor Operations
BUDGET Actual Actual Budget YTD Aug Annual Proposed
ITEM 1999 2000 2001 2001 Est-01 2002
REVENUE
Sales 2.320,164 2,532.379 2,863,000 1 ;703.992 2,555,988 2,692,130 0
Cost of Goods 1.837.915 1,888.069 2.204,510 1,110.710 1.841.871 2,034,864 0
GROSS PROFIT 482,249 644,310 658,490 593.283 714,117 657.266 0
EXPENSES
Staffing 211.786 259,076 287,230 186,485 279.727 302.702 0
Supplies/Materials 12,909 14,854 13,325 9,885 14.827 11,325 0
Services & Charges 232,762 251.081 275.535 174,695 262.042 255,195 0
Depreciation 9.489 6.609 9,490 5.456 8,184 6,770 0
Capital Outlay 0 0 50,000 8,992 9,000 40.000 0
TOTAL EXPENSES 466.946 531,620 635,580 385,512 573,780 615.992 0
TOTAL OPERATING INCOME (LOSS) 15.303 112,690 22,910 207.771 140,338 41 ,274 0
Transfers In/(Out) 0 (10.000) (10.000) 0 (10.000) (30,000) 0
Misc. Revenue/(Expense) 14,916 22.195 9,400 (4,876) 12,500 10,000 0
NET INCOME (LOSS) 30.219 124,885 22,310 202,895 142.838 21,274 0
SERVICE INDICATORS:
Gross Profit as a % of Sales 20.79% 25.44% 23.00% 34.82% 27.94% 24.41%
Oper. Income as a % of Sales 0.66% 4.45% 0.80% 12.19% 5.49% 1.53%
CASH FLOW IMPACT:
Beginning Cash Balance 44,590 190,317 152,510 147,602 171,766 195.410 195.410
Net Operating Income/Loss 8,834 112.690 22.910 207.771 140,338 41.274 0
Depreciation 9,489 6,609 9,490 5,456 8.184 6,770 0
Other Cash Flow Impacts 127,404 (157,106) 10.500 11 .180 12,200 (800) 0
Ending Cash Balance 190.317 152,510 195,410 372,008 332,488 242.654 195.410
STAFFING:
Full time:
Operations Manager 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Assistant Manager 3.00 3.00 3.00 3.00 3.00 3.00 3.00
Sr. Acctg. Clerk .15 .15 .15 .15 .15 .15 .15
Part time:
Sales Clerks 15.00 15.00 15.00 15.00 15.00 15.00 15.00
3
FUND:
Liquor
SUBFUND:
Shorewood Plaza
FUND NO:
641
DESCRIPTION OF ACTIVITY:
MISSION'
To control the sale and distribution of
packaged alcholic beverages within the
City and to provide property tax relief
the use of operation profits.
Provides for the sale of packaged alcoholic beverages to the general public.
OBJECTIVES:
- Effectively control the sale of packaged alcoholic beverages in the City
- Provide a profit equal to at least 2% of sales for transfer to the General Fund
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales
Expenses:
Staffing:
.33 Operations Manager
2.20 Assistant Manager
.05 Senior Accounting Clerk
5.00 Part time Sales Clerks
Supplies/Materials:
Office Supplies, Postage, Equipment Repair. Bags
Services & Charges:
Finance and Auditing Services
Contractual Rug Service
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental
Advertising
Credit Card Service Charges
Capital Outlay:
Counter, carpet, paint, gondolas $40,000
Misc. Revenue/Expenditures:
Interest Income & Service Charges
4
(
FUND: # 641 SUBFUND: Liquor - Shorewood Plaza DEPT #
BUDGET Actual Actual Budget YTD Aug Annual Proposed Adopted
ITEM 1999 2000 2001 2001 Est-01 2002 2002
REVENUE
Sales 978,818 1,093,956 1,210,000 701,703 1,052,554 1,115,500 0
Cost of Goods 792,228 810,884 931,700 436,048 654,071 836.625 0
GROSS PROFIT 186.590 283,072 278,300 265.655 398,483 278,875 0
EXPENSES
Staffing 75,238 101,236 103,821 69,116 103,674 116,819 0
Supplies/Materials 7,149 6.127 6.275 3,496 5,244 4,975 0
Services & Charges 76,905 90,187 95,250 62,240 93,360 96,395 0
Depreciation 1,365 244 1.365 280 420 420 0
Capital Outlay 0 0 50.000 8,992 9,000 40,000 0
TOTAL EXPENSES 167,126 197,794 256,711 144.124 211,698 258.609 0
NET OPERATING INCOME (LOS 19,464 85,278 21,589 121.531 186,784 20,266 0
Transfers In/(Out) 0 (5,000) (10,000) 0 (10,000) (15,000) 0
Misc. Revenuel(Expense) 9,285 14,813 5,000 (726) 10.000 10,000 0
NET INCOME (LOSS) 28,749 95,091 16,589 120.804 186,784 15.266 0
BUSINESS INDICATORS:
Gross Profit as a % of Sales 19.06% 25.88% 23.00% 37.86% 37.86% 25.00%
Oper. Income as a % of Sales 1.99% 7.80% 1.78% 17 .32% 17.75% 1.82%
CASH FLOW IMPACT:
Beginning Cash Balance 132.349 229,346 245,354 245,354 245,354 272,808 272,808
Net Operating Income/(Loss) 19,464 85,278 21,589 121.531 186,784 20,266 0
Depreciation 1,365 244 1,365 280 420 420 0
Other Cash Flow Impacts 76,168 (69,514) 4,500 4,500 5,000 (5.000)
Ending Cash Balance 229,346 245,354 272,808 371,665 437,558 288,494 272,808
STAFFING:
Full time:
Operations Manager .33 .33 .33 .33 .33 .33 .33
Assistant Manager 1.00 1.00 1.00 1.00 1.00 2.20 2.20
Sr. Acctg. Clerk .05 .05 .05 .05 .05 .05 .05
Part time:
Sales Clerks 6.00 5.00 5.00 5.00 5.00 5.00 5.00
5
FUND NO:
642
MISSION:
To control the sale and distribution of
packaged alcholic beverages within the
City and to provide property tax relief
the use of operation profits.
FUND:
Liquor
SUB FUND:
Waterford
DESCRIPTION OF ACTIVITY'
Provides for the sale of packaged alcoholic beverages to the general public.
OBJECTIVES:
- Effectively control the sale of packaged alcoholic beverages in the City
- Decrease operating loses through the reduction of leased floor space
HIGHLIGHTSfCOMMENTS:
Revenues:
Estimated liquor sales
Expenses:
Staffing:
.33 Operations Manager
1.40 Assistant Manager
.05 Senior Accounting Clerk
5.00 Part time Sales Clerks
SuppliesfMaterials:
Office Supplies, Postage, Equipment Repair, Bags
Services & Charges:
Finance and Auditing Services
Contractual Rug Service
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental - reduced through reduction in floor space
Advertising
Credit Card Service Charges
Capital Outlay:
Misc. RevenuefExpenditures:
Interest Income & Service Charges
6
FUND NO:
643
MISSION:
To control the sale and distribution of
packaged alcholic beverages within the
City and to provide property tax relief
the use of operation profits.
FUND:
Liquor
SUB FUND:
Tonka Bay
DESCRIPTION OF ACTIVITY:
Provides for the sale of packaged alcoholic beverages to the general public.
This location was acquired in December, 1994.
OBJECTIVES:
- Effectively control the sale of packaged alcoholic beverages in the City
- Provide a profit equal to at least 2% of sales for transfer to the General Fund
HIGHLIGHTS/COMMENTS:
Revenues:
Estimated liquor sales
Expenses:
Staffing:
.33 Operations Manager
1.40 Assistant Manager
.05 Senior Accounting Clerk
4.00 Part time Sales Clerks
Supplies/Materials:
Office Supplies, Postage, Equipment Repair, Bags
Services & Charges:
Finance and Auditing Services
Contractual Rug Service
General and Liquor Liability Insurance
Electric & Gas Utilities, and Refuse Hauling
Building Rental
Advertising
Credit Card Service Charges
Capital Outlay:
Misc. Revenue/Expenditures:
Interest Income & Service Charges
8
" ~
FUND: # 643 SUB FUND: Liquor - Tonka Bay DEPT #
, BUDGET
Actual Actual Budget YTD Aug Annual Proposed Adopted
ITEM 1999 2000 2001 2001 Est-01 2002 2002
REVENUE
Sales 638,082 727,990 819,500 506,912 760,367 793,450 0
Cost of Goods 515,602 537,925 631,015 337,021 604,492 603,022 0
GROSS PROFIT 122,480 190,065 188,485 169,890 155,875 190,428 0
EXPENSES
Staffing 72,849 85,655 95,200 65,862 98,793 96,814 0
Supplies/Materials 2,548 4,707 2,325 2,978 4,466 2.925 0
Support Services 42,500 49,397 54,635 30,798 46,197 70,545 0
Depreciation 250 549 250 1,360 2.040 550 0
Capital Outlay 0 0 0 0 0 0 0
TOTAL EXPENSES 118.147 140,307 152,410 100,998 151,497 170,834 0
TOTAL OPERATING INCOME 4,333 49,758 36,075 68.892 4,378 19.594. 0
Transfers In/(Out) 0 (5,000) 0 0 0 (15,000) 0
Misc. Revenue/(Expense) 4,723 8,293 4,400 (691 ) 6,000 0 0
NET INCOME/(LOSS) 9,056 53,051 40,475 68.201 10.378 4,594 0
BUSINESS INDICATORS:
Gross Profit as a % of Sales 19.20% 26.11 % 23.00% 33.51 % 20.50% 24.00%
Oper. Income as a % of Sales 0.68% 6.83% 4.40% 13.59% .0.58% 2.47%
CASH FLOW IMPACT:
Beginning Cash Balance 79.045 110,690 115,598 110,690 110,690 154,923 154,923
Net Operating Income/(Loss) 4,333 49.758 36.075 68,892 4.378 19,594 0
Depreciation 250 549 250 1,360 2,040 550 0
Other Cash Flow Impacts 27,062 (45,399) 3,000 3,680 4,200 4,200
Ending Cash Balance 110,690 115,598 154,923 184,622 121,308 179,267 154,923
STAFFING:
Full time:
Operations Manager .33 .33 .33 .33 .33 .33 .33
Assistant Manager 1.00 1.00 1.00 1.00 1.00 1.40 1.40
Senior Acct. Clerk .05 .05 .05 .05 .05 .05 .05
Part time:
Sales Clerks 4.00 4.00 4.00 4.00 4.00 4.00 4.00
9