6.1.d. ERMUSR 05-12-2015 Elk River —
Municipal Utilities UTILITIES COMMISSION MEETING
TO: FROM:
Elk River Municipal Utilities Commission Wade Lovelette—Superintendent of Technical
John Dietz—Chair Services
Al Nadeau—Vice-Chair
Daryl Thompson- Trustee
MEETING DATE: AGENDA ITEM NUMBER:
May 12, 2015 6.l d
SUBJECT:
Staff Update
DISCUSSION:
• The Locating department had a total of 414 locate tickets in April; 11 of them being
emergency tickets, two cancellations, 15 meets, 378 normal tickets, one boundary survey,
and seven updated tickets. It's been a very busy spring with locates. When Richard Wagner
is not locating he's working on map book updates and the ArcView maps. He has printed
the new map books and is now in the process of having them bound.
• In April, the Security Systems Department had a total of 92 phone contacts, 11 systems
quoted, six system sales made, eight installs completed, 24 service calls and 10 personal
visits.
• Electric Technicians continue with the meter reading, power bill, substation checks, hanging
red-tags, meter read-outs, dealing with meter and off-peak issues, and delivering and
installing new meters to commercial customers. They continue to change out the three phase
meters to radio read meters and help with the monthly engine runs. They are also re-
programming three-phase meters in the field for commercial and industrial loads.
• The power plant staff did the monthly engine run on April 28th. Engines 1 and 2 ran fine.
Wheeler World, Inc. was here to finish the upgrade work to engine 3 and to run it and put it
back on line. Engines 3 and 4 both ran fine.
• Staff continues to collect data with the GPS for our ArcView maps as time permits.
ATTACHMENTS:
• Security Systems Weekly Update
• Security Systems Analysis
PYONEBED PY
Page 1 of 1 NATURE
Reliable Public
Power Provider P 0 W E 0.E D T o S E R V E
100
Elk River ----
Municipal Utilities
13069 Orono Parkway
P.O. Box 430
Elk River, MN 55330-0430
Elk River Municipal Utilities
Security System Weekly Update
(sum of weeks) (total for calendar month)
Month of Apr-15 April Weekly Totals
Number of Contacts 90 92
Number of systems quoted 11 11
Number of sales made 6 6
Number of Installs completed 8 8
Number of service calls 19 24
Personal Visits 10 10
Revenue Mar-15 $ 18,081
Expense Mar-15 $ 20,367
Margin* Mar-15 $ (2,286)
YTD Revenue Mar-15 $ 67,883
YTD Expense Mar-15 $ 51,596
YTD Margin* Mar-15 $ 16,287
*Margin calculations exclude depreciation,payroll taxes,benefits coverage and office support
101
Security Revenue and Margin 2014
Total Year
Jan Feb Mar April May June July August Sept Oct Nov Dec Budget
Revenue 29,110 28,705 20,044 20,946 23,326 24,542 21,080 23,547 23,042 24,069 21,502 22,690 **
YTD Revenue 29,110 57,815 77,859 98,805 122,131 146,674 167,754 191,301 214,343 238,412 259,914 282,604 265,000
Expense 12,292 13,237 20,940 16,508 16,354 14,136 21,308 16,670 12,898 21,556 15,469 16,761 **
YTD Expense 12,292 25,529 46,469 62,977 79,331 93,467 114,775 131,445 144,342 165,898 181,367 198,128 215,000
Margin* 16,818 15,468 -896 4,438 6,972 10,407 -228 6,877 10,145 2,513 6,033 5,929
YTD Margin* 16,818 32,286 31,391 35,829 42,801 53,207 52,979 59,856 70,001 72,514 78,547 84,476 50,000
**April 2014 results exclude correction for 40K overbilling on security services.
*Margin calculations exclude depreciation,payroll taxes,benefits coverage and office support
Security Revenue and Margin 2015
Total Year
Jan Feb Mar April May June July August Sept Oct Nov Dec Budget
Revenue 31,014 18,788 18,081
YTD Revenue 31,014 49,802 67,883 67,883 67,883 67,883 67,883 67,883 67,883 67,883 67,883 67,883 270,000
Expense 14,894 16,335 20,367
YTD Expense 14,894 31,229 51,596 51,596 51,596 51,596 51,596 51,596 51,596 51,596 51,596 51,596 215,000
Margin* 16,120 2,453 -2,286 0 0 0 0 0 0 0 0 0
YTD Margin* 16,120 18,573 16,287 16,287 16,287 16,287 16,287 16,287 16,287 16,287 16,287 16,287 55,000
*Margin calculations exclude depreciation,payroll taxes,benefits coverage and office support
102
Security Contribution in Dollars
$350,000 -
$300,000
•
$250,000 —
•
$200,000 - /
$150,000 ---
$100,000
•
$50,000
$0
2004 2dbt-� 2006„:-----2811 2008 2009 2010 2011 2012 2013 2014
-$50,000
t Revenue t Expense --t—Margin
103