Loading...
HomeMy WebLinkAboutJune 22 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 50% Parks General Fund: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Taxes Property Taxes 311000 - Civil City Property Taxes 5,801,007.69 5,801,007.69 10,580,413.00 4,779,405.31 54.83% Total Property Taxes 5,801,007.69 5,801,007.69 10,580,413.00 4,779,405.31 54.83% Total Taxes 5,801,007.69 5,801,007.69 10,580,413.00 4,779,405.31 54.83% Total Intergovernmental Revenue 427,491.38 427,491.38 953,848.00 526,356.62 44.82% Licenses & Permits Nonbusiness Licenses & Permits 322050 - Park Food Sales Permit 30.00 160.00 250.00 90.00 64.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 15,405.46 15,629.46 40,213.00 24,583.54 38.87% 347002 - Picnic Site Rental 976.56 2,424.60 -(2,424.60)0.00% 347003 - Golf Season Pass 11,097.00 267,112.20 172,000.00 (95,112.20)155.30% 347004 - Golf Green Fees 176,497.76 323,369.61 805,000.00 481,630.39 40.17% 347005 - Golf Cart Rentals 75,921.09 143,710.28 365,000.00 221,289.72 39.37% 347006 - Golf Pro Shop Retail 13,725.69 29,878.59 59,500.00 29,621.41 50.22% 347007 - Golf Driving Range 7,821.00 17,285.00 30,000.00 12,715.00 57.62% 347008 - Golf Gift Certificate -35.00 -(35.00)0.00% 347009 - Golf Outings 1,655.70 4,278.83 -(4,278.83)0.00% 347010 - Concession Sales 22,450.06 31,775.76 69,000.00 37,224.24 46.05% 347011 - Recreational Programming 46,645.71 275,742.94 523,565.00 247,822.06 52.67% 347012 - Food Sales 13,655.46 26,400.59 53,277.00 26,876.41 49.55% 347013 - Nonalcoholic Beverage 8,568.26 15,074.58 31,500.00 16,425.42 47.86% 347014 - Alcoholic Beverage Sales 27,921.84 59,151.35 110,900.00 51,748.65 53.34% 347015 - Lease of Stadium 15,000.00 30,000.00 75,000.00 45,000.00 40.00% 347016 - East Race Waterway 12,954.25 14,102.80 60,000.00 45,897.20 23.50% 347017 - Ice Skating -197,057.38 300,000.00 102,942.62 65.69% 347019 - Site Mowing --222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 29,647.88 82,133.34 120,000.00 37,866.66 68.44% 347026 - Room Rental 5,993.31 71,707.75 56,000.00 (15,707.75)128.05% 347030 - Merch Sales 130.28 1,436.58 -(1,436.58)0.00% 347040 - Pavilion Rental 4,930.84 21,083.83 15,000.00 (6,083.83)140.56% 347100 - Concessions-Employee Discounts (371.20)(782.32)-782.32 0.00% Total Culture & Recreation 490,626.95 1,628,608.15 3,108,794.00 1,480,185.85 52.39% Total Charges for Services 490,626.95 1,628,608.15 3,108,794.00 1,480,185.85 52.39% Miscellaneous Revenue 360000 - Miscellaneous 259.87 5,933.65 9,500.00 3,566.35 62.46% 360001 - Sale of Scrap Metal -846.32 -(846.32)0.00% 361000 - Interest Earnings 1,068.65 8,201.08 15,000.00 6,798.92 54.67% 362000 - Rental of Property 5,815.75 32,824.50 60,000.00 27,175.50 54.71% 367000 - Donations from Private Sources 160,000.00 640,828.93 1,061,000.00 420,171.07 60.40% Total Miscellaneous Revenue 167,144.27 688,634.48 1,145,500.00 456,865.52 60.12% Refunds & Reimbursements 380000 - Misc Reimbursements 52.62 17,819.57 18,253.00 433.43 97.63% 380007 - Energy Rebates -808.98 809.00 0.02 100.00% 381000 - Misc Reimbursements -4,916.40 245,441.00 240,524.60 2.00% 396000 - Refunds 8.10 43,283.77 43,284.00 0.23 100.00% Total Refunds & Reimbursements 60.72 66,828.72 307,787.00 240,958.28 21.71% Other Sources 391000 - Interfund Transfers In 9,935.00 59,611.00 119,221.00 59,610.00 50.00% 393000 - Capital Lease Proceeds 1,290,000.00 1,290,000.00 1,290,000.00 -100.00% Total Other Sources 1,299,935.00 1,349,611.00 1,409,221.00 59,610.00 95.77% Total Revenue 8,186,296.01 9,962,341.42 17,505,813.00 7,543,471.58 56.91% EXPENDITURES June 30, 2022 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 219,605.76 1,410,811.47 -1,410,811.47 3,049,049.00 1,638,237.53 46.27% 410002 - Teamster Wages 103,855.23 708,642.02 -708,642.02 1,552,175.00 843,532.98 45.65% 410003 - Permanent Part Time 101,115.36 383,649.87 -383,649.87 1,039,670.00 656,020.13 36.90% 410004 - Extra & Overtime 25,142.10 64,549.95 -64,549.95 85,975.00 21,425.05 75.08% 410005 - Seasonal & Interns 111,049.56 298,692.03 -298,692.03 834,551.00 535,858.97 35.79% 410007 - Longevity Pay 300.00 4,845.83 -4,845.83 8,450.00 3,604.17 57.35% 410014 - Contract Add Pays ------0.00% 410017 - Stand By Pay 336.12 1,289.48 -1,289.48 3,500.00 2,210.52 36.84% 410022 - Park Board Stipend ----1,200.00 1,200.00 0.00% Total Salaries & Wages 561,404.13 2,872,480.65 - 2,872,480.65 6,574,570.00 3,702,089.35 43.69% Employee Benefits 411001 - FICA Regular 41,701.85 227,085.84 -227,085.84 506,363.00 279,277.16 44.85% 411004 - PERF Regular 38,024.00 252,805.19 -252,805.19 530,630.00 277,824.81 47.64% 411005 - PERF Union 1,404.19 9,690.15 -9,690.15 26,912.00 17,221.85 36.01% 411007 - Unemployment Comp 576.80 3,350.97 -3,350.97 7,520.00 4,169.03 44.56% 411008 - Health Insurance 87,027.38 516,710.52 -516,710.52 1,192,876.00 676,165.48 43.32% 411009 - Life Insurance 825.00 4,905.00 -4,905.00 10,560.00 5,655.00 46.45% 411014 - Parental Leave 1,204.89 7,639.44 -7,639.44 16,447.00 8,807.56 46.45% 411015 - Other Fringe Benefits -1,490.00 -1,490.00 1,500.00 10.00 99.33% 411201 - Tool Allowance -2,923.62 -2,923.62 4,800.00 1,876.38 60.91% 411203 - Job Readiness Allow.-14,875.00 -14,875.00 19,425.00 4,550.00 76.58% 411204 - Auto Allowance 266.66 1,599.96 -1,599.96 3,200.00 1,600.04 50.00% 411206 - Cell Phone Allowance 1,045.00 6,325.00 -6,325.00 11,820.00 5,495.00 53.51% Total Employee Benefits 172,075.77 1,049,400.69 - 1,049,400.69 2,332,053.00 1,282,652.31 45.00% Total Personnel Expenses 733,479.90 3,921,881.34 - 3,921,881.34 8,906,623.00 4,984,741.66 44.03% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,394.13 7,751.78 506.63 8,258.41 23,529.18 15,270.77 35.10% Total Office Supplies 1,394.13 7,751.78 506.63 8,258.41 23,529.18 15,270.77 35.10% Operating Supplies 422000 - Other Operating Supplies 48,665.02 162,306.11 32,544.28 194,850.39 280,554.02 85,703.63 69.45% 422001 - C.S. Gasoline 22,259.04 108,430.51 -108,430.51 165,000.00 56,569.49 65.72% 422002 - Diesel/CNG -1,886.00 1,693.50 3,579.50 4,000.00 420.50 89.49% 422003 - Gasoline -10,462.61 2,301.50 12,764.11 25,905.00 13,140.89 49.27% 422004 - Oil -35.30 -35.30 50.00 14.70 70.60% 422005 - Uniforms 3,338.47 6,316.77 1,763.25 8,080.02 21,695.00 13,614.98 37.24% 422006 - Computer Supplies & Equipment -319.93 -319.93 500.00 180.07 63.99% 422007 - Cleaning Supplies 1,446.78 1,531.91 -1,531.91 4,950.00 3,418.09 30.95% 422008 - Medical/Safety Supplies 1,374.99 11,156.90 165.84 11,322.74 15,556.00 4,233.26 72.79% 422009 - Recreation Supplies 9,162.59 55,432.32 66,330.36 121,762.68 250,301.60 128,538.92 48.65% 422010 - Plants Chemicals Seed & Fertilizer 7,686.85 117,509.18 42,373.05 159,882.23 182,575.00 22,692.77 87.57% 422014 - Concessions Inventory 36,988.03 63,432.57 5,382.91 68,815.48 86,405.00 17,589.52 79.64% 422016 - Inventory For Sale 2,807.78 32,816.62 209.00 33,025.62 34,035.00 1,009.38 97.03% Total Operating Supplies 133,729.55 571,636.73 152,763.69 724,400.42 1,071,526.62 347,126.20 67.60% Repair & Maintenance Supplies 423000 - Other R&M Supplies 17,140.77 125,880.50 62,535.90 188,416.40 275,265.04 86,848.64 68.45% 423001 - Building Materials 9,294.11 36,724.51 9,402.35 46,126.86 90,000.00 43,873.14 51.25% 423006 - Small Tools & Equipment 1,240.49 10,816.96 31.53 10,848.49 25,573.00 14,724.51 42.42% 423009 - Repair Parts 5,548.06 35,618.74 2,175.00 37,793.74 82,429.03 44,635.29 45.85% Total Repair & Maintenance Supplies 33,223.43 209,040.71 74,144.78 283,185.49 473,267.07 190,081.58 59.84% Total Supplies Expenses 168,347.11 788,429.22 227,415.10 1,015,844.32 1,568,322.87 552,478.55 64.77% Services & Charges Expenses Professional Services 431000 - Other Professional Services 8,781.50 54,977.41 32,653.10 87,630.51 101,877.00 14,246.49 86.02% 431009 - Computer & Technology -31.83 -31.83 500.00 468.17 6.37% 431014 - Collection Costs 11.25 23.75 -23.75 50.00 26.25 47.50% 431019 - Security Services 313.02 17,686.07 -17,686.07 18,118.00 431.93 97.62% Total Professional Services 9,105.77 72,719.06 32,653.10 105,372.16 120,545.00 15,172.84 87.41% Communication & Transportation 432002 - Mailing 60.06 416.52 -416.52 4,875.00 4,458.48 8.54% 432003 - Travel 179.88 2,732.03 5,670.73 8,402.76 27,450.00 19,047.24 30.61% 432004 - Telecommunications -1,126.46 3,513.80 4,640.26 10,003.80 5,363.54 46.38% 432005 - Mileage Reimb 303.32 303.32 176.96 480.28 5,705.00 5,224.72 8.42% Total Communication & Transportation 543.26 4,578.33 9,361.49 13,939.82 48,033.80 34,093.98 29.02% Printing & Advertising 433001 - Outside Printing Services 1,031.31 7,474.56 1,080.00 8,554.56 25,280.00 16,725.44 33.84% 433002 - Publication of Legal Notice -495.60 879.40 1,375.00 2,000.00 625.00 68.75% 433003 - Promotional 72,122.05 205,104.64 73,133.73 278,238.37 393,614.06 115,375.69 70.69% Total Printing & Advertising 73,153.36 213,074.80 75,093.13 288,167.93 420,894.06 132,726.13 68.47% Utilties 435001 - Electric 48,399.00 255,414.38 -255,414.38 452,847.00 197,432.62 56.40% 435002 - Natural Gas 2,505.88 134,043.44 -134,043.44 113,457.00 (20,586.44)118.14% 435004 - Water 39,935.26 84,983.77 -84,983.77 214,000.00 129,016.23 39.71% Total Utilities 90,840.14 474,441.59 - 474,441.59 780,304.00 305,862.41 60.80% Repairs & Maintenance 436000 - Other R&M 3,133.77 14,392.30 24,528.74 38,921.04 88,600.53 49,679.49 43.93% 436001 - Building R&M 56,028.61 138,405.22 43,236.91 181,642.13 206,994.82 25,352.69 87.75% 436003 - Auto Equip R&M 16,009.20 164,801.70 -164,801.70 297,000.00 132,198.30 55.49% 436005 - Other Equip R&M -1,309.67 -1,309.67 6,800.00 5,490.33 19.26% 436006 - Radio Equip R&M 2,845.35 6,267.44 -6,267.44 3,500.00 (2,767.44)179.07% 436011 - Exterminating -3,416.00 746.00 4,162.00 8,334.00 4,172.00 49.94% Total Repairs & Maintenance 78,016.93 328,592.33 68,511.65 397,103.98 611,229.35 214,125.37 64.97% Rentals 437005 - Parking Space Rental -12,000.00 -12,000.00 12,000.00 -100.00% 437006 - Recreation Space Rental -1,200.00 -1,200.00 1,200.00 -100.00% Total Rentals - 13,200.00 - 13,200.00 13,200.00 - 100.00% Debt Service 438100 - Principal -183,746.16 -183,746.16 387,682.81 203,936.65 47.40% 438200 - Interest -14,430.88 -14,430.88 23,339.19 8,908.31 61.83% 438300 - Paying Agent Fees -4,400.00 -4,400.00 5,000.00 600.00 88.00% Total Debt Service - 202,577.04 - 202,577.04 416,022.00 213,444.96 48.69% Other Charges & Services 439000 - Misc Charges & Svcs 60,662.41 232,248.36 325,276.55 557,524.91 734,077.29 176,552.38 75.95% 439001 - Other Contractual Services 629.40 1,279.39 6,060.00 7,339.39 11,000.00 3,660.61 66.72% 439002 - Licenses & Permits -9,780.51 435.00 10,215.51 12,625.00 2,409.49 80.91% 439003 - Subscriptions 469.86 1,860.58 -1,860.58 3,720.00 1,859.42 50.02% 439004 - Dues & Memberships 6,025.00 8,068.01 -8,068.01 18,510.00 10,441.99 43.59% 439005 - Bank & Credit Card Fees 10,850.73 48,138.08 -48,138.08 80,835.00 32,696.92 59.55% 439006 - Education & Training 2,549.00 12,289.94 2,554.00 14,843.94 25,825.00 10,981.06 57.48% 439009 - Trash Removal 548.60 25,869.55 15,821.61 41,691.16 46,734.41 5,043.25 89.21% 439012 - Uniform Services -7,220.30 -7,220.30 8,200.00 979.70 88.05% 439018 - Demolition & Clearance --18,000.00 18,000.00 18,000.00 -100.00% 439099 - Cashier Over/Short (970.46)838.50 -838.50 2,300.00 1,461.50 36.46% 439100 - Refunds/Awards/Indemnities 4,367.17 16,419.12 -16,419.12 30,485.00 14,065.88 53.86% 439300 - Grants & Subsidies -715,000.00 -715,000.00 715,000.00 -100.00% Total Other Services & Charges 85,131.71 1,079,012.34 368,147.16 1,447,159.50 1,707,311.70 260,152.20 84.76% Total Services & Charges Expenses 336,791.17 2,388,195.49 553,766.53 2,941,962.02 4,117,539.91 1,175,577.89 71.45% Capital Outlay Buildings 443001 - Building Improvements 96,400.00 100,948.75 1,501.25 102,450.00 102,450.00 -100.00% Total Buildings 96,400.00 100,948.75 1,501.25 102,450.00 102,450.00 - 100.00% 444000 - Land Improvements 8,896.50 216,716.38 843,753.32 1,060,469.70 1,294,470.49 234,000.79 81.92% Machinery & Equipment 445000 - Motor Equipment -10,866.95 -10,866.95 10,866.86 (0.09)100.00% 445003 - Park Equipment 7,062.50 7,062.50 120,939.84 128,002.34 686,027.50 558,025.16 18.66% 445006 - Computer Equip/Network --17,009.17 17,009.17 17,011.00 1.83 99.99% 445100 - Lease Purchase/Motor Equip --513,394.53 513,394.53 1,290,000.00 776,605.47 39.80% Total Machinery & Equipment 7,062.50 17,929.45 651,343.54 669,272.99 2,003,905.36 1,334,632.37 33.40% Total Capital Expenses 112,359.00 335,594.58 1,496,598.11 1,832,192.69 3,400,825.85 1,568,633.16 53.87% Other Uses 452002 - Allocations-Admin Cost 61,510.58 369,063.52 -369,063.52 738,127.00 369,063.48 50.00% 452003 - Allocations-IT 57,450.84 344,704.96 -344,704.96 689,410.00 344,705.04 50.00% 452004 - Allocations-Liability Insurance 24,384.42 146,306.48 -146,306.48 292,613.00 146,306.52 50.00% 452008 - Allocations-Payroll Cost 6,895.25 41,371.50 -41,371.50 82,743.00 41,371.50 50.00% 452009 - Allocations-Facilities Mgmt 2,296.25 13,777.50 -13,777.50 27,555.00 13,777.50 50.00% Total Other Uses 152,537.34 915,223.96 - 915,223.96 1,830,448.00 915,224.04 50.00% Total Expenses 1,503,514.52 8,349,324.59 2,277,779.74 10,627,104.33 19,823,759.63 9,196,655.30 53.61%