Blog · Industry
Which component has one qualified source and no second. Which site depends on a single supplier for a third of its inbound. Which supplier's on-time rate has slipped for three months. From the purchase ledger, receipts and the supplier master, supplier IDs only.
Compare a proposed supply chain change with baseline cash costs, implementation effort and measurable benefits. Build a spreadsheet appraisal, test the assumption that could change the decision and compare approved estimates with actual outcomes.
Oct 25, 20265 min readDemand forecasting data starts with orders, shipments and stock availability at a consistent SKU and period. Use a worked example and spreadsheet checks to find missing history, duplicate rows and unexplained differences before accepting a forecast.
Oct 25, 20265 min readBuild a demand range from confirmed orders and explicit assumptions when usable sales history is missing. Keep a dated estimate, then compare it with initial orders and actual sales.
Oct 25, 20265 min readClassify fast-, slow- and nonmoving inventory from a stock snapshot and daily issue records. Set explicit thresholds, calculate movement frequency by SKU and site, and reconcile the class values to inventory.
Oct 25, 20265 min readOrganize an inventory dashboard around dated stock value, service exposure, and decisions. Build a small worked scorecard from SKU and site exports, with exact spreadsheet formulas and checks.
Oct 25, 20265 min readCalculate average inventory from opening and closing balances or dated snapshots. Work through unequal intervals, spreadsheet formulas, and checks that keep SKU and site comparisons consistent.
Oct 24, 20265 min readBuild an inventory reporting pack from stock balances, movement records, and valuation exports. Reconcile quantities before comparing on-hand value, aging, and exceptions by SKU and site.
Oct 24, 20265 min readInventory write off analysis explains posted stock losses by product, location, cause, and accounting period. Use the adjustment register and ledger to separate reversals, reserve use, and current expense before assigning corrective actions.
Oct 24, 20265 min readRetail replenishment predictions need testing at the store and SKU level. Compare a supplied forecast with observed sales and stock availability, reconcile the totals, and separate forecast misses from constrained sales.
Oct 24, 20265 min readSupply chain visibility metrics measure milestone completeness and status freshness in operational records. Work through shipment coverage, missing events and stale status checks by supplier and lane.
Oct 24, 20266 min readPrepare order, shipment and inventory exports before presenting a Tableau supply chain dashboard. Define file relationships, work through duplicated values and reconcile service measures under the same filters.
Oct 24, 20265 min readInventory analysis matches stock questions to cost, aging, turnover, demand and service measures. Use a worked inventory export to choose the right view, calculate it in a spreadsheet, and prove that the balances reconcile.
Oct 23, 20266 min readReconcile opening stock, receipts, issues and adjustments against closing inventory by SKU and site. Build the workbook with exact Excel formulas and trace any difference to its source movements.
Oct 23, 20265 min readBuild a periodic control tower view from order, inbound receipt and inventory exports. Work through site exceptions, exact spreadsheet formulas and the checks that connect every total to its source records.
Oct 23, 20265 min readForecast established products from comparable sales history, then separate promotions, stockouts and changing demand. Follow a worked spreadsheet example and reconcile forecast errors before changing the next plan.
Oct 19, 20265 min readDemand forecasting for perishable goods must match demand to the period when inventory can still be sold. Work through a lot-level example, spreadsheet formulas, and a reconciliation that separates forecast error from excess supply.
Oct 19, 20266 min readEvaluate inventory forecasting software with your own demand, forecast and stock exports. Compare approaches, reconcile a worked test and distinguish forecast analysis from the execution of replenishment decisions.
Oct 19, 20266 min readReal-time demand forecasting updates estimates as new information arrives. Compare timestamped forecast versions with actual demand and decision deadlines to see whether a faster cadence improves planning.
Oct 19, 20265 min readSKU level demand forecasting keeps item decisions visible when category totals look right. Reconcile supplied forecasts to category totals, compare item demand with actuals and calculate an absolute error measure that cannot disappear through offsetting errors.
Oct 19, 20265 min readCost per order divides defined fulfillment spending by the orders it served. Work through a warehouse and channel example, reconcile the totals, and separate fulfillment expense from customer acquisition.
Oct 18, 20264 min readEstimate demand that could not be served during a stockout using comparable in-stock selling periods. Work through an hours-based example, spreadsheet formulas, a sensitivity range and the checks that keep estimated demand separate from recorded sales.
Oct 18, 20266 min readBuild a supply chain dashboard from reconciled order and inventory files. Work through service flags, site comparisons, spreadsheet checks, and the distinction between a report and a dashboard.
Oct 15, 20265 min readThe perfect order fulfillment KPI counts orders that meet every agreed fulfillment condition. This guide calculates the rate from order-level rows, reconciles overlapping failures, and shows how to compare customers without multiplying aggregate percentages.
Oct 13, 20266 min readTurn a demand forecast into a replenishment review using inventory, confirmed receipts, lead times and supply limits. Follow the Excel formulas and a worked plan that checks both the ending balance and the timing of supply.
Oct 12, 20265 min readHML inventory analysis groups items into high, medium and low unit-cost bands. Set documented thresholds, classify a stock export, and reconcile quantities and values without confusing HML with annual usage value.
Oct 12, 20265 min readBuild an inventory KPI dashboard from stock snapshots and fulfillment exports. This workbook layout covers inventory value, aging, turnover and available stock, with formulas and checks by SKU and location.
Oct 12, 20265 min readCompare inventory and delivery performance by site, supplier and product without multiplying your records. Build matching summaries in Excel, calculate the measures, and prove the totals before acting on an exception.
Oct 10, 20265 min readBuild a supply chain workbook that compares delivery reliability, inventory and supplier lead times. Use the layout, formulas and worked checks to keep each measure tied to the right export.
Oct 10, 20265 min readCompare delivery reliability, unit fill, inventory and distribution cost by site from exported summaries. Follow a worked US distributor example, spreadsheet formulas and checks that reconcile the network totals.
Oct 9, 20266 min readUse a practical supply chain executive summary layout that connects service results, inventory exposure and supplier exceptions to decisions. A worked US distributor example shows the source totals, narrative and accountable actions.
Oct 9, 20267 min readBuild a supply chain KPI scorecard with actuals, approved targets, trends, owners and actions. A worked site comparison shows the layout, threshold rules and checks that keep the recurring review consistent.
Oct 9, 20267 min readCausal demand forecasting connects demand forecasts with measured business drivers such as price and promotions. Compare supplied scenarios, reconcile revenue effects and test forecasts against demand without treating correlation as proof of causation.
Oct 8, 20266 min readSupply chain cost analysis separates spending into consistent activity pools. Build a site comparison from ledger, purchasing, warehouse and freight exports, then reconcile the costs and their allocation drivers.
Oct 8, 20265 min readBuild a supply chain dashboard from purchase orders, receipt records, and inventory exports. Match the data grains, calculate service at the promised-date cutoff, and reconcile stock by site before presenting results.
Oct 7, 20265 min readThe base stock inventory method replenishes inventory position toward a stated target. Compare supplied targets with stock, open orders, backorders, and the demand assumptions behind the protection period.
Oct 6, 20266 min readA baseline demand forecast estimates normal demand before temporary events and availability losses. Work through a product-month example that separates baseline, promotion lift, one-time demand and stockouts, then reconciles the result to actual sales.
Oct 6, 20266 min readA demand dashboard compares actual orders with the plan by product, location and period. Work through a US distributor example with unit trends, dollar exposure, absolute error and forecast bias, then test one changed planning input.
Oct 5, 20267 min readSupply chain analytics uses operational records to explain service, inventory and cost performance. Learn which exports to bring, how to define comparable measures and how to reconcile a worked supplier comparison before acting.
Oct 5, 20265 min readRebuild closing inventory quantities from opening balances, receipts, issues, and signed adjustments. Work through a SKU and site reconciliation, compare it with a physical count, and separate stock on hand from stock available to promise.
Oct 3, 20266 min readEstimate average transit inventory from demand and transit time, then calculate an actual cutoff balance from shipment and receipt rows. Work through units, operational value, reconciliation checks, and the separate question of accounting ownership.
Oct 2, 20266 min readHolt-Winters forecasting combines level, trend and a repeating seasonal pattern. Compare additive and multiplicative seasonality, work a seasonal forecast from its components and check forecast outputs against actual product demand.
Sep 29, 20266 min readEvaluate supplied linear regression demand forecasts against actual demand and a baseline. Align the exports, calculate errors, and investigate patterns before relying on the predictions.
Sep 28, 20265 min readRegression analysis tests relationships between inventory-related business measures. Work through a demand example, reserve later periods for validation, and compare prediction errors before using the result in a planning review.
Sep 28, 20265 min readSupplier delays, changing demand, and rising costs change how much inventory a company needs. Compare those pressures using your existing exports, a worked sensitivity table, and spreadsheet checks.
Sep 27, 20266 min readOrdering cost rises with order frequency, while carrying cost rises with average inventory. Compare annual order-size scenarios using the same demand, cost definitions, and service assumptions.
Sep 27, 20265 min readCombine SKU usage value with monthly demand variation to build an ABC-XYZ review matrix. Follow a worked inventory example with explicit periods, zero-demand treatment, formulas, and checks.
Sep 26, 20266 min readChoose demand forecasting software by testing your own forecast inputs, accuracy measures and operating handoffs. This guide compares approaches and works a buyer acceptance case from forecast and actual-demand rows.
Sep 26, 20266 min readChoose a supply chain analytical method by the decision, the available files and the assumptions the evidence can support. Work service, inventory and cost measures from the same operating rows, then choose the next comparison.
Sep 24, 20265 min readCompare forecast misses separately for launch, growth, maturity and decline. This workflow shows the export columns, spreadsheet formulas and checks that keep changing product stages from hiding inside one accuracy score.
Sep 24, 20265 min readS&OP KPI metrics connect forecast error, customer service, inventory, and supply plan attainment. Work through a product-family scorecard, check the totals, and assign each exception to the person who can resolve it.
Sep 24, 20266 min readInventory assortment connects the products a store offers with how much stock each receives. Compare sales, SKU gross profit, stock depth, and unsold inventory across stores using a worked example and explicit decision checks.
Sep 21, 20266 min readSupply chain risk analytics combines stock cover, qualified sources, and delivery history to identify material exposure. Use a worked continuity review to rank actions, check the exports, and keep assumptions separate from observed facts.
Sep 19, 20266 min readIntermittent demand needs a calendar that preserves genuine zeros and a review that separates order timing from order size. Compare supplied forecasts with a worked example, spreadsheet formulas, and checks for slow-moving items.
Sep 18, 20265 min readCompare inventory, supplier-service and customer-delivery dashboard layouts using one worked US distributor example. See the source rows, calculations, decision owners and a variation that changes supplier performance.
Sep 18, 20266 min readA supply planning dashboard compares demand with usable stock and dated receipts by SKU and site. This worked example shows how to distinguish a customer shortage from a reserve breach and test a delayed delivery.
Sep 17, 20266 min readSafety stock covers uncertainty beyond expected replenishment demand. Work through demand and lead-time inputs, compare service targets, and reconcile the buffer to a reorder point.
Sep 16, 20266 min readInventory reorder level is expected demand during replenishment lead time plus safety stock. Work it from usage and receipt exports, compare it with inventory position, and check the assumptions before changing a workbook threshold.
Sep 14, 20265 min readDemand forecasting turns expected customer demand into a planning input for supply chain teams. Compare methods, work a SKU-and-site example and check forecast errors before using the result for supply decisions.
Sep 12, 20266 min readA fulfillment dashboard connects open orders, picking quality and shipment timeliness by warehouse. Follow a worked US distributor example, reconcile the backlog and see why cancellations can improve a headline without improving service.
Sep 12, 20266 min readEvaluate inventory analysis software against reconciled stock, demand, and movement questions. Use a small export-based comparison to test calculations, exceptions, and the evidence behind each answer.
Sep 10, 20266 min readAn inventory dashboard compares dated stock balances, aging and turnover by SKU and location. Build a checked workbook, turn it into a Power BI report, and pin the summary visuals after reconciling the figures.
Sep 8, 20266 min readDemand planning KPIs connect forecast quality with availability and inventory. Build a planner scorecard from frozen forecasts, customer demand, fulfillment records and stock snapshots, then reconcile the measures before acting.
Sep 4, 20266 min readA stock movement report explains how opening quantities become closing stock. Build a reconciled report from movement exports, separate transfers from consumption, and identify unexplained differences by SKU.
Sep 4, 20265 min readTurn approved corporate goals into supply chain measures with defined owners and tradeoffs. Work service, inventory days, and freight cost from operational exports, compare them with targets, and reconcile the results before deciding what to change.
Sep 3, 20265 min readHow supply chain teams should choose analytics software: start from the questions, check the data you hold, ask vendors ten questions, avoid the traps.
Sep 3, 20264 min readABC inventory cycle counting uses approved classes to organize count priorities and assess the results. Compare the items due with completed counts, then separate exact matches, net adjustments, and gross dollar discrepancies.
Sep 1, 20265 min readTurn a demand forecast into a stock requirement using lead times, available inventory and a stated buffer. Follow a spreadsheet example, reconcile the projected balance and test what happens when a receipt arrives late.
Sep 1, 20265 min readA monthly demand forecast needs a preserved starting point, explained revisions and actual demand on the same basis. Follow one planning cycle from exported assumptions to item-level errors and a reconciliation of the total.
Aug 31, 20264 min readSustainable supply chain analytics compares material losses, waste destinations, and shipping activity using disclosed boundaries and supplied factors. Follow a worked site comparison, reconcile the quantities, and see which decisions the evidence supports.
Aug 30, 20266 min readCarrying cost measures the expense of keeping inventory available. Calculate capital, storage, service, and risk costs, then reconcile the total by product and warehouse.
Aug 29, 20265 min readThe Poisson distribution describes demand counts under specific rate and independence assumptions. Compare supplied count-based forecasts with observed low-volume demand, check zero frequency and variation, and recognize when the assumptions are unsuitable.
Aug 28, 20266 min readSupply forecasting estimates what will be available by item, site and date. Build a dated supply schedule from inventory and receipts, test capacity assumptions, and reconcile the plan with actual arrivals.
Aug 27, 20265 min readCollaborative supply chain planning aligns customer, supplier and internal assumptions. Reconcile forecast versions by SKU and period, separate demand consensus from supply commitments, and measure whether the agreed changes helped.
Aug 23, 20266 min readSCOR metrics organize supply chain performance into an agreed measurement framework. Learn how to map business exports, calculate perfect orders and check the resulting scorecard.
Aug 21, 20266 min readApparel inventory turnover needs seasonal cohorts, returns, and markdown context. Work a category comparison, reconcile the cost and sales inputs, and see why a faster stock movement figure cannot establish better profitability.
Aug 18, 20266 min readThe complete on-time-in-full calculation on ten purchase order lines from two suppliers to two sites, small enough to check by hand: the confirmed due date and the tolerance window, the receipt date and quantity, on time and in full per line, the over-receipt that fails the assertion, OTIF per supplier and per supplier-site, why the supplier figure hides the site, the three-month trend that makes a watch list, and the identity that receipts join to lines, so a reader can reproduce every figure and then run it on their own exports.
Aug 18, 20263 min readOTIF, fill rate and on-time delivery are three delivery measures that are reported as if they were one. On-time delivery tests the date only. Fill rate tests the quantity only, and comes in line, case and order versions. OTIF requires both on the same order. This page sets out the definitions, computes all of them on the same ten order lines, shows why OTIF is always the lowest, and explains which one a retailer's scorecard and chargebacks are based on.
Aug 18, 20264 min readThe ten KPIs a supply chain function should run on, each with its formula, the export it comes from and what it tells you: supplier OTIF against each supplier's own baseline, lead time variability, customer OTIF under each customer's rule, forecast bias by SKU and site, inventory aging, single-source exposure, days of cover against target, expedite cost, supplier deterioration watch, and cause of service misses. Also the three measures most teams miss, the figures to drop, the identities, and who owns what.
Aug 16, 20264 min readA demand forecasting process connects source exports, documented adjustments, an approved snapshot, and a review against actual demand. Follow the handoffs with a worked reconciliation and exact spreadsheet formulas.
Aug 11, 20265 min readSCOR organizes supply chain performance measures into attributes that connect strategy with operating results. Use this worked review to compare reliability, responsiveness, cost, and assets from company exports.
Aug 9, 20266 min readExcess obsolete inventory analysis separates stock above approved needs from stock with no supported future use. Build a SKU-level review from on-hand balances, demand assumptions, and disposition evidence, then reconcile the categories to inventory value.
Aug 7, 20265 min readAn unconstrained demand forecast estimates what customers would request without availability limits. Separate recorded sales from assumed lost demand, work a stockout adjustment, and test the estimate before using it for inventory decisions.
Aug 7, 20265 min readPredictive supply chain analytics estimates future demand, delivery, and service outcomes. Learn how to validate supplied forecasts against actuals, compare a baseline, and separate forecast error from operational performance.
Aug 4, 20265 min readCompare a comparable product's launch with an explicit buyer-adoption estimate. Build both forecasts, preserve the assumptions, and test them against early actual sales.
Jul 29, 20265 min readThe ten questions a COO puts to the supply chain and service functions, which suppliers are deteriorating, where is single-source risk, what is the lead time really, where is inventory aging, which sites are short and which are long, is the demand plan biased, what are we paying early for nothing, which accounts consume the most service, are we meeting the SLAs we signed, and what changed, each with the computed table, the identity behind it, and the answer a COO should send back.
Jul 29, 20263 min readDemand estimation describes demand for a defined period from incomplete observations. Forecasting projects demand into a future period; compare both using the same SKU rows, clear cutoffs and separate actuals.
Jul 26, 20266 min readDemand forecasting estimates what customers will request in a future period. Build a simple baseline, separate demand from recorded sales, and check forecast errors against the rows behind them.
Jul 26, 20265 min readHow a supply chain team finds single-source parts, measures inbound concentration by supplier per site and watches supplier performance trends from goods receipts and the supplier master, with the reconciliation to goods received that makes the exposure figure defensible.
Jul 26, 20263 min readProbabilistic demand forecasting describes possible demand outcomes and their likelihood. Compare supplied forecast intervals with actual demand, measure coverage and width, and check whether uncertainty assumptions support business decisions.
Jul 24, 20266 min readPurchasing, inventory and supplier payment timing determine how supply chain operations absorb or release cash. Reconcile inventory and payables by site, then separate cash already released from payments still due.
Jul 19, 20265 min readEconomic order quantity balances annual ordering and inventory holding costs. Work through the formula, compare purchase quantities, and check the assumptions against your demand and cost exports.
Jul 18, 20265 min readThe inventory-to-sales ratio divides an inventory balance by net sales for a stated period. Work the ratio and its reciprocal by category, check the totals, and understand why valuation and seasonal timing change the interpretation.
Jul 14, 20266 min readSupply chain sustainability metrics need clear boundaries, source quantities and approved factors. Compare freight activity and supplier evidence with worked calculations and checks.
Jul 14, 20266 min readLong term demand forecasting connects multiyear customer and usage assumptions to a capacity decision. Build a spreadsheet scenario, reconcile demand to available finished-unit capacity and see which assumptions change the timing of an expansion.
Jul 12, 20265 min readHow a supply chain team turns receipt and purchase order data into an on-time-in-full figure per supplier per site, why the trend matters more than the level, the three-month rule that separates a bad month from a deteriorating supplier, and the watch list that goes to the category manager.
Jul 12, 20262 min readHow a supply chain team measures actual lead time and its variability per supplier per site per item from purchase orders and receipts, why the spread drives safety stock more than the mean, the suppliers whose variability rose while their average held, and the inventory that a tighter supplier or a corrected lead time parameter would release.
Jul 9, 20263 min readHow a supply chain team reads inventory aging per SKU per site from the stock and movement files: days since last issue, value in each aging band, the sites where aged stock concentrates, the SKUs aged at one site and moving at another, the transfer that releases the cash, the write-down exposure at stated bands, and the identity that aged plus moving stock equals the inventory ledger.
Jul 8, 20263 min readInventory ratios connect stock balances with sales, cost of goods sold, and gross profit. Compare the measures on one category scorecard, reconcile the inputs, and choose the ratio that fits your decision.
Jun 30, 20266 min readHow a supply chain team measures demand forecast accuracy and bias per SKU per site from the forecast snapshots and the actual demand: error and signed bias, the SKU-site pairs that are consistently over-forecast and carry the excess stock, the ones consistently under-forecast and carry the stock-outs, why bias at one site is usually a planner's override, and the adjustment the team's own history supports.
Jun 29, 20263 min readAssess supply chain reporting through input reliability, reconciliation, repeatability and decision ownership. Use an evidence-based scoring table, spreadsheet formulas and improvement gates for recurring plant and supplier reviews.
Jun 29, 20265 min readThe bullwhip effect occurs when upstream orders vary more than customer demand. Work through a variance comparison, identify the ordering decisions behind the pattern and learn which export checks make the result trustworthy.
Jun 28, 20265 min readS&OP forecasting brings demand, supply and financial assumptions onto the same basis. Compare monthly product-family exports, calculate the gaps, and reconcile the resulting revenue plan.
Jun 23, 20265 min readCompare demand, inventory and production capacity by product family in one planning workbook. Follow a worked layout that exposes capacity gaps and reconciles the ending inventory plan.
Jun 21, 20266 min readJIT inventory analysis compares stock, supplier reliability, service, and operating costs before a policy change. Build a matched comparison from existing exports, calculate the tradeoffs, and identify the conditions that need testing.
Jun 18, 20266 min readSupplier concentration and continuity analytics for supply chain teams.
See the page