|
Municipal Liquor Stores
<br /> updated 08!9!16
<br /> 2013 2014 2015 20168 2017F 2018F
<br /> Sales 6,753,521 6,823,719 6,972,614 6,932,700 7,004,150 7,101,300
<br /> Cost of Sales 4,705;979 4,750,195 4,905,302 4,957,300 5,008,100 5,032,100
<br /> Gross Profit 2,047,542 30 2,073,524 30"4 2,067,312 3o a, 1,975,400 26 1,996,050 28';: 2,069,200 291
<br /> Operating revenues:
<br /> Other 3,060 1,623 1,722 3,000 1,700 1,700
<br /> Total Operating Revenues 3,060 1,623 1,722 3,000 1,700 1,700
<br /> Operating expenses:
<br /> Personal services 628,933 634,571 661,659 659,850 661,350 681,450
<br /> Supplies 26,507 57,604 31,542 53,700 20,700 20,700
<br /> Other service charges 220,584 209,746 225,221 231,950 241,500 250,250
<br /> Depreciation 124,757 124,757 121,402 123,000 125,000_ 125,000
<br /> Total Operating Expenditures 1,000,781 1,026,678 1,039,824 1,068,500 1,048,550 1,077,400
<br /> Operating income(loss) 1,049,821 1,048,469 1,029,210 909,900 949,200 993,500
<br /> Nonoperating rev(exp)
<br /> Interest income (87,003) 105,639_ 35,687 25,000 35,000 35,000
<br /> Total nonoperating rev(exp) (87,003) 105,639 35,687 25,000 35,000 35,000
<br /> Income before contributions and transfers 962,818 1,154,108 1,064,897 934,900 984,200 1,028,500
<br /> Transfer(Out)
<br /> General Fund (330,000) (361,850) (399,050) (438,950) (482,850) (531,150)
<br /> Park Improvement Fund (250,289) (282,519) (290,668) (280,000) (280,000) (280,000)
<br /> Other Projects (92,000) (40,690)-
<br /> Total (672,289) (685,059) (689,718) (718,950) (762,850) (811,150)
<br /> Change in net assets 290,529 469,049 375,179 215,950 221,350 217,350
<br /> Beginning net assets 4,486,806 4,777,335 4,767,280 5,142,459 5,358,409 5,579,759
<br /> Ending net assets 4,777,335 5,246,384 5,142,459 5,358,409 5,579,759 5,797,109
<br /> `Beginning net asset restated due to GASB 68 implementation
<br /> Gash Flow
<br /> Operating income(loss) 1,049,821 1,048,469 1,029,210 909,900 949,200 993,500
<br /> Depreciation 124,757 124,757 121,402 123,000 125,000 125,000
<br /> Other changes 24,174 5,451 (50,000) (50,000) (50,000)
<br /> Interfund Loan - - - - (850,000) 96,400
<br /> investment Income (89,759) 106,310 35,687 25,000 35,000 35,000
<br /> Transfers (672,289) (685,059) (689,718) (718,950) (762,850) (811,150)
<br /> Capital - - - - (100,000)
<br /> Net Cashflow 436,704 599,928 496,581 288,950 (553,650) 288,750
<br /> Beginning Cash 1,555,676 1,992,380 2,592,308 3,088,889 3,377,839 2,824,189
<br /> Ending cash 1,992,380 2,592,308 3,088,889 3,377,839 2,824,189 3,112,939
<br /> Target cash reserve amount(notel) 876,024 901,921 918,422 945,500 923,550 952,400
<br /> Cash over(under)minumum cash balance 1,116,356 1,690,387 2,170,467 2,432,339 1.900,639 2,160,539
<br /> Notes:
<br /> Note 1:Target cash reserve equals 1 year of operating City of Elk River
<br /> expenses,plus 100%of next year's debt Liquor Fund Cash Reserves
<br /> S4.000.000
<br /> ,
<br /> 5.1,090-000
<br /> $1,500,000
<br /> 11 9
<br /> 2013A 1". 2017F
<br /> 1
<br />
|