{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Factory Input Fields","Product Style Costing","LMV Hoisery TN"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Factory Input Fields","index":0,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[40,3,40,9],[42,2,42,3],[48,5,48,9],[49,5,49,9],[50,5,50,9],[52,5,52,9],[60,1,61,1],[60,2,61,3],[60,9,61,9],[43,2,43,3],[51,5,51,9],[4,1,4,9],[7,8,7,9],[8,8,8,9],[26,3,26,9],[11,1,11,2],[17,1,17,2],[21,3,21,9],[22,1,22,2],[24,1,24,2],[25,3,25,9],[10,3,10,9],[23,8,23,9],[18,3,18,9],[13,3,13,6],[19,3,19,9],[27,1,27,2],[20,3,20,9],[14,3,14,9],[15,1,15,2],[44,2,44,3],[33,3,33,9],[28,3,28,9],[35,3,35,9],[29,3,29,9],[30,3,30,9],[31,3,31,9],[32,3,32,9],[34,1,34,2],[37,3,37,9],[36,3,36,9],[39,3,39,9],[63,2,63,3],[53,5,53,9],[55,3,55,9],[56,3,56,9],[58,1,58,9],[62,2,62,3]]}
[null,"Factory Labour Minute and Product Costing Calculator, Hoisery, Tamil Nadu, India"]
[null,"Instructions and input fields, calculation and comparison of labour minute values"]
[null,"https://api.fairwear.org/wp-content/uploads/2020/06/Guidance-for-Use-of-the-Fair-Wear-Labour-and-Minute-and-Product-Costing-Calculator-Final.pdf"]
[]
[null,"The yellow fields in the file are your input fields, where you should insert the actual information based on your factory"]
[]
[]
[null,null,null,null,null,null,"Factory Name (optional)"]
[null,null,null,null,null,null,"Responsible staff (optional)"]
[null,"Step","Value"]
[null,"1)",70.95,"Insert actual INR-US$ foreign exchange rate or foreign exchange rate you are using for your calculations."]
[null,"workforce"]
[null,"2)",null,"Insert the total number of production workers in the factory."]
[null,"3)",null,"Insert total number of sewing operators working actively in the prod. lines (i.e. # machines in the lines determine capacity minutes), which means:",null,null,null,{"$f":"IFERROR(C14/C13,0)","v":0},"of the workforce."]
[null,null,null,"Distribution of workers per Pay Grade in %\nPlease adjust the percentages to reflect the real situation regarding the distribuion of the workforce by grade level in your factory."]
[null,"Must add up to 100%",null,"Skilled  ","Semi-skilled ","Unskilled"]
[null,null,{"$f":"SUM(D17:J17)","v":1},0.25,0.5,0.25]
[null,"paid leave"]
[null,null,9,"Total number of paid public holiday days per year when the factory is closed and workers are paid. As per law, workers are entitled to 9 festival days."]
[null,"4)",15,"\nInsert the average number of paid earned leave days taken annually per worker. This ranges from 12-15 days earned leave per year. "]
[null,"5)",null,"Insert the average number of paid casual leave days taken annually per worker."]
[null,null,{"$f":"SUM(C19:C21)","v":24},"Total average number of paid leave days taken annually per worker."]
[null,"overtime"]
[null,"6)",null,"Insert the average weekly Overtime Hours of your factory."]
[null,"capacity minutes"]
[null,null,{"$f":"(48+C24)*4.33*60-((C22/12)*8*60)-((C22/12)*(C24/6))*60","v":11510.4},"Total capacity minutes per worker/month, based on regular (48 h/w) and overtime hours (C20) and adjusted for the total average number of paid leave taken annually per worker (C18). "]
[null,null,{"$f":"C14*C26","v":0},"Total number of monthly sewing minutes (number of sewing operators x (48 + weekly OT hours) x 4.33 x 60 MINUS average monthly number of minutes on days not worked (i.e. paid public leave). "]
[null,"paid benefits"]
[null,"7)",null,"Insert the total amount paid by the factory in Gratuity in INR PER YEAR."]
[null,"8)",8.3000000000000004E-2,"Insert the ACTUAL percentage paid by the factory for the year-end bonus (Should not be below 8.3%). "]
[null,"9)",null,"Insert the total amount paid by the factory for Meals/Food in INR PER MONTH."]
[null,"10)",null,"Insert the total amount paid by the factory for Dormitory/Housing in INR PER MONTH."]
[null,"11)",null,"Total amount paid by the factory for Transportation in INR PER MONTH:"]
[null,"12)",null,"Insret the total amount paid by the factory in additional bonuses in INR PER MONTH:"]
[null,"employer on-costs"]
[null,"13)",null,"Insert the total monthly amount paid for compensation in case of accidents in INR PER YEAR."]
[null,"14)",null,"Insert the total amount in maternity benefits paid in INR PER YEAR (if not covered by ESI)."]
[null,"15)",null,"Insert the total amount in severence pay paid in INR PER YEAR."]
[]
[null,"16)",4956,"Legal Minimum Wage 2019 (Unskilled level) for Hoisery in TN. To be updated annually when the minimum wages are adjusted."]
[null,"17)",14670,"Insert the Target Wage (Unskilled level). It is assumed here that semi-skilled and skilled workers would receive the same nominal increase as the unskilled workers. Wage differentation, however, would need to be discussed with worker representation and can be adjusted in the light-coloured cells on the LMV worksheet. Please note that that would remove the formula's."]
[]
[null,"Wage ","Description",null,"Labour Cost  avg. worker","Capacity Minutes","INR Labour Minute Value ","US$ Labour Minute Value ","Difference (absolute)","Increment (in%)"]
[null,{"$f":"C40","v":4956},"Labour Minute Value \n(based on Legal Minimum Wage)",null,{"$f":"'LMV Hoisery TN'!I38","v":7383.7402666666667},{"$f":"C26","v":11510.4},{"$f":"E44/F44","v":0.64148424613103516},{"$f":"'LMV Hoisery TN'!I41","v":9.0413565346164227E-3}]
[null,{"$f":"C41","v":14670},"Labour Minute Value \n(based on Target Wage)",null,{"$f":"'LMV Hoisery TN'!P38","v":19629.208666666666},{"$f":"F44","v":11510.4},{"$f":"E45/F45","v":1.7053454846631451},{"$f":"'LMV Hoisery TN'!P41","v":2.4035877162271246E-2},{"$f":"H45-H44","v":1.4994520627654823E-2},{"$f":"IFERROR((H45-H44)/H44,0)","v":1.658437046503549}]
[]
[null,"Monthly Operational Expenses in the Factory"]
[null,null,"in INR","in USD","per minute ","(operational expenses in USD divided by the total monthly sewing minutes (C15)"]
[null,"19)",null,{"$f":"C49/C11","v":0},{"$f":"IFERROR(D49/C27,0)","v":0},"Insert the total amount paid for Direct Labour (i.e. sewing operators) per month in INR."]
[null,"20)",null,{"$f":"C50/C11","v":0},{"$f":"IFERROR(D50/C27,0)","v":0},"Insert the total amount paid for Indirect Labour (all other labour costs besides sewing, e.g. cutting, QC, maintainance, security, cleaning, office staff etc.) per month in INR."]
[null,null,{"$f":"SUM(C49:C50)","v":0},{"$f":"D50+D49","v":0},{"$f":"IFERROR(D51/C27,0)","v":0},"Total labour costs per month in INR / Labour Minute Costs (calculated by dividing with sewing capacity minutes: C12)"]
[null,"21)",null,{"$f":"C52/C11","v":0},{"$f":"IFERROR(D52/C27,0)","v":0},"Insert the average overhead costs in the factory: rent, fuel, electricity, training, interest payments, depreciation on building, safety measures, etc. per month in INR."]
[null,"22)",null,{"$f":"C53/C11","v":0},{"$f":"IFERROR(D53/C27,0)","v":0},"If appliable, Insert the total additional costs per month for Covid-19 measures (e.g. face masks, desinfectants, temperature scanning, etc).  "]
[null,null,{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},{"$f":"SUM(E51:E53)","v":0},"Total factory expenses per month in INR / working minute costs (which can be compared with the working minute costs based on prevailing (2018) min. wage (Cell I-63) as a plausibility check)."]
[]
[null,null,{"$f":"IFERROR(C49/C51,0)","v":0},"Total percentage paid for Direct Labour, i.e. sewing (based on step 19 above)"]
[null,null,{"$f":"IFERROR(C50/C51,0)","v":0},"Total percentage paid for Indirect Labour, i.e. all other labour costs besides sewing, e.g. cutting, QC, maintainance, security, cleaning, office staff etc. (based on step 20 above)"]
[]
[null,"Once you have inserted all above you should get following information:"]
[]
[null,"Wage grade","Description",null,"Direct Labour (A)","Indirect Labour  (B)","Factory Labour Minute Value (C)","Overhead (D)","Total Working Minute Cost (C+D)","Increment (in%)"]
[null,null,null,null,{"$f":"C56","v":0},{"$f":"C57","v":0},"A+B"]
[null,{"$f":"B44","v":4956},"Factory Labour/Working Minute Value (based on Legal Minimum Wage)",null,{"$f":"H44","v":9.0413565346164227E-3},{"$f":"IFERROR(G63*C57,0)","v":0},{"$f":"IFERROR(E63/C56,0)","v":0},{"$f":"E52+E53","v":0},{"$f":"SUM(G63:H63)","v":0}]
[null,{"$f":"B45","v":14670},"Factory Labour/Working Minute Value \n(based on Target Wage)",null,{"$f":"H45","v":2.4035877162271246E-2},{"$f":"IFERROR(G64*C57,0)","v":0},{"$f":"IFERROR(E64/C56,0)","v":0},{"$f":"E52+E53","v":0},{"$f":"SUM(G64:H64)","v":0},{"$f":"IFERROR((I64-I63)/I63,0)","v":0}]

