Agenda packet — Lemoore City Council, October 4, 2022

MEETING AGENDA
Please silence all electronic devices as a courtesy to those in attendance. Thank you.

Regular Session will begin immediately following Closed Session. 5:30 p.m. CLOSED SESSION
This item has been set aside for the City Council to meet in a closed session to discuss matters pursuant to Government Code Section 54956.9(d)(4). The City Attorney will provide an oral report regarding the Closed Session at the beginning of the next regular City Council meeting.

1. Government Code Section 54956.9
Conference with Legal Counsel – Anticipated Litigation
Initiation of Litigation Pursuant to Paragraph (4) of Subdivision (d) of Section 54956.9 (Deciding Whether to Initiate Litigation)
One Case

REGULAR SESSION
a. CALL TO ORDER
b. INVOCATION
c. PLEDGE OF ALLEGIANCE
d. ROLL CALL
f. AGENDA APPROVAL, ADDITIONS, AND/OR DELETIONS

PUBLIC COMMENT
Public comment will be in accordance with the attached policy. This time is reserved for members of the audience to address the City Council on items of interest that are not on the Agenda and are within the subject matter jurisdiction of the Council. It is recommended that speakers limit their comments to three (3) minutes each and it is requested that no comments be made during this period on items on the Agenda. The Council is prohibited by law from taking any action on matters discussed that are not on the Agenda. Prior to addressing the Council, any handouts for Council will be provided to the City Clerk for distribution to the Council and appropriate staff. The public will have an opportunity to comment on items on the agenda once the item has been called and the Mayor opens the item to the public.

CEREMONIAL / PRESENTATION – Section 1
No Ceremonies or Presentations.

DEPARTMENT AND CITY MANAGER REPORTS – Section 2
2-1 Department & City Manager Reports

LEMOORE

CALIFORNIA

LEMOORE CITY COUNCIL

COUNCIL CHAMBER
429 C STREET
October 4, 2022
1 CONSENT CALENDAR – Section 3
Items considered routine in nature are placed on the Consent Calendar. They will all be considered and voted upon in one vote as one item unless a Council member or member of the public requests individual consideration. 3-1 Approval – Minutes – Regular Meeting – September 20, 2022 3-2 Approval – Resolution 2022-37 – Authorizing Continued Use of Remote Teleconferencing Provisions (AB 361)
3-3 Approval – Biennial Review of Conflict of Interest Code 3-4 Approval – First Amendment to the Facility Use Agreement between the City of Lemoore and Lemoore Little League
3-5 Approval – Resolution 2022-38 – Accepting AMG & Associates Offer for the Sale and Development of Surplus Land Owned by the City of Lemoore and Authorize the City Manager to Enter into Escrow (APNs 023-020-065 and 023-020-064) 3-6 Approval – Budget Amendment – CIP 5013 – Bush Street Overlay PUBLIC HEARINGS – Section 4
Report, discussion and/or other Council action will be taken.

No Public Hearings.

NEW BUSINESS – Section 5
Report, discussion and/or other Council action will be taken.

No New Business.

BRIEF CITY COUNCIL REPORTS AND REQUESTS – Section 6
6-1 City Council Reports / Requests

ADJOURNMENT
Upcoming Council Meetings
• City Council Regular Meeting, Tuesday, October 18, 2022 • City Council Regular Meeting, Tuesday, November 1, 2022 Agendas for all City Council meetings are posted at least 72 hours prior to the meeting at the Council Chamber, 429 C Street and the Cinnamon Municipal Complex, 711 W. Cinnamon Drive. Written communications from the public for the agenda must be received by the City Clerk’s Office no less than seven (7) days prior to the meeting date. The City of Lemoore complies with the Americans with Disabilities Act (ADA of 1990). The Council Chamber is accessible to the physically disabled. Should you need special assistance, please call (559) 924-6744, at least 4 business days prior to the meeting.

PUBLIC NOTIFICATION
I, Marisa Avalos, City Clerk for the City of Lemoore, declare under penalty of perjury that I posted the above Regular City Council Agenda for the meeting of October 4, 2022 at Council Chamber, 429 C Street and Cinnamon Municipal Complex, 711 W. Cinnamon Drive, Lemoore, CA on September 30, 2022. //s//
Marisa Avalos, City Clerk
2 CITY OF LEMOORE

CITY COUNCIL REGULAR MEETING
OCTOBER 4, 2022 @ 5:30 p.m.

All upcoming regular and special City Council meetings will be open to members of the public on a first come, first served basis and via Zoom. The meeting may be viewed through the following options:
• Join Zoom Meeting
• Please click the link below to join the webinar:
• https://us06web.zoom.us/j/83088939098?pwd=aEo4Undxb0ZZU2swRjVqMTFwQllJZz09 • Meeting ID: 830 8893 9098
• Passcode: 382866
• Phone: +1 669 900 6833
The City will also provide links to streaming options on the City’s website and on its Facebook page.

If you wish to make a general public comment or public comment on a particular item on the agenda, participants may do so via Zoom during the meeting or by submitting public comments by e-mail to: [email protected]. In the subject line of the e-mail, please state your name and the item you are commenting on. If you wish to submit a public comment on more than one agenda item, please send a separate e-email for each item you are commenting on. Please be aware that written public comments, including your name, may become public information.

Additional requirements for submitting public comments by e-mail are provided below.

General Public Comments & Comments on City Council Business Items For general public comments and comments regarding specific City Council Business Items, public comments can be made via Zoom during the meeting or all public comments must be received by e-mail no later than 5:00 p.m. the day of the meeting. Comments received by this time will be read aloud by a staff member during the applicable agenda item, provided that such comments may be read within the normal three (3) minutes allotted to each speaker. Any portion of your comment extending past three (3) minutes may not be read aloud due to time restrictions.

If a general public comment or comment on a business item is received after 5:00 p.m., efforts will be made to read your comment into the record. However, staff cannot guarantee that written comments received after 5:00 p.m. will be read. All written comments that are not read into the record will be made part of the meeting minutes, provided that such comments are received prior to the end of the City Council meeting.

Public Hearings
For public comment on a public hearing, all public comments must be received by the close of the public hearing period. All comments received by the close of the public hearing period will be read aloud by a staff member during the applicable agenda item, provided that such comments may be read within the normal three (3) minutes allotted to each speaker. Any portion of your comment extending past three (3) minutes may not be read aloud due to time restrictions. If a 3 comment on a public hearing item is received after the close of the public hearing, such comment will be made part of the meeting minutes, provided that such comment is received prior to the end of the meeting.
*PLEASE BE AWARE THAT ANY PUBLIC COMMENTS RECEIVED THAT DO NOT

SPECIFY A PARTICULAR AGENDA ITEM WILL BE READ ALOUD DURING THE GENERAL PUBLIC COMMENT PORTION OF THE AGENDA.*
The City thanks you for your cooperation in advance. Our community’s health and safety is our highest priority.
4 Item 3-1
September 20, 2022 Minutes
Lemoore City Council Meeting
Study Session Meeting
CALL TO ORDER:

At 5:30 p.m., the meeting was called to order.

ROLL CALL: Mayor: LYONS
Mayor Pro Tem: MATTHEWS
Council Members: CHANEY, GORNICK, ORTH
City Staff and contract employees present: City Manager Olson; City Attorney Lerner; Police Chief Kendall; Public Works Director Rivera; Management Analyst Reeder; City Clerk Avalos.

STUDY SESSION
SS-1 Social Media Policy (Olson)
City Manager Olson provided information on the City’s current Social Media policy and seek direction from Council on possibly turning off the “Comment” portion on social media platforms.

Spoke: Tom Reed
Alex Walker
Ed Miller
Consensus was received from Council to not make any changes to the Social Media Policy.

At 5:55 p.m. Council went into Closed Session.

CLOSED SESSION

2. Government Code Section 54956.9
Conference with Legal Counsel – Exposure to Litigation
Significant Exposure to Litigation Pursuant to Paragraph (2) or (3) of Subdivision (d) of Section 54956.9
Two Cases
5 September 20, 2022 Minutes
Lemoore City Council Meeting
Regular Session Meeting
CALL TO ORDER:

At 6:34 p.m., the meeting was called to order.

ROLL CALL: Mayor: LYONS
Mayor Pro Tem: MATTHEWS
Council Members: CHANEY, GORNICK , ORTH
City Staff and contract employees present: City Manager Olson; City Attorney Lerner; Public Works Director Rivera; Police Chief Kendall; Management Analyst Reeder, City Clerk Avalos.

AGENDA APPROVAL, ADDITIONS, AND/OR DELETIONS
No agenda additions or deletions.

CLOSED SESSION REPORT
Nothing to Report.

PUBLIC COMMENT
Alex Walker thanked all City employees for their service. Encouraged the City to research other avenues of social media platforms such as LinkedIn.

CEREMONIAL / PRESENTATION – Section 1
No Ceremonies or Presentations.

DEPARTMENT AND CITY MANAGER REPORTS – Section 2
Community Services Manager Greenlee introduced the new Recreation Coordinators Stephany and Niyant. Rumble at the Rec was held this weekend at the Recreation Center. There were a few vendors that supported the event. He thanked the maintenance department, American Ambulance, Glaspie family, Recreation staff, and Police Department. There were 22 bouts. Flag Football games are starting Saturday, September 24th. There will be a cornhole tournament on Saturday the 24th at the Recreation Center. The building division is working with Lennar homes.

They will be beginning the process of applying for permits. Working on updating the building codes. Updates are done every three years.

Chief Kendall stated that Reserve Officer Alec Contreras was promoted to Full Time Officer. He was the last Reserve Officer. Held Reserve Officer interviews today and will continue to build the Reserve program. Coffee with a Cop is scheduled for October 25th at the Senior Center. Still accepting applications for the Citizens Academy.

Public Works Director Rivera stated that poles have been installed at the Slate Park for the shades. The shades will be installed in a couple of weeks. 12-14 canopies are going up at the Sports Complex. Bids were reviewed for the C Street Parking Lot project. 6 City Manager Olson attended the League of California Cities Conference. He has a few follow up meetings from the Conference. He has a meeting with Art Diaz at the old City Hall building to discuss plans. The City is hosting the City County Coordinating meeting at the Veteran’s Hall at 5:30 p.m. James Preston with West Hills and Nathan Alonzo with PG&E will be present to speak.

CONSENT CALENDAR – Section 3
3-1 Approval – Minutes – Regular Meeting – September 20, 2022 3-2 Approval – Budget Amendment – SB2 Planning Grant Awarded in the Amount of $160,000 from the California Department of Housing and Community Development – Grant Expiration Date Extended
3-3 Approval – Budget Amendment – Create CIP for 2019 State Homeland Security Grant Program Funding
3-4 Approval – Bid Award – Powers Construction – C Street Parking Lot Project 3-5 Approval – Budget Amendment – Create CIP for Cimarron Lift Station 3-6 Approval – Budget Amendment – PFMD Zone 1
Motion by Council Member Gornick, seconded by Mayor Pro Tem Matthews, to approve the Consent Calendar, as presented.

Ayes: Gornick, Matthews, Chaney, Orth, Lyons
PUBLIC HEARINGS – Section 4
No Public Hearings.

NEW BUSINESS – Section 5
No New Business.

BRIEF CITY COUNCIL REPORTS AND REQUESTS – Section 6
6-1 City Council Reports / Requests
Council Member Chaney thanked all City employees and residents of Lemoore.

Council Member Gornick attended the League of California Cities in Long Beach. He inquired if there will be a notice to residents that live near the old City Hall in regards to what the building’s intended use will be.

Council Member Orth also attended the League of California Cities Conference. It was very enlightening. He commented on the new City job flyers. He likes the pictures and stated they look nice. He requested another Holiday Bake event for the City employees amongst the Council. He thanked staff, police and fire. He congratulated the new Recreation employees.

Mayor Pro Tem Matthews attended League of California Cities Conference. Prop 47 – there is momentum to fix the issues. The Rural City Information Exchange allowed smaller cities to get together. Rumble at the Rec was an amazing event. Attending a KWRA meeting next week. LHS Homecoming parade is September 30th. Thanked all employees from different departments.

Welcomed the Recreation Coordinators.
7 Mayor Lyons thanked the Recreation Coordinators. He stated that he has heard a lot of great things. Requesting a Tree Lighting Ceremony. He spoke with Downtown businesses and all were for it. He thanked staff, police and fire.

ADJOURNMENT
At 7:05 p.m., Council adjourned.

Approved the 4th day of October 2022.

APPROVED:

Stuart Lyons, Mayor
ATTEST:

Marisa Avalos, City Clerk
8 City of

LEMOORE

CALIFORNIA
711 W. Cinnamon Drive  Lemoore, California 93245  (559) 924-6744 Staff Report
Item No: 3-2
To: Lemoore City Council
From: Nathan Olson, City Manager
Date: September 19, 2022 Meeting Date: October 4, 2022
Subject: Resolution 2022-37 – Authorizing Continued Use of Remote Teleconferencing Provisions (AB 361)
Strategic Initiative:
☐ Safe & Vibrant Community ☐ Growing & Dynamic Economy
☐ Fiscally Sound Government ☐ Operational Excellence
☐ Community & Neighborhood Livability ☐ Not Applicable
Proposed Motion:

Approve Resolution 2022-37, Authorizing the City Manager, or designee, to Continue with Teleconferenced Public Meetings Pursuant to Assembly Bill 361.

Subject/Discussion:

On September 16, 2021, the California legislature passed Assembly Bill (“AB”) 361, which amends Government Code, section 54953 and permits a local agency to use teleconferencing to conduct its meetings in any of the following circumstances: (A) the legislative body holds a meeting during a proclaimed state of emergency, and state or local officials have imposed or recommended measures to promote social distancing; (B) the legislative body holds a meeting during a proclaimed state of emergency for the purpose of determining, by majority vote, whether as a result of the emergency, meeting in person would present imminent risks to the health or safety of attendees; or (C) the legislative body holds a meeting during a proclaimed state of emergency and has determined, by majority vote, pursuant to subparagraph (B), that, as a result of the emergency, meeting in person would present imminent risks to the health or safety of attendees.

In order for the City Council to use teleconferencing as allowed by AB 361 after October 1, 2021, it must first adopt findings in a resolution, allowing the City Council to conduct teleconferenced meetings for a period of thirty (30) days. The City Council made such findings on May 23, 2022. In addition, AB 361 requires the City make specified findings every 30 days thereafter. Such additional findings were made by the City Council on June 15, 2022, July 5, 2022, August 2, 2022, August 16, 2022, and September 6, 2022. 9 Financial Consideration(s):

No substantial costs noted.

Alternatives or Pros/Cons:

Do not continue with virtual meetings.

Commission/Board Recommendation:

Not Applicable
Staff Recommendation:

