HomeMy WebLinkAbout04.a. Review and Recommend Approval of Expenditures Incurred October 12, 2022 Through November 10, 2022Page 1 of 117
Item 4.a.
F__1_448�411C_S0
November 21, 2022
TO: FINANCE COMMITTEE
FROM: OLIVIA RUIZ, ACCOUNTING SUPERVISOR
KEVIN MIZUNO, FINANCE MANAGER
REVIEWED BY: PHILIPLEIBER, DIRECTOR OF FINANCE AND ADMINISTRATION
ROGER S. BAILEY, GENERAL MANAGER
SUBJECT: REVIEW AND RECOMMEND APPROVAL OF EXPENDITURES INCURRED
OCTOBER 12, 2022 THROUGH NOVEMBER 10, 2022
This packet contains a listing of all payments issued by Central San that have not yet been reviewed and
recommended for Board approval by the Finance Committee spanning the time frame of October 12,
2022 through November 10, 2022, as listed in the attached check register (Attachment 1).
This packet also includes two Procurement Card (P-Card) Expense Summary Reports (Attachments 2
and 5) as well as two P-Card Expense Detail Reports (Attachments 3 and 6) to provide additional details
on procurement card expenditures which are unable to be included in the system -generated check register
(Attachment 1). Total P-Card expenditures presented in Attachments 2, 3, 5 and 6, are slightly lower than
the total presented as being paid to US Bank on Attachment 1 as some cardholder's expense reports
have not yet been finalized and approved in the system by their supervisors, which prevents the posting of
the underlying expenses but does not prevent timely payment to US Bank. A reconciliation outlining the
differences, largely pertaining to timing issues, between the check register report and the p-card report is
provided in Attachments 4 and 7.
Following review and recommendation by the Finance Committee, the expenditures packet is then
distributed to the full Board for review and approval at the next regularly scheduled Board meeting.
Strategic Plan re -In
GOAL FOUR: Governance and Fiscal Responsibility
Strategy 1 - Promote and uphold ethical behavior, openness, and accessibility
ATTACHMENTS:
1. Expenditure Listing December 1, 2022
2. P-Card Summary Report Aug. -Sept. 2022
3. P-Card Expense Detail Report Aug. -Sept. 2022
4. P-Card Reconciliation September 2022
5. P-Card Expense Summary Report Sept. -Oct. 2022
November 21, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 4 of 244
Page 2 of 117
6. P-Card Expense Detail Report Sept. -Oct. 2022
7. P-Card Reconciliation October 2022
November 21, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 5 of 244
Page 3 of 117
Jl Central Contra Costa Sanitary District
Protecting public health and the environment 50191mhoff Place, Martinez, CA 94553-4392
Expenditures forApproval
Date Prepared:
December 1, 2022 11/10/22
Self -Insurance Fund 3405:
Regular Checks: Fund Amount
Dated from 11103.22 to 11/03/22
No. From 100098 to 100098 $ 117,834.93
Fund Total $ 117,834.93
Running Expense Fund 3406:
Regular Checks:
Dated from 10120/22
to
11/10122
No. From 307353
to
307413
$
2,290,636.32
307414
to
307500
$
1, 326,825.27
307501
to
307564
$
2,933,881.76
307565
to
307648
$
766,711.74
Fund Total
$
7,318,055.09
Sewer Construction Fund 3407:
Regular Checks:
Dated from
No. From
Payroll Fund 3408:
Pay Dates
Regular Checks:
Direct Deposit:
Wells Fargo Bank
CCCERA ACH
10/20/22
to
11 /10/22
201713
to
201727
$
896, 897.57
201728
to
201741
$
182,308.56
201742
to
201762
$
1,550,219.65
201763
to
201787
$
1,790,949.92
Fund Total
$
4,420,375.70
10128 & 11110
61045 to 61061
11 /09/22
$ 25,942,34
$ 2,103,549.72
$ 338,550.25
tl-r 11/10/2022
Submitted for approval: "In, Alt lUnb
K_ Mizuno 1 Date
Approved by Finance Committee:
eRecycled Paper
November 21, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 6 of 244
0,CENTRAL SAN
AiN:Y1F]lirN:Y19-li<tiif F7]:Iil.�:YYIi NRJhI■
N, IYY! Ptk:l,MAk11hlj,fA9MA91%1-1}pj
From Date : 09/23/2022
To Date : 10/24/2022
CCCSD P-Card Expense Report - Detail
Attachment 6
Page 11 of 12
Expense
Expense
Expense
Report
Card Holder
Merchant
Expense Item Description
Expense
Fund Name
Org Unit Name
Expense Type
Report Number
Date
Amount
Item Amount
Steve M Borrelli
HACH COMPANY
wo 552112 conductivity portable meter
$1,375.15
Operations and Maintenance Fund
Instrument Shop
General Repairs &Maintenance
Su lies
Steve M Borrelli
THERMOCOUPLE TECHNOLOGY L
wo 473028 hearth T/C wells
$1,252.49
Operations and Maintenance Fund
Instrument Shop
General Repairs & Maintenance
Supplies
Steve M Borrelli
HACH COMPANY
probe return not correctwo 554454
-$1,578.53
Operations and Maintenance Fund
Instrument Shop
Miscellaneous Expense
Steve M Borrelli
HACH COMPANY
wo 554454 ph probe
$1,378.80
Operations and Maintenance Fund
Instrument Shop
General Repairs &Maintenance
Su lies
Steve M Borrelli
PERMA PURE LLC
wo 556703 THC sample filters ( 5)
$2,367.98
Operations and Maintenance Fund
Instrument Shop
General Repairs &Maintenance
Su lies
Steve M Borrelli
HACH COMPANY
TURBIDITY LAMPS AND SPARESWO #
$1,140.04
Operations and Maintenance Fund
Instrument Shop
General Repairs & Maintenance
554526
Supplies
Steve M Borrelli
WESTIN (WESTIN HOTELS)
WEFTEC 2022 HOTEL
$640.12
Operations and Maintenance Fund
Instrument Shop
General Repairs & Maintenance
Supplies
Steve M Borrelli
WESTIN (WESTIN HOTELS)
WEFTEC 2022 HOTEL
$160.03
Operations and Maintenance Fund
Instrument Shop
Travel/Training/Conference (Out -of -
State
Steve M Borrelli
HACH COMPANY
CONDUCTIVITY PROBE SOLUTION
$268.21
Operations and Maintenance Fund
Instrument Shop
General Repairs & Maintenance
WO # 552112
Supplies
Steve M Borrelli
CPI'COLEPARMERINSTRUMT
TURBIDITY METER SOLUTION SHOP
$1 489 99
Operations and Maintenance Fund
Instrument Shop
General Repairs & Maintenance
SUPPLY
Supplies
Steve M Borrelli
HACH COMPANY
CONDUCTIVITY PROBE SOLUTION
$73.80
Operations and Maintenance Fund
Instrument Shop
General Repairs & Maintenance
WO # 552112
Supplies
Steve M Borrelli
OMEGA 'ENGINEERING
CEM NOX TEMP FITTING
$234.09
Operations and Maintenance Fund
Instrument Shop
General Repairs & Maintenance
Supplies
Billy D Bowers
AKON LLC
Freezer curtain W/O 556759
$1,259.39
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
7/8-14 flange nuts W/O 548820
$38.07
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
1 1/8" and 1" hammer drill bits W/O
$195.21
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
556759
Services
Billy D Bowers
MCMASTER-CARR
Drill bits, welding curtains and hooks
$gg1.76
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
W/O 556759
Services
Billy D Bowers
AMZN MKTP US'H89BJ4TK1
Dry erase board
$217.39
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
24" x 48" X 3/16 steel plate- Inventory
$574.92
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
4" x 3/16" thick and 1 1/2" x 1/8" steel flat
$140.89
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
bar-inventoryServices
Billy D Bowers
MCMASTER-CARR
5/16 helical inserts to restock our kit
$38.46
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
18" x 18" 2 1/4" thick aluminum -stock
$947.99
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
Various sizes of set screws for shop
$221.87
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
inventory
Services
ER-000089202032
10-20-2022
$13,100.85
Billy D Bowers
MCMASTER-CARR
Stainless steel clamp collars and
$1,870.76
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
titanium bolts W/O 374212
Services
Billy D Bowers
ZORO TOOLS INC
Polyethylene carts for machine shop
$359.40
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
projects
Services
Billy D Bowers
ZORO TOOLS INC
80 grit abrasive blast media -aluminum
$403.51
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
oxide
Services
Billy D Bowers
AMZN MKTP US'142DU1IE2
6' x 8' tarp W/O 556759
$45.66
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
Harsh environment digital calipers-
$613.16
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Machine shoptoolingServices
Billy D Bowers
ZORO TOOLS INC
Abrasive blast cabinet
$3,663.42
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
AMZN MKTP US'1485D99N2
10'x12' brown tarp and paint stir sticks
$76.63
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
W/O 556759
Services
Billy D Bowers
MCMASTER-CARR
5/16 Tip ID Abrasive Blasting gun
$177.03
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
1" x 1" key stock -Inventory
$186.52
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
Washers, 518-18 threaded rod, helical
$110.59
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
inserts W/O 551125
Services
Billy D Bowers
MCMASTER-CARR
Various diameters 4140 alloy round bars,
$1,200.67
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
various size taps -Machine shopServices
November 21, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 118 of 244
0,CENTRAL SAN
AiN:Y1F]lirN:Y19-li<tiif F7]:Iil.�:YYIi NRJhI■
N, IY ! Ptk�l,MAk11hlj,fA9iry.%}-1}pj
From Date : 09/23/2022
To Date : 10/24/2022
CCCSD P-Card Expense Report - Detail
Attachment 6
Page 12 of 12
Expense
Report Number
Expense
Date
Expense
Report
Card Holder
Merchant
Expense Item Description
Expense
Item Amount
Fund Name
Org Unit Name
Expense Type
Amount
inventory
Billy D Bowers
GRAINGER
Panel filter holders W/O 554548
$241.53
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
Services
Billy D Bowers
MCMASTER-CARR
Polypropylene cinching straps W/O
$76.02
Operations and Maintenance Fund
Machine Shop
General Repairs & Maintenance
550224
Services
Timothy R Hiteshew
DMI* DELL K-12/GOVT
(2) Dell Docking Stations- Liana 0. &
Chris C.
$609.98
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment &Supplies
Timothy R Hiteshew
AMAZON.COM*HTOG62QO2 AMZN
Brother HL Printer- Chris C.
$130.48
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment &Supplies
Timothy R Hiteshew
WWW.IANDI.COM
centralsan.com domain renewal
$15.17
Operations and Maintenance Fund
Information Technology Division
General
Computer Software License
Timothy R Hiteshew
AMZN MKTP US*HT2Zl5AJ2
Anker Vertical Mouse & Ergonomic
Keyboard- Liana 0.
$58.24
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment & Supplies
Timothy R Hiteshew
CBI*TENABLE
Nessus Professional Annual
Subscription
$3,190.00
Operations and Maintenance Fund
Information Technology Division
General
Computer Software License
Timothy R Hiteshew
DMI* DELL K-12/GOUT
(2) Dell Lattitude laptops- Liana 0. &
Chris C.
$3,304.16
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment & Supplies
Timothy R Hiteshew
AMZN MKTP US*1KILB4632
(2) Lenovo AC Adapters- Stephanie K.
(Spare)
$71.78
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment & Supplies
Timothy R Hiteshew
HNS*HUGHESNET.COM
HughesNet Satellite Internet Service
Installation- MPR
$619.22
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment &Supplies
Timothy R Hiteshew
CERBERUS* CERBERUS, ILL.
Cerberus FTP Annual License
$300.00
Operations and Maintenance Fund
Information Technology Division
General
Computer Software License
Timothy R Hiteshew
AMAZ0N.00M*1K2UM4FB1 AMZN
(2) Answering Machines- Control Room
$32.56
Operations and Maintenance Fund
Information Technology Division
Computer Equipment &Supplies
Timothy R Hiteshew
DMI* DELL K-12/GOVT
(1) Dell Latitude laptop- Stacey D.
$1,897.97
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment & Supplies
ER-000088772026
10-23-2022
$15,120.51
Information Technology Division
Timothy R Hiteshew
DMI* DELL K-12/GOUT
Dell Docking Station- Stacey D.
$329.94
Operations and Maintenance Fund
General
Compute r Equipment &Supplies
Timothy R Hiteshew
FS *TECHSMITH
(5) SnaglT Annual Maintenance- GIS
$42.40
Operations and Maintenance Fund
Information Technology Division
General
Computer Software License
Timothy R Hiteshew
FS *TECHSMITH
(5) Camtasia Annual Maintenance- GIS
$215.00
Operations and Maintenance Fund
Information Technology Division
General
Computer Software License
Timothy R Hiteshew
AMAZON.COM*147x46G31
Bluetooth Headset- Katie Y.
$108.59
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment & Supplies
Timothy R Hiteshew
NGROK JMQ24AESEEU-0031
NGROK Secure Tunnel
$15.00
Operations and Maintenance Fund
Information Technology Division
General
Cloud Software as a Service (SaaS)
Timothy R Hiteshew
AMZN MKTP US*1444N84CO
Cat 6 Ethernet Cable- CSO
$6.53
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment & Supplies
Timothy R Hiteshew
AMZN MKTP US*1450581_61
Cat 6 Ethernet Cable- CSO
$28.26
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment &Supplies
Timothy R Hiteshew
LENOVO UNITED STATES
Lenovo X1 Carbon Laptop- Tad P.
$1,668.65
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment &Supplies
Timothy R Hiteshew
DMI* DELL K-12/G0VT
Dell Latitude Laptop- Jose V.
$1,641.33
Operations and Maintenance Fund
Information Technology Division
General
Computer Equipment & Supplies
Timothy R Hiteshew
KIS
(15) Meraki System Manager Licenses
$606.60
Operations and Maintenance Fund
Information Technology Division
General
Computer Software License
Timothy R Hiteshew
I DMI* DELL K-12/GOUT
Annual Hardware Support-
DistSurve Files PE server
$228.65
Operations and Maintenance Fund
Information Technology Division
General
Computer Repairs & Maintenance
Amy J Compaglia
MCCAMPBELL ANALYTICAL
Employee Onsite Covid Testing
$20,160.00
Operations and Maintenance Fund
Human Resources General
Testing Services
ER-000088744305
10-06-2022
$42,260.00
Amy J Compaglia
MCCAMPBELLANALYTICAL
Onsite Employee Covid Testing
$22,100.00
Operations and Maintenance Fund
Human Resources General
Testing Services
Total Ex ense Report Amount
$228,852.44
$228,852.44
November 21, 2022 Regular FINANCE Committee Meeting Agenda Packet -Page 119 of 244
Attachment 7
P-card Reconciliation
US Bank Statement End Date:
10/24/2022
Expense Report Timeframe (from/to):
9/23/2022
- 10/23/2022
Expense Report Run Date:
11/10/2022
US Bank Amount (Paid)
$ 241,658.41
Unadjusted P-card Expense Report
Accidental Personal Charges (owed to District)
Unsubmitted expense reports (as of P-card report run date)
ER-000080894136 St. John
$ (51.57)
Ortega, John
Smith, Joy
Brown, Jason
Mizuno, Kevin
McElley, Shane
Parks, Velisa
Fraudulent Charges (being contested)
Unapproved expense reports (as of P-card report run date)
None
$
ER-000088734854 Crawford - Missing Documentation
Reimbursement/Credit of Fraudulent Charge or other
Consolidated expense reports:
None
$
None
Current Holds/(Releases of Prior Holds l
Other (Reports submitted not included on Oracle Report)
None
$
None
US Bank Amount (Statement)
$ 241,606.84 Adjusted P-card Expense Report
Difference
$ 228,852.44 $ 12,805.97
$ 3,265.52
$ 1,848.51
$ 123.57
$ 200.00
$ 325.36
$ 4,100.36
$ 2,891.08
$ 241,606.84 $
November 21, 2022 Regular FINANCE Committee Meeting Agenda Packet - Page 120 of 244