Loading...
HomeMy WebLinkAbout12 Treasurers Reportenda Item # TREASURER'S REPORT To: Board of Directors From: Mike Salmon Date: June 17, 2020 TREASURER'S REPORT For the Month Ended Treasurers Report: June 2020 a) Approval of the Treasurer's report of fund balances as of month ended April 2020 b) Approval of disbursements for May 2020 12 TRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER'S REPORT June 17, 2020 Fund Balances for the Month Ended April 30, 2020 And Disbursements for the Month Ended May 31, 2020 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the month ending April 30, 2020 and disbursements for May 2020. 1) REQUEST FOR APPROVAL OF DISBURSEMENTS The total disbursements for May 2020 were $4,541,717.59. 2) CHECK SUMMARY The attached listing of checks and ACH payments issued during May 2020 total $4,541,717.59. 3) STATEMENT OF GENERAL FUND: As of April 30, 2020 the balance in the General Fund was $12,138,613 (Electric $9,460,132 and Water $2,678,480). 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 $33,486,902 ($23,559,168 electric and $9,927,734 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: April 2019 May 2019 June 2019 July 2019 August 2019 September 2019 October 2019 November 2019 December 2019 January 2020 February 2020 March 2020 Apri 12020 6) STATUS OF INVESTMENTS: LAIF PCIF UPTIF 1YRT-BILL 2.45% 2.12% 2.98% 2.31% 2.45% 2.12% 2.90% 2.15% 2.43% 2.03% 2.90% 1.87% 2.38% 2.08% 2.87% 1.94 / 2.34 / 1.96% 2.73% 1.72% 2.28% 1.96% 2.60% 1.71% 2.19% 1.84% 2.54% 1.49% 2.10 / 1.93% 2.40% 1.56% 2.04 / 1.70% 2.28% 1.55% 1.97% 1.78% 2.20% 1.41% 1.91% 1.80% 2.10% 0.95% 1.79% 1.54% 1.66% 0.17% 1.65% 1.23% 1.44% 0.16% 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 April 30, 2020, is $38,885,937 including a cumulative market adjustment of $123,367. TRUCKEE DONNER PUBLIC UTILITY DISTRICT Request for Approval of Disbursements The disbursements of the Truckee Donner Public Utility District for the month of May 2020 totaled $4,541,717.59. A listing of those disbursements is attached. Truckee Donner Public Utility District Check Register May 2020 Check[Tran Date Vendor 4689 5/1/2020 3824 4690 5/1/2020 11233 4691 5/1/2020 7310 4692 5/1/2020 3094 128503 5/1/2020 PL 28038 5/7/2020 1359 28039 5/7/2020 9203 28040 5/7/2020 3480 28041 5/7/2020 495 28042 5/7/2020 1312 28043 5/7/2020 4720 28044 5/7/2020 5130 28045 5/7/2020 820 28046 5/7/2020 775 28047 5/7/2020 6402 28048 5/7/2020 181 28049 5/7/2020 7313 28050 5/7/2020 26 28051 5/7/2020 10584 28052 5/7/2020 10737 28053 5/7/2020 320 28054 5/7/2020 1321 128504 5/7/2020 1181 128505 5/7/2020 134 128506 5/7/2020 5860 128507 5/7/2020 657 128508 5/7/2020 240 128509 5/7/2020 2471 128510 5/7/2020 39 128511 5/7/2020 348 128512 5/7/2020 44444 128513 5/7/2020 142 128514 5/7/2020 3349 128515 5/7/2020 570 128516 5/7/2020 1180 128517 5/7/2020 44444 128518 5/7/2020 9600 128519 5/7/2020 6401 128520 5/7/2020 44444 128521 5/7/2020 617 128522 5/7/2020 5151 128523 5/7/2020 10207 128524 5/7/2020 5150 128525 5/7/2020 44444 128526 5/7/2020 716 128527 5/7/2020 10761 128528 5/7/2020 548 128529 5/7/2020 1308 128530 5/7/2020 643 128531 5/7/2020 7820 128532 5/7/2020 44444 4684 5/14/2020 PL 4693 5/14/2020 3824 4694 5/14/2020 11233 4695 5/14/2020 7310 4696 5/14/2020 540 4697 5/14/2020 905 4698 5/14/2020 3094 28119 5/14/2020 5440 28120 5/14/2020 577 28121 5/14/2020 10759 28122 5/14/2020 3480 28123 5/14/2020 10449 28124 5/14/2020 3820 28125 5/14/2020 1174 28126 5/14/2020 3865 28127 5/14/2020 4720 28128 5/14/2020 758 28129 5/14/2020 5730 28130 5/14/2020 1787 28131 5/14/2020 26 28132 5/14/2020 712 28133 5/14/2020 1321 128533 5/14/2020 99999 128534 5/14/2020 134 128535 5/14/2020 44444 128536 5/14/2020 5860 128537 5/14/2020 99999 128538 5/14/2020 99999 128539 5/14/2020 99999 128540 5/14/2020 99999 128541 5/14/2020 99999 128542 5/14/2020 381 128543 5/14/2020 99999 Vendor Name ICMA RETIREMENT TRUST 457 CALPERS INTERNAL REVENUE SERVICE EMPLOYMENT DEV DEPT PAYROLL CALPERS CASEY CHAVEZ GRAINGER INC. INERTIA ENGINEERING INC. MILSOFT UTILITY SOLUTIONS MOUNTAIN HARDWARE AND SPORTS NCPA ONESOURCE DISTRIBUTORS ONLINE INFORMATION SERVICES SIERRA PACIFIC POWER CO SILVER STATE ANALYTICAL LABORATORIES, IN TAHOE SUPPLY COMPANY THE BANK OF NEW YORK MELLON UAMPS US BANK GOVERNMENT SERVICES W & T GRAPHICS WRIGHT TREE SERVICE, INC. AMAZON/SYNCB ANIXTER INC. ARAMARK UNIFORM SERVICES INC AT&T AUDIO ON -HOLD CPS HR CONSULTING CROSSROADS CARWASH EDGES ELECTRICAL GROUP ELLEN BAIR ENGINEERING UNLIMITED INC. GLOBAL RENTAL CO INC GOVERNMENT FINANCE OFFICERS ASSOCIATION INTERNATIONAL INSTITUTE OF MUNICIPAL JAMES ADAMSKI NEIL KAUFMAN LIBERTY UTILITIES MARC SULLIVAN MOUNTAIN EAP NRECA NRECA NRECA GROUP BENEFITS TRUST SCOTT KING SMALLPOND STUDIO SOUTHWEST GAS CORP. THE AUTO & TIRE DOCTOR INC. TRUCKEE TIRE UNITED SITE SERVICES OF NEVADA WESTERN NEVADA SUPPLY WILLIAM NASH PAYROLL ICMA RETIREMENT TRUST 457 CALPERS INTERNAL REVENUE SERVICE CALPERS 457 DEFERRED COMP PRGM HEALTHEQUITY INC. EMPLOYMENT DEV DEPT ALTEC INDUSTRIES INC COOPERATIVE RESPONSE CENTER INC. DONNER LAKE ASSESSMENT DISTR GRAINGER INC. HI -LINE UTILITY SUPPLY CO. IBEW LOCAL 1245 LOGI ANALYTICS, INC. MALLORY SAFETY & SUPPLY MOUNTAIN HARDWARE AND SPORTS PAMELA HURT ASSOCIATES PORTER SIMON SILVER STATE INTL TRUCK THE BANK OF NEW YORK MELLON TRUCKEE DONNER PUD WRIGHT TREE SERVICE, INC. RICHARD S ABBOTT ANIXTER INC. ANTHONY ZINGARO ARAMARK UNIFORM SERVICES INC ANDREW BACH JOSHUA BEATON SHAYE BLAZER JOHN BONCHER RAYMOND W BRATTJR CAL-NEVADA TOWING COBURN CROSSING APARTMENTS, LLC. Reference ICMA CONTRIBUTIONS 9221 FINAL CALPERS CONTRIBUTIONS 9221 FINAL FEDERAL]FICA WITHHOLDING 9221 FINAL SDI/STATE WITHHOLDING 9221 FINAL MANUALPAYROLLCHECK POST RETIREMENT BENEFITS SAFETY GLASSES MATERIALS RECLOSERS REGULATORS CONTROLS SWITCHES LICENSING, MAINTENANCE & SUPPORT 2020 WATER SCADA SYSTEM REPLACEMENT MEMBERSHIP DUES INVENTORY CREDIT CHECK SERVICES PURCHASED POWER - SPPC WATER SAMPLE ANALYSIS FIELD SUPPLIES 2016 REFUNDING SIDE FUND DEBT PAYMENT PURCHASED POWER- LAMPS CREDIT CARD CHARGES SAFETY SUPPLIES CONTRACT SERVICES: ROW TREE CLEARING COMPUTER EXPENSES INVENTORY EMPLOYEE UNIFORM CLEANING SERVICES COMMUNICATIONS ON -HOLD PHONE SYSTEM PROFESSIONAL SERVICES - OTHER REPAIRS & MAINTENANCE 2020 WATER SCADA SYSTEM REPLACEMENT APPLIANCE REBATE - ELECTRIC MATERIALS MATERIALS MEMBERSHIP DUES MEMBERSHIP DUES APPLIANCE REBATE - ELECTRIC MEMBERSHIP DUES ELECTRIC FOR PUMP STATION ELECTRIC WATER HEATER REBATE WELLNESS PROGRAM INSURANCE OFFICE SUPPLIES INSURANCE APPLIANCE REBATE - ELECTRIC PROFESSIONAL SERVICES: MARKETING UTILITIES: NATURAL GAS REPAIRS & MAINTENANCE REPAIRS & MAINTENANCE MATERIALS MATERIALS REFRIGERATOR RECYCLE Payroll Direct Deposit ICMA CONTRIBUTIONS PPE 05/08/2020 PENSION CONTRIBUTIONS PPE 05/08/2020 FEDERAL/FICA WITHHOLDING PPE 05/08/2020 CALPERS 457 CONTRIBUTIONS PPE 05/08/2020 EMPLOYEE HSA CONTRIBUTIONS PPE 05/08/20 SDI/STATE WITHHOLDING PPE 05/08/2020 REPAIRS & MAINTENANCE ANSWERING SERVICE 2019/20 ASSESSMENT COLLECTION FACILITY SUPPLIES MATERIALS UNION DUES LICENSING, MAINTENANCE & SUPPORT FACILITY SUPPLIES MATERIALS EMPLOYEE DEVELOPMENT PROFESSIONAL SERVICES: GENERAL COUNSEL REPAIRS & MAINTENANCE 2019/2020 ASSESSMENT COLLECTIIONS PURCHASED POWER - STAMPEDE HYDRO GENERA CONTRACT SERVICES: ROW TREE CLEARING CUSTOMER REFUND - CLOSED ACCOUNT INVENTORY COVID-19 CUSTOMER RELIEF EMPLOYEE UNIFORM CLEANING SERVICES CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT REPAIRS & MAINTENANCE CUSTOMER REFUND - CLOSED ACCOUNT Amount 267.14 292.12 1,923.53 515.88 3,933.07 9,243.00 173.22 1,202.21 513.92 7,000.00 86.39 12,221.00 5,363.56 168.80 75,039.75 470.00 541.25 177,904.37 836,595.76 30,856.36 2,971.25 27,008.80 15,744.70 28,066.47 230.71 148.42 79.00 7,930.10 11.00 2,124.03 200.00 850.98 4,415.64 150.00 195.00 100.00 115.00 134.81 1,000.00 225.00 16,990.43 559.00 194,401.96 100.00 375.00 11.28 101.95 150.00 730.43 64,296.68 35.00 175,202.88 17,714.97 54,286.35 85,969.20 18,356.76 417.01 18,562.59 2,002.29 2,524.76 297,941.52 698.70 389.98 6,577.60 27,025.00 584.55 76.03 36,812.50 15,450.00 4,632.75 1,380,795.07 31,547.93 26,269.28 79.91 5,827.61 180.00 78.18 1,094.07 185.56 154.11 275.24 138.58 1,040.00 42.45 Truckee Donner Public Utility District Check Register May 2020 Check/Tran Date Vendor Vendor Name Reference Amount 128544 5/14/2020 99999 DAVID COVINGTON CUSTOMER REFUND - CLOSED ACCOUNT 335.10 128545 5/14/2020 609 CUMMINS ROCKY MOUNTAIN LLC 2020 WATER SCADA SYSTEM REPLACEMENT 14,373.90 128546 5/14/2020 99999 MICHELLE ERSKINE CUSTOMER REFUND - CLOSED ACCOUNT 457.24 128547 5/14/2020 99999 LUIS FLORES CUSTOMER REFUND - CLOSED ACCOUNT 169.97 128548 5/14/2020 1790 FLYERS ENERGY LLC FUEL FOR VEHICLES 1,870.78 128549 5/14/2020 99999 JENNIFER FOUNTAIN CUSTOMER REFUND - CLOSED ACCOUNT 71.72 128550 5/14/2020 2222 FRANK STRATTON'S JUST FIX IT MATERIALS 200.00 128551 5/14/2020 99999 WILLIAM GARVEY CUSTOMER REFUND - CLOSED ACCOUNT 60.00 128552 5/14/2020 186 GRANITE CONSTRUCTION COMPANY MATERIALS 449.88 128553 5/14/2020 9449 MIKE HATCH TELEPHONE REIMBURSEMENT 11/19 TO 5/20 246.54 128554 5/14/2020 99999 MONICA HOWARTH CUSTOMER REFUND - CLOSED ACCOUNT 416.49 128555 5/14/2020 1388 INDUSTRIAL TESTS, INC. MATERIALS 6,360.00 128556 5/14/2020 44444 JAMES SCRIVEN COVID-19 CUSTOMER RELIEF - WATER 150.00 128557 5/14/2020 2232 JK ARCHITECTURE ENGINEERING FACILITIES MASTER PLAN 69,959.79 128558 5/14/2020 44444 KATIE HICKEY COVID-19 CUSTOMER RELIEF - WATER 430.00 128559 5/14/2020 99999 SOPHIA KEROSKY CUSTOMER REFUND - CLOSED ACCOUNT 268.76 128560 5/14/2020 44444 KRISTEN WILLIAMS COVID-19 CUSTOMER RELIEF 160.00 128561 5/14/2020 99999 MORGAN LEVAY CUSTOMER REFUND - CLOSED ACCOUNT 141.14 128562 5/14/2020 99999 LIV STUDIO CUSTOMER REFUND - CLOSED ACCOUNT 252.76 128563 5/14/2020 1149 LOOMIS BANKING CHARGES 440.26 128564 5/14/2020 99999 JENNIE LU CUSTOMER REFUND - CLOSED ACCOUNT 397.32 128565 5/14/2020 1079 O'REILLY AUTO PARTS REPAIRS & MAINTENANCE 93.70 128566 5/14/2020 5222 OFFICE DEPOT INC. OFFICE SUPPLIES 116.72 128567 5/14/2020 44444 PATRICK LITTEK COVID-19 CUSTOMER RELIEF 150.00 128568 5/14/2020 99999 ALI PAYRAVI CUSTOMER REFUND - CLOSED ACCOUNT 8.84 128569 5/14/2020 44444 PEGGY MARTIN COVID-19 CUSTOMER RELIEF 180.00 128570 5/14/2020 99999 SUSAN PERRY CUSTOMER REFUND - CLOSED ACCOUNT 37.22 128571 5/14/2020 99999 DAVID PETTY CUSTOMER REFUND - CLOSED ACCOUNT 37.48 128572 5/14/2020 99999 DAVID PICKERING CUSTOMER REFUND - CLOSED ACCOUNT 232.10 128573 5/14/2020 10503 PLACER COUNTY CLERK -RECORDER TEMPORARY BLANKET EASEMENT 17.00 128574 5/14/2020 31 POULIN STEEL FAB INC. MATERIALS 4,859.64 128575 5/14/2020 99999 PULLEN REALTY GROUP CUSTOMER REFUND - CLOSED ACCOUNT 171.46 128576 5/14/2020 44444 ROBIN SHORT COVID-19 CUSTOMER RELIEF 144.00 128577 5/14/2020 246 ROCK GARDEN MATERIALS 16.23 128578 5/14/2020 99999 DANIEL ROITER CUSTOMER REFUND - CLOSED ACCOUNT 320.08 128579 5/14/2020 99999 SAMUEL SEDER CUSTOMER REFUND - CLOSED ACCOUNT 232.18 128580 5/14/2020 675 SHERWIN-WILLIAMS MATERIALS 193.98 128581 5/14/2020 10761 SOUTHWEST GAS CORP. UTILITIES: NATURAL GAS 2,299.12 128582 5/14/2020 44444 SUSAN SZEKELY COVID-19 CUSTOMER RELIEF - WATER 180.00 128583 5/14/2020 6860 TAHOE FOREST HEALTH SYSTEM PERSONNEL EXPENSES 273.50 128584 5/14/2020 6920 TAHOE TRUCKEE SIERRA DISPOSAL LANDFILL CHARGES 3,161.71 128585 5/14/2020 548 THE AUTO & TIRE DOCTOR INC. REPAIRS & MAINTENANCE 70.00 128586 5/14/2020 1357 THE UNION MARKETING 1,345.91 128587 5/14/2020 99999 MICHELLE THELEN CUSTOMER REFUND - CLOSED ACCOUNT 24.82 128588 5/14/2020 99999 STEPHANY THOMPSON CUSTOMER REFUND - CLOSED ACCOUNT 51.67 128589 5/14/2020 7290 TRUCKEE OVERHEAD DOOR BUILDING MAINTENANCE 240.00 128590 5/14/2020 1435 TRUCKEE TAHOE WORKFORCE HOUSING AGENCY PROFESSIONAL SERVICES: OTHER 32,000.00 128591 5/14/2020 1308 TRUCKEE TIRE REPAIRS & MAINTENANCE 150.00 128592 5/14/2020 7380 UNITED PARCEL SERVICE UPS CHARGES 124.00 128593 5/14/2020 643 UNITED SITE SERVICES OF NEVADA 2020 WATER SCADA SYSTEM REPLACEMENT 247.67 128594 5/14/2020 7820 WESTERN NEVADA SUPPLY MATERIALS 2,616.85 128595 5/14/2020 99999 AILEEN WORMOOD CUSTOMER REFUND - CLOSED ACCOUNT 48.90 28134 5/20/2020 10825 ANIXTER INC. 2020 WATER SCADA SYSTEM REPLACEMENT 966.88 28135 5/20/2020 11443 AUTOGLASS/MOTORSPORTS EXPRESS-TRUCKEE REPAIRS & MAINTENANCE 546.97 28136 5/20/2020 1036 ESCI SAFETY MEETING 1,443.75 28137 5/20/2020 10650 EUROFINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 535.00 28138 5/20/2020 3340 GENERAL PACIFIC INC METERS PURCHASE 3,761.86 28139 5/20/2020 3480 GRAINGER INC. MATERIALS 319.04 28140 5/20/2020 778 HDR ENGINEERING INC PROFESSIONAL SERVICES: ENGINEERING 377.00 28141 5/20/2020 10008 HOSE & FITTINGS ETC FIELD SUPPLIES 133.57 28142 5/20/2020 1305 JW WELDING SUPPLIES & TOOLS MATERIALS 201.38 28143 5/20/2020 9710 VISION: EE REIMBURSEMENT VISION: EE REIMBURSEMENT 265.00 28144 5/20/2020 965 MOSS ADAMS PROFESSIONAL SERVICES: AUDIT 6,547.07 28145 5/20/2020 4720 MOUNTAIN HARDWARE AND SPORTS 2020 WATER SCADA SYSTEM REPLACEMENT 236.80 28146 5/20/2020 820 ONESOURCE DISTRIBUTORS MATERIALS 2,316.55 28147 5/20/2020 552 RK CONTRACTORS INC. HIT AND RUN PMS 69 16,851.56 28148 5/20/2020 6155 SAFETY-KLEEN CORPORATION HAZARDOUS MATERIAL COMPLIANCE 361.01 28149 5/20/2020 181 SILVER STATE ANALYTICAL LABORATORIES, IN WATER SAMPLE ANALYSIS 1,098.00 28150 5/20/2020 3826 STONE'S COUNTRY TIRE REPAIRS & MAINTENANCE 309.15 28151 5/20/2020 6880 TAHOE INSTANT PRESS OFFICE SUPPLIES 184.03 28152 5/20/2020 155 THE BANK OF NEW YORK MELLON DLAD ANNUAL ADMIN COSTS 1,500.00 28153 5/20/2020 1328 TRAFFIC MANAGEMENT, INC. MATERIALS 2,701.50 28154 5/20/2020 890 TRI SAGE CONSULTING PROFESSIONAL SERVICES: OTHER 11,877.63 28155 5/20/2020 1183 TRUCKEE-CARSON IRRIGATION DISTRICT PURCHASED POWER -TCID 16,086.49 28156 5/20/2020 4590 UNDERGROUND SERVICE ALERT OF NORTHERN MATERIALS 1,196.32 28157 5/20/2020 630 WESTERN AREA POWER ADMINISTRATION ENVIRONMENTAL COMPLIANCE FEES 11.02 28158 5/20/2020 7820 WESTERN NEVADA SUPPLY MATERIALS - 28159 5/20/2020 1321 WRIGHT TREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 22,571.68 128596 5/20/2020 1414 ALPINE SMITH, INC. REPAIRS & MAINTENANCE 359.96 128597 5/20/2020 134 ANIXTER INC. INVENTORY 7,192.11 128598 5/20/2020 5860 ARAMARK UNIFORM SERVICES INC EMPLOYEE UNIFORM CLEANING SERVICES 78.18 128599 5/20/2020 657 AT&T COMMUNICATIONS 83.28 128600 5/20/2020 6731 CALIFORNIA DEPARTMENT OF TAX AND FEE SALES TAX PAYABLE 204.00 128601 5/20/2020 348 EDGES ELECTRICAL GROUP 2020 WATER SCADA SYSTEM REPLACEMENT 598.47 Truckee Donner Public Utility District Check Register May 2020 Check/Tran Date Vendor 128602 5/20/2020 99999 128603 5/20/2020 78 128604 5/20/2020 10932 128605 5/20/2020 1247 128606 5/20/2020 1176 128607 5/20/2020 99999 128608 5/20/2020 6401 128609 5/20/2020 468 128610 5/20/2020 970 128611 5/20/2020 1079 128612 5/20/2020 5222 128613 5/20/2020 99999 128614 5/20/2020 246 128615 5/20/2020 900 128616 5/20/2020 99999 128617 5/20/2020 719 128618 5/20/2020 6940 128619 5/20/2020 7040 128620 5/20/2020 548 128621 5/20/2020 643 4687 5/28/2020 PL 4699 5/28/2020 3824 4700 5/28/2020 11233 4701 5/28/2020 7310 4702 5/28/2020 540 4703 5/28/2020 905 4704 5/28/2020 3094 28229 5/28/2020 228 28230 5/28/2020 1053 28231 5/28/2020 5440 28232 5/28/2020 829 28233 5/28/2020 524 28234 5/28/2020 10759 28235 5/28/2020 10650 28236 5/28/2020 3340 28237 5/28/2020 985 28238 5/28/2020 1115 28239 5/28/2020 4720 28240 5/28/2020 289 28241 5/28/2020 820 28242 5/28/2020 602 28243 5/28/2020 1013 28244 5/28/2020 10438 28245 5/28/2020 6880 28246 5/28/2020 973 28247 5/28/2020 10380 28248 5/28/2020 698 128622 5/28/2020 5860 128623 5/28/2020 657 128624 5/28/2020 99999 128625 5/28/2020 99999 128626 5/28/2020 10489 128627 5/28/2020 1415 128628 5/28/2020 348 128629 5/28/2020 1790 128630 5/28/2020 3515 128631 5/28/2020 1132 128632 5/28/2020 347 128633 5/28/2020 1079 128634 5/28/2020 5222 128635 5/28/2020 734 128636 5/28/2020 837 128637 5/28/2020 11304 128638 5/28/2020 99999 128639 5/28/2020 548 128640 5/28/2020 7320 128641 5/28/2020 643 128642 5/28/2020 1348 128643 5/28/2020 682 128644 5/28/2020 682 128645 5/28/2020 7820 128646 5/28/2020 7821 4705 5/29/2020 3824 Vendor Name LANCE EVANDER FEDERAL EXPRESS CORPORATION J & L FOOD MART & CARWASH JACK HENRY & ASSOCIATES, INC CHRISTINE F JACKSON, O.D. MATTHEW JENNINGS LIBERTY UTILITIES MAITA CHEVROLET NORTHERN CALIFORNIA JOINT POLE ASSN O'REILLY AUTO PARTS OFFICE DEPOT INC. OREGON INVESTORS I ROCK GARDEN SIERRA MOUNTAIN PIPE & SUPPLY SYNTHEGO CORPORATION T-MOBILE TAHOE TRUCKEE SANITATION AGENCY TEICHERT & SON INC CREDIT DE THE AUTO & TIRE DOCTOR INC. UNITED SITE SERVICES OF NEVADA PAYROLL ICMA RETIREMENT TRUST 457 CALPERS INTERNAL REVENUE SERVICE CALPERS 457 DEFERRED COMP PRGM HEALTHEQUITY INC. EMPLOYMENT DEV DEPT ALLIED ELECTRONICS INC. ALPHA OMEGA WIRELESS INC ALTEC INDUSTRIES INC CDS GLOBAL DE LAGE LANDEN OPERATIONAL SERVICES LLC DONNER LAKE ASSESSMENT DISTR EUROFINS EATON ANALYTICAL INC. GENERAL PACIFIC INC GRANICUS, LLC IFM EFECTOR, INC MOUNTAIN HARDWARE AND SPORTS NISC ONESOURCE DISTRIBUTORS SAFETY ON SITE SIERRA ENERGY PROFESSIONALS STB ELECTRICAL TEST EQUIP INC TAHOE INSTANT PRESS TRUCKEE TAHOE HOME IMPROVEMENT LLC ULINE WILEY PRICE & RADULOVICH LLP ARAMARK UNIFORM SERVICES INC AT&T AVANTSTAYINC BALANCE HOLISTIC HEALTH SPA CORELOGIC INFORMATION SOLUTIONS INC CRISIS INTERVENTION SERVICES EDGES ELECTRICAL GROUP FLYERS ENERGY LLC GRAYBAR ELECTRIC CO INC LEAF NORTHTOWN COMPANY O'REILLY AUTO PARTS OFFICE DEPOT INC. SHEPHERD'S AUTO BODY SIERRA OFFICE SOLUTIONS STELLA-JONES CORPORATION KATY STUCK THE AUTO & TIRE DOCTOR INC. TRUCKEE TAHOE LUMBER CO UNITED SITE SERVICES OF NEVADA VELOCITY TRUCK CENTERS VERIZON WIRELESS VERIZON WIRELESS WESTERN NEVADA SUPPLY WESTERN NEVADA SUPPLY ICMA RETIREMENT TRUST 457 Reference CUSTOMER REFUND - CLOSED ACCOUNT REPAIRS & MAINTENANCE REPAIRS & MAINTENANCE BANKING CHARGES VISION: EE REIMBURSEMENT CUSTOMER REFUND - CLOSED ACCOUNT ELECTRIC FOR PUMP STATION REPAIRS & MAINTENANCE MEMBERSHIP DUES REPAIRS & MAINTENANCE OFFICE SUPPLIES CUSTOMER REFUND - CLOSED ACCOUNT MATERIALS HIT AND RUN PMS 69 CUSTOMER REFUND - CLOSED ACCOUNT SANDEL-AVERY ALARM WATER SAMPLE ANALYSIS MATERIALS REPAIRS & MAINTENANCE 2020 WATER SCADA SYSTEM REPLACEMENT Payroll Direct Deposit ICMA CONTRIBUTIONS PPE 05/22/2020 PENSION CONTRIBUTIONS PPE 05/22/2020 FEDERAUFICA WITHHOLDING PPE 05/22/2020 CALPERS 457 CONTRIBUTIONS PPE 05/22/2020 EMPLOYEE HSA CONTRIBUTIONS PPE 05/22/20 SDI/STATE WITHHOLDING PPE 05/22/2080 2020 WATER SCADA SYSTEM REPLACEMENT LICENSING, MAINTENANCE & SUPPORT MATERIALS REMITTANCE PROCESSING XEROX COPIER LEASE 19/20 DLAD ASSESSMENT WATER SAMPLE ANALYSIS SAFETY SUPPLIES LICENSING, MAINTENANCE & SUPPORT 2020 WATER SCADA SYSTEM REPLACEMENT MATERIALS APRIL 2020 AMS INVENTORY SAFETY SUPPLIES RESIDENTIAL ENERGY SURVEY PROGRAM SAFETY SUPPLIES OFFICE SUPPLIES REFRIGERATOR RECYCLE MATERIALS PROFESSIONAL SERVICES: GENERAL COUNSEL MATERIALS COMMUNICATIONS CUSTOMER REFUND - CLOSED ACCOUNT CUSTOMER REFUND - CLOSED ACCOUNT LICENSING, MAINTENANCE & SUPPORT INCOME QUALIFIED (ESP) 2020 WATER SCADA SYSTEM REPLACEMENT FUEL FOR VEHICLES 2020 WATER SCADA SYSTEM REPLACEMENT XEROX COPIER LEASE MATERIALS MISC PARTS & SUPPLIES OFFICE SUPPLIES REPAIRS & MAINTENANCE XEROX COPIER LEASE INVENTORY CUSTOMER REFUND - CLOSED ACCOUNT REPAIRS & MAINTENANCE MATERIALS MATERIALS FUEL FOR VEHICLES CELL PHONE CHARGES MOBILE GIS UPGRADE & S/O INTE INVENTORY TOILET EXCHANGE - ARTHUR LOPEZ IMCA 457 LOAN REPAYMENTS Amount 113.84 64.62 10.00 157.20 1,335.00 199.68 803.65 585.37 8.15 10.74 292.15 31.31 16.23 78.97 309.42 38.26 100.00 316.16 1,929.21 411.87 178,831.51 17,285.12 53,942.73 84,784.79 18,402.19 417.01 18,174.39 1,050.89 3,500.00 505.07 944.68 1,499.41 26,000.41 20.00 3,414.97 7,350.00 4,446.16 163.43 8,892.79 1,415.91 51.36 2,000.00 701.32 72.09 625.00 48.58 924.00 152.53 422.46 281.35 42.17 463.50 5,450.00 1,116.81 3,714.15 35.06 549.34 246.02 25.95 159.14 2,484.69 166.76 26,528.09 135.02 2,650.40 31.36 227.73 68.20 260.18 10,475.10 4,579.97 425.91 44,280.97 241 4,541,717.59 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 4/30/20 Balance in General Fund 3/31/20 Receipts: Revenue received Retired employees medical insurance Reimburse for Horse Butte power from AB32 fund Record interest earned LAIF Interest quarterly received Total Receipts Disbursements: Accounts payable disbursements Distribute UPTIF interest Restrict Donner Lake surcharge Restrict facilities fees Section 125 benefit disbursement Bank charges Total Disbursements Balance in General Fund 4/30/20 Electric Dept Water Dept Total $9,418,451 $3,110,950 $12,529,401 $2,302,738 $1,031,761 $3,334,500 21,911 - 21,911 285,688 - 285,688 2,758 1,167 3,925 30,946 10,092 41,037 $2,644,041 $1,043,020 $3,687,061 $2,570,200 9,651 4,381 10,417 7,711 $2,602,360 $1,447,666 5,841 9,185 12,797 $1,475,490 $4,017,866 15,493 9,185 17,178 10,417 7,711 $4,077,850 $9,460,132 $2,678,480 $12,138,613 6/9/2020 12:08 PM I:\Treasurers Repo rt\Statement of General Fund\2020\2020-04 GF.xls TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 4/30/20 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 775,593 - 775,593 8,682,139 2,678,480 11,360,619 $9,460,132 $2,678,480 $12,138,613 14,099,036 3,674,175 $17,773,211 - 338,934 338,934 - 679,652 679,652 - 1,698,880 1,698,880 - 857,612 857,612 $14,099,036 $7,249,254 $21,348,290 $23,559,169 $9,927,734 $33,486,902 6/9/2020 12:06 PM I:\Treasurers Repo rt\Statement of General Fund\2020\2020-04 GF.xls INVESTMENT STATUS REPORT Activity for the Month Ended 04/30/20 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 1.65% General Fund 1..136.1 Consolidate cash Reimburse for Horse Butte Power LAIF transfer Quarterly Investment Income payment received Capital Replacement Fund 136.41 Quarterly Investment Income payment received AB 32 Cap & Trade Fund 1..136.58 Reimburse for Horse Butte Power Quarterly Investment Income payment received Deferred Liabilites Reserve 1..136.42 Quarterly Investment Income payment received Total LAIF Electric Investments UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 1.44% 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.23% 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 3/31/20 Activity 04/20 4/30/20 6,198,437 415,905 285,688 (300,000) 30,946 6,630,976 1,000,000 1,592 1,001,592 1,396,764 (285,688) 7,139 1,118,214 2,064,283 9,847 2,074,131 10, 659, 484 165,429 10, 824, 913 1,541,204 (9,651) (4,381) 2,078 1,529,250 936,501 4,381 1,263 942,145 1,594,152 2,150 1,596,301 827,509 1,116 828,625 615,296 830 616,126 5,514,661 (2,214) 5,512,447 521,234 680 521,913 4,303,738 5,613 4,309,350 1,610,452 2,100 1,612,552 6,435,423 8,393 6,443,816 22,609,569 171,607 22,781,175 6/9/2020 12:22 PM 2020-04 InvestAs INVESTMENT STATUS REPORT Activity for the Month Ended 04/30/20 WATER FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 1.65% _ General Fund 2..136.1 Consolidate cash Quarterly Investment Income payment received Restrict facility fees DSC Operating Reserve Fund 2..136.47 Quarterly Investment Income payment received Facilities Fees 2..136.90 Restrict facility fees Quarterly Investment Income payment received Total LAIF Water Investments UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 1.44% General Fund 2..136.12 Transfer to DLAD surcharge Distribute UPTIF interest Record monthly interest 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 Deferred Liabilites Reserve 2..136.42 Record monthly interest Prop 55 Reserve Fund 2..125.94 Record monthly interest 3/31/20 Activity 04/20 4/30/20 2,233,412 (415,905) 10,092 (12,797) 75,881 223,590 1,814,801 360 76,241 12,797 1,037 237,425 2,532,882 (404,416) 2,128,467 504,585 (9,185) (5,841) 680 490,239 1,239,805 1,672 1,241,477 37,810 51 37,861 77,267 104 77,371 678,737 915 679,652 161,790 9,185 218 171,194 18,240 25 18,265 175,344 236 175,580 105,514 142 105,656 338,478 456 338,934 Total UPTIF Water Investments 3,337,570 (1,340) 3,336,230 PLACER COUNTY INVESTMENT FUND (PCIF) 1.23% Water General Fund PC 2..136.5 372,953 Record monthly interest 486 DSC Operating Reserve Fund 2..136.49 1,531,139 Record monthly interest 1,967 1,533,106 Total PCIF Water Investments 1,904,092 2,453 1,906,545 Total Water Investments 7,774,545 (403,303) 7,371,241 ELECTRIC & WATER INVESTMENTS, COMBINED TOTALS Total LAIF Investments 13,192,367 (238,987) 12,953,379 Total UPTIF Investments 8,852,231 (3,554) 8,848,676 Total PCIF Investments 8,339,516 10,845 8,350,361 Total Investments 30,384,113 (231,697) 30,152,417 6/9/2020 12:22 PM 2020-04 InvestAs 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 03 Last Month End Balances Change from last month Pctg Change TRUCKEE DONNER PUD INVESTMENT BALANCES as of April 30, 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,630,976 $ 521,913 $ 1,529,250 $ $ $ $ $ $ 775,593 $ 2,400 $ 9,460,132 - - 942,145 - - 942,145 - 4,309,350 1,596,301 5,905,652 1,001,592 1,612,552 828,625 3,442,769 2,074,131 - - 348,519 2,422,650 - 616,126 - 616,126 1,118,214 - - - 1,118,214 10,824,913 6,443,816 5,512,447 348,519 775,593 2,400 23,907,688 1,814,801 373,439 490,239 2,678,480 237,425 - 1,241,477 - 1,478,902 - - - 497,547 497,547 76,241 1,533,136 - - 1,609,377 - - 37,861 37,861 105,656 105,656 77,371 77,371 679,652 857,612 1,537,264 171,194 - - 171,194 - - 1,698,880 1,698,880 821,580 - - 821,580 - 18,265 18,265 175,580 175,580 - - 338,934 - - - 338,934 2,950,047 1,906,575 3,336,230 497,547 1,698,880 857,612 11,246,891 248,299 274,578 522,877 248,299 274,578 522,877 1,830,086 1,255,028 3,085,113 1,830,086 - - - - - 1,255,028 - - - 3,085,113 $ 15,605,045 $ 8,350,391 $ 8,848,676 $ 497,547 $ 248,299 $ 623,098 $ 1,255,028 $ 1,698,880 $ 1,633,206 $ 2,400 $ 38,762,570 $ 86,703 $ (31,620) $ 36,697 $ $ $ $ $ 31,570 $ $ $ 123,350 17 17 $ 86,703 $ (31,620) $ 36,697 $ $ $ $ $ 31,587 $ $ $ 123,367 $ 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 15,930,734 8,307,896 8,888,928 406,152 248,115 535,939 1,254,295 1,736,825 2,012,789 2,400 39,324,073 (238,986) 10,875 (3,555) 91,395 184 87,159 733 (6,358) (379,583) - (438,136) -2% 0% 0% 23% 0% 16% 0% 0% -19% 0% -1% I:\T,-,,, Rep.,t\2D2D\2020 06 T-... re Report\ADS Fln -W E-d TR 202OD4.xlsx