Loading...
HomeMy WebLinkAbout08262013 City Council Laydowns i . alZies CITY OF SEWARD City Manager,Jim Hunt P.O. Box 167 Telephone (907)224-4047 Seward,AK 99664 Facsimile (907)224-4038 MANAGER'S REPORT August 26, 2013 The following purchase order was approved by the City Manager since the last council meeting: 4, A purchase order for$48,275 has been issued through the electric department to Harmon Construction for re-route for the pedestrian pathway and drainage ditch on Sea Lion Avenue. A purchase order was issued to Bering Marine for$12,380 through the Public Works Department to purchase 65 tons of bulk salt to mix with our winter street sand. A. Clerk's Office: (1) Residents of Seward and the surrounding area are encouraged to register to vote, or update their voter registration, at the City Clerk's office in preparation for the October 1, 2013 municipal election. The City Clerk's office is open from 8—5, Monday through Friday. (2) Everyone is invited to the 110th Anniversary of Seward's Founder's Day event,to be held at the Library/Museum on the corner of 6th and Adams Street on Wednesday,August 28, 2013 from 2-6:00 pm. Please bring your family and friends and join us for activities and refreshments throughout the afternoon. B. Electric: (1) The earth work is progressing for the warehouse. At the request of the electric department the construction crews are coordinating with the schools schedules to minimize traffic concerns. (2) A reminder to Seward that the end of the construction season is nearing. Anyone wishing to upgrade or add new electric facilities is urged to complete their paperwork quickly. (3) As requested, a spreadsheet listing the committed funds from the AEA grant is included. The operator/mechanic was hired at the beginning of 2011,not only to work on the generator portion of the grant but,also to train with the current operators who are nearing retirement. Since we have not begun the generator portion of the project,the operators have not yet charged any time to it. C. Harbor: (1) Recent rainy weather has delayed the concrete pouring at the wash down pad until August 23. (2) D Float work will begin after Labor Day. It is scheduled for completion by April 15, 2014. The Harbor staff has been communicating closely with the Finance Department,tallying the expenses of the D float design grant from the Denali Commission. (3) An inspector found both asbestos and lead paint in the Harbormaster Restrooms. The contractor is seeking prices from abatement contractors. (4) On August 12,the members of the Top to Top Expedition visited Seward before heading across the Gulf to Juneau. They have been sailing around the world for more than 10 years and climbing the highest peaks on each of the seven continents to focus attention on Global Climate Change. They plan to climb Denali and they have six openings for that segment of their journey. Then they will transit the Northwest Passage from the Bering Sea to the Atlantic. The group especially enjoyed the Alaska SeaLife Center during their 30 hours in Seward. (5) On August 20 and 21 an appraiser inspected the dry dock and marina in order to establish new values for insurance purposes. Currently the Small Boat Harbor is valued at $17.5 Million. (6) PACAB made a good start on updating the Harbor Master Plan. (7) The Silver Salmon Derby was a great success thanks to the Chamber of commerce and many,many volunteers. D. Library: (1) The security camera system has arrived for the museum. (2) Tim Morrow and Kate Rullman have received their notary stamps and Kate is now certified to accept passport applications. Kate will be attending the Alaska Historical Society/Museums Alaska Joint Conference in Haines at the end of September. (3) There are three events coming up at the Library Museum before the end of the month that may be of interest: • "Slugs Forever"Book Signing—Saturday,August 24th 11am— 1pm release and signing party for Homer author Marianne Schlegelmilch's new book"Slugs Forever"with illustrations by Kenai artist Maggie Winston. Both the author and illustrator will be at Seward Community Library Museum on Saturday, August 24th from 11 am to 1 pm. All proceeds benefit the Kenai Peninsula Independent Living Center. A CD is included with the book. • Seward Founder's Day Celebration—Wednesday, August 28th,2pm—6pm. The Resurrection Bay Historical Society and the City of Seward would like to invite all residents to a public celebration event for. You're invited to a book • the 110th Anniversary of Seward's Founding. There is no charge for this event, and the Library Museum will be open throughout the day. The program will consist of special museum displays, movies, and presentations. Please bring your family and friends and join us for activities throughout the afternoon. Refreshments will be served. • Online Internet Safety for Parents Video Conference—Thursday,August 29th,4:30-5:30pm. Juneau Police Detective Shawn Phelps,will present tips parents should follow to keep their children safe online. Parents will learn why it is important to talk to their children about the risks involved when they use social networking websites,three simple steps they can take to protect themselves online and how to report any cases of suspected internet-related crime. Please call the Library Museum at 224-4082 if you have any questions about these events. (4) Library Use Statistics: July 2012 July 2013 Visits 7854 10488 Circulation 4223 4204 Computer Use 1184 1571 Wireless (1 hour 886 1561 sessions) Museum visits 636 929 Community 10 491 Use/Programs E.Public Works (1) Streets: Crews have prepped our lot in Forest Acres for snow storage. With the rain, we are trying to keep up with dirt road maintenance. Still looking for an Equipment Operator. (2) Shop: Personnel have been ordering chains, cutting edges, and other items preparing for winter. The brush whacker that is powered and operated on the grader is undergoing a major overhaul. It is old and a challenge to get parts for. A new one is between $40,000 - $75,000. The Crew has done several brake jobs,ball joints, etc. on various vehicles. (3) Water/Wastewater: • Alaska Rural Association visited and conducted a sanitary survey of Town and SMIC Water Systems. Their report will be back in a week or two. 2 /D/4---,•-_ Jr r,_ -{- :; ;1_) 3, 2.9-)9(/ 'c----e7-,v 1- 0 ,t .i.0 i L • Staff assisted the Park Service in the Harbor hooking up to gravity sewer. , • Staff has been involved with attempting to fix leak in roof at City Hall. • Staff is doing final dirt work(fire hydrants,water service repairs,building maintenance items,yard 31 -- ---� maintenance) of the season. • Testing of both Wastewater Lagoons, and Water System testing is underway. 8 -- (4) Administrative: , • Working on renewal of Wastewater Discharge Permit at SMIC. The ADEC is proposing to make a major change that we do not feel is warranted. It is a$100,000 change, and would result in about • k $10,000- $15,000 a year in additional operating costs. Updates will come to council on this as the situation develops. • Submitted Municipal Matching Grant for Maple Street water/sewer. �' • Assisting with refurbishment of Annex(old Library) • Have Issued 148 digging/working in the R.O.W. permits. • Dairy Hill has been bid and Metco successful bidder but we may wait until April to start that portion C. of the project. 3 F. Parks and Recreation: ii. P (1) Admin: Internal ADA upgrade (priority list). Attraction Maps listing to Vendors and Chamber. (2) Park Maintenance & Campgrounds: Sidewalk repair(fixing cracks) at Kawabe Park, Obihiro Park Beautification Project is in the works and Campgrounds were busy for the Salmon Derby. (3) Parking: The closing weekend of the Salmon Derby featured our busiest Saturday of the summer. The boat launch ramps were active all morning and both the Northeast and Uplands. Parking Lots filled to capacity. We had to find overflow spots for truck&trailers. i (4) TYC: r TYC received a donation of pedometers from Healthy Futures for the Mileage Club program that will be starting next week. Children will be awarded foot shaped tokens to display on their shoes for different mile markers reached. TYC will forward data to Healthy Futures. Final push for Coupon Book fundraiser TYC to sing AK Flag Song at the Founder's Day celebration Wednesday, August 28th at 4pm (5) Sports&Rec: f AVTEC Gymnasium construction is complete and gymnasium is now open. Competitive Softball held the end-of-season tournament this past Sunday with Tony's taking the Gold. The Stylin' Stitches Youth Soccer League wrapped up the season on Wednesday. Over 80 kids, ages 3-13,participated in the soccer league this summer. Volunteer coaches: Jamie Fredrickson, Sean Williams, Kipp Dixon, Myla Liljemark, Amanda Adams, Stephanie Wright, Maria Jackson,Hana Stovall, and Cambria Robinson deserve special thanks for their hard work this season! THANK YOU also goes out to Stylin' Stitches for sponsoring the soccer league and providing the stylin'jerseys! Roller Skating is back, every Friday 5:30—7pm! WAREHOUSE PURCHASES Amount Comment Geotechnical Report for Ft. Ray Site $13,000 Original Building $145,500 R&M Steel Building Change#1 $4,914 Foundation Drawings, Insul. Upgrade Change#2 $121,600 Insulated Panels and Roof(R25, R38) Shipping for Building $27,979 Seattle to Seward, estimate Design site, Prepare Site, Construct Civil/Site Work, Found. $493,190 Foundation Expanded parking lot, per engineer's requirement (Change Order#1 was for Change#2 $28,750 in-floor heat,vetoed by Council) Change #3 Clear buried stumps, cost unknown Erection, design/install of heat& light $478,000 Change#1 $42,000 Architectural Services Roll-up doors $37,342 Allegrezza Door, installed Personnel Doors(SBS Quote) $10,750 (Only respondent) Lighting Package (Estimate) $4,000 Flourescent (Proposed) Heat(Estimate from internet) $4,000 Electric Dayton style Ceiling Mount (4) Total Commitment So Far $1,411,025 CotheL VT6/6t0 , -kJ, v 1 --, tolAlv- ( ,ft, w Vt-cOd� � ova 010 -o A-MIL \JAA-9 .., Idfit , Weekly Revenue Report *After Dates: 11-Aug Thru: 17-Aug Taxes Permits Camper Nights Sold Over/ *Camping *Mini-Park *Shower Sold $10.00 $15.00 $30.00 Short Revenue Revenue Revenue Sunday 11-Aug- 150 49 185 80 9 3,051.40 2,242.99 90.00 Monday 12-Aug- 145 62 104 82 20 2,037.38 2,299.07 118.25 Tuesday 13-Aug- 163 72 133 67 9 2,537.38 1,878.50 112.00 Wednesday 14-Aug- 164 72 157 55 2,873.83 1,542.06 140.00 Thursday 15-Aug- 181 71 162 77 10 2,934.58 2,158.88 170.00 Friday 16-Aug- 240 100 181 86 -3 3,471.96 2,411.21 124.00 Saturday 17-Aug- 191 74 125 249 21 2,443.93 6,981.31 240.00 Totals: 1234 500 1047 696 66.00 19,350.47 19,514.02 994.25 Total Camping Revenue 39,858.74 Report to City Council 26 August 2013 Seward Chamber of Commerce, CVS The AK Dept. of Fish & Game dumped some 214,444 Coho smolt into the Lagoon in June. These are the first Cohos reared in William Jack Hernandez Hatchery in Anchorage. As you might recall, the Chamber invested $25,000 for 50,000 smolt at Trail Lake Hatchery. These smolt will be released in 2014. If you haven't heard, the 58th annual Silver Salmon Derby was a huge success. Record number of participants, record number of big, fat Cohos turned in: 2257 totaling 21,164 lbs with an average weight almost 9.5 lbs. and up almost 7,000 lbs from last year. But wait, yes it gets better! Taro Rich was fishing on the Florette C when he landed the winning 21.25 Silver. Rich works for Crowley, he's a captain on the Tan'erliq, an escort tug out of Valdez! Great publicity for Seward on so many levels! After an informal discussion at the Derby booth with Dan Bosch its looking like we might be creating a lagoon dredging plan for this fall to make best use of the 10% Raw Fish Tax designated for fish restoration. The SSD committee meets later this month and will provide direction to staff on moving forward. An idea for the second phase or year two would be to then place a net pen in the lagoon, feeding the smolt while they're busy growing and imprinting. It's been a phenomenal summer and season for Seward. I'll be able to supply more specific data after I return from the Alaska Travel Industry Assoc. October conference in Sitka. I'll have our visitor numbers tallied too. Jill Missel is organizing the Marine Firefighting Symposium scheduled to take place in Seward on October 7 — 10. We are collaborating on a reception at the SeaLife Center and oh my goodness, another Pub Crawl! The tentative schedule looks like Monday evening — welcome reception, Tuesday will be classroom time, Wednesday fire-fighting across the bay at the AVTEC campus and Thursday simulated fires in or near the boat harbor. Jill is clearly excited about the enthusiasm she's received from our Harbormaster, AVTEC staff and others that she's spoken to about the symposium. Other conferences coming to Seward include — Association of Zoo Veterinary Technicians Conference, ASLC September 4 - 9, 2013 150 participants Institute of the North - Alaska Dialogue (please see the handout from Nils Andreassen) Their Goal: Develop criteria used to determine an effective use of State of Alaska resources to achieve stated (or potential) energy policy goals. September 13 - 15 Seward Windsong Lodge The 10th Annual Seward Music & Arts Festival Cruise Ship Terminal Sept 27 - 29 Marine Fire Fighters Symposium, AVTEC October 8 - 12, 2013 100 participants Chugach Alaska Corporation Annual Meeting October 18 & 19, AVTEC The August issue of Alaska Business Monthly is features the Sikuliaq, SMIC and Seward as a conference destination. Meet the Candidates Night will be hosted by the Chamber on Wednesday, Sept. 25th at 7:00 pm right here in Council Chambers - televised by GCI. This concludes my August report, thank you and good luck to you in the upcoming municipal elections. • /s /�3 City of Seward, Alaska Quarterly Budget Report For the Quarter ended June 30, 2013 We are pleased to provide this budget-to-actual report for the quarter ended June 30, 2013. This data is current as of August 21, 2013. The intent of this report is to provide transparent financial and budgetary information to the public and to present information in a format that combines narrative and graphical elements to make it easier to understand. The report includes the following components: 1) the narrative report explains the highlights of financial results for the General Fund; 2) cash balances in all City funds; 3) risk area assessment; and 4) detailed revenue and expenditure/expense reports. This monthly report includes data for the City's General Fund and the Harbor, SMIC, Electric, Water, Wastewater, and Parking Enterprise Funds. We welcome comments from the City Council or the public as to how we may improve this document to make it more useful for timely decision making. The following pages of this report contain information on the major sources of revenue for the General Fund, with a focus on providing historical perspective on the timing of revenues and the City's typical revenue cycle. Revenues are compared on a monthly basis over multiple years. Revenues are then compared according to major revenue category (taxes, licenses/permits, intergovernmental, charges for services, and miscellaneous) across years, to see whether major revenue sources are increasing or decreasing. And finally, year-to-date revenues are examined to predict whether we can expect to meet budgeted revenue goals. An analysis of expenditures demonstrates the typical pattern of spending during the year. For example, debt service payments are generally made semi-annually (June and October), snow removal costs are higher in the winter, and campgrounds and public works repairs and road maintenance gear up in the Spring. In this analysis, expenditures are compared on a monthly basis, and then by category, showing the trend in costs for each major category (salary, benefits, purchased services, supplies/maintenance, general and administrative,capital and debt, and other). The presentation of this financial information aims to meet the requirements for financial reporting as defined by the Seward City Council in Resolution 2008-59. If you have questions or require additional information,please feel free to contact finance director Kristin Erchinger at(907)224-4064, or by e-mail at kerchinger@cityofseward.net. June 2013 Financials as of 8/21/13 Page 1 GENERAL FUND Analysis of All Revenue Sources Graph 1 : Revenue Comparison by Month 12.000 -- At June.2013.Revenues are 2.08%higher than the same 10,000period in the prioryear.and are at 28.3%of annual budget. -- 8.000 - - -- E. 6.000 r9 r 4.000 _ - 2.000 rth,ll s 1T11 11 r r -r "r l r r r r Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 112007 0 2008 1112009 ■2010 ■2011 ■2012 ■2013 The above graph presents the monthly distribution of all revenues of the General Fund, which includes Taxes, Charges for Services, Intergovernmental, Licenses/Permits, and Miscellaneous. The graph highlights the revenue cycle of the General Fund and demonstrates that the majority of General Fund revenues are collected in the second half of the year. Revenue Highlights: Revenues are higher in 2013 through June than in 2012 by $58,914 (2.08%) due to the following: 1) the receipt of some State payments (revenue sharing) earlier in 2013 than in 2012, resulting in intergovernmental revenues higher by $33,194; 2) higher sales tax revenues by$45,069; 3) higher building permit revenues by $41,007; and 4) a difference in timing of the allocation of interest earnings, resulting in higher investment earnings by $18,004. A number of revenues are lower relative to 2012, including personal property tax (lower by $16,853 likely due to timing of remittance); the timing of some State revenues received later than in the prior year (jail contract -$11,395; KPB dispatching-$25,200) and lower project management fees (-$12,597). The following graph aggregates revenues into primary categories. This graph reflects revenues through June for the current year and multiple prior years. General Fund revenues come primarily from Taxes, Charges for Services, and Intergovernmental Revenues, in that order. This graph shows that through June, revenues are higher in 2013 than in the prior year for all categories except charges for services. June 2013 Financials as of 8/21/13 Page 2 The reduction in charges for services is primarily due to a reduction in municipal building rent payments of-$55,725 due only to the later timing of payment by the State. We do not anticipate a reduction in the amount of municipal building rent revenue for the year compared with the prior year. Graph 3 - Revenue Comparison by Category -Through June 1,600 _. 1,400 1,200 ccs I' 1,000 o - H 800 I _ : 600 ' -0. I 400 ' ' — I a 200 s • ni t .• iii Taxes License/Permits Intergovernment Charges for Misc. Services •2007 a 2008 ■2009 0 2010 ' 2011 •2012 '2013 The graph below shows the percentage of annual revenues which have been generated within the first six months of the calendar year, relative to the total revenues for the year. It would appear in comparison to prior years, that the annual revenue budget is reasonable and at this time, there is no reason to expect that we will not meet overall budgetary targets in the General Fund. Graph 2 -Revenue through June as % of Annual Total 12,000 7 0 AMP' � fw 03,7 2% ❑ 27.2°l° 0 28.3% 10,000 • Adimpr ,. i1 �000 1 1 1 1 I1 1 I I cv1 _ 7,305 _ 8,251 7,270 7,607 7,593 7,318 8000 6,853 000 1 2,000 3,292 2,506 2,830 2,899 2,846 2,835 2,894 i 0 � Y ) 2007 2008 2009 2010 2011 2012 2013 E Revenue thru June 50% 0 Revenue after June ❑Remaining Budget 0 June as%of Annual total June 2013 Financials as of 8/21/13 Page 3 I t The administration will come before the City Council before year-end with a request for an increase in budgeted revenues to account for the State of Alaska's payments on-behalf of the City of Seward to cover the cost of retirement benefits above the 22% cap on employer contribution rates. Between January 1 and June 30, 2013, the State's contributions on-behalf of the City of Seward into the Public Employees Retirement System amounted to $363,320 (or $137,793 for post-employment healthcare costs and $225,527 for pension). This is based on the FY13 Alaska Retirement Management Board adopted PERS contribution rate of 35.84%, where the City of Seward contributes 22% of total payroll toward PERS, and the State picks up the remaining 13.84%. In addition to this budget adjustment, we will request another budget amendment at year-end to account for the State's contributions on-behalf of the City from July 1 through December 31, 2013. These budgeted revenues will be exactly offset by a requested increase in budgeted expenditures allocated among all departments, so that actual revenues and expenditures associated with the State's on-behalf PERS contributions will be equal to budgeted revenues and expenditures. Sales Tax Sales tax collections (which are not the same as taxable sales) through June are 4.4% higher than the same period last year, equal to an increase in revenues of$45,069. However, to confirm whether these higher collections are the result of higher taxable sales reported to the Borough, we must await final quarterly sales tax data from the Borough. It is not unusual for the City's collections of sales tax to be inconsistent with the Borough's reports of taxable sales, since our collections are affected by late payments, the difference in timing between the Borough's collections and the City's receipt of sales tax, tax appeals, etc. The following table shows Seward's taxable sales by quarter, as published by the Kenai Peninsula Borough: Taxable Sales by Quarter 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Annual Total 2008 11,342,854 30,134,160 50,176,796 13,079,235 ' 104,733,045 2009 10,693,048 26,493,149 41,182,402 12,481,844 ' 90,850,443 2010 11,213,031 27,809,429 45,089,653 12,972,721 ' 97,084,834 2011 11,882,611 29,884,705 48,344,750 13,613,551 " 103,725,617 2012 13,117,251 31,352,863 49,460,679 14,481,997 ' 108,412,790 2013 13,033,425 13,033,425 June 2013 Financials as of 8/21/13 Page 4 The same information is presented graphically, as follows: 60,000,000 Taxable Sales by Quarter 50,000,000 2008 40,000,000 "; 2009 w 30,000,000 ■2010 *2011 20,000,000 ■2012 11 10,000,000 1 ■2013 1st Qtr I 2nd Qtr 3rd Qtr 4th Qtr The Borough reports that during the first quarter of 2013, Seward's taxable sales are down 0.64% from the prior year. Anecdotal reports of summer activity since that time suggest that taxable sales will be up from the previous year. Second quarter taxable sales information is expected from the Borough by the end of August. Since the economic downturn of 2009,taxable sales rebounded 19.3%between 2009 and 2012. The 2013 General Fund budget was prepared based on an anticipated increase in sales tax revenue of 1.41% (to a total budget of$4,248,066) compared to actual 2012 sales tax revenue ($4,189,330). To reach budget requires an increase in sales tax revenues of$58,736 over 2012, or an increase in taxable sales of$1,468,400. June 2013 Financials as of 8/21/13 Page 5 f 1 GENERAL FUND Analysis of Expenditures The graph below depicts the typical spending pattern of the General Fund. Spending in the General Fund is fairly equally distributed across the year, although slightly less in the early months of the year. Expenditures tend to rise during the summer due to road repairs and parks and campground operations and then again at year-end due to snow removal operations. In the past three years adjustments have also been made to account for the State's contributions to PERS on behalf of the City in July and again in December. During the current year, Snow & Ice department expenditures are already at 70%, but that represents a reduction from the prior year of$62,000 through June. Graph 4 shows that compared to the prior year, overall costs are higher in the General Fund through June by $47,279 or 0.99%. Higher costs are particularly seen in general & administrative ($77,758), capital outlay ($46,300), and salaries & benefits ($26,369), while lower costs are in purchased services (-$102,519) and supplies/maintenance (-$6,828). Capital expenditures in 2013 include bond payments for the new library/museum. With the exception of Snow & Ice and Contributions, most departments are still within 50% of their anticipated spending levels through June. Graph 4: Expenditure Comparison (by Month) Through June 12,000 10,000 8,000 -- �, r1 6,000 1111 111 1111 4,000 2,000 - 1 [1.11 .111 1l i 1 I JiliLilUl Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 02007 02008 62009 02010 •2011 •2012 is 2013 June 2013 Financials as of 8/21/13 Page 6 Graph 5 below shows that compared with 2012, costs are higher in nearly all categories through June, with the exception of Purchased Services and Supplies and Maintenance. . Graph 5-Expenditure Comparison(by Category)Through June 2,000 1,800 — 1,600 — _ .6A 1,400 i 1,200 — t_i z J 2 1,000 — 800 — 600 — __ 400 — — i 200 — lift DI641_,_ 1:11IL illf _i____ I Salaries Benefits Purchased Supplies& General& Capital& Other Services Maint. Admin. Debt •2007 02008 ■2009 02010 a 2011 •2012 ■2013 Graph 6 below shows that expenditures through June 2013 are nearly even with prior year spending levels and represent 47% of the annual budget. Graph 6-Expenditures through June as%of Annual Total Unexpended Thousands Appropriations 12000 38% 43% c %t-o l / 1 10000 47% 49" 42% / / _ 8000 45% 46% rl - - - - 6,133 5,361y 5,479 6,252 5,644 5,344 -4,754 6000 1 -4,669 _- — IN 4,73� I - gill 7- /- /--�/ --J ^ 4000 - 1 / 2000 - 3,171_: 3,26- 3,371 13,828 4,166 4,334 -4,296 4,517 -4,45' 4,80' 4,85 - 0 4= / 1 ——� - ,7 — T 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 El Expend.Thru June O Post-June Expenditures 0 Remaining Budget 0%of Annual June 2013 Financials as of 8/21/13 Page 7 Overall for the year, General Fund expenditures for 2013 are budgeted at $10,399,837, which is less than the final 2012 budget by $317,900 or 2.97%. However, given that 2012 actual expenditures finished the year at $10,165,422, the 2013 budget represents an increase over 2012 actuals, by ($234,415) or (2.3%). This is nearly equal to the new library/museum bond debt payments of$244,400, and does not include the additional expenditures related to the State's payments on-behalf of the City for retirement system contributions. June 2013 Financials as of 8/21/13 Page 8 CITY OF SEWARD Monthly Budget Report General Fund Revenue Detail by Line Item 2012 2013 2013 Bud to Act Dept GL Sub Account Name Thru 6/12 Thru 6/13 Variance Budget Variance % Change Department: General 0000 4110 0100 Real Property Ta $ 10,355 $ 5,328 $ (5,028) $ 732,871 $ (727,543) (99.3)% 0000 4110 0200 Personl Property. 6,279 (5,367) (11,646) 250,000 (255,367) (102.1) 0000 4110 0210 Vehicle Regist. 10,671 10,492 (179) 28,000 (17,508) (62.5) 0000 4120 0100 City Sales Tax 1,012,493 1,057,562 45,069 4,248,066 (3,190,504) (75.1) 0000 4130 0300 Hotel/Motel Room 21,381 27,248 5,867 350,000 (322,752) (92.2) 0000 4190 0100 Tax Pen/Interest 691 1,276 585 1,400 (124) (8.9) 0000 4230 0100 Taxi Permits 480 665 185 1,000 (335) (33.5) 0000 4230 0200 Building Permits 33,748 74,756 41,007 40,000 34,756 86.9 0000 4230 0300 Dog Licenses 445 310 (135) 775 (465) (60.0) 0000 4230 0400 DMV- Drivers Lic 11,288 10,203 (1,085) 26,000 (15,798) (60.8) 0000 4230 0401 DMV - Motor Vehi 31,910 29,290 (2,620) 70,000 (40,710) (58.2) 0000 4230 0500 Misc Permit 265 1,085 820 4,400 (3,315) (75.3) 0000 4230 0600 Business License 12,060 9,660 (2,400) 20,500 (10,840) (52.9) 0000 4330 0175 PILT-AK Sealife 2,548 3,429 881 75,000 (71,571) (95.4) 0000 4330 0900 P.I.L.T. - Other 1,055 - (1,055) - - - 0000 4350 0110 Alaska Liquor Ta 14,200 9,550 (4,650) 16,000 (6,450) (40.3) 0000 4350 0130 Alaska Raw Fish - - - 520,000 (520,000) (100.0) 0000 4350 0131 Fish Res.Landing 5,736 4,169 (1,568) - 4,169 - 0000 4350 0140 Revenue Sharing- - 96,914 96,914 220,000 (123,086) (55.9) 0000 4350 0170 Jail Contract 289,395 278,000 (11,395) 745,470 (467,470) (62.7) 0000 4350 0180 Dispatch Contrac 24,250 24,250 - 48,500 (24,250) (50.0) 0000 4350 0190 KPB 911 Dispatch 25,200 - (25,200) 49,680 (49,680) (100.0) 0000 4410 0110 Copying Charge 6,171 4,414 (1,757) 14,000 (9,586) (68.5) 0000 4410 0120 Sales Tax Credit 1,000 1,000 - 4,000 (3,000) (75.0) 0000 4410 0300 Zoning Fees 65 65 - 250 (185) (74.0) 0000 4410 0410 Project Manageme 15,323 2,726 (12,597) 30,000 (27,274) (90.9) 0000 4410 0470 Admin - SMIC 43,344 43,344 - 86,688 (43,344) (50.0) 0000 4410 0500 Admin - Harbor 162,398 162,398 - 324,795 (162,398) (50.0) 0000 4410 0501 Admin. - Parking 4,945 5,069 124 9,715 (4,647) (47.8) 0000 4410 0510 Admin - Electric 423,646 423,646 - 847,291 (423,645) (50.0) 0000 4410 0520 Admin - Water 116,872 116,872 - 233,744 (116,872) (50.0) 0000 4410 0530 Admin - Sewer 71,372 71,372 - 142,745 (71,373) (50.0) 0000 4410 0560 Admin - Jail 40,733 41,453 721 82,907 (41,454) (50.0) 0000 4420 0110 Misc. Dog Fees 935 1,190 256 2,200 (1,010) (45.9) 0000 4420 0250 Misc. Jail Reven 890 1,060 170 800 260 32.5 0000 4420 0400 Misc Dispatching 5,000 5,000 - 10,000 (5,000) (50.0) 0000 4430 0150 Shop Dept Work 0 1,435 1,015 (420) 2,200 (1,185) (53.9) 0000 4470 0010 P&R: Public Use 2,075 1,609 (466) 4,500 (2,891) (64.2) 0000 4470 0020 P&R: Punchcards 11,566 7,492 (4,074) 34,200 (26,708) (78.1) 0000 4470 0030 P&R: Class Regis 36,551 45,247 8,696 75,000 (29,753) (39.7) 0000 4470 0040 P&R: Facility Re 507 31 (476) 350 (319) (91.2) 0000 4470 0050 P&R: Tournaments 3,722 1,469 (2,253) 10,200 (8,731) (85.6) 0000 4470 0060 P&R: Special Eve 19,433 17,071 (2,362) 18,000 (929) (5.2) 0000 4470 0080 P&R: Shower Fees 3,815 5,828 2,013 11,000 (5,172) (47.0) 0000 4470 0100 P&R: Rock Wall F 591 164 (426) 5,000 (4,836) (96.7) 0000 4470 0110 P&R: Pavilion Fe 2,687 2,523 (164) 4,000 (1,477) (36.9) 0000 4470 0120 P&R: Camping Fee 89,047 98,799 9,752 261,000 (162,201) (62.1) 0000 4470 0121 Mini-Service Cam 85,897 85,785 (112) 225,000 (139,215) (61.9) 0000 4470 0122 Dump station fee - - - 20,000 (20,000) (100.0) CITY OF SEWARD Monthly Budget Report General Fund Revenue Detail by Line Item 2012 2013 2013 Bud to Act Dept GL Sub Account Name Thru 6/12 Thru 6/13 Variance Budget Variance % Change 0000 4470 0150 P&R: Misc. Incom $ 779 $ 153 $ (626) $ 1,700 $ (1,547) (91.0)°% 0000 4470 0160 P&R Work Order R 1,797 2,772 975 1,500 1,272 84.8 0000 4490 0100 Library Service 3,129 7,191 4,062 9,000 (1,809) (20.1) 0000 4490 0110 Library Circulat 1,518 3,152 1,634 6,800 (3,648) (53.7) 0000 4490 0120 Museum revenue - - - 10,000 (10,000) (100.0) 0000 4510 0000 Fines - General 1,662 4,277 2,615 12,000 (7,723) (64.4) 0000 4610 0010 GF Investment In 27,058 44,443 17,385 75,000 (30,557) (40.7) 0000 4610 0030 GF Interest on R 123 440 318 1,000 (560) (56.0) 0000 4610 0120 GF Penalty &Inte 431 732 301 15,000 (14,268) (95.1) 0000 4620 0100 GF Land Rent & L 24,100 24,100 - 50,325 (26,225) (52.1) 0000 4620 0160 Jail Facility Re 15,000 15,000 - 30,000 (15,000) (50.0) 0000 4620 0200 Municipal Bldg R 55,725 - (55,725) 60,000 (60,000) (100.0) 0000 4640 0100 Surplus Equipmen - 1 1 2,000 (1,999) (100.0) 0000 4680 0100 Federal Project 27,660 6,763 (20,897) - 6,763 - 0000 4680 0200 State Project Fu - - - 2,953 (2,953) (100.0) 0000 4680 0900 Spec.Proj .Other 10 - (10) 3,000 (3,000) (100.0) 0000 4690 0100 Garbage Contract 4,403 4,125 (278) 15,400 (11,275) (73.2) 0000 4690 0200 SVAC Maintenance - - - 2,400 (2,400) (100.0) 0000 4690 0500 City Clerk Fees 60 171 111 250 (79) (31.6) 0000 4690 0600 Coll./Doubtful A 367 579 212 1,000 (421) (42.1) 0000 4690 0900 Misc Service Fee - - - 150 (150) (100.0) 0000 4690 0910 Vending Machine - - - 4,000 (4,000) (100.0) 0000 4880 0490 Misc. Revenue 6,842 (5,315) (12,157) 3,000 (8,315) (277.2) Total Revenues $ 2,835,132 $ 2,894,046 $ 58,914 $ 10213725 $(7,319,679) (71.7)% I City of Seward FUND: 101 - General Fund Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Salaries $ 1,684,642 $ 1,727,548 $ 42,907 $ 1,832,914 $ (105,365) $ 3,665,827 47.13 % Overtime 108,918 73,380 (35,538) 51,391 21,989 102,782 71.39 Standby Time 4,567 4,872 305 3,913 959 7,826 62.25 Unemployment Wage 3,984 3,319 (665) 9,106 (5,787) 18,212 18.22 Leave Time 179,159 185,878 6,720 192,628 (6,749) 385,255 48.25 In Lieu of FICA 6,913 7,064 152 2,470 4,595 4,939 143.03 Retirement Benefi 401,860 400,770 (1,091) 409,469 (8,699) 818,938 48.94 Health Insurance 639,635 646,466 6,830 649,558 (3,092) 1,299,116 49.76 Workers' Comp 56,598 61,484 4,886 87,443 (25,959) 174,886 35.16 Medicare 34,310 36,174 1,864 36,419 (245) 72,837 49.66 Total Persnl Sery 3,120,585 3,146,954 26,369 3,275,309 (128,355) 6,550,618 48.04 Audit 69,000 45,000 (24,000) 33,000 12,000 66,000 68.18 Advertising 9,129 8,728 (401) 16,163 (7,434) 32,325 27.00 Subscriptions/Due 8,653 10,265 1,611 11,465 (1,200) 22,930 44.76 Travel/Subsistenc 38,922 60,738 21,816 47,195 13,543 94,390 64.35 Communications 34,148 46,852 12,704 42,100 4,752 84,200 55.64 Education/Trainin 9,300 11,821 2,521 20,035 (8,214) 40,070 29.50 Legal 78,373 38,037 (40,337) 62,500 (24,463) 125,000 30.43 Legal Settlement 92,339 - (92,339) - - - - Other Spec Servic 10,749 11,480 731 9,500 1,980 19,000 60.42 Utilities 178,686 202,271 23,585 214,720 (12,449) 429,440 47.10 Heating Fuel 47,954 56,586 8,632 45,610 10,976 91,220 62.03 Rents & Leases 22,530 37,166 14,635 32,650 4,516 65,300 56.92 Insurance 86,716 92,401 5,686 111,805 (19,404) 223,610 41.32 CY Insurnce Recov - (4,769) (4,769) - (4,769) - - Maintenance & Rep 73,351 96,935 23,584 130,015 (33,080) 260,030 37.28 Contracted Servic 77,715 80,337 2,622 152,331 (71,994) 304,662 26.37 Library Bks.& Mat 13,285 8,861 (4,425) 12,000 (3,139) 24,000 36.92 Vehicle Supplies 898 1,459 561 4,105 (2,646) 8,210 17.77 Uniform Allowance 2,468 3,088 620 3,675 (587) 7,350 42.01 Operating Supplie 118,775 100,896 (17,879) 133,530 (32,634) 267,060 37.78 Gas & Lube 85,844 63,989 (21,855) 50,400 13,589 100,800 63.48 Equip,Furn,Tools 16,179 23,381 7,202 36,322 (12,941) 72,643 32.19 Safety Equip/Supp 2,890 4,068 1,178 7,268 (3,200) 14,535 27.99 Janitorial Suppli 2,777 6,963 4,186 6,200 763 12,400 56.15 Inmate Meals 1,620 4,383 2,763 7,000 (2,617) 14,000 31.31 Postage/Misc.Frei 13,299 14,875 1,575 20,703 (5,828) 41,405 35.92 Equipment Rental 9,038 9,142 104 26,059 (16,917) 52,118 17.54 Motor Pool Rent 125,025 160,124 35,099 125,000 35,124 249,999 64.05 Sister City Progr 2,000 2,000 - 3,250 (1,250) 6,500 30.77 Municipal Lobby F 87,132 89,323 2,190 78,500 10,823 157,000 56.89 Contributions 132,099 182,420 50,321 127,500 54,920 255,000 71.54 Bad Debt Expense - - - 1,000 (1,000) 2,000 - City of Seward FUND: 101 - General Fund Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Genl Govt Admin F $ 40,733 $ 41,453 $ 721 $ 41,454 $ - $ 82,907 50.00 % Contingency 7,439 6,486 (953) 7,000 (514) 14,000 46.33 Elections 19 - (19) 2,000 (2,000) 4,000 - Promotion 2,662 1,075 (1,587) 12,500 (11,425) 25,000 4.30 Vol Fireman Stipe 11,667 11,667 - 10,000 1,667 20,000 58.33 Bank,credit card 3,758 4,531 773 4,500 31 9,000 50.34 Misc. Expenses 30,692 17,041 (13,651) 24,863 (7,821) 49,725 34.27 Principal 62,525 65,807 3,283 130,796 (64,989) 261,592 25.16 Interest Expense 73,501 79,700 6,199 114,149 (34,449) 228,298 34.91 Buildings - 7,919 7,919 - 7,919 - - Capital Equipment - - - 2,500 (2,500) 5,000 - Misc. Programs 630 934 304 3,250 (2,316) 6,500 14.37 Total Expenses $ 4,805,107 $ 4,852,386 $ 47,279 $ 5,199,918 $ (347,533) $ 10,399,837 46.66 % I FUND: 101 - General Fund DEPT: 1110 - Mayor and Council Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 13,500 $ 13,500 $ - $ 9,225 $ 4,275 $ 18,450 73.17 5060 Retirement Benefi 253 146 (107) 90 57 179 81.71 5080 Workers' Comp 81 123 42 106 17 212 57.95 5090 Medicare 921 921 - 630 292 1,259 73.17 14,755 14,690 (65) 10,050 4,640 20,100 73.09 5110 Audit 69,000 45,000 (24,000) 33,000 12,000 66,000 68.18 5120 Advertising 6,642 4,873 (1,769) 11,000 (6,127) 22,000 22.15 5130 Subscriptions/Due 3,134 3,225 91 1,800 1,425 3,600 89.59 5140 Travel/Subsistenc 6,217 7,694 1,476 10,000 (2,306) 20,000 38.47 5150 Communications 1,417 1,485 67 2,000 (515) 4,000 37.11 5160 Education/Trainin 1,060 - (1,060) 750 (750) 1,500 - 5370 Insurance 546 217 (328) 450 (233) 900 24.14 5440 Operating Supplie 5,257 1,869 (3,389) 4,500 (2,631) 9,000 20.76 5460 Equip,Furn,Tools - 111 111 750 (639) 1,500 7.42 5490 Postage/Misc.Frei 570 455 (115) 900 (445) 1,800 25.27 5560 Sister City Progr 2,000 2,000 - 3,250 (1,250) 6,500 30.77 5570 Municipal Lobby F 87,132 89,323 2,190 78,500 10,823 157,000 56.89 5690 Contingency 2,500 2,500 - 1,500 1,000 3,000 83.33 5730 Promotion 2,349 950 (1,400) 12,500 (11,550) 25,000 3.80 Total Expenses $ 202,580 $ 174,391 $ (28,189) $ 170,950 $ 3,441 $ 341,900 51.01 FUND: 101 - General Fund DEPT: 1111 - Legislative - Boards & Commissions Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 16,100 $ 16,073 $ (28) $ 9,073 $ 7,000 $ 18,145 88.58 5040 Leave Time 917 - (917) 970 (970) 1,940 - 5060 Retirement Benefi 1,727 1,389 (338) 694 695 1,388 100.09 5070 Health Insurance 7,232 6,625 (607) 3,498 3,128 6,995 94.72 5080 Workers' Comp 130 146 16 105 42 209 69.97 5090 Medicare 233 233 - 139 95 277 84.12 26,340 24,467 (1,874) 14,477 9,990 28,954 84.50 5130 Subscriptions/Due 80 140 60 500 (360) 1,000 14.00 5140 Travel/Subsistenc 590 495 (95) 1,250 (755) 2,500 19.80 5160 Education/Trainin - - - 250 (250) 500 - 5370 Insurance 249 310 61 350 (40) 700 44.31 5440 Operating Supplie 885 368 (518) 1,000 (632) 2,000 18.39 5490 Postage/Misc.Frei 5 5 - - 5 - - Total Expenses $ 28,150 $ 25,785 $ (2,365) $ 17,827 $ 7,958 $ 35,654 72.32 FUND: 101 - General Fund DEPT: 1115 - General Fund Legal Line item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5130 Subscriptions/Due $ - $ 60 $ 60 $ - $ 60 $ - - 5140 Travel/Subsistenc 799 791 (8) - 791 - - 5170 Legal 78,373 38,037 (40,337) 62,500 (24,463) 125,000 30.43 5171 Legal Settlement 92,339 - (92,339) - - - - Total Expenses $ 171,512 $ 38,888 $ (132,624) $ 62,500 $ (23,612) $ 125,000 31.11 FUND: 101 - General Fund DEPT: 1120 - City Manager Line Item Expenditure Summary by Fund Through June, 50e of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 117,461 $ 112,228 $ (5,233) $ 114,507 $ (2,279) $ 229,014 49.00 5040 Leave Time 11,381 12,078 697 12,669 (590) 25,337 47.67 5060 Retirement Benefi 13,467 10,264 (3,204) 7,787 2,477 15,574 65.90 5070 Health Insurance 34,922 35,209 287 32,663 2,547 65,325 53.90 5080 Workers' Comp 1,044 971 (73) 1,724 (754) 3,449 28.15 5090 Medicare 1,744 1,723 (21) 1,736 (13) 3,472 49.63 180,020 172,473 (7,547) 171,085 1,388 342,171 50.41 5120 Advertising - 60 60 250 (190) 500 12.00 5130 Subscriptions/Due 1,515 1,050 (465) 250 800 500 210.00 5140 Travel/Subsistenc 10,683 13,840 3,158 8,000 5,840 16,000 86.50 5150 Communications 1,680 1,657 (23) 1,500 157 3,000 55.23 5160 Education/Trainin 57 - (57) 750 (750) 1,500 - 5310 Utilities 775 2,907 2,132 63 2,844 126 2313.47 5370 Insurance 2,153 2,406 254 3,500 (1,094) 7,000 34.38 5380 Maintenance & Rep 254 - (254) 250 (250) 500 - 5390 Contracted Servic - 12 12 2,500 (2,488) 5,000 0.24 5440 Operating Supplie 2,218 1,062 (1,156) 4,100 (3,038) 8,200 12.95 5450 Gas & Lube 218 386 168 500 (114) 1,000 38.55 5460 Equip,Furn,Tools - 400 400 500 (100) 1,000 40.00 5490 Postage/Misc.Frei 38 18 (20) 250 (232) 500 3.54 5690 Contingency 4,939 3,986 (953) 5,500 (1,514) 11,000 36.24 5730 Promotion 313 - (313) - - - - 5790 Misc. Expenses 2,912 323 (2,589) 500 (177) 1,000 32.30 Total Expenses $ 207,773 $ 200,580 $ (7,194) $ 199,498 $ 1,081 $ 398,997 50.27 f $ FUND: 101 - General Fund DEPT: 1121 - Management Information Systems Dept. Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 63,245 $ 62,985 $ (260) $ 66,886 $ (3,900) $ 133,771 47.08 5020 Overtime 241 811 570 2,067 (1,255) 4,133 19.63 5040 Leave Time 7,551 7,612 61 8,104 (492) 16,208 46.97 5060 Retirement Benefi 7,418 5,754 (1,663) 5,300 454 10,600 54.28 5070 Health Insurance 19,262 20,127 865 20,078 49 40,155 50.12 5080 Workers' Comp 485 558 74 982 (424) 1,964 28.43 5090 Medicare 1,000 1,018 18 1,059 (41) 2,117 48.07 99,201 98,866 (336) 104,474 (5,608) 208,948 47.32 5120 Advertising - - - 250 (250) 500 - 5130 Subscriptions/Due - 1,195 1,195 250 945 500 239.00 5140 Travel/Subsistenc 876 598 (278) 1,250 (652) 2,500 23.90 5150 Communications 1,605 1,777 172 2,000 (223) 4,000 44.43 5160 Education/Trainin - - - 2,500 (2,500) 5,000 - 5370 Insurance 1,263 1,231 (32) 1,700 (469) 3,400 36.20 5380 Maintenance & Rep - - - 2,500 (2,500) 5,000 - 5390 Contracted Servic - - - 2,750 (2,750) 5,500 - 5440 Operating Supplie 17,679 10,241 (7,439) 11,150 (909) 22,300 45.92 5460 Equip,Furn,Tools 2,119 2,517 398 2,500 17 5,000 50.34 5490 Postage/Misc.Frei 22 - (22) 250 (250) 500 - 5790 Misc. Expenses - - - 250 (250) 500 - Total Expenses $ 122,765 $ 116,424 $ (6,342) $ 131,824 $ (15,401) $ 263,648 44.16 FUND: 101 - General Fund DEPT: 1130 - City Clerk Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 62,051 $ 66,957 $ 4,907 $ 66,988 $ (31) $ 133,976 49.98 5020 Overtime 184 667 483 742 (74) 1,483 44.98 5040 Leave Time 7,054 7,340 286 7,049 291 14,098 52.06 5060 Retirement Benefi 7,218 5,738 (1,480) 5,037 701 10,074 56.96 5070 Health Insurance 28,893 30,190 1,297 30,117 73 60,233 50.12 5080 Workers' Comp 481 583 102 974 (391) 1,947 29.94 5090 Medicare 980 1,078 98 1,006 72 2,012 53.57 106,859 112,553 5,693 111,912 641 223,823 50.29 5120 Advertising - 164 164 - 164 - - 5130 Subscriptions/Due 280 333 53 275 58 550 60.55 5140 Travel/Subsistenc 2,398 3,502 1,104 2,500 1,002 5,000 70.04 5150 Communications 1 - (1) - - - - 5160 Education/Trainin 1,152 1,664 512 1,250 414 2,500 66.56 5370 Insurance 1,319 1,185 (134) 2,250 (1,065) 4,500 26.33 5390 Contracted Servic 1,500 2,325 825 9,500 (7,175) 19,000 12.24 5500 Equipment Rental - - - 3,300 (3,300) 6,600 - 5720 Elections 19 - (19) 2,000 (2,000) 4,000 - Total Expenses $ 113,528 $ 121,725 $ 8,197 $ 132,987 $ (11,262) $ 265,973 45.77 FUND: 101 - General Fund DEPT: 1140 - Finance Department Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 179,281 $ 182,076 $ 2,794 $ 187,116 $ (5,040) $ 374,231 48.65 5020 Overtime 3,952 1,980 (1,973) 1,804 176 3,607 54.88 5040 Leave Time 18,887 19,436 549 19,874 (438) 39,747 48.90 5060 Retirement Benefi 20,071 15,190 (4,882) 14,306 884 28,612 53.09 5070 Health Insurance 67,319 67,812 493 70,260 (2,448) 140,519 48.26 5080 Workers' Comp 1,426 1,593 167 2,752 (1,159) 5,503 28.94 5090 Medicare 2,725 2,747 22 2,858 (111) 5,715 48.06 293,662 290,832 (2,830) 298,967 (8,135) 597,935 48.64 5120 Advertising 232 86 (147) 250 (164) 500 17.17 5130 Subscriptions/Due 105 714 609 650 64 1,300 54.92 5140 Travel/Subsistenc 3,659 4,816 1,158 5,500 (684) 11,000 43.78 5150 Communications 2,527 2,689 163 2,550 139 5,100 52.73 5160 Education/Trainin 1,607 1,891 284 1,250 641 2,500 75.62 5370 Insurance 3,342 3,542 200 5,000 (1,458) 10,000 35.42 5380 Maintenance & Rep 14,314 25,846 11,532 18,000 7,846 36,000 71.80 5390 Contracted Servic - 2,327 ° 2,327 6,000 (3,673) 12,000 19.39 5400 Library Bks.& Mat - 193 193 - 193 - - 5440 Operating Supplie 8,670 8,738 68 6,500 2,238 13,000 67.22 5450 Gas & Lube - 372 372 - 372 - - 5460 Equip,Furn,Tools 439 - (439) 2,000 (2,000) 4,000 - 5465 Safety Equip/Supp - 43 43 - 43 - - 5490 Postage/Misc.Frei 1,019 1,433 415 1,500 (67) 3,000 47.78 5790 Misc. Expenses - 330 330 250 80 500 65.95 Total Expenses $ 329,576 $ 343,852 $ 14,276 $ 348,417 $ (4,565) $ 696,835 49.34 FUND: 101 - General Fund DEPT: 1150 - Community Development Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 38,357 $ 53,525 $ 15,168 $ 68,107 $ (14,581) $ 136,213 39.30 5040 Leave Time 4,618 5,554 936 4,725 829 9,449 58.78 5060 Retirement Benefi 4,517 4,515 (2) 5,197 (682) 10,394 43.44 5070 Health Insurance 15,631 18,545 2,914 23,752 (5,207) 47,504 39.04 5080 Workers' Comp 297 472 175 980 (508) 1,960 24.07 5090 Medicare 592 886 294 1,038 (152) 2,076 42.68 64,011 83,497 19,486 103,798 (20,301) 207,596 40.22 5120 Advertising 1,530 - (1,530) - - - - 5130 Subscriptions/Due 258 60 (198) - 60 - - 5140 Travel/Subsistenc 3,064 4,148 1,084 750 3,398 1,500 276.53 5150 Communications 1,064 1,177 114 1,500 (323) 3,000 39.24 5160 Education/Trainin - 185 185 1,250 (1,065) 2,500 7.40 5370 Insurance 1,341 922 (419) 1,700 (778) 3,400 27.12 5380 Maintenance & Rep 400 1,424 1,024 750 674 1,500 94.95 5390 Contracted Servic 2,886 5,100 2,214 21,092 (15,992) 42,184 12.09 5440 Operating Supplie 638 656 18 1,100 (444) 2,200 29.81 5460 Equip,Furn,Tools 408 566 158 2,000 (1,434) 4,000 14.15 5490 Postage/Misc.Frei 92 62 (30) 250 (188) 500 12.42 5500 Equipment Rental - - - 750 (750) 1,500 - 5790 Misc. Expenses - 285 285 500 (215) 1,000 28.50 Total Expenses $ 75,691 $ 98,082 $ 22,391 $ 135,440 $ (37,358) $ 270,880 36.21 FUND: 101 - General Fund DEPT: 1180 - General Services Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5120 Advertising $ - $ - $ - $ 1,000 $ (1,000) $ 2,000 - 5130 Subscriptions/Due 313 204 (109) 250 (46) 500 40.60 5140 Travel/Subsistent - 229 229 - 229 - - 5150 Communications 630 634 4 600 34 1,200 52.82 5310 Utilities - - - 2,350 (2,350) 4,700 5370 Insurance 211 58 (153) 405 (347) 810 7.15 5371 CY Insurnce Recov - (4,769) (4,769) - (4,769) - - 5380 Maintenance & Rep 22 5,108 5,085 1,550 3,558 3,100 164.76 5390 Contracted Servic - - - 2,500 (2,500) 5,000 - 5440 Operating Supplie (435) (702) (267) 4,000 (4,702) 8,000 (8.78) 5450 Gas & Lube 52 227 175 255 (28) 510 44.49 5460 Equip,Furn,Tools - - - 2,000 (2,000) 4,000 - 5465 Safety Equip/Supp 231 - (231) 800 (800) 1,600 - 5490 Postage/Misc.Frei 1,206 3,826 2,620 1,000 2,826 2,000 191.29 5530 Motor Pool Rent 1,859 1,859 - 1,859 - 3,717 50.00 5660 Bad Debt Expense - - - 1,000 (1,000) 2,000 - 5730 Promotion - 125 125 - 125 - - 5770 Bank,credit card 1,657 2,334 678 2,000 334 4,000 58.36 5790 Misc. Expenses 21,366 13,597 (7,769) - 13,597 - - Total Expenses $ 27,110 $ 22,728 $ (4,382) $ 21,569 $ 1,160 $ 43,137 52.69 FUND: 101 - General Fund DEPT: 1181 - General Services Copier Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5440 Operating Supplie $ 420 $ 305 $ (115) $ 600 $ (295) $ 1,200 25.41 5500 Equipment Rental 6,379 4,189 (2,190) 4,500 (311) 9,000 46.54 Total Expenses $ 6,798 $ 4,494 $ (2,305) $ 5,100 $ (606) $ 10,200 44.06 FUND: 101 - General Fund DEPT: 1190 - SVAC Expense Accumulation Line item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5190 Other Spec Servic $ 10,000 $ 10,000 $ - $ 5,000 $ 5,000 $ 10,000 100.00 5370 Insurance 1,591 1,592 1 1,600 (8) 3,200 49.74 5380 Maintenance & Rep - 606 606 600 6 1,200 50.52 5440 Operating Supplie - 1,080 1,080 - 1,080 - - 5450 Gas & Lube 814 1,377 564 750 627 1,500 91.82 5490 Postage/Misc.Frei - 59 59 100 (41) 200 29.27 Total Expenses $ 12,405 $ 14,714 $ 2,309 $ 8,050 $ 6,664 $ 16,100 91.39 FUND: 101 - General Fund DEPT: 1191 - Contributions Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5610 Contributions $ 132,099 $ 182,420 $ 50,321 $ 127,500 $ 54,920 $ 255,000 71.54 5790 Misc. Expenses - - - 18,710 (18,710) 37,420 - Total Expenses $ 132,099 $ 182,420 $ 50,321 $ 146,210 $ 36,210 $ 292,420 62.38 FUND: 101 - General Fund DEPT: 1210 - Police Department Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 413,422 $ 453,976 $ 40,555 $ 479,335 $ (25,358) $ 958,669 47.35 5020 Overtime 20,779 20,521 (258) 25,605 (5,084) 51,209 40.07 5030 Unemployment Wage 874 (200) (1,073) 3,106 (3,306) 6,212 (3.21) 5040 Leave Time 47,135 49,947 2,811 54,632 (4,685) 109,264 45.71 5060 Retirement Benefi 49,576 42,604 (6,972) 37,843 4,761 75,686 56.29 5070 Health Insurance 174,628 182,656 8,028 170,843 11,813 341,687 53.46 5080 Workers' Comp 13,395 15,749 2,353 25,721 (9,972) 51,442 30.61 5090 Medicare 10,992 10,364 (628) 10,692 (328) 21,383 48.47 730,801 775,617 44,816 807,776 (32,159) 1,615,552 48.01 5120 Advertising - 212 212 250 (38) 500 42.49 5130 Subscriptions/Due 1,159 1,040 (119) 4,750 (3,710) 9,500 10.95 5140 Travel/Subsistenc 2,670 13,223 10,554 7,000 6,223 14,000 94.45 5150 Communications 6,011 6,308 297 7,500 (1,192) 15,000 42.05 5160 Education/Trainin 1,685 4,345 2,660 2,250 2,095 4,500 96.56 5190 Other Spec Servic 1,287 1,040 (247) 1,250 (210) 2,500 41.60 5370 Insurance 37,943 32,159 (5,784) 30,500 1,659 61,000 52.72 5380 Maintenance & Rep 5,460 12,042 6,582 5,250 6,792 10,500 114.68 5390 Contracted Servic - - - 1,500 (1,500) 3,000 - 5430 Uniform Allowance 1,045 1,931 886 2,000 (69) 4,000 48.28 5440 Operating Supplie 3,820 5,954 2,134 7,500 (1,546) 15,000 39.70 5450 Gas & Lube 8,042 8,029 (13) 9,250 (1,221) 18,500 43.40 5460 Equip,Furn,Tools 2,313 273 (2,041) 3,000 (2,727) 6,000 4.54 5465 Safety Equip/Supp 39 - (39) 1,250 (1,250) 2,500 - 5490 Postage/Misc.Frei 678 1,062 383 1,250 (188) 2,500 42.47 5500 Equipment Rental 2,660 2,711 51 2,750 (39) 5,500 49.29 5530 Motor Pool Rent 16,522 16,522 - 16,522 - 33,044 50.00 5770 Bank,credit card 2,101 2,196 95 2,500 (304) 5,000 43.93 5790 Misc. Expenses 142 33 (109) 750 (717) 1,500 2.20 5990 Misc. Programs 630 677 47 2,250 (1,573) 4,500 15.05 Total Expenses $ 825,007 $ 885,376 $ 60,368 $ 917,048 $ (31,672) $ 1,834,096 48.27 FUND: 101 - General Fund DEPT: 1211 - Jail Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 124,759 $ 126,179 $ 1,420 $ 133,000 $ (6,821) $ 265,999 47.44 5020 Overtime 9,198 7,568 (1,630) 9,836 (2,268) 19,672 38.47 5040 Leave Time 13,603 14,836 1,232 15,268 (432) 30,536 48.58 5060 Retirement Benefi 15,209 13,172 (2,037) 10,924 2,248 21,848 60.29 5070 Health Insurance 56,513 59,505 2,993 60,134 (629) 120,268 49.48 5080 Workers' Comp 5,786 7,086 1,300 8,593 (1,508) 17,187 41.23 5090 Medicare 2,044 2,031 (13) 2,182 (151) 4,364 46.53 227,111 230,376 3,265 239,937 (9,561) 479,874 48.01 5120 Advertising - - - 250 (250) 500 - 5130 Subscriptions/Due 504 204 (300) 400 (196) 800 25.45 5140 Travel/Subsistenc 617 2,171 1,554 1,250 921 2,500 86.83 5150 Communications 1,688 1,650 (38) 1,500 150 3,000 55.00 5160 Education/Trainin 170 348 178 1,000 (652) 2,000 17.40 5360 Rents & Leases 15,000 15,000 - 15,000 - 30,000 50.00 5370 Insurance 2,487 10,447 7,960 9,250 1,197 18,500 56.47 5380 Maintenance & Rep 10 394 384 750 (356) 1,500 26.25 5390 Contracted Servic - - - 500 (500) 1,000 - 5430 Uniform Allowance 790 540 (249) 750 (210) 1,500 36.02 5440 Operating Supplie 1,948 2,309 361 3,250 (941) 6,500 35.52 5460 Equip,Furn,Tools 369 364 (5) 1,000 (636) 2,000 18.20 5470 Janitorial Suppli 1,436 858 (578) 750 108 1,500 57.20 5480 Inmate Meals 1,564 4,333 2,768 7,000 (2,667) 14,000 30.95 5490 Postage/Misc.Frei 539 305 (234) 750 (445) 1,500 20.33 5530 Motor Pool Rent 860 860 - 861 - 1,721 50.00 5670 Genl Govt Admin F 40,733 41,453 721 41,454 - 82,907 50.00 5790 Misc. Expenses 339 62 (277) 250 (188) 500 12.47 Total Expenses $ 296,164 $ 311,674 $ 15,510 $ 325,901 $ (14,227) $ 651,802 47.82 FUND: 101 - General Fund DEPT: 1212 - Animal Control Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5310 Utilities $ 2,889 $ 4,015 $ 1,125 $ 2,623 $ 1,392 $ 5,246 76.52 5330 Heating Fuel 337 - (337) 37 (37) 74 - 5370 Insurance 33 41 8 150 (109) 300 13.53 5380 Maintenance & Rep - - - 2,500 (2,500) 5,000 - 5390 Contracted Servic 28,601 28,601 - 28,601 - 57,202 50.00 5500 Equipment Rental - - - 250 (250) 500 - Total Expenses $ 31,860 $ 32,656 $ 796 $ 34,161 $ (1,505) $ 68,322 47.80 FUND: 101 - General Fund DEPT: 1220 - Fire Department Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 83,433 $ 82,204 $ (1,228) $ 86,882 $ (4,677) $ 173,763 47.31 5020 Overtime - 64 64 229 (165) 457 13.98 5040 Leave Time 10,166 10,584 418 8,581 2,003 17,162 61.67 5050 In Lieu of FICA 1,975 1,735 (240) - 1,735 - - 5060 Retirement Benefi 9,596 6,640 (2,956) 5,888 752 11,775 56.39 5070 Health Insurance 26,790 28,292 1,502 27,619 673 55,237 51.22 5080 Workers' Comp 7,067 7,615 548 8,578 (963) 17,156 44.39 5090 Medicare 651 702 52 1,176 (474) 2,352 29.87 139,677 137,836 (1,842) 138,951 (1,115) 277,902 49.60 5120 Advertising 266 393 128 250 143 500 78.65 5130 Subscriptions/Due 390 625 235 250 375 500 125.00 5140 Travel/Subsistenc 2,361 5,341 2,980 1,750 3,591 3,500 152.61 5150 Communications 2,684 2,770 85 4,500 (1,730) 9,000 30.77 5160 Education/Trainin 895 540 (355) 850 (310) 1,700 31.76 5310 Utilities 34,691 34,961 270 36,490 (1,529) 72,981 47.90 5330 Heating Fuel 10,194 8,700 (1,494) 6,262 2,438 12,524 69.47 5360 Rents & Leases 603 48 (555) 3,200 (3,152) 6,400 0.75 5370 Insurance 10,006 10,829 822 14,000 (3,171) 28,000 38.67 5380 Maintenance & Rep 272 2,475 2,203 6,000 (3,525) 12,000 20.63 5390 Contracted Servic - - - 1,000 (1,000) 2,000 - 5420 Vehicle Supplies 860 1,398 538 3,200 (1,802) 6,400 21.84 5430 Uniform Allowance - 140 140 425 (285) 850 16.47 5440 Operating Supplie 714 1,546 831 2,900 (1,354) 5,800 26.65 5450 Gas & Lube 4,084 3,393 (691) 3,500 (107) 7,000 48.47 5460 Equip,Furn,Tools 2,973 3,993 1,020 2,500 1,493 5,000 79.85 5465 Safety Equip/Supp 746 - (746) 1,750 (1,750) 3,500 - 5490 Postage/Misc.Frei 220 271 51 750 (479) 1,500 18.09 5500 Equipment Rental - 422 422 500 (78) 1,000 42.19 5530 Motor Pool Rent 19,964 55,088 35,124 19,964 35,124 39,928 137.97 5790 Misc. Expenses 84 - (84) - - - - Total Expenses $ 231,685 $ 270,768 $ 39,083 $ 248,992 $ 21,776 $ 497,985 54.37 FUND: 101 - General Fund DEPT: 1221 - Volunteer Training Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5080 Workers' Comp $ - $ - $ - $ 3,350 $ (3,350) $ 6,700 - - - 3,350 (3,350) 6,700 - 5130 Subscriptions/Due - 15 15 - 15 - - 5140 Travel/Subsistenc - 228 228 1,750 (1,522) 3,500 6.52 5160 Education/Trainin 579 255 (324) 1,750 (1,495) 3,500 7.29 5370 insurance - - - 2,000 (2,000) 4,000 - 5380 Maintenance & Rep 1,154 529 (625) 2,000 (1,471) 4,000 13.21 5390 Contracted Servic 498 - (498) 500 (500) 1,000 - 5430 Uniform Allowance 633 444 (189) 500 (56) 1,000 44.40 5440 Operating Supplie 1,707 1,691 (16) 1,500 191 3,000 56.38 5460 Equip,Furn,Tools 3,798 2,376 (1,422) 4,500 (2,124) 9,000 26.40 5490 Postage/Misc.Frei 220 550 330 400 150 800 68.79 5750 Vol Fireman Stipe 11,667 11,667 - 10,000 1,667 20,000 58.33 5790 Misc. Expenses 45 - (45) - - - - Total Expenses $ 20,299 $ 17,755 $ (2,544) $ 28,250 $ (10,495) $ 56,500 31.42 FUND: 101 - General Fund DEPT: 1222 - Emergency Preparedness Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5130 Subscriptions/Due $ 260 $ - $ (260) $ - $ - $ - - 5140 Travel/Subsistenc - 268 268 500 (232) 1,000 26.84 5150 Communications 199 295 95 1,000 (706) 2,000 14.72 5160 Education/Trainin - - - 500 (500) 1,000 - 5310 Utilities 939 891 (48) 838 53 1,676 53.16 5380 Maintenance & Rep - - - 250 (250) 500 - 5390 Contracted Servic 250 - (250) - - - - 5440 Operating Supplie 95 176 81 500 (324) 1,000 17.61 5460 Equip,Furn,Tools - - - 375 (375) 750 - 5490 Postage/Misc.Frei 18 26 9 - 26 - - Total Expenses $ 1,761 $ 1,656 $ (105) $ 3,963 $ (2,307) $ 7,926 20.90 FUND: 101 - General Fund DEPT: 1250 - Building Inspection Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 32,511 $ 30,797 $ (1,714) $ 34,132 $ (3,334) $ 68,263 45.12 5020 Overtime 63 559 496 76 483 152 367.59 5040 Leave Time 3,932 3,438 (494) 3,527 (89) 7,054 48.74 5060 Retirement Benefi 3,488 2,586 (902) 2,634 (47) 5,267 49.11 5070 Health Insurance 11,733 11,961 228 12,537 (576) 25,074 47.70 5080 Workers' Comp 256 275 19 500 (225) 1,001 27.51 5090 Medicare 483 502 19 526 (24) 1,052 47.71 52,467 50,119 (2,348) 53,931 (3,813) 107,863 46.47 5130 Subscriptions/Due 125 - (125) 100 (100) 200 - 5140 Travel/Subsistenc 1,030 2,180 1,150 1,000 1,180 2,000 109.00 5150 Communications 907 1,161 254 500 661 1,000 116.11 5160 Education/Trainin 410 385 (25) 1,000 (615) 2,000 19.25 5360 Rents & Leases 603 254 (349) 950 (696) 1,900 13.36 5370 Insurance 593 607 14 1,500 (893) 3,000 20.24 5380 Maintenance & Rep - - - 500 (500) 1,000 - 5430 Uniform Allowance - 32 32 - 32 - - 5440 Operating Supplie 17 337 320 750 (413) 1,500 22.46 5450 Gas & Lube 283 220 (63) 250 (30) 500 43.93 5460 Equip,Furn,Tools - 2,043 2,043 1,250 793 2,500 81.73 5490 Postage/Misc.Frei 7 31 25 250 (219) 500 6.29 5500 Equipment Rental - 422 422 1,000 (578) 2,000 21.10 5530 Motor Pool Rent 2,066 2,066 - 2,066 - 4,131 50.00 5790 Misc. Expenses - - - 250 (250) 500 - Total Expenses $ 58,507 $ 59,857 $ 1,349 $ 65,297 $ (5,440) $ 130,594 45.83 FUND: 101 - General Fund DEPT: 1310 - Street General Operations Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 62,406 $ 54,112 $ (8,294) $ 63,807 $ (9,695) $ 127,613 42.40 5020 Overtime 9,865 2,063 (7,803) 1,367 696 2,734 75.45 5022 Standby Time 1,809 - (1,809) - - - - 5040 Leave Time 7,430 8,876 1,446 10,504 (1,627) 21,007 42.25 5050 In Lieu of FICA 2,374 1,823 (551) 1,235 588 2,469 73.82 5060 Retirement Benefi 9,135 5,274 (3,861) 5,225 50 10,449 50.47 5070 Health Insurance 25,785 25,498 (287) 27,328 (1,830) 54,656 46.65 5080 Workers' Comp 4,980 4,216 (764) 6,267 (2,051) 12,533 33.64 5090 Medicare 702 612 (90) 524 88 1,047 58.42 124,486 102,473 (22,013) 116,254 (13,781) 232,509 44.07 5120 Advertising - 251 251 78 173 155 161.61 5130 Subscriptions/Due - - - 155 (155) 310 - 5140 Travel/Subsistenc 118 265 147 515 (250) 1,030 25.75 5150 Communications 153 399 247 1,063 (663) 2,125 18.80 5160 Education/Trainin - - - 750 (750) 1,500 - 5310 Utilities 53,694 55,752 2,059 49,860 5,892 99,720 55.91 5370 Insurance 7,589 7,390 (199) 10,000 (2,610) 20,000 36.95 5380 Maintenance & Rep 6,955 9,073 2,118 36,060 (26,987) 72,120 12.58 5390 Contracted Servic 123 1,870 1,747 10,303 (8,432) 20,605 9.08 5440 Operating Supplie 9,088 1,032 (8,056) 12,880 (11,848) 25,760 4.01 5450 Gas & Lube 61,634 42,059 (19,576) 25,000 17,059 50,000 84.12 5460 Equip,Furn,Tools 26 46 20 620 (574) 1,240 3.74 5465 Safety Equip/Supp 75 202 127 773 (571) 1,545 13.07 5490 Postage/Misc.Frei 350 215 (135) 2,575 (2,360) 5,150 4.18 5500 Equipment Rental - - - 515 (515) 1,030 - 5530 Motor Pool Rent 62,302 62,302 - 62,302 - 124,604 50.00 5790 Misc. Expenses 38 207 169 1,290 (1,083) 2,580 8.01 Total Expenses $ 326,632 $ 283,537 $ (43,094) $ 330,991 $ (47,454) $ 661,983 42.83 FUND: 101 - General Fund DEPT: 1314 - Snow & Ice Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 29,964 $ 32,309 $ 2,345 $ 26,901 $ 5,408 $ 53,802 60.05 5020 Overtime 56,198 27,106 (29,092) 5,500 21,606 11,000 246.42 5022 Standby Time 2,674 4,872 2,198 2,885 1,987 5,769 84.45 5030 Unemployment Wage - - - 250 (250) 500 - 5040 Leave Time 2,907 - (2,907) - - - - 5060 Retirement Benefi 8,974 4,699 (4,275) 2,849 1,850 5,698 82.47 5070 Health Insurance 15,752 11,093 (4,659) 5,619 5,474 11,239 98.70 5080 Workers' Comp 5,430 3,307 (2,123) 4,288 (981) 8,576 38.56 5090 Medicare 1,033 589 (444) 382 208 763 77.20 122,932 83,975 (38,957) 48,674 35,302 97,347 86.26 5120 Advertising - - - 210 (210) 420 - 5140 Travel/Subsistenc 1,037 - (1,037) 210 (210) 420 - 5160 Education/Trainin - - - 310 (310) 620 - 5330 Heating Fuel - 370 370 - 370 - - 5380 Maintenance & Rep 31,103 23,595 (7,508) 16,485 7,110 32,970 71.56 5390 Contracted Servic 5,160 2,318 (2,842) 3,090 (772) 6,180 37.51 5440 Operating Supplie 26,690 25,876 (815) 24,725 1,151 49,450 52.33 5450 Gas & Lube 4,862 1,230 (3,632) 1,288 (58) 2,575 47.75 5460 Equip,Furn,Tools - - - 210 (210) 420 - 5465 Safety Equip/Supp 290 - (290) 260 (260) 520 - 5490 Postage/Misc.Frei 3,525 1,377 (2,148) 1,545 (168) 3,090 44.58 5530 Motor Pool Rent 7,229 7,229 - 7,229 - 14,457 50.00 5790 Misc. Expenses 5,143 - (5,143) 258 (258) 515 - Total Expenses $ 207,970 $ 145,969 $ (62,001) $ 104,492 $ 41,477 $ 208,984 69.85 FUND: 101 - General Fund DEPT: 1340 - City Shop Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 67,561 $ 75,057 $ 7,496 $ 65,340 $ 9,717 $ 130,680 57.44 5020 Overtime 5,013 84 (4,929) 2,799 (2,715) 5,598 1.50 5022 Standby Time 84 - (84) 1,029 (1,029) 2,057 - 5030 Unemployment Wage 33 - (33) - - - - 5040 Leave Time 8,479 12,670 4,191 7,366 5,304 14,731 86.01 5050 In Lieu of FICA 504 1,714 1,210 247 1,467 494 347.05 5060 Retirement Benefi 8,135 6,056 (2,079) 5,452 604 10,904 55.54 5070 Health Insurance 23,693 25,105 1,412 23,698 1,407 47,396 52.97 5080 Workers' Comp 4,454 5,202 748 5,821 (619) 11,642 44.68 5090 Medicare 883 964 82 907 58 1,813 53.20 118,839 126,852 8,013 112,658 14,194 225,315 56.30 5130 Subscriptions/Due - - - 500 (500) 1,000 - 5140 Travel/Subsistenc 215 - (215) 645 (645) 1,290 - 5150 Communications 3,002 3,345 344 4,000 (655) 8,000 41.82 5160 Education/Trainin - 199 199 1,000 (801) 2,000 9.95 5310 Utilities 19,471 19,703 232 18,702 1,001 37,404 52.68 5330 Heating Fuel 12,584 12,813 229 15,355 (2,541) 30,710 41.72 5370 Insurance 2,315 2,422 107 4,000 (1,578) 8,000 30.27 5380 Maintenance & Rep 503 596 93 8,245 (7,649) 16,490 3.62 5390 Contracted Servic 3,148 2,842 (306) 1,030 1,812 2,060 137.94 5440 Operating Supplie 13,552 11,723 (1,829) 14,425 (2,702) 28,850 40.63 5450 Gas & Lube 790 937 147 2,500 (1,563) 5,000 18.74 5460 Equip,Furn,Tools 2,017 6,279 4,263 4,640 1,639 9,280 67.67 5465 Safety Equip/Supp 834 260 (574) 1,030 (770) 2,060 12.62 5480 Inmate Meals 56 51 (5) - 51 - - 5490 Postage/Misc.Frei 307 267 (40) 773 (505) 1,545 17.31 5530 Motor Pool Rent 2,495 2,495 - 2,496 - 4,991 50.00 5790 Misc. Expenses 101 180 79 515 (335) 1,030 17.51 Total Expenses $ 180,229 $ 190,965 $ 10,736 $ 192,512 $ (1,547) $ 385,025 49.60 FUND: 101 - General Fund DEPT: 1350 - Municipal Building Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 39,790 $ 24,382 $ (15,408) $ 40,191 $ (15,809) $ 80,381 30.33 5020 Overtime 350 3,944 3,595 761 3,183 1,522 259.15 5040 Leave Time 4,771 4,433 (339) 4,870 (437) 9,739 45.52 5060 Retirement Benefi 4,221 3,094 (1,127) 3,150 (56) 6,300 49.11 5070 Health Insurance 19,262 20,127 865 20,078 49 40,155 50.12 5080 Workers' Comp 2,757 2,415 (343) 5,080 (2,665) 10,159 23.77 5090 Medicare 595 918 323 629 289 1,258 72.94 71,746 59,311 (12,434) 74,757 (15,446) 149,514 39.67 5120 Advertising - 177 177 - 177 - - 5150 Communications 256 265 8 388 (123) 775 34.16 5310 Utilities 34,037 33,035 (1,002) 33,918 (883) 67,836 48.70 5330 Heating Fuel 14,405 12,156 (2,249) 10,114 2,042 20,228 60.09 5370 Insurance 2,072 3,865 1,794 3,500 365 7,000 55.22 5380 Maintenance & Rep 5,826 5,495 (331) 13,000 (7,505) 26,000 21.14 5390 Contracted Servic 6,000 126 (5,874) 4,150 (4,024) 8,300 1.52 5440 Operating Supplie 5,446 1,200 (4,246) 4,750 (3,550) 9,500 12.63 5450 Gas & Lube 50 147 97 258 (111) 515 28.52 5460 Equip,Furn,Tools - - - 500 (500) 1,000 - 5465 Safety Equip/Supp - - - 130 (130) 260 - 5490 Postage/Misc.Frei 506 309 (197) 310 (1) 620 49.77 5790 Misc. Expenses 2 128 125 130 (2) 260 49.15 Total Expenses $ 140,346 $ 116,214 $ (24,131) $ 145,904 $ (29,690) $ 291,808 39.83 FUND: 101 - General Fund DEPT: 1351 - Community Center Expense Line Item Expenditure Summary by Fund Through June, 50e of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5310 Utilities $ 3,780 $ 4,177 $ 397 $ 3,913 $ 265 $ 7,825 53.39 5330 Heating Fuel 2,122 1,646 (477) 1,938 (292) 3,877 42.46 5370 Insurance 846 1,618 772 2,000 (382) 4,000 40.44 5380 Maintenance & Rep 330 - (330) 2,500 (2,500) 5,000 - 5390 Contracted Servic 5,032 - (5,032) 2,500 (2,500) 5,000 - 5440 Operating Supplie 2,195 86 (2,108) 250 (164) 500 17.28 5465 Safety Equip/Supp - 1,579 1,579 - 1,579 - - 5790 Misc. Expenses - - - 250 (250) 500 - Total Expenses $ 14,305 $ 9,106 $ (5,199) $ 13,351 $ (4,244) $ 26,702 34.10 FUND: 101 - General Fund DEPT: 1352 - City Hall Annex (old library) Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5310 Utilities $ - $ 1,683 $ 1,683 $ - $ 1,683 $ - - 5330 Heating Fuel - 2,853 2,853 - 2,853 - - 5390 Contracted Servic - 2,406 2,406 - 2,406 - - 5465 Safety Equip/Supp - 1,579 1,579 - 1,579 - - 5920 Buildings - 7,919 7,919 - 7,919 - Total Expenses $ - $ 16,440 $ 16,440 $ - $ 16,440 $ - - FUND: 101 - General Fund DEPT: 1400 - Parks & Recreation- Administration Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 46,880 $ 44,926 $ (1,954) $ 45,809 $ (883) $ 91,618 49.04 5020 Overtime - 30 30 - 30 - - 5040 Leave Time 5,497 7,410 1,913 7,415 (5) 14,830 49.97 5050 In Lieu of FICA 85 - (85) - - - - 5060 Retirement Benefi 4,914 3,608 (1,306) 3,306 302 6,611 54.57 5070 Health Insurance 17,977 15,751 (2,226) 13,299 2,452 26,598 59.22 5080 Workers' Comp 346 390 44 682 (292) 1,364 28.58 5090 Medicare 694 708 15 660 48 1,320 53.66 76,391 72,824 (3,568) 71,171 1,653 142,342 51.16 5120 Advertising - - - 50 (50) 100 - 5130 Subscriptions/Due 150 395 245 250 145 500 79.00 5140 Travel/Subsistenc - 210 210 550 (340) 1,100 19.09 5150 Communications 2,015 2,687 672 3,000 (313) 6,000 44.79 5160 Education/Trainin - 231 231 500 (269) 1,000 23.10 5330 Heating Fuel 628 997 369 120 877 241 414.58 5370 Insurance 907 939 32 1,800 (861) 3,600 26.08 5380 Maintenance & Rep - 770 770 - 770 - - 5390 Contracted Servic 16,963 12,760 (4,203) 20,000 (7,240) 40,000 31.90 5440 Operating Supplie 1,409 703 (707) 500 203 1,000 70.25 5465 Safety Equip/Supp 66 - (66) 75 (75) 150 - 5490 Postage/Misc.Frei 55 1 (54) 400 (399) 800 0.08 5790 Misc. Expenses - 2 2 60 (58) 120 1.78 Total Expenses $ 98,584 $ 92,518 $ (6,066) $ 98,476 $ (5,958) $ 196,952 46.97 FUND: 101 - General Fund DEPT: 1410 - Parks & Recreation- Parks Maintenance Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 40,675 $ 41,864 $ 1,190 $ 54,427 $ (12,563) $ 108,854 38.46 5020 Overtime 1,178 2,175 996 - 2,175 - - 5030 Unemployment Wage 3,051 1,870 (1,180) 4,750 (2,880) 9,500 19.69 5040 Leave Time 3,409 6,025 2,617 5,142 883 10,284 58.59 5060 Retirement Benefi 3,134 2,431 (702) 1,699 733 3,397 71.57 5070 Health Insurance 11,350 12,287 937 10,236 2,051 20,472 60.02 5080 Workers' Comp 2,864 3,807 943 3,285 522 6,570 57.95 5090 Medicare 1,521 1,593 72 2,785 (1,192) 5,569 28.60 67,181 72,053 4,873 82,323 (10,270) 164,647 43.76 5120 Advertising 17 120 102 - 120 - - 5130 Subscriptions/Due - - - 165 (165) 330 - 5140 Travel/Subsistenc - - - 125 (125) 250 - 5150 Communications 912 828 (84) 1,250 (422) 2,500 33.13 5160 Education/Trainin - - - 275 (275) 550 - 5310 Utilities 8,197 8,012 (185) 8,353 (341) 16,706 47.96 5330 Heating Fuel 450 662 212 558 103 1,117 59.24 5370 Insurance 3,871 3,819 (52) 5,000 (1,181) 10,000 38.19 5380 Maintenance & Rep 4,064 3,601 (464) 2,200 1,401 4,400 81.83 5390 Contracted Servic - - - 1,875 (1,875) 3,750 - 5420 Vehicle Supplies 2 61 59 375 (314) 750 8.15 5440 Operating Supplie 138 535 397 750 (215) 1,500 35.64 5450 Gas & Lube 3,115 3,573 458 3,750 (177) 7,500 47.64 5460 Equip,Furn,Tools 1,649 188 (1,461) 1,250 (1,062) 2,500 7.54 5465 Safety Equip/Supp 301 215 (86) 500 (285) 1,000 21.50 5470 Janitorial Suppli - 556 556 1,500 (944) 3,000 18.54 5490 Postage/Misc.Frei 127 101 (26) 900 (799) 1,800 5.62 5500 Equipment Rental - 300 300 1,750 (1,450) 3,500 8.57 5530 Motor Pool Rent 4,500 4,475 (26) 4,475 - 8,949 50.00 5790 Misc. Expenses 346 (41) (387) 500 (541) 1,000 (4.10) 5930 Capital Equipment - - - 1,500 (1,500) 3,000 - Total Expenses $ 94,870 $ 99,057 $ 4,187 $ 119,374 $ (20,317) $ 238,748 41.49 FUND: 101 - General Fund DEPT: 1415 - Parks & Recreation- Campgrounds Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 36,618 $ 42,066 $ 5,449 $ 53,916 $ (11,850) $ 107,832 39.01 5020 Overtime 1,816 1,336 (480) 608 728 1,215 109.92 5030 Unemployment Wage - 123 123 500 (377) 1,000 12.33 5040 Leave Time 1,674 - (1,674) - - - - 5060 Retirement Benefi 1,510 1,066 (445) 1,678 (612) 3,356 31.75 5070 Health Insurance 4,720 4,849 129 9,974 (5,125) 19,948 24.31 5080 Workers' Comp 2,617 3,815 1,198 3,755 60 7,511 50.80 5090 Medicare 2,008 2,396 388 2,780 (384) 5,560 43.09 50,963 55,651 4,687 73,211 (17,560) 146,421 38.01 5130 Subscriptions/Due - - - 30 (30) 60 - 5140 Travel/Subsistenc - - - 250 (250) 500 - 5150 Communications 195 149 (46) 400 (251) 800 18.59 5310 Utilities 13,752 16,315 2,563 44,827 (28,512) 89,654 18.20 5330 Heating Fuel 450 189 (260) 388 (199) 777 24.36 5370 Insurance 1,053 1,042 (11) 1,000 42 2,000 52.10 5380 Maintenance & Rep 2,138 3,482 1,344 6,775 (3,293) 13,550 25.70 5390 Contracted Servic 84 108 24 1,500 (1,392) 3,000 3.60 5420 Vehicle Supplies 35 - (35) 375 (375) 750 - 5440 Operating Supplie 4,016 1,434 (2,582) 2,250 (816) 4,500 31.86 5450 Gas & Lube 1,444 1,466 22 2,050 (584) 4,100 35.76 5460 Equip,Furn,Tools - 60 60 1,500 (1,440) 3,000 2.01 5465 Safety Equip/Supp 340 190 (150) 300 (110) 600 31.69 5470 Janitorial Suppli 623 4,163 3,539 2,250 1,913 4,500 92.50 5490 Postage/Misc.Frei 130 13 (117) 300 (287) 600 2.24 5500 Equipment Rental - 870 870 9,744 (8,874) 19,488 4.46 5530 Motor Pool Rent 3,098 4,130 1,032 4,131 - 8,261 50.00 5930 Capital Equipment - - - 1,000 (1,000) 2,000 - Total Expenses $ 78,322 $ 89,263 $ 10,941 $ 152,280 $ (63,018) $ 304,561 29.31 FUND: 101 - General Fund DEPT: 1420 - Parks & Recreation- Sports & Recreation Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual S 5010 Salaries $ 56,313 $ 51,180 $ (5,132) $ 52,803 $ (1,622) $ 105,605 48.46 5020 Overtime - 1,926 1,926 - 1,926 - - 5030 Unemployment Wage - - - 500 (500) 1,000 - 5040 Leave Time 4,826 5,009 183 5,877 (868) 11,754 42.61 5050 In Lieu of FICA 988 1,792 805 494 1,298 988 181.41 5060 Retirement Benefi 5,051 3,402 (1,649) 3,396 6 6,792 50.09 5070 Health Insurance 14,910 17,058 2,148 19,861 (2,803) 39,721 42.94 5080 Workers' Comp 637 591 (46) 830 (239) 1,660 35.59 5090 Medicare 1,326 1,331 5 1,051 280 2,102 63.33 84,050 82,290 (1,760) 84,811 (2,521) 169,623 48.51 5120 Advertising 17 173 155 1,000 (827) 2,000 8.63 5130 Subscriptions/Due - - - 160 (160) 320 - 5140 Travel/Subsistenc 12 - (12) 1,000 (1,000) 2,000 - 5150 Communications 1,497 1,275 (222) 600 675 1,200 106.28 5160 Education/Trainin - - - 375 (375) 750 - 5330 Heating Fuel 234 - (234) - - - - 5360 Rents & Leases - 18,000 18,000 10,000 8,000 20,000 90.00 5370 Insurance 1,091 1,123 32 1,700 (577) 3,400 33.02 5380 Maintenance & Rep 54 61 7 - 61 - - 5390 Contracted Servic 4,281 2,656 (1,625) 5,710 (3,054) 11,420 23.26 5440 Operating Supplie 5,627 11,364 5,737 12,400 (1,036) 24,800 45.82 5450 Gas & Lube 98 36 (62) - 36 - - 5460 Equip,Furn,Tools - 60 60 - 60 - - 5465 Safety Equip/Supp (32) - 32 250 (250) 500 - 5490 Postage/Misc.Frei 69 504 435 1,300 (796) 2,600 19.39 5790 Misc. Expenses 76 40 (36) 150 (110) 300 13.33 5990 Misc. Programs - - - 1,000 (1,000) 2,000 - Total Expenses $ 97,073 $ 117,581 $ 20,508 $ 120,456 $ (2,875) $ 240,913 48.81 FUND: 101 - General Fund DEPT: 1430 - Parks & Recreation- Youth Center Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 68,317 $ 75,370 $ 7,053 $ 78,649 $ (3,279) $ 157,298 47.92 5020 Overtime 82 1,850 1,768 - 1,850 - - 5030 Unemployment Wage - 1,524 1,524 - 1,524 - - 5040 Leave Time 5,953 2,374 (3,579) 4,755 (2,381) 9,510 24.96 5050 In Lieu of FICA 988 - (988) 494 (494) 988 - 5060 Retirement Benefi 5,917 3,542 (2,375) 4,380 (838) 8,759 40.44 5070 Health Insurance 26,340 16,878 (9,462) 27,855 (10,977) 55,711 30.30 5080 Workers' Comp 1,344 1,822 478 1,593 229 3,186 57.19 5090 Medicare 1,799 3,196 1,396 2,214 982 4,427 72.19 110,741 106,556 (4,185) 119,939 (13,383) 239,879 44.42 5120 Advertising - 110 110 125 (15) 250 44.00 5130 Subscriptions/Due - 6 6 130 (124) 260 2.30 5140 Travel/Subsistenc - - - 150 (150) 300 - 5150 Communications 1,855 1,544 (311) 2,000 (456) 4,000 38.59 5160 Education/Trainin - - - 475 (475) 950 - 5330 Heating Fuel 580 199 (381) - 199 - - 5370 Insurance 1,407 1,417 10 2,450 (1,033) 4,900 28.92 5380 Maintenance & Rep 189 222 33 2,100 (1,878) 4,200 5.29 5390 Contracted Servic 3,190 - (3,190) 175 (175) 350 - 5420 Vehicle Supplies - - - 155 (155) 310 - 5440 Operating Supplie 1,063 5,443 4,380 6,000 (557) 12,000 45.36 5450 Gas & Lube 360 539 179 1,050 (511) 2,100 25.67 5460 Equip,Furn,Tools - - - 1,250 (1,250) 2,500 - 5465 Safety Equip/Supp - - - 150 (150) 300 - 5470 Janitorial Suppli 306 331 26 450 (119) 900 36.79 5490 Postage/Misc.Frei 179 418 239 450 (32) 900 46.48 5530 Motor Pool Rent 4,130 3,098 (1,032) 3,098 - 6,196 50.00 5790 Misc. Expenses - 6 6 - 6 - - Total Expenses $ 124,000 $ 119,889 $ (4,111) $ 140,147 $ (20,258) $ 280,295 42.77 • FUND: 101 - General Fund DEPT: 1500 - Library Line Item Expenditure Summary by Fund Through June, 501 of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5010 Salaries $ 91,999 $ 85,782 $ (6,218) $ 95,825 $ (10,043) $ 191,650 44.76 5020 Overtime - 696 696 - 696 - - 5030 Unemployment Wage 26 - (26) - - - - 5040 Leave Time 8,969 8,257 (712) 11,303 (3,045) 22,605 36.53 5060 Retirement Benefi 10,076 7,510 (2,566) 7,259 251 14,517 51.73 5070 Health Insurance 36,924 36,897 (27) 40,111 (3,214) 80,221 45.99 5080 Workers' Comp 720 749 30 1,477 (728) 2,954 25.37 5090 Medicare 1,385 1,663 277 1,450 213 2,899 57.35 150,100 141,554 (8,546) 157,423 (15,869) 314,846 44.96 5120 Advertising 425 2,110 1,685 1,200 910 2,400 87.90 5130 Subscriptions/Due 380 999 619 600 399 1,200 83.22 5140 Travel/Subsistenc 2,578 738 (1,840) 750 (12) 1,500 49.20 5150 Communications 3,851 18,867 15,016 4,250 14,617 8,500 221.96 5160 Education/Trainin 1,685 1,778 93 1,000 778 2,000 88.92 5190 Other Spec Servic (538) 440 978 3,250 (2,810) 6,500 6.77 5310 Utilities 6,460 20,820 14,359 12,783 8,037 25,566 81.44 5330 Heating Fuel 5,969 16,001 10,032 10,837 5,164 21,674 73.83 5360 Rents & Leases 6,324 3,864 (2,460) 3,500 364 7,000 55.20 5370 Insurance 2,489 3,221 732 6,000 (2,779) 12,000 26.84 5380 Maintenance & Rep 304 1,615 1,312 1,750 (135) 3,500 46.15 5390 Contracted Servic - 16,887 16,887 25,556 (8,669) 51,111 33.04 5400 Library Bks.& Mat 13,285 8,668 (4,617) 12,000 (3,332) 24,000 36.12 5440 Operating Supplie 5,918 5,872 (45) 5,250 622 10,500 55.93 5460 Equip,Furn,Tools 68 4,104 4,036 3,977 127 7,953 51.60 5470 Janitorial Suppli 412 1,055 643 1,250 (195) 2,500 42.20 5490 Postage/Misc.Frei 3,418 3,565 147 4,500 (935) 9,000 39.61 5500 Equipment Rental - 228 228 1,000 (772) 2,000 11.42 5790 Misc. Expenses 100 1,890 1,790 250 1,640 500 377.95 5990 Misc. Programs - 256 256 - 256 - - Total Expenses $ 203,227 $ 254,532 $ 51,304 $ 257,125 $ (2,593) $ 514,250 49.50 FUND: 101 - General Fund DEPT: 1910 - General Fund Debt Service Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of GL 2012 2013 Variance Budget Variance Budget Annual B 5060 Retirement Benefi $ 208,252 $ 252,090 $ 43,838 $ 275,379 $ (23,289) $ 550,758 45.77 208,252 252,090 43,838 275,379 (23,289) 550,758 45.77 5810 Principal 62,525 65,807 3,283 130,796 (64,989) 261,592 25.16 5820 Interest Expense 73,501 79,700 6,199 114,149 (34,449) 228,298 34.91 Total Expenses $ 344,278 $ 397,597 $ 53,319 $ 520,324 $ (122,727) $ 1,040,648 38.21 City of Seward FUND: 401 - Small Boat Harbor Enterprise Fund Line Item Revenue Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud EF Interest Reven $ 18,369 $ 5,251 $ (13,118) $ 6,250 $ (999) $ 12,500 42.01 % Other Misc Revenu 302 - (302) 750 (750) 1,500 - Amortization of C 311,087 420,533 109,446 386,087 34,446 772,174 54.46 Amort.Bond Premiu - - - 4,188 (4,188) 8,375 - Transient Moorage 252,463 265,397 12,933 245,450 19,947 490,900 54.06 Moorage 577,960 573,271 (4,690) 499,400 73,871 998,800 57.40 Boat Lift Fees 49,619 56,473 6,854 50,000 6,473 100,000 56.47 Wharfage 10,128 15,571 5,442 27,500 (11,929) 55,000 28.31 Land Rents & Leas 202,698 202,453 (244) 194,208 8,245 388,416 52.12 Labor and Service 4,830 1,969 (2,862) 3,750 (1,781) 7,500 26.25 Land Lease Credit (32,241) (31,887) 355 (31,000) (887) (62,000) (51.43) Misc. Harbor Reve 24,748 24,584 (164) 45,875 (21,291) 91,750 26.79 Harbor Power Sale 166,648 197,571 30,923 143,000 54,571 286,000 69.08 Total Revenue $ 1,586,611 $ 1,731,185 $ 144,575 $ 1,575,458 $ 155,728 $ 3,150,915 54.94 % City of Seward FUND: 401 - Small Boat Harbor Enterprise Fund Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Salaries $ 221,390 $ 228,705 $ 7,315 $ 246,363 $ (17,658) $ 492,726 46.42 % Overtime 7,383 7,726 343 12,632 (4,906) 25,264 30.58 Standby Time 5,896 6,256 361 4,897 1,359 9,794 63.88 Leave Time 23,697 25,660 1,963 28,080 (2,420) 56,160 45.69 Retirement Benefi 59,509 59,627 118 63,670 (4,043) 127,340 46.83 Health Insurance 93,695 98,947 5,251 102,911 (3,964) 205,822 48.07 Workers' Comp 11,317 15,864 4,547 13,853 2,012 27,705 57.26 Medicare 4,075 4,064 (11) 4,299 (235) 8,598 47.27 Total Persnl Sery 426,963 446,849 19,886 476,705 (29,856) 953,409 46.87 Advertising 555 2,724 2,169 2,500 224 5,000 54.48 Subscriptions/Due - - - 750 (750) 1,500 - Travel/Subsistenc 5,304 4,199 (1,105) 3,250 949 6,500 64.60 Communications 3,559 3,922 362 6,000 (2,078) 12,000 32.68 Education/Trainin 1,441 962 (478) 2,000 (1,038) 4,000 24.06 Legal 2,075 2,372 297 12,500 (10,128) 25,000 9.49 Utilities 49,287 38,946 (10,341) 63,250 (24,304) 126,500 30.79 Power for Resale 149,412 132,896 (16,517) 132,150 746 264,300 50.28 Heating Fuel 4,454 4,537 83 5,000 (463) 10,000 45.37 Insurance 16,445 18,221 1,776 40,800 (22,579) 81,600 22.33 Maintenance & Rep 12,101 19,265 7,164 26,350 (7,085) 52,700 36.56 Contracted Servic 25,884 32,718 6,834 28,802 3,917 57,603 56.80 Operating Supplie 7,788 11,265 3,477 18,350 (7,085) 36,700 30.69 Gas & Lube 11,206 9,420 (1,786) 14,750 (5,330) 29,500 31.93 Equip,Furn,Tools 7,950 4,428 (3,522) 9,000 (4,572) 18,000 24.60 Safety Equip/Supp 3,963 1,737 (2,226) 3,000 (1,263) 6,000 28.95 Janitorial Suppli 2,414 2,095 (318) 4,000 (1,905) 8,000 26.19 Postage/Misc.Frei 2,861 3,445 583 6,225 (2,780) 12,450 27.67 Equipment Rental - - - 500 (500) 1,000 - Motor Pool Rent 28,425 28,905 480 28,905 - 57,810 50.00 Depreciation Expe 540,186 696,138 155,952 769,067 (72,928) 1,538,133 45.26 Bad Debt Expense 1,793 1,793 5,500 (3,707) 11,000 16.30 Harbor Overhead 474,609 458,735 (15,874) 458,735 - 917,470 50.00 Harbor Allocation (312,242) (295,621) 16,622 (295,621) - (591,242) (50.00) P.I.L.T. 87,325 90,787 3,462 81,198 9,589 162,396 55.90 Reclass PILT to T (87,325) (90,787) (3,462) (81,198) (9,589) (162,396) (55.90) Bank,credit card 23,626 24,836 1,210 1,000 23,836 2,000 1241.82 Misc. Expenses 1,002 508 (494) 1,750 (1,242) 3,500 14.50 Principal 267,358 278,588 11,230 221,794 56,794 443,588 62.80 Interest Expense 126,829 113,029 (13,800) 142,187 (29,157) 284,373 39.75 Amort.BondlssueCo - - - 2,965 (2,965) 5,929 - Infrastructure Co - - - 17,544 (17,544) 35,089 - Capital Equipment 15,790 - (15,790) - - - - Total Expenses $ 1,899,246 $ 2,046,913 $ 147,667 $ 2,209,706 $ (162,793) $ 4,419,412 46.32 % City of Seward FUND: 403 - Parking Enterprise Fund Line Item Revenue Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Parking Fees $ 105,673 $ 107,458 $ 1,785 $ 130,325 $ (22,867) $ 260,650 41.23 % Fines 795 580 (215) - 580 - - EF Interest Reven 1,086 - (1,086) 1,850 (1,850) 3,700 - Total Revenue $ 107,554 $ 108,038 $ 484 $ 132,175 $ (24,137) $ 264,350 40.87 % City of Seward FUND: 403 - Parking Enterprise Fund Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Salaries $ 33,359 $ 26,187 $ (7,172) $ 54,869 $ (28,682) $ 109,738 23.86 % Overtime 551 1,136 585 1,265 (129) 2,529 44.91 Unemployment Wage - 2,088 2,088 4,000 (1,912) 8,000 26.10 Leave Time 896 - (896) - - - - Retirement Benefi 755 508 (247) 633 (125) 1,266 40.12 Health Insurance 1,750 1,945 194 1,749 196 3,497 55.61 Workers' Comp 1,304 1,418 114 626 792 1,252 113.26 Medicare 2,113 1,642 (471) 3,737 (2,094) 7,473 21.97 Total Persnl Sery 40,728 34,923 (5,805) 66,878 (31,954) 133,755 26.11 Advertising - 76 76 1,000 (924) 2,000 3.80 Subscriptions/Due 1,520 1,920 400 3,148 (1,228) 6,295 30.50 Travel/Subsistenc - - - 125 (125) 250 - Communications 2,058 2,150 92 1,850 300 3,700 58.11 Education/Trainin - - - 800 (800) 1,600 - Legal - - - 300 (300) 600 - Other Spec Servic 60,286 - (60,286) 4,750 (4,750) 9,500 - Utilities 44 59 16 210 (151) 420 14.10 Rents & Leases - - - 500 (500) 1,000 - Insurance 1,205 1,090 (116) 1,800 (710) 3,600 30.27 Maintenance & Rep 1,103 2,769 1,666 7,875 (5,106) 15,750 17.58 Vehicle Supplies - - - 700 (700) 1,400 - Operating Supplie 3,332 3,241 (91) 4,750 (1,509) 9,500 34.12 Gas & Lube 260 190 (70) 388 (197) 775 24.53 Equip,Furn,Tools - 61 61 1,113 (1,051) 2,225 2.76 Safety Equip/Supp - - - 750 (750) 1,500 - Postage/Misc.Frei 308 - (308) 1,175 (1,175) 2,350 - Equipment Rental - 459 459 - 459 - - Motor Pool Rent 6,500 6,500 - 6,500 - 13,000 50.00 Depreciation Expe 8,378 11,984 3,606 8,379 3,605 16,757 71.52 Genl Govt Admin F 4,945 5,069 124 5,069 - 10,137 50.00 P.I.L.T. 8,517 8,643 126 10,426 (1,783) 20,852 41.45 Reclass PILT to T (8,517) (8,643) (126) (10,426) 1,783 (20,852) (41.45) Bank,credit card 648 679 31 2,100 (1,421) 4,200 16.17 Misc. Expenses 210 (194) (404) 400 (594) 800 (24.25) Total Expenses $ 131,525 $ 70,977 $ (60,548) $ 120,557 $ (49,580) $ 241,114 29.44 % City of Seward FUND: 417 - S.M.I.C. Enterprise Fund Line Item Revenue Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud EF Interest Reven $ 272 $ 40 $ (232) $ - $ 40 $ - - % Amortization of C 241,265 241,265 - 241,265 - 482,529 50.00 Moorage 1,841 780 (1,061) 1,500 (720) 3,000 26.00 Boat Lift Fees 49,598 49,981 383 57,500 (7,519) 115,000 43.46 Storage Fees 62,704 51,857 (10,847) 50,000 1,857 100,000 51.86 Wharfage 6,058 5,281 (777) 2,125 3,156 4,250 124.27 Land Rents & Leas 70,116 70,642 526 70,024 618 140,048 50.44 Labor and Service 418 158 (261) 500 (343) 1,000 15.75 Land Lease Credit (3,665) - 3,665 - - - - Misc. Harbor Reve 3,738 2,506 (1,232) - 2,506 - - Harbor Power Sale 17,181 24,463 7,282 18,000 6,463 36,000 67.95 Total Revenue $ 449,526 $ 446,973 $ (2,552) $ 440,914 $ 6,060 $ 881,827 50.69 % City of Seward FUND: 417 - S.M.I.C. Enterprise Fund Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Salaries $ 33,054 $ 22,014 $ (11,040) $ 18,580 $ 3,435 $ 37,159 59.24 % Overtime 632 481 (151) 2,403 (1,922) 4,806 10.00 Standby Time - 59 59 - 59 - - Leave Time 1,987 - (1,987) - - - - Retirement Benefi 3,708 1,921 (1,787) 2,308 (387) 4,615 41.62 Health Insurance 11,780 9,273 (2,507) 7,906 1,367 15,812 58.64 Workers' Comp 2,525 2,236 (289) 2,181 55 4,362 51.26 Medicare 488 351 (137) 476 (125) 952 36.87 Total Persnl Sery 54,173 36,334 (17,839) 33,853 2,481 67,706 53.66 Advertising - - - 500 (500) 1,000 - Travel/Subsistenc - - - 500 (500) 1,000 - Communications - - - 1,250 (1,250) 2,500 - Legal 2,789 4,048 1,259 5,000 (952) 10,000 40.48 Utilities 7,899 8,368 469 7,500 868 15,000 55.78 Power for Resale 11,296 15,677 4,381 18,000 (2,323) 36,000 43.55 Heating Fuel 2,364 1,697 (667) 6,000 (4,303) 12,000 14.14 Insurance 2,914 3,261 347 7,200 (3,939) 14,400 22.65 Maintenance & Rep 4,617 1,960 (2,657) 18,000 (16,040) 36,000 5.44 Contracted Servic 2,403 5,538 3,135 17,500 (11,962) 35,000 15.82 Operating Supplie 823 837 14 3,750 (2,913) 7,500 11.16 Gas & Lube 7,190 6,896 (293) 5,000 1,896 10,000 68.96 Equip,Furn,Tools 724 445 (279) 750 (305) 1,500 29.67 Postage/Misc.Frei 332 20 (312) 3,000 (2,980) 6,000 0.33 Depreciation Expe 300,916 300,916 - 300,916 - 601,831 50.00 Harbor Overhead 95,290 96,680 1,389 96,680 - 193,359 50.00 Harbor Allocation (51,915) (54,053) (2,138) (54,053) - (108,105) (50.00) P.I.L.T. 11,324 10,802 (522) 10,370 432 20,740 52.08 Reclass PILT to T (11,324) (10,802) 522 (10,370) (432) (20,740) (52.08) Misc. Expenses 260 350 91 375 (25) 750 46.67 Total Expenses $ 442,074 $ 428,974 $ (13,100) $ 471,721 $ (42,747) $ 943,441 45.47 % CITY OF SEWARD Monthly Budget Report Electric Fund Revenue Detail by Line Item 2012 2013 2013 Bud to Act Dept GL Sub Account Name Thru 6/12 Thru 6/13 Variance Budget Variance % Change Department: General 0000 4180 0200 Assessment Inter $ - $ 363 $ 363 $ 3,200 $ (2,837) (88.7)% 0000 4600 0010 EF Investmnt Int 7,131 - (7,131) 3,000 (3,000) (100.0) 0000 4600 0030 EF Repo Interest 31 - (31) 500 (500) (100.0) 0000 4600 0120 EF Penalties/Int 43,195 40,994 (2,201) 47,000 (6,006) (12.8) 0000 4690 0600 Coll./Doubtful A - 224 224 - 224 - 0000 4700 0000 Amort of CIA-Gen 468,783 473,366 4,583 1,063,795 (590,429) (55.5) 0000 4710 Amort.Bond Premi - - - 8,366 (8,366) (100.0) 0000 4801 0000 Residential 929,088 931,522 2,434 1,813,446 (881,924) (48.6) 0000 4801 0200 Resident fuel fa 576,650 464,940 (111,710) 1,158,344 (693,404) (59.9) 0000 4801 0300 Customer charge 209,490 222,115 12,625 463,442 (241,327) (52.1) 0000 4802 0000 SG Service 528,356 547,173 18,817 1,131,418 (584,245) (51.6) 0000 4802 0200 SG fuel factor 281,669 238,717 (42,952) 626,191 (387,474) (61.9) 0000 4802 0300 SG Customer Char 92,222 98,372 6,150 226,050 (127,678) (56.5) 0000 4803 0000 LG Service 859,308 903,540 44,232 1,790,025 (886,485) (49.5) 0000 4803 0200 LG fuel factor 765,922 658,821 (107,101) 1,575,483 (916,662) (58.2) 0000 4803 0300 LG customer char 18,335 20,123 1,787 41,725 (21,602) (51.8) 0000 4803 0400 LG alt energy cr - (1,772) (1,772) 1,169,356 (1,171,128) (100.2) 0000 4803 0500 LGS Demand 558,806 650,324 91,518 - 650,324 - 0000 4805 0000 Sp.Contract Ener 42,145 47,436 5,291 72,385 (24,949) (34.5) 0000 4805 0200 Spec.Contract fu 267,530 251,285 (16,245) 561,334 (310,049) (55.2) 0000 4805 0300 Sp.Contr.custmr 458 455 (4) 917 (462) (50.4) 0000 4805 0400 Spec.Contract En - - - 274,428 (274,428) (100.0) 0000 4805 0500 Spec Contract De 144,398 170,592 26,194 - 170,592 - 0000 4806 0000 Harbor Fund Powe 108,471 108,532 62 205,400 (96,868) (47.2) 0000 4806 0200 Harbor power fue 56,097 44,478 (11,618) - 44,478 - 0000 4807 0000 Street & Yard 31,099 32,858 1,759 76,707 (43,849) (57.2) 0000 4807 0200 Yard Light Fuel 3,381 2,719 (661) - 2,719 - 0000 4850 0000 Electric KVAR ra 9,713 - (9,713) - - - 0000 4880 0420 Turn on Fees 6,965 6,379 (586) 15,000 (8,621) (57.5) 0000 4880 0430 Work Order Reven 904 - (904) 20,000 (20,000) (100.0) 0000 4880 0470 Equipment Rental 1,305 - (1,305) 25,500 (25,500) (100.0) 0000 4880 0480 Joint Pole Use - - - 10,500 (10,500) (100.0) 0000 4880 0490 Misc. Revenue 15,368 16,187 819 2,000 14,187 709.4 Total Revenues $ 6,026,822 $ 5,929,745 $ (97,077) $ 12385512 $(6,455,767) (52.1)% City of Seward FUND: 501 - Electric Fund Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Salaries $ 406,820 $ 408,089 $ 1,269 $ 429,707 $ (21,618) $ 859,414 47.48 % Overtime 32,593 30,599 (1,995) 30,814 (215) 61,627 49.65 Standby Time 39,003 42,891 3,888 42,406 486 84,811 50.57 Electric Meal All 840 817 (23) 6,875 (6,057) 13,749 5.94 Unemployment Wage 5,493 325 (5,168) 1,500 (1,175) 3,000 10.85 Leave Time 38,232 42,526 4,294 45,601 (3,075) 91,201 46.63 Retirement Benefi 59,883 67,865 7,982 78,216 (10,351) 156,432 43.38 Health Insurance 96,497 104,294 7,797 99,936 4,358 199,872 52.18 Workers' Comp 25,080 27,827 2,747 53,240 (25,413) 106,479 26.13 Medicare 7,256 8,588 1,332 7,622 966 15,244 56.34 Union Benefits 10,038 12,187 2,149 10,000 2,187 20,000 60.94 Sal.& Ben.w/o cre (5,116) - 5,116 (147,500) 147,500 (295,000) - Total Persnl Sery 716,620 746,009 29,389 658,415 87,594 1,316,829 56.65 Advertising - 341 341 2,750 (2,409) 5,500 6.20 Subscriptions/Due 17,348 18,656 1,307 18,750 (95) 37,500 49.75 Travel/Subsistenc 8,451 2,479 (5,971) 11,500 (9,021) 23,000 10.78 Communications 7,449 8,303 855 16,000 (7,697) 32,000 25.95 Education/Trainin 4,551 3,800 (751) 11,500 (7,700) 23,000 16.52 Legal 6,823 38,807 31,985 17,500 21,307 35,000 110.88 Other Spec Servic 5,089 5,497 408 8,250 (2,753) 16,500 33.32 Utilities 41,279 37,585 (3,694) 42,975 (5,390) 85,950 43.73 Power for Resale 2,084,012 1,968,426 (115,586) 2,500,000 (531,574) 5,000,000 39.37 Heating Fuel 13,686 13,388 (298) 11,750 1,638 23,500 56.97 Fuel for Generato - 33,311 33,311 48,000 (14,689) 96,000 34.70 Rents & Leases 12,471 19,035 6,564 10,500 8,535 21,000 90.64 Insurance 26,607 25,851 (757) 32,500 (6,649) 65,000 39.77 Maintenance & Rep 43,990 19,375 (24,615) 63,650 (44,275) 127,300 15.22 Contracted Servic 66,669 101,515 34,846 131,271 (29,756) 262,542 38.67 Library Bks.& Mat - 93 93 - 93 - - Vehicle Supplies 1,926 2,059 133 2,500 (441) 5,000 41.18 Operating Supplie 61,548 44,594 (16,953) 164,250 (119,656) 328,500 13.58 Oper.Supp.w/o cre (180) - 180 (112,500) 112,500 (225,000) - Gas & Lube 22,404 17,678 (4,727) 16,650 1,028 33,300 53.09 Equip,Furn,Tools 3,020 2,879 (142) 9,500 (6,621) 19,000 15.15 Safety Equip/Supp 905 396 (509) 4,500 (4,104) 9,000 4.40 Postage/Misc.Frei 10,355 6,221 (4,134) 12,000 (5,779) 24,000 25.92 Equipment Rental 1,061 828 (233) 21,000 (20,172) 42,000 1.97 Motor Pool Rent 87,500 87,500 - 87,500 - 175,000 50.00 Util. Deposit Int 540 552 12 700 (148) 1,400 39.45 Depreciation Expe 735,979 879,068 143,088 927,551 (48,483) 1,855,102 47.39 Bad Debt Expense - - - 15,000 (15,000) 30,000 - Genl Govt Admin F 423,646 423,646 - 423,646 - 847,291 50.00 P.I.L.T. 444,174 433,184 (10,990) 450,386 (17,202) 900,772 48.09 D a City of Seward FUND: 501 - Electric Fund Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Reclass PILT to T $ (444,174) $ (433,184) $ 10,990 $ (450,386) $ 17,202 $ (900,772) (48.09)% Bank,credit card 21,234 22,319 1,085 1,500 20,819 3,000 743.96 Misc. Expenses 513 257 (256) 6,500 (6,243) 13,000 1.98 Principal 345,000 360,000 15,000 172,500 187,500 345,000 104.35 Interest Expense 138,328 131,661 (6,667) 163,412 (31,751) 326,823 40.29 Amort.BondissueCo - - - 1,761 (1,761) 3,521 - Buildings - 18,500 18,500 - 18,500 - - Infrastructure Co - - - 50,000 (50,000) 100,000 - Capital Equipment 24,240 40,388 16,148 25,000 15,388 50,000 80.78 Total Expenses $ 4,933,064 $ 5,081,016 $ 147,952 $ 5,578,279 $ (497,263) $ 11,156,558 45.54 % CITY OF SEWARD Monthly Budget Report Water Enterprise Fund Revenue Detail by Line Item 2012 2013 2013 Bud to Act Dept GL Sub Account Name Thru 6/12 Thru 6/13 Variance Budget Variance % Change Department: Water System 7110 4600 0010 EF Investmnt Int $ 3,699 $ 41 $ (3,658) $ 65,000 $ (64,959) (99.9)% 7110 4600 0030 EF Repu Interest 18 - (10) 2,000 (2,000) (100.0) 7110 4600 0120 EF Penalties/Int 689 763 74 - 763 - 7110 4700 0000 Amort of CIA-Gen 13,826 13,360 (466) 27,653 (14,293) (51.7) 7110 4801 0000 Residential 202,107 207,939 5,832 421,729 (213,790) (50.7) 7110 4802 0000 SG Service 52,456 53,599 1,142 112,480 (58,881) (52.3) 7110 4803 0000 LG Service 87,780 93,702 5,922 186,780 (93,078) (49.8) 7110 4804 0000 SMIC Sales 28,511 22,667 (5,844) 67,366 (44,699) (66.4) 7110 4805 0000 Sp.Contract Ener 133,848 121,867 (11,980) 174,816 (52,949) (30.3) 7110 4808 Ship Water 13,457 27,554 14,098 87,000 (59,446) (68.3) 7110 4880 0420 Turn on Fees 3,480 2,772 (708) 8,100 (5,328) (65.8) 7110 4880 0440 Hydrant Rentals 29,391 27,915 (1,476) 57,000 (29,085) (51.0) 7110 4880 0490 Misc. Revenue 12,293 - (12,293) 750 (750) (100.0) Total Revenues $ 581,555 $ 572,179 $ (9,375) $ 1,210,674 $ (638,495) (52.7)% City of Seward FUND: 701 - Water Enterprise Fund Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Salaries $ 73,051 $ 73,439 $ 388 $ 90,231 $ (16,792) $ 180,462 40.70 % Overtime 9,973 3,152 (6,821) 2,173 980 4,345 72.55 Standby Time 4,253 4,773 520 5,227 (454) 10,454 45.66 Leave Time 8,342 6,876 (1,466) 10,737 (3,860) 21,473 32.02 In Lieu of FICA 494 - (494) 247 (247) 494 - Retirement Benefi 19,001 16,809 (2,192) 22,714 (5,905) 45,428 37.00 Health Insurance 21,163 24,862 3,699 32,237 (7,375) 64,473 38.56 Workers' Comp 3,943 3,950 7 6,780 (2,829) 13,559 29.13 Medicare 1,117 1,115 (2) 1,315 (199) 2,629 42.43 Total Persnl Sery 141,338 134,977 (6,361) 171,659 (36,682) 343,317 39.32 Advertising - 101 101 515 (414) 1,030 9.81 Subscriptions/Due 322 704 382 618 86 1,236 56.94 Travel/Subsistent 781 530 (250) 2,810 (2,280) 5,620 9.44 Communications 4,049 3,572 (478) 4,500 (929) 9,000 39.68 Education/Trainin - - - 3,160 (3,160) 6,320 - Legal - - - 2,575 (2,575) 5,150 - Utilities 112,591 100,137 (12,454) 109,000 (8,863) 218,000 45.93 Insurance 1,542 1,603 61 3,500 (1,897) 7,000 22.89 Maintenance & Rep 5,198 4,819 (378) 16,150 (11,331) 32,300 14.92 Contracted Servic 8,186 1,720 (6,465) 44,770 (43,050) 89,540 1.92 Operating Supplie 12,473 2,200 (10,273) 20,630 (18,430) 41,260 5.33 Gas & Lube 4,217 4,059 (158) 4,435 (376) 8,870 45.76 Testing 3,138 1,360 (1,778) 5,750 (4,390) 11,500 11.83 Equip,Furn,Tools 836 584 (252) 4,850 (4,266) 9,700 6.02 Safety Equip/Supp 1,117 565 (552) 2,000 (1,435) 4,000 14.12 Postage/Misc.Frei 2,548 830 (1,718) 2,833 (2,002) 5,665 14.66 Equipment Rental 92 3,750 3,658 3,500 250 7,000 53.57 Motor Pool Rent 2,000 2,000 - 2,000 - 4,000 50.00 Depreciation Expe 104,264 108,012 3,749 99,442 8,571 198,883 54.31 Bad Debt Expense - - - 1,100 (1,100) 2,200 - Genl Govt Admin F 116,872 116,872 - 116,872 - 233,744 50.00 P.I.L.T. 45,121 44,641 (480) 45,649 (1,008) 91,298 48.90 Reclass PILT to T (45,121) (44,641) 480 (45,649) 1,008 (91,298) (48.90) Bank,credit card 1,997 2,264 267 - 2,264 - - Misc. Expenses 143 1,127 984 773 354 1,545 72.93 Principal 583,838 125,452 (458,386) 60,811 64,641 121,621 103.15 Interest Expense - 7,741 7,741 19,882 (12,141) 39,764 19.47 Capital Equipment 3,900 - (3,900) - - - - Total Expenses $ 1,111,441 $ 624,978 $ (486,462) $ 704,133 $ (79,154) $ 1,408,265 44.38 % CITY OF SEWARD Monthly Budget Report Wastewater Enterprise Fund Revenue Detail by Line Item 2012 2013 2013 Bud to Act Dept GL Sub Account Name Thru 6/12 Thru 6/13 Variance Budget Variance % Change Department: Wastewater System 7120 4600 0010 EF Investmnt Int $ 2,012 $ - $ (2,012) $ 500 $ (500) (100.0)% 7120 4600 0030 EF Repo Interest 9 - (9) 100 (100) (100.0) 7120 4600 0120 EF Penalties/Int 1,027 1,054 27 1,500 (446) (29.7) 7120 4700 0000 Amort of CIA-Gen 111,165 94,497 (16,668) 215,657 (121,160) (56.2) 7120 4801 0000 Residential 254,758 262,648 7,890 541,286 (278,638) (51.5) 7120 4802 0000 SG Service 61,155 74,714 13,559 126,889 (52,175) (41.1) 7120 4803 0000 LG Service 100,696 110,879 10,183 216,288 (105,409) (48.7) 7120 4804 0000 SMIC Sales 11,076 15,736 4,660 37,539 (21,803) (58.1) 7120 4880 0450 Sewer - Inspecti - - - 250 (250) (100.0) 7120 4880 0460 Sewer-Misc. Sery 463 161 (302) 500 (339) (67.8) Total Revenues $ 542,361 $ 559,689 $ 17,328 $ 1,140,509 $ (580,820) (50.9)% City of Seward FUND: 703 - Wastewater Enterprise Fund Line Item Expenditure Summary by Fund Through June, 50% of year has expired THROUGH JUNE ANNUAL Actual YTD Budget Annual % of Account Name 2012 2013 Variance Budget Variance Budget Annual Bud Salaries $ 67,145 $ 68,596 $ 1,452 $ 64,498 $ 4,098 $ 128,996 53.18 % Overtime 6,562 3,729 (2,833) 1,496 2,233 2,991 124.67 Standby Time 2,925 3,111 186 3,062 49 6,124 50.80 Leave Time 7,617 6,909 (709) 7,652 (743) 15,303 45.15 In Lieu of FICA 494 - (494) 247 (247) 494 - Retirement Benefi 18,054 16,999 (1,055) 16,088 911 32,176 52.83 Health Insurance 19,546 23,755 4,209 22,163 1,592 44,325 53.59 Workers' Comp 3,487 3,665 178 8,425 (4,760) 16,849 21.75 Medicare 958 1,021 63 878 143 1,756 58.16 Total Persnl Sery 126,788 127,784 996 124,507 3,277 249,014 51.32 Subscriptions/Due - 594 594 850 (256) 1,700 34.94 Travel/Subsistenc 502 303 (199) 1,258 (955) 2,515 12.04 Communications 2,711 2,372 (339) 3,615 (1,243) 7,230 32.81 Education/Trainin - - - 758 (758) 1,515 - Legal - - - 2,500 (2,500) 5,000 - Utilities 88,645 85,829 (2,817) 92,530 (6,701) 185,060 46.38 Heating Fuel - 1,274 1,274 875 399 1,750 72.79 Insurance 3,065 2,302 (763) 3,000 (698) 6,000 38.37 Maintenance & Rep 1,953 2,791 839 17,725 (14,934) 35,450 7.87 Contracted Servic 25,406 23,253 (2,154) 36,775 (13,522) 73,550 31.62 Operating Supplie 5,993 3,018 (2,975) 6,850 (3,832) 13,700 22.03 Gas & Lube 4,735 3,748 (987) 3,988 (239) 7,975 47.00 Testing 6,496 8,204 1,708 9,350 (1,146) 18,700 43.87 Equip,Furn,Tools 13 713 701 2,045 (1,332) 4,090 17.44 Safety Equip/Supp 178 - (178) 508 (508) 1,015 - Postage/Misc.Frei 1,400 993 (407) 1,620 (627) 3,240 30.64 Equipment Rental 27 - (27) 1,030 (1,030) 2,060 - Motor Pool Rent 2,000 2,000 - 2,000 - 4,000 50.00 Depreciation Expe 143,817 132,153 (11,664) 128,348 3,805 256,695 51.48 Bad Debt Expense - - - 750 (750) 1,500 - Genl Govt Admin F 71,372 71,372 - 71,373 - 142,745 50.00 P.I.L.T. 34,334 37,131 2,797 36,910 221 73,820 50.30 Reclass PILT to T (34,334) (37,131) (2,797) (36,910) (221) (73,820) (50.30) Bank,credit card 2,490 2,859 369 - 2,859 - - Misc. Expenses - - - 515 (515) 1,030 - Principal 1,333 - (1,333) 30,511 (30,511) 61,022 - Interest Expense 60 - (60) 468 (468) 935 - Total Expenses $ 488,984 $ 471,565 $ (17,419) $ 543,746 $ (72,181) $ 1,087,491 43.36 % City of Seward Trial Balance-Central Treasury as of 6/30/13 Last Year This Year Account Fund Description Balance Balance Assets: 1020 Cash-Treasury $4,108,316.97 2,506,980.45 1030 10 Investments 17,534,824.11 17,589,528.57 21,643,141.08 20,096,509.02 1300 101 General Fund 6,965,471.12 5,806,095.00 1300 102 Motor Pool Fund 1,089,780.28 1,114,230.23 1300 103 Capital Acquistion 742,857.08 629,873.70 1300 104 Compensated Leave 454,603.51 454,603.51 1300 208 Lawing/Ft.Ray.T-Line 566,135.55 566,135.55 1300 215 ALPAR -2,500.00 4,671.49 1300 220 Two Lakes Park 2,520.19 2,520.19 1300 271 FY97 Muni Grants -107,923.08 (493,187.42) 1300 274 Sm Boat Harbor Exp 689,392.01 690,111.92 1300 275 Sm.Boat Hrbr.South 117,725.09 117,725.09 1300 276 Harbor Dredging 82,983.65 83,200.00 1300 277 Harbor Cap Projects 66,032.41 66,032.41 1300 278 Harbor Float Restore -18,821.50 99,589.32 1300 306 1995 Flood Disaster 40,438.19 (2,382.81) 1300 315 SBH Repair/Renovate -10,337.79 1,283,306.44 1300 401 Harbor Fund 2,149,226.97 888,826.56 1300 402 Harbor MRRF Fund 901,249.91 (125,879.09) 1300 403 Parking Revenue Fund 464,388.63 504,168.40 1300 417 SMIC Operations 163,325.46 209,074.64 1300 501 Electric Fund 1,896,566.64 2,414,446.75 1300 502 Electric MRRF 460,017.73 496,146.06 1300 505 Stndby Elec Generatr 34,225.80 (19,123.47) 1300 600 Fourth&Adams Park 8,523.98 8,523.98 1300 626 Library/Museum CP -107,334.03 140,830.59 1300 666 NRCS Levee/Road -14,847.68 (33,053.47) 1300 700 Water MRRF 212,546.00 212,546.00 1300 701 Water Fund 957,478.75 771,198.73 1300 702 Wastewater MRRF 112,115.31 112,115.31 1300 703 Wastewater Ent.Fund 605,981.64 671,993.51 1300 704 Forest Acres/Gateway 30,826.49 30,826.49 1300 709 Water Tank Phase I 159,592.09 164,277.97 1300 800 Seward Mtn Haven 1,025,188.91 1,180,129.85 1300 801 Hospital Debt Svc. 945,498.04 503,473.58 1300 804 Teen Council Fund 54,718.83 54,825.61 1300 805 Bus Transportation 112,831.96 112,831.96 1300 806 Harbor Revenue Bond -53.51 78,116.47 1300 807 CPV Fund 1,445,667.82 1,788,932.82 1300 826 Library S.R.Projects 11,438.22 11,438.22 1300 851 Fire Dept.Grants -478.06 804.94 1300 866 Natural Disasters -608,017.43 (484,930.78) 1300 890 Pass-thru SR Fund (55,894.10) 11,265.74 Liabilities: 2000 A/P Trade $ - (29,822.97) ❑ 21,643,141.08 20,096,509.02