Docstoc

Data Base - Excel

Document Sample
Data Base - Excel Powered By Docstoc
					                                                  City Of Emporia, Kansas                                                                                             JULY 30, 2008 DRAFT
                                                  Capital Improvement Plan
                                                        2009 to 2013
                                           Projects funded by sales tax marked by asterisk                                                                                          City
Sales                                                                                                                                                                  General   Non-General Other
 Tax Year         Department                               Description                        Ranking Category        Status      Amount          Funding Source      Fund Share Fund Share Sources
      2009   Water Operations          Purchase City 400 Server                                  1   Equipment      New            $16,000 Water Fund                            $0            $16,000         $0 must replace if breaks
 *    2009   Water Plant               Replace #2 Basin Train                                    2   Construction   Replacement $1,000,000 Water Fund                            $0         $1,000,000         $0
      2009   Water Plant               Remove Lime Residuals                                     3   Construction   Replacement    $75,000 Water Fund                            $0            $75,000         $0
 *    2009   Water Plant               Rehabilitate #2 Raw Water Pump                            4   Equipment      Replacement    $30,000 Water Fund                            $0            $30,000         $0
 *    2009   Water Plant               VFD for #4 H.S.P.                                         5   Construction   Replacement    $27,000 Water Fund                            $0            $27,000         $0
 *    2009   Water Service             Main Replacement Whilden From 9th to 12th                 6   Construction   Replacement  $157,979 Water Fund                             $0          $157,979          $0
 *    2009   Water Service             Main Repair Neosho From 2nd to South                      7   Construction   Replacement  $100,000 Water Fund                             $0          $100,000          $0

      2009   Sewer Operations          Purchase City 400 Server                                  1   Equipment      New            $16,000   Sewer Fund                          $0           $16,000          $0 must replace if breaks
 *    2009   Sewer Service             Main Rehabilitation East From 6th to 12th                 2   Construction   Replacement   $150,000   Sewer Fund                          $0          $150,000          $0
 *    2009   Sewer Service             Manhole Spraying and Grouting                             3   Construction   Replacement    $40,000   Sewer Fund                          $0           $40,000          $0
 *    2009   Sewer Treatment Plant     Replace 2 Influent Pump VFD's and Motors                  4   Equipment      Replacement    $90,000   Sewer Fund                          $0           $90,000          $0
 *    2009   Sewer Treatment Plant     Replace FMC Barscreen                                     5   Equipment      Replacement    $35,000   Sewer Fund                          $0           $35,000          $0
 *    2009   Sewer Treatment Plant     Repair Influent Wetwell Control                           6   Equipment      Replacement    $40,000   Sewer Fund                          $0           $40,000          $0
      2009   Sewer Treatment Plant     WWTP Master Plan Update                                   7   Engineering    New             $5,000   Sewer Fund                          $0            $5,000          $0
 *    2009   Sewer Treatment Plant     Replace South Aeration Diffusers                          8   Equipment      Replacement   $150,000   Sewer Fund                          $0          $150,000          $0
 *    2009   Sewer Treatment Plant     Upgrade Road Around Berm                                  9   Construction   Replacement    $55,000   Sewer Fund                          $0           $55,000          $0

      2009   Solid Waste Operations    Purchase City 400 Server                                  1   Equipment      New            $16,000   Solid Waste                          $0          $16,000          $0 must replace if breaks
      2009   Solid Waste               Purchase Roll-off Truck                                   2   Equipment      Replacement   $135,000   Solid Waste Fund                     $0         $135,000          $0
      2009   Solid Waste               Replace Packer Body                                       3   Equipment      Replacement   $117,000   Solid Waste Fund                     $0         $117,000          $0
      2009   Solid Waste               Polycart Replacement                                      4   Equipment      Replacement    $35,000   Solid Waste Fund                     $0          $35,000          $0
 *    2009   Recycling                 Purchase Glass Breaker                                    5   Equipment      New             $6,500   Solid Waste Fund                     $0           $6,500          $0
 *    2009   Transfer Station          Purchase Equipment Shed                                   6   Construction   New            $60,000   Solid Waste Fund                     $0          $60,000          $0
      2009   Transfer Station          Purchase 3/4-ton Pick-up Truck                            7   Equipment      Replacement    $40,000   Solid Waste Fund                     $0          $40,000          $0
      2009   Transfer Station          Purchase Power Screener                                   8   Equipment      New           $100,000   Gen. Fund/Solid Waste           $50,000          $50,000          $0
 *    2009   Recycling                 Purchase Horizontal Baler                                 9   Equipment      Replacement    $70,000   Solid Waste Fund                     $0          $70,000          $0

 *    2009   Parks                     Hammond Park ADA Playground                               1   Construction   New            $75,000   Lake Kahola                         $0           $75,000          $0
 *    2009   Civic Building            Replace Media and Statistics Center                       2   Equipment      Replacement     $9,000   CVB                                 $0            $4,500      $4,500
 *    2009   Zoo                       Stabilize Picnic Shelter                                  3   Construction   Replacement     $6,000   Sp. Park/EFOZ                       $0            $3,000      $3,000
      2009   Sign & Marking            Portable Hydraulic Power Unit                             4   Equipment      New             $8,000   Special Street                      $0            $8,000          $0
      2009   Street                    Purchase 1-ton Pick-up Truck w/ Salt Spreader             5   Equipment      Replacement    $45,000   Special Street                      $0           $45,000          $0
 *    2009   Parks                     Pave Peter Pan Park Parking Lot                           6   Construction   Replacement   $112,500   Special Park                        $0          $112,500          $0 USD 253 to repay half over 10 years
 *    2009   Zoo                       Complete Sidewalk                                         7   Construction   New            $50,000   Sp. Park/EFOZ                       $0           $25,000     $25,000
      2009   Street                    Purchase Wacky Packer Vibrating Plate                     8   Equipment      New             $2,100   Special Street                      $0            $2,100          $0

 *    2009   Fire                      Fire Station 2 Repairs                                    1   Construction   Repair        $450,000   G.O. Bonds                          $0          $450,000          $0 project authorized to seek bids
 *    2009   Street Construction       Annual Slurry Seal Program                                2   Construction   Replacement   $175,000   General Fund                   $125,000                $0    $50,000
      2009   Administrative Services   Purchase High Speed Printer                               3   Equipment      Replacement    $19,000   General Fund                    $19,000                $0         $0 must replace if breaks
      2009   Police                    Purchase 3 Squad Cars                                     4   Equipment      Replacement   $100,500   General Fund                   $100,500                $0         $0
 *    2009   Street Construction       Street Rehabilitation/Replacement                         5   Construction   Replacement   $500,000   General Fund                   $500,000                $0         $0
 *    2009   Street Construction       Resurface Hwy. 50 Betw. Industrial & Priarie (KLINK)      6   Construction   Replacement   $450,000   Gen. Fund/KDOT                 $250,000                $0   $200,000
 *    2009   Street Construction       Hazardous Sidewalk Program                                7   Construction   Replacement   $200,000   Gen. Fund/Prop. Owners         $100,000                $0   $100,000
 *    2009   Civic Building            Replace Upper Balcony Seats                               8   Construction   Replacement   $125,000   General Fund/CVB                $30,500           $94,500        $0
      2009   Police                    Purchase Evidence Management System                       9   Equipment      New            $32,000   General Fund                    $32,000                $0         $0
    2009   Fire                      Purchase Rad-57 CO/Cyanide Monitor                            10   Equipment      New             $9,000   General Fund                    $9,000         $0         $0
