{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Staffing Audit","Manual vs Auto"],"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":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,2],[18,0,18,2],[10,0,10,2]]}
["Axial Insertion Staffing Audit Worksheet"]
[]
["Parameter","Your Value","Notes"]
["Axial components (resistors, diodes) per PCB",40,"Count all axial lead parts"]
["Average daily board volume",2000,"Total across all shifts"]
["Operators at manual axial station (per shift)",3,"Count dedicated axial ONLY"]
["Number of shifts per day",2,"1, 2, or 3"]
["Blended operator cost per hour (USD)",6.5,"Include benefits, housing, turnover"]
["Working days per year",250,"Subtract holidays, shutdown"]
[]
["RESULTS"]
["Daily operator-hours (axial station only)",{"$f":"B5*B6*8","v":null}]
["Annual operator cost (USD)",{"$f":"B8*B9*B7*B10","v":null}]
["Manual CPH per operator (sustained)",300]
["Total manual CPH (all operators)",{"$f":"B5*B14","v":null}]
["Minutes per board (manual)",{"$f":"(B3/B15)*60","v":null}]
["Machine CPH needed to match volume",{"$f":"B8/(B7*8)*B3","v":null}]
[]
["S4000 MACHINE REFERENCE"]
["S4000 rated speed (CPH)",20000]
["Realistic sustained CPH (85% efficiency)",17000]
["Boards per shift (40 axial/board)",4000]
["Annual output per machine (boards)",1000000]
["Operators per machine",0.25]

{"sheet":"Manual vs Auto","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2],[10,0,10,2]]}
["Manual vs Auto Axial Insertion Cost Comparison"]
[]
["Metric","Manual","Auto (1 x S4000)"]
["Sustained CPH",300,17000]
["Operators per shift",3,0.25]
["Annual labor cost (USD)",{"$f":"Staffing!B11","v":null},{"$f":"Staffing!B10*0.25*8*Staffing!B9","v":null}]
["Defect rate","2-5%","<0.5%"]
["Annual defect cost (100k boards)","~$60k-$120k","~$6k-$15k"]
["Payback on machine investment","N/A","12-24 months typical"]
[]
["Southern Machinery | Jason Wu | jasonwu@smthelp.com | +86 13602562576"]