Lot cost to unit cost: 3 checks before a bid

Key takeaways

• Step 1 checks what the lot cost includes.
• Step 2 checks the divisor, which is the number of finished items.
• Step 3 checks the arithmetic and the result against the quantity you are actually bidding.

Estimators often receive a cost for a whole lot. It might come from a production plan, a shop's job cost report, a supplier's batch quote, or a costing system that tracks a run as one order. The bid, though, asks for a price for each finished item. Turning one into the other looks like simple division, and in the arithmetic it is. The risk sits in the two numbers you feed into the division. If the lot cost includes the wrong things, or the count of items does not match what the lot really produced, the unit figure will look clean and still be wrong.

This post gives you three steps to check the unit figure before it goes into a bid. None of them requires special software.

The examples come from Microsoft Learn's page on calculating standard cost in Business Central, which shows the lot-to-unit arithmetic in plain form. Microsoft's figures are used here only to illustrate the method. Your own lots will have their own inputs, and you should check them against your own records rather than copying the numbers.

Step 1: Confirm what the lot cost covers

A lot cost is a total, and a total is only as trustworthy as the list of parts inside it. Before you divide anything, write down what is in the lot cost. Who built it, when, and from which inputs? If you cannot answer those questions, you do not yet have a figure you can bid from.

The Microsoft example shows how a lot cost is assembled from a few inputs. It states: "The lot cost is calculated as 4 unit cost × 3 components × 10 finished items = 120." ( Microsoft Learn) Here the lot cost is not a single number pulled from a file. It is the product of a unit cost, a number of components, and a number of finished items. Each of those inputs can be wrong, and each one changes the lot total.

A second example from the same source builds the lot from a work center rate: "The lot cost is calculated as 7 work center direct unit cost × 10 items = 70." ( Microsoft Learn) Again the lot is a rate multiplied by a count. The question to ask is what the rate is a rate of. Is it for each item, hour, setup, or batch? If the rate is hourly and the lot cost treats it as an item rate, the lot is wrong before you have divided anything.

When you review a lot cost, work through these questions:

• Material. Is each component cost current? Does the lot use the same material grade, size, or pack that you will buy for the bid?
• Labor. Is the labor time for each item or for the whole run? Does the lot include setup time, or only running time?
• Setup and fixed charges. Does the lot include a charge that does not change with the number of items, such as a machine setup, a tooling charge, or a first-article inspection? A fixed charge spread across a lot of one size gives a different unit figure than the same charge spread across a different size.
• Overhead. Has overhead been added once, or allocated more than once? Does the allocation base, such as machine hours or labor hours, match how the bid job will actually run?
• Scrap and rework. Does the lot allow for rejected pieces? If it does, how many?
• Freight and packaging. Are they inside the lot cost, or will they be added to the bid separately?

You do not need every answer to be perfect. You do need to know the answers and be able to explain them. If a number is an estimate, mark it as one. A unit figure built on an estimate should be presented as an estimate.

Pay close attention to the basis of every rate. Rates are a common source of error in a lot-to-unit conversion. An hourly rate, a setup rate, and an item rate are three different numbers, and it is easy to multiply one by the wrong count. Write the basis next to every rate in your worksheet. A line that says "labor rate, for each machine hour" is much easier to check than one that says "labor rate."

For related input checks, see construction material cost checks.

Finally, check whether the lot cost matches the work you are bidding. A lot built for one run size is not automatically the right basis for a bid on a different size. If your bid quantity differs from the lot quantity, decide whether the fixed charges need to be spread again. Do not simply scale the unit figure without thinking it through.

Step 2: Divide by the finished items, not by the inputs

The second step is the divisor. A unit cost divides the lot by the number of items that come out finished and usable.

The Microsoft example shows the division cleanly: the unit cost is 120 ÷ 10 = 12. ( Microsoft Learn) In that example, the lot cost was built using 10 finished items, so the divisor and the lot count match. The second example shows the same match: the unit cost is 70 ÷ 10 = 7. ( Microsoft Learn) That lot was also built on 10 items. When the two counts match, the division is straightforward. The check is to confirm that they match for the reason you think they do.

Now consider what happens when they do not match. Suppose a lot is planned for a certain number of finished items, but the process reliably yields fewer. The lot cost you built still reflects all the material and labor that went into the run, including the pieces that were rejected. It understates the real cost of each usable item.

The fix depends on what you decide the lot cost includes:

• If the lot cost includes the cost of rejected pieces, divide by the number of good, finished items. That spreads the full cost of the run over the items you can sell or deliver.
• If the lot cost covers only the good items, restore the rejected-piece costs before dividing by usable output to calculate the full unit cost. Removing those costs understates that full cost; retaining them does not.
• If you are unsure, say so in the worksheet and show the unit figure both ways, so the person reviewing the bid can see the gap.

Check the unit of count as well. A lot may be counted in pieces, sets, pairs, boxes, or linear feet. A lot cost in sets divided by a count of pieces gives a figure that is correct only if each set is exactly the number of pieces you assume. This is a simple check that can reveal count-conversion errors. Write the unit next to the count, the same way you write the basis next to each rate.

One last point for this step: distinguish costs calculated using started items from those calculated using finished items. Use finished, usable output for the cost of each deliverable item; dividing by started items measures something different. A mixed approach, where some lots are divided by started count and others by finished count, produces unit figures that cannot be compared, and a bid built on them will be hard to defend.

