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

If you're thinking that bitcoin and digital currency generally are merely some one-off flash in the pan, the new Digital Currency Council would argue otherwise. The council launched in September and already had 400...
Sponsored Content from Confirmation.com: AccountingWEB takes a look at confirmations in audit engagements, how they can serve as a doorway to fraud, and what you can do about it. Today, auditors have to fight fire with...
If your small-business clients are on the fence about cloud accounting, they've got plenty of company. A recent survey by market researcher and consultant Software Advice indicates a decidedly mixed view by respondents...

Already a member? log in here.

Upcoming CPE Webinars

Oct 21Kristen Rampe will share how to speak and write more effectively by understanding your own and your audience’s communication style.
Oct 22This webinar will include discussions of important issues in AU-C 800, Audits of Financial Statements Prepared in Accordance with Special Purpose Frameworks.
Oct 23Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.
Oct 30Many Excel users have a love-hate relationship with workbook links.