Regional Contracting
August 2011

APPENDIX A – CONTEXTUAL INFORMATION

Overview of Activity for Service Contracts in British Columbia, Prairie, and Quebec Regions.

All tables show values for service contracts, which do not include expert witnesses and Crown agents, as they have been excluded from the scope.

• Table 1 shows the contracting selection method and type of contract used in the three regions, during fiscal years 2007-08 and 2008-09 and the number of contracts.
• Table 2 illustrates the contracting activity in each region’s major organizations by contract value and volume.
• Table 3 shows the amount of contracting activity by dollar range.
• Table 4 shows the amount of contracting activity by General Ledger account for service contracts over $2,000.
• Table 5  shows lines of coding and amounts spent in all three regions for legal services expenditures.

Table 1

Service Contracts for British Columbia, Prairie, and Quebec Regions
Stratified by Tendering and Type of Contract
For Fiscal Years 2007-08 and 2008-09

Type of Contracts	Amount Awarded ($)						Number of Contracts
	BC	Prairie	Quebec	Total	2007-08	2008-09
Total Contracts	1,960,819	2,477,690	1,478,295	5,916,804	3,018,622	2,898,182	1,545
Contracts coded as being competitively awarded
Call-up	632,190	854,137	506,432	1,992,759	1,092,977	899,782	233
ACAN		6,743		6,743	6,743		1
Printing	5,081	315,585		320,666	164,942	155,724	95
Purchase Order (Goods)	55	254,328	34,716	289,099	116,752	172,347	205
Service Contract	205,262	541,364	109,709	856,335	436,301	420,034	114
Supply Arrangement	592	7,875	83,538	92,004	5,817	86,187	5
Task Authorization	3,904	18,156		22,060	1,486	20,574	5
Total Competitive	847,083	1,998,188	734,395	3,579,666	1,825,018	1,754,648	658
Contracts coded as being non-competitively awarded
Call-up	137,599	6,803	22,670	167,072	11,516	155,556	25
Printing	22,287	30,315		52,602	50,092	2,510	17
Purchase Orders (Goods)	427,852	101,481	296,973	826,307	390,479	435,828	651
Service Contract	512,974	340,903	335,700	1,189,577	707,692	481,885	187
Supply Arrangement	13,023		88,557	101,580	33,825	67,755	7
Total Non-Competitive	1,113,735	479,503	743,900	2,337,138	1,193,604	1,143,534	887

The British Columbia figures contain 87 British Columbia contracts worth $328,827 that were not awarded or managed from the British Columbia Regional Office.

Table 2

British Columbia, Prairie, and Quebec Regions

