{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Fee Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Fee Calculator","index":0,"n_rows":29,"n_cols":24,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,10],[3,4,4,9],[5,4,5,9]]}
[]
[null,"Amazon Inbound Pickup Service Fee Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shipment zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C8","v":"Local"}]
[null,null,"Enter Billable weight (1-999kg)",null,"FBA Inbound Pickup Serive Fee",null,null,null,null,null,null,null,null,"Check if weight is less than 10Kg",null,null,null,null,"Local","Intra-State","Intra-Region","Intra-Region Metros","Intra-Region National","Remote"]
[null,null,50,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C5<10,\"Yes\",\"No\")","v":"No"},null,null,"Upto 10Kg","Min. Charge",110,132,165,198,242,308]
[null,null,null,null,758.99999999999989,null,null,null,null,null,null,"Local",null,null,null,null,">10Kg","Incremental (per kg)",11,13.2,16.5,19.8,24.2,30.8]
[null,null,"Enter shipment zone",null,null,null,null,null,null,null,null,"Intra-State",null,"Extra weight more than 10Kg"]
[null,null,"Local",null,null,null,null,null,null,null,null,"Intra-Region",null,{"$f":"IF(N5=\"Yes\",0,C5-10)","v":40},null,null,"Base Fees","Min Charge",{"$f":"IF(AND($T$3=S$4,$C$5>0),S$5,0)","v":110},{"$f":"IF(AND($T$3=T$4,$C$5>0),T$5,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Intra-Region Metros",null,null,null,null,null,"Incremental",{"$f":"IF(AND($T$3=S$4,$N$8>0),($N$8*S$6),0)","v":440},{"$f":"IF(AND($T$3=T$4,$N$8>0),($N$8*T$6),0)","v":0},0,0,0,0]
[null,"Steps to calculate fee:",null,null,null,null,null,null,null,null,null,"Intra-Region National"]
[null,null,"Enter Billable weight of the shipment.",null,null,null,null,null,null,null,null,"Remote",null,null,null,null,"Fuel Surcharge",null,{"$f":"S8+0.2*S8","v":132},{"$f":"T8+0.2*T8","v":0},0,0,0,0]
[null,null,"Select a shipment zone from the drop down.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S9+0.2*S9","v":528},0,0,0,0,0]
[null,null,"Click on calculate button, FBA Inbound Pickup Service fee will be displayed basis entered inputs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S11:S12)","v":660},{"$f":"SUM(T11:T12)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount"]
[null,"To calculate Billable weight:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C5>99,C5<=499),0.25,IF(C5>499,0.3,0))","v":0},null,null,"Discount",null,{"$f":"S13-($N$15*S13)","v":660},{"$f":"T13-($N$15*T13)","v":0},0,0,0,0]
[null,null,"Billable weight = maximum(Volumetric weight, Actual weight)"]
[null,null,"For eg:"]
[null,null,"Actual weight = 5kg"]
[null,null,"Volumetric weight = ((Length*Width*Height) in cu cm / 5000) kg   = ((25*50*50)cu cm/5000) kg   = 12.5 kg"]
[null,null,"Billable weight = maximum(12.5,5) = 12.5kg"]
[]
[null,"To identify shipment zone :"]
[null,null,"Source and destination","Amazon Inbound Shipment Zone",null,null,null,null,null,null,null,null,null,null,null,null,"Other tax",null,{"$f":"S15*1.15","v":758.99999999999989},{"$f":"T15*1.15","v":0},0,0,0,0]
[null,null,"Ship from address and ship to address is within the same city, for example within Bangalore. ","Local"]
[null,null,"Ship from address and ship to address has the same state, for example within Karnataka state","Intra-State"]
[null,null,"Ship from address and ship to address is within same region, for example within north region, within south region, within west region etc. ","Intra-region"]
[null,null,"Ship from address and ship to address is from one metro city to other. Note: Metro cities include Bangalore, Delhi, Mumbai, Hyderabad, Chennai, Kolkotta, Pune and Ahmedabad","Metros"]
[null,null,"Ship from address and ship to address is from one metro city to other and both metro cities are in different regions","Inter-region Metros"]
[null,null,"Ship to address is North East, Jammu & Kashmir, Himachal and Uttarkhand","Remote"]