Industrial Consumption of Energy Survey Guide

Manufacturing and Energy Division
Energy Section

I. Who should complete this questionnaire?

An engineer, a production manager, an operation manager or someone knowledgeable about the energy consumption and production process of this enterprise should complete thisquestionnaire.

II. Reporting instructions

Please report all quantities of energy commodities consumed from the 1st of January to the 31st of December, be they purchased or self-generated by the industrial establishment. Exclude energy used by contractors, common carriers and suppliers. Round all data to the nearest whole number. If you need assistance, please contact Statistics Canada at thetelephone number indicated on your questionnaire.

III. Retention

Please keep a copy of the completed questionnaire with your secure records until March 31, 2016.

IV. Definitions

Type of energy use

Amount consumed as fuel: The quantity of the energy commodity used to power the production process of the plant, which includes heating and transportation at theestablishment.

Amount consumed to produce steam for sale: The quantity of the energy commodity used in the production of steam that is delivered to another establishment, as per a sales contract or other understanding. Energy used in the production of steam that is then used internally in the production process isreported in the “amount consumed as fuel” column.

Amount consumed to produce electricity: The quantity of the energy commodity used to generate electricity either for the plant’s own use or for delivery to another establishment,as per a sales contract or other understanding.

Amount consumed for non-energy use: The quantity of the energy commodity used for other purposes than As Fuel in the plant production process or to Produce Electricity or Steam. Some examples of energy commodities used for non-energyuse are:

  • Natural gas used as a reducing agent to produce direct reduced iron (DRI)
  • Petroleum coke used as feed to reduce lead oxide in lead production
  • Natural gas used as feed to produce hydrogen and ammonia
  • Anthracite used as feed (as a reducing agent) to produce ferrosilicon and silicon metal

Type of energy commodity

Please report your energy use according to the following commodity definitions.

Section 1

Electricity: A form of energy generated by friction, induction or chemical change that is caused by the presence and motion of elementary-charged particles. The electricity that is consumed can either be received by the establishment (purchased) orproduced by the establishment (self-generated).

Natural gas: A mixture of hydrocarbons, comprised principally of methane (CH4), originating in the gaseous phase or in solution with crude oil in porous geologic formations beneaththe earth’s surface.

Propane: A gaseous, straight-chained hydrocarbon. A colourless, paraffinic gas extracted from natural gas or refinery gas streams, consisting of molecules composed of three atoms of carbon and eight atoms of hydrogen (C3H8). Used primarily in residential and commercial heating and cooling,as transportation fuel and petrochemical feedstock.

Middle distillates

Diesel: All grades of distillate fuel used for diesel engines, including those with low sulphur content (lower than 0.05%). Does not include diesel used for transportation off theplant site.

Light fuel oil: A light petroleum distillate used for power burners. Includes fuel oil no. 2, fuel oil no. 3, furnace fuel oil,gas oils, and light industrial fuel.

Kerosene and other middle distillates: Includes kerosene (a light petroleum distillate that is used in space heaters, cook stoves and water heaters and is suitable for use as a light source when burned in wick-fed lamps; also known as stove oil), fuel oil no. 1, and mineral lamp oil. Does not include gasoline used for transportation off the plant site.

Heavy fuel oil (Canadian/Foreign): All grades of residual type fuels including those with low sulphur content. Usually used for steam and electric power generation and diesel motors.Includes heavy fuel oil nos. 4, 5, 6 and bunker C.

Wood and wood waste: Wood and wood energy used as fuel, including round wood (cord wood), lignin, wood scraps from furniture and window frame manufacturing, wood chips, bark, sawdust, shavings, lumber rejects, forest residues, charcoal and pulp waste from the operation of pulp mills, sawmills andplywood mills.

Spent pulping liquor (Black liquor): A recycled by-product formed during the pulping of wood in the paper-making process. It is primarily made up of lignin and other wood constituents and chemicals that are by-products of the manufacture of chemical pulp. It is burned As Fuel or in a recovery boiler which produces steam which can be used toproduce electricity.

Refuse: Solid or liquid waste materials used as a combustible energy source. This would include the burning of wastepaper, packing materials, garbage and other industrial, agricultural and urban refuse and is often used to generate electricity.Please specify type.

Steam: A gas resulting from the vaporization of a liquid or the sublimation of a solid, generated by condensing or non-condensing turbines. The steam that is consumed can either be produced by the establishment (self-generated) or receivedby the establishment (purchased).

Special note: the fuels used to generate steam within the establishment (self-generated) should be reported under “as fuel” for those fuels. For example, if 100 cubic metres of heavy fuel oil was used to produce steam, it should be includedunder “as fuel” for heavy fuel oil.

Statistics Canada is currently reviewing the ICE questionnaire and changes may be made in the future that will allow respondents to report for fuels used “to produce steam” separately from the “as fuel” component. To date, the self-generated steam values have not been made publiclyavailable, they are used for internal analysis only.

Section 2

Coal: A readily combustible, black or brownish-black rock-like substance, whose composition, including inherent moisture, consists of more than 50% by weight and 70% by volume of carbonaceous material. It is formed from plant remains that have been compacted, hardened, chemically altered and metamorphosed by heat and pressure over geologic timewithout access to air.

Bituminous coal (Canadian / Foreign): A dense, black coal, often with well-defined bands of bright and dull material with a moisture content usually less than 20 per cent. It has a higher heating value and higher volatile matter and ash content than sub-bituminous coal; the heating value of bituminous coal typically ranges from 23.3 to 30.2 terajoules per kilotonne. Used in making coke, in steam and electricity production, as well as in the production of steel. Metallurgical coal is typicallybituminous coal.

Sub-bituminous coal (Canadian / Foreign): A black coal used primarily for thermal generation. It has a high moisture content,between 15 and 40 percent by weight. Its sulphur content is typically quite low; its ash content is also usually low but volatilematter is usually high and can exceed 40% of the weight.Heating value varies from 16.3 terajoules per kilotonne to slightlyover 20.9 terajoules per kilotonne.

Lignite: Low-rank, brown coals which are distinctly brown and woody or claylike in appearance, and which contain relatively high moisture contents (between 30 and 70 percent of the fuel by weight). Used almost exclusively for electric powergeneration.

Anthracite: A hard, black, lustrous coal containing a high percentage of fixed carbon, a low percentage of volatile matter, little moisture content, low sulfur, low ash and a high heating value at or above 27.7 terajoules per kilotonne that burns with a nearly smokeless flame. Generally used in theproduction of steel.

Coal coke (Canadian/Foreign): A hard, porous product made from the carbonization (baking) of bituminous coal in ovens in substoichiometric atmosphere at high temperatures to the extent that the volatile matter of the coal is released and the coal passes through a “plastic stage” to become metallurgical coke. Often used as a fuel and a carbon input (reducing agent) in smelting iron ore in an integrated steel mill (blast furnace).Coke breeze and foundry coke are included in this category.

Coal by-products

Coal tar: Organic material separated from coke oven gas evolved during coking operations (a black and viscous liquid). This category includes pyridine, tar acids, naphthalene,creosote oil, and coal pitch.

Light coal oil: Condensable products (primarily benzene, toluene, xylene and solvent naphtha) obtained during distillation of the coke oven gas, following removal of the coaltar.

Coke oven gas: Obtained as a by-product of solid fuel carbonization and gasification operations carried out by cokeproducers and iron and steel plants.

Section 3

Petroleum coke (Canadian/Foreign): A final product, often called a “waste product”, of the petroleum refining process, which is the output of the refinery after all of the distillates and oils have been distilled from crude oil, leaving a product that has the appearance of coal. There are various types, e.g. “sponge”, “shot”, and “fluid” coke, which are differentiated according to size. Petroleum coke is a residue high in carbon content and low in hydrogen that is the final product of thermal decomposition in the condensation process in cracking. It is typically high in sulfur, low in volatile matter, low in ash and low in moisture. It may be sold as is or further purified by calcining for specialty uses, including anode production. It may also be burned as fuel in various processes, ranging from power plants to cement kilns. Heating value is typically around 40terajoules per kilotonne.

Refinery fuel gas: Any un-separated mixture of gases produced in refineries by distillation, cracking, reforming and other processes. The principal constituents are methane, ethane, ethylene, normal butane, butylenes, propane, propylene, etc. Also known as still gas. Still gas is used as arefinery fuel and a petrochemical feedstock.

Coke on catalyst (Catalyst coke): In many catalytic operations (e.g. catalytic cracking), carbon is deposited on the catalyst, thus deactivating the catalyst. The catalyst is reactivated by burning off the carbon, which is used as a fuel in the refining process. This carbon or coke is not recoverablein a concentrated form.

Bitumen emulsion (Orimulsion): A thick oil and water emulsion. It is made by mixing bitumen with about 30% water and a small amount of surfactant. Behaves similarly to fuel oiland was developed for industrial use.

Ethane: A normally gaseous, straight-chain hydrocarbon. A colourless, paraffinic gas extracted from natural gas or refinery gas streams, consisting of molecules composed of two atoms of carbon and six atoms of hydrogen (C2H6), used as petrochemical feedstock in production of chemicals andplastics and as a solvent in enhanced oil recovery process.

Butane: A normally gaseous hydrocarbon. A colourless, paraffinic gas extracted from natural gas or refinery gas streams, consisting of molecules composed of four atoms of carbon and ten atoms of hydrogen (C4H10), used primarily for blending in high-octane gasoline, for residential and commercial heating, and in the manufacture of chemicals andsynthetic rubber.

