WORK IN PROCESS

[mcongdon]

I WAS INTERESTED IN HOW OTHER DEALERS ARE JUSTIFYING THERE WORK IN PROCESS AND HOW DOES THE ROLL OVER FROM THE PREVIOUS MONTH FACTOR IN AND IF YOU HAVE ADP HOW ARE YOU DEALING WITH DOUBLE BOOKINGS.

[robc]

I haven't heard anything about the ADP booking difference. WIP is an asset, you buy the tech's time today, put it on the shelf and sell it tomorrow. Are you finding that it is counting this as a sale in both months?

------------------
** Rob, Editor Dealersedge/WD&S **
Help is only a message post away!
robc@dealersedge.com

[helpers1]

As a controller, part of my month-end process is to accrue payroll "earned" in the current month, but won't be "paid" until the following month. To get this figure for WIP, I look at previous weeks' payroll for that account, and accrue an educated "guess" for the unpaid days. Once the new month hits, I reverse this entry as the payroll will post the true amount. Back to month-end - I balance the WIP account with the open ro report. In ADP, I look at "RWP" ran "with accounting detail". Just last month we found a problem (we are new to ADP) that the mgr's had forgotten - when a tech gets a raise, you have to remember to adjust his pay in the service side of the computer so your ro's will calculate the proper cost of sale. Any other suggestions about keeping this account clean are appreciated --

[no_account]

As a former controller and system administrator for a dealer with an ADP system with ERO I ran RTH summary report from the start of the current pay period to the end of the month to get the hours for my accrued payroll. Just plugged the sold hrs into an Excel spreadsheet with the pay rate already entered, to give me the figure for my accrual. If the pay period is updated as it should (can be set to update automaticaly) multiple postings shold not be a problem. After the accrual use the WIP report from the month-end jobstack to reconcile the work in process accounts and post adjustment to adjusted cost of labor.

[This message has been edited by no_account (edited 04-06-2006).]