Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Council Packet - 2/11/2019
Council Work Session February 11, 2019 Time indicated below Harold E. Getty Council Chambers Roll Call. Approval of Agenda, as proposed or amended. 3:55 p.m. Presentation of the FYE2020 Library budget. Submitted By: Steven Nielsen, Library Director Approx. Presentation of the FYE2020 Cultural and Arts Department budget. 4:25 p.m. Submitted By: Kent Shankle, Cultural and Arts Director Approx. Presentation of the FYE2020 MIS Department budget. 4:55 p.m. Submitted By: Chris Youngblut, IT Director ADJOURNMENT Kelley F elchle City Clerk CITY OF WATERLOO Council Communication Presentation of the FYE2020 Library budget. City Council Meeting: 2/11/2019 Prepared: 2/6/2019 REVIEWERS: Department Reviewer Action Date Water Works Fek.1111e, .K.elley Approved 2/6/2019 3:53 PM ATTACHMENTS: Description Type • Budget Presentation Backup Material • Buliget .Narrative Ba.ckup Material General Fund R.equ..ests B ackup M.aterial D Bu.dget .Request Backup Material SUBJECT: Submitted by: Recommended Action: Summary Statement: Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: Presentation of the FYE2020 Library budget. Submitted By: Steven Nielsen, Library Director WATERLOO public library gather.c©nnect.expore. Mission Statement • To provide free access to education, information and recreation in a welcoming environment. The Waterloo Public Library • Circulates print and electronic material • Provides information seeking assistance • Offers free educational, informational and recreational programming • Provides outreach to other community organizations and the homebound • Equips users with important technology solutions • Hosts meetings and events for outside organizations Information Technology Manager` WPL Organizational Chart Library Director Circulation & Tech Services Manager Youth & Teen Services Manager 3 Reference Librarians Business Office Manager Technical Services Librarian 5 Youth Services Assistants Volunteer Services & Marketing, Maria®er s Volunteer 4 Circulation Assistants 2 Technical Services Assistants 2 Shelvers 4 Reference Assistants 1 Technical Systems Assistant 4 Circulation Aides Our Challenge Balancing the physical library vs. the virtual library GRO Gather. • Recorded 250,804 visits • by 39,323 cardholders • who attended 897 library programs Connect. • Logged 51,914 computer sessions • on 99 public Internet computers • Connected to WiFi 23,491 times • Downloaded 29,506 electronic items • Hosted a week-long CoderDojo Camp to introduce 8 — 14 year olds to the coding used in developing websites, apps & games. Explore. • Answered 52,029 reference questions • Offered 118 workshops in the Library's Maker Space, The Hive • Registered 951 Youth Summer Library Program participants & 198 Teen Summer Program participants Looking forward Gather. • More convenient, free parking for our patrons • Additional meeting space (that may be accessed after-hours) for community organizations Looking forward Connect. • Anew way of delivering our service • Give children & seniors year-round access to books & library resources • A visible, positive amenity in our community Looking forward Explore. • A vibrant, interactive and safe area for our youngest visitors • Designated programming space • More secure • Child -sized furniture How WPL compares to our peers (top 10 urban libraries in Iowa) Funding: • Total receipts — 10th Current holdings: • Print material added — 10th • Other items added — 7th • Total items owned per capita — 10th Staffing levels: • FTEs — 8th • FTEs with MLS — 10th Materials Expenditures: • Print — 9th • Video — 8th • Audio —10th • eBooks — 7th • Databases — 10th Total Expenditures: • Materials —10th • Per capita —10th • Materials as % of expenditures — 9th Questions? Steven Nielsen Executive Director sneilsen@waterloopubliclibrary.org FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 33 Library ACTIVITY: 3100, 3110 & 3200 204 Library Tax Levy DEPARTMENT/ACTIVITY DESCRIPTION: See separate activity 204-3100, 010-3100, 3110 and 3200 pages. DEPARTMENTIACTIVITY OBJECTIVES: See separate activity 3100, 3110 and 3200 pages. PERSONNEL SUMMARY: GRAND TOTALS (INFORMATION ONLY) FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020* DEPT REQUEST FYE2020 CERTIFIED FYE2020 Library Director 1.00 1.00 1.00 1.00 1.00 Reference/Technical Systems Admin 1.00 1.00 1.00 0.00 0.00 Business Office Manager 1.00 1.00 1.00 1.00 1.00 Circulation & Technical Services Manager 1.00 1.00 1.00 1.00 1.00 Youth & Teen Services Manager 1.00 1.00 1.00 1.00 1.00 Adult Services Manager 0.00 0.00 0.00 1.00 1.00 Marketing & Volunteer Manager ** 1.00 1.00 1.00 1.00 1.00 Librarian I 3.00 3.75 3.75 3.75 3.75 Tech Systems Assistant 0.75 0.75 0.75 0.75 0.75 Library Assistant 13.02 12.92 11.92 12.17 12.17 Library Aide 3.65 3.00 3.00 3.00 3.00 3rd Age Coordinator 0 0.3 0.3 0.3 0.3 Information Literacy Coordinator 1.00 1.00 0.00 0.00 0.00 Information Technology Manager 0.00 0.00 1.00 1.00 1.00 TOTAL FULL-TIME EQUIVALENT POSITIONS 27.42 27.72 26.72 26.97 26.97 0 *AT CURRENT FYE19 STAFFING LEVEL 17.91 lib gen 0.8 lib county 0.3 lib enrich 7.96 lib levy 26.97 FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 33 Library ACTIVITY: 3100 Library Services DEPARTMENT/ACTIVITY DESCRIPTION: In FY18, the total circulation of physical and downloadable material and successful retrieval of electronic information at the Waterloo Public Library was 299,035. Approximately 250,800 visits to the library by the public were recorded in FY18; 29,873 people attended 897 library programming events, both inside and outside the library, including adult, teen and children programs. 951 children registered for the 6 week Summer Library Program. In FY18, the library had 39,323 cardholders and owned 112,777 total physical and dowloadable volumes; 52,029 reference questions were answered; 99 internet stations are available for public use, including for adults, teens and kids. DEPARTMENT/ACTIVITY OBJECTIVES: To provide outstanding customer service to patrons of all ages by responding to community needs. To provide up-to-date and relevant materials, including print, AN, downloadable books, audio books and on-line databases. To provide free computer access. To provide technology classes. To offer programming needs for adults and teens, including book discussion groups, movie matinees and a makerspace. To offer children and family story times. To offer outreach services for youth, teens and adults. To offer a clean, safe environment for pleasure and learning. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 Library Director 0.70 0.70 0.70 0.70 0.70 Reference/Technical Systems Admin 0.70 0.70 0.70 0.00 0.00 Business Office Manager 0.70 0.70 0.70 0,70 0.70 Circulation & Technical Services Manager 0.70 0.70 0.70 0.70 0.70 Youth & Teen Services Manager 0.70 0.70 0.70 0.70 0.70 Adult Services Manager 0.00 0.00 0.00 0.70 0.70 Marketing & Volunteer Manager ** 0.70 0.70 0.70 0.70 0.70 Librarian 1 2.10 2.62 2.62 2.62 2.62 Tech Systems Assistant 0.52 0.52 0.52 0.52 0.52 Library Assistant 9.02 9.02 8.32 8.49 8.49 Library Aide 2.60 2.08 2.08 2.08 2.08 TOTAL FULL-TIME EQUIVALENT POSITIONS 18.44 18.44 17.74 17.91 17.91 0.00 **Prior to 212019 this position was a Marketing and Volunteer Coordinator FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 33 Library ACTIVITY: 3110 Library Enrich Iowa DEPARTMENT/ACTIVITY DESCRIPTION: The Enrich Iowa program includes three components: Direct State Aid for public libraries, Open Access and Interlibrary Loan/Access Plus. Enrich Iowa funds supplement, not supplant, any other funding received by the library. DEPARTMENT/ACTIVITY OBJECTIVES: To employ a Coordinator to manage the 3rd Age Project; and to purchase print materials for 3rd Age Book Discussion groups. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 3rd Age Coordinator 0 0.3 0.3 0.3 TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0.3 0.3 0.3 0 0 *AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 33 Library ACTIVITY: 3150 Library Access Plus DEPARTMENT/ACTIVITY DESCRIPTION: The Waterloo Public Library is compensated from state funds for costs associated with interlibrary loan materials to other libraries. In FY18, the Waterloo Public Library loaned 8,505 items to eligible lowa libraries. DEPARTMENT/ACTIVITY OBJECTIVES: To purchase adult, teen and youth DVDs. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020* DEPT REQUEST FYE2020 CERTIFIED FYE2020 TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0 0 0 0 0 * AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 33 Library ACTIVITY: 3160 Library Grants & Projects DEPARTMENT/ACTIVITY DESCRIPTION: Direct State Aid funds, once called Infrastructure, are distributed to libraries based on the previous year's Open Access and/or Access Plus transactions. Gift monies and Grants, including Black Hawk County Gaming Association grant received in FY19, are tracked by assigning special project budget codes. Miscellaneous gifts and memorials are received from donors throughout the year. DEPARTMENT/ACTIVITY OBJECTIVES: To purchase minor computer equipment and/or software, computer maintenance or related items and materials for the Library collection. To fund programming events, including speakers and supplies needed for events. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0 0 0 0 0 *AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 33 Library ACTIVITY: 3180 Library Gift & Memorial DEPARTMENT/ACTIVITY DESCRIPTION: The Community Foundation of Waterloo/Cedar Falls and Northeast Iowa holds gift monies for the Waterloo Public Library, including estates, bequests, donations and memorials. Some monies are held as endowed funds, while others are held to purchase items for the library, including print and AN materials. Gift monies also fund remodeling projects, including furnishings. DEPARTMENT/ACTIVITY OBJECTIVES: To place items in the library collection by memorializing or honoring an individual. To help fund remodeling projects. To purchase items for public use which could not be purchased with regular library funding. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020* DEPT REQUEST FYE2020 CERTIFIED FYE2020 TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0 0 0 0 0 * AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 Genera] DEPARTMENT: 33 Library ACTIVITY: 3190 Iowa Library Services DEPARTMENT/ACTIVITY DESCRIPTION: Iowa Library Services replaces what was once known as the Regional Library Service Area. Iowa Library Services contracts with the Waterloo Public Library for office space for $2,928 annual rent and provides consulting services for member libraries. DEPARTMENT/ACTIVITY OBJECTIVES: To purchase adult, teen and youth DVDs. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0 0 0 0 0 *AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 33 Library ACTIVITY: 3200 County Library System DEPARTMENT/ACTIVITY DESCRIPTION: The Waterloo Public Library provides service to Black Hawk County residents through contractual agreement. In FY18, items were circulated over 14,494 times to Black Hawk County residents, DEPARTMENT/ACTIVITY OBJECTIVES: To support Information Technology Manager salary. To purchase office supplies. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 Information Literacy Coordinator 0.8 0.8 0 0 Information Technology Manager 0 0 0.8 0.8 TOTAL FULL-TIME EQUIVALENT POSITIONS 0.8 0.8 0.8 0.8 0 0 *AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 33 Library ACTIVITY: 3210 Library Open Access DEPARTMENT/ACTIVITY DESCRIPTION: Through contract with the State Library of lowa, the Waterloo Public Library agrees to loan materials to all patrons from other libraries that participate in the statewide Open Access Program, This program also allows Waterloo library patrons the opportunity to borrow materials from participating Iowa libraries. DEPARTMENT/ACTIVITY OBJECTIVES: To purchase minor computer equipment and software. To support staff continuing education. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0 0 0 0 0 *AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 204 Library Tax Levy DEPARTMENT: 33 Library ACTIVITY: 3100 Library Services DEPARTMENT/ACTIVITY DESCRIPTION: The special library tax levy revenue was approved by Waterloo voters on November 2, 1993, to enable the Waterloo Public Library to be open to the public additional hours beyond the level supported by the general fund budget. To offer convenient open hours by providing for employee salaries and benefits. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 Library Director 0.30 0.30 0.30 0.30 0.30 Reference/Technical Systems Admin 0.30 0.30 0.30 0.00 0.00 Business Office Manager 0.30 0.30 0.30 0.30 0,30 Circulation & Technical Services Manager 0,30 0.30 0.30 0.30 0.30 Youth & Teen Services Manager 0.30 0.30 0.30 0.30 0.30 Adult Services Manager 0.00 0.00 0.00 0.30 0.30 Marketing & Volunteer Manager ** 0.30 0.30 0.30 0.30 0.30 Librarian' 0.90 1.13 1.13 1.13 1.13 Tech Systems Assistant 0,23 0.23 0.23 0.23 0.23 Information Literacy Coordinator 0.20 0.20 0,00 0.00 0.00 Information Technology Manager 0.00 0.00 0.20 0.20 0.20 Library Assistant 4.00 3.90 3.60 3.68 3.68 Library Aide 1.05 0.92 0.92 0.92 0.92 TOTAL FULL-TIME EQUIVALENT POSITIONS 8.18 8.18 7.88 7.96 7.96 0.00 * AT CURRENT FYE19 STAFFING LEVEL **Prior to 2/2019 this position was a Marketing and Volunteer Coordinator G/L Account Account Description Fund 010 - Genera_ Fund REVENUE Department 33 - Lb_ Act /iry 3100 - L_ _ _ ices Charges r Fees f Service 010-33-3100 3470 010-33-3100 3873 Library Fee Reimbursement for Service (Thames fini Fees t-gn Set Library GF Addtional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional Incr (Decr) from Amount Amount Amount Budget Budget 2020 Base Level Needs FY20 Base 30,780.58 26,292.83 43,473.62 27,020.50 12,837.42 34,000.00 34,000.00 34,000.00 24,000.00 (10,000.00) 30.00 .00 .00 .00 .00 .00 $74,254.20 $53,313.33 $12,867.42 $34,000.00 $34,000.00 $34,000.00 $24,000.00 ($10,000.00) miscellaneous Reimh 010-33-3100 3800 Miscellaneous Revenue 30.00 30.00 .00 .00 .00 .00 .00 .00 010-33-3100 3871 Damage Claims 3,432.40 3,043.96 1,176.54 2,000.00 2,000.00 2,000.00 3,000.00 1,000.00 Miscellaneous Reveiruu tcc<r $3,462.40 $3,073.96 $1,176.54 $2,000.00 $2,000.00 $2,000.00 $3,000.00 $1,000.00 010-33-3100 3722 Refunds .00 .00 68.65 .00 .00 .00 .00 .00 Reall7 s v t -?r. $0.00 $0.00 $68.65 $0.00 $0.00 $0.00 $0.00 $0.00 Activit 3100 __bcrivices - Activity 3110 - Library Enrich Iowa Stye Governing/7r grant 010-33-3110 3361 State Grant State Onverir, ,:t GAG& tmals $77,716.60 $56,387.29 13,123.41 15,446.02 $14,112.61 $36,000.00 16,459.59 14,527.00 $36,000.00 $36,000.00 14,527.00 14,527.00 $27,000.00 ($9,000.00) 14,527.00 .00 $13,123.41 $15,446.02 $16,459.59 $14,527.00 $14,527.00 $14,527.00 $14,527.00 $0.00 Other Financing iM fe5 010-33-3110 3000 Cash on Hand .00 .00 .00 3,890.00 3,890.00 3,890.00 3,890.00 .00 Otter Finanrrg Sources io ly $0.00 $0.00 $0.00 $3,890.00 $3,890.00 $3,890.00 $3,890.00 $0.00 At - -- 3110 nr _LL Iowa Totals Ac_ vi°a 3150 - Library Access Pins State Government ;rarer 010-33-3150 3361 State Grant State Gauen- r r rr ry Activity 3150 - Library Access Activity 3160 - L_br rA Grants & Projects 010-33-3160 3361 State Grant $13,123.41 $15,446.02 4,928.66 4,502.76 $16,459.59 $18,417.00 5,037.26 3,000.00 $18,417.00 $18,417.00 3,000.00 3,000.00 $18,417.00 $0.00 3,000.00 .00 $4,928.66 $4,502.76 $5,037.26 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $0.00 $4,928.66 $4,502.76 6,800.00 6,800.00 $5,037.26 $3,000.00 8,837.26 6,800.00 $3,000.00 $3,000.00 6,800.00 6,800.00 $3,000.00 $0.00 6,800.00 .00 Run by Kim Bahr on 02/11/2019 14:34:16 PM Page 1 of 8 G/L Account Account Description Fund 010 - Genera_ Fun REVENUE Department 33-_o ALLIVi y - " _ Grants Scare Government GO= State O_ - r 7i7 Pe Totals tats Shored P'io rim - City 010-33-3160 3358 Shared Program - City Snared Phogram = City hie Contributions & Donations = Private Sources 010-33-3160 3720 Restricted Donations :es eras Library GF Addtional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional Incr (Decr) from Amount Amount Amount Budget Budget 2020 Base Level Needs FY20 Base $6,800.00 $6,800.00 $8,837.26 $6,800.00 $6,800.00 $6,800.00 $6,800.00 $0.00 .00 4,185.42 .00 .00 .00 .00 .00 .00 $0.00 $4,185.42 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 84,865.65 103,081.00 .00 30,000.00 18,000.00 18,000.00 5,000.00 (13,000.00) $84,865.65 $103,081.00 $0.00 $30,000.00 $18,000.00 $18,000.00 $5,000.00 ($13,000.00) trier F n ing _=ourdeb 010-33-3160 3000 Cash on Hand .00 .00 .00 27,065.00 27,065.00 27,065.00 27,065.00 .00 Other Fra mo Sour- - vs Totals $0.00 $0.00 $0.00 $27,065.00 $27,065.00 $27,065.00 $27,065.00 $0.00 Activity 3160 L__` _ r a Projefts Totals Activity 3180 - LiDi Cbotributhrns & Donations ion = Private Ge_ur ccs" 010-33-3180 3720 Restricted Donations Cant rIhUIs•P-Mrd,i-• le- S_.. e_ Activity 31 - Ltare_ 7 _ft & Activity 3190 - sea L_r_ 7e_ v_cs Use Of Money & Property 010-33-3190 3620 Rent & Property Leases Use Of Meney & Property Totals Ar_ t= 319 so-ws L_ ces Tot Activity 3200 - County Library sser Shared Fdo ro - C_,=Uig ' 010-33-3200 3357 Shared Program - County hatial PTOgrain-COr ='WO/5 $91,665.65 $114,066.42 $8,837.26 $63,865.00 $51,865.00 $51,865.00 $38,865.00 ($13,000.00) 65,651.09 40,617.09 2,565.59 20,000.00 20,000.00 20,000.00 5,000.00 (15,000.00) $65,651.09 $40,617.09 $2,565.59 $20,000.00 $20,000.00 $20,000.00 $5,000.00 ($15,000.00) $65,651.09 $40,617.09 4,128.00 2,928.00 $2,565.59 $20,000.00 1,220.00 4,120.00 $20,000.00 $20,000.00 4,120.00 4,120.00 $5,000.00 ($15,000.00) 2,928.00 (1,192.00) $4,128.00 $2,928.00 $1,220.00 $4,120.00 $4,120.00 $4,120.00 $2,928.00 ($1,192.00) $4,128.00 $2,928.00 71,163.00 65,066.00 $1,220.00 $4,120.00 30,871.00 71,163.00 $4,120.00 $4,120.00 71,163.00 71,163.00 $2,928.00 ($1,192.00) 61,742.00 (9,421.00) $71,163.00 $65,066.00 $30,871.00 $71,163.00 $71,163.00 $71,163.00 $61,742.00 ($9,421.00) Run by Kim Bahr on 02/11/2019 14:34:16 PM Page 2 of 8 G/L Account Account Description Fund 010 - Genera_ Fun REVENUE Department 33 - Library Amory 3200 - County LID' Other Financing Sources Library GF Addtional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional Amount Amount Amount Budget Budget 2020 Base Level Needs Incr (Decr) from FY20 Base 010-33-3200 3000 Cash on Hand .00 .00 .00 13,721.00 13,721.00 15,984.00 15,984.00 .00 Other g Sources totals $0.00 $0.00 $0.00 $13,721.00 $13,721.00 $15,984.00 Activity 3200 - ;entity Libra_ Activity 3210 - __bay_ 7 Access State Government Grants •nts 010-33-3210 3361 State Grant thrr fr 'wing Sources 010-33-3210 3000 Cash on Hand °rho, 1-inaliC.ing Sources fools Activity 3 0 Library Open Access Totals s Department Library Totals REVENUE TOTALS $15,984.00 $0.00 $71,163.00 $65,066.00 5,300.00 7,300.00 $30,871.00 $84,884.00 7,337.26 5,300.00 $84,884.00 $87,147.00 5,300.00 5,300.00 $77,726.00 ($9,421.00) 5,300.00 .00 $5,300.00 $7,300.00 $7,337.26 $5,300.00 $5,300.00 $5,300.00 $5,300.00 $0.00 .00 .00 .00 4,700.00 4,700.00 4,700.00 4,700.00 .00 $0.00 $0.00 $0.00 $4,700.00 $4,700.00 $4,700.00 $4,700.00 $0.00 $5,300.00 $7,300.00 $7,337.26 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $0.00 $333,676.41 $333,676.41 $306,313.58 $306,313.58 $86,440.57 $86,440.57 $240,286.00 $240,286.00 $228,286.00 $228,286.00 $230,549.00 $230,549.00 $182,936.00 $182,936.00 ($47,613.00) ($47,613.00) EXPENSE Department 33 - L- A Le'_y 3100 - L_b are Services Persona/ Services - Salaries - Benefits 010-33-3100 1111 Salaries - Regular 926,912.72 866,656.20 449,466.30 896,492.00 878,292.00 944,308.00 954,183.00 9,875.00 010-33-3100 1112 Salaries - Part-time 60,538.48 52,335.62 23,047.71 52,807.00 71,007.00 52,807.00 52,807.00 .00 010-33-3100 1113 Longevity Pay 17,700.44 17,478.51 8,069.34 20,147.00 20,147.00 19,017.00 19,292.00 275.00 010-33-3100 1114 Time & Half Pay 178.94 428.32 202.93 1,000.00 1,000.00 1,000.00 1,000.00 .00 010-33-3100 1117 Double Time Pay 38,710.04 40,135.81 15,628.08 42,350.00 42,350.00 42,350.00 42,350.00 .00 010-33-3100 1121 FICA - City Contribution 77,711.95 73,353.66 37,431.89 77,746.00 77,746.00 80,194.00 80,972.00 778.00 010-33-3100 1122 IPERS - City Contribution 92,260.54 86,854.01 46,651.95 95,609.00 95,609.00 98,485.00 99,444.00 959.00 010-33-3100 1123 Life & Disability Insurance 5,082.34 4,968.47 2,650.39 4,813.00 4,813.00 5,060.00 5,075.00 15.00 010-33-3100 1128 Retirement Pay 2,988.60 12,557.02 4,502.36 .00 .00 .00 .00 .00 010-33-3100 1130 Employee Benefit Reimbursement 3,513.07 3,085.66 5,047.79 3,513.00 3,513.00 5,050.00 5,050.00 .00 010-33-3100 1131 Health Insurance 146,420.32 152,597.68 79,345.67 145,343.00 145,343.00 161,651.00 181,868.00 20,217.00 Persona/ Services Salaries & Benefits' totals- $1,372,017.44 $1,310,450.96 $672,044.41 $1,339,820.00 $1,339,820.00 $1,409,922.00 $1,442,041.00 $32,119.00 Run by Kim Bahr on 02/11/2019 14:34:16 PM Page 3 of 8 Gil_ Account Account Description Fund 010 - Genera_ Fun EXPENSE Departrient 33 - _ D Activiri 3100 - L_ _ tee_ Ices Contractual en-Ae 010-33-3100 1319 Other Professional Services 010-33-3100 1320 Semi -Professional Services 010-33-3100 1326 Cataloging Services 010-33-3100 1339 Data Communication 010-33-3100 1341 Contract Carriers 010-33-3100 1343 Postage & Mailing Expense 010-33-3100 1344 Telephone & Fax Expense 010-33-3100 1351 Advertising Expense 010-33-3100 1353 Printing Services 010-33-3100 1371 Building & Grounds Maintenance 010-33-3100 1376 Office Equipment Repair & Maintenance 010-33-3100 1385 Office Equip Repair & Maintenance 010-33-3100 1391 Dues & Memberships 010-33-3100 1400 Utility Service 010-33-3100 1516 Minor Computer Equipment 010-33-3100 1520 Computer Software 010-33-3100 1533 Fuel Expense 010-33-3100 1541 Janitorial Supplies 010-33-3100 1543 Library Supplies 010-33-3100 1561 Office Supplies & Minor Equipment 010-33-3100 1582 Adult Print Materials 010-33-3100 1583 Downloadable Materials 010-33-3100 1584 Reference Materials 010-33-3100 1585 Periodicals & Microfilm 010-33-3100 1590 Youth Print Materials 010-33-3100 1593 Teen Print Materials 010-33-3100 1594 On -Line Reference Materials Library GF Addtional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional Incr (Decr) from Amount Amount Amount Budget Budget 2020 Base Level Needs FY20 Base 27,870.56 12,250.03 2,583.54 20,183.00 21,183.00 21,183.00 13,000.00 (8,183.00) 900.00 1,000.00 .00 1,000.00 1,000.00 1,000.00 1,000.00 .00 12,809.27 809.75 3,000.00 16,334.00 26,334.00 26,334.00 5,000.00 (21,334.00) 558.05 .00 740.80 1,500.00 500.00 500.00 500.00 .00 550.00 6,607.00 .00 .00 .00 .00 .00 .00 9,016.39 5,033.24 5,074.37 15,000.00 15,000.00 15,000.00 10,000.00 (5,000.00) 1,169.86 814.00 518.00 1,250.00 1,250.00 1,250.00 1,250.00 .00 .00 .00 .00 450.00 450.00 450.00 450.00 .00 1,879.71 941.91 391.00 3,117.00 3,117.00 3,117.00 3,117.00 .00 8,086.04 13,980.78 5,426.50 15,280.00 15,280.00 15,280.00 15,280.00 .00 43,547.55 41,720.76 18,611.51 41,236.00 41,236.00 41,236.00 41,236.00 .00 2,682.96 2,682.96 2,012.22 2,700.00 2,700.00 2,700.00 2,700.00 .00 1,241.00 856.00 790.00 1,500.00 1,500.00 1,500.00 1,500.00 .00 58,482.82 61,530.50 36,180.51 58,152.00 58,152.00 58,152.00 65,000.00 6,848.00 $168,794.21 $148,226.93 $75,328.45 $177,702.00 $187,702.00 $187,702.00 $160,033.00 ($27,669.00) 7,977.25 14,514.71 4,709.06 6,000.00 6,000.00 6,000.00 9,000.00 3,000.00 7,174.66 3,548.90 126.18 6,000.00 6,000.00 6,000.00 6,000.00 .00 138.60 46.42 33.00 500.00 500.00 500.00 500.00 .00 10,294.06 9,606.10 5,326.91 7,000.00 7,000.00 7,000.00 10,000.00 3,000.00 9,148.50 3,400.61 1,479.27 18,500.00 18,500.00 18,500.00 5,000.00 (13,500.00) 6,038.07 8,390.08 2,962.09 10,559.00 10,559.00 10,559.00 10,559.00 .00 53,431.33 57,039.34 34,035.84 49,500.00 49,500.00 49,500.00 56,500.00 7,000.00 20,188.85 44,833.78 20,751.20 29,975.00 20,000.00 20,000.00 30,000.00 10,000.00 1,648.77 1,944.99 232.70 1,500.00 1,500.00 1,500.00 1,500.00 .00 12,311.12 7,978.93 493.02 9,900.00 9,900.00 9,900.00 9,900.00 .00 25,633.53 32,884.93 7,362.54 24,000.00 24,000.00 24,000.00 31,000.00 7,000.00 6,865.25 9,999.57 2,755.55 5,000.00 5,000.00 5,000.00 9,500.00 4,500.00 17,121.30 18,316.36 15,449.36 15,525.00 15,500.00 15,500.00 18,300.00 2,800.00 Run by Kim Bahr on 02/11/2019 14:34:16 PM Page 4 of 8 GIL Account Account Description Fund 010 - Genera_ Fun EXPENSE Department 33 - Lwow '_ Activity 3100 - L_ Chternetiews 010-33-31001595 CD's 010-33-31001597 DVD's _:1,77,2141i -7S 10[315 Activity 3100 __ 3 _ _ lows Activity 3110 - Library Enrich Iowa Personal Services Salaries &Benefits Library GF Addtional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional Incr (Decr) from Amount Amount Amount Budget Budget 2020 Base Level Needs FY20 Base 9,814.30 7,298.10 31,865.09 27,187.93 2,321.01 5,300.00 19,072.63 28,300.00 5,300.00 5,300.00 28,300.00 28,300.00 7,300.00 2,000.00 30,169.00 1,869.00 $219,650.68 $246,990.75 $117,110.36 $217,559.00 $207,559.00 $207,559.00 $235,228.00 $27,669.00 $1,760,462.33 $1,705,668.64 $864,483.22 $1,735,081.00 $1,735,081.00 $1,805,183.00 $1,837,302.00 $32,119.00 010-33-3110 1112 Salaries - Part-time .00 10,159.74 4,725.15 15,313.00 15,313.00 15,313.00 15,313.00 .00 010-33-3110 1121 FICA - City Contribution .00 777.22 361.48 1,171.00 1,171.00 1,171.00 1,171.00 .00 010-33-3110 1122 IPERS - City Contribution .00 458.75 446.05 1,446.00 1,446.00 1,446.00 1,446.00 .00 Persona/ Serves _ Salaries Bene --r $0.00 $11,395.71 $5,532.68 $17,930.00 $17,930.00 $17,930.00 $17,930.00 $0.00 eweraetwe Oen es 010-33-3110 1320 Semi -Professional Services 14,632.96 1,793.72 .00 .00 .00 .00 .00 .00 Coot/ Safi tre_tj $14,632.96 $1,793.72 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Commodities 010-33-3110 1582 Adult Print Materials Achy 3110 Library E En Iowa Teta Activity 3130 - Library Access Pius sa r`I OWEle 264.28 24.74 .00 487.00 487.00 487.00 487.00 .00 $264.28 $24.74 $0.00 $487.00 $487.00 $487.00 $487.00 $0.00 $14,897.24 $13,214.17 $5,532.68 $18,417.00 $18,417.00 $18,417.00 $18,417.00 $0.00 010-33-31501597 DVD's 2,888.28 2,999.42 .00 3,000.00 3,000.00 3,000.00 3,000.00 .00 _` .1„ ,t= ITie 1012i; $2,888.28 $2,999.42 $0.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $0.00 $2,888.28 $2,999.42 Activit'? 3o0- - L_ - Grants Ejects Contractual Seivices $0.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $0.00 010-33-3160 1320 Semi -Professional Services 690.83 16,260.25 .00 26,000.00 14,000.00 14,000.00 14,000.00 .00 010-33-3160 1371 Building & Grounds Maintenance .00 6,830.00 .00 .00 .00 .00 .00 .00 Sfiniiaccsai Sencced4-1315 $690.83 $23,090.25 $0.00 $26,000.00 $14,000.00 $14,000.00 $14,000.00 $0.00 Run by Kim Bahr on 02/11/2019 14:34:17 PM Page 5 of 8 G/L Account Fund 010 - Genera_ EXPENSE Department 33- Acnviry 3180 - avninoctaes 010-33-3160 1516 010-33-3160 1520 010-33-3160 1523 010-33-3160 1543 010-33-3160 1561 010-33-3160 1582 010-33-3160 1583 010-33-3160 1585 010-33-3160 1590 010-33-3160 1593 010-33-3160 1594 010-33-3160 1595 010-33-3160 1597 Account Description Fun ants Minor Computer Equipment Computer Software Program Supplies Library Supplies Office Supplies & Minor Equipment Adult Print Materials Downloadable Materials Periodicals & Microfilm Youth Print Materials Teen Print Materials On -Line Reference Materials CD's DVD's Atilt__ 3160 _.3 Activity 3180 - L__a_ Contractual Servk-es 010-33-3180 1319 010-33-3180 1371 CFFFFFaains 010-33-3180 1524 010-33-3180 1555 010-33-3180 1582 Capital Outlay 010-33-3180 2152 COMMOG r_ nHProjects To Other Professional Services Building & Grounds Maintenance aotraaual 511 --ice., Totals Workshop & Class Supplies Minor Equipment & Supplies Adult Print Materials Building Improvements orals 2017 Actual Amount 6,548.10 .00 120.31 .00 .00 4,547.55 6,043.00 .00 114.83 .00 .00 338.89 .00 2018 Actual Amount 23,504.32 .00 .00 200.54 6,098.30 2,874.85 1,732.50 .00 1,218.40 .00 .00 .00 7,878.21 2019 Actual Amount .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 Library GF Addtional Needs Level 2019 Amended 2019 Adopted 2020 Additional Incr (Decr) from Budget Budget 2020 Base Level Needs FY20 Base 5,800.00 1,000.00 2,000.00 .00 .00 2,000.00 5,000.00 1,500.00 3,000.00 3,000.00 1,000.00 6,000.00 7,565.00 5,800.00 1,000.00 2,000.00 .00 .00 2,000.00 5,000.00 1,500.00 3,000.00 3,000.00 1,000.00 6,000.00 7,565.00 5,800.00 1,000.00 2,000.00 .00 .00 2,000.00 5,000.00 1,500.00 3,000.00 3,000.00 1,000.00 6,000.00 7,565.00 5,800.00 1,000.00 2,000.00 .00 .00 2,000.00 5,000.00 1,500.00 3,000.00 3,000.00 1,000.00 6,000.00 7,565.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 $17,712.68 $43,507.12 $0.00 $37,865.00 $37,865.00 $37,865.00 $37,865.00 $0.00 $18,403.51 12,147.64 495.00 $66,597.37 9,896.48 540.00 $0.00 1,226.00 90.00 $63,865.00 .00 .00 $51,865.00 .00 .00 $51,865.00 .00 .00 $51,865.00 .00 .00 $0.00 .00 .00 $12,642.64 10,416.16 12,430.14 30,162.15 $10,436.48 8,251.01 1,105.62 20,725.02 $1,316.00 1,249.59 .00 .00 $0.00 .00 .00 20,000.00 $0.00 .00 .00 20,000.00 $0.00 .00 .00 20,000.00 $0.00 .00 .00 20,000.00 $0.00 .00 .00 .00 $53,008.45 .00 $30,081.65 98.96 $1,249.59 .00 $20,000.00 .00 $20,000.00 .00 $20,000.00 .00 $20,000.00 .00 $0.00 .00 $0.00 $98.96 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Run by Kim Bahr on 02/11/2019 14:34:17 PM Page 6 of 8 GIL Account Account Description 'ss_ 010 - Genera_ Fun EXPENSE _ _ 33 - Library r ey 3 300 - Libra - _ _ Tos? < Az: ivivy 3190 - IOW as trrmoilt`r` 010-33-31901595 CD's .00 010-33-31901597 DVD's 1,778.63 Library GF Addtional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional Incr (Decr) from Amount Amount Amount Budget Budget 2020 Base Level Needs FY20 Base $65,651.09 $40,617.09 A".v ay 3190 Iowa, Li ng .7 -ices of Act itv 3200 - Couns sibrary Sistem Persona/ Services - Soiornes f t` =its 2,928.78 $2,565.59 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $0.00 .00 .00 .00 .00 .00 .00 1,112.08 .00 4,120.00 4,120.00 4,120.00 4,120.00 .00 $1,778.63 $4,040.86 $0.00 $4,120.00 $4,120.00 $4,120.00 $4,120.00 $0.00 $1,778.63 $4,040.86 $0.00 $4,120.00 $4,120.00 $4,120.00 $4,120.00 $0.00 010-33-3200 1111 Salaries - Regular 21,150.32 49,433.28 25,838.72 51,784.00 51,784.00 52,566.00 52,566.00 .00 010-33-3200 1113 Longevity Pay 287.95 .00 .00 .00 .00 .00 .00 .00 010-33-3200 1114 Time & Half Pay 62.12 .00 .00 500.00 500.00 500.00 500.00 .00 010-33-3200 1117 Double Time Pay 615.49 .00 .00 .00 .00 .00 .00 .00 010-33-3200 1121 FICA - City Contribution 1,999.37 3,673.15 1,927.99 3,999.00 3,999.00 4,059.00 4,059.00 .00 010-33-3200 1122 IPERS - City Contribution 1,974.96 4,414.31 2,439.24 4,935.00 4,935.00 5,009.00 5,009.00 .00 010-33-3200 1123 Life & Disability Insurance 100.02 .00 .00 223.00 223.00 226.00 226.00 .00 010-33-3200 1128 Retirement Pay 4,251.40 .00 .00 .00 .00 .00 .00 .00 010-33-3200 1131 Health Insurance 2,798.40 .00 .00 12,720.00 12,720.00 14,064.00 .00 (14,064.00) Persona. f a./ Setvices = Salaries Benefits fat- h $33,240.03 $57,520.74 $30,205.95 $74,161.00 $74,161.00 $76,424.00 $62,360.00 ($14,064.00) a nrr-rrttas 010-33-3200 1561 Office Supplies & Minor Equipment Activity 3200 - bry LIDF2' - Act v ty 3210 - Library, Open Access Contractual Sep/ices 010-33-3210 1346 Travel - Professional Training Cominconnes 010-33-3210 1516 010-33-3210 1520 Contractual Service - Minor Computer Equipment Computer Software 2,167.63 .00 .00 10,723.00 10,723.00 10,723.00 10,723.00 .00 $2,167.63 $0.00 $0.00 $10,723.00 $10,723.00 $10,723.00 $10,723.00 $0.00 $35,407.66 $57,520.74 2,437.31 1,463.54 $30,205.95 $84,884.00 422.00 4,000.00 $84,884.00 $87,147.00 4,000.00 4,000.00 $73,083.00 ($14,064.00) 4,000.00 .00 $2,437.31 $1,463.54 $422.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $0.00 4,326.65 3,591.48 .00 4,000.00 4,000.00 4,000.00 4,000.00 .00 1,750.00 1,750.00 .00 2,000.00 2,000.00 2,000.00 2,000.00 .00 Run by Kim Bahr on 02/11/2019 14:34:17 PM Page 7 of 8 G/L Account Account Description Fund 010 - Genera_ Fun EXPENSE Departrient 33 - Lb_ Actor, 321 - L_ _n Access Commodities Como alities Totals Activity 3210 -a_ Open Acmes 'ot's Department 3 Library .oval EXPENSE TOTALS Fund - Genera_ Fund °a?=s REVENUE TOTALS EXPENSE TOTALS Fund 010 - Genecalu d . s Net Grand Totals REVENUE GRAND TOTALS EXPENSE GRAND TOTALS Library GF Addtional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional Incr (Decr) from Amount Amount Amount Budget Budget 2020 Base Level Needs FY20 Base $6,076.65 $5,341.48 $0.00 $6,000.00 $6,000.00 $6,000.00 $6,000.00 $0.00 $8,513.96 $6,805.02 $422.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $0.00 $1,908,002.70 $1,897,463.31 $903,209.44 $1,939,367.00 $1,927,367.00 $1,999,732.00 $2,017,787.00 $18,055.00 $1,908,002.70 $1,897,463.31 $333,676.41 $1,908,002.70 $306,313.58 $1,897,463.31 $903,209.44 $1,939,367.00 $86,440.57 $903,209.44 $240,286.00 $1,939,367.00 $1,927,367.00 $1,999,732.00 $228,286.00 $1,927,367.00 $230,549.00 $1,999,732.00 $2,017,787.00 $18,055.00 $182,936.00 $2,017,787.00 ($47,613.00) $18,055.00 ($1,574,326.29) ($1,591,149.73) $333,676.41 $1,908,002.70 $306,313.58 $1,897,463.31 ($816,768.87) ($1,699,081.00) ($1,699,081.00) ($1,769,183.00) ($1,834,851.00) ($65,668.00) $86,440.57 $903,209.44 $240,286.00 $1,939,367.00 $228,286.00 $1,927,367.00 $230,549.00 $1,999,732.00 $182,936.00 $2,017,787.00 ($47,613.00) $18,055.00 .e_ Grand Tocals ($1,574,326.29) ($1,591,149.73) ($816,768.87) ($1,699,081.00) ($1,699,081.00) ($1,769,183.00) ($1,834,851.00) ($65,668.00) Run by Kim Bahr on 02/11/2019 14:34:17 PM Page 8 of 8 G/L Account Account Description t..t 204 _ L_br =yTax Levy REVENUE pa _ _ 33 - _ b - Act riri 3100 - L_ _ V _vises Other City taxes 204-33-3100 3050 Mobile Home Taxes 204-33-3100 3100 Utility Excise Tax tss use Or Money & 204-33-3100 3614 Interest - Savings Account r Of Money & Propenbi total irrercuuernme 204-33-3100 3335 Property Tax Replacement 0 - LiaDepartment - EXPENSE Department 33 - a_ Activity 3100 - Library S b 204-33-3100 1111 204-33-3100 1112 204-33-3100 1113 204-33-3100 1114 204-33-3100 1117 204-33-3100 1121 204-33-3100 1122 204-33-3100 1123 204-33-3100 1128 204-33-3100 1130 204-33-3100 1131 lees T4. REVENUE TOTALS Salaries - Regular Salaries - Part-time Longevity Pay Time & Half Pay Double Time Pay FICA - City Contribution IPERS - City Contribution Life & Disability Insurance Retirement Pay Employee Benefit Reimbursement Health Insurance Personal Services - Salaries X bee'r ry Library Levy Addtional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional Incr (Decr) from Amount Amount Amount Budget Budget 2020 Base Level Needs FY20 Base 1,083.56 1,083.99 23,914.96 22,977.59 653.48 1,000.00 11,044.05 22,484.00 1,000.00 1,000.00 1,000.00 .00 22,484.00 .00 .00 .00 $24,998.52 $24,061.58 712.22 1,867.43 $11,697.53 $23,484.00 1,561.77 400.00 $23,484.00 $1,000.00 400.00 2,500.00 $1,000.00 $0.00 2,500.00 .00 $712.22 $1,867.43 24,845.28 24,417.50 $1,561.77 $400.00 11,221.75 25,398.00 $400.00 $2,500.00 $2,500.00 $0.00 25,398.00 .00 .00 .00 $24,845.28 $24,417.50 $11,221.75 $25,398.00 $25,398.00 $0.00 $0.00 $0.00 $50,556.02 $50,346.51 $24,481.05 $49,282.00 $49,282.00 $3,500.00 $3,500.00 $0.00 $50,556.02 $50,346.51 $24,481.05 $49,282.00 $49,282.00 $3,500.00 $3,500.00 $0.00 $50,556.02 $50,346.51 $24,481.05 $49,282.00 $49,282.00 $3,500.00 $3,500.00 $0.00 388,245.77 376,805.51 199,088.44 425,471.00 417,671.00 442,026.00 436,075.00 (5,951.00) 25,839.89 22,721.26 10,080.35 22,632.00 30,432.00 30,432.00 22,632.00 (7,800.00) 7,527.74 7,480.17 3,457.75 9,294.00 9,294.00 9,150.00 9,150.00 .00 77.70 183.53 86.94 1,000.00 1,000.00 1,000.00 1,000.00 .00 15,755.81 16,498.02 6,697.74 18,150.00 18,150.00 18,150.00 18,150.00 .00 32,629.47 31,791.95 16,539.59 36,564.00 36,564.00 38,475.00 37,425.00 (1,050.00) 38,652.66 37,666.14 20,622.42 44,988.00 44,988.00 47,273.00 45,975.00 (1,298.00) 2,205.04 2,102.35 1,107.53 2,246.00 2,246.00 2,376.00 2,338.00 (38.00) 2,343.68 5,381.58 1,929.58 .00 .00 .00 .00 .00 1,401.63 1,180.64 2,163.30 1,402.00 1,402.00 2,175.00 2,175.00 .00 59,458.16 54,700.48 27,277.17 53,787.00 53,787.00 69,078.00 66,734.00 (2,344.00) $574,137.55 $556,511.63 $289,050.81 $615,534.00 $615,534.00 $660,135.00 $641,654.00 ($18,481.00) Run by Kim Bahr on 02/11/2019 14:35:38 PM Page 1 of 2 Gil_ Account - .._ 244 - L_ r EXPENSE Department 33-� Account Description bx Levy e cni -_ 3100 L__ -ices Totals Department 3 Library Totals EXPENSE TOTALS Fund 22 L_ ry _ax Levy Totals REVENUE TOTALS EXPENSE TOTALS 204 ax Le - Iota is bet Grana .ma_s REVENUE GRAND TOTALS EXPENSE GRAND TOTALS Frerarrana.0 s Library Levy Addtional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional Incr (Decr) from Amount Amount Amount Budget Budget 2020 Base Level Needs FY20 Base $574,137.55 $574,137.55 $574,137.55 $50,556.02 $574,137.55 $556,511.63 $556,511.63 $556,511.63 $50,346.51 $556,511.63 $289,050.81 $289,050.81 $289,050.81 $24,481.05 $289,050.81 $615,534.00 $615,534.00 $615,534.00 $49,282.00 $615,534.00 $615,534.00 $615,534.00 $615,534.00 $49,282.00 $615,534.00 $660,135.00 $660,135.00 $660,135.00 $3,500.00 $660,135.00 $641,654.00 $641,654.00 $641,654.00 $3,500.00 $641,654.00 ($18,481.00) ($18,481.00) ($18,481.00) $0.00 ($18,481.00) ($523,581.53) ($506,165.12) $50,556.02 $574,137.55 $50,346.51 $556,511.63 ($264,569.76) ($566,252.00) $24,481.05 $289,050.81 $49,282.00 $615,534.00 ($566,252.00) ($656,635.00) $49,282.00 $615,534.00 $3,500.00 $660,135.00 ($638,154.00) $18,481.00 $3,500.00 $0.00 $641,654.00 ($18,481.00) ($523,581.53) ($506,165.12) ($264,569.76) ($566,252.00) ($566,252.00) ($656,635.00) ($638,154.00) $18,481.00 Run by Kim Bahr on 02/11/2019 14:35:38 PM Page 2 of 2 :uoiruuojul punoi pong :spun3 Jo aaanos :pa.inboj aan4ipuadx3 :4uau oini.s Iauununs :uoiay papuomm000> Submitted By: Kent Shankle, Cultural and Arts Director aDdfflnS aQ sl -TV put i1Jin3 OZOZgx3 alp Jo uoitutuasaid 0 0 0 uorgduosou S L1��I�iH��ZZy s IaMaIAaa Presentation of the FYE2020 Cultural and Arts Department budget. Missio History Arts programs located in Washington School 966 Recreaton & Arts Center opens 968 Junior Art Gager/ established X976 East ono ad t n co p ted 999 Rec Center rededicated as Center For the Arts 2008 Phe i s Youth Pavilion opens Under the auspices of the Waterloo Center for the Arts, the cultural & Arts Department provides fres & low-cost cultural opportunities and amenities for citizens of all ages Cultural & Q►rts programs improve quality of life in the Cedar Valley, draw visitors to Waterloo and create positive economic impacts 8 served visitors hosted or presented programs & events 1.l • served a63 children & parents in e Phelps Youth Pavilion prescnted 36 exhibitions at WDA and locations in the community • added more than 0 works of art to the permanent collection • art exhibitions • classes, workshops & lectures • concerts, dance & theatrical performances • festivals & cultural celebrations • facilities for civic functions, private & community events WDA sees audient:es, youth through seniors, with programs accessible to all regardless of income fo se a i - e- a of es, e s special events for youth t i- - S a eat at a o tstanding permanent art colection )O ai a Bele Cu tur f s Fiesta de Mayo Stem Stein River o p Rhythms Cinema on the Cedar Holiday Arts Festival Mayor's Fireworks Celebration World's Greatest Spring Break Waterloo Community Schools EMBARC Bosnian Cultural Association 0 Hartman Reserve Hawkeye Community College 0 Grout Museums University of Northern Iowa * silos & Smokestacks Waterloo Municipal Band * Main Street Waterloo Waterloo Cedar - alls Symphony* Girl Scouts Waterloo Community Playhouse ® Kud Lo Riv rLo p Association ®Youth Art Team Black Hawk Children's Theater * & many more Cultural & Arts Director Marketing/Development Coordinator r Curator Education Coordinator Bookkeeper Events Coordinator Registrar Technician/?reparator Oraan=national Chart Youth Pavilion Manager Yptith a Contractual Class/Program instructors Facilities Seryices Manager Facilities Services Specialist menance Evening/Week 8 Budget Performance expenses: Revenues: $ Tax Support: i,66i 182 e e_ FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 26 Cultural/Arts Commission ACTIVITY: 4208 Youth Pavilion DEPARTMENT/ACTIVITY DESCRIPTION: The Phelps Youth Pavilion's mission is to provide interactive experiences where art launches a world of wonder, discovery and learning. Our marketing goals are to be the "top of mind" source for family entertainment and to attract 25,000 patrons each year. The 39,000 square -foot facility includes three interactive galleries for youth, ceramics and 2-D studios, an arts workshop, digital arts lab, gift store, cafe, and collection management facilities. DEPARTMENT/ACTIVITY OBJECTIVES: Provide permanent and changing exhibitions. Provide state of the art storage, security, environmental control and collection care resources. Provide three interactive youth galleries with multiple discovery areas for community youth. Plan, promote and deliver classes, workshops and a birthday party program; increasing participation by 5%. Upgrade/update permanent exhibits in YP galleries. Continue and expand the partnership with Hawkeye Community College, Scouts and other community organizations. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 Development Marketing Manager 1 1 1 1 1 Facilities Services Manager 1 1 1 1 0 Education Coordinator 1 1 1 1 1 Youth Pavilion Manager 1 1 1 1 1 Technician/Preparator 1 1 1 1 1 Facilities Services Specialist II 0 0 0 0 1 TOTAL FULL-TIME EQUIVALENT POSITIONS 5 5 5 5 5 0 * AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 26 Cultural/Arts Commission ACTIVITY: 4250 Center for the Arts DEPARTMENT/ACTIVITY DESCRIPTION: Besides offering a wide range of programming for preschool through senior adult, the Waterloo Center for the Arts (WCA) is home to the Phelps Youth Pavilion, the Waterloo Community Playhouse, Black Hawk Children's Theatre, Waterloo Municipal Band, NAMI Care and Senior Singers. 23 community organizations and hobby groups meet at WCA on a regular basis. Other groups and individuals use WCA for one-time events such as wedding receptions, meetings, conferences, parties, dances and expositions. The Waterloo Cultural and Arts Commission's mission is to serve the community by ensuring quality cultural and educational opportunities for all citizens. WCA offers a full range of programs that include exhibits, educational/interpretive programs for all ages in the center and out in the community, care and display of a significant permanent art collection, special events, a gift shop and an active volunteer program. DEPARTMENT/ACTIVITY OBJECTIVES: See page 2. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 Director 1 1 1 1 1 Curator 1 1 1 1 1 Building Manager 0 0 0 0 0 Facilities Services Specialist 1 1 1 1 1 Bookkeeper 1 1 1 1 1 Registrar 1 1 1 1 1 Maintenance I 1 1 1 1 0 Events Coordinator 1 1 1 1 1 Visitor Services Manager 1 0.475 ** ** 0 Digital Arts Manager 1 1 0 0 0 Facilities Services Manager 0 0 0 0 1 TOTAL FULL-TIME EQUIVALENT POSITIONS 9 8.475 7 7 7 0 **POSITION MOVED TO PART TIME *AT CURRENT FYE19 STAFFING LEVEL Page 1 of 2 FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 26 Cultural/Arts Commission ACTIVITY: 4250 Center for the Arts DEPARTMENT/ACTIVITY DESCRIPTION: See page t DEPARTMENT/ACTIVITY OBJECTIVES: Provide more than 150 arts programs for preschool through senior adult including, film, performance, lecture, tours, symposia and special events. Expand outreach programs in and around the community. Provide volunteer opportunities for 400+ people. Present 25+ exhibitions in the Center and out in the community. Add at least one artwork from each significant feature exhibition to the permanent collection when appropriate. Solicit gifts to the collection and continue to build collections of Midwest, Haitian, Mexican Folk, International Folk and American Decorative Arts, House/partner with community arts organizations (WCP/BHCT, Waterloo Municipal Band, etc.). Serve the community by providing a place to meet, recreate, learn and experience cultural enrichment. Provide in-kind service to community groups and schools. Provide a cultural exploration/literacy program for all K-8 grades. Provide educational programs in a range of art media including ceramics and digital arts. Provide programs and services to special needs patrons. Expand marketing, including use of social media, to grow participation in Center activities. Diversify our funding base to support WCA programs and activities. Provide high quality visitor experiences through comfortable, well-maintained and outfitted facilities, clear wayfinding tools and a courteous and professional staff. Improve data management systems including implementation of online program registration. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 See page 1. TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0 0 0 0 0 *AT CURRENT FYE19 STAFFING LEVEL Page 2 of 2 FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 26 Cultural/Arts Commission ACTIVITY: 4251 River Loop Event Facilities DEPARTMENT/ACTIVITY DESCRIPTION: As part of its operations, the Waterloo Center for the Arts manages the Waterloo Boat House, making it available for rent to groups and individuals looking for a unique facility for meetings and events. DEPARTMENTIACTIVITY OBJECTIVES: Provide a unique, clean and safe community gathering place for meetings, public programs and celebrations. Effectively promote the space as a prime destination for business/civic meetings, retreats, reunions, birthday parties, anniversary celebrations, retirement parties, graduation open houses, weddings/wedding receptions, holiday parties and other functions. Book more than 80 events throughout the year. Increase rental revenues by 10%. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0 0 0 0 0 * AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 26 Cultural/Arts Commission ACTIVITY: 4265 Cultural Arts Projects DEPARTMENT/ACTIVITY DESCRIPTION: This activity is funded by non -property sources such as donations, state grants and hotel -motel tax grants. DEPARTMENT/ACTIVITY OBJECTIVES: PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020* DEPT REQUEST FYE2020 CERTIFIED FYE2020 TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0 0 0 0 0 * AT CURRENT FYE19 STAFFING LEVEL G/L Account Account Description Fund 010 - Genera_ Fun REVENUE Department _ 2 - Cu _ag_ _ _ Com _ _ n Acttm 2208 - Youth P _non Use OF flOney C.-4 Property 010-26-4208 3620 Rent & Property Leases Lase Of Money & Property Totals CULTURAL ARTS Additional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted Amount Amount Amount Budget Budget 2020 Base Level 4,800.00 4,400.00 5,800.00 4,800.00 4,800.00 4,800.00 2020 Additional [ncr (Decr) to FY20 Needs Base 4,800.00 .00 $4,800.00 $4,400.00 $5,800.00 $4,800.00 $4,800.00 $4,800.00 $4,800.00 $0.00 Charges tor Fees &z Service 010-26-4208 3487 Gift Shop Revenue 6,619.14 9,733.55 4,266.29 9,000.00 9,000.00 9,000.00 9,000.00 .00 010-26-4208 3832 Admissions 62,644.53 71,229.50 35,213.51 59,000.00 59,000.00 59,000.00 65,000.00 6,000.00 010-26-4208 3833 Special Event Fee 6,028.50 5,917.00 3,259.00 5,500.00 5,500.00 5,500.00 5,500.00 .00 010-26-4208 3873 Reimbursement for Service 10,025.50 11,685.58 739.00 10,000.00 10,000.00 10,000.00 10,000.00 .00 Charges %=ar Fees & Ser a total: $85,317.67 $98,565.63 $43,477.80 $83,500.00 $83,500.00 $83,500.00 $89,500.00 $6,000.00 Comments Auuaunt Levet 3832 Base Level Comment rrr{gent increase based on projection trend 010-26-4208 3830 Unrestricted Gifts orribu i ns Donal -ions - are Sources Totals l Acriviry 4208 -Yom AchedAched& 6250 - Canter for the s Charges ter Fees & Sencee on 33.50 5.00 .00 .00 .00 .00 .00 .00 $33.50 $5.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $90,151.17 $102,970.63 $49,277.80 $88,300.00 $88,300.00 $88,300.00 $94,300.00 $6,000.00 010-26-4250 3486 Sale of Crafts 7,665.95 5,657.50 6,333.23 7,500.00 7,500.00 7,500.00 7,500.00 .00 010-26-4250 3623 Facility Rental Fee 86,398.42 117,084.22 50,752.88 89,079.00 89,079.00 89,079.00 95,079.00 6,000.00 010-26-4250 3831 Registration Fee 20,133.01 21,914.50 11,541.75 24,000.00 24,000.00 24,000.00 24,000.00 .00 010-26-4250 3873 Reimbursement for Service .00 95.57 700.00 .00 .00 .00 .00 .00 010-26-4250 3875 Salary Reimbursement 7,597.70 9,542.20 4,777.57 15,000.00 15,000.00 15,000.00 15,000.00 .00 Charuesl rFees & -o totals $121,795.08 $154,293.99 $74,105.43 $135,579.00 $135,579.00 $135,579.00 $141,579.00 $6,000.00 Account never 3623 Base Level COMMent increase based on projection trend Miscellaneous =llaneou Revenue 010-26-4250 3800 Miscellaneous Revenue miscellaneous oe ue 7orals 1,366.49 35.11 1.35 .00 .00 .00 .00 .00 $1,366.49 $35.11 $1.35 $0.00 $0.00 $0.00 $0.00 $0.00 Run by Kim Bahr on 02/07/2019 13:18:53 PM Page 1 of 7 CULTURAL ARTS Additional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted G/L Account Account Description Amount Amount Amount Budget Budget 2020 Base Level Fund 010 - Genera_ Fun REVENUE Department 26 - Cu _ag_ a_/ _ Com Scum $250 - Center for the Arts ontributr r e =Y Donations - Private Sources 010-26-4250 3830 Unrestricted Gifts Coati/butMns & Donations - Prive-iL �a�r ores z total. Activity 425 Center for the Arts Totals Activity 4251 - RiverLoou _ Charges tor Fees =r1 r F 010-26-4251 3623 Facility Rental Fee gorges Fr Fees & Semi&Arta 2020 Additional [ncr (Decr) to FY20 Needs Base 46.89 7.92 .00 .00 .00 .00 .00 .00 $46.89 $7.92 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $123,208.46 $154,337.02 22,730.00 12,802.50 $74,106.78 $135,579.00 6,631.25 20,000.00 $135,579.00 $135,579.00 20,000.00 20,000.00 $141,579.00 $6,000.00 20,000.00 .00 $22,730.00 $12,802.50 $6,631.25 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $0.00 A= ,v.av 425 _sena Far__a_es DAP n $22,730.00 $12,802.50 $6,631.25 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $0.00 Ae t, -y =265 - CD_tnon_/Ass Counts & to ett etFr CM' ranee- 010-26-4265 angy=010-26-4265 3111 Hotel/Motel Tax 19,122.00 22,299.00 .00 21,542.00 .00 18,643.00 18,643.00 .00 nonen vir. lasso 1orals $19,122.00 $22,299.00 $0.00 $21,542.00 $0.00 $18,643.00 $18,643.00 $0.00 F rat =r -r -t & F }t, b; = r ten=s 010-26-4265 3373 Federal Pass-Thru From Iowa 15,000.00 15,000.00 20,000.00 20,000.00 15,000.00 15,000.00 15,000.00 .00 010-26-4265 3375 Federal Pass-Thru From Other 18.98 .00 .00 .00 .00 .00 .00 .00 F 7 r&t Scantys . r it,,, e met h; f ral $15,018.98 $15,000.00 $20,000.00 $20,000.00 $15,000.00 $15,000.00 $15,000.00 $0.00 010-26-4265 3873 Reimbursement for Service .00 1,958.16 .00 .00 .00 .00 .00 .00 a/ o s far Fetes See t t t t $0.00 $1,958.16 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Contratertans & Dear t erta - Pr& AreSr_nettes 010-26-4265 3720 Restricted Donations 11,400.00 20,000.00 Centributrene L Deracitans - Pr& ote Sail&a rpt la $11,400.00 $20,000.00 Other Finan rr, :Sources 010-26-4265 3000 Cash on Hand A _ .tial 4265 - 3,028.70 8,000.00 8,000.00 8,000.00 8,000.00 .00 $3,028.70 $8,000.00 $8,000.00 $8,000.00 $8,000.00 $0.00 .00 .00 .00 12,000.00 12,000.00 12,000.00 12,000.00 .00 $0.00 $0.00 $0.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00 $0.00 $45,540.98 $59,257.16 $23,028.70 $61,542.00 $35,000.00 $53,643.00 $53,643.00 $0.00 Run by Kim Bahr on 02/07/2019 13:18:54 PM Page 2 of 7 G/L Account Account Description .._ 010 - Genera_ Fun REVENUE Deparm AAA. IArts Commission oza EXPENSE Department 26 - Cu_t _/ Go _ Ac_ viti 4208 - Youth Pavilion PersonanSensices = Salaries & Benefits 010-26-4208 1111 010-26-4208 1112 010-26-4208 1113 010-26-4208 1114 010-26-4208 1121 010-26-4208 1122 010-26-4208 1123 010-26-4208 1128 010-26-4208 1130 010-26-4208 1131 REVENUE TOTALS Salaries - Regular Salaries - Part-time Longevity Pay Time & Half Pay FICA - City Contribution IPERS - City Contribution Life & Disability Insurance Retirement Pay Employee Benefit Reimbursement Health Insurance Persona/ Services - Salaries & Benefits Tota Contractual Sett 010-26-4208 1319 010-26-4208 1343 010-26-4208 1350 010-26-4208 1351 010-26-4208 1353 010-26-4208 1371 010-26-4208 1378 010-26-4208 1390 010-26-4208 1391 010-26-4208 1400 fommosSues 010-26-4208 1504 010-26-4208 1521 Other Professional Services Postage & Mailing Expense Exhibition Expenses Advertising Expense Printing Services Building & Grounds Maintenance Other Equipment Repair & Maintenance Other Contractual Services Dues & Memberships Utility Service LIYHT Credit Card Fees Electrical Supplies 2017 Actual Amount 2018 Actual Amount CULTURAL ARTS Additional Needs Level 2019 Actual Amount 2019 Amended 2019 Adopted Budget Budget 2020 Base Level 2020 Additional [ncr (Deer) to FY20 Needs Base $281,630.61 $329,367.31 $153,044.53 $305,421.00 $278,879.00 $297,522.00 $309,522.00 $12,000.00 $281,630.61 177,940.83 40,934.88 83.08 .67 16,491.13 17,051.88 1,153.36 .00 465.37 62,678.00 $329,367.31 192,392.83 44,215.44 540.02 26.94 17,932.72 19,241.78 1,203.19 1,624.51 406.18 65,100.00 $153,044.53 89,437.53 22,926.58 270.01 .54 8,561.55 10,029.51 571.65 .00 1,239.47 26,940.00 $305,421.00 202,946.00 37,500.00 900.00 100.00 18,570.00 22,792.00 1,254.00 .00 1,300.00 75,960.00 $278,879.00 202,946.00 37,500.00 900.00 100.00 18,570.00 22,792.00 1,254.00 .00 1,300.00 75,960.00 $297,522.00 194,604.00 39,970.00 1,620.00 100.00 18,183.00 22,306.00 1,198.00 .00 1,300.00 55,680.00 $309,522.00 194,604.00 39,970.00 1,620.00 100.00 18,183.00 22,306.00 1,198.00 .00 1,300.00 55,680.00 $12,000.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 $316,799.20 1,500.00 2,500.00 8,689.78 3,766.53 212.25 1,948.39 1,102.54 1,563.44 800.00 24,491.27 $342,683.61 2,494.80 2,500.00 8,543.14 3,270.85 1,517.75 2,396.19 925.00 1,466.78 800.00 24,999.19 $159,976.84 400.00 950.00 975.11 582.11 90.75 376.66 210.00 300.00 .00 13,120.65 $361,322.00 2,500.00 2,500.00 6,000.00 3,500.00 1,000.00 2,500.00 1,200.00 1,500.00 800.00 25,000.00 $361,322.00 2,500.00 2,500.00 6,000.00 3,500.00 1,000.00 2,500.00 1,200.00 1,500.00 800.00 25,000.00 $334,961.00 2,500.00 2,500.00 6,000.00 3,500.00 1,000.00 2,500.00 1,200.00 1,500.00 800.00 25,000.00 $334,961.00 2,500.00 2,500.00 6,000.00 3,500.00 1,000.00 3,000.00 3,200.00 1,500.00 800.00 25,000.00 $0.00 .00 .00 .00 .00 .00 500.00 2,000.00 .00 .00 .00 $46,574.20 4,125.55 1,958.81 $48,913.70 4,382.33 1,498.62 $17,005.28 1,830.69 155.45 $46,500.00 3,624.00 1,000.00 $46,500.00 3,624.00 1,000.00 $46,500.00 3,624.00 1,000.00 $49,000.00 $2,500.00 4,624.00 1,000.00 1,000.00 .00 Run by Kim Bahr on 02/07/2019 13:18:54 PM Page 3 of 7 Gil_ Account Fund 010 - Genera_ EXPENSE -__epa _Mien_ 2 - ACEIVI ,f $208 Commodities 010-26-4208 1524 010-26-4208 1539 010-26-4208 1541 010-26-4208 1549 010-26-4208 1553 010-26-4208 1561 010-26-4208 1563 010-26-4208 1579 010-26-4208 1581 010-26-4208 1710 Account Description Fun Cu hots Com - Youth P Workshop & Class Supplies Institutional Supplies Janitorial Supplies Lumber/Wood & Insulation Merchandise for Resale Office Supplies & Minor Equipment Photo & Video Equipment & Supplies Uniforms Paint & Paint Supplies Claims, Judgments & Contingencies r,t=-,atties oral_ Activity 4208 - =a •- n To Activity 4250 - Center for the A s 010-26-4250 1111 010-26-4250 1112 010-26-4250 1113 010-26-4250 1114 010-26-4250 1121 010-26-4250 1122 010-26-4250 1123 010-26-4250 1128 010-26-4250 1130 010-26-4250 1131 Salaries - Regular Salaries - Part-time Longevity Pay Time & Half Pay FICA - City Contribution IPERS - City Contribution Life & Disability Insurance Retirement Pay Employee Benefit Reimbursement Health Insurance Personal Services Salari,s & Bel its 7°1 -Ns Conti -actual SellIces 010-26-4250 1314 010-26-4250 1319 010-26-4250 1343 Health Services Other Professional Services Postage & Mailing Expense 2017 Actual Amount 2,982.91 2,480.23 2,978.58 960.55 3,794.01 1,951.85 968.59 440.00 951.50 .00 2018 Actual Amount 2,995.18 2,471.24 2,999.49 963.69 6,350.91 1,498.62 999.66 503.98 .00 .00 CULTURAL ARTS Additional Needs Level 3 Fe, area 2019 Actual Amount 2,003.97 347.60 849.59 540.20 2,905.47 383.92 365.00 .00 135.61 75.00 2019 Amended 2019 Adopted Budget Budget 2020 Base Level 3,000.00 2,500.00 3,000.00 1,000.00 5,000.00 2,000.00 1,000.00 500.00 1,000.00 .00 3,000.00 2,500.00 3,000.00 1,000.00 5,000.00 2,000.00 1,000.00 500.00 1,000.00 .00 3,000.00 2,500.00 3,000.00 1,000.00 5,000.00 2,000.00 1,000.00 500.00 1,000.00 .00 2020 Additional [ncr (Decr) to FY20 Needs Base 3,500.00 3,000.00 3,000.00 1,000.00 5,000.00 2,000.00 1,000.00 500.00 1,000.00 .00 500.00 500.00 .00 .00 .00 .00 .00 .00 .00 .00 $23,592.58 $24,663.72 $9,592.50 $23,624.00 $23,624.00 $23,624.00 $25,624.00 $2,000.00 $386,965.98 $416,261.03 $186,574.62 $431,446.00 $431,446.00 362,670.69 338,444.45 131,084.41 329,659.00 329,659.00 49,201.13 59,151.55 41,263.18 92,636.00 92,636.00 5,339.88 5,441.52 2,125.32 4,040.00 4,040.00 .54 286.58 621.65 300.00 300.00 31,868.63 31,160.65 14,325.67 33,577.00 33,577.00 34,811.44 35,392.77 16,244.84 40,272.00 40,272.00 2,277.29 2,104.02 837.82 2,031.00 2,031.00 .00 6,472.11 8,998.84 8,000.00 8,000.00 5,461.82 2,838.31 4,758.24 4,285.00 4,285.00 98,549.00 87,010.00 37,761.68 94,500.00 94,500.00 $405,085.00 342,825.00 90,466.00 4,620.00 300.00 33,850.00 41,366.00 2,114.00 .00 4,285.00 97,680.00 $409,585.00 342,825.00 90,466.00 4,620.00 300.00 33,850.00 41,366.00 2,114.00 .00 4,285.00 97,680.00 $4,500.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 $590,180.42 .00 7,247.00 2,560.48 $568,301.96 $258,021.65 65.00 .00 7,096.13 4,150.00 2,902.39 1,116.07 $609,300.00 .00 7,200.00 2,700.00 $609,300.00 .00 7,200.00 2,700.00 $617,506.00 .00 7,200.00 2,700.00 $617,506.00 .00 8,200.00 2,700.00 $0.00 .00 1,000.00 .00 Run by Kim Bahr on 02/07/2019 13:18:54 PM Page 4 of 7 CULTURAL ARTS Additional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional [ncr (Decr) to FY20 G/L Account Account Description Amount Amount Amount Budget Budget 2020 Base Level Needs Base Fund 010 - Genera_ Fun EXPENSE Department _ 26 - CF _ag_ _/ _ Com, Act irp $250 - Center for too Arts Contractual Sen-Afes 010-26-4250 1344 Telephone & Fax Expense 888.00 814.00 370.00 900.00 900.00 900.00 900.00 .00 010-26-4250 1353 Printing Services 401.25 935.52 161.00 1,000.00 1,000.00 1,000.00 1,000.00 .00 010-26-4250 1371 Building & Grounds Maintenance 3,682.85 4,776.18 993.89 3,400.00 3,400.00 3,400.00 3,900.00 500.00 010-26-4250 1376 Office Equipment Repair & Maintenance 4,067.34 4,976.51 2,687.97 4,100.00 4,100.00 4,100.00 5,100.00 1,000.00 010-26-4250 1378 Other Equipment Repair & Maintenance 1,365.08 1,703.52 460.00 1,400.00 1,400.00 1,400.00 3,400.00 2,000.00 010-26-4250 1385 Office Equip Repair & Maintenance 513.90 697.06 500.00 700.00 700.00 700.00 700.00 .00 010-26-4250 1390 Other Contractual Services 2,525.10 1,129.50 267.00 5,500.00 5,500.00 5,500.00 5,500.00 .00 010-26-4250 1391 Dues & Memberships 965.00 1,135.00 385.00 1,000.00 1,000.00 1,000.00 1,000.00 .00 010-26-42501392 Subscriptions .00 228.48 .00 250.00 250.00 250.00 250.00 .00 010-26-4250 1400 Utility Service 50,421.25 52,392.12 26,241.06 51,500.00 51,500.00 51,500.00 51,500.00 .00 t'ice 'orals $74,637.25 $78,851.41 $37,331.99 $79,650.00 $79,650.00 $79,650.00 $84,150.00 $4,500.00 a. 'r i7i77odittes 010-26-4250 1504 Credit Card Fees 1,927.90 3,078.32 2,281.21 3,600.00 3,600.00 3,600.00 4,600.00 1,000.00 010-26-4250 1520 Computer Software .00 2,562.29 .00 2,562.00 2,562.00 2,562.00 2,562.00 .00 010-26-4250 1521 Electrical Supplies 1,179.62 1,296.82 323.38 1,000.00 1,000.00 1,000.00 1,000.00 .00 010-26-4250 1524 Workshop & Class Supplies 4,817.37 3,477.18 782.83 4,300.00 4,300.00 4,300.00 4,800.00 500.00 010-26-4250 1533 Fuel Expense 834.05 1,472.02 563.05 1,350.00 1,350.00 1,350.00 1,350.00 .00 010-26-4250 1535 Hardware Items 468.71 587.01 33.14 600.00 600.00 600.00 600.00 .00 010-26-4250 1537 Horticultural & Landscaping Supplies 476.60 64.00 .00 500.00 500.00 500.00 500.00 .00 010-26-4250 1539 Institutional Supplies 6,582.84 4,406.99 2,691.83 4,750.00 4,750.00 4,750.00 5,250.00 500.00 010-26-4250 1541 Janitorial Supplies 3,805.77 4,486.62 2,852.46 4,500.00 4,500.00 4,500.00 4,500.00 .00 010-26-4250 1549 Lumber/Wood & Insulation 700.73 275.41 270.27 300.00 300.00 300.00 300.00 .00 010-26-4250 1551 Drugs/Medicines & Medical/Lab Supplies .00 .00 .00 100.00 100.00 100.00 100.00 .00 010-26-4250 1561 Office Supplies & Minor Equipment 3,426.27 1,977.41 1,343.77 2,987.00 2,987.00 2,987.00 2,987.00 .00 010-26-4250 1563 Photo & Video Equipment & Supplies 3,015.73 3,283.03 1,496.44 1,500.00 1,500.00 1,500.00 1,500.00 .00 010-26-4250 1564 Equipment Rental 439.78 401.59 102.70 500.00 500.00 500.00 500.00 .00 010-26-42501579 Uniforms 411.84 .00 .00 500.00 500.00 500.00 500.00 .00 010-26-4250 1581 Paint & Paint Supplies 302.06 539.56 .00 600.00 600.00 600.00 600.00 .00 010-26-4250 1785 Refund Payments 2,053.99 2,089.00 756.00 1,000.00 1,000.00 1,000.00 1,500.00 500.00 Run by Kim Bahr on 02/07/2019 13:18:55 PM Page 5 of 7 CULTURAL ARTS Additional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted Gil_ Account Account Description Amount Amount Amount Budget Budget 2020 Base Level Fund 010 - Genera_ Fun EXPENSE Department _ 26 - Ct tots Com, _ _ n Act/my 4250 - Center for the Arts Convonotnes ,f _alities Total Activity 4251 - Riven oop Event � Persona/ Services - Salaries & Benefito 2020 Additional [ncr (Decr) to FY20 Needs Base $30,443.26 $29,997.25 $13,497.08 $30,649.00 $30,649.00 $30,649.00 $33,149.00 $2,500.00 $695,260.93 $677,150.62 $308,850.72 $719,599.00 $719,599.00 $727,805.00 $734,805.00 $7,000.00 010-26-4251 1112 Salaries - Part-time 4,878.10 2,900.04 3,171.13 4,400.00 4,400.00 4,662.00 4,662.00 .00 010-26-4251 1121 FICA - City Contribution 373.20 221.87 242.57 336.00 336.00 356.00 356.00 .00 010-26-4251 1122 IPERS - City Contribution 261.65 6.26 128.71 .00 .00 .00 .00 .00 Persona/ Bemires _ &Varies & Benet7ts Totals $5,512.95 $3,128.17 $3,542.41 $4,736.00 $4,736.00 $5,018.00 $5,018.00 $0.00 Contractual Sera & 010-26-4251 1371 Building & Grounds Maintenance 334.84 434.98 (163.06) 500.00 500.00 500.00 500.00 .00 010-26-4251 1378 Other Equipment Repair & Maintenance 2,132.11 1,684.05 1,315.45 1,332.00 1,332.00 1,332.00 1,332.00 .00 010-26-4251 1400 Utility Service 4,366.05 5,636.67 2,256.70 5,000.00 5,000.00 5,000.00 5,000.00 .00 ContracruxSe c tragi $6,833.00 $7,755.70 $3,409.09 $6,832.00 $6,832.00 $6,832.00 $6,832.00 $0.00 Commodines 010-26-4251 1541 Janitorial Supplies 500.00 62.97 .00 500.00 500.00 500.00 500.00 .00 010-26-4251 1785 Refund Payments 1,480.00 250.00 912.50 1,000.00 1,000.00 1,500.00 2,000.00 500.00 Etn r r -n totes $1,980.00 $312.97 $912.50 $1,500.00 $1,500.00 $2,000.00 $2,500.00 $500.00 Act v„ 4251 AlverLaap Event Fac 4 5 t $14,325.95 $11,196.84 $7,864.00 $13,068.00 $13,068.00 $13,850.00 $14,350.00 $500.00 A`: vizy 4265 - Co cora /Arts Sr 010-26-4265 1112 Salaries - Part-time 738.98 .00 .00 .00 .00 18,643.00 18,643.00 .00 Persona/ "SPA/ e I -es _Saiarics & ears Incas $738.98 $0.00 $0.00 $0.00 $0.00 $18,643.00 $18,643.00 $0.00 Contractual er vice, 010-26-4265 1319 Other Professional Services .00 .00 .00 750.00 750.00 750.00 750.00 .00 010-26-4265 1337 Collection Conservation 4,981.00 463.00 2,433.93 4,460.00 4,460.00 4,460.00 4,460.00 .00 010-26-4265 1346 Travel - Professional Training 605.90 6,172.23 1,711.55 7,040.00 7,040.00 7,040.00 7,040.00 .00 Run by Kim Bahr on 02/07/2019 13:18:56 PM Page 6 of 7 CULTURAL ARTS Additional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted G/L Account Account Description Amount Amount Amount Budget Budget 2020 Base Level Fund 010 - Genera_ Fun EXPENSE Department _ 26 - Cs, _ Arts Com _ _ n Aomori $265 - Cu_tn'a_/A s Gants Contractual en-Ae 010-26-4265 1349 010-26-4265 1350 010-26-4265 1351 010-26-4265 1390 Peptic/ 55515c 010-26-4265 2127 2020 Additional [ncr (Decr) to FY20 Needs Base Visiting Artist Expense 550.00 1,150.00 .00 750.00 750.00 750.00 750.00 .00 Exhibition Expenses 5,349.68 4,183.34 .00 5,000.00 5,000.00 5,000.00 5,000.00 .00 Advertising Expense 19,121.61 22,690.60 11,841.81 21,542.00 .00 .00 .00 .00 Other Contractual Services 9,765.63 17,766.15 5,940.93 22,000.00 17,000.00 17,000.00 17,000.00 .00 Contractual SeccCes Totals $40,373.82 $52,425.32 $21,928.22 $61,542.00 $35,000.00 $35,000.00 $35,000.00 $0.00 Photo & Video Equipment Cltl _7 4265 - Arts Gnunt otais 2 C tonal/AM tdo t _prat EXPENSE TOTALS _11 010- Genera= Fund Fatus REVENUE TOTALS EXPENSE TOTALS 01 - Genera_ F :uozluuuojul punoBvng :spun3 Jo aaano5 :pa.inboj aanhpuadx3 auauzalul S i.Iuu uin S :uozlay papuaunti000> g pa?aiq S E \ :J JfflnS G SIV OZOZgx3 auiJo uoiluluasaid 0 0 0 uorlduosaa S L1��I�iH��ZZy • S2IaMaIAa a Presentation of the FYE2020 MIS Department budget. ec no ogy Services (Management Information Systems) } ss �\ � ° )on Sta e ent � � d S•t ) m (! Depa tment Staff \n tea; eche, Iowa City - Asses - deer 'A Access Atm G-aveld si Customers L 1 it �,. O �(% z; , „ (10 ri =g1 IT assets management & planning Services Geographic Information Systems Management in ear ��� � UM _ 3p �f, 2 ! r ,o ,GG SQ 6 JCG areas Q UpgE3 ft o Year in Review SALL nrei_i ram^ _ is per meg goers gg now an gws rear pcoming Projects pcomIng nni Stri_ICV UD __ 6 YO 0 Bu get FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 01 Mayor ACTIVITY: 8220 Administrative Services/MIS Technology Services (MIS) DEPARTMENT/ACTIVITY DESCRIPTION: The Technology Services department maintains the City's computers, network, communications, and other technology under the direction of the Director of Technology Services DEPARTMENT/ACTIVITY OBJECTIVES: Operate a technology replacement program to continually refresh computers, servers, printers/copiers, software and other technology. Respond to technology requests from all departments. Respond to issues, evaluate and recommend new technology on a departmental level. Provide applicable training resources for staff as needed. Evaluate software and hardware needs and either recommend and implement or provide custom solutions across the enterprise. Maintain and stay current with trends concerning the City's telecommunication systems. Install, maintain and improve the City's network infrastructure and provide for secure network access, both internally and externally. Continue to improve the security of the City's network while providing "as needed" access to the City's employees and vendors for systems support. Scale and leverage server virtualization to enable infrastructure to be refreshed as needed and allow for agile response to the City's needs. Work with building maintenance staff to evaluate, recommend and implement security solutions including cameras, video recorders and access (card reader) systems throughout the city buildings and public areas. For FY2020, the Technology Services department will continue to work on updating the City's aging cabling network. Expansion of the fiber optic infrastructure both internally (city buildings) and throughout the city. Expansion of the fiber optic network is crucial to the city's growing technology needs. Continue working with the traffic department to create infrastructure to allow expansion of the city's traffic camera system to enhance public safety. Continue to grow the City's Geographic Information System (GIS) technologies to provide City employees better infrastructure -mapping capabilities and allow for location based decision planning. Review printing and copying needs and make recommendations to achieve better efficiencies and lower the cost per page (print and copy) Review and create policies as needed to ensure data security and compliance with all rules and regulations. PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020* DEPT REQUEST FYE2020 CERTIFIED FYE2020 IT Director 1 1 1 1 1 Programmer Analyst 1 1 1 1 1 GIS Specialist 0.5 TOTAL FULL-TIME EQUIVALENT POSITIONS 2 2 2 2 2.5 0 * AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 01 Mayor (Information Technology) ACTIVITY: 8222 Administrative Services/MIS Chargebacks DEPARTMENT/ACTIVITY DESCRIPTION: This activity is used to record revenue received from the Sewer fund for various services provided to that fund by the Administrative Services/Management Information Systems department. DEPARTMENT/ACTIVITY OBJECTIVES: PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020 * DEPT REQUEST FYE2020 CERTIFIED FYE2020 TOTAL FULL-TIME EQUIVALENT POSITIONS 0 0 0 0 0 0 * AT CURRENT FYE19 STAFFING LEVEL FYE2020 BUDGET ACTIVITY NARRATIVE FUND: 010 General DEPARTMENT: 01 Mayor Technology Services (MIS) ACTIVITY: 8150 Public Access Studio DEPARTMENTIACTIVITY DESCRIPTION: This activity provides for the management and operation of the Public Access Studio and written policies for the public access channel and studio. DEPARTMENT/ACTIVITY OBJECTIVES: To provide individuals, groups and organizations an opportunity to deliver a message, an opinion, or other communication to the citizens of Waterloo. To provide access to designated facilities and equipment for transmission of television programs on the Public Access Channel. To monitor equipment and studio use and establish guidelines for Public Access Users. To provide technological support to cablecast all City Council meetings, Planning, Programming and Zoning Commission meetings, Board of Adjustment meetings, and other assistance as needed by Mayor, City Council and City departments in providing information to citizens. To observe the operations of cable television providers and make recommendations to the City Council concerning cable television operations. To update, maintain, and create content for the City of Waterloo webpage. The intended use of the Waterloo Public Access drone technology is to provide aerial video footage and photography of special projects and development, mapping, training, visual access to hard to reach areas for purpose of inspection and monitoring, and other applications benefitting the public interest through the efficient use of this City resource. For FY2020, an emphasis on getting out to city departments and the community to obtain and distribute information in a visually creative medium that is otherwise not being disseminated, PERSONNEL SUMMARY: FULL-TIME EQUIVALENT POSITIONS: CERTIFIED FYE2017 CERTIFIED FYE2018 CERTIFIED FYE2019 PROPOSED FYE2020* DEPT REQUEST FYE2020 CERTIFIED FYE2020 Cable TV Production Coordinator 1 1 1 1 1 Assistant Cable TV Production Coordinator 1 1 1 1 1 TOTAL FULL-TIME EQUIVALENT POSITIONS 2 2 2 2 2 0 * AT CURRENT FYE19 STAFFING LEVEL MIS Additional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted 2020 Additional [ncr (Decr) to FY20 G/L Account Account Description Amount Amount Amount Budget Budget 2020 Base Level Needs Base Fund 010 - Genera_ �nn REVENUE Department s - Mayor Fact eep 8220 - Adminia SVCS/MIS 010-01-8220 3354 Shared Program - School/Local 722.40 2,167.20 722.40 1,445.00 1,445.00 1,445.00 1,445.00 .00 Shared Program - LocayScnooltotatr Activity 8220 _ _ _ at SVCS/MIS - Activity 8222 - mem. SVC/M1 re sacks Miscellaneous Revenue 010-01-8222 3954 Service to Sewer Fund Misrellanevut d,e.v _p 8222 Adruin ° IS C - Mayor me s Department 0 - Caa C erk & Finance Activity 815E - Public Access Stu _o Other City lames 010-03-8150 3490 Cable TV Peg Access Fee Other Chit !axes Total Shared tr aram - LoraRSohool 010-03-8150 3354 Shared Program - School/Local Shared Program = Local/School iF tals $722.40 $2,167.20 $722.40 $1,445.00 $1,445.00 $1,445.00 $1,445.00 $0.00 $722.40 $2,167.20 $722.40 $1,445.00 $1,445.00 $1,445.00 $1,445.00 $0.00 40,000.00 40,000.00 .00 40,000.00 40,000.00 40,000.00 40,000.00 .00 $40,000.00 $40,000.00 $0.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $0.00 $40,000.00 $40,000.00 $0.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $0.00 $40,722.40 $42,167.20 $722.40 $41,445.00 $41,445.00 $41,445.00 $41,445.00 $0.00 57,125.32 54,171.57 25,954.85 .00 .00 .00 .00 .00 $57,125.32 $54,171.57 $25,954.85 $0.00 $0.00 $0.00 $0.00 $0.00 8,000.00 .00 .00 .00 .00 .00 .00 .00 $8,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 17ov:es for Fees 010-03-8150 3721 Service Charges .00 .00 .00 500.00 500.00 500.00 500.00 .00 010-03-8150 3831 Registration Fee .00 .00 .00 250.00 250.00 250.00 250.00 .00 Cfvatoes =or Fees & et - l mo $0.00 $0.00 $0.00 $750.00 $750.00 $750.00 $750.00 $0.00 010-03-8150 3830 Unrestricted Gifts form i Donations - R , t', _qtr '. Iclots .00 100.00 .00 .00 .00 .00 .00 .00 $0.00 $100.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 010-03-8150 3000 Cash on Hand .00 .00 .00 30,000.00 30,000.00 30,000.00 30,000.00 .00 t,13,- ur a lr t $0.00 $0.00 $0.00 $30,000.00 $30,000.00 $30,000.00 $30,000.00 $0.00 Run by Kim Bahr on 02/06/2019 14:41:30 PM Page 1 of 5 MIS Additional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted G/L Account Account Description Amount Amount Amount Budget Budget 2020 Base Level Fund 010 - Genera_ Fun REVENUE Department 3 - - Clerk Finance Activity 815 Public Access Studio Totals Department D =t Finance iotas REVENUE TOTALS 2020 Additional [ncr (Decr) to FY20 Needs Base $65,125.32 $54,271.57 $25,954.85 $30,750.00 $30,750.00 $30,750.00 $30,750.00 $0.00 $65,125.32 $54,271.57 $25,954.85 $30,750.00 $30,750.00 $30,750.00 $30,750.00 $0.00 $105,847.72 $96,438.77 $26,677.25 $72,195.00 $72,195.00 $72,195.00 $72,195.00 $0.00 EXPENSE Department B - Main A v v 8270 - Aa e SVCS/MIS Personal Services t`ies & Benefits 010-01-8220 1111 Salaries - Regular 174,511.46 171,172.90 86,416.00 173,535.00 173,535.00 175,739.00 175,739.00 .00 010-01-8220 1112 Salaries - Part-time .00 (2,444.90) .00 .00 .00 .00 .00 .00 010-01-8220 1113 Longevity Pay 1,052.32 1,080.04 540.02 1,080.00 1,080.00 1,180.00 1,180.00 .00 010-01-8220 1121 FICA - City Contribution 13,439.35 12,943.91 6,844.28 13,584.00 13,584.00 13,832.00 13,832.00 .00 010-01-8220 1122 IPERS - City Contribution 14,774.38 15,163.80 8,208.70 16,484.00 16,484.00 16,701.00 16,701.00 .00 010-01-8220 1123 Life & Disability Insurance 879.48 900.00 468.78 714.00 714.00 721.00 721.00 .00 010-01-8220 1130 Employee Benefit Reimbursement 2,953.90 2,168.88 3,897.60 2,954.00 2,954.00 3,900.00 3,900.00 .00 010-01-8220 1131 Health Insurance 29,920.00 30,240.00 15,900.00 31,800.00 31,800.00 35,160.00 35,160.00 .00 Personal Services = Sa lies & Benefits Total= $237,530.89 $231,224.63 $122,275.38 $240,151.00 $240,151.00 $247,233.00 $247,233.00 $0.00 Contractual Services 010-01-8220 1319 Other Professional Services 41,009.61 23,859.92 630.00 30,561.00 30,561.00 31,061.00 31,061.00 .00 010-01-8220 1339 Data Communication 12,320.80 9,217.30 5,195.15 21,000.00 21,000.00 20,000.00 20,000.00 .00 010-01-8220 1344 Telephone & Fax Expense 81,529.49 81,289.01 42,586.55 83,000.00 83,000.00 83,000.00 83,000.00 .00 010-01-8220 1346 Travel - Professional Training 566.69 150.00 .00 1,000.00 1,000.00 1,500.00 1,500.00 .00 Contractual Sem s Tot -el- $135,426.59 $114,516.23 $48,411.70 $135,561.00 $135,561.00 $135,561.00 $135,561.00 $0.00 Comments Act -moot Legi=t 1319 Base Level 1339 Base Level 1346 Base Level Comment Slight increase for implementation services. Slight decrease to reflect expected expenses. Slight increase (reduced 1339 to accommodate) to allow for additional staff training. 010-01-8220 1516 Minor Computer Equipment 2,146.53 5,252.10 1,952.82 2,500.00 2,500.00 3,000.00 3,000.00 .00 Run by Kim Bahr on 02/06/2019 14:41:30 PM Page 2 of 5 MIS Additional Needs Level 2017 Actual 2018 Actual 2019 Actual 2019 Amended 2019 Adopted G/L Account Account Description Amount Amount Amount Budget Budget 2020 Base Level Fuca 010 - Genera_ Fun EXPENSE Department 01 - ielayer Activity 8220 - Admm Commootaes 010-01-8220 1520 010-01-8220 1533 010-01-8220 1561 010-01-8220 1571 Computer Software Fuel Expense Office Supplies & Minor Equipment Machinery & Equipment Replacement Parts 2020 Additional [ncr (Decr) to FY20 Needs Base 45,811.09 32,224.84 13,503.94 38,870.00 38,870.00 38,070.00 38,070.00 .00 77.26 51.00 120.00 150.00 150.00 200.00 200.00 .00 489.54 1,307.18 117.78 250.00 250.00 500.00 500.00 .00 .00 .00 .00 350.00 350.00 350.00 350.00 .00 CUinunoo, L fL $48,524.42 $38,835.12 $15,694.54 $42,120.00 $42,120.00 $42,120.00 $42,120.00 $0.00 Comments ACC Ont Levet Comment 1516 Base Level Slight increase (reduced 1520 to accommodate) 1520 Base Level Slight decrease to accommodate minor increases in 1516, 1533 and 1561. 1533 Base Level Slight increase (reduced 1520 to accommodate) 1561 Base Level Slight increase (reduced 1520 to accommodate) A _ Om 8220 s: L MIS Totals s Depart:o 03 - City Clerk & Finance .e Activity 8150 - Public Access Studio Y tsona'f Services Saktramzn fits 010-03-8150 1111 010-03-8150 1113 010-03-8150 1121 010-03-8150 1122 010-03-8150 1123 010-03-8150 1130 010-03-8150 1131 - teals Salaries - Regular Longevity Pay FICA - City Contribution IPERS - City Contribution Life & Disability Insurance Employee Benefit Reimbursement Health Insurance $421,481.90 $384,575.98 $186,381.62 $417,832.00 $417,832.00 $424,914.00 $424,914.00 $0.00 $421,481.90 $384,575.98 $186,381.62 $417,832.00 $417,832.00 $424,914.00 $424,914.00 $0.00 100,797.92 103,274.40 53,100.00 106,413.00 106,413.00 107,619.00 107,619.00 .00 1,439.88 1,550.76 780.00 1,590.00 1,590.00 1,680.00 1,680.00 .00 7,747.32 7,909.66 4,070.79 8,302.00 8,302.00 8,402.00 8,402.00 .00 9,129.85 9,360.70 5,086.28 10,196.00 10,196.00 10,317.00 10,317.00 .00 622.32 639.72 332.10 655.00 655.00 665.00 665.00 .00 518.00 .00 46.53 518.00 518.00 518.00 518.00 .00 20,790.00 21,000.00 11,039.98 22,080.00 22,080.00 24,420.00 24,420.00 .00 Run by Kim Bahr on 02/06/2019 14:41:30 PM Page 3 of 5 G/L Account Account Description Fund 010 - Genera_ Fund EXPENSE Department 03 - City Clerk & Finance e Amami 8150 - Public Access Stu_o Personal <'t.=7es r,.riLu z Benefits Peisonat Services - Satyr, & Benefits totals Contractuai Ser 010-03-8150 1343 010-03-8150 1346 010-03-8150 1352 010-03-8150 1370 010-03-8150 1392 Postage & Mailing Expense Travel - Professional Training Photography & Copy Reproduction Repair & Maintenance Subscriptions Comments Account 1352 Level Base Level 2017 Actual Amount 2018 Actual Amount 2019 Actual Amount MIS Additional Needs Level 2019 Amended 2019 Adopted Budget Budget 2020 Base Level 2020 Additional [ncr (Decr) to FY20 Needs Base $141,045.29 3.99 .00 .00 .00 476.21 $143,735.24 .00 399.00 515.96 .00 526.24 $74,455.68 1.63 .00 .00 .00 270.12 $149,754.00 100.00 500.00 750.00 1,000.00 500.00 $149,754.00 100.00 500.00 750.00 1,000.00 500.00 $153,621.00 100.00 500.00 350.00 1,000.00 500.00 $153,621.00 100.00 500.00 350.00 1,000.00 500.00 $0.00 .00 .00 .00 .00 .00 $480.20 $1,441.20 $271.75 $2,850.00 Comment Decreased to allow for purchase of a LED light kit under account 1563.. $2,850.00 $2,450.00 $2,450.00 Commodities 010-03-8150 1520 010-03-8150 1561 010-03-8150 1563 Computer Software Office Supplies & Minor Equipment Photo & Video Equipment & Supplies Commodities Totals Comments Account 1563 Levet Base Level .00 1,229.22 .00 .00 1,466.97 1,128.53 .00 926.31 101.54 500.00 1,500.00 1,500.00 500.00 1,500.00 1,500.00 500.00 1,500.00 1,900.00 500.00 1,500.00 1,900.00 $0.00 .00 .00 .00 $1,229.22 $2,595.50 $1,027.85 Comment Increased to allow for purchase of a LED light kit. $3,500.00 $3,500.00 $3,900.00 $3,900.00 Activity 8150 Public Access Studio , Department 3 _ irk & Finance Totals EXPENSE TOTALS .10 - Genera_ Fun -Dr Totals REVENUE TOTALS EXPENSE TOTALS ,.d 010- General Fund Totals Net Grand Totals REVENUE GRAND TOTALS $0.00 $142,754.71 $147,771.94 $75,755.28 $156,104.00 $156,104.00 $159,971.00 $159,971.00 $0.00 $142,754.71 $147,771.94 $75,755.28 $156,104.00 $156,104.00 $159,971.00 $159,971.00 $0.00 $564,236.61 $105,847.72 $564,236.61 $532,347.92 $96,438.77 $532,347.92 $262,136.90 $26,677.25 $262,136.90 $573,936.00 $72,195.00 $573,936.00 $573,936.00 $72,195.00 $573,936.00 $584,885.00 $72,195.00 $584,885.00 $584,885.00 $72,195.00 $584,885.00 $0.00 $0.00 $0.00 ($458,388.89) $105,847.72 ($435,909.15) ($235,459.65) $96,438.77 $26,677.25 ($501,741.00) ($501,741.00) $72,195.00 $72,195.00 ($512,690.00) ($512,690.00) $72,195.00 $72,195.00 $0.00 $0.00 Run by Kim Bahr on 02/06/2019 14:41:30 PM Page 4 of 5 EXPENSE GRAND TOTALS $564,236.61 $532,347.92 $262,136.90 $573,936.00 MIS Additional Needs Level $573,936.00 $584,885.00 Ru - $584,885.00 $0.00 Net Grand Totals ($458,388.89) ($435,909.15) ($235,459.65) ($501,741.00) ($501,741.00) ($512,690.00) ($512,690.00) $0.00 Run by Kim Bahr on 02/06/2019 14:41:30 PM Page 5 of 5