Naphtha: A feedstock destined primarily for the petrochemical industry (e.g. ethylene manufacture or aromatics production). Naphtha specialties comprise all finished products within the naphtha boiling range of 70-200°C that are used as paintthinners, cleaners or solvents. This also includes gas oil used as petrochemical feedstocks.

By-product gas: A mixture of hydrocarbons and hydrogen produced from chemical processes such as ethane cracking.

Flared gas: Gas that is being burned as a means of disposal to the environment usually when it contains odorous or toxic components. Flared gas should be reported as non-energyuse.

Section 4

Other: Any energy commodity consumed not otherwise identified on the questionnaire. Specify in the space providedalong with the unit of measure.

Section 5

Reasons for changes in energy consumption

This section aims to reduce the necessity for further inquiries. Statistics Canada compares responses to this questionnaire with those from previous years. Please indicate the reason(s) that best describe significant changes in your energy consumption from the previous year along withan explanation.

Section 6

Steam sales

If an energy commodity is used to generate steam for sale, please report, in gigajoules, the amount sold to externalclients.

V. Data-sharing Agreements

To reduce respondent burden, Statistics Canada has entered into data-sharing agreements with provincial and territorial statistical agencies and other government organizations, which have agreed to keep the data confidential and use them only for statistical purposes. Statistics Canada will only share data from this survey with those organizations that havedemonstrated a requirement to use the data.

Section 11 of the Statistics Act provides for the sharing of information with provincial and territorial statistical agencies that meet certain conditions. These agencies must have the legislative authority to collect the same information, on a mandatory basis, and the legislation must provide substantially the same provisions for confidentiality and penalties for disclosure of confidential information as the Statistics Act. Because these agencies have the legal authority to compel businesses to provide the same information, consent is not requested and businesses may not object to the sharing ofthe data.

For this survey, there are Section 11 agreements with the provincial and territorial statistical agencies of Newfoundland and Labrador, Nova Scotia, New Brunswick, Quebec, Ontario, Manitoba, Saskatchewan, Alberta, British Columbia, and the Yukon. The shared data will be limited to information pertaining to business establishments located within the jurisdiction ofthe respective province or territory.

Section 12 of the Statistics Act provides for the sharing of information with federal, provincial or territorial government organizations. Under Section 12, you may refuse to share your information with any of these organizations by writing a letter of objection to the Chief Statistician and returning it with the completed questionnaire. Please specify the organizationswith which you do not want to share your data.

For this survey, there are Section 12 agreements with the statistical agencies of Prince Edward Island, the Northwest Territories and Nunavut, as well as with Natural Resources Canada, Environment Canada, National Energy Board, and Alberta Energy. For agreements with provincial and territorial government organizations, the shared data will be limited to business establishments located withinthe jurisdiction of the respective province or territory.

Preliminary Estimate for 2013 and Intentions for 2014

Unified Enterprise Survey - Annual

Reporting Guide

General Instructions

Please report only for the business unit and activity specified on the label.

A. Organization Identification (page 1)
The pre-printed label on page 1 indicates the most current identification of your organization on our files. Please use the appropriate space below the label to make any changes that would reflect a better description of your operations for this particular report.

B. Type of Ownership (page 1)
Ownership is defined as a government entity, person, group of persons, agency or incorporated body controlling more than 50% of the voting rights

Note: Financial assistance (grants, subsidies, etc.) provided by any level of government to an enterprise and/or institution does not necessarily constitute ownership of that organization.

Partnership and joint venture - regarding partnerships and joint venture activities or projects, report the expenditures reflecting your company’s net interest in such projects or ventures.

Canada lands - for this report, the Canada Lands should be assigned as follows:

  • Offshore Newfoundland and Labrador is assigned to Newfoundland and Labrador
  • Offshore Nova Scotia is assigned to Nova Scotia
  • St-Lawrence except offshore Newfoundland and Labrador and offshore Nova Scotia is assigned to Quebec
  • Hudson Bay and Strait is assigned to Ontario
  • Offshore Pacific is assigned to British Columbia
  • Yukon
  • Beaufort Sea and Mackenzie Delta assigned to Northwest Territories
  • Sverdup Basin, North Stable Platform and Arctic Fold Belts are assigned to Northwest or Nunavut Territories

The Non-Conventional Sector for oil sands relates to operations as defined in the A.E.U.B. Publication Alberta Active Projects - Oil Sands and Heavy Oil Schemes (Catalogue A.E.U.B. ST-97-44). Effectively, these operations take place in the geographical areas of Cold Lake, Peace River, Athabasca, Wabasca and Lindbergh, etc.

Data sharing Agreements
To reduce respondent burden, Statistics Canada has entered into data-sharing agreements with provincial and territorial statistical agencies and other government organizations, which have agreed to keep the data confidential and use them only for statistical purposes. Statistics Canada will only share data from this survey with those organizations that have demonstrated a requirement to use the data.

Section 11 of the Statistics Act provides for the sharing of information with provincial and territorial statistical agencies that meet certain conditions. These agencies must have the legislative authority to collect the same information, on a mandatory basis, and the legislation must provide substantially the same provisions for confidentiality and penalties for disclosure of confidential information as the Statistics Act. Because these agencies have the legal authority to compel businesses to provide the same information, consent is not requested and businesses may not object to the sharing of the data.

For this survey, there are Section 11 agreements with the provincial and territorial statistical agencies of Newfoundland and Labrador, Nova Scotia, New Brunswick, Quebec, Ontario, Manitoba, Saskatchewan, Alberta, British Columbia, and the Yukon.

The shared data will be limited to information pertaining to business establishments located within the jurisdiction of the respective province or territory.

Section 12 of the Statistics Act provides for the sharing of information with federal, provincial or territorial government organizations. Under Section 12, you may refuse to share your information with any of these organizations by writing a letter of objection to the Chief Statistician and returning it with the completed questionnaire. Please specify the organizations with which you do not want to share your data.

For this survey, there are Section 12 agreements with the statistical agencies of Prince Edward Island, the Northwest Territories and Nunavut as well as Natural Resources Canada, Environment Canada, the Newfoundland and Labrador Department of Mines and Energy, the Nova Scotia Department of Natural Resources, the New Brunswick Department of Natural Resources, the Ontario Ministry of Northern Development and Mines, Manitoba Science, Technology Energy and Mines and the British Columbia Ministry of Energy, Mines and Petroleum Resources, and the Saskatchewan Ministry of the Economy.

For agreements with provincial and territorial government organizations, the shared data will be limited to information pertaining to business establishments located within the jurisdiction of the respective province or territory.

Note that there is no right of refusal with respect to sharing the data with the Saskatchewan Ministry of the Economy for businesses also required to report under The Mineral Resources Act (Saskatchewan). The Saskatchewan Ministry of the Economy will use the information obtained from these businesses in accordance with the provisions of their Act.

Fiscal Year End

 For the purpose of this survey, please report information for your 12 month fiscal period for which the Final day occurs on or between April 1, 2013 - March 31, 2014 for 2013 and April 1, 2014 - March 31, 2015 for 2014.

The following are acceptable report periods for 2013:
May 2012 - April 2013 (04/13)
June 2012 - May 2013 (05/13)
July 2012 - June 2013 (06/13)
Aug. 2012 - July 2013 (07/13)
Sept. 2012 - Aug. 2013 (08/13)
Oct. 2012 - Sept. 2013 (09/13)
Nov. 2012 - Oct. 2013 (10/13)
Dec. 2012 - Nov. 2013 (11/13)
Jan. 2013 - Dec. 2013 (12/13)
Feb. 2013 - Jan. 2014 (01/14)
March 2013 - Feb. 2014 (02/14)
April 2013 - March 2014 (03/14)

The following are acceptable report periods for 2014:
 May 2013 - April 2014 (04/14)
June 2013 - May 2014 (05/14)
July 2013 - June 2014 (06/14)
Aug. 2013 - July 2014 (07/14)
Sept. 2013 - Aug. 2014 (08/14)
Oct. 2013 - Sept. 2014 (09/14)
Nov. 2013 - Oct. 2014 (10/14)
Dec. 2013 - Nov. 2014 (11/14)
Jan. 2014 - Dec. 2014 (12/14)
Feb. 2014 - Jan. 2015 (01/15)
March 2014 - Feb. 2015 (02/15)
April 2014 - March 2015 (03/15)

Definitions

Note:

Syncrude participants: If you are a participant in the Syncrude project, please exclude your participation when filing this report. Arrangements have been made to collect data for this project on a consolidated report.

Regarding partnerships and joint venture activities or projects: report the expenditures reflecting your company’s net interest in such oil sands projects or ventures. Capital expenditures for the Bi-Provincial Upgrader should be included in the schedule.

1. Oil and gas rights acquisition and retention costs (exclude inter-company sales or transfers) includes:

  • Acquisition costs and fees for oil and gas rights (include bonuses, legal fees and filing fees)
  • Oil and gas rentention costs

2. Cost of land and lease purchased from other petroleum companies: Purchases from companies that are engaged primarily in petroleum activities.

3. Geological and geophysical expenditures: Include such activities as seismic crew expenses, both company owned and contract. Include camp bulldozing and dirt work, flying crews in and out, seismograph, velocity survey, gravity meter, magnetometer, core drilling, photo geological digital processing, magnetic playback and bottom hole contributions and environmental impact studies and other similar pre-exploration expenditures. All seismic or geological and geophysical expenditures (including stratigraphic tests) should be reported here, whether such activity is deemed exploration or development by the company.

