Weighted Average Cost Material Calculations

[Kit]

Hi,

I'm working on a client site where we need to track an accurate WAC through out a partial work order. In example, if we have a WO for 1000 units and issue a single WO completion the WAC calculates correctly. If we issue 10 WO completions of 100 units each, all of the material is billed up front on the first 100 unit WO completion. We would ideally like this material cost to be spread out amongst all 10 of the WO completions. Is there a way to force the system to spread out the material costs? It seems to be spreading out the labor costs.

I have attached an excel sheet that kind of shows what I'm trying to say.

Thanks,
Kit

 

[John D]

Review your Bill of Material to update Inventory Issue as 'Backflush'. When workorders are partially completed at multiple times, this option would calcualte parts list quantity to be issued based on completed quantity. I hope this might resolve your issue.