Docstoc

051611accdoc0001

Document Sample
051611accdoc0001 Powered By Docstoc
					 
                                       TENTATIVE AGENDA 
                                        CITY OF AUBURN  
                              MONTHLY COUNCIL MEETING—May 16, 2011 
                                COUNCIL ROOM‐City Hall‐‐ 6:00 p.m. 
                                   Meeting is Open to the Public 
                                                               
                                                               
                                                               
1.     Open and Roll Call 
2.     Approval of Agenda 
3.     Approval of the Consent Agenda 
       a. Minutes of the April 11, 2011 Council meeting 
       b. Treasurer’s Report, Monthly Financial Report 
       c. Claims and Payroll 
       d. Sheriff’s Reports  
       e. Sparky’s One Stop Cigarette Permit 
                   
 
       Action Items         
4.     Approve Insurance Renewal‐ Renee Stauter, Mid‐Iowa Ins. 
5.     Consider/Approve Property Development Study‐ Myron Daringer, JEO 
6.     Energy Efficiency‐ 
                 Rebate Programs   
                 EECBG Grant‐begin event planning         
7.     Radio Communications Meeting Attendance – appoint representative                          
8.     Approve Maintenance Agreement with IDOT             
9.     Approve Mosquito spraying by Mosquito Control of IA 
        
        
10.    Public Forum This is an opportunity for any citizen to come forward and discuss any item that is not listed on the 
       Agenda. Please limit comment to no more than 5 minutes 


11.    Discussion Items and Reports   
        
       Public Works  
       City Clerk. SETD, SCEF, IAMWind 
       Sac Co. Solid Waste Board 
       Sac Co. Emergency Management Board 
           th
       125  Celebration Committee 
       Fire Department 
       Recreation Committee 
       Library Board 
       Historical Committee 
       Sheriff Department  
       Mayor and Council  

12.    Adjourn‐ Next Council Meeting will be June 13, 2011 at 6:00 PM in City Hall. 
Minutes 
Auburn City Council 
April 11, 2011 
 
Mayor Linda Beidler called the meeting to order at 6:01PM with council members Cindy Finley, Dustin Mead, Josh Zimmerman, Janelle King and Justin Potthoff 
present.  Employees: Gerry Blessington and Nancy Janssen.  Guests: Verdi Maunu, Jamie Svoboda, Cody Zimmerman, Randy Schulte, Fire Chief Randy Buse, 
Gayleen Schug, Michelle Jacobs, Scott Jacobs, Larry Finley, Alan Schrad and Mary Sturm. 
 
Motion by King, seconded by Potthoff to approve the agenda.  All voted affirmative.  Motion by Finley, seconded by Zimmerman to approve the consent 
agenda which included the minutes of the March 7 & 28, 2011 meeting, Financial, Treasurer’s and Sheriff’s reports and the following Claims and payroll.  
Voting Aye:  King, Finley, Mead, Zimmerman, and Potthoff. 
  Als Corner Oil                Propane                       $734.20                  Schug, Gayleen                            Training mileage         $30.60
  Baker & Taylor Books library                                $329.49                  Stewart, Donetta                          library                  $14.67
  Bunz & Gaffney                Legal                         $437.50                  Svoboda, Jamie                            Training mileage         $12.75
  C N A Surety                  Bond                          $150.00                  The Graphic-Advocate library                                       $32.00
  Center Point Books            library                        $43.74                  Raccoon Valley REC                        power                 $9,983.86
  Consumer Reports              library                        $26.00                  Reiling Electric                          Repairs                 $180.00
  Cornbelt Power                elect transmission            $735.90                  Sac Co. Sheriff                           1 qtr 28E             $3,469.50
  CRS Hauling                   garbage pick up           $1,000.00                    Spring Valley Wireless fire Dept pagers                           $770.00
  Daily Times Herald            Publishing                     $56.00                  Tiefenthaler Building                     Rec/comm bldg           $544.28
  EFTPS                         941 Tax                   $1,375.23                    Tri County Special                        publishing               $40.00
  Fleet Fueling                 fire/shop fuel                $369.03                  US Cellular                               phone                    $48.22
  Gorman, Mae                   Sewer Easement                 $49.85                  Utility Service Co.                       water tower             $596.08
  Highsmith                     library                        $39.19                  WAPA                                      power                 $1,904.50
  IA Dept of Revenue            withholding                   $552.00                  Wilkens Napa                              shop                     $31.93
  IA Dept of Revenue            Sales Tax                     $838.00                  Total Claims                                                   $26,829.88
  IA Savings Bank               Sewer Reserve                 $104.00
  IA State University           Fire Training                 $364.00                  March Wages                                                     $7,738.50
  IAMU                          Energy Efficiency              $66.42
  Iowa Telecom                  phone                         $142.03                  Rec Comm Bills
  IPERS                         employ benefits               $759.85                  Artworx                                   soccer                $1,012.00
  Janssen, Nancy                Park Repairs                   $60.25                  IA Saving Bank                            change                  $300.00
  Janssen, Nancy                mileage                       $157.08                  Martin's Welding                          soccer                  $385.00
  Kriz-Davis Co                 Electric repairs              $287.10                  Office Depot                              soccer                   $34.87
  Krudico                       Sample Shipping                $10.50                  Sherrie Hammond                           soccer                   $20.00
  Mangold Envir                 Water testing                  $48.00                  WalMart                                   soccer                  $219.69
  Martin's Welding              Repairs                       $161.16                  Uptown Sporting                           soccer                $1,118.00
  Mead, Kelly                   Fire Training                   $5.00                  Rec Total                                                       $3,089.56
  Office Depot                  Supplies                      $206.01
  Popular Mechanics             library                        $29.96
  Presto X Company              pest control                   $34.00
 
It has come to the attention of the council that rentals of the Community building space have dropped to almost zero, and persons are instead utilizing the fire 
station.  There is a charge of $40 to use the community building, but the city has received no revenue from use of the fire station to offset the tax payer’s 
utilities and other expenses.  The fire station is also not adequately insured for public use nor has council approved offering the use of the building to anyone. 
 
At the request of the Mayor, Fire Chief Randy Buse addressed the Council regarding personal use of the fire station by members of the department.  Chief Buse 
stated that he and his members donate a lot of time and personal expense to attend fires and meetings and that free use of the building for their families 
should be a “perk” for fire department personnel.  Council discussed this issue with Chief Buse; with several members of the audience also giving comment.  
Council noted that there are many other volunteers in our community performing countless hours of work at personal expense such as the Rec. Committee, 
Library Board and Historical Committee and expressed their need to treat all volunteers equally.  Mayor Beidler and Fire Chief Buse requested that the loud 
voice and offensive language cease.  A request was made by the fire department that they be given special treatment again or that they should be paid for the 
service they perform if they could not have special privileges.  It was also noted that section 721.2(5) of the IA Code prohibits use of public property for 
personal gain.  Council re‐iterated their position has having nothing against the fire department but rather a requirement to follow the law and treat all 
persons equally.  Council took no action following this listening session but will continue work on this issue. 
 
Council reviewed the kitchen, dining area and bathrooms in the basement of the community building.  The last work done in this space was in the mid 1980s 
and is badly in need of an update.  Motion by Finley, seconded by Mead to approve the bid of Clete’s Drywall and Painting in the amount of $7226.56 to 
renovate the kitchen and dining area.  Voting Aye:  Potthoff, Finley, Mead, King and Zimmerman.  Motion by Potthoff, seconded by King to approve the letter 
of support and application to the Sac County Endowment Foundation Grant for $3613 for the project.  All voted in the affirmative. 
 
Motion by King, seconded by Finley to approve Resolution 11‐07‐ A Resolution Setting Salary for Employee Angie Jergens:  Voting Aye: King, Potthoff, Mead, 
Zimmerman and Finley.                                                      RESOLUTION   11‐07 
A RESOLUTION SETTING SALARY FOR EMPLOYEE ANGIE JERGENS FOR THE CITY OF AUBURN, IOWA FOR THE 2011 SUMMER SEASON. 
It is hereby resolved, by the City Council of the City of Auburn, Iowa, that:   
            Effective on first day of employment the following persons and positions named shall be paid the salaries or wages indicated and that City Clerk is 
hereby authorized to issue payments, less legally required or authorized deductions in the amounts set forth below, bi‐weekly, and make such contributions to 
IPERS and Social Security or other persons by law or authorizations of the Council, all subject to audit and review by the Council; 
Part‐time Temporary Positions 
                                                                                                                                                   th
Groundskeeper           Angie Jergens          $   11.00 /hour                                                          Passed and approved this 11  day of April, 2011. 
No energy efficiency issues were discussed.  Motion by Potthoff, seconded by Zimmerman to approve a plan to purchase a city dump truck from the IDOT 
when one becomes available at a cost not to exceed $16000 and authorize Mead to act on the council’s behalf.  Voting Aye: Potthoff, Zimmerman, Finley, 
Mead and King.   
 
                                                                   th
Council set the City Wide Clean Up day for Wednesday, May 18 .  See newsletter and posters for details.  Motion by Zimmerman, seconded by Mead to 
approve replacement of the brine tank in the water plant with bid from Krudico in the amount of $6777.00.  Voting Aye: Zimmerman, Mead, Finley, Potthoff 
and King. 
 
