On the Physical Inventory Quantities add some additional columns to show the total value per item based on the quantity on hand. EG Quantity on Hand = 8, Adjustment Unit Cost = 139.74, Total Cost on Hand = 1117.92

Then have the adjusted total cost being the Counted Quantity ( EG 6) * Adjustment Unit Cost 139.74, Total Adjusted Cost = 838.44, the total variance of -279.48

Also add some fields to the bottom of the screen that total and add the information up as you progress through the stocktake (like the fields at the bottom of the O/E order screen)

Also include this information as standard on the I/C physical inventory reports.

by: Kerry J. | over a year ago | Operations Management