Loading...
HomeMy WebLinkAbout04272015 City Council Laydowns Hiil 16 40000A Travelift Rates 2015 ONE WAY LIFT CITY RATE TOTAL SEWARD TOTAL DIFFERENCE Kodiak 55FT $69.00ft $1897.50 $454.75 TAX INC + $1442.75 * Kodiak 81ft $78.00ft $3159.00 $1006.00 + $2153.00 * Cordova 55ft $24.00ft $660.00 $454.75 +$205.25 Cordova 80ft $26.00ft $1040.00 $1006.00 +$34.00 Sand Point 55ft $18.00ft $990.00 $454.75 +535.25 Sand Point 80ft $18.00ft $1440.00 $1006.00 +$434.00 Wrangell 55ft $12.00ft $330.00 $454.75 -$124.75 Wrangell 80ft $15.00ft $600.00 $1006.00 -$406.00 Hoonah 55ft $12.00ft $660.00 $454.75 +$205.25 Hoonah 80ft $12.00ft $960.00 $1006.00 +All the City's listed are higher than Seward's rates. -Are City's lower than Seward. * Kodiak the way they have it structured is 75%of above Total Rate for a basic I hour lift The $69.00 and $79.00 Rate is lift, block and launch, so the total figure you see for Kodiak is the 75% rate Hoonah's rate r • Zy[ / O/0 AI q/z 7/iv Monthly Budget-to-Actual Revenue Report -- By FUND Run: 4/25/2015 at 11:39 PM City of Seward Page: / General Fund For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D Over/(Under) Annual Over/(Under) % of Annual Month Actual Budget Budget Budget Budget Budget Revenues 4000 Tax Revenue - Sales 63,388.67 63,388.67 730,251.16 (666,862.49) 4,381,506.96 (4,318,118.29) 1.45 4010 Tax Revenue - Real Property 6,826.59 6,826.59 120,000.00 (113,173.41) 720,000.00 (713,173.41) 0.95 4011 Tax Revenue - Personal Property 3,151.15 3,151.15 48,333.34 (45,182.19) 290,000.04 (286,848.89) 1.09 4012 Tax Revenue - Motor vehicle 1,503.38 1,503.38 4,666.66 (3,163.28) 27,999.96 (26,496.58) 5.37 4020 Hotel/Motel Room Tax 3,571.00 1,138.97 64,808.34 (63,669.37) 388,850.04 (387,711.07) 0.29 4030 Payments in Lieu of Tax 0.00 0.00 12,333.34 (12,333.34) 74,000.04 (74,000.04) 0.00 4040 Penalties and Interest on Taxes 234.20 234.20 266.66 (32.46) 1,599.96 (1,365.76) 14.64 4100 Building Permits 136.01 3,069.26 8,333.34 (5,264.08) 50,000.04 (46,930.78) 6.14 4101 Permits - Taxi 201.92 216.92 166.66 50.26 999.96 (783.04) 21.69 4102 DMV - Drivers License 1,090.00 2,560.00 4,000.00 (1,440.00) 24,000.00 (21,440.00) 10.67 4103 DMV - Motor Vehicles 2,631.90 6,146.10 10,833.34 (4,687.24) 65,000.04 (58,853.94) 9.46 4104 Animal Control Licenses 25.00 55.00 58.34 (3.34) 350.04 (295.04) 15.71 4105 Business License 1,080.00 3,990.00 3,500.00 490.00 21,000.00 (17,010.00) 19.00 4106 License and Permits - Misc 15.00 15.00 333.34 (318.34) 2,000.04 (1,985.04) 0.75 4200 Revenue Sharing 0.00 0.00 41,666.66 (41,666.66) 249,999.96 (249,999.96) 0.00 4202 Jail Contract 0.00 167,705.25 124,245.00 43,460.25 670,821.00 (503,115.75) 25.00 4203 Dispatch Contract w/State of AK 0.00 0.00 8,083.34 (8,083.34) 48,500.04 (48,500.04) 0.00 4204 KPB 911 Dispatch 0.00 25,680.00 8,440.00 17,240.00 50,640.00 (24,960.00) 50.71 4205 Alaska Liquor Tax 18,150.00 18,150.00 3,666.66 14,483.34 21,999.96 (3,849.96) 82.50 4206 Alaska Raw Fish Tax 0.00 0.00 86,666.66 (86,666.66) 519,999.96 (519,999.96) 0.00 4300 Admin. Exp. - Jail 7,503.08 15,006.20 15,006.16 0.04 90,036.96 (75,030.76) 16.67 4301 Admin Exp.- Harbor 27,745.67 55,491.30 55,491.34 (0.04) 332,948.04 (277,456.74) 16.67 4302 Admin. Exp. - SMIC 7,368.42 14,736.80 14,811.50 (74.70) 88,869.00 (74,132.20) 16.58 4303 Admin. Exp.- Parking Fund 865.92 1,731.80 1,659.84 71.96 9,959.04 (8,227.24) 17.39 4304 Admin. Exp. - Electric 72,379.83 144,759.70 144,759.66 0.04 868,557.96 (723,798.26) 16.67 4305 Admin. Exp. - Water 19,967.58 39,935.20 39,935.16 0.04 239,610.96 (199,675.76) 16.67 4306 Admin. Exp. - Sewer 12,194.00 24,388.00 24,388.00 0.00 146,328.00 (121,940.00) 16.67 4307 Copying Fees 0.00 11.68 1,500.00 (1,488.32) 9,000.00 (8,988.32) 0.13 4308 Sales Tax Credit for Prompt Remittance 0.00 0.00 666.66 (666.66) 3,999.96 (3,999.96) 0.00 4309 Zoning Fees 46.73 93.46 41.66 51.80 249.96 (156.50) 37.39 4320 Misc Dog Fees 120.00 170.00 366.66 (196.66) 2,199.96 (2,029.96) 7.73 4321 Miscellaneous Jail Revenue 0.00 0.00 250.00 (250.00) 1,500.00 (1,500.00) 0.00 4322 Miscellaneous Dispatching 833.33 1,666.70 1,666.66 0.04 9,999.96 (8,333.26) 16.67 4323 Miscellaneous Police Fees 160.00 300.00 0.00 300.00 0.00 300.00 0.00 4331 Shop Work Orders 0.00 0.00 466.66 (466.66) 2,799.96 (2,799.96) 0.00 4340 P&R: Public Use Fees 16.82 36.45 583.34 (546.89) 3,500.04 (3,463.59) 1.04 4341 P&R: Punchard Fees 477.57 1,162.61 3,333.34 (2,170.73) 20,000.04 (18,837.43) 5.81 4342 P&R: Class Registrations 805.00 6,890.00 10,666.66 (3,776.66) 63,999.96 (57,109.96) 10.77 4343 P&R: Facility Rental 422.44 845.82 108.34 737.48 650.04 195.78 130.12 4344 P&R: Tournaments 0.00 0.00 1,666.66 (1,666.66) 9,999.96 (9,999.96) 0.00 4345 P&R: Special Events 5.00 565.00 3,333.34 (2,768.34) 20,000.04 (19,435.04) 2.82 4347 P&R: Shower Fees 0.00 0.00 1,833.34 (1,833.34) 11,000.04 (11,000.04) 0.00 4348 P&R: Rock Wall Fees 54.21 54.21 200.00 (145.79) 1,200.00 (1,145.79) 4.52 4349 P&R: Pavilion Fees 186.92 560.76 666.66 (105.90) 3,999.96 (3,439.20) 14.02 4350 P&R: Camping Fees 18.69 37.38 45,000.00 (44,962.62) 270,000.00 (269,962.62) 0.01 4351 P&R: Camping w/Utilities 0.00 0.00 36,666.66 (36,666.66) 219,999.96 (219,999.96) 0.00 4352 P&R: RV Dump Station 0.00 0.00 833.34 (833.34) 5,000.04 (5,000.04) 0.00 4353 P&R: Misc Revenue 0.00 343.93 200.00 143.93 1,200.00 (856.07) 28.66 f Monthly Budget-to-Actual Revenue Report -- By FUND Run: 4/25/2015 at 11:39 PM City of Seward Page: General Fund For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D Over/(Under) Annual Over/(Under) % of Annual Month Actual Budget Budget Budget Budget Budget 4354 P&R: Work Orders 1,992.05 1,992.05 0.00 1,992.05 0.00 1,992.05 0.00 4370 Library Service Revenue 922.40 1,485.30 2,166.66 (681.36) 12,999.96 (11,514.66) 11.43 4371 Library Circulation Revenue 362.20 759.65 1,250.00 (490.35) 7,500.00 (6,740.35) 10.13 4372 Museum Revenue 0.00 0.00 2,000.00 (2,000.00) 12,000.00 (12,000.00) 0.00 4380 General Fund Land Rents & Leases 500.00 5,675.00 9,166.66 (3,491.66) 54,999.96 (49,324.96) 10.32 4382 Jail Facility Rental 2,500.00 5,000.00 5,000.00 0.00 30,000.00 (25,000.00) 16.67 4383 Municipal Building Rent 0.00 0.00 10,833.34 (10,833.34) 65,000.04 (65,000.04) 0.00 4400 Fines and Bails 0.00 993.60 1,666.66 (673.06) 9,999.96 (9,006.36) 9.94 4500 GF Interest on Investments 40.95 94.31 8,333.34 (8,239.03) 50,000.04 (49,905.73) 0.19 4501 GF Penalties & Interest 53.31 53.31 500.00 (446.69) 3,000.00 (2,946.69) 1.78 4610 Surplus Sales 0.00 0.00 333.34 (333.34) 2,000.04 (2,000.04) 0.00 4620 Franchise Fee - Refuse 0.00 0.00 2,500.00 (2,500.00) 15,000.00 (15,000.00) 0.00 4630 City Clerk Fees 3.00 18.00 33.34 (15.34) 200.04 (182.04) 9.00 4633 Vending Machine Fees 0.00 0.00 416.66 (416.66) 2,499.96 (2,499.96) 0.00 4639 Misc Service Fees 0.00 (1.03) 500.00 (501.03) 3,000.00 (3,001.03) (0.03 5899 Miscellaneous Revenue 2.50 13,310.63 0.00 13,310.63 0.00 13,310.63 0.00 Total Revenues $ 259,552.44 641,998.34 1,731,454.48 (1,089,456.13T) 10,314,077.;x1 (9,672,079.5$') 6.22 Monthly Budget-to-Actual Revenue Report -- By FUND Run: 4/25/2015 at 11:39 PM City of Seward Pae: Harbor Enterprise Fund 9 For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D Over/(Under) Annual Over/(Under) % of Annual Month Actual Budget Budget Budget Budget Budget Revenues 5000 Land Rents & Leases 0.00 107,887.72 20,833.34 87,054.38 125,000.04 (17,112.32) 86.31 5001 Land Lease Credits 0.00 0.00 (10,771.32) 10,771.32 (64,627.92) 64,627.92 0.00 5100 Transient Moorage 12,811.77 23,883.36 95,725.00 (71,841.64) 574,350.00 (550,466.64) 4.16 5101 Moorage 80,713.62 184,690.59 177,166.66 7,523.93 1,062,999.96 (878,309.37) 17.37 5102 Wharfage 494.46 494.46 8,000.00 (7,505.54) 48,000.00 (47,505.54) 1.03 5103 Boat Lift Fees 874.13 1,582.88 18,666.66 (17,083.78) 111,999.96 (110,417.08) 1.41 5105 Harbor Power Sales 34,434.76 64,943.56 66,666.66 (1,723.10) 399,999.96 (335,056.40) 16.24 5150 Shower Fees 443.92 771.03 2,000.00 (1,228.97) 12,000.00 (11,228.97) 6.43 5153 Fuel Pumping Fee 0.00 785.56 3,416.68 (2,631.12) 20,500.08 (19,714.52) 3.83 5154 Waiting List Fees 283.50 378.00 1,166.66 (788.66) 6,999.96 (6,621.96) 5.40 5155 Towing Fees 0.00 0.00 333.34 (333.34) 2,000.04 (2,000.04) 0.00 5156 Pumping Boats 0.00 0.00 41.66 (41.66) 249.96 (249.96) 0.00 5157 North Harbor Launch Fee 0.00 0.00 5,833.34 (5,833.34) 35,000.04 (35,000.04) 0.00 5158 South Harbor Launch Fee 0.00 0.00 2,500.00 (2,500.00) 15,000.00 (15,000.00) 0.00 5800 Labor& Services 210.00 210.00 1,916.66 (1,706.66) 11,499.96 (11,289.96) 1.83 5890 Collection of Doubtful Accounts 0.00 152.62 166.66 (14.04) 999.96 (847.34) 15.26 5899 Miscellaneous Revenue 140.00 153.12 333.34 (180.22) 2,000.04 (1,846.92) 7.66 5901 EF Investment Interest 0.00 0.00 2,500.00 (2,500.00) 15,000.00 (15,000.00) 0.00 5905 EF Penalties and Interest 754.72 1,549.24 833.34 715.90 5,000.04 (3,450.80) 30.98 5940 Amortization of Contributions-in-Aid 70,974.86 141,949.73 206,247.32 (64,297.59) 1,237,483.92 (1,095,534.19) 11.47 5941 Amortization of Bond Premiums 0.00 0.00 1,395.84 (1,395.84) 8,375.04 (8,375.04) 0.00 Total Revenues $ 202,135.7'$ 529,431.8$ 604,971.84 (75,539.9$) 3,629,831.0$ (3,100,399.1$) 14.59 Monthly Budget-to-Actual Revenue Report -- By FUND Run: 4/25/2015 at 11:39 PM City of Seward Pae: SM IC Enterprise Fund 9 For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D Over/(Under) Annual Over/(Under) % of Annual Month Actual Budget Budget Budget Budget Budget Revenues 5000 Land Rents & Leases 0.00 39,647.06 18,833.32 20,813.74 112,999.92 (73,352.86) 35.09 5101 Moorage 0.00 0.00 500.00 (500.00) 3,000.00 (3,000.00) 0.00 5102 Wharfage 3,727.08 3,727.08 708.34 3,018.74 4,250.04 (522.96) 87.70 5103 Boat Lift Fees 6,590.62 9,698.12 16,666.66 (6,968.54) 99,999.96 (90,301.84) 9.70 5104 Storage Fees 9,477.00 20,204.60 18,333.34 1,871.26 110,000.04 (89,795.44) 18.37 5106 SMIC Power Sales 4,726.00 7,454.75 6,000.00 1,454.75 36,000.00 (28,545.25) 20.71 5109 Washdown Pad Fees 0.00 0.00 0.00 0.00 5,000.00 (5,000.00) 0.00 5153 Fuel Pumping Fee 0.00 521.10 500.00 21.10 3,000.00 (2,478.90) 17.37 5800 Labor & Services 0.00 0.00 166.66 (166.66) 999.96 (999.96) 0.00 5940 Amortization of Contributions-in-Aid 40,21 0.77 80,421.51 175,508.02 (95,086.51) 1,053,048.12 (972,626.61) 7.64 Total Revenues $ 64,731.44 161,674.24 237,216.34 (75,542.14) 1,428,298.0$ (1,266,623.832) 11.32 Monthly Budget-to-Actual Revenue Report -- By FUND Run: 4/25/2015 at 11:39 PM City of Seward Page: Electric Enterprise Fund For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D Over/(Under) Annual Over/(Under) % of Annual Month Actual Budget Budget Budget Budget Budget Revenues 5300 Residential 175,653.89 357,021.81 326,358.50 30,663.31 1,958,151.00 (1,601,129.19) 18.23 5302 Residential fuel factor 77,420.81 161,305.15 145,540.84 15,764.31 873,245.04 (711,939.89) 18.47 5303 Residential customer charge 39,347.37 77,774.49 83,027.50 (5,253.01) 498,165.00 (420,390.51) 15.61 5310 SG Service 100,454.92 184,618.96 198,500.84 (13,881.88) 1,191,005.04 (1,006,386.08) 15.50 5312 SG fuel factor 38,388.73 72,129.88 76,703.84 (4,573.96) 460,223.04 (388,093.16) 15.67 5313 SG Customer Charge 17,221.12 33,941.95 40,394.34 (6,452.39) 242,366.04 (208,424.09) 14.00 5320 LG Service 159,597.88 304,386.68 338,341.50 (33,954.82) 2,030,049.00 (1,725,662.32) 14.99 5322 LG fuel factor 108,514.35 208,596.12 210,463.34 (1,867.22) 1,262,780.04 (1,054,183.92) 16.52 5323 LG customer charge 3,461.60 6,834.11 7,641.84 (807.73) 45,851.04 (39,016.93) 14.91 5324 LG demand charge 103,544.96 200,689.78 249,571.00 (48,881.22) 1,497,426.00 (1,296,736.22) 13.40 5325 Electric KVAR rate 0.00 0.00 833.34 (833.34) 5,000.04 (5,000.04) 0.00 5326 Alternate Energy (0.22) (23.07) (608.50) 585.43 (3,651.00) 3,627.93 0.63 5340 Spec. Contract Energy 12,470.23 20,150.10 18,056.50 2,093.60 108,339.00 (88,188.90) 18.60 5342 Special Contract fuel factor 44,507.84 73,271.92 82,695.50 (9,423.58) 496,1 73.00 (422,901.08) 14.77 5343 Spec. Contract customer charge 80.44 158.84 161.00 (2.16) 966.00 (807.16) 16.44 5345 Special Contract Demand 27,802.32 53,700.77 54,349.16 (648.39) 326,094.96 (272,394.19) 16.47 5350 Harbor Fund Power Sales 27,196.62 45,375.88 36,036.84 9,339.04 216,221.04 (170,845.16) 20.99 5352 Harbor power fuel factor 10,070.50 17,028.46 14,956.16 2,072.30 89,736.96 (72,708.50) 18.98 5360 Street & Yard 6,655.19 12,858.69 11,666.66 1,192.03 69,999.96 (57,141.27) 18.37 5362 Yard Light Fuel 739.30 1,362.32 0.00 1,362.32 0.00 1,362.32 0.00 5801 Turn on Fees 424.65 1,123.94 2,500.00 (1,376.06) 15,000.00 (13,876.06) 7.49 5802 Equipment Rental 0.00 0.00 4,333.34 (4,333.34) 26,000.04 (26,000.04) 0.00 5803 Joint Pole Use 0.00 0.00 1,666.66 (1,666.66) 9,999.96 (9,999.96) 0.00 5804 Work Order Revenue 0.00 0.00 3,333.34 (3,333.34) 20,000.04 (20,000.04) 0.00 5805 Chugach Coop Divid. 13,141.74 224,800.74 0.00 224,800.74 0.00 224,800.74 0.00 5890 Collection of Doubtful Accounts 0.00 2,729.94 0.00 2,729.94 0.00 2,729.94 0.00 5899 Miscellaneous Revenue 0.00 0.00 333.34 (333.34) 2,000.04 (2,000.04) 0.00 5901 EF Investment Interest 0.00 0.00 2,000.00 (2,000.00) 12,000.00 (12,000.00) 0.00 5905 EF Penalties and Interest 5,416.84 12,267.46 10,000.00 2,267.46 60,000.00 (47,732.54) 20.45 5931 Assessment Interest 0.00 0.00 166.66 (166.66) 999.96 (999.96) 0.00 5940 Amort. of CIA - General 79,024.47 158,048.93 171,793.34 (1 3,744.41) 1,030,760.04 (872,711.11) 15.33 5941 Amort.Bond Premium 0.00 0.00 1,394.34 (1,394.34 8,366.04 (8,366.04) 0.00 Total Revenues $ 1,051,135.5$ 2,230,153.8$ 2,092,211.2$1 137,942.63 12,553,267.3$2 (10,323,113.4$) 17.77 Monthly Budget-to-Actual Revenue Report -- By FUND Run: 4/25/2015 at 11:39 PM City of Seward Page: (C) Water Enterprise Fund For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D Over/(Under) Annual Over/(Under) % of Annual Month Actual Budget Budget Budget Budget Budget Revenues 5300 Residential 37,240.27 73,407.18 74,085.16 (677.98) 444,510.96 (371,103.78) 16.51 5310 SG Service 6,969.19 13,432.41 21,820.16 (8,387.75) 130,920.96 (117,488.55) 10.26 5320 LG Service 15,033.27 29,432.48 37,579.00 (8,146.52) 225,474.00 (196,041.52) 13.05 5330 SM IC Sales 7,561.74 10,226.59 10,683.84 (457.25) 64,103.04 (53,876.45) 15.95 5340 Spec. Contracts 9,667.13 12,695.14 52,377.16 (39,682.02) 314,262.96 (301,567.82) 4.04 5801 Turn on Fees 220.75 501.81 797.34 (295.53) 4,784.04 (4,282.23) 10.49 5806 Ship Water 0.00 0.00 16,632.00 (16,632.00) 99,792.00 (99,792.00) 0.00 5807 Hydrant Rentals 4,631.00 9,262.00 9,783.84 (521.84) 58,703.04 (49,441.04) 15.78 5899 Miscellaneous Revenue 0.00 0.00 50.00 (50.00) 300.00 (300.00) 0.00 5901 EF Investment Interest 0.00 0.00 1,666.66 (1,666.66) 9,999.96 (9,999.96) 0.00 5905 EF Penalties and Interest 806.90 1,618.03 0.00 1,618.03 0.00 1,618.03 0.00 5940 Amort. of CIA - General 2,037.43 4,074.86 3,703.84 371.02 22,223.04 (18,148.18) 18.34 Total Revenues $ 84,167.688 154,650.50 229,179.00 (74,528.50) 1,375,074.0$ (1,220,423.51D) 11.25 Monthly Budget-to-Actual Revenue Report -- By FUND Run: 4/25/2015 at 11:39 PM City of Seward Page: Wastewater Enterprise Fund For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D Over/(Under) Annual Over/(Under) % of Annual Month Actual Budget Budget Budget Budget Budget Revenues 5300 Residential 49,490.26 96,328.97 98,330.50 (2,001.53) 589,983.00 (493,654.03) 16.33 5310 SG Service 9,410.52 18,017.26 30,015.50 (11,998.24) 180,093.00 (162,075.74) 10.00 5320 LG Service 19,440.80 37,661.16 45,080.34 (7,419.18) 270,482.04 (232,820.88) 13.92 5330 SM IC Sales 2,787.63 6,011.40 5,916.84 94.56 35,501.04 (29,489.64) 16.93 5808 Sewer- Inspection 0.00 0.00 87.66 (87.66) 525.96 (525.96) 0.00 5809 Water/Seward Misc. Service 0.00 0.00 87.66 (87.66) 525.96 (525.96) 0.00 5901 EF Investment Interest 0.00 0.00 200.00 (200.00) 1,200.00 (1,200.00) 0.00 5905 EF Penalties and Interest 101.26 217.22 250.00 (32.78) 1,500.00 (1,282.78) 14.48 5940 Amort. of CIA - General 13,717.75 27,435.47 27,435.50 (0.03) 164,613.00 (137,177.53) 16.67 Total Revenues $ 94,948.22$ 185,671.4$ 207,404.05 (21,732.52) 1,244,424.08 (1,058,752.5$2) 14.92 Monthly Budget-to-Actual EXP Report by FUND Run: 4/25/2015 at 11:41 PM City of Seward Page: General Fund (�J/ For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D (Over)/Under Annual (Over)/Under % of Annual Month Actual Budget Budget Budget Budget Budget Expenditures Personnel Costs: 6000 Salaries 273,731.69 507,099.68 649,380.32 142,280.64 3,931,523.92 3,424,424.24 12.90 6001 Overtime 12,409.58 23,551.15 21,129.86 (2,421.29) 126,779.16 103,228.01 18.58 6002 Standby Time 997.53 2,089.82 1,361.50 (728.32) 8,169.00 6,079.18 25.58 6100 Medicare 5,852.09 10,950.61 13,164.36 2,213.75 81,307.16 70,356.55 13.47 6101 Unemployment Insurance (1,613.98) 0.00 1,250.00 1,250.00 7,500.00 7,500.00 0.00 6102 Workers' Compensation 10,125.34 19,544.00 23,215.10 3,671.10 141,853.60 122,309.60 13.78 6200 Leave Time 29,597.44 66,576.99 71,927.50 5,350.51 431,565.00 364,988.01 15.43 6201 Retirement Benefits 62,339.10 118,130.64 149,138.16 31,007.52 896,233.46 778,102.82 13.18 6202 Health Insurance 121,351.74 172,952.15 236,204.02 63,251.87 1,447,224.10 1,274,271.95 11.95 6203 In Lieu of FICA 842.77 1,397.66 823.16 (574.50) 4,938.96 3,541.30 28.30 Total Personnel Costs: $ 515,633.38 922,292.78 1,167,593.98 245,301.28 7,077,094.36 6,154,801.65 13.03 Non-Personnel Costs: 7000 Audit 0.00 0.00 11,666.66 11,666.66 94,999.96 94,999.96 0.00 7001 Communications 8,972.36 18,731.71 17,332.46 (1,399.25) 103,994.76 85,263.05 18.01 7002 Postage and Freight 1,114.63 7,028.33 7,374.98 346.65 44,249.88 37,221.55 15.88 7003 Banking & Credit Card Fees 541.07 1,017.43 1,683.34 665.91 10,100.04 9,082.61 10.07 7004 Insurance 0.00 107,348.52 36,333.28 (71,015.24) 217,999.68 110,651.16 49.24 7006 Legal 7,849.71 12,233.50 21,666.66 9,433.16 129,999.96 117,766.46 9.41 7009 Contracted Services 36,924.14 45,199.88 43,016.68 (2,183.20) 376,100.08 330,900.20 12.02 7010 Engineering 0.00 20.26 0.00 (20.26) 0.00 (20.26) 0.00 7011 Testing 101.00 301.00 0.00 (301.00) 0.00 (301.00) 0.00 7012 Other Special Services 0.00 0.00 4,916.68 4,916.68 45,900.08 45,900.08 0.00 7013 State Lobbying Fees 8,042.00 21,126.00 14,083.34 (7,042.66) 84,500.04 63,374.04 25.00 7014 Federal Lobbying Fees 7,667.00 22,997.00 15,366.66 (7,630.34) 92,199.96 69,202.96 24.94 7015 Utilities 38,138.19 75,844.61 76,250.00 405.39 457,500.00 381,655.39 16.58 7016 Heating Fuel 7,277.30 14,123.56 18,371.00 4,247.44 110,226.00 96,102.44 12.81 7017 Rents & Leases 2,500.00 20,641.47 10,416.68 (10,224.79) 62,500.08 41,858.61 33.03 7201 01000 General Fund Library Books 1,893.88 2,066.05 2,000.00 (66.05) 12,000.00 9,933.95 17.22 7202 Library Periodicals (112.57) (112.57) 500.00 612.57 3,000.00 3,112.57 (3.75 7203 Library Standing Orders 0.00 699.00 833.34 134.34 5,000.04 4,301.04 13.98 7204 Library Non-Print 499.20 894.61 916.66 22.05 5,499.96 4,605.35 16.27 7210 Vehicle Supplies 0.00 20.98 1,303.34 1,282.36 7,820.04 7,799.06 0.27 7211 Gas & Lube 1,750.63 4,189.18 18,591.68 14,402.50 111,550.08 107,360.90 3.76 7212 Uniform Allowance 1,240.55 2,949.93 1,153.32 (1,796.61) 6,919.92 3,969.99 42.63 7213 Safety Equipment 1,366.70 2,230.96 2,929.14 698.18 17,574.84 15,343.88 12.69 7214 Janitorial Supplies 910.75 2,450.27 2,300.00 (150.27) 13,800.00 11,349.73 17.76 7215 Operating Supplies 11,945.82 34,986.72 46,520.82 11,534.10 284,124.92 249,138.20 12.31 7216 Maintenance & Repair 1,738.46 29,096.62 37,571.64 8,475.02 225,429.84 196,333.22 12.91 7217 Small Tools & Equipment 2,118.64 5,854.88 10,504.16 4,649.28 63,024.96 57,170.08 9.29 7218 Inmate Meals 926.24 1,425.01 2,333.34 908.33 14,000.04 12,575.03 10.18 7300 Advertising 2,233.14 4,023.43 5,428.34 1,404.91 32,570.04 28,546.61 12.35 7301 Subscriptions & Dues 19.95 3,667.37 4,068.32 400.95 24,409.92 20,742.55 15.02 7302 Travel & Subsistence 5,865.83 15,957.78 16,416.70 458.92 103,600.20 87,642.42 15.40 7303 Education & Training 2,523.53 5,347.78 7,885.02 2,537.24 53,910.12 48,562.34 9.92 7304 Equipment Rent 863.22 1,726.44 9,143.34 7,416.90 54,860.04 53,133.60 3.15 7307 GF Administrative Fee 7,503.12 15,006.24 15,006.16 (0.08) 90,036.96 75,030.72 16.67 Monthly Budget-to-Actual EXP Report by FUND Run: 4/25/2015 at 11:41 PM City of Seward Page: General Fund t For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D (Over)/Under Annual (Over)/Under % of Annual Month Actual Budget Budget Budget Budget Budget 7800 Sister City Program 0.00 0.00 750.00 750.00 4,500.00 4,500.00 0.00 7801 Contributions 95,000.00 95,000.00 31,666.66 (63,333.34) 189,999.96 94,999.96 50.00 7802 Contributions to Senior Citizens 0.00 75,000.00 12,500.00 (62,500.00) 75,000.00 0.00 100.00 7803 Contributions to SCF 0.00 25,000.00 4,166.66 (20,833.34) 24,999.96 (0.04) 100.00 7804 Elections 0.00 0.00 666.66 666.66 3,999.96 3,999.96 0.00 7805 Promotion 0.00 0.00 891.68 891.68 5,350.08 5,350.08 0.00 7806 Volunteer Fireman Stipend 3,333.32 4,999.98 3,333.34 (1,666.64) 20,000.04 15,000.06 25.00 7807 Contingency 0.00 5,000.00 1,883.34 (3,116.66) 11,300.04 6,300.04 44.25 7808 Bad Debt Expense 0.00 0.00 250.00 250.00 1,500.00 1,500.00 0.00 7810 Miscellaneous Expense 10,050.00 10,195.80 4,962.50 (5,233.30) 29,775.00 19,579.20 34.24 8012 Debt Service Interest Expense 155,150.00 155,150.00 25,858.34 (129,291.66) 155,150.04 0.04 100.00 8103 Capital Equipment 0.00 0.00 1,500.00 1,500.00 9,000.00 9,000.00 0.00 8104 Motor Pool Rent 17,969.08 35,938.20 35,938.16 (0.04) 215,628.96 179,690.76 16.67 8300 Debt Service Principal 0.00 0.00 33,464.00 33,464.00 200,784.00 200,784.00 0.00 Total Non-Personnel Costs: $ 443,916.8$ 885,377.93 621,715.05 (263,662.8$) 3,906,390.4$ 3,021,012.5$ 22.66 Total Expenditures $ 959,550.1$ 1,807,670.6$ 1,789,309.0$ (18,361.5$) 10,983,484.8$ 9,175,814.2$ 16.46 Monthly Budget-to-Actual EXP Report by FUND Run: 4/25/2015 at 11:41 PM City of Seward Page: I O Harbor Enterprise Fund For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D (Over)/Under Annual (Over)/Under % of Annual Month Actual Budget Budget Budget Budget Budget Expenditures Personnel Costs: 6000 Salaries 30,330.70 65,092.53 87,831.00 22,738.47 526,986.00 461,893.47 12.35 6001 Overtime 859.80 2,244.40 7,086.50 4,842.10 42,519.00 40,274.60 5.28 6002 Standby Time 1,067.71 1,998.17 2,019.34 21.17 12,116.04 10,117.87 16.49 6100 Medicare 567.88 1,134.70 1,698.52 563.82 10,191.12 9,056.42 11.13 6101 Unemployment Insurance (797.81) 0.00 0.00 0.00 0.00 0.00 0.00 6102 Workers' Compensation 2,462.24 5,037.79 5,447.16 409.37 32,682.96 27,645.17 15.41 6200 Leave Time 6,299.08 11,880.35 1 0,390.84 (1,489.51) 62,345.04 50,464.69 19.06 6201 Retirement Benefits 9,055.61 17,831.89 23,871.50 6,039.61 143,229.00 125,397.11 12.45 6202 Health Insurance 18,869.32 27,289.71 37,142.84 9,853.13 227,257.05 199,967.34 12.01 Total Personnel Costs: $ 68,714.5:$ 132,509.54 175,487.76 42,978.1E4 1,057,326.2$ 924,816.6$ 12.53 Non-Personnel Costs: 7001 Communications 803.53 2,347.83 2,000.00 (347.83) 12,000.00 9,652.17 19.57 7002 Postage and Freight 0.00 397.38 1,791.66 1,394.28 10,749.96 10,352.58 3.70 7003 Bank and Credit Card Fees 1,902.55 10,031.80 8,333.34 (1,698.46) 50,000.04 39,968.24 20.06 7004 Insurance 0.00 19,836.13 8,916.66 (10,919.47) 53,499.96 33,663.83 37.08 7006 Legal 626.70 902.55 1,666.66 764.11 9,999.96 9,097.41 9.03 7009 Contracted Services 12,083.68 23,463.52 15,166.66 (8,296.86) 90,999.96 67,536.44 25.78 7011 Testing 303.00 351.00 0.00 (351.00) 0.00 (351.00) 0.00 7015 Utilities 7,534.98 16,127.57 19,166.68 3,039.11 115,000.08 98,872.51 14.02 7016 Heating Fuel 533.75 1,491.17 1,666.66 175.49 9,999.96 8,508.79 14.91 7100 General Power for Resale 21,110.88 47,044.40 60,833.34 13,788.94 359,000.04 311,955.64 13.10 7211 Gas & Lube 918.69 1,937.57 4,833.32 2,895.75 28,999.92 27,062.35 6.68 7213 Safety Equipment 85.78 139.49 1,250.00 1,110.51 7,500.00 7,360.51 1.86 7214 Janitorial Supplies 0.00 446.23 1,416.66 970.43 8,499.96 8,053.73 5.25 7215 Operating Supplies 748.96 2,572.06 5,666.66 3,094.60 33,999.96 31,427.90 7.56 7216 Maintenance & Repair 919.25 3,368.38 8,666.68 5,298.30 52,000.08 48,631.70 6.48 7217 Small Tools & Equipment 436.04 525.14 1,833.34 1,308.20 17,000.04 16,474.90 3.09 7300 Advertising 0.00 241.00 833.34 592.34 5,000.04 4,759.04 4.82 7301 Subscriptions & Dues 0.00 0.00 250.00 250.00 1,500.00 1,500.00 0.00 7302 Travel & Subsistence 624.22 886.35 1,666.66 780.31 9,999.96 9,113.61 8.86 7303 Education & Training 660.00 1,135.00 666.66 (468.34) 3,999.96 2,864.96 28.38 7304 Equipment Rent 148.37 296.74 83.34 (213.40) 500.04 203.30 59.34 7321 Harbor General Indirect Costs 35,921.11 71,842.30 69,975.34 (1,866.96) 419,852.04 348,009.74 17.11 7322 Harbor Adm in Indirect Costs 24,030.10 48,060.19 46,784.48 (1,275.71) 280,706.88 232,646.69 17.12 7323 SM IC General Indirect Costs 378.94 757.88 0.00 (757.88) 0.00 (757.88) 0.00 7324 Gen Fund Indirect Costs 27,745.63 55,491.26 55,491.34 0.08 332,948.04 277,456.78 16.67 7325 Harbor Internal Cost Allocation (67,287.42) (134,574.69) (134,574.84) (0.15) (807,449.04) (672,874.35) 16.67 7330 P.I.L.T. 0.00 0.00 30,474.66 30,474.66 182,847.96 182,847.96 0.00 7331 Reclass PILT to Transfer-Out 0.00 0.00 (30,474.66) (30,474.66) (182,847.96) (182,847.96) 0.00 7808 Bad Debt Expense 0.00 0.00 1,666.68 1,666.68 10,000.08 10,000.08 0.00 7810 Miscellaneous Expense 0.00 0.00 583.34 583.34 3,500.04 3,500.04 0.00 7900 Depreciation Expense 117,079.58 234,159.20 262,952.34 28,793.14 1,577,714.04 1,343,554.84 14.84 8012 Debt Service Interest Expense 0.00 2,967.34 40,354.34 37,387.00 268,823.12 265,855.78 1.10 8014 Amortization of Bond Issue Costs 0.00 0.00 988.16 988.16 (0.04) (0.04) 0.00 8101 Infrastructure 987.00 1,471.23 0.00 (1,471.23) 0.00 (1,471.23) 0.00 Monthly Budget-to-Actual EXP Report by FUND Run: 4/25/2015 at 11:41 PM City of Seward Page: 1 Harbor Enterprise Fund ll For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D (Over)/Under Annual (Over)/Under % of Annual Month Actual Budget Budget Budget Budget Budget 8104 Motor Pool Rent 4,817.51 9,634.90 9,635.02 0.12 57,810.12 48,175.22 16.67 8300 Debt Service Principal 0.00 26,253.80 81,042.34 54,788.54 511,859.05 485,605.25 5.13 Total Non-Personnel Costs: $ 193,112.83 449,604.7$ 581,606.86 132,002.1$ 3,536,014.2$ 3,086,409.5$ 12.72 Total Expenditures $ 261,827.3$ 582,114.26 757,094.56 174,980.3$ 4,593,340.4$ 4,011,226.2$ 12.67 Monthly Budget-to-Actual EXP Report by FUND Run: 4/25/2015 at 11:41 PM City of Seward Page: .2 - SMIC Enterprise Fund I For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D (Over)/Under Annual (Over)/Under % of Annual Month Actual Budget Budget Budget Budget Budget Expenditures Personnel Costs: 6000 Salaries 4,473.22 6,537.85 10,598.50 4,060.65 63,591.00 57,053.15 10.28 6001 Overtime 0.00 44.48 550.84 506.36 3,305.04 3,260.56 1.35 6100 Medicare 77.76 109.16 172.50 63.34 1,035.00 925.84 10.55 6102 Workers' Compensation 451.11 616.72 840.34 223.62 5,042.04 4,425.32 12.23 6201 Retirement Benefits 1,239.79 1,721.06 393.00 (1,328.06) 2,358.00 636.94 72.99 6202 Health Insurance 2,624.22 2,843.22 1,973.00 (870.22) 12,138.00 9,294.78 23.42 Total Personnel Costs: $ 8,866.10$ 11,872.4% 14,528.1E6 2,655.6g6 87,469.0£6 75,596.5% 13.57 Non-Personnel Costs: 7001 Communications 0.00 0.00 83.34 83.34 500.04 500.04 0.00 7002 Postage and Freight 0.00 310.88 916.68 605.80 5,500.08 5,189.20 5.65 7003 Bank and Credit Card Fees 0.00 9.95 0.00 (9.95) 0.00 (9.95) 0.00 7004 Insurance 0.00 7,499.03 1,483.34 (6,015.69) 8,900.04 1,401.01 84.26 7006 Legal 1,348.20 2,778.30 0.00 (2,778.30) 0.00 (2,778.30) 0.00 7009 Contracted Services 0.00 0.00 8,333.34 8,333.34 50,000.04 50,000.04 0.00 7015 Utilities 1,629.86 3,317.25 2,500.00 (817.25) 15,000.00 11,682.75 22.12 7016 Heating Fuel 304.91 584.96 1,000.00 415.04 6,000.00 5,415.04 9.75 7100 General Power for Resale 1,561.65 1,561.65 3,666.66 2,105.01 21,999.96 20,438.31 7.10 7102 Power Fuel Costs 0.00 2,205.15 0.00 (2,205.15) 0.00 (2,205.15) 0.00 7211 Gas & Lube 2,711.19 2,744.79 1,666.66 (1,078.13) 9,999.96 7,255.17 27.45 7215 Operating Supplies 892.27 1,090.35 1,000.00 (90.35) 6,000.00 4,909.65 18.17 7216 Maintenance & Repair 146.55 918.36 6,000.00 5,081.64 36,000.00 35,081.64 2.55 7217 Small Tools & Equipment 1,027.29 1,060.28 250.00 (810.28) 1,500.00 439.72 70.69 7300 Advertising 0.00 0.00 833.34 833.34 5,000.04 5,000.04 0.00 7302 Travel & Subsistence 0.00 0.00 16.66 16.66 99.96 99.96 0.00 7304 Equipment Rent 0.00 0.00 0.00 0.00 17,000.00 17,000.00 0.00 7321 Harbor General Indirect Costs 4,404.89 8,809.70 8,580.84 (228.86) 51,485.04 42,675.34 17.11 7322 Harbor Admin Indirect Costs 2,931.32 5,862.50 5,707.00 (155.50) 34,242.00 28,379.50 17.12 7323 SMIC General Indirect Costs (378.94) (757.88) 21,304.00 22,061.88 127,824.00 128,581.88 (0.59 7324 Gen Fund Indirect Costs 7,368.42 14,736.80 14,736.84 0.04 88,421.04 73,684.24 16.67 7325 Harbor Internal Cost Allocation 0.00 0.00 (21,470.66) (21,470.66) (128,823.96) (128,823.96) 0.00 7330 P.I.L.T. 0.00 0.00 3,430.02 3,430.02 20,580.12 20,580.12 0.00 7331 Reclass PILT to Transfer-Out 0.00 0.00 (3,430.02) (3,430.02) (20,580.12) (20,580.12) 0.00 7808 Bad Debt Expense 0.00 0.00 666.66 666.66 3,999.96 3,999.96 0.00 7900 Depreciation Expense 50,152.61 100,305.15 190,043.18 89,738.03 1,140,259.08 1,039,953.93 8.80 8300 Debt Service Principal 0.00 147,012.43 0.00 (147,012.43) 0.00 (147,012.43) 0.00 Total Non-Personnel Costs: $ 74,100.22¢ 300,049.6$ 247,317.8$ (52,731.7$) 1,500,907.28 1,200,857.6$ _ 19.99 Total Expenditures $ 82,966.32$ 311,922.14 261,846.04 (50,076.0$) 1,588,376.3$ 1,276,454.2$ 19.64 • v Monthly Budget-to-Actual EXP Report by FUND Run: 4/25/2015 at 11:41 PM City of Seward Page: 3 Electric Enterprise Fund For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D (Over)/Under Annual (Over)/Under % of Annual Month Actual Budget Budget Budget Budget Budget Expenditures Personnel Costs: 6000 Salaries 52,614.13 96,806.39 151,067.00 54,260.61 906,402.00 809,595.61 10.68 6001 Overtime 5,449.84 7,974.92 10,806.34 2,831.42 64,838.04 56,863.12 12.30 6002 Standby Time 12,445.76 22,371.68 14,880.50 (7,491.18) 89,283.00 66,911.32 25.06 6100 Medicare 1,200.31 2,059.20 2,696.98 637.78 16,181.88 14,122.68 12.73 6101 Unemployment Insurance 0.00 0.00 500.00 500.00 3,000.00 3,000.00 0.00 6102 Workers' Compensation 3,413.61 4,436.09 7,443.00 3,006.91 44,658.00 40,221.91 9.93 6200 Leave Time 5,422.97 10,584.60 17,702.68 7,118.08 106,216.08 95,631.48 9.97 6201 Retirement Benefits 11,275.35 18,828.89 28,071.50 9,242.61 168,429.00 149,600.11 11.18 6202 Health Insurance 16,367.02 22,038.81 36,008.00 13,969.19 220,348.00 198,309.19 10.00 6204 Electric Meal Allowance 352.80 352.80 2,114.84 1,762.04 12,689.04 12,336.24 2.78 6205 Electric Union Benefits 129.75 211.48 52,960.50 52,749.02 317,763.00 317,551.52 0.07 Total Personnel Costs: $ 108,671.54 185,664.86 324,251.34 138,586.46 1,949,808.0$ 1,764,143.1$ 9.52 Non-Personnel Costs: 7001 Communications 1,118.25 2,319.05 3,416.66 1,097.61 20,499.96 18,180.91 11.31 7002 Postage and Freight 3,137.98 4,544.54 4,000.00 (544 54) 24,000.00 19,455.46 18.94 7003 Bank and Credit Card Fees 4,165.20 7,943.59 8,000.00 56.41 48,000.00 40,056.41 16.55 7004 Insurance 0.00 29,822.48 10,833.34 (18,989.14) 65,000.04 35,177.56 45.88 7006 Legal 1,382.50 2,761.92 10,333.34 7,571.42 62,000.04 59,238.12 4.45 7009 Contracted Services 3,998.75 9,536.27 44,570.34 35,034.07 267,422.04 257,885.77 3.57 7012 Other Special Services 875.97 1,799.12 2,500.00 700.88 15,000.00 13,200.88 11.99 7015 Utilities 7,241.86 15,503.85 15,666.66 162.81 100,999.96 85,496.11 15.35 7016 Heating Fuel 1,158.74 2,706.20 5,666.68 2,960.48 37,000.08 34,293.88 7.31 7017 Rents & Leases 33.33 5,852.58 2,833.34 (3,019.24) 17,000.04 11,147.46 34.43 7101 Chugach Power Purchases 321,347.21 335,992.21 295,833.34 (40,158.87) 1,775,000.04 1,439,007.83 18.93 7102 Power Fuel Costs 467,839.00 467,839.00 511,000.00 43,161.00 3,066,000.00 2,598,161.00 15.26 7103 Fuel for Generators 0.00 27,381.70 25,000.00 (2,381.70) 150,000.00 122,618.30 18.25 7210 Vehicle Supplies 113.56 113.56 833.34 719.78 5,000.04 4,886.48 2.27 7211 Gas & Lube 982.67 8,618.47 7,166.66 (1,451.81) 42,999.96 34,381.49 20.04 7213 Safety Equipment 0.00 0.00 833.34 833.34 5,000.04 5,000.04 0.00 7215 Operating Supplies 3,854.44 10,656.63 45,833.34 35,176.71 275,000.04 264,343.41 3.88 7216 Maintenance & Repair 481.92 980.47 20,833.34 19,852.87 125,000.04 124,019.57 0.78 7217 Small Tools & Equipment 394.99 1,956.40 8,333.36 6,376.96 50,000.16 48,043.76 3.91 7300 Advertising 0.00 0.00 1,333.34 1,333.34 8,000.04 8,000.04 0.00 7301 Subscriptions & Dues 155.85 155.85 1,666.68 1,510.83 10,000.08 9,844.23 1.56 7302 Travel & Subsistence 330.00 788.28 5,000.00 4,211.72 30,000.00 29,211.72 2.63 7303 Education & Training 528.00 1,578.00 7,499.98 5,921.98 44,999.88 43,421.88 3.51 7304 Equipment Rent 445.63 1,072.26 3,833.34 2,761.08 23,000.04 21,927.78 4.66 7307 GF Administrative Fee 72,379.83 144,759.70 144,759.66 (0.04) 868,557.96 723,798.26 16.67 7330 P.I.L.T. 0.00 0.00 152,548.50 152,548.50 915,291.00 915,291.00 0.00 7331 Reclass PILT to Transfer-Out 0.00 0.00 (152,548.50) (152,548.50) (915,291.00) (915,291.00) 0.00 7808 Bad Debt Expense 0.00 1,760.18 5,000.00 3,239.82 30,000.00 28,239.82 5.87 7810 Miscellaneous Expense 200.00 514.00 2,166.66 1,652.66 12,999.96 12,485.96 3.95 7900 Depreciation Expense 144,376.56 288,753.04 296,218.00 7,464.96 1,777,308.00 1,488,554.96 16.25 8010 Utility Deposit Interest 88.13 189.52 233.34 43.82 1,400.04 1,210.52 13.54 8012 Debt Service Interest Expense 0.00 0.00 45,543.50 45,543.50 273,261.00 273,261.00 0.00 s • Monthly Budget-to-Actual EXP Report by FUND Run: 4/25/2015 at 11:41 PM City of Seward Page: ti--( Electric Enterprise Fund For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D (Over)/Under Annual (Over)/Under % of Annual Month Actual Budget Budget Budget Budget Budget 8014 Amortization of Bond Issue Costs 0.00 0.00 1,404.16 1,404.16 8,424.96 8,424.96 0.00 8101 Infrastructure 0.00 0.00 94,166.66 94,166.66 564,999.96 564,999.96 0.00 8103 Capital Equipment 0.00 3,304.00 8,333.34 5,029.34 50,000.04 46,696.04 6.61 8104 Motor Pool Rent 14,583.33 29,166.70 29,166.66 (0.04) 174,999.96 145,833.26 16.67 8201 Work Order Operating Supply credits 0.00 0.00 (8,333.34) (8,333.34) (50,000.04) (50,000.04) 0.00 8300 Debt Service Principal 0.00 0.00 66,666.66 66,666.66 399,999.96 399,999.96 0.00 Total Non-Personnel Costs: $ 1,051,213.7$ 1,408,369.5$ 1,728,145.7$ 319,776.1$ 10,378,874.312 8,970,504.7$ 13.57 Total Expenditures $ 1,159,885.2$ 1,594,034.4$ 2,052,397.0$ 458,362.63 12,328,682.3$ 10,734,647.9$ 12.93 ..lb Monthly Budget-to-Actual EXP Report by FUND Run: 4/25/2015 at 11:41 PM City of Seward ' / Page: Water Enterprise Fund For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D (Over)/Under Annual (Over)/Under % of Annual Month Actual Budget Budget Budget Budget Budget Expenditures Personnel Costs: 6000 Salaries 14,004.50 26,301.07 36,270.34 9,969.27 217,622.04 191,320.97 12.09 6001 Overtime 666.78 1,136.04 767.50 (368.54) 4,605.00 3,468.96 24.67 6002 Standby Time 853.20 1,602.30 1,846.50 244.20 11,079.00 9,476.70 14.46 6100 Medicare 212.41 375.09 527.00 151.91 3,162.00 2,786.91 11.86 6102 Workers' Compensation 694.47 198.07 1,889.32 1,691.25 11,335.92 11,137.85 1.75 6200 Leave Time (4,929.11) (2,390.71) 2,448.50 4,839.21 14,691.00 17,081.71 (16.27 6201 Retirement Benefits 3,853.15 6,758.48 8,942.00 2,183.52 53,652.00 46,893.52 12.60 6202 Health Insurance 6,429.34 8,654.53 12,552.00 3,897.47 76,712.00 68,057.47 11.28 6203 In Lieu of FICA 248.32 360.90 82.34 (278.56) 494.04 133.14 73.05 Total Personnel Costs: $ 22,033.0($ 42,995.77$ 65,325.5($ 22,329.7$$ 393,353.0$ 350,357.2$ 10.93 Non-Personnel Costs: 7001 Communications 470.32 1,541.80 1,750.00 208.20 10,500.00 8,958.20 14.68 7002 Postage and Freight 582.25 693.03 1,125.00 431.97 6,750.00 6,056.97 10.27 7003 Bank and Credit Card Fees 440.57 862.04 750.00 (112 04) 4,500.00 3,637.96 19.16 7004 Insurance 0.00 5,360.42 1,400.00 (3,960.42) 8,400.00 3,039.58 63.81 7006 Legal 0.00 0.00 916.66 916.66 5,499.96 5,499.96 0.00 7009 Contracted Services 0.00 44,656.27 17,333.32 (27,322.95) 103,999.92 59,343.65 42.94 7011 Testing 477.00 1,317.00 1,908.34 591.34 11,450.04 10,133.04 11.50 7015 Utilities 11,445.70 22,039.80 40,416.66 18,376.86 242,499.96 220,460.16 9.09 7211 Gas & Lube 453.69 965.64 1,733.34 767.70 10,400.04 9,434.40 9.28 7213 Safety Equipment 115.58 254.11 458.34 204.23 2,750.04 2,495.93 9.24 7215 Operating Supplies 1,395.34 2,692.19 7,166.66 4,474.47 42,999.96 40,307.77 6.26 7216 Maintenance & Repair 682.94 771.44 5,500.00 4,728.56 33,000.00 32,228.56 2.34 7217 Small Tools & Equipment 144.75 1,245.60 1,325.00 79.40 7,950.00 6,704.40 15.67 7300 Advertising 0.00 0.00 333.34 333.34 2,000.04 2,000.04 0.00 7301 Subscriptions & Dues 214.50 827.00 216.66 (610.34) 1,299.96 472.96 63.62 7302 Travel & Subsistence 116.71 439.50 933.34 493.84 5,600.04 5,160.54 7.85 7303 Education & Training 0.00 0.00 1,100.00 1,100.00 6,600.00 6,600.00 0.00 7304 Equipment Rent 0.00 0.00 1,583.34 1,583.34 9,500.04 9,500.04 0.00 7307 GF Administrative Fee 19,967.58 39,935.20 39,935.16 (0.04) 239,610.96 199,675.76 16.67 7330 P.I.L.T. 0.00 0.00 17,904.66 17,904.66 107,427.96 107,427.96 0.00 7331 Reclass PILT to Transfer-Out 0.00 0.00 (17,904.66) (17,904.66) (107,427.96) (107,427.96) 0.00 7808 Bad Debt Expense 0.00 0.00 333.34 333.34 2,000.04 2,000.04 0.00 7810 Miscellaneous Expense 0.00 0.00 416.68 416.68 2,500.08 2,500.08 0.00 7900 Depreciation Expense 16,878.61 33,757.17 32,723.32 (1,033.85) 196,339.92 162,582.75 17.19 8012 Debt Service Interest Expense 27,286.49 27,286.49 4,547.66 (22,738.83) 27,285.96 (0.53) 100.00 8103 Capital Equipment 1,759.63 3,158.63 0.00 (3,158.63) 0.00 (3,158.63) 0.00 8104 Motor Pool Rent 375.00 750.00 750.00 0.00 4,500.00 3,750.00 16.67 8300 Debt Service Principal 127,774.18 127,774.18 21,295.66 (106,478.52) 127,773.96 (0 22) 100.00 Total Non-Personnel Costs: $ 210,580.8$ 316,327.5$ 185,951.8$ (130,375.6$) 1,115,710.9$ 799,383.4$ 28.35 Total Expenditures $ 232,613.9$ 359,323.2$ 251,277.3$ (108,045.9$) 1,509,063.9$ 1,149,740.6$ 23.81 • �~ Monthly Budget-to-Actual EXP Report by FUND Run: 4/25/2015 at 11:41 PM City of Seward Page: l Wastewater Enterprise Fund (to For 2/28/2015 Variance Variance Actual Y-T-D Y-T-D (Over)/Under Annual (Over)/Under % of Annual Month Actual Budget Budget Budget Budget Budget Expenditures Personnel Costs: 6000 Salaries 11,418.66 23,345.55 26,613.00 3,267.45 159,678.00 136,332.45 14.62 6001 Overtime 50.33 50.33 528.34 478.01 3,170.04 3,119.71 1.59 6002 Standby Time 411.39 778.47 1,081.84 303.37 6,491.04 5,712.57 11.99 6100 Medicare 154.59 320.33 372.68 52.35 2,236.08 1,915.75 14.33 6102 Workers' Compensation 504.85 1,021.22 1,609.50 588.28 9,657.00 8,635.78 10.57 6200 Leave Time 1,500.97 3,286.88 2,482.34 (804.54) 14,894.04 11,607.16 22.07 6201 Retirement Benefits 2,944.28 5,902.51 6,600.50 697.99 39,603.00 33,700.49 14.90 6202 Health Insurance 5,076.59 7,241.61 8,996.00 1,754.39 54,976.00 47,734.39 13.17 6203 In Lieu of FICA 248.33 360.90 82.34 (278.56) 494.04 133.14 73.05 Total Personnel Costs: $ 22,309.9% 42,307.8($ 48,366.54 6,058.74$ 291,199.24; 248,891.44 14.53 Non-Personnel Costs: 7001 Communications 470.32 1,161.17 1,450.00 288.83 8,700.00 7,538.83 13.35 7002 Postage and Freight 567.19 672.44 666.66 (5.78) 3,999.96 3,327.52 16.81 7003 Bank and Credit Card Fees 544.27 1,082.69 950.00 (132.69) 5,700.00 4,617.31 18.99 7004 Insurance 0.00 3,405.23 1,083.34 (2,321.89) 6,500.04 3,094.81 52.39 7006 Legal 0.00 0.00 833.34 833.34 5,000.04 5,000.04 0.00 7009 Contracted Services 8,917.84 9,311.04 14,500.00 5,188.96 87,000.00 77,688.96 10.70 7011 Testing 1,635.00 2,495.00 3,366.66 871.66 20,199.96 17,704.96 12.35 7015 Utilities 15,495.97 32,957.27 32,833.34 (123.93) 197,000.04 164,042.77 16.73 7016 Heating Fuel 0.00 0.00 300.00 300.00 1,800.00 1,800.00 0.00 7017 Rents & Leases 0.00 0.00 83.34 83.34 500.04 500.04 0.00 7211 Gas & Lube 371.43 1,066.59 1,466.68 400.09 8,800.08 7,733.49 12.12 7213 Safety Equipment 0.00 0.00 50.00 50.00 300.00 300.00 0.00 7215 Operating Supplies 394.76 1,281.44 2,416.68 1,135.24 14,500.08 13,218.64 8.84 7216 Maintenance & Repair 98.56 98.56 5,583.34 5,484.78 33,500.04 33,401.48 0.29 7217 Small Tools & Equipment 220.19 1,542.21 500.00 (1,042.21) 3,000.00 1,457.79 51.41 7300 Advertising 0.00 0.00 83.34 83.34 500.04 500.04 0.00 7301 Subscriptions & Dues 2,620.00 2,620.00 283.34 (2,336.66) 1,700.04 (919.96) 154.11 7302 Travel & Subsistence 0.00 0.00 666.66 666.66 3,999.96 3,999.96 0.00 7303 Education & Training 0.00 0.00 333.34 333.34 2,000.04 2,000.04 0.00 7304 Equipment Rent 0.00 0.00 183.34 183.34 1,100.04 1,100.04 0.00 7307 GF Administrative Fee 12,194.00 24,388.00 24,388.00 0.00 146,328.00 121,940.00 16.67 7330 P.I.L.T. 0.00 0.00 14,361.66 14,361.66 86,169.96 86,169.96 0.00 7331 Reclass PILI to Transfer-Out 0.00 0.00 (14,361.66) (14,361.66) (86,169.96) (86,169.96) 0.00 7808 Bad Debt Expense 0.00 0.00 291.66 291.66 1,749.96 1,749.96 0.00 7810 Miscellaneous Expense 0.00 100.00 166.66 66.66 999.96 899.96 10.00 7900 Depreciation Expense 18,575.27 37,150.37 34,976.82 (2,173.55) 209,860.92 172,710.55 17.70 8012 Debt Service Interest Expense 0.00 0.00 1,000.00 1,000.00 30,070.00 30,070.00 0.00 8103 Capital Equipment 1,759.62 3,158.62 0.00 (3,158.62) 0.00 (3,158.62) 0.00 8104 Motor Pool Rent 375.00 750.00 750.00 0.00 4,500.00 3,750.00 16.67 8300 Debt Service Principal 0.00 0.00 2,883.00 2,883.00 91,351.00 91,351.00 0.00 Total Non-Personnel Costs: $ 64,239.426 123,240.63 132,089.54 8,848.91$ 890,660.24 767,419.6$ 13.84 Total Expenditures $ 86,549.4'$ 165,548.43 180,456.05 14,907.6$ 1,181,859.48 1,016,311.0$ 14.01