Supply Chain Professional interview questions and answers

The bullwhip effect is when small changes in end-customer demand become larger and larger swings in orders as you move upstream from retailer to distributor to manufacturer to supplier. Causes include each tier forecasting from the orders it receives rather than real sales, ordering in large batches, price promotions that cause forward buying, and over-ordering when supply looks short. To reduce it, companies share point-of-sale data with suppliers, use collaborative forecasting, order in smaller and more frequent batches, keep prices steady instead of frequent promotions, and shorten lead times. Vendor-managed inventory, where the supplier sees stock levels and replenishes, also helps.

The reorder point is average daily demand multiplied by lead time in days, plus safety stock. For safety stock, a common formula when demand varies and lead time is fairly stable is Z multiplied by the standard deviation of daily demand multiplied by the square root of lead time. Z comes from the target service level, about 1.65 for 95 percent. For example, if average demand is 200 units a day with a standard deviation of 40, and lead time is 9 days, safety stock is 1.65 × 40 × 3, about 198 units. The reorder point is 200 × 9 plus 198, about 1,998 units. If lead time also varies, I use the formula that includes lead time variation.

EOQ is the order size that minimises the total of ordering cost and holding cost. The formula is the square root of 2 multiplied by annual demand multiplied by cost per order, divided by holding cost per unit per year. For example, with annual demand of 12,000 units, ordering cost of ₹500 per order and holding cost of ₹20 per unit per year, EOQ is the square root of 600,000, about 775 units. It assumes steady demand, fixed costs, no quantity discounts and instant delivery. It is a poor guide when demand is seasonal, when suppliers offer price breaks or minimum order quantities, when shelf life is short, or when storage space is limited.

ABC analysis ranks items by annual consumption value, usually quantity times unit cost. A items are the small number of items that make up most of the value, often around 70 to 80 percent, B items are the middle, and C items are the many low-value items. XYZ analysis classifies items by demand variability: X items are steady, Y items vary somewhat and Z items are erratic. Combining them gives a matrix. AX items get tight control, frequent review and lean safety stock because demand is predictable. AZ items need close attention and careful planning. CX items can be automated with simple reorder rules, and CZ items might be made to order or stocked at a central location only.

Inventory turnover is cost of goods sold for a period divided by average inventory value for the same period. Days of inventory is the number of days in the period divided by turnover, or average inventory divided by daily cost of goods sold. If annual cost of goods sold is ₹60 crore and average inventory is ₹10 crore, turnover is 6 and days of inventory is about 61. Low turnover means cash is tied up in stock, with risk of obsolescence. Very high turnover may mean we are running too lean and risking stockouts. I always look at it by category and alongside service level, because averages hide slow-moving items.

S&OP is a monthly cycle that aligns demand, supply and finance on one plan, usually looking twelve to eighteen months ahead. It starts with a demand review, where sales and marketing update the forecast with promotions, new launches and market changes. Then a supply review, where planning, manufacturing and procurement check capacity and material constraints against that demand and identify gaps. A pre-S&OP meeting works out options for the gaps, such as overtime, outsourcing or prioritising products, with financial impact. The executive S&OP meeting decides and approves one plan. The key is that decisions get made there, and that every function works from the same numbers afterwards.

I start with clear requirements: specification, volume, quality standards and delivery needs. Then I shortlist suppliers and assess them on weighted criteria agreed with quality, engineering and finance: quality systems and certifications, production capacity and ability to scale, delivery reliability, financial stability, location and logistics, total landed cost rather than just unit price, and compliance with labour and environmental norms. For critical parts, I visit the plant with the quality team for an audit. Then I approve a trial order and evaluate it before moving to regular supply. After onboarding, I review the supplier through a scorecard on quality, delivery and responsiveness every quarter.

Under FOB, Free on Board, the seller delivers the goods on board the vessel at the named port of shipment. Risk passes to the buyer once the goods are on board, and the buyer pays main freight and insurance. Under CIF, Cost, Insurance and Freight, the seller pays freight and minimum insurance to the destination port, but risk still passes to the buyer when goods are loaded at origin, which surprises many people. Under DDP, Delivered Duty Paid, the seller carries all costs and risks to the buyer’s named place, including import duties and clearance. FOB and CIF are meant for sea transport. For containers, FCA and CIP are usually more suitable.

I measure error at the level where decisions are made, such as item by location by month, using MAPE or weighted MAPE so high-volume items count more. I also track bias, the average of forecast minus actual, because a forecast that is always high builds excess stock, while one that is always low causes stockouts. If accuracy is poor, I look for causes: wrong statistical model for seasonal items, missing promotion information, or sales inflating numbers to secure stock. I compare the statistical forecast with the final adjusted one to see if manual changes help or hurt, which is forecast value added analysis, and I review the worst items every month with sales.

