Loading...
HomeMy WebLinkAboutBudget Report GolfGolf Budget Report for Operations City of Rexburg / Date: 03/05/2018 / Time: 13:20:40 Account Description 2017 Actual 2018 Budget 2018 Forecast Budget AJE GOLF OPERATIONS FUND REVENUE LEGACY GOLF COURSE REVENUES **DAILY FEES AND PASSES 50-351.10 DAILY FEES-REXBURG 30,392 38,000 38,000 50-351.12 FOOT GOLF 3,128 3,000 3,000 50-351.14 CART/CLUB RENTAL-LEGACY 10,700 10,700 50-351.28 PUNCH CARDS/COUPONS 1,132 2,000 2,000 50-351.32 MUNI ONLY PASSES -50% DISCOUNT 1,662 1,500 1,700 200 50-351.33 MUNI SHARE OF DUAL COURSE PASS 13,611 17,300 17,300 TOTAL DAILY FEES AND PASSES 49,925 61,800 72,700 10,900 **OTHER REVENUES 50-351.39 --LESS SALES TAX -2,825 -3,600 -4,100 -500 50-351.40 MISCELLANEOUS REVENUE 306 50-351.50 CC/DEBIT CONVENIENCE FEES 901 1,000 1,300 300 TOTAL OTHER REVENUES -1,618 -2,600 -2,800 -200 TOTAL LEGACY COURSE REVENUE 48,307 59,200 69,900 10,700 TETON LAKES COURSE REVENUES 50-352.11 DAILY FEES-TETON LAKES 172,142 168,000 172,000 4,000 50-352.13 RANGE DAILY FEES-TETON LAKES 22,000 22,000 50-352.14 CART/CLUB RENTAL-TETON LAKES 123,000 123,000 TOTAL DAILY FEES 172,142 168,000 317,000 149,000 **PASSES AND CARDS 50-352.20 SEASON PASSES 69,126 80,000 80,000 50-352.21 COLLEGE PASS 14,372 14,000 14,500 50-352.22 JUNIOR PASSES 3,112 5,000 4,500 300 50-352.23 THREE MONTH PASSES 1,843 1,500 1,800 50-352.24 SENIOR PASS 15,214 14,000 15,000 50-352.25 2ND SEASON PASS 4,301 6,000 5,000 -1,000 50-352.26 FAMILY PASS 26,319 21,200 24,000 2,800 50-352.27 ONE MONTH PASS 2,478 2,500 2,500 50-352.28 PUNCH CARDS/COUPONS 20,676 22,000 22,000 50-352.29 TOURNAMENT FEES-In Cart Fees?5,000 5,000 50-352.30 CITY EMPLOYEE PASSES & COUPONS 4,846 4,500 4,800 50-352.31 END OF SEASON PASS 1,893 3,300 2,000 50-352.32 MUNI DUAL SEASONPASS REDUCTION -13,611 -17,300 -17,300 50-352.33 CART PUNCH PASS 2,500 2,500 50-352.34 RANGE PUNCH PASS 2,500 2,500 TOTAL PASSES AND CARDS 150,569 156,700 168,800 12,100 **OTHER Golf Budget Report for Operations City of Rexburg / Date: 03/05/2018 / Time: 13:20:40 Account Description 2017 Actual 2018 Budget 2018 Forecast Budget AJE 50-352.39 --LESS SALES TAX -18,130 -17,800 -27,500 -9,700 50-352.40 MISCELLANEOUS REVENUE 2,734 1,600 1,800 200 50-352.41 GREEN FEES DISCOUNTS -2,148 -2,000 -2,200 -200 50-352.42 RESTAURANT LEASE/COMMON COST 4,200 4,200 50-352.50 CC/DEBIT CONVENIENCE FEES 5,583 6,200 8,700 2,500 50-352.80 CAPITAL IMPROVEMENT FEES 13,133 15,000 14,000 -1,000 50-375.00 SALE OF ASSETS 5,000 5,000 50-376.00 CONTRIBUTION-WATER 0 50-376.10 COUNTY/BRIDGE CONTRIBUTIONS 14,000 14,000 36,800 50-376.20 CONTRIBUTION -FUND 44 50-398.00 CONTINGENCY REVENUES 46,000 -46,000 50-399.00 FUND BALANCE CARRYOVER -46,000 -38,600 7,400 50-399.20 FUND TFR FROM CITY 14,000 14,000 36,800 TOTAL OTHER REVENUES 1,172 31,000 -6,600 36,000 TOTAL TETON LAKES REVENUES 323,883 355,700 479,200 197,100 TOTAL GOLF COURSES REVENUE 372,190 414,900 549,100 207,800 GOLF OPERATIONS EXPENSES **LEGACY GOLF COURSE EXPENSES ****PERSONNEL 50-436.10 FT SALARY-GROUNDS MAINT-25%-8,700 -8,700 50-436.15 MARKETING/PT CITY HALL HELP -300 -100 50-436.16 PART-TIME WAGES-GROUNDS MAINT.-23,000 -23,000 50-436.161 PART-TIME WAGES-CLUBHOUSE ONLY -9,000 -9,000 50-436.20 BENEFITS -7,000 -7,000 50-436.27 UNIFORMS -100 50-436.29 WELLNESS/RECREATION PROGRAMS -100 TOTAL PERSONNEL 0 -300 -48,000 -47,700 ****OPERATIONS 50-436.30 SUPPLIES -1,449 -2,000 -2,300 -300 50-436.31 FERTILIZER -1,885 -1,300 -1,500 50-436.33 HERBICIDES/FUNGICIDES -1,694 -2,000 -2,000 50-436.35 FUEL & OIL -2,977 -2,800 -3,600 -800 50-436.36 SAND -550 -600 -600 50-436.39 SMALL TOOLS -195 -200 -200 50-436.40 DRUG TESTS & BACKGROUND CHECKS -100 -100 50-436.41 MANAGEMENT CONTRACT -35,550 -35,600 -23,300 12,300 50-436.42 ACCOUNTING/OVERHEAD -5,100 -5,200 -5,200 50-436.43 PUMP & TOILET RENTAL -420 -700 -500 50-436.44 HIRED WORK -100 -200 -200 Golf Budget Report for Operations City of Rexburg / Date: 03/05/2018 / Time: 13:20:40 Account Description 2017 Actual 2018 Budget 2018 Forecast Budget AJE 50-436.45 ADVERTISING/MARKETING -365 -300 -400 50-436.46 INSURANCE -70 -100 -100 50-436.48 BANK & CREDIT CARD CHARGES -1,005 -1,000 -1,600 -600 50-436.51 TELEPHONE & INTERNET -869 -800 -1,000 50-436.52 HEAT & LIGHTS -958 -1,000 -1,000 50-436.53 PUMPING POWER-ON BILLING SCHED -489 -500 -2,000 -1,500 50-436.58 WATER/SEWER/GARBAGE -860 -1,200 -1,000 50-436.59 PUMP REPAIRS -300 -300 50-436.60 BUILDING REPAIRS -400 -300 50-436.61 EQUIPMENT REPAIRS -1,556 -2,500 -2,500 0 50-436.611 GOLF CART REPAIRS -600 -600 50-436.62 IRRIGATION REPAIRS -1,837 -1,000 -3,000 -2,000 50-436.64 COMPUTER PROGRAM MAINTENANCE -346 -300 -1,000 -700 TOTAL OPERATIONS -58,275 -60,000 -54,300 5,700 ****CAPITAL 50-436.712 IRRIGATION PUMP STAT-SHARED- Move to 2019-Discuss Option summer 2018- Original estimate $60,000 with $20,000 from water. Net Cost $40,000 0 TOTAL CAPITAL 0 0 0 0 ****OTHER 50-436.77 DEPRECIATION 50-436.95 SHOP EXPENSES -100 -300 -200 TOTAL OTHER 0 -100 -300 -200 TOTAL LEGACY COURSE EXPENSES -58,275 -60,400 -102,600 -42,200 TETON LAKES GOLF COURSE EXPENSES ****PERSONNEL 50-437.10 FT SALARY-GROUNDS MAINT-75%-26,500 -26,500 50-437.15 MARKETING/PT CITY HALL HELP -300 -300 50-437.16 PART-TIME WAGES-GROUNDS MAINT.-70,000 -70,000 50-437.161 PART-TIME WAGES-CLUBHOUSE ONLY -27,700 -27,700 50-437.162 PART-TIME WAGES-JANITOR -1,600 -1,600 50-437.163 PART-TIME WAGES-DRIVING RANGE -5,000 -5,000 50-437.20 BENEFITS -20,500 -20,500 50-437.27 UNIFORMS -100 -100 50-437.29 WELLNESS/RECREATION PROGRAMS -200 -200 TOTAL PERSONNEL 0 -300 -151,900 -151,600 ****OPERATIONS 50-437.30 SUPPLIES -6,257 -6,000 -5,800 Golf Budget Report for Operations City of Rexburg / Date: 03/05/2018 / Time: 13:20:40 Account Description 2017 Actual 2018 Budget 2018 Forecast Budget AJE 50-437.31 FERTILIZER -8,635 -13,000 -13,000 50-437.33 HERBICIDES/FUNGICIDES -6,642 -6,600 -6,600 50-437.35 FUEL & OIL -7,927 -8,000 -16,000 -8,000 50-437.36 SAND -3,850 -3,000 -3,000 50-437.39 SMALL TOOLS -1,698 -2,000 -1,800 50-437.40 DRUG TESTS & BACKGROUND CHECKS -500 -500 50-437.41 MANAGEMENT CONTRACT -201,450 -201,400 -85,300 116,100 50-437.42 ACCOUNTING/OVERHEAD -28,596 -29,300 -29,300 50-437.43 PUMP & TOILET RENTAL -963 -1,200 -1,100 50-437.44 HIRED WORK/TOOL RENT -450 -1,000 -9,000 -8,000 50-437.45 ADVERTISING/MARKETING -125 -500 -500 50-437.46 INSURANCE -1,105 -700 -800 -100 50-437.47 TRAINING, TRAVEL & MEETINGS -500 50-437.48 BANK & CREDIT CARD CHARGES -6,230 -6,200 -9,000 -2,800 50-437.51 TELEPHONE & INTERNET -869 -900 -1,700 -800 50-437.52 HEAT & LIGHTS -7,890 -6,200 -7,600 -1,400 50-437.53 PUMPING POWER-METERS READ -21,130 -29,400 -28,000 50-437.58 WATER/SEWER/GARBAGE -1,816 -2,100 -2,100 50-437.59 PUMP REPAIRS -1,500 -3,000 -1,500 50-437.60 BUILDING REPAIRS -1,060 -1,000 -2,000 50-437.61 EQUIPMENT REPAIRS -16,961 -17,000 -22,500 -5,500 50-437.611 GOLF CART REPAIRS -400 50-437.62 IRRIGATION REPAIRS -3,666 -1,600 -4,000 -2,400 50-437.64 COMPUTER PROGRAM MAINTENANCE -2,202 -1,300 -3,200 -1,900 50-437.69 MISCELLANEOUS -500 -500 TOTAL OPERATIONS -329,522 -339,900 -257,200 82,700 ****CAPITAL 50-437.708 ROUGH MOWER -12,000 50-437.718 NEW BRIDGES 50-437.720 MUNI SIDEWALK & FENCE 50-437.726 PUMP SCREEN & LINE ACROSS 14 -6,000 6,000 50-437.740 CUSHMAN UTILITY TRUCKSTER -8,000 -11,000 -3,000 50-437.741 HANDICAP RAMP -8,000 -8,000 50-437.742 HOOKUP WATER AT CLUBHOUSE -16,000 -16,000 50-437.743 PURCHASE CART/INVENTORY -50,100 -50,100 50-437.745 AERATOR-GREENS -23,500 -23,500 50-437.759 TOTAL TO BE DEPRECIATED TOTAL CAPITAL -12,000 -14,000 -108,600 -94,600 ****OTHER 50-437.77 DEPRECIATION Golf Budget Report for Operations City of Rexburg / Date: 03/05/2018 / Time: 13:20:40 Account Description 2017 Actual 2018 Budget 2018 Forecast Budget AJE 50-437.90 INTEREST -674 -900 -900 50-437.95 SHOP EXPENSES -300 -1,500 -1,200 TOTAL OTHER -674 -300 -2,400 -2,100 TOTAL TETON LAKES EXPENSES -342,196 -354,500 -520,100 -165,600 TOTAL GOLF COURSES EXPENSES -400,471 -414,900 -622,700 -207,800 GOLF OPERATIONS FUND NET -28,281 0 -73,600 GRAND TOTAL REVENUE:372,190 414,900 549,100 207,800 GRAND TOTAL EXPENSE:-400,471 -414,900 -622,700 -207,800 DIFFERENCE:-28,281 0 Projected YE Fund Balance (73,600)$ Subtract Beginning Carryover Deficit (38,600) Projected YE Operating Loss w/Capital (35,000) Added Capital Since Contract Analysis 47,500 Projected YE Operating Profit (Loss) w/o Added Capital 12,500$ Projected YE Operating Improvement Over Prior Year With Contract Changes 40,781$ Golf Construction Loan Fund Account Description 2017 Actual 2018 Budget 2018 Forecast GOLF COURSE CONST. REVENUES 51-376.10 COUNTY CONTRIBUTION 15,000 20,000 20,000 51-376.20 CITY CONTRIBUTION 20,000 20,000 51-399.20 FUND TFR - GENERAL FUND 15,000 51-399.90 FUND BALANCE CARRYOVER -578,100 TOTAL GOLF CONST. REVENUES 30,000 40,000 -538,100 GOLF COURSE CONST. EXPENSES 51-437.91 INTEREST EXPENSE -5,513 -6,000 -7,200 51-499.00 LOAN PAYBACK -34,000 TOTAL GOLF CONST. EXPENSES -5,513 -40,000 -7,200 GOLF COURSE CONST. FUND NET 24,486 -545,300