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]

## You may also like

Name

5S,3,Apparel ERP,1,apparel industry,56,apparel news,33,Apparel Production,30,Apparel Software,16,Bamboo Fabric,1,Bangladesh,1,Blogs,1,Books,30,Business Guides,9,Buyer,1,Buying House,4,CAD/CAM,1,Calculation & Formula,1,career,33,Change Management,1,Clothing,1,Clothing Brand,3,Compliance,3,Consumption,4,Costing,7,Cutting,17,Denim,3,Directory,3,Dyeing,1,eCommerce,2,Education,5,Event & Fair,14,Fabric,71,Fashion,5,Fashion Business,37,Fashion Design,3,Fashion Show,1,Fiber,1,Finishing,10,Garment Exporters,1,Garmenting,1,Gartex,1,GSM,1,Guest Post,8,Human Resource,2,Industrial Engineering,208,Infographic,5,Knitting,3,Kurti,1,Lean,27,Line layout,3,Machines,28,Manufacturing,51,Merchandising,101,MIS,23,MISC,20,Operation bulletin,14,Operator,1,Performance rating,1,PLM,3,Printing & Embroidery,11,Problem Solving,1,Production Planning,26,Project Report,1,QNA,120,Quality,61,Quality manual,2,Quality system,14,Resources,42,Retailing,4,Salary & Wages,7,Sampling,22,Scheduling,3,Sourcing,8,Spec Sheet,9,Sportswear,1,Stitching,3,Store,2,Stretch fabric,1,sustainable clothing,7,T-shirt,3,Tailor,1,Tailoring Shop,2,Technology,57,Texprocess,1,Textile processing,11,Textile testing,22,Textiles,41,Threads,1,Towel,1,Trims & Accessories,15,videos,11,Waste,1,Work Study,38,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
http://www.onlineclothingstudy.com/2013/05/how-to-calculate-size-wise-cut-quantity.html
http://www.onlineclothingstudy.com/
http://www.onlineclothingstudy.com/
http://www.onlineclothingstudy.com/2013/05/how-to-calculate-size-wise-cut-quantity.html
true
6551124471002606808
UTF-8