Per Carton CBM calculation on Excel

-
On Excel sheet have to multiply as follows:

Theory:
Carton width X Carton Height X Carton length X 0.0000164 X Carton QTY (per Carton)


To be noted ►► 

The Formula 0.0000164 is from


EXAMPLE with the Explanation :


Eg: IF Length =18"(Inch), Width =12"(Inch), Height =4"(Inch)  &  Total Ctn Qty =43 Ctns   what is total CBM?

We know that 1"(Inch) = 2.54 CM & 1 Meter = 100 CM


Then  let make the Inches to CM as :
Length =18"(Inch), Width =12"(Inch), Height =4"(Inch)    &    43 CTN

Length =18 X 2.54 , Width =12 X 2.54 , Height =4 X 2.54   X    43 CTN  / 100 CM X 100 CM X 100CM

Result=  Total CBM
WHY  USING THE Formula 0.0000164 is from EXCEL WORK SHEET

 If We know that 1"(Inch) = 2.54 CM & 1 Meter = 100 CM

Than make in CM from inches :  
       L - 2.54    X    W- 2.54    X  H - 2.54 
=     ------------------------------------------------
         100        X       100        X      100
              2.54 X 2.54 X 2.54  
=     ---------------------------------------
             1000000

 = 0.0000164 (  So Formula is using 0.0000164 is on EXCEL WORK SHEET )


 


Comments

Post a Comment

Popular posts from this blog

LC Payment methods: BY ACCEPTANCE; BY NEGOTIATION; BY DEF PAYMENT; BY MIXED PAYMENT. terms in letter of credit

-
Knowledge Statement  Knowledge of Types of Payment: Sight, Deferred, Acceptance Goal  The goal of this material is to introduce you to the types of payment opportunities for international business transactions and the ways each affects the timely payment for the sale of goods and/or services, including an understanding of how and when each type of payment is utilized with the methods of payment available for international transactions. Learning Objectives  You will be able to • identify the types of payments available for international transactions. • identify how each type of payment can be used. • identify how each type of payment affects the collections of funds. Introduction  Documentary credits and/or letters of credit are banking tools used to alleviate various levels of risk related to international business transactions. In addition to the many forms of credit including but not limited to irrevocable, confirmed, transfera
Read more

LC CLAUSES DETAILS meaning

-
http://www.creditguru.com/index.php/credit-management/international-trade-credit-management/articles-letter-of-credit/81-what-is-a-letter-of-credit MT 700 Issue of a Documentary Credit Status Tag Field Name M 27 Sequence of Total M 40A Form of Documentary Credit M 20 Documentary Credit Number O 23 Reference to Pre-Advice O 31C Date of Issue M 40E Applicable Rules M 31D Date and Place of Expiry O 51a Applicant Bank M 50 Applicant M 59 Beneficiary M 32B Currency Code, Amount O 39A Percentage Credit Amount Tolerance O 39B Maximum Credit Amount O 39C Additional Amounts Covered M 41a Available With ... By ... O 42C Drafts at ... O 42a Drawee O 42
Read more

How can calculate Total Tax Incidence for Bangladesh Customs

-
.       How can calculate Total Tax Incidence (TTl)? If importing invoice value is $ 38,780.82. Calculate TTI under Terms FOB,CIF/CFR. When, Exchange rate Tk 79.47=1$ AV= Assess Value=? CD = Customs Duty = 25% RD =Regulatory Duty = 3% SD =Supplementary Duty = 20% VAT = Value Added Tax =15% AIT= Advance Income Tax = 5% ATV = Advance Trade VAT = 4% FOB/ CFR : AV= Inv. Value +Freight+Insurance+Landing Charges CIF/ : AV= Inv. Value + Landing Charges Now, C alculateAssess Valueunder CFR: Assess Value: Invoice Value                          $ 38,780.82 (+)   Insu. 1%                            $387.81                                                   $ 39,168.53 (+) Landing Charge   1%          $ 391.69 Assess Value:                          $ 39,560.21 Convert TK 79.47/1$               Tk 31,43,714.59 (1 is adjusted) CD       = (AV X CD %)         = ($31,43,714.59 X 25%)        = TK 7,85,928.65 RD       = (AV X RD% )          =
Read more