Excel Consulting Services in Alhambra, CA

Landed cost has to reach the item, not the overhead

The first and most consequential build is a landed cost that reaches the individual item. That means allocating the freight invoice, the duty assessment, the handling charges and the currency difference across the goods in that shipment rather than letting them settle into overheads. Allocation needs a basis — by value, by weight, by volume or by unit, depending on what drives each charge — and choosing those bases sensibly is most of the work. Once it is done, the business has a real cost per item for the first time, and the usual discovery is that margins are thinner than reported and unevenly so, with the heaviest and bulkiest lines carrying far more cost than anybody had attributed to them. That is the core piece of Excel consulting work here.

Currency is an assumption with a date on it

Second, the exchange rate needs to be an explicit, dated assumption rather than an arithmetic afterthought. An order committed at one rate and settled weeks later at another has a cost that was never decided, and treating that difference as a financial curiosity at year end misses the point: it belongs in the landed cost of the goods it was spent on. Holding the rate used for each order, alongside the rate at settlement, lets the business see its own exposure historically and model it forward. Nothing here is advice on hedging — that belongs with your bank or your advisers; what the spreadsheet can do is stop the exposure being invisible until it has already happened.

Order size and container economics decide the unit cost

Third, order size and container economics drive the unit cost more than most buyers realize. Freight per unit falls as a container fills and rises sharply on a part load, duty thresholds and minimum charges create steps rather than slopes, and a supplier's price break may or may not survive the freight implications of taking it. Modeled properly, the question 'should we order more' has a numerical answer that accounts for all of those at once, including the cost of holding the extra stock. Modeled badly or not at all, it gets answered by the price break alone, which is the one factor the supplier controls. This is straightforward financial modeling with an immediate effect on purchasing.

Cash leaves on the supplier's calendar, not yours

Fourth, the cash timing deserves its own view because it is where importing businesses most often come unstuck. A deposit now, a balance on shipment, goods arriving weeks later and selling over months afterward produces a cash profile with a deep trough in it, and the trough is in a different place for every order. Laid out as a weekly cash view with each order's payment schedule on it, the business can see which weeks are tight before committing to the next order rather than afterward. That is the single most useful report for a business that holds stock and buys abroad.

Margin by line, once the real cost is known

Fifth, once landed cost is real, margin by line finally means something, and that is usually where the decisions are. With freight and duty attached to the goods, some lines turn out to be carrying the business and others to be close to break-even once the true cost of getting them here is counted. Those are decisions about what to stock, what to drop and what to reprice, and none of them can be made from a margin figure built on invoice price alone. Reporting it is a short piece of Excel reporting once the structure underneath is right.

This is a structure job rather than a purchase

None of this needs software bought. The supplier invoices, the freight and duty documents, the bank records and the sales history all exist; the problem is that three of those four never meet the fourth. Getting them onto one structure keyed to the shipment and the item is days of work, and an hour of Excel expert help will usually establish how much of it you need.