Loading...
HomeMy WebLinkAboutJuly 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 (8,963.08) 217,102.77 93,000.00 (124,102.77) 233.44% 347004 - Golf Green Fees 124,275.88 463,604.24 795,000.00 331,395.76 58.31% 347005 - Golf Cart Rentals 66,811.35 218,436.82 360,000.00 141,563.18 60.68% 347006 - Golf Pro Shop Retail 12,946.19 48,383.34 59,500.00 11,116.66 81.32% 347007 - Golf Driving Range 5,473.00 20,989.97 30,000.00 9,010.03 69.97% 347008 - Golf Gift Certificate 11,082.08 5.00 - (5.00) 0.00% 347012 - Food Sales 11,179.12 37,924.70 53,277.00 15,352.30 71.18% 347013 - Nonalcoholic Beverage 7,687.65 23,200.58 33,398.00 10,197.42 69.47% 347014 - Alcoholic Beverage Sales 23,876.40 82,787.35 110,000.00 27,212.65 75.26% 347026 - Room Rental 200.00 800.00 - (800.00) 0.00% 347100 - Concessions-Employee Discounts (677.68) (2,054.23) - 2,054.23 0.00% Total Culture & Recreation 253,890.91 1,111,180.54 1,534,175.00 422,994.46 72.43% Total Charges for Services 253,890.91 1,111,180.54 1,534,175.00 422,994.46 72.43% Miscellaneous Revenue 360000 - Miscellaneous 327.53 2,107.41 5,000.00 2,892.59 42.15% Total Miscellaneous Revenue 327.53 2,107.41 5,000.00 2,892.59 42.15% 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 254,218.44 1,120,268.80 1,545,615.00 425,346.20 72.48% 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.47 190,849.89 - 190,849.89 329,507.00 138,657.11 57.92% 410002 - Teamster Wages 6,351.52 44,980.98 - 44,980.98 83,842.00 38,861.02 53.65% 410003 - Permanent Part Time 29,604.42 121,860.64 - 121,860.64 245,500.00 123,639.36 49.64% 410004 - Extra & Overtime 765.95 2,309.45 - 2,309.45 2,550.00 240.55 90.57% 410005 - Seasonal & Interns 9,075.71 29,677.25 - 29,677.25 30,450.00 772.75 97.46% 410007 - Longevity Pay - 600.00 - 600.00 600.00 - 100.00% Total Salaries & Wages 71,275.07 390,278.21 - 390,278.21 692,449.00 302,170.79 56.36% Employee Benefits 411001 - FICA Regular 5,329.61 28,983.81 - 28,983.81 53,149.00 24,165.19 54.53% 411004 - PERF Regular 3,233.76 26,776.28 - 26,776.28 46,907.00 20,130.72 57.08% 411005 - PERF Union 50.10 660.07 - 660.07 1,330.00 669.93 49.63% 411007 - Unemployment Comp 10.23 72.96 - 72.96 124.00 51.04 58.84% 411008 - Health Insurance 7,739.84 57,748.48 - 57,748.48 82,943.00 25,194.52 69.62% 411009 - Life Insurance 75.00 525.00 - 525.00 960.00 435.00 54.69% 411014 - Parental Leave 113.38 832.14 - 832.14 1,458.00 625.86 57.07% 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 385.00 - 385.00 660.00 275.00 58.33% Total Employee Benefits 16,606.92 117,233.74 - 117,233.74 189,181.00 71,947.26 61.97% July 31, 2021 Total Personnel Expenditures 87,881.99 507,511.95 - 507,511.95 881,630.00 374,118.05 57.57% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 154.62 1,041.65 - 1,041.65 834.00 (207.65) 124.90% Total Office Supplies 154.62 1,041.65 - 1,041.65 834.00 (207.65) 124.90% Operating Supplies 422000 - Other Operating Supplies 12,639.89 61,759.65 1,915.47 63,675.12 65,034.00 1,358.88 97.91% 422002 - Diesel/CNG 1,315.80 6,716.44 - 6,716.44 10,947.00 4,230.56 61.35% 422003 - Gasoline - 6,102.08 - 6,102.08 14,556.00 8,453.92 41.92% 422005 - Uniforms 414.12 830.34 142.50 972.84 2,900.00 1,927.16 33.55% 422010 - Plants Chemicals Seed & Fertilizer 12,017.53 72,018.10 3,380.93 75,399.03 83,956.77 8,557.74 89.81% 422014 - Concessions Inventory 7,407.73 43,114.19 8,304.54 51,418.73 62,148.00 10,729.27 82.74% 422016 - Inventory For Sale 2,616.39 33,474.31 7,442.08 40,916.39 44,500.00 3,583.61 91.95% Total Operating Supplies 36,411.46 224,015.11 21,185.52 245,200.63 284,041.77 38,841.14 86.33% Repair & Maintenance Supplies 423000 - Other R&M Supplies 1,515.75 21,709.48 3,504.77 25,214.25 28,842.00 3,627.75 87.42% 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 1,515.75 54,527.41 3,666.01 58,193.42 61,802.23 3,608.81 94.16% Total Supplies Expenditures 38,081.83 279,584.17 24,851.53 304,435.70 346,678.00 42,242.30 87.82% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,318.25 10,207.80 4,510.00 14,717.80 16,286.65 1,568.85 90.37% 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 100.00% 431019 - Security Services 270.43 2,791.66 - 2,791.66 5,056.00 2,264.34 55.21% Total Professional Services 1,588.68 13,014.46 4,510.00 17,524.46 21,357.65 3,833.19 82.05% 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) 0.00% Total Printing & Advertising - 680.00 - 680.00 - (680.00) 0.00% Utilties 435001 - Electric 7,294.85 38,381.96 - 38,381.96 44,535.00 6,153.04 86.18% 435002 - Natural Gas 493.36 11,229.83 - 11,229.83 18,519.00 7,289.17 60.64% Total Utilities 7,788.21 49,611.79 - 49,611.79 63,054.00 13,442.21 78.68% Repairs & Maintenance 436000 - Other R&M - 8,697.00 26,151.54 34,848.54 15,197.00 (19,651.54) 229.31% Total Repairs & Maintenance - 8,697.00 26,151.54 34,848.54 15,197.00 (19,651.54) 229.31% Debt Service 438100 - Principal 82.56 65,012.35 - 65,012.35 65,326.00 313.65 99.52% 438200 - Interest 1.57 8,477.12 - 8,477.12 8,480.00 2.88 99.97% Total Debt Service 84.13 73,489.47 - 73,489.47 73,806.00 316.53 99.57% Other Charges & Services 439000 - Misc Charges & Svcs 88.69 4,687.56 488.43 5,175.99 8,128.43 2,952.44 63.68% 439001 - Other Contractual Services - 53.66 333.80 387.46 333.80 (53.66) 116.08% 439002 - Licenses & Permits 148.41 4,715.59 - 4,715.59 4,456.00 (259.59) 105.83% 439003 - Subscriptions 129.98 454.93 - 454.93 260.00 (194.93) 174.97% 439004 - Dues & Memberships - 623.04 - 623.04 3,700.00 3,076.96 16.84% 439005 - Bank & Credit Card Fees 6,522.03 23,497.79 - 23,497.79 28,000.00 4,502.21 83.92% 439009 - Trash Removal 1,989.25 2,096.83 232.11 2,328.94 4,545.00 2,216.06 51.24% 439099 - Cashier Over/Short (67.24) (245.89) - (245.89) - 245.89 0.00% 439100 - Refunds/Awards/Indemnities 141.82 881.11 - 881.11 1,205.00 323.89 73.12% Total Other Services & Charges 8,952.94 36,764.62 1,054.34 37,818.96 50,628.23 12,809.27 74.70% Total Services & Charges Expenditures 18,413.96 182,350.31 31,725.01 214,075.32 224,442.88 10,367.56 95.38% Other Uses 452002 - Allocations-Admin Cost 6,281.00 43,967.00 - 43,967.00 75,372.00 31,405.00 58.33% 452004 - Allocations-Liability Insurance 859.00 6,012.00 - 6,012.00 10,307.00 4,295.00 58.33% 452009 - Allocations-Facilities Mgmt 218.00 1,525.00 - 1,525.00 2,615.00 1,090.00 58.32% Total Other Uses 7,358.00 51,504.00 - 51,504.00 88,294.00 36,790.00 58.33% Total Expenditures 151,735.78 1,020,950.43 56,576.54 1,077,526.97 1,541,044.88 463,517.91 69.92%