Organization	Number of Contracts	Amount Awarded ($)
British Columbia, Prairie, and Quebec Regions Awarded Service Contracts Total	1545	5,916,804
British Columbia Service Contracts
British Columbia Regional Office Service Contracts
CORPORATE SERVICES GROUP	125	521,180
CORPORATE SERVICES – OFFICE ACCOMODATIONS	105	425,619
ABORIGINAL	41	240,473
REGIONAL DIRECTOR GENERAL'S OFFICE	34	202,657
BUSINESS & REGULATORY	18	125,008
TAX	11	42,806
HUMAN RESOURCES	12	28,605
CITIZENSHIP & IMMIGRATION	6	16,954
Total	352	1,603,303
Other British Columbia Service Contracts
INDIAN & NORTHERN AFFAIRS, LSU	64	211,153
BUSINESS CENTRE	17	116,504
OFFICE OF THE NORTHERN REGION	16	67,128
YUKON REGIONAL OFFICE	6	22,777
Total	103	417,562
TOTAL	455	2,020,865
Prairie Region Service Contracts
TAX LITIGATION – EDMONTON	78	562,801
ABORIGINAL AFFAIRS – EDMONTON	83	350,400
WINNIPEG REGIONAL OFFICE	50	343,036
EDMONTON REGIONAL OFFICE	64	267,616
IMS PRAIRIE REGION	30	213,139
SASKATOON REGIONAL OFFICE	66	172,551
REGULATORY AND BUSINESS – EDMONTON	75	162,377
CALGARY OFFICE	38	77,280
CITIZENSHIP, IMMIGRATION & PUBLIC SAFETY	31	66,830
HUMAN RESOURCES POLICY & PLANNING	2	40,410
ABORIGINAL LITIGATION STRATEGY	10	34,806
HUMAN RESOURCES	11	33,915
INFORMATION TECHNOLOGY	5	24,450
PRAIRIE REGION – Other	10	22,723
COMMUNICATIONS – PRAIRIE REGION	10	14,067
FINANCE & ADMINISTRATION – PRAIRIE REGION	4	11,126
ABORIGINAL LAW SECTION – LITIGATION	2	10,970
NORTH WEST TERRITORY REGIONAL OFFICE	6	5,189
NUNAVUT REGIONAL OFFICE	2	3,076
INFORMAL CONFLICT MANAGEMENT SERVICE	1	882
TOTAL	578	2,417,644
Quebec Regional Office Service Contracts
REGIONAL CORPORATE SERVICES DIRECTORATE	109	778,956
COMMERCIAL LAW & REGULATORY LAW PORTFOLIO	152	263,362
TAX LAW PORTFOLIO	120	199,178
REGIONAL DIRECTOR'S OFFICE	73	121,103
IMMIGRATION PORTFOLIO	37	63,086
ABORIGINAL LAW PORTFOLIO	12	34,277
TAX LAW SERVICES	1	6,339
EXTRADITION LAW GROUP	4	4,998
JUSTICE PORTFOLIO	3	4,555
TECHNOLOGY SERVICES DIVISION	1	2,441
TOTAL	512	1,478,295

Notes:

1. Discrepancies exist between the regional totals in Table 1 and Table 2, as some contracting activity initiated in the British Columbia and Prairie regions was coded to organizations in the other region.
2. The Citizenship and Immigration Section in the BCRO was changed to the Public Safety, Defence and Immigration Section in 2009.

Table 3

British Columbia, Prairie, and Quebec Regions
Service Contracts Stratified by Dollar Value

Dollar Range	2007-08				2008-09
	Number of Contracts	Contracts (%)	Final Contract Amounts (%)	Total Final Contract Amounts ($)	Number of Contracts	Contracts (%)	Final Contract Amounts (%)	Total Final Contract Amounts ($)
0 – 1,999	348	51.6	9.3	279,753	536	61.5	13.1	379,915
2,000 – 2,999	72	10.7	6.1	182,741	77	8.8	6.6	190,497
3,000 – 3,999	52	7.7	6.1	184,530	69	7.9	8.1	235,868
4,000 – 4,999	35	5.2	5.1	153,800	40	4.6	6.2	179,740
5,000 – 5,999	27	4.0	4.9	146,787	35	4.0	6.6	190,304
6,000 – 6,999	12	1.8	2.6	77,567	12	1.4	2.7	77,639
7,000 – 7,999	12	1.8	3.0	89,586	10	1.1	2.6	76,283
8,000 – 8,999	12	1.8	3.4	103,203	14	1.6	4.1	118,848
9,000 – 10,000	36	5.3	11.6	349,419	12	1.4	4.0	115,210
> 10,000	68	10.1	48.1	1,451,261	66	7.6	46.0	1,333,853
Total	674	100	100	3,018,647	871	100	100	2,888,157
0 – 1,999	348	51.6	9.7	279,753	536	61.5	13.1	379,915
> 2,000	326	48.4	90.3	2,738,894	335	38.5	86.9	2,518,242
Total	674	100	100	3,018,647	871	100	100	2,898,157

Contracts over $2,000 were part of the population sampled. Of the 661 contracts over $2,000, one was an ACAN, which was also excluded from the sample.

Table 4

British Columbia, Prairie, and Quebec Regions
Service Contracts over $2,000 Stratified by General Ledger Account

GL Description	Amount Awarded ($)
	BC	Prairie	Quebec	Total
