Loading...
HomeMy WebLinkAboutOct 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 59,804.00 832,059.32 805,000.00 (27,059.32) 103.36% 347005 - Golf Cart Rentals 31,934.83 376,658.91 365,000.00 (11,658.91) 103.19% 347006 - Golf Pro Shop Retail 4,807.51 70,382.91 59,500.00 (10,882.91) 118.29% 347007 - Golf Driving Range 2,703.00 40,331.00 30,000.00 (10,331.00) 134.44% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings - 7,808.89 - (7,808.89) 0.00% 347012 - Food Sales 6,538.59 71,815.61 53,277.00 (18,538.61) 134.80% 347013 - Nonalcoholic Beverage 2,384.08 39,535.14 31,500.00 (8,035.14) 125.51% 347014 - Alcoholic Beverage Sales 12,421.40 150,187.39 110,900.00 (39,287.39) 135.43% 347026 - Room Rental 2,421.67 19,191.49 10,000.00 (9,191.49) 191.91% 347100 - Concessions-Employee Discounts (166.26) (1,825.22) - 1,825.22 0.00% Total Culture & Recreation 122,848.82 1,875,352.64 1,637,177.00 (238,175.64) 114.55% Total Charges for Services 122,848.82 1,875,352.64 1,637,177.00 (238,175.64) 114.55% 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 120.33 3,387.16 2,500.00 (887.16) 135.49% 367000 - Donations from Private Sources - 1,772.62 - (1,772.62) 0.00% Total Miscellaneous Revenue 120.33 5,159.78 2,500.00 (2,659.78) 206.39% 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 122,969.15 1,892,729.26 1,649,358.00 (243,371.26) 114.76% 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 26,446.43 291,204.49 - 291,204.49 412,922.00 121,717.51 70.52% 410002 - Teamster Wages 6,349.09 51,855.20 - 51,855.20 86,090.00 34,234.80 60.23% 410003 - Permanent Part Time 34,011.46 302,959.83 - 302,959.83 292,076.00 (10,883.83) 103.73% 410004 - Extra & Overtime 350.97 5,551.85 - 5,551.85 5,675.00 123.15 97.83% 410005 - Seasonal & Interns 4,630.39 48,313.37 - 48,313.37 41,776.00 (6,537.37) 115.65% 410007 - Longevity Pay - 250.00 - 250.00 600.00 350.00 41.67% Total Salaries & Wages 71,788.34 700,134.74 - 700,134.74 839,139.00 139,004.26 83.43% Employee Benefits 411001 - FICA Regular 5,354.79 53,315.38 - 53,315.38 64,409.00 11,093.62 82.78% 411004 - PERF Regular 3,680.53 39,875.34 - 39,875.34 56,557.00 16,681.66 70.50% 411005 - PERF Union 48.62 610.95 - 610.95 1,371.00 760.05 44.56% 411007 - Unemployment Comp 3.38 410.35 - 410.35 804.00 393.65 51.04% 411008 - Health Insurance 9,060.94 83,405.60 - 83,405.60 121,999.00 38,593.40 68.37% 411009 - Life Insurance 80.00 735.00 - 735.00 1,080.00 345.00 68.06% 411014 - Parental Leave 116.04 1,227.26 - 1,227.26 1,759.00 531.74 69.77% 411015 - Other Fringe Benefits - 290.00 - 290.00 300.00 10.00 96.67% October 31, 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 550.00 - 550.00 660.00 110.00 83.33% Total Employee Benefits 18,399.30 180,844.88 - 180,844.88 250,789.00 69,944.12 72.11% Total Personnel Expenses 90,187.64 880,979.62 - 880,979.62 1,089,928.00 208,948.38 80.83% Supplies Expenses Office Supplies 421000 - General Office Supplies - 1,660.59 - 1,660.59 750.00 (910.59) 221.41% Total Office Supplies - 1,660.59 - 1,660.59 750.00 (910.59) 221.41% Operating Supplies 422000 - Other Operating Supplies 4,251.55 63,660.74 8,151.39 71,812.13 40,450.00 (31,362.13) 177.53% 422002 - Diesel/CNG 4,029.00 9,461.27 2,283.00 11,744.27 4,000.00 (7,744.27) 293.61% 422003 - Gasoline 3,593.50 18,400.18 5,054.66 23,454.84 23,500.00 45.16 99.81% 422005 - Uniforms - 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 2,894.00 91,965.20 24,744.01 116,709.21 113,600.00 (3,109.21) 102.74% 422013 - Promotional Supplies - 499.91 - 499.91 - (499.91) 0.00% 422014 - Concessions Inventory 14,233.28 115,672.96 3,335.31 119,008.27 51,905.00 (67,103.27) 229.28% 422016 - Inventory For Sale 471.26 52,049.51 2,125.21 54,174.72 34,035.00 (20,139.72) 159.17% Total Operating Supplies 29,472.59 353,186.09 45,693.58 398,879.67 269,085.00 (129,794.67) 148.24% Repair & Maintenance Supplies 423000 - Other R&M Supplies 7,440.69 55,866.07 7,459.93 63,326.00 41,590.63 (21,735.37) 152.26% 423009 - Repair Parts - 2,479.69 - 2,479.69 2,700.00 220.31 91.84% Total Repair & Maintenance Supplies 7,440.69 58,345.76 7,459.93 65,805.69 44,290.63 (21,515.06) 148.58% Total Supplies Expenses 36,913.28 413,192.44 53,153.51 466,345.95 314,125.63 (152,220.32) 148.46% Services & Charges Expenses Professional Services 431000 - Other Professional Services 4,738.19 40,904.46 - 40,904.46 30,380.00 (10,524.46) 134.64% 431019 - Security Services 274.77 3,552.90 - 3,552.90 1,900.00 (1,652.90) 186.99% Total Professional Services 5,012.96 44,457.36 - 44,457.36 32,280.00 (12,177.36) 137.72% 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 2,241.75 30,121.08 - 30,121.08 32,620.00 2,498.92 92.34% Total Printing & Advertising 2,241.75 33,613.81 - 33,613.81 32,620.00 (993.81) 103.05% Utilties 435001 - Electric 2,471.00 55,537.48 - 55,537.48 49,667.00 (5,870.48) 111.82% 435002 - Natural Gas 495.50 15,028.59 - 15,028.59 22,519.00 7,490.41 66.74% Total Utilities 2,966.50 70,566.07 - 70,566.07 72,186.00 1,619.93 97.76% Repairs & Maintenance 436000 - Other R&M 2,352.17 6,619.57 6,491.54 13,111.11 12,971.54 (139.57) 101.08% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% Total Repairs & Maintenance 2,352.17 7,144.27 6,491.54 13,635.81 13,971.54 335.73 97.60% 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 1,472.39 4,190.73 - 4,190.73 4,350.00 159.27 96.34% 439002 - Licenses & Permits - 3,493.63 - 3,493.63 3,360.00 (133.63) 103.98% 439003 - Subscriptions 12.95 1,595.40 - 1,595.40 1,500.00 (95.40) 106.36% 439004 - Dues & Memberships 705.00 1,051.93 - 1,051.93 3,200.00 2,148.07 32.87% 439005 - Bank & Credit Card Fees 3,115.96 44,968.32 - 44,968.32 25,270.00 (19,698.32) 177.95% 439006 - Education & Training - 1,180.92 - 1,180.92 800.00 (380.92) 147.62% 439009 - Trash Removal 1,652.57 14,224.41 - 14,224.41 13,339.15 (885.26) 106.64% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (60.09) (274.15) - (274.15) - 274.15 0.00% 439100 - Refunds/Awards/Indemnities 94.71 915.25 - 915.25 430.00 (485.25) 212.85% Total Other Services & Charges 6,993.49 71,346.44 18,000.00 89,346.44 70,249.15 (19,097.29) 127.19% Total Services & Charges Expenses 19,566.87 299,953.61 24,650.67 324,604.28 294,532.82 (30,071.46) 110.21% 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 49,620.00 - 49,620.00 59,544.00 9,924.00 83.33% 452003 - Allocations-IT 5,594.67 55,946.66 - 55,946.66 67,136.00 11,189.34 83.33% 452004 - Allocations-Liability Insurance 870.92 8,709.16 - 8,709.16 10,451.00 1,741.84 83.33% 452009 - Allocations-Facilities Mgmt 295.25 2,952.50 - 2,952.50 3,543.00 590.50 83.33% Total Other Uses 11,722.84 117,228.32 - 117,228.32 140,674.00 23,445.68 83.33% 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 158,390.63 1,728,461.11 77,804.18 1,806,265.29 1,856,271.45 50,006.16 97.31%