7-15-2014 08:14 AM CITY OF ELK RIVER PAGE: 2C
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: JUNE 30TH, 2014
<br /> 101-GENERAL FUND
<br /> Public Works 50.00° OF YEAR COMP.
<br /> CURRENT CURRENT YEAR TO DATE o OF BUDGET
<br /> DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br /> Street Maintenance
<br /> Personal Services
<br /> 101-4-3120-4101 Regular Pay 464,300.00 44,464.64 190,052.99 40.93 274,247.01
<br /> 101-4-3120-4102 Overtime Pay 4,000.00 512.33 3,039.93 76.00 960.07
<br /> 101-4-3120-4103 Part-time Pay 69,500.00 6,186.75 23,088.20 33.22 46,411.8C
<br /> 101-4-3120-4104 PERA 37,400.00 3,484.67 16,285.92 43.55 21,114.08
<br /> 101-4-3120-4105 FICA 33,350.00 3,022.68 13,664.43 40.97 19,685.57
<br /> 101-4-3120-4107 Medicare 7,800.00 706.93 3,195.71 40.97 4,604.29
<br /> 101-4-3120-4108 Insurance 74,150.00 6,672.06 25,449.13 34.32 48,700.87
<br /> 101-4-3120-4109 Workers Comp 26,500.00 6,630.00 19,890.00 75.06 6,610.00
<br /> TOTAL Personal Services 717,000.00 71,680.06 294,666.31 41.10 422,333.69
<br /> Supplies
<br /> 101-4-3120-4201 Office Supplies 2,800.00 170.71 814.95 29.11 1,985.05
<br /> 101-4-3120-4212 Fuels & Lubes 81,700.00 6,749.72 54,393.52 66.58 27,306.48
<br /> 101-4-3120-4219 Operating Supplies 106,350.00 8,111.38 32,016.62 30.10 74,333.38
<br /> 101-4-3120-4221 Equipment Parts 0.00 5,601.89 15,064.91 0.00 ( 15,064.91)
<br /> 101-4-3120-4226 Street Signs 32,600.00 11,237.53 20,028.71 61.44 12,571.29
<br /> TOTAL Supplies 223,450.00 31,871.23 122,318.71 54.74 101,131.29
<br /> Other Services & Charges
<br /> 101-4-3120-4319 Other Professional Services 550.00 0.00 0.00 0.00 550.00
<br /> 101-4-3120-4321 Telephone 6,100.00 574.56 2,917.80 47.83 3,182.2C
<br /> 101-4-3120-4322 Postage 100.00 0.00 15.16 15.16 84.84
<br /> 101-4-3120-4331 Travel, Conferences & Schools 3,500.00 0.00 824.65 23.56 2,675.3E
<br /> 101-4-3120-4359 Publishing 200.00 0.00 0.00 0.00 200.00
<br /> 101-4-3120-4361 Insurance 18,450.00 0.00 9,016.50 48.87 9,433.5C
<br /> 101-4-3120-4389 Utilities 53,400.00 5,513.26 39,454.72 73.89 13,945.28
<br /> 101-4-3120-4401 Bldg Repair/Maint Services 10,450.00 1,226.36 4,956.52 47.43 5,493.48
<br /> 101-4-3120-4404 Equip Repair/Maint Services 6,000.00 0.00 1,793.37 29.89 4,206.63
<br /> 101-4-3120-4409 Contractual Services 100,000.00 1,480.00 5,327.85 5.33 94,672.1E
<br /> 101-4-3120-4415 Equipment Rental 4,800.00 501.99 696.13 14.50 4,103.87
<br /> 101-4-3120-4417 Uniform Rental 5,800.00 217.63 1,446.09 24.93 4,353.91
<br /> 101-4-3120-4433 Dues & Subscriptions 350.00 0.00 267.50 76.43 82.5C
<br /> 101-4-3120-4437 Taxes & Licenses 150.00 0.00 416.00 277.33 ( 266.00)
<br /> 101-4-3120-4460 Equip Replacement Charge 89,450.00 7,454.17 44,725.02 50.00 44,724.98
<br /> TOTAL Other Services & Charges 299,300.00 16,967.97 111,857.31 37.37 187,442.69
<br /> Capital Outlay
<br /> TOTAL Street Maintenance 1,239,750.00 120,519.26 528,842.33 42.66 710,907.67
<br />
|