Skip to main content
VirtualInterview.ai

Business, Finance & Consulting

Supply chain analyst interview questions and mock interview

A supply chain analyst interview checks whether you can reason with numbers out loud: forecast a product with no history, size safety stock, react to a late supplier, and explain the trade-off between service and inventory to people who are not analysts. Many loops add an Excel task, a SQL question or a short case.

The practice link opens the practice chat with Supply Chain Analyst as the role. Switch the round to Case study on the plan card for the analytical part: every question comes with a small table, such as demand by week or supplier lead times, and you talk through what it shows. The Technical round covers tools questions. Each answer is scored from 0 to 100 for relevance, depth and clarity.

Practice this role with an AI interviewer

Free plan: 2 interviews a month, free account, no card.

What the loop usually looks like

  1. Recruiter screen (Often 20 to 30 min). Your degree or experience, the tools you have used (Excel, SQL, an ERP system, a BI tool) and a project you can explain.
  2. Hiring manager interview (Often 45 to 60 min). A walk-through of an analysis you did, how you handle a disruption such as a late supplier, and how you work with planners, buyers, warehouse and sales.
  3. Technical or case round (Varies). An Excel task, a SQL query, a forecasting or safety stock question, or a small case on a data set. Some employers send it as a take-home and ask you to present it.

What interviewers score

  • Quantitative reasoning you can say out loud
  • Tool fluency: Excel, SQL, ERP and BI reporting
  • A structured response to disruptions
  • Explaining trade-offs to people who are not analysts

What interviewers probe at each level

Analyst or graduate

Expect Excel and SQL basics, a class or internship project, and a calculation such as safety stock or a moving-average forecast. Interviewers want to hear how you check your own numbers. O*NET’s profile for logistics analysts lists Excel, SQL, SAP and Oracle ERP systems, Power BI and Tableau among the tools used in the job, so name the ones you have used and what you built.

Planner

Demand and supply planners own a plan. Expect questions on running the monthly planning meeting, handling exceptions, revising schedules when materials run short, chasing suppliers and agreeing numbers with sales. O*NET’s planning and expediting profile includes revising production schedules when design changes, material shortages or backlogs occur.

Specialist or senior analyst

Senior candidates are asked about network or sourcing decisions, total landed cost, scenario planning for disruptions, choosing a forecasting method for a whole portfolio and mentoring junior analysts. Expect a case with several options and no single right answer.

Mistakes that cost candidates this round

  • Giving a formula without explaining what each term means for the business.
  • Saying “I would use machine learning” for a product that has no sales history.
  • Judging forecast accuracy on MAPE alone when the range includes slow movers.
  • Presenting the inventory trade-off as a technical answer instead of a business choice with a cost.
  • Describing an analysis without the decision it changed.
  • Claiming an Excel or SQL skill you cannot talk through step by step.

How do you work out safety stock out loud?

Safety stock is the extra stock held to cover demand that is higher than forecast during the replenishment lead time. The standard textbook form when demand varies and lead time is steady is safety stock = z × σD × √L, where z comes from the service level you want, σD is the standard deviation of daily demand and L is the lead time in days. For a 95% cycle service level, z is about 1.65; for 99%, about 2.33.

A worked example, our own arithmetic. Daily demand averages 100 units with a standard deviation of 20, and the lead time is 9 days. The square root of 9 is 3, so safety stock at 95% is 1.65 × 20 × 3 = 99 units, call it 100. The reorder point is expected demand over the lead time plus safety stock: 100 × 9 + 99 = 999 units. At 99% service level, safety stock becomes 2.33 × 20 × 3, about 140 units. Four points of service level cost about 40% more safety stock, which is the trade-off most interviewers want you to notice.

If the lead time also varies, say so: the formula then needs a term for lead-time variability, and a supplier that is sometimes a week late can matter more than demand noise. Say what you would check before trusting the numbers, such as whether demand is roughly stable and whether the lead time in the system matches what actually happens.

How do you forecast a product with no sales history?

Hyndman and Athanasopoulos’s forecasting textbook says judgmental forecasting is usually the only available method for new product forecasting, because there is no history. The chapter covers the Delphi method with a panel of experts, forecasting by analogy from similar products, scenario forecasting, and three approaches for new products: a sales force composite, executive opinion and customer intentions.

