8-05-2014 01:46 PM CITY OF ELK RIVER PAGE: 21
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: JULY 31ST, 2014
<br /> 101-GENERAL FUND
<br /> Public Works 58.33° 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 0.00 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 0.00 10,253.37 104.10 ( 403.37)
<br /> 101-4-3130-4105 FICA 8,800.00 0.00 8,519.34 96.81 280.66
<br /> 101-4-3130-4107 Medicare 2,050.00 0.00 1,992.39 97.19 57.61
<br /> 101-4-3130-4108 Insurance 19,500.00 0.00 15,144.68 77.67 4,355.32
<br /> 101-4-3130-4109 Workers Comp 6,500.00 0.00 4,878.00 75.05 1,622.00
<br /> TOTAL Personal Services 188,350.00 0.00 157,171.16 83.45 31,178.84
<br /> Supplies
<br /> 101-4-3130-4219 Operating Supplies 89,400.00 1,189.86 87,486.89 97.86 1,913.11
<br /> TOTAL Supplies 89,400.00 1,189.86 87,486.89 97.86 1,913.11
<br /> Other Services & Charges
<br /> Capital Outlay
<br /> TOTAL Snow Removal 277,750.00 1,189.86 244,658.05 88.09 33,091.95
<br /> Equipment Services
<br /> Personal Services
<br /> 101-4-3150-4101 Regular Pay 116,800.00 8,985.60 60,035.04 51.40 56,764.96
<br /> 101-4-3150-4102 Overtime Pay 1,000.00 60.48 787.90 78.79 212.1C
<br /> 101-4-3150-4104 PERA 8,450.00 655.83 4,850.78 57.41 3,599.22
<br /> 101-4-3150-4105 FICA 7,250.00 527.81 3,928.90 54.19 3,321.1C
<br /> 101-4-3150-4107 Medicare 1,700.00 123.45 918.91 54.05 781.09
<br /> 101-4-3150-4108 Insurance 13,450.00 1,124.01 7,496.54 55.74 5,953.46
<br /> 101-4-3150-4109 Workers Comp 3,000.00 0.00 2,235.75 74.53 764.25
<br /> TOTAL Personal Services 151,650.00 11,477.18 80,253.82 52.92 71,396.18
<br /> Supplies
<br /> 101-4-3150-4212 Fuels & Lubes 0.00 2,671.67 2,788.71 0.00 ( 2,788.71)
<br /> 101-4-3150-4219 Operating Supplies 17,850.00 967.92 9,840.98 55.13 8,009.02
<br /> 101-4-3150-4221 Equipment Parts 10,000.00 1,048.25 11,247.97 112.48 ( 1,247.97)
<br /> TOTAL Supplies 27,850.00 4,687.84 23,877.66 85.74 3,972.34
<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 856.90 85.69 143.1C
<br /> 101-4-3150-4417 Uniform Rental 2,150.00 190.66 1,017.80 47.34 1,132.2C
<br /> TOTAL Other Services & Charges 4,650.00 190.66 1,874.70 40.32 2,775.3C
<br />
|