** Exploration and development expenditures: Should be reported gross (whether capitalized or expensed) before deducting any incentive grants.

4. Exploration drilling: Drilling outside a proven area or within a proven area but to a previously untested horizon, in order to determine whether oil or gas reserves exist rather than to develop proven reserves discovered by previous drilling. Include cost of dry wells, casing and other materials and equipment abandoned in place; productive wells, including capped wells; and wells still in progress at year end. Include also costs incurred in fighting blowouts, runaways and in replacing damaged equipment.

5. Development drilling: Drilling within the proven area of an oil gas reservoir to the depth of a stratigraphic horizon known to be productive for the purpose of extracting oil or gas reserves. This will cover costs of dry wells; including casing and other materials and equipment abandoned in place; productive wells, including capped wells; and wells still in progress at year end, core analysis, logging, road building and other directly related services. Include also costs incurred in fighting blowouts, runaways and in replacing damaged equipment. Exclude costs associated with service wells.

Note: There should be no development expenditures until a development plan has been approved.

6. Production facilities and pre-mining costs: Include tangible well and lease equipment comprising casing, tubing, wellheads, pumps, flowlines, separators, treaters, dehydrators. Include gathering pipelines, lease and centralized tank batteries and associated facilities prior to delivery to trunk pipeline terminals, and other production facilities. Include also, costs associated with intangibles such as pre-production studies costs and those expenditures that you consider to be pre-development. Include also, overburden removal and other pre-production expenditures as well as, laboratory work, consultants’ fees, performance evaluations and experimental pilot plants (including any capitalized operating costs).

7. Assets other than production facilities (machinery and equipment): Include automotive, airplane, communication, warehouse, dock, office and miscellaneous equipment not otherwise specified. Include items such as boilers, compressors, motors, pumps and any other items that may be termed manufacturing or mining equipment as opposed to a fixed installation such as a building.

8. Enhanced recovery projects: Include only expenditures on facilities in tertiary projects involving steam injection, miscible flooding, etc. Include service wells, both tangible and intangible, including the costs of drilling and equipping injection wells and also the cost of capitalized injection fuel (miscible fluid) costs, but exclude non-recoverable injection fluids charged to current operations.

9. Natural gas processing plants: Report only the capitalized amounts of the plants, including structures, measuring, regulating and related equipment. (Please include straddle plants.)

10. Drilling rigs and supply boats: Expenditures (including progress payments) for the purchase of new drilling rigs (on and offshore) and supply boats. Include also those drilling rigs and supply boats imported into Canada (both new and/or used).

11. Office buildings and other structures: Include office buildings and any other closely related structures not included above.

12. Coal bed methane extraction: Report all expenditures related to coal bed methane extraction.

13. Total: The addition of lines 1 to 12.

Year over year variation of capital expenditures

Complete this section only if this report shows significant changes in Total capital expenditures over previous fiscal period. The intent of this section is to reduce possible further inquiries by clarifying the reason(s) for major changes in the capital expenditures reported.

If there has been a launch of a major project or expansion of an existing project, please provide the nature, location, and (if applicable) the name(s) / title(s) of the project in the comment section of the questionnaire.

Survey on Capital ExpendituresPreliminary Estimate for 2013 and Intentions for 2014

Unified Enterprise Survey - Annual

Reporting Guide

General Instructions

1. Reports Required

  • Reports should be completed for Canadian activities and locations as described on the pre-printed label.

2. Dollar Amounts and Percentages

  • All dollar amounts reported should be rounded to Thousands of canadian dollars (e.g., $6,555,444.00 should be rounded to $6,555);
  • Percentages should be rounded (e.g., 37%, 76%, 94%);
  • Your best estimates are acceptable when precise figures are not available;
  • Pre-printed cell numbers are for identification purposes only.

3. Return of Questionnaire

By Mail to:
Statistics Canada,
150 Tunney’s Pasture Driveway, Distribution Center - SC-0702
Ottawa, Ontario K1A 0T6
By Fax at:
toll free at 1-888-883-7999

Statistics Canada advises you that there could be a risk of disclosure during the facsimile or other electronic transmission. However, upon receipt of your information, Statistics Canada will provide the guaranteed level of protection afforded all information collected under the authority of the Statistics Act.

4. Questions?

If you have any questions, please call us toll free at 1-877-604-7828 or by e-mail at Invest@statcan.gc.ca

Data sharing Agreements
To reduce respondent burden, Statistics Canada has entered into data-sharing agreements with provincial and territorial statistical agencies and other government organizations, which have agreed to keep the data confidential and use them only for statistical purposes. Statistics Canada will only share data from this survey with those organizations that have demonstrated a requirement to use the data.

Section 11 of the Statistics Act provides for the sharing of information with provincial and territorial statistical agencies that meet certain conditions. These agencies must have the legislative authority to collect the same information, on a mandatory basis, and the legislation must provide substantially the same provisions for confidentiality and penalties for disclosure of confidential information as the Statistics Act. Because these agencies have the legal authority to compel businesses to provide the same information, consent is not requested and businesses may not object to the sharing of the data.

For this survey, there are Section 11 agreements with the provincial and territorial statistical agencies of Newfoundland and Labrador, Nova Scotia, New Brunswick, Quebec, Ontario, Manitoba, Saskatchewan, Alberta, British Columbia, and the Yukon.

The shared data will be limited to information pertaining to business establishments located within the jurisdiction of the respective province or territory.

Section 12 of the Statistics Act provides for the sharing of information with federal, provincial or territorial government organizations. Under Section 12, you may refuse to share your information with any of these organizations by writing a letter of objection to the Chief Statistician and returning it with the completed questionnaire. Please specify the organizations with which you do not want to share your data.

For this survey, there are Section 12 agreements with the statistical agencies of Prince Edward Island, the Northwest Territories and Nunavut as well as Natural Resources Canada, Environment Canada, the Newfoundland and Labrador Department of Mines and Energy, the Nova Scotia Department of Natural Resources, the New Brunswick Department of Natural Resources, the Ontario Ministry of Northern Development and Mines, Manitoba Science, Technology Energy and Mines and the British Columbia Ministry of Energy, Mines and Petroleum Resources, and the Saskatchewan Ministry of the Economy.

For agreements with provincial and territorial government organizations, the shared data will be limited to information pertaining to business establishments located within the jurisdiction of the respective province or territory.

Note that there is no right of refusal with respect to sharing the data with the Saskatchewan Ministry of the Economy for businesses also required to report under The Mineral Resources Act (Saskatchewan). The Saskatchewan Ministry of the Economy will use the information obtained from these businesses in accordance with the provisions of their Act.

Pre-Printed Label

Type of Ownership

Private – less than 50% of the voting rights are controlled by the government
Public – more than 50% of the voting rights are controlled by the government
specify – Federal, Provincial or Municipal

Fiscal Year End

For the purpose of this survey, please report information for your 12 month fiscal period for which the Final day occurs on or between April 1, 2013 - March 31, 2014 for 2013 and April 1, 2014 - March 31, 2015 for 2014.

The following are acceptable report periods for 2013:
May 2012 - April 2013 (04/13)
June 2012 - May 2013 (05/13)
July 2012 - June 2013 (06/13)
Aug. 2012 - July 2013 (07/13)
Sept. 2012 - Aug. 2013 (08/13)
Oct. 2012 - Sept. 2013 (09/13)
Nov. 2012 - Oct. 2013 (10/13)
Dec. 2012 - Nov. 2013 (11/13)
Jan. 2013 - Dec. 2013 (12/13)
Feb. 2013 - Jan. 2014 (01/14)
March 2013 - Feb. 2014 (02/14)
April 2013 - March 2014 (03/14)

The following are acceptable report periods for 2014:
May 2013 - April 2014 (04/14)
June 2013 - May 2014 (05/14)
July 2013 - June 2014 (06/14)
Aug. 2013 - July 2014 (07/14)
Sept. 2013 - Aug. 2014 (08/14)
Oct. 2013 - Sept. 2014 (09/14)
Nov. 2013 - Oct. 2014 (10/14)
Dec. 2013 - Nov. 2014 (11/14)
Jan. 2014 - Dec. 2014 (12/14)
Feb. 2014 - Jan. 2015 (01/15)
March 2014 - Feb. 2015 (02/15)
April 2014 - March 2015 (03/15)

Definitions

What are Capital Expenditures?

Capital Expenditures are the gross expenditures on fixed assets for use in the operations of your organization or for lease or rent to others.

Include:

  • Cost of all new buildings, engineering, machinery and equipment which normally have a life of more than one year and are charged to fixed asset accounts
  • Modifications, acquisitions and major renovations
  • Capital costs such as feasibility studies, architectural, legal, installation and engineering fees
  • Subsidies
  • Capitalized interest charges on loans with which capital projects are financed
  • Work done by own labour force
  • Additions to work in progress

How to Treat Leases

  • Include assets acquired for lease to others, either as a capital, financial or as an operating lease
  • Exclude assets acquired as a lessee through either a capital, financial or an operating lease from others

Information for Government Departments

