Loading...
HomeMy WebLinkAboutFeb 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 48,824.25 211,723.25 230,000.00 18,276.75 92.05% 347004 - Golf Green Fees 4,707.00 4,707.00 820,000.00 815,293.00 0.57% 347005 - Golf Cart Rentals 645.66 645.66 400,000.00 399,354.34 0.16% 347006 - Golf Pro Shop Retail 387.42 565.86 87,000.00 86,434.14 0.65% 347007 - Golf Driving Range - - 45,000.00 45,000.00 0.00% 347012 - Food Sales 35.04 35.04 72,500.00 72,464.96 0.05% 347013 - Nonalcoholic Beverage 94.66 95.59 44,000.00 43,904.41 0.22% 347014 - Alcoholic Beverage Sales 220.11 224.78 155,000.00 154,775.22 0.15% 347026 - Room Rental 100.00 100.00 10,000.00 9,900.00 1.00% 347100 - Concessions-Employee Discounts (1.68) (1.68) - 1.68 0.00% Total Culture & Recreation 55,012.46 218,095.50 1,863,500.00 1,645,404.50 11.70% Total Charges for Services 55,012.46 218,095.50 1,863,500.00 1,645,404.50 11.70% Miscellaneous Revenue 360000 - Miscellaneous 0.03 1.55 1,000.00 998.45 0.16% Total Miscellaneous Revenue 0.03 1.55 1,000.00 998.45 0.16% Refunds & Reimbursements 380000 - Misc Reimbursements 1,872.96 1,872.96 - (1,872.96) 0.00% Total Refunds & Reimbursements 1,872.96 1,872.96 - (1,872.96) 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 56,885.45 219,970.01 2,372,000.00 2,152,029.99 9.27% 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,926.40 57,431.80 - 57,431.80 447,342.00 389,910.20 12.84% 410002 - Teamster Wages 4,744.38 9,558.98 - 9,558.98 92,052.00 82,493.02 10.38% 410003 - Permanent Part Time 2,587.20 4,721.23 - 4,721.23 293,601.00 288,879.77 1.61% 410004 - Extra & Overtime 16.60 156.04 - 156.04 2,550.00 2,393.96 6.12% 410005 - Seasonal & Interns - 12.36 - 12.36 41,775.90 41,763.54 0.03% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 36,274.58 71,880.41 - 71,880.41 877,920.90 806,040.49 8.19% Employee Benefits 411001 - FICA Regular 2,740.67 5,475.50 - 5,475.50 67,460.06 61,984.56 8.12% 411004 - PERF Regular 3,759.71 7,576.74 - 7,576.74 61,023.65 53,446.91 12.42% 411005 - PERF Union 53.20 110.46 - 110.46 1,452.78 1,342.32 7.60% 411007 - Unemployment Comp 3.32 6.58 - 6.58 651.05 644.47 1.01% 411008 - Health Insurance 8,218.60 16,458.03 - 16,458.03 141,393.60 124,935.57 11.64% 411009 - Life Insurance 80.00 160.00 - 160.00 1,080.00 920.00 14.81% 411010 - Med/Surgical/Dental 118.02 236.04 - 236.04 1,600.00 1,363.96 14.75% 411014 - Parental Leave 118.07 235.15 - 235.15 1,790.40 1,555.25 13.13% 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 110.00 - 110.00 660.00 550.00 16.67% Total Employee Benefits 15,146.59 31,218.50 - 31,218.50 278,761.54 247,543.04 11.20% February 29, 2024 Total Personnel Expenses 51,421.17 103,098.91 - 103,098.91 1,156,682.44 1,053,583.53 8.91% Supplies Expenses Office Supplies 421000 - General Office Supplies 162.63 379.62 - 379.62 1,500.00 1,120.38 25.31% Total Office Supplies 162.63 379.62 - 379.62 1,500.00 1,120.38 25.31% Operating Supplies 422000 - Other Operating Supplies 18,422.27 19,632.91 5,596.63 25,229.54 87,540.13 62,310.59 28.82% 422002 - Diesel/CNG - - - - 3,645.00 3,645.00 0.00% 422003 - Gasoline 1,462.50 1,462.50 897.90 2,360.40 25,564.90 23,204.50 9.23% 422005 - Uniforms 534.22 705.63 - 705.63 2,200.00 1,494.37 32.07% 422008 - Medical/Safety Supplies - - - - 500.00 500.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer - - 74,195.47 74,195.47 122,000.00 47,804.53 60.82% 422014 - Concessions Inventory - - - - 123,500.00 123,500.00 0.00% 422016 - Inventory For Sale 40,296.82 40,668.06 32,476.18 73,144.24 81,000.00 7,855.76 90.30% Total Operating Supplies 60,715.81 62,469.10 113,166.18 175,635.28 445,950.03 270,314.75 39.38% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,658.88 1,719.27 5,130.60 6,849.87 83,958.52 77,108.65 8.16% 423006 - Small Tools & Equipment - 676.76 - 676.76 3,000.00 2,323.24 22.56% 423009 - Repair Parts 169.99 169.99 - 169.99 7,000.00 6,830.01 2.43% Total Repair & Maintenance Supplies 1,828.87 2,566.02 5,130.60 7,696.62 93,958.52 86,261.90 8.19% Total Supplies Expenses 62,707.31 65,414.74 118,296.78 183,711.52 541,408.55 357,697.03 33.93% Services & Charges Expenses Professional Services 431000 - Other Professional Services 2,978.31 9,244.18 10,933.20 20,177.38 33,098.00 12,920.62 60.96% 431019 - Security Services 527.80 1,178.49 - 1,178.49 5,000.00 3,821.51 23.57% Total Professional Services 3,506.11 10,422.67 10,933.20 21,355.87 38,098.00 16,742.13 56.06% 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 15,867.85 17,099.75 - 17,099.75 57,000.00 39,900.25 30.00% Total Printing & Advertising 15,867.85 17,099.75 - 17,099.75 57,000.00 39,900.25 30.00% Utilties 435001 - Electric 3,259.85 6,505.74 - 6,505.74 70,000.00 63,494.26 9.29% 435002 - Natural Gas 3,529.72 5,781.41 - 5,781.41 25,000.00 19,218.59 23.13% Total Utilities 6,789.57 12,287.15 - 12,287.15 95,000.00 82,712.85 12.93% Repairs & Maintenance 436000 - Other R&M - - - - 15,000.00 15,000.00 0.00% 436005 - Other Equip R&M - - - - 1,050.00 1,050.00 0.00% Total Repairs & Maintenance - - - - 16,050.00 16,050.00 0.00% Rentals 437002 - Equipment Rental - 1,452.00 - 1,452.00 4,500.00 3,048.00 32.27% Total Rentals - 1,452.00 - 1,452.00 4,500.00 3,048.00 32.27% 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 249.52 3,987.29 5,785.10 9,772.39 12,090.00 2,317.61 80.83% 439002 - Licenses & Permits 97.68 2,247.68 - 2,247.68 5,000.00 2,752.32 44.95% 439003 - Subscriptions 72.99 145.98 - 145.98 1,500.00 1,354.02 9.73% 439004 - Dues & Memberships 279.11 279.11 - 279.11 1,050.00 770.89 26.58% 439005 - Bank & Credit Card Fees 1,507.89 5,719.43 - 5,719.43 50,500.00 44,780.57 11.33% 439006 - Education & Training - - 337.17 337.17 1,137.17 800.00 29.65% 439009 - Trash Removal 1,213.74 1,540.01 7,727.39 9,267.40 10,035.76 768.36 92.34% 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 3,420.93 13,919.50 13,849.66 27,769.16 83,530.93 55,761.77 33.24% Total Services & Charges Expenses 29,584.46 55,181.07 491,269.25 546,450.32 838,811.53 292,361.21 65.15% Capital Outlay Machinery & Equipment 445006 - Computer Equip/Network 37,300.00 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 - 37,300.00 152,508.00 115,208.00 24.46% Total Capital Expenses 37,300.00 37,300.00 - 37,300.00 152,508.00 115,208.00 24.46% Other Uses 452002 - Allocations-Admin Cost 7,257.89 14,515.78 - 14,515.78 87,094.66 72,578.88 16.67% 452003 - Allocations-IT 7,526.94 15,053.88 - 15,053.88 90,323.24 75,269.36 16.67% 452004 - Allocations-Liability Insurance 1,190.75 2,381.50 - 2,381.50 14,289.00 11,907.50 16.67% 452009 - Allocations-Facilities Mgmt 294.35 588.70 - 588.70 3,532.23 2,943.53 16.67% Total Other Uses 16,269.93 32,539.86 - 32,539.86 195,239.13 162,699.27 16.67% Total Expenses 197,282.87 293,534.58 609,566.03 903,100.61 2,884,649.65 1,981,549.04 31.31%