Loading...
HomeMy WebLinkAbout2020-07 Treasurers ReportTRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER'S REPORT July 15, 2020 Fund Balances for the Month Ended May 31, 2020 And Disbursements for the Month Ended June 30, 2020 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the month ending May 31, 2020 and disbursements for June 2020. 1) REQUEST FOR APPROVAL OF DISBURSEMENTS The total disbursements for June 2020 were $3,161,913.83. 2) CHECK SUMMARY The attached listing of checks and ACH payments issued during June 2020 total $3,161,913.83. 3) STATEMENT OF GENERAL FUND: As of May 31, 2020 the balance in the General Fund was $12,259,251 (Electric $9,555,100 and Water $2,704,150). 4) FUNDS STATUS REPORT: 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 April 30, 2020 was $34,156,921 ($23,705,527 electric and $10,451,394 water). 5) INVESTMENT STATUS REPORT: 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 rates for the last 13 months were: 1 YR T- LAIF PCIF UPTIF BILL May 2019 2.45% 2.12% 2.90% 2.15% June 2019 2.43% 2.03% 2.90% 1.87% July 2019 2.38% 2.08% 2.87% 1.94% August 2019 2.34% 1.96% 2.73% 1.72% September 2019 2.28% 1.96% 2.60% 1.71 % October 2019 2.19% 1.84% 2.54% 1.49% November 2019 2.10% 1.93% 2.40% 1.56% December 2019 2.04% 1.70% 2.28% 1.55% January 2020 1.97% 1.78% 2.20% 1.41 % February 2020 1.91 % 1.80% 2.10% 0.95% March 2020 1.79% 1.54% 1.66% 0.17% April 2020 1.65% 1.23% 1.44% 0.16% May 2020 1.36% 1.19% 1.19% 0.17% 6) STATUS OF INVESTMENTS: 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 May 31, 2020, is $40,881,937 including a cumulative market adjustment of $116,129. TRUCKEE DONNER PUBLIC UTILITY DISTRICT Request for Approval of Disbursements The disbursements of the Truckee Donner Public Utility District for the month of June 2020 totaled $3,161,913.83. A listing of those disbursements is attached. Truckee Donner Public Utility District Check Register June 2020 Check/Tran Date Vendor 28249 6/4/2020 5440 28250 6/4/2020 1359 28251 6/4/2020 145 28252 6/4/2020 4400 28253 6/4/2020 524 28254 6/4/2020 893 28255 6/4/2020 10650 28256 6/4/2020 3340 28257 6/4/2020 10008 28258 6/4/2020 10376 28259 6/4/2020 1043 28260 6/4/2020 4720 28261 6/4/2020 5130 28262 6/4/2020 820 28263 6/4/2020 5070 28264 6/4/2020 6402 28265 6/4/2020 10414 28266 6/4/2020 26 28267 6/4/2020 1328 28268 6/4/2020 890 28269 6/4/2020 10584 28270 6/4/2020 10737 28271 6/4/2020 1321 128647 6/4/2020 10360 128648 6/4/2020 1181 128649 6/4/2020 134 128650 6/4/2020 657 128651 6/4/2020 2420 128652 6/4/2020 44444 128653 6/4/2020 9381 128654 6/4/2020 99999 128655 6/4/2020 3349 128656 6/4/2020 905 128657 6/4/2020 115 128658 6/4/2020 6401 128659 6/4/2020 9665 128660 6/4/2020 1205 128661 6/4/2020 5151 128662 6/4/2020 5150 128663 6/4/2020 1079 128664 6/4/2020 95 128665 6/4/2020 99999 128666 6/4/2020 10331 128667 6/4/2020 11226 128668 6/4/2020 10761 128669 6/4/2020 11304 128670 6/4/2020 719 128671 6/4/2020 643 128672 6/4/2020 682 128673 6/4/2020 9982 128674 6/4/2020 99999 28336 6/10/2020 5440 28337 6/10/2020 736 28338 6/10/2020 9347 28339 6/10/2020 3480 28340 6/10/2020 4720 28341 6/10/2020 820 28342 6/10/2020 9504397 28343 6/10/2020 1372 28344 6/10/2020 6880 28345 6/10/2020 6360 28346 6/10/2020 7176 28347 6/10/2020 1321 128675 6/10/2020 134 128676 6/10/2020 5860 128677 6/10/2020 657 128678 6/10/2020 240 128679 6/10/2020 99999 128680 6/10/2020 1426 128681 6/10/2020 99999 128682 6/10/2020 348 128683 6/10/2020 1433 128684 6/10/2020 99999 128685 6/10/2020 1240 128686 6/10/2020 1330 128687 6/10/2020 99999 128688 6/10/2020 99999 128689 6/10/2020 10508 128690 6/10/2020 1079 128691 6/10/2020 5222 128692 6/10/2020 10455 128693 6/10/2020 99999 128694 6/10/2020 734 128695 6/10/2020 900 128696 6/10/2020 11001 128697 6/10/2020 548 128698 6/10/2020 242 Vendor Name ALTEC INDUSTRIES INC CALPERS CODALE ELECTRIC SUPPLY, INC COOPER POWER SYSTEMS DE LAGE LANDEN OPERATIONAL SERVICES LLC DEBBIE MADERA CLEANING SERVICE EUROFINS EATON ANALYTICAL INC. GENERAL PACIFIC INC HOSE & FITTINGS ETC JONES WEST FORD L & J INDUSTRIAL STAPLES INC. MOUNTAIN HARDWARE AND SPORTS NCPA ONESOURCE DISTRIBUTORS PLATT SIERRA PACIFIC POWER CO SNAP -ON INDUSTRIAL THE BANK OF NEW YORK MELLON TRAFFIC MANAGEMENT, INC. TRI SAGE CONSULTING UAMPS US BANK GOVERNMENT SERVICES WRIGHT TREE SERVICE, INC. AFLAC AMAZON/SYNCB ANIXTER INC. AT&T CALIFORNIA MUNICIPAL UTILITIES ASSN CRYSTAL BOUTELLE CHARLES GAZSO LYNN GILLETTE GLOBAL RENTAL CO INC HEALTHEQUITY INC. KIMBALL-MI D W EST LIBERTY UTILITIES EMPLOYEE MICRO MOTION INC NRECA NRECA GROUP BENEFITS TRUST O'REILLYAUTO PARTS OKONITE COMPANY MARK PRICE RENO BUSINESS INTERIORS SHRED -IT USA LLC SOUTHWEST GAS CORP. STELLA-JONES CORPORATION T-MOBILE UNITED SITE SERVICES OF NEVADA VERIZON WIRELESS CLAY WALKER MARK WASLEY ALTEC INDUSTRIES INC FACTORY MOTOR PARTS CHARLES W FILLMAN IV GRAINGER INC. MOUNTAIN HARDWARE AND SPORTS ONESOURCE DISTRIBUTORS PACE SUPPLY POWER PARTNERS, INC. TAHOE INSTANT PRESS THATCHER COMPANY OF CALIFORNIA, INC TRANSWORLD SYSTEMS INC WRIGHT TREE SERVICE, INC. ANIXTER INC. ARAMARK UNIFORM SERVICES INC AT&T AUDIO ON -HOLD COREY AVES CONVERGINT TECHNOLOGIES ROWAN CRUICKSHANK EDGES ELECTRICAL GROUP FRANK OLSEN JOSEPH GRAVELL JUST IMAGINE MARKETING & DESIGN LIBERTY UTILITIES DALE LIVEZEY DAVID MCCARTHY NEVADA COUNTY CLERK -RECORDER O'REILLYAUTO PARTS OFFICE DEPOT INC. OSMOSE UTILITIES SERVICES INC. MARK PRICE SHEPHERD'S AUTO BODY SIERRA MOUNTAIN PIPE & SUPPLY SPARKS ELECTRIC MOTOR REPAIR THE AUTO & TIRE DOCTOR INC. THOLL FENCE INC. Reference MATERIALS POST RETIREMENT BENEFITS MATERIALS RECLOSERS REGULATORS CONTROLS & SWITCHES XEROX COPIER LEASE BUILDING CLEANING WATER SAMPLE ANALYSIS METERS PURCHASE MISC PARTS & SUPPLIES REPAIRS & MAINTENANCE MATERIALS MATERIALS MEMBERSHIP DUES INVENTORY MATERIALS PURCHASED POWER - SPPC OFFICE SUPPLIES 2016 REFUNDING SIDE FUND NORTHWOODS REBUILD CHAMONIX-MUHLEBACH TRUCKEE SUBSTATION CONTROL PURCHASED POWER - UAMPS CREDIT CARD CHARGES CONTRACT SERVICES: ROW TREE CLEARING EMPLOYEE PAID INSURANCE OFFICE SUPPLIES INVENTORY COMMUNICATIONS MEMBERSHIP DUES APPLIANCE REBATE: ELECTRIC CELL PHONE REIMBURSEMENT 1/1/20-6/1/20 CUSTOMER REFUND - CLOSED ACCOUNT MATERIALS HSA ADMINISTRATIVE FEES MECHANICS TOOLS: PUD ELECTRIC FOR PUMP STATION VISION REIMBURSEMENT WATER PRODUCTION METER PROJECT HEALTH 125 ADMINISTRATIVE FEES INSURANCE REPAIRS & MAINTENANCE INVENTORY CUSTOMER REFUND - CLOSED ACCOUNT OFFICE SUPPLIES OFFICE SUPPLIES UTILITIES: NATURAL GAS INVENTORY SANDEL-AVERY ALARM MATERIALS CELL PHONE CHARGES EMPLOYEE DEVELOPMENT CUSTOMER REFUND - CLOSED ACCOUNT MATERIALS MISC PARTS & SUPPLIES DMV PHYSICAL FIELD SUPPLIES 2020 WATER SCADA SYSTEM REPLACEMENT INVENTORY INVENTORY PURCHASE TRANSFORMER OFFICE SUPPLIES WATER QUALITY: TREATMENT COLLECTION SERVICES CONTRACT SERVICES: ROW TREE CLEARING INVENTORY EMPLOYEE UNIFORM CLEANING SERVICES COMMUNICATIONS ON -HOLD PHONE SYSTEM CUSTOMER REFUND - CLOSED ACCOUNT SECURITY CAMERA SOFTWARE UPGRADE CUSTOMER REFUND - CLOSED ACCOUNT 2020 WATER SCADA SYSTEM REPLACEMENT WATER PRODUCTION METER PROJECT CUSTOMER REFUND - CLOSED ACCOUNT PROFESSIONAL SERVICES: MARKETING MARTIS WOODS PUMP STATION REPLACEMENT CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT ELECTION EXPENSES MISC PARTS & SUPPLIES FACILITY SUPPLIES LICENSING, MAINTENANCE & SUPPORT CUSTOMER REFUND - CLOSED ACCOUNT REPAIRS & MAINTENANCE MATERIALS MATERIALS REPAIRS & MAINTENANCE MATERIALS Amount 82.71 9,243.00 2,310.76 19,627.84 1,573.02 6,100.00 3,500.00 58,366.67 263.59 1,025.45 530.67 18.50 11,237.00 9,022.02 864.95 52,304.83 6,913.32 177,904.37 5,790.75 42,612.50 748,421.14 9,204.02 23,311.20 1,113.96 2,671.70 10,616.92 1,464.57 23,545.00 200.00 270.00 163.33 4,415.64 66.30 161.96 190.03 200.98 5,177.02 17,755.14 196,844.78 5.94 62,809.43 60.11 6,204.50 85.00 903.85 19,639.87 38.26 681.80 6,519.36 296.00 169.59 4,818.45 165.00 294.69 52.77 7,794.04 510.80 4,332.17 256.26 876.86 74.83 37,040.72 4,086.75 78.18 416.60 79.00 197.70 31,873.59 276.58 3,166.18 6,344.72 168.91 1,275.00 7,639.00 118.41 49.13 50.00 280.01 49.15 495.00 57.24 1,024.56 9.14 3,018.88 1,069.78 2,193.62 Truckee Donner Public Utility District Check Register June 2020 Check/Tran Date Vendor 128699 6/10/2020 7175 128700 6/10/2020 7290 128701 6/10/2020 11041 128702 6/10/2020 7320 128703 6/10/2020 7820 4707 6/11/2020 PL 4711 6/11/2020 3824 4712 6/11/2020 11233 4713 6/11/2020 7310 4714 6/11/2020 540 4715 6/11/2020 905 4716 6/11/2020 3094 28348 6/19/2020 856 28349 6/19/2020 549 28350 6/19/2020 5440 28351 6/19/2020 1360 28352 6/19/2020 829 28353 6/19/2020 577 28354 6/19/2020 9304 28355 6/19/2020 1167 28356 6/19/2020 1036 28357 6/19/2020 10650 28358 6/19/2020 3340 28359 6/19/2020 3480 28360 6/19/2020 778 28361 6/19/2020 10008 28362 6/19/2020 3820 28363 6/19/2020 10798 28364 6/19/2020 1305 28365 6/19/2020 9637 28366 6/19/2020 965 28367 6/19/2020 4720 28368 6/19/2020 289 28369 6/19/2020 820 28370 6/19/2020 5730 28371 6/19/2020 1013 28372 6/19/2020 181 28373 6/19/2020 1787 28374 6/19/2020 1405 28375 6/19/2020 1328 28376 6/19/2020 712 28377 6/19/2020 973 28378 6/19/2020 448 28379 6/19/2020 1183 28380 6/19/2020 10380 28381 6/19/2020 10737 28382 6/19/2020 320 28383 6/19/2020 1321 128704 6/19/2020 1414 128705 6/19/2020 134 128706 6/19/2020 5860 128707 6/19/2020 6731 128708 6/19/2020 1073 128709 6/19/2020 10489 128710 6/19/2020 2471 128711 6/19/2020 10367 128712 6/19/2020 39 128713 6/19/2020 348 128714 6/19/2020 1432 128715 6/19/2020 1790 128716 6/19/2020 186 128717 6/19/2020 277 128718 6/19/2020 99999 128719 6/19/2020 405 128720 6/19/2020 10932 128721 6/19/2020 1247 128722 6/19/2020 1176 128723 6/19/2020 1132 128724 6/19/2020 6401 128725 6/19/2020 468 128726 6/19/2020 44444 128727 6/19/2020 11025 128728 6/19/2020 99999 128729 6/19/2020 617 128730 6/19/2020 2234 128731 6/19/2020 1079 128732 6/19/2020 5222 128733 6/19/2020 9722 128734 6/19/2020 99999 128735 6/19/2020 846 128736 6/19/2020 10331 128737 6/19/2020 392 128738 6/19/2020 1436 128739 6/19/2020 837 128740 6/19/2020 835 128741 6/19/2020 99999 128742 6/19/2020 716 Vendor Name TRANSWORLD SYSTEMS INC TRUCKEE OVERHEAD DOOR TRUCKEE PAINT MART INC. TRUCKEE TAHOE LUMBER CO WESTERN NEVADA SUPPLY PAYROLL ICMA RETIREMENT TRUST 457 CALPERS INTERNAL REVENUE SERVICE CALPERS 457 DEFERRED COMP PRGM HEALTHEQUITY INC. EMPLOYMENT DEV DEPT ACLARA TECHNOLOGIES LLC ALLCAL EQUIPMENT SERVICES INC ALTEC INDUSTRIES INC AMERICAN PUBLIC POWER ASSOCIATION CDS GLOBAL COOPERATIVE RESPONSE CENTER INC. NICHOLAS DEHERRERA EAST RIVER PR ESCI EUROFINS EATON ANALYTICAL INC. GENERAL PACIFIC INC GRAINGER INC. HDR ENGINEERING INC HOSE & FITTINGS ETC IBEW LOCAL 1245 INNOVYZE INC JW WELDING SUPPLIES & TOOLS CONRAD KRAUSS MOSSADAMS MOUNTAIN HARDWARE AND SPORTS NISC ONESOURCE DISTRIBUTORS PORTER SIMON SIERRA ENERGY PROFESSIONALS SILVER STATE ANALYTICAL LABORATORIES, IN SILVER STATE INTERNATIONAL TRUCKS SSP INNOVATIONS, LLC TRAFFIC MANAGEMENT, INC. TRUCKEE DONNER PUD TRUCKEE TAHOE HOME IMPROVEMENT LLC TRUCKEE TAHOE RADIO LLC TRUCKEE-CARSON IRRIGATION DISTRICT ULINE US BANK GOVERNMENT SERVICES W & T GRAPHICS WRIGHT TREE SERVICE, INC. ALPINE SMITH, INC. ANIXTER INC. ARAMARK UNIFORM SERVICES INC CALIFORNIA DEPARTMENT OF TAX AND FEE CLEAN MACHINE CORELOGIC INFORMATION SOLUTIONS INC CPS HR CONSULTING CREATIVE CONCEPTS MEDIA CROSSROADS CARWASH EDGES ELECTRICAL GROUP FARR WEST ENGINEERING FLYERS ENERGY LLC GRANITE CONSTRUCTION COMPANY HACH COMPANY RONALD HUGGINS IN -SITU INC. J & L FOOD MART & CARWASH JACK HENRY & ASSOCIATES, INC CHRISTINE F JACKSON, O.D. LEAF LIBERTY UTILITIES MAITA CHEVROLET MARY RODERIGUE MOONSHINE INK STACY MOOREHOUSE MOUNTAIN EAP NORTH VALLEY RESOURCE MANAGEMENT O'REILLYAUTO PARTS OFFICE DEPOT INC. EMPLOYEE PETER LAMONICA REAL GRAPHIC RENO BUSINESS INTERIORS RYAN HERCO PRODUCTS CORP SACTOWN CONTRACTORS CORP SIERRA OFFICE SOLUTIONS SIERRA WATERSHED EDUCATION PARTNERSHIPS JULIANNE SIMMONS SMALLPOND STUDIO Reference COLLECTION SERVICES BUILDING MAINTENANCE HYDRANT MAINTENANCE MATERIALS HIT AND RUN PMS 69 MATERIALS PAYROLL DIRECT DEPOSIT ICMA CONTRIBUTIONS PPE 06/05/2020 PENSION CONTRIBUTIONS PPE 06/05/2020 FEDERAUFICA WITHHOLDING PPE O6/05/2020 CALPERS 457 CONTRIBUTIONS PPE O6/05/2020 EMPLOYEE HSA CONTRIBUTIONS PPE 06/05/20 SDI/STATE WITHHOLDING PPE O6/05/2020 METER PURCHASE ENVIRONMENTAL COMPLIANCE MATERIALS MEMBERSHIP DUES REMITTANCE PROCESSING ANSWERING SERVICE EMPLOYEE DEVELOPMENT PROFESSIONAL SERVICES: MARKETING SAFETY MEETING WATER SAMPLE ANALYSIS EMPLOYEE UNIFORMS MATERIALS PROFESSIONAL SERVICES: ENGINEERING MISC PARTS & SUPPLIES UNION DUES LICENSING, MAINTENANCE & SUPPORT MATERIALS EMPLOYEE DEVELOPMENT PROFESSIONAL SERVICES - AUDIT MATERIALS APRIL 2020 RECURRING INVOICE INVENTORY PROFESSIONAL SERVICES: GENERAL COUNSEL RESIDENTIAL ENERGY SURVEY PROGRAM WATER SAMPLE ANALYSIS MISC PARTS & SUPPLIES MOBILE GIS UPGRADE & S/O INTEG NORTHWOODS REBUILD CHAMONIX-MUHLEBACH PURCHASED POWER - STAMPEDE HYDRO GEN REFRIGERATOR RECYCLE MARKETING PURCHASED POWER - TCID MATERIALS CREDIT CARD CHARGES EMPLOYEE UNIFORMS CONTRACT SERVICES: ROW TREE CLEARING REPAIRS & MAINTENANCE MATERIALS MATERIALS SALES TAX PAYABLE REPAIRS & MAINTENANCE LICENSING, MAINTENANCE & SUPPORT PROFESSIONAL SERVICES: OTHER MARKETING REPAIRS & MAINTENANCE 2020 WATER SCADA SYSTEM REPLACEMENT FACILITIES METERING IMPROVEMENTS FUEL FOR VEHICLES MATERIALS WATER SAMPLE ANALYSIS CUSTOMER REFUND - CLOSED ACCOUNT 2020 WATER SCADA SYSTEM REPLACEMENT REPAIRS & MAINTENANCE BANKING CHARGES VISION: EMPLOYEE XEROX COPIER LEASE ELECTRIC FOR PUMP STATION REPAIRS & MAINTENANCE APPLIANCE REBATE - ELECTRIC MARKETING CUSTOMER REFUND - CLOSED ACCOUNT WELLNESS PROGRAM PROFESSIONAL SERVICES: OTHER REPAIRS & MAINTENANCE OFFICE SUPPLIES VISION: EMPLOYEE REFUND OVERPAYMENT MATERIALS OFFICE SUPPLIES MATERIALS WAREHOUSE LIGHTING UPGRADE PROJECT XEROX COPIER LEASE EDUCATIONAL CONSERVATION CUSTOMER REFUND - CLOSED ACCOUNT PROFESSIONAL SERVICES: MARKETING Amount 36.36 145.00 56.52 163.05 10,204.48 194,390.84 17,178.57 54,371.94 100,029.44 18,923.23 417.01 22,310.54 216,785.25 4,300.00 72.96 822.00 882.67 3,103.66 786.00 1,850.00 1,443.75 1,700.00 215.62 388.20 1,357.00 340.84 6,742.40 4,220.00 201.38 786.00 6,433.97 185.84 21,925.74 8,468.96 11,600.00 2,000.00 1,112.00 1,122.23 7,381.00 40,191.75 20,043.49 1,250.00 2,000.00 27,570.88 518.64 4,675.41 201.13 28,412.14 344.18 378.59 226.88 1,120.00 670.00 477.41 3,925.00 866.00 20.46 3,392.74 5,856.25 3,264.85 626.42 278.45 322.98 7,462.44 10.00 139.00 1,050.00 549.34 6,051.73 262.14 100.00 292.00 201.45 225.00 635.00 18.39 173.67 300.00 9,097.11 363.72 1,548.12 599.12 44,029.49 979.39 9,500.00 109.46 656.25 Truckee Donner Public Utility District Check Register June 2020 Check/Tran Date Vendor 128743 6/19/2020 10761 128744 6/19/2020 349 128745 6/19/2020 6940 128746 6/19/2020 212 128747 6/19/2020 548 128748 6/19/2020 7320 128749 6/19/2020 1308 128750 6/19/2020 643 128752 6/19/2020 11060 128753 6/19/2020 7820 128754 6/19/2020 7821 28453 6/24/2020 1393 28454 6/24/2020 228 28455 6/24/2020 145 28456 6/24/2020 893 28457 6/24/2020 992 28458 6/24/2020 10650 28459 6/24/2020 3322 28460 6/24/2020 3480 28461 6/24/2020 4720 28462 6/24/2020 775 28463 6/24/2020 5070 28464 6/24/2020 181 28465 6/24/2020 1787 28466 6/24/2020 3826 28467 6/24/2020 6655 28468 6/24/2020 7313 28469 6/24/2020 1157 28470 6/24/2020 6360 28471 6/24/2020 155 28472 6/24/2020 1303 28473 6/24/2020 1328 28474 6/24/2020 630 28475 6/24/2020 1321 128755 6/24/2020 1084 128756 6/24/2020 1414 128757 6/24/2020 657 128758 6/24/2020 579 128759 6/24/2020 99999 128760 6/24/2020 348 128761 6/24/2020 78 128762 6/24/2020 1790 128763 6/24/2020 10645 128764 6/24/2020 5658 128765 6/24/2020 186 128766 6/24/2020 905 128767 6/24/2020 1116 128768 6/24/2020 115 128769 6/24/2020 1149 128770 6/24/2020 4355 128771 6/24/2020 658 128772 6/24/2020 99999 128773 6/24/2020 1438 128774 6/24/2020 5151 128775 6/24/2020 1079 128776 6/24/2020 5222 128777 6/24/2020 10101 128778 6/24/2020 10503 128779 6/24/2020 31 128780 6/24/2020 10573 128781 6/24/2020 9971 128782 6/24/2020 11001 128783 6/24/2020 6920 128784 6/24/2020 7040 128785 6/24/2020 548 128786 6/24/2020 1357 128787 6/24/2020 11041 128788 6/24/2020 7320 128789 6/24/2020 7380 128790 6/24/2020 643 128791 6/24/2020 682 128792 6/24/2020 7820 4710 6/25/2020 PL 4717 6/25/2020 3824 4718 6/25/2020 11233 4719 6/25/2020 540 4720 6/25/2020 7310 4721 6/25/2020 905 4722 6/25/2020 3094 Vendor Name SOUTHWEST GAS CORP. STRADLING YOCCA CARLSON & RAUTH P.C. TAHOE TRUCKEE SANITATION AGENCY ROBERT TAMIETTI THE AUTO & TIRE DOCTOR INC. TRUCKEE TAHOE LUMBER CO TRUCKEE TIRE UNITED SITE SERVICES OF NEVADA WESTERN ENERGY INSTITUTE WESTERN NEVADA SUPPLY WESTERN NEVADA SUPPLY ACWA JPIA ALLIED ELECTRONICS INC. CODALE ELECTRIC SUPPLY, INC DEBBIE MADERA CLEANING SERVICE E & M ELECTRIC & MACHINERY INC EUROFINS EATON ANALYTICAL INC. GEXPRO GRAINGER INC. MOUNTAIN HARDWARE AND SPORTS ONLINE INFORMATION SERVICES PLATT SILVER STATE ANALYTICAL LABORATORIES, IN SILVER STATE INTERNATIONAL TRUCKS STONE'S COUNTRY TIRE SUNRISE ENVIRONMENTAL SCIENTIFIC TAHOE SUPPLY COMPANY TAIT NORTH AMERICA, INC THATCHER COMPANY OF CALIFORNIA, INC THE BANK OF NEW YORK MELLON TITAN WIRE AND CABLE TRAFFIC MANAGEMENT, INC. WESTERN AREA POWER ADMINISTRATION WRIGHT TREE SERVICE, INC. ALL STAR RENTS ALPINE SMITH, INC. AT&T AWAXX SYSTEMS INC. JAMES BEACH EDGES ELECTRICAL GROUP FEDERAL EXPRESS CORPORATION FLYERS ENERGY LLC GEI CONSULTANTS INC GOLDEN ROTISSERIE GRANITE CONSTRUCTION COMPANY HEALTHEQUITY INC. HUNT & SONS, INC KIMBALL-MI D W EST LOOMIS MCCARTHY SIGN CO. MOUNTAIN METAL WORKS AMALIA NIEWENDORP NORCAL POWER SERVICES NRECA O'REILLYAUTO PARTS OFFICE DEPOT INC. PITNEY BOWES PLACER COUNTY DEPARTMENT OF PUBLIC WORKS POULIN STEEL FAB INC. PURCHASE POWER EMPLOYEE SPARKS ELECTRIC MOTOR REPAIR TAHOE TRUCKEE SIERRA DISPOSAL TEICHERT & SON INC CREDIT DE THE AUTO & TIRE DOCTOR INC. THE UNION TRUCKEE PAINT MART INC. TRUCKEE TAHOE LUMBER CO UNITED PARCEL SERVICE UNITED SITE SERVICES OF NEVADA VERIZON WIRELESS WESTERN NEVADA SUPPLY PAYROLL ICMA RETIREMENT TRUST 457 CALPERS CALPERS 457 DEFERRED COMP PRGM INTERNAL REVENUE SERVICE HEALTHEQUITY INC. EMPLOYMENT DEV DEPT Reference UTILITIES: NATURAL GAS OG MR ANNUAL ADMIN COSTS LABORATORY TESTING CONTRACT SERVICES: SNOW REMOVAL REPAIRS & MAINTENANCE MATERIALS REPAIRS & MAINTENANCE MATERIALS MEMBERSHIP DUES HYDRANT MAINTENANCE MATERIALS TOILET EXCHANGE INSURANCE PREMIUM 2020 WATER SCADA SYSTEM REPLACEMENT 2020 WATER SCADA SYSTEM REPLACEMENT BUILDING CLEANING 2020 WATER SCADA SYSTEM REPLACEMENT WATER SAMPLE ANALYSIS PURCHASETRANSFORMERS ACLARA REPLACEMENT PROJECT WARRANTY MATERIALS CREDIT CHECK SERVICES MATERIALS WATER SAMPLE ANALYSIS REPAIRS & MAINTENANCE REPAIRS & MAINTENANCE FACILITY SUPPLIES FACILITY SUPPLIES LICENSING, MAINTENANCE & SUPPORT WATER QUALITY: TREATMENT DLAD ANNUAL ADMIN COSTS INVENTORY NORTHWOODS REBUILD CHAMONIX-MUHLEBACH ENVIRONMENTAL COMPLIANCE FEES CONTRACT SERVICES: ROW TREE CLEARING MATERIALS REPAIRS & MAINTENANCE COMMUNICATIONS BUILDING MAINTENANCE CUSTOMER REFUND - CLOSED ACCOUNT INVENTORY ELECTION EXPENSES FUEL FOR VEHICLES ENVIRONMENTAL COMPLIANCE FEES MEETING EXPENSES MATERIALS HSA ADMINISTRATIVE FEES FUEL FOR VEHICLES MISC PARTS & SUPPLIES BANKING CHARGES MATERIALS MATERIALS CUSTOMER REFUND - CLOSED ACCOUNT MATERIALS HEALTH 125 ADMINISTRATIVE FEES REPAIRS & MAINTENANCE OFFICE SUPPLIES OFFICE SUPPLIES RED MOUNTAIN TANK SITE CONSTRUCTION MATERIALS PREPAID POSTAGE VISION REIMBURSEMENT MATERIALS LANDFILL CHARGES MATERIALS REPAIRS & MAINTENANCE GENERAL ADVERTISEMENT MATERIALS MATERIALS UPS CHARGES MATERIALS CELL PHONE CHARGES INVENTORY PAYROLL DIRECT DEPOSIT ICMA CONTRIBUTIONS PPE 06/19/2020 PENSION CONTRIBUTIONS PPE 06/19/2020 CALPERS 457 CONTRIBUTIONS PPE O6/19/2020 FEDERAUFICA WITHHOLDING PPE O6/19/2020 EMPLOYEE HSA CONTRIBUTIONS PPE 06/19/20 SDI/STATE WITHHOLDING PPE O6/19/2020 Amount 11.28 1,931.50 325.00 135.00 1,102.99 70.26 995.98 411.87 500.00 2,639.30 985.65 1,995.00 1,987.33 2,144.48 6,100.00 2,190.00 340.00 14,293.94 322.97 75.51 155.15 480.37 240.00 546.05 899.23 365.25 542.80 18,750.00 1,411.90 635.00 1,213.91 20,645.25 30.02 19,613.60 290.01 5,652.29 1,959.13 98.10 77.85 1,104.62 73.59 4,210.60 913.71 1,200.00 649.20 66.30 1,080.61 80.32 556.13 740.00 33.04 80.15 5,604.10 285.00 64.93 142.50 686.90 55.00 1,593.30 1,020.99 847.86 925.75 3,161.71 2,497.11 593.20 438.26 717.78 16.54 228.80 227.73 6,379.58 3,024.33 187,133.74 17,360.12 54,533.32 18,390.98 85,776.54 417.01 18,664.52 $ 3,161,913.83 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 5/31/2020 Page 1 of 2 Balance in General Fund 4/30/2020 Receipts: Revenue received CFD and DLAD assessment collections Retired employees medical insurance Record interest earned Total Receipts Disbursements: Accounts payable disbursements Distribute UPTIF interest Transfer vehicle sale proceeds to vehicle reserve fund Restrict Donner Lake surcharge Restrict facilities fees Section 125 benefit disbursement Bank charges Total Disbursements Balance in General Fund 5/31/2020 Electric Dept Water Dept Total $9,460,132 $2,678,480 $12,138,613 $2,224,095 $891,041 $3,115,136 1,759,809 1,759,809 20,350 - 20,350 2,345 960 3,305 $4,006,599 $892,001 $4,898,601 $3,848,973 $692,745 $4,541,718 7,437 4,501 11,938 43,225 43,225 - 9,240 9,240 40,663 116,620 157,283 7,627 - 7,627 6,931 - 6,931 $3,911,631 $866,331 $4,777,962 $9,555,100 $2,704,150 $12,259,251 7/6/2020 11:04 AM I:\Treasurers Report\Statement of General Fund\2020\2020-05 GF.xls TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 5/31/2020 Page 2 of 2 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 - 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 $0 $2,400 1,414,613 - 1,414,613 8,138,087 2,704,150 10,842,238 $9,555,100 $2,704,150 $12,259,251 14,150,427 3,847,013 $17,997,440 - 339,337 339,337 - 680,459 680,459 - 1,698,880 1,698,880 - 1,181,554 1,181,554 $14,150,427 $7,747,243 $21,897,670 $23,705,527 $10,451,394 $34,156,921 7/6/2020 11:04 AM I:\Treasurers Report\Statement of General Fund\2020\2020-05 GF.xls INVESTMENT STATUS REPORT Activity for the Month Ended 05/31/20 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 1.36% General Fund 1..136.1 Consolidate cash LAIF transfer Capital Replacement Fund 136.41 AB 32 Cap & Trade Fund 1..136.58 Deferred Liabilites Reserve 1..136.42 Total LAIF Electric Investments UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 1.19% General Fund 1..136.12 Distribute UPTIF interest Restrict facility fees Record monthly interest Facilities Fees 1..136.9 Restrict facilites fees Record monthly interest Electric Rate Reserve Fund 1..136.45 Record monthly interest Capital Replacement Fund 136.46 Record monthly interest Electric Vehicle Reserve 1..136.13 Record monthly interest Total UPTIF Electric Investments PLACER COUNTY INVESTMENT FUND (PCIF) 1.19% Electric General Fund PC1..136.49 Record monthly interest Electric Rate Reserve Fund 1..136.47 Record monthly interest Capital Replacement Fund 1..136.48 Record monthly interest Total PCIF County Electric Investments Total Electric Investments WATER FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 1.36% General Fund 2..136.1 Consolidate cash Restrict facility fees 7/6/2020 1058 AM 2020-051nvest.xls 4/30/20 Activity 05/20 5/31/20 6,630,976 (198,296) (300,000) 6,132,680 1,001,592 1,001,592 1,118,214 1,118,214 2,074,131 2,074,131 10,824,913 (498,296) 10,326,617 1,529,250 (7,437) (40,663) 1,816 1,482,966 942,145 40,663 1,119 983,927 1,596,301 1,896 1,598,197 828,625 984 829,609 616,126 732 616,858 5,512,447 (890) 5,511,557 521,913 528 522,442 4,309,350 4,364 4,313,714 1,612,552 1,633 1,614,185 6,443,816 6,525 6,450,341 22,781,175 (492,661) 22,288,514 4/30/20 Activity 05/20 5/31/20 1,814,801 198,296 (116,620) 1,896,478 DSC Operating Reserve Fund 2..136.47 Facilities Fees 2..136.90 Restrict facility fees Total LAIF Water Investments UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 1.19% General Fund 2..136.12 Transfer to DLAD surcharge Distribute UPTIF interest Record monthly interest Asset sale proceeds (mud dog) - Restricted funds (FROM) Facilities Fees 2..136.25 Record monthly interest West River St. Assessment District 2..136.31 Record monthly interest Prepaid Connection Fees 2..136.7 Record monthly interest Donner Lake Assessment District Fund 2..136.84 Record monthly interest 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 Water Vehicle Reserve 2..136.13 Record monthly interest Asset sale proceeds (mud dog) - Restricted funds (TO) Deferred Liabilites Reserve 2..136.42 Record monthly interest Prop 55 Reserve Fund 2..125.94 Record monthly interest Total UPTIF Water Investments PLACER COUNTY INVESTMENT FUND (PCIF) 1.19% Water General Fund PC 2..136.5 Record monthly interest DSC Operating Reserve Fund 2..136.49 Record monthly interest Total PCIF Water Investments Total Water Investments ELECTRIC & WATER INVESTMENTS, COMBINED TOTALS Total LAIF Investments Total UPTIF Investments Total PCIF Investments Total Investments 4/30/20 Activity 05/20 5/31/20 76,241 76,241 237,425 116,620 354,044 2,128,467 198,296 2,326,763 490,239 (9,240) (4,501) 582 (43,225) 433,856 1,241,477 1,475 1,242,952 37,861 45 37,906 77,371 92 77,463 679,652 807 680,459 171,194 9,240 203 180,637 18,265 22 18,286 175,580 209 43,225 219,014 105,656 125 105,782 338,934 403 339,337 3,336,230 (538) 3,335,691 373,439 378 373,817 1,533,136 1,552 1,534,688 1,906,575 1,930 1,908,506 7,371,271 199,688 7,570,959 12,953,379 (300,000) 12,653,379 8,848,676 (1,428) 8,847,248 8,350,391 8,455 8,358,846 30,152,447 (292,973) 29,859,474 7/6/2020 10:58 AM 2020-051nvest.xls ELECTRIC FUNDS General Fund Facilities Fees Electric Rate Reserve Capital Replacement Fund Deferred Liabilites Reserve/POB Fund Electric Vehicle Reserve AB 32 Fund Total Electric Investments WATER FUNDS General Fund Facilities Fees 2015 COP Funds DSC and Operating Reserve Fund West River St. Assessment District Deferred Liabilites Reserve Prepaid Connection Fees DLAD Fund DLAD Surcharge DLAD Investment SRF Reserve and Payment Fund TSA SAD II Improvement Fund Water Vehicle Reserve Prop 55 Reserve Fund Total Water Investments MELLO ROOS - OLD GREENWOOD Total Mello Roos - Old Greenwood MELLO ROOS - GRAY'S CROSSING Total Mello Roos - Gray's Crossing Total Investments MARKET ADJUSTMENTS Prior Year Market Adjustment Current Year Market Adjustment Cumulative Market Adjustment Total Investments at Market Value 2020 04 Last Month End Balances Change from last month Pctg Change TRUCKEE DONNER PUD INVESTMENT BALANCES as of May 31, 2020 Utah Public Fidelity Mmkt Morgan Stanley Dreyfus Treasury Federated US Federal US Bank LAIF Placer County Investment Fund Govt 57 Treas Sec Port Security Treas Cash Res Farm Credit Checking Cash Total $ 6,132,680 $ 522,442 $ 1,482,966 $ $ $ $ $ $ 1,414,613 $ 2,400 $ 9,555,100 - - 983,927 - - 983,927 - 4,313,714 1,598,197 5,911,912 1,001,592 1,614,185 829,609 3,445,386 2,074,131 - - 435,359 2,509,490 - 616,858 - 616,858 1,118,214 - - - 1,118,214 10,326,617 6,450,341 5,511,557 435,359 1,414,613 2,400 24,140,887 1,896,478 373,817 433,856 2,704,150 354,044 - 1,242,952 - 1,596,996 - - - 363,004 363,004 76,241 1,534,688 - - 1,610,929 - - 37,906 37,906 105,782 105,782 77,463 77,463 680,459 1,181,554 1,862,014 180,637 - - 180,637 - - 1,698,880 1,698,880 821,580 - - 821,580 - 18,286 18,286 219,014 219,014 - - 339,337 - - - 339,337 3,148,343 1,908,506 3,335,691 363,004 1,698,880 1,181,554 11,635,978 248,355 634,909 883,264 248,355 634,909 883,264 1,890,086 2,215,593 4,105,679 1,890,086 - - - - - 2,215,593 - - - 4,105,679 $ 15,365,045 $ 8,358,846 $ 8,847,248 $ 363,004 $ 248,355 $ 1,070,268 $ 2,215,593 $ 1,698,880 $ 2,596,167 $ 2,400 $ 40,765,807 $ 86,703 $ (31,620) $ 36,697 $ $ $ $ $ 31,570 $ $ $ 123,350 (7,221) (7,221) $ 86,703 $ (31,620) $ 36,697 $ $ $ $ $ 24,349 $ $ $ 116,129 $ 15,451,748 $ 8,327,227 $ 8,883,945 $ 363,004 $ 248,355 $ 1,070,268 $ 2,215,593 $ 1,723,229 $ 2,596,167 $ 2,400 $ 40,881,937 15,691,748 8,318,771 8,885,373 497,547 248,299 623,098 1,255,028 1,730,467 1,633,206 2,400 38,885,937 (240,000) 8,456 (1,428) (134,543) 56 447,170 960,565 (7,238) 962,961 - 1,996,000 -2% 0% 0% -27% 0% 72% 77% 0% 59% 0% 5% l:\Treasurers RepO,tR92D\2020-07 T-...es Report\A85 Financial E-d TR 2020D5.xlsx