Motion to approve Resolution 11‐08‐ A resolution setting charges for city services was made by King and seconded by Finley.  Voting Aye:  Potthoff, 
Zimmerman, Mead, King and Finley. 
                                                                          Resolution 11‐08 
                                    A RESOLUTION SETTING CHARGES FOR CITY SERVICES FOR THE CITY OF AUBURN, IOWA. 
It is hereby resolved, by the City Council of the City of Auburn, Iowa, that: Effective May 1, 2011, the following fees and charges will be assessed as stated 
below, all subject to audit and review by the Council; 
Service                                                                           Fee________________________________ 
Utility Billing Research                       $50.00 per hour                    Returned Check Fee  $30.00 Each 
Utility Door Tag Fee                           $25.00                             Copies      City Office $00.25  Library  $00.15 
Community Building or Shelter House            $40.00 per day plus $35 damage deposit 
Public Works Labor                             $75.00 hour                        Black Dirt  $50.00/ load 
Gravel/Sand                                    $50.00/load                        White Rock$75.00/load 
Tractor                                        $75.00 plus $65.00/hr‐City Operator            Dump Truck            $85.00 plus $65.00/hr‐City Operator 
Lawn Mowing                                    $50.00 plus $50.00/hr‐City Operator                        City owned equipment must be operated by City Employee.  
All rates are per hour with a one hour minimum charge, then quarter hour increments.  Cost of Fuel will be added. 
Bulk Water                                     $ 8.68 per 1000 Gallons plus 7% sales tax 
Garbage/Recycling‐                  Residential monthly  $ 7.75                   Commercial monthly  $ 5.00 
 
City Clerk gave council an update on some less than well documented easement issues.  Work is continuing by the City Attorney.  Mayor Beidler asked council 
members to put their thoughts regarding the fire station/fire department issue in writing to her and she will share them at the next meeting.  Reports were 
heard from several departments, committees and boards.  Motion to adjourn by Finley at 7:43 PM. 
 
                                                                                                          ____Linda Beidler, Mayor ______________ 
 
ATTEST: 
Nancy A. Janssen 
City Clerk 
 
                                                                                Current           Change          Operating        Amounts Held
          FUND                 Previous        Received       Disbursed           Fund          from Prev           Funds           In Long-Term
                               Balance                                          Balance           Month                            Investment(CD)
    GENERAL                   $23,033.29        $3,143.74      $6,005.58       $20,171.45        -$2,861.84         $5,071.03            $15,100.42
      LOST                    $12,844.60        $1,195.22           $0.00      $14,039.82         $1,195.22        $14,039.82
      Emply Ben Levy             -$386.86         $242.01         $976.10       -$1,120.95         -$734.09        -$1,120.95
      Emergency Levy              $569.61          $37.96           $0.00          $607.57           $37.96           $607.57
      Rec Committee           $21,430.36          $435.20      $1,131.99       $20,733.57          -$696.79         $3,920.75            $16,812.82
      Historical Comm.          $4,645.72           $0.00           $0.00        $4,645.72             $0.00        $4,645.72                  $0.00
     125th Celebration          $1,928.94           $0.00           $0.00        $1,928.94             $0.00        $1,928.94
     Library Trust              $6,788.56         $100.08           $0.00        $6,888.64          $100.08         $2,095.60             $4,793.04
    ROAD USE TAX              $17,865.88        $2,945.94      $1,998.13       $18,813.69           $947.81        $18,813.69                  $0.00
    WATER UTILITY            -$19,033.59        $5,877.18      $7,452.21      -$20,608.62        -$1,575.03       -$20,608.62                  $0.00
    SEWER Operating            -$3,988.00       $2,424.29      $2,359.34        -$3,923.05           $64.95        -$3,923.05
      Sinking Fund              $8,800.00       $1,100.00                        $9,900.00        $1,100.00         $9,900.00
      Reserve                   $6,130.85         $104.00                        $6,234.85          $104.00                               $6,234.85
    ELECTRIC UTILITY         $247,769.23      $20,274.28      $16,274.93      $251,768.58         $3,999.35        $61,425.97          $190,342.61
    GARBAGE/RECYCL.              -$255.16       $2,086.83      $1,008.40           $823.27        $1,078.43           $823.27                  $0.00
    TOTAL CASH               $328,143.43      $39,966.73      $37,206.68      $330,903.48         $2,760.05        $97,619.74          $233,283.74
 
                                                   City of Auburn
                                  Statement of Revenue and Expenditures5/9/2011                      9:30am              Page          1
                                                                 Revised Budget
                                                              For General Fund (001)
                                               For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                    Current            Current          Annual           YTD     Remaining
Account Number                                                      Budget              Actual          Budget         Actual     Budget %

Revenues
   Taxes Revenues
    General Revenues
    001-100-004-0001 Property Tax                                   2,542.75 $        9,794.20 $      30,513.00 $$   28,021.43       8.17%
    001-100-004-0003 Ag Land Tax                                       35.33            178.45           424.00         425.26     (0.30%)
    001-100-004-0005 Utility Replacement Tax                          338.75          1,677.93         4,065.00       3,689.19       9.25%
    001-100-004-0006 FICA /Ipers/Empl Benefit Levy                      0.00            594.76             0.00       1,570.86       0.00%
    001-100-004-0007 Liab Ins Levy                                    604.08          2,326.79         7,249.00       6,640.20       8.40%
    001-100-004-0008 Emergency Levy                                     0.00              0.00             0.00           0.00       0.00%
    001-100-004-1000 Local Option Sales Tax                             0.00              0.00             0.00           0.00       0.00%
    001-100-004-1006 Cable Franchise                                   83.33            273.10         1,000.00       1,175.37    (17.54%)
    Total General Revenues                                          3,604.24         14,845.23        43,251.00      41,522.31       4.00%
   Total Taxes Revenues                                             3,604.24         14,845.23        43,251.00      41,522.31       4.00%

   Licenses/Permits Revenues
    General Revenues
    001-200-004-1005 Cigarette Permits                                 0.00                0.00           75.00          0.00      100.00%
    001-200-004-1100 Beer & Liquor Permits                             0.00                0.00          500.00        465.00        7.00%
    001-200-004-1200 Pet License                                     125.00                0.00          500.00        410.00       18.00%
    Total General Revenues                                           125.00                0.00        1,075.00        875.00       18.60%
   Total Licenses/Permits Revenues                                   125.00                0.00        1,075.00        875.00       18.60%

   Use of Money/Property Revenues
    General Revenues
    001-300-004-1001 Audit Assessment Fee                              0.00               0.00         3,000.00       3,265.31     (8.84%)
    001-300-004-1310 Park Rent                                        83.33             120.00         1,000.00         480.00     52.00%
    001-300-004-1311 Community Bldg Rent                             108.33             122.00         1,300.00         980.00     24.62%
    001-300-004-4800 Interest- Checking/ CD                           37.50              18.31           450.00         277.78     38.27%
    Total General Revenues                                           229.16             260.31         5,750.00       5,003.09     12.99%
   Total Use of Money/Property Revenues                              229.16             260.31         5,750.00       5,003.09      12.99%

   Intergovernmental Revenues
    General Revenues
    001-400-004-1340 Reimbursements                                   41.67               8.99           500.00         458.52       8.30%
    001-400-004-1341 Township Fire Dept Reimbursement                  0.00             441.20         2,900.00       2,379.12      17.96%
    001-400-004-1342 Other Misc. Revenue                              41.67               0.00           500.00          30.00      94.00%
    001-400-004-1343 Donations                                    16,666.67               0.00       200,000.00         100.00      99.95%
    001-400-004-1344 Ice Storm/Debris Assistance Grant                 0.00               0.00             0.00       9,414.69       0.00%
    001-400-004-1500 Economic Development                              0.00               0.00             0.00           0.00       0.00%
    001-400-004-1501 Project Grant Revenue                             0.00               0.00             0.00           0.00       0.00%
    Total General Revenues                                        16,750.01             450.19       203,900.00      12,382.33      93.93%
   Total Intergovernmental Revenues                               16,750.01             450.19       203,900.00      12,382.33      93.93%
                                                     City of Auburn
                                    Statement of Revenue and Expenditures5/9/2011                       9:30am              Page           2
                                                                    Revised Budget
                                                                 For General Fund (001)
                                                  For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                       Current            Current          Annual           YTD     Remaining
