Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
02-2018 CC PRELIMINARY LINE ITEM DETAIL_3-12-18
03/12/2018 17:13 |VILLAGE OF NORTH PALM BEACH |P 1 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud FEBRUARY 28, 2018 * PRELIMINARY* FOR 2018 05 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 468,617.37 155,354.21 187,284.63 71.4%* L2100 05232 GOLF CART RENTAL 543,599 543,599 353,075.91 89,266.27 190,523.09 65.0%* L2100 05234 LOCKER RENTALS 0 0 761.30 .00 -761.30 100.0%* L2100 05235 GOLF HANDICAP SERVICE 2,300 2,300 1,975.00 400.00 325.00 85.9%* L2100 06621 CLUB-RESIDENT 287,150 287,150 280,322.81 -740.47 6,827.19 97.6%* L2100 06622 CLUB-NON RESIDENT 202,050 202,050 179,526.66 2,705.34 22,523.34 88.9%* 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 23,773.82 5,987.64 13,856.18 63.2%* L2100 08310 TOURNAMENT PROCEEDS 3,000 3,000 5,456.83 2,976.03 -2,456.83 181.9%* TOTAL REVENUES 1,742,611 1,742,611 1,321,212.70 255,949.02 421,398.30 L2246 GOLF SHOP REVENUES _________________________________________ L2246 02301 GOLF SHOP - SALES 100,000 100,000 52,857.97 13,267.49 47,142.03 52.9%* L2246 02302 BAG ROOM 0 0 7,237.60 567.60 -7,237.60 100.0%* L2246 02303 LESSONS 100,000 100,000 44,372.50 14,582.50 55,627.50 44.4%* 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 .00 515.83 65.6%* L2246 02310 RENTAL-GOLF CLUBS 35,000 35,000 19,773.24 4,683.04 15,226.76 56.5%* TOTAL REVENUES 239,500 239,500 125,225.48 33,100.63 114,274.52 L3100 INTEREST EARNINGS _________________________________________ L3100 08204 INTEREST EARNED - TD B 10,000 10,000 2,466.73 .00 7,533.27 24.7%* TOTAL REVENUES 10,000 10,000 2,466.73 .00 7,533.27 L3200 DRIVING RANGE INCOME _________________________________________ L3200 07200 LEASE - GOLF 14,752 14,752 7,750.00 1,550.00 7,002.00 52.5%* L3200 07500 DRIVING RANGE PROCEEDS 223,772 223,772 142,214.86 42,134.20 81,557.14 63.6%* TOTAL REVENUES 238,524 238,524 149,964.86 43,684.20 88,559.14 L3700 OTHER MISC. REVENUES _________________________________________ L3700 08440 CHARGE CARD FEE REVENU 6,000 6,000 3,901.44 .00 2,098.56 65.0%* 03/12/2018 17:13 |VILLAGE OF NORTH PALM BEACH |P 2 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud FEBRUARY 28, 2018 * PRELIMINARY* FOR 2018 05 ORIGINAL REVISED ACTUAL YTD ACTUAL MTD REMAINING PCT ESTIM REV EST REV REVENUE REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ L3700 08920 DISCOUNTS EARNED 0 0 150.00 30.00 -150.00 100.0%* L3700 08945 CARD FEE - RESIDENCY 0 0 1,470.00 120.00 -1,470.00 100.0%* L3700 08950 INSURANCE REFUNDS 0 0 5,107.63 5,107.63 -5,107.63 100.0%* L3700 08981 ICMA FORFEITURE REV 0 0 398.23 242.93 -398.23 100.0%* L3700 08995 DONATIONS-PAVER BRICKS 0 0 93.46 .00 -93.46 100.0%* L3700 08999 MISC. REVENUES 0 0 -172.97 -4.02 172.97 100.0% TOTAL REVENUES 6,000 6,000 10,947.79 5,496.54 -4,947.79 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,609,817.56 338,230.39 1,052,587.44 60.5% ** END OF REPORT - Generated by samia janjua ** 03/12/2018 17:13 |VILLAGE OF NORTH PALM BEACH |P 1 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud FEBRUARY 28, 2018 * PRELIMINARY* FOR 2018 05 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 444,882.95 88,976.59 622,836.01 10,000.04 99.1% L8045 34310 ELECTRICITY 30,426 30,426 12,224.48 2,795.26 .00 18,201.52 40.2% L8045 34320 WATER & SEWER 29,177 29,177 9,187.28 144.05 .00 19,989.72 31.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 466,294.71 91,915.90 622,836.01 72,691.28 L8046 GOLF SHOP EXPENSES _________________________________________ L8046 11110 EXECUTIVE SALARIES 78,945 78,945 32,753.08 6,072.68 .00 46,191.92 41.5% L8046 11210 REGULAR PAY 83,307 83,307 41,316.33 8,059.98 .00 41,990.67 49.6% L8046 11300 PART-TIME PAY 193,237 193,237 120,829.49 22,764.38 .00 72,407.51 62.5% L8046 11400 OVERTIME PAY 1,000 1,000 295.06 169.91 .00 704.94 29.5% L8046 11501 AUTO ALLOWANCE 4,800 4,800 2,030.82 369.24 .00 2,769.18 42.3% L8046 11504 TELEPHONE ALLOWANCE 720 720 304.59 55.38 .00 415.41 42.3% L8046 11506 COMMISSIONS - LESSONS 55,000 55,000 31,195.55 9,866.05 .00 23,804.45 56.7% L8046 12110 F I C A 31,902 31,902 17,324.55 3,591.28 .00 14,577.45 54.3% L8046 12216 ICMA GENERAL EMPLOYEES 21,052 21,052 9,390.47 1,798.42 .00 11,661.53 44.6% L8046 12217 ICMA MUNICIPAL EMPLOYE 4,114 4,114 1,719.18 321.48 .00 2,394.82 41.8% L8046 12225 ICMA-457 MATCH 2,880 2,880 609.20 110.80 .00 2,270.80 21.2% L8046 12310 HEALTH INSURANCE 29,040 29,040 10,079.74 1,832.68 .00 18,960.26 34.7% L8046 12312 HEALTH SAVING ACCOUNT 0 0 4,500.00 .00 .00 -4,500.00 100.0%* L8046 12320 LIFE INSURANCE 348 348 145.00 29.00 .00 203.00 41.7% L8046 12330 L.T.D. INSURANCE 722 722 312.41 62.89 .00 409.59 43.3% L8046 12410 WORKERS' COMPENSATION 7,256 7,256 3,976.63 820.82 .00 3,279.37 54.8% L8046 33190 PROFESSIONAL SERVICES 200 200 .00 .00 .00 200.00 .0% L8046 33230 CHARGE CARD FEE 45,000 45,000 28,090.60 7,094.28 .00 16,909.40 62.4% L8046 33491 CONTRACTUAL SERVICES 198,545 198,545 71,191.35 13,062.22 86,088.24 41,265.41 79.2% L8046 34010 TRAVEL & LODGING 1,200 1,200 1,641.18 1,227.78 .00 -441.18 136.8%* L8046 34110 TELEPHONE 9,582 9,582 909.62 191.18 .00 8,672.38 9.5% L8046 34210 POSTAGE 0 0 28.97 28.97 .00 -28.97 100.0%* L8046 34310 ELECTRICITY 8,400 8,400 12,036.45 2,511.12 .00 -3,636.45 143.3%* L8046 34320 WATER & SEWER 4,512 4,512 424.95 223.23 .00 4,087.05 9.4% 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 .00 .00 3,433.87 1.9% L8046 34710 PRINTING & BINDING 3,250 3,250 295.86 170.58 .00 2,954.14 9.1% 03/12/2018 17:13 |VILLAGE OF NORTH PALM BEACH |P 2 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud FEBRUARY 28, 2018 * PRELIMINARY* FOR 2018 05 ORIGINAL REVISED AVAILABLE PCT L8046 GOLF SHOP EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ L8046 34812 CLUB RELATIONS 8,000 8,000 5,196.91 1,921.57 .00 2,803.09 65.0% L8046 34910 ADVERTISING 25,000 25,000 7,690.01 70.00 .00 17,309.99 30.8% L8046 34960 TROPHIES, AWARDS & PRI 3,500 3,500 1,817.16 829.52 .00 1,682.84 51.9% L8046 35110 OFFICE SUPPLIES 6,300 6,300 3,584.92 289.55 .00 2,715.08 56.9% L8046 35111 COMPUTER SUPPLIES 2,000 2,000 706.35 449.39 .00 1,293.65 35.3% L8046 35120 GOLF SUPPLIES 0 0 6,239.30 1,104.50 .00 -6,239.30 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 406.67 .00 .00 -106.67 135.6%* L8046 35293 REFRESHMENTS & SUPPLIE 1,000 1,000 248.80 72.10 .00 751.20 24.9% L8046 35294 UNIFORMS & SHOES 4,000 4,000 2,193.88 5.50 .00 1,806.12 54.8% 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 400.00 .00 .00 2,500.00 13.8% L8046 35530 GOLF MERCHANDISE 60,000 60,000 37,145.38 4,649.16 .00 22,854.62 61.9% L8046 35532 GOLF LESSONS EXPENSE 0 0 -21.00 343.00 .00 21.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 152.84 122.94 .00 5,447.16 2.7% 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 457,626.43 90,291.58 86,088.24 403,547.33 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 1,027.65 139.88 .00 -1,027.65 100.0%* L8053 34310 ELECTRICITY 8,800 8,800 8,433.68 1,199.86 .00 366.32 95.8% L8053 34320 WATER & SEWER 1,200 1,200 5,964.79 1,276.99 .00 -4,764.79 497.1%* L8053 34330 GAS 0 0 4,508.68 835.47 .00 -4,508.68 100.0%* L8053 34940 LICENSES & FEES 6,600 6,600 2,314.00 1,970.00 .00 4,286.00 35.1% L8053 35290 MISC. OPERATING EXPENS 0 0 8,610.84 .00 .00 -8,610.84 100.0%* TOTAL EXPENSES 16,600 16,600 31,988.20 5,422.20 .00 -15,388.20 L8056 ADMINISTRATIVE EXPENSES _________________________________________ L8056 11210 REGULAR PAY 38,617 38,617 16,292.21 2,962.22 .00 22,324.79 42.2% 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,157.97 210.54 .00 1,873.03 38.2% L8056 12216 ICMA GENERAL EMPLOYEES 5,793 5,793 2,443.87 444.34 .00 3,349.13 42.2% L8056 12225 ICMA-457 MATCH 720 720 304.50 55.40 .00 415.50 42.3% L8056 12310 HEALTH INSURANCE 17,333 17,333 6,502.10 1,182.20 .00 10,830.90 37.5% 03/12/2018 17:13 |VILLAGE OF NORTH PALM BEACH |P 3 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud FEBRUARY 28, 2018 * PRELIMINARY* FOR 2018 05 ORIGINAL REVISED AVAILABLE PCT L8056 ADMINISTRATIVE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ L8056 12312 HEALTH SAVING ACCOUNT 0 0 3,000.00 .00 .00 -3,000.00 100.0%* L8056 12320 LIFE INSURANCE 87 87 36.25 7.25 .00 50.75 41.7% L8056 12330 L.T.D. INSURANCE 167 167 69.00 13.80 .00 98.00 41.3% L8056 12410 WORKERS' COMPENSATION 690 690 283.47 51.54 .00 406.53 41.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 2,700.00 .00 .00 4,300.00 38.6% L8056 34110 TELEPHONE 0 0 749.00 191.18 .00 -749.00 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,322.07 230.09 2,067.49 -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 35,690.77 5,348.56 2,067.49 41,879.74 L8059 CLUBHOUSE GROUNDS EXPENSE _________________________________________ L8059 33440 EXTERMINATING 950 950 3,200.00 800.00 .00 -2,250.00 336.8%* L8059 33491 CONTRACTUAL SERVICES 0 0 14,710.00 .00 5,600.00 -20,310.00 100.0%* L8059 34110 TELEPHONE 0 0 970.69 185.47 .00 -970.69 100.0%* L8059 34310 ELECTRICITY 0 0 5,622.47 799.91 .00 -5,622.47 100.0%* L8059 34320 WATER & SEWER 0 0 15,031.16 3,150.49 .00 -15,031.16 100.0%* L8059 34330 GAS 0 0 329.94 58.49 .00 -329.94 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 41,714.76 4,994.36 5,600.00 -42,428.76 L8062 INSURANCE EXPENSES _________________________________________ L8062 34530 INSURANCE-COMP.GEN'L L 44,038 44,038 17,796.20 3,559.24 .00 26,241.80 40.4% TOTAL EXPENSES 44,038 44,038 17,796.20 3,559.24 .00 26,241.80 L8070 RESERVES EXPENSES _________________________________________ L8070 33112 SPECIAL LEGAL SERVICES 10,000 10,000 2,301.00 702.00 .00 7,699.00 23.0% TOTAL EXPENSES 10,000 10,000 2,301.00 702.00 .00 7,699.00 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 1,053,412.07 202,233.84 716,591.74 892,401.19 66.5% ** END OF REPORT - Generated by samia janjua **