Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Country Club Preliminary Line Item Detail_Sep 2012
10/10/2012 16:05 VILLAGE OF NORTH PALM BEACH PG 1 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud FOR 2012 12 ORIGINAL REVISED ACTUAL YTD ACTUAL MTD REMAINING PCT ESTIM REV EST REV REVENUE REVENUE REVENUE COLL L2100 GRN FEE /CRT RNTLS /MBRSHIP L2100 05231 GOLF GREENS FEES 836,500 836,500 835,365.81 30,693.36 1,134.19 99.9%* L2100 05232 GOLF CART RENTAL 1,019,820 1,019,820 883,437.09 59,431.99 136,382.91 86.6%* L2100 05234 LOCKER RENTALS 1,500 1,500 1,935.00 .00 - 435.00 129.0 %* L2100 05235 GOLF HANDICAP SERVICE 900 900 1,525.00 25.00 - 625.00 169.4 %* L2100 06621 CLUB - RESIDENT 373,485 373,485 355,977.89 132.90 17,507.11 95.3%* L2100 06622 CLUB -NON RESIDENT 265,100 265,100 235,614.10 .00 29,485.90 88.9%* L2100 06623 SUMMER MEMBERSHIPS 21,285 21,285 33,165.00 .00 - 11,880.00 155.8 %* L2100 06683 SOCIAL - JUNIOR 5,100 5,100 2,676.22 .00 2,423.78 52.5%* L2100 07100 WALKING FEE 41,560 41,560 36,142.69 1,730.50 5,417.31 87.0%* L2100 08310 TOURNAMENT PROCEEDS 0 0 3,686.74 101.30 - 3,686.74 100.0 %* TOTAL GRN FEE /CRT RNTLS /MBRSHIP 2,565,250 2,565,250 2,389,525.54 92,115.05 175,724.46 93.1% TOTAL REVENUES 2,565,250 2,565,250 2,389,525.54 92,115.05 175,724.46 L2246 GOLF SHOP REVENUES L2246 02301 GOLF SHOP - SALES 137,000 137,000 161,613.04 14,145.87 - 24,613.04 118.0 %* L2246 02302 BAG ROOM 10,000 10,000 15,360.00 .00 - 5,360.00 153.6 %* L2246 02303 LESSONS 100,000 100,000 100,597.00 6,235.00 - 597.00 100.6 %* L2246 02304 GOLF BALL RETRIEVAL 3,500 3,500 3,600.00 .00 - 100.00 102.9 %* L2246 02307 GOLF GRIP SALES 0 0 747.45 8.01 - 747.45 100.0 %* L2246 02310 RENTAL -GOLF CLUBS 27,000 27,000 36,388.44 2,121.36 - 9,388.44 134.8 %* L2246 02341 SPECIAL EVENTS /CAMPS 4,000 4,000 .00 .00 4,000.00 .0%* TOTAL GOLF SHOP REVENUES 281,500 281,500 318,305.93 22,510.24 - 36,805.93 113.1% TOTAL REVENUES 281,500 281,500 318,305.93 22,510.24 - 36,805.93 L3100 INTEREST EARNINGS L3100 08204 INTEREST EARNED - TD B 8,855 8,855 6,317.83 .00 2,537.17 71.3%* TOTAL INTEREST EARNINGS 8,855 8,855 6,317.83 .00 2,537.17 71.3% TOTAL REVENUES 8,855 8,855 6,317.83 .00 2,537.17 L3200 DRIVING RANGE INCOME L3200 07500 DRIVING RANGE PROCEEDS 197,380 197,380 257,122.73 14,050.09 - 59,742.73 130.3 %* 10/10/2012 16:05 VILLAGE OF NORTH PALM BEACH PG 2 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud FOR 2012 12 TOTAL DRIVING RANGE INCOME TOTAL REVENUES L3253 RESTAURANT INCOME L3253 08110 FOOD & BEVERAGE SALES L3253 08111 BEVERAGE CART SALES L3253 08112 LIQUOR SALES - BVG CAR L3253 08113 NON - ALCOHOLIC BEVERAGE L3253 08120 LIQUOR SALES - F & B L3253 08130 FACILITY - RENTAL L3253 08135 BANQUETS L3253 08999 MISC. REVENUES TOTAL RESTAURANT INCOME TOTAL REVENUES L3700 OTHER MISC. REVENUES L3700 08920 DISCOUNTS EARNED L3700 08945 CARD FEE - RESIDENCY L3700 08980 COMMISSIONS - VENDING MA L3700 08995 DONATIONS -PAVER BRICKS L3700 08999 MISC. REVENUES TOTAL OTHER MISC. REVENUES TOTAL REVENUES GRAND TOTAL ORIGINAL REVISED ACTUAL YTD ACTUAL MTD ESTIM REV EST REV REVENUE REVENUE REMAINING PCT REVENUE COLL 197,380 197,380 257,122.73 14,050.09 - 59,742.73 130.3% 197,380 197,380 257,122.73 14,050.09 - 59,742.73 285,279 285,279 170,354.47 10,124.96 114,924.53 59.7%* 23,224 23,224 16,430.41 961.14 6,793.59 70.7%* 30,571 30,571 26,411.55 1,345.35 4,159.45 86.4%* 12,849 12,849 29,176.30 1,156.50 - 16,327.30 227.1 %* 226,051 226,051 175,890.68 11,401.28 50,160.32 77.8%* 0 0 150.00 150.00 - 150.00 100.0 %* 269,736 269,736 194,685.18 10,962.72 75,050.82 72.2%* 0 0 - 187.65 1.03 187.65 100.0% 847,710 847,710 612,910.94 36,102.98 234,799.06 72.3% 847,710 847,710 612,910.94 36,102.98 234,799.06 0 0 360.00 30.00 - 360.00 100.0 %* 0 0 2,565.00 .00 - 2,565.00 100.0 %* 0 0 447.75 .00 - 447.75 100.0 %* 0 0 188.66 .00 - 188.66 100.0 %* 0 0 1,027.35 .68 - 1,027.35 100.0%* 0 0 4,588.76 30.68 - 4,588.76 100.0% 0 0 4,588.76 30.68 - 4,588.76 3,900,695 3,900,695 3,588,771.73 164,809.04 311,923.27 92.0% ** END OF REPORT - Generated by samia janjua ** 10/10/2012 16:06 VILLAGE OF NORTH PALM BEACH PG 1 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud FOR 2012 12 ORIGINAL APPROP REVISED BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES AVAILABLE BUDGET PCT USED L8045 GOLF COURSE MAINT. EXP. 57,422 57,422 57,648.05 4,480.00 .00 - 226.05 100.4 %* L8045 33491 CONTRACTUAL SERVICES 1,153,888 1,153,888 1,155,935.96 98,205.33 .00 - 2,047.96 100.2 %* L8045 34310 ELECTRICITY 53,780 53,780 49,681.14 3,368.12 .00 4,098.86 92.4% L8045 34320 WATER & SEWER 21,598 21,598 22,544.07 45.67 .00 - 946.07 104.4%* L8045 34340 SOLID WASTE DISPOSAL 3,449 3,449 3,345.60 .00 .00 103.40 97.0% L8045 35222 TREES & SOD 8,000 8,000 390.00 390.00 .00 7,610.00 4.9% TOTAL GOLF COURSE MAINT. EXP. 1,240,715 1,240,715 1,231,896.77 102,009.12 .00 8,818.23 99.3% 90.3% L8046 TOTAL EXPENSES 1,240,715 1,240,715 1,231,896.77 102,009.12 .00 8,818.23 - 325.24 L8046 GOLF SHOP EXPENSES L8046 11110 EXECUTIVE SALARIES 51,471 51,471 53,643.88 4,231.68 .00 - 2,172.88 104.2 %* L8046 11210 REGULAR PAY 57,422 57,422 57,648.05 4,480.00 .00 - 226.05 100.4 %* L8046 11300 PART -TIME PAY 248,023 248,023 240,931.71 17,656.33 .00 7,091.29 97.1% L8046 11400 OVERTIME PAY 5,200 5,200 919.39 269.56 .00 4,280.61 17.7% L8046 11501 AUTO ALLOWANCE 4,800 4,800 4,800.12 369.24 .00 -.12 100.0 %* L8046 11504 TELEPHONE ALLOWANCE 720 720 719.94 55.38 .00 .06 100.0% L8046 11506 COMMISSIONS - LESSONS 40,000 40,000 57,014.84 4,200.99 .00 - 17,014.84 142.5 %* L8046 11530 HOLIDAY GIFTS 725 725 654.75 .00 .00 70.25 90.3% L8046 12110 F I C A 31,184 31,184 31,509.24 2,367.19 .00 - 325.24 101.0 %* L8046 12215 ICMA - DIRECTOR 8,549 8,549 5,250.95 634.76 .00 3,298.05 61.4% L8046 12216 ICMA GENERAL EMPLOYEES 5,410 5,410 2,774.50 364.70 .00 2,635.50 51.3% L8046 12217 ICMA MUNICIPAL EMPLOYE 3,984 3,984 3,375.76 307.29 .00 608.24 84.7% L8046 12225 ICMA -457 MATCH 2,160 2,160 720.00 55.40 .00 1,440.00 33.3% L8046 12310 HEALTH INSURANCE 28,340 28,340 28,459.92 2,481.00 .00 - 119.92 100.4%* L8046 12320 LIFE INSURANCE 324 324 324.00 27.00 .00 .00 100.0% L8046 12330 L.T.D. INSURANCE 643 643 659.90 56.37 .00 -16.90 102.6 %* L8046 12410 WORKERS' COMPENSATION 4,299 4,299 3,898.18 298.55 .00 400.82 90.7% L8046 12415 UNEMPLOYMENT COMPENSAT 18,158 18,158 .00 .00 .00 18,158.00 .0% L8046 33130 PHYSICAL EXAMS 500 500 .00 .00 .00 500.00 .0% L8046 33190 PROFESSIONAL SERVICES 500 500 .00 .00 .00 500.00 .0% L8046 33230 CHARGE CARD FEE 51,000 51,000 52,204.19 5,848.37 .00 - 1,204.19 102.4 %* L8046 33491 CONTRACTUAL SERVICES 13,000 13,000 10,626.95 628.56 .00 2,373.05 81.7% L8046 34010 TRAVEL & LODGING 300 300 539.94 .00 .00 - 239.94 180.0 %* L8046 34110 TELEPHONE 5,027 5,027 4,645.37 312.77 .00 381.63 92.4% L8046 34310 ELECTRICITY 31,216 31,216 25,762.12 2,541.99 .00 5,453.88 82.5% L8046 34320 WATER & SEWER 506 506 1,273.94 161.09 .00 - 767.94 251.8 %* L8046 34620 R & M BLDG & GROUNDS 2,500 2,500 844.57 16.64 .00 1,655.43 33.8% 10/10/2012 16:06 VILLAGE OF NORTH PALM BEACH PG 2 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud FOR 2012 12 L8053 FOOD & BEVERAGE EXPENSES L8053 11110 EXECUTIVE SALARIES ORIGINAL REVISED 58,381.61 3,856.62 .00 AVAILABLE PCT L8046 GOLF SHOP EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8046 34650 R & M MACH. & EQUIP. 1,500 1,500 3,100.52 206.69 .00 - 1,600.52 206.7 %* L8046 34710 PRINTING & BINDING 4,000 4,000 1,695.80 1,471.50 .00 2,304.20 42.4% L8046 34812 CLUB RELATIONS 1,500 1,500 .00 .00 .00 1,500.00 .0% L8046 34910 ADVERTISING 36,000 36,000 17,917.30 1,382.40 .00 18,082.70 49.8% L8046 34960 TROPHIES, AWARDS & PRI 1,000 1,000 1,007.20 .00 .00 -7.20 100.7 %* L8046 35110 OFFICE SUPPLIES 3,000 3,000 2,545.28 .00 .00 454.72 84.8% L8046 35111 COMPUTER SUPPLIES 3,000 3,000 3,144.81 .00 .00 - 144.81 104.8 %* L8046 35120 GOLF SUPPLIES 22,000 22,000 26,113.85 1,231.23 .00 - 4,113.85 118.7 %* L8046 35213 SHOP TOOLS & SUPPLIES 2,000 2,000 807.05 17.91 .00 1,192.95 40.4% L8046 35214 BUILDING MAINT. SUPPLI 2,000 2,000 354.20 168.95 .00 1,645.80 17.7% L8046 35215 FURNITURE /FIXTURE SUPP 500 500 791.30 659.60 .00 - 291.30 158.3 %* L8046 35217 MACH. & EQUIP. SUPPLIE 8,000 8,000 4,958.36 .00 .00 3,041.64 62.0% L8046 35270 CUSTODIAL SUPPLIES 500 500 316.24 .00 .00 183.76 63.2% L8046 35294 UNIFORMS & SHOES 4,400 4,400 2,807.41 .00 .00 1,592.59 63.8% L8046 35410 BOOKS, PUBLS., & SUBSC 100 100 .00 .00 .00 100.00 .0% L8046 35420 MEMBERSHIP & DUES 2,500 2,500 1,853.00 .00 .00 647.00 74.1% L8046 35430 CONFERENCE & SEMINARS 1,000 1,000 50.00 .00 .00 950.00 5.0% L8046 35530 GOLF MERCHANDISE 108,000 108,000 95,503.08 8,773.97 .00 12,496.92 88.4% L8046 35532 GOLF LESSONS EXPENSE 40,000 40,000 23,622.00 788.00 .00 16,378.00 59.1% L8046 35533 SPECIAL EVENTS /CAMPS 500 500 .00 .00 .00 500.00 .0% L8046 35534 GOLF CLUB RENTAL EXPEN 3,000 3,000 922.20 .00 .00 2,077.80 30.7% L8046 35550 GOLF HANDICAP EXPENSES 3,000 3,000 3,125.00 .00 .00 - 125.00 104.2 %* L8046 66490 MACHINERY & EQUIPMENT 15,500 15,500 15,000.00 .00 .00 500.00 96.8% TOTAL GOLF SHOP EXPENSES 878,961 878,961 794,836.81 62,065.11 .00 84,124.19 90.4% TOTAL EXPENSES 878,961 878,961 794,836.81 62,065.11 .00 84,124.19 L8053 FOOD & BEVERAGE EXPENSES L8053 11110 EXECUTIVE SALARIES 54,804 54,804 58,381.61 3,856.62 .00 - 3,577.61 106.5 %* L8053 11210 REGULAR PAY 0 0 19,999.20 3,076.80 .00 - 19,999.20 100.0 %* L8053 11300 PART -TIME PAY 212,307 212,307 152,263.86 10,639.55 .00 60,043.14 71.7% L8053 11400 OVERTIME PAY 0 0 88.52 .00 .00 -88.52 100.0 %* L8053 11501 AUTO ALLOWANCE 4,800 4,800 553.86 .00 .00 4,246.14 11.5% L8053 11504 TELEPHONE ALLOWANCE 720 720 83.07 .00 .00 636.93 11.5% L8053 11530 HOLIDAY GIFTS 725 725 485.00 .00 .00 240.00 66.9% L8053 12110 F I C A 20,857 20,857 22,403.72 1,580.56 .00 - 1,546.72 107.4%* L8053 12215 ICMA - DIRECTOR 9,049 9,049 4,791.00 578.50 .00 4,258.00 52.9% L8053 12216 ICMA GENERAL EMPLOYEES 0 0 2,999.88 461.52 .00 - 2,999.88 100.0 %* L8053 12225 ICMA -457 MATCH 720 720 245.60 25.00 .00 474.40 34.1% L8053 12310 HEALTH INSURANCE 16,219 16,219 17,318.96 1,930.20 .00 - 1,099.96 106.8 %* L8053 12320 LIFE INSURANCE 108 108 162.00 18.00 .00 -54.00 150.0 %* 10/10/2012 16:06 VILLAGE OF NORTH PALM BEACH PG 3 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud FOR 2012 12 ORIGINAL REVISED AVAILABLE PCT L8053 FOOD & BEVERAGE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8053 12330 L.T.D. INSURANCE 324 324 415.43 44.32 .00 -91.43 128.2 %* L8053 12410 WORKERS' COMPENSATION 3,708 3,708 3,065.87 239.00 .00 642.13 82.7% L8053 12415 UNEMPLOYMENT COMPENSAT 14,607 14,607 8,137.59 .00 .00 6,469.41 55.7% L8053 33190 PROFESSIONAL SERVICES 600 600 1,199.00 .00 .00 - 599.00 199.8 %* L8053 33230 CHARGE CARD FEE 11,798 11,798 7,856.96 357.43 .00 3,941.04 66.6% L8053 33410 UNIFORM RENTAL 1,500 1,500 .00 .00 .00 1,500.00 .0% L8053 33411 LINEN RENTAL 11,000 11,000 9,132.76 672.79 .00 1,867.24 83.0% L8053 33430 CONTRACT LABOR 1,500 1,500 622.50 .00 .00 877.50 41.5% L8053 33434 ENTERTAINMENT & ETC. 12,500 12,500 7,237.66 227.46 .00 5,262.34 57.9% L8053 33491 CONTRACTUAL SERVICES 25,888 25,888 22,795.50 1,880.67 .00 3,092.50 88.1% L8053 34110 TELEPHONE 360 360 25.00 .00 .00 335.00 6.9% L8053 34310 ELECTRICITY 38,401 38,401 27,351.50 2,572.82 .00 11,049.50 71.2% L8053 34320 WATER & SEWER 7,931 7,931 11,510.80 1,810.28 .00 - 3,579.80 145.1 %* L8053 34330 GAS 15,000 15,000 9,509.31 34.50 .00 5,490.69 63.4% L8053 34340 SOLID WASTE DISPOSAL 6,899 6,899 6,688.00 .00 .00 211.00 96.9% L8053 34420 RENTAL - EQUIPMENT 4,800 4,800 5,080.36 375.00 .00 - 280.36 105.8 %* L8053 34620 R & M BLDG & GROUNDS 3,401 3,401 1,889.85 385.16 .00 1,511.15 55.6% L8053 34630 R & M FURN. & OFF. EQ 1,000 1,000 124.21 4.29 .00 875.79 12.4% L8053 34650 R & M MACH. & EQUIP. 7,500 7,500 3,265.74 .00 .00 4,234.26 43.5% L8053 34655 R & M BURGLAR /FIRE AL 1,000 1,000 889.40 .00 .00 110.60 88.9% L8053 34811 EMPLOYEE RELATIONS 0 0 113.43 113.43 .00 - 113.43 100.0 %* L8053 34910 ADVERTISING 8,040 8,040 1,014.84 .00 .00 7,025.16 12.6% L8053 34940 LICENSES & FEES 5,200 5,200 3,044.75 .00 .00 2,155.25 58.6% L8053 34970 BAD DEBT EXPENSES 200 200 .00 .00 .00 200.00 .0% L8053 35110 OFFICE SUPPLIES 500 500 499.30 104.98 .00 .70 99.9% L8053 35111 COMPUTER SUPPLIES 1,000 1,000 917.20 .00 .00 82.80 91.7% L8053 35130 PAPER GOODS & SUPPLIES 9,000 9,000 4,977.49 422.32 .00 4,022.51 55.3% L8053 35131 KITCHEN SUPPLIES 4,500 4,500 1,268.98 .00 .00 3,231.02 28.2% L8053 35135 CHINA, GLASS, SILVERWA 1,500 1,500 658.30 .00 .00 841.70 43.9% L8053 35214 BUILDING MAINT. SUPPLI 1,000 1,000 164.97 61.61 .00 835.03 16.5% L8053 35217 MACH. & EQUIP. SUPPLIE 2,000 2,000 496.70 .00 .00 1,503.30 24.8% L8053 35243 FURNITURE, FIXTURES & 3,500 3,500 289.97 .00 .00 3,210.03 8.3% L8053 35250 AMBIENCE 750 750 423.06 .00 .00 326.94 56.4% L8053 35270 CUSTODIAL SUPPLIES 6,000 6,000 5,040.46 391.02 .00 959.54 84.0% L8053 35280 GAS, OIL & LUBRICANTS 100 100 74.31 4.00 .00 25.69 74.3% L8053 35290 MISC. OPERATING EXPENS 3,500 3,500 396.76 .00 .00 3,103.24 11.3% L8053 35294 UNIFORMS & SHOES 0 0 128.54 .00 .00 - 128.54 100.0 %* L8053 35298 FLOWER EXPENSE 1,500 1,500 298.96 .00 .00 1,201.04 19.9% L8053 35510 MERCHANDISE - F&B 231,298 231,298 163,062.16 10,052.43 .00 68,235.84 70.5% L8053 35520 MERCHANDISE - LIQUOR 76,987 76,987 59,071.84 3,660.81 .00 17,915.16 76.7% TOTAL FOOD & BEVERAGE EXPENSES 846,601 846,601 648,515.74 45,581.07 .00 198,085.26 76.6% TOTAL EXPENSES 846,601 846,601 648,515.74 45,581.07 .00 198,085.26 L8056 ADMINISTRATIVE EXPENSES L8056 11210 REGULAR PAY 33,893 33,893 36,407.69 2,706.44 .00 - 2,514.69 107.4 %* 10/10/2012 16:06 VILLAGE OF NORTH PALM BEACH PG 4 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud FOR 2012 12 L8059 CLUBHOUSE GROUNDS EXPENSE L8059 33440 EXTERMINATING ORIGINAL REVISED 3,029.44 262.36 .00 AVAILABLE PCT L8056 ADMINISTRATIVE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8056 11400 OVERTIME PAY 1,000 1,000 .00 .00 .00 1,000.00 .0% L8056 11530 HOLIDAY GIFTS 50 50 48.50 .00 .00 1.50 97.0% L8056 12110 F I C A 2,670 2,670 2,635.11 180.18 .00 34.89 98.7% L8056 12210 PENSION -GEN'L EMPLOYEE 0 0 451.60 .00 .00 - 451.60 100.0 %* L8056 12216 ICMA GENERAL EMPLOYEES 5,234 5,234 3,018.15 405.96 .00 2,215.85 57.7% L8056 12225 ICMA -457 MATCH 720 720 24.36 .00 .00 695.64 3.4% L8056 12310 HEALTH INSURANCE 10,774 10,774 11,888.06 1,417.80 .00 - 1,114.06 110.3 %* L8056 12320 LIFE INSURANCE 108 108 111.96 9.00 .00 -3.96 103.7 %* L8056 12330 L.T.D. INSURANCE 200 200 212.53 17.30 .00 -12.53 106.3 %* L8056 12410 WORKERS' COMPENSATION 53 53 51.07 4.06 .00 1.93 96.4% L8056 12415 UNEMPLOYMENT COMPENSAT 7,150 7,150 1,375.00 .00 .00 5,775.00 19.2% L8056 33160 DONATIONS EXP -PAVER BR 0 0 92.00 .00 .00 -92.00 100.0 %* L8056 33210 ACCOUNTING & AUDITING 7,000 7,000 5,911.00 .00 .00 1,089.00 84.4% L8056 33491 CONTRACTUAL SERVICES 4,139 4,139 4,139.00 .00 .00 .00 100.0% L8056 34110 TELEPHONE 5,735 5,735 5,381.84 381.06 .00 353.16 93.8% L8056 34210 POSTAGE 4,000 4,000 2,514.96 323.22 .00 1,485.04 62.9% L8056 34422 RENTAL - COPIER 3,500 3,500 4,403.00 83.01 .00 - 903.00 125.8 %* L8056 34710 PRINTING & BINDING 2,500 2,500 492.60 .00 .00 2,007.40 19.7% L8056 34910 ADVERTISING 6,000 6,000 .00 .00 .00 6,000.00 .0% L8056 34970 BAD DEBT EXPENSES 0 0 8,387.47 8,387.47 .00 - 8,387.47 100.0 %* L8056 35110 OFFICE SUPPLIES 2,500 2,500 1,782.52 235.09 .00 717.48 71.3% L8056 35111 COMPUTER SUPPLIES 1,500 1,500 1,251.77 143.32 .00 248.23 83.5% L8056 35294 UNIFORMS & SHOES 0 0 97.50 97.50 .00 -97.50 100.0 %* TOTAL ADMINISTRATIVE EXPENSES 98,726 98,726 90,677.69 14,391.41 .00 8,048.31 91.8% TOTAL EXPENSES 98,726 98,726 90,677.69 14,391.41 .00 8,048.31 L8059 CLUBHOUSE GROUNDS EXPENSE L8059 33440 EXTERMINATING 2,700 2,700 3,029.44 262.36 .00 - 329.44 112.2 %* L8059 33491 CONTRACTUAL SERVICES 25,000 25,000 17,807.78 755.00 .00 7,192.22 71.2% L8059 34110 TELEPHONE 1,865 1,865 1,868.44 107.95 .00 -3.44 100.2 %* L8059 34310 ELECTRICITY 25,601 25,601 18,234.33 1,715.21 .00 7,366.67 71.2% L8059 34320 WATER & SEWER 19,828 19,828 24,731.06 886.65 .00 - 4,903.06 124.7 %* L8059 34330 GAS 0 0 5,177.88 .00 .00 - 5,177.88 100.0 %* L8059 34340 SOLID WASTE DISPOSAL 3,450 3,450 3,344.00 .00 .00 106.00 96.9% L8059 34620 R & M BLDG & GROUNDS 15,600 15,600 17,614.93 6,995.09 .00 - 2,014.93 112.9 %* L8059 34650 R & M MACH. & EQUIP. 500 500 4,697.86 4,066.72 .00 - 4,197.86 939.6 %* L8059 34655 R & M BURGLAR /FIRE AL 3,000 3,000 1,304.80 .00 .00 1,695.20 43.5% L8059 34656 R & M FIRE EQUIPMENT 1,000 1,000 559.10 .00 .00 440.90 55.9% L8059 34657 R & M PLUMB.,HEAT. & 5,364 5,364 3,397.54 1,336.63 .00 1,966.46 63.3% L8059 34660 R & M P.A. & COMM. SY 0 0 524.36 .00 .00 - 524.36 100.0 %* 10/10/2012 16:06 VILLAGE OF NORTH PALM BEACH PG 5 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud FOR L8059 2012 12 CLUBHOUSE GROUNDS EXPENSE ORIGINAL APPROP REVISED BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES AVAILABLE BUDGET PCT USED L8059 35213 SHOP TOOLS & SUPPLIES 200 200 30.96 .00 .00 169.04 15.5% L8059 35214 BUILDING MAINT. SUPPLI 3,469 3,469 294.76 .00 .00 3,174.24 8.5% L8059 35216 IRRIGATION SUPPLIES 200 200 9.95 .00 .00 190.05 5.0% L8059 35270 CUSTODIAL SUPPLIES 500 500 .00 .00 .00 500.00 .0% TOTAL CLUBHOUSE GROUNDS EXPENSE 108,277 108,277 102,627.19 16,125.61 .00 5,649.81 94.8% .00 .00 TOTAL EXPENSES 108,277 108,277 102,627.19 16,125.61 .00 5,649.81 RESERVES EXPENSES L8062 INSURANCE EXPENSES L8062 34530 INSURANCE- COMP.GEN'L L 39,864 39,864 39,864.00 3,322.00 .00 .00 100.0% TOTAL INSURANCE EXPENSES 39,864 39,864 39,864.00 3,322.00 .00 .00 100.0% TOTAL EXPENSES 39,864 39,864 39,864.00 3,322.00 .00 .00 L8070 RESERVES EXPENSES L8070 33112 SPECIAL LEGAL SERVICES 7,500 7,500 12,197.50 4,532.50 .00 - 4,697.50 162.6 %* L8070 49910 COUNTRY CLUB CONTINGEN 209,850 209,850 2,000.00 .00 .00 207,850.00 1.0% TOTAL RESERVES EXPENSES 217,350 217,350 14,197.50 4,532.50 .00 203,152.50 6.5% TOTAL EXPENSES 217,350 217,350 14,197.50 4,532.50 .00 203,152.50 L8565 DEBT SERVICE EXPENSES L8565 49157 GOLF CART LEASE 75,300 75,300 75,235.20 6,269.60 .00 64.80 99.9% L8565 49170 DEBT PMT -BOA 4.893M 394,901 394,901 394,900.40 197,450.20 .00 .60 100.0% TOTAL DEBT SERVICE EXPENSES 470,201 470,201 470,135.60 203,719.80 .00 65.40 100.0% TOTAL EXPENSES 470,201 470,201 470,135.60 203,719.80 .00 65.40 GRAND TOTAL 3,900,695 3,900,695 3,392,751.30 451,746.62 .00 507,943.70 87.0% ** END OF REPORT - Generated by samia janjua **