Course contents
Practitioner · Course 2: Capacity Planning · Lesson 3 of 5

Building a capacity booking sheet across multiple lines and multiple orders

Level: PractitionerTime: 45 minutesOrder used: A (the T-shirt) and B (the jeans)Tool: Capacity booking calculator
This lesson is for a merchandiser or production manager who tracks more than one line and more than one order at once. Line and quantity figures are teaching examples; no shared booking-sheet figure is fixed in the master cast.
FactoryDelta Garments
Line 1 weekly capacityabout 8,988 pieces (illustrative)
Booked, Order A's shape4,800 pieces that week
Booked, new enquiry900 pieces, same week
Combined utilisationabout 63.4% (illustrative)
Second buyer on the sheetCedar & Co., domestic MTS
02Opening

This page explains how to build a shared booking sheet that records every line's commitments across several orders and weeks, and how to read utilisation from it

This page is for anyone who has to track more than one line carrying more than one order at once. Lesson 8.2.2 gave a single line's actual daily capacity; this lesson extends that figure into a shared record the whole planning team can read together. It mainly teaches an information flow: how bookings from different orders, on different lines, in different weeks, are recorded so anyone checking the sheet sees the same, complete picture.

This matters most at a factory like Delta Garments, running an export order for Northline Apparel alongside domestic production for Cedar & Co. on the same lines. Checking a new booking against a line's capacity in isolation, without adding it to everything else already booked, can make a line look free when it is not.

Without a shared sheet, two people can each confirm a booking to the same line in the same week without seeing what the other already committed. This lesson gives the method: calculate weekly capacity, record every commitment as its own row, and add together everything booked to the same line and week before comparing against capacity.

03Before you start

What you need, and what this lesson does not cover

You need: a line's actual daily capacity, calculated as in lesson 8.2.2. You do not need to have tracked more than one order on a shared sheet before.

By the end of this lesson you can:

  • calculate a line's actual weekly capacity from its actual daily capacity and the working days booked;
  • record every order and week committed to a line as its own row on a shared booking sheet;
  • add together every quantity booked to the same line in the same week before checking it against capacity;
  • calculate utilisation for a line and week from combined booked quantity divided by weekly capacity;
  • avoid the common mistake of checking a new booking against a line's capacity without adding it to what is already booked.

Not covered here: calculating a line's actual daily capacity itself (lesson 8.2.2), what happens once a line's combined booking exceeds its weekly capacity (lesson 8.2.4), and running the complete method end to end for a brand-new order (lesson 8.2.5).

04Key terms

Words you will meet in this lesson

TermMeaning
Booking sheetA shared record that lists which lines are committed to which orders, in which weeks, and how much of each line's capacity each commitment uses, so every booking can be checked against the same total.
Capacity utilisationThe share of a factory's available capacity actually being used by confirmed orders, expressed as a percentage of its maximum output.
Pre-negotiated capacityFactory production capacity a buyer reserves ahead of a season, before a specific order is confirmed.
Make to Order (MTO)Production starts only after a specific buyer has confirmed a specific order, with quantity, price and delivery date agreed.
Make to Stock (MTS)Producing against the seller's own sales forecast, rather than a single confirmed buyer order.
05Teaching
The rule

A capacity booking sheet records every line's actual weekly capacity against every order and week committed to it, so combined booked quantity can be checked against what a line can actually deliver

A capacity booking sheet records every line's actual weekly capacity, actual daily capacity from lesson 8.2.2 multiplied by the working days booked that week, against every order and week committed to that line. The total quantity booked to a line in a week can then be compared, on one shared record, against what that line can actually deliver that week. The same check Track 7 made only at the whole-factory level is here made line by line and week by week, and across more than one order at a time.

1,498 × 6 = 8,988

Line 1's actual weekly capacity, in pieces: actual daily capacity (lesson 8.2.2) multiplied by 6 working days booked that week.

Line 1, this weekPieces bookedOrder A's own shape4,800New enquiry900Combined total booked5,700Line 1 weekly capacity≈ 8,988
Two separate bookings on Line 1 in the same week must be added together before comparing against weekly capacity. Checked separately, both 4,800 and 900 look small against 8,988; checked correctly as a combined 5,700, the line still has spare capacity, but only because the addition was actually done.
What you meet in real life

The same add-then-compare method applies whether one line carries one order or several lines share several orders

A person who has only booked one line against one order should not assume every booking looks the same. The method does not change; how many rows feed into the same line-and-week total does.