Account Number                                                         Budget              Actual          Budget         Actual     Budget %

   Culture/Recreation Revenues
     Library Trust Revenues
     001-401-400-1476 Library Trust Revenue                                0.00               0.09            0.00        264.27        0.00%
     Total Library Trust Revenues                                          0.00               0.09            0.00        264.27        0.00%

     Library Revenues
     001-401-401-1470 Library-County Funding                              0.00            3,326.50       13,306.00       9,979.50      25.00%
     001-401-401-1472 Library-other State Funds                          50.00                0.00          600.00         489.26      18.46%
     001-401-401-1476 Library-Misc Revenue                                0.00                0.00            0.00           0.00       0.00%
     Total Library Revenues                                              50.00            3,326.50       13,906.00      10,468.76      24.72%

     Recreation Committee Revenues
     001-401-404-1343 Rec CD Interest                                    12.50               0.00           150.00         159.79      (6.53%)
     001-401-404-4500 Soccer                                              0.00               0.00         3,000.00       3,290.00      (9.67%)
     001-401-404-4510 Soccer Donations                                    0.00               0.00             0.00          25.00        0.00%
     001-401-404-4530 Other Donations/Fund Raising                        0.00              20.00             0.00          20.00        0.00%
     001-401-404-4540 Concession Revenue                                750.00             494.75         1,500.00         494.75      67.02%
     001-401-404-4600 Baseball                                            0.00               0.00             0.00           0.00        0.00%
     001-401-404-4610 Baseball Donations                                  0.00               0.00             0.00           0.00        0.00%
     001-401-404-4700 Other Revenue/Activites                            83.33               0.00         1,000.00           0.00     100.00%
     001-401-404-4800 Interest on Checking Account                        2.08               0.12            25.00           3.51      85.96%
     Total Recreation Committee Revenues                                847.91             514.87         5,675.00       3,993.05      29.64%

     Historical Committee Revenues
     001-401-405-4530 Historical Revenue                                383.33                0.00        4,600.00       2,439.65      46.96%
     Total Historical Committee Revenues                                383.33                0.00        4,600.00       2,439.65      46.96%

     125th Celebration Revenues
     001-401-406-4530 125th --Donations/Fund Raising                       0.00             25.00             0.00       3,134.35       0.00%
     Total 125th Celebration Revenues                                      0.00             25.00             0.00       3,134.35       0.00%
   Total Culture/Recreation Revenues                                   1,281.24           3,866.46       24,181.00      20,300.08      16.05%

   General Government Revenues
     Finance Revenues
     001-600-600-1340 Sale of Property                                     0.00               0.00            0.00           0.00       0.00%
     Total Finance Revenues                                                0.00               0.00            0.00           0.00       0.00%
   Total General Government Revenues                                       0.00               0.00            0.00           0.00       0.00%

   Transfers In Revenues
     General Revenues
     001-901-004-9000 Transfer In                                          0.00               0.00            0.00       3,973.25       0.00%
     Total General Revenues                                                0.00               0.00            0.00       3,973.25       0.00%
   Total Transfers In Revenues                                             0.00               0.00            0.00       3,973.25       0.00%
Total General Fund Revenues                                          21,989.65 $        19,422.19 $     278,157.00 $$   84,056.06      69.78%
                                                       City of Auburn
                                      Statement of Revenue and Expenditures5/9/2011                      9:30am             Page           3
                                                                     Revised Budget
                                                                  For General Fund (001)
                                                   For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                        Current            Current         Annual           YTD     Remaining
Account Number                                                          Budget              Actual         Budget         Actual     Budget %

Expenditures
   Public Safety Expenditures
     General Expenditures
     001-101-004-6310 Fire-Building Maint/Repair                          41.67 $              0.00 $       500.00 $$      173.89      65.22%
     001-101-004-6406 Fire- Liability Insurance                            0.00                0.00         650.00           0.00     100.00%
     001-101-004-6407 Fire-Work Comp Insurance                             0.00                0.00       2,000.00           0.00     100.00%
     001-101-004-6408 Fire Dept-Property Insurance                         0.00                0.00       1,200.00           0.00     100.00%
     001-101-004-6410 Fire-Vehicle Insurance                               0.00                0.00       1,800.00       1,084.00      39.78%
     Total General Expenditures                                           41.67                0.00       6,150.00       1,257.89      79.55%

     Fire Expenditures
     001-101-101-6230 Fire-Training                                        8.33              412.35         100.00       1,037.59   (937.59%)
     001-101-101-6331 Fire-Vehicle Operations                             83.33               47.05       1,000.00         339.99      66.00%
     001-101-101-6332 Fire-Vehicle Repairs                                83.33                0.00       1,000.00         293.32      70.67%
     001-101-101-6350 Fire-Operational Equipment Repair                  166.67                0.00       2,000.00         934.50      53.28%
     001-101-101-6351 Fire Equipment- New                                141.25              770.00       1,695.00       2,111.45    (24.57%)
     001-101-101-6352 Fire- Misc. Exp                                     16.67                0.00         200.00          20.50      89.75%
     Total Fire Expenditures                                             499.58            1,229.40       5,995.00       4,737.35      20.98%

     Police Expenditures
     001-101-102-6406 Police-Liability Insurance                            0.00               0.00         150.00           0.00     100.00%
     001-101-102-6413 Police 28E agreement                              3,875.00           3,469.50      15,500.00      13,878.00      10.46%
     Total Police Expenditures                                          3,875.00           3,469.50      15,650.00      13,878.00      11.32%

     Pet Ordinance Expenditures
     001-101-103-6402 Pet License                                         25.00                0.00         300.00        302.02       (0.67%)
     001-101-103-6403 Pet Ordinance Enforcement                           16.67                0.00         200.00          0.00      100.00%
     Total Pet Ordinance Expenditures                                     41.67                0.00         500.00        302.02       39.60%

     Ice Storm Debris Operations Expenditures
     001-101-104-6331 Ice Storm Debris Operations                           0.00               0.00           0.00           0.00       0.00%
     Total Ice Storm Debris Operations Expenditures                         0.00               0.00           0.00           0.00       0.00%
   Total Public Safety Expenditures                                     4,457.92           4,698.90      28,295.00      20,175.26      28.70%

   Pubilc Works Expenditures
     General Expenditures
     001-201-004-6379 Storm Sewer                                         41.67                0.00         500.00         120.00      76.00%
     001-201-004-6399 Vegetation Management                                0.00                0.00           0.00       1,220.00       0.00%
     Total General Expenditures                                           41.67                0.00         500.00       1,340.00   (168.00%)

     Shop Expenditures
     001-201-201-6310 Shop-Building Maint/Repair                          41.67                0.00         500.00           0.00     100.00%
     001-201-201-6331 Shop-Vehicle Operations                            333.33             321.98        4,000.00       2,550.63      36.23%
     001-201-201-6332 Shop-Vehicle Repairs                               333.33             (24.05)       4,000.00       2,149.60      46.26%
     001-201-201-6408 Shop-Insurance Expense                               0.00                0.00       2,200.00           0.00     100.00%
     001-201-201-6499 Shop-Cell Phone                                     58.33               48.22         700.00         482.06      31.13%
                                                      City of Auburn
                                     Statement of Revenue and Expenditures5/9/2011                     9:30am         Page           4
                                                                   Revised Budget
                                                                For General Fund (001)
                                                 For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                      Current            Current         Annual       YTD     Remaining
Account Number                                                        Budget              Actual         Budget     Actual     Budget %
    001-201-201-6505 Shop Misc.                                           8.33              0.00          100.00       1.70      98.30%
    001-201-201-6507 Shop-Operating Supplies                            250.00            152.32        3,000.00   1,532.85      48.91%
    Total Shop Expenditures                                           1,024.99            498.47       14,500.00   6,716.84      53.68%
   Total Pubilc Works Expenditures                                    1,066.66            498.47       15,000.00   8,056.84      46.29%

   Health/Social Services Expenditures
    General Expenditures
    001-301-004-6499 Mosquito Control                                     0.00               0.00         825.00    825.00        0.00%
    Total General Expenditures                                            0.00               0.00         825.00    825.00        0.00%
   Total Health/Social Services Expenditures                              0.00               0.00         825.00    825.00        0.00%

   Culture/Recreation Expenditures
    General Expenditures
    001-401-000-6310 Rec-Building Maint/Repair                          41.67             292.72          500.00    420.70       15.86%
    001-401-000-6320 Rec-Grounds Maint/Repair                           41.67               0.00          500.00      0.00      100.00%
    001-401-000-6371 Rec-Gas/Elect Expense                               0.00              81.59        1,000.00    416.64       58.34%
    001-401-000-6406 Rec-Liability Insurance                             0.00               0.00          100.00      0.00      100.00%
    001-401-000-6408 Rec-Property Insurance                              0.00               0.00          550.00      0.00      100.00%
    001-401-000-6499 Rec-Annual Payment                                  0.00               0.00          200.00      0.00      100.00%
    001-401-000-6599 Supplies                                           50.00               0.00          100.00      4.70       95.30%
    Total General Expenditures                                         133.34             374.31        2,950.00    842.04       71.46%

    General Expenditures
    001-401-004-6310 Library-Building Maint/Repair                      83.33               0.00        1,000.00     232.84      76.72%
    001-401-004-6371 Library-Gas/Elect Expense                         291.67             244.73        3,500.00   1,378.84      60.60%
    001-401-004-6373 Library-Telecommunications Expense                 50.00              62.91          600.00     630.22      (5.04%)
    001-401-004-6406 Library-Liability Insurance                         0.00               0.00          300.00       0.00     100.00%
    001-401-004-6408 Library-Property Insurance Expense                  0.00               0.00        1,400.00       0.00     100.00%
    001-401-004-6409 Janitorial Expense-                                25.00               0.00          300.00      70.94      76.35%
    001-401-004-6500 Computer Purchase                                   0.00               0.00            0.00       0.00        0.00%
    Total General Expenditures                                         450.00             307.64        7,100.00   2,312.84      67.42%

    General Expenditures
    001-401-005-6310 Historical-Bldg Maintenance/Renovations             0.00               0.00            0.00      4.18        0.00%
    001-401-005-6371 Historical-Utility Expense                        166.67             163.15        2,000.00    843.13       57.84%
    001-401-005-6406 Historical-Liability Insurance                      0.00               0.00          200.00      0.00      100.00%
    001-401-005-6408 Historical-Property Insurance Expense               0.00               0.00          500.00      0.00      100.00%
    Total General Expenditures                                         166.67             163.15        2,700.00    847.31       68.62%

    Library Trust Expenditures
    001-401-400-6505 Library Trust Expense                                0.00               0.00           0.00    713.00        0.00%
    Total Library Trust Expenditures                                      0.00               0.00           0.00    713.00        0.00%

    Library Expenditures
    001-401-401-6020 Library-Wages-Part Time                           750.00             671.85        9,000.00   7,195.43      20.05%
    001-401-401-6110 Library-FICA                                       58.33              52.18          700.00     517.93      26.01%
    001-401-401-6130 Library-IPERS                                      50.00              46.86          600.00     470.30      21.62%
                                                    City of Auburn
                                   Statement of Revenue and Expenditures5/9/2011                      9:30am          Page          5
                                                                  Revised Budget
                                                               For General Fund (001)
                                                For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                     Current            Current         Annual        YTD     Remaining