*   2009   Street Construction       Purchase Signal Pre-emption Controllers for 5 intersections   11   Equipment      New            $28,345   General Fund                   $28,345         $0         $0
*   2009   Fire                      Purchase 9 Signal Pre-emption Emitters                        12   Equipment      New             $9,539   General Fund                    $9,539         $0         $0
*   2009   Police                    Purchase 3 Signal Pre-emption Emitters                        13   Equipment      New             $3,177   General Fund                    $3,177         $0         $0
    2009   Civic Building            Excavate and Replace Sewer Line and Valve in Basement         14   Equipment      Replacement    $13,500   General Fund                   $13,500         $0         $0
    2009   Administrative Services   Purchase City 400 Server                                      15   Equipment      New            $16,000   Gen./Water/Sewer/S.W. Funds    $16,000         $0         $0 must replace if breaks
*   2009   Street Construction       Replace 8th From Constitution to Commercial                   16   Construction   Replacement   $105,000   General Fund                  $105,000         $0         $0
*   2009   Street Construction       Replace 10th From Commercial to Mechanic                      17   Construction   Replacement    $75,000   General Fund                   $75,000         $0         $0
*   2009   Street Construction       Update Traffic Signals at Hwy. 50 & Industrial                18   Construction   Replacement   $135,000   General Fund                  $135,000         $0         $0
*   2009   Civic Building            Purchase New HVAC Controls                                    19   Equipment      Replacement    $47,000   General Fund                   $47,000         $0         $0
    2009   Golf Shop                 Lease 8 Golf Carts                                            20   Equipment      Replacement    $10,000   General Fund                   $10,000         $0         $0
    2009   EMS                       Purchase 2 Styker Pro Chairs                                  21   Equipment      New             $5,600   General Fund                    $5,600         $0         $0
    2009   Administrative Services   Purchase Sequel Server Software                               22   Equipment      New             $5,000   General Fund                    $5,000         $0         $0
