Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
080904 Liquor Comm AgP
... ..r,' CITY OF SHOREWOOD Conference Room 5755 Country Club Road LIQUOR COMMITTEE MEETING MONDAY, AUGUST 9,2004 5:30 PM AGENDA t. UQUOR MANAGER 2003 PERFORMANCE PAY 1. UQUOR MARKETING STUDY 3. OTHER 4. ADJOURN Amajorlty of the City Council members may be present at this meeting. ~t',. , CITY OF SHOREWOOD 5755 COUNTRY CLUB ROAD · SHOREWOOD, MINNESOTA 55331-8927 · (952) 474-3236 FAX (952) 474-0128. www.cLshorewood.mn.us. cityhall@cLshorewood.mn.us MEMORANDUM TO: FROM: DATE: SUBJECT: Liquor Committee Craig W. Dawson, City Administrator 111\ July 22, 2004 (/1-> 2003 Performance Pay for Liquor Operations Manager " I have had some opportunity to discuss with Don Swandby the appropriate amount of performance pay for 2003. As the Committee reviewed and'provided some interpretation on the performance criteria at its last meeting, I believe that Mr. Swandby has earned $4,000 in performance pay for operating a two-store system in 2003. He has been able to earn as much as $5,000 for a three-store operation in past years, and b,elieves that he should be'able to earn that amount regardless of the size of the City's operation. As, of this writing, we had not concluded our discussions. Understandably, the year 2003 presented several challenges, including the lack of an anchor grocery store at the Shorewood Village Shopping Center, creating a new store within the Shorewood Village Shopping Center, and a reduction in sales without a comparable reduction in fixed expenses. While we were pleased to have had any net profit from the system under these circumstan~es, it should not be a reward not to lose money - this should be a mipimum expectation. One set in the performance criteria which has been consistent from year to year is system-wide profit, , with $500 paid to achieve $70,000, $100,000, and $130,000. While these figures are based on a three-store system, they could be reduced by simple math to '$46,000, $67,000, and $86,000 for a , two-store system. None of these levels was reached during 2003., I devised an alternate set of criteria for 2003 which would be challenging yet attainable: gains in gross sales for the two full months-- November and December--the new Shorewood Village store was open compared to those same months in 2001 (as there was an anchor grocery store open at both of these times). $500 increments would be achievable for gross sales that were 10%,20%, 'imd 25% greater in 2003 than 2001. Gross , sales ended up 24% greater over the comparable periods. ' If the system-wide profit criteria were removed, the criteria used for Mr. Swandby could yield $4,500. In prior years, and, with three stores, he has been eligible for $5,000. Based on the foregoing. I believe that the criteria for 2003 were fair and that Mr. Swandbv has earned $4.000 in performance pay for the year. If the Committee 'believes that Mr. Swandby should be eligible for $5,000,1 would suggest the criteria for per,..store profit margins and per-store wine sales be increased $125 each (to $625). Mr. Swandby would then earn an additional $500, for a total of $4,500 in performance pay, for 2003. n ~.1 PRINTED ON RECYCLED PAPER #1 2003 Liquor Performance Pay July 26, 2004, Liquor Committee Meeting Page Two Basis for Compensation: Regarding compensation for 2004 and beyond, I would like to discontinue the use of performance pay and increase the salary schedule for the Liquor Operations Manager. Among the reasons are: . The performance pay system was seen as appropriate when the Manager was hired in 1999. There was a general concern that the system would yield positive financial results. A higher base salary could burden the system in achieving those results. Performance pay would protect the financial position of the liquor operations, and funds would be available for with higher levels of performance. . The system is performing solidly, and can support a higher base salary. . There remains an incentive for positive results, as negative results threaten the viability of, and jobs in, the City's Liquor Operations. . The vagaries of appropriate performance criteria from year to year would be removed. . The Attorney General's Office has issued several opinions about the legality of performance or bonus pay in general. While they are not thoroughly consistent, they do not provide a clear-cut answer whether it is a valid expenditure of public funds. In light of the opinions written, staff at the League of Minnesota Cities advises that the AG is consistent in its belief that such compensation should not come out of liquor operations profits. . An increase of approximately $4,000 in base salary of the Liquor Operations Manager would place it in the middle of the range of the comparable group of cities in the Twin Cities salary survey. With one exception, no other city in Stanton Group 7 has performance pay for this position. If the Committee believes this approach has merit, I would like to do some more research regarding salary information. If the Committee, and ultimately the City Council, decides that the salary adjustment in lieu of performance pay should be done for 2004, then the adjustment should be retroactive to January 1,2004. Mr. Swandby has suggested performance criteria for 2004. In a brief review, I am in general agreement with them, but would want to develop them further before presenting:them to the Committee. ' Date: 07/22/2004 Time: 10: 53 :21 operator: Cathy CITY OF SHOREWOOD Balance Sheet Calendar Period: 06/2004 Fiscal Period: 06/2004 SHOREWOOD PLAZA LIQUOR Assets cASH AND INVESTMENTS PETTY CASH ALLOW FOR UNREALIZED INVEST GAIN/LOSS ACCRUED INTEREST RECEIVABLE ACCOUNTS RECEIVABLE RETURNED CHECKS DUE FROM OTHER FUNDS INVENTORY - LIQUOR INVENTORY - WINE INVENTORY - BEER INVENTORY - MISC PREPAID INSURANCE PREPAID EXPENSES - OTHER FURNITURE AND FIXTURES ALLOWANCE FOR DEPRECIATION - FURN &: FIX Total Assets: Liabilities ACCOUNTS PAYABLE SALES TAX PAYABLE ACCRUED WAGES &: SALARIES PAYABLE VOLUNTARY PAYROLL DEDUCTS PAYABLE Total Liabilities: Equity CONTRIBUTED CAPITAL UNRESERVED, UNDESIGNATED RETAINED EARN Fund Balance YTD Total Equity: Total Liability &: Equity: Page: 1 258,703.98 600.00 436.00- 1,207.68 .00 346.02 .00 48,246.39 64,859.06 38,687.72 4,473.03 40.20 .00 235,444.58 45,094.06- 607,078.60 .00 11,755.75 11,903.66 .00 23,659.41 30,000.00 502,493.87 50,925.32 583,419.19 607,078.60 =if:3 Date: 07/22/2004 Time: 10:54:22 CITY OF SHOREWOOD Income Statement Operator: Calendar Period: 06/2004 Fiscal period: 06/2004 Shorewood Plaza Liquor SALES 641-37811 LIQUOR SALES 641-37812 WINE SALES 641-37813 BEER SALES 641-37814 MISCSALES 641-37816 BOTTLE DEPOSITS TOTAL SALES COST OF GOODS SOLD 641-49750-251 LIQUOR PURCHASES 641-49750-252 WINE PURCHASES 641-49750-253 BEER PURCHASES 641-49750-254 MISC PURCHASES TOTAL COST OF GOODS SOLD GROSS PROFIT OPERATING EXPENSES PERSONAL SERVICES 641-49750-101 FULL-TIME REGULAR 641-49750-102 OVERTIME 641-49750-103 PART-TIME 641-49750-104 TEMPORARY REGULAR 641-49750-111 SEVERANCE PAY 641-49750-121 PERA CONTRIB - CITY SHARE 641-49750-122 FICA CONTRIB - CITY SHARE 641-49750-131 EMPLOYEE INSURANCE - CITY SHARE 641- 4 9750-141 UNEMPLOYMENT COMPENSATION 641-49750-151 WORKERS COMPENSATION TOTAL PERSONAL SERVICES SUPPLIES 641-49750-200 OFFICE SUPPLIES 641-49750-208 POSTAGE 641-49750-221 MAINTENANCE OF EQUIPMENT 641-49750-223 MAINTENANCE OF BUILDINGS 641-49750-245 GENERAL SUPPLIES TOTAL SUPPLIES **. Current *** *** Year to Date *** Amount PCT Amount PCT 35,737.41 30.62 187,355.23 31.11 29,157.72 24.99 174,788.90 29.03 48,159.59 41. 27 223,318.69 37.09 3,627.82 3.11 16,616.88 2.76 16.80 0.01 71.15 0.01 116,699.34 100.00 602,150.85 100.00 20,153.55 17.27 130,352.50 21. 65 16,291.49 13.96 111,785.00 18.56 23,215.63 19.89 143,046.88 23.76 2,010.94 1.72 10,519.59 1.75 61,671. 61 52.85 395,703.97 65.72 55,027.73 47.15 206,446.88 34.28 10,205.14 8.74 42,016.42 6.98 0.00 0.00 0.00 0.00 3,335.84 2.86 14,365.72 2.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 748.79 0.64 3,136.56 0.52 1,033.57 0.89 4,302.04 0.71 0.00 0.00 4,924.93 0.82 0.00 0.00 19.51 0.00 0.00 0.00 0.00 0.00 15,323.34 13.13 68,765.18 11.42 49.17 0.04 152.58 0.03 0.00 0.00 0.00 0.00 1,300.00 1.11 1,300.00 0.22 0.00 0.00 37.26 0.01 398.36 0.34 1,082.32 0.18 1,747.53 1.50 2,572.16 0.43 Cathy Page: 1 Date: 07/22/2004 Time: 10:54:22 OTHER CHARGES 641-49750-301 AUDITING & ACCOUNTING SERVICES 641-49750-302 CONSULTING FEES 641-49750-304 LEGAL FEES 641-49750-321 COMMUNICATIONS - TELEPHONE 641-49750-331 TRAVEL, CONFERENCE & SCHOOLS 641-49750-342 ADVERTISING & PROMOTIONS 641-49750-351 PRINTING AND PUBLISHING 641-49750-360 INSURANCE 641-49750-380 UTILITY SERVICES 641-49750-400 CONTRACTUAL SERVICES 641-49750-410 RENTS 641-49750-420 DEPRECIATION 641-49750-432 UNCOLLECTIBLE CHECKS 641-49750-433 DUES AND SUBSCRIPTIONS 641-49750-437 TAXES/LICENSES 641-49750-440 MISe SERVICES 641-49750-445 CREDIT CARD FEES TOTAL OTHER CHARGES TOTAL OPERATING EXPENSES NET OPERATING INCOME/LOSS OTHER INCOME/EXPENSE 641-36210 INTEREST EARNINGS 641-49750-450 BANK SERVICE CHARGES 641-36270 MISCELLANEOUS REVENUE 641-37840 CASH OVER 641-49750-431 CASH SHORT TOTAL OTHER INCOME/EXPENSE INTERFUND TRANSFERS 641-49750-720 OPERATING TRANSFERS TOTAL INTERFUND TRANSFERS NET INCOME/LOSS CITY OF SHOREWOOD Income Statement Qperator: Calendar Period: 06/2004 Fiscal Period: 06/2004 Shorewood Plaza Liquor *** Current *** *** Year to Date *** Amount Amount PCT PCT 0.00 0.00 0.00 0.00 1,166.67 1.00 1,166.67 0.19 0.00 0.00 0.00 0.00 97.40 0.08 484.98 0.08 35.63 0.03 164.94 0.03 694.80 0.60 2,126.45 0.35 0.00 0.00 0.00 0.00 605.65 0.52 3,633.90 0.60 l27.51 0.11 1,884.90 0.31 0.00 0.00 587.62 0.10 5,409.40 4.64 35,625.80 5.92 2,825.42 2.42 16,952.52 2.82 0.00 0.00 0.00 0.00 0.00 0.00 45.00 0.01 0.00 0.00 270.00 0.04 0.00 0.00 28.49 0.00 1,773.81 1.52 8,192.50 1.36 12,736.29 10.91 71,163.77 11.82 29,807.16 25.54 142,501.11 23.67 25,220.57 21.61 63,945.77 10.62 356.98 0.31 3,023.20 0.50 5.91 0.01 50.71 0.01 0.00 0.00 400.00 0.00 148.80 0.13 672 .75 0.11 156.84 0.13 865.93 0.14 343.03 0.29 3,179.31 0.53 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25,563.60 21.91 67,125.08 11.15 Cathy Page: 2 Date: 07/22/2004 Time: 10: 54: 38 CITY OF SHOREWOOD Income Statement Operator: Cathy Page: 1 Calendar Period: 06/2004 Fiscal Period: 06/2004 Variance to Last Year Shorewood Plaza Liquor ________________ MONTH-TO-DATE ---------------- CUrrent Last Year Budget Variance Description ------------------- YEAR-TO-DATE -------------------- CUrrent Last Year Budget Variance Pet SALES 35,737 21,600 35,950 14,138 LIQUOR SALES 187,355 119,614 431,400 67,741 156.63 29,158 15,100 32,750 14,058 WINE SALES 174,789 96,628 393,000 78,161 180.89 48,160 27,589 41,087 20,571 BEER SALES 223,319 135,064 493,000 88,255 165.34 3,628 3,030 4,175 598 MISC SALES 16,617 14,837 50,045 1,780 112.00 17 11- 0 28 BOTTLE DEPOSITS 71 10- 0 81 741.15- 116,699 67,307 113,962 49,392 TOTAL SALES 602,151 366,133 1,367,445 236,018 164.46 COST OF GOODS SOLD 20,154 19,449 27,663 705 LIQUOR PURCHASES 130,353 90,178 33;2,000 40,175 144.55 16,291 9,001 22,663 7,290 WINE PURCHASES 111,785 61,434 272,000 50,351 181. 96 23,216 18,116 31,663 5,100 BEER PURCHASES 143,047 92,972 380,000 50,075 153.86 2,011 1,520 2,323 491 MISC PURCHASES 10,520 11,038 27,909 519- 95.30 61,672 48,085 84,312 13,586 TOTAL COST OF GOODS SOL 395,704 255,622 1,011,909 140,082 154.80 55,028 19,222 29,650 35,806 GROSS PROFIT 206,447 110,511 355,536 95,936 186.81 OPERATING EXPENSES PERSONAL SERVICES 10,205 7,835 7,865 2,370 FULL-TIME REGULAR 42,016 30,569 94,413 11,447 137.45 0 0 0 0 OVERTIME 0 0 0 0 .00 3,336 1,283 2,550 2,053 PART-TIME 14,366 8,141 30,600 6,225 176.47 0 0 0 0 TEMPORARY REGULAR 0 0 0 0 .00 0 0 O. 0 SEVERANCE PAY 0 0 0 0 .00 749 492 520 257 PERA CONTRIB - CITY SHARE 3,137 2,084 6,251 1,052 150.50 1,034 695 646 338 FICA CONTRIB - CITY SHARE 4,302 2,947 7,752 1,355 145.97 0 585 1,706 585- EMPLOYEE INSURANCE - CITY 4,925 4,120 20,494 805 119.55 0 38 0 38- UNEMPLOYMENT COMPENSATION 20 38 0 18- 51.41 0 0 0 0 WORKERS COMPENSATION 0 0 0 0 .00 Date: 07/22/2004 Time: 10:54:38 CITY OF SHOREWOOD Income Statement operator: Cathy Page: 2 Calendar period: 06/2004 Fisca1 Period: 06/2004 Variance to Last Year Shorewood Plaza Liquor ._______________ MONTH-TQ-DATE ---------------- current Last Year Budget Variance Description ___________________ YEAR-TO-DATE -------------------- CUrrent Last Year Budget Variance Pct 15,323 10,928 13 , 287 4, 395 TOTAL PERSONAL SERVICES 68,765 47,899 159,510 20,866 143.56 SUPPLIES 49 0 37 49 OFFICE SUPPLIES 153 159 400 6- 96.12 0 0 12 0 POSTAGE 0 0 100 0 .00 1,300 0 125 1,300 MAINTENANCE OF EQUIPMENT 1,300 1,405 1,500 105- 92.56 0 50 0 50- MAINTENANCE OF BUILDINGS 37 50 0 13- 74.52 398 75 163 324 GENERAL SUPPLIES 1,082 805 2,000 277 134.43 1,748 125 337 1,623 TOTAL SUPPLIES 2,572 2,418 4,000 154 106.36 OTHER CHARGES 0 0 116 0 AUDITING &. ACCOUNTING SER 0 0 1,425 0 .00 1,167 0 0 1,167 CONSULTING FEES 1,167 0 0 1,167 .00 0 0 0 0 LEGAL FEES 0 84 0 84- .00 97 116 125 19- COMMUNICATIONS - TELEPHON 485 584 1,500 99- 83.10 36 27 63 8 TRAVEL, CONFERENCE &. SCHO 165 161 800 4 102.66 695 67 337 628 ADVERTISING &. PROMOTIONS 2,126 1,279 4,000 847 166.22 0 0 10 0 PRINTING AND PUBLISHING 0 0 120 0 .00 606 666 788 60- INSURANCE 3,634 3,996 9,500 362- 90.94 128 585 750 458- UTILITY SERVICES 1,885 4,044 9,000 2,159- 46.61 0 2,330 100 2,330- CONTRACTUAL SERVI CES 588 3,680 1,200 3,092- 15.97 5,409 9,359 5,413 3,950- RENTS 35,626 29,283 65,000 6,343 121.66 2,825 41.3 837 2,413 DEPRECIATION 16,953 2,445 10,000 14,508 693.50 0 0 38 0 UNCOLLECTIBLE CHECKS 0 0 500 0 .00 0 0 19 0 DUES AND SUBSCRIPTIONS 45 45 250 o 100.00 0 250 17 250- TAXES/LICENSES 270 270 270 o 100.00 0 0 0 0 MISC SERVICES 28 0 0 28 .00 1,774 781 837 993 CREDIT CARD FEES 8,193 3,901 10,000 4,291 210.01 12,736 14,594 9,450 1,858- TOTAL OTHER CHARGES 71,164 49,771 113,565 21,392 142.98 29,807 25,647 23,074 4,160 TOTAL OPERATING EXPEN 142,501 100,089 277,075 42,412 142.37 " Date: 07/22/2004 Time: 10:54:38 CITY OF SHOREWOOD Income Statement Operator: Cathy Page: 3 Calendar Period: 06/2004 Fiscal period: 06/2004 Variance to Last Year Shorewood plaza Liquor ________________ MONTH-TO-DATE ---------------- current Last Year Budget Variance Description ------------------- YEAR-TO-DATE -------------------- cu=ent Last Year Budget Variance pct 25,221 6,425- 6,576 31,646 NET OPERATING INCOM 63,946 10,422 78,461 53,523 613.54 OTHER INCOME/EXPENSE 357 562 0 205- INTEREST EARNINGS 3,023 2,035 0 988 148.55 6 9 0 3- BANK SERVICE CHARGES 51 68 0 17- 74.97 0 0 0 0 MISeELLl\NEOUS REVENUE 400 239 0 161 167.39 149 40 0 108 CASH OVER 673 532 0 141 126.44 157 3,763- 0 3,920 CASH SHORT 866 1,046 0 180- 82.82 343 4,357 o 4,013- TOTAL OTHER INCOME/EXPE 3,179 1,693 o 1,486 187.80 INTERFUND TRANSFERS o o 2,087- o OPERATING TRANSFERS o o 25,000- o .00 o o 2,087- o TOTAL INTERFUND TRANSFE o o 25,000- o .00 25,564 2,069- 8,663 27,632 NET INCOME/LOSS 67,125 12,115 103,461 55,010 554.05 Date; 07/22/2004 Operator; Cathy Time; 10;53;49 CITY OF SHOREWOOD Balance Sheet Calendar Period; 06/2004 Fiscal Period; 06/2004 WATERFORD LIQUOR Assets CASH AND INVESTMENTS PETTY CASH ALLOW FOR UNREALIZED INVEST GAIN/LOSS ACCRUED INTEREST RECEIVABLE RETURNED CHECKS INVENTORY - LIQUOR INVENTORY - WINE INVENTORY - BEER INVENTORY - MISC PREPAID INSURANCE PREPAID EXPENSES - OTHER FURNITURE AND FIXTURES ALLOWANCE FOR DEPRECIATION - FURN &: FIX Total Assets; Liabilities ACCOUNTS PAYABLE DUE TO OTHER FUNDS SALES TAX PAYABLE ACCRUED WAGES &: SALARIES PAYABLE VOLUNTARY PAYROLL DEDUCTS PAYABLE Total Liabilities; Equity UNRESERVED, UNDESIGNATED RETAINED EARN Fund Balance YTD Total Equity; Total Liability &: Equity: Page; 1 164,083.18- 600.00 .00 .00 792.73 35,532.62 35,363.86 28,225.78 3,177.11 39.21 .00 68,198.50 50,822.98- 42,976.35- .00 .00 7,896.75 2,611.48 .00 10,508.23 79,100.88- 25,616.30 53,484.58- 42,976.35- Date: 07/22/2004 Time: 10:55:12 CITY OF SHOREWOOD Income Statement Operator: Calendar Period: 06/2004 Fiscal Period: 06/2004 WATERFORD LIQUOR SALES 642-37811 LIQUOR SALES 642-37812 WINE SALES 642-37813 BEER SALES 642-37814 MISC SALES 642-37816 BOTTLE DEPOSITS TOTAL SALES COST OF GOODS SOLD 642-49750-251 LIQUOR PURCHASES 642-49750-252 WINE PURCHASES 642-49750-253 BEER PURCHASES 642-49750-254 MISC PURCHASES TOTAL COST OF GOODS SOLD GROSS PROFIT OPERATING EXPENSES PERSONAL SERVICES 642-49750-101 FULL-TIME REGULAR 642-49750-102 OVERTIME 642-49750-103 PART-TIME 642-49750-104 TEMPORARY REGULAR 642-49750-111 SEVERANCE PAY 642-49750-121 PERA CONTRIB - CITY SHARE 642-49750-122 FICA CONTRIB - CITY SHARE 642-49750-131 EMPLOYEE INSURANCE - CITY SHARE 642-49750-141 UNEMPLOYMENT COMPENSATION 642-49750-151 WORKERS COMPENSATION TOTAL PERSONAL SERVICES SUPPLIES 642-49750-200 OFFICE SUPPLIES 642-49750-208 POSTAGE 642-49750-221 MAINTENANCE OF EQUIPMENT 642-49750-223 MAINTENANCE OF BUILDINGS 642-49750-245 GENERAL SUPPLIES TOTAL SUPPLIES *** Current *** ... Year to Date **. Amount PCT PCT Amount 23,176.62 29.44 117,000.31 29.23 17,824.97 22.65 97,001. 09 24.24 34,192.71 43.44 170,625.16 42.63 3,512.73 4.46 15,580.38 3.89 6.00 0.01 44.40 0.01 78,713.03 100.00 400,251.34 100.00 15,229.65 19.35 81,385.70 20.33 10,430.60 13.25 63,525.74 15.87 15,533.50 19.73 112,301.57 28.06 2,296.55 2.92 10,608.45 2.65 43,490.30 55.25 267,821.46 66.91 35,222.73 44.75 132,429.88 33.09 7,219.54 9.17 34,284.64 8.57 0.00 0.00 0.00 0.00 2,698.26 3.43 11,092.07 2.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 548.44 0.70 2,409.89 0.60 756.33 0.96 3,459.82 0.86 0.00 0.00 3,564.49 0.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11,222.57 14.26 54,810.91 13.69 49.17 0.06 176.47 0.04 0.00 0.00 0.00 0.00 0.00 0.00 1,625.00 0.41 0.00 0.00 324.83 0.08 87.76 0.11 562.44 0.14 136.93 0.17 2,688.74 0.67 Cathy Page: 1 Date: 07/22/2004 Time: 10:55:12 OTHER CHARGES CITY OF SHORE WOOD Income Statement Operator: Calendar Period: 06/2004 Fiscal Period: 06/2004 WATERFORD LIQUOR .** CUrrent ..* ... Year to Date ... Amount Amount PCT PCT 642-49750-301 AUDITING & ACCOUNTING SERVICES 642-49750-302 CONSULTING FEES 642-49750-304 LEGAL FEES 642-49750-321 COMMUNICATIONS - TELEPHONE 642-49750-331 TRAVEL, CONFERENCE & SCHOOLS 642-49750-342 ADVERTISING & PROMOTIONS 642-49750-351 PRINTING AND PUBLISHING 642-49750-360 INSURANCE 642-49750-380 UTILITY SERVICES 642-49750-400 CONTRACTUAL SERVICES 642-49750-410 RENTS 642-49750-420 DEPRECIATION 642-49750-432 UNCOLLECTIBLE CHECKS 642-49750-433 DUES AND SUBSCRIPTIONS 642-49750-437 TAXES/LICENSES 642-49750-440 MISC SERVICES 642-49750-445 CREDIT CARD FEES 642-49750-560 FURNITURE AND FIXTURES TOTAL OTHER CHARGES TOTAL OPERATING EXPENSES NET OPERATING INCOME/LOSS OTHER INCOME/EXPENSE 642-36210 INTEREST EARNINGS 642-49750-450 BANK SERVICE CHARGES 642-36270 MISCELLANEOUS REVENUE 642-37840 CASH OVER 642-49750-431 CASH SHORT TOTAL OTHER INCOME/EXPENSE INTERFUND TRANSFERS 642-49750-720 OPERATING TRANSFERS TOTAL INTERFUND TRANSFERS NET INCOME/LOSS 0.00 0.00 0.00 0.00 1,166.67 1.48 1,166.67 0.29 0.00 0.00 0.00 0.00 98.35 0.12 487.71 0.12 35.62 0.05 164.92 0.04 694.80 0.88 2,572.51 0.64 0.00 0.00 0.00 0.00 605.65 0.77 3,633.90 0.91 9.59 0.01 2,612.64 0.65 0.00 0.00 247.15 0.06 5,497.67 6.98 31,023.86 7.75 429.33 0.55 2,575.98 0.64 0.00 0.00 0.00 0.00 0.00 0.00 45.00 0.01 0.00 0.00 250.00 0.06 0.00 0.00 28.49 0.01 1,002.50 1.27 4,504.65 1.13 0.00 0.00 0.00 0.00 9,540.18 12.12 49,313.48 12.32 20,899.68 26.55 106,813.13 26.69 14,323.05 18.20 25,616.75 6.40 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 99.64 0.13 448.87 0.11 89.07 0.11 449.32 0.11 10.57 0.01 0.45- 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 14,333.62 18.21 25,616.30 6.40 Cathy Page: 2 Date: 07/22/2004 Time: 10:55:28 CITY OF SHOREWOOD Income Statement Operator: Cathy Page: 1 ealendar Period: 06/2004 Fiscal Period: 06/2004 Variance to Last Year WATERFORD LIQUOR ---------------- MONTH-TO-DATE ---------------- CUrrent Last Year Budget Variance Description ------------------- YEAR-TO-DATE -------------------- CUrrent Last Year Budget Variance Pct SALES 23,177 21,473 20,250 1,703 LIQUOR SALES 117,000 112,571 243,000 4,429 103.93 17,825 15,327 16,837 2,498 WINE SALES 97,001 88,612 202,000 8,389 109.47 34,193 32,777 31,250 1,416 BEER SALES 170,625 164,007 375,000 6,618 104.04 3,513 3,405 3,050 107 MISC SALES 15,580 14,843 36,600 738 104.97 6 10 0 4- BOTTLE DEPOSITS 44 20 0 24 217.65 78,713 72, 993 71,387 5,720 TOTAL SALES 400,251 380,054 856,600 20,198 105.31 COST OF GOODS SOLD 15,230 16,994 15,837 1,765- LIQUOR PURCHASES 81,386 78,847 190,000 2,538 103.22 10,431 10,862 11,663 432- WINE PURCHASES 63,526 56,979 140,000 6,547 111.49 15,534 19,810 23,750 4,276- BEER PURCHASES 112,302 113,551 285,000 1,249- 98.90 2,297 1,770 1,587 526 MISe PURCHASES 10,608 12,598 19,000 1,989- 84.21 43,490 49,437 52,837 5,946- TOTAL COST OF GOODS SOL 267,821 261,974 634,000 5,847 102.23 35,223 23,556 18,550 11,667 GROSS PROFIT 132,430 118,079 222,600 14,351 112.15 OPERATING EXPENSES PERSONAL SERVIeES 7,220 8,131 5,411 911- FULL-TIME REGULAR 34,285 37,857 64,965 3,573- 90.56 0 0 0 0 OVERTIME 0 0 0 0 .00 2,698 1,009 2,087 1,689 PART-TIME 11,092 5,661 25,000 5,431 195.94 0 0 0 0 TEMPORARY REGULAR 0 0 0 0 .00 0 0 0 0 SEVERANCE PAY 0 0 0 0 .00 548 505 374 43 PERA CONTRIB - CITY SHARE 2,410 2,458 4,499 48- 98.04 756 697 332 60 FICA CONTRIB - CITY SHARE 3,460 3,377 4,028 83 102.45 0 641 1,209 641- EMPLOYEE INSURANCE - CITY 3,564 4,510 14,475 945- 79.04 0 0 0 0 UNEMPLOYMENT COMPENSATION 0 0 0 0 .00 0 0 0 0 WORKERS COMPENSATION 0 0 0 0 .00 Date: 07/22/2004 Time; 10:55:28 CITY OF SHOREWOOD Income Statement Operator: Cathy Page: 2 Calendar Period: 06/2004 Fiscal Period; 06/2004 Variance to Last Year WATERFORD LIQUOR ---------------- MONTH-TO-DATE ---------------- current Last Year Budget Variance Description ------------------- YEAR-TO-DATE -------------------- Current Last Year Budget Variance Pct 11,223 10,983 9,413 240 TOTAL PERSONAL SERVIeES 54,811 53,863 112,967 947 101. 76 SUPPLIES 49 0 25 49 OFFICE SUPPLIES 176 57 300 120 310.63 0 0 12 0 POSTAGE 0 0 100 0 .00 0 0 163 0 MAINTENANCE OF EQUIPMENT 1,625 1,350 2,000 275 120.38 0 0 0 0 MAINTENANCE OF BUILDINGS 325 221 0 103 146.75 88 14 137 74 GENERAL SUPPLIES 562 510 1,600 53 110.39 137 14 337 123 TOTAL SUPPLIES 2,689 2,138 4,000 551 125.78 OTHER CHARGES 0 0 116 0 AUDITING & ACCOUNTING SER 0 0 1,425 0 .00 1,167 0 0 1,167 CONSULTING FEES 1,167 0 0 1,167 .00 0 0 0 0 LEGAL FEES 0 84 0 84- .00 98 116 125 18- COMMUNICATIONS - TELEPHON 488 584 1,500 97 - 83. 44 36 27 63 8 TRAVEL, eONFERENCE << SCHO 165 161 800 4 102.64 695 213 337 482 ADVERTISING << PROMOTIONS 2,573 1,896 4,000 676 135.67 0 0 10 0 PRINTING AND PUBLISHING 0 0 120 0 .00 606 666 788 60- INSURANCE 3,634 3,996 9,500 362- 90.94 10 652 537 642- UTILITY SERVICES 2,613 2,987 6,400 374- 87.48 0 0 38 0 CONTRACTUAL SERVICES 247 179 500 68 138. 13 5,498 5,007 5,000 491 RENTS 31,024 29,514 60,000 1,510 105.12 429 399 400 31 DEPREeIATION 2,576 2,393 4,800 183 107.67 0 0 38 0 UNCOLLECTIBLE CHEeKS 0 0 500 0 .00 0 0 19 0 DUES AND SUBSCRIPTIONS 45 0 250 45 .00 0 250 17 250- TAXES/LICENSES 250 270 270 20- 92.59 0 0 0 0 MIse SERVICES 28 0 0 28 .00 1,003 762 663 240 CREDIT CARD FEES 4,505 3,683 8,000 821 122.29 0 0 0 0 FURNITURE AND FIXTURES 0 1,923 0 1,923- .00 9,540 8,093 8,151 1,447 TOTAL OTHER CHARGES 49,313 47,669 98,065 1,644 103.45 20,900 19,090 17,901 1,810 TOTAL OPERATING EXPEN 106,813 103,670 215,032 3,143 103.03 Date: 07/22/2004 Time: 10:55:28 CITY OF SHOREWOOD Income Statement Operator: Cathy Page: 3 Calendar Period: 06/2004 Fiscal Period: 06/2004 Variance to Last Year WATERFORD LIQUOR ________________ MONTH-TO-DATE ---------------- current Last Year Budget Variance Deseription ------------------- YEAR-TO-DATE -------------------- Current Last Year Budget Variance Pct 14,323 4,466 649 9,857 NET OPERATING INCOM 25,617 14,409 7,568 11,208 177.79 OTHER INCOME/EXPENSE 0 0 0 0 INTEREST EARNINGS 0 0 0 0 .00 0 0 0 0 BANK SERVICE CHARGES 0 7 0 7- .00 0 0 0 0 MISCELLANEOUS REVENUE 0 0 0 0 .00 100 43 0 57 CASH OVER 449 353 0 9El 127.21 89 83 0 6 CASH SHORT 449 380 0 69 118.15 11 40- o 51 TOTAL OTHER INCOME/EXPE o 35- o 34 1.29 INTERFUND TRANSFERS o o 413- o OPERATING TRANSFERS o o 5,000- o .00 o o 413- o TOTAL INTERFUND TRANSFE o o 5,000- o .00 14,334 4,426 1,062 9,908 NET INCOME/LOSS 25,616 14,374 12,568 11,242 178.21 Date: 07/22/2004 Operator: Cathy Time: 10:53:40 CITY OF SHOREWOOD Balance Sheet Calendar Period: 06/2004 Fiscal Period: 06/2004 TONKA BAY LIQUOR Assets CASH AND INVESTMENTS PETTY CASH ALLOW FOR UNREALIZED INVEST GAIN/LOSS ACCRUED INTEREST RECEIVABLE ACCOUNTS RECEIVABLE RETURNED CHECKS INVENTORY - LIQUOR INVENTORY - WINE INVENTORY - BEER INVENTORY - MISC PREPAID INSURANCE PREPAID EXPENSES - OTHER FURNITURE AND FIXTURES ALLOWANCE FOR DEPRECIATION - FURN & FIX Total Assets: Liabilities ACCOUNTS PAYABLE SALES TAX PAYABLE ACCRUED WAGES & SALARIES PAYABLE VOLUNTARY PAYROLL DEDUCTS PAYABLE Total Liabilities: Equity UNRESERVED, UNDESIGNATED RETAINED EARN Fund Balance YTD Total Equity: Total Liability & Equity: Page: 1 246,091. 72 .00 468.00- 1,296.55 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 246.920.27 .00 .00 .00 .00 .00 245,436.34 1,483.93 246,920.27 246,920.27 . - Date: 07/22/2004 Time: 10:54:49 CITY OF SHOREWOOD Operator: Cathy Page: 1 Income Statement Calendar period: 06/2004 Fiscal Period: 06/2004 TONKA BAY LIQUOR *** Current *** *** Year to Date *** Amount PCT Amount PCT SALES 643-37811 LIQUOR SALES 0.00 0.00 0.00 0.00 643-37812 WINE SALES 0.00 0.00 0.00 0.00 643-37813 BEER SALES 0.00 0.00 0.00 0.00 643-37814 MISC SALES 0.00 0.00 0.00 0.00 643-37816 BOTTLE DEPOSITS 0.00 0.00 0.00 0.00 TOTAL SALES 0.00 0.00 0.00 0.00 COST OF GOODS SOLD 643-49750-251 LIQUOR PURCHASES 0.00 0.00 0.00 0.00 643-49750-252 WINE PURCHASES 0.00 0.00 0.00 0.00 643-49750-253 BEER PURCHASES 0.00 0.00 0.00 0.00 643-49750-254 MISC PURCHASES 0.00 0.00 0.00 0.00 TOTAL COST OF GOODS SOLD 0.00 0.00 0.00 0.00 GROSS PROFIT 0.00 0.00 0.00 0.00 OPERATING EXPENSES PERSONAL SERVICES 643-49750-101 FULL-TIME REGULAR 0.00 0.00 0.00 0.00 643-49750-102 OVERTIME 0.00 0.00 0.00 0.00 643-49750-103 PART-TIME 0.00 0.00 0.00 0.00 643-49750-104 TEMPORARY REGULAR 0.00 0.00 0.00 0.00 643-49750-111 SEVERANCE PAY 0.00 0.00 0.00 0.00 643-49750-121 PERA CONTRIB - CITY SHARE 0.00 0.00 0.00 0.00 643-49750-122 FICA CONTRIB - CITY SHARE 0.00 0.00 0.00 0.00 643-49750-131 EMPLOYEE INSURANCE - CITY SHARE 0.00 0.00 0.00 0.00 643-49750-141 UNEMPLOYMENT COMPENSATION 0.00 0.00 0.00 0.00 643-49750-151 WORKERS COMPENSATION 0.00 0.00 0.00 0.00 TOTAL PERSONAL SERVICES 0.00 0.00 0.00 0.00 SUPPLIES 643-49750-200 OFFICE SUPPLIES 0.00 0.00 0.00 0.00 643-49750-208 POSTAGE 0.00 0.00 0.00 0.00 643-49750-221 MAINTENANCE OF EQUIPMENT 0.00 0.00 0.00 0.00 643-49750-223 MAINTENANCE OF BUILDINGS 0.00 0.00 0.00 0.00 643-49750-245 GENERAL SUPPLIES 0.00 0.00 0.00 0.00 TOTAL SUPPLIES 0.00 0.00 0.00 0.00 Date: 07/22/2004 Time: 10:54:49 CITY OF SHOREWOOD Operator: Cathy Page: 2 Income Statement Calendar Period: 06/2004 Fiscal period: 06/2004 TONKA BAY LIQUOR *** CUrrent *** *** Year to Date *** Amount PCT Amount PCT OTHER CHARGES 643-49750-301 AUDITING " ACCOUNTING SERVICES 0.00 0.00 0.00 0.00 643-49750-302 CONSULTING FEES 1,166.66 0.00 1,166.66 0.00 643-49750-304 LEGAL FEES 0.00 0.00 0.00 0.00 643-49750-321 COMMUNICATIONS - TELEPHONE 0.00 0.00 0.00 0.00 643-49750-331 TRAVEL, CONFERENCE " SCHOOLS 0.00 0.00 0.00 0.00 643-49750-342 ADVERTISING " PROMOTIONS 0.00 0.00 0.00 0.00 643-49750-351 PRINTING AND PUBLISHING 0.00 0.00 0.00 0.00 643-49750-360 INSURANCE 0.00 0.00 0.00 0.00 643-49750-380 UTILITY SERVICES 0.00 0.00 0.00 0.00 643-49750-400 CONTRACTUAL SERVICES 0.00 0.00 0.00 0.00 643-49750-410 RENTS 0.00 0.00 0.00 0.00 643-49750-420 DEPRECIATION 0.00 0.00 0.00 0.00 643-49750-432 UNCOLLECTIBLE CHECKS 0.00 0.00 0.00 0.00 643-49750-433 DUES AND SUBSCRIPTIONS 0.00 0.00 0.00 0.00 643-49750-437 TAXES/LICENSES 0.00 0.00 0.00 0.00 643-49750-440 MISC SERVICES 0.00 0.00 0.00 0.00 643-49750-445 CREDIT CARD FEES 0.00 0.00 0.00 0.00 643-49750-560 FURNITURE AND FIXTURES 0.00 0.00 0.00 0.00 TOTAL OTHER CHARGES 1,166.66 0.00 1,166.66 0.00 TOTAL OPERATING EXPENSES 1,166.66 0.00 1,166.66 0.00 NET OPERATING INCOME/LOSS 1,166.66- 0.00 1,166.66- 0.00 OTHER INCOME/EXPENSE 643-36210 INTEREST EARNINGS 382.20 0.00 2,698.63 0.00 643-49750-450 BANK SERVICE CHARGES 6.34 0.00 48.04 0.00 643-36270 MISCELLANEOUS REVENUE 0.00 0.00 0.00 0.00 643-37840 CASH OVER 0.00 0.00 0.00 0.00 643-49750-431 CASH SHORT 0.00 0.00 0.00 0.00 TOTAL OTHER INCOME/EXPENSE 375.86 0.00 2,650.59 0.00 INTERFUND TRANSFERS 643-49750-720 OPERATING TRANSFERS 0.00 0.00 0.00 0.00 TOTAL INTERFUND TRANSFERS 0.00 0.00 0.00 0.00 NET INCOME/LOSS 790.80- 0.00 1,483.93 0.00 Date: 07/22/2004 Time: 10:54:57 CITY OF SHOREWOOD Income Statement Operator: Cathy Page: 1 '. Calendar Period: 06/2004 Fiscal Period: 06/2004 Variance to Last Year TONKA BAY LIQUOR ________________ MONTH-TO-DATE ---------------- CUrrent Last Year Budget Variance Description ------------------- YEAR-TO-DATE -------------------- CUrrent Last Year Budget Variance pct SALES 0 0 0 0 LIQUOR SALES 0 0 0 0 .00 0 0 0 0 WINE SALES 0 0 0 0 .00 0 0 0 0 BEER SALES 0 0 0 0 .00 0 0 0 0 MISC SALES 0 0 0 0 .00 0 0 0 0 BOTTLE DEPOSITS 0 0 0 0 .00 o o o o TOTAL SALES o o o o .00 COST OF GOODS SOLD 0 0 0 0 LIQUOR PURCHASES 0 0 0 0 .00 0 0 0 0 WINE PURCHASES 0 0 0 0 .00 0 0 0 0 BEER PURCHASES 0 0 0 0 .00 0 0 0 0 MISC PURCHASES 0 0 0 0 .00 o o o o TOTAL COST OF GOODS SOL o o o o .00 o o o o GROSS PROFIT o o o o .00 OPERATING EXPENSES PERSONAL SERVICES 0 0 0 0 FULL- TIME REGULAR 0 0 0 0 .00 0 0 0 0 OVERTIME 0 0 0 0 .00 0 0 0 0 PART-TIME 0 0 0 0 .00 0 0 0 0 TEMPORARY REGULAR 0 0 0 0 .00 0 0 0 0 SEVERANCE PAY 0 0 0 0 .00 0 0 0 0 PERA CONTRIB - CITY SHARE 0 0 0 0 .00 0 0 0 0 FICA CONTRIB - CITY SHARE 0 0 0 0 .00 0 0 0 0 EMPLOYEE INSURANCE - CITY 0 0 0 0 .00 0 0 0 0 UNEMPLOYMENT COMPENSATION 0 0 0 0 .00 0 0 0 0 WORKERS COMPENSATION 0 0 0 0 .00 Date: 07/22/2004 Time: 10:54:57 CITY OF SHOREWOOD Income Statement Operator: Cathy Page: 2 Calendar Period: 06/2004 Fiscal Period: 06/2004 Variance to Last Year TONKA BAY LIQUOR ---------------- MONTH-TQ-DATE ---------------- Current Last Year Budget Variance Description ------------------- YEAR-TO-DATE -------------------- CUrrent Last Year Budget Variance pct o o o o TOTAL PERSONAL SERVICES o o o o .00 SUPPLIES 0 0 0 0 OFFICE SUPPLIES 0 0 0 0 .00 0 0 0 0 POSTAGE 0 0 0 0 .00 0 0 0 0 MAINTENANCE OF EQUIPMENT 0 0 0 0 .00 0 0 0 0 MAINTENANCE OF BUILDINGS 0 0 0 0 .00 0 0 0 0 GENERAL SUPPLIES 0 0 0 0 .00 o o o o TOTAL SUPPLIES o o o o .00 OTHER CHARGES 0 0 0 0 AUDITING & ACCOUNTING SER 0 0 0 0 .00 1,167 0 0 1,167 CONSULTING FEES 1,167 0 0 1,167 .00 0 0 0 0 LEGAL FEES 0 0 0 0 .00 0 0 0 0 COMMUNICATIONS - TELEPHON 0 11- 0 11 .00 0 0 0 0 TRAVEL, CONFERENCE & SCHO 0 0 0 0 .00 0 0 0 0 ADVERTISING & PROMOTIONS 0 0 0 0 .00 0 0 0 0 PRINTING AND PUBLISHING 0 0 0 0 .00 0 0 0 0 INSURANCE 0 0 0 0 .00 0 0 0 0 UTILITY SERVICES 0 33 0 33- .00 0 0 0 0 CONTRACTUAL SERVICES 0 0 0 0 .00 0 10,563 0 0 RENTS 0 0 0 0 .00 0 0 0 0 DEPRECIATION 0 0 0 0 .00 0 0 0 0 UNCOLLECTIBLE CHECKS 0 0 0 0 .00 0 0 0 0 DUES AND SUBSCRIPTIONS 0 0 0 0 .00 0 0 0 0 TAXES/LICENSES 0 0 0 0 .00 0 0 0 0 MISC SERVICES 0 0 0 0 .00 0 0 0 0 CREDIT CARD FEES 0 0 0 0 .00 0 0 0 0 FURNITURE AND FIXTURES 0 0 0 0 .00 1,167 10,563 o 1,167 TOTAL OTHER CHARGES 1,167 23 o 1,144 999.99 1,167 10,563 o 1,167 TOTAL OPERATING EXPEN 1,167 23 o 1,144 999.99 Date: 07/22/2004 Time: 10:54:57 CITY OF SHOREWOOD Income Statement Operator: Cathy Page: 3 Calendar Period: 06/2004 Fiscal Period: 06/2004 Variance to Last Year TONKA BAY LIQUOR ________________ MONTH-TO-DATE ---------------- Current Last Year Budget Variance Description ------------------- YEAR-TO-DATE -------------------- Current Last Year Budget Variance Pct 1,167- 10,563- o 1,167- NET OPERATING INCOM 1,167- 23- o 1,144-999.99 OTHER INCOME/EXPENSE 382 418 0 36- INTEREST EARNINGS 2,699 1,691 0 1,008 159.60 6 6 0 0 BANK SERVICE CHARGES 48 29 0 19 164.18 0 0 0 0 MISCELLANEOUS REVENUE 0 0 0 0 .00 0 0 0 0 CASH OVER 0 0 0 0 .00 0 0 0 0 CASH SHORT 0 0 0 0 .00 376 412 o 36- TOTAL OTHER INCOME/EXPE 2,651 1,662 o '989 159.52 INTERFUND TRANSFERS o o o o OPERATING TRANSFERS o o o o .00 o o o o TOTAL INTERFUND TRANSFE o o o o .00 791- 10,151- o 1,203- NET INCOME/LOSS 1,484 1,639 o 155- 90.54