Building a Landed-Cost Worksheet for Materials Imports

A useful landed-cost worksheet separates known prices from estimates and unresolved charges. It helps a buyer compare options without assuming that a product quote includes everything needed to receive and install the goods.

Build the cost categories

Start with product value, agreed sourcing fees, samples, tooling and export packing. Add origin transport, inspection, consolidation, international freight, insurance and destination services where applicable. Include import duties and taxes only after obtaining product- and destination-specific advice from an appropriate source or broker.

Keep the assumptions visible

Record the currency, exchange-rate assumption, quote date and validity for each line. Identify the delivery term and named location. Avoid counting a charge twice when it is already included in a supplier's quoted scope.

Compare scenarios

• Separate fixed charges from costs that change with quantity.
• Model alternative shipment sizes or delivery arrangements.
• Mark uncertain figures instead of presenting them as final.
• Keep installation and local storage visible even if excluded from landed cost.

Use a contingency for uncertainty without disguising missing information. Before committing, ask the relevant service provider to confirm the major unresolved items. The worksheet is a purchasing aid, not a customs assessment, and should be updated when the actual products, packing and route are finalized.