First I would break down cost per unit or per kilogram by lane, mode, carrier and customer, to see where money goes. Common levers are improving truck utilisation by consolidating small orders and setting minimum order values or delivery days for small customers, route optimisation for milk runs, shifting suitable long-haul volume from road to rail or to full-truckload instead of part loads, and renegotiating carrier rates with bundled volumes through a tender. Network design matters too: sometimes adding a regional depot reduces total cost. I would check each change against delivery lead time and on-time performance, so we do not save freight and lose customers.

First I find out the facts: the cause, which items are affected, and how reliable the one-month estimate is. Then I check our exposure: current stock, open orders, stock in transit and how many days of production that covers for each affected item. I inform sales and production planning so they can prioritise high-margin or contractual customers. Then I look for alternatives: other approved suppliers, the supplier’s other plants, spot purchases, or substitute materials with engineering approval. Once the crisis is handled, I review the risk: single-source items, safety stock for critical parts, and qualifying a second supplier, so the same disruption hurts less next time.

At a consumer electronics distributor, slow-moving stock had grown to a large share of our warehouse value. I ran an ageing analysis by item and found most of it came from old models that sales kept ordering for a few key dealers. I worked with sales to clear older stock through dealer schemes and online channels, returned some items to the manufacturer under our agreement, and wrote off a small part. To stop it recurring, we introduced end-of-life planning for each model, so ordering tapered off before a new launch. Slow-moving stock reduced substantially over six months, and warehouse space was freed up for fast movers.

Our packaging supplier proposed a large price increase citing raw material costs. Before the meeting, I tracked the published price trend for paper and checked how much of their cost it represented, which suggested a smaller increase was justified. I also got quotes from two other suppliers. In the negotiation, I accepted part of the increase but asked for a longer contract, a volume commitment from our side in return for fixed prices for six months, and shorter lead times. We ended up at less than half the requested increase, with better lead times. The supplier was comfortable because they gained volume certainty.

A popular pack size of a food product went out of stock in several cities for about ten days during a promotion. Investigating, I found that marketing had planned the promotion, but the information never reached planning, so our forecast did not include the uplift. I owned my part, which was not checking for promotions in the planning cycle. We fixed it by making the promotion calendar a mandatory input in the monthly demand review, with marketing signing off volumes. We also set a rule that any promotion needs at least six weeks’ notice to planning. Later promotions ran without stockouts.

During my internship at an auto parts manufacturer, the stores team complained that some items ran out while others piled up. I pulled a year of consumption data from SAP into Excel, cleaned it, and ran an ABC analysis by consumption value and an XYZ analysis using the coefficient of variation of monthly demand. I then compared current reorder levels with what a simple safety stock formula suggested. Several A items had reorder levels far too low, while many C items were overstocked. I presented a revised reorder list for the top items, and the stores manager started using it for those items within the month.

As a graduate trainee in a pharmaceutical company, I noticed a key raw material order was delayed by customs, which would affect a batch due for a large hospital tender. Production wanted to reschedule, while sales wanted the batch on time. I gathered the facts from procurement about the expected clearance date, checked with production whether another product could be run first, and shared a short summary with all three teams. We agreed to run another batch first and shift the tender batch by four days, still inside the delivery window. Sales confirmed the date with the customer. It taught me that clear facts shared early prevent most arguments.

We moved our planning from spreadsheets to the planning module in our ERP. The biggest problem was not the software but data: lead times, minimum order quantities and safety stock values in the item master were old or missing. I led a data clean-up with procurement and stores over six weeks, checking every A and B item. We ran the new system in parallel with spreadsheets for two monthly cycles and compared results. I trained the planners with real items rather than generic examples. After the parallel run, we switched fully, and planners spent far less time compiling data and more time on exceptions.

I have worked in FMCG supply chain for four years, mostly in demand planning and distribution. Your company is in quick-service restaurants, where the supply chain is even more time-sensitive: perishable ingredients, cold chain, many small deliveries to outlets and tight food safety rules. I find that combination interesting, because forecasting errors show up quickly as waste or stockouts at the outlet. I read about your plan to open more outlets in tier-2 cities, which will need new distribution centres and suppliers. I would like to bring my planning experience to that and learn cold chain logistics in depth.

Yes, I would actually prefer it at the start. Supply chain decisions made at head office only work if they make sense on the ground, and I want to understand how a warehouse or plant runs: receiving, storage, picking, dispatch and how delays really happen. During my MBA internship I spent two weeks at a distribution centre and learned more about lead times there than in class. I understand it may mean a smaller town, shifts and less comfortable working conditions. I would like to know how long the first posting usually lasts and what the rotation plan looks like.

I currently earn ₹11 lakh CTC as a demand planner with four years of experience, including leading the monthly demand review for two categories and working on our S&OP process. This role covers supply planning for a full business unit and S&OP coordination, so I am looking for ₹14 to 15 lakh fixed. I am open on the variable component if it is tied to clear measures like forecast accuracy and inventory days. My notice period is 45 days, and I would want to finish the monthly planning cycle before handing over.