Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
05-2014 CC LINE ITEM DETAIL_PRELIMINARY AS OF 06-10-14
06/10/2014 17:24 VILLAGE OF NORTH PALM BEACH PG 1 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud MAY 31, 2014 * *PRELIMINARY ** FOR 2014 08 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 822,590 822,590 767,972.73 44,002.54 54,617.27 93.4%* L2100 05232 GOLF CART RENTAL 913,440 913,440 660,643.68 85,622.42 252,796.32 72.3%* L2100 05234 LOCKER RENTALS 1,965 1,965 3,668.00 26.50 - 1,703.00 186.7 %* L2100 05235 GOLF HANDICAP SERVICE 1,803 1,803 2,600.00 175.00 - 797.00 144.2 %* L2100 06621 CLUB - RESIDENT 337,995 337,995 348,401.12 .00 - 10,406.12 103.1 %* L2100 06622 CLUB -NON RESIDENT 199,800 199,800 171,072.92 .00 28,727.08 85.6%* L2100 06623 SUMMER MEMBERSHIPS 31,790 31,790 24,755.00 11,385.00 7,035.00 77.9%* L2100 06625 BUSINESS MEMBERSHIPS 3,750 3,750 .00 .00 3,750.00 .0%* L2100 06683 SOCIAL - JUNIOR 6,000 6,000 2,726.24 600.00 3,273.76 45.4%* L2100 07100 WALKING FEE 37,702 37,702 35,218.91 4,069.41 2,483.09 93.4%* L2100 08310 TOURNAMENT PROCEEDS 2,620 2,620 1,863.66 279.41 756.34 71.1%* L2100 08995 DONATIONS 0 0 56.00 .00 -56.00 100.0 %* TOTAL GRN FEE /CRT RNTLS /MBRSHIP 2,359,455 2,359,455 2,018,978.26 146,160.28 340,476.74 85.6% TOTAL REVENUES 2,359,455 2,359,455 2,018,978.26 146,160.28 340,476.74 L2246 GOLF SHOP REVENUES L2246 02301 GOLF SHOP - SALES 160,500 160,500 137,484.10 18,288.56 23,015.90 85.7%* L2246 02302 BAG ROOM 14,000 14,000 9,000.00 .00 5,000.00 64.3%* L2246 02303 LESSONS 120,000 120,000 111,432.00 7,394.00 8,568.00 92.9%* L2246 02304 GOLF BALL RETRIEVAL 4,800 4,800 2,235.00 2,235.00 2,565.00 46.6%* L2246 02307 GOLF GRIP SALES 600 600 768.51 107.01 - 168.51 128.1 %* L2246 02310 RENTAL -GOLF CLUBS 38,000 38,000 36,179.68 2,869.68 1,820.32 95.2%* TOTAL GOLF SHOP REVENUES 337,900 337,900 297,099.29 30,894.25 40,800.71 87.9% TOTAL REVENUES 337,900 337,900 297,099.29 30,894.25 40,800.71 L3100 INTEREST EARNINGS L3100 08204 INTEREST EARNED - TD B 7,600 7,600 4,204.97 .00 3,395.03 55.3%* TOTAL INTEREST EARNINGS 7,600 7,600 4,204.97 .00 3,395.03 55.3% TOTAL REVENUES 7,600 7,600 4,204.97 .00 3,395.03 L3200 DRIVING RANGE INCOME L3200 07200 LEASE - GOLF 12,500 12,500 13,500.00 .00 - 1,000.00 108.0 %* 06/10/2014 17:24 VILLAGE OF NORTH PALM BEACH PG 2 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud MAY 31, 2014 * *PRELIMINARY ** FOR 2014 08 ORIGINAL ESTIM REV REVISED EST REV ACTUAL YTD REVENUE ACTUAL MTD REVENUE REMAINING REVENUE PCT COLL L3200 07500 DRIVING RANGE PROCEEDS 268,500 268,500 206,397.61 20,379.50 62,102.39 76.9%* TOTAL DRIVING RANGE INCOME 281,000 281,000 219,897.61 20,379.50 61,102.39 78.3% TOTAL REVENUES 281,000 281,000 219,897.61 20,379.50 61,102.39 L3253 RESTAURANT INCOME L3253 08110 FOOD & BEVERAGE SALES 230,000 230,000 135,491.14 13,009.65 94,508.86 58.9%* L3253 08111 BEVERAGE CART SALES 15,000 15,000 11,918.60 1,591.87 3,081.40 79.5%* L3253 08112 LIQUOR SALES - BVG CAR 25,000 25,000 11,605.96 1,522.64 13,394.04 46.4%* L3253 08113 NON - ALCOHOLIC BEVERAGE 31,250 31,250 17,271.59 1,940.57 13,978.41 55.3%* L3253 08120 LIQUOR SALES - F & B 210,000 210,000 142,550.10 19,533.70 67,449.90 67.9%* L3253 08130 FACILITY - RENTAL 27,750 27,750 7,730.38 1,500.00 20,019.62 27.9%* L3253 08135 BANQUETS 260,000 260,000 152,228.30 25,108.99 107,771.70 58.5%* L3253 08999 MISC. REVENUES 0 0 - 235.33 6.92 235.33 100.0% TOTAL RESTAURANT INCOME 799,000 799,000 478,560.74 64,214.34 320,439.26 59.9% TOTAL REVENUES 799,000 799,000 478,560.74 64,214.34 320,439.26 L3700 OTHER MISC. REVENUES L3700 08920 DISCOUNTS EARNED 0 0 240.00 30.00 - 240.00 100.0 %* L3700 08945 CARD FEE - RESIDENCY 0 0 1,485.00 30.00 - 1,485.00 100.0 %* L3700 08950 INSURANCE REFUNDS 0 0 1,235.70 393.57 - 1,235.70 100.0 %* L3700 08980 COMMISSIONS - VENDING MA 0 0 192.98 .00 - 192.98 100.0 %* L3700 08995 DONATIONS -PAVER BRICKS 0 0 1,149.93 283.02 - 1,149.93 100.0 %* L3700 08999 MISC. REVENUES 0 0 1,085.38 87.75 - 1,085.38 100.0 %* TOTAL OTHER MISC. REVENUES 0 0 5,388.99 824.34 - 5,388.99 100.0% TOTAL REVENUES 0 0 5,388.99 824.34 - 5,388.99 L4600 APPROP. FUND BALANCE L4600 09100 APPROP. RETAINED EARNI 0 19,135 .00 .00 19,135.00 .0%* TOTAL APPROP. FUND BALANCE 0 19,135 .00 .00 19,135.00 .0% TOTAL REVENUES 0 19,135 .00 .00 19,135.00 GRAND TOTAL 3,784,955 3,804,090 3,024,129.86 262,472.71 779,960.14 79.5% ** END OF REPORT - Generated by samia janjua ** 06/10/2014 17:25 VILLAGE OF NORTH PALM BEACH PG 1 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud MAY 31, 2014 * *PRELIMINARY ** FOR 2014 08 ORIGINAL APPROP REVISED BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES AVAILABLE BUDGET PCT USED L8045 GOLF COURSE MAINT. EXP. 66,322 66,322 44,050.32 5,235.28 .00 22,271.68 66.4% L8045 33491 CONTRACTUAL SERVICES 1,067,719 1,067,719 711,632.72 88,976.59 356,086.28 .00 100.0 %* L8045 34310 ELECTRICITY 43,352 43,352 24,273.55 4,681.86 .00 19,078.45 56.0% L8045 34320 WATER & SEWER 23,386 23,386 19,796.74 2,001.52 .00 3,589.26 84.7%* L8045 34340 SOLID WASTE DISPOSAL 6,783 6,783 .00 .00 .00 6,783.00 .0% L8045 34620 R & M BLDG & GROUNDS 0 8,800 13,500.00 .00 8,800.00 - 13,500.00 253.4 %* L8045 34640 R & M IRRIGATION SYS. 0 0 9,804.51 .00 .00 - 9,804.51 100.0 %* L8045 34683 R & M GOLF COURSE 0 0 22,475.00 18,475.00 21,700.00 - 44,175.00 100.0 %* L8045 35222 TREES & SOD 8,000 8,000 2,280.00 .00 .00 5,720.00 28.5% TOTAL GOLF COURSE MAINT. EXP. 1,149,240 1,158,040 803,762.52 114,134.97 386,586.28 - 32,308.80 102.8% 59.5% L8046 TOTAL EXPENSES 1,149,240 1,158,040 803,762.52 114,134.97 386,586.28 - 32,308.80 1,689.30 L8046 GOLF SHOP EXPENSES L8046 11110 EXECUTIVE SALARIES 61,571 61,571 66,841.85 5,722.76 .00 - 5,270.85 108.6 %* L8046 11210 REGULAR PAY 66,322 66,322 44,050.32 5,235.28 .00 22,271.68 66.4% L8046 11300 PART -TIME PAY 279,686 279,686 191,423.87 24,070.25 .00 88,262.13 68.4%* L8046 11400 OVERTIME PAY 1,000 1,000 5.57 .00 .00 994.43 .6% L8046 11501 AUTO ALLOWANCE 4,800 4,800 3,138.54 369.24 .00 1,661.46 65.4% L8046 11504 TELEPHONE ALLOWANCE 720 720 470.73 55.38 .00 249.27 65.4% L8046 11506 COMMISSIONS - LESSONS 68,000 68,000 68,618.10 5,026.00 .00 - 618.10 100.9 %* L8046 12110 F I C A 36,889 36,889 26,350.11 3,074.82 .00 10,538.89 71.4%* L8046 12215 ICMA - DIRECTOR 10,064 10,064 6,192.38 740.98 .00 3,871.62 61.5% L8046 12216 ICMA GENERAL EMPLOYEES 5,317 5,317 3,610.38 493.35 .00 1,706.62 67.9%* L8046 12217 ICMA MUNICIPAL EMPLOYE 4,647 4,647 2,765.11 409.37 .00 1,881.89 59.5% L8046 12225 ICMA -457 MATCH 2,160 2,160 470.70 55.40 .00 1,689.30 21.8% L8046 12310 HEALTH INSURANCE 32,422 32,422 27,340.20 1,822.68 .00 5,081.80 84.3%* L8046 12320 LIFE INSURANCE 261 261 174.00 21.75 .00 87.00 66.7% L8046 12330 L.T.D. INSURANCE 576 576 371.70 47.39 .00 204.30 64.5% L8046 12410 WORKERS' COMPENSATION 5,620 5,620 3,871.43 478.24 .00 1,748.57 68.9%* L8046 33160 DONATIONS EXPENSES 0 0 56.00 .00 .00 -56.00 100.0 %* L8046 33230 CHARGE CARD FEE 53,716 53,716 40,569.55 .00 .00 13,146.45 75.5%* L8046 33491 CONTRACTUAL SERVICES 1,500 1,500 9,763.50 1,211.00 5,907.50 - 14,171.00 1044.7 %* L8046 34010 TRAVEL & LODGING 2,700 2,700 784.37 .00 .00 1,915.63 29.1% L8046 34110 TELEPHONE 4,008 4,008 2,245.57 186.51 .00 1,762.43 56.0% L8046 34210 POSTAGE 0 0 139.38 .00 .00 - 139.38 100.0 %* L8046 34310 ELECTRICITY 27,419 27,419 17,210.11 2,040.78 .00 10,208.89 62.8% L8046 34320 WATER & SEWER 1,181 1,181 708.92 45.48 .00 472.08 60.0% 06/10/2014 17:25 VILLAGE OF NORTH PALM BEACH PG 2 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud MAY 31, 2014 * *PRELIMINARY ** FOR 2014 08 L8053 FOOD & BEVERAGE EXPENSES L8053 11110 EXECUTIVE SALARIES ORIGINAL REVISED 37,514.06 4,437.60 .00 AVAILABLE PCT L8046 GOLF SHOP EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8046 34620 R & M BLDG & GROUNDS 1,500 1,500 149.85 .00 600.00 750.15 50.0% L8046 34650 R & M MACH. & EQUIP. 2,250 2,250 4,635.66 282.34 .00 - 2,385.66 206.0 %* L8046 34710 PRINTING & BINDING 2,000 2,000 5.00 .00 .00 1,995.00 .3% L8046 34812 CLUB RELATIONS 500 500 1,062.99 39.99 .00 - 562.99 212.6 %* L8046 34910 ADVERTISING 37,000 40,200 19,370.21 1,052.89 .00 20,829.79 48.2% L8046 34960 TROPHIES, AWARDS & PRI 1,250 1,250 781.46 .00 .00 468.54 62.5% L8046 35110 OFFICE SUPPLIES 2,500 2,500 998.94 485.18 .00 1,501.06 40.0% L8046 35111 COMPUTER SUPPLIES 2,500 2,500 139.99 139.99 .00 2,360.01 5.6% L8046 35120 GOLF SUPPLIES 22,000 22,000 22,870.39 1,037.44 .00 - 870.39 104.0 %* L8046 35213 SHOP TOOLS & SUPPLIES 1,000 1,000 639.34 19.99 .00 360.66 63.9% L8046 35214 BUILDING MAINT. SUPPLI 500 500 .00 .00 800.00 - 300.00 160.0 %* L8046 35215 FURNITURE /FIXTURE SUPP 1,500 1,500 364.38 .00 .00 1,135.62 24.3% L8046 35217 MACH. & EQUIP. SUPPLIE 3,750 6,885 3,439.48 .00 200.00 3,245.52 52.9% L8046 35270 CUSTODIAL SUPPLIES 250 250 62.95 .00 .00 187.05 25.2% L8046 35294 UNIFORMS & SHOES 4,000 4,000 2,549.23 357.84 524.93 925.84 76.9%* L8046 35410 BOOKS, PUBLS., & SUBSC 100 100 .00 .00 .00 100.00 .0% L8046 35420 MEMBERSHIP & DUES 2,800 2,800 1,666.00 971.00 .00 1,134.00 59.5% L8046 35430 CONFERENCE & SEMINARS 1,700 1,700 890.00 .00 .00 810.00 52.4% L8046 35530 GOLF MERCHANDISE 97,500 97,500 88,102.41 11,024.23 2,147.58 7,250.01 92.6%* L8046 35532 GOLF LESSONS EXPENSE 28,000 28,000 20,606.00 889.20 .00 7,394.00 73.6%* L8046 35533 SPECIAL EVENTS /CAMPS 0 0 72.00 .00 .00 -72.00 100.0 %* L8046 35534 GOLF CLUB RENTAL EXPEN 2,000 2,000 381.60 .00 .00 1,618.40 19.1% L8046 35550 GOLF HANDICAP EXPENSES 3,000 3,000 2,803.50 .00 408.00 - 211.50 107.1 %* TOTAL GOLF SHOP EXPENSES 888,179 894,514 688,763.77 67,406.75 10,588.01 195,162.22 78.2% TOTAL EXPENSES 888,179 894,514 688,763.77 67,406.75 10,588.01 195,162.22 L8053 FOOD & BEVERAGE EXPENSES L8053 11110 EXECUTIVE SALARIES 55,524 55,524 37,514.06 4,437.60 .00 18,009.94 67.6%* L8053 11210 REGULAR PAY 121,906 121,906 72,087.23 8,608.73 .00 49,818.77 59.1% L8053 11300 PART -TIME PAY 181,381 181,381 93,156.01 13,219.23 .00 88,224.99 51.4% L8053 11400 OVERTIME PAY 0 0 997.00 41.92 .00 - 997.00 100.0 %* L8053 11501 AUTO ALLOWANCE 0 0 2,769.30 369.24 .00 - 2,769.30 100.0 %* L8053 11507 INSURANCE - OPT OUT 0 0 549.22 .00 .00 - 549.22 100.0 %* L8053 12110 F I C A 27,449 27,449 20,288.09 2,645.04 .00 7,160.91 73.9%* L8053 12215 ICMA - DIRECTOR 8,329 8,329 5,627.11 665.64 .00 2,701.89 67.6%* L8053 12216 ICMA GENERAL EMPLOYEES 18,286 18,286 10,992.22 1,352.36 .00 7,293.78 60.1% L8053 12225 ICMA -457 MATCH 2,880 2,880 382.50 45.00 .00 2,497.50 13.3% L8053 12310 HEALTH INSURANCE 43,751 43,751 20,565.80 1,370.72 .00 23,185.20 47.0% L8053 12320 LIFE INSURANCE 348 348 224.75 21.75 .00 123.25 64.6% L8053 12330 L.T.D. INSURANCE 799 799 503.08 50.67 .00 295.92 63.0% 06/10/2014 17:25 VILLAGE OF NORTH PALM BEACH PG 3 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud MAY 31, 2014 * *PRELIMINARY ** FOR 2014 08 ORIGINAL REVISED AVAILABLE PCT L8053 FOOD & BEVERAGE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8053 12410 WORKERS' COMPENSATION 5,634 5,634 3,229.14 405.62 .00 2,404.86 57.3% L8053 33230 CHARGE CARD FEE 9,000 9,000 5,662.19 .00 .00 3,337.81 62.9% L8053 33411 LINEN RENTAL 10,000 10,000 6,575.42 960.57 .00 3,424.58 65.8% L8053 33430 CONTRACT LABOR 700 700 .00 .00 .00 700.00 .0% L8053 33434 ENTERTAINMENT & ETC. 10,000 10,000 3,485.81 224.05 .00 6,514.19 34.9% L8053 33491 CONTRACTUAL SERVICES 23,000 23,000 13,164.69 1,880.67 9,403.31 432.00 98.1%* L8053 34310 ELECTRICITY 23,618 23,618 14,650.20 2,084.30 .00 8,967.80 62.0% L8053 34320 WATER & SEWER 11,520 11,520 8,216.30 734.79 .00 3,303.70 71.3%* L8053 34330 GAS 9,500 9,500 6,642.38 846.70 .00 2,857.62 69.9%* L8053 34340 SOLID WASTE DISPOSAL 8,000 8,000 43.23 .00 .00 7,956.77 .5% L8053 34420 RENTAL - EQUIPMENT 5,500 5,500 3,143.70 375.00 .00 2,356.30 57.2% L8053 34620 R & M BLDG & GROUNDS 8,000 8,000 8,419.59 3.39 .00 - 419.59 105.2 %* L8053 34622 R & M CARPET /TILE 26,000 26,000 4,583.76 .00 3,998.76 17,417.48 33.0% L8053 34630 R & M FURN. & OFF. EQ 700 700 .00 .00 .00 700.00 .0% L8053 34650 R & M MACH. & EQUIP. 4,000 4,000 1,317.48 33.09 .00 2,682.52 32.9% L8053 34655 R & M BURGLAR /FIRE AL 1,400 1,400 704.55 .00 .00 695.45 50.3% L8053 34658 R &M FACILITY SAFETY CO 0 0 187.50 .00 .00 - 187.50 100.0 %* L8053 34910 ADVERTISING 5,000 5,000 229.28 9.28 .00 4,770.72 4.6% L8053 34940 LICENSES & FEES 7,500 7,500 7,291.98 .00 .00 208.02 97.2%* L8053 35110 OFFICE SUPPLIES 1,000 1,000 324.50 .00 .00 675.50 32.5% L8053 35111 COMPUTER SUPPLIES 1,500 1,500 810.94 .00 .00 689.06 54.1% L8053 35130 PAPER GOODS & SUPPLIES 9,000 9,000 3,139.97 557.48 .00 5,860.03 34.9% L8053 35131 KITCHEN SUPPLIES 3,000 3,000 616.42 20.19 .00 2,383.58 20.5% L8053 35135 CHINA, GLASS, SILVERWA 2,000 2,000 962.24 .00 .00 1,037.76 48.1% L8053 35214 BUILDING MAINT. SUPPLI 1,000 1,000 26.08 .00 .00 973.92 2.6% L8053 35217 MACH. & EQUIP. SUPPLIE 1,500 1,500 18.53 .00 .00 1,481.47 1.2% L8053 35243 FURNITURE, FIXTURES & 0 0 147.42 .00 .00 - 147.42 100.0 %* L8053 35250 AMBIENCE 800 800 226.38 .00 .00 573.62 28.3% L8053 35270 CUSTODIAL SUPPLIES 7,000 7,000 3,838.07 542.50 .00 3,161.93 54.8% L8053 35280 GAS, OIL & LUBRICANTS 1,600 1,600 56.55 10.00 .00 1,543.45 3.5% L8053 35290 MISC. OPERATING EXPENS 500 500 216.96 42.75 .00 283.04 43.4% L8053 35294 UNIFORMS & SHOES 1,200 1,200 523.04 39.44 .00 676.96 43.6% L8053 35298 FLOWER EXPENSE 700 700 .00 .00 .00 700.00 .0% L8053 35510 MERCHANDISE - F &B 193,050 193,050 113,587.31 12,409.36 .00 79,462.69 58.8% L8053 35520 MERCHANDISE - LIQUOR 58,750 58,750 46,517.50 6,683.03 .00 12,232.50 79.2%* TOTAL FOOD & BEVERAGE EXPENSES 912,325 912,325 524,215.48 60,690.11 13,402.07 374,707.45 58.9% TOTAL EXPENSES 912,325 912,325 524,215.48 60,690.11 13,402.07 374,707.45 L8056 ADMINISTRATIVE EXPENSES L8056 11210 REGULAR PAY 39,304 39,304 14,804.41 .00 .00 24,499.59 37.7% 06/10/2014 17:25 VILLAGE OF NORTH PALM BEACH PG 4 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud MAY 31, 2014 * *PRELIMINARY ** FOR 2014 08 L8059 CLUBHOUSE GROUNDS EXPENSE L8059 33440 EXTERMINATING ORIGINAL REVISED 2,203.84 137.74 .00 AVAILABLE PCT L8056 ADMINISTRATIVE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8056 11400 OVERTIME PAY 0 0 935.35 .00 .00 - 935.35 100.0 %* L8056 12110 F I C A 3,007 3,007 1,094.26 .00 .00 1,912.74 36.4% L8056 12216 ICMA GENERAL EMPLOYEES 5,896 5,896 2,220.67 .00 .00 3,675.33 37.7% L8056 12225 ICMA -457 MATCH 720 720 .00 .00 .00 720.00 .0% L8056 12310 HEALTH INSURANCE 18,528 18,528 6,863.35 .00 .00 11,664.65 37.0% L8056 12320 LIFE INSURANCE 87 87 36.25 .00 .00 50.75 41.7% L8056 12330 L.T.D. INSURANCE 177 177 70.40 .00 .00 106.60 39.8% L8056 12410 WORKERS' COMPENSATION 63 63 25.18 .00 .00 37.82 40.0% L8056 33160 DONATIONS EXP -PAVER BR 0 0 451.00 163.00 .00 - 451.00 100.0 %* L8056 33190 PROFESSIONAL SERVICES 0 0 15,090.04 3,497.49 .00 - 15,090.04 100.0 %* L8056 33210 ACCOUNTING & AUDITING 7,000 7,000 4,159.00 .00 .00 2,841.00 59.4% L8056 33491 CONTRACTUAL SERVICES 4,144 4,144 5,652.33 .00 .00 - 1,508.33 136.4%* L8056 34110 TELEPHONE 4,800 4,800 2,903.34 292.44 .00 1,896.66 60.5% L8056 34210 POSTAGE 3,000 3,000 1,076.92 .00 .00 1,923.08 35.9% L8056 34422 RENTAL - COPIER 4,000 4,000 2,648.80 303.47 .00 1,351.20 66.2% L8056 34710 PRINTING & BINDING 2,000 2,000 1,674.84 .00 .00 325.16 83.7%* L8056 34970 BAD DEBT EXPENSES 0 0 - 665.00 .00 .00 665.00 100.0% L8056 35110 OFFICE SUPPLIES 3,000 3,000 2,446.10 .00 .00 553.90 81.5%* L8056 35111 COMPUTER SUPPLIES 1,500 1,500 984.46 .00 .00 515.54 65.6% TOTAL ADMINISTRATIVE EXPENSES 97,226 97,226 62,471.70 4,256.40 .00 34,754.30 64.3% TOTAL EXPENSES 97,226 97,226 62,471.70 4,256.40 .00 34,754.30 L8059 CLUBHOUSE GROUNDS EXPENSE L8059 33440 EXTERMINATING 3,250 3,250 2,203.84 137.74 .00 1,046.16 67.8%* L8059 33491 CONTRACTUAL SERVICES 25,000 25,000 9,875.20 755.00 9,520.00 5,604.80 77.6%* L8059 34110 TELEPHONE 1,327 1,327 909.12 113.78 .00 417.88 68.5%* L8059 34310 ELECTRICITY 15,746 15,746 9,766.77 1,389.53 .00 5,979.23 62.0% L8059 34320 WATER & SEWER 26,109 26,109 20,104.91 1,831.79 .00 6,004.09 77.0%* L8059 34330 GAS 8,817 8,817 574.02 41.74 .00 8,242.98 6.5% L8059 34340 SOLID WASTE DISPOSAL 3,423 3,423 .00 .00 .00 3,423.00 .0% L8059 34620 R & M BLDG & GROUNDS 14,500 14,500 17,045.94 665.58 2,350.00 - 4,895.94 133.8 %* L8059 34640 R & M IRRIGATION SYS. 0 0 784.58 .00 .00 - 784.58 100.0 %* L8059 34650 R & M MACH. & EQUIP. 500 500 1,516.00 120.00 .00 - 1,016.00 303.2 %* L8059 34655 R & M BURGLAR /FIRE AL 1,500 1,500 1,116.30 .00 .00 383.70 74.4%* L8059 34656 R & M FIRE EQUIPMENT 750 750 109.50 .00 200.00 440.50 41.3% L8059 34657 R & M PLUMB.,HEAT. & 2,544 2,544 658.60 .00 1,050.00 835.40 67.2%* L8059 34658 R &M FACILITY SAFETY CO 0 4,000 4,586.93 .00 .00 - 586.93 114.7 %* L8059 35213 SHOP TOOLS & SUPPLIES 100 100 132.10 .00 .00 -32.10 132.1 %* L8059 35214 BUILDING MAINT. SUPPLI 608 608 34.60 .00 300.00 273.40 55.0% L8059 35216 IRRIGATION SUPPLIES 200 200 .00 .00 .00 200.00 .0% 06/10/2014 17:25 VILLAGE OF NORTH PALM BEACH PG 5 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud MAY 31, 2014 * *PRELIMINARY ** FOR 2014 08 48,529 48,529 32,213.60 3,989.00 .00 16,315.40 66.4% TOTAL INSURANCE EXPENSES ORIGINAL REVISED 32,213.60 3,989.00 .00 AVAILABLE PCT L8059 CLUBHOUSE GROUNDS EXPENSE APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8059 35217 MACH. & EQUIP. SUPPLIE 0 0 .00 .00 2,100.00 - 2,100.00 100.0 %* L8059 35270 CUSTODIAL SUPPLIES 200 200 .00 .00 .00 200.00 .0% L8059 66410 AUTOMOTIVE 12,000 12,000 8,119.60 8,119.60 .00 3,880.40 67.7%* TOTAL CLUBHOUSE GROUNDS EXPENSE 116,574 120,574 77,538.01 13,174.76 15,520.00 27,515.99 77.2% 14.3% TOTAL EXPENSES 116,574 120,574 77,538.01 13,174.76 15,520.00 27,515.99 20,683.50 L8062 INSURANCE EXPENSES L8062 34530 INSURANCE- COMP.GEN'L L 48,529 48,529 32,213.60 3,989.00 .00 16,315.40 66.4% TOTAL INSURANCE EXPENSES 48,529 48,529 32,213.60 3,989.00 .00 16,315.40 66.4% 548,751 TOTAL EXPENSES 48,529 48,529 32,213.60 3,989.00 .00 16,315.40 548,751 L8070 RESERVES EXPENSES 11,305.18 .00 259,230.11 GRAND TOTAL 3,784,955 3,804,090 L8070 33112 SPECIAL LEGAL SERVICES 10,000 10,000 3,447.50 787.50 .00 6,552.50 34.5% L8070 49910 COUNTRY CLUB CONTINGEN 14,131 14,131 .00 .00 .00 14,131.00 .0% TOTAL RESERVES EXPENSES 24,131 24,131 3,447.50 787.50 .00 20,683.50 14.3% TOTAL EXPENSES 24,131 24,131 3,447.50 787.50 .00 20,683.50 L8565 DEBT SERVICE EXPENSES L8565 49157 GOLF CART LEASE 150,600 150,600 90,441.44 11,305.18 .00 60,158.56 60.1% L8565 49170 DEBT PMT -BOA 4.893M 398,151 398,151 199,079.45 .00 .00 199,071.55 50.0% TOTAL DEBT SERVICE EXPENSES 548,751 548,751 289,520.89 11,305.18 .00 259,230.11 52.8% TOTAL EXPENSES 548,751 548,751 289,520.89 11,305.18 .00 259,230.11 GRAND TOTAL 3,784,955 3,804,090 2,481,933.47 275,744.67 426,096.36 896,060.17 76.4% ** END OF REPORT - Generated by samia janjua **