Loading...
CC SEP 2013_Preliminary Line Item Detail_10101310/10/2013 13:45 VILLAGE OF NORTH PALM BEACH PG 1 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud SEPTEMBER 30, 2013 ** PRELIMINARY ** FOR 2013 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 912,480 912,480 841,875.19 32,600.53 70,604.81 92.3%* L2100 05232 GOLF CART RENTAL 939,400 939,400 849,010.41 54,835.84 90,389.59 90.4%* L2100 05234 LOCKER RENTALS 1,632 1,632 2,325.00 330.00 - 693.00 142.5 %* L2100 05235 GOLF HANDICAP SERVICE 1,288 1,288 2,255.00 75.00 - 967.00 175.1 %* L2100 06621 CLUB - RESIDENT 345,870 345,870 332,091.62 161.67 13,778.38 96.0%* 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 .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 40,927.00 1,321.50 - 3,407.00 109.1 %* L2100 08310 TOURNAMENT PROCEEDS 2,716 2,716 2,610.17 111.05 105.83 96.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,307,403.27 89,435.59 211,212.73 91.6% TOTAL REVENUES 2,518,616 2,518,616 2,307,403.27 89,435.59 211,212.73 L2246 GOLF SHOP REVENUES L2246 02301 GOLF SHOP - SALES 140,150 140,150 165,860.91 16,262.81 - 25,710.91 118.3 %* L2246 02302 BAG ROOM 15,240 15,240 12,360.00 .00 2,880.00 81.1%* L2246 02303 LESSONS 100,000 100,000 146,627.00 17,259.50 - 46,627.00 146.6 %* 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 867.33 84.60 - 393.33 183.0 %* L2246 02310 RENTAL -GOLF CLUBS 32,000 32,000 44,586.80 1,738.04 - 12,586.80 139.3 %* L2246 02341 SPECIAL EVENTS /CAMPS 4,000 4,000 .00 .00 4,000.00 .0%* TOTAL GOLF SHOP REVENUES 296,664 296,664 373,902.04 35,344.95 - 77,238.04 126.0% TOTAL REVENUES 296,664 296,664 373,902.04 35,344.95 - 77,238.04 L3100 INTEREST EARNINGS L3100 08204 INTEREST EARNED - TD B 7,327 7,327 6,995.86 .00 331.14 95.5%* TOTAL INTEREST EARNINGS 7,327 7,327 6,995.86 .00 331.14 95.5% TOTAL REVENUES 7,327 7,327 6,995.86 .00 331.14 L3200 DRIVING RANGE INCOME L3200 07200 LEASE - GOLF 0 0 12,500.00 .00 - 12,500.00 100.0 %* 10/10/2013 13:45 VILLAGE OF NORTH PALM BEACH PG 2 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud SEPTEMBER 30, 2013 ** PRELIMINARY ** FOR 2013 12 ORIGINAL ESTIM REV REVISED EST REV ACTUAL YTD REVENUE ACTUAL MTD REVENUE REMAINING REVENUE PCT COLL L3200 07500 DRIVING RANGE PROCEEDS 209,026 209,026 269,017.80 15,076.47 - 59,991.80 128.7 %* L3700 TOTAL DRIVING RANGE INCOME 209,026 209,026 281,517.80 15,076.47 - 72,491.80 134.7% L3700 08990 TOTAL REVENUES 209,026 209,026 281,517.80 15,076.47 - 72,491.80 138.5 %* L3253 RESTAURANT INCOME DONATIONS -PAVER BRICKS 0 0 660.31 .00 - 660.31 L3253 08110 FOOD & BEVERAGE SALES 290,000 290,000 180,262.41 8,061.69 109,737.59 62.2%* L3253 08111 BEVERAGE CART SALES 18,000 18,000 14,200.92 1,501.84 3,799.08 78.9%* L3253 08112 LIQUOR SALES - BVG CAR 30,000 30,000 18,677.27 994.23 11,322.73 62.3%* L3253 08113 NON - ALCOHOLIC BEVERAGE 27,000 27,000 25,612.56 1,533.25 1,387.44 94.9%* L3253 08120 LIQUOR SALES - F & B 210,000 210,000 187,594.58 12,165.36 22,405.42 89.3%* L3253 08130 FACILITY - RENTAL 36,300 36,300 7,068.53 350.00 29,231.47 19.5%* L3253 08135 BANQUETS 210,000 210,000 177,008.35 12,130.44 32,991.65 84.3%* L3253 08999 MISC. REVENUES 0 0 276.04 .19 - 276.04 100.0 %* TOTAL RESTAURANT INCOME 821,300 821,300 610,700.66 36,737.00 210,599.34 74.4% TOTAL REVENUES 821,300 821,300 610,700.66 36,737.00 210,599.34 L3700 OTHER MISC. REVENUES L3700 08920 DISCOUNTS EARNED 0 0 360.00 30.00 - 360.00 100.0 %* L3700 08945 CARD FEE - RESIDENCY 0 0 2,115.00 90.00 - 2,115.00 100.0 %* L3700 08980 COMMISSIONS - VENDING MA 0 0 529.55 .00 - 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 .00 - 660.31 100.0 %* L3700 08999 MISC. REVENUES 0 0 8.19 2.00 -8.19 100.0 %* TOTAL OTHER MISC. REVENUES 96,000 96,000 136,673.05 122.00 - 40,673.05 142.4% TOTAL REVENUES 96,000 96,000 136,673.05 122.00 - 40,673.05 GRAND TOTAL 3,948,933 3,948,933 3,717,192.68 176,716.01 231,740.32 94.1% ** END OF REPORT - Generated by samia janjua ** 10/10/2013 13:46 VILLAGE OF NORTH PALM BEACH PG 1 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud SEPTEMBER 30, 2013 ** PRELIMINARY ** FOR 2013 12 ORIGINAL APPROP REVISED BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES AVAILABLE BUDGET PCT USED L8045 GOLF COURSE MAINT. EXP. 60,233 60,233 60,895.75 4,810.20 .00 - 662.75 101.1 %* L8045 33190 PROFESSIONAL SERVICES 0 0 382.50 .00 .00 - 382.50 100.0 %* L8045 33491 CONTRACTUAL SERVICES 1,153,888 1,126,043 1,041,223.08 84,560.59 .00 84,819.92 92.5% L8045 34310 ELECTRICITY 51,188 51,188 45,747.29 3,625.23 .00 5,440.71 89.4% L8045 34320 WATER & SEWER 25,860 25,860 23,073.63 1,960.37 .00 2,786.37 89.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 5,900.00 2,850.00 8,800.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 4,787.75 692.00 .00 3,212.25 59.8% TOTAL GOLF COURSE MAINT. EXP. 1,242,550 1,214,705 1,124,918.94 93,688.19 8,800.00 80,986.06 93.3% 92.5% L8046 TOTAL EXPENSES 1,242,550 1,214,705 1,124,918.94 93,688.19 8,800.00 80,986.06 1,440.00 L8046 GOLF SHOP EXPENSES L8046 11110 EXECUTIVE SALARIES 56,476 56,476 78,116.99 4,426.34 .00 - 21,640.99 138.3 %* L8046 11210 REGULAR PAY 60,233 60,233 60,895.75 4,810.20 .00 - 662.75 101.1 %* L8046 11300 PART -TIME PAY 261,198 261,198 246,106.74 18,304.99 .00 15,091.26 94.2% 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,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 45,000 45,000 80,741.67 9,253.20 .00 - 35,741.67 179.4%* L8046 12110 F I C A 32,852 32,852 35,501.52 2,556.94 .00 - 2,649.52 108.1 %* L8046 12215 ICMA - DIRECTOR 9,300 9,300 8,524.07 663.96 .00 775.93 91.7% L8046 12216 ICMA GENERAL EMPLOYEES 4,852 4,852 4,888.98 382.20 .00 -36.98 100.8 %* L8046 12217 ICMA MUNICIPAL EMPLOYE 4,334 4,334 4,008.13 339.32 .00 325.87 92.5% L8046 12225 ICMA -457 MATCH 2,160 2,160 720.00 55.40 .00 1,440.00 33.3% L8046 12310 HEALTH INSURANCE 29,771 29,771 30,936.18 3,645.36 .00 - 1,165.18 103.9 %* L8046 12320 LIFE INSURANCE 261 261 266.25 21.75 .00 -5.25 102.0 %* L8046 12330 L.T.D. INSURANCE 526 526 490.36 43.03 .00 35.64 93.2% L8046 12410 WORKERS' COMPENSATION 5,165 5,165 5,544.94 414.18 .00 - 379.94 107.4%* L8046 33160 DONATIONS EXPENSES 0 0 3,264.66 1,914.10 .00 - 3,264.66 100.0 %* L8046 33230 CHARGE CARD FEE 51,500 51,500 51,052.57 4,810.79 .00 447.43 99.1% L8046 33491 CONTRACTUAL SERVICES 12,000 120 1,799.82 993.54 .00 - 1,679.82 1499.9 %* L8046 34010 TRAVEL & LODGING 2,700 2,700 .00 .00 .00 2,700.00 .0% L8046 34110 TELEPHONE 5,136 5,136 3,887.62 330.40 .00 1,248.38 75.7% L8046 34210 POSTAGE 0 0 50.90 .00 .00 -50.90 100.0 %* L8046 34310 ELECTRICITY 25,772 25,772 25,908.38 2,084.30 .00 - 136.38 100.5 %* L8046 34320 WATER & SEWER 1,215 1,215 1,019.80 78.79 .00 195.20 83.9% 10/10/2013 13:46 VILLAGE OF NORTH PALM BEACH PG 2 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud SEPTEMBER 30, 2013 ** PRELIMINARY ** FOR 2013 12 L8053 FOOD & BEVERAGE EXPENSES L8053 11110 EXECUTIVE SALARIES ORIGINAL REVISED 51,742.33 3,991.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 700.11 .00 .00 799.89 46.7% L8046 34650 R & M MACH. & EQUIP. 1,500 1,500 6,188.92 .00 .00 - 4,688.92 412.6 %* 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 525.00 525.00 .00 2,975.00 15.0% L8046 34812 CLUB RELATIONS 500 500 303.85 .00 .00 196.15 60.8% L8046 34910 ADVERTISING 42,000 42,000 21,791.18 1,831.07 3,200.00 17,008.82 59.5% L8046 34940 LICENSES & FEES 0 0 579.50 .00 .00 - 579.50 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,375.78 .00 .00 1,375.78 100.0% L8046 35110 OFFICE SUPPLIES 3,000 3,000 2,718.26 406.55 .00 281.74 90.6% L8046 35111 COMPUTER SUPPLIES 3,000 3,000 2,321.40 .00 .00 678.60 77.4% L8046 35120 GOLF SUPPLIES 22,000 22,000 20,954.81 697.77 .00 1,045.19 95.2% L8046 35213 SHOP TOOLS & SUPPLIES 1,000 1,000 464.64 .00 .00 535.36 46.5% L8046 35214 BUILDING MAINT. SUPPLI 500 500 163.40 .00 .00 336.60 32.7% 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 4,741.53 .00 3,135.00 - 3,376.53 175.0 %* 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,298.74 .00 .00 701.26 82.5% L8046 35410 BOOKS, PUBLS., & SUBSC 100 100 271.71 .00 .00 - 171.71 271.7 %* L8046 35420 MEMBERSHIP & DUES 2,800 2,800 1,675.00 149.00 .00 1,125.00 59.8% 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 97,715.13 7,792.39 .00 284.87 99.7% L8046 35532 GOLF LESSONS EXPENSE 35,000 35,000 36,665.60 620.80 .00 - 1,665.60 104.8 %* 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,550.42 366.12 .00 449.58 77.5% L8046 35550 GOLF HANDICAP EXPENSES 3,000 3,000 2,835.00 .00 .00 165.00 94.5% TOTAL GOLF SHOP EXPENSES 850,071 838,191 855,901.37 67,942.11 6,335.00 - 24,045.37 102.9% TOTAL EXPENSES 850,071 838,191 855,901.37 67,942.11 6,335.00 - 24,045.37 L8053 FOOD & BEVERAGE EXPENSES L8053 11110 EXECUTIVE SALARIES 51,862 51,862 51,742.33 3,991.60 .00 119.67 99.8% L8053 11210 REGULAR PAY 40,776 40,776 40,814.10 3,196.77 .00 -38.10 100.1 %* L8053 11300 PART -TIME PAY 192,024 192,024 173,440.68 10,953.92 .00 18,583.32 90.3% L8053 11400 OVERTIME PAY 500 500 .00 .00 .00 500.00 .0% L8053 12110 F I C A 21,815 21,815 25,130.17 1,662.64 .00 - 3,315.17 115.2 %* L8053 12215 ICMA - DIRECTOR 7,780 7,780 7,761.37 598.74 .00 18.63 99.8% L8053 12216 ICMA GENERAL EMPLOYEES 6,192 6,192 6,122.19 479.52 .00 69.81 98.9% L8053 12225 ICMA -457 MATCH 1,440 1,440 325.00 25.00 .00 1,115.00 22.6% L8053 12310 HEALTH INSURANCE 28,335 28,335 23,415.88 2,128.68 .00 4,919.12 82.6% 10/10/2013 13:46 VILLAGE OF NORTH PALM BEACH PG 3 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud SEPTEMBER 30, 2013 ** PRELIMINARY ** FOR 2013 12 ORIGINAL REVISED AVAILABLE PCT L8053 FOOD & BEVERAGE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8053 12320 LIFE INSURANCE 174 174 177.50 14.50 .00 -3.50 102.0 %* L8053 12330 L.T.D. INSURANCE 417 417 383.40 33.48 .00 33.60 91.9% L8053 12410 WORKERS' COMPENSATION 3,893 3,893 4,813.20 328.36 .00 - 920.20 123.6 %* 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 8,643.09 652.53 .00 - 643.09 108.0 %* L8053 33411 LINEN RENTAL 10,000 10,000 10,102.84 568.20 .00 - 102.84 101.0 %* L8053 33430 CONTRACT LABOR 500 500 520.00 .00 .00 -20.00 104.0 %* L8053 33434 ENTERTAINMENT & ETC. 10,000 10,000 7,352.88 240.38 .00 2,647.12 73.5% L8053 33491 CONTRACTUAL SERVICES 26,000 26,000 23,433.04 1,880.67 .00 2,566.96 90.1% L8053 34310 ELECTRICITY 26,140 26,140 24,315.74 2,179.00 .00 1,824.26 93.0% L8053 34320 WATER & SEWER 11,249 11,249 10,432.39 767.04 .00 816.61 92.7% L8053 34330 GAS 12,884 12,884 8,866.46 638.00 .00 4,017.54 68.8% 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 4,659.00 375.00 .00 841.00 84.7% L8053 34620 R & M BLDG & GROUNDS 1,700 1,700 4,477.54 151.98 .00 - 2,777.54 263.4 %* 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. EQ 700 700 .00 .00 .00 700.00 .0% L8053 34650 R & M MACH. & EQUIP. 7,000 7,000 7,417.51 794.37 .00 - 417.51 106.0 %* L8053 34655 R & M BURGLAR /FIRE AL 800 800 1,389.40 .00 .00 - 589.40 173.7 %* 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 568.19 .00 .00 2,431.81 18.9% L8053 34940 LICENSES & FEES 5,200 5,200 6,390.33 8.00 .00 - 1,190.33 122.9 %* L8053 35110 OFFICE SUPPLIES 750 750 502.74 .00 .00 247.26 67.0% L8053 35111 COMPUTER SUPPLIES 1,000 1,000 512.90 .00 .00 487.10 51.3% L8053 35130 PAPER GOODS & SUPPLIES 8,000 8,000 4,436.49 207.13 .00 3,563.51 55.5% L8053 35131 KITCHEN SUPPLIES 3,000 3,000 564.69 .00 .00 2,435.31 18.8% L8053 35135 CHINA, GLASS, SILVERWA 1,500 1,500 1,190.96 .00 .00 309.04 79.4% L8053 35214 BUILDING MAINT. SUPPLI 800 800 237.09 .00 .00 562.91 29.6% 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 3,746.36 .00 .00 - 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 5,263.80 322.73 .00 736.20 87.7% L8053 35280 GAS, OIL & LUBRICANTS 150 150 120.06 24.00 .00 29.94 80.0% L8053 35290 MISC. OPERATING EXPENS 700 700 293.43 9.49 .00 406.57 41.9% L8053 35294 UNIFORMS & SHOES 800 800 864.37 .00 .00 -64.37 108.0 %* L8053 35298 FLOWER EXPENSE 700 700 104.94 .00 .00 595.06 15.0% L8053 35510 MERCHANDISE - F &B 218,000 218,000 160,415.29 9,067.60 .00 57,584.71 73.6% L8053 35520 MERCHANDISE - LIQUOR 72,000 72,000 63,602.55 4,045.53 .00 8,397.45 88.3% 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 740,035.93 45,344.86 .00 143,814.07 83.7% TOTAL EXPENSES 883,850 883,850 740,035.93 45,344.86 .00 143,814.07 L8056 ADMINISTRATIVE EXPENSES 10/10/2013 13:46 VILLAGE OF NORTH PALM BEACH PG 4 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud SEPTEMBER 30, 2013 ** PRELIMINARY ** FOR 2013 12 L8059 CLUBHOUSE GROUNDS EXPENSE L8059 33440 EXTERMINATING ORIGINAL REVISED 3,200.80 275.48 .00 AVAILABLE PCT L8056 ADMINISTRATIVE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED 76.7% L8059 34110 TELEPHONE 2,053 2,053 1,303.38 113.39 .00 L8056 11210 REGULAR PAY 35,321 35,321 35,600.63 2,825.54 .00 - 279.63 100.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,412.36 192.09 .00 328.64 88.0% L8056 12216 ICMA GENERAL EMPLOYEES 5,374 5,374 5,340.06 423.84 .00 33.94 99.4% L8056 12225 ICMA -457 MATCH 720 720 .00 .00 .00 720.00 .0% L8056 12310 HEALTH INSURANCE 11,322 11,322 17,161.92 1,516.30 .00 - 5,839.92 151.6 %* L8056 12320 LIFE INSURANCE 87 87 88.75 7.25 .00 -1.75 102.0 %* L8056 12330 L.T.D. INSURANCE 159 159 148.27 13.16 .00 10.73 93.3% L8056 12410 WORKERS' COMPENSATION 62 62 71.43 5.66 .00 -9.43 115.2 %* L8056 33160 DONATIONS EXP -PAVER BR 0 0 393.00 .00 .00 - 393.00 100.0 %* L8056 33210 ACCOUNTING & AUDITING 7,000 7,000 8,151.00 1,300.00 .00 - 1,151.00 116.4 %* 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 4,682.17 400.08 .00 1,211.83 79.4% L8056 34210 POSTAGE 3,000 3,000 1,805.69 234.35 .00 1,194.31 60.2% L8056 34422 RENTAL - COPIER 5,214 5,214 4,068.34 602.86 .00 1,145.66 78.0% 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,905.60 .00 .00 - 405.60 116.2 %* L8056 35111 COMPUTER SUPPLIES 1,500 1,500 973.70 39.72 .00 526.30 64.9% TOTAL ADMINISTRATIVE EXPENSES 117,533 117,533 89,412.89 7,560.85 .00 28,120.11 76.1% TOTAL EXPENSES 117,533 117,533 89,412.89 7,560.85 .00 28,120.11 L8059 CLUBHOUSE GROUNDS EXPENSE L8059 33440 EXTERMINATING 3,000 3,000 3,200.80 275.48 .00 - 200.80 106.7 %* L8059 33491 CONTRACTUAL SERVICES 27,000 27,000 20,704.27 755.00 .00 6,295.73 76.7% L8059 34110 TELEPHONE 2,053 2,053 1,303.38 113.39 .00 749.62 63.5% L8059 34310 ELECTRICITY 17,427 17,427 16,210.49 1,452.65 .00 1,216.51 93.0% L8059 34320 WATER & SEWER 27,637 27,637 24,631.04 1,900.56 .00 3,005.96 89.1% L8059 34330 GAS 4,747 4,747 4,651.99 25.55 .00 95.01 98.0% 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 9,340.91 1,852.03 .00 1,659.09 84.9% 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,304.80 .00 .00 695.20 65.2% L8059 34656 R & M FIRE EQUIPMENT 1,000 1,000 467.50 .00 .00 532.50 46.8% L8059 34657 R & M PLUMB.,HEAT. & 4,879 4,879 1,609.98 90.00 .00 3,269.02 33.0% L8059 34658 R &M FACILITY SAFETY CO 0 27,845 5,976.82 .00 4,000.00 17,868.18 35.8% 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 .00 2,033.83 10.6% L8059 35216 IRRIGATION SUPPLIES 200 200 .00 .00 .00 200.00 .0% L8059 35270 CUSTODIAL SUPPLIES 500 500 .00 .00 .00 500.00 .0% sianjua FOR 2013 12 L8059 CLUBHOUSE GROUNDS EXPENSE ZBtiK-1V-LtilB muuuml KBYVKl SEPTEMBER 30, 2013 ** PRELIMINARY ** PG 5 glytdbud ORIGINAL REVISED AVAILABLE PCT APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED TOTAL CLUBHOUSE GROUNDS EXPENSE 108,030 135,875 93,353.15 6,464.66 4,000.00 38,521.85 71.6% TOTAL EXPENSES 108,030 135,875 93,353.15 6,464.66 4,000.00 38,521.85 L8062 INSURANCE EXPENSES L8062 34530 INSURANCE- COMP.GEN'L L 43,881 43,881 43,680.00 3,640.00 .00 201.00 99.5% L8565 49170 DEBT PMT -BOA 4.893M TOTAL INSURANCE EXPENSES 43,881 43,881 43,680.00 3,640.00 .00 201.00 99.5% TOTAL EXPENSES 43,881 43,881 43,680.00 3,640.00 .00 201.00 TOTAL EXPENSES L8070 RESERVES EXPENSES 632,334 617,895.00 211,084.63 .00 14,439.00 GRAND TOTAL L8070 33112 SPECIAL LEGAL SERVICES 7,500 7,500 13,516.57 875.00 .00 - 6,016.57 180.2 %* L8070 49910 COUNTRY CLUB CONTINGEN 126,067 75,064 .00 .00 .00 75,064.00 .0% TOTAL RESERVES EXPENSES 133,567 82,564 13,516.57 875.00 .00 69,047.43 16.4% TOTAL EXPENSES 133,567 82,564 13,516.57 875.00 .00 69,047.43 L8565 DEBT SERVICE EXPENSES L8565 49157 GOLF CART LEASE 171,300 234,183 219,736.10 12,005.18 .00 14,446.90 93.8% L8565 49170 DEBT PMT -BOA 4.893M 398,151 398,151 398,158.90 199,079.45 .00 -7.90 100.0 %* TOTAL DEBT SERVICE EXPENSES 569,451 632,334 617,895.00 211,084.63 .00 14,439.00 97.7% TOTAL EXPENSES 569,451 632,334 617,895.00 211,084.63 .00 14,439.00 GRAND TOTAL 3,948,933 3,948,933 3,578,713.85 436,600.30 19,135.00 351,084.15 91.1% ** END OF REPORT - Generated by samia janjua **