Loading...
HomeMy WebLinkAboutMar 24 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 25,453.00 237,176.25 230,000.00 (7,176.25) 103.12% 347004 - Golf Green Fees 18,289.00 22,996.00 820,000.00 797,004.00 2.80% 347005 - Golf Cart Rentals 7,863.07 8,508.73 400,000.00 391,491.27 2.13% 347006 - Golf Pro Shop Retail 2,915.59 3,481.45 87,000.00 83,518.55 4.00% 347007 - Golf Driving Range 751.00 751.00 45,000.00 44,249.00 1.67% 347009 - Golf Outings 2,240.00 2,240.00 - (2,240.00) 0.00% 347012 - Food Sales 1,133.25 1,168.29 72,500.00 71,331.71 1.61% 347013 - Nonalcoholic Beverage 628.96 724.55 44,000.00 43,275.45 1.65% 347014 - Alcoholic Beverage Sales 2,465.07 2,689.85 155,000.00 152,310.15 1.74% 347026 - Room Rental 525.00 625.00 10,000.00 9,375.00 6.25% 347100 - Concessions-Employee Discounts (45.30) (46.98) - 46.98 0.00% Total Culture & Recreation 62,218.64 280,314.14 1,863,500.00 1,583,185.86 15.04% Total Charges for Services 62,218.64 280,314.14 1,863,500.00 1,583,185.86 15.04% Miscellaneous Revenue 360000 - Miscellaneous 15.25 16.80 1,000.00 983.20 1.68% Total Miscellaneous Revenue 15.25 16.80 1,000.00 983.20 1.68% Refunds & Reimbursements 380000 - Misc Reimbursements 14.99 1,887.95 - (1,887.95) 0.00% Total Refunds & Reimbursements 14.99 1,887.95 - (1,887.95) 0.00% Other Sources 393000 - Capital Lease Proceeds - - 507,500.00 507,500.00 0.00% Total Other Sources - - 507,500.00 507,500.00 0.00% Total Revenue 62,248.88 282,218.89 2,372,000.00 2,089,781.11 11.90% 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 43,389.64 100,821.44 - 100,821.44 447,342.00 346,520.56 22.54% 410002 - Teamster Wages 5,093.50 14,652.48 - 14,652.48 92,052.00 77,399.52 15.92% 410003 - Permanent Part Time 15,314.36 20,035.59 - 20,035.59 293,601.00 273,565.41 6.82% 410004 - Extra & Overtime 395.13 551.17 - 551.17 2,550.00 1,998.83 21.61% 410005 - Seasonal & Interns 145.23 157.59 - 157.59 41,775.90 41,618.31 0.38% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 64,337.86 136,218.27 - 136,218.27 877,920.90 741,702.63 15.52% Employee Benefits 411001 - FICA Regular 4,928.23 10,403.73 - 10,403.73 67,460.06 57,056.33 15.42% 411004 - PERF Regular 5,480.52 13,057.26 - 13,057.26 61,023.65 47,966.39 21.40% 411005 - PERF Union 82.33 192.79 - 192.79 1,452.78 1,259.99 13.27% 411007 - Unemployment Comp 4.81 11.39 - 11.39 651.05 639.66 1.75% 411008 - Health Insurance 8,218.60 24,676.63 - 24,676.63 141,393.60 116,716.97 17.45% 411009 - Life Insurance 80.00 240.00 - 240.00 1,080.00 840.00 22.22% 411010 - Med/Surgical/Dental 118.02 354.06 - 354.06 1,600.00 1,245.94 22.13% 411014 - Parental Leave 172.04 407.19 - 407.19 1,790.40 1,383.21 22.74% 411015 - Other Fringe Benefits - 200.00 - 200.00 - (200.00) 0.00% 411201 - Tool Allowance - - - - 800.00 800.00 0.00% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 100.00% 411206 - Cell Phone Allowance 55.00 165.00 - 165.00 660.00 495.00 25.00% March 31, 2024 Total Employee Benefits 19,139.55 50,558.05 - 50,558.05 278,761.54 228,203.49 18.14% Total Personnel Expenses 83,477.41 186,776.32 - 186,776.32 1,156,682.44 969,906.12 16.15% Supplies Expenses Office Supplies 421000 - General Office Supplies 136.37 515.99 - 515.99 1,500.00 984.01 34.40% Total Office Supplies 136.37 515.99 - 515.99 1,500.00 984.01 34.40% Operating Supplies 422000 - Other Operating Supplies 6,067.75 25,700.66 2,652.18 28,352.84 84,540.13 56,187.29 33.54% 422002 - Diesel/CNG - - - - 3,645.00 3,645.00 0.00% 422003 - Gasoline - 1,462.50 897.90 2,360.40 25,564.90 23,204.50 9.23% 422005 - Uniforms 134.22 839.85 - 839.85 2,200.00 1,360.15 38.18% 422008 - Medical/Safety Supplies 288.87 288.87 - 288.87 500.00 211.13 57.77% 422010 - Plants Chemicals Seed & Fertilizer - - 74,195.47 74,195.47 122,000.00 47,804.53 60.82% 422014 - Concessions Inventory 9,955.97 9,955.97 - 9,955.97 123,500.00 113,544.03 8.06% 422016 - Inventory For Sale 10,242.61 50,910.67 25,889.80 76,800.47 81,000.00 4,199.53 94.82% Total Operating Supplies 26,689.42 89,158.52 103,635.35 192,793.87 442,950.03 250,156.16 43.52% Repair & Maintenance Supplies 423000 - Other R&M Supplies 7,418.52 9,137.79 1,275.13 10,412.92 83,958.52 73,545.60 12.40% 423006 - Small Tools & Equipment 1,221.16 1,897.92 - 1,897.92 6,000.00 4,102.08 31.63% 423009 - Repair Parts 1,186.24 1,356.23 - 1,356.23 7,000.00 5,643.77 19.37% Total Repair & Maintenance Supplies 9,825.92 12,391.94 1,275.13 13,667.07 96,958.52 83,291.45 14.10% Total Supplies Expenses 36,651.71 102,066.45 104,910.48 206,976.93 541,408.55 334,431.62 38.23% Services & Charges Expenses Professional Services 431000 - Other Professional Services 4,390.20 13,634.38 6,818.00 20,452.38 32,748.00 12,295.62 62.45% 431019 - Security Services 38.25 1,216.74 - 1,216.74 5,000.00 3,783.26 24.33% Total Professional Services 4,428.45 14,851.12 6,818.00 21,669.12 37,748.00 16,078.88 57.40% Communication & Transportation 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation - - 9.13 9.13 409.13 400.00 2.23% Printing & Advertising 433001 - Outside Printing Services - - 42.75 42.75 100.00 57.25 42.75% 433003 - Promotional 3,755.10 20,854.85 3,176.00 24,030.85 57,000.00 32,969.15 42.16% Total Printing & Advertising 3,755.10 20,854.85 3,218.75 24,073.60 57,100.00 33,026.40 42.16% Utilties 435001 - Electric 4,405.50 10,911.24 - 10,911.24 70,000.00 59,088.76 15.59% 435002 - Natural Gas 3,643.26 9,424.67 - 9,424.67 25,000.00 15,575.33 37.70% Total Utilities 8,048.76 20,335.91 - 20,335.91 95,000.00 74,664.09 21.41% Repairs & Maintenance 436000 - Other R&M 525.00 525.00 394.00 919.00 15,000.00 14,081.00 6.13% 436005 - Other Equip R&M - - - - 1,050.00 1,050.00 0.00% Total Repairs & Maintenance 525.00 525.00 394.00 919.00 16,050.00 15,131.00 5.73% Rentals 437002 - Equipment Rental 220.38 1,672.38 - 1,672.38 4,500.00 2,827.62 37.16% Total Rentals 220.38 1,672.38 - 1,672.38 4,500.00 2,827.62 37.16% Debt Service 438100 - Principal - - 394,615.82 394,615.82 455,532.01 60,916.19 86.63% 438200 - Interest - - 71,861.44 71,861.44 88,691.46 16,830.02 81.02% Total Debt Service - - 466,477.26 466,477.26 544,223.47 77,746.21 85.71% Other Charges & Services 439000 - Misc Charges & Svcs 7,015.18 11,002.47 90.00 11,092.47 12,090.00 997.53 91.75% 439002 - Licenses & Permits 146.52 2,394.20 - 2,394.20 5,100.00 2,705.80 46.95% 439003 - Subscriptions 3,012.99 3,158.97 - 3,158.97 1,500.00 (1,658.97) 210.60% 439004 - Dues & Memberships - 279.11 - 279.11 1,050.00 770.89 26.58% 439005 - Bank & Credit Card Fees 1,753.93 7,473.36 - 7,473.36 50,500.00 43,026.64 14.80% 439006 - Education & Training - - - - 1,287.17 1,287.17 0.00% 439009 - Trash Removal 327.09 1,867.10 7,400.30 9,267.40 10,035.76 768.36 92.34% 439099 - Cashier Over/Short (16.34) (16.34) - (16.34) 400.00 416.34 (4.09%) 439100 - Refunds/Awards/Indemnities - - - - 1,818.00 1,818.00 0.00% Total Other Services & Charges 12,239.37 26,158.87 7,490.30 33,649.17 83,780.93 50,131.76 40.16% Total Services & Charges Expenses 29,217.06 84,398.13 484,407.44 568,805.57 838,811.53 270,005.96 67.81% Capital Outlay Machinery & Equipment 445006 - Computer Equip/Network - 37,300.00 - 37,300.00 37,300.00 - 100.00% 445108 - Lease Purchase/Other Equip - - - - 115,208.00 115,208.00 0.00% Total Machinery & Equipment - 37,300.00 - 37,300.00 152,508.00 115,208.00 24.46% Total Capital Expenses - 37,300.00 - 37,300.00 152,508.00 115,208.00 24.46% Other Uses 452002 - Allocations-Admin Cost 7,257.89 21,773.67 - 21,773.67 87,094.66 65,320.99 25.00% 452003 - Allocations-IT 7,526.94 22,580.82 - 22,580.82 90,323.24 67,742.42 25.00% 452004 - Allocations-Liability Insurance 1,190.75 3,572.25 - 3,572.25 14,289.00 10,716.75 25.00% 452009 - Allocations-Facilities Mgmt 294.35 883.05 - 883.05 3,532.23 2,649.18 25.00% Total Other Uses 16,269.93 48,809.79 - 48,809.79 195,239.13 146,429.34 25.00% Total Expenses 165,616.11 459,350.69 589,317.92 1,048,668.61 2,884,649.65 1,835,981.04 36.35%