SCStock Count Studio

Stock Count Studio

Methods and worked example

The exact calculation, assumptions, rounding and limits behind the free tool.

What is calculated

For each row, quantity difference = counted quantity − recorded quantity. Signed reference-value difference = quantity difference × entered reference unit cost. Net reference-value difference is the sum of signed row values. Absolute reference-value variance is the sum of their absolute values. Exact-match rate = rows with an exact quantity match ÷ all five entered rows × 100.

Read the worked example

Rows A and B have −2 and +2 units at $5, row D has −1 at $20, and C and E match. That gives −$20 net reference value, $40 absolute reference-value variance and two exact matches out of five (40%). The measure describes the selected sample; it is not a claim about the whole store.

Important boundaries

All five rows are included, including a zero-versus-zero row. Use actual selected stock lines rather than blank zero rows if you want a meaningful exact-match rate. Fractional quantities are allowed for businesses whose counting units permit them. Use the same unit on both sides of each comparison. Costs are user-supplied reference values, not independently verified valuations. The tool does not identify theft, authorize adjustments, update stock or provide accounting records.

Use with the review workflow

Define scope and cutoff, record first observations, independently recount exceptions, document evidence and obtain approval through your own system. The downloadable sheets support those steps. Refreshing or closing the page discards entries unless you download the scenario.

Testing and corrections

The publication includes constructed examples designed to be reproducible. If a result looks wrong, note the inputs, the result and the outcome you expected, then contact the publisher. Avoid emailing confidential records. We update material when we identify a supported correction.