6-10-2014 12:40 PM CITY OF ELK RIVER PAGE: 21
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: MAY 31ST, 2014
<br /> 101-GENERAL FUND
<br /> Public Works 41.67° OF YEAR COMP.
<br /> CURRENT CURRENT YEAR TO DATE o OF BUDGET
<br /> DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br /> Snow Removal
<br /> Personal Services
<br /> 101-4-3130-4101 Regular Pay 121,650.00 26.88 79,163.28 65.07 42,486.72
<br /> 101-4-3130-4102 Overtime Pay 20,000.00 0.00 37,220.10 186.10 ( 17,220.10)
<br /> 101-4-3130-4104 PERA 9,850.00 1.95 10,253.37 104.10 ( 403.37)
<br /> 101-4-3130-4105 FICA 8,800.00 1.65 8,519.34 96.81 280.66
<br /> 101-4-3130-4107 Medicare 2,050.00 0.39 1,992.39 97.19 57.61
<br /> 101-4-3130-4108 Insurance 19,500.00 7.03 15,144.68 77.67 4,355.32
<br /> 101-4-3130-4109 Workers Comp 6,500.00 0.00 3,252.00 50.03 3,248.00
<br /> TOTAL Personal Services 188,350.00 37.90 155,545.16 82.58 32,804.84
<br /> Supplies
<br /> 101-4-3130-4219 Operating Supplies 89,400.00 147.20 82,515.20 92.3C 6,884.8C
<br /> TOTAL Supplies 89,400.00 147.20 82,515.20 92.30 6,884.8C
<br /> Other Services & Charges
<br /> Capital Outlay
<br /> TOTAL Snow Removal 277,750.00 185.10 238,060.36 85.71 39,689.64
<br /> Equipment Services
<br /> Personal Services
<br /> 101-4-3150-4101 Regular Pay 116,800.00 8,985.60 42,063.84 36.01 74,736.16
<br /> 101-4-3150-4102 Overtime Pay 1,000.00 20.16 727.42 72.74 272.58
<br /> 101-4-3150-4104 PERA 8,450.00 652.90 3,543.51 41.94 4,906.49
<br /> 101-4-3150-4105 FICA 7,250.00 525.63 2,877.03 39.68 4,372.97
<br /> 101-4-3150-4107 Medicare 1,700.00 122.95 672.88 39.58 1,027.12
<br /> 101-4-3150-4108 Insurance 13,450.00 1,081.60 5,248.52 39.02 8,201.48
<br /> 101-4-3150-4109 Workers Comp 3,000.00 0.00 1,490.50 49.68 1,509.5C
<br /> TOTAL Personal Services 151,650.00 11,388.84 56,623.70 37.34 95,026.3C
<br /> Supplies
<br /> 101-4-3150-4219 Operating Supplies 17,850.00 1,983.45 7,314.79 40.98 10,535.21
<br /> 101-4-3150-4221 Equipment Parts 10,000.00 1,960.61 8,067.51 80.68 1,932.49
<br /> TOTAL Supplies 27,850.00 3,944.06 15,382.30 55.23 12,467.7C
<br /> Other Services & Charges
<br /> 101-4-3150-4331 Travel, Conferences & Schools 1,500.00 0.00 0.00 0.00 1,500.00
<br /> 101-4-3150-4404 Equip Repair/Maint Services 1,000.00 0.00 674.95 67.50 325.05
<br /> 101-4-3150-4417 Uniform Rental 2,150.00 136.45 646.95 30.09 1,503.05
<br /> TOTAL Other Services & Charges 4,650.00 136.45 1,321.90 28.43 3,328.10
<br />
|