The following applies to government departments only:

  • Include all capital expenditures without taking into account the capitalization threshold of your department;
  • Grants and/or subsidies to outside entities (e.g., municipalities, agencies, institutions or businesses) are not to be included;
  • Departments are requested to exclude from reported figures budgetary items pertaining to any departmental agency and proprietary crown corporation as they are surveyed separately;
  • Federal departments are to report expenditures paid for by the department, regardless of which department awarded the contract;
  • Provincial departments are to include any capital expenditures on construction (exclude outlays for land) or machinery and equipment, for use in Canada, financed from revolving funds, loans attached to revolving funds, other loans, the Consolidated Revenue Fund or special accounts.

Sections A and C: Capital Expenditures

Report the value of the projects expected to be put in place during the year. Include the gross expenditures (including subsidies) on fixed assets for use in the operations of your organization or for lease or rent to others. Include all capital costs such as feasibility studies, architectural, legal, installation and engineering fees as well as work done by your own labour force.

New Assets, Renovation, Retrofit (Column 1), includes both existing assets being upgraded and acquisitions of new assets

The following explanations are Not applicable to government departments:

  • include - Capitalized interest charges on loans with which capital projects are financed
  • exclude - If you are capitalizing your leased fixed assets as a lessee in accordance with the  Canadian Institute of Chartered Accountants’ recommendations, please exclude the total of the capitalization of such leases during the year from capital expenditures

Leases

In accordance with the recommendations of the Canadian Institute of Chartered Accountants, leases are divided into two types, operating and capital. For the present, purchases of all capital assets whether for own use or for lease to others, either as a capital lease or as an operating lease should be reported Fin the appropriate place in Columns 1 or 2 Sections A and C. Assets acquired as a lessee through either a capital lease or operating lease from others should not be reported in these columns.

New assets acquired by means of a capital lease from others should not be included in Section A and C Columns 1 or 2.

The following applies to government departments only:

  • grants and/or subsidies: to outside entities (e.g., municipalities, agencies, institutions orbusinesses), are not to be included
  • departments are requested to exclude from reported figures budgetary items pertaining to any departmental agency and proprietary crown corporation as they are surveyed separately
  • federal departments are to report expenditures paid for by their department, regardless of which department awarded the contract
  • provincial departments are to include any capital expenditures on construction (exclude outlays for land) and/or machinery and equipment, for use in Canada, financed from revolving funds, loans attached torevolving funds, other loans, the Consolidated Revenue Fund or special accounts

Purchase of Used Canadian Assets (Column 2)

Definition: Used fixed assets may be defined as existing buildings, structures or machinery and equipment which have been previously used by another organization in Canada that you have acquired during the time period being reported on this questionnaire.

Explanation: The objective of our survey is to measure gross annual new acquisitions to fixed assets separately from the acquisition of gross annual used fixed assets in the Canadian economy as a whole.

Hence, the acquisition of a used fixed Canadian asset should be reported separately since such acquisitions would not change the aggregates of our domestic inventory of fixed assets, it would simply mean a transfer of assets within Canada from one organization to another.

Imports of used assets, on the other hand, should be included with the new assets (Column 1) because they are newly acquired for the Canadian economy.

Work in Progress:
Work in progress represents accumulated costs since the start of capital projects which are intended to be capitalized upon completion.

Typically capital investment includes any expenditure on an asset in which its’ life is greater than one year. Capital items charged to operating expenses are defined as expenditures which could have been capitalized as part of the fixed assets, but for various reasons, have been charged to current expenses.

Definitions

Land (Row 1)
Capital expenditures for land should include all costs associated with the purchase of the land that are not amortized or depreciated.

Residential Construction (Row 2)
Report the value of residential structures including the housing portion of multi-purpose projects and of townsites with the following Exceptions:

  • buildings that have accommodation units without self-contained or exclusive use of bathroom and kitchen facilities (e.g., some student and senior citizen residences)
  • the non-residential portion of multi-purpose projects and of townsites
  • associated expenditures on services

The exceptions should be included in the appropriate construction (e.g., non-residential) asset.

Non-Residential Construction (Row 3) (excluding land purchase and residential construction)
Report the total cost incurred during the year of building and engineering construction (contract and by own employees) whether for your own use or rent to others. Include also:

  • the cost of demolition of buildings, land servicing and of site-preparation
  • leasehold and land improvements
  • townsite facilities, such as streets, sewers, stores, schools
  • oil or gas pipelines, including pipe and installation costs
  • all preconstruction planning and design costs such as engineer and consulting fees and any materials supplied to construction contractors for installation, etc.

Machinery and Equipment (Row 4)
Report total cost incurred during the year of all new machinery, whether for your own use or for lease or rent to others. Any capitalized tooling should also be included. Include progress payments paid out before delivery in the year in which such payments are made. Receipts from the sale of your own fixed assets or allowance for scrap or trade-in should not be deducted from your total capital expenditures. Any balance owing or holdbacks should be reported in the year the cost is incurred.

Include:

  • automobiles, trucks, professional and scientific equipment, office and store furniture and appliances
  • computers (hardware and software), broadcasting, telecommunication and other information and communication technology equipment
  • motors, generators, transformers
  • any capitalized tooling expenses
  • progress payments paid out before delivery in the year in which such payments are made
  • any balance owing or holdbacks should be reported in the year the cost is incurred

Section B: Capacity Utilization (Manufacturing Companies only)

Capacity use (utilization) is calculated by taking the actual production level for an establishment (production can be measured in dollars or units) and dividing it by the establishment’s capacity production level.

Capacity production is defined as maximum production attainable under normal conditions.

To calculate capacity production, follow the establishment’s operating practices with respect to the use of productive facilities, overtime, workshifts, holidays, etc. For example, if your plant normally operates with one shift of eight hours a day five days a week then capacity will be calculated subject to these conditions and not on the hypothetical case of three shifts a day, seven days a week.

Example:
Plant “A” normally operates one shift a day, five days a week and given this operating pattern capacity production is 150 units of product “A” for the month. In that month actual production of product “A” was 125 units. The capacity utilization rate for plant “A” is (125/150) * 100 = 83%

Now suppose that plant “A” had to open a shift on Saturdays to satisfy an abnormal surge in demand for product “A”. Given this plant’s normal operating schedule, capacity production remains at 150 units. Actual production hasgrown to 160 units, so capacity utilization would be (160/150) * 100 = 107%.

Section D: Year over Year Variation of Capital Expenditures

Complete this section only if this report shows significant changes in Total capital expenditures over previous fiscal period. The intent of this section is to reduce possible further inquiries by clarifying the reason(s) for major changes in the capital expenditures reported.

If there has been a launch of a major project or expansion of an existing project, please provide the nature, location, and (if applicable) the name(s) / title(s) of the project in the comment section of the questionnaire.

Description for Figure 1 - Certificate Preparation Process

The chart is a flow chart description of the Equalization certificate process, the parties involved in the certificate process and their roles during the process. It is set up in 3 columns. National Accounts Integration and Development Division (NAIDD) is labelled as the centre column and this division co-ordinates the certificate process. The outside left column is labelled as External Reviewers and the outside right column is labelled Data Supplying Divisions. The flow chart begins in the center column and the first box within the NAIDD column indicates that NAIDD requests data from DSDs using structured templates. From this point the process moves into the Data Supplying Divisions column. The first box in the DSD column shows that the DSDs prepare the data and from here the next step is then the internal quality assurance within the DSDs. From this step the data then are subject to the Director challenge and sign-off. The chart then shows that the completed templates are submitted back to NAIDD and this is illustrated with an arrow back into the centre column. At this point NAIDD conducts basic quality checks and then sends queries to DSDs based upon reviews. A bi-directional arrow between the NAIDD column and the Data Supplying Divisions column illustrates that queries and responses back to NAIDD may take place several times as the data are reviewed. The chart shows that as the certificate information is being finalized, NAIDD sends the certificate information for Work-in-Progress reviews. This is illustrated by the left column labelled External Reviewers. This movement into the External Reviewers column is labelled with a bi-directional arrow as Work-in-Progress reviews take place at different times. As these reviews are done NAIDD sends the external reviewer queries to the DSD who respond. This process continues bi-directionally until all reviews have been completed and all queries are adequately responded to. Work-in-Progress reviews that take place include: Focal point review in August, a first Department of Finance Review in September and a final Department of Finance review in November. Once all reviews have been completed and all queries responded to, the certificates are finalized and NAIDD obtains the Chief Statistician signature and finalized certificates are submitted to the Department of Finance by December 1.

Audit of Equalization Certificates

Audit Report

April 22, 2013
Project Number: 80590-75

Executive summary

The equalization program has been in place since 1957 and is embedded in Section 36(2) of The Constitution Act (1982). The statutory authority for equalization is found in the Federal-Provincial Fiscal Arrangements Act (FPFAA) and regulations. Equalization has changed significantly since the original implementation and continues to undergo change during periodic reviews. The next review of the Act and regulations is scheduled to take place in 2013.

The equalization program examines, on a per capita basis, a province's ability to generate its own revenue compared to the fiscal capacity for all provinces. In addition to equalization for provinces, there is also Territorial Formula Financing, which is an annual unconditional transfer to the three territorial governments. The territorial financing enables the territories to provide residents with a range of public services comparable to those offered by provincial governments, at comparable levels of taxation and these data are contained on the equalization certificates.

Statistics Canada's role in equalization is outlined in the FPFAA and regulations. It is Statistics Canada's responsibility to prepare the revenue base and revenue source certificates. These certificates are used by the Department of Finance to calculate provincial equalization payments and territorial funding payments. In 2012, approximately 18.5 billion dollars were distributed to receiving provinces and territories under the provincial and territorial transfer programs.

