Storekeeping & Warehouse Operations

Chapter 11
Warehouse Analytics, Costing and Performance Management

Post Graduate Programme in Materials Management
Storekeeping & Warehouse Operations   •   Post Graduate

Warehouse Analytics, Costing and Performance Management

Introduction

Modern warehouses are not merely storage locations. They are operational systems in which inventory, information, people, equipment, space, suppliers, carriers and customers interact. Their performance must therefore be measured as a system rather than through isolated measures such as pallet movements or labour hours. Warehouse analytics converts operational data into evidence for decisions about capacity, process design, staffing, inventory policy, technology and service commitments.

The central managerial challenge is balance. A warehouse may reduce cost by consolidating shipments, increasing batch sizes or reducing labour, but these actions can increase order-cycle time, stock-out risk or customer dissatisfaction. Conversely, very high service levels may require additional safety stock, overtime, premium transport and reserve capacity. Performance management is therefore concerned with the relationship among cost, speed, quality, capacity and service.

This chapter develops a framework for measuring and improving warehouse performance. It explains key performance indicators (KPIs), dashboard design, warehouse costing, Pareto analysis, forecasting, productivity measurement and cost–service trade-offs. Numerical examples illustrate how managers can move from raw data to defensible decisions.

Learning Objectives

After studying this chapter, the reader should be able to:

  1. Design a balanced warehouse KPI framework and management dashboard.
  2. Calculate and interpret inventory accuracy, dock-to-stock time, utilization, throughput, order-cycle time, picking accuracy, labour productivity and cost per order.
  3. Distinguish financial, operational, service and risk indicators.
  4. Apply Pareto analysis to inventory, errors, orders and warehouse costs.
  5. Use basic forecasting measures to support capacity and labour decisions.
  6. Evaluate cost–service trade-offs without optimizing one measure at the expense of the whole system.
  7. Assess the governance, data-quality and ethical requirements of warehouse analytics.

1. From Operational Data to Management Insight

Warehouse data originate in warehouse management systems (WMS), enterprise resource planning systems, transport systems, labour-management systems, barcode scanners, radio-frequency identification (RFID), automated storage and retrieval systems, sensors and financial ledgers. Data become useful only when they are defined consistently and linked to a decision.

A sound analytics chain is:

Event capture → data validation → metric calculation → diagnosis → decision → controlled improvement.

For example, a low picking-accuracy percentage is a signal, not an explanation. The cause may be poor master data, similar item codes, inadequate slotting, damaged labels, rushed work, replenishment failure or a WMS interface error. A KPI should therefore trigger investigation rather than automatic blame.

A KPI should have:

  • a precise numerator and denominator;
  • a defined time window and population;
  • a data owner;
  • a target or reference point;
  • an agreed treatment of exceptions;
  • a review frequency; and
  • a documented management response.

Leading and lagging indicators

Lagging indicators describe results, such as monthly cost per order or customer returns. Leading indicators describe conditions likely to influence future results, such as replenishment tasks overdue, locations without cycle counts, congestion at receiving doors or training completion. Effective dashboards combine both types.

Strategic alignment

KPIs should be derived from the warehouse value proposition. A facility supporting emergency medical supplies requires different priorities from a facility handling low-value, non-urgent commodities. Typical strategic priorities include availability, responsiveness, traceability, damage prevention, regulatory compliance, low cost, flexibility and sustainability.

2. A Balanced Warehouse KPI Architecture

A useful architecture groups measures into six perspectives.

PerspectiveQuestionsIllustrative KPIs
ServiceAre customer requirements met?On-time dispatch, order-cycle time, fill rate
QualityIs work performed correctly?Picking accuracy, damage rate, inventory accuracy
FlowHow quickly does material move?Dock-to-stock time, throughput, queue time
CapacityHow effectively are resources used?Space utilization, equipment utilization, labour utilization
CostWhat resources are consumed?Cost per order, cost per line, cost per unit handled
Risk and improvementIs the system resilient and controlled?Safety incidents, audit findings, overdue actions, energy per order

