# Calculate Size Wise Order Quantity in Garments Industry : An Easy 3 Steps

Sharing is caring!

# 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

1. Order quantity of garment.
2. 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

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)

Sharing is caring!

This site uses Akismet to reduce spam. Learn how your comment data is processed.