|
CITY OF PEQUOT LAKES Budget Worksheet - 2012 Preliminary Budget
<br />Period: 09/11
<br />Page: 17
<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 />WATER FUND
<br />INTERGOVERNMENTAL REVENUES
<br />601 - 33401 -000 PERA AID
<br />21
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total INTERGOVERNMENTAL REVENUES:
<br />21
<br />.00
<br />.00
<br />.00
<br />.00
<br />ASSESSMENTS/PRINCIPAL/INTEREST
<br />601 - 36101 -000 SPECIAL ASSESSMENTS
<br />32
<br />.00
<br />.00
<br />.00
<br />.00
<br />601 - 36203 -000 MISCELLANEOUS REVENUE
<br />217
<br />.00
<br />.00
<br />.00
<br />.00
<br />601 - 36210 -000 INTEREST EARNINGS
<br />4,102
<br />8,800
<br />5,500
<br />( 3,300)
<br />- 60.00%
<br />Total ASSESSMENTS /PRINCIPAL/INTEREST:
<br />4,351
<br />8,800
<br />5,500
<br />( 3,300)
<br />- 60.00%
<br />WATER SALES
<br />601- 37110 -000 WATER SALES
<br />167,771
<br />221,980
<br />214,970
<br />( 7,010)
<br />-3.26%
<br />Budget notes:
<br />2012 PER RATE STUDY
<br />601 - 37171 -000 STATE SALES TAX COLLECTED
<br />3,362
<br />.00
<br />4,000
<br />4,000
<br />100.00%
<br />601 - 37172 -000 WATER METER FEES
<br />9,144
<br />10,750
<br />11,220
<br />470
<br />4.19%
<br />Budget notes:
<br />-2012 PER RATE STUDY
<br />Total WATER SALES:
<br />180,277
<br />232,730
<br />230,190
<br />( 2,540)
<br />-1.10%
<br />OTHER FINANCING SOURCES
<br />601 - 39990 -000 REFUNDS & REIMBURSEMENTS
<br />2,460
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total OTHER FINANCING SOURCES:
<br />2,460
<br />.00
<br />.00
<br />.00
<br />.00
<br />TRANSFERS TO OTHER FUNDS
<br />601 -49350 -720 TRANSFERS
<br />465
<br />.00
<br />.00
<br />.00
<br />.00
<br />Total TRANSFERS TO OTHER FUNDS:
<br />465
<br />.00
<br />.00
<br />.00
<br />.00
<br />WATER
<br />601 -49400 -100 WAGES
<br />18,227
<br />47,700
<br />16,470
<br />( 31,230)
<br />- 189.62%
<br />Budget notes:
<br />-2012 1.25% INCREASE
<br />601 -49400 -121 EMPLOYER SHARE - PERA
<br />1,185
<br />3,290
<br />1,190
<br />( 2,100)
<br />- 176.47%
<br />601 - 49400 -122 EMPLOYER SHARE - FICA
<br />1,089
<br />2,960
<br />1,030
<br />( 1,930)
<br />- 187.38%
<br />601 - 49400 -125 EMPLOYER SHARE - MEDICARE
<br />270
<br />700
<br />240
<br />( 460)
<br />- 191.67%
<br />601 -49400 -131 EMPLOYER SHARE - HEALTH INSURA
<br />2,973
<br />6,200
<br />3,260
<br />( 2,940)
<br />- 90.18%
<br />Budget notes:
<br />^-2012 0% INCREASE
<br />601 -49400 -133 EMPLOYER SHARE - LIFE INSURANC
<br />23
<br />70
<br />20
<br />( 50)
<br />- 250.00%
<br />601 -49400 -200 OFFICE SUPPLIES
<br />115
<br />350
<br />500
<br />150
<br />30.00%
<br />601 -49400 -210 OPERATING SUPPLIES
<br />5,236
<br />6,500
<br />6,500
<br />.00
<br />.00
<br />Budget notes:
<br />-2012 WATER SERVICE REPAIR PARTS, EQUIP & BLDG MAINT SUPPLIES
<br />601 -49400 -217 CLOTHING ALLOWANCE
<br />.00
<br />100
<br />100
<br />.00
<br />.00
<br />601 -49400 -303 ENGINEERING FEES
<br />736
<br />1,000
<br />5,000
<br />4,000
<br />80.00%
<br />Budget notes:
<br />-2012 GOVERNMENT DR PROJECT
<br />601 -49400 -304 LEGAL FEES
<br />345
<br />500
<br />1,500
<br />1,000
<br />66.67%
<br />Budget notes:
<br />2012 GOVERNMENT DR
<br />
|