*   2009   Golf Shop                 Enlarge #9 Pond                                               23   Construction   New           $180,000   General Fund                  $180,000         $0         $0
*   2009   Storm Water               Holiday Dr. Protection Plan                                   24   Construction   New            $50,000   General Fund                   $50,000         $0         $0
    2009   Golf Course               Purchase Batwing Rotary Mower                                 25   Equipment      New            $38,000   General Fund                   $38,000         $0         $0
    2009   Civic Building            Replace Lift Station Pumps in Police Station                  26   Equipment      Replacement    $15,500   General Fund                   $15,500         $0         $0
    2009   Fire                      Replace Hose & Equipment                                      27   Equipment      Replacement    $12,000   General Fund                   $12,000         $0         $0
    2009   Police                    Purchase 7 Mobile Data Terminals                              28   Equipment      Replacement    $37,500   General Fund                   $37,500         $0         $0
    2009   Engineering               Purchase 2008 AutoCad Update                                  29   Equipment      Replacement    $20,000   General Fund                   $20,000         $0         $0
    2009   EMS                       Purchase 2 Transport Ventilators                              30   Equipment      Replacement    $10,000   General Fund                   $10,000         $0         $0
    2009   Police                    Purchase Mobile Video Cameras                                 31   Equipment      Replacement    $35,000   General/Drug Forfeiture        $17,500    $17,500         $0
*   2009   Golf Shop                 Replace Septic System                                         32   Construction   Replacement    $19,500   General Fund                   $19,500         $0         $0
*   2009   Golf Shop                 Repair Parking Lot                                            33   Construction   Replacement    $85,000   General Fund                   $85,000         $0         $0
*   2009   Storm Water               MS4-Phase II Implementation                                   34   Engineering    New            $35,000   General Fund                   $35,000         $0         $0
*   2009   Storm Water               Phase 2 Implementation Funding                                35   Engineering    New            $35,000   General Fund                   $35,000         $0         $0
*   2009   Street Construction       Street Repair Whilden 9th to 12th (Water Project)             36   Construction   Replacement   $157,979   General Fund                  $157,979         $0         $0
*   2009   Street Construction       30th Ave. Crestview to Priarie Resurfacing                    37   Construction   Replacement   $825,000   G.O. Bonds                          $0   $825,000         $0
*   2009   Civic Building            Air Condition Little Theater                                  38   Construction   New            $34,000   General Fund                   $34,000         $0         $0
*   2009   Library                   Replace First Floor Ceiling Tiles                             39   Construction   Replacement    $10,500   Library Fund                        $0    $10,500         $0
    2009   Police                    Purchase Domain Server                                        40   Equipment      Replacement    $12,000   General Fund                   $12,000         $0         $0
    2009   Police                    Purchase Windows 2008 Server                                  41   Equipment      Replacement    $10,000   General Fund                   $10,000         $0         $0
*   2009   Golf Shop                 Repair Men's Room                                             42   Construction   Replacement    $20,000   General Fund                   $20,000         $0         $0
    2009   Parks                     Purchase 4-wheel drive Tractor/Loader                         43   Equipment      Replacement    $80,000   General Fund                   $80,000         $0         $0
*   2009   Library                   Replace Children's Area Carpet on First Floor                 44   Construction   Replacement     $8,500   Library Fund                        $0     $8,500         $0
    2009   Police                    Purchase 5 Radar Units                                        45   Equipment      Replacement    $13,490   General Fund                   $13,490         $0         $0
*   2009   Library                   Renovate Roof Area                                            46   Construction   Replacement     $8,500   Library Fund                        $0     $8,500         $0
*   2009   Street Construction       Sidewalk Construction Hwy. 50 Corinth to Weaver               47   Construction   New            $70,000   General Fund                   $70,000         $0         $0
*   2009   Storm Water               Storm Water Upgrade (Holiday Dr.)                             48   Construction   New           $150,000   General Fund                  $150,000         $0         $0
    2009   Civic Building            Purchase ADA Hearing Devices                                  49   Equipment      New            $12,000   General Fund                   $12,000         $0         $0
    2009   Parks                     Purchase Rotary Mower                                         50   Equipment      Replacement    $40,000   General Fund                   $40,000         $0         $0
    2009   Police                    Purchase 4 Mobile Radios                                      51   Equipment      Replacement    $12,000   General Fund                   $12,000         $0         $0
    2009   Police                    Replace Network Firewall                                      52   Equipment      Replacement    $12,500   General Fund                   $12,500         $0         $0
