Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
JAN 2018 CC Preliminary Line Item Detail_as of 2-12-18
02/12/2018 13:22 |VILLAGE OF NORTH PALM BEACH |P 1 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud JANUARY 31, 2018 * PRELIMINARY * FOR 2018 04 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 655,902 655,902 313,263.16 116,776.24 342,638.84 47.8%* L2100 05232 GOLF CART RENTAL 543,599 543,599 263,809.64 72,690.29 279,789.36 48.5%* L2100 05234 LOCKER RENTALS 0 0 761.30 262.22 -761.30 100.0%* L2100 05235 GOLF HANDICAP SERVICE 2,300 2,300 1,575.00 425.00 725.00 68.5%* L2100 06621 CLUB-RESIDENT 287,150 287,150 281,063.28 27,886.11 6,086.72 97.9%* L2100 06622 CLUB-NON RESIDENT 202,050 202,050 176,821.32 33,480.48 25,228.68 87.5%* 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,200.00 .00 3,360.00 55.6%* L2100 07100 WALKING FEE 37,630 37,630 17,786.18 6,077.70 19,843.82 47.3%* L2100 08310 TOURNAMENT PROCEEDS 3,000 3,000 2,480.80 1,139.90 519.20 82.7%* TOTAL REVENUES 1,742,611 1,742,611 1,065,263.68 258,737.94 677,347.32 L2246 GOLF SHOP REVENUES _________________________________________ L2246 02301 GOLF SHOP - SALES 100,000 100,000 39,590.48 9,436.88 60,409.52 39.6%* L2246 02302 BAG ROOM 0 0 6,670.00 1,455.00 -6,670.00 100.0%* L2246 02303 LESSONS 100,000 100,000 29,790.00 4,990.00 70,210.00 29.8%* L2246 02304 GOLF BALL RETRIEVAL 3,000 3,000 .00 .00 3,000.00 .0%* L2246 02307 GOLF GRIP SALES 1,500 1,500 984.17 329.40 515.83 65.6%* L2246 02310 RENTAL-GOLF CLUBS 35,000 35,000 15,090.20 4,056.94 19,909.80 43.1%* TOTAL REVENUES 239,500 239,500 92,124.85 20,268.22 147,375.15 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,752 14,752 4,650.00 .00 10,102.00 31.5%* L3200 07500 DRIVING RANGE PROCEEDS 223,772 223,772 100,080.66 32,391.89 123,691.34 44.7%* TOTAL REVENUES 238,524 238,524 104,730.66 32,391.89 133,793.34 L3700 OTHER MISC. REVENUES _________________________________________ L3700 08440 CHARGE CARD FEE REVENU 6,000 6,000 3,901.44 690.51 2,098.56 65.0%* 02/12/2018 13:22 |VILLAGE OF NORTH PALM BEACH |P 2 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud JANUARY 31, 2018 * PRELIMINARY * FOR 2018 04 ORIGINAL REVISED ACTUAL YTD ACTUAL MTD REMAINING PCT ESTIM REV EST REV REVENUE REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ L3700 08920 DISCOUNTS EARNED 0 0 120.00 30.00 -120.00 100.0%* L3700 08945 CARD FEE - RESIDENCY 0 0 1,350.00 270.00 -1,350.00 100.0%* L3700 08981 ICMA FORFEITURE REV 0 0 155.30 155.30 -155.30 100.0%* L3700 08995 DONATIONS-PAVER BRICKS 0 0 93.46 .00 -93.46 100.0%* L3700 08999 MISC. REVENUES 0 0 -168.95 -63.90 168.95 100.0% TOTAL REVENUES 6,000 6,000 5,451.25 1,081.91 548.75 L4600 APPROP. FUND BALANCE _________________________________________ L4600 09100 APPROP. RETAINED EARNI 425,770 425,770 .00 .00 425,770.00 .0%* TOTAL REVENUES 425,770 425,770 .00 .00 425,770.00 GRAND TOTAL 2,662,405 2,662,405 1,267,570.44 312,479.96 1,394,834.56 47.6% ** END OF REPORT - Generated by samia janjua ** 02/12/2018 13:23 |VILLAGE OF NORTH PALM BEACH |P 1 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud JANUARY 31, 2018 * PRELIMINARY * FOR 2018 04 ORIGINAL REVISED AVAILABLE PCT APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ L8045 GOLF COURSE MAINT. EXP. _________________________________________ L8045 33491 CONTRACTUAL SERVICES 1,077,719 1,077,719 355,906.36 88,976.59 711,812.60 10,000.04 99.1% L8045 34310 ELECTRICITY 30,426 30,426 9,429.22 2,561.06 .00 20,996.78 31.0% L8045 34320 WATER & SEWER 29,177 29,177 6,552.01 2,193.87 .00 22,624.99 22.5% 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 66490 MACHINERY & EQUIPMENT 12,000 12,000 .00 .00 .00 12,000.00 .0% TOTAL EXPENSES 1,161,822 1,161,822 371,887.59 93,731.52 711,812.60 78,121.81 L8046 GOLF SHOP EXPENSES _________________________________________ L8046 11110 EXECUTIVE SALARIES 78,945 78,945 26,680.40 6,072.68 .00 52,264.60 33.8% L8046 11210 REGULAR PAY 83,307 83,307 33,256.35 7,317.40 .00 50,050.65 39.9% L8046 11300 PART-TIME PAY 193,237 193,237 98,065.11 22,810.21 .00 95,171.89 50.7% L8046 11400 OVERTIME PAY 1,000 1,000 125.15 75.09 .00 874.85 12.5% L8046 11501 AUTO ALLOWANCE 4,800 4,800 1,661.58 369.24 .00 3,138.42 34.6% L8046 11504 TELEPHONE ALLOWANCE 720 720 249.21 55.38 .00 470.79 34.6% L8046 11506 COMMISSIONS - LESSONS 55,000 55,000 21,329.50 3,416.30 .00 33,670.50 38.8% L8046 12110 F I C A 31,902 31,902 13,733.27 3,037.33 .00 18,168.73 43.0% L8046 12216 ICMA GENERAL EMPLOYEES 21,052 21,052 7,592.05 1,697.90 .00 13,459.95 36.1% L8046 12217 ICMA MUNICIPAL EMPLOYE 4,114 4,114 1,397.70 310.60 .00 2,716.30 34.0% L8046 12225 ICMA-457 MATCH 2,880 2,880 498.40 110.80 .00 2,381.60 17.3% L8046 12310 HEALTH INSURANCE 29,040 29,040 8,247.06 1,832.68 .00 20,792.94 28.4% L8046 12312 HEALTH SAVING ACCOUNT 0 0 4,500.00 .00 .00 -4,500.00 100.0%* L8046 12320 LIFE INSURANCE 348 348 116.00 29.00 .00 232.00 33.3% L8046 12330 L.T.D. INSURANCE 722 722 249.52 62.38 .00 472.48 34.6% L8046 12410 WORKERS' COMPENSATION 7,256 7,256 3,155.81 698.01 .00 4,100.19 43.5% L8046 33190 PROFESSIONAL SERVICES 200 200 .00 .00 .00 200.00 .0% L8046 33230 CHARGE CARD FEE 45,000 45,000 20,996.32 7,246.70 .00 24,003.68 46.7% L8046 33491 CONTRACTUAL SERVICES 198,545 198,545 48,230.81 20,859.14 108,284.88 42,029.31 78.8% L8046 34010 TRAVEL & LODGING 1,200 1,200 .00 .00 .00 1,200.00 .0% L8046 34110 TELEPHONE 9,582 9,582 718.44 .00 .00 8,863.56 7.5% L8046 34310 ELECTRICITY 8,400 8,400 9,525.33 2,792.80 .00 -1,125.33 113.4%* L8046 34320 WATER & SEWER 4,512 4,512 201.72 50.43 .00 4,310.28 4.5% 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 66.13 41.22 .00 3,433.87 1.9% L8046 34710 PRINTING & BINDING 3,250 3,250 125.28 69.50 .00 3,124.72 3.9% L8046 34812 CLUB RELATIONS 8,000 8,000 3,221.85 2,769.00 .00 4,778.15 40.3% 02/12/2018 13:23 |VILLAGE OF NORTH PALM BEACH |P 2 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud JANUARY 31, 2018 * PRELIMINARY * FOR 2018 04 ORIGINAL REVISED AVAILABLE PCT L8046 GOLF SHOP EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ L8046 34910 ADVERTISING 25,000 25,000 6,280.30 847.00 .00 18,719.70 25.1% L8046 34960 TROPHIES, AWARDS & PRI 3,500 3,500 703.24 75.00 .00 2,796.76 20.1% L8046 35110 OFFICE SUPPLIES 6,300 6,300 3,166.72 959.70 .00 3,133.28 50.3% L8046 35111 COMPUTER SUPPLIES 2,000 2,000 256.96 .00 .00 1,743.04 12.8% L8046 35120 GOLF SUPPLIES 0 0 5,107.70 364.71 .00 -5,107.70 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 390.69 .00 .00 -90.69 130.2%* L8046 35293 REFRESHMENTS & SUPPLIE 1,000 1,000 176.70 .00 .00 823.30 17.7% L8046 35294 UNIFORMS & SHOES 4,000 4,000 637.34 .00 .00 3,362.66 15.9% L8046 35420 MEMBERSHIP & DUES 3,200 3,200 260.00 .00 .00 2,940.00 8.1% L8046 35430 CONFERENCE & SEMINARS 2,900 2,900 385.00 .00 .00 2,515.00 13.3% L8046 35530 GOLF MERCHANDISE 60,000 60,000 32,205.29 11,277.27 .00 27,794.71 53.7% L8046 35532 GOLF LESSONS EXPENSE 0 0 -364.00 112.00 .00 364.00 100.0% L8046 35533 SPECIAL EVENTS/CAMPS 1,500 1,500 .00 .00 .00 1,500.00 .0% L8046 35534 GOLF CLUB RENTAL EXPEN 5,600 5,600 29.90 29.90 .00 5,570.10 .5% L8046 35550 GOLF HANDICAP EXPENSES 4,200 4,200 138.00 .00 .00 4,062.00 3.3% L8046 66490 MACHINERY & EQUIPMENT 11,000 11,000 .00 .00 .00 11,000.00 .0% TOTAL EXPENSES 947,262 947,262 353,316.83 95,389.37 108,284.88 485,660.29 L8053 FOOD & BEVERAGE EXPENSES _________________________________________ L8053 12415 UNEMPLOYMENT COMPENSAT 0 0 1,128.56 .00 .00 -1,128.56 100.0%* L8053 33434 ENTERTAINMENT & ETC. 0 0 887.77 223.63 .00 -887.77 100.0%* L8053 34310 ELECTRICITY 8,800 8,800 7,233.82 1,431.62 .00 1,566.18 82.2% L8053 34320 WATER & SEWER 1,200 1,200 4,687.80 1,311.41 .00 -3,487.80 390.7%* L8053 34330 GAS 0 0 3,673.21 1,010.37 .00 -3,673.21 100.0%* L8053 34940 LICENSES & FEES 6,600 6,600 344.00 .00 .00 6,256.00 5.2% L8053 35290 MISC. OPERATING EXPENS 0 0 8,610.84 .00 .00 -8,610.84 100.0%* TOTAL EXPENSES 16,600 16,600 26,566.00 3,977.03 .00 -9,966.00 L8056 ADMINISTRATIVE EXPENSES _________________________________________ L8056 11210 REGULAR PAY 38,617 38,617 13,329.99 2,962.22 .00 25,287.01 34.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 947.43 210.54 .00 2,083.57 31.3% L8056 12216 ICMA GENERAL EMPLOYEES 5,793 5,793 1,999.53 444.34 .00 3,793.47 34.5% L8056 12225 ICMA-457 MATCH 720 720 249.10 55.40 .00 470.90 34.6% L8056 12310 HEALTH INSURANCE 17,333 17,333 5,319.90 1,182.20 .00 12,013.10 30.7% L8056 12312 HEALTH SAVING ACCOUNT 0 0 3,000.00 .00 .00 -3,000.00 100.0%* 02/12/2018 13:23 |VILLAGE OF NORTH PALM BEACH |P 3 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud JANUARY 31, 2018 * PRELIMINARY * FOR 2018 04 ORIGINAL REVISED AVAILABLE PCT L8056 ADMINISTRATIVE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ L8056 12320 LIFE INSURANCE 87 87 29.00 7.25 .00 58.00 33.3% L8056 12330 L.T.D. INSURANCE 167 167 55.20 13.80 .00 111.80 33.1% L8056 12410 WORKERS' COMPENSATION 690 690 231.93 51.54 .00 458.07 33.6% L8056 33160 DONATIONS EXP-PAVER BR 0 0 35.00 35.00 .00 -35.00 100.0%* L8056 33210 ACCOUNTING & AUDITING 7,000 7,000 2,200.00 .00 .00 4,800.00 31.4% L8056 34110 TELEPHONE 0 0 557.82 49.39 .00 -557.82 100.0%* L8056 34210 POSTAGE 2,000 2,000 .00 .00 .00 2,000.00 .0% L8056 34422 RENTAL-COPIER 3,200 3,200 1,091.98 230.44 2,297.58 -189.56 105.9%* L8056 35110 OFFICE SUPPLIES 0 0 308.43 .00 .00 -308.43 100.0%* L8056 35111 COMPUTER SUPPLIES 0 0 486.90 .00 .00 -486.90 100.0%* TOTAL EXPENSES 79,638 79,638 29,842.21 5,242.12 2,297.58 47,498.21 L8059 CLUBHOUSE GROUNDS EXPENSE _________________________________________ L8059 33440 EXTERMINATING 950 950 2,400.00 .00 .00 -1,450.00 252.6%* L8059 33491 CONTRACTUAL SERVICES 0 0 14,710.00 4,670.00 5,600.00 -20,310.00 100.0%* L8059 34110 TELEPHONE 0 0 785.22 188.81 .00 -785.22 100.0%* L8059 34310 ELECTRICITY 0 0 4,822.56 954.42 .00 -4,822.56 100.0%* L8059 34320 WATER & SEWER 0 0 11,880.67 3,274.68 .00 -11,880.67 100.0%* L8059 34330 GAS 0 0 271.45 75.02 .00 -271.45 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% TOTAL EXPENSES 4,886 4,886 36,720.40 9,162.93 5,600.00 -37,434.40 L8062 INSURANCE EXPENSES _________________________________________ L8062 34530 INSURANCE-COMP.GEN'L L 44,038 44,038 14,236.96 3,559.24 .00 29,801.04 32.3% TOTAL EXPENSES 44,038 44,038 14,236.96 3,559.24 .00 29,801.04 L8070 RESERVES EXPENSES _________________________________________ L8070 33112 SPECIAL LEGAL SERVICES 10,000 10,000 1,111.50 .00 .00 8,888.50 11.1% TOTAL EXPENSES 10,000 10,000 1,111.50 .00 .00 8,888.50 L8565 DEBT SERVICE EXPENSES _________________________________________ L8565 49170 DEBT PMT-BOA 4.893M 398,159 398,159 .00 .00 .00 398,159.00 .0% TOTAL EXPENSES 398,159 398,159 .00 .00 .00 398,159.00 GRAND TOTAL 2,662,405 2,662,405 833,681.49 211,062.21 827,995.06 1,000,728.45 62.4% ** END OF REPORT - Generated by samia janjua **