Course contents
Practitioner · Course 1: Warehouse Fundamentals · Lesson 5 of 5

Building a complete warehouse fundamentals worksheet

Level: FoundationTime: 45 minutesOrder used: Cedar & Co.'s own hybrid domestic buying, standing Make to Stock plus Make to Order top-up runs from Delta GarmentsTool: Warehouse fundamentals worksheet
For a domestic buyer or logistics new entrant who needs to see all four warehouse jobs recorded on one order, receiving to dispatch. Lessons T24-C01-L01 through L04 are useful background but not required. Figures are teaching examples in US dollars.
Domestic brandCedar & Co., 12 shops
Supply patternStanding Make to Stock forecast, plus a Make to Order top-up run when demand justifies it
SupplierDelta Garments, on 60-day open account
Warehouse jobs trackedReceiving, put-away, picking and packing, dispatch, all on one worksheet
Top-up run900 pieces, ordered after faster-than-forecast selling
What this lesson measuresHow one worksheet ties all four warehouse jobs to a single decision
02Opening

This page explains how to bring receiving, put-away, picking and packing, and dispatch together on one worksheet for a single order, so a warehouse decision is based on the full picture, not one job in isolation

This page is for a domestic buyer, a logistics new entrant, or anyone who needs to see all four warehouse jobs recorded against the same order at once. This lesson mainly teaches the product flow: it draws together receiving, put-away, picking and packing, and dispatch, the four jobs taught separately across this course, into a single worksheet that follows one order from arrival to departure.

Cedar & Co. runs a hybrid supply pattern: a standing Make to Stock forecast covers its own normal weekly sales, and a separate Make to Order top-up run is placed only when a style sells faster than that forecast expected. When a top-up run of 900 pieces arrives from Delta Garments, it passes through all four warehouse jobs taught in this course, and a buyer deciding whether the warehouse is actually ready to get those pieces to shops needs to see all four jobs at once, not just whichever one happened most recently.

03Before you start

What you need, and what this lesson does not cover

You need: lessons T24-C01-L01 through L04 are useful background but not required. A basic idea of the four warehouse jobs, receiving, put-away, picking and packing, and dispatch, is enough to start.

By the end of this lesson you can:

  • combine receiving, put-away, picking and packing, and dispatch records into one worksheet for a single order;
  • identify which of the four jobs is the current bottleneck when an order is running behind;
  • explain why checking only the most recently completed job can hide a problem in an earlier job;
  • use a completed worksheet to decide whether an order is genuinely ready to reach a shop;
  • explain why a hybrid buyer needs the same four-job worksheet for both its standing stock and its top-up runs.

Not covered here: the individual detail of each job, already covered in lessons T24-C01-L01 through L04.

04Key terms

Words you will meet in this lesson

TermMeaning
Warehouse cycleThe full sequence of receiving, put-away, picking and packing, and dispatch for one order.
Bottleneck jobWhichever of the four warehouse jobs is currently the slowest, limiting how fast the rest of the order can move.
Cycle worksheetA single record tracking one order's own progress through all four warehouse jobs at once.
Top-up runAn additional Make to Order production run placed on top of a standing Make to Stock forecast, when demand justifies it.
05Teaching
The rule

A single worksheet tracking all four warehouse jobs shows an order's own true position, which no single job's own record can show alone

A cycle worksheet records receiving, put-away, picking and packing, and dispatch for the same order side by side, so anyone reading it can see the order's own true position at a glance, rather than piecing it together from four separate records. Any one job's own record, taken alone, only ever answers a question about that job; only the combined worksheet answers the question a buyer actually needs answered: is this order ready to reach a shop, and if not, exactly which job is holding it back.

Cedar & Co.'s own top-up run size: 900 pieces
What you meet in real life

The same combined worksheet applies whether the order is a standing Make to Stock replenishment or a Make to Order top-up run

What can differThe shapes you will meetWhy it matters
A standing Make to Stock replenishmentCedar & Co.'s own regular shipments from Delta Garments follow the same four-job cycle every time, recorded on the same worksheet format each cycle.A repeating pattern makes the worksheet a routine check, not a one-off exercise, so a delay stands out quickly against a familiar baseline.
A Make to Order top-up runThe 900-piece top-up run follows the identical four jobs, but on a tighter timeline, since it exists specifically because demand is already outrunning the standing forecast.A top-up run has less slack to absorb a delay in any one job, since it was ordered precisely because speed already mattered.
An order stuck at one job while others show completeA worksheet might show receiving, put-away and picking and packing all complete, with dispatch still pending days later.Seeing all four jobs together makes an isolated bottleneck visible immediately; checking only the most recent update might miss that dispatch, not the earlier jobs, is where the delay actually sits.
An export order using the same four-job structureOrder A's own export shipment through Delta Garments' export warehouse uses the identical four-job worksheet structure, despite serving a completely different market.The same worksheet format works for both domestic and export orders because the underlying four jobs never change, only the specific figures inside them.
The case we follow

