9-10-2014 09:35 AM CITY OF ELK RIVER PAGE: 21
<br /> REVENUE & EXPENSE REPORT (UNAUDITED)
<br /> AS OF: AUGUST 31ST, 2014
<br /> 101-GENERAL FUND
<br /> Public Works 66.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 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 0.00 87,486.89 97.86 1,913.11
<br /> TOTAL Supplies 89,400.00 0.00 87,486.89 97.86 1,913.11
<br /> Other Services & Charges
<br /> Capital Outlay
<br /> TOTAL Snow Removal 277,750.00 0.00 244,658.05 88.09 33,091.95
<br /> Equipment Services
<br /> Personal Services
<br /> 101-4-3150-4101 Regular Pay 116,800.00 13,478.40 73,513.44 62.94 43,286.56
<br /> 101-4-3150-4102 Overtime Pay 1,000.00 40.32 828.22 82.82 171.78
<br /> 101-4-3150-4103 Part-time Pay 0.00 1,337.50 1,337.50 0.00 ( 1,337.50)
<br /> 101-4-3150-4104 PERA 8,450.00 980.09 5,830.87 69.00 2,619.13
<br /> 101-4-3150-4105 FICA 7,250.00 888.04 4,816.94 66.44 2,433.06
<br /> 101-4-3150-4107 Medicare 1,700.00 207.69 1,126.60 66.27 573.40
<br /> 101-4-3150-4108 Insurance 13,450.00 1,124.01 8,620.55 64.09 4,829.45
<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 18,056.05 98,309.87 64.83 53,340.13
<br /> Supplies
<br /> 101-4-3150-4212 Fuels & Lubes 0.00 744.80 3,533.51 0.00 ( 3,533.51)
<br /> 101-4-3150-4219 Operating Supplies 17,850.00 590.23 10,431.21 58.44 7,418.79
<br /> 101-4-3150-4221 Equipment Parts 10,000.00 23.83 11,271.80 112.72 ( 1,271.8C)
<br /> TOTAL Supplies 27,850.00 1,358.86 25,236.52 90.62 2,613.48
<br />
|