No single KPI represents warehouse performance. High utilization may indicate effective use of space, but it may also produce congestion, inaccessible stock and slow replenishment. High labour productivity may result from understaffing and declining service. Metrics must therefore be interpreted in combinations.

KPI definitions and formulas

#### Inventory accuracy

Inventory accuracy compares the physical quantity with the recorded quantity. One common unit-based measure is:

Inventory accuracy (%) = (Number of accurately recorded stock records ÷ Total stock records checked) × 100

A stock record is accurate only if it satisfies the organization’s tolerance rule, such as exact equality or a permitted quantity variance. The formula is a sample-based proportion when only selected records are counted. If inventory value is more important than record count, a value-weighted measure may be used:

Value accuracy (%) = (Book value of records within tolerance ÷ Book value of records checked) × 100

The first measure treats every record equally; the second gives greater influence to high-value records. Neither replaces investigation of root causes.

Example. Of 1,200 cycle-count records checked, 1,164 met the defined tolerance. Inventory accuracy is (1,164 ÷ 1,200) × 100 = 97%. If 36 discrepancies are concentrated in one product family, an overall percentage may conceal a serious local problem.

#### Dock-to-stock time

Dock-to-stock time measures elapsed time from receipt arrival or unloading authorization to stock becoming available for normal use. A clearly defined operational version is:

Average dock-to-stock time = ∑(Availability timei − Receipt start timei) ÷ n

Here, i identifies receipt i, n is the number of receipts, and time is measured in minutes or hours. The organization must state whether waiting for documents, inspection, quality release and system posting are included. Averages can be distorted by exceptional receipts; median and percentile values should also be reported.

#### Space utilization

Space utilization requires a capacity denominator that reflects usable capacity rather than the building’s gross floor area.

Space utilization (%) = (Occupied usable storage capacity ÷ Available usable storage capacity) × 100

Capacity may be measured in pallet positions, cubic metres, bin locations or square metres. The numerator and denominator must use the same unit. A pallet-position measure is inappropriate for irregular loose cartons unless a reliable conversion rule exists. Operationally, a target below 100% is necessary because access aisles, safety clearances, staging areas and variability require reserve capacity.

#### Throughput

Throughput is the quantity processed per unit of time:

Throughput rate = Quantity processed ÷ Elapsed operating time

Quantity may be orders, order lines, cartons, pallets or tonnes. A throughput figure must identify the unit, process boundary, shift pattern and whether rework is included. Receiving throughput and picking throughput should not be combined into one unexplained number.

#### Order-cycle time

Order-cycle time is the elapsed interval between agreed order release and completed dispatch or delivery, depending on the process definition:

Order-cycle timei = Completion timei − Release timei

For a group of orders, managers should report mean, median and service percentiles. If ti denotes each order’s cycle time, the mean is:

Mean cycle time = ∑ti ÷ n

The mean is sensitive to very late orders. The 95th percentile answers a different managerial question: the time within which approximately 95% of observed orders were completed.

#### Picking accuracy

A line-based picking accuracy measure is:

Picking accuracy (%) = (Correctly picked order lines ÷ Total order lines picked) × 100

The definition of “correctly picked” should include item identity, quantity, condition and, where relevant, lot or serial number. An order-based measure can hide errors in large orders, while a line-based measure may understate the customer impact of a critical error. Both can be reported.

#### Labour productivity

Labour productivity relates valid output to labour input:

Labour productivity = Standard or actual output ÷ Direct labour hours

For picking, this may be order lines per direct labour hour. If tasks differ substantially in difficulty, unadjusted lines per hour can be misleading. A weighted standard-minute system may assign time values to travel, handling and verification, but standards must be periodically validated and must not encourage unsafe behaviour.

#### Cost per order

A basic fully allocated cost measure is:

Cost per order = Total warehouse operating cost ÷ Completed orders

The cost boundary must be explicit. It may include direct labour, supervision, rent, utilities, equipment depreciation, maintenance, information systems, consumables and allocated overhead. If orders vary greatly in size, cost per order should be supplemented by cost per line, carton, unit or shipment.

3. Dashboard Design and Interpretation