The objectives of the audit were to provide the Chief Statistician (CS) and the Departmental Audit Committee (DAC) with assurance that Statistics Canada has the appropriate tools, people, resources, and quality assurance mechanisms necessary to develop accurate and complete equalization certificates which comply with the Federal-Provincial Fiscal Arrangements Act.

Key findings

The equalization certificate program is a small but complex undertaking for Statistics Canada. Equalization certificates require over 100 data series from eleven divisions within the department. In 2012, National Accounts Integration and Development Division (NAIDD) was delegated the responsibility for coordinating and preparing the equalization certificates. Within NAIDD and the data supplying divisions, roles and responsibilities for those preparing the information are clearly communicated and understood.

While the processes and tools in place with NAIDD are effective and help to ensure risks to the quality and timeliness of the certificates are minimized, the audit revealed that there are opportunities to strengthen the certificate framework environment by ensuring that systems access permissions within NAIDD are periodically monitored to ensure access is provided on a "need-to-know" basis. Additionally, NAIDD should actively monitor the operating environment within Statistics Canada to assess and respond to risks external to the division that may impact the equalization certificates.

Within NAIDD, effective data quality control points have been integrated into the certificate preparation business process. The audit noted that the quality management framework developed by NAIDD could be improved by ensuring validation of the formulas in the final certificates takes place and configuring the templates to protect the data to ensure that data and formulas cannot be inadvertently overwritten.

Five of the six data supplying divisions (DSDs) examined in the audit have effective procedures documents that have been tailored to meet the needs of the specific programs as they respond to the requirements of the equalization program and evidence of quality review was found. However, in one DSD examined, the audit found no process documentation in place for the preparation and quality review of the data. The audit noted that this division has been subject to data anomalies in past submissions. The implementation of processes and procedures documentation for the preparation, quality review and sign-off of data submissions would reduce the risk of future data anomalies.

The majority of data supplying divisions (DSDs) examined had effective quality management practices in place to ensure the appropriate validation information on the divisional templates. Assessment of internal quality review, program director challenge and sign-off indicated that the framework could be strengthened by ensuring these processes are formalized and evidence of quality review and challenge is documented. Additionally, DSDs should ensure that segregation of duties is in place between data preparation and data validation, and that contingency plans are in place to ensure DSD submissions can be accurately completed.

The certificate preparation cycle takes place over several months and divisional data requests are timed to correspond with specific survey data releases. Although the certificate process is designed to ensure data provided are final, the audit noted that inconsistencies in the reporting of data revisions to NAIDD during the annual certificate process underscore that there is some uncertainty within DSDs related to the definitions and reporting requirements outlined in the Directive on Corrections to Daily Releases and Statistical Products. This elevates the risk that data on the certificates may not reflect the most accurate and up-to-date information. The audit team found that opportunities exist to strengthen the quality management practices by ensuring that DSDs develop procedures to advise NAIDD when data revisions or corrections occur to the data supplied on the divisional templates during the equalization certificate cycle.

Overall conclusion

The audit determined that the equalization certificates prepared by Statistics Canada in 2011 and 2012 were accurate and the tools, people, resources and quality assurance mechanisms in place support the completion of certificates in accordance with the FPFAA. Although the audit found minor data anomalies on the source and base certificates prepared in 2011 and 2012, these discrepancies did not impact equalization information for the provinces or territories for the years reviewed.

The certificate framework and quality management controls in place within NAIDD are generally effective; however, opportunities exist to strengthen these control frameworks within the certificate preparing division.

The certificate and quality management frameworks within DSDs could be enhanced by ensuring that within all DSDs process documents are developed and strengthening and documenting the quality assurance mechanisms in place.

Conformance with professional standards

The conduct of this engagement conforms with the Internal Auditing Standards for the Government of Canada, as supported by the results of the Quality Assurance and Improvement Program. Sufficient testing was carried to support the findings and related recommendations.

Patrice Prud'homme
Chief Audit Executive

Introduction

Background

The equalization program has been in place since 1957 and is part of the federal-provincial fiscal arrangements legislation. Equalization has changed significantly since the original implementation and continues to undergo periodic review. The next review of the Federal-Provincial Fiscal Arrangements Act (FPFAA) and regulations is scheduled to take place in 2013.

In general, equalization is a federal transfer payment program that has been designed to assess the fiscal capacity of the provinces and smooth out disparities. It is embedded in Section 36(2) of The Constitution Act (1982) which states:

Parliament and the Government of Canada are committed to the principle of making equalization payments to ensure that provincial governments have sufficient revenues to provide reasonably comparable levels of public services at reasonably comparable levels of taxation.

The equalization program examines, on a per capita basis, a province's ability to generate own source revenues to the fiscal capacity for all provinces. In addition to equalization for the provinces, the FPFAA includes Territorial Formula Financing, an annual unconditional transfer to the three territorial governments. Territorial financing enables the territories to provide public services comparable to those provided by provinces while taking into consideration the higher costs of providing programs and services in the territories.

The statutory authority for equalization and territorial financing is found in the Federal-Provincial Fiscal Arrangements Act and regulations. This Act outlines the role of the Chief Statistician as it pertains to fiscal equalization payments to provinces and territorial financing. Statistics Canada is responsible for preparing the revenue base and revenue source certificates. The regulations associated with the Act provide specific interpretation and outline data requirements and calculations.

The equalization certificate program is a small but complex undertaking for Statistics Canada; over 100 data series are collected from eleven divisions to prepare the equalization certificates. Reviews of data are completed by the eleven data supplying divisions, the certificate preparing division, Provincial and Territorial Focal Points, and the Department of Finance. The equalization program has a large impact on the country: in 2012, approximately 18.5 billion dollars were transferred to provinces under the FPFAA.

Until 2012, Public Sector Statistics Division (PSSD) within the National Accounts and Analytical Studies Field compiled the legislated input required for the administration of the FPFAA. Beginning in 2012, responsibility for certificate preparation was transferred to the National Accounts Integration and Development Division (NAIDD) within the National Accounts assumed responsibility for the preparation of the certificates for Statistics Canada. Effective April 1, 2013, NAIDD was subsumed into Industry Accounts and Expenditure Division and moved into the Economics Statistics Field.

Audit objectives

The objectives of the audit were to provide the Chief Statistician (CS) and the Departmental Audit Committee (DAC) with assurance that:

  • Statistics Canada has the tools, people and other resources necessary to develop timely, accurate and complete certificates in accordance with the requirements of the Federal-Provincial Fiscal Arrangements Act.
  • Statistics Canada has appropriate quality assurance mechanisms in place over the equalization certificate program to ensure compliance with the requirements of the Federal-Provincial Fiscal Arrangements Act.

Scope

The scope of this audit included an examination of the adequacy and effectiveness of the controls in place to prepare the equalization certificates. Specific areas examined included the preparation and quality assurance controls for the data and actual certificates, and examination of the adequacy and effectiveness of controls in place to ensure compliance with the data required by the FPFAA regulations. The audit covered statistical information for certificates prepared in 2011 and 2012.

Approach and methodology

The audit was conducted in accordance with the Internal Auditing Standards for the Government of Canada, which includes the Institute of Internal Auditors (IIA) International Standards for the Professional Practice of Internal Auditing.

The audit work consisted of an examination of documents, interviews with key Senior Management and personnel, and a review for compliance with relevant policies and guidelines.

The methodology consisted of a review of applicable policies, procedures, and information related to quality, accuracy and sign-off of the certificates and source data. Testing of a sample of quality assurance mechanisms in place as they relate to the certificates and data submissions also took place. Audit testing included: validation to ensure that data supplied on the certificates matched current equalization regulations on the source and base certificates; confirming that all formulas on finalized source and base certificates were equivalent for each province and territory; ensuring that final certificate data matched data supplied by DSDs; validating that formulas within spreadsheets that were linked to equalization certificates were coherent and accurate; and validating that English and French versions of the certificates were equivalent, and units of measure were accurately denoted. The audit also examined evidence confirming that quality assurance activities took place within DSDs and NAIDD.

Authority

The audit was conducted under the authority of Statistics Canada Integrated Risk-Based Audit & Evaluation Plan 2012/13 to 2016/17, approved April 2012, by the Departmental Audit Committee.

Findings, recommendations and management response

Objective No. 1: Statistics Canada has the tools, people and other resources necessary to develop timely, accurate and complete certificates in accordance with the requirements of the Federal-Provincial Fiscal Arrangements Act.

Certificate framework

Certificate Preparing Division:
Within NAIDD, roles and responsibilities for staff coordinating the certificate preparation are clear and communicated. Adequate and effective procedures documents and tools are in place to support preparation of the certificates. However, internal systems access permissions should be periodically monitored to ensure access is provided on a "need-to-know" basis.

Extensive changes related to the transfer of the certificate program and loss of experience and knowledge across the organization elevates the risk to the quality and timeliness of the equalization certificates. NAIDD should actively monitor the operating environment to assess and respond to risks external to the division that may impact the equalization certificates.

Data Supplying Divisions:
Roles and responsibilities for staff in the divisions supplying data for the certificates are clear and communicated.

The majority of DSDs examined had effective procedures documents in place to fulfill the requirements of the equalization certificate program. However, opportunities exist to strengthen tools in place by ensuring processes and procedures for the preparation, quality review and sign-off of data submissions are clearly documented.