Account Number                                                       Budget              Actual         Budget      Actual     Budget %
    001-401-401-6407 Library-Work Comp Insurance                         0.00               0.00          35.00        0.00     100.00%
    001-401-401-6500 Computer Expense                                   20.83               0.00         250.00      583.88   (133.55%)
    001-401-401-6501 Programming                                        20.83               0.00         250.00       38.00      84.80%
    001-401-401-6502 Library-Books                                     232.42             373.23       2,789.00    2,692.77        3.45%
    001-401-401-6503 Library-Magazines/Newspaper                        41.67              87.96         500.00      506.67      (1.33%)
    001-401-401-6504 Library-Video                                      41.67               0.00         500.00      357.11      28.58%
    001-401-401-6505 Library-Other Materials-Supplies                   20.83              39.19         250.00      559.71   (123.88%)
    001-401-401-6508 Postage/Shipping                                   16.67              14.67         200.00       82.43      58.79%
    001-401-401-6510 Training-Mileage                                   20.83               0.00         250.00        0.00     100.00%
    Total Library Expenditures                                       1,274.08           1,285.94      15,324.00   13,004.23      15.14%

    Parks Expenditures
    001-401-402-6020 Parks Wages-Part Time                            416.67               0.00        2,500.00    1,823.79      27.05%
    001-401-402-6110 Parks FICA                                         0.00               0.00          140.00      160.50    (14.64%)
    001-401-402-6320 Parks-Grounds Maint/Repair                       250.00             193.69        3,000.00    1,198.15      60.06%
    001-401-402-6371 Parks-Gas/Elect Expense                           83.33               0.00        1,000.00      247.86      75.21%
    001-401-402-6406 Parks-Liability Insurance                          0.00               0.00          125.00        0.00    100.00%
    001-401-402-6407 Parks-Work Comp Insurance                          0.00               0.00          150.00        0.00    100.00%
    001-401-402-6408 Parks-Property Insurance Expense                   0.00               0.00          450.00        0.00    100.00%
    001-401-402-6505 Parks- Equipment                                  41.67               0.00          500.00      281.00      43.80%
    001-401-402-6599 Parks-Supplies                                    41.67               0.00          500.00      203.38      59.32%
    Total Parks Expenditures                                          833.34             193.69        8,365.00    3,914.68      53.20%

    Community Bldg Expenditures
    001-401-403-6020 Comm Bldg-Wages-Part Time                          0.00               6.65          375.00      358.66       4.36%
    001-401-403-6110 Comm Bldg-FICA                                    12.50               8.99           50.00       47.50       5.00%
    001-401-403-6310 Comm Building Maint/Repair                       666.67              21.78        8,000.00    1,502.84      81.21%
    001-401-403-6371 Comm Bldg Gas/Elect Expense                       41.67             244.73          500.00    1,378.99   (175.80%)
    001-401-403-6406 Comm Bldg-Liability Insurance                      0.00               0.00          275.00        0.00     100.00%
    001-401-403-6407 Comm Bldg-Work Comp Insurance                      0.00               0.00           50.00        0.00     100.00%
    001-401-403-6408 Comm Bldg-Property Insurance Expense               0.00               0.00          600.00        0.00     100.00%
    001-401-403-6499 Comm Bldg- pest control- Contractural             37.50              34.00          450.00      340.00      24.44%
    001-401-403-6599 Comm Bldg -Supplies                               16.67               0.00          200.00      329.74    (64.87%)
    Total Community Bldg Expenditures                                 775.01             316.15       10,500.00    3,957.73      62.31%

    Recreation Committee Expenditures
    001-401-404-6352 Transfer to reserve                                 0.00               0.00           0.00    5,000.00       0.00%
    001-401-404-6401 Soccer                                          1,000.00           1,777.56       3,000.00    3,878.31    (29.28%)
    001-401-404-6402 Baseball                                            0.00               0.00           0.00        0.00       0.00%
    001-401-404-6403 Donations                                          20.83               0.00         250.00       25.00      90.00%
    001-401-404-6404 Fall Festival Expense                               0.00               0.00         250.00      316.98    (26.79%)
    001-401-404-6405 Santa Expense                                       0.00               0.00       1,000.00      296.64      70.34%
    001-401-404-6410 Postage                                             2.08               0.00          25.00        8.80      64.80%
    001-401-404-6414 Easter Expense                                    250.00             153.07         250.00      153.07      38.77%
    001-401-404-6506 Concession Supplies                               500.00             347.76       1,500.00      413.98      72.40%
    001-401-404-6599 Rec-Supplies                                      112.50               0.00       1,350.00        0.00    100.00%
    Total Recreation Committee Expenditures                          1,885.41           2,278.39       7,625.00   10,092.78    (32.36%)
                                                    City of Auburn
                                   Statement of Revenue and Expenditures5/9/2011                      9:30am           Page          6
                                                                  Revised Budget
                                                               For General Fund (001)
                                                For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                     Current            Current          Annual        YTD     Remaining
Account Number                                                       Budget              Actual          Budget      Actual     Budget %

    Historical Committee Expenditures
    001-401-405-6310 Historical-Building Renovation                   833.33                0.00       10,000.00    9,050.00       9.50%
    001-401-405-6599 Supplies                                         125.00                0.00        1,500.00    1,127.83      24.81%
    Total Historical Committee Expenditures                           958.33                0.00       11,500.00   10,177.83      11.50%

    125th Celebration Expenditures
    001-401-406-6403 125th Celebration Fund Raising                      0.00               0.00            0.00    1,180.41       0.00%
    Total 125th Celebration Expenditures                                 0.00               0.00            0.00    1,180.41       0.00%
   Total Culture/Recreation Expenditures                             6,476.18           4,919.27       66,064.00   47,042.85      28.79%

   Community/Economic Develeopment Expenditures
    General Expenditures
    001-500-004-6320 Beautification--Grounds Maint/Repair           4,166.67                0.00       50,000.00      457.25      99.09%
    001-500-004-7000 Capitol Projects                               8,333.33                0.00      100,000.00    1,388.00      98.61%
    001-500-004-8000 Economic Development                           4,166.67                0.00       50,000.00      296.00      99.41%
    Total General Expenditures                                     16,666.67                0.00      200,000.00    2,141.25      98.93%
   Total Community/Economic Develeopment Expenditures              16,666.67                0.00      200,000.00    2,141.25      98.93%

   General Government Expenditures
    General Expenditures
    001-600-004-6240 Banking Mileage & Fees                             62.50             60.20           750.00      512.74      31.63%
    001-600-004-6373 Telecommunications Expense                         83.33             62.92         1,000.00      660.55      33.95%
    001-600-004-6405 Court & Recording Expense                           4.17              0.00            50.00       72.50    (45.00%)
    001-600-004-6406 Liability Insurance                                 0.00              0.00         1,000.00        0.00    100.00%
    001-600-004-6408 Bond-Misc. Insurance                              350.00              0.00           350.00        0.00    100.00%
    001-600-004-6411 Legal Expense                                     291.67            437.50         3,500.00    1,471.25      57.96%
    001-600-004-6414 Publishing Expense                                 91.67             96.00         1,100.00      500.12      54.53%
    001-600-004-6490 Elections                                           0.00              0.00             0.00        0.00       0.00%
    001-600-004-6499 Donations/Contributions                            16.67              0.00           200.00      125.00      37.50%
    001-600-004-6505 Other Equipment                                    41.67              0.00           500.00       75.00      85.00%
    001-600-004-6506 Office Supplies                                   291.67            206.01         3,500.00    2,463.96      29.60%
    001-600-004-6508 Postage/Shipping                                   35.42              0.00           425.00      187.99      55.77%
    001-600-004-6699 Other Gen Govt Exp                              1,166.67             20.40        14,000.00    9,413.25      32.76%
    Total General Expenditures                                       2,435.44            883.03        26,375.00   15,482.36      41.30%

    Clerk Expenditures
    001-600-601-6010 Clerk Wages                                       752.50             778.57        9,030.00    7,739.16      14.30%
    001-600-601-6110 Clerk-FICA                                         58.33              55.59          700.00      581.59      16.92%
    001-600-601-6130 Clerk-IPERS                                        52.08              49.92          625.00      519.39      16.90%
    001-600-601-6140 Pmt in Lieu of Health Ins                          87.50              52.50        1,050.00      525.00      50.00%
    001-600-601-6210 Clerk-Association Dues                             12.50               0.00          150.00       65.00      56.67%
    001-600-601-6230 Clerk-Training                                     29.17               0.00          350.00      320.00       8.57%
    001-600-601-6240 Clerk-Meetings & Conferences                      125.00             244.29        1,500.00      656.95      56.20%
    001-600-601-6407 Clerk-Work Comp Insurance                           0.00               0.00          100.00        0.00     100.00%
    Total Clerk Expenditures                                         1,117.08           1,180.87       13,505.00   10,407.09      22.94%
                                                       City of Auburn
                                      Statement of Revenue and Expenditures5/9/2011                 9:30am               Page              7
                                                                Revised Budget
                                                             For General Fund (001)
                                              For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                   Current            Current          Annual             YTD       Remaining
