|
CITY OF PEQUOT LAKES
<br />EXPENDITURES WITH COMPARISON TO BUDGET
<br />FOR THE 9 MONTHS ENDING SEPTEMBER 30, 2023
<br />WATER FUND
<br />MONTH YTD ANNUAL YTD % OF PRIOR YTD PRIOR YR PRIOR
<br />ACTUAL YTD ACTU BUDGET VARIANCE BUDGET PERIOD ACTUAL BUDGET
<br />WATER
<br />601 -49400 -100
<br />WAGES
<br />6,800
<br />62,048
<br />83,500
<br />21,452
<br />74%
<br />5,373
<br />36,283
<br />28,370
<br />601 -49400 -121
<br />EMPLOYER SHARE - PERA
<br />514
<br />4,682
<br />6,250
<br />1,568
<br />75%
<br />404
<br />2,745
<br />2,130
<br />601 -49400 -122
<br />EMPLOYER SHARE - FICA
<br />412
<br />3,771
<br />5,400
<br />1,629
<br />70%
<br />325
<br />2,158
<br />1,760
<br />601 -49400 -125
<br />EMPLOYER SHARE - MEDICARE
<br />96
<br />882
<br />1,300
<br />418
<br />68%
<br />76
<br />513
<br />420
<br />601 -49400 -131
<br />EMPLOYER SHARE - HEALTH INSURA
<br />869
<br />7,474
<br />14,800
<br />7,326
<br />51%
<br />551
<br />4,990
<br />4,510
<br />601 -49400 -133
<br />EMPLOYER SHARE - LIFE INSURANC
<br />4
<br />37
<br />30
<br />-7
<br />123%
<br />4
<br />25
<br />20
<br />601 -49400 -142
<br />UNEMPLOYMENT COMPENSATION
<br />0
<br />0
<br />0
<br />0
<br />%
<br />0
<br />1,210
<br />1,020
<br />601 -49400 -200
<br />OFFICE SUPPLIES
<br />0
<br />380
<br />900
<br />520
<br />42%
<br />0
<br />612
<br />850
<br />601 -49400 -210
<br />OPERATING SUPPLIES
<br />1,084
<br />10,689
<br />35,000
<br />24,311
<br />31%
<br />2,457
<br />14,425
<br />15,000
<br />601 -49400 -300
<br />PROFESSIONAL SERVICES
<br />0
<br />198
<br />1,000
<br />802
<br />20%
<br />0
<br />631
<br />1,000
<br />601 -49400 -303
<br />ENGINEERING FEES
<br />0
<br />0
<br />10,000
<br />10,000
<br />%
<br />0
<br />0
<br />11,000
<br />601 -49400 -304
<br />LEGAL FEES
<br />0
<br />2,106
<br />0
<br />-2,106
<br />%
<br />165
<br />639
<br />0
<br />601 -49400 -308
<br />TRAVEL/CONFERENCES /SCHOOLS
<br />0
<br />0
<br />500
<br />500
<br />%
<br />0
<br />45
<br />500
<br />601 -49400 -310
<br />SALES & USE TAX
<br />0
<br />1,128
<br />7,000
<br />5,872
<br />16%
<br />841
<br />3,968
<br />5,000
<br />601 -49400 -313
<br />CONTRACT SERVICES
<br />271
<br />16,805
<br />14,000
<br />-2,805
<br />120%
<br />2,152
<br />27,113
<br />52,970
<br />601 -49400 -321
<br />TELEPHONE
<br />103
<br />945
<br />1,000
<br />55
<br />95%
<br />102
<br />644
<br />0
<br />601 -49400 -322
<br />POSTAGE
<br />237
<br />1,105
<br />1,200
<br />95
<br />92%
<br />243
<br />952
<br />1,500
<br />601 -49400 -334
<br />FUEL
<br />201
<br />1,431
<br />5,000
<br />3,569
<br />29%
<br />150
<br />941
<br />800
<br />601 -49400 -350
<br />PUBLISHING
<br />76
<br />204
<br />200
<br />-4
<br />102%
<br />51
<br />102
<br />200
<br />601 -49400 -360
<br />INSURANCE
<br />0
<br />6,170
<br />4,000
<br />-2,170
<br />154%
<br />967
<br />3,868
<br />3,050
<br />601 -49400 -381
<br />ELECTRICITY
<br />2,052
<br />14,989
<br />15,000
<br />11
<br />100%
<br />1,718
<br />11,907
<br />13,000
<br />601 -49400 -383
<br />HEATING
<br />1
<br />1,230
<br />2,200
<br />970
<br />56%
<br />32
<br />1,915
<br />1,500
<br />601 -49400 -386
<br />WELLHEAD PROTECTION
<br />0
<br />0
<br />500
<br />500
<br />%
<br />0
<br />0
<br />500
<br />601 - 49400 -400
<br />REPAIR/MAINTENANCE /SERVICES
<br />0
<br />3,674
<br />40,000
<br />36,326
<br />9%
<br />0
<br />41,038
<br />30,000
<br />601 - 49400 -433
<br />DUES /LICENSING /SUBSCRIPTIONS
<br />13
<br />6,180
<br />6,400
<br />220
<br />97%
<br />4
<br />6,479
<br />6,310
<br />601 -49400 -500
<br />CAPITAL OUTLAY
<br />0
<br />0
<br />0
<br />0
<br />%
<br />0
<br />3,030
<br />0
<br />601 -49400 -601
<br />DEBT SERVICE - PRINCIPAL
<br />0
<br />65,000
<br />65,000
<br />0
<br />100%
<br />0
<br />0
<br />65,000
<br />601 -49400 -610
<br />DEBT SERVICE - INTEREST
<br />0
<br />18,160
<br />18,160
<br />0
<br />100%
<br />0
<br />9,405
<br />19,460
<br />601- 49400 -620
<br />FISCAL AGENT FEES
<br />0
<br />550
<br />500
<br />-50
<br />110%
<br />0
<br />550
<br />500
<br />601 -49400 -810
<br />REFUNDS & REIMBURSEMENTS
<br />0
<br />0
<br />0
<br />0
<br />%
<br />45
<br />382
<br />0
<br />FOR ADMINISTRATION USE ONLY
<br />75 % OF THE FISCAL YEAR HAS ELAPSED
<br />11/02/2023 03:50PM PAGE: 46
<br />
|