Stock Counting and Variance Report Values

Opening Value

Stock at start of period (taken from system count or overridden by manual stock count).

Net Receipts

Stock received from suppliers.

Net Transfers

Stock moved between venues.

Net Manufacturing

Stock produced internally.

Net Adjustments

Manual changes (incoming, damage, waste).

Closing Value

Stock at end of period.

Actual Usage

What was really used.

(Opening + Receipts + Transfers + Manufacturing + Adjustments) – Closing

Theo Sold

Expected stock used based on sales.

Waste

Recorded wastage.

Theo Usage

Expected total used.

Theo Sold + Waste

Variance

Difference between actual and theoretical usage.

Actual Usage – Theo Usage

Theo Closing

System-predicted closing stock.

Opening + Receipts + Transfers + Manufacturing + Adjustments – Theo Usage