|
6-17-2011 01:01 PM CITY OF ELK RIVER PAGE: 3
<br />REVENUE & EXPENSE REPORT (UNAUDITED)
<br />AS OF: MAY 31ST, 2011
<br />I 222-PINEWOOD GOLF COURSE
<br />41.67$ OF YEAR COMP.
<br />CURRENT CURRENT YEAR TO DATE $ OF BUDGET
<br />DEPARTMENTAL EXPENDITURES BUDGET PERIOD ACTUAL BUDGET BALANCE
<br />Golf Course
<br />Personal Services
<br />222-4-5300-4101 Regular Pay 93,650. 00 6,930 .24 32,263. 15 34. 45 61,386 .85
<br />222-4-5300-4103 Part-time Pay 29,900. 00 2,216 .03 2,932. 09 9. 81 26,967 .96
<br />222-4-5300-4104 PERA 8,950. 00 657 .31 2,419. 73 27. 04 6,530 .27
<br />222-4-5300-4105 FICA 7,650. 00 561 .26 2,293. 48 29. 96 5,356 .52
<br />222-4-5300-4107 Medicare 1,800. 00 131 .26 536. 39 29. 80 1,263 .66
<br />222-9-5300-4108 Insurance 10,150. 00 458 .01 2,290. 05 22. 56 7,859 .95
<br />222-4-5300-4109 Workers Comp 1,400. 00 0 .00 636. 00 59. 71 564 .00
<br />222-4-5300-4110 Re-employment Compensation 0. 00 0 .00 4,842. 25 0. 00 ( 4,842 .25)
<br />TOTAL Personal Services 153,500. 00 10,954 .11 48,413. 04 31. 54 105,086 .96
<br />Supplies
<br />222-4-5300-4212 Fuels & Lubs 5,000. 00 1,689 .39 1,689. 39 33. 79 3,310 .61
<br />222-4-5300-9217 Uniform Allowance 500. 00 53 .40 413. 40 82. 68 86 .60
<br />222-4-5300-4219 Operating Supplies 30,400. 00 8,204 .66 13,101. 30 43. 10 17,298 .70
<br />222-4-5300-4259 Other Merchandise For Resale 14,500. 00 1,831 .52 2,347. 59 16. 19 12,152 .91
<br />TOTAL Supplies 50,400. 00 11,778 .97 17,551. 68 34. 82 32,848 .32
<br />Other Services & Charges
<br />222-4-5300-4321 Telephone 2,500. 00 193 .23 622. 29 24. 69 1,877 .71
<br />222-4-5300-4331 Travel, Conferences & Schools 500. 00 208 .27 208. 27 41. 65 291 .73
<br />222-4-5300-4349 Advertising/Marketing 1,300. 00 0 .00 195. 00 15. 00 1,105 .00
<br />222-4-5300-4361 Insurance 11,900. 00 0 .00 5,296. 50 49. 51 6,603 .50
<br />222-4-5300-4389 Utilities 7,150. 00 409 .54 801. 77 11. 21 6,348 .23
<br />222-4-5300-4401 Bldg Repair/Maint Services 2,300. 00 20 .04 250. 66 10. 90 2,049 .34
<br />222-4-5300-4404 Equip Repair/Maint Services 3,000. 00 553 .09 1,830. 99 61. 02 1,169 .51
<br />222-4-5300-4415 Equipment Rental 2,000. 00 587 .51 608. 67 30. 43 1,391 .33
<br />222-4-5300-4937 Taxes & Licenses 1,000. 00 ( 183 .00)( 1,017. 48) 101. 75- 2,017 .46
<br />222-4-5300-4438 Credit Card Fees 5,500. 00 500 .02 712. 99 12. 96 4,787. 01
<br />TOTAL Other Services & Charges 37,150. 00 2,288 .70 9,509. 16 25. 60 27,690. 84
<br />Capital Outlay
<br />i
<br />Debt Service
<br />222-4-5300-4601 Principal 8,500. 00 1,416 .00 2,832. 00 33. 32 5,668. 00
<br />TOTAL Debt Service 8,500. 00 1,416 .00 2,832. 00 33. 32 5,668.00
<br />TOTAL Golf Course 249,550. 00 26,437 .78 78,305. 88 31. 38 171,244. 12
<br />TOTAL Culture & Recreation 249,550. 00 26,437 .78 78,305. 68 31. 38 171,244. 12
<br />TOTAL EXPENDITURES 249,550. 00 26,437 .78 78,305.88 31. 38 171,244.12
<br />REVENUES OVER/(UNDER) EXPENDITURES 0. 00 4,966 .69 ( 20,811. 66) 20,811. 66
<br />
|