What can differThe shapes you meetWhy it matters
One line, one order, one weekThe simplest booking, where a single order's quantity for a week is compared directly against that line's weekly capacity.The baseline case the method scales up from.
One line, two orders sharing the same weekA new enquiry added to a line already carrying Order A's own shape in the same week.Both quantities booked to that line that week must be added together before comparing the total against the line's weekly capacity, not checked as two separate, unrelated bookings.
The same order split across two linesA single order too large for one line's weekly capacity booked partly to Line 1 and partly to Line 2, each recorded as its own row.The order's total quantity is only found by adding the two lines' bookings together.
Export order booked ahead versus domestic order booked against current free capacityAn export order for a buyer like Northline Apparel may be booked as soon as pre-negotiated capacity is agreed, weeks before production starts; a domestic Make to Stock order for Cedar & Co. is booked against whatever capacity the sheet currently shows as free.An export slot may already be reserved months ago; a domestic slot is checked fresh against today's sheet.
The case we follow

Delta Garments' Line 1 and Line 2, booked against Order A's own shape for Northline Apparel and a new domestic run for Cedar & Co. in the same week

Delta Garments' Line 1 and Line 2 are booked illustratively against Order A's own shape and a new, similar-sized enquiry in the same week, continuing the figures introduced in lessons 8.2.1 and 8.2.2. The new enquiry on this shared sheet is Cedar & Co.'s own domestic Make to Stock run, booked against the sheet's currently free capacity rather than a seasonal reservation.

FactWhat it tells the planning team
Line 1's actual weekly capacity, about 8,988 pieces (illustrative)The ceiling that everything booked to Line 1 that week must fit inside
Order A's own shape, 4,800 pieces booked that weekOne row on the shared sheet, for Northline Apparel's export order
Cedar & Co.'s new enquiry, 900 pieces, same weekA second row on the same sheet, for a domestic Make to Stock run
What the sheet must show before either booking is confirmedBoth rows added together, compared as one combined total against Line 1's weekly capacity
The worked number

Line 1's combined booked quantity for the week, checked against its actual weekly capacity

This example is illustrative, not a claimed fixed academy fact: Line 1's actual daily capacity from lesson 8.2.2 is about 1,498 pieces; booked for 6 working days that week, its weekly capacity is about 1,498 × 6 = 8,988 pieces. If Order A's own shape is booked for 4,800 pieces that week and Cedar & Co.'s new enquiry is booked for 900 pieces in the same week on Line 1, the combined quantity booked is 4,800 + 900 = 5,700 pieces, giving a utilisation of 5,700 ÷ 8,988 ≈ 63.4%, well under 100%, so Line 1 has spare capacity that week for the combined bookings shown.

4,800 + 900 = 5,700

Combined quantity booked to Line 1 that week: Order A's own shape plus Cedar & Co.'s new enquiry.

5,700 ÷ 8,988 = 63.4%

Line 1's utilisation that week: combined booked quantity divided by actual weekly capacity.

5,700 booked ≈ 63.4%spareOf Line 1's 8,988-piece weekly capacity, the combined 5,700-piece booking leaves real, unbooked room that week.
Line 1's combined booking uses about 63.4% of its weekly capacity, leaving genuine spare room. This figure is only correct because both orders booked to Line 1 that week were added together first.
The method

How to build and read a multi-line, multi-order booking sheet

  1. Calculate each line's actual weekly capacity from its actual daily capacity and the working days booked that week.
  2. List every order and week committed to each line as its own row.
  3. Record the quantity booked for each order in each row.
  4. Add together every quantity booked to the same line in the same week to get that line's total booked quantity.
  5. Divide the line's total booked quantity by its weekly capacity to get utilisation for that line and week, and flag any week where booked quantity exceeds weekly capacity.
The trap

Checking each order's booking against a line's capacity one at a time, without adding it to everything else already booked

A common mistake is checking each order's booking against a line's capacity one order at a time, without adding it to everything else already booked to that same line in the same week. This can make a line look like it has spare capacity when the combined total of all its bookings that week has already used it up.

06In plain words

A booking sheet is a shared list of which lines are committed to which orders, in which weeks. To use it correctly, first work out how many pieces a line can actually make in a week. Then list every order booked to that line for that week as its own row. If more than one order shares the same line and week, add their quantities together before comparing the total against the line's weekly capacity. Checking one order at a time, without adding it to what else is already booked, can make a line look free when its combined bookings have already filled it up.

07Quick check
  • A line's actual weekly capacity = actual daily capacity × working days booked that week.
  • Every order and week committed to a line is its own row on the shared booking sheet.
  • Two or more orders sharing the same line and week must be added together before comparing against weekly capacity.
  • Utilisation for a line and week = combined booked quantity ÷ actual weekly capacity.
  • A single order can be split across two lines; its total quantity is found by adding the two lines' bookings together.
  • Export orders may reserve pre-negotiated capacity months ahead; domestic Make to Stock orders are booked against whatever the sheet currently shows as free.
08Workplace scenario