Account Number                                                     Budget              Actual          Budget           Actual       Budget %

     Mayor/Council Expenditures
     001-600-602-6020 Mayor/Council-Wages                           333.33              53.81         4,000.00        2,136.84         46.58%
     001-600-602-6110 Mayor/Council-FICA                             25.00              55.65           300.00          218.02         27.33%
     001-600-602-6130 Mayor/Council-IPERS                             6.25              19.07            75.00           79.47         (5.96%)
     001-600-602-6210 Mayor/Council-Association Dues                 20.83               0.00           250.00          217.00         13.20%
     001-600-602-6240 Mayor/Council-Meetings & Conferences           54.17              20.40           650.00          205.26         68.42%
     001-600-602-6407 Mayor/Council-Work Comp Insurance               0.00               0.00            20.00            0.00        100.00%
     Total Mayor/Council Expenditures                               439.58             148.93         5,295.00        2,856.59         46.05%
   Total General Government Expenditures                           3,992.10           2,212.83       45,175.00       28,746.04         36.37%

   Transfers Out Expenditures
     General Expenditures
     001-900-004-9001 Transfer to Reserve                              0.00               0.00            0.00       15,000.00          0.00%
     Total General Expenditures                                        0.00               0.00            0.00       15,000.00          0.00%
   Total Transfers Out Expenditures                                    0.00               0.00            0.00       15,000.00          0.00%
Total General Fund Expenditures                                  32,659.53 $        12,329.47 $     355,359.00 $$   121,987.24         65.67%
General Fund Excess of Revenues Over Expenditures       $       (10,669.88)           7,092.72 $    (77,202.00) $   (37,931.18) $      50.87%
                                                    City of Auburn
                                   Statement of Revenue and Expenditures5/9/2011                       9:30am             Page            8
                                                                   Revised Budget
                                                       For Local Option Sales Tax Fund (002)
                                                 For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                      Current            Current         Annual           YTD       Remaining
Account Number                                                        Budget              Actual         Budget         Actual       Budget %

Revenues
   Taxes Revenues
     General Revenues
     002-100-004-1000 Local Option Sales Tax                          1,416.67 $         1,195.22 $    17,000.00 $$   15,235.04        10.38%
     Total General Revenues                                           1,416.67           1,195.22      17,000.00      15,235.04        10.38%
   Total Taxes Revenues                                               1,416.67           1,195.22      17,000.00      15,235.04        10.38%
Total Local Option Sales Tax Fund Revenues                            1,416.67 $         1,195.22 $    17,000.00 $$   15,235.04        10.38%

Expenditures
   Taxes Expenditures
     General Expenditures
     002-100-004-9002 Transfer to General Fund                         626.33 $              0.00 $     7,516.00 $$        0.00       100.00%
     Total General Expenditures                                        626.33                0.00       7,516.00           0.00       100.00%
   Total Taxes Expenditures                                            626.33                0.00       7,516.00           0.00       100.00%
Total Local Option Sales Tax Fund Expenditures                         626.33 $              0.00 $     7,516.00 $$        0.00       100.00%
Local Option Sales Tax Fund Excess of Revenues Over        $           790.34            1,195.22 $     9,484.00 $    15,235.04 $    (60.64%)
                                                      City of Auburn
                                     Statement of Revenue and Expenditures5/9/2011                      9:30am                Page          9
                                                                  Revised Budget
                                                         For Employee Benefits Levy (003)
                                                For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                     Current            Current             Annual            YTD     Remaining
Account Number                                                       Budget              Actual             Budget          Actual     Budget %

Revenues
   Taxes Revenues
     General Revenues
     003-100-004-0006 FICA/Ipers/Emply Benefit Levy                   540.33 $          2,369.58 $          6,484.00 $$    6,197.98       4.41%
     Total General Revenues                                           540.33            2,369.58            6,484.00       6,197.98       4.41%
   Total Taxes Revenues                                               540.33            2,369.58            6,484.00       6,197.98       4.41%
Total Employee Benefits Levy Revenues                                 540.33 $          2,369.58 $          6,484.00 $$    6,197.98       4.41%

Expenditures
   Pubilc Works Expenditures
     General Expenditures
     003-201-004-9002 Transfer to General- PW                         208.33 $           238.41 $           2,500.00 $$    2,133.28      14.67%
     Total General Expenditures                                       208.33             238.41             2,500.00       2,133.28      14.67%
   Total Pubilc Works Expenditures                                    208.33             238.41             2,500.00       2,133.28      14.67%

   Culture/Recreation Expenditures
     General Expenditures
     003-401-004-9002 Transfer to General-Culture/Rec.                148.67             145.92             1,784.00       1,408.59      21.04%
     Total General Expenditures                                       148.67             145.92             1,784.00       1,408.59      21.04%
   Total Culture/Recreation Expenditures                              148.67             145.92             1,784.00       1,408.59      21.04%

   General Government Expenditures
     General Expenditures
     003-601-004-9002 Transfer to General-Gen Govt                    183.33             210.43             2,200.00       2,002.24       8.99%
     Total General Expenditures                                       183.33             210.43             2,200.00       2,002.24       8.99%
   Total General Government Expenditures                              183.33             210.43             2,200.00       2,002.24       8.99%
Total Employee Benefits Levy Expenditures                             540.33 $           594.76 $           6,484.00 $$    5,544.11      14.50%
Employee Benefits Levy Excess of Revenues Over Expenditures                 $               0.00 1,774.82         $ 0.00         $ 653.87       $
 0.00%
                                                     City of Auburn
                                    Statement of Revenue and Expenditures5/9/2011                      9:30am          Page           10
                                                                   Revised Budget
                                                             For Emergency Levy (004)
                                                 For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                      Current            Current         Annual         YTD      Remaining
Account Number                                                        Budget              Actual         Budget       Actual      Budget %

Revenues
   Taxes Revenues
     General Revenues
     004-100-004-0008 Emergency Levy                                    84.75 $           371.66 $      1,017.00 $$   979.23         3.71%
     Total General Revenues                                             84.75             371.66        1,017.00      979.23         3.71%
   Total Taxes Revenues                                                 84.75             371.66        1,017.00      979.23         3.71%
Total Emergency Levy Revenues                                           84.75 $           371.66 $      1,017.00 $$   979.23         3.71%

Expenditures
   Taxes Expenditures
     General Expenditures
     004-100-004-9002 Transfer to General Fund                          84.75 $              0.00 $     1,017.00 $$     0.00       100.00%
     Total General Expenditures                                         84.75                0.00       1,017.00        0.00       100.00%
   Total Taxes Expenditures                                             84.75                0.00       1,017.00        0.00       100.00%
Total Emergency Levy Expenditures                                       84.75 $              0.00 $     1,017.00 $$     0.00       100.00%
Emergency Levy Excess of Revenues Over Expenditures        $              0.00            371.66 $          0.00 $    979.23 $       0.00%
                                                      City of Auburn
                                     Statement of Revenue and Expenditures5/9/2011                   9:30am              Page           11
                                                                 Revised Budget
                                                             For Road Use Tax (110)
                                               For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                    Current            Current          Annual           YTD       Remaining
Account Number                                                      Budget              Actual          Budget         Actual       Budget %

Revenues
   Intergovernmental Revenues
     General Revenues
     110-400-004-1430 Road Use Tax                                  2,281.67 $         2,092.75 $     27,380.00 $$   24,101.44        11.97%
     110-400-004-1431 Road Use-Ijobs                                  107.75               0.00        1,293.00       1,573.05      (21.66%)
     Total General Revenues                                         2,389.42           2,092.75       28,673.00      25,674.49        10.46%
   Total Intergovernmental Revenues                                 2,389.42           2,092.75       28,673.00      25,674.49        10.46%
