{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Payback","Cost Calculator"],"not_rendered":{"charts":0,"images":2,"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":"Payback","index":0,"n_rows":66,"n_cols":8,"rows_kept":66,"cut":false,"hidden":false,"merged":[[2,1,2,8],[48,1,48,3],[31,1,31,3],[37,1,37,3],[64,2,64,5],[65,2,65,5],[43,1,43,3],[3,1,3,3],[14,1,14,3],[52,1,52,3],[27,1,27,3]]}
[]
[]
[null,"Return on Investment Calculation for Tin top cover placement solution"]
[null,"Production Data for 15 Kg Oil Tin"]
[{"$nulls":7},"Comments"]
[null,null,"Productivity",17,"Tin / Min ",null,null,"Given by Customer"]
[null,null,"Tins per Hour",{"$f":"D6*60","v":1020},"Tins","T1",null,"Productivity based on given data"]
[null,null,"Hours per day",16,"Hours","H1"]
[null,null,"Tins per day",{"$f":"D8*D7","v":16320},"Tins","T2 = T1 x H1"]
[null,null,"Days per annum",300,"Days","D1"]
[null,null,"Tins per annum",{"$f":"D9*D10","v":4896000},"Tins","T3 = T2 x D1"]
[null,null,"Tonnage per day",{"$f":"D9*15/1000","v":244.8},"tpd","W1 = T2 x 15"]
[null,null,"Tonnage per Annum",{"$f":"D12*D10","v":73440},"tpa","W2 =  W1 x D1"]
[]
[null,"Strapping Cost"]
[null,null,"Cost of Strapping per Tin",{"$f":"'Cost Calculator'!D7","v":1.5959999999999999},"INR","C1",null,"Refer Cost Calculator Sheet'!D11"]
[null,null,"Cost of strapping per annum",{"$f":"(D16*D11)/100000","v":78.140159999999995},"L INR","C1A"]
{"$rows_empty":7}
[null,null,"Cost of labour per annum",{"$f":"'Cost Calculator'!L8","v":6},"L INR","C2A",null,"Refer Cost Calculator Sheet'!L12"]
[null,null,"Total cost per annum",{"$f":"(D25+D17)","v":84.140159999999995},"L INR","C3A"]
[]
[null,"Hot Glue Cost"]
[null,null,"Cost of glue per Tin",{"$f":"'Cost Calculator'!I12","v":0.27},null,"C3",null,"Refere Cost Calculator Sheet"]
[null,null,"Cost of  glue per annum",{"$f":"(D29*D11)/100000","v":13.219200000000001},"L INR","C3A"]
[]
[null,"Power Cost"]
[null,null,"Power (kw) of machine",1.5,"kW"]
[null,null,"Units consumed per day ",{"$f":"D33*D8","v":24},"kWh"]
[null,null,"Cost per unit ",6.5,"Rs."]
[null,null,"Annual Power Cost ",{"$f":"D35*D34*D10/100000","v":0.46800000000000003},"L INR","PC"]
[]
[null,"Compressed Air Cost "]
[null,null,"Power (kw) of compressor ",2,"kW"]
[null,null,"Units consumed per day ",{"$f":"D39*D8","v":32},"kWh"]
[null,null,"Cost per unit ",6.5,"Rs."]
[null,null,"Annual Power Cost ",{"$f":"D41*D40*D10/100000","v":0.624},"L INR ","CC"]
[]
[null,"Maintenance Cost "]
[null,null,"Consumables ",0.4,"L INR","rubber parts"]
[null,null,"Repair ",0.75,"L INR","assumed "]
[null,null,null,{"$f":"D46+D45","v":1.1499999999999999},"L INR ","MC"]
[]
[null,"Cost saving "]
[null,null,"Material cost saving per yr",{"$f":"D17-D30-D36-D42-D47","v":62.678959999999989},"L INR","B1=C3A - C2A - PC - CC - MC"]
[null,null,"Labour Saving per year ",{"$f":"D25-0","v":6},"L INR","B2=S2-0"]
[null,null,"Total Saving per year ",{"$f":"D50+D51","v":68.678959999999989},"L INR","B3=B1+B2"]
[null,"Investment Data "]
[null,null,"One time investment for MOC MS",null,"L INR","Inv1",null,"Please connect for a quotation."]
[null,"B>","Man power for operating forklifts",null,"persons/ shift","N1"]
[null,null,null,3,"shifts/ day","N2"]
[null,null,null,{"$f":"D56*D55","v":0},"people required","N3 = N1 x N2"]
[]
[null,null,"Salary p.a.",1,null,"S1"]
[]
[null,null,"Yearly man power cost",{"$f":"D59*D57","v":0},null,"S2 = S1 x N3"]
[null,null,"Payback Period",{"$f":"D54/D52","v":0},"Year","PP = Inv1/ B3"]
[]
[null,null,"User has to input this data based on the case in hand "]
[null,null,"Machine specific data "]
[null,null,"Data from Another sheet "]

{"sheet":"Cost Calculator","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,15,6],[13,2,13,6],[14,2,14,6],[11,5,11,7],[3,10,3,11],[2,1,2,11],[4,1,4,2],[5,1,5,2],[6,1,6,2],[3,1,3,3]]}
[]
[]
[null,"Costing Details"]
[null,"Strap Cost",null,null,null,"Braid Glue ",null,"Cold Glue ","(NA)",null,"Labour Cost"]
[null,"Strap per Tin (m)",null,2.2799999999999998,null,"gms/ m",null,"gms/ m",0,null,"No. of labour Saved",2]
[null,"Strap Rate (Rs./m) ",null,0.7,null,"Price per kg",300,"Price per kg",202,null,"Rate (Rs/shift)",500]
[null,"Strap cost per Tin (Rs.)",null,{"$f":"D5*D6","v":1.5959999999999999},null,"Length of each side",null,"Length of each side",0.23,null,"Shifts per day",2]
[{"$nulls":5},"No of sides",null,"No of sides",4,null,"Labour per annum (L INR)",{"$f":"(L5*L6*L7*Payback!D10)/100000","v":6}]
[{"$nulls":5},"Grammage per tin ",0.9,null,{"$f":"I8*I7*I5","v":0}]
[{"$nulls":5},"Cost of Hot Glue per Tin",{"$f":"G9/1000*G6","v":0.27},"Cost of Cold Glue per Tin",{"$f":"I9/1000*I6","v":0}]
[]
[{"$nulls":5},"Total Cost of Glue (Hot + Cold)  per tin (INR) ",null,null,{"$f":"I10+G10","v":0.27}]
[]
[null,null,"Data to be  input by customer "]
[null,null,"Data used in Sheet 'Payback'"]
[null,null,"Machine Data and calculation. Do no disturb."]