Introduction:

In the garments industry, while receiving the order, the merchandiser sometimes gets the exact details of color wise order quantity and size wise order quantity. But most of the time, merchandisers received only

Order quantity of garment.
Size wise and color wise ratio or percentage of garment.

So, a merchandiser needs to know how to calculate size wise order quantity and color wise order quantity in the garments industry. In this article, I will describe the calculation method for quantity breakup, i.e. how to calculate size wise order quantity and color wise order quantity in the garments industry.

Calculate size wise order quantity and color wise order quantity:

Step 1: At first, calculate the sum of all ratios (it may be size or color).
Step 2: Now, divide the total order quantity by the summation value (ratio sum).
Step 3: Multiply the result by the ratio of a particular size or color; this will give the exact quantity of that particular size of order quantity or color of order quantity (either size or color).
N.B.: Don’t forget to add the wastage percentage with the order quantity (based on experience/company’s previous records).

Example: Calculate size wise order quantity and color wise order quantity

Example 1: calculate size wise order quantity for the order with 12,000 pcs order quantity and the size ratio is S:M:L:XL= 1:2:2:1

Solution:

Step-1: sum of all ratios of size= 1+2+2+1=6
Step 2: Order quantity/sum of ratios= 12,000/6
Step 3: Multiply the result of step 3 by particular size ratio.
- For size S= 12,000/6 × 1= 2,000 pcs garments
- For size M= 12,000/6 × 2= 4,000 pcs garments
- For size L= 12,000/6 × 2= 4,000 pcs garments
- For size XL= 12,000/6 × 1= 2,000 pcs garments
N.B: No wastage percentage is provided .so that, this step can be ignored.

Example 2: Calculate color wise order quantity for the following order in details. Order quantity with four colour is 1,78,500 pcs, size breakup ratio for each colour is 1:2:1:2:1 and the colour are blue, red, olive green and, yellow.

Solution:

Here,

Order quantity with four colour= 1,78,500 pcs

Size breakup ratio= 1:2:1:2:1=7

Color wise order quantity
- For blue color= 1,78,500/4= 44,625 pcs
- For red color= 1,78,500/4= 44,625 pcs
- For olive green color= 1,78,500/4= 44,625 pcs
- For yellow color= 1,78,500/4= 44,625 pcs
Since, all the colours having same quantity, the size wise breakup for the colors are same as follows.
- Sum of all ratios =1+2+1+2+1=7
- Size 1 (XS): (1/7)×44, 625= 6,375 pcs
- Size 2 (S): (2/7)×44,625= 12,750 pcs
- Size 3 (M) : (1/7)×44, 625= 6,375 pcs
- Size 4 (L): (2/7)×44,625= 12,750 pcs
- Size 5 (XL): (1/7)×44, 625= 6,375 pcs
Summary of size wise order quantity breakup and color wise order quantity breakup

Colour	XS	S	M	L	XL	Total colour wise quantity
Blue	6,375	12,750	6,375	12,750	6,375	44,625
Red	6,375	12,750	6,375	12,750	6,375	44,625
Olive green	6,375	12,750	6,375	12,750	6,375	44,625
yellow	6,375	12,750	6,375	12,750	6,375	44,625
Total order quantity						1,78,500

Table 1: Size wise order quantity and color wise order quantity

Example 3: An apparel export garments industry produces 100% cotton men’s T-shirts with an order quantity of 20,000 garments in a total of six colors. The size breakup for each color is 1:2:2:1= S:M:L:XL. The color wise order quantities are: sea green- 2000 pcs, green-1000 pcs, blue-3000 pcs, yellow-2000pcs, Navy blue- 8000 pcs, and white-4000 pcs. Calculate the colour wise breakup quantity of garments, and size wise breakup quantity of garments with 5% wastage.

Solution:

Here,

Order quantity= 20,000 pcs

Size breakup for each colour= 1:2:2:1= S:M:L:XL= 6

Wastage percentage=10%

For sea green colour
- Size S: (1/6)×2000= 333.33× 1.05 (wastage)=349.99350 pcs
- Size M : (2/6)×2000= 666.66× 1.05 (wastage)=699.99700 pcs
- Size L : (2/6)×2000= 666.66× 1.05 (wastage)=699.99700 pcs
- Size XL: (1/6)×2000= 333.33× 1.05 (wastage)=349.99350 pcs
For green colour
- Size S: (1/6)×1000= 166.66× 1.05 (wastage)=174.99175 pcs
- Size M : (2/6)×1000= 333.32× 1.05 (wastage)=349.98350 pcs
- Size L : (2/6)×1000= 333.32× 1.05 (wastage)=349.98350 pcs
- Size XL: (1/6)×1000= 166.66× 1.05 (wastage)=174.99175 pcs
For blue colour
- Size S: (1/6)×3000= 500× 1.05 (wastage)=525 pcs
- Size M : (2/6)×3000= 1000× 1.05 (wastage)=1,050 pcs
- Size L : (2/6)×3000= 1000× 1.05 (wastage)=1,050 pcs
- Size XL: (1/6)×3000= 500× 1.05 (wastage)=525 pcs
For yellow colour
- Size S: (1/6)×2000= 333.33× 1.05 (wastage)=349.99350 pcs
- Size M : (2/6)×2000= 666.66× 1.05 (wastage)=699.99700 pcs
- Size L : (2/6)×2000= 666.66× 1.05 (wastage)=699.99700 pcs
- Size XL: (1/6)×2000= 333.33× 1.05 (wastage)=349.99350 pcs
For Navy blue colour
- Size S: (1/6)×8000= 1,333.33× 1.05 (wastage)=1399.651,400 pcs
- Size M : (2/6)×8000= 2,666.66× 1.05 (wastage)=2799.992,800 pcs
- Size L : (2/6)×8000= 2,666.66× 1.05 (wastage)=2799.992,800 pcs
- Size XL: (1/6)×8000= 1,333.33× 1.05 (wastage)=1399.651,400 pcs
For white colour
- Size S: (1/6)×4000= 666.66× 1.05 (wastage)=699.99700 pcs
- Size M : (2/6)×4000= 1,333.32× 1.05 (wastage)=1399.981,400 pcs
- Size L : (2/6)×4000= 1,333.32× 1.05 (wastage)=1399.981,400 pcs
- Size XL: (1/6)×4000= 666.66× 1.05 (wastage)=699.99700 pcs
Total quantity details are provided ( Size wise order quantity and color wise color quantity)

Colour	S	M	L	XL	Total colour wise quantity (with 5% wastage)
Sea green color	350	700	700	350	2,000( 2,100)
Green	175	350	350	175	1,000 (1,050)
Blue	525	1,050	1,050	525	3,000 (3,150)
Yellow	350	700	700	350	2,000( 2,100)
Navy blue	1,400	2,800	2,800	1,400	8,000 (8,400)
White	700	1,400	1,400	700	4,000 (4,200)
Total order quantity					20,000(21,000)