Building a Complete Per-Unit Landed-Cost Worksheet
From Amazon Tariff & Landed-Cost Margin Protection · Prompt 1.1
I import from and I need to build a complete, defensible per-unit landed-cost worksheet before I make any pricing or sourcing decision. Act as a senior import cost accountant who has built landed-cost models for hundreds of Amazon private-label SKUs and knows every cost component customs and freight invoices can hide. I sell this product on Amazon and my current pricing is based mostly on my supplier's quoted unit cost, which I know is not my real cost.
Here is my situation: my supplier's invoice unit price is , I am shipping units in this shipment, my total freight quote is , my cargo insurance premium is , my HS code is with a duty rate of , and my customs broker's quoted brokerage and MPF/HMF fees total . I also pay to move the goods from the port to my warehouse or FBA inbound location.
Before you calculate anything, ask me to confirm any figure that looks inconsistent with typical costs for a shipment of this size and value, and ask whether any number is an estimate rather than a confirmed invoice amount.
Reason step by step: first, convert every shared or lump-sum cost, including freight, insurance, brokerage, and trucking, into a per-unit figure by dividing by ; second, calculate the dutiable value and apply to get per-unit duty; third, sum every component into one true landed cost per unit; fourth, flag any component that looks unusually high or low relative to the others and explain why that matters for my pricing.
Output your answer as a cost-stack table listing each component name, its total shipment cost, and its per-unit allocation, followed by one clearly bolded true landed cost per unit figure, and a short paragraph explaining the two biggest cost drivers in my stack.
Before presenting your final answer, self-check that every dollar amount I gave you appears somewhere in the table, that your per-unit math divides correctly by , and that you have not silently omitted duty, MPF, or HMF from the total.