Staff recommends City Council approve Resolution 2022-37, Authorizing the City Manager to Continue with Teleconferenced Public Meetings Pursuant to Assembly Bill 361.

Attachments: Review: Date:
☒ Resolution: 2022-37 ☒ Asst. City Manager 09/28/2022
☐ Ordinance: ☒ City Attorney 09/29/2022
☐ Map ☒ City Clerk 09/29/2022
☐ Contract ☒ City Manager 09/29/2022
☐ Other ☐ Finance
List:
10 RESOLUTION NO. 2022-37

A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF LEMOORE AUTHORIZING CONTINUED USE OF REMOTE TELECONFERENCING PROVISIONS (AB 361) WHEREAS, the City Council of the City of Lemoore (“City Council”) is committed to open and transparent government, and full compliance with the Ralph M. Brown Act (“Brown Act”); and
WHEREAS, the Brown Act generally requires that a public agency take certain actions in order to use teleconferencing to attend a public meeting virtually; and WHEREAS, the City Council recognizes that a local emergency persists due to the worldwide COVID-19 pandemic; and
WHEREAS, the California Legislature has recognized the ongoing state of emergency due to the COVID-19 pandemic and has responded by creating an additional means for public meetings to be held via teleconference (inclusive of internet-based virtual meetings); and WHEREAS, on September 16, 2021, the California legislature passed Assembly Bill (“AB”) 361, which amends Government Code, section 54953 and permits a local agency to use teleconferencing to conduct its meetings in any of the following circumstances: (A) the legislative body holds a meeting during a proclaimed state of emergency, and state or local officials have imposed or recommended measures to promote social distancing; (B) the legislative body holds a meeting during a proclaimed state of emergency for the purpose of determining, by majority vote, whether as a result of the emergency, meeting in person would present imminent risks to the health or safety of attendees; or (C) the legislative body holds a meeting during a proclaimed state of emergency and has determined, by majority vote, pursuant to subparagraph (B), that, as a result of the emergency, meeting in person would present imminent risks to the health or safety of attendees; and
WHEREAS, in order for the City Council to use teleconferencing as allowed by AB 361 after October 1, 2021, it must first adopt findings in a resolution, allowing the City Council to conduct teleconferenced meetings for a period of thirty (30) days. Such adoption occurred by the City Council on May 23, 2022; and
WHEREAS, AB 361 requires the City make specified findings every 30 days thereafter; and
WHEREAS, such additional findings were made by the City Council on May 23, 2022, June 15, 2022, July 5, 2022, August 2, 2022. August 16, 2022 and September 6, 2022 with the approval of Resolutions No. 2022-22, 2022-25, 2022-29, 2022-33, 2022-34 and 2022-35; and WHEREAS, Governor Gavin Newsom declared a state of emergency for the State of California due to the COVID-19 pandemic in his order entitled “Proclamation of a State of Emergency,” signed March 4, 2020; and/or
11 WHEREAS, the California Occupational and Safety Health Administration (OSHA) continues to recommend certain social distancing requirements, as described in detail in California Code of Regulations Title 8, section 3205 Covid Prevention; and/or WHEREAS, the County of Kings Department of Public Health in its August 28, 2021 press release urged “…everyone to physical distance themselves from others…” and further recommends as a “very effective” step that people can take: “Stay in your home as much as possible. The only exceptions should be for getting food and/or necessary household supplies, medications and medical treatments.”
WHEREAS, the City Council hereby finds that the state and local emergencies have caused and will continue to cause imminent risks to the health or safety of attendees; and WHEREAS, the City Council is conducting its meetings through the use of telephonic and internet-based services so that members of the public may observe and participate in meetings and offer public comment.

NOW THEREFORE, BE IT RESOLVED, that the recitals set forth above are true and correct and fully incorporated into this Resolution by reference.

BE IT FURTHER RESOLVED, that the City Council is conducting meetings during a state of emergency and OSHA recommends measures to promote social distancing; and/or BE IT FURTHER RESOLVED, that the City Council has determined that given the state of emergency, holding in-person only meetings would present imminent risks to the health or safety of attendees.

BE IT FURTHER RESOLVED, that the actions taken by the City Council through this resolution shall be applied to all City committees governed by the Brown Act unless otherwise desired by that committee.

BE IT FURTHER RESOLVED, the City Council authorizes the City Manager or their designee(s) to take all actions necessary to continue to conduct City Council meetings in accordance with Government Code section 54953(e) and all other applicable provisions of the Brown Act, using teleconferencing for a period of thirty (30) days from the adoption of this Resolution after which the City Council will again reconsider the circumstances of the state of emergency.
12 PASSED AND ADOPTED by the Lemoore City Council on this 4th day of October 2022, by the following vote:

AYES:

NOES:

ABSENT:

ABSTAIN:

ATTEST: APPROVED:
_________________________ _________________________
Marisa Avalos Stuart Lyons
City Clerk Mayor
13 City of

LEMOORE

CALIFORNIA
711 West Cinnamon Drive  Lemoore, California 93245  (559) 924-6744  Fax (559) 924-9003 Staff Report
Item No: 3-3
To: Lemoore City Council
From: Marisa Avalos, City Clerk
Date: September 20, 2022 Meeting Date: October 4, 2022
Subject: Biennial Review of Conflict of Interest Code
Strategic Initiative:
☐ Safe & Vibrant Community ☐ Growing & Dynamic Economy
☐ Fiscally Sound Government ☒ Operational Excellence
☐ Community & Neighborhood Livability ☐ Not Applicable
Proposed Motion:

Approve the 2022 Local Biennial Notice, reflecting no changes to the Conflict of Interest Code.

Subject/Discussion:

In accordance with California Statute, staff has performed the required Biennial Review of the Lemoore Municipal Code Ordinance pertaining to Conflict of Interest. This document serves to memorialize the review, along with the attached “2022 Local Agency Biennial Notice.” Resolution 2020-31 was adopted on September 1, 2020, approving a revised Conflict of Interest Code.

The attached 2022 Local Agency Biennial Notice reflects that no additional changes to the code are needed at this time. Staff will review and update the Conflict of Interest Code in 2024 if needed.

Financial Consideration(s):

No financial impact to the City.

Alternatives or Pros/Cons:

Pros:
14 • Ensures the City is compliant with state law.

Cons:
• None noted.

Commission/Board Recommendation:

Not Applicable.

Staff Recommendation:

Approval of the 2022 Local Biennial Notice, reflecting no changes to the Conflict of Interest Code.

Attachments: Review: Date:
☐ Resolution: ☒ Asst. City Manager 09/28/2022
☐ Ordinance: ☒ City Attorney 09/29/2022
☐ Map ☒ City Clerk 09/29/2022
☐ Contract ☒ City Manager 09/29/2022
☒ Other ☐ Finance
List: 2022 Local Agency Biennial
15 16
City of

LEMOORE

CALIFORNIA
711 West Cinnamon Drive  Lemoore, California 93245  (559) 924-6744 Staff Report
Item No: 3-4
To: Lemoore City Council
From: Nathan Olson, City Manager
Date: September 16, 2022 Meeting Date: October 4, 2022
Subject: First Amendment to the Facility Use Agreement between the City of Lemoore and Lemoore Little League
Strategic Initiative:
☐ Safe & Vibrant Community ☐ Growing & Dynamic Economy
☒ Fiscally Sound Government ☒ Operational Excellence
☒ Community & Neighborhood Livability ☐ Not Applicable
Proposed Motion:

Approve the First Amendment to the Facility Use Agreement Extension between the City of Lemoore and Lemoore Little League and authorize the City Manager or designee to execute.

Subject/Discussion:

At the September 6, 2022 City Council meeting, consensus was received by the Council for staff to bring the Facility Use Agreement between the City of Lemoore and Lemoore Little League to Council for an extension. Lemoore Little League is working on rehabilitating and improving the property.

The City and Lemoore Little League entered into a Facility Use Agreement on October 5, 2021 for the use of the City facility located at 250 W. Iona. The current duration of the facility use agreement is October 2021 to October 2024. The League has requested a 5- year extension to October 2029, with an additional automatic 5-year extension. This will allow sufficient time to complete rehabilitation and improvement projects.

Financial Consideration(s):

Not applicable.
17 Alternatives or Pros/Cons:

Pros:
• Property will continue to be rehabilitated and improved • Little League has a facility to use long term.

Cons:
• None.

Commission/Board Recommendation:

None.

Staff Recommendation:

Staff recommends the approval of the First Amendment to the Facility Use Agreement between the City of Lemoore and Lemoore Little League and authorize the City Manager or designee to execute.

Attachments: Review: Date:
☐ Resolution: ☒ Asst. City Manager 09/28/2022
☐ Ordinance: ☒ City Attorney 09/29/2022
☐ Maps ☒ City Clerk 09/29/2022
☒ Contract ☒ City Manager 09/29/2022
☐ Other: ☐ Finance
18 FIRST AMENDMENT TO

FACILITY USE AGREEMENT

BETWEEN THE CITY OF LEMOORE

AND LEMOORE LITTLE LEAGUE
The First Amendment to the Facility Use Agreement for Facility Use (Agreement) is made and entered into by and between the City of Lemoore and Lemoore Little League on this 4th day of October, 2022. The First Amendment amends the Agreement entered into on October 5, 2021, by the City and Lemoore Little League.

City and Lemoore Little League agree as follows:

1. Duration of Agreement
(a) The use of the PROPERTY is from October 5, 2021 to October 1, 2029, with an automatic five (5) year extension, if either party does not terminate the agreement as described under the “Termination of Agreement” section. The LLL understands that it is their responsibility to maintain the entire facility including, but not limited to, the Public Right of Way for weeds, hazards and public parking areas at all times and including during events and during the off season. The LLL understands and agrees that its duty to defend and indemnify the CITY is not limited by this section noting that “paragraph d INDEMNIFICATION” is in no way amended or altered by this First Amendment to the Facility Use Agreement and all obligations thereunder remain in full force and effect
Further, all other terms of the October 2021 Facility Use Agreement remain in full force and effect. _____________________________________
LLL Representative
_____________________________________
Date
_____________________________________
City of Lemoore
_____________________________________
Date
19 20
21 22
23 Exhibit A

INSURANCE REQUIREMENTS
Workers’ Compensation General Liability Auto Liability
Statutory
Employer’s Liability $1,000,000
$2,000,000 per occurrence
(may accept $1,000,000 per
occurrence for lower risks)
$4,000,000
general aggregate
$1,000,000
products/completed
operations aggregate
$2,000,000
Combined Single Limit
(may accept $1,000,000 for
lower risks)
Statutory
Employer’s Liability $1,000,000
$2,000,000+
per occurrence
$4,000,000+
general aggregate
$2,000,000+
products/completed
operations aggregate
$2,000,000+
Combined Single Limit
Statutory
Employer’s Liability $1,000,000
$5,000,000+
per occurrence
$10,000,000+
general aggregate
$5,000,000+
products/completed
operations aggregate
$5,000,000+
Combined Single Limit
24 City of

LEMOORE

CALIFORNIA
711 W. Cinnamon Drive  Lemoore, California 93245  (559) 924-6744 Staff Report
Item No: 3-5
To: Lemoore City Council
From: Steve Brandt, City Planner
Date: September 19, 2022 Meeting Date: October 4, 2022
Subject: Resolution 2022-38 – Accepting AMG & Associates Offer for the Sale and Development of Surplus Land Owned by the City of Lemoore and Authorize the City Manager to Enter into Escrow (APNs 023-020-065 and 023-020-064)
Strategic Initiative:
☐ Safe & Vibrant Community ☐ Growing & Dynamic Economy
☒ Fiscally Sound Government ☐ Operational Excellence
☒ Community & Neighborhood Livability ☐ Not Applicable
Proposed Motion:

Adopt Resolution No. 2022-38, accepting AMG & Associates offer for the sale and development of City-owned Surplus Land located on the south side of East D Street, between Oleander Avenue and Smith Avenue and authorize the City Manager to enter escrow.

Subject/Discussion:

This vacant, City-owned property was originally purchased with monies meant for the development of affordable housing. The City Council adopted Resolution No. 2021-31 on December 7, 2021, to declare two parcels owned by the City of Lemoore as Surplus Land and authorized the City Manager to send surplus land notices of availability to all appropriate public agencies. This was the first step in a process to sell the city-owned property located on the south side of East D Street between Oleander Avenue and Smith Avenue (APNs 023-020-065 and 023-020-064). This action was a required step for the disposition of surplus properties owned by public agencies to make them available for development under the Surplus Lands Act (SLA) in State law (Government Code section 54221).
25 On January 31, 2022, as part of the second step of the required process, the City provided notification to the CA Housing and Community Development Department (HCD) and local agencies of intent to sell the surplus property and in accordance with Government Code Section 54222, provided agencies 60 days from the date of the notification to submit letters of interest. Three letters were received during the 60-day period which ended March 31, 2022.

Per the SLA Guidelines, if a local agency disposing of the surplus land receives a timely notice of interest from a proper entity, then a 90-day good faith negotiation period begins.

There were three affordable housing developers that submitted proposals to purchase the site and develop it with affordable housing. As part of this negotiation process, the City created a list of areas that one or more of the proposals may have been lacking information and sent a request for information letter to the three entities to assist in making the review as fair as possible. The proposals were then reviewed by a panel made up of the City Manager, Management Analyst, City Planner, and another QK team member familiar with HCD requirements. The proposals were reviewed for completeness and evaluated to determine which agency met the greatest number of affordability requirements (number of units, type of units, target group). Information also considered during the overall scoring process were type of financing, past performance, type of property acquisition, and City concessions requested.

The reviewing panel unanimously determined that AMG & Associates (AMG) proposed the greatest number of affordable units where at least 25% of the units will be affordable to lower income households (Government Code Section 54227) and scored AMG highest overall due in part to type of property acquisition offered and City financial concessions requested. Staff contacted AMG and began conducting verbal negotiations within the parameters of the SLA Guidelines during the remainder of the 90-day period. The key proposal elements of each of the three submitters is shown below.

Proposer Number of Units Type of Units Target Group
AMG and Associates 100-110 2 & 3 Bd Units 30%-60% of AMI, All Ages Self Help Enterprises 70-100 1, 2 & 3 Bd Units 30-50% of AMI, Previously Homeless Caddis Properties 66 2 & 3 Bd Units 14/30%, 16/40%, 17/50%, 18/60% of AMI Note: Bd = bedroom, AMI = area median income
At the end of the 90-day negotiation period, AMG requested a good faith letter so that their team could continue to move forward with negotiations. On June 6, 2022, the City Manager provided a letter of intent to negotiate to sell surplus property for an affordable housing project and staff have been working with AMG to clarify details of the timeline, site plan, and development agreement required for the sale of the property.

