Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
LIBRARY BOARD Packet - 4/21/2020
CITY OF MUSKEGO LIBRARY BOARD AGENDA 04/21/2020 5:00 PM Virtual via Zoom, S73 W16663 Janesville Road CALL TO ORDER PLEDGE OF ALLEGIANCE ROLL CALL STATEMENT OF PUBLIC NOTICE PUBLIC COMMENT CONSENT AGENDA 1 Approval of minutes February 18, 2020 Minutes 2 Place on file the Library Financial Reports February 2020 Financial Reports March 2020 Financial Reports PRESIDENT’S REPORT Information DIRECTOR’S REPORT Information April 2020 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: Discussion: COVID-19 Response Discussion/Action: Allowable Costs Worksheet 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 02/18/2020 5:00 PM Library Conference Room, S73 W16663 Janesville Road CALL TO ORDER President Robertson called the meeting to order at 5:06 PM. PLEDGE OF ALLEGIANCE ROLL CALL Present were Trustees Blair, Konkel, Heinowski, Humphreys, Alderman Wolfe, President Robertson and Director Larson. Trustees Darkow, Jung and Schroeder were excused. Trustee Blair left at 5:29 PM. STATEMENT OF PUBLIC NOTICE PUBLIC COMMENT CONSENT AGENDA Trustee Blair made a motion to approve the CONSENT AGENDA, Trustee Humphreys seconded. Motion Passed 5 in favor. 1 Approval of minutes December 17, 2019 Minutes January 21, 2020 Minutes 2 Place on file the Library Financial Reports December 2019 Financial Reports January 2020 Financial Reports PRESIDENT’S REPORT Information DIRECTOR’S REPORT Information 1 February 2020 Director's Report Page 1 of 2 February 18, 2020 Minutes Packet Page 3 UNFINISHED BUSINESS Discussion update and possible action may be taken on any or all of the following: 1 Discussion/Action: Library Board Policy Review: Library Meeting Rooms, Computer and Internet Use, and Materials for Posting Trustee Konkel made a motion to approve the updates to the Library Meeting Rooms, Computer and Internet Use, and Materials for Posting policies, Trustee Blair seconded. Motion Passed 5 in favor. 2 Dicussion: RFID Technology Analysis Report NEW BUSINESS Discussion update and possible action may be taken on any or all of the following: 1 Discussion/Action: Approval of 2019 Muskego Public Library State Annual Report Trustee Humphreys made a motion to approve the 2019 Muskego Public Library State Annual Report, Trustee Konkel seconded. Motion Passed 4 in favor. COMMUNICATIONS AND MISCELLANEOUS BUSINESS AS AUTHORIZED BY LAW ADJOURNMENT Trustee Konkel made a motion to adjourn, Trustee Humphreys seconded. Motion Passed 4 in favor. Meeting adjourned at 6:13 PM 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. Page 2 of 2 February 18, 2020 Minutes Packet Page 4 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 1 Report dates: 2/1/2020-2/29/2020 Mar 02, 2020 03:04PM 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 AMAZON CAPITAL SERVICES 13H3-9QCQ-K 1 Invoice 2 POWER STRIPS 01/19/2020 02/11/2020 9.77 220 100.05.71.00.5701 13H3-9QCQ-K 2 Invoice PRINT 01/19/2020 02/11/2020 23.98 220 100.05.71.01.5711 197F-NPK3-GF 1 Invoice PRINT 01/27/2020 02/11/2020 305.39 220 100.05.71.01.5711 19FG-LHX3-1D 1 Invoice REPLACEMENT 01/15/2020 02/11/2020 98.55 220 100.05.71.00.5774 1N3J-D6JC-CG 1 Invoice 1 CORDLESS PHONE- LIBRARY 01/23/2020 02/11/2020 223.75 220 100.05.71.00.5505 1Q9Q-3TRT-4 1 Invoice TAPE, LABEL PEELERS, POSTCA 01/15/2020 02/11/2020 60.23 220 100.05.71.00.5701 1Q9Q-3TRT-4 2 Invoice KIDS PROGRAMMING PRIZES 01/15/2020 02/11/2020 16.99 220 100.05.71.00.6062 Total AMAZON CAPITAL SERVICES:738.66 BAKER & TAYLOR COMPANY 0003195933 1 Invoice PRINT CREDIT 01/07/2020 02/11/2020 7.02- 1219 100.05.71.01.5711 2035055278 1 Invoice PRINT 01/16/2020 02/11/2020 1,118.82 220 100.05.71.02.5711 2035063692 1 Invoice PRINT 01/21/2020 02/11/2020 313.62 220 100.05.71.01.5711 2035065794 1 Invoice AV 01/22/2020 02/11/2020 14.85 220 100.05.71.02.5711 2035065794 2 Invoice PRINT 01/22/2020 02/11/2020 2,392.71 220 100.05.71.01.5711 2035079224 1 Invoice PRINT 01/28/2020 02/25/2020 347.85 220 100.05.71.01.5711 2035080296 1 Invoice PRINT 01/29/2020 02/25/2020 143.55 220 100.05.71.01.5711 2035089850 1 Invoice PRINT 02/03/2020 02/25/2020 1,058.02 220 100.05.71.01.5711 2035091719 1 Invoice PRINT 02/04/2020 02/25/2020 1,264.71 220 100.05.71.01.5711 2035099162 1 Invoice PRINT 02/07/2020 02/25/2020 574.06 220 100.05.71.01.5711 2035101219 1 Invoice PRINT 02/10/2020 02/25/2020 1,258.72 220 100.05.71.01.5711 5015991897 1 Invoice PRINT 01/29/2020 02/25/2020 42.45 220 100.05.71.01.5711 Total BAKER & TAYLOR COMPANY:8,522.34 BAKER & TAYLOR ENTERTAINMENT H43389140 1 Invoice AV 01/21/2020 02/11/2020 138.86 220 100.05.71.02.5711 H43423090 1 Invoice AV 01/21/2020 02/11/2020 11.88 220 100.05.71.02.5711 H43423190 1 Invoice AV 01/21/2020 02/11/2020 64.01 220 100.05.71.02.5711 H43426620 1 Invoice AV 01/21/2020 02/11/2020 10.79 220 100.05.71.02.5711 H43434300 1 Invoice AV 01/21/2020 02/11/2020 139.29 220 100.05.71.02.5711 H43624030 1 Invoice AV 01/28/2020 02/25/2020 56.13 220 100.05.71.02.5711 H43624031 1 Invoice AV 01/28/2020 02/25/2020 159.77 220 100.05.71.02.5711 H43647210 1 Invoice AV 01/28/2020 02/25/2020 188.43 220 100.05.71.02.5711 H43694600 1 Invoice AV 01/30/2020 02/25/2020 11.88 220 100.05.71.02.5711 H43751290 1 Invoice AV 02/03/2020 02/25/2020 32.39 220 100.05.71.02.5711 H43751291 1 Invoice AV 02/03/2020 02/25/2020 28.79 220 100.05.71.02.5711 H43825860 1 Invoice AV 02/04/2020 02/25/2020 92.12 220 100.05.71.02.5711 H43897520 1 Invoice AV 02/06/2020 02/25/2020 11.03 220 100.05.71.02.5711 Total BAKER & TAYLOR ENTERTAINMENT:945.37 BRODART CO. 549332 1 Invoice ACRYLIC LITERATURE DISPLAY 01/27/2020 02/11/2020 84.33 220 100.05.71.00.5701 Total BRODART CO.:84.33 Page 1 of 8 February 2020 Financial Reports Packet Page 5 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 2 Report dates: 2/1/2020-2/29/2020 Mar 02, 2020 03:04PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number CARDMEMBER SERVICE (ELAN) 3469/021120 1 Invoice BRITTANY - WLA CONF REGISTR 01/27/2020 02/11/2020 25.00 220 100.05.71.00.5303 3871/021120 1 Invoice MEETING ROOM TECH 01/27/2020 02/11/2020 105.00 1219 100.05.71.00.5505 3871/021120 2 Invoice ELKE WLA MEMBERSHIP THRU 3/ 01/27/2020 02/11/2020 156.00 220 100.05.71.00.5305 3905/021120 1 Invoice TEEN EXAM SNACKS PROGRAMM 01/27/2020 02/11/2020 104.86 220 100.05.71.00.6062 3905/021120 2 Invoice TEEN FOL 01/27/2020 02/11/2020 11.74 220 100.05.71.00.5752 3913/021120 1 Invoice KIDS AREA CHALKBOARD SUPPL 01/27/2020 02/11/2020 23.14 220 100.05.71.00.5701 3913/021120 2 Invoice KIDS FOL 01/27/2020 02/11/2020 117.60 220 100.05.71.00.5752 4273/021120 2 Invoice SNAP IN CFL LAMPHOLDER 01/27/2020 02/11/2020 431.20 220 100.05.71.00.5415 Total CARDMEMBER SERVICE (ELAN):974.54 COMPLETE OFFICE OF WIS 583922 1 Invoice MISC PAPER PRODUCTS - LIBRA 02/14/2020 02/25/2020 211.88 220 100.05.71.00.5703 Total COMPLETE OFFICE OF WIS:211.88 DEMCO EDUCATIONAL CORP 6761193 1 Invoice 20 7+ SECURITY DVD CASES 01/29/2020 02/11/2020 127.93 220 100.05.71.00.5702 Total DEMCO EDUCATIONAL CORP:127.93 ELLIOTT'S ACE HARDWARE 601005/022520 3 Invoice LIBRARY MAINT 01/31/2020 02/25/2020 25.00 220 100.05.71.00.5415 Total ELLIOTT'S ACE HARDWARE:25.00 FINDAWAY WORLD LLC 311707 1 Invoice AV 01/22/2020 02/11/2020 363.94 220 100.05.71.02.5711 Total FINDAWAY WORLD LLC:363.94 HEARTLAND BUSINESS SYSTEMS 358369-H 1 Invoice LIB. VEEAM ANNUAL 01/31/2020 02/25/2020 662.00 220 100.05.71.00.5505 Total HEARTLAND BUSINESS SYSTEMS:662.00 IMPACT ACQUISTIONS LLC 1626489 1 Invoice PUBLIC PRINTER12/1/19-2/29/20B 12/02/2019 02/11/2020 349.84 1219 100.05.71.00.5401 1669874 1 Invoice PAPERCUT RENEWAL-PUBLIC PR 01/16/2020 02/11/2020 630.19 220 100.05.71.00.5505 Total IMPACT ACQUISTIONS LLC:980.03 JANI-KING INC- MILW REGION MIL03200141 3 Invoice CLEANING - LIBRARY MARCH 03/01/2020 03/10/2020 3,125.00 320 100.05.71.00.5835 Total JANI-KING INC- MILW REGION:3,125.00 KUJAWA ENTERPRISES INC. 130770 1 Invoice FEB20 - INTERIOR PLANT MAINT 02/03/2020 02/25/2020 61.00 220 100.05.71.00.5415 Total KUJAWA ENTERPRISES INC.:61.00 MICROMARKETING LLC 801326 1 Invoice AV 01/23/2020 02/25/2020 26.25 220 100.05.71.02.5711 802065 1 Invoice AV 01/30/2020 02/25/2020 187.25 220 100.05.71.02.5711 Page 2 of 8 February 2020 Financial Reports Packet Page 6 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 3 Report dates: 2/1/2020-2/29/2020 Mar 02, 2020 03:04PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total MICROMARKETING LLC:213.50 MIDWEST TAPE 98516916 1 Invoice AV 01/24/2020 02/11/2020 151.96 220 100.05.71.02.5711 98565837 1 Invoice AV 02/04/2020 02/25/2020 74.98 220 100.05.71.02.5711 Total MIDWEST TAPE:226.94 MUSKEGO PUBLIC LIBRARY MU021120-LIB 1 Invoice KIDS PROGRAMMING 10/16/2019 02/11/2020 9.88 1219 100.05.71.00.6062 MU021120-LIB 2 Invoice DISTILLED WATER FOR DISK CLE 10/16/2019 02/11/2020 8.69 1219 100.05.71.00.5702 Total MUSKEGO PUBLIC LIBRARY:18.57 SAFEWAY PEST MANAGEMENT INC. 627294 1 Invoice JAN '20 PEST MAINTENANCE 01/20/2020 02/11/2020 35.00 220 100.05.71.00.5415 Total SAFEWAY PEST MANAGEMENT INC.:35.00 TIME WARNER CABLE 063003301/022 1 Invoice 01/29/20-02/28/20 BUSINESS INTE 01/30/2020 02/25/2020 99.98 220 100.05.71.00.5505 Total TIME WARNER CABLE:99.98 U.S. CELLULAR 0354712489 6 Invoice MONTHLY CHARGE-LIBRARY 01/28/2020 02/25/2020 20.00 220 100.05.71.00.5602 Total U.S. CELLULAR:20.00 USA FIRE PROTECTION 1046-F024843 1 Invoice NOV19 QUARTERLY DRY SPRINK 12/19/2019 02/25/2020 180.00 1219 100.05.71.00.5415 Total USA FIRE PROTECTION:180.00 WAUKESHA COUNTY TREASURER 2020-0000000 1 Invoice FOL - BOOKPAGES 2020 SUBSCRI 01/14/2020 02/25/2020 243.00 220 100.05.71.00.5752 2020-0000002 1 Invoice 1000 CAFE CARDS 01/15/2020 02/11/2020 158.00 220 100.05.71.00.5701 2020-0000005 1 Invoice FOL -MOVIE LICENSES 2020 01/17/2020 02/25/2020 508.00 220 100.05.71.00.5752 2020-0000007 1 Invoice 2020 SHARED DATABASE 01/17/2020 02/11/2020 2,721.00 220 100.05.71.03.5711 2020-0000010 1 Invoice 2020 FLIPSTER EMAGAZINE 01/20/2020 02/11/2020 1,955.00 220 100.05.71.03.5711 2020-0000012 1 Invoice 2020 ADVANTAGE PROGRAM 01/20/2020 02/11/2020 3,502.00 220 100.05.71.03.5711 2020-0000015 1 Invoice 2020 GALE COURSES 01/20/2020 02/11/2020 2,856.00 220 100.05.71.03.5711 2020-0000017 1 Invoice 2020 CAFE ANNUAL SUPPORT 01/20/2020 02/11/2020 19,857.00 220 100.05.71.00.5505 2020-0000019 1 Invoice 3 CASES BPA/BPS CIRC PAPER 01/22/2020 02/11/2020 168.00 220 100.05.71.00.5701 Total WAUKESHA COUNTY TREASURER:31,968.00 WE ENERGIES 5499-564-961/ 3 Invoice LIBRARY 02/03/2020 02/25/2020 5,613.59 220 100.05.71.00.5910 Total WE ENERGIES:5,613.59 Grand Totals: 55,197.60 Page 3 of 8 February 2020 Financial Reports Packet Page 7 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 4 Report dates: 2/1/2020-2/29/2020 Mar 02, 2020 03:04PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number 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 8 February 2020 Financial Reports Packet Page 8 CITY OF MUSKEGO Budget Worksheet - Library Revenues Current Year w/ Monthly Total Page: 1 Period: 02/20 Mar 02, 2020 03:30PM 2020-20 2020-20 2020-20 2020-20 % 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 1,556.00 1,556.00 .00 .00 .00 1,556.00- 100.05.71.00.4150 LIBRARY - SYSTEM, ETC 117,784.00 117,784.00 156.00 156.00 .13% 117,628.00- 100.05.71.00.4274 LIBRARY LOST AND DAMAGED 1,300.00 1,300.00 274.37 80.25 21.11% 1,025.63- 100.05.71.00.4313 LIBRARY FINES 17,000.00 17,000.00 2,282.94 1,288.90 13.43% 14,717.06- 100.05.71.00.4314 LIBRARY TAXABLE REVENUE 9,000.00 9,000.00 1,750.00 775.00 19.44% 7,250.00- 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 350.00 150.00 35.00% 650.00- 100.05.71.00.4551 SALE OF F/A - COMPUTERS .00 .00 .00 .00 .00 .00 100.05.71.00.4552 LIBRARY FRIENDS REVENUE 5,000.00 5,000.00 883.89 707.56 17.68% 4,116.11- Total LIBRARY DEPARTMENT:152,640.00 152,640.00 5,697.20 3,157.71 3.73% 146,942.80- Page 5 of 8 February 2020 Financial Reports Packet Page 9 CITY OF MUSKEGO Budget Worksheet - Library Expenditures Current Year w/ Monthly Total Page: 1 Period: 02/20 Mar 06, 2020 03:27PM 2020-20 2020-20 2020-20 2020-20 % 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 663,692.43 663,692.43 83,356.67 50,486.33 12.56% 580,335.76- 100.05.71.00.5102 OVERTIME 2,000.00 2,000.00 .00 .00 .00 2,000.00- 100.05.71.00.5201 FICA 52,394.27 52,394.27 6,361.24 3,854.42 12.14% 46,033.03- 100.05.71.00.5202 PENSION 39,635.32 39,635.32 4,962.47 3,005.94 12.52% 34,672.85- 100.05.71.00.5203 HEALTH 108,019.98 108,019.98 17,528.14 8,764.07 16.23% 90,491.84- 100.05.71.00.5204 LIFE 1,219.82 1,219.82 185.20 92.60 15.18% 1,034.62- 100.05.71.00.5205 FSA FEE EXPENSE .00 .00 .00 .00 .00 .00 100.05.71.00.5229 HEALTH INSURANCE ALLOWANCE 19,200.00 19,200.00 3,200.00 1,600.00 16.67% 16,000.00- 100.05.71.00.5302 MILEAGE 2,000.00 2,000.00 163.68 109.50 8.18% 1,836.32- 100.05.71.00.5303 CONFERENCES & TRAINING 3,500.00 3,500.00 25.00 25.00 .71% 3,475.00- 100.05.71.00.5305 DUES & MEMBERSHIP 1,300.00 1,300.00 156.00 156.00 12.00% 1,144.00- 100.05.71.00.5401 LIBRARY EQUIPMENT 19,900.00 19,900.00 1,401.09 .00 7.04% 18,498.91- 100.05.71.00.5415 MAINTENANCE OF BLDG & GROUNDS 36,700.00 36,700.00 1,898.20 1,837.20 5.17% 34,801.80- 100.05.71.00.5505 COMPUTER CHARGES 40,325.00 40,325.00 21,672.90 21,472.92 53.75% 18,652.10- 100.05.71.00.5602 TELEPHONE 720.00 720.00 20.00 20.00 2.78% 700.00- 100.05.71.00.5701 OFFICE SUPPLIES AND EXPENSES 8,000.00 8,000.00 557.45 503.47 6.97% 7,442.55- 100.05.71.00.5702 PROCESSING SUPPLIES 17,500.00 17,500.00 127.93 127.93 .73% 17,372.07- 100.05.71.00.5703 HOUSEKEEPING SUPPLIES 3,800.00 3,800.00 211.88 211.88 5.58% 3,588.12- 100.05.71.00.5740 LIBRARY GRANT EXPENSE 1,556.00 1,556.00 .00 .00 .00 1,556.00- 100.05.71.00.5752 LIBRARY FRIENDS EXPENSE 5,000.00 5,000.00 1,455.39 880.34 29.11% 3,544.61- 100.05.71.00.5774 LIBRARY REPLACEMENT 1,300.00 1,300.00 98.55 98.55 7.58% 1,201.45- 100.05.71.00.5835 HOUSEKEEPING SERVICES 38,000.00 38,000.00 6,250.00 3,125.00 16.45% 31,750.00- 100.05.71.00.5910 GAS & ELECTRIC 75,000.00 75,000.00 5,613.59 5,613.59 7.48% 69,386.41- 100.05.71.00.5915 SEWER & WATER 2,500.00 2,500.00 .00 .00 .00 2,500.00- 100.05.71.00.6062 PROGRAMMING 7,000.00 7,000.00 521.85 121.85 7.46% 6,478.15- 100.05.71.01.5711 PRINT MATERIALS 115,000.00 115,000.00 11,073.51 7,725.06 9.63% 103,926.49- 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 3,511.33 2,883.42 7.02% 46,488.67- 100.05.71.03.5711 ELECTRONIC MATERIALS 18,375.00 18,375.00 11,034.00 11,034.00 60.05% 7,341.00- 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,333,637.82 1,333,637.82 181,386.07 123,749.07 13.60% 1,152,251.75 Page 6 of 8 February 2020 Financial Reports Packet Page 10 CITY OF MUSKEGO BALANCE SHEET FEBRUARY 29, 2020 FEDERATED LIBRARY SYSTEM FUND ASSETS 503.00.00.00.1001 EQUITY IN POOLED CASH 36,035.60 TOTAL ASSETS 36,035.60 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 21,250.63 REVENUE OVER EXPENDITURES - YTD 1,000.00 TOTAL FUND EQUITY 37,035.60 TOTAL LIABILITIES AND EQUITY 37,035.60 Page 7 of 8 February 2020 Financial Reports Packet Page 11 CITY OF MUSKEGO BALANCE SHEET FEBRUARY 29, 2020 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,932.19 502.00.00.00.1105 LIBRARY INVESTMENTS 45,573.99 TOTAL ASSETS 25,609.18 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 ( 36,083.77) TOTAL FUND EQUITY 25,609.18 TOTAL LIABILITIES AND EQUITY 25,609.18 Page 8 of 8 February 2020 Financial Reports Packet Page 12 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 1 Report dates: 3/1/2020-3/31/2020 Apr 01, 2020 02:39PM 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 AMAZON CAPITAL SERVICES 11HK-KTLV-3Q 1 Invoice 6PK TOTES & STICKERS 02/05/2020 03/10/2020 63.12 320 100.05.71.00.5701 17MF-D4VG-1 1 Invoice CRAFTERNOON 02/23/2020 04/14/2020 128.83 420 100.05.71.00.6062 17MF-D4VG-3 1 Invoice AV 02/23/2020 04/14/2020 43.96 420 100.05.71.02.5711 17QQ-RTMW-9 1 Invoice PRINT 03/09/2020 04/14/2020 49.77 420 100.05.71.01.5711 19DW-ZXFG-H 1 Invoice AV 01/31/2020 03/10/2020 52.74 320 100.05.71.02.5711 1DXP-1DFH-J6 1 Invoice PRINT 02/12/2020 03/10/2020 112.37 320 100.05.71.01.5711 1HC4-779K-1H 1 Invoice AV 03/08/2020 04/14/2020 84.85 420 100.05.71.02.5711 1J33-VXG4-4X 1 Invoice CAMERA MICROPHONE, TRIPOD, 03/16/2020 04/14/2020 95.98 420 100.05.71.00.5401 1JVH-KGDW-H 1 Invoice SUPPLIES 02/20/2020 03/10/2020 266.08 320 100.05.71.00.5701 1LV4-YGWG-7 1 Invoice FOL - KIDS 03/09/2020 04/14/2020 61.99 420 100.05.71.00.5752 1N3M-YCWN- 1 Invoice AV 02/23/2020 04/14/2020 121.71 420 100.05.71.02.5711 1NHN-DQRY-9 1 Invoice AV 02/03/2020 03/10/2020 130.71 320 100.05.71.02.5711 1PLV-MJN4-43 1 Invoice PRINT 02/24/2020 04/14/2020 517.96 420 100.05.71.01.5711 1RWN-HP6L-9 1 Invoice ELECTRONIC MATERIALS 02/10/2020 03/10/2020 143.68 320 100.05.71.03.5711 1TLP-GVXF-X 1 Invoice AV 01/29/2020 03/10/2020 160.19 320 100.05.71.02.5711 1V1V-XVFT-4F 1 Invoice CARDSTOCK 02/20/2020 04/14/2020 31.99 420 100.05.71.00.5701 Total AMAZON CAPITAL SERVICES:2,065.93 AMS ALARM, LLC T40836-0220 1 Invoice FIRE ALARM MONITORING 2/20-1/ 03/03/2020 03/24/2020 612.00 320 100.05.71.00.5415 Total AMS ALARM, LLC:612.00 BAKER & TAYLOR COMPANY 2035105389 1 Invoice PRINT 02/11/2020 03/10/2020 350.32 320 100.05.71.01.5711 2035112071 1 Invoice PRINT 02/13/2020 03/10/2020 289.59 320 100.05.71.01.5711 2035121085 1 Invoice PRINT 02/18/2020 03/10/2020 183.42 320 100.05.71.01.5711 2035121381 1 Invoice PRINT 02/18/2020 03/10/2020 1,966.10 320 100.05.71.01.5711 2035131707 1 Invoice PRINT 02/24/2020 03/24/2020 357.91 320 100.05.71.01.5711 2035138558 2 Invoice PRINT 02/25/2020 03/24/2020 158.08 320 100.05.71.01.5711 2035138558 1 Invoice REPLACEMENT 02/25/2020 03/24/2020 22.95 320 100.05.71.00.5774 2035149415 1 Invoice PRINT 03/02/2020 03/24/2020 1,474.90 320 100.05.71.01.5711 2035151021 1 Invoice PRINT 03/03/2020 03/24/2020 1,673.30 320 100.05.71.01.5711 2035156691 2 Invoice PRINT 03/05/2020 03/24/2020 294.98 320 100.05.71.01.5711 2035156691 1 Invoice HUNTING - FISHING BOOKS PURC 03/05/2020 03/24/2020 48.05 320 503.05.00.00.6007 2035161575 1 Invoice PRINT 03/07/2020 03/24/2020 312.58 320 100.05.71.01.5711 2035166621 1 Invoice PRINT 03/10/2020 03/24/2020 2,411.04 320 100.05.71.01.5711 2035169109 1 Invoice PRINT 03/11/2020 03/24/2020 1,041.31 320 100.05.71.01.5711 2035171480 1 Invoice PRINT 03/12/2020 03/24/2020 269.94 320 100.05.71.01.5711 2035173697 1 Invoice PRINT 03/13/2020 04/14/2020 433.42 420 100.05.71.01.5711 2035173697 2 Invoice DONATION: SURE FIRE WHITETAI 03/13/2020 04/14/2020 12.74 420 503.05.00.00.6007 5016023444 1 Invoice PRINT 02/12/2020 03/10/2020 56.67 320 100.05.71.01.5711 5016038807 1 Invoice PRINT 02/19/2020 03/24/2020 61.79 320 100.05.71.01.5711 5016054749 1 Invoice PRINT 02/26/2020 03/24/2020 46.10 320 100.05.71.01.5711 5016070659 1 Invoice PRINT 03/04/2020 03/24/2020 88.11 320 100.05.71.01.5711 5016086268 1 Invoice PRINT 03/11/2020 03/24/2020 84.69 320 100.05.71.01.5711 Page 1 of 9 March 2020 Financial Reports Packet Page 13 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 2 Report dates: 3/1/2020-3/31/2020 Apr 01, 2020 02:39PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total BAKER & TAYLOR COMPANY:11,637.99 BAKER & TAYLOR ENTERTAINMENT H44050650 1 Invoice AV 02/12/2020 03/10/2020 129.15 320 100.05.71.02.5711 H44050660 1 Invoice AV 02/12/2020 03/10/2020 167.03 320 100.05.71.02.5711 H44061930 1 Invoice AV 02/12/2020 03/10/2020 604.45 320 100.05.71.02.5711 H44078490 1 Invoice AV 02/13/2020 03/10/2020 33.10 320 100.05.71.02.5711 H44086930 1 Invoice AV 02/13/2020 03/10/2020 14.36 320 100.05.71.02.5711 H44103130 1 Invoice AV 02/14/2020 03/10/2020 14.39 320 100.05.71.02.5711 H44104300 1 Invoice AV 02/14/2020 03/10/2020 17.99 320 100.05.71.02.5711 H44108810 1 Invoice AV 02/14/2020 03/10/2020 10.18 320 100.05.71.02.5711 H44138580 1 Invoice AV 02/17/2020 03/10/2020 10.79 320 100.05.71.02.5711 H44151260 1 Invoice AV 02/17/2020 03/10/2020 13.67 320 100.05.71.02.5711 H44164260 1 Invoice AV 02/18/2020 03/10/2020 10.18 320 100.05.71.02.5711 H44164261 1 Invoice AV 02/18/2020 03/10/2020 115.03 320 100.05.71.02.5711 H44164262 1 Invoice AV 02/18/2020 03/10/2020 21.26 320 100.05.71.02.5711 H44207720 1 Invoice AV 02/19/2020 03/24/2020 14.39 320 100.05.71.02.5711 H44241230 1 Invoice AV 02/20/2020 03/24/2020 12.22 320 100.05.71.02.5711 H44241580 1 Invoice AV 02/20/2020 03/24/2020 17.27 320 100.05.71.02.5711 H44255410 1 Invoice AV 02/21/2020 03/24/2020 10.79 320 100.05.71.02.5711 H44277240 1 Invoice AV 02/22/2020 03/24/2020 12.73 320 100.05.71.02.5711 H44318850 1 Invoice AV 02/25/2020 03/24/2020 39.58 320 100.05.71.02.5711 H44318851 1 Invoice AV 02/25/2020 03/24/2020 16.55 320 100.05.71.02.5711 H44318852 1 Invoice AV 02/25/2020 03/24/2020 16.55 320 100.05.71.02.5711 H44399630 1 Invoice AV 02/28/2020 03/24/2020 25.19 320 100.05.71.02.5711 H44478920 1 Invoice AV 03/03/2020 03/24/2020 143.82 320 100.05.71.02.5711 H44478921 1 Invoice AV 03/03/2020 03/24/2020 43.18 320 100.05.71.02.5711 H44488470 1 Invoice AV 03/03/2020 03/24/2020 11.03 320 100.05.71.02.5711 H44501770 1 Invoice AV 03/03/2020 03/24/2020 584.44 320 100.05.71.02.5711 H44519800 1 Invoice AV 03/04/2020 03/24/2020 14.03 320 100.05.71.02.5711 H44615510 1 Invoice AV 03/10/2020 04/14/2020 22.31 420 100.05.71.02.5711 H44615511 1 Invoice AV 03/10/2020 04/14/2020 80.60 420 100.05.71.02.5711 H44627480 1 Invoice AV 03/11/2020 04/14/2020 20.39 420 100.05.71.02.5711 H44661600 1 Invoice AV 03/11/2020 04/14/2020 10.75 420 100.05.71.02.5711 Total BAKER & TAYLOR ENTERTAINMENT:2,257.40 CARDMEMBER SERVICE (ELAN) 3469/041420 1 Invoice PARKING FOR LIB LEG DAY 02/26/2020 04/14/2020 7.80 420 100.05.71.00.5303 3469/041420 2 Invoice BUTTON MAKER 02/26/2020 04/14/2020 399.95 420 100.05.71.00.5701 3871/041420 1 Invoice PRINT - WALL ST JOURNAL 02/26/2020 04/14/2020 539.88 420 100.05.71.01.5711 3897/041420 1 Invoice AV 02/26/2020 04/14/2020 125.89 420 100.05.71.02.5711 3905/041420 1 Invoice TEEN HS EXAM STUDY SURVEY 02/26/2020 04/14/2020 25.00 420 100.05.71.00.6062 3905/041420 2 Invoice FOL - TEENS 02/26/2020 04/14/2020 88.10 420 100.05.71.00.5752 3905/041420 3 Invoice SUPPLIES 02/26/2020 04/14/2020 8.40 420 100.05.71.00.5701 3913/041420 1 Invoice FOL - KIDS 02/26/2020 04/14/2020 83.46 420 100.05.71.00.5752 3913/041420 2 Invoice PRINT 02/26/2020 04/14/2020 135.72 420 100.05.71.01.5711 Total CARDMEMBER SERVICE (ELAN):1,414.20 COVELLI, GENE CO031020-LIB 1 Invoice JOJ DJ GINO DEPOSIT 02/26/2020 03/10/2020 100.00 320 100.05.71.00.6062 Total COVELLI, GENE:100.00 EBSCO INFORMATION SERVICES 1588796 1 Invoice PRINT 03/04/2020 03/24/2020 4,336.07 320 100.05.71.01.5711 Page 2 of 9 March 2020 Financial Reports Packet Page 14 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 3 Report dates: 3/1/2020-3/31/2020 Apr 01, 2020 02:39PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total EBSCO INFORMATION SERVICES:4,336.07 ELLIOTT'S ACE HARDWARE 601005/032420 2 Invoice LIBRARY MAINT 02/29/2020 03/24/2020 27.88 320 100.05.71.00.5415 Total ELLIOTT'S ACE HARDWARE:27.88 FINDAWAY WORLD LLC 314692 1 Invoice AV 02/14/2020 03/10/2020 423.93 320 100.05.71.02.5711 315452 1 Invoice AV 02/21/2020 03/10/2020 39.98 320 100.05.71.02.5711 316207 1 Invoice AV 02/27/2020 03/24/2020 47.49 320 100.05.71.02.5711 316437 1 Invoice AV 02/28/2020 03/24/2020 47.49 320 100.05.71.02.5711 316457 1 Invoice AV 02/28/2020 03/24/2020 1,947.08 320 100.05.71.02.5711 Total FINDAWAY WORLD LLC:2,505.97 HEARTLAND BUSINESS SYSTEMS 362302-H 1 Invoice LIB- PALO ALTO RENEWAL 02/20/2020 03/10/2020 1,405.14 320 100.05.71.00.5505 Total HEARTLAND BUSINESS SYSTEMS:1,405.14 IMPACT ACQUISTIONS LLC 1721807 1 Invoice PUBLIC MFD 3/1/20-5/31/20+OVG 1 03/02/2020 03/24/2020 362.29 320 100.05.71.00.5401 Total IMPACT ACQUISTIONS LLC:362.29 KC'S INFLATABLES, LLC KC031020-LIB 1 Invoice JOJ GAMES 50% DEPOSIT 02/22/2020 03/10/2020 100.00 320 100.05.71.00.6062 Total KC'S INFLATABLES, LLC:100.00 KUJAWA ENTERPRISES INC. 131205 1 Invoice MAR20 PLANT MAINTENANCE 03/01/2020 03/24/2020 61.00 320 100.05.71.00.5415 Total KUJAWA ENTERPRISES INC.:61.00 MAYO CLINIC HEALTH LETTER MA032420-LIB 1 Invoice PRINT 03/03/2020 03/24/2020 31.52 320 100.05.71.01.5711 Total MAYO CLINIC HEALTH LETTER:31.52 MICROMARKETING LLC 801704 1 Invoice AV 01/28/2020 03/24/2020 49.48 320 100.05.71.02.5711 802773 1 Invoice AV 02/06/2020 03/24/2020 34.95 320 100.05.71.02.5711 803087 1 Invoice AV 02/11/2020 03/10/2020 35.00 320 100.05.71.02.5711 806325 1 Invoice AV 03/10/2020 03/24/2020 205.47 320 100.05.71.02.5711 Total MICROMARKETING LLC:324.90 MIDWEST TAPE 98578795 1 Invoice AV 02/10/2020 03/10/2020 39.98 320 100.05.71.02.5711 98629547 1 Invoice AV 02/18/2020 03/10/2020 39.99 320 100.05.71.02.5711 98700021 1 Invoice AV 03/03/2020 03/24/2020 149.96 320 100.05.71.02.5711 98727780 1 Invoice AV 03/10/2020 04/14/2020 124.97 420 100.05.71.02.5711 Total MIDWEST TAPE:354.90 Page 3 of 9 March 2020 Financial Reports Packet Page 15 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 4 Report dates: 3/1/2020-3/31/2020 Apr 01, 2020 02:39PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number SAFEWAY PEST MANAGEMENT INC. 629385 1 Invoice FEB20 PEST CONTROL 02/17/2020 03/10/2020 35.00 320 100.05.71.00.5415 631357 1 Invoice MAR20 PEST/INSECT CONTROL 03/16/2020 03/24/2020 35.00 320 100.05.71.00.5415 Total SAFEWAY PEST MANAGEMENT INC.:70.00 SIEMENS INDUSTRY, INC. 5445920285 1 Invoice 03/01/20-02/28/21 FIRE SERVICE A 03/01/2020 03/24/2020 1,932.00 320 100.05.71.00.5415 Total SIEMENS INDUSTRY, INC.:1,932.00 TIAA COMMERCIAL FINANCE, INC. 20340429/0324 1 Invoice 4/1/20-4/30/20 STAFF PRINTER LE 03/10/2020 03/24/2020 336.55 320 100.05.71.00.5401 6941214 1 Invoice 03/01/20-03/31/20 STAFF PRINTER 02/10/2020 03/24/2020 564.00 320 100.05.71.00.5401 Total TIAA COMMERCIAL FINANCE, INC.:900.55 TIME WARNER CABLE 063003301/032 1 Invoice LIBRARY CONNECTION 03/01/2020 03/24/2020 99.98 320 100.05.71.00.5505 Total TIME WARNER CABLE:99.98 U.S. CELLULAR 0360100332 6 Invoice MONTHLY CHARGE- LIBRARY 02/28/2020 03/24/2020 20.00 320 100.05.71.00.5602 0360100332 7 Invoice MONTHLY CHARGE- FINANCE 02/28/2020 03/24/2020 30.00 320 100.05.71.00.5602 Total U.S. CELLULAR:50.00 USA FIRE PROTECTION 1046-F029364 1 Invoice FEB20 QUARTERLY DRY SPRINKL 02/26/2020 03/24/2020 180.00 320 100.05.71.00.5415 Total USA FIRE PROTECTION:180.00 WAUKESHA COUNTY TREASURER 2020-0000021 1 Invoice 100 CD JEWEL CASES 02/11/2020 03/10/2020 185.00 320 100.05.71.00.5702 Total WAUKESHA COUNTY TREASURER:185.00 WE ENERGIES 5499-564-961/ 1 Invoice LIBRARY 03/03/2020 03/24/2020 5,006.48 320 100.05.71.00.5910 Total WE ENERGIES:5,006.48 Grand Totals: 36,021.20 Page 4 of 9 March 2020 Financial Reports Packet Page 16 CITY OF MUSKEGO Payment Approval Report - Library Board Report Alpha Page: 5 Report dates: 3/1/2020-3/31/2020 Apr 01, 2020 02:39PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number 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 5 of 9 March 2020 Financial Reports Packet Page 17 CITY OF MUSKEGO Budget Worksheet - Library Revenues Current Year w/ Monthly Total Page: 1 Period: 03/20 Apr 01, 2020 03:57PM 2020-20 2020-20 2020-20 2020-20 % 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 1,556.00 1,556.00 .00 .00 .00 1,556.00- 100.05.71.00.4150 LIBRARY - SYSTEM, ETC 117,784.00 117,784.00 572.00 416.00 .49% 117,212.00- 100.05.71.00.4274 LIBRARY LOST AND DAMAGED 1,300.00 1,300.00 443.75 169.38 34.13% 856.25- 100.05.71.00.4313 LIBRARY FINES 17,000.00 17,000.00 3,067.66 784.72 18.05% 13,932.34- 100.05.71.00.4314 LIBRARY TAXABLE REVENUE 9,000.00 9,000.00 1,832.00 82.00 20.36% 7,168.00- 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 350.00 .00 35.00% 650.00- 100.05.71.00.4551 SALE OF F/A - COMPUTERS .00 .00 .00 .00 .00 .00 100.05.71.00.4552 LIBRARY FRIENDS REVENUE 5,000.00 5,000.00 883.89 .00 17.68% 4,116.11- Total LIBRARY DEPARTMENT:152,640.00 152,640.00 7,149.30 1,452.10 4.68% 145,490.70- Page 6 of 9 March 2020 Financial Reports Packet Page 18 CITY OF MUSKEGO Budget Worksheet - Library Expenditures Current Year w/ Monthly Total Page: 1 Period: 03/20 Apr 02, 2020 01:26PM 2020-20 2020-20 2020-20 2020-20 % 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 663,692.43 663,692.43 133,880.40 25,268.57 20.17% 529,812.03- 100.05.71.00.5102 OVERTIME 2,000.00 2,000.00 .00 .00 .00 2,000.00- 100.05.71.00.5201 FICA 52,394.27 52,394.27 10,218.53 1,990.36 19.50% 42,175.74- 100.05.71.00.5202 PENSION 39,635.32 39,635.32 7,974.45 1,509.01 20.12% 31,660.87- 100.05.71.00.5203 HEALTH 108,019.98 108,019.98 26,292.21 8,764.07 24.34% 81,727.77- 100.05.71.00.5204 LIFE 1,219.82 1,219.82 277.80 92.60 22.77% 942.02- 100.05.71.00.5205 FSA FEE EXPENSE .00 .00 .00 .00 .00 .00 100.05.71.00.5229 HEALTH INSURANCE ALLOWANCE 19,200.00 19,200.00 4,800.00 1,600.00 25.00% 14,400.00- 100.05.71.00.5302 MILEAGE 2,000.00 2,000.00 273.86 85.68 13.69% 1,726.14- 100.05.71.00.5303 CONFERENCES & TRAINING 3,500.00 3,500.00 25.00 .00 .71% 3,475.00- 100.05.71.00.5305 DUES & MEMBERSHIP 1,300.00 1,300.00 156.00 .00 12.00% 1,144.00- 100.05.71.00.5401 LIBRARY EQUIPMENT 19,900.00 19,900.00 2,663.93 1,262.84 13.39% 17,236.07- 100.05.71.00.5415 MAINTENANCE OF BLDG & GROUNDS 36,700.00 36,700.00 4,781.08 2,882.88 13.03% 31,918.92- 100.05.71.00.5505 COMPUTER CHARGES 40,325.00 40,325.00 23,178.02 1,505.12 57.48% 17,146.98- 100.05.71.00.5602 TELEPHONE 720.00 720.00 70.00 50.00 9.72% 650.00- 100.05.71.00.5701 OFFICE SUPPLIES AND EXPENSES 8,000.00 8,000.00 886.65 329.20 11.08% 7,113.35- 100.05.71.00.5702 PROCESSING SUPPLIES 17,500.00 17,500.00 312.93 185.00 1.79% 17,187.07- 100.05.71.00.5703 HOUSEKEEPING SUPPLIES 3,800.00 3,800.00 211.88 .00 5.58% 3,588.12- 100.05.71.00.5740 LIBRARY GRANT EXPENSE 1,556.00 1,556.00 .00 .00 .00 1,556.00- 100.05.71.00.5752 LIBRARY FRIENDS EXPENSE 5,000.00 5,000.00 1,455.39 .00 29.11% 3,544.61- 100.05.71.00.5774 LIBRARY REPLACEMENT 1,300.00 1,300.00 121.50 22.95 9.35% 1,178.50- 100.05.71.00.5835 HOUSEKEEPING SERVICES 38,000.00 38,000.00 9,375.00 3,125.00 24.67% 28,625.00- 100.05.71.00.5910 GAS & ELECTRIC 75,000.00 75,000.00 10,620.07 5,006.48 14.16% 64,379.93- 100.05.71.00.5915 SEWER & WATER 2,500.00 2,500.00 .00 .00 .00 2,500.00- 100.05.71.00.6062 PROGRAMMING 7,000.00 7,000.00 721.85 200.00 10.31% 6,278.15- 100.05.71.01.5711 PRINT MATERIALS 115,000.00 115,000.00 26,674.30 15,600.79 23.20% 88,325.70- 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 9,039.12 5,527.79 18.08% 40,960.88- 100.05.71.03.5711 ELECTRONIC MATERIALS 18,375.00 18,375.00 11,177.68 143.68 60.83% 7,197.32- 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,333,637.82 1,333,637.82 285,187.65 75,152.02 21.38% 1,048,450.17 Page 7 of 9 March 2020 Financial Reports Packet Page 19 CITY OF MUSKEGO BALANCE SHEET MARCH 31, 2020 FEDERATED LIBRARY SYSTEM FUND ASSETS 503.00.00.00.1001 EQUITY IN POOLED CASH 36,035.60 TOTAL ASSETS 36,035.60 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 21,250.63 REVENUE OVER EXPENDITURES - YTD 1,011.95 TOTAL FUND EQUITY 37,047.55 TOTAL LIABILITIES AND EQUITY 37,047.55 Page 8 of 9 March 2020 Financial Reports Packet Page 20 CITY OF MUSKEGO BALANCE SHEET MARCH 31, 2020 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,932.19 502.00.00.00.1105 LIBRARY INVESTMENTS 45,573.99 TOTAL ASSETS 25,609.18 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 ( 36,083.77) TOTAL FUND EQUITY 25,609.18 TOTAL LIABILITIES AND EQUITY 25,609.18 Page 9 of 9 March 2020 Financial Reports Packet Page 21 Library Name: Description Annual Report Reference 2019 Actuals (Per Annual Report) 2020 Municipal Adopted Budget Library Notes or Comments Revenues Local Municipal Library Operating Revenue Section V, 1 (for 2019) and Section V, 9 (for 2020)$1,149,720 $1,180,997 Home County Operating Revenue Section V, 2(a)$51,254 $53,968 Other County Payments for Library Services Section V, 2(b)$66,784 $63,816 State Funds (e.g. Innovation Grant, Hotspots)Section V, 3 $1,704 $1,556 2020 based on budgeted Grant revenue Federal Funds Section V, 4$0 Contract Income Section V, 5$0 Funds Carried Forward for Operations Section V, 6$0 All Other Operating Income Section V, 7 $33,319 $33,300 2020 based on Lost&Dmged, Fines, Taxable Rev, Room Rental, Friends Rev Indirect Cost Funding (If applicable and if not already counted in Municipal Operating Revenue)N/A ‐ Field should match Indirect Cost field in Expenditures listed below $62,462 $62,462 2020 is based on 2019 actuals Total Revenues $1,365,243 $1,396,099 Expenditures Operating Expenditures Section VI, 6 $1,280,893 $1,333,638 2020 based on budgeted Total Expenditures Indirect Costs (If applicable and if not already counted in another field) N/A ‐ Field should match Indirect Cost Funding in Revenues listed above $62,462 $62,462 2020 based on 2019 actuals Total Operating Expenditures $1,343,355 $1,396,100 Library Capital and Debt Section VII (1 & 2)$50,171 No 2020 Capital Projects Total Expenditures $1,393,526 $1,396,100 The information listed above is a correct statement of the Library's spending for 2019 actuals and 2020 budget. Please provide any additional comments in the box below. __________________________________________________________________ Board President Date __________________________________________________________________ Library Director Date Muskego Instructions: Fill out the following financial information as they pertain to prior year actuals and the current year budget. For prior year actual information, please verify that all applicable information matches the reference fields certified in the annual report. For current year adopted budget information, please reflect the numbers adopted by your municipal entity, effective January 1st. Allowable Cost Worksheet for Waukesha County Libraries ‐ in Bridges Library System 2020 based on budgeted System revenue Allowable Costs Form for 2021 budget Muskego prepopulated ‐ FINAL DRAFT 4/16/2020 T:\Departments\Library\Admin Services\Annual Report\2020 State Report\Allowable Costs\Allowable Costs Form for 2021 budget Muskego prepopulated ‐ FINAL DRAFT Page 1 of 1 Discussion/Action: Allowable Costs Worksheet Packet Page 22