{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Factory Input Fields","Product Style Costing","Labour Minute Value China"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,1,1,8],[4,1,4,8],[7,8,7,10],[8,8,8,10],[7,6,7,7],[8,6,8,7],[62,1,62,10],[55,5,55,10],[56,5,56,10],[57,5,57,10],[59,3,59,10],[60,3,60,10],[28,3,28,10],[24,3,24,10],[31,3,31,10],[10,3,10,10],[15,3,15,10],[20,3,20,10],[22,3,22,10],[23,3,23,10],[12,3,12,10],[18,3,18,10],[17,3,17,10],[16,3,16,10],[64,10,65,10],[69,2,69,4],[68,2,68,4],[66,2,66,4],[64,2,65,4],[67,2,67,4],[40,9,40,10],[40,3,40,7],[11,1,11,2],[14,1,14,2],[21,1,21,2],[26,1,26,2],[27,3,27,10],[37,3,37,10],[38,3,38,10],[30,3,30,10],[32,3,32,10],[33,3,33,10],[34,3,34,10],[36,3,36,10],[25,3,25,6],[25,8,25,10],[64,1,65,1],[48,2,48,4],[29,1,29,2],[35,1,35,2],[13,3,13,7],[42,3,42,10],[52,5,52,10],[53,5,53,10],[54,5,54,10],[50,1,50,4],[51,5,51,10],[47,2,47,4],[46,2,46,4],[45,2,45,4],[44,2,44,4],[41,3,41,10]]}
[null,"Factory Labour Minute Value and Product Labour Cost Tool China"]
[null,"Instructions and input fields, calculation and comparison of labour minute values\n使用说明，输入栏以及劳动力分钟价值的计算和比较"]
[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\n请根据您工厂实际的信息情况填写表格中的黄色空格部分"]
[]
[]
[null,null,null,null,null,null,"Factory Name (optional)\n工厂名称（可选填）"]
[null,null,null,null,null,null,"Responsible staff (optional)\n负责人（可选填）"]
[null,"Step","Value"]
[null,"1)",7.89,"Exchange rate CNY - Euro   欧元兑人民币的汇率 "]
[null,"workforce"]
[null,"2)",null,"Total number of workers - 员工总数"]
[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,null,{"$f":"IFERROR(C14/C13,0)","v":0},"of the workforce.\n占工厂总人数比例"]
[null,"paid leave"]
[null,null,11,"Statutory holidays, 11 days in total, include Spring Festivals (3 days), 1 Jan (new year), 5 Apr (tomb sweeping day), 1 May (National holiday), Lunar calendar 5 May (tomb sweeping festival), lunar calendar 15 Aug (mid-autumn festival), national holiday 3 days (1 to 3rd Oct) \n每年有11天法定假日包含中秋，端午等"]
[null,"4)",1,"Insert the percentage of your workforce with 1-10 years of service. These workers are entilted to 5 days of annual leave per year. 1到10年工龄的员工总数"]
[null,"5)",0,"Insert the percentage of your workforce with 10-20 years of service. These workers are entilted to 10 days of annual leave per year. 10到20年工龄的员工总数"]
[null,"6)",0,"Insert the percentage of your workforce with more than 20 years of service. These workers are entilted to 15 days of annual leave per year. 多于20年工龄的员工总数"]
[null,null,{"$f":"SUM(C17:C19)","v":1},"Must add up to 100%"]
[null,null,{"$f":"IFERROR(C16+C17*5+C18*10+C19*15,0)","v":16},"Average number of holiday payments / paid annual leave per worker per YEAR. 假日工资支付的平均数/每年每人的带薪年休假"]
[null,"overtime"]
[null,"7)",null,"Insert the actual number of OT Hours per week during working days. 输入每周工作日的实际加班小时数"]
[null,"8)",null,"Insert the actual number of OT Hours per week during the weekend. 输入每周周末的实际加班小时数"]
[null,"9)",null,"Insert the actual number of OT Hours per week during statutory holidays. 输入每周法定假日实际加班小时数"]
[null,null,{"$f":"SUM(C23:C25)","v":0},"Total number of OT Hours per week. 每周总加班小时数，从而算出："]
[null,"capacity minutes"]
[null,null,{"$f":"40*4.33*60+C26*4.33*60-((C21/12*8*60))-((C21/12*C26/6)*60)","v":9752},"Total capacity minutes per worker/month, based on regular (40 h/w) and overtime hours (C27) and adjusted for the total average number of paid leave taken annually per worker (C22). "]
[null,null,{"$f":"C14*C28","v":0},"Total number of monthly sewing minutes (number of sewing operators x (40 + weekly OT hours) x 4.33 x 60) MINUS average monthly number of minutes on days not worked (i.e. paid leave).  每月的总缝制分钟数（缝制工数量x（40+每周加班总数）X4.33X60) 减去 平均每月不工作的分钟总数 （如，带薪公众假期）"]
[null,"paid benefits"]
[null,"10)",null,"Insert total amount paid in attendance bonuses per MONTH in CNY - 输入每月支付的出勤奖金总数（如果适用的话）"]
[null,"11)",null,"Insert total amount paid in productivity bonuses per MONTH in CNY - 输入每月支付的生产奖金总数（如果适用的话）"]
[null,"12)",null,"Insert total amount paid in seniority bonuses per MONTH in CNY - 输入每月支付的工龄奖金总数（如果适用的话）"]
[null,"13)",null,"Insert total amount paid in skills bonuses per MONTH in CNY - 输入每月支付的岗位/技术奖金总数（如果适用的话）"]
[null,"14)",null,"If applicable, Insert total amount paid in additional bonuses (e.g. 13th salary payment) PER YEAR in CNY. 输入每年支付的额外奖金总数（如果适用的话）"]
[null,"employer on-costs"]
[null,"15)",null,"Insert the total amount you paid for housing fund per YEAR in CNY - 输入每年支付的住房公积金总数（如果适用的话）"]
[null,"16)",null,"Total amount paid in severence pay per YEAR in CNY. 每年支付经济赔偿金（解雇金）的总数（人民币）"]
[null,"17)",null,"Insert total amount paid in any additional labour related on-costs paid per YEAR in CNY - 输入每年支付的其他额外的劳动力相关成本（如果适用的话）"]
[]
[null,"18)",null,"Enter total actual monthly Wage Bill (direct and indirect) including piece rate wages, OT Hours, bonuses, social security, etc  输入每月实际工资总数（直接以及间接员工）包含计件工资，奖金，社保等",null,null,null,null,{"$f":"IFERROR(C41/C13,0)","v":0},"average monthly wage bill per worker."]
[null,"19)",2010,"Enter Regional Legal Minimum Wage (based on regular working hours)\n输入当地最低工资标准（基于正常工作时间）"]
[null,"20)",2500,"Wage Benchmark based on regular working hours (new NMW or Target Wage)\n基于正常工作时间的工资标准 （新的最低工资标准或者目标的工资标准）"]
[]
[null,"Wage Level\n工资水平","Description\n描述",null,null,"Labour Cost  avg. worker","Capacity Minutes","Labour Minute Value (CNY)","Labour Minute Value (EUR)","Difference (absolute)","Increment (in%)"]
[null,{"$f":"'Labour Minute Value China'!E7","v":0},"Labour Minute Value (based on Actual Wage Bill) \n基于工厂实际工资总数的劳动力分钟价值",null,null,{"$f":"'Labour Minute Value China'!E29","v":0},{"$f":"C28","v":9752},{"$f":"F46/G46","v":0},{"$f":"H46/$C$11","v":0}]
[null,{"$f":"C42","v":2010},"Labour Minute Value (based on Legal Minimum Wage) \nWith OT Hours remunerated at 100% of LMW.\n基于当地最低工资标准的劳动力分钟价值\n加班费按最低工资标准的100%计算",null,null,{"$f":"'Labour Minute Value China'!H29","v":2637.12},{"$f":"C28","v":9752},{"$f":"F47/G47","v":0.27041837571780147},{"$f":"H47/$C$11","v":3.4273558392623762E-2},{"$f":"I47-I46","v":3.4273558392623762E-2},{"$f":"IFERROR((I47-I46)/I46,0)","v":0}]
[null,{"$f":"C42","v":2010},"Labour Minute Value (based on Legal Minimum Wage) \nWith OT hours remunerated as per min. wage law: 150-200-300%)\n基于当地最低工资标准的劳动力分钟价值 \n加班费按最低工资标准的150-200-300%计算",null,null,{"$f":"'Labour Minute Value China'!K29","v":2637.12},{"$f":"C28","v":9752},0.27041837571780147,3.4273558392623762E-2,{"$f":"I48-I46","v":3.4273558392623762E-2},{"$f":"IFERROR((I48-I46)/I46,0)","v":0}]
[null,{"$f":"C43","v":2500},"Labour Minute Value (based on Target Wage)\n基于目标工资标准的劳动力分钟价值",null,null,{"$f":"'Labour Minute Value China'!N29","v":3280},{"$f":"C28","v":9752},0.33634126333059883,4.2628803970925076E-2,{"$f":"I49-I46","v":4.2628803970925076E-2},{"$f":"IFERROR((I49-I46)/I46,0)","v":0}]
[]
[null,"Monthly Operational Expenses in the Factory\n工厂每月的运营费用"]
[null,null,"in CNY\n人民币","in Euro\n欧元","per minute \n每分钟","(operational expenses in EUR divided by the total monthly sewing minutes (C20)\n总运营费用（欧元）除以每月总缝制分钟数（C20)"]
[null,"21)",null,{"$f":"C53/C11","v":0},{"$f":"IFERROR(D53/C29,0)","v":0},"Insert the total amount paid for Direct Labour (i.e. sewing operators) per month in CNY.\n输入每月支付直接劳动力（缝制工）的总成本（人民币）"]
[null,"22)",null,{"$f":"C54/C11","v":0},{"$f":"IFERROR(D54/C29,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 CNY.\n输入每月支付间接劳动力（除缝制外的所有部门，如裁剪，检验，机修，保安，清洁，文员等）的总成本（人民币）"]
[null,null,{"$f":"SUM(C53:C54)","v":0},{"$f":"D54+D53","v":0},{"$f":"SUM(E53:E54)","v":0},"Total labour costs per month in CNY / Labour Minute Costs (calculated by dividing with sewing capacity minutes: C24)\n每月总劳动力成本（人民币）/每分钟劳动力成本 （用劳动力总成本除以缝制分钟总数得出）"]
[null,"23)",null,{"$f":"C56/C11","v":0},{"$f":"IFERROR(D56/C29,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 CNY.\n输入每月平均的管理成本（人民币）：租金，能源，电，培训，利息，厂房折旧，安全措施等"]
[null,"24)",null,{"$f":"C57/C11","v":0},{"$f":"IFERROR(D57/C29,0)","v":0},"If applicable, Insert the total additional costs per month for Covid-19 measures (e.g. face masks, desinfectants, temperature scanning, etc).  \n如适用，输入每月为预防新冠肺炎的额外支出（如，口罩，消毒液，体温测试等）"]
[null,null,{"$f":"C55+C56+C57","v":0},{"$f":"D56+D55+D57","v":0},{"$f":"E56+E55+E57","v":0},"Total factory expenses per month in IDR / working minute costs (which can be compared with the working minute costs based on prevailing (2018) min. wage (Cell I-59) as a plausibility check).\n每月工厂总运营费用/每个工作分钟的成本 （这个工作分钟成本可以用于跟基于现行最低工资标准的工作分钟成本做比较检查其合理性）"]
[]
[null,null,{"$f":"IFERROR(C53/C55,0)","v":0},"Total percentage paid for Direct Labour, i.e. sewing (based on step 2 above) 用于支付直接劳动力成本的总比例，例如，缝制"]
[null,null,{"$f":"IFERROR(C54/C55,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 3 above) 用于支付间接劳动力成本的总比例，例如，除了缝制工意外的其他部门，如，裁剪，质检，机修，保安，清洁，办公室人员等"]
[]
[null,"Once you have inserted all above you should get following information: 前面栏目都输入完成后，您会自动得到下面的数据信息："]
[]
[null,"Wage grade\n工资级别","Description\n描述",null,null,"Direct Labour (A)\n直接劳动力（A)","Indirect Labour  (B)\n间接劳动力（B)","Factory Labour Minute Value (C)\n工厂劳动力分钟价值（C)","Overhead (D)\n管理成本（D）","Total Working Minute Cost (C+D)\n总体工作分钟成本（C+D)","Increment (in%)"]
[null,null,null,null,null,{"$f":"C60","v":0},{"$f":"C61","v":0},"A+B"]
[null,{"$f":"B46","v":0},"Labour Minute Value (based on Actual Wage Bill) \n基于工厂实际工资总数的劳动力分钟价值",null,null,{"$f":"I46","v":0},{"$f":"IFERROR(H67*C61,0)","v":0},{"$f":"IFERROR(F67/C60,0)","v":0},{"$f":"E56+E57","v":0},{"$f":"SUM(H67:I67)","v":0}]
[null,{"$f":"B47","v":2010},"Labour Minute Value (based on Legal Minimum Wage) \nWith OT Hours remunerated at 100% of LMW.\n基于当地最低工资标准的劳动力分钟价值\n加班费按最低工资标准的100%计算",null,null,{"$f":"I47","v":3.4273558392623762E-2},{"$f":"IFERROR(H68*C61,0)","v":0},{"$f":"IFERROR(F68/C60,0)","v":0},{"$f":"E56+E57","v":0},{"$f":"SUM(H68:I68)","v":0},{"$f":"IFERROR((J68-J67)/J67,0)","v":0}]
[null,{"$f":"B48","v":2010},"Labour Minute Value (based on Legal Minimum Wage) \nWith OT hours remunerated as per min. wage law: 150-200-300%)\n基于当地最低工资标准的劳动力分钟价值 \n加班费按最低工资标准的150-200-300%计算",null,null,{"$f":"I48","v":3.4273558392623762E-2},{"$f":"IFERROR(H69*C61,0)","v":0},{"$f":"IFERROR(F69/C60,0)","v":0},{"$f":"E56+E57","v":0},{"$f":"SUM(H69:I69)","v":0},{"$f":"IFERROR((J69-J67)/J67,0)","v":0}]
[null,{"$f":"B49","v":2500},"Labour Minute Value (based on Target Wage)\n基于目标工资标准的劳动力分钟价值",null,null,{"$f":"I49","v":4.2628803970925076E-2},{"$f":"IFERROR(H70*C61,0)","v":0},{"$f":"IFERROR(F70/C60,0)","v":0},{"$f":"E56+E57","v":0},0,{"$f":"IFERROR((J70-J67)/J67,0)","v":0}]

{"sheet":"Product Style Costing","index":1,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[39,8,39,10],[40,2,40,3],[41,8,41,10],[42,8,42,10],[38,2,38,3],[38,4,38,7],[38,8,38,10],[32,1,36,1],[43,2,43,3],[44,2,44,3],[46,3,46,6],[39,2,39,3],[39,4,39,7],[36,2,36,3],[36,4,36,7],[37,2,37,3],[37,4,37,7],[37,8,37,10],[29,2,29,3],[29,4,29,7],[29,8,29,10],[30,2,30,3],[30,4,30,7],[30,8,30,10],[36,8,36,10],[31,2,31,3],[31,4,31,7],[32,2,32,3],[32,8,35,10],[35,2,35,3],[27,2,27,3],[27,4,27,5],[27,6,27,10],[28,2,28,3],[28,4,28,7],[28,8,28,10],[25,2,25,3],[25,4,25,5],[25,6,25,10],[26,2,26,3],[26,4,26,5],[26,6,26,10],[24,2,24,3],[24,4,24,7],[24,8,24,10],[13,1,14,1],[13,2,14,4],[13,10,14,10],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[20,1,20,10],[23,2,23,3],[23,4,23,7],[23,8,23,10],[11,1,11,10],[1,1,1,8],[4,1,4,8],[8,6,8,7],[7,8,7,10],[8,8,8,10],[7,6,7,7],[9,8,9,10]]}
[null,"Product Style Costing Calculator China"]
[null,"Instructions and input fields, calculation and comparison of labour minute values\n使用说明，输入栏以及劳动力分钟价值的计算和比较"]
[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\n请根据您工厂实际的信息情况填写表格中的黄色空格部分"]
[]
[]
[null,null,null,null,null,null,"name of the brand (optional)\n请输入品牌名称（可选填）"]
[null,null,null,null,null,null,"Factory Name (optional)\n工厂名称（可选填）"]
[null,null,null,null,null,null,"Responsible staff (optional)\n负责人（可选填）"]
[]
[null,"Once you have inserted all above you should get following information: 前面栏目都输入完成后，您会自动得到下面的数据信息："]
[]
[null,"Wage grade\n工资级别","Description\n描述",null,null,"Direct Labour (A)\n直接劳动力（A)","Indirect Labour  (B)\n间接劳动力（B)","Factory Labour Minute Value (C)\n工厂劳动力分钟价值（C)","Overhead (D)\n管理成本（D）","Total Working Minute Cost (C+D)\n总体工作分钟成本（C+D)","Increment (in%)"]
[null,null,null,null,null,{"$f":"'Factory Input Fields'!$F$66","v":0},{"$f":"'Factory Input Fields'!$F$66","v":0},"A+B"]
[null,{"$f":"'Factory Input Fields'!B67","v":0},"Labour Minute Value (based on Actual Wage Bill) \n基于工厂实际工资总数的劳动力分钟价值",null,null,{"$f":"'Factory Input Fields'!F67","v":0},{"$f":"'Factory Input Fields'!G67","v":0},{"$f":"'Factory Input Fields'!H67","v":0},{"$f":"'Factory Input Fields'!I67","v":0},{"$f":"SUM(H16:I16)","v":0}]
[null,{"$f":"'Factory Input Fields'!B68","v":2010},"Labour Minute Value (based on Legal Minimum Wage) \nWith OT Hours remunerated at 100% of LMW.\n基于当地最低工资标准的劳动力分钟价值\n加班费按最低工资标准的100%计算",null,null,{"$f":"'Factory Input Fields'!F68","v":3.4273558392623762E-2},{"$f":"'Factory Input Fields'!G68","v":0},{"$f":"'Factory Input Fields'!H68","v":0},{"$f":"'Factory Input Fields'!I68","v":0},{"$f":"SUM(H17:I17)","v":0},{"$f":"IFERROR((J17-J16)/J16,0)","v":0}]
[null,{"$f":"'Factory Input Fields'!B69","v":2010},"Labour Minute Value (based on Legal Minimum Wage) \nWith OT hours remunerated as per min. wage law: 150-200-300%)\n基于当地最低工资标准的劳动力分钟价值 \n加班费按最低工资标准的150-200-300%计算",null,null,{"$f":"'Factory Input Fields'!F69","v":3.4273558392623762E-2},{"$f":"'Factory Input Fields'!G69","v":0},{"$f":"'Factory Input Fields'!H69","v":0},{"$f":"'Factory Input Fields'!I69","v":0},0,{"$f":"IFERROR((J18-J16)/J16,0)","v":0}]
[null,{"$f":"'Factory Input Fields'!B70","v":2500},"Labour Minute Value (based on Target Wage)\n基于目标工资标准的劳动力分钟价值",null,null,{"$f":"'Factory Input Fields'!F70","v":4.2628803970925076E-2},{"$f":"'Factory Input Fields'!G70","v":0},{"$f":"'Factory Input Fields'!H70","v":0},{"$f":"'Factory Input Fields'!I70","v":0},0,{"$f":"IFERROR((J19-J16)/J16,0)","v":0}]
[]
[null,"Calculating the cost for a product style 计算一个产品的成本"]
[null,"Note: Type a point (.) for decimals behind the comma."]
[]
[null,null,"Items provided by the factory\n工厂提供的产品",null,"Details / Calculations\n明细/计算",null,null,null,"Notes\n备注"]
[null,"1)","Style Name\n款式名称",null,null,null,null,null,"Style name or number of the Product\n产品的款式名称或者是代号"]
[null,"2)","Standard Allowed Minutes\n标准工时",null,null,null,"Standard Allowed (sewing) Minutes of the style you want to calculate per piece. \n生产一件您想计算的款式的标准（缝纫）工时"]
[null,"3)","Efficiency Percentage\n效率值",null,null,null,"Depending on your cost calculation the factory or line efficiency value. Note: One could adjust this % to calculate the impact of Covid-19 on labour (and product) costs due to possible efficiency loss. \n根据您的成本计算，工厂或生产线效率值。注：可以调整这个百分比来计算新冠肺炎对可能的效率损失造成的劳动力（和产品）成本的影响。"]
[null,null,"Total actual number of sewing minutes for style:\n该款式的实际缝制分钟数",null,{"$f":"IFERROR(E26/E27,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.\n注：如果您不知道标准工时和效率值，只需在2)栏目标出生产一件衣服的实际（缝纫）工时，3)栏目中标出100%效率。"]
[null,"4)","Fabric\n布料",null,null,null,null,null,"Fabric costs per piece (incl. wastage %) in €\n每件的布料成本（欧元）（包含损耗）"]
[null,"5)","Accessories\n辅料",null,null,null,null,null,"Costs for accessories (buttons, zippers, etc) per piece in €\n每件的辅料成本（欧元）（纽扣，拉链等）"]
[null,"6)","Polybag, packaging, labelling\n塑料袋、包装、标签",null,null,null,null,null,"Total amount per piece for polybag, packaging, hangtag in €\n每件的塑料袋，包装，标签的成本（欧元）"]
[null,null,"Total Material Costs\n物料成本总数",null,{"$f":"SUM(E29:G31)","v":0}]
[null,"Total CM Costs","Labour Cost\n劳动力成本",null,"Actual Piece Rate\n实际的计件单价","at LMW \n(OT paid at 100%)\n所有加班时间都按最低工资标准的100%支付","at LMW \n(OT paid as per law)\n加班时间按法律要求150-200-300%支付","at Target Wage\n基于目标工资标准的单价","Factory labour minute value x SAM / efficiency %\n工厂的劳动力分钟价值x标准工时/效率值"]
[null,null,"Direct直接",{"$f":"F15","v":0},{"$f":"E28*F16","v":0},{"$f":"F17*E28","v":0},{"$f":"F18*E28","v":0},{"$f":"F19*E28","v":0}]
[null,null,"Indirect间接",{"$f":"G15","v":0},{"$f":"G16*E28","v":0},{"$f":"G17*E28","v":0},{"$f":"G18*E28","v":0},{"$f":"G19*E28","v":0}]
[null,null,"Total labour cost",null,{"$f":"SUM(E34:E35)","v":0},0,{"$f":"SUM(G34:G35)","v":0},{"$f":"SUM(H34:H35)","v":0}]
[null,null,"Overhead Cost (electricity, fuel ..)\n经常性支出成本（电，燃料等）",null,{"$f":"IFERROR(E28*I16,0)","v":0},null,null,null,"Monthly overhead costs (step 2) divided by monthly sewing minutes -C21) x minutes spent on style (step 2-3).\n每月的经常性支出成本总数（第二步）除以每月的缝制分钟数-C21x每件花费的分钟数（第2-3步）"]
[null,"7)","Outsourced processes\n外发工序成本",null,null,null,null,null,"If applicable, amount paid per piece for outsourced processes (e.g. embroidery, washing, printing) in €\n支付外发工序的每件的成本（欧元），如，绣花，洗水，印花（如果适用的话）"]
[null,"8)","Logistic costs (inbound-outbound) \n物流成本（入港-离港）",null,null,null,null,null,"Cost for logistics (inbound and out-bound) calculated p/piece in €\n每件的物流成本（欧元）（入港和离港）"]
[null,"9)","Import tax and duties\n进口税",null,null,null,null,null,"Cost for import tax and duties calculated per piece in €\n每件的进口关税（欧元）"]
[null,null,"Total Garment Manufacturing Cost\n衣服的生产成本总数",null,{"$f":"E40+E37+E39+E38+E36+E32","v":0},{"$f":"E40+E37+E39+E38+F36+E32","v":0},{"$f":"E40+E37+E39+E38+G36+E32","v":0},{"$f":"E40+E37+E39+E38+H36+E32","v":0}]
[null,"10)","Profit Margin\n利润率",null,{"$f":"E41*D42","v":0},{"$f":"D42*F41","v":0},{"$f":"D42*G41","v":0},{"$f":"D42*H41","v":0},"Insert your profit margin.\n输入您的利润率"]
[null,"11)","Buying House Commission",null,{"$f":"D43*E41","v":0},{"$f":"F41*D43","v":0},{"$f":"G41*D43","v":0},{"$f":"D43*H41","v":0},"If applicable, insert the percentage you pay to a buying house or agent"]
[null,null,"Factory Selling Price\n出厂价格 ",null,{"$f":"SUM(E41:E42)","v":0},0,0,{"$f":"SUM(H41:H42)","v":0}]
[null,null,"% difference\n差距% ",null,null,{"$f":"IFERROR((F44-E44)/E44,0)","v":0},{"$f":"IFERROR((G44-E44)/E44,0)","v":0},{"$f":"IFERROR((H44-F44)/F44,0)","v":0}]
[]
[null,"12)",null,"CHECK: insert the FOB price you receive from the buyer (in €).\n检查：请输入客户给的FOB价格（欧元）",null,null,null,null,"Date:"]
[null,"13)",null,"Insert the order size (# pieces)",{"$f":"C48*E44","v":0},{"$f":"C48*F44","v":0},{"$f":"C48*G44","v":0},{"$f":"C48*H44","v":0},"Order Value"]

{"sheet":"Labour Minute Value China","index":2,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[[39,16,39,17],[37,18,37,22],[38,18,38,22],[39,18,39,22],[33,18,33,22],[34,19,35,22],[34,16,34,17],[33,16,33,17],[38,16,38,17],[36,16,36,17],[37,16,37,17],[3,1,3,2],[4,1,4,2],[9,10,9,11],[9,13,9,14],[9,1,10,2],[9,4,9,5],[3,4,3,5],[6,4,6,5],[4,4,4,5],[3,13,4,14],[3,10,4,11],[6,1,6,2],[6,10,6,11],[6,13,6,14],[3,7,4,8],[6,7,6,8],[13,17,13,23],[12,17,12,23],[11,17,11,23],[9,17,10,23],[15,17,15,22],[17,17,17,22],[18,17,18,22],[32,17,32,23],[20,17,20,23],[21,17,21,22],[31,17,31,23],[30,17,30,23],[29,17,29,23],[28,17,28,23],[3,20,3,21],[5,17,5,18],[6,17,6,18],[4,20,4,21],[4,17,4,18],[3,17,3,18],[14,1,19,1],[5,20,5,21],[6,20,6,21],[35,16,35,17],[9,7,9,8],[28,4,28,5],[11,1,13,1],[14,17,14,22],[25,17,25,23],[27,17,27,23],[26,17,26,23],[23,17,23,22],[20,1,24,1],[24,17,24,23],[25,1,25,2],[16,17,16,22],[26,1,26,2],[27,1,27,2],[22,17,22,22],[28,7,28,8],[28,1,28,2],[28,10,28,11],[28,13,28,14],[39,1,39,3],[39,12,39,15],[37,1,37,3],[37,11,37,15],[38,1,38,3],[38,11,38,15],[29,13,29,14],[29,4,29,5],[33,1,33,2],[33,10,33,11],[34,10,34,11],[33,7,33,8],[34,7,34,8],[32,13,32,14],[30,13,30,14],[31,1,31,2],[30,4,30,5],[31,4,31,5],[31,10,31,11],[31,13,31,14],[30,1,30,2],[30,10,30,11],[32,10,32,11],[29,1,29,2],[29,10,29,11],[32,7,32,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,1,32,2]]}
[]
[null,"Factory Labour Minute Value and Product Labour Cost Tool China"]
[null,"\n中国工厂劳动力分钟价值以及产品成本计算工具"]
[null,"Exchange rate CNY - €\n(change to actual) \n欧元兑人民币的汇率\n（根据实时汇率更改）\n",null,null,"Total actual monthly Wage Bill (direct and indirect) including piece rate wages, bonus, social security, etc, per worker..\n输入总每月实际工资总数（直接以及间接员工）包含计件工资，奖金，社保等",null,null,"Enter Regional Legal Minimum Wage (based on regular working hours); \nAll OT hours remunerated at 100% of legal min.\n输入当地最低工资标准（基于正常工作时间）\n所有加班时间都按最低工资标准的100%支付",null,null,"Enter Regional Legal Minimum Wage (based on regular working hours)\nAll OT hours remunerated as per min. wage law: 150-200-300%)\n输入当地最低工资标准（基于正常工作时间）\n加班时间按最低工资标准的150-200-300%支付",null,null,"Wage Benchmark based on regular working hours \n(new NMW or Target Wage)\n基于正常工作时间的工资标准\n（新的最低工资标准或者目标的工资标准）",null,null,null,"Average OT Hours per week\n每周总的加班时间",null,null,"Total number of workers\n员工总数"]
[null,{"$f":"'Factory Input Fields'!C11","v":7.89},null,null,{"$f":"'Factory Input Fields'!I41","v":0},null,null,null,null,null,null,null,null,null,null,null," @150%",{"$f":"'Factory Input Fields'!C23","v":0},null,null,{"$f":"'Factory Input Fields'!C13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," @200%",{"$f":"'Factory Input Fields'!C24","v":0}]
[null,"Basic Wage per month per worker\n每月每个工人的基本工资",null,null,{"$f":"E14","v":0},null,null,{"$f":"'Factory Input Fields'!C42","v":2010},null,null,{"$f":"'Factory Input Fields'!C42","v":2010},null,null,{"$f":"'Factory Input Fields'!C43","v":2500},null,null," @300%",{"$f":"'Factory Input Fields'!C25","v":0}]
[]
[]
[null,"Wage Item\n工资项目",null,null,"Actual Wages Paid \n实际支付的工资",null,null,"Current LMW\n现行的最低工资标准",null,null,"Current LMW\n现行的最低工资标准",null,null,"New Wage Benchmark\n新的工资标准",null,null,null,"Explanatory Notes\n注释"]
[null,null,null,null,"Regular working hours (40)\n正常工作时间（40小时/周）","Overtime hours\n加班时间 ",null,"Regular working hours (40h)\n正常工作时间（40小时/周）","Overtime hours  \n加班时间",null,"Regular working hours (40h)\n正常工作时间（40小时/周）","Overtime hours  \n加班时间",null,"Regular working hours (40h)\n正常工作时间（40小时/周）","Overtime hours  \n加班时间"]
[null,"Legal Minimum Wage\n\nPay for time worked","Basic Wage (Net)\n基本工资（净值）",null,{"$f":"IFERROR(E26*(K14/K26),0)","v":0},null,null,{"$f":"H7","v":2010},null,null,{"$f":"K7","v":2010},null,null,{"$f":"N7","v":2500},null,null,null,"Regular working hours 40h/week \n正常工作时间40小时/周\n"]
[null,null,"OT Wage\n加班工资",null,null,{"$f":"((E12/4.33/40*1.5*R5)+(E12/4.33/40*2*R6)+(E12/4.33/40*3*R7))*4.33","v":0},null,null,{"$f":"((H12/4.33/40*R5)+(H12/4.33/40*R6)+(H12/4.33/40*R7))*4.33","v":0},null,null,{"$f":"((K12/4.33/40*1.5*R5)+(K12/4.33/40*2*R6)+(K12/4.33/40*3*R7))*4.33","v":0},null,null,{"$f":"((N12/4.33/40*1.5*R5)+(N12/4.33/40*2*R6)+(N12/4.33/40*3*R7))*4.33","v":0},null,null,"150% for regular OT, 200% for weekend OT and 300% for statutory OT\n正常加班费150%，周末加班费200%以及法定假日加班费300%"]
[null,null,"SubTOTAL 1\n小计1",null,{"$f":"IFERROR(SUM(E12:E13),0)","v":0},{"$f":"IFERROR(F26*(L14/L26),0)","v":0},null,{"$f":"H12","v":2010},{"$f":"I13","v":0},null,{"$f":"K12","v":2010},{"$f":"L13","v":0},null,{"$f":"N12","v":2500},{"$f":"O13","v":0}]
[null,"Directly \nPaid\nBenefits\n直接支付的福利","Attendance bonus\n出勤奖金",null,{"$f":"IFERROR(X15/U5,0)","v":0},null,null,{"$f":"IFERROR(X15/$U$5,0)","v":0},null,null,{"$f":"IFERROR(X15/$U$5,0)","v":0},null,null,{"$f":"IFERROR(X15/$U$5,0)","v":0},null,null,null,"Total amount paid in attendance bonuses per MONTH in CNY.\n输入每月支付的出勤奖金总数（如果适用的话）",null,null,null,null,null,{"$f":"'Factory Input Fields'!C31","v":0}]
[null,null,"Productivity Bonus\n生产奖金",null,{"$f":"IFERROR(X16/U5,0)","v":0},null,null,{"$f":"IFERROR(X16/$U$5,0)","v":0},null,null,{"$f":"IFERROR(X16/$U$5,0)","v":0},null,null,{"$f":"IFERROR(X16/U5,0)","v":0},null,null,null,"Total amount paid in productivity bonuses per MONTH in CNY. \n输入每月支付的生产奖金总数（如果适用的话）",null,null,null,null,null,{"$f":"'Factory Input Fields'!C32","v":0}]
[null,null,"Seniority Bonus\n年资奖金",null,{"$f":"IFERROR(X17/U5,0)","v":0},null,null,{"$f":"IFERROR(X17/$U$5,0)","v":0},null,null,{"$f":"IFERROR(X17/$U$5,0)","v":0},null,null,{"$f":"IFERROR(X17/$U$5,0)","v":0},null,null,null,"Total amount paid in seniority bonuses per MONTH in CNY.\n输入每月支付的工龄奖金总数（如果适用的话）",null,null,null,null,null,{"$f":"'Factory Input Fields'!C33","v":0}]
[null,null,"Position/Skill Bonus\n岗位/技术奖金",null,{"$f":"IFERROR(X18/U5,0)","v":0},null,null,{"$f":"IFERROR(X18/$U$5,0)","v":0},null,null,{"$f":"IFERROR(X18/$U$5,0)","v":0},null,null,{"$f":"IFERROR(X18/$U$5,0)","v":0},null,null,null,"Total amount paid in skills bonuses per MONTH in CNY. \n输入每月支付的岗位/技术奖金总数（如果适用的话）",null,null,null,null,null,{"$f":"'Factory Input Fields'!C34","v":0}]
[null,null,"Any other Bonuses\n其他奖金",null,{"$f":"IFERROR(X19/U5/12,0)","v":0},null,null,{"$f":"IFERROR(X19/$U$5/12,0)","v":0},null,null,{"$f":"IFERROR(X19/$U$5/12,0)","v":0},null,null,{"$f":"IFERROR(X19/$U$5/12,0)","v":0},null,null,null,"Total amount paid in additional bonuses (e.g. 13th salary payment) per year in CNY:\n输入每年支付的额外奖金总数（如果适用的话）",null,null,null,null,null,{"$f":"'Factory Input Fields'!C35","v":0}]
[null,null,"SubTOTAL 2\n小计2",null,{"$f":"SUM(E16:E19)","v":0},{"$f":"SUM(F16:F19)","v":0},null,{"$f":"SUM(H16:H19)","v":0},{"$f":"SUM(I16:I19)","v":0},null,{"$f":"SUM(K16:K19)","v":0},{"$f":"SUM(L16:L19)","v":0},null,{"$f":"SUM(N16:N19)","v":0},{"$f":"SUM(O16:O19)","v":0}]
[null,"Employer \nlabour\nrelated\non-cost\n雇主劳动力相关成本","Social Security payments Employer 31.2%\n雇主承担的社保费用31.2%",null,{"$f":"IFERROR(E26*(K21/K26),0)","v":0},{"$f":"IFERROR(F26*(L21/L26),0)","v":0},null,{"$f":"(H14+H20)*31.2%","v":627.12},{"$f":"(I14+I20)*31.2%","v":0},null,{"$f":"(K14+K20)*31.2%","v":627.12},{"$f":"(L14+L20)*31.2%","v":0},null,{"$f":"(N20+N14)*31.2%","v":780},{"$f":"(O20+O14)*31.2%","v":0},null,null,"Pension 20% + Medical 10% + Injury 0.3% + Maternity 0.8% Unemployment 1% = Total 31.2%\n养老 20% + 医疗 10% + 工伤 0.3% + 生育 0.8% + 失业 1% = 总数 31.2%\n以上是公司承担的各项社保费用比例"]
[null,null,"Housing fund\n住房公积金",null,{"$f":"IFERROR(X22/U5/12,0)","v":0},null,null,{"$f":"IFERROR(X22/U5/12,0)","v":0},null,null,{"$f":"IFERROR(X22/U5/12,0)","v":0},null,null,{"$f":"IFERROR(X22/U5/12,0)","v":0},null,null,null,"Total amount you paid for housing fund per year\n输入每年支付的住房公积金总数（如果适用的话）",null,null,null,null,null,{"$f":"'Factory Input Fields'!C37","v":0}]
[null,null,"Severence Pay",null,{"$f":"IFERROR(X23/U5/12,0)","v":0},null,null,{"$f":"IFERROR(X23/U5/12,0)","v":0},null,null,{"$f":"IFERROR(X23/U5/12,0)","v":0},null,null,{"$f":"IFERROR(X23/U5/12,0)","v":0},null,null,null,"Total amount paid in severence pay per YEAR in CNY.",null,null,null,null,null,{"$f":"'Factory Input Fields'!C38","v":0}]
[null,null,"Additional employer labour related on-costs\n其他的劳动力相关成本",null,{"$f":"IFERROR(X24/U5/12,0)","v":0},null,null,{"$f":"IFERROR(U24/R5/12,0)","v":0},null,null,{"$f":"IFERROR(X24/U5/12,0)","v":0},null,null,{"$f":"IFERROR(X24/U5/12,0)","v":0},null,null,null,"If applicable, total amount paid in any additional labour related on-costs paid per year: \n输入每年支付的其他额外的劳动力相关成本（如果适用的话）",null,null,null,null,null,{"$f":"'Factory Input Fields'!C39","v":0}]
[null,null,"SubTOTAL 3\n小计3",null,{"$f":"SUM(E21:E24)","v":0},{"$f":"SUM(F21:F24)","v":0},null,{"$f":"SUM(H21:H24)","v":627.12},{"$f":"SUM(I21:I24)","v":0},null,{"$f":"SUM(K21:K24)","v":627.12},{"$f":"SUM(L21:L24)","v":0},null,{"$f":"SUM(N21:N24)","v":780},{"$f":"SUM(O21:O24)","v":0}]
[null,"TOTAL Labour cost per worker in CNY\n每个工人总的劳动力成本（人民币）",null,null,{"$f":"IFERROR(E29*(K26/K29),0)","v":0},{"$f":"IFERROR(E29*(L26/K29),0)","v":0},null,{"$f":"H25+H20+H14","v":2637.12},{"$f":"I25+I20+I14","v":0},null,{"$f":"K25+K20+K14","v":2637.12},{"$f":"L25+L20+L14","v":0},null,{"$f":"N25+N20+N14","v":3280},{"$f":"O25+O20+O14","v":0}]
[null,"Monthly capacity minutes\n每月的产能分钟数",null,null,{"$f":"40*4.33*60-('Factory Input Fields'!C21/12*8*60)","v":9752},{"$f":"(R5*4.33*60)+(R6*4.33*60)+(R7*4.33*60)-(('Factory Input Fields'!C21/12*'Factory Input Fields'!C26/6)*60)","v":0},null,{"$f":"E27","v":9752},{"$f":"F27","v":0},null,{"$f":"E27","v":9752},{"$f":"F27","v":0},null,{"$f":"E27","v":9752},{"$f":"F27","v":0},null,null,"Regular working time: 40h/week x 4.33 x 60min\n正常工作时间：40小时/周x4.33x60分钟\nOvertime: Actual OT/week x 4.33 x 60min\n加班时间：每周实际加班时间总数x4.33周x60分钟"]
[null,"Labour Minute Value CNY\n劳动力分钟价值（人民币）\n(row 26/27)（26/27行）",null,null,{"$f":"E26/E27","v":0},{"$f":"IFERROR(F26/F27,0)","v":0},null,{"$f":"H26/H27","v":0.27041837571780147},{"$f":"IFERROR(I26/I27,0)","v":0},null,{"$f":"K26/K27","v":0.27041837571780147},{"$f":"IFERROR(L26/L27,0)","v":0},null,{"$f":"N26/N27","v":0.33634126333059883},{"$f":"IFERROR(O26/O27,0)","v":0}]
[null,"Monthly Labour Cost incl. OT in CNY\n每月劳动力成本包含加班（人民币）\n(sum row 27)（27行总计）",null,null,{"$f":"IFERROR(E5,0)","v":0},null,null,{"$f":"H26+I26","v":2637.12},null,null,{"$f":"K26+L26","v":2637.12},null,null,{"$f":"N26+O26","v":3280}]
[null,"Monthly capacity minutes incl. OT \n每月产能分钟总数包含加班时间\n(sum row 28)（28行总计）",null,null,{"$f":"E27+F27","v":9752},null,null,{"$f":"H27+I27","v":9752},null,null,{"$f":"K27+L27","v":9752},null,null,{"$f":"N27+O27","v":9752}]
[null,"Labour minute Value CNY incl. OT \n(row 30/31)",null,null,{"$f":"E29/E30","v":0},null,null,{"$f":"H29/H30","v":0.27041837571780147},null,null,{"$f":"K29/K30","v":0.27041837571780147},null,null,{"$f":"N29/N30","v":0.33634126333059883}]
[null,"Labour Minute Value € incl. OT \n劳动力分钟价值包含加班（欧元）",null,null,{"$f":"E31/B5","v":0},null,null,{"$f":"H31/$B$5","v":3.4273558392623762E-2},null,null,{"$f":"K31/$B$5","v":3.4273558392623762E-2},null,null,{"$f":"N31/$B$5","v":4.2628803970925076E-2}]
[null,"% difference between LMV based on actual wage bill and LMVs based on legal minimum wage and target wage.\n基于实际工资，最低工资标准以及目标工资标准的劳动力分钟价值的区别百分比",null,null,null,null,null,{"$f":"IFERROR(((H32-E32)/E32),0)","v":0},null,null,{"$f":"IFERROR(((K32-E32)/E32),0)","v":0},null,null,{"$f":"IFERROR(((N32-E32)/E32),0)","v":0}]