Loading...
HomeMy Public PortalAboutApril18Financial TOWN OF WATERTOWN REPORT ORIGINAL TRANFRS/ REVISED AVAILABLE PCT BUDGEF USED Olrlar>•ra:r.Grtn �11I�.i'J l,llr,�i�J.4dadJ`LtiG:.�aJM'.. S10111 FULL TIME SALARIES 1,478,607 10,297 1,488904 1,039,860.86 .00 449,043.14 69.8% 510112 PART TIME SALARIES 464,760 2,959 467:719 317,SSS.05 .00 150,163.95 67.9% 510130 OVERTIME 25,000 0 25,000 17,639.48 .00 7,360.52 70.6% 510141 SHIFT DIFFERENTIAL 3,719 0 3,719 2636.25 .00 1,082.75 70.9% 510143 LONGEVITY 24,948 600 25,548 19:913.52 .00 5,634.48 77.9% 510190 CLOTHING ALLOWANCE 2,772 0 2,772 2767.00 .00 5.00 99.8% 510195 ONE TIME PAYMENT 0 2.100 2,100 2:100.00 .00 .00 100.0% 511111 PRIOR YEAR FULL TIME 0 5,231 5,231 5,230.53 .00 .47 100.0% 511112 PRIOR YEAR PART TIME 0 1,517 1,517 956.75 .00 560.25 63.1% TOTAL LIBRARY - PERS. SVCS. 1,999,806 22,704 2,022,510 1,408,659.44 .00 613,850.56 69.6% BIOLAybyt ra:,cre2A�xlU fta>a 520211 ELECTRICITY 127,577 0 127,577 89,671.09 .00 37,905.91 70.3% 520213 GAS 34,804 0 34,804 14,755.59 .00 20,048.41 42.4% 520240 OFFICE EQUIPMENT MAINTENANCE 3,949 0 3,949 2,028.77 1,235.31 684.92 82.7% 520241 BUILDING MAINTENANCE 38,455 0 38,455 358S3.16 1,624.16 977.68 97.5% 520244 COMPUTER MAINTENANCE 20,500 0 20,500 12:838.32 6,674.45 987.23 95.2% 530327 REGIONAL LIBRARY 'SERVICES 66,105 0 66,105 66104.70 .00 .30 100.0% 530342 COMMUNICATIONS - POSTAGE 1,600 0 1,600 1:460.00 .00 140.00 91.3% 540421 OFFICE SUPPLIES 11,000 0 11,000 7,254.95 2,291.96 1,453.09 86.8% 540422 PRINTING & FORMS 5,000 . 0 5,000 3,653.57 848.84 497.59 90.0% 540430 BUILDING MAINTENANCE SUP. 16,000 0 16,000 7,945.78 6,944.17 1,110.05 93.1% 550511 BOOKS 405,000 0 405,000 291,476.51 109 199.03 4,324.46 98.9% 550512 BOOK PROCESSING 39,500 0 39,500 16,609.94 7:468.84 15,421.22 61.0% 570710 IN STATE TRAVEL S00 0 500 78.24 .00 421.76 15.6% 570730 DUES & SUBSCRIPTIONS 990 0 990 340.00 650.00 .00 100.0% 570735 PROJECT LITERACY/TOWN 62,320 0 62,320 45,200.34 17,020.66 99.00 99.8% 570785 COMMITTEE EXPENSES 3,600 0 3,600 1681.31 452.00 1466.69 59.3% 570787 STAFF DEVELOPMENT 10,000 0 10,000 4:489.98 .00 5:510.02 44.9% TOTAL LIBRARY - EXPENSES 846,900 0 846,900 601.442.25 154,409.42 91,048.33 89.2% Report generated: 03/29/2018 14:26 Page 1 user: nruggeri-koret Program zo: glyttlbud TOWN OF WATERTOWN �` REPORT EXPENDEDORIGINAL TRANFRS/ REVISED AVAILABLE PCT ,Uai/YI�:�WYON_R\��Y_vLYLf� 580840 IMPROV/BLDG RENOV 41,000 0 41,000 4,380.07 .00 36,619.93 10.7% 580870 REPLACEMENT OF EQUIPMENT 14,000 0 14,000 4,684.32 171.65 9,144.03 34.7% TOTAL LIBRARY - CAPITAL 55,000 0 55,000 9,064.39 171.65 45,763.96 16.8% TOTAL LIBRARY 2,901,706 22,704 2,924,410 2,019,166.08 154,581.07 750,662.85 74.3% TOTAL GENERAL FUND - TOWN 2,901,706 22,704 2,924,410 2,019,166.08 154,581.07 750,662.85 74.3% GRAND TOTAL 2,901,706 22,704 2,924,410 2,019,166.08 154,581.07 750,662.85 74.3% ** END OF REPORT - Generated by Natasha Ruggeri-Koret == Report generated: 03/29//2018 14:26 Page 2 user: 9yeri 4 Program io: 97 yt bud WATERTOWN FREE PUBLIC LIBRARY EXPENDITURE BREAKDOWN FY18 FY18 3rd QUARTER BUDGET BREAKDOWN 0161058 580870 REPLACEMENT EQUIPMENT VENDOR* AMOUNT TO DATE ITEMS/COMMENTS AMAZON.COM $ 828.35 REPLACEMENT EQUIPMENT BIBLIOTHECA LLC $ 935.00 CHILDRENS RFID WORKSTATION GOVCONNECTION INC $ 2,375.00 FORTIGATE 100E NEWEGG $ S4S.97 STAFF PRINTERS TOTAL $ 4,684.32 0161058 580840 IMPROVMENTS/BUILDING RENOVATIONS VENDOR AMOUNT TO DATE ITEMS/COMMENTS SHANAHAN SOUND&ELECTRONICS $ 4,380.07 WSBR AV SYSTEM TOTAL $ 4,380.07 0161052 570787 STAFF DEVELOPMENT VENDOR AMOUNT TO DATE ITEMS/COMMENTS AMERICAN LIBRARY ASSOCIATION $ 2,060.00 CONFERENCE REGISTRATIONS KATHLEEN BRENNAN $ 45.00 REGISTRATION/MILEAGE REIMBURSEMENT CAITLIN BROWNE $ 20.00 DISABILITY TRAINING REIMBURSEMENT CALIFA GROUP $ 200.00 PAULI STERN WEBINAR REGISTRATION CAREY CON KEY $ 257.19 COMPETENCY TRAINING REIMBURSEMENT DIGITAL COMMONWEALTH $ 110.00 BRITA ZITIN CONFERENCE REGISTRATION MA READING ASSOCATION $ 376.00 KATHLEEN BRENNAN REGISTRATION BRITA ZITIN $ 1,421.79 CONFERENCE REIMBURSEMENT TOTAL $ 4,489.98 0161052 570785 COMMITTEE EXPENSES VENDOR AMOUNT TO DATE ITEMS/COMMENTS AMAZON.COM $ 21.57 TRUSTEE NAMEPLATES AMERICAN LIBRARY ASSOCIATION $ 189.00 TRUSTEE MEMERSHIPS CAITLIN BROWNE $ 842.74 LUNCHEON SUPPLY REIMBURSEMENTS RED LEAF CAFt $ 628.00 TRUSTEE MEETING/PARTY REFRESHMENTS TOTAL $ 1,681.31 WATERTOWN FREE PUBLIC LIBRARY EXPENDITURE BREAKDOWN FY18 0161052 570735 PROJECT LITERACY VENDOR AMOUNT TO DATE ITEMS/COMMENTS AMAZON.COM $ 400.00 SUPPLIES FLORY BARRINGHAM $ 3,490.87 TEACHING ANNE BENAQUIST $ 775.75 TEACHING DONNA BOSCO $ 428.00 TEACHING LEONA BRESLOW $ 3,918.92 TEACHING OLIVIA DRABICKI $ 4,071.01 TEACHING EASY ENGLISH NEWS $ 131.60 EASY ENGLISH NEWS KATHLEEN HYNES $ 66.88 TEACHING JULIE LEGER-FULLERTON $ 3,878.75 STUDENT SUPPORT COORDINATOR SHARON LICHTMAN $ 4,146.26 TEACHING NATHAN MORTENSON $ 2,313.88 TEACHING MICHELLE ANN NAJARIAN $ 909.51 TEACHING JANET ONYAK $ 3,397.24 TEACHING PEARSON EDUCATION $ 3,576.65 MATERIALS JANE RAVID $ 896.12 TEACHING SHAHRZAD INC $ 1,000.00 PHOTOCOPYING MICHELLE SMITH $ 3,236.75 TEACHING JULIE TOVAR $ 4,002.01 TEACHING JACKY VAN LEEUWEN $ 12.75 PHOTOCOPYING REIMBURSEMENT VERIZON WIRELESS $ 234.90 CELL PHONE WB MASON $ 300.00 SUPPLIES GAEL WILLIAMS $ 4,012.49 TEACHING TOTAL $ 45,200.34 0161052 540430 BUILDING MAINTENANCE SUPPLIES VENDOR AMOUNT TO DATE ITEMS/COMMENTS AMAZON.COM ' $ 1,206.61 BUILDING MAINTENANCE SUPPLIES ASP ENTERPRISES $ 148.50 NO SMOKING SIGNS ATLANTIC BATTERY CO INC $ 40.00 SECURITY SYSTEM BATTERY BERL ENTERPRISES LLC $ 539.00 STEP N WASH FOR CHILDREN'S DEPT BESAM $ 110.31 WASHERS FOR SLIDING DOORS COOLIDGE HARDWARE $ 135.28 BUILDING MAINTENANCE SUPPLIES D&R ELECTRICAL CORP $ 47.59 BALLASTS DURON PAINTS $ 765.43 PAINT ELIZABETH HELFER $ 396.22 HATCH REIMBURSEMENTS EVERLAST CLIMBING INDUSTRIES INC $ 98.00 BIKE STATION HOSE REPLACEMENT GRAINGER $ 196.99 BUILDING MAINTENANCE SUPPLIES KATIE KOTTAS $ 10.61 CORK BOARD INSTALLATION SUPPLIES BOB MCLAUGHLIN $ 7.97 LEADER HOSE REIMBURSEMENT MD STETSON CO INC $ 147.15 NEUTRAL CLEANER MR SWEEPER $ 29.98 VACUUM BAGS RB ALLEN $ 331.12 REPLACEMENT SMOKE DETECTORS SERVICE LIGHTING INC $ 55.19 LIGHTBULBS SHERMAN LOCK $ 283.50 CHILDREN'S BATHROOM LOCK REPAIR STAPLES ADVANTAGE $ 1,116.81 BUILDING MAINTENANCE SUPPLIES WB MASON $ 2,279.52 BUILDING MAINTENANCE SUPPLIES TOTAL $ 7,945.78 WATERTOWN FREE PUBLIC LIBRARY EXPENDITURE BREAKDOWN FY18 0161052 540422 PRINTING VENDOR AMOUNT TO DATE ITEMS/COMMENTS STAPLES ADVANTAGE $ 3,534.57 PRINTING WB MASON $ 119.00 CHILDREN'S BOOKMARKS TOTAL $ 3,653.57 0161052 540421 OFFICE SUPPLIES VENDOR AMOUNT TO DATE ITEMS/COMMENTS AMAZON.COM i $ 1,680.00 OFFICE SUPPLIES BLUE RIDGE VISUAL COMMUNICATIONS $ 478.24 CIRCULATION CORK BOARDS CAITLIN BROWNE $ 269.94 REIMBURSEMENTS LEONE COLE $ 17.95 REIMBURSEMENTS DISPLAY52GO $ 228.56 DISPLAY STANDS ELM USA $ 168.70 DISC BUFFING SUPPLIES FLOTECH $ 952.44 STAFF TONER HAMCO KANSAS CITY $ 405.60 RECEIPT PAPER THE LIBRARY STORE $ 114.21 CHILDREN'S HEADPHONES NATASHA RUGGERI-KORET $ 38.00 NOTARY JOURNAL REIMBURSEMENT STAPLES ADVANTAGE $ 290.13 OFFICE SUPPLIES TECH SOUP GLOBAL $ 55.00 ADOBE ACROBAT LICENSE ULINE $ 42.04 OFFICE SUPPLIES WB MASON $ 2,514.14 OFFICE SUPPLIES TOTAL $ 7,254.95 0161052 520244 COMPUTER MAINTENANCE VENDOR AMOUNT TO DATE ITEMS/COMMENTS BIBLIOTHECA LLC $ 2,963.53 ANNUAL SUPPORT AND LICENSES BLUE ROBIN INC $ 35.00 ANNUAL DNS HOSTING CREDO REFERENCE LTD $ 1,491.00 LIBRARIAN CONNECT D&R ELECTRIC CORP $ 2,500.00 HATCH INTERNET INSTALLATION EMMA INC $ 480.00 EMMA EMAIL LIST EVERNOTE CORPORATION $ 600.00 EVERNOTE ANNUAL RENEWAL FARONICS TECHNOLOGIES $ 810.00 DEEP FREEZE RENEWAL FLOTECH $ 338.00 STAFF PRINTER CONTRACT JAMES GILLEN $ 191.04 CRASHPLAN REIMBURSEMENTS GOVCONNECTION $ 3,510.00 ADOBE LICENSES HUB TECHNICAL SERVICES $ 313.26 FORTINET SUPPORT MINUTEMAN LIBRARY NETWORK $ 737.49 PLYMOUTH ROCKET/SSL CERTIFICATE SENSOURCE $ 360.00 DOOR COUNTER TOTAL $ 14,329.32 WATERTOWN FREE PUBLIC LIBRARY EXPENDITURE BREAKDOWN FY18 0161052 520241 BUILDING MAINTENANCE VENDOR AMOUNT TO DATE ITEMS/COMMENTS BESAM US INC $ 1,547.85 DOOR MAINTENANCE AND CONTRACT COMMONWEALTH GLASS $ 689.00 CAFE DOOR CLOSER D&R ELECTRIC $ 1,281.70 ELECTRICAL WORK EAGLE ELEVATOR $ 1,175.00 ELEVATOR MAINTENANCE FM EMERGENCY GENERATOR $ 399.45 GENERATOR BATTERY REPLACEMENT KIRK EUGENE HOBBS $ 550.00 TV INSTALLATION J AND B'S PLUMBING $ 1,765.00 WATER HEATER SERVICE JC CANNISTRARO INC $ 23,217.65 HVAC MAINTENANCE AND SERVICE JOHN PAUL FLAHERTY $ 340.00 WSBR AV CABINET FRAMING JOHNS SEWER AND PIPE CLEANING $ 859.54 GREASEIRAP CLEANING KEANE FIRE AND SAFETY $ 83.92 FIRE EXTINGUISHER SERVICE RB ALLEN $ 2,175.00 FIRE ALRM/SPRINKLER MAINTENANCE SAS $ 880.00 BUILDING SECURITY SYSTEM SHANAHAND SOUND&ELECTRONICS $ 759.05 WSBR AV SYSTEM CHANGE ORDERS SHERMAN LOCK $ 130.00 CHILDREN'S BATHROOM LOCK REPAIR TOTAL $ 35,853.16 0161052 520240 EQUIPMENT MAINTENANCE VENDOR AMOUNT TO DATE ITEMS/COMMENTS CANON SOLUTIONS AMERICA• $ 491.02 TECH SERVICES PHOTOCOPIER CONTRACT FLOTECH $ 128.00 ADMIN PHOTOCOPIER SERVICESTAR DOCUMENT MGMT $ 899.00 MICROREADER/SCANNER CONTRACT VERIZON WIRELESS $ 510.75 CUSTODIAL/HATCH CELL PHONES TOTAL $ 2,028.77 FY18 FUNDS AND GRANTS Available to Current spend balance Expended available Fund or Grant 7/1/2017 as of 7/1/2017 Deposits YTD YTD balance Notes Book Funds Pratt(includes Pratt Stock) 113,800.63 1,996.17 25.87 - 1,996.17 80%of int on periodicals Whitney 2,674.24 2,674.24 (30.91) - 2,643.33 Mead 6,564.45 3,564.45 (75.86) - 3,488.59 Charles 2,146.21 1,946.21 (24.79) - 1,921.42 Armenian History books Barry 3,045.22 3,045.22 (35.19) - 3,010.03 McGuire 2,873.14 1,873.14 (33.21) - 1,839.93 W. Pierce 22,881.76 2,881.76 (264.19) - 2,617.57 MacDonald 8,282.73 3,282.73 (95.67) 138.67 3,048.39 Grief related books O'Reilly 7,581.01 7,081.01 (87.56) - 6,993.45 Fiction Stone 1,526.22 1,526.22 (4.42) - 1,521.80 Campbell 4,332.90 3,332.90 (25.40) 1,192.59 2,114.91 Large print books Santoro 1,853.26 253.26 (21.41) - 231.85 Art Brown 2,733.73 1,733.73 (31.55) 188.70 1,513.48 Sci-fi books Keith 3,496.82 2,496.82 (37.20) 146.00 2,313.62 Wat history books Drucker 2,412.15 2,412.15 (27.85) - 2,384.30 Humanities books Special Gifts 13,475.38 13,475.38 (4,785.18) 3,920.27 4,769.93 Unrestricted -Cohen Fund 12,195.19 12,195.19 - 1,087.51 11,107.68 Cookbook and Mysteries -Makerspace Fund 4,152.63 4,152.63 5,467.20 7,363.83 2,256.00 Makerspace materials Other Funds&Grants Kaveny 31,737.59 3,366.10 (363.04) 161.84 2,841.22 Benefit of the library Masters 3,657.30 950.30 (42.23) - 908.07 Trustees discretion B. Pierce 1,828.84 1,828.84 (21.14) - 1,807.70 Trustees discretion LIG/MEG 73,495.92 73,495.92 58,508.61 11,661.53 120,343.00 Revolving Printing Account 16,850.03 16,850.03 13,896.50 16,185.66 14,560.87 Friends of Project Literacy Fundraising 614.52 614.52 39,971.00 15,133.19 25,452.33 McCall Gift Fund 78,147.23 78,147.23 - - 78,147.23 For children's dept only Griffin 144,788.70 144,788.70 18,440.80 5,000.00 158,229.50 GRIFFIN FUND REPORT CASH VERIZON AVAILABLE INTEREST/ INVESTMENT VERIZON STOCK CASH HELD FOR MONTH ENDING BEG BAL ADDED WITHDRAWN DIVIDENDS MKT VAL ADJ DIVIDENDS MKTVALADJ END BAL FORINV SPENDING INV FY17 BAL FWD 144,788.70 $ 144,788.70 $ 2,154.54 $ 7,390.21 $ 135,243.95 31-Jul 144,788.70 - - 3.97 5.94 - 11,627.66 $ 156,426.27 $ - $ 7,400.12 $ 146,871.61 31-Aug 156,426.27 (3.72) 3.80 1,832.20 2,267.12 $ 160,525.67 $ 732.88 $ 8,499.52 $ 149,138.73 30-Sep 160,525.67 (5,000.00) 29.48 (28.16) - 4,725.68 $ 160,252.67 $ - $ 3,500.84 $ 153,864.41 31-Oct 160,252.67 - 1.27 0.50 - (5,036.58) $ 155,217.86 $ - $ 3,502.61 $ 148,827.83 30-Nov 155,217.86 5.82 2.28 1,832.20 9,389.18 $ 166,447.34 $ 732.88 $ 4,610.03 $ 158,217.01 31-Dec 165,447.34 8.59 9.92 10,047.46 $ 172,966.41 $ (3,546.90) $ 4,628.54 $ 168,264.47 31-Jan 172,966.41 2.08 (30.94) 3,624.06 $ 176,561.61 $ - $ 4,599.68 $ 171,888.53 28-Feb 176,561.61 57.30 (98.54) 1,832.20 (20,123.07) $ 158,229.50 $ 732.88 $ 5,657.76 $ 151,765.46 31-Mar 158,229.50 $ 158,229.50 $ - $ 5,657.76 $ 151,765.46 30-Apr 158,229.50 $ 158,229.50 $ - $ 5,657.76 $ 151,765.46 31-May 158,229.50 $ 158,229.50 $ - $ 5,657.76 $ 151,765.46 30-Jun 158,229.50 $ 158,229.50 $ - $ 5,657.76 $ 151,765.46 FYI8 TOTAL - (8,546.90) 104.79 (135.20) 5,496.60 16,521.51 $ 13,440.80 806.28 5,657.76 $ 151,765.46 FUNDS USED TO PURCHASE ADDITIONAL SHARES w*a%"* 6,464.04 � rl Y t Iu is Teat ltL Teo-oP ��. C:�iCd.i�a't.��fii1c�.�?ra4. Ada�,fiat.adult:Prog. Museums Nlay.l.� $27,044.00 $27,044.00 $2,705.00 $2,913.00 $1�352.00 $9�064.00 $1,352.00 $4,208.00 $4,OOO.00 $1,450.00 PQ 2EC fmk 9 Cate Vendor/Descrlpdon Spent as of 312912018 $2J06.90 $1,209.31 $1,352.00 $6,282.57 $1,351.27 $3,316.67 $4,223.00 $1,227.00 Balance of Accounts as of 312912018 $5.375.28 41.90 $1 o703.69 $0.00 $2,781.43 $0.73 $991.33 -$223.001 $223.00 AN i - D -T9 QfSCM#f- ` `� -�3`tFT� UQf MJEQ;. co�'[tf l,.* E �Q1FF'CA. , to ~ n .V or+Gunter,a + inn �' o� �( �� 7;4 A7 -/2{ 1 Jo dan,,p,6Wg-. a1Ce lSeaw.ril bu serfient a-/ .20 ME-Engra.veim$apply!--laser cufter f liters 4U2 y, $ 7: :45'` FVJ 1 I T(ital:Revenue � ..�._.._-__....�__...W,15i972. 43,161.60 $33,CO1.85.' $, '9s00.004 22,590.06 ...~$ .9.24,525.�.�• Taal �xpenditure $ m .17) $ €41517.60 + ; $ (10fi56:18)j $ (23J 5,16) $(118' 12034) Current Baiaftie $ 6,613.A5_