2 27 12 Finance Department FY 2013 Budget PresentationFinance DeparAment
Fiscal Year 2013 Bwiget
City Council Budget Hearing
Monday, February 27, 2012
Ken TeKippe, CPA - Finance Director
Jean Nachtman, CPA - Assistant Finance Director
Rose Hoerner - Utility Billing Supervisor
City of Dubuque
Finance Department
FY 2013Budget
leTaod iaiteMiapews •
/4 igenendspeaj ApnoH •
i.uawi(ed aur-up pawuequ3 .
bu!IIi8 )!uoJPa13 .
ONI11I9 LLI1llfl elOd
Sl33f O Jd J Ifllfld 19 iNJ Ifl3
Hourly Profile for 110530878 (Gallons)
Hourly Reads On
01/10/2012
250 -
200 -
150 -
100 -
50
0
46..3
34.134.£ 23.'23.ir13
06:00 12'00 18 00
2,500 -0
2,000 -
1,500 -
1,000 -
Daily Usage for 110530878 (Gallons)
1
i
MM
500
6
5
0
5555.1
5:555 $'
45545;545�1 l
565.41
A
W6'6�
4 3
limpre
1
2012
CURRENT & FUTURE PROJECTS
FOR FINANCE
• Unqualified Audit Opinion
• Bond Issues and SRF Funding
• Evaluate Insurance Coverage
• Property & Liability
• Lead Paint & Pollution
• Financial Services Manager RFP (2012)
• Banking Services RFP (2013)
RECD DED CAPITAL
'ROJECTS
Finance Department
Capital Improvement Projects- Software Upgrades
• $20K Finance (FY'13)
• $20K Utility Billing (FY'13)
Equipment Replacements
• Van $21,000
• Safe $3,000
• 3 Payment Processing Scanners $6,000
RECO
NDED IMPROVEMENT
PACKAGES
Finance Department
• $8,142 for Overtime Wages, IPERS and
Social Security
• Certified Public Finance Officer
Certification (CPFO) through the
Government Finance Officers
Association (GFOA) $3,100
Fire
•Ambulance
Revenue
Summary
Water
•Smarter City
Project
•Water Meter
Replacement
Project
"• \er Connect
Public Works
•DMASWA
Finance
Enterprise
Departments
•Billing. Collections&
Customer Support for.
Water, Sewer, Refuse,
Stormwater , Parking
Ticket Colkction &
Tram
Legal
•Insurance Claims& Issues
•Ut'lity Bill Collection Issues
•Debt Issues
•Identity Theft Prevention
Program
�- ^rdinance Changes
Leisure
Services
•AmeriCorps
•Five Flags
Engineering
•Leases
•Assessments
•Stormwater Billing
•Sewer Connections
\r Billing
City Manager's
Office
•Budget Data
•Treasury Update
•Assistance for Debt
Issues
Housing
•CDBG Assistance
•Section 8 Support
•Bridges Programs
Health
•Assessments
•Animal Ucensing
Accounting
Building
Services
•Water Meters
•Construction
Finance
Information
Services
•IT System Support
•Check, Utility Bills
& Parking Ticket
Printing
Economic
Development
•loan Collections
/Payments
Police
•Abandoned
Vehicles
Lendlord
Association
*Communicate
Utility Billing
PoMites &
Procedures
Dubuque County
*property Owner
information
• Property Assessments
*Lions
•Property Tau
Collection
*Parking Tickets
AmenCorps
•Accounting/Repo t ng
*Grant Drawdown
• Payroll
Outreach Agencies
(S Major Agencies)
*Utility Bill
Payment
Assistance
Cost Central
intergovernmental
Association 1C0A)
•Tr•nsit Grent Support
up
S
•r Ive
Support
Dubuque Initiatives &
Subsidiaries
• Acco u n t i n g/ Re porting
•Accounts Payable
•Prepare Audit
Dubuque Metropolfan
AIe• Sclid Waite
Agency
•Accounting/Reporting
•Accounts Payable
*Payroll
•Treasury
Thank You For Your Time!!
Questions Are Welcome
City of Dubuque
FINANCE DEPARTMENT
Organizational Chart
FINANCE DIRECTOR
SECRETARY
PART THE
ASSISTANT FINANCE DIRECTOR
UTILITY BILLING SUPERVISOR
I I I 1 I I
ACCOUNTANTS PURCHASING ACCOUNT PAYROLL INTERN
2 FULLTMC COORDINATOR CLERKS SPECIALIST PART TIME
2 FULL TIME PART TIME
UTILITY
ACCOUNT
CLERK
CASHIERS
4 FULL nPE
PART TIME
SERVICE
WORKERS
1 FULL V.1E
1 PART TIME
City of Dubuque
FINANCE DEPARTMENT
Organizational Chart
FINANCE DIRECTOR
SECRETARY
PART THE
ASSISTANT FINANCE DIRECTOR
UTILITY BILLING SUPERVISOR
1 1 I 1 I
ACCOUNTANTS PURCHASING ACCOUNT PAYROLL INTERN
2 FULL TIME COORDINATOR CLERKS SPECIALIST PARTTIME
2 FULL TIME PART TINE
UTILITY
ACCOUNT
CLERK
CASHIERS
4 FULL nmE
1 PART TIME
SERVICE
WORKERS
1 FULL THE
1 PART TIME
PRIOR YEAR ACCOMPLISHMENTS
• FinancePLUS Upgrade 4.0 to 4.3
• Laserfiche Journal Entries and Receipts
• Audit Services Request for Proposal Issued
PRIOR YEAR ACCOMPLISHMENTS
• Roll Out Purchase Cards City -Wide
• New Accounting Pronouncements GASB 54
• Received GFOA Certificate of Excellence in
Financial Reporting Award for FY'10 (231 "a
year)
• Compliance with Investment Policy
Certificate of
Achievement
for Excellence
in Financial
Reporting
Presented to
City of Dubuque
Iowa
For its Comprehensive Annual
Financial Report
far the Fiscal Year Fidel
June 30,2010
A Caanfiaa o(Mbimmni for &cannot in Financial
Repeating Y pnaand by de 0overment Finance ORCaa
Aaociaion ofh United SWa and Canada lo
nowmtal vain and public nOlolac wuemat
ryYmr atom cmpabmein annual 0eacini
reports (CAFRa) achieve 6o highest
nadardr in gowns accounting
and financial reporting.
President
p
Executive Director
ASSOCIATION OF PUBLIC TREASURERS
UNITED STATES AND CANADA
CE.RT /f /CATION -OF EXCELLENCE
INVESTMENT POLICY
Awarded 10
CITY OF DUBUQUE IOWA
July 2009
The rmuunent policy submitted /of feller meets the standeNS established bt
the Asysuucn d Pub /te Trcuurees a' the United States 6 (Wade
PRIOR YEAR ACCOMPLISHMENTS
Utility Billing
• Close Out Water Meter Replacement Project
• Expand Program to Inform Customers of
Subsidies Available to Assist in Paying
Utility Bills
• Age & Annual Income
• Family Size & Annual Income
• Extreme Financial Hardship
A.Y. McDonald
Unmeasured Flow Reducer (UFR)