Original practice scenario: A hypothetical beverage distributor tracks filled bottles, returned empties, damaged containers and deposits. Explain the data grains and controls for a reusable-container report.
Read model answer +
Keep physical container movements and monetary deposit entries separate, linking them through explicit references. Beverage volume, container count and deposit balance are different measures with different adjustments.
Work through it
Identify container type, route, counterparty and movement event, preserving receipt, dispatch, damage and correction categories without converting every event into a sale.
Aggregate physical flows independently, then compare opening containers plus receipts minus dispatches and authorized losses with closing observations.
Prepare deposit accounting at its own transaction grain and reconcile linked container movements, returning unmatched references and contract exceptions for review.
Tradeoffs to discuss
Detailed event tracking supports investigation but increases capture requirements; aggregate route counts are simpler while leaving more ambiguity about individual losses.
Common pitfalls
Do not assume every container type carries the same deposit or holds the same volume.
A returned empty is not negative beverage demand and should not cancel an unrelated sales line.
Original practice scenario: A hypothetical beverage producer sees a surge in distributor orders before a promotion. How would you test whether it reflects consumer consumption or inventory accumulation?
Read model answer +
Treat orders, shipments, channel inventory and consumer sales as different signals. Upstream ordering can shift demand between periods without a corresponding change in final consumption.
Work through it
Align the product, channel and time grains, documenting coverage and reporting delays for inventory and downstream sales rather than assuming complete visibility.
Compare ordering changes with sell-through, stock levels, promotion timing and later replenishment, using seasonal baselines and consistent product specifications.
Evaluate whether a surge is followed by lower orders or inventory drawdown, reporting uncertainty where downstream observations are missing.
Tradeoffs to discuss
Upstream orders arrive quickly but are influenced by purchasing behavior; consumer sales are closer to consumption while often delayed or incomplete.
Common pitfalls
Do not label promotional pipeline filling as a permanent increase in demand.
Changes in distributor coverage or shipment allocation can mimic growth even when comparable consumer activity is unchanged.
