Loading...
HomeMy WebLinkAboutApr 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 22,889.00 228,865.20 172,000.00 (56,865.20) 133.06% 347004 - Golf Green Fees 38,237.00 50,257.00 805,000.00 754,743.00 6.24% 347005 - Golf Cart Rentals 16,259.48 20,525.47 365,000.00 344,474.53 5.62% 347006 - Golf Pro Shop Retail 5,867.09 8,158.39 59,500.00 51,341.61 13.71% 347007 - Golf Driving Range 3,678.00 4,499.00 30,000.00 25,501.00 15.00% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings 660.00 2,040.00 - (2,040.00) 0.00% 347012 - Food Sales 3,909.11 4,483.87 53,277.00 48,793.13 8.42% 347013 - Nonalcoholic Beverage 1,729.30 2,138.50 31,500.00 29,361.50 6.79% 347014 - Alcoholic Beverage Sales 8,309.81 9,681.21 110,900.00 101,218.79 8.73% 347026 - Room Rental 3,129.88 6,213.46 10,000.00 3,786.54 62.13% 347100 - Concessions-Employee Discounts (93.35) (111.70) - 111.70 0.00% Total Culture & Recreation 104,575.32 336,785.40 1,637,177.00 1,300,391.60 20.57% Total Charges for Services 104,575.32 336,785.40 1,637,177.00 1,300,391.60 20.57% Miscellaneous Revenue 360000 - Miscellaneous 62.47 63.52 2,500.00 2,436.48 2.54% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 62.47 1,836.14 2,500.00 663.86 73.45% Refunds & Reimbursements 380000 - Misc Reimbursements 4,008.00 4,008.00 - (4,008.00) 0.00% 396000 - Refunds - 5,672.50 - (5,672.50) 0.00% Total Refunds & Reimbursements 4,008.00 9,680.50 - (9,680.50) 0.00% Total Revenue 108,645.79 348,302.04 1,639,677.00 1,291,374.96 21.24% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 39,562.18 118,198.96 - 118,198.96 412,922.00 294,723.04 28.63% 410002 - Teamster Wages 5,104.80 14,426.80 - 14,426.80 86,090.00 71,663.20 16.76% 410003 - Permanent Part Time 27,620.20 36,394.79 - 36,394.79 295,201.00 258,806.21 12.33% 410004 - Extra & Overtime 287.98 383.70 - 383.70 2,550.00 2,166.30 15.05% 410005 - Seasonal & Interns 5,549.44 5,763.77 - 5,763.77 41,776.00 36,012.23 13.80% 410007 - Longevity Pay 250.00 250.00 - 250.00 600.00 350.00 41.67% Total Salaries & Wages 78,374.60 175,418.02 - 175,418.02 839,139.00 663,720.98 20.90% Employee Benefits 411001 - FICA Regular 5,869.56 13,974.84 - 13,974.84 64,409.00 50,434.16 21.70% 411004 - PERF Regular 5,056.54 16,209.30 - 16,209.30 56,557.00 40,347.70 28.66% 411005 - PERF Union 82.95 260.58 - 260.58 1,371.00 1,110.42 19.01% 411007 - Unemployment Comp 72.48 189.91 - 189.91 804.00 614.09 23.62% 411008 - Health Insurance 7,967.74 31,828.96 - 31,828.96 121,999.00 90,170.04 26.09% 411009 - Life Insurance 70.00 280.00 - 280.00 1,080.00 800.00 25.93% 411014 - Parental Leave 157.84 465.98 - 465.98 1,759.00 1,293.02 26.49% 411015 - Other Fringe Benefits - 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 220.00 - 220.00 660.00 440.00 33.33% Total Employee Benefits 19,332.11 64,144.57 - 64,144.57 250,789.00 186,644.43 25.58% April 30, 2022 Total Personnel Expenses 97,706.71 239,562.59 - 239,562.59 1,089,928.00 850,365.41 21.98% Supplies Expenses Office Supplies 421000 - General Office Supplies 11.08 86.04 - 86.04 1,000.00 913.96 8.60% Total Office Supplies 11.08 86.04 - 86.04 1,000.00 913.96 8.60% Operating Supplies 422000 - Other Operating Supplies 8,588.37 24,627.49 1,795.75 26,423.24 34,500.00 8,076.76 76.59% 422002 - Diesel/CNG - - 1,886.00 1,886.00 4,000.00 2,114.00 47.15% 422003 - Gasoline 2,805.00 2,805.00 1,555.20 4,360.20 24,000.00 19,639.80 18.17% 422005 - Uniforms - 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 56,387.24 56,387.24 37,861.48 94,248.72 101,000.00 6,751.28 93.32% 422014 - Concessions Inventory 7,681.74 15,014.34 4,817.55 19,831.89 64,900.00 45,068.11 30.56% 422016 - Inventory For Sale 6,984.47 28,929.04 209.00 29,138.04 37,335.00 8,196.96 78.04% Total Operating Supplies 82,446.82 127,924.34 48,124.98 176,049.32 268,435.00 92,385.68 65.58% Repair & Maintenance Supplies 423000 - Other R&M Supplies 7,329.66 13,898.98 14,069.30 27,968.28 42,090.63 14,122.35 66.45% 423009 - Repair Parts 53.64 1,964.61 - 1,964.61 2,600.00 635.39 75.56% Total Repair & Maintenance Supplies 7,383.30 15,863.59 14,069.30 29,932.89 44,690.63 14,757.74 66.98% Total Supplies Expenses 89,841.20 143,873.97 62,194.28 206,068.25 314,125.63 108,057.38 65.60% Services & Charges Expenses Professional Services 431000 - Other Professional Services 500.53 14,539.65 - 14,539.65 21,680.00 7,140.35 67.06% 431019 - Security Services 271.44 1,334.01 - 1,334.01 1,600.00 265.99 83.38% Total Professional Services 771.97 15,873.66 - 15,873.66 23,280.00 7,406.34 68.19% 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 4,123.85 18,140.01 - 18,140.01 36,620.00 18,479.99 49.54% Total Printing & Advertising 4,123.85 18,140.01 - 18,140.01 36,620.00 18,479.99 49.54% Utilties 435001 - Electric 4,069.65 15,445.58 - 15,445.58 49,667.00 34,221.42 31.10% 435002 - Natural Gas 2,905.56 11,309.24 - 11,309.24 22,519.00 11,209.76 50.22% Total Utilities 6,975.21 26,754.82 - 26,754.82 72,186.00 45,431.18 37.06% Repairs & Maintenance 436000 - Other R&M 221.41 221.41 7,231.54 7,452.95 17,471.54 10,018.59 42.66% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance 221.41 746.11 7,231.54 7,977.65 18,471.54 10,493.89 43.19% 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 4,250.00 2,465.14 42.00% 439002 - Licenses & Permits - 2,935.82 - 2,935.82 3,360.00 424.18 87.38% 439003 - Subscriptions - 1,260.70 - 1,260.70 1,500.00 239.30 84.05% 439004 - Dues & Memberships - 281.94 - 281.94 4,000.00 3,718.06 7.05% 439005 - Bank & Credit Card Fees 2,581.09 8,511.08 - 8,511.08 29,790.00 21,278.92 28.57% 439006 - Education & Training - 665.92 - 665.92 800.00 134.08 83.24% 439009 - Trash Removal - 2,711.93 2,808.99 5,520.92 8,839.15 3,318.23 62.46% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (124.22) (124.21) - (124.21) - 124.21 0.00% 439100 - Refunds/Awards/Indemnities 20.56 38.33 - 38.33 210.00 171.67 18.25% Total Other Services & Charges 2,477.43 18,066.37 20,808.99 38,875.36 70,749.15 31,873.79 54.95% Total Services & Charges Expenses 14,569.87 79,580.97 28,049.66 107,630.63 294,532.82 186,902.19 36.54% Other Uses 452002 - Allocations-Admin Cost 4,962.00 19,848.00 - 19,848.00 59,544.00 39,696.00 33.33% 452003 - Allocations-IT 5,594.67 22,378.64 - 22,378.64 67,136.00 44,757.36 33.33% 452004 - Allocations-Liability Insurance 870.92 3,483.64 - 3,483.64 10,451.00 6,967.36 33.33% 452009 - Allocations-Facilities Mgmt 295.25 1,181.00 - 1,181.00 3,543.00 2,362.00 33.33% Total Other Uses 11,722.84 46,891.28 - 46,891.28 140,674.00 93,782.72 33.33% Total Expenses 213,840.62 509,908.81 90,243.94 600,152.75 1,839,260.45 1,239,107.70 32.63%