|
CITY OF PEQUOT LAKES Budget Worksheet - 2012 Preliminary Budget
<br />Period: 09/11
<br />Page: 18
<br />Oct 17, 2011 01:14PM
<br />01/11 -09/11
<br />2011
<br />2012
<br />Current year
<br />Current year
<br />Preliminary
<br />Budget
<br />Budget
<br />Account Number Account Title
<br />Actual
<br />Budget
<br />Budget
<br />Variance
<br />Variance%
<br />601 - 49400 -305 MEDICAL
<br />.00
<br />200
<br />200
<br />.00
<br />.00
<br />601 -49400 -308 TRAVEL/CONFERENCES /SCHOOLS
<br />208
<br />500
<br />500
<br />.00
<br />.00
<br />601 -49400 -310 SALES & USE TAX
<br />3,057
<br />300
<br />4,300
<br />4,000
<br />93.02%
<br />601 -49400 -311 RISK MANAGEMENT
<br />49
<br />200
<br />200
<br />.00
<br />.00
<br />Budget notes:
<br />-2012 SAFETY EQUIP
<br />601 -49400 -313 CONTRACT SERVICES
<br />13,769
<br />6,400
<br />31,500
<br />25,100
<br />79.68%
<br />Budget notes:
<br />-2012 SOFTWARE SUPPORT, SERVICE CONTRACTS ON EQUIP,
<br />TESTING,
<br />PRASD
<br />601 -49400 -321 TELEPHONE
<br />744
<br />1,000
<br />1,100
<br />100
<br />9.09%
<br />601 -49400 -322 POSTAGE
<br />1,189
<br />1,200
<br />1,200
<br />.00
<br />.00
<br />601 -49400 -334 FUEL
<br />931
<br />1,150
<br />1,750
<br />600
<br />34.29%
<br />601 -49400 -350 PUBLISHING
<br />259
<br />300
<br />300
<br />.00
<br />.00
<br />601 -49400 -360 INSURANCE
<br />6,063
<br />6,600
<br />6,500
<br />( 100)
<br />-1.54%
<br />Budget notes:
<br />2012 5% INCREASE
<br />601 -49400 -381 ELECTRICITY
<br />7,319
<br />10,000
<br />12,000
<br />2,000
<br />16.67%
<br />601 -49400 -383 HEATING
<br />1,554
<br />2,500
<br />2,500
<br />.00
<br />.00
<br />601 -49400 -384 SANITATION
<br />.00
<br />.00
<br />200
<br />200
<br />100.00%
<br />601 -49400 -386 WELLHEAD PROTECTION
<br />.00
<br />500
<br />2,000
<br />1,500
<br />75.00%
<br />601 - 49400 -400 REPAIR/MAINTENANCE /SERVICES
<br />7,409
<br />18,000
<br />15,000
<br />( 3,000)
<br />- 20.00%
<br />Budget notes:
<br />2012 PUMP MAINT, REPAIR & REPLACEMENT OF EQUIP
<br />601 - 49400 -433 DUES /LICENSING /SUBSCRIPTIONS
<br />3,700
<br />3,800
<br />6,000
<br />2,200
<br />36.67%
<br />Budget notes:
<br />-2012 MDH, MMUA, MRWA, DNR WTP PERMIT RE- ISSUANCE FEE
<br />601 -49400 -500 CAPITAL OUTLAY
<br />.00
<br />4,000
<br />5,000
<br />1,000
<br />20.00%
<br />Budget notes:
<br />-2012 GOVERNMENT DR PROJECT
<br />601 -49400 -601 DEBT SERVICE - PRINCIPAL
<br />46,577
<br />23,800
<br />24,880
<br />1,080
<br />4.34%
<br />Budget notes:
<br />-2012 USDA GENERAL OBLIGATION BOND
<br />601 -49400 -610 DEBT SERVICE - INTEREST
<br />65,340
<br />65,340
<br />64,270
<br />( 1,070)
<br />-1.66%
<br />Budget notes:
<br />-2012 USDA GENERAL OBLIGATION BOND
<br />601 -49400 -810 REFUNDS & REIMBURSEMENTS
<br />438
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total WATER:
<br />188,803
<br />215,160
<br />215,210
<br />50
<br />0.02%
<br />WATER FUND Revenue Total:
<br />187,109
<br />241,530
<br />235,690
<br />( 5,840)
<br />-2.48%
<br />WATER FUND Expenditure Total:
<br />189,268
<br />215,160
<br />215,210
<br />50
<br />0.02%
<br />Net Total WATER FUND:
<br />( 2,159) 26,370 20,480 ( 5,890) - 28.76%
<br />
|