Physical Evaluation Variance Report by Item Warehouse

How to print: Enter 1 at the Physical Inventory Evaluation Report Screen. The system generates this version of the report only if you use FIFO costing; see Part M: FIFO Costing.

CWDirect Rel 3.5 Physical Evaluation Variance Report EKAPLAN INR1292 1/08/99 5:19:41 Page 1 By Item Warehouse Level - Unit Variance EZK Mail Order Control #: 1 Partial physical Warehouse 2 MAIN WAREHOUSE Eval Unit Eval O/H Var Cost Unit Item SKU Count O/H Qty Var Ext Cost Ext Cost Ext Cost % Var % Var PEN 220 100 120 220.0000 100.0000 120.0000 120.00 120.00 BRUSH GREN LRGE 0 0 0 .0000 .0000 .0000 100.00 100.00 A 0 93 93- .0000 .0000 .0000 100.00 100.00- CONTROL #: 1 220 193 27 220.0000 100.0000 120.0000

Contents:

• physical inventory control number

• whether the report is for a complete physical or a partial physical

• warehouse code and description

• item

• SKU

• the count quantity used to evaluate variance (Evaluation count) for all warehouse locations included in the physical inventory

• on-hand quantity on record before the physical inventory (On-hand quantity) for all warehouse locations included in the physical inventory

• unit variance, calculated by subtracting the Evaluation count from the on-hand quantity for the item location

• evaluation extended cost, calculated by adding the extended cost derived from all FIFO layers selected by the standard hierarchy

• on-hand extended cost, calculated by adding the extended cost from all FIFO layers for the SKU within the warehouse

• extended cost variance, calculated by comparing the evaluation extended cost with the on-hand extended cost

• cost percentage variance, calculated by dividing the variance extended cost by the on-hand extended cost

• unit percentage variance, calculated by dividing the Unit variance by the on-hand quantity

• batch control number