The URL can be used to link to this page

CFPUA 7-10 2013 Board Meeting dill t £�Ti tin S, 'loll( (f ', t 1 om� i'tt )�3+ i r s Board Meeting July 1 2013 CaPeFea Stewardship Sustainabilit Service x 5 _ rr�r�/ffrrt,2it ffffft}f�'i 44445\ _.. STATEMENT OF REVENUES AND EXPENDITURES As of June 30,2013 100% of Year Lapsed Current Month Year To Date Annual Year to Date Actual % Earned Actual Budget % Earned June 30,2012 IIIIIIIIIIIIIIIIIIIII�� `' f' I1 Water Revenues 2,860,249 9.36% 29,914,992 30,552,000 97.92% 30,567,141 Wastewater Revenues 3,290,158 10.11% 32,884,322 32,551,000 101.02% 31,344,875 Interest Earnings 704 0.10% 783,486 691,300 113.34% 774,620 Other Charges for Service 234,917 10.16% 3,043,891 2,311,700 131.67% 2,578,508 Operating Grants and Contributions 2,062 0.00% 81,795 - 0.00% 222,126 System Development Charges 727,050 21.62% 3,851,687 3,363,274 114.52% 3,755,573 OPERATING REVENUES 7,115,140 10.24% 70,560,173 69,469,274 101.57% 69,242,843 Transfers from Other Funds - 0.00% 1,136,485 1,136,486 100.00% 877,108 Proceeds from Bonds 0.00% - 780,320 0.00% 1,022,622 Proceeds from Refunding Bonds 0.00% 17,870,325 17,870,325 100.00% 3,121,619 Appropriated Fund Balance - 0.00% - 568,098 0.00% - TOTAL REVENUES 7,115,140 7.92% 89,566,983 89,824,503 99.71% 74,264,192 us tr�Ut, . to/l 'Vrit,t K UVUf vm�`{t11tdVl�ttiC -kk. STATEMENT OF REVENUES AND EXPENDITURES As of June 30,2013 100%of Year Lapsed Current Month Year To Date Annual % Expended/ Year to Date Actual % Expended Actual Encumbrances Budget % Expended Encumbered June 30,2012 Authority Board 7,088 14.76% 43,579 203 48,022 90.75% 91.17% 37,374 Administration 89,713 10.38% 662,316 89,317 864,213 76.64% 86.97% 712,487 Finance/Administrative Services 149,072 7.33% 1,869,078 45,347 2,034,246 91.88% 94.11% 1,884,396 Human Resources 56,251 9.04% 519,540 16,007 622,046 83.52% 86.09% 421,445 Engineering 211,063 11.52% 1,739,254 7,068 1,832,855 94.89% 95.28% 1,647,092 Operations-Administration 115,421 10.77% 957,088 1,415 1,071,874 89.29% 89.42% 773,224 Operations-Water Treatment 386,837 5.92% 5,889,510 182,993 6,536,586 90.10% 92.90% 6,037,821 Operations-Wastewater Treatment 372,288 7.87% 4,312,550 156,187 4,731,301 91.15% 94.45% 4,329,211 Operations-Utility Services 942,881 9.80% 8,100,213 497,446 9,623,582 84.17% 89.34% 8,933,107 Environment/Safety Management 210,456 9.79% 1,988,833 41,080 2,149,933 92.51% 94.42% 1,970,051 Customer Service 258,134 9.17% 2,522,075 84,806 2,814,724 89.60% 92.62% 2,317,050 Nondepartmental 53,994 2.76% 1,799,500 3,539 1,958,805 91.87% 92.05% 1,676,470 Contingency - 0.00% - - 529,000 0.00% 0.00% - Budget Reserve - 0.00% - - 1,804,009 0.00% 0.00% - OPERATING EXPENDITURES 2,853,198 7.79% 30,403,536 1,125,408 36,621,196 83.02% 86.09% 30,739,728 Debt Service&Fees-CFPUA 6,096 0.03% 17,057,711 - 18,262,090 93.41% 93.41% 14,660,102 Debt Service-COW 3,519,020 35.95% 9,740,745 9,789,790 99.50% 99.50% 9,892,630 Debt Service-NHC (9,302) -0.73% 1,198,276 1,265,652 94.68% 94.68% 2,161,805 Payment to Refunded Bond Escrow Agent 0.00% 17,649,423 17,649,422 100.00% 100.00% 3,577,058 Transfers - 0.00% 6,236,352 6,236,353 100.00% 100.00% 10,425,123 TOTAL EXPENDITURES 6,369,012 7.09% 82,286,043 1,125,408 89,824,503 91.61% 92.86% 71,456,446 'tSoKoUVUU1'SS!t�j,i�.�� Statement of Revenues and Expenditures (Budgetary Basis) With 100% of Year Lapsed $70.6 million Operating Revenues — 101.57% of Budget 6 June 2012- $69.2 million & 99.51% of Budget $29.9 million Water Revenues — 97.92% of Budget 0 June 2012 — $30.6 million & 97.93% of Budget $32.9 million Wastewater Revenues — 101.02% of Budget 0 June 2012 - $31.3 million & 100.07% of Budget $3.9 million System Development Charges — 114.52% of Budget 0 June 2012 $3.8 million & 105.38% of Budget $30.4 million Operating Expenditures 83.02% of Budget $336,000 less than same time last year June 2012 - $30.7 million & 82.45% of Budget $7.3 million Revenues over Expenditures �. - � _ _ _ - - -_ __ -- .`.� ......... ......... ......... ......... ......... �........� ........ ....... ......... �........ ......... ......... ......... ......... ......... ........ i........ ....... ......... ......... ......... ....5.... 'tSoKoUVUU1'SS!t�j,i�.�� Construction Bid Process Update Sent survey to contractors for feedback Sent email to Purchasing Listsery to see what other utilities and municipalities processes are Revised bid documents In the process of documenting bid process 'tSoKoUVUU1'SS!t�j,i�.�� Contractor Survey Results Sent a survey on June 14th to 75 contractors who have bid with us in the past Received 14 responses to date ,g Asked them specific questions about subcontractors, qualification information and their likes and dislikes about our bidding process 'tSoogUVUU1'SS!t�j,i�.�� Contractor Survey Results : Subcontractors Majority (13-1) do not want us to require all subcontractors to be listed in the bid Majority (8-6) do not want to list subcontractors doing a certain percentage of the contract Staff has revised the bid documents to address these concerns For some contracts, CFPUA staff believes it is important to know upfront which subcontractors will be used for certain components of the project. For these contracts, the Director of Engineering (or designee) will determine which subcontractors, if any, should be listed in the bid Contractor Survey Results : Qualifications Majority (11-3) do not want us to require qualifications with the bid Majority (10-4) would like for us to request qualifications after the bid if needed Staff has revised the bid documents to address these concerns • The Contractor's Qualification Statement that had been required with all proposals has been removed, • For each RFP, the Director of Engineering (or designee) will determine if specific qualifications are needed for the project. If specific qualifications are needed, they will be requested as part of the bid document 'tSoogUVUU1'SS!t�j,i�.�� Contractor Survey Results : Qualifications Majority (12-2) would like to see a contractors prequalification program at CFPUA Also mentioned in the comments sections Staff will work towards developing a prequalification program 'tSoK�oUVUU1'SS!t�j,i�.�� Contractor Survey Results : Dislikes r Too much information required to be submitted with the bid such as the qualification statement, listing of all subcontractors and sub qualifications to These documents take away from the actual bid and they are hard to fill out when quotes are coming in at the last minute Staff has revised the bid documents to address these concerns by removing the requirement that all subs be listed and removing the qualification statement 'tSoogUVUU1'SS!t�j,i�.�� Contractor Survey Results : Dislikes to More time between addendum and bid opening Bid document states that questions should be in 5 days prior to bid opening Staff has revised the process to address these concerns as follows: The issuance of addendums had been decentralized, including some being issued by consultants. For all future bids, CFPUA Purchasing Division has taken over issuing all addendums and will not issue addendums close to bid opening date. If an addendum is needed, the bid opening date will be pushed back 'tSoogUVUU1'SS!t�j,i�.�� Contractor Survey Results : Likes Bidder's Checklist - helps identify all documents that need to be submitted with the bid Pre-Bid Meeting - 11 out of the 14 respondents stated they received enough info at the pre-bid meetings Bidding process is consistent CFPUA employees are helpful and responsive to inquiries 'tSoK�oUVUU1'SS!t",j,i�.�� Deliverables Outstanding Full documentation of the bid process * Compilation of data received from other utilities and municipalities * Development of prequalification program CaPeFea Stewardship.Susteinabilit .Seruic i qt r�5ee rt r^,,1 m In-house Lockbox and Interactive Voice Response ( IVR) Initiatives In-House Lockbox Beginning in July 2013, all CFPUA lockbox payments will be processed at 235 Government Center Drive. The remittance address will be changed with July bills. By making this change, we will have greater flexibility for payment processing and we will have the opportunity to retain job(s) within New Hanover County. Longer payment processing time ensures all customer payments received will be posted before any disconnections are generated. Interactive Voice Response System (IVR) Also beginning in July, CFPUA will implement an Interactive Voice Response (IVR) system which will offer our customers a 'Voice Utility' option when they call Customer Service. Customers will have access to their account information or be able to make a credit card payment, 24 hours a day, seven days a week. To use the 'Voice Utility' option, customers will only need their account number located on their bill. Customer Service Update Customer Service achieved a Service Level of 96.016, exceeding the target goal of 95.0%for all calls handled in under 5 minutes. The Call Center continues to consistently meet or exceed this level of service. Average answer time was 72 seconds. EzBilling payments totaled 3565, up 33.52% from last year. Call Volumes and Service Level * Calls Handled 100.0% ........................................................................ 121(m 10, • 96.6% Handled < 5 minutes a) 000 a? 0 Average Answer Time of 72 seconds vs. target of 180 seconds $'0°° E 3 This represents the average wait time that all customers experienced 096.0% a000 throughout the month. 6C6 94.0% X 0 Longest Wait Time 11:28 minutes —this represents the longest one 2.000 call wait time in the month of June. This occurred on Monday,June 24th 92.0% ........................................................................................ ............ ......................... 0 which was the highest call volume day of the month. qIq 4,i.� 4, lac -%Handled<5 min. -Target%Handled<5 min. -Calls Handled * Cash Receipts —-—----------------- ....... Prior Yr. Current Yr. EzBilling and Bank Drafts as a%of June 12 June 13 g E Total Cash Receipts Lock Box Service-Envelope in Bill 56.90% 54.51% Call Center 8.89% 9.73% 14,00% ,2.00% Lobby--Government Center Drive 10.54% 9.43% 10.00% '_'4)....... ............ S.W% Lobby—Downtown 8.16% 6.83% 6-00% — ........ ......... ......... Ez B i I I i ng-C F P U A We bs i te 8.33% 11.92% 4.W%2.00% Bank Drafts 5.20% 5.77% 0.00% Mail GCD 1.98% 1.81% Jun-12 Jul-12 Avg-12 Sep-12 ()ct-12 Niw-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun- 13 .. ............Bank orates EzBilling was 3.44%of total payments in July 2010 'tSoKoUVUU1'SS!t�j,i. Total Incoming by Ca11 s Date Total Incoming Calls by Date Report is unavailable for June 2013 due to the Cisco Phone system upgrade done mid month. Total Calls Offered were 10.7 thousand and Total Calls Answered were 9.9 thousand Abandoned Calls — 6.7% which is .3 points better than target System Development Charges Customer/Location Counts Rolling 2 Quarters Total YTD SDC's paid are$3,851,687 and are 114.52% of 80 budget with 100% of the year complete 70 60 > FYTD June 2013 SDC's are 2.6% higher than prior year 50 40 v. Month of June 2013 was $496K higher than June 2012. 30 --------------- -------------- 20 ............ ............... Residential 10 ------------------------------------- FYTD billed amount of $2,872,041 Commercial Residential Multi-Unit W January u February w March w April N May W Julie FYTD number of customers/locations are 688 compared to prior year of 482 Commercial Total SDC's Paid (Dollars) 0 Rolling 2 Quarters FYTD billed amount of $686,346 vs. prior year of 400,000 ----------------------------------------------------------------------------------------------------------------- $656,040 300,000 0 FYTD number of customers/location — 35 compared 200,000 to prior year of 27 100,000 There were 5 Multiunit SDC's in June for a total of $293,330 Commercial Residential Multi-Unit 0 Multi-unit SDC's prior FYTD were $1,113,644 W January kd February kd March wApril IN May W June 'tSoK�oUVUU1'SS!t�j,i�.�� Customer Accounts Receivable ti $11.7 million combined accounts receivable as of 06/30/13 58% of Accounts Receivable are current This includes CFPUA customer accounts receivables & City of Wilmington trash/stormwater $200,962 in payment plans 10 payment plans were satisfied and 3 new plans were established eo $3.3 million (28.38%) is 120 days and older $1.4M active accounts, $1.9 million non-active Receivables ov -"-1 2 oDays.ss Receivables over 120 Days by Age and Customer Status at June 2013 $1,000,000 $900,000 $800,000 $700,000 Vacant $600,000 Shut Off Active $500,000 Terminated- Non-pay $400,000 a Terminated $300,000 Final 0ollection .$200,000 $100,000 $® 120- 180 days 180 days -1 Year 1 -2 Years 2 -3 Years Over 3 Years - «rJJJr�tur„iiu. Total Water Consumption Trends Rolling 12 Months Total Rolling 12 Month Water/Irrigation Consumption (Million Gallons 5"00 5,100 __ .- __. ___ ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- --------- Calendar 2011—Basis Calendar 2112—Basis LA 5,H0 for F Y URates for FY 4 Rues ........ ........ ........ ..............._ o 1,211 46 a c 5,100 5,000 = 4,900 4,800 Jar 11 11 Mar 11 l Apr 11- Mav 11 J"rll Ill ug 11- Sept ll- Oct 11- No,11 Dec 11- J5r12- Fain 12- 'srIsr 12- App 12- Ma-12° Jurel2-, JO,,12° Oec 11 Arr-12 F--L12 Mar 12 Apr 12 '. May 12 Sur 12 Ju112 Aug.12 ' Sept 12 Oct 12 No',12 aec 13 Jar 13 Pep 13 Mar 13 Apr 13 Ma�,•13 Jvre 13 ollr r g 12 MoI,ti,Am Ca r L�.r'prt�'�5!}5163 5,425 62 541'5:�15� 30 541555 5.4356'3 5,400&1, 535514 S?S£� 5.25'3'1 5290 56 5,?t.J''11 5236 69 5,22609 5,2 15 59 x,237 SS 5,19 49 5,12?06 507716} #ff Calendar 2012 consumption was 3.9% below prior year. This was the data that was used for our approved rate changes effective May 1, 2013. Jul 12—June 13 rolling average consumption is 3.1% lower than Calendar 2012. Jul 12—June 13 rolling average consumption is 0.9% lower than prior month and the lowest since we began analyzing rolling 12 month data Consumption Trends vs. Distribution & Waste Water Treatment (Rolling 2 Months) Total Rolling 2 Month Water/irrigation Consumption(Thousands Gallons)vs.Distribution&Treated Waste Water(1 cycle lag) 1,400,000 1,20D,000 1,000,000 .2 'E —————————-- LD ..... 15 E 80D'000 600,000 400,000 200,000 0 Dec 11- Jan 12- Feb 12- Mar 12- Apr 12- May 12- Jun 12- Jul 12- Aug 12- Sep 12 Oct 12 Nov 12 i Dec 12 Jan 13 Feb 13 i Mar 13 d Apr 13 May 13 Jan 12 Feb 12 Mar 12 Apr 12 May 12 Jun 12 Jul 12 Aug 12 Sep 12 Oct 12 Nov 12 Dec 12 i Jan 13 Feb 13 Mar 13 i Apr 13 I May 13 June 13 Billed Consumption 764,175.8 730,908.3 713,024.6 758,932.3 853,323.9 945,3383 1,013,346 1,062,318 1,015,976 958,578.5 904,263.2!783,641 6;730,152.2 746019.0 724,822.2 702,832.0 738,514.4 823,012.6 Distribution 964,891. 993,740. 966,705. 953,470. 1,029,66 1,117,24 1,147,14 1,224,72 1,194,59 1,043,31 1,030,71'987,259. 907,741. 888,299. 844,799. 847,426. 903,497. 991,691. Treated Waste Water 906,937. 879,415. 843,840. 879,621 897,439. 884,011 909,023, 910,830. 973,100, 997,762, 962,794.'963,520. 970,7 12, 99 3,115 974,167. 965,381. 1,010,16 1,007,10 Water Loss 21% 26Y, 26% 20% 171 1510 12% 13% 15% Ki 134E 21% 20?,,6 16 P/6 144E 171 ISN 17% • Water Loss is defined as the difference between Distribution and Billed Consumption. • Water loss can be driven by hydrant flushing, leaks,water line breaks, meter inaccuracies and City/County Fire training and actual fires • Water Distribution and Treated Waste Water is a one cycle lag to Billed Consumption --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Water Consumption(TGA) Calendar Year 2010-2013 Water �� Consumption and Revenue ��<�� Billed water for June 2013 was the lowest June since we began Water Revenues by Customer Class Calendar Year 2010-2013 tracking consumption 53,OOO,ODO This follows the same trend we have seen since March 2013 2Z22i Irrigation Consumption(TGA) by Customer Class Calendar Year 2010-2013 sG°oG as,ou° E 40, Irrigation i Consumption _ F and Revenue �t-6 M Resider€iM M WIti f—fly O C-11-rdal m 111dustdal "InstltutiWal MG—ri-ental Irrigation Revenue by Customer Class Calendar Year 2010-2013 Billed Irrigation Consumption for June 2013 is the lowest since we G�GGG began tracking f tx.: $150(30° _- ----. ----. ----. ----. ----. ----. ----. — �� -------- �Y d —, ---LL <Z< 000 .R"'dmtlal ®M,1l1�1-,Ily C. rm�[Giid �tl1�JUStri3 IlstltAQ,,I =' Sewer Consumption(TGA)by Customer Class Calendar Year 2010-2013 700,000 6JO00o iF Sewer rr 200,000 Consumption Rs id"t"I Multi-fan,N Inclustr i"I I s[tuhai of GoreA n�isnta9 r,Wrlglrtsv Its B—h and Revenue ------------------------------------------------------------------------------------------------------------------------------- Sewer Revenue by Customer Class Calendar Year 2010-2013 $3,sa©,aoo a 5�.©oo,aao WD,a0(3 ---_. ---_. �Re5 den till ■Mui[�-(araE ly GCoiT�netcial �Ir�d�sU aM 1171�nLtutionaX aG��rn�nc�Eal 'd Wr'��I ts�l @C B-0, en Residential Irrigation Subtraction Meter Customers wanting irrigation meters but their water There have been 529 total inquiries since May 23, liras is too small to split now have the option of adding 2012 an Irrigation Subtraction Meter that will subtract the amount of water used for irrigation from the billing of 52 Subtraction Meter Installations in progress or water used for other household purposes. The water completed to date that passes through this separate subtraction meter ❖ 9.8% of inquiries resulted in a subtraction will be billed the irrigation rate as stated on CPU 's meter installation fee schedule, with no associated sewer charges nor a monthly fixed meter charge. 1" Meter Downsize CFPUA mailed letters to approximately 62o customers r May 23, 2012 - 620 letters mailed to residential informing them that their property is being served by customers with 1" meters a i"water meter and that they have the option to 10% or 60 of those customers inquired about donsaze to a / eter downsize as of June 1, 2013 r 14 customers (2.3%) downsized to a 5/8" meter i �, 4 � - ' ` .`.� ......... ......... ......... ......... ......... �........� ........ ....... ......... �........ ......... ......... ......... ......... ......... ........ i........ ....... ......... ......... ......... ....5.... BALANCE SHEET Operating and SDC Escrow Funds fz Cash and cash equivalents - operating funds $ 11,000,000 $ 11,000,000 Cash and cash equivalents - capital reserve 40,809,302 39,642,377 Cash and cash equivalents - restricted for retirement health insurance 4,184,322 4,187,454 Cash and cash equivalents - restricted bond proceeds 13,782,516 13,782,516 Receivables, net of allowance for uncollectible accounts of$2,017,597 8,003,603 10,583,547 Inventories 1,256,473 1,223,129 Prepaid Expenses 30,657 101,102 Capital Assets 557,138,413 557,138,413 Total assets $636,205,286 $637,658,538 s s t i S, S, Accounts payable and accrued liabilities $ 2,346,047 $ 3,313,701 Due to other governments 2,069,163 2,602,544 Deferred Revenue 706,609 706,609 Compensated absences 1,063,438 1,063,438 Other pos tern ployment benefits 2,215,498 2,215,498 Long-term obligations 314,080,925 311,910,925 Total liabilities 322,481,680 321,812,715 NET ASSETS Invested in capital assets, net of related debt 243,057,488 245,227,488 Restricted for retirement health insurance 4,184,322 4,187,454 Restricted bond proceeds 13,782,516 13,782,516 Unrestricted 52,699,280 52,648,365 Total net assets 313,723,606 315,845,823 TOTAL LIABILITIES AND NET ASSETS $ 636,205,286 $ 637,658,538 'tSoK�oUVUU1'SS!t",j,i�.�� Balance Sheets Operating and SDC Escrow Funds $80.5 million Current Assets (Total assets less Capital assets) $50.6 million Unrestricted Cash ($11 million + $39.6 million) $1.2 million decrease in cash from previous month $10.6 million Receivables, net of allowance for uncollectible accounts CFPUA customer accounts receivable, City of Wilmington trash & stormwater, sales tax receivable, & miscellaneous receivables Net of $2.02 million allowance for uncollectible accounts $6.6 million Current Liabilities Accounts payable, accrued liabilities, due to other governments, deferred revenue BALANCE SHEET Capital Projects Funds - Water and Wastewater , r 3 � 1) 11 f f 1 f1 4 � SStI $ Cash and cash equivalents - capital reserve $ 40,419,135 $ 41,451,689 Cash and cash equivalents - restricted bond proceeds 16,923,288 16,926,111 Receivables 99,330 1 15,980 Total assets $ 57,441,753 $ 58,493,780 r r t r fS 55 i J f 5r Accounts payable $ 360,550 $ 406,608 Due to other governments - - Total liabilities 360,550 406,608 NET ASSETS Restricted bond proceeds 16,923,288 16,926,111 Restricted for capital projects 40,157,915 41,161,061 Total net assets 57,081,203 58,087,172 TOTAL LIABILITIES AND NET ASSETS $ 57,441,753 $ 58,493,780 Balance Sheets J Capital Projects Funds — Water and Sewer $58.5 million Total Assets Includes $16.9 million of restricted proceeds from the 2011 Revenue bonds All committed to active capital projects 'tSoogUVUU1'SS!t�j,i�.�� J Capital Projects Report PROJECT-TO-DATE PROJECT-TO-DATE PROJECT TOTAL BUDGET BUDGET EXPENDITURES ENCUMBRANCES AVAILABLE TOTAL ACTIVE WASTEWATER PROJECTS $120,346,322 $57,276,151 $10,736,239 $52,333,932 TOTAL ACTIVE WATER PROJECTS $139,554,535 $117,363,508 $3,321,293 $18,869,734 GRAND TOTAL ACTIVE PROJECTS $259,900,857 $174,639,659 $14,057,532 $71,203,666 enm : Cash and Investment Report (Based on May 31st Bank Reconciliations) CASH & INVESTMENT BY TYPE AND/OR INSTRUMENT IN RATE BALANCES % FOLIO BB&T- Checking Accounts-General & Payroll 0.29% 30,165,313.98 24.49% BB&T- Investment Account 0.29% 8,821,900.74 7.16% BOA -Checking Accounts-General & Payroll 0.35% 2,868,319.43 2.33% BOA - Investment Account 0.38% 50,008,904.06 40.59% Suntrust- Checking Account-Merchant Services 0.02% 118,081.48 0.10% North Carolina Capital Management Trust- Investment Account 0.03% 505,424.13 0.41% North Carolina Capital Management Trust- Bond Proceeds * 0.03% 325,257.23 0.26% FHLM Discount Note -2008 Bond Proceeds Debt Service Reserve Account* 4.623% 13,456,192.18 10.92% TD Bank - Fixed Rate Public Funds Money Market-2011 Bond Proceeds * 0.20% 16,926,099.56 13.74% *Bond Proceeds are held by US Bank as Trustee $123,195,492.79 100.00% DEPOSITORY/INVESTMENT BALANCES % FOLIO Branch Banking & Trust 38,987,214.72 31.65% Bank of America 52,877,223.49 42.92% Suntrust 118,081.48 0.10% TD Bank 16,926,099.56 13.74% FHLM Discount Note 13,456,192.18 10.92% North Carolina Capital Management Trust 830,681.36 0.67% $123,195,492.79 100.00% June Change r Or des Original Previous Contract Contract Change Current Change Change Order Contract Type Vendor Amount Order# Order Amount Amounts Date Kirkland Capacity Engineering Paramounte Engineering $91,700.00 1 $3,100.00 $0.00 6/4/2013 N. 10th &Anderson Construction Heath Grading& Utility $86,965.00 2 $28,209.22 $12,370.00 6/4/2013 Surveying Services Emergency Projects Surveying SEPI $70,000.00 5 $3,150.00 $6,280.00 6/6/2013 Surveying Services Emergency Projects Surveying SEPI $70,000.00 6 $1,500.00 $9,430.00 6/6/2013 Surveying Services Emergency Projects Surveying ESP $70,000.00 1 $8,470.00 $0.00 6/11/2013 Surveying Services Emergency Projects Surveying ESP $70,000.00 2 $5,000.00 $8,470.00 6/11/2013 HVAC Repairs at 235 Construction Tim's Heating&Air $26,662.00 3 $393.00 $2,215.00 6/11/2013 Airport Lining Project Construction Portland Utilities $605,550.00 1 $36,465.00 $0.00 6/12/2013 June Change Orders Continued Previous Original Contract Change Current Change Change Order Contract Contract Type Vendor Amount Order# Order Amount Amounts Date Airport Lining Project Construction Portland Utilities $605,550.00 2 $41,380.00 $36,465.00 6/12/2013 608 Hampton Road Construction Atlantic Construction $28,880.00 1 $6,288.37 $0.00 6/18/2013 Airport Lining Project Construction Portland Utilities $605,550.00 3 $7,650.00 $77,845.00 6/19/2013 Alley Between Market& Perry Construction Sandy's Hauling $193,000.00 1 $8,700.00 $0.00 6/19/2013 100 Block Hampton Road Construction Skinner Smith Construction $260,200.00 1 $14,696.00 $0.00 6/19/2013 100 Block Hampton Road Construction Skinner Smith Construction $260,200.00 2 $20,478.00 $14,696.00 6/19/2013 Airport Lining Project Construction Portland Utilities $605,550.00 4 $9,400.00 $85,495.00 6/26/2013 - Water Distribution Report Units =mgd June 2012 June 2013 June 2012 June 2013 Daily High T Daily High T Daily Low Daily Low Sweeney WTP q�� ? 18.11 17.32 13.04 12.17 04-65-010 Nano Plant 04-65-232 4.48 3.74 2.13 1.98 Montereys. � Heights '` _ ' 0.77 0.74 0.38 0.33 04-65-137 421 04-65-191 1 d t, 0.13 0.12 0.04 0.06 CFPLIA Total '' _ _ 23.49 21.92 15.59 14.54