Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
MAR CC PRELIMINARY LINE ITEM DETAIL_4-10-18
04/10/2018 14:35 |VILLAGE OF NORTH PALM BEACH |P 1 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud MARCH 31, 2018 **PRELIMINARY** FOR 2018 06 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 633,760.39 165,143.02 22,141.61 96.6%* L2100 05232 GOLF CART RENTAL 543,599 543,599 447,382.72 94,306.81 96,216.28 82.3%* L2100 05234 LOCKER RENTALS 0 0 761.30 .00 -761.30 100.0%* L2100 05235 GOLF HANDICAP SERVICE 2,300 2,300 2,125.00 150.00 175.00 92.4%* L2100 06621 CLUB-RESIDENT 287,150 287,150 302,843.68 22,520.87 -15,693.68 105.5%* L2100 06622 CLUB-NON RESIDENT 202,050 202,050 184,380.56 4,853.90 17,669.44 91.3%* 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 300.00 3,060.00 59.5%* L2100 07100 WALKING FEE 37,630 37,630 30,767.50 6,993.68 6,862.50 81.8%* L2100 08310 TOURNAMENT PROCEEDS 3,000 3,000 5,995.78 538.95 -2,995.78 199.9%* TOTAL REVENUES 1,742,611 1,742,611 1,616,019.93 294,807.23 126,591.07 L2246 GOLF SHOP REVENUES _________________________________________ L2246 02301 GOLF SHOP - SALES 100,000 100,000 70,912.22 18,054.25 29,087.78 70.9%* L2246 02302 BAG ROOM 0 0 7,237.60 .00 -7,237.60 100.0%* L2246 02303 LESSONS 100,000 100,000 48,502.50 4,130.00 51,497.50 48.5%* L2246 02304 GOLF BALL RETRIEVAL 3,000 3,000 .00 .00 3,000.00 .0%* L2246 02307 GOLF GRIP SALES 1,500 1,500 1,200.17 216.00 299.83 80.0%* L2246 02310 RENTAL-GOLF CLUBS 35,000 35,000 28,414.32 8,641.08 6,585.68 81.2%* TOTAL REVENUES 239,500 239,500 156,266.81 31,041.33 83,233.19 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 .00 7,002.00 52.5%* L3200 07500 DRIVING RANGE PROCEEDS 223,772 223,772 186,471.23 44,256.37 37,300.77 83.3%* TOTAL REVENUES 238,524 238,524 194,221.23 44,256.37 44,302.77 L3700 OTHER MISC. REVENUES _________________________________________ L3700 08440 CHARGE CARD FEE REVENU 6,000 6,000 4,018.51 117.07 1,981.49 67.0%* 04/10/2018 14:35 |VILLAGE OF NORTH PALM BEACH |P 2 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud MARCH 31, 2018 **PRELIMINARY** FOR 2018 06 ORIGINAL REVISED ACTUAL YTD ACTUAL MTD REMAINING PCT ESTIM REV EST REV REVENUE REVENUE REVENUE COLL____________________________________________________________________________________________________________________________________ L3700 08920 DISCOUNTS EARNED 0 0 180.00 30.00 -180.00 100.0%* L3700 08945 CARD FEE - RESIDENCY 0 0 1,500.00 30.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 .15 -398.38 100.0%* L3700 08995 DONATIONS-PAVER BRICKS 0 0 93.46 .00 -93.46 100.0%* L3700 08999 MISC. REVENUES 0 0 -174.06 -1.09 174.06 100.0% TOTAL REVENUES 6,000 6,000 11,123.92 176.13 -5,123.92 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,980,098.62 370,281.06 682,306.38 74.4% ** END OF REPORT - Generated by samia janjua ** 04/10/2018 14:34 |VILLAGE OF NORTH PALM BEACH |P 1 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud MARCH 31, 2018 **PRELIMINARY** FOR 2018 06 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 533,859.54 88,976.59 533,859.42 10,000.04 99.1% L8045 34310 ELECTRICITY 30,426 30,426 15,295.66 3,071.18 .00 15,130.34 50.3% L8045 34320 WATER & SEWER 29,177 29,177 11,483.32 55.62 .00 17,693.68 39.4% 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 0 78,034.50 53,034.50 1,426,224.69 -1,504,259.19 100.0%* L8045 66490 MACHINERY & EQUIPMENT 12,000 12,000 .00 .00 .00 12,000.00 .0% TOTAL EXPENSES 1,161,822 1,161,822 638,673.02 145,137.89 1,960,084.11 -1,436,935.13 L8046 GOLF SHOP EXPENSES _________________________________________ L8046 11110 EXECUTIVE SALARIES 78,945 78,945 38,825.76 6,072.68 .00 40,119.24 49.2% L8046 11210 REGULAR PAY 83,307 83,307 47,052.98 5,736.65 .00 36,254.02 56.5% L8046 11300 PART-TIME PAY 193,237 193,237 143,724.63 22,895.14 .00 49,512.37 74.4% L8046 11400 OVERTIME PAY 1,000 1,000 981.34 686.28 .00 18.66 98.1% L8046 11501 AUTO ALLOWANCE 4,800 4,800 2,400.06 369.24 .00 2,399.94 50.0% L8046 11504 TELEPHONE ALLOWANCE 720 720 359.97 55.38 .00 360.03 50.0% L8046 11506 COMMISSIONS - LESSONS 55,000 55,000 33,509.05 2,313.50 .00 21,490.95 60.9% L8046 12110 F I C A 31,902 31,902 20,215.93 2,891.38 .00 11,686.07 63.4% L8046 12216 ICMA GENERAL EMPLOYEES 21,052 21,052 10,835.72 1,445.25 .00 10,216.28 51.5% L8046 12217 ICMA MUNICIPAL EMPLOYE 4,114 4,114 2,045.32 326.14 .00 2,068.68 49.7% L8046 12225 ICMA-457 MATCH 2,880 2,880 692.30 83.10 .00 2,187.70 24.0% L8046 12310 HEALTH INSURANCE 29,040 29,040 10,769.26 689.52 .00 18,270.74 37.1% L8046 12312 HEALTH SAVING ACCOUNT 0 0 4,500.00 .00 .00 -4,500.00 100.0%* L8046 12320 LIFE INSURANCE 348 348 166.75 21.75 .00 181.25 47.9% L8046 12330 L.T.D. INSURANCE 722 722 363.30 50.89 .00 358.70 50.3% L8046 12410 WORKERS' COMPENSATION 7,256 7,256 4,640.09 663.46 .00 2,615.91 63.9% L8046 33190 PROFESSIONAL SERVICES 200 200 .00 .00 .00 200.00 .0% L8046 33230 CHARGE CARD FEE 45,000 45,000 28,090.60 .00 .00 16,909.40 62.4% L8046 33491 CONTRACTUAL SERVICES 198,545 198,545 83,661.68 12,470.33 73,789.92 41,093.40 79.3% L8046 34010 TRAVEL & LODGING 1,200 1,200 1,064.96 -576.22 .00 135.04 88.7% L8046 34110 TELEPHONE 9,582 9,582 1,287.98 378.36 .00 8,294.02 13.4% L8046 34210 POSTAGE 0 0 28.97 .00 .00 -28.97 100.0%* L8046 34310 ELECTRICITY 8,400 8,400 14,497.95 2,461.50 .00 -6,097.95 172.6%* L8046 34320 WATER & SEWER 4,512 4,512 475.38 50.43 .00 4,036.62 10.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 241.17 175.04 .00 3,258.83 6.9% 04/10/2018 14:34 |VILLAGE OF NORTH PALM BEACH |P 2 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud MARCH 31, 2018 **PRELIMINARY** FOR 2018 06 ORIGINAL REVISED AVAILABLE PCT L8046 GOLF SHOP EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ L8046 34710 PRINTING & BINDING 3,250 3,250 295.86 .00 .00 2,954.14 9.1% L8046 34812 CLUB RELATIONS 8,000 8,000 5,861.10 664.19 .00 2,138.90 73.3% L8046 34910 ADVERTISING 25,000 25,000 7,760.01 70.00 .00 17,239.99 31.0% L8046 34960 TROPHIES, AWARDS & PRI 3,500 3,500 2,973.06 1,155.90 .00 526.94 84.9% L8046 35110 OFFICE SUPPLIES 6,300 6,300 3,690.81 105.89 .00 2,609.19 58.6% L8046 35111 COMPUTER SUPPLIES 2,000 2,000 706.35 .00 .00 1,293.65 35.3% L8046 35120 GOLF SUPPLIES 0 0 6,494.30 .00 .00 -6,494.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 347.65 98.85 .00 652.35 34.8% L8046 35294 UNIFORMS & SHOES 4,000 4,000 2,193.88 .00 .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 48,617.17 11,129.47 .00 11,382.83 81.0% L8046 35532 GOLF LESSONS EXPENSE 0 0 556.50 577.50 .00 -556.50 100.0%* L8046 35533 SPECIAL EVENTS/CAMPS 1,500 1,500 232.01 232.01 .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% TOTAL EXPENSES 947,262 947,262 535,027.36 73,293.61 73,789.92 338,444.72 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,215.73 188.08 .00 -1,215.73 100.0%* L8053 34310 ELECTRICITY 8,800 8,800 9,554.29 1,120.61 .00 -754.29 108.6%* L8053 34320 WATER & SEWER 1,200 1,200 7,168.64 1,203.85 .00 -5,968.64 597.4%* L8053 34330 GAS 0 0 5,489.76 981.08 .00 -5,489.76 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%* TOTAL EXPENSES 16,600 16,600 35,481.82 3,493.62 .00 -18,881.82 L8056 ADMINISTRATIVE EXPENSES _________________________________________ L8056 11210 REGULAR PAY 38,617 38,617 19,254.43 2,962.22 .00 19,362.57 49.9% 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,368.51 210.54 .00 1,662.49 45.2% L8056 12216 ICMA GENERAL EMPLOYEES 5,793 5,793 2,888.21 444.34 .00 2,904.79 49.9% L8056 12225 ICMA-457 MATCH 720 720 359.90 55.40 .00 360.10 50.0% 04/10/2018 14:34 |VILLAGE OF NORTH PALM BEACH |P 3 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud MARCH 31, 2018 **PRELIMINARY** FOR 2018 06 ORIGINAL REVISED AVAILABLE PCT L8056 ADMINISTRATIVE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ L8056 12310 HEALTH INSURANCE 17,333 17,333 7,093.20 591.10 .00 10,239.80 40.9% L8056 12312 HEALTH SAVING ACCOUNT 0 0 3,000.00 .00 .00 -3,000.00 100.0%* L8056 12320 LIFE INSURANCE 87 87 43.50 7.25 .00 43.50 50.0% L8056 12330 L.T.D. INSURANCE 167 167 82.80 13.80 .00 84.20 49.6% L8056 12410 WORKERS' COMPENSATION 690 690 335.01 51.54 .00 354.99 48.6% 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,340.00 .00 .00 1,660.00 76.3% L8056 34110 TELEPHONE 0 0 936.34 187.34 .00 -936.34 100.0%* L8056 34210 POSTAGE 2,000 2,000 167.31 .00 .00 1,832.69 8.4% L8056 34422 RENTAL-COPIER 3,200 3,200 1,577.35 255.28 1,812.21 -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 43,276.89 4,778.81 1,812.21 34,548.90 L8059 CLUBHOUSE GROUNDS EXPENSE _________________________________________ L8059 33440 EXTERMINATING 950 950 4,000.00 800.00 .00 -3,050.00 421.1%* L8059 33491 CONTRACTUAL SERVICES 0 0 14,710.00 .00 5,600.00 -20,310.00 100.0%* L8059 34110 TELEPHONE 0 0 1,156.16 185.47 .00 -1,156.16 100.0%* L8059 34310 ELECTRICITY 0 0 6,369.54 747.07 .00 -6,369.54 100.0%* L8059 34320 WATER & SEWER 0 0 17,970.28 2,939.12 .00 -17,970.28 100.0%* L8059 34330 GAS 0 0 359.13 29.19 .00 -359.13 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 46,415.61 4,700.85 5,600.00 -47,129.61 L8062 INSURANCE EXPENSES _________________________________________ L8062 34530 INSURANCE-COMP.GEN'L L 44,038 44,038 21,355.44 3,559.24 .00 22,682.56 48.5% TOTAL EXPENSES 44,038 44,038 21,355.44 3,559.24 .00 22,682.56 L8070 RESERVES EXPENSES _________________________________________ L8070 33112 SPECIAL LEGAL SERVICES 10,000 10,000 2,301.00 .00 .00 7,699.00 23.0% TOTAL EXPENSES 10,000 10,000 2,301.00 .00 .00 7,699.00 L8565 DEBT SERVICE EXPENSES _________________________________________ L8565 49170 DEBT PMT-BOA 4.893M 398,159 398,159 199,079.45 199,079.45 .00 199,079.55 50.0% TOTAL EXPENSES 398,159 398,159 199,079.45 199,079.45 .00 199,079.55 GRAND TOTAL 2,662,405 2,662,405 1,521,610.59 434,043.47 2,041,286.24 -900,491.83 133.8% 04/10/2018 14:34 |VILLAGE OF NORTH PALM BEACH |P 4 sjanjua |YEAR-TO-DATE BUDGET REPORT |glytdbud MARCH 31, 2018 **PRELIMINARY** FOR 2018 06 ORIGINAL REVISED AVAILABLE PCT L8565 DEBT SERVICE EXPENSES APPROP BUDGET YTD EXPENDED MTD EXPENDED ENCUMBRANCES BUDGET USED____________________________________________________________________________________________________________________________________ ** END OF REPORT - Generated by samia janjua **