City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) CEQA LITIGATION
2023 City of Indian Wells Local Guidelines 10-3 ©Best Best & Krieger LLP (1) Index. A detailed index must be included at the beginning of the administrative record listing each document in the order presented. Each entry must include the document’s title, date, brief description, and the volume and page where the document begins;
(2) The Notice of Determination;
(3) The resolutions or ordinances adopted by the Lead Agency approving the project; (4) The findings required by Public Resources Code section 21081, including any statement of overriding considerations;
(5) The Final EIR, including the Draft EIR or a revision of the draft, all other matters included in the Final EIR (such as traffic studies and air quality studies), or other types of environmental documents prepared under CEQA, such as a negative declaration, mitigated negative declaration, or addenda; (6) The initial study;
(7) Staff reports prepared for the administrative bodies providing subordinate approvals or recommendations to the Lead Agency, in chronological order; (8) Transcripts and minutes of hearings, in chronological order; and (9) All other documents appropriate for inclusion in the administrative record, in chronological order.
Each section listed above must be separated by tabs or marked with electronic bookmarks.
Oversized documents (such as building plans and maps) must be presented in a manner that allows them to be easily unfolded and viewed.
The court may issue an order allowing the documents to be organized in a different manner.
C. Preparation of Administrative Record.
The administrative record can be prepared: (1) by the petitioner, if the petitioner elects to do so, or (2) by the Lead Agency. The petitioner and the Lead Agency can also agree on any alternative method of preparing the record. However, when a third party such as the project applicant prepares or assists with the preparation of the administrative record, the Lead Agency may not be able to recover fees incurred by the third party unless petitioner has agreed to this method of preparation.
Notwithstanding the above, upon the written request of a project applicant received no later than 30 days after the date that the Lead Agency makes a determination pursuant to Public Resources Code section 21080.1, 21094.5, or Chapter 4.2 (commencing with Public Resources Code section 21155) and with the written consent of the Lead Agency sent within 10 business days from receipt of the written request, the Lead Agency may prepare the administrative record concurrently with the administrative process. Should the Lead Agency and the project applicant
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) CEQA LITIGATION
2023 City of Indian Wells Local Guidelines 10-4 ©Best Best & Krieger LLP so desire to pursue concurrent record preparation, the parties must comply with the provisions of Public Resources Code section 21167.6.2.
D. Special Circumstances For Environmental Leadership Projects.
Special timing considerations and requirements apply if the Project is certified by the Governor as an Environmental Leadership Project pursuant to the “Jobs and Economic Improvement Through Environmental Leadership Act of 2021.” For example, the administrative record must be finished and certified within five (5) days of project approval. See Public Resources Code section 21186 for a complete discussion of the special requirements related to the preparation of an administrative record for an Environmental Leadership Project.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-1 ©Best Best & Krieger LLP
11. DEFINITIONS
Whenever the following terms are used in these Local Guidelines, they shall have the following meaning unless otherwise expressly defined:
11.01 “Agricultural Employee” means a person engaged in agriculture, which includes farming in all its branches, and, among other things, includes: (1) the cultivation and tillage of the soil, (2) dairying, (3) the production, cultivation, growing, and harvesting of any agricultural or horticultural commodities, (4) the raising of livestock, bees, furbearing animals, or poultry, and (5) any practices (including any forestry or lumbering operations) performed by a farmer or on a farm as an incident to or in conjunction with such farming operations, including preparation for market and delivery to storage or to market or to carriers for transportation to market.
This definition does not include any person covered by the National Labor Relations Act as agricultural employees pursuant to Section 2(3) of the Labor Management Relations Act (Section 152(3), Title 29, United States Code) and Section 3(f) of the Fair Labor Standards Act (Section 203(f), Title 29, United States Code). This definition does not apply to employees who perform work to be done at the site of the construction, alteration, painting, or repair of a building, structure, or other work (as these terms have been construed under Section 8(e) of the Labor Management Relations Act, 29 United States Code section 158(e)) or logging or timber-clearing operations in initial preparation of land for farming, or who does land leveling or only land surveying for any of the above. As used in this definition, “land leveling” shall include only major land moving operations changing the contour of the land, but shall not include annual or seasonal tillage or preparation of land for cultivation. (State CEQA Guidelines section 15191(a).)
11.02 “Applicant” means a person who proposes to carry out a project that requires a lease, permit, license, certificate, or other entitlement for use, or requires financial aid from one or more public agencies when applying for governmental approval or assistance.
11.03 “Approval” means a decision by the decision-making body or other authorized body or officer of the City which commits the City to a definite course of action with regard to a particular project. With regard to any project to be undertaken directly by the City, approval shall be deemed to occur on the date when the decision-making body adopts a motion or resolution determining to proceed with the project, which in no event shall be later than the date of adoption of plans and specifications. As to private projects, approval shall be deemed to have occurred upon the earliest commitment to provide service or the issuance by the City of a discretionary contract, subsidy, or other form of financial assistance, lease, permit, license, certificate, or other entitlement for use of the project. The mere acquisition of land by the City shall not, in and of itself, be deemed to constitute approval of a project.
For purposes of these Local Guidelines, all environmental documents must be completed as of the time of project approval.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-2 ©Best Best & Krieger LLP
11.04 “Baseline” refers to the pre-project environmental conditions. By comparing the project’s potential impacts to the baseline, the Lead Agency determines whether the project’s impacts are substantial enough to be significant under the relevant thresholds of significance. Generally, the baseline is the environmental conditions existing on the date the environmental analysis begins, such as the date the Notice of Preparation is published for an EIR or the date the Notice of Intent to Adopt a Negative Declaration is published. However, in certain circumstances, an earlier or later date may provide a more accurate environmental analysis. The City may establish any baseline that is appropriate, including an earlier or later date, as long as the choice of baseline can be supported by substantial evidence.
11.05 “California Native American Tribe” means a Native American tribe located in California that is on the contact list maintained by the Native American Heritage Commission for the purposes of Chapter 905 of the Statutes of 2004.
11.06 “Categorical Exemption” means an exemption from CEQA for a class of projects based on a finding by the Secretary of the Resources Agency that the class of projects does not have a significant effect on the environment.
11.07 “Census-Defined Place” means a specific unincorporated land area within boundaries determined by the United States Census Bureau in the most recent decennial census.
11.08 “CEQA” means the California Environmental Quality Act, codified at California Public Resources Code sections 21000, et seq.
11.09 “City” means the City of Indian Wells.
11.10 “Clerk” means either the “Clerk of the Board” or the “County Clerk” depending upon the county. Please refer to the “Index to Environmental Filing by County” in the Staff Summary to determine which applies.
11.11 “Community-Level Environmental Review” means either (1) or (2) below:
(1) An EIR certified for any of the following:
(a) A general plan;
(b) A revision or update to the general plan that includes at least the land use and circulation elements;
(c) An applicable community plan;
(d) An applicable specific plan; or
(e) A housing element of the general plan, if the Environmental Impact Report analyzed the environmental effects of the density of the proposed project;
(2) A Negative Declaration or Mitigated Negative Declaration adopted as a subsequent environmental review document, following and based upon an EIR on a general plan, an applicable community plan or specific plan, provided that the subsequent environmental review document is allowed by CEQA following
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-3 ©Best Best & Krieger LLP a Master EIR or a Program EIR or is required pursuant to Public Resource Section 21166.
11.12 “Consultation” means the meaningful and timely process of seeking, discussing, and considering carefully the views of others, in a manner that is cognizant of all parties' cultural values and, where feasible, seeking agreement. Consultation between government agencies and Native American tribes shall be conducted in a way that is mutually respectful of each party's sovereignty. Consultation shall also recognize the tribes' potential needs for confidentiality with respect to places that have traditional tribal cultural significance.
11.13 “Cumulative Impacts” means two or more individual effects which, when considered together, are considerable or which compound or increase other environmental impacts.
The individual effects may be changes resulting from a single project or a number of separate projects, whether past, present or future.
The cumulative impact from several projects is the change in the environment which results from the incremental impact of the project when added to other closely related past, present and reasonably foreseeable future projects. Cumulative impacts can result from individually minor but collectively significant projects taking place over a period of time.
11.14 “Cumulatively Considerable” means that the incremental effects of an individual project are significant when viewed in connection with the effects of past projects, the effects of other current projects, and the effects of probable future projects.
11.15 “Decision-Making Body” means the body within the City, e.g. the City Council, which has final approval authority over the particular project.
11.16 “Developed Open Space” means land that meets each of the following three criteria:
(1) Is publicly owned, or financed in whole or in part by public funds; (2) Is generally open to, and available for use by, the public; and (3) Is predominantly lacking in structural development other than structures associated with open spaces, including, but not limited to, playgrounds, swimming pools, ball fields, enclosed child play areas, and picnic facilities.
Developed Open Space may include land that has been designated for acquisition by a public agency for developed open space purposes, but does not include lands acquired by public funds dedicated to the acquisition of land for housing purposes.
11.17 “Development Project” means any project undertaken for the purpose of development, including any project involving the issuance of a permit for construction or reconstruction but not a permit to operate. It does not include any ministerial projects proposed to be carried out or approved by public agencies. (Government Code section 65928.)
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-4 ©Best Best & Krieger LLP
11.18 “Discretionary Project” means a project for which approval requires the exercise of independent judgment, deliberation, or decision-making on the part of the City. To determine whether a project is discretionary, the key question is whether the public agency can use its subjective judgment to decide whether and how to carry out or approve a project.
11.19 “EIR” means Environmental Impact Report, a detailed written statement setting forth the environmental effects and considerations pertaining to a project. EIR may mean a Draft or a Final version of an EIR, a Project EIR, a Subsequent EIR, a Supplemental EIR, a Tiered EIR, a Staged EIR, a Program EIR, a Redevelopment EIR, a Master EIR, or a Focused EIR.
11.20 “Emergency” means a sudden, unexpected occurrence, involving a clear and imminent danger, demanding immediate action to prevent or mitigate loss of, or damage to, life, health, property, or essential public services. Emergency includes such occurrences as fire, flood, earthquake, landslide or other natural disaster, as well as such occurrences as riot, war, terrorist incident, accident or sabotage.
11.21 “Endangered, Rare or Threatened Species” means certain species or subspecies of animals or plants. A species or subspecies of animal or plant is “Endangered” when its survival and reproduction in the wild are in immediate jeopardy from one or more causes, including loss of habitat, change in habitat, overexploitation, predation, competition, disease, or other factors. A species or subspecies of animal or plant is “Threatened” when it is listed as a threatened species pursuant to the California Endangered Species Act or the Federal Endangered Species Act. A species or subspecies of animal or plant is “Rare” when either:
(1) Although not presently threatened with extinction, the species is existing in such small numbers throughout all or a significant portion of its range that it may become endangered if its environment worsens; or
(2) The species is likely to become endangered within the foreseeable future throughout all or a significant portion of its range and many be considered “threatened” as that term is used in the Federal Endangered Species Act.
For purposes of analyzing impacts to biological resources, a species of animal or plant shall be presumed to be endangered, rare or threatened if it is listed under the California Endangered Species Act or the Federal Endangered Species Act.
This definition shall not include any species of the Class Insecta which is a pest whose protection under the provisions of CEQA would present an overwhelming and overriding risk to man as determined by the Director of Food and Agriculture (with regard to economic pests) or the Director of Health Services (with regard to health risks).
11.22 “Environment” means the physical conditions which exist in the area which will be affected by a proposed project, including land, air, water, minerals, flora, fauna, ambient noise, and objects of historic or aesthetic significance. The area involved shall
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-5 ©Best Best & Krieger LLP be the area in which significant effects would occur either directly or indirectly as a result of the project. The “environment” includes both natural and man-made conditions.
11.23 “Feasible” means capable of being accomplished in a successful manner within a reasonable period of time, taking into account economic, environmental, social and technological factors.
11.24 “Final EIR” means an EIR containing the information contained in the Draft EIR, comments either verbatim or in summary received in the review process, a list of persons commenting, and the response of the City to the comments received.
11.25 “Greenhouse Gases” include, but are not limited to, carbon dioxide, methane, nitrous oxide, hydrofluorocarbons, perfluorocarbons, and sulfur hexafluoride.
11.26 “Guidelines” or “Local Guidelines” means the City’s Local Guidelines for implementing the California Environmental Quality Act.
11.27 “Highway” shall have the same meaning as defined in Section 360 of the Vehicle Code.
11.28 “Historical Resources” include:
Resources listed in, or eligible for listing in, the California Register of Historical Resources shall be considered historical resources.
A resource may be listed in the California Register if it meets any of the following National Register of Historic Places criteria:
(a) Is associated with events that have made a significant contribution to the broad patterns of California’s history and cultural heritage; (b) Is associated with the lives of persons important in our past; (c) Embodies the distinctive characteristics of a type, period, region, or method of construction, or represents the work of an important creative individual, or possesses high artistic values; or
(d) Has yielded, or may be likely to yield, information important in prehistory or history.
A resource may also be listed in the California Register if it is identified as significant in an historical resource survey that meets all of the following criteria:
(a) The survey has been or will be included in the State Historic Resources Inventory;
(b) The survey and the survey documentation were prepared in accordance with office procedures and requirements; and
(c) The resource is evaluated and determined by the office to have a significance rating of Category 1 to 5 on DPR Form 523.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-6 ©Best Best & Krieger LLP Resources included on a list of properties officially designated or recognized as historically significant by a local government pursuant to a local ordinance or resolution, or identified as significant in a historical resource survey (as described above) are presumed to be historically or culturally significant, unless a preponderance of evidence demonstrates that they are not historically or culturally significant.
Any of the following may be considered historically significant: any object, building, structure, site, area, place, record or manuscript which a Lead Agency determines, based upon substantial evidence in light of the whole record, to be historically significant or significant in the architectural, engineering, scientific, economic, agricultural, educational, social, political, military or cultural annals of California.
The Lead Agency is not precluded from determining that a resource is a historical resource, as defined in Public Resources Code sections 5020.1(j) or 5024.1, even if it is: (a) not listed in, or is not determined to be eligible for listing in, the California Register of Historical Resources; (b) not included in a local register of historical resources; or (c) not identified in a historical resources survey.
11.29 “Infill Site” means a site in an urbanized area that meets either of the following criteria:
(1) The site has been previously developed for qualified urban uses; or (2) The site has not been previously developed for qualified urban uses and both (a) and (b) are met:
(a) the site is immediately adjacent to parcels that are developed with qualified urban uses, or
1. at least 75 percent of the perimeter of the site adjoins, or is separated only by an improved public right-of-way from, parcels that are developed with existing qualified urban uses at the time the Lead Agency receives an application for an approval; and
2. the remaining 25 percent of the perimeter of the site adjoins parcels that had been previously developed for qualified urban uses;
(b) No parcel within the site has been created within the past 10 years unless the parcel was created as a result of the plan of a redevelopment agency. (Public Resources Code section 21061.3.)
11.30 “Initial Study” means a preliminary analysis conducted by the City to determine whether an EIR, a Negative Declaration, or a Mitigated Negative Declaration must be prepared or to identify the significant environmental effects to be analyzed in an EIR.
11.31 “Jurisdiction by Law” means the authority of any public agency to grant a permit or other entitlement for use, to provide funding for the project in question or to exercise authority over resources which may be affected by the project.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-7 ©Best Best & Krieger LLP The City will have jurisdiction by law over a project when the City has primary and exclusive jurisdiction over the site of the project, the area in which the major environmental effects will occur, or the area in which reside those citizens most directly concerned by any such environmental effects.
11.32 “Land Disposal Facility” means a hazardous waste facility where hazardous waste is disposed in, on, or under land. (Health and Safety Code section 25199.1(d).)
11.33 “Large Treatment Facility” means a treatment facility which treats or recycles one thousand (1,000) or more tons of hazardous waste during any one month of the current reporting period commencing on or after July 1, 1991. (Health and Safety Code section 25205.1(d).)
11.34 “Lead Agency” means the public agency which has the principal responsibility for preparing environmental documents and for carrying out or approving a project when more than one public agency is involved with the same underlying activity.
11.35 “Low- and Moderate-Income Households” means persons and families of low or moderate income as defined in Section 50093 of the Health and Safety Code—i.e., persons and families whose income does not exceed 120% of area median income, adjusted for family size by the Department of Housing and Community Development, in accordance with adjustment factors adopted and amended from time to time by the United States Department of Housing and Urban Development pursuant to Section 8 of the United States Housing Act of 1937. (Public Resources Code section 21159.20(d); State CEQA Guidelines section 15191(f).)
11.36 “Low-Income Households” means households of persons and families of very low and low income. Low-income persons or families are those eligible for financial assistance from governmental agencies for occupants of state-funded housing. Very low income persons are those whose incomes do not exceed the qualifying limits for very low income families as established and amended pursuant to Section 8 of the United States Housing Act of 1937. Such limits are published and updated in the California Code of Regulations. (Public Resources Code section 21159.20(c); Health and Safety Code sections 50105 and 50106; State CEQA Guidelines section 15191(g).)
11.37 “Low-Level Flight Path” means any flight path for any aircraft owned, maintained, or under the jurisdiction of the United States Department of Defense that flies lower than 1,500 feet above ground level, as indicated in the United States Department of Defense Flight Information Publication, “Area Planning Military Training Routes: North and South America (AP/1B)” published by the United States National Imagery and Mapping Agency or its successor.
11.38 “Lower Income Households” is defined in Health and Safety Code section 50079.5 to mean any of the following:
(1) “Lower income households” means persons and families whose income does not exceed the qualifying limits for lower income families as established and
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-8 ©Best Best & Krieger LLP amended from time to time pursuant to Section 8 of the United States Housing Act of 1937;
(2) “Very low income households” means persons and families whose incomes do not exceed the qualifying limits for very low income families as defined in Health and Safety Code 50105; or
(3) “Extremely low income households” means persons and families whose incomes do not exceed the qualifying limits for extremely low income families as defined in Health and Safety Code section 50106.
11.39 “Major Transit Stop” means a site containing an existing rail or bus rapit transit station, a ferry terminal served by either a bus or rail transit service, or the intersection of two or more major bus routes with a frequency of service interval of fifteen (15) minutes or less during the morning and afternoon peak commute periods. (Pub. Resources Code, § 21064.3; see also Pub. Resources Code, § 21060.2; State CEQA Guidelines section 15191(i).)
11.40 “Metropolitan Planning Organization” or “MPO” means a federally-designated agency that provides transportation planning and programming in metropolitan areas. A MPO is designated for each urban area that has been defined in the most recent federal census as having a population of more than 50,000 people. There are 18 federally-designated MPOs in California. Non-urbanized (rural) areas do not have a designated MPO.
11.41 “Military Impact Zone” means any area, including airspace, that meets both of the following criteria:
(1) Is located within two miles of a military installation, including, but not limited to, any base, military airport, camp, post, station, yard, center, homeport facility for a ship, or any other military activity center that is under the jurisdiction of the United States Department of Defense; and
(2) Covers greater than 500 acres of unincorporated land, or greater than 100 acres of city incorporated land.
11.42 “Military Service” means the United States Department of Defense or any branch of the United States Armed Forces.
11.43 “Ministerial” describes a governmental decision involving little or no personal judgment by the public official as to the wisdom or manner of carrying out the project.
The public official merely applies the law to the facts as presented but uses no special discretion or standards or objective measurements, and the public official cannot use personal, subjective judgment in deciding whether or how the project should be carried out. Common examples of ministerial permits include automobile registrations, dog licenses, and marriage licenses. A building permit is ministerial if the ordinance requiring the permit limits the public official to determining whether the zoning allows the structure to be built in the requested location, the structure would meet the strength
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-9 ©Best Best & Krieger LLP requirements in the Uniform Building Code, and the applicant has paid his fee. (Public Resources Code section 21080(b)(1).)
11.44 “Mitigated Negative Declaration” or “MND” means a Negative Declaration prepared for a Project when the Initial Study has identified potentially significant effects on the environment, but: (1) revisions in the project plans or proposals made, or agreed to, by the applicant before the proposed Negative Declaration and Initial Study are released for public review would avoid the effects or mitigate the effects to a point where clearly no significant effect on the environment would occur, and (2) there is no substantial evidence in light of the whole record before the public agency that the project, as revised, may have a significant effect on the environment.
11.45 “Mitigation” includes avoiding the environmental impact altogether by not taking a certain action or parts of an action, minimizing impacts by limiting the degree or magnitude of the action and its implementation, rectifying the impact by repairing, rehabilitating or restoring the impacted environment, reducing or eliminating the impact over time by preservation and maintenance operations during the life of the action, or compensating for the impact by replacing or providing substitute resources or environments, including through permanent protection of such resources in the form of conservation easements.
11.46 “Negative Declaration” or “ND” means a written statement by the City briefly describing the reasons that a proposed project, not exempt from CEQA, will not have a significant effect on the environment and, therefore, does not require the preparation of an EIR.
11.47 “Notice of Completion” means a brief report filed with the Office of Planning and Research by the City when it is the Lead Agency as soon as it has completed a Draft EIR and is prepared to send out copies for review.
11.48 “Notice of Determination” means a brief notice to be filed by the City when it approves or determines to carry out a project which is subject to the requirements of CEQA.
11.49 “Notice of Exemption” means a brief notice which may be filed by the City when it has approved or determined to carry out a project, and it has determined that the project is exempt from the requirements of CEQA. Such a notice may also be filed by an applicant where such a determination has been made by a public agency which must approve the project.
11.50 “Notice of Preparation” means a brief notice sent by a Lead Agency to notify the Responsible Agencies, Trustee Agencies, the Office of Planning and Research, and involved federal agencies that the Lead Agency plans to prepare an EIR for a project.
The purpose of this notice is to solicit guidance from those agencies as to the scope and content of the environmental information to be included in the EIR. Public agencies are free to develop their own formats for this notice.
11.51 “Oak” means a native tree species in the genus Quercus, not designated as Group A or Group B commercial species pursuant to regulations adopted by the State Board of
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-10 ©Best Best & Krieger LLP Forestry and Fire Protection pursuant to Public Resources Code section 4526, and that is five (5) inches or more in diameter at breast height. (Public Resources Code section 21083.4(a).)
11.52 “Oak Woodlands” means an oak stand with a greater than 10 percent canopy cover or that may have historically supported greater than 10 percent canopy cover. (Fish & Game Code section 1361(h).)
11.53 “Offsite Facility” means a facility that serves more than one generator of hazardous waste. (Public Resources Code section 21151.1(h).)
11.54 “Person” includes any person, firm, association, organization, partnership, business, trust, corporation, company, city, county, city and county, town, the state, and any of the agencies which may be political subdivisions of such entities, and, to the extent permitted by federal law, the United States, or any of its agencies or political subdivisions.
11.55 “Pipeline” as defined in these Local Guidelines depends on the context. Please see Local Guidelines Sections 3.10 and 3.11 for specific definitions.
11.56 “Private Project” means a project which will be carried out by a person other than a governmental agency, but which will need a discretionary approval from the City.
Private projects will normally be those listed in subsections (2) and (3) of Local Guidelines Section 11.57.
11.57 “Project” means the whole of an action or activity which may cause either a direct physical change in the environment, or a reasonably foreseeable indirect change in the environment, and is any of the following:
(1) A discretionary activity directly undertaken by the City including but not limited to public works construction and related activities, clearing or grading of land, or improvements to existing public structures; (2) A discretionary activity which involves a public agency’s issuance to a person of a lease, permit, license, certificate, or other entitlement for use, or which is supported, in whole or in part, through contracts, grants, subsidies, loans or other forms of assistance by the City; or
(3) A discretionary project proposed to be carried out or approved by public agencies, including but not limited to the enactment and amendment of local General Plans or elements thereof, the enactment of zoning ordinances, the issuance of zoning variances, the issuance of conditional use permits and the approval of tentative subdivision maps.
The presence of any real degree of control over the manner in which a project is completed makes it a discretionary project.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-11 ©Best Best & Krieger LLP The term “project” refers to the activity which is being approved and which may be subject to several discretionary approvals by governmental agencies. The term “project” does not mean each separate governmental approval.
11.58 “Project-Specific Effects” means all the direct or indirect environmental effects of a project other than cumulative effects and growth-inducing effects. (Public Resources Code section 21065.3; State CEQA Guidelines section 15191(j).)
11.59 “Public Water System” means a system for the provision of piped water to the public for human consumption that has 3,000 or more service connections. A public water system includes all of the following: (A) Any collection, treatment, storage, and distribution facility under control of the operator of the system which is used primarily in connection with the system; (B) Any collection or pretreatment storage facility not under the control of the operator that is used primarily in connection with the system; (C) Any person who treats water on behalf of one or more public water systems for the purpose of rendering it safe for human consumption. (State CEQA Guidelines section 15155.)
11.60 “Qualified Urban Use” means any residential, commercial, public institutional, transit or transportation passenger facility, or retail use, or any combination of those uses. (Public Resources Code section 21072; State CEQA Guidelines section 15191(k).)
11.61 “Residential” means a use consisting of either residential units only or residential units and primarily neighborhood-serving goods, services, or retail uses that do not exceed 15% of the total floor area of the project. (State CEQA Guidelines section 15191(l).) Residential, pursuant to Public Resources Code section 21159.24, shall mean a use consisting of either of the following:
(1) Residential units only.
(2) Residential units and primarily neighborhood-serving goods, services, or retail uses that do not exceed 25 percent of the total building square footage of the project.
11.62 “Responsible Agency” means a public agency which proposes to carry out or approve a project for which a Lead Agency has prepared the environmental documents. For the purposes of CEQA, the term “Responsible Agency” includes all federal, state, regional and local public agencies other than the Lead Agency which have discretionary approval power over the project.
11.63 “Riparian areas” mean those areas transitional between terrestrial and aquatic ecosystems and that are distinguished by gradients in biophysical conditions, ecological processes, and biota. A riparian area is an area through which surface and subsurface hydrology connect waterbodies with their adjacent uplands. A riparian area includes those portions of terrestrial ecosystems that significantly influence exchanges of energy and matter with aquatic ecosystems. A riparian area is adjacent to perennial, intermittent, and ephemeral streams, lakes, and estuarine-marine shorelines.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-12 ©Best Best & Krieger LLP
11.64 “Roadway” means a roadway as defined pursuant to Section 530 of the Vehicle Code and the previously graded and maintained shoulder that is within a roadway right-of- way of no more than five feet from the edge of the roadway.
11.65 “Significant Effect” means a substantial, or potentially substantial, adverse change in any of the physical conditions within the area affected by the activity including land, air, water, minerals, flora, fauna, ambient noise, and objects of historic or aesthetic significance. A social or economic change related to a physical change may be considered in determining whether the physical change is significant.
11.66 “Significant Value as a Wildlife Habitat” includes wildlife habitat of national, statewide, regional, or local importance; habitat for species protected by the federal Endangered Species Act of 1973 (16 U.S.C. Sec. 1531, et seq.), the California Endangered Species Act (Chapter 1.5 (commencing with Section 2050) of Division 3 of the Fish and Game Code), or the Native Plant Protection Act (Chapter 10 (commencing with Section 1900) of Division 2 of the Fish and Game Code); habitat identified as candidate, fully protected, sensitive, or species of special status by local, state, or federal agencies; or habitat essential to the movement of resident or migratory wildlife.
11.67 “Special Use Airspace” means the land area underlying the airspace that is designated for training, research, development, or evaluation for a military service, as that land area is established by the United States Department of Defense Flight Information Publication, “Area Planning: Special Use Airspace: North and South America (AP/1A)” published by the United States National Imagery and Mapping Agency or its successor.
11.68 “Staff” means the City Manager or his or her designee.
11.69 “Standard” means a standard of general application that is all of the following:
(1) A quantitative, qualitative or performance requirement found in a statute, ordinance, resolution, rule, regulation, order, or other standard of general application;
(2) Adopted for the purpose of environmental protection; (3) Adopted by a public agency through a public review process; (4) Governs the same environmental effect which the change in the environment is impacting; and
(5) Governs the jurisdiction where the project is located.
The definition of “standard” includes any thresholds of significance adopted by the City which meet the requirements of this Section.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-13 ©Best Best & Krieger LLP If there is a conflict between standards, the City shall determine which standard is appropriate based upon substantial evidence in light of the whole record.
11.70 “State CEQA Guidelines” means the Guidelines for Implementation of the California Environmental Quality Act as adopted by the Secretary of the California Natural Resources Agency as they now exist or hereafter may be amended. (California Administrative Code, Title 14, Sections 15000, et seq.)
11.71 “Substantial Evidence” means reliable information on which a fair argument can be based to support an inference or conclusion, even though another conclusion could be drawn from that information. “Substantial evidence” includes facts, reasonable assumptions predicated upon facts, and expert opinion supported by facts. “Substantial evidence” does not include argument, speculation, unsubstantiated opinion or narrative, evidence which is clearly inaccurate or erroneous, or evidence of social or economic impacts which do not contribute to, or are not caused by, physical impacts on the environment.
11.72 “Sustainable Communities Strategy” is an element of a Regional Transportation Plan, which must be adopted by the Metropolitan Planning Organization for the region. (See Local Guidelines Section 11.40.) The Sustainable Communities Strategy is an integrated land use and transportation plan intended to reduce greenhouse gases. The Sustainable Communities Strategy includes various components such as: consideration of existing densities and uses within the region, identification of areas within the region that can accommodate an eight-year projection of the region’s housing needs, development of projections for growth in the region, identification of existing transportation networks, and preparation of a forecast for development pattern for the region that can be integrated with transportation networks.
11.73 “Tiering” means the coverage of general matters in broader EIRs (such as on general plans or policy statements) with subsequent narrower EIRs or ultimately site-specific EIRs incorporating by reference the general discussions and concentrating solely on the issues specific to the EIR subsequently prepared. Tiering is appropriate when the sequence of EIRs is:
(a) From a general plan, policy, or Program EIR to a program, plan, or policy EIR of lesser scope or to a site-specific EIR; or (b) From an EIR on a specific action at an early stage to a subsequent EIR or a supplement to an EIR at a later stage. Tiering in such cases is appropriate when it helps the Lead Agency to focus on the issues which are ripe for decision and exclude from consideration issues already decided or not yet ripe.
(Public Resources Code sections 21003, 21061 and 21100.)
11.74 “Transit Priority Area” means an area within one-half mile of a major transit stop that is existing or planned, if the planned stop is scheduled to be completed within the
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-14 ©Best Best & Krieger LLP planning horizon included in a Transportation Improvement Program adopted pursuant to Section 450.216 or 450.322 of Title 23 of the Code of Federal Regulations.
11.75 “Transit Priority Project” means a mixed use project that is consistent with the general use designation, density, building intensity, and applicable policies specified for the project area in either a sustainable communities strategy or an alternative planning strategy for which the California Air Resources Board has accepted a Metropolitan Planning Organization’s determination that the sustainable communities strategy or the alternative planning strategy would, if implemented, achieve the greenhouse gas emission reduction targets. Such a project may be exempt from CEQA if a detailed laundry list of requirements is met. To qualify for the exemption, the Transit Priority Project must:
(1) contain at least 50 percent residential use based on total building square footage; (2) if the project contains between 26 percent and 50 percent non-residential uses, the floor-to-area ratio (FAR) must be at least 0.75;
(3) have a minimum net density of 20 dwelling units per acre; (4) be located within a half mile of a major transit stop or high-quality transit corridor included in a regional transportation plan; and (5) meet all the requirements of Public Resources Code section 21155.1.
11.76 “Transportation Facilities” includes major local arterials and public transit within five (5) miles of the project site, and freeways, highways, and rail transit service within ten (10) miles of the project site.
11.77 “Tribal Cultural Resources” are either of the following:
(1) Sites, features, places, cultural landscapes, sacred places, and objects with cultural value to a California Native American tribe that are either of the following:
(a) Included or determined to be eligible for inclusion in the California Register of Historical Resources.
(b) Included in a local register of historic resources as defined in subdivision (k) of Public Resources Code section 5020.1. (2) A resource determined by the Lead Agency, in its discretion and supported by substantial evidence, to be significant pursuant to criteria set forth in subdivision (c) of Public Resources Code section 5024.1. In applying the criteria set forth in subdivision (c) of Section 5024.1 for the purposes of this definition, the Lead Agency shall consider the significance of the resource to a California Native American tribe.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-15 ©Best Best & Krieger LLP A cultural landscape that meets the criteria set forth above is a tribal cultural resource to the extent that the landscape is geographically defined in terms of the size and scope of the landscape.
A historic resource described in Public Resources Code section 21084.1, a unique archaeological resource as defined in subdivision (g) of Public Resources Code section 21083.2, or a “nonunique archaeological resource” as defined in subdivision (h) of Public Resources Code section 21083.2 may also be a tribal cultural resource if it conforms with the criteria of Tribal cultural resources.
11.78 “Trustee Agency” means a State agency having jurisdiction by law over natural resources affected by a project which are held in trust for the people of the State of California. Trustee Agencies may include, but are not limited to, the following:
(a) The California Department of Fish and Wildlife (“DFW”) with regard to the fish and wildlife of the state, designated rare or endangered native plants, and game refuges, ecological reserves, and other areas administered by DFW;
(b) The State Lands Commission with regard to state owned “sovereign” lands such as the beds of navigable waters and state school lands; (c) The State Department of Parks and Recreation with regard to units of the State Park System;
(d) The University of California with regard to sites within the Natural Land and Water Reserve System; and/or
(e) The State Water Resources Control Board with respect to surface waters.
11.79 “Urban Growth Boundary” means a provision of a locally adopted general plan that allows urban uses on one side of the boundary and prohibits urban uses on the other side of the boundary.
11.80 “Urbanized Area” means either of the following:
(1) An incorporated city that either by itself or in combination with two contiguous incorporated cities has a population of at least one hundred thousand (100,000) persons;
(2) An unincorporated area that meets both of the following requirements:
(a) The unincorporated area is either:
(i) completely surrounded by one or more incorporated cities, has a population of at least 100,000 persons either by itself or in combination with the surrounding incorporated city or cities, and has a population density that at least equals the population density of the surrounding city or cities; or
(ii) located within an urban growth boundary and has an existing residential population of at least five thousand (5,000) persons per square mile. An “urban growth boundary” means a
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-16 ©Best Best & Krieger LLP provision of a locally adopted general plan that allows urban uses on one side of the boundary and prohibits urban uses on the other side.
(b) The board of supervisors with jurisdiction over the unincorporated area has taken all three of the following steps:
1. Prepared a draft document by which the board would find that the general plan, zoning ordinance, and related policies and programs applicable to the unincorporated area are consistent with principles that encourage compact development in a manner that promotes efficient transportation systems,
economic growth, affordable housing, energy efficiency, and an appropriate balance of jobs and housing, and protects the environment, open space and agricultural areas;
2. Submitted the draft document to the Office of Planning and Research and allowed OPR thirty (30) days to submit comments on the draft finding to the board; and
3. At least thirty (30) days after submitting the draft document to OPR, the board has adopted a final finding in substantial conformity with the draft finding described in the draft document.
(Public Resources Code sections 21083, 21159.20-21159.24; State CEQA Guidelines section 15191(m).)
11.81 “Water Acquisition Plans” means any plans for acquiring additional water supplies prepared by the public water system or a city or county Lead Agency pursuant to subdivision (a) of section 10911 of the Water Code.
11.82 “Water Assessment” or “Water Supply Assessment” means the water supply assessment that must be prepared by the governing body of a public water system, or a city or county, pursuant to and in compliance with sections 10910 to 10915 of the Water Code, and that includes, without limitation, the elements of the assessment required to comply with subdivisions (d), (e), (f), and (g) of section 10910 of the Water Code.
11.83 “Water Demand Project” means any one of the following:
(A) A residential development of more than 500 dwelling units; (B) A shopping center or business establishment employing more than 1,000 persons or having more than 500,000 square feet of floor space; (C) A commercial office building employing more than 1,000 persons or having more than 250,000 square feet of floor space;
(D) A hotel or motel, or both, having more than 500 rooms;
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-17 ©Best Best & Krieger LLP (E) An industrial, manufacturing, or processing plant, or industrial park planned to house more than 1,000 persons, occupying more than 40 acres of land, or having more than 650,000 square feet of floor area;
Except, a proposed photovoltaic or wind energy generation facility approved on or after October 8, 2011, is not a Water Demand Project if the facility would demand no more than 75 acre-feet of water annually.
(F) A mixed-use project that includes one or more of the projects specified in subdivisions (A); (B), (C), (D), (E), or (G) of this section; (G) A project that would demand an amount of water equivalent to, or greater than, the amount of water required by a 500 dwelling unit project; or (H) For public water systems with fewer than 5,000 service connections, a project that meets the following criteria:
(1) A proposed residential, business, commercial, hotel or motel, or industrial development that would account for an increase of 10 percent or more in the number of a public water system’s existing service connections; or
(2) A mixed-use project that would demand an amount of water equivalent to, or greater than, the amount of water required by residential development that would represent an increase of 10 percent or more in the number of the public water system’s existing service connections. (State CEQA Guidelines section 15155.)
11.84 “Waterway” means a bay, estuary, lake, pond, river, slough, or a perennial, intermittent, or ephemeral stream, lake, or estuarine-marine shoreline.
11.85 “Wetlands” has the same meaning as that term is construed in the regulations issued by the United States Army Corps of Engineers pursuant to the Clean Water Act. Thus, “wetlands” means areas that are inundated or saturated by surface or ground water at a frequency and duration sufficient to support, and that under normal circumstances do support, a prevalence of vegetation typically adapted for life in saturated soil conditions. Wetlands generally include swamps, marshes, bogs, and similar areas. (Public Resources Code section 21159.21(d), incorporating Title 33, Code of Federal Regulations, Section 328.3.)
11.86 “Wildlife Habitat” means the ecological communities upon which wild animals, birds, plants, fish, amphibians, and invertebrates depend for their conservation and protection. (Public Resources Code section 21159.21.)
11.87 “Zoning Approval” means any enactment, amendment, or appeal of a zoning ordinance; granting of a conditional use permit or variance; or any other form of land
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) DEFINITIONS
2023 City of Indian Wells Local Guidelines 11-18 ©Best Best & Krieger LLP use, subdivision, tract, or development approval required from the city or county having jurisdiction to permit the particular use of the property.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) FORMS
2023 City of Indian Wells Local Guidelines 12-1 ©Best Best & Krieger LLP
12. FORMS
See forms A – S which accompany these Guidelines.
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) Common ACRONYMS
2023 City of Indian Wells Local Guidelines 13-1 ©Best Best & Krieger LLP
13. COMMON ACRONYMS
A. **************************************************
ADEIR – Administrative Draft Environmental Impact Report AQMD – Air Quality Management District
AQMP – Air Quality Management Plan
AR – Administrative Record
ARB – Air Resources Board
B. **************************************************
BMP – Best Management Practices
BO – Biological Opinion
C. **************************************************
Cal EPA – California Environmental Protection Agency
CAP – Climate Action Plan
CCAA – California Clean Air Act
CCR – California Code of Regulations (Title 14 Sections 15000 et seq. are also known as the State CEQA Guidelines.)
CE – Categorical Exclusion (NEPA)
CESA – California Endangered Species Act
CEQA – California Environmental Quality Act
CFR – Code of Federal Regulations
CMP – Congestion Management Plan
CRWQCB – California Regional Water Quality Control Board D. **************************************************
DEIR – Draft Environmental Impact Report
DFW – Department of Fish and Wildlife
E. **************************************************
EA – Environmental Assessment (NEPA term)
EIR – Environmental Impact Report
EIS – Environmental Impact Statement (NEPA term)
EPA – Environmental Protection Agency
ESA – Endangered Species Act; Environmental Site Assessment F. **************************************************
FCAA – Federal Clean Air Act
FEIR – Final Environmental Impact Report
FOIA – Freedom of Information Act (Federal)
FONSI – Finding of No Significant Impact (NEPA term)
FWS – Fish and Wildlife Service
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) Common ACRONYMS
2023 City of Indian Wells Local Guidelines 13-2 ©Best Best & Krieger LLP G. **************************************************
GHG – Greenhouse Gas
GW – Ground Water
H. **************************************************
HH&E – Human Health and Environment
HRA – Health Risk Assessment
HS – Hazardous Substance
I. **************************************************
IS – Initial Study
J. **************************************************
K. **************************************************
L. **************************************************
LADD – Lifetime Average Daily Dose; Lowest Acceptable Daily Dose LEA – Local Enforcement Agency
LESA – Land Evaluation and Site Assessment
LUFT – Leaking Underground Fuel Tank
LUST – Leaking Underground Storage Tanks. Reference Part 213 of Public Act 451 of 1994.
M. **************************************************
MEIR – Master Environmental Impact Report
MMRP – Mitigation Monitoring and Reporting Plan
MPO – Metropolitan Planning Organization
MND – Mitigated Negative Declaration
N. **************************************************
ND – Negative Declaration
NEPA – National Environmental Policy Act
NOA – Notice of Availability
NOC – Notice of Completion
NOD – Notice of Determination
NOE – Notice of Exemption
NOI – Notice of Intent
NOP – Notice of Preparation
NOV – Notice of Violation
O. **************************************************
OPR – Office of Planning and Research
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) Common ACRONYMS
2023 City of Indian Wells Local Guidelines 13-3 ©Best Best & Krieger LLP P. **************************************************
PEIR – Program Environmental Impact Report. Sometimes also used to describe a Project Environmental Impact Report
PM – Particulate Matter
PRA – Public Records Act
PSA – Permit Streamlining Act
Q. **************************************************
R. **************************************************
RCRA – Resource Conservation and Recovery Act (1976) Governs definition, handling, and disposal of hazardous waste.
S. **************************************************
SCH – State Clearinghouse
SEIR – Supplemental or Subsequent Environmental Impact Report SMARA – Surface Mining and Reclamation Act
SWMP – Stormwater Monitoring Program
SWPPP – Stormwater Pollution Prevention Program
T. **************************************************
TCM – Transportation Control Measure
TCP – Transportation Control Plan
TDS – Total Dissolved Solids
TMP – Transportation Management Plan
Title V – refers to Title V of the Clean Air Act related to ambient air quality provisions TLV – Threshold Limit Value
U. **************************************************
UBC – Uniform Building Code
UFC – Uniform Fire Code
UGST – Underground Storage Tank
USDW – Underground Source of Drinking Water
UWMP – Urban Water Management Plan
V. **************************************************
VOC – Volatile Organic Compounds (Health & Safety Code, Section 25123.6.) VOS – Vehicle Operating Survey
W. **************************************************
WQS – Water Quality Standard
WSA – Water Supply Assessment
WTP – Water Treatment Plant. A facility designed to provide treatment to water.
WWTP – Wastewater Treatment Plan
City Council Agenda - June 1, 2023
Local Guidelines for Implementing the
California Environmental Quality Act (2023) Common ACRONYMS
2023 City of Indian Wells Local Guidelines 13-4 ©Best Best & Krieger LLP X. **************************************************
Y. **************************************************
Z. **************************************************
City Council Agenda - June 1, 2023
INDIAN WELLS CITY COUNCIL
June 1, 2023
To: City Council
From: Human Resources
Prepared by: Kristen Nelson, Senior Management Analyst
Subject: Annual Update to Employee’s Salary Range Schedule and FY 2023-24 Approved Employee Positions
RECOMMENDED ACTIONS:
Council APPROVES the annual update to employee’s salary schedule as required by the California Public Employees’ Pension Reform Act of 2013; and
APPROVES the Fiscal Year 2023-24 Approved Positions List with Annual Salaries and Ranges; and
DIRECTS staff to post the employee salary range schedule on the City’s website.
DISCUSSION:
Effective August 1, 2013, the Public Employees’ Pension Reform Act (“PEPRA”) changed the law to make compensation more transparent, specifically as it relates to eligible income for the calculation of retiree benefits. Under PEPRA, the calculation of employees’ retirement benefits must be for a salary within a publicly approved salary range schedule which is published on the City’s website.
Pursuant to the City’s Personnel Rules and Regulations (as amended by City Council February 15, 2018), Section IV Salary Administration, Subsection 2, the City’s salary ranges adjust automatically on an annual basis, based on changes to the Riverside/San Bernardino/Ontario Consumer Price Index (“CPI-W”) ending the prior calendar year in an amount not to exceed 2.5%. For the calendar year ending 2022, CPI increased 7.0%.
The salary range schedule will adjust by 2.5%.
The updated the salary range schedule (Attachment 1), updated Exhibit A to the FY 2019-21 MOU and Resolution 2022-03 for approved positions and salary ranges (Attachment 2), and the U.S. Department of Labor CPI table (Attachment 3) are included with this report.
City Council Agenda - June 1, 2023
FISCAL IMPACT:
Employee salaries and salary ranges will be adjusted by 2.5%, effective July 1, 2023, to coincide with the employment agreements for City employees. This increase is not applicable to the City Manager’s salary, as he has a separate employment agreement with the City.
ATTACHMENTS:
1. FY 2023-24 Salary Range Schedule
2. FY 2023-24 Approved Positions and Annual Salary Ranges
3. U.S. Department of Labor CPI Report
City Council Agenda - June 1, 2023
City of Indian Wells
Salary Schedule
FY 2023-24
Minimum Maximum Minimum Maximum Minimum Maximum Minimum Maximum 1 33,646 42,057 2,804 3,505 1,294.06 1,617.58 16.176 20.220 2 34,487 43,109 2,874 3,592 1,326.42 1,658.02 16.580 20.725 3 35,349 44,186 2,946 3,682 1,359.58 1,699.47 16.995 21.243 4 36,233 45,291 3,019 3,774 1,393.57 1,741.96 17.420 21.774 5 37,139 46,423 3,095 3,869 1,428.41 1,785.51 17.855 22.319 6 38,067 47,584 3,172 3,965 1,464.12 1,830.14 18.301 22.877 7 39,019 48,773 3,252 4,064 1,500.72 1,875.90 18.759 23.449 8 39,994 49,993 3,333 4,166 1,538.24 1,922.80 19.228 24.035 9 40,994 51,242 3,416 4,270 1,576.69 1,970.87 19.709 24.636 10 42,019 52,524 3,502 4,377 1,616.11 2,020.14 20.201 25.252 11 43,069 53,837 3,589 4,486 1,656.51 2,070.64 20.706 25.883 12 44,146 55,183 3,679 4,599 1,697.92 2,122.41 21.224 26.530 13 45,250 56,562 3,771 4,714 1,740.37 2,175.47 21.755 27.193 14 46,381 57,976 3,865 4,831 1,783.88 2,229.85 22.299 27.873 15 47,540 59,426 3,962 4,952 1,828.48 2,285.60 22.856 28.570 16 48,729 60,911 4,061 5,076 1,874.19 2,342.74 23.427 29.284 17 49,947 62,434 4,162 5,203 1,921.05 2,401.31 24.013 30.016 18 51,196 63,995 4,266 5,333 1,969.07 2,461.34 24.613 30.767 19 52,476 65,595 4,373 5,466 2,018.30 2,522.87 25.229 31.536 20 53,788 67,235 4,482 5,603 2,068.76 2,585.95 25.859 32.324 21 55,132 68,915 4,594 5,743 2,120.48 2,650.59 26.506 33.132 22 56,511 70,638 4,709 5,887 2,173.49 2,716.86 27.169 33.961 Monthly Biweekly Hourly
2.50%
Pay Periods per Year
26 Hours per Year
2,080
Salary Range Annual
Range Increase
FACTORS
Range 19 , Maximum, Annual
$65,594.72
Range Spread
25.00%
ATTACHMENT #1
City Council Agenda - June 1, 2023
City of Indian Wells
Salary Schedule
FY 2023-24
Minimum Maximum Minimum Maximum Minimum Maximum Minimum Maximum Monthly Biweekly HourlySalary Range Annual
23 57,923 72,404 4,827 6,034 2,227.82 2,784.78 27.848 34.810 24 59,372 74,214 4,948 6,185 2,283.52 2,854.40 28.544 35.680 25 60,856 76,070 5,071 6,339 2,340.61 2,925.76 29.258 36.572 26 62,377 77,972 5,198 6,498 2,399.12 2,998.90 29.989 37.486 27 63,937 79,921 5,328 6,660 2,459.10 3,073.88 30.739 38.423 28 65,535 81,919 5,461 6,827 2,520.58 3,150.72 31.507 39.384 29 67,173 83,967 5,598 6,997 2,583.59 3,229.49 32.295 40.369 30 68,853 86,066 5,738 7,172 2,648.18 3,310.23 33.102 41.378 31 70,574 88,218 5,881 7,351 2,714.39 3,392.98 33.930 42.412 32 72,338 90,423 6,028 7,535 2,782.25 3,477.81 34.778 43.473 33 74,147 92,684 6,179 7,724 2,851.80 3,564.75 35.648 44.559 34 76,001 95,001 6,333 7,917 2,923.10 3,653.87 36.539 45.673 35 77,901 97,376 6,492 8,115 2,996.18 3,745.22 37.452 46.815 36 79,848 99,810 6,654 8,318 3,071.08 3,838.85 38.389 47.986 37 81,844 102,305 6,820 8,525 3,147.86 3,934.82 39.348 49.185 38 83,890 104,863 6,991 8,739 3,226.55 4,033.19 40.332 50.415 39 85,988 107,485 7,166 8,957 3,307.22 4,134.02 41.340 51.675 40 88,137 110,172 7,345 9,181 3,389.90 4,237.37 42.374 52.967 41 90,341 112,926 7,528 9,410 3,474.65 4,343.31 43.433 54.291 42 92,599 115,749 7,717 9,646 3,561.51 4,451.89 44.519 55.649 43 94,914 118,643 7,910 9,887 3,650.55 4,563.19 45.632 57.040 44 97,287 121,609 8,107 10,134 3,741.81 4,677.27 46.773 58.466 45 99,719 124,649 8,310 10,387 3,835.36 4,794.20 47.942 59.927 46 102,212 127,765 8,518 10,647 3,931.24 4,914.05 49.141 61.426 47 104,768 130,960 8,731 10,913 4,029.52 5,036.91 50.369 62.961 48 107,387 134,234 8,949 11,186 4,130.26 5,162.83 51.628 64.535 49 110,071 137,589 9,173 11,466 4,233.52 5,291.90 52.919 66.149 50 112,823 141,029 9,402 11,752 4,339.36 5,424.20 54.242 67.802 51 115,644 144,555 9,637 12,046 4,447.84 5,559.80 55.598 69.498 52 118,535 148,169 9,878 12,347 4,559.04 5,698.80 56.988 71.235 53 121,498 151,873 10,125 12,656 4,673.01 5,841.27 58.413 73.016 54 124,536 155,670 10,378 12,972 4,789.84 5,987.30 59.873 74.841 55 127,649 159,561 10,637 13,297 4,909.58 6,136.98 61.370 76.712 56 130,840 163,551 10,903 13,629 5,032.32 6,290.40 62.904 78.630 57 134,111 167,639 11,176 13,970 5,158.13 6,447.66 64.477 80.596 58 137,464 171,830 11,455 14,319 5,287.08 6,608.86 66.089 82.611 59 140,901 176,126 11,742 14,677 5,419.26 6,774.08 67.741 84.676 60 144,423 180,529 12,035 15,044 5,554.74 6,943.43 69.434 86.793 Page 232 of 359 City Council Agenda - June 1, 2023
City of Indian Wells
Salary Schedule
FY 2023-24
Minimum Maximum Minimum Maximum Minimum Maximum Minimum Maximum Monthly Biweekly HourlySalary Range Annual
61 148,034 185,042 12,336 15,420 5,693.61 7,117.01 71.170 88.963 62 151,735 189,668 12,645 15,806 5,835.95 7,294.94 72.949 91.187 63 155,528 194,410 12,961 16,201 5,981.85 7,477.31 74.773 93.466 64 159,416 199,270 13,285 16,606 6,131.40 7,664.25 76.642 95.803 65 163,402 204,252 13,617 17,021 6,284.68 7,855.85 78.559 98.198 66 167,487 209,358 13,957 17,447 6,441.80 8,052.25 80.522 100.653 67 171,674 214,592 14,306 17,883 6,602.84 8,253.56 82.536 103.169 68 175,966 219,957 14,664 18,330 6,767.92 8,459.89 84.599 105.749 69 180,365 225,456 15,030 18,788 6,937.11 8,671.39 86.714 108.392 70 184,874 231,093 15,406 19,258 7,110.54 8,888.18 88.882 111.102 71 189,496 236,870 15,791 19,739 7,288.30 9,110.38 91.104 113.880 72 194,233 242,792 16,186 20,233 7,470.51 9,338.14 93.381 116.727 73 199,089 248,861 16,591 20,738 7,657.28 9,571.59 95.716 119.645 74 204,066 255,083 17,006 21,257 7,848.71 9,810.88 98.109 122.636 75 209,168 261,460 17,431 21,788 8,044.92 10,056.16 100.562 125.702 76 214,397 267,997 17,866 22,333 8,246.05 10,307.56 103.076 128.844 77 219,757 274,696 18,313 22,891 8,452.20 10,565.25 105.652 132.066 78 225,251 281,564 18,771 23,464 8,663.50 10,829.38 108.294 135.367 79 230,882 288,603 19,240 24,050 8,880.09 11,100.11 111.001 138.751 80 236,654 295,818 19,721 24,652 9,102.09 11,377.62 113.776 142.220 81 242,571 303,214 20,214 25,268 9,329.65 11,662.06 116.621 145.776 82 248,635 310,794 20,720 25,899 9,562.89 11,953.61 119.536 149.420
City Council Agenda - June 1, 2023
BEGIN TOP
POSITION RANGE RANGE RANGE
1 City Manager N/A 262,000$ 262,000$
2 Deputy City Manager 70 184,874$ 231,093$
3 Finance Director 68 175,966$ 219,957$
3a Finance Director* N/A 193,157$ 234,789$
4 Public Works Director 67 171,674$ 214,592$
5 Community Development Director 66 167,487$ 209,358$ 6 Information Technology Manager 58 137,464$ 171,830$ 6a Information Technology Manager* N/A 147,213$ 178,943$ 7 Building Official & Code Enforcment Mgr. 56 130,840$ 163,551$ 8 Assistant Finance Director 55 127,649$ 159,561$ 9 City Clerk 53 121,498$ 151,873$
10 Housing Manager 50 112,823$ 141,029$
11 Senior Management Analyst 46 102,212$ 127,765$ 12 Senior Management Analyst 46 102,212$ 127,765$ 13 Public Works Manager 46 102,212$ 127,765$
14 Public Works Field Supervisor 44 97,287$ 121,609$ 15 Planner 41 90,341$ 112,926$
16 Management Analyst 40 88,137$ 110,172$
17 Senior Executive Assistant 37 81,844$ 102,305$ 18 Public Works Inspector I 34 76,001$ 95,001$ 19 Accountant 33 74,147$ 92,684$
20 Management Assistant 33 74,147$ 92,684$
21 Building Inspector I/Code Enforcment Officer 31 70,574$ 88,218$ 22 Permit Technician II 31 70,574$ 88,218$
22a Permit Technician II* N/A 81,391$ 98,933$ 23 Accounting Technician II 28 65,535$ 81,919$ 23a Accounting Technician II* N/A 66,801$ 81,199$ 24 Administrative Assistant 28 65,535$ 81,919$ 25 Administrative Assistant 28 65,535$ 81,919$ 26 Permit Technician I 27 63,937$ 79,921$
26a Permit Technician I* N/A 70,183$ 85,310$
27 Planning Technician I 27 63,937$ 79,921$
28 Accounting Technician I 26 62,377$ 77,972$ 29 Accounting Technician I 26 62,377$ 77,972$
30 Maintenance Worker II 21 55,132$ 68,915$
31 Office Assistant 19 52,476$ 65,595$
32 Maintenance Worker I 17 49,947$ 62,434$
33 Maintenance Worker I 17 49,947$ 62,434$
34 Maintenance Worker I 17 49,947$ 62,434$
3,373,917$ 4,132,640$
City of Indian Wells
Approved Positions List w/ Annual Salaries and Ranges
Salaries for Fiscal Year 2023/24
*Hired on or before 02/17/2022 ATTACHMENT #2 Page 234 of 359 City Council Agenda - June 1, 2023
Bureau of Labor Statistics
Series Title All items in Riverside-San Bernardino-Ontario, CA, urban wage earners and clerical workers, not seasonally adjusted Series ID CWURS49CSA0
Seasonality Not Seasonally Adjusted
Survey Name CPI for Urban Wage Earners and Clerical Workers (CPI-W) Measure Data Type All items
Area Riverside-San Bernardino-Ontario, CA
Item All items
Year Period Label Observation
Value 12-Month % Change
2022 M01 2022 Jan 119.557 8.5
2022 M03 2022 Mar 122.861 9.9
2022 M05 2022 May 124.853 9.8
2022 M07 2022 Jul 126.084 9.5
2022 M09 2022 Sep 125.762 8.2
2022 M11 2022 Nov 126.453 7.3
2023 M01 2023 Jan 127.936 7.0
CPI for Urban Wage Earners and Clerical Workers (CPI-W) Bureau of Labor Statistics
Source: Bureau of Labor Statistics Generated on: April 25, 2023 (03:02:39 PM) ATTACHMENT #3
City Council Agenda - June 1, 2023
INDIAN WELLS CITY COUNCIL
June 1, 2023
To: City Council
From: Public Works Department
Prepared by: Dina Purvis, Public Works Manager
Subject: Warner Trail Improvement Project, Extended Construction Days, and Project Budget Advance
RECOMMENDED ACTIONS:
Council APPROVES easing of the City’s codified construction days for the Warner Trail Improvement project; and
APPROVES advancing the authorized Capital Improvement project budget funds into the upcoming fiscal year; and
AUTHORIZES City Manager or Designee to make the necessary budgetary adjustments.
DISCUSSION:
Warner Trail and Fred Waring Drive is one of the City’s busiest intersections. In addition, the City’s only school, Gerald Ford Elementary, is located nearby. To assist with traffic congestion during the school’s high-volume times, the City conducted a community outreach process and the outcome was to construct a right-hand turn pocket on northbound Warner Trail, just south of Fred Waring Drive. Additionally, there is a 5-foot diameter storm drain line beneath Warner Trail that needs repair. To minimize the impact of the construction work on the community and school, the projects have been combined and a phasing plan is in place.
Separately, the Coachella Valley Water District (CVWD) is currently installing a new non- potable water line in the same area. The City’s improvement project is scheduled to occur directly after CVWD’s project is completed. To avoid traffic impacts to the regular school year, the City’s project is scheduled to begin and end during the school’s summer break. The working day request is being made to allow the City’s contractor to work on Saturdays and Sundays to take advantage of the school’s summer break schedule and complete the project prior to the start of school in August. Currently, the Indian Wells Municipal Code (Section 9.06.047) does not allow work on Sundays. Working hours on the weekend days are required to be between 8am and 5pm.
City Council Agenda - June 1, 2023
The compressed working days schedule will require additional costs from the contractor.
Advancing the approved budget into the upcoming fiscal year will ensure the project has sufficient funding to complete the necessary repairs during the short construction window. The approved CIP budget includes $950,000 for FY2024, and $797,500 for FY2025, in addition to the rollover funds from the current fiscal year.
FISCAL IMPACT:
No additional funds are being requested. Advance $797,500 from the approved CIP budget for FY2025 to the upcoming 2024 fiscal year.
City Council Agenda - June 1, 2023
INDIAN WELLS CITY COUNCIL
June 1, 2023
To: City Council
From: Public Works Department
Prepared by: Ken Seumalo, Public Works Director
Subject: Fiscal Year 2023/24 Road Maintenance and Rehabilitation Account Funding Allocation
RECOMMENDED ACTION:
Council ADOPTS resolution approving the Fiscal Year 2023-2024 Road Maintenance and Rehabilitation Account Funding Allocation.
DISCUSSION:
Background:
In April 2017, California Governor Jerry Brown signed Senate Bill 1 (SB 1), known also as the Road Repair and Accountability Act of 2017, creating a new funding source to address the needs of California's transportation system. SB 1 created an account, the Road Maintenance and Rehabilitation Account (RMRA), where increases in the newly implemented per gallon fuel excise taxes and existing portions of diesel fuel sales taxes and vehicle registration fees would be deposited. Collectively, these RMRA funds are to be continuously appropriated on a monthly basis and apportioned by formula to cities and counties for road maintenance, rehabilitation, and safety needs. The first apportionment began in mid-January 2018.
Funding:
According to a report published by California City Finance, the City of Indian Wells (City) is estimated to receive an approximate total of $117,718 in Fiscal Year 2023/2024. The estimate is provided by California City Finance (Attachment 2).
RMRA Program Requirements and Use of Funds:
Similar to the Highway Users Tax Account (HUTA) use rules, RMRA funds must be used for projects that include the following:
Road maintenance and rehabilitation;
City Council Agenda - June 1, 2023
Safety projects;
Railroad grade separations;
Complete streets components (including active transportation purposes, pedestrian and bicycle safety projects, transit facilities, and drainage and stormwater capture projects); and
Traffic control devices
RMRA funds may also be utilized by cities and counties towards match requirements for state or federal funds for eligible projects.
Furthermore, SB 1 contains non-obligatory language that encourage the use of RMRA funds to incorporate the following additional project elements (to the extent possible and cost-effective):
Use of advanced material recycling techniques that reduce greenhouse gas emissions and reduce maintenance costs of local streets and roads; Incorporate automotive technologies and infrastructure-to-vehicle communications for autonomous vehicle systems;
Promote resiliency to impacts of climate change, fires, floods, sea level rise; and Incorporate complete street elements that improve quality and safety for all users of transportation facilities.
Lastly, if a city or county has an average pavement condition index (PCI) score that meets or exceeds 80, the city or county may spend its RMRA funds on transportation priorities other than the previously listed items. The City contracted with Bucknam Infrastructure Group, Inc. in 2021 to assess the pavement throughout the entire City. The final report indicated the citywide PCI was 75.3. Subsequently, Bucknam did another reporting after the Highway 111 Pavement Rehabilitation Project and Local Streets Paving Project that both occurred in 2022 and the citywide PCI is now 78 which is considered “Good” overall but doesn’t meet or exceed the required score of 80 yet. Street projects in fiscal year 2023-24 should increase the citywide PCI over 80, which is a Council goal for the upcoming fiscal year.
Maintenance of Effort:
The Road Repair and Accountability Act contains a local agency maintenance of effort (MOE) requirement that applies to funds allocated through the RMRA. The MOE requirement ensures that the new RMRA funds do not replace existing levels of city general revenue spending on streets and roads and affirms the City is committed to maintaining the same level of services already being provided after receiving funds.
To receive RMRA funds for Fiscal Year (FY) 2023/2024, the City must maintain general fund spending for street, road, and highway purposes at no less than average of FY
City Council Agenda - June 1, 2023
2009/2010, FY 2010/2011, and FY 2011/2012. If the City fails to meet this requirement in a given year, it may make it up with additional expenditures the following year.
According to the California City Finance’s unofficial estimates, the City’s MOE is $1,836,481 (Attachment 3).
Fiscal Year 2023/2024 Annual Project List:
Cities and counties must submit a project list pursuant to an adopted budget to the California Transportation Commission (CTC) prior to receiving RMRA funds in a fiscal year.
The project list must include a description, location, proposed schedule of completion, and estimated useful life of the improvement for each proposed project. According to the guidelines adopted by the CTC in August 2018, “after submittal of the project list to the Commission, in the event a city or county elects to make changes to the project list pursuant to the statutory provision noted above, formal notification of the Commission is not required.”
The RMRA requires that a city or county submit to the CTC an annual report of project completion to receive RMRA funds. The report must include descriptions of all projects for which RMRA funds were expended including (as with the submittal of the preceding project listing) a description, location, proposed schedule of completion, and estimated useful life of the improvement for each proposed project
This fiscal year staff is recommending the following project list from the City’s Capital Improvement Program (CIP) for RMRA funding; the Local Roads and Streets Program.
Below is a further breakdown of the project.
Local Roads and Streets Program
Project Description: This project will support the City’s Pavement Management Program (PMP). The City’s PMP identifies the street for scheduled slurry seal as a preventative maintenance to extend its useful life. The process includes crack cleaning and sealing, slurry seal application and restriping. This project will utilize rubberized polymer modified slurry for this maintenance work.
Project Location: Palm Shadow Drive, Palm Villa Lane, Desert Park Drive, Skylark Trail, Painted Desert Drive, Purple Hills Road, Azure Hills and Paradise Valley Lane
Project Cost Allocation: $279,306
Proposed Schedule of Completion: The proposed project will start in FY 23-24 and complete construction in December 2023.
City Council Agenda - June 1, 2023
Estimated Useful Life: The estimated life span is estimated to be equal to or greater than 8 years without major repair work required.
The proposed resolution is expected to be acceptable as confirmation that the project list is in fact included in our CIP budget pursuant to a decision made at a regular public meeting. The projects identified in this proposed list are in the proposed FY 23/24 CIP.
FISCAL IMPACT:
In Fiscal Year 2023/24, the City is anticipating receiving an estimated $117,718 in RMRA funds which will support the funding of the Capital Improvement Plan’s annual asphalt program. The project identified is currently proposed projects in the FY 2023/24 CIP program.
ATTACHMENTS:
1. Resolution
2. Projected Fiscal Year Revenues
3. Estimated Maintenance of Effort
City Council Agenda - June 1, 2023
RESOLUTION NO. 2023-
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF INDIAN
WELLS, CALIFORNIA, ADOPTING A PROJECT FOR FISCAL YEAR
2023-2024 FUNDED BY SB 1: THE ROAD REPAIR AND
ACCOUNTABILITY ACT OF 2017
WHEREAS, Senate Bill 1 (SB 1), the Road Repair and Accountability Act of 2017 (Chapter 5, Statutes of 2017) was passed by the Legislature and Signed into law by the Governor in April 2017 to address the significant multi-modal transportation funding shortfalls statewide; and
WHEREAS, SB 1 includes accountability and transparency provisions that will ensure the residents of our City are aware of the projects proposed for funding in our community and which projects have been completed each fiscal year; and WHEREAS, the City must adopt by resolution a list of projects proposed to receive fiscal year funding from the Road Maintenance and Rehabilitation Account (RMRA), created by SB 1, which must include a description and the location of each proposed project, a proposed schedule for the project’s completion, and the estimated useful life of the improvement; and
WHEREAS, the City, will receive an estimated $117,718 in RMRA funding in Fiscal Year 2023-2024 from SB 1; and
WHEREAS, this is the seventh year in which the City is receiving SB 1 funding and will enable the City to continue essential road maintenance and rehabilitation projects, safety improvements, repairing and replacing aging bridges, and increasing access and mobility options for the traveling public that would not have otherwise been possible without SB 1; and
WHEREAS, the City has undergone a public process to ensure public input into our community’s transportation priorities/the project list; and WHEREAS, the City used a Pavement Management System to develop the SB 1 project list to ensure revenues are being used on the most high-priority and cost- effective projects that also meet the community’s priorities for transportation investment; and
WHEREAS, the funding from SB 1 will help the City maintain and rehabilitate streets and roads throughout the City this year and hundreds of similar projects into the future; and
WHEREAS, the 2020 California Statewide Local Streets and Roads Needs Assessment found that the City’s streets and roads are in a “good” condition and this ATTACHMENT #1
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution No. 2023-__
revenue will help us increase the overall quality of our road system and over the next decade will bring our streets and roads into a “excellent” condition; and
WHEREAS, the SB 1 project list and overall investment in our local streets and roads infrastructure with a focus on basic maintenance and safety, investing in complete streets infrastructure, and using cutting-edge technology, materials and practices, will have significant positive co-benefits statewide.
NOW, THEREFORE, the City Council of the City of Indian Wells RESOLVES as follows:
1. The foregoing recitals are true and correct.
2. The project will be funded in-part or solely with fiscal year 2023-2024 Road Maintenance and Rehabilitation Account revenues:
Local Roads and Streets Program
Project Description: This project will support the City’s Pavement Management Program (PMP). The City’s PMP identifies the street for scheduled slurry seal as a preventative maintenance to extend its useful life. The process includes crack cleaning and sealing, slurry seal application and restriping. This project will utilize rubberized polymer modified slurry for this maintenance work.
Project Location: Palm Shadow Drive, Palm Villa Lane, Desert Park Drive, Skylark Trail, Painted Desert Drive, Purple Hills Road, Azure Hills and Paradise Valley Lane
Project Cost Allocation: $279,306
Proposed Schedule of Completion: The proposed project will start in FY 23/24 and complete construction by December 2023.
Estimated Useful Life: The estimated life span is estimated to be equal to or greater than 8 years without major repair work required.
3. The Capital Improvement Program budget for fiscal year 2023-24 includes RMRA funding to be appropriated for the aforementioned program.
NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF INDIAN WELLS RESOLVES AS FOLLOWS:
SECTION 1. The City Council ADOPTS this Resolution approving the fiscal year 2023/2024 road maintenance and rehabilitation account funding allocation.
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution No. 2023-__
SECTION 2. This Resolution shall take effect upon adoption.
PASSED, APPROVED, AND ADOPTED by the City Council of the City of Indian Wells, California, at a regular meeting held on this 1st day of June 2023.
_______________________________
DONNA GRIFFITH
MAYOR
CERTIFICATION FOR RESOLUTION NO. 2023-__
I, Angelica Avila, City Clerk of the City Council of the City of Indian Wells, California, DO HEREBY CERTIFY that the whole number of members of the City Council is five (5) and, that the above and foregoing Resolution was duly and regularly passed and adopted at a regular meeting of the City Council of the City of Indian Wells on the 1st day of June 2023 by the following vote:
AYES:
NOES:
ATTEST: APPROVED AS TO FORM:
___________________________________ ________________________________
ANGELICA AVILA TODD LEISHMAN
CITY CLERK CITY ATTORNEY
City Council Agenda - June 1, 2023
ATTACHMENT B
Local Streets and Roads - Projected FY2023-24 Revenues
Based on State Dept of Finance statewide revenue projections Estimated January 2023 TOTAL Road Mntnc
Sec2103 (5)Sec2105 (3)Sec2106 (3)Sec2107 (3)Sec2107.5 (4)HUTA Rehab Acct TOTALHighway Users Tax Acct (HUTA)(1) Streets & Highways Code
PLACER COUNTY
AUBURN 136,560 90,431 61,709 108,619 3,000 400,320 340,670 740,989 COLFAX 20,235 13,400 13,233 16,095 1,000 63,962 50,479 114,440 LINCOLN 507,873 336,315 216,447 403,959 6,000 1,470,594 1,266,962 2,737,556 LOOMIS 67,522 44,713 32,939 53,707 2,000 200,881 168,444 369,325 ROCKLIN 710,132 470,252 300,735 564,835 7,500 2,053,454 1,771,526 3,824,981 ROSEVILLE 1,496,646 991,083 628,501 1,190,423 10,000 4,316,653 3,733,596 8,050,249
PLUMAS COUNTY
PORTOLA 20,810 13,780 9,077 130,102 1,000 174,769 51,913 226,681
RIVERSIDE COUNTY
BANNING 305,970 202,614 130,037 243,367 6,000 887,989 763,287 1,651,276 BEAUMONT 541,941 358,875 226,623 431,057 7,500 1,565,996 1,351,950 2,917,946 BLYTHE 184,175 121,961 80,185 146,492 5,000 537,812 459,450 997,263 CALIMESA 108,002 71,519 49,006 85,904 2,000 316,431 269,426 585,857 CANYON LAKE 109,686 72,635 49,696 87,244 3,000 322,261 273,628 595,889 CATHEDRAL CITY 513,700 340,173 215,064 408,594 7,500 1,485,030 1,281,497 2,766,527 COACHELLA 417,758 276,640 175,793 332,282 6,000 1,208,473 1,042,156 2,250,629 CORONA 1,553,565 1,028,775 640,693 1,235,696 10,000 4,468,729 3,875,589 8,344,319 DESERT HOT SPRINGS 322,737 213,717 136,900 256,703 6,000 936,058 805,113 1,741,171 EASTVALE 692,950 458,873 288,433 551,168 7,500 1,998,923 1,728,662 3,727,585 HEMET 888,332 588,256 368,405 706,574 7,500 2,559,066 2,216,070 4,775,137 INDIAN WELLS 47,188 31,248 24,115 37,533 2,000 142,084 117,718 259,802 INDIO 883,288 584,916 366,340 702,562 7,500 2,544,606 2,203,488 4,748,094 JURUPA VALLEY 1,044,285 691,528 432,238 830,618 10,000 3,008,670 2,605,118 5,613,787 LAKE ELSINORE 709,657 469,937 295,271 564,457 7,500 2,046,821 1,770,340 3,817,161 LA QUINTA 375,167 248,437 158,361 298,406 6,000 1,086,370 935,908 2,022,279 MENIFEE 1,056,602 699,685 437,280 840,415 7,500 3,041,482 2,635,845 5,677,327 MORENO VALLEY 2,075,083 1,374,126 854,157 1,650,508 10,000 5,963,874 5,176,591 11,140,465 MURRIETA 1,101,749 729,581 455,759 876,324 10,000 3,173,414 2,748,470 5,921,884 NORCO 264,173 174,936 112,929 210,121 6,000 768,159 659,017 1,427,176 PALM DESERT 504,276 333,933 211,206 401,098 7,500 1,458,013 1,257,988 2,716,001 PALM SPRINGS 439,945 291,333 184,875 349,929 6,000 1,272,081 1,097,504 2,369,585 PERRIS 781,747 517,675 324,779 621,797 7,500 2,253,498 1,950,180 4,203,677 RANCHO MIRAGE 166,516 110,268 72,957 132,446 4,000 486,187 415,399 901,586 RIVERSIDE 3,149,651 2,085,708 1,293,990 2,505,213 10,000 9,044,562 7,857,254 16,901,816 SAN JACINTO 540,980 358,239 226,230 430,292 7,500 1,563,241 1,349,552 2,912,793 TEMECULA 1,089,283 721,326 450,657 866,409 10,000 3,137,676 2,717,372 5,855,048 WILDOMAR 363,871 240,956 153,737 289,420 6,000 1,053,984 907,727 1,961,711 18 January 2023 CaliforniaCityFinance.com Page 10 of 16 ATTACHMENT #2 Page 245 of 359
City Council Agenda - June 1, 2023
Maintenance of Effort - General Fund for Streets & Roads - Esti mated Unofficial Road Maintenance and Rehabilitation Account per Streets & Hwys Code Sec 2036 1 revised est: 08/07/2017 Streets and Roads Annual Report - Reported General Fund for Street Purposes FY2009-10 FY2010-11 FY2011-12 Average Adjustment RMRA M.O.E.
PLACER COUNTY
AUBURN 618,097 552,860 307,564 492,840 492,840
COLFAX 0 0 1,176 392 392
LINCOLN 0 0 0 0 0
LOOMIS 0 0 0 0 0
ROCKLIN 161,531 513,070 628,776 434,459 434,459
ROSEVILLE 4,262,137 6,038,474 6,835,903 5,712,171 5,712,171
PLUMAS COUNTY
PORTOLA 146,671 184,184 128,542 153,132 153,132
RIVERSIDE COUNTY
BANNING 316,181 38,587 133,164 162,644 162,644
BEAUMONT 0 586,825 1,552,970 713,265 713,265
BLYTHE 261,196 1,076,032 445,295 594,174 594,174
CALIMESA 77,232 64,501 0 47,244 47,244
CANYON LAKE 41,009 26,318 25,798 31,042 31,042
CATHEDRAL CITY 1,033,190 574,077 1,080,111 895,793 895,793 COACHELLA 1,802,424 2,375,264 1,929,366 2,035,685 2,035,685 CORONA 3,424,971 2,989,106 2,986,573 3,133,550 3,133,550 DESERT HOT SPRINGS 435,933 369,337 370,783 392,018 392,018 EASTVALE (inc. 1 Oct 2010)n/a see notes below see notes below 59,787 4 59,787 HEMET 18,924 0 9,462 9,462
INDIAN WELLS 1,075,582 1,115,139 3,318,722 1,836,481 1,836,481 INDIO 4,648,594 2,075,668 2,383,136 3,035,799 3,035,799 JURUPA VALLEY (inc. 1 July 2 n/a see notes below see notes below 0 4 0 LAKE ELSINORE 1,198,185 1,367,576 1,165,691 1,243,817 1,243,817 LA QUINTA 2,798,095 1,031,556 1,590,929 1,806,860 1,806,860MENIFEE00000 MORENO VALLEY 1,600,807 1,506,617 2,119,479 1,742,301 1,742,301 MURRIETA 785,317 1,510,212 1,660,517 1,318,682 1,318,682 NORCO 78,660 26,269 12,036 38,988 38,988
PALM DESERT 5,346,951 4,688,794 4,566,328 4,867,358 4,867,358 PALM SPRINGS 4,243,162 4,274,880 4,578,581 4,365,541 4,365,541 PERRIS 235,180 907,323 307,663 483,389 483,389
RANCHO MIRAGE 1,815,441 3,458,223 3,506,707 2,926,790 2,926,790 RIVERSIDE 18,039,443 17,447,014 17,333,720 17,606,726 17,606,726 SAN JACINTO 543,637 735,080 730,303 669,673 669,673
TEMECULA 3,228,915 2,875,767 2,854,016 2,986,233 2,986,233 UPDATED 7 August 2017 CaliforniaCityFinance.com
E S
T
I
M
A
T
E
D
U N O
F
F
I
C
I
A
L
City Council Agenda - June 1, 2023
Maintenance of Effort - General Fund for Streets & Roads - Esti mated Unofficial Road Maintenance and Rehabilitation Account per Streets & Hwys Code Sec 2036 1 revised est: 08/07/2017 Streets and Roads Annual Report - Reported General Fund for Street Purposes FY2009-10 FY2010-11 FY2011-12 Average Adjustment RMRA M.O.E.
PLACER COUNTY
AUBURN 618,097 552,860 307,564 492,840 492,840
COLFAX 0 0 1,176 392 392
LINCOLN 0 0 0 0 0
LOOMIS 0 0 0 0 0
ROCKLIN 161,531 513,070 628,776 434,459 434,459
ROSEVILLE 4,262,137 6,038,474 6,835,903 5,712,171 5,712,171
PLUMAS COUNTY
PORTOLA 146,671 184,184 128,542 153,132 153,132
RIVERSIDE COUNTY
BANNING 316,181 38,587 133,164 162,644 162,644
BEAUMONT 0 586,825 1,552,970 713,265 713,265
BLYTHE 261,196 1,076,032 445,295 594,174 594,174
CALIMESA 77,232 64,501 0 47,244 47,244
CANYON LAKE 41,009 26,318 25,798 31,042 31,042
CATHEDRAL CITY 1,033,190 574,077 1,080,111 895,793 895,793 COACHELLA 1,802,424 2,375,264 1,929,366 2,035,685 2,035,685 CORONA 3,424,971 2,989,106 2,986,573 3,133,550 3,133,550 DESERT HOT SPRINGS 435,933 369,337 370,783 392,018 392,018 EASTVALE (inc. 1 Oct 2010)n/a see notes below see notes below 59,787 4 59,787 HEMET 18,924 0 9,462 9,462
INDIAN WELLS 1,075,582 1,115,139 3,318,722 1,836,481 1,836,481 INDIO 4,648,594 2,075,668 2,383,136 3,035,799 3,035,799 JURUPA VALLEY (inc. 1 July 2 n/a see notes below see notes below 0 4 0 LAKE ELSINORE 1,198,185 1,367,576 1,165,691 1,243,817 1,243,817 LA QUINTA 2,798,095 1,031,556 1,590,929 1,806,860 1,806,860MENIFEE00000 MORENO VALLEY 1,600,807 1,506,617 2,119,479 1,742,301 1,742,301 MURRIETA 785,317 1,510,212 1,660,517 1,318,682 1,318,682 NORCO 78,660 26,269 12,036 38,988 38,988
PALM DESERT 5,346,951 4,688,794 4,566,328 4,867,358 4,867,358 PALM SPRINGS 4,243,162 4,274,880 4,578,581 4,365,541 4,365,541 PERRIS 235,180 907,323 307,663 483,389 483,389
RANCHO MIRAGE 1,815,441 3,458,223 3,506,707 2,926,790 2,926,790 RIVERSIDE 18,039,443 17,447,014 17,333,720 17,606,726 17,606,726 SAN JACINTO 543,637 735,080 730,303 669,673 669,673
TEMECULA 3,228,915 2,875,767 2,854,016 2,986,233 2,986,233 UPDATED 7 August 2017 CaliforniaCityFinance.com
E S
T
I
M
A
T
E
D
U N O
F
F
I
C
I
A
L
ATTACHMENT #3 Page 247 of 359
City Council Agenda - June 1, 2023
INDIAN WELLS CITY COUNCIL
June 1, 2023
To: City Council
From: Finance Department
Prepared by: Ruby D. Walla, Assistant Finance Director
Subject: City Treasurer’s Report for April 2023
RECOMMENDED ACTION:
Council RECEIVES and FILES the City Treasurer’s Report for April 2023.
DISCUSSION:
Attached are the monthly cash balance and investment reports for April 2023.
Investments reflected in this report are “Marked-to-Market,” meaning the market value of the City’s investments is updated monthly. This method provides a clear depiction of the City’s portfolio’s value subject to the investment market’s performance . As a result, the City of Indian Wells maintains prudent fiscal reserves and minimizes un-invested cash.
Cash and Investments
As of April 30, 2023:
The City’s cash and investments totaled $85,873,804.75 The City’s portfolio earned a 1.965% rate of return.
Treasurer’s Certification
Compliance - The City Treasurer certifies that the City’s cash and investments presented in this Report comply with the City’s investment policy and with the legal requirements of the State of California Government Code section 53600.
Liquidity - The City Treasurer certifies that the City’s portfolio is sufficient to meet its financial obligations for the next six months. The investment portfolio will remain sufficiently liquid to meet all operating requirements, which might be reasonably anticipated. This is accomplished by striving to have securities mature while cash is needed to meet anticipated demands (static liquidity). Additionally,
City Council Agenda - June 1, 2023
since all possible cash demands cannot be anticipated, the portfolio consists mainly of securities with active secondary or resale markets (dynamic liquidity).
Fiscal Prudence
When investing, reinvesting, purchasing, acquiring, exchanging, selling, or managing public funds, a trustee shall act with care, skill, prudence, and diligence under the circumstances then prevailing, including, but not limited to, the general economic conditions and the anticipated needs of the City, that a prudent person acting in a like capacity and familiarity with those matters would use in the conduct of funds of a like character and with like aims, to safeguard the principal and maintain the liquidity needs of the City.
Background
Staff provides Council with a monthly update to the Treasurer’s Report. The Report presents the City’s cash activity and investment portfolio and includes a reconciliation between investment balances and General Ledger. Specifically, the report provides information on the types of investments, dates of maturities, costs, the updated market value of securities, and rates of interest earned in the portfolio.
The City maintains a written investment policy in compliance with legal requirements of Government Code section 53600 and governs the investments made by the City. It is the policy of the City of Indian Wells to invest public funds in a manner that will provide maximum security with the highest investment return while meeting the daily cash flow demands of the City. Therefore, the investments purchased by the City are consistent with the City’s investment policy and are allowable under the current legislation of the State of California.
The City invests in U.S. treasuries, federal agency securities, medium-term corporate notes, municipal bonds, federally insured certificates of deposit, and overnight cash investments. Criteria for selecting investments in the order of priority are (1) safety, (2) liquidity, and (3) yield.
ATTACHMENTS:
1. City Treasurer’s Report
City Council Agenda - June 1, 2023
NET CASH & INVESTMENT SUMMARY APRIL 2023
16,530,184.82
April
2022
$ 12,819,879.36
L2$19,879.36
April
2023UNRESTRICTED FUNDS
GENERAL FUND
101- GENERAL
TOTAL GENERAL FUND
RESTRICTED FUNDS
SPECIAL REVENUE FUNDS
202 - TRAFFIC SAFETY
203 - PUBLIC SAFETY 1/2 CENT SALES TAX
204 - MEASURE ''AU
209 - F.A.M.D. #1
210 - SCAQMD (VEHICLE REG.)
, 2LL - A83229 COPS FUNDING
214 - GAS TAX 2103 MAINTENANCE
215 - GAS TAX 2105 MAINTENANCE
216 - GAS TAX 2106 CONSTRUCT/MAINT
217 . GAS TPX.2TO7 MAINTENANCE
218 - GAS TAX 2107.5 ENG./ADMIN
219 - GAS TAX RMRA
228 - EMERG. UPGRADE SERVICES
247 - AB 939 RECYCLING FUND
248 - SOLID WASTE
251 - STREET LIGHTING DISTRICT 2OOO-1
253- INDIAN WELLS VILLAS OPERATIONS
254- MOUNTAIN VIEW VILLAS OPERANONS
256- HOUSING AUTHORITY
271 - ELDORADO DRIVE LLMD
272 - MONTECITO/STARDUST LLMD
273 - CASA DORADO LLMD
274 -THE COVE LLMD
27s - SH lll/IWGR (ENTRANCE) LLMD
276 - CLUBIIW LANE LLMD
277 . COLONY LLMD
278 . COLONY COV ESTATES LLMD
279 - DESERT HORIZONS LLMD
2BO - MOUNTAIN GATE LLMD
281 - MOUNTAIN GATE ESTATES LLMD
282 - VILI.AGIO LLMD
283 - VAIDYA LLMD
284 - CLUB, SOUTH OF 111 LLMD
285 - MONTELENA LLMD
286 - SUNDANCE LLMD
287 - PROVINCE LLMD
2BB - PROVINCE DBAD
TOTAL SPECIAL REVENUE FUNDS
CAPITAL PROJECT FUNDS
310 - PARK FACILITIES FEES
311 - TMNSPORTATION FACILITIES FEES
313 - RECREATION FACILITIES FEES
314 - PARK.IN-LIEU FEES
315 - CITYWIDE PUBLIC IMPROVEMENT FEE
316 - CAPITAL IMPROVEMENT
319 - ART IN PUBLIC PI-ACES
321 - HIGHWAY 111 CIRCUI.ATION IMP FEE
TOTAL CAPITAL PROJECT FUNDS
T:\Common\bank\Treasurer's Report\Cash 1 0Apr 23
$ 16,530,184.82
r0,079.43
L7,038.29
120,98L.42
r,393,43r.64
L4,037.38
49,796.4L
rr,702.75
9,100.91
7,316.58
11,930.13
0.00 90,953.57
5,088,197.27
345,642.33
156,409.69
15,594.00
1,660,554.81
2,698,291.54
LL,649,2r0.73
63,775.07
6,837.92
1,313.21
r,40L.49
L29,939.85
19,288.60
83,352.82
52,613.08
688.25
96,864.03
47,152.40
240,507.34
35,495.01
30,066.52
78,402.65
L,437.74
101,371.39
ss8.979.93
845.62
3,599.97
3,083.69
1,959,135.66
13,20L.2r
3.00 0.00
0.00 0.00
0.00 333.33
322,065.86
3,866,399.91
47L,247.75
233,234.90
L4,396.84
L,4OL,746.BL
2,186,33r.54
L4,164,477.70
63,948.34
7,088.94
1,360.20
r,442.05
6r,444.27
15,25L.49
96,069.73
60,298.05
L7,L49.43
L04,587.75
54,960.24
28r,059.L7
38,257.t5
28,669.31
83,981.46
r,467.15
99,485.78
586.532.79
24,899,756,L8
14,818.00
0.00 0.00
88,529.45
0.00 5,478,949.29
466,590.L2
26,243,157.O9
0.00 0.00
0.00 0.00
149,533.00
5,022,094.r9
277,920.68
3 7.208.70 4 160.70
5A53,708.576,086,095.56
10:59 AMs/25l2023ATTACHMENT #1 Page 250 of 359
City Council Agenda - June 1, 2023
CITY OF INDIAN WELLS
NET CASH & INVESTMENT SUMMARY APRIL 2023
PAGE 2
RESTRICTED FUNDS (Cont.)
REPLACEMENT FUNDS
326 - BUILDINGS CAPITAL RESERVE
327 - BRIDGES CAPITAL RESERVE
328 - MEDIANS & PARKWAYS CAPITAL RESERVE
329. STORM DRAINS CAPITAL RESERVE
330 . TRAFFIC SIGNALS CAPITAL RESERVE
331 - TECHNOLOGY CAPITAL RESERVE
332 - CITY STREETS CAPITAL RESERVE
333 - CITY VEHICLES CAPITAL RESERVE
350 - DISASTER RECOVERY RESERVE
TOTAL REPLACEMENT FUNDS
SUCCESSOR AGENCY FUNDS
453 - DEBT SERVICE
456 . RDA OBLIGATION RENREMENT
460 - INDIAN WELLS FINANCING AUTHORITY
TOTAL SUCCESSOR AGENCY FUNDS
ENTERPRISE FUNDS
560 - INDIAN WELLS GOLF RESORT
TOTAL ENTERPRISE FUNDS
INTERNAL SERVICE FUNDS
601 - OPEB BENEFIT FUND
TOTAL INTERNAL SERVICE FUNDS
RESERVE FUNDS
602 - COMPENSATED ABSENCES
TOTAL RESERVE FUNDS
TRUST &AGENCY FUNDS
732 . SPECIAL DEPOSITS
TOTAL TRUST & AGENCY FUNDS
TOTAL ALL FUNDS
FISCAL AGENTS
253 - INDIAN WELLS VILLAS
254 - MOUNTAIN VIEW VILI.AS
453 - US BANK TRUSTEE - SUCCESSOR AGENCY DEBT SERVICE
460 - US BANK - INDIAN WELLS FINANCE AUTHORITY
560 - INDIAN WELLS GOLF RESORT
601 - PARS SEfiON 115 TRUST - PENSION
601 - PARS SECTION 115 TRUST - OPEB
TOTAL FISCAL AGENTS
TOTAL ALL FUNDS & FISCAL AGENTS
UNRESTRICTED FUNDS
RESTRICTED FUNDS
April
2023
April
2022
1,992,511.80
L,79r,7L8.00
L,426,25r.07
720,432.00
591,375.00
540,147.00
L9,654,062.00
r23,879.00
292.L29.00
1,759,893.80
1,809,625.00
L,440,405.07
727,374.00
597,733.00
545,871.00
19,848,108.00
L25,24r.00
0.00 27,132,504.87
5,162,003.00
0.00 277.98
26,854,25O.87
8,383,632.81
0.00 0.00
5,162,280.98
2 910 603.19
2,910,603.19
8,383,632.81
T,487,662.67
r,487,662.67
L,7L9,298.L5 282 939.78
L,7L9,298,L5 282,939.78
581,403.00 512.512.00
581,403.00
851 678.00
851,678.OO
8s.873.804.75
-
r87,867.52
435,768.29
1,188,886.55
LL,228,274.3L
962,883.87
864,656.65
209 863.03
L5,O78,2OO.22
923 447.06
923447.06
83,061,190.21
528,636.31
L,ll2,052.BL
17.69 0.00
1,569,906.33
862,160.04
0.00 4,O72J73.L8
6t2,5r2.OO
$ LOO,952,OO4,p7
15,530,184.82
84,42 1,820.15
$87 963.39
L2,8L9$79.36
74,3L4,O84.O3
$ 87,133,963.39ffiT:\Common\bank\Treasurer's Report\Cash 1 oApr 23 $ 100.952,004.97 Page 251 of 359
City Council Agenda - June 1, 2023
Tlcmmonhnkbank tsonciliabon Iy23U023_M RPT,AF Bant RsAgil 23 pdld 11.05AM 512512023 Bank Reconciliation Report - CiW Held Cash
Finance Depadment
City n
473
480M
/r83
498
499
501
512
513
514
515
515
5L7
518
519
s20
521
s22
525
5,r8
550
557
558
561
552
574
573
s75
524
s26
s33
538
549
556
570
527
529
530
532
534
535
536
s39
541
542
544
546
551
552
553
554
555
559
560
s53
s65
564
s66
s67
558
559
57t
572
s37
531
117
Paciflc Western Bank - Accts. Pavable **-**3411
Paciflc Western Bank - Pavroll *x-**1752
Paciflc Western Bank - Ambulance **-****7937
Pacific Western Bank - Public Funds l4MA **-***x5064
union Bank of CA - SweD Investment ***-***0121
US Bank Money Market - Investment
US Bank l4oney Market - 4590
US Bank Nlonev Market - 4591
PetW Cash
Assm.
1 2
3 6
7 4
8 9
10 19
2t
0.00 0.00
0.00 15,180.77
0.00 0.00
4,L74,543.27
18,759.41
2,000.00
(602.114.8s)
5,704.47
r47,738.72
8,485.45
1,000,000.00
2,000,000.00
r,000,420.47
2.000,000.00
1.000,000.00
1.000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000.000.00
2,000,000,00
1,000,000.00
2,000,000.00
2.000,000.00
2,000,000.00
2,000,000.00
3,000.000.00
1,000,000.00
1,000,000.00
1.000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1.700,000.00
1.000,000.00
1,000,000.00
1,000,000.00
Cf,rtitidtsofDeDosit , . .- :t-xg 248,000.00
Certificte of Deoosit-Discover Bank 254673U18 250.000 00 Certifimte of Deoosit-Comeniw Capital Bank 20033AM86 250.000.00 Certificate of Deposit-UsB Bank USA 9O348JFF2 250,000.00 Certificate of Deposit-RlA Federal Credit Union749622ALO 249,000.00 Certificate of Deposit-Capital One Bank 14042TAY3 247 '000.00 Certificate of Deposit-Bankwest O6652CHA2 249,000.00
Certificate of D€posit-BMW Bank North America 05580AVX9 250,000.00 CertificateofDeposit-NicoletNationBanR6S4062Jz2 250'000.00 Certificate of Deposit-Live Oak Bankinq Companv 538036111 250'000.00 Certificate of Deposit-Alma Bank O20O80BX4 250.000.00
Certificate of Deposit-State Bank of India 856285TF8 248,000 00 Certificte of Deposit-First Natl Bank of Mccre{or TX 32 1 12UDF 249,000 00 Certificate of Demsit-Centerstate Bank l520lQDE4 248,000 00 CertifiGte of DeDosit-Northwest Bank 66736A8V0 249,000.00 Certificate of DeDosit-Encore Bank 29260M8E4 249,000.00 Certificate of DeDosit-First Freedom Bank 320278AM9 249,000.00 Certificate of Deoosit-Pacific Western Bank 69506YR15 248,000.00 Certificate of Deoosit-Bank of Baroda 06063HN1S9 249'000 00 Certificate of Deposit-Toyota Financial Sqs Bank 89235MKY6 250.000 00 Certificate of Deposit-Grenstate credit Union 395731811 250.000 00 Certiflcate of Degosit-Pentaqon Federal Credit Union 70962LASI 249.000.00 Certificate of Deposit-Nelnet Bank, Inc 64034KAG6 250,000.00 CertifiGte of Deposit-Beal Bank 07371AYE7 250.000.00
Certificate of Deposit-Beal Bank USA 07371CE88 250,000.00 CertifiGte of Deposit-Austin Telco Fed Credit Union 0523928T3 250,000.00 certificte of Deposit-capital one NA 14042RUJ8 250,000.00 certificate of Deoosit-Svnchronv Bank 87164XR65 250.000.00 MediumTermCorDorateNots - ...--.. - --.---1,007,542 58
Montebello CA Pens Obliq M 612285AE6 1.034,087.80
Jp ltorqan Chas Bank NA 46632FRU1 2,000,000.00
Jp Morqan Chase 48128G2e2 1,000,000.00
Bank of America MTN 06048WM31 1,000.000,00
Bank of America MTN O6O48WM72 1,000.000 00
Citiqroup Global MKs 17330PJ83 2.000,000.00
Fed. Farm Credit Bank 3133E1280
Fed. Home LGn Mtq Corp 3134GWCG9
Fed. Nafl llortqaqe Assc 3135GA223
Fed. Farm Credit Bank 3130AL351
Fed. Farm Credit Bank 3130A16G4
Fed. Farm Credit Bank 3130A16J8
Fed. Farm Credit Bank 3130ALDN1
Fed. Farm Credit Bank 3130ALHZ0
Fed. Farm Credit Bank 3130AU62
Fed, Farm Credit Bank 3130A1MF13
Fed. Farm Credit Bank 3130A1W67
Fed. Farm Credit Bank 3130AMW57
Fed. Farm Credit Bank 3133E[4H21
Fed. Farm Credit Bank 3133E[4167
Fed. Farm Credit Bank 3133EMN99
Fed. Farm Credit Bank 3133EMW73
Fed. Home L€n Bank 3130AQWF6
Fed. Home L@n Bank 3130AQWJ8
Fed. Home Loan Bank 3130AQ255
Fed. Home LGn Bank 3130ARCV1
Fed. Home Loan Mtq CorP 313'IGXMX9
Fed. Home L@n Bank 3130ARGE5
Fed. Home LGn Mtq Corp 3134GXQP2
Fed. Home Loan Bank 3130A5320
Fed. Home Loan Bank 3134GXUM4
Fed. Home Loan Bank 3130A5567
Fed. Home Loan Bank 3130ASS91
M".1ffi
Natomas CA Schml District 63877NN1M6 300,000.00
Total P@led Cash and Inv6tments
Fair Value Incras (over cost)
Rsonciled Bank Balance
41,
(3,825,764.49\
$ 85,873,804.75
items Outstandinq Watrants/Wire Transfers
Outstandino Pavroll Warrants/Wire Transfers
Outstandinq Outqoinq ACH Pavments
Credit card in Transit
Investment N4aturiw in Transit
Outstandinq ltems
City Council Agenda - June 1, 2023
ELLSW
i-. t.-
INDIAN i,,
City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA'92210
(760)346-2489CALIFORN IA
lnvestments
Bank Certificates of Deposit
Managed Pool Accounts - LAIF
Money Market Sweep/Checking Account
Negotiable CD's
Medium Term Corporate Notes
Federal Agency Issues - Callables
Miscellaneous Securities - Coupon
lnvestments
Total Earninqs
Current Year
Average Daily Balance
Effective Rate of Return
Reporting period 04/01 /2023-0413012023
Par
The Gity of lndian Wells
Portfolio Management
Portfolio Summary
April30, 2023
Market Book
V.llre
248,000.00
24,390,418.80
6,224,600.56
6,733,000.00
9,041,630.38
41,700,420.47
801,685.24
%of
Portfolio
Days to
Maturity
611
360 Equiv.355 Equiv.Telm
Aoril 30 llllonth
Value
248,000.00
24,390,418.80
6,224,600.56
6,733,000.00
9,000,000.00
41,700,000.00
800,000.00
89,096,019.36
Ending
142,O32.00
87,',t74,877.98
1.98%
246,968.32
24,390,418.80
6,224,600.56
6,319,441 .70
8,256,160.00
38,668,551.00
752,608.00
84,858,748.38
Fiscal Year To Date
1,078,574.99
0.28 27.36
6.98 7.55
10.14 46.78
0.90 1,826
1 1
1,791
i,495
1,649
1,445
3.107
2.831
3.256
1.677
1.556
1.361
0.653
1.938
3.1 50
2.870
3.301
1.700
1.578
1.380
0.662
80 1
'l
417
774
994
595
89,139,755.45 100.00% 1,077 1.965
Portfolio CITY
AP
PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
The investments are consistant with the City's investment policy and allowable under current legislation of the State of California. lnvestments were purchased using safety, liquidity, and yield as ition, cash flow from revenue and maturing investments will be sufficient to cover expenditures for the next six months. All securities are "Markedto-Market" on a monthly basis.
Director
Run Date: 05/2312023 - 18:36
City Council Agenda - June 1, 2023
CUSIP lnvestment #lssuer
Bank Certificates of Deposit
321 1 0YLK9 473 First National Bank of America
Subtotal and Average
Managed Pool Accounts - LAIF
SYS21 21 LAIF - CitY
SYS23 23 LAIF - Redevelopment
Subtotal and Average
Money Market Sweep/Checking Account
Average
Fl.l.nca
548,000.00
22,817,73A.79
4,464,861.24
07to1t2022
07t01t2022
08t30t2022
08t30t2022
07t01t2022
0710112022
07t0112022
0710112022
o3t31t2020
09t2112022
07t22t2020
07t26t2019
oztnn022
02t2312022
03t31t2020
0711812019
09t21t2022
04130n020
1013012018
10to3t2014
2,014,117.1'l
0.00 15,180.77
0.00 't8,759.41
4,174,543.27
0.00 0.00
0.00 2,000.00
0.00 2,014,117.11
0.00 15,180.77
0.00 18,759.41
4,174,543.27
0.00 0.00
0.00 2,000.00
0.00 2,014,117.1'l
0.00 15,180.77
0.00 18,759.41
4,'174,543.27
0.00 0.00
0.00 2,000.00
0.00 The City of lndian Wells
Portfolio Management
Portfolio Details - Investments
April30, 2023
Purchase
Date Par Value
07t20t2018 248,000.00
248,000.00
24,390,418.80
0.00 24,390,418.80
Market value
246,968.32
246,968.32
24,390,418.80
0.00 24,390,418.80
Stated
BookValue Rrte
248,000.00 3.150
248,000.00
Page I
YTM Days to Maturity
360 Maturitv Date
3.'t07 80 07t20t2023
3.107 80
Fitch
24,390,418.80
0.00 24,390,418.80
2.870
o 233
2.831
0.230
SYSl
SYS6
SYST
SYSs
SYSlO
SYS9
sYs2
SYS3
SY54
SYS19
sYs5
0.250
2.930
4.740
4.770
2.831
3.256
o.247
0.000
2.890
0.000
4.675
4.705
0.000
0.000
0.197
0.000
0.000
'1
6 7
o
10 9
2 ?
4 19
5 515
574
525
501
561
562
512
499
573
518
484
480
Pacific Western Bank
Pacific Western Bank-Ambulance
Pacifi c Western-Pu blicFundsM MA
US Bank Money Market
US Bank Money Market-4sg1
US Bank Money Market-4590
Pacific Western - Acct Payable
Pacifi c Western-Payroll
Union Bank-Checking
Petty Cash
V1/estAmerica Bank
Subtotal and Average
0.200
Negotiable CD's
0200808X4
0523928T3
06063HMS9
06652CH42
07371AYE7
07371 CE88
05580AVX9
14042rAY3
14042RUJ8
15201QDE4
20033AM86
254673U18
Alma Bank
Austin Telco Fed Credit Union
Bank of Baroda
Bankwest lnc.
Beal Bank - Plano TX
Beal Bank USA
BMW BANK NORTH AMERICA
Capital One Bank USA NA
Capital One NA
Centerstate Bank NA
Comenity Capital Bank
Discover Bank
5,224,600.56
250,000.00
250,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
247,000.00
250,000.00
248,000.00
250,000.00
250,000.00
6,224,600.s6
233,672.50
239,625.00
226,664.70
240,292.47
224,405.00
224,405.00
234,352.50
239,834.53
240,670.OO
230,46't.44
24A,205.00
24A,252.50
6,224,600.55
250,000.00
250,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
247,000.00
250,000.00
248,000.00
250,000.00
250,000.00
1.400
3.800
0.700
2.000
1.900
1_900
1.550
2.300
3.900
1.250
3.450
3.300
1.380
3.748
0.690
1.973
1.874
1.874
1.529
0.000
0.000
1.233
3.403
3.255
697
1,604
813
452
'1,388
1,388
700
422
1,604
730
182
155
03t28t2025
0912112027
07t22t2025
0712612024
0217t2027
0211712027
0313112025
06t2612024
o9t21t2027
04t3012025
10t30t2023
1010312023
Portfolio CITY
AP
PM (PRF-PM2) 7.3.0Run Date: 05/2312023 - 18:36
Report Ver. 7.3.6.1Page 254 of 359
City Council Agenda - June 1, 2023
The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
April 30,2023
Purchase
Dala Par Value
Stated
Book Value p.ra Fitch
Page2
YTM Days to Maturity
Negotiable CD's
29260MBE4
32027B'AM9
321 12UDR9
395731B11
538036104
64034KAG6
654062J22
667364BVo
69506YR15
70962LASl
749622ALO
856285TF8
87164XR65
89235MKY6
90348JFF2
CUSIP
06048VV1431
06048\ /M72
06406RAN7
17330PJ83
48128G2Q2
46632FRU1
61 22854E6
lnvestment #
Medium Term Corporate Notes
549
556
524
570
538
533
526
lssuer
ENCORE BANK
First Freedom Bank
First Natl Bank of Mccregor TX
Greenstate Credit Union
Live Oak Banking Company
Nelnet Bank, lnc.
Nicolet National Bank
Northwest Bank
Pacific Western Bank CA CD
Pentagon Federal Credit Union
RIA Federal Credit Union
State Bank of lndia NY, NY CD
Synchrony Bank
Toyota Financial Sgs Bk
UBS Bank USA
Subtotal and Average
Bank of America MTN A
Bank of America MTN A
Bank of New York Mellon Corp
Citigroup
JPMorgan Chase & Co
JP Morgan Chase Bank NA
Montebello CA Pens Oblig AA
Subtotal and Average
520
521
517
550
514
ssa
5't 3
510
s22
s6;
408
516
575
548
483
Average
6,733,000.00
10,009,109.47
04t3012020
04t30t2020
0412812020
06t1612021
0313112020
02t02t2022
o3t31t2020
04t30t2020
0413012020
09t29t202'l
0612412019
04129t2020
09t23t2022
04122t202'l
1013012018
051281202'l
0713012021
05t1412020
07t29t2022
0212612021
01t22DO2'l
07t17t2020
249,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
250,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
250,000.00
250,000.00
250,000.00
6,733,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
9,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
Market Value
239,923.95
239,801.94
231,736.83
220,760.OO
233,560.00
221,292.50
233,582.50
230,979.87
230,461.44
217,643.43
245,'t35.52
232,118.08
241,150.00
222,157.50
248,297.50
6,319,441.70
873,320.00
8s6,790.00
940,680.00
1,986,780.00
887,830.00
1,758,860.00
951,900.00
8,255,160.00
1,843,520.00
1,808,280.00
1,801,440.00
1,8s3,740.00
2,705,700.00
906,250.00
905,120.00
249,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
250,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
250,000.00
250,000.00
250,000.00
6,733,000.00
'l,000,000.00
1,000,000.00
1,O07,542.54
2,000,000.00
1,000,000.00
2,000,000.00
1,034,087.80
9,041,630.38
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
1.677 817
0413012024
0413012024
04t2812025
06h6n026
03t3112025
02t02t2027
03t3112025
o4ROt2025
04t30t2025
09t29t2026
1212612023
04129no25
0912312027
04t22t2026
10t27t2023
05t28t2026
07t30t2026
04t24t2025
07t29t2023
0212612026
o'v22t2026
06t01t2025
07t29t2025
06t15t2026
0612212026
0613012025
0712812026
02t1712026
0212512026
1.150
1.100
1.350
0.900
1.400
1.500
1.400
'l.200
1.250
0.900
2.500
1.600
3.950
0.900
3.500
1.250
1.200
1.600
3.800
0.800
0.700
2.503
0.580
0.900
0.800
0.740
0.870
0.625
0.600
1.135
1.086
1.332
0.888
't.382
1.479
1.3A2
1.'184
1.233
0.888
2.468
1.578
3.896
0.888
3.454
1.233
1.184
'1.190
3.720
0.789
0.690
0.819
365
365
728
1,'142
700
1,373
700
730
730
1,247
239
729
1,606
1,087
179
1,123
1,186
724
89 1,032
997
762
820
1,141
1,148
791
1,'184
1,O23
1,031
1.555 778
Federal Agency lssues - Callables
3133E1280
31 33EMH21
31 33EML67
3133EMN99
3133EMW3
31 30AL3S1
31 30AL6G4
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bani<
Fed. Home Loan Bank
Fed. Home Loan Bank
529
552
553
554
555
534
535
0712912020
0611712021
0612212021
06t30t2021
07t2812021
0?r'17t2021
o2t25t2021
0.572
0.888
0.789
0.730
0.858
0.616
0.592
Portfolio CITY
AP
PM (PRF_PrVr2) 7.3.0Run Date: 052312023 - 18:36
City Council Agenda - June 1, 2023
The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
April30, 2023
Purchase
Dale Par Value
Stated
Book Value P.rA Fitch
YTM Daysto Maturity
CUSIP lnvestment #
Federal Agency lssues - Callables
31 30AL6J8
31 3OALDNl
31 30ALHZo
31 30ALJ62
313OALMM3
313041\ /67
3130AMW57
313oAQ\ /F6
313OAQWJ8
31304Q255
313oARCV1
313OARGE5
3130AS320
31 30A5567
31 30ASS91
3134G\ /CGg
3134GXMX9
3134GXQP2
3134GXUM4
31 36G4C43
3135G4223
lssuer
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Mtg Corp
Fed. Home Loan Mtg Corp
Fed. Home Loan Mtg Corp
Fed. Home Loan Mtg Corp
Fed. Nat'l Mortgage Assoc
Fed. Natl Mortgage Assoc
Total and Average
536
539
541
542
544
546
551
559
560
563
565
566
568
571
572
530
564
567
569
527
532
537
Average
41,700,428.95
801,739.54
87,174,877.98
0212412021
03t16t2021
03t'18t2021
0312412021
03t3012021
0412212021
0613012021
0212512022
0212412022
03t10t2022
0312812022
04t21120?2
0st26t2022
o4t16t2022
08t10t2022
07t30t2020
03l25no22
0412812022
0610712022
08t1412020
11t17t2020
o211812021
1010112020
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
I,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,700,000.00
1,000,000.00
1,000,000.00
'1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
41,700,000.00
500,000.00
300,000.00
800,000.00
89,096,019.36
Market Value
1,81 1 ,680.00
1,817,400.00
923,560.00
910,220.00
1,826,500.00
911,590.00
1 ,819,740.00
930,050.00
927,O70.00
940,890.00
1,952,160.00
953,790.00
1 ,656,701.00
982,2'10.00
973,620.00
928,300.00
957,540.00
970,710.00
978,1 90.00
1,844,420.00
1,828,160.00
38,668,551.00
474,685.00
277,923.00
752,608.00
84,858,748.38
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000-00
1,000,000.00
1,700,000.00
1,000,000.00
1,000,000.00
1,000,420.47
1,000,000.00
1,000,000.00
1,000,000_00
2,000,000.00
2,000,000.00
41,700,420.47
501,685.24
300,000.00
801,685.24
89,139,755.45
0.625
0.800
0.530
0.875
1.000
't .'100
0.650
2.150
2.050
2.500
2.250
3.000
3.000
4.500
4.000
0.650
2.200
3.030
3.050
0.650
0.560
0.616
0.789
0.523
0.863
0.986
1.085
0.967
2.121
2.022
2.466
1.846
2.959
2.959
4.438
3.945
o.621
2.170
2.988
3.008
0.641
0.552
1,030
1,050
779
1,058
1,064
1,087
1,156
1,396
1,395
1,409
332
't,451
575
1,568
1,562
730
694
728
403
836
93'l
0212412026
03116t2026
06t1812025
03t24t2026
0313012026
0412212026
06t30t2026
o2D5nO27
02t24t2027
0311012027
03t28n024
0412112027
1112612024
0811612027
oahot2027
04t30t2025
0312512025
04t28t2025
06t0712024
oan4t2025
11t'17t2025
Miscellaneous Securities - Coupon
Subtotal and Average
Dixon CA Unified School Dist
Natomas CA Sch Dist AA lnsured
Subtotal and Average
255651 KY6
63877NMM6 53't
0.672
1.'t00
458 0810112024
a23 0a1o112025
1.361 994
0.395
1.085
0.653 595
1.938 611
Portfolio CITY
AP
PM (PRF_Ptvl2) 7.3.0Run Date: 05/232023 - 18:36
City Council Agenda - June 1, 2023
./:
,! /,
i..INDIAN i WELLS City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489CALIFORNIA
lnvestments
Money Market Sweep/Checking Account
lnvestments
Total Earnings
Cunent Year
Average Balance
Return
Kevin
Reporting period 0l|/01 /2023-0413012023
2014, 2015, 2016, 2020 Series
Portfolio Management
Portfolio Summary
April30,2023
Par Market
Value
2,494.00
2,494.00
Fiscal Year To Date
0.00 2,494.00 100.00
2,494.OO 100.00%
Book
Value
o/o ol
Portfolio Term
Days to
Maturity
YTM
360 Equiv.
0.000
0.000
YTM
365 Equiv.
0.000
0.000
Portfolio 144
CP
PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
Value
2,494.00
2,494.00
April 30 Month Ending
1 0.00
2,485.08
0.00%
Run Date: 05/2512023 - 07:47
City Council Agenda - June 1, 2023
2O1 4, 201 5, 2016, 2020 Series
Portfolio Management
Portfolio Details - Investments
April30,2023
Purchase
Date
Page I
custP lnvestment #
lllloney Market Sweep/Checking Account
lssuel
2014A Bonds Reserve
All Bond Series Principal
All Bond Series lnterest
All Bond Series Debt Svc
Cost Of lssuance Escrow
Subtotal and Average
Total and Average
Average
Ealanca
2,485.08
2,485.08
Par Value
0.00 155.29
0.08 2,338.63
0.00 2,494.00
2,494.0O
Market Value
0.00 155.29
0.08 2,338.63
0.00 2,494.00
2,494.00
Stated
BookValue R.te
0.00 155.29
0.08 2,338.63
0.00 2,494.00
2,494.OO
YTM Daysto
365 Maturitv
0.000
0.000
0.000
0.000
0.000
0.000
0.000
Maturity
flata
Portfolio 144
CP
PM (PRF_PM2) 7.3.0
Fitch
SYS28
SY526
SYSz5
SYS27
SYS24
28 26
25 27
I
07t01t2022
07to112022
071o112022
0710112022
0710112022
Run D?l.e: oS 125 Do23 - 07 : 47
Report Ver. 7.3.6.1Page 258 of 359
City Council Agenda - June 1, 2023
INDIAN
1 / -.,1
1)'WELLS
City of lndian Wells
44-950 Eldorado Drive
lndian Wells C492210
(760)346-2489CALIFORNIA
lnvestments
Money Market Sweep/Checking Account
lnvestments
Total Earnings
Current Year
Average Daily Balance
of Return
Agenry
Reporting period 04/01/2023-0413012023
Value
1.00 1.00
April 30 Month Ending
Par
2015 A Bonds
Porffolio Management
Portfolio Summary
April30, 2023
Market
Vrlrre
1.00 1.00
Fiscal Year To Date
0.00 Book
Value
o/o ol
Portfolio Term
Days to
Maturity
1 .00 100.00
{.00 100.00%I
YTM
360 Equiv.
0.000
0.000
YTM
365 Equiv.
0.000
0.000
Portfolio 15A
CP
PM (PRF_PMl) 7.3.0
Report Ver. 7.3.6.1
0.00 1.00
0.00%
Run Date: 0525/2023 - 07:49
City Council Agenda - June 1, 2023
2015 A Bonds
Portfolio Management
Portfolio Details - lnvestments
April30, 2023
Page I
Stated YTM Days to Maturity
BookValue E-ld Fifch 365 MatudtwCUSIPlnvestment #
Money Market Sweep/Checking Account
lssuer
201 5 A Reserve
UBC Cost Of lssuance Escrow
Subtotal and Average
Total and Average
Average Purchase
1.00 1.00
SYS27
SYS22
27 22
07to1t2022
07t01t2022
1.00 0.00
1.00 0.00
0.000
0.000
Par Value
1.00 1.00
Market Value
1.00 0.00
1.00 1.00
1.00 1.00
0.000
0.000
Portfolio 15A
CP
PM (PRF_PM2) 7.3.0Run Date: 052512023 - 07:49
Report Ver. 7.3.6.1Page 260 of 359
City Council Agenda - June 1, 2023
INDIAN
/+-/
,,E .:.
i'WELLS City of lndian Wells
44-950 Eldorado Drive
lndian Wells C492210
(760)346-2489CALIFORN IA
2016 A Bonds
Portfolio Management
Portfolio Summary
April 30,2023
Market Book
Value
olo ol Days to YTM
360 Equiv.365 Equiv.lnvestments
Money Market Sweep/Checking Account
lnvestments
Total Earnings
Current Year
Average Daily Balance
of Return
1.00 r.00
April 30 Month Ending
1.00 ,t.00
Fiscal Year To Date
0.00 'I .00 100.00
1.00 100.00%
Par
Value Term
1 0.000
0.000
0.000
0.000
Portfolio 16A
CP
PM (PRF_PMl) 7.3.0
Report Ver. 7.3.6.1
0.00 1.00
0.00%
n
Reporting period 0/U01 /2023-0413012023
Run Date: 0525/2023 - 07:50
City Council Agenda - June 1, 2023
2016 A Bonds
Portfolio Management
Portfolio Details - lnvestments
April 30,2023
Purchase
Date
Stated
BookValue Rate
1.00 1.00
Page't
YTM Days to Maturity
Fitch 365 Maturitv Deta
0.000
0.000
Portfolio 16A
CP
PM (PRF-PM2) 7.3.0
CUSIP lnvestment #lssuer
Money Market Sweep/Checking Account
SYS28 1 UBC Cost Of lssuance Escrow
SYS33 2 Union Bank Reserve Account
Subtotal and Average
Total and Average
Average
Balance
1.00 1.00
07t01t202?
0710'112022
Par Value
1.00 1.00
Market Value
1.00 1.00
0.00 1.00
0.00 't.00
0.00 1.00
0.000
0.000
Run Date: 052512023 - 07:50
Report Ver. 7.3.6.1Page 262 of 359
City Council Agenda - June 1, 2023
INDIAN WELLS 2020 A Bonds
Portfolio Management
Portfolio Summary
April30, 2023
Market
Valrra
1_00
1.00 Fiscal Year To Date
0.00 City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA922'lO
(760)346-2489CALIFORNIA
Investments
Money Market Sweep/Checking Account
lnvestments
Total Earninss
Current Year
Average Daily Balance
of Return
Reporting period 04101 /2023-0413012023
1.00 1.00
April 30 Month Ending
Par Book
Value
Yo ot
Portfolio
Days to
Maturity
YTM
360 Equiv.
0.000
0.000
365 Equiv.
0.000
0.000
Portfolio 20A
CP
PM (PRF_PMl) 7.3.0
Report Ver. 7.3.6.1
Tem
1.00 100.00
1.00 100.00%I
0.00 1.00
0.00%
Run Date; 05/252023 - 08:22
City Council Agenda - June 1, 2023
2020 A Bonds
Portfolio Management
Portfolio Details - lnvestments
April30,2023
YTM Daysto MatudtyAverage Purchase Stated
CUSIP lnvestment #lssuer
Money Market Sweep/Ghecking Account
SYSI 1 2020 A Bonds COI
SYS2 2 2020 A Bonds Reserve
Subtotal and Average
Total and Average
07to1t2022
0710112022
Par Value
1.00 1.00
Market Value
1.00 1.00
Book Value
0.00 1.00
1.00 1.00
FitFh
0.00 '1.00
0.00 1.00
0.000
0.000
r.00
1.00 0.000
0.000
Portfolio 20A
CP
PM (PRF_PM2) 7.3.0Run Date: 05125/2023 - 08:22
Report Ver. 7.3.6.1Page 264 of 359
City Council Agenda - June 1, 2023
: iG'/) ''!.t 1
INDIAN .I WELLS\
City of lndian Wells
zg-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489CALIFORNIA
lnvestments
Money Market Sweep/Checking Account
lnvestments
Total Earnings
Current Year
Average Balance
of Return
Agency
Reporting period 04/0{ /2023-0413012023
2022 Bonds
Portfolio Management
Portfolio Summary
April30, 2023
Value
11,228,275.23
11,228,275.23
April 30 Month Ending
0.00 11,208,508.77
0.00%
Market
Value
11,228,275.?3
't1,228,275.23
Fiscal Year To Date
0.01 %of
Portfolio
11,228,275.23 100.00
11,228,275.23 100.00%
Pat Book
Value Te]m
Days to
Maturity 360 Equiv. 365 Equiv.
o.000 0.000
0.000 0.000
Portfolio 22
CP
PM (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
1 Run Date: 05/2512023 - 08:01
City Council Agenda - June 1, 2023
2022 Bonds
Portfolio Management
Portfolio Details - lnvestments
April30, 2023
Purchase
Date Par Value
Stated
Book Value Flrtc Fitch
CUSIP lnvestment #
Money Market Sweep/Checking Account
SYS2
SY54
SYSl
SYS5
SYS3
Subtotal and Average
Total and Average
lssuer
2022 Bonds COI
2022 Bonds lnterest
2022 Bonds Project Fund
2022 Bonds Redemption Fund
2022 Bonds Payment Fund
2 4
1 c
3 Average
Rahnaa
11,208,508.77
1 1,208,s08.77
07t0112022
0311612023
07to112022
o311612023
0912112022
0.00 256,748.26
10,591,248.39
380,000.00
278.58
11,228,275.23
11,228,275.23
Market Value
0.00 256,748.26
10,591 ,248.39
380,000.00
278.58
11,228,275.23
11,228,275,23
0.00 256,748.26
10,591,248.39
380,000.00
278.58
11,228,275.23
11,228,275.23
0.000
0.000
0.000
0.000
0.000
YTM Daysto
365 Maturitv
illaturity
1 Porltolio22
CP
PM (PRF_PM2) 7.3.0
0.000
0.000
Run Date: 0512512023 - 08:01
Report Ver. 7.3.6.1Page 266 of 359
City Council Agenda - June 1, 2023
INDIAN WELLS CITY COUNCIL
June 1, 2023
To: City Council
From: Finance Department
Prepared by: Kevin McCarthy, City Finance Director
Subject: Residential and Commercial Rates for Refuse Collection and Recycling Services and Annual Levy of Residential Parcels
RECOMMENDED ACTION:
Council OPENS the public hearing, takes any public testimony, CLOSES the public hearing; and
APPROVES the annual levy of residential parcels for refuse collection and recycling services; and
ADOPTS Resolution ordering the levy and collection of fees for refuse collection and recycling services from residential and commercial properties within the City consistent with Indian Wells Municipal Code section 8.04.190.ody
SUMMARY:
Annually as required by law, the City Council must hold a Public Hearing and approve by Resolution the annual Residential and Commercial Rate for Refuse Collection and Recycling Services within the City of Indian Wells. The City Council must also approve the annual levy of residential parcels for refuse collection and recycling services. The approved levy is placed on the Riverside County tax roll for collection.
To comply with Proposition 218 requirements, a Public Hearing was properly noticed for the June 1, 2023, City Council meeting. The Public Hearing notice allows for public testimony regarding the proposed residential rate.
The levy for refuse collection and recycling services consists of three essential components: service cost, disposal, and recycling. The franchise agreement fixes service and recycling costs and can only be adjusted strictly within the terms and conditions outlined in the franchise agreement. The disposal fee is a direct pass-through to customers based on the tipping fee that the County of Riverside charges at the landfill.
The City oversees a very accomplished and efficient city-wide recycling program using AB 939 recycling fees. This recycling fee, adopted in 1991, covers the costs of implementing
City Council Agenda - June 1, 2023
a source reduction and recycling program to maintain City compliance with State mandated diversion goals.
Rubbish Services are offered to Indian Wells Residents.
Residential Services
Indian Wells provides backyard service to all residential households. In addition, Burrtec provides color-coded bins for rubbish disposal, including regular household waste, recycling, and green and food waste.
Additional Services
The following services are free for residents; however, pick-up of these items is optional.
To schedule a pickup, residents can call Burrtec at (760) 340-2113.
Bulky Items
To dispose of large, bulky items that do not fit in the regular trash container, residents can contact Burrtec to schedule a Bulky Item Pickup. Residents may place up to four items weekly at the curb by 7:00 a.m. on their regular trash day.
Electronic Waste (E-Waste)
TVs, computers, phones, thermostats, and other gadgets are dangerous to our environment if not managed properly. Burrtec will collect these items for recycling at no charge through their bulky item pick-up process.
Household Hazardous Waste (HHW)
Residents may call Burrtec for free at-home collection of Household Hazardous Waste.
The material should be placed near waste cans for collection.
Sharps Disposal
To safely dispose of needles and other medical "sharps," residents can collect the used instruments in a puncture-resistant container with a secure cap. Mark the container "Sharps.” Once the container is full, contact Burrtec, and they will arrange to collect the material.
Motor Oil
Residents may contact Burrtec at least 48 hours in advance of their regular service day to schedule a free pick-up of up to five gallons of used motor oil.
Christmas Trees
From December 26th through the second week of January, Burrtec will collect Christmas trees on the resident’s regular trash collection day.
City Council Agenda - June 1, 2023
Document Shred Events
The City of Indian Wells offers two document shred events each year. These allow residents to securely dispose of financial records, medical papers, and other sensitive documents. A mobile shredding unit on-site destroys these items. Events are held on the last Saturday of January and the last Saturday of April at Burrtec’s office at 41575 Eclectic Street, Palm Desert. Shredding starts at 7:00 a.m. and ends at 11:00 a.m.
Commercial Recycling Programs
Burrtec coordinates primary residential, commercial, and organic recycling efforts for the City of Indian Wells. According to the latest diversion statistics, Cal-Recycle determined waste generation (to the County landfill) must come in at 21.5 pounds per Indian Wells residence per day or lower.
Thanks to significant recycling efforts, Indian Wells generates only 9.0 pounds per Indian Wells residence daily. This is an improvement over last year when residents generated
10.3 pounds daily.
FISCAL IMPACT:
Under the terms of the agreement, service rates adjust annually by the annual percent change based on the Producer Price Index (PPI). However, the total residential and commercial service adjustments shall not exceed the maximum cap of 5% in any given adjustment year.
SB 1383 Implementation Costs on Indian Wells Rubbish Rates In September 2016, Governor Edmund Brown Jr. set methane emissions reduction targets for California (SB 1383 Lara, Chapter 395, Statutes of 2016) in a statewide effort to reduce emissions of short-lived climate pollutants (SLCP).
The statutory requirements to reduce organic waste disposal by 75 percent by 2025 include a mandate that CalRecycle’s regulations have “requirements intended to meet the goal that not less than 20 percent of edible food that is currently disposed of is recovered for human consumption by 2025.” The regulations are designed to achieve these organic waste reduction targets within the authority and direction provided in enabling statute.
The SB 1383 regulations require that jurisdictions conduct education and outreach on organics recycling to all residents, businesses (including those that generate edible food that can be donated), haulers, solid waste facilities, and local food banks and other food recovery organizations. Most recently, Indian Wells Residents welcomed our SB 1383
City Council Agenda - June 1, 2023
recycling education campaign and are showcasing positive participation in our newly implemented recycling programs. The City, residents, and businesses look forward to ongoing education efforts.
As discussed during the implementation phase, SB 1383 implementation costs are included in the 2023-24 rubbish levy fiscal year. SB 1383 fees are $4.25 per month or $51.00 annually.
Residential Rates
The annual levy of residential parcels for refuse collection and recycling services is $360.84 per parcel, an increase of $67.56 compared to the prior year. The new levy is effective from July 1, 2023, through June 30, 2024. The franchise agreement governs service and recycling costs. The proposed residential levy is as follows:
Commercial Rates
Commercial rates consist of three components: the service rate, tipping fees, and AB 939 recycling fees, and are adjusted by the franchise agreement. Burrtec’s commercial rate schedule is attached to this staff report.
ATTACHMENTS:
1. Resolution
2. Burrtec FY 2023-24 Rubbish Rates Correspondence
Fy 2023/24 Fy 2022/23 Fy 2023/24 Fy 2022/23
Proposed Current Increase Proposed Current Increase
Tax Roll Levy Levy Levy Direct Bill Levy Levy Levy Service Fee 13.43 12.79 0.64 Service Fee 14.67 13.97 0.70 SB 1383 Rate 4.25 - 4.25 SB 1383 Rate 4.25 - 4.25 Dump Fee 4.35 4.02 0.33 Dump Fee 4.35 4.02 0.33 AB 939 Assessment 0.53 0.53 - AB 939 Assessment 0.53 0.53 - Recycling Fee 5.94 5.66 0.28 Recycling Fee 5.94 5.66 0.28 Home Hazardous Waste 1.57 1.44 0.13 Home Hazardous Waste 1.57 1.44 0.13 Total Monthly Fee 30.07 24.44 5.63 Total Monthly Fee 31.31 25.62 5.69 Total Annual Fee 360.84 293.28 67.56 Total Annual Fee 375.72 307.44 68.28 Residential Services
City Council Agenda - June 1, 2023
RESOLUTION NO. 2023-_
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF INDIAN WELLS,
CALIFORNIA, ORDERING THE LEVY AND COLLECTION OF FEES FOR
REFUSE COLLECTION AND RECYCLING SERVICES FROM RESIDENTIAL
AND COMMERICAL PROPERTIES WITHIN THE CITY PURSUANT TO
INDIAN WELLS MUNICIPAL CODE SECTION 8.04.190
WHEREAS, the City Council has heretofore adopted Chapter 8.04 of the Indian Wells Municipal Code establishing standards for the collection and disposal of refuse, trash, rubbish and other forms of solid waste; and
WHEREAS, the City Council has determined that the disposal and/or collection of refuse, trash, rubbish or other solid waste is a service to be performed in the City in accordance with the provisions of the Municipal Code; and
WHEREAS, pursuant to Municipal Code Section 8.04.210 and California Public Resources Code Section 40059(a)(1) an exclusive franchise has been granted to Burrtec Waste and Recycling Services (the “Contractor”) for the collection, transportation, recycling, composting and disposal of solid waste from residential, commercial, construction and industrial (roll-off) establishments within the City; and
WHEREAS, Municipal Code Section 8.04.190 provides that the City Council shall establish by Resolution the schedule of residential and commercial fees that can be charged by the Contractor for solid waste collection, disposal and recycling services; and WHEREAS, California Public Resources Code Section 41901 authorizes the City to impose fees in amounts sufficient to pay the costs of preparing, adopting, implementing and administering local recycling and source reduction programs; and WHEREAS, the City has heretofore adopted and imposed an AB 939 Administrative Fee as part of the fees for refuse collection and recycling services paid annually by eligible parcels within the City; and
WHEREAS, the City Council desires to levy and collect residential and commercial fees to pay for Refuse Collection and Recycling Services rendered to eligible parcels within the City for the period commencing July 1, 2023, and ending June 30, 2024; and WHEREAS, the City Council has conducted a duly noticed public hearing on June 1, 2023 concerning the adoption of fees for refuse collection and recycling services, at the conclusion of which there was not a majority protest against the adoption of the proposed fees.
NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF INDIAN WELLS DOES HEREBY FIND, DETERMINE, RESOLVE AND ORDER AS FOLLOWS:
SECTION 1. In all respects, the Recitals of this Resolution are true and correct.
ATTACHMENT #1
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
SECTION 2. The annual fees for residential refuse collection and recycling services shall be $360.84 per parcel for those parcels which will be billed on the property tax roll, and otherwise for all other parcels of the rates set forth in Exhibit “A” attached hereto. The City Clerk and Finance Director are authorized and directed to request that the County place on residential property tax roles in the amount of $360.84 per parcel. The annual fees set forth above shall be effective from and after the first day of July 1, 2023 through June 30, 2024 unless amended by City Council resolution prior to that date.
SECTION 3. The annual rates for commercial refuse collection and recycling services shall be as set forth in Exhibit “A” attached hereto. Commercial rates shall be paid by all applicable commercial customers within the City. The annual fees set forth above shall be effective from and after the first day of July 1, 2023 through June 30, 2024 unless amended by City Council resolution prior to that date.
SECTION 4. This Resolution shall take effect upon adoption.
PASSED, APPROVED, AND ADOPTED by the City Council of the City of Indian Wells, California, at a regular meeting held on this 1st day of June 2023.
_______________________________
DONNA GRIFFTH
MAYOR
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
CERTIFICATION FOR RESOLUTION NO. 2023-_
I, Angelica Avila, City Clerk of the City Council of the City of Indian Wells, California DO HEREBY CERTIFY that the whole number of the members of the City Council is five (5); that the above and foregoing resolution was duly and regularly passed and adopted at a regular meeting of the City Council of the City of Indian Wells the 1st day of June 2023, by the following vote:
AYES:
NOES:
ATTEST: APPROVED AS TO FORM:
_____________________________ ____________________________
ANGELICA AVILA TODD LEISHMAN
CITY CLERK CITY ATTORNEY
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
EXHIBIT “A”
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution 2023-_
City Council Agenda - June 1, 2023
ATTACHMENT #2
City Council Agenda - June 1, 2023
INDIAN WELLS CITY COUNCIL
June 1, 2023
To: City Council
From: City Manager Department
Prepared by: Angelica Avila, City Clerk
Subject: Annual Appointments to the Various Commission, Committees, and Boards Vacancies
RECOMMENDED ACTIONS:
Council APPROVES the Council Ad Hoc Committee recommendations for a two-year term beginning on July 1, 2023, through June 30, 2025; and APPOINTS Peter Rammer and Marianne Hagan to serve on the Community Activities Committee; and
APPOINTS Marcie Maxwell to serve on the Golf Resort Advisory Committee; and APPOINTS Ivonne Sklar to serve on the Indian Wells Housing Authority n; and APPOINTS Glenn Schubert to serve on the Planning Commission; and APPOINTS Robert Berriman to serve on the Palm Springs Airport Commission; and APPOINTS Susan Paresky to serve on Grants in Aid Committee and Tricia Cole to serve on Community Activities Committee to fill unexpired terms ending on June 30, 2024; and
RE-APPPOINTS for a second term ending on June 30, 2025; Bruce Bahneman to serve on the Planning Commission, Tim Venturi on the Golf Resort Advisory Committee, Kay Hillery on the Community Activities Committee, Kathleen Felci, Arlene Lucchesi, and Corina Morrison on Grants in Aid Committee and John O’Hea on the Housing Authority.
BACKGROUND:
Annually the City Council appoints residents (“Members”) to serve on various Commissions, Committees and Boards (“Committee”). Serving on a Committee provides an opportunity for residents to volunteer and serve their community. The selection
City Council Agenda - June 1, 2023
process includes an application and interview by a City Councilmember(s), who make recommendations to the full City Council.
Selected Members serve for a two-year term unless they fill an unexpired vacancy on any one Committee. Members may serve two consecutive terms, up to a maximum of four years, on any one Committee. Members are required to complete an application after the completion of their first term to seek reappointment or to apply for a different Committee.
The City received 26 applications from interested residents to fill vacancies, with terms beginning on July 1, 2023, and ending on June 30, 2025.
Community Activities Committee 3
Golf Resort Advisory Committee 2
Grants In Aid Committee 3
Housing Authority 2
Palm Springs Airport Commission 1
Planning Commission 2
Two vacancies are for unexpired terms; one on the Community Activities Committee and one on the Grants in Aid Committee, are to fill terms ending on June 30, 2024.
Committee resident member Glenn Schubert is being recommended for appointment on the Planning Commission creating one of the unexpired terms. The Council Ad Hoc recommends the additional appointment of Tricia Cole for a one-year term on the Community Activities Committee to fill Mr. Shubert’s unexpired term. Due to a resignation on the Grants in Aid Committee in December of 2022, the Ad Hoc recommends Susan Paresky to fill the one-year unexpired term.
Applications received are available for public review at City Hall, City Clerk Department during regular business hours, 8:00 a.m. to 5:00 p.m., Monday through Friday (excluding holidays).
City Council Agenda - June 1, 2023
INDIAN WELLS CITY COUNCIL
June 1, 2023
To: City Council
From: City Manager Department
Prepared by: Peter Castro, Deputy City Manager
Subject: Discussion on Naming the Future Park at Eldorado and Fairway Drive
RECOMMENDED ACTIONS:
Council DISCUSSES potential names for the park at the northwest corner of Eldorado and Fairway Drive; and
PROVIDES direction to staff.
DISCUSSION:
At the March 2, 2023, City Council meeting, the Council approved the design for the development of the new park at the corner of Eldorado and Fairway Drive.
As the final design is being completed, Council needs to determine a name for the park to be included into the design. The naming of a park is complex as the assigned name is a permanent identity of this public place. There are many options to consider when naming a park such as:
A distinct geographic, historic, environmental, physical element, or developmental feature
The streets adjacent to the park
A local neighborhood or community
A commemorative event
Some initial ideas that have been submitted:
- Desert Gateway
- Desert Greens
- Desert Gardens
- Desert Gem
- Desert Glen Park
- Desert Glory
City Council Agenda - June 1, 2023
- Desert Fauna
- Desert Jewel
- Desert Palm
- Desert Estates Park
- Desierto Jardin Park
- Eisenhower Park
- Eldorado Park
- Eldorado Palms Park
- Fairway Park
- Kavinish Park
- Legacy Park
- Heritage Park
- Paradise Park
Staff is seeking Council discussion on the naming of the park or direction on how to best proceed with the naming of the park over the next 30-60 days.
OPTIONS:
1. Staff recommends the City Council discuss potential names for the park at the northwest corner of Eldorado and Fairway Drive; or
2. Provide alternative direction.
FISCAL IMPACT:
There is no fiscal impact with this action.
City Council Agenda - June 1, 2023
From:
To:Angelica Avila
Cc:Donna Griffith
Subject:City Council Meeting June 01, 2023
Date:Wednesday, May 31, 2023 8:03:06 AM
CAUTION: This email originated outside our organization. Be cautious with any links or attachments. ________________________________
Good Morning Angelica,
Yesterday, I received and read the
City Council Meeting Agenda for
June 01, 2023.
It is delightful to read about the naming of our new park.
As it is a privilege to live in the City of Indian Wells a cc of this email was sent to our Mayor.
It is very important to include the name
of our great City and our current Mayor.
Mayor Griffith in a short time did a lot for
our City.
Since none of the suggestions included
the name of our City or of our Mayor,
under General Business I -2 please include the following for consideration in naming our park. 1) Indian Wells Legacy Park
2) Indian Wells Griffith Park
3) Indian Wells Oasis Park
Thank you,
Amalia Latza
(Indian Wells Resident for almost 20 years)
Public Comment: Item I.2
6/01/2023
INDIAN WELLS CITY COUNCIL
June 1, 2023
To: City Council
From: Finance Department
Prepared by: Kevin McCarthy, City Finance Director
Subject: Fiscal Year 2023-24 Golf Resort Operating Budget and Capital Improvement Plan
RECOMMENDED ACTION:
Council REVIEWS, DISCUSSES, and APPROVES or APPROVES AS AMENDED the Golf Resort Operating Budget and Capital Improvement Plan from July 1, 2023, through June 30, 2024.
BACKGROUND:
The Golf Resort budget, as submitted, includes $19.6 million (net of Golf Subsidy) in operating revenues and $18.6 million in operating expenditure. Capital replacements total $950,498. The after-capital net operating profit at the Golf Resort is projected at $53,593. Appropriations for operational costs are balanced in relation to projected revenue sources and do not rely on one-time revenue sources or reserves.
The budget implements the Council’s priorities and strategic goals, provides a financial plan that continues delivering first-rate services, and is responsive to the community’s needs. In addition, developing a stand-alone Golf Resort budget book addresses the Community’s needs to improve communication and transparency.
In addition to providing a detailed budget by profit centers, the new Golf Resort Budget Book includes the business plan, and a look into the new marketing plan. Capital funding was also updated and is now broken down into two separate segments, capital repairs and replacements managed by Troon and all other capital funding managed by the City Council.
Summary of Strategic Goals and Priorities
The budget implements the Council’s priorities and strategic goals, provides a financial plan that continues delivering first-rate services, and is responsive to the community’s needs. The focus of a strategic plan is to outline the goals of the City Council for the community as a whole/organization over some time (one, three, or five years are typical).
City Council Agenda - June 1, 2023
A Summary of the City Council and staff Goals for the upcoming Golf Resort budget cycle is as follows:
Goals and Priorities
Profitable before the amenity subsidy and after capital and maintenance expenses. Develop strategies to increase customers and check averages in all operations (e.g., Vue restaurant, banquets, golf, etc.).
Identify opportunities to improve efficiency and operations to be more cost- effective while maintaining quality.
Develop a comprehensive marketing strategy that promotes the Indian Wells Golf Resort as a golf and special events destination for visitors, including local and drive markets.
o Improve advertising by adding Top Tracer to Shots in the Night and the Academy.
Expand partnerships with local hotels to increase customers at the Indian Wells Golf Resort for golf, dining, and special events.
Focus on driving more golf rounds and increasing banquets at the Indian Wells Golf Resort. These are the top two profit centers for the golf resort. Examine possible rebranding of the Vue restaurant’s concept and menu, including a celebrity chef concept that targets all customers (e.g., golfers, residents, hotel guests, and local drive market).
Consider golf resort operating profits and energy savings from the new solar project to fund future capital needs.
Remove allocated payroll.
o Direct charges only based on the actual timecard.
Provide $3.7 million (gross surplus) to repay loans to the City’s General Fund. o Based on current projections, Golf Loans are scheduled to be fully repaid to the City’s General Fund by FY 2024/25.
Provide Financial Performance targets in the form of net income goals. Based on the budget, the ability to meet the Financial Performance targets is estimated in the table below.
City Council Agenda - June 1, 2023
Implement strategies to increase customers and check averages. Identify opportunities to improve efficiency and operations to be more cost-effective while maintaining quality.
Consider golf resort operating profits and energy savings from the new solar project to fund future capital needs.
Budget Overview
The Budget Document comprises both the Annual Operating Budget and the Capital Budget. The Operating Budget is the total budget used to finance all day-to-day operations and obligations of the Golf Resort. The fiscal year 2023/24 Adopted Budget totals $18.6 million for all Golf operations.
Minimum
Goal
Maximum
Goal
Budgeted
Goal Met Goal
Golf, including golf maintenance 25.0%30.0%27.6%Yes
Merchandise 27.0%33.0%30.5%Yes
F&B All Outlets Consolidated 15.0%20.0%19.5%Yes
Vue 8.0%12.0%8.4%Yes
Vue - Cost of Sales 30.0%n/a 29.5%Yes
Vue - Labor 50.0%n/a 50.0%Yes
Beverage Carts 38.0%42.0%38.0%Yes
Banquets 30.0%35.0%33.0%Yes
Food Truck 30.0%35.0%21.6%No
Shots in the Night 30.0%35.0%30.0%Yes
General & Administrative
Increased
5.3% to Last
Year Actual
Missed City
Target by
$242k
Building Maintenance
Increased
4.5% to Last
Year Actual
Missed City
Target by
$100k
Indian Wells Golf Resort
Projected Net Income Goal (%) by Department
Decrease 5% from last
year actual
Decrease 5% from last
year actual
City Council Agenda - June 1, 2023
Capital Budget Overview
The capital improvement plan includes sixteen projects budgeted for $950,498.
ATTACHMENTS:
1.Golf Resort Budget Book
2.Golf Resort Implementation Goals and Deliverables
Fiscal Year
2023-24
Budget
Rounds 76,507
Covers 237,728
Total Revenues (Net of Golf Subsidy)19,613,644
Cost of Sales 3,177,065
Payroll 9,858,197
Operating Expenses 5,574,291
Total Operating 18,609,553
Net Operating Income before Capital 1,004,091
Capital Replacements 950,498
Net Operating Income After Capital 53,593
Indian Wells Golf Resort
Consolidated Budget Summary
Capital Category Total Percentage
Buildings And Structures 29,300 3.1%
Clubhouse Equipment 20,000 2.1%
Golf Course Equipment 658,419 69.3%
Signage and Wayfinding 133,800 14.1%
Emergency 108,979 11.5%
Total Capital Replacements 950,498 100.0%
City Council Agenda - June 1, 2023
Indian Wells Golf Resort Budget
Fiscal Years 2023/24
June 1, 2023
At dais: Presentation Item I.3
06/01/2023
A Look at the New Golf Resort Budget Book
•Enhances Fiscal Transparency to our Residents
•Establishes revenue and expense expectations by Profit Center
•Provides a single source of enhanced detail
•Establishes Deliverables and Council Goals
•Business Plan
•Marketing Plan
•Provides detailed anticipated Financial Performance broken out by Profit Center
•Provides detailed capital spending based on needs
Achieving Council Goals during the Budget Cycle
•Provides a $53,593 surplus before including the
amenity subsidy and after capital repairs and
maintenance.
•Clarifies Golf Amenity Subsidy as shown in the
budget and Financial Statements.
•Removes allocated payroll
•Direct charges only based on the actual timecard.
Achieving Council Goals during the Budget Cycle
•Provides $2.5 million (gross surplus) to repay loans to the City’s General Fund.
•All Golf Loans are anticipated to be repaid to the
City’s General Fund by FY 2024/25.
Meeting Financial Performance Targets
Minimum
Goal
Maximum
Goal
Budgeted
Goal Met Goal
Golf, including golf maintenance 25.0% 30.0% 27.6%Yes
Merchandise 27.0%33.0% 30.5%Yes
F&B All Outlets Consolidated 15.0% 20.0% 19.5%Yes
Vue 8.0% 12.0% 8.4%Yes
Vue - Cost of Sales 30.0%n/a 29.5%Yes
Vue - Labor 50.0%n/a 50.0%Yes
Beverage Carts 38.0% 42.0% 38.0%Yes
Banquets 30.0% 35.0% 33.0%Yes
Food Truck 30.0% 35.0% 21.6%No
Shots in the Night 30.0% 35.0% 30.0%Yes
General & Administrative
Increased
5.3% to Last
Year Actual
Missed City
Target by
$242k
Building Maintenance
Increased
4.5% to Last
Year Actual
Missed City
Target by
$100k
Indian Wells Golf Resort
Projected Net Income Goal (%) by Department
Decrease 5% from last
year actual
Decrease 5% from last
year actual
Fiscal Year
2023-24
Budget
Rounds 76,507
Covers 237,728
Total Revenues (Net of Golf Subsidy)19,613,644
Cost of Sales 3,177,065
Payroll 9,858,197
Operating Expenses 5,574,291
Total Operating 18,609,553
Net Operating Income before Capital 1,004,091
Capital Replacements 950,498
Net Operating Income After Capital 53,593
Indian Wells Golf Resort
Consolidated Budget Summary
Capital Category Total Percentage
Buildings And Structures 29,300 3.1%
Clubhouse Equipment 20,000 2.1%
Golf Course Equipment 658,419 69.3%
Signage and Wayfinding 133,800 14.1%
Emergency 108,979 11.5%
Total Capital Replacements 950,498 100.0%
Excited by our future
Happy, yet not satisfied
~
Be so good they can’t
ignore you
(1.2 BilLion are Watching)
Headlines
Residents are our priority
Leverage our solid TROON resources
Work with TROON’s Quality Standards
Regular review of our Business Plan
Summer theme: “efficiency”
Drive excellence
Operating strategies
Continue with seasonal flexing in all areas
Hours of operation & staffing
Flex based on historical trends & patterns
Promoting VUE during the Summer & beyond
Theme nights
“Happiest place in the valley”
New menu /fresh look
What is new?
Year round sales efforts
Golf growth in rate/ rounds
New TV & PR presence
Multiple awards & articles
VUE: Resident Centric/ Golfers
Café 36 in the Lobby
Shots 2.0/ theme nights
Executive Meetings/ playful approach
Drive all social events large & small
•City Council REVIEWS, DISCUSSES, and APPROVES or
APPROVES AS AMENDED any revisions to the July 1, 2023,
through June 30, 2025, Biennial Budget
CITY OF INDIAN WELLS, CALIFORNIA
44-950 Eldorado Drive
Indian Wells, CA 92210
City Council
Draft
June 1, 2023
INDIAN WELLS
GOLF RESORT
BUDGET
&
CAPITAL IMPROVEMENT PLAN
Fiscal Year 2023/2024
ATTACHMENT #1
City Council Agenda - June 1, 2023
TABLE OF CONTENTS
Budget Message 1
Goals & Deliverables 7
Business Plan 10
Marketing Plan 23
Organizational Chart 37
Budget
Consolidated Budget 38
Consolidated Golf 39
Golf & Golf Academy 40
Merchandise 41
Golf Course Maintenance 42
Building 43
General & Administrative 44
Food & Beverage Consolidated 45
VUE Grille 46
Beverage Carts 47
Banquet & Catering 48
Food Truck 49
Shots in the Night (SITN)50
Capital Expenditure Schedule 51
Assumptions 52
City Council Agenda - June 1, 2023
Golf Resort Budget Message
The Honorable Mayor and Members of the City Council:
City of Indian Wells, California
Presented for your
review is the proposed
Indian Wells Golf Resort
budget for the fiscal
years 2023-24.
It is a budget that
reflects the Indian Wells
Golf Resort’s Mission
Statement:
To create extraordinary
resident and guest
experience by delivering
superior service,
amenities, and facility
conditions. Our commitment to the quality of our product, coupled with our operating results, will allow us to enhance the brand of Indian Wells Golf Resort and provide a financially sustainable future for the City of Indian Wells.
Among its many amenities, the park-like Indian Wells Golf Resort includes two excellent 18-hole championship golf courses: The Celebrity Course, designed by Clive Clark, and the Players Course, created by John Fought. Fought also designed a lighted putting course. The Golf Resort also features versatile indoor/outdoor banquet facilities, a restaurant, and bar, an outdoor food truck with patio dining, a Pavilion event center, event lawns, a golf shop, “Shots in the Night,” an evening/group entertainment venue and expert tournament planning services.
Utilizing the “Toptracer” technology, Shots in the Night transformed into a full-time, seasonal outlet operating with impunity from the variances presented by the weather, such as wind and direct sunlight. A Toptracer Range is the ultimate practice tool, taking the guesswork out of range sessions by offering an engaging, data-driven experience that appeals to everyone. Toptracer Range features several modes and games, much like Topgolf. For serious golfers looking to focus on practice, there is the driving range and "What's In Your Bag," which tracks total distance, carry, ball speed, launch, and hang time.
1Page 294 of 359
City Council Agenda - June 1, 2023
The Indian Wells Golf Resort has been a premier destination for amateurs, pros, and presidents. Along the way, the Resort has garnered numerous awards and accolades, including “One of the Best Golf Courses in America” by Leading Golf Courses of America, winner of Golf Digest’s coveted “Best Places to Play” Gold Medal, and one of the “Top 10 Resorts in California” by California Golf magazine, Golden fork award, Dirona award for food and beverage as well as the wine spectator award. The Indian Wells Golf Resort hosts approximately 75,000 rounds annually and 235,000 food and beverage covers.
Douglas Fredrikson Architects designed the Golf Resort’s 53,000-square-foot clubhouse.
This contemporary masterpiece highlights magnificent fairways and mountain views and features sophisticated styling and comfort. The City continues to reinvest in the Golf Resort to encourage new revenue generation. The Pavilion (a 5600 sq. Ft. fully conditioned banquet facility) was built in December 2015, and the VUE restaurant kitchen, Bar experience, and dining room was fully remodeled in September 2019. This keeps facility amenities new and fresh looking, attracting recent events.
Celebrity Course
The Par 72 Celebrity Course
offers the winning combination
of aesthetic beauty and strategic
intrigue. With most holes on this
7,050-yard course oriented
north/south to take advantage
of magnificent mountain views,
scenic water features, and a
profusion of wildflowers, leading
golf course architect Clive Clark
crafted a course that is
breathtaking in beauty. In
November 2007, this spectacular
course was the game site for the
25th annual LG Skins Game.
2Page 295 of 359
City Council Agenda - June 1, 2023
Players Course
Prominent golf course architect John
Fought designed this Par 72
championship course in the spirit of
a classic American design style. The
7,376-yard course features wide
playing corridors, sculpted bunkers,
and traditional rectangular tee
boxes. The holes are oriented to
take full advantage of jaw-dropping
views of the surrounding mountains.
Fought used many of the mature
trees found on the original course to
impart the feel of a venerable facility while delivering a modern approach to golf course design. As a result, the Players Course was chosen to host the 2008 LG Skins Game in November 2008.
Summary of Strategic Goals and Priorities
The budget implements the Council’s priorities and strategic goals, provides a financial plan that continues delivering first-rate services, and is responsive to the community’s needs. The focus of a strategic plan is to outline the goals of the City Council for the community as a whole/organization over some time (one, three, or five years are typical). A Summary of Significant City Goals for the upcoming budget cycle is as follows:
Financial Goals
•Profitable before the amenity subsidy and after capital and maintenance expenses.
•Develop strategies to increase customers and check averages in all operations (e.g., Vue restaurant, banquets, golf, etc.).
•Identify opportunities to improve efficiency and operations to be more cost- effective while maintaining quality.
•Consider golf resort operating profits and energy savings from the new solar project to fund future capital needs.
•Refine the allocation of payroll in food and beverage operations. 3Page 296 of 359
City Council Agenda - June 1, 2023
Strategic Asset Plan Goals
•Authorize staff to develop more information on the possible upgrade to the Fairway Grill, banquet kitchen, and energy efficiency remodel of the pavilion and Golf Suites at the driving range.
•The Council expressed interest in negotiating with Renaissance Esmerelda on the possible sale of Hole 18 to offset the costs to redesign and relocate Holes 17 and 18 of the Player’s Course.
•Each Council will provide opinions and thoughts to the City Manager regarding the possible sale of holes 17 and 18.
•Identify opportunities to improve efficiencies in operations that generate savings for the Indian Wells Golf Resort while maintaining a first-class golf resort. •Develop a comprehensive marketing strategy that promotes the Indian Wells Golf Resort as a golf and special events destination for visitors, including local and drive markets.
o Improve advertising by adding Top Tracer to Shots in the Night and the Academy.
•Expand partnerships with local hotels to increase customers at the Indian Wells Golf Resort for golf, dining, and special events.
•Focus on driving more golf rounds and increasing banquets at the Indian Wells Golf Resort. These are the top two profit centers for the golf resort. •Examine possible rebranding of the Vue restaurant’s concept and menu, including a celebrity chef concept that targets all customers (e.g., golfers, residents, hotel guests, and local drive market).
•The Council authorized the City Manager to negotiate a new management agreement with Troon, with input from Council on policy decisions that need to be reflected in a new contract. If the City Manager is unsuccessful in negotiating a new contract, the City will give Troon notice and begin the RFP process. •New agreement negotiations to include policies to develop standards and expectations. It was the consensus of the Council to provide the City Manager with suggestions and feedback to develop negotiation strategies. If the City Manager and Troon cannot agree on a new agreement before June 30th, the staff is to notify Troon of the City’s intent to conduct an RFP process for management services of the Indian Wells Golf Resort.
4Page 297 of 359
City Council Agenda - June 1, 2023
Budget Overview
The Budget Document comprises both the Annual Operating Budget and the Capital Budget. The Operating Budget is the total budget used to finance all day-to-day operations and obligations of the Golf Resort.
The fiscal year 2023/24 Adopted Budget totals $18.6 million for all Golf operations.
Fiscal Year
2023-24
Budge t
Rounds 76,507
Covers 237,728
Total Revenues (Net of Golf Subsidy)19,613,644
Cost of Sales 3,177,065
Payroll 9,858,197
Operating Expenses 5,574,291
Total Operating 18,609,553
Net Operating Income before Capital 1,004,091
Capital Replacements 950,498
Net Operating Income After Capital 53,593
Indian Wells Golf Resort
Consolidated Budget Summary
Capital Budget Overview
The capital improvement plan includes sixteen projects budgeted for $950,498.
Capital Category Total Percentage
Buildings And Structures 29,300 3.1%
Clubhouse Equipment 20,000 2.1%
Golf Course Equipment 658,419 69.3%
Signage and Wayfinding 133,800 14.1%
Emergency 108,979 11.5%
Total Capital Replacements 950,498 100.0%
5Page 298 of 359
City Council Agenda - June 1, 2023
Conclusion
This Budget reflects the continuing effort by the City Council to have the City of Indian Wells engage in sound budget discipline and deliberate decision-making. As a result, the budget actions included in this document take serious steps to address a potentially weaker economic environment for the future.
Respectfully submitted,
Chris Freeland
City Manager
6Page 299 of 359
City Council Agenda - June 1, 2023
Indian Wells Golf Resort
Fiscal Year 2023-24 Budget
City Council Implementation Goals and Deliverables
1.Profitability
a.Golf Resorts should
be operated
profitably before the
Golf Amenity
Subsidy and after
capital expenditures.
2.General Fund Amenity
Subsidy
a.Specific to the
budget and monthly
financial statements,
the Amenity Subsidy shall be displayed as follows:
i.Golf Amenity subsidy – below the Net Income Line
ii.F&B and Merchandise – included in the Revenue line
3.Allocated payroll.
a.No allocated payroll based on revenue.
b.Each profit center shall be based on the staff working in the profit center.
In Troon’s terminology, this is known as direct payroll. c.The Consolidated summaries in Golf and F&B and the Consolidated Financial Report shall contain all payroll costs required to operate the programs.
d.Remove allocated payroll lines from the budget and the monthly financial statements.
i.Direct payroll only.
4.Projected Net Operating Income by Department
a.As a Goal, the Budget should project Net Income as a % of Revenue as follows:
i.Golf, including golf maintenance: 25% to 30%
ii.Merchandise: 27% to 33%
iii.VUE: 8% to 12%
1.Cost of sales goals around 30%
2.Labor goals around 50%
iv.Beverage Carts: 38% to 42%
v.Banquets: 30% to 35%
vi.Food Truck & SITN: 30% to 35%
7Page 300 of 359
City Council Agenda - June 1, 2023
vii.These expectations exclude costs associated with building maintenance and G&A and are calculated to maintain profitability before the golf amenity subsidy and after capital.
5.Operating strategies incorporated into the new budget. a.Operate as a profitable business every year.
i.This could include limiting operating times and services during unprofitable periods.
ii.Identify opportunities to reduce operating losses during the first half of the fiscal year.
iii. Develop a worst-case scenario budget for the period June through September.
b.Evaluate COS and labor controls consistent with brand standards and revenue expectations.
c.Develop strategies to implement efficiencies to decrease G&A and building maintenance and golf maintenance costs. The savings goal is 5%.
6.Capital Budgeting:
a.Capital budget is limited to the replacement of existing equipment. b.The City Council approves all other capital improvements. i.An initial ROI analysis with preliminary figures will be included for each new capital project for Council consideration as deemed appropriate.
ii.If Council provides investigative approval, the ROI analysis will be restated as design and construction figures are confirmed.
7.Development of the New Concepts, the Business Plan, and the Marketing Plan a.These plans, at a
minimum, should
include strategies to
capture the following:
i.Protect the
Brand – we
need to
attract the
right kind of
new rounds
and covers.
Maintain the
golf rate.
ii.Expand summer and shoulder seasons.
iii.Drive additional golf rounds in summer and shoulder seasons. iv.Increase VUE covers annually.
1.Increase resident covers by 10%
8Page 301 of 359
City Council Agenda - June 1, 2023
2.Increase golfer use by 30%.
3.Develop a VUE resident campaign.
4.Establish a local marketing campaign to encourage and attract new hotel guests, business lunches, and locals to support VUE.
v.Commit up to 1% of gross revenue to develop a local marketing plan budget.
b.New VUE concept
i.Work with Council to establish a new VUE identity.
9Page 302 of 359
City Council Agenda - June 1, 2023
1 BUSINESS PLAN
2023/2024 FISCAL
10
City Council Agenda - June 1, 2023
2 EXECUTIVE SUMMARY
I.Financial summary
II.Strategic direction
a.SWOT analysis
b.Competitive set
III.Key objectives
IV.Target segments & strategies
V.Organizational structure
11
City Council Agenda - June 1, 2023
3 I.FINANCIAL SUMMARY
12
City Council Agenda - June 1, 2023
4 II.STRATEGIC DIRECTION
In Fiscal 2022 /2023, Indian Wells Golf Resort had a record-breaking year. The three main reasons for this performance are the quality of the two golf courses, the quality of the team which, services individuals and groups that visit and experience The Indian Wells Golf Resort and the cache IWGR carries with golfers around the world.
Our vision for 2023/2024 encompasses continuing the momentum to generate positive financial outcome, building on the ‘IWGR’ brand and making IWGR and Indian Wells the ideal destination for residents and destination visitors from our main markets and the world. Increase golf ADR in all segments (except IW residents) Increase golf rounds in off-peak and shoulder seasons
Increase ADC in all Food & Beverage
Establish mid-week events business
Increase week-end social business
Drive Golfers to the VUE Bar & Grille and make it the Resident favorite of Indian Wells.
Focus will extend to the local community and market. IWGR’s world-class experience is a primary amenity for the local residents. Resident focused engagement will be through hyper-targeted events and experiences combined with elevated communication. 13
City Council Agenda - June 1, 2023
5 SWOT ANALYLIS
GOLF COMP SET
Club Location Distance Holes/Type Rates (Peak,
Shoulder, Off)
Renovations
(Year, Scope,
Cost)
Competitive Advantage
PGA West La Quinta,
CA. 10 miles Private, resort
and championship courses.
Peak Season from 10/1
through 5/1. Shoulder
from 5/1 to 6/1. Summer season from 6/1 through 9/30.
5/23 through 11/23
3 of 9 golf courses,
replacing greens and overall experience.
Hosts Amex Tournament, carries
cache as top destination for
golfers in The Western US.
Desert Willow
Palm
Desert, CA 7 miles 36 holes,
resort style
courses.
Peak Season from 10/1
through 5/1. Shoulder
from 5/1 to 6/1.
Summer season from 6/1 through 9/30.
All greens on Fires
Cliff’s course will be
renovated. Timeline
not yet set within 12months.
Top Muni course same as IWGR.
No distinct advantage.
Silver Rock
La Quinta, CA 10 miles 18 holes, resort/champi
onship course
Peak Season from 10/1 through 5/1. Shoulder
from 5/1 to 6/1.
Summer season from
6/1 through 9/30.
From 2021 – to now.
No end date for
renovation set.
None yet. Campus is in full construction with developer not yet securing funding to finish
project. 4 and 5 star hotel
properties with a full conference center and individual residences for purchase.
Classic Club Palm Desert, CA 5 miles 18 holes, championship course Peak Season from 10/1 through 5/1. Shoulder from 5/1 to 6/1. Summer season from 6/1 through 9/30.
TBD. Sister course to IWGR, great conditions and player experience. Hosts some of the top charity tournaments in Coachella Valley.
14
City Council Agenda - June 1, 2023
6 DINING COMP SET
Club/Restaurant Location Distance Cuisine Pricing
Tommy Bahama Palm Desert, El Paseo 3.5 miles Classic American and Mediterranean flair, big bar, prime location on El Paseo.
Lunch Avg. $35 Dinner Avg. $45
Eureka Highway 111, Indian Wells 2.0 miles Chain restaurant elevated experience American Food craft/local drinks Lunch Avg. $35 Dinner Avg. $35
Pacifica El Paseo, Palm Desert 3.4 miles Elevated Fine Dining – Seafood restaurant. 15 years in business, 3 private dining space options Lunch Avg. $45
Dinner Avg. $65
Beer Hunter Highway 111, Palm Desert 2.4 miles Classic American Sports Bar with pool tables, larges bars and sticky floors Lunch Avg. $25 Dinner Avg. $40
Cliff House Highway 111, La Quinta 2.1 miles Fine Dining – Grille/Steak house – American Food, extensive wine list, multiple private dining options Dinner Avg. $75
15
City Council Agenda - June 1, 2023
7 EVENTS COMP SET
Club Location Distance Site Fee Capacity Site Notes
Indian Wells Country Club Indian Wells, CA 1 mile $2 to $5k with $15k F&B Minimum 400 One of the original clubs in greater palm springs. Massive ballroom, great views.
The Living Desert Palm Desert 5 miles Fee’s start at $3k. 12 different event spaces. 500 Building a 500 person indoor event facility. Completion in 2026.
La Quinta Resort La Quinta 5 miles $3.5k wedding fee, reduced to $1,750 off-season, Two venues:
one is up to 200 guess with a
$46k++ minimum. The second space is up to 300 guests with a $57k++ minimum. Bar and intermezzo included in all packages. Plated begins at $190++ p/p Buffet begins at $185++ p/p.
350 The original Desert getaway.
Showing its age and relations with
PGA West are ambiguous.
Acrisure Arena Palm Desert 5 miles From $5k to $250k
Up to 10,000 people. Indoor and
outdoor spaces. Dedicated secondary ice rink for public and events. 10,000
Newest space in the desert. Hosts
the CV Firebirds hockey team, concerts and various entertainments.
Desert Willow Golf Resort Palm Desert 7 miles $2.5k venue fee if under 50 guests. Otherwise, fee is waived. Packages start at $93++ up to $145++ Additional hours are $1k each. No F&B minimums. Venue is also their
restaurant.
300 Single level clubhouse with two well ranked courses. Large patio overlooking the golf courses for events. Lots of parking
Classic Club Palm Desert 5 miles NA 500
Large club house, lots of parking
16
City Council Agenda - June 1, 2023
8 KEY OBJECTIVES
#1 Increase golf ADR in all segments (except IW residents) a.Digital marketing
b.Print advertising
c.Media production
d.Pricing strategy
e.Revenue management
#2– Drive Golfers to the VUE Bar & Grille and make it the resident favorite. a.Establish VUE promotion program for outside services team b.Focus on using residents name from valet through cart return c.Communications: Promote VUE through golf cart media system and The Arrow resident newsletter
d.Establish VUE theme nights
e.Timely updates to menus and website
f.Social media campaign for local awareness
#4 – Increase ADC in all Food & Beverage
a.Evaluate comp set for Weddings
b.Approved menus to be used
c.Golf sales to promote F&B with all tournaments
d.Promotion of Theme nights at SITN and The VUE
17
City Council Agenda - June 1, 2023
9 #5– Establish mid-week events business
a.Create corporate event package
b.Create and publish ‘Events’ landing page on website
c.Marketing campaign for corp. events
#6 – Increase golf rounds in off-peak and shoulder seasons a.Continue to work with campus hotels for direct stay and play programs b.Continue with email marketing program to drive in markets c.Maximize tee sheet utilization year round – continue with dynamic pricing model. Continue to participate in Troon’s Revenue management program d.Create special offers bundling golf, F&B and other services to entice golfers during the summer
#6 – Increase weekend social business
a.Sales team will pro-actively market the weekend to local and destination groups
b.Create special offers for Friday and Sunday weddings
c.Create celebration of life program with tiered options and high quality tri-fold brochure
d.Restructure public facing side of ‘The Knot’, “Wedding Wire’ and here comes the guide
18
City Council Agenda - June 1, 2023
10 Target Markets
1.Residents & Locals
2.Destination Golfers
3.Group Golf
4.Troon Golfers
5.Social & Other Catering
6.VUE Bar & Grille
19
City Council Agenda - June 1, 2023
11 TARGET SEGMENT 1
Residents | local marketing
1.Localized digital campaign
2.Local TV ads
3.Enhanced communications
4.Local radio
5.Visit Greater Palm Springs
6.Social media
TARGET SEGMENT 2
Destination golfers
1.Email Marketing Campaign
2.Professional Video Production
3.SEO/SEM Campaign
4.Social Media Marketing Campaign
5.Stay & Play Package Offerings
6.Leverage Print Publication Advertising
TARGET SEGMENT 3
Group Golf
1.Professional Collateral
2.Charity Golf Tournament Summit
3.Email Marketing Campaign
4.SEO/SEM Campaign
5.Social Media Marketing Campaign
6.Event Planner Toolbox
20
City Council Agenda - June 1, 2023
12 TARGET SEGMENT 4
Troon Golfers
1.Troon Card
2.Troon Rewards
3.Troon Advantage
4.Troon Email Blasts
5.Troon CA Co-Op
6.Troon Challenge
TARGET SEGMENT 5
Social & Other Catering
1.Professional Collateral
7.Email Marketing Campaign
8.SEO/SEM Campaign
9.Social Media Marketing Campaign
10.Stage event summit
TARGET SEGMENT 6
VUE Bar & Grille
1.Professional Collateral
2. Email marketing
3. Seo/Sem campaign
4.Social media marketing
21
City Council Agenda - June 1, 2023
13 Organizational Structure
Sven Wiedenhaupt
General Manager
Joe Williams
Director of Golf
# of Managers = 8
# of Associates = 23
Lorean Vargas
Interim F&B Director
# of Managers = 3
# of Associates = 63
Nick Leitner
Superintendent
# of Managers = 4
# 44 Associates = 32
Ben Rodny
Director of S&M
# of Event Sales=2
# of Golf Sales=2
# of Concierge = 3
Danette Perotta
Dir. of Finance
Nona Howard
Admin Staff
# of Managers = 1
# of Associates = 1
22
City Council Agenda - June 1, 2023
SALES AND MARKETING PLAN 2023
IND
I
A
N
W
E
L
L
S
G
O
L
F
R
E
S
O
R
T
SAL
E
S
&
M
A
R
K
E
T
I
N
G
P
L
A
N
2 0
2 3
Indian Wells Golf Resort
23Page 316 of 359
City Council Agenda - June 1, 2023
IND
I
A
N
W
E
L
L
S
G
O
L
F
R
E
S
O
R
T
SA
L
E
S
&
M
A
R
K
E
T
I
N
G
P
L
A
N
2 0
2 3
Plan Overview
Strategic Direction
SWOT Analysis
Competitive Set
Target Markets
This Sales & Marketing Plan
compliments the IWGR Business
Plan in outlining the following for
our defined target markets:
-Strategy
-Tactics
24Page 317 of 359
City Council Agenda - June 1, 2023
INDIAN WELLS GOLF RESORT SALES & MARKETING PLAN 2023
STRATEGIC DIRECTION
Increase golf ADR in all segments (except IW residents) Increase golf rounds in off-peak and shoulder seasons
Increase ADC in all Food & Beverage
Establish mid-week events business
Increase week-end social business
Drive Golfers to the VUE Bar & Grille and make it the Resident favorite of Indian Wells.
Our Strategic Direction for 2023/2024 is continuing the momentum to generate positive financial outcomes. Our objectives include:
This plan defines the markets we plan to target in pursuit of these objectives along with the supporting strategies and tactics that will be used.
25
City Council Agenda - June 1, 2023
SWOT ANALYSIS
26Page 319 of 359
City Council Agenda - June 1, 2023
IND
I
A
N
W
E
L
L
S
G
O
L
F
R
E
S
O
R
T
SA
L
E
S
&
M
A
R
K
E
T
I
N
G
P
L
A
N
2 0
2 3
GOLF COMP SET
27Page 320 of 359
City Council Agenda - June 1, 2023
IND
I
A
N
W
E
L
L
S
G
O
L
F
R
E
S
O
R
T
SA
L
E
S
&
M
A
R
K
E
T
I
N
G
P
L
A
N
2 0
2 3
DINING COMP SET
28Page 321 of 359
City Council Agenda - June 1, 2023
IND
I
A
N
W
E
L
L
S
G
O
L
F
R
E
S
O
R
T
SA
L
E
S
&
M
A
R
K
E
T
I
N
G
P
L
A
N
2 0
2 3
EVENTS COMP SET
29Page 322 of 359
City Council Agenda - June 1, 2023
IND
I
A
N
W
E
L
L
S
G
O
L
F
R
E
S
O
R
T
SA
L
E
S
&
M
A
R
K
E
T
I
N
G
P
L
A
N
2 0
2 3
TARGET MARKETS
1.Residents / Locals
2.Destination Golfers
3.Group Golf
4.Troon Golfers
5.Social & Other Catering
6.VUE Bar & Grille
30Page 323 of 359
City Council Agenda - June 1, 2023
RESIDENT AND LOCALS
31Page 324 of 359
City Council Agenda - June 1, 2023
DESTINATION GOLFERS
32Page 325 of 359
City Council Agenda - June 1, 2023
GROUP GOLF
CUSTOMERS
33Page 326 of 359
City Council Agenda - June 1, 2023
TROON GOLFERS
34Page 327 of 359
City Council Agenda - June 1, 2023
VUE BAR AND GRILL
CUSTOMERS
35Page 328 of 359
City Council Agenda - June 1, 2023
36Page 329 of 359
City Council Agenda - June 1, 2023
INDIAN WELLS GOLF RESORT
ORGANIZATIONAL CHART 2023/2024
City Mgr -Chris
Feeland
General Manager
Sven Wiedenhaupt
Dir of Finance
Danette
Perrotta
Joe Williams -
Dir of Golf
Tom Burley
Head Golf Pro
Pam Vincent
Merchandise
Mgr
Dir of
Agronomy
Nick Lietner
Director of F &
B
Lorena Vargas
Asst Dir of FB
Earl Schryver
F & B Mgr
TBD
F & B Mgr
TBD
Exec Chef
Juan Leon
Banquet Mgr
Robert Reyes
Facilities Mgr.
George Edward
Dir. of
Sales/Mkt
Ben Rodny
Sales Manager
Sharon Clark
Sales Manager
Beth
Widdowson
Sales Manager
Jenny Poland
HR Coorindator
Nona Howard
Troon Golf -Bill
O'Brien
37Page 330 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance ROUNDS 76,507 76,057 450 76,500 7
COVERS 237,728 232,611 5,117 151,469 86,259
REVENUES
GOLF FEES 9,449,314 8,865,359 583,955 8,001,548 1,447,767 MERCHANDISE 1,720,937 1,638,844 82,092 1,574,523 146,414 FOOD & BEVERAGE 7,765,631 6,910,682 854,950 5,943,966 1,821,665 RANGE, RENTAL & OTHER 3,414,646 3,356,582 58,064 2,756,285 658,361 TOTAL REVENUES 22,350,528 20,771,467 1,579,061 18,276,322 4,074,206
COST OF SALES
COS - MERCHANDISE 936,436 882,467 53,969 819,737 116,699 AS % OF REVENUE 54.41%53.85%0.57%52.06%2.35%
COS - FOOD & BEVERAGE 2,059,114 1,799,201 259,913 1,621,166 437,948 AS % OF REVENUE 26.52%26.04%0.48%27.27%-0.76%
GOLF COS 181,515 183,231 (1,716) 208,030 (26,514)
AS % OF REVENUE 1.17%1.23%-0.06%1.61%-0.45%
TOTAL COST OF SALES 3,177,065 2,864,899 312,166 2,648,932 528,133 AS % OF REVENUE 14.21%13.79%0.42%14.49%-0.28%
GROSS MARGIN 19,173,463 17,906,568 1,266,895 15,627,390 3,546,073
PAYROLL
PAYROLL 9,858,197 9,345,897 512,300 7,813,446 2,044,751 TOTAL PAYROLL 9,858,197 9,345,897 512,300 7,813,446 2,044,751 AS % OF REVENUE 44.11%44.99%-0.89%42.75%1.36%
OPERATING EXPENSES
OPERATING EXPENSES 5,574,291 5,341,999 232,293 4,808,841 765,450 TOTAL OPERATING EXPENSES 5,574,291 5,341,999 232,293 4,808,841 765,450 AS % OF REVENUE 24.94%25.72%-0.78%26.31%-1.37%
NET OPERATING INCOME 3,740,975 3,218,672 522,303 3,005,103 735,872 AS % OF REVENUE 16.74%15.50%1.24%16.44%0.30%
RESIDENT AMENITY
RESIDENT DISCOUNTS AMENITY - - 0 - -
RESIDENT GREEN FEE AMENITY 2,736,884 2,730,947 5,937 2,189,611 547,273 TOTAL RESIDENT AMENITY 2,736,884 2,730,947 5,937 2,189,611 547,273 AS % OF REVENUE 12.25%13.15%-0.90%11.98%0.26%
NET OPERATING INCOME W/O AMENITY 1,004,091 487,725 516,366 815,492 188,599 AS % OF REVENUE 4.49%2.35%2.14%4.46%0.03%
ROU LEASE DEPRECIATION EXPENSES
ROU LEASE DEPRECIATION EXPENSES 154,587 161,776 (7,189) 212,434 (57,847) TOTAL ROU LEASE DEPRECIATION EXPENSES 154,587 161,776 (7,189) 212,434 (57,847) AS % OF REVENUE 0.69%0.78%-0.09%1.16%-0.47%
NET INCOME AFTER DEPRECIATION 849,504 325,950 523,554 603,058 246,445 AS % OF REVENUE 3.80%1.57%2.23%3.30%0.50%
PAYROLL STATS:
FULL TIME EQUIVILANCE 154.94 149.25 5.69 1 40.95 13.9 9
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
CONSOLIDATED
38
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance ROUNDS
RESIDENT ROUNDS 18,403 18,403 - 18,271 132
RESIDENT GUEST ROUNDS 4,624 4,624 - 4,671 (47)
TOURAMENT/GROUP ROUNDS 15,562 15,562 - 17,273 (1,711) ALL OTHER ROUNDS 37,918 37,468 450 36,285 1,633 TOTAL ROUNDS 76,507 76,057 450 76,500 7
AVERAGE PER ROUND 123.51 116.56 6.95 104.60 18.91
REVENUES
RESIDENT REVENUE 773,332 771,064 2,268 766,610 6,722 RESIDENT GUEST REVENUE 479,114 475,219 3,896 485,282 (6,167) TOURNAMENT/GROUP REVENUE 2,206,367 2,054,798 151,568 1,945,343 261,023 ALL OTHER GOLF FEE REVENUE 5,990,502 5,564,278 426,223 4,804,313 1,186,189 GOLF FEE REVENUES 9,449,314 8,865,359 583,955 8,001,548 1,447,767
OTHER GOLF REVENUES
MERCHANDISE REVENUE 1,720,937 1,638,844 82,092 1,574,523 146,414 RANGE, RENTAL & OTHER REVENUE 446,408 432,873 13,535 387,864 58,544 GOLF ACADEMY 215,056 166,977 48,080 142,672 72,384 TOTAL OTHER GOLF REVENUES 2,382,401 2,238,694 143,707 2,105,059 277,342 TOTAL GOLF REVENUES 11,831,715 11,104,053 727,662 10,106,607 1,725,108
COST OF SALES
COST OF SALES - MERCHANDISE 936,192 882,467 53,725 819,737 116,455 COST OF SALES - RANGE, RENTAL & OTHER 93,372 91,098 2,274 112,610 (19,238) COST OF SALES - GOLF ACADEMY 88,143 92,133 (3,990) 95,419 (7,276) TOTAL COST OF SALES 1,117,707 1,065,699 52,008 1,027,766 89,941 AS % OF REVENUE 9.45%9.60%-0.15%10.17%-0.72%
GROSS MARGIN 10,714,008 10,038,355 675,653 9,078,841 1,635,168
PAYROLL
PAYROLL 4,408,251 4,200,056 208,195 3,305,860 1,102,391 TOTAL PAYROLL 4,408,251 4,200,056 208,195 3,305,860 1,102,391 AS % OF REVENUE 37.26%37.82%-0.57%32.71%4.55%
OPERATING EXPENSES
OPERATING EXPENSES 3,110,835 2,986,374 124,461 2,813,698 297,138 TOTAL OPERATING EXPENSES 3,110,835 2,986,374 124,461 2,813,698 297,138 AS % OF REVENUE 26.29%26.89%-0.60%27.84%-1.55%
NET OPERATING INCOME 3,194,922 2,851,925 342,997 2,959,283 235,639 AS % OF REVENUE 27.00%25.68%1.32%29.28%-2.28%
RESIDENT AMENITY
RESIDENT GREEN FEE AMENITY 2,723,386 2,717,450 5,936 2,173,069 550,317 TOTAL RESIDENT AMENITY 2,723,386 2,717,450 5,936 2,173,069 550,317 AS % OF REVENUE 23.02%24.47%-1.45%21.50%1.52%
NET OPERATING INCOME W/ AMENITY 5,918,308 5,569,375 348,933 5,132,352 785,956 AS % OF REVENUE 50.02%50.16%-0.14%50.78%-0.76%
ROU LEASE DEPRECIATION EXPENSES
ROU LEASE DEPRECIATION EXPENSES 151,011 158,831 (7,820) 206,704 (55,692) TOTAL ROU LEASE DEPRECIATION EXPENSES 151,011 158,831 (7,820) 206,704 (55,692) NET INCOME AFTER DEPRECIATION 5,767,297 5,410,544 356,753 4,925,649 841,648 PAYROLL STATS:
FULL TIME EQUIVILANCE 74.09 71.8 7 2.22 67.0 4 7.05
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
GOLF, GOLF ACADEMY, MERCHANDISE AND GOLF MAINTENANCE
39Page 332 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance ROUNDS
RESIDENT ROUNDS 18,403 18,403 - 18,271 132
RESIDENT GUEST ROUNDS 4,624 4,624 - 4,671 (47)
TOURNAMENT/GROUP ROUNDS 15,562 15,562 - 17,273 (1,711) ALL OTHER ROUNDS 37,918 37,468 450 36,285 1,633 TOTAL ROUNDS 76,507 76,057 450 76,500 7
AVERAGE PER ROUND 123.51 116.56 6.95 104.60 18.91
REVENUES
RESIDENT REVENUE 773,332 771,064 2,268 766,610 6,722 RESIDENT GUEST REVENUE 479,114 475,219 3,896 485,282 (6,167) TOURNAMENT/GROUP REVENUE 2,206,367 2,054,798 151,568 1,945,343 261,023 ALL OTHER GOLF FEE REVENUE 5,990,502 5,564,278 426,223 4,804,313 1,186,189 GOLF FEE REVENUES 9,449,314 8,865,359 583,955 8,001,548 1,447,767
OTHER GOLF REVENUES
RANGE, RENTAL & OTHER REVENUE 446,408 432,873 13,535 387,864 58,544 GOLF ACADEMY 215,056 166,977 48,080 142,672 72,384 TOTAL OTHER GOLF REVENUES 661,464 599,850 61,614 530,536 130,928 TOTAL GOLF REVENUES 10,110,778 9,465,209 645,569 8,532,084 1,578,695
COST OF SALES
COST OF SALES - RANGE, RENTAL & OTHER 93,372 91,098 2,274 112,610 (19,238) COST OF SALES - GOLF ACADEMY 88,143 92,133 (3,990) 95,419 (7,276) TOTAL COST OF SALES 181,515 183,231 (1,716) 208,030 (26,514) AS % OF REVENUE 1.80%1.94%-0.14%2.44%-0.64%
GROSS MARGIN 9,929,263 9,281,978 647,285 8,324,054 1,605,209
PAYROLL
PAYROLL 1,780,442 1,773,618 6,824 1,440,512 339,930 TOTAL PAYROLL 1,780,442 1,773,618 6,824 1,440,512 339,930 AS % OF REVENUE 17.61%18.74%-1.13%16.88%0.73%
OPERATING EXPENSES
OPERATING EXPENSES 944,507 933,228 11,280 843,306 101,201 TOTAL OPERATING EXPENSES 944,507 933,228 11,280 843,306 101,201 AS % OF REVENUE 9.34%9.86%-0.52%9.88%-0.54%
NET OPERATING INCOME 7,204,314 6,575,132 629,182 6,040,237 1,164,077 AS % OF REVENUE 71.25%69.47%1.79%70.79%0.46%
RESIDENT AMENITY
RESIDENT GREEN FEE AMENITY 2,723,386 2,717,450 5,936 2,173,069 550,317 TOTAL RESIDENT AMENITY 2,723,386 2,717,450 5,936 2,173,069 550,317 AS % OF REVENUE 26.94%28.71%-1.77%25.47%1.47%
NET OPERATING INCOME W/AMENITY 9,927,700 9,292,582 635,118 8,213,306 1,714,394 AS % OF REVENUE 98.19%98.18%0.01%96.26%1.93%
ROU LEASE DEPRECIATION EXPENSES
ROU LEASE DEPRECIATION EXPENSES 77,047 80,105 (3,058) 125,925 (48,878) TOTAL ROU LEASE DEPRECIATION EXPENSES 77,047 80,105 (3,058) 125,925 (48,878) NET INCOME AFTER DEPRECIATION 9,850,653 9,212,477 638,177 8,087,381 1,763,273 PAYROLL STATS:
FULL TIME EQUIVILANCE 32.13 32.69 (0.56) 29.30 2.83
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
GOLF & GOLF ACADEMY
40Page 333 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance
REVENUES
MERCHANDISE REVENUE 1,720,937 1,638,844 82,092 1,574,523 146,414 TOTAL REVENUES 1,720,937 1,638,844 82,092 1,574,523 146,414 AVERAGE PER ROUND 22.49 21.55 0.95 20.58 1.91
COST OF SALES
COST OF SALES 936,192 882,467 53,725 819,737 116,455
TOTAL COST OF SALES 936,192 882,467 53,725 819,737 116,455 AS % OF REVENUE 54.40%53.85%0.55%52.06%2.34%
GROSS MARGIN 784,745 756,377 28,368 754,786 29,959
PAYROLL
PAYROLL 240,338 218,446 21,891 189,440 50,898
TOTAL PAYROLL 240,338 218,446 21,891 189,440 50,898
AS % OF REVENUE 13.97%13.33%0.64%12.03%1.93%
OPERATING EXPENSES
OPERATING EXPENSES 18,981 16,638 2,343 35,128 (16,147)
TOTAL OPERATING EXPENSES 18,981 16,638 2,343 35,128 (16,147) AS % OF REVENUE 1.10%1.02%0.09%2.23%-1.13%
NET OPERATING INCOME 525,426 521,293 4,134 530,218 (4,792) AS % OF REVENUE 30.53%31.81%-1.28%33.67%-3.14%
PAYROLL STATS:
FULL TIME EQUIVILANCE 3.54 3.50 0.04 3.19 0.35
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
MERCHANDISE
41Page 334 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance
PAYROLL
PAYROLL 2,387,471 2,207,991 179,480 1,675,908 711,563 TOTAL PAYROLL 2,387,471 2,207,991 179,480 1,675,908 711,563
OPERATING EXPENSES
OPERATING EXPENSES 1,475,064 1,385,459 89,605 1,303,276 171,788 TOTAL OPERATING EXPENSES 1,475,064 1,385,459 89,605 1,303,276 171,788
UTILITIES
UTILITIES 672,038 651,049 20,989 631,987 40,050
TOTAL UTILITIES 672,038 651,049 20,989 631,987 40,050
NET OPERATING INCOME (LOSS)4,534,573 4,244,500 290,074 3,611,172 923,402
ROU LEASE DEPRECIATION EXPENSES
ROU LEASE DEPRECIATION EXPENSES 73,965 78,726 (4,761) 80,779 (6,814) TOTAL ROU LEASE DEPRECIATION EXPENSES 73,965 78,726 (4,761) 80,779 (6,814) NET INCOME (LOSS) AFTER DEPRECIATION (4,608,538) (4,323,226) (285,312) (3,691,950) (916,587) PAYROLL STATS:
FULL TIME EQUIVILANCE 38.42 35.67 2.75 34.55 3.87
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
GOLF COURSE MAINTENANCE
42Page 335 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance
PAYROLL
PAYROLL 623,579 573,731 49,848 502,758 120,820
TOTAL PAYROLL 623,579 573,731 49,848 502,758 120,820
OPERATING EXPENSES
OPERATING EXPENSES 121,106 128,817 (7,711) 197,626 (76,520) TOTAL OPERATING EXPENSES 121,106 128,817 (7,711) 197,626 (76,520)
UTILITIES
UTILITIES 414,563 406,763 7,800 389,736 24,827
TOTAL UTILITIES 414,563 406,763 7,800 389,736 24,827
NET INCOME (LOSS)(1,159,247) (1,109,311) (49,937) (1,090,120) (69,127) PAYROLL STATS:
FULL TIME EQUIVILANCE 9.29 8.84 0 .45 8 .85 0 .44
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
BUILDING
43Page 336 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance
OTHER NON-OPERATING INCOME
OTHER NON-OPERATING INCOME 29,019 38,565 (9,546) 51,848 (22,829) TOTAL OTHER NON-OPERATING INCOME 29,019 38,565 (9,546) 51,848 (22,829)
PAYROLL
PAYROLL 1,592,506 1,421,894 170,612 1,219,574 372,932 TOTAL PAYROLL 1,592,506 1,421,894 170,612 1,219,574 372,932
OPERATING EXPENSES
OPERATING EXPENSES 965,951 958,815 7,136 706,219 259,732 TOTAL OPERATING EXPENSES 965,951 958,815 7,136 706,219 259,732 NET OPERATING INCOME (2,529,438) (2,342,143) (187,295) (1,873,945) (655,493)
ROU LEASE DEPRECIATION EXPENSES
ROU LEASE DEPRECIATION EXPENSES 3,576 2,559 1,016 2,843 733 TOTAL ROU LEASE DEPRECIATION EXPENSES 3,576 2,559 1,016 2,843 733 NET INCOME (LOSS) AFTER DEPRECIATION (2,533,014) (2,344,703) (188,311) (1,876,788) (656,226) PAYROLL STATS:
FULL TIME EQUIVILANCE 13.90 11.17 2.73 10.41 3.49
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
GENERAL & ADMINISTRATIVE
44Page 337 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance COVERS
COVERS 230,050 225,631 4,419 145,240 84,810
COVERS - RESIDENT 7,678 6,980 698 6,229 1,449
TOTAL COVERS 237,728 232,611 5,117 151,469 86,259
AVERAGE PER COVER 32.67 29.71 2.96 39.24 (6.58)
REVENUES
FOOD & BEVERAGE REVENUE 7,765,631 6,910,682 854,950 5,943,966 1,821,665 TOTAL REVENUES 7,765,631 6,910,682 854,950 5,943,966 1,821,665
COST OF SALES
COST OF SALES 2,059,114 1,799,201 259,913 1,621,166 437,948 TOTAL COST OF SALES 2,059,114 1,799,201 259,913 1,621,166 437,948 AS % OF REVENUE 26.52%26.04%0.48%27.27%-0.76%
GROSS MARGIN 5,706,517 5,111,481 595,036 4,322,800 1,383,717
PAYROLL
PAYROLL 3,233,861 3,150,217 83,644 2,785,254 448,607
TOTAL PAYROLL 3,233,861 3,150,217 83,644 2,785,254 448,607 AS % OF REVENUE 41.64%45.58%-3.94%46.86%-5.22%
OPERATING EXPENSES
OPERATING EXPENSES 961,304 860,484 100,820 700,716 260,587 TOTAL OPERATING EXPENSES 961,304 860,484 100,820 700,716 260,587 AS % OF REVENUE 12.38%12.45%-0.07%11.79%0.59%
NET OPERATING INCOME 1,511,352 1,100,780 410,572 836,830 674,523 AS % OF REVENUE 19.46%15.93%3.53%14.08%5.38%
ROU LEASE DEPRECIATION EXPENSES
ROU LEASE DEPRECIATION EXPENSES - 386 (386) 2,887 (2,887) TOTAL ROU LEASE DEPRECIATION EXPENSES - 386 (386) 2,887 (2,887) AS % OF REVENUE 0.00%0.01%-0.01%0.05%-0.05%
NET INCOME AFTER DEPRECIATION 1,511,352 1,100,395 410,958 833,943 677,410 AS % OF REVENUE 19.46%15.92%3.54%14.03%5.43%
PAYROLL STATS:
FULL TIME EQUIVILANCE 57.66 57.3 8 0.28 54 .6 6 3.00
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
FOOD & BEVERAGE CONSOLIDATED
45Page 338 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance COVERS
COVERS - RESTAURANT 57,911 55,599 2,312 51,148 6,763
COVERS - RESIDENT 7,678 6,980 698 6,229 1,449
TOTAL COVERS 65,589 62,579 3,010 57,377 8,212
AVERAGE PER COVER 45.09 43.10 1.98 40.12 4.97
REVENUES
FOOD & BEVERAGE REVENUE 2,957,306 2,697,403 259,903 2,301,819 655,487 TOTAL REVENUES 2,957,306 2,697,403 259,903 2,301,819 655,487
COST OF SALES
COST OF SALES 872,255 841,242 31,013 787,937 84,318
TOTAL COST OF SALES 872,255 841,242 31,013 787,937 84,318 AS % OF REVENUE 29.49%31.19%-1.69%34.23%-4.74%
GROSS MARGIN 2,085,051 1,856,161 228,890 1,513,881 571,169
PAYROLL
PAYROLL 1,478,380 1,859,725 (381,345) 1,703,996 (225,616) TOTAL PAYROLL 1,478,380 1,859,725 (381,345) 1,703,996 (225,616) AS % OF REVENUE 49.99%68.95%-18.95%74.03%-24.04%
OPERATING EXPENSES
OPERATING EXPENSES 356,810 332,418 24,392 295,533 61,278 TOTAL OPERATING EXPENSES 356,810 332,418 24,392 295,533 61,278 AS % OF REVENUE 12.07%12.32%-0.26%12.84%-0.77%
NET OPERATING INCOME 249,861 (335,982) 585,843 (485,647) 735,508 AS % OF REVENUE 8.45%-12.46%20.90%-21.10%29.55%
ALLOCATED PAYROLL
ALLOCATED PAYROLL - (735,426) 735,426 (695,435) 695,435 TOTAL ALLOCATED PAYROLL - (735,426) 735,426 (695,435) 695,435 NET INCOME W/ ALLOCATED PAYROLL 249,861 399,444 (149,583) 209,788 40,073 AS % OF REVENUE 8.45%14.81%-6.36%9.11%-0.67%
PAYROLL STATS:
FULL TIME EQUIVILANCE 29.43 35.1 8 (5.7 5) 34.2 0 (4.7 7)
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
VUE GRILLE & BAR
46Page 339 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance COVERS
COVERS - BEV CART/SNACK BAR 76,507 76,057 450 68,841 7,666 TOTAL COVERS 76,507 76,057 450 68,841 7,666
AVERAGE PER COVER 9.90 8.62 1.28 9.05 0.84
REVENUES
FOOD & BEVERAGE REVENUE 757,041 655,517 101,525 623,138 133,903 TOTAL REVENUES 757,041 655,517 101,525 623,138 133,903
COST OF SALES
COST OF SALES 178,889 156,335 22,554 142,584 36,304
TOTAL COST OF SALES 178,889 156,335 22,554 142,584 36,304 AS % OF REVENUE 23.63%23.85%-0.22%22.88%0.75%
GROSS MARGIN 578,153 499,182 78,971 480,554 97,599
PAYROLL
PAYROLL 209,204 145,938 63,266 158,367 50,838
TOTAL PAYROLL 209,204 145,938 63,266 158,367 50,838
AS % OF REVENUE 27.63%22.26%5.37%25.41%2.22%
OPERATING EXPENSES
OPERATING EXPENSES 81,103 70,427 10,675 69,321 11,781
TOTAL OPERATING EXPENSES 81,103 70,427 10,675 69,321 11,781 AS % OF REVENUE 10.71%10.74%-0.03%11.12%-0.41%
NET OPERATING INCOME 287,846 282,816 5,029 252,866 34,980 AS % OF REVENUE 38.02%43.14%-5.12%40.58%-2.56%
ALLOCATED PAYROLL
ALLOCATED PAYROLL - 147,829 (147,829) 132,032 (132,032) TOTAL ALLOCATED PAYROLL - 147,829 (147,829) 132,032 (132,032) NET INCOME W/PAYROLL ALLOCATED 287,846 134,987 152,858 120,834 167,012 AS % OF REVENUE 38.02%20.59%17.43%19.39%18.63%
PAYROLL STATS:
FULL TIME EQUIVILANCE 4.31 3.14 1.17 3.46 0.85
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
BEVERAGE CARTS
47Page 340 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance COVERS
COVERS - BANQUET 19,125 19,037 88 25,251 (6,126)
TOTAL COVERS 19,125 19,037 88 25,251 (6,126)
AVERAGE PER COVER 137.64 125.68 11.96 97.02 40.62
REVENUES
FOOD & BEVERAGE REVENUE 2,632,304 2,392,566 239,737 2,449,750 182,553 TOTAL REVENUES 2,632,304 2,392,566 239,737 2,449,750 182,553
COST OF SALES
COST OF SALES 729,219 590,824 138,395 579,301 149,918
TOTAL COST OF SALES 729,219 590,824 138,395 579,301 149,918 AS % OF REVENUE 27.70%24.69%3.01%23.65%4.06%
GROSS MARGIN 1,903,084 1,801,742 101,342 1,870,449 32,636
PAYROLL
PAYROLL 771,330 731,037 40,293 753,248 18,082
TOTAL PAYROLL 771,330 731,037 40,293 753,248 18,082
AS % OF REVENUE 29.30%30.55%-1.25%30.75%-1.45%
OPERATING EXPENSES
OPERATING EXPENSES 258,649 253,852 4,797 278,681 (20,032) TOTAL OPERATING EXPENSES 258,649 253,852 4,797 278,681 (20,032) AS % OF REVENUE 9.83%10.61%-0.78%11.38%-1.55%
NET OPERATING INCOME 873,105 816,853 56,252 838,520 34,585 AS % OF REVENUE 33.17%34.14%-0.97%34.23%-1.06%
ALLOCATED PAYROLL
ALLOCATED PAYROLL - 434,624 (434,624) 476,568 (476,568) TOTAL ALLOCATED PAYROLL - 434,624 (434,624) 476,568 (476,568) NET INCOME W/ALLOCATED PAYROLL 873,105 382,229 490,876 361,952 511,153 AS % OF REVENUE 33.17%15.98%17.19%14.78%18.39%
PAYROLL STATS:
FULL TIME EQUIVILANCE 11.11 11.1 3 (0.0 2) 13.2 8 (2.1 7)
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
BANQUET & CATERING
48Page 341 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance COVERS
COVERS - FOOD TRUCK 76,507 74,938 1,569 - 76,507
TOTAL HOURS AND COVERS 76,507 74,938 1,569 - 76,507
AVERAGE PER COVER 5.41 5.15 0.26 #DIV/0!#DIV/0!
REVENUES
FOOD & BEVERAGE REVENUE 413,875 385,958 27,917 446,495 (32,620) TOTAL REVENUES 413,875 385,958 27,917 446,495 (32,620)
COST OF SALES
COST OF SALES 103,617 94,972 8,645 111,343 (7,726)
TOTAL COST OF SALES 103,617 94,972 8,645 111,343 (7,726) AS % OF REVENUE 25.04%24.61%0.43%24.94%0.10%
GROSS MARGIN 310,259 290,987 19,272 335,152 (24,893)
PAYROLL
PAYROLL 180,571 184,790 (4,219) 118,299 62,272
TOTAL PAYROLL 180,571 184,790 (4,219) 118,299 62,272
AS % OF REVENUE 43.63%47.88%-4.25%26.50%17.13%
OPERATING EXPENSES
OPERATING EXPENSES 41,049 38,441 2,608 47,556 (6,508)
TOTAL OPERATING EXPENSES 41,049 38,441 2,608 47,556 (6,508) AS % OF REVENUE 9.92%9.96%-0.04%10.65%-0.73%
NET OPERATING INCOME 88,639 67,756 20,883 169,297 (80,658) AS % OF REVENUE 21.42%17.56%3.86%37.92%-16.50%
NET OPERATING INCOME W/AMENITY 88,639 67,756 20,883 169,297 (80,658) AS % OF REVENUE 21.42%17.56%3.86%37.92%-16.50%
ALLOCATED PAYROLL
ALLOCATED PAYROLL - 76,590 (76,590) 86,836 (86,836)
TOTAL ALLOCATED PAYROLL - 76,590 (76,590) 86,836 (86,836) NET INCOME W/ ALLOCATED PAYROLL 88,639 (8,834) 97,473 82,461 6,178 AS % OF REVENUE 21.42%-2.29%23.71%18.47%2.95%
PAYROLL STATS:
FULL TIME EQUIVILANCE 3.39 3.95 (0.5 6) 3.07 0 .32
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
FOOD TRUCK/CAFÉ 36
49Page 342 of 359
City Council Agenda - June 1, 2023
2023-24 Budget 2022-23 Actuals Variance 2021-22 Actuals Variance SITN ACTIVITY HOURS 3,807 2,699 1,109 871 2,936
TOTAL HOURS 3,807 2,699 1,109 871 2,936
AVERAGE PER HOUR 264.02 288.77 (24.75) 140.95 123.07
REVENUES
FOOD & BEVERAGE REVENUE 619,855 404,237 215,619 - 619,855 SHOTS IN THE NIGHT REVENUES 385,250 375,001 10,249 122,764 262,486 TOTAL REVENUES 1,005,105 779,237 225,868 122,764 882,341
COST OF SALES
COST OF SALES 175,135 115,827 59,307 - 175,135
TOTAL COST OF SALES 175,135 115,827 59,307 - 175,135
AS % OF REVENUE 17.42%14.86%2.56%0.00%17.42%
GROSS MARGIN 829,971 663,410 166,560 122,764 707,207
PAYROLL
PAYROLL 304,655 305,110 (455) 51,343 253,312
TOTAL PAYROLL 304,655 305,110 (455) 51,343 253,312
AS % OF REVENUE 30.31%39.15%-8.84%41.82%-11.51%
OPERATING EXPENSES
OPERATING EXPENSES 223,693 166,594 57,099 16,878 206,815 TOTAL OPERATING EXPENSES 223,693 166,594 57,099 16,878 206,815 AS % OF REVENUE 22.26%21.38%0.88%13.75%8.51%
NET OPERATING INCOME 301,623 191,706 109,917 54,543 247,080 AS % OF REVENUE 30.01%24.60%5.41%44.43%-14.42%
NET OPERATING INCOME W/AMENITY 301,623 191,706 109,917 54,543 247,080 AS % OF REVENUE 30.01%24.60%5.41%44.43%-14.42%
ALLOCATED PAYROLL
ALLOCATED PAYROLL - 18,861 (18,861) 9,099 (9,099)
TOTAL ALLOCATED PAYROLL - 18,861 (18,861) 9,099 (9,099) NET INCOME W/ ALLOCATED PAYROLL 301,623 172,844 128,778 45,444 256,179 AS % OF REVENUE 30.01%22.18%7.83%37.02%-7.01%
PAYROLL STATS:
FULL TIME EQUIVILANCE 6.59 5.98 0.61 1.98 4.61
INDIAN WELLS GOLF RESORT
2023-2024 BUDGET SUMMARY
SHOTS IN THE NIGHT
50Page 343 of 359
City Council Agenda - June 1, 2023
TROON
Indian Wells Golf Resort
Capital Expenditures 2023/24
Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Category Item Name Budget Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 TOTAL
CAPITAL REPLACEMENT
BUILDING AND STRUCTURES 29,300.00$ -$ 14,300.00$ -$ 15,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ 29,300.00$ -$
Golf Maintenance Bldg - Roof Repair 15,000.00$ 15,000.00$ 15,000.00$ - Replace north area/tee line Pavers Replace sinking pavers 14,300.00$ 14,300.00$ 14,300.00$ - -$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
CLUBHOUSE EQUIPMENT (KITCHEN/ PROSHOP)20,000.00$ 20,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 20,000.00$ - -$ -
Kitchen Exhaust/Make up air fans 20,000.00$ 20,000.00$ 20,000.00$ - -$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$
-$
-$
-$
-$
-$ -
-
GOLF COURSE EQUIPMENT (ANYTHING OUTSIDE)658,419.00$ -$ 172,902.00$ 151,493.00$ 16,200.00$ 189,925.00$ 44,823.00$ -$ -$ -$ -$ -$ 83,076.00$ 658,419.00$ - Sitting Benches for SITN/putting Green 16,200.00$ 16,200.00$ 16,200.00$ - Driving Range Safety Barrier netting 39,800.00$ 39,800.00$ 39,800.00$ - Power for Tee line @ driving range + Pavers 23,619.00$ 23,619.00$ 23,619.00$ - New Mats for the Range/Addl Turf 54,125.00$ 54,125 54,125.00$ - -$ -
Toro Reelmaster 3100 D Lease buy out 26,745.00$ 26,745.00$ 26,745.00$ - Toro Reelmaster 7000-d Lease buy out 56,331.00$ 56,331.00$ 56,331.00$ - Toro Work Trucks 4 trucks 135,800.00$ 135,800 -$ 135,800.00$ - Buffalo Debris Blowers 4 Blowers 47,015.00$ 47,015 47,015.00$ - John Deer 4052R Compact Tractor 47,143.00$ 47,143 47,143.00$ - John Deer 5060E Tractor 55,125.00$ 55,125 55,125.00$ - Debris Sweeper - Widenmann Super 600 111,693.00$ 111,693.00$ 111,693.00$ - Superintendents Carts -Carry All 502 3 Carts 44,823.00$ 44,823.00$ 44,823.00$ - -$ -
-$ -
-$ -
-
-$ -
ADMINISTRATIVE & MARKETING 133,800.00$ 21,550.00$ -$ 50,000.00$ 50,000.00$ -$ -$ -$ -$ -$ -$ -$ 12,250.00$ 133,800.00$ - Moden full featured VOIP System Phone system replacement 12,250.00$ 12,250.00$ 12,250.00$ - Digital Sigange for Clubhouse Lobby 21,550.00$ 21,550.00$ 21,550.00$ - Property Signage 100,000.00$ 50,000.00$ 50,000.00$ 100,000.00$ - -$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
GOLF COURSE IMPROVEMENTS (SANDTRAPS/ PUMPSTATATIONS/ REMODEL)- -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - -$ -
-$ -
-$ -
-$ -
-$ -
-$ -
-$ -
PAVILION ENHANCEMENTS -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - -$ -
-$ -
-$ -
-$ -
STRATEGIC PLANNING-BUSINESS SEGMENTS 108,979.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 17,316.00$ 108,979.00$ - -$ -
Contingueny Fund - Emergency 108,979.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 17,316.00$ 108,979.00$ - -$ -
-$ -
Subtotal 950,498.00$ 41,550.00$ 195,535.00$ 209,826.00$ 89,533.00$ 198,258.00$ 53,156.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 8,333.00$ 112,642.00$ 950,498.00$ Available Capital:950,498.00$ -
Variance - 0
51Page 344 of 359
City Council Agenda - June 1, 2023
Indian Wells Golf Resort
Budget 2023/2024 Assumptions
Consolidated
Department Budget 2023/24 Prior Year Variance %
Consolidated
Total Revenues 22,349,751$ 20,770,750$ 1,579,001$ 7.6% (Less) Amenity Fee (2,736,884)$ (2,730,947)$ (5,937)$ 0.2% Adjusted Revenues 19,612,867$ 18,039,803$ 1,573,064$ 8.7% NOI 3,740,198$ 3,217,956$ 522,242$ 16.2%33% flow thru Adjusted NOI w/o Amenity Fee 1,003,314$ 487,009$ 516,305$ 32.8% Flow thru PROFIT %5.1%2.7%0$ 89.5%
PROFIT TARGET %0.00%
52Page 345 of 359
City Council Agenda - June 1, 2023
IWGR Golf Agronomy
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
Rounds 76,507 76,057 450 0.6%450 Rounds up - August, Sept, June (non-resident rounds) Between 18 hole prime, non prime and Troon
Rate 123.51$ 116.56$ 6.95$ 6.0%7% net increase, except Resident, Guest and PGA cart Resulting in 6% overall rate increase
Green Fees 9,449,314$ 8,865,359$ 583,955$ 6.6%Increase 6.58% based on rounds and rate Group Services 155,620$ 151,613$ 4,007$ 2.6%$10 per tournament round - Full Year Range, Rental, Other 277,290$ 267,764$ 9,526$ 3.6%3% increase - $/round Resident Recapture 2,633,146$ 2,627,210$ 5,936$ 0.2%Flat to prior year - Difficult to budget based on new calculation Rate variance by hour of day, Day of week, by course
Total Golf Revenues 12,619,108$ 12,015,682$ 603,426$ 5.0% Golf Net W/O Amenity Fee 9,985,962$ 9,388,472$ 597,490$ 6.4% Total Payroll 1,666,224$ 1,586,832$ 79,392$ 5.0%FTE's flat year over year - 30.25 vs 30.23 % o revenue 13.2%13.2%No Valet July and August
Assumption that minimum wage will increase to $16/hr - Jan 1 Marissa 7% adjustment - full year additional $2000
Travel Expense 4,700$ 108$ 4,592$ 4251.9%Troon Leadship conf May; PGA Show Jan Advertising 332,437$ 330,509$ 1,928$ 0.6%
R & M Carts 33,000$ 26,252$ 6,748$ 25.7%Softwater water system install - $1000/mo TOTAL NOI LESS RESIDENT FEE 7,294,524$ 6,801,134$ 493,390$ 7.3% TOTAL AGRONOMY NOI (4,534,573)$ (4,244,500)$ (290,073)$ 6.8% ACADEMY - NOI 30$ (135,762)$ 135,792$ -100.0% NET NOI GOLF/MAINENANCE 2,759,981$ 2,420,872$ 339,109$ 14.0% TOTAL GOLF/MAINTENACE %27.64%25.79%
PROFIT TARGET %25.00%
Total Expense (4,534,573)$ (4,244,500)$ (290,073)$ 6.8% Payroll & Related 2,387,471$ 2,207,991$ 179,480$ 8.1%37 FTE >>> to 38 in November>> 39 in January>> 40 FTE in April Seminars 2,300$ 160$ 2,140$ 1337.5%GCSAA for Nick, Tylor, Teo, DPR - and Education R & M Equipment 170,424$ 159,277$ 11,147$ 7.0%7% increase for worn equipment R & M Pump Station 19,332$ 11,791$ 7,541$ 64.0%Cloudburst scheduled maintenance Contract Labor 452,576$ 397,889$ 54,687$ 13.7%Lake Maintenance $$58k Fertilizer & Chemicals 160,103$ 151,723$ 8,380$ 5.5%Actuals + increases from 3-20% Utilties 694,505$ 667,730$ 26,775$ 4.0% GOLF
AGRONOMY
53Page 346 of 359
City Council Agenda - June 1, 2023
IWGR Merchandise
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
Rounds 76,623 76,173 450 0.6%
Total Merchandise Revenues 1,720,937$ 1,638,844$ 82,093$ 5.0%4% ADR increase + Additional Rounds Merchandise ADR 22.46$ 21.51$ 0.95$ 4.4% Total Payroll & Related 240,338$ 218,446$ 21,892$ 10.0%Hourly rate adjustment $16 > $17 > $18 Travel Expense 2,000$ -$ 2,000$ 100.0%PGA Show Jan TOTAL NOI 525,182$ 521,293$ 3,889$ 0.7% NOI %30.5%31.8%-1.3%
City Target 28-32%
54Page 347 of 359
City Council Agenda - June 1, 2023
IWGR Building Maintenance.G A
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
TOTAL BLDG MAINT EXPENSE 1,159,247$ 1,109,311$ 49,936$ 4.5% City Target 1,053,845.45$ City requested 5% decrease year over year Difference to Target (105,402)$
Total Payroll & Related 623,579$ 573,731$ 49,848$ 8.7%Additional salary added mid Oct 2023 $20k Utilties 403,019$ 392,444$ 10,575$ 2.7%Slight increase year over year *Please note - Budget for 22/23 is $1,142,525
*Flat lined operating expnses with no price increases budgeted Budget 2023/24 Prior Year Variance %
TOTAL G & A EXPENSE 2,530,020$ 2,342,658$ 187,362$ 8.0% City Target 2,225,525.10$ City requested 5% decrease year over year Difference to Target (304,495)$
Other Revenue 29,019$ 38,565$ (9,546)$ -24.8%Will not have refund in new year Total Payroll & Related 1,592,506$ 1,421,894$ 170,612$ 12.0%Inventory supervisor added 9/1 - $7k Sales Managers rate adjustment 10.21.23 - 4K each;
Sales manager position empty 1 month
Acct mgr/Asst rate adjust $4/hr - $9k per year
Sales Admin positions added -+ 1 july; +1 Sept (Addl $6 k/year) Salary rate adjustments
Learning & Development Mgr - 7/1 $90k
Commissions - Decreased 1/2 with eliminated position ($50K) Additional Conceirge/Admin position
Employee Recognition 69,269$ 56,771$ 12,498$ 22.0%Employee Wellness & Retention program Recruiting & Relation -$ 78,037$ (78,037)$ -100.0% Other Professional fees 23,200$ 90,067$ (66,867)$ -74.2%Security for parking lot during peak periods Computer Related 225,638$ 100,792$ 124,846$ 123.9%$118k computer /server repacement, Troon email accounts, cedar creek Office Supplies 24,156$ 29,476$ (5,320)$ -18.0%Do not need expense for Receiving Cage Travel 23,800$ 16,983$ 6,817$ 40.1%$1500 Qtrly trip to Troon; Leadership conference: Troon onsite visits Management Fee 337,402$ 327,574$ 9,828$ 3.0%Annual increase 55Page 348 of 359
City Council Agenda - June 1, 2023
IWGR - F B Consolidated
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
Covers 237,960 233,962 3,998 1.7%
ADC 32.63$ 29.54$ 3.10$ 10.5% Total Revenues 7,765,631$ 6,910,682$ 854,949$ 12.4% TOTAL NOI 1,511,352$ 1,100,578$ 410,774$ 37.3%48% Flow thru PROFIT %19.5%15.9%0$ 22.2%
PROFIT TARGET %0.00%
56Page 349 of 359
City Council Agenda - June 1, 2023
Vue Restaurant
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
Total Covers 65,589 62,579 3,010 4.8%Summer covers adjusted, 3.5% increase balance of the year Resident Covers 7,678 6,980 698 10.0%10% increase Per Directive of COIW ADC 43.62$ 41.50$ 2.12$ 5.1%3% increase ADC starting oct 1 Total Revenues 2,957,306$ 2,697,403$ 259,903$ 9.6%Based upon increase of covers and ADC Cost of Sales 872,255$ 841,242$ 31,013$ 3.7% % of Revenue 29.5%31.2%Xfer 5% of Food COS to Banquets
Payroll & Related 1,478,380$ 1,124,299$ 354,081$ 31.5%Elimination of Allocated payroll; .5% increase in payroll taxes for declared tips % of Revenue 50.0%41.7%
Operating Expenses 356,810$ 332,418$ 24,392$ 7.3% % of Revenue 40.9%39.5%
TOTAL NOI 249,861$ 399,444$ (149,583)$ -37.4% NOI%8.4%14.8%(0)$ -42.9%
NOI TARGET %8.0%
57Page 350 of 359
City Council Agenda - June 1, 2023
Beverage Cart
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
Total Covers/Rounds 76,623 76,173 450 0.6%
ADC 9.88$ 8.61$ 1.27$ 14.8% Total Revenues 757,041$ 655,517$ 101,524$ 15.5%6% ADC increase + Cool Cart ($18k rental + $160/day for 8 mos. = $38.4K) Cost of Sales 178,899$ 156,335$ 22,564$ 14.4% % of Revenue 23.6%23.8%
Payroll & Related 209,204$ 293,767$ (84,563)$ -28.8%Elimination of Allocated payroll; Added .33 FTE of mgr; .5 FTE Supervisor % of Revenue 27.6%44.8%
Operating Expenses 81,092$ 70,428$ 10,664$ 15.1% % of Revenue 45.3%45.0%
TOTAL NOI 287,846$ 134,987$ 152,859$ 113.2% NOI%38.0%20.6%0$ 84.6%
NOI TARGET %38.0%
58Page 351 of 359
City Council Agenda - June 1, 2023
Banquet Operation
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
Total Covers 19,125 19,037 88 0.5%Currently trending behind prior year however added 1,000 covers for Corporate Events ADC 103.89$ 95.01$ 8.88$ 9.3%Based upon current pace, addl booking needed, and avg check for Corp events @ $100 Total Revenues 2,632,304$ 2,392,566$ 239,738$ 10.0% Cost of Sales 729,219$ 590,824$ 138,395$ 23.4%Brought Food COS up from 17% to 22% - Xfer savings to Vue % of Revenue 27.7%24.7%
Payroll & Related 771,330$ 1,165,661$ (394,331)$ -33.8%Elimination of Allocated payroll % of Revenue 29.3%48.7%
Operating Expenses 258,650$ 253,852$ 4,798$ 1.9%
% of Revenue 9.8%10.6%
TOTAL NOI 873,105$ 382,229$ 490,876$ 128.4% NOI%33%16.0%0$ 107.6%
NOI TARGET %30%
59Page 352 of 359
City Council Agenda - June 1, 2023
Food Truck/Cafe 36
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
Total Covers/Rounds 76,623 76,173 450 0.6%
ADC 5.37$ 5.11$ 0.26$ 5.1%Based on additional rounds and 5% increase ADC Total Revenues 413,875$ 385,958$ 27,917$ 7.2% Cost of Sales 103,617$ 94,972$ 8,645$ 9.1%
% of Revenue 25.0%24.6%
Payroll & Related 180,571$ 261,380$ (80,809)$ -30.9%Elimination of Allocated payroll; adding .33 FTE mgr; .5 FTE Supervisor % of Revenue 43.6%67.7%
Operating Expenses 40,249$ 39,407$ 842$ 2.1%
% of Revenue 9.7%10.2%
TOTAL NOI 88,639$ (8,834)$ 97,473$ -1103.4% NOI%21.4%-2.3%0$ -1035.7%
NOI TARGET %30.00%
60Page 353 of 359
City Council Agenda - June 1, 2023
Shot in the NIght
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
Hours Hitting Bay/Putting 3,710 2,644 1,066 40.3%Opens Oct 15; + 2 addl bays; local TV Adver Group hours 97 55 42 76.4%
Total $/hr spend 270.94$ 294.74$ (23.80)$ -8.1%Decrease due to know ice skating for 2023/2024 Social $/hr spend
Group $/hr spend
Golf Revenues 385,250$ 375,001$ 10,249$ 2.7%Eliminated Ice Skating $126k; increase rate to $75/hr F & B Revenues 619,855$ 404,237$ 215,618$ 53.3%Based on spend per hour Social & Group Added theme nights with Entertainment
Total Revenues 1,005,105$ 779,238$ 225,867$ 29.0% Cost of Sales 175,135$ 115,827$ 59,308$ 51.2% % of Revenue 28.3%28.7%% based on F & B Revenues only
Payroll & Related 304,655$ 305,110$ (455)$ -0.1%Elimination of Allocated payroll; going from 1 FTE to .33 FTE mgr; % of Revenue 30.3%39.2%
Operating Expenses 218,708$ 166,594$ 52,114$ 31.3% % of Revenue 21.8%21.4%
Computer & Related 54,384$ 29,398$ 24,986$ 85.0%Top Tracer full year + 2 addl bays Allocated Expense 75,077$ 53,803$ 21,274$ 39.5%Increase % of revenue: opens Oct rather than Nov Entertainment 49,500$ 50,555$ (1,055)$ -2.1%No NYE event, however added DJ 3 days/week TOTAL NOI 301,623$ 191,706$ 109,917$ 57.3% NOI%30.0%24.6%0$ 22.0%
NOI TARGET %30.00%
61Page 354 of 359
City Council Agenda - June 1, 2023
F B Admin
2023/2024 Budget Assumptions
Budget 2023/24 Prior Year Variance %
TOTAL F & B Admin EXPENSE 289,721$ -$ 289,721$ All operating expenses are allocated by to outlets Payroll & Related 289,721$ -$ 289,721$ Includes F & B Director, Admin, and Earl Operating Expenses 680,518$ 622,661$ 57,857$ 9.3% China, Glass & Silver 39,996$ 10,716$ 29,280$ 273.2%Additional par stock needed Operating Supplies 154,175$ 153,071$ 1,104$ 0.7%Based 2% of revenue Credit Card Fees 192,724$ 173,354$ 19,370$ 11.2%Based upon revenues 2.5% 62Page 355 of 359
City Council Agenda - June 1, 2023
RESOLUTION NO. 2023-__
A RESOLUTION OF THE CITY OF INDIAN WELLS, CALIFORNIA,
ADOPTING THE GOLF RESORT OPERATING AND CAPITAL BUDGETS
FOR THE CITY OF INDIAN WELLS FOR THE FISCAL YEAR 2023-24 AND FISCAL YEAR 2024-25, AND APPROVING A PROCEDURE FOR PAYMENT
OF CLAIMS WITHOUT THE ISSUANCE OF WARRANTS PURSUANT TO
GOVERNMENT CODE SECTION 53910 ET SEQ.
WHEREAS, the City Council held a public meeting on June 1, 2023, to review, consider, deliberate, and collect public input regarding the proposed Golf Resort biennial operating budget and capital improvement budget for the City of Indian Wells for fiscal year 2023-24 and fiscal year 2024-25; and,
WHEREAS, the proposed Golf Resort biennial operating budget and capital improvement budget submitted were modified by the City Council during the public meeting; and,
WHEREAS, a proposed Golf Resort biennial operating budget and capital improvement budget for the City of Indian Wells was submitted to the City Council on June 1, 2023, and, WHEREAS, the proposed Golf Resort biennial operating budget and capital improvement budget submitted have been reviewed by the City Council; and WHEREAS, under Government Code Section 53910, the City’s governing body may, by resolution, authorize practices concerning form, issuance, delivery, endorsement, and payment of warrants it deems convenient, efficient, and in the public interest, conforming substantially to those practices specified in Sections 53911, 53912, 53913, or 53914 of said Code; and WHEREAS, Government Code Section 53912 authorizes a city’s governing body to provide that when funds are available for the payment of approved claims, the approval of claims for payment shall, without the issuance of any warrant, be the authority to the custodian of its funds to pay the claims by check or electronic transfer, so long as related registers and transfers contain substantially the same information as required by law to be maintained for a warrant; and
WHEREAS, the City Council for the City of Indian Wells deems it convenient, efficient, and in the public interest to provide that when funds are available for the payment of approved claims, the approval of claims for payment shall, without the issuance of any warrant, be the authority to the Finance Director / Agency Treasurer to pay the claims by check or electronic transfer.
NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF INDIAN WELLS DOES HEREBY RESOLVE AS FOLLOWS:
SECTION 1: Golf Resort Operating and Capital Budget Approved for Adoption.
Pursuant to and in accordance with applicable provisions of the Charter of the City of Indian Wells, the biennial operating budget and capital improvement budget for fiscal year 2023-24 ATTACHMENT #2
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution No. 2023-
and fiscal year 2024-25, submitted by the City Manager to the City Council on June 1, 2023, is hereby approved for adoption.
SECTION 2: Proposed Golf Resort Budget for Fiscal Year 2023-24 and Fiscal Year 2024-25
There is hereby appropriated from the unappropriated fund balances anticipated to be available on July 1, 2023, and from the estimated revenues and transfers to be received during the Fiscal Year(s) beginning July 1, 2023, and ending June 30, 2025, the following amounts necessary to fund the operating programs of the City Departments and the Capital Improvements Program for the City of Indian Wells during said Fiscal Years:
Fiscal Year
2023/24
Fiscal Year
2024/25
560 Indian Wells Golf Resort 17,298,468 20,998,468
Total All Funds 17,298,468 20,998,468
SECTION 3: Legislative Control. The legislative format of the adopted budget shall be by Fund and Program for the operating budget and by Fund and Capital Project Group for the Capital Budget, as specified above in Section 1, and the change of any appropriation authorized above shall be subject to the approval of the City Council.
SECTION 4: Administrative Budget Control. It is hereby declared that, in addition to the legislative format, there is a need for administrative control over the adopted budget; and that the Finance Director, under the direction of the City Manager, shall detail the adopted budget to administrative control accounts; and that such detailing shall be consistent with the legislative format by the program for the operating budget and by project and expense item within a Capital Program Group for the capital budget.
SECTION 5: Budget Carryovers. It is hereby approved that all appropriations for prior fiscal years shall lapse at the end of Fiscal Year 2022-23. Any remaining amounts shall be credited to their respective fund balances, except for specific orders or encumbrances for operating and capital budgets outstanding at the end of the year, and as deemed necessary by the Finance Director, may be carried over to the following fiscal year. The Finance Director shall carry over the appropriation without further City Council action.
SECTION 6: Findings concerning City Charter. The City Council finds that expenditures set forth in the biennial operating budget for official meetings/conferences and for community presentations as set forth in the City Council department budget do not constitute payment for or reimbursement by the City to City Council Members for their personal use or benefit, as generally outlined in Section 101 of the City Charter, but instead pertain to matters of City business.
City Council Agenda - June 1, 2023
City of Indian Wells
Resolution No. 2023-
SECTION 7: Filing the Adopted Budget in the Office of the City Clerk. The City Clerk is hereby DIRECTED to file the biennial operating budget and capital improvement budget for fiscal year 2023-24 and fiscal year 2024-25 as adopted by the City Council on June 1, 2023, in the Office of the City Clerk.
SECTION 8: Use of Checks and Electronic Transfers in Lieu of Warrants. It is hereby approved that when funds are available for the payment of claims, the audit and approval of said claims by either the Finance Director, when authorized in Section 2.16.020 of the Indian Wells Municipal Code, or by the City Council in all other cases, shall, without the issuance of a warrant, be the authority to the legal depository holding the funds in the City Treasury to pay the audited claims by check or electronic transfer as authorized by Government Code § 53912.
Registers and transfers maintained by the Finance Director pertaining to said checks and electronic transfers shall contain substantially the same information as required by law or ordinance to be maintained in connection with the use of warrants for payment of claims.
SECTION 9: Effective Date. This resolution shall take full force and effect on July 1, 2023, after its adoption by the City Council.
PASSED, APPROVED, AND ADOPTED by the City Council of the City of Indian Wells, California, on this 1st day of June 2021.
________________________________
DONNA GRIFFITH
MAYOR
CERTIFICATION FOR RESOLUTION NO. 2023-
I, Angelica Avila, City Clerk of the City Council of the City of Indian Wells, California, DO HEREBY CERTIFY that the whole number of the members of the City Council is five (5); that the above and foregoing resolution was duly and regularly passed and adopted at a regular meeting of the City Council of the City of Indian Wells the 1st day of June 2023, by the following vote:
AYES:
NOES:
ATTEST: APPROVED AS TO FORM:
_______________________________ ______________________________
ANGELICA AVILA TODD LEISHMAN
CITY CLERK CITY ATTORNEY
City Council Agenda - June 1, 2023
INDIAN WELLS CITY COUNCIL
June 1, 2023
To: City Council
From: City Manager Department
Prepared by: Peter Castro, Deputy City Manager
Subject: Request to Place Discussion Regarding Request for Proposal for the Management of the Indian Wells Golf
Resort
RECOMMENDED ACTION:
Council DISCUSSES and provides DIRECTION to staff on Council Member Ty Peabody’s request for a future agenda item on a Request for Proposal for the Management of the Indian Wells Golf Resort.
DISCUSSION:
Councilmember Ty Peabody requested a staff report on a Request for Proposal (RFP) for the management of the Indian Wells Golf Resort (IWGR) be added to the June 1, 2023, City Council agenda.
An RFP for management at the IWGR was discussed at the 2023 IWGR Strategic Planning Session held on March 23, 2023. At that meeting, the Council unanimously authorized the City Manager to negotiate a new management agreement with Troon, with input from the Councilmembers on suggested terms to be reflected in a new contract. If the City Manager is unsuccessful in negotiating a new contract, the City will give Troon notice that the City will be conducting an RFP process. A summary of the IWGR Strategic Planning Goals was presented to Council for approval at their April 6, 2023, regular meeting. At that meeting, it was unanimously approved to authorize the City Manager to collect input from the City Councilmembers on what they would like to see in a new contract, and then begin negotiations with Troon.
The City Manager has met with each Councilmember to get the input/suggestions for deal points with Troon and is meeting with City Staff to do negotiations with Troon. The plan is to have a tentative agreement with Troon prior to June 30, 2023, for City Council consideration.
City Council Agenda - June 1, 2023