HomeMy WebLinkAboutCity Council Agenda 8-20-03.doc AGENDA
#2316
CITY COUNCIL MEETING/WORK SESSION
CITY OF UNIVERSITY PARK, TEXAS
CITY HALL CONFERENCE ROOM
WEDNESDAY, AUGUST 20, 2003 AT 7:30AM
I. ITEMS FROM THE FLOOR
Anyone wishing to address an item not on the Agenda or having questions about items on
the Consent Agenda should do so at this time. Questions and comments regarding Main
Agenda items may be made when that item is addressed by the City Council.
II. CONSENT AGENDA
A. CONSIDER: Resolution renewing City Investment Policy Austin Tab I
B. CONSIDER: Office Supplies Contract through U.S. Communities Green Tab II
C. CONSIDER: Approval of City Council Meeting Minutes for August 5, 2003
Wilson Tab III
III. MAIN AGENDA
A. CONSIDER: Request from Highland Park Lacrosse Board Thom Hanford Tab IV
B. PUBLIC HEARING: Regarding proposed FY2004 budget and proposed property
tax rate Austin Tab V
C. CONSIDER: Adoption of 2003 Certified Tax Roll - Austin Tab VI
D. CONSIDER: Bids for In - Place Recycling of asphalt pavements along various
Streets Smallwood Tab VII
E. CONSIDER: Interlocal Agreement with the City of Dallas for the reconstruction
of Lovers Lane from Boedeker east to Willard Smallwood Tab VIII
F. CONTiNUATION OF DISCUSSION: Regarding Pay and Display Parking
Livingston Tab IX
G. CONSIDER: Change Order for contract with Ken - Do Construction for
realignment of Caruth - Turtle Creek Boulevard intersection Smallwood Tab X
As authorized by Section 551.071(2) of the Texas Government Code, this meeting may be
convened into Closed Executive Session for the purpose of seeking confidential legal advice
from the City Attorney on any agenda items listed herein.
AGENDA MEMO
(08/20/03 AGENDA)
DATE:
TO:
FROM:
SUBJECT:
August 13, 2003
Honorable Mayor and City Council
Kent R. Austin, Director of Finance
Resolution renewing City Investment Policy
ITEM:
The Texas Public Funds Investment Act (PFIA) requires that a city's goveming body "review its
investment policy and investment strategies not less than annually" and that the policy be adopted
by rule, order, ordinance, or resolution. The City Council last approved University Park's
Investment Policy via resolution in March 2003, when the TexStar investment pool was added and
the LOGIC and Lone Star pools were deleted.
Staffproposes no changes to the policy adopted earlier this year. Review and renewal of the
policy now will satisfy PFIA requirements for another year. The Finance Advisory Committee
considered the policy at their August 6, 2003, meeting and recommended approval with no
changes as well.
Highlights of the City's investment policy include:
· Emphasis on safety of principal first, liquidity second, and yield third;
· Listing of eligible investments, including U.S. Treasury and agency securities and specific
local government investment pools but excluding commercial paper and collateralized
mortgage obligations;
· Requirements for quarterly investment reporting and 'marking to market' to reflect fair market
value of securities held by the City;
· Use of delivery versus payment for settlement of investment transactions;
· Establishment of asset allocation limits (for example, maximum 60% for U.S. agencies and
50% for local government investment pools);
· Limitation of maximum portfolio weighted average maturity to 548 days (1.5 years) and no
final stated maturities longer than five years for individual securities; and
· Designation of the Finance Advisory Committee as the City's investment committee.
In the interest of brevity, I have omitted the appendices from the attached 18-page investment
policy. These appendices consist of boilerplate language regarding State investment legislation,
master repurchase agreement, broker/dealer certification, and broker/dealer questionnaire. They
remain unchanged from last year.
3800 UNIVERSITY BOULEVARD UNIVERSITY PARK, TEXAS 75205 TELEPHONE (214) 363-1644
C:\Documents and Settings~nwilson\Local Settings\Temporary Internet Files\OLK21~AGENDA MEMO Invest Poi Adopt
082003.doc 12:38 PM 08/14/03
RECOMMENDATION:
City staff and the Finance Advisory Committee recommend approval of the attached resolution
adopting the Investment Policy. The resolution names the Finance Director, City Manager, and
Controller as investment officers, and the Finance Advisory Committee approved a list of seven
authorized broker/dealers.
ATTACHMENTS:
· Finance Advisory Committee draft meeting minutes, August 6, 2003
· Resolution adopting City investment policy
· Proposed City investment policy sans appendices
3800 UNIVERSITY BOULEVARD UNIVERSITY PARK, TEXAS 75205 TELEPHONE (214) 363-1644
C:\Documents and Settings~nwilson\Local Settings\Temporary Internet Files\OLK21~AGENDA MEMO Invest Poi Adopt
082003.doc 12:38 PM 08/14/03
CITY OF UNIVERSITY PARK, TEXAS
FINANCE AD VISORY COMMITTEE
WEDNESDA Y, AUGUST 6, 2003 at 7:30 A.M.
MINUTES
Committee members attending
Atwood, John
Edwards, Richard
Kelley, Terry
Mahon, Ed
Others present:
Austin, Kent
Livingston, Bob
Tvardzik, Tom
Zelms, Alison
Absent:
Davis, Dick Councilmember
Harralson, Howell
Olmsted, Bob Chair
Stuart, John
Call to order.
Kent Austin called the meeting to order at 7:36 a.m. Bob Livingston introduced Alison
Zelms, Administrative Intern. Ms. Zelms provided an overview of the pay and display
parking meter concept. A brief discussion ensued. No action was taken.
2. Review/approve minutes of June ] 7, 2003 meeting.
Ed Mahon moved approval of the June 17, 2003 meeting minutes. John Atwood seconded,
and the motion was approved 4-0.
3. Review/approve investment policy, broker-dealer list, and investment officers.
Kent Austin reviewed the Investment Policy with the Committee pointing out no new
amendments have been added to the State Public Funds Investment Act and none are being
proposed by the City.
The proposed broker-dealer list includes the same seven broker-dealers currently approved to
do business with the City: A.G. Edwards & Sons; Bank of America; BOSC, Inc; First
Southwest Co.; First Tennessee; Merrill Lynch; and Salomon Smith Barney. John Atwood
suggested inviting Frost Brokerage to apply for approval in the future.
The proposed investment officers list is unchanged and includes Kent Austin, Tom Tvardzik
and Bob Livingston.
Terry Kelley moved approval of the City Investment Policy and related items, and John
Atwood seconded. The motion was approved 4-0.
C: [Documents and Settings[nwilson[Local Settings[ Temporary D~ternet Files[OLK2l [FACrninutes 080603. doc 08/15/03
4. Review/discuss proposed FT2004 budget
Kent Austin and Bob Livingston briefed the Committee regarding the proposed FY2004
budget, composed of the General Fund, Utilities Fund, and Sanitation Fund. The Committee
asked about the deficit budgets for Sanitation and Utilities, compared to the balanced General
Fund budget. Austin replied that actual expenditures will likely be under budget and actual
revenues will likely be over budget for example, water revenue is volatile and can change
substantially from year to year. The Sanitation Fund revenues are largely fixed, but
historically Fund expenditures have been under budget. Rather than propose rate increases or
make personnel reductions, City staff recommends approving deficit budgets for these two
enterprise funds. Should actual deficits be incurred, rate increases or personnel changes can
be considered.
Committee members asked about some of the General Fund revenue amounts. Austin and
Livingston noted that some numbers are deliberately under-budgeted, such as building permits.
This is done so that the budget does not become overly dependent on revenue sources that
could change sharply. Austin noted that the interest revenue number, on the other hand, was
optimistic but more consistent with longer-term averages. Richard Edwards and Terry Kelley
suggested more realistic revenue projections so that each number was more self-evident.
After additional discussion, Terry Kelley moved approval of the FY2004 budget. John
Atwood seconded, and the motion was approved 4-0.
5. Review April-dune 2003 City investment reports.
Austin reported that the investment report was not yet available for review.
6. Review dune and duly 2003 City fund reports.
Austin and the Committee reviewed the reports. No action was taken.
New business.
a. Update: City Hall reconstruction project.
Bob Livingston described the plans for the water line replacement and the creek paving to
begin in fall 2003.
b. Next Committee meeting date
The next meeting will be held some time during the first half of November.
8. Adjourn.
The meeting adjourned at 8:58 a.m.
Bob Olmsted, Chair
Kent R. Austin, Director of Finance
C: [Documents and Settings[nwilson[Local Settings[ Temporary Internet Files[OLK2] [FACrninutes 080603. doc 08/15/03
RESOLUTION NO.
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
UNIVERSITY PARK, TEXAS, ADOPTING THE INVESTMENT POLICY
OF THE CITY OF UNIVERSITY PARK HERETOFORE ADOPTED BY
RESOLUTION NO. 03-06; AND PROVIDING AN EFFECTIVE DATE.
WHEREAS, the Public Funds Investment Act, as amended, requires the City to adopt an
investment policy by rule, order, ordinance or resolution, and to review such policy not less than
annually; and
WHEREAS, the Public Funds Investment Act, as amended, requires the Treasurer, the
Chief Financial Officer, and the Investment Officers of the City to attend investment training; and
WHEREAS, the City of University Park approves of the investment training courses
sponsored by the Texas Municipal League and other independent sources; and
WHEREAS, the Treasurer, the Chief Financial Officer, and the Investment Officers of the
City have attended investment training courses as required by the Public Funds Investment Act;
and
WHEREAS, the attached investment policy complies with the Public Funds Investment
Act, as amended, and authorizes the investment of City funds in safe and prudent investments;
Now, Therefore,
BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF UNIVERSITY
PARK, TEXAS:
SECTION 1. That the City of University Park has complied with the
requirements of the Public Funds Investment Act, and the Investment Policy, as amended,
attached hereto as Exhibit "A" is hereby adopted as the Investment Policy of the City of
University Park, effective August 20, 2003.
SECTION 2. That the following individuals are hereby designated as Investment
Officers for the City of University Park: Kent Austin, Director of Finance; Bob Livingston, City
Manager; and, Thomas Tvardzik, Controller.
SECTION 3. This resolution shall take effect from and after its passage, and it is
accordingly so resolved.
C'.' IDocuments and 3'ettingslnwilsonlLocal 3'ettingsl Temporary Jnternet FileslOLK2l IResolution Jnvest Poi 2003 March. doc
DULY PASSED AND APPROVED by the City Council of the City of University Park,
Texas, on the 20th day of August, 2003.
APPROVED:
APPROVED AS TO FORM:
HAROLD PEEK, MAYOR
ATTEST:
CITY ATTORNEY
NINA WILSON, CITY SECRETARY
C'.' [Documents and Settings[nwilson[Local Settings[ Temporary Internet Files[OLK2] [Resolution Invest Poi 2003 March. doc
Investment Policy
Effective August 20, 2003
City of University Park, Texas
City of University Parlq Texas - Investmem Policy
CONTENTS
Preface ....................................................................................................................... iv
1. PURPOSE
o
o
2.
3.
4.
Authorization ................................................................................................... 1
Goal ................................................................................................................ 1
Scope .............................................................................................................. 1
Review and Amendment ................................................................................... 1
INVESTMENT OBJECTIVES
2.
3.
4.
Preservation and Safety of Principal .................................................................. 2
Maintenance of Adequate Liquidity .................................................................. 2
Return on Investments ...................................................................................... 2
Prudence and Ethical Standards ........................................................................ 3
INVESTMENT STRATEGY STATEMENT
2.
3.
4.
Operating Funds ............................................................................................... 4
Bond Debt Service Funds ................................................................................. 4
Bond Reserve Funds ........................................................................................ 4
Capital Projects Funds ...................................................................................... 5
SPECIFIC INVESTMENT POLICIES
Eligible Investments ......................................................................................... 6
1. Obligations of the United States ............................................................... 6
2. Obligations of the State of Texas .............................................................. 6
3. Agencies of the United States and State of Texas ...................................... 6
4. Obligations of other States, Counties, Cities ............................................. 6
5. Direct Repurchase Agreements ................................................................ 6
6. Certificates of Deposit ............................................................................. 6
7. Share Certificates of state and federal Credit Unions ................................. 7
8. Money Market Mutual Funds ................................................................... 7
9. Local Government Investment Pools ......................................................... 7
Ensuring Safety of Principal ............................................................................... 8
1. Protection of Principal ............................................................................. 8
1. Approved Broker/Dealers/Financial Institutions/Depositories ............... 8
2. Master Repurchase Agreement ........................................................... 9
3. Collateralization ................................................................................. 9
City of University Parlq Texas - Investment Policy
1. Allowable Collateral ................................................................. 10
1. Certificates of Deposit ....................................................... 10
2. Repurchase Agreements ..................................................... 10
2. Collateral Levels ....................................................................... 10
1. Certificates of Deposit ....................................................... 10
2. Repurchase Agreements ..................................................... 11
3. Monitoring Collateral Adequacy ................................................ 11
1. Certificates of Deposit ....................................................... 11
2. Repurchase Agreements ..................................................... 11
4. Margin Calls ............................................................................. 11
1. Certificates of Deposit ....................................................... 11
2. Repurchase Agreements ..................................................... 11
5. Collateral Substitution ............................................................. 12
6. Collateral Reductions ............................................................. 12
4. Portfolio Diversification ................................................................... 12
1. Bond Proceeds .......................................................................... 13
5. Limiting Maturity ............................................................................ 13
1. Operating Funds ....................................................................... 13
2. Bond Proceeds, Bond Reserves, Debt Service Funds .................. 13
2. Safekeeping ............................................................................................ 14
1. Safekeeping Agreement ................................................................... 14
2. Safekeeping of Certificate of Deposit Collateral ................................ 14
3. Safekeeping of Repurchase Agreement Collateral ............................. 14
Ensuring Liquidity ......................................................................................... 14
Achieving Investment Return Objectives ......................................................... 15
1. Securities Swaps ..................................................................................... 15
2. Competitive Bidding ............................................................................... 15
3. Methods of Monitoring Market Price ....................................................... 15
4. Benchmark Rate of Return ...................................................................... 16
Responsibility and Controls ............................................................................ 16
1. Authority to Invest .................................................................................. 16
2. Bonding requirements/Standard of care .................................................... 16
3. Establishment of Internal Controls ........................................................... 17
4. Standard of Ethics ................................................................................... 17
5. Training and Education ........................................................................... 17
6. Investment Committee ............................................................................. 18
Reporting ....................................................................................................... 18
Compliance Audit .......................................................................................... 19
Certification ................................................................................................... 19
5. ADOPTING CLAUSE ........................................................................................... 20
City of University Parlq Texas - Investmem Policy
APPENDICES
ao
INVESTMENT LEGISLATION ................................................................ 21
MASTER REPURCHASE AGREEMENT .............................................. 48
BROKER/DEALER CERTIFICATION ................................................... 56
ATTACHMENTS
BROKER/DEALER QUESTIONNAIRE ................................................... 58
iii
City of University Parlq Texas - Investment Policy
PREFACE
The purpose of this document is to establish specific investment policy and strategy
guidelines for the City of University Park, Texas ("City") in order to achieve the goals of
safety, liquidity and yield for all investment activity. The City shall review its investment
strategies and policy not less than annually. This policy serves to satisfy the statutory
requirement, specifically the Public Funds Investment Act, Chapter 2256 of the Texas
Government Code (the "Act"), to define, adopt and review a formal investment strategy
and policy.
It is the policy of the City that all available funds shall be invested in conformance with
these legal and administrative guidelines.
Effective cash management is recognized as essential to good fiscal management. An
aggressive cash management and investment policy will be pursued to take advantage of
investment interest as viable and material revenue to all operating and capital funds. The
City's portfolio shall be designed and managed in a manner responsive to the public trust
and consistent with state and federal law.
Investments shall be made with the primary considerations of:
· Preservation of capital and protection of principal
· Maintenance of sufficient liquidity to meet operating needs
· Security of City funds and investments
· Diversification of investments to avoid unreasonable or foreseeable
risks
· Maximization of return on the portfolio
SECTION 1
PURPOSE
City of University Parlq Texas - Investment Policy
1. Purpose
1. Authorization
This Policy is to be authorized by the City Council in accordance with
Section 5 of the Public Funds Investment Act (Chapter 2256, Texas
Government Code), which requires the adoption of a formal written
Investment Policy.
2. Goal
The primary goal of the City of University Park's Investment Policy shall
be to ensure the safety of all funds entrusted to the City; to maintain the
availability of those funds for the payment of all necessary obligations of
the City; and to provide for the investment of all funds, not immediately
required, in interest-bearing securities or pooled investment products. The
safety of the principal invested shall always be the primary concern.
3. Scope
This Investment Policy of the City of University Park shall include all
investment activities of any fund of the City, except for the Firemen's
Relief and Retirement Fund, which is covered by a separate policy. In
addition to this Policy, bond funds, including debt service and reserve
funds, shall be managed by their governing resolution and federal law,
including the Tax Reform Act of 1986 and subsequent legislation. City
funds will be pooled for investment purposes.
4. Review and Amendment
This Policy may be amended from time to time as the City Council may so
desire, or as State Law may require. This Policy, which includes strategies
for each fund or pooled fund group, shall be adopted by resolution, rule, or
ordinance by the City Council and shall be reviewed annually by the City
Council. The fact that the Investment Policy has been reviewed and that any
amendments have been made must be recorded by resolution, rule or
ordinance.
SECTION 2
INVESTMENT OBJECTIVES
City of University Parlq Texas - Investment Policy
2. INVESTMENT OBJECTIVES
The City shall manage and invest its cash with four objectives, listed in order of
priority: Preservation and Safety of Principal; Liquidity; Yield; and Prudence. All
investments shall be designed and managed in a manner responsive to the public trust
and consistent with State and Local Law.
The City shall maintain a comprehensive cash management program that includes the
prudent investment of available cash. Cash management is defined as the process of
managing monies in order to increase cash availability and interest earnings on short-
term investment of idle cash.
1. Preservation and Safety of Principal
The primary objective of City investment activity is the preservation of
principal in the overall portfolio. Each investment transaction shall be
conducted in a manner designed to avoid principal losses, whether they are
from securities defaults or erosion of market value. The manner in which
the City ensures safety of principal is presented in Section 4.2, "Ensuring
Safety of Principal."
2. Maintenance of Adequate Liquidity
The City investment portfolio shall be structured such that the City is able
to meet all obligations in a timely manner. Maintenance of adequate
liquidity is described in Section 4.3, "Ensuring Liquidity."
3. Return on Investments
Consistent with State law, the City shall seek to optimize return on
investments within the constraints of safety and liquidity. Investments
(excluding assets managed under separate investment programs, such as in
arbitrage restrictive programs) shall be made in permitted obligations at
yields equal to or greater than the bond equivalent yield on United States
Treasury obligations of comparable maturity. Other appropriate
performance measures will be established by the Investment Committee.
Specific policies regarding investment rate of return are presented in
Section 4.4, "Achieving Investment Return Objectives."
For bond issues to which Federal yield or arbitrage restrictions apply, the
primary objectives shall be to obtain satisfactory market yields and to
minimize the costs associated with investment of such funds.
City of University Parlq Texas - Investment Policy
4. Prudence and Ethical Standards
The standard of prudence used by the City shall be the "prudent person
rule" and shall be applied in the context of managing the overall portfolio
within the applicable legal constraints. The prudent person rule is restated
below:
"Investments shall be made with judgment and care, under
circumstances then prevailing, which persons of prudence,
discretion and intelligence would exercise in the management of
their own afl'airs, not for speculation, but for investment,
considering the probable safety of their capital as well as the
probable income to be derived."
In determining whether the Investment Officer(s) or Investment Advisor
under contract has exercised prudence with respect to an investment
decision, the determination shall be made taking into consideration the
investment of all funds over which the Officer/Advisor had responsibility
rather than a consideration as to the prudence of a single investment, and
whether the investment decision was consistent with the written Investment
Policy of the City.
The Investment Officers, acting in accordance with written procedures and
exercising due diligence, shall not be held personally responsible for a
specific security's credit risk or market price changes, provided that these
deviations are reported immediately.
Specific policies describing the City's prudence and ethical standards are
found in Section 4.5, "Responsibility and Controls."
SECTION 3
INVESTMENT STRATEGY STATEMENT
City of University Parlq Texas - Investment Policy
3. INVESTMENT STRATEGY STATEMENT
The City maintains portfolios that utilize four specific investment strategy
considerations designed to address the unique characteristics of the fund groups
represented in the portfolios.
1. The Operating Funds
The investment strategy for operating funds has as its primary objective the
assurance that anticipated cash flows are matched with adequate investment
liquidity. The secondary objective is to create a portfolio structure which
will experience minimal volatility during economic cycles. This may be
accomplished by purchasing quality, short- to medium-term securities. The
dollar weighted average maturity shall be calculated in accordance with
GASB requirements. The weighted average maturity of operating funds
shall not exceed 548 days. Securities may not be purchased that have a
final stated maturity date that exceeds five (5) years.
2. The Bond Debt Service Funds
The investment strategy for bond debt service fund(s) has as its primary
objective the assurance of investment liquidity adequate to cover the debt
service obligation on the required payment date. Securities purchased shall
not have a stated final maturity date that exceeds the next unfunded bond
debt service payment date.
3. Bond Reserve Funds
The investment strategy for bond reserve fund(s) has as its primary
objective the ability to generate a dependable revenue stream to the
appropriate debt service fund from securities with a low degree of
volatility. Securities should be of high quality and, except as may be
required by the Bond Ordinance specific to an individual issue, of short-to-
intermediate-term maturities. The stated final maturity dates of securities
held shall not exceed five (5) years.
City of University Parlq Texas - Investment Policy
4. Capital Projects Funds
The investment strategy for capital projects funds portfolios has as its
primary objective the assurance that anticipated cash flows are matched
with adequate investment liquidity. These portfolios should include at least
10% in highly liquid securities to allow for flexibility and unanticipated
project outlays. The stated final maturity dates of securities held should not
exceed the estimated project completion date.
To maximize the effective investment of assets, all funds needed for general
obligations may be pooled into one account for investment purposes. The income
derived from this account will be distributed to the various funds based on their
average balances on a periodic basis. Proceeds of bond issues shall not be pooled
with other assets of the City, but shall be maintained in the fund issuing the bonds
with interest earnings on these invested proceeds recorded directly to that fund.
SECTION 4
SPECIFIC INVESTMENT POLICIES
City of University Parlq Texas - Investment Policy
4. SPECIFIC INVESTMENT POLICIES
1. Eligible Investments
Investments described below are those authorized by the Public Funds
Investment Act (Chapter 2256, Texas Government Code), as amended,
which is included and made a part of this Policy as Appendix A. The
following list may not contain all of those securities that are authorized by
state statutes, but only those that the City Council wishes to include in their
portfolios. The purchase of specific issues may at times be further restricted
or prohibited because of current market conditions. City funds governed by
this Policy may be invested in:
1. obligations of the United States or its agencies and instrumentalities;
2. direct obligations of the State of Texas or its agencies;
other obligations, the principal and interest on which are
unconditionally guaranteed or insured by the State of Texas or the
United States or its agencies and instrumentalities.
obligations of states, agencies, counties, cities and other political
subdivisions of any state having been rated as to investment quality by a
nationally recognized investment rating finn and having received a
rating of not less than A or its equivalent.
fully collateralized direct repurchase agreements having a defined
tennination date, secured by obligations described by subdivision 1 of
this subsection, pledged to the City, held in the City's name and
deposited at the time the investment is made with the City with a third
party selected and approved by the City, and placed through a primary
government securities dealer, as defined by the Federal Reserve, or a
financial institution doing business in Texas, and having a market value
(including accrued interest) of no less than the principal amount of the
funds disbursed;
6. certificates of deposit issued by state and national banks domiciled in
Texas that are:
guaranteed or insured by the Federal Deposit Insurance
Corporation, or its successor; or,
secured by obligations that are described by 1 - 4 above, which are
intended to include all direct federal agency or instrumentality
issues that have a market value of not less than the principal amount
of the certificates or in any other manner and amount provided by
law for deposits of the City.
City of University Parlq Texas - Investment Policy
7. share certificates issued by state and federal credit unions domiciled in
Texas that are:
guaranteed or insured by the National Credit Union Share Insurance
Fund, or its successor; or,
secured by obligations that are described by 1 - 4 above, which are
intended to include all direct federal agency or instrumentality
issues that have a market value of not less than the principal amount
of the certificates or in any other manner and amount provided by
law for deposits of the City.
SEC-regulated, no-load money market mutual funds with a dollar-
weighted average stated portfolio maturity of 90 days or less and
whose investment objectives include seeking to maintain a stable net
asset value of $1 per share. No more than 15% of the City's average
fund balance may be invested in money market mutual funds, and the
City may not invest funds under its control in an amount that exceeds
10% of the total assets of any individual money market mutual fund.
Local government investment pools organized in accordance with the
Interlocal Cooperation Act (Chapter 791, Texas Government Act) as
amended, whose assets consist exclusively of the obligations that are
allowed as a direct investment for funds subject to the Public Funds
Investment Act (Chapter 2256, Texas Government Code). A public
funds investment pool must be continuously rated no lower than AAA,
AAA-m or at an equivalent rating by at least one nationally recognized
rating service.
Eligible investment pools must be authorized by the City Council, by
rule, order, ordinance, or resolution, as appropriate. The City Council
has approved the Texas Local Government Investment Pool
("TexPool"), administered by the Texas State Comptroller; the Local
Government Investment Cooperative ("LOGIC"), administered by
Southwest Securities Group, Inc; and the Lone Star Investment Pool
("Lone Star"), administered by the Texas Association of School
Boards.
Investments in collateralized mortgage obligations are strictly
prohibited. These securities are also disallowed for collateral positions.
The City will not be required to liquidate investments that were authorized
investments at the time of purchase.
2. Ensuring Safety of Principal
City of University Parlq Texas - Investment Policy
Ensuring safety is accomplished through protection of principal and
safekeeping.
1. Protection of Principal
The City shall seek to control the risk of loss due to the failure of a security
issuer or guarantor. Such risk shall be controlled by:
1. investing only in the safest types of securities as defined in the
Policy,
2. qualifying the broker/dealer and financial institution with whom
the City will transact,
3. collateralization as required by law,
4. portfolio diversification, and
5. limiting maturity.
Settlement of all investment transactions, except those transactions
involving investments in mutual funds or local government investment
pools, must be made on a delivery versus payment basis. The purchase of
individual securities shall be executed "delivery versus payment" (DVP)
through the Federal Reserve System delivered to an authorized safekeeping
agent or "Trustee." By so doing, City funds are not released until the City
has received, through the Federal Reserve wire, the securities purchased.
The security shall be held in the name of the City by the Trustee. The
Trustee's records shall assure the notation of the City ownership of or
explicit claim on the securities. The original copy of the safekeeping
receipts shall be delivered to the City within twenty-four (24) hours of the
security's receipt by the Trustee.
1. Approved Broker/Dealers/Financial Institutions and Depositories
Investments shall only be made with those firms and institutions who
have acknowledged receipt and understanding of the City's Investment
Policy. The "qualified representative" of the business as defined in
Chapter 2256 of the Texas Government Code shall execute a written
certification to acknowledge receipt of the City's Investment Policy and
to acknowledge that the organization has implemented reasonable
procedures and controls to preclude imprudent investment activities
arising out of the investment transactions conducted between the entity
and the City. Should the City contract with an external investment
advisor to execute the investment strategy, including the negotiation and
execution of investment transactions, a managing officer of the
investment advisory firm may sign the written certification in lieu of the
broker/dealer firms. This certification must be included as part of the
investment advisory contract.
City of University Parlq Texas - Investment Policy
Securities and certificates of deposit shall only be purchased from those
institutions included on the City's list of broker/dealers and financial
institutions as approved by the Investment Committee. All securities
dealers shall provide the City with references from other public entities
that they are currently serving. This list of approved investment
providers must be reviewed at least annually by the City's Investment
Committee and shall be recorded in the Committee's meeting minutes.
The City's Finance Advisory Committee shall comprise the Investment
Committee.
All state and national banks located in the State of Texas, which are
insured by the Federal Deposit Insurance Corporation (FDIC) are to be
considered as eligible depositories. The financial condition of the bank
shall be considered prior to establishing any accounts with that bank.
The Finance Advisory Committee shall review the bids submitted by
depository candidates and make a recommendation to the City Council
for final approval.
2. Master Repurchase Agreement
It is the policy of the City to require each issuer of repurchase
agreements to sign a copy of the City's Master Repurchase Agreement.
An executed copy of this agreement must be on file before the City will
enter into any repurchase agreement with an issuer. (See Appendix B,
"Master Repurchase Agreement".)
3. Collateralization
Consistent with the requirements of State law, the City requires all bank
deposits (including time deposits) to be federally insured or
collateralized with eligible securities. Financial institutions serving as
City Depositories will be required to sign an Agreement with the City
and its safekeeping agent for the collateral, perfecting the City's rights
to the collateral in case of default, bankruptcy or closure.
The City shall not accept, as depository collateral, any security that is
not specifically allowed to be held as a direct investment by the City
portfolio (see 4.1). Repurchase agreements must also be collateralized
in accordance with State law. Each issuer of repurchase agreements is
required to sign a copy of the City's Master Repurchase Agreement.
An executed copy of this agreement must be on file before the City will
enter into any repurchase agreements with an issuer. (See Appendix B,
"Master Repurchase Agreement".) The City considers repurchase
agreements to be simultaneous purchases and sales of securities as
outlined in the Master Repurchase Agreement and not as collateralized
City of University Parlq Texas - Investment Policy
loans. However, the underlying securities may be referred to as
"collateral."
Evidence of the pledged collateral shall be maintained by the Finance
Director or a third party financial institution. All collateral shall be
subject to inspection and audit by the Finance Director or the City
independent auditors.
(1) Allowable Collateral
1. Certificates of Deposit
Eligible securities for collateralization of certificates of
deposit are U.S. Treasury obligations and government
agency securities. The eligibility of specific issues may
at times be restricted or prohibited because of current
market conditions.
2. Repurchase Agreements
Collateral underlying repurchase agreements is limited
to U.S. government and agency obligations, which are
eligible for wire transfer (i.e. book entry) to the City's
designated safekeeping agent through the Federal
Reserve System.
(2) Collateral Levels
Collateral is valued at current market plus interest accrued
through the date of valuation.
1. Certificates of Deposit
The market value of collateral pledged for certificates of
deposit must at all times be equal to or greater than
102% of the par value of the certificate of deposit plus
accrued interest, less the amount insured by the FDIC or
its successors. Investment in eligible pooled Certificate
of Deposit programs is authorized under this section.
2. Repurchase Agreements
The market value of collateral required to be pledged for
repurchase agreements shall be a percentage of the par
value of the agreement plus accrued interest and shall be
maintained at the following levels:
l0
City of University Parlq Texas - Investment Policy
Collateral U.S. Treasury U.S. Government
Maturity Securities A~enc¥
1 year or less 102 % 102 %
1 year to 5 years 102 % 103 %
Over 5 years 103 % 104 %
(3) Monitoring Collateral Adequacy
1. Certificates of Deposit
The City requires monthly reports with market values of
pledged securities from all financial institutions with which the
City has certificates of deposit. The City's Investment Officer
will at least weekly monitor the adequacy of collateral.
2. Repurchase Agreements
Weekly monitoring by the City's Investment Officer of all
collateral underlying repurchase agreements is required. More
frequent monitoring may be necessary during periods of market
volatility.
(4) Margin Calls
1. Certificates of Deposit
If the collateral pledged for a certificate of deposit falls below
the 102% of the deposit, plus accrued interest less FDIC
insurance, the institution will be notified by the City and will be
required to pledge additional securities no later than the end of
the next succeeding business day.
2. Repurchase Agreements
If the value of the collateral underlying a repurchase agreement
falls below the margin maintenance levels specified above, the
City will make a margin call unless the repurchase agreement is
scheduled to mature within five business days and the amount is
deemed to be immaterial.
(5) Collateral Substitution
City of University Park, Texas - Investment Policy
Collateralized investments and certificates of deposit often require
substitution of collateral. Any broker or financial institution
requesting substitution must contact the Investment Officer(s) for
approval and settlement. The substituted collateral's value will be
calculated and substitution approved if its value is equal to or
greater than the required value (See 4.2.1.3.2.2). The Investment
Officer or must give immediate notification of the decision to the
bank or the safekeeping agent holding the collateral. Substitution is
allowable for all transactions, but should be limited, if possible, to
minimize potential administrative problems and transfer expense.
The Investment Officer may limit substitution and assess
appropriate fees if substitution becomes excessive or abusive.
Collateral may be substituted only with the oral authorization of the
Investment Officer, followed by written confirmations within 24
hours.
(6) Collateral Reductions
Should the collateral's market value exceed the required amount,
any broker or financial institution may request approval from the
Investment Officer to reduce collateral. Collateral reductions may
be permitted only if the City's records indicate that the collateral's
market value exceeds the required amount. Written confirmations of
the collateral reduction should be received within 24 hours of the
Investment Officer's approval.
4. Portfolio Diversification
Risk of principal loss in the portfolio as a whole shall be minimized by
diversifying investment types according to the following limitations.
12
City of University Parlq Texas - Investment Policy
As discussed below, these limitations do not apply to bond proceeds.
Investment Type:
% of Portfolio
· U.S. Treasury Notes/Bonds/Bills 100%
· U.S. Agencies 60%
· Local Government Investment Pools 50%
· Repurchase Agreements 30%
· Certificates of Deposit 30%
· Money Market Mutual Funds 15%
It is the policy of the City to diversify its investment portfolio so that
reliance on any one issuer or broker will not place an undue financial
burden on the City. Generally, the City should limit its repurchase
agreement exposure with a single finn to no more than 15% of the
value of the City's overall portfolio. To allow efficient and effective
placement of proceeds from any bond sales, these limits may be
exceeded for a maximum of five business days following the receipt of
bond proceeds.
(1) Bond Proceeds
Proceeds of a single bond issue may be invested in a single security
or investment if the Investment Committee determines that such an
investment is necessary to comply with Federal arbitrage
restrictions or to facilitate arbitrage record keeping and calculation.
5. Limiting Maturity
In order to minimize risk of loss due to interest rate fluctuations,
investment maturities will not exceed the anticipated cash flow
requirements of the funds. Maturity guidelines by funds are as follows:
(1) Operating Funds
The dollar weighted average days to final stated maturity shall be
548 days or less. The Investment Officer will monitor the maturity
level and make changes as appropriate.
(2) Bond Proceeds, Bond Reserves, Debt Service Funds
The investment maturity of bond proceeds (including reserves and
debt service funds) shall be determined considering:
1. the anticipated cash flow requirements of the funds, and;
City of University Parlq Texas - Investment Policy
the "temporary period" as defined by Federal tax law during
which time bond proceeds may be invested at an
unrestricted yield. After the expiration of the temporary
period, bond proceeds subject to yield restriction shall be
invested considering the anticipated cash flow requirements
of the funds.
3. Safekeeping
1. Safekeeping Agreement
The City shall contract with a bank or banks for the safekeeping of
securities either owned by the City as a part of its investment portfolio
or held as collateral to secure certificates of deposits or repurchase
agreements. The Safekeeping Agreement shall clearly define the
procedural steps for gaining access to the collateral should the City
determine that the City funds are in jeopardy. The safekeeping
institution, or Trustee, shall hold all aforementioned securities in an
account at the Federal Reserve Bank that specifies City ownership of
the account. The Safekeeping Agreement shall include the signatures of
authorized representatives of the City, the firm pledging the collateral
and the Trustee.
2. Safekeeping of Certificate of Deposit Collateral
All collateral securing certificates of deposit must be held by a third
party banking institution approved by the City, or collateral may be
held at the Federal Reserve Bank. The City's ownership in collateral
positions must be fully perfected.
3. Safekeeping of Repurchase Agreement Collateral
The securities that serve as collateral for repurchase agreements with
dealers must be delivered to a third-party custodian with which the City
has established a third-party safekeeping agreement. The City's
ownership of all securities that serve as collateral for repurchase
agreements must be fully perfected.
3. Ensuring Liquidity
Liquidity shall be achieved by matching investment maturities with forecasted
cash flow requirements, by investing in securities with active secondary
markets, and by investing in eligible money market mutual funds (MMMF's)
and local government investment pools (LGIP's).
14
City of University Parlq Texas - Investment Policy
o
A security may be liquidated to meet unanticipated cash requirements, to re-
deploy cash into other investments expected to outperform current holdings, or
to otherwise adjust the portfolio.
Achieving Investment Return Objectives
Investment selection for all funds shall be based on legality, appropriateness,
liquidity, and risk/return considerations. The portfolios may be actively
managed to enhance overall interest income. Active management will take
place within the context of the "Prudent Person Rule." (see Section 2.4).
1. Securities Swaps
The City may take advantage of security swap opportunities to improve
portfolio yield. A swap which improves portfolio yield may be selected
even if the transaction results in an accounting loss.
2. Competitive Bidding
It is the policy of the City to require competitive bidding for all individual
security purchases except for those transactions with money market mutual
funds (MMMFs) and local government investment pools (LGIP's) which
are deemed to be made at prevailing market rates, and for government
securities purchased at issue through a primary dealer at auction price.
Rather than relying solely on yield, investment in MMMFs and LGIP's
shall be based on criteria determined by the Investment Committee,
including adherence to Securities and Exchange Commission (SEC)
guidelines for MMMFs when appropriate.
At least three bidders must be contacted in all transactions involving
individual securities. Competitive bidding for security swaps is also
required. Bids may be solicited in any manner provided by law. For those
situations where it may be impractical or unreasonable to receive three bids
for a transaction due to a rapidly changing market environment or to
secondary market availability, documentation of a competitive market
survey of comparable securities or an explanation of the specific
circumstance must be included with the transaction bid sheet. All bids
received must be documented and filed for auditing purposes.
3. Methods of Monitoring Market Price
The methods/sources to be used to monitor the price of investments that
have been acquired with public funds shall be from sources deemed reliable
by the Investment Officer, including primary or regional broker/dealers,
established financial institutions providing portfolio
management/accounting services, financial publications, such as the I/all
City of University Parlq Texas - Investment Policy
Street Journal, market information vendors such as Bloomberg or Telerate
and market pricing services.
4. Benclunark Rate of Return
As a general guideline, the City's cash management portfolio shall be
designed with the objective of regularly meeting the average return on
three-month U.S. Treasury Bills, or the average rate of 90-day Certificates
of Deposit. These indices are considered benchmarks for risk-free
investment transactions and therefore comprise a standard for the
portfolio's rate of return. Additional benchmarks may be developed and
recommended by the Investment Committee and used as a comparative
performance measures for the portfolio. Additional benchmarks that may be
considered for targeting by the Investment Committee include the Constant
Maturity Treasury Bill with the maturity that most closely matches the
weighted average maturity of the portfolio or a more customized index
made up of blended Merrill Lynch Treasury/Agency indices.
The investment program shall seek to augment rates of return above this
threshold, consistent with legal restrictions and prudent investment
principles. In a diversified portfolio, measured losses are inevitable and
must be considered within the context of the overall portfolio.
5. Responsibility and Control
1. Authority to Invest
Authority to manage the City investment program is derived from a
resolution of the City. Those authorized by said resolution are designated
as Investment Officers of the City, and, in conjunction with the Investment
Committee, are responsible for investment decisions and activities. The
City reserves the right to contract with an external investment advisory firm
to manage the investment assets, and the resulting resolution will grant
investment authorization to the contracted firm. The Finance Director shall
establish written procedures for the operation of the investment program
consistent with this Investment Policy.
2. Bonding requirements/Standard of care
Each of the authorized investment officers shall be a bonded employee. All
participants in the investment process shall act responsibly as custodians of
the public trust and shall exercise the judgment and care, under prevailing
circumstances, that a prudent person would exercise in the management of
the person's own aflhirs.
City of University Parlq Texas - Investment Policy
3. Establishment of Internal Controls
The Finance Director is responsible for establishing and maintaining an
internal control structure designed to ensure that the assets of the entity are
protected from loss, theft or misuse. The internal control structure shall be
designed to provide reasonable assurance that the objectives are met. The
concept of reasonable assurance recognizes that (1) the cost of a control
should not exceed the benefits likely to be derived; and (2) the valuation of
costs and benefits requires estimates and judgments by management.
4. Standard of Ethics
City staff involved in the investment process shall refrain from personal
business activity that could conflict with proper execution of the investment
program, or which could impair the ability to make impartial investment
decisions.
City staff shall disclose to the City any material interests in financial
institutions that conduct business with the City, and they shall further
disclose positions that could be related to the performance of the City
portfolio. City staff shall subordinate their personal financial transactions to
those of the City, particularly with regard to the timing of purchases and
sales.
An investment officer of the City who has a personal business relationship
with an organization seeking to sell an investment to the City shall file a
statement disclosing that personal business interest. An investment officer
who is related within the second degree by affinity or consanguinity to an
individual seeking to sell an investment to the City shall file a statement
disclosing that relationship. A statement required under this subsection
must be filed with the Texas Ethics Commission and the governing body of
the City.
5. Training and Education
In accordance with the Public Funds Investment Act (Chapter 2256, Texas
Government Code), the designated Investment Officers, or those personnel
authorized to execute investment transactions, must attend periodic
investment training. State law requires that training relating to investment
responsibilities must be provided by an independent source as approved by
the Investment Committee. Personnel authorized to execute or approve
investment transactions must receive at least 10 hours of investment training
within each two-year period. Newly appointed investment officers must
attain at least 10 hours of instruction relating to the officer's responsibility
under the Act within 12 months after assuming investment duties.
City of University Parlq Texas - Investment Policy
6. Investment Committee
An Investment Committee that is comprised of the membership of the
Finance Advisory Committee shall be established to determine
investment guidelines, general strategies, and monitor performance. The
Committee shall meet quarterly to review performance, strategy and
procedures. The Investment Committee shall include in its deliberation
such topics as: performance reports, economic outlook, portfolio
diversification, maturity structure, potential risk to the City funds,
authorized brokers and dealers, and the target rate of return on the
investment portfolio.
6. Reporting
Investment performance is continually monitored and evaluated by the Finance
Director. The Investment Officer(s) will provide detailed reports, as required
by the Public Funds Investment Act (Chapter 2256, Texas Government Code,
Section 2256.023) for the City on a quarterly basis.
The Finance Director shall submit a quarterly investment report signed by the
investment officers that summarizes current market conditions, economic
developments and anticipated investment conditions. The report shall
summarize investment strategies employed in the most recent quarter, and
describe the portfolio in terms of investment securities, maturities, risk
characteristics and shall explain the total investment return for the quarter.
The report will outline conformance to the restrictions of the Policy in the area
of diversification and term of maturity. The report will also compare the
performance of City's portfolio to appropriate benchmarks as determined by
the Investment Committee. The report shall summarize current market
conditions, economic developments and anticipated investment conditions. The
report shall also summarize investment strategies employed in the most recent
quarter, and describe the portfolio in terms of investment securities, maturities
and risk characteristics.
Within 60 days of the end of the fiscal year, the Finance Director or the
Investment Advisory firm shall present an annual report on the investment
program and investment activity. The report may be presented as a component
of the fourth quarter report to the City.
The quarterly investment report shall include a succinct management summary
that provides a clear picture of the status of the current investment portfolio and
transactions made over the last quarter. This management summary will be
prepared in a manner which will allow the City to ascertain whether investment
activities during the reporting period have conformed to the Investment Policy.
The report will include the following:
City of University Parlq Texas - Investment Policy
o
go
1. A listing of individual securities held at the end of the reporting period.
2. Unrealized gains or losses resulting from appreciation or depreciation
by listing the beginning and ending book and market value of securities
for the period.
3. Additions and changes to the market value during the period.
4. Average weighted yield to maturity or total return performance of the
portfolio on entity investments as compared to applicable benchmarks.
5. Listing of investments by maturity date.
6. The percentage of the total portfolio which each type of investment
represents.
7. Statement of compliance of the City investment portfolio with State
Law and the investment strategy and policy approved by the City.
Compliance Audit
In conjunction with its annual financial audit, the City shall perform a
compliance audit of management controls on investments and adherence to the
City's established Investment Policies. The results of the audit shall be reported
to the Investment Committee and the governing body of the City.
Certification
A copy of this Investment Policy will be provided to the senior management of
any bank, dealer, broker or investment advisor wishing to transact investment
business directly with the City in order that it is apprised of the investment
goals of the City. Before business is transacted with the firm, a certification
(Appendix C) must be signed by a senior member of a firm. Should the City
contract with an external investment advisor to execute the entity's investment
strategy, including the negotiation and execution of investment transactions, a
managing officer of the investment advisory firm may sign the written
certification in lieu of the broker/dealer firms. This certification must be
included as part of the investment advisory contract.
SECTION 5
ADOPTING CLAUSE
City of University Parlq Texas - Investment Policy
5. ADOPTING CLAUSE
This Investment Policy for the City of University Park, Texas is hereby adopted as of
the 20th day of August, 2003.
Mayor
Director of Finance
ATTEST:
City Secretary
48
DATE:
TO:
FROM:
SUBJECT:
AGENDA MEMO
(8/20/03 AGENDA)
August 13, 2003
Honorable Mayor and City Council
Christine Green, Purchasing Agent
Office Supplies Contract through U.S. Communities
In January of this year, the City Council approved the City's membership in the U.S. Communities
Government Purchasing Alliance, a non-profit purchasing cooperative for public agencies. U.S.
Communities off'ers an annual contract for office supplies through Office Depot. This contract
was competitively bid in May 2000 by Los Angeles County, California, and is effective through
March 2004 with the likelihood of extensions through March 2006.
Corporate Express is the City's current office supply vendor. At my request, Corporate Express
provided a list of all items the City has purchased in the last 12 months along with the price we
paid for each item. I gave this list to Office Depot and asked them to provide a price for each
item as per their U.S. Communities contract. For the 838 items priced, the City's total with
Corporate Express was $37,151.41. Office Depot's total for the same items was $26,444.35, a
savings of 28%. Attached is a spreadsheet comparing prices for each item.
In recent years, Office Depot has expanded and improved its service to commercial customers
beyond its retail stores. They have an extensive local inventory and will deliver orders the next
day. Office Depot will also extend their U.S. Communities' pricing to purchases made at their
retail stores. I believe Office Depot's service and product selection will meet or exceed that of
Corporate Express.
Thirty-six local governmental agencies are currently participating in the U.S. Communities'
contract with Office Depot. These include the cities of Dallas, Richardson, and Plano, as well as
Dallas and Collin Counties. A complete list of these agencies is attached.
I believe this contract will provide the City with the lowest possible pricing with no sacrifice in
service or selection.
RECOMMENDATION:
Staff recommends participation in the U.S. Communities office supply contract with Office
Depot.
3800 UNIVERSITY BOULEVARD UNIVERSITY PARK, TEXAS 75205 TELEPHONE (214) 363-1644
LIST OF AREA ENTITIES PARTICIPATING IN
U.S. COMMUNITIES/OFFICE DEPOT OFFICE SUPPLY CONTRACT
AS OF AUGUST 2003
City of Dallas
Dallas County
Collin County
Denton County
City of Frisco
City of McKinney
City of Allen
City of Plano
City of Richardson
Johnson County
Navarro County
Parker County
City of Flower Mound
City of Lewisville
City of Desoto
City of Duncanville
City of Mesquite
City of Grand Prairie
City of Euless
City of Bedford
City of North Richland Hills
City of Keller
City of Balch Springs
City of Bowie
Brazos River Authority
Ellis County
Dallas Housing Authority
Dallas Central Appraisal District
Ector County
City of Lancaster
City of Midlothian
Town of Prosper
City of Rowlett
Rockwall County
Town of Sunnyvale
N.C.T.C.O.G.
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U.P. 2002 PURCHASES
ss
LN
NO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2O
21
22
23
24
25
26
27
28
29
3O
31
32
33
34
35
36
37
38
39
4O
41
42
43
44
45
46
47
48
49
5O
51
52
53
54
55
56
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
PRINT CTRG,F/1600C,BK, EA
PRINT CTRG,DJ970,TRICLR
PPR CLIP,SMTH,JMBO,1C
PPR CLIP,GEM,#1,1C
CLEANER,OFFDUSTR 3,10OZ
NTBK, STENO,GN,60SH
PAD,LGL RL,PERF,LTR,WE
PRINT CTRG,INKJT 690C,BK
CORR FILM,DRYLINE,NRF,1LN
PEN,BLPT,COMFTMATE,MED,BK
FLDR,MLA, 1/3,LTR,1C
BOO K,AP PT, MO, 11 "X9", BK
BNDR CLIP,MED
PPR,1 PT, 18#, 14.8X11 ,BB
STAPLE,STD,CHSL,5M/BX
E NVL,CS P,28#,9X12, KFT, 1C
TONER CTRG,LASRJT 5SI
LEAD,SPR HIPLYMR,7MM,30TB
CAL,RFL,DESK, 12MO,3.5X6
CAL,WAL L, 12MO, 12"X17"
FLAG ,TAPE, POSTIT, B B E,50
BOO K,AP PT,G RP, 11 "XS", BK
ENVL,POLY,VELCRO,GN
ENVL, PO LY,VE LC RO, PE
BNDR CLIP,3/8",SM
PEN,ROLR,GEL,IM PACT,BK
PEN RFL,UNIGEL,MED,BK
FILE,STG,ECON,LTR/LGL
PAD,POSTIT,3X3,AQ,5PK
E NVL,CS P,28#, 10X13, KFT, 1C
CAL,WALL, 12 M O,20"X30"
PPR,CPY,20#,LTR,CY
STAPLE REMOVER,CLAW STYLE
CAL,WALL, 12 M O/PG, 15.5"X23
PAD, POSTIT,3X3, UAST,5 P K
PROT,SHT,TL,LTR,CL,50
CAL, DESK/WALL, 12 M O,22X17
CORR TAPE,WITEOUT CTRG
PRINT CTRG,HP660C,TRICLR
GLUE,ROLL-N-GLUE
ENVL, PO LY,VE LC RO, BE
ENVL, PO LY,VE LC RO, PK
PEN,U NIBALL,VIS,ELTE,BK
FILE,STG,END TAB,LTR/LGL
CORR FLUID,.6OZ,WE
PEN RFL,ROLR,IMPACT,BK
FILE,STG,ECON,LTR
PEN,BLPT,AST,GX300,M ED,BK
PEN,ROLR,JIMNIE,GEL,BK
PAD, POSTIT,3X3,YW
PEN,BLPT,FLXGRP,RET,MD,BK
C MAT,36"X48",ANTSTAT, NC
PPR CLIP,#1 ,VYL,AST,5C
PUSH PIN,PLAS,CL,1C
TAPE DSPR,DESK, I"CORE,BK
RI BN, FAX,TH RM L, KXF 1100
Order Ship
Item ID Freq Qty CEX UM
HEW51645A 23 74 EA
HEWC6578DN 15 34 EA
EXP40021 12 76 BX
EXP40020 10 81 BX
RRTRR3507 9 38 EA
EXP20000 9 135 EA
EXP11428 8 12 DZ
HEW51629A 7 24 EA
PAP06604 7 41 EA
PAP63301 7 267 EA
SMD153L 6 12 BX
AAG7026005 6 18 EA
EXP90001 6 21 DZ
EXP00048 6 26 2500CT
EXP40022 6 45 BX
QUA37890 5 5 BX
HEWC3909A 5 8 EA
PENC27HB 5 8 TB
AAGE71750 5 9 EA
AAGPM228 5 9 EA
MMM68023 5 13 EA
AAGG56000 5 16 EA
LIO22080GR 5 20 EA
LIO22080PU 5 22 EA
EXP90000 5 27 DZ
SAN65800 5 38 EA
SAN65423 5 64 EA
EXP30002 5 78 EA
MMM6545AQ 4 4 PK
QUA37897 4 4 BX
AAGPM428 4 5 EA
EXP8511CAN 4 5 RM
EXP90020 4 5 EA
AAGPM628 4 6 EA
MMM6545UC 4 6 PK
CLI62037 4 7 BX
AAGSK2400 4 9 EA
BICWOTAPP 11W 4 14 EA
HEW51649A 4 14 EA
PENER101 4 14 EA
LIO22080BL 4 16 EA
LIO22080PK 4 18 EA
SAN61231 4 24 EA
FEL00709 4 33 EA
PAP56401 4 38 EA
SAN65803 4 40 EA
FEL00701 4 44 EA
PIL34115 4 45 EA
ZEB44110 4 51 EA
MMM654YW 4 58 PD
EXP50020 4 96 EA
TEN14401 3 0 EA
EXP90003 3 3 BX
GEMCP20 3 3 BX
MMMC38BK 3 3 EA
PAN KXFA133 3 3 EA
CEX SELL CEX EXTD.
PRICE
$32.90
$36.60
$4.34
$0.66
$7.41
$32.90
$2.31
$0.53
$52.02
S0:421
$5.41
$190.53
$1.33
$1.35
$1.79
$0.97
$1.11
$7.66
$3.99
$5.41
$4.95
I $1:49I
$2.62
$33.81
$1.53
$1 .O7
$1.31
$2.73
$5.23
$O.98
I S4:241
$3.99
$1.27
$0.67
$0.90
$0.00
$2.37
$2.37
$42.24
SELL PRICE SAVINGS% SAVINGS$
$2,434.60 26.87% $654.16
$1,244.48 17.74% $220.74
$21.28 -42.86% -$9.12
$7.34 -54.50% -$4.00
$164.84 14.71% $24.24
$89.43 26.03% $23.28
$88.92 24.43% $21.72
$789.60 26.87% $212.16
$94.84 21.32% $20.22
$141.51 7.55% $10.68
$45.24 -31.03% -$14.04
$113.96 -18.62% -$21.22
$9.90 -56.97% -$5.64
$1,352.48 51.67% $698.84
$18.90 -45.24% -$8.55
$27.07 13.56% $3.67
$1,524.24 29.63% $451.68
$12.25 -7.76% -$0.95
$6.78 -36.73% -$2.49
$39.06 -5.53% -$2.16
$13.85 -34.22% -$4.74
$266.09 -1.80% -$4.79
$26.68 52.02% $13.88
$29.70 52.59% $15.62
$5.74 -64.63% -$3.71
$68.02 20.67% $14.06
$62.08 46.39% $28.80
$86.46 35.95% $31.08
$30.64 45.43% $13.92
$24.00 -23.50% -$5.64
$42.36 -30.43% -$12.89
$19.94 16.50% $3.29
$0.85 -129.41% -$1.10
$38.28 -1.57% -$0.60
$32.46 22.74% $7.38
$34.65 32.53% $11.27
$13.40 -40.37% -$5.41
$36.70 37.44% $13.74
$473.34 26.83% $126.98
$21.42 46.41% $9.94
$17.12 40.19% $6.88
$23.66 51.31% $12.14
$65.52 47.62% $31.20
$172.59 60.99% $105.27
$28.72 -3.20% -$0.92
$39.20 16.33% $6.40
$186.56 -41.75% -$77.88
$179.55 45.11% $81.00
$65.01 31.75% $20.64
$38.86 8.96% $3.48
$86.40 60.00% $51.84
$0.00 0.00% $0.00
$7.11 20.25% $1.44
$7.11 78.90% $5.61
$4.08 -47.79% -$1.95
$126.71 22.01% $27.89
OFFICE DEPOT OFFICE DEPOT
EXTD SELL SELL PRICE
PRICE (CEX UM) (CEX UM)
$1,780.441 $24;o61
$1,023.74I' ' $30'11
$30.40 $0.40
$11.34 $0.14
$59.28 $4.94
$135.18 $7.51
$15.54 $0.74
OD UM
EA
EA
BX
BX
EA
EA
DZ
EA
EA
EA
BX
EA
BX
$653.641 $2s;~41 2500CA
$27.45 $0.61
$1,072.561 $134;07I
$13.20 $1.65
$9.27 $1.03
$41.22 $4.58
$18.59 $1.43
$270.88 $16.93
$12.soI $0;64I
$9.45 $0.35
$29.64 $7.41
$55.25 $11.05
$1.95 $0.39
$38.88 $6.48
$18.81 $2.09
$29.64 $0.78
$264.44 $6.01
$0.00 $0.00
$6.03 $2.01
$98.82 I$,~!,~1
BX
BX
EA
EA
EA
EA
2PK *
EA
3PK *
3PK *
BX
DZ *
EA
EA
5PK
BX
EA
RM
3PK *
EA
5PK
BX
EA
EA
EA
EA
3PK *
3PK *
EA
EA
EA
2PK *
EA
EA
EA
DZ *
EA
EA
BX
BX
EA
EA
SELL PRICE
(OD UM
UM WHERE
DIFF DIFF)
$2.85
$1.92
$1.92
$17.08
$1.160
$1.92
$1.92
$1.64
$7,27
Page 1 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U,P, 2002 PURCHASES
SS
LN
NO
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
8O
81
82
83
84
85
86
87
88
89
9O
91
92
93
94
95
96
97
98
99
lO0
101
102
103
104
105
106
107
108
109
110
111
112
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
E NVL,CS P,32#,9X12, KFT, 1C
CAL,WALL, 12MO,15.5"X23"
RACK, STE P,SS EC,WI RE, BK
PAD, POSTIT, 1.5X2, U LT,AST
PAD, POSTIT,3X5, UAST,5 P K
CALC,HVY DTY,2CLR,12DGT
CAL,WALL,YR,24"X36"
GLUE PEN,RFL,4PK
FLAG ,TAPE, POSTIT,YW,50
BNDR CLIP,AST,30EA/TUB
ARCH BOAR D,9"X15.5"
HILITER,MJR ACNT,6ST
PRINT CTRG,STY740,BK
FLDR,INTR,1/3,LTR,1C
P P R,C PY,20#,84 B, LTR,3 H P
PRINT CTRG,F/DJ970,TRI-C
PAD,POSTIT,3X5,AQ,5PK
CAL,RFL,DESK, 3.5"X6"
PAD, POSTIT, 1.5X2,YW
FLAG ,SIG N/R ETN, RD, 120
CASSETTE, M lC RO,60 M I N ,3PK
FLAG,TAPE,SIGN HERE,YW,50
STAPLE REMOVER,BK
PPR,1 PT,20#, 9.5X11 ,PRF
PRINT CTRG,HP720C/890
H I LITER, M R KLITE R,YW/B K
HILITER,DESK STYLE,YW
PEN,BLPT,STK, MED,BK
ENVL, PO LY,VE LC RO, BK
IN DEX, BN DR,LTR,WE,STB
TAPE,EM BS, 1/2",BK/WE,2PK
CAL,DESK,WK, EXEC PLNR
IN DEX, BN DR,LTR,AST,STB
PEN,BLPT,RET,MED,BK
CASE,BINDING,HGH,ARCH,3.1
HILITER,PEN STYLE,FYW
PEN,ROLR,GEL,FN,BK
FILE,STG,ECON,LGL
INDEX,SD TAB,LTR,26-50
FILE PKT,LTR,2/5R,3.5"
PEN RFL,UNIGEL,MED,BE
PEN,BLPT,RET,CLCSTK, M D,BK
PEN,BLPT,RET,SAGA, M ED,BK
EASEL PAD,27×34,PLN,RCY
SHREDDER,PRSNL,CRSCT
CAL BASE,E717,S170,BK
CAL,DESK PD,MO,22X17,GN
CAL, R F L,WALL, F/K1-00
CAL,WALL,YR, ERS,2'X3'
CAL,DESK, 12M,RFL,3.5X6
SH EARS,OFF, LE FTY,8"
RUBRBAND,ADV,#19,1/4LB
H I LITER, POSTIT,W/H LD R,SST
REINFORCMNT,9/16,WE,2C
MAGNIFIER,RND,2X,5"
SCRAPER, BLADE, RAZOR,CE
Order Ship
Item ID Freq Qty CEX UM
QUA37790 3 3 BX
AAGPM328 3 4 EA
FEL72614 3 4 EA
MMM653AU 3 4 PK
MMM6555UC 3 4 PK
SHRELl197P 3 4 EA
AAGPM1228 3 5 EA
AVE00416 3 5 PK
MMM6805 3 5 EA
01031026 3 5 EA
01083120 3 5 EA
SAN25076 3 5 ST
EPSS020189 3 6 EA
ESS421013 3 6 BX
EXP8511P 3 6 RM
HEWC6578AN 3 6 EA
MMM6555AQ 3 6 PK
AAGE51750 3 7 EA
MMM6539YW 3 7 PK
BTE81344 3 8 PK
MAX179030 3 8 PK
MMM6809 3 8 EA
SWl38101 3 8 EA
EXP00180 3 9 2200CT
HEWC1823D 3 9 EA
PIL45600 3 9 EA
AVE07742 3 10 EA
EXP50010 3 12 DZ
LIO22080BK 3 12 EA
AVEWT2138 3 13 ST
B RTTC20 3 14 P K
AAGG26200 3 18 EA
AVE23079 3 21 ST
PIL32220 3 22 EA
FEL47200 3 31 EA
AVE23591 3 36 EA
PIL31020 3 36 EA
FEL00702 3 38 EA
AVELGLTS2650 3 43 ST
SMDR1370E 3 62 EA
SAN65425 3 72 EA
BICCSM 11BK 3 92 EA
SAN79011 3 144 EA
EXP20010 2 0 EA
GBC1750300 2 1 EA
AAGE1700 2 2 EA
AAGGG250003 2 2 EA
AAGK150 2 2 EA
AAGPM21028 2 2 EA
AAGSW571750 2 2 EA
ACM10513 2 2 EA
ALL26197 2 2 BG
AVE48508 2 2 ST
AVETD909 2 2 PK
BAL813305 2 2 EA
BOS28500 2 2 EA
CEX SELL CEX EXTD.
PRICE
$12.66
$6.51
$7.5O
$5.59
$6.88
$89.99
$5.21
$4.00
$4.32
$26.89
$13.32
$4.13
$66.73
$7.26
$3.86
$2.38
$4.12
$2.50
$2.09
$30.09
$36.56
$1.69
$0.55
$1.63
$1.22
$1.26
$19.89
$41.94
$1.80
$0.77
$11.32
$0.47
$1.59
$4.78
$5.4O
$0.97
$0:261
$0.74
$0.00
$209.62
$8.51
$5.18
$6:391
$13.37
$14.88
$11.59
$0.69
$11.44
$1.00
$26.75
SELL PRICE SAVINGS% SAVINGS$
$37.98 46.60% $17.70
$26.04 0.46% $0.12
$30.00 34.93% $10.48
$22.37 22.40% $5.01
$27.53 22.27% $6.13
$359.96 51.14% $184.08
$26.05 6.33% $1.65
$12.37 -8.73% -$1.08
$5.37 -18.25% -$0.98
$19.98 29.18% $5.83
$21.60 42.13% $9.10
$10.45 -35.41% -$3.70
$161.32 19.92% $32.14
$79.92 8.33% $6.66
$24.75 28.24% $6.99
$400.38 19.41% $77.70
$43.54 26.27% $11.44
$26.99 32.31% $8.72
$16.67 41.21% $6.87
$32.93 36.35% $11.97
$20.00 25.60% $5.12
$9.52 -23.53% -$2.24
$16.72 8.13% $1.36
$270.84 42.98% $116.40
$329.04 26.12% $85.95
$15.21 44.97% $6.84
$5.50 40.00% $2.20
$19.56 45.40% $8.88
$14.60 47.40% $6.92
$16.38 30.16% $4.94
$278.44 0.50% $1.38
$754.98 46.00% $347.28
$37.80 38.33% $14.49
$16.94 36.36% $6.16
$350.92 36.75% $128.96
$16.92 29.79% $5.04
$57.24 31.45% $18.00
$181.64 38.49% $69.92
$232.20 8.33% $19.35
$93.62 -3.31% -$3.10
$69.84 38.14% $26.64
$23.92 -3.85% -$0.92
$106.56 63.51% $67.68
$0.00 0.00% $0.00
$209.62 24.23% $50.80
$17.02 33.61% $5.72
$10.36 59.65% $6.18
$12.77 -122.08% -$15.59
$26.74 25.65% $6.86
$29.76 33.53% $9.98
$23.18 85.07% $19.72
$1.38 14.49% $0.20
$22.88 31.12% $7.12
$2.00 32.00% $0.64
$53.49 73.30% $39.21
$5.74 -9.76% -$0.56
OFFICE DEPOT
EXTD SELL
PRICE (CEX UM)
SELL PRICE
OFFICE DEPOT (OD UM
SELL PRICE UM WHERE
(CEX UM) DIFF DIFF)
$13.45 $2.69
$6.35 $1.27
$12.501 $2'50I
$14.15 $2.83
$11.76 $1.47
$96.72 $1.56
$24.84 $0.27
$0.00 $8.77
$28.36 $14.18
$6.30 $3.15
OD UM
BX
EA
EA
PK
PK
EA
EA
4PK
2PK
EA
EA
ST
EA
BX
10RM CA
EA
PK
EA
PK
EA
3PK
2PK
EA
2500CA
EA
EA
EA
DZ
3PK
ST
2PK
EA
ST
DZ
EA
EA
EA
12CT
ST
EA
EA
EA
EA
2CT
EA
EA
EA
EA
EA
EA
PR
BG
ST
PK
EA
EA
* $2.54
* $29.60
* $2.94
* $19.50
* $1.92
* $5.87
* $35.32
* $17.54
Page 2 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U.P. 2002 PURCHASES
ss
LN
NO
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
TONER CTRG,CAN H116221
RACK, SO RTE R,CO M B, EY
FLDR,FILE,1/3C,LTR,AST,30
RUBRBAND,#19,1/4LB
RUBRBAND,#32,1/4LB
LETTER OPENER,SERATD,8.5"
SHEARS,BENT,8",SS
TRAY,WI R E,3" D, LTR, BK
SHREDDER BAG,F1256S,1656S
STAPLER,ELEC,PY
STAPLER,ELEC,RAPID R55
DISK, 3.5",DSHD,IBM FRMT
DICTNARY,CO LLEG E, H RDBK
FLAG ,TAPE, POSTIT, RD,50
POSTIT DSPR,FLAG
RIBN,PTR,OKI ML390/391 ,BK
PEN RFL,BLPT,RET,M ED,BK,2
HANGER,PARTITN,BK
MRKR,SHARPIE,TWN TP,4ST
PEN,BLPT,PHD,MED,CP
STAPLER,GUN,SR
CMAT,46"X60",NO LIP,CLT
WAST E BS KT, R ECT,28QT, BK
PAD,LGL RL,PRISM,5XS,IY
CALC,SCIENCE,HNDHLD,10DGT
CAL,WALL,ERS,2SD
CAL,WALL,ERS,2SD
BOO K,AP PT, M O,8.75"X7", BK
BOOK,APPT, 12 MO,SX11 ,BK
RULER,STAINLS STL, 12"
SH EARS,BENT,8",SS,BE
LBL, LAS R,AD D,2-5/SX1,3M
MRKR,MRKSALOT,LG,BK
PEN ,VELOCITY, R ET,AST,5 P K
BLADE,RAZOR,SGL EDGE,10PK
ORGNZ,SHLF,6X6,CL
RIBN,PTR,PAN KX1090,BK
PPR,CPY,20#,LTR,BE
PPR,CPY,20#,LTR,GN
SHEARS,STRT,FORGED,7"
PRINT CTRG,DESKJT,BK
TONER CTRG,LASRJT 3/4SI
TONER CTRG,LASR,HP2100
TONER CTRG,HP4000,6M
DICTNARY,THESRS,E×PD ED
DISK, 3.5",DSH D,FRMT,NAST
MOUSE,TRACKBALL,TU RBOBALL
PAD, POSTIT,3X3,S N BRTE
POSTIT,CUBE DSGNR,690SH
ORGNZ,DRW, 16X9X1.7
LEAD,MECH PCL,.5MM,HB,30
ENVL,CAT,28#, 9X12, REDSTP
PCL GRIP,FOAM,AST,2PK
HILITER,LIQ ACNT,5ST
MRKR,SHARPIE,TWN TIP,BK
CLEANER,BOARD,8OZ
Order Ship
Item ID Freq Qty CEX UM
CAN1551A002 2 2 EA
ELD17371 2 2 EA
ESS02086 2 2 30PK
EXP00615 2 2 BG
EXP00616 2 2 BG
EXP90021 2 2 EA
EXP91004 2 2 EA
FEL60112 2 2 EA
GBC1765001 2 2 100CT
HUN73100 2 2 EA
HUN73112 2 2 EA
MAX556423 2 2 BX
MER10 2 2 EA
MMM6801 2 2 EA
MMMDS420 2 2 EA
OKI52104001 2 2 EA
PIL77227 2 2 PK
ROG13406 2 2 ST
SAN32274 2 2 4ST
SAN70122 2 2 EA
sw~10105 2 2 EA
TEN12113 2 2 EA
TEN69176 2 2 EA
TOP63030 2 2 DZ
VCT9302 2 2 EA
VIOA1102 2 2 EA
WOA1152 2 2 EA
AAGG40000 2 3 EA
AAGG52000 2 3 EA
ACM10415 2 3 EA
ACM43218 2 3 EA
AVE05160 2 3 BX
AVE08888 2 3 EA
BICVLGP51AST 2 3 PK
BOS28510 2 3 PK
ELD29891 2 3 EA
EXP25200 2 3 EA
EXP8511BLU 2 3 RM
EXP8511GRE 2 3 RM
EXP91001 2 3 EA
HEW51640A 2 3 EA
HEW92291A 2 3 EA
HEWC4096A 2 3 EA
HEWC4127A 2 3 EA
HOUH03020 2 3 EA
IMNl1916 2 3 BX
KMW64227 2 3 EA
MMM6545SB 2 3 PK
MMM678HF 2 3 PD
oic21312 2 3 EA
PENC25HB 2 3 TB
QUA44562 2 3 BX
ROG14004 2 3 2PK
SAN24555 2 3 ST
SAN32001 2 3 EA
SAN81803 2 3 EA
CEX SELL CEX EXTD.
PRICE
$105.00
$32.76
$1.90
$1.95
$3.33
$33.88
$44.31
$38.96
$3.72
$27.95
$1:06I
$14.23
$9.21
$0.78
$6.99
$5.O4
$7.29
$19.53
$138.15
$4.90
$10.00
$15.84
$21.95
$28.5O
$4.95
$25.46
$0.46
$6.26
$2.57
$6.17
$2i921
$4.04
$4.04
$3.45
$20i61 I
$130.77
$109.37
$108.46
$21.00
$5.12
$63.44
$5.98
$11.20
$1.66
$O.87
$14.67
$O.89
$5.52
$1.69
$1.96
SELL PRICE SAVINGS% SAVINGS$
$210.00 33.45% $70.24
$65.52 59.58% $39.04
$12.82 -50.08% -$6.42
$1.18 0.00% $0.00
$1.18 0.00% $0.00
$3.80 5.26% $0.20
$3.90 11.28% $0.44
$6.66 35.44% $2.36
$67.75 60.21% $40.79
$88.61 25.58% $22.67
$77.92 49.72% $38.74
$7.44 26.08% $1.94
$55.90 52.77% $29.50
$2.12 -19.81% -$0.42
$28.46 55.94% $15.92
$18.42 14.12% $2.60
$1.56 7.69% $0.12
$13.98 29.33% $4.10
$10.08 7.94% $0.80
$14.58 37.04% $5.40
$39.06 26.98% $10.54
$276.30 65.31% $180.46
$9.79 56.49% $5.53
$20.00 35.10% $7.02
$31.68 48.11% $15.24
$43.90 69.20% $30.38
$57.00 65.12% $37.12
$15.16 -6.66% -$1.01
$21.06 -6.27% -$1.32
$5.82 -27.84% -$1.62
$14.85 65.05% $9.66
$76.38 26.12% $19.95
$1.38 15.22% $0.21
$18.78 34.19% $6.42
$7.71 77.43% $5.97
$18.51 46.19% $8.55
$8.76 -102.40% -$8.97
$12.12 17.08% $2.07
$12.12 17.57% $2.13
$10.35 73.62% $7.62
$61.83 -31.44% -$19.44
$392.31 29.63% $116.25
$328.11 26.11% $85.68
$325.38 17.65% $57.42
$63.00 45.00% $28.35
$15.35 10.29% $1.58
$190.32 30.66% $58.35
$17.95 30.14% $5.41
$33.61 36.72% $12.34
$4.98 12.05% $0.60
$2.61 36.78% $0.96
$44.01 41.72% $18.36
$2.67 68.54% $1.83
$16.56 22.64% $3.75
$5.08 31.50% $1.60
$5.88 8.67% $0.51
OFFICE DEPOT
EXTD SELL
PRICE (CEX UM)
SELL PRICE
OFFICE DEPOT (OD UM
SELL PRICE UM WHERE
(CEX UM) DIFF DIFF)
$19.24 $9.62
$1.18 $0.59
$1.18 $0.59
$16.17 $5.39
$22.38 $7.46
$7.44 $2.48
$17.73 $5.91
$10.05 $3i35
$9.99 $3i33
$2.73 $0i91
$81.27 $27.09
$276.06 $92i02
$242.43 $80i81
$267.96 $89i32
$34.65 $11i55
$13.77 $4i59
$131.97 $43i99
$12.54 $4;18
$21.27 $7;09
$4.38 $1i46
$1.65 $0;55
$25.65 $8;55
$0.84 $0;28
$12.81 $4;27
$3.48 $1;16
$5.37 $1;79
OD UM
EA
EA
30PK
BG
BG
EA
PR
EA
250BX *
EA
EA
BX
EA
2PK *
EA
EA
2PK
2PK
5PK *
EA
EA
EA
EA
DZ
EA
EA
EA
EA
EA
EA
PR
BX
EA
5PK
100BX *
EA
EA
RM
RM
PR
EA
EA
EA
EA
EA
BX
EA
5PK
EA
EA
3PK *
BX
5PK *
5PK
EA
EA
$33.69
$2.54
$5.80
$5.78O
$1.65O
$0.71
Page 3 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U,P, 2002 PURCHASES
ss
LN
NO
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
2OO
201
2O2
2O3
2O4
2O5
2O6
2O7
2O8
2O9
210
211
212
213
214
215
216
217
218
219
22O
221
222
223
224
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
TAB,HANG FLDR,1/5,CL,25
STAPLE REMOVER,ULTMTE,GY
PAD,LGL RL,PERF,LTR,WE
CAL,WALL,3 M O/PG, 12.25"X27
RULER,STAINLS STL, 6"
GLUE PEN,RFLBLE
LBL, LASR, F F LD R,AST,750
PEN,BLPT,RND STK, MED,BE
PRINT CTRG,FAX, BK
FILE JACKET, I"EXP,LTR,MLA
FLDR,CLAS,LGL,2DV, LBE
RUBRBAND,#64,1/4LB
PPR,CPY,20#,LTR,PK
TONER CTRG,LASRJT 5P/5MP
PAD, POSTIT,3X5, NAST,5 P K
RIBN,PTR,OKI ML182,BK
CAL,WALL,ORG NZ,YR,24X36
CAL, D ES K/WALL,22X17,QN
BNDR CLIP,#50,MED
FLDR, HANG ,3.5", POLY, BE
FLDR, HANG ,3.5", POLY, BK
AIR DUSTER,10OZ
PRINT CTRG,DESKJT,BK
TAPE,SEAL,2"XS00",CL
PEN,BLPT,STK, MED,BK
FLDR,MLA, 1/2,LTR,1C
BNDR,DRNG,LTR,4",DBE
TAB,INS,HANG FLDR,1/5,1C
PEN,BLPT,RZL-DZL,M ED,GN
HILITER,LIQ ACNT,FOR
HILITER,LIQ ACNT,FPK
IN D EX,TAB, 1/3X2 ,C L,25 P K
CORR FLUID,QUICKDRY
H I LITER, PKT, FLU RSC NT,6
FLAG ,TAPE, POSTIT, BG N ,50
PEN,BLPT,STK, FN,BK
TAB,HANG FLDR,1/3,CL,25
ADD ROLL,2.25"X150',WE
RIBN,PTR,IBM 2380,2390,BK
ENVL,POLY,VELCRO,CL
F LD R,TT, 1/3, LT R,AST, 12
PAD, LG L RL, LTR,YW/WE,50SH
BNDR,3RG,LTR,I",BE
CORR TAPE,1LN,N/RFL
GLUE STICK,.25OZ,PE
DISK, 3.5",DSH D,FMT,AST
HILITER,LIQ ACNT,FYW
BNDR,VU,3RG,LTR,1.5",WE
BNDR CLIP,.25",MINI
PEN,BLPT,CUSHN,STK, MED,RD
FILE,STG,9X4
FRAM E,WD,8.5X11 ,BK
CLIPBOARD,9"X12.5",BN
MRKR,FELT,MAGNUM,LG,BK
BNDR,DRNG,LTR,1.5",MN
I NDEX, ERSBLE,LTR,WE,STB
Order Ship
Item ID Freq Qty CEX UM
SMD64600 2 3 PK
sw~38121 2 3 EA
TOP63410 2 3 DZ
AAGPM1128 2 4 EA
ACM10414 2 4 EA
AVE00331 2 4 EA
AVE05266 2 4 P K
BICGSMG 11 BE 2 4 DZ
BRTPC201 2 4 EA
ESS22100 2 4 50BX
ESS2257LB 2 4 EA
EXP00619 2 4 BG
EXP8511PIN 2 4 RM
HEWC3903A 2 4 EA
MMM6555PK 2 4 PK
OKI52102001 2 4 EA
WOA102 2 4 EA
AAGSK70000 2 5 EA
A0072050 2 5 DZ
BSP38122 2 5 PK
BSP38125 2 5 PK
FEL99790 2 5 EA
HEW51626A 2 5 EA
MMM142 2 5 RL
PAP33311 2 5 DZ
SMD152L 2 5 BX
WLJ38354BL 2 5 EA
AVE11136 2 6 PK
PENBK92RDDA 2 6 EA
SAN24406 2 6 EA
SAN24429 2 6 EA
AVES201 2 7 PK
BICWOFQD12 2 7 EA
EXP51104 2 7 ST
MMM68022 2 7 EA
PAP33811 2 7 DZ
SMD64615 2 7 PK
EXP20213 2 8 PK
EXP25308 2 8 EA
LIO22080CR 2 8 EA
SMDSS3A 2 8 PK
TOP99625 2 8 PK
EXP60023 2 9 EA
MAN0020501 2 9 EA
MMM6108 2 9 EA
MAX556437 2 10 BX
SAN24425 2 10 EA
WLJ36134 2 10 EA
EXP90004 2 12 DZ
BICSGSM11RD 2 15 EA
FEL00706 2 15 EA
NUD17081 2 15 EA
o~c83100 2 16 EA
SAN44001 2 16 EA
CRD11457 2 18 EA
EXP10041 2 18 ST
CEX SELL CEX EXTD.
PRICE
$2.11
$2.09
$20.64
$11.51
$1.49
$2.65
sl 1 :s6I
$2.91
$25.71
$22.62
$6.30
$°:s91
$3.91
$89.10
$4;631
$7.64
$20.95
$8.57
$1.36
$8.17
$8.17
$7.17
$22:031
$1.96
$1.05
$10.05
$11.33
$1.16
$1.47
$1.73
$1.73
$4.O5
$1.53
$2:301
$1.64
$1.05
$2.57
$5.14
$4.88
$1 .O7
$2:7Sl
$5.41
$1.77
$2.21
$0.96
$4.36
$1.36
$5.32
$0.61
$0.51
$4.96
$6.60
$10.71
$1.29
SELL PRICE SAVINGS% SAVINGS$
$6.33 29.38% $1.86
$6.27 37.80% $2.37
$61.92 38.32% $23.73
$46.05 51.88% $23.89
$5.96 9.40% $0.56
$10.58 69.38% $7.34
$46.24 -0.87% -$0.40
$11.65 45.75% $5.33
$102.84 20.38% $20.96
$90.48 44.74% $40.48
$25.20 44.92% $11.32
$2.36 0.00% $0.00
$15.64 14.83% $2.32
$356.40 32.83% $117.00
$18.52 -15.55% -$2.88
$30.56 21.47% $6.56
$83.80 52.55% $44.04
$42.85 31.04% $13.30
$6.80 40.44% $2.75
$40.85 32.80% $13.40
$40.85 32.80% $13.40
$35.85 48.40% $17.35
$110.15 -9.21% -$10.15
$9.80 17.86% $1.75
$5.25 15.24% $0.80
$50.25 42.89% $21.55
$56.65 38.31% $21.70
$6.96 8.62% $0.60
$8.82 63.27% $5.58
$10.38 50.87% $5.28
$10.38 50.87% $5.28
$28.35 38.27% $10.85
$10.71 46.41% $4.97
$16.13 -11.97% -$1.93
$11.48 22.56% $2.59
$7.35 5.71% $0.42
$17.99 32.30% $5.81
$41.08 36.71% $15.08
$39.04 23.16% $9.04
$8.56 40.19% $3.44
$22.24 -20.86% -$4.64
$43.28 30.13% $13.04
$15.93 45.20% $7.20
$19.89 27.60% $5.49
$8.64 75.00% $6.48
$43.62 23.66% $10.32
$13.58 37.41% $5.08
$53.20 28.57% $15.20
$7.32 34.43% $2.52
$7.65 47.06% $3.60
$74.40 8.27% $6.15
$99.00 8.33% $8.25
$9.60 -5.00% -$0.48
$23.84 -32.89% -$7.84
$192.78 68.81% $132.66
$23.22 31.78% $7.38
OFFICE DEPOT
EXTD SELL
PRICE (CEX UM)
SELL PRICE
OFFICE DEPOT (OD UM
SELL PRICE UM WHERE
(CEX UM) DIFF DIFF)
$46.64 $11.66
$21.40 $5.35
$120.30 $24.06
$18.06 $2.58
$26.88 $3.36
$30.24 $3i78
$8.73 $0;97
$14.40 $1;60
$2.16 $0;24
$33.30 $3;33
$8.50 $0;8s
$38.00 $3;80
$4.80 $0;40
$4.05 $0;27
$68.25 $4;55
$90.75 $6;05
$10.08 $0.63
$31.68 $1.98
OD UM
PK
EA
DZ
EA
EA
2PK * $1.62
PK
DZ
EA
EA * $0.25
EA
BG
RM
EA
5PK
EA
EA
EA
BX
3PK
3PK
EA
EA
RL
DZ
BX
EA
PK
6PK * $3.23
DZ * $10.16
DZ * $10.16
PK
3PK * $2.47
6PK
2PK * $2.54
DZ
PK
12PK
EA
3PK * $1.92
PK
2PK
EA
EA
4PK * $O.95
BX
DZ * $10.16
EA
BX
DZ * $3.25
EA
EA
EA
EA
EA
ST
Page 4 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U,P, 2002 PURCHASES
SS
LN
NO
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
24O
241
242
243
244
245
246
247
248
249
25O
251
252
253
254
255
256
257
258
259
26O
261
262
263
264
265
266
267
268
269
27O
271
272
273
274
275
276
277
278
279
28O
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
F ILE,QUIKSTG,LTR/LGL,WE
PAD, POSTIT,3X3,YW
PAD, POSTIT,3X5,YW
PEN,BLPT,RET,MED,BE
PEN,BLPT,ERSRMTE,MED,BK
INDEX,SD TAB,LTR,1-25
PEN,ROLR,GRIP,MICRO FN,BK
IN D EX,WRTO N, LTR,STB,WE
NTBK,WB END,3"X5"
PEN RFL,SLCTP,FN,BK
PCL,MECH,CMFRT MATE
PEN RFL,ROLR,IMPACT,BE
PEN,BLPT,CUSHN,RET,MED,BK
PEN,BLPT,COMFTMATE,MED,BE
FLDR, PB,2 P KT,2/5, LTR, BRD
PEN,BLPT,EZTCH,BRD,BK
PPR,CPY,20#,84B,LTR,WE
MOUSE CRADLE,UNDRDSK, CC
PROT,SHT,TL,A4,CL,50
C MAT,46"X60", UTI L,CLT
BNDR,DATA, 11X14.8,BST,LBE
FURN ASSEMBLY CHARGE
*RAN528522116 2003 ROAD ATLAS
* 20249 SELF-INKING DATER
* 21011 6X6 NAMEPLATE
* 6956 SELF-INKING DATE STAMP
* 7329 NAMEPLATE
* 7462 PRE-INKED STAMP
16161 SELF-INKING DATE STAMP
16218 6X6 ADA SIGN
17567 SELF-INKING DATE STAMP
BOO K,AP PT, PRO, LTR, BK
BOOK,APPT,WK/MO,8"X5",BK
BOOK,APPT,WK/MO,6X3.75,BK
BOO K,AP PT, PRO, M O,6"X4", BK
BOOK,APPT,WK,8.75"X7",BK
CAL BASE,E717,S170,BK
CAL,WALL,TODAYIS,9-3/SX12
CAL, RFL, F/K4-00,8.5"XS"
CAL,WALL,2 M O/PG, 15.5"X22"
CAL,WALL,ERS,90DY
BOOK,APPT, DY,8"X5", BK
CAL, RFL, F/S KS-00
CAL RFL,FLP-WK,WE
FLDR,PB,LTR,SPR,ERD
BNDR,DATA, 14.8"X11",DBE
BN DR, DATA, 14.8"X11 ",GY
RING,BOOK,2",12BX
PUNCH ,2-3H L,ADJ ,40S H, BK
PUNCH ,3-7H L,ADJ ,40S H, BW
RULER,ACRY, DATA, 15"
SHEARS,BENT HDL,8",SS
SHEARS,STRT,FORGED,7"
SH EARS, KLE N CT,STR,8", RD
RULER,COMPUTER,15"
SHEARS,SAFTY,7",RCY, BK
Order Ship
Item ID Freq Qty CEX UM
FEL00789 2 18 EA
MMM6549YW 2 18 PD
MMM655YW 2 18 PD
PIL32221 2 18 EA
PAP39301 2 22 EA
AVELGLTS125 2 24 ST
BICRV11BK 2 24 EA
AVE23078 2 28 ST
AVE31120 2 30 EA
CRO8444 2 36 EA
PAP65501 2 36 EA
SAN65804 2 36 EA
BICSCSM 11BK 2 60 EA
PAP63101 2 96 EA
SMD14082 2 100 EA
PIL32300 2 120 EA
EXP8511 2 800 RM
ccP76545 1 -1 EA
CLI08037 1 -1 BX
ELD64429 1 -1 EA
ACC54272 1 0 EA
AAAFURNASY 1 1 LT
AAASPECSPR 1 1 LT
AAASTAMPRUB 1 1 LT
AAASTAMPRUB 1 1 LT
AAASTAMPRUB 1 1 LT
AAASTAMPRUB 1 1 LT
AAASTAMPRUB 1 1 LT
AAASTAMPRUB 1 1 LT
AAASTAMPRUB 1 1 LT
AAASTAMPRUB 1 1 LT
AAG7095005 1 1 EA
AAG760205 1 1 EA
AAG760305 1 1 EA
AAGG45000 1 1 EA
AAGG53500 1 1 EA
AAGJ 1700 1 1 EA
AAGK400 1 1 EA
AAGK450 1 1 EA
AAGPM1328 1 1 EA
AAGPM23928 1 1 EA
AAGSK4400 1 1 EA
AAGSK850 1 1 EA
AAGSW70650 1 1 EA
ACC 15995 1 1 EA
ACC53073 1 1 EA
ACC53074 1 1 EA
ACC72002 1 1 BX
ACC74350 1 1 EA
ACC74400 1 1 EA
ACM10580 1 1 EA
ACM10703 1 1 EA
ACM19017 1 1 EA
ACM40618 1 1 EA
ACM40711 1 1 EA
ACM44218 1 1 EA
CEX SELL CEX EXTD.
PRICE
$2.39
$0.38
$0.97
$0.77
$O.89
$5.4O
$1.24
$1.43
$O.38
$0.53
$1.07
$O.53
$O.53
I $3:1Ol
$0.90
$3.58
$61.57
$5.46
$56.97
$0.00
$12.57
$11.86
$16.07
$11.36
$10.27
$9.95
$12.59
$36.34
$30.37
$12.89
$13.37
$7.31
$5.99
$4.14
$4.14
$2.34
$31.49
$54.89
$1.5O
$2.37
$4.O5
$2.37
$3.59
$4.41
SELL PRICE SAVINGS% SAVINGS$
$43.02 4.60% $1.98
$6.84 39.47% $2.70
$17.46 6.19% $1.08
$13.86 36.36% $5.04
$19.58 57.30% $11.22
$129.60 8.33% $10.80
$29.76 37.90% $11.28
$40.04 38.46% $15.40
$11.40 13.16% $1.50
$45.72 -22.83% -$10.44
$19.08 7.55% $1.44
$38.52 23.36% $9.00
$31.80 32.08% $10.20
$50.88 7.55% $3.84
$310.00 -7.42% -$23.00
$108.00 40.00% $43.20
$2,864.00 35.75% $1,024.00
-$61.57 62.53% -$38.50
-$5.46 -48.35% $2.64
-$56.97 46.74% -$26.63
$0.00 0.00% $0.00
$12.57 0.00% $0.00
$14.95 0.00% $0.00
$71.90 0.00% $0.00
$56.00 0.00% $0.00
$49.95 0.00% $0.00
$15.00 0.00% $0.00
$21.75 0.00% $0.00
$38.90 0.00% $0.00
$56.00 0.00% $0.00
$42.90 0.00% $0.00
$11.86 17.71% $2.10
$16.07 42.19% $6.78
$11.36 41.99% $4.77
$10.27 34.18% $3.51
$9.95 8.34% $0.83
$12.59 4.37% $0.55
$36.34 37.07% $13.47
$30.37 24.70% $7.50
$12.89 49.81% $6.42
$13.37 8.30% $1.11
$3.88 -52.32% -$2.03
$4.97 -1.61% -$0.08
$7.31 22.57% $1.65
$5.99 78.63% $4.71
$4.14 42.27% $1.75
$4.14 42.27% $1.75
$2.34 -232.48% -$5.44
$31.49 37.38% $11.77
$54.89 64.07% $35.17
$1.50 8.00% $0.12
$2.37 27.00% $0.64
$4.05 77.53% $3.14
$2.37 31.65% $0.75
$3.59 61.56% $2.21
$4.41 6.35% $0.28
OFFICE DEPOT OFFICE DEPOT
EXTD SELL SELL PRICE
PRICE (CEX UM) (CEX UM)
$56.16 $1.56
$333.00 $3.33
SELL PRICE
(OD UM
UM WHERE
OD UM DIFF DIFF)
3PK * $6.85
DZ * $2.80
DZ * $10.87
DZ * $5.87
5PK * $1.92
ST
DZ * $9.18
ST
3PK * $O.99
EA
EA
2PK * $1.64
EA
EA
EA
$1,840.001 $2:301 10RM CA
-$23.07 $23.07
-$8.10 $8.10
-$30.34 $30.34
$0.00 $2.39
$12.57 $12.57
$5.91 $5.91
$5.O5 $5.O5
EA
BX
EA
EA
LT
LT
LT
LT
LT
LT
LT
LT
LT
LT
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
BX
EA
EA
EA
PR
PR
2PK
EA
PR
* $23.01
$3.24
Page 5 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U.P. 2002 PURCHASES
SS
LN
NO
281
282
283
284
285
286
287
288
289
29O
291
292
293
294
295
296
297
298
299
3OO
301
3O2
3O3
3O4
3O5
3O6
3O7
3O8
3O9
310
311
312
313
314
315
316
317
318
319
32O
321
322
323
324
325
326
327
328
329
33O
331
332
333
334
335
336
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
NTBK, P KT,4X8, N R,G REGG
DESK PAD,20X36,RHNOLN,BK
CALC, DESK, D/PWR,8 DGT
LBL,TAB,3.5X7/16,WE,5M
LBL, LAS R,AD D,3-1/3X4,6C
LBL, LASR, F F LD R,WE, 15C
BN DR,4RG,LH,LGL,2",BK
LBL,LASR,RM,2/3X3-7/8
MRKR,MRKSALOT,LG,GN
MRKR,MRKSALOT,LG,BE
MRKR,MRKSALOT,LG,RD
LBL, IN KJT,VI D EO,WE,40 P K
STAMP PAD,FOAM,#1 ,BK
HILITER,PEN STYLE,6ST
HILITER,BOSS,SST
PCL,MECH,E-GRIP,GP
PROT,SHT,TL,SHW, DMND CL
INDEX,SD TAB,LTR,A-Z
P ROT,S HT,TL, LTR, NG ,50
INDEX, RDY, LTR,MO,AST
BNDR,3RG,CTHRU,LTR,I",RD
IN D EX,TAB LE/TAB, M O,AST
CLIP,WALL PANEL,BG,4PK
PPR CLIP,PLAS,×L,AST,50
SHARPEN ER,PCL,DESK, SK
DECANTER,VPR/VPS,DECAF
TONER CTRG,CAN 6012
TONER BTL,CAN NP6045
TONER CTRG,CN4000,FX-3
COPYHLDR,CLIP,LGY
CATALOG,CE SOURCE BK,2002
CD WALLET, KOSKI N,208CAP
PROT,SHT,TL,LTR,CL,25
BUS CRD HLDR,TOP LD,P/S
CD STG,PS,10PK
BN DR, DRNG,VU, LTR, 1 ",WE
ORGNZ,BN DR,RGNT,ZP,LEA, BY
FILE,WALL,STRTR,BK
PCL CUP,SUPR,PLAS,CL
ORGNZ STAND,MESH,PW
SHELF,DESK, 3 TIER,MESH,BK
FILE,RTRY, DESK, EY
CUBE,2DRW,SHF,CL
CUBE,4DRW,SHF,CL
ORGNZ,SHLF,6X12,CL
ORGNZ,SHF,9",SHF SAVR
SORTER,INCLINE,REGEN,BK
ORGNZ,REGEN,BK
CMAT,46"X60",NO LIP,BVL
CMAT,46"X60",ANTSTAT
FI L E,WAL L, STAK, BK
CMAT,46"X60",UTIL,HFLR
PRINT CTRG,EPS 440/640
CARD FILE,PLAS,3×5,BK
BOOK, RECD,150PG,BK
FILE JACKET,2"EXP,LTR,RD
Item ID
AMP25280
ARZLT61
AURDT150
AVE04027
AVE05164
AVE05366
AVE06120
AVE06466
AVE08885
AVE08886
AVE08887
AVE08997
AVE21381
AVE23565
AVE48580
AVE49574
AVE74400
AVE LG LTSAZ
AVE PV119G50
AVE RI213M
AVEST1110RD
AVETT213 M
AVT075300
BAU LP 1700
BAUMR9900
BUN6088
CAN 1382A003A
CAN 1385A002
CAN 1557A002 B
CCPCC1
CEI20021
CLGKSW208
CLI62020
CLI70257
CLI70568
CRD10200
DTM81503
ELD13606
ELD14124
ELD22154
ELD22341
ELD25001
ELD29882
ELD29884
ELD29893
ELD29894
ELD38386
ELD38986
ELD40730
ELD45730
ELD48706
ELD76730
EPS5020191
ESS01351
ESS21150R
ESS22211
Order Ship CEX SELL CEX EXTD.
Freq Qty CEX UM PRICE SELL PRICE SAVINGS% SAVINGS$
1 1 DZ I $13i321 $13.32 -35.36% -$4.71
1 1 EA $35.13 $35.13 46.37% $16.29
1 1 EA $14.11 $14.11 47.63% $6.72
1 1 BX $25.41 $25.41 8.34% $2.12
1 1 BX $26.21 $26.21 17.63% $4.62
1 1 BX $26.21 $26.21 17.63% $4.62
1 1 EA I $21i801 $21.80 -113.26% -$24.69
1 1 PK $13.87 $13.87 17.66% $2.45
1 1 EA $0.48 $0.48 18.75% $0.09
1 1 EA $0.48 $0.48 18.75% $0.09
1 1 EA $0.48 $0.48 18.75% $0.09
1 1 PK $10.99 $10.99 19.75% $2.17
1 1 EA $1.42 $1.42 8.45% $0.12
1 1 ST $3.04 $3.04 29.61% $0.90
1 1 ST $12.37 $12.37 36.30% $4.49
1 1 EA $4.06 $4.06 32.51% $1.32
1 1 ax $29.04 $29.04 73.07% $21.22
1 1 ST $5.60 $5.60 8.39% $0.47
1 1 ax $6.27 $6.27 21.53% $1.35
1 1 ST $3.18 $3.18 29.25% $0.93
1 1 EA $7.36 $7.36 34.38% $2.53
1 1 ST $2.52 $2.52 10.71% $0.27
1 1 4PK $2.41 $2.41 16.60% $0.40
1 1 ax $3.26 $3.26 33.44% $1.09
1 1 EA $2.94 $2.94 75.85% $2.23
1 1 EA $14.14 $14.14 24.61% $3.48
1 1 EA $32.10 $32.10 23.55% $7.56
1 1 EA i $~s:~Ol $75.60-31.83% -$24.06
1 1 EA $84.77 $84.77 23.39% $19.83
1 1 EA $5.53 $5.53 40.87% $2.26
1 1 EA $0.00 $0.00 0.00% $0.00
1 1 EA $44.99 $44.99 10.00% $4.50
1 1 ax $3.76 $3.76 13.83% $0.52
1 1 PK $3.90 $3.90 49.23% $1.92
1 1 10PK $3.61 $3.61 3.60% $0.13
1 1 EA $6.42 $6.42 34.42% $2.21
1 1 EA $128.05 $128.05 37.29% $47.75
1 1 EA $12.76 $12.76 36.60% $4.67
1 1 EA $2.81 $2.81 21.35% $0.60
1 1 EA $17.00 $17.00 35.29% $6.00
1 1 EA $14.84 $14.84 12.47% $1.85
1 1 EA $17.14 $17.14 14.47% $2.48
1 1 EA $11.86 $11.86 46.46% $5.51
1 1 EA $13.16 $13.16 46.43% $6.11
1 1 EA $8.47 $8.47 46.40% $3.93
1 1 EA $12.97 $12.97 40.48% $5.25
1 1 EA $5.78 $5.78 8.30% $0.48
1 1 EA $4.21 $4.21 9.50% $0.40
1 1 EA $45.09 $45.09 32.71% $14.75
1 1 EA $121.76 $121.76 27.05% $32.93
1 1 EA $5.21 $5.21 8.45% $0.44
1 1 EA $65.42 $65.42 37.66% $24.64
1 1 EA $26.14 $26.14 17.64% $4.61
1 1 EA $1.69 $1.69 43.20% $0.73
1 1 EA $28.38 $28.38 12.19% $3.46
1 1 50BX $28.85 $28.85 11.61% $3.35
OFFICE DEPOT
EXTD SELL
PRICE (CEX UM)
$18.03
SELL PRICE
OFFICE DEPOT (OD UM
SELL PRICE UM WHERE
(CEX UM) DIFF DIFF)
$18.03 * $6.01
$46.49 $46.49
$99.66 $99.66
$0.00 $0.00
$40.49 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii$40i;4i9
OD UM
4PK
EA
EA
BX
BX
BX
EA
BX
EA
EA
EA
40PK
EA
6PK
8PK
EA
BX
ST
BX
ST
EA
ST
24BX
BX
EA
EA
EA
EA
EA
EA
EA
EA
PK
10PK
5PK
EA
EA
3PK
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
* $12.07
$1.74
* $0.510
Page 6 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U.P. 2002 PUF~CHASES
ss
LN
NO
337
338
339
34O
341
342
343
344
345
346
347
348
349
35O
351
352
353
354
355
356
357
358
359
36O
361
362
363
364
365
366
367
368
369
37O
371
372
373
374
375
376
377
378
379
38O
381
382
383
384
385
386
387
388
389
39O
391
392
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
CVR, REP, LTR, D B L-TAN G ,ASST
PORTFOLIO,2PKT,HG
PO RTFO LIO,2 PKT, FAS, LTR
FLDR,BX BOTM,LTR,3"
FLDR,MLA,STR,LTR
LBL,FILE FLDR,LBE
LBL,FILE FLDR,GN
LBL,FILE FLDR,RD
LBL,FILE FLDR,YW
LBL,LASR,I-I/3X4,WE
PAD,LGL RL,PERF,LTR,CY
PPR, M E M O,4X6,WE
PAD,LGL RL,PERF,LGL,WE
RIBN,LO,CAN,6BX
PAD,GUM,WD RL,LTR,WE
BN DR,3RG,LH,LTR,3",BK
PAD,LGL RL,PERF,5XS,WE
PPR,CPY,20#,LTR,GD
BNDR CLIP,I",LG
PUNCH,1HL,HNDHLD
PUNCH,2-3HL,ADJ,14SH,BK
CALC,DESK, 12DGT
COPYH LDR, D ES KTP, BK
COPYH LDR, FLEXARM, BASE
BUS CRD HLDR,PERF-ECT,BK
SHREDDER,BSKT,P500
COPYHLDR,CLIP,ADJ,PY
MOUSEPAD,GP
T RAY,WI R E,3"D, LTR, BK
CD SPINNER,112CAP,BK
DISK FILE,3.5,F/50,PL
WRISTREST,GEL,RY
CVR,PC,UNV,VYL,LG,CL
CLEAN ER,SCREEN,WIPES, lC
CLEAN ER, D U STE R,AI R,2.75OZ
CAL, RFL, M O NARC, MONTICELLO
LAMNT POUCH,BADGE,5ML,
LAMNT POUCH,LTR,3ML,50PK
PUNCH,3HL,ADJ,40SH,GY
STAPLER,DESK, FULL STRP,BK
STAPLER,DESK, FULL STRP,BY
STAPLER,FULL STRP,HG
STAMP,PRNK, COPY, BE
STAMP,PRNK, FILE CPY, RD
STAMP,PRNK, PAID,RD
STAMP,PRNK, RECD,RD
STAM P,TITLE, POSTED, RD
STAMP,RPL PAD,F/75826
STAMP,DATER,CSTM,HD
DATER,PHRASE,HD
PUSH PIN,PLAS,AST, lC
FILE,EXP,LAM, 10X12,BE
P P R,C PY,24#, U N COAT,WE
PAD HLDR,LTR,DLX,VYL,BY
PRINT CTRG,DESKJT,CN
PRINT CTRG,DESKJT,MA
Order Ship
Item ID Freq Qty
ESS52513 1 1
ESS57556 1 1
ESS57713 1 1
ESS82317 1 1 BX
ESSH110D 1 1 BX
EXP00453 1 1 PK
EXP00455 1 1 PK
EXP00459 1 1 PK
EXP00462 1 1 PK
EXP00518 1 1 BX
EXP11429 1 1 DZ
EXP20020 1 1 PK
EXP21428 1 1 DZ
EXP26107 1 1 6BX
EXP41218 1 1 DZ
EXP60037 1 1 EA
EXP61428 1 1 DZ
EXP8511GOL 1 1 RM
EXP90002 1 1 DZ
EXP90030 1 1 EA
EXP90031 1 1 EA
EXP95005 1 1 EA
FEL21106 1 1 EA
FEL21128 1 1 EA
FEL22308 1 1 EA
FEL32500 1 1 EA
FEL48107 1 1 EA
FEL58037 1 1 EA
FEL66112 1 1 EA
FEL83123 1 1 EA
FEL90611 1 1 EA
FEL96737 1 1 EA
FEL99615 1 1 EA
FEL99703 1 1 EA
FEL99791 1 1 EA
FRQ23966 1 1 EA
GBC3202004 1 1 PK
GBC3745690 1 1 PK
GBC9800276 1 1 EA
GBC9855000 1 1 EA
GBC9855020 1 1 EA
GBC9895030 1 1 EA
GEM07611 1 1 EA
GEM07613 1 1 EA
GEM07620 1 1 EA
GEM07621 1 1 EA
GEM07631 1 1 EA
GEM55608 1 1 EA
GEM73026 1 1 EA
GEM75826 1 1 EA
GEMCPOA 1 1 BX
GLW38301 1 1 EA
HAM124960 1 1 PK
HAZ548710 1 1 EA
HEW51640C 1 1 EA
HEW51640M 1 1 EA
CEX SELL CEX EXTD.
CEX UM PRICE
25BX $12.99
25BX $12.99
25BX I $8i411
$16.61
$18.83
$18.13
$7.23
I $3:561
$9.78
$6.66
$6.72
I s~:2~1
$1.01
$9.15
$14.99
$11.96
$35.84
$4.59
$78.22
$4.69
$2.97
$4.79
$17.46
$4.54
$21.59
$14.41
$9.61
$6.45
$44.63
$5.14
$2O.88
$47.62
$14.37
$13.17
$17.37
$7.8O
$7.8O
$7.8O
$5.37
$5.37
$4.81
$21.59
$53.10
$2.37
$12.17
$7.86
$14.44
$33.81
$33.81
SELL PRICE SAVINGS% SAVINGS$
$12.99 9.93% $1.29
$12.99 50.12% $6.51
$8.41 -26.99% -$2.27
$16.61 1.51% $0.25
$18.83 55.44% $10.44
$1.29 -34.88% -$0.45
$1.29 -34.88% -$0.45
$1.29 -34.88% -$0.45
$1.29 -34.88% -$0.45
$18.13 35.69% $6.47
$7.23 12.17% $0.88
$3.56 -29.78% -$1.06
$9.78 1.64% $0.16
$1.38 -766.67% -$10.58
$6.66 4.65% $0.31
$6.12 -3.43% -$0.21
$0.24 -33.33% -$0.08
$6.72 50.15% $3.37
$1.21 -67.77% -$0.82
$1.01 13.86% $0.14
$9.15 61.42% $5.62
$14.99 54.10% $8.11
$11.96 31.35% $3.75
$35.84 38.64% $13.85
$4.59 33.99% $1.56
$78.22 43.79% $34.25
$4.69 30.31% $1.42
$2.97 8.42% $0.25
$4.79 4.59% $0.22
$17.46 34.99% $6.11
$4.54 23.79% $1.08
$21.59 56.51% $12.20
$14.41 35.32% $5.09
$9.61 48.80% $4.69
$6.45 42.64% $2.75
$44.63 48.26% $21.54
$5.14 34.63% $1.78
$20.88 36.25% $7.57
$47.62 58.59% $27.90
$14.37 40.92% $5.88
$13.17 35.54% $4.68
$17.37 38.23% $6.64
$7.80 48.46% $3.78
$7.80 46.03% $3.59
$7.80 48.46% $3.78
$5.37 25.14% $1.35
$5.37 -6.70% -$0.36
$4.81 33.47% $1.61
$21.59 0.00% $0.00
$53.10 55.52% $29.48
$2.37 78.90% $1.87
$12.17 33.03% $4.02
$7.86 37.40% $2.94
$14.44 44.94% $6.49
$33.81 17.63% $5.96
$33.81 17.63% $5.96
OFFICE DEPOT
EXTD SELL
PRICE (CEX UM)
OFFICE DEPOT
SELL PRICE
(CEX UM)
$10.68 $10.68
$1.74 $1.74
$1.74 $1.74
$1.74 $1.74
$1.74 $1.74
$4.62 $4.62
$11.96 $11.96
$6.33 $6.33
$0.32 $0.32
$2.03 $2.03
OD UM
10PK
10PK
10PK
BX
BX
PK
PK
PK
PK
PK
DZ
PK
DZ
6PK
DZ
EA
EA
RM
BX
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
PK
PK
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
EA
BX
EA
RM
EA
EA
EA
UM
DIFF
SELL PRICE
(OD UM
WHERE
DIFF)
$4.68
$2.59
$4.27
Page 7 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U,P, 2002 PUF~CHASES
ss
LN
NO
393
394
395
396
397
398
399
4OO
401
4O2
4O3
4O4
4O5
4O6
4O7
4O8
4O9
410
411
412
413
414
415
416
417
418
419
42O
421
422
423
424
425
426
427
428
429
43O
431
432
433
434
435
436
437
438
439
44O
441
442
443
444
445
446
447
448
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
PRINT CTRG,DESKJT,YW
PRINT CTRG,DESKJT,CLR
PPR ROLL,BNNR,INKJT,LTR
TONER CTRG,HP1100A, ULTRA
CABINET,STG,72"H,PY
DICTNARY,WEBSTERS II
H EATE R,C E RAM C,ADJ ,TH ERM
BINDING,PLAS,1.25",BK,50
CD-R,40X,WE,50/SPN DL/PK
DISK, 3.5",DSHD,CL
M O U S E PAD, FSTTR K, BE
SWAB,CLEAN ER,20BX
CLEAN ER, D U ST/LI NT, 1007
MOISTEN ER,FNGRTIP,3/807
RACK, 3HORT,SVERT,DP,BK
CASSETTE,AUDIO,30MIN
DICTNARY,CO LLEG E, H RDBK
TAPE, DBL STK, 1/2"X450"
TAPE,PKG,CL
BOARD,POSTIT,S STICK, PLM
PAD, POSTIT, 1.5X2,AQ
PAD, POSTIT, 1.5X2,YW, 12 PK
PAD,POSTIT,3X3,AST, 12PK
PAD, POSTIT,4X6,AQ,3PK
PAD, POSTIT,4X6, U LTRA,3 P K
PAD, POSTIT, PAG M KR,2X.6
NOTE,PGM RKR, 1X3,UAST,4PK
PAD, POSTIT,4X4,AQ
FLAG ,TAPE, POSTIT, BE,50
FLAG ,TAPE, POSTIT, B P K,50
FLAG,TAPE, POSTIT,G N,50
FLAG ,TAPE, POSTIT,AR ROW
FLAG, POSTIT,SIG NATU R E,AST
FLAG,POSTIT,SIGN HERE,AST
MOUNTING SQ,RMVBL,CL,35PK
TAPE, POPU P, .75X2 ,STR P,C L
KEYBRD TRAY,ADJ
ORG NT, DESK, ROTATE, BK
TAPE DSPR,POPUP,CHPN
PAD, POSTIT,AD H, POPU P,3X3
STAPLE,MINI,3/16"
STAPLER,MINI,BK
LETTER OPENER,DELUXE,BK
SHARPEN ER,PCL,BATT,BK
ERASER,CAP,12PK
ERASER,PCL,PK/PA, LG
MRKR,PERM,CHSL,WE
MRKR,PEN STYLE,FN,WE
ERASER,MECH PCL,3TB
KNIFE,UTIL,RETRACTBLE
PEN,BLPT,M ED,RET,GX300,BK
PEN,BLPT,M ED,RET,GX300BBY
PEN,GEL,DR GRIP,FN,NPE
PEN RFL,BLPT,RET,M ED,BE,2
ADD ROLL,2.25X150',RCY, 12
TONER CTRG,CAN L500
Order Ship
Item ID Freq Qty CEX UM
HEW51640Y 1 1 EA
HEW51641A 1 1 EA
HEWC1820A 1 1 PK
HEWC4092A 1 1 EA
HONSC1872L 1 1 EA
HOUH15080 1 1 EA
HWLHZ315 1 1 EA
IBC15262 1 1 PK
IMN41410 1 1 PK
IMN42439 1 1 BX
KCS811 O3 1 1 EA
KMW18040 1 1 BX
KMW22260 1 1 EA
LEE10050 1 1 EA
LIT5DOBK 1 1 EA
MAX102811 1 1 EA
MER9 1 1 EA
MMM137 1 1 RL
MMM3650C 1 1 RL
MMM558F5 1 1 EA
MMM65312AQ 1 1 PK
MMM653YW 1 1 PK
MMM654A 1 1 PK
MMM6603AQ 1 1 PK
MMM6603AU 1 1 PK
MMM6705AF 1 1 PK
MMM6714AU 1 1 PK
MMM675AQL 1 1 PD
MMM6802 1 1 EA
MMM68021 1 1 EA
MMM6803 1 1 EA
MMM684ARR3 1 1 EA
MMM684AST1 1 1 PK
MMM684SH 1 1 EA
MMM859 1 1 35PK
MMM90M3PK 1 1 PK
M M MAKT60 1 1 EA
MMMC91 1 1 EA
MMMC92CH 1 1 EA
MMMR3306AQ 1 1 PK
MXB105M 1 1 BX
MXBHD10DFBK 1 1 EA
01c30310 1 1 EA
PANKP4ABK 1 1 EA
PAP02512 1 1 PK
PAP70521 1 1 EA
PEN100W 1 1 EA
PEN100WS 1 1 EA
PENZ21 1 1 TB
PHCCQR16 1 1 EA
PIL34110 1 1 EA
PIL34112 1 1 CD
PIL36261 1 1 EA
PIL77228 1 1 PK
PMF02835 1 1 PK
PMF75500 1 1 EA
CEX SELL CEX EXTD.
PRICE
$33.81
$33.81
$11.95
$64.49
$268.98
$6.5O
$35.29
$27.45
$28.OO
$5.67
$7.87
$15.07
$41.95
$1.26
$69.30
$1 .O9
$24.95
$2.13
$4.49
$29.60
$8.61
$6.43
$2.61
$1.73
$7.56
$3.84
$2.54
$3.86
$3.27
$2.57
$194.68
$21.57
$8.69
$9.70
$1
$10.42
$1.27
$12.83
$0.53
$0.41
$2.31
$2.79
$6.56
$3.54
$3.54
$5.97
$0.78
$13.66
$99.00
SELL PRICE SAVINGS% SAVINGS$
$33.81 17.63% $5.96
$33.81 26.83% $9.07
$11.95 7.62% $0.91
$64.49 17.65% $11.38
$268.98 28.53% $76.73
$6.50 61.85% $4.02
$35.29 29.90% $10.55
$27.45 29.51% $8.10
$28.00 43.75% $12.25
$5.67 41.27% $2.34
$7.87 65.44% $5.15
$15.07 39.95% $6.02
$41.95 45.01% $18.88
$1.26 59.52% $0.75
$69.30 33.49% $23.21
$1.09 55.05% $0.60
$24.95 38.84% $9.69
$2.13 14.55% $0.31
$4.49 56.35% $2.53
$29.60 45.00% $13.32
$8.61 49.59% $4.27
$3.10 -13.55% -$0.42
$7.79 -6.93% -$0.54
$6.43 -27.53% -$1.77
$6.43 18.20% $1.17
$2.61 41.76% $1.09
$1.73 14.45% $0.25
$7.56 44.97% $3.40
$1.06 -19.81% -$0.21
$1.06 -19.81% -$0.21
$1.06 -19.81% -$0.21
$3.84 44.01% $1.69
$2.54 23.62% $0.60
$3.86 14.51% $0.56
$3.27 86.85% $2.84
$2.57 17.51% $0.45
$194.68 43.51% $84.71
$21.57 32.04% $6.91
$8.69 45.22% $3.93
$9.70 46.91% $4.55
$1.56 -75.64% -$1.18
$10.42 20.92% $2.18
$1.27 14.17% $0.18
$12.83 14.50% $1.86
$0.53 7.55% $0.04
$0.41 7.32% $0.03
$2.31 9.52% $0.22
$2.79 30.11% $0.84
$0.48 -60.42% -$0.29
$6.56 8.23% $0.54
$3.54 36.44% $1.29
$3.54 36.44% $1.29
$5.97 8.38% $0.50
$0.78 7.69% $0.06
$13.66 76.79% $10.49
$99.00 44.86% $44.41
OFFICE DEPOT OFFICE DEPOT
EXTD SELL SELL PRICE
PRICE (CEX UM) (CEX UM)
$3.52 $3.52
$8.33 $8.33
$8.20 $8.20
$1.27 $1.27
$1.27 $1.27
$1.27 $1.27
$2.15 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii$2i;iliii$
$2.74 $2.74
$0.77 $0.77
OD UM
EA
EA
PK
EA
EA
EA
EA
50PK
PK
BX
EA
PK
EA
EA
EA
6PK
EA
RL
4PK
EA
PK
PK
DZ
PK
3PK
5PK
4PK
PK
2PK
2PK
2PK
4PK
EA
EA
480PK
3PK
EA
EA
EA
6PK
BX
EA
2PK
EA
PK
EA
DZ
DZ
3PK
EA
EA
EA
EA
2PK
DZ
EA
SELL PRICE
(OD UM
UM WHERE
DIFF DIFF)
$2.93
$7.82
$2.54
$2.54
$2.54
$5.90
$2.17
* $25.13
* $23.43
* $2.31
Page 8 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U,P, 2002 PURCHASES
ss
LN
NO
449
45O
451
452
453
454
455
456
457
458
459
46O
461
462
463
464
465
466
467
468
469
47O
471
472
473
474
475
476
477
478
479
48O
481
482
483
484
485
486
487
488
489
49O
491
492
493
494
495
496
497
498
499
5OO
501
5O2
5O3
5O4
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
BOARD,CORK, 3'X4',OK
BOARD,FBR,3'X4',GY
E NVL,CAT,28#, 10X13, KFT, 1C
ENVL,CSP,24#,6X9,PRKRG
E NVL,CS P,24#, 10X13, PRKRG
E NVL,CAT,28#, 10X13, REDSL
E NVL,COI N ,#5,28#,5C/BX
ENVL,IN DPT,TIE, 10X13,KFT
ORGNZ,DRW, BK
SORTER, M EGA,STE P, BK
BOOK,ADD,BUS CRD STYLE,AM
CARD FILE,VIP,2.25X4,BK
CARD FILE,VIP,CVR,2.25,BK
CLEAN E R,CTRG,WI P ES,75TU B
M R KR,VISAVIS, FN ,4ST
MRKR,LIQ,SHARPIE,BK
PEN RFL,BLPT,PHD,MED,BK
STAMP PAD INK, ROLL-ON,GN
PEN,UNIGEL,GRIP,MED,PE
PEN,UNIGEL,GRIP,MED,GN
PEN,BLPT,PHD,MED,SCL
ERASER,DRY ERS,EXPO
BOARD,DRY ERS,ACCESS KT
MRKR,EXPO,DRY ERS,SST
MRKR,DE,FN,CRBN,4ST
MRKR,EXPO,DRY ERS,BLT,4ST
MRKR,EXPO,DRY ERS,BLT,SST
MRKR,EXPO,XFN,4ST
CLOCK,WALL, 12",Q RTZ,C M PRM
PCL,MECH,DELTA GRP,.7,BBY
CALC,DESK, PRT, 12DGT
FILE JACKET,FLAT,LTR,RD
FILE JACKET, I"EXP,LTR,50
FILE JACKET,2" EXP,LTR,50
FILE JACKET,2" EXP,LTR,GN
FILE JACKET,2" EXP,LTR,RD
GUIDE,CARD,3X5,A-Z,PB,GN
FLDR,FILE, 1/3,LTR,AST
GUIDE,CARD,4X6,MO,PB,GN
GUIDE,CARD,4X6,A-Z,PB,GN
GUIDE,CARD,5XS, 1/5,M LA, 1C
FLDR,HANG,LTR,BK,25
FLDR,HANG,LTR,1/5,YW,25
FI LE, D ES K,20 PG ,A-Z, LTR
LBL PROT,SEAL,VU,CL,1C
FRAME,HANG,LTR/LGL,2BX
GUIDE,SELF TAB,A-Z,LTR,25
STAPLER,DESK, HLF STRP,BK
STAPLER,DESK, FULL STRP,BK
STAPLER,ELEC,20SH
FINGER PAD,#11.5,AR
STAPLER,DESK, FULL STRP,BK
STAPLER,DESK, FULL STRP,PL
STAPLER,DESK, HLF STRP,BK
PUNCH,2HL,1/4",35SH,BK
PUNCH ,2-3H L,ADJ ,40S H, BK
Item ID
QRT304
QRT7694G
Q UA41667
QUA43055
QUA43097
QUA43717
QUA50462
QUA63561
ROG 11906
ROG48016
ROL66440
ROL66998
ROL67011
RRTRR1409
SAN 16074
SAN34011
SAN56892
SAN58704
SAN65453
SAN65455
SAN70102
SAN81505
SAN83054
SAN83078
SAN86435
SAN88074
SAN88078
SAN89074
SET1143
SHF92006
SHREL2192R
SMD24900R
SMD24910
SMD24920
SMD24920GN
SMD24920R
SMD51525
SM D53LASMT
SMD61112
SMD61525
SMD825
SMDC15HBK
SMDC15HY
SMDC33
SMDCLL
SMDR782
SMDS11525
SWI20301
SWI40701
SWI51110
SWI54035
SWI54501
SWI54515
SWI71101
SWI74050
SWI74350
Order Ship
Freq Qty CEX UM
1 1 EA
1 1 EA
1 1 BX
1 1 BX
1 1 BX
1 1 BX
1 1 BX
1 1 BX
1 1 EA
1 1 EA
1 1 EA
1 1 EA
1 1 EA
1 1 EA
1 1 ST
1 1 EA
1 1 EA
1 1 EA
1 1 EA
1 1 EA
1 1 EA
1 1 EA
1 1 KT
1 1 ST
1 1 ST
1 1 ST
1 1 ST
1 1 ST
1 1 EA
1 1 EA
1 1 EA
1 1 BX
1 1 50BX
1 1 50BX
1 1 50BX
1 1 50BX
1 1 ST
1 1 BX
1 1 ST
1 1 ST
1 1 BX
1 1 BX
1 1 BX
1 1 EA
1 1 PK
1 1 2BX
1 1 ST
1 1 EA
1 1 EA
1 1 EA
1 1 DZ
1 1 EA
1 1 EA
1 1 EA
1 1 EA
1 1 EA
CEX SELL CEX EXTD.
PRICE
$46.72
$75.02
$13.47
$19.50
$14.06
$25.89
$6.86
$9i321
$44.99
$13.18
$19.77
$6.29
$3.21
$1.37
$2.09
$1:9o
$1.60
$1.6O
$7.29
$1.95
$16.20
$s:8ol
$5.15
$3.93
$S:801
$3.21
$27.07
$5.39
$69.99
$30.00
$19.59
$19.59
$27.57
$27.57
$3.93
$13.54
$3.33
$4.97
$11.50
$11
$11.58
$8.34
$2.54
$12.96
$13.17
$99.33
] s0:721
$7.19
$7.19
$5.32
$13.13
$44.90
SELL PRICE SAVINGS% SAVINGS$
$46.72 12.91% $6.03
$75.02 44.29% $33.23
$13.47 45.58% $6.14
$9.96 -63.55% -$6.33
$15.06 -62.55% -$9.42
$19.50 46.10% $8.99
$14.06 39.97% $5.62
$25.89 48.82% $12.64
$6.86 47.81% $3.28
$9.32 -17.92% -$1.67
$44.99 83.35% $37.50
$13.18 17.60% $2.32
$19.77 19.68% $3.89
$6.29 21.78% $1.37
$3.21 20.25% $0.65
$1.37 8.03% $0.11
$2.09 56.46% $1.18
$1.90 -3.68% -$0.07
$1.60 40.00% $0.64
$1.60 40.00% $0.64
$7.29 37.04% $2.70
$1.95 8.21% $0.16
$16.20 8.33% $1.35
$5.80 -10.52% -$0.61
$5.15 33.79% $1.74
$3.93 13.23% $0.52
$5.80 -10.52% -$0.61
$3.21 8.41% $0.27
$27.07 8.57% $2.32
$5.39 49.17% $2.65
$69.99 62.18% $43.52
$30.00 8.50% $2.55
$19.59 36.19% $7.09
$19.59 36.19% $7.09
$27.57 7.51% $2.07
$27.57 7.51% $2.07
$3.93 51.40% $2.02
$13.54 32.94% $4.46
$3.33 30.93% $1.03
$4.97 52.52% $2.61
$11.50 7.22% $0.83
$11.58 -8.12% -$0.94
$11.58 38.34% $4.44
$8.34 35.25% $2.94
$2.54 16.54% $0.42
$12.96 26.85% $3.48
$10.01 -1.40% -$0.14
$2.62 -27.86% -$0.73
$13.17 8.35% $1.10
$99.33 14.48% $14.38
$0.72 -20.83% -$0.15
$7.19 53.41% $3.84
$7.19 38.25% $2.75
$5.32 37.03% $1.97
$13.13 12.26% $1.61
$44.90 56.08% $25.18
OFFICE DEPOT
EXTD SELL
PRICE (CEX UM)
SELL PRICE
OFFICE DEPOT (OD UM
SELL PRICE UM WHERE
(CEX UM) DIFF DIFF)
$16.29 $16.29
$24.48 $24.48
$10.99 $10.99
$1.97 $1.97
$6.41 $6.41
$3.41
$3.41
$6.41 $6.41
$2.94 iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii$2i;i94
$12.52 $12.52
$10.15
$3.35
$10.15
$3.35
$0.87
$0.87
OD UM
EA
EA
BX
BX
BX
BX
BX
BX
EA
EA
EA
EA
EA
EA
4PK
EA
2PK
EA
EA
EA
EA
EA
EA
ST
EA
ST
ST
ST
EA
EA
EA
BX
EA
EA
EA
EA
ST
BX
ST
ST
BX
BX
BX
EA
BG
EA
ST
EA
EA
EA
DZ
EA
EA
EA
EA
EA
$1.81
$0.25
$0.25
$0.51
$0.51
$4.74
Page 9 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U.P. 2002 PURCHASES
ss
LN
NO
5O5
5O6
5O7
5O8
5O9
510
511
512
513
514
515
516
517
518
519
52O
521
522
523
524
525
526
527
528
529
53O
531
532
533
534
535
536
537
538
539
54O
541
542
543
544
545
546
547
548
549
55O
551
552
553
554
555
556
557
558
559
56O
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
STAPLER,DESK, FULL STRP,BK
STAPLER,DESK, FULL STRP,BK
STAPLE, HVY DTY, 1/2"
STAPLE, HVY DTY, 1/4",SF39
CAL HLDR,MESH,BK
WASTE BS KT, RECT, 13QT, PY
WAST E BS KT, R ECT,28QT, BK
FILE,WALL,STRTR,BK
FI LE,WALL,STRTR/O RG NZ, BK
PCL CUP,BK
SORTER,STEP,200C,BK
SHELF,OFF SRFC,BK
PAD, MSG, I M P NT,4.25X5.5,CY
PAD, MSG, I M P NT,4.25X5.5, PK
BOOK,VM,MSG
PAD,LGL RL,PRISM,5XS,OD
PAD,LGL RL,LTR,3HL,CY
PAD,LGL RL,PERF,LTR,CY
PAD,LGL RL,RCY,5XS,WE
CALC, PRT, DS PLY, 12 DGT
CALC, DESK, DS PLY, 12 DGT
CAL,DESK PD,WLDLFE,17X22
CAL,DESK PD,17X22,FLORAL
ORGNZ,WALL,CMPNT KT
PPR,VELLUM,67#,LTR,WE
BNDR,3RG,LH,LTR,I",BK
BNDR,DRNG,LTR,1.5",RD
BNDR,DRNG,LH,LTR,5",GN
IN DEX, M U LTIDEX,A-Z,AST
H I LITE R,ZAZZLE, BRT, 10ST
* 21011 1X6 NAMEPLATE
CAL,RFL,DESK, 12MO,3.5"X6"
CAL, DESK/WALL, RCY, MO, BK
STAPLER,DESK, HLF STRP,CE
RUBRBAND,ADV,#14,1 LB
LBL,RND,1/4,AST,760
LBL,LASR,1X2-5/8,FAST,450
LBL,INKJT, 1X2-5/8,WE
TAB,INS,HANG FLDR,1/3,1C
MRKR,MRKSALOT,REG,BK
MRKR,PERM,DUAL SHARP,4ST
PCL,MECH,E-GRIP,BBY
BOOK, RECD,150PG,BK
IN D EX,XWD E, LTR,C L,STB
P LAS BAN D, PO LY,2-1/8",2C
P LAS BAN D, PO LY,4.25", 1C
PEN,ROLR,GEL,INTNSTY, BE
PEN,ROLR,GEL,GRIP,BK
BUS CRD HLDR,LTR,3R,10ST
PROT,SHT,TL,LTR,AST,50
PEN RFL,SLCTP,JMBO,MED,BE
BUS CRD HLDR,PLAS,BK
ORGNZ,HANG FDR,LTR/LGL,EY
TRAY,W/RISER, LTR, B K,2ST
ORGNZ,W/DRW,6X6,CL
PRINT CTRG,STY440/640/740
Order Ship
Item ID Freq Qty CEX UM
SWI74701 1 1 EA
swi767Ol 1 1 EA
SWI79382 1 1 1 M BX
swi79384 1 1 1 M BX
TEN15261 1 1 EA
TEN16003 1 1 EA
TEN16021 1 1 EA
TEN20309 1 1 ST
TEN20329 1 1 ST
TEN24061 1 1 EA
TEN69016 1 1 EA
TEN69018 1 1 EA
TOP3002C 1 1 DZ
TOP3002P 1 1 DZ
TOP44160 1 1 EA
TOP63040 1 1 DZ
TOP63387 1 1 6PK
TOP63400 1 1 DZ
TOP74830 1 1 DZ
VCT01225 1 1 EA
VCT12003 1 1 EA
v1089300 1 1 EA
w089805 1 1 EA
VIOA162 1 1 EA
WAU82211 1 1 PK
WLJ36814NHB 1 1 EA
WLJ38334R 1 1 EA
WLJ38450G 1 1 EA
WLJ90203 1 1 ST
ZEB71110 1 1 10ST
AAASTAMPRUB 1 2 LT
AAGE01750 1 2 EA
AAGSK24R00 1 2 EA
ACE03024 1 2 EA
ALL26145 1 2 BX
AVE05795 1 2 P K
AVE05979 1 2 P K
AVE08250 1 2 PK
AVE11137 1 2 PK
AVE24458 1 2 EA
AVE29649 1 2 4ST
AVE49576 1 2 EA
AVE56211 1 2 EA
AVEEW2138C 1 2 ST
BAUSF5000 1 2 BX
BAUSF6000 1 2 BX
BICRN11BE 1 2 EA
BICRN11BK 1 2 EA
CLI61217 1 2 ST
CLI62000 1 2 BX
CRO85623 1 2 EA
ELD02336 1 2 EA
ELD16861 1 2 EA
ELD29441 1 2 ST
ELD29892 1 2 EA
EPSS020191 1 2 EA
CEX SELL CEX EXTD.
PRICE
$16.79
$20.39
$2.99
$2.39
$11.64
$4.70
$4.05
$58.34
$1.93
$14.00
$45.20
$2.34
$1.5O
$4:031
$10.00
$28.92
$20.64
$10.80
$79.95
$24.29
$10.61
$16.50
$27.50
$8.O4
$2.13
$6.41
$26.88
$3.8O
$14.44
$15.00
$2.74
$4.55
$17.81
$2.63
$3.55
$8.79
$10.00
$1.16
$1.11
$6.67
$4.03
$1 s:l 7I
$1.68
$1.18
$1.18
$1.64
$14.39
$4.OO
$1.3O
$9.44
$8.47
$26.14
SELL PRICE SAVINGS% SAVINGS$
$16.79 36.09% $6.06
$20.39 8.34% $1.70
$2.99 57.53% $1.72
$2.39 58.58% $1.40
$11.64 78.18% $9.10
$4.70 58.72% $2.76
$4.05 47.41% $1.92
$24.93 -21.34% -$5.32
$58.34 35.89% $20.94
$1.93 10.36% $0.20
$14.00 49.71% $6.96
$45.20 60.29% $27.25
$2.34 43.16% $1.01
$1.50 9.33% $0.14
$4.03 -2.23% -$0.09
$10.00 35.10% $3.51
$28.92 69.57% $20.12
$20.64 38.32% $7.91
$10.80 41.11% $4.44
$79.95 45.00% $35.98
$24.29 27.34% $6.64
$10.61 1.04% $0.11
$16.50 36.36% $6.00
$27.50 55.42% $15.24
$8.04 45.02% $3.62
$2.13 8.45% $0.18
$6.41 47.89% $3.07
$26.88 29.39% $7.90
$3.80 24.21% $0.92
$14.44 43.21% $6.24
$30.00 0.00% $0.00
$5.48 7.66% $0.42
$9.10 38.24% $3.48
$35.62 32.23% $11.48
$5.26 38.40% $2.02
$7.10 8.45% $0.60
$17.58 11.72% $2.06
$20.00 17.60% $3.52
$2.32 8.62% $0.20
$2.22 54.05% $1.20
$13.34 30.43% $4.06
$8.06 32.01% $2.58
$30.34 -64.27% -$19.50
$3.36 8.33% $0.28
$10.06 -6.56% -$0.66
$12.80 -11.88% -$1.52
$2.36 46.61% $1.10
$2.36 46.61% $1.10
$3.28 21.34% $0.70
$28.78 49.34% $14.20
$8.00 10.00% $0.80
$2.60 65.38% $1.70
$18.88 1.27% $0.24
$24.08 -40.12% -$9.66
$16.94 44.27% $7.50
$52.28 17.64% $9.22
OFFICE DEPOT
EXTD SELL
PRICE (CEX UM)
SELL PRICE
OFFICE DEPOT (OD UM
SELL PRICE UM WHERE
(CEX UM) DIFF DIFF)
$30.25 $30.25
$12.73 $12;73
$6.36 $6;36
$43.97 $43;97
$17.65 $17;65
$10.50 $10;50
$10.50 $10;50
$12.26 $12;26
$4.42 $4;42
$1.95 $1;95
$3.34 $3;34
$18.98 $18;98
$2.88 $2;88
$8.20 $8;20
$30.00 $15;00
$5.06 $2;53
$5.62 $2;81
$24.14 $12;07
$3.24 $1;62
$6.50 $3;25
$15.52 $7;76
$16.48 $8;24
$2.12 $1;06
$1.02 $0;51
$9.28 $4;64
$5.48 $2;74
$49.84 $24.92
$3.081 $1:s41
$10.72 $5.36
$14.32 $7.16
$33.74 $16.87
OD UM
EA
EA
5MBX * $6.320
5MBX * $4.94O
EA
EA
EA
3PK
3PK
EA
EA
EA
DZ
DZ
EA
DZ
DZ * $17.60
DZ
DZ
EA
EA
EA
EA
EA
PK
EA
EA
EA
ST
5ST * $4.10
LT
EA
EA
EA
BX
BX
PK
PK
PK
DZ * $6.13
5ST * $5.8O
EA
EA
ST
BX
BX
6PK * $3.75
6PK * $3.75
10PK
50BX
EA
EA
EA
ST
EA
EA
Page 10 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U,P, 2002 PURCHASES
ss
LN
NO
561
562
563
564
565
566
567
568
569
57O
571
572
573
574
575
576
577
578
579
58O
581
582
583
584
585
586
587
588
589
59O
591
592
593
594
595
596
597
598
599
6OO
601
6O2
6O3
6O4
6O5
6O6
6O7
608
6O9
610
611
612
613
614
615
616
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
FI LE, BOX, ECON, PO RT,STG
BNDR,DRNG,VU,1.5",WE
FLDR, HANG, LTR, N/TAB, G N ,25
BNDR,3RG,VU,1.5",RBE
BNDR,VU,ECON,1.5",WE
BNDR,VU,VYL, 1.5,RD
TAPE,SEAL,2"X55YD,CL
PEN,BLPT,STK, MED,BK
PEN,BLPT,STK, MED,RD
PPR,CPY,20#,LTR,BF
PPR,CPY,20#,LTR,IY
STAN D, BOOK,WI RE, FOLD
BUS CRD FILE,ESS×,LEA, BK
TONER CTRG,HP14,CP1160
TONER CTRG,HP14,CP1160 SR
PRINT CTRG,DJ810C/812C,BK
TONER CTRG,INKJT,BK
TONER CTRG,INKJT,TRICLR
STAPLER,STN DU P,U LT,BE
RACK, SVERT,LTR,BK
BOOKEND,WNG BK,TXTRD,BK
PEN, B LPT,C NTR,C HAl N, BK
PEN, B LPT,C NTR,C HAl N, BE
TAPE,SEAL,W/DSPR,TN
MEMO CUBE,POSTIT,SOFT
MEMO CUBE,POSTIT,BRITE
GLUE STICK,.45OZ,PE
PAD, POSTIT,4X6, NAST,3 P K
NOTE, PG M RKR, .5X2, UAST,5 P K
POSTIT CUBE,DSGNR,690SH
FLAG ,TAPE, POSTIT,AR ROW
TAPE, FI LA, BU LK,3/4"X60YD
POSTIT DSPR,3×3,SMPL,CL
PAD, POSTIT,3X3, NAST,6 P K
BOOKEN D,NON-SLIP,5",BK
PEN,BLPT,STK, FN,BE
CORR PEN,LIQ PPR,WE
CORR FLUID,MLTPURP,WE
MRKR,PORUS PT,BLD,BE
MRKR,PORUS PT,BLD,RD
MRKR,PORUS PT,BOLD,BK
MRKR,PORUS PT,BLD,GN
PCL,MECH,.5MM,ICY,VT
PEN,BLPT,RSVP,MED,SK
PEN,BLPT,RSVP,MED,BE
PEN,BLPT,RSVP,MED,GN
PEN,BLPT,RSVP,MED,OR
PEN,BLPT,RZL-DZL,M ED,PK
PEN,BLPT,RZL-DZL,M ED,VT
LEAD,MECH PCL,2H,.5MM,12
ERASER,STICK, CLIC,BE
H I LITER,SPOTLITR,SPRM E, PK
H ILITER,SPOTLITR,SPRME,OR
PEN,BLPT,EASYTCH,M ED,BK
PEN,BLPT,ESYTCH,M ED,RD
PEN,BLPT,DR GRIP,MED,PE
Order Ship
Item ID Freq Qty CEX UM
ESS20862 1 2 EA
ESS23504 1 2 EA
ESS4152 1 2 BX
ESSRV112RB 1 2 EA
ESSRV112WE 1 2 EA
EXP00075 1 2 EA
EXP40039 1 2 RL
EXP50030 1 2 EA
EXP50032 1 2 EA
EXP8511BUF 1 2 RM
EXP85111VO 1 2 RM
FELl0024 1 2 EA
HAZ46011 1 2 EA
H EWC5010AN 1 2 EA
HEWC5011AN 1 2 EA
HEWC6615DN 1 2 EA
HEWC6656AN 1 2 EA
HEWC6657AN 1 2 EA
HUN73097 1 2 EA
LIT8VBK 1 2 EA
MJM24177110 1 2 PR
MJM52554 1 2 EA
MJM52558 1 2 EA
MMM143 1 2 RL
MMM2018 1 2 PD
MMM2027 1 2 PD
MMM6115 1 2 EA
MMM6603AN 1 2 PK
MMM6705AU 1 2 PK
MMM678BF 1 2 PD
MMM684ARR4 1 2 EA
MMM89334 1 2 RL
MMMC301S 1 2 EA
MMMR330AN 1 2 PK
01c93001 1 2 PR
PAP33611 1 2 DZ
PAP56201 1 2 EA
PAP56301 1 2 EA
PAP86111 1 2 EA
PAP86211 1 2 EA
PAP86311 1 2 EA
PAP86411 1 2 EA
PENAL25TV 1 2 EA
PENBK91RDAA 1 2 EA
PENBK91RDCA 1 2 EA
PENBK91RDDA 1 2 EA
PENBK91RDFA 1 2 EA
PENBK91RDPA 1 2 EA
PENBK91RDVA 1 2 EA
PENC5052H 1 2 TB
PENZE21C 1 2 EA
PILl6005 1 2 EA
PILl6009 1 2 EA
PIL32010 1 2 EA
PIL32012 1 2 EA
PIL36144 1 2 EA
CEX SELL CEX EXTD.
PRICE
$11.43
$8.33
$10.82
$5.83
$4.59
$1.03
$0.63
$0.63
$6.72
$6.72
$3.87
$17.96
$30.99
$25.99
$31.07
$24.05
$39.99
$21.50
$26.10
$7.17
$2.10
$2.8O
$2.8O
$1.42
$6.89
$5.63
$12.66
$3.84
$5.44
$0.00
$6.74
$2:801
$1.05
sl :20I
$0.84
$0.81
$0.81
$0.81
$0.81
$1.41
$O.6O
$O.6O
$0.97
$0.97
$0.97
$O.6O
$O.84
$0.59
$0.59
$8.27
SELL PRICE SAVINGS% SAVINGS$
$22.86 42.69% $9.76
$16.66 18.73% $3.12
$21.64 30.50% $6.60
$11.66 34.82% $4.06
$3.98 -30.65% -$1.22
$9.18 17.21% $1.58
$2.06 52.43% $1.08
$1.26 88.89% $1.12
$1.26 88.25% $1.11
$13.44 50.15% $6.74
$13.44 50.15% $6.74
$7.74 24.55% $1.90
$35.92 31.01% $11.14
$61.98 24.69% $15.30
$51.98 24.66% $12.82
$62.14 18.44% $11.46
$48.10 24.70% $11.88
$79.98 24.71% $19.76
$43.00 43.86% $18.86
$52.20 13.60% $7.10
$14.34 25.24% $3.62
$4.20 8.10% $0.34
$5.60 31.07% $1.74
$5.60 42.50% $2.38
$5.10 -32.16% -$1.64
$5.10 -32.16% -$1.64
$2.84 83.10% $2.36
$13.78 23.66% $3.26
$11.26 52.93% $5.96
$25.32 44.00% $11.14
$7.68 44.01% $3.38
$10.88 36.40% $3.96
$0.00 0.00% $0.00
$13.48 23.59% $3.18
$5.60 -8.21% -$0.46
$2.10 5.71% $0.12
$2.40 -15.83% -$0.38
$1.68 5.95% $0.10
$1.62 82.72% $1.34
$1.62 82.72% $1.34
$1.62 82.72% $1.34
$1.62 3.70% $0.06
$2.82 41.13% $1.16
$1.20 10.00% $0.12
$1.20 10.00% $0.12
$1.94 14.43% $0.28
$1.94 14.43% $0.28
$1.94 14.43% $0.28
$1.20 10.00% $0.12
$1.68 34.52% $0.58
$1.18 -77.97% -$0.92
$1.48 -14.86% -$0.22
$1.48 -14.86% -$0.22
$1.18 8.47% $0.10
$1.18 35.59% $0.42
$16.54 49.82% $8.24
OFFICE DEPOT
EXTD SELL
PRICE (CEX UM)
SELL PRICE
OFFICE DEPOT (OD UM
SELL PRICE UM WHERE
(CEX UM) DIFF DIFF)
$6.74 $3.37
$6.74 $3.37
$0.00 $0.00
$6.06 $3.03
$2.78 $1.39
$2.10 $1.05
$1.7O $O.85
$1.7O $O.85
OD UM
EA
EA
BX
EA
EA
EA
6PK * $2.91
DZ * $0.89
DZ * $0.87
RM
RM
EA
EA
EA
EA
EA
EA
EA
EA
EA
PR
EA
EA
RL
EA
EA
4PK * $0.95
3PK
PK
EA
4PK
RL
EA
PK
PR
DZ
EA
EA
DZ * $1.66
DZ * $1.66
DZ * $1.66
DZ * $9.360
3PK * $2.48
EA
EA
DZ * $9.90
DZ * $9.90
DZ * $9.90
6PK * $3.23
TB
EA
DZ * $10.16
DZ * $10.16
EA
DZ * $4.52
EA
Page 11 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U,P, 2002 PURCHASES
SS
LN
NO
617
618
619
62O
621
622
623
624
625
626
627
628
629
63O
631
632
633
634
635
636
637
638
639
64O
641
642
643
644
645
646
647
648
649
65O
651
652
653
654
655
656
657
658
659
66O
661
662
663
664
665
666
667
668
669
67O
671
672
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
BOARD,DRY ERS,2'X3',AL
E NVL,¢I 0,24¢, PRKRG ,WE,5C
ENVL,CAT,28¢,9.5X12.5,RDS
E NVL,CAT,28¢, 10X13, R E DSTP
ENVL,FC,28¢,9X12,WE,1C
ENVL,IN DPT,TIE, 10X13,1C
PCL,WD,¢2,EAGLE,YW
HILITER,LIQ ACNT,PE
MRKR,SHARPIE,TWN TP,BE
M RKR,CHSL,SHARPI E,4/S ET
PEN RFL,GEL,IMPCT,GD
PEN,GEL,UNI,MTLC,BZ
PEN,GEL,UNI,MTLC,VT
PEN,GEL,UNI,MTLC,PK
PEN,UNIBLL,GEL, 1MM,SEGN
PEN,UNIBALL,GEL, 1.0MM,CPK
ERASER,MECH PCL,ZEZE,5TB
MRKR,DRY ERS,ORGNZ,6ST
MRKR,EXPO,DRY ERS,4ST
FORM H LDR,W/CALC,8.5"X12"
FILE JACKET,LTR,SLSH,AST
FLDR,HANG,LTR,1/5,GN,25
FLDR,HANG,LTR,1/5,RD,25
TAB,INS,1/3,BLANK
FILE,EXP,A-Z,21PKT,LTR
FRAME,HANG FLDR,LTR,STL
STAPLE,HIGH CAP,F/77701
PAD,LGL RL,PRISM,5XS,BE
P P R,ASTRO,24¢, LTR, PLPE
BN DR,STG,8.5"X11 ",GN
BNDR,3RG,LTR,1.5",WE
BNDR,DRNG,LH,LTR,5",GY
BOOK,APPT, DY,8"X5", BK
CAL,DESK PAD RFL, 12MO
GLUE STICK,.26OZ
NTBK,WB,NR,7.75"X5"
BADGE HLDR,HORZ
PEN,BLPT,RND STK, MED,BK
PEN,BLPT,STK, MED,GN
PEN,BLPT,STK, MED,RD
PEN,BLPT,CUSHN,STK, MED,BE
PEN,BLPT,CUSHN,STK, MED,BK
MRKR,HILITER,DUAL END
RIBN,TW,CORR,AX300 SER
SPONGE,SOS,HVY DTY,3PK
BASKET,SHF SAVR,WIRE,LG
CVR,REP,RDY CLIP,30PG,BK
BOOK, P R ES,24 P KT, BK
ADD ROLL,2.25"X150',WE
PEN,BLPT,STK, FN,BE
WIPE,M LTPU RP,70EA/TU B
CD PROT,3RG SHT,2CAP,CL
TONER CTRG,HP4000,10M
PPR,PHOTO,LTR,PREM,50/BX
CLEAN ER, D U ST/LI NT, F/22260
MOISTENER'FNGRTIP
Order Ship
Item ID Freq Qty CEX UM
QRTS533 1 2 EA
QUA21330 1 2 BX
QUA44682 1 2 BX
QUA44782 1 2 BX
QUA54182 1 2 BX
QUA63563 1 2 BX
SAN22414 1 2 DZ
SAN24408 1 2 EA
SAN32003 1 2 EA
SAN38274 1 2 ST
SAN60659 1 2 EA
SAN63618 1 2 EA
SAN63619 1 2 EA
SAN63620 1 2 EA
SAN64417 1 2 EA
SAN64418 1 2 EA
SAN64881 1 2 TB
SAN83056 1 2 ST
SAN83074 1 2 ST
SAU 11 O25 1 2 EA
SMD3825SSA 1 2 PK
SMDC15H 1 2 BX
SMDC15HR 1 2 BX
SMDCH35 1 2 PK
SMDK117A 1 2 EA
SMDR672 1 2 BX
sw~35550 1 2 BX
TOP63020 1 2 DZ
WAU22671 1 2 RM
WLJ27826 1 2 EA
WLJ36834NW 1 2 EA
WLJ38450M 1 2 EA
AAGG10000 1 3 EA
AAGSK2250 1 3 EA
AVE00166 1 3 EA
AVE33002 1 3 EA
BAU67810 1 3 PK
BICGSMG 11BK 1 3 DZ
BICGSMG11GN 1 3 DZ
BICGSMG 11 RD 1 3 DZ
BICSGSM 11 BE 1 3 EA
BICSGSM 11BK 1 3 EA
BIN766705 1 3 EA
BRT1030 1 3 EA
cxs91029 1 3 3PK
ELD29886 1 3 EA
ESS52006 1 3 EA
ESS62406 1 3 EA
EXP20212 1 3 RL
EXP50014 1 3 DZ
FALDCMT 1 3 EA
FEL95304 1 3 PK
HEWC4127X 1 3 EA
HEWC6979A 1 3 BX
KMW22270 1 3 EA
LEE10134 1 3 EA
CEX SELL CEX EXTD.
PRICE
$28.50
$18.90
$19.53
$32.49
$29.91
]
$1.73
$1.91
$5.91
$1 .O7
$2.67
$2.67
$2.67
$2.67
$2.67
$0.66
$38.17
] $s:74I
$11.43
$11.58
$1.37
$6.55
$7.O5
$2.99
$10.00
$11.97
$29.23
$3.28
$26.88
$9.65
$4.14
$3.14
$3.53
$3.53
$0.39
$0.39
$1.94
$5.84
$3.43
$11.51
$2.38
$10.24
$O.35
$0.99
$6.31
$9.97
$139.20
$24.84
$7.17
$2.99
SELL PRICE SAVINGS% SAVINGS$
$57.00 23.72% $13.52
$55.98 -26.37% -$14.76
$37.80 42.22% $15.96
$39.06 51.10% $19.96
$64.98 66.51% $43.22
$59.82 30.66% $18.34
$1.14 -31.58% -$0.36
$3.46 50.87% $1.76
$3.82 39.27% $1.50
$11.82 39.59% $4.68
$2.14 23.36% $0.50
$5.34 35.96% $1.92
$5.34 35.96% $1.92
$5.34 35.96% $1.92
$5.34 38.58% $2.06
$5.34 38.58% $2.06
$1.32 7.58% $0.10
$11.14 -10.95% -$1.22
$5.80 -11.03% -$0.64
$76.34 64.34% $49.12
$11.48 -42.51% -$4.88
$22.86 63.60% $14.54
$23.16 38.34% $8.88
$2.74 42.34% $1.16
$13.10 8.24% $1.08
$14.10 33.62% $4.74
$5.98 8.36% $0.50
$20.00 35.10% $7.02
$23.94 32.16% $7.70
$58.46 38.93% $22.76
$6.56 8.23% $0.54
$53.76 8.33% $4.48
$28.95 30.88% $8.94
$19.23 -50.08% -$9.63
$0.99 -6.06% -$0.06
$4.59 0.00% $0.00
$12.42 37.92% $4.71
$9.42 49.68% $4.68
$10.59 55.24% $5.85
$10.59 55.24% $5.85
$1.17 30.77% $0.36
$1.17 30.77% $0.36
$5.82 52.06% $3.03
$17.52 34.25% $6.00
$10.29 41.40% $4.26
$34.53 44.22% $15.27
$7.14 67.65% $4.83
$30.72 39.26% $12.06
$1.05 34.29% $0.36
$2.97 10.10% $0.30
$18.93 39.46% $7.47
$29.91 38.31% $11.46
$417.60 26.11% $109.02
$74.52 24.76% $18.45
$21.51 13.11% $2.82
$8.97 61.54% $5.52
OFFICE DEPOT OFFICE DEPOT
EXTD SELL SELL PRICE
PRICE (CEX UM) (CEX UM)
$43.481 $2~:74I
$70.74 $35.37
$12.36 $6.18
$6.44 $3.22
$16.36 $8.18
$28.86 $9.62
$1.05 $0.35
SELL PRICE
(OD UM
UM WHERE
OD UM DIFF DIFF)
EA
BX
BX
BX
BX
BX
72PK * $4.48
DZ * $10.16
EA
4PK
2PK * $1.64
5PK * $8.56
5PK * $8.56
5PK * $8.56
EA
EA
TB
ST
ST
EA
PK
BX
BX
PK
EA
PK
BX
DZ
RM
EA
EA
EA
EA
EA
EA
EA
PK
DZ
DZ
DZ
DZ * $3.25
DZ * $3.25
EA
EA
6PK * $4.O8
EA
5PK * $3.87
EA
EA
DZ
PK
PK
EA
PK
6PK * $37.37
2PK * $2.29
Page 12 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U.P. 2002 PURCHASES
SS
LN
NO
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
69O
691
692
693
694
695
696
697
698
699
7OO
701
7O2
7O3
7O4
7O5
7O6
7O7
7O8
7O9
710
711
712
713
714
715
716
717
718
719
72O
721
722
723
724
725
726
727
728
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
NOTE, PG M RKR, .5X2, NAST,5 P K
TAPE,CUBICLE GRIP,REM,SQ
CALC INK ROLLER,BK
TRAY, LTR,BK
PEN RFL,BLPT,MED,BK
PEN,BLPT,GZMO,MED,BYBK
PEN,BLPT,GZMO,MED,BEBK
PEN, B LPT,GZM O, M E D,VTB K
PEN,BLPT,RZL-DZL,M ED,BE
PEN,BLPT,RZL-DZL,M ED,PK
PEN,BLPT,RZL-DZL,M ED,VT
PCL,MECH,.7MM,SHRP,BE
PEN RFL,G2,FN,BK,2PK
E NVL,CS P,24#,9X12, PRKDG
PC L,WD,#2 ,WARRIOR, BK
MRKR,SHARPIE,ULTRAFN,BK
PEN RFL,SILHTE,MED,BK
MRKR,PAINT,MED,BK
MRKR,PAINT,MED,YW
BNDR,DRNG,LTR,4",BK
PEN,ROLR,JIMNIE,GEL,BE
PEN,ROLR,JIMNIE,GEL,RD
17808 4X8 NAMEPLATE
PPR CLIP,NSKD,#1,1C
PPR CLIP,1.75",JUMBO,GD
PPR,CLI P,#2,G D, 1C/PK
RU BRBAN D,AST SZS, 1.5OZ
BOO K,WYWO,2 PT, NCR,4U P,4C
IN D EX,TAB, 1/3X1.5,CL,25PK
IN DEX, BN DR,LTR,AST,8TB
IN DEX, BN DR,LTR,WE,5TB, 1ST
TAPE,EM BS, 1/2",BK/CL,2PK
PROT,SHT,TL,LTR,8TB,AST
BNDR,DRNG,LTR,5",MN
I NDEX, 1STEP,LTR,AST, 10TB
FLDR,MLA, 1/2,LTR,1C
BN DR,VU,3RG,LTR,3",WE
INDEX,SD TAB,LTR,1-25
BNDR,3RG,LTR,2",BE
BN DR,3RG,LH,LTR,3",BE
FI LE,STG, 10.5X4.25X24
FI LE,STG, 9X4.5X24
FILE,STG,LTR/LGL,RD
DISK,ZIP,IBM
M O U S E PAD, FSTTR K, RD
TAP E,S EAL,48 M MX50M ,CL
GLUE STICK,.25OZ,WE
PAD, POSTIT, 1.5X2,AST, 12
PAD, POSTIT,2X3,AST, 12 P K
PAD, POSTIT, R LD,4X6, P K
FLAG ,TAPE, POSTIT, PE,50
PEN,ROLR,ENERGEL,.5MM,BK
LEAD,MECH PCL,HB,.5MM,12
PEN,ROLR,DLX, BOLD,BK
PEN, RO LR,VBALL,G R P,XF N, BK
E NVL,TYVK, PLN ,9X12,1C
Order Ship
Item ID Freq Qty CEX UM
MMM6705AN 1 3 PK
MMM858 1 3 PK
NUKNR74 1 3 EA
01c21002 1 3 EA
PAR30316 1 3 EA
PENBK31BAA 1 3 EA
PENBK31CAA 1 3 EA
PENBK31VAA 1 3 EA
PENBK92RDCA 1 3 EA
PENBK92RDPA 1 3 EA
PENBK92RDVA 1 3 EA
PENP207C 1 3 EA
PIL77240 1 3 PK
QUA43090 1 3 BX
SAN02254 1 3 DZ
SAN37001 1 3 EA
SAN51411 1 3 EA
SAN63601 1 3 EA
SAN63605 1 3 EA
WLJ38354B 1 3 EA
ZEB44120 1 3 EA
ZEB44130 1 3 EA
AAASTAMPRUB 1 4 LT
ACC72370 1 4 BX
ACC72532 1 4 PK
ACC72533 1 4 PK
ALL07706 1 4 BX
AMP23024 1 4 EA
AVES151 1 4 PK
AVEWI2138 1 4 ST
AVEWT2135 1 4 ST
BRTTC10 1 4 PK
cu05580 1 4 ST
CRD11957 1 4 EA
CRD61018 1 4 ST
ESS75212F 1 4 BX
EXP00080 1 4 EA
EXP10034 1 4 ST
EXP60033 1 4 EA
EXP60038 1 4 EA
FEL00005 1 4 EA
FEL00007 1 4 EA
FEL07242 1 4 EA
FUJ25271001 1 4 EA
KCS811 O8 1 4 EA
MAN07567 1 4 RL
MMM6008 1 4 EA
MMM653A 1 4 PK
MMM656A 1 4 PK
MMM660PK 1 4 PD
MMM6808 1 4 EA
PENBLN15A 1 4 EA
PENC505HB 1 4 TB
PIL28031 1 4 EA
PIL35470 1 4 EA
QUAR1460 1 4 BX
CEX SELL CEX EXTD.
PRICE
$3.55
$2.41
$2.85
$1.90
$1.90
$1.9O
$1.47
$1.47
$O.9O
$3.42
$1.97
$0.69
$1.46
$2.87
$2.87
$11.33
$O.95
$O.95
$52.30
i $o:1~1
$0.75
$0.52
$1.18
$7.53
$3.21
$1.46
$0.81
I $18:Oll
$3.68
$37.03
$3.06
$14.09
$7.75
$6.12
$9.89
$7.75
$4.17
$11.99
$7.87
$1.29
$0.96
$4.70
$8.13
$1.86
$2.10
$1.49
$2.29
$36.90
SELL PRICE SAVINGS% SAVINGS$
$10.65 25.35% $2.70
$7.23 7.88% $0.57
$8.55 26.32% $2.25
$4.68 -0.64% -$0.03
$5.46 -1.10% -$0.06
$5.70 40.00% $2.28
$5.70 40.00% $2.28
$5.70 40.00% $2.28
$4.41 63.27% $2.79
$4.41 63.27% $2.79
$2.70 40.00% $1.08
$10.26 38.89% $3.99
$5.91 39.09% $2.31
$38.79 -63.57% -$24.66
$3.24 -27.78% -$0.90
$2.07 21.74% $0.45
$4.38 37.67% $1.65
$8.61 19.86% $1.71
$8.61 19.86% $1.71
$33.99 38.31% $13.02
$2.85 8.42% $0.24
$2.85 8.42% $0.24
$209.20 0.00% $0.00
$0.64 -131.25% -$0.84
$3.00 8.00% $0.24
$2.08 7.69% $0.16
$4.72 35.59% $1.68
$30.12 52.46% $15.80
$12.84 38.32% $4.92
$5.84 21.92% $1.28
$3.24 25.93% $0.84
$72.04 -9.88% -$7.12
$14.72 1.63% $0.24
$148.12 33.46% $49.56
$12.24 25.16% $3.08
$56.36 59.26% $33.40
$31.00 42.19% $13.08
$19.44 -1.85% -$0.36
$7.92 -22.22% -$1.76
$24.48 29.90% $7.32
$39.56 25.58% $10.12
$31.00 8.26% $2.56
$16.68 38.37% $6.40
$47.96 24.35% $11.68
$31.48 65.44% $20.60
$5.16 62.02% $3.20
$3.84 66.67% $2.56
$18.80 23.62% $4.44
$32.52 23.62% $7.68
$7.44 14.52% $1.08
$4.24 -19.81% -$0.84
$8.40 43.81% $3.68
$1.48 -48.65% -$0.72
$5.96 24.83% $1.48
$9.16 40.17% $3.68
$147.60 41.71% $61.56
OFFICE DEPOT OFFICE DEPOT
EXTD SELL SELL PRICE
PRICE (CEX UM) (CEX UM)
$7.95 $2;65
$6.66 $2i22
$6.30 $2:10
$4.71 $1.57
$5.52 $1.84
$63.45
$4.14
$21.15
$1.38
$0.37
$1.48
$79.16 $19.79
$19.80 $4.95
$9.68 $2.42
$5.08 $1.27
$2.20 $0.55
SELL PRICE
(OD UM
UM WHERE
OD UM DIFF DIFF)
PK
35PK
2PK * $4.19
EA
EA
DZ * $13.66
DZ * $13.66
DZ * $13.66
6PK * $3.23
6PK * $3.23
6PK * $3.23
EA
2PK
BX
DZ
DZ * $6.49
2PK * $1.81
DZ * $27.65
DZ * $27.65
EA
DZ * $1 O.49
DZ * $1 O.49
LT
BX
PK
PK
EA
EA
PK
ST
ST
PK
ST
EA
ST
BX
EA
ST
EA
EA
EA
EA
EA
3PK * $27.2O
EA
6PK * $2.91
EA
PK
DZ
EA
2PK * $2.54
DZ * $14.19
3PK * $1.65O
DZ * $13.41
DZ * $16.43
BX
Page 13 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U,P, 2002 PURCHASES
ss
LN
NO
729
73O
731
732
733
734
735
736
737
738
739
74O
741
742
743
744
745
746
747
748
749
75O
751
752
753
754
755
756
757
758
759
76O
761
762
763
764
765
766
767
768
769
77O
771
772
773
774
775
776
777
778
779
78O
781
782
783
784
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
E NVL,S H I P LIT,9X12,1C
CLEAN ER, PHON E,WI P E,50TU B
FORM HLDR,8.5"X12",AL
FLDR,DT,MLA, 1/3,LTR
TAB,HANG FLDR,1/3,OR,25
TAB, HANG FLDR, 1/3,YW,25
FLDR,HANG,LTR,1/5,BE,25
DESK PAD,DODL,22X17,OD
BNDR,DRNG,LH,LTR,3",DBE
BNDR,DRNG,LH,LTR,4",RD
INDEX, MULTIDEX, BKWE,12TB
BN DR, DRNG,VU, LTR,2",WE
BN DR, DRNG,VU, LTR,3",WE
FLDR,MLA, 1/3,LTR,1C
BNDR,3RG,LTR,1.5",BE
BINDING,PLAS,1.5",BK, 10
STAPLE,STD SIZE,5M
BN DR,VU,3RG,LTR,3",BK
NTBK,WB,PRJ PLANR
REINFORCMNT,9/16,CL,1M
NTBK,WB,CM,11"X8.5"
BNDR,SLTRG,LTR,3",BK
BNDR,SLTRG,LTR,4",BK
BNDR,DRNG,LTR,1.5",NY
CLIP BOAR D, 10"X14.5,STG ,GY
PPR,1PT,20#,14.SX11,BB
PEN,BLPT,STK, MED,BE
DISK, 3.5",DSHD,FRMT
TAPE,AUDIO,XLII,90MIN
TAPE,MAGIC,3/4"X1000"
RIBN,LO,IBM WHLWTR
RIBN,CALC,NYL,BK/RD
PEN,BLPT,FLXGRP,RET,MD,BK
PEN RFL,BLPT,FN,BE
PEN RFL,ROLR,GEL,FN,BK,2P
PEN,BLPT,RZL-DZL,M ED,SK
PCL,M ECH,.7M M,T/CLICK, GN
PCL,MECH,.7MM,T/CLICK,VT
ERASER,MECH PCL,PD345,5TB
CORR PEN,FN,.4OZ,WE
H ILITER,SPOTLITR,SPRME,YW
PEN,BLPT,RET,MED,RD
PPR, FAX,8.5"X98'X.5"
FI L E,WAL L, STAK, BK
MRKR,PERM,XFN,AST
PEN,UNIBALL,VIS,.3MM,BE
PEN RFL,UNIBALL,BK,2CD
PEN RFL,UNIBALL,BEBK,2CD
PEN,UNIBALL,GEL, 1.0MM,BK
STAPLE, FULL STRP, 1/4",5M
CORR TAPE,I-LINE,WE
BNDR,DRNG,LH,LTR,4",BY
BN DR,DRNG,LH,LTR,4",GY
BN DR, DRNG,VU, LTR,3",WE
CAL,DESK PD,12MO,BK
BNDR,DRNG,LH,LTR,1.5",RD
Order Ship
Item ID Freq Qty CEX UM
QUAS3610 1 4 BX
RRTRR1403 1 4 EA
SAU10517 1 4 EA
SMD2153L 1 4 BX
SMD64621 1 4 PK
SMD64624 1 4 PK
SMDC15HBE 1 4 BX
TOP7957 1 4 EA
WLJ38449BL 1 4 EA
WLJ38454R 1 4 EA
WLJ91201 1 4 ST
CRD10500 1 5 EA
CRD10600 1 5 EA
ESS75213 1 5 BX
EXP60028 1 5 EA
G BC4290010 1 5 10PK
sw~35108 1 5 BX
WLJ36249B 1 5 EA
AMP20816 1 6 EA
AVE05722 1 6 P K
AVE33706 1 6 EA
AVESR 1130BK 1 6 EA
AVESR1140BK 1 6 EA
CRDl1447 1 6 EA
ELD10764 1 6 EA
EXP00040 1 6 2600CT
EXP50011 1 6 DZ
IMN12881 1 6 BX
MAX139410 1 6 EA
MMM8101K 1 6 RL
NUK192LT 1 6 EA
NUKBR80C 1 6 EA
PAP95301 1 6 EA
PAR30325 1 6 EA
PAR30525 1 6 PK
PENBK92RDAA 1 6 EA
PENPD107TD 1 6 EA
PENPD107TV 1 6 EA
PENPDE1 1 6 TB
PENZL31W 1 6 EA
PILl6008 1 6 EA
PIL32222 1 6 EA
PMF00012 1 6 RL
ROG48706 1 6 EA
SAN35074 1 6 ST
SAN60134 1 6 EA
SAN61233 1 6 CD
SAN61234 1 6 CD
SAN65870 1 6 EA
swi35450 1 6 BX
TOM68620 1 6 EA
WLJ38454C 1 6 EA
WLJ38454M 1 6 EA
WLJ38649W 1 6 EA
AAGSK2200 1 7 EA
WLJ38434R 1 7 EA
CEX SELL CEX EXTD.
PRICE
$24.60
$9.29
$9.55
$3.35
$3.35
i $s:181
$24.17
$11.98
$17.38
$2.81
$10.98
$14.01
[ $3:77[
$2.85
$8.43
$1.49
$7.46
J
$4.07
$2.57
$7.63
$12.96
$10.71
$16.69
$55.31
$1.95
$3.OO
$2.78
$1.78
$3.30
$2.01
J S0:651
$3.09
$3.89
$1.47
$2.20
$1.50
$0.96
$0.77
$8.57
$5.21
$2.76
$1.59
$2.96
$2.96
$2.91
J S1:62J
$2.39
$17.38
$17.38
$10.21
$13.37
$7.83
SELL PRICE SAVINGS% SAVINGS$
$98.40 8.33% $8.20
$37.16 5.60% $2.08
$69.24 -2.77% -$1.92
$38.20 13.72% $5.24
$13.40 48.06% $6.44
$13.40 48.06% $6.44
$20.72 -37.84% -$7.84
$96.68 70.46% $68.12
$47.92 38.31% $18.36
$69.52 8.34% $5.80
$11.24 1.42% $0.16
$54.90 44.63% $24.50
$70.05 41.04% $28.75
$18.85 -18.83% -$3.55
$14.25 29.12% $4.15
$42.15 54.09% $22.80
$7.45 40.27% $3.00
$37.30 39.95% $14.90
$21.24 -8.76% -$1.86
$24.42 11.79% $2.88
$15.42 43.58% $6.72
$45.78 19.00% $8.70
$77.76 46.06% $35.82
$64.26 68.81% $44.22
$100.14 57.82% $57.90
$331.86 47.93% $159.06
$11.70 54.36% $6.36
$18.00 8.33% $1.50
$16.68 79.86% $13.32
$10.68 19.10% $2.04
$19.80 0.91% $0.18
$12.06 29.85% $3.60
$3.90 -21.54% -$0.84
$18.54 40.45% $7.50
$23.34 7.97% $1.86
$8.82 63.27% $5.58
$13.20 37.27% $4.92
$9.00 8.00% $0.72
$5.76 8.33% $0.48
$8.76 -32.19% -$2.82
$4.44 -14.86% -$0.66
$4.62 36.36% $1.68
$51.42 82.50% $42.42
$31.26 8.45% $2.64
$16.56 8.33% $1.38
$9.54 8.18% $0.78
$17.76 39.53% $7.02
$17.76 39.53% $7.02
$17.46 38.49% $6.72
$9.72 -13.58% -$1.32
$14.34 33.05% $4.74
$104.28 8.34% $8.70
$104.28 8.34% $8.70
$61.26 38.39% $23.52
$93.59 5.01% $4.69
$54.81 57.34% $31.43
OFFICE DEPOT
EXTD SELL
PRICE (CEX UM)
SELL PRICE
OFFICE DEPOT (OD UM
SELL PRICE UM WHERE
(CEX UM) DIFF DIFF)
$71.16 $17.79
$3 2.96 $8i24
$6.96 $1;74
$6.96 $1;74
$28.56 $7.14
$22.40 $4.48
$23.10 $3.85
$21.54 $3;59
$8.70 $1;45
$3 7.08 $6;18
$41.94 $6;99
$20.04 $3;34
$42.24 $7;04
$172.80 $28;80
$5.34 $0;89
$16.50 $2;75
$3.36 $0;56
$8.64 $1;44
$19.62 $3;27
$8.46 $1;41
$4.74 $0.79
$11.58 $1.93
$5.10 $0.85
$11.04 $1.84
OD UM
BX
EA
EA
BX
25PK
PK
BX
EA
EA
EA
ST
EA
EA
BX
EA
50PK
BX
EA
EA
PK
3PK
EA
EA
EA
EA
2500CA
DZ
BX
5PK
4PK
EA
2PK
DZ
EA
2PK
6PK
3PK
3PK
3PK
EA
DZ
DZ
6BX
EA
4PK
EA
2PK
2PK
DZ
BX
EA
EA
EA
EA
EA
EA
$19.350
$4.34
$27.69
$2.81
$5.74
$2.81
$9.46
$3.23
$4.13
$4.13
$2.64
* $10.16
* $5.87
* $9.00
* $21.45
Page 14 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U,P, 2002 PURCHASES
ss
LN
NO
785
786
787
788
789
79O
791
792
793
794
795
796
797
798
799
8OO
801
802
8O3
8O4
8O5
806
8O7
808
8O9
810
811
812
813
814
815
816
817
818
819
82O
821
822
823
824
825
826
827
828
829
83O
831
832
833
834
835
836
837
838
Report Year
Begin Date
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
1/1/2002
Item Description
CVR,REP,PB,11"X8.5",RD
PEN,BLPT,STK, MED,BE
CASE,BINDING,LTR,HGH,ARCH
FRAME,EZ MNT,8.5"X11",WT
PEN,BLPT,ESYTCH,M ED,BE
BN DR,VU,3RG,LTR,2",WE
CDR HLDR,5PK
MOISTENER,BOTTLE,20Z
PEN,BLPT,ERSRMTE2,MED,RD
PEN RFL,STAYPT,BK
HILITER,PKT ACCENT,FYW
HILITER,PKT ACCENT,FPK
H I LITE R, EVE R BO LD, FG N
H ILITER,EVERBOLD,OR
NTBK,WB,CR,LTR
BN DR,VU,3RG,LTR,2",BK
IN D EX,TAB, 1.5X1/3,AST
PEN,BLPT,CUSHN,RET,MED,RD
CLEANER,CLOTH,GY
TAPE,MAGIC,3/4"X36YD
CORR FLUID,.6OZ,LB
PEN,BLPT,COMFTMATE,MED,RD
LEAD,MECH PCL,HB,.7MM,12
PEN,ROLR,GEL,RD
PEN,ROLR,GEL,VT
HILITER,MJR ACNT,YW
HILITER,MJR ACNT,FYW
HILITER,PKT ACCENT,FYW
M RKR, EXP R ESSO,XF N, RD
M RKR, EXP R ESSO,XF N, BE
PEN,UNIBALL,ONYX,.2MM,BK
PEN,U NIBALL,VIS,ELTE,BE
PCL,MECH,.5M,EAGEL
PEN,UNIBALL,VIS,FPE
PEN,UNIBALL,VIS,FPK
PAD,LGL RL,PERF,5XS,WE
PAD, PLAN N E R,20#,WE,70S H
BN DR, DATA, 14.8"X11 ", FSG N
BNDR,DATA, 14.8"X11",MGN
BN DR, DATA, 14.8"X11 ",SBE
BNDR,3RG,LTR,1.5",GN
IN D EX,XWD E, LTR,C L,5TB
BNDR,3RG,LTR,I",GY
BNDR,VU,3RG,LTR,I",WE
FLDR, P B,6S EC,2/5, LTR, RD
CVR,REP,PRSGD,LTR,HG
PEN,BLPT,FLXGRP,RET,FN,BE
PEN,BLPT,FLXGRP,RET,FN,BK
BNDR,DRNG,LH,LTR,1.5",GN
CORD,NECK, NYL,BE
FILE PKT,LTR,3.5"EXP
PEN,BLPT,CUSHN,RET,MED,BE
PEN,BLPT,COMFRTMTE,MED,BK
PEN,BLPT,RET,SAGA, M ED,BE
Item ID
ACC25078
EXP50031
GLWB50H
NUD11890
PIL32011
WLJ36244W
FEL98315
OIC97800
PAP39201
ROG21016
AVE29591
AVE29592
AVE29594
AVE29595
AVE33986
AVECV1120BK
AVES 150
BICSCSM 11 RD
FEL99768
MMM81034X36
PAP56601
PAP63201
PEN507HB
PENK108MB
PENK108MV
SAN25005
SAN25025
SAN27025
SAN39002
SAN39003
SAN60040
SAN61232
SAN64611
SAN69008
SAN69009
TOP63360
TOP99710
WLJ141411NE
WLJ 141411NG
WLJ 141411 NJ
WLJ36834NG
AVE EW2135C
WLJ36814NM
WLJ 36214W
SMD14079
ESS12717
PAP95601
PAP95801
WLJ38434G
BAU68903
SMD1524EB
BICSCSM 11 BE
PAP61301
SAN79013
Order Ship
Freq Qty CEX UM
1 8 EA
1 8 EA
1 8 EA
1 8 EA
1 8 EA
1 8 EA
1 10 PK
1 10 EA
1 10 EA
1 10 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 PK
1 12 EA
1 12 EA
1 12 RL
1 12 EA
1 12 EA
1 12 TB
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 DZ
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 12 EA
1 15 ST
1 15 EA
1 17 EA
1 20 EA
1 22 EA
1 24 EA
1 24 EA
1 26 EA
1 30 EA
1 50 EA
1 72 EA
1 72 EA
1 72 EA
CEX SELL CEX EXTD.
PRICE
$2.05
$0.63
$9.60
$3.30
$O.59
$5.17
$3.70
$1.29
$1.31
$1.83
$1.83
$1.84
$1.83
$1.73
$5.35
$0.53
$5.77
$1.62
$1.60
$O.53
$O.6O
$1.53
$1.53
$O.35
$0.65
$2.73
$0.49
$2.46
$2.40
$13.92
$7.51
$4.52
$4.52
$3.28
$1.07
$1.99
$3.34
$2.53
$1.07
$1 .O7
$8.O4
$0.31
$1 .O7
$O.53
$O.28
$0.74
SELL PRICE SAVINGS% SAVINGS$
$16.40 8.29% $1.36
$5.04 88.25% $4.45
$76.80 25.42% $19.52
$26.40 8.18% $2.16
$4.72 8.47% $0.40
$41.36 38.10% $15.76
$37.00 52.97% $19.60
$5.90 -8.47% -$0.50
$12.90 70.54% $9.10
$13.10 18.32% $2.40
$21.96 81.97% $18.00
$21.96 53.55% $11.76
$22.08 53.80% $11.88
$21.96 80.87% $17.76
$20.76 6.36% $1.32
$64.20 40.93% $26.28
$27.84 -9.91% -$2.76
$6.36 32.08% $2.04
$69.24 43.85% $30.36
$19.44 6.79% $1.32
$19.20 28.13% $5.40
$6.36 7.55% $0.48
$7.20 8.33% $0.60
$18.36 52.94% $9.72
$18.36 52.94% $9.72
$4.20 8.57% $0.36
$4.20 -42.86% -$1.80
$4.20 0.00% $0.00
$9.24 -23.38% -$2.16
$9.24 -23.38% -$2.16
$7.80 38.46% $3.00
$32.76 47.62% $15.60
$5.88 61.22% $3.60
$29.52 47.97% $14.16
$28.80 40.83% $11.76
$167.04 38.36% $64.08
$90.12 48.74% $43.92
$20.88 -37.36% -$7.80
$54.24 47.12% $25.56
$54.24 47.12% $25.56
$39.36 8.23% $3.24
$16.05 8.41% $1.35
$29.85 51.26% $15.30
$56.78 41.62% $23.63
$58.20 -3.09% -$1.80
$55.66 57.71% $32.12
$25.68 26.17% $6.72
$25.68 26.17% $6.72
$209.04 23.63% $49.40
$9.30 16.13% $1.50
$53.50 41.12% $22.00
$38.16 32.08% $12.24
$20.16 0.00% $0.00
$53.28 33.78% $18.00
OFFICE DEPOT OFFICE DEPOT
EXTD SELL SELL PRICE
PRICE (CEX UM) (CEX UM)
$6.40 $0.64
$30.60 $2.55
$6.00 $0.50
$4.20 $0.35
$11.40 $0.95
$11.40 $0.95
$28.68 $2.39
$60.00 $3.00
UM
OD UM DIFF
EA
DZ *
EA
EA
EA
EA
5PK
EA
5PK *
EA
EA
DZ *
DZ *
DZ *
EA
EA
PK
EA
EA
RL
EA
EA
3PK *
5PK *
5PK *
EA
EA
DZ *
DZ *
DZ *
DZ *
EA
DZ *
DZ *
DZ *
DZ
EA
EA
EA
EA
EA
ST
EA
EA
EA
EA
DZ *
DZ *
EA
EA
EA
EA
DZ *
EA
SELL PRICE
(OD UM
WHERE
DIFF)
$0.89
$1.92
$10.16
$10.16
$4.24
$1.65O
$3.60
$3.60
$4.24
$11.44
$11.44
$4.84
$2.29
$15.39
$17.08
$9.46
$9.46
$3.39
Page 15 of 16 Shaded cells indicate lower price
PRICE COMPARISON - CORPORATE EXPRESS VS. OFFICE DEPOT CITY OF U.P. 2002 PUF~CHASES
ss
LN
NO
Report Year
Begin Date Item Description
Item ID
OFFICE DEPOT OFFICE DEPOT
Order Ship CEX SELL CEX EXTD. EXTD SELL SELL PRICE
Freq Qty CEX UM PRICE SELL PRICE SAVINGS% SAVINGS$ PRICE (CEX UM) (CEX UM)
GRAND TOTAL $37,151.41 28.82% $10,707.06 $26,444.35
SELL PRICE
(OD UM
UM WHERE
OD UM DIFF DIFF)
Page 16 of 16 Shaded cells indicate lower price
MINUTES
#2315
CITY COUNCIL MEETING
CITY OF UNIVERSITY PARK, TEXAS
CITY HALL COUNCIL CHAMBER
TUESDAY, AUGUST 5, 2003 AT 5:00 P.M.
Mayor Harold Peek convened the City of University Park City Council into Executive Session at
4:00p.m. to receive legal advice from the City Attorney under Section 551.071 of the Texas
Government Code. The Executive Session was adjourned at 4:20p.m. No action was voted on
or taken during the meeting.
Mayor Harold Peek then opened the regular meeting of the City Council. Present were
Councilmembers Jim Roberts and Harry Shawver. Also in attendance were City Attorney Rob
Dillard, City Manager Bob Livingston, and City Secretary Nina Wilson. Mayor Pro Tempore
Dick Davis and Councilmember Blackie Holmes were absent and excused.
AWARD
CERTIFICATE OF ACHIEVEMENT: The State of Texas Commission on State Emergency
Communication has awarded Mr. Augustest Walton the "Silent Hero Certificate of
Achievement" award. This award is given to 9-1-1 dispatchers for their exemplary conduct in
the field of emergency telecommunications. The call that prompted Mr. Walton to be nominated
for this award was a call he handled in September 2002, which led officers to a homicide scene.
With information he provided, the officers were kept updated for their safety as well as securing
a crime scene with adequate personnel. Fire Chief David Ledbetter presented Mr. Walton with
the award.
Councilmember Shawver moved acceptance of the Consent Agenda. Councilmember Roberts
seconded, and the vote was unanimous to approve the following:
CONSENT AGENDA
CONSIDER ORDINANCE REGARDING DENIAL OF NATURAL GAS RATE REQUEST:
The City passed a resolution in May 2003 suspending TXU's request and authorizing the joining
of a coalition of 123 cities working under the direction of a Steering Committee authorizing the
filing of an intervention in the proceeding on TXU's rate application pending at the Railroad
Commission (RRC), GUD No. 9400 referred to as Allied Coalition of Cities (ACC). The
Company's Statement of Intent to change gas rates within the City as part of the Company's
statewide gas utility system is found to be unreasonable because: (a) TXU's requested return on
equity is excessive, generating more than 86% of the requested increase in rates; (b) the basis for
TXU's proposed consolidations (of regional distribution systems and of pipeline costs with
distribution costs) has not been established; (c) the City's jurisdiction to increase pipeline rates
has not been established and, therefore, the proposed pipeline cost increases should be
disallowed; (d) revenue requirements should be reduced rather than increased; and (e) the TXU
filing should be denied pursuant to agreement with the Company; and is therefore denied in all
respects.
ORDINANCE NO. 03/16
AN ORDINANCE OF THE CITY OF UNIVERSITY PARK, TEXAS,
DENYING TXU GAS COMPANY'S REQUEST TO CHANGE RATES IN
THIS MUNICIPALITY, AS A PART OF THE COMPANY'S STATEWIDE
GAS UTILITY SYSTEM; PROVIDING A REQUIREMENT FOR A PROMPT
REIMBURSEMENT OF COSTS INCURRED BY THE CITY; FINDING THAT
THE MEETING AT WHICH THIS ORDINANCE IS PASSED IS OPEN TO
THE PUBLIC AS REQUIRED BY LAW; AND PROVIDING FOR NOTICE OF
THIS ORDINANCE TO TXU GAS COMPANY.
CONSIDER PROPOSAL FROM C&P ENGINEERING FOR DESIGN OF WATER AND
SANITARY SEWER IMPROVEMENTS IN ALLEY BOUNDED BY STANHOPE,
SHENANDOAH, PRESTON AND ARMSTRONG IN THE AMOUNT OF $83,936. This work
was driven by the deteriorating condition of the sanitary sewer.
CONSIDER FiNAL PAYMENT TO BARSON UTILITIES, INC., FOR WATER, SANITARY
SEWER IMPROVEMENTS AND ALLEY PAVING, PROJECT NO. 42710: The Engineering
Department has accepted the completed work. Partial payments in the amount of $2,094,021.99
have been made to the contractor resulting in a final payment in the amount of $110,211.67.
CONSIDER FINAL PAYMENT TO BARSON UTILITIES, INC., FOR WATER, SANITARY
SEWER IMPROVEMENTS AND ALLEY PAVING, PROJECT NOS. 42711 AND 44170:
The Engineering Department has accepted the completed work. Partial payments in the amount
of $517,582.06 (42711 $366,169.94 and 44170 - $151,412.12) have been made to the
contractor resulting in a final payment in the amount of $22,739.87 (42711 $18,462.81 and
44170 - $4,277.06). The final payment includes a credit of $394.27 (42711) for water utility
payments for the 3700 blocks of Lovers Lane and Amherst.
CONSIDER APPROVAL OF CITY COUNCIL MEETING MINUTES: For July 16, 2003.
MAIN AGENDA
PUBLIC HEARING AMENDING HILLCREST HOTEL PLANNED DEVELOPMENT: Mayor
Peek opened the public hearing. Mr. Brandon Blackburn, 8100 Lomo Alto, The Eureka Hotel
Group, spoke on behalf of the hotel, stating the property at 6101 Hillcrest was a Ramada Inn and
in a state of disrepair when they decided to redesign the rooms and upgrade the hotel. Building
& Zoning Administrator Wade McLaurin stated that Planned Development District No. 22 was
established in June 1997 as an assisted care facility. The facility was never developed, and the
property continued to be operated as a hotel. Mayor Peek closed the public hearing.
CONSIDER ORDINANCE AMENDMENT TO HILLCREST HOTEL PLANNED
DEVELOPMENT DISTRICT NO. 22: On July 21, 2003, the Planning & Zoning Commission
approved a request by 6101 Hillcrest Group, L.P. to amend Planned Development 22 (PD-22).
The request was to allow for continued hotel use of the property in lieu of the assisted care
facility use that was approved in June of 1997. Staff recommended that the existing planned
development be amended after the project was expanded beyond the permitted interior remodel.
The project expansion was a result of asbestos and mold encountered during the remodel.
Councilmember Roberts moved approval. Councilmember Shawver seconded, and the vote was
unanimous to approve the amendment to Planned Development District No. 22.
ORDINANCE NO. 03/17
AN ORDiNANCE OF THE CITY OF UNIVERSITY PARK, TEXAS, AMENDiNG THE
COMPREHENSIVE ZONiNG ORDiNANCE AND MAP OF THE CITY OF UNIVERSITY
PARK, AS HERETOFORE AMENDED, SO AS TO AMEND PLANNED DEVELOPMENT
DISTRICT NO. 22 FOR THE PROPERTY DESCRIBED AS LOTS 1, 2, AND 3 OF BLOCK D,
UNIVERSITY ANNEX NO. 2, AN ADDITION TO THE CITY OF UNIVERSITY PARK,
DALLAS COUNTY, TEXAS, AND MORE COMMONLY KNOWN AS 6101 HILLCREST,
UNIVERSITY PARK, TEXAS; APPROViNG A SITE PLAN; PROVIDiNG SPECIAL
CONDITIONS; PROVIDiNG FOR THE REPEAL OF ALL ORDiNANCES iN CONFLICT;
PROVIDiNG A SEVERABILITY CLAUSE; PROVIDiNG FOR A PENALTY OF FINE NOT
TO EXCEED THE SUM OF TWO THOUSAND DOLLARS ($2,000.00) FOR EACH OFFENSE;
AND PROVIDING AN EFFECTIVE DATE.
CONSIDER ORDiNANCE TO ADOPT COMMERCIAL BUILDING HEIGHTS: A
recommendation was made by the Planning & Zoning Commission on March 17, 2003 to place
the following height restrictions on commercial properties: PD-1-R (Snider Plaza) 40 feet overall,
PD-2-R (Miracle Mile) 26 feet, with an additional 9-foot allowance for equipment and screening, and
General Retail (GR) 40 feet overall. Staff will present a new ordinance creating an additional
General Retail Zoning District to the August Planning & Zoning Commission Meeting.
Councilmember Roberts moved this item be held for further study and action be deferred until
the September 17, 2003 meeting when all City Councilmembers will be present.
Councilmember Shaxwer seconded, and the vote was unanimous to defer action.
CONSIDER AMENDMENT TO SIGN ORDINANCE REGARDING TEMPORARY SIGNS:
The Urban Design and Development Advisory Committee (UDADAC) was asked to review the current
requirements for temporary signs found in the Sign Ordinance and make recommendations as to how
potential constitutionality issues regarding our political sign restrictions could be resolved. In an effort to
also make the residential neighborhoods in the City less cluttered, UDADAC reviewed all of the
temporary sign regulations and made the following recommendations: set a maximum of six (6) square
feet for any temporary sign. The current maximum square footage for a political sign is three (3) square
feet, while real estate or contractor signs are allowed to be six (6); provide for a total aggregate square
footage of twelve (12) square feet for temporary signs per lot. This would allow for multiple political
signs on a property or the combination of different types of temporary signs (i.e. a real estate sign and a
political sign on the lot at the same time); maintain the current maximum height of four (4) feet for
temporary signs and amend the ordinance to prohibit the use of contractor signs. The proposed changes
will provide for political signs to be regulated the same as other temporary signs, eliminating the
constitutionality issues, and creating enforceable restrictions. Contractor signs will be eliminated.
Councilmember Roberts suggested a 30-day notice be sent to general contractors by mail, stickers on
signs and on the website. Councilmember Shawver moved approval of the amendment. Councilmember
Roberts seconded, and the vote was unanimous to approve the enabling ordinance amending Article
12.200 of the University Park Code of Ordinances. Mayor Peek recognized Former Mayor Barbara
Hitzelberger and Mr. Robert H. "Bobby" Clark, member of U.D.A.D.A.C. and thanked them for their
support with this issue.
ORDINANCE NO. 03/18
AN ORDINANCE OF THE CITY OF UNIVERSITY PARK, TEXAS, AMENDING THE
CODE OF ORDINANCES OF THE CITY OF UNiVERSITY PARK, CHAPTER 12, SIGN
REGULATIONS, BY AMENDING SECTION 12.229 REGULATING REAL ESTATE SIGNS;
AMENDING SECTION 12,231 TO PROHIBIT CONSTRUCTION SIGNS IN RESIDENTIAL ZONES;
AMENDING SECTION 12.233 TO REGULATE AGGREGATE AREA OF TEMPORARY SIGNS IN
RESIDENTIAL ZONES; AMENDiNG SECTION 12.237 REGULATING POLITICAL SIGNS IN
RESIDENTIAL ZONES; PROVIDING FOR THE REPEAL OF ALL ORDINANCES IN
CONFLICT; PROVIDING A SEVERABILITY CLAUSE; PROVIDING FOR A PENALTY OF
FINE NOT TO EXCEED THE SUM OF FIVE HUNDRED DOLLARS ($500.00) FOR EACH
OFFENSE; AND PROVIDING AN EFFECTIVE DATE.
PRESENTATION OF PROPOSED FY2004 BUDGET: The proposed budget for FY 2004
(October 1, 2003 September 30, 2004) consisted of a properly tax rate decrease of 1%, from
$0.32932 to $0.32601, maintenance of existing service levels with optimal workforce size and
competitive compensation, continuation of aggressive pay-as-you-go funding of infrastructure
replacement, no user fee increases, a balanced General Fund budget; a $250,033 increase in
funding for capital projects, and the addition of two full-time positions, Fire Department
Training Officer and Utilities Office Billing/Mail Clerk. This was the 9th consecutive year for a
reduction in the City's tax rate. The tax levy for an average single-family home, valued 1.7 %
higher than last year, would increase $12.35 (0.7%). Councilmember Roberts moved acceptance
of the budget with instructions that it be sent to the Finance and Employee Benefits Committees
for recommendation as to action. Councilmember Shaxwer seconded, and the vote was
unanimous for budget acceptance.
CONSIDER ACCEPTANCE OF $99,099 FEDERAL GRANT FOR ASSISTANCE FOR HOMELAND
SECURITY: In April 2003, the City of University Park participated in a statewide assessment to
evaluate the threat, vulnerability, capabilities, and needs of jurisdictions within the State of
Texas to handle bio-terrorism and terrorist events. A joint task force from the Police, Fire and
Public Works Departments participated in this assessment to evaluate the need for equipment
and training within our jurisdiction. These grant monies would allow the Police, Fire and Public
Works Departments to stockpile equipment and be operationally prepared for local or regional
terrorist events. In June 2003, the City of University Park received notification of an award of
$99,099 toward the purchase of equipment and training. Councilmember Shawver moved
approval of the acceptance of the federal grant. Councilmember Roberts seconded, and the vote
was unanimous to accept $99,099 from the U.S. Department of Homeland Security.
CONSIDER ENGINEERING CONTRACT WITH R.L. GOODSON FOR DESIGN OF LOVERS
LANE: A proposal from R.L. Goodson was presented in the amount of $176,000 that would
provide engineering and surveying services associated with the design of street improvements
for Lovers Lane, from Hillcrest east to North Central Expressway. Councilmember Roberts
moved approval of the contract subject to deleting the "limit of liability" clause.
Councilmember Shaxwer seconded, and the vote was unanimous to approve the proposal.
CONSIDER ORDINANCE CHANGING TITLE FROM ENVIRONMENTAL INSPECTOR
TO NEIGHBORHOOD INTEGRITY OFFICER: The current job does not truly deal with
environmental issues, but more with right-of-way code compliance matters; therefore, the name
of Neighborhood Integrity Officer seems more applicable. This ordinance would amend Section
6, Article 6.500 of the Code of Ordinances of the City of University Park. Councilmember
Shawver moved approval of the ordinance. Councilmember Roberts seconded, and the vote was
unanimous to approve the title change.
ORDINANCE NO. 03/19
AN ORDiNANCE OF THE CITY OF UNIVERSITY PARK, TEXAS, AMENDING THE
CODE OF ORDINANCES, AS HERETOFORE AMENDED, BY AMENDING ARTICLE 6.500
TO DESIGNATE THE NEIGHBORHOOD INTEGRITY OFFICER FOR THE CITY;
PROVIDING FOR THE REPEAL OF ALL ORDINANCES IN CONFLICT; PROVIDING A
SEVERABILITY CLAUSE; AND PROVIDING AN EFFECTIVE DATE.
Mayor Peek recognized two boy scouts working on their merit badges. Reagan Tankersley,
3306 Hanover, Troop #70, working on his Citizenship in the Community Merit Badge, and Lake
Tankersley, 3306 Hanover, Troop #70, on his Communications Merit Badge.
Mrs. Carolyn Loy spoke to the council regarding the lack of benches in Coffee Park and across
from University Park Elementary School. She requested two benches from the park at Lovers
Lane and Hillcrest be moved. Mayor Peek said her request regarding the benches would be sent
to the Park Department. City Manager Bob Livingston told her more benches were in future
plans for all parks. She also complimented the council on the budget and the gates to be
installed at Central Expressway and University and SMU Boulevards. She suggested gates at the
toll road would be appropriate also. Mayor Peek thanked her for her comments and interest in
the City.
There being no further business, the meeting was adjourned.
PASSED AND APPROVED this 20th day of August 2003.
ATTEST:
Harold Peek, Mayor
Nina Wilson, City Secretary
AGENDA MEMO
(08/20/03 AGENDA)
DATE: August 13,2003
TO: Nina Wilson
FROM: Thom Hanford
SUBJECT: Request from Highland Park LaCrosse Board
ITEM:
The Highland Park High School lacrosse team is requesting the use of Coffee Park
(or Germany Park if available) for practice purposes. Their program has two
seasons, the Fall Season which runs from October 1st through November 15th, and
the Spring Season which runs from February 1st through May 15th. They are asking
for a practice time of 4:15 PM tffi dark Monday thru Friday. They would Hke this
request to be approved for the next 5 years.
I have some concerns about the sport of lacrosse being played in a public park. The
game requires that a very hard ball be thrown between players, sometimes at high
rates of speed. Given the skill levels of the players, it is not certain what direction
this ball will go. Mr. Wellington has proposed to put up netting similar to that used
on a batting cage. This is a fine idea but I would hate to see either Coffee Park or
Germany Park with 10 to 12 foot netting strung around an area the size of a football
field. Mr. Wellington would do only the ends of the field but I believe for the safety
of other park patrons, the entire field would have to be enclosed.
I also have to ask why the Park Department should have to provide space for
another high school athletic team to practice? We had the girls softball teams for a
number of years using Coffee and Curtis Parks. We continue to have the boys
soccer teams using Goar Park during the school years. If this request is granted it is
going to mean that some YMCA programs will have to be scaled back.
RECOMMENDATION:
The High School has complete control of Germany Park and can schedule practice
times as they wish. I would recommend, as I did back in the spring, that the
lacrosse team work out a practice schedule with the other teams using Germany
3800 UNIVERSITY BOULEVARD UNIVERSITY PARK, TEXAS 75205 TELEPHONE (214) 363-1644
C:\Documents and Settings~nwilson\Local Settings\Temporary Internet Files\OLK21\Lacrosse request 2.doc 12:52 PM 08/1
Park. They may not get as much time as they would like but they need to
understand that they are "the new kids on the block".
ATTACHMENTS:
Letter from Highland Park Lacrosse Board
3800 UNIVERSITY BOULEVARD UNIVERSITY PARK, TEXAS 75205 TELEPHONE (214) 363-1644
C:\Documents and Settings~nwilson\Local Settings\Temporary Internet Files\OLK21\Lacrosse request 2.doc 12:52 PM 08/1
MEMORANDUM
CITY OF UNIVERSITY PARK, TEXAS
TO:
FROM:
SUBJECT:
Honorable Mayor and City Council
Director of Finance
Budget and tax rate public hearings
DATE: August 14, 2003
ITEM
Texas statutes require that cities provide notice and hold public hearings before adopting an annual budget
and property tax rate.
Proposed FY2004 budget
State law requires that a budget hearing be held no sooner than 15 days after the proposed budget is filed
with the municipal clerk. Using August 5 as the filing date, a hearing August 20 meets this requirement. A
second budget hearing will take place at the September 2 Council meeting; at the conclusion of the
hearing, the Council acts upon the proposed budget and tax rate.
The proposed FY04 budget of $32.053 million is 4.67% larger than the adopted FY03 budget of $30.623
million. The proposed budget includes a tax rate decrease; no rate increases for water, sewer, and garbage
service; and $4.549 million in capital project funding. The Finance Advisory Committee met August 6 to
review and recommend approval of the proposed budget. Details are included in the attached August 5
memo from the City Manager and line item detail.
Proposed property tax rate
The property tax is the General Fund's primary source of revenue. The proposed FY04 rate of $0.32601 is
a 1.0% reduction from last year's adopted rate of $0.32932. The certified taxable property base rose
6.06%. The proposed budget would collect $585,180 more in property taxes than last year, a 5.0%
increase. Thus it is correct to say that the City is both cutting the tax rate and raising taxes.
EFFECTIVE TAX RATE OVERVIEW
Due to the intricacies of the official effective tax rate (ETR) calculation, the proposed $0.32601 rate that
will raise 5% more tax revenue represents an effective tax increase of only 2.01%. The ETR is significant
because it drives the notice and hearing requirements a city must meet per the Texas Truth-in-Taxation
law. Cities proposing an effective tax increase greater than 3% must hold a separate public hearing about
the tax rate. The Dallas County Tax Assessor-Collector performs the effective tax rate calculation. This
year, University Park need only hold a tax rate hearing at the same meeting the rate is scheduled for
adoption.
The ETR's purpose is to identify the tax rate that produces the same revenue dollars this year as last year.
Instead of using the new 2003 certified tax roll ($3.769 billion) as the base, the ETR calculation considers
only those properties that were on the tax roll one year ago, after adjustment for changes in exemptions,
values under protest, and court-ordered reductions. The resulting tax base number ($3.682 billion) is
known as the "2003 Adjusted Taxable Value" and omits the $90.559 million added by new construction in
C:~Doc~tments and Settings~nwilson~Local Settings\Temporary Internet Files\OLK21~Budget Hearing 082003 memo.doc 08/14/03 12:54 PM
1
University Park this year. This new construction makes up 42% of the $215 million increase in the
certified taxable value.
At the same time, the taxes levied one year ago are also adjusted for refunds and are known as the
"Adjusted 2002 Taxes." Dividing this adjusted tax figure ($11.705 million) plus refunds by the adjusted
tax base ($3.682 billion) produces an effective tax rate of $0.319573/$100. Comparing the new proposed
tax rate of $0.32601 against the ETR yields an effective tax increase of 2.01%.
RECOMMENDATION
Holding public hearings regarding the proposed budget and property tax rates will allow opportunity for
input from the community and coverage by the local press. Formal action by Council on the budget, tax
rate, and salary ordinance is scheduled for Tuesday, September 2, 2003.
Attachments:
· City Manager's budget memo of 5 August 2003
· Proposed FY04 line-item detail
C:~Doc~m~ents and Settings~nwilson~Local Settings\Temporary Internet Files\OLK21~Budget Hearing 082003 memo.doc 08/14/03 12:54 PM
2
MEMORANDUM
CITY OF UNIVERSITY PARK, TEXAS
TO:
Honorable Mayor and City Council
FROM: City Manager
DATE: August 5, 2003
SUBJECT: FY 2004 Proposed Budget
OVERVIEW
This memo presents the City Manager's proposed budget for FY 2004 (October 1, 2003 September 30,
2004). The FY 2004 budget continues trends familiar in prior year budgets:
· A reduction in the City's tax rate for the 9th consecutive year.
· Maintenance of existing service levels with optimal workforce size and competitive
compensation.
· Continuation of aggressive pay-as-you-go funding of infrastructure replacement.
· No user fee increases.
Highlights of the proposed budget include:
· A property tax rate decrease of 1%, from $0.32932 to $0.32601. The tax levy for an average
single-family home, valued 1.7 % higher than last year, would increase $12.35 (0.7%).
· A balanced General Fund budget.
· A $250,033 increase in funding for capital projects.
· The addition of two full-time positions Fire Department Training Officer and Utilities Office
Billing/Mail Clerk.
Total expenditures
The proposed FY04 budget totals $32.05 million, an increase of $1.43 million, or 4.67%, from FY03's
total $30.62 million. As in past years, personnel-related costs are the primary reason for the increase
($1.14 million), followed by capital project transfers ($250,033) and supplies/other ($151,802). The
proposed budget does not include any major equipment or new programs.
Personnel costs
Salaries and benefits represent 52% of the proposed budget's makeup. Total personnel costs for FY2004
are $17.51 million, up 7.0 % or $1.14 million from FY03's $16.37 million. Of this, $630,098 represents
increased salary-related costs and $512,320 represents increased benefit costs. The proposed budget
includes a 3% market-based salary increase and a 52% increase in employer health insurance payments.
Even though our employees have supported attempts to control costs, including paying higher amounts for
their coverage, health costs have been rising 15% to 20% per annum for several years. Consecutive years
of high claims forced a sharp increase in the City's contributions starting last January. This increase is now
included in the FY 2004 Budget.
1
C:[Documents and Settings[nwilson[Local Settings[Temporary Internet Files[OLK21 [CM Budget Letter FYO4].doc
08/14/03 12:55 PM
Comparisons
The table below provides a comparison of total budgeted expenditures for the City's three budgeted funds.
Three other funds Capital Projects, Equipment Services, and Self-Insurance are not included in the
formal budget, although they each receive contributions from the budgeted funds. Departmental and line
item detail is provided in the attached schedule.
TOTAL BUDGETED EXPENDITURES - FY02 TO FY04
FY02 FY03 FY04 % CHANGE
FUND ADOPTED ADOPTED PROPOSED FY04 V. FY03
General
Utility
Sanitation
Debt Service
Total
17,910,128 18,957,713 19,923,714 5.10%
8,674,252 9,288,817 9,632,850 3.70%
2,215,774 2,376,790 2,496,972 5.06%
220,913 -0- -0- 0.00%
$29,021,067 $30,623,320 $32,053,536 4.67%
As in past years, the General Fund expenditures increased the most compared to the other funds. The bulk
of the City's personnel and operations are contained in the General Fund, which in tum is supported
primarily by property taxes (63% of General Fund revenue).
By way of reference, over the past year, the Consumer Price Index (CPI)-All Urban Consumers for Dallas-
Fort Worth increased 2.3%. The City's FY04 proposed budget is 4.67% higher than last year's adopted
budget. What accounts for the more rapid increase in City expenditures compared to the CPI? Simply put,
the CPI's collection of consumer goods does not align with the items purchased by the City. The proposed
FY2004 budget is especially hard hit by sharp rises in personnel-related costs, such as health insurance as
well as other items such as fuel costs, which have increased dramatically during the past year. The only
bright spot is that we perceive a larger number of contractors are now willing to bid our capital projects.
Whether or not this will translate into lower costs, particularly since contractors face many of the same
personnel and other costs as we do, is difficult to determine.
Revenue considerations
The proposed budget includes modifications to non-property tax revenues in the General Fund, which help
lessen the burden placed on the property tax. For FY2003 there was little opportunity to project increases
in key General Fund revenues, like sales taxes, franchise fees, interest eamings and building permits. This
year is similar, although we are projecting increases in franchise fees and direct alarm monitoring charges.
We have also projected slight increases in an assortment of other General Fund revenues, such as
ambulance billing. Overall, non-property tax General Fund revenues are budgeted to increase 5.1%, the
same percentage as property-tax-related revenues.
Tax rate decrease
The trend of consistent sharp increases in property values throughout the city appears to be ending. Last
year, market values citywide rose 8.27%, while this year the increase is 2.67%. Despite this, taxable value
increased 6.06%, reflecting the release of property parcels whose taxable value was capped last year. The
FY04 budget includes a proposed rate reduction of 0.0033 cents, from $0.32932 to $0.32601 per $100
taxable value. This represents a 1.0 % decrease in the property tax rate. Due to the increased taxable
value, however, the proposed rate will increase the typical single-family homeowner's bill by about 1.7 %.
This equals about $1.00 a month for the average University Park homeowner.
PROPERTY TAX RATE COMPARISON FY01 TO FY04
2
C:[Documents and Settings[nwilson[Local Settings[Temporary Internet Files[OLK21 [CM Budget Letter FYO4].doc
08/14/03 12:55 PM
TAX ADOPTED ADOPTED PROPOSED PROPOSED
P U R POS E FY01 FY02 FY03 FY04
O&M
Operations
Capital
Total O&M
Debt Service
Total Tax Rate
$0.28002 $0.25948 $0.25789 $0.25488
$0.07683 $0.07377 $0.07142 $0.07113
$0.35685 $0.33325 $0.32932 $0.32601
$0.01474 $0.00675 $0.00000 $0.00000
$0.37159 $0.33999 $0.32932 $0.32601
For FY04 the average single-family home in University Park is valued at $717,626, an increase of
$11,887 (1.7%) over last year. The owner of an average home whose value did not increase in assessed
value this year would pay $18.69 less in City taxes compared to FY03.
TAX LEVY COMPARISON FY01 TO FY04
ADOPTED ADOPTED ADOPTED PROPOSED
FYO 1 FY02 FY03 FY04
Assessed Value (Market)
Less 20% Hmstd Exmp
Taxable Value
Tax Rate per $100
City Tax Levy
$552,938 $637,009 $705,739 $717,626
(110,588) (127,402) (141,148) (143,525)
$442,350 $509,607 $564,592 $574,101
$0.37159 $0.33999 $0.32932 $0.32601
$1,643.73 $1,732.61 $1,859.30 $1,871.65
Over the period FY01 to FY04, the average single-family home has increased 29.8 % in market value,
while the City tax levy has increased 13.9%.
CAPITAL PROJECTS
The proposed budget continues the program of replacing the City's aging infrastructure. Project funding
included in the adopted FY03 and proposed FY04 budgets is shown as follows:
PROJECT FY03 FY04
Mile-per-year water, sewer, and alley replacement
Curb and gutter replacement
General Fund contribution - undesignated
Asphalt overlay program
Fire hydrant installation
Utility Fund contribution - undesignated
Total
$1,850,000 $1,962,665
$ 811,275 $ 877,224
$ 917,000 $ 944,510
$ 510,000 $ 541,059
$ 135,000 $ 143,222
$ 76,000 $ 80,628
$4,299,275 $4,549,308
In addition to these operating contributions, the City occasionally transfers additional funds to the Capital
Projects Fund each year. These transfers are made from unappropriated fund balances in the General and
Utility Funds. When combined with the budgeted transfers shown above, they allow the City to fund and
3
C: [Documents and Settings[nwilson[Local Settings[ Temporary D~ternet Files[OLK2] [CM Budget Letter FY04]. doc
08/14/03 12:55 PM
construct an average of over $6 million in projects each year.
SALARIES AND PERSONNEL ADJUSTMENTS
Personnel changes
The proposed budget includes two new positions, bringing the full-time headcount total to 239. This
number continues to be lower than the 244 the City employed in the early 1990's. One of the new
positions is the Fire Department Training Officer. This position was requested last year but cut. As we
have discussed in briefings, this position is needed to oversee and coordinate the increasingly complex
training our paramedics must undergo as well as the increasing requirements of Federal, State, and local
programs to deal with emergency preparedness. Second, the budget includes the restoration of the Utility
Billing/Mail Clerk position eliminated three years ago. This position is currently filled on a temporary
basis and now includes receptionist relief responsibilities.
Salary costs
Salary-related costs in all funds increased approximately $630,098, from $12.362 million to $12.991
million for FY04. As in past years, the City performed salary surveys to compare our relative position in
both the public and private job markets. Last year, the results of the survey indicated that to remain
competitive, the City only needed to increase Police and Fire salaries. This year, the results indicated that
a 3% salary increase for all positions is appropriate. Some employees will be eligible for a merit increase,
depending upon their current step in the pay plan. However, each year the number of such eligible
employees declines as more reach the top steps of their respective pay ranges.
Benefits costs
The proposed budget includes one minor benefit adjustment. For employees covered by the Texas
Municipal Retirement System (TMRS), I am proposing to reduce the years of service required for
retirement from 25 to 20. The only employees not affected will be fire personnel, who are covered by their
own system and can already retire after 20 years of service. The annual cost of this TMRS adjustment is
approximately $27,000.
The cost of existing benefits in all funds is rising by $512,320, a 12.8%increase. As mentioned
previously, employers of all sizes are experiencing rising health care costs. The City's claims experience
continues to be poor. The 46-year average age of our group, coupled with the high increases in medical
costs overall, does not help to lower claims. For FY04 employer health insurance premiums make up
$398,430 of the $512,320 benefit costs increase. This is fully 52% higher than what was budgeted last
year. On a positive note, the budgeted amounts for life and ADD insurance rose only 3.3%, and workers
compensation insurance decreased 3.8%.
UTILITY FUND
The proposed Utility Fund budget includes no rate increases for water or sewer charges. The City of
Dallas has informed us that our wastewater treatment cost will rise 5.4%, from $1.95 million to $2.05
million. No increase is forecasted for water treatment charges, which are currently budgeted at $2.27
million. Largely as a result of the $105,241 wastewater treatment increase, and $188,784 increase in
salary and benefit costs, the proposed FY04 Utility Fund budget is out of balance by $181,175. Because
Utility Fund water revenues are so volatile, however, the projected deficit may not be realized. Rather
than eliminate positions or raise rates, I recommend approving the Utility Fund budget as proposed. The
4
C'.' IDocuments and S'ettingslnwilsonlLocal S'ettingsl Temporary lnternet FileslOLK21 ICM £udget Letter FY041. doc
08/14/03 12:55 PM
budgeted deficit ($181,175) represents just 1.8% of Fund expenditures.
SANITATION FUND
The proposed Sanitation Fund budget is also out of balance, which is consistent with budgets for this Fund
over the last five years. Unlike the General Fund, Sanitation Fund revenues only increase if rates are
raised. The Fund routinely expends less than its budget, which allows it to finish the year with a positive
balance. At the end of the third quarter of FY2003, the Sanitation Fund had a year-to-date positive
balance of $75,000 and should end the year with a $70,000-$90,000 gain. Our Sanitation employees and
Superintendent Kenneth Chance continue to perform an outstanding job. Further, and also consistent with
past years, the Sanitation Budget contains a $100,000 placeholder, which is intended to allow
accumulation of reserves toward future landfill needs. Using this approach, the unappropriated fund
balance for Sanitation was $797,000 as of June 30, 2003. A year ago it was $616,000, and two years ago
it was $589,000. Again, this growth is planned to build a reserve for future landfill needs.
CONCLUSION
As in the past, the proposed budget will be sent to the Employee Benefits, Finance, and Insurance Advisory
Committees for review. Staff`has begun scheduling those meetings. Because we propose to increase
property tax revenues more than 3%, State Truth-in-Taxation law requires that a separate public hearing be
held before the meeting at which the tax rate is adopted. To comply with this law, staff`proposes the
following schedule for the FY2004 budget's adoption.
Date Day
August 5 Tuesday
Description
Submit proposed budget to City Council
Vote to hold public hearing re. proposed tax rate
August 20 Wednesday Conduct public hearing re. proposed tax rate
August 28 Thursday Notice of vote on tax rate appears in Park Cities People
Sept. 2 Tuesday
Conduct public hearings on budget and tax rate
Approve ordinances adopting budget and tax rate
Oct. 1
Wednesday New budget takes effect
5
C:[Documents and Settings[nwilson[Local Settings[Temporary Internet Files[OLK2] [CM Budget Letter FYO4].doc
08/14/03 12:55 PM
CITY OF UNIVERSITY PARK, TEXAS
FY 2004 PROPOSED BUDGET
SUMMARY BY FUND AND DEPARTMENT
GENERALFUND
01-11 REVENUES
TOTAL GENERALFUND REVENUES
EXPENDITURES
01-02 EXECUTIVE
01-03 FINANCE
01-04 HUMAN RESOURCES
01-05 INFORMATION SERVICES
01-10 COURT
01-19 BUILDING
01-20 ENGINEERING
01-25 TRAFFIC
01-35 FACILITY MAINTENANCE
01-40 FIRE
01-50 POLICE
01-70 PARKS
01-75 SWIMMING POOL
01-80 STREETS
01-85 TRANSFERS
TOTAL GENERAL FUND EXPENDITURES
DIFFERENCE
UTILITY FUND
REVENUES
02-11 REVENUES
EXPENDITURES
02-21 UTILITY OFFICE
02-22 UTILITIES
02-85 TRANSFERS
TOTAL UTILITY FUND EXPENDITURES
DIFFERENCE
SANITATION FUND
04-11 REVENUES
TOTAL SANITATION FUND REVENUES
EXPENDITURES
04-60 SANITATION
TOTAL SANITATION FUND EXPENDITURES
DIFFERENCE
TOTAL REVENUES
TOTAL EXPENDITURES
DIFFERENCE
FY03 FY04
ADOPTED PROPOSED
BUDGET BUDGET
$18,957,713 $19,924,227
$18,957,713 $19,924,227
% CHANGE
$ CHANGE
5.10% $966,514
5.10% $966,514
$605,755 $618,054 2.03% $12,299
$892,781 $918,432 2.87% $25,651
$304,568 $303,261 -0.43% ($1,307)
$462,172 $485,068 4.95% $22,896
$234,353 $249,236 6.35% $14,883
$552,889 $580,616 5.01% $27,727
$808,789 $872,773 7.91% $63,984
$694,104 $740,709 6.71% $46,605
$572,835 $611,069 6.67% $38,234
$3,328,761 $3,502,650 5.22% $173,889
$4,307,531 $4,523,224 5.01% $215,693
$1,958,841 $2,064,482 5.39% $105,641
$171,450 $166,950 -2.62% ($4,500)
$1,524,609 $1,606,127 5.35% $81,518
$2,538,275 $2,681,063 5.63% $142,788
$18,957,713 $19,923,714 5.10% $966,001
$0 $513
$513
$9,451,675 $9,451,675 0.00% $
$9,451,675 $9,451,675 0.00% 0%
$5,018,501 $5,140,536
$2,509,316 $2,624,069
$1,761,000 $1,868,245
$9,288,817 $9,632,850
$1621858 ($181,I75)
$2,231,450 $2,231,450
$2,231,450 $2,231,450
2.43% $ 122,035
4.57% $ 114,753
6.09% $ 107,245
3.70% $ 344,033
$ (344,033)
o.oo% $o
0.00% 0
$2,376,790 $2,496,972 5.06% $120,182
$2,376,790 $2,496,972 5.06% $120,182
($I45,840) ($265,522) ($I20,182)
$30,640,838 $31,607,352 3.15% $966,514
$30~623~320 $32~053~536 4.67% $1~430~216
$17,518 {$448,~841 ($483,702)
CITY OFUNIVERSITY PARK, TEXAS
FY2004 PROPOSED BUDGET
PROPERTYTAXIMPACT
TOTAL TAXABLE VALUE (CERTIFIED)
TOTAL GENERAL FUND REVENUES
NON PROPERTY TAX REVENUE
Sales tax
Franchise fees
Building permits
Traffic/parking fines
Service charges
Direct alarm monitoring fees
Miscellaneous
TOTAL NON PROPERTY TAX REV,
PROPERTY TAX REVENUE
Operations & Maintenance (O&M) need
Penalty/interest & attorney's fees
Delinquent (prior years) taxes
TOTAL PROP TAX OP REQUEST
DEBT SERVICE REQUIREMENT
PROPERTY TAX RATE
Operations & Maintenance (O&M)
Debt Service
Total Property Tax Rate per $100
IMPACT ON HOMEOWNER
Average single-family market value
Less: 20% homestead exemption
Average single-family taxable value
Tax levy
Change from prior year
FY2002 FY2003 FY2004
ADOPTED ADOPTED PROPOSED % Change
BUDGET BUDGET BUDGET FY04/FY03
$ Change
FY04 V. FY03
$ 3,272,644,258 $ 3,553,903,488 3,769,405,331 6.06% $
$ 17,910,497 $ 18,957,713 $ 19,924,227 5.1% $
$ 2,160,220 $ 2,160,220 $ 2,160,220 0.0% $
1,543,630 1,650,000 1,805,000 9.4% $
700,000 700,000 700,000 0.0% $
355,000 355,000 355,000 0.0% $
365,160 400,160 452,160 13.0% $
210,000 285,000 350,000 22.8% $
1,505,781 1,533,228 1,621,562 5.8% $
215,501,843
966,514
155,000
52,000
65,000
88,334
6,839,791 $ 7,083,608 $ 7,443,942 5.1% $ 360,334
10,905,718 $ 11,703,605 $ 12,288,785 5.0% $ 585,180
106,619 110,000 115,000 4.5% $ 5,000
58,000 60,500 76,500 26.4% $ 16,000
$ 11,070,337 $ 11,874,105
$ 220,913 $
$ 0.33324 $ 0.32932
0.00675
$ 12,480,285 5.1% $ 606,180
$ O.O% $
$ 0.33999 $ 0.32932
$ 637,009 705,739
(127,402) (141,148)
509,607 564,592
$ 1,732.61 $ 1,859.30
$ 88.88 $ 126.69
Fund: GENERAL FUND I Department:ADMINISTRATION I Division: EXECUTIVE (01-02)
iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii~iii~i~ii~ii~ ~iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
31-02-1002 OVERTIME EARNINGS SALARIES & BENEFITS $358 ~500 ~0 $500 $0 0.00%
31-02-1007 CAR ALLOWANCE SALARIES & BENEFITS $7,200 ~7,200 ~7,200 $7,200 $0 0.00%
31-02-1120 EMPLOYERS SHARE T.M.R.S. SALARIES & BENEFITS $34,751 ~34,9~ ~,994 $35,894 $900 2.57%
31-02-1130 INSURANCE-EMPLOYEE LIFE SALARIES & BENEFITS $1,399 ~1,589 ~1,550 $1,~0 $51 3.21%
31-02-1132 INSURANCE-UNEMPLOYMENT SALARIES & BENEFITS $0 ~0 ~0 $0 $0 ~DIV/0!
31-02-2100 OFFICE SUPPLIES SUPPLIES $1,724 ~2,421 ~2,000 $2,121 (~300) -12.39%
31-02-3003 BOARD MEETINGS PROFESSIONAL $647 ~1,150 ~650 $900 ($250) -21.74%
SERVICES
31-02-3014 PUBLICATIONS PROFESSIONAL $12,001 ~1,200 ~2,779 $1,200 $0 0.00%
SERVICES
31-02-3063 PROGR~MING/MAINTENANCE PROFESSIONAL $2,500 ~3,500 ~3,500 $6,625 $3,125 89.29%
SERVICES
31-02-4110 H EAT, LIGHT,WATER UTIL UTILITIES $1,515 ~1,879 ~1,879 $1,879 $0 0.00%
D1-02-55~ INSURANCE-EXCESS LIABILIT INSURANCE 947,000 ~47,000 ~47,000 91,098 (~45~02) -97.66%
31-02-5514 INSURANCE-PUBL.OFF'L LIAB INSURANCE 939,300 ~39,300 ~39,300 950,000 910,700 27.23%
D1-02-6200 EQUIP REPAIRS/NON VEHICLE OUTSIDE SERVICES 91,909 ~1,800 ~1,800 91,800 $0 0.00%
31-02-7151 CONTINGENCY FUND OTHER $0 ~0 ~0 $0 $0 ~DIV/0!
31-02-7153 CAPITAL PROJECTS CONTRIB OTHER $0 ~0 ~0 $0 $0 ~DIV/0!
31-02-7202 MICRO COMPUTER SOF~ARE OTHER $0 ~1,000 ~400 $1,000 $0 0.00%
31-02-7240 TUITION & TRAINING OTHER $29,681 ~17,350 ~15,650 $2,650 (~14 700) -84.73%
31-02-7432 ELECTIONS OTHER $3,480 ~0 ~0 $7,500 $7,500 ~DIV/0!
~ ~-~ ~ ~i~ ~Ui~N CA~iTA~ ~N~igJ~ ~iV~i
31-02-9201 MICRO COMPUTER CAPITAL EXPENDITURES $200 ~810 $851 $500 ($~10) -38.27%
EQUIPMENT
~ ~-~ ~i~ ~U~Ni ~ CA~iTA~ ~N~igJ~ ~iV~i
SALARIES & BENEFITS $3~,53~ $355,049 $356,283 $372,111 $17,062 4.81%
SUPPLIES $1,94~ $2,921 $2,000 ~2,621
PROFESSIONALSERVlCES $115,461 $109,050 $137,579 $138,775 $29,725 27.26%
UTILITIES $4,951 $5,312 $5,312 $5,31:
INSURANCE $91,~ $91,048 $91,048 $55,957 ($55091) -38.54%
OUTSIDE SERVICES $1,90~ $1,800 $1,800 $1,80~
OTHER $56,01~ $39,765 $37,465 $39,97~ $213 0.54%
CAPITAL EXPENDITURES $32~ $810 $1,076
DEPARTMENTTOTAL~ $616,191 $605,~55 $632,563 $618,054 $12,299 2.03%
Fund: GENERAL FUND I Department: FINANCE I Division: FINANCE (01-03)
~1-03-1002 OVERTIME F~RNINGS SAlaRIES & BEN EFITS $3,158 $1,500 ~500 ~1,500 $0 0.00%
31-03-1007 CAR ALLOWANCE SA~RIES & BENEFITS $7,200 $7,200 ~7,200 ~7,200 $0 0.00%
31-03-1120 EM PLOYERS SHARE T.M.R.S. SA~RIES & BENEFITS $59,388 $69,100 ~69,100 ~71,835 $2,735 3.96%
31-03-1131 INSU~CE-WOR~ENS COMP SA~RIES & BENEFITS $839 $1,331 ~1,331 ~1,387 $56 4.21%
SA~RIES &BENEFITS $531,241 $627,302 $626,30: $6~,65:
OTHER $19,9~ $16,~1 $18,491
CAPITAL EXPENDITURES $8,456 $13,060 $11,90( $3,50~
Fund: GENERAL FUND I Department:ADMINISTRATION I Division: HUMAN RESOURCES (01-04)
~E~EIB~ ~ BBNEEI ~
01-04-1002 OVERTIME EARNINGS SALARIES & BENEFITS $353 $0 $0 $0 $0 0.00%
01-04-1007 CAR ALLOWANCE SALARIES & BENEFITS $7,200 $7,200 $7,200 $7,200 $0 0.00%
01-04-1120 EMPLOYERS SHARE TM.R.S. SALARIES & BENEFITS $21,042 $21,356 $21,356 $22,436 $1,080 0.00%
91-04-1131 INSURANCE-WORKMENS SALARIES & BENEFITS $307 $427 $427 $434 $7 0.00%
COMP
~1-04-1135 HEALTH INSURANCE SALARIES & BENEFITS $5,801 $10,216 $10,216 $10,155 ($61) 0.00%
91-04-2100 OFFICE SUPPLIES SUPPLIES $1,592 $1,550 $1,200 $1,350 ($200) 0.00%
91-04-3010 POSTAGE PROFESSIONAL SERVICES $448 $500 $250 $500 $0 0.00%
~%04-30~3 ~ROFESSIO~Ak SERVICES $0 $0 $0 $0 $0 0.00%
PROGRAMMING/MAINTENANCE
~-04-4~0 HEAT,UGHT,WATER UTIk UTIklTIES $40~ $48~ $48~ $48~ $0 0.00%
01-04-5504 INSURANCE-EXCESS LIABILIT INSURANCE $0 $0 $0 $0 $0 0.00%
91-04-5520 RISK, LOSS, C~IM MGMT INSURANCE $35,000 $35,000 $35,000 $45,000 $10,000 0.00%
01-04-7110 EMPLOYEE RECOGNITION OTHER $6,127 $9,000 $9,000 $9,000 $0 0.00%
01-04-7170 TRAVEL EXPENSE OTHER $399 $3,600 $3,600 $2,750 ($850) 0.00%
~ WA~
01-04-7221 OTHER EXPENSE OTHER $219 $2,000 $2,000 $2,000 $0 0.00%
01-04-7245 TUITION REIMBURSEMENT OTHER $0 $0 $0 $0 $0 0.00%
01-04-9201 MICRO COMPUTER CAPITAL EXPENDITURES $0 $0 $0 $0 $0 0.00%
EQUIPMENT
SALARIES & BENEFITS $208,54( $200,45( $200,45( $204,08( $3,630 0.00%
SUPPLIES $1,59; $1,55( $1,20( $1,35(
PROFESSIONAL SERVICES $34,09~ $32,80( $25,05( $29,80( ($3,000) 0.00%
UTILITIES $2,25~ $2,26: $2,26: $2,26:
INSURANCE $35,28( $35,28( $35,28( $45,89~ $10,618 0.00%
OUTSIDE SERVICES
OTHER $10,30( $31,82~ $22,92~ $19,47( ($12,355) 0.00%
CAPITAL EXPENDITURES $C $C $C
DEPARTMENT TOTALS $292,06( $3~,56~ $287,56~ $303,261 ($1,307) 0.00%
Fund: GENERAL FUND I Department: INFORMATION SERVICES I Division: INFORMATION SERVICES (0'1-05)
01-05-1005 LONGEVITY PAY SALARIES & BENEFITS $367 $576 $576 $864 $288 50.00%
01-05-1110 EMPLOYERS SHARE F.I.C.A. SALARIES & BENEFITS $12,114 $15,206 $15,206 $15,938 $732 4.81%
01-05-1130 INSURANCE-EMPLOYEE LIFE SALARIES & BENEFITS $982 $1,170 $1,170 $1,247 $77 6.58%
81-05-1132 INSURANCE-UNEMPLOYMENT SALARIES & BENEFITS $0 $0 $0 $0 $0 CDIV/0!
01-05-2029 CLOTHING ALLOWANCE SUPPLIES $0 $0 $0 $0 $0 CDIV/0I
01-05-2318 COMPUTER SUPPLIES SUPPLIES $14,131 $11,074 $11,000 $11,074 $0 0.00%
~1-05-3060 PROFESSIONAL SERVICES PROFESSIONAL SERVICES $47,985 $26,800 $26,800 $35,040 $8,240 30.75%
~ ~i~N ~RVi~
91-05-4110 HEAT,LIGHT,WATER UTIL UTILITIES $406 $792 $792 $792 $0 0.00%
~ IE~IE~ ~ 78~
01-05-5506 INSURANCE-GEN'L LIABILITY INSURANCE $331 $331 $331 $1,061 $730 220.54%
01-05-7150 DUES & SUBSCRIPTIONS OTHER $205 $950 $950 $955 $5 0.53%
01-05-7202 MICRO COMPUTER OTHER $24,488 $41,598 $25,000 $27,536 ($14,0~2) -33.80%
SOFTWARE
01-05-7240 TUITION & TRAINING OTHER $12,024 $7,425 $7,425 $12,800 $5,375 72.39%
01-05-9100 OFFICE EQUIPMENT CAPITAL EXPENDITURES $0 $0 $0 $0 $0 CDIV/0I
~-05-~20~ MICRO COM~UTER CA~ITAk EXPENDITURES $30,087 $38,573 $35,000 $~,370 ($27~203) -70.52%
EQUIPMENT
01-05-9910 OFFICE FURNITURE CAPITAL EXPENDITURES $942 $0 $0 $0 $0 CDIV/0i
SALARIES & BENEFITS $208,74( $267,491 $267,491 $288,871
SUPPLIES $14,59~ $11,78( $11,60( $11,78( $0 0.00%
PROFESSIONAL SERVICES $50,281 $35,97( $35,97(
UTILITIES $27,74~ $45,57~ $30,79; $56,71( $11,141 24.44%
INSURANCE $331 $331 $331 $1,061
OUTSIDE SERVICES $8,66; $11,19( $11,00( ~13,31( $2,120 18.95%
OTHER $40,90( $51,25: $34,43: $48,351
CAPITAL EXPENDITURES $34,06( $38,57: $35,00( ~16,37( ($22,203) -57.56%
DEPARTMENT TOTALS $385,333 $462,172 $426,617 ~85,06~
Fund: GENERAL FUND I Department: FINANCE I Division: COURT
iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
Fund: GENERAL FUND I Department: PUBLIC WORKS I Division: BUILDING (01-19)
31-19-1002 OVERTIME EARNINGS SALARIES & BENEFITS ~0 $500 $0 $500 $0 3.00%
31-19-1007 CAR ALLOWANCE SALARIES & BENEFITS ~0 $0 $0 $0 $0 ~DIV/0!
31-19-1120 EMPLOYERS SHARE T.M.R.S. SALARIES&BENEFITS ~52,411 $53,611 $53,611 $56,121 $2,510 ~.68%
31-19-1131 INSURANCE-WORKMENS SALARIES&BENEFITS ~4,639 $6,479 $6,479 $6,816 $337 5.20%
31-19-1135 HEALTH INSURANCE SALARIES & BENEFITS ~20,005 $23,880 ~23,880 $35,047 $11,167 ~6.76%
31-19-2100 OFFICE SUPPLIES SUPPLIES ~1,674 $2,200 $2,200 $2,200 $0 3.00%
31-19-2320 GAS, OIL & GREASE SUPPLIES ~1,645 $1,570 $1,775 $1,570 $0 3.00%
31-19-3003 BOARD MEETINGS =ROFESSIONAL SERVICES ~265 $360 $420 $360 $0 3.00%
31-19-3014 PUBLICATIONS =ROFESSIONAL SERVICES ~953 $525 $500 $525 $0 3.00%
31-19-3063 PROGRAMMING/MAINTENANCE =ROFESSIONAL SERVICES ~0 $4,100 $4,100 $4,305 $205 5.00%
31-19-4120 TELEPHONE SERVICE JTILITIES ~7,639 $7,604 $6,750 $7,604 $0 3.00%
31-19-5506 INSURANCE-GEN'L LIABILI~ NSURANCE ~522 $522 ~522 $1,673 $1,151 220.50%
31-19-6195 EQUIPMENT MAINTENANCE DUTSIDE SERVICES ~7,634 $8,812 $8,812 $7,556 ($I,256) -14.25%
31-19-7202 MICRO COMPUTER SOF~ARE DTHER ~6,215 $750 $750 $750 $0 3.00%
31-19-7240 TUITION & TRAINING 3THER ~4,652 $2,390 $2,000 $2,810 $420 17.57%
31-19-7300 HANDICAP RAMP REIMB 3THER ~0 $0 $0 $0 $0 ~DIV/0!
~1-19-9100 OFFICE EQUIPMENT 2APITAL EXPENDITURES ~0 $0 $0 $0 $0 ~DIV/0~
31-19-9600 AUTOMOBILES 3APITAL EXPENDITURES ~0 $0 $0 $0 $0 ~DIV/0i
SALARIES & BENEFITS $489,891 $496,047 $495,547 $530,273 $34,226 ~.90%
SUPPLIES $5,886 $6,520 $6,65( $6,520
PROFESSIONAL SERVICES $22,828 $7,060 $14,22( $7,265 $205 2.90%
UTILITIES $10,291 $9,843 $8,98~ $9,843
INSURANCE $577 $577 $577 $1,765 $1,188 205.89%
OUTSIDE SERVICES $10,230 $11,028 $10,26~ $9,772
OTHER $14,905 $8,615 $7,17~ $7,385 ($I230) -14.28%
CAPITAL EXPENDITURES $7,511 $13,199 $13,19~ $7,793
DEPARTMENT TOTALS $562,118 $552,889 $556,61~ $580,616 $27,727 5.01%
Fund: GENERAL FUND I Department: PUBLIC WORKS I Division: ENGINEERING (01-20)
01-20-1002 OVERTIME EARNINGS SALARIES & BENEFITS $795 $500 $500 $500 $0 0.00%
01-20-1007 CAR ALLOWANCE SALARIES&BENEFITS $11,584 $7,200 $14,400 $14,400 $7,200 100.00%
01-20-1120 EMPLOYERS SHARE TM.R.S. SALARIES & BENEFITS $75,605 $79,881 $79,881 $85,274 $5,393 6.75%
~52 ~79
91-20-1131 INSURANCE-WORKMENS SALARIES&BENEFITS $11,588 $16,114 $16,114 $17,032 $918 5.70%
COMP
~1-20-1135 HEALTH INSURANCE SALARIES & BENEFITS $21,777 $27,702 $32,598 $40,520 $12,818 46.27%
~1-20-2100 OFFICE SUPPLIES SUPPLIES $1,428 $1,000 $1,200 $1,000 $0 0.00%
~1-20-2320 GAS, OIL & GREASE SUPPLIES $2,299 $2,555 $2,200 $2,555 $0 0.00%
91-20-3003 BOARD MEETINGS PROFESSIONAL SERVICES $88 $300 $0 $300 $0 0.00%
~-20-30~ 4 ~U BklCATIO~S ~ROFESSIO~Ak SERVICES $0 $0 $0 $0 $0
~-20-30~3 ~ROFESSIO~Ak SERVICES $2,4~ $~ 2,350 $~2,350 $~5,787 $3,437 27.83%
PROGRAMMING/MAINTENANCE
~-20-4~0 HEAT,klGHT,WATER UTIk UTIklTIES $2,5~8 $2,727 $2,727 $2,727 $0 0.00%
01-20-5500 INSURANCE-AUTO LIABILITY INSURANCE $124 $124 $124 $206 $82 66.13%
81-20-6190 AUTO REPAIRS OUTSIDE SERVICES $2,274 $2,329 $2,329 $2,329 $0 0.00%
01-20-6200 EQUIP REPAIRS/NON VEHICLE OUTSIDE SERVICES $259 $1,500 $1,000 $1,500 $0 0.00%
81-20-7170 TRAVEL EXPENSE OTHER $3,446 $3,500 $5,500 $6,315 $2,815 80.43%
01-20-7221 OTHER EXPENSE OTHER $695 $275 $0 $275 $0 0.00%
01-20-7245 TUITION REIMBURSEMENT OTHER $0 $0 $0 $0 $0 CDIV/0!
01-20-9100 OFFICE EQUIPMENT CAPITAL EXPENDITURES $0 $0 $0 $0 $0 ~DIV/0~
01-20-9910 OFFICE FURNITURE CAPITAL EXPENDITURES $0 $0 $0 $0 $0 ~DIV/0~
SALARIES & BENEFITS 9681,13~ $734,06~ $746,18~ 9794,94;
SUPPLIES $7,36~ $9,40{ $7,75[ $7,90~ ($1500~ -15.95%
PROFESSIONAL SERVICES 915,957 $23,70[ $23,40[ $23,637
UTILITIES $15,54~ $14,69{ $14,69{ $14,69~ $0 0.00%
INSURANCE $77~ $77~ $77~ 92,30;
OUTSIDE SERVICES $9,67{ $9,17~ $8,67~ $9,17~ $0 0.00%
OTHER 913,861 $8,97~ $14,20[ S14,26~
CAPITAL EXPENDITURES $8,73~ $7,997 $8,497 $5,~5{ ($21~) -26.77%
DEPARTMENT TOTALS $753,054 $808,78~ $824,~8; $872,77~
Fund: GENERAL FUND I Department: PUBLIC WORKS I Division: TRAFFIC (01-25)
31-25-1002 OVERTIME EARNINGS SALARIES & BENEFITS ~2,175 $500 $500 $3,000 $2,500 500.00%
31-25-1007 CAR ALLOWANCE SALARIES & BENEFITS ~0 $0 $0 $0 $0 ~DIV/0!
31-25-1120 EMPLOYERS SHARE T.M.R.S. SALARIES & BENEFITS ~38,691 $39,363 $39,363 $40,463 $1,100 2.79%
31-25-1131 INSURANCE-WORKMENS SALARIES&BENEFITS ~11,780 $15,979 $15,979 $16,461 $482 3.02%
31-25-1135 HEALTH INSURANCE SALARIES & BENEFITS H 9,473 $23,566 ~23,566 $34,701 $11,135 ~7.25%
31-25-2100 OFFICE SUPPLIES SUPPLIES ~589 $455 $455 $455 $0 3.00%
31-25-2320 GAS, OIL & GREASE SUPPLIES ~3,876 $3,120 $3,120 $4,498 $1,378 ~4.17%
31-25-2360 SMALL TOOLS SUPPLIES ~591 $0 $0 $500 $500 ~DIV/0!
~1-25-4110 H EAT,LIGHT,WATE R UTIL JTILITIES ~48,285 $43,860 $43,860 $43,860 $0 ~.00%
31-25-5500 INSURANCE-AUTO LIABILI~ NSURANCE ~621 $621 ~621 $1,033 $412 ~6.34%
31-25-6190 AUTO REPAIRS 3UTSIDE SERVICES H 0,690 $5,458 $5,458 $8,587 $3,129 57.33%
31-25-6200 EQUIP REPAIRS/NON VEHICLE 3UTSIDE SERVICES ~0 $0 $0 $0 $0 ~DIV/0i
31-25-7150 DUES & SUBSCRIPTIONS 3THER ~320 $400 $320 $400 $0 3.00%
31-25-7202 MICRO COMPUTER SOF~ARE 3THER ~0 $700 $500 $700 $0 3.00%
31-25-7240 TUITION & TRAINING 3THER ~494 $1,475 $0 $1,440 ($35) -2.37%
31-25-7260 EQUIPMENT RENTAL 3THER ~0 $1,200 $700 $700 ($500) -41.67%
SALARIES & BENEFITS $364,384 $381,474 $381,47~ $405,814 $24,340 S.38%
SUPPLIES $101,781 $126,382 $126,33~ $137,835
UTILITIES $51,156 $46,526 $46,52( $46,526
OUTSIDE SERVICES $57,085 $83,034 $123,03z $99,604
OTHER $1,041 $4,575 $2,46~ $3,915 ($660) .14.43%
CAPITAL EXPENDITURES $20,832 $22,280 $22,28( $15,357
--und: GENERAL FUND I Deparlment: PUBLIC WORKS I Division: FACILITY MAINTENANCE (01
3/ 35 /002 OVERTIME EARNINGS SALARIES&BENEFITS $//65 ~500 $/500 ~//23 $623 /24 60%
}/ 35 /007 CAR ALLOWANCE SALARIES & BENEFITS $4384 ~0 $6025 ~7200 $7200 ~DIV/0!
=und: GENERAL FUND I Department: PUBLIC SAFETY I Division: FIRE (01~40)
:und: GENERAL FUND I Depar~nent: PUBLIC SAFETY I DJ~lsJon: POLICE (01 ~0)
Fund: GENERAL FUND I Department: PARKS I Division: PARKS (01-70)
~1-70-1002 OYERTIME E^RNINGS S^[_^RIES & BENEFITS ~3~,322 $20,000 $30,000 ~20,000 $0 ).00%
~vi ~
~1-70-9900PARKIMPROVEMENTS CAPITAL EXPENDITURES ;6,026 $30,000 $30,000 ~15,000 ($15,000) 50.00%
Fund: GENERAL FUND I Department: PARKS I Division: SWIMMING POOL (01-75)
01-75-1002 OVERTIME EARNINGS SALARIES & BENEFITS $12,024 ~6,000 $6,000 ~6,000 $0 0.00%
01-75-1120 EMPLOYERS SHARE T.M.R.S. SALARIES & BENEFITS $0 ~0 $0 ~0 $0 ~DIV/0!
01-75-3010 POSTAGE PROFESSIONAL $1,029 ~1,950 $1,950 ~1,450 ~500) -25.64%
SERVICES
01-75-4110 H EAT,LIGHT,WATER UTIL UTILITIES $0 ~0 $0 ~0 $0 CDIV/0!
D1-75-6189 SWIMMING POOL REPAIRS OUTSIDE SERVICES $15,329 ~18,500 $18,500 ~15,000 (~SS00} -18.92%
81-75-9201 MICRO COMPUTER CAPITAL EXPENDITURES $0 ~0 $0 ~0 $0 CDIV/0!
EQUIPMENT
SA~RIES & BENEFITS $129,50~ $106,000 $121,00( $125,500
PROFESSIONAL SERVICES $16,02~ $16,950 $1,95( $1,450 ($15,500) -91.45%
UTILITIES $C
OUTSIDE SERVICES $15,32~ $18,500 $18,50( $15,000 ($3,500) -18.92%
OTHER $30,69; $30,000 $30,00( S25,000
CAPITAL EXPENDITURES $( $0 $( $0 $0 CDIV/0!
DEPARTMENT TOTALS $191,56: $171,450 $171,45( $166,950
Fund: GENERAL FUND I Department: PUBLIC WORKS I Division: STREETS (01-80)
31-80-1002 OVERTIME EARNINGS SALARIES&BENEFITS ~25,050 $30,000 $15,000 315,000 ($I5,000) -50.00%
31-80-1007 CAR ALLOWANCE SALARIES & BENEFITS ~7,200 $7,200 $7,200 ~7,200 $0 0.00%
Fund: GENERAL FUND I Department: FINANCE I Division: TRANSFERS (01-85)
91-85-4120 TELEPHONE SERVICE UTILITIES $0 $0 $0 50 $0 ~DIV/0!
01-85-7153 CAPITAL PROJECTS CONTRIB OTHER $702,000 $917,000 $0 5944,510 $27,510 3.00%
01-85-9582 CURB & GUTTER CAPITAL $902,275 $811,275 $0 ~877,224 $65,949 B.13%
EXPEN DITU RES
UTILITIES $0 $~ $0 $0 $0 ~DIV/0!
OUTSIDE SERVICES $510,000 $510,00~ $0 $541,059
OTHER $702,000 $917,00~ $0 $944,510 $27,510 ~.00%
TRANSFERS $0 $~ $0 $0
CAPITAL EXPENDITURES $1,202,275 $1,111,275 $0 $1,195,494 $84,219 7.58%
DEPART~ENTTOTALS $2,414,275 $2,538,275 $0 $2,681,063~ ~
Fund: WATER &SEWER FUND I Department: FINANCEI Division: REVENUES (02-11)
02-11-3451 WATER SALES-COMMERCIAL REVENUE ~;167,516 ~;459,125 $0 $459,125 $0 0.00%
02-11-3453 WATER SALES-PARKS/CITY REVENUE $0 $0 $0 $0 $0 #DIV/0!
02-11-3521 WATER SALES-SMU REVENUE ~605,085 ~430,000 $0 $430,000 $0 0.00%
02-11-3523 METER INSTALLATION REVENUE ~118,196 ~65,000 $0 $65,000 $0 0.00%
02-~ ~-353~ S~W~ CHA~G~S ~V~U~ $0 $0 $0 $0 $0 ~DIV/0~
02-~-3533 SfiWfi~ Pfi~MIIS ~fiVfi~Ufi $~03,~¢5 $¢0,000 $0 $¢0,000 $0 0.00%
~V~N~
02-11-3551 SEWER CHRG-COMMERCIAL REVENUE ~146,344 ~233,750 $0 $233,750 $0 0.00%
02-11-3850 AUCTION/SALE OF EQUIPMENT REVENUE ~0 ~2,000 $0 $2,000 $0 0.00%
02-11-3910 GAIN(LOSS) - INVESTMENTS REVENUE $0 $0 $0 $0 $0 ~DIV/0~
02-11-3999 OTHER REVENUE REVENUE ~9,197 ~3,600 $0 $3,600 $0 0.00%
REVENUE $8,957,095 $9,451,675 $0 $9,451,675 i~
DEPAR~ENTTOTALS $8~957~095 $9~451~675 $0 $9~451~675 $0 0.00%
Fund: WATER & SEWER FUND I Department: FINANCE I Division: UTILITY OFFICE (02-21)
:und: WATER & SEWER FUND I Deparl~ent: PUBLIC WORKS I Division: UTILITIES (02-22)
iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii~i~i~i~i ~iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiiiiiiiiii~iiiiiiiiiiiiiii iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiiii~iiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiiiiiiiiiiii~iiii
Fund: WATER & SEWER FUND I Department: FINANCE I Division: TRANSFERS (02-85)
92-85-8500 TRANSFERS TRANSFERS ~0 ~0 $0 $0 ~0 ~DIV/0!
92-85-9990 INFRASTRUCTURE CAPITAL ~76,000 ~76,000 $0 $80,628 ~4,628 6.09%
EXPEN DITU RES
OUTSIDE SERVICES $135,000 $135,000 ${ $143,22;
TRANSFERS $0 $0 ${ ~{ ~0 ~DIV/0!
CAPITAL EXPENDITURES $1,626,000 $1,626,000 ${ $1,725~02~
DEPARTMENT TOTALS $~,76~,000 $~,76~,000 $( $~,868,24{ ~107,245 6.09%
Fund: SANITATION FUND I Department: FINANCE I Division: REVENUES (04-11)
04-11-3500 REFUSE COLLECTION CHARGES REVENUE $0 $0 $0 50 ~;0 gDIV/0!
04-11-3503 YARD WASTE BAGS REVENUE REVENUE $74,134 $77,000 $0 577,000 30 3.00%
D4-11-3540 REFUSE COLL- RESIDENTIAL REVENUE $1,218,400 $1,371,700 $0 51,371,700 30 3.00%
~11-3542 REFUSE COLL-CHURCH/SCHOOL ~EVENUE $77,341 $137,500 $0 5137,500 30 3.00%
~4-11-3800 CONTRIBUTION-GENERAL FUND ~EVENUE $0 $0 $0 50 t;0 gDIV/0!
84-11-3900 INTEREST EARNINGS REVENUE $15,728 $18,000 $0 518,000 30 3.00%
04-11-3995 OTHER SOURCES/EQUITY TRSF REVENUE $0 $0 $0 50 ~;0 gDIV/0!
REVENUE $1,924,40~ $2,231,45C $£ $2,231,45( t;0 3.00%
DEPARTMENT TOTALS $1,924,406 $2,231,45(~ $( $2,231,45(
=und: SANITATION FUND I Department: PUBLIC WORKS I Divisien: SANITATION (04~0)
34 60 1002 OVERTIME EARNINGS SA~RIES & BENEFITS ;32848 $35000 ;O $35000 ;O O 00%
--und: EQUIPMENT SERVICES FUND I Department: FINANCE I Division: GARAGE (47-30)
~7 30 /002 OVERTIME EARNINGS }ALARIES & BENEFITS $4859 5000 $2500 ;5000 $0 ~ 00%
~7 30 /007 CAR ALLOWANCE }ALARIES & BENEFITS $0 0 $0 0 $0 ~DIV/0J
~7 30 //20 EMPLOYERS SHARE T M R S }ALARIES & BENEFITS $53 292 49856 $50 /06 58795 $8939 /7 93%
~7 30 //30 INSURANCE EMPLOYEE LIFE }ALARIES & BENEFITS $2/3/ /947 $2096 2049 $/02 5 24%
~ so ms ~su~c~ u~o~ ~s a s~n~s ~o o ~o o ~o ~D~W0~
~7 30 2029 CLOTHIN6 ALLOWANCE }UPPLIES $/634 2559 $2000 2559 $0 ~ 00%
~ so ss~s co~u~ su~u~s ~u~u~s ~o o ~o o ~o ~D~W0~
~7 30 2350 SUPPLIES & MATERIALS }UPPLIES $/7 850 17800 $13000 /5500 ~ ~8U /292%
~7 30 30/0 POSTA6E ~ROFESSIONAL SERVICES $23 0 $0 25 $25 ~DIV/0J
~7 30 3063 PRO6RAMMIN6/MAINTENANCE ~ROFESSIONAL SERVICES $4590 9646 $9646 3430 ~b~b 64 44%
~7 30 4//0 HEAT LI6HT WATER UTIL JTILITIES $19820 17114 $0 17114 $0 } 00%
~7 30 5500 INSURANCE AUTO LIABILITY NSURANCE $/// /// $0 /85 $74 }6 67%
~7 30 6/90 AUTO REPAIRS )UTSlDE SERVICES $/860 3030 $2600 3030 $0 } 00%
~7 30 6200 EQUIP REPAIRS/NON VEHICLE )UTSlDE SERVICES $0 2000 $2509 2000 $0 } 00%
~7 30 7/55 VEHICLE RELATED EXPENSE )THER $0 0 $0 0 $0 ~DIV/0J
~7 30 7202 MICRO COMPUTER SOFTWARE )THER $/546 /700 $/700 3200 $/500 }8 24%
~7 30 7240 TUITION & TRAININ6 )THER $860 2/00 $/800 /425 (~?~ 32/4%
~7 30 7260 EQUIPMENT RENTAL )THER $96 900 $450 900 $0 } 00%
~7 30 9000 CAPITAL EQUIPMENT REPLACE 3APITAL E~ENDITURES $0 6779 $6779 6779 $0 } 00%
~7 30 9//0 RADIO EQUIPMENT 3APITAL E~ENDITURES $0 0 $0 0 $0 ~DIV/0J
~7 30 9575 6ARA6E EQUIPMENT 3APITAL E~ENDITURES $5643 /6500 $16129 //500 ~ /ri 30 30%
~7 30 9985 CAPITALIZED EXPENDITURES 3APITAL E~ENDITURES ~ 5~ ~0 $0 0 $0 ~DIV/0J
SALA~S a B~F~TS $502 ~0 $4n 24c $5~8 5s $568 62c
SUPPLIES $2064 $22299 $/6/0( $/ 2~i ~0'~: /379%
PROFESSIONAL SERVICES $46/ $9886 $976 $5 9
UTILITIES $2259 $19780 $( $1q78 $0 000%
INSURANCE $68 $68a
OUTSIDE SERVICES $/86~ $5030 $5/0 $503C $0 0 00%
OTHER $75865 $8/9~ $746~
CAPITAL BPENDITURES $2~ $25// $24 //~ $1827 ~t840 2723%
BE~E~ ~O~L8 ~1,311,1~ ~6~,~3~ ~81,0~ ~6~6,3~1 $84119 /496%
Filename Overview of FY04 Proposed Budget xls Tab Garage Budget
Last Printed 8//4/20034 26 PM
=und:EQUIPMENTSERVICES FUND I Department:FINANCE I Division: WAREHOUSE (47-34)
iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii~iiiiiiiiiiiiiiiiiiiiiiiiiiiiii~iii~i~iiiiiiiiiiiiiii~iiiiiiiiiiiiiiii~iiiii~i?i ~iiiiii~iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii iiiiiiiiiiiiiii~iiiiiiiiiiiii iiiiiiiiiiiiii~iiiiiiiiiiiii iiiiii~i~iiiii
~7 34 1002 OVERTIME EARNINGS 3A~RIES & BENEFITS $2095 $2 000 ~2OOO $2000
~7 34 I 110 EMPLOYERS SHARE F I C A ~A~RIES & BENEFITS ~9586 $10068 ~ 10068 $10 259
~7 34 1130 INSURANCE EMPLOYEE LIFE ~A~RIES & BENEFITS ~734 $724 ~724 $738
~7 34 1132 INSURANCE UNEMPLOYMENT ~A~RIES & BENEFITS ~0 $0 ~0 $0
~7 34 2029 CLOTHING ALLOWANCE ~UPPLIES ~407 $970 ~900 $970
~7 34 2318 COMPUTER SUPPLIES ~UPPLIES ~0 $150 ~150 $150
~7 34 2350 SUPPLIES & MATERIALS ~UPPLIES ~1 345 $1 020 ~1 020 $1 020
~7 34 2720 GAS OIL & GREASE DEPT 20 ~UPPLIES ~0 $0 ~0 $0
~7 34 2723 GAS OIL & GREASE DEPT 23 ~UPPLIES ~0 $0 ~0 $0
~7 34 2735 GAS OIL & GREASE DEPT 35 ~UPPLIES ~0 $0 ~0 $0
~7 34 2750 GAS OIL & GREASE DEPT 50 ~UPPLIES ~0 $0 ~0 $0
~7 34 2770 GAS OIL & GREASE DEPT 70 ~UPPLIES ~0 $0 ~0 $0
~7 34 3010 POSTAGE :ROFESSIONAL SERVICES ~48 $50 ~120 $50
~7 34 4110 HEAT LIGHT WATER UTIL JTILITIES ~7163 $5 765 ~5765 $5765
~7 34 5500 INSURANCE AUTO LIABILI~ NSURANCE ~55 $55 ~55 $92
~7 34 6190 AUTO REPAIRS )UTSIDE SE~ICES ~1 606 $2494 ~2600 $2600
~7 34 6200 EQUIP REPAIRS/NON VEHICLE )UTSIDE SE~ICES ~1 717 $9100 ~11 962 $9300
~7 34 6703 AUTO REPAIRS DEPT 03 )UTSIDE SE~ICES ~0 $0 ~0 $0
~7 34 6722 AUTO REPAIRS DEPT 22 )UTSIDE SE~ICES ~0 $0 ~0 $0
~7 34 6725 AUTO REPAIRS DEPT 25 )UTSIDE SE~ICES ~0 $0 ~0 $0
~7 34 6740 AUTO REPAIRS DEPT40 )UTSIDE SE~ICES ~0 $0 ~0 $0
~7 34 6760 AUTO REPAIRS DEPT 60 )UTSIDE SE~ICES ~0 $0 ~0 $0
~7 34 6780 AUTO REPAIRS DEPT 80 )UTSIDE SE~ICES ~0 $0 ~0 $0
~7 34 7155 VEHICLE RE~TED EXPENSE )THER ~0 $0 ~0 $0
~7 34 7202 MICRO COMPUTER SOF~ARE )THER ~0 $0 ~0 $1 150
~7 34 7240 TUITION &TRAINING )THER ~0 $750 ~595 $625
~7 34 7260 EQUIPMENT RENTAL )THER ~0 $0 ~0 $0
~7 34 9110 ~DIO EQUIPMENT APITAL EXPENDITURES ~0 $0 ~0 $0
~7 34 9570 WAREHOUSE EQUIPMENT APITAL EXPENDITURES ~2076 $0 ~2290 $0
~7 34 9985 CAPITALIZED EXPENDITURES APITAL EXPENDITURES f; :;:i $0 ~0 $0
SA~RIES & BENEFITS $17303, $175567 $17556 $18349~
SUPPLIES $3 87: $5563 $549: $583
PROFESSIONAL SE~ICES $41 $50 $12[ $348E
UTILITIES $9 42~ $9941 $994 $9941
INSURANCE $25 $251 $25 $21
OUTSIDE SE~ICES $332: $11594 $1456: $1190E
OTHER $374~ $1925 $471; $312~
CAPITAL ~PENDITURES $1 67[ $8074 $1036z $4037
DEPARTMENT TOTALS $195,~T $212,965 $221,01~ $222,~28
--und: EQUIPMENT SERVICES FUND I Department: FINANCE I Division: REVENUES (47-11)
~7 11 3/6/ 02 VEH MAINTENANCE UTIL FUND ~EVENUE 119118 136913 136913 160035 ~23122 1689%
~7 // 3/62 0/ WHSE ALLOCATION GEN FUND ~EVENUE 60264 73100 73100 74097 ~997 I 36%
~7 // 3/62 04 WHSE ALLOCATION SANITATN ~EVENUE 26305 32101 32528 32528 ~427 I 33%
~7 // 3/63 02 VEH REPLACEMENT UTIL FUND ~EVENUE 9/938 85766 85766 87010 ~/244 I 45%
~7 / / 3850 AUCTION/SALE OF EQUIPMENT ~EVENUE 0 55000 0 55000 ~0 ) 00%
~7 // 3908GAIN(LOSS) FIXED ASSETS ~EVENUE 33792 0 0 0 ~0 fDIV/0J
~EVENUE $131887 $156068 $1280846 $1649650
AGENDA MEMO
(08/20/2003 AGENDA)
DATE:
TO:
FROM:
SUBJECT:
August 13, 2003
Honorable Mayor and City Council
Kent R. Austin
Adoption of 2003 Certified Tax Roll
ITEM:
Each year, taxing jurisdictions must officially adopt the tax roll upon which they will
assess property taxes. The Dallas Central Appraisal District (DCAD) performs the
property appraisal function for University Park and other taxing entities in Dallas County.
Property value information for this year and last year is as follows:
2003 2002 % Change
Market value $4,950,370,340 $4,821,440,160 2.67%
Taxable value $3,769,405,331 $3,553,903,488 6.06%
New construction $90,559,748 $92,522,346 -2.17%
The primary reason for the overall taxable value rising faster than the market value is the
release of capped parcels. Last year, the tax roll included 2,717 parcels with a capped
value loss of $206 million. This year, 1,298 parcels with a value of $85 million are
capped. As a result, over $121 million in formerly capped value is now on the tax roll.
RECOMMENDATION:
Staff recommends approval of the resolution adopting the 2003 appraisal roll.
ATTACHMENTS:
· Certification of Appraisal Roll document
· Resolution adopting 2003 appraisal roll
3800 UNIVERSITY BOULEVARD UNIVERSITY PARK, TEXAS 75205 TELEPHONE (214) 363-1644
C:\Documents and Settings~nwilson\Local Settings\Temporary Internet Files\OLK21\Tax roll memo 082003.doc 08/14/03
3:11 PM
CERTIFICATION OF APPRAISAL ROLL
Year: 2003 ~[, ~
Jurisdiction: CITY OF UNIVERSITY PARK
In accordance with the requirements of the Texas Property Tax Code, Chapter 26, Section 26.01,
paragraphs {A) and (B}, the following values are hereby certified:
Market Value of all Real & Bus Pers Prop
Before Qualified Exemptions*
Taxable Value of all Real & Bus Pets Prop
After Qualified Exemptions
$4,950,370,340
$3,769,405,331
In accordance with the requirements of the Texas Property Tax Code, Chapter 26, Section 26.01,
paragraph (C}, the following values are hereby certified as disputed values and are not included
in the above totals:
Values under protest as
determined by the Appraisal
District
Market Value
$4,977,160
Market Value
$3,732~869
Taxable Value
54,643,406
Taxable Value
$3,513,096
Values under protest as
c~aimed by property owner
or estimated by Appraisal
District in event property
owner's claim is upheld
I, Foy Mitchell, Jr., Director/Chief Appraiser of the Dallas Central Appraisal District, do hereby
certify the aforementioned values and totals to the taxing jurisdiction indicated above, in
accordance with the requirements of the laws of the State of Texas.
Dallas Central Appraisal District
Witnessed this 25th day of Jul~7'~003.
)~',ssmnEx;,mNotary Public, Dallas County, Texas
*Total Value of New Construction $90,559,748
{Included in Certified Market Value above)
2949 N. Stemmons Freeway, Dallas, Texas 75247-6195 (214) 631-0520
CER1 7/C2
RESOLUTION NO.
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF UNIVERSITY
PARK, TEXAS, ADOPTING THE 2003 APPRAISAL ROLL OF THE DALLAS
CENTRAL APPRAISAL DISTRICT FOR THE CITY; AND PROVIDING AN
EFFECTIVE DATE.
WHEREAS, the City's assessor and collector of taxes has submitted to the City
Council the 2003 tax appraisal roll compiled by the Dallas Central Appraisal District; and
WHEREAS, the City Council is of the opinion that the 2003 appraisal roll should
be approved and adopted;
NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF
THE CITY OF UNIVERSITY PARK, TEXAS:
SECTION 1. That the 2003 appraisal roll for the City of University Park, as
presented by the Dallas Central Appraisal District, be, and the same is hereby, approved
and adopted in all respects showing a total appraised property value of $4,950,370,340,
new property added to the tax roll of a taxable value of $90,559,748, and a total taxable
value of property, after exemptions, for 2003 of $3,769,405,331.
SECTION 2. This Resolution shall take effect immediately from and after its
passage, and it is accordingly so resolved.
DULY PASSED by the City Council of the City of University Park, Texas, on the
day of ,2003.
APPROVED:
APPROVED AS TO FORM:
HAROLD PEEK, MAYOR
ATTEST:
CITY ATTORNEY
NINA WILSON, CITY SECRETARY
49776
AGENDA MEMO
(08 -20 -03 AG E N DA)
DATE:
TO:
FROM:
SUBJECT:
August 14, 2003
Bob Livingston
City Manager
Gene R. Smallwood, P.E.
Director of Public Works
Consider bids received for in-place recycling of asphalt pavements
along various City streets.
Backg round.
and the newspaper regarding in-place
following streets:
STREET FROM TO
Amherst Airline Durham
Baedeker Southwestern Hanover
Bryn Mawr Airline Baedeker
Douglas University Lovers Lane
Granada Hillcrest High School
Grassmere Preston Westchester
Hillcrest Caruth NW Hwy
Hyer Preston Westchester
Key Granada Binkley
Lovers Lane Douglas Preston
Normandy Armstrong Lovers Lane
Purdue Durham Hillcrest
Shenandoah Douglas Toll Road
Southwestern Hillcrest Baedeker
A solicitation for bid notice was sent to contractors, plan rooms,
recycling of asphalt pavement for the
Stanford Hillcrest Airline
Stanhope Armstrong Lomo Alto
University Preston Toll Road
Vassar Turtle Creek Blvd (intersection)
Westchester Emerson Grassmere
Windsor Preston Lomo Alto
Similar to recent years, only one bid was received from Cutler-Repaving from
Lawrence, Kansas. Cutler's bid for the above-referenced work was $311,671.25. In
addition to the amount of the bid, the specifications call for the City to provide the
asphalt used by the contractor. Using the current annual contract the City has with
Austin Paving at $27 per ton, the additional cost for asphalt would be $123,849.
Therefore, the total cost of the project presented for City Council approval is
$435,520.25
Recommendation. Staff recommends City Council approval of the bid of Cutler-
Repaving in the amount of $311,671.25, and authorize staff to expend $123,849 to
purchase asphalt for the project.
AGENDA MEMO
(08 -20 -03 AG E N DA)
DATE:
TO:
FROM:
SUBJECT:
August 14, 2003
Bob Livingston
City Manager
Gene R. Smallwood, P.E.
Director of Public Works
Consider Interlocal Agreement with the City of Dallas for the
reconstruction of Lovers Lane, from Boedeker east to Willard.
Background. Pursuant to recent City Council action at their 08-05-03 meeting
to authorize the design of Lovers Lane, Hillcrest east to Willard, the attached
interlocal agreement (ILA) with the City of Dallas provides for University Park to
furnish design and construction administration services for the entire project.
Furthermore, the ILA details financial responsibilities for the work. Generally,
University Park, in administering both the design and construction contracts, will pay
the engineering consultant and subsequently the contractor and Dallas will
reimburse University Park for their share of those costs.
The City Attorney has reviewed the ILA, and his comments have been incorporated
into the attached document.
Recommendation. Staff recommends City Council approval of the interlocal
agreement with the City of Dallas.
INTERLOCAL AGREEMENT
BETWEEN THE CITY OF UNIVERSITY PARK AND THE CITY OF DALLAS
FOR CONSTRUCTION OF PAVING IMPROVEMENTS ON LOVERS LANE
FROM BOEDEKER STREET TO 100' E. OF WILLARD DRIVE
WHEREAS, the City of University Park, Texas ("University Park") and the City of
Dallas ("Dallas") desire to enter into an agreement for the construction of paving
improvements on Lovers Lane from Boedeker Street to 100' east of Willard Drive in
Dallas County, Texas (the "Project"); and
WHEREAS, the Interlocal Cooperation Act (Texas Government Code, Chapter
791, as amended) authorizes any local government to contract with one or more
governments to perform governmental functions and services under the terms of the
Act; and
WHEREAS, University Park and Dallas have determined that the improvements
may be most economically implemented by this Agreement.
NOW, THEREFORE, in consideration of mutual promises, covenants and
conditions contained herein, this Agreement is made and entered into by University
Park and Dallas as follows:
WITNESSETH:
ARTICLE
University Park shall, through its design consultant, prepare plans and
specifications, advertise, and bid improvements needed for the Project. Dallas agrees
to fund its share of the design cost in an amount not to exceed $34,000, based on the
design fee proposed by the consultant for that portion of the improvements lying within
Dallas. Dallas, acting through its Department of Public Works and Transportation, shall
review and approve plans and specifications for Dallas prior to University Park's
contractor beginning work on the portion of the Project located in Dallas. University Park
shall coordinate plans, specifications, language, and standards with Dallas prior to
advertising the Project to accommodate the parties' needs.
Town of Universit~ Park - Interlocal Agreement
1
ARTICLE II.
No additional right-of-way will be required to complete the Project. All work will be
performed within the existing right-of-way of the Project owned by University Park and
Dallas.
ARTICLE III.
University Park shall bid and award a contract to construct the improvements and
administer the construction contract for the Project. Dallas, acting through its
Department of Public Works and Transportation staff, will review and approve the bid
amount for the paving improvements to the portion of the Project located within Dallas.
If Dallas does not approve the above mentioned bid amount, University Park agrees not
to include the paving improvements located in Dallas in the contract award.
In addition, Dallas, acting through its Department of Public Works and
Transportation staff, shall provide inspection of the paving improvements. In all such
activities, Dallas and University Park shall comply with all state statutory requirements.
The construction of the Project shall include, but not be limited to, pay items and unit
costs, materials testing, inspection and construction engineering, and contingencies.
ARTICLE
The total estimated design cost for that portion of the improvements lying within
Dallas is $34,000. The total estimated cost of the paving improvements within and/or
on Dallas' portion of the Project, including but not limited to removal of existing
pavement, subgrade stabilization, construction of 9" concrete pavement with curb,
gutter, and sidewalks, inlets, and other items necessary to complete the work, is
$845,837. Dallas agrees to fund both the design and the construction of the paving
improvements for the portion of the Project within and/or in Dallas in an amount not to
exceed $879,837 (hereinafter, the "Not to Exceed Amount").
In those instances where Dallas has approved the bid amount for the paving
improvements to the portion of the Project located within Dallas, Dallas shall remit to
University Park its share of the design funding and the construction funding within thirty
(30) days after notice from University Park that University Park intends to award the
construction contract for the Project.
In the event that the cost of the paving improvements causes the sum of the
design and construction costs to exceed the Not to Exceed Amount, Dallas and
Town of Universit~ Park - Interlocal Agreement
2
University Park agree to either reduce the scope of construction or obtain additional
funding to complete the work. In the event additional funds are needed for additional~
agreed upon work, University Park will bill Dallas, who agrees to pay such additional
funds within thirty (30) days after receipt of such billing and approval of the funding by
the Dallas City Council.
If University Park determines during construction that there is a need for a
plan/specification revision or for any other type of change order to the construction
contract, University Park shall submit the proposed revisions or changes to Dallas for
review and approval prior to issuing a change order or other directive to the construction
contractor. Dallas shall also notify University Park of any changes Dallas wants made
to the Project scope of work or the plans and specifications.
Following completion of the Project, University Park shall provide to Dallas a final
accounting of expenditures for the Project. Any funding provided by Dallas that remains
unspent at the final completion of the Project shall be returned to Dallas within sixty (60)
days after completion of the final accounting.
ARTICLE V.
University Park shall prepare for Dallas an itemized statement specifying the
Project costs that have been incurred to date and shall submit to Dallas detailed Project
cost and progress reports every thirty (30) days until the Project is complete.
ARTICLE
University Park and Dallas agree that the party paying for the performance of
governmental functions or services shall make those payments only from current
revenues legally available to the paying party.
ARTICLE
To the extent allowed by law, and without waiving any governmental immunity
available to the parties under Texas law, or any other defense the parties are able to
assert under Texas law, Dallas and University Park each agree to be responsible for its
own negligent or otherwise tortuous acts or omissions in the course of performance of
this Agreement. Nothing in this Agreement shall be construed as creating a joint
enterprise, partnership or joint venture between the parties.
Town of Universit~ Park - Interlocal Agreement
3
ARTICLE VIII.
The laws and court decisions of the State of Texas shall govern the
interpretation, validity, performance and enforcement of this Agreement. The parties
agree that this Agreement is performable in Dallas County, Texas, and that exclusive
venue for any action to enforce this Agreement shall lie in Dallas County, Texas.
ARTICLE IX.
The provisions of this Agreement are severable. If any paragraph, section,
subdivision, sentence, clause, or phrase of this Agreement is for any reason held by a
court of competent jurisdiction to be contrary to law or contrary to any rule of regulation
having the force and effect of the law, the remaining portions of the Agreement shall be
enforced as if the invalid provision had never been included.
ARTICLE X.
This Agreement embodies the entire agreement between the parties,
superseding any oral or written prior or contemporaneous agreements or
understandings, and may only be modified in writing by a supplemental agreement
executed by both parties.
ARTICLE
This Agreement shall be binding upon the parties hereto, their successors and
assigns. Neither party will assign or transfer an interest in this Agreement without the
written consent of the other party.
ARTICLE
It is expressly understood and agreed that, in the execution of this Agreement,
neither party waives, nor shall be deemed hereby to have waived any immunity or
defense that would otherwise be available to it against claims arising in the exercise of
governmental powers and functions. By entering into this Agreement, the parties do not
create any obligations, express or implied, other than those set forth herein, and this
Town of Universit~ Park - Interlocal Agreement
4
Agreement shall not create any rights in any persons or entities who are not parties to
this Agreement.
ARTICLE Xlll.
This Agreement shall be effective upon execution by both parties and shall
continue in effect until final acceptance of the Project.
EXECUTED as of the__ day of
University Park Council Action, dated
the City of Dallas Council Resolution No.
, pursuant to the City of
, __ and
, dated
APPROVED AS TO FORM:
Robert L. Dillard III
City Attorney
CITY OF UNIVERSITY PARK
Harold Peek
Mayor
By:
City Attorney
By:
Mayor
APPROVED AS TO FORM:
MADELEINE B. JOHNSON
City Attorney
CITY OF DALLAS
TEODORO J. BENAVlDES
City Manager
By:
Assistant City Attorney
By:
Assistant City Manager
Town of Universit~ Park - Interlocal Agreement
5
MEMORANDUM
DATE:
TO:
FROM:
SUBJECT:
August 14, 2003
Honorable Mayor and Members of the City Council
Bob Livingston, City Manager
Continuation of Discussion Regarding Pay and Display Parking
At the July 16th the City Council directed staff to investigate alternatives regarding "pay
and display" parking for commercial areas in the City. Toward that end staff has been
accumulating information regarding equipment cost as well as other information regarding
this issue. Based on the Council's direction we intended to have a public meeting with
property owners and merchants in these commercial areas sometime during the month of
September.
Several members of the Council, and others, have mentioned receiving negative comments
regarding even considering this alternative. Because of this, I thought it might be wise to
discuss the item further before proceeding with additional staff work necessary to prepare
the presentation for the meeting.
If you have questions, please let me know.
3800 UNIVERSITY BOULEVARD UNIVERSITY PARK, TEXAS 75205 TELEPHONE (214) 363-1644
C:\Documents and Settings~nwilson\Local Settings\Temporary Internet Files\OLK21\SNIDERPKG081303.doc 3:20 PM 08/14
AGENDA MEMO
(08 -20 -03 AG E N DA)
DATE:
TO:
FROM:
SUBJECT:
August 14, 2003
Bob Livingston
City Manager
Gene R. Smallwood, P.E.
Director of Public Works
Review realignment of Caruth - Turtle Creek Blvd intersection.
Background. Working recently with the adjacent property owner at the
northwest corner of the above-referenced intersection, City staff was trying to install
a handicap accessible ramp. The construction opportunity was to get positive
drainage at the corner, which for years has had standing water. Engineering Division
staff developed a realignment of the north leg of the intersection that solves the
drainage problem and allows for the installation of the handicap ramp. The design
solution does significantly reduce the width of the southbound approach, which will
also more clearly define the travel lanes. The attached drawing delineates the
proposed alignment for Council's consideration.
We would ask Council to authorize a change order in the amount of $44,853.75 to
the contract with Ken-do Construction for the aforementioned work. On a related
matter, staff will present another change order to Ken-Do's contract in September to
adjust the scope of work on the remainder of the project to coincide with the
authorized budget.
Recommendation. Staff recommends City Council approval of the change to Ken-
Do's contract for additional work at the intersection of Caruth and Turtle Creek Blvd.