Total Road Use Tax Revenues                                         2,389.42 $         2,092.75 $     28,673.00 $$   25,674.49        10.46%

Expenditures
   Pubilc Works Expenditures
     General Expenditures
     110-201-004-6010 Road Use-Wages                                  962.50 $           993.31 $     11,550.00 $$   10,092.18        12.62%
     110-201-004-6110 FICA                                             98.75             108.84        1,185.00         869.53        26.62%
     110-201-004-6130 IPERS                                            66.67              61.00          800.00         735.87         8.02%
     110-201-004-6140 Pmt in Lieu of Health Ins.                       75.00              45.00          900.00         450.00        50.00%
     110-201-004-6379 Road Use-Storm Sewer                             41.67               0.00          500.00         110.00        78.00%
     110-201-004-6380 Road Use Tax-Street Lights                      375.00             390.00        4,500.00       3,290.00        26.89%
     110-201-004-6407 Road Use-Work Comp Insurance                      0.00               0.00          700.00          20.70        97.04%
     110-201-004-6417 Street Maintenance Expense                    1,250.00               0.00       15,000.00           0.00       100.00%
     110-201-004-6599 Supplies                                         20.83               0.00          250.00         171.96        31.22%
     110-201-004-7000 Qualified IJOBs                                 107.75               0.00        1,293.00           0.00       100.00%
     Total General Expenditures                                     2,998.17           1,598.15       36,678.00      15,740.24        57.09%

     Snow Expenditures
     110-201-202-6030 Snow-Hourly Wages                                0.00               0.00         2,000.00         520.25        73.99%
     110-201-202-6110 Snow-FICA                                       37.50               0.00           150.00           0.00       100.00%
     110-201-202-6331 Vehicle Operations                              83.33               0.00         1,000.00         833.35        16.67%
     110-201-202-6350 Operational Equipment Repair                    83.33             161.16         1,000.00         161.16        83.88%
     110-201-202-6407 Snow-Work Comp Insurance                         0.00               0.00            50.00           0.00       100.00%
     Total Snow Expenditures                                         204.16             161.16         4,200.00       1,514.76        63.93%
   Total Pubilc Works Expenditures                                  3,202.33           1,759.31       40,878.00      17,255.00        57.79%
Total Road Use Tax Expenditures                                     3,202.33 $         1,759.31 $     40,878.00 $$   17,255.00        57.79%
Road Use Tax Excess of Revenues Over Expenditures        $          (812.91)            333.44 $     (12,205.00) $    8,419.49 $     168.98%
                                                      City of Auburn
                                     Statement of Revenue and Expenditures5/9/2011                   9:30am             Page            12
                                                                 Revised Budget
                                                               For Water Fund (600)
                                               For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                    Current            Current         Annual           YTD       Remaining
Account Number                                                      Budget              Actual         Budget         Actual       Budget %

Revenues
   Enterprise-Water Revenues
     Charges for Servic Revenues
     600-810-001-1001 Sales                                         5,750.00 $         5,862.84 $    69,000.00 $$   59,294.24        14.07%
     600-810-001-1002 Utility Deposits                                 41.67              50.00         500.00         600.00      (20.00%)
     600-810-001-1003 Sales Tax                                       366.67               0.00       4,400.00          18.32        99.58%
     600-810-001-1340 Recovered & Misc Revenue                          0.00               0.00           0.00         453.42         0.00%
     Total Charges for Servic Revenues                              6,158.34           5,912.84      73,900.00      60,365.98        18.31%
   Total Enterprise-Water Revenues                                  6,158.34           5,912.84      73,900.00      60,365.98        18.31%
Total Water Fund Revenues                                           6,158.34 $         5,912.84 $    73,900.00 $$   60,365.98        18.31%

Expenditures
   Enterprise-Water Expenditures
     Charges for Servic Expenditures
     600-810-001-6010 Water Wages-Full Time                         1,439.17 $         1,362.27 $    17,270.00 $$   15,061.90        12.79%
     600-810-001-6110 FICA                                            135.50             140.74       1,626.00       1,228.12        24.47%
     600-810-001-6130 IPERS                                           100.17             126.39       1,202.00       1,093.52          9.02%
     600-810-001-6140 pmt in Lieu of Health ins.                      112.50              67.50       1,350.00         675.00        50.00%
     600-810-001-6230 Water-Training                                   41.67               0.00         500.00         310.00        38.00%
     600-810-001-6350 Operational Equipment Repair                    833.33               0.00      10,000.00       3,032.80        69.67%
     600-810-001-6399 Other Maintenance & Repair                      541.67              16.20       6,500.00       2,410.06        62.92%
     600-810-001-6406 Liability Insurance                               0.00               0.00         350.00           0.00       100.00%
     600-810-001-6407 Water-Work Comp Insurance                         0.00               0.00         500.00          20.70        95.86%
     600-810-001-6408 Property Insurance Expense                        0.00               0.00         700.00           0.00       100.00%
     600-810-001-6418 Tax Expense                                     366.67             386.93       4,400.00       3,824.53        13.08%
     600-810-001-6490 Water-Testing                                    83.33              48.00       1,000.00         806.30        19.37%
     600-810-001-6499 Water Tower Contract                          1,113.09             596.08      13,357.02      12,164.86          8.93%
     600-810-001-6501 Chemicals/Salt/Chlorine                         666.67               0.00       8,000.00       8,398.70        (4.98%)
     600-810-001-6508 Billing/Postage/Shipping                         41.67              10.50         500.00         489.21          2.16%
     600-810-001-6700 Utility Deposit Refund                           41.67               0.00         500.00         275.00        45.00%
     Total Charges for Servic Expenditures                          5,517.11           2,754.61      67,755.02      49,790.70        26.51%
   Total Enterprise-Water Expenditures                              5,517.11           2,754.61      67,755.02      49,790.70        26.51%
Total Water Fund Expenditures                                       5,517.11 $         2,754.61 $    67,755.02 $$   49,790.70        26.51%
Water Fund Excess of Revenues Over Expenditures          $           641.23            3,158.23 $     6,144.98 $    10,575.28 $    (72.10%)
                                                    City of Auburn
                                   Statement of Revenue and Expenditures5/9/2011                     9:30am             Page           13
                                                                 Revised Budget
                                                              For Sewer Fund (610)
                                               For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                    Current            Current         Annual           YTD       Remaining
Account Number                                                      Budget              Actual         Budget         Actual       Budget %

Revenues
   Enterprise-Sewer Revenues
     General Revenues
     610-815-000-1343 CD Investment Interest                            0.00 $             0.00 $         0.00 $$        0.00         0.00%
     Total General Revenues                                             0.00               0.00           0.00           0.00         0.00%

     Charges for Servic Revenues
     610-815-001-1001 Sales                                         2,500.00           2,349.26      30,000.00      24,040.14        19.87%
     610-815-001-1002 Utility Deposits                                 37.50              30.00         450.00         360.00        20.00%
     610-815-001-1003 Sales Tax                                        12.50               0.00         150.00           0.00      100.00%
     610-815-001-1340 Misc Revenue                                      0.00               0.00         300.00         412.82      (37.61%)
     610-815-001-1343 CD Investment Interest                            5.00               0.00          60.00           0.00      100.00%
     Total Charges for Servic Revenues                              2,555.00           2,379.26      30,960.00      24,812.96        19.85%
   Total Enterprise-Sewer Revenues                                  2,555.00           2,379.26      30,960.00      24,812.96        19.85%
Total Sewer Fund Revenues                                           2,555.00 $         2,379.26 $    30,960.00 $$   24,812.96        19.85%

Expenditures
   Enterprise-Sewer Expenditures
     Charges for Servic Expenditures
     610-815-001-6010 Wages-Full Time                                 854.17 $           802.60 $    10,250.00 $$    8,390.87        18.14%
     610-815-001-6110 FICA                                             65.42              56.62         785.00         612.64        21.96%
     610-815-001-6130 IPERS                                            57.08              50.84         685.00         595.88        13.01%
     610-815-001-6140 Pmt in Lieu of Health Ins.                       62.50              37.50         750.00         375.00        50.00%
     610-815-001-6320 Grounds Maint/Repair                             29.17              49.85         350.00          49.85        85.76%
     610-815-001-6406 Sewer-Liability Insurance                         0.00               0.00         300.00           0.00      100.00%
     610-815-001-6407 Sewer-Work Comp Insurance                         0.00               0.00         450.00          17.25        96.17%
     610-815-001-6408 Sewer-Property Insurance Expense                  0.00               0.00          50.00           0.00      100.00%
     610-815-001-6413 Coverage Reserve Fund Contributions             104.17             104.00       1,250.00       1,040.00        16.80%
     610-815-001-6416 Bond Payment-Trans- Sinking Fund                  0.00           1,100.00      13,200.00      11,000.00        16.67%
     610-815-001-6418 Tax Expense                                      12.50              17.12         150.00         174.61      (16.41%)
     610-815-001-6490 Sewer-Testing-DNR                               166.67               0.00       2,000.00         368.50        81.58%
     610-815-001-6499 Sewer-Maint                                      83.33               0.00       1,000.00           0.00      100.00%
     610-815-001-6508 Billing Fees                                     45.83               0.00         550.00         427.50        22.27%
     610-815-001-6700 Utility Deposit Refund                           37.50               0.00         450.00         165.00        63.33%
     Total Charges for Servic Expenditures                          1,518.34           2,218.53      32,220.00      23,217.10        27.94%
   Total Enterprise-Sewer Expenditures                              1,518.34           2,218.53      32,220.00      23,217.10        27.94%
