Loading...
HomeMy WebLinkAboutFeb 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 88,961.60 175,842.90 172,000.00 (3,842.90) 102.23% 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 140.63 700.82 59,500.00 58,799.18 1.18% 347007 - Golf Driving Range - - 30,000.00 30,000.00 0.00% 347008 - Golf Gift Certificate 35.00 35.00 - (35.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 110,900.00 110,830.49 0.06% 347026 - Room Rental 2,908.58 2,983.58 10,000.00 7,016.42 29.84% Total Culture & Recreation 92,045.81 179,631.81 1,637,177.00 1,457,545.19 10.97% Total Charges for Services 92,045.81 179,631.81 1,637,177.00 1,457,545.19 10.97% Miscellaneous Revenue 360000 - Miscellaneous 0.10 1.02 2,500.00 2,498.98 0.04% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 0.10 1,773.64 2,500.00 726.36 70.95% Refunds & Reimbursements 396000 - Refunds - 5,672.50 - (5,672.50) 0.00% Total Refunds & Reimbursements - 5,672.50 - (5,672.50) 0.00% Total Revenue 92,045.91 187,077.95 1,639,677.00 1,452,599.05 11.41% 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 26,374.85 52,259.26 - 52,259.26 412,922.00 360,662.74 12.66% 410002 - Teamster Wages 3,443.20 5,915.20 - 5,915.20 86,390.00 80,474.80 6.85% 410003 - Permanent Part Time 3,054.69 5,089.17 - 5,089.17 295,201.00 290,111.83 1.72% 410004 - Extra & Overtime - - - - 2,550.00 2,550.00 0.00% 410005 - Seasonal & Interns 24.00 24.00 - 24.00 41,776.00 41,752.00 0.06% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 32,896.74 63,287.63 - 63,287.63 839,439.00 776,151.37 7.54% Employee Benefits 411001 - FICA Regular 2,387.96 5,651.56 - 5,651.56 64,409.00 58,757.44 8.77% 411004 - PERF Regular 3,345.81 7,800.01 - 7,800.01 56,557.00 48,756.99 13.79% 411005 - PERF Union 51.64 125.10 - 125.10 1,371.00 1,245.90 9.12% 411007 - Unemployment Comp 24.04 69.43 - 69.43 804.00 734.57 8.64% 411008 - Health Insurance 7,946.74 15,893.48 - 15,893.48 121,999.00 106,105.52 13.03% 411009 - Life Insurance 70.00 140.00 - 140.00 1,080.00 940.00 12.96% 411014 - Parental Leave 104.29 203.54 - 203.54 1,759.00 1,555.46 11.57% 411201 - Tool Allowance - - - - 800.00 800.00 0.00% 411203 - Job Readiness Allow. - 425.00 - 425.00 1,050.00 625.00 40.48% 411206 - Cell Phone Allowance 55.00 110.00 - 110.00 660.00 550.00 16.67% Total Employee Benefits 13,985.48 30,418.12 - 30,418.12 250,489.00 220,070.88 12.14% Total Personnel Expenditures 46,882.22 93,705.75 - 93,705.75 1,089,928.00 996,222.25 8.60% Supplies Expenditures February 28, 2022 Office Supplies 421000 - General Office Supplies 24.96 74.96 - 74.96 1,000.00 925.04 7.50% Total Office Supplies 24.96 74.96 - 74.96 1,000.00 925.04 7.50% Operating Supplies 422000 - Other Operating Supplies 3,736.22 6,372.42 - 6,372.42 36,500.00 30,127.58 17.46% 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 500.00 450.07 9.99% 422010 - Plants Chemicals Seed & Fertilizer - - - - 93,000.00 93,000.00 0.00% 422014 - Concessions Inventory 285.10 561.90 - 561.90 81,400.00 80,838.10 0.69% 422016 - Inventory For Sale 2,058.45 2,058.45 17,168.86 19,227.31 35,335.00 16,107.69 54.41% Total Operating Supplies 6,079.77 9,042.70 17,168.86 26,211.56 271,935.00 245,723.44 9.64% Repair & Maintenance Supplies 423000 - Other R&M Supplies 176.34 4,372.41 5,934.43 10,306.84 40,590.63 30,283.79 25.39% 423009 - Repair Parts 74.38 74.38 - 74.38 600.00 525.62 12.40% Total Repair & Maintenance Supplies 250.72 4,446.79 5,934.43 10,381.22 41,190.63 30,809.41 25.20% Total Supplies Expenditures 6,355.45 13,564.45 23,103.29 36,667.74 314,125.63 277,457.89 11.67% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 2,073.15 10,893.09 - 10,893.09 17,180.00 6,286.91 63.41% 431019 - Security Services 481.44 752.88 - 752.88 1,600.00 847.12 47.06% Total Professional Services 2,554.59 11,645.97 - 11,645.97 18,780.00 7,134.03 62.01% 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 748.55 11,528.68 1,750.00 13,278.68 42,520.00 29,241.32 31.23% Total Printing & Advertising 748.55 11,528.68 1,750.00 13,278.68 42,520.00 29,241.32 31.23% Utilties 435001 - Electric 4,143.24 7,338.28 - 7,338.28 49,667.00 42,328.72 14.77% 435002 - Natural Gas 4,322.97 6,489.94 - 6,489.94 22,519.00 16,029.06 28.82% Total Utilities 8,466.21 13,828.22 - 13,828.22 72,186.00 58,357.78 19.16% Repairs & Maintenance 436000 - Other R&M - - 19,971.54 19,971.54 19,971.54 - 100.00% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance - 524.70 19,971.54 20,496.24 20,971.54 475.30 97.73% 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 - - - - 3,050.00 3,050.00 0.00% 439002 - Licenses & Permits 2,150.00 2,436.88 400.00 2,836.88 3,160.00 323.12 89.77% 439003 - Subscriptions 1,195.71 1,195.71 - 1,195.71 1,500.00 304.29 79.71% 439004 - Dues & Memberships 152.95 181.94 - 181.94 4,000.00 3,818.06 4.55% 439005 - Bank & Credit Card Fees 2,338.94 4,596.66 - 4,596.66 29,800.00 25,203.34 15.43% 439006 - Education & Training - 395.46 - 395.46 800.00 404.54 49.43% 439009 - Trash Removal 466.65 805.80 1,194.41 2,000.21 6,339.15 4,338.94 31.55% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439100 - Refunds/Awards/Indemnities - - - - 200.00 200.00 0.00% Total Other Services & Charges 6,304.25 9,612.45 19,594.41 29,206.86 66,849.15 37,642.29 43.69% Total Services & Charges Expenditures 18,073.60 47,140.02 41,325.08 88,465.10 294,532.82 206,067.72 30.04% Other Uses 452002 - Allocations-Admin Cost 4,962.00 9,924.00 - 9,924.00 59,544.00 49,620.00 16.67% 452003 - Allocations-IT 5,594.67 11,189.30 - 11,189.30 67,136.00 55,946.70 16.67% 452004 - Allocations-Liability Insurance 870.92 1,741.80 - 1,741.80 10,451.00 8,709.20 16.67% 452009 - Allocations-Facilities Mgmt 295.25 590.50 - 590.50 3,543.00 2,952.50 16.67% Total Other Uses 11,722.84 23,445.60 - 23,445.60 140,674.00 117,228.40 16.67% Total Expenditures 83,034.11 177,855.82 64,428.37 242,284.19 1,839,260.45 1,596,976.26 13.17%