Loading...
HomeMy WebLinkAboutMar 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 21,638.00 214,681.69 221,898.00 7,216.31 96.75% 347004 - Golf Green Fees 5,920.00 7,857.00 785,529.00 777,672.00 1.00% 347005 - Golf Cart Rentals 1,220.44 1,240.04 392,284.00 391,043.96 0.32% 347006 - Golf Pro Shop Retail 1,112.97 2,647.99 77,652.00 75,004.01 3.41% 347007 - Golf Driving Range 762.00 762.00 34,323.00 33,561.00 2.22% 347009 - Golf Outings 1,540.00 1,540.00 - (1,540.00) 0.00% 347012 - Food Sales 330.68 330.68 68,447.00 68,116.32 0.48% 347013 - Nonalcoholic Beverage 117.79 117.79 41,633.00 41,515.21 0.28% 347014 - Alcoholic Beverage Sales 804.21 1,306.00 151,573.00 150,267.00 0.86% 347026 - Room Rental - 250.00 7,572.00 7,322.00 3.30% 347100 - Concessions-Employee Discounts (5.67) (5.67) - 5.67 0.00% Total Culture & Recreation 33,440.42 230,727.52 1,780,911.00 1,550,183.48 12.96% Total Charges for Services 33,440.42 230,727.52 1,780,911.00 1,550,183.48 12.96% Miscellaneous Revenue 360000 - Miscellaneous 0.17 330.38 1,483.00 1,152.62 22.28% Total Miscellaneous Revenue 0.17 330.38 1,483.00 1,152.62 22.28% Refunds & Reimbursements 380000 - Misc Reimbursements 4,424.96 4,424.96 - (4,424.96) 0.00% Total Refunds & Reimbursements 4,424.96 4,424.96 - (4,424.96) 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 37,865.55 235,482.86 2,218,394.00 1,982,911.14 10.62% 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.62 97,440.63 - 97,440.63 434,369.00 336,928.37 22.43% 410002 - Teamster Wages - 3,387.25 - 3,387.25 90,248.00 86,860.75 3.75% 410003 - Permanent Part Time 5,508.08 8,726.55 - 8,726.55 295,201.00 286,474.45 2.96% 410004 - Extra & Overtime - 7.98 - 7.98 2,550.00 2,542.02 0.31% 410005 - Seasonal & Interns 204.00 228.00 - 228.00 41,776.00 41,548.00 0.55% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 47,838.70 109,790.41 - 109,790.41 864,744.00 754,953.59 12.70% Employee Benefits 411001 - FICA Regular 3,586.34 8,163.17 - 8,163.17 66,330.00 58,166.83 12.31% 411004 - PERF Regular 4,724.32 11,284.97 - 11,284.97 59,369.00 48,084.03 19.01% 411005 - PERF Union - 25.52 - 25.52 1,426.00 1,400.48 1.79% 411007 - Unemployment Comp 3.93 9.52 - 9.52 633.00 623.48 1.50% 411008 - Health Insurance 6,045.54 19,296.82 - 19,296.82 126,094.00 106,797.18 15.30% 411009 - Life Insurance 60.00 190.00 - 190.00 1,080.00 890.00 17.59% 411010 - Med/Surgical/Dental 87.54 278.93 - 278.93 - (278.93) 0.00% 411014 - Parental Leave 147.01 352.10 - 352.10 1,847.00 1,494.90 19.06% 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 0.00% 411206 - Cell Phone Allowance 55.00 165.00 - 165.00 660.00 495.00 25.00% March 31, 2023 Total Employee Benefits 14,709.68 39,966.03 - 39,966.03 259,089.00 219,122.97 15.43% Total Personnel Expenses 62,548.38 149,756.44 - 149,756.44 1,123,833.00 974,076.56 13.33% Supplies Expenses Office Supplies 421000 - General Office Supplies 220.42 288.40 - 288.40 1,000.00 711.60 28.84% Total Office Supplies 220.42 288.40 - 288.40 1,000.00 711.60 28.84% Operating Supplies 422000 - Other Operating Supplies 5,769.22 33,136.76 18,813.03 51,949.79 110,870.80 58,921.01 46.86% 422002 - Diesel/CNG - - 1,463.65 1,463.65 3,472.00 2,008.35 42.16% 422003 - Gasoline - - 2,962.44 2,962.44 27,314.50 24,352.06 10.85% 422005 - Uniforms 343.59 530.91 1,249.50 1,780.41 2,200.00 419.59 80.93% 422008 - Medical/Safety Supplies - - - - 500.00 500.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer 553.37 553.37 68,649.30 69,202.67 164,983.00 95,780.33 41.95% 422014 - Concessions Inventory 1,922.21 2,420.96 4,739.32 7,160.28 87,780.96 80,620.68 8.16% 422016 - Inventory For Sale 29,065.37 30,047.87 45,835.05 75,882.92 40,725.21 (35,157.71) 186.33% Total Operating Supplies 37,653.76 66,689.87 143,712.29 210,402.16 437,846.47 227,444.31 48.05% Repair & Maintenance Supplies 423000 - Other R&M Supplies 10,647.78 13,662.08 4,489.03 18,151.11 54,197.93 36,046.82 33.49% 423009 - Repair Parts 827.38 827.38 - 827.38 5,000.00 4,172.62 16.55% Total Repair & Maintenance Supplies 11,475.16 14,489.46 4,489.03 18,978.49 59,197.93 40,219.44 32.06% Total Supplies Expenses 49,349.34 81,467.73 148,201.32 229,669.05 498,044.40 268,375.35 46.11% Services & Charges Expenses Professional Services 431000 - Other Professional Services 2,493.90 3,690.64 17,000.00 20,690.64 35,337.00 14,646.36 58.55% 431019 - Security Services 367.91 1,156.57 - 1,156.57 6,200.00 5,043.43 18.65% Total Professional Services 2,861.81 4,847.21 17,000.00 21,847.21 41,537.00 19,689.79 52.60% Communication & Transportation 432002 - Mailing - - 550.00 550.00 550.00 - 100.00% 432003 - Travel - 691.99 378.71 1,070.70 - (1,070.70) 0.00% 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation - 691.99 937.84 1,629.83 959.13 (670.70) 169.93% Printing & Advertising 433003 - Promotional 15,648.05 19,252.00 8,000.00 27,252.00 57,000.00 29,748.00 47.81% Total Printing & Advertising 15,648.05 19,252.00 8,000.00 27,252.00 57,000.00 29,748.00 47.81% Utilties 435001 - Electric 6,829.67 15,664.20 - 15,664.20 68,664.00 52,999.80 22.81% 435002 - Natural Gas 2,994.97 9,987.43 - 9,987.43 26,645.00 16,657.57 37.48% Total Utilities 9,824.64 25,651.63 - 25,651.63 95,309.00 69,657.37 26.91% Repairs & Maintenance 436000 - Other R&M 1,356.80 1,906.80 1,500.00 3,406.80 27,630.00 24,223.20 12.33% 436005 - Other Equip R&M - - - - 1,050.00 1,050.00 0.00% Total Repairs & Maintenance 1,356.80 1,906.80 1,500.00 3,406.80 28,680.00 25,273.20 11.88% Rentals 437002 - Equipment Rental - 588.00 - 588.00 - (588.00) 0.00% Total Rentals - 588.00 - 588.00 - (588.00) 0.00% Debt Service 438100 - Principal - - - - 120,091.00 120,091.00 0.00% 438200 - Interest - - - - 12,243.00 12,243.00 0.00% Total Debt Service - - - - 132,334.00 132,334.00 0.00% Other Charges & Services 439000 - Misc Charges & Svcs 533.50 581.87 - 581.87 9,839.00 9,257.13 5.91% 439002 - Licenses & Permits 195.36 355.36 - 355.36 4,867.00 4,511.64 7.30% 439003 - Subscriptions 2,864.99 2,994.97 - 2,994.97 3,000.00 5.03 99.83% 439004 - Dues & Memberships 110.00 297.00 - 297.00 4,000.00 3,703.00 7.43% 439005 - Bank & Credit Card Fees 987.99 6,040.12 - 6,040.12 39,995.00 33,954.88 15.10% 439006 - Education & Training - 344.00 - 344.00 800.00 456.00 43.00% 439009 - Trash Removal 284.30 1,082.54 - 1,082.54 14,466.74 13,384.20 7.48% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 2.75 2.75 - 2.75 - (2.75) 0.00% 439100 - Refunds/Awards/Indemnities 6.54 10.28 - 10.28 1,757.00 1,746.72 0.59% Total Other Services & Charges 4,985.43 28,808.89 900.00 29,708.89 96,724.74 67,015.85 30.71% Total Services & Charges Expenses 34,676.73 81,746.52 28,337.84 110,084.36 452,543.87 342,459.51 24.33% Capital Outlay Machinery & Equipment 445108 - Lease Purchase/Other Equip - - - - 436,000.00 436,000.00 0.00% Total Machinery & Equipment - - - - 436,000.00 436,000.00 0.00% Total Capital Expenses - - - - 436,000.00 436,000.00 0.00% Other Uses 452002 - Allocations-Admin Cost - 7,439.00 - 7,439.00 89,268.00 81,829.00 8.33% 452003 - Allocations-IT - 6,707.25 - 6,707.25 80,487.00 73,779.75 8.33% 452004 - Allocations-Liability Insurance - 1,174.33 - 1,174.33 14,092.00 12,917.67 8.33% 452009 - Allocations-Facilities Mgmt - 300.00 - 300.00 3,600.00 3,300.00 8.33% Total Other Uses - 15,620.58 - 15,620.58 187,447.00 171,826.42 8.33% Total Expenses 146,574.45 328,591.27 176,539.16 505,130.43 2,697,868.27 2,192,737.84 18.72%