17 February 2014

The proper way to report headcount

It never ceases to amaze me how a simple operation like reporting how many people work for you can be so routinely manipulated:

  • if a layoff occurs on the last day of a reporting period, many managers will disclaim responsibility for the people who actually worked during the period, saying that their effective headcount is the people who remain.
  • other managers may farm out significant roles to agency workers or outside consultants, and not report such activity.
  • others who are on leave of absence are ignored until their return to work.
  • conversely, there are other managers who report the positions they are responsible for, whether or not they are actually filled, and whether or not one person is filling more than one position!
These areas (among others) contribute to unreliability in reporting and unpredictability in forecasting future needs. I would like to summarize some current best practice (of which a more precise summary is given here), in the hope that it will help to improve what has been a rather messy situation.

What to report?

Managers must be held responsible for all activity that arises from the areas under their control, and there are several critical areas that need to be covered:
  • staff who are on payroll (segregated into full-time, temporary/casual, and part-time)
  • non-staff payroll (segregated into contingent labour and consultants)
  • actual vs full-time equivalent (FTE) headcount
  • internships
  • workers on paid leave
  • workers on unpaid leave
  • workers who are on short-term or long-term disability, who are expected to return to work
  • sickness and absence costs
  • hours worked
  • overtime hours
  • vacancies at the end of the reporting period
  • training costs
This is a much broader definition than what is given by Statistics Canada for its reporting, but it more properly reflects reality.

Definition of "headcount" - payroll employees

Segregate between:
  • Permanent employees: those with contracts without expiry dates or on fixed-term contracts lasting more than 12 months
  • Temporary/casual: those, excluding agency workers, with fixed-term contracts of 12 months or less, or are employed on a casual basis
  • Part-time: those who work less than an organization's normal weekly hours

Include:
  • Agency workers, when paid directly from payroll
  • Those temporarily absent but still on the payroll (ie, on maternity leave)
  • Seconded employees, where the organization is paying 50% or more of the related payroll cost
  • Workers who only work part of the year, where they are being paid at the reporting date
  • All those on paid leave
Exclude:
  • Agency and other workers not paid directly from the payroll
  • Seconded employees, where the organization is paying less than half the related payroll cost
  • Self-employed workers
  • Voluntary workers
  • Former employees only receiving a pension
  • Directors who do not receive a salary
  • Workers who only work part of the year, where they are not being paid at the reporting date
  • All those on career breaks
  • All those on unpaid leave

Definition of "headcount" - non-payroll workforce

Segregate between:
  • Contingent labour: workers engaged to cover business-as-usual or service delivery activities within an organization (whether agency workers, interim managers or more comprehensive outsourcing arrangements)
  • Consultants: those providing management with objective advice relating to strategy, structure, management or operations of an organization, in pursuit of its purposes and objectives.

Counting workers

Headcount relates to the number of workers paid by or for the organization.

While all reporting must include continuity schedules that detail all activity affecting headcounts from opening to closing amounts (ie, hires, exits, going to and returning from leave, and so on), this must be compared to the full-time equivalents for the work actually performed during the reporting period. There are certain critical points to consider:
  • Exclude overtime hours from FTE calculations
  • Include the contracted working hours for each employee that worked during the reporting period, whether working, temporarily absent or on paid leave during that time
  • Divide by the standard working hours of the organization
For the non-payroll workforce, hours must be gathered for all activity worked , in order to perform similar calculations. The related agreements and invoices rendered must note this information.

Other areas to consider

There are other areas that may be required, or may otherwise prove useful for reporting or forecasting purposes:
  • diversity of the workforce
  • workforce by age
  • workforce by seniority

Method of reporting

The type of reporting really needs to be configured to the needs of the organization, but the above data must all be presented in it in a logical way. I prefer continuity schedules to prove movements from beginning to end, and from one bucket to another (ie, change of status from one category to another, going to and returning from paid or unpaid leave). Care is required in designing these reports, or the presentation of the data may otherwise prove cumbersome and difficult to understand. Many examples can be found in web searches, especially in the education sector.

10 February 2014

Painless wire-transfer instructions

For many business users, composing wire-transfer instructions for transmitting funds to Canadian banks can be rather frustrating, because the banks themselves do not present the syntax in a way that can be converted to the internationally recognized SWIFT MT103 format. The templates I have seen do not even allow for fillable formats for on-screen entry and validation before printing and forwarding, let along ease of use for on-screen data entry such as is used in other countries. Here are some pointers that I have gathered which may be of use.

Scenario: transmission of CAD funds to a Canadian bank (details of beneficiary)

BankCanadian Imperial Bank of Commerce (010) (SWIFT CIBCCATT)
Transit (branch)aaaaa
Account numberxx-xxxxx
Branch address123 ANYWHERE ST
ST JOHN'S, NL  A1A 1A1
CANADA
Beneficiary name and addressJOHN Q. DOE
456 ELSEWHERE AV
ST JOHN'S, NL  A1A 1A2
Remittance informationEither description or reference - in this case, assume payment reference is 123456789
Responsibility for wire chargesBeneficiary (BEN)/Sender (OUR)/Shared (SHA) - in this case, assume BEN

The key fields will be laid out as follows:

Field tagField nameFormat to be entered
:57AAccount with institutionSWIFT BIC: CIBCCATT
//CC0010aaaaa
:59Beneficiaryxx-xxxxx
JOHN Q. DOE
456 ELSEWHERE AV
ST JOHN'S, NL  A1A 1A2
:70Remittance information123456789
:71ADetails of chargesBEN

There are some possible variations:
  • If the beneficiary has obtained his own SWIFT Business Entity Identifier, use tag :59A and enter the account number and BEI only.
  • The beneficiary's bank may require the insertion of the branch's address as well, in which case use tag :57D
 I hope this clarifies matters for some users.

03 February 2014

Tracking systems to make your work easier

Bugzilla Lifecycle color-aqua

One of the impacts of implementing ISO 9000 systems has been the necessity to be able to track issues from initiation to resolution, and changes to company documentation. There are too many instances, which I am familiar with, of organizations attempting to set these up from scratch. Such developments often have fuzzy goals, expenditures that seem to be out of control, inordinate wastes of time, and a failure rate that is all too high. And that's before updating and maintenance!


The above chart shows a bug lifecycle chart as implemented in Bugzilla, a rather good issue-tracking application that is really open-source software. It has great reviews, is very flexible, and is worth checking out.
Revision controlled project visualization-2010-24-02
For tracking of document changes, Subversion is a great open-source revision control application as well, which can be integrated with many other applications as well for tracking company documents, software documentation, and the like. 

Why don't Canadian businesses invest?

The tendency of Canadian businesses to under-invest has been noted for decades, and the Fraser Institute reported in 2017 that investment f...