An effective certification framework should ensure that appropriate processes and procedures are in place so that individuals preparing and validating the information have the tools necessary to develop quality equalization certificates. This includes detailed process documents outlining how data should be prepared and what data validation is required to ensure the quality of the information. Roles and responsibilities should be clearly defined and communicated and the business and operating environments should be monitored for change. Controls in place should ensure files are restricted to authorized users only.

Certificate framework: process overview

Equalization certificates are developed based on over 100 data series received from eleven divisions within Statistics Canada. National Accounts Integration and Development Division (NAIDD) has been delegated responsibility for the coordination and preparation of the equalization certificates, which are comprised of revenue base, revenue source and population certificates.

NAIDD requests data from data supplying divisions (DSDs) using structured templates specifying the data to be provided. Requests are timed to follow the official release of data. Staff in DSDs prepare the required information, carry out quality assurance over the information prepared, and obtain program director sign-off on the completed template.

Information transmitted back to NAIDD is compiled into the certificates and reviewed. NAIDD performs basic quality checks over the information provided by DSDs and coordinates Work-in-Progress (WIP) reviews with Provincial/Territorial Focal Points and the Department of Finance. Once reviewed and finalized, the certificates are sent to the Director General of NAIDD and the Assistant Chief Statistician for review, and subsequently to the Chief Statistician for sign-off. Final signed certificates are sent to the Department of Finance, where provincial equalization and territorial funding payments are calculated using these data.

Figure 1: Certificate Preparation Process

Figure 1: Certificate Preparation Process

Description for Figure 1: Certificate Preparation Process

Certificate framework: Certificate Preparing Division

Roles and responsibilities

The audit found that within NAIDD roles and responsibilities have been clearly defined and communicated. The chief in the equalization section of NAIDD is the main point-of-contact for the Department of Finance, Provincial/Territorial Focal Points, and DSDs. The economist in the section is responsible for the coordination and preparation of the certificates, requesting, compiling and validating information received from DSDs, and liaising with DSDs when questions arise.

Clearly defined roles and responsibilities are in place within the equalization certificate program of NAIDD to support the effective management of quality for the certificates. Tasks and responsibilities for the preparation, validation and review of the certificates are complied with by NAIDD staff.

Procedures and tools

A detailed and comprehensive document entitled, "Equalization and Territorial Formula Financing" is in place within NAIDD. This document was developed as a knowledge transfer tool, when NAIDD learned that they were to take over preparation of the equalization certificates from Public Sector Statistics Division. The document outlines the history behind equalization and details the data required for the certificates. The document includes detailed timelines for requesting, compiling and validating data including the WIP reviews undertaken with Provincial and Territorial Focal Points and the Department of Finance. This document is an effective resource for employees working on the equalization certificate program.

The certificates are created and prepared using Microsoft Excel. Each row of the certificate data provides a reference to the associated FPFAA regulations, the name of the data and the units of measure for each data point (e.g. kilowatts, tonnes, dollars etc.). In both the revenue source and revenue base certificates workbooks are several linked worksheets which contain the data from finalized divisional templates. Using a linked workbook for the certificates ensures that certificate preparers do not have to transcribe data and can easily refer to data supplied from DSDs to validate and update information.

Monitoring the risk environment

Within NAIDD, risks are identified at the divisional level and risks specific to the timeliness and quality of the equalization certificates are not specifically or formally defined in the risk register. Interviews noted that risks specific to the equalization program have been informally identified and are managed through the business processes, including the completion of a quality review and following a detailed schedule to ensure the certificates are finalized by the date required by the Department of Finance.

NAIDD is dependent on DSDs to supply and provide comprehensive quality assurance on all of the data contained in the equalization certificates. Issues related to the quality and timeliness of supplying data will impact the information contained in the certificates and impact the equalization program. The divisional risk register notes this dependence as a risk to the relevance, quality, accuracy and timeliness of the divisional programs however no formal assessment, mitigation or monitoring of this risk are in place within NAIDD. As a result, NAIDD should actively monitor the operating environment across the organization to assess and respond to the risks external to the division that may impact the equalization certificates. For example, the audit noted that as a result of significant staffing changes across the organization (including change in responsibility for certificate preparation) there has been a substantial loss of knowledge and experience related to the equalization program. In 2012, staff preparing the certificates were new to the process as were staff preparing the divisional templates in 3 of the six data supplying divisions examined during the audit. This loss of experience and knowledge elevates the risks to the quality and/or timeliness of the certificate information, as employees may not understand the importance of the information they provide, or may not be aware that data requirements can change.

Systems access controls

NAIDD has effective electronic access controls in place for the external transmission of certificate information to authorized recipients. Access to draft certificates for Provincial/Territorial Focal Point and Department of Finance WIP reviews is restricted to designated officials only. An electronic File Transfer System (e-FTS) has been implemented with access authentication procedures and mechanisms in place to ensure safe transmittal of draft certificate information between NAIDD and authorized external parties.

Within NAIDD, information (data and production information) for the equalization certificates are stored on a Solaris Server within a designated folder. Access to the equalization folder is granted to those working in the Harmonized Sales Tax (HST) secretariat, but access permissions are not monitored to ensure access to authorized individuals only. The audit found that of the eleven individuals in the group with access permission, one no longer worked in the division, two worked in NAIDD but not on the equalization certificates, and one no longer worked at Statistics Canada. Opportunities exist to strengthen system access permissions through regular monitoring and ensuring that access is limited to employees on a "need-to-know" basis as per the Statistics Canada Security Practices Manual.

Certificate framework: Data Supplying Divisions

The audit examined six of the eleven divisions which provide data for the equalization certificates. Divisions were chosen to ensure coverage of all fields that provide data to the certificate program. Additionally, divisions in which data anomalies had been detected in past submissions were included.

Roles and responsibilities

The audit determined that roles and responsibilities as they relate to the preparation and quality assurance of the data prepared on the divisional templates within the 6 DSDs examined are well defined and communicated. Data for the divisional templates are prepared by economists, analysts and/or client services staff. In all 6 DSDs examined, individuals involved in the equalization program understand they are responsible for the preparation and accuracy of the information. Quality checks are completed prior to program director review.

Within DSDs, directors are the delegated authority for sign-off on the completed divisional templates. They understand that they are responsible for the quality of the information originating in their divisions. As such, their review is designed to provide a final challenge of the information prior to being sent to NAIDD to be incorporated into the certificates.

The audit noted that DSDs have clearly defined roles and responsibilities in place to support the effective management of quality of the data supplied to the equalization certificates.

Procedures and tools

The audit team examined all procedures documents and tools related to the equalization certificates within the six DSDs included in the audit. The audit noted that documentation is in place in five of the six divisions examined and that processes and procedures varied between these divisions. For divisions which require special tabulations for the templates, process documents outline the files to use, the statistical programming files and software required for the correct code for the tabulations, and the appropriate quality assurance activities to check the data to ensure the data are correct. In divisions in which the data can be retrieved directly from CANSIM tables, the documentation notes the applicable CANSIM table the data should be retrieved from, what to check to ensure the data are correct and how to prepare the templates. While the audit noted that the procedures and tools differ between the five divisions, each was tailored to meet the needs of the specific program as they respond to the requirements of the equalization program and were effective tools to ensure the quality of the information.

The audit revealed that in one of the DSDs examined, there was no process documentation in place for the preparation, quality assurance or program director sign-off of data prepared for the template. The person coordinating the submission for this division was new to the process in 2012 and having documentation that outlines the steps for data retrieval and validation would help ensure the all the required steps were completed prior to director sign-off. Additionally, because this division has been subject to data anomalies in past, the implementation of data preparation and quality review requirements documentation would reduce the risk of future data anomalies within these data submissions.

The majority of DSDs examined had effective processes and procedures documents in place to fulfill the requirements of the equalization certificate program. However, opportunities exist to strengthen the quality of equalization data coming from DSDs through the implementation of procedures documents that outline the data to be produced, the methodology to be followed, as well as required quality assurance practices required within divisions that do not have these tools in place.

Recommendations:

It is recommended that the Assistant Chief Statistician of Economic Statistics should ensure that:

  • Monitoring of systems access permissions is carried out on a periodic basis and updated as required;
  • Certificate preparing staff actively monitors business conditions external to the division on a scheduled basis to ensure that risks to the quality of equalization data are identified, assessed and mitigated.

Management response:

Management agrees with the recommendations.

  • The Assistant Director of the HST-EQ Secretariat within NEAD will ensure that regular monitoring of systems access is implemented.

    Deliverables and Timeline: Quarterly report on access rights to designated folder is prepared. This will be completed immediately.
  • The Assistant Director of the HST-EQ Secretariat within NEAD will ensure that a process is in place to monitor risks related to the quality of equalization data.

    Deliverables and Timeline: Develop and deliver a presentation on the process for preparing Equalization certificate and conduct bi-annual consultations with Data Supplying Divisions (DSDs) and Finance Canada, with a subsequent bi-annual report on business conditions affecting the Equalization certificate data. The presentation will be developed and delivered to DSDs prior to the end of the 2013-2014 fiscal year-end. Bi-annual consultations and reporting will begin during the 2013-2014 fiscal year.

Recommendation:

It is recommended that the Assistant Chief Statistician of the Economic Statistics Field and the Assistant Chief Statistician of the Social, Health and Labour Statistics Field should ensure that:

  • Processes and procedures for preparation, quality assurance and sign-off of data submissions are formally documented.