Total Sewer Fund Expenditures                                       1,518.34 $         2,218.53 $    32,220.00 $$   23,217.10        27.94%
Sewer Fund Excess of Revenues Over Expenditures          $          1,036.66            160.73 $     (1,260.00) $    1,595.86 $     226.66%
                                                    City of Auburn
                                   Statement of Revenue and Expenditures5/9/2011                     9:30am             Page           14
                                                                 Revised Budget
                                                       For Sewer Bond Sinking Fund (620)
                                               For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                    Current            Current         Annual           YTD       Remaining
Account Number                                                      Budget              Actual         Budget         Actual       Budget %

Revenues
   Enterprise-Sewer Revenues
     General Revenues
     620-815-000-9000 Transfer In from Sewer Fund                       0.00 $         1,100.00 $         0.00 $$   11,000.00         0.00%
     Total General Revenues                                             0.00           1,100.00           0.00      11,000.00         0.00%
   Total Enterprise-Sewer Revenues                                      0.00           1,100.00           0.00      11,000.00         0.00%
Total Sewer Bond Sinking Fund Revenues                                  0.00 $         1,100.00 $         0.00 $$   11,000.00         0.00%

Expenditures
   Enterprise-Sewer Expenditures
     General Expenditures
     620-815-000-6416 Sewer Bond Payment                                0.00 $             0.00 $         0.00 $$        0.00         0.00%
     Total General Expenditures                                         0.00               0.00           0.00           0.00         0.00%
   Total Enterprise-Sewer Expenditures                                  0.00               0.00           0.00           0.00         0.00%
Total Sewer Bond Sinking Fund Expenditures                              0.00 $             0.00 $         0.00 $$        0.00         0.00%
Sewer Bond Sinking Fund Excess of Revenues Over          $              0.00           1,100.00 $         0.00 $    11,000.00 $       0.00%
                                                      City of Auburn
                                     Statement of Revenue and Expenditures5/9/2011                 9:30am            Page           15
                                                               Revised Budget
                                                   For Sewer Coverage Reserve Fund (625)
                                             For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                  Current            Current         Annual          YTD       Remaining
Account Number                                                    Budget              Actual         Budget        Actual       Budget %

Revenues
   Enterprise-Sewer Revenues
     General Revenues
     625-815-000-1343 CD Interest Earned                              0.00 $            0.00 $          0.00 $$      86.48         0.00%
     625-815-000-9000 Transfer In                                     0.00            104.00            0.00      1,040.00         0.00%
     Total General Revenues                                           0.00            104.00            0.00      1,126.48         0.00%
   Total Enterprise-Sewer Revenues                                    0.00            104.00            0.00      1,126.48         0.00%
Total Sewer Coverage Reserve Fund Revenues                            0.00 $          104.00 $          0.00 $$   1,126.48         0.00%

Expenditures
   Enterprise-Sewer Expenditures
     General Expenditures
     625-815-000-7002 Debt Service                                    0.00 $             0.00 $         0.00 $$       0.00         0.00%
     Total General Expenditures                                       0.00               0.00           0.00          0.00         0.00%
   Total Enterprise-Sewer Expenditures                                0.00               0.00           0.00          0.00         0.00%
Total Sewer Coverage Reserve Fund Expenditures                        0.00 $             0.00 $         0.00 $$       0.00         0.00%
Sewer Coverage Reserve Fund Excess of Revenues Over    $              0.00            104.00 $          0.00 $    1,126.48 $       0.00%
                                                       City of Auburn
                                      Statement of Revenue and Expenditures5/9/2011                  9:30am               Page          16
                                                                 Revised Budget
                                                              For Electric Fund (630)
                                               For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                    Current            Current          Annual            YTD     Remaining
Account Number                                                      Budget              Actual          Budget          Actual     Budget %

Revenues
   Enterprise-Electric Revenues
     General Revenues
     630-820-000-1343 CD Investment Interest                            0.00 $             0.00 $          0.00 $$     1,502.25       0.00%
     Total General Revenues                                             0.00               0.00            0.00        1,502.25       0.00%

     Charges for Servic Revenues
     630-820-001-1001 Sales                                       17,916.67          20,308.65       215,000.00      197,905.50         7.95%
     630-820-001-1002 Utility Deposits                               208.33             104.00         2,500.00        1,644.04       34.24%
     630-820-001-1003 Sales Tax                                      500.00               0.00         6,000.00            0.00      100.00%
     630-820-001-1341 Recovered & Misc. Revenue                       20.83               0.00           250.00        3,913.71   (1465.48%)
     630-820-001-1342 Transmission Investment Revenue                166.67             104.00         2,000.00          104.00       94.80%
     630-820-001-1343 CD Investment Interest                           0.00               0.00             0.00            0.00         0.00%
     630-820-001-1344 Ice Storm Assistance Grant                       0.00               0.00             0.00       28,421.48         0.00%
     630-820-001-4550 Elect Pole Rent                                  0.00               0.00           700.00          707.00       (1.00%)
     Total Charges for Servic Revenues                            18,812.50          20,516.65       226,450.00      232,695.73       (2.76%)
   Total Enterprise-Electric Revenues                             18,812.50          20,516.65       226,450.00      234,197.98      (3.42%)
Total Electric Fund Revenues                                      18,812.50 $        20,516.65 $     226,450.00 $$   234,197.98      (3.42%)

Expenditures
   Enterprise-Electric Expenditures
     Charges for Servic Expenditures
     630-820-001-6010 Wages-Full Time                              1,556.25 $         1,593.83 $      18,675.00 $$    16,009.40       14.27%
     630-820-001-6110 FICA                                           119.17             113.38         1,430.00        1,213.38       15.15%
     630-820-001-6130 IPERS                                          108.42             101.83         1,301.00        1,083.21       16.74%
     630-820-001-6140 Pmt in Lieu of Health Ins.                     162.50              97.50         1,950.00          975.00       50.00%
     630-820-001-6210 Association Dues                               125.00               0.00         1,500.00        1,387.84        7.48%
     630-820-001-6310 Electrical Distribution costs                  416.67               0.00         5,000.00           53.00       98.94%
     630-820-001-6352 Misc. Exp                                       12.50               0.00           150.00          135.90        9.40%
     630-820-001-6371 Wholesale Electric                          13,541.67          11,974.26       162,500.00      123,863.91       23.78%
     630-820-001-6380 Street Lights                                  500.00             727.10         6,000.00        4,241.59       29.31%
     630-820-001-6399 Electrical Maintenance & Repair                833.33               0.00        10,000.00        7,897.39       21.03%
     630-820-001-6406 Liability Insurance                              0.00               0.00           500.00            0.00     100.00%
     630-820-001-6407 Work Comp Insurance                              0.00               0.00           300.00           10.35       96.55%
     630-820-001-6418 Tax Expense                                    500.00             429.05         6,000.00        4,440.78       25.99%
     630-820-001-6490 Energy Efficiency Expense                      358.33               0.00         4,300.00        7,336.90     (70.63%)
     630-820-001-6508 Postage-Billing Expense                         83.33               0.00         1,000.00          440.96       55.90%
     630-820-001-6700 Utility Deposit Refund                         208.33               0.00         2,500.00        1,758.47       29.66%
     630-820-001-7000 Wind Investment                                833.33               0.00        10,000.00          343.84       96.56%
     630-820-001-7001 Transmission Investment                         83.33               0.00         1,000.00            0.00     100.00%
     630-820-001-7002 Ice Storm Emergency Operations                   0.00               0.00             0.00            0.00        0.00%
     630-820-001-9001 Transfer to Reserve                              0.00               0.00             0.00       60,000.00        0.00%
     Total Charges for Servic Expenditures                        19,442.16          15,036.95       234,106.00      231,191.92        1.24%
   Total Enterprise-Electric Expenditures                         19,442.16          15,036.95       234,106.00      231,191.92       1.24%
                                                    City of Auburn
                                   Statement of Revenue and Expenditures5/9/2011                    9:30am               Page           17
                                                                Revised Budget
                                                             For Electric Fund (630)
                                              For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                   Current            Current          Annual            YTD       Remaining
Account Number                                                     Budget              Actual          Budget          Actual       Budget %
Total Electric Fund Expenditures                                 19,442.16 $        15,036.95 $     234,106.00 $$   231,191.92         1.24%
Electric Fund Excess of Revenues Over Expenditures      $          (629.66)           5,479.70 $    (7,656.00) $      3,006.06 $     139.26%
                                                    City of Auburn
                                   Statement of Revenue and Expenditures5/9/2011                         9:30am                Page         18
                                                                 Revised Budget
                                                        For Garbage-recycling Fund (670)
                                               For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                    Current            Current             Annual              YTD     Remaining
