Loading...
HomeMy WebLinkAboutJan 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 162,899.00 162,899.00 230,000.00 67,101.00 70.83% 347004 - Golf Green Fees - - 820,000.00 820,000.00 0.00% 347005 - Golf Cart Rentals - - 400,000.00 400,000.00 0.00% 347006 - Golf Pro Shop Retail 178.44 178.44 87,000.00 86,821.56 0.21% 347007 - Golf Driving Range - - 45,000.00 45,000.00 0.00% 347012 - Food Sales - - 72,500.00 72,500.00 0.00% 347013 - Nonalcoholic Beverage - - 44,000.00 44,000.00 0.00% 347014 - Alcoholic Beverage Sales - - 155,000.00 155,000.00 0.00% 347026 - Room Rental - - 10,000.00 10,000.00 0.00% Total Culture & Recreation 163,077.44 163,077.44 1,863,500.00 1,700,422.56 8.75% Total Charges for Services 163,077.44 163,077.44 1,863,500.00 1,700,422.56 8.75% Miscellaneous Revenue 360000 - Miscellaneous 1.52 1.52 1,000.00 998.48 0.15% Total Miscellaneous Revenue 1.52 1.52 1,000.00 998.48 0.15% 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 163,078.96 163,078.96 2,372,000.00 2,208,921.04 6.88% 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 28,505.40 28,505.40 - 28,505.40 447,342.00 418,836.60 6.37% 410002 - Teamster Wages 4,814.60 4,814.60 - 4,814.60 92,052.00 87,237.40 5.23% 410003 - Permanent Part Time 2,134.03 2,134.03 - 2,134.03 295,201.00 293,066.97 0.72% 410004 - Extra & Overtime 139.44 139.44 - 139.44 2,550.00 2,410.56 5.47% 410005 - Seasonal & Interns 12.36 12.36 - 12.36 41,775.90 41,763.54 0.03% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 35,605.83 35,605.83 - 35,605.83 879,520.90 843,915.07 4.05% Employee Benefits 411001 - FICA Regular 2,734.83 2,734.83 - 2,734.83 67,460.06 64,725.23 4.05% 411004 - PERF Regular 3,817.03 3,817.03 - 3,817.03 61,023.65 57,206.62 6.26% 411005 - PERF Union 57.26 57.26 - 57.26 1,452.78 1,395.52 3.94% 411007 - Unemployment Comp 3.26 3.26 - 3.26 651.05 647.79 0.50% 411008 - Health Insurance 8,239.43 8,239.43 - 8,239.43 141,393.60 133,154.17 5.83% 411009 - Life Insurance 80.00 80.00 - 80.00 1,080.00 1,000.00 7.41% 411010 - Med/Surgical/Dental 118.02 118.02 - 118.02 - (118.02) 0.00% 411014 - Parental Leave 117.08 117.08 - 117.08 1,790.40 1,673.32 6.54% 411201 - Tool Allowance - - - - 800.00 800.00 0.00% 411203 - Job Readiness Allow. 850.00 850.00 - 850.00 850.00 - 100.00% 411206 - Cell Phone Allowance 55.00 55.00 - 55.00 660.00 605.00 8.33% Total Employee Benefits 16,071.91 16,071.91 - 16,071.91 277,161.54 261,089.63 5.80% Total Personnel Expenses 51,677.74 51,677.74 - 51,677.74 1,156,682.44 1,105,004.70 4.47% Supplies Expenses Office Supplies 421000 - General Office Supplies 216.99 216.99 - 216.99 1,000.00 783.01 21.70% January 31, 2024 Total Office Supplies 216.99 216.99 - 216.99 1,000.00 783.01 21.70% Operating Supplies 422000 - Other Operating Supplies 1,210.64 1,210.64 10,040.13 11,250.77 88,040.13 76,789.36 12.78% 422002 - Diesel/CNG - - - - 3,645.00 3,645.00 0.00% 422003 - Gasoline - - 897.90 897.90 25,564.90 24,667.00 3.51% 422005 - Uniforms 171.41 171.41 - 171.41 2,200.00 2,028.59 7.79% 422008 - Medical/Safety Supplies - - - - 500.00 500.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer - - - - 135,000.00 135,000.00 0.00% 422014 - Concessions Inventory - - - - 123,500.00 123,500.00 0.00% 422016 - Inventory For Sale 371.24 371.24 72,773.00 73,144.24 68,000.00 (5,144.24) 107.57% Total Operating Supplies 1,753.29 1,753.29 83,711.03 85,464.32 446,450.03 360,985.71 19.14% Repair & Maintenance Supplies 423000 - Other R&M Supplies 60.39 60.39 3,458.52 3,518.91 88,958.52 85,439.61 3.96% 423006 - Small Tools & Equipment 676.76 676.76 - 676.76 - (676.76) 0.00% 423009 - Repair Parts - - - - 5,000.00 5,000.00 0.00% Total Repair & Maintenance Supplies 737.15 737.15 3,458.52 4,195.67 93,958.52 89,762.85 4.47% Total Supplies Expenses 2,707.43 2,707.43 87,169.55 89,876.98 541,408.55 451,531.57 16.60% Services & Charges Expenses Professional Services 431000 - Other Professional Services 6,265.87 6,265.87 6,818.00 13,083.87 35,098.00 22,014.13 37.28% 431019 - Security Services 650.69 650.69 - 650.69 5,000.00 4,349.31 13.01% Total Professional Services 6,916.56 6,916.56 6,818.00 13,734.56 40,098.00 26,363.44 34.25% 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 433003 - Promotional 1,231.90 1,231.90 - 1,231.90 57,000.00 55,768.10 2.16% Total Printing & Advertising 1,231.90 1,231.90 - 1,231.90 57,000.00 55,768.10 2.16% Utilties 435001 - Electric 3,245.89 3,245.89 - 3,245.89 70,000.00 66,754.11 4.64% 435002 - Natural Gas 2,251.69 2,251.69 - 2,251.69 25,000.00 22,748.31 9.01% Total Utilities 5,497.58 5,497.58 - 5,497.58 95,000.00 89,502.42 5.79% Repairs & Maintenance 436000 - Other R&M - - - - 19,000.00 19,000.00 0.00% 436005 - Other Equip R&M - - - - 1,050.00 1,050.00 0.00% Total Repairs & Maintenance - - - - 20,050.00 20,050.00 0.00% Rentals 437002 - Equipment Rental 1,452.00 1,452.00 - 1,452.00 1,500.00 48.00 96.80% Total Rentals 1,452.00 1,452.00 - 1,452.00 1,500.00 48.00 96.80% 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 3,737.77 3,737.77 90.00 3,827.77 8,090.00 4,262.23 47.31% 439002 - Licenses & Permits 2,150.00 2,150.00 - 2,150.00 6,000.00 3,850.00 35.83% 439003 - Subscriptions 72.99 72.99 - 72.99 1,500.00 1,427.01 4.87% 439004 - Dues & Memberships - - - - 1,050.00 1,050.00 0.00% 439005 - Bank & Credit Card Fees 4,211.18 4,211.18 - 4,211.18 50,500.00 46,288.82 8.34% 439006 - Education & Training - - 337.17 337.17 1,137.17 800.00 29.65% 439009 - Trash Removal 326.27 326.27 8,739.49 9,065.76 10,035.76 970.00 90.33% 439099 - Cashier Over/Short - - - - 400.00 400.00 0.00% 439100 - Refunds/Awards/Indemnities - - - - 1,818.00 1,818.00 0.00% Total Other Services & Charges 10,498.21 10,498.21 9,166.66 19,664.87 80,530.93 60,866.06 24.42% Total Services & Charges Expenses 25,596.25 25,596.25 482,471.05 508,067.30 838,811.53 330,744.23 60.57% Capital Outlay Machinery & Equipment 445108 - Lease Purchase/Other Equip - - - - 152,508.00 152,508.00 0.00% Total Machinery & Equipment - - - - 152,508.00 152,508.00 0.00% Total Capital Expenses - - - - 152,508.00 152,508.00 0.00% Other Uses 452002 - Allocations-Admin Cost - - - - 87,094.66 87,094.66 0.00% 452003 - Allocations-IT - - - - 90,323.24 90,323.24 0.00% 452004 - Allocations-Liability Insurance - - - - 14,289.00 14,289.00 0.00% 452009 - Allocations-Facilities Mgmt - - - - 3,532.23 3,532.23 0.00% Total Other Uses - - - - 195,239.13 195,239.13 0.00% Total Expenses 79,981.42 79,981.42 569,640.60 649,622.02 2,884,649.65 2,235,027.63 22.52%