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 Purchasing

 

 

DATE OF MEETING:

February 6, 2006

 

 

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 Equipmentbe 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 Purchasing Department’s account 410-434-4299.

 

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 Purchasing Card (AMEX) spending trend in 2004, it was determined that numerous suppliers were being used for the purchase of hardware items, tools and equipment with little or no price negotiations.  For the purpose of this report, “Hardware” means the commonly ordered commodities such as:  batteries, yard tools, hand tools, power tools, locks, wrenches, connectors, bulbs, gloves etc.

 

Analysis on 2004 Purchasing Card Records

The analysis of the 2004 (AMEX) Purchasing Card records indicated that the approximate annual amount spent on hardware items purchased from major retail outlets such as Home Depot, Canadian Tire, Concord Hardware etc. was approximately $375,000, consisting of approximately 33 commodity groups.

 

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) Purchasing Card activities indicated that 40 different staff make approximately 1900 trips to 25 different retail suppliers annually to purchase hardware, tools and equipment.  It was concluded that a consolidated contract for the supply and delivery of these products would lead to standardization which will reduce administrative costs such as invoicing, shipping and handling and staff travel.  It will also improve staff productivity.

 

BID INFORMATION:

Advertised, place and date

Electronic Tendering Network ,  March 09, 2005

Bids closed on

March 23, 2005

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 Purchasing Department.  Stage One was evaluated based on predetermined evaluation as listed in the RFP with results illustrated in Table A.  

 

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
Table A

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 Markham on Shields Court.

 

 

Purchasing staff has verified the bid documents for accuracy and compliance with the RFP specifications and terms and conditions.

 

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 Purchasing staff in negotiating lower prices based on bulk purchasing and standardization of product.

 

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 Purchasing departments $200,000 target as a permanent reduction to the Operating Budget from account 410-434-4299.

 

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

                                   

                         
_______________________________________________________

           Jim Sales, Commissioner, Community and Fire Services Commission

 

 

 

 

 

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

             -  

Markham Village Recreation Area

500 3995414

67,000

5,003

Markham Village Recreation Area

503 1675414

6,700

500

Markham Village Recreation Area

503 9125414

6,000

448

Markham Village Recreation Area

503 9225414

20,400

1,523

Markham Village Recreation Area

503 9235414

17,500

1,307

Markham Village Recreation Area

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

Subtotal Museum

 

$24,800

$1,799

GRAND TOTAL

 

 

$90,000