{"sheet":"Product Style Costing","index":1,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[4,1,4,9],[7,8,7,9],[8,8,8,9],[22,2,22,3],[22,6,22,9],[22,4,22,5],[23,4,23,5],[15,2,15,3],[16,2,16,3],[20,2,20,3],[20,6,20,9],[21,2,21,3],[21,4,21,5],[21,6,21,9],[23,2,23,3],[24,2,24,3],[25,2,25,3],[25,4,25,5],[25,6,25,9],[24,6,24,9],[23,6,23,9],[24,4,24,5],[26,2,26,3],[26,4,26,5],[26,6,26,9],[27,2,27,3],[27,4,27,5],[27,6,27,9],[29,2,29,3],[29,6,32,9],[32,2,32,3],[33,2,33,3],[33,4,33,5],[33,6,33,9],[41,2,41,3],[41,6,41,9],[43,3,43,6],[36,2,36,3],[36,4,36,5],[36,6,36,9],[37,2,37,3],[37,6,37,9],[38,6,38,9],[13,1,14,1],[13,2,14,3],[13,9,14,9],[39,6,39,9],[40,2,40,3],[40,6,40,9],[34,2,34,3],[34,4,34,5],[34,6,34,9],[35,2,35,3],[35,4,35,5],[35,6,35,9],[28,2,28,3],[28,4,28,5],[28,6,28,9],[29,1,33,1],[9,8,9,9],[9,6,9,7],[8,6,8,7],[7,6,7,7],[11,1,11,9]]}
[null,"Product Style Costing Calculator, Tailoring, Tamil Nadu, India"]
[null,"Instructions and input fields, calculation and comparison of labour minute values"]
[null,"https://api.fairwear.org/wp-content/uploads/2020/06/Guidance-for-Use-of-the-Fair-Wear-Labour-and-Minute-and-Product-Costing-Calculator-Final.pdf"]
[]
[null,"The yellow fields in the file are your input fields, where you should insert the actual information based on your factory"]
[]
[]
[null,null,null,null,null,null,"Brand Name (optional)"]
[null,null,null,null,null,null,"Factory Name (optional)"]
[null,null,null,null,null,null,"Responsible staff (optional)"]
[]
[null,"From the Worksheet \"Factory Input Fields', you should get following information:"]
[]
[null,"Wage grade","Description",null,"Direct Labour (A)","Indirect Labour  (B)","Factory Labour Minute Value (C)","Overhead (D)","Total Working Minute Cost (C+D)","Increment (in%)"]
[null,null,null,null,{"$f":"'Factory Input Fields'!E62","v":0},{"$f":"'Factory Input Fields'!F62","v":0},"A+B"]
[null,{"$f":"'Factory Input Fields'!B63","v":4956},"Factory Labour/Working Minute Value (based on Legal Minimum Wage)",null,{"$f":"'Factory Input Fields'!E63","v":9.0413565346164227E-3},{"$f":"'Factory Input Fields'!F63","v":0},{"$f":"'Factory Input Fields'!G63","v":0},{"$f":"'Factory Input Fields'!H63","v":0},{"$f":"SUM(G16:H16)","v":0}]
[null,{"$f":"'Factory Input Fields'!B64","v":14670},"Factory Labour/Working Minute Value \n(based on Target Wage)",null,{"$f":"'Factory Input Fields'!E64","v":2.4035877162271246E-2},{"$f":"'Factory Input Fields'!F64","v":0},{"$f":"'Factory Input Fields'!G64","v":0},{"$f":"'Factory Input Fields'!H64","v":0},{"$f":"SUM(G17:H17)","v":0},{"$f":"IFERROR((I17-I16)/I16,0)","v":0}]
[]
[null,"Calculating the cost for a product style"]
[]
[null,null,"Items provided by the factory",null,"Details / Calculations",null,"Notes"]
[null,"1)","Style Name",null,null,null,"Style name or number of the Product"]
[null,"2)","Standard Allowed Minutes",null,null,null,"Standard Allowed Minutes (sewing) of the style you want to calculate per piece. "]
[null,"3)","Efficiency Percentage",null,null,null,"Factory or line efficiency value. Note: One could also adjust this % to calculate the impact of Covid-19 on labour (and product) costs due to possible efficiency loss. "]
[null,null,"Actual number of sewing minutes for style",null,{"$f":"IFERROR(E23/E24,0)","v":0},null,"Note: if you don't know the SAM and efficiency percentage, simply indicate the actual labour minutes under 2, and 100% efficiency under 3."]
[null,"4)","Fabric",null,null,null,"Fabric costs per piece (incl. wastage %) in USD"]
[null,"5)","Accessories",null,null,null,"Costs for accessories (buttons, zippers, etc) per piece in USD"]
[null,"6)","Polybag, packaging, labelling",null,null,null,"Total amount per piece for polybag, packaging, hangtag"]
[null,null,"Total Material Costs",null,{"$f":"SUM(E26:G28)","v":0}]
[null,"Total CM Costs","Labour Cost",null,"at LMW","at Target Wage","Factory labour minute value x SAM / efficiency %"]
[null,null,"Direct",{"$f":"'Factory Input Fields'!$E$62","v":0},{"$f":"E25*'Factory Input Fields'!$E$63","v":0},{"$f":"E25*'Factory Input Fields'!$E$64","v":0}]
[null,null,"Indirect",{"$f":"'Factory Input Fields'!$F$62","v":0},{"$f":"E25*'Factory Input Fields'!$F$63","v":0},{"$f":"E25*'Factory Input Fields'!$F$64","v":0}]
[null,null,"Total labour cost",null,{"$f":"SUM(E31:E32)","v":0},{"$f":"SUM(F31:F32)","v":0}]
[null,null,"Overhead Cost (electricity, fuel ..)",null,{"$f":"IFERROR((E25)*'Factory Input Fields'!$H$63,0)","v":0},null,"Overhead costs per minute (H16) x minutes spent on style (step 2-3)."]
[null,"7)","Outsourced processes",null,null,null,"If applicable, amount for outsourced processes (e.g. embroidery, washing, printing) per piece in USD"]
[null,"8)","Logistic costs (inbound-outbound) ",null,null,null,"Freight cost to bring material to factory and finished goods to buyer (depending on INCOTERMS agreed) per piece in USD"]
[null,"9)","Import tax and duties",null,null,null,"Cost for import tax and duties calculated per piece in USD"]
[null,null,"Total",null,{"$f":"E29+E33+E35+E36+E34+E37","v":0},{"$f":"E29+F33+E35+E36+E34+E37","v":0}]
[null,"10)","Profit Margin",null,{"$f":"D39*E38","v":0},{"$f":"D39*F38","v":0},"Insert your profit margin."]
[null,"11)","Buying House Commission",null,{"$f":"D40*E38","v":0},{"$f":"D40*F38","v":0},"If applicable, insert the buying houses commission %"]
[null,null,"FOB PRICE",null,{"$f":"SUM(E38:E40)","v":0},{"$f":"SUM(F38:F40)","v":0}]
[null,null,"% increase",null,null,{"$f":"IFERROR((F41-E41)/E41,0)","v":0}]
[]
[null,"12)",null,"CHECK: insert the FOB price you receive from the buyer (in USD).",null,null,null,null,"Date:"]
[null,"13)",1000,"Insert order size",{"$f":"C45*E41","v":0},{"$f":"C45*F41","v":0},"Order Value"]