A dashboard is a controlled management interface, not a decorative collection of graphs. A practical hierarchy contains:

  1. Executive view: service, cost, quality, safety and capacity trends.
  2. Process view: receiving, put-away, storage, replenishment, picking, packing and dispatch.
  3. Diagnostic view: shift, zone, SKU, customer, carrier, equipment and exception details.

Each KPI card should show the current value, target, variance, trend, population size and data timestamp. Colour coding should be used cautiously. A red indicator may represent a statistical anomaly, a genuine service failure or a data-feed problem.

Data quality controls

Analytics requires master-data discipline. Important controls include:

  • unique SKU, location, order and shipment identifiers;
  • synchronized clocks across WMS, scanning and transport systems;
  • validation of units of measure and conversion factors;
  • duplicate-event detection;
  • reconciliation between physical counts, WMS balances and the general ledger;
  • treatment of cancelled, split and backordered orders; and
  • audit trails for manual overrides.

A dashboard should distinguish “zero,” “not applicable,” “missing” and “not yet reported.” Treating missing data as zero creates false performance.

Statistical interpretation

Performance varies. Managers should separate common-cause variation, arising from the normal process, from special-cause variation, arising from unusual events. A control chart or run chart can reveal whether a change is persistent. A simple average comparison before and after an intervention is weak evidence if order mix, staffing, seasonality or demand changed simultaneously.

For a sample mean, the standard error is often represented as:

SE(x̄) = s ÷ √n

where s is the sample standard deviation and n is the sample size. This expression assumes independent observations and is used to describe uncertainty around the sample mean; it does not prove that a process is stable or that a management intervention caused improvement.

4. Warehouse Costing and Cost-to-Serve

Warehouse costing supports decisions about layout, outsourcing, automation, customer pricing and service design. The first requirement is a defensible cost object: an order, order line, pallet received, pallet stored, carton shipped, customer, product family or process.

Cost classification

Cost categoryExamplesManagement use
Fixed or capacity-relatedRent, salaried supervision, depreciationCapacity and network decisions
Variable or activity-relatedHandling labour, packaging, transaction feesVolume and process decisions
Step costAdditional shift, supervisor or vehicleVolume thresholds
Failure costErrors, damages, returns, claims, expeditingQuality and prevention priorities
Opportunity costLost capacity or delayed ordersTrade-off analysis

The fixed-variable distinction is not absolute. Labour may be fixed within a shift but variable across a wide volume range. Cost behaviour should be studied over the relevant decision horizon.

A simple total-cost model is:

Total cost = Fixed cost + (Variable cost per activity unit × Activity volume)

This model assumes a stable relevant range and approximately linear variable cost. It is not reliable when overtime thresholds, capacity steps, volume discounts or nonlinear congestion are material.

Cost-to-serve allocates resources according to the activities required by each customer or product. A customer ordering small quantities frequently may consume more receiving, picking, packing and delivery resources than a customer ordering full pallets. Activity-based costing can expose this pattern, but allocation bases must reflect causal resource consumption rather than arbitrary revenue percentages.

Worked costing example

An illustrative warehouse incurs monthly costs of:

  • fixed facility and supervision cost: $48,000;
  • variable handling cost: $1.80 per order; and
  • quality and systems cost: $12,000.

It completes 20,000 orders. Total cost is:

48,000 + (1.80 × 20,000) + 12,000 = $96,000.

Cost per order is 96,000 ÷ 20,000 = $4.80. If volume rises to 24,000 orders without additional fixed cost, cost becomes 48,000 + (1.80 × 24,000) + 12,000 = $103,200, or $4.30 per order. This reduction is an apparent scale benefit, but it is valid only if service quality, congestion and overtime remain acceptable.

5. Pareto Analysis for Warehouse Improvement

Pareto analysis ranks causes or items by their contribution and calculates cumulative contribution. It is based on the practical observation that a minority of categories often accounts for a large share of impact; it is not a universal law requiring an exact 80:20 ratio.

Applications include:

  • SKUs accounting for most inventory value;
  • error categories accounting for most picking defects;
  • customers generating most urgent requests;
  • locations causing most stock discrepancies; and
  • activities generating most warehouse cost.

