Loading...
LIBRARY BOARD Packet - 7/17/2018 (2)CITY OF MUSKEGO LIBRARY BOARD AGENDA 07/17/2018 5:00 PM Library Conference Room, S73 W16663 Janesville Road CALL TO ORDER PLEDGE OF ALLEGIANCE ROLL CALL STATEMENT OF PUBLIC NOTICE PUBLIC COMMENT CONSENT AGENDA 1 Approval of minutes from June 19, 2018 June 19, 2018 Minutes 2 Place on file the Library Financial Reports Financial Reports PRESIDENT’S REPORT Information DIRECTOR’S REPORT Information 1 July '18 Director's Report UNFINISHED BUSINESS Discussion update and possible action may be taken on any or all of the following: NEW BUSINESS Discussion update and possible action may be taken on any or all of the following: 1 Operating Budget 2 Capital Budget 3 Public Library System Redesign Update Packet Page 1 COMMUNICATIONS AND MISCELLANEOUS BUSINESS AS AUTHORIZED BY LAW ADJOURNMENT NOTICE PLEASE NOTE: It is possible that members of and possibly a quorum of members of other governmental bodies of the municipality may be in attendance at the above-mentioned meeting to gather information; no action will be taken by any governmental body at the above-stated meeting other than the governmental body specifically referred to above in this notice. Upon reasonable notice, efforts will be made to accommodate the needs of disabled individuals through appropriate aids and services. For additional information or to request this service, contact Muskego City Hall, (262) 679-4100. Packet Page 2 CITY OF MUSKEGO LIBRARY BOARD MINUTES June 19, 2018 5:00 PM Library Conference Room, S73 W16663 JANESVILLE RD CALL TO ORDER Vice President Konkel called the meeting to order at 5:00 PM. PLEDGE OF ALLEGIANCE ROLL CALL Present were Trustees Tomaszewski, Keil, Darkow, Heinowski, Konkel, Jung and Director Larson. President Robertson, Trustee Schroeder and Alderman Kapusta were excused. Note: Trustee Schroeder arrived at 5:25 PM. Trustee Jung left at 5:30 PM. STATEMENT OF PUBLIC NOTICE PUBLIC COMMENT CONSENT AGENDA Trustee Tomaszewski made a motion to approve the CONSENT AGENDA. Trustee Darkow seconded. Motion Passed 6 in favor. Approval of minutes from May 15, 2018 May 15, 2018 Minutes Place on file the Library Financial Reports Financial Reports PRESIDENT’S REPORT DIRECTOR’S REPORT June '18 Director's Report UNFINISHED BUSINESS NEW BUSINESS Page 1 of 2 June 19, 2018 Minutes Packet Page 3 Contact Information for Library Board Operating Budget Disussion Operating Budget Discussion Bridges and Public Library System Redesign Update Bridges and PLSR Update COMMUNICATIONS AND MISCELLANEOUS BUSINESS AS AUTHORIZED BY LAW ADJOURNMENT Trustee Darkow made a motion to adjourn, Trustee Keil seconded. Motion Passed 6 in favor. Meeting adjourned at 6:13 PM. Page 2 of 2 June 19, 2018 Minutes Packet Page 4 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 1 Report dates: 6/1/2018-6/30/2018 Jul 05, 2018 11:03AM Report Criteria: Detail report. Invoices with totals above $0 included. Paid and unpaid invoices included. [Report].Description = {<>} "1099 adjustment" Invoice Detail.Type = {>} "adjustments" Invoice Detail.GL account = "1000571000000"-"1000571999999","5020000000000"-"5029999999999","5030000000000"-"5039999999999","4100890716500"-"4100890716599" Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number BAKER & TAYLOR COMPANY 2033720368 1 Invoice PRINT 05/16/2018 06/12/2018 1,007.99 618 100.05.71.01.5711 2033736846 1 Invoice PRINT 05/22/2018 06/12/2018 407.57 618 100.05.71.01.5711 2033738443 1 Invoice REPLACEMENT 05/23/2018 06/12/2018 26.06 618 100.05.71.00.5774 2033738443 2 Invoice PRINT 05/23/2018 06/12/2018 15.67 618 100.05.71.01.5711 2033738476 1 Invoice PRINT 05/23/2018 06/12/2018 663.23 618 100.05.71.01.5711 2033740335 1 Invoice REPLACEMENT 05/23/2018 06/12/2018 42.13 618 100.05.71.00.5774 2033740335 2 Invoice PRINT 05/23/2018 06/12/2018 22.35 618 100.05.71.01.5711 2033758431 1 Invoice PRINT 06/01/2018 06/26/2018 800.59 618 100.05.71.01.5711 2033758479 1 Invoice PRINT 06/01/2018 06/26/2018 562.27 618 100.05.71.01.5711 2033761235 1 Invoice PRINT 06/04/2018 06/26/2018 832.43 618 100.05.71.01.5711 2033762268 1 Invoice PRINT 06/05/2018 06/26/2018 759.40 618 100.05.71.01.5711 2033772645 1 Invoice PRINT 06/07/2018 06/26/2018 2,673.53 618 100.05.71.01.5711 5015015423 1 Invoice PRINT 05/16/2018 06/12/2018 73.93 618 100.05.71.01.5711 5015025259 1 Invoice PRINT 05/23/2018 06/12/2018 48.09 618 100.05.71.01.5711 5015034419 1 Invoice PRINT 05/30/2018 06/12/2018 300.92 618 100.05.71.01.5711 5015044632 1 Invoice PRINT 06/06/2018 06/26/2018 113.07 618 100.05.71.01.5711 B90773080 1 Invoice AV 05/22/2018 06/12/2018 60.45 618 100.05.71.02.5711 Total BAKER & TAYLOR COMPANY:8,409.68 BAKER & TAYLOR ENTERTAINMENT B90904480 1 Invoice AV 05/23/2018 06/12/2018 17.96 618 100.05.71.02.5711 B91027590 1 Invoice AV 05/25/2018 06/12/2018 353.15 618 100.05.71.02.5711 B91239610 1 Invoice AV 05/29/2018 06/12/2018 100.75 618 100.05.71.02.5711 B91677730 1 Invoice AV 06/04/2018 06/26/2018 272.58 618 100.05.71.02.5711 B91737890 1 Invoice AV 06/05/2018 06/26/2018 51.06 618 100.05.71.02.5711 B91737891 1 Invoice AV 06/05/2018 06/26/2018 133.08 618 100.05.71.02.5711 B91923900 1 Invoice AV 06/07/2018 06/26/2018 21.59 618 100.05.71.02.5711 B91942550 1 Invoice AV 06/07/2018 06/26/2018 18.71 618 100.05.71.02.5711 B91994470 1 Invoice AV 06/08/2018 06/26/2018 17.96 618 100.05.71.02.5711 B92271720 1 Invoice AV 06/12/2018 06/26/2018 83.48 618 100.05.71.02.5711 B92271721 1 Invoice AV 06/12/2018 06/26/2018 21.59 618 100.05.71.02.5711 T80634720 1 Invoice AV 05/14/2018 06/12/2018 65.48 618 100.05.71.02.5711 T81298620 1 Invoice AV 05/29/2018 06/26/2018 17.96 618 100.05.71.02.5711 T81702610 1 Invoice AV 06/04/2018 06/26/2018 10.75 618 100.05.71.02.5711 Total BAKER & TAYLOR ENTERTAINMENT:1,186.10 BOARD GAME BARRISTER, LTD 1125043 1 Invoice KIDS SUMMER READING PROGR 06/07/2018 06/26/2018 300.00 618 100.05.71.00.6062 Total BOARD GAME BARRISTER, LTD:300.00 CDW GOVERNMENT, INC MTV3042 1 Invoice LIB. DISPLAY FOR CHILDRENS AR 05/22/2018 06/26/2018 426.38 618 410.08.90.71.6508 Total CDW GOVERNMENT, INC:426.38 Page 1 of 12 Financial Reports Packet Page 5 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 2 Report dates: 6/1/2018-6/30/2018 Jul 05, 2018 11:03AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number COMPLETE OFFICE OF WIS 325132 1 Invoice OFFICE SUPPLIES 05/25/2018 06/12/2018 105.24 618 100.05.71.00.5701 413630 1 Invoice SUPPLIES 04/07/2018 06/26/2018 30.95 618 100.05.71.00.5701 Total COMPLETE OFFICE OF WIS:136.19 DEMCO EDUCATIONAL CORP 6380556 1 Invoice SUMMER READING T'S - FOL 05/18/2018 06/12/2018 58.00 618 100.05.71.00.6062 6380639 1 Invoice SUMMER READING T'S - FOL 05/18/2018 06/12/2018 33.15 618 100.05.71.00.6062 6380829 1 Invoice WOMAN'S CLUB DONATION-KID'S 05/18/2018 06/12/2018 2,033.33 618 503.05.00.00.6007 Total DEMCO EDUCATIONAL CORP:2,124.48 DEPT OF ADMINISTRATION 505-00000284 1 Invoice TEACH 1/1/18-6/30/18 06/08/2018 06/26/2018 600.00 618 100.05.71.00.5505 Total DEPT OF ADMINISTRATION:600.00 ELLIOTT'S ACE HARDWARE EL061218 5 Invoice LIB MAINT 05/31/2018 06/12/2018 28.27 618 100.05.71.00.5415 EL061218 9 Invoice LIB MAINT 05/31/2018 06/12/2018 15.97 618 100.05.71.00.5415 Total ELLIOTT'S ACE HARDWARE:44.24 EVERBANK COMMERCIAL FINANCE, INC. 20340429/0626 1 Invoice STAFF COPIER LEASE + ORIGINA 06/10/2018 06/26/2018 486.55 618 100.05.71.00.5401 Total EVERBANK COMMERCIAL FINANCE, INC.:486.55 FINDAWAY WORLD,LLC 249788 1 Invoice AV 04/04/2018 06/12/2018 195.75 618 100.05.71.02.5711 255485 1 Invoice AV 05/18/2018 06/12/2018 359.94 618 100.05.71.02.5711 Total FINDAWAY WORLD,LLC:555.69 FIRST BUSINESS 3469/062618 1 Invoice WAGON & SUPPLIES FOR KID'S M 05/29/2018 06/26/2018 106.41 618 100.05.71.00.5701 3871/062618 1 Invoice SUPPLIES FOR KID'S MOVE 05/29/2018 06/26/2018 50.01 618 100.05.71.00.5701 3897/062618 1 Invoice AV 05/29/2018 06/26/2018 22.99 618 100.05.71.02.5711 3897/062618 2 Invoice NOOK SETUP 05/29/2018 06/26/2018 .01 618 100.05.71.03.5711 3897/062618 3 Invoice PRINT 05/29/2018 06/26/2018 59.24 618 100.05.71.01.5711 3905/062618 1 Invoice FOL - YA PROGRAMMING 05/29/2018 06/26/2018 26.90 618 100.05.71.00.6062 3913/062618 1 Invoice CHILDREN'S PROGRAMMING 05/29/2018 06/26/2018 108.10 618 100.05.71.00.6062 3913/062618 2 Invoice FOL - CHILDREN"S PROGRAMMIN 05/29/2018 06/26/2018 70.48 618 100.05.71.00.6062 3913/062618 3 Invoice RIBBON CUTTING - CONSTRUCTI 05/29/2018 06/26/2018 104.58 618 410.08.90.71.6508 Total FIRST BUSINESS:548.72 FRIENDS OF THE MUSKEGO PUBLIC LIBRARY FR061218 1 Invoice REMAINING BALANCE FOR DJ AT 06/05/2018 06/12/2018 250.00 618 100.05.71.00.6062 Total FRIENDS OF THE MUSKEGO PUBLIC LIBRARY:250.00 JAMES IMAGING SYSTEMS INC (lease) 827351 1 Invoice LIBRARY COPIER-FINAL USAGE 06/06/2018 06/26/2018 28.01 618 100.05.71.00.5401 Total JAMES IMAGING SYSTEMS INC (lease):28.01 Page 2 of 12 Financial Reports Packet Page 6 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 3 Report dates: 6/1/2018-6/30/2018 Jul 05, 2018 11:03AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number JANI-KING INC- MILW REGION MIL06180159 3 Invoice CLEANING/LIB JUNE 06/01/2018 06/12/2018 3,049.00 618 100.05.71.00.5835 Total JANI-KING INC- MILW REGION:3,049.00 JM BRENNAN, INC. SALES000096 1 Invoice PREVENTIVE MAINT ON HVAC EQ 05/17/2018 06/12/2018 1,820.00 618 100.05.71.00.5415 Total JM BRENNAN, INC.:1,820.00 KC'S INFLATABLES, LLC 2018-032/0612 1 Invoice REMAINING BALANCE ON GAMES 02/01/2018 06/12/2018 90.00 618 100.05.71.00.6062 Total KC'S INFLATABLES, LLC:90.00 KUJAWA ENTERPRISES INC. 116542 1 Invoice JUNE PLANT MAINTENANCE 06/04/2018 06/26/2018 61.00 618 100.05.71.00.5415 Total KUJAWA ENTERPRISES INC.:61.00 LIBRARY FURNITURE INT, INC 5976 1 Invoice CHILDRENS AREA FURNITURE - 06/04/2018 06/12/2018 8,817.00 618 503.05.00.00.6007 5976 2 Invoice CHILDRENS AREA REDESIGN - F 06/04/2018 06/12/2018 19,273.00 618 410.08.90.71.6508 5977 1 Invoice SHELVING MOVE - REMAINING BA 06/04/2018 06/26/2018 4,002.00 618 410.08.90.71.6508 Total LIBRARY FURNITURE INT, INC:32,092.00 MICROMARKETING LLC 720592 1 Invoice AV 05/15/2018 06/12/2018 177.50 618 100.05.71.02.5711 721045 1 Invoice AV 05/18/2018 06/12/2018 67.98 618 100.05.71.02.5711 721104 1 Invoice AV 05/21/2018 06/12/2018 8.50 618 100.05.71.02.5711 721520 1 Invoice AV 05/22/2018 06/12/2018 39.99 618 100.05.71.02.5711 721557 1 Invoice AV 05/22/2018 06/12/2018 45.99 618 100.05.71.02.5711 722335 1 Invoice AV 05/30/2018 06/26/2018 39.99 618 100.05.71.02.5711 Total MICROMARKETING LLC:379.95 MIDWEST TAPE 96141209 1 Invoice AV 05/30/2018 06/12/2018 62.98 618 100.05.71.02.5711 96159472 1 Invoice AV 06/04/2018 06/26/2018 94.48 618 100.05.71.02.5711 96176094 1 Invoice AV 06/09/2018 06/26/2018 123.87 618 100.05.71.02.5711 96176096 1 Invoice AV 06/09/2018 06/26/2018 78.73 618 100.05.71.02.5711 Total MIDWEST TAPE:360.06 PENGUIN RANDOM HOUSE LLC 1088241622 1 Invoice AV 05/24/2018 06/12/2018 45.00 618 100.05.71.02.5711 1088336800 1 Invoice AV 06/01/2018 06/26/2018 35.00 618 100.05.71.02.5711 1088398420 1 Invoice AV 06/01/2018 06/26/2018 45.00 618 100.05.71.02.5711 1088440854 1 Invoice AV 06/05/2018 06/26/2018 40.00 618 100.05.71.02.5711 Total PENGUIN RANDOM HOUSE LLC:165.00 QUALITY AWARDS LLC 28184 1 Invoice PLAQUES - KIDS REDESIGN 05/31/2018 06/26/2018 82.25 618 410.08.90.71.6508 Total QUALITY AWARDS LLC:82.25 Page 3 of 12 Financial Reports Packet Page 7 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 4 Report dates: 6/1/2018-6/30/2018 Jul 05, 2018 11:03AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number SAFEWAY PEST MANAGEMENT INC. 9092/062618 3 Invoice PEST CONTROL/LIB/MAY 06/05/2018 06/26/2018 30.00 618 100.05.71.00.5415 Total SAFEWAY PEST MANAGEMENT INC.:30.00 THE REESE GROUP, LLC RE062618-LIB 1 Invoice CARPETING - KID'S AREA 06/19/2018 06/26/2018 30,000.00 618 410.08.90.71.6507 RE062618-LIB 2 Invoice CONSTRUCTION - KID'S AREA 06/19/2018 06/26/2018 20,254.05 618 410.08.90.71.6508 Total THE REESE GROUP, LLC:50,254.05 TIME WARNER CABLE 063003301052 1 Invoice SPECTRUM INTERNET 5/29-6/28 05/24/2018 06/26/2018 94.57 618 100.05.71.00.5505 Total TIME WARNER CABLE:94.57 U.S. CELLULAR 0251618395 7 Invoice MONTHLY CHANGE- LIBRARY 05/28/2018 06/26/2018 10.00 618 100.05.71.00.5602 Total U.S. CELLULAR:10.00 USA FIRE PROTECTION USA056524 1 Invoice AUG 17 SPRINKLER SERVICE WO 03/23/2018 06/12/2018 742.00 618 100.05.71.00.5415 USA060401 1 Invoice MAY 18 QUARTERLY SPRINKLER I 05/16/2018 06/12/2018 180.00 618 100.05.71.00.5415 USA061111 5 Invoice LIBRARY 05/25/2018 06/26/2018 185.16 618 100.05.71.00.5415 Total USA FIRE PROTECTION:1,107.16 WE ENERGIES 5499-564-961/ 1 Invoice LIB ELECTRIC 05/30/2018 06/12/2018 4,946.50 618 100.05.71.00.5910 5499-564-961/ 2 Invoice LIB GAS 05/30/2018 06/12/2018 794.98 618 100.05.71.00.5910 Total WE ENERGIES:5,741.48 Grand Totals: 110,432.56 Report Criteria: Detail report. Invoices with totals above $0 included. Paid and unpaid invoices included. [Report].Description = {<>} "1099 adjustment" Invoice Detail.Type = {>} "adjustments" Invoice Detail.GL account = "1000571000000"-"1000571999999","5020000000000"-"5029999999999","5030000000000"-"5039999999999","4100890716500"-"4100890716599" Page 4 of 12 Financial Reports Packet Page 8 CITY OF MUSKEGO Budget Worksheet - Library Expenditures Current Year w/ Monthly Total Page: 1 Period: 06/18 Jul 05, 2018 10:19AM 2018-18 2018-18 2018-18 2018-18 % Actual Over / Adopted Amended YTD Current Month To (Under) Account Number Account Title Budget Budget Actual Actual Budget Budget GENERAL FUND CULTURE, REC AND EDUCATION 100.05.71.00.5101 SALARY & WAGES 613,713.00 613,713.00 275,696.66 45,510.32 44.92% 338,016.34- 100.05.71.00.5102 OVERTIME 2,000.00 2,000.00 16.27 .00 .81% 1,983.73- 100.05.71.00.5201 FICA 48,484.00 48,484.00 21,632.25 3,557.86 44.62% 26,851.75- 100.05.71.00.5202 PENSION 39,332.00 39,332.00 17,043.99 2,780.18 43.33% 22,288.01- 100.05.71.00.5203 HEALTH 91,083.00 91,083.00 19,993.59 4,447.88 21.95% 71,089.41- 100.05.71.00.5204 LIFE 1,420.00 1,420.00 627.40 107.14 44.18% 792.60- 100.05.71.00.5205 FSA FEE EXPENSE .00 .00 .00 .00 .00 .00 100.05.71.00.5229 HEALTH INSURANCE ALLOWANCE 18,060.00 18,060.00 11,430.00 1,905.00 63.29% 6,630.00- 100.05.71.00.5302 MILEAGE 1,200.00 1,200.00 1,251.62 250.70 104.30% 51.62 100.05.71.00.5303 CONFERENCES & TRAINING 3,500.00 3,500.00 571.25 .00 16.32% 2,928.75- 100.05.71.00.5305 DUES & MEMBERSHIP 1,300.00 1,300.00 624.00 .00 48.00% 676.00- 100.05.71.00.5401 LIBRARY EQUIPMENT 20,500.00 20,500.00 8,945.85 1,072.71 43.64% 11,554.15- 100.05.71.00.5415 MAINTENANCE OF BLDG & GROUNDS 36,700.00 36,700.00 17,132.32 3,062.40 46.68% 19,567.68- 100.05.71.00.5505 COMPUTER CHARGES 41,040.00 41,040.00 24,178.92 694.57 58.92% 16,861.08- 100.05.71.00.5602 TELEPHONE 300.00 300.00 60.00 10.00 20.00% 240.00- 100.05.71.00.5701 OFFICE SUPPLIES AND EXPENSES 8,000.00 8,000.00 5,160.92 292.61 64.51% 2,839.08- 100.05.71.00.5702 PROCESSING SUPPLIES 17,500.00 17,500.00 8,314.77 2,559.87 47.51% 9,185.23- 100.05.71.00.5703 HOUSEKEEPING SUPPLIES 3,800.00 3,800.00 546.69 .00 14.39% 3,253.31- 100.05.71.00.5740 LIBRARY GRANT EXPENSE .00 .00 .00 .00 .00 .00 100.05.71.00.5752 LIBRARY FRIENDS EXPENSE .00 .00 .00 .00 .00 .00 100.05.71.00.5774 LIBRARY REPLACEMENT 1,300.00 1,300.00 177.33 76.19 13.64% 1,122.67- 100.05.71.00.5835 HOUSEKEEPING SERVICES 38,000.00 38,000.00 18,294.00 3,049.00 48.14% 19,706.00- 100.05.71.00.5910 GAS & ELECTRIC 75,000.00 75,000.00 27,613.96 5,741.48 36.82% 47,386.04- 100.05.71.00.5915 SEWER & WATER 2,500.00 2,500.00 980.36 .00 39.21% 1,519.64- 100.05.71.00.6062 PROGRAMMING 6,000.00 6,000.00 6,894.54 936.63 114.91% 894.54 100.05.71.01.5711 PRINT MATERIALS 115,000.00 115,000.00 47,264.27 8,340.28 41.10% 67,735.73- 100.05.71.01.5713 PRINT MATERIALS - ADULT .00 .00 .00 .00 .00 .00 100.05.71.02.5711 AUDIO VISUAL MATERIALS 50,000.00 50,000.00 17,230.91 3,422.25 34.46% 32,769.09- 100.05.71.03.5711 ELECTRONIC MATERIALS 16,000.00 16,000.00 12,474.01 .01 77.96% 3,525.99- 100.05.71.03.5714 AUDIO VISUAL MATERIAL - A.V..00 .00 .00 .00 .00 .00 100.05.71.11.5713 PRINT MATERIALS - JUVENILE .00 .00 .00 .00 .00 .00 100.05.71.12.5714 AUDIO VISUAL MATERIAL - JUVENL .00 .00 .00 .00 .00 .00 100.05.71.14.5713 PRINT MATERIALS - MISC .00 .00 .00 .00 .00 .00 100.05.71.18.5713 PRINT MATERIALS - NEWSPAPER .00 .00 .00 .00 .00 .00 100.05.71.19.5713 PRINT MATERIALS - PERIODICALS .00 .00 .00 .00 .00 .00 100.05.71.23.5713 PRINT MATERIALS - REFERENCE .00 .00 .00 .00 .00 .00 100.05.71.26.5713 PRINT MATERIALS - SERIALS .00 .00 .00 .00 .00 .00 100.05.71.35.5714 AUDIO VISUAL MATRL - DATA BASE .00 .00 .00 .00 .00 .00 100.05.71.36.5713 PRINT MATERIALS - YOUNG ADULT .00 .00 .00 .00 .00 .00 Total LIBRARY DEPARTMENT:1,251,732.00 1,251,732.00 544,155.88 87,817.08 43.47% 707,576.12- Page 5 of 12 Financial Reports Packet Page 9 CITY OF MUSKEGO Budget Worksheet - Library Revenues Current Year w/ Monthly Total Page: 1 Period: 06/18 Jul 05, 2018 10:13AM 2018-18 2018-18 2018-18 2018-18 % Actual Over / Adopted Amended YTD Current month To (Under) Account Number Account Title Budget Budget Actual Actual Budget Budget GENERAL FUND CULTURE, REC AND EDUCATION 100.05.71.00.4140 LIBRARY GRANTS REVENUE .00 .00 .00 .00 .00 .00 100.05.71.00.4150 LIBRARY - SYSTEM, ETC 116,472.00 116,472.00 60,629.30 .00 52.05% 55,842.70- 100.05.71.00.4274 LIBRARY LOST AND DAMAGED 1,300.00 1,300.00 788.62 216.53 60.66% 511.38- 100.05.71.00.4313 LIBRARY FINES 17,000.00 17,000.00 7,640.37 1,460.57 44.94% 9,359.63- 100.05.71.00.4314 LIBRARY TAXABLE REVENUE 9,000.00 9,000.00 4,606.46 769.00 51.18% 4,393.54- 100.05.71.00.4542 LIBRARY PHONE USE .00 .00 .00 .00 .00 .00 100.05.71.00.4544 ROOM RENTAL 1,000.00 1,000.00 468.75 .00 46.88% 531.25- 100.05.71.00.4551 SALE OF F/A - COMPUTERS .00 .00 .00 .00 .00 .00 100.05.71.00.4552 LIBRARY FRIENDS REVENUE .00 .00 3,077.44 396.58 .00 3,077.44 Total LIBRARY DEPARTMENT:144,772.00 144,772.00 77,210.94 2,842.68 53.33% 67,561.06- Page 6 of 12 Financial Reports Packet Page 10 CITY OF MUSKEGO BALANCE SHEET JUNE 30, 2018 FEDERATED LIBRARY SYSTEM FUND ASSETS 503.00.00.00.1001 EQUITY IN POOLED CASH 130,099.57 TOTAL ASSETS 130,099.57 LIABILITIES AND EQUITY FUND EQUITY 503.00.00.00.3510 FUND BALANCE-RESERVED 14,784.97 503.00.00.00.3520 FUND BAL-UNRESERVED UNDESIGNAT 107,712.93 REVENUE OVER EXPENDITURES - YTD 7,801.67 TOTAL FUND EQUITY 130,299.57 TOTAL LIABILITIES AND EQUITY 130,299.57 Page 7 of 12 Financial Reports Packet Page 11 CITY OF MUSKEGO BALANCE SHEET JUNE 30, 2018 LIBRARY EXPANSION TRUST FUND ASSETS 502.00.00.00.1001 EQUITY IN POOLED CASH ( 32,897.00) 502.00.00.00.1011 CASH IN BANK- LIBRARY-1B 12,852.04 502.00.00.00.1105 LIBRARY INVESTMENTS 43,957.21 TOTAL ASSETS 23,912.25 LIABILITIES AND EQUITY FUND EQUITY 502.00.00.00.3501 FUND BALANCE-RESERVED 61,692.95 502.00.00.00.3520 FUND BAL-UNRESERVED UNDESIGNAT ( 38,004.86) REVENUE OVER EXPENDITURES - YTD 224.16 TOTAL FUND EQUITY 23,912.25 TOTAL LIABILITIES AND EQUITY 23,912.25 Page 8 of 12 Financial Reports Packet Page 12 CITY OF MUSKEGO Budget Worksheet - Library Expenditures Current Year w/ Monthly Total Page: 1 Period: 06/18 Jul 05, 2018 10:19AM 2018-18 2018-18 2018-18 2018-18 % Actual Over / Adopted Amended YTD Current Month To (Under) Account Number Account Title Budget Budget Actual Actual Budget Budget GENERAL FUND CULTURE, REC AND EDUCATION 100.05.71.00.5101 SALARY & WAGES 613,713.00 613,713.00 275,696.66 45,510.32 44.92% 338,016.34- 100.05.71.00.5102 OVERTIME 2,000.00 2,000.00 16.27 .00 .81% 1,983.73- 100.05.71.00.5201 FICA 48,484.00 48,484.00 21,632.25 3,557.86 44.62% 26,851.75- 100.05.71.00.5202 PENSION 39,332.00 39,332.00 17,043.99 2,780.18 43.33% 22,288.01- 100.05.71.00.5203 HEALTH 91,083.00 91,083.00 19,993.59 4,447.88 21.95% 71,089.41- 100.05.71.00.5204 LIFE 1,420.00 1,420.00 627.40 107.14 44.18% 792.60- 100.05.71.00.5205 FSA FEE EXPENSE .00 .00 .00 .00 .00 .00 100.05.71.00.5229 HEALTH INSURANCE ALLOWANCE 18,060.00 18,060.00 11,430.00 1,905.00 63.29% 6,630.00- 100.05.71.00.5302 MILEAGE 1,200.00 1,200.00 1,251.62 250.70 104.30% 51.62 100.05.71.00.5303 CONFERENCES & TRAINING 3,500.00 3,500.00 571.25 .00 16.32% 2,928.75- 100.05.71.00.5305 DUES & MEMBERSHIP 1,300.00 1,300.00 624.00 .00 48.00% 676.00- 100.05.71.00.5401 LIBRARY EQUIPMENT 20,500.00 20,500.00 8,945.85 1,072.71 43.64% 11,554.15- 100.05.71.00.5415 MAINTENANCE OF BLDG & GROUNDS 36,700.00 36,700.00 17,132.32 3,062.40 46.68% 19,567.68- 100.05.71.00.5505 COMPUTER CHARGES 41,040.00 41,040.00 24,178.92 694.57 58.92% 16,861.08- 100.05.71.00.5602 TELEPHONE 300.00 300.00 60.00 10.00 20.00% 240.00- 100.05.71.00.5701 OFFICE SUPPLIES AND EXPENSES 8,000.00 8,000.00 5,160.92 292.61 64.51% 2,839.08- 100.05.71.00.5702 PROCESSING SUPPLIES 17,500.00 17,500.00 8,314.77 2,559.87 47.51% 9,185.23- 100.05.71.00.5703 HOUSEKEEPING SUPPLIES 3,800.00 3,800.00 546.69 .00 14.39% 3,253.31- 100.05.71.00.5740 LIBRARY GRANT EXPENSE .00 .00 .00 .00 .00 .00 100.05.71.00.5752 LIBRARY FRIENDS EXPENSE .00 .00 .00 .00 .00 .00 100.05.71.00.5774 LIBRARY REPLACEMENT 1,300.00 1,300.00 177.33 76.19 13.64% 1,122.67- 100.05.71.00.5835 HOUSEKEEPING SERVICES 38,000.00 38,000.00 18,294.00 3,049.00 48.14% 19,706.00- 100.05.71.00.5910 GAS & ELECTRIC 75,000.00 75,000.00 27,613.96 5,741.48 36.82% 47,386.04- 100.05.71.00.5915 SEWER & WATER 2,500.00 2,500.00 980.36 .00 39.21% 1,519.64- 100.05.71.00.6062 PROGRAMMING 6,000.00 6,000.00 6,894.54 936.63 114.91% 894.54 100.05.71.01.5711 PRINT MATERIALS 115,000.00 115,000.00 47,264.27 8,340.28 41.10% 67,735.73- 100.05.71.01.5713 PRINT MATERIALS - ADULT .00 .00 .00 .00 .00 .00 100.05.71.02.5711 AUDIO VISUAL MATERIALS 50,000.00 50,000.00 17,230.91 3,422.25 34.46% 32,769.09- 100.05.71.03.5711 ELECTRONIC MATERIALS 16,000.00 16,000.00 12,474.01 .01 77.96% 3,525.99- 100.05.71.03.5714 AUDIO VISUAL MATERIAL - A.V..00 .00 .00 .00 .00 .00 100.05.71.11.5713 PRINT MATERIALS - JUVENILE .00 .00 .00 .00 .00 .00 100.05.71.12.5714 AUDIO VISUAL MATERIAL - JUVENL .00 .00 .00 .00 .00 .00 100.05.71.14.5713 PRINT MATERIALS - MISC .00 .00 .00 .00 .00 .00 100.05.71.18.5713 PRINT MATERIALS - NEWSPAPER .00 .00 .00 .00 .00 .00 100.05.71.19.5713 PRINT MATERIALS - PERIODICALS .00 .00 .00 .00 .00 .00 100.05.71.23.5713 PRINT MATERIALS - REFERENCE .00 .00 .00 .00 .00 .00 100.05.71.26.5713 PRINT MATERIALS - SERIALS .00 .00 .00 .00 .00 .00 100.05.71.35.5714 AUDIO VISUAL MATRL - DATA BASE .00 .00 .00 .00 .00 .00 100.05.71.36.5713 PRINT MATERIALS - YOUNG ADULT .00 .00 .00 .00 .00 .00 Total LIBRARY DEPARTMENT:1,251,732.00 1,251,732.00 544,155.88 87,817.08 43.47% 707,576.12- Page 9 of 12 Financial Reports Packet Page 13 CITY OF MUSKEGO Budget Worksheet - Library Revenues Current Year w/ Monthly Total Page: 1 Period: 06/18 Jul 05, 2018 10:13AM 2018-18 2018-18 2018-18 2018-18 % Actual Over / Adopted Amended YTD Current month To (Under) Account Number Account Title Budget Budget Actual Actual Budget Budget GENERAL FUND CULTURE, REC AND EDUCATION 100.05.71.00.4140 LIBRARY GRANTS REVENUE .00 .00 .00 .00 .00 .00 100.05.71.00.4150 LIBRARY - SYSTEM, ETC 116,472.00 116,472.00 60,629.30 .00 52.05% 55,842.70- 100.05.71.00.4274 LIBRARY LOST AND DAMAGED 1,300.00 1,300.00 788.62 216.53 60.66% 511.38- 100.05.71.00.4313 LIBRARY FINES 17,000.00 17,000.00 7,640.37 1,460.57 44.94% 9,359.63- 100.05.71.00.4314 LIBRARY TAXABLE REVENUE 9,000.00 9,000.00 4,606.46 769.00 51.18% 4,393.54- 100.05.71.00.4542 LIBRARY PHONE USE .00 .00 .00 .00 .00 .00 100.05.71.00.4544 ROOM RENTAL 1,000.00 1,000.00 468.75 .00 46.88% 531.25- 100.05.71.00.4551 SALE OF F/A - COMPUTERS .00 .00 .00 .00 .00 .00 100.05.71.00.4552 LIBRARY FRIENDS REVENUE .00 .00 3,077.44 396.58 .00 3,077.44 Total LIBRARY DEPARTMENT:144,772.00 144,772.00 77,210.94 2,842.68 53.33% 67,561.06- Page 10 of 12 Financial Reports Packet Page 14 CITY OF MUSKEGO BALANCE SHEET JUNE 30, 2018 FEDERATED LIBRARY SYSTEM FUND ASSETS 503.00.00.00.1001 EQUITY IN POOLED CASH 130,099.57 TOTAL ASSETS 130,099.57 LIABILITIES AND EQUITY FUND EQUITY 503.00.00.00.3510 FUND BALANCE-RESERVED 14,784.97 503.00.00.00.3520 FUND BAL-UNRESERVED UNDESIGNAT 107,712.93 REVENUE OVER EXPENDITURES - YTD 7,801.67 TOTAL FUND EQUITY 130,299.57 TOTAL LIABILITIES AND EQUITY 130,299.57 Page 11 of 12 Financial Reports Packet Page 15 CITY OF MUSKEGO BALANCE SHEET JUNE 30, 2018 LIBRARY EXPANSION TRUST FUND ASSETS 502.00.00.00.1001 EQUITY IN POOLED CASH ( 32,897.00) 502.00.00.00.1011 CASH IN BANK- LIBRARY-1B 12,852.04 502.00.00.00.1105 LIBRARY INVESTMENTS 43,957.21 TOTAL ASSETS 23,912.25 LIABILITIES AND EQUITY FUND EQUITY 502.00.00.00.3501 FUND BALANCE-RESERVED 61,692.95 502.00.00.00.3520 FUND BAL-UNRESERVED UNDESIGNAT ( 38,004.86) REVENUE OVER EXPENDITURES - YTD 224.16 TOTAL FUND EQUITY 23,912.25 TOTAL LIABILITIES AND EQUITY 23,912.25 Page 12 of 12 Financial Reports Packet Page 16 Director’s Report July 17th, 2018 1. Adult Services Update (from Elke Saylor, Head of Reference and Samantha Quail, Adult Services Librarian): After a program-filled June, the adult services staff is in “Dog days of Summer” mode. Our Adult Summer Reading Program is going well with record participation and a wonderful selection of prizes. It is also our turn this month to host the Memory Café and we hope attendants will enjoy the Soap Making activity. 2. Children’s Update (from Abby Bussen, Children’s Librarian): We kicked off our summer reading program on Monday June 4 with an unofficial, one-night-only opportunity to sign up at Jammin’ on Janesville on Friday June 1. It was our first time trying a Jammin’ on Janesville sign up and we were very pleased to have a total of 196 sign ups (168 in kids, 15 in teens, and 13 in adults). Throughout the month of June, we had 1,073 kids sign up for our summer reading program. Last year, not including children registered through Parks & Recreation’s All-Day Playground and other childcare facilities, we had 914 sign ups for the entire summer. Our 2016 total was 675 (without including 228 kids’ registered through childcare providers), so all things considered, we are doing quite well. June was absolutely packed with in-house programming led by children’s staff as well as performers KidsPlay, Chris Fascione, Hoos Woods, Board Game Barrister, JumpBunch, and Mad Science Milwaukee. Staff-led programming included a fabulous ribbon-cutting ceremony, inviting the community into our wonderful new kids’ area, as well as our 3rd annual Intergalactic Tea Party, where patrons ate snacks, made crafts, and mingled with members of the Wisconsin Garrison’s Blood Moon Squad. With the program wrapping in August, we still have tons of programs and performances to enjoy before fall! 3. Young Adult Update (from Amanda Hyland, Young Adult Librarian): During the Month of June, 180 teens signed up for the Summer Reading Program. A program called Technically Involved Thursdays, started up on June 27. This program meets weekly throughout the summer and allows teens to play with several gadgets that the library owns, such as spheroes, ozobots, bloxels, etc. The Library also hosted its first escape room on June 28. Throughout the day, the library “locked” 32 teens in the Library for not paying their library fines, and they had to try Page 1 of 3 July '18 Director's Report Packet Page 17 escaping the “director’s office”. In the end, all the teens escaped the room, had a good time, and said they would do it again. 4. Children’s Area Update: The Children’s Area is in a state that I refer to as “phase 2”. With the major construction work done, it is now time to put up finishing touches. We are watching how patrons use the space in order to put up end panel shelf signage as well as wayfinding signage. We have another window vinyl to order for the second window storefront. The smart board has arrived and will be installed when staff time allows. The amazing flooring in the storytime room has weathered its first sensory storytime, and was very easy to clean, saving precious staff time. We have already had one visit from a neighboring library to take notes on what we have done! 5. Other Updates: a. Dates of Note: July 17th Library Board Meeting with vote on capital and operating budget, August 21st Waukesha County Standards Certification letter. b. Grants: Thanks to a referral from Trustee Gail Miles Konkel, the Library is attempting to receive funding from two grants. The first grant from Microsoft is for a Virtual Reality hardware/software set, which would align with our strategic goals of incorporating STEAM concepts into programming. The second grant is to the Waukesha County Community Foundation for a lactation pod for nursing/pumping mothers. This will be in conjunction with the Friends of the Library. c. WI Trustee Training Week: Bridges and other Wisconsin library systems are sponsoring this annual webcast series, developed and coordinated by South Central Library System, geared toward public library trustees but open to everyone. There will be one online session offered each day during the lunch hour (12-1 pm) with a different topic and speaker. These programs will be archived. More information and registration is available at this link: http://www.wistrusteetraining.com d. Friends of the Library: The 15th Annual Friends of Muskego Library’s Craft Beer and Wine Tasting Event will be held on October 13, 2018. The Friends are hoping each Library Board Trustee will try and sell some tickets to help spread the word for their Library fundraising event. 6. Continuing Education: Elke Saylor attended a professional development opportunity on Intergenerational Programming and one on Expanding and Strengthening Senior Programming. 7. Employee Anniversaries in July: Debbie Mortenson, Library Aide (11 years). Sam Miller, Shelver (3 years). Page 2 of 3 July '18 Director's Report Packet Page 18 JAN FEB MAR APR MAY JUN JUL AUG SEPT OCT NOV DEC TOTAL JUN YTD Checkouts 2017 23,280 22,488 25,479 22,564 21,917 28,959 29,044 25,946 20,266 22,451 20,987 16,966 280,347 144,687 2018 23,110 21,362 23,503 23,882 19,768 31,869 143,494 143,494 % Change -0.7%-5.0%-7.8%5.8%-9.8%10.0%-0.8% eBook Checkouts 2017 1,654 1,453 1,774 1,700 1,568 1,683 1,717 1,729 1,654 1,669 1,507 1,592 19,700 9,832 2018 1,889 1,798 1,997 1,906 1,771 1,869 11,230 11,230 % Change 14.2%23.7%12.6%12.1%12.9%11.1%14.2% Self-Service Transaction Percentage of Total Circ (Self-check, Online Renewals, and eBook Checkouts/Checkouts and eBook Checkouts) 2017 56.4%56.5%57.3%59.4%57.7%51.7%59.1%55.7%60.0%59.1%58.6%66.8%57.1%56.3% 2018 56.9%57.3%60.1%61.3%62.4%57.5%59.1%59.1% Library Visits 2017 10,901 11,146 13,100 10,339 10,600 14,598 13,934 12,585 9,812 10,788 9,897 7,786 135,486 70,684 2018 10,641 11,097 11,784 11,417 9,779 16,604 71,321 71,321 % Change -2.4%-0.4%-10.0%10.4%-7.7%13.7%0.9% Reference Transactions 2017 1,224 1,237 1,425 1,080 1,133 992 1,077 1,206 874 1,064 979 932 13,223 7,091 2018 1,387 1,249 1,407 1,362 1,043 1,196 7,644 7,644 % Change 13.3%1.0%-1.3%26.1%-7.9%20.6%7.8% Meeting Room Use 2017 88 96 99 76 88 69 76 84 79 87 85 68 995 516 2018 101 93 102 95 82 72 545 545 % Change 14.8%-3.1%3.0%25.0%-6.8%4.3%5.6% Monthly Statistics for Muskego Public Library 2018 Page 3 of 3 July '18 Director's Report Packet Page 19 as of 07/11/18 as of 07/11/18 2016 ACTUAL 2017 ACTUAL 2018 BUDGET 2018 JUN YTD 2018 PROJECTED 2019 PROPOSED COMMENTS 100.05.71.00.5101 SALARY & WAGES 563,962 545,449 613,713 275,697 613,713 613,713 100.05.71.00.5102 SALARY & WAGES - OVERTIME - - 2,000 16 2,000 2,000 100.05.71.00.5201 FICA 43,699 42,496 48,484 21,632 48,484 48,484 100.05.71.00.5202 PENSION 34,681 34,633 39,332 17,044 39,332 39,332 100.05.71.00.5203 HEALTH INSURANCE 72,539 56,560 91,083 19,994 91,083 91,083 100.05.71.00.5204 LIFE INSURANCE 1,206 1,287 1,420 627 1,420 1,420 100.05.71.00.5205 FSA FEE EXPENSE - - - - - - 100.05.71.00.5229 HEALTH INSURANCE ALLOWANCE 17,680 20,390 18,060 11,430 18,060 18,060 100.05.71.01.5711 PRINT MATERIALS 116,741 114,494 115,000 47,264 115,000 115,000 100.05.71.02.5711 AUDIO VISUAL MATERIALS 47,660 51,118 50,000 17,231 50,000 50,000 100.05.71.03.5711 ELECTRONIC MATERIALS 15,889 16,247 16,000 12,474 16,000 17,095 Based on Bridges proposed 2019 System Fee Schedule - Libraries funding a greater share of Databases, Flipster, Gale, Advantage Program. 100.05.71.00.5774 LIBRARY REPLACEMENT 637 257 1,300 177 1,300 1,300 100.05.71.00.5415 MAINTENANCE OF BLDG & GROUNDS 38,838 36,406 36,700 17,132 36,700 36,700 100.05.71.00.5602 TELEPHONE 275 225 300 60 300 300 100.05.71.00.5703 HOUSEKEEPING SUPPLIES 3,762 2,819 3,800 547 3,800 3,800 100.05.71.00.5835 HOUSEKEEPING SERVICES 36,588 36,588 38,000 18,294 38,000 38,000 100.05.71.00.5910 GAS & ELECTRIC 68,251 70,823 75,000 27,614 75,000 75,000 100.05.71.00.5915 SEWER & WATER 1,642 1,703 2,500 980 2,500 2,500 100.05.71.00.5302 MILEAGE 654 1,253 1,200 1,252 2,000 2,000 Mileage costs trending upward due to staff participation in conferences and community programs. 100.05.71.00.5303 CONFERENCES & TRAINING 2,868 1,306 3,500 571 3,500 3,500 100.05.71.00.5305 DUES & MEMBERSHIPS 1,034 1,260 1,300 624 1,300 1,300 100.05.71.00.5401 LIBRARY EQUIPMENT 13,509 17,643 20,500 8,946 20,500 19,900 Staff printer savings based on the City's printer maintenance contract with Impact. 100.05.71.00.5505 COMPUTER CHARGES/LIBRARY 30,929 26,936 41,040 24,179 41,040 42,190 Includes data service for hot spots 100.05.71.00.5701 OFFICE SUPPLIES 20,237 7,288 8,000 5,161 8,000 8,000 100.05.71.00.5702 PROCESSING SUPPLIES - 17,360 17,500 8,315 17,500 17,500 100.05.71.00.5740 LIBRARY GRANT EXP 6,825 2,193 - - - 1,556 Grant expense and revenue separated into own account in 2019. 100.05.71.00.5752 LIBRARY FRIENDS EXP 4,936 7,736 - - - 5,000 Friends expense and revenue separated into own account in 2019. 100.05.71.00.6062 PROGRAMMING 4,718 5,771 6,000 6,895 12,592 6,500 Looking to continue to expand and innovate with new ideas. EXPENDITURE TOTAL 1,149,760 1,120,241 1,251,732 544,156 1,259,124 1,261,233 Grant and Friends expense separated into own account in 2019. 100.05.71.00.4140 LIBRARY GRANT REV 6,858 1,592 0 - 1,592 1,556 Bridges Library Improvement & Innovation Grant. Note: Grant expense and revenue separated into own account in 2019. 100.05.71.00.4150 LIBRARY - SYSTEM, ETC 113,836 112,846 116,472 60,629 116,472 117,784 Based on Bridges projected counties' payments. 100.05.71.00.4274 LIBRARY LOST & DAMAGED 1,551 1,941 1,300 789 1,300 1,300 100.05.71.00.4313 LIBRARY FINES 17,610 16,640 17,000 7,640 17,000 17,000 100.05.71.00.4314 LIBRARY TAXABLE REVENUE 9,210 7,908 9,000 4,606 9,000 9,000 100.05.71.00.4544 ROOM RENTAL 2,450 1,050 1,000 469 1,000 1,000 100.05.71.00.4552 LIBRARY FRIENDS REV 4,936 6,945 - 3,077 5,000 5,000 Friends expense and revenue separated into own account in 2019. REVENUE TOTAL 156,452 148,922 144,772 77,211 151,364 152,640 Grant and Friends revenue separated into own account in 2019. NET CITY SUPPORT FOR LIBRARY 993,309 971,319 1,106,960 466,945 1,107,760 1,108,593 Category Summaries SALARIES TOTAL 563,962 545,449 615,713 275,713 615,713 615,713 BENEFITS TOTAL 169,804 155,366 198,379 70,727 198,379 198,379 SALARIES & BENEFITS 733,766 700,815 814,092 346,440 814,092 814,092 MATERIALS TOTAL 180,927 182,116 182,300 77,147 182,300 183,395 BUILDING & UTILITIES TOTAL 149,356 148,564 156,300 64,627 156,300 156,300 MISCELLANEOUS 85,711 88,746 99,040 55,942 106,432 107,446 ------------------------------------------------------------------------------------ TOTAL 1,149,760 1,120,241 1,251,732 544,156 1,259,124 1,261,233 Grant and Friends expense separated into own account in 2019. *Based on 2018 budget. 2019 will be given by HR on 7/28/18. Page 1 of 1 Operating Budget Packet Page 20 LIBRARY - 5 YR PROPOSED CAPITAL PLAN as of 07/11/18 2019-2023 Expenditure Schedule - PROPOSED Project Name Account #TOTAL 2019 2020 2021 2022 2023 Carpeting/Flooring 410.08.90.71.6507 $77,000 $22,000 $23,000 $32,000 $0 $0 Public Furniture 410.08.90.71.6511 $42,000 $10,000 $0 $16,000 $16,000 $0 Library Parking Lot Sealcoating 410.08.90.71.6504 $7,000 $7,000 $0 $0 $0 $0 RFID 410.08.90.71.6514 $90,000 $0 $90,000 $0 $0 $0 Young Adult Area Redesign 410.08.90.71.6513 $30,000 $30,000 $0 $0 $0 $0 Service Desks Redesign 410.08.90.71.6515 $40,000 $0 $25,000 $15,000 $0 $0 Security Cameras $10,500 $10,500 $0 $0 $0 $0 Public Restroom Renovation $30,000 $0 $0 $0 $0 $30,000 $0 $0 TOTAL EXPENDITURES $326,500 $79,500 $138,000 $63,000 $16,000 $30,000 Page 1 of 9 Capital Budget Packet Page 21 2019 Capital Schedule & Worksheets - 07.11.18 CITY OF MUSKEGO 5-YEAR CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No:410.08.90.71.6507 A.PROJECT IDENTIFICATION 1. Project Name:Carpeting/Flooring 2. Department:Library 3. Description:2019: Young Adult Area, Magazine Area, Meeting Rooms 2020: Adult Stacks 2021: Great Room, Media Area, Study Rooms B.EXPENDITURE SCHEDULE Subproj.Expend. category TOTAL 2019 2020 2021 2022 2023 Equipment 0 Vehicle Replacement 0 Stormwater 0 Arch/Engineering 0 Land/ROW/Site Prep 0 Construction 0 Testing 0 Other 77,000 22,000 23,000 32,000 TOTAL 77,000 22,000 23,000 32,000 0 0 C.FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 0 605 Water Working Cap.0 601 Sewer Working Cap.0 401 Trnsfr w/in CPF 0 GO Borrowing 0 Water Borrowing 0 Sewer Borrowing 0 100 Gen Fund Balance 0 Other Fund Fd Bal 0 State Aid 0 210 Landfill Funds 0 202 Park Ded. Funds 0 Forfeiture Funds 0 Stormwater Funds 0 Other Source 0 TOTAL 0 0 0 0 0 0 D.ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 0 5. Net impact 0 0 0 0 0 0 E.DESCRIPTION HISTORY Original Date: Revised Date: Page 2 of 9 Capital Budget Packet Page 22 2019 Capital Schedule & Worksheets - 07.11.18 CITY OF MUSKEGO 5-YEAR CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No:410.08.90.71.6511 A.PROJECT IDENTIFICATION 1. Project Name:Public Furniture 2. Department:Library 3. Description: 2019: 4 soft chairs for Fiction Area, 4 soft chairs for Media Room 2021: Reupholster all public meeting room chairs (188) 2022: Replace furniture in Library Board room. B.EXPENDITURE SCHEDULE Subproj.Expend. category TOTAL 2019 2020 2021 2022 2023 Equipment 42,000 10,000 0 16,000 16,000 Vehicle Replacement 0 Stormwater 0 Arch/Engineering 0 Land/ROW/Site Prep 0 Construction 0 Testing 0 Other 0 TOTAL 42,000 10,000 0 16,000 16,000 0 C.FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 0 605 Water Working Cap.0 601 Sewer Working Cap.0 401 Trnsfr w/in CPF 0 GO Borrowing 0 Water Borrowing 0 Sewer Borrowing 0 100 Gen Fund Balance 0 Other Fund Fd Bal 0 State Aid 0 210 Landfill Funds 0 202 Park Ded. Funds 0 Forfeiture Funds 0 Stormwater Funds 0 Other Source 0 TOTAL 0 0 0 0 0 0 D.ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 0 5. Net impact 0 0 0 0 0 0 E.DESCRIPTION HISTORY Original Date: Revised Date: Page 3 of 9 Capital Budget Packet Page 23 2019 Capital Schedule & Worksheets - 07.11.18 CITY OF MUSKEGO 5-YEAR CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No:410.08.90.71.6504 A.PROJECT IDENTIFICATION 1. Project Name:Library Parking Lot Sealcoating 2. Department:Library 3. Description:The parking lot was last sealcoated in 2010. B.EXPENDITURE SCHEDULE Subproj.Expend. category TOTAL 2019 2020 2021 2022 2023 Equipment 7,000 7,000 Vehicle Replacement 0 Stormwater 0 Arch/Engineering 0 Land/ROW/Site Prep 0 Construction 0 Testing 0 Other 0 TOTAL 7,000 7,000 0 0 0 0 C.FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 0 605 Water Working Cap.0 601 Sewer Working Cap.0 401 Trnsfr w/in CPF 0 GO Borrowing 0 Water Borrowing 0 Sewer Borrowing 0 100 Gen Fund Balance 0 Other Fund Fd Bal 0 State Aid 0 210 Landfill Funds 0 202 Park Ded. Funds 0 Forfeiture Funds 0 Stormwater Funds 0 Other Source 0 TOTAL 0 0 0 0 0 0 D.ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 0 5. Net impact 0 0 0 0 0 0 E.DESCRIPTION HISTORY Original Date: Revised Date: Page 4 of 9 Capital Budget Packet Page 24 2019 Capital Schedule & Worksheets - 07.11.18 CITY OF MUSKEGO 5-YEAR CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No:410.08.90.71.6514 A.PROJECT IDENTIFICATION 1. Project Name:RFID 2. Department:Library 3. Description:Upgrade the Library to a Radio Frequency Identification System. B.EXPENDITURE SCHEDULE Subproj.Expend. category TOTAL 2019 2020 2021 2022 2023 Equipment 90,000 90,000 Vehicle Replacement 0 Stormwater 0 Arch/Engineering 0 Land/ROW/Site Prep 0 Construction 0 Testing 0 Other 0 TOTAL 90,000 0 90,000 0 0 0 C.FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 0 605 Water Working Cap.0 601 Sewer Working Cap.0 401 Trnsfr w/in CPF 0 GO Borrowing 0 Water Borrowing 0 Sewer Borrowing 0 100 Gen Fund Balance 0 Other Fund Fd Bal 0 State Aid 0 210 Landfill Funds 0 202 Park Ded. Funds 0 Forfeiture Funds 0 Stormwater Funds 0 Other Source 0 TOTAL 0 0 0 0 0 0 D.ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 0 5. Net impact 0 0 0 0 0 0 E.DESCRIPTION HISTORY Original Date: Revised Date: Page 5 of 9 Capital Budget Packet Page 25 2019 Capital Schedule & Worksheets - 07.11.18 CITY OF MUSKEGO 5-YEAR CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No:410.08.90.71.6513 A.PROJECT IDENTIFICATION 1. Project Name:Young Adult Area Redesign 2. Department:Library 3. Description:Update the Young Adult Area with functional spaces to accommodate individual and group use. B.EXPENDITURE SCHEDULE Subproj.Expend. category TOTAL 2019 2020 2021 2022 2023 Equipment 30,000 30,000 0 Vehicle Replacement 0 Stormwater 0 Arch/Engineering 0 Land/ROW/Site Prep 0 Construction 0 Testing 0 Other 0 TOTAL 30,000 30,000 0 0 0 0 C.FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 0 605 Water Working Cap.0 601 Sewer Working Cap.0 401 Trnsfr w/in CPF 0 GO Borrowing 0 Water Borrowing 0 Sewer Borrowing 0 100 Gen Fund Balance 0 Other Fund Fd Bal 0 State Aid 0 210 Landfill Funds 0 202 Park Ded. Funds 0 Forfeiture Funds 0 Stormwater Funds 0 Other Source 0 TOTAL 0 0 0 0 0 0 D.ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 0 5. Net impact 0 0 0 0 0 0 E.DESCRIPTION HISTORY Original Date: Revised Date: Page 6 of 9 Capital Budget Packet Page 26 2019 Capital Schedule & Worksheets - 07.11.18 CITY OF MUSKEGO 5-YEAR CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No:410.08.90.71.6515 A.PROJECT IDENTIFICATION 1. Project Name:Service Desks Redesign 2. Department:Library 3. Description:2020: Redesign Circulation Desk Area 2021: Redesign Reference Desk B.EXPENDITURE SCHEDULE Subproj.Expend. category TOTAL 2019 2020 2021 2022 2023 Equipment 40,000 25,000 15,000 Vehicle Replacement 0 Stormwater 0 Arch/Engineering 0 Land/ROW/Site Prep 0 Construction 0 Testing 0 Other 0 TOTAL 40,000 0 25,000 15,000 0 0 C.FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 0 605 Water Working Cap.0 601 Sewer Working Cap.0 401 Trnsfr w/in CPF 0 GO Borrowing 0 Water Borrowing 0 Sewer Borrowing 0 100 Gen Fund Balance 0 Other Fund Fd Bal 0 State Aid 0 210 Landfill Funds 0 202 Park Ded. Funds 0 Forfeiture Funds 0 Stormwater Funds 0 Other Source 0 TOTAL 0 0 0 0 0 0 D.ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 0 5. Net impact 0 0 0 0 0 0 E.DESCRIPTION HISTORY Original Date: Revised Date: Page 7 of 9 Capital Budget Packet Page 27 2019 Capital Schedule & Worksheets - 07.11.18 CITY OF MUSKEGO 5-YEAR CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A.PROJECT IDENTIFICATION 1. Project Name:Security Cameras 2. Department:Library 3. Description:Appx 7 cameras to cover the front doors, meeting room hallway side doors, circulation desk B.EXPENDITURE SCHEDULE Subproj.Expend. category TOTAL 2019 2020 2021 2022 2023 Equipment 10,500 10,500 0 Vehicle Replacement 0 Stormwater 0 Arch/Engineering 0 Land/ROW/Site Prep 0 Construction 0 Testing 0 Other 0 TOTAL 10,500 10,500 0 0 0 0 C.FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 0 605 Water Working Cap.0 601 Sewer Working Cap.0 401 Trnsfr w/in CPF 0 GO Borrowing 0 Water Borrowing 0 Sewer Borrowing 0 100 Gen Fund Balance 0 Other Fund Fd Bal 0 State Aid 0 210 Landfill Funds 0 202 Park Ded. Funds 0 Forfeiture Funds 0 Stormwater Funds 0 Other Source 0 TOTAL 0 0 0 0 0 0 D.ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 0 5. Net impact 0 0 0 0 0 0 E.DESCRIPTION HISTORY Original Date: Revised Date: Page 8 of 9 Capital Budget Packet Page 28 2019 Capital Schedule & Worksheets - 07.11.18 CITY OF MUSKEGO 5-YEAR CAPITAL IMPROVEMENTS PROGRAM DETAILED PROJECT DESCRIPTION Project No: Account No: A.PROJECT IDENTIFICATION 1. Project Name:Public Restroom Renovation 2. Department:Library 3. Description:Renovate the men's, women's and family restroom. B.EXPENDITURE SCHEDULE Subproj.Expend. category TOTAL 2019 2020 2021 2022 2023 Equipment 30,000 30,000 Vehicle Replacement 0 Stormwater 0 Arch/Engineering 0 Land/ROW/Site Prep 0 Construction 0 Testing 0 Other 0 TOTAL 30,000 0 0 0 0 30,000 C.FUNDING SOURCE(S) Fund Revenue category 100 Gen Fd Op Budget 0 605 Water Working Cap.0 601 Sewer Working Cap.0 401 Trnsfr w/in CPF 0 GO Borrowing 0 Water Borrowing 0 Sewer Borrowing 0 100 Gen Fund Balance 0 Other Fund Fd Bal 0 State Aid 0 210 Landfill Funds 0 202 Park Ded. Funds 0 Forfeiture Funds 0 Stormwater Funds 0 Other Source 0 TOTAL 0 0 0 0 0 0 D.ANNUAL OPERATING IMPACT (if any) 1. Personnel 0 2. Materials 0 3. Total Cost 0 4. Offsetting Rev or Savings 0 5. Net impact 0 0 0 0 0 0 E.DESCRIPTION HISTORY Original Date: Revised Date: Page 9 of 9 Capital Budget Packet Page 29