ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Work in Process
http://www.istechforum.com/YaBB.pl?num=1115040799

Message started by David Waldmann on 05/02/05 at 05:33:19

Title: Work in Process
Post by David Waldmann on 05/02/05 at 05:33:19

Is there any good way to find out what is actually in Work in Process? The numbers in my GL WIP account just don't seem reasonable. Is the relationship between the actual and GL something that should also be checked on a monthly basis and adjusted?

Title: Re: Work in Process
Post by Lynn Pantic on 05/02/05 at 07:14:10

The columns in the JC-M report are based on the transaction detail you can look at in JC-C, D, E and Q if you want to look at the transactions contributing to the net WIP and see where they may be coming from.

Title: Re: Work in Process
Post by David Waldmann on 05/02/05 at 08:31:54

That's not really what I'm looking for. Maybe because what I'm looking for doesn't exist. When material/labor is issued in WO-G, is it just the costs that are put in WIP, or are the quantities/items put somewhere?

What I'm looking for is a report that says "143 BF of 4/4 Oak is in WIP, and 3.4 hrs of Labor". Otherwise, how do you reconcile it?

Title: Re: Work in Process
Post by cathyh on 05/02/05 at 09:12:08

And JC-P will list materials in WIP by part number or Work order. Are you looking for a combination of the two reports, JC-C and JC-P? I don't think that exists, but you could probably create it in Access or maybe Crystal.
We dod check the WIP in GL and the number on the WIP summary and balance them every month. The numbers for labor and materials on the WIP summary are for items both still in wip and also in finished production. Only the total on the right is the one you should compare to your WIP in the GL. If you are trying to get labor and materials totals from the wip summary and have unclosed finished or partially finished work orders, you need to do some math.

Title: Re: Work in Process
Post by David Waldmann on 05/02/05 at 11:04:35

That's exactly what I was looking for. I guess if it were a bear it would have bit me. :-[

Title: Re: Work in Process
Post by lmk223a on 05/03/05 at 06:09:21

I may be in the minority of DBA/EVA users, but every month I analyze WIP by components of labor, material and loads, for which separate GL accounts are maintained.

I use JC-P to reconcile WIP material only.

I use JC-C for monthly labor hours/$ which I import into an Excel spreadsheet anaylzing each work order and apportion WIP labor costs by percentage complete. (i.e. if a work order was completed/closed during the month all labor costs must be removed from WIP-Labor or if 5/10 units were completed during the month, 50% of labor costs are removed) I use a beginning balance, add the current month labor, and determine those labor costs that should remain in WIP-Labor.

The fixed and variable loads are calculated based on monthend labor hours (determined by monthend WIP-Labor dollars divided by labor rate)

WIP Material and labor variations are recorded into one GL account which we call Inventory Shrinkage (RM & FG variations also use this account)