Loading...
HomeMy WebLinkAboutMar 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 30,133.30 205,976.20 172,000.00 (33,976.20) 119.75% 347004 - Golf Green Fees 12,020.00 12,020.00 805,000.00 792,980.00 1.49% 347005 - Golf Cart Rentals 4,265.99 4,265.99 365,000.00 360,734.01 1.17% 347006 - Golf Pro Shop Retail 1,590.48 2,291.30 59,500.00 57,208.70 3.85% 347007 - Golf Driving Range 821.00 821.00 30,000.00 29,179.00 2.74% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings 1,380.00 1,380.00 - (1,380.00) 0.00% 347012 - Food Sales 574.76 574.76 53,277.00 52,702.24 1.08% 347013 - Nonalcoholic Beverage 409.20 409.20 31,500.00 31,090.80 1.30% 347014 - Alcoholic Beverage Sales 1,301.89 1,371.40 110,900.00 109,528.60 1.24% 347026 - Room Rental 100.00 3,083.58 10,000.00 6,916.42 30.84% 347100 - Concessions-Employee Discounts (18.35) (18.35) - 18.35 0.00% Total Culture & Recreation 52,578.27 232,210.08 1,637,177.00 1,404,966.92 14.18% Total Charges for Services 52,578.27 232,210.08 1,637,177.00 1,404,966.92 14.18% Miscellaneous Revenue 360000 - Miscellaneous 0.03 1.05 2,500.00 2,498.95 0.04% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 0.03 1,773.67 2,500.00 726.33 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 52,578.30 239,656.25 1,639,677.00 1,400,020.75 14.62% 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,377.52 78,636.78 - 78,636.78 412,922.00 334,285.22 19.04% 410002 - Teamster Wages 3,406.80 9,322.00 - 9,322.00 86,090.00 76,768.00 10.83% 410003 - Permanent Part Time 3,685.42 8,774.59 - 8,774.59 295,201.00 286,426.41 2.97% 410004 - Extra & Overtime 95.72 95.72 - 95.72 2,550.00 2,454.28 3.75% 410005 - Seasonal & Interns 190.33 214.33 - 214.33 41,776.00 41,561.67 0.51% 410007 - Longevity Pay - - - - 600.00 600.00 0.00% Total Salaries & Wages 33,755.79 97,043.42 - 97,043.42 839,139.00 742,095.58 11.56% Employee Benefits 411001 - FICA Regular 2,453.72 8,105.28 - 8,105.28 64,409.00 56,303.72 12.58% 411004 - PERF Regular 3,352.75 11,152.76 - 11,152.76 56,557.00 45,404.24 19.72% 411005 - PERF Union 52.53 177.63 - 177.63 1,371.00 1,193.37 12.96% 411007 - Unemployment Comp 48.00 117.43 - 117.43 804.00 686.57 14.61% 411008 - Health Insurance 7,967.74 23,861.22 - 23,861.22 121,999.00 98,137.78 19.56% 411009 - Life Insurance 70.00 210.00 - 210.00 1,080.00 870.00 19.44% 411014 - Parental Leave 104.60 308.14 - 308.14 1,759.00 1,450.86 17.52% 411015 - Other Fringe Benefits 290.00 290.00 - 290.00 300.00 10.00 96.67% 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 165.00 - 165.00 660.00 495.00 25.00% Total Employee Benefits 14,394.34 44,812.46 - 44,812.46 250,789.00 205,976.54 17.87% March 31, 2022 Total Personnel Expenditures 48,150.13 141,855.88 - 141,855.88 1,089,928.00 948,072.12 13.02% Supplies Expenditures Office Supplies 421000 - General Office Supplies - 74.96 - 74.96 1,000.00 925.04 7.50% Total Office Supplies - 74.96 - 74.96 1,000.00 925.04 7.50% Operating Supplies 422000 - Other Operating Supplies 9,666.70 16,039.12 1,586.04 17,625.16 34,500.00 16,874.84 51.09% 422003 - Gasoline - - - - 23,000.00 23,000.00 0.00% 422005 - Uniforms 111.30 111.30 - 111.30 2,200.00 2,088.70 5.06% 422008 - Medical/Safety Supplies - 49.93 - 49.93 500.00 450.07 9.99% 422010 - Plants Chemicals Seed & Fertilizer - - 77,405.48 77,405.48 97,000.00 19,594.52 79.80% 422014 - Concessions Inventory 6,770.70 7,332.60 - 7,332.60 75,400.00 68,067.40 9.72% 422016 - Inventory For Sale 19,886.12 21,944.57 1,883.16 23,827.73 37,335.00 13,507.27 63.82% Total Operating Supplies 36,434.82 45,477.52 80,874.68 126,352.20 269,935.00 143,582.80 46.81% Repair & Maintenance Supplies 423000 - Other R&M Supplies 2,196.91 6,569.32 8,247.42 14,816.74 40,590.63 25,773.89 36.50% 423009 - Repair Parts 1,836.59 1,910.97 - 1,910.97 2,600.00 689.03 73.50% Total Repair & Maintenance Supplies 4,033.50 8,480.29 8,247.42 16,727.71 43,190.63 26,462.92 38.73% Total Supplies Expenditures 40,468.32 54,032.77 89,122.10 143,154.87 314,125.63 170,970.76 45.57% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 3,146.03 14,039.12 - 14,039.12 21,680.00 7,640.88 64.76% 431019 - Security Services 309.69 1,062.57 - 1,062.57 1,600.00 537.43 66.41% Total Professional Services 3,455.72 15,101.69 - 15,101.69 23,280.00 8,178.31 64.87% 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 2,487.48 14,016.16 - 14,016.16 36,620.00 22,603.84 38.27% Total Printing & Advertising 2,487.48 14,016.16 - 14,016.16 36,620.00 22,603.84 38.27% Utilties 435001 - Electric 4,037.65 11,375.93 - 11,375.93 49,667.00 38,291.07 22.90% 435002 - Natural Gas 1,913.74 8,403.68 - 8,403.68 22,519.00 14,115.32 37.32% Total Utilities 5,951.39 19,779.61 - 19,779.61 72,186.00 52,406.39 27.40% Repairs & Maintenance 436000 - Other R&M - - 6,491.54 6,491.54 19,971.54 13,480.00 32.50% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance - 524.70 6,491.54 7,016.24 20,971.54 13,955.30 33.46% 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 1,784.86 1,784.86 - 1,784.86 4,250.00 2,465.14 42.00% 439002 - Licenses & Permits 498.94 2,935.82 - 2,935.82 3,360.00 424.18 87.38% 439003 - Subscriptions 64.99 1,260.70 - 1,260.70 1,500.00 239.30 84.05% 439004 - Dues & Memberships 100.00 281.94 - 281.94 4,000.00 3,718.06 7.05% 439005 - Bank & Credit Card Fees 1,333.33 5,929.99 - 5,929.99 29,790.00 23,860.01 19.91% 439006 - Education & Training 270.46 665.92 - 665.92 800.00 134.08 83.24% 439009 - Trash Removal 1,906.13 2,711.93 241.44 2,953.37 6,339.15 3,385.78 46.59% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 0.01 0.01 - 0.01 - (0.01) 0.00% 439100 - Refunds/Awards/Indemnities 17.77 17.77 - 17.77 210.00 192.23 8.46% Total Other Services & Charges 5,976.49 15,588.94 18,241.44 33,830.38 68,249.15 34,418.77 49.57% Total Services & Charges Expenditures 17,871.08 65,011.10 24,742.11 89,753.21 294,532.82 204,779.61 30.47% Other Uses 452002 - Allocations-Admin Cost 4,962.00 14,886.00 - 14,886.00 59,544.00 44,658.00 25.00% 452003 - Allocations-IT 5,594.67 16,783.97 - 16,783.97 67,136.00 50,352.03 25.00% 452004 - Allocations-Liability Insurance 870.92 2,612.72 - 2,612.72 10,451.00 7,838.28 25.00% 452009 - Allocations-Facilities Mgmt 295.25 885.75 - 885.75 3,543.00 2,657.25 25.00% Total Other Uses 11,722.84 35,168.44 - 35,168.44 140,674.00 105,505.56 25.00% Total Expenditures 118,212.37 296,068.19 113,864.21 409,932.40 1,839,260.45 1,429,328.05 22.29%