The procedure is:

  1. Define the unit of analysis and impact measure.
  2. Collect data for a consistent period.
  3. Rank categories from largest to smallest impact.
  4. Calculate each category’s percentage of total impact.
  5. Calculate cumulative percentage.
  6. Investigate the vital few, while monitoring the remaining categories.

Example. Suppose five error causes produce 200 errors: wrong item 80, quantity error 50, damaged product 30, label error 25 and system exception 15. Their shares are 40%, 25%, 15%, 12.5% and 7.5%. The first two causes account for 65%, and the first three for 80%. Improvement should begin with wrong-item and quantity errors, but the organization should not ignore a low-frequency error with severe safety or regulatory consequences.

Pareto analysis identifies concentration, not root cause. Root-cause tools such as process mapping, five-whys analysis, fishbone diagrams, observation and controlled experiments are required before intervention.

6. Forecasting for Capacity and Labour Decisions

Forecasting links expected demand with warehouse resources. Forecasts should be prepared at the level at which decisions are made: daily orders for labour planning, weekly volume for transport capacity, and monthly volume for budgets and facility planning.

Moving-average forecast

For a simple moving average of the previous k periods:

Ft+1 = (Dt + Dt−1 + … + Dt−k+1) ÷ k

Dt is actual demand in period t, and Ft+1 is the forecast for the next period. The method assumes recent observations are relevant and gives equal weight to the selected periods.

If the last three weekly order volumes are 9,800, 10,400 and 10,100, the next forecast is (9,800 + 10,400 + 10,100) ÷ 3 = 10,100 orders. A moving average smooths random variation but responds slowly to a sudden trend.

Exponential smoothing

A basic exponential-smoothing model is:

Ft+1 = αDt + (1 − α)Ft

where 0 ≤ α ≤ 1 is the smoothing constant. A larger α responds more quickly to recent changes. The method assumes a stable process without explicitly modelling seasonality or causal drivers.

Forecast error can be measured as:

et = Dt − Ft

Mean absolute deviation is:

MAD = ∑|et| ÷ n

Mean absolute percentage error is:

MAPE = (100 ÷ n) × ∑(|et| ÷ |Dt|)

MAPE is problematic when actual demand is zero or very small. Forecasts should therefore be evaluated with more than one measure and judged against the operational decision they support. A forecast is not a promise; it is an estimate with uncertainty.

7. Cost–Service Trade-offs

Service is multidimensional. It may include product availability, order completeness, dispatch punctuality, delivery reliability, information accuracy and responsiveness to exceptions. Raising one service dimension can increase cost, while failing to meet a critical requirement may create disproportionate loss.

A useful conceptual model is:

Total relevant cost = Operating cost + Inventory cost + Failure cost + Service penalty

The terms must be defined for the decision. Inventory cost may include capital, storage, insurance, obsolescence and handling. Failure cost may include returns, claims, lost sales and reputational damage. Service penalty represents the economic consequence of failing an agreed service requirement. The model is a decision framework, not a universal accounting identity.

Managers should compare alternatives incrementally. If an additional shift costs $18,000 per month and is expected to prevent $25,000 of returns and premium freight, the apparent monthly benefit is $7,000 before considering risks, implementation cost and whether the estimates are causal. If the shift merely increases processing capacity while demand remains unchanged, its value may be negligible.

Trade-off analysis should consider:

  • marginal cost and marginal service benefit;
  • capacity and congestion effects;
  • customer and product criticality;
  • reversibility of the decision;
  • uncertainty in demand and processing time;
  • resilience to disruption; and
  • legal, safety and ethical obligations.

Service segmentation is often superior to a single target. Critical medical items may require near-continuous availability, while routine items may use economical replenishment and longer cycle times. Segmentation must be transparent and consistent with contractual and regulatory obligations.

8. Integrated Performance Management

A mature performance-management cycle has five stages:

  1. Plan: define service requirements, capacity assumptions and targets.
  2. Measure: capture reliable event and cost data.
  3. Diagnose: identify variation, constraints and root causes.
  4. Act: implement a targeted operational change.
  5. Learn: verify outcomes and update standards or policy.

