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

Shipping Terms of Sale (Export & Import)

-
Shipping Terms of Sale (Export & Import) In any sales agreement, it is important that there is a common understanding of the delivery terms since confusion over their meaning can result in a lost sale or a loss on a sale. The terms in international business transactions often sound similar to those used in domestic business, but they frequently have very different meanings. For this reason, the exporter must know the terms before preparing a quotation or a pro forma invoice. A complete list of important terms (including many new terms and abbreviations)and their definitions is provided in Incoterms 1990 . This booklet is issued by ICC Publishing Corporation, Inc., 156 Fifth Avenue, Suite 820, New York, NY 10010; telephone 212-206-1150. The following are a few of the more frequently used terms in international trade: CIF (cost, insurance, freight) to a named overseas port where the seller quotes a price for the goods (including insurance), all transportation, and
Read more