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

How are you planning? What tools do you use (or fail to use) for forecasting? PlanGuru is a business budgeting, forecasting, and performance review software company based in White Plains, N.Y. AccountingWEB recently spoke...
Event Date: October 30, 2014, 2 pm ETMany Excel users have a love-hate relationship with workbook links. For the uninitiated, workbook links allow you to connect one Microsoft Excel spreadsheet to other spreadsheets, Word...
Event Date: September 9, 2014, 2:00 pm ETIn this session we'll discuss the types of technologies and their uses in a small accounting firm office. Included will be:The networked office: connecting everything together for...

Already a member? log in here.

Upcoming CPE Webinars

Aug 26
This webcast will include discussions of recently issued, commonly-applicable Accounting Standards Updates for non-public, non-governmental entities.
Aug 28
Excel spreadsheets are often akin to the American Wild West, where users can input anything they want into any worksheet cell. Excel's Data Validation feature allows you to restrict user inputs to selected choices, but there are many nuances to the feature that often trip users up.
Sep 9
In this session we'll discuss the types of technologies and their uses in a small accounting firm office.
Sep 11
This webcast will include discussions of commonly-applicable Clarified Auditing Standards for audits of non-public, non-governmental entities.