Loading...
CC LINE ITEM DETAIL_APR 2018VILLAGE OF NORTH PALM BEACH YEAR-TO-DATE BUDGET REPORT APRIL 30, 2018 "PRELIMINARY* FOR 2018 07 L2100 05231 GOLF GREENS FEES 655,902 655,902 689,327.63 55,600.24 -33,425.63 105.1%- L2100 05232 GOLF CART RENTAL 543,599 543,599 510,240.40 62,884.63 33,358.60 93.9%- L2100 05234 LOCKER RENTALS 0 0 761.30 .00 -761.30 100.0%* L2100 05235 GOLF HANDICAP SERVICE 2,300 2,300 2,175.00 50.00 125.00 94.6%* L2100 06621 CLUB -RESIDENT 287,150 287,150 302,843.68 .00 -15,693.68 105.5%* L2100 06622 CLUB -NON RESIDENT 202,050 202,050 185,787.41 1,406.85 16,262.59 92.0%- L2100 06623 SUMMER MEMBERSHIPS 0 0 -297.00 .00 297.00 100.0% L2100 06625 BUSINESS MEMBERSHIPS 3,420 3,420 3,800.00 .00 -380.00 111.1%* L2100 06683 SOCIAL -JUNIOR 7,560 7,560 4,500.00 .00 3,060.00 59.5%* L2100 07100 WALKING FEE 37,630 37,630 36,700.28 5,932.78 929.72 97.5%* L2100 08310 TOURNAMENT PROCEEDS 3,000 3,000 6,061.68 65.90 -3,061.68 202.1%- L2246 02301 GOLF SHOP - SALES 100,000 100,000 88,614.19 17,701.97 11,385.81 88.6%* L2246 02302 BAG ROOM 0 0 7,237.60 .00 -7,237.60 100.0%* L2246 02303 LESSONS 100,000 100,000 56,800.00 8,297.50 43,200.00 56.8%* L2246 02304 GOLF BALL RETRIEVAL 3,000 3,000 720.00 .00 2,280.00 24.0%- L2246 02307 GOLF GRIP SALES 1,500 1,500 1,236.17 36.00 263.83 82.4%* L2246 02310 RENTAL -GOLF CLUBS 35,000 35,000 34,342.92 5,928.60 657.08 98.1%* %TIIJlrljFfk%lW,.=�T L3100 08200 INTEREST EARNED - S B 0 0 731.95 169.44 -731.95 100.0%* L3100 08202 INTEREST EARNED - FEIT 0 0 1,641.30 208.03 -1,641.30 100.0%- L3100 08204 INTEREST EARNED - TO B 10,000 10,000 5,145.94 812.77 4,854.06 51.5%- L3200 07200 LEASE - GOLF 14,752 14,752 7,750.00 .00 7,002.00 52.5%* L3200 07500 DRIVING RANGE PROCEEDS 223,772 223,772 216,655.88 30,184.65 7,116.12 96.8%* lclrjllllrflll��� L3700 08440 CHARGE CARD FEE REVENU 6,000 6,000 4,018.51 .00 1,981.49 67.0%* L3700 08920 DISCOUNTS EARNED 0 0 210.00 30.00 -210.00 100.0%* Report generated: 07/18/2018 15:07 Page 1 User : s7anga Program ID: glytdbud VILLAGE OF NORTH PALM BEACH YEAR-TO-DATE BUDGET REPORT APRIL 30, 2018 "PRELIMINARY* FOR 2018 07 L3700 08945 CARD FEE - RESIDENCY 0 0 1,500.00 .00 -1,500.00 100.0%* L3700 08950 INSURANCE REFUNDS 0 0 5,107.63 .00 -5,107.63 100.0%- L3700 08981 ICMA FORFEITURE REV 0 0 398.38 .00 -398.38 100.0%* L3700 08990 OTHER SALES OF SURPLUS 0 0 2,448.58 2,448.58 -2,448.58 100.0%* L3700 08995 DONATIONS -PAVER BRICKS 0 0 93.46 .00 -93.46 100.0%* L3700 08999 MISC. REVENUES 0 0 -167.43 11.63 167.43 100.0% 00 • • • • L4100 09210 LOAN FROM GENERAL FUND 0 1,700,000 .00 .00 1,700,000.00 .0% L4600 09100 APPROP. RETAINED EARNI 425,770 425,770 .00 TOTAL COUNTRY CLUB 2,662,405 4,362,405 2,176,385.46 TOTAL REVENUES 2,662,405 4,362,405 2,176,385.46 Report generated: 07/18/2018 15:07 User: s7anga Program ID: glytdbud .00 191,769.57 191,769.57 425,770.00 .0%* 2,186,019.54 49.9% 2,186,019.54 Page 2 VILLAGE OF NORTH PALM BEACH YEAR-TO-DATE BUDGET REPORT APRIL 30, 2018 *PRELIMINARY* FOR 2018 07 L8045 33491 CONTRACTUAL SERVICES 1,077,719 1,077,719 622,836.13 88,976.59 444,882.83 10,000.04 99.1% L8045 34310 ELECTRICITY 30,426 30,426 17,817.02 2,521.36 .00 12,608.98 58.6% L8045 34320 WATER & SEWER 29,177 29,177 13,754.16 196.21 .00 15,422.84 47.1% 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 34910 ADVERTISING 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% L8045 66210 CONSTR. & MAJOR RENOVA 0 1,700,000 85,254.50 3,300.00 1,432,824.69 181,920.81 89.3% L8045 66490 MACHINERY & EQUIPMENT 12,000 12,000 .00 .00 .00 12,000.00 .0% e••� L8046 11110 EXECUTIVE SALARIES 78,945 78,945 44,898.44 6,072.68 .00 34,046.56 56.9% L8046 11210 REGULAR PAY 83,307 83,307 52,202.86 5,149.88 .00 31,104.14 62.7% L8046 11300 PART-TIME PAY 193,237 193,237 166,552.16 22,827.53 .00 26,684.84 86.2% L8046 11400 OVERTIME PAY 1,000 1,000 1,643.40 662.06 .00 -643.40 164.3%` L8046 11501 AUTO ALLOWANCE 4,800 4,800 2,769.30 369.24 .00 2,030.70 57.7% L8046 11504 TELEPHONE ALLOWANCE 720 720 415.35 55.38 .00 304.65 57.7% L8046 11506 COMMISSIONS - LESSONS 55,000 55,000 38,169.30 4,660.25 .00 16,830.70 69.4% L8046 12110 F I C A 31,902 31,902 23,234.97 3,019.04 .00 8,667.03 72.8% L8046 12216 ICMA GENERAL EMPLOYEES 21,052 21,052 12,184.34 1,348.62 .00 8,867.66 57.9% L8046 12217 ICMA MUNICIPAL EMPLOYE 4,114 4,114 2,380.08 334.76 .00 1,733.92 57.9% L8046 12225 ICMA-457 MATCH 2,880 2,880 747.70 55.40 .00 2,132.30 26.0% L8046 12310 HEALTH INSURANCE 29,040 29,040 12,148.30 1,379.04 .00 16,891.70 41.8% L8046 12312 HEALTH SAVING ACCOUNT 0 0 4,500.00 .00 .00 -4,500.00 100.0%* L8046 12320 LIFE INSURANCE 348 348 188.50 21.75 .00 159.50 54.2% L8046 12330 L.T.D. INSURANCE 722 722 414.48 51.18 .00 307.52 57.4% L8046 12410 WORKERS' COMPENSATION 7,256 7,256 5,227.76 692.46 .00 2,028.24 72.0% L8046 33190 PROFESSIONAL SERVICES 200 200 .00 .00 .00 200.00 .0% L8046 33230 CHARGE CARD FEE 45,000 45,000 41,800.07 5,036.32 .00 3,199.93 92.9% L8046 33491 CONTRACTUAL SERVICES 198,545 198,545 97,166.21 13,504.53 61,491.60 39,887.19 79.9% L8046 34010 TRAVEL & LODGING 1,200 1,200 1,064.96 .00 .00 135.04 88.7% L8046 34110 TELEPHONE 9,582 9,582 1,553.61 265.63 .00 8,028.39 16.2% L8046 34210 POSTAGE 0 0 28.97 .00 .00 -28.97 100.0% L8046 34310 ELECTRICITY 8,400 8,400 16,939.55 2,441.60 .00 -8,539.55 201.7%` L8046 34320 WATER & SEWER 4,512 4,512 596.21 120.83 .00 3,915.79 13.2% L8046 34620 R & M BLDG & GROUNDS 12,500 12,500 .00 .00 .00 12,500.00 .0% L8046 34650 R & M MACH. & EQUIP. 3,500 3,500 291.04 49.87 .00 3,208.96 8.3% L8046 34710 PRINTING & BINDING 3,250 3,250 295.86 .00 .00 2,954.14 9.1% Report generated: 07/18/2018 15:09 User: sjanjua Page Program ID: glytdbud VILLAGE OF NORTH PALM BEACH YEAR-TO-DATE BUDGET REPORT APRIL 30, 2018 PRELIMINARY* FOR 2018 07 L8046 34812 CLUB RELATIONS 8,000 8,000 8,240.07 2,378.97 .00 -240.07 103.0%* L8046 34910 ADVERTISING 25,000 25,000 10,240.53 2,480.52 .00 14,759.47 41.0% L8046 34960 TROPHIES, AWARDS & PRI 3,500 3,500 2,973.06 .00 .00 526.94 84.9% L8046 35110 OFFICE SUPPLIES 6,300 6,300 3,817.17 .00 .00 2,482.83 60.6% L8046 35111 COMPUTER SUPPLIES 2,000 2,000 766.34 59.99 .00 1,233.66 38.3% L8046 35120 GOLF SUPPLIES 0 0 8,772.16 2,277.86 .00 -8,772.16 100.0%- L8046 35213 SHOP TOOLS & SUPPLIES 1,000 1,000 .00 .00 .00 1,000.00 .0% L8046 35214 BUILDING MAINT. SUPPLI 750 750 .00 .00 .00 750.00 .0% L8046 35215 FURNITURE/FIXTURE SUPP 1,000 1,000 .00 .00 .00 1,000.00 .0% L8046 35217 MACH. & EQUIP. SUPPLIE 5,000 5,000 .00 .00 .00 5,000.00 .0% L8046 35270 CUSTODIAL SUPPLIES 300 300 575.99 169.32 .00 -275.99 192.0%* L8046 35293 REFRESHMENTS & SUPPLIE 1,000 1,000 473.32 125.67 .00 526.68 47.3% L8046 35294 UNIFORMS & SHOES 4,000 4,000 2,994.26 800.38 .00 1,005.74 74.9% L8046 35420 MEMBERSHIP & DUES 3,200 3,200 273.23 13.23 .00 2,926.77 8.5% L8046 35430 CONFERENCE & SEMINARS 2,900 2,900 400.00 .00 .00 2,500.00 13.8% L8046 35530 GOLF MERCHANDISE 60,000 60,000 56,508.11 6,979.28 .00 3,491.89 94.2% L8046 35532 GOLF LESSONS EXPENSE 0 0 1,704.50 1,148.00 .00 -1,704.50 100.0%* L8046 35533 SPECIAL EVENTS/CAMPS 1,500 1,500 232.01 .00 .00 1,267.99 15.5% L8046 35534 GOLF CLUB RENTAL EXPEN 5,600 5,600 152.84 .00 .00 5,447.16 2.7% L8046 35550 GOLF HANDICAP EXPENSES 4,200 4,200 3,648.00 .00 .00 552.00 86.9% L8046 66490 MACHINERY & EQUIPMENT 11,000 11,000 .00 .00 .00 11,000.00 .0% L8053 12415 UNEMPLOYMENT COMPENSAT 0 0 4,222.53 3,093.97 .00 -4,222.53 100.0%* L8053 33434 ENTERTAINMENT & ETC. 0 0 1,403.81 188.08 .00 -1,403.81 100.0%* L8053 34310 ELECTRICITY 8,800 8,800 10,744.14 1,189.85 .00 -1,944.14 122.1%* L8053 34320 WATER & SEWER 1,200 1,200 8,395.44 1,226.80 .00 -7,195.44 699.6%* L8053 34330 GAS 0 0 6,009.78 980.09 .00 -6,009.78 100.0%* L8053 34940 LICENSES & FEES 6,600 6,600 2,314.00 .00 .00 4,286.00 35.1% L8053 35290 MISC. OPERATING EXPENS 0 0 8,610.84 .00 .00 -8,610.84 100.0%* L8056 11210 REGULAR PAY 38,617 38,617 22,216.66 2,962.23 .00 16,400.34 57.5% L8056 11400 OVERTIME PAY 1,000 1,000 .00 .00 .00 1,000.00 .0% L8056 12110 F I C A 3,031 3,031 1,579.05 210.54 .00 1,451.95 52.1% L8056 12216 ICMA GENERAL EMPLOYEES 5,793 5,793 3,332.55 444.34 .00 2,460.45 57.5% L8056 12225 ICMA-457 MATCH 720 720 415.30 55.40 .00 304.70 57.7% L8056 12310 HEALTH INSURANCE 17,333 17,333 8,275.40 1,182.20 .00 9,057.60 47.7% L8056 12312 HEALTH SAVING ACCOUNT 0 0 3,000.00 .00 .00 -3,000.00 100.0%* L8056 12320 LIFE INSURANCE 87 87 50.75 7.25 .00 36.25 58.3% Report generated: 07/18/2018 15:09 Page User: s7anga Program ID: glytdbud VILLAGE OF NORTH PALM BEACH YEAR-TO-DATE BUDGET REPORT APRIL 30, 2018 PRELIMINARY* FOR 2018 07 L8056 12330 L.T.D. INSURANCE 167 167 96.60 13.80 .00 70.40 57.8% L8056 12410 WORKERS' COMPENSATION 690 690 380.32 51.54 .00 309.68 55.1% L8056 33160 DONATIONS EXP -PAVER BR 0 0 35.00 .00 .00 -35.00 100.0%* L8056 33210 ACCOUNTING & AUDITING 7,000 7,000 5,920.00 .00 .00 1,080.00 84.6% L8056 34110 TELEPHONE 0 0 1,123.68 187.34 .00 -1,123.68 100.0%* L8056 34210 POSTAGE 2,000 2,000 570.03 80.28 .00 1,429.97 28.5% L8056 34422 RENTAL -COPIER 3,200 3,200 1,794.47 217.12 1,595.09 -189.56 105.9%* L8056 35110 OFFICE SUPPLIES 0 0 308.43 .00 .00 -308.43 100.0%* L8056 35111 COMPUTER SUPPLIES 0 0 1,236.53 749.63 .00 -1,236.53 100.0%* L8059 33440 EXTERMINATING 950 950 4,800.00 800.00 .00 -3,850.00 505.3%* L8059 33491 CONTRACTUAL SERVICES 0 0 14,710.00 .00 5,600.00 -20,310.00 100.0%* L8059 34110 TELEPHONE 0 0 1,341.63 185.47 .00 -1,341.63 100.0%* L8059 34310 ELECTRICITY 0 0 7,162.76 793.22 .00 -7,162.76 100.0%* L8059 34320 WATER & SEWER 0 0 21,073.65 2,992.65 .00 -21,073.65 100.0%* L8059 34330 GAS 0 0 354.54 22.00 .00 -354.54 100.0%* L8059 34620 R & M BLDG & GROUNDS 0 0 1,850.50 .00 .00 -1,850.50 100.0%* L8059 34655 R & M BURGLAR/FIRE AL 936 936 .00 .00 .00 936.00 .0% L8059 34657 R & M PLUMB.,HEAT. & 3,000 3,000 .00 .00 .00 3,000.00 .0% :I. L8062 34530 INSURANCE-COMP.GEN'L L 44,038 44,038 24,914.68 3,559.24 .00 19,123.32 56.6% :1 1 L8070 33112 SPECIAL LEGAL SERVICES 10,000 10,000 3,061.50 195.00 .00 6,938.50 30.6% L8565 49170 DEBT PMT -BOA 4.893m 398,159 398,159 199,079.45 .00 .00 199,079.55 50.0% TOTAL COUNTRY CLUB 2,662,405 4,3629405 197399230.84 200,933.47 1,946,394.21 676,779.95 84.5% TOTAL EXPENSES 2,662,405 4,362,405 1,739,230.84 200,933.47 1,946,394.21 676,779.95 Report generated: 07/18/2018 15:09 Page 3 User: s7anga Program ID: glytdbud