A KPI review should ask four questions: What happened? Why did it happen? What decision follows? How will the decision be tested? This prevents dashboards from becoming passive reporting systems.

Balanced scorecards can connect warehouse indicators to organizational outcomes. For example, training completion and replenishment adherence are internal-process indicators; picking accuracy is a quality indicator; order-cycle time is a customer indicator; and cost per order is a financial indicator. The causal links should be tested rather than assumed.

Benchmarking

Internal benchmarking compares zones, shifts or facilities under comparable conditions. External benchmarking compares organizations but requires caution because accounting boundaries, product mix, automation, labour markets and service promises differ. Benchmarking is most useful when it stimulates questions, not when it imposes an unadjusted target.

Incentives and unintended consequences

If workers are rewarded solely for lines per hour, they may skip scans, combine incompatible work, defer housekeeping or select easy orders. If managers are rewarded solely for space utilization, they may eliminate reserve capacity. Incentive systems should include quality, safety, accuracy and service measures, with explicit safeguards against gaming.

9. Technology, Automation and AI

WMS analytics can provide real-time exception alerts, slotting recommendations, labour forecasts and process mining. Machine-learning models may predict late orders, equipment failure or likely inventory discrepancies. Digital twins can test layout and capacity scenarios before physical changes are made.

Technology does not eliminate managerial responsibility. AI outputs depend on data quality, training data, model assumptions and changing operating conditions. A prediction of late dispatch is not proof that a particular employee caused the delay. Human review is necessary for high-impact decisions, especially those affecting employment, safety, customer allocation or regulated goods.

Good governance includes:

  • documented data lineage and model purpose;
  • access control and cybersecurity;
  • validation for bias and drift;
  • explainable decision rules where feasible;
  • retention and privacy controls;
  • auditability of automated recommendations; and
  • a method for correcting erroneous records.

Sensors and worker-monitoring systems also raise privacy and dignity concerns. Data collection should be proportionate, transparent and limited to legitimate operational purposes. Safety analytics should improve working conditions, not encourage unsafe speed.

10. Illustrative Case: Meridian Health Distribution Centre

Background

Meridian Health operates a regional distribution centre serving hospitals and clinics. The facility processes approximately 12,000 order lines per week, including temperature-sensitive and high-criticality products. Management reported rising overtime, late dispatches and inventory discrepancies.

Problem

The dashboard showed 98.4% overall picking accuracy, apparently close to target. However, customer complaints and emergency replenishment activity were increasing. Dock-to-stock time averaged 9.2 hours, while space utilization was reported at 94%. The measures were not segmented by product family, shift or process.

Analysis

A six-week diagnostic study reconciled WMS events, cycle counts, labour records and customer claims. The team found:

  • 62% of picking errors came from two visually similar product families;
  • 70% of late dispatches occurred during the final two hours of the afternoon shift;
  • receiving inspection queues caused most dock-to-stock delay for regulated products;
  • utilization was overstated because blocked and inaccessible locations were counted as available capacity; and
  • labour productivity was calculated using order lines only, despite large differences in travel distance and handling complexity.

Pareto analysis focused improvement on the two error families. Process observation showed that labels were similar and replenishment often placed the substitute item in an adjacent location. A revised slotting plan, colour-coded location labels, mandatory scan verification and a replenishment cut-off before peak picking were introduced.

For receiving, the centre created a risk-based inspection lane. Critical temperature-sensitive receipts received priority, while documentation exceptions were routed to a controlled hold area rather than blocking all receipts. Space capacity was remeasured using accessible pallet positions.

Outcome

After eight weeks, line accuracy increased to 99.3%, median dock-to-stock time fell to 5.1 hours, and late dispatches decreased by 38%. Reported space utilization fell from 94% to 87%, not because physical stock was removed, but because the denominator was corrected. This apparently negative KPI movement represented better measurement and greater operational accessibility. Overtime declined, although management continued monitoring whether the new process created hidden work.

Learning points

  1. An aggregate KPI can conceal critical concentration and customer impact.
  2. Correcting a denominator may make performance appear worse while improving decision quality.
  3. Service segmentation can reduce total cost without applying one process to every item.
  4. Productivity measures must recognize task complexity.
  5. Improvement claims require a defined baseline, comparable conditions and post-change verification.