Cedar & Co. reviews a completed cycle worksheet for its own 900-piece top-up run before confirming shop deliveries

Cedar & Co.'s own top-up run of 900 pieces from Delta Garments reaches its distribution warehouse, and the buyer reviewing shop-delivery readiness pulls up the cycle worksheet for this specific run. The worksheet shows receiving complete at 900 of 900 pieces confirmed, put-away complete with all pieces recorded at location B3-A2, picking and packing complete for 3 of 4 planned shop deliveries, and dispatch pending for those 3 completed deliveries plus the picking and packing for the 4th delivery still in progress.

900-piece top-up run: all four jobs on one worksheetReceiving: 900/900 completePut-away: complete at location B3-A2Picking and packing: 3 of 4 deliveries doneDispatch: pending for all deliveries
Reading all four jobs together shows exactly where the 900-piece top-up run stands: fully received and located, mostly picked and packed, and not yet dispatched at all. No single job's own record alone shows this complete picture.
The worked number

Calculating what share of the top-up run is genuinely ready to move, across all four jobs together

Pieces confirmed at receiving: 900 of 900, 100%
Pieces confirmed at put-away: 900 of 900, 100%
Shop deliveries with picking and packing complete: 3 / 4 = 75%
Shop deliveries with dispatch complete: 0 / 4 = 0%

Reading only the receiving and put-away figures would suggest the order is 100% ready, but the picking and packing figure of 75% and the dispatch figure of 0% show the true position: no part of this 900-piece run has actually left the warehouse yet, regardless of how complete the earlier two jobs are.

The method

Four steps to build and read a complete cycle worksheet for any order

  1. List the order's own total quantity once, at the top of the worksheet, as the fixed reference point for all four jobs.
  2. Record each job's own status, receiving, put-away, picking and packing, and dispatch, as its own separate row or column, never combined into one summary figure.
  3. Identify the bottleneck job, the one with the lowest completion figure, since that job is what actually limits the order's own progress.
  4. Decide based on the bottleneck job specifically, not on the most recently updated job or the job that happens to show the highest number.
The trap

A common mistake is reporting an order as "on track" based on whichever job was most recently checked, rather than the job that is actually furthest behind

A common mistake is reporting an order's own status based on whichever job someone happened to check most recently, rather than checking all four jobs carefully and reporting the one that is genuinely furthest behind. A warehouse team that just finished put-away might report the order as "on track" because put-away went smoothly, without checking that picking and packing, or dispatch, are in fact running late that same day. What this costs Cedar & Co. is real: a shop expecting a top-up delivery on a specific date, told confidently the order is "on track" based only on a completed put-away step, has no warning that dispatch has not even started, and discovers the actual delay only when the expected delivery simply does not arrive on time.

What each reporting method actually reflectsReports most recently checked jobMay hide a real delay in an earlier or later jobReports the bottleneck jobReflects the order's own true, slowest point
Reporting the most recently checked job can hide a real delay elsewhere in the cycle. Reporting the bottleneck job reflects the order's own true position, wherever the slowdown actually is.
06In plain words

A cycle worksheet puts all four warehouse jobs for one order in a single place, so a buyer can see the whole picture at once instead of checking four separate records. Receiving and put-away being complete does not mean the order is ready; picking and packing and dispatch still need their own separate check, since each job can move at a different speed. The job with the lowest completion figure, called the bottleneck, is the one that actually decides how soon the order is genuinely ready, no matter how far ahead the other three jobs are. A report based on whichever job was checked most recently, rather than the bottleneck job specifically, can make an order look fine when it is actually stuck, simply because the check happened to land on a job that was going well.

07Quick check
  • A cycle worksheet records receiving, put-away, picking and packing, and dispatch for one order, side by side.
  • The bottleneck job, the one furthest behind, decides the order's own true readiness, not the most complete job.
  • Checking only the most recently updated job can hide a delay sitting in a different job entirely.
  • The same four-job worksheet structure applies to domestic replenishment, top-up runs, and export orders alike.
  • A worksheet showing 100% on two jobs and 0% on a third still means the order is not ready.