Management response:

Management agrees with the recommendations.

  • The Directors within DSDs will establish standardized processes for preparation, quality assurance and sign-off that are well documented.

    Deliverables and Timeline: Best practices and processes will be identified and standardized across DSDs. Processes and procedures, including quality assurance and sign-off will be documented and implemented. Identification and standardization will be completed by September 2013. Processes and procedures, quality assurance and sign-off within DSDs will be documented and implemented by March 2014.

Objective No. 2: Statistics Canada has appropriate quality assurance mechanisms in place related to the equalization certificate program to ensure compliance with the requirements of the Federal-Provincial Fiscal Arrangements Act.

Quality management

Certificate Preparation Division:
Within NAIDD, effective data quality control points have been integrated into the certificate preparation business process and data provided in the certificates are generally complete, coherent and accurate. However, opportunities exist to strengthen quality management practices by ensuring that validation of formulas within the certificates takes place and ensuring certificates are configured to protect the data and ensure formulas and data cannot be inadvertently overwritten.

Data produced on the revenue base and revenue source certificates correspond to the data specified in the FPFAA regulations.

Data Supplying Divisions:
Data contained in divisional submissions are approved by those with appropriate authority.

The majority of the DSDs examined had effective quality management practices in place to ensure the appropriate validation information on the divisional templates. Assessment of internal quality review, program director challenge and sign-off indicated that the framework could be strengthened by ensuring these processes are formalized and evidence of quality review and challenge is documented in all DSDs.

Quality management practices can be enhanced within DSDs by ensuring the segregation of duties between data preparation and data validation, and contingency plans are in place to ensure DSD submissions can be accurately completed.

Quality management practices within DSDs could be strengthened with the development of procedures to advise NAIDD when data revisions or corrections occur to the data supplied on the divisional templates during the equalization certificate cycle.

The quality management framework for the equalization program should include documented guidance for quality review and approval activities, clear segregation of duties between data preparation and quality review, and formal review and challenge prior to approval and sign-off on data quality. Quality management processes should be integrated into the business practices in place for the preparation of equalization certificates. The Statistics Canada Quality Guidelines note that certification or validation of statistical information should include a challenge of the data rather than a rationalization of the information. This challenge should ensure that data movements, unusual events or uneven growth are understood and can be explained.

Quality management framework: Certificate Preparing Division

The audit found that the data quality control points within NAIDD are effective and have been integrated into the certificate preparation business process. The certificate preparing division typically requests data that have been released in the Daily. Requesting finalized data ensures that the information have been subject to internal quality assurance practices within each DSD. When requesting the data, the NAIDD provides structured templates to each data supplying division. Templates specify the data to be provided, and include a section for DSDs to note methodological, classification or other changes that may impact the data. The audit confirmed that these templates are used by data supplying divisions.

Upon receipt of completed templates, NAIDD performs a number of basic validity checks, including checking against previous submissions, previous year data (growth analysis), and where applicable, validation against CANSIM, other publications and a check of totals. A quality review checklist is in place to support this activity. Unusual movements, variations and other issues are queried with the data supplying division and documented.

The certificate preparing division coordinates three Work-in-Progress reviews: one review with Provincial/Territorial Focal Points, and two reviews with the Department of Finance. Focal Points review provincial and territorial data to be included in the revenue source certificate and the Department of Finance reviews point-in-time versions of the revenue base and revenue source certificates in September and November. These reviews provide a check of coherence and reasonableness. The audit found evidence of items raised through WIP reviews including data challenges, requests for explanations and notices of updates for missing information being queried with DSDs, and responses documented.

Finalized templates are sent by the Assistant Chief Statistician, System of National Accounts Branch to the Office of the Chief Statistician (OCS) for signature. The audit confirmed that the OCS relies upon the data reviews completed within NAIDD and DSDs. This places further importance on the practices put in place by NAIDD and DSDs to mitigate potential risks to the quality of information provided by Statistics Canada to meet the organization's obligation with respect to the FPFAA and regulations.

The audit conducted testing to confirm that the data being supplied by Statistics Canada for the revenue base and revenue source certificates correspond to the data series specified in the FPFAA regulations. The audit tested each reference made to the regulations in the 2011/2012 revenue base certificate template, and in the provincial tabs supporting the 2009/2010 revenue source certificate templates. Each reference made in the templates was validated against the corresponding section of the regulations.

The audit examined the data provided in the base and source certificates for coherence, completeness and accuracy. The audit tested and found that the data on the final certificates matched the DSD templates. The audit also confirmed that the data found in the French and English versions of the certificates are equivalent, units of measure (e.g. kilowatts, tonnes, dollars etc.), and table stub blocks, header blocks and notes blocks have been correctly denoted.

The finalized certificates are linked to specific worksheets. These worksheets contain the data and specific calculations based upon the regulations. The audit tested the calculations on the base and revenue source certificates prepared in 2011 and 2012 and found that the computations on the linked data sheets were coherent and accurate, and that provincial and territorial formulas were equivalent.

The audit found that NAIDD does not validate that the formulas in each cell of the equalization certificates are referenced to the appropriate linked source data sheet or that they have not been overwritten which increases the risks to the quality of the information. Audit testing of the formulas on the revenue base and revenue source certificates prepared in 2011 and 2012 revealed instances of incorrect references and overwritten formulas on the finalized equalization certificates. While data formula and data anomalies were found on the final certificates, the audit noted these inconsistencies did not impact final figures for the years examined.

Overall, NAIDD has implemented effective quality control points within the certificate preparation process to ensure the quality of the information. Opportunities exist to strengthen the quality management practices by ensuring that validation of the formulas within the certificates takes place and ensuring the certificates are configured to protect the data and ensure formulas and data cannot be inadvertently overwritten.

Quality management framework: Data Supplying Divisions

The Statistics Canada Quality Guidelines notes that certification or validation of statistical information should challenge data rather than rationalize the information to help ensure information quality. Additionally, the Guidelines recommend that validation/certification should be carried out by analysts not involved in the production of the data. The audit revealed that the quality management practices followed within DSDs for preparation, validation, and sign-off varied. In five of the six DSDs examined, segregation between data preparation and data validation is in place. In one division in which data anomalies occurred in the 2011 submission, processes rely on a single person for both data retrieval and validation and only one individual in the division has the requisite knowledge to provide the information. There is no contingency plan in the event of an absence. This person-dependent process exposes the data to potential quality or timeliness risks.

Data supplying divisions are responsible for the quality of the information they provide. In five of the six divisions, the audit found evidence that data validation takes place and is documented. Evidence of validation consisted of spreadsheet comparisons to previous years, documented explanations for data large movements, validation against other data sets or provinces, and checks of totals. In the division without process documents there was no documented evidence of data validation occurring.

Program directors are required to sign the divisional template as acknowledgement of their approval of the information being submitted by their division. In 5 of the 6 DSDs examined, the management review of divisional templates is informal and undocumented, but management noted that prior to sign-off they must have assurance that the data are of sufficient quality. This informal review process varied: in some cases the review was general, whereby directors asked only if quality assurance took place (no specific challenge) prior to sign-off, while others provided a more detailed challenge function which included confirming what types of checks were done and how the data differed from previous years prior to providing sign-off.

In one of the six divisions examined, the management review is formalized. A formal presentation is made to the program director, outlining the data, major changes, largest contributors and reasons for large variations. The program director provides a challenge function over the information presented. Queries made by the program director during the challenge are documented, and the analyst must subsequently respond in writing to these queries. When the director is satisfied with the explanations, the templates are signed. The audit found that signatures were in place on all divisional templates in 2011 and 2012 for the six DSDs examined in the audit.

The audit found that the majority of the DSDs examined had effective quality management practices in place to ensure the appropriate validation information on the divisional templates. Assessment of internal quality review, program director challenge and sign-off indicated that the framework could be strengthened by ensuring these processes are formalized and evidence of quality review and challenge is documented. Additionally, DSDs should ensure that segregation of duties is in place between data preparation and data validation, and that contingency plans are in place to ensure DSD submissions can be accurately completed.

Reporting of corrections or revisions

The Directive on Corrections to Daily Releases and Statistical Products has been developed to:

"ensure that a standard and consistent approach is applied for the identification, reporting, documentation, approval, and posting of post-release corrections and unplanned revisions."

The Directive defines corrections, revisions and unplanned revisions as the following:

  • A correction is "the action of eliminating an error to data, text or metadata which was introduced by an error in the design, implementation or execution of a statistical process."
  • A revision is defined as, "a planned statistical activity whereby preliminary data are recompiled when more and better source data become available, or when previously released data are recompiled following the introduction of new classifications, frameworks and methodologies."
  • Finally, an unplanned revision is considered as, "the action of recompiling previously released data in response to an event external to the statistical process and planned statistical activities, and results in significant improvement in the quality of published data or analysis."

The Directive notes that unplanned revisions should be treated with the same due diligence and formal treatment as corrections. The policy notes that unplanned revisions are to be communicated to the senior management responsible for the subject-matter, and that stakeholders should be proactively informed of data updates.

