|
9 -06 -2012 08:22 AM
<br />CITY
<br />OF ELK RIVER
<br />PAGE: 4
<br />PROPOSED
<br />BUDGET WORKSHEET
<br />AS OF:
<br />AUGUST 31ST, 2012
<br />603- LIQUOR
<br />Northbound- Operations
<br />(-----------------
<br />2012 -----------------
<br />-- - ------ 2013
<br />)
<br />2009
<br />2010
<br />2011
<br />APPROVED
<br />CURRENT
<br />Y -T -D
<br />REQUESTED
<br />CITY ADMIN
<br />EXPENDITURES
<br />ACTUAL
<br />ACTUAL
<br />ACTUAL
<br />BUDGET
<br />BUDGET
<br />ACTUAL
<br />BUDGET
<br />BUDGET
<br />Personal Services
<br />603 -4- 9112 -4101 Regular Pay
<br />188,583
<br />214,647
<br />224,551
<br />227,900
<br />227,900
<br />149,119
<br />232,500
<br />0
<br />603 -4- 9112 -4102 Overtime Pay
<br />641
<br />808
<br />454
<br />0
<br />0
<br />0
<br />2,000
<br />0
<br />603 -4- 9112 -4103 Part -time Pay
<br />87,935
<br />88,345
<br />64,736
<br />70,950
<br />70,950
<br />44,091
<br />70,950
<br />0
<br />603 -4- 9112 -4104 PERA
<br />18,350
<br />19,525
<br />20,826
<br />21,650
<br />21,650
<br />14,776
<br />22,000
<br />0
<br />603 -4- 9112 -4105 FICA
<br />16,511
<br />17,895
<br />17,181
<br />18,550
<br />18,550
<br />12,319
<br />18,800
<br />0
<br />6.03 -4- 9112 -4106 Other Retirement Contributions
<br />( 72)
<br />{ 7,424)
<br />11,576
<br />0
<br />0
<br />0
<br />0
<br />0
<br />603 -4- 9112 -4107 Medicare
<br />3,862
<br />4,185
<br />4,018
<br />4,350
<br />4,350
<br />2,881
<br />4,400
<br />0
<br />603 -4 -9112 -4108 Insurance
<br />19,444
<br />28,378
<br />32,316
<br />34,650
<br />34,650
<br />22,536
<br />35,700
<br />0
<br />603 -4- 9112 -4109 Workers Comp
<br />3,541
<br />4,194
<br />4,110
<br />4,700
<br />4,700
<br />3,589
<br />4,550
<br />0
<br />603 -4- 9112 -4110 Re- employment Compensation
<br />71
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />TOTAL Personal Services
<br />338,866
<br />370,554
<br />379,768
<br />382,750
<br />382,750
<br />249,311
<br />390,900
<br />0
<br />Supplies
<br />603 -4- 9112 -4212 Fuels & Lubs
<br />181
<br />215
<br />320
<br />300
<br />300
<br />128
<br />300
<br />0
<br />603 -4- 9112 -4217 Uniform Allowance
<br />73
<br />757
<br />719
<br />11000
<br />1,000
<br />555
<br />1,000
<br />0
<br />603 -4- 9112 -4219 Operating Supplies
<br />5,748
<br />21,688
<br />17,111
<br />14,000
<br />14,000
<br />5,977
<br />17,000
<br />0
<br />TOTAL Supplies
<br />6,003
<br />22,660
<br />18,149
<br />15,300
<br />15,300
<br />6,660
<br />18,300
<br />0
<br />Other Services & Charges
<br />603 -4- 9112 -4301 Audit Fees
<br />2,880
<br />2,960
<br />3,005
<br />3,050
<br />3,050
<br />2,987
<br />3,050
<br />0
<br />603 -4 -9112 -4319 Other Professional Services
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />603 -4- 9112 -4321 Telephone
<br />2,412
<br />2,518
<br />2,250
<br />2;500
<br />2,500
<br />1,558
<br />2,500
<br />0
<br />603 -4- 9112 -4322 Postage
<br />0
<br />3
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />603 -4- 9112 -4331 Travel, Conferences & Schools
<br />45
<br />321
<br />15
<br />500
<br />500
<br />40
<br />500
<br />0
<br />603 -4- 9112 -4349 Advertising /Marketing
<br />14,509
<br />7,853
<br />6,067
<br />81000
<br />8,000
<br />3,691
<br />7,500
<br />0
<br />603 -4- 9112 -4361 Insurance
<br />12,133
<br />11,683
<br />10,531
<br />12,050
<br />12,050
<br />4,938
<br />10,300
<br />0
<br />603 -4- 9112 -4389 Utilities
<br />31,223
<br />31,809
<br />32,881
<br />30,000
<br />30,000
<br />16,311
<br />28,000
<br />0
<br />603 -4- 9112 -4404 Equip Repair /Maint Services
<br />22,990
<br />8,689
<br />11,858
<br />15,000
<br />15,000
<br />8,251
<br />19,000
<br />0
<br />603 -4- 9112 -4405 Cleaning Services
<br />544
<br />273
<br />0
<br />2,000
<br />2,000
<br />0
<br />0
<br />0
<br />603 -4- 9112 -4420 Depreciation
<br />46,731
<br />47,358
<br />47,358
<br />47,350
<br />47,350
<br />0
<br />47,350
<br />0
<br />603 -4- 9112 -4431 Cash Short
<br />275
<br />0
<br />0
<br />0
<br />0
<br />289
<br />0
<br />0
<br />603 -4- 9112 -4433 Dues & Subscriptions
<br />3,630
<br />3,545
<br />3,499
<br />3,500
<br />3,500
<br />2,349
<br />3,500
<br />0
<br />603 -4- 9112 -4437 Taxes & Licenses
<br />384
<br />278
<br />270
<br />400
<br />400
<br />( 35,953)
<br />300
<br />0
<br />603 -4- 9112 -4438 Credit Card Fees
<br />58,879
<br />61,806
<br />59,318
<br />62,000
<br />62,000
<br />30,424
<br />60,000
<br />0
<br />603 -4 -9112 -4440 Miscellaneous
<br />11196
<br />723
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />TOTAL Other Services & Charges
<br />197,831
<br />179,818
<br />177,051
<br />186,350
<br />186,350
<br />34,885
<br />182,000
<br />0
<br />Capital Outlay
<br />603 -4- 9112 -4510 Land
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />603 -4- 9112 -4530 Improvement Project Contract
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />603 -4- 9112 -4560 Equipment
<br />0
<br />0
<br />0
<br />55,000
<br />55,000
<br />30,478
<br />0
<br />0
<br />TOTAL Capital Outlay
<br />0
<br />0
<br />0
<br />55,000
<br />55,000
<br />30,478
<br />0
<br />0
<br />
|