Loading...
HomeMy WebLinkAboutGolf Budget Report thru 5-31-25 FY 25Budget Report For Golf Course 5/31/2025 Organization Object Account Description 2023 Actuals 2024 Actuals 2025 Revised Budget 2025 Actuals 2025 Projected Actuals 2026 Adopted Budget Revenues Legacy Revenues 50436 3077 MISC FEES-CC CONVENIENCE ($6,932)($6,899)($6,700)$0 ($7,000)($7,000) 50436 3200 FEES-LEGACY DAILY ($90,392)($110,108)($85,000)($42,139)($116,000)($108,000) 50436 3201 FEES-LEGACY FOOTGOLF $0 $0 $0 $0 $0 $0 50436 3202 FEES-LEGACY CART/CLUB RENTAL ($66,110)($70,201)($65,000)($16,450)($65,000)($68,000) 50436 3203 FEES-LEGACY PUNCH CARD/COUPONS ($22)($165)$0 ($77)($200)($100) 50436 3204 FEES-LEGACY SEASON PASSES ($46,566)($63,780)($50,000)($60,398)($69,000)($66,000) 50436 3205 FEES-LEG SEASON DUALPASS SHARE ($32,131)($30,199)($30,000)$0 ($30,000)($30,000) 50436 3270 NON-RES10%SURCHARGEPASS/COUPON $0 $0 $0 $0 $0 50436 3800 MISCELLANEOUS REVENUE $0 $0 $0 $0 $0 $0 Total Legacy Revenues ($242,153)($281,353)($236,700)($119,065)($287,200)($279,100) Teton Lakes Revenues 50437 3077 MISC FEES-CC CONVENIENCE ($37,102)($43,990)($36,000)($25,307)($45,000)($43,500) 50437 3146 RENTALS-LOCKERS/DECK/TENT/ETC ($1,132)($640)($600)($467)($600)($700) 50437 3230 FEES-TETON LAKES DAILY ($358,564)($383,243)($348,000)($138,631)($392,000)($380,000) 50437 3231 FEES-TETON LAKES RANGE ($40,795)($41,632)($41,000)($20,679)($44,000)($41,000) 50437 3232 FEES-TL CART/CLUB RENTAL ($255,925)($275,058)($248,000)($111,594)($288,000)($273,000) 50437 3240 FEES- SEASON PASS ($130,360)($179,509)($162,000)($189,158)($193,000)($180,000) 50437 3241 FEES- COLLEGE PASS ($44,231)$0 $0 $0 $0 $0 50437 3242 FEES- JUNIOR PASS ($8,360)($10,214)($7,000)($13,662)($14,000)($11,000) 50437 3243 FEES- SENIOR PASS ($51,394)($50,702)($50,000)($53,922)($55,000)($52,000) 50437 3244 FEES- 2ND SEASON PASS ($11,007)($17,127)($11,500)($15,004)($17,500)($17,000) 50437 3245 FEES- FAMILY PASS ($34,351)($37,192)($32,000)($56,718)($58,000)($46,000) 50437 3247 FEES- ONE MONTH PASS ($1,962)($896)($1,500)($943)($1,300)($1,000) 50437 3248 FEES- THREE MONTH PASS ($3,868)($5,674)($3,400)($4,158)($5,000)($4,300) 50437 3249 FEES- END OF SEASON PASS ($15,876)($11,619)($13,000)$0 ($11,500)($11,000) 50437 3250 FEES-MUNI DUAL SEASON PASS RED $32,131 $30,199 $30,000 $0 $30,000 $30,000 50437 3260 FEES-TL-PUNCH CARD/COUPONS ($20,006)($30,952)($21,500)($9,279)($30,000)($30,000) 50437 3261 FEES-TL-PUNCH PASS CARTS ($46,219)($63,116)($45,000)($25,544)($64,000)($62,000) 50437 3262 FEES-TL-RANGE SEASON PASS ($20,123)($18,672)($19,000)($16,710)($17,600)($18,000) 50437 3270 NON-RES10%SURCHARGEPASS/COUPON $0 $0 $0 $0 $0 $0 50437 3275 FEES-GOLF LESSONS ($10,650)($8,004)($10,000)($50)($8,000)($8,000) 50437 3276 FEES-YOUTH LESSON-NO REC PROG ($6,486)($3,185)($6,500)($350)($2,800)($1,000) Budget Report For Golf Course 5/31/2025 Organization Object Account Description 2023 Actuals 2024 Actuals 2025 Revised Budget 2025 Actuals 2025 Projected Actuals 2026 Adopted Budget 50437 3277 FEES-GOLF SIMULATOR $0 $0 $0 $0 ($8,000) 50437 3278 INVENTORY PROFIT-23%-NET10.35%($80,877)($57,620)($52,000)($19,856)($59,000)($65,000) 50437 3280 DISCOUNTS-TETON LAKES $1,591 $449 $1,600 $54 $500 $600 50437 3285 LEASE/COMMON COST-RESTAURANT ($8,500)($12,000)($12,000)($2,500)($2,500)$0 50437 3286 LEASE/COMMON COST-WINTER REC ($1,600)($2,000)($2,000)$0 ($2,000)($2,100) 50437 3288 FEES-CAPITAL IMPROVEMENT ($46,493)($48,164)($44,500)($27,171)($49,400)($47,000) 50437 3289 FEES-CAP IMPROVEMENT CLUBHOUSE ($2,811)($3,952)($2,800)$0 ($4,000)($3,500) 50437 3350 STATE GRANT $0 $0 $0 $0 $0 $0 50437 3711 INTEREST EARNED- INVESTMENTS ($6,876)($9,372)($7,500)($4,351)($7,400)($3,500) 50437 3750 SALE OF ASSETS $0 $0 $0 $0 ($5,000)$0 50437 3760 CONTRIBUTIONS/PRIVATE GRANTS ($20,300)($9,700)($13,500)($14,485)($14,500)($14,500) 50437 3800 MISCELLANEOUS REVENUE ($27)($33,866)($200)($644)($2,000)($2,000) Total Teton Lakes Revenues ($1,232,174)($1,327,450)($1,158,900)($751,129)($1,362,600)($1,294,500) Other Revenues 50437 3764 CONTRIBUTIONS-MADISON COUNTY ($50,000)($25,300)$0 $0 $0 $0 50437 3776 CONTRIBUTIONS-WATER $0 $0 $0 $0 $0 $0 50437 3778 CONTRIBUTED ASSETS-OUTSIDERS $0 $0 $0 $0 $0 $0 50399 3901 FUND TFRIN-CITY GEN/CONVERSION ($50,000)($25,300)$0 $0 $0 $0 50437 3999 FUND BAL CARRYOVER-BUDGET $0 $0 ($245,900)$0 ($602,700)($204,900) Total Other Revenues ($100,000)($50,600)($245,900)$0 ($602,700)($204,900) Total Revenues ($1,574,327)($1,659,403)($1,641,500)($870,193)($2,252,500)($1,778,500) Budget Report For Golf Course 5/31/2025 Organization Object Account Description 2023 Actuals 2024 Actuals 2025 Revised Budget 2025 Actuals 2025 Projected Actuals 2026 Adopted Budget Expenses Legacy Expenses 50436 4100 SALARIES FT $46,398 $50,767 $56,000 $35,499 $55,000 $56,700 50436 4107 MERIT/SAL STY RAISE-BUDGET $0 $0 $0 $0 $0 $0 50436 4109 NEW HIRE-GROUNDS-75%/25% REC $0 $0 $0 $0 $0 $16,500 50436 4110 NEW HIRE-PRO SHOP 83%/17% REC $0 $0 $0 $0 $0 $17,800 50436 4150 FULL TIME OVERTIME $713 $566 $700 $285 $700 $1,200 50436 4160 PART-TIME WAGES-GROUNDS MAINT.$41,622 $37,855 $42,000 $18,444 $42,000 $35,000 50436 4161 PART TIME WAGE-GOLF CLUBHOUSE $26,592 $15,289 $27,500 $5,906 $21,000 $26,000 50436 4190 ACCRUED LEAVE/VACATION BUYOUT $720 $408 $500 $1,199 $1,200 $1,400 50436 4200 BENEFITS $25,203 $24,756 $29,500 $17,050 $29,200 $33,700 50436 4250 W/C CLAIMS SURCHARGE $0 $0 $0 $0 $0 $0 50436 4251 W/C REFUND ($339)($315)($300)($303)($300)($400) 50436 4260 UNEMPLOYMENT BENEFITS-25% $0 $0 $0 $0 $0 $0 50436 4270 UNIFORMS $78 $105 $100 $123 $100 $200 50436 4290 WELLNESS/RECREATION PROGRAMS $16 $0 $100 $0 $0 $200 50436 4300 SUPPLIES $2,918 $5,066 $2,700 $2,396 $4,000 $4,000 50436 4327 SUPPLIES-SAND $1,350 $1,130 $1,400 $2,025 $2,000 $1,400 50436 4328 SUPPLES-HERBICIDES/FUNGICIDES $3,032 $2,600 $3,200 $4,008 $4,000 $3,800 50436 4329 SUPPLIES-FERTILIZER $6,225 $6,555 $6,300 $2,092 $6,500 $6,600 50436 4350 FUEL & OIL $8,028 $8,606 $8,600 $2,946 $8,200 $9,000 50436 4390 SMALL TOOLS/EQUIPMENT $2,801 $2,296 $2,400 $1,751 $2,400 $2,400 50436 4400 DRUG TEST/SHOTS/BCKGRND CHECKS $132 $229 $100 $445 $400 $400 50436 4418 GOLF MANAGEMENT CONTRACT $0 $0 $0 $0 $0 $0 50436 4430 HIRED WORK $2,662 $0 $1,000 $0 $0 $0 50436 4449 HIRED WORK-PUMP& TOILET RENTAL $1,020 $891 $1,100 $297 $1,000 $1,000 50436 4460 INSURANCE $2,198 $2,886 $3,700 $3,744 $3,700 $3,700 50436 4470 TRAINING, TRAVEL, & MEETINGS $222 $397 $300 $126 $400 $400 50436 4490 BANKING FEES $0 $0 $0 $0 $0 $0 50436 4491 CREDIT CARD PROCESSING FEES $7,815 $6,088 $7,300 $0 $6,100 $6,200 50436 4500 PUBLISHING/ADVERTISING $95 $476 $200 $226 $300 $300 50436 4510 TELEPHONE & INTERNET $1,138 $502 $400 $246 $400 $400 50436 4520 HEAT & LIGHTS $1,462 $1,271 $1,500 $555 $1,200 $1,400 50436 4532 POWER-PUMPING $242 $245 $300 $146 $300 $300 50436 4580 WATER/SEWER/GARBAGE/IRRIGATION $1,770 $4,615 $2,100 $809 $4,600 $4,700 Budget Report For Golf Course 5/31/2025 Organization Object Account Description 2023 Actuals 2024 Actuals 2025 Revised Budget 2025 Actuals 2025 Projected Actuals 2026 Adopted Budget 50436 4590 PUMP REPAIRS $0 $0 $0 $265 $300 $0 50436 4600 BUILDING/GROUNDS REPAIRS $6,169 $0 $500 $0 $300 $500 50436 4610 EQUIPMENT REPAIRS $6,966 $6,603 $6,200 $1,621 $6,200 $6,300 50436 4612 IRRIGATION/GROUNDS REPAIRS $3,657 $4,664 $5,000 $365 $3,800 $4,000 50436 4628 EQUIPMENT REPAIRS-GOLF CARTS $1,410 $2,617 $1,300 $3,097 $4,000 $2,800 50436 4640 COMPUTER PROGRAM/SOFTWARE MAIN $2,146 $1,926 $2,300 $1,769 $2,100 $2,200 50436 4677 DEPRECIATION $0 $0 $0 $0 $0 $0 50436 4680 LIABILITY LOSSES ($2,078)$0 $0 $0 $0 $0 50436 4690 MISCELLANEOUS EXPENSE $0 $0 $0 $0 $0 $0 50436 4850 OVERHEAD-SHOP EXPENSES $2,781 $0 $2,000 $1,503 $0 $1,000 50436 4890 HIREDWORK-ACCOUNTING/OVERHEAD $6,096 $6,504 $7,500 $5,625 $7,500 $10,000 50436 5570 NEW CARPET AT CLUBHOUSE-LEG. $0 $0 $0 $0 $0 $0 50436 5572 LEAN SHELTER- FOR CARTS $0 $0 $0 $0 $0 $0 50436 5573 AVAILABLE $0 $0 $0 $0 $0 $0 50436 5783 IRRIGATION PUMP STAT-SHARED $0 $0 $0 $0 $0 $0 50436 5784 AVAILABLE $0 $0 $0 $0 $0 $0 50436 5785 REBUILD MAINLINE $9,156 $24,906 $30,000 $65,238 $65,300 $40,000 50436 5788 LEGACY-ADD SIDEWALK-PIONEER RD $0 $0 $0 $0 $0 $0 Total Legacy Expenses $220,417 $220,503 $253,500 $179,498 $283,900 $301,100 Budget Report For Golf Course 5/31/2025 Organization Object Account Description 2023 Actuals 2024 Actuals 2025 Revised Budget 2025 Actuals 2025 Projected Actuals 2026 Adopted Budget Teton Lakes Expenses 50437 4100 SALARIES FT $188,728 $192,075 $201,200 $117,464 $201,500 $210,000 50437 4107 MERIT/SAL STY RAISE-BUDGET $0 $0 $0 $0 $0 $0 50437 4109 NEW HIRE-GROUNDS-75%/25% REC $0 $0 $0 $0 $0 $49,400 50437 4110 NEW HIRE-PRO SHOP 83%/17% REC $0 $0 $0 $0 $0 $53,600 50437 4150 FULL TIME OVERTIME $2,138 $1,696 $2,000 $854 $1,700 $2,300 50437 4160 PART-TIME WAGES-GROUNDS MAINT.$139,275 $198,663 $142,000 $72,631 $211,000 $195,000 50437 4161 PART TIME WAGE-GOLF CLUBHOUSE $49,992 $68,258 $61,000 $31,354 $76,000 $45,000 50437 4162 PART TIME WAGES-GOLF JANITOR $0 $0 $0 $0 $0 $0 50437 4163 PARTTIME WAGE-GOLF DRIVE RANGE $461 $9,214 $500 $2,285 $9,800 $9,200 50437 4164 PART TIME WAGES-GOLF-LESSONS $5,799 $1,033 $8,600 $23 $1,000 $0 50437 4190 ACCRUED LEAVE/VACATION BUYOUT $3,342 $3,916 $4,000 $5,281 $5,300 $5,500 50437 4200 BENEFITS $89,400 $95,800 $101,200 $60,615 $102,000 $109,000 50437 4250 W/C CLAIMS SURCHARGE $5,395 $8,798 $8,600 $124 $100 $100 50437 4251 W/C REFUND ($834)($1,026)($1,000)($998)($1,000)($1,300) 50437 4260 UNEMPLOYMENT BENEFITS-75% $0 $0 $0 $0 $0 $0 50437 4270 UNIFORMS $272 $314 $400 $618 $700 $600 50437 4290 WELLNESS/RECREATION PROGRAMS $49 $0 $100 $0 $100 $200 50437 4300 SUPPLIES $22,882 $27,415 $27,000 $19,661 $27,500 $27,500 50437 4327 SUPPLIES-SAND $9,159 $9,605 $9,000 $550 $9,600 $9,700 50437 4328 SUPPLES-HERBICIDES/FUNGICIDES $11,485 $10,373 $10,000 $11,782 $10,500 $10,600 50437 4329 SUPPLIES-FERTILIZER $15,295 $23,703 $22,000 $6,277 $22,000 $22,500 50437 4330 SUPPLES-JANITOR $3,975 $3,400 $4,000 $2,174 $3,500 $3,600 50437 4350 FUEL & OIL $38,839 $38,609 $39,800 $14,596 $38,500 $39,500 50437 4390 SMALL TOOLS/EQUIPMENT $13,443 $14,830 $12,000 $6,175 $13,000 $13,800 50437 4400 DRUG TEST/SHOTS/BCKGRND CHECKS $374 $653 $400 $1,027 $1,100 $1,200 50437 4418 GOLF MANAGEMENT CONTRACT $0 $0 $0 $0 $0 $0 50437 4426 INTEREST EXPENSE $0 $0 $0 $0 $0 $0 50437 4430 HIRED WORK $2,806 $1,203 $6,000 $5,880 $5,800 $1,800 50437 4433 HIREDWORK-TREE REMOVAL/REPLACE $0 $0 $1,500 $0 $1,200 $2,000 50437 4449 HIRED WORK-PUMP& TOILET RENTAL $4,056 $4,391 $4,200 $1,431 $4,400 $4,500 50437 4460 INSURANCE $6,262 $12,831 $18,700 $18,706 $18,700 $28,200 50437 4470 TRAINING, TRAVEL, & MEETINGS $1,807 $1,555 $1,400 $382 $1,500 $1,800 50437 4490 BANKING FEES $0 $0 $0 $0 $0 $0 50437 4491 CREDIT CARD PROCESSING FEES $41,832 $38,816 $38,000 $21,727 $39,800 $40,000 Budget Report For Golf Course 5/31/2025 Organization Object Account Description 2023 Actuals 2024 Actuals 2025 Revised Budget 2025 Actuals 2025 Projected Actuals 2026 Adopted Budget 50437 4500 PUBLISHING/ADVERTISING $1,165 $887 $800 $95 $700 $800 50437 4510 TELEPHONE & INTERNET $2,112 $2,197 $1,000 $611 $1,000 $1,100 50437 4520 HEAT & LIGHTS $6,822 $5,972 $6,800 $3,876 $6,100 $7,000 50437 4532 POWER-PUMPING $22,127 $24,915 $22,000 $5,265 $25,000 $24,000 50437 4580 WATER/SEWER/GARBAGE/IRRIGATION $7,753 $10,550 $7,800 $4,914 $8,000 $8,700 50437 4590 PUMP REPAIRS $0 $7,934 $2,500 $1,136 $2,500 $2,500 50437 4600 BUILDING REPAIRS $15,105 $4,964 $11,000 $9,535 $11,000 $10,000 50437 4610 EQUIPMENT REPAIRS $49,503 $62,727 $50,000 $38,413 $60,000 $63,000 50437 4612 IRRIGATION/GROUNDS REPAIRS $45,688 $48,066 $31,000 $32,399 $48,000 $49,000 50437 4628 EQUIPMENT REPAIRS-GOLF CARTS $10,305 $17,450 $13,000 $13,932 $18,000 $18,500 50437 4640 COMPUTER PROGRAM/SOFTWARE MAIN $10,988 $16,283 $11,400 $5,482 $16,500 $16,700 50437 4677 DEPRECIATION $0 $0 $0 $0 $0 $0 50437 4680 LIABILITY LOSSES $0 $0 $0 $10,000 $10,000 $0 50437 4690 MISCELLANEOUS EXPENSE $0 $0 $0 $0 $0 $0 50437 4850 OVERHEAD-SHOP EXPENSES $8,344 $0 $8,000 $6,003 $1,000 $5,000 50437 4890 HIREDWORK-ACCOUNTING/OVERHEAD $36,000 $40,008 $43,500 $32,625 $43,500 $50,000 50437 5003 VEHICLE $5,000 $0 $0 $0 $0 $0 50437 5008 BANKS MOWER $0 $46,795 $0 $26,995 $27,000 $0 50437 5143 TRACTOR $0 $45,605 $0 $0 $0 $0 50437 5177 IT-SECURITY CAMERAS/BLD ACCESS $0 $0 $0 $0 $0 $0 50437 5266 SEPTIC EQUIP-REPLACE AS NEEDED $0 $0 $0 $0 $0 $0 50437 5332 FAIRWAY MOWER $79,512 $0 $0 $0 $0 $90,000 50437 5333 ROUGH MOWER-USED $0 $0 $110,000 $90,221 $90,300 $0 50437 5334 GREENS MOWER $0 $85,981 $0 $0 $0 $0 50437 5335 UTILITY CART $0 $0 $0 $0 $0 $0 50437 5336 TRAILER $0 $6,540 $0 $8,350 $8,400 $0 50437 5337 PUMP SCREEN & LINE ACROSS 14 $0 $0 $0 $0 $0 $0 50437 5338 CUSHMAN UTILITY TRUCKSTER $0 $0 $40,000 $0 $40,000 $70,000 50437 5339 PURCHASE CART/INVENTORY $0 $0 $0 $0 $0 $0 50437 5340 AERATOR-GREENS $0 $0 $0 $0 $0 $0 50437 5341 AERATOR-FAIRWAY-1/2 THE COST $0 $0 $0 $0 $0 $0 50437 5342 TRACTOR-1/2 OF THE COST $6,577 $0 $0 $0 $0 $0 50437 5343 DETHATCHER/SWEEPER-1/2 OF COST $0 $0 $0 $0 $0 $0 50437 5344 SF#9DEWATER PUMP/VAULT REBUILD $9,683 $0 $0 $0 $40,000 $0 50437 5345 TL NEW VFD FOR 100 HP PUMP $9,419 $0 $0 $0 $0 $0 50437 5348 DRINKING FOUNTAIN $5,665 $0 $0 $0 $0 $0 Budget Report For Golf Course 5/31/2025 Organization Object Account Description 2023 Actuals 2024 Actuals 2025 Revised Budget 2025 Actuals 2025 Projected Actuals 2026 Adopted Budget 50437 5351 TURF SPREADER $0 $0 $0 $0 $0 $0 50437 5352 Sand Pro Equipment $0 $0 $0 $0 $0 $0 50437 5353 Add Lights at Range-Golf $0 $0 $0 $0 $0 $0 50437 5355 RANGE PICKER/ BALL DISPENSOR $0 $0 $0 $0 $0 $0 50437 5540 BUILD REMODEL-LOCKER RM/SIDING $24,711 $0 $160,000 $135,849 $139,000 $0 50437 5573 TEE/GREEN RENOVATION/EXPANSION $0 $0 $0 $0 $0 $5,000 50437 5574 LEAN TO/EXPAND DECK-CART STORE $11,297 $0 $0 $0 $0 $0 50437 5575 NEW CARPET-TETON LAKES $0 $0 $10,000 $0 $0 $0 50437 5576 HANDICAP RAMP $0 $0 $0 $0 $0 $0 50437 5577 HOOKUP WATER AT CLUBHOUSE $0 $0 $0 $0 $0 $0 50437 5578 NEW SWAMP COOLER INSTALLED $0 $0 $0 $0 $0 $0 50437 5579 REPLACE ROOF $0 $0 $0 $0 $0 $0 50437 5580 STORAGE TO SHOP-2 PHASES $0 $0 $5,000 $0 $0 $0 50437 5581 STORAGE POLE BARN -MOVE-1500' $0 $0 $0 $0 $0 $0 50437 5583 ELECTRICAL SERVICE UPDGRADE $9,384 $0 $0 $0 $0 $0 50437 5588 GOLF SIMULATOR $0 $0 $0 $0 $30,000 50437 5589 REEL SHARPENER $0 $0 $0 $0 $30,000 50437 5621 NEW SIGN AT TETON LAKES $0 $0 $0 $0 $0 $0 50437 5786 NEW BRIDGES $0 $0 $0 $0 $0 $0 50437 5787 750' LINE CANAL TO POND TETON $0 $0 $0 $0 $0 $0 50437 5789 TL-EXPAND PARKING LOT SOUTH $141,542 $0 $20,000 $0 $14,000 $0 50437 6000 CONTINGENCY-BUDGET ONLY $0 $0 $4,100 $0 $0 $0 50499 4950 FUND TFR -GOLF OPERATIONS $0 $0 $0 $0 $0 $0 50499 4951 FUND TFR -GOLF DEBT SERVICE $84,417 $59,196 $107,500 $81,000 $107,500 $110,800 Total Teton Lakes Expenses $1,259,351 $1,252,196 $1,388,000 $907,319 $1,522,800 $1,477,400 Total Expenses $1,479,768 $1,472,699 $1,641,500 $1,086,817 $1,806,700 $1,778,500 Total (Profit) Loss Legacy ($21,736)($60,850)$16,800 $60,433 ($3,300)$22,000 Total (Profit) Loss Teton Lakes $27,177 ($75,254)$229,100 $156,190 $160,200 $182,900 Total (Profit) Loss $5,441 ($136,104)$245,900 $216,624 $156,900 $204,900 Total Revenues ($1,574,327)($1,659,403)($1,641,500)($870,193)($2,252,500)($1,778,500) Total Expenses $1,479,768 $1,472,699 $1,641,500 $1,086,817 $1,806,700 $1,778,500 Net ($94,559)($186,704)$0 $216,624 ($445,800)$0 Projected Ending Balance ($445,800)($240,900)