Sara asks whether Line 1 can also carry a new 900-piece domestic enquiry in the same week Order A's own 4,800-piece shape is already booked to it

Mona is asked by Sara whether Line 1 can also carry a new 900-piece enquiry in the same week Order A's own 4,800-piece shape is already booked to it. Mona has only checked the new enquiry's 900 pieces against Line 1's weekly capacity on its own, without adding it to Order A's existing booking.

  • Line 1's weekly capacity that week is about 8,988 pieces (illustrative, from actual daily capacity × 6 working days).
  • Order A's own shape already has 4,800 pieces booked to Line 1 that week.
  • The new enquiry alone, at 900 pieces, is well under weekly capacity if checked by itself.

Karim's note to Mona:

"Mona, before you confirm the new 900-piece enquiry on Line 1, check it against everything already on the sheet for that week, not just on its own."

Is it enough for Mona to check only the new 900-piece enquiry against Line 1's weekly capacity, without adding it to Order A's existing 4,800-piece booking?

Show decision

No. Mona must add the new enquiry's 900 pieces to Order A's existing 4,800 pieces already booked to Line 1 that week, giving a combined total of 5,700 pieces, and compare that combined total against Line 1's weekly capacity of about 8,988 pieces.

First, a line's weekly capacity is shared across every order booked to it in that week, not reset for each new order checked.

Second, checking the new enquiry in isolation (900 against 8,988) would have looked safe on its own while ignoring the 4,800 pieces already committed.

In this illustrative case the combined 5,700 pieces still fits under 8,988, so Mona can confirm — but only because she added both bookings together first.

09What it costs

The cost of approving bookings order by order without adding them together on the shared sheet

If Mona had approved bookings order by order without adding them together, a third order arriving later in the same week could push the combined total past Line 1's weekly capacity of about 8,988 pieces without anyone noticing until the line was already overcommitted.

8,988 − 5,700 = 3,288

Line 1's remaining spare capacity that week, in pieces, after the combined 5,700-piece booking — the room a third, unchecked order could silently use up.

Catching an overbooked line before confirming a date avoids the overtime or delay costs that lesson 8.2.4 covers directly; a shared, correctly added sheet is what makes that catch possible before a promise is made.

10Working template

Capacity booking calculator: the "Multi-Order Booking Sheet"

This lesson uses the "Multi-Order Booking Sheet" of the course's Capacity booking calculator, which reads each line's actual daily capacity from the "Line Daily Capacity" sheet and calculates weekly capacity, booked quantity totals and utilisation for every line, order and week entered. Enter one row per order per line per week, and let the sheet add same-line, same-week rows together automatically before comparing against capacity. Download link: the course tool, `templates/T08-C02-capacity-booking-calculator.xlsx`.

Download the Capacity booking calculator (Excel)

11Check yourself

1. When two orders are booked to the same line in the same week, how should their booked quantities be checked against the line's weekly capacity?

2. A line's actual daily capacity is 1,000 pieces and it is booked for 5 working days in a week. What is its weekly capacity?

3. An order too large for one line's weekly capacity is split across two lines. How is the order's total booked quantity found?

12Glossary
ENARFRTRMeaning
Booking sheetورقة الحجزFiche de réservationRezervasyon tablosuA shared record that lists which lines are committed to which orders, in which weeks, and how much of each line's capacity each commitment uses, so every booking can be checked against the same total.
Capacity utilisationمعدل استغلال الطاقة الإنتاجيةTaux d'utilisation de la capacitéKapasite kullanım oranıThe share of a factory's available capacity actually being used by confirmed orders, expressed as a percentage of its maximum output.
Pre-negotiated capacityطاقة إنتاجية محجوزة مسبقًاCapacité pré-négociéeÖnceden ayrılmış kapasiteFactory production capacity a buyer reserves ahead of a season, before a specific order is confirmed.
Make to Order (MTO)الإنتاج حسب الطلبFabrication sur commande (MTO)Siparişe göre üretim (MTO)Production starts only after a specific buyer has confirmed a specific order, with quantity, price and delivery date agreed.
Make to Stock (MTS)إنتاج حسب المخزونFabrication sur stockStoğa üretimProducing against the seller's own sales forecast, rather than a single confirmed buyer order.
13Next

Lesson 8.2.4: What happens when a factory overbooks its own capacity

You now know how to add every commitment to the same line and week together before checking utilisation. The next lesson looks at what happens, and what it costs, when that combined total exceeds a line's actual weekly capacity. Back to the course map

14Ladder

RecognizeName what a capacity booking sheet records for every line, order and week.
ConnectSee why two orders sharing the same line and week must be added together before checking capacity.
CompareTell a booking checked in isolation from one checked against everything already on the sheet.
DecideAdd every commitment to a line and week together before confirming a new booking against it.