Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
CC JULY 2013_Preliminary Line Item Detail_080813
.0.0 munis- 08/08/2013 15:23 VILLAGE OF NORTH PALM BEACH PG 1 sjanjua YEAR-TO-DATE BUDGET REPORT glytdbud JULY 31, 2013 *** PRELIMINARY *** FOR 2013 10 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 912,480 912,480 772,258.87 36,249.66 140,221.13 84.6°%* L2100 05232 GOLF CART RENTAL 939,400 939,400 731,149.29 60,167.84 208,250.71 77.8°%* L2100 05234 LOCKER RENTALS 1,632 1,632 1,995.00 .00 -363.00 122.2°%* L2100 05235 GOLF HANDICAP SERVICE 1,288 1,288 2,155.00 50.00 -867.00 167.3°%* L2100 06621 CLUB-RESIDENT 345,870 345,870 331,175.10 .00 14,694.90 95.8°%* L2100 06622 CLUB-NON RESIDENT 229,900 229,900 199,115.12 .00 30,784.88 86.6°%* L2100 06623 SUMMER MEMBERSHIPS 44,210 44,210 22,770.00 1,485.00 21,440.00 51.5°%* L2100 06625 BUSINESS MEMBERSHIPS 0 0 3,750.00 .00 -3,750.00 100.0°%* L2100 06683 SOCIAL-JUNIOR 3,600 3,600 5,673.76 .00 -2,073.76 157.6°%* L2100 07100 WALKING FEE 37,520 37,520 38,022.50 1,922.00 -502.50 101.3°%* L2100 08310 TOURNAMENT PROCEEDS 2,716 2,716 2,419.27 65.20 296.73 89.1°%* L2100 08995 DONATIONS 0 0 5,000.00 .00 -5,000.00 100.0°%* TOTAL GRN FEE/CRT RNTLS/MBRSHIP 2,518,616 2,518,616 2,115,483.91 99,939.70 403,132.09 84.0°% TOTAL REVENUES 2,518,616 2,518,616 2,115,483.91 99,939.70 403,132.09 L2246 GOLF SHOP REVENUES L2246 02301 GOLF SHOP - SALES 140,150 140,150 139,396.75 10,721.31 753.25 99.5°%* L2246 02302 BAG ROOM 15,240 15,240 12,360.00 .00 2,880.00 81.1°%* L2246 02303 LESSONS 100,000 100,000 112,200.50 15,665.00 -12,200.50 112.2°%* L2246 02304 GOLF BALL RETRIEVAL 4,800 4,800 3,600.00 .00 1,200.00 75.0°%* L2246 02307 GOLF GRIP SALES 474 474 763.83 96.12 -289.83 161.1°%* L2246 02310 RENTAL-GOLF CLUBS 32,000 32,000 40,115.16 1,906.92 -8,115.16 125.4°%* L2246 02341 SPECIAL EVENTS/CAMPS 4,000 4,000 .00 .00 4,000.00 .0%* TOTAL GOLF SHOP REVENUES 296,664 296,664 308,436.24 28,389.35 -11,772.24 104.0°% TOTAL REVENUES 296,664 296,664 308,436.24 28,389.35 -11,772.24 L3100 INTEREST EARNINGS L3100 08204 INTEREST EARNED - TD B 7,327 7,327 5,198.89 .00 2,128.11 71.0°%* TOTAL INTEREST EARNINGS 7,327 7,327 5,198.89 .00 2,128.11 71.0°% TOTAL REVENUES 7,327 7,327 5,198.89 .00 2,128.11 L3200 DRIVING RANGE INCOME L3200 07200 LEASE - GOLF 0 0 12,500.00 .00 -12,500.00 100.00* .0.0 munis- 08/08/2013 15:23 VILLAGE OF NORTH PALM BEACH PG 2 sjanjua YEAR-TO-DATE BUDGET REPORT glytdbud JULY 31, 2013 *** PRELIMINARY *** FOR 2013 10 ORIGINAL REVISED ACTUAL YTD ACTUAL MTD REMAINING PCT ESTIM REV EST REV REVENUE REVENUE REVENUE COLL L3200 07500 DRIVING RANGE PROCEEDS 209,026 209,026 235,911.02 17,806.76 -26,885.02 112.9°%* TOTAL DRIVING RANGE INCOME 209,026 209,026 248,411.02 17,806.76 -39,385.02 118.8°% TOTAL REVENUES 209,026 209,026 248,411.02 17,806.76 -39,385.02 L3253 RESTAURANT INCOME L3253 08110 FOOD & BEVERAGE SALES 290,000 290,000 157,859.48 15,123.70 132,140.52 54.4°%* L3253 08111 BEVERAGE CART SALES 18,000 18,000 11,725.50 797.13 6,274.50 65.1°%* L3253 08112 LIQUOR SALES - BVG CAR 30,000 30,000 16,829.93 1,249.95 13,170.07 56.1°%* L3253 08113 NON-ALCOHOLIC BEVERAGE 27,000 27,000 22,548.11 1,856.50 4,451.89 83.5°%* L3253 08120 LIQUOR SALES - F & B 210,000 210,000 160,157.14 17,714.35 49,842.86 76.3°%* L3253 08130 FACILITY - RENTAL 36,300 36,300 6,093.53 625.00 30,206.47 16.8°%* L3253 08135 BANQUETS 210,000 210,000 152,556.22 13,399.85 57,443.78 72.6°%* L3253 08999 MISC. REVENUES 0 0 277.42 .55 -277.42 100.0°%* TOTAL RESTAURANT INCOME 821,300 821,300 528,047.33 50,767.03 293,252.67 64.3°% TOTAL REVENUES 821,300 821,300 528,047.33 50,767.03 293,252.67 L3700 OTHER MISC. REVENUES L3700 08920 DISCOUNTS EARNED 0 0 300.00 30.00 -300.00 100.0°%* L3700 08945 CARD FEE - RESIDENCY 0 0 1,980.00 15.00 -1,980.00 100.0°%* L3700 08980 COMMISSIONS-VENDING MA 0 0 529.55 107.25 -529.55 100.0°%* L3700 08990 OTHER SALES OF SURPLUS 96,000 96,000 133,000.00 .00 -37,000.00 138.5°%* L3700 08995 DONATIONS-PAVER BRICKS 0 0 660.31 188.66 -660.31 100.0°%* L3700 08999 MISC. REVENUES 0 0 6.86 -.01 -6.86 100.0°%* TOTAL OTHER MISC. REVENUES 96,000 96,000 136,476.72 340.90 -40,476.72 142.2°% TOTAL REVENUES 96,000 96,000 136,476.72 340.90 -40,476.72 GRAND TOTAL 3,948,933 3,948,933 3,342,054.11 197,243.74 606,878.89 84.6°% ** END OF REPORT - Generated by samia janjua ** .0.0 munis- 08/08/2013 15:24 VILLAGE OF NORTH PALM BEACH PG 1 sjanjua YEAR-TO-DATE BUDGET REPORT glytdbud JULY 31, 2013 *** PRELIMINARY *** FOR 2013 10 ORIGINAL REVISED AVAILABLE PCT APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8045 GOLF COURSE MAINT. EXP. L8045 33190 PROFESSIONAL SERVICES 0 0 382.50 .00 .00 -382.50 100.0°%* L8045 33491 CONTRACTUAL SERVICES 1,153,888 1,126,043 867,685.90 86,768.59 177,953.10 80,404.00 92.9°%* L8045 34310 ELECTRICITY 51,188 51,188 37,777.14 3,875.50 .00 13,410.86 73.8°% L8045 34320 WATER & SEWER 25,860 25,860 17,370.40 196.35 .00 8,489.60 67.2°% L8045 34340 SOLID WASTE DISPOSAL 3,614 3,614 3,324.69 .00 .00 289.31 92.0°%* L8045 34620 R & M BLDG & GROUNDS 0 0 .00 .00 14,700.00 -14,700.00 100.0°%* L8045 34640 R & M IRRIGATION SYS. 0 0 480.00 .00 .00 -480.00 100.0°%* L8045 35222 TREES & SOD 8,000 8,000 3,195.75 1,250.00 .00 4,804.25 39.9°% TOTAL GOLF COURSE MAINT. EXP. 1,242,550 1,214,705 930,216.38 92,090.44 192,653.10 91,835.52 92.4°% TOTAL EXPENSES 1,242,550 1,214,705 930,216.38 92,090.44 192,653.10 91,835.52 L8046 GOLF SHOP EXPENSES L8046 11110 EXECUTIVE SALARIES 56,476 56,476 69,264.31 4,426.34 .00 -12,788.31 122.6°%* L8046 11210 REGULAR PAY 60,233 60,233 51,254.22 4,704.52 .00 8,978.78 85.1°%* L8046 11300 PART-TIME PAY 261,198 261,198 207,909.28 19,204.08 .00 53,288.72 79.6°% L8046 11400 OVERTIME PAY 1,000 1,000 695.80 .00 .00 304.20 69.6°% L8046 11501 AUTO ALLOWANCE 4,800 4,800 4,061.64 369.24 .00 738.36 84.6°%* L8046 11504 TELEPHONE ALLOWANCE 720 720 609.18 55.38 .00 110.82 84.6°%* L8046 11506 COMMISSIONS - LESSONS 45,000 45,000 63,544.77 5,633.60 .00 -18,544.77 141.2°%* L8046 12110 F I C A 32,852 32,852 30,098.25 2,607.28 .00 2,753.75 91.6°%* L8046 12215 ICMA - DIRECTOR 9,300 9,300 7,196.15 663.96 .00 2,103.85 77.4°% L8046 12216 ICMA GENERAL EMPLOYEES 4,852 4,852 4,124.58 382.20 .00 727.42 85.0°%* L8046 12217 ICMA MUNICIPAL EMPLOYE 4,334 4,334 3,326.32 323.46 .00 1,007.68 76.7°% L8046 12225 ICMA-457 MATCH 2,160 2,160 609.20 55.40 .00 1,550.80 28.2°% L8046 12310 HEALTH INSURANCE 29,771 29,771 24,809.84 2,480.98 .00 4,961.16 83.3°%* L8046 12320 LIFE INSURANCE 261 261 222.75 21.75 .00 38.25 85.3°%* L8046 12330 L.T.D. INSURANCE 526 526 404.30 42.54 .00 121.70 76.9°% L8046 12410 WORKERS' COMPENSATION 5,165 5,165 4,689.55 431.35 .00 475.45 90.8°%* L8046 33160 DONATIONS EXPENSES 0 0 953.66 .00 .00 -953.66 100.0°%* L8046 33230 CHARGE CARD FEE 51,500 51,500 43,794.37 2,825.94 .00 7,705.63 85.0°%* L8046 33491 CONTRACTUAL SERVICES 12,000 120 745.28 -14.85 857.50 -1,482.78 1335.7°%* L8046 34010 TRAVEL & LODGING 2,700 2,700 .00 .00 .00 2,700.00 .0% L8046 34110 TELEPHONE 5,136 5,136 3,229.51 281.73 .00 1,906.49 62.9°% L8046 34210 POSTAGE 0 0 36.77 .00 .00 -36.77 100.0°%* L8046 34310 ELECTRICITY 25,772 25,772 21,637.35 2,179.98 .00 4,134.65 84.0°%* L8046 34320 WATER & SEWER 1,215 1,215 896.86 44.15 .00 318.14 73.8°% .0.0 munis- 08/08/2013 15:24 VILLAGE OF NORTH PALM BEACH PG 2 sjanjua YEAR-TO-DATE BUDGET REPORT glytdbud JULY 31, 2013 *** PRELIMINARY *** FOR 2013 10 ORIGINAL REVISED 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 700.11 .00 1,351.00 -551.11 136.7°%* L8046 34650 R & M MACH. & EQUIP. 1,500 1,500 5,298.13 3,313.93 .00 -3,798.13 353.2°%* L8046 34658 R&M FACILITY SAFETY CO 0 0 40.88 .00 .00 -40.88 100.0°%* L8046 34710 PRINTING & BINDING 3,500 3,500 .00 .00 .00 3,500.00 .0% L8046 34812 CLUB RELATIONS 500 500 303.85 .00 .00 196.15 60.8°% L8046 34910 ADVERTISING 42,000 42,000 15,509.25 549.00 .00 26,490.75 36.9°% L8046 34940 LICENSES & FEES 0 0 579.50 579.50 20.50 -600.00 100.0°%* L8046 34960 TROPHIES, AWARDS & PRI 1,000 1,000 982.50 .00 .00 17.50 98.3°%* L8046 34970 BAD DEBT EXPENSES 0 0 -1,325.78 .00 .00 1,325.78 100.0°% L8046 35110 OFFICE SUPPLIES 3,000 3,000 1,904.43 113.31 .00 1,095.57 63.5°% L8046 35111 COMPUTER SUPPLIES 3,000 3,000 1,403.40 572.95 .00 1,596.60 46.8°% L8046 35120 GOLF SUPPLIES 22,000 22,000 19,469.49 1,509.49 .00 2,530.51 88.5°%* L8046 35213 SHOP TOOLS & SUPPLIES 1,000 1,000 402.08 .00 .00 597.92 40.2°% L8046 35214 BUILDING MAINT. SUPPLI 500 500 .00 .00 200.00 300.00 40.0°% L8046 35215 FURNITURE/FIXTURE SUPP 1,500 1,500 244.59 .00 .00 1,255.41 16.3°% L8046 35217 MACH. & EQUIP. SUPPLIE 4,500 4,500 2,860.79 235.17 5,653.19 -4,013.98 189.2°%* L8046 35240 MEDICAL & SAFETY SUPPL 0 0 55.80 .00 .00 -55.80 100.0°%* L8046 35270 CUSTODIAL SUPPLIES 500 500 7.99 .00 .00 492.01 1.6% L8046 35294 UNIFORMS & SHOES 4,000 4,000 3,254.60 .00 25.19 720.21 82.0°% L8046 35410 BOOKS, PUBLS., & SUBSC 100 100 271.71 .00 .00 -171.71 271.7°%* L8046 35420 MEMBERSHIP & DUES 2,800 2,800 1,526.00 .00 .00 1,274.00 54.5°% L8046 35430 CONFERENCE & SEMINARS 1,700 1,700 340.00 .00 .00 1,360.00 20.0°% L8046 35530 GOLF MERCHANDISE 98,000 98,000 95,351.43 17,527.68 .00 2,648.57 97.3°%* L8046 35532 GOLF LESSONS EXPENSE 35,000 35,000 29,290.40 6,392.80 .00 5,709.60 83.7°%* L8046 35533 SPECIAL EVENTS/CAMPS 500 500 200.00 .00 .00 300.00 40.0°% L8046 35534 GOLF CLUB RENTAL EXPEN 2,000 2,000 1,184.30 .00 .00 815.70 59.2°% L8046 35550 GOLF HANDICAP EXPENSES 3,000 3,000 2,592.00 .00 552.00 -144.00 104.8°%* TOTAL GOLF SHOP EXPENSES 850,071 838,191 726,561.39 77,512.86 8,659.38 102,970.23 87.7°% TOTAL EXPENSES 850,071 838,191 726,561.39 77,512.86 8,659.38 102,970.23 L8053 FOOD & BEVERAGE EXPENSES L8053 11110 EXECUTIVE SALARIES 51,862 51,862 43,759.13 3,991.60 .00 8,102.87 84.4°%* L8053 11210 REGULAR PAY 40,776 40,776 34,420.57 3,196.76 .00 6,355.43 84.4°%* L8053 11300 PART-TIME PAY 192,024 192,024 150,169.37 12,833.95 .00 41,854.63 78.2°% L8053 11400 OVERTIME PAY 500 500 .00 .00 .00 500.00 .0% L8053 12110 F I C A 21,815 21,815 21,672.02 1,825.26 .00 142.98 99.3°%* L8053 12215 ICMA - DIRECTOR 7,780 7,780 6,563.89 598.74 .00 1,216.11 84.4°%* L8053 12216 ICMA GENERAL EMPLOYEES 6,192 6,192 5,163.15 479.52 .00 1,028.85 83.4°%* L8053 12225 ICMA-457 MATCH 1,440 1,440 275.00 25.00 .00 1,165.00 19.1°% L8053 12310 HEALTH INSURANCE 28,335 28,335 19,342.00 1,930.20 .00 8,993.00 68.3°% .0.0 munis- 08/08/2013 15:24 VILLAGE OF NORTH PALM BEACH PG 3 sjanjua YEAR-TO-DATE BUDGET REPORT glytdbud JULY 31, 2013 *** PRELIMINARY *** FOR 2013 10 ORIGINAL REVISED AVAILABLE PCT L8053 FOOD & BEVERAGE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8053 12320 LIFE INSURANCE 174 174 148.50 14.50 .00 25.50 85.3°%* L8053 12330 L.T.D. INSURANCE 417 417 316.44 33.48 .00 100.56 75.9°% L8053 12410 WORKERS' COMPENSATION 3,893 3,893 4,131.79 362.38 .00 -238.79 106.1°%* L8053 12415 UNEMPLOYMENT COMPENSAT 8,606 8,606 5,162.30 .00 .00 3,443.70 60.0°% L8053 33190 PROFESSIONAL SERVICES 600 600 135.00 .00 .00 465.00 22.5°% L8053 33230 CHARGE CARD FEE 8,000 8,000 7,516.33 823.26 .00 483.67 94.0°%* L8053 33411 LINEN RENTAL 10,000 10,000 8,987.39 729.74 .00 1,012.61 89.9°%* L8053 33430 CONTRACT LABOR 500 500 520.00 .00 .00 -20.00 104.0°%* L8053 33434 ENTERTAINMENT & ETC. 10,000 10,000 6,077.13 985.39 .00 3,922.87 60.8°% L8053 33491 CONTRACTUAL SERVICES 26,000 26,000 19,671.70 1,880.67 3,761.34 2,566.96 90.1°%* L8053 34310 ELECTRICITY 26,140 26,140 19,608.86 2,103.77 .00 6,531.14 75.0°% L8053 34320 WATER & SEWER 11,249 11,249 8,903.34 775.84 .00 2,345.66 79.1°% L8053 34330 GAS 12,884 12,884 7,473.63 726.96 .00 5,410.37 58.0°% L8053 34340 SOLID WASTE DISPOSAL 7,224 7,224 6,646.20 .00 .00 577.80 92.0°%* L8053 34420 RENTAL - EQUIPMENT 5,500 5,500 3,909.00 375.00 .00 1,591.00 71.1°% L8053 34620 R & M BLDG & GROUNDS 1,700 1,700 4,075.56 190.00 .00 -2,375.56 239.7°%* L8053 34622 R & M CARPET/TILE 13,000 13,000 12,367.60 .00 .00 632.40 95.1°%* L8053 34630 R & M FURN. & OFF. EO 700 700 .00 .00 .00 700.00 .0% L8053 34650 R & M MACH. & EQUIP. 7,000 7,000 6,254.88 .00 .00 745.12 89.4°%* L8053 34655 R & M BURGLAR/FIRE AL 800 800 1,281.40 114.35 .00 -481.40 160.2°%* L8053 34658 R&M FACILITY SAFETY CO 0 0 2,049.34 .00 .00 -2,049.34 100.0°%* L8053 34910 ADVERTISING 3,000 3,000 461.83 9.97 .00 2,538.17 15.4°% L8053 34940 LICENSES & FEES 5,200 5,200 6,250.33 .00 .00 -1,050.33 120.2°%* L8053 35110 OFFICE SUPPLIES 750 750 502.74 .00 .00 247.26 67.0°% L8053 35111 COMPUTER SUPPLIES 1,000 1,000 349.99 .00 .00 650.01 35.0°% L8053 35130 PAPER GOODS & SUPPLIES 8,000 8,000 3,977.08 326.48 .00 4,022.92 49.7°% L8053 35131 KITCHEN SUPPLIES 3,000 3,000 561.10 144.36 .00 2,438.90 18.7°% L8053 35135 CHINA, GLASS, SILVERWA 1,500 1,500 1,190.96 24.40 .00 309.04 79.4°% L8053 35214 BUILDING MAINT. SUPPLI 800 800 207.05 .00 232.92 360.03 55.0°% L8053 35217 MACH. & EQUIP. SUPPLIE 2,000 2,000 154.72 .00 .00 1,845.28 7.7% L8053 35243 FURNITURE, FIXTURES & 1,000 1,000 169.56 34.94 3,576.80 -2,746.36 374.6°%* L8053 35250 AMBIENCE 500 500 47.00 .00 .00 453.00 9.4% L8053 35270 CUSTODIAL SUPPLIES 6,000 6,000 4,567.93 553.63 .00 1,432.07 76.1°% L8053 35280 GAS, OIL & LUBRICANTS 150 150 74.61 19.61 .00 75.39 49.7°% L8053 35290 MISC. OPERATING EXPENS 700 700 281.94 18.97 .00 418.06 40.3°% L8053 35294 UNIFORMS & SHOES 800 800 804.52 .00 .00 -4.52 100.6°%* L8053 35298 FLOWER EXPENSE 700 700 104.94 .00 .00 595.06 15.0°% L8053 35510 MERCHANDISE - F&B 218,000 218,000 139,731.72 12,546.23 .00 78,268.28 64.1°% L8053 35520 MERCHANDISE - LIQUOR 72,000 72,000 54,586.08 3,949.50 .00 17,413.92 75.8°% L8053 66210 CONSTR. & MAJOR RENOVA 53,639 39,092 5,177.47 .00 .00 33,914.53 13.2°% L8053 66410 AUTOMOTIVE 0 14,547 13,746.40 .00 .00 800.60 94.5°%* TOTAL FOOD & BEVERAGE EXPENSES 883,850 883,850 639,549.49 51,624.46 7,571.06 236,729.45 73.2°% TOTAL EXPENSES 883,850 883,850 639,549.49 51,624.46 7,571.06 236,729.45 L8056 ADMINISTRATIVE EXPENSES .0.0 munis- 08/08/2013 15:24 VILLAGE OF NORTH PALM BEACH PG 4 sjanjua YEAR-TO-DATE BUDGET REPORT glytdbud JULY 31, 2013 *** PRELIMINARY *** FOR 2013 10 ORIGINAL REVISED AVAILABLE PCT L8056 ADMINISTRATIVE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8056 11210 REGULAR PAY 35,321 35,321 29,949.55 2,825.54 .00 5,371.45 84.8°%* L8056 11400 OVERTIME PAY 500 500 79.47 .00 .00 420.53 15.9°% L8056 12110 F I C A 2,741 2,741 2,030.31 189.96 .00 710.69 74.1°% L8056 12216 ICMA GENERAL EMPLOYEES 5,374 5,374 4,492.38 423.84 .00 881.62 83.6°%* L8056 12225 ICMA-457 MATCH 720 720 .00 .00 .00 720.00 .0% L8056 12310 HEALTH INSURANCE 11,322 11,322 14,212.84 1,417.78 .00 -2,890.84 125.5°%* L8056 12320 LIFE INSURANCE 87 87 74.25 7.25 .00 12.75 85.3°%* L8056 12330 L.T.D. INSURANCE 159 159 121.95 13.16 .00 37.05 76.7°% L8056 12410 WORKERS' COMPENSATION 62 62 60.11 5.66 .00 1.89 97.0°%* L8056 33160 DONATIONS EXP-PAVER BR 0 0 393.00 72.50 .00 -393.00 100.0°%* L8056 33210 ACCOUNTING & AUDITING 7,000 7,000 6,071.00 .00 .00 929.00 86.7°%* L8056 33491 CONTRACTUAL SERVICES 34,139 34,139 4,139.00 .00 .00 30,000.00 12.1°% L8056 34110 TELEPHONE 5,894 5,894 3,888.69 358.96 .00 2,005.31 66.0°% L8056 34210 POSTAGE 3,000 3,000 1,344.31 78.19 .00 1,655.69 44.8°% L8056 34422 RENTAL-COPIER 5,214 5,214 3,153.36 306.19 .00 2,060.64 60.5°% L8056 34710 PRINTING & BINDING 2,000 2,000 1,391.50 .00 .00 608.50 69.6°% L8056 35110 OFFICE SUPPLIES 2,500 2,500 2,848.90 .00 .00 -348.90 114.0°%* L8056 35111 COMPUTER SUPPLIES 1,500 1,500 815.52 65.07 .00 684.48 54.4°% TOTAL ADMINISTRATIVE EXPENSES 117,533 117,533 75,066.14 5,764.10 .00 42,466.86 63.9°% TOTAL EXPENSES 117,533 117,533 75,066.14 5,764.10 .00 42,466.86 L8059 CLUBHOUSE GROUNDS EXPENSE L8059 33440 EXTERMINATING 3,000 3,000 2,649.84 275.48 .00 350.16 88.3°%* L8059 33491 CONTRACTUAL SERVICES 27,000 27,000 19,194.27 755.00 1,510.00 6,295.73 76.7°% L8059 34110 TELEPHONE 2,053 2,053 1,076.71 110.68 .00 976.29 52.4°% L8059 34310 ELECTRICITY 17,427 17,427 13,072.58 1,402.52 .00 4,354.42 75.0°% L8059 34320 WATER & SEWER 27,637 27,637 20,841.65 1,922.61 .00 6,795.35 75.4°% L8059 34330 GAS 4,747 4,747 4,601.96 31.90 .00 145.04 96.9°%* L8059 34340 SOLID WASTE DISPOSAL 3,612 3,612 3,323.10 .00 .00 288.90 92.0°%* L8059 34620 R & M BLDG & GROUNDS 11,000 11,000 7,311.97 885.74 4,172.54 -484.51 104.4°%* L8059 34650 R & M MACH. & EQUIP. 500 500 328.47 .00 .00 171.53 65.7°% L8059 34655 R & M BURGLAR/FIRE AL 2,000 2,000 1,172.80 194.20 .00 827.20 58.6°% L8059 34656 R & M FIRE EQUIPMENT 1,000 1,000 467.50 109.50 .00 532.50 46.8°% L8059 34657 R & M PLUMB. ,HEAT. & 4,879 4,879 1,429.98 502.60 2,086.67 1,362.35 72.1°% L8059 34658 R&M FACILITY SAFETY CO 0 27,845 5,976.82 .00 993.02 20,875.16 25.0°% L8059 35213 SHOP TOOLS & SUPPLIES 200 200 58.43 .00 .00 141.57 29.2°% L8059 35214 BUILDING MAINT. SUPPLI 2,275 2,275 241.17 .00 1,191.41 842.42 63.0°% L8059 35216 IRRIGATION SUPPLIES 200 200 .00 .00 .00 200.00 .0% L8059 35270 CUSTODIAL SUPPLIES 500 500 .00 .00 .00 500.00 .0% .0.0 munis- 08/08/2013 15:24 VILLAGE OF NORTH PALM BEACH PG 5 sjanjua YEAR-TO-DATE BUDGET REPORT glytdbud JULY 31, 2013 *** PRELIMINARY *** FOR 2013 10 ORIGINAL REVISED AVAILABLE PCT L8059 CLUBHOUSE GROUNDS EXPENSE APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED TOTAL CLUBHOUSE GROUNDS EXPENSE 108,030 135,875 81,747.25 6,190.23 9,953.64 44,174.11 67.5°% TOTAL EXPENSES 108,030 135,875 81,747.25 6,190.23 9,953.64 44,174.11 L8062 INSURANCE EXPENSES L8062 34530 INSURANCE-COMP.GEN'L L 43,881 43,881 36,400.00 3,640.00 .00 7,481.00 83.0o TOTAL INSURANCE EXPENSES 43,881 43,881 36,400.00 3,640.00 .00 7,481.00 83.0o TOTAL EXPENSES 43,881 43,881 36,400.00 3,640.00 .00 7,481.00 L8070 RESERVES EXPENSES L8070 33112 SPECIAL LEGAL SERVICES 7,500 7,500 11,941.57 157.50 .00 -4,441.57 159.2°%* L8070 49910 COUNTRY CLUB CONTINGEN 126,067 75,064 .00 .00 .00 75,064.00 .0% TOTAL RESERVES EXPENSES 133,567 82,564 11,941.57 157.50 .00 70,622.43 14.5°% TOTAL EXPENSES 133,567 82,564 11,941.57 157.50 .00 70,622.43 L8565 DEBT SERVICE EXPENSES L8565 49157 GOLF CART LEASE 171,300 234,183 195,725.74 12,505.18 .00 38,457.26 83.6°%* 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 569,451 632,334 394,805.19 12,505.18 .00 237,528.81 62.4°% TOTAL EXPENSES 569,451 632,334 394,805.19 12,505.18 .00 237,528.81 GRAND TOTAL 3,948,933 3,948,933 2,896,287.41 249,484.77 218,837.18 833,808.41 78.9°% ** END OF REPORT - Generated by samia janjua **