Loading...
102504 Liquor Comm AgP CITY OF SHOREWOOD Conference Room 5755 Country Club Road LIQUOR COMMITTEE MEETING MONDAY, OCTOBER 25, 2004 6:00 PM AGENDA 1. LIQUOR STAFFING 2. 2005 LIQUOR BUDGET 3. OTHER 4. ADJOURN A majority of the City Council members may be present at this meeting. FUND NO: 640 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 SUBFUND: 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 - Produce a reasonable net profit HIGHLIGHTS/COMMENTS: Revenues: Estimated liquor sales for two stores. Expenses: Staffing: 1.00 Operations Manager 1.00 Assistant Managers 2.00 Full Time Clerks .15 Senior Accounting Clerk 10.00 Part time Sales Clerks Supplies/Materials: Office Supplies, Bags, Postage Services & Charges: Finance and Auditing Services Consulting Services include a marketing study for the former Tanka Bay Store General and Liquor Liability Insurance Electric & Gas Utilities, and Refuse Hauling Building Rental Advertising Credit Card Service Charges Capital Outlay: To Be Determined Transfers Out: Transfer to General Fund Misc. RevenuelExpenditures: Interest Income & Service Charges FUND: # 640 SUBFUND: Liquor Operations (Shorewood Village & Waterford) DEPT # BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 2002 2003 2004 2004 2005 2005 REVENUE Sales 2,622,145 2,507,063 2,224,045 1,624,743 2,283,500 0 Cost of Goods 1,962,099 1,829,854 1,645,909 1,168,415 1,678,740 0 GROSS PROFIT 660,046 677,209 578,136 456,327 604,760 0 EXPENSES Staffing 290,934 302,702 272,477 190,570 281,267 0 Supplies/Materials 12,912 11,325 8,000 7,340 7,150 0 Services & Charges 258,685 232,728 196,830 165,707 222,820 0 Depreciation 9,662 10,085 14,800 29,293 36,960 0 Capital Outlay 0 40,000 20,000 465 21,500 0 TOTAL EXPENSES 572,193 596,840 512,107 393,376 569,697 0 TOTAL OPERATING INCOME (LOSS) 87,853 80,369 66,029 62,952 35,063 0 Other Sources 4.502 10,680 30,000 3,122 20,000 0 Other Uses 10,000 30,000 0 668 50,000 0 NET INCOME (LOSS) 82,355 61,048 96,029 65,406 5,063 0 SERVICE INDICATORS: Gross Profit as a % of Sales 25.17% 27.01% 25.99% 28.09% 26.48% Oper. Income as a % of Sales 3.35% 3.21% 2.97% 3.87% 1.54% CASH FLOW IMPACT: Beginning Cash Balance Net Operating Income/Loss Depreciation Other Cash Flow Impacts Ending Cash Balance STAFFING: Full time: Operations Manager 1.00 1.00 1.00 1.00 1.00 1.00 Assistant Manager 3.00 3.00 2.00 2.00 2.00 2.00 Full Time Clerk 1.00 1.00 1.00 1.00 Sr. Acctg. Clerk .15 .15 .15 .1~ .15 .15 Part time: Sales Clerks 15.00 15.00 15.00 15.00 10.00 10.00 . FUND: #640 FUND: Liquor DEPT #49750 BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 2002 2003 2,004 2004 2005 2005 SALES 37811 Liquor 787,200 754,840 674,400 489,198 689,000 0 37812 Wine 618.992 579,589 595,000 424,319 638,000 0 37813 Beer 1,095,632 1,061,568 868,000 654,189 880,000 0 37814 Miscellaneous 120,321 111,066 86,645 57,036 76,500 0 TOTAL SALES 2,622,145 2,507,063 2,224,045 1,624,743 2,283,500 0 COST OF GOODS SOLD 251 Liquor 600,838 572,013 522,000 360,843 504,500 0 252 Wine 424,592 394,077 412,000 282,706 430,000 0 253 Beer 839,677 791,961 665,000 488,745 683,290 0 254 Miscellaneous 96,991 71,803 46,909 36,122 60,950 0 TOTAL COST OF GOODS SOLD 1,962,099 1,829,854 1,645,909 1,168,415 1,678,740 0 GROSS PROFIT 660,046 677,209 578,136 456,327 604,760 0 EXPENSES 0.74828 0.72988 0.74005 0.71914 0.73516 PERSONAL SERVICES 101 Regular Salaries 162,358 166,010 159,378 117,202 167,503 0 102 O.T. Salaries 164 343 0 0 0 0 103 Part Time Salaries 79,719 72,541 55,600 38.649 57,000 0 121 PERA City Share 9,758 12,860 10,750 8,538 12,897 0 122 FICA City Share 18,429 17,866 11,780 11,891 17,159 0 131 Ins. City Share 19,548 21,651 34,969 14,271 26,708 0 141 Unemployment Comp 311 14 0 20 0 151 Workers Comp 648 3,201 0 0 0 Total 290,934 302,702 272,477 190,570 281,267 0 SUPPLIES 200 Office Supplies 1,205 1,170 700 .672 600 0 201 Postage 34 0 200 0 50 0 221 Maint-Equipment 4,939 5,420 3,500 2,925 3,000 0 223 Maint-Buildings 1,658 923 0 480 0 0 245 General Supplies 5,076 5,451 3,600 3,264 3,500 0 Total 12,912 11 ,325 8,000 7,340 7,150 0 OTHER SERVICES 301 Audit & Accounting 4,148 4,715 2,850 2,800 2,850 0 302 Consulting Fees 0 0 0 4,667 0 0 304 Legal 1,158 3,039 0 0 0 0 321 Communication 4,945 3,983 3,000 1,617 3,000 0 331 Travel, Conf,Sch 2,908 1,486 1,600 524 1,200 0 342 Advertising & Promo 10,374 7,694 8,000 6,880 12,000 0 351 Print/Publish 342 0 240 82 100 0 360 Insurance-Total 12,597 13,512 19,000 10,902 16,000 0 380 Utilities-Gas/Elec 24,309 20,541 15,400 13,424 18,000 0 400 Contractual 2,962 2,221 1,700 1 ,427 1,700 0 410 Rent 167,433 149,171 125,000 99,371 141,500 0 420 Depreciation 9,662 10,085 14,800 29,293 36,960 0 432 Uncollectible Checks 4,504 2,849 1,000 0 1,000 0 433 Dues & Subscriptions 640 695 500 1,530 1,530 0 437 TaxeslLicenses 1,360 1,250 540 1,020 540 0 440 Mise Services 0 100 0 62 0 0 FUND: #640 FUND: Liquor DEPT #49750 BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 2002 2003 2,004 2004 2005 2005 445 Credit Card Fees 21,006 21,472 18,000 21 ,402 23,400 0 Total 268,347 242,813 211,630 195,000 259,780 0 CAPITAL OUTLAY 560 Furniture & Fixtures 0 0 20,000 465 21 ,500 0 Total 0 40,000 20,000 465 21,500 0 TOTAL EXPENSES 572,193 596,840 512,107 393,376 569,697 0 TOTAL OPERATING INCOME/(LOSS) 87,853 80,369 66,029 62,952 35,063 0 Other Sources 4,502 10,680 30,000 3,122 20,000 0 Other Uses 10,000 30,000 0 668 50,000 0 NET INCOME/(LOSS) 82,355 61,048 96,029 65,406 5,063 0 - FUND: #640 FUND: LIQUOR HIGHLIGHTS/COMMENTS: Revenues: Estimated liquor sales less cost of goods sold Expenses: Staffing: 1.00 Operations Manager 1.00 Assistant Managers 2.00 Full Time Clerks .15 Senior Accounting Clerk 10.00 Part time Sales Clerks Supplies/Materials: Office Supplies, Bags, Postage Other Services: Finance and Auditing Services Consulting Services General and Liquor Liability Insurance Electric & Gas Utilities, and Refuse Hauling Building Rental Advertising Credit Card Service Charges Depreciation Capital Outlay: Misc. Revenue/Expenditures: Interest Income & Service Charges FUND NO: 641 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 SUBFUND: Shorewood Plaza 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 - Provide a profit equal to at least 2% of sales for transfer to the General Fund HIGHLIGHTS/COMMENTS: Revenues: Estimated liquor sates Expenses: Staffing: .50 Operations Manager 2.00 Full Time Clerk II 6.00 Part time Sales Clerks .05 Senior Accounting Clerk SupplieslMaterials: 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: Computer inventory & accounting software systems (2005) Misc. Revenue/Expenditures: Interest Income & Service Charges FUND: # 641 SUBFUND: Liquor - shorewood Plaza DEPT # BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 2002 2003 2004 2004 2005 2005 REVENUE Sales 986,844 931,324 1,367,445 986,022 1,370,000 0 Cost of Goods 714,346 687,760 1,011,909 702,530 1,006,950 0 GROSS PROFIT 272,499 243,564 355,536 283,492 363,050 0 EXPENSES Staffing 104,673 120,185 159,510 108,060 162,205 0 Supplies/Materials 4,967 5,178 4,000 4,031 3,825 0 Services & Charges 86,660 98,734 103,565 89,382 120,81Q 0 Depreciation 3,188 9,n7 10,000 25,429 33,573 0 Capital Outlay 0 0 20,000 16,825 11,500 0 TOTAL EXPENSES 199,487 233,874 297,075 243,726 331,913 0 NET OPERATING INCOME (LOSS) 73,011 9,690 58,461 39,766 31,137 0 Other Sources 11,740 15,000 25,000 3,122 15,000 0 Other Uses 15,000 0 0 0 40,000 0 NET INCOME (LOSS) 69,752 24,690 83,461 42,888 6,137 0 BUSINESS INDICATORS: Gross Profit as a % of Sales 27.61 % 26.15% 26.00% 28.75% 26.50% #DIV/OI Oper. Income as a % of Sales 7.40% 1.04% 4.28% 4.03% 2.27% #DIV/Ol CASH FLOW IMPACT: Beginning Cash Balance 287,570 294,255 318,222 294,255 318,222 318,222 Net Operating Income/(Loss) 73,011 9,690 58,461 39,766 31,137 0 Depreciation 3,188 9.n7 10,000 25,429 33,573 0 Other Cash Flow Impacts (69,514) 4,500 4,500 4,500 (5,000) (5,000) Ending Cash Balance 294,255 318,222 391,183 363,950 3n,932 313,222 STAFFING: Full time: Operations Manager .33 .33 .33 .33 .50 .50 Assistant Manager 1.00 1.00 1.00 1.00 .00 1.00 Full Time Clerk II 2.00 1.00 Sr. Acctg. Clerk .05 .05 .05 .05 .05 .05 Part time: Sales Clerks 5.00 5.00 5.00 5.00 5.00 5.00 FUND: #641 SUBFUND: Liquor - Shorewood Plaza DEPT #49750 BUDGET Actual Actual Budget vrD Sept Proposed Adopted ITEM 2002 2003 2004 2004 2005 2005 SALES 37811 Liquor 321,756 299,019 431,400 304,509 425,000 37812 Wine 267,nO 260,154 393,000 274,132 411,000 37813 Beer 361,024 337,525 493,000 376,697 493,000 37814 Miscellaneous 36,296 34,626 50,045 30,684 41,000 TOTAL SALES 986,844 931,324 1,367,445 986,022 1 ,370,000 0 COST OF GOODS SOLD 251 Uquor 239,297 229,456 332,000 223,513 313,000 252 Wine 180,520 173,965 272,000 180,828 280,000 253 Beer 268,470 258,307 380,000 279,301 382,000 254 Miscellaneous 26,058 26,033 27,909 18,887 31,950 TOTAL COST OF GOODS SOLD 714,346 687,760 1,011,909 702,530 1,006,950 0 GROSS PROFIT 272,499 243,564 355,536 283,492 363,050 0 EXPENSES 0.71249 PERSONAL SERVICES 101 Regular Salaries 56,360 76,314 94,413 66,675 95,700 102 O.T. Salaries 8 0 103 Part Time Salaries 28,160 22,852 30,600 21,617 32,000 121 PERA City Share 4,553 5,097 6,251 4,829 7,325 122 FICA City Share 6,339 7,295 7,752 6,638 9,746 131 Ins. City Share 7,640 6,762 20,494 8,282 17,434 141 Unemployment Comp 14 152 0 20 0 151 Workers Comp 1,600 1,713 0 0 0 Total 104,673 120,185 159,510 108,060 162,205 0 SUPPLIES 200 Office Supplies 399 627 400 451 300 201 Postage 100 25 221 Maint-Equipment 1,560 1 ,405 1,500 1,300 1,500 223 Maint-Buildings 746 50 0 155 0 245 General Supplies 2,261 3,097 2,000 2,125 2,000 Total 4,967 5,178 4,000 4,031 3,825 0 OTHER SERVICES 301 Audit & Accounting 1,572 1 ,423 1 ,425 1,400 1 ,425 302 Consulting Fees 0 2,333 0 304 Legal 706 354 0 0 321 Communication 1,543 1,540 1,500 n8 1,500 331 Travel, Conf,Sch 512 440 800 282 600 342 Advertising & Promo 2,515 4,492 4,000 2,936 6,000 351 PrintlPublish 79 120 41 50 360 Insurance-Total 4,309 7,267 9,500 5,451 8,000 380 Utilities-GaslElec 7,286 8,331 9,000 8,095 11,000 400 Contractual 949 6,712 1,200 876 1,200 410 Rent 56,971 53,166 65,000 51,854 74,500 420 Depreciation 3,188 9,n7 10,000 25,429 33,573 432 Uncollectible Checks 838 2,827 500 0 500 433 Dues & Subscriptions 247 765 250 765 765 437 Taxes/Licenses 500 520 270 520 270 440 Misc Services 0 41 0 33 0 445 Credit Card Fees 8,714 10,n8 10,000 14,016 15,000 Total 89,848 108,511 113,565 114,810 154,383 0 FUND: #641 SUBFUND: Liquor - Shorewood Plaza DEPT #49750 BUDGET Actual Aetual Budget YTD Sept Proposed Adopted ITEM 2002 2003 2004 2004 2005 2005 CAPITAL OUTLAY 520 Buildings & Structures 16,360 560 Fumiture & Fixtures 0 0 20,000 465 11,500 Total 0 0 20,000 16,825 11,500 0 TOTAL EXPENSES 199,487 233,874 297,075 243,726 -331,913 0 TOTAL OPERATING INCOME/(LOSS) 73,011 9,690 58,461 39,766 31,137 0 NET INCOME/(LOSS) 73,011 9,690 58,461 39,766 31,137 0 OTHER SOURCES Transfers In 15,000 25,000 0 Mise Revenue 11,740 3,122 15,000 Total 11,740 15,000 25,000 3,122 15,000 0 OTHER USES Transfers Out 15,000 40,000 Mise Expense Total 15,000 0 0 0 40,000 0 NET INCOME/(LOSS) 69,752 24,690 83,461 42,888 6,137 0 . FUND: #641 SUBFUND: Liquor - Shorewood Plaza HIGHLIGHTS/COMMENTS: Revenues: Estimated liquor sales Expenses: Staffing: .50 Operations Manager 2.00 Full Time Clerk II 6.00 Part time Sales Clerks .05 Senior Accounting Clerk Supplies/Materials: Office Supplies, Bags, Postage Other Services: Finance and Auditing Services Contractual Rug Service General and Liquor Liability Insurance Electric & Gas Utilities, and Refuse Hauling Building Rental Advertising Credit Card Serviee Charges Depreciation Capital Outlay: Completely remodeled store in 2003 Computer inventory & accounting software systems (2004) FUND NO: 642 MISSION: To control the sale and distribution of packaged alchollc beverages within the City and to provide property tax relief the use of operation profits. FUND: Liquor SUBFUND: 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 HIGHLIGHTS/COMMENTS: Revenues: Estimated liquor sales Expenses: Staffing: .50 Operations Manager 1.00 Assistant Manager 4.00 Part time Sales Clerks .05 Senior Accounting Clerk 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 - reduced through reduction in floor space Advertising Credit Card Service Charges Capital Outlay: Remodel Misc. Revenue/Expenditures: Interest Income & Service Charges FUND: # 642 SUB FUND: Liquor - Waterford DEPT # BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 2002 2003 2004 2004 2005 2005 REVENUE Sales 792,260 841,374 856,600 638,721 913,500 0 Cost of Goods 575,759 615,141 634,000 465,886 671,790 0 GROSS PROFIT 216,501 226,233 222,600 172,835 241,710 0 EXPENSES Staffing 97,522 113,378 112,967 82,510 119,062 0 SupplieslMaterials 4,746 2,959 4,000 3,310 3,325 0 Support Services 97,251 93,491 93,265 76,326 102,010 0 Depreciation 4,854 5,083 4,800 3,864 3,387 0 Capital Outlay 0 0 0 0 10,000 0 TOTAL EXPENSES 204,373 214,911 215,032 166,009 237,784 0 TOTAL OPERATING INCOME (LOSS) 12,128 11 ,323 7,568 6,826 3,926 0 Other Sources 0 15,000 5,000 0 5,000 0 Other Uses 6,453 0 0 668 10,000 0 NET INCOME (LOSS) 5,675 26,323 12,568 6,158 (1,074) 0 BUSINESS INDICATORS: Gross Profit as a % of Sales 27.33% 26.89% 25.99% 27.06% 26.46% #DIV/O! Oper. Income as a % of Sales 1.53% 1.35% 0.88% 1.07% 0.43% #DIV/O! CASH FLOW IMPACT: Beginning Cash Balance (159,160) (184,371 ) (164,966) (184,371 ) (164,966) (164,966) Net Operating Income/(Loss) 12,128 11,323 7,568 6,826 3,926 '0 Depreciation 4,854 5,083 4,800 3,864 3,387 0 Other Cash Flow Impacts (42,193) 3,000 3,000 3,000 Ending Cash Balance (184,371 ) (164,966) (149,598) (170,682) (157,653) (164,966) STAFFING: Full time: Operations Manager .33 .33 .33 .33 .50 .50 Assistant Manager 1.00 1.00 1.00 1.00 1.0 1.0 Full Time Clerk Sr. Acctg. Clerk .05 .05 .05 .05 .05 .05 Part time: Sales Clerks 5.00 5.00 5.00 5.00 5.00 5.00 . FUND: #642 SUBFUND: Liquor - Waterford DEPT #49750 BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 2002 2003 2,004 2004 2005 2005 SALES 37811 Liquor 224,836 240,921 243,000 184,689 264,000 37812 Wine 186,741 205,314 202,000 150,187 227,000 37813 Beer 345,707 361 ,865 375,000 277 ,492 387,000 37814 Miscellaneous 34,975 33,273 36,600 26,353 35,500 TOTAL SALES 792,260 841,374 856,600 638,721 913,500 0 COST OF GOODS SOLD 251 Liquor 171,176 182,429 190,000 137,330 191,500 252 Wine 126,519 135,047 140,000 101,878 150,000 253 Beer 259,456 271,235 285,000 209,444 301,290 254 Miscellaneous 18,607 26,429 19,000 17,234 29,000 TOTAL COST OF GOODS SOLD 575,759 615,141 634,000 465,886 671,790 0 GROSS PROFIT 216,501 226,233 222,600 172,835 241,710 0 EXPENSES PERSONAL SERVICES 101 Regular Salaries 57,755 74,357 64,965 50,528 71,803 102 O.T. Salaries 23 0 103 Part Time Salaries 24,006 17,513 25,000 17,032 25,000 121 PERA City Share 4,297 5,178 4,499 3,709 5,572 122 FICA City Share 5,938 7,214 4,028 5,253 7,413 131 Ins. City Share 3,904 7,403 14,475 5,989 9,274 141 Unemployment Comp 0 0 0 151 . Workers Comp 1,600 1,713 0 Total 97,522 113,378 112,967 82,510 119,062 0 SUPPLIES 200 Office Supplies 311 174 300 222 300 201 Postage 100 25 221 Maint-Equipment 2,258 1,350 2,000 1,625 1,500 223 Malnt-Buildings 177 221 0 325 0 245 General Supplies 1,999 1,213 1,600 1,138 1,500 Total 4,746 2,959 4,000 3,310 3,325 0 OTHER SERVICES 301 Audit & Accounting 1,572 1 ,423 1,425 1,400 1 ,425 302 Consulting fees 0 0 2,333 0 304 Legal 1,453 84 0 0 321 Communication 1,343 1 ,422 1,500 838 1,500 331 Travel, Conf,Sch 525 440 800 241 600 342 Advertising & Promo 3,695 5,260 4,000 3,944 6,000 351 Print/Publish 0 79 120 41 50 360 Insurance-Total 4,292 7,267 9,500 5,451 8,000 380 Utilities-Gas/Elec 6,458 6,659 6,400 5,329 7,000 400 Contractual 479 390 500 551 500 410 Rent 68,428 59,557 60,000 47,517 67,000 420 Depreciation 4,854 5,083 4,800 3,864 3,387 432 Uncollectible Checks 1,152 1,395 500 0 500 433 Dues & Subscriptions 247 765 250 765 765 437 Taxes/Licenses 500 540 270 500 270 440 Misc Services 100 41 0 28 0 445 Credit Card Fees 7,008 8,169 8,000 7,386 8,400 Total 102,105 98,574 98,065 80,190 105,397 0 'FUND: #642 SUBFUND: Liquor - Waterford DEPT #49750 BUDGET Actual Actual Budget YTD Sept Proposed Adopted ITEM 2002 2003 2,004 2004 2005 2005 CAPITAL OUTLAY 560 Fumiture & Fixtures 0 0 10,000 0 Total 0 0 0 0 10,000 0 TOTAL EXPENSES 204,373 214,911 215,032 166,009 237,784 0 . TOTAL OPERATING INCOME/(LOSS) 12,128 11 ,323 7,568 6,826 3,926 0 NET INCOME/(LOSS) 12,128 11 ,323 7,568 6,826 3,926 0 OTHER SOURCES Transfers In 15,000 5,000 Mise Revenue 5,000 Total 0 15.000 5,000 0 5,000 0 OTHER USES Transfers Out 10,000 Mise Expense 6,453 668 Total 6,453 0 0 668 10,000 0 NET INCOME/(LOSS) 5,675 26,323 12,568 6,158 (1,074) 0