lmk223a
|
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)
|