# SAP B1 Landed Cost Allocation Calculator > Source: https://netray.co/tools/sap-b1-landed-cost-allocation-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Spread shipment charges across the goods by value share to see landed cost per unit and the uplift over invoice price before you post a landed cost document. ## Category sap ## Erp SAP Business One ## Industry Discrete Manufacturing ## Audience - Buyer - Cost accountant - Import coordinator ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Invoice value of this item line **Key:** item_value **Type:** number **Default:** 24000 **Min:** 0 **Step:** 100 **Unit:** $ #### Invoice value of whole shipment **Key:** total_value **Type:** number **Default:** 80000 **Min:** 0 **Step:** 100 **Unit:** $ #### Quantity of this item **Key:** qty **Type:** number **Default:** 1200 **Min:** 1 **Step:** 10 **Unit:** units #### Freight for shipment **Key:** freight **Type:** number **Default:** 5200 **Min:** 0 **Step:** 50 **Unit:** $ #### Insurance **Key:** insurance **Type:** number **Default:** 400 **Min:** 0 **Step:** 10 **Unit:** $ #### Duty rate on this item **Key:** duty_pct **Type:** slider **Default:** 6.5 **Min:** 0 **Max:** 40 **Step:** 0.5 **Unit:** % #### Brokerage, port and other charges **Key:** other **Type:** number **Default:** 950 **Min:** 0 **Step:** 10 **Unit:** $ **Outputs:** #### Value share of shipment **Key:** share **Expr:** if(gt(total_value,0), item_value / total_value * 100, 0) **Format:** percent #### Freight allocated **Key:** a_freight **Expr:** freight * share / 100 **Format:** currency #### Insurance allocated **Key:** a_ins **Expr:** insurance * share / 100 **Format:** currency #### Other charges allocated **Key:** a_other **Expr:** other * share / 100 **Format:** currency #### Duty on this item **Key:** duty **Expr:** item_value * duty_pct / 100 **Format:** currency **Description:** Applied to invoice value here. Customs value may include freight and insurance in your jurisdiction. #### Total landed cost of line **Key:** landed **Expr:** item_value + a_freight + a_ins + a_other + duty **Format:** currency **Primary:** true #### Landed cost per unit **Key:** per_unit **Expr:** landed / qty **Format:** currency **Primary:** true #### Uplift over invoice price **Key:** uplift **Expr:** if(gt(item_value,0), (landed - item_value) / item_value * 100, 0) **Format:** percent **Chart:** #### Landed cost per unit versus duty rate **Type:** line **X:** duty_pct **From:** 0 **To:** 40 **Steps:** 20 **Series:** - per_unit **Disclaimer:** Duty bases differ by country. Confirm customs valuation rules with your broker. This is an estimate for costing, not a customs declaration. ## Content **Intro:** Invoice price is rarely what an imported part costs you. Freight, insurance, duty and brokerage need to land on the right items before margins and inventory values mean anything. This calculator shows the arithmetic behind a landed cost allocation. **Sections:** #### How to use it **Body:** Enter the invoice value of the line you care about and of the whole shipment. Add freight, insurance and other charges at shipment level, and the duty rate that applies to that tariff line. The tool allocates shared charges by value share and adds line-specific duty to give a landed cost per unit. #### Allocation logic **Body:** Shared charges are split by value share: line value divided by shipment value. SAP Business One's landed cost document lets you choose other allocation criteria for each cost, such as quantity, weight, volume or equal split. Value-based allocation is a reasonable default for freight on mixed goods, while weight suits heavy bulky items. Compare methods by changing the shares. **Bullets:** - Value: simple, favours cheap bulky items - Weight or volume: tracks real freight drivers - Quantity: fine for identical parts #### Reading the result **Body:** The uplift percentage tells you how much to add to supplier price when quoting or setting standard cost. Uplift above 15 to 20 percent on low-value components usually means freight is eating your margin, and ordering larger, consolidated shipments may pay for itself. #### Common mistakes **Body:** Charging duty on invoice value when customs value includes freight, allocating by quantity across items with very different prices, ignoring brokerage fees, and posting landed cost after items were already sold, which pushes the difference to cost of goods sold instead of inventory. **Cta:** If imports run through SAP Business One and you want landed cost reviewed or automated, Netray can look at your setup. The tool does not need it. **Faq:** #### Does SAP Business One support landed costs? **Answer:** Yes. A landed cost document lets you attach additional costs to goods receipt PO or A/P invoice lines and choose how each cost is allocated. Check your version for supported criteria and posting accounts. #### Should duty be calculated on freight too? **Answer:** In many countries customs value includes freight and insurance up to the border. In others it does not. Ask your broker and adjust the item value you enter if needed. #### Why allocate by value share? **Answer:** It is a neutral default when you lack weights or volumes. It spreads costs in proportion to what each item is worth, but it can overcharge expensive light items and undercharge cheap heavy ones. #### What happens if stock was already sold? **Answer:** Landed cost posted late cannot fully reach the inventory value for units already shipped, so part of the cost lands in cost of goods sold. Post landed costs promptly after receipt. ## Search terms sap business one landed costs, sap b1 landed cost allocation, landed cost calculator, import duty freight allocation, landed cost per unit, sap b1 goods receipt po landed cost, how to calculate landed cost, customs duty calculator for imports --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json