Loading...
HomeMy WebLinkAbout17 Treasurer's Reportenda Item # TREASURER'S REPORT To: Board of ®irectors From: Tricia Phillips Title: Interim Accounting and Finance Manager Date: August 19, 2015 TREASURER'S REPORT For the Month Ended Treasurers Report: July 31, 2015 a) Approval of the Treasurers report of fund balances as of June 30, 2015 b) Approval of disbursements for July 2015 17 TRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER'S REPORT August 199 2015 Fund Balances for the Month Ended June 30, 2015 and Disbursements for the Month Ended July 31, 2015 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the period ended June 30, 2015 and disbursements for July 2015: 1) REQUEST FOR APPROVAL OF DISBURSEMENTS -Page 3 The total disbursements for July 2015 were $3,744,883.36. 2) CHECK SUMMARY -Pages 4 through 9 The attached listing of checks and ACH payments issued during July 31, 2015 total $3,744,883.36. 3) STATEMENT OF GENERAL FUND: Page 10 As of June 30, 2015 the balance in the General Fund was $7,432,275.05 (Electric $4,965,918.86 and Water $2,457,356.19.) 4) FUNDS STATUS REPORT: Page 11 The total of all funds held in cash and on deposit with US Bank, the Local Agency Investment Fund, Placer County Investment Fund, Utah Public Treasurers' Investment Fund and the Federal Farm Credit Investment as of June 30, 2015 was $26,161,227.72 ($13,938,396.30 electric and $12,222,831.42 water). 5) INVESTMENT STATUS REPORT: Pages 12 through 13 The majority of the District's investments are in California's Local Agency Investment Fund (LAIF), Utah Public Treasurers' Investment Fund (UPTIF) and the Placer County Investment Fund (PCIF). The earnings rate for the last 13 months were: LAIF PCIF UPTIF 1YRT-BILL June 2014 0.23% 1.29% 0.47% 0.11% July 2014 0.24% 1.26% 0.46% 0.11% August 2014 0.26% 1.20% 0.46% 0.90% September 2014 0.25% 1.65% 0.47% 0.11% October 2014 0.26% 0.94% 0.48% 0.10% November 2014 0.26% 0.95% 0.50% 0.12% December 2014 0.27% 0.77% 0.50% 0.22% January 2015 0.26% 0.70% 0.50% 0.16% February 2015 0.26% 0.89% 0.51% 0.19% March 2015 0.28% 0.85% 0.52% 0.26% Apri12015 0.28% 0.74% 0.55% 0.23% May 2015 0.29% 0.89% 0.55% 0.25% July 2015 0.30% 1.00% 0.56% 0.27% 6) STATUS OF INVESTMENTS: Page 14 Funds are on deposit with LAIF, Placer County, Utah Public Investment Fund and US Bank. Other investments are held by the District's trustee, Bank of New York Mellon. The total fair market value of all deposits and investments as of June 30, 2015, is $35,251,868 including a cumulative market adjustment of $209,211. ra TRUCKEE DONNER PUBLIC UTILITY DISTRICT Request for Approval of Disbursements The disbursements of the Truckee Donner Public Utility District for the month of July totaled $3,744,883.36. A listing of those disbursements is attached. Truckee Donner Public Utility District Check Register July 2015 Check/Trans Date Vendor #Vendor Name Reference Amount 13584 7/1/2015 5440 ALTEC INDUSTRIES INC REPAIRS &MAINTENANCE 193.14 13585 7/1/2015 524 DE LAGE LANDEN OPERATIONAL SERVICES LLC CONSERVATION XEROX LEASE 227.57 13586 7/1/2015 9325 EMPLOYEE DEVELOPMENT EMPLOYEE DEVELOPMENT 40.07 13587 7/1/2015 5840 FERGUSON ENTERPRISES INC INVENTORY 2,492.63 13588 7/1/2015 361 FIRST CHOICE SERVICES FACILITY SUPPLIES 89.02 13589 7/1/2015 3340 GENERAL PACIFIC INC INVENTORY 1,132.52 13590 7/1/2015 10804 JUNIPER HILLS PROPERTY OWNER CONTRACT SERVICES: SNOW REMOVAL 612.98 13591 7/1/2015 3865 MALLORY SAFETY &SUPPLY FIELD SUPPLIES 325.24 13592 7/1/2015 5130 NCPA MEMBERSHIP DUES 13,867.00 13593 7/1/2015 820 ONESOURCE DISTRIBUTORS MATERIALS 981.88 13594 7/1/2015 1173 RPS INDUSTRIES WELL 20 REHABILITATION PROJECT 6,770.00 13595 7/1/2015 6402 SIERRA PACIFIC POWER CO PURCHASED POWER - SPPC 21,113.62 13596 7/1/2015 6604 SPIEGEL & MC DIARMID PROFESSIONAL SERVICES: FERC ISSUES 7,906.81 13597 7/1/2015 26 THE BANK OF NEW YORK MELLON DEBT PAYMENT 143,232.71 13598 7/1/2015 776 TYRES INTERNATIONAL INC. REPAIRS &MAINTENANCE 1,031.52 13599 7/1/2015 10584 UAMPS PURCHASED POWER -UAMPS 850,090.76 13600 7/1/2015 1321 WRIGHTTREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 12,865.61 116714 7/1/2015 44444 7-ELEVEN INC COMMERCIAL CUSTOM REBATE 2,250.00 116715 7/1/2015 5860 ARAMARK UNIFORM SERVICES INC EMPLOYEE UNIFORM CLEANING SERVICES 67.69 116716 7/1/2015 657 AT&T E-SCADA 235.72 116717 7/1/2015 969 BC LABORATORIES INC. WATER SAMPLE ANALYSIS 50.00 116718 7/1/2015 9233 CELL PHONE REIMBURSEMENT CELL PHONE REIMBURSEMENT 156.00 116719 7/1/2015 11233 CALPERS CALPERS CONTRIBUTIONS 64,065.00 116720 7/1/2015 9370 VISION VISION 275.00 116721 7/1/2015 10250 CARBON PUMP LLC 2015 AIRPORT WELL MAINTENANCE 28,732.91 116722 7/1/2015 11026 CINTAS CORPORATION k2 EMPLOYEE UNIFORM CLEANING SERVICES 190.81 116723 7/1/2015 1072 CONSOLIDATED ELECTRICAL DIST COMMUNICATION UPGRADE -RADIOS 1,357.13 116724 7/1/2015 44444 DENNIS BRESNAHAN APPLIANCE REBATE 75.00 116725 7/1/2015 10419 DEPARTMENT OF MOTOR VEHICLES PURCHASE JEEP CHEROKEE 3,952.00 116726 7/1/2015 10669 E.H. WACHS COMPANY MISC PARTS &SUPPLIES 335.15 116727 7/1/2015 348EDGESELECTRICAIGROUP COMMUNICATION UPGRADE -RADIOS 1,541.11 116728 7/1/2015 848 FASTENAL COMMUNICATION UPGRADE -RADIOS 66.90 116729 7/1/2015 7860 HD SUPPLY POWER SOLUTIONS LTD. RECLOSERS, REGULATORS 8c CONTROLS 4,877.03 116730 7/1/2015 1078 IDIOMA VIVO SPANISH LESSONS 140.00 116731 7/1/2015 1176 VISION VISION 1,065.00 116732 7/1/2015 9600 MEETING EXPENSES MEETING EXPENSES 47.15 116733 7/1/2015 924 KWA SAFETY 8e HAZMAT CONSULTANTS INC EMPLOYEE DEVELOPMENT 1,100.00 116734 7/1/2015 9657 EMPLOYEE DEVELOPMENT EMPLOYEE DEVELOPMENT 46.30 116735 7/1/2015 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 277.20 116736 7/1/2015 629 LIEBERT CASSIDY WHITMORE MEMBERSHIP DUES 1,940.00 116737 7/1/2015 257 LONGO INCORPORATED DONNER LAKE SUB REBUILD 2015 500.00 116738 7/1/2015 1161 MADER SUPPLY, LLC INVENTORY 263.99 116739 7/1/2015 468 MAITA CHEVROLET REPAIRS Se MAINTENANCE 126.35 116740 7/1/2015 44444 MARSH VENTURES INC COMMERCIAL LIGHTING REBATE 2,446.50 116741 7/1/2015 11025 MOONSHINE INK MARKETING 257.81 116742 7/1/2015 965 MOSS ADAMS PROFESSIONAL SERVICES: AUDIT 12,900.00 116743 7/1/2015 1179 MOUNTAIN AREA PRESERVATION MARKETING 500.00 116744 7/1/2015 617 MOUNTAIN EAP WELLNESS PROGRAM 225.00 116745 7/1/2015 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 117.90 116746 7/1/2015 347 NORTHTOWN COMPANY MATERIALS 278.72 116747 7/1/2015 5151 NRECA INSURANCE 14,054.82 116748 7/1/2015 5150NRECAGROUPBENEFITSTRUST INSURANCE 160,155.26 116749 7/1/2015 1079 O'REILLY AUTO PARTS REPAIRS 8e MAINTENANCE 544.01 116750 7/1/2015 9504397 PACE SUPPLY INVENTORY 1,227.89 116751 7/1/2015 44444 PIKA PROPERTIES REFRIGERATOR RECYCLE 60.00 116752 7/1/2015 322 POLLARDWATER.COM MATERIALS 990.60 116753 7/1/2015 44444 ROCK Se ROSE INC. COMMERCIAL LIGHTING REBATE 906.14 116754 7/1/2015 44444 SIERRA CREST CORPORATION COMMERCIAL LIGHTING REBATE 4,958.55 116755 7/1/2015 181 SIERRA ENVIRONMENTAL MONITORING INC. WATER SAMPLE ANALYSIS 180.00 116756 7/1/2015 406 SIERRA NEVADA MEDIA GROUP MARKETING 2,749.00 116757 7/1/2015 837 SIERRA OFFICE SOLUTIONS CUSTOMER SERVICE COPIER 75.39 116758 7/1/2015 880 SIERRA VALLEY HOME CENTER RESIDENTIAL ENERGY SURVEY PROGRAM 256.00 116759 7/1/2015 10761 SOUTHWEST GAS CORP. MATERIALS 11.28 116760 7/1/2015 7040 TEICHERT &SON INC CREDIT DE MATERIALS 1,360.36 116761 7/1/2015 44444 TERRY HUNT REFRIGERATOR RECYCLE 30.00 116762 7/1/2015 9979 VISION VISION 493.00 116763 7/1/2015 10284 UNITED RENTALS DROUGHT REGULATION COMPLIANCE 1,085.76 Truckee Donner Public Utility District Check Register July 2015 Check/Trans Date Vendor fi Vendor Name Reference Amount 116764 7/1/2015 682 VERIZON WIRELESS CELL PHONE CHARGES 2,287.10 116765 7/1/2015 99999 VALERIE VILBIG CUSTOMER REFUND -CLOSED ACCOUNT 19.09 116766 7/1/2015 934 WEST COAST PAVING INC DONNER LAKE SUB REBUILD 2015 57,172.98 116767 7/1/2015 7820 WESTERN NEVADASUPPLY MATERIALS 2.23 116768 7/1/2015 667 WESTERN RENEWABLE ENERGY GENERATION ENVIRONMENTAL COMPLIANCE FEES 50.00 116769 7/1/2015 44444 WILMA EPPERLE APPLIANCE REBATE 75.00 3352 7/2/2015 PAYROLL PAYROLL 162,952.97 116770 7/2/2015 PAYROLL PAYROLL 1,768.10 116771 7/2/2015 PAYROLL PAYROLL 1,526.13 3353 7/Z/2015 38241CMARETIREMENTTRUST457 ICMACONTRIBUTIONS 7,523.22 3354 7J2/2015 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 76,677.68 3355 7J2/2015 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 14,479.76 3356 7/2/2015 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS 14,922.02 3363 7/2/2015 38241CMARETIREMENTTRUST457 ICMA457CONTRIBUTIONS 85.42 3364 7/2/2015 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 1,121.75 3365 7/2/2015 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 135.73 3358 7/16/2015 PAYROLL PAYROLL 166,146.62 3359 7/16/2015 38241CMARETIREMENTTRUST457 ICMACONTRIBUTIONS 19,084.57 3360 7/16/2015 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 74,732.67 3361 7/16/2015 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 14,197.77 3362 7/16/2015 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS 14,719.97 13671 7/16/2015 10020 ALPHA ANALYTICAL INC. WATER SAMPLE ANALYSIS 155.00 13672 7/16/2015 1053 ALPHA OMEGA WIRELESS INC LICENSING, MAINTENANCE &SUPPORT 10,800.00 13673 7/16/2015 5440 ALTEC INDUSTRIES INC REPAIRS &MAINTENANCE 189.54 13674 7/16/2015 9086 VISION VISION 622.28 13675 7/16/2015 829 CDS GLOBAL REMITTANCE PROCESSING 1,091.23 13676 7/15/2015 981 CRMORBIT INC LICENSING, MAINTENANCE &SUPPORT 3,615.84 13677 7/16/2015 990 D-SIGN CENTRAL DROUGHT REGULATION COMPLIANCE 32.44 13678 7/16/2015 10759 DONNER LAKE ASSESSMENT DISTR NEVADA COUNTY 2014/15 ASSESSMENT 37,407.15 13679 7/16/2015 992E & M ELECTRIC &MACHINERY INC 2015 WATER SCADA SYSTEM REPLACEMENT 193.99 13680 7/16/2015 1167EASTRIVERPR PROFESSIONAL SERVICES: MARKETING 1,921.66 13681 7/16/2015 1100 ECOTONE PRODUCTS, LLC INVENTORY 3,714.23 13682 7/16/2015 5840 FERGUSON ENTERPRISES INC INVENTORY 355.18 13683 7/16/2015 361 FIRST CHOICE SERVICES FACILITY SUPPLIES 94.97 13684 7/16/2015 3340 GENERAL PACIFIC INC INVENTORY 3,627.20 13685 7/16/2015 3322 GEXPRO PURCHASE TRANSFORMER 10,858.03 13686 7/16/2015 3480 GRAINGER INC. SCADA HUB BLDG 304.05 13687 7/16/2015 10008 HOSE 8c FITTINGS ETC REPAIRS &MAINTENANCE 162.12 13688 7/16/2015 1107 ICE DATA LP ENVIRONMENTAL COMPLIANCE FEES 800.00 13689 7/16/2015 11227 INLAND ECOSYSTEMS DISTRICT PIPELINE REPLACEMENT 2015 440.00 13690 7/16/2015 967 INLAND SUPPLY CO FACILITY SUPPLIES 304.56 13691 7/16/2015 9730 VISION VISION 794.85 13692 7/16/2015 1099 MOANANURSERY PROFESSIONAL SERVICES: OTHERS 130.00 13693 7/16/2015 9810 JULIE NELSON TELEPHONE REIMBURSEMENT 02/15 TO 06/15 330.84 13694 7/16/2015 820 ONESOURCE DISTRIBUTORS INVENTORY 420.98 13695 7/16/2015 775 ONLINE INFORMATION SERVICES CREDIT CHECK SERVICES 281.90 13696 7/16/2015 9924 VISION VISION 210.50 13697 7/16/2015 1013 SIERRA ENERGY PROFESSIONALS RESIDENTIAL ENERGY SURVEY PROGRAM 1,935.00 13698 7/16/2015 1158 SIERRA TAHOE HEATING & A/C BUILDING MAINTENANCE 4,278.00 13699 7/16/2015 3520 SIMPLEXGRINNEIL BUILDING MAINTENANCE 104.59 13700 7/16/2015 26 THE BANK OF NEW YORK MELLON DEBT PAYMENT 172,120.09 13701 7J16/2015 2025 THE OFFICE BOSS MARKETING 201.02 13702 7/16/2015 7176 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 17.51 13703 7/16/2015 890 TRI SAGE CONSULTING MARTIS VALLEY SUB T/F TIE DOWN PROJECT 2,540.50 13704 7/16/2015 712 TRUCKEE DONNER PUD STAMPEDE PURCHASED POWER 5,412.87 13705 7/16/2015 1321 WRIGHTTREE SERVICE, INC. CONTRACT SERVICES: ROW POLE CLEARING 7,797.22 116772 7/16/2015 1135 AIRGAS USA, LLC MATERIALS 186.74 116773 7/16J2015 10682 AM-X CONSTRUCTION & EXCAVATI DISTRICT PIPELINE REPLACEMENT 2015 216,838.64 116774 7/16/2015 10825 ANIXTER INC. SCADA HUB SYSTEM 1,429.14 116775 7/16/2015 5860 ARAMARK UNIFORM SERVICES INC MATERIALS 435.93 116776 7/16J2015 240 AUDIO ON -HOLD ON -HOLD PHONE SYSTEM 79.00 116777 7/16/2015 1019 BARE BONES WORKWEAR EMPLOYEE UNIFORM 491.02 116778 7/16/2015 969 BC LABORATORIES INC. WATER SAMPLE ANALYSIS 46.35 116779 7/16/2015 99999 RON BISHOP CUSTOMER REFUND -CLOSED ACCOUNT 1.70 116780 7/16/2015 99999 FRANCISCO BRAVO CUSTOMER REFUND -CLOSED ACCOUNT 22.48 116781 7/16J2015 10950 CALIFORNIA CONTRACTORS SUPPLIES FACILITY SUPPLIES 113.91 116782 7/16/2015 11233 CALPERS PENSION 46,454.79 E Truckee Donner Public Utility District Check Register July 2015 Check/Trans Date Vendor N Vendor Name 116783 7/16/2015 11026 CINTAS CORPORATION #2 116784 7/16/2015 1072 CONSOLIDATED ELECTRICAL DIST 116785 7/16/2015 577 COOPERATIVE RESPONSE CENTER INC. 116786 7/16/2015 226 CRANMER ENGINEERING INC. 116787 7/16/2015 1003 CRUX EVENTS 116788 7/16/2015 10669 E.H. WACHS COMPANY 116789 7/16/2015 193 EASTERN REGIONAL LANDFILL 116790 7/16/2015 348 EDGES ELECTRICAL GROUP 116791 7/16/2015 640 EMPLOYER LYNX INC. 116792 7/16/2015 44444 ERIN KELLY 116793 7/16/2015 772 FAMILY RESOURCE CENTER OF TRUCKEE 116794 7/16/2015 10257 FARWEST LINE SPECIALTIES, LLC 116795 7/16/2015 848 FASTENAL 116796 7/16/2015 1790 FLYERS ENERGY LLC 116797 7/16/2015 3349 GLOBAL RENTAL CO INC 116798 7/16/2015 145 GROVE MADSEN INDUSTRIES 116799 7/16/2015 277 HACH COMPANY 116800 7/16/2015 556 HART HIGH VOLTAGE CO INC. 116801 7/16/2015 9449 MIKE HATCH 116802 7/16/2015 7860 HD SUPPLY POWER SOLUTIONS LTD. 116803 7/16/2015 10175 HDS WHITE CAP CONST SUPPY 116804 7/16/2015 905 HEALTHEQUITYINC. 116805 7/16/2015 1136 CRISTINA HENNESSEY 116806 7/16/2015 99999 LAURA HERRERA 116807 7/16/2015 10449 HI -LINE UTILITY SUPPLY CO. 116808 7/16/2015 9460 VISION 116809 7/16/2015 99999 MITCHELL HURST 116810 7/16/2015 1180 INTERNATIONAL INSTITUTE OF MUNICIPAL 116811 7/16/2015 10932 J & L FOOD MART 8e CARWASH 116812 7/16/2015 109 J.L. WINGERT CO. 116813 7/16/2015 1176 VISION 116814 7/16/2015 3930 JACKSON-HIRSH INC 116815 7/16/2015 999 JEFF BENDER 116816 7/16/2015 44444 JEFFSARLO 116817 7/16/2015 1132 LEAF 116818 7/16/2015 99999 DONG K LEE 116819 7/16/2015 99999 ARCENIA LEYVA 116820 7/16/2015 6401 LIBERTY UTILITIES 116821 7/16/2015 1149 LOOMIS 116822 7/16/2015 1085 MACHABEE CAPITAL, INC. 116823 7/16/2015 1161 MADER SUPPLY, LLC 116824 7/16/2015 99999 MAT MAES 116825 7/16/2015 468 MAITA CHEVROLET 116826 7/16/2015 4720 MOUNTAIN HARDWARE AND SPORTS 116827 7/16/2015 99999 KATARIINA NOUSIAINEN 116828 7/16/2015 5151 NRECA 116829 7/16/2015 1079 O'REILLY AUTO PARTS 116830 7/16/2015 5222 OFFICE DEPOTINC. 116831 7/16/2015 1920 OFFICEMAX - A BOISE COMPANY 116832 7/16/2015 788 ONTRAC 116833 7/16/2015 5347 OTIS ELEVATOR COMPANY 116834 7/16/2015 9504397 PACE SUPPLY 116835 7/16/2015 99999 WILANA PRIBBLE 116836 7/16/2015 10524 PRINTART 116837 7/16/2015 99999 J COREY RAY 116838 7/16/2015 884 ROAD SAFE CONSTRUCTION, INC. 116839 7/16/2015 699 RYAN PROCESS INC. 116840 7/16/2015 99999 BRIAN SANTILENA 116841 7/16/2015 6S6 SCO PLANNING &ENGINEERING INC 116842 7/16/2015 11226 SHRED -IT REND 116843 7/16/2015 181 SIERRA ENVIRONMENTAL MONITORING INC. 116544 7/16/2015 28 SIERRA FREIGHTLINER STERLING WESTERN 116845 7/16/2015 900 SIERRA MOUNTAIN PIPE &SUPPLY 116846 7/16/2015 406 SIERRA NEVADA MEDIA GROUP 116847 7/16/2015 837 SIERRA OFFICE SOLUTIONS 116848 7/16/2015 6445 SIERRA WELDING SUPPLY CO 116849 7/16/2015 716 SMALLPOND STUDIO Reference Amount EMPLOYEE UNIFORM CLEANING SERVICES 381.62 COMMUNICATION UPGRADE -RADIOS 60.81 ANSWERING SERVICE 2,232.43 WATER SAMPLE ANALYSIS 113.75 CONSERVATION GARDEN EXPENSES 509.35 MATERIALS 167.02 LANDFILL CHARGES 66.25 SCADA HUB BLDG 1,322.80 PERSONNEL EXPENSES 178.00 SOLAR REBATE 7,650.00 INCOME QUALIFIED (ESP) 633.80 SAFETY SUPPLIES 1,055.08 MISC PARTS &SUPPLIES 621.32 FUEL FOR VEHICLES 5,696.98 MATERIALS 8,995.13 SCADA HUe BLDG 2,310.96 MATERIALS 184.91 TRUCKEE SUBSTATION STORM DAMAGE REPAIRS 6,707.80 TELEPHONE REIMBURSEMENT 1/15 TO 6/15 119.94 RECLOSERS, REGULATORS &CONTROLS 61,835.52 MATERIALS 736.50 HSA ADMINISTRATIVE FEES 82.50 DROUGHT REGULATION COMPLIANCE 156.00 CUSTOMER REFUND -CLOSED ACCOUNT 14.35 MATERIALS 50.35 VISION 210.00 CUSTOMER REFUND -CLOSED ACCOUNT 283.98 MEMBERSHIP DUES 120.00 FUEL FOR VEHICLES 97.79 MATERIALS 504.92 VISION 1,252.50 OFFICE SUPPLIES 71.41 REFUND FACILITY FEES 1,260.00 SOLAR REBATE 7,650.00 XEROX COPIER LEASE 549.82 CUSTOMER REFUND -CLOSED ACCOUNT 80.16 CUSTOMER REFUND -CLOSED ACCOUNT 121.74 ELECTRIC FOR PUMP STATION 196.68 BANKING SERVICES 335.49 COPIER LEASES 1,898.91 MATERIALS 9,707.92 CUSTOMER REFUND -CLOSED ACCOUNT 64.87 REPAIRS 8c MAINTENANCE 516.19 WATER PRODUCTION METER PROJECT 455.22 CUSTOMER REFUND -CLOSED ACCOUNT 177.99 HEALTH 125 ADMINISTRATIVE FEES 277.50 MATERIALS 32.31 OFFICE SUPPLIES 192.13 OFFICE SUPPLIES 64.66 WATER SAMPLE ANALYSIS 39.68 BUILDING MAINTENANCE 5,934.76 INVENTORY 4,930.79 CUSTOMER REFUND -CLOSED ACCOUNT 8.98 WATER RATE CHANGE 5,546.14 CUSTOMER REFUND -CLOSED ACCOUNT 28.77 NORTHWOODS O/H RECONSTRUCTION 3,190.50 WATER QUALITY: TREATMENT 6,216.92 CUSTOMER REFUND -CLOSED ACCOUNT 61.04 SITE SERVEY 10.35 OFFICE SUPPLIES 85.00 WATER SAMPLE ANALYSIS 180.00 MISC PARTS &SUPPLIES 79.99 INVENTORY 246.88 CONSERVATION GARDEN EXPENSES 751.00 WORK ORDER XEROX 140.49 MATERIALS 179.07 CONSERVATION GARDEN EXPENSES 1,781.25 Truckee Donner Public Utility District Check Register July 2015 Check/Trans Date Vendor q Vendor Name Reference Amount 116850 7/16/2015 3826 STONE'S COUNTRY TIRE REPAIRS &MAINTENANCE 992.13 116851 7/16/2015 719 T-MOBILE SCADA SYSTEM MODEM 40.94 116852 7/16/2015 99999 TAHOE BLUE AUTOMOTIVE CUSTOMER REFUND -CLOSED ACCOUNT 106.23 116853 7/16/2015 10814 TAHOE FENCE COMPANY INC. SCADA HUB BLDG 4,899.00 116854 7/16/2015 6860 TAHOE FOREST HOSPITAL PERSONNEL EXPENSES 534.00 116855 7/16/2015 6940 TAHOE TRUCKEE SANITATION AGENCY WATER SAMPLE ANALYSIS 225.00 116856 7/16/2015 6920 TAHOE TRUCKEE SIERRA DISPOSAL LANDFILL CHARGES 1,793.80 116857 7/16/2015 1062 TESSCO TECHNOLOGIES 2015 WATER SCADA SYSTEM REPLACEMENT 960.05 116858 7/16/2015 1092 TOYOTA FINANCIAL SERVICES ELECTRIC VEHICLE LEASE 497.22 116859 7/16/2015 7175 TRANSWORLD SYSTEMS INC COLLECTION SERVICES 90.64 116860 7/16/2015 7290 TRUCKEE OVERHEAD DOOR MATERIALS 130.00 116861 7/16/2015 7315 TRUCKEE SANITARY DISTRICT UTILITIES: SEWER 1,046.52 116862 7/16/2015 99999 TRUCKEE TAHOE AIRPORT DISTRICT CUSTOMER REFUND -CLOSED ACCOUNT 14.48 116863 7/16/2015 57 TRUCKEE TAHOE MEDICAL GROUP PERSONNEL EXPENSES 369.00 116864 7/16/2015 324 UNION PACIFIC RAILROAD COMPA TRUCKEE RAILYARD REDEVELOPMENT 505.00 116865 7/16/2015 7380 UNITED PARCEL SERVICE UPS CHARGES 208.32 116866 7/16/2015 10141 VILLAGER NURSERY FENCE PROPERTY BEHIND PUD 435.48 116867 7/16/2015 7820 WESTERN NEVADASUPPLY RESIDENTIALSVCS NEW/UPGRADE 2,365.65 13706 7/23/2015 479 3T EQUIPMENT COMPANY INC REPAIRS &MAINTENANCE 1,410.42 13707 7/23/2015 345 AMERICAN &FOREIGN TRANSMISSIO REPAIRS Se MAINTENANCE 3,784.07 13708 7/23/2015 524 DE LACE LANDEN OPERATIONAL SERVICES LLC WATER CREW COPIER 120.09 13709 7/23/2015 3480 GRAINGER INC. MATERIALS 69.12 13710 7/23/2015 494 HOLDREGE & KULL CONSULTING ENGINEERS DISTRICT PIPELINE REPLACEMENT 2015 7,413.30 13711 7/23/2015 986 KELLY-MOOREPAINTCOINC MATERIALS 300.32 13712 7/23/2015 289 NISC DUNE 2015 RECURRING INVOICE 20,277.95 13713 7/23/2015 820 ONESOURCE DISTRIBUTORS INVENTORY 518.37 13714 7/23/2015 9924 RYAN PURSEL DMV LICENSE RENEWAL 58.25 13715 7/23/2015 9940 PATRICIA RUBY GREEN PARTNERS PROGRAM 129.31 13716 7/23/2015 839 S & S SUPPLIES &SOLUTIONS SAFETY SUPPLIES 1,893.36 13717 7/23/2015 6360 SIERRA CHEMICAL COMPANY WATER QUALITY: TREATMENT 1,132.95 13718 7/23/2015 2025 THE OFFICE BOSS OFFICE SUPPLIES 418.82 13719 7/23/2015 590 TRUCKEE FENCE COMPANY FENCE PROPERTY BEHIND PUD 22,947.50 13720 7/23/2015 4590 UNDERGROUND SERVICE ALERT OF NORTHERN MEMBERSHIP DUES 1,535.28 13721 7/23/2015 10737 US BANK GOVERNMENT SERVICES CREDIT CARD CHARGES 22,500.88 13722 7/23/2015 10678 WILLDAN FINANCIAL SERVICES OG MR ADMIN COSTS 5,947.75 13723 7/23/2015 1321 WRIGHTTREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 7,671.13 116868 7J23/2015 10360 AFLAC EMPLOYEE PAID INSURANCE 1,980.90 116869 7/23/2015 1181 AMAZON/SYNCB MATERIALS 307.91 116870 7/23/2015 5860 ARAMARK UNIFORM SERVICES INC EMPLOYEE UNIFORM CLEANING SERVICES 67.69 116871 7/23/2015 657 AT&T E-SCADA 1,549.28 116872 7/23/2015 11233 CALPERS PENSION 368,358.00 116873 7/23/2015 99999 HOLLY CARRINGTON CUSTOMER REFUND -CLOSED ACCOUNT 12.49 116874 7/23/2015 11026 CINTAS CORPORATION Jig EMPLOYEE UNIFORM CLEANING SERVICES 190.81 116875 7/23/2015 1073 CLEAN MACHINE REPAIRS &MAINTENANCE 620.00 116876 7/23/2015 10489 CORELOGIC INFORMATION SOLUTIONS INC LICENSING, MAINTENANCE &SUPPORT 450.00 116877 7/23/2015 39 CROSSROADS CARWASH HAZARDOUS MATERIAL COMPLIANCE 141.21 116878 7/23/2015 99999 GREG DUSTIN CUSTOMER REFUND -CLOSED ACCOUNT 23.45 116879 7/23/2015 193 EASTERN REGIONAL LANDFILL LANDFILL CHARGES 1,835.15 116880 7/23/2015 348 EDGES ELECTRICAL GROUP WATER PRODUCTION METER PROJECT 153.96 116881 7/23/2015 1182 F&D EMBROIDERY EMPLOYEE UNIFORMS 420.99 116882 7J23/2015 736 FACTORY MOTOR PARTS MISC PARTS &SUPPLIES 361.60 116883 7/23/2015 848 FASTENAL FIELD SUPPLIES 60.27 116884 7/23/2015 99999 JAMES FERN CUSTOMER REFUND -CLOSED ACCOUNT 55.85 116885 7/23/2015 1790 FLYERS ENERGY LLC FUEL FOR VEHICLES 5,693.14 116886 7J23/2015 99999 PHYLLIS GARRATT CUSTOMER REFUND -CLOSED ACCOUNT 82.72 116887 7/23/2015 134 HD SUPPLY POWER SOLUTIONS LTD NORTHWOODS 0/H RECONSTRUCTION PHASE 165.81 116888 7/23/2015 7860 HD SUPPLY POWER SOLUTIONS LTD. RECLOSERS, REGULATORS 8c CONTROLS 2,935.46 116889 7/23J2015 1184 INDUSOFT INC. EMPLOYEE DEVELOPMENT 1,695.00 116890 7/23/2015 109 J.L. WINGERTCO. MATERIALS 335.64 116891 7/23/2015 10376 JONES WEST FORD REPAIRS &MAINTENANCE 47.97 116892 7/23/2015 99999 EDNA LAMPPERT CUSTOMER REFUND -CLOSED ACCOUNT 84.00 116893 7/23/2015 99999 CRYSTAL LUNA CUSTOMER REFUND -CLOSED ACCOUNT 47.96 116894 7/23/2015 1161 MADER SUPPLY, LLC MATERIALS 1,434.56 116895 7/23/2015 99999 ROBERT MARK CUSTOMER REFUND -CLOSED ACCOUNT 116.24 116896 7/23/2015 4355 MCCARTHYSIGN CO. MATERIALS 430.00 116897 7/23/2015 99999 AGUESTIN MORALES CUSTOMER REFUND -CLOSED ACCOUNT 29.25 116898 7/23/2015 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 220.88 7 Truckee Donner Public Utility District Check Register July 2015 Check/Trans Date Vendor #Vendor Name Reference Amount 116899 7/23/2015 1175 MT. ROSE HEATING &AIR CONDITIONING, INC SCADA HUB BLDG 15,340.00 116900 7/23/2015 99999 REBECCA NANEY CUSTOMER REFUND -CLOSED ACCOUNT 284.90 116901 7/23/2015 10508 NEVADA COUNTY CLERK -RECORDER OFFICE SUPPLIES 150.00 116902 7/23/2015 999 NORTHWOODS BUILDING LLC MR REFUND 13-744312 104.58 116903 7/23/2015 1079 O'REILLY AUTO PARTS REPAIRS &MAINTENANCE 186.32 116904 7/23/2015 5222 OFFICE DEPOT INC. OFFICE SUPPLIES 72.21 116905 7/23/2015 788 ONTRAC WATER SAMPLE ANALYSIS 67.00 116906 7/23/2015 9504397 PACE SUPPLY INVENTORY 390.81 116907 7/23/2015 99999 LES PEDERSEN CUSTOMER REFUND -CLOSED ACCOUNT 16.07 116908 7/23/2015 166 PENNINGTON CROSSARM COMPANY INVENTORY 2,022.50 116909 7/23/2015 31 POULIN STEEL FA8 INC. COMMUNICATION UPGRADE -RADIOS 8,069.24 116910 7/23/2015 462 POWERPLAN-018 REPAIRS &MAINTENANCE 46.32 116911 7/23/2015 414 PRECISION FLOORING SOLUTIONS INC. BUILDING MAINTENANCE 200.00 116912 7/23/2015 10573 PURCHASE POWER PREPAID POSTAGE 1,020.99 116913 7/23/2015 419 QCS INC. BUILDING MAINTENANCE 1,761.21 116914 7/23/2015 181 SIERRA ENVIRONMENTAL MONITORING INC. WATER SAMPLE ANALYSIS 303.00 116915 7/23/2015 900 SIERRA MOUNTAIN PIPE &SUPPLY INVENTORY 398.44 116916 7/23/2015 837 SIERRA OFFICE SOLUTIONS XEROX COPIER LEASE 216.85 116917 7/23/2015 880 SIERRA VALLEY HOME CENTER RESIDENTIAL ENERGY SURVEY PROGRAM 325.31 116918 7/23/2015 1787 SILVER STATE INTLTRUCK REPAIRS &MAINTENANCE 418.38 116919 7/23/2015 6731 STATE BOARD OF EQUALIZATION USE TAX RETURN 4,274.00 116920 7/23/2015 349 STRADLING YOCCA CARLSON & RAUTH P.C. GC ADMIN COSTS 163.20 116921 7/23/2015 668 SUDDENLINK INTERNETSERVICES 309.95 116922 7/23/2015 6860 TAHOE FOREST HOSPITAL WELlNE55 PROGRAM 2,415.50 116923 7/23/2015 6940 TAHOE TRUCKEE SANITATION AGENCY UTILITIES: SEWER 3,442.50 116924 7/23/2015 1185 TOTAL COMPENSATION SYSTEMS, INC. POST RETIREMENT BENEFITS 1,400.00 116925 7/23/2015 7300 TRUCKEE RENTS INC MATERIALS 101.82 116926 7/23/2015 7320 TRUCKEE TAHOE LUMBER CO MATERIALS 90.45 116927 7/23/2015 448 TRUCKEE TAHOE RADIO LLC MARKETING 2,500.00 116928 7/23/2015 1183 TRUCKEE-CARBON IRRIGATION DISTRICT PURCHASED POWER-TCID 12,867.39 116929 7/23/2015 643 UNITED SITE SERVICES OF NEVADA MATERIALS 566.82 116930 7/23/2015 827 USA LANDLORD CONSERVATION CO MISC CONSERVATION PROJECTS 7,843.00 116931 7/23/2015 682 VERIZON WIRELESS CELL PHONE CHARGES 275.56 116932 7/23/2015 99999 VINEYARD CUSTOMER HOMES CUSTOMER REFUND -CLOSED ACCOUNT 80.00 116933 7/23/2015 7820 WESTERN NEVADA SUPPLY MATERIALS 290.18 116934 7/23/2015 7821 WESTERN NEVADA SUPPLY TOILET EXCHANGE - GARY CHRISTIANSEN 2,032.48 3368 7/30/2015 PAYROLL PAYROLL 175,304.06 3369 7/30/2015 38241CMARETIREMENTTRUST457 ICMACONTRIBUTIONS 7,335.18 3370 7/30/2015 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 77,156.86 3371 7/30/2015 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 15,029.65 3372 7/30/2015 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS 15,520.01 3373 7/30/2015 905 HEALTHEQUITYINC. HSACONTRIBUTION 680.63 13800 7/30/2015 10020 ALPHA ANALYTICAL INC. WATER SAMPLE ANALYSIS 155.00 13801 7/30/2015 9160 MEGAN CAMPE MOVING REIMBURSEMENT 2,536.00 13802 7/30/2015 9503810 CDW GOVERNMENT INC. SCADA HUB SYSTEM 6,688.11 13803 7/30/2015 893 DEBBIE MADERA CLEANING SERVICE BUILDING CLEANING 5,550.00 13804 7/30/2015 52 DELL MARKETING L.P. HARDWARE PURCHASES 3,587.54 13805 7/30/2015 1036 ESCI SAFETY MEETING 1,625.00 13806 7/30/2015 5840 FERGUSON ENTERPRISES INC MATERIALS 182.07 13807 7/30/2015 361 FIRST CHOICE SERVICES FACILITY SUPPLIES 84.87 13808 7/30/2015 3340 GENERAL PACIFIC INC INVENTORY 2,820.46 13809 7/30/2015 3480 GRAINGER INC. 2015 WATER SCADA SYSTEM REPLACEMENT 390.29 13810 7/30/2015 10064 HANSEN SUPPLY COMPANY MATERIALS 122.58 13811 7/30/2015 778 HDR ENGINEERING INC WATER RATE STUDY 3,599.80 13812 7/30/2015 967 INLAND SUPPLY CO FACILITY SUPPLIES 143.08 13813 7/30/2015 986 KELLY-MOORE PAINT CO INC MATERIALS 148.72 13814 7/30/2015 3865 MAIIORY SAFETY &SUPPLY FIELD SUPPLIES 90.95 13815 7/30/2015 820 ONESOURCE DISTRIBUTORS NORTHWOODS 0/H RECONSTRUCTION PHASE 1 1,027.38 13816 7/30/2015 1139 SHI CORP LICENSING, MAINTENANCE &SUPPORT 10,051.09 13817 7/30/2015 10414 SNAP -ON INDUSTRIAL GM TOOL ALLOWANCE 260.38 13818 7/30/2015 6604 SPIEGEL & MC DIARMID PROFESSIONAL SERVICES: FERC ISSUES 7,977.62 13819 7/30/2015 155 THE BANK OF NEW YORK MELLON PROFESSIONAL SERVICES: BONDS 2,500.00 13820 7/30/2015 2025 THE OFFICE BOSS DONNER LAKE SUB REBUILD 2015 774.25 116935 7/30/2015 1135 AIRGAS USA, LLC MATERIALS 248.30 116936 7/30/2015 228 ALLIED ELECTRONICS INC. 2015 WATER SCADA SYSTEM REPLACEMENT 525.9Z 116937 7/30/2015 10825 ANIXTER INC. SCADA HUB SYSTEM 2,228.23 116938 7/30/2015 5860 ARAMARK UNIFORM SERVICES INC MATERIALS 152.94 0 Truckee Donner Puhlic Utility District Check Register July 2015 Check/Trans Date Vendor q Vendor Name Reference Amount 116939 7/30/2015 99999 MARIA LORENA AVILA CUSTOMER REFUND -CLOSED ACCOUNT 45.46 116940 7/30/2015 11233 CALPERS CALPERS CONTRIBUTIONS 44,562.97 116941 7/30/2015 11026 CINTAS CORPORATION it2 EMPLOYEE UNIFORM CLEANING SERVICES 190.81 116942 7/30/2015 1073 CLEAN MACHINE REPAIRS &MAINTENANCE 660.00 116943 7/30/2015 10367 CREATIVE CONCEPTS MARKETING 735.00 116944 7/30/2015 193EASTERNREGIONALLANDFILL LANDFILL CHARGES 520.70 116945 7/30/2015 736 FACTORY MOTOR PARTS MISC PARTS &SUPPLIES 605.02 116946 7/30/2015 10257 FARWESTLINESPECIALTIES, LLC MATERIALS 170.70 116947 7/30/2015 848 FASTENAL WATER PRODUCTION METER PROJECT 93.00 116948 7/30/2015 1790 FLYERS ENERGY LLC MISC PARTS &SUPPLIES 1,592.88 116949 7/30/2015 145 GROVE MADSEN INDUSTRIES SCADA HUB BLDG 110.53 116950 7/30/2015 99999 SUSAN HART CUSTOMER REFUND -CLOSED ACCOUNT 39.19 116951 7/30/2015 10175 HDS WHITE CAP CONST SUPPY MATERIALS 161.49 116952 7/30/2015 10449 HI -LINE UTILITY SUPPLY CO. MATERIALS 148.36 116953 7/30/2015 1184 INDUSOFT INC. 2015 WATER SCADA SYSTEM REPLACEMENT 567.60 116954 7/30/2015 10798 INNOVYZE INC LICENSING, MAINTENANCE &SUPPORT 3,750.00 116955 7/30/2015 71 INQUIP SALES CORPORATION MATERIALS 807.60 116956 7/30/2015 22 JOHNSTONE SUPPLY MATERIALS 114.72 116957 7/30/2015 44444 KEITH ABRAHAMS SOLAR REBATE 7,650.00 116958 7/30/2015 4149 KORTICK MANUFACTURING COMPANY MATERIALS 324.90 116959 7/30/2015 44444 LENNI CHARTER SOLAR REBATE 7,650.00 116960 7/30/2015 99999 JOSEPH MICHELUCCI CUSTOMER REFUND -CLOSED ACCOUNT 115.02 116961 7/30/2015 1068 MONITOR PREMIUMS LEARN OR BURN EXPENSES 606.09 116962 7/30/2015 4720 MOUNTAIN HARDWARE AND SPORTS SCADA HUB BLDG 191.54 116963 7/30/2015 5200 NORTHWEST PUBLIC POWER ASSOCIATION EMPLOYEE DEVELOPMENT 1,410.00 116964 7/30/2015 5151 NRECA HEALTH 125 & HRA ADMINISTRATIVE FEES 270.00 116965 7/30/2015 1079 O'REIIIY AUTO PARTS 2015 WATER SCADA SYSTEM REPLACEMENT 46.26 116966 7/30/2015 1920OFFICEMAX-ABOISECOMPANY OFFICESUPPLIES 280.05 116967 7/30/2015 9722 VISION VISION 289.31 116968 7/30/2015 322 POLLARDWATER.COM MATERIALS 60.76 116969 7/30/2015 31 POULIN STEEL FAB INC. STRAND BOOSTER STATION MANIFOLD REPLACE 2,873.52 116970 7/30/2015 884 ROAD SAFE CONSTRUCTION, INC. NORTH WOODS O/H RECONSTRUCTION PHASE 1 8,503.95 116971 7/30/2015 1034 SCHNEIDER ELECTRIC IT USA, INC SCADA HU8 SYSTEM 2,524.00 116972 7/30/2015 656 SCO PLANNING 8c ENGINEERING INC SITE SURVEY 575.00 116973 7/30/2015 181 SIERRA ENVIRONMENTAL MONITORING INC. WATER SAMPLE ANALYSIS 455.00 116974 7/30/2015 28 SIERRA FREIGHTLINER STERLING WESTERN REPAIRS &MAINTENANCE 81.95 116975 7/30/2015 900 SIERRA MOUNTAIN PIPE &SUPPLY INVENTORY 315.84 116976 7/30/2015 837 SIERRA OFFICE SOLUTIONS CONSERVATION XEROX 323.06 116977 7/30/2015 880 SIERRA VALLEY HOME CENTER SAFETY SUPPLIES 43.00 116978 7/30/2015 6445 SIERRA WELDING SUPPLY CO MATERIALS 179.07 116979 7/30/2015 1787 SILVER STATE INTLTRUCK REPAIRS &MAINTENANCE 4,458.79 116980 7/30/2015 6731 STATE BOARD OF EQUALIZATION ELECTRICAL ENERGY SURCHARGE 9,348.73 116981 7/30/2015 999 ROBERT SWENSON MR REFUND 15-63731 527.56 116982 7/30/2015 6880 TAHOE INSTANT PRESS OFFICE SUPPLIES 26.12 116983 7/30/2015 7040 TEICHERT &SON INC CREDIT DE MATERIALS 278.78 116984 7/30/2015 44444 TODD POWELL SOLAR REBATE 7,504.45 116985 7/30/2015 10284 UNITED RENTALS DROUGHT REGULATION COMPLIANCE 1,085.76 116986 7/30/2015 682 VERIZON WIRELESS CELL PHONE CHARGES 3,363.76 116987 7/30/2015 7740 WEDCO INC HARDWARE PURCHASES 987.47 116988 7/30/2015 7820 WESTERN NEVADASUPPLY INVENTORY 529.82 385 3,744,883.36 7 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 6/30/15 Balance in General Fund 05/31/15 Receipts: Revenue received Record interest earned Retired employees medical insurance UPTIF Investment Disbursements: Accounts payable disbursements Voided check from prior period Transfer to Capital Reserve Fund Transfer to Electric Rate Reserve Fund Restrict Glenshire water monthly surcharge Restrict Donner Lake surcharge Restrict facilites fees Section 125 benefit disbursement Bank charges Total Disbursements Balance in General Fund 6/30/15 Electric Dept Water Dept Total $5,312,503.01 $2,764,784.24 $8,077,287.25 2,068,633.78 934,301.77 3,002,935.55 667.39 615.20 1,282.59 8,896.02 0.00 8,896.02 300,000.00 100,000.00 400,000.00 $2,378,197.19 $1,034,916.97 $3,413,114.16 2,680,383.97 (47,208.50) 25,022.84 35,543.92 0.00 0.00 17,476.75 9,444.63 4,117.73 $2,724,781.34 1,272,155.69 0.00 0.00 0.00 7,120.75 9,018.33 54,050.25 0.00 0.00 $1,342,345.02 3,952,539.66 (47,208.50) 25,022.84 35,543.92 7,120.75 9,018.33 71,527.00 9,444.63 4,117.73 $4,067,126.36 $4,965,918.86 $2,457,356.19 $7,423,275.05 10 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 6/30/15 Distribution of Non -Restricted Funds At Month -End: Customer Services Operating Funds U.S. Bank -General Fund LAIF, UPTIF &PCIF -General Fund Total Non -Restricted Funds Distribution of Restricted Funds at Month -End: LAIF, UPTIF &PCIF -Restricted Funds UPTIF - TDPUD Prop 55 Reserve Fund UPTIF - Glenshire Water Loan Repayment UPTIF -Donner Lake Assessment District Donner Lake Federal Farm Credit Account U S Bank -Donner Lake Assessment District 00-1 Total Restricted Funds Total Funds Available Electric Dept Water Dept Total $2,400.00 956,158.88 4,007,359.98 $0.00 0.00 2,457,356.19 $2,400.00 956,158.88 6,464,716.17 $4,965,918.86 $2,457,356.19 $7,423,275.05 $8,972,477.44 0.00 0.00 0.00 0.00 0.00 $6,557,064.34 311, 693.34 215,500.13 981,395.85 1,698,879.92 941.65 $15,529,541.78 311,693.34 215,500.13 981,395.85 1,698,879.92 941.65 $8,972,477.44 $9,765,475.23 $18,737,952.67 $13,938,396.30 $12,222,831.42 $26,161,227.72 11 INVESTMENT STATUS REPORT Activity for the Month Ended 6/30/15 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.30% General Fund 1..136.1 LAIF transfers Consolidate cash Total LAIF Electric Investments 05/30/15 Activity 6/15 06/30/15 $4, 059, 823.13 (1,400,000.00) 337,853.92 $4,059,823.13 (1,062,146.08) $2,997,677.05 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.56% General Fund 1..136.12 $109,127.66 Budgeted transfer to Electric Rate Reserve (35,543.92) Budgeted transfer to Capital Reserve (25,022.84) Restrict facilites fees (17,476.75) Reimburse for AB32 (233,510.00) UPTIF transfers 300,000.00 Record monthly interest 73.60 Facilities Fees 1..136.9 266,429.32 Restrict facilites fees 17,476.75 Record monthly interest 119.54 Electric Rate Reserve Fund 1..136.45 900,667.77 Budgeted transfer to Electric Rate Reserve 35,543.92 Record monthly interest 408.69 Capital Replacement Fund 136.46 1,963,544.26 Budgeted transfer to Capital Reserve 25,022.84 Record monthly interest g15,77 Electric Vehicle Reserve 1..136.13 369,473.96 Record monthly interest 187.41 AB 32 Cap &Trade Fund 1..136.58 1,072,810.23 233,510.00 Record monthly interest 506.80 Total UPTIF Electric Investments ,053.20 ,211.81 PLACER COUNTY INVESTMENT FUND (PCIF) - 1.00% Electric General Fund PC1..136.49 $911,441.39 Record monthly interest 593.79 Electric Rate Reserve Fund 1..136.47 2,874,151.77 Record monthly interest 1,870.49 Capital Replacement Fund 1..136.48 Record monthly interest Total PCIF County Electric Investments Total Electric Investments 1,209,050.31 $4,994,643 787.61 251.89 97,647.75 284,025.61 936,620.38 1,989,482.87 369,661.37 1,306,827.03 4.984.265.01 912,035.18 2, 876, 022.26 1 09,837.92 97.895.36 $13,736,519.80 ($756,682.38) $12,979,837.42 INVESTMENT STATUS REPORT Activity for the Month Ended 6/30/15 WATER FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.30% 05/30/15 Activity 6/15 06/30/15 General Fund 2..136.1 $1,695,083.17 Consolidate cash (337.853.92) Total LAIF Electric Investments $1,695,083.17 ($337,853.92) $1,357,229.25 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.56% General Fund 2..136.12 Transfer to DLAD surcharge Restrict Glenshire water revenue received Restrict facilites fees UPTIF transfers Record monthly interest Facilities Fees 2..136.25 Restrict facilites fees Record monthly interest Capital Replacement 2..136.46 Record monthly interest DSC and Operating Reserve Fund 2..136.47 Record monthly interest Reserve for Future Meters 2..136.51 Record monthly interest West River St. Assessment District 2..136.31 Record monthly interest Prepaid Connection Fees 2..136.7 Record monthly interest Glenshire Loan Repayment Fund 2..136.87 Restrict Glenshire water revenue received Record monthly interest Donner Lake Assessment District Fund 2..136.84 Record monthly interest Reimburse for SRF debt payment Donner Lake Assessment District Surcharge Fund 2..136.61 DLAD surcharge collections Record monthly interest TSA SAD II Improvement Fund 2..136.85 Record monthly interest Prop 55 2..125.94 Record monthly interest Water Vehicle Reserve 2..136.13 Record monthly interest Total UPTIF Water Investments PLACER COUNTY INVESTMENT FUND (PCIF) - 1.00% Water General Fund PC 2..136.5 Record monthly interest DSC and Operating Reserve Fund 2..136.49 Record monthly interest Capital Replacement Fund 2..136.48 Record monthly interest Total PCIF Water Investments Total Water Investments Total LAIF Investments Total UPTIF Investments Total PCIF Investments Total Investments $158,259.68 641,005.22 184, 801.12 257,759.75 796,641.02 34, 801.31 79,582.52 208,264.65 115,003.29 16,788.75 311, 546.16 282,663.94 (9.018.33) (7,120.75j (54,050.25) 100,000.00 21.41 54,050.25 288.34 87.30 121.77 376.34 16.44 37.60 7,120.75 114.73 505.89 9,018.33 50.07 7.93 147.18 146.76 88,091.76 695,343.81 184,888.42 257,881.52 797,017.36 34,817.75 79,620.12 215, 500.13 981,395.85 124,071.69 16, 796.68 311,693.34 282, 810.70 $4,068,007.37 $101,921.76 $4,169,929.13 $911,441.39 3,383,483.26 697,674.95 593.79 912,035.18 2,203.47 3,385,686.73 454.61 698,129.56 $4,992,599.60 $3,251.87 $4,995,851.47 $10,755,690.14 ($232,680.29) $10,523,009.85 5,754,906.30 (1,400,000.00) 4,354,906.30 8,750,060.57 404,133.57 9,154,194.14 9,987,243.07 6,503.76 9,993,746.83 $24,492,209.94 ($989,362.67) $23,502,847.27 13 rncoco rn nco rnvvmaonmoomNornnrco N d' N CO N r V C7 CO N O (h n M O m m Q1 O (O C'') C7 (O 0� n � M N O to O OJ (D V1 (`] O W C7 n 00 (O If7 V N m m O W � to r CJ C7 n V 0) N N E OJ r (O N r (D N m M O (h C'7 Ol O W 7 m (7 n r O N Ol (O r N � OJ N CO r ('J ('l � � (D u� 00 (O n N m .- O r N C� VM (7 (7 r� N M r r F � � N ffl �_� = o � in O ao U o m o 0 0 0 0 0 Y (7 -'' .- Z ¢ Y � rn pp U �» N W � � _ � U H a o 0 0 0 0 0 0 J p � a w „ w � m W U W � � W LL 0 0 0 0 0 0 0 W = � } � O F S � a a w � p H �`' z }= o 0 0 0 0 0 0 w�� � a¢ o[ w W S � u7 p f- p W N W j o aVm ¢ Q� O T o 0 0 o rn o 0 � = e» Z Q d Z J o c+� Z(D � �Z � Z W � � � W � w O S � Q o j W O � � mcnocoorn F Z O C V N N M (D N y U 7 _ (D O (O V (O OJ Q � W nv(O m mO O C p p m 00 (`] M O O d W � Efl N O 01 (`7 (7 t E o � r r � � � m � c T �f 7 0 N N O O O M N M C T O O a0 7 _ N (O m O o O n 0 U O m O N � � N r U � W � a n 0 0 0 0 0 0 n > (D o O rn W O m m J O � N EH c W E N C C N � a w � � c � W � j C LL y W N v G � A N � ._ G H Zc w w `-° '�'E � 7 LL N W O O C W LL W S S > U Ate; c,`LL S N C: r ' N � v'o y'ac �r� Jis liWUn.WQ W O O (00 COO � M � r (MO O O In N O r O N 00 (`7 C'7 to U7 N n N O) 7 V n n V ['l n 0 u] m O N N O N N EA FA V V � V3 � � EA EA M M 0 Ffl 0 0 0 0 0 0 0 0 0 0 0 C9 O O O OJ O ffl O EA O Efl O 69 CO O Efl O O Efl O] (D (O O O V V V V �, �, O O O O O O O O O N O O O O O O N O O O O O O O FA V d' fR 69 ffl EA O ffl Efl O m m r .- � � rn rn � � 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o m rn n n <» oo w e» e» e» f» w n rn n �n O7 of N V N n (O W CO N r m O T � N (O CO (D N m r r � � r � � � 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 EA o o ffl fA Efl EA o ffl EA O n n n n In Ui LLi N � � � oFn0000000000000000� ova 0� � ov � �000� � o� m m m � � W � 0 0 0 0 N N N N 64 ER EA fA o� o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0� o0 0� o� rn o� o o� rn 00 0 o c%� c%� v v v v rn rn rn rn E» e» c» f» N V O W N n W 0 0 CO N O O n r C7 m O O O O V O O O V Ol 7 0] 00 N O m n OJ 01 N EA Efl EA ffl OJ V3 fR m OM 0]N OOJ (O lf) (hO n m (O m o]� V nnvrnv] V cON�m 7 V W Ol (O � 01 M n r ap T r W (O lf] Ln (O N n N Ol N (`] v� � � � � 0 0 0 n O 0 0 0 0 0 0 0 0 0 0 r O O O O n CJ r N � r Vi ffl fH FA O (WO W n m� M V N m M m m � V � ONO � (D (7 m m � Efl 01 M V m O 69 fA EA m 0� 0 0 0 0 0 0 0 0 0 .-- O O O� O O N N lf] � O� O N U � � O (D V (00 (O W S N � n C'�] O (O (D LL] ("7 V � v In � O (D N (O (O 00 EA � M M m n O n n n n r � Efl Efl ffl � � a rn m O C 7 O N C N rn w � o � E y > `m E U v N E v C V W N (� N E O y Y � 1q 'O 7 10 W (n C v a E O Q a � u p (7 'a Q � C a u u u E p C7 � Q w 10 7 10 C '� � � N O N Z N « y Y Y Y LL p LL w a a c > O c N c w Y� �o w ,c>ac �ppp �? c 3¢ O B E ��� E C y v N v C C C y Z O S O N y 0 N ii v °1 E v E m w v m y � w � U w > �}'« > �� NLL � a a vEi E� c� � � �n � c F y a m c C� y C O. N N Vl d N 7 CS } Z `/ O W E` N �¢ N N vOi O N W m p � Q N � W O E F N E 1. 7 Q U N Ul N W O _J O ¢ O O � 7 7 �a ayi c m v�i c cQQQ E� �F- O F (7 H H N aUU H �a y p 7 lL LL 6 O' �� � J Y Y Y N_ V� � N � Z W NO'5��.- dU `JJJa_L W O O O W E '�+ U 10 �> W' Q y N N N lL f¢!/ i N S Q F �c'�c'cU�y°-ccccWQ«�O- O O W W y m o to fn N v E� 0 0 0 S V) m � J J Y a C7LLNUp¢�aC7pppNF-pia W W Q � � � 14