Loading...
NOV 2016 CC PRELIM LINE ITEM DETAIL_AS OF 12-12-1612/12/2016 16:19 VILLAGE OF NORTH PALM BEACH P 1 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud NOVEMBER 30, 2016 *PRELIMINARY* FOR 2017 02 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 867,785 867,785 103,530.24 67,623.07 764,254.76 11.9°% L2100 05232 GOLF CART RENTAL 837,956 837,956 123,795.24 73,680.73 714,160.76 14.8°% L2100 05234 LOCKER RENTALS 2,000 2,000 1,215.00 255.00 785.00 60.8°% L2100 05235 GOLF HANDICAP SERVICE 2,000 2,000 1,225.00 225.00 775.00 61.3°% L2100 06621 CLUB - RESIDENT 349,690 349,690 254,002.35 40,585.36 95,687.65 72.6°% L2100 06622 CLUB -NON RESIDENT 215,800 215,800 143,790.36 33,239.07 72,009.64 66.6°% L2100 06623 SUMMER MEMBERSHIPS 23,775 23,775 .00 .00 23,775.00 .0% L2100 06625 BUSINESS MEMBERSHIPS 3,800 3,800 1,643.87 .00 2,156.13 43.3°% L2100 06683 SOCIAL - JUNIOR 6,300 6,300 6,300.00 1,200.00 .00 100.0°% L2100 07100 WALKING FEE 46,984 46,984 7,539.87 4,939.19 39,444.13 16.0°% L2100 08310 TOURNAMENT PROCEEDS 3,200 3,200 904.35 - 107.15 2,295.65 28.3°% TOTAL REVENUES 2,359,290 2,359,290 643,946.28 221,640.27 1,715,343.72 L2246 GOLF SHOP REVENUES L2246 02301 GOLF SHOP - SALES 180,000 180,000 20,360.51 10,682.43 159,639.49 11.3°% L2246 02302 BAG ROOM 13,000 13,000 10,320.00 3,600.00 2,680.00 79.4°% L2246 02303 LESSONS 130,000 130,000 9,950.00 4,140.00 120,050.00 7.7% L2246 02304 GOLF BALL RETRIEVAL 3,000 3,000 .00 .00 3,000.00 .0% L2246 02307 GOLF GRIP SALES 1,800 1,800 311.13 311.13 1,488.87 17.3°% L2246 02310 RENTAL -GOLF CLUBS 40,000 40,000 6,076.92 3,913.60 33,923.08 15.2°% TOTAL REVENUES 367,800 367,800 47,018.56 22,647.16 320,781.44 L3100 INTEREST EARNINGS L3100 08204 INTEREST EARNED - TD B 10,000 10,000 .00 .00 10,000.00 .0% TOTAL REVENUES 10,000 10,000 .00 .00 10,000.00 L3200 DRIVING RANGE INCOME L3200 07200 LEASE - GOLF 14,322 14,322 .00 .00 14,322.00 .0% L3200 07500 DRIVING RANGE PROCEEDS 301,598 301,598 42,278.62 25,147.41 259,319.38 14.0°% TOTAL REVENUES 315,920 315,920 42,278.62 25,147.41 273,641.38 L3253 RESTAURANT INCOME L3253 08100 FOOD & BEVERAGE LEASE 0 0 9,180.00 6,180.00 - 9,180.00 100.0% 12/12/2016 16:19 sjanjua FOR 2017 02 V-99-4. munis- a VILLAGE OF NORTH PALM BEACH P 2 YEAR -TO -DATE BUDGET REPORT glytdbud NOVEMBER 30, 2016 *PRELIMINARY* ORIGINAL REVISED ACTUAL YTD ACTUAL MTD ESTIM REV EST REV REVENUE REVENUE REMAINING PCT REVENUE COLL L3253 08110 FOOD & BEVERAGE SALES 238,050 238,050 .00 .00 238,050.00 .0% L3253 08111 BEVERAGE CART SALES 19,435 19,435 .00 .00 19,435.00 .0% L3253 08112 LIQUOR SALES - BVG CAR 18,055 18,055 .00 .00 18,055.00 .0% L3253 08113 NON - ALCOHOLIC BEVERAGE 39,215 39,215 .00 .00 39,215.00 .0% L3253 08120 LIQUOR SALES - F & B 253,690 253,690 .00 .00 253,690.00 .0% L3253 08130 FACILITY - RENTAL 30,000 30,000 .00 .00 30,000.00 .0% L3253 08135 BANQUETS 140,000 140,000 .00 .00 140,000.00 .0% L3253 08999 MISC. REVENUES 0 0 7,000.00 5,000.00 - 7,000.00 100.0°% TOTAL REVENUES 738,445 738,445 16,180.00 11,180.00 722,265.00 L3700 OTHER MISC. REVENUES L3700 08440 CHARGE CARD FEE REVENU 6,000 6,000 2,294.87 740.69 3,705.13 38.2°% L3700 08920 DISCOUNTS EARNED 0 0 60.00 30.00 -60.00 100.0°% L3700 08945 CARD FEE - RESIDENCY 0 0 1,020.00 330.00 - 1,020.00 100.0°% L3700 08980 COMMISSIONS - VENDING MA 0 0 82.23 .00 -82.23 100.0°% L3700 08999 MISC. REVENUES 0 0 -2.35 -1.34 2.35 100.0°% TOTAL REVENUES 6,000 6,000 3,454.75 1,099.35 2,545.25 L4600 APPROP. FUND BALANCE L4600 09100 APPROP. RETAINED EARNI 45,400 45,400 .00 .00 45,400.00 .0% TOTAL REVENUES 45,400 45,400 .00 .00 45,400.00 GRAND TOTAL 3,842,855 3,842,855 752,878.21 281,714.19 3,089,976.79 19.6% ** END OF REPORT - Generated by samia janjua ** 12/12/2016 16:20 VILLAGE OF NORTH PALM BEACH P 1 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud NOVEMBER 30, 2016 *PRELIMINARY* FOR 2017 02 ORIGINAL REVISED AVAILABLE PCT APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8045 GOLF COURSE MAINT. EXP. L8045 33491 CONTRACTUAL SERVICES 1,067,719 1,067,719 177,953.18 88,976.59 889,765.78 .04 100.0°% L8045 34310 ELECTRICITY 31,149 31,149 4,647.63 2,578.40 .00 26,501.37 14.9°% L8045 34320 WATER & SEWER 26,794 26,794 2,310.14 131.52 .00 24,483.86 8.6°% L8045 34620 R & M BLDG & GROUNDS 2,000 2,000 .00 .00 .00 2,000.00 .0°% L8045 34640 R & M IRRIGATION SYS. 500 500 .00 .00 .00 500.00 .0°% L8045 34683 R & M GOLF COURSE 5,000 5,000 .00 .00 .00 5,000.00 .0°% L8045 35222 TREES & SOD 5,000 5,000 .00 .00 .00 5,000.00 .0°% L8046 12110 TOTAL EXPENSES 1,138,162 1,138,162 184,910.95 91,686.51 889,765.78 63,485.27 12.4°% L8046 GOLF SHOP EXPENSES L8046 11110 EXECUTIVE SALARIES 61,010 61,010 12,023.73 7,663.83 .00 48,986.27 19.7°% L8046 11210 REGULAR PAY 95,069 95,069 14,202.99 6,979.75 .00 80,866.01 14.9°% L8046 11300 PART -TIME PAY 324,800 324,800 36,366.00 19,508.99 .00 288,434.00 11.2°% L8046 11400 OVERTIME PAY 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8046 11501 AUTO ALLOWANCE 4,800 4,800 738.48 369.24 .00 4,061.52 15.4°% L8046 11504 TELEPHONE ALLOWANCE 720 720 110.76 55.38 .00 609.24 15.4°% L8046 11506 COMMISSIONS - LESSONS 60,000 60,000 4,780.15 3,170.15 .00 55,219.85 8.0°% L8046 12110 F I C A 41,876 41,876 5,207.32 2,881.84 .00 36,668.68 12.4°% L8046 12210 PENSION -GEN'L EMPLOYEE 5,135 5,135 .00 .00 .00 5,135.00 .0°% L8046 12216 ICMA GENERAL EMPLOYEES 15,140 15,140 2,464.04 1,897.15 .00 12,675.96 16.3°% L8046 12217 ICMA MUNICIPAL EMPLOYE 3,966 3,966 598.76 299.38 .00 3,367.24 15.1°% L8046 12225 ICMA -457 MATCH 2,880 2,880 110.80 55.40 .00 2,769.20 3.8°% L8046 12310 HEALTH INSURANCE 28,986 28,986 4,830.96 2,415.48 .00 24,155.04 16.7°% L8046 12320 LIFE INSURANCE 348 348 65.25 29.00 .00 282.75 18.8°% L8046 12330 L.T.D. INSURANCE 695 695 122.49 56.00 .00 572.51 17.6°% L8046 12410 WORKERS' COMPENSATION 7,703 7,703 1,103.92 601.65 .00 6,599.08 14.3°% L8046 33190 PROFESSIONAL SERVICES 100 100 .00 .00 .00 100.00 .0°% L8046 33230 CHARGE CARD FEE 69,072 69,072 9,692.00 4,866.41 .00 59,380.00 14.0°% L8046 33491 CONTRACTUAL SERVICES 149,710 149,710 27,266.74 14,843.33 120,583.20 1,860.06 98.8°% L8046 34010 TRAVEL & LODGING 1,200 1,200 .00 .00 .00 1,200.00 .0°% L8046 34110 TELEPHONE 2,268 2,268 366.96 183.48 .00 1,901.04 16.2°% L8046 34310 ELECTRICITY 31,244 31,244 4,533.86 2,297.18 .00 26,710.14 14.5°% L8046 34320 WATER & SEWER 1,229 1,229 98.88 49.44 .00 1,130.12 8.0°% L8046 34620 R & M BLDG & GROUNDS 500 500 .00 .00 .00 500.00 .0°% L8046 34650 R & M MACH. & EOUIP. 2,500 2,500 .00 .00 .00 2,500.00 .0°% L8046 34710 PRINTING & BINDING 1,250 1,250 .00 .00 .00 1,250.00 .0°% L8046 34812 CLUB RELATIONS 3,500 3,500 209.75 145.96 .00 3,290.25 6.0°% L8046 34910 ADVERTISING 25,000 25,000 882.59 882.59 .00 24,117.41 3.5°% 12/12/2016 16:20 VILLAGE OF NORTH PALM BEACH P 2 sjanjua YEAR -TO -DATE BUDGET REPORT glytdbud NOVEMBER 30, 2016 *PRELIMINARY* FOR 2017 02 ORIGINAL REVISED AVAILABLE PCT L8046 GOLF SHOP EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8046 34960 TROPHIES, AWARDS & PRI 3,500 3,500 153.00 72.00 .00 3,347.00 4.4°% L8046 35110 OFFICE SUPPLIES 2,500 2,500 274.17 271.47 .00 2,225.83 11.0°% L8046 35111 COMPUTER SUPPLIES 3,000 3,000 .00 .00 .00 3,000.00 .0°% L8046 35120 GOLF SUPPLIES 33,000 33,000 11,636.36 482.99 .00 21,363.64 35.3°% L8046 35213 SHOP TOOLS & SUPPLIES 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8046 35214 BUILDING MAINT. SUPPLI 500 500 .00 .00 .00 500.00 .0°% L8046 35215 FURNITURE /FIXTURE SUPP 1,500 1,500 .00 .00 .00 1,500.00 .0°% L8046 35217 MACH. & EQUIP. SUPPLIE 5,000 5,000 .00 .00 .00 5,000.00 .0°% L8046 35270 CUSTODIAL SUPPLIES 100 100 8.72 .00 .00 91.28 8.7°% L8046 35294 UNIFORMS & SHOES 4,500 4,500 252.79 187.32 .00 4,247.21 5.6°% L8046 35410 BOOKS, PUBLS., & SUBSC 100 100 .00 .00 .00 100.00 .0°% L8046 35420 MEMBERSHIP & DUES 3,200 3,200 .00 .00 .00 3,200.00 .0°% L8046 35430 CONFERENCE & SEMINARS 2,900 2,900 .00 .00 .00 2,900.00 .0°% L8046 35530 GOLF MERCHANDISE 117,000 117,000 10,167.07 2,089.96 .00 106,832.93 8.7°% L8046 35532 GOLF LESSONS EXPENSE 32,000 32,000 2,431.20 - 184.20 .00 29,568.80 7.6°% L8046 35533 SPECIAL EVENTS /CAMPS 1,500 1,500 35.86 .00 .00 1,464.14 2.4°% L8046 35534 GOLF CLUB RENTAL EXPEN 7,500 7,500 .00 .00 .00 7,500.00 .0°% L8046 35550 GOLF HANDICAP EXPENSES 3,600 3,600 .00 .00 3,300.00 300.00 91.7°% L8053 34620 TOTAL EXPENSES 1,164,101 1,164,101 150,735.60 72,171.17 123,883.20 889,482.20 10.3°% L8053 FOOD & BEVERAGE EXPENSES L8053 11210 REGULAR PAY 139,311 139,311 26,000.00 .00 .00 113,311.00 18.7°% L8053 11300 PART -TIME PAY 269,235 269,235 3,119.41 .00 .00 266,115.59 1.2°% L8053 11400 OVERTIME PAY 1,000 1,000 51.11 .00 .00 948.89 5.1°% L8053 12110 F I C A 31,331 31,331 2,294.00 .00 .00 29,037.00 7.3°% L8053 12216 ICMA GENERAL EMPLOYEES 20,897 20,897 .00 .00 .00 20,897.00 .0°% L8053 12225 ICMA -457 MATCH 2,160 2,160 65.40 .00 .00 2,094.60 3.0°% L8053 12310 HEALTH INSURANCE 26,848 26,848 10.00 .00 .00 26,838.00 .0°% L8053 12320 LIFE INSURANCE 261 261 .00 .00 .00 261.00 .0°% L8053 12330 L.T.D. INSURANCE 600 600 .00 .00 .00 600.00 .0°% L8053 12410 WORKERS' COMPENSATION 7,111 7,111 152.79 .00 .00 6,958.21 2.1°% L8053 33230 CHARGE CARD FEE 10,500 10,500 40.23 8.04 .00 10,459.77 .4°% L8053 33411 LINEN RENTAL 9,000 9,000 .00 .00 .00 9,000.00 .0°% L8053 33434 ENTERTAINMENT & ETC. 7,000 7,000 408.57 204.29 .00 6,591.43 5.8°% L8053 33491 CONTRACTUAL SERVICES 23,000 23,000 85.26 .00 .00 22,914.74 .4°% L8053 34310 ELECTRICITY 23,188 23,188 3,526.88 1,542.02 .00 19,661.12 15.2°% L8053 34320 WATER & SEWER 15,836 15,836 2,215.51 1,106.35 .00 13,620.49 14.0°% L8053 34330 GAS 8,693 8,693 1,724.30 878.32 .00 6,968.70 19.8°% L8053 34420 RENTAL - EQUIPMENT 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8053 34620 R & M BLDG & GROUNDS 4,500 4,500 462.50 462.50 .00 4,037.50 10.3°% L8053 34622 R & M CARPET /TILE 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8053 34650 R & M MACH. & EQUIP. 4,500 4,500 .00 .00 .00 4,500.00 .0°% 12/12/2016 16:20 sjanjua FOR 2017 02 VILLAGE OF NORTH PALM BEACH P 3 YEAR -TO -DATE BUDGET REPORT glytdbud NOVEMBER 30, 2016 *PRELIMINARY* ORIGINAL REVISED AVAILABLE PCT L8053 FOOD & BEVERAGE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED L8053 34655 R & M BURGLAR /FIRE AL 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8053 34910 ADVERTISING 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8053 34940 LICENSES & FEES 6,600 6,600 294.00 .00 .00 6,306.00 4.5°% L8053 35110 OFFICE SUPPLIES 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8053 35111 COMPUTER SUPPLIES 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8053 35130 PAPER GOODS & SUPPLIES 6,500 6,500 .00 .00 .00 6,500.00 .0°% L8053 35131 KITCHEN SUPPLIES 3,000 3,000 .00 .00 .00 3,000.00 .0°% L8053 35135 CHINA, GLASS, SILVERWA 1,500 1,500 .00 .00 .00 1,500.00 .0°% L8053 35214 BUILDING MAINT. SUPPLI 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8053 35240 MEDICAL & SAFETY SUPPL 600 600 .00 .00 .00 600.00 .0°% L8053 35243 FURNITURE, FIXTURES & 5,000 5,000 .00 .00 .00 5,000.00 .0°% L8053 35250 AMBIENCE 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8053 35270 CUSTODIAL SUPPLIES 1,500 1,500 .00 .00 .00 1,500.00 .0°% L8053 35280 GAS, OIL & LUBRICANTS 500 500 .00 .00 .00 500.00 .0°% L8053 35290 MISC. OPERATING EXPENS 500 500 .00 .00 .00 500.00 .0°% L8053 35294 UNIFORMS & SHOES 1,000 1,000 .00 .00 .00 1,000.00 .0°% L8053 35298 FLOWER EXPENSE 500 500 .00 .00 .00 500.00 .0°% L8053 35440 TRAINING & ED. COURSES 600 600 .00 .00 .00 600.00 .0°% L8053 35510 MERCHANDISE - F &B 175,000 175,000 .00 .00 .00 175,000.00 .0°% L8053 35520 MERCHANDISE - LIQUOR 72,000 72,000 .00 .00 .00 72,000.00 .0°% TOTAL EXPENSES 887,771 887,771 40,449.96 4,201.52 .00 847,321.04 L8056 ADMINISTRATIVE EXPENSES L8056 11210 REGULAR PAY 37,096 37,096 5,680.19 2,840.09 .00 31,415.81 15.3°% L8056 11400 OVERTIME PAY 1,000 1,000 312.85 199.69 .00 687.15 31.3°% L8056 12110 F I C A 2,915 2,915 418.70 212.66 .00 2,496.30 14.4°% L8056 12216 ICMA GENERAL EMPLOYEES 5,565 5,565 535.28 426.02 .00 5,029.72 9.6°% L8056 12225 ICMA -457 MATCH 720 720 110.80 55.40 .00 609.20 15.4°% L8056 12310 HEALTH INSURANCE 17,812 17,812 2,973.64 1,484.32 .00 14,838.36 16.7°% L8056 12320 LIFE INSURANCE 87 87 14.50 7.25 .00 72.50 16.7°% L8056 12330 L.T.D. INSURANCE 160 160 26.46 13.23 .00 133.54 16.5°% L8056 12410 WORKERS' COMPENSATION 69 69 10.80 5.48 .00 58.20 15.7°% L8056 33210 ACCOUNTING & AUDITING 7,000 7,000 1,460.00 500.00 .00 5,540.00 20.9°% L8056 33491 CONTRACTUAL SERVICES 4,545 4,545 .00 .00 .00 4,545.00 .0°% L8056 34110 TELEPHONE 2,292 2,292 370.80 185.40 .00 1,921.20 16.2°% L8056 34210 POSTAGE 2,000 2,000 246.11 101.51 .00 1,753.89 12.3°% L8056 34422 RENTAL - COPIER 6,250 6,250 510.28 270.38 .00 5,739.72 8.2°% L8056 34710 PRINTING & BINDING 2,000 2,000 36.96 .00 .00 1,963.04 1.8°% L8056 35110 OFFICE SUPPLIES 3,300 3,300 370.20 70.20 .00 2,929.80 11.2°% L8056 35111 COMPUTER SUPPLIES 1,500 1,500 .00 .00 .00 1,500.00 .0°% TOTAL EXPENSES 94,311 94,311 13,077.57 6,371.63 .00 81,233.43 L8059 CLUBHOUSE GROUNDS EXPENSE L8059 33440 EXTERMINATING 3,505 3,505 417.24 208.62 1,043.10 2,044.66 41.7°% 12/12/2016 16:20 sjanjua FOR 2017 02 VILLAGE OF NORTH PALM BEACH P 4 YEAR -TO -DATE BUDGET REPORT glytdbud NOVEMBER 30, 2016 *PRELIMINARY* L8059 CLUBHOUSE GROUNDS EXPENSE ORIGINAL APPROP REVISED BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES AVAILABLE BUDGET PCT USED L8059 33491 CONTRACTUAL SERVICES 10,000 10,000 1,400.00 700.00 .00 8,600.00 14.0°% L8059 34110 TELEPHONE 3,051 3,051 435.47 217.73 .00 2,615.53 14.3°% L8059 34310 ELECTRICITY 15,459 15,459 2,351.26 1,028.02 .00 13,107.74 15.2°% L8059 34320 WATER & SEWER 38,489 38,489 5,421.29 2,707.36 .00 33,067.71 14.1°% L8059 34330 GAS 470 470 85.49 58.66 .00 384.51 18.2°% L8059 34620 R & M BLDG & GROUNDS 15,000 15,000 .00 .00 .00 15,000.00 .0°% L8059 34640 R & M IRRIGATION SYS. 500 500 .00 .00 .00 500.00 .0°% L8059 34650 R & M MACH. & EQUIP. 1,500 1,500 .00 .00 .00 1,500.00 .0°% L8059 34655 R & M BURGLAR /FIRE AL 3,615 3,615 109.50 109.50 .00 3,505.50 3.0°% L8059 34657 R & M PLUMB.,HEAT. & 3,000 3,000 .00 .00 .00 3,000.00 .0°% L8059 35213 SHOP TOOLS & SUPPLIES 150 150 .00 .00 .00 150.00 .0°% L8059 35214 BUILDING MAINT. SUPPLI 250 250 .00 .00 .00 250.00 .0°% L8059 35216 IRRIGATION SUPPLIES 200 200 .00 .00 .00 200.00 .0°% L8059 35243 FURNITURE, FIXTURES & 500 500 .00 .00 .00 500.00 .0°% L8059 35270 CUSTODIAL SUPPLIES 200 200 .00 .00 .00 200.00 .0°% L8059 66490 MACHINERY & EQUIPMENT 7,000 7,000 .00 .00 .00 7,000.00 .0°% TOTAL EXPENSES 102,889 102,889 10,220.25 5,029.89 1,043.10 91,625.65 L8062 INSURANCE EXPENSES L8062 34530 INSURANCE- COMP.GEN'L L 47,470 47,470 7,911.48 3,955.74 .00 39,558.52 16.7°% TOTAL EXPENSES 47,470 47,470 7,911.48 3,955.74 .00 39,558.52 L8070 RESERVES EXPENSES L8070 33112 SPECIAL LEGAL SERVICES 10,000 10,000 721.50 390.00 .00 9,278.50 7.2°% TOTAL EXPENSES 10,000 10,000 721.50 390.00 .00 9,278.50 L8565 DEBT SERVICE EXPENSES L8565 49170 DEBT PMT -BOA 4.893M 398,151 398,151 .00 .00 .00 398,151.00 .0°% TOTAL EXPENSES 398,151 398,151 .00 .00 .00 398,151.00 GRAND TOTAL 3,842,855 3,842,855 408,027.31 183,806.46 1,014,692.08 2,420,135.61 37.0°% ** END OF REPORT - Generated by samia janjua **