Landed Cost Calculator for Canadian Imports Dashboard   Excel template (XLSX)
$20.00

Landed Cost Calculator for Canadian Imports (Excel template (XLSX)) Preview Image
Landed Cost Calculator for Canadian Imports (Excel template (XLSX)) Preview Image
Landed Cost Calculator for Canadian Imports (Excel template (XLSX)) Preview Image
Flevy is the marketplace for business best practices.
Landed Cost Calculator for Canadian Imports (Excel template (XLSX)) Preview Image
Landed Cost Calculator for Canadian Imports (Excel template (XLSX)) Preview Image
Landed Cost Calculator for Canadian Imports (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen.

Landed Cost Calculator for Canadian Imports Dashboard – Excel XLSX

Excel (XLSX) French

$20.00

Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

  1. Shows the true landed cost per product, including duties, freight, broker fees and GST.
  2. Lets you choose how shipment costs are allocated: by value, volume, weight or quantity.
  3. Suggests a selling price for each product based on your target gross margin.

LOGISTICS EXCEL DESCRIPTION

Landed Cost Calculator for Canadian Imports is an Excel template (XLSX) available for immediate download upon purchase.

This French-language Excel template calculates the true landed cost of goods imported into Canada. Enter your shipment costs (international freight, insurance, customs broker, local delivery) and your product lines (quantity, supplier unit price, duty rate, weight and volume). The model allocates shipment costs to each product by value, volume, weight or quantity, computes customs duties and the 5% GST on imports separately, and suggests a selling price based on your target gross margin. All labels and instructions are in French, which makes it ideal for Quebec and French-speaking importers.

VERSION FRANÇAISE

Calculateur de coût d'importation pour le Canada, en français : connaissez le vrai coût de vos produits importés avant de fixer vos prix.

Le prix du fournisseur n'est qu'une partie de la facture. Transport, assurance, courtier, droits de douane et livraison locale peuvent ajouter 30 %, 50 %, parfois plus. Ce modèle Excel calcule pour vous le coût au débarqué de chaque produit et vous suggère un prix de vente selon la marge que vous visez.

CE QUE FAIT LE CALCULATEUR
•  Coût unitaire au débarqué pour chaque produit (jusqu'à 30 produits par envoi).
•  Droits de douane par ligne, selon votre taux et le code SH.
•  TPS à l'importation (5 %) calculée à part, puisqu'elle est généralement récupérable.
•  Répartition des frais d'expédition au choix : par valeur, volume (m³), poids (kg) ou quantité.
•  Prix de vente suggéré selon la marge brute visée.
•  Résumé de l'envoi : valeur des produits, droits, frais répartis, sortie de fonds totale et « coûts cachés » en % du prix fournisseur.
•  Conversion automatique de la devise du fournisseur (USD, CNY, EUR…) en dollars canadiens.

POUR QUI ?
Petites entreprises, commerçants en ligne et acheteurs qui importent de Chine, d'Asie, des États-Unis ou d'Europe vers le Canada.

CE QUE VOUS RECEVEZ
1 fichier Excel, 3 onglets : Mode d'emploi, Paramètres, Calculateur. Des exemples préremplis vous montrent le fonctionnement en 2 minutes; effacez-les et entrez vos chiffres. Cellules jaunes = à remplir, tout le reste se calcule.

FORMAT ET COMPATIBILITÉ
•  Fichier Excel (.xlsx), sans macro ni code caché.
•  Fonctionne dans Microsoft Excel 2010 ou plus récent (Windows et Mac).
•  Fichier non verrouillé : vous pouvez l'adapter à votre entreprise.

Outil d'estimation : il ne remplace pas l'avis d'un courtier en douane ou d'un comptable.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Logistics, Tariff Management Excel: Landed Cost Calculator for Canadian Imports Excel (XLSX) Spreadsheet, gx76612


$20.00

Add to Cart
  

ABOUT THE AUTHOR

Author: gx76612
Additional documents from author: 2

Ask the Author a Question

You must be logged in to contact the author.

Click here to log in Click here register

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided business templates to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab





Read Customer Testimonials

 
"[Flevy] produces some great work that has been/continues to be of immense help not only to myself, but as I seek to provide professional services to my clients, it gives me a large "tool box" of resources that are critical to provide them with the quality of service and outcomes they are expecting."

– Royston Knowles, Executive with 50+ Years of Board Level Experience
 
"Last Sunday morning, I was diligently working on an important presentation for a client and found myself in need of additional content and suitable templates for various types of graphics. Flevy.com proved to be a treasure trove for both content and design at a reasonable price, considering the time I "

– M. E., Chief Commercial Officer, International Logistics Service Provider
 
"My FlevyPro subscription provides me with the most popular frameworks and decks in demand in today’s market. They not only augment my existing consulting and coaching offerings and delivery, but also keep me abreast of the latest trends, inspire new products and service offerings for my practice, and educate me "

– Bill Branson, Founder at Strategic Business Architects
 
"FlevyPro provides business frameworks from many of the global giants in management consulting that allow you to provide best in class solutions for your clients."

– David Harris, Managing Director at Futures Strategy
 
"I have used FlevyPro for several business applications. It is a great complement to working with expensive consultants. The quality and effectiveness of the tools are of the highest standards."

– Moritz Bernhoerster, Global Sourcing Director at Fortune 500
 
"Flevy is now a part of my business routine. I visit Flevy at least 3 times each month.

Flevy has become my preferred learning source, because what it provides is practical, current, and useful in this era where the business world is being rewritten.

In today's environment where there are so "

– Omar Hernán Montes Parra, CEO at Quantum SFE
 
"As a young consulting firm, requests for input from clients vary and it's sometimes impossible to provide expert solutions across a broad spectrum of requirements. That was before I discovered Flevy.com.

Through subscription to this invaluable site of a plethora of topics that are key and crucial to consulting, I "

– Nishi Singh, Strategist and MD at NSP Consultants
 
"I have found Flevy to be an amazing resource and library of useful presentations for lean sigma, change management and so many other topics. This has reduced the time I need to spend on preparing for my performance consultation. The library is easily accessible and updates are regularly provided. A wealth of great information."

– Cynthia Howard RN, PhD, Executive Coach at Ei Leadership



Customers Also Like These Documents

Explore Templates on Related Management Topics



Your Recently Viewed Documents
Receive our FREE presentation on Operational Excellence

This 50-slide presentation provides a high-level introduction to the 4 Building Blocks of Operational Excellence. Achieving OpEx requires the implementation of a Business Execution System that integrates these 4 building blocks.