Color and fabric MOQ
Shows how many pieces a color needs to use up the minimum fabric run, how much fabric and money is left over and what each color costs: with leftovers, with a small-run surcharge or whether to merge colors.
At a glance
- What question does it answer?
- How many pieces a color needs to use up the fabric minimum and what to do if the plan falls short.
- What data is needed?
- Fabric use per piece and the allowance for shrinkage and defects.
- How to read the result?
- If a color’s plan is below the minimum there are three ways: raise the run, merge colors or pay the surcharge. The calculation shows the price of each and a verdict against the cost-rise allowance. Count leftover fabric as money in stock. Example on the default values: Minimum pieces per color — 179; Colors below the minimum — 2; Surplus fabric on colors bought at the minimum — 48 m; Value of the surplus — RUB 31,200.
Why and how to reason
A fabric mill sells not meters but a minimum lot per color (MOQ). If few items go into a color, you pay for fabric that will not be used. First the consumption per piece with shrinkage allowance: 1.6 m × 1.05 = 1.68 m. Minimum pieces per color = 300 m ÷ 1.68 = 179. Then each color has two roads: buy the full lot and pay for the surplus (assuming half of it is reused later), or pay a small-run surcharge (15%). The cheaper one wins. Beige: needs 252 m, surplus 48 m, surplus cost RUB 31,200 (48 × 650), after reuse the loss is half, RUB 15,600. Cost rise per piece 9.5%, within the 10% allowance: take it. Green: 60 pieces, surcharge 15% above the 10% allowance, so merge colors.
When to use it
It comes in handy when planning the color palette and a color falls below the minimum lot. Assumptions: one price per meter for all colors, leftover fabric can be reused (share is set), surcharge for a small run is known from negotiation. It does not fit if you buy from a supplier stock by the meter without an MOQ, or if a color is strategic (the face of the collection) and must be made anyway: then the tool shows the price, it does not forbid it.
How to read the result
Check how many colors are below the minimum (2 of 4 here) and the verdict per color: pays, take, merge. A merged color is usually best: two colors of 100 pieces become one of 200 and the MOQ is met. Loss after reuse shows real money: if leftover fabric sits idle, count the full surplus cost. The allowed rise depends on margin: with high margin 10% on fabric is bearable, with low margin not. For colors marked merge, consider swapping to a neighboring color or moving to next season; for take, fix where the leftover fabric will be used.
Common mistakes
The usual mistakes: leaving out shrinkage and scrap in consumption; assuming leftovers will always be used (they must be used next season, otherwise the loss is total); comparing colors without the surcharge; keeping 1–2 pieces in a color for the window. Leftovers are reusable only in the same quality and color: next year seasonal color rarely matches. Check that the minimum lot is in the same units as consumption: meters against kilograms.
What data is needed?
- Fabric use per piece and the allowance for shrinkage and defects.
- The minimum run per color and the price per meter from the offer.
- The piece plan by color, the small-run surcharge, the share of leftovers usable later.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Fabric use per piece | m | 1.6 | Meters of fabric per item from the patterns, including the marker. |
| Allowance for shrinkage and fabric defects (optional) | % | 5 | An allowance for shrinkage and fabric defects in percent: added to the usage. Empty: 0. |
| Minimum run per color | m | 300 | From the dye house or supplier’s offer. |
| Price per meter | ₽ | 650 | The price of a meter of fabric excl. VAT from the supplier’s offer; the cost of the minimum lot and of leftover fabric is counted from it. |
| Small-run surcharge | % on the fabric price | 15 | If the supplier sells below the minimum at a markup. Empty or 0: no such option. |
| Share of leftover fabric usable later | % | 50 | What share of the surplus fabric above the run you will later use in another style or sell, in percent. |
| Acceptable rise in fabric cost per piece | % | 10 | A rule of thumb, replace with your own: above it, merge or drop the color. |
How it is calculated
| Step | Formula |
|---|---|
| Use with allowance | use × (1 + allowance) |
| Minimum pieces per colour | run per colour ÷ use with allowance, rounded up |
| Buy at the minimum | piece cost = use × price + (minimum − needed) × price × (1 − reusable share) ÷ pieces |
| With surcharge | use × price × (1 + surcharge) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Minimum pieces per colour
- 179Minimum run ÷ fabric use per piece with allowance.
- Colours below the minimum
- 2
- Surplus fabric on colours bought at the minimum
- 48 m
- Value of the surplus
- 31,200 ₽
- Loss after reuse
- 15,600 ₽
Colours
| Colour | Pieces | Needed, m | Buy, m | Fabric per piece | Rise | Verdict |
|---|---|---|---|---|---|---|
| Black | 400 | 672 | 672 | 1,092 ₽ | 0 % | the colour pays |
| Beige | 150 | 252 | 300 | 1,196 ₽ | 9.5 % | take it, rise within the allowance |
| Green | 60 | 100.8 | 100.8 | 1,255.8 ₽ | 15 % | merge colours or drop it (short by 119 pcs) |
| Gray | 200 | 336 | 336 | 1,092 ₽ | 0 % | the colour pays |
Needed 1,360.8 m in total, you will have to buy 1,408.8 m. A colour below the minimum: raise the run, merge colours or pay the surcharge; the calculation shows the price of each way. Leftover fabric is money in stock: count it in days of stock.
Nuances and limits
- Counting the minimum per piece rather than per color.
- Forgetting the shrinkage and defect allowance.
- Adding a new color at the last moment.