‘ |
Report
to General Committee - Finance and Administrative |
|
|
|
|
TO: |
Mayor and Members of Council |
|
|
FROM: |
Peter Loukes,
Director of Operations and Asset Management Barb Roth,
Director of Recreation and Cultural Services |
|
|
PREPARED BY: |
Joel Lustig, Director , Financial
and Client Services Kevin Newson, Manager of |
|
|
DATE OF MEETING: |
|
|
|
SUBJECT: |
RFP Award #066-R-05 Supply and Delivery of Hardware,
Tools and Equipment |
|
|
RECOMMENDATION:
THAT the report entitled “RFP Award #066-R-05
Supply and Delivery of Hardware, Tools and Equipment” be received;
AND THAT the contract for RFP 066-R-05
Supply and Delivery of Hardware, Tools and Equipment be awarded to the highest ranked and lowest priced proponent,
Acklands Grainger Inc. in the estimated annual amount of $375,000 exclusive of
GST for a period of 1 (ONE) year with an option to renew for an additional 2 (TWO)
years under the same terms and conditions at the sole discretion of the Town;
And that funding for this
contract be provided from facility maintenance accounts in the Operations and
Recreation & Culture departments;
And that projected cost
savings in the amount of $90,000 be removed from the 2006 Operating Budget
accounts identified in Appendix A with the corresponding offset in the
PURPOSE:
To obtain Council approval to award contract RFP
066-R-05, Supply and Delivery of Hardware, Tools and Equipment. This contract will streamline the procurement
activities of various departments by centralizing the supply and delivery of these items. This would lead to savings based on negotiated
bulk purchase and the ability to monitor spending activities through custom
built reports. Further, this contract
will reduce staff time spent on travelling to numerous retail locations and will ultimately lead to
product standardization.
BACKGROUND:
This
project is initiated from CSI (Core Services Implementation) as part of the
revenue strategy. Based on an analysis
of the Town’s
Analysis on 2004
The analysis of the 2004 (AMEX)
Creation of the
RFP Document and Determination of Savings
The 33 commodity groups were used for
quoting purposes in the RFP. These groups
were selected based on the most commonly ordered items from the 2004 purchasing
card records. They were grouped into
specific categories such as key locks, batteries, hand tools, yard tools
etc. The RFP also required that each
category be assigned a discount structure to ensure firm pricing.
Proposed Ordering
Process
Under the new contract with Acklands Grainger,
staff have the option of either having items delivered to Miller Avenue Store
Location or to pick up orders from Acklands Grainger’s new facility near Miller
Avenue, thereby eliminating unproductive Staff Hours. It should be noted that there is no charge
for next day delivery.
Benefits
The current method of procurement does not
permit volume discounts and product standardization. This contract will allow the standardization
of products and thus provide the opportunity for staff to negotiate volume
discount for bulk purchasing at the time of renewal. The final result will be consistency in terms of quality, service and
price.
Further, under the current system, the
Town is unable to track product descriptions and usage patterns, reducing the Town’s
ability to budget and forecast inventory. Acklands Grainger will provide customized reports
permitting staff to track purchases by dollar value, commodity type and spending
trend. This will assist in improving inventory
turnover allowing Town staff to manage resources.
An analysis of the 2004 (AMEX)
Advertised,
place and date |
Electronic
Tendering Network , |
Bids
closed on |
|
Number
picking up bid documents |
6 |
Number
responding to bid |
3* |
* ONE bid was disqualified for not meeting
the mandatory criteria.
RFP EVALUATION PROCESS
The
RFP was evaluated in a two stage process by staff from Recreation and Cultural
Services, Operations and Asset Management Department and
Stage
Two comprised of a presentation by the two proponents to the Evaluation Team
with results listed in Table B.
PRICES ANALYSIS
A price comparison of the current pricing from the 25 different
retail suppliers with the lowest priced bidder, Acklands Grainger Inc.
indicated an annual savings of approximately 24%.
Considering
the total annual purchase of hardware, tools and equipment to be $375,000 in
2004, it can be estimated that a net annual savings of $90,000 (24% of
$375,000) can be achieved by the award of this contract.
DETAILED EVALUATION INFORMATION
as submitted:
RFP
Evaluation Criteria |
Weight |
Acklands |
Guillevin |
1.
Product Details |
30% |
25.3% |
23% |
2. Management Reporting Tools |
25% |
25% |
25% |
3. Pricing Indication |
30% |
30% |
28.8% |
4. Consulting Services – Inventory Mgmt.
Techniques |
10% |
10% |
10% |
5.
Value Added Services |
5% |
3.3% |
2.6% |
Grand
Total of Stage One |
100% |
93.6% |
89.6% |
Presentation Evaluation
Criteria Table B |
Weight |
Acklands |
Guillevin |
1. Ability to provide reporting information
to monitor spending trends |
5% |
4% |
4% |
2. Willingness to work with the Town to
improve buying processes and
procedures |
5% |
4.1% |
3.8% |
3. Ability to stock items and provide ad-hoc
services as specified by the users |
5% |
3.6% |
3.5% |
4. Ability to provide solutions towards a
continuous improvement program |
5% |
3.6% |
3.8% |
5. Willingness to reduce overall costs to the
organization |
5% |
3.9% |
3.8% |
6. Overall Ability to meet the requirements
of the Town in a timely fashion |
5% |
3.7% |
3.5% |
Grand Total of Stage Two |
30% |
22.9% |
22.4% |
Based on the analysis of the evaluation criterion as
mentioned in both Table A and B, it was determined that Acklands Grainger Inc. was
the highest ranked and the lowest priced proponent. It should be noted that Acklands
Grainger Inc. is located in
MONITORING THE CONTRACT AND NEXT STEPS
With
the award of this contract and the availability of customized report, staff
will be able to analyze spending trends.
In addition, reports will assist
Within
a year, based on the data accumulated, staff will determine if the introduction
of a centralized store operation (where commonly used items will be
inventoried) will assist in complimenting this initiative and further reduce
costs.
FINANCIAL CONSIDERATIONS:
Funding for this contract in
the estimated annual amount of $375,000 exclusive of GST will be provided from
facility maintenance accounts in the Operations and Recreation & Culture
departments.
In the 2004 Budget, a
purchasing analyst position was approved with a targeted savings of $200,000 to
be achieved from contract review/renegotiation, consolidation of purchases, and
the centralizing of the supply and delivery of hardware, tools, and
equipment. As a result of this
initiative, $90,000 of budget reductions can be made in the 2006 Operating Budget
(see Appendix A). The $90,000 will be
reduced from the
ATTACHMENT: Appendix A – 2006 Operating Budget
APPROVED BY:
________________________________________________________________
Peter
Loukes, P. Eng. Director, Operations and Asset Management
______________________________________________________
Barbara Roth, R.D.M.R., Director
of Recreation & Culture Services
_______________________________________________________
Q:\Finance
and Administration\Finance\Purchasing\2005 File Management\Contract
Management\066-R-05 Hardware, Tools & Equipment\066-R-05 Award Report.doc
RFP
066-R-05 Supply and Delivery of Hardware, Tools and Equipment
Appendix A – 2006 Operating Budget
Operations Department
Department
Name |
Full
Account |
Sum of Annual Budget |
Allocation |
Asset Management |
750 7504500 |
2,330 |
366 |
Asset Management |
750 7505410 |
0 |
- |
Asset Management |
750 7515410 |
19,515 |
3,069 |
Asset Management |
750 7515499 |
58,266 |
9,162 |
Fleet |
750 7534261 |
1,553 |
244 |
Fleet |
750 7524292 |
5,783 |
909 |
Fleet |
750 7524330 |
14,854 |
2,336 |
Fleet |
750 7524339 |
0 |
- |
Fleet |
750 7534339 |
7,767 |
1,221 |
Fleet |
750 7535410 |
30,097 |
4,732 |
Operations Admin |
700 9984261 |
728 |
114 |
Operations Admin |
700 9984299 |
4,369 |
687 |
Operations Admin |
700 9984500 |
2,913 |
458 |
Operations Admin |
700 9984501 |
11,262 |
1,771 |
Parks |
730 9984261 |
17,233 |
2,710 |
Parks |
730 7354292 |
99 |
16 |
Parks |
730 7314339 |
3,155 |
496 |
Parks |
730 7324339 |
6,796 |
1,069 |
Parks |
730 7344339 |
9,709 |
1,527 |
Parks |
730 7394339 |
28,544 |
4,488 |
Parks |
730 7434339 |
27,476 |
4,320 |
Parks |
730 7314420 |
485 |
76 |
Parks |
730 7354420 |
4,369 |
687 |
Parks |
730 7434501 |
6,311 |
992 |
Parks |
730 7435414 |
66,990 |
10,534 |
Roads |
700 5024292 |
876 |
138 |
Roads |
700 5014291 |
0 |
- |
Roads |
700 5074291 |
9,612 |
1,511 |
Roads |
700 5054500 |
0 |
- |
Roads |
700 5044501 |
2,330 |
366 |
Roads |
700 5054501 |
0 |
-
|
Operations
Subtotal |
|
$343,422 |
$53,999 |
RFP
066-R-05 Supply and Delivery of Hardware, Tools and Equipment
Appendix A – 2006 Operating Budget
Recreation and Culture Services
Department
Name |
Full
Account |
Sum of Annual Budget |
Allocation |
Department Support |
500 9985414 |
0 |
- |
|
500 3995414 |
67,000 |
5,003 |
|
503 1675414 |
6,700 |
500 |
|
503 9125414 |
6,000 |
448 |
|
503 9225414 |
20,400 |
1,523 |
|
503 9235414 |
17,500 |
1,307 |
|
503 9715414 |
5,750 |
429 |
Milliken Recreation |
500 2995414 |
68,800 |
5,137 |
Milliken Recreation |
502 9115414 |
25,000 |
1,867 |
Milliken Recreation |
502 9225414 |
21,575 |
1,611 |
Milliken Recreation |
502 9235414 |
11,000 |
821 |
Milliken Recreation |
502 9715414 |
17,500 |
1,307 |
Milliken Recreation |
503 9135414 |
6,925 |
517 |
Milliken Recreation |
503 9725414 |
17,563 |
1,311 |
Thornhill Recreation |
501 9115414 |
186,019 |
|
Thornhill Recreation |
501 9125414 |
500 |
37 |
Thornhill Recreation |
501 9215414 |
45,400 |
3,390 |
Thornhill Recreation |
501 9225414 |
13,500 |
1,008 |
Thornhill Recreation |
501 9515414 |
26,950 |
2,012 |
Thornhill Recreation |
501 9715414 |
1,500 |
112 |
Unionville Recreation Area |
500 2705414 |
3,948 |
295 |
Unionville Recreation Area |
500 2715414 |
3,550 |
265 |
Unionville Recreation Area |
500 2725414 |
4,400 |
329 |
Unionville Recreation Area |
500 2735414 |
5,000 |
373 |
Unionville Recreation Area |
502 9725414 |
1,650 |
123 |
Unionville Recreation Area |
504 9115414 |
15,000 |
1,120 |
Unionville Recreation Area |
504 9215414 |
44,900 |
3,353 |
Subtotal |
|
644,030 |
34,200 |
Less Thornhill Recreation |
501 9115414 |
186,019 |
|
Recreation
Subtotal |
|
$458,011 |
$34,202 |
Markham Museum
Museum |
520 5204241 |
6,000 |
435 |
|
520 9984241 |
1,500 |
109 |
|
520 5205414 |
7,250 |
526 |
|
520 9985414 |
10,050 |
729 |
|
|
$24,800 |
$1,799 |
GRAND TOTAL |
|
|
$90,000 |