In an interview, combine them in a plain order. Pick two or three analogous products and look at their first 12 weeks, adjusted for price and distribution. Check that against what sales or key customers expect. Give a range instead of a single number, decide how much stock to commit before launch, and say how soon you would switch to a statistical forecast once real sales arrive.

The same book’s chapter on accuracy explains a trap for follow-up questions. Percentage errors such as MAPE are infinite or undefined when actual demand is zero, extreme when it is close to zero, and put a heavier penalty on negative errors than on positive ones. That is why MAPE can look terrible on slow movers even when the forecast is reasonable. Mention a scale-based measure such as mean absolute error for those items, or a weighted percentage error across the range.

Sources: Hyndman and Athanasopoulos, Forecasting: Principles and Practice (3rd ed.), chapter 6; Hyndman and Athanasopoulos, Forecasting: Principles and Practice (3rd ed.), section 5.8

What does a supply chain analyst do day to day?

O*NET’s logistics analyst profile describes the work as interpreting data on logistics, applying analytic methods to understand, predict or control logistics operations, preparing reports on performance measures, and providing ongoing analyses of areas such as transportation costs, parts procurement, back orders and delivery. Interview questions follow those tasks closely, which is why most of the questions below are calculations, reports and disruptions.

If the job description mentions SCOR, the supply chain operations reference model, read the current version on ASCM’s site before the interview and use its names for the processes and for delivery performance. Most analyst interviews do not ask about it.

The US Bureau of Labor Statistics groups this work with logisticians. It reports about 255,100 logistician jobs in 2025, a median annual wage of $82,320 in May 2025, projected employment growth of 18% from 2025 to 2035, and about 26,600 openings a year on average over the decade. It says logisticians typically need a bachelor’s degree, although less education may be enough for some jobs.

Sources: O*NET OnLine, 13-1081.02 Logistics Analysts; O*NET OnLine, 43-5061.00 Production, Planning, and Expediting Clerks; U.S. Bureau of Labor Statistics, Occupational Outlook Handbook: Logisticians

How do I rehearse a supply chain interview here?

Use the Case study round for the analytical questions. Each question shows a table of a few rows, every later table is a different cut of the same situation, and you answer by saying what the numbers show and what you would do. The AI interviewer cannot run your spreadsheet or your query, so practise describing the Excel formula or the SQL you would write, clause by clause, which is also what a live technical interviewer asks for. Then run a job interview with the role set to Supply Chain Analyst for the behavioural questions, and re-answer the lowest-scoring one.

10 supply chain analyst interview questions and model answers

1. How would you forecast demand for a new product with no sales history?

Domain. What they are testing: Judgmental methods, analogies and a range instead of false precision.

I’d start with analogues: two or three similar products, their first twelve weeks of sales, adjusted for price, number of stores and marketing. I’d check that against what sales and our biggest customers expect, and give a low, middle and high case. I’d commit stock for the middle case with a fast reorder option, and switch to a statistical forecast once we have six to eight weeks of real sales.

2. Your key supplier tells you a shipment will arrive two weeks late. What do you do in the first day?

Situational. What they are testing: Structured response: impact, options, communication.

First I size the impact: current stock and open orders against the new arrival date, item by item, to see when we stock out and which customers are affected. Then options: part of the shipment by air, an alternative supplier, moving stock between sites, or prioritising our biggest customers. I tell sales and customer service the same day with the dates, so they don’t promise what we can’t ship, and I revise the plan in the system.

3. What happens to inventory if we raise our service level from 95% to 99%?

Domain. What they are testing: Understanding that the relationship is not linear.

Safety stock rises faster than the service level. With the usual formula, z goes from about 1.65 to about 2.33, so safety stock goes up by about 40% for four points of service. Each extra point costs more than the one before. I’d show the business the cost of holding that stock next to the value of the extra sales, and suggest the higher level only for the items where a stock-out really hurts.

4. Daily demand averages 100 units with a standard deviation of 20. Lead time is 9 days. What safety stock do you need for a 95% service level?