The audit noted that among the DSDs examined during the 2012 certificate process, there were two cases in which data were revised and divisional templates had to be re-signed by the program directors and resubmitted to NAIDD. Interviews and documentation review by the audit team found that in one instance, the revision was defined as "unplanned" and followed the process described in the Directive with a note from the director to the OCS outlining the impact of the revision to the data as well as the impact of the revision to the data provided for the equalization certificate. In the second case, although the revision was not planned, the division did not feel it met the definition of an unplanned revision and therefore did not follow the procedures laid out in the Directive. As a result, it was not reported and was identified only through the quality review completed within NAIDD. Inconsistencies in the reporting of data revisions to NAIDD during the annual certificate process underscore that there is some uncertainty within DSDs with respect to the definitions and reporting requirements outlined in the Directive. This elevates the risk that data on the certificates may not reflect the most accurate and up-to-date information.

The audit team found that quality management practices could be enhanced by ensuring that DSDs develop procedures to advise NAIDD when data revisions or corrections occur to the data supplied on the divisional templates during the equalization certificate cycle.

Recommendation:

It is recommended that the Assistant Chief Statistician of Economic Statistics sh ould ensure that:

  • Equalization templates are validated and configured to prevent inadvertent changes to the data and formulas.

Management response:

Management agrees with the recommendations.

  • The Assistant Director of the HST-EQ Secretariat within NEAD will implement cell protection in order to lock the formulas and data in Equalization worksheets.

    Deliverables and Timeline: Cells protected following validation of data in the Equalization worksheets. This has been completed.

Recommendations:

It is recommended that the Assistant Chief Statistician of the Economic Statistics Field and the Assistant Chief Statistician of the Social, Health and Labour Statistics Field should ensure that:

  • Process documents and practices are updated to ensure that the certificate preparing staff are notified when revisions or data changes take place during the equalization certificate cycle.
  • There is a segregation of duties between data preparation and quality assurance of data for the certificates and that contingency plans are in place to ensure DSD submissions can be accurately completed.
  • Internal quality review and program director challenge prior to sign-off on divisional templates is formalized, and evidence is in place to attest to these checks being completed.

Management response:

Management agrees with the recommendations.

  • The Directors of DSDs will ensure that notification procedures are in place when Equalization data is revised.

    Deliverables and Timeline: Notification procedures will be established by November 2013.
  • The Directors of DSDs will ensure proper separation of data preparation and quality assurance verification of certificate data and that contingency plans are in place.

    Deliverables and Timeline: Implement processes in data supplying divisions that ensure that data preparation, proper Quality Assurance and sign-off are conducted by separate parties. Ensure processes are documented and back-ups are identified and trained. These activities will be completed by March 2014.
  • The Directors of DSDs will ensure that internal quality review of data on divisional templates is documented and a formalized and documented director challenge of template data is carried out prior to Director sign-off.

    Deliverables and Timeline: DSDs will document the results of quality review checks completed prior to submitting the templates to the Director for final challenge and review. Based upon existing best practice, implementation of a formalized Director challenge function of the data for divisional templates prior to sign-off and submission. These activities will be completed by March 2014.

Appendices

Appendix A: Audit criteria

Appendix A: Table 1 Audit criteria
Table summary
The table in Appendix A identifies the Audit Criteria, audit sub-criteria as well as the policy instrument used as the source of these criteria.
Objective / Core Controls / Criteria Sub-Criteria Policy Instrument
1) Statistics Canada has the tools, people and other resources necessary to develop timely, accurate and complete certificates in accordance with the requirements of the Federal-Provincial Fiscal Arrangements Act.
THEME: Certification Framework
CRITERIA: People

1.1 Statistics Canada provides employees with the necessary training, tools, resources and information to support the discharge of their responsibilities.
1.1.1 Employees have access to sufficient tools, such as software, equipment, work methodologies and standard operating procedures. Management Accountability Framework
1.1.2 Processes exist to identify change requirements impacting the equalization certificates, and update tools (guidelines, procedures, templates) on a timely basis.
1.1.3 Statistics Canada identifies resource requirements for the production of equalization certificates and analyses them against existing human resource competencies and capacities.
1.1.4 HR planning exists to address any gaps from the above analysis, and to ensure succession planning.
Accountability

1.2 Authority, responsibility and accountability for the equalization certificate program are clear and communicated.
1.2.1 Roles and responsibilities for data provision, data quality, preparation of certificates, and approval of data are defined and communicated. Management Accountability Framework
Stewardship

1.3 System application controls exist.
1.3.1 Application controls are in place to limit unauthorized access and potential for inappropriate changes. Statistics Canada Security Practices Manual
1.3.2 Procedures exist to ensure that application controls are effective.
Risk Management

2.3 Risk management is applied to the equalization certificate program.
2.3.1 Risks to the timeliness and quality of the certificates are identified, assessed, responded to, and monitored. Management Accountability Framework
2) Statistics Canada has appropriate quality assurance mechanisms in place related to the equalization certificate program to ensure compliance with the requirements of the Federal-Provincial Fiscal Arrangements Act.
THEME: Quality Management
Stewardship

2.1 Quality Assurance reviews take place for certificate data.
2.1.1 Activities needed to ensure data quality are documented and have been integrated into the process for the production of certificate data.

Statistics Canada Quality Guidelines

Federal-Provincial Fiscal Arrangements Act

Directive on Corrections to Daily Releases and Statistical Products

2.1.2 Quality of the certificate data is monitored.
2.1.3 Quality control breakdowns are reported to management.
Accountability

2.2 Equalization certificates are reviewed and approved.
2.2.1 Reporting is reviewed for quality (completeness, accuracy, relevance, timeliness, appropriateness, and reasonableness).

Statistics Canada Quality Guidelines

Federal-Provincial Fiscal Arrangements Act
2.2.2 Approval is evidenced (signoff, email, minutes, etc).

Appendix B: Acronyms

Appendix B: Acronyms
Acronym Description
ACS Assistant Chief Statistician
CS Chief Statistician
DAC Departmental Audit Committee
DSD Data Supplying Division
e-FTS Electronic File Transfer System
FPFAA Federal-Provincial Fiscal Arrangements Act
HST Harmonized Sales Tax
IIA Institute of Internal Auditors
NAIDD National Accounts Integration and Development Division
OCS Office of the Chief Statistician
PDF Portable Document Format
PSSD Public Sector Statistics Division
WIP Work-in-Progress

Changes to the Travel Tours Index of the Consumer Price Index (CPI), effective with the September 2013 CPI

Background

The Consumer Price Index (CPI) measures the rate at which the prices of representative goods and services in a fixed consumer basket change over time. In order to accurately reflect changes in the market and in the behaviour of consumers, Statistics Canada periodically reviews and updates the concepts and methods applied to the various components of the CPI program.

The Travel Tours Index, part of the CPI, was updated with the September 2013 CPI release on October 18, 2013. The Travel Tours component accounts for 0.80% of the 2011 CPI basket by weight and belongs to the Recreation, education and reading index, which is a major component of the CPI.

Prior to this methodology review, the most popular holiday packages were priced according to travel agents’ records in three months of the year, from January to March. The index in other months carried forward the March value and did not change as no pricing was done in those months. The methodology review determined that a significant number of the most popular holiday packages change between March (which ends one collection period) and January (which begins the next collection period) for a given destination. This required a high rate of replacement of holiday packages in the pricing sample. Moreover, based on recent International Travel Survey results, it was clear that the nature of and level of expenditure on Canadians’ leisure trips abroad change significantly from season to season throughout the year.

The aims of this methodology review of the Travel Tours index were a reduction in the replacement rate during data collection and a more accurate reflection of the habits of consumers regarding the timing and nature of their holiday package trip purchases.

The Travel Tours Index Review

On October 18, 2013 with the release of the September 2013 CPI, the following changes were made to the index:

  1. Pricing of holiday packages will occur every month so that the Travel Tours index better reflects the year-round pattern of travel tours purchases.
  2. The sample of destinations was updated to better represent the most popular destinations of leisure trips purchased by Canadians. These destinations were identified using recent International Traveller Survey data (2005-2011). The destination regions  were extended from the United States, Mexico and the Caribbean to include European destinations; furthermore, two more U.S. destinations were added.
  3. The pattern of pricing was changed to better reflect the time at which Canadians actually book their travel tours. Previously, prices were collected one month and four months prior to the departure date for each destination. This pattern was used to reflect the fact that consumers usually book and pay for their holiday packages ahead of time. This general strategy will be carried forward into the new methodology, with an important modification: an examination of booking patterns has indicated that it is better to collect prices two months in advance for American and Caribbean destinations and four months in advance for European destinations and cruise packages.
  4. The outlet sample was reviewed and changed to be more representative of where consumers make their travel tour purchases. The new outlet sample is selected from Statistics Canada's Business Register (BR) from a target population of businesses classified by industry, using the North American Industry Classification System (NAICS 2012) in code 561510 (Travel agencies).
  5. The new outlet sample has increased in size. As before, an outlet sample of travel agencies is drawn from six major Canadian cities with an international airport. Holiday packages will also be priced through Internet databases to provide better coverage. For the Internet price collection, holiday packages will be selected separately from those chosen for travel agencies, allowing a much more diverse product sample to be used in the index calculation.

The updated methodology better reflects the changing consumption patterns and product characteristics of travel tours. It should be noted that the introduction of monthly pricing to a series that has previously been stationary for a large part of the year brings with it increased volatility. In particular, the indicators of change (either 1-month change or 12-month change) no longer remain at the same values for each of the months in the April to December period. Destinations and outlets are now updated more frequently. This regular update process is more effective in capturing changes to the products purchased by consumers, in a more timely fashion.