Loading...
HomeMy WebLinkAboutSept 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 - 269,172.20 172,000.00 (97,172.20) 156.50% 347004 - Golf Green Fees 120,269.06 772,255.32 805,000.00 32,744.68 95.93% 347005 - Golf Cart Rentals 50,415.69 344,724.08 365,000.00 20,275.92 94.44% 347006 - Golf Pro Shop Retail 8,324.38 65,575.40 59,500.00 (6,075.40) 110.21% 347007 - Golf Driving Range 4,992.00 37,628.00 30,000.00 (7,628.00) 125.43% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings - 7,808.89 - (7,808.89) 0.00% 347012 - Food Sales 11,827.57 65,277.02 53,277.00 (12,000.02) 122.52% 347013 - Nonalcoholic Beverage 5,389.15 37,151.06 31,500.00 (5,651.06) 117.94% 347014 - Alcoholic Beverage Sales 21,229.28 137,765.99 110,900.00 (26,865.99) 124.23% 347026 - Room Rental 4,015.73 16,769.82 10,000.00 (6,769.82) 167.70% 347100 - Concessions-Employee Discounts (233.32) (1,658.96) - 1,658.96 0.00% Total Culture & Recreation 226,229.54 1,752,503.82 1,637,177.00 (115,326.82) 107.04% Total Charges for Services 226,229.54 1,752,503.82 1,637,177.00 (115,326.82) 107.04% Fines, Forefeitures, Fees 351002 - Bad Checks Fines - 24.00 - (24.00) 0.00% Total Fines, Forfeitures, Fees - 24.00 - (24.00) 0.00% Miscellaneous Revenue 360000 - Miscellaneous 345.79 3,266.83 2,500.00 (766.83) 130.67% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 345.79 5,039.45 2,500.00 (2,539.45) 201.58% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,056.44 4,008.00 (48.44) 101.21% 396000 - Refunds - 8,136.40 5,673.00 (2,463.40) 143.42% Total Refunds & Reimbursements - 12,192.84 9,681.00 (2,511.84) 125.95% Total Revenue 226,575.33 1,769,760.11 1,649,358.00 (120,402.11) 107.30% 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.10 264,758.06 - 264,758.06 412,922.00 148,163.94 64.12% 410002 - Teamster Wages 10,121.14 45,506.11 - 45,506.11 86,090.00 40,583.89 52.86% 410003 - Permanent Part Time 59,991.76 268,948.37 - 268,948.37 292,076.00 23,127.63 92.08% 410004 - Extra & Overtime 448.92 5,200.88 - 5,200.88 5,675.00 474.12 91.65% 410005 - Seasonal & Interns 11,068.55 43,682.98 - 43,682.98 41,776.00 (1,906.98) 104.56% 410007 - Longevity Pay - 250.00 - 250.00 600.00 350.00 41.67% Total Salaries & Wages 121,192.47 628,346.40 - 628,346.40 839,139.00 210,792.60 74.88% Employee Benefits 411001 - FICA Regular 9,133.45 47,960.59 - 47,960.59 64,409.00 16,448.41 74.46% 411004 - PERF Regular 6,308.26 36,194.81 - 36,194.81 56,557.00 20,362.19 64.00% 411005 - PERF Union 78.23 562.33 - 562.33 1,371.00 808.67 41.02% 411007 - Unemployment Comp 5.54 406.97 - 406.97 804.00 397.03 50.62% 411008 - Health Insurance 9,015.44 74,344.66 - 74,344.66 121,999.00 47,654.34 60.94% 411009 - Life Insurance 80.00 655.00 - 655.00 1,080.00 425.00 60.65% 411014 - Parental Leave 191.71 1,111.22 - 1,111.22 1,759.00 647.78 63.17% 411015 - Other Fringe Benefits - 290.00 - 290.00 300.00 10.00 96.67% September 30, 2022 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 495.00 - 495.00 660.00 165.00 75.00% Total Employee Benefits 24,867.63 162,445.58 - 162,445.58 250,789.00 88,343.42 64.77% Total Personnel Expenses 146,060.10 790,791.98 - 790,791.98 1,089,928.00 299,136.02 72.55% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,041.60 1,660.59 - 1,660.59 750.00 (910.59) 221.41% Total Office Supplies 1,041.60 1,660.59 - 1,660.59 750.00 (910.59) 221.41% Operating Supplies 422000 - Other Operating Supplies 8,058.44 59,409.19 7,068.14 66,477.33 40,450.00 (26,027.33) 164.34% 422002 - Diesel/CNG - 5,432.27 6,309.00 11,741.27 4,000.00 (7,741.27) 293.53% 422003 - Gasoline - 14,806.68 8,975.00 23,781.68 23,500.00 (281.68) 101.20% 422005 - Uniforms 686.21 1,426.39 - 1,426.39 1,095.00 (331.39) 130.26% 422008 - Medical/Safety Supplies - 49.93 - 49.93 500.00 450.07 9.99% 422010 - Plants Chemicals Seed & Fertilizer 555.50 89,071.20 27,638.01 116,709.21 113,600.00 (3,109.21) 102.74% 422013 - Promotional Supplies 40.00 499.91 - 499.91 - (499.91) 0.00% 422014 - Concessions Inventory 23,002.84 101,439.68 3,335.31 104,774.99 51,905.00 (52,869.99) 201.86% 422016 - Inventory For Sale 9,766.73 51,578.25 2,596.47 54,174.72 34,035.00 (20,139.72) 159.17% Total Operating Supplies 42,109.72 323,713.50 55,921.93 379,635.43 269,085.00 (110,550.43) 141.08% Repair & Maintenance Supplies 423000 - Other R&M Supplies 2,226.78 48,425.38 2,686.93 51,112.31 41,590.63 (9,521.68) 122.89% 423009 - Repair Parts - 2,479.69 - 2,479.69 2,700.00 220.31 91.84% Total Repair & Maintenance Supplies 2,226.78 50,905.07 2,686.93 53,592.00 44,290.63 (9,301.37) 121.00% Total Supplies Expenses 45,378.10 376,279.16 58,608.86 434,888.02 314,125.63 (120,762.39) 138.44% Services & Charges Expenses Professional Services 431000 - Other Professional Services 3,409.14 36,166.27 - 36,166.27 30,380.00 (5,786.27) 119.05% 431019 - Security Services 390.12 3,278.13 - 3,278.13 1,900.00 (1,378.13) 172.53% Total Professional Services 3,799.26 39,444.40 - 39,444.40 32,280.00 (7,164.40) 122.19% Communication & Transportation 432002 - Mailing - 9.25 150.00 159.25 - (159.25) 0.00% 432004 - Telecommunications - - 9.13 9.13 409.13 400.00 2.23% Total Communication & Transportation - 9.25 159.13 168.38 409.13 240.75 41.16% Printing & Advertising 433001 - Outside Printing Services - 3,492.73 - 3,492.73 - (3,492.73) 0.00% 433003 - Promotional 816.09 27,879.33 - 27,879.33 32,620.00 4,740.67 85.47% Total Printing & Advertising 816.09 31,372.06 - 31,372.06 32,620.00 1,247.94 96.17% Utilties 435001 - Electric 12,071.38 53,066.48 - 53,066.48 49,667.00 (3,399.48) 106.84% 435002 - Natural Gas 493.99 14,533.09 - 14,533.09 22,519.00 7,985.91 64.54% Total Utilities 12,565.37 67,599.57 - 67,599.57 72,186.00 4,586.43 93.65% Repairs & Maintenance 436000 - Other R&M - 4,267.40 6,491.54 10,758.94 12,971.54 2,212.60 82.94% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance - 4,792.10 6,491.54 11,283.64 13,971.54 2,687.90 80.76% Debt Service 438100 - Principal - 67,578.98 - 67,578.98 67,579.00 0.02 100.00% 438200 - Interest - 5,237.43 - 5,237.43 5,238.00 0.57 99.99% Total Debt Service - 72,816.41 - 72,816.41 72,817.00 0.59 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 378.06 2,718.34 - 2,718.34 4,350.00 1,631.66 62.49% 439002 - Licenses & Permits - 3,493.63 - 3,493.63 3,360.00 (133.63) 103.98% 439003 - Subscriptions 12.95 1,582.45 - 1,582.45 1,500.00 (82.45) 105.50% 439004 - Dues & Memberships - 346.93 - 346.93 3,200.00 2,853.07 10.84% 439005 - Bank & Credit Card Fees 5,275.21 41,852.36 - 41,852.36 25,270.00 (16,582.36) 165.62% 439006 - Education & Training - 1,180.92 - 1,180.92 800.00 (380.92) 147.62% 439009 - Trash Removal 2,934.38 12,571.84 265.40 12,837.24 13,339.15 501.91 96.24% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 305.27 (214.06) - (214.06) - 214.06 0.00% 439100 - Refunds/Awards/Indemnities 60.78 820.54 - 820.54 430.00 (390.54) 190.82% Total Other Services & Charges 8,966.65 64,352.95 18,265.40 82,618.35 70,249.15 (12,369.20) 117.61% Total Services & Charges Expenses 26,147.37 280,386.74 24,916.07 305,302.81 294,532.82 (10,769.99) 103.66% Capital Outlay Machinery & Equipment 445006 - Computer Equip/Network - 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Total Machinery & Equipment - 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Total Capital Expenses - 17,007.12 - 17,007.12 17,011.00 3.88 99.98% Other Uses 452002 - Allocations-Admin Cost 4,962.00 44,658.00 - 44,658.00 59,544.00 14,886.00 75.00% 452003 - Allocations-IT 5,594.67 50,351.99 - 50,351.99 67,136.00 16,784.01 75.00% 452004 - Allocations-Liability Insurance 870.92 7,838.24 - 7,838.24 10,451.00 2,612.76 75.00% 452009 - Allocations-Facilities Mgmt 295.25 2,657.25 - 2,657.25 3,543.00 885.75 75.00% Total Other Uses 11,722.84 105,505.48 - 105,505.48 140,674.00 35,168.52 75.00% Bad Debt Expense 490000 - Bad Debt Expense - 100.00 - 100.00 - (100.00) 0.00% Total Bad Debt Expense - 100.00 - 100.00 - (100.00) 0.00% Total Expenses 229,308.41 1,570,070.48 83,524.93 1,653,595.41 1,856,271.45 202,676.04 89.08%