HomeMy WebLinkAboutAgenda Packets - 2011/10/03
CITY OF MOUNDS VIEW
CITY COUNCIL WORK SESSION AGENDA
MOUNDS VIEW CITY HALL
Monday, October 3, 2011
7:00 p.m.
ROLL CALL: Flaherty, Stigney, Hull, Mueller, Gunn
PUBLIC COMMENT
Citizens may speak to issues not on tonight’s agenda. Before speaking, please give your
full name and address for the minutes. Also, please limit your comments to three minutes.
Agenda Items Discussed by Consensus
1. Review Proposed Revisions to Tobacco Licensing Requirements
2. Continue Discussion Regarding Potential K9 Unit
3. Other Funds Budgets for 2012
Next Work Session: Monday, November 7, 2011, at 7pm
Next City Council Meeting: Monday, October 10, 2011, at 7pm
Item No: 1
Meeting Date: October 3, 2011
Type of Business: Work Session
City of Mounds View Staff Report
To: Honorable Mayor and City Council
From: James Ericson, City Administrator
Item Title/Subject: Review Proposed Revisions to Tobacco Licensing
Requirements
Introduction:
On May 9th of this year, the City Council adopted Interim Ordinance 859 establishing a
temporary moratorium on new tobacco products licenses and zoning approval for a period
not to exceed 12 months to give the City sufficient time to review the current laws, model
ordinance language, zoning issues and licensing matters. Since that time, staff has been
working with representatives from the Ramsey Tobacco Coalition to review model
language they prepared with the League of Minnesota Cities and the Public Health Law
Center for purposes of incorporating the same or similar language into the City’s code.
Discussion:
While many businesses sell tobacco products as part of their retail operation, only two
businesses in the City are licensed solely for tobacco sales—Vino and Stogies and
Tobacco View. Staff sent letters to both business owners and requested an opportunity to
meet and discuss their operations. While Tobacco View did not respond to my letter, I was
able to meet with Greg Waste of Vino and Stogies. One of the questions the City asked of
Mr. Waste was how important the “sampling” provision was for his business. He indicated
retaining such a provision would be critical to the success of his business, as many
customers will not purchase quantities of product without sampling first. Staff asked the
Ramsey Tobacco Coalition for potential language to allow Vino and Stogies to continue
sampling while prohibiting all others, present and future, from doing so. (To our
knowledge, the only other affected business, Tobacco View, does not permit sampling of
product within their premises.)
Recommendation:
Review the attached draft Ordinance 865 which incorporates language prepared by the
Ramsey Tobacco Coalition, League of Minnesota City and the Public Health Law Center.
Representatives from Ramsey Tobacco Coalition will be present to answer questions of the
Council.
Respectfully submitted,
________________________
James Ericson
City Administrator
ORDINANCE NO. 865
CITY OF MOUNDS VIEW
COUNTY OF RAMSEY
STATE OF MINNESOTA
AN ORDINANCE REGULATING THE POSSESSION, SALE AND CONSUMPTION OF
TOBACCO AND TOBACCO RELATED DEVICES AND PRODUCTS WITHIN THE
CITY OF MOUNDS VIEW
THE CITY OF MOUNDS VIEW ORDAINS:
Section 1. The City Council of the City of Mounds View hereby amends Title 500, Chapter
512 of the Mounds View City Code, regulating the sale or distribution of cigarette and
tobacco products within the City through the issuance of a tobacco license, by deleting the
Chapter in its entirety.
Section 2. The City Council of the City of Mounds View hereby amends Title 500 by
adding a new Chapter 512 of the Mounds View City Code to regulate the sale, possession
and use of tobacco, tobacco products, tobacco-related devices through the issuance of a
tobacco license, as follows:
CHAPTER 512
CIGARETTE AND TOBACCO PRODUCTS
SECTION:
512.01: Purpose and intent
512.02: Definitions
512.03: License
512.04: Fees
512.05: Basis for denial of license
512.06: Prohibited sales
512.07: Self-service sales
512.08: Responsibility
512.09: Compliance checks and inspections
512.10: Other illegal acts
512.11: Violations and penalty
512.12: Suspension or revocation
512.13: Exceptions and defenses
512.14: Severability
512.01: PURPOSE AND INTENT: Because the City recognizes that many persons under the
age of 18 years purchase or otherwise obtain, possess and use tobacco, tobacco products, tobacco-
related devices, and nicotine or lobelia delivery devices, and the sales, possession, and use are
violations of both state and federal laws; and because studies, which the City hereby accepts and
adopts, have shown that most smokers begin smoking before they have reached the age of 18 years
and that those persons who reach the age of 18 years without having started smoking are significantly
Ordinance 865
Page 2
less likely to begin smoking; and because smoking has been shown to be the cause of several serious
health problems which subsequently place a financial burden on all levels of government; this
ordinance shall be intended to regulate the sale, possession and use of tobacco, tobacco products,
tobacco-related devices, and nicotine or lobelia delivery devices for the purpose of enforcing and
furthering existing laws, to protect minors against the serious effects associated with the illegal use
of tobacco, tobacco products, tobacco-related devices, and nicotine or lobelia delivery devices, and to
further the official public policy of the state in regard to preventing young people from starting to
smoke as stated in M.S. § 144.391, as it may be amended from time to time. In making these
findings, the City Council accepts the conclusions and recommendations of Center for Disease
Control in their study “Selected Cigarette Smoking Initiation and Quitting Behaviors Among High
School Students, United States, 1997,” and of the following medical professionals in these medical
journals: Khuder SA, et al., “Age at Smoking Onset and its Effect on Smoking Cessation,” Addictive
Behavior 24(5):673-7, September-October 1999; D’Avanzo B, et al., “Age at Starting Smoking and
Number of Cigarettes Smoked,” Annals of Epidemiology 4(6):455-59, November 1994; Chen, J &
Millar, WJ, “Age of Smoking Initiation: Implications for Quitting,” Health Reports 9(4):39-46,
Spring 1998; Everett SA, et al., “Initiation of Cigarette Smoking and Subsequent Smoking Behavior
Among U.S. High School Students,” Preventive Medicine, 29(5):327-33, November 1999, copies of
which are adopted by reference.
512.02: DEFINITIONS: Except as may otherwise be provided or clearly implied by context,
all terms shall be given their commonly accepted definitions. For the purpose of this chapter, the
following definitions shall apply unless the context clearly indicates or requires a different meaning.
Subd. 1. COMPLIANCE CHECKS. The system the City uses to investigate and ensure that
those authorized to sell tobacco, tobacco products, tobacco-related devices, and nicotine or
lobelia delivery devices are following and complying with the requirements of this ordinance.
Compliance checks shall involve the use of minors as authorized by this ordinance.
Compliance checks shall also mean the use of minors who attempt to purchase tobacco,
tobacco products, tobacco-related devices, or nicotine or lobelia delivery devices for
educational, research and training purposes as authorized by state and federal laws.
Compliance checks may also be conducted by other units of government for the purpose of
enforcing appropriate federal, state or local laws and regulations relating to tobacco, tobacco
products, tobacco-related devices, and nicotine or lobelia delivery devices.
Subd. 2. INDIVIDUALLY PACKAGED. The practice of selling any tobacco or tobacco
product wrapped individually for sale. Individually wrapped tobacco and tobacco products
shall include but not be limited to single cigarette packs, single bags or cans of loose tobacco
in any form, and single cans or other packaging of snuff or chewing tobacco. Cartons or other
packaging containing more than a single pack or other container as described in this
definition shall not be considered individually packaged.
Subd. 3. INDOOR AREA. All space between a floor and a ceiling that is bounded by walls,
doorways, or windows, whether open or closed, covering more than 50 percent of the
combined surface area of the vertical planes constituting the perimeter of the area. A wall
includes any retractable divider, garage door, or other physical barrier, whether temporary or
permanent.
Ord 865
Page 3
Subd. 4. LOOSIES. The common term used to refer to a single or individually packaged
cigarette or any other tobacco product that has been removed from its packaging and sold
individually. The term “Loosies” does not include individual cigars with a retail price, before
any sales taxes, of more than $2.00 per cigar.
Subd. 5. MINOR. Any natural person who has not yet reached the age of 18 years.
Subd. 6. MOVEABLE PLACE OF BUSINESS. Any form of business operated out of a truck,
van, automobile or other type of vehicle or transportable shelter and not a fixed address store
front or other permanent type of structure authorized for sales transactions.
Subd. 7. NICOTINE OR LOBELIA DELIVERY DEVICES. Any product containing or
delivering nicotine or lobelia intended for human consumption, or any part of such a product,
that is not tobacco as defined in this section, not including any product that has been
approved or otherwise certified for legal sale by the United States Food and Drug
Administration for tobacco use cessation, harm reduction, or for other medical purposes, and
is being marketed and sold solely for that approved purpose.
Subd. 8. RETAIL ESTABLISHMENT. Any place of business where tobacco, tobacco
products, tobacco-related devices, or nicotine or lobelia delivery devices are available for
sale to the general public. The phrase shall include but not be limited to grocery stores,
convenience stores, restaurants, and drug stores.
Subd. 9. SALE. Any transfer of goods for money, trade, barter or other consideration.
Subd. 10. SELF-SERVICE MERCHANDISING. Open displays of tobacco, tobacco products,
tobacco-related devices, or nicotine or lobelia delivery devices in any manner where any
person shall have access to the tobacco, tobacco products, tobacco-related devices, or
nicotine or lobelia delivery devices, without the assistance or intervention of the licensee or
the licensee's employee. The assistance or intervention shall entail the actual physical
exchange of the tobacco, tobacco product, tobacco-related device, or nicotine or lobelia
delivery device between the customer and the licensee or employee. Self-service sales are
interpreted as being any sale where there is not an actual physical exchange of the product
between the clerk and the customer.
Subd. 11. SMOKING. Inhaling or exhaling smoke from any lighted or heated cigar, cigarette,
pipe, or any other lighted or heated tobacco or plant product. Smoking also includes carrying
a lighted or heated cigar, cigarette, pipe, or any other lighted or heated tobacco or plant
product intended for inhalation.
Ord 865
Page 4
Subd. 12. TOBACCO or TOBACCO PRODUCTS. Tobacco and tobacco products includes
cigarettes and any product containing, made, or derived from tobacco that is intended for
human consumption, whether chewed, smoked, absorbed, dissolved, inhaled, snorted,
sniffed, or ingested by any other means, or any component, part, or accessory of a tobacco
product; cigars; cheroots; stogies; perique; granulated, plug cut, crimp cut, ready rubbed, and
other smoking tobacco; snuff; snuff flour; cavendish; plug and twist tobacco; fine cut and
other chewing tobaccos; shorts; refuse scraps, clippings, cuttings and sweepings of tobacco;
and other kinds and forms of tobacco. Tobacco excludes any tobacco product that has been
approved by the United States Food and Drug Administration for sale as a tobacco cessation
product, as a tobacco dependence product, or for other medical purposes, and is being
marketed and sold solely for such an approved purpose.
Subd. 13. TOBACCO-RELATED DEVICES. Tobacco-related devices includes any tobacco
product as well as a pipe, rolling papers, ashtray, or other device intentionally designed or
intended to be used in a manner which enables the chewing, sniffing or smoking of tobacco
or tobacco products.
Subd. 14. VENDING MACHINE. Any mechanical, electric or electronic, or other type of
device which dispenses tobacco, tobacco products or tobacco-related devices upon the
insertion of money, tokens or other form of payment directly into the machine by the person
seeking to purchase the tobacco, tobacco product or tobacco-related device.
512.03: LICENSE:
Subd. 1. License required. No person shall sell or offer to sell any tobacco, tobacco products,
tobacco-related device, or nicotine or lobelia delivery device without first having obtained a
license to do so from the City.
Subd. 2. Application. An application for a license to sell tobacco, tobacco products, tobacco-
related devices, or nicotine or lobelia delivery devices shall be made on a form provided by
the City. The application shall contain the full name of the applicant, the applicant's
residential and business addresses and telephone numbers, the name of the business for
which the license is sought, and any additional information the City deems necessary. Upon
receipt of a completed application, the City Administrator shall forward the application to the
City Council for action at its next regularly scheduled City Council meeting. If the City
Administrator shall determine that an application is incomplete, he or she shall return the
application to the applicant with notice of the information necessary to make the application
complete.
Subd. 3. Action. The City Council may either approve or deny the license, or it may delay action
for a reasonable period of time as necessary to complete any investigation of the application
or the applicant it deems necessary. If the City Council shall approve the license, the City
Administrator shall issue the license to the applicant. If the City Council denies the license,
notice of the denial shall be given to the applicant along with notice of the applicant's right to
appeal the City Council's decision.
Ord 865
Page 5
Subd. 4. Term. The license is effective from July 1st to June 30th of each year.
Subd. 5. Revocation or suspension. Any license issued under this section may be revoked or
suspended as provided in Section 512.12.
Subd. 6. Transfers. All licenses issued under this Chapter shall be valid only on the premises for
which the license was issued and only for the person to whom the license was issued. No
transfer of any license to another location or person shall be valid without the prior approval
of the City Council.
Subd. 7. Moveable place of business. No license shall be issued to a moveable place of
business. Only fixed location businesses shall be eligible to be licensed under this section.
Subd. 8. Display. All licenses shall be posted and displayed in plain view of the general public
on the licensed premise.
Subd. 9. Renewals. The renewal of a license issued under this section shall be handled in the
same manner as the original application.
Subd. 10. Issuance as privilege and not a right. The issuance of a license issued under this section
shall be considered a privilege and not an absolute right of the applicant and shall not entitle
the holder to an automatic renewal of the license.
Subd 11. Proximity to youth-oriented facilities. No license shall be granted pursuant to this
Chapter to any person for any retail sales of tobacco, tobacco products, tobacco-related
devices, or nicotine or lobelia delivery devices within 1,000 feet of any school, playground,
house of worship, or youth-oriented facility, as measured by the shortest line between the
space to be occupied by the proposed licensee and the occupied space of the school,
playground, house of worship, or youth-oriented facility, unless that person has been in the
business of selling such products in that location before the date this Chapter was enacted
into law for at least one year. For the purpose of this section, a youth-oriented facility is
defined to include any facility with residents, customers, visitors, or inhabitants of which 25
percent or more are regularly under the age of 21 or which primarily sells, rents, or offers
services or products that are consumed or used primarily by persons under the age of 21.
Subd 12. Proximity to other tobacco retailers. No license shall be granted pursuant to this
Chapter to any person for any retail sales of tobacco, tobacco products, tobacco-related
devices, or nicotine or lobelia delivery devices within 2,000 feet of any other establishment
holding such a license, as measured by the shortest line between the space to be occupied by
the proposed licensee and the occupied space of the nearest existing licensee, unless that
person has been in the business of selling such products in that location before the date this
section was enacted into law for at least one year.
Ord 865
Page 6
Subd. 13. Smoking. Smoking shall not be permitted and no person shall smoke within the indoor
area of any establishment with a retail tobacco license. Smoking for the purposes of
sampling tobacco and tobacco related products is prohibited. Notwithstanding the preceding,
smoking may occur in a retail establishment if all of the following circumstances are met:
a. The smoking is by a customer or potential customer for the specific purpose of
sampling cigars;
b. The establishment has an entrance door opening directly to the outside;
c. The establishment is not a tobacco department or section of any individual business
establishment with any type of liquor, food, or restaurant license;
d. The establishment derives more than 90 percent of its gross revenue from the sale of
loose tobacco, plants, or herbs and cigars, cigarettes, pipes, and other smoking devices for
burning tobacco and related smoking accessories and the sale of other products is merely
incidental;
e. The establishment has been in the business of selling such products in that location
for at least one year prior to the enactment of this provision; and
f. The owner of the establishment has maintained a valid license and has abided by all
applicable laws.
Any smoking allowed under this exemption shall be prohibited if the license holder loses the
license or transfers title to, relinquishes management or control of, or sells the business to
any other individual or business entity.
512.04: FEES: No license shall be issued under this Chapter until the appropriate license fee
shall be paid in full. The fee for a license under this Chapter shall be established in the City's Fee
Schedule, as it may be amended from time to time.
512.05: BASIS FOR DENIAL OF LICENSE:
Subd. 1. Grounds for denying the issuance or renewal of a license under this chapter include but
are not limited to the following:
a. The applicant is under the age of 18 years.
b. The applicant has been convicted within the past five years of any violation of a
federal, state, or local law, ordinance provision, or other regulation relating to tobacco,
tobacco products, tobacco-related devices, or nicotine or lobelia delivery devices.
c. The applicant has had a license to sell tobacco, tobacco products, tobacco-related
devices, or nicotine or lobelia delivery devices revoked within the preceding 12 months of
the date of application.
Ord 865
Page 7
d. The applicant fails to provide any information required on the application, or provides
false or misleading information.
e. The applicant is prohibited by federal, state, or other local law, ordinance, or other
regulation from holding a license.
Subd. 2. However, except as may otherwise be provided by law, the existence of any particular
ground for denial does not mean that the City must deny the license.
Subd. 3. If a license is mistakenly issued or renewed to a person, it shall be revoked upon the
discovery that the person was ineligible for the license under this chapter.
512.06: PROHIBITED SALES: It shall be a violation of this Chapter for any person to sell or
offer to sell any tobacco, tobacco product, tobacco-related device, or nicotine or lobelia delivery
device:
Subd. 1. To any person under the age of 18 years.
Subd. 2. By means of any type of vending machine.
Subd. 3. By means of self-service methods whereby the customer does not need to a make a
verbal or written request to an employee of the licensed premise in order to receive the
tobacco, tobacco product, tobacco-related device, or nicotine or lobelia delivery device and
whereby the there is not a physical exchange of the tobacco, tobacco product, tobacco-related
device, or nicotine or lobelia delivery device between the licensee, or the licensee's
employee, and the customer.
Subd. 4. By means of Loosies as defined in Section 512.02.
Subd. 5. Containing opium, morphine, jimson weed, bella donna, strychnos, cocaine, marijuana,
or other deleterious, hallucinogenic, toxic or controlled substances except nicotine and other
substances found naturally in tobacco or added as part of an otherwise lawful manufacturing
process. It is not the intention of this provision to ban the sale of lawfully manufactured
cigarettes or other tobacco products.
Subd. 6. By any other means, to any other person, on in any other manner or form prohibited by
federal, state or other local law, ordinance provision, or other regulation.
512.07: SELF-SERVICE SALES: It shall be unlawful for a licensee under this chapter to
allow the sale of tobacco, tobacco products, tobacco-related devices, or nicotine or lobelia delivery
devices by any means where by the customer may have access to those items without having to
request the item from the licensee or the licensee's employee and whereby there is not a physical
exchange of the tobacco, tobacco product, tobacco-related device, or nicotine or lobelia delivery
device between the licensee or his or her clerk and the customer. All tobacco, tobacco products,
tobacco-related devices, and nicotine or lobelia delivery devices shall either be stored behind a
counter or other area not freely accessible to customers, or in a case or other storage unit not left
open and accessible to the general public. Any retailer selling tobacco, tobacco products, tobacco-
related devices, or nicotine or lobelia delivery devices at the time this Chapter is adopted shall
comply with this section within 90 days following the effective date of this Chapter.
Ord 865
Page 8
512.08: RESPONSIBILITY: All licensees under this Chapter shall be responsible for the
actions of their employees in regard to the sale of tobacco, tobacco products, tobacco-related devices,
or nicotine or lobelia delivery devices on the licensed premises, and the sale of an item by an
employee shall be considered a sale by the license holder. Nothing in this section shall be construed
as prohibiting the City from also subjecting the clerk to whatever penalties are appropriate under this
Chapter, state or federal law, or other applicable law or regulation.
512.09: COMPLIANCE CHECKS AND INSPECTIONS: All licensed premises shall be
open to inspection by the police department or other authorized City official during regular business
hours. From time to time, but at least once per year, the City shall conduct compliance checks by
engaging, with the written consent of their parents or guardians, minors over the age of 15 years but
less than 18 years to enter the licensed premise to attempt to purchase tobacco, tobacco products,
tobacco-related devices, or nicotine or lobelia delivery devices. Minors used for the purpose of
compliance checks shall be supervised by city designated law enforcement officers or other
designated city personnel. Minors used for compliance checks shall not be guilty of unlawful
possession of tobacco, tobacco products, tobacco-related devices, or nicotine or lobelia delivery
devices when those items are obtained as a part of the compliance check. No minor used in
compliance checks shall attempt to use a false identification misrepresenting the minor's age, and all
minors lawfully engaged in a compliance check shall answer all questions about the minor's age
asked by the licensee or his or her employee and shall produce any identification, if any exists, for
which he or she is asked. Nothing in this Chapter shall prohibit compliance checks authorized by
state or federal laws for educational, research, or training purposes, or required for the enforcement
of a particular state or federal law.
512.10: OTHER ILLEGAL ACTS: Unless otherwise provided, the following acts shall be a
violation of this Chapter:
Subd. 1. Illegal sales. It shall be a violation of this Chapter for any person to sell or otherwise
provide any tobacco, tobacco product, tobacco-related device, or nicotine or lobelia delivery
device to any minor.
Subd. 2. Illegal possession. It shall be a violation of this Chapter for any minor to have in his or
her possession any tobacco, tobacco product, tobacco-related device, or nicotine or lobelia
delivery device. This subdivision shall not apply to minors lawfully involved in a compliance
check.
Subd. 3. Illegal use. It shall be a violation of this Chapter for any minor to smoke, chew, sniff or
otherwise use any tobacco, tobacco product, tobacco-related device, or nicotine or lobelia
delivery device.
Ord 865
Page 9
Subd. 4. Illegal procurement. It shall be a violation of this Chapter for any minor to purchase or
attempt to purchase or otherwise obtain any tobacco, tobacco product, tobacco-related
device, or nicotine or lobelia delivery device, and it shall be a violation of this Chapter for
any person to purchase or otherwise obtain those items on behalf of a minor. It shall further
be a violation for any person to coerce or attempt to coerce a minor to illegally purchase or
otherwise obtain or use any tobacco, tobacco product, tobacco-related device, or nicotine or
lobelia delivery device. This subdivision shall not apply to minors lawfully involved in a
compliance check.
Subd. 5. Use of false identification. It shall be a violation of this chapter for any minor to
attempt to disguise his or her true age by the use of a false form of identification, whether the
identification is that of another person or one on which the age of the person has been
modified or tampered with to represent an age older than the actual age of the person.
512.11: VIOLATIONS AND PENALTY:
Subd. 1. Licensees: If a person licensed under this Chapter or an employee of a person licensed
under this Chapter violates any provisions of this Chapter, the licensee shall be charged an
administrative penalty of one hundred fifty dollars ($150.00). If a person licensed under this
Chapter or an employee of a person licensed under this Chapter violates any provisions of this
Chapter twice at the same location within twenty four (24) months of the initial violation, the
licensee shall be charged an administrative penalty of four hundred dollars ($400.00). If a
person licensed under this Chapter or an employee of a person licensed under this Chapter
violates any provision of this Chapter three (3) times at the same location within twenty four
(24) months of the initial violation, the licensee shall be charged an administrative penalty of
five hundred dollars ($500.00). No penalty under this Section 512.11 Subd 1. shall take effect
until the licensee has received notice, served personally or by mail, of the alleged violation,
and has had an opportunity for a hearing before the City Council. The notice shall provide
information on how and where a hearing may be requested, including a contact address and
phone number. The right to a hearing shall be terminated should licensee fail to request a
hearing within ten (10) business days of notice delivery. A decision by the City Council that
a violation of this Chapter has occurred shall be in writing. Judicial appeal shall be as
provided for by state law.
Subd. 2. Individuals: Any person who sells tobacco to a person under the age of eighteen (18)
years shall be charged an administrative penalty of one hundred dollars ($100.00) for a first
offense and fifty dollars ($50.00) additional for every subsequent offense. This penalty shall
be in addition to the penalty charged under Section 512.11, Subd. 1. No penalty under this
Section 512.11 Subd. 2 shall take effect until the person against whom the penalty will be
charged has received notice, served personally or by mail, of the alleged violation, and has had
an opportunity for a hearing before the City Council. The notice shall provide information on
how and where a hearing may be requested, including a contact address and phone number.
The right to a hearing shall be terminated should the person fail to request a hearing within ten
(10) business days of notice delivery. A decision by the City Council that a violation of this
Section has occurred shall be in writing. Judicial appeal shall be as provided for by state law.
Ord 865
Page 10
Subd. 3. Continued violation. Each violation, and every day in which a violation occurs or
continues, shall constitute a separate offense.
Subd. 4. Minors. Any person under the age of eighteen (18) years who purchases, possesses, or
consumes tobacco shall be treated as follows: for a first offense the violator will be referred to
Northwest Youth and Family Services, and be required to complete NYFS's Tobacco Education
Program, and pay the related fees or expenses. A second violation will result in an administrative
penalty of fifty dollars ($50.00), and will also result in a referral to Northwest Youth and Family
Services for monitored community service. Third or subsequent violations will be referred to the
Ramsey County Attorney's Office, Juvenile Court Division, for prosecution. Failure to comply
with the requirements set forth above for a first or second offense will result in an immediate
referral to the Ramsey County Attorney's Office for prosecution through the Juvenile Court
Division.
Subd. 5. Other individuals. Other individuals, other than minors as regulated by Subd. 4 of this
Section, found to be in violation of this Chapter, shall be charged an administrative fine of
$50.
Subd. 6. Defenses. It shall be an affirmative defense to a charge of selling tobacco to a person
under the age of eighteen (18) years in violation of this Section that the licensee or individual
making the sale relied in good faith upon proof of age as described in Minnesota Statutes,
Section 340A.503, subdivision 6.
512.12: SUSPENSION OR REVOCATION:
Subd. 1. In addition to any other penalty imposed under Section 512.13, any license issued under
this Section may be suspended or revoked by the City Council for a violation of any provision
of this Chapter if the licensee has been given a reasonable notice and an opportunity to be
heard. A second violation within twelve (12) months shall result in a suspension of not less than
three (3) consecutive days. A third violation within a twenty four (24) month's time frame shall
result in a suspension of ten (10) consecutive days. A fourth violation within a twenty four (24)
month time frame shall result in revocation of license for ninety (90) consecutive days, and will
require a mandatory hearing before the Mounds View City Council.
Subd. 2. Hearing and Notices. Suspension or revocation of a license shall be preceded by a hearing
before the City Council. A hearing notice shall be delivered at least ten (10) days prior to the
hearing including notice of the time and place of the hearing and shall state the nature of the
charges against the licensee. Judicial appeal shall be as provided for by state law.
512.13: EXCEPTIONS: Nothing in this Chapter shall prevent the providing of tobacco,
tobacco products, tobacco-related devices, or nicotine or lobelia delivery devices to a minor as part
of a lawfully recognized religious, spiritual, or cultural ceremony.
512.14: SEVERABILITY: If any section or provision of this ordinance is held invalid, such
invalidity shall not affect other sections or provisions which can be given force and effect without the
invalidated section or provision.
Ord 865
Page 11
SECTION 3. In accordance with Section 3.07 of the City Charter, City staff shall have the
following summary printed in the official City newspaper in lieu of the complete ordinance:
On October 24, 2011, the City Council adopted Ordinance 865 that deletes the
existing Chapter 512 of the City Code pertaining to the licensing of retail tobacco
establishments and in its place adopts new tobacco licensing provisions consistent
with the model language developed and supported by the Ramsey Tobacco
Coalition, the League of Minnesota Cities and the Public Health law Center.
A printed copy of the ordinance is available for inspection during regular business
hours at Mounds View City Hall and is available on line at the City’s web site located
at www.ci.mounds-view.mn.us.
SECTION 4. This ordinance shall take effect and be in force 30 days from and after its
passage and publication, in accordance with Section 3.09 of the City Charter.
Introduction and First Reading by the Mounds View City Council on October 10, 2011.
Second Reading and Adoption by the Mounds View City Council on October 24, 2011.
Publication Date: November 3, 2011
Joe Flaherty, Mayor
Attest:
______________________________
James Ericson
City Administrator
(seal)
Item No: 2
Meeting Date: October 3, 2011
Type of Business: Work Session
Administrator Review : ____
City of Mounds View Staff Report
To: Honorable Mayor and City Council
From: Thomas Kinney, Chief of Police
Item Title/Subject: Police Canine Discussion
Introduction:
There has been continued discussion over a proposed police canine program within the
Mounds View Police Department. During a past presentation, the total expenses to begin
this type of program were outlined. A brief summary of the costs to initiate this program
total approximately $12,000. This amount has been reduced from a projected $18,000 total
cost as it reflects an additional $6,000 in grant funding that the St Paul Police K9
Foundation has generously offered to our agency.
Discussion:
One suggested method for raising this $12,000 is for residents in support of this cause to
form a private non-profit group/foundation to raise funds and accept donations. A
community member, Robin Marion, has recently voiced his willingness to lead such a
cause. It is understandable that private fundraising may take considerable time to organize
and take action and the success of such a movement has yet to be determined.
The grant offer through the St Paul Police K9 Foundation has extended their deadline to
December 1, 2011. If the city is unable to commit in moving forward with the program, the
funds would be offered to another agency. The start time for the next St. Paul Police
canine handler school is March 2012, which runs 12 weeks, with an additional 3 weeks in
narcotic detection training.
In addition to the required $12,000 in start-up costs, an estimated $5,500-$9,500 can be
expected on an annual basis due to overtime costs, handler compensation, food and
veterinary care.
Recommendation:
Staff seeks direction from the Council on whether to provide the St. Paul Police K9
Foundation our commitment to proceed with the grant acceptance and subsequent
enrollment in the canine handler training program.
Respectfully Submitted,
__________________
Thomas Kinney
Chief of Police
CITY OF MOUNDS VIEW, MINNESOTA
Enterprise Funds 2012 Budgets
Combining Statement of Revenues and Expenses
Sanitary Street Storm
Water Sewer Lighting Water 2012 2011
Operating revenue:
Operating revenues 791,552 1,257,470 75,500 250,718 2,375,240 2,325,376
Special assessments 50,000 - - - 50,000 50,000
Connection charges - 300 - - 300 300
Tower rental - - - - - -
Other income - 4,000 - - 4,000 4,000
Total operating revenue 841,552 1,261,770 75,500 250,718 2,429,540 2,379,676
Operating expenses:
Personal services 314,894 294,971 3,661 87,090 700,616 672,928
Supplies 75,541 24,070 - 21,175 120,786 108,615
Contractual services 165,639 95,289 3,900 47,155 311,983 443,929
Electricity & gas 87,000 2,100 73,000 - 162,100 163,100
Disposal charges - 760,913 - - 760,913 776,066
Contingency 15,000 15,000 - - 30,000 30,000
Depreciation 240,000 160,000 - 32,000 432,000 417,000
Capital outlays 877,200 133,500 - 117,000 1,127,700 1,618,700
Total operating expenses 1,775,274 1,485,843 80,561 304,420 3,646,098 4,230,338
Net operating income (loss)(933,722) (224,073) (5,061) (53,702) (1,216,558) (1,850,662)
Non-operating revenue (expenses):
Investment income 31,250 45,000 2,000 22,000 100,250 115,250
Principal payment on debt (215,000) - - - (215,000) (210,000)
Interest expense (11,705) - - - (11,705) (18,825)
Bond fees / discounts (1,975) - - - (1,975) (2,625)
Total non-operating (197,430) 45,000 2,000 22,000 (128,430) (116,200)
Transfers
Transfers in 289,000 - - - 289,000 659,000
Transfers out (223,410) (247,807) (2,320) (62,756) (536,293) (526,055)
Revenues over (under) expenditures (1,065,562) (426,880) (5,381) (94,458) (1,592,281) (1,833,917)
Add back:
Capital outlays 877,200 133,500 - 117,000 1,127,700 1,618,700
Principal on debt 215,000 - - - 215,000 210,000
Net income (loss)26,638 (293,380) (5,381) 22,542 (249,581) (5,217)
Net assets (deficit), January 1 4,542,758 5,622,469 151,365 2,914,977 13,231,568 12,746,992
Net assets (deficit), December 31 4,569,396$ 5,329,089$ 145,984$ 2,937,519$ 12,981,987$ 12,741,775$
Total
1
2008 2009 2010 2011 Y-T-D 2012 Change from 2011
Actual Actual Actual Budget 09/30/11 Request Dollar Percent
Water (Fund 700):
Revenues
3424 Meter charge 1,859 2,451 - - - - - 0.00%
3426 Reimbursed staff time - 357 - - - - - 0.00%
3551 Spec assessments-current 34,719 38,321 59,806 50,000 34,853 50,000 - 0.00%
3552 Spec assessments-delinquent 7,300 31,639 17,264 - 8,015 - - 0.00%
3553 Spec assess.-penalty & interest 464 1,559 1,059 - 1,423 - - 0.00%
3610 Investment income 72,980 33,770 20,946 31,250 31,250 - 0.00%
3631 Water tower space rental 60,390 62,832 62,539 - - - 0.00%
3680 Other revenues 2,939 788 7,214 2,000 3,100 2,000 - 0.00%
3710 Water sales 683,665 683,987 676,858 737,052 434,758 737,052 - 0.00%
3714 Water service fee 47,587 50,547 52,092 51,500 40,239 51,500 - 0.00%
3715 Utility connections 805 480 420 1,000 980 1,000 - 0.00%
3716 Penalties 8,561 8,594 7,119 - 9,796 - - 0.00%
3913 Meter sales 1,020 763 4,090 - 3,534 - - 0.00%
WAC/SWM charges 1,200 2,900 500 - - - 0.00%
3940 Capital Contributions - 42,475 - - 0.00%
3972 Transfers - Vehicle & Equip - - - 289,000 289,000 - 0.00%
Total revenue 923,489 961,463 909,907 1,161,802 536,698 1,161,802 - 0.00%
Operating expenses
Billing Services (4820):
Personnel services
0100 Salaries, regular 30,751 33,262 33,133 33,058 23,533 36,690 3,632 10.99%
0110 Salaries, overtime 67 7 - - - - 0.00%
0300 Social security 2,325 2,360 2,369 2,529 1,710 2,806 277 10.95%
0321 PERA 1,895 2,196 2,282 2,396 1,692 2,660 264 11.02%
0400 Group insurance 2,389 2,803 2,983 4,387 2,327 5,260 873 19.90%
0500 Workers compensation 138 168 196 222 196 244 22 9.91%
0990 Severance - - - - 0.00%
Total personnel services 37,565 40,796 40,963 42,592 29,458 47,660 5,068 11.90%
Materials & supplies
1600 Supplies, operating - 4 - 50 68 (50) -100.00%
Total materials & supplies - 4 - 50 68 - (50) -100.00%
Contractual services
3030 Other professional services 8,015 6,334 6,476 7,815 6,985 8,280 465 5.95%
3300 Postage 2,974 2,710 2,996 3,256 2,189 3,256 - 0.00%
3430 Printing 1,093 680 980 900 748 900 - 0.00%
3630 Training - - 79 250 250 - 0.00%
5130 Repairs, equipment 2,737 3,128 3,063 3,332 3,345 3,498 166 4.98%
Total contractual services 14,819 12,852 13,594 15,553 13,267 16,184 631 4.06%
Debt Service:
8010 Principal 190,000 200,000 205,000 210,000 210,000 215,000 5,000 2.38%
8020 Interest 35,325 29,350 22,837 18,825 18,825 11,705 (7,120) -37.82%
8030 Paying agent fees 431 431 431 475 431 475 - 0.00%
8040 Continuing disclosure 1,675 1,138 1,164 2,150 983 1,500 (650) -30.23%
Total capital outlays 227,431 230,919 229,432 231,450 230,239 228,680 (2,770) -1.20%
Miscellaneous:
9900 Transfers out to General Fund 58,115 59,859 61,655 63,505 65,410 1,905 3.00%
9900 Transfers out to Vehicle Fund 20,000 20,000 20,000 58,000 58,000 - 0.00%
Total capital outlays 78,115 79,859 81,655 121,505 - 123,410 1,905 1.57%
Total Billing 357,930 364,430 365,644 411,150 273,032 415,934 4,784 1.16%
2012 Budget Summary
2
Fund: 700 Department: 4820 Billing Services
Account Description 2009 2010 2011 2012 Description
1600 Supplies, operating 50 50 50 50 Utility billing supplies
50 50 50 50
3030 Other professional services 6,300 6,435 6,615 6,705 22.5% of audit fee
800 800 800 800 Inserting & mailing bills
400 400 400 400 Legal services
- - - 375 Annual maintenance (meter reading software)(50% sewer, 50% Water)
7,500 7,635 7,815 8,280
3300 Postage 2,688 2,816 2,816 2,816 3200 bills X $0.44 postage X 4 billings X 1/2 cost
357 374 440 440 Late notices: 500 bills X $0.44 postage X 4 billings X 1/2 cost
3,045 3,190 3,256 3,256
3430 Printing 450 450 450 450 Utility bills (1/2 cost)
450 450 450 450 Envelopes
900 900 900 900
3630 Training 250 250 250 250 Seminars on new regulations, software updates, etc. INCODE training
250 250 250 250 Defer INCODE Training to future year $1,000
5130 Repairs, equipment 2,717 2,885 3,029 3,180 INCODE software support (30%)
- 289 303 318 Handheld interface support for new meter readers (50% water 50% sewer)
2,717 3,174 3,332 3,498
8010 Principal 200,000 205,000 210,000 215,000 Principal due on bonds
200,000 205,000 210,000 215,000
8020 Interest 31,850 25,570 18,825 11,705 Interest due on 2002 A Bonds
31,850 25,570 18,825 11,705
8030 Paying agent fees 475 475 475 475 Paying agent fees on bond issues
475 475 475 475
8040 Continuing Disclosure 2,150 2,150 2,150 1,500 Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees
2,150 2,150 2,150 1,500
9900 Transfers out 59,859 61,655 63,505 65,410 Transfer to General Fund for administrative overhead costs
20,000 20,000 57,000 58,000 Transfer to Vehicle & Equipment Fund to fund future purchases
79,859 81,655 120,505 123,410
328,796 330,049 367,558 368,324
5
2008 2009 2010 2011 Y-T-D 2012 Change from 2011
Actual Actual Actual Budget 09/30/11 Request Dollar Percent
Water (Fund 700):
2012 Budget Summary
Infrastructure & Equip Maintenance (4823):
Personnel services
0100 Salaries, regular 159,180 153,144 165,318 168,844 119,533 173,363 4,519 2.68%
0110 Salaries, overtime 15,168 15,195 7,360 9,002 5,234 9,182 180 2.00%
0150 Salaries, part-time 11,667 16,474 13,449 18,475 10,679 18,475 - 0.00%
0300 Social security 13,735 12,845 13,028 15,019 9,404 15,377 358 2.38%
0321 PERA 9,974 11,637 11,990 13,176 9,037 13,518 342 2.60%
0400 Group insurance 21,482 25,145 28,231 28,828 21,568 31,130 2,302 7.99%
0500 Workers compensation 4,174 5,048 5,760 6,141 5,445 6,189 48 0.78%
Total personnel services 235,380 239,488 245,136 259,485 180,900 267,234 7,749 2.99%
Materials & supplies
1210 Supplies, bldg & grnds 1,668 3,174 1,210 5,300 892 5,300 - 0.00%
1220 Supplies, vehicles 191 593 442 800 721 800 - 0.00%
1230 Supplies, equipment 264 1,579 1,181 818 808 818 - 0.00%
1240 Supplies, streets 2,349 1,247 1,652 5,000 1,289 5,000 - 0.00%
1250 Supplies, utilities 9,786 5,902 10,163 11,750 6,712 14,250 2,500 21.28%
1260 Supplies, traffic control - 38 - 200 200 - 0.00%
1600 Supplies, operating 3,169 6,751 3,307 4,300 1,628 4,300 - 0.00%
1700 Motor fuels 8,383 2,832 5,635 4,800 3,943 5,850 1,050 21.88%
2400 Uniforms 1,021 1,239 1,043 1,380 674 1,475 95 6.88%
2410 Mats & towels 1,140 1,427 1,266 800 1,125 1,620 820 102.50%
Total materials & supplies 27,971 24,782 25,899 35,148 17,792 39,613 4,465 12.70%
Contractual services
3030 Other professional services 470 8,272 4,824 12,350 2,351 5,830 (6,520) -52.79%
3100 Communications - telephone 4,515 1,909 2,211 1,780 1,333 2,060 280 15.73%
3200 Water & wastewater charges 7,002 8,030 7,846 5,000 3,008 6,000 1,000 20.00%
3220 Natural gas 11,964 10,792 6,292 12,000 5,569 10,000 (2,000) -16.67%
3610 Memberships 280 261 265 353 159 440 87 24.65%
3630 Training 896 943 844 2,650 1,360 3,940 1,290 48.68%
4010 Equipment rental 331 2,458 1,927 4,500 5,123 4,500 - 0.00%
4800 Insurance 8,378 8,700 8,290 10,230 8,393 10,230 - 0.00%
5130 Repairs, equipment 5,738 6,309 13,430 2,500 1,283 1,250 (1,250) -50.00%
5140 Repairs, streets 3,700 12,500 18,219 10,000 6,335 10,000 - 0.00%
5150 Repairs, utilities 2,138 6,337 7,468 1,800 6,092 1,800 - 0.00%
5155 Water service repair 55,824 41,271 32,654 50,000 45,548 50,000 - 0.00%
5160 Repairs, system maintenance 980 2,650 5,107 15,000 4,975 15,000 - 0.00%
Total contractual services 102,216 110,432 109,377 128,163 91,529 121,050 (7,113) -5.55%
Capital outlays
7030 Equipment - - - 28,500 14,012 52,200 23,700 83.16%
7050 Construction - - - 1,212,700 21,065 825,000 (387,700) -31.97%
7950 Depreciation 209,839 230,375 229,199 225,000 - 240,000 15,000 6.67%
Total capital outlays 209,839 230,375 229,199 1,466,200 35,077 1,117,200 (349,000) -23.80%
Miscellaneous:
9100 Contingency - - - 15,000 15,000 - 0.00%
9900 Transfer to Street Fund 30,000 90,000 100,000 100,000 100,000 100,000 100.00%
Total miscellaneous 30,000 90,000 100,000 115,000 - 115,000 100,000 86.96%
Total infrastructure & equip maint 605,406 695,077 709,611 2,003,996 325,298 1,660,097 (243,899) -12.17%
3
Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance
Account Description 2009 2010 2011 2012 Description
1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms
900 600 600 600 Light tubes & ballasts
200 200 200 200 Paper products
200 200 200 200 Paint, thinner, & brushes
250 500 2,500 2,500 Black dirt & sod/seed, landscaping materials
500 500 500 500 Misc. cleaners for well houses & % of shop
400 400 400 400 Fertilizer/seed/weed control
700 500 500 500 Irrigation parts
600 300 300 300 Goose repellent
3,850 3,300 5,300 5,300
1220 Supplies, vehicles 200 200 200 200 Air, oil, fuel, & transmission filters
100 100 100 100 Fluids
100 100 100 100 Batteries
50 50 50 50 Paint sealant
150 150 150 150 Tune ups
200 200 200 200 Misc repairs
800 800 800 800
1230 Supplies, equipment 100 100 100 100 Tune ups
300 100 100 100 Grounds maintenance equipment
150 100 100 100 Blades, suction hoses, filter screens
168 168 168 168 Hydraulic fluid: 35 gallons @ $4.80 / gallon
220 200 200 200 Solvents & cleaning fluids
200 150 150 150 Air, oil, fuel, & trans filters
1,138 818 818 818
1240 Supplies, streets 3,000 3,000 5,000 5,000 Asphalt/concrete/sod/seed for patching minor street,curb, driveway repairs.
3,000 3,000 5,000 5,000
1250 Supplies, utilities 150 150 150 150 Air compresser & dehumidifier parts
500 500 2,500 5,000 Meter batteries (200 @ $25)
500 500 500 500 Paint & sandblasting materials for hydrants
500 500 500 500 Copper, steel & PVC pipe
600 1,200 - - Location flags & paint (moved to account 1600)
650 650 2,100 2,100 Chemical equipment parts (flouride pumps)
1,500 1,500 1,500 1,500 Valve box risers, main repair clamps
2,000 1,000 1,000 1,000 Hydrant markers
2,500 1,500 1,500 1,500 Hydrant repair parts & used hydrants
- - 2,000 2,000 Meter supplies, etc. (move from account 1600)
850 - - - Metal locator replacement
9,750 7,500 11,750 14,250
1260 Supplies, traffic control 200 200 200 200 Traffic cones / safety vests
200 200 200 200
1600 Supplies, operating 500 500 500 500 Propane, acetylene & oxygen supplies
400 400 400 400 Gloves, masks, & rags
650 650 650 650 Film, first aid supplies, & batteries
- - 1,500 1,500 Location flags & paint (moved from account 1250)
250 250 250 250 Cleaning supplies
1,000 1,000 1,000 1,000 Additional & replacement hand tools
500 500 - - Meter supplies, etc. (move to account 1250)
3,300 3,300 4,300 4,300
1700 Motor fuels & lubs 213 188 375 450 Diesel fuel - 100 gallons @ $4.50
300 300 200 200 Propane: 50 gallons @ $4
4,875 4,225 4,225 5,200 Unleaded fuel: 1,300 gallons @ $4.00
5,388 4,713 4,800 5,850
2400 Uniforms 1,380 1,380 1,380 1,475 Uniforms 19% of $6,000 and clothing 1.9 FTE x $175 per contract
1,380 1,380 1,380 1,475
2410 Mats & towels 800 800 800 1,620 Share of floor mats & shop towels (19% of $8,500)
800 800 800 1,620
3030 Other professional services 1,400 1,400 1,400 180 Backflow prevention testing (3 @ $60 per test)
- - 3,000 - Water system leak survey (every 2 years, 2013)
5,000 - - - Water tower evaluation
- - 200 200 Fire sprinkler inspections/testing
- - - 200 Fire extinguisher inspection/servcie (10 @ $20)
2,000 2,750 2,750 2,750 Gopher State One-call locates
3,000 10,000 5,000 2,500 Arcview/GIS base map consulting
11,400 14,150 12,350 5,830
3100 Communications - telephone 400 400 400 400 Service & repair
1,200 1,200 1,200 1,570 Cellular phone service (18.5%
80 80 80 - On call pager (half water / half sewer)
- - 100 90 800 Mhz license fee (33%)(5 radios @ $4.48 per month)
1,680 1,680 1,780 2,060
3200 Water and wastewater charges 5,000 5,000 5,000 6,000
5,000 5,000 5,000 6,000
6
THIS PAGE LEFT BLANK INTENTIONALLY
Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance
Account Description 2009 2010 2011 2012 Description
3220 Natural gas 12,000 12,000 12,000 10,000 Heating fuel
12,000 12,000 12,000 10,000
3610 Memberships 200 113 113 150 American Public Works Association (APWA)(25% of $600)
195 195 100 100 MN Rural Water Association (50%)
65 65 80 80 MN Safety Council (19% of $405)
- - - 50 Suburban Utility Superintendant Association (SUSA)(50% of $100)
60 60 60 60 Pressurized vessel license
520 433 353 440
3630 Training 600 600 - - Collection operator's seminar
250 250 250 250 Computer training/webinars
200 200 200 - Confined space safety seminar
- - - 1,200 Trench safety training (on-site)(not annual)
120 120 120 110 Hearing test/R2K (2.15 FTE * $50)
50 50 50 - License renewal
60 60 60 60 Maintenance Expo
160 160 800 820 Water operator class/exam/certificate ($205 per person)
200 200 200 200 Misc. training seminars
- - - 390 Equipment operator training
400 400 200 200 MRWA workshops
200 125 150 150 MN Public Works Assoc workshop
560 560 560 560 Tuition reimbursement
60 60 60 - Work zone safety seminar (every 3 years)
2,860 2,785 2,650 3,940
4010 Rental, equipment 2,500 2,500 3,500 3,500 Skid steer - upgrade
600 600 600 600 Barricades & signs
400 400 400 400 Tools & equipment
300 300 - - Fax machine
3,800 3,800 4,500 4,500
4800 Insurance 10,230 10,230 10,230 10,230 Share of property/liability insurance
10,230 10,230 10,230 10,230
5130 Repairs, equipment 1,000 1,000 1,000 100 Chemical pump repairs
250 250 - - Copier maintenance
350 350 350 - Fire extinguisher recharge / repair (moved to 3030)
1,000 1,000 1,000 1,000 Miscellaneous repairs
200 200 - - Sprinkler inspections - Well #3 (moved to account 3030)
150 150 150 150 Radio repairs
2,950 2,950 2,500 1,250
5140 Repairs, streets 10,000 10,000 10,000 10,000 Contractor repairs to streets after water main breaks
10,000 10,000 10,000 10,000
5150 Repairs, utilities 800 800 800 800 RTU panel repairs
1,000 1,000 1,000 1,000 Electrical modifications & repairs
900 900 - - Floride tanks for each well house (every 3 years)
2,500 2,500 - - Leak survey (moved to account 3030)
5,200 5,200 1,800 1,800
5155 Water service repairs 45,000 50,000 50,000 50,000 Contractor repairs to residential water services.
45,000 50,000 50,000 50,000
5160 System maintenance 13,000 13,000 13,000 12,500 Building repairs
2,000 2,000 2,000 2,500 Water system maintenance & repair items
15,000 15,000 15,000 15,000
7030 Capital, equipment 8,000 8,000 8,000 8,000 Gate valves
- 5,000 5,000 - GPS Locating Equipment (Sewer 5,000)(carryover from 2010)
- 125,000 - - Booster station
- - 10,500 10,500 Plate compactor for backhoe
- - - 8,500 Trench box
- - 5,000 SCADA System upgrade Phase #2 well #6
20,000 - - - Generator (trailer mounted)(20,000 to water and 10,000 to sanitary sewer)
- - - 19,000 Chemical feed equipment (WTP #2 & 3)
- - - 3,200 Dehumidifier (well #6)
- - - 1,200 Laptop and mounting bracket for infield use of record drawings
- - - 1,800 Hydrant diffuser
28,000 138,000 28,500 52,200
7050 Construction 90,000 - - - Water system upgrades in conjunction with major roadway program
10,000 - 800,000 700,000 Water tower rehabilitation 2011 - $800,000
- 100,000 75,000 Well #2 motor replacement (carryover from 2010)
- 22,700 22,700 Well #1,2,3 building repairs (int. and exterior repairs)(carryover from 10)
- 211,000 250,000 Reservoir & booster station building and roof repairs (carryover from 10)
- - 65,000 50,000 Roof replacement well #1
- 60,000 - 75,000 Well pump rehabilitation project (wells no. 3&5)
100,000 393,700 1,212,700 825,000
7950 Depreciation 220,000 215,000 225,000 240,000 Estimated depreciation
220,000 215,000 225,000 240,000
9100 Contingency 15,000 15,000 15,000 15,000 Contingency
15,000 15,000 15,000 15,000
9900 Transfers out - 100,000 100,000 100,000 Water system upgrades in conjunction with major roadway program
- 100,000 100,000 100,000
518,246 1,020,739 1,744,511 1,392,863
7
2008 2009 2010 2011 Y-T-D 2012 Change from 2011
Actual Actual Actual Budget 09/30/11 Request Dollar Percent
Water (Fund 700):
2012 Budget Summary
Water Production (4825):
Materials & supplies
1600 Supplies, operating 25,600 31,007 31,982 32,778 19,022 32,778 - 0.00%
1700 Motor fuels 616 310 552 2,700 3,150 450 16.67%
Total materials & supplies 26,216 31,317 32,534 35,478 19,022 35,928 450 1.27%
Contractual services
3030 Other professional services 12,307 23,991 11,517 37,230 13,505 38,205 975 2.62%
3210 Electricity 79,853 74,990 76,248 77,000 52,857 77,000 - 0.00%
3630 Training - - - 200 200 - 0.00%
Total contractual services 92,160 98,981 87,765 114,430 66,362 115,405 975 0.85%
Total water production 118,376 130,298 120,299 149,908 85,384 151,333 1,425 0.95%
Total expenditures 1,081,712 1,189,805 1,195,554 2,565,054 683,714 2,227,364 (237,690) -9.27%
Revenues over (under) expenditures (158,223) (228,342) (285,647) (1,403,252) (147,016) (1,065,562) 237,690 -16.94%
Add back:
capital outlays - - - 1,241,200 35,077 877,200 (364,000) -29.33%
principal payment on debt 190,000 200,000 205,000 210,000 210,000 215,000 5,000 2.38%
Change in net assets 31,777 (28,342) (80,647) 47,948 98,061 26,638 (21,310) -44.44%
Net Assets, beginning year 4,572,022 4,603,799 4,575,457 4,494,810 4,494,810 4,542,758 47,948 1.07%
Net Assets, end of year 4,603,799$ 4,575,457$ 4,494,810$ 4,542,758$ 4,592,870$ 4,569,396$ 26,638$ 0.59%
4
Fund: 700 Department: 4825 Water Production
Account Description 2009 2010 2011 2012 Description
1600 Supplies, operating 550 550 550 550 Computer supplies
800 800 800 800 Testing reagents
3,600 3,950 3,950 3,950 Sulfur dioxide: 25 150# cylinders @ $1.05 per pound
9,000 8,000 8,000 8,000 Chlorine: 8 - 1 ton cylinders @ .50 per pound
8,500 8,438 8,438 8,438 75 - 150 # cylinders @ $.75
6,200 6,600 6,600 6,600 Hydrofluosilic acid: 20,000 pounds @ $0.33
- 3,190 3,190 3,190 R-999 Buffer solution 2 - 55 gal drums @ 29 per gal.
- - 850 850 Sand seperater
400 400 400 400 Water conservation program implementation
29,050 31,928 32,778 32,778
1700 Motor fuels & lubs 330 330 - - Motor oil for well # 2 - 55 gallons $6 gal.
150 150 200 200 Turbine & electric motor oil
192 192 250 250 Oil for generators
1,000 1,000 - - Propane for well #2: 500 gallons @ $2.00
2,550 2,250 2,250 2,700 Diesel fuel for primary generator: 600 gallons @ $4.50
4,222 3,922 2,700 3,150
3030 Other professional services 1,000 960 960 960 Bacteria tests (8*$10*12 months)
800 800 800 800 Computer maintenance
9,000 9,000 9,000 9,000 Consumer confidence report
6,470 6,800 7,500 7,500 DNR water permit fee (annual surcharge)
300 300 300 300 Emergency Response Commission fees
1,120 1,120 1,120 1,120 Full scan tests - 4 @ $280
600 600 600 600 Minimum contamination level (MCL) tests
2,000 - - - One-call locating (moved to 700-4823-3030)
1,000 1,000 1,000 1,000 Radon tests
800 800 800 800 Random sample tests
50,000 - - - Filter sand replenishment
25,000 - - - solenoid and valve repairs
- - - 825 MCES discharge permits (3*$275)
- 150 150 300 MNDPS - EPCRA program ($100/WTP)
25,000 10,000 15,000 15,000 Well head protection plan (req. by Dept. of Health)(30kl/3yr 09-11)
123,090 31,530 37,230 38,205
3210 Electricity 72,606 75,510 77,000 77,000 Electricity for wells, tower & reservoir
72,606 75,510 77,000 77,000
3630 Training 200 200 200 200 General training
200 200 200 200
229,168 143,090 149,908 151,333
8
2012 Budget Summary
2008 2009 2010 2011 Y-T-D 2012 Change from 2011
Actual Actual Actual Budget 09/30/11 Request Dollar Percent
Sanitary Sewer (Fund 730):
Revenues
3426 Reimbursed staff time - - - - 85 - - 0.00%
3551 Spec. Assessments - 2,125 5,749 - 7,715 - - 0.00%
3610 Investment income 149,549 77,662 47,990 60,000 45,000 (15,000) -25.00%
3680 Other revenues 364 - - - 170 - - 0.00%
3716 Penalties 12,494 11,019 9,637 - 14,695 - - 0.00%
3720 Utility sales 1,101,413 1,138,858 1,153,260 1,209,106 893,162 1,257,470 48,364 4.00%
3721 SAC charges 7,405 (15,480) (2,157) 4,000 13,380 4,000 - 0.00%
3725 Utility connections 300 180 420 300 625 300 - 0.00%
3728 Contractual wastewater service 12,891 74 - - - - 0.00%
3911 Gain on sale of assets 1,125 - - - - - 0.00%
3940 Capital Contributions - 42,475 - - - - 0.00%
3972 Transfers from Vehicle Fund - - - 330,000 - (330,000) -100.00%
Total revenue 1,285,541 1,256,913 1,214,899 1,603,406 929,832 1,306,770 (296,636) -18.50%
Operating expenses
Billing Services (4820):
Personnel services
0100 Salaries, regular 30,751 33,262 33,133 33,058 23,533 36,690 3,632 10.99%
0110 Salaries, overtime 159 68 - - - - 0.00%
0150 Salaries, part-time - - - - - - 0.00%
0300 Social security 2,331 2,364 2,369 2,529 1,709 2,806 277 10.95%
0321 PERA 1,901 2,200 2,282 2,396 1,692 2,660 264 11.02%
0400 Group insurance 2,400 2,812 2,983 4,387 2,328 5,260 873 19.90%
0500 Workers compensation 138 168 196 222 196 244 22 9.91%
Total personnel services 37,680 40,874 40,963 42,592 29,458 47,660 5,068 11.90%
Materials & supplies
1600 Supplies, operating - - - 50 57 50 - 0.00%
Total materials & supplies - - - 50 57 50 - 0.00%
Contractual services
3030 Other professional services 6,195 6,334 6,476 7,440 6,985 7,905 465 6.25%
3300 Postage 2,974 2,710 2,996 3,256 2,189 3,256 - 0.00%
3430 Printing 1,093 680 980 900 748 900 - 0.00%
3630 Training - - 310 250 250 - 0.00%
5130 Repairs, equipment 2,589 3,128 3,071 3,332 3,345 3,498 166 4.98%
Total contractual services 12,851 12,852 13,833 15,178 13,267 15,809 631 4.16%
Miscellaneous:
9900 Transfers out to General Fund 46,030 47,411 48,833 50,298 - 51,807 1,509 3.00%
9900 Transfers out to Vehicle Fund 36,000 36,000 36,000 36,000 - 36,000 - 0.00%
Total miscellaneous 82,030 83,411 84,833 86,298 - 87,807 1,509 1.75%
Total Billing 132,561 137,137 139,629 144,118 42,782 151,326 7,208 5.00%
Infrastructure & Equip Maintenance (4823):
Personnel services
100 Salaries, regular 139,887 148,658 159,201 162,168 109,120 166,553 4,385 2.70%
110 Salaries, overtime 1,345 5,215 5,814 7,221 6,620 7,365 144 1.99%
150 Salaries, part-time 1,060 7,511 10,071 11,100 8,776 11,100 - 0.00%
300 Social security 10,774 11,580 12,808 13,807 8,910 14,153 346 2.51%
321 PERA 8,192 10,655 11,404 12,563 8,237 12,892 329 2.62%
400 Group insurance 16,323 19,268 22,718 27,406 18,501 29,642 2,236 8.16%
500 Workers compensation 3,813 4,552 5,238 5,554 4,937 5,606 52 0.94%
Total personnel services 181,394 207,439 227,254 239,819 165,101 247,311 7,492 3.12%
Materials & supplies
1210 Supplies, bldg & grnds 155 90 49 200 - 200 - 0.00%
1220 Supplies, vehicles 2,180 1,756 781 1,275 1,728 1,575 300 23.53%
1230 Supplies, equipment 290 3,243 2,484 3,250 404 3,250 - 0.00%
9
2012 Budget Summary
2008 2009 2010 2011 Y-T-D 2012 Change from 2011
Actual Actual Actual Budget 09/30/11 Request Dollar Percent
Sanitary Sewer (Fund 730):
1240 Supplies, streets 36 - - 850 3,094 850 - 0.00%
1250 Supplies, utilities 1,344 1,065 1,452 1,950 11 1,950 - 0.00%
1260 Supplies, traffic control - - - 300 300 - 0.00%
1600 Supplies, operating 2,991 1,806 2,367 4,300 1,730 4,300 - 0.00%
1700 Motor fuels 4,109 4,859 6,577 7,150 5,877 8,500 1,350 18.88%
2400 Uniforms 887 1,175 1,010 1,438 728 1,475 37 2.57%
2410 Mats & towels 1,134 1,427 1,295 800 1,125 1,620 820 102.50%
Total materials & supplies 13,126 15,421 16,015 21,513 14,697 24,020 2,507 11.65%
Contractual services
3030 Other professional services 136 1,452 1,194 7,750 4,422 5,350 (2,400) -30.97%
3030 Medtronic utility extension 1,965 - - - - - - 0.00%
3100 Communications - telephone 2,894 1,214 1,407 1,430 865 1,660 230 16.08%
3200 Water & sewer 2,456 2,911 2,593 1,200 1,963 2,600 1,400 116.67%
3210 Electricity 1,866 2,072 2,019 2,100 1,674 2,100 - 0.00%
3230 Wastewater disposal - Met Council 696,031 733,120 776,845 776,066 646,722 760,913 (15,153) -1.95%
3610 Memberships - 63 64 230 230 - 0.00%
3630 Training 1,530 513 756 3,105 965 4,590 1,485 47.83%
4010 Equipment rental - - - 1,000 - 1,000 - 0.00%
4800 Insurance 10,381 6,163 5,605 7,300 5,544 7,300 - 0.00%
5130 Repairs, equipment 9,987 20,222 3,660 8,850 2,800 8,750 (100) -1.13%
5150 Repairs, utilities - - - 1,000 40,886 1,000 - 0.00%
5155 Utility service repairs - - - 4,500 6,900 4,500 - 0.00%
5160 Repairs, maintenance 52,416 14,674 6,585 140,000 6,366 42,500 (97,500) -69.64%
Total contractual services 779,662 782,404 800,728 954,531 719,107 842,493 (112,038) -11.74%
Capital outlays
7030 Equipment - - - 337,500 311,685 8,500 (329,000) -97.48%
7050 Construction - - - - - 125,000 125,000 #DIV/0!
7950 Depreciation 153,931 157,989 156,758 160,000 - 160,000 - 0.00%
Total capital outlays 153,931 157,989 156,758 497,500 311,685 293,500 (204,000) -41.01%
Miscellaneous:
9100 Contingency - - - 15,000 - 15,000 - 0.00%
9900 Transfer to Street fund 60,000 150,000 160,000 160,000 - 160,000 - 0.00%
Total miscellaneous 60,000 150,000 160,000 175,000 - 175,000 - 0.00%
Total infrastructure & equip maint 1,188,113 1,313,253 1,360,755 1,888,363 1,210,590 1,582,324 (306,039) -16.21%
Total expenditures 1,320,674 1,450,390 1,500,384 2,032,481 1,253,372 1,733,650 (298,831) -14.70%
Revenues over (under) expenditures (35,133) (193,477) (285,485) (429,075) (323,540) (426,880) 2,195 -0.51%
Add back:
capital outlays - - - 337,500 311,685 133,500 (204,000) -60.44%
Change in net assets (35,133) (193,477) (285,485) (91,575) (11,855) (293,380) (201,805) 220.37%
Net Assets, beginning of year 5,749,177 5,714,044 5,520,567 5,714,044 5,714,044 5,622,469 (91,575) -1.60%
Net Asset, end of year 5,714,044$ 5,520,567$ 5,235,082$ 5,622,469$ 5,702,189$ 5,329,089$ (495,185)$ -8.81%
10
Fund: 730 Department: 4820 Billing Services
Account Description 2009 2010 2011 2012 Description
1600 Supplies, operating 50 50 50 50 Utility billing supplies
50 50 50 50
3030 Other professional services 800 800 825 825 Inserting & mailing bills
- - - - Financial/Payroll/Utility billing software search/selection costs
- - - 375 Annual maintenance (meter reading software)(50% sewer, 50% Water)
6,300 6,435 6,615 6,705 22.5% of audit fee
7,100 7,235 7,440 7,905
3300 Postage 357 374 440 440 Late notices: 500 bills X $0.44 postage X 4 billings X 1/2 cost
2,688 2,816 2,816 2,816 3200 bills X $0.44 postage X 4 billings X 1/2 cost
3,045 3,190 3,256 3,256
3430 Printing 450 450 450 450 Envelopes
450 450 450 450 Utility bills (1/2 cost)
900 900 900 900
3630 Training 250 250 250 250 Seminars on new regulations, software updates, etc. INCODE training (new)
250 250 250 250 Defer INCODE training to a future year $1,000
5130 Repairs, equipment 2,717 2,885 3,029 3,180 Incode software support (30%)
- 289 303 318 Handheld interface support for new meter readers (50% water 50% sewer)
2,717 3,174 3,332 3,498
9900 Transfers out 47,411 48,833 50,298 51,807 Transfer to General Fund for admin costs
36,000 36,000 36,000 36,000 Transfer to Vehicle & Equipment Fund for vehicle use
83,411 84,833 86,298 87,807
97,473 99,632 101,526 103,666
11
Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance
Account Description 2009 2010 2011 2012 Description
1210 Supplies, bldgs & grounds 200 200 100 100 Paint, bulbs, fuses, etc
500 500 100 100 Seed, dirt, sod, etc
700 700 200 200
1220 Supplies, vehicles 75 75 75 75 Air, oil, fuel & transmission filters
775 775 775 775 Fluids
125 125 125 125 Repair & replacement parts
300 300 300 600 Tires & batteries
1,275 1,275 1,275 1,575
1230 Supplies, equipment 650 650 650 650 Tune up parts
500 500 500 500 Hydraulic fluids & hoses
550 550 200 200 Cutting edges (skid loader)
300 300 300 300 Misc. replacement & repair parts
300 300 300 300 Light equip misc replacement & repair parts
200 200 1,000 1,000 Camera track and parts
300 300 300 300 Minor repairs
2,800 2,800 3,250 3,250
1240 Supplies, streets 50 50 50 50 Tack coat
300 300 300 300 Dewatering rock
500 500 500 500 Asphalt mix
500 500 - - Gate @ Co. Rd. H2 & West City Limits (move to 2009)
1,350 1,350 850 850
1250 Supplies, utilities 100 100 100 100 Replacement pumps & motors
100 100 100 100 Filters, packings, relays, etc
300 300 300 300 Speed crete (mortar)
700 700 700 700 Repair parts
375 750 750 750 Manhole covers, adjust rings & bolts
1,575 1,950 1,950 1,950
1260 Supplies, traffic control 300 300 300 300 Traffic cones, work zone sign face, safety vests
300 300 300 300
1600 Supplies, operating 650 650 500 500 Additional & replacement hand tools
100 100 250 250 Glove & paper products
150 150 150 150 Disinfectant supplies
500 500 500 500 Camera supplies
150 150 200 200 First aid supplies, protective equip
400 400 400 400 CD's, DVD's, software
500 500 500 500 Engineering supplies
700 700 700 700 Shop supplies, fastners, soap, degreasers, steet, batteries
500 500 500 500 Pipe, fittings, and accessories (connectors)
600 - 600 600 Filter replacement for sewer gas monitors
4,250 3,650 4,300 4,300
1700 Motor fuels & lubs 300 300 300 300 Fluids
600 600 600 600 Motor oil - 100 gallons $6 gal.
3,750 3,250 3,250 4,000 Unleaded fuel 1,000 gallons @ $4
3,400 3,000 3,000 3,600 Diesel fuel 800 gallons @ $4.50
8,050 7,150 7,150 8,500
2400 Uniforms 1,438 1,438 1,438 1,475 Uniforms 19% of $6,000 and clothing 1.9 FTE x $175 per contract
1,438 1,438 1,438 1,475
2410 Mats & towels 800 800 800 1,620 Share of floor mats & shop towels (19% of $8,500)
800 800 800 1,620
3030 Other professional services 1,844 2,750 2,750 2,750 Gopher State One Call locates
750 - - - Consulting engineering services
- - - 100 Fire extinguisher inspection/servcie (5 @ $20)
- 10,000 5,000 2,500 Arcview/GIS base map consulting
2,594 12,750 7,750 5,350
3100 Communications - telephone 50 50 50 Service & repair
80 80 80 On call pager (half water / half sewer)
1,200 1,200 1,200 1,570 Cellular phone service (18.5% of $8,500)
- - 100 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month)
1,330 1,330 1,430 1,660
3200 Water & Sewer service 1,200 1,200 1,200 2,600 Estimated annual charge
1,200 1,200 1,200 2,600
3210 Electricity 1,815 1,888 2,100 2,100 Electricity for lift stations
1,815 1,888 2,100 2,100
29,477 38,581 33,993 35,730
12
THIS PAGE LEFT BLANK INTENTIONALLY
Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued)
Account Description 2009 2010 2011 2012 Description
3230 Metro Waste Commission 733,120 776,845 776,066 760,913 Estimated annual charge
733,120 776,845 776,066 760,913
3610 Memberships 200 113 - - American Public Works Association (APWA)(25% of $600)
- - 100 100 MN Rural Water Assoc. (50%)
- - 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100)
65 65 80 80 MN Safety Council (20%)
265 178 230 230
3630 Training 600 600 600 1,400 Collection operators training/renewal ($350 per person)
560 560 560 560 Tuition reimbursement (PW Mgt. Class - North Hennepin CC)
250 250 250 250 Computer training/webinars
120 120 120 110 Hearing test/R2K (2.15 FTE * $50)
50 50 50 - License renewal
200 200 200 - Confined space seminar
150 150 150 1,200 Trench safety training (on-site)(not annual)
450 450 450 - Wastewater collection operators recertification seminar
235 235 235 - Low voltage license
320 320 320 320 Metro school
110 110 110 - Pesticide applicators license
- - - 300 Miscellaneous wastewater training
- - - 60 Maintenance Expo
- - - 390 Equipment operator training
- 125 - - APWA MN conference
60 60 60 - Work zone safety seminar (every 3 years)
3,105 3,230 3,105 4,590
4010 Rental, equipment 1,000 1,000 1,000 1,000 Barricades & signs
1,000 1,000 1,000 1,000
4800 Insurance 7,246 7,246 7,300 7,300 Share of property/liability insurance
7,246 7,246 7,300 7,300
5130 Repairs, equipment 100 100 100 - Fire extinguisher recharge / repair
500 500 - - Groveland Lift Station repair
200 200 2,500 2,500 Repairs to motors & pumps
3,800 10,000 2,500 2,500 Repairs to Vactor (jet truck)
- - 2,500 2,500 Repairs to camera van and camera equipment
- - 1,000 1,000 Repairs to utility truck
250 250 250 250 Misc repairs
250 250 - - Copy machine/fax machine repairs
5,100 11,300 8,850 8,750
5150 Repairs, utilities 500 500 - - Repairs to RTUs
- - 1,000 1,000 Lift station repairs
500 500 1,000 1,000
5155 Utility service repairs 4,500 4,500 4,500 4,500 Service line repairs
4,500 4,500 4,500 4,500
5160 System maintenance 50,000 50,000 15,000 15,000 Sewer main & manhole rehabilitation
15,000 15,000 25,000 25,000 Root control
- 27,500 - 2,500 Groveland lift station maintenance/cleaning
75,000 100,000 100,000 - Sewer pipe relining program
140,000 192,500 140,000 42,500
7030 Capital, equipment 330,000 330,000 300,000 - Vactor (includes auto chassis lube)
- 5,000 5,000 - GPS Locating Equipment (carryover from 2010)
10,000 - 30,000 - Generator - trailer mounted
- - - 8,500 Wincam software upgrade/desktop license/training
- - 2,500 - Vehicle Cameras (3)
340,000 335,000 337,500 8,500
7050 Construction 150,000 - - - Sewer system upgrades in conjunction with major roadway program
- - - 125,000 Sewer pipe relining program
- - - - Groveland lift station pump replacement
150,000 - - 125,000
7950 Depreciation 165,000 165,000 160,000 165,000 Estimated depreciation
165,000 165,000 160,000 165,000
9100 Contingency 15,000 15,000 15,000 15,000 Contingency - may include lift station impeller replacement at Bronson
15,000 15,000 15,000 15,000
9900 Transfer out - 160,000 160,000 160,000 Sewer system upgrades in conjunction with major roadway program
- 160,000 160,000 160,000
1,564,836 1,672,299 1,614,551 1,304,283
13
2008 2009 2010 2011 Y-T-D 2012 Change from 2011
Actual Actual Actual Budget 09/30/11 Request Dollar Percent
Street Lighting (Fund 240):
Revenues
3610 Investment income 6,222 3,318 2,091 2,000 2,000 - 0.00%
3716 Penalties 902 688 713 - 807 500 500 #DIV/0!
3740 Street lighting charges 76,963 76,520 75,548 74,000 57,547 75,000 1,000 1.35%
Total revenue 84,087 80,526 78,352 76,000 58,354 77,500 1,500 1.97%
Operating expenses
Operations (4416)
Personnel services
0100 Salaries, regular 2,670 2,753 2,630 2,638 1,877 2,691 53 2.01%
0110 Salaries, overtime - 18 - - 2 - - 0.00%
0300 Social security 192 185 184 202 126 206 4 1.98%
0321 PERA 166 183 185 191 136 195 4 2.09%
0400 Group insurance 433 499 520 505 389 550 45 8.91%
0500 Workers compensation 13 15 18 19 17 19 - 0.00%
0990 Severence pay - - - - - 0.00%
Total personnel services 3,474 3,653 3,537 3,555 2,547 3,661 106 2.98%
Materials & supplies 0
1600 Supplies, operating - - 11 - - - - 0.00%
0
Contractual services
3030 Other professional services - 0.00%
3210 Electricity 66,125 71,816 72,603 72,000 53,584 73,000 1,000 1.39%
4800 Insurance 737 765 690 900 684 900 - 0.00%
5150 Repairs, utilities - 3,464 3,193 - 3,000 3,000 #DIV/0!
Total contractual services 66,862 76,045 76,486 72,900 54,268 76,900 4,000 5.49%
Other
9900 Transfer to General Fund 2,060 2,122 2,186 2,252 - 2,320 68 3.02%
Total other 2,060 2,122 2,186 2,252 - 2,320 68 3.02%
0.00%
Total expenditures 72,396 81,820 82,220 78,707 56,815 82,881 4,174 5.30%
Revenues over (under) expenditures 11,691 (1,294) (3,868) (2,707) 1,539 (5,381) (2,674) 98.78%
0.00%
Add back: Capital outlays - - - - - - - 0.00%
Change in net assets 11,691 (1,294) (3,868) (2,707) 1,539 (5,381) (2,674) 98.78%
Net assets, beginning year 147,543 159,234 157,940 154,072 154,072 151,365 (2,707) -1.76%
0.00%
Net assets, end of year 159,234$ 157,940$ 154,072$ 151,365$ 155,611$ 145,984$ (5,381)$ -3.55%
2012 Budget Summary
14
Fund: 240 Street Lighting Fund Revenues
Account Description 2009 2010 2011 2012 Description
3610 Interest revenue 2,000 2,000 2,000 2,000 Estimated interest earnings at 2.00%.
2,000 2,000 2,000 2,000
3740 Street lighting charges 72,000 74,000 74,000 74,000 Estimated utility charges for street lighting.
72,000 74,000 74,000 74,000
Fund: 240 Department: 4416 Operations
3210 Electricity 65,000 68,770 72,000 72,000 Estimate
65,000 68,770 72,000 72,000
4800 Insurance 900 900 900 900 Share of property/liability insurance
900 900 900 900
5150 Repairs, utilities - - - 2,000 Repairs to street lighting.
- - - 2,000
9900 Transfer out 2,122 2,186 2,252 2,320 Transfer to General Fund for administrative overhead costs
2,122 2,186 2,252 2,320
15
2008 2009 2010 2011 Y-T-D 2012 Change from 2011
Actual Actual Actual Request 09/30/11 Request Dollar Percent
Storm Water (Fund 245):
Revenues
3610 Investment income 57,985 33,177 22,653 22,000 - 22,000 - 0.00%
3680 Other revenues - - - - 2,500 - - 0.00%
3716 Penalties & interest 2,254 1,958 2,308 - 2,641 - - 0.00%
3730 Surface water charges 222,137 241,384 264,658 250,718 200,897 250,718 - 0.00%
3972 Transfer from other funds - - - 40,000 - - (40,000) -100.00%
Total revenue 282,376 276,519 289,619 312,718 206,038 272,718 (40,000) -12.79%
Operating expenses
System Maintenance (4415):
Personnel services
0100 Salaries, regular 54,235 49,958 52,822 47,562 33,858 48,514 952 2.00%
0110 Salaries, overtime 123 1,293 329 1,083 705 1,105 22 2.03%
0150 Salaries, part-time 4,792 6,263 5,264 4,920 5,295 4,920 - 0.00%
0300 Social security 4,534 4,329 4,089 4,097 3,026 4,172 75 1.83%
0321 PERA 3,265 3,428 3,408 3,527 2,505 3,597 70 1.98%
0400 Group insurance 4,759 5,907 6,372 7,798 4,824 8,573 775 9.94%
0500 Workers compensation 2,852 3,266 3,875 3,893 3,466 3,884 (9) -0.23%
0990 Severence pay - - - - - - 0.00%
Total personnel services 74,560 74,444 76,159 72,880 53,679 74,765 1,885 2.59%
Materials & supplies
1230 Supplies, equipment 1,695 81 1,594 2,000 648 2,000 - 0.00%
1240 Supplies, streets - - - 600 600 - 0.00%
1600 Supplies, operating 1,345 167 1,291 2,200 1,568 3,200 1,000 45.45%
1700 Motor fuels 3,720 2,388 2,686 2,750 2,223 3,350 600 21.82%
2100 Books/Periodicals - - 54 100 100 - 0.00%
2400 Uniforms 420 723 614 1,188 355 740 (448) -37.71%
2410 Mats & towels 1,137 1,427 1,296 800 599 810 10 1.25%
Total materials & supplies 8,317 4,786 7,535 9,638 5,393 10,800 1,162 12.06%
Contractual services
3030 Other professional services 15,032 12,698 4,947 17,500 1,323 6,350 (11,150) -63.71%
3100 Telephone 1,379 1,143 1,057 1,250 1,105 780 (470) -37.60%
3610 Memberships 690 753 1,154 750 920 170 22.67%
3630 Training 324 365 307 3,410 894 2,925 (485) -14.22%
4800 Insurance 1,556 1,616 6,680 1,900 1,919 1,900 - 0.00%
5150 Repairs, utilities 50,474 7,147 - 50,000 3,336 25,000 (25,000) -50.00%
Total contractual services 69,455 23,722 14,145 74,810 8,577 37,875 (36,935) -49.37%
Capital outlays
7030 Equipment - - - - 9,000 9,000 #DIV/0!
7050 Construction - - - - - 108,000 108,000 #DIV/0!
7950 Depreciation 31,878 31,878 32,151 32,000 - 32,000 - 0.00%
Total capital outlays 31,878 31,878 32,151 32,000 - 149,000 117,000 365.63%
Miscellaneous:
9900 Transfer out - 30,000 40,000 40,000 - 46,756 6,756 16.89%
Total miscellaneous - 30,000 40,000 40,000 - 46,756 6,756 16.89%
Total System Maintenance 184,210 164,830 169,990 229,328 67,649 319,196 89,868 39.19%
0.00%
2012 Budget Summary
16
Fund: 245 Storm Water Revenues
Account Description 2009 2010 2011 2012 Description
3610 Interest revenue 34,000 25,000 22,000 22,000 Estimated interest earnings at 2.00%.
34,000 25,000 22,000 22,000
3730 Utility sales 225,669 250,718 250,718 250,718 Estimated surface water charges.
225,669 250,718 250,718 250,718
3972 Transfers - Vehicle & equip Fd 40,000 40,000 40,000 40,000 Transfer for capital equipment purchases
40,000 40,000 40,000 40,000
Fund: 245 Department: 4415 System Maintenance
1230 Supplies, equipment 200 500 500 500 Miscellaneous equipment (laser level)
1,000 1,000 1,500 1,500 Hoses & nozzles
1,200 1,500 2,000 2,000
1240 Supplies, streets 600 600 600 600 Bituminous mix
600 600 600 600
1600 Supplies, operating 300 300 300 300 Concrete
- - 1,000 2,000 Rain Garden mix, riprap, topsoil, seed and sod
1,200 1,200 200 200 Concrete adjustment rings
200 200 200 200 CD's, DVD's, software upgrade for camera van
800 800 500 500 Catch basin castings
2,500 2,500 2,200 3,200
1700 Motor fuels 2,550 2,250 1,125 1,350 300 gallons diesel fuel @ $4.50 / gallon for Vactor
- - 1,625 2,000 500 gallons unleaded @ $4.00 for utility truck
2,550 2,250 2,750 3,350
2100 Books/Periodicals 500 150 100 100 Storm water books/periodicals
500 150 100 100
2400 Uniforms 1,188 1,188 1,188 740 Uniforms/clothing (9.5% of $6,000, .95 FTE x $175 per contract)
1,188 1,188 1,188 740
2410 Mats & towels 800 800 800 810 Share of floor mats & shop towels (9.5% of $8,500)
800 800 800 810
3030 Other professional services 1,600 1,600 - - GIS data input
6,000 5,000 5,000 5,000 Consulting engineers
- 5,000 2,500 1,250 Arcview/GIS base map consulting
- 10,000 - - FEMA Study
- - 10,000 - Silverview pond sediment removal study
- - - 100 Fire extinguisher inspection/servcie (5 @ $20)
7,600 21,600 17,500 6,350
3100 Communications 1,200 1,200 1,200 690 Cell Phone (8% of $8,500)
- - 50 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month)
1,200 1,200 1,250 780
3610 Memberships 85 - - - CPV Program
- 113 - 150 American Public Works Association (APWA)(25% of $600)
690 690 710 725 Minnesota Cities Storm Water Coalition
65 65 40 45 MN Safety Council (11% of $405)
840 868 750 920
3630 Training 200 200 200 200 Seminars & training sessions (Stormwater)
- - 60 55 Hearing test/R2K (1.1 FTE * $50)
- - 800 - Wastewater class/exam
- - 350 350 Safety training
- - 750 750 NPDES compliance training
- - 1,250 1,250 Tuition reimbursement
700 700 - - Public Education Fund
150 150 - - Trench safety seminar
150 150 - - Competent person training
- - - 220 Equipment operator training
500 500 - 100 Computer/webinar training
1,700 1,700 3,410 2,925
4800 Insurance 1,900 1,900 1,900 1,900 Share of property/liability insurance
1,900 1,900 1,900 1,900
5150 Repairs, utilities 70,000 50,000 25,000 25,000 Repair storm sewer and drainage issues throughout the city
10,000 10,000 25,000 - Storm Sewer slip linning improvements
80,000 60,000 50,000 25,000
7030 Equipment - - 4,000 4,000 Small generator for trailer
- - 5,000 5,000 Concrete mixer
- - 9,000 9,000
7050 Construction - - - 25,000 Sewer sliplining program
- - - 35,000 Mustang Drive improvements
40,000 - - - Storm water system upgrades in conjunction with major roadway program
- 48,000 - 48,000 Storm water projects, Subwatershed SC-1, SC-3, EW-4
315,000 - - - Storm water projects, Subwatershed AA-2, AA-6, EW-4
355,000 48,000 - 108,000
7950 Depreciation 35,000 35,000 32,000 34,000 Estimated depreciation
35,000 35,000 32,000 34,000
9900 Transfer out - 40,000 40,000 40,000 Storm water system upgrades in conjunction with major roadway program
- 40,000 40,000 40,000
492,578 219,256 156,448 230,675
18
2008 2009 2010 2011 Y-T-D 2012 Change from 2011
Actual Actual Actual Request 09/30/11 Request Dollar Percent
2012 Budget Summary
Storm Water (Fund 245):
Street Sweeping (4417):
Personnel services
0100 Salaries, regular 8,431 8,056 7,976 7,510 5,586 7,660 150 2.00%
0110 Salaries, overtime - 292 181 1,083 197 1,105 22 2.03%
0150 Salaries, part-time - - - 240 - 240 - 0.00%
0300 Social security 662 610 577 676 401 689 13 1.92%
0321 PERA 531 577 571 623 419 635 12 1.93%
0400 Group insurance 1,061 1,278 1,353 1,231 993 1,354 123 9.99%
0500 Workers compensation 469 545 640 642 570 642 - 0.00%
0990 Severence pay - - - - - - 0.00%
Total personnel services 11,154 11,358 11,298 12,005 8,166 12,325 320 2.67%
Materials & supplies
1230 Supplies, equipment 94 2,150 3,805 200 3,671 2,500 2,300 1150.00%
1600 Supplies, operating 1,493 605 2,118 3,200 1,404 3,500 300 9.38%
1700 Motor fuels - 2,389 1,583 3,150 3,566 4,150 1,000 31.75%
2400 Uniforms - - - 188 48 115 (73) -38.83%
2410 Mats & towels - - - - 87 110 110 #DIV/0!
Total materials & supplies 1,587 5,144 7,506 6,738 8,776 10,375 3,637 53.98%
Contractual services
3530 Disposal - - - 5,000 - 5,000 - 0.00%
3630 Training - 40 109 530 - 280 (250) -47.17%
5130 Repairs, equipment - - 2,036 2,000 1,648 4,000 2,000 100.00%
Total contractual services - 40 2,145 7,530 1,648 9,280 1,750 23.24%
Capital outlays
7030 Equipment - - - 40,000 30,681 - (40,000) -100.00%
Total capital outlays - - - 40,000 30,681 - (40,000) -100.00%
0.00%
Miscellaneous:0.00%
9800 Loss on disposal of asset - - - - - - 0.00%
9900 Transfer out 16,000 16,000 16,000 16,000 - 16,000 - 0.00%
Total miscellaneous 16,000 16,000 16,000 16,000 - 16,000 - 0.00%
Total street sweeping 28,741 32,542 36,949 82,273 49,271 47,980 (34,293) -41.68%
Total expenditures 212,951 197,372 206,939 311,601 116,920 367,176 55,575 17.84%
Revenues over expenditures 69,425 79,147 82,680 1,117 89,118 (94,458) (95,575) -8556.40%
Add back: Capital outlays - - - 40,000 30,681 117,000 77,000 192.50%
Change in net asssets 69,425 79,147 82,680 41,117 119,799 22,542 (18,575) -45.18%
Net assets, beginning year 2,642,608 2,712,033 2,791,180 2,873,860 2,873,860 2,914,977 41,117 1.43%
Net assets, end of year 2,712,033$ 2,791,180$ 2,873,860$ 2,914,977$ 2,993,659$ 2,937,519$ 22,542$ 0.77%
17
Fund: 245 Department: 4417 Street Cleaning
1230 Supplies, equipment 200 200 200 2,500 Misc. repairs - belts, pumps, hoses, filters, etc.
200 200 200 2,500
1600 Supplies, operating 1,000 1,000 2,000 2,300 Gutter brooms
- - 700 700 Belts, pumps, hoses, filters, etc... for sweeper
- - 100 100 Gloves, hearing protection, etc...
100 100 400 400 2 dirt shoes
1,100 1,100 3,200 3,500
1700 Motor fuels 2,550 2,250 3,000 4,000 Diesel fuel - 800 gallons @ $5.00/gallon
150 150 150 150 Oil - 4 changes
2,700 2,400 3,150 4,150
2400 Uniforms 188 188 188 115 Uniforms/clothing (1.5% of $6,000, .15 FTE x $175 per contract)
188 188 188 115
2410 Mats & towels - - - 110 Share of floor mats & shop towels (1.5% of $8,500)
- - - 110
3530 Disposal - 5,000 5,000 5,000 Dumping charges for sweeping disposals 2010
- 5,000 5,000 5,000
3630 Training 150 125 - - American Public Works Assoc. MN conference
150 - - - Minnesota Public Works Assoc. conference
- - 500 250 NPDES compliance training
- - 30 30 Maintenance Expo
200 200 - - MSSA operator training sessions.
200 200 - - Sweeper operator seminar
200 200 - - MCCA Membership
900 725 530 280
5130 Repairs, equipment - - 2,000 4,000 Elgin sweeper repairs
- - 2,000 4,000
7030 Equipment 40,000 40,000 40,000 - 3/4 T 4X4 Truck (carryover from 2008)
40,000 40,000 40,000 -
9900 Transfer out to Vehicle & Equip 16,000 16,000 16,000 16,000 Transfer to Vehicle & Equip Fund for future replacements
16,000 16,000 16,000 16,000
61,088 65,613 68,268 31,655
19
CITY OF MOUNDS VIEW, MINNESOTA
Special Revenue Funds 2012 Budgets
Combining Statement of Revenues and Expenditures
and Net Changes in Fund Balances
Economic
Cable Development Community
Television DARE Forfeiture Authority Center
Revenues:
Taxes 100,000 - - - -
Intergovernmental:
County grants - - - - -
Other local govt.- - - - -
Charges for services:
Culture and recreation - - - - 187,829
Miscellaneous:
Fines - 500 5,500 - -
Investment income - - - - 2,500
Other 5,100 - - - -
Total revenues 105,100 500 5,500 - 190,329
Expenditures:
Public safety
Supplies - 350 500 - -
Contractual services - 150 1,500 - -
Capital outlay - - - - -
Sanitation
Personal services - - - - -
Contractual services - - - - -
Culture and recreation:
Personal services 87,244 - - - 52,450
Supplies 3,000 - - - 12,150
Contractual services 41,747 - - - 312,966
Capital outlay - - - - 44,000
Economic development
Personal services - - - 38,332 -
Supplies - - - 300 -
Contractual services - - - 231,149 -
Capital outlay - - - 50,000 -
Total expenditures 131,991 500 2,000 319,781 421,566
Surplus of revenues over
(under) expenditures (26,891) - 3,500 (319,781) (231,237)
Other financing sources (uses)
Transfers in - - - 319,781 170,000
Transfers out - - - - -
Total other financing sources (uses)- - - 319,781 170,000
Net change in fund balance (26,891) - 3,500 - (61,237)
Fund balance, January 1:270,723 2,520 21,218 - 160,723
Fund balance, December 31 243,832 2,520 24,718 - 99,486
20
Lakeside Recycling TIF TIF TIF TIF
Park Grant District #1 District #2 District #3 District #5 2012 2011
- - 1,493,611 138,330 349,928 1,208,260 3,290,129 3,376,178
- 26,185 - - - - 26,185 26,185
21,216 - - - - - 21,216 21,216
- - - - - - 187,829 189,934
- - - - - - 6,000 6,300
300 - 10,000 2,500 10,000 6,000 31,300 166,800
250 - - - - - 5,350 150
21,766 26,185 1,503,611 140,830 359,928 1,214,260 3,568,009 3,786,763
- - - - - - 850 1,150
- - - - - - 1,650 1,650
- - - - - - - 40,000
- 12,342 - - - - 12,342 11,999
- 13,843 - - - - 13,843 14,186
3,699 - - - - - 143,393 140,865
2,400 - - - - - 17,550 17,250
15,667 - - - - - 370,380 358,305
- - - - - - 44,000 54,000
- - - - - - 38,332 100,460
- - - - - - 300 280
- - 2,000 40,238 1,200 1,150,047 1,424,634 1,930,817
- - 1,504,027 - 425,973 - 1,980,000 2,504,743
21,766 26,185 1,506,027 40,238 427,173 1,150,047 4,047,274 5,175,705
- - (2,416) 100,592 (67,245) 64,213 (479,265) (1,388,942)
- - - - - - 489,781 742,435
- - (86,456) (86,456) (86,456) (60,413) (319,781) (1,632,529)
- - (86,456) (86,456) (86,456) (60,413) 170,000 (890,094)
- - (88,872) 14,136 (153,701) 3,800 (309,265) (2,279,036)
11,165 21,649 400,505 445,115 572,256 923,870 2,829,744 11,771,352
11,165 21,649 311,633 459,251 418,555 927,670 2,520,479 9,492,316
Total
21
Y-T-D
2008 2009 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
Cable TV (Fund 210):
Revenues
3180 Franchise fee 109,828 141,282 114,631 96,000 58,542 100,000 4,000 4.17%
3370 Other local government rev 569 - - - - - 0.00%
3610 Investment income - - - - - - 0.00%
3680 Other revenue 1,546 6,530 5,144 5,100 3,825 5,100 - 0.00%
Total revenue 111,943 147,812 119,775 101,100 62,367 105,100 4,000 3.96%
Operating expenses
Operations (4350)
Personnel services
0100 Salaries, regular 49,259 54,766 58,199 59,383 42,679 61,564 2,181 3.67%
0110 Salaries, over-time 3,056 2,074 - - - - 0.00%
0150 Salaries, part-time 5,211 8,017 4,211 8,432 886 6,261 (2,171) -25.75%
0300 Social security 4,460 4,895 4,680 5,188 3,134 5,188 - 0.00%
0321 PERA 4,030 4,341 4,324 4,308 3,153 4,463 155 3.60%
0400 Group insurance 5,292 7,004 7,905 8,618 6,001 9,475 857 9.94%
0500 Workers compensation 182 239 290 299 260 293 (6) -2.01%
0600 Unemployment - 1,246 744 - - - 0.00%
0990 Severence pay - - - - - - 0.00%
Total personnel services 71,490 82,582 80,352 86,228 56,113 87,244 1,016 1.18%
Materials & supplies
1230 Supplies, equipment 237 2,598 396 2,000 554 2,000 - 0.00%
1600 Supplies, operating 1,081 551 221 1,000 2 1,000 - 0.00%
Total materials & supplies 1,318 3,149 617 3,000 556 3,000 - 0.00%
Contractual services
3030 Other professional services 3,713 4,850 3,622 3,600 1,800 4,140 540 15.00%
3630 Training & conferences 152 325 370 300 300 - 0.00%
3800 Mileage & parking 97 20 23 100 7 75 (25) -25.00%
3900 Grants & subsidies 25,936 26,719 26,933 26,933 27,232 27,232 299 1.11%
5130 Repairs, equipment 906 51 139 1,000 - 10,000 9,000 900.00%
Total contractual services 30,804 31,965 31,087 31,933 29,039 41,747 9,814 30.73%
Capital
7030 Equipment 37,462 9,767 - - - - 0.00%
Total capital outlays 37,462 9,767 - - - - - 0.00%
Total expenditures 141,074 127,463 112,056 121,161 85,708 131,991 10,830 8.94%
Net change in fund balance (29,131) 20,349 7,718 (20,061) (23,341) (26,891) (6,830) 34.05%
Fund balance, beginning year 291,847 262,716 283,065 290,784 290,784 270,723 (20,061) -6.90%
Fund balance, end of year 262,716$ 283,065$ 290,784$ 270,723$ 267,443$ 243,832$ (26,891)$ -9.93%
2012 Budget Summary
22
Fund: 210 Cable TV Revenues
Account Description 2009 2010 2011 2012 Description
3180 Franchise fee revenue 96,000 96,000 96,000 100,000 Estimated collections
96,000 96,000 96,000 100,000
3680 Other revenue - 5,100 5,100 5,100 Lease revenue from Library fiber connection
- 5,100 5,100 5,100
Fund: 210 Department: 4350 Operations
1230 Supplies, equipment 3,500 4,000 2,000 2,000 Equipment costing less than $1,000 per item
3,500 4,000 2,000 2,000
1600 Supplies, operating 1,000 1,000 750 750 Recording media - tapes, DVD's
500 500 250 250 Batteries, cables, bulbs, tapes, misc
1,500 1,500 1,000 1,000
3030 Other professional services 3,300 3,400 3,600 4,140 Web streaming meetings $300 per month.
3,300 3,400 3,600 4,140
3630 Training & conferences 700 700 300 300 Attendance at local training
- 600 - - Submission fees for awards (new item for 2010)
700 1,300 300 300
3800 Mileage & parking 200 100 100 75 Mileage
200 100 100 75
3900 Grants & subsidies 26,382 27,254 26,933 27,232 Share of costs of North Suburban Cable Commission
26,382 27,254 26,933 27,232
5130 Repairs, equipment 1,500 1,500 1,000 10,000 Repair and maintenance of equipment
1,500 1,500 1,000 10,000
7030 Capital, equipment 2,000 - - - Podeum and other council chamber improvements
1,700 - - - Adobe Creative Suite 3 Production Premium Software
3,700 - - -
40,782 39,054 34,933 44,747
-30.39%-4.24%-10.55%28.09%
23
Y-T-D
2008 2009 2010 2011 09/30/11 2012
Actual Actual Actual Budget Actual Request Dollar Percent
DARE (Fund 220):
Revenues
3511 Fines - controlled substnc 643 759 538 800 565 500 (300) -37.50%
3610 Investment income - - - - - - - 0.00%
3650 Donations - - - - - - - 0.00%
3680 Other revenue - 450 - - - - - 0.00%
Total revenue 643 1,209 538 800 565 500 (300) -37.50%
Operating expenses (4200):
Materials & supplies
1600 Supplies, operating 1,357 754 1,189 650 582 350 (300) -46.15%
Total Supplies 1,357 754 1,189 650 582 350 (300) -46.15%
Contractual services
3030 Other professional services - - - - - - - 0.00%
3430 Printing - - - 100 - 100 - 0.00%
3610 Memberships - - - 50 - 50 - 0.00%
3630 Training & conferences - - - - - - - 0.00%
Total contractual services - - - 150 - 150 - 0.00%
Transfers
9900 Transfers out 4,393 4,393 4,393 3,000 - - - 0.00%
Total capital outlays 4,393 4,393 4,393 3,000 - - - 0.00%
Total expenditures 5,750 5,147 5,582 3,800 582 500 (300) -7.89%
Net change in fund balance (5,107) (3,938) (5,044) (3,000) (17) - 3,092 -103.07%
Fund balance, beginning year 19,610 14,503 10,565 5,520 5,520 2,520 (3,000) -54.34%
Fund balance, end of year 14,503$ 10,565$ 5,520$ 2,520$ 5,503$ 2,520$ -$ 0.00%
2012 Budget Summary
Change from 2011
24
Fund: 220 DARE Revenues
Account Description 2009 2010 2011 2012 Description
3511 Fines - controlled substance 1,600 850 800 500 Estimated collections
1,600 850 800 500
3610 Interest revenue - - - - Estimated interest earnings (moved to general fund per council 08)
- - - -
Fund: 220 Department: 4200 Operations
1600 Supplies, operating 2,500 2,000 650 350 DARE apparel and supplies.
2,500 2,000 650 350
3430 Printing 100 100 100 100 Programs and parent guides.
100 100 100 100
3610 Memberships 100 100 50 50 NSRO, NDOA, & MNDARE.
100 100 50 50
3630 Training & conferences 800 800 - - DARE or NSRO conference.
800 800 - -
9900 Transfer out 4,393 4,393 3,000 - Reimburse General Fund for 5% of DARE officer salary
4,393 4,393 3,000 -
7,893 7,393 3,800 500
25
Y-T-D
2008 2009 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
Forfeiture (Fund 225):
Revenues
3514 Forfeitures 10,098 15,744 14,831 5,500 9,012 5,500 - 0.00%
3610 Investment income - - - - - - - 0.00%
3650 Donations - - - - - - - 0.00%
3680 Other revenue 6,703 - 422 - - - - 0.00%
Total revenue 16,801 15,744 15,253 5,500 9,012 5,500 - 0.00%
Operating expenses (4200):
Materials & supplies
1230 Supplies, equipment - - - - - - 0.00%
1600 Supplies, operating 7,334 206 340 500 1,057 500 - 0.00%
Total materials & supplies 7,334 206 340 500 1,057 500 - 0.00%
Contractual services
3030 Other professional services 203 5,880 4,545 1,500 2,238 1,500 - 0.00%
Total contractual services 203 5,880 4,545 1,500 2,238 1,500 - 0.00%
Capital
7030 Equipment 21,576 - - - - - - 0.00%
7040 Vehicles 25,000 - - 29,000 33,880 - - 0.00%
Total capital outlays 46,576 - - 29,000 33,880 - - 0.00%
Total expenses 54,113 6,086 4,885 31,000 37,175 2,000 - 0.00%
Net change in fund balance (37,312) 9,658 10,368 (25,500) (28,163) 3,500 29,000 -113.73%
Fund balance, beginning year 64,004 26,692 36,350 46,718 46,718 21,218 (25,500) -54.58%
Fund balance, end of year 26,692 36,350 46,718 21,218 18,555 24,718 3,500 16.50%
2012 Budget Summary
26
Fund: 225 Forfeiture Revenues
Account Description 2009 2010 2011 2012 Description
3514 Forfeitures 5,500 5,500 5,500 5,500 Sale of forfeited vehicles at auction.
5,500 5,500 5,500 5,500
3610 Interest revenue - - - - Estimated interest earnings (moved to general fund per council 08)
- - - -
Fund: 225 Department: 4200 Operations
1600 Supplies - operating 1,000 500 500 500 Supplies to prepare vehicles for auction. (tows, title fees, batteries)
- -
- -
- -
1,000 500 500 500
3030 Other professional services 4,125 2,000 1,500 1,500 Share of auction costs.
4,125 2,000 1,500 1,500
7030 Equipment 10,000 - - - In-squad cameras
- - 29,000 - One squad $23,000 + set-up $6000 One in General Fund.
8,800 9,500 - - Speed display unit
18,800 9,500 29,000 -
23,925 12,000 31,000 2,000
27
Y-T-D
2008 2009 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
EDA (Fund 230):
Revenues
3425 Remodeling planbook 15 - - - - - - 0.00%
3680 Other revenue 5,464 2,760 2,815 - 5,743 - - 0.00%
3972 Transfers 156,680 129,824 127,649 387,435 - 319,781 (67,654) -17.46%
Total revenue 162,159 132,584 130,464 387,435 5,743 319,781 (67,654) -17.46%
Operating expenses
Economic Development (4650):
Personnel services
0100 Salaries, regular 71,885 77,240 78,820 78,681 54,463 18,570 (60,111) -76.40%
0300 Social security 5,335 5,808 5,946 6,019 4,120 1,421 (4,598) -76.39%
0321 PERA 4,438 5,098 5,500 5,703 3,900 1,346 (4,357) -76.40%
0400 Group insurance 9,577 9,039 9,734 9,628 7,134 1,678 (7,950) -82.57%
0500 Workers compensation 209 274 323 429 382 107 (322) -75.06%
0600 Unemployment - - - - - 15,210 15,210 #DIV/0!
0990 Severence pay - - - - - - - 0.00%
Total personnel services 91,444 97,459 100,324 100,460 69,999 38,332 (62,128) -61.84%
Materials & supplies
1600 Supplies, operating - - - 150 - 100 (50) -33.33%
2100 Book & periodicals 269 110 - 130 175 200 70 53.85%
Total materials & supplies 269 110 - 280 175 300 20 7.14%
Contractual services
3030 Other professional services 46,277 28,645 21,775 73,910 18,312 68,998 (4,912) -6.65%
3420 Advertisements 336 717 273 1,000 365 1,000 - 0.00%
3430 Printing - 556 885 1,000 156 1,000 - 0.00%
3610 Memberships 10,086 3,935 3,066 3,875 3,236 3,451 (424) -10.94%
3630 Training & conferences 1,980 1,262 616 2,210 529 2,000 (210) -9.50%
3800 Mileage - - - 100 22 100 - 0.00%
4800 Insurance 3,767 3,912 3,526 4,600 3,494 4,600 - 0.00%
5210 Housing replacement 8,000 - - 150,000 50,000 150,000 - 0.00%
Total contractual services 70,446 39,027 30,140 236,695 76,114 231,149 (5,546) -2.34%
Capital outlays
9300 Business subsidies - - - 50,000 - 50,000 - 0.00%
Total capital outlays - - - 50,000 - 50,000 - 0.00%
Total expenditures 162,159 136,596 130,464 387,435 146,288 319,781 (67,654) -17.46%
Net change in fund balance - (4,012) - - (140,545) - - 0.00%
Fund balance, beginning year 4,012 4,012 - - - - - 0.00%
Fund balance, end of year 4,012 - - - (140,545) - - 0.00%
2012 Budget Summary
28
Fund: 230 EDA Revenues
Account Description 2009 2010 2011 2012 Description
3610 Interest income 75 - - - Estimated interest earnings at 1.50%.
75 - - -
3972 Transfers 380,865 385,189 387,435 Transfers from TIF 1,2,3,5
380,865 385,189 387,435 -
Fund: 230 Department: 4650 Economic Development
1600 Supplies, operating 200 150 150 100 Misc office supplies
200 150 150 100
2100 Books & periodicals 100 100 - - MN Real Estate Journal
- - - - Mpls./St.Paul Business Journal
30 30 30 30 LMC directory
100 100 100 170 Misc. reports & periodicals (Finance & Commerce)
230 230 130 200
3030 Other professional services 7,000 7,000 7,000 7,000 Legal fees for development reviews
12,000 12,000 12,000 12,000 Financial consultant fees (Ehlers)
31,500 30,000 30,000 25,000 Special project consultant fees
11,750 - - - City branding - Marketing Group Services
5,000 5,000 5,000 5,000 Appraisal and environmental fees
4,200 4,290 4,410 4,498 15% audit fee
12,000 12,500 12,500 12,500 Housing Resource Center fees
3,000 3,000 3,000 3,000 Marketing Consultant fees
86,450 73,790 73,910 68,998
3420 Advertising 1,000 1,000 1,000 1,000 Targeted advertisements.
1,000 1,000 1,000 1,000
3430 Printing 500 500 500 500 Property ad printing
200 200 200 200 Stationary/business cards/signs/site info
1,200 - - - Business directory reprints
300 300 300 300 Misc printing
2,200 1,000 1,000 1,000
3610 Memberships 375 400 400 400 Economic Development Assoc of MN (EDAM)
5,500 - - - North Metro 35 W Corridor Coalition
600 600 600 250 Twin Cities North Chamber of Commerce dues
3,500 2,801 2,875 2,801 North Metro Mayors Assoc (50% of dues, 50% in GF)
9,975 3,801 3,875 3,451
3630 Training & conferences 400 400 400 300 Chamber of Commerce meetings
650 650 650 650 DEED/ EDC training
125 360 360 300 EDAM monthly meetings
800 600 600 600 EDAM summer conference
300 200 200 150 Other miscellaneous training
2,275 2,210 2,210 2,000
3800 Mileage 100 100 100 100 Misc. mileage
4800 Insurance 4,600 4,600 4,600 4,600 Allocation of the City's property & liability insurance
4,600 4,600 4,600 4,600
5210 Housing replacement 150,000 150,000 150,000 150,000 Housing Improvement programs
150,000 150,000 150,000 150,000
9300 Business subsidies 25,000 50,000 50,000 50,000 Business improvement partnership loans
25,000 50,000 50,000 50,000
282,030 286,881 286,975 281,449
29
THIS PAGE LEFT BLANK INTENTIONALLY
2012 Budget Summary
Y-T-D
2008 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Budget Actual Request Dollar Percent
Community Center (Fund 252):
Building overhead (4350)
Building overhead revenues 179,969 173,342 172,500 143 172,500 - 0.00%
Building overhead expenditures 1,632 8,184 9,900 18,397 - (9,900) -100.00%
Net Building Overhead Operations 178,337 165,158 162,600 (18,254) 172,500 9,900 6.09%
Banquet Center (4730):
Banquet revenues 75,740 84,895 80,000 61,135 80,000 - 0.00%
Banquet Center expenditures 92,125 106,370 148,241 84,835 151,662 3,421 2.31%
Net Banquet Center (16,385) (21,474) (68,241) (23,700) (71,662) (3,421) 5.01%
YMCA (4732):
YMCA revenues 24,572 33,162 30,450 16,751 30,450 - 0.00%
YMCA expenditures 207,627 203,284 232,771 144,172 232,765 (6) 0.00%
Net YMCA (183,055) (170,122) (202,321) (127,421) (202,315) 6 0.00%
Chamber of Commerce (4734):
Chamber revenues 10,832 4,049 - - - - 0.00%
Chamber expenditures 5,990 5,929 - - - - 0.00%
Net Chamber of Commerce 4,842 (1,879) - - - - 0.00%
Creative Kids Child Care Center (4736):
Creative Kids revenues 72,866 76,047 76,984 58,034 77,379 395 0.51%
Creative Kids expenditures 34,607 34,910 36,582 20,948 37,138 556 1.52%
Net Creative Kids 38,259 41,137 40,402 37,086 40,241 (161) -0.40%
Total revenue 363,979 371,496 359,934 136,063 360,329 395 0.11%
Total expenditures 341,981 358,677 427,494 268,352 421,566 (5,928) -1.39%
Net change in fund balance 21,998 12,819 (67,560) (132,289) (61,237) 6,323 -9.36%
Fund balance, beginning year 172,502 215,463 228,283 228,283 160,723 (67,560) -29.59%
Fund balance, end of year 194,500 228,283 160,723 95,994 99,486 (61,237) -38.10%
(continued)
30
2012 Budget Summary
YTD
2008 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Budget Actual Request Dollar Percent
Community Center (continued):
Building overhead (4350)
Building revenues:
3610 Investment income 4,677 2,508 2,500 2,500 - 0.00%
3634 Equipment rental 167 - - - - - 0.00%
3650 Donations - - - - - - 0.00%
3680 Miscellaneous 125 834 - 143 - - 0.00%
3972 Transfers from Sp. Projects - - - - - - 0.00%
3972 Transfers 175,000 170,000 170,000 170,000 - 0.00%
179,969 173,342 172,500 143 172,500 - 0.00%
Operating expenses
Personnel services
0100 Salaries, regular 35,408 35,327 34,726 25,422 35,420 694 2.00%
0110 Salaries,overtime - 958 1,670 757 1,703 33 1.98%
0300 Social Security 2,545 2,355 2,785 1,712 2,840 55 1.97%
0321 PERA 2,163 2,511 2,639 1,898 2,691 52 1.97%
0400 Group insurance 6,473 7,762 7,578 5,839 8,256 678 8.95%
0500 Workers compensation 1,196 1,558 1,540 1,371 1,540 - 0.00%
999 Allocation of salaries (47,785) (49,664) (50,938) (32,991) (52,450) (1,512) 2.97%
Total personnel services - 805 - 4,008 - - 0.00%
Materials & supplies
1210 Supplies, buildings & grounds 532 910 1,100 1,279 1,100 - 0.00%
1230 Supplies, equipment 1,339 2,380 400 546 800 400 100.00%
1600 Supplies, operating 8,387 6,526 7,000 3,929 7,000 - 0.00%
2400 Uniforms 337 396 450 286 450 - 0.00%
2410 Mats & towels 2,757 1,219 2,800 494 2,800 - 0.00%
2999 Allocation of supplies (13,352) (11,345) (11,850) (5,610) (12,150) (300) 2.53%
Total materials & supplies - 86 (100) 924 - 100 -100.00%
Contractual services
3030 Other professional services 239 147 200 1,114 200 - 0.00%
3100 Telephone 3,338 3,631 3,000 2,465 3,600 600 20.00%
3200 Water & sewer 9,412 8,792 9,500 3,356 9,500 - 0.00%
3210 Electricity 52,182 55,718 53,000 40,883 56,000 3,000 5.66%
3220 Natural gas 22,275 12,047 23,000 9,337 17,000 (6,000) -26.09%
3530 Refuse collection 4,272 4,792 4,100 2,828 4,500 400 9.76%
3999 Allocation of utilities (91,718) (85,183) (92,800) (50,613) (90,800) 2,000 -2.16%
5110 Repairs, building & grounds 10,533 11,599 18,000 14,674 17,330 (670) -3.72%
5130 Repairs, equipment 5,734 9,599 6,700 5,355 6,700 - 0.00%
5999 Allocation of repairs (16,267) (21,198) (24,700) (15,934) (24,030) 670 -2.71%
Total contractual services - (56) - 13,465 - - 0.00%
Capital
7030 Equipment 1,632 7,350 10,000 - - (10,000) -100.00%
Total capital outlays 1,632 7,350 10,000 - - (10,000) -100.00%
1,632 8,184 9,900 18,397 - (9,900) -100.00%
Total Building Overhead Net 178,337 165,158 162,600 (18,254) 172,500 9,900 6.09%
(continued)
31
Fund: 252 Department: 4350 Community Center Building Overhead
Account Description 2009 2010 2011 2012 Description
1210 Supplies, bldgs & grounds 1,200 1,200 1,100 1,100 Lights, signs, fertilizer
1,200 1,200 1,100 1,100
1230 Supplies, equipment 400 400 400 800 Small tools & equipment
400 400 400 800
1600 Supplies, operating 5,090 5,800 7,000 7,000 Batteries, soap, paper towels, cleaning supplies for bathrooms
Paper cups, plates, etc. for lounge & customer service events
5,090 5,800 7,000 7,000
2400 Uniforms 500 450 450 450 Uniforms
500 450 450 450
2410 Mats & towels 2,000 2,000 2,000 2,000 Floor mats and cleaning towelsto provide better protection of carpets
800 800 800 800 Special events
2,800 2,800 2,800 2,800
3030 Other professional services 200 200 200 200 Backflow inspection
200 200 200 200
3100 Telephone & internet 3,000 3,000 3,000 3,600 Office & customer phones, internet, maintenance agreements, & repairs
3,000 3,000 3,000 3,600
3200 Water & Wastewater 9,500 9,500 9,500 9,500 Water & sewer charges for community center
9,500 9,500 9,500 9,500
3210 Electricity 55,800 54,000 53,000 56,000 Estimated electrice charges
55,800 54,000 53,000 56,000
3220 Natural gas 30,240 25,500 23,000 17,000 Estimated natural gas charges
30,240 25,500 23,000 17,000
3530 Refuse collection 3,420 3,420 4,000 3,720 Dumpsters $310 x 12 months (10-$333)
- - - 680 Extra garbage pick-up charges
100 100 100 100 Ramsey County recyclying fee
3,520 3,520 4,100 4,500
5110 Repairs, building & grounds 5,760 5,760 5,760 5,760 Custodial services: 12 mths X $480
4,000 4,000 3,000 3,000 Commercial carpet cleaning service (twice annually)
6,180 6,180 5,180 4,500 Exterior building maintenance
750 750 750 770 Exterminator: 12 months X 64.02
2,000 2,000 1,500 1,500 Fire alarm system service
2,060 2,060 1,310 1,300 Parking lot & grounds maintenance
500 750 500 500 Security system service
21,250 21,500 18,000 17,330
5130 Repairs, equipment 4,500 5,000 5,000 5,000 HVAC system maintenance
200 200 200 200 Sprinkler inspections
1,500 1,500 1,500 1,500 Plumbing, electrical, & misc. interior maintenance
6,200 4,025 6,700 6,700
7030 Capital, equipment - - - - HVAC Improvements
- - 10,000 - Community Center Roof repairs
- - - - Roof over kitchen area (will be done as part of full reroof above in 2012)
- - 10,000 -
139,700 131,895 139,250 126,980
32
2012 Budget Summary
Y-T-D
2008 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Budget Actual Request Dollar Percent
Community Center (continued):
Banquet Center (4730):
Banquet Revenues
3644 Equipment rental 109 - - - - - 0.00%
3645 Rental - banquet facility 75,631 84,895 80,000 61,135 80,000 - 0.00%
0.00%
75,740 84,895 80,000 61,135 80,000 - 0.00%
Banquet Expenditures
Personnel services
0999 Allocation of salaries 9,557 9,933 10,188 6,529 10,490 302 2.96%
Total personnel services 9,557 9,933 10,188 6,529 10,490 302 2.96%
Materials & supplies
1230 Supplies, equipment - - - 258 - - 0.00%
2999 Allocation of supplies 3,798 3,298 3,318 1,680 3,402 84 2.53%
Total materials & supplies 3,798 3,298 3,318 1,938 3,402 84 2.53%
Contractual services
3030 Other professional services 35,356 56,697 51,075 39,676 55,256 4,181 8.19%
3100 Telephone 412 399 600 375 500 (100) -16.67%
3420 Advertising 266 - 750 - 500 (250) -33.33%
3430 Printing 97 - 250 - 250 - 0.00%
3999 Allocation of utilities 25,270 23,616 25,744 17,092 25,136 (608) -2.36%
4800 Bonding & insurance 1,720 1,610 2,100 1,595 2,100 - 0.00%
5110 Repairs, building & grounds 2,907 320 1,700 5,896 1,700 - 0.00%
5130 Repairs, equipment 2,975 274 1,600 1,215 1,600 - 0.00%
5999 Allocation of repairs 4,400 5,935 6,916 6,508 6,728 (188) -2.71%
Total contractual services 73,403 88,852 90,735 72,357 93,770 3,035 3.35%
Capital
7030 Equipment 5,367 4,287 44,000 4,011 44,000 - 0.00%
Total capital outlays 5,367 4,287 44,000 4,011 44,000 - 0.00%
92,125 106,370 148,241 84,835 151,662 3,421 2.31%
Total Banquet Center net (16,385) (21,474) (68,241) (23,700) (71,662) (3,421) 5.01%
(continued)
33
Fund: 252 Community Center
Expenses
Account Description 2009 2010 2011 2012 Description
2999 Allocation of supplies 2,797 2,982 3,318 3,402 28% Allocation from overall building support
2,797 2,982 3,318 3,402
3030 Other professional services 700 715 735 745 2.5% of audit
850 2,600 2,600 2,600 Miscellaneous professional services (linen service)
47,103 45,333 46,240 50,411 Banquet facility management
1,500 1,500 1,500 1,500 Legal costs
50,153 50,148 51,075 55,256
3100 Telephone/Internet 900 450 600 500 Internet service (1/2 reimbursed from other tenants)
900 450 600 500
3420 Advertising & marketing 1,000 1,000 750 500 Website and traditional advertising, marketing
1,000 1,000 750 500
3430 Printing 250 250 250 250 Brochures, flyers, etc.
250 250 250 250
3999 Allocation of utilities 28,393 26,562 25,744 25,136 28% Allocation from overall building utilities
28,393 26,562 25,744 25,136
4800 Bonding & insurance 2,100 2,100 2,100 2,100 Insurance & bonding cost
2,100 2,100 2,100 2,100
5110 Repairs, building & grounds 1,200 1,200 1,200 1,200 Interior building repairs specific to the banquette center
500 500 500 500 Dance floor maintenance
1,700 1,700 1,700 1,700
5130 Repairs, equipment 1,600 1,600 1,600 1,600 Repairs to kitchen, audio system, and other banquette equipment
1,600 1,600 1,600 1,600
5999 Allocation of repairs 7,686 7,826 6,916 6,728 28% Allocation from overall building repairs
7,686 7,826 6,916 6,728
7030 Capital, equipment 4,000 4,000 4,000 4,000 Table replacement program
- - 40,000 40,000 Chairs for banquet center (400 @ $100)
1,200 - - - LCD Projectors (2)
5,200 4,000 44,000 44,000
101,779 98,618 138,053 141,172
34
2012 Budget Summary
YTD
2008 2010 2011 09/30/11 2012
Actual Actual Budget Actual Request Dollar Percent
Community Center (continued):
YMCA (4732):
YMCA Revenues
3405 Recreation profit 6,941 14,976 12,000 - 12,000 - 0.00%
3660 Gym & meeting room rental 4,221 4,691 7,000 7,021 5,000 (2,000) -28.57%
3661 Open gym participant fees 13,050 13,036 11,000 9,573 13,000 2,000 18.18%
3679 Commissions - vending 360 459 450 157 450 - 0.00%
24,572 33,162 30,450 16,751 30,450 - 0.00%
YMCA Expenditures
Personnel services -
0999 Allocation of salaries 32,972 34,268 36,675 23,174 37,764 1,089 2.97%
Total personnel services 32,972 34,268 36,675 23,174 37,764 1,089 2.97%
Materials & supplies
1600 Supplies, operating 29 - - - - - 0.00%
2999 Allocation of supplies 6,797 5,892 6,281 2,973 6,440 159 2.52%
Total materials & supplies 6,826 5,892 6,281 2,973 6,440 159 2.52%
Contractual services
3030 Other professional services 93,213 94,659 99,505 71,578 99,505 - 0.00%
3300 Postage 1,177 - 1,200 1,200 - 0.00%
3430 Printing 7,564 4,620 6,000 3,790 6,000 - 0.00%
3999 Allocation of utilities 46,373 43,608 49,994 24,197 49,096 (898) -1.80%
4800 Bonding & insurance 2,866 2,683 4,025 3,057 4,025 - 0.00%
5110 Repairs, building & grounds 5,451 178 12,000 7,187 12,000 - 0.00%
5130 Repairs, equipment 2,827 6,777 4,000 1,817 4,000 - 0.00%
5999 Allocation of repairs 8,358 10,599 13,091 6,399 12,736 (355) -2.71%
Total contractual services 167,829 163,124 189,815 118,025 188,562 (1,253) -0.66%
207,627 203,284 232,771 144,172 232,765 (6) 0.00%
Total YMCA net (183,055) (170,122) (202,321) (127,421) (202,315) 6 0.00%
(continued)
Change from 2011
35
Fund: 252 Community Center
Account Description 2009 2010 2011 2012 Description
2999 Allocation of supplies 4,995 5,325 6,281 6,440 50% Allocation from overall building support
4,995 5,325 6,281 6,440
3030 Other professional services 95,000 95,400 97,300 97,300 YMCA management contract (other half of fee in parks)
2,100 2,145 2,205 2,235 7.5% of audit
97,100 97,545 99,505 99,535
3300 Postage 1,200 1,200 1,200 1,200 50% of the cost of mailing the Mounds View Matters newsletter
1,200 1,200 1,200 1,200
3430 Printing 6,000 6,000 6,000 6,000 50% of the cost of printing the Mounds View Matters newsletter
6,000 6,000 6,000 6,000
3999 Allocation of utilities 52,030 48,760 49,994 49,096 50% Allocation from overall building utilities
52,030 48,760 49,994 49,096
4010 Rental, equipment 500 - - - RecNet recreation programming and facility rental software
500 - - -
4800 Bonding & insurance 3,500 3,500 4,025 4,025 Insurance & bonding cost.
3,500 3,500 4,025 4,025
5110 Repairs, building & grounds 2,000 2,000 3,000 3,000 General building repairs
- - 7,000 - Interior improvements
10,000 10,000 2,000 2,000 Gym floor resurfacing & maintenance
12,000 12,000 12,000 5,000
5130 Repairs, equipment 2,650 2,650 2,650 2,650 Copier maintenance contract
1,000 1,000 1,000 1,000 Registration system support
350 350 350 350 Repairs to other equipment
4,000 4,000 4,000 4,000
5999 Allocation of repairs 13,725 13,975 13,091 12,736 50% Allocation from overall building repairs
13,725 13,975 13,091 12,736
195,050 192,305 196,096 188,032
36
THIS PAGE LEFT BLANK INTENTIONALLY
2012 Budget Summary
YTD
2008 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Budget Actual Request Dollar Percent
Creative Kids Child Care (4736):
Child Care Revenues
3632 Lease - Child Care 72,866 76,047 76,984 58,034 77,379 395 0.51%
72,866 76,047 76,984 58,034 77,379 395 0.51%
Child Care Ed Expenditures
Personnel services
0999 Allocation of salaries 3,824 3,973 4,075 2,575 4,196 121 2.97%
Total personnel services 3,824 3,973 4,075 2,575 4,196 121 2.97%
Materials & supplies
2999 Allocation of supplies 2,549 2,236 2,252 1,066 2,309 57 2.51%
Total materials & supplies 2,549 2,236 2,252 1,066 2,309 57 2.51%
Contractual services
3999 Allocation of utilities 16,842 15,713 17,062 9,324 16,568 (494) -2.90%
4750 Taxes, licenses, & fees 6,790 7,888 7,100 3,893 8,100 1,000 14.08%
4800 Bonding & insurance 1,146 1,073 1,400 1,063 1,400 - 0.00%
5110 Repairs, building & grounds - - - - - - 0.00%
5999 Allocation of repairs 3,456 4,028 4,693 3,027 4,566 (127) -2.71%
Total contractual services 28,234 28,702 30,255 17,307 30,634 379 1.25%
Total Child Care expenditures 34,607 34,910 36,582 20,948 37,138 556 1.52%
Total Child Care net 38,259 41,137 40,402 37,086 40,241 (161) -0.40%
37
2012 Budget Summary
Y-T-D
2008 2009 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
Lakeside Park (Fund 255):
Revenues
3370 Spring Lake Pk contribution 10,608 10,608 10,608 10,608 10,608 10,608 - 0.00%
3370 Mounds View contribution 10,608 10,608 10,608 10,608 10,608 10,608 - 0.00%
3610 Investment income 345 478 186 300 300 - 0.00%
3680 Other revenue - - - - 0.00%
3665 Park site permit 515 217 801 150 201 250 100 66.67%
Total revenue 22,076 21,911 22,204 21,666 21,417 21,766 100 0.46%
Operating expenses (4350):
Personnel services
0150 Salaries, part-time 2,853 3,360 3,780 3,349 3,360 3,349 - 0.00%
0300 Social security 218 257 289 256 257 256 - 0.00%
0500 Workers compensation 63 87 94 94 84 94 - 0.00%
Total personnel services 3,134 3,704 4,164 3,699 3,701 3,699 - 0.00%
Materials & supplies
1210 Supplies, bldgs & grounds 1,595 432 4,285 600 - 600 - 0.00%
1600 Supplies, operating 1,155 1,714 - 1,800 - 1,800 - 0.00%
Total materials & supplies 2,750 2,146 4,285 2,400 - 2,400 - 0.00%
Contractual services
3030 Other professional services - - - - - - - 0.00%
3100 Telephone/Internet - - - - - - - 0.00%
3200 Water & sewer 1,381 2,159 1,315 1,400 774 1,400 - 0.00%
3210 Electricity 637 700 919 700 1,186 1,500 800 114.29%
3530 Refuse collection 48 48 118 300 48 250 (50) -16.67%
4010 Equipment Contribution SLP 4,233 4,481 4,481 4,372 4,372 - 0.00%
4030 Satellites 550 507 389 550 207 500 (50) -9.09%
4800 Insurance 3,440 3,572 4,019 4,150 4,150 4,200 50 1.20%
5130 Repairs, equipment 637 3,316 - 4,095 3,445 (650) -15.87%
Total contractual services 10,926 14,783 11,242 15,567 6,365 15,667 100 0.64%
Capital
7030 Equipment - - - - - - - 0.00%
7050 Construction - - - - - - - 0.00%
Total capital outlays - - - - - - - 0.00%
Total expenses 16,810 20,633 19,690 21,666 10,066 21,766 100 0.46%
Net change in fund balance 5,266 1,278 2,513 - 11,351 - - 0.00%
Fund balance, beginning year 2,108 7,374 8,652 11,165 11,165 11,165 - 0.00%
Fund balance, end of year 7,374 8,652 11,165 11,165 22,516 11,165 - 0.00%
38
Fund: 255 Lakeside Park
Account Description 2009 2010 2011 2012 Description
3370 Contributions 10,608 10,608 10,608 10,608 Spring Lake Park contribution for half of cost for joint park
10,608 10,608 10,608 10,608
3370 Contributions 10,608 10,608 10,608 10,608 Mounds View contribution for half of cost for joint park
10,608 10,608 10,608 10,608
3610 Interest revenue 300 300 300 300 Estimated interest earnings at 2.00%.
300 300 300 300
3680 Park sit rental 150 150 150 250 Rental of the park by groups or individuals
150 150 150 250
Fund: 255 Department: 4350
1210 Supplies, bldgs & grounds 600 600 600 600 Paper, sand, etc.
600 600 600 600
1600 Supplies, operating 1,595 1,800 1,800 1,800 Fertilizer & pesticides
1,595 1,800 1,800 1,800
3200 Water & sewer 1,000 1,400 1,400 1,400 Estimated water & sewer charges
1,000 1,400 1,400 1,400
3210 Electricity 600 600 700 1,500 Estimated electric charges
600 600 700 1,500
3530 Refuse collection 400 400 300 250 Six months service
400 400 300 250
4010 Equipment, capital charge 4,372 4,372 4,372 4,372 Capital charge for usage of SLP city equipment
4,372 4,372 4,372 4,372
4030 Satellites 500 500 550 500 Five months service
500 500 550 500
4800 Insurance & bonds 4,200 4,200 4,150 4,200 Property & liability insurnace
4,200 4,200 4,150 4,200
5130 Repairs, equipment 4,700 4,095 4,095 3,445 Repair of equipment at the park
4,700 4,095 4,095 3,445
17,967 17,967 17,967 18,067
0.00%0.00%0.00%0.56%
39
2012 Budget Summary
Y-T-D
2008 2009 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
Recycling (Fund 290):
Revenues
3360 Other County grants 25,806 25,806 25,598 26,185 19,588 26,185 - 0.00%
3680 Other revenue 943 943 - - - - - 0.00%
Total revenue 26,749 26,749 25,598 26,185 19,588 26,185 - 0.00%
Operating expenses
Operations (4420)
Personnel services
0100 Salaries, regular 5,523 5,523 8,570 8,488 6,159 8,611 123 1.45%
0300 Social security 388 388 553 646 395 659 13 2.01%
0321 PERA 342 342 600 612 446 624 12 1.96%
0400 Group insurance 1,420 1,420 2,259 2,190 1,716 2,385 195 8.90%
0500 Workers compensation 27 27 55 63 56 63 - 0.00%
0990 Severence pay - - - - - - 0.00%
Total personnel services 7,700 7,700 12,037 11,999 8,772 12,342 343 2.86%
Materials & supplies
1600 Supplies, operating 4,320 4,320 4,505 - - - - 0.00%
Contractual services
3030 Other professional services 150 150 1,800 - 824 - - 0.00%
3300 Postage 1,806 1,806 2,245 1,200 1,800 1,200 - 0.00%
3420 Advertisements - - - 1,545 1,202 (343) -22.20%
3430 Printing 4,158 4,158 520 1,301 2,161 1,301 - 0.00%
3530 Refuse collection 4,486 4,486 5,291 10,140 11,004 10,140 - 0.00%
3960 Awards - - - - - - - 0.00%
Total contractual services 10,600 10,600 9,856 14,186 15,789 13,843 (343) -2.42%
Capital
7030 Equipment - - - - - - - 0.00%
Total capital outlays - - - - - - - 0.00%
Total expenses 22,620 22,620 26,398 26,185 24,561 26,185 - 0.00%
Net change in fund balance 4,129 4,129 (800) - (4,973) - - 0.00%
Fund balance, beginning year 14,191 18,320 22,449 21,649 21,649 21,649 - 0.00%
Fund balance, end of year 18,320 22,449 21,649 21,649 16,676 21,649 - 0.00%
40
Fund: 290 Recycling Grant Revenues
Account Description 2009 2010 2011 2012 Description
3360 Other grants & aid 26,218 26,545 26,185 26,185 Estimated Ramsey County recycling grant
26,218 26,545 26,185 26,185
Fund: 290 Department: 4420 Operations
1600 Supplies, operatin 4,000 - - -
4,000 - - -
3030 Other professional services - - - -
- - - -
3300 Postage 2,000 1,200 1,200 1,200 City wide mailing for Cleanup Day
2,000 1,200 1,200 1,200
3420 Advertisements 1,000 1,545 1,545 1,202 Promotional items
1,000 1,545 1,545 1,202
3430 Printing 1,800 501 501 501 Articles in City newsletter
1,413 800 800 800 Clean-up Day printing of direct mailing items
3,213 1,301 1,301 1,301
3530 Refuse collection 6,000 10,500 10,140 10,140 Contractual services for City Cleanup Day
6,000 10,500 10,140 10,140
16,213 14,546 14,186 13,843
41
2012 Budget Summary
Y-T-D
2008 2009 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
TIF # 1 (Fund 410):
Revenues
3101 Tax collections 1,200,245 1,493,611 1,632,309 1,434,611 890,855 1,493,611 59,000 4.11%
3101 Tax collections - Mermaid 166,058 156,520 - - - 0.00%
3102 Taxes - delinquent (113) - 0.00%
3103 Market value credit 951 1,022 1,130 - 0.00%
3610 Investment income 102,265 41,887 6,183 14,000 - 10,000 (4,000) -28.57%
3972 Transfer from other funds 40,747 - - 0.00%
Total revenue 1,510,266 1,693,040 1,639,509 1,448,611 890,855 1,503,611 55,000 3.80%
Operating expenses (4650):
Contractual services
3030 Other professional 3,463 2,212 2,818 2,000 1,219 2,000 - 0.00%
5220 Highway 10 redevelopment 100,168 20,261 1,200 375,000 (375,000) -100.00%
7050 Construction 276,499 3,664,138 653,111 1,829,287 1,526,369 1,504,027 (325,260) -17.78%
8010 Developer PAG, principal 279,438 - 0.00%
9900 Transfers out to EDA 171,262 24,634 24,660 107,139 - 86,456 (20,683) -19.30%
9900 Transfers out to other funds - - - - - - 0.00%
Total contractual services 551,392 3,711,245 961,226 2,313,426 1,527,588 1,592,483 (720,943) -31.16%
Net change in fund balance 958,874 (2,018,205) 678,283 (864,815) (636,733) (88,872) 775,943 -89.72%
Fund balance, beginning year 1,646,368 2,605,242 587,037 1,265,320 1,265,320 400,505 (864,815) -68.35%
Fund balance, end of year 2,605,242 587,037 1,265,320 400,505 628,587 311,633 (88,872) -22.19%
42
Fund: 410 TIF District #1 Revenues
Account Description 2009 2010 2011 2012 Description
3101 Tax increment collections 1,213,988 1,213,988 1,434,611 1,493,611 Estimated collections of incremental taxes on properties in the district.
1,213,988 1,213,988 1,434,611 1,493,611
3101 Tax increment collections 156,520 178,838 - - Estimated collections of incremental taxes on the Mermaid
156,520 178,838 - - property which are dedicated to the 2001A TIF bonds. (bonds paid off)
3610 Interest income 40,000 10,000 14,000 10,000 Estimated interest earnings at 1.50%.
40,000 10,000 14,000 10,000
Fund: 410 Department: 4650 Economic Development
3030 Other professional services 1,000 1,000 2,000 2,000 TIF administration and reporting fees
1,000 1,000 2,000 2,000
5220 County Rd 10 redevelopment - - - - CR 10 trail segmentsj 9 - 10
- - - 5,000 CR 10/Silver Lake Rd Intersection (design)
- 100,000 375,000 25,000 CR 10/CR H Intersection (preconstruction)
- 100,000 375,000 30,000
7050 Construction 3,500,000 365,000 - - Area B & C Street project
- 300,000 1,829,287 - Area D Street project (preconstruction)
- - - 1,000,000 Area E Street project
- - - 474,027 Area F Street project (preconstruction)
3,500,000 665,000 1,829,287 1,474,027
9900 Transfer out to EDA Fund 112,851 109,398 107,138 Transfer to cover the EDA operating budget.
112,851 109,398 107,138 -
9900 Transfer out to debt service - - - - Transfer to make debt service payments on TIF bonds 01A (Mermaid)
- - - -
3,613,851 875,398 2,313,425 1,506,027
43
2012 Budget Summary
Y-T-D
2008 2009 2010 2011 09/30/11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
TIF # 2 (Fund 420):
Revenues
3101 Tax collections 128,125 143,266 152,505 154,335 69,165 138,330 (16,005) -10.37%
3102 Tax collections - delinquent - 1,116 - - - - 0.00%
3103 Market value credit 730 765 638 - - - 0.00%
3610 Investment income 16,275 11,347 5,523 2,500 2,500 - 0.00%
3680 Other revenue 25 - - - - - 0.00%
3972 Transfer from other funds 60,978 - - - - - 0.00%
Total revenue 206,133 156,494 158,666 156,835 69,165 140,830 (16,005) -10.20%
Operating expenses (4650):
Contractual services
3030 Other professional 1,375 1,240 1,559 1,200 1,989 2,000 800 66.67%
4750 Taxes, Licenses, & Fees - - - - - - - 0.00%
7050 Construction - 165,734 - - - - - 0.00%
8010 Developer PAG, principal 34,412 37,358 42,602 46,753 42,495 38,238 (8,515) -18.21%
9900 Transfers out to debt service/EDA 81,776 24,634 24,660 107,138 - 86,456 (20,682) -19.30%
Total contractual services 117,563 228,966 68,821 155,091 44,484 126,694 (28,397) -18.31%
Net change in fund balance 88,570 (72,472) 89,845 1,744 24,681 14,136 12,392 710.55%
Fund balance, beginning year 337,428 425,998 353,526 443,371 443,371 445,115 1,744 0.39%
Fund balance, end of year 425,998 353,526 443,371 445,115 468,052 459,251 14,136 3.18%
44
Fund: 420 TIF District #2 Revenues
Account Description 2009 2010 2011 2012 Description
3101 Tax increment collections 146,436 151,698 154,335 138,330 Estimated collections of incremental taxes on properties
146,436 151,698 154,335 138,330 in the district.
3610 Investment income 11,250 2,500 2,500 Estimated interest earnings at 1.50%.
11,250 2,500 2,500 -
Fund: 420 Department: 4650 Economic Development
3030 Other professional services 1,200 1,200 1,200 2,000 TIF administration and reporting fees
1,200 1,200 1,200 2,000
7050 Construction 313,019 - - - 2009/2010 Street project
313,019 - - -
8010 Pay-as-you-go principal 36,264 38,452 46,753 38,238 Principal on a revenue note issued to promote a development.
36,264 38,452 46,753 38,238 (Silver Lake Point Project - Heartland MV Common Bond, LLC.)
9900 Transfer out to EDA Fund 112,851 109,397 107,138 Transfer to cover the EDA operating budget.
112,851 109,397 107,138 -
463,334 149,049 155,091 40,238
45
2012 Budget Summary
Y-T-D
2008 2009 2010 2011 09/30/11 2012
Actual Actual Actual Budget Actual Request Dollar Percent
TIF # 3 (Fund 430):
Revenues
3101 Tax collections 367,643 351,862 475,317 370,824 174,964 349,928 (20,896) -5.64%
3102 Tax collections - delinquent - - 69,085 - - - 0.00%
3610 Investment income 33,367 21,013 7,701 10,000 10,000 - 0.00%
3972 Transfer from other funds - - - - - - 0.00%
Total revenue 401,010 372,875 552,103 380,824 174,964 359,928 (20,896) -5.49%
Operating expenses (4650):
Contractual services
3030 Other professional 915 987 920 1,200 1,219 1,200 - 0.00%
5220 Highway 10 redevelopment 95,413 723,906 66,208 - 4,897 - - 0.00%
7050 Construction 1,484 - - 625,456 3,159 425,973 (199,483) -31.89%
8010 Developer PAG, principal 250,000 - - - - - 0.00%
8020 Developer PAG, interest 9,930 - - - - - 0.00%
9900 Transfers out to other funds - - - - - - 0.00%
9900 Transfers out to EDA 95,875 24,634 24,660 107,138 - 86,456 (20,682) -19.30%
Total contractual services 453,617 749,527 91,788 733,794 9,275 513,629 (220,165) -30.00%
Net change in fund balance (52,607) (376,652) 460,315 (352,970) 165,689 (153,701) 199,269 -56.45%
Fund balance, beginning year 894,170 841,563 464,911 925,226 925,226 572,256 (352,970) -38.15%
Fund balance, end of year 841,563 464,911 925,226 572,256 1,090,915 418,555 (153,701) -26.86%
Change from 2011
46
Fund: 430 TIF District #3 Revenues
Account Description 2009 2010 2011 2012 Description
3101 Tax increment collections 394,056 328,408 370,824 349,928 Estimated collections of incremental taxes on properties
394,056 328,408 370,824 349,928 in the district.
3610 Investment income 22,500 12,500 10,000 10,000 Estimated interest earnings at 2.50%.
22,500 12,500 10,000 10,000
Fund: 430 Department: 4650 Economic Development
3030 Other professional services 1,200 1,200 1,200 1,200 TIF administration and reporting fees
1,200 1,200 1,200 1,200
7050 Construction - - 625,456 - Area E Street project (preconstruction)
- - - 425,973 Area E Street project (construction)
750,000 - - - CR 10 trail segments 1 - 5 (H to Silver Lk Rd)(also in 285 grant portion)
750,000 - 625,456 425,973 (prepare plans and specs in 2008)
9900 Transfer out to EDA Fund 112,851 109,397 107,138 Transfer to cover the EDA operating budget.
112,851 109,397 107,138 -
864,051 110,597 733,794 427,173
47
Y-T-D
2008 2009 2010 2011 09/30/11 2012
Actual Actual Actual Budget Actual Request Dollar Percent
TIF # 5 (Fund 450):
Revenues
3101 Tax collections 674,255 1,565,044 1,287,696 1,320,408 604,130 1,208,260 (112,148) -8.49%
3610 Investment income 3,265 4,161 5,286 9,000 - 6,000 (3,000) -33.33%
Total revenue 677,520 1,569,205 1,292,982 1,329,408 604,130 1,214,260 (115,148) -8.66%
Operating expenses (4650):
Contractual services
3030 Other professional 1,284 1,109 1,517 1,400 2,179 2,200 800 57.14%
8010 Developer PAG, principal 319,118 1,062,514 170,896 1,266,569 1,458,101 1,147,847 (118,722) -9.37%
8020 Developer PAG, interest - - 911,635 - - - 0.00%
9900 Transfers out to EDA 33,592 55,922 53,670 66,020 - 60,413 (5,607) -8.49%
Total contractual services 353,994 1,119,545 1,137,717 1,333,989 1,460,280 1,210,460 (123,529) -9.26%
Net change in fund balance 323,526 449,660 155,265 (4,581) (856,150) 3,800 8,381 -182.95%
Fund balance, beginning year - 323,526 773,186 928,451 928,451 923,870 (4,581) -0.49%
Fund balance, end of year 323,526 773,186 928,451 923,870 72,301 927,670 3,800 0.41%
2012 Budget Summary
Change from 2011
48
Fund: 450 TIF District #5 Revenues
Account Description 2009 2010 2011 2012 Description
3101 Tax increment collections 846,270 1,139,960 1,320,408 1,208,260 Estimated collections of incremental taxes on properties
846,270 1,139,960 1,320,408 1,208,260 in the district.
3610 Investment income 6,300 6,300 9,000 6,000 Estimated interest earnings at 1.50%.
6,300 6,300 9,000 6,000
Fund: 430 Department: 4650 Economic Development
3030 Other professional services 1,200 1,200 1,400 2,200 TIF administration and reporting fees
1,200 1,200 1,400 2,200
8010 Pay-as-you-go principal 803,956 1,082,963 1,266,569 1,147,847 Principal on a revenue note issued to promote a development. (Medtronic)
803,956 1,082,963 1,266,569 1,147,847
9900 Transfer out to EDA Fund 42,313 56,997 66,020 60,413 Transfer to cover the EDA operating budget.
42,313 56,997 66,020 60,413
49
THIS PAGE LEFT BLANK INTENTIONALLY
CITY OF MOUNDS VIEW, MINNESOTA
Capital Project Funds 2011 Budgets
Combining Statement of Revenues and Expenditures
Special Street Park Vehicle and
Projects Improvement Dedication Equipment 2012 2011
Revenue:
Taxes -$ 300,000$ -$ -$ 300,000$ 300,000$
Franchise fees - 253,000 - - 253,000 249,900
Intergovernmental:
State - 578,000 - - 578,000 578,000
Federal - - - - - -
Miscellaneous:
Investment income 10,000 72,500 10,000 - 92,500 132,000
Other - - 6,000 - 6,000 6,000
Total revenue 10,000 1,223,500 16,000 - 1,249,500 1,265,900
Expenditures:
General government 469,000 - - 70,890 539,890 442,000
Public safety - - 29,000 29,000 -
Streets and highways 1,078,280 - - 1,078,280 767,000
Culture and recreation - 150,500 - 150,500 310,000
Total expenditures 469,000 1,078,280 150,500 99,890 1,797,670 1,519,000
Excess (deficiency) of revenue
over expenditures (459,000) 145,220 (134,500) (99,890) (548,170) (253,100)
Other financing sources (uses)
Operating transfers
Transfers in - 300,000 - 185,000 485,000 300,000
Transfers out (90,000) - - (289,000) (379,000) (90,000)
Net change in fund balance (549,000) 445,220 (134,500) (203,890) (442,170) (43,100)
Fund balance, January 1 803,352 7,651,051 626,562 1,943,112 11,024,077 7,079,551
Fund balance, December 31 254,352$ 8,096,271$ 492,062$ 1,739,222$ 10,581,907$ 7,036,451$
Total Budget
50
Y-T-D
2007 2008 2009 2010 2011 09-30-11 2012 Change from 2011
Actual Actual Actual Actual Budget Actual Request Dollar Percent
Special Projects (Fund 280):
Revenues
3551 Spec assessmt current 3,826 3,591 - - - 0.00%
3552 Spec assessmt delinquent 83 - 73 48 - 0.00%
3553 Spec assessmt penalty & interest 20 - 12 18 - 0.00%
3610 Investment income 84,076 64,034 28,276 19,322 17,000 10,000 (7,000) -41.18%
3680 Other revenue - 126 - - - 0.00%
3972 Transfers in 12,563 - - - - 0.00%
Total revenue 100,568 67,751 28,361 19,388 17,000 - 10,000 (7,000) -41.18%
Operating expenses
Operations (4180):
Contractual services
3030 Other professional services 18,481 22,260 1,116 11,475 10,000 7,031 - (10,000) -100.00%
5130 Repairs; Equipment 313 140 - - - - - 0.00%
Total contractual services 18,794 22,400 1,116 11,475 10,000 7,031 - (10,000) -100.00%
Capital
7030 Capital equipment 651 27,092 84,949 - 90,000 34,144 65,000 (25,000) -27.78%
7050 Construction 94,804 31,379 6,977 18,830 342,000 28,536 404,000 62,000 18.13%
Total capital outlays 95,455 58,471 91,926 18,830 432,000 62,680 469,000 37,000 8.56%
Other
9900 Transfer out - 90,000 - - 90,000 90,000 - 0.00%
Total other - 90,000 - - 90,000 - 90,000 - 0.00%
Total expenses 114,249 170,871 93,042 30,306 532,000 69,711 559,000 27,000 5.08%
Net change in fund balance (13,681) (103,120) (64,681) (10,917) (515,000) (69,711) (549,000) (34,000) 6.60%
Fund balance, beginning year 1,510,752 1,497,071 1,393,951 1,329,270 1,318,352 1,318,352 803,352 (515,000) -39.06%
Fund balance, end of year 1,497,071 1,393,951 1,329,270 1,318,352 803,352 1,248,641 254,352 (549,000) -68.34%
2012 Budget Summary
51
Fund: 280 Special Projects Revenues
Account Description 2009 2010 2011 2012 Description
3610 Investment income 45,000 30,000 17,000 Estimated interest earnings at 2.00%.
45,000 30,000 17,000 -
Fund: 280 Department: 4180 Expenditures
3030 Other professional services - - - - Ramsey County fee for spec. ass. adm.
- - - - PW Building Evaluation
- - 10,000 - Scanning of microfilm to laserfiche
- - - - 1st and 2nd phase of Laserfiche Imaging conversion over 2 years
- - 10,000 -
7030 Capital, equipment 7,500 - - - Purchase copier (1) lease expires in July 2009
25,000 25,000 25,000 - Community center furniture replacement
- - 65,000 - Alternative Power Supply Project (City Hall generator for EOC)
- - - - Laserfiche software upgrade (one-time pay to Roseville)
32,500 25,000 90,000 -
7050 Construction - 30,000 - 30,000 Community center parking lot improvements
- 15,000 - - Lambert Park building (preconstruction)(50% in Park Dedication)
- - 13,000 - City Hall irigation project (postponed from 08)
- - 30,000 - Edgewood Dr. boulevard project (carryover from 2007)
104,000 104,000 104,000 104,000 Pathway construction program
50,000 50,000 - - Emergency power Supply PW generator city hall wiring (carryover from 09)
65,000 65,000 - 65,000 Community center energy improvements (carryover from 09)
120,000 120,000 - - PW shop intermediate rehabilitation (carryover from 09)
40,000 40,000 20,000 20,000 Pathway rehabilitation program
6,500 - - - Community Center Copier (lease expires 5/09)
- - - 250,000 Community Center roof replacement/repair
- - 175,000 - City Hall roof replacement/repair
385,500 424,000 342,000 469,000
9900 Transfer to General Fund 90,000 90,000 90,000 90,000
Transfer to Comm. Center Fund - - - -
90,000 90,000 90,000 90,000
52
Y-T-D
2008 2009 2010 2011 09-30-11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
Street Improvement (Fund 285):
Revenues
3101 Property taxes - - 279,586 300,000 136,040 300,000 - 0.00%
3180 Franchise fee 283,796 235,002 225,581 249,900 150,988 253,000 3,100 1.24%
3319 Other federal grants - 463,438 40,761 630,000 (630,000) -100.00%
3352 MSA street construction - 1,157,743 425,115 383,000 325,787 383,000 - 0.00%
3359 Other state grants - - - 495,000 195,000 (300,000) -60.61%
3360 Other county grant - 216,973 - - 0.00%
3550 Spec assessmt prepayment - 209,822 20,127 11,019 20,000 20,000 #DIV/0!
3610 Investment income 122,387 106,092 82,329 100,000 72,500 (27,500) -27.50%
3680 Other revenue 14,130 42,369 25,377 - 45,089 - - 0.00%
3972 Transfer from other funds 100,000 280,000 300,000 300,000 300,000 - 0.00%
Total revenue 520,313 2,711,439 1,398,876 2,457,900 668,923 1,523,500 (934,400) -38.02%
Operating expenses
Operations (4470):
Contractual services
3030 Other professional services 144,953 99,508 259 - - - 0.00%
3810 Special assessment refunds 110,391 3,818 - - - - 0.00%
5130 Repair - - - - - - 0.00%
Total contractual services 255,344 103,326 259 - - - - 0.00%
Capital
7050 Construction 325,219 572,522 160,424 767,000 8,578 1,078,280 311,280 40.58%
Total capital outlays 325,219 572,522 160,424 767,000 8,578 1,078,280 311,280 40.58%
Total expenses 580,563 675,848 160,683 767,000 8,578 1,078,280 311,280 40.58%
Net change in fund balance (60,250) 2,035,591 1,238,193 1,690,900 660,345 445,220 (1,245,680) -73.67%
Fund balance, beginning year 2,746,616 2,686,366 4,721,957 5,960,151 5,960,151 7,651,051 1,690,900 28.37%
Fund balance, end of year 2,686,366$ 4,721,957$ 5,960,151$ 7,651,051$ 6,620,496$ 8,096,271$ 445,220$ 5.82%
2012 Budget Summary
53
Fund: 285 Street Improvement Revenues
Account Description 2009 2010 2011 2012 Description
3101 Property taxes - 300,000 300,000 300,000 General tax levy for streets
- 300,000 300,000 300,000
3180 Franchise fee 290,625 287,000 249,900 253,000 Half of the 3.87% franchase fee on gas & electric utilities
290,625 287,000 249,900 253,000
3319 Other federal grants 525,000 - - - Federal trails grant
- - 630,000 630,000 Federal safety grant for Cty H intersection(2011)
525,000 - 630,000 630,000
3352 MSA Street Construction 1,374,090 365,000 383,000 383,000 State aid funds
1,374,090 365,000 383,000 383,000
3359 Other state grants - - 300,000 300,000 MNDOT Coop Agreement (2011 H and Cty 10 intersection project)
- - 70,000 70,000 Ramsey Cty CSAH (2010 H and Cty 10 intersection project)
- - 125,000 125,000 CR 10 Turnback Funds (2010 H and Cty 10 intersection project)
- - 495,000 495,000
3610 Investment income 93,750 72,500 100,000 72,500 Estimated interest earnings at 1.5%.
93,750 72,500 100,000 72,500
3972 Transfer in 280,000 300,000 300,000 300,000 Transfers from utility funds (water 100,000, sewer 160,000, storm 40,000)
280,000 300,000 300,000 300,000
Fund: 285 Department: 4470 Expenditures
3030 Other professional services - - - -
- - - -
7050 Construction 900,000 - - - 2009/2010 Project ($4,313,019 in TIF funds)
- 547,000 - - 2010 Area B&C Street & Utility project
- - - - 2011 Area D Street & Utility project
- - 417,000 - 2012 Area E Street & Utility project
- - - 778,280 2013 Area F Street & Utility project
300,000 - 350,000 300,000 Mill and overlay (Mustang Drive)(move to 2011)(50,000 in utility funds)
- - - - Cty Rd H intersection safety improvements (move to 2012)
525,000 - - - Trail segments 1 - 5
- - - - Traffic signal @ H and Silver Lake Road (what does council want to do?)
- - - - Seal coat project
1,725,000 547,000 767,000 1,078,280
54
Y-T-D
2008 2009 2010 2011 09-30-11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
Park Dedication (Fund 251):
Revenues
3610 Investment income 37,535 20,320 13,353 15,000 10,000 (5,000) -33.33%
3650 Park donations 1,000 2,664 39,969 - 0.00%
3652 Park dedication fees 18,239 1,800 - 6,000 6,000 - 0.00%
Total revenue 56,774 24,784 53,322 21,000 - 16,000 (5,000) -23.81%
Operating expenses
Operations (4470):
Materials & supplies
1600 Supplies, operating 549 - - - - - - 0.00%
Total materials & supplies 549 - - - - - - 0.00%
Contractual services
3030 Other professional services - - 615 - - - - 0.00%
Total contractual services - - 615 - - - - 0.00%
Capital
7050 Construction 45,322 5,986 46,811 310,000 26,719 150,500 (159,500) -51.45%
Total capital outlays 45,322 5,986 46,811 310,000 26,719 150,500 (159,500) -51.45%
Total expenses 45,871 5,986 47,426 310,000 26,719 150,500 (159,500) -51.45%
Net change in fund balance 10,903 18,798 5,896 (289,000) (26,719) (134,500) 154,500 -53.46%
Fund balance, beginning year 879,965 890,868 909,666 915,562 915,562 626,562 (289,000) -31.57%
Fund balance, end of year 890,868$ 909,666$ 915,562$ 626,562$ 888,843$ 492,062$ (134,500)$ -21.47%
2012 Budget Summary
55
Fund: 251 Park Dedication Fund Revenues
Account Description 2009 2010 2011 2012 Description
3610 Investment income 30,000 20,000 15,000 10,000 Estimated interest earnings at 1.50%.
30,000 20,000 15,000 10,000
3652 Park dedication fees 6,000 6,000 6,000 6,000 Developer payments
6,000 6,000 6,000 6,000
Fund: 251 Department: 4470 Expenditures
7050 Construction - 15,000 - - Lambert Park building (preconstruction)(50% in Spec. Projects Fund)
- - 260,000 - Lambert Park building (construction)(does Council want to split?)
- - 40,000 - Relocate Lambert ballfield to accomodate reconfigured building site.
- - 10,000 - Hillview hockey rink expansion and grading
- - - 4,500 Reconstruct irrigation controls at Silverview Park
- - - 100,000 Replace playground equipment - Silverview Park
- - - 13,000 PIP - Security lighting Imp. - Greenfield & Groveland Parks
- - - 8,000 PIP - Replace playground media - City Hall Park
- 25,000 - - Groveland & Hillview drainage and irrigation improvements
8,000 - - - Playground media
25,000 25,000 - 25,000 Park Improvement Program (PIP)
20,000 - - - Groveland & Hillview baseball field rehab project (carryover Groveland)
10,000 - - - Groveland baseball field backstop (carryover to 2009)
32,000 - - - Hillview Parking Area
20,000 - - - Greenfield Park open space
115,000 65,000 310,000 150,500
56
2012 Budget Summary
Y-T-D
2008 2009 2010 2011 09-30-11 2012 Change from 2011
Actual Actual Actual Budget Actual Request Dollar Percent
Vehicle & Equipment (Fund 640):
Revenues
3610 Investment income - - - - - - 0.00%
3972 Transfers in - General fund 175,000 175,000 50,000 50,000 75,000 25,000 50.00%
3972 Transfers in - Water Fund 20,000 20,000 20,000 20,000 58,000 38,000 190.00%
3972 Transfers in - Sewer Fund 36,000 36,000 36,000 36,000 36,000 - 0.00%
3972 Transfers in - Storm Water Fund 6,000 6,000 16,000 16,000 16,000 - 0.00%
Total revenue 237,000 237,000 122,000 122,000 - 185,000 63,000 51.64%
Operating expenses
Operations (4160):
Contractual services 0.00%
3030 Other professional services - - - - - - - 0.00%
Total contractual services - - - - - - - 0.00%
Other
9900 Transfer out - General Fund 117,250 44,000 13,319 65,600 (65,600) -100.00%
9900 Transfer out - Water Fund - - - - 289,000 289,000 #DIV/0!
9900 Transfer out - Sewer Fund - - - 330,000 (330,000) -100.00%
9900 Transfer out - Storm Water Fund - - - 40,000 (40,000) -100.00%
Total other 117,250 44,000 13,319 435,600 - 289,000 (146,600) -33.65%
Capital
7010 Buildings - - - - - - - 0.00%
7030 Equipment - - - - - 70,890 70,890 #DIV/0!
7040 Vehicles - - - - - 29,000 29,000 #DIV/0!
7050 Construction - - - - - - - 0.00%
Total capital outlays - - - - - 99,890 99,890 #DIV/0!
Total expenses 117,250 44,000 13,319 435,600 - 388,890 (46,710) -10.72%
Net change in fund balance 119,750 193,000 108,681 (313,600) - (203,890) 109,710 -34.98%
Fund balance, beginning year 1,835,281 1,955,031 2,148,031 2,256,712 2,256,712 1,943,112 (313,600) -13.90%
Fund balance, end of year 1,955,031 2,148,031 2,256,712 1,943,112 2,256,712 1,739,222 (203,890) -10.49%
57
Fund: 640 Vehicle & Equipment Fund Revenues
Account Description 2009 2010 2011 2012 Description
3610 Interest income - - - - Estimated interest earnings (moved to general fund per council 08)
- - - -
3961 Transfers in 175,000 50,000 75,000 75,000 From General Fund
20,000 20,000 58,000 58,000 From Water Fund
36,000 36,000 36,000 36,000 From Sanitary Sewer Fund
16,000 16,000 16,000 16,000 From Storm Water Fund
247,000 122,000 185,000 185,000
Fund: 640 Department: 4160 Operations
9900 Transfers out 25,000 25,000 23,000 23,000 11 computers, software and network hardware reduce from $25,000.
68,500 40,600 30,200 29,000 1 vehicle $29,000, radar $1,200, light bar $2,000, digital equip. $3,000
- - 22,894 11,340 Fire equipment per SBM
32,000 - 66,000 - Parks Pick-up $36,000, wood chipper $24,000, pick-up plow $6,000
- - 140,000 - PW plow truck
40,000 - 45,000 - PW boom truck
- - 6,000 - Plow for pick-up
- - 289,000 289,000 Water Tower major maintenance
- - - - Sewer generator - trailer mounted
330,000 330,000 300,000 - Sewer - Vactor
40,000 40,000 40,000 - Storm Water - truck (carryover from 2007)
535,500 435,600 962,094 352,340
58
2008 2009 2010 2011 Y-T-D 2012 Change from 2011
Actual Actual Actual Budget 09/30/10 Request Dollar Percent
GO Improvement Bonds of 2004A Debt Service (Fund 505):
Revenues
3101 Property taxes 186,903 186,427 178,567 190,553 98,351 190,892 339 0.18%
3550 Spec assess prepayments - - - - - - 0.00%
3551 Spec assess current 127,575 38,326 36,916 25,652 17,682 25,652 - 0.00%
3552 Spec assess delinquent - 1,041 - - - - 0.00%
3553 Spec assess penalty & int - 282 - - - - 0.00%
3610 Investment income 11,564 6,822 3,433 8,750 3,000 (5,750) -65.71%
Total revenue 326,042 232,898 218,917 224,955 116,033 219,544 (5,411) -2.41%
Operating expenses (4650):
Contractual services
8010 Debt, principal 215,000 215,000 220,000 225,000 225,000 230,000 5,000 2.22%
8020 Debt, interest 57,239 51,058 44,423 37,300 37,300 29,563 (7,737) -20.74%
8030 Paying agent 431 431 431 475 431 475 - 0.00%
8040 Continuing disclosure 982 1,138 1,164 1,500 983 1,500 - 0.00%
Total contractual services 273,652 267,627 266,018 264,275 263,714 261,538 (2,737) -1.04%
Net change in fund balance 52,390 (34,729) (47,101) (39,320) (147,681) (41,994) (2,674) 6.80%
Fund balance, beginning year 407,428 459,818 425,089 377,988 377,988 338,668 (39,320) -10.40%
Fund balance, end of year 459,818 425,089 377,988 338,668 230,307 296,674 (41,994) -12.40%
2012 Budget Summary
59
Item No: 3
Meeting Date: October 3, 2011
Type of Business: Work Session
Administrator Review: _____
City of Mounds View Staff Report
To: Honorable Mayor and City Council
From: Mark Beer, Finance Director
Item Title/Subject: Other Funds Budgets for 2012
Attached are the budgets for the Other Funds (Special Revenue, Debt Service, Capital Projects,
and Enterprise) for your consideration.
The Council has had several opportunities to review the General Fund and will again in
November or December. The Special Revenue, Debt Service, Capital Projects, and Enterprise
funds have not been reviewed.
Enterprise Funds
The City continues to have low utility rates based on rate studies the City participates in and
staff has shared with the City Council. Staff advocates a policy of nominal increases to maintain
the infrastructure rather than larger increases with greater intervals between increases.
The Water fund anticipates an increase in base user charges by a dime which will add about $8
per year for the average home. The increase is based on significant costs associated with the
planned maintenance of the water tower in 2012 and a number of capital related items from the
five year financial plan. The five year plan projects the need for a dime increase in 2013 and
2014 and nickel increases in the base rates for 2015 and 2016.
The Sewer fund anticipates a 4% increase in user charges which will add $10 to a residential
utility bill. Met Council Environmental Services (MCES) waste charges will not increase in 2012
but have significantly increased in the past and we have not kept pace with the increases, future
increases of 4% for 2013 thru 2016 will help stabilize the sewer fund.
The Storm Water fund and the Street Light funds do not require increases in 2012. The Storm
Water fund does not anticipate a rate increase for 2013 thru 2016. The City will be exploring the
possibility of slip lining some of the storm sewers to extend their lives in the coming years and
that could impact future rates. The Street Light Fund anticipates a $.25 per quarter increase in
2013 and 2016 to offset higher electrical and trailway lighting and maintenance costs.
Capital Projects Funds
There are a number of capital projects that are anticipated to occur in 2012, the most prominent
are the street project for Area E, Mustang Drive stormwater and mill and overlay project, roof
repairs for the Community Center and Well #1 buildings, Community Center HVAC
improvements, replace playground equipment at Silverview Park, and possibly some trailway
improvements.
Special Revenue Funds
Most of the special revenue funds are small and the budgets are driven by the specific revenues
received. The most note worthy are the Cable, Forfeiture, EDA, Community Center, TIF 1, 2, 3,
and TIF 5 as they have the most significant activity.
Staff would recommend that Council review the funds and make any recommendations that they
may have.
Respectfully Submitted,
Mark Beer, Finance Director