Going into labour: Problem-solving with QuickBooks

By Peter G. Budreski

Manufacturing companies know the importance of including the cost of labour in the products they create. QuickBooks, with a work-around, can incorporate the cost of labour into a manufactured product.

This can be demonstrated with the case study of MOJO Services Limited. The principal product of the company is prepackaged cloth diapers. This company has 5 full time employees and the accountant of the company advised them that the employees labour cost should be included into the product to allow for the following -

1) Actual unit cost of a package of 24 cloth diapers
2) Efficiency of the employees

Here is how they assessed the problem -

1) After studying the company's labour costs, they determined that an hour's worth of labour cost them $12.50, including benefits.
2) Each package of cloth diapers required one hour of employees time to produce - that included cutting, finishing, folding and packaging.

 

And this is what they did in QuickBooks -

1) A new vendor was added to the Vendor List - not an external vendor, but one named "Internal Labor" - no cheques will ever be issued to this vendor.

 
2) An item was added to the Items List - labeled "Labour" 
 
3) An inventory assembly item was added to the Items List to with one of the components being "Labour".
 
 
 

4) With the lists in QuickBooks updated, the next step in the process was to get the labor cost into inventory. How accomplished? Simple - determine the predicted monthly hours to be worked by the staff and enter a bill. The staff at MOJO Services Limited typically work 880 hours in a month, but to accommodate extra hours, they enter a bill for 1,000 hours @ $12.50 at the beginning of the month.

 

5) After a productive month, MOJO has produced 950 bags of cloth diapers. They review their Inventory Valuation Summary Report and ascertain that there is still $625 of labour in inventory - time for a change as they say in the business. To continue the process, they need to enter another bill - credit to remove the $625 of labour in inventory.

 
 

6) To wrap it up, one last step - the month end AP Aging summary show that MOJO still owes the vendor "Internal Labour" $11,875, which of course, requires a change also.

 

7) MOJO tracks its production labour separately from its administrative staff - in its Chart of Accounts list, there are two Cost of Goods Sold accounts -
a) Production Labour
b) Production Labour Recovered

8) The final step in the process is to enter a bill - credit for the apparent balance owing to the vendor "Internal Labour".

 

 

The month end bill-credit will create a credit balance in the cost of goods sold section of the profit & loss statement for comparison to the actual production labor costs for the month. For the month of April 2007, MOJO recorded actual production labour costs of $12,890 and recovered $11,875 of this into product costs, implying that $1,015 of actual production labour was expended for shop clean-up and equipment maintenance, well within the parameters that owners of MOJO Services Limited  had set-up.

The whole process is repeated at the start of the next month.

The approach demonstrated here can also be applied to other aspects of manufacturing and production.
 

 

About the author:

Peter Budreski has been a Chartered Accountant for over 25 years based in Halifax, Nova Scotia, is President of TCOB Computer Solutions and a Vice President of Certified Software Labs Inc., based in Toronto, Ontario.

TCOB’s mission statement states that it provides clients with the most efficient means of dealing with accounting data, the maximum useful information from their accounting systems, and a view to more effective utilization of resources through training and technology implementation in a simplified manner.

Peter is a Certified QuickBooks ProAdvisor, speaker at Discovery and is a Certified Regional Trainer for Intuit Canada. Peter is a member of the VOA (Voice of Advisor) and VOT (Voice of Trainer) councils of Intuit Canada. He participates in ongoing conferences regarding emerging business & technology issues. Additionally, Peter is a certified QuickBooks Consultant with the Sleeter Group, based in Pleasanton, California and a member of the Association of QuickBooks Technologists based in West Palm Beach, Florida.

 

You may like these other stories...

No field likes its buzzwords more than technology, and one of today's leading terms is "the cloud." But it's not just a matter of knowing what's fashionable. Accounting professionals who know how to use...
There is a growing trend of accountants moving away from traditional compliance work to more advisory work. Client demand is there, but it is up to the accountants to capitalize on that. What should accountants' roles be...
 Event Date: April 24, 2014 In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel. David will introduce the Macro Recorder, which transforms actions...

Upcoming CPE Webinars

Apr 17
In this exciting presentation Excel expert David H. Ringstrom, CPA shares tricks that you can use with pivot tables every day. Remember, either you work Excel, or it works you!
Apr 22
Is everyone at your organization meeting your client service expectations? Let client service expert, Kristen Rampe, CPA help you establish a reputation of top-tier service in every facet of your firm during this one hour webinar.
Apr 24
In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
Apr 25
This material focuses on the principles of accounting for non-profit organizations' revenues. It will include discussions of revenue recognition for cash and non-cash contributions as well as other revenues commonly received by non-profit organizations.