Loading...
TR-2012-23 C.I.P. BUDGET ■ P (bud, ct= w TR-2012-23 oy— A RESOLUTION ADOPTING THE FISCAL YEAR 2013-2017 CAPITAL IMPROVEMENT PROGRAM J 3 - 3 WHEREAS,The Capital Improvement Program for Fiscal Year 2013-2017 was su ittZ '+ to the City Council on April 9,2012 in accordance with Article 5,Section 5.3(a)of the Garter; . and N, WHEREAS,The Capital Improvement Program contains a prioritized plan of proposed capital improvements over the next five fiscal years in accordance with Article 5, Section 5-3 (b)of the Charter; and WHEREAS, The Capital Improvement Program is designed to utilize funds for capital improvements on the basis of community priorities in condition with the availability of grants and/or other state, federal or private reimbursement; and WHEREAS, In development the Capital Improvement Program each year,the planning process includes consideration of growth of the town, the improvement of efficient service delivery reducing the need for staff increases,maintenance of new and existing facilities,and consideration of existing commitments; and WHEREAS,Each year the Capital Improvement Program is revised and updated in light of changing needs,requirements, and funding availability; and WHEREAS, In accordance with Article '5, Section 5-3 (c) and (d), the Council shall conduct a public hearing and on or before the twentieth day of the last month of the current fiscal year, shall by resolution adopt the Capital Improvement Program. NOW THEREFORE,THE AGAWAM CITY COUNCIL hereby resolves to adapt the Fiscal Year 2013.2017 Capital Improvement Program as submitted by the Mayor on April 9,2012. DATED THIS ' DAY OF uNE 2012. PER ORDER OF THE AGAWAM TOWN COUNCIL Christopher John President,Agawam Town Council 0PR VEjAT0q FORM AND LEGALITY` S II U r DpvJ Vinceni Gi s a, Solicitor C,r cu.A � MAYORAL ACTION Received this day of 4r'� , 2012 from Council Clerk.. Signed by Council President this day of , 2011 APPROVAL OF LEGISLATION By the powers vested in me pursue to Article 3, Section 3-6 of the Agaw Charter, as amend hereby approve the passage of the above legislation on this . day o 2012. �z0/0/IZ - Richard A Cohen, Mayor DISAPPROVAL OF LEGI LATIO By the powers vested in me pursuant to Article 3, Section 3-6 of the Agawam Charter, as amended, I hereby veto the passage of the above legislation on this day of 2012 for the following reasons):, Richard A. Cohen, Mayor' RETURN OF LEGISLATION TO COUNCIL CLERK Returned to Council Clerk this day of 2012. _ � , E r jAGAWAM CITY COUNCIL ;�, r 36 IN STREET }, AGAWAM, MASSACHUSETTS 01001 LEGAL NOTICE; LEGAL NOTICE PUBLIC HEARING AGAWAM CITY COUNCIL, PRESIDENT Christopher C. Johnson The Agawam City Council will conduct a public_hearing, on Monday, VICE PRESIDENT June 4, 2012, at 7:00prn, at the Roberta G. Doering School, 68 Main Dennis perry Street, Agawam, MA on the Capital Improvement Program For Fiscal Year' 013 to Fiscal Year 2017 as submitted to the City Council by the COUNCILORS Mayor on April 6,201 George Brtzas Cecilia P. Calabrese The Capital Improvement Program is a prioritized plan of proposed Patti C. Cacalla Janres P. Cichettr` capital improvements over the neat five fiscal years. A capital Gina M Letellier improvement is a project or undertaking which provides for the Robert A. Magovern planning; design, construction; reconstruction, renovation or Joseph Mineo replacement of a public building or Facility; an addition to a public DonaldM:Rheaalt building or facility; the purchase of land, buildings or facilities for a Robert E. Rossi public purpose, or a long range development study. ADMINISTRATIVE The Capital Improvement Program for Fiscal Year 2013 to Fiscal Year ;ASSISTANT 2017 is available for public inspection at the City Clerk's Office, 36 Barbara k Bard Main Street, Agawam, MA between the hours of 8:30am to 4:30pm Monday through Friday. The Capital Improvement Program is also available at the Agawam Public Library, 70 Cooper Street, Agawam, MA and the Agawam Senior Center, 954 Main Street, Agawam, MA. BY ORDER OF, Christopher C. Johnson President of the City Council r-- TO BE ADVERTISED ON /17/12 TELEPHONE ray '''CD (413) 786 0400 Ext, 871 co FAX EMAIL bbard@agaivam.ma.us us INTEROFFICE MEMORANDUM x TO: 'N4AYOR RIC RD CO HEN FROM: CHIUSTOPHER C.JOANSOI , COUNCIL PRE SID ENT SUBJECT: REQUEST FOR INFORMATION During discussion of the Capital Improvement Program at our June 4'" City. Council meeting, there was a concern regarding costs, funding sources and state/federal reimbursements of the October storm and relate clean-up,. Would you kindly provide this Council with the final cost of the clean-up, the status of any state/federal :reimbursements and the; source of finds utilized to pad' the bills incurred? Thank you for your assistance! cc hull Council, Auditor IN°TEROFFICE MEMORANDUM TOMAYOR RICHARD COHEIR FROM: CITY COUNCIL FINANCE SUB-COMMITTEE SUBJECT: CAPITAL IMPROVEMENT PROGRAM DATE: / 1/2012' Dear Mayor Cohen: After reviewing your proposed Capital Improvement Program, the members of the Finance Snub-Committee respectfully request clarification of the following items: I. On Page 3 you indicate in Item 4A, that principal and interest spending will not exceed approximately I million annually. That estimation is inconsistent with the figures set forth on Page 3 1. 'lease explain the reason for this large inconsistency and advise which figures are the most accurate for our purposes of evaluating the Capital Improvement Flan, 2. The Capital Improvement Plan calls for a Fire Department vehicle with towing capacity to be used by the Deputy Fire Chief. It appears that such a vehicle will be driven home by the Deputy Fire Chief whom sloes not reside within the Town of Agawam. How is that practical and of what benefit is there to the citizens of Agawam to have this vehicle traveling outside of our town? What is the benefit of having a vehicle with boat towing capacity if it won't always be onsite for expeditious use`s e look forward to your clarification of these matters. Respectfully, The Agawam City Council Finance Sub-Committee members cc: Full Council �i► A To wv , n of Arvawam 6 Interoffice Memorandum To: CITY COUNCIL FINANCE SUB-COMMITTEE CC FULL CITY COUNCIL From: MAYOR RICHARD COH N Date: 45/171 01 Subject: CAPITAL IMPROVEMENT PROGRAM Dear City Council Finance Sub-Committee, In response to your letter dated May 17, 2012 in regards to the Capital Improvement Program l am happy to supply you with the following information you requested for clarification: Question 1 —As outlined in the Capital Improvement program the following are general assumptions; # 4A states, "Limit General Fund principal and interest payments to approximately $1 million dollars per year". This should have been removed, as for numerous years this has not been the case. Thank you for bringing this to my attention. The figures in each year's appropriation and bonding schedule are estimates for evaluating the Capital Improvement Program as they are updated each year based on need and the ability to fund. This plan is the Towns best estimate for your review. The appropriations for each year are ,rude as park of the whole budget. The principal and interest,payment for each year are included in the line items;portion in section 30 of the annual operating budget. The Capital Improvement appropriations for each year are shown in erection 31. Question 2 As to your concern regarding the Deputy Fire Chief taking the vehicle, outside of Agawam, I want to advise you that the Deputy lives in Feeding Hills. The new vehicle in the C.I.P. will have towing capacity providing a back-up for our current' tow vehicle. The 1996 vehicle the Deputy is driving currently is becoming unsafe due to advanced age and body deterioration. The Chief and Deputy Fire Chief are on-call 24 hours per day for the safety of our residents. Respectfully, Richard A. Cohen Mayor INTEROFFICE MEMORANDUM TO: MAYOR RICHARD CO EN FROM: CITY COUNCIL FINANCE SUB-COMMITTEE SUBJECT: CAPITAL IMPROVEMENT PROGRAM DATE: 5/17/20I2 Dear Mayor Cohen Air reviewing your proposed Capital Improvement Program,the members of the Finance Sub-Contmittee respectfully request clarification of the following items: I. On rage 3 you indicate in Item 4A, that principal and interest spending will, not exceed approximately $Imillion annually. That estimation is inconsistent with the figures set forth an Page 3 1. Please explain the reason for this large inconsistency and advise which figures are the most accurate for our purposes of evaluating the Capital Improvement Plan, 2. The Capital Improvement Plant calls for a fire Department vehicle with towing capacity to be used by the Deputy Fire Chief. It appears that such a vehicle will be drivers horne by the Deputy Fire Chief whom does not reside within the Town of Agawam, How is that practical and of what benefit is there to the citizens of Agawam to have this vehicles traveling outside of our town? What is the bcnef t of having a vehicle with boat 'towing capacity if it won't always be onsite for expeditious.use? We look forward to your clarification of these matters. Respectfully, The Agawam City Council Finance Sub-Committee members cc Full Counci I Town tat Agwam Employees Subject to Vehicle Fringe Benefit Type; Loc # Last First 950 7440 421 Blackak Brian. 950 7420 420 Bonesteel Steven 950 7250 969 Bosini Richard 950 7220 24 Brown Gary 950 7420 282 Decker John 950 7450 419 Flynn James 950 7420 526 Golba Christopher 950 7420 359 Myers Ralph 950 7220 1370 Sirois Alan 950 7250 519 Urb nati; Dominic 950 7111 21 Cohen Richard 950 7137 583 Nicora Chet Town of Agawam Page 1 Policy Period; 711111-7111112 2J271 12 ago 2011 ATTACHMENT SA-VEHICLES LIST ALL VEHICLES GARAGED IN AGAWAM,MASSACHUSETTS Coverage Codes: 1= Full coverage - (liability,comprehensive&collision) 2= No collision - (liability,comprehensive) 3= No physical darnago - iliability) 4= Physical damage only - (comprehensive,collision) Aga Mass went amont Indicates now Cost No. No. Cov. DepL Description Now Ptate No. GVW VIIN Motorcycles with fu1l_q2yqraqe Cyl 68 1 15 2006 Harley Davidson 14,951 MM04647 IHDIFMW106Y678170 CY2 69 1 15 2006 Honey Davidson 14,951 MMC7199 1HD1FMW1X6Y577950 Total motorcycles with full coverage 2 Trailers T-1 70 1 14 2010 Wanco Radar Board(Speed) Trail 5,000 MP896F 189AF511X9P825333 T-2 74 1 14 2003 Carmate Emergency Reponse Utili 2,000 M70170 SAX7140431.004039 239 1 14 2010* ATS-$Utility Trailer 1000 MP896F 189AF511X912825333 240 109 1 8 1974 Mastercraft Boat Trailer 150 F14773 182038 385 28 1 10 1989 Intl Trailer(paint mach) 2,000 M40127 3,500 IZFUF0817KB003488 395 83 1 10 2005 Brim Utility Trailer 4,595 M72929 -- 43YDC20265r,045646 719 27 1 71 2007 Big Tex Utility Trailer 1,200 M80090 -- 16VLX081072A73025 720 157 1 10 2010 Cross Country Flat Bed Trailer 4,000 M83398 9,996 431FS2020AI000444 Total trailers with full coverage 8 379 44 2 10 1988 International Trailer 2,000 M40-131 3.50o 1ZFUF10I05SO03140 386 77 2 10 2004 Big TE Utility Trailer 2,000 M69028 16VAXIO 1 442A321 09 Total trailers with no collision 2 207 21 3 8 1931 Intl Suftlo Water Trailer 2,000 MIF910 A42309 291 ill 3 23 2006 CARMATE UTILITY TRAILER 61500 M74268 5AX7114D061-002275 324 46 3 10 1979 General Flatbed Trailer Roller 2,000 M28-516 3,000 3TL7925 342 108 3 10 1973 Woodchuck Chipper Trailer M000 M74274 0 STWG 3243 384 55 3 10 1990 Cvslom Flatbed Trailer 3,295 M61553 10,000 58732153)(XI004781 409 48 3 4 1985 Superior Ideal Trailer -- M33-868 2,000 IZT4ZCB12F4018120 420 138 3 4 2009 Anderson Utility Trailer 1,795 M77-901 4YNBN18229CO56912 701 49 3 10 1985 Ouality Utility Trailer 2,000 M33-871 ---- 8685 903 52 3 10 1985 Collemore lifility Trailer -- M40-035 LCAA830T9FT086874 Total trailers with no physical damage 9 Total Trailers 19 Town of Agawam Page'2 Policy Period. 71i111 •711/12 2122J12 aga 2011 ATTACHMENT 5A-VEHICLES LIST ALL VEHICLES GARAGED IN AGAWAM,MASSACHUSETTS Coverage Codes: 1= Full coverage (liability.comprehensivet8 collision); 2= No collision • (liability,comprehensive) 3= No physical damage - (liability) 4= Physical damage only - (comprehensive,collision) Aga Mass warn amont `=indicates new Cost No. No. Cov. Dept. Description New Plate No. GVW VIN Vehicles with full coverage 101 1 14 2011:' Ford Crown Victoria 31,000 MP375F 2FA8P7BV5BX106850 102 158 1 14 2011 Ford Crown Victoria Sedan 30.000 MP 87D 2FABP7BV6BX172324 103 154 1 14' 2011 Ford Crown Victoria 30.000 MP378F - 2FA8P7BV86X168324 104 1 14 2011 Ford Crown Victoria 30,000` MP2410 2FABP7BV56X149228 105 1 14 2011 Ford Crown Victoria' 30.000' MP404F 2FABP76V38X107544 106 131 1 14` 2011 Ford Crown Victoria 30,000 MP184Q 2FABP7BV5BX107545 107 10 1: 14 2033 Explorer Sport Utility 35.000 MP9663 1FMZU72KO3UB06346 108 85 1 14 2006 Ford Taurus Sedan 21,000 44HG70 -- 1FAFP53U96AI24052 109 1 14 2009 Dodge Charger 30,000' 712FXK 283KA43V49H582442' 110 78 1 14 1097 Ford Crown Victoria 26.000 290CWJ - 2FALP71 W3VX229842 ill 76 1 14 2007. Ford gown Victoria 25,000 81GR32 -- 2FAFP71WOTX117533 112 76 1 14 2004 Ford Crown Victoria 25,000 M64619 2FAFP71W64X143324 113 58 1 14 2000 F❑rd Crown Victoria 23,035 8900SX --- --2FAFP71W7YX2ti2401• 114 86 1 14 2005 Ford Crown Vic.Sedan 26,807 MP402F 2FAFP71W75X176950 15 84 1 14 2006 Ford Crown Victoria Sedan 28.000' M 30494- •-- 2FAFP7iW76X108326 116 4 1 14 2008' Ford Crown Vic DARE 25,730 MP9164 2FAFP71V48X112196 117 5 1 14' 1997 Ford E350 Van 29,982 MP124A 9.400 1FMEEllLlVHB96245 118 146 1 14 1998' Marked Ford Van Prisoner Van 30,000 MP115A 1FTSS34L6WHA56432 119' 1' 14 2009 Crown Vic 30,000 MP405F 2FAHP71V99X O4444 121 71 1' 14 2000 Hyundai 25.000 4461NY --- KMHWF35VXYA300550 122 1 14 2005 Ford Taunus 30,000 6442CV 1 FAFP53UO5A159240 124 112 1 14 2003 Ford Crown Vic Unmarked 17,719 8652XB --- 2FAHP71W23X192012 126 147 1' 14 2001 Audi A6f" 32,000 799XBM WAUED64B91N163367 125 152 1 14 2006 Nissan Maxima 16.000 775EA3 -- 1N4BA41EX6C843045 123 156 1 14 2003 Unmarked Lincoln Navigator 25,000 213KH9 SLMFU28RO31.J32345 128' 1 14 2012 Unmarked Ford Escape` 363HL9 1 FMCU5K36CK820521 201 8 3 8` 2007` Pierce Pumper; 400.000 MF4606 - 4P1CC01T77AO07357 202 9 3 a 2007 Pierce Pumper 400,000 MF4656 -- 4P1CCOiT97AO07358 203 6 3 8' 1996 Pierce Pumper, 390.000 MF7820 1PICT02U3TA000486 204 7 3 8 1996` Pierce Pumper 390,000 MF6216 - 4PICT02U5TA000490 210 113 3 8 2002 Pierce Dash Tower Truck 1,100,DOO MF7727 -- 4P1CT02S73AO02626 211 8 8' 2010 Ford E450 Cutaway Ambulance' 163,510 MF9719 1 FDXE4FP8ADA06498 212 96 3 8` 2006` GMC Cutaway Ambulance 165,000 MF6183 17,500 1 GDE4V1266F400931` 213 1 8; 2010' Ford E450 Cutaway Ambulance 165,000 MF9719 --•- 1 FDXE4FP8ADA16707 215 114 3 8; 1986 GMC Saulsburg Rescue Vehicle 100.000 MF52B3< -- 1GDM7D1G6GV538811' 217< 2 8` 2003- Ford Expedition 10,800 M83936 1FMPU16L23LA20095 222 53 1 8 1997 Ford Crown Victoria 20,497 MF6218- ---•- 2FALP71W7VX229861 226 102 1 8' 2005 Ford Expedition 35.000 MF7815- 1FMPU16555LAW05 228 1 8 1997 Ford F350 Pickup 30,000 MF9731 1FTHF36GOVEC46709 233' 1` 21 2011 Ford Escape Hybrid 32,000 MP74 1FMCU5K33BKA75767' 345 1 8 2000 Ford Ranger MF9958 1FTYRiOX8YTA59559 301 101 1 10 2007 F450 Rack Body 35,000 M80099 14,000 1FDXF47P57EB31229 302 75 1 21 2004 Ford F150 Pickup,-4 WO 20.000 M70129 6,250 2FTRF18W44CA38978 303 13 1 10 1999s Ford F150 Pickup 22,755 M54230' 6,000 2FTRF08W4XCA13223 304 88 1 21' 2006 Intl 700ser Henderson Muni 8D 123.145 M74264 40,000 1 HTWCAAR16J313570 Town of Agawam Page 3 Policy.Period: 711111-711112 2/22 12 aga 2011 ATTACHMENT 5A m VEHICLES LIST ALL VEHICLES GARAGED IN AGAW:AM MASSACHUSETTS Coverage Codes: 1= Full coverage •- (liability,comprehensive S collision) 2= No collision - (liability,comprehensive) 3= No physical damage - (liability) 4= Physical damage only - (comprehensive,collision) Aga Mass wam arnont =Indicates new Cost No. No. Cov, Dept. Description New Plate No, GVW V1N Vehicles With full coverage(continued) 306 15 1 21 1995 Ford LN8000 67,129 M52.450 35,000 1FOYR82EXSVA37753 307 16 1 10 1997 Ford LN8000 thump/Spreader 72,650 M64-728 35000 1FOYR82E lWA2865d 308 56 1 10 2001 Freightliner FL80 Dump/Spreader, 86,318 M64-738 40,000 1FV64886181-113056 309 144 1 10 2009 International 7400 Dump Sander 106,000 M77-263 40,000 IHTWCAAR99JO84284 310 141 1 10 2009 International 7400 Dump Sander 109,000 M77-275 40,000 1HTWCAAR09JO84285" 311 95 1 21 2005 Ford Explorer 23.000 L472932 1FMZU72EXSU883M 312 1 21 2011 • international 7400 Dump" 145,380 M82877 40 000 IHTVVCAARGBJ394314 313 136 1 21 1986 GMC True 50.000' M 15-429 IGDL6TIG4GV5 6438 314 89 1 21 2006 Ford F250 Pick-Up 32,745 M74253 1FTNF205X6EA65610 315 90 1 21 2006 (Ford F350 Utility ORW 32,745 M74254 1FDVM36Y26FA65611 316 80 1 21 2004 Ford Cutvan 30,161 M69599 1FUWE35L74HA01147 317 91 1 21 2005 International700$ER OUMPISprem 81,818 M72014 40,000 1HTWCAARX5J107720' 320 97 1' 21 2006 Ford F450 Utility 36,545 M74263 0 iFDXW46Y86EA76977 322 25 1 10" 1995 Ford F450 Dump 31,707 M52442 15,000 1FDLF47FXSEA28192 325 57 1 10 2001 Freightliner 51-80 rump Truck 74,891 M64746 40,000 1 FV6JLBB31 HH13055 326 1 21 2011 Ford Escape Hybrid 27,892 M83377 1 FMCU4K37SKA76765 328 98 1 10 2005 Ford F250 Pickup 21.928' M69592 1 FTNF 1575E A45604 332 54 1 10 1999 Freightliner Medcon;FL80 Clump 77,813 M52515 35.000 1FV6JLABXXH882267 333 26 1 10 2005 Intl 700S R Clump 50.200 M69581 1H'TWCAAR55JO14877 334 103 1 10 2003 International 7400 Dump/Spread 91,611 M62295 40,000 1HTi CAAR63JO51735 337 62 1 10 2002 Freightliner Chump Truck 74,910 M67275 IFVABXBS22HJ73761 338 107' 1 10 2007 Ford F1SoPickup 20,000 M74 91 1FTRF14tr 7NA59025 339 151; 1 10 2009* Ford F150 Pickup"` 28,000' M81516 1FTRF14W49KC60011 340 64 1 21 2001 International Sewer`Cleaner Truck 194,427 M40046 1HTGBAt3R61H343554 343 12 1 10 2007 Trier/Tenex TV^900-1 27.000 M73845 43YDC16167CO57072 34$ 19 1 21: 1999 'Ford Ranger 19,200 M54033 1FT1"R10V9XTA17799' 357 22 1 7 1996 Ford Econoline Club Wagon 17,448 M64-687 1FMEE11Y6THA40828 3 8 35 1 16 2002 Fond Focus 4 door Sedan 14,540 M66937 1 FAFP343X2W267924 359 23 1 7 1997 Ford Escort Wagon 13,150 M54672 3FALP15PGVRI16322 360 142 1 21- 2008 Ford Escape Hybrid 23,000 M76570' 1 FMCU59H58KE09145 361 115 1 21 1999 Ford Ranger Pickup 14,800 M54231 4„„„000 1FTYR10V2XPA27325 362 61 1 10 2001 Ford Super Duly Crew Carr Lump 50,999 M64620 10,000 1FOXW47F51EA94343 363 139 1 10 2008 Ford F450 Crew Cab Clump 31,680 M77267 16,000 1 FOXW47R58EE39519 364 140 1 10 2008 Ford F450 i0ump 31,880 M77266 16 000 1FDXF46Y28EE39518 371 24 1 211 1999 Ford F450 Super Duty Clump 44,490 M61503 15 1F01XF47F2XEC28816 373 72 1 21 2003 Ford F250 Pickup 16,971 M70152 8,800 IFTNF20183ED58190 375 92 1 10 2006 Ford F450 DRW Cab Rack Body 281.480: M74273 15,000 1 F:DXF46Y36EC65729 383 63 1 10 2001 Ford Pickup 18,436 M66950 6,600 1FTRF17 /`91h1B70738 380 29 1 20 1997 international Mode14700 78,000 M47449 35 1HTSCAAR2VH414380 Town of Agawam Page 4 Policy Period: 7111111 -711112 2122112 aga 2011 ATTACHMENT 5A-VEHICLES LIST ALL VEHICLES GARAGED IN AGAWAM MASSACHUSETTS: Coverage Codes: 1= Full coverage - (liability,comprehensive&collision) 2= No collision - (liability,comprehensive) 3= No physical damage - (liability) 4= Physical damage only - (comprehensive,collision) Aga Mass warn amont *=indicates new; Cost No. No, Cov, Dept. Description New Plate No. GVW VIN Vehicles with full coverage (continued) 344 36 1 3 1996 Ford Escort Sedan 12,293 M47-435 3FASP13J2TR104014 390 1 4 2012 Ford DRWSUP' M88638 0 iFDUF4HY7CEB23718 391 93' 1 1 2005 Ford Explorer U728 4X4 23.000 M72933 5,984 1 FMZU72E85UBB3687 392 66 1 10 2002 Ford Ranger Extended Cab 4WD 20.000 M66946 4,940 1FTYR45E62TA15866- 402 32 1 4 1989 Ford F250 Pickup 12.700 M40-148 2FTHF25H6KCA47847 406 73 1 4 1W8 International 400SER Box Truck 15,200 M44-687 25,500 1 HTSCAAMBWH547182 407 110 1` 4 1999 Ford E250Van 10.000 M40911 1FTNE24L2XH807375 " 411 33 1 4 1995 Ford E150 Econoline Van 15,594 M52403 6700 1FTEE14YISH869459 413 94 1; 4 2006 Ford E-350 Van 32,000 M74262 9400 1 FDWE35L26HA73392 414 153 1' 4 2005 Ford Econovan' 27,355 M78609 1FTSE34L45HB27729 565 31 1' 9 1998 Ford Contour 16,197 M54294 0' 1FAFP66L6WK274395' 608 17 1 7 1998 Font Contour 19,197 M54293 0 1FAFP66LBWK274396 609 1 14 2012 Ford Escape M81814 0 1FMCV5K36CKB20525 730 67 1` 6 2002 Chevrolet Silvaderado 4WD Pickul 17,222 M67265 6,400 1GCEK14V42E153207' 801 104 1 19 2000 Ford Cut Away Van 30,000 M64624 1 FDWF35S7YH831541 802 116 1' 19 2006 Ford EcoVan 15,886 M74272 1FTNE24L06DA10634 803 1 19 2010 Ford Transit S98' 23,215' M83387' NMOKS9BN8AT033809 807 9 2011 Intemational 700SER DUMP M82877 1HTWCAAROBJ394314 902 38 1 22 1999 Ford Ranger 14,640 M60183 1FTYR10VIXTA17800 905 135 1' 16 2007 Ford EooVan 15,000 M79-433 IFTNE24L87DB3806` 954 41 1 16 1997 Ford Escort Sedan` 12,340 M41.717 1FALP13P6VW192316 Total vehicles with full coverage 102 Vehicles with no collision 206 42 2 8 1993 Ford F250 12,000 M54233 8,000 1 FTHF26H5PLB25642 208 43 2 8 1986 Chevy 4 WO Pickup 10,000 MF8363 - 1GC1HD3458G5446920' 290 117 2 23 1994' Ford Bronco 20,000 MF906' 1FMEU15H9RLB43518 327 18 2 21 1997 Ford Ltgcon Crew Cab Util Body 38,212 M56288 10.000 1FTJW35H4VED08639 341 99 2 12 1995 Ford F150 Pickup 14.800 M69595 6.250 1FTEF15Y9SLB92349 404 106 2 4 1983 Ford El50'Van 7,999 M16596 I FOKE04YI DHA42641 405 159 2 4 2000 Ford E250 Van 10,000 M79434 I FTNE2424YH891 174 Total vehicles with no collision 7 Vehicles with no physical damage 1110 45 3> 14 1968 VW Sedan(Safety Bug) 2000 MPKK' 18818453 121 79 3 14, 2000 Hyandai Sonata Sedan 11,000 4461NY KMHWF35VXYA300550 906 149 3> 8` 1997 Rogue Boat/1-railer MF6282 18YILAX27U1011373 Total vehicles with no physical dama9e 3 Total of all vehicles 133 I A AGAWAM CITY COUNCIL facility;the purchase of land, HISTORICAL The Agawam City Coun- buildings or facilities for a COMMISSION cil will conduct a public public purpose, or a long The Agawam Historical hearing on Monday, June range development study. Commission will be hold- 4, 2012, at 7:00pm, at the The Capital improvement ing a public hearing at 7:00 Roberta G. Doering ,School, Program for Fiscal Year 2013 PM on Thursday, May 24 68 Main Street, Agawam, to Fiscal Year 2017 is avail- 2a12 at the Captain Charles MA on the Capital Improve able for public inspection Leonard House,'fr 3 Main ment Program for Fiscal'Year at the City Clerk's Office, Street. The purpose of this 2013 to Fiscal Year 2017 as 36 Main Street., Agawam, heariing,will be to review the submitted to the City Council MA between the hours of Demolition Permit for 414 by the Mayor on April 6, 8.30arn to 4.30pm, Monday North Street which comes 2012, through Friday. The Capital under the Town of Aga The Capital Improvement Improvement Program is wam's Demolition Delay Program is a prioritized plan also available at the Agawam Ordinance. of proposed capital improve- Public Library, 750 Cooper Ily'Order of ments over the next Live fiscal .Street,Agawam,M A and the David Cecchi,Chairman years.A capital improvement Agawam Senior Center, 954 AGAWAM HISTORICAL is a project or undertaking Main Street,Agawam,MA. COMMISSION which;provides for the plan- BY ORDER OF: 5/10 117/12 ping, design, construction; Christopher C.Johnson reconstruction, renovation President of the City Council LEGAIII'tOTICE or replacement of a public 5tt7d12 PUBLIC HEARING building or facility; an addi- AGAWAM titan to a public building or LEGAL AD 20 16 20 27 Registration More sponsorships;are welcomed.If your ao tl p.m.Dead company would like to sponsor this very im- portant tournament or for more information eck out to the please call Dee or Lori at 413-8 8-4019. 40 urnament and ten Magazine, To get your organization's information 42 43 44 Feeding Hills, placed in the Agawam Advertiser News,can- 46'.ard,Visa,His- tact Sports Editor Dave Forbes at 413-2 3 ay pal location on 8393 ext. 237 or send an email to rfforbes@ TS Imen.coan, turleY.com.. ansored by Pe oz s5 The offense was spearheaded by the ever- CLUES ACROSS stud present work from Miami Hurricanes for 1.Traditional baby 40,1- came of it' ° ward Kate Howarth. Her work off and over carriage sleep the gates fir the ball created many scoring chances for the 5.A fencing sword 41. onverting on a Mutiny but Fury goalkeeper Michelle Betos g.Titan mother of 41 t early chances was up to the task,especially in the 64th and Helios grow lutiny,defense 83rd minutes.- 10 S.F,Asian 45.1 3y &dynamic "I thought I Kate] was excellent," said penninsula now and Jasmyne Horta about his athletic forward. "I think 12.A stretch of 46a e we're going to seas a lot of her, I give her shallow waer false L_og_aLN_0_§C_C5___ ACAWAM CITY COUNCIL facility;the purchase of land; . AGAWAM HISTORICAL The Agawam City Coun- buildings or facilities for a CONSERVATION COMMISSION Oil will conduct a public public purpose; or a long COMMISSION The Agawam historical hearing on Monday,June range development study. The Agawam Conserva Commission will be hold- 4, 2012, at 7'00pm, at the The Capital Improvement lion Commission will meet ing a public hearing at 7:00 Roberta G. Doering School, Program for Fiscal Year 2013 on'Thursday,May 24,2012 PM on Thursday, May 24, 68 Main Street, Agawam, to Fiscal Year 2017 is avail- at 6.30 PM at the Agawam 2012, at the Captain Charles MA on the Capital Improve- able for public inspection Public library, 750 Cooper Leonard House, 663 Main ment Program for Fiscal Year at the City Clerk's Office, Street, Agawam, MA. The Street. The ;purpose of this 2013 to Fiscal Year 2017 as 36 Main Street, Agawam, purpose of this meeting will hearing will be to review the submitted to the City Council MA between the hours of be to hear the Request for Demolition Permit for 414 by the Mayor on April 6, 8:30am to 4:30pm, Monday Determination of Applicabi- North Street which comes 2012. through Friday. The Capital lity of Mazurowski for pro under the Town of Aga- The Capital Improvement Improvement 'Program is perty located at 8 Independ wam"s Demolition Delay Program is a prioritized plan also available at the Agawam ence Road. Ordinance. of proposed capital improve- Public Library, 750 Cooper By Order of Henry A. y Order of ments"raver the next five fiscal Street,Agawam,MA and the Kozloski,Chairman David+Cecchi,Chairman years.A capital improvement Agawam Senior Center„954 Agawam Conservation AGAWAM HISTORICAL is a project or undertaking Main Street,Agawam,MA. Commission COMMISSION which?provides for the plan- BY ORDER OF. 5l17l12 5l1 t1,5117t12 ning, design, construction, Christopher C.Johnson reconstruction, renovation President of the City Council LEGAL Ni)TICE or replacement of a public 5/17l12 PUBLIC HEARING building or facility; an addi- ACAWAM tion to a public building or LEGAL AD I�1 IML!J T H ECE oil "t I A ERROR& Each *Residentialadvertiser is re- -�oan rdal O A L cluested to ehe+ck meaning E L N t3 their advertise- *Repairs ruent the first time "FQ n" N .0 L O E A D S it appears. "this G~SPUM © V A N t M B U B paper will not be I WARHMM responsible a for L A M E N I T A T I C7 IV more than one � � ! S R t 010 B A E U IR correctd inser- tic n,nor will be li- M I A T R I U L A T E able for any error FomflyOpuaWfix 38 Wen 8 E D I D E [3 R M A in an advertise asp tltx A B B A F L O, tent to a greater For All Your extent than the Cutter Needs D C} U B T M I 17 S T coast of the space H A R 8 U R P t Q T occupied by the 536-7451 item in the adver= MAUC4103177-cra2 P L E B E M 0 D E M tisem+ent E A C H 0 A I B CALENDAR,from page 16 2 28 The cost per golfer is$130. Registration More sponsorships are welcomed.If your u time is 11 a.m.Tee time is 12:30 p.m.Dead- company would like to sponsor this very im- line for sign up is June 19 portant tournament or for;more information 8' Golfers can make their check out to the please call Dee or Lori at 413-888-4019.. 40 Peter Picknelly Sr. Golf Tournament and send to Western Mass Women Magazine, To het your organi ation"s information 4 43 44 525 Springfield St. Suite 0, Feeding Hills, placed in the Agaawrarn Advertiser News,con- MA 0103 or pay by Master Card,!Visa,Dis- tact Sports,Editor Dave Forbes at 13-283- a cover,AMX at the secure pay pal location on 8393 ext.237 orsend an entail to dforbes 4 the website at westernmasswomen.com. turley.co . The tournament is being sponsored by Pe- ter Pan Bras Lines. MUTINY,from page 14 The offense was spearheaded by the ever- CLUES ACROSS stuck present work from Miami Hurricanes for- 1.Traditional baby 40.:F Pie early crosses,but nothing carve of it.' ward Kate.Howarth. Her work off'and over carriage steept, New England came out of the gates fir- the ball created many scoring chances for the 5.A fencing.sword 41._ ing,with Riley Houle almost converting on.a Mutiny but Fury goalkeeper Michelle Betos 9.Titan mother of 42.St scoring opportunity.But those early chances was up to the task,especially in the 64th and llelios grout opened up the space in the Mutiny defense 8 rd minutes. 10.S.E.Asian 45:B to counterattack and the speedy &dynamic "I thought tKate] was excellent," said penninsula Howe- two-some of Merrit Mathias and Jasmyne Horta about his athletic forward, "I think 12,A stretch of 46;& Spencer filled that void, were going to see a lot of her. I gave her shallow waer false Mathias would notch the first of her three the freedom to exploit those places that she 13.Pea,bean or 48.Ic first half goals in the 5th minute,beating the lilies to go into.We need to get a player that lentil 49. offside trap and breaking in cane-on-one on can compliment her with her speed and with 16.African 51.L Mutiny goalkeeper Jennifer Bannon. Math- being interchangeable:' antelope smatlf ias would become the provider on the second New York's Meghan Lenczyk, however, 17.Recording of 52.'C` goal in the 14th minute,joking along the end would show her how to fire a ball past a keep- different songs 54.L line to serve a cross to an open Spencer who er in the 74th minute,blasting a shot from 20 18.T contendere. over 1' ruthlessly finished for the 2-0 lead. yards out on the left side of the penalty area plead no contest 55.-8 Both teams appeared to settle clown into a that Bannon had no chance to save. Recent 19.Diving bell indiv rhythm for the next ten minutes until Math- slgnee Tiya Gallegos would put the Mutiny inventor 5&R" iris capitalized on as goalkeeper error to matte on the board a little over a minute later,con- 20.Egg cells platft the score"3-0. If the third goal didn't let the verting off a rebound of a hard Howarth shot 21.Cumulus rain air out of the balloon for New England, for the final score of 5-1, cloud CLU, Mathias'goal to seal the hat trick in the 42ad The nett home game for New England is 26.Cry of sorrow I, minute would prove to be the needle in any Saturday, May 19 as they host the Chesa- 30.23 :go 2.Cc comeback bid. peke Charge(0-1 WPSL Elite).The Charge away wrtt The Mutiny were now behind 4-0 on the lost to the Boston Breakers(1-0 WPSL Elite), 31.Supreme Allied 3.Fc scoreboard. Horta would make adjustments 3-0, in the WPSL Elite Opening Match this Commander Europe 4. 1l to his side at halftime and the second half path Thursday night. 6.Enroll s a amp would see a stronger performance from the home side; 05/30/2012 15:29 iTown of Agaw&M eheryj,s�john jYTD BUDGET REPORT Iglytdbud AS OF 5-30-12 FOR 2012 99 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJST!MTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED --------------- ------------------------ ......--------------------- -------------------------------------------------------------- 100 GENERAL FUND ---------------------- ------------------ 16610 S2450 14GWIY OTHER ECUPMENT 150,000 2,677,00 152,677.00 152,559.54 ,00 118-26 99.9t 16610 52460 STREET IMPROVE PROGRAM 150,000 -2,6'77,80 147,322,20 38,556.39 .00 108,765.91 26,2t 16610 53001 JR HIGH POOP DESIGN FE 0 fio,omoo 60,000.04 40,208.00 .00 19,792.00 67.0t 26610 59415 TRAFFIC LIGHT IMPROVEM 20,000 .00 20,000.00 .00 00 20,000.00 .0% 16610 $8501 DPW CPS VRHICLE TRACKI 50,000 -00 50,000.00 007 .00 50,000,00 16610 50502 ENGINEERING DIG SCANNE 25,000 .00 25,000.00 24,234.44 .00 765.56 96.9% 16610 58501 FIRE AIR COMPRESSOR 40,000 .00 40,000.00 38,602.00 .00 1,398.00 96,5% 16610 SSS04 FIRE EMERG BACKUP GE N 12,000 .00 12,000-013 .00 ,Qo 12,000,00 16610 58505 FIRE CARDIAC MONITORS 8,928 .00 8,929.00 8,647,50 .00 280.50 96.91, 16620 58913 COUNTY LAND ACQUISITIO 9,500 00 9,5moo 9,500.04 .00 1004% 16610 $8924 SIDEWALK REHAB & EXT; 5,000 .00 5,000,00 00 .00 51000.00 D% 16610 58934 GYM DOOR JR HIGH SCHOO 25,000 .00 25,000.00 00 .00 25,000.00 16619 $2450 SIGNS & POSTS/HGWY EQU 0 1,611.65 1,611.65 1,175.00 .00 436.65 72.9% 16619 52460 CAP IMPR RCS MATERIAL C 0 149,156.35 149,156.35 149,156.35 .00 .00 100.0t 16619 52461 CT RIVER WALK & DIKEPA 0 72,256.61 72,256,61 8,469,37 .00 63,797.24 11.7% 146619 S2469 GASS 34 IMPLEMENT C/O 0 27,495.45 27,495.45 .00 .00 27,495.45 .0% 16619 $2475 FARM LAND PRESERVATION 0 10,000,00 10,000.00 .00 '00 10,000100 .08 16619 58706 ZONING MAY RECODIFICAT 0 2,000-00 2,000.00 .00 .00 21000.00 .0% 16619 58914 SIDEWALK REHAB & EXT 0 56,759.53 56,759-53 1911BS.31 '00 37,574.22 33.sit 16619 58926 MIDDLE SCHOOL CLASSROO 0 1,271.98 1,271-88 1,271,88 .01 16619 58929 CLARK SCHOOL PRKNG LOT 0 570.84 570.84 00 Go 570.84 .0% GRAND TOTAL 495,428 361,122.31 816,550.31 490,293,90 .00 386,256.41 55-9t - END OF REPORT - Generated by Cheryl St. John TOWN of AGAWAM CAPITAL;PROJECTS FUND FISCAL YEAR 2012 as of 5129112 FUND BAL. REVENUE OFS OFU FUND BAL FUND# DESC 71112011 FED STATE OTHER IN EXPEND OUT ADJ 5129/2012' 301 SCHOOL ROOF 3,424 $ 3,424 302 WATER REHABILITATION SYST $ 1,498 $ 1,498 303 N.AGAWAM REVITALIZATION $ 2,472 $' 2,472 304 INDUSTRIAL PARK DEVELOPMENT $ 2,085 $ 2,085 305 AERIAL PLATFORM TRUCK $ 3,088 $ 3,088 306' F H SOUTH WEST AREA SEWERS 26,617 $ 26,617 308 N. AGAWAM REVITALIZATION $ 14,263 $ 14,263 312 GOLF COURSE IRRIGATION 8,575; $ 8,575 314 MAIN STREET WATER MAIN $ 121,970' $ 121,970 315 FIRE HEADQUARTERS $ 266 266 21 PLAYSCAPE GIFT ACCOUNT $ 1,512 $ 1,512 323 CAMPBELL DRIFLORIDA DR SP $ 31,827 $' 31,827 324 PUBLIC LIBRARY EXPANSION $ 446,925" 57,624 $ 389,301 326 RT 187 WATER MAIN $ 677,132 1,595 $ 675,537 327 CHAPTER 90 22,428 555,976 786,244 $ (207,840) 29 AHS LIBRARY'EXPANSION $ 1,563 $ 1,563 330 MAIN STIR PWED $ (212) $; (212) 331 DPW FACILITY ACQUISITION $ 43,632 43,632 32 PHASE 11 STORMWATERICOMBINED $ (14,611) 37,518 12„031 $< 10,875 333 MIDDLE SCHOOL ROOF REPLACEMENT $ - 334 MIDDLE &JUNIOR HIGH REPAIRS' $ 18,588 $ 18,588 335 MODULAR CLASSROOMS $ 21,811 $ 21,811 336 FIRE PUMPER TRUCKS $' 828 $ 828 337 SENIOR CENTER $ 26,600 22,040 4,560 338 PERRY LANE POOL RENOVATION $ 5,417` $ 5,417 339 WESTFIELD RIVER SEWER MAIN $ (8,120) $ (8,120)' 340 SANITARY SEWERS $ (2,153,630) 373,579 $ (2.,527,209) 341 BUILDING MAINTENANCE STORAGE BLDG $; _ 122,540' $ (122,540) 342 TOWN TELEPHONE SYSTEM $ - 307,760 $ (307,760 343 JR HIGH GREEN REPAIR PROGRAM $ - 88,017 162,096 $ 74,079 TOTALS $' (694,t153 $ $ 643,993 $ - $ 37,518 $ 1,845,509 $ $ $ (1,858,051 Mote-A bond anticipation note and/or bored will be issued for funds with a deficit balance before June 30, 2012, Note-Chapter 90 has a deficit because it is a reimbursement grant. Expenditures are made then copies of the Invoices are submitted for reimbursement. INTEROFFICE MEMORANDUM TO: MAYOR RICHARI) COHEN FROM: CITY COUNCIL FINANCE SUB-COMMITTEE SUBJECT: CAPITAL IMPROVEMENT PROGRAM DATE; S/17/201 Dear Mayor Cohen; After reviewing your proposed Capital Improvement Program, the members of the Finance Sub-Committee respectfully request clarification of the following items: I. On Page 3 you indicate in Item 4A, that principal and interest spending will not exceed approximately $Imillion annually. That estimation is inconsistent with the figures set forth on Page 31. Please explain the reason for this large inconsistency and advise which figures are the most accurate for our purposes of evaluating,the Capital Improvement Plan. 2. The Capital Improvement Plan calls for a Fire Department vehicle with towing capacity to be used by the Deputy Fire Chief I`t appears that such a vehicle will be driven home by the Deputy Fire Chief whom does not reside within the Town of Agawam. ,How is that practical and of what benefit is there to the citizens of Agawam to have this vehicle traveling outside of our town? What is the benefit of having a vehicle with boat towing capacity if it won't always be onsite for expeditious use?' We look forward to your clarification of these matters. Respectfully, The Agawam City Council Finance Sub-Committee members cc: Full Council IN'TEROFFICE MEMORANDUM'. TO: MAYOR RICHARD COHEN FROM: CITY COUNCIL FINANCE SUB-COMMITTEE SUBJECT: CAPITAL IMPROVEMENT PROGRAM DATE 5/17/2012 Dear Mayor Cohen: After reviewing your proposed Capital Improvement Program, the members of the Finance Sub-Committee respectfully request clarification of the following items: 1. On Page 3 you indicate in Item 4A, that principal and interest spending will not exceed approximately $1 million annually. That estimation is inconsistent with the figures set forth on Page 3 1. Please explain the reason for this ,large inconsistency and advise which figures are the most accurate for our purposes of evaluating the Capital Improvement Plan. 2. The Capital Improvement Plan calls for a Fire Department vehicle with towing capacity to be used by the Deputy Fire Chief. It appears that such a vehicle will be driven home by the Deputy Fire Chief whom does not reside within the Town of Agawam. How is that practical and of what benefit is there to the citizens of Agawam to have this vehicle traveling outside of our town? What is the benefit of having a vehicle with boat towing: capacity if it won't always be onsite for expeditious use? We look forward to your clarification of these matters. Respectfully, The Agawam City Council Finance Sub-Corninittee members cc: Full Council 05/17/2012 10:07 Town of Agawam I P 1- cheryl.stjohn JYTD BUDGET REPORT° Iglytdbud AS OF 5".-17-12 FOR;'2.012 99: ORIGINAL TRANFRS/ REVISED> AVAILABLE PCT 'APPROP: ADJSTMTS BUDGET YTU:EXPENDED ENCUMBRANCES; BUDGET: USED 010 SCHOOL DEPARTMENT ----------------------------------- 90000 51200 SCHOOL COMMITTEE 32,400' .00 32,400,00' 27,400.20 .00 4,999.80 84.61 90000 51220 SCHOOL COMM SECRETARY 19,225 .00 19,`225.00` 17,007.0`9 .00 2,217.91 88.51 90001 52365 SCH COMM LEGAL/CONTR SE 95,000 .00 95,000.00 47;554.94' 4,000.00 43,445.06 54.,3% 90001 62990 SCH COMM OTHER EXPENSE' 15,000 -6,500.00 8,500.00' 7,704.19 .00 '795,81 90,6% 90002 51200 SUPERINTENDENT SALARY 110,182I 31,647.00 141,?829.00 125,438,04 00 16,390,96 88,4% 90002 51205 ASSISTANT SUPT SALARY 95,711 -1,020.00 94,691.00 84660.77 .DO 10,030,23 89.4% 90002 51220 SUPERINTENDENT SEC SALA 59,439_ -1,762,00 57,t677.00; 51,039.60 .00; 6,637.40 88.5% 90003 52170 SUPT DUES/SUBSCRIPTIONS 0 314.40 314.40; 314.40 .00' .00 100.Ot 90003 52230 CENTRAL OFFICE SUPPLIES 9,076`". -563.20 0,.512.00: 6,174.72 483.34: 1,854.74 78.2% 90003 5236G CENTRAL OFFICE CONTR SE 16,366: -1,638.94 14,527.06 8` 369.36 .00' 6,157.70 57„6% 90003 52362 SUPT NEWSLETTER/POSTAGE 11,000 .00 11,000.00` 11,000.00 .00 .00 100.0t 90004 51010 CENTRAL OFFIC NON PRO S 13,362 220.OD 13,582.00 11 721.60 .00; 1,860.40 86.3% 90004 51100 CROSSING GUARDS SALARY 50.,767" -7,831.DD 42,936.00. 40,454.13 .00` 2,481.87 94t2 90004 51200 DIRECTOR OF FINANCE/HR 103,000' 3,403.00 106,403.00' 94,399.84 .00 12,003,16 88.71k 90004 51201 C OFFICE ADM ASST'SAL 50,000 -4,610.00 45,390.00' 42283,61 .00' 3,106.39 93.21k 90004 51220 CENTRAL OFFICE SECRETAR 152,039i 2,927.00 154,966.00' 119,769.6 .00 16,196.35 89.5t 90005 52090 CENTRAL OFFICE MILEAGE- 700 .00 700.00` 194.37 00` 505.63 27.8% 90005 52130 CENTRAL OFFIC VAN SUPPL 4,000 .00 4,000.00 1,347.18 _00` 2,652.82 33.71k 90005 52173 Advertising 0 8,587.74' 8587.74 8,644.74 .001 -57.00 100.71 90007 51211 LIBRARY ASSISTANT 25,751 .00 25,751.00 20,696.62 .00 5,054.38 80.4% 90015 51205 SPED SUPERVISOR SALARY' 85,911, .00 85,911,00 72,.152.34' '90' 13,758.56 84,0% 90015 51215 SUPERVISOR;OF SPED PROD 74„520` 00 74,520.00 59,139.67 .00 15,391.13 79;4t 90015 51216 SPED SUMMER PROGRAMS ST 31310 OD 3,`310.00 3310.00 .001 .00 100.0t 90015 51220 SPED SUPV'SECRETARIAL IS 77,707 .00 77,707.00' 77;990.73 ,00 -283 73 1GO At 90015 52390 SPED SUPV TRAVEL ALLOWA 3,600, .00 31600.00 .00 .001 3,600.00 0% 90019 52000 SPED SUPP TM CONSLT/STI 4,400 .00 4,400.00' 1,397.19 D0 3,002.81 31.8% 90018 52230 SPED DIRECTOR SUPPLIES 12,000 8,951.61 3,048.39` 1„26B.99 00 1,779.40 41.6% 90018 52245 SPED INDIVIDUALIZED/INS 1,000` 969.44 1,969.44- 1,735.41 00': 234.03 88.1% 90018 52360 SPED DIRECTOR CONTR SER 51000 .00 5,000.00: 2,423.32 OD 2,576.68 48,5% 90018 52390 TRAVEL 0 .00 00 842.53 _00' -842.53 100.0% 90020 51105 PHELPS LUNCH MONITOR 15,314 .00 15,314.00` 9,572,47 .00 5,641.53 63.2% 90020 51206 PHELPS PRINCIPAL SALARY 89,406' .00 89,`406,00 79,880.78 .00 9,525.22 89.3 90020 51.220 PHELPS PRIN SECRETARY 9 26,423: .00; 26,423.00t. 32,843.84 .DO r-6,470.84 124-.5% 90021 52230 PHELPS PRIN OFFICE SUPP 2,000' -1,025,00 975.00 723.66 .00 251.34 74.2% 90021 52360 PHELPS PRIN CONTRACT BE 11,000` .00 11,000.00` 7,976,98 .00 3,023.02 72.5% 90021 52369 SAFETY &,-SECURITY 0' 607.50' 667.50" 607.50 DO .00 100.0% 90022 51105 ROB PK LUNCH MONITOR; 9,770 1,443.00; 11,213.00; 10,449.01 .00' 763.99 93:2t 90022 51206 ROB PK PRINCIPAL SALARY 910155 900.00 92,055.00 81,443.82 .00 10,611.18 $8.5% 90022 51220 ROB PK SECRETARY SALARY 31,737 943,00 32,680.00 29`,114.22' .00' 3,565.7B 89.1% 90023 52230 ROB PK PRIN SUPPLIES 1,000 .00 1,000.00 109.13' .00- 890.87 10.9t 05/17/2012 10:07 (Town of Agawam JPG 2r cheryl.stjotn IYTD BUDGET REPORT 1glytdbud AS OF 5-17-12 FOR 2012 99 ORIGINAL: TRANFRS/ REVISED: AVAILABLE PCT' -APPROPr ADJSTMTS: 'BUDGET: YTD:EXPENDED ENCUMBRANCES BUDGET USED 90023 5236C ROB PK PRIN CONTRACT SE 10,000: .00 10,000.00. 8,986,86 40 1,013,14 89.9% 90024 51105 GRANGER LUNCH MONITOR 10,411, .00 10,411,00 7,457.96 .00 2,955,04 71.6% 90024 51206 GRANGER PRIN SALARY 79,750 .00 79,`750.00 69`,541,78 .04 10,208.22 B7.2$ 90024 51220 GRANGER PRIN SEC SALARY 31,48E .00 31,4B6.00 27,354.98 .00` 4,131.02 86.!9t 90025 52230 GRANGER PRIN SUPPLIES 1,000' .00 1,000.00 834.28 .00 165.72 63A%; 90025 52360 GRANGER PRIN CONTRACT 'S 9,600 -1,800.00 7,`800.00' 7>,246.72 .00' S53.28 92.9E` 90026 51105 CLARK LUNCH MONITOR 15,657 -1,287.00 14,370.00 13,376,14 '00 993.86 93.1 90026 51206 CLARK PRINCIPAL SALARY' 102,505' 2,977.00 105,482.00' 94,991,33 .00 10,490.67 90.1% 90026 51220 CLARK PRIN SECRETARY SA 32,127 1,689.00 33,616.00 30`,332.77 .00 1,483.23 89.74 9G027 52170 CLARK PRIN ACCREDITATIO 0 530,00 530.00 _00 .00" 530.DD .A3 90027 52230 CLARK PRIN SUPPLIES 1,000` -530.00 470.00 109.13 .00 360.B7 23.24 90027 52360 CLARK PRIN CONTRACT SER 10,000 500.00 10,500,00' 10,221.5B .00' 278.42 97.3% 9002B 51`206 DOERING SCHOOL PRIN SAL 165,733; 1,624.00 IB7,557.00" 151,,980.98 ,00 35,576.02 81.0% 90028 51220 DOERING SCH PRIN SEC SA 39,598 792.00 40,360.00' 35,767.73 .00 4,612.27 86.6% 90029 52170 DOERING PRIN DUES/SUBSC 0 B00.00 600.00' .00 .00 800.00 .0% 90029 52230 DOERING PRINCIPAL SUPPL 6,000 -670.00 5,330.00 4,691.18 .00' 638,82 68.0%' 90029 52360 DOERING PRIN CONTRACT S 12,000 1,130.00 13,130.00 12,456.00 .00' 674.00 94,9% 90030 51206 J HIGH PRINCIPAL SALARI 183,441; .00 183,441.00 149,804.51 .00 33,636.49 81.<7* 90030 51220 J HIGH PRIN SEC SALARI'E 73,091- .00 73,091.00` 53,521.47 .00 19,569.53 73.2% 90031 52170 J HIGH PRIN DUES/SUBSCR 574; .00 574.00' 530.00 .00 44,OD 92.3% 90031 52230 J HIGH PRIN SUPPLIES' 11,064; 1,674.64 12,730.64, 10,115,03 982,00' 1,641,61 87,1% 90031 52360 J HIGH PRIN CONTRACT SE 13,650 2,000.00 15,650.00' 11-,287.37 4,147.41< 15.22 99.9% 90032 51206 S HIGH PRINCIPAL SALARI' 374,658 00 374,658.00 307392.77 .0 67,265.23 82.`0% 90032 51220 S HIGH PRIN SEC SALARIE 82,367' .00 82,367.00' 75,058.07 .00 7,308.93 91,11k 90033 52170 S HIGH PRIN DUES/SUBSCR' 3,730" 290.00. 4,020.00'. 4,.225.00 .00'. -205.00 105.1% 90033 52230 S HIGH PRIN SUPPLIES 2,980 1,907.00 4,887.00` 3,929.23 .00 957,77 8D,41k 90031 52236 INSTRUCTIONAL EQUIPMENT 0 4,050.00 4,050.00' 3,981.36 .00 68.64 98,3W 90013 52244 SHIPRIN COMPUTER SUPPLI 3,477" -204,51 3,272,49 2,841.63 29.26 461,60 87.7t 90033 52255 SH PRIN COMPUTER HARDWA 0 958.10: 958.10r 1,437.15 .00i -479.05 150.01 90033 52360 S HIGH PRIN CONTRACT SE 48,600 -1,438.00 47,162,00- 44,407.83 427.32 2,326,85 95.-1% 90033 52369 SAFETY & SECURITY' 0 279.00' 279,00' 269.10 .00 9.90 96.5% 90033 52990 S HIGH PRIN OTHER' 4„600 -3,240.29 1,359.71, 926.15 00' 433.56 68.1% 90034 51220 SECRETARY SUBS/OVERTIME' 3,500 00 3,500.00 9,099.50 .00 5,599.50 260.0% 90034 51225 SUBSTITUTE COORDINATOR 11,097 .00 11,097.00' 605.55 .00 10,491.45 5.5% 90035 51210 SPED SUMMER PRG TA SALA 66,198 00 66,198.00 63,205.52 .00 2,992.48 95.5% 90035 51300 SPED SUMMER PRG TCHR SA 63,088 .00 63„088.00 60,982,50' .00` 2,105.50 96.7% 90035 51320 SPED TEACHER STIPEND OS 695 .00i 695.00 505,72 .00 189,28 72.8% 90037 51300 PHELPS KINDERGARTEN SAL 201,870 36,530.DD 238,400.00 129,636.52 .00 108,761.6`8 54.4W 9.0040 51300 ROB" PK KINDER SALARY 158,481 12,871.00 171,352.00 125-,214,90 .00 46,117,10 73. it 90042 51300 GRANGER KINDERGARTEN SA 164-,363 -17,664,CO 146,699.00 96,266.26 .00 50,432.12 65 6t 90045 51210 CLARK TCH ASST (REG ED) 39,779 -1,701.00r 38,078.00 27,969.06 .00 10,088.94 73.5t 90045 51300 CLARK KINDER SALARIES' 139.,637 -39,943.00 99,694.00 71,851.53 .00 25,842,47 74.1 90047 52248 COMP NETWORKING-ELEM 4,650 -4,650.00; .00 .4O' .00 00 .0t 90047 52255 COMP HARDWARE-EL£M 5,,580 -695.30' 4,'884.70 4,'884,70' .00 .00 100 0% 05/17/2012 10c07 ITOWD of Agawam cheryl.atjohn BUDGET REPORT �qlytdbvd AS OF 5-17-12 FOR 2012 99 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED -----------------------I--------------------------------------... ----------------------------------------------------------------- 90048 51300 MUSIC CLEM SALARIES 145,581 ®00 145,581,00 106,552.76 00 39,028.24 73,21V 90050 51300 PHYS ED CLEM SALARIES 156,942 .00 156,942,00 114,326�22 ,Oo 42,615.78 72:8w 90054 51300 ADAPTIVE PZ/OCC THERAPI 271,411 271,411,00 299,443.85 .uo 71,967,15 73�st 90056 S2295 SPED ENRICHMENT TRIPS 2,000 .00 2,000-00 314.00 1,6moo 15.7% 90058 51300 CLEM ART SALARY 103,869 .00 103,869-00 76,668-07 .00 27,200,93 7318% 90059 51210 PHELPS TCH ASST REG 63,814 19,140,00 82,954,00 35,654.79 .00 47,299.22 43.01 90059 51300 PHELPS TEACHER SALARIES 764,420 .00 764,420.00 598,741.44 165,678.56 78.3% 90059 51329 PHELPS ELEM SCIENCE TCH 26,124 .00 26,124.00 19,090.23 .00 7,013.77 7311t 90060 51300 PHELPS READING SALARY 140,746 ,00 140,746.00 103,291.78 .00 37,454.22 73.4% 90060 51315 PH INTENSIVE RATH TCHR 57,050 .00 57,050.00 41,251.52 .00 15,798,48 72.3t 90061 51210 SPED P14ELPS TA SALARY 129,147 .00 125,147,00 103,890.28 .00 25,256.72 80.4t 90061 51300 SPED PHELPS TCHR SALARY 229,123 .Oo 229,123,00 168,479,57 .00 60,643.43 73,5% 90062 52216 PHELPS INSTRUCTIONAL MA 6,526 -82,50 6,443.50 1,390,81 564,40 4,488.29 30.3% 90062 52239 PHELPS TEST f. ASSESSMEN 1,400 200,00 1,600.00 1,187,01 384.23 28.76 98.2t 90062 52241 PHELPS SCIENCE SUPPLIES 300 Do 300,00 257,64 .00 42,36 85,9% 90062 52242 PHELPS CLEM PE SUPPLIES 300 300.00 225.66 '00 74.44 75.2% 90062 52243 PHELPS MUSIC SUPPLIES 300 .00 300,00 288,82 .00 11,18 96�3k 90062 52244 PHELPS COMPUTER SUPPLIE 4,500 -1,654.79 2,845.21 1,977,66 861.55 .00 100,0% 90062 52245 PHELPS GENERAL SUPPLIES 7,000 -200,00 6,800.00 6,021.16 220.64 550,21 91.8% 90062 52247 PHELPS COMPUTER SOFTWAR 2,000 5,4M00 7,400-00 7,199.00 '00 201,00 97,3% 90062 522S5 PHELPS COMPUTER HARDWAR 0 645.11 645,11 645.11 '00 .00 imot 90062 52256 PHELPS RUG RECOVERY SUP 400 ,00 400.00 .00 d00 400.00 .0% 90062 52274 PHELPS WORKBOOKS 12,500 -1,356.21 11,104.7;9 10,844,55 260.24 97,7% 90065 61210 ROB PK TCH ASST SAL (RE 51,020 41,676.00 92,696-00 64,645.99 .00 28,050.01 691,17% 90065 51300 ROB PK TCHR SALARIES 761,795 48,561.00 810,356.00 583,445,50 Do 226.910.SO 72;0% 90065 51329 POD PR CLEM SCIENCE TCH 26,124 Go 26,124.00 19,090,11 .00 7,033;69 71.3t 90066 51300 908 PK READING SALARY 65,281 -25,617.00 39,664.00 29.187,91 .00 10,476.09 73.6% 90067 51210 SPED ROB PK TA SAL 281,151 .00 281,151,00 195,609.54 00 85,461.46 69.6t 90067 51300 SPED ROB PK TCHR SALARY 177,526 177,526,00 145,158,04 '00 32,367.96 8I.8* 90068 52215 ROB PK INSTRUCTIONAL MA 10 000 00 10,000.00 2,989.92 ,00 7,010.08 29.9% 90068 52239 ROB PIC TEST & ASSESSMEN 1,200 .00 1,200.00 ,00 918.68 281.32 76.61 90068 52241 ROB PK SCIENCE SUPPLIES 300 '00 300.00 ,00 00 300.00 Ot 90068 52242 ROB PX CLEM PE SUPPLIES 300 .00 300.00 296.89 .00 3.11 99:0% 90068 52243 ROB PK MUSIC SUPPLIES 300 40 300,00 296.30 '00 3.70 98,9% 90068 52244 ROO PK COMPUTER SUPPLIE 4,500 -4,500,00 '00 .00 '00 .00 .0k 90068 52245 ROB PK GENERAL SUPPLIES 91140 00 9,140,00 4,009.32 00 5,130.62 43,9* 90060 52247 ROB PK COMPUTER SOFTWAR 1,000 1,429.00 2,429.00 2,429,00 .00 '00 100.0% 90068 52255 ROB PK COMPUTER HARDWAR 0 4,748,00 4,748.00 4,748.00 00 .00 100,0% 90060 52256 ROB PX READING RECOVERY 400 .00 400.00 39a55 00 360,45 9.91 90068 52274 ROB PX WORKBOOKS 12,500 '00 12,500.00 8,358.17 .00 4,141.83 66.9V 50070 52245 SPED RPK SPEC SUPP/MATE 0 40,00 40,00 '00 .00 40.00 .0% 90071 51210 GRANGER T.ASST, REGULAR 45,832 '00 45,932,00 34,509.21 Do 11,222,79 75,5% 90071 $1300 GRANGER TEACHER SALARIE 628,218 42,660.00 670,878.00 477,630,62 0 193,247.38 71,2% 90071 51328 GRANGER CLEM SCIENCE TO 33,648 '00 33,648.00 24,588.44 00 5,059,56 73:1% } 05/17/2012 10:07 (Town of_Agawam JPG; 4 cheryl.stjohn JYTD BUDGET REPORT Iglytdbud AS OF 5-17-12 :FOR 2012 99 ORIGINAL. TRANFRS/ REVISED AVAILABLE: PCT APPROP AD3STMTS` BUDGET YTD EXPENDED ENCUMBRANCES` BUDGET USED 90072 51 0D GRANGER READING SALARY 54,210 .00 54,210.00 29,711.32 .00 24,498.68 54,86' 90073 51210 SPED GRANGER TA SAL 207,588` .00 207,588.00` 205,149.32 .00 2,438.68 98.8% 90073 51300 SPED GRANGER TCHR'SALAR 208,425 .00 208,425.00' 134,321.32 .00 74,103.68 64.4% 90074 52215 GRANGER INSTRUCTIONAL 7,800' -2,051.50 5,749.50' 4,755.45 .00' 993.05 82;7t" 90074 52236 INSTRUCTIONAL EQUIPMENT 0i 1,338.46 1,338.46 1,>338.46 .00' .00 300.0#' 90074 52239 GRANGER TEST & ASSESSME 1,200 197.95 1,397.95 1,082.49 .00 315.46 77.4t 90074 52241 GRANGER SCIENCE SUPPLI:E 300 4.75 304.75 304.75 .00 .00 100.0% 90014 52242 GRANGER ELEM PE SUPPLIE 300 .00 300.00 286.73 .00 13.27 9516% 90074 52243 GRANGER MUSIC SUPPLIES. 300'. .00 300.00 .00 .00. 300.0.0 90074 52244 GRANGER COMPUTER SUPPLI 4,500 00 4,500.00 3,317.50 50.00 1,132,50 74.8%; 90074 52245 GRANGER GENERAL SUPPLIE 7,527 1,322,00 8,849.00 7,298.62 1,420.97 129.41 98.5% 90074 52247 GRANGER COMPUTER SOFTWA 1,000' 1,429.00 2,429.00i 2,429.00 .00 .00 100.0% 90074 52256 GRANGER ROG RECOVERY SO 400 .00 400.00 93.30 .00 306.70 23.3% 90074 52274 GRANGER WORKBOOKS 7,429' 2,006.00 9,435.00 11,-817.39 .00 -2,382.3-9 125.3t` 90077 51300 CLARK TEACHER SALARIES 673i,842; 39,940,00 713,782.00c 519,-108.86 .00 194,673.14 72.7% 90077 51328 CLARK ELEM SCIENCE TCHR 33,648' .00 33,648.00 24,588.66 .00 9,059.34 73. t 90078 51300 CLARK READING SALARY 105,399 .00 105,399.00 77,022,66 .00 28,376.34 73.1% 90079 51210 SPED CLARK TA SALARY( 230,269 .00 230,269.00f 159,984.52 .00 70,284,18 69.5t 90079 51300 SPED CLARK TCHR SALARTE 233,936 -1,566.06 232,370.00' 132,772.57 .00" 99,597,43 57,1i` 90079 51305 SPED CLARK INTEGR GR 1 31_,644 .00 31,644.00; 23,140.54 .00 8,503.46 73,111 90080 52215 CLARK INSTRUCTIONAL MAT 7,000". -399.99 6,600.01: 359.01 .00 `6,241.00 5.4t 90080 52236 INSTRUCTIONAL EQUICPMENT% 0= 399.99 395,997 327.90 .00 72.09 82,0# 90080 52239 CLARK TEST K ASSESSMENT 1,000' .00 1,000.00 973.86 .00 26.14 97.4% 50060 52241 CLARK SCIENCE SUPP 300 .00 300.00' 273,65 .00 26.35 91.2% 90080 52242 CLARK ELEM PE SUPPLIES 400 157.53 557,53 557.53 .00 .00 100.0%: 90080 52243 CLARK MUSIC SUPPLIES 300 .0.0 300.00: .00 .00 300.00 .'Ot< 90080 52244 CLARK COMPUTER SUPPLIES 4,500 3,539.82 960.19 1960.18 00 .00 100.01' 90080 52245 CLARK GENERAL SUPPLIES 7,652 1,8iD0.02 9,452.02 9,430.53 .00 21.49 99.8t 90G80 52247 CLARK COMPUTER SOFTWARE 1,100 .00 1,100.00 925.00- OG 175.00 84. t 9GG80 52255 CLARK COMPUTER HARDWARE 0 5,183.52 5,183.52f 5,`163.52 .00 .00 100.0% 90080 52256 CLARK ROG RECOVERY SUPP 400' .00 400.00 -.04 .00 400.04 30t> 90080 52274 CLARK WORKBOOKS 15s,000: -4,`532,72 10,467.28 8,190.97 .00'. i2,276.31 79.31k 90062 52245 SPED CL SPEC SUPPLIES/M, 0' 350,00 350.001 342.76 .00 7.24 97.9% 90083 51300 DOERING TEACHER SALARIE' 1,562,166% 6,582,00 1,566,748.00 1,140,997,97 .00 427,750.03 72;`7t 90084 51300 DOERING RDG/INTENSIVE M 222,734 .00 222,734,00 162,767.31 .00 59,966.69 73:lk 90085 51300 DOERING ART TCAA 52,247' 00 52,.247.00( 36,160,51 .00' 14,066.45 73,1% 90087 51300 DOERING MUSIC TCHR, 129,041 .00 129;043.005 94,300.61 .00 34,742.35 73.1% 90088 51300 DOERING PHYS ED TCHR 127,454 509.00 127,963.00 93,511,37 .00' 34,451.63 73.1% 90C90 51300 DOERING INSTRUCTIONAL T` 50,,364' 00 50,384.00 36,819,17 .00 13,564.83 73.1% 90092 51304 MCAS TCHR DOERING SCH00' 67,917 .00 67,917.00 49,631.61 .00 18,285.39 73.11k 90093 51210 SPED MIDDLE TA SALARY 274,291 .00 274,281,00 238,077.89 .00 36,203.11 96.8% 90093 51300 SPED MIDDLE TCHR SALART 616,909' ,00 616,909.00 451,597.99 .00' 165,311.01 73.12t 90094 52170 DOERING DUES/SUBSCRIPTI 625 .00 625.00 .00 .00 625.00 .ot 90094 52175 DOERIN CLASSROOM SUBSCR- 3',110 .00 31110.00 11601,60 .00 1,508.4'0 51.5%' 05/17/2012 10:07 ITown Of;Agawam IPG s' cheryl.st'john IYTD BUDGET REPORT IglytdBud AS OF :5-17-12 FOR-2012 99 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED: ENCUMBRANCES BUDGET USED 90094 52215 DOERING INSTRUCTIONAL M 15,165 51099.00 20,263.00 19,-499.57 .00 763,43 96,2t' 90094 52236 INSTRUCTIONAL EQUIPMENT' 0 2,345.00 2,345.00 2,332.71 .00 12.29 9915% 90094 52244 DOERING COMPUTER SUPPLI 5,000 225.00 5,225.00 4,1865.00 87.72 272,28 94.8% 90094 52245 DOERING GENERAL SUPPLIE 30?,000 -17,790.00 12,220.OD 7,267.16 156.56 4,796.28 60.8% 90094 52247 DOERING COMPUTER SOFTWAc 1,000 .00 1,000.00" .00` .00 1,000.00 .0%', 90094 52255 DOERING COMPUTER HARDWA 0' 1,500.00 1,500.00 11462.12 .00 37.88 97.`5% 90095 52245 DOERING ART SUPPLIES 3 000 650.00 3,650,00 3,r%648,47 .00 1.53 100.0%i 90098 52245 DOERING MUSIC SUPPLIES 1,500 352.00 1,852.00: 1,089,00; .00 763,00 58.8% 90099 52245 DOERING PHYS ED 5UPPLIE` 700 .00 700.00 655.28` .00 44.72 93.6t; 90100 52248 COMP NETWORKING-MIDDLE 5,580 -5,580.00 .00' .00 .00 .00 .0% 90100 52255 COMP HARDWARE-MIDDLE 4,650 5,550-00 10,200.00" 10,200.00 .00 .00 100.01 90101 52245 SPED MIDDLE ISPEC 'SUPP/M' 0' 226.22; 226.22 166.22' 59.90 .10 100.0t 90102 51210 J HIGH TCH ASST SAL (RE 3,134 00 3,134.00 3,320.10= .00 -196.10 105.9t 90103 51300 J HIGH READING TCH SALA' 184,113 .00' 184,113.00 94,929.13i .00 89,1B3.B7 51.61` 90104 51300 J HIGH ART SALARIES 144,065 00 144,065.00 105,-278.25 .00 38,786.75 73.1%- 90105 51300 J HIGH MATH TCHR SALARY' 448,933 .00' 446,933,0`0 311,=338.2-; 0:0 13`1,594.73 70.7% 90106 51300 J HIGH ENGLISH TCH SALA. 447,977 .00: 447,977,00 278.,449.66': .00 169,527,34 62.2% 90107 51300 J HIGH LANGUAGE TCH SAL} 335,419 .00 335,419.00 256,329.26 .00 99,009.74 70r51 90108 51300 J HIGH SCIENCE TCH SALA 340,,362 .00 340,362.00 248,`726.19" 00 91,635.Bl 73.11- 90109 51300 J'HIGH SOC STUD TCH SAL 309,407 .00 309„407.00 225,050.63 .00 04,356,37 72.7% 90110 51300 J HIGH BUSINESS TCH SAL 125,019 .00 125,019.00 96,694.52' .00 28,324.48 77.3% 90111 51300 HEALTH ED JH SALARY 264„663 .00 264,663.00 235,943.62 .00 2B,739.38 89.1% 90112 51300 TECH ED J' HIGH SALARIES- 94,937 .00' 94,937.00 87,561.52 .00 7,375.48 92.2% 90113 51300 MUSIC J HIGH SALARIES 195,192 .00' 195,192.00 142,640.2B` .00 52,551.72 73.13 90114 51300 PHYS' ED J HIGH SALARIES' 124„117 .00 124,117.00 91,377.47' .00 32,739.53 73.6% 90115 51210 SPED J HIGH TA SALARIES; 135,332 .00 135,332.00 100,163.59 .00 35,168.41 74.0% 90115 51300 SPED J HIGH TCHR SALARI 593,441 .00- 593,441.00 434,380.37' .00 159,060.63 73,2% 90117 52175 JH STUDENT SUBSCRIPTION 1,250 350.00: 1,600.00' 1,590.56' .OD 1.44 99.9% 90117 52244 JH COMPUTER SW/HW/SUPPL. 1:.,150. 400.001: 11550.00 1.499.0.0: .00 51.00 96::7% 90117 52245 J HIGH GENERAL SUPPLIES 10,285 .00, 10,285.00 9,823.01 404.82 57.17 99.4% 90117 52255 JH COMPUTER HARDWARE 7,000` -2,750.00` 4,250,00 .00: .00 -4,250.00 .:0l` 90118 52244 JH MATH COMP HW/Sw/SUPP 1,400 00 1,400,00 336.93 .00 1,063.07 24, % 90119 52245 J HIGH MATH SUPPLIES 1,440 2,128,67 2,568.67 2,564.76'- .00 3.91 99.8% 90119 52244 JH ENGLISH FiW/SW/SUPP 545 00 545.00 .00 .00 545.00 .0% 90119 52245 J HIGH ENGLISH SUPPLIES 300 .00' 300.00 250.96? .00 49.04 83,71k 90119 52246 J HIGH ENGLISH AV SUPP 400 00 400.00 410.00 .00 -10,00 102151` 90120 52244 JH LANG COMP HW/SW/SUPP 250 -180,00 70.00 15.10` 00 54.90 21.61s 90120 52245 J HIGH LANG SUPPLIES 700 180.00 880.00 879.8S' .00 .12 100.01': 90121 52244 JH SCIENCE COMP HW/SW/S' 100, 500,00 600.00 589.00'; .00 11.00 98.2% 90121 52245 J HIGH SCI :SUPPLI:ES 71000. -500.00 6,500.00. 1,580.34 3,9B5.31 934.35 8516%'. 90122 52.244 JH SOC STUD: HW/SWJSUPS 200 .`00 200.00 .00' .00 200.00 .`0% 90122 52245 J HIGH SOC STUD SUPPLIE 2,500 .00 2,500.00 781.43 .00 1,718.57 31.3% 90123 52244 JH BUSIN ED HW/SW/SUPP 1,000 -20.00 9B0.00 367,00- 186.00 427.00 56.4% 90123 52245 J HIGH BUSI ED SUPPLIES 200 20.00 220.00 215.29+ .00 4,71 97.'9% 05117/2012 10:07 ITOWn of AgawaM JPG 6 cheryl.Btjohn JYTD BUDGET REPORT Iglytdbud As OF 5-17-12 FOR 2012 99 ORIGINAL TRMFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED --------------------- -------------------- --------------------- ----------------------------l"-------------------------------- 90124 52244 JH READING COMP HW/SW/S Soo -500.00 '00 uo ,00 .00 .0% 90124 52245 J HIGH READING SUPPLIES 300 800.00 1,100,00 1I090,80 .00 9,20 59,2v 90125 52244 JH HEALTH ED HW/SW/SU 800 -300,00 500.00 .DO 40 500.00 .0% 90125 52245 HEALTH ED JH SUPPLIES 4,800 .00 4,800.00 3,040.32 1,220.61 539.07 88.8% 90126 52244 JH TECH ED HW/SW/SUPP 2,200 -1,245.00 955.00 .00 '00 955.00 ot 90126 $2245 TECH ED J HIGH SUPPLIES 2,500 1,24S�00 3,745.00 2,642,87 11033,78 69.35 98.214 90127 52236 INSTRUCTIONAL 8OUIPMENT 0 1,949.92 -1,949.92 1,S45.92 ,00 4.00 99.8% 90127 52245 MUSIC J HIGH SUPPLIES 2,700 -4W92 2,o00.05 779-87 .00 1,220.21 39,0% 90I2B 52245 PHYS ED i HIGH SUPPLIES 900 .00 900-00 1,234.7S 00 -334.75 137,2t 90129 52245 j HIGH APT SUPPLIES 3,700 -1,250,00 2,450-00 1,704.92 '00 745.08 69.61 90130 52244 COMPUTER SW/HW/SUPPLIES 4,650 -4,650.00 .00 .00 .00 .00 .0% 90130 52248 COMP NETWORXING-J HIGH 4,650 .00 .00 .00 cc 0% 90130 52255 COMP HARDWARE-J HIGH 51580 6,570.00 12,150.00 12,150.00 00 ,00 100.0v 90133 51300 S HIGH MATH TCH SALARIE 764,557 764,557.00 573,449.19 00 191,107'81 75:0% 90134 S1300 S HIGH ENGLISH TCHR SAL 714,085 00 714,085-00 501,206.B2 ,00 212,818.18 70.21, 90135 51300 S HIGH LANGUAGE TCHR SA 511,791 0a 511,791,00 375,910.72 .00 135,890.28 73,5% 90136 51300 S HIGH SCIENCE TCHR SAL 901,313 00 901,313.00 658,092.76 .00 243,220.24 73,0V 90137 51300 S 14IGH SOC STUD TCHR SA 679,986 .00 675,985.00 488,383.30 .00 191,602,70 90138 51300 S HIGH BUSINESS TCHR SA 253,655 .00 253,655.00 190,314,44 00 73,340,56 71.1% 90140 51300 S HIGH ART TCHR SALARIS 132,340 .00 132,340.00 96,929.12 00 35,410.88 73.2% 90141 51300 HEALTH ED SH'SALARY 132,131 .00 132,131,00 96,557-28 .00 35,573.72 7311% 90142 51010 IT TECHNICIAN 76,819 6,777.00 83,596-00 73,950.34 00 9,645.66 salst 90142 61020 IT SPECTALIST - DATA 63,204 -390.00 62,806.00 S5,714.23 .Qo 7,091.77 88.714 50142 51205 IT- INISTRATOR 67,000 670.o0 61,670.00 59,861,86 .00 7,808.14 96.59, 90142 51207 IT SPECIALIST ADM 62.992 236,00 63,228.00 56.136,28 .00 1,091.72 88.8% 90143 51300 TECH ED S HIGH TCH SALA 152,610 .00 152,610.00 93,585,26 00 59,024.74 61.3% 90143 51326 INSTRUCT TECH TEACHER S 159,491 .00 159,451-00 113,335.62 ao 46,155.38 71.1% 90144 51300 MUSIC 9 HIGH TCHR SALAR 99,328 00 95,328,00 72,585.91 .00 26,742,09 73.1A 90145 51300 PHYS ED S HIGH TCH SALA 104,867 -16,318,00 288,545-00 206,711.78 .00 81,837.22 71,6t 90146 51300 ESL TEACHER S HIGH SALA 48,623 .00 48,623.00 35,532.30 .00 13,090,70 73.1% 90147 51210 SPED SH TA SALARY 203,022 .00 203,022.00 143,531.72 00 59,490.28 70.7t 90147 51300 SPED S H1014 TCHR SALARY 767,901 .00 767,901.00 550,335,36 217,565.64 71,7% 9014B 52215 S HIGH INSTRUCTIONAL MA 4,900 -2,512.25 2,307,75 1,702.50 685T25 .00 100.0% 90146 52244 S HIGH COMPUTER SUPPLIE 10,000 -6,396.73 3,603.27 3,603,27 40 .00 Ioc.c% 90146 52245 S HIGH SUPPLIES 27,000 -6,748.23 20,251.77 14,652,80 667.20 4,931.77 75.6% 9014H 52247 914 COMPUTER SOFTWARRYLI 6,000 -6,000,00 -00 .0() .00 -00 .04 90149 52255 S HIGH COMPUT99 HARDWAR 0 17,389.11 17,389.71 17,386.41 ,00 3-30 100.0% 90149 $2170 SH MATH STUDENT DUESISU 100 ,00 100-00 100,00 .00 .00 100.0% 90149 52236 INSTRUCTIONAL EOUIPMENT 0 .00 .00 4,565,00 .00 w4,565.00 100.04E 90149 52244 SH MATH COMPUTER SUPPLI 2,600 -292,82 2,507,18 497,78 .00 1,809.40 21,6t 90149 52245 S HIGH MATH SUPPLIES 8,500 -2,603.95 5,896.05 318-00 .00 5,578.05 5.4t 90150 52244 SH ENGLTSJJ COMPUTER SUP 780 -151.58 428.42 369,90 58.52 .00 loo.ot 90150 52245 S HIGH ENGLISH SUPPLIES 4,050 -1,319,87 2,730.13 631,58 124.70 1,773.85 35.0% 90150 52255 SH ENGLISH COMPUTER HAR 0 1,431,15 1,437.15 956l10 .00 479,05 66.74r.. 05/17/2012 10:07 ITOwn of Agawam JPG 7 cheryl.stjohn JYTD BUDGET REPORT Igly4dbud AS OF 5-17-12 FOR 2012 99 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT` APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 90151 52244 SH LANGUAGE COMPUTER SU 1,130 -500.00 630,00' 93.34 95.96 440.70 30.0% 90151 52245 S HIGH LANGUAGE SUPPLIE 2,070' 834.00 2,904.00r 1,054.23 300.00 1,549.77 46.6t' 90152 52244 SH SCIENCE' COMPUTER SUP 260 .00 260.00' .00 29.26' 230.74 11.3%; 90152 52245 S HIGH SCIENCE SUPPLIES 17` 570' -558.46 17,011.54 11,331.17 5,266.01 413.56 97.6%' 90153 52244 SH SOC STUDIES COMPUTER 0' 1,43,97 143,97` .00 143,97 .00 100.0% 90153 52245 S HIGH SOC'STUD SUPPLIE 2,630 -143.91 2,486,03 709.39 Obl 1,776.65 28.5% 90155 52244 SH ART COMPUTER SUPPLIE 510 .00 510.00 .00 .00 510.00 .Ot 90155 52245 S HIGH ART.SUPPLIES 10,980" 1,234.53 12,114.53; 12;1B6.50 .00: -71.97 100.6% 90156 52237 OTHER INSTRUCTIONAL SER 01 .00 .00 152.6`2 .00 -152.62 100.0% 90156 52244 SH BUSINESS ED COMPUTER 1,270` -96B.27 301.73 58.00 00 243.73 19.2k 90156 52245 S HIGH BUSI ED SUPPLIES 7,240 -1,180.70 6,051.30 4,+206.17 .00 1.845.13 69.,5% 90156 52248 SH BUSINESS ED SW{LICEN' 1,,190; -275.00 915.00 _00r .00 915.00 .OF 90156 522195 SH BUSIN ED ENRICH TRIP' 1,500 519.34 2,019.34', 1,019.34 11000.00 .00 10010%< 90156 52390 BUSINESS ED MILEAGE 260 -244,34 15.66 .00` .00 15.66 Ot 90157 52245 SPED SH SPEC SUPPLIES/M` 0 256.60 256.605 156.60' 200.0`0 -100.00 139.=0t 90158 52244 SH HEALTH COMPUTER' SUPP" 400 172.12 572.12 507.60' 64.52 100 100.0t 90158 52245 HEALTH ED SH SUPPLIES 6,140 437.68 6,577.86r 4,366.97' 2,186.07 24.84 9916% 90159 52248 IT -EXP COMPUTER NETWOR 18,600` -17,347.29 1,252.71' 1,252,46 .00 .25 100.0% 90159 52255 IT'EXP COMPUTER HARDWAR 12,090 10,124.71 22,214.71i 22,214.71 .00 .00 100.0% 90160 52244 SH TECH ED COMPUTER SUP 3`,140 .00'< 3,140.00 2,123.77' .DO 1,016423 67.6% 90160 52245 TECH £D S HIGH SUPPLIES 13`,150 .00 13,=150.00 10,699,88 457.47 1,992.65 84.8% 90160 52241 SH TECH ED COMPUTER SOP" 2,600 .00' 2,600.00 975.00 .00 1,625.00 37,5%; 90161 52245 MUSIC S HIGH SUPPLIES 3,700 .00 3,700.00 3,(497,98 57.00' 145.02 96.`1% 90162 52245 PHYS ED SiHIGH SUPPLIES 4,640 .00= 4,640.00 4,±222.06 425.46 -7.52 100.2t 90164 52000 PL 5`04 EXPENSE' 10,000 -2.840.00 7,160.00 240.00; .00 6,920.00 3.43`, 90164 52090 MILEAGE-ESL/BI-L/TUTOR- 2,500 .00 2,500.00 2,748.36' .00 -248.36 109,`9t 90164 52091 ACADEMIC COORD MILEAGE 1,600 .00' 1,600.00 971.04 .00 628,96 60:7t' 90164 52092 PROF DEVELOPMENT GENERA 73,,000 .00 73,,000,00 36,5917.14 398.00 35,684.86 51 1#' 90164 52195 INSERVICE CONTRACT SERV` 45,000 -10,446,00 34,554.00 .00 .00 34,554,00 .0 90164 52240 ESL/BI-LINGUAL SUPPLIES' 3000 .00' 3,000.00 482.43 .00 2,517,57 16.1% 90164 52260 MEDICAL 6 SURGICAL 0 2,840.00 2,840.00 4,436.31 .00 -1,596.31 156.2t 9'DI68 51300 SPED TCHR VISION/HRNC; 1 58,562 ,00 58,562,00: 13,936.8.7 00 44,625.13 23:8% 90168 51306 TEACHER HEARING IMPAIRE 67,917 .00 67,917,00' 49,370.39s .00 16,546.61 72.7t 90169 51300 SPED SPEECH- TCHR SALARI 748,480' -18,240.00` 730,240.00 540,265,02 .00 189,974.98 74 0% 90170 51020 SPED TUTORS SALARIES 67,950' -2,000,00 65,950.00: 37,835.00 .00 28,115.0`0 57.4% 90171 52090 SPED TUTOR/SP/APE MILER 3,500 00 3,500.00' 2,341.36- .00 1,158.64 66.9% 90172 52990 SPED TESTING 0'. 4,858,94 4,.858.94 4,533,74= .0.0: 325.20 93.3%: 90173 51010 SUBSTITUTE SALARIES 344,500' .00 344,500.00 274,-935.61 .00 69,564.39 79.8%< 90173 51020 TUTOR SALARIES (REG ED) 29,482 .00 29,482.00 19,266.90 .00 10,215,10 65.4% 90173 51300 CURRICULUM 'SALARIES 10,000 .00 10,000.00 157.50' .00 9,842.5`0 1,`6t 90173 51307 NEGOITIATED INCR/DEGREE 49,217 -22,974.00` 26,243.005 .00 .00 26,243.00 .0% 90173 51313 I.S.T. STIPEND 3,324' .00 3,324.00 2„724.61 .00 609,39 81.7% 90173 51320 VIRTUAL HS STIPEND 21020 .00 21020,00 500.00' ,00 1,520.00 24.81k 90175 51205 EARLY CHILDHOOD DIRECTO 29,831 3,412.00 32,243.00 24,742.92 .00 7,500.08 76.7E 0 05117/2012 10!07 [TOwn of Agawam JPG 8 cheryl.stjohn JYTG BUDGET REPORT lglytdbud AS OF 5-17-12 FOR 2012 91 ORIGINAL TRANFRS/ REVISED AVAILABLE PDT APPROP ADJSTMTS BUDGET YTD EXPENDED- ENCUMBRANCES BUDGET USED ------------------­--------------------------------------------------------------- ------------------------------------------------- 90175 51210 SPED EC TCH ASST SALARI 327,325 15,173,00 342,498.00 249,972.41 .00 92,525,59 90175 51300 SPED EC TEACHER SALARIE 413,178 Woo 413,238,00 301,997.78 ,00 111,240.22 73,11k 90183 52275 CLARK TEXTBOOKS 0 431,47 431,47 431.46 .00 .01 100.01 90184 52275 DOERING TEXTBOOKS 1,500 00 1,500-00 .00 OO 11500.00 ot 90185 52275 J HIG14 MATH TEXTBOOKS 529 -Soo,00 25.00 .00 .00 25.00 ot 90186 52275 J HIGH ENGLISH TEXTBOOK loo 1,040.00 1,140.00 1,131.30 '00 8.70 99.2% 90187 52275 0 HIGH LANGUAGE TEXTECO 2,200 -1,040.00 1,160.00 862,34 .00 297,66 74.3% 90188 52275 J HIGH SCIENCE TEXTBOOK 400 .00 400,00 -00 .00 400.00 olk 90189 52275 J HIG14 SO C STUD TEXTBOO 900 .00 900.00 .00 ,00 900.00 Ov 90190 52275 J HIGH READING TEXTBOOK 1,000 .00 1,000.00 783.20 .00, 216.80 79.39 90191 52275 S HIGH MATH TEXTBOOKS 230 31603,95 3,833,95 3,992,27 .00 -58.32 101-5% 90191 52,2*16 S HIGH TEXTBOOK REPAIR 11500 .00 1,500,00 366.70 .00 1®133.30 24.4* 90192 52275 S HIGH FNGLrSH TEXTBOOK 6,380 _11000,00 51380,00 4,608.79 .00 771,22 05-71k 90193 52275 S HIGH LANGUAGE TEXTBOO 7,640 -3,901.09 3,738,91 3,403,74 R00 335,17 91.0% 90194 52275 8 HIGH SCIENCE TEXTBOOK 8,630 Ac 8,630.00 .00 Ao 8,630,00 .0% 90195 52275 S HIGH SOC STUDIES TEXT 1,850 -400.00 1,450.00 1,423,50 00 26.50 96.2% 90196 52275 SH BUS: ED TEXTBOOKS 1,090 2,706.10 3,796,10 2,801.38 .00 -5.28 100.1% 90201 52275 HEALTH ED SH TEXTBOOKS 1,390 -132,91 1,257.09 1,256.31 �00 .78 99.9% 90200 52090 SPED RTF MILEAGE 2,000 .00 2,000.00 B57.87 .00 1,142,13 42.9% 90217 52276 J HIGH TEXTBOOK REPAIR 700 460,00 1,160.00 1,156.00 00 2.00 99.B% 90218 52248 PHELPS LIBRARY TECHNOLO 2,500 -2,495.11 4,69 .00 .00 4.99 Olt 90219 52248 ROB PK LIBRARY TECHNOIJO 2,500 -1,677,00 823,00 146.51 .00 676.09 117.91 90220 52248 GRANGER LIBRARY TECHNOL 2,500 -1,429.00 1,071.00 146.91 .00 924.09 13.7t 90221: 52248 CLARK LIBRARY TECHMLOG 2,500 .00 2,500100 960.50 .00 1,539.50 38,4t 90222 51211 MIDDLE LIBRARY SECRETAR 0 .00 .00 113.54 .00 -113.54 100.0% 90222 51214 ENRICHMENT COACH-RD 22,471 2,112.00 24,583.00 17,968.58 6,614.42 73:1% 90222 51300 MIDDLE LIBRARIAN SAIARY 0 32,570.00 32,570.00 19,834.32 Go 12,735,68 60.9% 90223 52110 DOERING LIBRARY SUBSCRI 360 00 360�00 351,92 00 8.18 97.7v 90223 52270 DOERING LIBRARY BOOKS 1,500 .00 1,500-00 2,218.30 ,00 -718�30 147,9% 90223 52360 DOERING LIBRARY CONTRAC 7,500 .00 7,500.00 5,973.06 .00 1,526,94 79,6% 90224 51220 J HIGH LIBRARY SEC SALA 0 00 .00 1,211.53 ,00 -1,211.53 IGO.Ok 90224 51300 J HIGH LIBRARIAN SALARY 71,201 .00 73,201.00 53,493.00 00 19,708.00 73.1% 90225 52248 JH LIBRARY TECHNICAL SU 700 -460.00 240.00 .00 .00 240,00 'Olk 90225 52270 J HIGH LIBRARY BOOKS 4,400 _650.00 3,760.00 2,641.72 200A0 900,28 75,83 90226 51220 S HIGH LIBRARY SEC SALA 29.848 00 29,848.00 26,749.18 �00 3,098,82 89.6% 90226 51300 9 HIGH LIBRARIAN SALARY 46;319 -46,240.00 79.00 7R.74 '00 126 99.171 90227 52171 SH LIBRARY SUBSCRIPTION 541 37.00 578.00 6I5.00 00 -37.00 106,4% 90227 52245 S HIGH LIBRARY SUPPLIES 1,860 -685.00 1,175.00 1,140.22 Do 34.79 974% 90227 52248 S HIGH LIBRARY TECHNOLO 5,160 6,71,7.00 11,877.00 11,842,00 ,00 35.00 99.7% 90227 52270 S HIGH LIBRARY BOOKS 5,400 .5,469.00 -61.00 30.90 .00 -99,90 44;8t 90229 52246 PHELPS AV/IJBRARY SUPPL 1,100 00 1.100.00 1,064.26 .00 35.72 96,8% '30230 52246 ROB PX AV/LIBRARY SUPPI, 1.100 .00 1,100.00 826.04 .00 283.96 74,.2'k 90231 52246 GRANGER AV/LIBRARY SUPP 160 Do 160.00 .00 ,00 160,00 Ot 90232 52246 CLARK AV/LIBRARY SUPPLI 1,100 .00 1,100,00 142.17 .00 957.83 1219t 05/17/2012 10:07 ITown of Agawam In 9 Cheryl.stjohn jYTD BUDGET REPORT Iglyt,dbud AS OF 5`-17-12 FOR 2012 99 ORIGINAL TRANFRS/ REVISED: .AVAILABLE PCT: APPROP ADJSTMTS BUDGET YTD'EXPENDED; ENCUMBRANCES BUDGET USED 90234 52246 DOERING AV/LIBRARY SUP 500` 6,350.00 6,850,00 6,777.52 .00 72.46 98.9t 90235 52246 J HIGH AV/LIBRARY SUPPL 5,950 -1,6`53.11 4,296.69` 4,021.29 .00 275.40 93.6% 90236 52246 S HIGH G£N AV SUPPLIES 10,000 5,162.35 15,1+62.35 10,559,61 1B0.00 4,422,74 70.8%1 90238 52246 S HIGH ENGLISH AV'SUPPL 200 -200.00 .00 00' OA .00 .Olt 90239 52246 S HIGH LANGUAGE AV SUPP 1,340 -1,340.00 .00; .00' D0 .00 0% 90240 52246 S HIGH SOC STUD AV SUPP' 5BO -500.00 .00' .00` .00 .00 Ot3 90241 52246 S HIGH SCIENCE AV:SUPPL 1` 910 1,910.00 .00 .O0 .00 00 O4' 90245 52246 HEALTH ED JH AV SUPPLIE 700 .00 700.00` 00 .00 700.00 .0%" 90246 52246 HEALTH ED SH AV SUPPLIE 960. -290,00 690.00 '.3S4.31:. .QO 335.6`9 51,3% 90248 51300 JH AV SAL DIFFERENTIAL 1,546 .00 1,546.00' 1,129.75- .00 416.25 73. k 90251 51220 GUIDANCE DOERING SEC SA 31,524 3,086.00 34,61D.00 31,078.37' .00 3,531.63 B9.B% 90251 51300 GUIDANCE DOERING COUNSE 120,357 .00 120,357.00 $7,1953.09 .00 32,403.91 73.1% 90252 52170 GUIDANCE DOERING DUES 155 .00' 155.00' 60.00 .00' 95,00 3B.7% 90252 $2230 GUIDANCE DOERING SUPPLI 900' .00 900.00 747,78 .00 152.22 83.1% 90253 51220 GUIDANCE J HIGH SEC SAL 32,387 .00 32,387.00` 29,197,76 00 3,189.24 90.2% 90253 51300 GUIDANCE J HIGH PRO SAL- 106,,813` .00 106„813.00` 75,217.42' .00 31,595.56 70.4%': 90254 52170 GUIDANCE J HIGH DUES 100 .00 1`00,00 DO' .00 100.00 0%` 90254 52230 GUIDANCE Jr HIGH SUPPLIE' 700 .00" 700,00 204,43' .00 495.57 29,2% 90255 51205 DIRECTOR OF GUIDANCE K- 77,501 .00 77,501,00 57,201.75 .00 20,299.25 73.8 9025$ 51220 GUIDANCE S iHIGH SEC SAL- 74,205 .00 74,205,00 66,923.11 .00' 71261,89 90:2% 90255 51300 GUIDANCE S' HIGH`PRO SAL, 292,764 .00. 292,.764.00 213,942.67 .,00 76,821,33 73.1#: 90256 52170 GUIDANCE S HIGH DUES 220 .00 .220,00 45.00' .00 175.00 20.5t 90256 52230 GUIDANCE S HIGH SUPPLIE' 21,060 .00" 2,060.00 1,361.47 00 698.53 66.1% 90256 52244 S HIGH GUID COMPUTER SU` 2,020 -149.00' 1,871.00 199.00'S 678.02 993,98 46.9%' 90256 52247 S HIGH GUID COMPUTER SO r 0 149,00z 149.00 149.00 .00 .00 100.0% 90256 52270 GUIDANCE 9 HIGH BOOKS 770 .00 770.00 GO 240.00 530.00 31.2*° 90256 52359 SH GUID VIRTUAL HIGH SC 6„000 .00 6,000.00 5,f250.00 .00 750.00 87.56 90256 52360 S HIGH GUIDANCE CONT SE'- 13,300 .00 13,300.00 13,`108.74 .00 191.26 98.6% 90257 51210 TEACHER ASSISTANTS' 0 33,274.00' 33,274.00 .00' .00 33,274.00 .0% 90257 51300 SPED EDUC`TEAM LEADER '( 269,157 .00' 269,157.00 185,046.31 .00 84,110.69 68„Bt 90258 51300 SPED SCH ADJUSTMENT COU 506,088 .00 506,088.00 367,135,29` .00 138,952,71 72.51 90259 51300 PSYCHOLOGIST/BEHAVIOR 1 298,023 _00' 298,023.00 217,`786.41 00 80,236.59 73.'11k 90259 51316 SPED PRIMARY INTERVENTI 70,540 .00- 70,540.00 51,548.52 00 19,991.48 73.1%' 90260 52090 PSYCH MILEAGE 1,200 .00- 1,200.00' 11219,99' .00 -18.9`9 101.6% 90260 52236 INSTRUCTIONAL EQUIPMENT 0 714.00' 714.00 714,00 00 .00 100.0%` 90260 52245 PSYCHOLOGICAL SUPPLIES 2,250 .00- 2,250.00` 1,c965,17` 93.50 191.33 91,5% 90260 52360 PSYCH CONSULT/COUNSELIN- 325,751' -207,391.20 118,359.60 80,244.42'- 8,190.28 29,925.10 74.7%: 90260 53260 OT/PT/SPEECH THERAP£UT,I 74,790 210,631.20 285,421,20: 259,566.79' 55,079.29 -29,224.88 11D.23f 90260 53720 OT/PT/SP/PSYC/INDEPENDE 0' 15,000,00 15,000,DD 3,974.75 DO` 11,025.25 26.3% 90272 51300 DOERING BAND/YEARBOOK 'S 2£,241 .00 2,241.00 1„637.38 .00 603.62 73.1% 90274 51300 J HIGH OSA:DIFFERENTIAL 9.,315'. r00 9,315.00. 4,421.62: .00. 4,893.38 47.51k 90.274 51302 JH YRBX/NEWSPAPER_:STIPE 1.,625: .00 1,625.00: 1,167.50 .00 437.50 73.1% 90275 52245 J HIGH OSA:SUPPLIES 1-,S00: .00 1,500.00 413.40 .00 1,086✓60 27.6% 90277 51300 S HIGH OSA DIFFERENTIAL 21,315 32,970.00 54,285.00 22,165.08 .00 32,119.92 40.8% 05/17/2012 10:07 [Town of Agawam JPG 10' cheryl.stjohn 1YTD BUDGET REPORT igiytdbud' AS OF 5-17-12 FOR 2012 99 ORIGINAL TRANFRS:/ REVISED AVAILABLE PCT ;APPROP. ADJSTMTS;. BUDGET" YTD: EXPENDED ENCUMBRANCES: BUDGET USED 90278 52245 S HIGH THEATER SUPPLIES 4,130 -593.60 3,536,40 376.56 2,399.63 760.21 78.51; 90278 52990 OSA'S HIGH OTHER 9,350 8,857.57 18,207.57 17,{835.70 .00 371.87 98.0% 90279 52290 OSA MUSIC ENTRY FEES' 2,330 500.00 2.830.00 1„415.23 .00 1,414.77 50.0 90280 51300 BAND J HIGH SALARIES 1-,546 .00 1,546,00 1,129.75 .00 416.25 73.1% 90281 52245 JH BAND SUPPLIES 33,000 .00 3,000.00 448.90 .00f 2,551.10 15.0% 90282 51300 BAND S HIGH SALARIES- 51,413` 00 5,413.00 2,259.50 00" 3,153.50 41.7% 90283 52245 BAND S HIGH SUPPLIES 4,500 340.92 4,8i40.92' 4,475,10 1,649.40 -1,283.58 126.5t 90283 52415 BAND" S HIGH UNIFORMS 1,500' 505.50 2,005.50 1,505.50 .00 500.00 75. t 90284 52296 BAND TRANSPORTATION` 1.,4705 5,530.00 7,000.00' 2,681.34 .00 4,318.66 38.3% 90295 51300 S HIGH GRADUATION SALAR 2,823 .00 2,823.00' .00 .00 2,823.00 .0% 90286 52070 SH GRAD BLDG RENTAL 6,000 100.00 6,100.00; 5,%750.00 .00 350.00 94.3% 90286 52245 SH GRAD SUPPLIES; 3,000 -314.00 2,686.00 2,144.06 45.42 496.52 81.51 90286 52990 SH GRAD OTHER 2,900 314.00 3,214.00' 2,794.40 415.00 4.60 99.91r 90287 51300 S HIGH CHEERLEADER COAC 3,,324` .00 3,324.00 2,E321.00 .00 1,003.00 69.6 90288 52245 SH CHEERLPR SUPPLIES 100 .00 100.00 100.00 .00 .00 100.0% 90288 52297 CHEERLEADER TRANSPORTAT 6005 .00 600.00 .00 .00' 600.00 .0% 90288 52990 SH CHEERLEADER OTHER 360 00 360.00 360.00 ,00 .00 100.0t 90289 51300 MIRROR S HIGH PRO.SALAR. 1s.,546' .00 1,546.00` 1,129.75 .00 416.25 73.11; 90290 52360 SH MIRROR CONTRACT SERV'' 6,225 11579.80 7,<804.801 8,i684.80 .00 -88D.00 111.3k 90291 52150 UTILITIES 'TELEPHONE`. 24,000i .00 24,000.00. 47,036.15 .00: -23,036.15 196.0%. 90294 52030 GRANGER MAINT EQUIP' 0' 518,75 518.75' 518.75 .00 .00 100.0% 90296 52030 DOERING MAINTENANCE EQU' S00 .00 500.00' 418.00 00 82,00 83.6% 90257 52030 J HIGH ADMIN MAINT EQUI 4,700` .00 4,7100.00' 1,228.00 .00 3,472.00 26.1% 90299 52030 S HIGH MAINTENANCE,EQUI 4,040' -774,42 3,265.58' 922.50 330.00` 21013.00 39.4% 90318 52030 MAINT EQUIP VEHICLE 500 .00 500.00 ,00 .00. 500.00 .:Ot. 90321 52060 SPED MAINTENANCE EQUIP 61000: .00 6,000.00 147.00 .00 5,853.00 2.54 90347 52404 TUITION COLLABORATIVE 1,2085,248 .00 1,208,248,00 1,089,957.00 55,645.00 62,446.00 94.Bt 90348 52401 TUITION PUBLIC {RECOVER: 15,.000 .00 15,000.00 .00 .00. 15,000.00 .04' 90348 52402 TUITION COLLAR SPED' 30,900 .00 30,900.00 32,250.00 .00 1,350.00 104.0 30348 52404 TUITION OCC/VOC {NON SP' 87,907 _00 87,907.00 20,`832.00' .00 67,075,00 23.7% 90349 52400 SPED INSTATE TUIT':NON-:P 53,064: 23,964.00 77,028.00- 42,959.31. 22.,,621.23: 1'.1,447.46 85,1k 90349 52401 SPED' TUITION INSTATE PU' 0; .00 .00; 2,435.00 .00 -2,415.00 100.0%. 90349 52403 SPED TUITION OUTSTATE 285,329' -23,964.00 261,365.00' 187,876.32 73-,488.68 .00 100.0% 90349 52405 TUITION RESIDENTIAL INS 296,747` _00 296,747.00 163,109.76 45,554.97 88,082.27 70.31k 90349 52406 OUTSTATE RESIDENTIAL TU' 82;368 .00, 82,368.00> .00 .00 82,368.00 .0$ 90349 52401 Homo/Hospital Tuition 0 2,000.00 2,000.00' 1,517.80 .00 482,20 75.9t 90350 52402 SPED TUITION COLLABORAT' 1,152,,487 .00 1,152,487.00 973,087.22 17,505.66', 16`1,894.12 86.0% 90367 52030 IT/DP MAINTENANCE EQUIP' 8,370' -4,571.00 3,799.00` 3,798.97 .00` .03 100.at 90367 52041 IT/OP CONTRACT SERVICES 127,939 -3,736,75 124,202.25 110,135.92 11,305,93 2,760.40 97.8% 90367 52090 IT/DP MILEAGE 2<,325 .00 2,325.00' 1,r407.4`2 .00 917.58 60.5% 90367 S2236 INSTRUCTIONAL EQUIPMENT 0'; 3,185.00 1,185.00 3,185.00 .00 .00 100,0t' 90367 52240 DATA PROCESSING SUPPLIE 9021- -4,92.6.89 4,094.11. 4,093.89 .00. .22. 100.0% 90167 52245 IT SUPPLIES 1,395- .00 1,395.0D` 1,115.66 .00 279.34 80.0% 90367 52247 ID/DP COMPUTER SOFTWARE 9'„300 11,4 8.4"1 20,748.41- 592.40 20,166.01 .00 10010% 05/17/2012 10:07 ITown Of Agawam, JPG 11 cheryl.stjohn JYTD BUDGET REPORT Iglytdbud AS OF.5-.17-1,2 FOR 2012 99 ORIGINAL TRANFRS/ REVISED AVAILABLE PCT APPROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 90367 52246 IT/DP LICENSES 37,200; -23,544,15+ 13,655.85 11,520,00 2=,051.92 83.93 99,41E 90367 52255 IT/DP COMPUTER HARDWARE' 18,,600 42,919.26 61,519.26 31,814.86 29,703.52 .88 100.0% 91092 51300 ESL TCHR ELEMENTARY SAL 203,,909 .00 203,909.00 140,758.89 .00 63,110,11 69r k 91164 52360 DW GUIDANCE-CONTRACT SV 0 .00' .00 3,360.00 .00 -3,360.00 100.0i` 91218 51211 PHELPS LIBRARY ASSISTAN 25,160 .00 25,160.00 18,717.80: .00 6,442.20 74.41" 91218 512.14 ENRICHMENT COACH-:PHELPS: 21,155. .00` 21,155.00 17,033.09 .00 <4,121.91 80.5% 91218 51300 PHELPS LIBRARIAN 18,207 00 18,207.00 13,305.30 .00 4,901.70 73.1% 91219 51211 ROB' PK LIBRARY ASSISTAN' 21,325 542,00' 21,867,00 16,i037.64< 00 5,829.36 73.3k 91219 51214 ENRICHMENT COACH-ROB PKs 23,,787 -2,346.00' 21,441,00 15,611.75 .00 5,829.25 721Bk' 91219 51300 ROB PK L18RARIAN 18„207 .00" 18,207.00 13,^305.33' .00 4,901.67 73.1% 91220 51211 GRANGER LIBRARY AS5ISTA 26,261 .00` 26,261.00 19,605.79` .00 6,655.21 74.7% 91220 51214 ENCHRICHMENT COACH-GRAN 23,787 00' 23,787.00 18,297.54' .00 5,489.46 76-.9% 91220 51300 GRANGER LIBRARIAN; 18,207i .00? 18,r207,00' 13,305.33' .00 4,901.67 73.1% 91221 51211 CLARK LIBRARY ASSISTANT' 25,080 327,00 25,407,00 18.,723.90'. .00 '6,663.10 73..7k: 91221 51214 ENRICHMENT COACH CLARK 21,155 1,989.00' 23,144,00 16,916.84 00 6,227.16 73.1% 91221 51300 CLARK LIBRARIAN SAL 18,207 .00i 18,207,00 13,305.33`; .00 4,901.67 73.1% 91248 51301 SH AV SAL.DIFFERENTIAL :2,316 .0.0 2,318.00 1,696.12> .00 621.BB 73.2% 91341 51100 ATHLETIC OTHER SALARIES; 33,000 2,428.00+ 35,428.00 35,,422,60 .00 5.40 100.0%I 91341 51205 ATHLETIC/PE SUPERVISOR 71,177 3,756.00` 80,933,00 56,962.781 .00 23,970,22 70.4k 91341 51220 ATHLETIC SUPERVISOR SEC 29,742 96.00 29,838.00 26,012.14 .00 3,825.B6 67.2% 91341 513GO ATHLETIC COACHES-SALARY q 108,076 57,640.00 165,716.00 118,869.70 .00 46,946.10 71.7% 91341 51340 ATHLETIC TRAINER 47,247 1,518,00r 48,765.00 34,947.22, .00 13,817.76 71,,7% 91342 52240 ATHLETIC SUPPLIES 17,281 -3,200.00 14,081.00 12,`.571.63s 1.,194.00 313.37 97.+6% 91342 52297 ATHLETICS TRANSPORTATIO 41,675 -1,640.00 40,035.00 11,629.96 .00 8,205.04 79.5% 91342 52360 ATHLETICS CONTRACT SERV 7,645' 3,200.00 20,845.00 10,565.88' .00 279.12 97:0 91342 52415 ATHLETIC UNIFORMS 11,145 .00 11„145.00 6,`870.74; 4,260.00 14.26 99.9% 91342 52990 ATHLETICS OTHER, 29,645 .00` 29,645.00 37,211.15' .00 ->7,566.15 125:5k 99011 52090 11 CARRY FORWARD PROF D' 0 69.97 69.87 1,f179.87- 00 -1,110,00 168B.7t; 99011 52092 11 CARRYOVER PROF"DEVEL 0 1,110.00 1,110.00 .00 .010 11110,00 .0t' 9`9011 52150 11 CARRY FORWARD TELEPH 0 2,410.17 2,410.17 2,`410.15 .00 .02 100.0% 99011 52245 11 CARRY FORWARD COPY P 0 54,132.85 54,132.85 54,126.54 .00 6.31 100_0% 99011 52247 11 CARRY FORWARD :SUB FI 0 12,360.00 12,360,00 12,360,00` .00 .00 100.01 99011 52248 11 CARRY FORWARD IT INS` 0 1,600.00 1,600.00 1,600.00` .00 .00 100.0%: 99011 52270 11 CARRY FORWARD SH GUI 0 180.00 180,00 180,00 .00 .00 100.0% 99011 52360 11 CARRY FORWARD JH SCH` 0 6,750.00 6,750.00 6,750.00 .00 .00 100.0►" 99011 52990 11 CARRY FORWARD REIMBU 0 20.00 20.00 20.00 .00 .00 100.0% GRAND TOTAL 32,263,439' 389,615,89 32,653,054.89 24,29B;289.39 307,502.15 7,567,263,35 75.6% - END OF 'REPORT - Generated by Cheryl St. John *`* 0 .. h Page l of 1 barbara bard Front. Cheryl StJohn Seat';: Thursday, May 17,.2012 10:48 AM To: barbara hard Subject: SPECIAL. REVENUE 4-30-12.xls Attachments: SPECIAL REVENUE 4-30-12.xis Attached are special revenue summaries through 4-30-12 for the town and school that Paul Cav ll requested. Town funds 630, 632, 635, 642 and 647 have deficits because they are:reimbursement grants where the money is expended first and then copies of the invoices are submitted for reimbursement. If you have any questions feel free to call me at 726-9707. Cheryl /t 7/20 t TOWN OF AGAWAM TOWN SPECIAL REVENUE FUNDS FISCAL YEAR 2012 AS OF 4130112 FUND BAL DES OFU AUDIT FUND BAL FUND I; DESC 71`112011 REVENUE IN EXPENDITURES OUT ADJ' 413012012 200 ANNIE'SULLIVAN; $ 1,513 1,513 201 BEAUTIFICATION $ 25,196 20,764 14,146 $ 31,813 202 CABLE TELEVISION $ 336,649 114,461 133,757 $ 317,354 204 COUNCIL ON AGING $ 8,061 3,437 8,036 $ 3,461 206 COA MEALS ON WHEELS $ 42,761 119,619 131.507 $ 30,874 207 COA MEMORIAL FUND $ 2,400 $ 2,400` 208' COA NUTRITION $ 2J27 2,201 2.773 $ 1,656 210 DOG LAW $ 4,546 5.009 $ 9,555 211 EMERGENCY FUEL FUND $ 2,778 2,300' 3,372 $ 1,706 212 GAZEBO BUILDING $ 150 $ ISO 213 HEALTH DEPARTMENT $ 50 $ 50 214 LIBRARY $ 118,352 $3,848: 42,373 $ 139.828 215 B.HODGES MEMORIAL $ 92 $ 92 218 PARKS AND RECREATION $ 75,675 111,456 130A99 $ 56,632 219 PERRY LANE DAY CAMP' $ 121,490 114,922 148.71E $ 87,693 220 PLANNING BOARD $ 50,180 3,20 588 $ 52,852 222 RUTH TIERNEY $ 25 $ 25 223 TUCKAHOE RENTAL $ 213,218 $ 213,218 224 VETERANS COUNCIL: $ 24,277 3: 24,277 226 WETLANDS FEES $ 32.000 "$ 32,000 228 FIRE AMBULANCE $ 856,656 1,098,575 1,158,797 50000 $ 746,435 230 LIBRARY EXPANSION 19,726 $ 10.726 231 FIRE GIFT' $ 9,993 904 2,414 $ 8,483" 232 POLICE ACCIDENT $ 28,862 $ 28,862 233 POLICE DARE $ 6,695 1,560 1,734 $ 6,510 234 POLICE DEPARTMENT $ 37,120 530 $ 37.650 236; COMMUNITY POLICING $ 144A60 302 440 (50a479) $ 93,842 236 DA DRUG FORFEITURE $ 9,118 11,205' 6,511 $ 13,811 237 ARTS AND HUMANITIES $ 12,128 21,049 18,819 $ 14,358 238' COA VAN GIFT $ 2,652 50 $ 2,602' 239 COA ELDER AFFAIRS $ 15,293 44,150 36,803 $ 22,640 241 LIBRARY HEALTH $ 28,050 $ 28,050 244 LPVTA $ 7 $ 7 245: TREE PLANTING $' 1,527 $ 1.527 246 SKATEBOARD PARK $ 4,600 $ 4,500 247 INSURANCE DAMAGE CH 44 S53 $ 28,175 106,377 87,332 $ 46,220 249 SAFE GRANT $ 430 $ 430 325 TITLE V SEPTIC $ 22,370 $ 22,370 602 COMPOST BINS $ 312,279 76,391 75,463 $ 315.216 004 SCHOOL ST ATHLETIC FIELDS $ 289 26 $ 315 605 SKATEBOARD PARK $ 1,571 $: 1,571 607 CATV'DATA SUPPORT GRANT $ 9.824 846 $ 8,978 608 CATV PEG ACCESS GRANT $ 30.391 20,000' $- 10,391 $10 SENIOR CENTER EXPANSION $ 4,125 $ 4,125 611 CPA SURCHARGE FUND $ 3,338,297 535,273 19,816 $ 3,853,753 612 FIRE PUBLIC SAFETY EQUIPMENT GRANT S 5' $ 5; 613 FIRE FEMA GRANT $ 140 $ 140 614 PARKS 8 RECREATION GIFT FUND $ 56,713 57,870 20,137 $ 94,445 615 EMERGENCY MGT DEPARTMENT $ 2,,101 3.735 2,152 $ 3„685> 516 HANDICAPPED PARKING FINES $ 30,531 4,325 7 $ 34,849 617 MUNICIPAL RECYCLING'GRANT $ 32,859 $ 32,8 618 FI R EFIGHTING EQ U IPMENT GRANT $ 11 $ 1 11 619 SAFE GRANT 3 3,295 5,266 4,796 $ 3,762 620 VACCINATION FUND $' 83,367 10,303 4.297 $ 89,433 626 FIRE CODE VIOLATION FUND $ 100 $ 100 627' PYNCHON POINT $ 33 $ 33 628 LIBRARY STATE AID $ 75,983 38,129 17,101 $ 97,011 829 2008 HEALTH CAPACITY BUILDING $ 13„599 630 FED DRUG ENF ASSET FORFEITURE $ 279 $ 13' 9 $ 27 279 632 COPS SECURE OUR SCHOOLS GRANT $ (9.6681 24,206 20,032 $ (5,414) 633 STREET OFFLAGS-VETERANS $ 1,945 524 $ 2,469 634 BULLET PROOF VESTS-POLICE $ 4,920 795 $ 5,715 635 FY08 ASSIST TOFIREFIGHTERS $ (146) $ (146) 636: SCHOOL ST BARN $ 1.601 349 $ 1,253 639 SECURE OUR SCHOOLS VIDEO GRANT $ - 65,830 131,661 $ (65,631) 642 FYI 1 911 TRAINING GRANT $ (338) $ (330) 643 FYI 1 911 DEPT SUPPT INGE $ (21,579)` 17,851 46JS0 50,479 $ 1 644 MILITARY CARE PACKAGES $ 1,374 $ 1,374 $45 FY10 ASST TO FIREFIGHTERS GRIT $ 80,352' 5700 $ 22,752 646 FYI STATE 911 DEPT SUPPORT GR' $ 6%374, 61,689 $ 7,485 647 FYI STATE 911 DEPT TRAINING $ 208 $ (208) 656 NFIE PRIVATE GRANT $ 685 $ 685 667 SMALL BUSINESS ASSISTANCE $ 13.364 4,702 7,531' $ 10.534 807 POLICE OUTSIDE DETAIL $ 269,638 778,271 710,699 $ 337.209 $ 6,547,i61 $ 3,554,370 $ 65,830 S 3,129,996 $ 50,000 $ $ 8,987,372 SPECIAL REVENUE TOWN TOWN OF AGAWAM SCHOOL SPECIAL REVENUE FUNDS FISCAL YEAR 2012 AS OF 4130112 FUND BAL- OFS OFU AUDIT FUND BAL FUND# DESC 71112011 REVENUE IN EXPEND OUT ADJ 413012012 250 SUMMER SCHOOL 50,874 39,905 44,176 $ 46,604 251 ADULT EDUCATION $ 26,231 23„790 24,875 $ 25,146 252 SH ART REVOLVING $ 1,862" 437 $ 2,299 253 EARLY CHILDHOOD TUITION $ 27,496 59,204 75,53 S 11,163 254 HIGH SCHOOL ACTIVITIES $ 150,430 128,645 54,914 $ 224,161= 255 LOST BOOKS 15,482' 8,06E 3,457 $ 20,091' 256 SCHOLARSHIP FUND $ (9,231) 860 10,500 '$ 2,129 257 SCHOOL ATHLETICS $' 4,644 61,380 49,314 $ 16,710 259 SCHOOL LUNCH $ 4%010' 940,459 1,062,535 S (73,065)' 260 11 TCHR QUALITY(140) $ 17,641 6,691 28,060 $ (3,728) 261 11 ED JOBS FUND PRC $ 2,429 6,903 8,913 $ 418 262 11 RACE,TO THE TOP(201) S 1,542; 6,231 7,147 $ 626 263 11 E CHLDHD ALLOC"(262) $ 1,910 1,910 $ 264 11 SPED 94-142(240) $ (4,607) 138,640 132,135 S 1,897 265 12 COOP SERV.GRANT' $ 22,417 25,917 $ (3,500) 266 11 E CHLDHD ARRA(762) S 1,738 1,781 $' ( 3) 267 12 QUALITY KINDERGARTEN (701) $ 0 82,953 82,880 $ 73 268 11 DRUG,FREE SCH(331) $ 3,578 3,578 $ - 269 11 QUALITY F DAY K(701) $ 297 297 S - 270 11 SPECS ARRA(760)' $ 19,041 18,477 S 564 271 11 STREAMLINE DATA MGT(120) S 8,0010 8,000 S" - 272 11 TITLE III(180) (63) 15,698 15,635 $ 273 12 ACADEMIC SUPPORT(632) S 264 13,730" 13,730 $ 265 274 11 TITLE I AR"RA(770) 5,163 5,163 $ 275 12 TITLE 1(305) $ 0 341,160 312,570 S 28,591 276 12 TITLE III $ 19,660 18,195 S 1,465 277 11 TITLE 1 (305) $ 38,554 70,541 97,Q03 S 12,093 278 12 COOP SERVICE GRANT(115) 21,275' S' 21,275 279 12 E CHLDHD ALLOC(262)' $ 3,414 36,225 30,076 $ 9,564 280 12 SPED ENTITLEMENT(240) $ 18,694 850,474 813,578 $ 55,590' 281 12 TITLE I CARRYOVER s 4,226 17,809 42,051 $ (20,016) 282 12 TITLE IIA EDUC QUAL(140) S (766) 67,807 63,124 s 3,918 283 11 ACADEMIC SUPPORT(632) $ 284 12 SPED IMPROVEMENTS $ 2,699 8,323 2,055 $ 8,967 285 SPED 50:50 CIRCUIT'BREAKER $ 547,115 494,409 987,281 142,337 S' (88,094) 286 11 SF SF CARRYOVER(780) $ 7,246 $ (7,246) 287 SCHOOL AGED CHI LOCARE $ 694519 417,706 580,510 S 529,715 288 12 ED JOBS $ 272579 265,720 $ 6„859 269 12 CFCE 237 EEC $ - 18,475 13,136 $ 5,339 290 12 RM S 32,202 28,463 S 3,739 291 11 UPK(EEC) $ (3,273) 4,502 1,228 $ 292 12 INCL PS LEARNING(391) $ 6,326 8.892 $ (2,566) 293 11 MMSI $ (55) 33.600' 12,112 $ 21,433: 294 11 INCLUSIVE P$LRNG(391) $ 1,044 1,044 $ 295 FED"COUNSELING $ (76,670) 280,538 344W3 $ (139,204) 296 TITLE III CARRYOVER $ - 47,926 4,208 S 43,719 297 11 CFCE(237) $ 5,730 5,730' $ - 298 SCHOOL CHOICE REVOLVING $ 169,400 256,500 193,215 $ 232,685 299 11 LANGUAGE:8 LITERACY DEV 297B $ 467 3,735 4,202 $ 1,800,248 $ 4,835,363 $ $ 5,504,140 $142,337 10,500 $ 999,633 SPECIAL REVENUE SCHOOL TOWN OF AGAWAM CAPITAL PROJECTS FUND FISCAL YEAR 2012 as of 5/15/12 FUND BAL REVENUE OFS OFU FUND BAL FUND# DESC 711/2011 FED STATE OTHER IN EXPEND OUT ADJ 5/15/2012 301 SCHOOL ROOF $ 3,424 $ 3424 302 WATER REHABILITATION SYST $ 1,498 $' 1,498 303 N.AGAWAM REVITALIZATION $ 2,472 $< 2,472 304 INDUSTRIAL PARK DEVELOPMENT $' 2,085` $' 2,085 305 AERIAL;PLATFORM`TRUCK $ 3,088 $ 3,088 306 F H SOUTH WEST AREA SEWERS $ 26,617 $ 26,617 308 N. AGAWAM REVITALIZATION $ 14,263' $ 14,263 312 GOLF COURSE IRRIGATION $ 8,575 $' 8,575 314 MAIN STREET WATER MAIN $ 121,970 $` 121,970 315 FIRE HEADQUARTERS $ 266 $ 266' 321 PLAYSCAPE GIFT ACCOUNT $- 1,512 $ 1,512 323 CAMPBELL DR/FLORIDA DR SP $y 31,827' $ 31,827 324 PUBLIC LIBRARY EXPANSION $ 446,925 56,340 $' 390,584 326 RT 187 WATER MAIN $ 677,132 1,595' $ 675,537 327 CHAPTER 90 $: 22,428 555,976 786,244 $ (207-,840) 329 AHS LIBRARY EXPANSION $ 1,563` $ 1,563, 330 MAIN STIR PWED $` (212) $ (212) 331 DPW FACILITY ACQUISITION $ 43,632 $ 43632 332 PHASE II STORMWATER/COMBINED $; (14,611) 37,518 12,031 $ 10,875 333 MIDDLE SCHOOL ROOF REPLACEMENT $ - $ 334 MIDDLE&JUNIOR HIGH REPAIRS $ 18.588' $ 18,588 335 MODULAR CLASSROOMS $ 21,811 $ 21,811 336 FIRE PUMPER TRUCKS $' 828 $ 828 337 SENIOR CENTER $ 26,600 22,040 $' 4,560 338 PERRY LANE POOL RENOVATION $ 5,417 $ 5,417 339 WESTFIELD RIVER SEWER MAIN $ (8,120) $ (8,120) 340 SANITARY SEWERS $ (2,153,630) 373,579 $ (2,527,209)' 341 BUILDING MAINTENANCE STORAGE BLDG $ - 122,540 $ (122,540)' 342 TOWN TELEPHONE SYSTEM $ 307,760' $ (307,760) 343 JR HIGH GREEN REPAIR PROGRAM $ 88,017 157,491 $ (69474)' TOTALS $ (694,053) $ $ 643,993 $ - $ 37,518 $ 1,839,620 $ - $ $ (1,852,162); Note-A bond anticipation note and/or bond will be issued for funds with deficit balance before June 30, 2012 Note;-Chapter 90 has a deficit because it is a reimbursement;grant. Expenditures are made then copies of the invoices are submitted for reimbursement. r E ..e WELCOME TO THE NE10HRORHOOD A-3 �i 1�- m!�- -n-ki , 05/15/2012 12>43 Town of Agawwn �� chezyl.stjo xn Y d'B DG REPORT 1 tdbud CAPITAL, PROJECTS GEN FUND AS OF 5115l12 FOR 2012 99 ORIGINAL T RS( REVISED AVAILABLE PCT "PROP ADJSTMTS BUDGET YTD EXPENDED ENCUMBRANCES BUDGET USED 100 GENERAL FUND 16610 CAPITAL :IMPROVEMENTS 16610 52450 HGNY OTHER EQUPMENT 150,000 2,677.80 152,677,,80 152,559.54 .00 118.26 99.9% 16610 52460 STREET IMPROVE PROGRAM 150,000r -2,677.80 147,322.20 38, 56.39 .00 108,765.81 26.2 16610 53001 VTR HIGH ROOF DESIGN IEEE 0 60,000.00 60,000 00 40,208.00 .00 15,792..00 67.0% 16610 58415 TRAFFIC 'LIGHT IMPROVEME 20.000 .00 20,000.00 .00 .00 20,000 00 _0% 16610 58501 DPW GPS VEHICLE TRACKIN 50,000 .00 50,000.00 .00 .00 50„000:00 .0 16610 58502 ENGINEERING DIG SCANNER 25,000 .00 25,000.00 24,234 ,44 .00 765,56 96.9 16610 58503 FIRE AIR, COMPRESSOR 40„000 .00 40,000.00 38, 602.00 .00 1,398.00 96.5 16610 58504 FIRE EMERG BACKUP GEN 12,000 .00 12,000.00 .00 .00 12,000.00 .0% 16610 58505 FIRE CARDIAC MONITORS 8,928 .00 8,928.00 6,400.00 .00 2,528.00 71.7 16610 58913 COUNTY LAND ACQUISITION 9,500 .00 9,500.00 .00 .00 9,500,00 .0 16610 58914 SIDEWALK REHAB & EXT. 5,000 .00 5,000,00 ,00 .00 5,000-.00 .0% 16610 58934 GYM DOOR SIR, HIGH SCHOOL 25,000 .00 25,000.00 .00 .00 25,000.00 .0 TOTAL CAPITAL IMPROVEMENTS' 495,428 60,000.00 555,428.00 300,560.37 .00 254,867>:63 54.1 TOTAL GENERAL FUND 495,428 60,000.00 555,428.00 300-,560,37 .00 254,867®63 54.1% TOTAL EXPENSES 495,428 60,000.00 555,428.00 300,560.37 .00 254,867.63 GRAND TOTAL 495,428' 60,000.00 555,428.00' 300,-560.37 .00 254,867.63 54.1% ** END OF REPORT - Generated by Cheryl St. Jahn ** 131JJO W 13 113l noo i ,own of Arvawam8 Interoffice Memorandum To CITY COUNCIL FINANCE SUB-COMMITTEE CC: FULL CITY COUNCIL From: MAYOR RICHARD 'COHEN Date- 0/17/2012 Subject: CAPITAL IMPROVEMENT PROGRAM Clear City Council Finance Sub-Committee, In response to your letter dated May 17, 212 in regards to the Capital Improvement Program I am happy to supply you with the following information you requested for clarification, Question 1 -•As outlined in the Capital Improvement program the following are general assumptions, #4A,states, "Limit General Fund principal and interest payments to approximately 1 million dollars per year . This should have been removed, as for numerous years this has not been the caste. Thank you for bringing this to my, attention. The figures in each year's appropriation and bonding schedule are estimates for evaluating the Capital Improvement Program as they are updated each year based on need and the ability to fund. This plan is the Towns best estimate for your review. The appropriations for each year are made as part of the whole budget. The principal and interest payment for each year are included in the line items portion in section 30 of the annual operating budget. The Capital Improvement appropriations for each year are shown in Section 31. Question 2 -As to your concern regarding the,Deputy Fire Chief taking the vehicle outside of Agawam. I want to advise you that the Deputy lives in Feeding Hills. The new vehicle in the C.I.P. will have towing capacity providing a back-up for our current tow vehicle. The 1996 vehicle the Deputy is driving currently is becoming unsafe due to adva ed age and body deterioration. The Chief and Deputy Eire Chief are on-call 24 hourtpe day for the safety of our residents. >r Respectfully, M 3> P c Richard A. Cohen s ` ' Mayor INTEROFFICE MEMORANDUM O: MAYOR RICHARD COHE 1 FROM. CITE'COUNCIL CIL FINANCE SUB-COMMITTEE SUBJECT: CAPITAL IMPROVEMENT PROGRAM DATE 51 t 7/2012' Dear Mayor Cohen: After reviewing your proposed Capital Improvement Program, the members of the Finance Sub-Committee respectfully request clarification of the following items: I, On Page 3 you indicate in Item 4A, that principal and interest spending will not exceed approximately $l million annually. That estimation is inconsistent with the figures set forth on Page 31. Please explain the reason for this large inconsistency and advise which figures are the most accurate for our purposes of evaluating the Capital Improvernent Plan. 2. The Capital Improvement Ilan, calls for a Fire Department vehicle with towing capacity to be used by the Deputy.Fire Chief: It appears that such a vehicle will be driven home by the deputy .Fire Chief"whom does not reside within the Town of Agawam. How is that practical and of what benefit is there to the citizens' of Agawam to have this vehicle traveling outside of'our town? Wheat is the bcncf'rt of having a vehicle with boat 'towing capacity if it: won't always be onsite for expeditious use? We look forward to your clarification of these matters. Respectfully,- The Agawam City Council Finance Sub-Committee members cc Full Council TownofAgwam Employees Subject to Vehicle Fringe Benefit "Type Loc Al Last First 950 7440 421 Blackak Brian 950 742 420 Bonesteel Steven 950 7250 969 Bosini Richard 950 7220 24 Brown diary 950 7420 282 Decker John • 950 7450 419 Flyrm James 950 7420 526 Colba Christopher InCA 950 7420 359 Myers Ralph 950 7220 1370 Sirois Alan 96,0 950 7250 519 Urbinati Dominic 950 7111 21 Cohen Richard 950 7137 583 Nicora Chet Town otAgawam Page l Policy Period: 711111--711112 2122J12 aga 2011 ATTACHMENT SA-VEHICLES LIST ALL VEHICLES GARAGED IN AGAWAM MASSACHUSETTS Coverage odes i= Fall coverage - {liability,comprehensive&collision) 2= No collision - (nability,comprehensive) 3- No physical damage - ltiability) 4= Physical damage only - icomprehensive,collision) Aga Mass warn amont indicates now cost No. No, Cov. Dept. Description Now Plate No. GVW V N Mtatorcvcles with full CBVeraq Cyl 68 1 15 2006 Harley Davidson 14,961 MMC4647 _--. 1H011FM '106Y678170 cyz 69 1 15 2006 Harley Davidson 14,961 1ti MC7199 w- 1HID1�MWIX6Y67795 Total motorcycles with full coverage Trailers T-1 70 1 14 2010 'Wanco Radar Board(Speed) Tail 5,000 MP896F IB9AF51IX9P825333 T-2 74 1 14 2009 Carmate Emergency Reponse Utili 2,000 M701i70 - 5AX714D43I.004039 239 1 14 2010' rsTS-5 Utility Trailer 3,000 MP896F I B9AF511 X9P825333 240 109 1 8 1971 Islastercratt Boat Trailer I50 FI4773 182038 385 28 1 10 1989 Intl Trailer(paint mach) 21000 M40127 3$00 IZFUF0817K8003486 395 83 1 10 2006 Brim Utility Trailer 4.595 M72929 - 43YOC20265CO45646 719 27 1 21 2007 Big Tex Utility Trailer 1.200 M80090 --- I BVLX081072A73025 720 157 1 It) 2010 Cross Country Flat:Bed Trailer 4,000 M83398 996 431FS2020A1000444 Total trailers with full coverage 379 44 2 10 1988 International Trailer 2,000 M40-131 3,500 1 i?FUF101058003140 386 77 2 10 2004 Big TE Utility Trailer 2,000 M69028 --• 16VAX1 1442A32109 Total trailers with No collision 207 21 3 8 1931 Intl Buffalo Water Trailer 2.000 MF910 -_-- A42300 291 ill 3 23 2006 CARMATE UTILITY TRAILER 6,500 M74268 —_ 5A,3C714DO61.00227 324 46 3 10 1979 General Flatbed Trailer Roller 2>000 M28-516 3,000 3TL7925 342 108 3 10 1973 Woodchuck Chipper Trailer 10,000:r M74274 0 STWC 3243 354 55 3 10 1999 Custom Flatbed Trailer 3,295 M61553 10,000 58732163XXIO04781 409 48 3 4 1985 Superior Ideal Trailer' -- M33-868 2,000 1 ZT42 B12F4018120 420 138 3 4 2009 Anderson Utility Trailer 1,79 1 77-901 4YNSN18229CO56912 701 49' 3 10 1985 Quality Utility Trailer 2,00(} M33-871 8685 903 52 3 10 1985 Colemore Utility Trailer -- M40-035 -- LCAA83OT9FT086674 Total trailers with no physical damage Total Trailers 1 Town of Agawam Page 2 Policy Period: W1111 -711112 2122112 aga 2011 ATTACHMENT 5A-VEHICLES LIST ALL VEHICLES GARAGED IN AGAWAM,MASSACHUSETTS Coverage Codes: 1=- Full coverage (liability,comprehensive&collision) ^ 2= No collision - (liability,Comprehensive) 3=, No physical damage - (liability)' 4= Physical damage only - (comprehensive,collision)' Aga Mass warn amont '=indicates new Cost No. No. Cov. !Sept Description New Plate No. GVW VIN Vehicles with;full coverage 101 1 14' 2011* Ford Crown Victoria 31,000 MP375F - 2FABP78V5BX106850 102 158 1 14 2011 Ford Crown Victoria Sedan 30.000 MP187D - - 2FABP7BV6BX172324 103 154 1 14` 2011 Ford Crown Victoria 30,000 MP378F --- 2FABP78VSBX168324 104 1 14+ 2011 Ford Crown Victoria' 30,000 MP2410 2FABP7BV5BX149228 105 1 14 2011 Ford Crown Victoria 30,000 MP404F 2FABP7BV3BX107544' 106 131 1' 14 2011 Ford Crown Victoria 30,000 MP1840 2FASP78V5BX107545 107 10 1 14 2033 Explorer Sport Utility 35,000 MP9663 - i FMZU72K03UB06346 108 85 1 14 2006 Ford Taurus Sedan 21,000 44HG70 -- 1FAFP53U96A124052' 109 1 14 2009' Dodge Charger 30,000 712FXK 2B3KA43V49H582442 110 78 1 14 1997' Ford Crown Victoria 26.000 290CW! - 2FALP71W3VX229842 111 76 1' 14 2007, For¢gown Victoria 25,000 81GR32 T 2FAFP.71WO7X117533 112 76 1' 14 2004 Ford Crown Victoria 25,000 M64619 2FAFP71W64X143324 _.. -� 113 58 1 14 2000 Ford Crown Victoria 23,035 8900SX - - 2FAFP71 W7YX212401- 114 86 1 14 2005 Ford Crown Vic.Sedan 26.807 MP402F --- 2FAFP71W75X176950 115 84 1 14 2006 Ford Crown Victoria Sedan 28,000 M 30494 +-•- 2FAFP71 W76X108320 116 4 1 14 2008 Ford Crown Vic DARE 25,730 MP9164 - 2FAFP71V48X112196" 117 5 1 14 1997 Ford E350 Van 29,982 MP124A 9,400 1 FMEE1 lLlVH895245 118 145 1 14 1995 Marked Ford Van Prisoner Van 30,000 MR115A 1FTSS34L6WHA56432 119' 1 14 2009 Crown Vic 30,000 MP405F 2FAHP71VSSX104444 121 71 1 14 2000 Hyundai 25.000 4461NY - -- KMKWF35VXYA300550 122 1 14 2005 Ford Taurus 30,000 6442CV 1FAFP53U05A159240 124 112 1 14 2003 Ford Crown Vic Unmarked 17,719 8652XB 2FAHP71 W23X192012 126 147 1' 14 2001 Audi A6'' 32,000 799X$Md - WAUED64891N163367 125 152 1 14 2006 Nissan Maxima 16,000 775EA3 1 N4SA41 EX6C843045 123 156 1 14 2003 Unmarked Lincoln Navigator 25.000< 213KH9 5LMFU28RO3U32345 128 1 14 2012 Unmarked Ford Escape' 3631-11-9 1 FMCU5K36CK820521 201" 8 3 8; 2007 Pierce Pumper 400.000 MF4606 - 4P1CC01T77A007357 202 9 3 8 2007 Pierce Pumper 400,000 MF4656 -- 4P1CC01T97A007358 203 6 3 8' 1996 Pierce Pumper 390,000 MF7820 - iPICT02U3TA000486` 204 7 3 8 1996 Pierce Pumper 390,000 MF6216' -- 4PICT02U5TA000490 210 113 3 8' 2002' Pierce Dash Tower Truck 1,100,000 MF7727 -- 4P1CT02S73A002626' 211 8 8; 2010 Ford E450 Cutaway Ambulance 163,510 MF9719 1FUXE4FPBADA06498' 212 96 3 8 2006 GMC Cutaway Ambulance 165,000 MF6183 17,500 iGOE4V1266F400931 213 1 8 2010'` Ford E450 Cutaway Ambulance 165.000 MF9719I ---- 1FDXE4FP8ADA16707 215 114 3 8' 1986' GMC Saulsburg Rescue Vehicle 100,000 MF6283' - 1GDM7D1 G6GV538811 217 2 8 2003` Ford Expedition 10,800 M83936; 1 FMPU16L23LA20095 222 53 1 8 1997' Ford gown Victoria, 20,497 MF6218' 2FALP71W7VX229861 226 102 1 8 2005 Ford Expedition 35,000 MF7816 1FMPU16555LA34805 228' 1 8; 1997 Ford F350 Pickup 30,000 MF9731 1 FTHF36GOVEC46709' 233 1 21 2011 Ford Escape Hybrid 32,000 MF74 1 FMCU5K33BKA75767 345 1 8'; 2000' Ford Ranger MFO58 1FTYR10X8YTA59559 301 101 1 10 2007" F450 Rack Body 35,000 M80099' 14,000` 1FDXF47P57EB31229 302 75' 1 21 2004 Ford F150 Pickup-4 W0 20.000 M70129 6,250 2PTRFl OW44CA38978' 303 13' 1 10 1999' Ford F150 Pickup 22,755` M54230' 6,000 2FTRF08W4XCA13223 304 88 1 21 2006 Intl 700ser Henderson Muni BE) 123,145 M74264 40,000 1 HTWCAAR16 i313570 Town of Agawam Page Policy Period_ 711111-711112 2122112 aga 2011 ATTACHMENT SA-VEHICLES LIST ALL VEHICLES GARAGED IN AGAWAM,MASSACHUSETTS Coveratle Codes: 1= Full coverage - (liability,comprehensive&collision) 2= No collision - (liability,comprehensive) 3= No physical damage - (liability) 4= Physical damage only - (comprehensive,collision) Aga Mass warn amont =indicates new Cost' No. No. Cov. Dept. Description Now Plate No. GVW VIN Vehicles with full coverage (continued)' 306 15 1 21 1995 Ford LN8000: 67,129 M52450 35.000 1FOYR82EXSVA37753 307 1$ 1 10 1997 Ford LN8000 Dump/Spreader 72,650 M64-728 35,000 1FDYR82EIWA28654' 308 56 1 10 2001 Freightliner FL80 Dump/Spreader 86318 M64-738 40,000 iFV6JLB851HH13056 309 144 1 10 2009 International 7400 Dump Sander 106,000 M77.263 40.000 1 HTWCAAR99JO84284 310 141 1 10 2009 Intemational 7400 Dump Sander 109,000 M77-275 40,000 1 HTWCAAR09JO84285 311 95 1 21 2005 Ford Explorer 23.000 M72932 tFMZU72EX5U883688 312 1' 21' 2011 ' International 7400'Dump' 146,380 M82877 40,000 1HTWCAAROBJ394314- 313 136 1 21 1986 GMC Truck 50,000 M15-429 iGDL6T1G4GV526438 314 89 1 21 2006 Ford F250 Pick-Up 32,745 M74253 1FTNF205X6EA65610 315 90 1 21 2006 Ford F350 Utility oRW, 32,745' M74254 1 FDWW36Y26FA65611 316 80 1 21' 2004 'Ford Cutvan 30,161 M69599 iFDWE35L74HAO1147 317 91 1 21 2005 International700SER DUMPISpre. 81,818 M72014 40,000 1lHTWCAARX5J167720 320 97 1' 21 2006 Ford F450 Utility 36,545 M74263 0 1FDXW46Y86EA76977 322 25 1 10 1995 Ford F450 Dump 31.707 M52442 15,000 1 F0LF47FXSEA28192 325 57 1 10 2001 Freightliner F1-80 Dump Truck 74.891 M64746 40,000 1FV6JLBB31 HH13055 326 1 21: 2011 Ford Escape Hybrid 27,892 M83377 1FMCU4K37BKA75765 328 98 1' 10 2005 Ford F250 Pickup 21,928 M69592 i FTNF21575=A45604 332 54- 1 10 1999 Freightliner Medcon FL80 pump 77,813 M62515 35.000 1 FV6JLABXXH882267 333 26 1 10 2005 1nt'l 700SER Dump 50,200 M69581 1HTWCAAR55JO14677 334 103 1' 10 2003 International 7400 Dump/Spread 91,611 M62295 40.000' IHTWCAAR63JO51735 337 62 1 10 2002 Freightliner Dump Truck 74.910 M67275 1FVABXBS22HJ73761 338 107 1 10 2007 ;Ford F150 Pickup 20,000 M74991 1 FTRF14W27NA59025 339 151 1 10 2009' Ford F150 Pickup`"' 28,000 M81516 1 FTRF1 4W49KC6001 1 340 64 1 21 2001 International Sewer Cleaner Truck 194,427 M40046 11-ITGBADR611-1343554 343 12' 1 10 2007 Trierlrerex TV900-1 27.000 M73845 43YDC16157CO57072 345 19 1 21 1999 Ford Ranger 19.200 M54033 1FTYR10V9XTA17799 357 22 1 7 1996 Ford Econoline Club Wagon 17,448 M64-587 1FMEE11Y6THA40828 358 35 1 16 2002 Ford Focus 4 door Sedan 14,540 M66937 1FAFP343X2W267924 359 23 1 7` 1997 Ford Escort Wagon 13,150 M54672 3FALP15P6VR116322 360 142 1 21` 2008 Ford Escape Hybrid 23.000 M76570 1FMCU59H58KE09145 361 115 1 21 1999 Ford Ranger Pickup 14,800 M54231 4000 1FTYR1OV2XPA27325 362 61 1 10 2001 Ford Super Duty Crew Cab Dump 50,999 M64620 10,000 1 FOXW47F51 EA94343 363 139 1; 10 2005 Foal F450 Crew Cab Dump 31,880 M77267 16,000 1 FDXW47R58EE39519 364 140 1 10 2008 Ford F450 Dump 31,880 M77266 16,000 1 FDXF46Y28EE3951 8 371 24 1 21 1999 Ford F450 Super Duty Dump 44,490 M61503 15,000 1Ft7XF47F2XEC28816 373 72 1' 21 2003 'Ford F250 Pickup 16,971' M70152 8.800' 1 FTNF20183ED58190 375 92 1 10 2006 Ford F450 DRW Cab Rack Body`' 281,480 M74273 15,000 1FDXF46Y36EC65729 383 63 1 10` 2001 Ford Pickup 18,436 M66950 6600 1FTRF17W91NB70738 338 29 1 20 1997 International Model4700` 78,000 M47449 35,000 1HTSCAAR2VH414380 J Town of-Agawam Page 4 Policy Period: 711111 -711112 2/22i12 aga 2011 ATTACHMENT$A-VEHICLES LIST ALL VEHICLES GARAGED IN AGAWAM,MASSACHUSETTS Coverage Codes: 1= Full coverage - llabllity,comprehensive$collision) 2= No collision - (liability,comprehensive) 3= No physical damage - (liability) 4= Physical'damage only - (comprehensive,collision Aga Mass wam amont` '=indicates new Cost No. No Cov. Dept:- Description New Plate No. GVW VIN Vehicles with full coverage(continued)' 344 36 1 3; 1996 Ford Escort Sedan 12.293 M47-435 3FASP13J2TR104014 390 1 4 2012 Ford DRWSUP M88538 0 1FDUF4HY7CEB23718' 391 93 1 1 2005 Ford Explorer U728 4x4 23.000 M72933 5,984 1 FMZU72E85UB83687" 392 66 1 10 2002 Ford Ranger Extended Cab 4WO 20,000 M66946 4,940 1 FTYR45E62TA15866 402 32 1 4 1989 Ford F250 Pickup 12,700' M40-148 2FTHF25H6KCA47847 406 73 1 4 1998 International 400SER Box Truck 15.200= M44.687 25,500 1HTSCAAMBWH547182 407 110 1 4" 1999 Ford E250 Van 10,000 M40911' 1 FTNE24L2XHB07375 411 33 1 4 1995 Ford E150 Econoline Van 15,594 M52403 6700 1FTEE14Y1SHB69459 413 94> 1 4 2006 Ford E•350 Van 32,000 M74262 9,400 1FDWE=35t26HA73392 414 153< 1 4 2005 Ford Econovan 27,355' M78609 1FTSE34L45HB27729 565 31 1 9` 1998 Ford Contour 16,197 M54294 D 1FAFP66L6WK274395 608 17" 1 7 1998 Ford Contour 19,197 M54293 0' 1FAFP66L8WK274396 609 1 14 2012 fiord Escape M81814 0 1FMCV5K36CKB20525 730 67` 1 6 2002 Chevrolet Silvaderado 4WD'Pickul 17,222, M67265 6,400 1GCEK14V42E153207 801 104 1 19' 2000 Ford Cut Away Van 30.000` M64624 FDWE35S7YHB31541 802 116 1 19 2006 Ford EcoVan 15.886' M74272 1FTNE241-06DA10634 803 1 19 2010' Ford Transit S9B 23,215' M83387 NMOKS9BNBAT033809: 807 9 2011 International 700SER DUMP' M82877 1HTWCAAROBJ394314 902 38 1 22 1999 Ford Ranger 14,640" M60183 1FTYR10VlXTA17800 905 13$ 1 18 2007 Ford EcoVan 15,000` M79-433 1FTNE24L87DB3806 954 41 1 16 1997 ford Escort Sedan 12,340 M41417 1FALP13P6VW192316 Total vehicles with full coverage 02 Vehicles with no collision 206 42 2 8< 1993 Ford F250' 12,000 M54233 8,000 1FTHF26H6PL826642 208 43 2' 8 1986 Chevy 4 WD Pickup 10,000; MF8383 -- 1 GCHD3458GF446920 290 117 2` 23= 1994 Ford Bronco 20,000< MF906 1FMEU15H9RLB43518 327 18 2 21 1997 Ford Ltgcon Crew Cab Util Body 38.212 M56288 10000 1FTJW35H4VEDD8639` 341 99" 2 12; 1995 Ford F150'Pickup 14.800 M69595 6250 1FTEF15Y9SLB92349 404 i06 2 4 1983 Ford E150 Van 7,999 M16506 1FDKE04Y1DHA42641 405 159 2` 4 2000 Ford E250 Van 10,000 M79434 1FTNE2424YH891174 Total vehicles with no collision 7 Vehicles with no physical damage 100 45 3; 14 1968 VW Sedan(Safety Bug) 2,000 MPKK 18818453 121 79 3' 14 2000 Hyandai Sonata Sedan 11,000 4461NY KMHWF35VXYA300550 906 149 3 8 1997 Rogue Boat/Trailer MF6282` 18Y1LAX27U1011373 Total vehicles with no physical damage 3 Total of all vehicles 133- INTEROFFICE MEMORANDUM TO: RICI ARD M. THEROUX FROM: BARBARA BARD, COUNCIL CLI-RK SUBJECT: JUNK Df-I-M: I7R LICENSC(S) DATE: MAY 22, 2012 Please be advised that during their regular council meeting, on Monday, May 21, 2012, the Agawam City Council approved the following: JUNK DEALER LICENSE(S) RENEWAL: TO-2012-22 T's Jewelers 559 Springfield Street, Feeding Hills, MA t44z (gammat tslt4 of Musartmants I'll 7- 40M of APPLICATION FOR PERMIT No To THz Licr.NSINr. AUTHORrrms: In accordance with the provisions of the Statutes relating thereto, application for a Permit is herebv made bv 7�, wi Name L (Ftdi A%M* of perowt. firm or corpomtsan Maxus* appiscatuas) ssj? (Cive Imatusu bV strwet and numorr) t C= State clearly purpose for wlucn permit 0 is requested. =n :X rn Permit issued 19 C-) 5: ` THE COMMONWEALTH OF MASSACHUSETTS EXECUTIVE OFFICE OF PUBLIC SAFETY AND SECURITY Department of Criminal Justice Information Services 200 Arlington Street,Suite 2200,Chelsea,Massachusetts 02150,MASS GOVJCJIS TEL.617-660-4600 . TTY;617-660-4606 • FAX.617-660-4613 Enhancing Public Safety t7 oval L.Patrick v av Through InformationTirnoth P Murr Mary Elizabeth Heffernan :;fames f.Slater,III Exchange Governor � oeutenantcovernor � .het'retaryof Public Safety and Secunty I AttingCommiWoner • To wham it may concern: A computerized search has been made of the database of the Department of Criminal Justice Information Services, which is the repository for criminal records in the Commonwealth of Massachusetts, for TOE MAN, ZINOVY, date-of-birth 05/2 f and have determined that he or she has no adult criminal court appearances: Signed under the pains and penalties of perjury this Fifth day of April, 2012, Criminal Justice Information Services Suffolk, ss: 4 ,., {County On this ' day of ,20 ,before me®the undersigned notary public,personally appe Rd (name of document signer),proved to me through satisfactory ev4ence`-� of iderrtifica ion,which were /r .? r &. ' , o be the person who.signetl the pret�E ding =v+ attached document in my presence,ar d who swore or affirmed to me that the contents of the do cr erxt cD are truthful and accurate to the best of(his)(her) knowledge and belief, f rn Dated; 041512012' - ; Notary-Public - My commission expires ! ♦ !1 Enhancing Public.Safety Through information Exchange Commonwealth of Massachusetts-- Department of Criminal Justice Information Services No record found in Court Activity Record Information file on CJIS for: Name:e' TCKMAN, ZINOVY DOB: 05/29/56 T day's date: 04105/2012 Today's time: 12: 1 This indicates that there is no record in the Massachusetts'Probation Central File Automated Database for this name and date of birth pursuant to your request. Please check that the name referenced above matches the name and date of birth of the person whose record you requested_ IT IS YOUR RESPONSIBILITY TO ENSURE THAT THE RESPONSE CORRESPONDS WITH THE REQUEST. If there is a discrepancy please contact the CORI Unit at ( 17)660-4 40, Requested by: PERSN Completed by CCRI-OAR 029 -CHAR; a 7 Z Licry-se Number Name' ', 1// Fix,: �4�¢rexr. r I--=:i-y under:he pemidties of c:� -v:,: L to -my es i eli Z ve =e aU stazc=re _S and Vmd an smte yes :-Z=Ired under law. Sr c es CalparsYt Na= `1 G,^=..e Mt= arn it A,"p%ele) VO Sc=ai Sz==ty 3 T .:: h= Jr M rn "Iris license�U not be issued unJ e s :his cer n_melon a is signed by the applic=; Your Soma] Se_rmty INT=ber wW i''be =- = ned zo ;�c.'Vfzs�w�tlser=ss Depa== of Revenue to der__ zinc wne her you have =zz - �,• or=pa,,=est oblizations. ;Li ensets who :',zZ to corm heir non-filing r delinque:ncy�1 be subie�}t rice a s�zs�en inn c� revocLnm This rc uest is made under t :r =—thomv foss.GI. c. 62C s. 49.k r r Town o- f Ag-awam Interoffice Memorandum To: CITY COUNCIL FINANCE SUB-COMMITTEE CC:: FULL CITY COUNCIL From: MAYOR RICHARD CCHEN Date: 0 117/201 Subject: CAPITAL IMPROVEMENT PROGRAM Dear City Council Finance Sub-Committee, In response to your letter dated May 17, 2012 in regards to the Capital Improvement Program I am happy to supply you with the following information you requested for clarification. Question 1 As outlined in the Capital Improvement program the following are general assumptions, # 4A states, "Limit General Fund principal and interest payments to approximately $1 million dollars per ear". This should have been removed, as for numerous years this has not been the case_ Thank you for bringing this to my attention. The figures in each year's appropriation and bonding schedule are estimates for evaluating the Capital Improvement Program as they are updated each year based on need and the ability to fund. This plan is the Towns best estimate for your review. The appropriations for each year are made as part of the whole budget. The principal and interest payment for each year are included in the line items portion in section Ca of the annual operating budget. The Capital Improvement appropriations for each year are shown in Section 31. Question 2 As to your concern regarding the Deputy Fire Chief taking the vehicle outside of Agawam_ I want to advise you that the Deputy lives in Feeding Hills. The new vehicle in the C.I.P. will have towing capacity providing a back-up for our current tow vehicle. The 1996 vehicle the Deputy is driving currently is becoming unsafe due to advanced age and body deterioration. The Chief and deputy Fire Chief are on-call 24 hours per day for the safety of our residents: Respectfully, Richard A. Cohen. Mayor INTEROFFICE MEMORANDUM 70-- M'A',Y-0RR1CRA—R,D--C-OHEN FROM: CITY COUNCIL FINANCE SUB-COMMITTEE SUBJECT: CAPITAL IMPROVEMENT PROGRAM DATE: 5/17/2012 Dear Mayor Cohen: After reviewing your proposed Capital Improvement Program,the members of the Finance Sub-Coirunittee respectfally request clarification of the following items: I, On Page 3 you indicate in Item 4A, that principal and interest spending will not exceed approximately $I million annually. That estimation is inconsistent with the figures set forth on Page 3 1: Please explain the reason for this large inconsistency and advise which figures are the most accurate for our purposes of evaluating the Capital Improvement Plan. 2. The Capital Improvement Plan calls for a Fire Department vehicle with towing capacity to be used by the Deputy Fire Chief It appears that such a vehicle will be driven home by the Deputy Fire Chief whom does not reside within the To,wri of Agawam,. How is that practical and of what benefit is there to the citizens of Agawam to have this vehicle traveling outside of our town! What is the benefit of having a vehicle with boat, towing capacity if it won't always be onsite for expeditious use? We took forward to your clarification of these matters. Respectfully, The Agawam City Council Finance Sub-Committee members cc: Full Council Town of Agwam Employees Subject to Vehicle Fringe Benefit- Type Loc # toast First 950 7440 421, Blackak Brian , 950 7420 420 Bone steel Steven 950 7250 969 Bosini Richard' 950 7220 24 Brown Gary 950 7420 282 Decker John 950 7450 4191*lnn James 950 7420 526 Golba Christopher 950 7420 359 Myers Ralph 950 7220 1370 Sirois Alan 950 7250 519 Urbinati' Dominic 950 7111 21 Cohen Richard 950 7137 583 Nic ra Chet Town of Agawam Page,I Policy Period: 711111 -711112 2122J12 aga 2011 ATTACHMENT 5A-VEHICLES LIST ALL VEHICLES GARAGED IN A AWAM MASSACHUSETTS nwerage G'ades: 1 = Full coverage - (liability,comprehensive&collision) 2= No collision - (liability,comprehensive) 3= No physical dar"090 - (liability) 4= Physical damage only - (comprehensive,collision) Aga Mass warn amont *=indicates now Cost No, No. Cov. Dept. Description Now Plate No. GVW VI Motorcycles With full coverage Cyl 68 1 15 2006 Marley Davidson 14.961 MM04647 - = 1HD1FMWI06Y678170 y2 fag 1 15 2006 Harley Davidson 14,951 MMC7190 — 1HDlFM�lX6Y677950 Total motorcycles with full coverage 2 Trailers, T-1 70 1' 14 2010 Wanco Radar Board(Speed) Trail 5,000 MP096F 1B9AF511X9P8 5333 T-2 74 1 14 2003 Carmate Emergency Reponse Utili 2.000 M70170 SA3C714D43LOO4039 239 1 14 2010' ATS-5 Utility Trailer 31000 MP896F 1B9AF511X9P82333 240 109 1 8 1971 Mastercratt Boat Trailer 150 FI4773 ---- 18203 385 28 1' 10 1989 Intl Trailer(paint Mach) 2,000 M40127 3,500 1ZFUFOB17KB003488 395 83 t 10 2005 Brim Utility Traiter 4,595 M72929 - 43YO7C20265CO45646 719 27' 1 21 2007 Big Tex Utility TraiW 1,200 M80090 — 16V'LX081072A73025 720 157 1 10 2010 Cross Country Flat Bed Trailer 4,000 M83398 9,996 431FS202OA1000444 Total trailers with full coverage 379 44 2 10 1968 Inlemational Trailer 2,000 M40.131 3,500 1ZFUFl OI05B003140 386 77 2 10 2004 Sig TE Utility Trailer 2,000' M69028 16VAX101442A32109 Total trailers with no collision 2017 21 3 8 1931 Intl Buffalo Water Trailer 2.000 MF910 A42309 291 ill 3 23 2006 CARMATE UTILITY TRAILER 0,500 M74268 - 5AX714DO61-002275 324 46 3 10 1970 General Flatbed Trailer Roller` 2A00 M28-516 3,000 3TL7925 342 108 3 10 1973 Woodchuck Chipper Trailer 10.0100 M74274 0 STWC 3243 384 55 3 10 1999 Custom Flatbed Trailer 3,295 M61553 10,000 58732153XX1004781 409 48 3 4 1985 Superior Ideal Trailer M33-866 2,000 1ZT4ZCB12 4018120 420 138 3 4 2009 Anderson;Utility Trailer 1,795 M77-901 4YNBN18229CO56912 7101 49 3 10 1985 Quality Utility Trailer' 2,000 M33-871 -- 8685 903 52 3 10 1985 Colemore Utility Traii r M40-035 — LCAA830TOFT086874 Total trailers with no physical damage Total Trailers 19 Town of Agawam Page 2 Polley Period! 711114•7/1112 2122112 aga 2011 ATTACHMENT SA-VEHICLES LIST ALL VEHICLES GARAGED IN AGAWAM,MASSACHUSETTS Coverage Codes: 1 t= Full coverage - (liability,comprehensive&collision), 2=I No collision - (liability,comprehensive), 3= No physical damage - (liability) 4=' Physical damage only - (comprehensive,collision) Aga` Mass wam amont "=indicates new Cost No. No. Cov. Dept: Description New Plate No GVW VIN Vehicles with full coverage 101 1 14 2011* Ford Crown Victoria 31,000 MP375F 2FABP7BV5BX106850 102 158 1 14 2011 Ford Crown Victoria Sedan 30.000 MP1870 ---• 2FA8P7BV68X172324' 103 154' 1 14 2011 Ford Crown Victoria 30,000 MP378F -- 2FASP76VSBX168324 104 1 14; 2011 Ford Crown Victoria 30.000' MP241 D 2FA9P76V5BX149228 105 1 14 2011 Ford Crown Victoria 30,000 MP404F 2FABP78V3BX107544` 106 131 1 14` 2011 Ford Crown Vicloria; 30,000 MP1840 2FABP7BV5BX107545 107 10 1 14' 2033 Explorer Sport Utility 35,000 MP9663 1 FMZU72KO3UB06346 108 85 1 14 2006 Ford Taurus Sedan 21,000 44HG70 --- 1FAFP53U96A124052 100 1 14 2009 Dodge Charger 30,000 712FXK 2B3KA43V49H582442 110 78 1 14 1997 Ford Crown Victoria 26,000' 290CWJ 2FALP71W3VX229842 Ill 76 1 14 :2007. Ford Crown Victoria; 25,000 51GR32 -- 2FAFP71WOTX117533 112 76 1 w 14 2004 Ford_Crown Victoria 25,000 - M64619' ---- 2FAFP71 W64X 143324 113 58 1 14 2000 Ford Crown Victoria' 23,035 8900SX - _2FAFP71W7YX2124W 114- 86 1 14 2005 Ford Crown Vic.Sedan 26,807 MP402F -- 2FAFP71W75X176950 115 84 1 14 2006 Ford Grown Victoria Sedan 28,000 M30494 - 2FAFP71W76X108326 116' 4 1 14 2008 Ford Crown Vic DARE 25,730 MP9164 - 2FAFP71V48X112196 117 5 1 14 1997 Ford E350 Van 29,982 MP124A 9.400 1FMEE11LIVH895245 118 146 1 14 1998' Marked Ford Van Prisoner Van 30,000 MP115A 1 FTSS34L6WHA56432 119 1 14 2009 Crown Vic 30,000 MP405F 2FA# P71V99X104444 121 71 1 14 2000` Hyundai 25,000 4461 NY ---- KMHWF35VXYA300550 122 1 14 2005' Ford Taurus 30,000 6442CV 1 FAFP53UO5A159240 124 112 1 14 2003 Ford Crown Vic Unmarked 17,719 8652XB -- 2FAHP71W23X192012 126` 147 1 14' 2001 Audi A6` 32,000 799XBM WAUE064691Ni63367 125' 152 1 14" 2005 Nissan Maxima 16,000 775EA3 iN4SA41EX6C843045 123 156 1 14 2003 Unmarked Lincoln Navigator 25,000 213KH9 5LMFU28R03U32345 128 t 14 2012 Unmarked Ford Escape 363HL9 1FMCU5K36CKB20521 201 8 3 6 2007 Pierce Pumper 400,000 MF4606 -- 4PICCO1777AGO7357 202' 9 3 8. 2007 Pierce Pumper 400,000 MF4656 4P1CCO1T97A007358 203' 6 3 8 1996; Pierce Pumper 390,000 MF7820 -- iPICT02U3TA000486 204 7 3 8 1996 Pierce Pumper390.000 MF6216 -__ 4PtCT02U5TA000490` 210 113 3 8 2002` Pierce Dash Tower Truck; 11100,000 MF7727 4P1CT02S73AO02626 211 8 8 2010 Ford E450 Cutaway Ambulance 163,510 MF9719 1 FDXE4FPBADA06498 212 96 3 8 2006 GMC Cutaway Ambulance 165,000 MF6183 17,500 1 GDE4V1266F400931 213 1 8 2010*' Ford E450 Cutaway Ambulance 165.000 MF9719 --- 1 FDXE4FP8ADA16707 215 114 3 8 1986' GMC Saulsburg<Rescue Vehicle 100.000 MF6283 -- 1GDM7D1 G6GV538811 217 2 8 2003" Ford Expedition 10,800 M83936 1FMPU16L23LA20095 222' 53 1 8 1997" Ford Crown Victoria 20,497 MF6218 ---- 2FALP71W7VX229861 226 102 1 8 2005 Ford Expedition 35.000 MF7816 --- 1 FMPU16555LA34805 228 1 8 1997 Ford F350 Pickup 30.000 MF9731 1FTHF36GOVEC46709 233 1 21 2011 Ford Escape Hybrid 32,000 MF74 1 FMCUSK33BKA75767 345; 1 8 2000 Ford Ranger MF9958 1FTYR1OX8YTA59559 301 101 1 10 2007 F450 FZOOIc Body 35,000 M80099 14,000 1 FDXF47P37EB31229 302 75 1 21 2004 Ford F150 Pickup-4 WO 20,000 M70129 6,250' 2FTRF18W44CA38978 303 13 1 10' 1999 Ford F150 Pickup 22,755 M54230 6,000 2FTRF08W4XCA13223 304 88 1 21` 2006 Init 700ser Henderson Muni 80 123.145 M74264 40,000 1 HTWCAAR16J313570` Town of Agawam Page 3 Polity Period: 711111-711112 2122/12 aga 2011 ATTACHMENT SA-VEHICLES LIST ALL VEHICLE'S GARAGED IN AGAWAM.MASSACHUSETTS Coverage Codes- 1= Fuil Coverage - (liability,comprehensive$collision) 2= No collision - (liability,comprehensive) 3= No physical damage - (liability) 4= Physical damage only - (comprehensive,collision] AgaMass wam among' Indicates new Cost No. No Cov. Dept Description New Plate No. GVW VIN Vehicles with full coverage (continued) 306 15 1 21 1995 Ford LN8000' 67,129- M52.450 35.000 1 FDYR82EXSVA37753 307 16 1 10 1997 Ford LN8000DumplSpreader 72.650 M64-728 35000 1FOYR82E1WA28654 308 56 1 10 2001 Freightliner FL80 Dump/Spreader 86,318 M64-738 40,000 1FV6JLBB51HH13056' 309 144< 1 10' 2009 International 7400 Dump Sander 106,000 M77.263 40,000 1HTWCAAR99JO84284: 310 141 1 10' 2009 International 7400 Dump Sander 109,000 M77-275 40,000 1HTWCAAR09JO84285; 311 95 1 21 2005 Ford Explorer 23.000 M72932 1FMZU72EX5UB83688 312 1 21 2011 ' International 7400 Dump' 146,380 MB2877 40000 1HTWCAAROBJ394314 313 136 1 21 1986 GMC Truck 50,000: M15-429 1GDL6T1G4GV526438 314 89` 1 21 2006 Ford F250 Pick-Up' 32,745` M74253 1FTNF205X6EA65610 315 90 1 21 2006 Ford F350'Utility DRW 32,745r M74254 iFDWW36Y26FA65611 316 80 1 21 2004 Ford Cutvan 30,161 M69599 1FDWE35L74HAO1147 317 91; 1- 21 2005 International 700SER DUMP1Spre: 81.818 M72014 40,000 1HTWCAARX5J167720 320 97' 1 21 2006 Ford F450 Utility 36,545 M74263' 0 1FDXW46Y86EA76977 322 25 1: 10 1995 Ford F460 Dump 31,707 M52442 15,000 1 FOLF47FXSEA28192 325 57 1 10 2001 Freightliner FL80 Ountp Truck 74.891 M64746 40.000 1 FV6JLBB31 HH13055 326 1 21 2011 Ford Escape Hybrid 27,892 M83377 1FMCU4K37BKA75765 328 98 1 10 2005 Ford F250 Pickup 21,928 M69592 IFTNF21575EA456D4 332 54 1 10 1999 Freightliner Medcon FL80 Dump 77,813` M62515 35.000 iFV6JLA13XXHB82267 '333 26` 1' 10; 2005 Intl 700SER Dump 50,200 M69581 IHTWCAAR55JO14677 334 103 1 10 2003 International 7400 Dump/Spread 91.611 M62295 40,OW 1HTWCAAR63JO51735 337 62 1 10 2002 Freightliner Dump Truck 74.910 M67275 1FVABXBS22KJ73761 338 107 1 10 2007 Ford F150Pickup 20,000 M74891 1FTRF14W27NA59025` 339 151 1 10 2009' Kard F15OPickup' 26.000 M81516 1FTRF14W49KC60011' 340 64 1 21 2001 International Sewer Cleaner Truck 194,427 M40046 1HTGSADR61H343554 343 12 1 10` 2007 Trierrrerex TV900-1 27,000` M73845 43YDC16167CO57072 345 19 1 21 1999 Ford Ranger 1%200 M54033 1FTYR10V9XTA17799 357 22 1' 7 1996 Ford Econoline Club Wagon 17,448; M64-587 1FMEE11 YGTHA40828 358 35 1 16 2002 Ford Focus 4 door Sedan 14,540 M66037 1 FAFP343X2W267924' 359 23 1' 7 1997 Ford Escort Wagon 13.150 M54672 3FALP15P6VR116322 360 142 1° 21 2008 Ford Escape hybrid 23.000 M76570 1 FMCU59HSBKE09145 361 115 1' 21 1999 Ford Ranger Pickup 14,800 M54231 4,000 1FTYR1OV2XPA27325 362 61 1 10 2001 Ford Super Duty Crew Cab Dump 50.999 M64620 10,000 1 FDXW47F51EA94343 363 139 1 10 2008 Ford F450 Crew Cab Dump 31,880; M77267 16,000 1 FDXW47R58EE39519 364 140 1 10 2008 Ford F450 Dump 31.880 M77266 16.000 1FDXF46Y28EE39518 371 24 1 21 1999 Ford F450'Super Duty Dump 44.490' M61503 15,000 1 FDXF47F2XEC28816- 373 72 1 21 2003 Ford F250 Pickup 16,971 M70152 8,800 1 FTNF20183ED58190 375 92' 1 10 2006 Ford F450 DRW Cab Rack Body 281,480 M74273 15000 1FDXF46Y36EC65729 383 63' 1 10; 2001 Ford Pickup 18,436 M66950 6,600 1FTRF17W91NB70738 368 29 1 20' 1997 international Model 4700< 78,000 M47449 35.000 1HTSCAAR2VH414380' Town of Agawam Page 4 Policy Period: 711111-711112 2122)12 ago 2011- ATTACHMENT$A-VEHICLES LIST ALL VEHICLES GARAGED IN A AWAM MASBACHLISETTB Cov rar Codes; 1= Full coverage lilability,cornprehensive&collision) 2= No collision - (liability,comprehensive) = No physical damage _ [liability) 4= Physical damage only - tco preha nsive,collision) Aga Mass were amont =indicates now Cost No, No; col. Dept, Description Now Plate No. + Vw VIM Vehicles with full coverage (continued) 344 36 1 3 1996 Ford Escort Sedan 12.293 M47-435 3FASP13J2TR1O4014 390 1 4 2012 Ford DRW UP M88638 0 1FDUF4HY7CEB23718 391 93 1 1: 2005 Ford Explorer U72B 04 23,000 M72933 5,964 1 FM2U72E85UB83687 392 66 1( 10 2002 Ford Ranger Extended Cab 4WD 20.000 M66946 4,940 1 FTYR45E62TA15866 402 32 1 4, 1989 Ford F250 Pickup 12JO0 M40-148 2FTHF25H6KCA47847' 406 73 1 4 1998 International 400SER Box Truck 15,200 M44.687 25,500 1HTS A MBWH547182 07 110 1 4 1999 Ford E250 Van' 10,000 M40911 1FTNE24L2XH807375 411 33 1 4 1995 Ford E150 Econot rte Van 15,594 M52403 fi 700 1FTEE14YISH869459 413 94 1 d 2006 Ford E-350 Van 32,000 M74262 9;400 1FOWE35L26HA73392 414 153 1 4 2005 Foal Econovan' 27,355 M78M 1FTSE34L45HB27729 565 31 1 9 1998 Ford Contour 16,197 M54294 0 IFAFP66L6WK274395 608 17 1 7 1998 Ford Contour 19,197 M54293 0 1 FAFP66LBWK274396 609 1 14 2012 Ford Escape M81814 0 1FMCV K36CKS20525 730 67 1 6 2002 Chevrolet Silvaderado 4WD Pickul 17,222 M67265 6,400 10CEK14V42E153207 801 104 1 19 2DOO +Ford Cut Away Van 30.000 M64624 1 FDWE3557YH831541 802 116 1 19 2006 Ford Ecovan 15.886 M74272 1FTNE24LOBOA10634 803 1 19 2010 Fond Transit SOB 23.215 M83387 NMOKS9BN8A7033809 807 9 2011 international 700S RDUMP M82877 1HTWCAAROBJ394314 902 38 1 22 1999 Ford Ranger 14,640 M60183 1FTYRiOVi)TA17800 905 135 1 18 2007 Ford EcoVan 15,000' M79-433 1 FT"NE24L6708 806 954 41 1 16- 1997 Ford Escort Sedan 12,340 M41-717 1FALP13P6VW192316 "dotal vehicles with full coverage 102 Vehicles with no collision 206 42 2 8 1993 Ford F250 12.ti00 M54233 8,000 1 FTHF26H6PL826642 208 43 2 8 1986 Chevy 4 WD Pickup 10,000 MF8383 — IGCHD3458GF446920 2190 1t7 2 23 1994 Ford Bronco 20,000 MF 06 IFMEU15HORLS43518 327 18 2 21 1997 Ford Lt9con Craw Cab Util Body 38,212 M56288 10.000 1FTJW35H4VED08639 341 99 2 12 1995 Ford F150 Pickup' 14,800 M69595 6,250 1FTEFISY9 L692349` 404 106 2 4 1983 Ford E150 Van 7,999 M16596 1FDKE04Y1DHA42841 405 159 2 4 2000 Ford E250 Van 10,000 M79434 1FTNE2424YH891174 Total vehicles with no collision 7 Vehicles with no physical +damac 100 45 3 14 1968 VW Sedan(Safety Bug) 2,000 MPKK 18818453 121 79 3 14 2000 Hyandai Sonata Sedan 11,000 4461NY" KMHWF35VXYA300550 906 149 3 8 1997 Rogue 8oat/Trakler MF6282' 18Y1LAX27U1011373 Total vehicles with no physical damage Total of all vehicles 133 T -2012-23 A RESOLUTION ADOPTING THE FISCAL YEAR 2013.-2017 CAPITAL IMPROVEMENT PROGRAM WHEREAS,The Capital Improvement Program for Fiscal Year 2013.2017 was submitted to the City Council on April 5,201 In accordance with Article 5,Section 5-3(a)of the Charters and WHEREAS,The Capital Improvement Program contains a prioritized plan of proposed capital improvements over the next five fiscal years in accordance with Article 5,Section 5-3 (b)of the Charter; and a WHEREAS,The Capital Improvement Program is designed to utilize funds for capital Improvements on the basis of community priorities in condition with the availability of grants and/or other state,federal or private reimbursement; and WHEREAS,In development the Capital Improvement Program each year,the planning process includes consideration of growth of the town, the improvement of efficient service delivery reducing the need for staff increases,maintenance of new and existing facilities,and consideration of existing commitments, and WHEREAS,Each year the Capital Improvement Program is revised and updated in light of changing needs, requirements,and funding availability;and WHEREAS, In accordance with Article 5, Section 5- (c) and d), the Council shall conduct a public hearing and on or before the twentieth day of the last month of the current fiscal year,shall by resolution adopt the Capital Improvement Program. NOW THEREFORE,THE AGAWAM CITY COUNCIL hereby resolves to adopt the Fiscal Year 2013.2017 Capital Improvement Program as submitted by the Mayor on April 9,2012 DATED THIS DRAY OF 2012. CD �a PER ORDER OF THE AGAWAM TOWN COUNCIL v x A� Christopher Johnson, President,Agawam Town Council '-0 Alt-PPIR WED AATO,FORM AND LEGALITY Vincenf Gi4tifi, Solicitor i Y pf 1 � a1�{s r 'sy .ice, s a t, 4 3 l t ..., � t .,.t" ;'��:. us>t.c•., ,.ti„„w�, ,'jr„r, ti.a. ,..'ta, ,� ,e,. :;�.. .. 1?. 1 1 , z.. vs k �r d F £ Yi fi s, T fi l Town o Agawam Carnal Improvement Program Fiscal' Year 2013 - Fiscal Year 2017 )[ABLE OF CQNTENTS ITEM PAGE NUMBER (1) Cover Memorandum to City Council 1 (2) Introduction 2 (3) List of Projects (Bonding& Appropriation Schedules)(F' 2t113 - F 2017) 5 (4) Project Descriptions 20 (5)' Bond Payment Spreadsheet 2 ( ) Chart- Budget Appropriations 27 (7)" Chart- Existing Bond Costs 28 (8) Chart Projected New Bond Costs 2 ' (9) Chart - Projected Total Bond Casts(before grants and reimbursements) 3 (1 )' Chart -Projected Total Bond Costs (after grants and reimbursements) 31 (11) Chart- Self Sustaining Funds- Existing Bond Costs 32 (1 ) Chart -Self Sustaining Funds - Projected New Bond Costs 33 (13) Chart - Self Sustaining Funds- Projected Total Band Costs(before grants and reimbursements) 34 (14) Chart -'Self Sustaining Funds - Projected Total Bond Costs (after grants and reimbursements)- 35` Town of Agawam 36 Malty Street, Agawam, Massachusetts wool, Telephone (413) 786-4520 1 FAX (413) 786- 927 Richard A. Cohen, Mayor To Agawam City Council From; Mayor Richard A.Cohen Rye: Capita Improvement Pro (Fiscal Year 2013 ' Fiscal Year 2017) Date: April 9, 2012 Pursuant to Section 5-3 of the Agawam Home Mule Charter, I hereby submit the Capital Improvement Program for Fiscal Year 2013 to Fiscal year 2017 to the Agawam City Council. The Capital Improvement Program is a prioritized plan of proposed capital improvements over the net five fiscal years. The major purposes of the Capital Improvement Program are as follows:' (a) to develop and prioritize needed proposed capital improvement projects, (b) to research and estimate the revenue necessary to fund proposed capital improvement projects; (c) to set parameters on the revenue dedicated to fund proposed capital'improvement projects; d (d) to forecast future principal and interest expenditures. The program presented represents a realistic financially feasible long term program.As revenue estimates become available, revisions shall be made and incorporated in the capital budget portion of the annual budget. Please call with any questions. Respectfully submitted, Mayor Richard A. Cohen l l O-,,*tA1 Improvement Program 7 z k.941 Yee ' 20'13 - Fiacal Year 2017 INIRODUCTION For the purposes of this Capital Improvement Program, a capital improvement is a project or undertaking which provides for (i) the planning, design, construction, reconstruction, renovation or replacement of a public building or facility; (ii) an addition to a public building or facility, iii) the purchase of land, buildings or facilities for a public purpose; or (iv) a long range development study. "le the type of improvement is the basic criteria, a project costing at least $20,000 that has a life expectancy of ten (10) years or more is generally considered to be a capital improvement. The Capital Improvement Program is designed to accomplish the following purposes. I. To utilize town funds for capital improvements which are compatible with the town's mission of effective and efficient provision of quality services to the citizens and businesses of Agawam which in turn enhance the:quality of life in our community; 2. To undertake Capital Improvement Projects on a coordinated basis; 3. To inform the community when needed and planned Capital Improvement Projects and corresponding expenditures are to be expected and initiated in the future; 4. To utilize town funds on the basis of community priorities in coordination with the availability of grantsand/or other state, federal or private reimbursements; and S. To undertake Capital Improvement after careful planning and financial analysis to avoid_ 2 an undue burden on the to 's fiscal capacity now and in the future. After many years of limited capital investment, the town was faced with many desperately needed projects which had to be undertaken in spite of projected limited revenue growth. Fiscal restraint and careful planning are required to ,assure long term stability, and care must be taken in project development and implementation in order that bond sales are timed so that principal and interest costs occur in the year scheduled. In addition, the funding requirements of the Education Reform Bill have placed severe limits on the To 's ability to undertake needed capital improvements. In developing this Capital Improvement Program the following general assumptions on fiscal capacity,were assured and applied: 1.. Growth in total property tax revenues will continue to be limited by the restraints of Proposition 2 1/2 and no debt exclusion overrides are contemplated in this plan; . The town will pursue the maximum property tax revenue allowed b Proposition 2 1. 3. For the upcoming fiscal year and future years, the Administration is continuing to recommend a ,greater emphasis be planed on capital improvements; and . During the next five years, the town should; a. Limit General Fund;principal and interest payments to approximately 1 million dollars per year, b Appropriate as much funding as possible annually from the general fund for capital improvements on a pay as you go basis while; maintaining existing service levels; and 3 C. Utilize the Stabilization Fund to assist in meeting the above referenced goal for level principal and interest payments. The process of capital planning involves setting priorities within the fiscal capability of the town. Each year the entire plan is reviewed in light of changing needs and requirements. There are more needs for improvements by town departments that can be included in a five year time period, and. certainly the net school spending requirements of the Education Reform Bill may cause further delays in making capital improvements. In developing the recommended Capital Imptovement Program, the following priorities were addressed: . growth - The town must meet the needs of a growing population and at the same time direct and manage growth through the timing of public utility expansion; 2. improve or assist Service Delivery - Projects that will reduce the need for staff increases or make staff operations more efficient have been given priority; _. Facilities - New and Maintenance of Existing Facilities - When Proposition 2 1 was implemented communities were forced to delay constructing new facilities and defer maintenance on existing facilities which has led to the current backlog of need for new facilities and the provision of maintenance to existing facilities, and 4. Prior commitments The Town is bound by commitments made in prior years. The commitments were considered in the proposed budget and program. The attached Capital Improvement Program was developed around the previously cited constraints and program objectives. It includes a bonding and appropriation plan for each of the five program years, a brief description of each project item, spread sheets and charts showing:existing and proposed bond payments and ,graphical representations of these payments. 4 Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017 Fiscal ear-2013 ppro rza an +che—d-j& General Fund ApVLQdations Projected Project Descri tion rnoim Hampden County Land Acquisition S%500®0€1 Department of Public Works Equipment S200,000#00 Street Improvement Program $150,000.00 Sidewalk Rehabilitation and Extension $5,000.00 Permit Tracking Software $61,7 0.00 Fire Department Motor Vehicle $34,800.00 Fire Department Protective Gear $40,000.00 Town lull Emergency Generator $25,000.00 Police Department HVAC System $75,000.00 TOTAL 5 Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017 Eiscal Ycar 2013 Appropriation Schedulgcent a Wastewater Fund ;ppLo-j atio Projected Project Desc i %ion "Wastewater Equipment replacement $20,000,00 Wastewater Motor Vehicle $47,174.00 TOTAL .a W�tcr Fund Aatar `atians Projected Project Dc tionAM Water Department Equipment Replacement $4 ,174.00 TOTAL AZAAam Municipal+ olfo sc Appr nations Projected Project Mscr" tion AmQJW Municipal GolfCourse Equipment Replacement $60, 00. 0 TOTAL 6 Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017 Eiscal Ycar Z013in e General Fund Projects Projected I'Year Proiect Des r ttion Amo-un Det Sepdce Junior High School Roof,Windows and HVAC $1,250,000.00 $11 ,500.00 High School Bathroom and Locker Room Renovation $1,750,000.00 $157,500.00- Fine Street Road Improvements $54,000.00 $55,960.00 Suffield Street Drainage Improvements $300 000,00 $32,000.00 Wastewater F nd Projecta Projected V Year Project Desgrip-liQn un Debt Set-vice Feeding Hills Southwest Sewer Extension Phase 11 $10 700 000.00 $963,000.00 Water Fund Protects Projected 1"Year ft.ject Descdl2tion no t Debt Sgryice Water Main Design - Main & Suffield Streets $350,000.00 $34,000.00 7 T own of Agawa m Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017 FiscaUg—ar-2-014Al2i2rQpriatioll Scbedulk General Fund Aagruriationk Projected Projoc ,. tioza Hampden County Land Acquisition $9,500.00 Department of Public Works Equipment S150,000.00 Street Improvement Program $160,000.00 Sidewalk Rehabilitation and Extension $30,000.00 Traffic Light Improvements $30,000.00 Pool Filtration System -Junior High School $150,000.00 TOTAL 5 ,500— 00 Waste ter Fund ro riati ns Projected Project Description AmQ=1 Wastewater Equipment Replacement $47,174.00 TOTAL Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017 Fiscal Ykar 201 a Water Fund Appropriations . Pr roiect I7escri tin c u Water Equipment Replacement $47,100.00 TOTAL 4 Agaw—am Mmidpal 1 e A21=2dations Ewjectc °ec� t Desg6ption unt Municipal olf Course Equipment Replacement $31,100.00 TOTAL ° Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017 Year 201 Bonding lichgdUl WagLw- t r E d2mjects Er.9jected. 1 tiggt , ;nation Amomt D&I s ice Westfield River Backup Force Main Design $ 00,000.00 $ 0,000.00 }yater Proie�ts ed "ye Pro'erg Dcagliption. unt Debt Service Water Main Construction,- Main &. Suffield'ield Streets 2,000,000.00 $200,000.00 Water Main Construction forth Westfield Street $3,300,000.00 $330,000,00 Water Main Construction - Reed Street $600,000.00 $60,000.00 10 Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 201" Fiscal l ar 2015 Approndalignh le General liund A=r-QiLna1im5. E, `ect , Project Deseri Lion urn Hampden County Land Acquisition $q,500v00 Department of Public Works Equipment $150,000.00 Street Improvement Pro $400,000.00 Sidewalk Rehabilitation and Extension $40,000.00 Traffic Light Improvements $30,000,00 Police Station Renovation -Feasibility Stud} & Preliminary Design $25,000.00 Robinson Park School Energy Management System $128,000.00 TOTAL 2 5 0 0 Wastmaer Fund Aampiiatimns cted Rmiegt Dese ' tiQn AMQ= Wastewater Equipment Replacement $47,174.00 TOTAL L41ABA. 11 Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017` Fiscal Yea 2015 A pproopriation Schedule (Contined Water Fund Appropriations Pj:vjected Project Description Amount Water Equipment Replacement $47,100.00 TOTAL iiLLOUWO Agawam_Municipal Golf Course Appropriations Projected Project Description Amount Municipal Golf Course Equipment Replacement $31,100.00 TOTAL ; 1100 12 Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017 `scal Yor 2Q 5 ending Schedule Wastewater Fund Projects PrQjected Elm m Eroigct Description Am Debt Se ice Westfield River Backup Force Main Construction $2,000,000.00 $230 000.00 Feeding Hills Southwest Sewer Extension Phase 11 $393,000.00 $45,545.00 Design VA TOR.Truck $400,000.00 106 000.00 Water Fund Prq.jects Effect Desc;dX on ou-n Debt Service Water Main replacement- Silver Street to Elm Street 1,l00,000.00 12�, 00.00' 13 Town of Agawam Capital Improvement ent Program P F Fiscal Year 2013 - Fiscal Year 2017 Flual 6 Appr9priation Schedule General Fund Awrar� `ate a' ggigd RMiget De EWliun Amount Hampden County Land Acquisition $9, 00,00 Department oPublic Works Equipment $1 0,000.00 Street-Improvement Pro $ 00,000. 0 Sidewalk Rehabilitation and Extension $50,000.00 T T asstewater Fund AppnWhations Pr- y, +pie t�T]eseri t ;:, 1 Wastewater:Equipment Replacement $4 ,1" 4M TOTAL L L L 4. 14 Town of Agawam Capital Improvement Program Fiscal Year 2013 ¢ Fiscal Year 2017 Fiscal ar 20 riati n Schgdmig (CQntinue Water Elrod ARprgpriat ons PjQjec PW.jggt Deseriplion Amount Water Equipment Replacement $47,100.00 TOTAL ". o m Agawam Munici al olf Course-A=Qlaiation ro`e Fraigr-t Dese ` tionAmunt Municipal Golf Course Equipment Replacement $31,100.00 TOTAL SuaMLO Town of Agawam Capital Improvement Program Fiscal Year 201 - Fiscal Year 2017 r 20 in h l Wastewater Fund Pro-jects eeted LYear Pr+-eet Qg5cription t' Debt Smice Feeding Hills Southwest'Sewer Extension Phase III Construction , 0 q 0,0 468,t1 .00 Water Find r jects R ' e ed 15` Project Des ri Lion ArnQjmt Qebt Service Water Main Design-South Street $ 00,000.00 $24,000.00 Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017 FisdaLY—e—ax-207 ApprQpriglionclul General Fund Ap rapriatigns Projecifd project j2r.5 tiunAm Hampden (county Land Acquisition $9,500.00 Department of Public 'Works Equipment S160,000.00' Street Improvement Program $500,O00.00 Sidewalk Rehabilitation and Extension $50, 00.00 Traffic Light Improvements $30,O000.00 TOTAL "Wastewater Fund A ro riatio p—p !1: a ' d P�'o` l.�eset intion Wastewater Equipment Replacement S47,174.00 TOTAL; 4 17 Town of Agawam Capital Improvement Program Fiscal Year 2013 - Fiscal Year 2017` Eiscal Yor 2017ria i hed Con W tgr Fund.A prgpdations sect; "cptiur� Am Water Equipment Replacement $47,100.00 TOTAL Agawam Municipal Golf Cgurae Appropriations Project Desc ipt Municipal Golf Course Equipment replacement $ 1,100.00 TOTAL 18 Town of Agawam Capital Improvement Program Fiscal Year 2013 _ Fiscal Year 2017" Fiscal Year 2017 Bonding Sch dule Wastewater Fund RrQ.jects Erg.jecte lt C Project 12gigiphon Amo Debt gryic?, Feeding Hills Southwest Sewer Extension Phase 1V Design $388,000.00 $49,100.00 ` Water Fund ELoject ftWerto 1 ' jgct DrsaipkPn Am—canj Debt Sgryice Water Main Construction- South Street _ $1,500,000.00 $187,500.00 1: °I'own of Agawam wa Capital Improvement Program Fiscal Year 20I3 — Fiscal Year 2017 PROJECT DESCRIPTION Iw MUNICIPAL BUILDINGS TOWN MALL EMERGENCY GENERATOR The Town has applied for FEMA rani to purchase an emergency generator that will provide Pp P y emergency power to the Town Hall in the event of an extended power outage. The estimated cost of the generator;is $100,000. The FEMA grant will provide for seventy-five per cent of the cast,the To ''s share would be$2 , 00. POLICE DEPARTMENT HVAC SYSTEM Funds are requested to replace the heating and air conditioning system at the police station. The present system is over twenty years old and is required to operate twenty-four hours;per day, seven days per weep. Due to the age of the system, it does not operate efficiently. A new system should last between Fifteen and twenty years and provide energy efficiency which will reduce operating costs. POLICE STATION RENOVATION Funds have been set aside to provide for a use and feasibility study for repairs and improvements to the Police Stations II. PUBLIC WORKS HIGHWAY DEPARTMENT EQUIPMENT An annual capital appropriation is included to provide for the ongoing replacement of equipment ment q on a scheduled maintenance program. Funds may be carried from one fiscal year to the next in order to provide funding for high value, large Department of Public Works trucks and other capital equipment. Two large dump trucks have been replaced and financed with a capital lease, $100.000 has been set aside for lease payments. As part of a scheduled replacement program, ,$ 0,000 has been included to provide one-third of the cost for the replacement of a CAT 199 IT 28G Loader with 8,595 operating hours or converted to 257,850 miles); In addition$50,000 has - 20 Town of Agawam Capital Improvement Program P p Fiscal Year 201 -a Fiscal Year 2017 been included to provide foT one=half of a two year lease for a 1999 Jacobson HR901 fi, a 16 foot winged rotary mower with 166,320 operating hours or converted to 166,320 miles): STREET IMPROVEMENT PROGRAM Funding is required for the improvement and maintenance of local roadways. Improvements include the construction, reconstruction, widening and resurfacing of roads and the installation and repair of drainage structures and systems. Funds will be utilized in combination with state Chapter 90 funding to meet routine maintenance,preventative maintenance and improvement requirements. Annual increases in this account are recommended based upon the Pioneer Valley Planning Commission Pavement Management Study performed in 2010 SIDEWALK REHABILITATION AND EXTENSION The Department of Public Works Highway Divisions' sidewalk construction and repair teach. will P g y p continue rehabilitation work on sidewalks throughout the community. Funds will be used to extend walks to provide connections to schools and recreation facilities. Future increases in this account are recommended in order to implement a Sidewalk Master Plan currently under development. TRAFFIC LIGHT IMPROVEMENTS Funds are included to provide for upgrades of equipment and software for existing,traffic lights. PINE STREET ROAD IMPRO EMENTS In conjunction with Phase 11 of the Feeding:Hills Southwest Sewer Extension Pine Street will .l g , have to be rehabilitated, graded and resurfaced. SUFFIELD STREET DRAINAGE IMPROVEMENTS M S The culverts on Suffield Street are inadequate to provide drainage during storms. .Funds are included to enlarge the existing culverts to correct this problem. It is anticipated that partial funding will be provided from the Massachusetts Emergency Management Agency to reduce the casts to the Town for this project. - 1 Town of Agawam Capital Improvement Program Fiscal Year 2013 Fiscal Year 2017 III. PUBLIC WORKS -WASTEWATER WASTEWATER EQUIPMENT An annual capital appropriation is included to provide for the ongoing replacement of equipment; on a scheduled maintenance program. Funds may be carried from one fiscal year to the next in order to provide funding for large, high value, wastewater capital equipment. FEEDING HILLS- SOUTHWEST AREA SANITARY SEWER EXTENSION This project involves extension of the sewer service to the Southwest portion of Town. The first phase of this program is complete. Funds are included for construction for recently combined Phases II and III, followed by additional construction in the second subsequent year. The enormity of this project requires that it be completed and funded in phases. It is anticipated that it will be completed in several pluses over a period of approximately nine years at a;total cost of over$30,000,000. E TFIELD RIVER BACKUP FORCE MAIN Failure of the newer force main during fiscal year 2008 required emergency repairs during'which the 10 inch backup force main was used to continue flows to Bondi's Island. This backup farce main should be completed to be ready to be put in service should any of the existing four river crossings fail in the future. Assistance will be sought from local communities that share the use of the force main. IV. PUBLIC WIIKS`-WATER WATER DEPARTMENT EQUIPMENT An annual capital appropriation is included to provide for the ongoing replacement of equipment` on a scheduled maintenance program. Funds may be carried from one fiscal year to the next in order to provide funding for high value,large water capital equipment... a - - Town of Agawam m Capital Improvement Program .P P Fiscal Year 2013—Fiscal Year 2017 MAIN STREET- SUFFIELD STREET WATER MAIM IMPROVEMENT The Springfield Winter and Sewer Commission is planning maintenance work on their transmission mains from which we receive our water. A portion of the mains will be taken out of ,service for the work. Hydraulic modeling of our system indicated that we do not have sufficient capacity in our distribution system to insure adequate pressure for our residents if we lose service from more than one connection. We need to build flow capacity in an east-west direction. NORTH WESTFIELD STREET`WATER.MAIN IMPROVEMENT V'EMENT This project will provide a link from our only connection to the Springfield northerly transmission main to the ;rest of our system, which only has connections to the southerly transmission line. This; will allow the Town to maintain- service should the southerly transmission line go out of service. Seventy-five per cent of design costs will he submitted to the Massachusetts Department of Transportation with the Route 187 road improvement plans in Fiscal Year 2014. REED STREET WATER MAIN CONSTRUCTION Funds are requested to construct a twelve inch water main to replace 650 feet of six inch asbestos cement pipe and 1,050 feet of four inch cast iron pipe. This will also improve the east — west flaw capabilities as well as fire flows. SILVER STREET—ELM`STREET WATER MAIN REPLACEMENT Funds are requested to replace the existing six inch main running between Main Street and Suffield Street with a twelve inch main to improve the east — west flaw capabilities as well as fire flows. SOUTH STREET WATER MAIN REPLACEMENT Funds are requested to replace the existing six inch main with 5,420 feet of eight inch ductile iron water main. -2 - Town of Agawam Capital ital Improvement Program Fiscal Year 2013 — Fiscal ear*201 V. MISCELLANEOUS PLACE PERMIT TRACKING_ SOFTWARE Presently, the software services only the Inspection Services Department. In addition, the current application runs too slowly. Funds are requested to replace the current software with a Permit Tracking Software that will service the Inspection Services, Planning and Engineering departments and provide a speedier, accurate flow of information between departments, FIRE DEPARTMENT M TQR:VEHICLE Funding is included to replace the Fire Department 1997 Ford Crown Victoria that is currently utilized by the Deputy Fire Chief The replacement vehicle will also serge as a secondary means of towing the Agawam Fire Department rescue boat when it is stared at Station 1; FIRE DEPARTMENT PROTECTIVE GEAR Funds are requested o replace twenty sets of firefighting personal protective:equipment (turnout gear) that will ensure the safety ofpers+onnel in fire suppression and rescue operations, GOLF''COURSE EQUIPMENT An annual capital appropriation, is included to provide for the ongoing replacement of equipment on a scheduled maintenance program. In fiscal year 2013, funds are required to replace golf carts, Funds may be carried from one fiscal year to the next in order to provide funding for high value, large Municipal Golf Course capital equipment. HAMPDEN COUNTY LAND ACQUISITION Agawam acquired most of the holdings of the Hampden County government that were within the To 's boundaries when the county was dissolved. The Town is required to reimburse the other county communities for their share of these assets: t 24 Town of Agawam Capital Improvement Program Fiscal Year 2013 — Fiscal Year 2017 VL SCHOOL DEPARTMENT LI&IOR HIGH SCHOOL ROOF WINDOWS AND HVAG The roof at the Junior High School is being replaced,along with the windows and HV'AC system as part of a Massachusetts School Building Authority Green Repair Project. The Town is required to fund 42.26 per cent of this project. SCHOOL REPAIRS These projects will continue to be funded through.annual appropriation. They include,a new folding gym door at the Juniof High School, a new energy management system at Robinson Park School, and a new pool filtration system at the Junior High School. HIGH SCHOOL LG R ROOM D BATHROOM RENOVATIONS Pursuant to the NEASC report, funds are included to provide for locker room and bathroom refurbishment at the'High School, 2 gg as a as $8 8 8 8'8 B B 8.8 B«BB B B a: a a8a8, R«88 2 - a6884888a a 8a 8W88 — Rf '8a Ba88 8.8a �$ — g.8 gig 8889 a R 8a 84188 R as 8a m88.88 a 8 8 a 8,818;88888 Ya ^ stag 8� 88 ag'a8 _8. a.S4 88 a8g`8 8088 S 8� 8818898189 8 g g C : I I:f d ��, �.� Asa s :, 8 gig g s gaga � �« — 8;; 88 8MIR a's8 a a gig 8888a8 8 Ki9 s,tt 3i se If1� stelaIPi' aBS 3 3 aa$8 as x _e gg'gsaas88 a Ni ults. , v.v. s•a s g a,s' als-, s s,84 a - -- a � a��aa"a a�8 � a a,s.assaaa s` F ,3 Aj 3 H 1 s,_ sus 3 A,9'3;@ 3 ti 8= $+sag 1 a�aaR 8's.ga gm� a 88 888.8 a'sa 4 ' —e s3ssaasa « 1� »,� "�Is•s..�� �.� : ss«�;� - per � �"s: n� �s�m ,. a � a ��"� Rn � as $AlB,$18as ail. : s188+P' aaaa saR a 8a84s. as aas8 8i$ a 5 Ta— 88J8888a8_ a tl •I��3' �"�I�3'I�!���as= �a�:� «g`��� ' ' � ; . �s3��' �� 3�� ���'� � 3 @i�.l���'��s � 'u+ I��,��� :;{: •�g ��+s a sa's� -Y r � x.x s a .,� li�3 s � s � x e els�.al�"x;' 8 8, i8 8 8fa,s�a p.81 818 a 8 �8 8 8;a Tot g a 8 8 8 8 '8 8 8 8 8's a`s a s -• a 8ig,a 8 s+a's a' B �91�" '�3-X�lljl'3. 1�--3. .19i#a + ' + "�1 3 3.9 aa_ n E ,1,1'�+g��� 3�. �. 3 � 11111 oil s s R � •a � a a ';•� a «a •a,$ ��"a a� � s 8 s"�a s $a g 8 Q a s"a$s a c' � a s gg•a s s.g a s. AAI kciI°� TR� r.as a.11a0 111s 1,el 3 Isla so U I f 11 a3' r5 8 = r BagB9a Ill 1 3 . s a �la s4' s � arTM . ss 'r sx a s.g s_ aa'8g A;8"Ves!VaIR�Sa a88'a 8•888 S 'r:88 aaas a 88 8,8$88s ta8 »« a �8�ssaa:ssa a sass; a, a s" sus Zit s ast aa1818 8$^8j888181A,8aill via 9S 8•g'aa B x 8 "-;988r8P 88 sagas $ :: 8 a 88888 s a 1 . s, ��� $$; 8888!88as 18R gr a,8,88 88=118: x 9189,888 $8 g'8 8 8 KR a 8 .8.88aa, aW8 go go I f '8 aaa,a Big aias8a28as 18a0 8 Big a 88�.'Ra• t SiBa"B . . 88 'a 8 0 9 ti g 8 8 8 : a8glc¢8sa"g8218899.818 7 M aa'sa 81818 aa's«8q # 4°g8a8ew as :a �g I C�& t"; 1XI 3's '2'4 S s u m 3 s's s 3 s 'asa1SRICIR$ $88:8„8m8R8 a,a R g 8$6 R 8aa88t9 88 ga8 —a a f!'! o per - --------- 000 olso $Mof #01 of 1 0#1 General Fund Pry Iected New Bond Costs n2013 - FY2017) FY2013 FY2014 FY2015 FY2016 FY2017 I Building Maintenance Building Extension $ 16,884 16,444 $ 16,055 15,667 $ 15,278 Town Wide Telephone System $ 45,500 $ 44,450 $ 43,400 $ 42,350 $ 41,300 Junior High School Roof and HVAC System $ - $ 112,500 $ 110,000 $ 207,500 $ 105,000 Pine Street PAnd Dnprovements $ - $ 55,960 $ 54,560 $ 53,160 $ 51.760 Sufflelid Street Drainage Improvements $ - $ 32,000 $ 32,200 $ 30,400 $ 29,600 High School Locker Room & Bathrocto $ - $ 157.5W $ 154,000 $ 150.sw $ 147,000 ITOTS 62,384 $ 418,854 $ 409,215 $ 399,577 $ 389,938 "ected New Bond Costs TY2013- FY2017) $5W,OOO $400,000 $300,000 $2w,000 $100,000 FY2013 FY2014 FY2015 FY2016 FY2017 -29- General Fund Pro'+ td�d Total Bond Costs 201 - FY2017 (before grants and reimbursements) FY2013 FY2014 FY201 _ FY2016 FY2017 Existing Bond Costs $2,868,488 $2,772,184 $2,535,732 $2, 45,138 $2,240,739 Projected New Somd Costs $62,364 $418,854 $409,Z15 $399,577 $389,938 TOTAL B©M COSTS 2:M,872 $3,191,0 8 $2,90,947 $2,70,715 $2,630,677 Total Projected Bond Costs (FY2013 -FY2017) (before grants wW reimbursements) $3,500,000 $3 $2, , $?-,WO,OW $1,5W.cm $1. $5Ws FY2013 FY2014 FY2015 FY2016 FY2017 -30- ,; �9 y� � B ..:� • '.. � xis �. ! • !'. ! •. it i..,' ! ,. ® ... � _ r � -x� M�� r r� __,___. •k� ei4 �� it.. e� err ��� •�♦ # �♦ ®�+� • #' ! * • if-in :-:T=MMqm7lt 1 114-7 owl Self Sus ainin Fund Prgjected New Bond Cost 1 - 2 1 Z FY2013 FY2 14 FY2015 F 2016 FY2017 Feeding Hills Southwest Sewer Phase II $ $ - 963,000 ;;1,600 920,200 Westfield River Backup Fords Main Usign $ - $ .- $ $ 30, $ 29,250 Westf ield River Backup Force Main Construction $ - $ $; $ - $, 230,000 Feeding Hills Southwest Sewer Design Phase III $ $ $ - $ $ 45,545 VAC"TOR 'Truck $ - $' - $ $ 101,000 $ 96,800 Feeding Hills Southwest Sewer Construction Phase II] $ $ $ $ - $ _ Feeding Hills Southwest Sewer Design Phase IV $ _ $ $ $ _ $ Water Main besign _ Main &Suffield Streets $ - $ - $ $4,000 $ 33,200 $ 32,400 Water Main Coratruction , M41n A Suffield Streets $ _ $ $ - $ 200, $; 195,000 Water Main Construction Westfield Street $- $, $ $ 330, $; 321,750 Water Main Construction - Reed Street - $ $ $ 60,000 $ 58.500 Water MainConstruction - Silver d Elm Streets $ $' - $ $ 112, $ 117, Wstiter in Design - S - $ $ $ Water Main CAnstruction - South Street $ $ $ - $ _ `t"CJTAL $ $ - $ 997,000 $ 1,808, $ 2,047,145 Projected New Bond Cash (FY201 - FY 017) $2 P $2, Y $1i501C),000 $1,000,000 $ t : $- FY2013 F'Y2014 FY2015 FY2016 FY2 17 33 Self SustainingFunds ands Projected Total Band Cosh (FY2013 - FY201 (before grants and reimbursements) FY2013 FY2+014 FY2015 FY2016 FY2017 Existing Bond Costs $484,929 $475,105 $463,993 $375,068 $372,537 Projected New Bond costs $0 $0 $997,000 $1,808,550 $2,047,145 TOTAL BON0 COSTS $484,929 $475,105 $1,460,993 $2,183,618 $2,419,682 Total Projected Bond Casts ( 2Q13-FY2 17 (before grants and reimbursements) $2, $2,000,000 $1. $1, FY2013 FY2014 FY2015 FY2016 FY2017 34 s r w i M i' i � a� s r a • •� iiM ii iii - i� iai t is i�i "i'® lii ,- {* � � , �. i �' i � • i