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 

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.



5S,3,Activewear,1,Apparel ERP,2,apparel industry,63,apparel news,34,Apparel Production,32,Apparel Software,20,Bamboo Fabric,1,Bangladesh,3,Blogs,1,Books,34,Business Guides,9,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,4,Directory,3,Dyeing,1,eCommerce,2,Education,5,Event & Fair,16,Fabric,75,Fashion,5,Fashion Business,44,Fashion Design,3,Fashion Show,2,Fiber,3,Finishing,10,Garment Exporters,1,Garmenting,2,Gartex,1,GSM,1,Guest Post,7,Human Resource,5,Industrial Engineering,226,Infographic,5,Knitting,4,KPI,8,Kurti,1,Lean,27,Leggings,2,Line Balancing,3,Line layout,4,Living Wages,1,Machines,36,Manufacturing,55,Merchandising,114,MIS,25,MISC,25,Operation bulletin,14,Operator,2,Operator Training,1,Performance rating,1,PLM,5,Printing & Embroidery,13,Problem Solving,1,Production Planning,27,Productivity,1,Project Report,1,QNA,124,Quality,64,Quality manual,2,Quality system,14,Research project,1,Resources,44,Retailing,5,RMG,1,Salary & Wages,7,Sampling,23,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,66,Texprocess,1,Textile processing,11,Textile testing,22,Textiles,42,Threads,1,Towel,1,Trims & Accessories,17,videos,12,Waste,1,Work Study,40,Work wear,1,Yoga wear,1,
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
Online Clothing Study
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