HomeMy WebLinkAboutCouncil Information Memorandum 08-10-2017CITY OF PLYMOUTH
COUNCIL INFO MEMO
August 10, 2017
EVENTS / MEETINGS
Planning Commission Agenda for August 16th .................................................................................. Page 2
Official City Meeting Calendars ......................................................................................................... Page 3
Tentative List of Agenda Items ........................................................................................................... Page 6
CORRESPONDENCE
Draft Changes to City Code Section 400.13 and 400.19..................................................................... Page 9
Picture Plymouth Photo Contest Seeks Entries ................................................................................. Page 14
Pie Day & Book Sale Fundraiser Set for August 23rd ...................................................................... Page 15
Plymouth & Maple Grove Hiring Music Program Instructors .......................................................... Page 16
REPORTS & OTHER ARTICLES OF INTEREST
Monthly Financial Report ................................................................................................................. Page 17
PLANNING COMMISSION AGENDA
WEDNESDAY, August 16, 2017
WHERE: CITY COUNCIL CHAMBERS
Plymouth City Hall
3400 Plymouth Boulevard
Plymouth, MN 55447
1.CALL TO ORDER - 7:00 P.M.
2.PLEDGE OF ALLEGIANCE
3.PUBLIC FORUM
4.APPROVAL OF AGENDA
5.CONSENT AGENDA
A.Approve the August 2, 2017 Planning Commission meeting minutes.
B.Jennifer and Steve Halligan. Approve a variance to front yard setback for property
located at 9920 South Shore Drive. (2017064)
6.PUBLIC HEARINGS
7.NEW BUSI NESS
8.ADJOURNMENT
Page 2
SUN MON TUE WED THU FRI SAT
1
2:30 PM - 4:30 PM
Night to Unite
Kickoff Event
Plymouth Creek
Center
2 3 4 5
6 7 8 9 10 11 12
13 14 15
6:00 PM
SPECIAL COUNCIL
MEETING
Budget and CIP
Medicine Lake Room
16 17 18 19
20 21 22 23 24 25 26
27 28 29
6:00 PM
SPECIAL COUNCIL
MEETING
Budget and CIP
(if needed)
Medicine Lake Room
30 31
August 2017
3400 Plymouth Boulevard
Plymouth, MN 55447 OFFICIAL CITY CALENDAR Phone: 763-509-5000
Fax: 763-509-5060
7:00 PM
PLANNING
COMMISSION
MEETING
Council Chambers
7:00 PM
REGULAR COUNCIL
MEETING
Council Chambers
7:00 PM
ENVIRONMENTAL
QUALITY
COMMITTEE (EQC)
MEETING
Medicine Lake Room
7:00 PM
PLANNING
COMMISSION
MEETING
Council Chambers
7:00 PM
HOUSING AND
REDEVELOPMENT
AUTHORITY (HRA)
MEETING
Medicine Lake Room
SUN TUES MON WED THUR FRI SAT
5:00 PM
SPECIAL COUNCIL
MEETING
Budget and CIP/Review
Future Trail Projects
Medicine Lake Room
7:00 PM
REGULAR COUNCIL
MEETING
Council Chambers
CHANGES ARE NOTED IN RED
5:30 PM - 8:30 PM
Kids Fest
Hilde
Performance Center
Page 3
SUN MON TUE WED THU FRI SAT
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
September 2017
3400 Plymouth Boulevard
Plymouth, MN 55447 OFFICIAL CITY CALENDAR Phone: 763-509-5000
Fax: 763-509-5060
7:00 PM
PLANNING
COMMISSION
MEETING
Council Chambers
7:00 PM
ENVIRONMENTAL
QUALITY
COMMITTEE (EQC)
MEETING
Medicine Lake Room
7:00 PM
PLANNING
COMMISSION
MEETING
Council Chambers
SUN TUES MON WED THUR FRI SAT
CHANGES ARE MADE IN RED
LABOR DAY
CITY OFFICES
CLOSED
5:30 PM
SPECIAL COUNCIL
MEETING
Median/Beautification
Projects
Medicine Lake Room
7:00 PM
REGULAR COUNCIL
MEETING
Council Chambers
5:30 PM
SPECIAL COUNCIL
MEETING
Consider minimum age
to purchase tobacco
Medicine Lake Room
7:00 PM
REGULAR COUNCIL
MEETING
Council Chambers
10:30 AM - 3:00 PM
Plymouth on Parade
Celebration
City Center Area
7:00 PM
HOUSING AND
REDEVELOPMENT
AUTHORITY (HRA)
MEETING
Medicine Lake Room
7:00 PM
PARK & REC ADVI-
SORY
COMMISSION
(PRAC)
MEETING
Park Maintenance
Page 4
SUN MON TUE WED THU FRI SAT
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31 26 27 28 29
October 2017
3400 Plymouth Boulevard
Plymouth, MN 55447 OFFICIAL CITY CALENDAR Phone: 763-509-5000
Fax: 763-509-5060
7:00 PM
PLANNING
COMMISSION
MEETING
Council Chambers
5:30 PM
SPECIAL COUNCIL
MEETING
Small Cell Wireless
Ordinance
Medicine Lake Room
7:00 PM
REGULAR COUNCIL
MEETING
Council Chambers
7:00 PM
PARK & REC
ADVISORY
COMMISSION
(PRAC) MEETING
Plymouth Ice Center
7:00 PM
HOUSING AND
REDEVELOPMENT
AUTHORITY (HRA)
MEETING
Medicine Lake Room
SUN TUES MON WED THUR FRI SAT
7:00 PM
REGULAR COUNCIL
MEETING
Council Chambers
CHANGES ARE NOTED IN RED
7:00 PM
PLANNING
COMMISSION
MEETING
Council Chambers
CHA
6:00 PM - 8:30 PM
Halloween at the
Creek
Plymouth Creek
Center
7:00 PM
ENVIRONMENTAL
QUALITY
COMMITTEE (EQC)
MEETING
Medicine Lake Room
6:30 PM
Volunteer
Recognition Event
Plymouth Creek
Center
Page 5
Note: Special Meeting topics have been set by Council; all other topics are tentative.
EDA refers to the Economic Development Authority
Tentative Schedule for
City Council Agenda Items
August 15, Special, 6:00 p.m. Medicine Lake Room
•Budget and CIP
August 22, Special, 5:00 p.m. Medicine Lake Room
•Budget and CIP
•Review future trail projects
August 22, Regular, 7:00 p.m. Council Chambers
•Recognition to Senator Paul Anderson on receiving Legislator of Distinction by the League of
Minnesota Cities
•Public hearing on denial of Massage Therapy Certificate for Fengfang Tan at Lotus Therapeutic
Spa, 3161 Fernbrook Lane North
•Authorize Joint Powers Agreement with the City of Minneapolis regarding public safety support
related to the 2018 Super Bowl
•Announcement of 5k walk to support “Pause for Paws”
•Approve payment No. 3 and final for the 2016 Contractor Mill and Overlay project (16004)
•Approve plans and specifications and order advertisement for bids for the Plymouth Creek
Stream Restoration Project (16007)
•Accept streets for continual maintenance in Brynwood (2013095)
•Approve request for proposal for catering at the Plymouth Creek Center
•Approve Variance to allow construction of detached oversized garage at 2700 Quaker Lane
(Adam Nawrocki – 2017061)
•Consider approval of Reguiding, Rezoning, and Preliminary Plat for “Beacon Ridge” on
properties located at 5225, 5305, and 5325 Dunkirk Lane (Estate Development Corporation –
2017053)
August 29, Special, 6:00 p.m. Medicine Lake Room (if needed)
•Budget and CIP
September 12, Special, 5:30 p.m. Medicine Lake Room
•Median/beautification projects
September 12, Regular, 7:00 p.m. Council Chambers
•Announce Plymouth on Parade on September 23
•Approve 2018 proposed budget, preliminary general property tax levy, HRA levy and budget
hearing date
•Consider Sexual Predator Ordinance
September 26, Special, 5:30 p.m. Medicine Lake Room
•Consider minimum age to purchase tobacco
September 26, Regular, 7:00 p.m. Council Chambers
October 10, Special, 5:30 p.m. Medicine Lake Room
Page 6
•Small Cell Wireless Ordinance
October 10, Regular, 7:00 p.m. Council Chambers
October 24, Regular, 7:00 p.m. Council Chambers
November 14, Special, 5:30 p.m. Medicine Lake Room
•Budget
November 14, Regular, 7:00 p.m. Council Chambers
November 28, Regular, 7:00 p.m. Council Chambers
December 12, Regular, 7:00 p.m. Council Chambers
•Public hearing on 2018 budget, general property tax levy, HRA levy, and 2018-2022 Capital
Improvement Program
•Approve 2018 Target and Trap Shooting License renewal
•Approve 2018 Amusement License renewals
•Approve 2018 Tobacco License renewals
Page 7
Budget Calendar
2018-2019 Biennial Budget Preparation & 5-yr Capital Improvement Plan
Date Category Description
April 17, 2017 Budget Departments receive budget instruction
May 23 at 5:30 p.m. Budget Council Study Session – Financial Plan & Budget Goals
April – June 2017 Budget Departments prepare budgets
June 2, 2017 Budget Personnel changes submitted to HR
June 12, 2017 Budget Budgets submitted to Finance
June 26 – July 14, 2017 Budget Department meetings
August 4 Budget Council receives budget materials for upcoming meeting
August 15 at 6 p.m. Budget & CIP Council study session (Budget & CIP meeting #1)
August 22 at 5:30 p.m. Budget & CIP Council Study Session (Budget & CIP meeting #2)
Council Regular Session (Financial Overview & Audit Presentation)
August 29 at 6 p.m. Budget & CIP Council Study Session (Budget meeting #3) (if needed)
September 12, 2017 Budget Council adopts preliminary levies & budget (Budget meeting #4)
October 4, 2017 CIP Planning Commission public hearing
November 14 at 5:30 p.m. Budget Council Study Session (Budget meeting #5) (If needed)
December 12, 2017 Budget & CIP Budget Public Hearing, CIP, Budget & Levy Adoption
December 26, 2017 Budget Levy is certified with Hennepin County
Page 8
1
Staff continues to discuss and deal with drainage issues that come with land development, specifically in
residential areas. Section 400.13 of the City Code provides drainage and survey requirements that must
be reviewed and verified during the permit process and prior to construction finals. City staff is
reviewing changes to this section to help staff verify water runoff, lot elevations and building
requirements. The proposed changes to Section 400.13 help clarify which projects need a survey
included with the permit application and what information is needed to ensure compliance with City
Code and Building Code. Some building sites have specific challenges that may need additional
information indicated on the survey. This new language will allow flexibility in requiring needed
information but still within the parameters of the Code section. One significant change is 400.13 G. This
change requires more detailed topographical information on the survey within 15 feet of a building.
Having this information will ensure proper lot drainage in the most critical area of a property. This
section also identifies swales, storm drains and other means necessary to properly drain a site.
Finally, the proposed changes to 400.19 would require an as-built survey to all newly constructed
buildings. Currently the City requires a Grading Certificate signed by the surveyor of record. This is a
written document stating that the surveyor believes the final grades match those approved during
permit review. In most cases this process has worked fine. However, in several instances this practice
has resulted in homeowner and staff challenges if drainage doesn’t perform exactly the way it was
designed.
An as-built survey costs approximately $350 if done by the same company that completed the survey for
the building permit. From our discussions with other communities, approximately 50% require some
type of as-built survey.
Please review the attached proposed ordinance changes and let either Tyson or Steve know if you have
questions or comments. Staff plans to bring the proposed ordinance amendment to the City Council in
the near future.
Memorandum
To: Mayor, City Council and City Manager Dave Callister
From: Steve Juetten, Community Development Director and Tyson
Jenkins, Building Official
Date: August 7, 2017
Item: Draft changes to City Code Section 400.13 and 400.19
Page 9
2
400.13. Building Permits; Required Information. Each permit application for a new
building or addition permit shall be accompanied by a site plan, drawn to scale and based upon a
certified land survey which shall include the following: survey of said premises and information on
the location and the dimension of existing and proposed buildings, location of easements
crossing the property, encroachments, and any other information which shall be necessary to
insure conformance with the City Ordinances and may include the following:
A.All existing buildings with dimensions of each and the distance measured
perpendicular from the lot lines and from any wetlands or wetland buffers (when
applicable) to the nearest point of each building. (Ord. 2009-08, 5/12/2009)
B.All proposed buildings with dimensions of each and distance measured
perpendicular from the lot lines and from any wetlands or wetland buffers (when
applicable) to the nearest point of each building. (Ord. 2009-08, 5/12/2009)
C.Elevations to sea level datum of the center line of the nearest street at
points where the side line of proposed buildings extended intersect said
street. (Ord. 2009-08, 5/12/2009)
D.Proposed elevations to sea level datum of the top of foundation,
garage floor, and the lowest floor and lowest opening.
E.The approved lowest floor minimum elevation shall be no less than two
feet above the established 100-year flood plain elevation as determined by the
City Storm Water Drainage Plan and/or the Federal Flood Insurance Map, subject
to approval by the City Engineer. The lowest opening shall be no less than 1 1/2
feet above the highest point of any adjacent emergency overflow. (Ord. 2003-22,
7/22/2003; Ord. 2009-08, 5/12/2009)
F.Existing and proposed elevations to sea level datum of grade at each
property corner and within five feet of foundation on all sides of proposed
buildings. (Ord. 2009-08, 5/12/2009)
G. Proposed slope or grade of ground for a distance of not less than 25 feet in
front of and in back of foundation and topographical information at two (2) foot
contours depicting (existing and proposed) elevation within fifteen (15) feet of all
sides of the building foundation. Water runoff shall be properly channeled by use
of swale or other approved means to storm drains, ponding areas or other public
facilities subject to the review and approval of the City Engineer.
Page 10
3
H. Elevation to sea level of sanitary sewer main, if existing, at point of
connection.
I. All existing utilities, easements, drainageways, waterways, ponds, and
wetlands on or within the property, including the location and elevation of all
emergency overflows. (Ord. 2002-10, 3/12/2002; Ord. 2009-08, 5/12/2009)
J. Indication and notation of any proposed or approved variances. (Ord.
2009-08, 5/12/2009)
J.For single- and two-family dwellings, the location of an attached or
detached garage, containing at least one parking stall, which could be built in
addition to the dwelling within ordinance setback standards. (Ord. 2009-08,
5/12/2009)
K. Certification that the building, proposed site grading, and erosion control
measures are in accordance with the City-wide storm water drainage plans
and/or grading plans approved by the City Engineer for the specific development
or subdivision. (Ord. 2009-08, 5/12/2009)
L. Certification that permanent iron monuments are in place at each
lot corner.
M. Indication that permanent iron monuments are placed on each side of
the lot a distance from the front lot line equivalent to the proposed front building
setback line. In the event the distance from the side line to the proposed building
is greater than 30 feet, stakes shall be placed on the front building line a distance
not to exceed 30 feet from the proposed building. (Ord. 2009-08, 5/12/2009)
N. Location of existing buildings on adjacent properties, within 25 feet of the
lot lines, to include top of foundation elevation and distance to front and side lot
lines. (Ord. 2009-08, 5/12/2009)
O. Location of all proposed decks, porches, patios, retailing walls, stairways,
cantilevers, fireplaces, bay and bow windows.
P. Location and elevation of all sanitary and storm sewer manholes, hydrants
Page 11
4
and catch basins.
Q. The location of all proposed driveways, curb cuts, and retaining walls,
including proposed driveway slope and height of retaining wall.
R.Indication, with arrows, the direction of proposed surface drainage in
accordance with the City-wide storm water drainage plans and/or grading plans
approved by the City Engineer for the specific development or subdivision.
S.For properties which abut lakes and/or ponds, indicate by contour line,
the ordinary high water level (OHWL) elevation and distance to the nearest point
of the proposed building. (Ord. 2009-08, 5/12/2009)
T.Proof proposed building is located on parcel of land abutting on a street or
highway which said street or highway has been approved by the City, and
otherwise meets the requirements of Minnesota Statutes Section 462.358, as
amended. (Ord. 94-22, 11/21/94; Ord. 2009-08, 5/12/2009)
U.Location of erosion control devices, including any permanent or
temporary erosion control measures shown on the approved grading plan. (Ord.
95-17, 3/21/95; (Ord. 2009-08, 5/12/2009)
V.If the lot is subject to the City’s wetland buffer regulations (subdivided
after January 3, 1995), indicate the location of the designated wetland buffer area
as shown on the approved grading plan, together with the location of
permanently installed wetland buffer monument signage. (Ord. 96-26, 10/02/96;
Ord. 2009- 08, 5/12/2009)
W.Location of all rain gardens when required. (Ord. 2002-10, 3/12/2002)
X.For properties located within a shoreland management overlay district,
provide calculations indicating the total percentage of impervious surface area
coverage. (Ord. 2003-22, 7/22/2003; Ord. 2009-08, 5/12/2009)
Y.If the lot is subject to the City’s tree preservation regulations, indicate the
construction zone and areas of tree removal and tree preservation. (Ord. 2009-08,
5/12/2009)
Page 12
5
AA. For single- and two-family dwellings, indicate the location, size, and
species of the two required trees, pursuant to Section 21130.03 of this Code.
(Ord. 2009-08, 5/12/2009)
400.19. Final Inspections. Subdivision 1. Certification. Final inspections and authorization of
occupancy of all new Buildings and building additions as may be necessary, shall be
performed upon receipt of an “as-built” survey prepared written certification by an
engineer or land surveyor licensed and registered in Minnesota that the grades and
elevations of the site and Building are in accordance with the approved plans.
Page 13
City of Plymouth
News Release
For Immediate Release
Aug. 8, 2017
Contact: Helen LaFave
Communications Manager
City of Plymouth
763-509-5090
hlafave@plymouthmn.gov
Picture Plymouth Photo Contest seeks entries
Plymouth, Minn. – The annual Picture Plymouth Photo Contest is underway. Entries are due Aug. 31.
The City of Plymouth and Plymouth Magazine, a local lifestyle publication, partner to hold the annual
contest.
Photo categories include people and families, community activities and events, pets, wildlife and nature,
and city landmarks.
All entries must be submitted digitally via plymouthmag.com.
Each entrant must live, work or attend school in Plymouth and photos must be taken in Plymouth
between Sept. 1, 2016 to Aug. 31, 2017.
A winner for each category will be selected, as well as a grand-prize winner. The grand-prize winner will
receive $100. Top picks in each category will receive $50. For complete contest rules, visit
plymouthmag.com.
After the contest closes, residents may visit the Plymouth Magazine website Sept. 10-30 to cast their
vote for the readers’ choice winner.
Those who enter the contest may see their work in print – even if they do not win. Photos submitted to
the contest will be used in city publicity, including publications, the website and social media sites.
Plymouth Magazine will also publish many of the photographs.
Cutline: The grand-prize winning photograph from last year’s Picture Plymouth Photo Contest, “S’mores
Brothers,” was captured by Andrea Potashnick. Entries for this year’s contest are due Aug. 31.
-30-
Page 14
City of Plymouth
News Release
For Immediate Release
Aug. 9, 2017
Contact: Chris Fleck
Plymouth Creek Center Manager
City of Plymouth
763-509-5281
cfleck@plymouthmn.gov
Pie Day, book sale fundraiser set for Aug. 23
Plymouth, Minn. – The annual Pie Day and book sale fundraiser for the Plymouth Senior Program is set
for 11 a.m. to 2:30 p.m. Wednesday, Aug. 23 at the Plymouth Creek Center, 14800 34th Ave. N.
Freshly baked apple, cherry, strawberry-rhubarb and cream pies will be sold for $5 per slice. Ice cream is
available. The event also features a used book sale.
Money raised through the fundraiser supports senior programs at the Plymouth Creek Center. It helps
fund supplies, equipment and guest speakers, as well as veteran and senior events and an annual party
celebrating local seniors ages 90 and older.
For more information, call the Plymouth Creek Center at 763-509-5280.
-30-
Page 15
City of Plymouth
News Release
For Immediate Release
Aug. 9, 2017
Contact: Kari Hemp
Recreation Manager
City of Plymouth
763-509-5220
khemp@plymouthmn.gov
Cities of Plymouth, Maple Grove hiring music program instructors
Plymouth, Minn. – The cities of Plymouth and Maple Grove are seeking to hire music instructors for the
Music for Everyone program.
Instructors provide music lessons for participants ages 7 and older during the school year, with a
summer option available. These 10- to 12-week sessions offer music lessons in voice, brass, woodwinds,
strings and piano.
In its 26th year, Music for Everyone is a collaboration of four Parks and Recreation departments,
including Plymouth, Brooklyn Park, Golden Valley and Maple Grove.
The program instructor position requires some preparation hours, as well as instruction one to two days
per week. Hours may vary.
Candidates should be creative, fun and experienced, and must have a background in music education
and instruction. College degree in music education preferred.
For more information or to apply, visit the City of Maple Grove website at maplegrovemn.gov.
-30-
Page 16
Memorandum
To: Dave Callister
From: Jodi Bursheim, Finance Manager
Date August 9, 2017
Item: Investment Summary & Fund Financial Statements
Attached please find the financial reports through June, 2017. A cash balance report for the same time period is also
included. Please let me know if you have any questions.
Page 17
Fund: 100 - General Fund
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
General Property Taxes 26,691,753 12,105,900 (14,585,853)45.35 %11,574,700 25,247,809
Permits and Licenses 3,750,160 2,600,905 (1,149,255)69.35 %2,534,209 4,510,095
Intergovernmental 2,416,481 789,973 (1,626,508)32.69 %672,092 3,488,203
Charges for Services 1,404,382 603,021 (801,361)42.94 %582,592 1,415,679
Billings to Departments 2,226,977 488,489 (1,738,488)21.94 %474,261 2,543,553
Fines & Forfeitures 513,500 286,263 (227,237)55.75 %200,938 443,918
Special Assessments 10,000 0 (10,000)0.00 %0 12,822
Contributions & Donations - Operating 1,600 5,361 3,761 335.08 %1,500 99,651
Contributions & Donations - Capital 0 0 0 0.00 %3,000 3,000
Interest Income 260,000 140,872 (119,128)54.18 %304,134 102,490
Other 132,100 942,112 810,012 713.18 %96,643 268,028
Transfers In 285,000 3,065 (281,935)1.08 %18,271 328,560
Total Revenue 37,691,953 17,965,961 (19,725,992)47.67 %16,462,339 38,463,806
Expense:
Personal Services 23,226,534 11,226,084 (12,000,450)48.33 %9,769,842 21,647,651
Materials and Supplies 1,457,973 530,189 (927,784)36.36 %623,178 1,128,483
Employee Development & Meetings 323,576 160,850 (162,726)49.71 %194,454 281,184
Dues & Subscriptions 138,199 99,539 (38,660)72.03 %100,086 117,957
Contractual Services 4,553,871 1,938,970 (2,614,901)42.58 %2,337,646 4,055,360
Equipment 96,000 53,842 (42,158)56.09 %85,577 104,666
Capital Improvements 0 0 0 0.00 %38,401 92,968
Allocations 6,731,067 3,365,533 (3,365,534)50.00 %3,240,880 6,481,761
Transfers Out 212,500 0 (212,500)0.00 %0 2,062,614
Other Expense 952,233 307,053 (645,180)32.25 %249,038 2,012,563
Total Expense 37,691,953 17,682,060 (20,009,893)46.91 %16,639,101 37,985,208
Net Total 0 283,900 283,900 0.00 %(176,763)478,598
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 1
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 18
Fund: 200 - Recreation Fund
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
General Property Taxes 631,674 0 (631,674)0.00 %0 600,388
Intergovernmental 0 0 0 0.00 %0 10
Charges for Services 1,276,725 570,351 (706,374)44.67 %904,972 1,203,594
Contributions & Donations - Operating 10,000 26,446 16,446 264.46 %27,300 28,300
Interest Income 8,000 8,724 724 109.05 %12,358 4,768
Other 1,300 4,187 2,887 322.09 %0 1,685
Total Revenue 1,927,699 609,708 (1,317,991)31.63 %944,631 1,838,745
Expense:
Personal Services 1,163,023 535,969 (627,054)46.08 %492,673 1,060,229
Materials and Supplies 56,000 35,133 (20,867)62.74 %37,324 68,914
Employee Development & Meetings 9,400 4,212 (5,188)44.81 %725 5,459
Dues & Subscriptions 1,620 2,401 781 148.20 %2,295 2,609
Contractual Services 535,870 214,433 (321,437)40.02 %227,915 514,970
Equipment 4,500 0 (4,500)0.00 %0 6,686
Capital Improvements 0 5,159 5,159 0.00 %5,550 5,550
Allocations 86,386 43,193 (43,193)50.00 %38,395 76,790
Transfers Out 22,831 0 (22,831)0.00 %0 20,138
Other Expense 48,069 20,536 (27,533)42.72 %25,143 44,503
Total Expense 1,927,699 861,036 (1,066,663)44.67 %830,019 1,805,847
Net Total 0 (251,328)(251,328)0.00 %114,611 32,898
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 2
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 19
Fund: 220 - Transit System
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Intergovernmental 4,234,566 2,225,632 (2,008,934)52.56 %1,601,417 4,096,174
Charges for Services 1,140,000 351,065 (788,935)30.80 %435,523 1,019,326
Interest Income 35,000 79,867 44,867 228.19 %127,256 56,808
Other 0 3,345 3,345 0.00 %3 5,239
Transfers In 0 0 0 0.00 %0 18,330
Total Revenue 5,409,566 2,659,909 (2,749,657)49.17 %2,164,198 5,195,877
Expense:
Personal Services 0 65,843 65,843 0.00 %0 22,599
Materials and Supplies 557,000 187,573 (369,427)33.68 %6 4,244
Employee Development & Meetings 2,750 0 (2,750)0.00 %(1)16
Dues & Subscriptions 13,500 9,500 (4,000)70.37 %9,500 9,500
Contractual Services 4,730,263 1,759,105 (2,971,158)37.19 %1,981,222 4,088,504
Equipment 1,500 1,820 320 121.33 %0 0
Capital Improvements 0 0 0 0.00 %89,119 145,037
Allocations 67,248 33,624 (33,624)50.00 %39,917 79,833
Transfers Out 36,730 0 (36,730)0.00 %0 0
Other Expense 575 705 130 122.67 %561 20,435
Total Expense 5,409,566 2,058,170 (3,351,397)38.05 %2,120,324 4,370,169
Net Total 0 601,740 601,740 0.00 %43,874 825,709
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 3
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 20
Fund: 250 - Community Dev Block Grant (CDBG)
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
General Property Taxes 3,790 0 (3,790)0.00 %0 2,098
Intergovernmental 294,398 130,021 (164,377)44.16 %179,009 311,267
Interest Income 600 1,243 643 207.21 %1,122 237
Total Revenue 298,788 131,264 (167,524)43.93 %180,131 313,602
Expense:
Personal Services 50,481 24,300 (26,181)48.14 %14,554 34,879
Materials and Supplies 300 0 (300)0.00 %0 126
Employee Development & Meetings 1,266 885 (381)69.91 %605 935
Contractual Services 7,900 3,064 (4,836)38.79 %4,262 7,744
Allocations 4,727 2,364 (2,363)50.00 %2,472 4,945
Other Expense 234,114 139,493 (94,621)59.58 %132,721 229,885
Total Expense 298,788 170,106 (128,682)56.93 %154,614 278,514
Net Total 0 (38,842)(38,842)0.00 %25,516 35,088
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 4
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 21
Fund: 254 - HRA Section 8
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Intergovernmental 3,179,250 1,511,797 (1,667,453)47.55 %1,493,760 3,003,903
Interest Income 0 44 44 0.00 %6 92
Transfers In 34,181 0 (34,181)0.00 %0 0
Total Revenue 3,213,431 1,511,841 (1,701,590)47.05 %1,493,766 3,003,995
Expense:
Personal Services 239,673 109,995 (129,678)45.89 %96,192 211,145
Materials and Supplies 100 0 (100)0.00 %0 0
Employee Development & Meetings 1,125 522 (603)46.43 %92 92
Dues & Subscriptions 750 0 (750)0.00 %0 0
Contractual Services 21,500 9,685 (11,815)45.05 %9,691 13,276
Allocations 24,692 12,346 (12,346)50.00 %20,097 40,194
Other Expense 2,925,591 1,382,897 (1,542,694)47.27 %1,374,714 2,740,223
Total Expense 3,213,431 1,515,446 (1,697,985)47.16 %1,500,786 3,004,931
Net Total 0 (3,605)(3,605)0.00 %(7,020)(936)
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 5
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 22
Fund: 258 - HRA General
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
General Property Taxes 567,589 0 (567,589)0.00 %0 558,673
Intergovernmental 0 0 0 0.00 %0 125,010
Charges for Services 9,900 4,950 (4,950)50.00 %4,950 9,900
Contributions & Donations - Operating 0 400 400 0.00 %0 0
Interest Income 37,150 26,335 (10,815)70.89 %49,731 29,762
Other 10,000 0 (10,000)0.00 %3,280 7,132
Transfers In 5,000 0 (5,000)0.00 %0 0
Total Revenue 629,639 31,685 (597,954)5.03 %57,961 730,476
Expense:
Personal Services 250,233 122,560 (127,673)48.98 %103,714 229,123
Materials and Supplies 700 0 (700)0.00 %882 977
Employee Development & Meetings 3,300 369 (2,931)11.18 %885 1,341
Dues & Subscriptions 1,700 816 (884)48.02 %758 758
Contractual Services 31,888 11,181 (20,707)35.06 %17,298 35,311
Allocations 24,555 12,278 (12,278)50.00 %11,667 23,334
Transfers Out 90,646 94,000 3,354 103.70 %99,000 198,000
Other Expense 226,617 203 (226,414)0.09 %1,180 289,015
Total Expense 629,639 241,407 (388,232)38.34 %235,384 777,858
Net Total 0 (209,722)(209,722)0.00 %(177,423)(47,382)
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 6
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 23
Fund: 500 - Water
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Permits and Licenses 8,548 11,454 2,906 134.00 %8,054 16,660
Intergovernmental 0 0 0 0.00 %0 10,000
Charges for Services 7,793,869 2,222,819 (5,571,050)28.52 %1,952,487 6,431,548
Billings to Departments 16,000 0 (16,000)0.00 %0 0
Contributions & Donations - Capital 600,000 0 (600,000)0.00 %0 3,001,434
Interest Income 15,000 40,507 25,507 270.04 %63,384 36,575
Other 0 5,696 5,696 0.00 %4,788 15,528
Transfers In 0 0 0 0.00 %0 5,821,520
Total Revenue 8,433,417 2,280,475 (6,152,942)27.04 %2,028,713 15,333,266
Expense:
Personal Services 1,266,559 579,464 (687,095)45.75 %566,001 1,231,423
Materials and Supplies 844,000 261,243 (582,757)30.95 %374,335 789,965
Employee Development & Meetings 8,000 4,960 (3,040)62.01 %3,653 6,106
Dues & Subscriptions 5,000 3,553 (1,448)71.05 %3,717 3,717
Contractual Services 2,632,800 734,991 (1,897,809)27.92 %1,175,170 2,693,994
Equipment 12,000 2,644 (9,356)22.03 %6,076 12,697
Capital Improvements 985,000 0 (985,000)0.00 %80,423 0
Depreciation 0 0 0 0.00 %0 2,539,210
Debt Service - Interest 62,263 44,400 (17,863)71.31 %58,425 60,194
Allocations 711,722 355,861 (355,861)50.00 %373,270 746,540
Transfers Out 1,898,300 0 (1,898,300)0.00 %0 2,577,466
Other Expense 7,773 2,676 (5,097)34.43 %1,548 6,219
Total Expense 8,433,417 1,989,791 (6,443,626)23.59 %2,642,618 10,667,529
Net Total 0 290,684 290,684 0.00 %(613,905)4,665,737
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 7
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 24
Fund: 510 - Water Resources
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Intergovernmental 0 0 0 0.00 %1,151 264,026
Charges for Services 3,110,952 1,334,333 (1,776,619)42.89 %1,131,246 3,005,275
Billings to Departments 100,000 0 (100,000)0.00 %0 0
Contributions & Donations - Capital 0 0 0 0.00 %0 2,248,049
Interest Income 45,025 34,032 (10,993)75.59 %51,709 25,119
Other 20,000 14,969 (5,031)74.84 %15,976 40,080
Transfers In 1,771,845 0 (1,771,845)0.00 %0 662,561
Total Revenue 5,047,822 1,383,334 (3,664,488)27.40 %1,200,081 6,245,110
Expense:
Personal Services 741,721 361,026 (380,695)48.67 %323,626 713,549
Materials and Supplies 191,700 28,266 (163,434)14.74 %98,423 172,057
Employee Development & Meetings 2,200 129 (2,071)5.89 %2,386 2,526
Dues & Subscriptions 320,000 300,943 (19,057)94.04 %278,894 278,894
Contractual Services 712,200 153,798 (558,402)21.59 %259,173 664,253
Equipment 15,000 2,247 (12,753)14.98 %2,966 6,366
Capital Improvements 2,695,000 0 (2,695,000)0.00 %0 0
Depreciation 0 0 0 0.00 %0 396,259
Allocations 355,170 177,585 (177,585)50.00 %173,161 346,322
Transfers Out 0 0 0 0.00 %0 670,668
Other Expense 14,831 726 (14,105)4.89 %430 1,264
Total Expense 5,047,822 1,024,720 (4,023,102)20.30 %1,139,060 3,252,158
Net Total 0 358,614 358,614 0.00 %61,021 2,992,951
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 8
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 25
Fund: 520 - Sewer
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Permits and Licenses 8,862 10,815 1,953 122.04 %8,464 17,271
Intergovernmental 27,000 7,643 (19,358)28.31 %3,829 15,315
Charges for Services 9,238,611 3,348,197 (5,890,414)36.24 %2,973,814 7,949,222
Billings to Departments 105,000 0 (105,000)0.00 %0 0
Contributions & Donations - Capital 800,000 0 (800,000)0.00 %0 1,853,614
Interest Income 10,010 26,372 16,362 263.46 %43,611 34,849
Other 18,000 15,276 (2,724)84.87 %9,645 46,723
Transfers In 59,478 0 (59,478)0.00 %0 4,058,066
Total Revenue 10,266,961 3,408,303 (6,858,658)33.20 %3,039,362 13,975,060
Expense:
Personal Services 754,530 353,113 (401,417)46.80 %327,022 716,000
Materials and Supplies 151,500 33,612 (117,888)22.19 %107,599 115,841
Employee Development & Meetings 6,000 4,682 (1,318)78.03 %4,622 5,614
Contractual Services 7,069,200 3,396,233 (3,672,967)48.04 %3,339,134 5,971,633
Equipment 6,000 804 (5,196)13.40 %1,775 4,657
Capital Improvements 1,570,000 0 (1,570,000)0.00 %0 0
Depreciation 0 0 0 0.00 %0 1,221,889
Allocations 701,923 350,962 (350,961)50.00 %349,783 699,565
Transfers Out 0 0 0 0.00 %0 1,480,663
Other Expense 7,808 1,664 (6,144)21.31 %1,278 3,079
Total Expense 10,266,961 4,141,069 (6,125,892)40.33 %4,131,213 10,218,941
Net Total 0 (732,766)(732,766)0.00 %(1,091,851)3,756,119
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 9
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 26
Fund: 530 - Solid Waste Mgmt
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Permits and Licenses 4,975 4,525 (450)90.95 %0 0
Intergovernmental 120,547 0 (120,547)0.00 %108,207 222,251
Charges for Services 665,802 249,008 (416,794)37.40 %218,216 579,226
Interest Income 30,015 17,139 (12,876)57.10 %34,788 18,006
Other 14,500 11,520 (2,980)79.45 %8,414 16,881
Transfers In 304,845 0 (304,845)0.00 %0 0
Total Revenue 1,140,684 282,191 (858,493)24.74 %369,625 836,364
Expense:
Personal Services 137,429 60,145 (77,284)43.76 %76,470 148,891
Materials and Supplies 12,140 2,018 (10,122)16.62 %2,235 2,263
Employee Development & Meetings 240 0 (240)0.00 %25 25
Dues & Subscriptions 540 0 (540)0.00 %10 10
Contractual Services 915,844 381,404 (534,440)41.65 %431,503 848,411
Equipment 1,500 0 (1,500)0.00 %0 0
Depreciation 0 0 0 0.00 %0 4,821
Allocations 65,577 32,789 (32,789)50.00 %34,043 68,086
Other Expense 7,414 1,603 (5,811)21.63 %1,542 1,932
Total Expense 1,140,684 477,959 (662,725)41.90 %545,827 1,074,439
Net Total 0 (195,768)(195,768)0.00 %(176,201)(238,074)
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 10
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 27
Fund: 540 - Ice Center
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Charges for Services 1,617,068 873,881 (743,187)54.04 %798,734 1,577,870
Contributions & Donations - Operating 0 0 0 0.00 %0 88,301
Contributions & Donations - Capital 85,976 40,265 (45,711)46.83 %0 139,278
Interest Income 17,000 13,696 (3,304)80.57 %24,685 14,487
Other 13,000 13,636 636 104.89 %7,337 29,918
Transfers In 191,567 0 (191,567)0.00 %0 0
Total Revenue 1,924,611 941,479 (983,132)48.92 %830,755 1,849,854
Expense:
Personal Services 740,284 302,335 (437,949)40.84 %274,867 576,629
Materials and Supplies 150,100 42,286 (107,814)28.17 %49,882 88,380
Employee Development & Meetings 2,200 1,351 (849)61.40 %161 2,202
Dues & Subscriptions 950 504 (446)53.05 %150 249
Contractual Services 511,700 270,319 (241,381)52.83 %250,210 508,749
Equipment 20,200 1,000 (19,200)4.95 %6,428 10,767
Capital Improvements 300,000 0 (300,000)0.00 %6,750 0
Depreciation 0 0 0 0.00 %0 488,317
Allocations 167,282 83,641 (83,641)50.00 %78,844 157,688
Transfers Out 0 0 0 0.00 %0 131,861
Other Expense 31,895 3,312 (28,583)10.39 %3,891 33,173
Total Expense 1,924,611 704,748 (1,219,863)36.62 %671,184 1,998,014
Net Total 0 236,730 236,730 0.00 %159,571 (148,160)
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 11
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 28
Fund: 550 - Field House
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Charges for Services 414,700 279,974 (134,726)67.51 %264,942 374,197
Interest Income 23,000 19,855 (3,145)86.32 %34,541 17,274
Other 2,500 1,200 (1,300)48.01 %651 1,494
Transfers In 696,147 0 (696,147)0.00 %0 0
Total Revenue 1,136,347 301,028 (835,319)26.49 %300,134 392,966
Expense:
Personal Services 122,367 63,216 (59,151)51.66 %58,390 115,618
Materials and Supplies 7,900 1,609 (6,291)20.36 %1,773 4,323
Employee Development & Meetings 200 0 (200)0.00 %0 0
Contractual Services 111,900 43,490 (68,410)38.87 %45,169 83,402
Capital Improvements 875,000 0 (875,000)0.00 %0 0
Depreciation 0 0 0 0.00 %0 63,745
Allocations 17,579 8,790 (8,789)50.00 %8,703 17,406
Transfers Out 0 0 0 0.00 %0 182,942
Other Expense 1,401 597 (804)42.59 %670 1,441
Total Expense 1,136,347 117,701 (1,018,646)10.36 %114,706 468,876
Net Total 0 183,328 183,328 0.00 %185,428 (75,911)
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 12
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 29
Fund: 600 - Central Equipment
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Charges for Services 0 0 0 0.00 %0 25,400
Billings to Departments 3,350,572 1,675,286 (1,675,286)50.00 %1,626,490 3,252,980
Contributions & Donations - Capital 0 0 0 0.00 %0 656,909
Interest Income 100,040 76,871 (23,169)76.84 %135,544 65,223
Other 40,000 50,135 10,135 125.34 %34,588 49,446
Transfers In 0 0 0 0.00 %0 268,341
Total Revenue 3,490,612 1,802,293 (1,688,319)51.63 %1,796,622 4,318,299
Expense:
Personal Services 462,538 214,481 (248,057)46.37 %188,691 436,785
Materials and Supplies 810,100 249,336 (560,764)30.78 %256,420 558,012
Employee Development & Meetings 1,500 833 (667)55.53 %100 175
Dues & Subscriptions 2,000 1,590 (411)79.48 %1,580 1,759
Contractual Services 129,900 39,979 (89,921)30.78 %32,147 86,455
Equipment 113,500 1,851 (111,649)1.63 %1,603 10,087
Capital Improvements 1,552,600 452,963 (1,099,637)29.17 %753,319 0
Depreciation 0 1,835 1,835 0.00 %0 1,298,162
Allocations 110,341 55,171 (55,170)50.00 %56,928 113,855
Transfers Out 304,463 0 (304,463)0.00 %0 105,645
Other Expense 3,670 736 (2,934)20.06 %566 1,805
Total Expense 3,490,612 1,018,774 (2,471,838)29.19 %1,291,354 2,612,741
Net Total 0 783,519 783,519 0.00 %505,268 1,705,559
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 13
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 30
Fund: 610 - Public Facilities
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Billings to Departments 1,799,491 899,746 (899,745)50.00 %873,539 1,747,078
Contributions & Donations - Capital 0 0 0 0.00 %0 212,871
Interest Income 80,030 62,746 (17,284)78.40 %110,712 54,168
Other 0 69 69 0.00 %4,155 4,158
Transfers In 127,881 0 (127,881)0.00 %0 0
Total Revenue 2,007,402 962,561 (1,044,841)47.95 %988,406 2,018,275
Expense:
Personal Services 252,762 78,602 (174,160)31.10 %111,760 238,026
Materials and Supplies 45,000 18,251 (26,750)40.56 %16,765 36,753
Employee Development & Meetings 3,000 0 (3,000)0.00 %20 20
Dues & Subscriptions 1,000 481 (519)48.05 %0 264
Contractual Services 875,800 287,455 (588,345)32.82 %341,391 801,756
Equipment 500 5,880 5,380 1,176.00 %9,788 39,018
Capital Improvements 786,000 24,835 (761,165)3.16 %94,293 0
Depreciation 0 0 0 0.00 %0 101,508
Allocations 41,528 20,764 (20,764)50.00 %13,877 27,754
Transfers Out 0 0 0 0.00 %0 182,911
Other Expense 1,812 593 (1,219)32.70 %457 1,485
Total Expense 2,007,402 436,859 (1,570,543)21.76 %588,351 1,429,495
Net Total 0 525,702 525,702 0.00 %400,055 588,781
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 14
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 31
Fund: 620 - Information Technology
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Intergovernmental 0 0 0 0.00 %0 6,655
Charges for Services 0 32 32 0.00 %73 131
Billings to Departments 2,381,102 1,190,551 (1,190,551)50.00 %1,086,588 2,173,177
Contributions & Donations - Capital 0 0 0 0.00 %0 117,337
Interest Income 75,000 57,535 (17,465)76.71 %96,419 47,651
Other 0 107 107 0.00 %767 2,038
Transfers In 317,388 0 (317,388)0.00 %0 0
Total Revenue 2,773,490 1,248,225 (1,525,265)45.01 %1,183,847 2,346,989
Expense:
Personal Services 645,610 310,175 (335,435)48.04 %293,351 614,421
Materials and Supplies 58,500 5,455 (53,045)9.33 %13,582 31,179
Employee Development & Meetings 25,500 6,308 (19,192)24.74 %5,670 8,627
Dues & Subscriptions 250 0 (250)0.00 %0 0
Contractual Services 820,856 645,563 (175,293)78.65 %638,786 776,923
Equipment 125,000 135,305 10,305 108.24 %146,899 189,155
Capital Improvements 1,047,000 200,260 (846,740)19.13 %151,509 0
Depreciation 0 0 0 0.00 %0 170,684
Allocations 38,234 19,117 (19,117)50.00 %18,551 37,101
Transfers Out 0 0 0 0.00 %0 174,816
Other Expense 12,540 490 (12,050)3.91 %394 1,302
Total Expense 2,773,490 1,322,674 (1,450,817)47.69 %1,268,740 2,004,208
Net Total 0 (74,449)(74,449)0.00 %(84,893)342,781
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 15
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 32
Fund: 630 - Risk Management
Reporting Period: January, 2017 To June, 2017 (6 Months)
Fund Category: Multiple; Fund: All; Department: All; Division: All; Account Category: All; GL
Account: All; Program: All
Budget
YTD Actual
Amount
Budget
Less
YTD Actual
% of
Budget
Prior Year
YTD
Actual
Amount
Prior Year
Total
Actual
Amount
Revenue:
Billings to Departments 553,490 276,745 (276,745)50.00 %356,600 713,200
Interest Income 105,050 82,039 (23,011)78.09 %141,401 68,516
Other 90,000 50,592 (39,408)56.21 %48,622 283,686
Transfers In 255,512 0 (255,512)0.00 %0 0
Total Revenue 1,004,052 409,376 (594,676)40.77 %546,622 1,065,402
Expense:
Personal Services 0 26,429 26,429 0.00 %33,710 66,109
Materials and Supplies 500 0 (500)0.00 %0 45
Employee Development & Meetings 500 0 (500)0.00 %0 0
Dues & Subscriptions 615 445 (170)72.36 %425 425
Contractual Services 964,636 812,107 (152,529)84.19 %618,143 1,126,665
Equipment 600 0 (600)0.00 %0 0
Allocations 12,101 6,051 (6,050)50.00 %6,141 12,282
Transfers Out 0 0 0 0.00 %0 46,106
Other Expense 25,100 4,834 (20,266)19.26 %8,543 14,209
Total Expense 1,004,052 849,865 (154,187)84.64 %666,962 1,265,842
Net Total 0 (440,489)(440,489)0.00 %(120,340)(200,440)
Aug 09, 2017 03:21 PM Actual vs Budget Year to Date with Prior Year Comparison Page 16
Actual vs Budget Year to Date with Prior Year Comparison
by Fund:
Page 33
City of Plymouth InvestmentsPortfolio ManagementJune 30, 2017City of PlymouthPortfolio Summary% ofPortfolioBookValueInvestmentsMarketValueParValueDays toMaturityTermYTM365 Equiv.Certificates of Deposit2,464,000.00 1,7852.111.9518342,480,290.782,464,000.00Bankers Acceptances -Amortizing4,990,479.29 1074.281.095614,990,014.055,000,000.00Federal Agency Coupon Securities57,432,136.08 2,08649.261.6091,29956,847,763.2357,441,176.47Miscellaneous Coupon Securities803,374.423,5300.692.7342,435805,440.26782,459.43Pass Through Securities (GNMA/CMO)8,346,650.923,6567.162.0952,4418,246,196.527,970,501.48Municipal Bonds42,550,664.542,30236.501.9931,53442,324,377.7041,900,000.00116,587,305.25 100.00%Investments115,694,082.54115,558,137.382,196 1,411 1.777Cash and Accrued Interest116,641,452.04Total Cash and Investments54,146.79Subtotal54,146.79115,748,229.33115,558,137.3854,146.7954,146.792,196 1,411 1.777Accrued Interest at PurchaseCurrent YearJune 30176,151.17Average Daily BalanceEffective Rate of Return118,738,033.641.80%Total EarningsMonth Ending__________________________________________________ ____________________Patti Weitgenant, AccountantPortfolio INVTAPReporting period 06/01/2017-06/30/2017Run Date: 07/11/2017 - 08:56PM (PRF_PM1) 7.3.0No fiscal year history availableReport Ver. 7.3.3aPage 34
Moody'sPage 1Par ValueBook ValueMaturityDateStatedRateMarket ValueJune 30, 2017Portfolio Details - InvestmentsAverageBalanceIssuerPortfolio ManagementCity of Plymouth InvestmentsDays toMaturityS&PCUSIPInvestment #PurchaseDateCertificates of DepositAmerican Express Centurion Bk10636248,000.00248,000.0011/29/20192.20011/28/2014250,398.1602587DWK0881Capital One Bank U VA US10632248,000.00248,000.0011/26/20192.10011/26/2014250,343.60140420RC6878CIT Bank Lake City Utah CTF DE10633248,000.00248,000.0011/26/20192.20011/26/2014250,985.9217284C4L5878Discover Bank DE US10634248,000.00248,000.0011/26/20192.10011/26/2014250,400.64254672EP9878Firstbank P R Santurce CD10502249,000.00249,000.0011/02/20171.25011/02/2012249,104.5833764JNN1124Goldman Sachs Bnk USA New York10591245,000.00245,000.0006/11/20192.00006/11/2014246,631.7038147JG55710Sallie Mae bk Murray Utah C/D10841245,000.00245,000.0006/21/20222.35006/21/2017246,038.80795450A701,816Synchrony Bk Retail CTF10592245,000.00245,000.0006/13/20192.00006/13/2014246,866.9087165HAP5712Third Federal Savings & Loan A10631248,000.00248,000.0011/25/20192.00011/24/2014250,346.0888413QAW8877First Source Bank in US10657240,000.00240,000.0002/11/20191.30004/10/2015239,174.4033646CEP55902,464,000.002,480,290.782,464,000.002,424,666.67Subtotal and Average834US Bank Sweep - Money Market FundUS Bank Money Center - Monthly103750.000.00 0.15012/01/20100.00049210089710.000.000.000.00Subtotal and Average0Bankers Acceptances -AmortizingUS Bank Money Center - Monthly10828400,000.00399,026.6709/12/20171.20003/20/2017399,100.449033A0WC073US Bank Money Center - Monthly10832476,665.00475,086.9810/10/20171.18004/18/2017475,205.889033A0XA3101US Bank Money Center - Monthly10833753,471.00753,224.8707/13/20170.98004/24/2017752,973.719033A0UD012US Bank Money Center - Monthly10834439,449.00439,320.0907/12/20170.96004/27/2017439,169.709033A0UC211US Bank Money Center - Monthly10835601,432.00598,869.2311/08/20171.18005/15/2017599,058.029033A0Y87130US Bank Money Center - Monthly10836300,000.00299,878.6707/17/20170.91005/17/2017299,767.509033A0UH116US Bank Money Center - Monthly10837395,357.00394,796.9108/21/20171.00005/25/2017394,690.169033A0VM951US Bank Money Center - Monthly10838348,449.00347,872.2208/29/20171.01006/06/2017347,790.049033A0VV959US Bank Money Center - Monthly10839335,740.00335,303.5408/15/20171.04006/19/2017335,236.399033A0VF445US Bank Money Center - Monthly10840300,000.00299,725.3408/02/20171.03006/20/2017299,647.509033A0V2332US Bank Money Center - Monthly10847300,000.00298,805.3411/06/20171.12006/26/2017298,832.179033A0Y61128US Bank Money Center - Monthly10852349,437.00348,569.4309/21/20171.09006/29/2017348,542.549033A0WM8824,990,479.294,990,014.055,000,000.004,956,051.97Subtotal and Average61Federal Agency Coupon SecuritiesFedl Agric Mtg Corp105121,000,000.001,000,000.0011/29/20212.00011/29/2012998,020.0031315PQL61,612Fedl Agric Mtg Corp107682,000,000.002,000,000.0007/19/20211.26007/19/20161,946,280.003132X0HQ71,479Fedl Mgric Mtg Corp104781,000,000.001,000,000.0009/27/20191.40009/27/2012994,960.0031315PVD8818Federal Farm Credit Bank107241,000,000.001,000,000.0002/16/20222.00002/16/2016979,690.003133EFZL41,691Portfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PM2) 7.3.0Report Ver. 7.3.3aPage 35
Moody'sPage 2Par ValueBook ValueMaturityDateStatedRateMarket ValueJune 30, 2017Portfolio Details - InvestmentsAverageBalanceIssuerPortfolio ManagementCity of Plymouth InvestmentsDays toMaturityS&PCUSIPInvestment #PurchaseDateFederal Agency Coupon SecuritiesFederal Farm Credit Bank107342,000,000.002,000,000.0003/30/20201.49003/30/20161,984,100.003133EFV201,003Federal Farm Credit Bank107401,000,000.001,000,000.0004/19/20221.92004/29/2016991,950.003133EF4A21,753Federal Farm Credit Bank107421,000,000.001,000,000.0005/16/20232.00005/16/2016980,680.003133EGAD72,145Federal Farm Credit Bank107431,000,000.001,000,000.0002/17/20211.58005/17/2016991,030.003133EGAZ81,327Federal Farm Credit Bank107641,000,000.001,000,000.0007/14/20211.48007/14/2016982,160.003133EGLU71,474Federal Farm Credit Bank107651,000,000.001,000,000.0008/14/20221.72007/14/2016981,100.003133EGLZ61,870Federal Farm Credit Bank107671,000,000.001,000,000.0001/19/20211.44007/19/2016969,490.003133EGMP71,298Federal Farm Credit Bank108071,000,000.00971,164.6104/25/20231.82001/17/2017975,150.003133EGZV02,124Federal Home Loan Bank10484441,176.47441,176.4710/24/20191.37010/24/2012437,863.23313380Z75845Federal Home Loan Bank106672,000,000.002,000,000.0006/22/20181.15006/25/20151,997,060.003130A5QA0356Federal Home Loan Bank106932,000,000.002,000,000.0007/26/20222.23010/26/20151,992,300.003130A6LE51,851Federal Home Loan Bank106961,000,000.00999,319.7210/26/20170.62511/06/2015998,490.003130A6LZ8117AaaFederal Home Loan Bank107102,000,000.002,000,000.0001/27/20222.00001/27/20161,956,480.00AAA3130A73W31,671Federal Home Loan Bank107141,000,000.001,001,861.2301/27/20221.50002/08/2016997,270.003130A72V61,671Federal Home Loan Bank107191,000,000.001,000,000.0002/10/20201.37002/10/2016989,720.003130A7A70954Federal Home Loan Bank107481,000,000.001,027,521.2403/11/20222.25005/25/20161,014,300.00313378CR01,714Federal Home Loan Bank107551,000,000.001,000,000.0006/13/20232.00006/13/2016984,800.003130A8EP42,173Federal Home Loan Bank107561,000,000.001,000,000.0006/13/20232.00006/13/2016984,800.003130A8EP42,173AaaFederal Home Loan Bank107801,000,000.00999,555.3609/22/20231.83009/22/2016968,360.00AAA3130A9GV72,274AaaFederal Home Loan Bank108181,000,000.001,000,000.0001/26/20242.67001/26/20171,000,710.00AAA3130AAPY82,400Federal Home Loan Bank108422,000,000.001,997,508.6611/22/20232.25006/23/20171,979,620.003130AA5J32,335Federal Home Loan Bank108482,000,000.002,000,000.0006/27/20242.55006/27/20171,983,480.003130ABJW72,553Federal Home Loan Mtg Corp104611,000,000.001,000,000.0006/27/20191.50006/27/20121,000,590.003134G3XJ4726Federal Home Loan Mtg Corp104722,000,000.002,000,000.0008/21/20201.55008/21/20121,991,960.003134G3D641,147Federal Home Loan Mtg Corp104732,000,000.002,000,000.0002/22/20181.00008/22/20121,995,160.003134G3B41236Federal Home Loan Mtg Corp105082,000,000.002,000,000.0005/14/20181.00011/14/20121,994,980.003134G3T26317Federal Home Loan Mtg Corp106491,000,000.001,000,000.0012/29/20171.00003/30/2015998,950.003134G6OZ9181Federal Home Loan Mtg Corp106941,000,000.001,000,000.0010/27/20170.75010/27/2015998,980.003134G7S69118Federal Home Loan Mtg Corp107151,000,000.001,000,035.7807/14/20170.75002/08/2016999,900.003137EADV813Federal Home Loan Mtg Corp107811,000,000.001,000,000.0009/22/20231.75009/22/2016960,320.003134GAHJ62,274Federal Home Loan Mtg Corp107932,000,000.001,997,302.8610/13/20231.20010/17/20161,962,160.003134GAQL12,295Federal National Mtg Assn104802,000,000.002,000,289.0510/03/20181.13510/05/20121,991,120.003136G0N64459Federal National Mtg Assn104871,000,000.00999,889.3510/29/20181.00010/29/2012995,500.003136G0X22485Federal National Mtg Assn104882,000,000.002,000,000.0010/30/20181.18010/30/20122,000,320.003136G02M2486Federal National Mtg Assn104992,000,000.002,000,000.0001/30/20201.35011/05/20121,989,060.003136G0X63943Federal National Mtg Assn105741,000,000.00996,511.7505/21/20181.03002/19/2014997,570.003135G0XA6324Portfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PM2) 7.3.0Page 36
Moody'sPage 3Par ValueBook ValueMaturityDateStatedRateMarket ValueJune 30, 2017Portfolio Details - InvestmentsAverageBalanceIssuerPortfolio ManagementCity of Plymouth InvestmentsDays toMaturityS&PCUSIPInvestment #PurchaseDateFederal Agency Coupon SecuritiesFederal National Mtg Assn107581,000,000.001,000,000.0006/14/20211.80006/14/20161,000,280.003136G3RK31,444Federal National Mtg Assn107832,000,000.002,000,000.0012/28/20211.50009/28/20161,938,320.003136G35U51,641Federal National Mtg Assn107851,000,000.001,000,000.0009/30/20211.62509/30/2016972,730.003136G4AH61,55257,432,136.0856,847,763.2357,441,176.4754,900,507.00Subtotal and Average1,299Miscellaneous Coupon SecuritiesSmall Business Administration10595782,459.43803,374.4203/01/20243.19107/02/2014805,440.26831641FA82,435803,374.42805,440.26782,459.43803,498.97Subtotal and Average2,435Pass Through Securities (GNMA/CMO)Federal Home Loan Mtg Corp107631,500,000.001,552,968.7509/25/20222.57305/27/20161,521,285.003137AXHP11,912Federal National Mtg Assn10420780,725.85830,009.1708/01/20214.00008/16/2011814,250.2231417Y4V61,492Federal National Mtg Assn10421694,033.38730,687.0207/01/20254.00008/16/2011729,422.1431419AMZ72,922Federal National Mtg Assn10659696,313.44716,767.6510/01/20272.50004/20/2015704,578.6831417DL763,744Federal National Mtg Assn10814548,601.33546,715.5212/01/20222.21001/20/2017549,089.593138L16Z71,979GNMA10366553,648.15591,538.4505/15/20254.50007/28/2010589,358.463620AWE482,875GNMA104031,191,437.701,238,722.8805/15/20263.50006/16/20111,246,351.0636241LU953,240FHMS K041 A2108121,000,000.001,040,468.7510/25/20243.17101/20/20171,038,870.003137BFE982,673Small Bus. Admin Pool #522068106181,005,741.631,098,772.7311/25/20214.16709/22/20141,052,991.3783165AQV91,6088,346,650.928,246,196.527,970,501.488,430,169.34Subtotal and Average2,441Municipal BondsThree Crowns Funding LLC106691,315,000.001,391,688.4909/01/20194.44606/29/20151,393,768.50052396UY2792Allen Cmnty Dev-Ref108111,000,000.00974,221.6709/01/20252.35301/20/2017983,350.00018100DN42,984Andover Minn Ult G.O. Series10519910,000.00916,723.3502/01/20202.00012/27/2012913,749.20034313ZQ2945Andover Minn Ult G.O. Series10520925,000.00928,890.1402/01/20212.00012/27/2012926,766.75034313ZR01,311Arkansas-Ref-Txbl10653300,000.00300,000.0007/01/20171.50004/01/2015300,006.00041042SJ20Bloomingdale MI Public Schools107391,230,000.001,254,142.2705/01/20212.49004/29/20161,236,888.00094383FR21,400Carmel IN Redev Auth10718775,000.00792,068.5208/01/20212.43002/10/2016787,121.0014329NEB61,492District of Columbia107661,055,000.001,168,234.9006/01/20205.27007/15/20161,141,562.7525476FKZ01,066P-1FL HURRICANE-SER106511,000,000.001,003,879.7607/01/20182.10703/30/20151,005,920.00A-134074GDG6365AaaGeorgia ST GO BDS 2016B GO10759500,000.00510,723.2502/01/20202.00007/07/2016503,670.00AAA3733844Q6945Green Bay Wis Area Pub Sch BDS105151,455,000.001,461,562.8304/01/20211.90012/11/20121,451,217.00392643TB81,370Green Bay Wis Area Pub Sch BDS10516930,000.00932,622.0704/01/20201.65012/11/2012924,885.00392643TA01,005Itasca Cnty Minn Indpt Sch Dis10815500,000.00502,392.4702/01/20242.65001/20/2017508,960.00465468DG82,406AaMemphis-C-Babs10778500,000.00587,230.0807/01/20245.05609/15/2016567,280.00AA586145WG52,557Portfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PM2) 7.3.0Page 37
Moody'sPage 4Par ValueBook ValueMaturityDateStatedRateMarket ValueJune 30, 2017Portfolio Details - InvestmentsAverageBalanceIssuerPortfolio ManagementCity of Plymouth InvestmentsDays toMaturityS&PCUSIPInvestment #PurchaseDateMunicipal BondsMetropolitan Council Minn104671,000,000.001,000,161.3509/01/20171.20007/24/20121,000,620.00591852UW662Milan Mich Area Schools107541,000,000.001,015,532.8105/01/20212.13106/03/2016990,320.00AA598801JE91,400Minnetonka Minn Indpt Sch Dist105241,000,000.001,014,260.6401/01/20262.90002/14/20131,017,790.00604195VE43,106Mounds View MN Indep School108432,000,000.002,077,538.2702/01/20243.00006/23/20172,053,380.00620637W872,406Muskego Norway WI Sch Dis105301,000,000.001,004,200.9904/01/20191.50005/06/2013999,140.00627627QC9639Northeast IA Cmnty Clg10849530,000.00530,000.0006/01/20242.45006/29/2017527,599.10664214MG52,527Northeast IA Cmnty Clg10850555,000.00555,000.0006/01/20262.70006/29/2017553,684.65664214MJ93,257Northeast IA Cmnty Clg10851375,000.00375,000.0006/01/20272.85006/29/2017374,028.75664214MK63,622City of New York NY106762,000,000.001,945,667.7611/01/20232.40007/14/20151,976,920.0064971QJ202,314New Mexico St Fin107211,190,000.001,237,513.4206/15/20223.10002/10/20161,221,903.9064711NVA01,810Northbrook IL Taxable (AAA)105211,000,000.001,000,680.4812/01/20181.25001/10/2013996,310.00663821SJ6518AaNewton Cnty GA Sch Dist Ser B107841,000,000.001,105,967.1304/01/20254.97309/30/20161,080,890.00AA652577FA02,831New York City NY Transitional105131,000,000.00999,805.0911/01/20170.98012/04/2012999,630.0064971QH48123New York City NY Transitional108441,000,000.00971,826.9808/01/20221.70006/26/2017967,130.0064966MED71,857New York St Dorm Auth St Pers106711,000,000.001,004,382.2402/15/20191.79006/29/20151,005,160.0064990EJ57594Shepherd Mich Pub Schs108241,000,000.001,000,000.0005/01/20232.55002/15/20171,012,120.00823348DS32,130Sioux City IA10845675,000.00675,000.0006/01/20262.70006/26/2017673,400.25829458HZ43,257Stifel Nicolaus107201,000,000.001,028,226.1907/01/20202.99502/10/20161,022,100.0034074GDH41,096State of CA - Txb GO107511,000,000.00996,036.7004/01/20211.50005/27/2016982,280.0013063CP871,370State of MN GO10613585,000.00582,663.5708/01/20202.08009/16/2014588,650.406041293K01,127Superior WI Sch Dist10788300,000.00300,000.0003/01/20241.95010/04/2016293,046.00AA868424JW32,435Superior WI Sch Dist10789295,000.00313,862.6603/01/20233.00010/04/2016308,130.45868424JV52,069Texas St Transn Commn Hwy Impt105172,000,000.002,003,340.7004/01/20191.25012/18/20121,989,660.008827227B1639Univ of Pttsburgh PA108161,000,000.001,006,548.0909/15/20232.73201/20/20171,008,110.00914805EU62,267Victor VLY CA Cmnty Clg D108461,000,000.001,003,444.0808/01/20252.72806/26/2017987,260.0092603PEV02,953Washington St Taxable104712,000,000.002,001,669.3608/01/20181.20008/07/20121,995,200.0093974CX70396Wilmot Wis Union High Sch Dist108091,000,000.001,020,655.8903/01/20222.60001/18/20171,015,570.00AA971838DN41,704Whitemore Lake SD - B107532,000,000.002,057,300.3405/01/20212.74905/27/20162,039,200.00966578LW41,40042,550,664.5442,324,377.7041,900,000.0047,223,139.70Subtotal and Average1,534118,738,033.64115,558,137.381,411115,694,082.54 116,587,305.25Total and AveragePortfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PM2) 7.3.0Page 38
Moody'sPage 5Par ValueBook ValueStatedRateMarket ValueJune 30, 2017Portfolio Details - CashAverageBalanceIssuerPortfolio ManagementCity of Plymouth InvestmentsDays toMaturityS&PCUSIPInvestment #PurchaseDate0.00118,738,033.64 115,558,137.381,411054,146.7954,146.7954,146.7954,146.79SubtotalAccrued Interest at PurchaseAverage Balance115,748,229.33 116,641,452.04Total Cash and InvestmentsPortfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PM2) 7.3.0Page 39
Page 1Par ValueStatedRateJune 30, 2017Investment Status Report - InvestmentsPortfolio ManagementBook ValueMaturityDateCurrentPrincipalCity of Plymouth InvestmentsYTM365Days toMaturityMarket ValueCUSIPInvestment # IssuerPurchaseDateAccrued InterestAt PurchaseCertificates of DepositAMEX10636248,000.00248,000.002.20011/29/201902587DWK0250,398.1611/28/2014248,000.002.200881CAPONE10632248,000.00248,000.002.10011/26/2019140420RC6250,343.6011/26/2014248,000.002.100878CITBAN10633248,000.00248,000.002.20011/26/201917284C4L5250,985.9211/26/2014248,000.002.200878DISCOV10634248,000.00248,000.002.10011/26/2019254672EP9250,400.6411/26/2014248,000.002.100878FRSTBK10502249,000.00249,000.001.25011/02/201733764JNN1249,104.5811/02/2012249,000.001.250124GOLDMN10591245,000.00245,000.002.00006/11/201938147JG55246,631.7006/11/2014245,000.002.000710SALLIE10841245,000.00245,000.002.35006/21/2022795450A70246,038.8006/21/2017245,000.002.3501,816SYNCHR10592245,000.00245,000.002.00006/13/201987165HAP5246,866.9006/13/2014245,000.002.000712THIRDF10631248,000.00248,000.002.00011/25/201988413QAW8250,346.0811/24/2014248,000.002.000877ZBDKW10657240,000.00240,000.001.30002/11/201933646CEP5239,174.4004/10/2015240,000.001.3005902,464,000.00Certificates of Deposit Totals2,464,000.000.008342,464,000.001.9512,480,290.78US Bank Sweep - Money Market FundUSBANK103750.000.000.15004921008970.0012/01/20100.000.15010.00US Bank Sweep - Money Market Fund Totals0.000.0000.000.0000.00Bankers Acceptances -AmortizingUSBANK10828400,000.00399,026.671.20009/12/20179033A0WC0399,100.4403/20/2017397,653.331.24173USBANK10832476,665.00475,086.981.18010/10/20179033A0XA3475,205.8804/18/2017473,930.801.220101USBANK10833753,471.00753,224.870.98007/13/20179033A0UD0752,973.7104/24/2017751,830.111.01012USBANK10834439,449.00439,320.090.96007/12/20179033A0UC2439,169.7004/27/2017438,558.380.98911USBANK10835601,432.00598,869.231.18011/08/20179033A0Y87599,058.0205/15/2017597,942.691.220130USBANK10836300,000.00299,878.670.91007/17/20179033A0UH1299,767.5005/17/2017299,537.420.93716USBANK10837395,357.00394,796.911.00008/21/20179033A0VM9394,690.1605/25/2017394,390.571.03051USBANK10838348,449.00347,872.221.01008/29/20179033A0VV9347,790.0406/06/2017347,627.821.04159USBANK10839335,740.00335,303.541.04008/15/20179033A0VF4335,236.3906/19/2017335,187.151.07145USBANK10840300,000.00299,725.341.03008/02/20179033A0V23299,647.5006/20/2017299,630.921.06032USBANK10847300,000.00298,805.341.12011/06/20179033A0Y61298,832.1706/26/2017298,758.671.156128USBANK10852349,437.00348,569.431.09009/21/20179033A0WM8348,542.5406/29/2017348,548.271.123824,990,479.29Bankers Acceptances -Amortizing Totals4,983,596.130.00615,000,000.001.0954,990,014.05Federal Agency Coupon SecuritiesFAMC10512 1,000,000.001,000,000.002.00011/29/202131315PQL6998,020.0011/29/20121,000,000.002.0001,612FAMC10768 2,000,000.002,000,000.001.26007/19/20213132X0HQ71,946,280.0007/19/20162,000,000.001.2601,479FAMCA10478 1,000,000.001,000,000.001.40009/27/201931315PVD8994,960.0009/27/20121,000,000.001.400818Portfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PMS) 7.3.0Report Ver. 7.3.3aPage 40
Page 2Par ValueStatedRateJune 30, 2017Investment Status Report - InvestmentsPortfolio ManagementBook ValueMaturityDateCurrentPrincipalCity of Plymouth InvestmentsYTM365Days toMaturityMarket ValueCUSIPInvestment # IssuerPurchaseDateAccrued InterestAt PurchaseFederal Agency Coupon SecuritiesFFCB10724 1,000,000.001,000,000.002.00002/16/20223133EFZL4979,690.0002/16/20161,000,000.002.1611,691FFCB10734 2,000,000.002,000,000.001.49003/30/20203133EFV201,984,100.0003/30/20162,000,000.001.4901,003FFCB10740 1,000,000.001,000,000.001.92004/19/20223133EF4A2991,950.00Received04/29/20161,000,000.001.9201,753FFCB107421,000,000.001,000,000.002.00005/16/20233133EGAD7980,680.0005/16/20161,000,000.002.0002,145FFCB107431,000,000.001,000,000.001.58002/17/20213133EGAZ8991,030.0005/17/20161,000,000.001.5801,327FFCB107641,000,000.001,000,000.001.48007/14/20213133EGLU7982,160.0007/14/20161,000,000.001.4801,474FFCB107651,000,000.001,000,000.001.72008/14/20223133EGLZ6981,100.0007/14/20161,000,000.001.7201,870FFCB107671,000,000.001,000,000.001.44001/19/20213133EGMP7969,490.0007/19/20161,000,000.001.4401,298FFCB108071,000,000.00971,164.611.82004/25/20233133EGZV0975,150.00Received01/17/2017968,906.252.3562,124FHLB10484441,176.47441,176.471.37010/24/2019313380Z75437,863.2310/24/2012441,176.471.370845FHLB106672,000,000.002,000,000.001.15006/22/20183130A5QA01,997,060.00Received06/25/20152,000,000.001.150356FHLB106932,000,000.002,000,000.002.23007/26/20223130A6LE51,992,300.0010/26/20152,000,000.002.2301,851FHLB106961,000,000.00999,319.720.62510/26/20173130A6LZ8998,490.00Received11/06/2015995,800.000.840117FHLB107102,000,000.002,000,000.002.00001/27/20223130A73W31,956,480.0001/27/20162,000,000.002.0001,671FHLB107141,000,000.001,001,861.231.50001/27/20223130A72V6997,270.00Received02/08/20161,002,430.002.2591,671FHLB107191,000,000.001,000,000.001.37002/10/20203130A7A70989,720.0002/10/20161,000,000.001.370954FHLB107481,000,000.001,027,521.242.25003/11/2022313378CR01,014,300.00Received05/25/20161,033,970.001.6331,714FHLB107551,000,000.001,000,000.002.00006/13/20233130A8EP4984,800.0006/13/20161,000,000.002.0002,173FHLB107561,000,000.001,000,000.002.00006/13/20233130A8EP4984,800.0006/13/20161,000,000.002.0002,173FHLB107801,000,000.00999,555.361.83009/22/20233130A9GV7968,360.0009/22/2016999,500.001.8382,274FHLB108181,000,000.001,000,000.002.67001/26/20243130AAPY81,000,710.0001/26/20171,000,000.002.6702,400FHLB108422,000,000.001,997,508.662.25011/22/20233130AA5J31,979,620.003,875.0006/23/20171,997,500.002.2712,335FHLB108482,000,000.002,000,000.002.55006/27/20243130ABJW71,983,480.0006/27/20172,000,000.002.5502,553FHLMC104611,000,000.001,000,000.001.50006/27/20193134G3XJ41,000,590.0006/27/20121,000,000.001.500726FHLMC104722,000,000.002,000,000.001.55008/21/20203134G3D641,991,960.0008/21/20122,000,000.001.5501,147FHLMC104732,000,000.002,000,000.001.00002/22/20183134G3B411,995,160.0008/22/20122,000,000.001.000236FHLMC105082,000,000.002,000,000.001.00005/14/20183134G3T261,994,980.0011/14/20122,000,000.001.000317FHLMC106491,000,000.001,000,000.001.00012/29/20173134G6OZ9998,950.0003/30/20151,000,000.001.000181FHLMC106941,000,000.001,000,000.000.75010/27/20173134G7S69998,980.0010/27/20151,000,000.000.750118FHLMC107151,000,000.001,000,035.780.75007/14/20173137EADV8999,900.00Received02/08/20161,001,420.000.65013FHLMC107811,000,000.001,000,000.001.75009/22/20233134GAHJ6960,320.0009/22/20161,000,000.001.7502,274FHLMC107932,000,000.001,997,302.861.20010/13/20233134GAQL11,962,160.00Received10/17/20161,997,000.002.1672,295FNMA104802,000,000.002,000,289.051.13510/03/20183136G0N641,991,120.00Received10/05/20122,001,380.001.123459FNMA104871,000,000.00999,889.351.00010/29/20183136G0X22995,500.0010/29/2012999,500.001.009485FNMA104882,000,000.002,000,000.001.18010/30/20183136G02M22,000,320.0010/30/20122,000,000.001.180486Portfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PMS) 7.3.0Page 41
Page 3Par ValueStatedRateJune 30, 2017Investment Status Report - InvestmentsPortfolio ManagementBook ValueMaturityDateCurrentPrincipalCity of Plymouth InvestmentsYTM365Days toMaturityMarket ValueCUSIPInvestment # IssuerPurchaseDateAccrued InterestAt PurchaseFederal Agency Coupon SecuritiesFNMA10499 2,000,000.002,000,000.001.35001/30/20203136G0X631,989,060.00Received11/05/20122,000,000.001.350943FNMA105741,000,000.00996,511.751.03005/21/20183135G0XA6997,570.00Received02/19/2014983,300.001.436324FNMA107581,000,000.001,000,000.001.80006/14/20213136G3RK31,000,280.0006/14/20161,000,000.001.8001,444FNMA107832,000,000.002,000,000.001.50012/28/20213136G35U51,938,320.0009/28/20162,000,000.001.5001,641FNMA107851,000,000.001,000,000.001.62509/30/20213136G4AH6972,730.0009/30/20161,000,000.001.6251,55257,432,136.08Federal Agency Coupon Securities Totals57,421,882.723,875.001,29957,441,176.471.609 56,847,763.23Miscellaneous Coupon SecuritiesSBA10595782,459.43803,374.423.19103/01/2024831641FA8805,440.268,567.6207/02/2014812,779.732.7342,435803,374.42Miscellaneous Coupon Securities Totals812,779.738,567.622,435782,459.432.734805,440.26Pass Through Securities (GNMA/CMO)FHLMC10763 1,500,000.001,552,968.752.57309/25/20223137AXHP11,521,285.00Received05/27/20161,552,968.751.2481,912FNMA10420780,725.85830,009.174.00008/01/202131417Y4V6814,250.22Received08/16/2011830,009.172.4811,492FNMA10421694,033.38730,687.024.00007/01/202531419AMZ7729,422.14Received08/16/2011730,687.022.9502,922FNMA10659696,313.44716,767.652.50010/01/202731417DL76704,578.68Received04/20/2015716,767.651.8453,744FNMA10814548,601.33546,715.522.21012/01/20223138L16Z7549,089.59Received01/20/2017546,715.522.2501,979GNMA10366553,648.15591,538.454.50005/15/20253620AWE48589,358.46Received07/28/2010591,538.453.2502,875GNMA104031,191,437.701,238,722.883.50005/15/202636241LU951,246,351.06Received06/16/20111,238,722.882.7813,240KFMS108121,000,000.001,040,468.753.17110/25/20243137BFE981,038,870.00Received01/20/20171,040,468.751.8882,673SBAPL106181,005,741.631,098,772.734.16711/25/202183165AQV91,052,991.37Received09/22/20141,098,772.731.3201,6088,346,650.92Pass Through Securities (GNMA/CMO) Totals8,346,650.920.002,4417,970,501.482.0958,246,196.52Municipal Bonds3 CROW10669 1,315,000.001,391,688.494.44609/01/2019052396UY21,393,768.50Received06/29/20151,462,674.501.649792ALLDEV108111,000,000.00974,221.672.35309/01/2025018100DN4983,350.00Received01/20/2017972,810.002.7022,984ANDOVE10519910,000.00916,723.352.00002/01/2020034313ZQ2913,749.2012/27/2012928,463.901.683945ANDOVE10520925,000.00928,890.142.00002/01/2021034313ZR0926,766.7512/27/2012933,787.501.8591,311ARS10653300,000.00300,000.001.50007/01/2017041042SJ2300,006.00Received04/01/2015305,481.000.6800BLOSCD107391,230,000.001,254,142.272.49005/01/2021094383FR21,236,888.00Received04/29/20161,261,524.902.1551,400CARDEV10718775,000.00792,068.522.43008/01/202114329NEB6787,121.00Received02/10/2016797,885.752.0001,492DISTRI107661,055,000.001,168,234.905.27006/01/202025476FKZ01,141,562.75Received07/15/20161,205,548.501.4911,066FLSGEN106511,000,000.001,003,879.762.10707/01/201834074GDG61,005,920.00Received03/30/20151,012,620.001.882365GEORGI10759500,000.00510,723.252.00002/01/20203733844Q6503,670.0007/07/2016514,805.001.150945GRNBAY105151,455,000.001,461,562.831.90004/01/2021392643TB81,451,217.0012/11/20121,469,535.451.7701,370Portfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PMS) 7.3.0Page 42
Page 4Par ValueStatedRateJune 30, 2017Investment Status Report - InvestmentsPortfolio ManagementBook ValueMaturityDateCurrentPrincipalCity of Plymouth InvestmentsYTM365Days toMaturityMarket ValueCUSIPInvestment # IssuerPurchaseDateAccrued InterestAt PurchaseMunicipal BondsGRNBAY10516930,000.00932,622.071.65004/01/2020392643TA0924,885.0012/11/2012936,965.701.5411,005ITASCA10815500,000.00502,392.472.65002/01/2024465468DG8508,960.00Received01/20/2017502,555.002.5702,406MEMPHI10778500,000.00587,230.085.05607/01/2024586145WG5567,280.00Received09/15/2016597,130.002.4482,557METROP104671,000,000.001,000,161.351.20009/01/2017591852UW61,000,620.00Received07/24/20121,004,940.001.21962MILAN107541,000,000.001,015,532.812.13105/01/2021598801JE9990,320.00Received06/03/20161,019,900.001.7071,400MINNTO105241,000,000.001,014,260.642.90001/01/2026604195VE41,017,790.00Received02/14/20131,021,610.002.6993,106MNDSCD108432,000,000.002,077,538.273.00002/01/2024620637W872,053,380.0023,666.6706/23/20172,077,800.002.3602,406MSNSCD105301,000,000.001,004,200.991.50004/01/2019627627QC9999,140.0005/06/20131,014,170.001.250639NEIHGR10849530,000.00530,000.002.45006/01/2024664214MG5527,599.1006/29/2017530,000.002.4392,527NEIHGR10850555,000.00555,000.002.70006/01/2026664214MJ9553,684.6506/29/2017555,000.002.6953,257NEIHGR10851375,000.00375,000.002.85006/01/2027664214MK6374,028.7506/29/2017375,000.002.8443,622NEWYOR106762,000,000.001,945,667.762.40011/01/202364971QJ201,976,920.00Received07/14/20151,928,820.002.8852,314NMSGEN107211,190,000.001,237,513.423.10006/15/202264711NVA01,221,903.90Received02/10/20161,250,856.602.4011,810NORTHB105211,000,000.001,000,680.481.25012/01/2018663821SJ6996,310.00Received01/10/20131,002,830.001.200518NWTSCD107841,000,000.001,105,967.134.97304/01/2025652577FA01,080,890.00Received09/30/20161,116,260.003.3882,831NYCITY105131,000,000.00999,805.090.98011/01/201764971QH48999,630.0012/04/2012997,130.001.039123NYCITY108441,000,000.00971,826.981.70008/01/202264966MED7967,130.006,847.2206/26/2017971,750.002.3111,857NYSHGR106711,000,000.001,004,382.241.79002/15/201964990EJ571,005,160.00Received06/29/20151,009,800.001.512594SHEPHE108241,000,000.001,000,000.002.55005/01/2023823348DS31,012,120.0002/15/20171,000,000.002.7712,130SIO10845675,000.00675,000.002.70006/01/2026829458HZ4673,400.25202.5006/26/2017675,000.002.7003,257STIFEL107201,000,000.001,028,226.192.99507/01/202034074GDH41,022,100.00Received02/10/20161,041,320.002.0071,096STOFCA107511,000,000.00996,036.701.50004/01/202113063CP87982,280.00Received05/27/2016994,880.001.6101,370STOFMN10613585,000.00582,663.572.08008/01/20206041293K0588,650.40Received09/16/2014580,548.152.2161,127SUPSCD10788300,000.00300,000.001.95003/01/2024868424JW3293,046.0010/04/2016300,000.001.9502,435SUPSCD10789295,000.00313,862.663.00003/01/2023868424JV5308,130.4510/04/2016316,331.451.8002,069TEXAS105172,000,000.002,003,340.701.25004/01/20198827227B11,989,660.0012/18/20122,012,000.001.151639UNIVPI108161,000,000.001,006,548.092.73209/15/2023914805EU61,008,110.00Received01/20/20171,007,020.002.5952,267VVYHGR108461,000,000.001,003,444.082.72808/01/202592603PEV0987,260.0010,987.7806/26/20171,003,450.002.6802,953WASHTN104712,000,000.002,001,669.361.20008/01/201893974CX701,995,200.00Received08/07/20122,009,220.001.120396WILMOT108091,000,000.001,020,655.892.60003/01/2022971838DN41,015,570.00Received01/18/20171,022,660.002.1461,704WTMSCD107532,000,000.002,057,300.342.74905/01/2021966578LW42,039,200.00Received05/27/20162,073,660.002.1211,40042,550,664.54Municipal Bonds Totals42,813,743.4041,704.171,53441,900,000.001.993 42,324,377.70Portfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PMS) 7.3.0Page 43
Page 5Par ValueStatedRateJune 30, 2017Investment Status Report - InvestmentsPortfolio ManagementBook ValueMaturityDateCurrentPrincipalCity of Plymouth InvestmentsYTM365Days toMaturityMarket ValueCUSIPInvestment # IssuerPurchaseDateAccrued InterestAt Purchase116,587,305.25Investment Totals115,694,082.54116,842,652.9054,146.79115,558,137.381,411 1.777Portfolio INVTAPRun Date: 07/11/2017 - 08:56PM (PRF_PMS) 7.3.0Page 44
user: Jodi Bursheim Pages 1 of 2 Wednesday, August 09, 2017
Description Cash Balance
General Fund $17,688,247.95
Recreation Fund $628,996.90
Parker's Lake Cemetery Maintnce $143,480.14
Transit System $7,389,224.40
Community Development $56,634.49
Economic Development $97,928.94
Lawful Gambling $25,279.50
Community Dev Block Grant (CDBG)($2,310.01)
HRA Section 8 $567,748.75
HRA General $2,093,007.15
2003D - Open Space Refunding $93,811.73
2003B - GO Street Reconstruction $115,163.33
2003C - Special Assmt Strt Recon $359,379.21
2004A - GO Public Safety $1,033,714.48
2005A - TIF #1-1 $876,255.43
2007A - Opens Space Series ($109.65)
2009A - TIF 7-5A - Refund 1998A ($217,871.95)
2009B - AC and FH Refunding $5,424.16
2010A - GO Open Space $70,035.09
2012A GO Refunding 2004A ($474,061.21)
2015A GO Open Space $17,851.83
CON - Const Imprvmnts - General $3,017,356.59
FND - Minnesota State Aid $5,539,427.71
FND - Community Improvement $5,041,156.86
FND - Park Replacement $2,907,915.11
FND - Street Reconstruction $9,059,273.93
FND - Admin - Pre-construction $547,115.96
FND - Park Const Dedication Fees $6,135,321.66
FND - Capital Improvement $4,009,137.75
ENT - FND - Water Sewer Replace $4,843,419.91
CON - Constr Imprvmnts - Streets $4,141,080.23
CON-Project Warranty Repairs ($209.04)
ENT - FND - Util Trunk Expansion $7,858,687.42
ENT - Water Sewer Construction ($504,078.29)
ENT - Water Resources Constrctn ($237,523.40)
TIF - 7-4 - PTP Construction $490,697.36
TIF - 7-5 - Rottland ($2,763.89)
100
200
210
City of Plymouth
Cash Balance Report
30-Jun-17
Fund
240
250
254
220
230
234
309
310
303
305
258
301
302
315
400
401
311
312
314
407
408
409
404
405
406
418
420
421
412
413
417
422
423
Page 45
user: Jodi Bursheim Pages 2 of 2 Wednesday, August 09, 2017
City of Plymouth
Cash Balance Report
30-Jun-17
TIF - 7-6 - Berkshire $614,279.04
TIF - Housing Assistance Program $67,116.12
TIF - 7-7 - Stonecreek $68,037.59
TIF - 1-1 - Shops at Plymth Crk $190,110.20
TIF - 1-2 - Vicksburg Commons $13,179.27
TIF -1-3 - Crossroads Stations $141,634.74
TIF - 7-8 Quest ($2,233.90)
Water $2,187,771.65
Water Resources $3,166,674.59
Sewer $3,048,795.52
Solid Waste Mgmt $1,358,696.33
Ice Center $1,184,732.31
Field House $1,781,539.23
Central Equipment $7,786,256.20
Public Facilities $6,193,756.46
Information Technology $5,102,455.12
Risk Management $6,836,693.80
Employee Benefits $6,162,672.79
Resource Planning $3,203,195.73
Parker's Lake Cemetery $192,506.91
Plymouth Town Square $551,552.85
Vicksburg Crossing $464,825.30
$133,728,094.38
425
426
427
424
500
510
520
428
429
432
600
610
620
530
540
550
700
850
851
630
640
660
Page 46