{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Staffing Audit","Summary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Staffing Audit","index":0,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["THT Staffing Audit Calculator"]
[]
["CURRENT MANUAL LINE"]
["Parameter","Your Value","Unit","Notes"]
["Number of operators per shift",10,"people","All THT insertion stations"]
["Number of shifts per day",2,"shifts","1, 2, or 3"]
["Average CPH per operator",500,"comps/hr","300-800 typical"]
["Working hours per shift",8,"hours","Excluding breaks"]
["Avg annual labor cost/operator",72000,"RMB/yr","Incl. social insurance"]
["Current defect rate (%)",3,"%","2-5% typical for manual THT"]
[]
["CALCULATED (Manual)"]
["Metric","Formula","Value","Unit"]
["Placements/hour",{"$f":"B5*B7","v":null},"comps/hr"]
["Placements/shift",{"$f":"B14*B8","v":null},"comps/shift"]
["Placements/day",{"$f":"B15*B6","v":null},"comps/day"]
["Annual labor cost",{"$f":"B5*B9","v":null},"RMB/yr"]
["Defective placements/day",{"$f":"B16*B10/100","v":null},"comps/day"]
[]
["AUTO INSERTION ALTERNATIVE"]
["Parameter","Your Value","Unit","Notes"]
["Number of insertion machines",4,"machines","S4000/S-3010B mix"]
["Average CPH per machine",15000,"comps/hr","13,000-20,000 CPH"]
["Machine uptime factor",0.92,"ratio","92% typical"]
["Operators needed per shift",1,"people","Machine tender"]
["Total purchase cost (RMB)",800000,"RMB","For payback calc"]
[]
["CALCULATED (Auto)"]
["Metric","Formula","Value","Unit"]
["Auto placements/hour",{"$f":"B22*B23*B24","v":null},"comps/hr"]
["Auto placements/shift",{"$f":"B30*B8","v":null},"comps/shift"]
["Auto placements/day",{"$f":"B31*B6","v":null},"comps/day"]
["Auto annual labor cost",{"$f":"B25*B9","v":null},"RMB/yr"]
[]
["HEADCOUNT SAVING (operators/shift)",{"$f":"B5-B25","v":null},"people"]
["ANNUAL LABOR SAVING (RMB)",{"$f":"B17-B33","v":null}]
["PAYBACK PERIOD (months)",{"$f":"IF(B26>0,B26/(B36/12),\"Enter cost in B26\")","v":null},"months"]
[]
["NOTES"]
["1. Yellow cells = your inputs. Green/blue cells = calculated results."]
["2. Actual CPH varies by board design, component mix, and changeover frequency."]
["3. For a free trial on your highest-volume board: jasonwu@smthelp.com"]
["4. Southern Machinery - Shenzhen - www.smthelp.com"]

{"sheet":"Summary","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["THT Auto Insertion - Staffing Summary"]
["Metric","Manual Line","Auto Line"]
["Operators per shift",{"$f":"Staffing Audit!B5","v":null},{"$f":"Staffing Audit!B25","v":null}]
["Shifts per day",{"$f":"Staffing Audit!B6","v":null},{"$f":"Staffing Audit!B6","v":null}]
["Total daily operators",{"$f":"B3*B4","v":null},{"$f":"C3*C4","v":null}]
["Throughput/hr (comps)",{"$f":"Staffing Audit!B14","v":null},{"$f":"Staffing Audit!B30","v":null}]
["Throughput/shift (comps)",{"$f":"Staffing Audit!B15","v":null},{"$f":"Staffing Audit!B31","v":null}]
["Daily output (comps)",{"$f":"Staffing Audit!B16","v":null},{"$f":"Staffing Audit!B32","v":null}]
["Annual labor cost (RMB)",{"$f":"Staffing Audit!B17","v":null},{"$f":"Staffing Audit!B33","v":null}]
["Headcount saving",null,{"$f":"Staffing Audit!B35","v":null}]
["Annual labor saving (RMB)",null,{"$f":"Staffing Audit!B36","v":null}]
["Payback period (months)",null,{"$f":"Staffing Audit!B37","v":null}]