Loading...
HomeMy WebLinkAboutSept 21 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 118.00 218,202.77 93,000.00 (125,202.77) 234.63% 347004 - Golf Green Fees 120,111.92 725,812.45 795,000.00 69,187.55 91.30% 347005 - Golf Cart Rentals 51,942.38 341,285.43 360,000.00 18,714.57 94.80% 347006 - Golf Pro Shop Retail 9,144.70 68,470.87 59,500.00 (8,970.87) 115.08% 347007 - Golf Driving Range 4,762.00 31,177.97 30,000.00 (1,177.97) 103.93% 347008 - Golf Gift Certificate - 5.00 - (5.00) 0.00% 347012 - Food Sales 11,398.38 60,621.21 53,277.00 (7,344.21) 113.78% 347013 - Nonalcoholic Beverage 5,951.78 37,488.33 33,398.00 (4,090.33) 112.25% 347014 - Alcoholic Beverage Sales 23,093.56 132,370.04 110,000.00 (22,370.04) 120.34% 347026 - Room Rental 450.00 2,300.00 - (2,300.00) 0.00% 347100 - Concessions-Employee Discounts (386.10) (3,182.53) - 3,182.53 0.00% Total Culture & Recreation 226,586.62 1,614,551.54 1,534,175.00 (80,376.54) 105.24% Total Charges for Services 226,586.62 1,614,551.54 1,534,175.00 (80,376.54) 105.24% Miscellaneous Revenue 360000 - Miscellaneous 249.41 2,811.60 5,000.00 2,188.40 56.23% Total Miscellaneous Revenue 249.41 2,811.60 5,000.00 2,188.40 56.23% Refunds & Reimbursements 380000 - Misc Reimbursements - 3,717.00 3,176.00 (541.00) 117.03% 396000 - Refunds - 3,263.85 3,264.00 0.15 100.00% Total Refunds & Reimbursements - 6,980.85 6,440.00 (540.85) 108.40% Total Revenue 226,836.03 1,624,343.99 1,545,615.00 (78,728.99) 105.09% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 25,809.79 242,549.42 - 242,549.42 308,284.00 65,734.58 78.68% 410002 - Teamster Wages 6,284.19 57,733.17 - 57,733.17 83,842.00 26,108.83 68.86% 410003 - Permanent Part Time 31,055.54 184,166.54 - 184,166.54 234,000.00 49,833.46 78.70% 410004 - Extra & Overtime 579.56 4,224.96 - 4,224.96 5,050.00 825.04 83.66% 410005 - Seasonal & Interns 7,205.59 45,933.40 - 45,933.40 60,673.00 14,739.60 75.71% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 100.00% Total Salaries & Wages 70,934.67 535,207.49 - 535,207.49 692,449.00 157,241.51 77.29% Employee Benefits 411001 - FICA Regular 5,314.83 39,841.76 - 39,841.76 53,149.00 13,307.24 74.96% 411004 - PERF Regular 3,565.18 34,545.27 - 34,545.27 46,907.00 12,361.73 73.65% 411005 - PERF Union 49.13 765.80 - 765.80 1,330.00 564.20 57.58% 411007 - Unemployment Comp 10.20 93.36 - 93.36 124.00 30.64 75.29% 411008 - Health Insurance 7,805.94 73,360.36 - 73,360.36 82,943.00 9,582.64 88.45% 411009 - Life Insurance 80.00 685.00 - 685.00 960.00 275.00 71.35% 411014 - Parental Leave 113.80 1,062.57 - 1,062.57 1,458.00 395.43 72.88% 411015 - Other Fringe Benefits - 400.00 - 400.00 400.00 - 100.00% 411201 - Tool Allowance - - - - 400.00 400.00 0.00% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 100.00% 411206 - Cell Phone Allowance 55.00 495.00 - 495.00 660.00 165.00 75.00% Total Employee Benefits 16,994.08 152,099.12 - 152,099.12 189,181.00 37,081.88 80.40% Total Personnel Expenditures 87,928.75 687,306.61 - 687,306.61 881,630.00 194,323.39 77.96% September 30, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies 97.89 1,530.33 - 1,530.33 934.00 (596.33) 163.85% 421002 - Stationary & Printing 305.58 329.11 - 329.11 - (329.11) 0.00% Total Office Supplies 403.47 1,859.44 - 1,859.44 934.00 (925.44) 199.08% Operating Supplies 422000 - Other Operating Supplies 13,534.66 81,332.46 2,562.17 83,894.63 67,334.00 (16,560.63) 124.59% 422001 - C.S. Gasoline 1,173.20 1,173.20 - 1,173.20 1,900.00 726.80 61.75% 422002 - Diesel/CNG - 8,199.94 1,500.00 9,699.94 10,947.00 1,247.06 88.61% 422003 - Gasoline 2,334.80 8,436.88 - 8,436.88 10,556.00 2,119.12 79.92% 422005 - Uniforms 241.81 1,790.72 142.50 1,933.22 2,900.00 966.78 66.66% 422010 - Plants Chemicals Seed & Fertilizer 1,451.65 77,181.14 10,049.86 87,231.00 84,351.77 (2,879.23) 103.41% 422014 - Concessions Inventory 6,777.49 68,319.37 12,292.14 80,611.51 64,048.00 (16,563.51) 125.86% 422016 - Inventory For Sale - 34,462.31 7,912.08 42,374.39 41,905.00 (469.39) 101.12% Total Operating Supplies 25,513.61 280,896.02 34,458.75 315,354.77 283,941.77 (31,413.00) 111.06% Repair & Maintenance Supplies 423000 - Other R&M Supplies 2,468.90 26,157.77 3,044.82 29,202.59 28,742.00 (460.59) 101.60% 423001 - Building Materials - 393.64 - 393.64 394.00 0.36 99.91% 423006 - Small Tools & Equipment - 31,175.00 - 31,175.00 31,175.00 - 100.00% 423009 - Repair Parts 451.63 2,186.14 161.24 2,347.38 1,491.23 (856.15) 157.41% Total Repair & Maintenance Supplies 2,920.53 59,912.55 3,206.06 63,118.61 61,802.23 (1,316.38) 102.13% Total Supplies Expenditures 28,837.61 342,668.01 37,664.81 380,332.82 346,678.00 (33,654.82) 109.71% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,315.04 13,716.84 7,090.00 20,806.84 15,096.65 (5,710.19) 137.82% 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 100.00% 431019 - Security Services 572.68 4,052.65 - 4,052.65 5,056.00 1,003.35 80.16% Total Professional Services 1,887.72 17,784.49 7,090.00 24,874.49 20,167.65 (4,706.84) 123.34% Communication & Transportation 432002 - Mailing - 12.10 - 12.10 13.00 0.90 93.08% 432004 - Telecommunications - 80.87 9.13 90.00 243.00 153.00 37.04% Total Communication & Transportation - 92.97 9.13 102.10 256.00 153.90 39.88% Printing & Advertising 433003 - Promotional - 680.00 - 680.00 681.00 1.00 99.85% Total Printing & Advertising - 680.00 - 680.00 681.00 1.00 99.85% Utilties 435001 - Electric 7,744.00 51,808.97 - 51,808.97 45,035.00 (6,773.97) 115.04% 435002 - Natural Gas 202.97 11,999.47 - 11,999.47 15,419.00 3,419.53 77.82% Total Utilities 7,946.97 63,808.44 - 63,808.44 60,454.00 (3,354.44) 105.55% Repairs & Maintenance 436000 - Other R&M - 8,697.00 26,151.54 34,848.54 40,197.00 5,348.46 86.69% Total Repairs & Maintenance - 8,697.00 26,151.54 34,848.54 40,197.00 5,348.46 86.69% Rentals 437002 - Equipment Rental 420.00 556.00 - 556.00 - (556.00) 0.00% Total Rentals 420.00 556.00 - 556.00 - (556.00) 0.00% Debt Service 438100 - Principal - 65,325.96 - 65,325.96 65,326.00 0.04 100.00% 438200 - Interest - 8,479.62 - 8,479.62 8,480.00 0.38 100.00% Total Debt Service - 73,805.58 - 73,805.58 73,806.00 0.42 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 210.11 5,622.17 384.43 6,006.60 7,128.43 1,121.83 84.26% 439001 - Other Contractual Services - 53.66 333.80 387.46 387.80 0.34 99.91% 439002 - Licenses & Permits - 4,715.59 - 4,715.59 5,531.00 815.41 85.26% 439003 - Subscriptions 64.99 2,519.92 - 2,519.92 390.00 (2,129.92) 646.13% 439004 - Dues & Memberships - 623.04 - 623.04 3,279.00 2,655.96 19.00% 439005 - Bank & Credit Card Fees 5,195.36 34,948.69 - 34,948.69 31,400.00 (3,548.69) 111.30% 439009 - Trash Removal 2,038.29 4,731.23 232.18 4,963.41 4,345.00 (618.41) 114.23% 439099 - Cashier Over/Short (193.54) (602.47) - (602.47) 15.00 617.47 (4016.47%) 439100 - Refunds/Awards/Indemnities 141.07 1,205.91 - 1,205.91 1,405.00 199.09 85.83% Total Other Services & Charges 7,456.28 53,817.74 950.41 54,768.15 53,881.23 (886.92) 101.65% Total Services & Charges Expenditures 17,710.97 219,242.22 34,201.08 253,443.30 249,442.88 (4,000.42) 101.60% Other Uses 452002 - Allocations-Admin Cost 6,281.00 56,529.00 - 56,529.00 75,372.00 18,843.00 75.00% 452004 - Allocations-Liability Insurance 859.00 7,730.00 - 7,730.00 10,307.00 2,577.00 75.00% 452009 - Allocations-Facilities Mgmt 218.00 1,961.00 - 1,961.00 2,615.00 654.00 74.99% Total Other Uses 7,358.00 66,220.00 - 66,220.00 88,294.00 22,074.00 75.00% Total Expenditures 141,835.33 1,315,436.84 71,865.89 1,387,302.73 1,566,044.88 178,742.15 88.59%