A materials order from the swatch and trim card: need with losses and shrinkage, packing, minimum lot, surplus and order date
From the number of garments and a table of materials (consumption per garment, losses, shrinkage, price, packing, minimum lot, lead time) it counts the need for every item, the order allowing for the roll and the minimum lot, the surplus and its cost, the cost of materials per garment and the week by which the order must be placed. It shows where the minimum lot exceeds the need and pays for a surplus. Set the prices, packing and lead times from supplier offers; the default values are illustrative.
At a glance
- What question does it answer?
- How much of every material to order allowing for losses, shrinkage, the roll and the minimum lot, how much money goes into the surplus and by which week the order must be placed.
- What data is needed?
- The number of garments in the batch and the week the cutting starts.
- How to read the result?
- Example at the default values (a shirt-jacket, 1,200 garments, 8 items): an order worth RUB 1.62 million, RUB 1,352 per garment; a surplus after the roll and the minimum lot of RUB 18,648 (1.1% of the order); items where the minimum lot exceeds the need: 1; the order must be placed no later than week 28. Example on the default values: Items in the card: 8; Order value: RUB 1.62 million; Materials per garment: RUB 1,352; The need without surplus, in money: RUB 1.6 million. The figures are illustrative: enter your own to see your result.
Why and how to reason
Materials purchasing goes wrong in two ways: it is ordered by net consumption and there is not enough, or it is ordered with a reserve and the money freezes in the warehouse. The calculation goes in a chain. The consumption per garment is multiplied by the number of garments, losses (roll defects, fitting, samples) are added and, for fabric, it is divided by one minus shrinkage: after washing part of the length disappears, so more must be bought. Then the need is raised to the supplier’s minimum lot and rounded up to a roll or a pack. The difference between the order and the need is the surplus, and it costs money. At the default values for 1,200 garments the shell fabric needs 2,754 m (2,520 m net, losses 6%, shrinkage 3%), the order is 2,760 m, that is 46 rolls of 60 m. The patch needs 1,236 pcs but the minimum lot is 2,000: the surplus of 764 pcs costs RUB 9,168. The whole order is RUB 1.62m, RUB 1,352 per garment.
When to use it
Apply when launching a batch, when the swatch and trim card is approved and the supplier offers are known: prices, packing, minimum lots, lead times. The calculation does not replace the marker: the consumption per garment is taken from it. It does not account for partial deliveries and volume discounts; for them set an average price. For footwear give pairs and lasts instead of meters, for accessories parts and hardware, for children’s the weighted average consumption by size.
How to read the result
Look at four numbers. The order sum and the materials per garment (RUB 1,352): compare with the target cost. The share of the surplus (1.1% of the order, RUB 18,648): if it is large, unify materials between models or agree a smaller lot. The number of items where the minimum lot exceeds the need (one, the patch): this is a place for negotiation. The order week (the 28th): if it has already passed, move the cutting or speed up the delivery. The next step: reconcile the sum with the purchase budget and check the acceptance of the first rolls by the fabric reference. If the sum is above the target cost, start with the costliest item.
Common mistakes
They forget shrinkage and losses or count the marker losses twice: they are already inside the consumption by the marker. They take the price from an offer without checking the width and density of the fabric. They do not compare the minimum lot with the need. They count the date from the order and not from the week the cutting starts. They set one shrinkage for all fabrics: the shell and the lining have different ones.
What data is needed?
- The number of garments in the batch and the week the cutting starts.
- Consumption per garment by the marker and the specification, losses and shrinkage by a sample.
- The price, packing, minimum lot and lead time from supplier offers.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Garments in the batch | units | 1,200 | How many garments of this model are planned: every material’s consumption is multiplied by this number. The example value is illustrative. |
| Week the cutting starts | week no. | 36 | The number of the week of the year when the materials must be at the factory or in cutting; the order date is counted back from it. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Need | N = garments × consumption × (1 + losses) ÷ (1 − shrinkage) |
| Order | Q = rounded up to the packing from max(N; minimum lot) |
| Surplus | Q − N, in money (Q − N) × price |
| Date | week the cutting starts − the lead time in weeks, rounded up |
| Per garment | sum of orders ÷ garments |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Items in the card
- 8
- Order value
- 1.62 m ₽
- Materials per garment
- 1,352 ₽
- The need without surplus, in money
- 1.6 m ₽
- Surplus after packing and the minimum lot, in money
- 18,648 ₽
- Share of surplus in the order
- 1.1 %
- Items where the minimum lot exceeds the need
- 1
- Share of the costliest item in the order
- 71.4 %The item: Shell: cotton-polyester twill.
- Place the order no later than week
- 28The longest lead time is taken: the lead time in weeks is subtracted from the week the cutting starts.
- Materials per garment without surplus
- 1,337 ₽
- Need
- Surplus
Data as a table
| Measure | Need | Surplus |
|---|---|---|
| Shell: cotton-polyester twill | 1.16m | 2,598 |
| Lining | 251k | 4,286 |
| Fusible interlining | 64.8k | 1,200 |
| Zipper | 46.5k | 988 |
| Buttons | 38.9k | 216 |
| Thread | 27.7k | 0 |
| Composition and care label | 3,708 | 192 |
| Logo patch | 14.8k | 9,168 |
The order by item
| Material | Need | Order | Surplus | Order value | Order week |
|---|---|---|---|---|---|
| Shell: cotton-polyester twill | 2,753.8 | 2,760 | 6.2 | 1.16 m ₽ | 28 |
| Lining | 1,671.4 | 1,700 | 28.6 | 255,000 ₽ | 30 |
| Fusible interlining | 589.1 | 600 | 10.9 | 66,000 ₽ | 31 |
| Zipper | 1,224 | 1,250 | 26 | 47,500 ₽ | 31 |
| Buttons | 8,652 | 8,700 | 48 | 39,150 ₽ | 32 |
| Thread | 504 | 504 | 0 | 27,720 ₽ | 33 |
| Composition and care label | 1,236 | 1,300 | 64 | 3,900 ₽ | 33 |
| Logo patch | 1,236 | 2,000 | 764 | 24,000 ₽ | 30 |
The calculation: need = garments × consumption × (1 + losses) ÷ (1 − shrinkage); the order is not below the minimum lot and is a multiple of the packing. Shrinkage goes into the fabric purchase and not into the consumption by the marker. A surplus is not necessarily lost: it can be used in the next batch or another model, but the money in it is already frozen. For footwear pairs and lasts are counted instead of meters, for accessories parts and hardware, for children’s the consumption of the smaller sizes and smaller minimum lots per colour.
“Logo patch”: the minimum lot 2,000 exceeds the need 1,236; the surplus 764 pcs costs 9,168 ₽.
Nuances and limits
- Not putting shrinkage into the fabric purchase: after washing there is not enough material.
- Ordering exactly by the need and ignoring the minimum lot and the roll: the supplier ships more and the money is frozen.
- Counting the date from the order without the week the cutting starts: the materials arrive after production has begun.