Loading...
HomeMy WebLinkAboutSept 23 Fin 4South Bend Venues, Parks and Arts Golf: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Charges for Services Culture & Recreation 347003 - Golf Season Pass 350.00 287,409.19 221,898.00 (65,511.19) 129.52% 347004 - Golf Green Fees 120,930.58 783,847.99 785,529.00 1,681.01 99.79% 347005 - Golf Cart Rentals 57,743.19 362,264.18 392,284.00 30,019.82 92.35% 347006 - Golf Pro Shop Retail 13,100.18 81,496.22 77,652.00 (3,844.22) 104.95% 347007 - Golf Driving Range 6,087.95 43,196.95 34,323.00 (8,873.95) 125.85% 347009 - Golf Outings 3,336.31 13,493.40 - (13,493.40) 0.00% 347012 - Food Sales 8,922.32 62,778.84 68,447.00 5,668.16 91.72% 347013 - Nonalcoholic Beverage 5,192.75 37,658.76 41,633.00 3,974.24 90.45% 347014 - Alcoholic Beverage Sales 22,821.45 153,821.32 151,573.00 (2,248.32) 101.48% 347026 - Room Rental 525.28 3,380.28 7,572.00 4,191.72 44.64% 347100 - Concessions-Employee Discounts (261.06) (2,065.19) - 2,065.19 0.00% Total Culture & Recreation 238,748.95 1,827,281.94 1,780,911.00 (46,370.94) 102.60% Total Charges for Services 238,748.95 1,827,281.94 1,780,911.00 (46,370.94) 102.60% Miscellaneous Revenue 360000 - Miscellaneous 297.24 4,878.88 1,483.00 (3,395.88) 328.99% Total Miscellaneous Revenue 297.24 4,878.88 1,483.00 (3,395.88) 328.99% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,524.82 - (4,524.82) 0.00% Total Refunds & Reimbursements - 4,524.82 - (4,524.82) 0.00% Other Sources 393000 - Capital Lease Proceeds - - 436,000.00 436,000.00 0.00% Total Other Sources - - 436,000.00 436,000.00 0.00% Total Revenue 239,046.19 1,836,685.64 2,218,394.00 381,708.36 82.79% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent of Account String Month Expenses Encumbrances w/ Encumb. Budget Budget Budget Personnel Expenses Salaries & Wages 410001 - Salaried Wages 42,126.67 310,285.52 - 310,285.52 434,369.00 124,083.48 71.43% 410002 - Teamster Wages - 3,387.25 - 3,387.25 90,248.00 86,860.75 3.75% 410003 - Permanent Part Time 70,162.24 312,467.04 - 312,467.04 295,201.00 (17,266.04) 105.85% 410004 - Extra & Overtime 1,806.56 4,780.21 - 4,780.21 2,550.00 (2,230.21) 187.46% 410005 - Seasonal & Interns 2,115.00 9,918.00 - 9,918.00 41,576.00 31,658.00 23.86% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 116,210.47 640,838.02 - 640,838.02 864,544.00 223,705.98 74.12% Employee Benefits 411001 - FICA Regular 8,810.37 53,035.43 - 53,035.43 66,330.00 13,294.57 79.96% 411004 - PERF Regular 4,724.32 35,092.37 - 35,092.37 59,369.00 24,276.63 59.11% 411005 - PERF Union - 25.52 - 25.52 1,426.00 1,400.48 1.79% 411007 - Unemployment Comp 4.04 30.20 - 30.20 633.00 602.80 4.77% 411008 - Health Insurance 5,961.54 56,110.06 - 56,110.06 126,094.00 69,983.94 44.50% 411009 - Life Insurance 60.00 625.00 - 625.00 1,080.00 455.00 57.87% 411010 - Med/Surgical/Dental 87.54 804.17 - 804.17 - (804.17) 0.00% 411014 - Parental Leave 147.19 1,111.23 - 1,111.23 1,847.00 735.77 60.16% 411015 - Other Fringe Benefits - 200.00 - 200.00 200.00 - 100.00% 411201 - Tool Allowance - - - - 800.00 800.00 0.00% 411203 - Job Readiness Allow. - - - - 850.00 850.00 0.00% 411206 - Cell Phone Allowance 55.00 495.00 - 495.00 660.00 165.00 75.00% September 30, 2023 Total Employee Benefits 19,850.00 147,528.98 - 147,528.98 259,289.00 111,760.02 56.90% Total Personnel Expenses 136,060.47 788,367.00 - 788,367.00 1,123,833.00 335,466.00 70.15% Supplies Expenses Office Supplies 421000 - General Office Supplies 134.10 1,037.24 - 1,037.24 1,500.00 462.76 69.15% Total Office Supplies 134.10 1,037.24 - 1,037.24 1,500.00 462.76 69.15% Operating Supplies 422000 - Other Operating Supplies 9,147.59 92,240.18 5,468.93 97,709.11 99,699.80 1,990.69 98.00% 422002 - Diesel/CNG 1,988.50 8,463.59 2,038.58 10,502.17 10,936.00 433.83 96.03% 422003 - Gasoline - 13,393.48 631.50 14,024.98 27,314.50 13,289.52 51.35% 422005 - Uniforms 257.63 4,090.76 - 4,090.76 3,631.00 (459.76) 112.66% 422008 - Medical/Safety Supplies - - - - 500.00 500.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer 5,250.53 108,224.99 4,991.63 113,216.62 144,019.00 30,802.38 78.61% 422014 - Concessions Inventory 5,478.87 110,019.79 1,359.96 111,379.75 132,780.96 21,401.21 83.88% 422016 - Inventory For Sale 1,411.77 61,982.39 2,205.31 64,187.70 69,742.21 5,554.51 92.04% Total Operating Supplies 23,534.89 398,415.18 16,695.91 415,111.09 488,623.47 73,512.38 84.96% Repair & Maintenance Supplies 423000 - Other R&M Supplies 5,859.22 37,968.84 6,589.07 44,557.91 46,197.93 1,640.02 96.45% 423006 - Small Tools & Equipment - 368.08 - 368.08 369.00 0.92 99.75% 423009 - Repair Parts 301.40 5,777.89 741.84 6,519.73 6,354.00 (165.73) 102.61% Total Repair & Maintenance Supplies 6,160.62 44,114.81 7,330.91 51,445.72 52,920.93 1,475.21 97.21% Total Supplies Expenses 29,829.61 443,567.23 24,026.82 467,594.05 543,044.40 75,450.35 86.11% Services & Charges Expenses Professional Services 431000 - Other Professional Services 1,750.00 29,004.03 6,818.00 35,822.03 37,062.00 1,239.97 96.65% 431019 - Security Services 336.04 3,427.05 - 3,427.05 4,200.00 772.95 81.60% Total Professional Services 2,086.04 32,431.08 6,818.00 39,249.08 41,262.00 2,012.92 95.12% Communication & Transportation 432002 - Mailing - 165.50 108.70 274.20 571.00 296.80 48.02% 432003 - Travel - 691.99 378.71 1,070.70 1,093.00 22.30 97.96% 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation - 857.49 496.54 1,354.03 2,073.13 719.10 65.31% Printing & Advertising 433003 - Promotional 2,189.10 46,394.77 - 46,394.77 57,000.00 10,605.23 81.39% Total Printing & Advertising 2,189.10 46,394.77 - 46,394.77 57,000.00 10,605.23 81.39% Utilties 435001 - Electric 6,782.59 57,724.96 - 57,724.96 68,664.00 10,939.04 84.07% 435002 - Natural Gas 470.19 15,332.13 - 15,332.13 26,645.00 11,312.87 57.54% Total Utilities 7,252.78 73,057.09 - 73,057.09 95,309.00 22,251.91 76.65% Repairs & Maintenance 436000 - Other R&M 753.33 9,987.48 - 9,987.48 22,998.00 13,010.52 43.43% 436005 - Other Equip R&M - - - - 1,050.00 1,050.00 0.00% Total Repairs & Maintenance 753.33 9,987.48 - 9,987.48 24,048.00 14,060.52 41.53% Rentals 437002 - Equipment Rental 2,115.60 11,212.50 - 11,212.50 11,407.00 194.50 98.29% Total Rentals 2,115.60 11,212.50 - 11,212.50 11,407.00 194.50 98.29% Debt Service 438100 - Principal - 95,184.68 394,615.82 489,800.50 495,299.00 5,498.50 98.89% 438200 - Interest - 21,589.23 71,861.44 93,450.67 73,035.00 (20,415.67) 127.95% 438300 - Paying Agent Fees - 250.00 - 250.00 - (250.00) 0.00% Total Debt Service - 117,023.91 466,477.26 583,501.17 568,334.00 (15,167.17) 102.67% Other Charges & Services 439000 - Misc Charges & Svcs 926.78 3,942.63 90.00 4,032.63 9,146.00 5,113.37 44.09% 439002 - Licenses & Permits - 697.24 - 697.24 3,268.00 2,570.76 21.34% 439003 - Subscriptions 72.99 3,424.91 - 3,424.91 3,633.00 208.09 94.27% 439004 - Dues & Memberships 949.65 2,016.63 - 2,016.63 2,000.00 (16.63) 100.83% 439005 - Bank & Credit Card Fees 5,742.12 46,244.16 - 46,244.16 46,390.00 145.84 99.69% 439006 - Education & Training 16.99 360.99 468.40 829.39 850.00 20.61 97.58% 439009 - Trash Removal 2,140.20 8,255.32 294.22 8,549.54 10,066.74 1,517.20 84.93% 439018 - Demolition & Clearance 900.00 18,000.00 - 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 4.74 2,051.52 - 2,051.52 - (2,051.52) 0.00% 439100 - Refunds/Awards/Indemnities - 12.38 - 12.38 1,757.00 1,744.62 0.70% Total Other Services & Charges 10,753.47 85,005.78 852.62 85,858.40 95,110.74 9,252.34 90.27% Total Services & Charges Expenses 25,150.32 375,970.10 474,644.42 850,614.52 894,543.87 43,929.35 95.09% Other Uses 452002 - Allocations-Admin Cost - 59,512.00 - 59,512.00 89,268.00 29,756.00 66.67% 452003 - Allocations-IT - 53,658.00 - 53,658.00 80,487.00 26,829.00 66.67% 452004 - Allocations-Liability Insurance - 9,394.64 - 9,394.64 14,092.00 4,697.36 66.67% 452009 - Allocations-Facilities Mgmt - 2,400.00 - 2,400.00 3,600.00 1,200.00 66.67% Total Other Uses - 124,964.64 - 124,964.64 187,447.00 62,482.36 66.67% Total Expenses 191,040.40 1,732,868.97 498,671.24 2,231,540.21 2,748,868.27 517,328.06 81.18%