Loading...
HomeMy WebLinkAboutMay 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 16,015.00 219,751.85 93,000.00 (126,751.85) (136.29%) 347004 - Golf Green Fees 111,329.81 201,585.91 795,000.00 593,414.09 74.64% 347005 - Golf Cart Rentals 49,049.61 89,604.50 360,000.00 270,395.50 75.11% 347006 - Golf Pro Shop Retail 10,795.41 22,197.89 59,500.00 37,302.11 62.69% 347007 - Golf Driving Range 4,590.97 9,871.97 30,000.00 20,128.03 67.09% 347008 - Golf Gift Certificate (844.85) (12,713.74) - 12,713.74 0.00% 347012 - Food Sales 8,590.85 16,176.02 53,277.00 37,100.98 69.64% 347013 - Nonalcoholic Beverage 4,788.47 8,166.57 33,398.00 25,231.43 75.55% 347014 - Alcoholic Beverage Sales 21,080.12 35,415.42 110,000.00 74,584.58 67.80% 347026 - Room Rental 200.00 300.00 - (300.00) 0.00% 347100 - Concessions-Employee Discounts (563.12) (754.26) - 754.26 0.00% Total Culture & Recreation 225,032.27 589,602.13 1,534,175.00 944,572.87 61.57% Total Charges for Services 225,032.27 589,602.13 1,534,175.00 944,572.87 61.57% Miscellaneous Revenue 360000 - Miscellaneous 304.64 1,343.88 5,000.00 3,656.12 73.12% Total Miscellaneous Revenue 304.64 1,343.88 5,000.00 3,656.12 73.12% Refunds & Reimbursements 396000 - Refunds - 3,263.85 - (3,263.85) 0.00% Total Refunds & Reimbursements - 3,263.85 - (3,263.85) 0.00% Total Revenue 225,336.91 594,209.86 1,539,175.00 944,965.14 61.39% 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,477.45 139,894.90 - 139,894.90 329,507.00 189,612.10 57.54% 410002 - Teamster Wages 3,241.60 35,384.93 - 35,384.93 83,842.00 48,457.07 57.80% 410003 - Permanent Part Time 29,306.51 60,215.98 - 60,215.98 245,500.00 185,284.02 75.47% 410004 - Extra & Overtime 457.50 791.98 - 791.98 2,550.00 1,758.02 68.94% 410005 - Seasonal & Interns 5,603.64 12,044.58 - 12,044.58 30,450.00 18,405.42 60.44% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 0.00% Total Salaries & Wages 64,086.70 248,932.37 - 248,932.37 692,449.00 443,516.63 64.05% Employee Benefits 411001 - FICA Regular 4,774.76 18,421.72 - 18,421.72 53,149.00 34,727.28 65.34% 411004 - PERF Regular 3,242.26 20,310.98 - 20,310.98 46,907.00 26,596.02 56.70% 411005 - PERF Union 51.24 560.16 - 560.16 1,330.00 769.84 57.88% 411007 - Unemployment Comp 3.03 17.90 - 17.90 124.00 106.10 85.56% 411008 - Health Insurance 7,673.74 42,334.90 - 42,334.90 82,943.00 40,608.10 48.96% 411009 - Life Insurance 70.00 380.00 - 380.00 960.00 580.00 60.42% 411014 - Parental Leave 101.28 617.84 - 617.84 1,458.00 840.16 57.62% 411015 - Other Fringe Benefits - 400.00 - 400.00 400.00 - 0.00% 411201 - Tool Allowance - - - - 400.00 400.00 100.00% 411203 - Job Readiness Allow. - 850.00 - 850.00 850.00 - 0.00% 411206 - Cell Phone Allowance 55.00 275.00 - 275.00 660.00 385.00 58.33% Total Employee Benefits 15,971.31 84,168.50 - 84,168.50 189,181.00 105,012.50 55.51% Total Personnel Expenditures 80,058.01 333,100.87 - 333,100.87 881,630.00 548,529.13 62.22% May 31, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies 53.49 887.03 - 887.03 834.00 (53.03) (6.36%) Total Office Supplies 53.49 887.03 - 887.03 834.00 (53.03) (6.36%) Operating Supplies 422000 - Other Operating Supplies 8,156.56 37,677.67 5,316.77 42,994.44 50,250.00 7,255.56 14.44% 422002 - Diesel/CNG - 1,171.80 1,168.00 2,339.80 6,000.00 3,660.20 61.00% 422003 - Gasoline - 4,946.08 1,156.00 6,102.08 19,503.00 13,400.92 68.71% 422005 - Uniforms 416.22 416.22 186.62 602.84 2,200.00 1,597.16 72.60% 422010 - Plants Chemicals Seed & Fertilizer 4,335.39 57,843.84 12,723.55 70,567.39 87,456.77 16,889.38 19.31% 422014 - Concessions Inventory 3,681.75 17,441.29 2,756.00 20,197.29 80,748.00 60,550.71 74.99% 422016 - Inventory For Sale 518.87 30,857.92 7,888.42 38,746.34 35,000.00 (3,746.34) (10.70%) Total Operating Supplies 17,108.79 150,354.82 31,195.36 181,550.18 281,157.77 99,607.59 35.43% Repair & Maintenance Supplies 423000 - Other R&M Supplies 333.51 11,392.34 2,662.86 14,055.20 31,726.00 17,670.80 55.70% 423001 - Building Materials - 393.64 - 393.64 394.00 0.36 0.09% 423006 - Small Tools & Equipment - 31,175.00 - 31,175.00 31,175.00 - 0.00% 423009 - Repair Parts 20.89 1,249.29 161.24 1,410.53 1,391.23 (19.30) (1.39%) Total Repair & Maintenance Supplies 354.40 44,210.27 2,824.10 47,034.37 64,686.23 17,651.86 27.29% Total Supplies Expenditures 17,516.68 195,452.12 34,019.46 229,471.58 346,678.00 117,206.42 33.81% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 2,014.00 6,639.59 - 6,639.59 8,889.65 2,250.06 25.31% 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 0.00% 431019 - Security Services 477.28 2,521.23 - 2,521.23 3,056.00 534.77 17.50% Total Professional Services 2,491.28 9,175.82 - 9,175.82 11,960.65 2,784.83 23.28% Communication & Transportation 432002 - Mailing - 12.10 - 12.10 - (12.10) 0.00% 432004 - Telecommunications - 80.87 9.13 90.00 400.00 310.00 77.50% Total Communication & Transportation - 92.97 9.13 102.10 400.00 297.90 74.48% Utilties 435001 - Electric 2,264.29 21,358.19 - 21,358.19 52,035.00 30,676.81 58.95% 435002 - Natural Gas 954.76 10,437.17 - 10,437.17 22,519.00 12,081.83 53.65% Total Utilities 3,219.05 31,795.36 - 31,795.36 74,554.00 42,758.64 57.35% Repairs & Maintenance 436000 - Other R&M - - 8,697.00 8,697.00 8,697.00 - 0.00% Total Repairs & Maintenance - - 8,697.00 8,697.00 8,697.00 - 0.00% Debt Service 438100 - Principal 64,442.86 64,847.56 - 64,847.56 65,326.00 478.44 0.73% 438200 - Interest 8,457.69 8,473.65 - 8,473.65 8,480.00 6.35 0.07% Total Debt Service 72,900.55 73,321.21 - 73,321.21 73,806.00 484.79 0.66% Other Charges & Services 439000 - Misc Charges & Svcs 1,358.57 3,455.51 409.43 3,864.94 14,725.43 10,860.49 73.75% 439001 - Other Contractual Services - - 333.80 333.80 333.80 - 0.00% 439002 - Licenses & Permits 148.41 4,436.29 - 4,436.29 4,456.00 19.71 0.44% 439003 - Subscriptions 64.99 324.95 - 324.95 260.00 (64.95) (24.98%) 439004 - Dues & Memberships - 623.04 - 623.04 3,700.00 3,076.96 83.16% 439005 - Bank & Credit Card Fees 2,852.84 8,291.95 - 8,291.95 26,800.00 18,508.05 69.06% 439009 - Trash Removal - 107.58 - 107.58 4,750.00 4,642.42 97.74% 439099 - Cashier Over/Short 29.19 (35.99) - (35.99) - 35.99 0.00% 439100 - Refunds/Awards/Indemnities 452.46 500.44 - 500.44 - (500.44) 0.00% Total Other Services & Charges 4,906.46 17,703.77 743.23 18,447.00 55,025.23 36,578.23 66.48% Total Services & Charges Expenditures 83,517.34 132,089.13 9,449.36 141,538.49 224,442.88 82,904.39 36.94% Other Uses 452002 - Allocations-Admin Cost 6,281.00 31,405.00 - 31,405.00 75,372.00 43,967.00 58.33% 452004 - Allocations-Liability Insurance 859.00 4,294.00 - 4,294.00 10,307.00 6,013.00 58.34% 452009 - Allocations-Facilities Mgmt 218.00 1,089.00 - 1,089.00 1,056.00 (33.00) (3.13%) Total Other Uses 7,358.00 36,788.00 - 36,788.00 86,735.00 49,947.00 57.59% Total Expenditures 188,450.03 697,430.12 43,468.82 740,898.94 1,539,485.88 798,586.94 51.87%