Loading...
HomeMy WebLinkAboutApr 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 33,333.50 248,015.19 221,898.00 (26,117.19) 111.77% 347004 - Golf Green Fees 52,133.40 59,990.40 785,529.00 725,538.60 7.64% 347005 - Golf Cart Rentals 24,138.74 25,378.78 392,284.00 366,905.22 6.47% 347006 - Golf Pro Shop Retail 9,237.22 11,885.21 77,652.00 65,766.79 15.31% 347007 - Golf Driving Range 4,656.00 5,418.00 34,323.00 28,905.00 15.79% 347009 - Golf Outings 490.00 2,030.00 - (2,030.00) 0.00% 347012 - Food Sales 4,513.59 4,844.27 68,447.00 63,602.73 7.08% 347013 - Nonalcoholic Beverage 2,497.92 2,615.71 41,633.00 39,017.29 6.28% 347014 - Alcoholic Beverage Sales 9,953.78 11,259.78 151,573.00 140,313.22 7.43% 347026 - Room Rental 150.00 400.00 7,572.00 7,172.00 5.28% 347100 - Concessions-Employee Discounts (198.73) (204.40) - 204.40 0.00% Total Culture & Recreation 140,905.42 371,632.94 1,780,911.00 1,409,278.06 20.87% Total Charges for Services 140,905.42 371,632.94 1,780,911.00 1,409,278.06 20.87% Miscellaneous Revenue 360000 - Miscellaneous 143.64 474.02 1,483.00 1,008.98 31.96% Total Miscellaneous Revenue 143.64 474.02 1,483.00 1,008.98 31.96% Refunds & Reimbursements 380000 - Misc Reimbursements 73.79 4,498.75 - (4,498.75) 0.00% Total Refunds & Reimbursements 73.79 4,498.75 - (4,498.75) 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 141,122.85 376,605.71 2,218,394.00 1,841,788.29 16.98% 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,084.36 125,524.99 - 125,524.99 434,369.00 308,844.01 28.90% 410002 - Teamster Wages - 3,387.25 - 3,387.25 90,248.00 86,860.75 3.75% 410003 - Permanent Part Time 28,907.47 37,634.02 - 37,634.02 295,201.00 257,566.98 12.75% 410004 - Extra & Overtime 161.25 169.23 - 169.23 2,550.00 2,380.77 6.64% 410005 - Seasonal & Interns 990.00 1,218.00 - 1,218.00 41,776.00 40,558.00 2.92% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 58,143.08 167,933.49 - 167,933.49 864,744.00 696,810.51 19.42% Employee Benefits 411001 - FICA Regular 4,368.01 12,531.18 - 12,531.18 66,330.00 53,798.82 18.89% 411004 - PERF Regular 3,151.60 14,436.57 - 14,436.57 59,369.00 44,932.43 24.32% 411005 - PERF Union - 25.52 - 25.52 1,426.00 1,400.48 1.79% 411007 - Unemployment Comp 2.64 12.16 - 12.16 633.00 620.84 1.92% 411008 - Health Insurance 5,961.54 25,258.36 - 25,258.36 126,094.00 100,835.64 20.03% 411009 - Life Insurance 60.00 250.00 - 250.00 1,080.00 830.00 23.15% 411010 - Med/Surgical/Dental 87.54 366.47 - 366.47 - (366.47) 0.00% 411014 - Parental Leave 98.00 450.10 - 450.10 1,847.00 1,396.90 24.37% 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 220.00 - 220.00 660.00 440.00 33.33% April 30, 2023 Total Employee Benefits 13,784.33 53,750.36 - 53,750.36 259,089.00 205,338.64 20.75% Total Personnel Expenses 71,927.41 221,683.85 - 221,683.85 1,123,833.00 902,149.15 19.73% Supplies Expenses Office Supplies 421000 - General Office Supplies 119.98 408.38 - 408.38 1,000.00 591.62 40.84% Total Office Supplies 119.98 408.38 - 408.38 1,000.00 591.62 40.84% Operating Supplies 422000 - Other Operating Supplies 9,369.82 42,506.58 22,741.92 65,248.50 110,870.80 45,622.30 58.85% 422002 - Diesel/CNG 1,463.65 1,463.65 - 1,463.65 3,472.00 2,008.35 42.16% 422003 - Gasoline 2,330.94 2,330.94 631.50 2,962.44 27,314.50 24,352.06 10.85% 422005 - Uniforms 964.95 1,495.86 1,249.50 2,745.36 2,200.00 (545.36) 124.79% 422008 - Medical/Safety Supplies - - - - 500.00 500.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer 2,782.65 3,336.02 88,642.64 91,978.66 164,983.00 73,004.34 55.75% 422014 - Concessions Inventory 15,686.53 18,107.49 1,359.96 19,467.45 87,780.96 68,313.51 22.18% 422016 - Inventory For Sale 6,322.15 36,370.02 43,269.95 79,639.97 40,725.21 (38,914.76) 195.55% Total Operating Supplies 38,920.69 105,610.56 157,895.47 263,506.03 437,846.47 174,340.44 60.18% Repair & Maintenance Supplies 423000 - Other R&M Supplies 4,830.03 18,492.11 2,686.93 21,179.04 54,197.93 33,018.89 39.08% 423009 - Repair Parts 43.13 870.51 - 870.51 5,000.00 4,129.49 17.41% Total Repair & Maintenance Supplies 4,873.16 19,362.62 2,686.93 22,049.55 59,197.93 37,148.38 37.25% Total Supplies Expenses 43,913.83 125,381.56 160,582.40 285,963.96 498,044.40 212,080.44 57.42% Services & Charges Expenses Professional Services 431000 - Other Professional Services 723.00 4,413.64 17,000.00 21,413.64 35,337.00 13,923.36 60.60% 431019 - Security Services 291.41 1,447.98 - 1,447.98 6,200.00 4,752.02 23.35% Total Professional Services 1,014.41 5,861.62 17,000.00 22,861.62 41,537.00 18,675.38 55.04% 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 9,659.55 28,911.55 8,000.00 36,911.55 57,000.00 20,088.45 64.76% Total Printing & Advertising 9,659.55 28,911.55 8,000.00 36,911.55 57,000.00 20,088.45 64.76% Utilties 435001 - Electric 4,105.98 19,770.18 - 19,770.18 68,664.00 48,893.82 28.79% 435002 - Natural Gas 2,200.08 12,187.51 - 12,187.51 26,645.00 14,457.49 45.74% Total Utilities 6,306.06 31,957.69 - 31,957.69 95,309.00 63,351.31 33.53% Repairs & Maintenance 436000 - Other R&M - 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,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 147.06 728.93 - 728.93 9,839.00 9,110.07 7.41% 439002 - Licenses & Permits 48.84 404.20 - 404.20 4,867.00 4,462.80 8.30% 439003 - Subscriptions 64.99 3,059.96 - 3,059.96 3,000.00 (59.96) 102.00% 439004 - Dues & Memberships - 297.00 - 297.00 4,000.00 3,703.00 7.43% 439005 - Bank & Credit Card Fees 3,735.56 9,775.68 - 9,775.68 39,995.00 30,219.32 24.44% 439006 - Education & Training - 344.00 - 344.00 800.00 456.00 43.00% 439009 - Trash Removal 1,019.82 2,102.36 - 2,102.36 14,466.74 12,364.38 14.53% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (416.37) (413.62) - (413.62) - 413.62 0.00% 439100 - Refunds/Awards/Indemnities 2.10 12.38 - 12.38 1,757.00 1,744.62 0.70% Total Other Services & Charges 4,602.00 33,410.89 900.00 34,310.89 96,724.74 62,413.85 35.47% Total Services & Charges Expenses 21,582.02 103,328.54 28,337.84 131,666.38 452,543.87 320,877.49 29.09% 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 - 22,317.00 - 22,317.00 89,268.00 66,951.00 25.00% 452003 - Allocations-IT - 20,121.75 - 20,121.75 80,487.00 60,365.25 25.00% 452004 - Allocations-Liability Insurance - 3,522.99 - 3,522.99 14,092.00 10,569.01 25.00% 452009 - Allocations-Facilities Mgmt - 900.00 - 900.00 3,600.00 2,700.00 25.00% Total Other Uses - 46,861.74 - 46,861.74 187,447.00 140,585.26 25.00% Total Expenses 137,423.26 497,255.69 188,920.24 686,175.93 2,697,868.27 2,011,692.34 25.43%