08Workplace scenario

A buyer at Cedar & Co. tells a shop manager the top-up run is "on track" after checking only the put-away record

A shop manager asks Cedar & Co.'s own buyer whether the 900-piece top-up run will arrive on the promised date. The buyer checks the most recent update available, which shows put-away complete, and replies that the order is on track, without checking the picking and packing or dispatch records for the same run.

Here is the message the buyer sends to the shop manager:

Top-up run update. All 900 pieces received and put away successfully at location B3-A2. Order is on track for the promised delivery date.

Does a completed put-away step justify telling the shop manager the order is "on track"? Decide before opening the answer.

Show decision

No, a completed put-away step alone does not justify saying the order is "on track." Two facts missing from the buyer's message decide this.

First, put-away completion only confirms the pieces are located inside the warehouse; it says nothing about whether picking and packing or dispatch, the two jobs still ahead, are on schedule. If either of those two jobs is running behind, the "on track" claim is simply not true, regardless of how well receiving and put-away went.

Second, the cycle worksheet for this specific run shows picking and packing only 75% complete and dispatch at 0%, which the buyer never checked before sending the update. The shop manager is being told the order is fine based on the two jobs that happen to be furthest ahead, not the two jobs that actually decide whether the delivery date will be met.

The corrected message should report the bottleneck job specifically, picking and packing or dispatch, whichever is furthest behind, rather than the job that happens to look best.

09What it costs

What reporting based on the wrong job costs a shop's own delivery planning

Using this lesson's own fixed figures:

Pieces reported as "on track" based on put-away alone: 900 pieces
Shop deliveries actually dispatched at the time of that report: 0 of 4, 0%
Days of false confidence created if the shop plans staff and floor space around an "on track" report that is actually 0% dispatched: at minimum, the gap between the report date and the actual dispatch date

The cost here is not measured only in pieces or dollars; it is measured in a shop planning its own staff schedule and floor space around a delivery date that a misleading "on track" report never actually confirmed, discovering the real delay only when the expected stock fails to arrive.

10Working template

Warehouse fundamentals worksheet: the complete cycle sheet bringing all four jobs together

Open the course workbook's "Full cycle" sheet. It combines the receiving, put-away, picking and packing, and dispatch sheets from the previous four lessons into one view for a single order, automatically highlighting whichever job shows the lowest completion percentage as the current bottleneck. Enter a different order's own figures across all four jobs to see its true readiness at a glance.

[Download the Warehouse fundamentals worksheet](../../templates/T24-C01-warehouse-fundamentals-worksheet.xlsx)

Download the Warehouse fundamentals worksheet (Excel)

11Check yourself

1. A cycle worksheet shows receiving and put-away both 100% complete, picking and packing at 75%, and dispatch at 0%. What does this worksheet actually show about the order's own readiness?

2. A buyer reports an order as 'on track' based only on the most recently checked job, without reviewing the other three jobs on the cycle worksheet. What risk does this create?

12Glossary
ENARFRTRMeaning
Warehouse cycleدورة المستودعCycle d'entrepôtDepo döngüsüThe full sequence of receiving, put-away, picking and packing, and dispatch for one order.
Bottleneck jobالمهمة العنق الزجاجيTâche goulot d'étranglementDarboğaz işWhichever of the four warehouse jobs is currently the slowest, limiting how fast the rest of the order can move.
Cycle worksheetورقة عمل الدورةFiche de cycleDöngü çalışma sayfasıA single record tracking one order's own progress through all four warehouse jobs at once.
Top-up runالدفعة التكميليةProduction complémentaireEk üretim partisiAn additional Make to Order production run placed on top of a standing Make to Stock forecast, when demand justifies it.
13Next

Course complete

This is the final lesson of Warehouse Fundamentals. You have covered what a warehouse does, how it receives, stores, picks and packs a single order, and how those four jobs come together in one worksheet to support a real decision. Back to the course map

14Ladder

RecognizeName the four warehouse jobs a complete cycle worksheet brings together for one order.
ConnectSee how Cedar & Co.'s own top-up run's true readiness depends on its bottleneck job, not its most complete job.
CompareWeigh a report based on the most recently checked job against a report based on the bottleneck job.
DecideJudge whether a completed put-away step justifies telling a shop manager an order is "on track."