Loading...
HomeMy WebLinkAboutJune 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 6,314.00 226,065.85 93,000.00 (133,065.85) 243.08% 347004 - Golf Green Fees 137,742.45 339,328.36 795,000.00 455,671.64 42.68% 347005 - Golf Cart Rentals 62,020.97 151,625.47 360,000.00 208,374.53 42.12% 347006 - Golf Pro Shop Retail 13,239.26 35,437.15 59,500.00 24,062.85 59.56% 347007 - Golf Driving Range 5,645.00 15,516.97 30,000.00 14,483.03 51.72% 347008 - Golf Gift Certificate 1,636.66 (11,077.08) - 11,077.08 0.00% 347012 - Food Sales 10,569.56 26,745.58 53,277.00 26,531.42 50.20% 347013 - Nonalcoholic Beverage 7,346.36 15,512.93 33,398.00 17,885.07 46.45% 347014 - Alcoholic Beverage Sales 23,495.53 58,910.95 110,000.00 51,089.05 53.56% 347026 - Room Rental 300.00 600.00 - (600.00) 0.00% 347100 - Concessions-Employee Discounts (622.29) (1,376.55) - 1,376.55 0.00% Total Culture & Recreation 267,687.50 857,289.63 1,534,175.00 676,885.37 55.88% Total Charges for Services 267,687.50 857,289.63 1,534,175.00 676,885.37 55.88% Miscellaneous Revenue 360000 - Miscellaneous 436.00 1,779.88 5,000.00 3,220.12 35.60% Total Miscellaneous Revenue 436.00 1,779.88 5,000.00 3,220.12 35.60% Refunds & Reimbursements 380000 - Misc Reimbursements 3,717.00 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 3,717.00 6,980.85 6,440.00 (540.85) 108.40% Total Revenue 271,840.50 866,050.36 1,545,615.00 679,564.64 56.03% 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.52 165,372.42 - 165,372.42 329,507.00 164,134.58 50.19% 410002 - Teamster Wages 3,244.53 38,629.46 - 38,629.46 83,842.00 45,212.54 46.07% 410003 - Permanent Part Time 32,040.24 92,256.22 - 92,256.22 245,500.00 153,243.78 37.58% 410004 - Extra & Overtime 751.52 1,543.50 - 1,543.50 2,550.00 1,006.50 60.53% 410005 - Seasonal & Interns 8,556.96 20,601.54 - 20,601.54 30,450.00 9,848.46 67.66% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 100.00% Total Salaries & Wages 70,070.77 319,003.14 - 319,003.14 692,449.00 373,445.86 46.07% Employee Benefits 411001 - FICA Regular 5,232.48 23,654.20 - 23,654.20 53,149.00 29,494.80 44.51% 411004 - PERF Regular 3,231.54 23,542.52 - 23,542.52 46,907.00 23,364.48 50.19% 411005 - PERF Union 49.81 609.97 - 609.97 1,330.00 720.03 45.86% 411007 - Unemployment Comp 44.83 62.73 - 62.73 124.00 61.27 50.59% 411008 - Health Insurance 7,673.74 50,008.64 - 50,008.64 82,943.00 32,934.36 60.29% 411009 - Life Insurance 70.00 450.00 - 450.00 960.00 510.00 46.88% 411014 - Parental Leave 100.92 718.76 - 718.76 1,458.00 739.24 49.30% 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 330.00 - 330.00 660.00 330.00 50.00% Total Employee Benefits 16,458.32 100,626.82 - 100,626.82 189,181.00 88,554.18 53.19% June 30, 2021 Total Personnel Expenditures 86,529.09 419,629.96 - 419,629.96 881,630.00 462,000.04 47.60% Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 887.03 - 887.03 834.00 (53.03) 106.36% Total Office Supplies - 887.03 - 887.03 834.00 (53.03) 106.36% Operating Supplies 422000 - Other Operating Supplies 11,442.09 49,119.76 8,082.41 57,202.17 60,034.00 2,831.83 95.28% 422002 - Diesel/CNG 4,228.84 5,400.64 - 5,400.64 10,947.00 5,546.36 49.33% 422003 - Gasoline 1,156.00 6,102.08 - 6,102.08 14,556.00 8,453.92 41.92% 422005 - Uniforms - 416.22 186.62 602.84 2,200.00 1,597.16 27.40% 422010 - Plants Chemicals Seed & Fertilizer 2,156.73 60,000.57 13,707.50 73,708.07 87,456.77 13,748.70 84.28% 422014 - Concessions Inventory 18,265.17 35,706.46 5,294.65 41,001.11 73,848.00 32,846.89 55.52% 422016 - Inventory For Sale - 30,857.92 7,888.42 38,746.34 35,000.00 (3,746.34) 110.70% Total Operating Supplies 37,248.83 187,603.65 35,159.60 222,763.25 284,041.77 61,278.52 78.43% Repair & Maintenance Supplies 423000 - Other R&M Supplies 8,801.39 20,193.73 2,862.87 23,056.60 28,842.00 5,785.40 79.94% 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 - 1,249.29 161.24 1,410.53 1,391.23 (19.30) 101.39% Total Repair & Maintenance Supplies 8,801.39 53,011.66 3,024.11 56,035.77 61,802.23 5,766.46 90.67% Total Supplies Expenditures 46,050.22 241,502.34 38,183.71 279,686.05 346,678.00 66,991.95 80.68% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 2,249.96 8,889.55 4,345.00 13,234.55 11,286.65 (1,947.90) 117.26% 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 100.00% 431019 - Security Services - 2,521.23 - 2,521.23 5,056.00 2,534.77 49.87% Total Professional Services 2,249.96 11,425.78 4,345.00 15,770.78 16,357.65 586.87 96.41% Communication & Transportation 432002 - Mailing - 12.10 - 12.10 - (12.10) 0.00% 432004 - Telecommunications - 80.87 9.13 90.00 400.00 310.00 22.50% Total Communication & Transportation - 92.97 9.13 102.10 400.00 297.90 25.53% Printing & Advertising 433003 - Promotional 680.00 680.00 - 680.00 - (680.00) 0.00% Total Printing & Advertising 680.00 680.00 - 680.00 - (680.00) 0.00% Utilties 435001 - Electric 9,728.92 31,087.11 - 31,087.11 47,535.00 16,447.89 65.40% 435002 - Natural Gas 299.30 10,736.47 - 10,736.47 21,519.00 10,782.53 49.89% Total Utilities 10,028.22 41,823.58 - 41,823.58 69,054.00 27,230.42 60.57% Repairs & Maintenance 436000 - Other R&M 8,697.00 8,697.00 26,151.54 34,848.54 15,197.00 (19,651.54) 229.31% Total Repairs & Maintenance 8,697.00 8,697.00 26,151.54 34,848.54 15,197.00 (19,651.54) 229.31% Debt Service 438100 - Principal 82.23 64,929.79 - 64,929.79 65,326.00 396.21 99.39% 438200 - Interest 1.90 8,475.55 - 8,475.55 8,480.00 4.45 99.95% Total Debt Service 84.13 73,405.34 - 73,405.34 73,806.00 400.66 99.46% Other Charges & Services 439000 - Misc Charges & Svcs 1,143.36 4,598.87 384.43 4,983.30 8,828.43 3,845.13 56.45% 439001 - Other Contractual Services 53.66 53.66 333.80 387.46 333.80 (53.66) 116.08% 439002 - Licenses & Permits 130.89 4,567.18 - 4,567.18 4,456.00 (111.18) 102.50% 439003 - Subscriptions - 324.95 - 324.95 260.00 (64.95) 124.98% 439004 - Dues & Memberships - 623.04 - 623.04 3,700.00 3,076.96 16.84% 439005 - Bank & Credit Card Fees 8,683.81 16,975.76 - 16,975.76 26,300.00 9,324.24 64.55% 439009 - Trash Removal - 107.58 877.56 985.14 4,545.00 3,559.86 21.68% 439099 - Cashier Over/Short (142.66) (178.65) - (178.65) - 178.65 0.00% 439100 - Refunds/Awards/Indemnities 238.85 739.29 - 739.29 1,205.00 465.71 61.35% Total Other Services & Charges 10,107.91 27,811.68 1,595.79 29,407.47 49,628.23 20,220.76 59.26% Total Services & Charges Expenditures 31,847.22 163,936.35 32,101.46 196,037.81 224,442.88 28,405.07 87.34% Other Uses 452002 - Allocations-Admin Cost 6,281.00 37,686.00 - 37,686.00 75,372.00 37,686.00 50.00% 452004 - Allocations-Liability Insurance 859.00 5,153.00 - 5,153.00 10,307.00 5,154.00 50.00% 452009 - Allocations-Facilities Mgmt 218.00 1,307.00 - 1,307.00 2,615.00 1,308.00 49.98% Total Other Uses 7,358.00 44,146.00 - 44,146.00 88,294.00 44,148.00 50.00% Total Expenditures 171,784.53 869,214.65 70,285.17 939,499.82 1,541,044.88 601,545.06 60.97%