The steps that will be required prior to close of escrow include Planning Commission’s approval of the site plan, which will be reviewed by them in November, City Council approval of the development agreement (scheduled for December), and submittal of proposed disposition summary to HCD (in December after Council approval). 26 Financial Consideration(s):

Financial concessions were not requested by the buyer. Sale of the surplus land to AMG will increase the Housing funds available for future projects.

Alternatives or Pros/Cons:

Pros:
• Development of vacant land that is not suitable for the City’s use. • Increase to Housing funds for future projects.
• Increase the number of affordable housing units as required by the State.

Cons:
• None.

Commission/Board Recommendation:

Not applicable.

Staff Recommendation:

Staff recommends the approval of Resolution 2022-38, accepting the AMG & Associates offer for sale of surplus land and authorize the City Manager to enter escrow.

Attachments: Review: Date:
☒ Resolution: 2022-38 ☒ Asst. City Manager 09/28/2022
☐ Ordinance: ☒ City Attorney 09/29/2022
☐ Map ☒ City Manager 09/29/2022
☐ Contract ☒ City Clerk 09/29/2022
☒ Other ☐ Finance
List: Resolution No. 2021-31
Notice of Availability/Offer to Sell Surplus Property (January 31, 2022) Request for more information letter (April 14, 2022)
AMG & Associates Development Proposal Information (April 25, 2022) 27 RESOLUTION NO. 2022-38

A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF LEMOORE

ACCEPTING AMG & ASSOCIATES OFFER FOR THE SALE AND DEVELOPMENT

OF SURPLUS LAND OWNED BY THE CITY OF LEMOORE AND AUTHORIZING THE CITY MANAGER TO ENTER ESCROW (APNS 023-020-065 AND 023-020-064) WHEREAS, the City of Lemoore (“City”) is the owner in fee simple of that certain real property located on the south side of East D Street, Oleander Avenue and Smith Avenue (APNs 023-020-065 and 023-020-064) totaling 4.92 acres and shown on the map in Exhibit “A,” attached hereto and made a part hereof (“Property”); and
WHEREAS, under the Surplus Property Land Act, Government Code Sections 54220- 54233 (“Act”), surplus land is land owned in fee simple by the City for which the City Council took formal action in a regular public meeting on December 7, 2021 declaring the land is surplus and not necessary for the City’s use.; and
WHEREAS, the City sent a written notice of availability of the Property to certain designated entities on January 31, 2022 and provided a 60-day response period, and WHEREAS, the City received three proposals from three affordable housing developers for acquisition and development of the surplus land, and WHEREAS, the City reviewed the proposals per Surplus Land Act Guidelines.

NOW, THEREFORE, BE IT RESOLVED, the City Council accepts the AMG & Associates offer for the sale and development of the City owned Surplus Land.

BE IT FURTHER RESOLVED, the City Council of the City of Lemoore hereby authorizes the City Manager to enter escrow with AMG & Associates for the purpose of constructing affordable housing on the Property.

PASSED AND ADOPTED by the Lemoore City Council on this 4th day of October 2022, by the following vote:

AYES:

NOES:

ABSENT:

ABSTAIN:

ATTEST: APPROVED:
_________________________ _________________________
Marisa Avalos Stuart Lyons
City Clerk Mayor
28 City of
Lemoore Exhibit “A”

29 30
31 32
“In God We Trust”
Sept
City of

LEMOORE

CALIFORNIA
711 W. Cinnamon Drive ● Lemoore, CA 93245 ● (559) 924-6744 January 31, 2022
To All Interested Parties:

RE: Notice of Availability/Offer to Sell Surplus Property As required by Government Code Section 54220 of the State of California, the City of Lemoore is providing notification that the City intends to sell the surplus property listed in the accompanying table.

In accordance with Government Code Section 54222, you have sixty (60) days from the date this offer was sent via certified mail or electronic mail to notify the City of your interest in acquiring the property.

However, this offer shall not obligate the City to sell the property to you. Instead, the City would enter into at least ninety (90) days of negotiations with you pursuant to Government Code Section 54223. If no agreement is reached on sales price and terms, or lease terms, the City may market the property to the general public.

As required by Government Code Section 54227, if the City receives more than one letter of interest during this 60-day period, it will give first priority to entities proposing to develop housing where at least 25 percent of the units will be affordable to lower income households. If more than one such proposal is received, priority will be given to the proposal with the greatest number of affordable units. If more than one proposal specifies the same number of affordable units, priority will be given to the proposal that has the lowest average affordability level.

In the event your agency or company is interested in purchasing the property, you must notify the City in writing within sixty (60) days of the date this notice was sent via certified mail or electronic mail. Notice of your interest in acquiring the property shall be delivered to the City of Lemoore, Attn: City Clerk, 711 W.

Cinnamon Drive, Lemoore CA 93245. You may also direct your questions to [email protected] or by calling (559) 924-6744, ext. 700
Entities proposing to submit a letter of interest are advised to review the requirements set forth in the Surplus Land Act (Government Code Section 54220-54234).

Thank you very much.

Nathan Olson
City Manager
33 Sept
City of

LEMOORE

CALIFORNIA
711 W. Cinnamon Drive ● Lemoore, CA 93245 ● (559) 924-6744 April 14, 2022
RE: Request for Information – 90-Day Negotiation Period for Offer to Sell Surplus Property To Whom It May Concern:

The City of Lemoore is in receipt of your interest letter, received XXXXX, requesting to negotiate the purchase and development of 4.92 acres of City owned surplus property located south of East D Street, between Oleander Avenue and Smith Street in the City of Lemoore (APNs 023-020-064 and 023-020- 065). The City received three interest letters between January 31, 2022 and March 31, 2022.

Per Government Code Section 54227, if the City received more than one letter of interest during this 60- day period, it will give first priority to entities proposing to develop housing where at least 25% of the units will be affordable to lower income households. If more than one such proposal is received, priority will be given to the proposal with the greatest number of affordable units. If more than one proposal specifies the same number of affordable units, priority will be given to the proposal that has the lowest average affordability level.

As part of the 90-Day negotiation process, the City is requesting that you provide more information to assist staff in making the review process as fair as possible. Please refer to the list below. Interested parties that do not provide satisfactory information may lose priority status. • Type of Project
• Type and Number of Units (mix of units, include type and how many of each) • Target Group (income level)
• Project Amenities (recreation and other services available) • Type of Financing for this project
• Finance Performance Resume
• Requested City Concessions (from purchase to occupancy) • Schedule (proposed timeline to achieve final occupancy) • Schedule Performance Resume
• Any other pertinent information is encouraged
The information requested should be emailed to [email protected]. Please contact the Community Development Department at (559) 924-6744 or [email protected] with any questions you may have.

Kind Regards,
Kristie Baley
Management Analyst
34 April 25, 2022
City of Lemoore
Attn: Kristi Baley
711 W. Cinnamon Drive
Lemoore, CA 93245
Ms. Baley,
Thank you for the opportunity to respond to the City’s inquiry regarding the potential development (the “Project”) on APN 023-020-064 and APN 023-020-065 (collectively, the “Parcels”), proposed by AMG & Associates, LLC (“AMG”). Please find a table of contents concerning important information contained herein.

Table of Contents
Introduction to Project and Project Financing…………………………………………………………………..2 Statement of Qualifications – AMG & Associates, LLC……………………………………………………….3 Statement of Qualifications - Pacific West Communities, Inc………………………………………………….4 AHSC Fact Sheet……………………………………………………………………………………………...5-6 Winning AHSC Projects and Disbursement of AHSC Funds……………………………………………….7-10 Description of Proposed Project……………………………………………………………………………….10 Renderings of Similar Projects……………………………………………………………………………..12-13 Timeline and Answers to Specific Questions Per RFP…………………………………………………….…14 35 Introduction to Project and Project Financing
AMG intends to construct between 98-110 units on the Parcels utilizing a combination of 9% low-income housing tax credits issued by the California Tax Credit Allocation Committee as well as grant funding from the Affordable Housing and Sustainable Communities Program (“AHSC”), administered by the California Department of Housing and Community Development (“HCD”).

AHSC is a funding program created in 2014 that subsidizes both infill, low carbon-emission affordable housing developments and local transportation infrastructure improvements near such development sites, servicing the ultimate objective of encouraging Californians to drive less and instead, utilize public transportation and non-carbon emission transportation methods, such as walking, biking, and ride-share vans.

AHSC, like many other public housing funding programs, is competitive. Applications are scored according to financial feasibility of the project and transportation improvements, local need for transportation infrastructure improvements, and location of the project to amenities and public resources, among other things.

In an AHSC application, AMG, our partner firm Pacific West Communities, Inc (“PWC”) and the City of Lemoore (the “City”) would participate as co-applicants. A portion of the total funding received (typically, roughly 60%) would be dedicated towards the Project itself while the remainder would be dedicated towards transportation improvements, such as new bike lanes, street lights, bus shelters, bus fleet, sidewalks, and van fleet (for CalVans). Transportation infrastructure improvements are typically applied in areas in close proximity to the Project, which would be identified in the application. 36 Statement of Qualifications (AMG)
AMG & Associates, LLC (“AMG”) is a mid-size land development company that specializes in the development of rental housing in California and other western states.

Our philosophy is to capitalize on the added value created through assembling the most qualified and trustworthy development and capital partners. We believe that the highest yields are achieved through land acquisitions that have been overlooked by developers and investors that do not have the risk appetite for complex land entitlements and financing. AMG principals are involved in all aspects of the development process in which all of its projects involve an institutional capital partner and an experienced development partner.

In every land development project that AMG develops, it takes the land acquisition entitlement risk, develops the financing plan, selects the most qualified development partner and capital partner, and then oversees the project until the final permanent loan conversion and/or sale. Other land development transactions involve joint ventures with land owners or ventures with municipal agencies. To date, AMG has developed over 3,600 units with a total project cost of over $450MM, partnering with its strategic development partners in 55 limited partnerships.

Through extensive due-diligence, experience and its own capital at risk, AMG minimizes its capital partners’ land development risks.
37 Statement of Qualifications (Pacific West Communities, Inc) Pacific West Communities, Inc. (PWC) is a real estate development and finance firm specializing in the construction and rehabilitation of affordable workforce and senior housing throughout the western United States. With a particular emphasis on the use of the affordable housing tax credit, PWC and its related companies develop multifamily and senior housing in the states of California, Arizona, New Mexico, Utah, Oregon, Montana, Idaho, Nevada, Colorado, Washington, and Wyoming.

The President and CEO of PWC, Caleb Roope has managed the development and construction of over 160 housing developments since 1998. With a history in the new construction of housing, as well as the rehabilitation of existing housing, PWC combines the federal affordable housing tax credit program with secondary financing including Home Investment Partnership Program (HOME) funds, Multifamily Housing Programs (MHP) funds, Infill Infrastructure Grant funds, Community Development Block Grants (CDBG), Affordable Housing Program (AHP) funds, and other local, state, and federal resources to creatively bring solutions to communities with affordable housing needs. PWC fills a much-needed housing niche in a variety of unique environments with a special focus on rural areas, resort communities, and high-cost communities such as Jackson Hole-WY, Truckee-CA, Bishop-CA, Mammoth Lakes-CA, and Eagle-CO.

Caleb Roope’s experiences include all facets of the real estate development and financing processes with special emphasis directed toward site acquisition and feasibility evaluations. His companies initiate roughly ten new developments per year resulting in approximately twenty-five active projects in various stages of development and construction.
38 AHSC Fact Sheet
39 AHSC Fact Sheet (Continued)
40 Winning AHSC Projects and Disbursement of AHSC Funds AMG, working in conjunction with PWC, has achieved an over 85% success rate in obtaining AHSC funding, Of the 7 AHSC applications submitted to AHSC, 6 were ultimately funded. On the following pages, I have attached examples of previous AMG/PWC projects that have obtained AHSC funding. Numbers in the column “transportation capital funding” indicate funding that was disbursed the cities in which the respective project is located. We obtained approximately $38,800,000 of funding in the 4th round, $35,000,000 of funding in the 5th round, and $40,550,000 in the 6th round.

Round 4 AHSC Awards: AMG/PWC were co-developers in the Amaya Village Apartments in Orange Cove, CA, the Madera Veterans Apartments in Madera, CA and the Ocotillo Springs Apartments in Brawley, CA. 41 Winning AHSC Projects and Disbursement of AHSC Funds (Continued) Round 5 AHSC Awards: AMG/PWC were co-developers in the Mojave View Apartments in Ridgecrest, CA the Coalinga Pacific Apartments in Coalinga, CA and the Riverbend Family Apartments in Oroville, CA. 42 Winning AHSC Projects and Disbursement of AHSC Funds (Continued) Continuation of Round 5 AHSC Awards Below:
43 Winning AHSC Projects and Disbursement of AHSC Funds (Continued) Round 6 AHSC Awards: AMG/PWC were co-developers in the Newmark Village Apartments in Sanger, CA. 44 Description of Proposed Project
The proposed project, the Lemoore Apartments, will be between a 100 to 110-unit family housing new construction project located on 4.92+/- acres of land identified as APNs 023-020-064 & 020-023-065. The project will be built in 1 phase and will include a mix of two and three-bedroom units. The proposed project will target households earning between 30-60% of the area median income for Kings County. There will also be ample bicycle parking and bicycle storage units. All units, less the manager’s unit, will be restricted to the aforementioned income levels. The Project will be developed in 1 phase.

The units will be newly constructed apartments in three-story garden style, residential buildings in addition to a single-story community building. The type of construction will be wood frame supported by perimeter foundations with concrete slab flooring. This type of construction will allow the building to conform to the natural terrain with only minor amounts of grading. The exterior will be a combination of vinyl lap and shake siding with Class A composite roof shingles and stone veneer accents. Architectural accents will be incorporated, providing an aesthetically appealing exterior that blends with the character of the surrounding neighborhood and the community of Lemoore. The development will meet Title 24 energy efficiency standards and will qualify as a ZNE (zero net energy) project. Minimum construction standards will be adhered to in order to assure that a quality family housing development is provided.

The buildings will be oriented appropriately throughout the site with the intent to create a community concept for families to enjoy while remaining social and active. The development will include a roughly 3,000 sq. ft. community building with a common kitchen, exercise room, laundry facility, and business center.

Additionally, the development will include covered picnic tables with BBQs and pergolas made from noncombustible material, a tot lot, a fenced dog park, a pool, pergola-covered seating areas, garden with raised planter beds, and a half basketball court. An on-site resident manager will provide assistance and management while residing in a two-bedroom manager’s unit.