*   2009   Civic Building            Relocate and Replace Hot Water Expansion Tank                 53   Equipment      Replacement     $5,200   General Fund                    $5,200         $0         $0
*   2009   Civic Building            Replace 1,000-gallon water heater                             54   Equipment      Replacement     $6,500   General Fund                    $6,500         $0         $0
    2009   Fire                      Replace Rescue Boat                                           55   Equipment      Replacement    $22,075   General Fund                   $22,075         $0         $0
*   2009   Civic Building            Automatic Door Locking Entry System (MY Program)              56   Equipment      New             $5,000   General Fund                    $5,000         $0         $0
    2009   EMS                       Purchase 4-wheel drive Vehicle                                57   Equipment      Replacement    $30,000   General Fund                   $30,000         $0         $0
*   2009   Municipal Court           Refurbish Court Room and Lobby                                58   Construction   Replacement     $5,000   General Fund                    $5,000         $0         $0
*   2009   Civic Building            Widen and Raise East Entry                                    59   Construction   Replacement    $14,000   General Fund                   $14,000         $0         $0
    2009   Airport                   Update Airport Master Plan                                    60   Engineering    New           $110,000   Gen. Fund/FAA Grant             $5,500         $0   $104,500
    2009   Golf Course               Purchase Greens Roller                                        61   Equipment      Replacement     $6,000   General Fund                    $6,000         $0         $0
    2009   Civic Building            Replace 7 Windows in Little Theater                           62   Construction   Replacement    $10,000   General Fund                   $10,000         $0         $0
    2009   Police                    Remodel Patrol Supervisor Office                              63   Construction   New            $11,000   General Fund                   $11,000         $0         $0
     2009 Code Services       Purchase Short-Bed Pick-up Truck              64   Equipment      Replacement    $25,000   General Fund             $25,000           $0         $0
     2009 Civic Building      Purchase John Deere Mower                     65   Equipment      Replacement     $5,500   General Fund              $5,500           $0         $0
*    2009 Airport             Acquire Runway Easements for 1/19 Extension   66   Construction   New          $384,640    Gen. Fund/FAA Grant      $19,232           $0  $365,408
     2009 MIS                 Office Updates/Relocation                     67   Equipment      Replacement    $15,000   General Fund             $15,000           $0         $0
     2009 Engineering         Purchase Scanner and Printer                  68   Equipment      Replacement    $16,000   General Fund             $16,000           $0         $0
     2009 Golf Course         Purchase 72-inch Rotary Mower                 69   Equipment      Replacement    $25,000   General Fund             $25,000           $0         $0
*    2009 Airport             Phase 1 Design of 1/19 Extension              70   Construction   New          $260,000    Gen. Fund/FAA Grant      $13,000           $0  $247,000
     2009 Civic Building      Replace 7 Window Curtains in Little Theater   71   Equipment      Replacement     $8,400   General Fund              $8,400           $0         $0
     2009 Civic Building      Replace Stage Curtain in Little Theater       72   Equipment      Replacement     $4,200   General Fund              $4,200           $0         $0
     2009 Golf Shop           Replace Carpet in Golf Shop                   73   Construction   Replacement     $7,000   General Fund              $7,000           $0         $0
     2009 Parks               Purchase 1-ton Pick-up w/ Dumping Bed         74   Equipment      Replacement    $30,000   General Fund             $30,000           $0         $0
     2009 Airport             Purchase 6-foot John Deere Mower              75   Equipment      Replacement    $18,000   General Fund             $18,000           $0         $0
     2009 Police              Purchase Computers/Printer/Software           76   Equipment      Replacement    $15,000   General Fund             $15,000           $0         $0
     2009 Fire                Purchase 3-4-ton Pick-up w/ 4-Wheel Drive     77   Equipment      New            $30,000   General Fund             $30,000           $0         $0
     2009 Civic Building      Purchase used 1-ton Flatbed Truck             78   Equipment      Replacement     $4,000   General Fund              $4,000           $0         $0
     2009 Airport             Purchase Pick-up Truck                        79   Equipment      Replacement    $21,000   General Fund             $21,000           $0         $0
     2009 Civic Building      Purchase used 1-2-ton Pick-up Truck           80   Equipment      Replacement     $4,000   General Fund              $4,000           $0         $0
*    2009 Street Construction 24th Ave. Industrial to Prairie Resurfacing   81   Construction   Replacement $1,630,000   G.O. Bonds                    $0   $1,630,000         $0
    GENERAL FUND EXPENSES ONLY:                                                                             $7,390,145                         $3,228,737   $3,094,500 $1,066,908