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

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?


  • Download this template and save the excel file in your computer. 
  • 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.

In case you find a problem with downloading the excel format, please write me.

COMMENTS

Name

5S,3,Activewear,1,Apparel ERP,3,apparel industry,62,apparel news,36,Apparel Production,34,Apparel Software,29,AQL Chart,1,Bamboo Fabric,1,Bangladesh,3,Blogs,1,Body Scanner,1,Books,34,Business Guides,13,Buyer,4,Buying House,4,CAD/CAM,2,Calculation & Formula,1,career,36,Change Management,1,China,1,Clothing,3,Clothing Brand,4,Compliance,3,Consumption,4,Costing,17,Cutting,23,Data Analysis,1,Defects,1,Denim,9,Directory,3,Drone,1,Dyeing,2,eCommerce,2,Education,5,End use,1,Event & Fair,16,Fabric,83,Fashion,5,Fashion Business,51,Fashion Design,4,Fashion Show,2,Fiber,5,Finishing,12,Fusing,1,Garment Exporters,1,Garment Industry,1,Garmenting,2,Gartex,1,GSM,3,Guest Post,7,Human Resource,6,Industrial Engineering,234,Industry 4,1,Infographic,5,Interlining,2,Jeans,3,Knitting,4,KPI,8,Kurti,1,Laser Technology,1,Lean,27,Leggings,2,Line Balancing,3,Line layout,4,Living Wages,1,Machines,40,Manufacturing,56,Merchandising,118,MIS,25,MISC,24,News,4,Operation bulletin,14,Operator,2,Operator Training,1,Performance rating,1,PLM,6,Printing & Embroidery,13,Problem Solving,1,Production Planning,27,Productivity,2,Project Report,1,QNA,133,Quality,68,Quality Circle,1,Quality manual,2,Quality system,16,Research project,2,Resources,46,Retailing,6,RMG,1,Salary & Wages,7,Sampling,27,Scheduling,5,Seam Sealing,1,Shirt Making,2,Skiiwear,1,Smart Clothing,1,Sourcing,10,Spec Sheet,10,Sportswear,6,Spreading,1,Stitching,4,Store,2,Stretch fabric,1,Student corner,2,sustainable clothing,7,T-shirt,4,Tailor,1,Tailoring Shop,3,Technology,85,Texprocess,1,Textile processing,12,Textile testing,23,Textiles,42,Threads,2,Towel,1,Trims & Accessories,19,videos,12,Washing,2,Waste,1,Wearable Tech,1,Work Study,42,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
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy