Loading...
HomeMy WebLinkAbout04 Ice ArenaBudget Comparison Report Object Fund: 250 - ICE ARENA Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4110 - OVERTIME F, T. 4115 - REGULAR-P/T REG STATUS 4120 - SAL-P.T./TEMP 4121- O.T. - P.T./TEMP 4141- PERA 4142 - FICA 4144- HEALTH INSURANCE 4147- UNEMPLOYMENT 4148- WORKERS COMP Total Category: 4100 - PERSONAL SERVICES: Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 4209 - OP SUPPLIES-CLEN 4210 -OP SUPPLY -OTHER 4211- MOTOR FUELS 4212 - LUB/ADD 4217 - CLOTHING/UNIFORM 4231- SMALL TOOLS 4270 - OP SUP-VEH/EQ 4271- OP SUP -OTHER IMP 4272 -OP SUP -BUILDINGS 4280 - CAPITAL OUTLAY <$5,000 Total Category: 4200 - COMMODITIES: Category: 4300 - CONTRACTUAL SERVICES 2,976.92% 6,760.00 -193,240.00 Comparison 1 Comparison 1 4300 - PROF SERVICES Comparison 2 Comparison 2 50.00 6,500.00 200,000.00 4301- ENGINEERING SVS Parent Budget Budget to Parent % Budget to Comparison % 43,024.00 0.00 25,000.00 44,000.00 4305 - FEES FOR SERVICE Budget 26,025.27 15,038.99 1 Budget 20,400.00 2015 2016 2017 2017 2018 Increase / 4310 -COMMUNICATION 2019 Increase / 1,798.71 Total Activity Total Activity YTD Activity 2017 2018 (Decrease) 300.00 2019 fall 2017 (Decrease) 14,874.96 14,874.96 8,677.06 Through Jul 16,330.00 4340 -PRINTING 1,612.22 943.46 1,303.48 400.00 400.00 139,702.58 140,078.99 75,385.80 165,100.00 154,100.00 -11,000.00 -6.66% 157,500.00 3,400.00 2.21% 1,134.00 1,706.03 855.01 1,500.00 1,550.00 50.00 3.33% 1,590.00 40.00 2.58% 12,780.64 9,005.72 4,829.95 16,600.00 17,800.00 1,200.00 7.23% 18,330.00 530.00 2.98% 113,186.23 123,161.87 68,915.71 99,000.00 99,000.00 0.00 0.00% 99,000.00 0.00 0.00% 2,981.70 3,807.52 1,687.91 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 14,686.54 15,472.57 9,156.36 15,400.00 14,640.00 -760.00 -4.94% 14,950.00 310.00 2.12% 19,329.56 19,880.06 11,402.20 21,600.00 20,840.00 -760.00 -3.52% 21,150.00 310.00 1.49% 30,099.96 31,599.96 22,429.19 38,450.00 34,420.00 -4,030.00 -10.48% 33,680.00 -740.00 -2.15% 10,669.36 344.87 25.30 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 5,100.00 6,399.96 3,762.50 6,450.00 6,670.00 220.00 3.41% 6,770.00 100.00 1.50% 349,670.57 351,457.55 198,449.93 364,100.00 349,020.00 -15,080.00 -4.14% 352,970.00 3,950.00 1.13% 656.22 697.93 40.63 600.00 600.00 0.00 0.00% 615.00 15.00 2.50% 2,228.41 2,888.69 950.61 2,500.00 2,550.00 50.00 2.00% 2,600.00 50.00 1.96% 4,023.07 10,163.94 10,474.33 4,000.00 4,080.00 80.00 2.00% 4,160.00 80.00 1.96% 4,636.44 4,257.85 1,796.14 5,000.00 5,100.00 100.00 2.00% 5,200.00 100.00 1.96% 151.84 151.57 12.91 500.00 510.00 10.00 2.00% 520.00 10.00 1.96% 1,421.49 916.25 477.58 1,300.00 1,300.00 0.00 0.00% 1,325.00 25.00 1.92% 66.14 214.77 0.00 300.00 300.00 0.00 0.00% 310.00 10.00 3.33% 6,392.88 6,621.73 2,483.57 12,000.00 12,240.00 240.00 2.00% 12,500.00 260.00 2.12% 0.00 320.88 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4,657.97 7,045.81 2,969.47 5,000.00 5,100.00 100.00 2.00% 5,200.00 100.00 1.96% 9,587.17 0.00 2,884.01 3,200.00 11,000.00 7,800.00 243.75% 11,200.00 200.00 1.82% 33,821.63 33,279.42 22,089.25 34,400.00 42,780.00 8,380.00 24.36% 43,630.00 850.00 1.99% Category: 4300 - CONTRACTUAL SERVICES 2,976.92% 6,760.00 -193,240.00 -96,62% 0.00 4300 - PROF SERVICES 1,745.28 720.00 50.00 6,500.00 200,000.00 4301- ENGINEERING SVS 0.00 0.00 44,849.00 0.00 0.00 4303 - INSTRUCTORS 44,649.00 43,024.00 0.00 25,000.00 44,000.00 4305 - FEES FOR SERVICE 17,091.13 26,025.27 15,038.99 20,000.00 20,400.00 4309 - CREDIT CARD FEES 9,197.65 11,430.10 4,652.50 6,200.00 10,500.00 4310 -COMMUNICATION 3,033.15 3,068.05 1,798.71 3,500.00 3,570.00 4311 -POSTAGE 168.37 16.20 9.40 300.00 300.00 4321- DATA PROCESSING 14,874.96 14,874.96 8,677.06 14,875.00 16,330.00 4340 -PRINTING 1,612.22 943.46 1,303.48 400.00 400.00 4341-ADVER/PUBLISH 5,543.01 620.82 1,238.98 3,000.00 3,000.00 4350- INSURANCE CHARGE 9,999.96 9,999.96 6,416.69 11,000.00 11,000.00 4360 -UTILITIES 150,591.52 157,893.29 61,064.20 160,000.00 163,200.00 193,500.00 2,976.92% 6,760.00 -193,240.00 -96,62% 0.00 0.00% 0.00 0.00 0.00% 19,000.00 76.00% 44,000.00 0.00 0.00% 400.00 2.00% 20,800.00 400.00 1.96% 4,300.00 69.35% 10,500.00 0.00 0.00% 70.00 2.00% 3,600.00 30.00 0.84% 0.00 0.00% 310.00 10.00 3.33% 1,455.00 9.78% 16,330.00 0.00 0.00% 0.00 0.00% 410.00 10.00 2.50% 0.00 0.00% 3,060.00 60.00 2.00% 0.00 0.00% 11,000.00 0.00 0.00% 3,200.00 2.00% 166,500.00 3,300.00 2.02% 7/25/2017 2:37:30 PM Page 4 of 14 Budget Comparison Report Total Fund: 250 - ICE ARENA: 1,353,497.94 1,178,127.15 556,527.33 1,042,250.00 1,259,225.00 216,975.00 20.82% 1,078,060.00 -181,165.00 -14.39% 7/25/2017 2:37:30 PM Page 5 of 14 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % Budget 1 Budget 2015 2016 2017 2017 2018 Increase / 2019 Increase / Total Activity Total Activity YTD Activity 2017 2018 (Decrease) 2019 fall 2017 (Decrease) Object Through Jul 4370 - MAINT-REPAIR/EQ 20,363.00 16,910.52 4,878.88 12,000.00 12,240.00 240.00 2.00% 12,500.00 260.00 2.12% 4371- MAINT-REPAIR/OTH 0.00 1,975.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4372-MAINT-REPAIR/BLD 12,660.57 9,290.18 2,909.40 12,000.00 12,000.00 0.00 0.00% 12,240.00 240.00 2.00% 4375 - CHARGE -FLEET MNT 1,376.16 0.00 74.70 2,100.00 1,100.00 -1,000.00 -47.62% 1,100.00 0.00 0.00% 4380-RENTAL/LEASE 2,364.64 3,686.39 2,684.88 1,600.00 1,600.00 0.00 0.00% 1,630.00 30.00 1.88% 4401- DUES & SUBS 2,644.29 3,111.43 2,357.43 2,700.00 2,700.00 0.00 0.00% 2,750.00 50.00 1.85% 4403-TRAVEL/TRAIN/CON 97.00 628.38 474.00 1,600.00 1,600.00 0.00 0.00% 1,630.00 30.00 1.88% 4405 - CLEAN/WASTE REMV 478.17 374.40 187.67 800.00 800.00 0.00 0.00% 820.00 20.00 2.50% 4434 - SPECIAL EVENTS 567.29 481.96 352.69 500.00 510.00 10.00 2.00% 520.00 10.00 1.96% 4436 - CONCESSION RESAL 1,907.10 1,669.02 752.07 2,000.00 2,000.00 0.00 0.00% 2,040.00 40.00 2.00% 4437 -VENDING RESALE 0.00 0.00 100.30 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4438 - PRO/MISC RESALE 44,116.77 60,179.77 23,451.12 37,500.00 38,000.00 500.00 1.33% 38,760.00 760.00 2.00% 4449 - OTHER CONTRACT 677.00 175.00 35.00 175.00 175.00 0.00 0.00% 200.00 25.00 14.29% Total Category: 4300 - CONTRACTUAL SERVICES: 345,758.24 367,098.16 183,357.15 323,750.00 545,425.00 221,675.00 68.47% 357,460.00 -187,965.00 -34.46% Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 40,955.00 16,964.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4540 - OTHER CAP OUTLAY 80,000.00 10,481.77 24,300.00 100,000.00 102,000.00 2,000.00 2.00% 104,000.00 2,000.00 1.96% Total Category: 4500 - CAPITAL OUTLAY: 120,955.00 27,445.77 24,300.00 100,000.00 102,000.00 2,000.00 2.00% 104,000.00 2,000.00 1.96% Category: 4600 - OTHER FINANCING USES 4600 -PRINCIPAL 280,000.00 290,000.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4610 -INTEREST 223,292,50 108,846.25 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4600 - OTHER FINANCING USES: 503,292.50 398,846.25 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4999 - TRANSFERS OUT 4700 -TRANSFERS OUT 0.00 0.00 128,331.00 220,000.00 220,000.00 0.00 0.00% 220,000.00 0.00 0.00% Total Category: 4999 -TRANSFERS OUT: 0.00 0.00 128,331.00 220,000.00 220,000.00 0.00 0.00% 220,000.00 0.00 0.00% Total Fund: 250 - ICE ARENA: 1,353,497.94 1,178,127.15 556,527.33 1,042,250.00 1,259,225.00 216,975.00 20.82% 1,078,060.00 -181,165.00 -14.39% 7/25/2017 2:37:30 PM Page 5 of 14