How to Calculate Size Wise Cut Quantity from the Size Ratio in an Order

[post_ads_2]
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. ... asked by Mala SN 

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.

Cut order plan sheet for single color

You can download above cut order plan (in excel format) just by sharing on Google+ or Twitter or liking our Facebook page. Just click on one of the following buttons.

In case you find problem with downloading the excel format, please write me.
[post_ads]