Home › Blog › Supply Chain Intern Interview Questions: Inventory, Excel and Cases

Supply Chain Intern Interview Questions: Inventory, Excel and Cases

Supply chain intern interviews rest on three legs: inventory and planning concepts, Excel, and case-style problem solving about getting the right product to the right place at the right cost. Consumer goods companies, retailers, manufacturers and logistics firms all hire supply chain interns, and many give a short case or a data exercise, so be ready to calculate, not just define.

Supply chain intern interviews rest on three legs: inventory and planning concepts, Excel, and case-style problem solving about getting the right product to the right place at the right cost. Consumer goods companies, retailers, manufacturers and logistics firms all hire supply chain interns, and many give a short case or a data exercise, so be ready to calculate, not just define. This page covers the rounds to expect, the questions that come up with what a strong answer contains, two sample answers, what interviewers expect from an intern, the mistakes that cost offers, and a two-week prep plan.

What the supply chain intern interview looks like

RoundWhat happensHow to prepare
ScreenWhy supply chain, relevant coursework and availabilityA clear answer about which part interests you: planning, procurement, logistics or manufacturing
Behavioral interviewTeamwork, problem solving under pressure and handling a mistakeThree STAR stories, one built around numbers
Case or data exerciseA stockout, a late supplier or a cost question, sometimes with an Excel file to analysePractice safety stock, reorder points and simple cost trade-offs
Final roundPresent your case or meet the team, sometimes with a site tourA three-slide summary: problem, analysis, recommendation

Questions that come up, and what strong answers contain

  1. What is safety stock, and how would you calculate it? Extra inventory that covers variability in demand and lead time. With a stable lead time, a common formula is z times the standard deviation of daily demand times the square root of the lead time in days, where z reflects the service level, about 1.65 for 95 percent. Then explain the trade-off: more service ties up more cash.
  2. How do you set a reorder point? Average demand during the lead time plus safety stock. Work an example aloud, and mention that a varying lead time needs a larger buffer.
  3. What is the bullwhip effect? Orders swing more the further upstream you go, even when consumer demand is steady, because of forecast updates, order batching, promotions and rationing. Jay Forrester described it in 1961. Remedies include sharing point-of-sale data, smaller and more frequent orders, and steadier pricing.
  4. What is economic order quantity, and when does it break down? The square root of two times annual demand times the cost per order, divided by the annual holding cost per unit: the order size that balances ordering against holding costs, from Ford Harris's 1913 model. It assumes steady demand and a fixed cost per order, so seasonality, volume discounts and capacity limits break it.
  5. Our best-selling product stocked out at three stores. What do you check? Whether it was a forecast miss, a supplier or transport delay, wrong on-hand counts in the system, or allocation between stores. Fix the immediate shortage by transferring or expediting stock, then fix the root cause.
  6. How would you choose between two suppliers? Total cost (price, freight, duties and the inventory a longer lead time forces you to carry), quality, lead time and reliability, capacity, risk such as dependence on one country, and payment terms. Never unit price alone.
  7. Which Excel functions have you used on supply chain data? XLOOKUP or INDEX with MATCH, SUMIFS, pivot tables, conditional formatting to flag exceptions, and simple forecasts such as moving averages.

Two sample answers

How would you calculate safety stock?

Safety stock covers the variability we can't predict. Say a product sells 100 units a day on average with a standard deviation of 20, and the supplier reliably delivers in nine days. For a 95 percent service level I'd use z of about 1.65, so safety stock is 1.65 times 20 times the square root of nine, which is 1.65 times 20 times 3, about 99 units. The reorder point is then 900 units of lead-time demand plus 99, so roughly 1,000. If the lead time also varies, I'd use the version of the formula that adds lead-time variance, which raises the buffer.

Tell me about a time you dealt with a delay.

For a design project we ordered custom parts for a prototype, and two weeks before our demo the supplier pushed delivery back past the demo date. I called to ask why, and it was one component on backorder. I found a standard part from a local distributor that met the spec well enough for the demo, ordered it with overnight shipping, and kept the custom order for the final version. The demo went ahead on time, and since then I ask suppliers for a confirmed ship date, not an estimate.

What interviewers expect from an intern

For the full-time version of these questions, see supply chain analyst interview questions.

Mistakes that cost offers

A two-week prep plan

  1. Days 1 to 3: inventory fundamentals with worked numbers: safety stock, reorder point, economic order quantity, inventory turns and days of supply.
  2. Days 4 to 5: the big ideas: the bullwhip effect, push versus pull, make-to-stock versus make-to-order, and the trade-off between cost, speed and service.
  3. Days 6 to 8: Excel: build a small inventory model with demand, lead time and a reorder trigger, plus a pivot table of shipments by route.
  4. Days 9 to 11: three cases out loud: a stockout, a supplier choice and a rise in transport costs.
  5. Days 12 to 14: research the company's network of plants, distribution centres and sales channels, then run two mock interviews; for a planning role, also read our demand planner interview questions.

Timing matters as much as preparation: see our internship recruiting timeline, and once you are in, turning an internship into a return offer. Before the last round, prepare your questions to ask at the end of an intern interview.

Where CoPilot Interview fits

Intern interviews reward clear explanations of your own projects and coursework, and that takes practice out loud. CoPilot Interview is an AI interview assistant; its free AI mock interview builds supply chain intern questions from your résumé and the job description, reads them aloud, scores each spoken answer out of ten and shows a model answer to compare. The free plan gives 15 minutes a day of live help in sessions of up to 15 minutes, with AI mock interviews included, with no card, which suits a student budget. For real interviews and online assessments, follow your employer's rules.

Disclosure: CoPilot Interview is our product, so weigh what we say about it accordingly.

Frequently asked questions

What does a supply chain intern do?

Common projects include analysing inventory or transport data, supporting demand planning, tracking supplier performance and improving a process at a plant or distribution centre. Many companies give interns one main project to present at the end.

Do I need a supply chain degree?

No. Business, engineering, economics and maths students are common in these internships; what matters is comfort with numbers and Excel and a genuine interest in how products move.

Which certifications matter for supply chain interns?

None are expected. Professional certifications from bodies such as ASCM can come later in a career; for an internship, solid Excel and one analysis project you can talk through matter more.

Can I use AI tools during an internship interview?

Only where the instructions allow it. Online assessments and many live rounds forbid outside help. Use AI to practice beforehand, and follow your employer's rules.

Practice this interview before the real one

The AI mock interview builds questions from your resume and the job description, reads them aloud and scores each spoken answer out of 10. Included on the free plan.

Start a mock interview