dp.Djellon Pllana
← All projects

PROJECT 008 / 102 · Commerce

Order size and fulfillment workload.

How does product variety per invoice relate to order value and units to handle?

Focused analytical studyRetailExecuted notebook

THE RESULT

What the data shows

The largest computed metric is 384 for (50.0, inf]; the smallest is 12 for (0.0, 1.0]. Metric: median_units (Units per invoice).

Distinct codes measure variety, not package count; bulk buyers can dominate units.

Order size and fulfillment workload — chart from the computed study output
Computed study output. Full values and units are available in the results download.
Computed results · 6 of 6 rows. Values rounded for display; source units and raw column names are retained in the download.
item bandordersmedian unitsmedian value gbp
(0.0, 1.0]1,6411245
(1.0, 5.0]2,86756122.4
(10.0, 25.0]6,660172309.4
(25.0, 50.0]3,711255453.1
(5.0, 10.0]2,97998189.2
(50.0, inf]2,102384836.4
Download the complete result table ↓

THE METHOD

From source to answer

Aggregate invoice lines before calculating order-size bands.

The Python source exposes this study’s transformations. The complete project download includes shared preparation and evaluation routines.

THE NEXT DECISION

What follows from the finding

Compare handling effort across order types once packing-time and fulfillment-cost records are available.

Where the conclusion stops

Historical invoice lines; credits are not reliably matched to original sales. Gross purchases are not profit. Unidentified customers cannot support customer-level conclusions. Exact repeated lines remain unless the study explicitly compares removal.

Related studies may reuse observations or holdouts. These are historical analyses; associations and backtests do not demonstrate commercial impact. Further model tuning needs new, untouched evaluation data.