Loading...
HomeMy WebLinkAboutMar 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 39,145.10 185,158.85 175,000.00 (10,158.85) (5.81%) 347004 - Golf Green Fees 28,308.00 28,308.00 684,000.00 655,692.00 95.86% 347005 - Golf Cart Rentals 11,673.54 11,673.54 350,000.00 338,326.46 96.66% 347006 - Golf Pro Shop Retail 3,613.35 3,660.34 60,000.00 56,339.66 93.90% 347007 - Golf Driving Range 1,711.00 1,711.00 25,000.00 23,289.00 93.16% 347008 - Golf Gift Certificate 280.83 (10,893.89) - 10,893.89 0.00% 347012 - Food Sales 1,682.10 1,682.10 65,000.00 63,317.90 97.41% 347013 - Nonalcoholic Beverage 736.94 736.94 48,000.00 47,263.06 98.46% 347014 - Alcoholic Beverage Sales 3,348.85 3,362.86 100,000.00 96,637.14 96.64% 347026 - Room Rental 100.00 100.00 - (100.00) 0.00% 347100 - Concessions-Employee Discounts (31.35) (31.35) - 31.35 0.00% Total Culture & Recreation 90,568.36 225,468.39 1,507,000.00 1,281,531.61 85.04% Total Charges for Services 90,568.36 225,468.39 1,507,000.00 1,281,531.61 85.04% Miscellaneous Revenue 360000 - Miscellaneous 898.31 903.24 5,000.00 4,096.76 81.94% Total Miscellaneous Revenue 898.31 903.24 5,000.00 4,096.76 81.94% 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 91,466.67 229,635.48 1,512,000.00 1,282,364.52 84.81% 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,246.40 76,201.26 - 76,201.26 329,507.00 253,305.74 76.87% 410002 - Teamster Wages 6,485.45 19,451.86 - 19,451.86 83,842.00 64,390.14 76.80% 410003 - Permanent Part Time 2,050.25 3,233.08 - 3,233.08 245,500.00 242,266.92 98.68% 410004 - Extra & Overtime 15.20 288.72 - 288.72 2,550.00 2,261.28 88.68% 410005 - Seasonal & Interns 1,138.27 2,607.21 - 2,607.21 30,450.00 27,842.79 91.44% 410007 - Longevity Pay 350.00 350.00 - 350.00 600.00 250.00 41.67% Total Salaries & Wages 35,285.57 102,132.13 - 102,132.13 692,449.00 590,316.87 85.25% Employee Benefits 411001 - FICA Regular 2,552.97 7,447.32 - 7,447.32 53,149.00 45,701.68 85.99% 411004 - PERF Regular 3,601.04 11,743.62 - 11,743.62 46,907.00 35,163.38 74.96% 411005 - PERF Union 102.76 314.11 - 314.11 1,330.00 1,015.89 76.38% 411007 - Unemployment Comp 3.22 9.64 - 9.64 124.00 114.36 92.23% 411008 - Health Insurance 8,808.94 26,419.82 - 26,419.82 82,943.00 56,523.18 68.15% 411009 - Life Insurance 80.00 240.00 - 240.00 960.00 720.00 75.00% 411014 - Parental Leave 112.36 337.06 - 337.06 1,458.00 1,120.94 76.88% 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 165.00 - 165.00 660.00 495.00 75.00% Total Employee Benefits 15,316.29 47,926.57 - 47,926.57 189,181.00 141,254.43 74.67% Total Personnel Expenditures 50,601.86 150,058.70 - 150,058.70 881,630.00 731,571.30 82.98% March 31, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies 13.29 833.54 - 833.54 834.00 0.46 0.06% Total Office Supplies 13.29 833.54 - 833.54 834.00 0.46 0.06% Operating Supplies 422000 - Other Operating Supplies 14,655.96 21,404.08 2,877.35 24,281.43 37,551.00 13,269.57 35.34% 422002 - Diesel/CNG - - 1,171.80 1,171.80 - (1,171.80) 0.00% 422003 - Gasoline 3,038.33 3,601.08 1,345.00 4,946.08 23,503.00 18,556.92 78.96% 422005 - Uniforms - - 523.50 523.50 2,200.00 1,676.50 76.20% 422010 - Plants Chemicals Seed & Fertilizer 49,591.50 49,591.50 2,451.57 52,043.07 90,056.77 38,013.70 42.21% 422014 - Concessions Inventory 365.78 365.78 7,356.11 7,721.89 85,500.00 77,778.11 90.97% 422016 - Inventory For Sale 29,158.43 29,158.43 8,864.49 38,022.92 35,000.00 (3,022.92) (8.64%) Total Operating Supplies 96,810.00 104,120.87 24,589.82 128,710.69 273,810.77 145,100.08 52.99% Repair & Maintenance Supplies 423000 - Other R&M Supplies 3,835.78 9,738.94 1,080.70 10,819.64 39,073.00 28,253.36 72.31% 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 153.42 1,228.40 161.24 1,389.64 1,391.23 1.59 0.11% Total Repair & Maintenance Supplies 3,989.20 42,535.98 1,241.94 43,777.92 72,033.23 28,255.31 39.23% Total Supplies Expenditures 100,812.49 147,490.39 25,831.76 173,322.15 346,678.00 173,355.85 50.00% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,851.65 2,981.65 - 2,981.65 2,607.65 (374.00) (14.34%) 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 0.00% 431019 - Security Services 305.53 1,776.67 - 1,776.67 1,656.00 (120.67) (7.29%) Total Professional Services 2,157.18 4,773.32 - 4,773.32 4,278.65 (494.67) (11.56%) Communication & Transportation 432004 - Telecommunications - 80.87 9.13 90.00 400.00 310.00 77.50% Total Communication & Transportation - 80.87 9.13 90.00 400.00 310.00 77.50% Utilties 435001 - Electric 6,256.78 14,727.68 - 14,727.68 52,667.00 37,939.32 72.04% 435002 - Natural Gas 2,903.98 7,268.52 - 7,268.52 22,519.00 15,250.48 67.72% Total Utilities 9,160.76 21,996.20 - 21,996.20 75,186.00 53,189.80 70.74% Debt Service 438100 - Principal 81.26 323.12 - 323.12 65,326.00 65,002.88 99.51% 438200 - Interest 2.87 13.41 - 13.41 8,480.00 8,466.59 99.84% Total Debt Service 84.13 336.53 - 336.53 73,806.00 73,469.47 99.54% Other Charges & Services 439000 - Misc Charges & Svcs 1,608.55 1,876.13 384.43 2,260.56 29,217.43 26,956.87 92.26% 439001 - Other Contractual Services - - 333.80 333.80 333.80 - 0.00% 439002 - Licenses & Permits 370.96 2,603.51 - 2,603.51 2,456.00 (147.51) (6.01%) 439003 - Subscriptions 64.99 194.97 - 194.97 65.00 (129.97) (199.95%) 439004 - Dues & Memberships 623.04 623.04 - 623.04 3,700.00 3,076.96 83.16% 439005 - Bank & Credit Card Fees 410.13 3,538.83 - 3,538.83 29,800.00 26,261.17 88.12% 439009 - Trash Removal - 107.58 - 107.58 5,200.00 5,092.42 97.93% 439099 - Cashier Over/Short (19.25) (19.15) - (19.15) - 19.15 0.00% Total Other Services & Charges 3,058.42 8,924.91 718.23 9,643.14 70,772.23 61,129.09 86.37% Total Services & Charges Expenditures 14,460.49 36,111.83 727.36 36,839.19 224,442.88 187,603.69 83.59% Other Uses 452002 - Allocations-Admin Cost 6,281.00 18,843.00 - 18,843.00 75,372.00 56,529.00 75.00% 452004 - Allocations-Liability Insurance 859.00 2,576.00 - 2,576.00 10,307.00 7,731.00 75.01% 452009 - Allocations-Facilities Mgmt 218.00 653.00 - 653.00 1,056.00 403.00 38.16% Total Other Uses 7,358.00 22,072.00 - 22,072.00 86,735.00 64,663.00 74.55% Total Expenditures 173,232.84 355,732.92 26,559.12 382,292.04 1,539,485.88 1,157,193.84 75.17%