Loading...
HomeMy WebLinkAboutDec 23 Fin 4South Bend Venues, Parks and Arts Golf: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Charges for Services Culture & Recreation 347003 - Golf Season Pass 2,150.00 289,559.19 221,898.00 (67,661.19) 130.49% 347004 - Golf Green Fees 4,614.00 877,509.43 785,529.00 (91,980.43) 111.71% 347005 - Golf Cart Rentals 2,031.02 410,064.76 392,284.00 (17,780.76) 104.53% 347006 - Golf Pro Shop Retail 6,291.71 96,459.66 77,652.00 (18,807.66) 124.22% 347007 - Golf Driving Range - 46,724.95 34,323.00 (12,401.95) 136.13% 347009 - Golf Outings - 13,740.12 - (13,740.12) 0.00% 347012 - Food Sales 61.47 71,097.19 68,447.00 (2,650.19) 103.87% 347013 - Nonalcoholic Beverage 183.88 41,527.13 41,633.00 105.87 99.75% 347014 - Alcoholic Beverage Sales 341.59 169,129.85 151,573.00 (17,556.85) 111.58% 347026 - Room Rental - 2,984.28 7,572.00 4,587.72 39.41% 347100 - Concessions-Employee Discounts - (2,318.13) - 2,318.13 0.00% Total Culture & Recreation 15,673.67 2,016,478.43 1,780,911.00 (235,567.43) 113.23% Total Charges for Services 15,673.67 2,016,478.43 1,780,911.00 (235,567.43) 113.23% Miscellaneous Revenue 360000 - Miscellaneous 1,098.89 7,268.14 1,483.00 (5,785.14) 490.10% Total Miscellaneous Revenue 1,098.89 7,268.14 1,483.00 (5,785.14) 490.10% Refunds & Reimbursements 380000 - Misc Reimbursements - 4,524.82 - (4,524.82) 0.00% Total Refunds & Reimbursements - 4,524.82 - (4,524.82) 0.00% Other Sources 393000 - Capital Lease Proceeds - - 436,000.00 436,000.00 0.00% Total Other Sources - - 436,000.00 436,000.00 0.00% Total Revenue 16,772.56 2,028,271.39 2,218,394.00 190,122.61 91.43% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent of Account String Month Expenses Encumbrances w/ Encumb. Budget Budget Budget Personnel Expenses Salaries & Wages 410001 - Salaried Wages 31,751.08 398,205.39 - 398,205.39 434,369.00 36,163.61 91.67% 410002 - Teamster Wages 16,102.58 82,364.50 - 82,364.50 90,248.00 7,883.50 91.26% 410003 - Permanent Part Time 7,361.56 387,267.12 - 387,267.12 387,301.00 33.88 99.99% 410004 - Extra & Overtime 553.31 7,392.89 - 7,392.89 9,550.00 2,157.11 77.41% 410005 - Seasonal & Interns 36.00 11,028.00 - 11,028.00 32,576.00 21,548.00 33.85% 410007 - Longevity Pay - 350.00 - 350.00 600.00 250.00 58.33% Total Salaries & Wages 55,804.53 886,607.90 - 886,607.90 954,644.00 68,036.10 92.87% Employee Benefits 411001 - FICA Regular 4,104.20 71,297.15 - 71,297.15 71,330.00 32.85 99.95% 411004 - PERF Regular 5,300.25 53,523.14 - 53,523.14 59,369.00 5,845.86 90.15% 411005 - PERF Union 130.32 672.69 - 672.69 1,426.00 753.31 47.17% 411007 - Unemployment Comp 4.90 47.71 - 47.71 633.00 585.29 7.54% 411008 - Health Insurance 11,782.54 99,559.08 - 99,559.08 103,994.00 4,434.92 95.74% 411009 - Life Insurance 110.00 1,025.00 - 1,025.00 1,080.00 55.00 94.91% 411010 - Med/Surgical/Dental 166.01 1,422.53 - 1,422.53 2,000.00 577.47 71.13% 411014 - Parental Leave 169.30 1,703.99 - 1,703.99 1,847.00 143.01 92.26% 411015 - Other Fringe Benefits - 200.00 - 200.00 200.00 - 100.00% 411201 - Tool Allowance - - - - 800.00 800.00 0.00% 411203 - Job Readiness Allow. - 531.25 - 531.25 850.00 318.75 62.50% 411206 - Cell Phone Allowance 55.00 660.00 - 660.00 660.00 - 100.00% December 31, 2023 Total Employee Benefits 21,822.52 230,642.54 - 230,642.54 244,189.00 13,546.46 94.45% Total Personnel Expenses 77,627.05 1,117,250.44 - 1,117,250.44 1,198,833.00 81,582.56 93.19% Supplies Expenses Office Supplies 421000 - General Office Supplies - 1,124.39 - 1,124.39 1,700.00 575.61 66.14% Total Office Supplies - 1,124.39 - 1,124.39 1,700.00 575.61 66.14% Operating Supplies 422000 - Other Operating Supplies 744.64 99,194.69 - 99,194.69 101,659.67 2,464.98 97.58% 422002 - Diesel/CNG 3,875.40 14,518.99 - 14,518.99 16,200.00 1,681.01 89.62% 422003 - Gasoline 1,955.57 17,549.55 - 17,549.55 23,402.60 5,853.05 74.99% 422005 - Uniforms 114.23 4,909.78 - 4,909.78 5,131.00 221.22 95.69% 422010 - Plants Chemicals Seed & Fertilizer 2,835.80 113,804.28 - 113,804.28 121,931.00 8,126.72 93.33% 422014 - Concessions Inventory (3,617.70) 129,035.59 - 129,035.59 133,818.96 4,783.37 96.43% 422016 - Inventory For Sale 3,130.00 65,712.41 - 65,712.41 67,568.21 1,855.80 97.25% Total Operating Supplies 9,037.94 444,725.29 - 444,725.29 469,711.44 24,986.15 94.68% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 44,179.29 - 44,179.29 47,703.41 3,524.12 92.61% 423006 - Small Tools & Equipment - 658.50 - 658.50 869.00 210.50 75.78% 423009 - Repair Parts 424.91 7,315.56 - 7,315.56 9,564.00 2,248.44 76.49% Total Repair & Maintenance Supplies 424.91 52,153.35 - 52,153.35 58,136.41 5,983.06 89.71% Total Supplies Expenses 9,462.85 498,003.03 - 498,003.03 529,547.85 31,544.82 94.04% Services & Charges Expenses Professional Services 431000 - Other Professional Services 100.00 31,391.12 - 31,391.12 31,459.00 67.88 99.78% 431019 - Security Services - 4,210.63 - 4,210.63 4,211.00 0.37 99.99% Total Professional Services 100.00 35,601.75 - 35,601.75 35,670.00 68.25 99.81% Communication & Transportation 432002 - Mailing - 165.50 - 165.50 166.00 0.50 99.70% 432003 - Travel - 691.99 - 691.99 714.00 22.01 96.92% Total Communication & Transportation - 857.49 - 857.49 880.00 22.51 97.44% Printing & Advertising 433003 - Promotional 57.38 49,505.91 - 49,505.91 49,549.00 43.09 99.91% Total Printing & Advertising 57.38 49,505.91 - 49,505.91 49,549.00 43.09 99.91% Utilties 435001 - Electric 3,812.36 68,786.54 - 68,786.54 69,664.00 877.46 98.74% 435002 - Natural Gas 1,943.86 18,283.81 - 18,283.81 22,407.00 4,123.19 81.60% Total Utilities 5,756.22 87,070.35 - 87,070.35 92,071.00 5,000.65 94.57% Repairs & Maintenance 436000 - Other R&M - 10,397.48 - 10,397.48 10,398.00 0.52 99.99% Total Repairs & Maintenance - 10,397.48 - 10,397.48 10,398.00 0.52 99.99% Rentals 437002 - Equipment Rental 450.00 13,678.50 - 13,678.50 13,703.00 24.50 99.82% Total Rentals 450.00 13,678.50 - 13,678.50 13,703.00 24.50 99.82% Debt Service 438100 - Principal - 95,184.68 - 95,184.68 95,185.18 0.50 100.00% 438200 - Interest - 21,589.23 - 21,589.23 21,589.56 0.33 100.00% 438300 - Paying Agent Fees - 250.00 - 250.00 250.00 - 100.00% Total Debt Service - 117,023.91 - 117,023.91 117,024.74 0.83 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 147.06 5,110.82 - 5,110.82 5,112.00 1.18 99.98% 439002 - Licenses & Permits - 1,053.73 - 1,053.73 1,835.00 781.27 57.42% 439003 - Subscriptions 72.99 3,643.88 - 3,643.88 3,744.00 100.12 97.33% 439004 - Dues & Memberships - 2,136.03 - 2,136.03 2,137.00 0.97 99.95% 439005 - Bank & Credit Card Fees 679.41 51,481.98 - 51,481.98 52,960.00 1,478.02 97.21% 439006 - Education & Training 2,814.57 3,631.21 - 3,631.21 3,632.83 1.62 99.96% 439009 - Trash Removal 1,459.95 11,376.91 - 11,376.91 12,376.98 1,000.07 91.92% 439018 - Demolition & Clearance - 18,000.00 - 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (3.51) 1,981.13 - 1,981.13 1,990.00 8.87 99.55% 439100 - Refunds/Awards/Indemnities - 12.38 - 12.38 13.00 0.62 95.23% Total Other Services & Charges 5,170.47 98,428.07 - 98,428.07 101,800.81 3,372.74 96.69% Total Services & Charges Expenses 11,534.07 412,563.46 - 412,563.46 421,096.55 8,533.09 97.97% Other Uses 452002 - Allocations-Admin Cost 7,439.00 89,268.00 - 89,268.00 89,268.00 - 100.00% 452003 - Allocations-IT 6,707.25 80,487.00 - 80,487.00 80,487.00 - 100.00% 452004 - Allocations-Liability Insurance 1,174.33 14,091.96 - 14,091.96 14,092.00 0.04 100.00% 452009 - Allocations-Facilities Mgmt 300.00 3,600.00 - 3,600.00 3,600.00 - 100.00% Total Other Uses 15,620.58 187,446.96 - 187,446.96 187,447.00 0.04 100.00% Total Expenses 114,244.55 2,215,263.89 - 2,215,263.89 2,336,924.40 121,660.51 94.79%