A routine analysis of the system costs at a large
manufacturing facility discovered that the cost of administering the company's
direct labor timekeeping system appeared to be inordinately high. Approximately
50 percent of the entire cost accounting function was devoted to the collection
and interpretation of data related to direct labor. The controller asked a cost
accountant, Ms. Anna North, to investigate the situation and recommend a revised
system that would generate usable information, while costing as little as
possible to administer.
The cost accountant's plan for this analysis was to, first,
determine the level of detailed information collected by the timekeeping system,
second, calculate the cost of collecting it,
and then determine the benefit of using the resulting information. She would
then see if costs could be reduced for the existing collection system, while
losing no benefits from the system. If this was not possible, or if the costs
could be reduced only by a modest amount, then she would investigate the
possibility of reducing the level of information gathered, which in turn would
reduce the cost of data collection.
Ms. North's first step was to determine the level of detailed
information collected by the timekeeping system. She interviewed the facility's
controller, Ms. Barbara MacCauley, who said that the timekeeping system required
employees to write down on a time sheet the hours they worked each day on
specific jobs, as well as the workstations where they worked on each job. The
typical time sheet looked like the one shown in Exhibit 2.5.
It was apparent from the time sheet that each employee must
carefully enter a large amount of information during the course of a shift.
Also, the information entered by the employee in the example was not easy to
read, making it likely that the person who entered this information into the
computer would have a difficult time doing so correctly. Further, many time
sheets were submitted each day by the 412 direct labor personnel at the
facility, some of which were lost by employees or during the data entry process.
This information had to be re-created, which could only be done through
estimates of the work an employee completed during the period.
Ms. North found that these three issues gave rise to three
different types of costs. The first cost was the time required by employees to
enter their time worked onto each time sheet and then transport that time sheet
to the payroll office for data entry. The second cost was for the data entry
staff to initially enter the data into the computer; the third cost was to track
down and correct any missing information or to correct data that was
inaccurately entered. Ms. North calculated these costs for a typical month in
the following manner:
-
Cost to initially record data. She
estimated that each employee required 10 minutes per day to complete and deliver
his or her time sheets. Since the average burdened cost per hour for all 412
employees was $17.92, this resulted in a monthly cost of $25,869 to collect the
information, assuming 21 business days per month (412 employees x 21 days x
$2.99/day).
-
Cost to enter data into computer
system. She found that one and a half employees were required in the
accounting department on a full-time basis to enter into the computer system the
information from all 412 time sheets. These hourly employees earned a burdened
wage of $12.05 per hour. This resulted in a monthly cost of $3,037 (1.5
employees x 21 days x 8 hours/day x $12.05/hour.)
-
Cost to correct data errors. On
average, the accounting staff spent three hours per day correcting errors that
had been discovered on time sheets or created during data entry. These errors
were investigated and corrected by a senior data entry clerk, whose hourly
burdened pay was $15.28. This resulted in a monthly cost of $963 (3 hours x 21
days x $15.28).
The grand total of all these costs was $29,869 per month, or
$358,428 per year.
Ms. North's next task, determining the value of the benefits
derived from the timekeeping system, was much more difficult. She found that the
number of daily hours worked was used by the payroll staff to calculate and pay
weekly wages to the direct labor employees. She described this function as a
mandatory one for which the system had to provide sufficient data to calculate
the payroll, but she could not ascribe to it a monetary value.
Next she looked at the benefit of tracking hours by job worked.
This information was used by the cost accounting staff to develop an income
statement for each job, which the sales staff used to revise its pricing
estimates for future jobs, to verify that pricing levels were sufficiently high
to ensure a targeted profitability level per job of 30 percent. The proportion
of direct labor to all job costs was about one-third, so this was considered a
significant cost that must be tracked for this purpose. The pricing staff
members assured the cost accountant that they frequently altered their pricing
strategies in accordance with the information they received through the job
income statements. Once again, Ms. North found herself unable to clearly
quantify a benefit associated with the tracking of direct labor hours, this time
in relation to job numbers, but it appeared that obtaining the information was
mandatory.
Ms. North's last benefits-related task was to quantify the benefit
of tracking labor hours by workstation within each job. She found that this
information was only used by the industrial engineering staff, whose members summarized the information into a
report that listed the total hours worked at each workstation, by day, so that
they could determine when capacity utilization levels were reaching such heights
that new equipment had to be purchased or when levels were so low that existing
equipment could be sold. A brief discussion with the production scheduling staff
revealed that standard capacity amounts per job were already stored in the labor
routings of the facility's manufacturing resources planning (MRP II) system,
which produced a similar report by multiplying the units in the production
schedule by the hours per unit of production listed in the labor routings. This
meant that an alternative system could be used to provide the industrial
engineering staff with the information it needed, without resorting to
additional data entry to provide this information.
Ms. North then perused sample time sheets submitted by employees
and noted that an average of three workstations were referenced on each time
sheet for each job on which work was performed. If she could convince the
management staff to eliminate the tracking of time by workstation, she could cut
the labor time spent by the direct labor employees on timekeeping by two-thirds,
plus similar amounts by the data entry clerks who would otherwise have to enter
and correct this information, since these additional entries would no longer
have to be made. This worked out to a cost savings of $19,912 per month ($29,869
x 2/3), or $238,950 per year.
Ms. North realized that the industrial engineering staff
would agree to this change only if she could prove that the data the staff
received from the MRP II system was sufficiently accurate to replace the
workstation capacity data it had been receiving from the timekeeping system. To
ensure that the MRP II system maintained a high level of labor-routing accuracy
(which was the prime driver of the accuracy of capacity information produced by
the MRP II system), she added $50,000 back to her estimate of remaining
timekeeping system costs, which would pay for an engineer whose sole purpose was to continually review the accuracy of labor
routings. This resulted in a timekeeping system cost of $169,478, which still
represented a reduction of $188,950 from the earlier timekeeping system, for a
drop in costs of 53 percent.