Laserfiche WebLink
III. Finance Activity Unique to 2013 <br />2013 Annual Report · Publc Works Department · St. Anthony Village, Minnesota <br />7 <br />III. Finance Activity Unique to 2013 <br />LIQUOR FUND <br />The Liquor operations profits are a key resource in the City’s overall <br />financial plan. Unlike traditional government resources the revenue <br />stream provided by the Liquor operation is subject to greater <br />fluctuations due to market conditions, economy and seasonal demand. <br />Given this dynamitic the monthly sales for the past five years were <br />compiled for review. The sales data was charted to gauge impact <br />of the seasonality of sales on cash flow. The larger variances in <br />monthly sales occur during the back to school and year-end holiday’s <br />time frames. By gleaning this information the Finance Department <br />developed a tool to monitor the cash position of the Liquor fund. <br />This tool assists management in ensuring that there is adequate <br />cash available through-out the year for Stores working capital and <br />while projecting funds available for special projects and equipment <br />purchases for all city departments. <br />JAN FEB MAR APR MAY JUN <br />2010 2011 2012 2013 2014 <br />JUL AUG SEP OCT NOV DEC <br />$400,000 <br />$100,000 <br />$450,000 <br />$300,000 <br />$500,000 <br />$500,000 <br />$550,000 <br />$700,000 <br />$600,000 <br />$900,000 <br />$650,000 <br />$1,100,000 <br />$700,000 <br />$750,000 <br />$850,000 <br />$800,000 <br />5 YEAR AVERAGE MONTHLY SALES VOLUME <br />LIQUOR FUND <br />Ending Cash Balance <br />Cash Ceiling <br />Cash Floor