Loading...
5.1 ERMUSR 11-13-2018Elk River Municipal Utilities UTILITIES COMMISSION MEETING TO: FROM: ERMU Commission Theresa Slominski — Finance & Office Manager MEETING DATE: AGENDA ITEM NUMBER: November 13, 2018 5.1 SUBJECT: Financial Report — September 2018 ACTION REQUESTED: Receive the September 2018 Financial Report DISCUSSION: With the change in billing cycles, the revenue comparisons from the prior year will be skewed as they will not be comparing the same billing time frames. Also, budgeted numbers were not adjusted for the billing cycle change, as the data did not exist to estimate this impact. Please keep this in mind as we review the financials throughout 2018. Electric P&L September's electric kWh sales are up from the prior year, 3%. For further breakdown: • Residential usage is up 6% • Small Commercial usage is down 6% • Large Commercial usage is up 2% Electric Operating Revenue for September was $3,551,685, 4% ahead of the prior year and less than 1 % above budget. 2017 included the pro -forma adjustment to show the demand adjustment credit being funded through reserves. Without this adjustment in 2017, September revenue would be 6% ahead of the prior year and 11 % ahead of prior YTD. Other Revenue of $182,978 is ahead of the prior year by 13%, and 18% above prior YTD. Other Revenue is also 34% above YTD budget which is largely due to the Contribution from the City of Otsego for its street lights. Overall, Total Revenues of $3,734,663 are ahead of prior year by 5% and ahead of prior YTD by 10%. YTD Total Revenues are ahead of budget by 7%. Purchased Power of $2,086,980 is above the prior year by 1%, but below budget by 6%. YTD costs are more than prior year by 6%, and are above YTD budget by 4%. Administrative Expenses of $357,826 are more than prior year by 55% which is mainly driven by bond issuance cost, and 23% over budget. The bond costs are just a timing issue with budgeting, as YTD costs are more than prior year by 3%, but are under budget by 10%. Page 1 of 2 45 General Expenses of $15,845 are 64% under budget, and are 30% under budget YTD. For expenses, in total they are 5% more than the prior year, and 6% more than prior YTD, and are over budget YTD by 1 %. For September 2018, the Electric Department has a Net Profit of $743,003 and YTD Net Profit of $2,090,204. This is above the budgeted monthly Net Profit of $585,906, as well as ahead of the prior year monthly Net Profit of $726,935, and is significantly ahead of prior YTD Net Profit of $875,082. Water P&L September gallons of water sold are up 4% from the prior year. For further breakdown: • Residential use up 12% • Commercial use down 2% Water Operating Revenue for September was $323,630, 6% ahead of prior year and ahead of YTD budget by 15%. Other Revenues of $85,699 are behind the prior year by 3%, and behind prior YTD by 10%. The main drivers causing the prior YTD variance are Contributions from Developers and Connection Fees. Other Revenues are ahead of YTD budget by 200%. Overall, Total Revenues of $409,329 are ahead of the prior year by 4%, and ahead of prior YTD by 4% with Water Sales being the driving force. YTD Total Revenues are ahead of budget by 42%. Expenses are more than the prior year by 10%, but are under YTD budget by 9%. For September 2018, the Water Department has a Net Profit of $183,588, which is slightly behind last year's Net Profit of $189,160. September YTD Net Profit is $795,366, which is ahead of the prior YTD Net Profit of $762,606, and is significantly ahead of the budgeted YTD Net Loss of $232,564. ATTACHMENTS: • Balance Sheet 9.2018 • Summary Electric Statement of Revenues, Expenses and Changes in Net Position 9.2018 • Summary Water Statement of Revenues, Expenses and Changes in Net Position 9.2018 • Graphs Prior Year and YTD 2018 • Detailed Electric Statement of Revenues, Expenses and Changes in Net Position 9.2018 • Detailed Water Statement of Revenues, Expenses and Changes in Net Position 9.2018 Page 2 of 2 0 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA COMBINED BALANCE SHEET FOR PERIOD ENDING SEPTEMBER 2018 ASSETS CURRENT ASSETS CASH ACCOUNTS RECEIVABLE INVENTORIES PREPAID ITEMS CONSTRUCTION IN PROGRESS TOTAL CURRENT ASSETS RESTRICTED ASSETS BOND RESERVE FUND EMERGENCY RESERVE FUND UNRESTRICTED RESERVE FUND TOTAL RESTRICTED ASSETS FIXED ASSETS PRODUCTION LTG PROJECT TRANSMISSION DISTRIBUTION GENERAL FIXED ASSETS (COST) LESS ACCUMULATED DEPRECIATION TOTAL FIXED ASSETS, NET INTANGIBLE ASSETS POWER AGENCY MEMBERSHIP BUY -IN LOSS OF REVENUE INTANGIBLE LESS ACCUMULATED AMORTIZATION TOTAL INTANGIBLE ASSETS, NET OTHER ASSETS AND DEFERRED OUTFLOWS TOTAL ASSETS LIABILITIES AND FUND EQUITY CURRENT LIABILITIES ACCOUNTSPAYABLE SALARIES AND BENEFITS PAYABLE DUE TO CITY DUE TO OTHER FUNDS NOTES PAYABLE -CURRENT PORTION BONDS PAYABLE -CURRENT PORTION UNEARNED REVENUE TOTAL CURRENT LIABILITIES LONG TERM LIABILITIES LFG PROJECT DUE TO COUNTY BONDS PAYABLE, LESS CURRENT PORTION PENSION LIABILITIES TOTAL LONG TERM LIABILITIES TOTAL LIABILITIES DEFERRED INFLOWS OF RESOURCES FUND EQUITY CAPITAL ACCOUNT CONST COST CONTRIBUTED CAPITAL RETAINED EARNINGS NET INCOME (LOSS) (THROUGH PREVIOUS MONTH) TOTAL FUND EQUITY TOTAL LIABILITIES & FUND EQUITY ELECTRIC 10,058,875 2,803,787 701,607 t06,073 1,115,998 14,786,339 1,261,359 2,619,879 38,884 3,920,122 6457285 3,801,373 2.3017867 38,648,176 10,106,791 55,503,491 (27,230,356) 28,273,135 21,101,819 981,883 0 22,083,701 911.386 69,974,682 3,687,610 540,463 740,612 0 49,563 0 2,568 5,020,815 820,608 0 22,008,748 2,890,601 25,719,957 30,740,772 651,486 1,261,359 0 35,229,923 2,090,205 38,581,486 69,973,744 1S9:V 1181.N 4,975,252 556,691 13,476 13,657 290,189 5,849,264 0 1,179,308 113,824 1,293,132 13,528,683 0 0 22,740,586 1,019,980 37,289,250 (17,326,738) 19,962,512 0 0 0 0 177,225 27,282,132 206,844 108,140 2,227 0 0 0 152,582 469,793 0 0 1,134,662 556,723 1,691,385 2,161,177 125,475 0 0 24,201,051 795,366 24,996,417 27,283,070 47 1 N , v i A r 7 O M 0 M V CO v� Vl b b N h O� V M O Vl M N b N O ^ N Q 7 M O h ti M M b W VNi N l� VI N M O b O 1� W Q. M 14 b h^ Q` N O vl n VM1 O N M r W N O M r r V O b V b b IN b b vl [O IN DA NNIN V N O^ N N W V] lO V ^ •^ C O h N� �O � � r+ � 0 � h V � � � � V � O O � O^ O^ ^ vl � � � � N �l M M^ Q z D\ C •. P V O T O r h W b b b l� O G� O d\ r O N W r r Vl Vl .-. r W N lO N 'O 01 [� M vl co Iq cc W W W Q W ^� vl M vl O N W N M b O O� b N h M f� r D17 \ D\ M b b .� l� Cl W a0 w O a Q\ O v MM b Inc ' W N W F L w C R L a F ay. on U c U m u e i y O L 00 o K c a v y o a W a- i c a [U c c 0 X � a Q u i L, .e¢. {J U K' Q a Q y W 3 W N 6 m m2 A x a o a o F O W 8> w y F 0 aQ v N o �o.O.aFQ�QSrnOUQV �00 LUC u W � G r a ao o w o �2I�2 U Q 7 � [a F N >' W M W r V Vl �D V N M O W Vl �O C r_ O W IO Vl N N r Q\ rV r N a.o�0oo N _ m n V S tp V M S N V T vl N N M [n Vl rl d' V r M W N M a O W a r O o0 N v� 01 N N r C N L\ M V M O1 W r M V VI VI M R '+ VI N OWN' ■■N O IOIN O O C 9 70.0 65.0 60.0 3 55.0 0 50.0 c y 45.0 a 4&0 35.0 Elk River Municipal Utilities Monthly Electrical Demand i i i i i 30.0 act act ��r Q�J a� Jae a�� Jet ,eea ,ear ,eea ,oea )aa° Q ego 5aQ 0 Month -+-2017--o-2018 Elk River Municipal Utilities Monthly Energy Purchases 34,000 29,000 3 `` `- '� �` ' 24,000 N A L V a 19,000 T D) N C w 14,000 PQ�. �aq )J9 00ac �& aaJa� �`Ja� �a``r )Jae JAJew e�a�a` P 6 0 �e lie boa Oao Month --o.--2017 ---2018 50 40,000 35,000 x 3 30,000 f c 0 25,000 J U w 20,000 W 15,000 Elk River Municipal Utilities Monthly Total Electric Load I 10,000 ,acee6 e�`Jec1 40G* Q $4,500,000 $4,000,000 $3,500,000 m $3,000,000 0 0 m $2,500,000 m y $2,000,000 $1,500,000 $1,000,000 P �` � PJ9 ti0F e\o ,eF oeF Month 9eQ O r\o Oe -+-2017 f2018 Elk River Municipal Utilities Monthly Electric Sales i i i i i►---♦ i oe Month c�eQ �o Oe -+-2017 f2018 51 Elk River Municipal Utilities Monthly Residential, Commercial & Industrial Loads 25,000 20,000 15,000 x 3 5 10,000 .N 9 W J 5,000 e`er PQ�. �e� �J�� acJeel �`JeA I< ,Jce JAJeti e�,oee P C G`oeet yeQN �o� Oeo Month —t-2017 Residential —*-2018 Residential—i--2017 Commercial --)(--2018 Commercial —.W--2017 Industrial ——20181ndustrial ,e Elk River Municipal Utilities Monthly Residential, Commercial & Industrial Sales $2,500,000 $2,000,000 `m $1,500,000 0 0 c a $1,000,000 m $500,000 $0 PJle lees 100 ,e�'10 Q MonthCei --*--2017 Residential t2018 Residential—f-2017 Commercial —►(-2018 Commercial--X--2017 Industrial t 2018 Industrial i 52 Elk River Municipal Utilities Monthly Water Pumpage 1 ao i 120 m 0 100 80 60 a40 %--- 20 0 P�`\ Month -t-2017 -m-2018 Elk River Municipal Utilities Peak Day Pumpage 6 --- 5 � 4 C O 3 � C � i N 2 d o. 1 0 �e� sec peg �e� ecc 1c�o F ce6 Fc P e9 Oa?Om Month -+-2017-a-2018 53 Elk River Municipal Utilities Monthly Water Sales 120 100 i c 80 o 60 ` v � 40 20 0 'IQ �tio10 e�,Q 1< P 9eQ` O boa Qea Month -+-2017 -*-2018 $450,000 $400,000 $350,000 $300,000 0 $250,000 c $200,000 fa $150,000 $100,000 $50,000 $0 Elk River Municipal Utilities Monthly Water Sales )a°Jed e�`Jei �a�r PQi• �e9 ,J�e �J�� PJAJyti 0 e��et G�1 e��e e�'ec �e11 Month -+-2017 t2018 54 r ❑ F N > x w z O w NF o a H � Q z a N 0. ¢a U G l/i CJ ^QC.7 m wa^ c4 p; W W V N o �awz� �Q a > N W O w w O w z =� � F W a F Q F ^ O vl M m � �D vl O M Vl N M M^ 01 S O P b b P O O M M M O1 b r N V Vi O r P GO 01 N N O O b N I r T O� V V � � Wn r -+ M M M W V N V O lO M r W O� oo r oo a r N b Q\ V C O O N r ^ r O1 b <t : Vl N W r M b r r O W 'cf V1 O O O� M r O r r LO + N r M N M O� M N V1 CO vl O M M v1 V1 O O ^ /1 N li W M N r M M `l:� N N M N T W T ^ N 01 M N ^ ^ M L ❑ Y_ e x°zo a a a Q Q Q W U W d _ .N. .M. V V V V �oxa a V V y V G w a o � ❑ d ❑ � W 3 h F" � 'c 'c ❑ Q U wF U O W¢ °0 v, 2 Q w� x U W O v�7 o cG '�' P7 ww O L � •a p o .. x 2❑.� ZO ZO a m F u U E" z J' F vwi U c rii x W U' Q z y N w ti `e � v ❑ v¢i vdi vQi vai vai v¢i � v¢i Q � rn q � 2 U U U U U U U 00 U -d V C O x ❑ a (7 ❑ O N , r 7 O N N V V O O C• Q� F Q N Val ^ � T 1� Q 7 N M b M O W O M 1� Vl r V1 N l� N r O M O W O O O V1 b \O M N V1 O N M W c0 Vl a V V O Vl b Vl VI O1 O� W N Ol M M Vl M V M O ti Q O NO vl h [� l� U 01 .� W r N W W ti M l00 l00 b rO z �w W o a F, oh o 0 0 0 0 00 00 0 0 0 0 0 0 0 0 0 � b b r r M M O N vl O 'Y V � N n h W WHO O L y > L a L y L A W a o e ov c a c S F o m a s e b r � O c F it1 ti O L 1 a a � W ',�' k• O U C7 u L zz > a s z > dd w z a o w z z z F x O F a a. 0 0 o L w w F4 rii O > F c W E. a f Z C] y > WU a O w W z F F F 0. U z 0 au W v � o v c � o v y r v a t� a � a � v � v r v � v � v o v v v v v O c u a c v v a a c U � `o F W ti z N W a o N O qF 3 Noi W ¢m Far-FU� ]O�w -�w¢a W ca �>kz ce�ww >xWo xw�W �Q W ; ON > O w w v� z W =� � of w H a W F oie .m N V1 r r vt O N vl M b^ P V O O O M^ O Ql I .-. M .. vl P OJ N N b M b 0� h l0 lV I� N h W P P O N N W r M b O l0 P P l� P b V r vt W b b W V V r W M h N W P P N P O M Vl ^ N r r V b N 0 Cl 13 b O O r O a P P O N O O M O o Ni a o 0 0 0 o rn h o vl Vl M N M vi O l� vl vl N O W O b r h n N O vl N N N� M N r M r Vl N dll� w w Z Z ,j It `�' W RS 0. 0.' m 3 F w 0 a m c¢7 o o i�� a¢ w h H cC O O O o z E• y e ¢ ti O c� Wv, q c� a Q W 'W F., W U F W W W a q Q z .�., N O q ',Z W W o. C4 F" OF� F V V d' a V V VNi Vl Vl 0 0 0 0 0 4 �n 'E V VI h n h V1 h V1 a �n Vl V1 VI V1 C �n r VI V1 Vl V1 n VI n h a o � N ; 7 A r � O Q Q M U Vl O� O� T V b M V W U Ol V1 O Vl Vl lO �� m M of r- r V [li m b O m b O O �--� M O .. W 1 01 D\ M N^ M O1 O1 O W N W OVl vl O ll N �n ^ O Vl U 'C (J Q (7 N N O� N Vl Oi V5 n CO M n M N V 01 m m N M N 04 w W _ l- N V V^ 01 r V O r N w dw r- VI O O� O O r N M 1� �� r M W C W z U O H W W IUD U w U G N F z U! 6 V 2 z o zz Ll c4 U O cC Q W Cl Z Z 'a X F^ vFi a"i O O O 7 w U w w W W W W 0 0 C. W 0. .^�. H H e O O O O O O O F O 0 0 0¢ 04 K O O �, o H W W W W W W Q W W W W H Q U W W Q z¢ F o c C a a H F F H F F F U FU, tU- tU-, [U-, '� W W H F U F O y N N M M in r 7, N .N -+ vl --N M vl ❑ '+ F Y .+ vl .-" N c m m b vi m vi m m m m m m m is oo W o0 00 00 00 y O O O O O O O O O O O O O O O O O O O 'U rn rn rn rn a� rn rn a rn o. rn a. o. rn a. rn rn rn v rn a a a c V Y W O Q } N (Yl r N o0 h N N vl M M O E N M b o^ o o a rn rn N M � N O O M O O O O W — O O O O O b r O O O r vl O O U� O N n M r Gl r N V V N— V O b O O O 'I1 N O M N O O r M M r W N G1 O� r N S O� oo N N M O O W O N b O N I O h M C T N. — W 7b b h O a 0 O M O d' O iD 0o M Y O b oo a m M h r N v� V1 N O M b vl N N Vl G1 O1 O� N N r O M I! O O b M O N M M Vl b W N N Vl C 00 0 0 0 00 - o 0 0 0 0 0 0 0 0 0 0 0 o O o o a o vi a m a o N M o h r" 0 0 0 o a: b vi N M r P N N— r P a O O vl O O M vl O O r a Q. O O O P W C O N v h LO N V V N M V M W r O r M W l0 O V vl r M vl vl M V r O N r �O M V l0 M N O� O N vl M b b vl M V lO vl M N N V V r � O O W d' U N Vl b b N b W Vl l� 01 a O O h b UT M Vl Vl N ^ it N V M �n N M M W W N N O Q ^ •� r m m -- rn N N W H F } ^ o0 1- r O\ 13 01 h O a N N 'nZj O `W w Q x a w A ce 4 Q Q F z O W° O U Q z j° y .tOL. X� z W z a W U o F' F' O F G W F r � W W Q Q�� W Q 3 z z q° a O O O O O m a N N N N N N N N OM y O H N O N rn rn a rn s rn W rn a. a. a s a rn a rn O ^ G L c W O I r q O w m r � z ow N [r w O Q F R w � 9 N [A aQxm ozQ w ra Q (]y aaw >x�'o awzW �o w �r >� 0 w W O � � m O F w Q F M M M M O 01 O�1 V O W N r N O O �O �O �D l0 r °� 01 C' O �-• r ^ r-• ry � V' O O O O VI l0 M M M M r V l0 VI �O V V V d' V N N r M O vl vl N r N N N N r r N N ^ M M M M h h O O O O O� O O 00 I~ I~ IN � la � ONi m IOMi lo0 N N N N O O O O O O O O O O h O O O O r N N O O O O O O O O O O O O 01 O ^ O O O O N N O N N N N M N N N N P R M M y a UO w u w a o a ww 3 > 9 o f U 3 u c u � d m27. a y C N 3 ° 0 04 0 r p O Ca z --� p1 b �p .--� � -- N M N N •r � r N � V1 M ¢ 7 r r M Woc O'J V D\ In M M M Q\ Q\ 1p N N a b N N M M M N r b b M M b T W O� O vl �D N GO a b r M M N F N a M v 01 v �p z o z_ O O N C� O O O O M � U 5 F ^ Q Q W b l0 V O O� O b O lO V Vl M N V OC M N ^ a H O n TN �ww z W W x o r N w > a O ni O a W ry z c U c w a K W w e ��- � �'' n W 0 w a a O U a o zw i x a a a O x ce z o 3 a f << o04 F a F d a O a y v a a w U U d y U U U U F U F' o o F U z p a El y F F U a°i F• O O F d F d F F Q¢� W W H x N — y O Y a y o, 3 w t� N Q p N vl V1 Q� N 09 00 O In W M b� b W C N N M V IN M ^ W Q — o } m V M M W WO �D M N v) VI In O WG N W Cn N T F b v1 O N N � N r V1 V h T c0 [� r a N a C O O O V r G In Vl b DI W M r EO a W O VI .� Vl l0 V N r. V M M VI a C l O1 N N Vl M Q� b .� M 1 �✓�'yy N �_. N N . W > �O w DD 00 T O O r M O W O O GO N O M P r V vl O d' b M h vl V1 Vl a N �a � H O 04 v O a G W d a w� v�i W U w w a• Fy O ° o � vWi '� F C p�j �6 Q vw.l 02 cn U U .� z L O O o ti F 4 a o ] W C z w v Ln W W W A y z z g cG U r]i� F F W Fy c ax' tr] w W CO W O y WW c W U s F Q .'� Q F 'a 5 O C F N r 0 d Ni W M .a .� .-. Z Z) W W W I,N I, N N M N A b N �p N b N �D N 1p N ♦O N 1p N b N W o0 oa Goo m oo m � rn rn rn y rn rn rn a o. rn rn rn rn rn a rn rn rn a� rn b b N�� h N � 41 U �` 4• � T� T S S T� P� T O P� O. u R 3 N ; ' R � O ¢ l'y �Qyy v � N v 01 Q N >' � o W N F w W � 9 z O � N V M aOq� W 4 Q 9 W W a Wa �y W �O O CYi 0 0� l0 � O vMl O N z '^ W a � C w w x W a w d o z H w c7 c7 ai wy � z y ti ZO W 5 U F F QQ N N M M M M M M O O O O p O O O � a O QNi a T T T V R 3 'cY O^ O vl V I M M ^ M W O O O O M V O M ^ O M a M d vl vl O 1� O d O M d ^ vl ^ 1� r b b vi vi N V tit M O �O O O O W M O IP ^ C IO N v O O O O O O O � h T R 59 -t e