Step 3: Check the result against the lot and bid quantity

The third step is a check on the result. Take the unit figure and multiply it by the count you used for the division. You should get back the original lot cost.

If your figures do not return to the lot cost, something has gone wrong: a typing error, a rounding problem, or a count that changed between steps.

Be careful here, though. The multiply-back check has a blind spot, and you need to know what it is. If you divided by the wrong count, multiplying back by that same wrong count will return the lot cost perfectly. The arithmetic is correct, but the answer is still wrong. So the multiply-back check catches slips in arithmetic and rounding. It does not catch a wrong divisor. For that you need a second check.

The second check compares the divisor with the quantity in the bid. Open the bid, find the quantity you are pricing, and ask whether the count you divided by is the same number. If the bid quantity differs from the lot quantity, check fixed-cost allocation, rates and production assumptions before using the unit cost. Compare them directly to avoid carrying an unsuitable unit cost across bid lines.

Rounding deserves its own attention. If you round the unit price and then multiply by the quantity, the bid total may differ slightly from the lot cost you started with. That difference is usually small, but a reviewer who sees a mismatch will ask about it. Decide on a rounding approach in advance:

• Keep full precision through the calculation, and round only the figure that goes on the bid.
• Show the rounding difference in the worksheet, so the mismatch is explained rather than discovered.
• Use the same approach for every lot, so the bids are comparable.

Avoid rounding the unit figure early, before you have finished the other steps. An early rounding becomes a small error that grows when it is multiplied back by the quantity.

Common mistakes to watch for

Check for these errors when converting a lot cost into a unit cost. Use this list as a last scan before you finish.

• Using the wrong count. Using a unit cost without checking its applicability to the bid quantity can carry unsuitable assumptions into the bid. Compare them directly.
• Dividing a fixed charge as if it were variable. A setup charge does not grow with each item. Spreading it across a larger or smaller quantity than the lot was built for changes the unit figure.
• Allocating overhead twice. Overhead may already be inside the lot cost. Adding it again on the bid inflates the price. Check the lot for overhead before you add any.
• Ignoring the rate basis. An hourly rate multiplied as if it were an item rate gives a wrong lot cost, and the division only makes the error look more precise.
• Mixing units. Sets, pairs, pieces, and linear feet are not interchangeable.
• Forgetting scrap. If the lot cost includes rejected pieces and you divide by all started items, the unit figure is understated. If the lot cost does not include them and you divide by good items, check that the total is right.
• Rounding too early. Round at the end, not in the middle.
• Carrying an old lot forward. A lot cost from a previous run may use prices that have since changed. Check that the inputs are current before you reuse the figure.

Illustrative example: Check a lot calculation

An illustrative lot costs 200 and produces 10 usable items. Dividing 200 by 10 gives a unit cost of 20. Multiplying 20 by 10 returns 200. Before using 20 in a bid, check that the lot's rates, fixed charges and production assumptions fit the bid quantity.

A worked check you can repeat

Here is a short procedure you can apply to any lot. It uses the arithmetic from the Microsoft examples, but the steps apply to any figure you have.

First, write the lot cost and the list of inputs that built it. Mark each input with its basis, such as for each item, hour, or setup. Confirm that the lot includes what you intend to bid.

Second, write the divisor and its unit. Confirm that it is the count of finished, usable items, not the count of items started.

Third, compute the unit figure with full precision.

Fourth, multiply the unit figure by the divisor and confirm that it returns the lot cost. If it does not, find the slip before going further.

Fifth, compare the divisor with the bid quantity. If they differ, decide whether the fixed charges must be spread again, and recalculate.

Sixth, round only at the end, and record the rounding difference.

Seventh, note any estimate or assumption on the worksheet, so the reviewer knows which parts are firm and which are not.

For a bid with many lines, it is worth building a reusable worksheet with these fields built in, so every line goes through the same checks.

Before the figure goes into the bid

The unit figure is a pricing input, and it should be treated as one. A checked unit cost is still only a cost. The bid also needs margin, a risk allowance, and any terms the customer has asked for. Keep those separate from the unit cost so the reviewer can see where the cost ends and the pricing decision begins. See markup and margin rates when reviewing that separate pricing decision.

Keep the worksheet with the bid. If someone asks later how a unit price was reached, you should be able to show the lot cost, the inputs and their bases, the divisor, the check against the bid quantity, and the rounding approach. A figure that can be traced is much easier to defend than one that appears without a history.

Finally, revisit the figure if anything changes. A change in quantity, a change in a material price, a new setup requirement, or a change in the rejection rate can each shift the unit figure. A lot cost checked last month may not hold for a bid submitted today.

The goal of these three steps is not to make the arithmetic harder. It is to make sure the arithmetic answers the right question. The lot cost tells you what a run cost. The unit figure tells you what one usable item cost, under the assumptions in your worksheet. A bid needs the second figure, and it needs that figure to be right for the quantity and the work that will actually be done.

Today, take a lot from your current bid and apply the worked check above before carrying its unit cost into the price.

Questions

Which count should divide the lot cost?

Use finished, usable output when calculating the full cost of each deliverable item.

Does a different bid quantity make the unit cost wrong?

A quantity difference calls for checking fixed-cost allocation, rates and production assumptions before reusing the figure.

Does multiplying back prove the divisor is right?

Multiplying back checks the arithmetic, but it cannot establish that the chosen output count is correct.