Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        Interviews in Supply chain analytics

        Work in the tool while you explain your decisions.

        Choose a role and level. Each interview has a new task, follow-up questions and a report that checks your work and your explanation.

        Speak or type. Sign in to save your results across devices.

        Timed assessment

        • 12 practical questions
        • 45 minutes
        • Mid level

        Questions are drawn from a bank of 36. Your report includes a skill breakdown and lessons to practice next.

        Practice interviews

        Junior tasks cover the fundamentals. Mid and senior tasks add debugging, changing requirements and review decisions.

        10 interviews

        • Supply chain analyst
        • Junior
        • 30 min

        Net requirements

        Calculate demand minus usable stock, with a minimum of zero. Usable stock is physical stock minus quarantined stock. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricNet requirements
        • Quarantine remains in the physical count but cannot fulfill customer demand. I would reconcile physical units to released units before calculating the net requirement. Otherwise the plan understates the purchase needed. The row-level quarantine status must agree with the stock snapshot date; a release tomorrow cannot satisfy demand due today.
        • Usable supply rises by 10 units while the physical count stays unchanged. Reduce quarantine by 10 and recalculate the net requirement, which falls by 10 until it reaches zero. Do not add the released units to physical stock as well: that would count the same movement twice. Verify the release is effective before demand is due.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • Supply chain analyst
        • Junior
        • 30 min

        Inventory position

        Calculate usable on-hand plus confirmed inbound minus backorders. Exclude unconfirmed inbound. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricInventory position
        • On-hand stock does not include the full planning commitment. Backorders consume supply, while confirmed inbound adds future availability. I would reconcile inventory position to on-hand plus confirmed inbound minus backorders and compare that position with the policy trigger. Unconfirmed receipts stay outside the base plan and belong in a separate scenario.
        • Inventory position falls by 20 units even though current physical stock does not move. Remove the canceled receipt from confirmed inbound, recalculate the position, and reassess the trigger. Keep the cancellation separate from an actual goods issue, because recording it as a stock withdrawal would corrupt the physical balance and could double-count the shortage.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • Supply chain analyst
        • Junior
        • 30 min

        Inventory turns at cost

        Calculate annual COGS divided by average inventory at cost. Return 0 when average inventory is zero. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricInventory turns at cost
        • Revenue includes margin while inventory is valued at cost, so the two sides use different valuation bases. Ending stock is also a single snapshot that may reflect a late receipt. Use annual COGS over average inventory at cost, document the averaging convention, and compare the same period. A zero inventory denominator needs explicit treatment.
        • Turns halve because the numerator is unchanged and the denominator doubles. I would verify that the extra inventory belongs to the same cost basis and year before interpreting the movement. Then inspect stockouts, service and aging: lower turns alone do not tell us whether the extra buffer is justified or obsolete.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • Supply chain analyst
        • Mid
        • 30 min

        Three-period moving average

        Forecast period four as the mean of periods one, two and three. Do not use period-four actual demand. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricThree-period moving average
        • Including period-four actual demand in the forecast for period four leaks the answer into the model. Build each forecast from observations that existed before its issue date, then score it on the held-out actual. Keep the horizon and update schedule fixed so a model with more recent information does not get an unfair comparison.
        • The already-issued forecast stays fixed. Its forecast error changes, and the new actual becomes an input for the next rolling forecast. Replacing the archived forecast with a revised value would erase the miss and break the backtest. Preserve the issue timestamp and version so later planning adjustments can be evaluated separately.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • Supply chain analyst
        • Mid
        • 30 min

        ABC annual usage value

        Calculate annual usage value as annual units consumed times unit cost. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricABC annual usage value
        • ABC ranks annual consumption value, which combines consumed units and unit cost. A costly spare with little consumption can rank below a cheap fast mover. Calculate usage value before sorting and applying cumulative policy cutoffs. Criticality is a separate dimension: a low-value spare may still need protection because an outage would stop production.
        • This SKU's annual usage value doubles. Recalculate the total across every SKU, resort the list, and rebuild all cumulative shares before assigning classes. Its own class and other items near a cutoff may change. Simply doubling its percentage while keeping the old denominator would produce a share that no longer reconciles to the portfolio.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • Supply chain analyst
        • Mid
        • 30 min

        Safety stock with fixed lead time

        Calculate z times daily demand standard deviation times SQRT(lead-time days). Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricSafety stock with fixed lead time
        • Independent daily variances add over the lead time; standard deviations do not. For fixed lead time, multiply daily standard deviation by the square root of days and then by z. Multiplying by days overstates this model's uncertainty. If daily demands are correlated or intermittent, test those assumptions before using the normal approximation.
        • Safety stock doubles because the square root of lead time rises from three to six, while daily variability and z stay fixed. Expected lead-time demand quadruples, so the reorder point does not simply double. Recalculate the expected-demand component and the safety component separately, then check whether the longer lead time remains operationally stable.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • Supply chain analyst
        • Mid
        • 30 min

        Reorder points

        Calculate mean daily demand times lead-time days plus safety stock. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricReorder points
        • The reorder point covers expected lead-time demand plus safety stock, while position includes confirmed inbound and backorders. Comparing only on-hand can order again for units already on the way or overlook existing obligations. Reconcile the position first, then apply the trigger. Check whether confirmed receipts actually arrive before the demand they are meant to cover.
        • The expected-demand component rises by 70 units, so the reorder point rises by 70 if safety stock is unchanged. Recheck whether the higher average demand also changes the variability model; do not automatically hold the safety assumption forever. Compare the revised point with current position and state whether a new purchase is triggered.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • Supply chain analyst
        • Senior
        • 30 min

        Pack sizes and order multiples

        Round the positive net requirement up to a whole pack. Return 0 when net requirement is negative or zero. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricPack sizes and order multiples
        • The order rises from 144 units, or six packs, to 168 units, or seven packs. That one-unit increase crosses a pack boundary and creates 23 units above the requirement. I would show the excess explicitly and check storage and expiry before ordering. Do not describe the difference as forecast error; it comes from the supplier constraint.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • A requirement exactly divisible by pack size must remain unchanged. Rounding a quotient down and always adding one orders an extra carton at that boundary. Test exact multiples, a value just above a multiple, and a zero requirement. Then check any supplier minimum separately; pack size and minimum order quantity are different constraints.
        • Supply chain analyst
        • Senior
        • 30 min

        Landed unit cost

        Divide purchase cost plus freight plus nonrecoverable duty by received units minus damaged units. Exclude recoverable tax. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricLanded unit cost
        • Sellable units fall by 10 and landed cost per sellable unit rises because the same shipment cost is spread across fewer units. Recalculate using received minus damaged units. Also confirm the damage treatment and any supplier credit; a credit would change the numerator and must be supported by a separate record rather than assumed.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • The unit denominator must be sellable received units, and the numerator includes the defined nonrecoverable freight and duty costs. Damage reduces yield and can outweigh a low purchase price. Reconcile the shipment costs to the invoice and the accepted quantity to receipt inspection. Keep recoverable tax separate under the explicit assumptions in this case.
        • Supply chain analyst
        • Senior
        • 30 min

        Network break-even volume

        Calculate added annual fixed cost divided by old variable cost per unit minus new variable cost per unit. Enter a formula in B12. The inputs belong to Pine Harbor Distribution, a fictional distributor.

        Start interview
        Skills and rubricNetwork break-even volume
        • The variable saving becomes zero, so no finite volume can recover a positive incremental fixed cost through that saving. Do not divide by zero or report zero break-even volume. State that the cost case fails under this scenario, then evaluate any separately evidenced service benefit without presenting it as a transport saving.
        • I retain the source material, the saved answer and the decision owner because a plausible answer alone does not show which requirement was checked. I name the unresolved exception and the next review date.
        • The threshold compares incremental fixed cost with variable savings under the stated demand and cost assumptions. It does not establish that the center has capacity, serves every lane or survives a disruption. I would verify the volume in the relevant catchment, then compare service and capacity constraints before recommending the additional center.

        Interview Hub access

        The Interview Hub is included in All Access. Choose a plan or sign in to your account to continue.

        View plansSign in or join

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Change your plan

        Checking the price

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.