Technical. What they are testing: Calculating out loud and explaining the assumptions.

Using safety stock = z times the standard deviation of daily demand times the square root of lead time: 1.65 × 20 × 3 = 99, so about 100 units. The reorder point is 9 days of average demand plus that, 900 + 99 = 999. That assumes the lead time is stable; if the supplier varies by several days, I’d add the lead-time term and the number would go up.

5. Your forecast’s MAPE looks fine overall but very poor on slow-moving items. Why?

Technical. What they are testing: Knowing the limits of percentage error measures.

MAPE divides by actual demand, so when actuals are zero or very small it explodes; selling one unit instead of the two forecast is a 100% error. It also penalises over-forecasts and under-forecasts differently. For slow movers I’d use mean absolute error or a weighted percentage error across the group, and look at whether we are holding the right stock for them rather than chasing a percentage.

6. Which KPIs would you put on a supply chain dashboard?

Domain. What they are testing: Choosing a balanced set and knowing who uses it.

I’d balance service, cost and inventory: on-time in-full delivery to customers, fill rate, forecast accuracy measured in a way that works for slow movers, inventory turns or days of supply, and supplier on-time delivery. I’d keep it to a handful on the first page, with the ability to drill into a site or a product family. Each measure needs an owner, or nobody acts on it.

7. How would you write a SQL query to find items below their reorder point?

Technical. What they are testing: Explaining a query clearly, step by step.

I’d join the inventory table to the item master on item ID, so I have on-hand quantity, quantity on order and the reorder point. Then I filter where on-hand plus on-order is less than the reorder point, and order by how far below they are, largest gap first. I’d also select the supplier and lead time so the planner can act straight away, and check for items with no reorder point set, because they never show up.

8. How would you build a weekly demand report in Excel from a raw sales extract?

Technical. What they are testing: Practical Excel skills and checking your work.

I’d load the extract as a table, add a column for the week number, and use XLOOKUP or a join in Power Query to bring in the product family from the item master. Then a pivot table by family and week, with a simple four-week moving average next to actuals. Before sharing it, I’d reconcile the total units against the source system so nobody argues about the numbers in the meeting.

9. Tell me about an analysis that changed a decision.

Behavioral. What they are testing: Whether your work changed what the business did.

In my internship the team wanted to add a second supplier for a part because of late deliveries. I pulled the delivery data and found the lateness was on orders we placed late, inside the supplier’s standard lead time. We changed the reorder point in the system instead, late deliveries for that part dropped, and we avoided qualifying a new supplier.

10. Sales wants more stock, finance wants less. How do you present the trade-off?

Situational. What they are testing: Turning a conflict into a choice with numbers.

I’d show both sides on one page: for two or three service levels, how much inventory we would hold, what it costs to carry, and the expected lost sales from stock-outs. I’d split it by product group, because the answer is usually different for top sellers and slow movers. Then I make a recommendation, but the decision belongs to the people accountable for the budget and the customers.

Frequently asked questions

Do supply chain analysts get an Excel test?

Often. Many employers include an Excel task, such as lookups, a pivot table or a simple forecast, or a SQL question. Practise doing the task and also explaining each step out loud, because interviewers ask why you chose a formula and how you would check the result.

Do I need an ASCM or APICS certification to become a supply chain analyst?

No, it is not usually required for analyst roles, though it can help. The US Bureau of Labor Statistics says logisticians typically need a bachelor’s degree, and some jobs accept less. Strong Excel, SQL and a project you can explain matter more in most entry-level interviews.

What is the difference between a supply chain analyst and a planner?

An analyst mainly builds reports, forecasts and analyses that others use. A demand or supply planner owns a plan: they set the forecast or order quantities, handle exceptions and chase suppliers. Interviews for planners ask more about meetings, decisions and follow-up; analyst interviews ask more about tools and calculations.

Is supply chain analyst a good career?

In the US the outlook is strong. The Bureau of Labor Statistics projects employment of logisticians, the group that includes this work, to grow 18% from 2025 to 2035, much faster than average, with about 26,600 openings a year. It puts the median wage at $82,320 in May 2025. Expect Excel in the interview whatever your degree.