Loading...
HomeMy WebLinkAboutJan 22 Fin 4South Bend Venues, Parks and Arts Golf: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Charges for Services Culture & Recreation 347003 - Golf Season Pass 86,881.30 86,881.30 172,000.00 85,118.70 50.51% 347004 - Golf Green Fees - - 805,000.00 805,000.00 0.00% 347005 - Golf Cart Rentals - - 365,000.00 365,000.00 0.00% 347006 - Golf Pro Shop Retail 560.19 560.19 59,500.00 58,939.81 0.94% 347007 - Golf Driving Range - - 30,000.00 30,000.00 0.00% 347012 - Food Sales - - 53,277.00 53,277.00 0.00% 347013 - Nonalcoholic Beverage - - 31,500.00 31,500.00 0.00% 347014 - Alcoholic Beverage Sales 69.51 69.51 110,900.00 110,830.49 0.06% 347026 - Room Rental 75.00 75.00 10,000.00 9,925.00 0.75% Total Culture & Recreation 87,586.00 87,586.00 1,637,177.00 1,549,591.00 5.35% Total Charges for Services 87,586.00 87,586.00 1,637,177.00 1,549,591.00 5.35% Miscellaneous Revenue 360000 - Miscellaneous 0.92 0.92 2,500.00 2,499.08 0.04% 367000 - Donations from Private Sources 1,772.62 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 1,773.54 1,773.54 2,500.00 726.46 70.94% Refunds & Reimbursements 396000 - Refunds 5,672.50 5,672.50 - (5,672.50) 0.00% Total Refunds & Reimbursements 5,672.50 5,672.50 - (5,672.50) 0.00% Total Revenue 95,032.04 95,032.04 1,639,677.00 1,544,644.96 5.80% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 25,884.41 25,884.41 - 25,884.41 412,922.00 387,037.59 6.27% 410002 - Teamster Wages 2,472.00 2,472.00 - 2,472.00 86,390.00 83,918.00 2.86% 410003 - Permanent Part Time 2,034.48 2,034.48 - 2,034.48 295,201.00 293,166.52 0.69% 410004 - Extra & Overtime - - - - 2,550.00 2,550.00 0.00% 410005 - Seasonal & Interns - - - - 41,776.00 41,776.00 0.00% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 30,390.89 30,390.89 - 30,390.89 839,439.00 809,048.11 3.62% Employee Benefits 411001 - FICA Regular 3,263.60 3,263.60 - 3,263.60 64,409.00 61,145.40 5.07% 411004 - PERF Regular 4,454.20 4,454.20 - 4,454.20 56,557.00 52,102.80 7.88% 411005 - PERF Union 73.46 73.46 - 73.46 1,371.00 1,297.54 5.36% 411007 - Unemployment Comp 45.39 45.39 - 45.39 804.00 758.61 5.65% 411008 - Health Insurance 7,946.74 7,946.74 - 7,946.74 121,999.00 114,052.26 6.51% 411009 - Life Insurance 70.00 70.00 - 70.00 1,080.00 1,010.00 6.48% 411014 - Parental Leave 99.25 99.25 - 99.25 1,759.00 1,659.75 5.64% 411201 - Tool Allowance - - - - 800.00 800.00 0.00% 411203 - Job Readiness Allow. 425.00 425.00 - 425.00 1,050.00 625.00 40.48% 411206 - Cell Phone Allowance 55.00 55.00 - 55.00 660.00 605.00 8.33% Total Employee Benefits 16,432.64 16,432.64 - 16,432.64 250,489.00 234,056.36 6.56% Total Personnel Expenditures 46,823.53 46,823.53 - 46,823.53 1,089,928.00 1,043,104.47 4.30% Supplies Expenditures Office Supplies 421000 - General Office Supplies 50.00 50.00 - 50.00 - (50.00) 0.00% Total Office Supplies 50.00 50.00 - 50.00 - (50.00) 0.00% January 31, 2022 Operating Supplies 422000 - Other Operating Supplies 2,636.20 2,636.20 - 2,636.20 37,500.00 34,863.80 7.03% 422003 - Gasoline - - - - 23,000.00 23,000.00 0.00% 422005 - Uniforms - - - - 2,200.00 2,200.00 0.00% 422008 - Medical/Safety Supplies 49.93 49.93 - 49.93 - (49.93) 0.00% 422010 - Plants Chemicals Seed & Fertilizer - - - - 90,000.00 90,000.00 0.00% 422014 - Concessions Inventory 276.80 276.80 - 276.80 85,500.00 85,223.20 0.32% 422016 - Inventory For Sale - - 335.00 335.00 35,335.00 35,000.00 0.95% Total Operating Supplies 2,962.93 2,962.93 335.00 3,297.93 273,535.00 270,237.07 1.21% Repair & Maintenance Supplies 423000 - Other R&M Supplies 4,196.07 4,196.07 5,934.43 10,130.50 40,590.63 30,460.13 24.96% Total Repair & Maintenance Supplies 4,196.07 4,196.07 5,934.43 10,130.50 40,590.63 30,460.13 24.96% Total Supplies Expenditures 7,209.00 7,209.00 6,269.43 13,478.43 314,125.63 300,647.20 4.29% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 8,819.94 8,819.94 - 8,819.94 26,330.00 17,510.06 33.50% 431019 - Security Services 271.44 271.44 - 271.44 4,000.00 3,728.56 6.79% Total Professional Services 9,091.38 9,091.38 - 9,091.38 30,330.00 21,238.62 29.97% 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 10,780.13 10,780.13 - 10,780.13 48,000.00 37,219.87 22.46% Total Printing & Advertising 10,780.13 10,780.13 - 10,780.13 48,000.00 37,219.87 22.46% Utilties 435001 - Electric 3,195.04 3,195.04 - 3,195.04 49,667.00 46,471.96 6.43% 435002 - Natural Gas 2,166.97 2,166.97 - 2,166.97 22,519.00 20,352.03 9.62% Total Utilities 5,362.01 5,362.01 - 5,362.01 72,186.00 66,823.99 7.43% Repairs & Maintenance 436000 - Other R&M - - 6,491.54 6,491.54 6,491.54 - 100.00% 436005 - Other Equip R&M 524.70 524.70 - 524.70 - (524.70) 0.00% Total Repairs & Maintenance 524.70 524.70 6,491.54 7,016.24 6,491.54 (524.70) 108.08% Debt Service 438100 - Principal - - - - 67,579.00 67,579.00 0.00% 438200 - Interest - - - - 5,238.00 5,238.00 0.00% Total Debt Service - - - - 72,817.00 72,817.00 0.00% Other Charges & Services 439000 - Misc Charges & Svcs - - - - 4,000.00 4,000.00 0.00% 439002 - Licenses & Permits 286.88 286.88 2,150.00 2,436.88 2,760.00 323.12 88.29% 439004 - Dues & Memberships 28.99 28.99 - 28.99 3,700.00 3,671.01 0.78% 439005 - Bank & Credit Card Fees 2,257.72 2,257.72 - 2,257.72 29,800.00 27,542.28 7.58% 439006 - Education & Training 395.46 395.46 - 395.46 - (395.46) 0.00% 439009 - Trash Removal 339.15 339.15 466.65 805.80 6,039.15 5,233.35 13.34% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% Total Other Services & Charges 3,308.20 3,308.20 20,616.65 23,924.85 64,299.15 40,374.30 37.21% Total Services & Charges Expenditures 29,066.42 29,066.42 27,117.32 56,183.74 294,532.82 238,349.08 19.08% Other Uses 452002 - Allocations-Admin Cost 4,962.00 4,962.00 - 4,962.00 59,544.00 54,582.00 8.33% 452003 - Allocations-IT 5,594.63 5,594.63 - 5,594.63 67,136.00 61,541.37 8.33% 452004 - Allocations-Liability Insurance 870.88 870.88 - 870.88 10,451.00 9,580.12 8.33% 452009 - Allocations-Facilities Mgmt 295.25 295.25 - 295.25 3,543.00 3,247.75 8.33% Total Other Uses 11,722.76 11,722.76 - 11,722.76 140,674.00 128,951.24 8.33% Total Expenditures 94,821.71 94,821.71 33,386.75 128,208.46 1,839,260.45 1,711,051.99 6.97%