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
In bulk apparel production, garment manufacturers get an order in volume for a style. In such bulk orders, garment supplier needs to garment for multiple sizes. Like, the same design is made for size small, size medium and size Large.

The buyer PO contains total order quantity and size wise order quantity. Sometimes buyers do not provide the size wise quantity breakup. Instead, they provide the following details.
• total order quantity,
• list of sizes garment to made and
• size wise quantity ratio of garments
From the ratio, you need to calculate size wise quantity. A mathematical calculation is used to convert ratios into quantity.  At the time of cut order plan, size wise quantity is calculated by the garment manufacturers.

You can use the following steps to find size wise quantity.

Step#1. Calculate the 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 the ratio (here 6)

Step#3. Multiply the result by the ratio of a particular size

The following formula is used for conversion from ratio to quantity.
Quantity of a size = (order quantity X ratio of the particular size)/ (Sum of ratio of all sizes)
Let's consider the above data for an 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

The above calculation can be made easily by using an excel sheet. You can create a table with formula. Later when you get an order and size ratio, enter those on the specific cells; you will get actual cut quantity. For your reference, I have shown you a simple cut order plan (for a single color order) in the following table.

 Cut order plan sheet for single color

If you find it difficult to calculate size wise cut quantity from the total order quantity using the given size ratio. Use my template.

### How to use this template?

• Enter your style number, order quantity, and the size ratio in the colored cells.
• If you like to add extra cutting to cover the defective garment and size mismatch in packing, add how extra quantity requirement in percentage. Like 3% or 5% or 7%.
• Once the entry is done in the colored cells, your size wise quantity breakup is ready.

Name

5S,3,Activewear,1,Apparel ERP,3,apparel industry,62,apparel news,34,Apparel Production,33,Apparel Software,22,AQL Chart,1,Bamboo Fabric,1,Bangladesh,3,Blogs,1,Books,34,Business Guides,11,Buyer,4,Buying House,4,CAD/CAM,1,Calculation & Formula,1,career,35,Change Management,1,Clothing,3,Clothing Brand,4,Compliance,3,Consumption,4,Costing,15,Cutting,23,Data Analysis,1,Defects,1,Denim,5,Directory,3,Dyeing,1,eCommerce,2,Education,5,Event & Fair,17,Fabric,81,Fashion,5,Fashion Business,47,Fashion Design,4,Fashion Show,2,Fiber,3,Finishing,10,Fusing,1,Garment Exporters,1,Garmenting,2,Gartex,1,GSM,3,Guest Post,7,Human Resource,5,Industrial Engineering,229,Industry Updates,1,Infographic,5,Interlining,2,Knitting,4,KPI,8,Kurti,1,Lean,27,Leggings,2,Line Balancing,3,Line layout,4,Living Wages,1,Machines,38,Manufacturing,55,Merchandising,117,MIS,25,MISC,25,News,7,Operation bulletin,14,Operator,2,Operator Training,1,Performance rating,1,PLM,6,Printing & Embroidery,13,Printing Machines,1,Problem Solving,1,Production Planning,27,Productivity,1,Project Report,1,QNA,126,Quality,65,Quality manual,2,Quality system,14,Research project,1,Resources,46,Retailing,5,RMG,1,Salary & Wages,7,Sampling,26,Scheduling,5,Shirt Making,2,Sourcing,9,Spec Sheet,10,Sportswear,5,Spreading,1,Stitching,4,Store,2,Stretch fabric,1,Student corner,1,sustainable clothing,7,T-shirt,4,Tailor,1,Tailoring Shop,2,Technology,73,Texprocess,1,Textile processing,11,Textile testing,23,Textiles,41,Threads,1,Towel,1,Trims & Accessories,19,videos,12,Waste,1,Work Study,41,Work wear,1,Yoga wear,1,
ltr
item
Online Clothing Study: How to Calculate Size Wise Cut Quantity from the Size Ratio in an Order
How to Calculate Size Wise Cut Quantity from the Size Ratio in an Order
Calculate Size Wise Cut Quantity from the Size Ratio in an Order
https://3.bp.blogspot.com/-KytEOewtS-0/UZRbQVo2FqI/AAAAAAAAA2U/z-sy4KWkLQo/s1600/cut+order+plan+single+color.png
https://3.bp.blogspot.com/-KytEOewtS-0/UZRbQVo2FqI/AAAAAAAAA2U/z-sy4KWkLQo/s72-c/cut+order+plan+single+color.png
Online Clothing Study
https://www.onlineclothingstudy.com/2013/05/how-to-calculate-size-wise-cut-quantity.html
https://www.onlineclothingstudy.com/
https://www.onlineclothingstudy.com/
https://www.onlineclothingstudy.com/2013/05/how-to-calculate-size-wise-cut-quantity.html
true
6551124471002606808
UTF-8