Loading...
HomeMy WebLinkAbout15 Treasurers Report'd TRUCKEE DONNER Public Utility District MEETING DATE: September 1, 2021 TO: Board of Directors AGENDA ITEM #15 FROM: Michael Salmon, Chief Financial Officer SUBJECT: Approve the Treasurer's Report: June 30, 2021 & July 31, 2021 Page 1 of 1 TRUCKEE DONNER PUBLIC UTILITY DISTRICT TREASURER'S REPORT September 1, 2021 Fund Balances for the Month Ended June 30, 2021 And Disbursements for the Month July 31, 2021 Page 1 of 13 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Summary report of fund balances for the month ending June 30, 2021 and disbursements for July 2021. 1) REQUEST FOR APPROVAL OF DISBURSEMENTS The total disbursements for July 2021 were $4,899,903.89. 2) CHECK SUMMARY The attached listing of checks and ACH payments issued during July 2021 total $4,899,903.89. 3) STATEMENT OF GENERAL FUND: As of June 30, 2021 the balance in the General Fund was $18,284,539 (Electric $13,287,835 and Water $4,996,703). 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 TVI Investments as of June 2021 was $39,430,796 ($28,119,569 electric and $11,311,227 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: LAIF PCIF UPTIF YR T-BILI June 2020 1.22% 1.19% 0.95% 0.16% July 2020 0.92% 0.89% 0.74% 0.11 % August 2020 0.78% 0.74% 0.53% 0.12% September 2020 0.69% 0.57% 0.55% 0.12% October 2020 0.62% 0.60% 0.52% 0.13% November 2020 0.58% 0.49% 0.52% 0.11 % December 2020 0.54% 0.32% 0.49% 0.10% January 2021 0.46% 0.29% 0.47% 0.10% February 2021 0.41 % 0.26% 0.45% 0.08% March 2021 0.36% 0.24% 0.43% 0.07% April 2021 0.34% 0.23% 0.42% 0.05% May 2021 0.32% 0.24% 0.40% 0.05% June 2021 0.26% 0.19% 0.37% 0.08% Page 2 of 13 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Request for Approval of Disbursements The disbursements of the Truckee Donner Public Utility District for the month of July 2021 totaled $4,899,903.89. A listing of those disbursements is attached. AP DISBURSEMENTS METRICS: 6,000,000.00 5,000,000.00 4,000,000.00 3,000,000.00 2,000,000.00 1,000,000.00 0.00 400 350 300 250 200 150 100 50 0 $ A/P Disbursements Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2018 ■ 2019 ■ 2020 ■ 2021 # A/P Payments Issued Jan Feb Mar Apr May Jun Jul ■ 2018 ■ 2019 ■ 2020 1111 d-11 III III Aug Sep Oct Nov Dec 2021 # A/P I nvoices Vouchered 1000 800 600 — 400 — 200 I 0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ■ 2018 ■ 2019 ■ 2020 ■ 2021 Page 3 of 13 Truckee Donner Public Utility District Check Register July 2021 Check/Tran Date Type Vendor Vendor Name Reference Amount 31468 7/1/2021 DD 9504397 PACE SUPPLY INVENTORY $ 25.46 130437 7/1/2021 CHK 44444 DAN WARREN REFRIGERATOR RECYCLE 35.00 130457 7/1/2021 CHK 536 TAHOE-TRUCKEE UNIFIED SCHOOL DISTRICT BANKING CHARGES 65.00 130433 7/1/2021 CHK 657 AT&T COMMUNICATIONS 70.16 130440 7/1/2021 CHK 44444 FEDERICO ZARATE TOILET REBATE 100.00 130453 7/1/2021 CHK 668 SUDDENLINK COMMUNICATION INTERNET SERVICES 101.43 31475 7/1/2021 DD 320 W&TGRAPHICS EMPLOYEE UNIFORMS 108.53 31473 7/1/2021 DD 7300 TRUCKEE RENTS INC 2021 WATER SCADA SYSTEM REPLACEMENT 130.75 130434 7/1/2021 CHK 99999 CDS GLOBAL CDS PAYMENT MADE IN ERROR 154.59 130450 7/1/2021 CHK 246 ROCK GARDEN MATERIALS 155.28 31462 7/1/2021 DD 3340 GENERAL PACIFIC INC EMPLOYEE UNIFORMS 160.08 130445 7/1/2021 CHK 1210 IMPACT EQUIPMENT COMPANY REPAIRS & MAINTENANCE 173.93 31466 7/1/2021 DD 923 NETXPERTS INC LICENSING, MAINTENANCE & SUPPORT 176.00 31464 7/1/2021 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 217.15 130447 7/1/2021 CHK 4250 LAWSON PRODUCTS INC FIELD SUPPLIES 266.64 31457 7/1/2021 DD 228 ALLIED ELECTRONICS INC. MATERIALS 292.82 130456 7/1/2021 CHK 6860 TAHOE FOREST HOSPITAL SYSTEM WELLNESS PROGRAM 294.00 130449 7/1/2021 CHK 5222 OFFICE DEPOT INC. OFFICE SUPPLIES 302.86 130460 7/1/2021 CHK 548 THE AUTO & TIRE DOCTOR INC. REPAIRS & MAINTENANCE 457.67 130451 7/1/2021 CHK 1479 SCHNEIDER ELECTRIC SYSTEMS USA, INC. HARDWARE PURCHASES 493.62 130443 7/1/2021 CHK 44444 HEATHER SPEAR ELECTRIC VEHICLE CHARGER REBATE 500.00 130441 7/1/2021 CHK 186 GRANITE CONSTRUCTION COMPANY MATERIALS 505.41 130454 7/1/2021 CHK 6860 TAHOE FOREST HEALTH SYSTEM PERSONNEL EXPENSES 520.00 31469 7/1/2021 DD 419 QCS INC. BUILDING MAINTENANCE 610.66 31463 7/1/2021 DD 3480 GRAINGER INC. HYDRANT MAINTENANCE MATERIALS 620.24 130435 7/1/2021 CHK 1073 CLEAN MACHINE REPAIRS & MAINTENANCE 640.00 130446 7/1/2021 CHK 10804 JUNIPER HILLS PROPERTY OWNER CONTRACT SERVICES: SNOW REMOVAL 687.98 130448 7/1/2021 CHK 11025 MOONSHINE INK MARKETING 700.00 130452 7/1/2021 CHK 10761 SOUTHWEST GAS CORP. UTILITIES: NATURAL GAS 710.75 31474 7/1/2021 DD 973 TRUCKEE TAHOE HOME IMPROVEMENT LLC REFRIGERATOR RECYCLE 875.00 130463 7/1/2021 CHK 643 UNITED SITE SERVICES OF NEVADA MATERIALS 981.32 130462 7/1/2021 CHK 999 TRUCKEE TAHOE AIRPORT DISTRICT REFUND WORK ORDER #21-644448 1,000.00 130464 7/1/2021 CHK 10082 UTILITY ENERGY FORUM MEETING EXPENSES 1,000.00 31460 7/1/2021 DD 10650 EUROFINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 1,225.00 130444 7/1/2021 CHK 1116 HUNT& SONS, INC WILDFIRE MITIGATION MATERIALS 1,394.75 31461 7/1/2021 DD 5840 FERGUSON ENTERPRISES INC MATERIALS 1,448.21 31465 7/1/2021 DD 1419 MUNICIPAL MAINTENANCE EQUIPMENT REPAIRS & MAINTENANCE 1,826.68 31472 7/1/2021 DD 6360 THATCHER COMPANY OF CALIFORNIA, INC WATER QUALITY: TREATMENT 1,844.20 130442 7/1/2021 CHK 3515 GRAYBAR ELECTRIC CO INC MATERIALS 1,853.95 130439 7/1/2021 CHK 348 EDGES ELECTRICAL GROUP MATERIALS 1,989.19 130438 7/1/2021 CHK 44444 DESIGN BAR HOME FURNISHINGS COMMERCIAL LIGHTING REBATE 2,332.41 130458 7/1/2021 CHK 7040 TEICHERT & SON INC CREDIT DE MATERIALS 3,079.48 31471 7/1/2021 DD 1157 TAIT NORTH AMERICA, INC MATERIALS 3,145.98 130461 7/1/2021 CHK 10050 TOWN OF TRUCKEE PEV STATION EXPENSES 4,000.00 31467 7/1/2021 DD 820 ONESOURCE DISTRIBUTORS INVENTORY 4,574.26 130436 7/1/2021 CHK 1415 CRISIS INTERVENTION SERVICES PAYMENT ASSISTANCE - COVID 19 4,760.00 31459 7/1/2021 DD 893 DEBBIE MADERA CLEANING SERVICE BUILDING CLEANING 6,300.00 130465 7/1/2021 CHK 682 VERIZON WIRELESS CELL PHONE CHARGES 6,567.76 130459 7/1/2021 CHK 999 TEICHERT LAND CO REFUND WORK ORDER 19-644402 6,977.66 130455 7/1/2021 CHK 999 TAHOE FOREST HOSPITAL REFUND WORK ORDER # 18-644394 8,823.44 31470 7/1/2021 DD 1466 ROADSAFE TRAFFIC SYSTEMS POLE CHANGE OUT 10,800.00 31476 7/1/2021 DD 934 WEST COAST PAVING INC MATERIALS 18,505.60 31477 7/1/2021 DD 1321 WRIGHT TREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 37,299.44 5039 7/1/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYER HSA DEPOSIT JULY 2021 65,104.50 31458 7/1/2021 DD 9503810 CDW GOVERNMENT INC. LICENSING, MAINTENANCE & SUPPORT 69,786.00 5028 7/6/2021 WIRE 38241CMA RETIREMENT TRUST 457 ICMA CONTRIBUTIONS 9304 FINAL 206.28 5030 7/6/2021 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS 9304 FINAL 206.28 5032 7/6/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 9304 FINAL 277.84 5029 7/6/2021 WIRE 11233 CALPERS PENSION 471.01 5031 7/6/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 9304 FINAL 1,109.92 130466 7/6/2021 PL PL PAYROLL PAYROLL FINAL CHECK 1,858.38 5037 7/8/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE 07/02/21 623.93 5036 7/8/2021 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS CONTRIBUTIONS PPE 07/02/2021 17,770.20 5038 7/8/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 07/02/2021 19,258.85 5033 7/8/2021 WIRE 38241CMA RETIREMENT TRUST 457 ICMA CONTRIBUTIONS PPE 07/02/2021 20,546.48 5034 7/8/2021 WIRE 11233 CALPERS PENSION 52,613.35 5035 7/8/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 07/02/2021 87,057.26 5023 7/8/2021 PL PL PAYROLL PAYROLL DIRECT DEPOSIT 178,708.71 31548 7/9/2021 DD 10650 EUROFINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 40.00 130471 7/9/2021 CHK 5661 DOORKING, INC CELL PHONE CHARGES 41.95 31551 7/9/2021 DD 967 INLAND SUPPLY CO FACILITY SUPPLIES 65.96 130490 7/9/2021 CHK 669 STATE WATER RESOURCES CONTROL BOARD EMPLOYEE DEVELOPMENT 70.00 130469 7/9/2021 CHK 240 AUDIO ON -HOLD ON -HOLD PHONE SYSTEM 79.00 130486 7/9/2021 CHK 11226 SHRED -IT USA LLC OFFICE SUPPLIES 85.00 130474 7/9/2021 CHK 99999 DR WILLIAM R HESLOP CUSTOMER REFUND -CLOSED ACCOUNT 108.12 31552 7/9/2021 DD 10008 MOTION & FLOW CONTROL PRODUCTS, INC. MISC PARTS & SUPPLIES 109.46 31563 7/9/2021 DD 7313 TAHOE SUPPLY COMPANY FACILITY SUPPLIES 119.06 130493 7/9/2021 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 166.14 130481 7/9/2021 CHK 5200 NORTHWEST PUBLIC POWER ASSOCIATION JOB ADVERTISEMENT- JOURNEYMAN LINEMAN 175.00 31554 7/9/2021 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 179.88 130494 7/9/2021 CHK 643 UNITED SITE SERVICES OF NEVADA MATERIALS 198.80 130478 7/9/2021 CHK 9658 EMPLOYEE VISION REIMBURSEMENT 204.00 31553 7/9/2021 DD 617 MOUNTAIN EAP WELLNESS PROGRAM 225.00 130484 7/9/2021 CHK 99999 TYLER NYBY CUSTOMER REFUND -CLOSED ACCOUNT 243.82 130485 7/9/2021 CHK 734 SHEPHERD'S AUTO BODY ALTEC WARRANTY WORK- VEH 239 248.33 130476 7/9/2021 CHK 1176 CHRISTINE FJACKSON, O.D. VISION REIMBURSEMENT 310.00 130470 7/9/2021 CHK 381 CAL-NEVADA TOWING REPAIRS & MAINTENANCE 357.50 130487 7/9/2021 CHK 900 SIERRA MOUNTAIN PIPE &SUPPLY TOILET EXCHANGE- MARIAM SHAMBAYATI 509.56 Page 1 of 4 Page 4 of 13 Check/Tran Date Type Vendor Vendor Name Reference Amount 31555 7/9/2021 DO 1419 MUNICIPAL MAINTENANCE EQUIPMENT REPAIRS & MAINTENANCE 634.09 130477 7/9/2021 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 714.36 130479 7/9/2021 CHK 999 MARK BOVENZI REFUND TEMP POWER FEE 719.00 31562 7/9/2021 DD 6604 SPIEGEL & MC DIARMID PROFESSIONAL SERVICES: FERC ISSUES 976.25 130467 7/9/2021 CHK 10360 AFLAC EMPLOYEE PAID INSURANCE 981.32 31546 7/9/2021 DO 1167 EAST RIVER PR PROFESSIONAL SERVICES: MARKETING 1,000.00 130472 7/9/2021 CHK 348 EDGES ELECTRICAL GROUP MATERIALS 1,179.76 31550 7/9/2021 DO 3480 GRAINGER INC. HYDRANT MAINTENANCE MATERIALS 1,423.04 31559 7/9/2021 DO 9504397 PACE SUPPLY INVENTORY 1,437.56 130492 7/9/2021 CHK 7315 TRUCKEE SANITARY DISTRICT UTILITIES: SEWER 1,542.24 31561 7/9/2021 DO 1787 SILVER STATE INTERNATIONAL TRUCKS REPAIRS & MAINTENANCE 1,641.71 31547 7/9/2021 DD 1036 ESCI SAFETY MEETING 1,925.00 130468 7/9/2021 CHK 657 AT&T COMMUNICATIONS 2,009.01 130489 7/9/2021 CHK 5601 SMOKEY'S KITCHEN MEETING EXPENSES 2,064.44 31549 7/9/2021 DO 5840 FERGUSON ENTERPRISES INC MATERIALS 2,096.13 31565 7/9/2021 DO 155 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 2,120.00 31543 7/9/2021 DO 5440 ALTEC INDUSTRIES INC ALTEC WARRANTY WORK- VEH 213 3,073.85 130491 7/9/2021 CHK 6920 TAHOE TRUCKEE SIERRA DISPOSAL LANDFILL CHARGES 3,277.15 31567 7/9/2021 DO 10678 WILLDAN FINANCIAL SERVICES GC MR ANNUAL ADMIN COSTS 3,678.79 130475 7/9/2021 CHK 1116 HUNT &SONS, INC FUEL FOR VEHICLES 3,730.70 130473 7/9/2021 CHK 3515 GRAYBAR ELECTRIC CO INC MATERIALS 4,225.74 31545 7/9/2021 DO 577 COOPERATIVE RESPONSE CENTER INC. ANSWERING SERVICE 4,830.76 31558 7/9/2021 DO 820 ONESOURCE DISTRIBUTORS INVENTORY 6,007.78 130488 7/9/2021 CHK 1082 SIERRA NEVADA AD PARTNERS MARKETING 6,185.08 31544 7/9/2021 DO 9503810 CDW GOVERNMENT INC. COMPUTER EXPENSES 7,508.87 5046 7/9/2021 WIRE 1359 CALIPERS PENSION 9,460.00 31556 7/9/2021 DO 5130 NCPA MEMBERSHIP DUES 10,856.00 31557 7/9/2021 DD 6403 NEVADA POWER COMPANY PURCHASED POWER-NEVADA POWER 12,154.39 130482 7/9/2021 CHK 5151 NRECA INSURANCE 17,096.14 31568 7/9/2021 DD 1321 WRIGHTTREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 27,711.33 31560 7/9/2021 DO 6402 SIERRA PACIFIC POWER CO PURCHASED POWER -SPPC 60,200.59 31564 7/9/2021 DD 26 THE BANK OF NEW YORK MELLON DEBT PAYMENTS 179,076.20 130480 7/9/2021 CHK 1481 MOUNTAIN G ENTERPRISES, INC TRUCKEE SUBSTATION CONTROL 206,115.42 130483 7/9/2021 CHK 5150 NRECA GR0UP BENEFITS TRUST INSURANCE 209,230.26 31566 7/9/2021 DO 10584 LAMPS PURCHASED POWER -LAMPS 846,557.24 5040 7/13/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYER DEPOSIT 1,059.00 130504 7/15/2021 CHK 10932 J & L FOOD MART & CARWASH REPAIRS & MAINTENANCE 10.00 31571 7/15/2021 DD 10809 BATTERIES PLUS MATERIALS 17.30 130503 7/15/2021 CHK 78 FEDERAL EXPRESS CORPORATION FEDERAL EXPRESS CHARGES 54.87 31585 7/15/2021 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 71.05 31587 7/15/2021 DO 820 ONESOURCE DISTRIBUTORS INVENTORY 87.96 130505 7/15/2021 CHK 1176 CHRISTINE FJACKSON, O.D. VISION REIMBURSEMENT 100.00 31596 7/15/2021 DO 6880 TAHOE INSTANT PRESS OFFICE SUPPLIES 100.29 130510 7/15/2021 CHK 1082 SIERRA NEVADA AD PARTNERS MARKETING 112.50 130502 7/15/2021 CHK 1432 FARR WEST ENGINEERING PROFESSIONAL SERVICES: ENGINEERING 113.00 31582 7/15/2021 DD 3520 JOHNSON CONTROLS FIRE PROTECTION LP BUILDING MAINTENANCE 125.03 31584 7/15/2021 DO 10008 MOTION & FLOW CONTROL PRODUCTS, INC. FIELD SUPPLIES 137.82 31577 7/15/2021 DD 640 EMPLOYER LYNX INC. PERSONNEL EXPENSES 152.00 130516 7/15/2021 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 166.14 31592 7/15/2021 DD 9962 GRANT J SACKS CELL PHONE CHARGES 180.00 130508 7/15/2021 CHK 5222 OFFICE DEPOT INC. OFFICE SUPPLIES 182.64 130500 7/15/2021 CHK 2780 DEPENDABLE TOW 2021 WATER SCADA SYSTEM REPLACEMENT 210.00 130506 7/15/2021 CHK 115 KIMBALL-MIDWEST MISC PARTS & SUPPLIES 217.10 130517 7/15/2021 CHK 7380 UNITED PARCEL SERVICE UPS CHARGES 224.94 130509 7/15/2021 CHK 675 SHERWIN-WILLIAMS MATERIALS 237.73 31583 7/15/2021 DD 1305 JWWELDING SUPPLIES&TOOLS MATERIALS 240.63 31579 7/15/2021 DO 3480 GRAINGER INC. FIELD SUPPLIES 249.21 130518 7/15/2021 CHK 643 UNITED SITE SERVICES OF NEVADA MATERIALS 254.56 31593 7/15/2021 DO 837 SIERRA OFFICE SOLUTIONS XEROX COPIER LEASE 271.39 31569 7/15/2021 DD 228 ALLIED ELECTRONICS INC. 2021 WATER SCADA SYSTEM REPLACEMENT 300.65 31581 7/15/2021 DO 1115 IFM EFECTOR, INC 2021 WATER SCADA SYSTEM REPLACEMENT 301.34 31588 7/15/2021 DD 775 ONLINE INFORMATION SERVICES CREDIT CHECK SERVICES 336.50 5041 7/15/2021 WIRE 38241CMA RETIREMENT TRUST 457 ICMA CONTRIBUTIONS 9658 FINAL 356.25 5043 7/15/2021 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALIPERS 457 CONTRIBUTIONS 9658 FINAL 357.39 31600 7/15/2021 DO 667 WESTERN RENEWABLE ENERGY GENERATION ENVIRONMENTAL COMPLIANCE FEES 408.38 130499 7/15/2021 CHK 10489 CORELOGIC INFORMATION SOLUTIONS INC LICENSING, MAINTENANCE & SUPPORT 491.73 31594 7/15/2021 DO 181 SILVER STATE ANALYTICAL LABORATORIES, IN WATER SAMPLE ANALYSIS 504.00 130507 7/15/2021 CHK 1149 LOOMIS BANKING CHARGES 512.26 130515 7/15/2021 CHK 242 THOLL FENCE INC. BUILDING MAINTENANCE 540.00 31599 7/15/2021 DD 2040 TYDEN BROOKS MATERIALS 683.68 130519 7/15/2021 CHK 7820 WESTERN NEVADA SUPPLY MATERIALS 696.32 130501 7/15/2021 CHK 348 EDGES ELECTRICAL GROUP 2021 WATER SCADA SYSTEM REPLACEMENT 752.74 5042 7/15/2021 WIRE 11233 CALIPERS PENSION 813.48 130498 7/15/2021 CHK 1073 CLEAN MACHINE REPAIRS & MAINTENANCE 910.00 31572 7/15/2021 DO 829 COS GLOBAL REMITTANCE PROCESSING 982.36 130513 7/15/2021 CHK 548 THE AUTO & TIRE DOCTOR INC. REPAIRS & MAINTENANCE 1,039.99 31589 7/15/2021 DO 9504397 PACE SUPPLY INVENTORY 1,059.19 31578 7/15/2021 DD 10650 EUROFINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 1,135.00 5045 7/15/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 9658 FINAL 1,207.06 130514 7/15/2021 CHK 1357 THE UNION GENERAL ADVERTISEMENT 1,939.64 31575 7/15/2021 DO 524 DE LAGE LANDEN OPERATIONAL SERVICES LLC OFFICE SUPPLIES 2,144.92 31574 7/15/2021 DD 981 CRMORBIT INC LICENSING, MAINTENANCE & SUPPORT 2,475.00 130512 7/15/2021 CHK 6940 TAHOE TRUCKEE SANITATION AGENCY WATER SAMPLE ANALYSIS 3,642.50 31597 7/15/2021 DD 6360 THATCHER COMPANY OF CALIFORNIA, INC WATER QUALITY: TREATMENT 4,377.14 5044 7/15/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 9658 FINAL 4,796.76 130511 7/15/2021 CHK 349 STRADLING YOCCA CARLSON & RAUTH P.C. GC MR ANNUALADMIN COSTS 5,550.98 31580 7/15/2021 DO 3820 IBEW LOCAL 1245 UNION DUES 6,430.30 31576 7/15/2021 DO 1469 ECS IMAGING INC LICENSING, MAINTENANCE & SUPPORT 6,487.50 130520 7/15/2021 PL PL PAYROLL PAYROLL FINAL CHECK 6,702.97 31590 7/15/2021 DD 5730 PORTER SIMON LEGAL SERVICES 11,325.00 130497 7/15/2021 CHK 2263 CASHMAN EQUIPMENT COMPANY MATERIALS 12,254.46 Page 2of4 Page 5 of 13 Check/Tran Date Type Vendor Vendor Name Reference Amount 130495 7/15/2021 CHK 1162 ADM ASSOCIATES, INC. EM & V SERVICES 14,000.00 31573 7/15/2021 DD 1251 CONSTRUCTION MATERIALS ENGINEERS, INC. 2021 PIPELINE REPLACEMENT PROJECT 18,143.50 130496 7/15/2021 CHK 10250 CARSON PUMP LLC MATERIALS 20,750.00 31595 7/15/2021 DD 11304 STELLA-JONES CORPORATION INVENTORY 23,224.37 31586 7/15/2021 DD 289 NISC APRIL 2021 MISC 26,941.97 31598 7/15/2021 DD 1183 TRUCKEE-CARSON IRRIGATION DISTRICT PURCHASED POWER -TCID 27,921.18 31601 7/15/2021 DD 1321 WRIGHTTREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 45,185.87 31570 7/15/2021 DD 5440 ALTEC INDUSTRIES INC 2020 RAM 35004X4 ALTEC SVC BODY RPL 201 192,156.74 31591 7/15/2021 DD 1483 RAPID CONSTRUCTION INC. 2021 PIPELINE REPLACEMENT PROJECT 311,333.04 5053 7/21/2021 WIRE 11233 CALPERS PENSION 14,947.00 5054 7/21/2021 WIRE 11233 CALPERS PENSION 1,035,633.00 130522 7/22/2021 CHK 99999 ELLA ANDERSON CUSTOMER REFUND -CLOSED ACCOUNT 5.42 130535 7/22/2021 CHK 970 NORTHERN CALIFORNIA JOINT POLE ASSN MEMBERSHIP DUES 7.85 130526 7/22/2021 CHK 99999 LLOYD E CARLSON CUSTOMER REFUND -CLOSED ACCOUNT 19.79 130524 7/22/2021 CHK 657 AT&T COMMUNICATIONS 23.47 130541 7/22/2021 CHK 716 SMALLPOND STUDIO PROFESSIONAL SERVICES: MARKETING 62.50 130537 7/22/2021 CHK 5222 OFFICE DEPOT INC. FACILITY SUPPLIES 85.98 130528 7/22/2021 CHK 99999 BRYAN EMERSON CUSTOMER REFUND -CLOSED ACCOUNT 90.88 130542 7/22/2021 CHK 668 SUDDENLINK COMMUNICATION INTERNET SERVICES 101.43 130536 7/22/2021 CHK 1079 O'REI LILY AUTO PARTS 2020 RAM 3500 4X4 ALTEC SVC BODY RPL 201 111.10 130547 7/22/2021 CHK 7820 WESTERN NEVADA SUPPLY MATERIALS 111.50 130529 7/22/2021 CHK 99999 ALEJANDRO GOMEZ CUSTOMER REFUND -CLOSED ACCOUNT 117.50 31680 7/22/2021 DD 4720 MOUNTAIN HARDWARE AND SPORTS MATERIALS 135.20 130534 7/22/2021 CHK 99999 DOUGLAS J MCGEHEE CUSTOMER REFUND -CLOSED ACCOUNT 149.95 31675 7/22/2021 DD 3340 GENERAL PACIFIC INC EMPLOYEE UNIFORMS 170.10 130525 7/22/2021 CHK 6731 CALIFORNIA DEPARTMENT OF TAX AND FEE USE TAX PAYABLE 197.00 130546 7/22/2021 CHK 682 VERIZON WIRELESS CELL PHONE CHARGES 260.18 130539 7/22/2021 CHK 675 SHERWIN-WILLIAMS MATERIALS 272.30 130532 7/22/2021 CHK 99999 MIKE LATHBURY CUSTOMER REFUND-CLOSEDACCOUNT 274.07 31676 7/22/2021 DD 3480 GRAINGER INC. METER MAINTENANCE 305.50 130544 7/22/2021 CHK 2236 UNIFIRST EMPLOYEE UNIFORM CLEANING SERVICES 330.07 31682 7/22/2021 DD 9504397 PACE SUPPLY INVENTORY 337.05 130530 7/22/2021 CHK 186 GRANITE CONSTRUCTION COMPANY MATERIALS 373.95 31688 7/22/2021 DD 10380 ULINE FIELD SUPPLIES 447.99 31679 7/22/2021 DD 1303 MONROE TITAN, LLC HARDWARE PURCHASES 452.35 130533 7/22/2021 CHK 1132 LEAF XEROX COPIER LEASE 549.34 31686 7/22/2021 DD 6880 TAHOE INSTANT PRESS OFFICE SUPPLIES 569.66 130527 7/22/2021 CHK 348 EDGES ELECTRICAL GROUP 2021 WATER SCADA SYSTEM REPLACEMENT 574.66 5051 7/22/2021 WIRE 905 HEALTHEQUITY INC. EMPLOYEE HSA CONTRIBUTIONS PPE 07/16/21 623.93 130545 7/22/2021 CHK 643 UNITED SITE SERVICES OF NEVADA MATERIALS 726.76 31685 7/22/2021 DD 181 SILVER STATE ANALYTICAL LABORATORIES, IN WATER SAMPLE ANALYSIS 843.00 130538 7/22/2021 CHK 10573 PURCHASE POWER PREPAID POSTAGE 1,020.99 130543 7/22/2021 CHK 548 THE AUTO & TIRE DOCTOR INC. REPAIRS & MAINTENANCE 1,100.36 31673 7/22/2021 DD 10367 CCMEDIA MARKETING 1,316.00 31674 7/22/2021 DD 10650 EUROFINS EATON ANALYTICAL INC. WATER SAMPLE ANALYSIS 1,335.00 130521 7/22/2021 CHK 1162 ADM ASSOCIATES, INC. EM & V 1,400.00 31677 7/22/2021 DD 778 HDR ENGINEERING INC PROFESSIONAL SERVICES: ENGINEERING 1,578.72 130531 7/22/2021 CHK 3515 GRAYBAR ELECTRIC CO INC MATERIALS 1,676.15 130523 7/22/2021 CHK 134 ANIXTER INC. INVENTORY 2,175.83 31678 7/22/2021 DD 1430 JENNIFER STOLLARCHITECT TDPUD BUILDING MODERNIZATION PROJECT 2,700.00 31690 7/22/2021 DD 320 W&TGRAPHICS EMPLOYEE UNIFORMS 3,905.61 31681 7/22/2021 DD 820 ONESOURCE DISTRIBUTORS INVENTORY 4,593.28 31683 7/22/2021 DD 758 PAMELA HURT ASSOCIATES MEETING EXPENSES 5,900.00 130540 7/22/2021 CHK 1082 SIERRA NEVADA AD PARTNERS MARKETING 6,717.00 31672 7/22/2021 DD 515 BRAGG CRANE SERVICE CONTRACT SERVICES: ROW TREE CLEARING 8,743.20 31689 7/22/2021 DD 10737 US BANK GOVERNMENT SERVICES CREDIT CARD CHARGES 8,908.24 31687 7/22/2021 DD 712 TRUCKEE DONNER PUD PURCHASED POWER - STAMPEDE HYDRO GEN 11,993.68 31684 7/22/2021 DD 1466 ROADSAFE TRAFFIC SYSTEMS POLE CHANGE OUT 14,955.64 5049 7/22/2021 WIRE 540 CALPERS 457 DEFERRED COMP PRGM CALPERS 457 CONTRIBUTIONS PPE 07/16/2021 18,273.75 5052 7/22/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING PPE 07/16/2021 19,347.44 5047 7/22/2021 WIRE 38241CMA RETIREMENT TRUST 457 ICMA CONTRIBUTIONS PPE 07/16/2021 20,341.70 31691 7/22/2021 DD 1321 WRIGHT TREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 35,482.95 5048 7/22/2021 WIRE 11233 CALPERS PENSION 51,302.96 5050 7/22/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING PPE 07/16/2021 86,417.61 5026 7/22/2021 PL PL PAYROLL PAYROLL DIRECT DEPOSIT 188,657.07 5055 7/23/2021 WIRE 38241CMA RETIREMENT TRUST 457 ICMA CONTRIBUTIONS 9934 FINAL 210.22 5056 7/23/2021 WIRE 11233 CALPERS PENSION 240.02 5058 7/23/2021 WIRE 3094 EMPLOYMENT DEV DEPT SDI/STATE WITHHOLDING 9934 FINAL 240.85 5057 7/23/2021 WIRE 7310 INTERNAL REVENUE SERVICE FEDERAL/FICA WITHHOLDING 9934 FINAL 1,258.63 130548 7/23/2021 PL PL PAYROLL PAYROLL FINAL CHECK 3,221.11 31702 7/28/2021 DD 1079 O'REI LILY AUTO PARTS MISC PARTS & SUPPLIES - 130555 7/28/2021 CHK 1116 HUNT &SONS, INC FUEL FOR VEHICLES 47.39 31694 7/28/2021 DD 10809 BATTERIES PLUS REPAIRS & MAINTENANCE 91.97 130551 7/28/2021 CHK 1006 CALIFORNIA STATE DISBURSEMENT UNIT CHILD SUPPORT 115.38 130552 7/28/2021 CHK 1006 CALIFORNIA STATE DISBURSEMENT UNIT CHILD SUPPORT PPE 07/16/2021 115.38 31705 7/28/2021 DD 10414 SNAP -ON INDUSTRIAL CG TOOL ALLOWANCE 123.11 31700 7/28/2021 DD 4720 MOUNTAIN HARDWARE AND SPORTS WILDFIRE MITIGATION MATERIALS 152.69 31708 7/28/2021 DD 7313 TAHOE SUPPLY COMPANY FACILITY SUPPLIES 175.45 31698 7/28/2021 DD 1099 MOANA NURSERY PROFESSIONAL SERVICES: OTHER 185.00 130561 7/28/2021 CHK 5222 OFFICE DEPOT INC. OFFICE SUPPLIES 193.31 130556 7/28/2021 CHK 1176 CHRISTINE FJACKSON, O.D. VISION REIMBURSEMENT 205.00 31699 7/28/2021 DD 617 MOUNTAIN EAP WELLNESS PROGRAM 225.00 130553 7/28/2021 CHK 10203 DEPARTMENT OF INDUSTRIAL RELATIONS BUILDING MAINTENANCE 225.00 130568 7/28/2021 CHK 643 UNITED SITE SERVICES OF NEVADA MATERIALS 225.24 130554 7/28/2021 CHK 348 EDGES ELECTRICAL GROUP INVENTORY 329.51 31706 7/28/2021 DD 6604 SPIEGEL & MC DIARMID PROFESSIONAL SERVICES: FERC ISSUES 355.00 130570 7/28/2021 CHK 7820 WESTERN NEVADA SUPPLY INVENTORY 465.17 130564 7/28/2021 CHK 9985 EMPLOYEE VISION REIMBURSEMENT 562.50 130567 7/28/2021 CHK 548 THE AUTO & TIRE DOCTOR INC. REPAIRS & MAINTENANCE 578.28 130559 7/28/2021 CHK 11025 MOONSHINE INK MARKETING 696.00 31696 7/28/2021 DD 9637 CONRAD KRAUSS EMPLOYEE DEVELOPMENT 715.00 Page 3of4 Page 6 of 13 Check/Tran Date Type Vendor Vendor Name Reference Amount 31704 7/28/2021 DD 9504397 PACE SUPPLY INVENTORY 1,013.57 130565 7/28/2021 CHK 999 TAHOE FOREST HOSPITAL REFUND FACILITY FEES 1,125.00 130566 7/28/2021 CHK 536 TAHOE-TRUCKEE UNIFIED SCHOOL DISTRICT BOARD MEETING EXPENSES 1,400.00 130563 7/28/2021 CHK 11226 SHRED -IT USA LLC OFFICE SUPPLIES 1,633.00 31693 7/28/2021 DD 5440 ALTEC INDUSTRIES INC INVENTORY 2,627.64 130562 7/28/2021 CHK 4447 SD MYERS INC. MATERIALS 5,601.00 130569 7/28/2021 CHK 682 VERIZON WIRELESS CELL PHONE CHARGES 5,900.19 31695 7/28/2021 DD 893 DEBBIE MADERA CLEANING SERVICE BUILDING CLEANING 6,300.00 130558 7/28/2021 CHK 6401 LIBERTY UTILITIES ELECTRIC FOR PUMP STATION 6,741.99 31701 7/28/2021 DD 494 NVS, INC. 2021 PIPELINE REPLACEMENT PROJECT 8,136.82 130557 7/28/2021 CHK 3980 JENSEN PRECAST MATERIALS 8,514.95 130549 7/28/2021 CHK 1181 AMAZON/SYNCB COMPUTER EXPENSES 8,907.08 31703 7/28/2021 DD 820 ONESOURCE DISTRIBUTORS INVENTORY 9,864.85 130550 7/28/2021 CHK 6731 CALIFORNIA DEPARTMENT OF TAX AND FEE ELECTRICAL ENERGY SURCHARGE 11,631.00 31707 7/28/2021 DD 11304 STELLA-JONES CORPORATION INVENTORY 23,296.47 31697 7/28/2021 DD 1406 MEYERS NAVE PROFESSIONAL SERVICES: GENERAL COUNSEL 30,399.83 130560 7/28/2021 CHK 1349 NEVADA COUNTY AUDITOR PROFESSIONAL SERVICES: OTHER 32,721.00 31709 7/28/2021 DD 1321 WRIGHT TREE SERVICE, INC. CONTRACT SERVICES: ROW TREE CLEARING 35,960.18 31692 7/28/2021 DD 1393 ACWA JPIA WORKERS'COMP Q42021 58,220.02 289 $ 4,899,903.89 Page 4of4 Page 7 of 13 TRUCKEE DONNER PUBLIC UTILITY DISTRICT STATEMENT OF GENERAL FUND Activity for the Month Ended 6/30/2021 Page 1 of 2 Electric Dept Water Dept Total Balance in General Fund 5/31/2021 $11,744,271 $5,591,546 $17,335,817 Receipts: Revenue received Retired employees medical insurance Record interest earned Reimburse for Horse Butte power from AB32 Fund FF Funding and DL Surcharge Reimbursement for 2006 COP Funds transfer for TVI Investment Cash clearing accounts (timing -prior month reversal) Cash clearing accounts (timing -current month) Total Receipts Disbursements: Accounts payable/payroll disbursements Voided checks Transfer to TVI Investment SRF Transfer Distribute UPTIF interest Transfer to Capital Replacement Fund Restrict Donner Lake surcharge Restrict facilities fees Section 125 benefit disbursement Bank charges Total Disbursements Balance in General Fund 6/30/2021 2,684,058 1,345,610 4,029,668 19,979 - 19,979 4,128 602 4,730 1,400,000 - 1,400,000 - 37,700 37,700 1,977,818 993,209 2,971,027 (72,717) - (72,717) 63,958 - 63,958 6,077,225 2,377,121 $8,454,345 $2,176,956 $794,492 $2,971,447 (22,534) - (22,534) 2,023,947 1,004,813 3,028,760 - 36,412 36,412 1,610 986 2,596 257,486 1,015,747 1,273,233 - 9,226 9,226 75,613 110,287 185,900 13,133 - 13,133 7,449 - 7,449 $4,533,660 $2,971,964 $7,505,624 $13,287,835 $4,996,703 $18,284,539 8/24/2021 8:51 AM I:\Treasurers Report\Statement of General Fund\2021\2021-06 GF Page 8 of 13 TRUCKEE DONNER PUBLIC UTILITY DISTRICT Funds Status Report Activity for the Month Ended 6/30/2021 Page 2 of 2 Distribution of Non -Restricted Funds At Month -End: Customer Services Operating Funds Operating clearing accounts U.S. Bank -General Fund LAIF, UPTIF, PCIF, & TVI - General Fund Total Market Adjustment Total Non -Restricted Funds Distribution of Designated & Restricted Funds at Month -End: LAIF, UPTIF, PCIF & TVI - Restricted Funds UPTIF - TDPUD Prop 55 Reserve Fund UPTIF - Donner Lake Assessment District POB Deferred Liability Reserve Fund SRF DLAD Bond Reserve Fund/Payment Fund 2015 COP Water Bonds, Interest Payment Fund 2015 COP Water Bonds, Principal Payment Fund Donner Lake Federal Farm Credit Account U S Bank - Donner Lake Assessment District 00-1 Total Market Adjustment Total Restricted Funds Total Funds Available Total Market Adjustments Electric Dept Water Dept Total $2,400 $0 $2,400 63,958 - 63,958 1,144,835 - 1,144,835 12,076,642 4,996,703 17,073,346 $13,287,835 $4,996,703 $18,284,539 $56,852 $21,778 $78,630 $13,344,688 $5,018,481 $18,363,169 14,726,805 3,942,034 18,668,839 - 341,540 341,540 - 665,779 665,779 16 - 16 - 828,827 828,827 - 8,661 8,661 - 457,358 457,358 - 445 445 14,726,821 6,244,644 20,971,465 48,060 48,102 96,163 14,774,881 6,292,746 21,067,627 28,119,569 11,311,227 39,430,796 104,913 69,880 174,793 8/24/2021 8:51 AM I:\Treasurers Report\Statement of General Fund\2021\2021-06 GF Page 9 of 13 INVESTMENT STATUS REPORT Activity for the Month Ended 6/30/2021 Balance Beg.Balance Month End Balance %Current Month ( %Last Month) 12/31/2020 5/31/2021 Activity 6/30/2021 ELECTRIC FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.26% (0.32%) General Fund 1..136.1 $ 6,968,896 $ 8,823,485 $ (82,392) $ 8,741,093 Consolidate cash (551,119) Reimburse for Horse Butte Power 1,221,400 Funds Transfer to TVI Invest (1,995,187) Capital Reserve Transfer (257,486) LAIF transfer 1,500,000 Quarterly Investment Income payment received Capital Replacement Fund 136.41 1,181,925 1,185,616 257,486 1,443,102 Capital Reserve Transfer 257,486 AB 32 Cap & Trade Fund 1..136.58 1,606,959 1,780,243 (1,221,400) 558,843 Reimburse for Horse Butte Power (1,221,400) Deferred Liabilites Reserve 1..136.42 2,085,918 2,091,376 2,091,376 Quarterly Investment Income payment received Total LAIF Electric Investments 11,843,699 13,880,719 (1,046,306) 12,834,413 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.37% (0.40%) General Fund 1..136.12 1,690,317 916,454 (76,952) 839,502 Distribute UPTIF interest (1,610) Restrict facility fees (75,613) Record monthly interest 271 Facilities Fees 1..136.9 748,126 815,430 75,852 891,282 Restrict facilites fees 75,613 Record monthly interest 239 Electric Rate Reserve Fund 1..136.45 1,604,909 2,098,281 616 2,098,897 Record monthly interest 616 Capital Replacement Fund 136.46 833,092 834,751 245 834,996 Record monthly interest 245 Electric Vehicle Reserve 1..136.13 626,347 842,488 247 842,735 Record monthly interest 247 Total UPTIF Electric Investments 5,502,792 5,507,403 8 5,507,412 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.19%(0.24%) Electric General Fund PC1..136.49 524,852 525,434 (2,392) 523,042 Record monthly interest 108 TVI Interest Receivable (2,500) Electric Rate Reserve Fund 1..136.47 4,333,619 4,338,422 (1,996,610) 2,341,813 Record monthly interest 890 Funds Transfer for TVI Investment (2,000,000) TVI Interest Recievable 2,500 Capital Replacement Fund 1..136.48 1,621,632 1,623,429 333 1,623,762 Record monthly interest 333 Total PCIF County Electric Investments 6,480,103 6,487,285 (1,998,669) 4,488,617 TVI INVESTMENTS - 0.55% (0.00%) General Fund TVI 1..136.15 - - 1,973,005 1,973,005 Record Initial funds transfer for new investment 1,973,005 Electric Rate Reserve Fund 1..136.44 2,000,000 2,000,000 Record Initial funds transfer for new investment 2,000,000 Total TVI Electric Investments - - 3,973,005 3,973,005 Total Electric Investments $ 23,826,594 $ 25,875,408 $ 928,039 $ 26,803,447 8/24/2021 8:49AM Investments Status Report I:\Treasurers Report\Investment Status Repons\2021\2021-06 I nvestments Status Report Page 1of3 Page 10 of 13 INVESTMENT STATUS REPORT Activity for the Month Ended 6/30/2021 Balance Beg.Balance Month End Balance %Current Month ( %Last Month) 12/31/2020 5/31/2021 Activity 6/30/2021 WATER FUNDS LOCAL AGENCY INVESTMENT FUND (LAIF) - 0.26% (0.32%) General Fund 2..136.1 1,861,580 2,963,747 (1,616,141) 1,347,606 Consolidate cash 514,707 Quarterly Investment Income payment received - Restrict facility fees (110,287) Capital Reserve Transfer to Budget (1,015,747) Funds transfer for TVI Investment (1,004,813) DSC Operating Reserve Fund 2..136.47 76,677 (0) (0) Quarterly Investment Income payment received - Facilities Fees 2..136.90 948,794 1,226,376 110,287 1,336,663 Restrict facility fees 110,287 SRF/DLAD Reserve Fund 2..125.5 $26,526 $28,827 - $28,827 Investment Income - SRF Loan Payoff Capital Replacement Fund 2..136.48 - 1,015,747 1,015,747 Captial Reserve Transfer to Budget 1,015,747 DLAD Invested 2..136.82 1,704,588 (1,704,588) - Record monthly interest SRF Transfer (1,704,588) Total LAIF Water Investments 2,887,052 6,723,538 (2,194,694) 4,528,844 UTAH PUBLIC TREASURERS' INVESTMENT FUND (UPTIF) - 0.37% (0.40%) General Fund 2..136.12 848,478 708,364 27,695 736,059 Transfer to DLAD surcharge (9,226) Distribute UPTIF interest (986) DL Surcharge Reimbursement for 2006 COP 8,018 FF Funding portion of 2006 COP 29,682 Record monthly interest 208 Facilities Fees 2..136.25 $90,402 743,652 (29,463) 714,189 Record monthly interest 218 Transfer to GF for FF Funding portion of 2006 COP (29,682) West River St. Assessment District 2..136.31 38,065 38,140 11 38,152 Record monthly interest 11 Prepaid Connection Fees 2..136.7 77,788 77,943 23 77,966 Record monthly interest 23 Donner Lake Assessment District Fund 2..136.84 664,261 665,584 195 665,779 Record monthly interest 195 Donner Lake Assessment District Surcharge Fund 2..136.61 147,937 154,279 1,253 155,532 DLAD surcharge collections 9,226 DL Surcharge Reimbursement to GF for 2006 COP (8,018) Record monthly interest 45 TSA SAD II Improvement Fund 2..136.85 18,363 18,400 5 18,405 Record monthly interest 5 Water Vehicle Reserve 2..136.13 197,987 478,771 141 478,912 Record monthly interest 141 Deferred Liabilites Reserve 2..136.42 106,226 106,437 31 106,469 Record monthly interest 31 Prop 55 Reserve Fund 2..125.94 340,762 341,440 100 341,540 Record monthly interest 100 Total UPTIF Water Investments 3,330,269 3,333,010 (8) 3,333,002 PLACER COUNTY INVESTMENT FUND (PCIF) - 0.19% (0.24%) Water General Fund PC 2..136.5 375,541 1,919,435 394 1,919,829 Record monthly interest 394 DSC Operating Reserve Fund 2..136.49 1,541,769 0 - 0 Record monthly interest - Total PCIF Water Investments 1,917,311 1,919,435 394 1,919,829 8/24/2021 8:49AM Investments Status Report :,Treasurers Report,Investment StatusRepons\2021,2021.06 I nvestments Status Report Page 2of3 Page 11 of 13 TVI INVESTMENTS - 0.55% (0.00%) Water General Fund TVI 2..136.15 Record initial investment Total TVI Water Investments INVESTMENT STATUS REPORT Activity for the Month Ended 6/30/2021 Balance Beg.Balance Month End Balance %Current Month (%Last Month) 12/31/2020 5/31/2021 Activity 6/30/2021 993,209 993,209 993,209 993,209 993,209 Total Water Investments $ 8,134,631 $ 11,975,984 $ (1,201,100) $ 10,774,884 ELECTRIC & WATER INVESTMENTS, COMBINED TOTALS Pre - Market Adjustments Total LAIF Investments 46% 14,730,751 20,604,257 (3,241,000) 17,363,257 Total UPTIF Investments 24% 8,833,060 8,840,414 (0) 8,840,414 Total PCIF Investments 17% 8,397,414 8,406,721 (1,998,275) 6,408,446 Total TVI Investments 13% - - 4,966,214 4,966,214 Total Investments 100% Month End Bal.Mix $ 31,961,225 $ 37,851,392 $ (273,061) $ 37,578,331 Market Adjustments Total LAIF Investments 67,341 67,341 67,341 Total UPTIF Investments 33,897 33,897 33,897 Total PCIF Investments 62,280 62,280 - 62,280 Total TVI Investments - - 11,274 11,274 Total Investments $ 163,518 $ 163,518 $ 11,274 $ 174,793 Post - Market Adjustments Total LAIF Investments 46% 14,798,091 20,671,598 (3,241,000) 17,430,598 Total UPTIF Investments 24% 8,866,958 8,874,311 8,874,311 Total PCIF Investments 17% 8,459,694 8,469,001 (1,998,275) 6,470,726 Total TVI Investments 13% 4,977,488 4,977,488 Total Investments 100 % Month End Bal.Mix $ 32,124,743 $ 38,014,910 $ (261,786) $ 37,753,124 8/24/2021 8:49AM Investments Status Report I:\Treasurers Report\Investment Status Repons\2021\2021-06 I nvestments Status Report Page 3of3 Page 12 of 13 ELECTRIC FUNDS General Fund Facilities Fees Electric Rate Reserve Capital Replacement Fund Deferred Liabilites Reserve/POB Fund Electric Vehicle Reserve AB 32 Fund Market Adjustments Total Electric Investments WATER FUNDS General Fund Facilities Fees Capital Replacement Fund 2015 COP Funds DSC and Operating Reserve Fund West River St. Assessment District Deferred Liabilites Reserve Prepaid Connection Fees DLAD Fund DLAD Surcharge SRF Reserve and Payment Fund TSA SAD II Improvement Fund Water Vehicle Reserve Prop 55 Reserve Fund DLAD Investment Market Adjustments Total Water Investments Electric and Water, subtotal MELLO ROOS - OLD GREENWOOD Total Mello Roos - Old Greenwood MELLO ROOS - GRAY'S CROSSING Total Mello Roos - Gray's Crossing Total Investments TRUCKEE DONNER PUD INVESTMENT BALANCES as of June 30, 2021 Utah Public TVI Fidelity Mmkt Morgan Stanley Dreyfus Treasury Federated US US Bank Cash/ LAIF Placer County Investment Fund Investments Govt 57 Treas Sec Port Security Treas Cash Res Checking Cash clearings Total 131.1 $ 8,741,093 $ 523,042 $ 839,502 $ 1,973,005 $ $ $ $ $ 1,144,835 $ 66,358 $ 13,287,835 - - 891,282 - - - 891,282 - 2,341,813 2,098,897 2,000,000 6,440,709 1,443,102 1,623,762 834,996 - 3,901,860 2,091,376 - - 16 2,091,392 - 842,735 842,735 558,843 - - - 558,843 26,760 48,060 21,117 8,975 104,913 12,861,174 4,536,677 5,528,529 3,981,980 16 1,144,835 66,358 28,119,569 $ 1,347,606 $ 1,919,829 $ 736,059 $ 993,209 $ $ $ $ $ - $ - 4,996,703 1,336,663 - 714,189 - 2,050,852 1,015,747 - 1,015,747 - 466,019 466,019 (0) 0 0 38,152 38,152 106,469 106,469 77,966 77,966 665,779 445 666,224 - 155,532 - - 155,532 828,827 - 2,939,464 3,768,291 - 18,405 - 18,405 478,912 478,912 341,540 341,540 40,581 14,220 12,780 2,299 - - - 69,880 4,569,424 1,934,049 3,345,782 995,508 466,019 445 2,939,464 14,250,691 17,430,598 6,470,726 8,874,311 4,977,488 466,019 16 1,145,280 3,005,822 42,370,260 - - - - - 306,198 604,049 - - 910,247 - 306,198 604,049 - 910,247 1,906,096 - - 2,239,917 4,146,013 1,906,096 2,239,917 4,146,013 $ 19,336,694 $ 6,470,726 $ 8,874,311 $ 4,977,488 $ 466,019 $ 306,198 $ 604,065 $ 2,239,917 $ 1,145,280 $ 3,005,822 $ 47,426,520 2021 05 Last Month End Balances 22,577,694 8,469,001 8,874,311 - 375,616 306,195 1,053,635 2,239,907 2,577,948 75,117 46,549,424 Change from last month (3,241,000) (1,998,275) - 4,977,488 90,402 2 (449,570) 10 (1,432,668) 2,930,705 877,095 202006 PY Month End Balances 16,351,748 8,335,684 8,882,485 - 454,191 248,379 636,543 2,215,609 2,401,464 468,302 39,994,404 Change from PY Month 2,984,946 (1,864,957) (8,174) 11,827 57,819 (32,478) 24,308 (1,256,185) 2,537,520 7,432,116 202012 PYE Balances 17,525,627 8,459,694 8,866,958 137,681 306,183 5,716 769,266 2,635,065 440,819 39,147,008 Change from PYE 1,811,067 (1,988,968) 7,353 328,338 15 598,349 1,470,651 (1,489,786) 2,565,003 8,279,511 I:\Treasurers Report\2021\202-9 Treasurer's Mp-rt All Investments 202106 959 Page 13 of 13