Loading...
HomeMy WebLinkAboutAug 23 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 67% Parks General Fund: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Taxes Property Taxes 311000 - Civil City Property Taxes - 6,352,360.58 11,426,846.00 5,074,485.42 55.59% Total Property Taxes - 6,352,360.58 11,426,846.00 5,074,485.42 55.59% Total Taxes - 6,352,360.58 11,426,846.00 5,074,485.42 55.59% State Shared Revenue 335002 - Vehicle/Aircraft Excise - 341,236.98 730,198.00 388,961.02 46.73% 335007 - Commercial Vehicle Excise - 91,464.69 170,564.00 79,099.31 53.62% Total State Shared Revenue - 432,701.67 900,762.00 468,060.33 48.04% Total Intergovernmental Revenue - 567,701.67 1,025,762.00 458,060.33 55.34% Total Nonbusiness Licenses & Permits 26.25 105.00 - (105.00) 0.00% Total Licenses & Permits 26.25 105.00 - (105.00) 0.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 4,218.61 34,489.26 30,000.00 (4,489.26) 114.96% 347002 - Picnic Site Rental 354.48 2,949.92 6,154.00 3,204.08 47.94% 347003 - Golf Season Pass 471.00 285,540.19 221,898.00 (63,642.19) 128.68% 347004 - Golf Green Fees 124,410.55 588,439.66 785,529.00 197,089.34 74.91% 347005 - Golf Cart Rentals 58,055.39 269,140.30 392,284.00 123,143.70 68.61% 347006 - Golf Pro Shop Retail 10,850.65 62,701.48 77,652.00 14,950.52 80.75% 347007 - Golf Driving Range 4,777.00 32,032.00 34,323.00 2,291.00 93.33% 347009 - Golf Outings 1,277.76 10,157.09 - (10,157.09) 0.00% 347010 - Concession Sales 13,893.27 65,248.25 56,200.00 (9,048.25) 116.10% 347011 - Recreational Programming 32,626.15 336,733.73 372,321.00 35,587.27 90.44% 347012 - Food Sales 11,156.99 53,787.83 68,447.00 14,659.17 78.58% 347013 - Nonalcoholic Beverage 7,686.06 32,301.47 41,633.00 9,331.53 77.59% 347014 - Alcoholic Beverage Sales 28,851.52 130,910.13 151,573.00 20,662.87 86.37% 347015 - Lease of Stadium 30,000.00 75,000.00 75,000.00 - 100.00% 347016 - East Race Waterway 13,547.95 56,822.20 50,000.00 (6,822.20) 113.64% 347017 - Ice Skating - 182,387.99 400,000.00 217,612.01 45.60% 347021 - Tree Maintenance 1,801.00 22,328.59 - (22,328.59) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% 347026 - Room Rental 6,175.73 62,897.76 57,972.00 (4,925.76) 108.50% 347030 - Merch Sales 74.33 901.61 - (901.61) 0.00% 347040 - Pavilion Rental 1,373.67 22,724.84 33,710.00 10,985.16 67.41% 347100 - Concessions-Employee Discounts (387.10) (1,804.13) - 1,804.13 0.00% Total Culture & Recreation 351,215.01 2,325,690.17 2,856,696.00 531,005.83 81.41% Total Charges for Services 351,215.01 2,325,690.17 2,856,696.00 531,005.83 81.41% Miscellaneous Revenue 360000 - Miscellaneous 1,686.63 7,137.47 6,483.00 (654.47) 110.10% 360001 - Sale of Scrap Metal - 964.73 - (964.73) 0.00% 360011 - Settlement Fees - 50,450.00 - (50,450.00) 0.00% 361000 - Interest Earnings 18,056.37 64,300.20 15,000.00 (49,300.20) 428.67% 362000 - Rental of Property 12,406.18 56,108.41 72,337.00 16,228.59 77.57% 367000 - Donations from Private Sources 300.00 1,445,800.00 5,184,000.00 3,738,200.00 27.89% Total Miscellaneous Revenue 32,449.18 1,624,760.81 5,277,820.00 3,653,059.19 30.78% Refunds & Reimbursements 380000 - Misc Reimbursements - 53,696.04 45,000.00 (8,696.04) 119.32% 396000 - Refunds 805.35 1,324.47 - (1,324.47) 0.00% Total Refunds & Reimbursements 805.35 55,020.51 45,000.00 (10,020.51) 122.27% Other Sources 391000 - Interfund Transfers In - 2,442,073.75 5,860,977.00 3,418,903.25 41.67% 392000 - Gain/Loss on Sale of Asset 37,352.00 37,352.00 - (37,352.00) 0.00% 392005 - Sale of Non-Capital Assets 8,418.00 8,418.00 - (8,418.00) 0.00% 393000 - Capital Lease Proceeds - - 436,000.00 436,000.00 0.00% Total Other Sources 45,770.00 2,487,843.75 6,296,977.00 3,809,133.25 39.51% Total Revenue 430,265.79 13,413,482.49 26,929,101.00 13,515,618.51 49.81% August 31, 2023 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 238,859.57 2,031,541.10 - 2,031,541.10 3,467,002.00 1,435,460.90 58.60% 410002 - Teamster Wages 115,247.27 985,416.82 - 985,416.82 1,630,310.00 644,893.18 60.44% 410003 - Permanent Part Time 128,239.87 742,324.14 - 742,324.14 1,042,770.00 300,445.86 71.19% 410004 - Extra & Overtime 14,632.78 81,107.60 - 81,107.60 71,850.00 (9,257.60) 112.88% 410005 - Seasonal & Interns 121,852.11 546,086.01 - 546,086.01 828,351.00 282,264.99 65.92% 410007 - Longevity Pay 387.50 5,037.50 - 5,037.50 9,389.00 4,351.50 53.65% 410017 - Stand By Pay 1,375.00 2,513.66 - 2,513.66 - (2,513.66) 0.00% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 620,594.10 4,394,026.83 - 4,394,026.83 7,050,872.00 2,656,845.17 62.32% Employee Benefits 411001 - FICA Regular 51,453.26 351,059.11 - 351,059.11 542,270.00 191,210.89 64.74% 411004 - PERF Regular 40,277.82 337,441.83 - 337,441.83 582,642.00 245,200.17 57.92% 411005 - PERF Union 1,213.96 10,172.28 - 10,172.28 24,703.00 14,530.72 41.18% 411007 - Unemployment Comp 38.50 319.45 - 319.45 6,200.00 5,880.55 5.15% 411008 - Health Insurance 89,122.44 704,408.72 - 704,408.72 1,274,947.00 570,538.28 55.25% 411009 - Life Insurance 870.00 6,810.00 - 6,810.00 10,920.00 4,110.00 62.36% 411010 - Med/Surgical/Dental 1,038.00 8,244.61 - 8,244.61 - (8,244.61) 0.00% 411014 - Parental Leave 1,300.24 10,798.30 - 10,798.30 18,082.00 7,283.70 59.72% 411015 - Other Fringe Benefits - 1,400.00 - 1,400.00 1,400.00 - 100.00% 411200 - Clothing Allowance - 353.08 - 353.08 356.00 2.92 99.18% 411201 - Tool Allowance 964.62 2,964.95 - 2,964.95 4,444.00 1,479.05 66.72% 411203 - Job Readiness Allow. - - - - 15,725.00 15,725.00 0.00% 411204 - Auto Allowance - 1,333.30 - 1,333.30 3,200.00 1,866.70 41.67% 411206 - Cell Phone Allowance 715.00 6,600.00 - 6,600.00 11,880.00 5,280.00 55.56% Total Employee Benefits 186,993.84 1,441,905.63 - 1,441,905.63 2,496,769.00 1,054,863.37 57.75% Total Personnel Expenses 807,587.94 5,835,932.46 - 5,835,932.46 9,547,641.00 3,711,708.54 61.12% Supplies Expenses Office Supplies 421000 - General Office Supplies 879.71 9,719.88 2,005.44 11,725.32 18,196.05 6,470.73 64.44% Total Office Supplies 879.71 9,719.88 2,005.44 11,725.32 18,196.05 6,470.73 64.44% Operating Supplies 422000 - Other Operating Supplies 23,313.14 217,754.05 14,199.32 231,953.37 311,311.06 79,357.69 74.51% 422001 - C.S. Gasoline 21,676.05 149,833.60 - 149,833.60 220,000.00 70,166.40 68.11% 422002 - Diesel/CNG 1,895.86 6,475.09 1,988.50 8,463.59 10,936.00 2,472.41 77.39% 422003 - Gasoline 2,113.47 13,406.59 631.50 14,038.09 27,981.50 13,943.41 50.17% 422005 - Uniforms 988.78 7,724.43 - 7,724.43 20,482.25 12,757.82 37.71% 422006 - Computer Supplies & Equipment 3,140.53 4,010.94 - 4,010.94 3,924.00 (86.94) 102.22% 422007 - Cleaning Supplies - 902.31 - 902.31 6,120.00 5,217.69 14.74% 422008 - Medical/Safety Supplies 395.75 9,484.33 2,260.68 11,745.01 16,309.00 4,563.99 72.02% 422009 - Recreation Supplies 5,610.72 55,857.69 8,052.12 63,909.81 141,697.68 77,787.87 45.10% 422010 - Plants Chemicals Seed & Fertilizer 11,848.06 176,818.91 9,686.41 186,505.32 264,474.00 77,968.68 70.52% 422014 - Concessions Inventory 36,837.32 142,041.86 3,554.46 145,596.32 128,408.32 (17,188.00) 113.39% 422016 - Inventory For Sale 1,111.73 60,570.62 2,205.31 62,775.93 69,742.21 6,966.28 90.01% Total Operating Supplies 108,931.41 844,880.42 42,578.30 887,458.72 1,221,386.02 333,927.30 72.66% Repair & Maintenance Supplies 423000 - Other R&M Supplies 22,133.18 170,266.34 12,419.62 182,685.96 278,919.81 96,233.85 65.50% 423001 - Building Materials 1,542.31 70,583.92 9,462.08 80,046.00 145,169.45 65,123.45 55.14% 423006 - Small Tools & Equipment 7,346.75 39,196.67 6,584.52 45,781.19 47,221.00 1,439.81 96.95% 423009 - Repair Parts 8,945.79 73,952.35 7,580.19 81,532.54 83,518.24 1,985.70 97.62% Total Repair & Maintenance Supplies 39,968.03 353,999.28 36,046.41 390,045.69 554,828.50 164,782.81 70.30% Total Supplies Expenses 149,779.15 1,208,599.58 80,630.15 1,289,229.73 1,794,410.57 505,180.84 71.85% Services & Charges Expenses Professional Services 431000 - Other Professional Services 23,549.88 218,747.41 58,934.63 277,682.04 277,384.71 (297.33) 100.11% 431001 - Legal Services 4,855.50 5,855.50 47,825.00 53,680.50 4,500.00 (49,180.50) 1192.90% 431009 - Computer & Technology - 7,750.00 - 7,750.00 8,275.00 525.00 93.66% 431014 - Collection Costs 8.75 64.50 - 64.50 100.00 35.50 64.50% 431019 - Security Services 7,701.79 35,013.01 12,636.00 47,649.01 173,869.00 126,219.99 27.41% Total Professional Services 36,115.92 267,430.42 119,395.63 386,826.05 464,128.71 77,302.66 83.34% Communication & Transportation 432002 - Mailing 365.69 5,178.72 108.70 5,287.42 6,575.00 1,287.58 80.42% 432003 - Travel 2,222.54 5,756.09 16,797.44 22,553.53 30,880.41 8,326.88 73.04% 432004 - Telecommunications 87.72 1,226.75 2,320.64 3,547.39 12,923.80 9,376.41 27.45% 432005 - Mileage Reimb 220.08 1,131.66 176.96 1,308.62 6,494.96 5,186.34 20.15% Total Communication & Transportation 2,896.03 13,293.22 19,403.74 32,696.96 56,874.17 24,177.21 57.49% Printing & Advertising 433001 - Outside Printing Services 2,275.28 5,264.25 2,391.75 7,656.00 15,165.00 7,509.00 50.48% 433002 - Publication of Legal Notice - 1,038.00 834.69 1,872.69 3,277.72 1,405.03 57.13% 433003 - Promotional 91,132.05 225,230.35 184,040.47 409,270.82 699,608.90 290,338.08 58.50% Total Printing & Advertising 93,407.33 231,532.60 187,266.91 418,799.51 718,051.62 299,252.11 58.32% Utilties 435001 - Electric 47,577.85 357,764.49 - 357,764.49 538,707.00 180,942.51 66.41% 435002 - Natural Gas 2,097.13 131,779.32 - 131,779.32 309,583.00 177,803.68 42.57% 435004 - Water 34,243.28 171,715.50 - 171,715.50 300,000.00 128,284.50 57.24% Total Utilities 83,918.26 661,259.31 - 661,259.31 1,148,290.00 487,030.69 57.59% Repairs & Maintenance 436000 - Other R&M 16,530.39 69,908.12 38,500.85 108,408.97 209,322.99 100,914.02 51.79% 436001 - Building R&M 32,417.63 355,691.63 86,857.15 442,548.78 444,077.60 1,528.82 99.66% 436003 - Auto Equip R&M 22,329.05 184,206.51 - 184,206.51 346,750.00 162,543.49 53.12% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 8,042.10 1,125.68 86.00% 436006 - Radio Equip R&M 1,908.30 16,714.91 - 16,714.91 16,814.00 99.09 99.41% 436011 - Exterminating 899.00 3,830.00 9,557.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 74,084.37 637,267.59 134,915.00 772,182.59 1,041,348.69 269,166.10 74.15% Rentals 437002 - Equipment Rental 5,275.46 9,110.90 - 9,110.90 8,421.00 (689.90) 108.19% 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,260.00 60.00 95.24% Total Rentals 5,275.46 22,310.90 - 22,310.90 21,681.00 (629.90) 102.91% Debt Service 438100 - Principal 58,015.42 462,762.21 - 462,762.21 548,925.00 86,162.79 84.30% 438200 - Interest 19,730.79 51,794.54 - 51,794.54 46,466.00 (5,328.54) 111.47% 438300 - Paying Agent Fees 250.00 5,200.00 - 5,200.00 5,500.00 300.00 94.55% Total Debt Service 77,996.21 519,756.75 - 519,756.75 600,891.00 81,134.25 86.50% Other Charges & Services 439000 - Misc Charges & Svcs 17,673.88 124,324.52 71,075.33 195,399.85 260,012.96 64,613.11 75.15% 439001 - Other Contractual Services 28,100.24 104,217.18 45,309.89 149,527.07 149,059.00 (468.07) 100.31% 439002 - Licenses & Permits - 6,749.11 - 6,749.11 12,640.00 5,890.89 53.39% 439003 - Subscriptions 391.95 4,946.23 - 4,946.23 5,914.00 967.77 83.64% 439004 - Dues & Memberships 479.99 11,267.26 - 11,267.26 21,732.00 10,464.74 51.85% 439005 - Bank & Credit Card Fees 7,842.49 68,216.94 - 68,216.94 108,798.00 40,581.06 62.70% 439006 - Education & Training 3,313.32 27,500.45 17,227.31 44,727.76 45,369.45 641.69 98.59% 439009 - Trash Removal 5,424.61 35,665.07 5,997.91 41,662.98 55,567.03 13,904.05 74.98% 439012 - Uniform Services 1,516.81 14,348.89 - 14,348.89 25,941.00 11,592.11 55.31% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (71.15) 236.28 - 236.28 10.00 (226.28) 2362.80% 439100 - Refunds/Awards/Indemnities - 5,284.07 - 5,284.07 34,027.00 28,742.93 15.53% 439300 - Grants & Subsidies 375.00 615,375.00 3,000.00 618,375.00 635,000.00 16,625.00 97.38% Total Other Services & Charges 65,047.14 1,035,231.00 143,510.44 1,178,741.44 1,372,070.44 193,329.00 85.91% Total Services & Charges Expenses 438,740.72 3,388,081.79 604,491.72 3,992,573.51 5,423,335.63 1,430,762.12 73.62% Capital Outlay Buildings 443001 - Building Improvements - - 250.00 250.00 6,000,250.00 6,000,000.00 0.00% Total Buildings - - 250.00 250.00 6,000,250.00 6,000,000.00 0.00% 444000 - Land Improvements 15,852.50 313,031.45 455,208.26 768,239.71 2,037,097.38 1,268,857.67 37.71% Machinery & Equipment 445000 - Motor Equipment - - - - 21,726.00 21,726.00 0.00% 445003 - Park Equipment 15,277.00 53,009.62 875,513.40 928,523.02 1,207,819.00 279,295.98 76.88% 445008 - Other Equipment 29,121.03 29,121.03 - 29,121.03 29,121.03 - 100.00% 445100 - Lease Purchase/Motor Equip 253,531.83 526,065.83 250,862.00 776,927.83 1,047,863.30 270,935.47 74.14% 445108 - Lease Purchase/Other Equip - - - - 436,000.00 436,000.00 0.00% Total Machinery & Equipment 297,929.86 608,196.48 1,126,375.40 1,734,571.88 2,742,529.33 1,007,957.45 63.25% Total Capital Expenses 313,782.36 921,227.93 1,581,833.66 2,503,061.59 10,779,876.71 8,276,815.12 23.22% Other Uses 452002 - Allocations-Admin Cost - 377,182.08 - 377,182.08 754,364.00 377,181.92 50.00% 452003 - Allocations-IT - 372,698.52 - 372,698.52 745,397.00 372,698.48 50.00% 452004 - Allocations-Liability Insurance - 139,021.98 - 139,021.98 278,044.00 139,022.02 50.00% 452008 - Allocations-Payroll Cost - 42,193.50 - 42,193.50 84,387.00 42,193.50 50.00% 452009 - Allocations-Facilities Mgmt - 14,620.50 - 14,620.50 29,241.00 14,620.50 50.00% Total Other Uses - 945,716.58 - 945,716.58 1,891,433.00 945,716.42 50.00% Total Expenses 1,709,890.17 12,299,558.34 2,266,955.53 14,566,513.87 29,436,696.91 14,870,183.04 49.48%