{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Staffing Audit"],"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":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["THT Staffing Audit Calculator - One Operator, Four Machines"]
[]
["CURRENT MANUAL LINE"]
["Parameter","Your Value","Unit","Notes"]
["Number of operators per shift",10,"people","Count 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 range"]
["Working hours per shift",8,"hours","Excluding breaks"]
["Working days per month",26,"days","Standard schedule"]
["Avg labor cost per operator/yr",72000,"RMB/year","Including social insurance"]
["Current defect rate",3,"%","2-5% typical for manual THT"]
[]
["CALCULATED OUTPUTS (Manual)"]
["Metric","Formula","Value","Unit"]
["Placements per hour",{"$f":"B5*B7","v":null},"comps/hr"]
["Placements per shift",{"$f":"B16*B8","v":null},"comps/shift"]
["Placements per day",{"$f":"B17*B6","v":null},"comps/day"]
["Annual labor cost",{"$f":"B5*B9","v":null},"RMB/yr"]
["Defective placements/day",{"$f":"B18*B10/100","v":null},"comps/day"]
[]
[]
[]
[]
[]
["AUTO INSERTION ALTERNATIVE"]
["Parameter","Your Value","Unit","Notes"]
["Number of insertion machines",4,"machines","S4000, S-3010B, S-70LD mix"]
["Average CPH per machine",15000,"comps/hr","13,000-20,000 CPH range"]
["Machine uptime factor",0.92,"ratio","92% typical"]
["Operators needed per shift",1,"people","Team leader / machine tender"]
["Total purchase cost (RMB)",0,"RMB","For payback calculation"]
[]
["CALCULATED OUTPUTS (Auto Insertion)"]
["Metric","Formula","Value","Unit"]
["Auto placements per hour",{"$f":"B27*B28*B29","v":null},"comps/hr"]
["Auto placements per shift",{"$f":"B33*B8","v":null},"comps/shift"]
["Auto placements per day",{"$f":"B34*B6","v":null},"comps/day"]
["Auto annual labor cost",{"$f":"B30*B9","v":null},"RMB/yr"]
[]
["HEADCOUNT SAVING (operators/shift)",{"$f":"B5-B30","v":null},"people"]
["ANNUAL LABOR SAVING (RMB)",{"$f":"B19-B37","v":null}]
["PAYBACK PERIOD (months)",{"$f":"IF(B31>0,B31/(B39/12),\"Enter purchase cost in B31\")","v":null},"months"]