Calculate Size Wise Cut
How to Calculate Size Wise Cut Quantity from the Size Ratio in an Order
Question:How to calculate size wise cutting quantity for 10000 pieces? For example, suppose we have received a production order of 10000 pieces and the order size ratio is S:M:L:XL = 1:2:2:1. Please help me with the formula.
Mostly when apparel buyers place an order with suppliers, they provide total order quantity and what sizes to be made and in which ratio garments to be made for different sizes. Later when cut order plan is made size wise quantity is calculated.
Mathematical calculation is used to convert ratios into quantity. You can use following steps to find size wise quantity.
Step#1. Calculate sum of all ratios. Here size ratio (1:2:2:1), 1+2+2+1 =6
Step#2. Divide total order quantity by sum of ratio (here 6)
Step#3. Multiply the result by ratio of a particular size
If we consider above data for example, size wise cutting quantity will be
Quantity in S = (10000 /6) *1 = 1666.66 = 1667
Quantity in M = (10000 /6) *2 = 3333.33 = 3333
Quantity in L = (10000 /6) *2 = 3333.33 = 3333
Quantity in XL = (10000 /6) *1 = 1666.66 = 1667
So we can write the formula as following
Quantity of a size = (order quantity X ratio of the particular size)/ (Sum of ratio of all sizes)
The above calculation can be made easily by using excel sheet. You can create a table with formula. Later when you get order and size ratios, enter those on the specific cells; you will get actual cut quantity. For reference I have shown you a simple cut order plan (for single color) in the following table.
If we consider above data for example, size wise cutting quantity will be
Quantity in S = (10000 /6) *1 = 1666.66 = 1667
Quantity in M = (10000 /6) *2 = 3333.33 = 3333
Quantity in L = (10000 /6) *2 = 3333.33 = 3333
Quantity in XL = (10000 /6) *1 = 1666.66 = 1667
So we can write the formula as following
Quantity of a size = (order quantity X ratio of the particular size)/ (Sum of ratio of all sizes)
The above calculation can be made easily by using excel sheet. You can create a table with formula. Later when you get order and size ratios, enter those on the specific cells; you will get actual cut quantity. For reference I have shown you a simple cut order plan (for single color) in the following table.
 |
| Cut order plan sheet for single color |