11. Challenges and Limitations

Warehouse analytics faces several limitations. First, data may be incomplete or systematically biased toward scanned activities. Unrecorded rework, informal movements and waiting may disappear from the dataset. Second, KPIs can conflict because local optimization improves one process while worsening the end-to-end flow. Third, averages conceal variability and tail performance. Fourth, cost allocations may create false precision when activity drivers are weak.

Causal inference is particularly difficult. A reduction in cycle time after automation may result from lower demand, new staffing, seasonal effects or process redesign rather than the technology alone. Controlled pilots, matched comparisons and time-series analysis improve confidence.

Regulatory requirements may apply to traceability, pharmaceuticals, food, hazardous materials, worker safety, financial records and personal data. KPI definitions must not encourage bypassing mandatory controls. A fast process that compromises product integrity is not high performance.

Best-Practice Checklist

  • Define every KPI operationally and financially.
  • Use numerator, denominator, unit, time window and exception rules.
  • Display trends, variation and percentiles, not only averages.
  • Reconcile operational data with physical observation and financial records.
  • Segment results by product, customer, zone, shift and criticality where relevant.
  • Pair productivity with quality, safety and service measures.
  • Use Pareto analysis to prioritize, then investigate root causes.
  • Forecast at the decision level and report uncertainty.
  • Evaluate marginal cost against marginal service benefit.
  • Treat dashboards and AI recommendations as decision support, not substitutes for judgment.
  • Review targets when strategy, demand, layout or technology changes.

Chapter Summary

Warehouse analytics transforms operational events and financial data into decisions about service, capacity, quality and cost. Effective performance management uses a balanced set of KPIs, including inventory accuracy, dock-to-stock time, utilization, throughput, order-cycle time, picking accuracy, labour productivity and cost per order. Each measure requires precise definitions, consistent units, reliable data and appropriate interpretation.

Dashboards should show results, trends, variation and exceptions, while distinguishing missing data from zero performance. Costing should identify relevant cost objects and recognize fixed, variable, step, failure and opportunity costs. Pareto analysis helps prioritize concentrated problems but must be followed by root-cause investigation. Forecasting supports staffing and capacity decisions, although forecasts contain uncertainty and should be evaluated with suitable error measures.

The most important managerial principle is system balance. Lower cost, higher speed, better accuracy and greater utilization cannot be pursued independently. Cost–service analysis, segmentation, governance and controlled experimentation enable managers to improve the warehouse without shifting hidden costs or risks elsewhere in the supply chain.

Key Terms

KPI: A defined measure used to monitor performance against a purpose or target.

Dashboard: A structured visual interface presenting selected performance information.

Inventory accuracy: The degree to which recorded stock agrees with physical stock within a defined tolerance.

Dock-to-stock time: Elapsed time from receipt initiation to stock availability.

Space utilization: Occupied usable storage capacity expressed as a proportion of available usable capacity.

Throughput: Quantity processed per unit of elapsed operating time.

Order-cycle time: Time between order release and the defined completion event.

Picking accuracy: Proportion of picked order lines or orders completed correctly.

Labour productivity: Output achieved per unit of direct labour input.

Cost per order: Warehouse operating cost divided by completed orders within a stated cost boundary.

Cost-to-serve: Resource cost associated with serving a particular customer, product or activity pattern.

Pareto analysis: Ranking categories by contribution and examining cumulative impact.

Forecast: An estimate of future demand or activity based on available information.

Forecast error: Difference between actual demand and forecast demand.

Utilization: The proportion of available capacity currently used.

Leading indicator: A measure of conditions likely to influence future results.

Lagging indicator: A measure of an outcome that has already occurred.

Common-cause variation: Normal process variation arising from the system’s usual conditions.

Special-cause variation: Variation associated with an identifiable unusual event.

Cost–service trade-off: The relationship between resource expenditure and the service outcome achieved.

Review Questions