Within the units, tenants will enjoy standard features such as refrigerators, exhaust fans, dishwashers, disposals and ranges with ovens. All units feature an outdoor patio or balcony and storage space. The design of these apartments will adhere to all necessary requirements to satisfy Section 504 as well as any additional mandates that the local jurisdiction deems appropriate. 45 Renderings of Similar Projects (Continued)
Deer Creek Apartments in Chico, CA shown below. 204 units in total, 156 units in phase 1 which is currently under construction.
46 Renderings of Similar Projects (Continued)
Woodmark Apartments in Sebastopol, CA.
47 Timeline and Answers to Specific Questions Per RFP
Timeline
Assuming AMG takes possession of the subject properties by July 2022, AMG will anticipate submitting for AHSC funds in February 2023, being awarded in July 2023, submitting for low income housing tax credits in September 2023 and obtaining tax credit funding in December 2023. AMG will anticipate commencing construction in in early 2024 and completing construction in early 2025 and commence lease out by spring 2025. This schedule is contingent upon successful funding of AHSC and 9% tax credits.

Answers to Specific Questions per RFP
Type of Project: Family housing (all ages)
Target Group (Income Level): Households earning between 30-60% of the AMI (area median income) for Kings County
Project Partners and Key Staff: AHSC applicants will be AMG & Associates, LLC, Pacific West Communities, Inc., and the City of Lemoore. The Project will be developed by AMG & PWC alone.

Number of Affordable Units per Acre: Between 20.12 and 22.15.

Type of Financing for this Project: Grant funding from the Affordable Housing and Sustainable Communities program, as well as low-income housing tax credits (LIHTC) issued by the California Tax Credit Allocation Committee.

Requested City Concessions: In order to increase the likelihood of securing of AHSC funding, we will require between a 19.5% and 31.5% density bonus to increase the Project density to accommodate 100-110 units. We will also likely require a slight parking reduction. 48 City of

LEMOORE

CALIFORNIA
711 West Cinnamon Drive  Lemoore, California 93245  (559) 924-6744  Fax (559) 924-9003 Staff Report
Item No: 3-6
To: Lemoore City Council
From: Randon Reeder, Management Analyst
Date: September 25, 2022 Meeting Date: October 4, 2022
Subject: Budget Amendment – CIP 5013 – Bush Street Overlay Strategic Initiative:
☐ Safe & Vibrant Community ☐ Growing & Dynamic Economy
☐ Fiscally Sound Government ☐ Operational Excellence
☒ Community & Neighborhood Livability ☐ Not Applicable
Proposed Motion:

Approve the budget amendment in the amount of $917,092 to CIP 5013 Bush Street Overlay and authorize the City Manager, or designee, to execute the budget amendment.

Subject/Discussion:

Bush Street Overlay is a current CIP that included an overlay on Bush Street from 19th Avenue to 19 ½ Avenue. The project was delayed in June when the road needed additional grinding. Due to this change, a majority of the CIP was pushed into FY 2023 and a budget amendment is needed to reflect the project in the FY 2023 budget instead of the original time frame which was expected to be 2022.

The project was previously approved by City Council on April 19, 2022.

Financial Consideration (s):

Funds for the project were approved on April 19, 2022, when the project was awarded to Terra West, utilizing grant funds (Fund 030) and gas tax funding sources (Fund 034). The budget amendment is required in order to place the expenditures in the FY 2023 budget.

The City received HIP (Highway Infrastructure Program) Funds for reimbursement of 44% of the total construction costs; $359,000. The remaining project costs were approved by City Council to be funded with gas tax funds, in the amount of $558,092 49 Alternatives or Pros/Cons:

N/A
Commission/Board Recommendation:

N/A
Staff Recommendation:

Approve the budget amendment in the amount of $917,092 to CIP 5013 Bush Street Overlay, and authorize the City Manager, or designee, to sign the budget amendment.

Requesting Department:

TYPE OF BUDGET AMENDMENT REQUEST:

Appropriation Transfer within Budget Unit
All other appropriations (Attach Council approved Staff Report) FROM:

Fund Budget Unit Account Current Budget Proposed
Increase/Decrease: Proposed New Budget
30 3710 $ 462,000.00 $ (359,000.00) $ 103,000.00
34 3745 $ 236,302.00 $ (229,046.00) $ 7,256.00
34 3774 $ 264,042.00 $ (229,046.00) $ 34,996.00
34 3590 $ 172,968.00 $ (100,000.00) $ 72,968.00
- - $ -
TO:

Fund Budget Unit Account Current Budget Proposed
Increase/Decrease: Proposed New Budget
403 5013 4317 $ - $ 917,092.00 $ 917,092.00
$ -
$ -
- - $ -
$ -
APPROVALS:
9/15/2022 Randon Reeder
Public Works

CITY OF LEMOORE

BUDGET AMENDMENT FORM
JUSTIFICATION FOR CHANGE/FUNDING SOURCE:

CIP project extended into FY 2023. Creating budget for project expenditures Completed By: Date:

Department Head: Date:

City Manager: Date:
51 City of

LEMOORE

CALIFORNIA
711 West Cinnamon Drive  Lemoore, California 93245  (559) 924-6744 Staff Report
To: Lemoore City Council
From: Marisa Avalos, City Clerk
Date: September 21, 2022 Meeting Date: October 4, 2022
Subject: Activity Update
Strategic
Initiative:
☐ Safe & Vibrant Community
☒ Fiscally Sound Government
☐ Community & Neighborhood
L Livability
☐ Growing & Dynamic Economy
☐ Operational Excellence
☐ Not Applicable
Reports
 Warrant Register – FY 22/23 September 16, 2022
 Warrant Register – FY 22/23 September 23, 2022