Total	1,813,152	2,216,370	1,220,871	5,250,392
Rental of Photocopiers	179,923	241,625	170,061	591,610
Temporary Office Assistance	164,701	260,647	122,903	548,252
Court Reporters	24,981	350,370	85,462	460,813
Printing	20,534	375,166	34,628	430,328
Other Prof. Services < 100,000/YR	81,980	35,052	193,441	310,472
Local Moving Services	176,563	78,519	4,982	260,064
On-Line Enquiry		213,167		213,167
Training Second Language	41,584	7,434	162,660	211,678
Training Consultants	140,249	33,717		173,966
Warehousing Services	161,927			161,927
Transcripts	127,362	20,149		147,511
Commissionaires	48,690	2,926	62,420	114,036
Data Preparation	99,887	12,900		112,788
Other Health Services	16,450	52,670	43,300	112,420
Translation Services	14,638	28,470	60,557	103,666
Sheriff/Bailiff		100,848		100,848
Maintenance Bldg - General	22,925	67,663		90,588
Training & Development for Staff	34,802		55,383	90,185
Repairs & Maint. Furniture & Furnishing	85,932			85,932
Rental of Space	26,867	10,079	42,286	79,233
Image/Video Equipment > 10K	31,155	32,029	10,515	73,698
Paper Recycling Service	48,811	13,500		62,310
Repairs & Maintenance Computer Equipment	33,375	21,200	7,228	61,804
Image/Video Equipment < 10K	28,993	27,471		56,464
Non-Professional Services Contracts	18,494	19,998	8,505	46,997
Professional Opinions & Advice	41,539			41,539
Other Services Not Elsewhere Specified		36,826		36,826
Accounts With Less Than 35K	140,787	173,945	156,540	471,272

GL Description	Number of Contracts
	BC	Prairie	Quebec	Total
Total	258	250	152	660
Rental of Photocopiers	16	17	8	41
Temporary Office Assistance	21	28	9	58
Court Reporters	3	27	18	48
Printing	4	66	9	79
Other Prof. Services < 100,000/YR	6	4	36	46
Local Moving Services	20	9	1	30
On-Line Enquiry		5		5
Training Second Language	7	1	12	20
Training Consultants	20	4		24
Warehousing Services	44			4
Transcripts	5	7		12
Commissionaires	5	1	1	7
Data Preparation	14	3		17
Other Health Services	3	4	2	9
Translation Services	1	3	1	5
Sheriff/Bailiff		6		6
Maintenance Bldg - General	5	11		16
Training & Development for Staff	5		14	19
Repairs & Maint. Furniture & Furnishing	20			20
Rental of Space	9	2	12	23
Image/Video Equipment >10K	2	2	1	5
Paper Recycling Service	5	5		10
Repairs & Maintenance Computer Equipment	3	1	2	6
Image/Video Equipment <10K	6	2		8
Non-Professional Services Contracts	6	2	1	9
Professional Opinions & Advice	4			4
Other Services Not Elsewhere Specified		7		7
Accounts With Less Than 35K	24	33	25	82

The British Columbia figures contain 87 British Columbia contracts worth $328,827 that were not awarded or managed from the British Columbia Regional Office.

Table 5

Legal Services Expenditures for the British Columbia, Prairie, and Quebec Regions
Lines of Coding and Amounts Spent

	All Three Regions
	Lines	O & M (%)	Dollars	O & M (%)
Percentage of Total Printing, Sheriff/Bailiff, Court Reporters, Transcripts without PO Reference		87.1		78.6
O & M coding, excluding JVs and Travel	118,966		25,224,192
Referencing a PO Number
Printing	2,109	1.8	469,520	1.9
Sheriff/Bailiff	120	0.1	13,104	0.1
Court Reporters	708	0.6	355,865	1.4
Transcripts	133	0.5	90,627	0.4
Total	3,070	2.9	929,116	3.7
No PO Number reference
Printing	11,008	9.3	2,106,223	8.4
Sheriff/Bailiff	7,263	6.1	470,266	1.9
Court Reporters	715	0.6	331,583	1.3
Transcripts	1,110	4.0	501,812	2.0
Total	20,096	20.0	3,409,884	13.5