{"sheet":"LMV Hoisery TN","index":2,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[[34,15,34,16],[34,18,34,27],[35,1,35,2],[35,4,35,5],[35,6,35,7],[35,8,35,9],[35,11,35,12],[35,13,35,14],[35,15,35,16],[35,19,35,27],[34,1,34,2],[34,4,34,5],[34,6,34,7],[34,8,34,9],[34,11,34,12],[34,13,34,14],[32,15,32,16],[32,18,32,27],[33,1,33,2],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,11,33,12],[33,13,33,14],[33,15,33,16],[33,18,33,27],[32,1,32,2],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,11,32,12],[32,13,32,14],[30,1,30,2],[30,18,30,27],[31,1,31,2],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,11,31,12],[31,13,31,14],[31,15,31,16],[31,18,31,27],[29,1,29,2],[29,18,29,27],[20,18,20,27],[23,18,23,26],[16,18,16,26],[17,18,17,26],[18,18,18,26],[25,18,25,27],[19,18,19,26],[28,1,28,2],[28,18,28,27],[15,18,15,26],[14,1,20,1],[21,1,27,1],[13,18,13,27],[8,1,9,2],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,11,8,12],[8,13,8,14],[21,18,21,27],[14,18,14,26],[22,18,22,26],[26,18,26,27],[27,18,27,27],[24,18,24,26],[39,4,39,7],[40,4,40,7],[38,4,38,7],[37,4,37,7],[4,23,4,25],[5,1,5,2],[5,4,5,5],[5,6,5,9],[5,11,5,12],[5,13,5,16],[5,19,5,21],[5,23,5,25],[4,1,4,2],[4,4,4,5],[4,6,4,9],[4,11,4,12],[4,13,4,16],[4,19,4,21],[8,15,8,16],[8,18,9,27],[10,1,13,1],[10,18,10,27],[11,18,11,27],[12,18,12,27],[40,15,40,16],[39,15,39,16],[38,15,38,16],[37,15,37,16],[40,11,40,14],[39,11,39,14],[38,11,38,14],[37,11,37,14],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,8,40,9]]}
[]
[null,"Factory Labour Minute Calculator, Hoisery, Tamil Nadu, India"]
[]
[]
[null,"Exchange rate INR - US$ \n (change to actual) ",null,null,"Legal Minimum Wage (Unskilled)",null,"Note",null,null,null,null,"Target Wage (Unskilled)",null,"Note",null,null,null,null,null,"Average OT Hours per week",null,null,null,"Total number of workers "]
[null,{"$f":"'Factory Input Fields'!C11","v":70.95},null,null,{"$f":"'Factory Input Fields'!C40","v":4956},null,"To be updated annually when the minimum wages are adjusted.",null,null,null,null,{"$f":"'Factory Input Fields'!C41","v":14670},null,"Appropriate wage differentation would need to be discussed with worker representation and could be adjusted in the light-coloured cells.",null,null,null,null,null,{"$f":"'Factory Input Fields'!C24","v":0},null,null,null,{"$f":"'Factory Input Fields'!C13","v":0}]
[]
[]
[null,"Wage Item",null,null,"Skilled  \"LMW\"",null,"Semi-skilled \"LMW\"",null,"Unskilled \"LMW\"",null,null,"Skilled  \"LW\"",null,"Semi-skilled \"LW\"",null,"Unskilled  \"LW\"",null,null,"Explanatory Notes"]
[null,null,null,null,"Regular working hours (48h)","Overtime hours ","Regular working hours (48h)","Overtime hours ","Regular working hours (48h)","Overtime hours ",null,"Regular working hours (48h)","Overtime hours ","Regular working hours (48h)","Overtime hours","Regular working hours (48h)","Overtime hours"]
[null,"1. Legal Minimum Wage\n\n(Pay for time worked)","Basic Wage",null,4248,null,2448,null,{"$f":"E6-I12","v":1848},null,null,{"$f":"E11+(P11-I11)","v":13962},null,{"$f":"G11+(P11-I11)","v":12162},null,{"$f":"L6-P12","v":11562},null,null,"6 days a week, 8h/day; 48h/week  x 4,33 = 208 h/month"]
[null,null,"Dearness Allowance",null,3108,null,3108,null,3108,null,null,3108,null,3108,null,3108,null,null,"Dearness Allowance (to be adjusted annually)."]
[null,null,"OT Wage",null,null,{"$f":"(E11+E12)/208*($T$6*4.33)*2","v":0},null,{"$f":"(G11+G12)/208*($T$6*4.33)*2","v":0},null,{"$f":"(I11+I12)/208*($T$6*4.33)*2","v":0},null,null,{"$f":"L14/208*($T$6*4.33)*2","v":0},null,{"$f":"N14/208*($T$6*4.33)*2","v":0},null,{"$f":"P14/208*($T$6*4.33)*2","v":0},null,"Paid at 200%. Total OT per month is weekly OT hours x 4.33"]
[null,null,"SubTOTAL 1",null,{"$f":"SUM(E11:E13)","v":7356},{"$f":"SUM(F11:F13)","v":0},{"$f":"SUM(G11:G13)","v":5556},{"$f":"SUM(H11:H13)","v":0},4956,{"$f":"SUM(J11:J13)","v":0},null,{"$f":"SUM(L11:L13)","v":17070},{"$f":"SUM(M11:M13)","v":0},15270,{"$f":"SUM(O11:O13)","v":0},14670,{"$f":"SUM(Q11:Q13)","v":0}]
[null,"2. Directly \nPaid\nBenefits","Gratuity ",null,{"$f":"IFERROR(AB15/X6/12,0)","v":0},null,{"$f":"IFERROR(AB15/X6/12,0)","v":0},null,{"$f":"IFERROR(AB15/X6/12,0)","v":0},null,null,{"$f":"IFERROR(AB15/X6/12,0)","v":0},null,{"$f":"IFERROR(AB15/X6/12,0)","v":0},null,{"$f":"IFERROR(AB15/X6/12,0)","v":0},null,null,"Total amount paid by the factory in Gratuity in INR PER YEAR:",null,null,null,null,null,null,null,null,{"$f":"'Factory Input Fields'!C29","v":0}]
[null,null,"Year end Bonus",null,{"$f":"($AB$16*(12*E14))/12","v":610.548},null,{"$f":"($AB$16*(12*G14))/12","v":461.14799999999997},null,{"$f":"($AB$16*(12*I14))/12","v":411.34800000000001},null,{"$f":"($AB$16*(12*K14))/12","v":0},{"$f":"($AB$16*(12*L14))/12","v":1416.8100000000002},null,{"$f":"($AB$16*(12*N14))/12","v":1267.4100000000001},null,{"$f":"($AB$16*(12*P14))/12","v":1217.6100000000001},null,null,"ACTUAL percentage paid by the factory for the year-end bonus (Should not be below 8.3%). ",null,null,null,null,null,null,null,null,{"$f":"'Factory Input Fields'!C30","v":8.3000000000000004E-2}]
[null,null,"Meal/Food",null,{"$f":"IFERROR($AB$17/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$17/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$17/$X$6,0)","v":0},null,null,{"$f":"IFERROR($AB$17/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$17/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$17/$X$6,0)","v":0},null,null,"Total amount paid by the factory for Meals/Food in INR PER MONTH:",null,null,null,null,null,null,null,null,{"$f":"'Factory Input Fields'!C31","v":0}]
[null,null,"Dormitory/Housing",null,{"$f":"IFERROR($AB$18/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$18/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$18/$X$6,0)","v":0},null,null,{"$f":"IFERROR($AB$18/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$18/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$18/$X$6,0)","v":0},null,null,"Total amount paid by the factory for Dormitory/Housing in INR PER MONTH:\n",null,null,null,null,null,null,null,null,{"$f":"'Factory Input Fields'!C32","v":0}]
[null,null,"Transportation",null,{"$f":"IFERROR($AB$19/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$19/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$19/$X$6,0)","v":0},null,null,{"$f":"IFERROR($AB$19/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$19/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$19/$X$6,0)","v":0},null,null,"Total amount paid by the factory for Transportation in INR PER MONTH:",null,null,null,null,null,null,null,null,{"$f":"'Factory Input Fields'!C33","v":0}]
[null,null,"Any additional bonuses",null,{"$f":"IFERROR($AB$20/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$20/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$20/$X$6,0)","v":0},null,null,{"$f":"IFERROR($AB$20/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$20/$X$6,0)","v":0},null,{"$f":"IFERROR($AB$20/$X$6,0)","v":0},null,null,"Total amount paid by the factory in additional bonuses in INR PER MONTH:",null,null,null,null,null,null,null,null,{"$f":"'Factory Input Fields'!C34","v":0}]
[null,null,"SubTOTAL 2",null,{"$f":"SUM(E15:E19)","v":610.548},0,461.14799999999997,0,411.34800000000001,0,0,1416.8100000000002,0,1267.4100000000001,0,1217.6100000000001,0]
[null,"3. Employer \nlabour\nrelated\non-cost","Labour Wellfare Fund",null,{"$f":"20/12","v":1.6666666666666667},null,{"$f":"20/12","v":1.6666666666666667},null,{"$f":"20/12","v":1.6666666666666667},null,null,{"$f":"20/12","v":1.6666666666666667},null,{"$f":"20/12","v":1.6666666666666667},null,{"$f":"20/12","v":1.6666666666666667},null,null,"20 Rupees per worker per year"]
[null,null,"Compensation related to accidents",null,{"$f":"IFERROR(AB23/X6/12,0)","v":0},null,{"$f":"IFERROR(AB23/X6/12,0)","v":0},null,{"$f":"IFERROR(AB23/X6/12,0)","v":0},null,null,{"$f":"IFERROR(AB23/X6/12,0)","v":0},null,{"$f":"IFERROR(AB23/X6/12,0)","v":0},null,{"$f":"IFERROR(AB23/X6/12,0)","v":0},null,null,"Total monthly amount paid for compensation in case of accidents in INR PER YEAR:",null,null,null,null,null,null,null,null,{"$f":"'Factory Input Fields'!C36","v":0}]
[null,null,"Maternity leave / benefit",null,{"$f":"IFERROR($AB$24/$X$6/12,0)","v":0},null,{"$f":"IFERROR($AB$24/$X$6/12,0)","v":0},null,{"$f":"IFERROR($AB$24/$X$6/12,0)","v":0},null,null,{"$f":"IFERROR($AB$24/$X$6/12,0)","v":0},null,{"$f":"IFERROR($AB$24/$X$6/12,0)","v":0},null,{"$f":"IFERROR($AB$24/$X$6/12,0)","v":0},null,null,"Total amount in maternity benefits paid in INR PER YEAR (if not covered by ESI):",null,null,null,null,null,null,null,null,{"$f":"'Factory Input Fields'!C37","v":0}]
[null,null,"Severence Pay",null,{"$f":"IFERROR($AB$25/$X$6/12,0)","v":0},null,{"$f":"IFERROR($AB$25/$X$6/12,0)","v":0},null,{"$f":"IFERROR($AB$25/$X$6/12,0)","v":0},null,null,{"$f":"IFERROR($AB$25/$X$6/12,0)","v":0},null,{"$f":"IFERROR($AB$25/$X$6/12,0)","v":0},null,{"$f":"IFERROR($AB$25/$X$6/12,0)","v":0},null,null,"Total amount in severence pay paid in INR PER YEAR.",null,null,null,null,null,null,null,null,{"$f":"'Factory Input Fields'!C38","v":0}]
[null,null,"Employees Provident Fund",null,{"$f":"0.1301*E14","v":957.01559999999995},null,{"$f":"0.1301*G14","v":722.8356},null,{"$f":"0.1301*I14","v":644.77559999999994},null,null,{"$f":"0.1301*L14","v":2220.8069999999998},null,{"$f":"0.1301*N14","v":1986.627},null,{"$f":"0.1301*P14","v":1908.567},null,null,"12% + 1.01% admin charges of basic plus DA"]
[null,null,"Employer State Insurance",null,{"$f":"0.0475*E14","v":349.41},0,263.91000000000003,0,235.41,0,null,{"$f":"0.0475*L14","v":810.82500000000005},0,725.32500000000005,0,696.82500000000005,0,null,"4.75% of basic plus DA (paid over regular + OT wages)"]
[null,null,"SubTOTAL 3",null,{"$f":"SUM(E22:E27)","v":1308.0922666666665},0,988.41226666666671,0,881.85226666666654,0,null,{"$f":"SUM(L22:L27)","v":3033.2986666666666},0,2713.6186666666667,0,2607.0586666666668,0]
[null,"TOTAL Labour cost per worker in INR (1+2+3)",null,null,{"$f":"E28+E21+E14","v":9274.6402666666672},0,7005.5602666666664,0,6249.2002666666667,0,null,{"$f":"L28+L21+L14","v":21520.108666666667},0,19251.028666666665,0,18494.668666666668,0]
[null,"Monthly capacity minutes",null,null,{"$f":"48*4.33*60-('Factory Input Fields'!C22/12*8*60)","v":11510.4},{"$f":"$T$6*4.33*60-('Factory Input Fields'!C22/12*'Factory Input Fields'!C24/6)*60","v":0},{"$f":"E30","v":11510.4},{"$f":"F30","v":0},{"$f":"E30","v":11510.4},{"$f":"F30","v":0},null,{"$f":"E30","v":11510.4},{"$f":"F30","v":0},{"$f":"E30","v":11510.4},{"$f":"F30","v":0},{"$f":"E30","v":11510.4},{"$f":"F30","v":0},null,"48 x 4.33 x 60min for regular working hours. \nTotal OT per month is weekly OT hours x 4.33 x 60 minutes."]
[null,"Labour Minute Value INR \n(row 31/32)",null,null,{"$f":"E29/E30","v":0.80576176906681496},{"$f":"IFERROR(F29/F30,0)","v":0},{"$f":"G29/G30","v":0.60862874154387914},{"$f":"IFERROR(H29/H30,0)","v":0},0.54291773236956731,{"$f":"IFERROR(J29/J30,0)","v":0},null,1.8696230075989251,{"$f":"IFERROR(M29/M30,0)","v":0},1.6724899800759891,{"$f":"IFERROR(O29/O30,0)","v":0},1.6067789709016775,{"$f":"IFERROR(Q29/Q30,0)","v":0}]
[null,"Monthly Labour Cost incl. OT in INR (sum row 31)",null,null,{"$f":"E29+F29","v":9274.6402666666672},null,{"$f":"G29+H29","v":7005.5602666666664},null,{"$f":"I29+J29","v":6249.2002666666667},null,null,{"$f":"L29+M29","v":21520.108666666667},null,{"$f":"N29+O29","v":19251.028666666665},null,{"$f":"P29+Q29","v":18494.668666666668}]
[null,"Monthly capacity minutes incl. OT  (sum row 32)",null,null,{"$f":"E30+F30","v":11510.4},null,{"$f":"G30+H30","v":11510.4},null,{"$f":"I30+J30","v":11510.4},null,null,{"$f":"L30+M30","v":11510.4},null,{"$f":"N30+O30","v":11510.4},null,{"$f":"P30+Q30","v":11510.4}]
[null,"Labour minute Value INR incl. OT(row 19/20)",null,null,{"$f":"E32/E33","v":0.80576176906681496},null,{"$f":"G32/G33","v":0.60862874154387914},null,{"$f":"I32/I33","v":0.54291773236956731},null,null,{"$f":"L32/L33","v":1.8696230075989251},null,{"$f":"N32/N33","v":1.6724899800759891},null,{"$f":"P32/P33","v":1.6067789709016775}]
[null,"Labour Minute Value US$ incl. OT ",null,null,{"$f":"E34/$B$6","v":1.1356755025606976E-2},null,{"$f":"G34/$B$6","v":8.5782768364183106E-3},null,{"$f":"I34/$B$6","v":7.6521174400220899E-3},null,null,{"$f":"L34/$B$6","v":2.6351275653261803E-2},null,{"$f":"N34/$B$6","v":2.3572797464073137E-2},null,{"$f":"P34/$B$6","v":2.264663806767692E-2}]
[null,"Distribution per Pay Grade in %",null,null,{"$f":"'Factory Input Fields'!D17","v":0.25},null,{"$f":"'Factory Input Fields'!E17","v":0.5},null,{"$f":"'Factory Input Fields'!F17","v":0.25},null,null,{"$f":"'Factory Input Fields'!D17","v":0.25},null,{"$f":"'Factory Input Fields'!E17","v":0.5},null,{"$f":"'Factory Input Fields'!F17","v":0.25},null,null,{"$f":"SUM(E36:J36)","v":1}," % must add up to 100%"]
[]
[null,null,null,null,"Weighted Labour Cost p/worker \n(based on Legal Minimum Wage)",null,null,null,{"$f":"E32*E36+G32*G36+I32*I36","v":7383.7402666666667},null,null,"Weighted Labour Cost p/worker \n(based on Target Wage)",null,null,null,{"$f":"L32*L36+N32*N36+P32*P36","v":19629.208666666666}]
[null,null,null,null,"Total Capacity Minutes",null,null,null,{"$f":"E33","v":11510.4},null,null,"Total Capacity Minutes",null,null,null,{"$f":"L33","v":11510.4}]
[null,null,null,null,"Weighted Labour Minute Value INR \n(based on Legal Minimum Wage)",null,null,null,{"$f":"I38/I39","v":0.64148424613103516},null,null,"Weighted Labour Minute Value INR \n(based on Target Wage)",null,null,null,{"$f":"P38/P39","v":1.7053454846631451}]
[null,null,null,null,"Weighted Labour Minute Value US$ \n(based on Legal Minimum Wage)",null,null,null,{"$f":"I40/B6","v":9.0413565346164227E-3},null,null,"Weighted Labour Minute Value US$ \n(based on Target Wage)",null,null,null,{"$f":"P40/B6","v":2.4035877162271246E-2}]