Account Number                                                      Budget              Actual             Budget            Actual     Budget %

Revenues
   Enterprise-Garbage Revenues
     Charges for Servic Revenues
     670-840-001-1001 Sales                                         1,083.33 $         1,144.26 $        13,000.00 $$      11,682.21      10.14%
     670-840-001-1002 Utility Deposits                                 18.75              23.00             225.00            276.00    (22.67%)
     670-840-001-1003 Sales Tax-Bags                                    6.25               7.35              75.00             46.20      38.40%
     670-840-001-1004 Garbage Bag Sales                               500.00             105.00           6,000.00          4,660.00      22.33%
     670-840-001-1341 Recovered & Misc. Revenue                         0.00               0.00               0.00             58.20       0.00%
     Total Charges for Servic Revenues                              1,608.33           1,279.61          19,300.00         16,722.61      13.35%
   Total Enterprise-Garbage Revenues                                1,608.33           1,279.61          19,300.00         16,722.61      13.35%
Total Garbage-recycling Fund Revenues                               1,608.33 $         1,279.61 $        19,300.00 $$      16,722.61      13.35%

Expenditures
   Enterprise-Garbage Expenditures
     Charges for Servic Expenditures
     670-840-001-6418 Tax Expense                                       6.25 $             4.90 $            75.00 $$          43.95      41.40%
     670-840-001-6490 Landfill Fees                                   541.67               0.00           6,500.00          4,884.00      24.86%
     670-840-001-6491 Administration                                    0.00               0.00               0.00            128.00       0.00%
     670-840-001-6499 Gargabe Contract                              1,000.00           1,000.00          12,000.00         10,000.00      16.67%
     670-840-001-6508 Garbage-Billing Expense-Postage/Shipping         41.67               0.00             500.00            266.50      46.70%
     670-840-001-6599 Supplies-Bags                                     0.00               0.00               0.00              0.00       0.00%
     670-840-001-6700 Utility Deposit Refund                           18.75               0.00             225.00            115.00      48.89%
     Total Charges for Servic Expenditures                          1,608.34           1,004.90          19,300.00         15,437.45      20.01%
   Total Enterprise-Garbage Expenditures                            1,608.34           1,004.90          19,300.00         15,437.45      20.01%
Total Garbage-recycling Fund Expenditures                           1,608.34 $         1,004.90 $        19,300.00 $$      15,437.45      20.01%
Garbage-recycling Fund Excess of Revenues Over Expenditures                $             (0.01) 274.71            $ 0.00          $ 1,285.16     $
 0.00%
                                                   City of Auburn
                                  Statement of Revenue and Expenditures5/9/2011                    9:30am               Page           19
                                                              Revised Budget

                                             For the Fiscal Period 2011-10 Ending April 30, 2011

                                                                  Current            Current          Annual            YTD       Remaining
Account Number                                                    Budget              Actual          Budget          Actual       Budget %

Total Revenues                                                  55,554.99 $        56,743.76 $     681,941.00 $    480,368.81 $      29.56%
Total Expenditures                                              65,199.22 $        35,698.53 $     764,635.02 $    464,423.52 $      39.26%
Total Excess of Revenues Over Expenditures                      (9,644.23) $       21,045.23 $     (82,694.02) $    15,945.29 $      80.72%
                                                                                Current       Change       Operating     Amounts Held
              FUND             Previous       Received        Disbursed           Fund       from Prev       Funds       In Long-Term
                               Balance                                          Balance        Month                     Investment(CD)
    GENERAL                     $20,171.45    $18,882.23         $10,051.08     $29,002.60    $8,831.15     $13,902.18       $15,100.42
       LOST                     $14,039.82     $1,195.22                        $15,235.04    $1,195.22     $15,235.04
       Emply Ben Levy           -$1,120.95     $2,369.58            $594.76       $653.87     $1,774.82       $653.87
       Emergency Levy             $607.57        $371.66                          $979.23       $371.66       $979.23
       Rec Committee            $20,733.57       $514.87          $2,278.39     $18,970.05   -$1,763.52      $2,157.23       $16,812.82
       Historical Comm.          $4,645.72                                       $4,645.72         $0.00     $4,645.72            $0.00
      125th Celebration          $1,928.94        $25.00                         $1,953.94        $25.00     $1,953.94
      Library Trust              $6,888.64         $0.09                         $6,888.73         $0.09     $2,095.69        $4,793.04
    ROAD USE TAX                $18,813.69     $2,092.75          $1,759.31     $19,147.13      $333.44     $19,147.13            $0.00
    WATER UTILITY              -$20,608.62     $5,912.84          $2,754.61    -$17,450.39    $3,158.23    -$17,450.39            $0.00
    SEWER Operating             -$3,923.05     $2,379.26          $2,218.53     -$3,762.32      $160.73     -$3,762.32
       Sinking Fund              $9,900.00     $1,100.00                        $11,000.00    $1,100.00     $11,000.00
       Reserve                   $6,234.85       $104.00                         $6,338.85      $104.00          $0.00        $6,338.85
    ELECTRIC UTILITY           $251,768.58    $20,516.65         $15,036.95    $257,248.28    $5,479.70     $66,905.67      $190,342.61
    GARBAGE/RECYCL.               $823.27      $1,279.61          $1,004.90      $1,097.98      $274.71      $1,097.98            $0.00
    TOTAL CASH                 $330,903.48    $56,743.76         $35,698.53    $351,948.71   $21,045.23    $118,560.97      $233,387.74

                             Checking        Rec Chg                                         Utility
    Checking Acct            Acct            Acct          Library Trust Ckg                 Billing        $26,250.14
    Statement Balance          $116,329.26     $2,157.23          $2,095.69                  Utility A/R    $11,599.82
    Less Outstanding
    Checks                      -$2,021.21         $0.00                                     Other A/R       $1,041.20
    Current Balance            $114,308.05     $2,157.23          $2,095.69    $118,560.97
    Investment-CD Elect-98      $70,900.49
    CD Elect-43                 $59,207.81
    CD Elect-63                 $25,000.00
    CD-Rec-62                                  $5,000.00
    CD Rec-50                                 $11,812.82
    CD Elect-050                $35,234.31
    CD- LibraryTrust                                              $4,793.04
    CD General-49               $15,100.42
    CD Sewer-604                 $6,338.85
    Total All Accounts         $326,089.93    $18,970.05          $6,888.73    $351,948.71
 

 

Month Ending 4/30/11 
Bills to be Paid                      May            2011


Ahlers & Cooney           Legal                    $27.48    Raccoon Valley REC      wholesale power       $8,100.77
Als Corner Oil            Propane/fire Dept       $397.13    Reiling Electric        Repairs                $180.00
Auburn Feed               Planter                 $310.50    Tiefenthaler Building   Rec/comm bldg          $149.03
Auburn Rec Comm           Annual payment          $200.00    Tri County Special      publishing              $75.32
Baker & Taylor Books      library                 $105.54    US Cellular             phone                   $48.35
Bomgaars                  Shop                    $128.89    Utility Service Co.     water tower            $596.08
Bunz & Gaffney            Legal                   $208.75    Wal Mart                Library                 $65.80
Center Point Books        library                  $43.74    WAPA                    wholesale power       $1,585.32
Cornbelt Power            elect transmission                 Wilkens Napa            shop                   $149.90
CRS Hauling               garbage pick up        $1,000.00
EFTPS                     941 Tax                $1,661.49
Feld Fire                 Fire Dept               $454.65    Total Claims                                 $26,080.52
Fleet Fueling             fire/shop fuel          $341.77
Hawkins                   Chlorine                $211.20    April Wages                                   $8,552.65
Holiday Inn               Clerk Training           $92.96
IA Dept of Revenue        Sales Tax               $744.00    Rec Comm Bills
IA DNR                    Operator Licenses       $120.00    Nobbies                 easter                  $47.80
IA Savings Bank           Sewer Reserve           $104.00    Sams Club               Easter/concessions     $145.03
IPERS                     employ benefits         $979.27    IA Savings Bank         Easter                   $8.00
Janssen, Nancy            mileage                 $242.25    Farner Bocken           Concessions            $439.99
Kriz-Davis Co             Electric repairs        $593.23    WalMart                 Concessions             $73.38
Krudico                   Chemicals/shipping      $437.94
Martins Welding           Shop                      $4.42
Mid IA Insurance          Fire Life Ins           $187.50    Rec Total                                      $714.20
Office Depot              Supplies                 $78.42
Presto X Company          pest control             $34.00
Sac County Solid Waste    Quarterly assessment   $1,628.00
Stewart, Donetta
       ,                  Reimb library
                                      y            $22.27
                                                   $
Toyne Inc.                Fire Dept                $22.00
Utility Deposit Refunds                           $304.98
Windstream                Water/Libr/cityphone    $144.07
IA League of Citites      Clerk Training          $175.00
IMWCA                     Work Comp Ins          $3,922.00
IA Utilities Board        Assessements             $81.00
Feld Fire                 Fire Dept               $118.50
Postmaster                postage                   $3.00

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:470
posted:5/23/2011
language:English
pages:24