Skip to content

The apparel WIP report: what to track and how to read it

By UniformsOS Team. Updated .

What a WIP report is

In a custom apparel shop, an order is in WIP from the moment production starts until the box leaves the dock. On any given day a busy shop has dozens of these, spread across stages and often across factories.

The WIP report is the daily view of all of them. It answers three questions. What is on the floor? Where is each job? Which jobs are in trouble?

It is not the order list. The order list includes quotes, unpaid orders and orders that shipped last month. It is not the production schedule either. The schedule is the plan. The WIP report is what is actually happening.

The columns that matter

Column What it holds Why it is there
Order number Your order or PO number The key everyone uses on the floor and on the phone
Customer The team, school, league or brand Who to call when a date moves
Product and units Style and total pieces Late on 300 units is not the same problem as late on 12
Factory or line Who is making it Where to chase
Stage The current production step Where the job is right now
Days in stage Days since it entered that stage The first sign of a stuck job
Ship-by date The day it must leave to arrive on time The only deadline that counts
Days left Ship-by date minus today The column you sort by
Status On schedule, at risk or late The call, made by rule
Blocker One line on what the job is waiting for Turns a status into an action

Stop there. Price, margin and the full artwork belong on the order. A WIP report with thirty columns does not get read.

The stages

Use the stages your floor really has. For sublimated teamwear a typical flow is:

  1. Not started. Approved and released to production. Nothing made yet.
  2. Test print. A printed sample, also called a strike-off, to approve color and placement.
  3. Sublimation. The design is printed to transfer paper and heat-pressed into the fabric.
  4. Sewing. Panels are cut and assembled.
  5. QA. Pieces are counted, checked against the order and measured.
  6. Packing. Sorted by player or by size, bagged, boxed and labeled.

Once the box ships, the order leaves the report.

A screen print shop has different steps: separations, screens, printing, curing. An embroidery shop has digitizing, hooping, stitching and trimming. Six to eight stages is enough for most shops. If a step takes less than a few hours, fold it into the one next to it.

Stage norms

Days in stage means nothing without a norm to compare it to. Set a standard duration for every stage, and set it from your own history, not from a guess.

Take your last 50 shipped orders. For each stage, find the median time jobs spent there. That is your norm. An example, not a benchmark:

Stage Norm
Test print 2 days
Sublimation 3 days
Sewing 5 days
QA 1 day
Packing 1 day

Any job that has been in a stage longer than the norm gets flagged, whatever its status says.

How status gets decided

Status should come from a rule, not from whoever updated the row.

  • Late: the ship-by date has passed.
  • At risk: the days left are fewer than the days the remaining stages normally take.
  • On schedule: everything else.

Here is the at-risk rule at work, using the norms above. An order has been in Sewing for 2 days and has 4 days left before its ship-by date. Sewing normally takes 5 days, so it needs 3 more. QA needs 1. Packing needs 1. That is 5 days of work and 4 days to do it in. Nothing is late yet, and the order is already a day short.

Catching that order today, while a day can still be found, is the reason the report exists.

How to read it in five minutes

  1. Sort by days left, smallest first.
  2. Read every late and at-risk row. Each one needs a blocker and a name next to it.
  3. Scan days in stage for anything over its norm, even if the status says on schedule.
  4. Count the jobs in each stage. A pile in one stage is this week's bottleneck.
  5. Look for rows with no factory or line assigned. Those jobs were released and nobody owns them.

Do it at the same time every day, before the floor gets busy.

Numbers worth tracking over time

  • On-time ship rate. Orders shipped on or before their ship-by date, divided by all orders shipped.
  • Cycle time. Days from production start to ship. Use the median, because one disaster order distorts an average.
  • Units in WIP. Total pieces on the floor. If it climbs while shipments stay flat, the floor is filling up.
  • Aging by stage. How many jobs are past the norm in each stage.

Mistakes that make the report useless

Tracking the delivery date instead of the ship-by date. The customer cares when the box arrives. The floor can only control when it leaves. Subtract transit time and track that.

Updating it weekly. A weekly report describes last week. Stages should update the moment a job moves.

Typing the status by hand. Hand-typed statuses are optimistic. Calculate them.

One row for an order that is split across two factories. Each factory's part can be late on its own. Give each purchase order its own row.

Keeping it inside production. The people who answer customer calls need it more than anyone.

Spreadsheet or software

A spreadsheet works while one person updates it and can hold the whole floor in their head. It starts to fail when two people edit it, when factories report by email, or when stage changes happen somewhere the sheet does not see.

In UniformsOS the WIP sheet is built from the orders themselves. When a job moves on the production board, its row updates. Days in stage and schedule status are calculated, and the sheet filters by stage, factory and rep and exports to CSV. More on the Production WIP module.

FAQ

What does WIP mean in apparel production?
Work in progress. It covers every order that has started production and has not shipped.
How often should a WIP report be updated?
Whenever a job changes stage. Review it once a day.
What is the difference between a WIP report and a production schedule?
The schedule is the plan for when each job should move. The WIP report shows where each job actually is. You need both, and the gap between them is where the problems are.
Who should see the WIP report?
Production, customer service and sales. Factory partners should see their own rows.

Try UniformsOS free for 30 days

30-day free trial, every module on, no card needed.

All articles