|
CITY OF RAMSEY
<br />FINANCIAL STATEMENT
<br />JANUARY 1, 2020 THROUGH PERIOD ENDING:
<br />May 31, 2021
<br />REVENUES
<br />BUSINESS UNIT
<br />GENERAL LEDGER ACCOUNT
<br />9601 WATER UTILITY
<br />CURRENT YEAR CURRENT YTD GENERAL
<br />REQUESTED BUDGET LEDGER
<br />-% of Budget-
<br />4140 CREDIT CARD PROCESSING FEES
<br />4609 OTHER MISCELLANEOUS REVENUES
<br />4651 WATER REVENUE
<br />4652 WATER SALES - RESIDENTIAL
<br />4653 WATER SALES -COMMERCIAL
<br />4654 WATER PENALTIES
<br />4655 WATER METER INSTALLATION
<br />4656 WATER METERS
<br />4657 CONNECTION/RECONNECTION FEES
<br />4701 INTEREST ON INVESTMENTS
<br />4606 DEVELOPER FEES (WAC)
<br />4601 MISCELLANEOUS REVENUE
<br />6436 WATER EFFICIENCY REBATE PROG
<br />Grand Total
<br />(20,000.00)
<br />12, 000.00
<br />1,334,128.00
<br />700,510.00
<br />15,000.00
<br />12, 000.00
<br />30, 000.00
<br />500.00
<br />100, 000.00
<br />(4,820.91)
<br />767.56
<br />100.65
<br />258,131.15
<br />74, 544.72
<br />(58.93)
<br />7,140.00
<br />14,575.00
<br />250.00
<br />237,660.00
<br />1,568.97
<br />627.95
<br />24.10%
<br />6.40%
<br />0.00%
<br />19.35%
<br />10.64%
<br />-0.39%
<br />59.50%
<br />48.58%
<br />50.00%
<br />0.00%
<br />0.00%
<br />0.00%
<br />0.00%
<br />2,184,138.00
<br />590,486.16
<br />EXPENSES
<br />BUSINESS UNIT
<br />GENERAL LEDGER ACCOUNT
<br />9601 WATER UTILITY
<br />CURRENT YEAR CURRENT YTD GENERAL
<br />REQUESTED BUDGET LEDGER
<br />-% of Budget-
<br />6102 F.T. REGULAR -WAGES & SALARIES
<br />6103 FULL TIME -REGULAR -OVERTIME
<br />6105 TEMPORARY -WAGES & SALARIES
<br />6121 PERA CONTRIBUTIONS
<br />6122 FICA/MEDICARE CONTRIBUTIONS
<br />6131 GROUP INSURANCE
<br />6133 WORKERS COMP INSURANCE PREMIUM
<br />6208 MISCELLANEOUS OFFICE SUPPLIES
<br />6223 GASOLINE
<br />6225 DIESEL FUEL
<br />6229 SHOP MATERIALS
<br />271,061.00
<br />13,500.00
<br />19,167.00
<br />56, 342.00
<br />23,235.00
<br />36,250.00
<br />15,406.00
<br />600.00
<br />6,000.00
<br />1,500.00
<br />600.00
<br />73,875.54
<br />6,747.13
<br />3,731.18
<br />6,927.04
<br />7,443.74
<br />11,029.25
<br />(41.96)
<br />3,064.13
<br />39.96
<br />27.25%
<br />49.98%
<br />19.47%
<br />12.29%
<br />32.04%
<br />30.43%
<br />0.00%
<br />-6.99%
<br />51.07%
<br />0.00%
<br />6.66%
<br />6231 UNIFORMS & TURN -OUT GEAR
<br />6249 MISCELLANEOUS OPERATING SUPPLY
<br />2,900.00
<br />18,000.00
<br />2,175.00
<br />8,109.42
<br />75.00%
<br />45.05%
<br />6257 OTHER VEHICLE PARTS
<br />6273 UTILITY SYSTEM MAINT SUPPLIES
<br />5,000.00
<br />95, 000.00
<br />396.59
<br />13,887.20
<br />7.93%
<br />14.62%
<br />6281 SMALL TOOLS & MINOR EQUIPMENT
<br />6292 WATER METERS FOR RESALE
<br />10,000.00
<br />75, 000.00
<br />25,557.55
<br />36,344.07
<br />255.58%
<br />48.46%
<br />6315 MISCELLANEOUS PROFESSIONAL SER 95,000.00 13,780.12 14.51%
<br />6322 POSTAGE 3,000.00 172.25 5.74%
<br />6323 CELLULAR PHONES 4,000.00 1,382.84 34.57%
<br />6334 MILEAGE REIMBURSEMENT 400.00 0.00%
<br />6335 TRAINING 4,000.00 1,383.00 34.58%
<br />6352 GENERAL NOTICE & PUBLIC INFOR 300.00 107.50 35.83%
<br />6361 GENERAL LIABILITY/PROPERTY INS 35,000.00 5,872.00 16.78%
<br />6371 ELECTRIC UTILITIES 155,000.00 33,478.24 21.60%
<br />6373 GAS 3,000.00 1,405.20 46.84%
<br />6374 REFUSE/RECYCLING 700.00 266.49 38.07%
<br />6381 BUILDING & STRUCTURE REPAIR 3,500.00 805.58 23.02%
<br />6439 OTHER MISCELLANEOUS 67,000.00 0.00%
<br />6451 MEMBERSHIP DUES 1,400.00 1,000.00 71.43%
<br />6489 OTHER CONTRACTED SERVICES 76,000.00 24,686.98 32.48%
<br />6722 DEPRECIATION 798,000.00 0.00%
<br />6820 OPERATING TRANSFERS TO OTHER F 47,000.00 0.00%
<br />6436 WATER EFFICIENCY REBATE PROG 627.95 0.00%
<br />Grand Total 1,942,861.00 284,253.99
<br />Note: The Finance Department has highlighted line items that may be trending towards exceeding budget OR not may not have been
<br />included in the adopted budget.
<br />This report reflects year to date revenue and expenditures as compared to annual budget.
<br />It does not reflect fund balance. Business Unit: 9601
<br />Page 1 of 5
<br />
|