Super Business - Project Management Articles


Sections
Syndication



Reducing the Cost of Timekeeping


In the Real World: Reducing the Cost of Timekeeping
Start example

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:

  1. 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).

  2. 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.)

  3. 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.


338 times read

Related news

» Problems with Timekeeping and Payroll
by admin posted on Nov 01,2009
» Data Collection Methods
by admin posted on Nov 01,2009
» The Need for Time Tracking
by admin posted on Nov 01,2009
» Avoid Job Costing through the Payroll System
by admin posted on Nov 01,2009
» Timekeeping Reports
by admin posted on Nov 01,2009