52 PEI PAGE NUMBER: 1
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4211 - CITY COUNCIL

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4980 LEGAL EXPENSE
3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 168.75 .00 PROFESSIONAL SERVICES 3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 712.50 .00 PROFESSIONAL SERVICES 3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 1,171.25 .00 PROFESSIONAL SERVICES TOTAL LEGAL EXPENSE .00 2,052.50 .00
TOTAL CITY COUNCIL .00 2,052.50 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING Warrant Register 09-16-2022
53 PEI PAGE NUMBER: 2
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4213 - CITY MANAGER

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 11639 -01 15234 2849 KINGS COUNTY ECO 1,666.67 -1,666.67 MONTHLY CONTRIBUTION (20, 3 /23 09/16/22 21 15222 7265 COMPUTER SYSTEMS 400.00 .00 SUBSCRIPTION 3 /23 09/16/22 21 15222 7265 COMPUTER SYSTEMS 400.00 .00 SUBSCRIPTION TOTAL PROFESSIONAL CONTRACT SVC .00 2,466.67 -1,666.67
4340 UTILITIES
3 /23 09/16/22 21 15261 6266 SPARKLETTS 22.70 .00 WATER SVC TOTAL UTILITIES .00 22.70 .00
4980 LEGAL EXPENSE
3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 131.25 .00 PROFESSIONAL SERVICES 3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 1,068.75 .00 PROFESSIONAL SERVICES 3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 1,087.50 .00 PROFESSIONAL SERVICES TOTAL LEGAL EXPENSE .00 2,287.50 .00
TOTAL CITY MANAGER .00 4,776.87 -1,666.67
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 54 PEI PAGE NUMBER: 3
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4214 - CITY CLERK'S OFFICE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 15233 4062 KINGS COUNTY 20.00 .00 RECORDING FEES TOTAL PROFESSIONAL CONTRACT SVC .00 20.00 .00
TOTAL CITY CLERK'S OFFICE .00 20.00 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 55 PEI PAGE NUMBER: 4
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4215 - FINANCE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 11629 -01 15265 7278 TYLER TECHNOLOGI 640.00 -640.00 APPLICATION SERVICES/ FEE 3 /23 09/16/22 21 11629 -01 15265 7278 TYLER TECHNOLOGI 2,560.00 -2,560.00 APPLICATION SERVICES/ FEE 3 /23 09/16/22 21 11629 -01 15265 7278 TYLER TECHNOLOGI 3,200.00 -3,200.00 APPLICATION SERVICES/ FEE 3 /23 09/16/22 21 11629 -01 15265 7278 TYLER TECHNOLOGI 4,480.00 -4,480.00 APPLICATION SERVICES/ FEE 3 /23 09/16/22 21 11629 -01 15265 7278 TYLER TECHNOLOGI 7,680.00 -7,680.00 APPLICATION SERVICES/ FEE 3 /23 09/16/22 21 11629 -01 15265 7278 TYLER TECHNOLOGI 8,789.17 -8,789.17 APPLICATION SERVICES/ FEE TOTAL PROFESSIONAL CONTRACT SVC .00 27,349.17 -27,349.17 4340 UTILITIES
3 /23 09/16/22 21 15261 6266 SPARKLETTS 29.93 .00 WATER SVC TOTAL UTILITIES .00 29.93 .00
4980 LEGAL EXPENSE
3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 581.25 .00 PROFESSIONAL SERVICES TOTAL LEGAL EXPENSE .00 581.25 .00
TOTAL FINANCE .00 27,960.35 -27,349.17
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 56 PEI PAGE NUMBER: 5
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4216 - PLANNING

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15261 6266 SPARKLETTS 22.70 .00 WATER SVC TOTAL UTILITIES .00 22.70 .00
4980 LEGAL EXPENSE
3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 856.37 .00 PROFESSIONAL SERVICES TOTAL LEGAL EXPENSE .00 856.37 .00
TOTAL PLANNING .00 879.07 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 57 PEI PAGE NUMBER: 6
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4220 - MAINTENANCE DIVISION

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 20.55 .00 SPRAY PAINT 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 19.82 .00 NUTS& BOLTS 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 7.50 .00 GRINDER 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE -5.14 .00 APPLE SAT ENAMEL 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 5.98 .00 EMT STRAP 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 6.42 .00 MAS BIT 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 29.41 .00 MALE CONNECTOR 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 24.81 .00 UREA PLATE 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 27.92 .00 NUTS &BOLTS 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 28.47 .00 CLOSE BLK NIPPLE 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 31.20 .00 DPLX OUTLET 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 35.37 .00 SDS HAMM BIT 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 37.70 .00 FULLPAT HEAD/12" 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 39.83 .00 FILTER 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 43.24 .00 COIL KEY RING 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 144.67 .00 DPLX OUTLET 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 321.01 .00 MISC. MDSE 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 56.04 .00 RETRAC KNIFE/BLADE 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 57.66 .00 LOCK KEY BLANK 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 75.05 .00 GAL PRO DRAIN OPENER 3 /23 09/16/22 21 15209 6081 ALL AMERICAN POO 110.79 .00 RETURNABLE CHLORINE C TOTAL OPERATING SUPPLIES .00 1,118.30 .00
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 79.50 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 178.30 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 43.52 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 43.52 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 43.52 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 43.52 .00 UNIFORM SERVICES TOTAL PROFESSIONAL CONTRACT SVC .00 431.88 .00
4340 UTILITIES
3 /23 09/16/22 21 15256 0363 PG&E 2,311.91 .00 07/29/22-08/29/22 TOTAL UTILITIES .00 2,311.91 .00
TOTAL MAINTENANCE DIVISION .00 3,862.09 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 58 PEI PAGE NUMBER: 7
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4221 - POLICE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 15219 5725 CENTRAL VALLEY R 484.81 .00 FREEZER LEAKING WATER 3 /23 09/16/22 21 11698 -01 15223 2399 DEPARTMENT OF JU 735.00 -735.00 DOJ LIVE SCANS FY 2022-20 3 /23 09/16/22 21 11698 -01 15223 2399 DEPARTMENT OF JU 1,112.00 -1,112.00 DOJ LIVE SCANS FY 2022-20 3 /23 09/16/22 21 11710 -01 15235 0772 COUNTY OF KINGS 5,081.04 -5,081.04 INFORMATION TECHNOLOGY SE 3 /23 09/16/22 21 15237 5035 LEMOORE ANIMAL C 40.00 .00 OFFICE VISIT 3 /23 09/16/22 21 15220 7346 CHARTER COMMUNIC 100.00 .00 TARGETS TOTAL PROFESSIONAL CONTRACT SVC .00 7,552.85 -6,928.04
4340 UTILITIES
3 /23 09/16/22 21 15224 6685 DIRECTV 107.24 .00 09/04/22-10/03/22 3 /23 09/16/22 21 15212 5048 AT&T MOBILITY 1,150.77 .00 08/3/22-9/2/22 TOTAL UTILITIES .00 1,258.01 .00
4360 TRAINING
3 /23 09/16/22 21 11704 -01 15228 6529 GENERAL DYNAMICS 1,240.00 -1,240.00 SIMUNITION INSTRUCTOR COU 3 /23 09/16/22 21 15253 T385 MARK PESCATORE 247.00 .00 CAHN 2022 ANNUAL CONF 3 /23 09/16/22 21 15231 7092 KATARINA ESCOBAR 247.00 .00 ICI CHILD ABUSE TOTAL TRAINING .00 1,734.00 -1,240.00
4380 RENTALS & LEASES
3 /23 09/16/22 21 11616 -01 15226 7311 ENTERPRISE FM TR 1,823.40 -1,823.40 FLEET - 2ND YEAR RENTAL T TOTAL RENTALS & LEASES .00 1,823.40 -1,823.40
TOTAL POLICE .00 12,368.26 -9,991.44
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 59 PEI PAGE NUMBER: 8
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4222 - FIRE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 205.88 .00 BATTERY 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 32.15 .00 DETERGENT TOTAL OPERATING SUPPLIES .00 238.03 .00
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 43.72 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 43.72 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 109.83 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 109.83 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 109.83 .00 UNIFORM SERVICES TOTAL PROFESSIONAL CONTRACT SVC .00 416.93 .00
4980 LEGAL EXPENSE
3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 168.75 .00 PROFESSIONAL SERVICES TOTAL LEGAL EXPENSE .00 168.75 .00
TOTAL FIRE .00 823.71 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 60 PEI PAGE NUMBER: 9
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4224 - BUILDING INSPECTION

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15261 6266 SPARKLETTS 22.70 .00 WATER SVC TOTAL UTILITIES .00 22.70 .00
4380 RENTALS & LEASES
3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 37.50 .00 PROFESSIONAL SERVICES TOTAL RENTALS & LEASES .00 37.50 .00
TOTAL BUILDING INSPECTION .00 60.20 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 61 PEI PAGE NUMBER: 10
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4230 - PUBLIC WORKS

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15261 6266 SPARKLETTS 22.70 .00 WATER SVC TOTAL UTILITIES .00 22.70 .00
TOTAL PUBLIC WORKS .00 22.70 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 62 PEI PAGE NUMBER: 11
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4231 - STREETS

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15254 0363 PG&E 71.53 .00 07/29/22-08/29/22 3 /23 09/16/22 21 15257 0363 PG&E 44.05 .00 07/29/22-08/29/22 TOTAL UTILITIES .00 115.58 .00
4350 REPAIR/MAINT SERVICES
3 /23 09/16/22 21 15260 0388 REED ELECTRIC, L 325.00 .00 DISPATCH CENTER STREE TOTAL REPAIR/MAINT SERVICES .00 325.00 .00
TOTAL STREETS .00 440.58 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 63 PEI PAGE NUMBER: 12
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4242 - RECREATION

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/16/22 21 15250 7317 ODP BUSINESS SOL 15.49 .00 OFFICE SUPPLIES 3 /23 09/16/22 21 15250 7317 ODP BUSINESS SOL 7.44 .00 MOUSEPAD TOTAL OPERATING SUPPLIES .00 22.93 .00
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 15270 6371 MANUEL VELARDE 352.33 .00 KARATE-AUGUST 2022 3 /23 09/16/22 21 15264 6885 TRENTON WILLIAMS 450.00 .00 CONTRACT SERVICES 3 /23 09/16/22 21 11695 -01 15241 6696 LIVE SCAN FRESNO 580.00 -580.00 LIVE SCANS FINGER PRINTIN TOTAL PROFESSIONAL CONTRACT SVC .00 1,382.33 -580.00
4980 LEGAL EXPENSE
3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 1,556.25 .00 PROFESSIONAL SERVICES TOTAL LEGAL EXPENSE .00 1,556.25 .00
TOTAL RECREATION .00 2,961.51 -580.00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 64 PEI PAGE NUMBER: 13
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4296 - INFORMATION TECHNOLOGY

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15221 4056 COMCAST 4,213.79 .00 06/01/22-06/30/22 3 /23 09/16/22 21 15221 4056 COMCAST 4,223.03 .00 07/01/22-07/31/22 3 /23 09/16/22 21 15221 4056 COMCAST 4,223.03 .00 08/1/22-08/31/22 3 /23 09/16/22 21 15267 5818 UNWIRED BROADBAN 210.00 .00 09/01/22-09/30/22 TOTAL UTILITIES .00 12,869.85 .00
TOTAL INFORMATION TECHNOLOGY .00 12,869.85 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 65 PEI PAGE NUMBER: 14
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4297 - HUMAN RESOURCES

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 15215 0057 RICHARD A. BLAK, 450.00 .00 PRE-EMPLOYMENT TOTAL PROFESSIONAL CONTRACT SVC .00 450.00 .00
4980 LEGAL EXPENSE
3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 56.25 .00 PROFESSIONAL SERVICES 3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 1,181.25 .00 PROFESSIONAL SERVICES TOTAL LEGAL EXPENSE .00 1,237.50 .00
TOTAL HUMAN RESOURCES .00 1,687.50 .00
TOTAL GENERAL FUND .00 70,785.19 -39,587.28
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 66 PEI PAGE NUMBER: 15
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 040 - FLEET MAINTENANCE
BUDGET UNIT - 4265 - FLEET MAINTENANCE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/16/22 21 11554 -01 15227 0068 GARY V. BURROWS, 17,176.05 -17,176.05 FUEL 3 /23 09/16/22 21 11555 -01 15240 0304 LEMOORE HARDWARE 13.93 -13.93 OPERATING SUPPLIES 3 /23 09/16/22 21 11702 -01 15232 2990 KIMBALL-MIDWEST 1,645.99 -1,645.99 SHOP SUPPLIES INCLUDING T 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 196.11 .00 FILTERS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 16.29 .00 BAT CABL 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 12.45 .00 FITTINGS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 32.05 .00 GLASS CLEANER 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 30.01 .00 HIGH TEMPERATURE- 56 TOTAL OPERATING SUPPLIES .00 19,122.88 -18,835.97
4230 REPAIR/MAINT SUPPLIES
3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 30.19 .00 FUEL FILTER 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 29.84 .00 FILTERS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 33.61 .00 85 MIRROR HEAD 3 /23 09/16/22 21 15246 0345 MORGAN & SLATES, 21.84 .00 RD DOM TUBE 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 37.28 .00 NAPA LIGHTING BY TRUC 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 43.88 .00 FILTERS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 37.90 .00 FUEL FILTER 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 13.23 .00 PLUG 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 14.56 .00 LAMP 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 14.84 .00 BOXED MINIATURES 3 /23 09/16/22 21 15246 0345 MORGAN & SLATES, 15.99 .00 TEEJET CP15941-3-SSPP 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 6.75 .00 HOS CLMP 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 3.45 .00 REPLACEMENT LENS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 4.98 .00 HEAT HOS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 7.61 .00 FILTER 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 7.61 .00 FILTERS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 249.05 .00 FILTERS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 173.35 .00 PICKUP 4.8 L 294 CID 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 304.50 .00 FILTERS 3 /23 09/16/22 21 15269 0458 KELLER FORD LINC 445.51 .00 INSTALL TRAILER BRAKE 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 45.01 .00 FILTERS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 39.79 .00 4 OBLONG LENS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 41.74 .00 SWITCH-TOGGLE 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 67.45 .00 BELT -AIR CONDITIONIN 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 70.12 .00 FILTERS 3 /23 09/16/22 21 15246 0345 MORGAN & SLATES, 76.05 .00 GLOVE LARGE 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 84.97 .00 FILTERS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 123.39 .00 FITLERS 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 128.69 .00 MOUNT 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 128.69 .00 MOUNT 3 /23 09/16/22 21 11697 -01 15230 5181 HAAKER EQUIPMENT 1,849.22 -1,849.22 AUXILARY HYD PUMP FOR SWE 3 /23 09/16/22 21 11705 -01 15249 6120 O'REILLY AUTO PA 572.45 -572.45 DEEP CYLCE BATTERIES FOR 3 /23 09/16/22 21 11558 -02 15214 0056 BILLINGSLEY TIRE 518.00 -518.00 CHANGE ORDER 1 - ADD NEW TOTAL REPAIR/MAINT SUPPLIES .00 5,241.54 -2,939.67
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 67 PEI PAGE NUMBER: 16
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 040 - FLEET MAINTENANCE
BUDGET UNIT - 4265 - FLEET MAINTENANCE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 59.52 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 59.52 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 64.02 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 56.83 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 56.83 .00 UNIFORM SERVICES TOTAL PROFESSIONAL CONTRACT SVC .00 296.72 .00
4350 REPAIR/MAINT SERVICES
3 /23 09/16/22 21 11558 -01 15214 0056 BILLINGSLEY TIRE 48.57 -48.57 TIRE REPAIR 3 /23 09/16/22 21 11558 -01 15214 0056 BILLINGSLEY TIRE 57.05 -57.05 TIRE REPAIR 3 /23 09/16/22 21 11558 -01 15214 0056 BILLINGSLEY TIRE 130.00 -130.00 TIRE REPAIR 3 /23 09/16/22 21 11558 -01 15214 0056 BILLINGSLEY TIRE 205.60 -205.60 TIRE REPAIR 3 /23 09/16/22 21 11558 -01 15214 0056 BILLINGSLEY TIRE 1,676.01 -1,676.01 TIRE REPAIR 3 /23 09/16/22 21 11558 -01 15214 0056 BILLINGSLEY TIRE 1,968.15 -1,968.15 TIRE REPAIR 3 /23 09/16/22 21 11558 -01 15214 0056 BILLINGSLEY TIRE 1,968.15 -1,968.15 TIRE REPAIR TOTAL REPAIR/MAINT SERVICES .00 6,053.53 -6,053.53
TOTAL FLEET MAINTENANCE .00 30,714.67 -27,829.17
TOTAL FLEET MAINTENANCE .00 30,714.67 -27,829.17
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 68 PEI PAGE NUMBER: 17
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 050 - WATER
BUDGET UNIT - 4250 - WATER

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/16/22 21 15268 2038 USA BLUEBOOK 428.96 .00 ARSENIC LOW TOTAL OPERATING SUPPLIES .00 428.96 .00
4220CH CHLORINE OPERATING SUPPLY
3 /23 09/16/22 21 11591 -01 15266 6058 UNIVAR 880.22 -880.22 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/16/22 21 11591 -01 15266 6058 UNIVAR 884.66 -884.66 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/16/22 21 11591 -01 15266 6058 UNIVAR 1,537.54 -1,537.54 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/16/22 21 11591 -01 15266 6058 UNIVAR 2,745.60 -2,745.60 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/16/22 21 11591 -01 15266 6058 UNIVAR 2,766.42 -2,766.42 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/16/22 21 11612 -01 15243 7175 MATHESON TRI-GAS 1,504.80 -1,504.80 LIQUID OXYGEN 7 3 /23 09/16/22 21 11612 -02 15243 7175 MATHESON TRI-GAS 1,254.00 -1,254.00 LIQUID OXYGEN STATION 11 TOTAL CHLORINE OPERATING SUPPLY .00 11,573.24 -11,573.24 4230 REPAIR/MAINT SUPPLIES
3 /23 09/16/22 21 11694 -01 15252 7301 PACE SUPPLY CORP 8.36 -8.36 CTS PE INSERT 3 /23 09/16/22 21 11694 -02 15252 7301 PACE SUPPLY CORP 136.98 -136.98 BRASS CORP. STOP 3 /23 09/16/22 21 11694 -03 15252 7301 PACE SUPPLY CORP 469.42 -469.42 STAINLESS STTEEL SADDLE 3 /23 09/16/22 21 11694 -04 15252 7301 PACE SUPPLY CORP 49.03 -49.03 SALES TAX 3 /23 09/16/22 21 11699 -01 197969665-1 7301 PACE SUPPLY CORP .00 .00 6" HYDRANT GASKET 3 /23 09/16/22 21 11699 -01 15252 7301 PACE SUPPLY CORP 12.88 -12.88 6" HYDRANT GASKET 3 /23 09/16/22 21 11699 -02 197969665-1 7301 PACE SUPPLY CORP .00 .00 BOLT SET 3 /23 09/16/22 21 11699 -02 15252 7301 PACE SUPPLY CORP 18.74 -18.74 BOLT SET 3 /23 09/16/22 21 11699 -03 15252 7301 PACE SUPPLY CORP 728.30 -728.30 HYDRANT BURY 3 /23 09/16/22 21 11699 -03 197969665 7301 PACE SUPPLY CORP .00 .00 HYDRANT BURY 3 /23 09/16/22 21 11699 -04 197969665-1 7301 PACE SUPPLY CORP .00 .00 HYDRANT EXTENTION 3 /23 09/16/22 21 11699 -04 15252 7301 PACE SUPPLY CORP 140.45 -140.45 HYDRANT EXTENTION 3 /23 09/16/22 21 11699 -05 15252 7301 PACE SUPPLY CORP 52.80 -52.80 SALES TAX 3 /23 09/16/22 21 11699 -05 15252 7301 PACE SUPPLY CORP 13.72 -13.72 SALES TAX TOTAL REPAIR/MAINT SUPPLIES .00 1,630.68 -1,630.68
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 11708 -01 15262 2799 TELSTAR INSTRUME 846.00 -846.00 TROUBLESHOOT WELL 7 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 450.88 .00 UNIFORM SERVICES 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 39.00 -39.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 39.00 -39.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 84.00 -84.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 130.00 -130.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 130.00 -130.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 130.00 -130.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 130.00 -130.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 130.00 -130.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 152.00 -152.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 152.00 -152.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 152.00 -152.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 152.00 -152.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 152.00 -152.00 WATER TREATMENT LABS AND RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 69 PEI PAGE NUMBER: 18
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 050 - WATER
BUDGET UNIT - 4250 - WATER

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC (cont'd)
3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 171.50 -171.50 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 523.00 -523.00 WATER TREATMENT LABS AND 3 /23 09/16/22 21 11588 -01 15216 1397 BSK ANALYTICAL L 851.50 -851.50 WATER TREATMENT LABS AND 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 38.70 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 38.70 .00 UNIFORM SERVICES TOTAL PROFESSIONAL CONTRACT SVC .00 4,492.28 -3,964.00
4320 MEETINGS & DUES
3 /23 09/16/22 21 15238 0297 LEMOORE CANAL & 322.00 .00 952/953 CITY/LAGUNA TOTAL MEETINGS & DUES .00 322.00 .00
4340 UTILITIES
3 /23 09/16/22 21 15261 6266 SPARKLETTS 193.57 .00 WATER SVC TOTAL UTILITIES .00 193.57 .00
TOTAL WATER .00 18,640.73 -17,167.92
TOTAL WATER .00 18,640.73 -17,167.92
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 70 PEI PAGE NUMBER: 19
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 052 - WATER INCIDENT FUND
BUDGET UNIT - 4752 - WATER INCIDENT

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4380 RENTALS & LEASES
3 /23 09/16/22 21 15248 2138 NICK CHAMPI ENTE 199.50 .00 MONTHLY TEMP FENCE TOTAL RENTALS & LEASES .00 199.50 .00
4980 LEGAL EXPENSE
3 /23 09/16/22 21 15247 7298 MOTSCHIEDLER, MI 400.00 .00 PROFESSIONAL SERVICES 3 /23 09/16/22 21 15242 5609 LOZANO SMITH, LL 450.00 .00 PROFESSIONAL SERVICES TOTAL LEGAL EXPENSE .00 850.00 .00
TOTAL WATER INCIDENT .00 1,049.50 .00
TOTAL WATER INCIDENT FUND .00 1,049.50 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 71 PEI PAGE NUMBER: 20
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 056 - REFUSE
BUDGET UNIT - 4256 - REFUSE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/16/22 21 11565 -01 15240 0304 LEMOORE HARDWARE 22.51 -22.51 OPERATING SUPPLIES 3 /23 09/16/22 21 11565 -01 15240 0304 LEMOORE HARDWARE 23.02 -23.02 OPERATING SUPPLIES 3 /23 09/16/22 21 11565 -01 15240 0304 LEMOORE HARDWARE 102.94 -102.94 OPERATING SUPPLIES TOTAL OPERATING SUPPLIES .00 148.47 -148.47
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 11552 -01 15225 6869 WELLS FARGO BANK 810.30 -810.30 TEMP POSITION 3 /23 09/16/22 21 11553 -01 15236 0234 KINGS WASTE AND 81,997.20 -81,997.20 TIPPING FEE'S 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 71.25 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 71.25 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 69.75 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 69.75 .00 UNIFORM SERVICES 3 /23 09/16/22 21 15211 2653 ARAMARK UNIFORM 76.25 .00 UNIFORM SERVICES TOTAL PROFESSIONAL CONTRACT SVC .00 83,165.75 -82,807.50 TOTAL REFUSE .00 83,314.22 -82,955.97
TOTAL REFUSE .00 83,314.22 -82,955.97
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 72 PEI PAGE NUMBER: 21
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 060 - SEWER& STORM WTR DRAINAGE
BUDGET UNIT - 4260 - SEWER

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 55.75 .00 SUPPORT 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 95.43 .00 WRENCH HOLDER 3 /23 09/16/22 21 15244 5333 MEDALLION SUPPLY 114.26 .00 CABLE TIES BLACK 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 56.35 .00 WOOL SOAP PAD 3 /23 09/16/22 21 15229 0521 GRAINGER 146.95 .00 STD LIFE JACKET 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 28.50 .00 BIKE HOOK 3 /23 09/16/22 21 15218 7205 CENCAL AUTO & TR 8.25 .00 JB WELD -JB STIK 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 8.57 .00 SQUEEZE UTILIT LIGHTE 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 21.43 .00 PRO ELEC TAPE 3 /23 09/16/22 21 11572 -01 15263 2072 THATCHER COMPANY -2,000.00 2,000.00 WWTP GAS CHLORINE 3 /23 09/16/22 21 11572 -01 15263 2072 THATCHER COMPANY -2,000.00 2,000.00 WWTP GAS CHLORINE 3 /23 09/16/22 21 11572 -01 15263 2072 THATCHER COMPANY 6,527.50 -6,527.50 WWTP GAS CHLORINE 3 /23 09/16/22 21 11572 -01 15263 2072 THATCHER COMPANY 6,562.46 -6,562.46 WWTP GAS CHLORINE TOTAL OPERATING SUPPLIES .00 9,625.45 -9,089.96
4230 REPAIR/MAINT SUPPLIES
3 /23 09/16/22 21 15244 5333 MEDALLION SUPPLY 8.79 .00 THRD REDUCER 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 5.15 .00 NUTS & BOLTS 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 5.62 .00 MISC. MDSE 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 5.98 .00 BX COVER 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 11.78 .00 GALV STREET ELBOW 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 34.49 .00 ELEC TAPE 3 /23 09/16/22 21 15246 0345 MORGAN & SLATES, 262.64 .00 STRAW HAT LARGE 3 /23 09/16/22 21 15240 0304 LEMOORE HARDWARE 96.05 .00 GALV NIPPLE TOTAL REPAIR/MAINT SUPPLIES .00 430.50 .00
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 11584 -01 15211 2653 ARAMARK UNIFORM 40.41 -40.41 UNIFORM SERVICES 3 /23 09/16/22 21 11584 -01 15211 2653 ARAMARK UNIFORM 44.94 -44.94 UNIFORM SERVICES 3 /23 09/16/22 21 11584 -01 15211 2653 ARAMARK UNIFORM 45.34 -45.34 UNIFORM SERVICES 3 /23 09/16/22 21 11584 -01 15211 2653 ARAMARK UNIFORM 109.94 -109.94 UNIFORM SERVICES 3 /23 09/16/22 21 11584 -01 15211 2653 ARAMARK UNIFORM 469.99 -469.99 UNIFORM SERVICES 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 45.00 -45.00 LAB ANALYSIS 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 45.00 -45.00 LAB ANALYSIS 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 45.00 -45.00 LAB ANALYSIS 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 45.00 -45.00 LAB ANALYSIS 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 70.00 -70.00 LAB ANALYSIS 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 70.00 -70.00 LAB ANALYSIS 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 70.00 -70.00 LAB ANALYSIS 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 70.00 -70.00 LAB ANALYSIS 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 90.00 -90.00 LAB ANALYSIS 3 /23 09/16/22 21 11593 -01 15245 6245 MOORE TWINING AS 230.00 -230.00 LAB ANALYSIS TOTAL PROFESSIONAL CONTRACT SVC .00 1,490.62 -1,490.62
4340 UTILITIES
3 /23 09/16/22 21 15261 6266 SPARKLETTS 37.43 .00 WATER SVC RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 73 PEI PAGE NUMBER: 22
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 060 - SEWER& STORM WTR DRAINAGE
BUDGET UNIT - 4260 - SEWER

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES (cont'd)
TOTAL UTILITIES .00 37.43 .00
TOTAL SEWER .00 11,584.00 -10,580.58
TOTAL SEWER& STORM WTR DRAINAGE .00 11,584.00 -10,580.58 RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 74 PEI PAGE NUMBER: 23
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 085 - PBIA
BUDGET UNIT - 4270 - PBIA

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/16/22 21 15251 5563 RUSTY DEROUIN 300.00 .00 AUGUST SERVICES TOTAL OPERATING SUPPLIES .00 300.00 .00
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 15251 5563 RUSTY DEROUIN 300.00 .00 JULY SERVICES TOTAL PROFESSIONAL CONTRACT SVC .00 300.00 .00
TOTAL PBIA .00 600.00 .00
TOTAL PBIA .00 600.00 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 75 PEI PAGE NUMBER: 24
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 201 - LLMD ZONE 1
BUDGET UNIT - 4851 - LLMD ZONE 1 WESTFIELD

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 84.76 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 84.76 .00
TOTAL LLMD ZONE 1 WESTFIELD .00 84.76 .00
TOTAL LLMD ZONE 1 .00 84.76 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 76 PEI PAGE NUMBER: 25
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 203 - LLMD ZONE 3 SILVA ESTATES
BUDGET UNIT - 4853 - LLMD ZONE 3 SILVA ESTATES

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 52.58 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 52.58 .00
TOTAL LLMD ZONE 3 SILVA ESTATES .00 52.58 .00
TOTAL LLMD ZONE 3 SILVA ESTATES .00 52.58 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 77 PEI PAGE NUMBER: 26
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 206 - LLMD ZONE 6 CAPISTRANO
BUDGET UNIT - 4856 - LLMD ZONE 6 CAPISTRANO

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 10.51 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 10.51 .00
TOTAL LLMD ZONE 6 CAPISTRANO .00 10.51 .00
TOTAL LLMD ZONE 6 CAPISTRANO .00 10.51 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 78 PEI PAGE NUMBER: 27
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 208B - LLMD ZONE 8B GREENS
BUDGET UNIT - 4858B - LLMD ZONE 8B GREENS

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 10.51 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 10.51 .00
TOTAL LLMD ZONE 8B GREENS .00 10.51 .00
TOTAL LLMD ZONE 8B GREENS .00 10.51 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 79 PEI PAGE NUMBER: 28
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 210 - LLMD ZONE 10 AVALON
BUDGET UNIT - 4860 - LLMD ZONE 10 AVALON

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 21.05 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 21.05 .00
TOTAL LLMD ZONE 10 AVALON .00 21.05 .00
TOTAL LLMD ZONE 10 AVALON .00 21.05 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 80 PEI PAGE NUMBER: 29
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 212 - LLMD ZONE 12 SUMMERWIND
BUDGET UNIT - 4862 - LLMD ZONE 12 SUMMERWIND

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/16/22 21 11709 -01 15271 7238 WESTSCAPES 16,156.00 -16,156.00 REPLANTING, TREE REMOVALS TOTAL PROFESSIONAL CONTRACT SVC .00 16,156.00 -16,156.00 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 21.51 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 21.51 .00
TOTAL LLMD ZONE 12 SUMMERWIND .00 16,177.51 -16,156.00
TOTAL LLMD ZONE 12 SUMMERWIND .00 16,177.51 -16,156.00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 81 PEI PAGE NUMBER: 30
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 251 - PFMD ZONE 1
BUDGET UNIT - 4871 - PFMD ZONE 1

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 40.77 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 40.77 .00
TOTAL PFMD ZONE 1 .00 40.77 .00
TOTAL PFMD ZONE 1 .00 40.77 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 82 PEI PAGE NUMBER: 31
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 252 - PFMD ZONE 2
BUDGET UNIT - 4872 - PFMD ZONE 2

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 189.47 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 189.47 .00
TOTAL PFMD ZONE 2 .00 189.47 .00
TOTAL PFMD ZONE 2 .00 189.47 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 83 PEI PAGE NUMBER: 32
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 253 - PFMD ZONE 3
BUDGET UNIT - 4873 - PFMD ZONE 3

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 13.22 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 13.22 .00
TOTAL PFMD ZONE 3 .00 13.22 .00
TOTAL PFMD ZONE 3 .00 13.22 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 84 PEI PAGE NUMBER: 33
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 254 - PFMD ZONE 4
BUDGET UNIT - 4874 - PFMD ZONE 4

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 41.39 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 41.39 .00
TOTAL PFMD ZONE 4 .00 41.39 .00
TOTAL PFMD ZONE 4 .00 41.39 .00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 85 PEI PAGE NUMBER: 34
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 255 - PFMD ZONE 5
BUDGET UNIT - 4875 - PFMD ZONE 5

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 163.47 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 163.47 .00
4350 REPAIR/MAINT SERVICES
3 /23 09/16/22 21 11701 -01 15208 6651 A-1 ALLSTAR PLUM 1,950.00 -1,950.00 REPAIRED BACK FLOW WHICH TOTAL REPAIR/MAINT SERVICES .00 1,950.00 -1,950.00
TOTAL PFMD ZONE 5 .00 2,113.47 -1,950.00
TOTAL PFMD ZONE 5 .00 2,113.47 -1,950.00
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 86 PEI PAGE NUMBER: 35
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:23:24 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 259 - PFMD ZONE 9
BUDGET UNIT - 4879 - PFMD ZONE 9

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/16/22 21 15255 0363 PG&E 10.96 .00 07/22/22-08/22/22 TOTAL UTILITIES .00 10.96 .00
TOTAL PFMD ZONE 9 .00 10.96 .00
TOTAL PFMD ZONE 9 .00 10.96 .00
TOTAL REPORT .00 235,454.51 -196,226.92
RUN DATE 09/30/2022 TIME 08:23:25 PEI - FUND ACCOUNTING 87 PEI PAGE NUMBER: 1
DATE: 09/30/2022 CITY OF LEMOORE AUDIT311
TIME: 08:25:55 GENERAL LEDGER TRANSACTION ANALYSIS
SELECTION CRITERIA: account.acct between '2000' and '2999'AND transact.yr='23' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 120 - FACILITIES RENTAL FUND

ACCOUNT DATE T/C REFERENCE VENDOR/PAYER DEBIT CREDIT DESCRIPTION 2020 ACCOUNTS PAYABLE
3 /23 09/16/22 21 15213 T3249 ESTER AVINA 250.00 REFUND CIVIC AUDITORI TOTAL ACCOUNTS PAYABLE .00 250.00
2300 CUSTOMER DEPOSITS
3 /23 09/16/22 21 15213 T3249 ESTER AVINA 250.00 REFUND CIVIC AUDITORI TOTAL CUSTOMER DEPOSITS 250.00 .00
TOTAL FACILITIES RENTAL FUND 250.00 250.00
TOTAL REPORT 250.00 250.00
88 PEI PAGE NUMBER: 1
DATE: 09/30/2022 CITY OF LEMOORE AUDIT311
TIME: 08:25:14 GENERAL LEDGER TRANSACTION ANALYSIS
SELECTION CRITERIA: account.acct between '1011' and '2021'AND transact.yr='23' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND

ACCOUNT DATE T/C REFERENCE VENDOR/PAYER DEBIT CREDIT DESCRIPTION 1550 PREPAID EXPENSE
3 /23 09/16/22 21 15259 7165 QUADIENT FINANCE USA 1,999.32 POSTAGE TOTAL PREPAID EXPENSE 1,999.32 .00
2020 ACCOUNTS PAYABLE
3 /23 09/16/22 21 15259 7165 QUADIENT FINANCE USA 1,999.32 POSTAGE TOTAL ACCOUNTS PAYABLE .00 1,999.32
TOTAL GENERAL FUND 1,999.32 1,999.32
TOTAL REPORT 1,999.32 1,999.32
89 PEI PAGE NUMBER: 1
DATE: 09/30/2022 CITY OF LEMOORE AUDIT31
TIME: 08:24:32 REVENUE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.account between '3000' and '3999' and transact.batch='VM091622' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 001 - GENERAL FUND

ACCOUNT DATE T/C RECEIVE REFERENCE PAYER/VENDOR BUDGET RECEIPTS RECEIVABLES DESCRIPTION 3681 RECREATION FEES
3 /23 09/16/22 210 15258 T3250 ARSELIA PUGA -250.00 REFUND VET HALL TOTAL RECREATION FEES .00 -250.00 .00
TOTAL GENERAL FUND .00 -250.00 .00
TOTAL GENERAL FUND .00 -250.00 .00
TOTAL REPORT .00 -250.00 .00
RUN DATE 09/30/2022 TIME 08:24:32 PEI - FUND ACCOUNTING 90 PEI PAGE NUMBER: 1
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4211 - CITY COUNCIL

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4980 LEGAL EXPENSE
3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 1,181.25 .00 PROFESSIONAL SERVICE 3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 1,307.50 .00 PROFESSIONAL SERVICE TOTAL LEGAL EXPENSE .00 2,488.75 .00
TOTAL CITY COUNCIL .00 2,488.75 .00
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING Warrant Register 09-23-2022
91 PEI PAGE NUMBER: 2
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4213 - CITY MANAGER

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4980 LEGAL EXPENSE
3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 693.75 .00 PROFESSIONAL SERVICE 3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 1,763.10 .00 PROFESSIONAL SERVICE TOTAL LEGAL EXPENSE .00 2,456.85 .00
TOTAL CITY MANAGER .00 2,456.85 .00
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 92 PEI PAGE NUMBER: 3
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4215 - FINANCE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11661 -01 15297 7148 LOOMIS 248.13 -248.13 ARMORED CAR SERVICES TOTAL PROFESSIONAL CONTRACT SVC .00 248.13 -248.13
4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 93.47 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 93.47 .00
4980 LEGAL EXPENSE
3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 1,687.50 .00 PROFESSIONAL SERVICE TOTAL LEGAL EXPENSE .00 1,687.50 .00
TOTAL FINANCE .00 2,029.10 -248.13
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 93 PEI PAGE NUMBER: 4
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4216 - PLANNING

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4980 LEGAL EXPENSE
3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 1,556.25 .00 PROFESSIONAL SERVICE TOTAL LEGAL EXPENSE .00 1,556.25 .00
TOTAL PLANNING .00 1,556.25 .00
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 94 PEI PAGE NUMBER: 5
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4220 - MAINTENANCE DIVISION

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4170 UNIFORM ALLOWANCE
3 /23 09/22/22 21 15308 T3254 ERIC ROMERO 167.78 .00 BOOT REIMBURSEMENT TOTAL UNIFORM ALLOWANCE .00 167.78 .00
4220 OPERATING SUPPLIES
3 /23 09/22/22 21 15323 0520 WINDTAMER TARPS 70.00 .00 REPAIR 3 /23 09/22/22 21 15294 0304 LEMOORE HARDWARE -7.28 .00 MARKING PAINT 3 /23 09/22/22 21 15311 6613 THE SHERWIN WILL 484.23 .00 PAINT TOTAL OPERATING SUPPLIES .00 546.95 .00
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11621 -01 15286 5758 MARK FERNANDES 2,100.00 -2,100.00 PD, SARAH MOONEY, AND CMC TOTAL PROFESSIONAL CONTRACT SVC .00 2,100.00 -2,100.00
4340 UTILITIES
3 /23 09/22/22 21 15304 0363 PG&E 23,905.71 .00 07/29/22-08/29/22 3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 354.81 .00 08/03/22-09/02/22 3 /23 09/22/22 21 15303 0363 PG&E 806.16 .00 08/09/22-09/07/22 TOTAL UTILITIES .00 25,066.68 .00
TOTAL MAINTENANCE DIVISION .00 27,881.41 -2,100.00
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 95 PEI PAGE NUMBER: 6
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4221 - POLICE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/22/22 21 11618 -05 15309 0531 SAN DIEGO POLICE 594.00 -594.00 FORCE ON FORCE 9MM MARKER 3 /23 09/22/22 21 11618 -06 15309 0531 SAN DIEGO POLICE 594.00 -594.00 FORCE ON FORCE 9MM MARKER 3 /23 09/22/22 21 11618 -07 15309 0531 SAN DIEGO POLICE 1,356.00 -1,356.00 FORCE ON FORCE 5.56MM MAR 3 /23 09/22/22 21 11618 -08 15309 0531 SAN DIEGO POLICE 184.44 -184.44 TAX 3 /23 09/22/22 21 11618 -09 15309 0531 SAN DIEGO POLICE 28.26 -28.26 SHIPPING TOTAL OPERATING SUPPLIES .00 2,756.70 -2,756.70
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11710 -01 15293 0772 COUNTY OF KINGS 5,081.04 -5,081.04 INFORMATION TECHNOLOGY SE TOTAL PROFESSIONAL CONTRACT SVC .00 5,081.04 -5,081.04
4330 PRINTING & PUBLICATIONS
3 /23 09/22/22 21 15293 0772 COUNTY OF KINGS 105.70 .00 PRINT SHOP TOTAL PRINTING & PUBLICATIONS .00 105.70 .00
4360 TRAINING
3 /23 09/22/22 21 15299 T3205 JACOB MARTINEZ 42.00 .00 INTERVIEW & INTERROGA 3 /23 09/22/22 21 15318 7225 RAYMUNDO VALENCI 42.00 .00 INTERVIEW & INTERROGA TOTAL TRAINING .00 84.00 .00
4380 RENTALS & LEASES
3 /23 09/22/22 21 15281 1817 C.A. REDING COMP 379.65 .00 08/02/22-09/01/22 TOTAL RENTALS & LEASES .00 379.65 .00
TOTAL POLICE .00 8,407.09 -7,837.74
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 96 PEI PAGE NUMBER: 7
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4222 - FIRE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/22/22 21 15296 0313 LEMOORE VOLUNTEE 1,312.73 .00 TUESDAY TRAININGS 3 /23 09/22/22 21 15294 0304 LEMOORE HARDWARE 18.83 .00 TV KWIKSETLOCK 3 /23 09/22/22 21 15294 0304 LEMOORE HARDWARE 23.57 .00 MOP & GLO CLEANER 3 /23 09/22/22 21 15294 0304 LEMOORE HARDWARE 31.09 .00 SOLDERING IIRON 3 /23 09/22/22 21 15294 0304 LEMOORE HARDWARE 38.59 .00 FLUO LAMP 3 /23 09/22/22 21 15283 0126 L.N. CURTIS & SO 44.95 .00 TRUCK REPAIRS 3 /23 09/22/22 21 15294 0304 LEMOORE HARDWARE 81.81 .00 GT 7PATT POLY NOZZLE TOTAL OPERATING SUPPLIES .00 1,551.57 .00
4980 LEGAL EXPENSE
3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 506.25 .00 PROFESSIONAL SERVICE 3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 3,113.07 .00 PROFESSIONAL SERVICE TOTAL LEGAL EXPENSE .00 3,619.32 .00
TOTAL FIRE .00 5,170.89 .00
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 97 PEI PAGE NUMBER: 8
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4224 - BUILDING INSPECTION

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 237.24 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 237.24 .00
4980 LEGAL EXPENSE
3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 187.50 .00 PROFESSIONAL SERVICE TOTAL LEGAL EXPENSE .00 187.50 .00
TOTAL BUILDING INSPECTION .00 424.74 .00
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 98 PEI PAGE NUMBER: 9
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4230 - PUBLIC WORKS

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11643 -02 15320 6783 VIRTUAL PROJECT 500.00 -500.00 VPM MONTHLY MAINTENANCE F TOTAL PROFESSIONAL CONTRACT SVC .00 500.00 -500.00
4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 137.69 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 137.69 .00
TOTAL PUBLIC WORKS .00 637.69 -500.00
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 99 PEI PAGE NUMBER: 10
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4242 - RECREATION

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 15315 6885 TRENTON WILLIAMS 670.00 .00 CONTRACTOR SERVICES TOTAL PROFESSIONAL CONTRACT SVC .00 670.00 .00
4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 93.47 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 93.47 .00
4980 LEGAL EXPENSE
3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 918.75 .00 PROFESSIONAL SERVICE TOTAL LEGAL EXPENSE .00 918.75 .00
TOTAL RECREATION .00 1,682.22 .00
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 100
PEI PAGE NUMBER: 11
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4296 - INFORMATION TECHNOLOGY

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 325.79 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 325.79 .00
TOTAL INFORMATION TECHNOLOGY .00 325.79 .00
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 101
PEI PAGE NUMBER: 12
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 4297 - HUMAN RESOURCES

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 44.22 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 44.22 .00
4534 EE HOME BUYERS ASSIST.PRG
3 /23 09/22/22 21 15282 2267 CHICAGO TITLE CO 10,000.00 .00 J. LOPEZ HOMEBUYER TOTAL EE HOME BUYERS ASSIST.PRG .00 10,000.00 .00
4980 LEGAL EXPENSE
3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 93.75 .00 PROFESSIONAL SERVICE 3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 56.25 .00 PROFESSIONAL SERVICE 3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 1,406.25 .00 PROFESSIONAL SERVICE 3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 56.25 .00 PROFESSIONAL SERVICE TOTAL LEGAL EXPENSE .00 1,612.50 .00
TOTAL HUMAN RESOURCES .00 11,656.72 .00
TOTAL GENERAL FUND .00 64,717.50 -10,685.87
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 102
PEI PAGE NUMBER: 13
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 040 - FLEET MAINTENANCE
BUDGET UNIT - 4265 - FLEET MAINTENANCE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/22/22 21 11554 -01 15290 0068 GARY V. BURROWS, 14,834.12 -14,834.12 FUEL 3 /23 09/22/22 21 11556 -01 15295 0306 LEMOORE HIGH SCH 2,862.14 -2,862.14 AUG CNG FUEL 3 /23 09/22/22 21 11557 -02 15290 0068 GARY V. BURROWS, 1,370.27 -1,370.27 CHANGE ORDER 1 - OIL TOTAL OPERATING SUPPLIES .00 19,066.53 -19,066.53
4230 REPAIR/MAINT SUPPLIES
3 /23 09/22/22 21 15292 6715 INTERSTATE BILLI 477.94 .00 PIPE-BELLOWS 3 /23 09/22/22 21 15278 6145 AUTOZONE 110.66 .00 ENGINE MOUNT FRONT 3 /23 09/22/22 21 15301 7236 N & S TRACTOR 15.51 .00 FILTER 3 /23 09/22/22 21 15279 1908 BATTERY SYSTEMS, 126.96 .00 BATTERY TOTAL REPAIR/MAINT SUPPLIES .00 731.07 .00
4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 88.44 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 88.44 .00
4350 REPAIR/MAINT SERVICES
3 /23 09/22/22 21 11558 -01 15280 0056 BILLINGSLEY TIRE -1,968.15 1,968.15 TIRE REPAIR 3 /23 09/22/22 21 11558 -01 15280 0056 BILLINGSLEY TIRE 119.00 -119.00 TIRE REPAIR 3 /23 09/22/22 21 11558 -01 15280 0056 BILLINGSLEY TIRE 480.77 -480.77 TIRE REPAIR 3 /23 09/22/22 21 11558 -01 15280 0056 BILLINGSLEY TIRE 790.61 -790.61 TIRE REPAIR 3 /23 09/22/22 21 11558 -01 15280 0056 BILLINGSLEY TIRE 1,968.15 -1,968.15 TIRE REPAIR 3 /23 09/22/22 21 11558 -01 15280 0056 BILLINGSLEY TIRE 2,052.82 -2,052.82 TIRE REPAIR 3 /23 09/22/22 21 11713 -01 15306 6323 QUINN COMPANY 950.81 -950.81 BLANK PO HYDRAULICS CYLIN TOTAL REPAIR/MAINT SERVICES .00 4,394.01 -4,394.01
TOTAL FLEET MAINTENANCE .00 24,280.05 -23,460.54
TOTAL FLEET MAINTENANCE .00 24,280.05 -23,460.54
RUN DATE 09/30/2022 TIME 08:32:43 PEI - FUND ACCOUNTING 103
PEI PAGE NUMBER: 14
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 050 - WATER
BUDGET UNIT - 4250 - WATER

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220CH CHLORINE OPERATING SUPPLY
3 /23 09/22/22 21 11591 -01 15316 6058 UNIVAR 739.68 -739.68 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/22/22 21 11591 -01 15316 6058 UNIVAR 1,094.73 -1,094.73 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/22/22 21 11591 -01 15316 6058 UNIVAR 1,331.43 -1,331.43 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/22/22 21 11591 -01 15316 6058 UNIVAR 1,441.44 -1,441.44 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/22/22 21 11591 -01 15316 6058 UNIVAR 1,482.62 -1,482.62 SODIUM HYPOCHLORITE-CHLOR 3 /23 09/22/22 21 11591 -01 15316 6058 UNIVAR 2,514.93 -2,514.93 SODIUM HYPOCHLORITE-CHLOR TOTAL CHLORINE OPERATING SUPPLY .00 8,604.83 -8,604.83
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11691 -01 15313 6663 SUSP, INC 132,560.00 -132,560.00 LEMOORE CPO SERVICES TOTAL PROFESSIONAL CONTRACT SVC .00 132,560.00 -132,560.00 4340 UTILITIES
3 /23 09/22/22 21 15305 6627 PG&E NON ENERGY 445.37 .00 09/01/22-09/30/22 3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 292.36 .00 08/03/22-09/02/22 3 /23 09/22/22 21 15319 0116 VERIZON WIRELESS 50.01 .00 08/05/22-09/04/22 TOTAL UTILITIES .00 787.74 .00
TOTAL WATER .00 141,952.57 -141,164.83
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 104
PEI PAGE NUMBER: 15
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 050 - WATER
BUDGET UNIT - 4251 - UTILITY OFFICE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 88.44 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 88.44 .00
TOTAL UTILITY OFFICE .00 88.44 .00
TOTAL WATER .00 142,041.01 -141,164.83
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 105
PEI PAGE NUMBER: 16
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 052 - WATER INCIDENT FUND
BUDGET UNIT - 4752 - WATER INCIDENT

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4380 RENTALS & LEASES
3 /23 09/22/22 21 15302 2138 NICK CHAMPI ENTE 112.61 .00 MONTHLY TEMPORARY FEN TOTAL RENTALS & LEASES .00 112.61 .00
4980 LEGAL EXPENSE
3 /23 09/22/22 21 15298 5609 LOZANO SMITH, LL 562.50 .00 PROFESSIONAL SERVICE TOTAL LEGAL EXPENSE .00 562.50 .00
TOTAL WATER INCIDENT .00 675.11 .00
TOTAL WATER INCIDENT FUND .00 675.11 .00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 106
PEI PAGE NUMBER: 17
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 056 - REFUSE
BUDGET UNIT - 4256 - REFUSE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4230 REPAIR/MAINT SUPPLIES
3 /23 09/22/22 21 15287 7339 FURTADO WELDING 207.08 .00 GLOVE TOTAL REPAIR/MAINT SUPPLIES .00 207.08 .00
4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11552 -01 15284 6869 WELLS FARGO BANK 810.30 -810.30 TEMP POSITION TOTAL PROFESSIONAL CONTRACT SVC .00 810.30 -810.30
4320 MEETINGS & DUES
3 /23 09/22/22 21 15312 6759 SWANA 275.00 .00 PUBLIC MEMBER ASSOCIA TOTAL MEETINGS & DUES .00 275.00 .00
4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 535.67 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 535.67 .00
TOTAL REFUSE .00 1,828.05 -810.30
TOTAL REFUSE .00 1,828.05 -810.30
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 107
PEI PAGE NUMBER: 18
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 060 - SEWER& STORM WTR DRAINAGE
BUDGET UNIT - 4260 - SEWER

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4220 OPERATING SUPPLIES
3 /23 09/22/22 21 15285 5866 FASTENAL COMPANY 246.22 .00 GLOVES 3 /23 09/22/22 21 15317 2038 USA BLUEBOOK 153.82 .00 HACH TOTAL CHLORINE TOTAL OPERATING SUPPLIES .00 400.04 .00
4230 REPAIR/MAINT SUPPLIES
3 /23 09/22/22 21 11693 -01 15300 5333 MEDALLION SUPPLY 778.57 -784.29 SO14/4 500 FT WIRE 3 /23 09/22/22 21 11693 -02 15300 5333 MEDALLION SUPPLY 56.45 -56.86 SALES TAX TOTAL REPAIR/MAINT SUPPLIES .00 835.02 -841.15
4340 UTILITIES
3 /23 09/22/22 21 15277 5048 AT&T MOBILITY 449.29 .00 08/03/22-09/02/22 TOTAL UTILITIES .00 449.29 .00
4360 TRAINING
3 /23 09/22/22 21 15288 7287 ANTHONY GARCIA 60.00 .00 DRINKING WATER TREATM TOTAL TRAINING .00 60.00 .00
TOTAL SEWER .00 1,744.35 -841.15
TOTAL SEWER& STORM WTR DRAINAGE .00 1,744.35 -841.15
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 108
PEI PAGE NUMBER: 19
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 155 - HOUSING AUTHORITY FUND
BUDGET UNIT - 4953 - HOUSING AUTHORITY FUNDS

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11603 -01 15310 4054 SELF-HELP ENTERP 674.25 -674.25 LOAN PORTFOLIO MANAGEMENT TOTAL PROFESSIONAL CONTRACT SVC .00 674.25 -674.25
TOTAL HOUSING AUTHORITY FUNDS .00 674.25 -674.25
TOTAL HOUSING AUTHORITY FUND .00 674.25 -674.25
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 109
PEI PAGE NUMBER: 20
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 201 - LLMD ZONE 1
BUDGET UNIT - 4851 - LLMD ZONE 1 WESTFIELD

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11683 -01 15322 7238 WESTSCAPES 3,583.00 -3,583.00 LLMD 1 TOTAL PROFESSIONAL CONTRACT SVC .00 3,583.00 -3,583.00
TOTAL LLMD ZONE 1 WESTFIELD .00 3,583.00 -3,583.00
TOTAL LLMD ZONE 1 .00 3,583.00 -3,583.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 110
PEI PAGE NUMBER: 21
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 203 - LLMD ZONE 3 SILVA ESTATES
BUDGET UNIT - 4853 - LLMD ZONE 3 SILVA ESTATES

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11682 -01 15322 7238 WESTSCAPES 452.00 -452.00 LLMD 3 TOTAL PROFESSIONAL CONTRACT SVC .00 452.00 -452.00
TOTAL LLMD ZONE 3 SILVA ESTATES .00 452.00 -452.00
TOTAL LLMD ZONE 3 SILVA ESTATES .00 452.00 -452.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 111
PEI PAGE NUMBER: 22
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 205 - LLMD ZONE 5 WILDFLOWER
BUDGET UNIT - 4855 - LLMD ZONE 5 WILDFLOWER

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11680 -01 15322 7238 WESTSCAPES 75.00 -75.00 LLMD 5 TOTAL PROFESSIONAL CONTRACT SVC .00 75.00 -75.00
TOTAL LLMD ZONE 5 WILDFLOWER .00 75.00 -75.00
TOTAL LLMD ZONE 5 WILDFLOWER .00 75.00 -75.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 112
PEI PAGE NUMBER: 23
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 206 - LLMD ZONE 6 CAPISTRANO
BUDGET UNIT - 4856 - LLMD ZONE 6 CAPISTRANO

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11681 -01 15322 7238 WESTSCAPES 81.00 -81.00 LLMD 6 TOTAL PROFESSIONAL CONTRACT SVC .00 81.00 -81.00
TOTAL LLMD ZONE 6 CAPISTRANO .00 81.00 -81.00
TOTAL LLMD ZONE 6 CAPISTRANO .00 81.00 -81.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 113
PEI PAGE NUMBER: 24
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 207 - LLMD ZONE 7 SILVERADO
BUDGET UNIT - 4857 - LLMD ZONE 7 SILVERADO

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11679 -01 15322 7238 WESTSCAPES 291.00 -291.00 LLMD 7 TOTAL PROFESSIONAL CONTRACT SVC .00 291.00 -291.00
TOTAL LLMD ZONE 7 SILVERADO .00 291.00 -291.00
TOTAL LLMD ZONE 7 SILVERADO .00 291.00 -291.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 114
PEI PAGE NUMBER: 25
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 208A - LLMD ZONE 8 COUNTRY CLUB
BUDGET UNIT - 4858A - LLMD ZONE 8 COUNTRY CLUB

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11678 -01 15322 7238 WESTSCAPES 412.00 -412.00 LLMD 8A TOTAL PROFESSIONAL CONTRACT SVC .00 412.00 -412.00
TOTAL LLMD ZONE 8 COUNTRY CLUB .00 412.00 -412.00
TOTAL LLMD ZONE 8 COUNTRY CLUB .00 412.00 -412.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 115
PEI PAGE NUMBER: 26
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 208B - LLMD ZONE 8B GREENS
BUDGET UNIT - 4858B - LLMD ZONE 8B GREENS

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11677 -01 15322 7238 WESTSCAPES 434.00 -434.00 LLMD 8B TOTAL PROFESSIONAL CONTRACT SVC .00 434.00 -434.00
4350 REPAIR/MAINT SERVICES
3 /23 09/22/22 21 15322 7238 WESTSCAPES 432.41 .00 VALVE ARE LEAKING FRO 3 /23 09/22/22 21 15322 7238 WESTSCAPES 432.41 .00 18TH AVE-NORTH SIDE 3 /23 09/22/22 21 15322 7238 WESTSCAPES 316.93 .00 REPAIR BROKEN WATER L TOTAL REPAIR/MAINT SERVICES .00 1,181.75 .00
TOTAL LLMD ZONE 8B GREENS .00 1,615.75 -434.00
TOTAL LLMD ZONE 8B GREENS .00 1,615.75 -434.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 116
PEI PAGE NUMBER: 27
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 209 - LLMD ZONE 9 LA DANTE ROSE
BUDGET UNIT - 4859 - LLMD ZONE 9 LA DANTE ROSE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11676 -01 15322 7238 WESTSCAPES 295.00 -295.00 LLMD 9 TOTAL PROFESSIONAL CONTRACT SVC .00 295.00 -295.00
TOTAL LLMD ZONE 9 LA DANTE ROSE .00 295.00 -295.00
TOTAL LLMD ZONE 9 LA DANTE ROSE .00 295.00 -295.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 117
PEI PAGE NUMBER: 28
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 210 - LLMD ZONE 10 AVALON
BUDGET UNIT - 4860 - LLMD ZONE 10 AVALON

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11675 -01 15322 7238 WESTSCAPES 817.00 -817.00 LLMD 10 TOTAL PROFESSIONAL CONTRACT SVC .00 817.00 -817.00
TOTAL LLMD ZONE 10 AVALON .00 817.00 -817.00
TOTAL LLMD ZONE 10 AVALON .00 817.00 -817.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 118
PEI PAGE NUMBER: 29
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 211 - LLMD ZONE 11 SELF HELP EN
BUDGET UNIT - 4861 - LLMD ZONE 11 SELF HELP EN

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11664 -01 15322 7238 WESTSCAPES 89.50 -89.50 LLMD 11 TOTAL PROFESSIONAL CONTRACT SVC .00 89.50 -89.50
TOTAL LLMD ZONE 11 SELF HELP EN .00 89.50 -89.50
TOTAL LLMD ZONE 11 SELF HELP EN .00 89.50 -89.50
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 119
PEI PAGE NUMBER: 30
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 212 - LLMD ZONE 12 SUMMERWIND
BUDGET UNIT - 4862 - LLMD ZONE 12 SUMMERWIND

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11674 -01 15322 7238 WESTSCAPES 1,778.00 -1,778.00 LLMD 12 TOTAL PROFESSIONAL CONTRACT SVC .00 1,778.00 -1,778.00
TOTAL LLMD ZONE 12 SUMMERWIND .00 1,778.00 -1,778.00
TOTAL LLMD ZONE 12 SUMMERWIND .00 1,778.00 -1,778.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 120
PEI PAGE NUMBER: 31
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 213 - LLMD ZONE 13 CORNERSTONE
BUDGET UNIT - 4863 - LLMD ZONE 13 CORNERSTONE

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11673 -01 15322 7238 WESTSCAPES 252.00 -252.00 LLMD 13 TOTAL PROFESSIONAL CONTRACT SVC .00 252.00 -252.00
TOTAL LLMD ZONE 13 CORNERSTONE .00 252.00 -252.00
TOTAL LLMD ZONE 13 CORNERSTONE .00 252.00 -252.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 121
PEI PAGE NUMBER: 32
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 251 - PFMD ZONE 1
BUDGET UNIT - 4871 - PFMD ZONE 1

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11672 -01 15322 7238 WESTSCAPES 599.00 -599.00 PFMD 1 TOTAL PROFESSIONAL CONTRACT SVC .00 599.00 -599.00
TOTAL PFMD ZONE 1 .00 599.00 -599.00
TOTAL PFMD ZONE 1 .00 599.00 -599.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 122
PEI PAGE NUMBER: 33
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 252 - PFMD ZONE 2
BUDGET UNIT - 4872 - PFMD ZONE 2

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11671 -01 15322 7238 WESTSCAPES 1,771.00 -1,771.00 PFMD 2 TOTAL PROFESSIONAL CONTRACT SVC .00 1,771.00 -1,771.00
TOTAL PFMD ZONE 2 .00 1,771.00 -1,771.00
TOTAL PFMD ZONE 2 .00 1,771.00 -1,771.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 123
PEI PAGE NUMBER: 34
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 253 - PFMD ZONE 3
BUDGET UNIT - 4873 - PFMD ZONE 3

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11670 -01 15322 7238 WESTSCAPES 525.00 -525.00 PFMD 3 TOTAL PROFESSIONAL CONTRACT SVC .00 525.00 -525.00
TOTAL PFMD ZONE 3 .00 525.00 -525.00
TOTAL PFMD ZONE 3 .00 525.00 -525.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 124
PEI PAGE NUMBER: 35
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 254 - PFMD ZONE 4
BUDGET UNIT - 4874 - PFMD ZONE 4

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11669 -01 15322 7238 WESTSCAPES 439.00 -439.00 PFMD 4 TOTAL PROFESSIONAL CONTRACT SVC .00 439.00 -439.00
TOTAL PFMD ZONE 4 .00 439.00 -439.00
TOTAL PFMD ZONE 4 .00 439.00 -439.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 125
PEI PAGE NUMBER: 36
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 255 - PFMD ZONE 5
BUDGET UNIT - 4875 - PFMD ZONE 5

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11668 -01 15322 7238 WESTSCAPES 699.00 -699.00 PFMD 5 TOTAL PROFESSIONAL CONTRACT SVC .00 699.00 -699.00
TOTAL PFMD ZONE 5 .00 699.00 -699.00
TOTAL PFMD ZONE 5 .00 699.00 -699.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 126
PEI PAGE NUMBER: 37
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 256 - PFMD ZONE 6
BUDGET UNIT - 4876 - PFMD ZONE 6

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11667 -01 15322 7238 WESTSCAPES 398.00 -398.00 PFMD 6 TOTAL PROFESSIONAL CONTRACT SVC .00 398.00 -398.00
TOTAL PFMD ZONE 6 .00 398.00 -398.00
TOTAL PFMD ZONE 6 .00 398.00 -398.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 127
PEI PAGE NUMBER: 38
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 257 - PFMD ZONE 7
BUDGET UNIT - 4877 - PFMD ZONE 7

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11681 -02 15322 7238 WESTSCAPES 81.00 -81.00 PFMD 7 TOTAL PROFESSIONAL CONTRACT SVC .00 81.00 -81.00
TOTAL PFMD ZONE 7 .00 81.00 -81.00
TOTAL PFMD ZONE 7 .00 81.00 -81.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 128
PEI PAGE NUMBER: 39
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 258 - PFMD ZONE 8
BUDGET UNIT - 4878 - PFMD ZONE 8

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11666 -01 15322 7238 WESTSCAPES 557.00 -557.00 PFMD 8 TOTAL PROFESSIONAL CONTRACT SVC .00 557.00 -557.00
TOTAL PFMD ZONE 8 .00 557.00 -557.00
TOTAL PFMD ZONE 8 .00 557.00 -557.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 129
PEI PAGE NUMBER: 40
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 259 - PFMD ZONE 9
BUDGET UNIT - 4879 - PFMD ZONE 9

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11665 -01 15322 7238 WESTSCAPES 579.00 -579.00 PFMD 9 TOTAL PROFESSIONAL CONTRACT SVC .00 579.00 -579.00
TOTAL PFMD ZONE 9 .00 579.00 -579.00
TOTAL PFMD ZONE 9 .00 579.00 -579.00
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 130
PEI PAGE NUMBER: 41
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 260 - PFMD ZONE 10
BUDGET UNIT - 4880 - PFMD ZONE 10

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11664 -02 15322 7238 WESTSCAPES 89.50 -89.50 PFMD 10 TOTAL PROFESSIONAL CONTRACT SVC .00 89.50 -89.50
TOTAL PFMD ZONE 10 .00 89.50 -89.50
TOTAL PFMD ZONE 10 .00 89.50 -89.50
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 131
PEI PAGE NUMBER: 42
DATE: 09/30/2022 CITY OF LEMOORE AUDIT11
TIME: 08:32:43 EXPENDITURE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.fund between '001' and '800' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 406 - WASTEWATER CIP
BUDGET UNIT - 5304 - WASTEWATER TREATMENT PLAN

ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 4310 PROFESSIONAL CONTRACT SVC
3 /23 09/22/22 21 11632 -01 15291 6965 GLOBAL WATER TEC 50,000.00 -50,000.00 MONTHLY RENTAL FEE (50,00 TOTAL PROFESSIONAL CONTRACT SVC .00 50,000.00 -50,000.00 TOTAL WASTEWATER TREATMENT PLAN .00 50,000.00 -50,000.00 TOTAL WASTEWATER CIP .00 50,000.00 -50,000.00
TOTAL REPORT .00 301,439.07 -241,933.94
RUN DATE 09/30/2022 TIME 08:32:44 PEI - FUND ACCOUNTING 132
PEI PAGE NUMBER: 1
DATE: 09/30/2022 CITY OF LEMOORE AUDIT311
TIME: 08:34:22 GENERAL LEDGER TRANSACTION ANALYSIS
SELECTION CRITERIA: account.acct between '2000' and '2999'AND transact.yr='23' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 120 - FACILITIES RENTAL FUND

ACCOUNT DATE T/C REFERENCE VENDOR/PAYER DEBIT CREDIT DESCRIPTION 2020 ACCOUNTS PAYABLE
3 /23 09/22/22 21 15307 T3252 JORGE LUIS ROMAN 250.00 REFUND DEPOIT VET HAL TOTAL ACCOUNTS PAYABLE .00 250.00
2300 CUSTOMER DEPOSITS
3 /23 09/22/22 21 15307 T3252 JORGE LUIS ROMAN 250.00 REFUND DEPOIT VET HAL TOTAL CUSTOMER DEPOSITS 250.00 .00
TOTAL FACILITIES RENTAL FUND 250.00 250.00
TOTAL REPORT 250.00 250.00
133
PEI PAGE NUMBER: 1
DATE: 09/30/2022 CITY OF LEMOORE AUDIT31
TIME: 08:33:35 REVENUE TRANSACTION ANALYSIS
SELECTION CRITERIA: transact.yr='23' and transact.account between '3000' and '3999' and transact.batch='VM092322' ACCOUNTING PERIOD: 3/23
FUND - 001 - GENERAL FUND
BUDGET UNIT - 001 - GENERAL FUND

ACCOUNT DATE T/C RECEIVE REFERENCE PAYER/VENDOR BUDGET RECEIPTS RECEIVABLES DESCRIPTION 3625 CIVIC AUDITORIUM RENTAL
3 /23 09/22/22 210 15314 T3251 TAISHA GREEN -150.00 REFUND CANCEL CIVIC TOTAL CIVIC AUDITORIUM RENTAL .00 -150.00 .00
3681 RECREATION FEES
3 /23 09/22/22 210 15289 T3253 LISA GARCIA -150.00 REFUND DEP VET HALL TOTAL RECREATION FEES .00 -150.00 .00
TOTAL GENERAL FUND .00 -300.00 .00
TOTAL GENERAL FUND .00 -300.00 .00
TOTAL REPORT .00 -300.00 .00
RUN DATE 09/30/2022 TIME 08:33:35 PEI - FUND ACCOUNTING 134

Lemoore City CouncilOctober 4, 2022

Lemoore City Council
October 4, 2022