Loading...
Country Club May 2012 Preliminary_as of 06-11-2012The Village of North Palm Beach Country Club Budget Summary Eight Months Ending May 31, 2012 Pre&rrunary Year- To-Date as of May 31, 2012 FY 2012 % of budget Prior Year Actual Actual Actual Actual Golf F & B Admiu Total Budget (Target 66.67 %) May 2011 9/302011 9/302010 9/302009 9/302008 REVENUES Driving Range $ 196,897 S 196,897 S 197,380 99.76% $ 159,722 $ 208,865 $ 174,929 $ 208,230 $ 213,103 Membership 623,526 623,526 664,970 93.77% 642,445 650,358 753,349 910,249 1,071,758 Cart Rental 641,826 641,826 1,019,820 62.94% 643,497 866,505 960,599 998,584 1,007,706 Walking Fees 30,634 30,634 41,560 73.71% 34,422 40,204 45,215 39,910 32,515 Greens Fees 712,055 712,055 836,500 85.12% 691,373 810,849 753,886 816,059 863,046 Lessons 73,917 73,917 100,000 73.92% 76,050 102,006 49,365 21,622 22,275 Tournament Proceeds 2,832 2,832 0 0.00% 2,008 1,675 3,470 508 21,790 Merchandise Sales 115,349 115,349 137,000 84.20% 94,890 133,349 133,324 133,386 138,512 Special Events /Camps - 0 4,000 0.00% 400 400 200 12,204 4,218 Food & Beverage -Lease Operation - 0 0 0.00% 0 0 28,241 192,735 175,753 Liquor Sales 146,849 146,849 256,622 57.22% 160,296 221,152 84,145 - - Food & Beverage Sales 303,542 303,542 591,088 51.35% 362,663 479,226 158,839 - - Sales of Surplus - 0 0 0.00% 0 0 124,000 0 0 Interest Earnings 3,663 3,663 8,855 41.37% 5,891 8,493 14,686 7,376 36,431 Other 47,982 (192) 4,040 51,830 42,900 120.82% 47,082 56,608 82,016 71,372 65,833 Total Revenues 2,445,017 450,199 7,704 2,902,920 3,900,695 74.42% 2,920,738 3,579,690 3,366,265 3,412,235 3,652,941 EXPENSES Personnel: Salary & Benefits 328,057 191,983 37,247 557,287 912,212 61.09% 602,669 892,066 715,637 558,813 521,249 Operating: Accounting & Auditing - - 5,911 5,911 7,000 84.44% 5,911 5,911 5,187 6,512 5,986 Charge Card Fees 39,193 5,586 0 44,778 62,798 71.31% 43,447 58,602 52,262 51,284 48,024 Contractual Services 789,600 15,693 4,139 809,432 1,223,415 66.16% 806,505 1,207,178 1,214,879 1,297,245 1,257,611 Entertainment - 3,878 0 3,878 12,500 31.02% 19,356 23,298 11,032 0 0 Rental- Equipment/Uniform, etc. 922 10,236 3,342 14,500 23,800 60.92% 16,696 22,112 19,120 113,737 113,503 Legal Fees 4,340 4,340 7,500 57.87% 1,820 3,395 11,652 2,488 3,623 Lessons 18,448 - 0 18,448 40,000 46.12% 20,972 27,386 14,580 5,684 8,927 Marketing & Advertising 11,226 698 0 11,924 50,040 23.83% 36,277 46,376 47,634 41,869 41,699 Materials & Supplies 31,867 10,926 1,865 44,659 78,119 57.17% 44,156 56,388 81,934 36,893 39,884 Merchandise 64,005 159,981 0 223,986 416,285 53.81% 276,902 373,348 184,527 112,418 105,496 Repairs & Maintenance 17,729 4,392 0 22,121 45,065 49.09% 18,421 27,625 52,748 17,388 19,692 Solid Waste Disposal 6,690 6,688 0 13,378 13,798 96.95% 12,542 12,542 12,040 9,866 0 Utilities 104,181 31,394 3,747 139,322 226,848 61.42% 136,795 209,567 207,725 238,622 204,514 Other Operating Costs 7,624 3,515 1,965 13,104 45,900 28.55% 34,213 42,666 40,590 31,106 52,505 Capital: Capital Outlay 15,000 - 0 15,000 15,500 96.77% 3,056 60,456 36,972 15,951 5,250 Debt & Other: Debt Service 197,450 197,450 394,901 50.00% 214,888 412,338 471,149 506,548 494,759 Golf Cart Lease 50,157 50,157 75,300 66.61% 50,157 75,235 160,626 71,157 71,157 Insurance -Prop & Gen Liab 26,576 26,576 39,864 66.67% 27,224 40,840 56,923 63,247 150,166 Contingency 0 0 209,850 0.00% 0 0 0 0 373,471 Total Expenses 1,682,148 444,970 89,132 2,216,250 3,900,695 56.82% 2,372,006 3,597,328 3,397,216 3,180,826 3,517,516 Revenues over (under) expenses S 762,869 S 5,229 S 686,670 S - S 548,732 S (17,638) S (30,952) S 231,409 S 135,425 S (81,428) Rounds 31,776 50,000 32,400 44,972 50,210 50,910 52,318