Short Answer Questions

  1. Why should warehouse performance be measured using a balanced set of KPIs rather than one productivity measure?
  2. Define dock-to-stock time and state two choices that must be specified when measuring it.
  3. What is the difference between a leading indicator and a lagging indicator?
  4. Why can high space utilization create operational risk?
  5. State two limitations of using cost per order as the only warehouse cost measure.

Long Answer Questions

  1. Explain how a warehouse dashboard should be designed for executive, process and diagnostic decision-making.
  2. Discuss the principles of warehouse cost-to-serve analysis, including cost objects, activity drivers and allocation risks.
  3. Explain Pareto analysis and evaluate its strengths and limitations in warehouse improvement.
  4. Discuss how forecasting can support labour and capacity planning, including the assumptions of moving-average and exponential-smoothing methods.
  5. Explain why warehouse managers must evaluate cost, quality, speed, capacity, safety and service as an interconnected system.

Analytical / Application Questions

  1. A facility records 2,400 stock records, of which 2,328 meet the accepted tolerance. Calculate inventory accuracy and explain why the result should be segmented before setting corrective action.
  2. A warehouse has fixed monthly costs of $60,000, variable handling cost of $2.10 per order and monthly volume of 18,000 orders. Calculate total cost and cost per order. Identify two conditions under which the calculation could mislead management.
  3. A distribution centre has increasing picking productivity but worsening customer complaints. Design a diagnostic analysis using at least four KPIs and explain the possible trade-offs that should be investigated.

Multiple Choice Questions with Answers

Question 1

Which measure most directly assesses whether recorded stock agrees with physical stock?

A. Throughput

B. Inventory accuracy

C. Dock-to-stock time

D. Cost per order

Correct Answer: B. Inventory accuracy

Question 2

A warehouse processes 4,000 order lines and 3,960 are correct. What is the picking accuracy?

A. 96.0%

B. 98.0%

C. 99.0%

D. 99.6%

Correct Answer: C. 99.0%

Question 3

Which statement best describes Pareto analysis?

A. It proves that every process follows an 80:20 relationship

B. It ranks categories by impact and examines cumulative contribution

C. It replaces root-cause analysis

D. It measures forecast uncertainty

Correct Answer: B. It ranks categories by impact and examines cumulative contribution

Question 4

A warehouse has usable capacity of 10,000 pallet positions and 8,700 occupied positions. What is utilization?

A. 8.7%

B. 13.0%

C. 87.0%

D. 115.0%

Correct Answer: C. 87.0%

Question 5

Which cost is most clearly a step cost?

A. Packaging tape used per carton

B. Rent within an existing lease

C. An additional supervisor required for a new shift

D. Electricity used by one scanner

Correct Answer: C. An additional supervisor required for a new shift

Question 6

In a three-period moving-average forecast, demand in the previous periods was 9,000, 10,500 and 10,200 orders. What is the next forecast?

A. 9,700 orders

B. 9,900 orders

C. 10,000 orders

D. 10,200 orders

Correct Answer: C. 10,000 orders

Question 7

Which dashboard practice is most appropriate?

A. Treat missing data as zero

B. Show only the latest value

C. Display target, trend, variance and data timestamp

D. Use one KPI for every warehouse process

Correct Answer: C. Display target, trend, variance and data timestamp

Question 8

Why can lines per labour hour be misleading when comparing warehouse zones?

A. Lines never represent output

B. Orders and lines always have identical complexity

C. Tasks may differ in travel distance and handling difficulty

D. Labour hours cannot be measured

Correct Answer: C. Tasks may differ in travel distance and handling difficulty

Question 9

Which statement about cost–service trade-offs is most accurate?

A. The lowest operating cost always gives the best performance

B. Service penalties and failure costs may justify additional operating cost

C. Service should never be segmented by product criticality

D. Inventory cost is unrelated to service policy

Correct Answer: B. Service penalties and failure costs may justify additional operating cost

Question 10

What is a major governance requirement for AI-based warehouse recommendations?

A. Removing all human review

B. Using only colour-coded dashboards

C. Documenting data lineage, validation and auditability

D. Maximizing worker speed regardless of safety

Correct Answer: C. Documenting data lineage, validation and auditability

Storekeeping & Warehouse Operations
Chapter 11 of 15