Before You Roll Sage X3 Standard Costs: Validating Material Costs, Landed Costs, and Calculation Quantities

How the update usually runs

Depending on volume and how costs are maintained, standard costs are typically updated in one of two ways:

• Calculated in Sage X3 using the standard cost calculation function, which rolls material, labor, machine, and overhead costs up through the bill of material and routing.
• Imported from a prepared file, which is common when a large number of products are updated at once or when costs are prepared outside the system.

Either way, the result is only as reliable as the data behind it. An import moves the validation work earlier, into the file preparation. A calculation moves it into the master data the calculation reads. Neither removes the need to check.

Validate material costs

For purchased components, the material cost is the foundation of every standard above it. A small error on a high-volume component can affect hundreds of finished products.

Before the update, review:

• The source of each material cost. Know whether the cost comes from a price list, the last purchase price, an average, or a manually entered value, and whether that source is still current.
• Stale prices. Costs that have not changed in a long time, or that are based on a purchase made years ago, may no longer reflect what the business pays.
• Outliers. A single unusual purchase, such as an emergency buy, a small trial order, or a one-off discount, can distort a cost based on recent purchases.
• Units of measure. Confirm that the purchase unit, stock unit, and conversion factor are correct. A wrong conversion can make a component appear many times more or less expensive than it is.
• Currency. For components purchased in foreign currency, confirm which exchange rate the cost is based on and whether it reflects the rate the business expects to use for the year.
• Zero or missing costs. A component with no cost will roll up as zero and understate every product that uses it.

Decide how landed costs are included

Landed costs, such as freight, duty, brokerage, and handling, are one of the most common sources of ongoing purchase price variances. If the standard reflects only the supplier price, and the business actually pays freight and duty on every receipt, the difference will appear as a variance every month.

Before the update, make a deliberate decision:

• Include landed costs in standard when they are significant, predictable, and part of the true cost of the item. Use a realistic rate or amount per unit, based on recent actual costs, by supplier, origin, or product group where that makes a difference.
• Exclude them when they are small or highly variable, and agree how the resulting variances will be reported and reviewed.

Whichever approach you choose, document it and apply it consistently. The most difficult situation to explain is one where some products include landed costs and others do not, with no clear rule.

Check the calculation quantity

The calculation quantity is the quantity the standard cost calculation assumes when spreading fixed costs, such as setup time, across units. It has a direct effect on the cost per unit:

• If the calculation quantity is too small, setup and other fixed costs are spread over too few units, and the standard is overstated.
• If it is too large, fixed costs are spread too thinly, and the standard is understated.

Compare new standards to current standards before you commit

Running the calculation or preparing the import is only half of the update. The other half is reviewing the result before it becomes the standard.

Compare the proposed standard to the current standard for every product, and focus attention on:

• The largest percentage changes, in both directions.
• The largest value changes, taking into account volume and inventory on hand.
• Products whose cost moved for an unexpected reason, for example a finished product that increased because one component's unit of measure changed.
• The revaluation impact. For products valued at standard, changing the standard revalues inventory on hand. Estimate that impact before the update so Finance knows what to expect.

Agree on thresholds that require explanation, for example any product that changes by more than a set percentage, and have the explanations reviewed by both Finance and Operations before the new standards are applied.

Why product-by-product review does not work

Reviewing standard costs one product at a time in Sage X3 is slow, and it makes patterns hard to see. A unit of measure error on one component, or an outdated calculation quantity on a family of products, is easier to find when the data is viewed together.

In practice, a reliable update is supported by custom queries or reports that bring the relevant information into one view, so the team can make decisions rather than search for data. A useful review report typically shows, for each product and site:

• Current standard and proposed standard, with the change in value and percentage
• Material, labor, machine, and overhead components of each
• The landed cost amount or rate included, if any
• The calculation quantity, alongside a typical production quantity
• The most recent actual purchase price for purchased components
• Inventory on hand and the estimated revaluation impact

The details matter. A review is only as useful as the data in it, so the report itself should be checked against a sample of products before it is relied on.

After the update

The first month after a standard cost update is the best time to confirm it worked. Review purchase price variances and production variances by product and component. Large or unexpected variances in that first month usually point directly to an input that was not right: a material cost, a landed cost assumption, or a calculation quantity.

When to bring in help

Outside help is usually worthwhile when the business has never had a structured standard cost review, when variances have been unexplained for several periods, when the costing method is being changed, or when a large number of products need to be updated at once. In those situations, the work involves reviewing master data, cost assumptions, and reporting together, and the review queries are often the first thing to build.

Standard cost update questions