{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["CAPITAL JUSTIFICATION"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"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","formulas":"cached_only"}

{"sheet":"CAPITAL JUSTIFICATION","index":0,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,0,1,7],[11,5,11,7],[12,5,12,7],[13,5,13,7],[3,1,3,4],[4,5,5,7],[45,0,45,7],[7,5,7,6],[20,0,20,7],[30,0,30,7],[35,0,35,7],[40,0,40,7],[14,0,14,1]],"flags":["formulas_cached_only"]}
["CAPITAL EXPENDITURE JUSTIFICATION ( HYROBOT TOPIV SPRUE / PARTS PICKING ROBOT )"]
["YOU WILL SAVE AT LEAST $5,000 / YEAR FOR ONE MOLDING MACHINE"]
[]
["Robot Model:","  TOPIV SPRUE PICK / PARTS PICKING ROBOT"]
["Robot Price:",5000,null,"Reason:",null,"DO THE MATH !"]
[null,"About :  $ 3,000 ~ 5,000",null,"x","Safety"]
["Capitalized Cost:",5000,null,"x","Cost Improvement"]
["Annual ROI:",11868.88888888889,null,null,"Capital Replacement"]
["Rate Of Return:",2.373777777777778,null,"x","Quality Control"]
["Cash Payback (Yrs):",0.42126942520127314,null,"x","New Technology"]
[]
["Total Production Q'ty ","Average Cavity","Machine",null,"IMM","HYROBOTICS CORP. ( www.hyrobots.com )"]
["(PCS./ Month)","PCS / Mold","EA",null,"RATE","5988 Mid River Mall Dr."]
[20000,2,1,null,50,"St.Louis MO 63304, www.hyrobot.com"]
["All Mold Operation Included"]
["1. Increased Capacity (Average Cycle Time Reduction)",{"$nulls":6},"Customer Data"]
["Operation with Labor or Drop ","Proposed Operation with HYRobot","%",null,"IMM","Run Hour (1)","%","Additional Available"]
["(sec./cycle)","(sec./cycle)","Change",null,"Hourly Rate","Hrs/Yr","Utilization","Capacity ($'s & Hrs/Yr)"]
[15,13,0.1333333333333333,null,50,433.33333333333337,1,2888.8888888888887]
[null,"Save 2 Seconds / Every Cycle",{"$nulls":5},57.77777777777777]
["Increased Capacity is the additional IMM time that will become available when the current production isapplied to the proposed cycle time.  The addition IMM time is represented in dollars ($) and in hours."]
["2. Remain Time due to Cycle Time Reduction (Available Hrs/Yr (1))"]
["Current Running Hr / Year","Improved Running Hr / Year","SAVE TIME"]
["Hr","Hr","Hr / Year"]
[500,433.33333333333337,66.66666666666663]
["3. Consistency / Quality (Average Part Cost/Yield Improvement )"]
["Current Operation","Proposed Operation","%",null,"Current","Parts/",null,"Value Based On"]
["Yield (%)","Yield (%)","Change",null,"Cost/1k Parts","Cycle",null,"Current Rates & Utilization"]
[0.75,0.95,0.19999999999999996,null,100,1,null,2080]
[{"$nulls":6},"Parts",20800]
["Average Part Cost/Yield Improvement is the value of the additional parts realized with increased yelds.  This value is based on the current production rate/cost and the Proposed Yield, not including increases in production due to improved cycle times."]
["4. Labor Savings"]
["Current Number of","Proposed Number of",null,null,"Burden Rate/",null,null,"Savings per Year"]
["Operators","Operators","Change",null,"Hour",null,null,"Based on % Utilization"]
[1,0.2,-0.8,null,15,null,null,5200.000000000001]
["Labor Savings is based on the reduction of burdened direct labor associated with operating the IMM for the specific application sighted.  The savings is calculated based on the yearly total hours of operation de-rated by the % utilization."]
["5. Tax Benefit Due To Depreciation & Interest"]
["Depreciation",null,"Tax",null,"Robot",null,null,"Annual "]
["Period (Yrs.)","Interest Rate","Rate",null,"Price",null,null,"Tax Benefit"]
[2,0.06,0.25,null,5000,null,null,700]
["Tax Benefit is based on the yearly depreciation of the capitol equipment and any interest incurred as a result of financing the purchase."]
["6.  Mold Repair Savings"]
["Current Cost of","Proposed Cost of",{"$nulls":5},"Annual Savings From"]
["Repairs","Repairs","Change",{"$nulls":4},"Tool Repair"]
[1000,0,1000,{"$nulls":4},1000]
["Mold Repair Savings is based upon part sensing capabilities that the robot will possess that will prevent clamp closing on parts failing to eject "]