Bypass the header links
StockroomLane

Overhead for each unit: 4 figures for stock costs

By
StockroomLane Editorial Team
Posted
Sources checked
Time to read
12 min read

How this guide was made

Written by AI software on a local computer, with a source shown beside each statement and the facts looked over once by a second AI system from an outside firm. Humans did not write, edit or review it. Editorial standards

The invoice is not the whole cost

Calculate overhead for each stock unit by dividing planned overhead by planned activity, then applying that rate to each unit's activity. The clipboard is full, and the sheet lists a case of candles at the price printed on the vendor's invoice. Before you set the shelf cost from that number, ask a harder question: what did the store spend last month to keep those candles on the shelf?

The invoice covers the candles and nothing else. It says nothing about the rent, the lights, the card reader fees, the shelving that wore out, or the hours your count staff spent in the back room. Those costs are real, and they do not sit on any one item. Accountants call them overhead.

Overhead is the cost of running the place that is not the stock itself and not labor you can trace straight to a single item. Many independent shops leave it out when they set cost on counted stock. Others fold it in by feel: add a little on top and hope it is close. That habit works until a slow month arrives, a bill goes up, or a new owner asks why the margin on a line never seems to hold.

This post walks through a simple method for putting a unit overhead figure on stock you count each period. It uses four figures. Once you have them, you can apply them to any count sheet and explain the number to anyone who asks where it came from.

The examples below come from a managerial accounting textbook, OpenStax. They are written for manufacturers, not shops, but the problem is the same: shared costs, and a unit cost to set for each item. Treat the numbers as teaching examples, not benchmarks for your store.

Figure 1: the overhead pool

The first figure is the total overhead you expect to spend over the period you are counting. Call it the pool. The pool is an estimate, not a bill. You are forecasting what the period will cost so you can spread that cost across the units you expect to hold and sell.

The textbook looks back before it looks forward. In one worked example, the company "uses the expenses from the prior two years to estimate the overhead for the upcoming year to be $250,000." A shop can do the same. Pull last year's rent, utilities, insurance, card fees, repairs, software subscriptions, and cleaning supplies. Then adjust for anything you know is changing: a new lease, a rate increase from a provider, a side room you closed off, or a service you stopped using.

Some bills do not land evenly across the year. Insurance is often paid in a lump, even though the shop is covered every month. The same textbook notes that "since production rates can vary month to month, most producers would allocate $400 each month for property insurance, and this cost would be incorporated into the total overhead costs anticipated when estimating a manufacturing overhead allocation rate." In plain terms, divide the annual premium by the months it covers and put that monthly share into the pool. Do the same with any yearly fee or subscription, so one large payment does not make a single month look expensive.

The hardest line to draw is between stock and the things that help you sell it. New York's tax guidance defines the term this way: "The term tangible personal property means any kind of physical personal property that has a material existence and is perceptible to the human senses (in other words, something you can see and touch)." Candles, shelving, and the register all pass that test. For this costing method, distinguish items for sale from items used to run the shop. Settle that before you count, and write the rule down.

Keep the pool to costs that support the whole operation. Leave out the purchase cost of the stock, because the vendor's invoice already covers it. Leave out owner draws and loan principal. If you are unsure whether a cost belongs, ask your accountant or bookkeeper. A cost that is hard to classify can shift the figure every time you count, so it is worth settling once.

Write the pool down with a date and a short list of what it includes. Six months from now, you will want to know exactly what went into it.

Figure 2: the activity measure

The second figure is the thing you spread the pool across. Accountants call it the allocation base or the activity measure. For a shop it is usually one of three things: the number of units, the hours of labor, or the dollars of labor paid.

The textbook uses labor dollars in one of its examples. The company "also used its payroll records to estimate that it will spend $100,000 on direct labor." That choice makes sense when much of the overhead rises and falls with the work people do. The table sets out when each base tends to fit.

Base Use it when Watch out for
Units Items are similar in size and handling Bulky and tiny items get the same overhead for each unit
Labor hours Staff time drives most of the cost, such as receiving and shelving You need a reliable record of who did what
Labor dollars Pay rates are stable and payroll is tracked by task A raise changes the rate even when the work does not

Choose the base by asking what drives your overhead. If items move through the back room in large numbers, units make sense. If most of the cost is staff time on the floor and in the back, labor makes more sense. A poor choice is one that ignores what really takes up your time and space.

Pick one base for the whole period. Switching halfway through makes this period's numbers impossible to compare with the last. If you later decide the base was wrong, change it at the start of a new period and note the change on your records.

Figure 3: the overhead rate

The third figure is the overhead rate. Divide the pool from figure 1 by the base from figure 2. The result tells you how much overhead attaches to each unit of base.

The textbook example makes the arithmetic easy to follow. It states the rate as $2.50 of overhead for each dollar of labor, then shows it at work: "If the total labor paid for the job is $66, the overhead applied to the job is $2.50 times that amount, or $165." The table traces the steps.

Step Textbook figure
Overhead pool (figure 1) $250,000
Labor base (figure 2) $100,000 of direct labor
Rate (figure 3) $2.50 for each labor dollar
Overhead on a $66 labor job $165

Apply the rate the same way in your shop. Multiply it by the amount of base that an item or batch uses. With labor dollars, multiply by the labor dollars tied to the item. With units, the rate is already dollars of overhead for each unit, so the multiplication is simple.

Recalculate the rate every period. A rate is only as current as the pool and the base behind it. If rent rises mid-year, the rate you calculated in January will understate overhead by spring. Keep the calculation on the same page as the pool and base so you can check it quickly.

Figure 4: unit overhead on the count sheet

The fourth figure is the one that goes on the count sheet. Get it by applying the rate to the base each unit uses. If your base is units, the unit overhead is the rate itself. If your base is labor hours, use the handling hours for each unit; if it is labor dollars, convert that time into dollars at your staff's pay rate. Multiply that by the rate.

Many shops will not time every item, and that is fine. Group items into a few handling categories, such as small hanging goods, boxed goods, and bulky items, and set one labor figure for each category. The categories do not need to be exact. They need to be consistent and reasonable, and you should write down how you chose them.

Once you have the unit overhead, add it to the purchase cost of the item. That total is your estimated unit cost for internal planning. It is a cost figure, not a retail price. Shelf pricing depends on what customers will pay, what competitors charge, and the margin you need, so keep the two numbers apart on your records. For the separate question of valuing stock against your books, see stock count cost layers.

Expect the figure to be a little rough. It is only as good as the estimates behind the pool and the base. A rough number built on a clear method still beats a cost that shifts with whoever is holding the clipboard.

Why the unit overhead figure moves

Overhead for each unit changes when the pool or the base changes. The textbook shows how far the number can swing with volume alone: with 500 units made in one month and 2,000 the next, the overhead cost for each unit changes from $2 to $0.50. The same thing happens in a shop. When overhead stays roughly the same and you handle more units, each unit carries less of it. When you handle fewer, each unit carries more.

That means a slow month can make every item look expensive, and a busy month can make the same items look cheap. Neither result says anything wrong about the stock. It says the overhead had fewer or more units to spread across.

Do not chase every swing. Set the rate using the volume you planned for the period, not the volume you hope to see on a given day. At the end of the period, compare actual volume with planned volume. If the gap is small, leave the figure alone. If it is large and keeps repeating, adjust the planned volume for the next period. The aim is a steady, defensible figure, not a perfect one every week.

Also watch for changes that have nothing to do with volume. A new card reader with higher fees, a longer lease, or a new employee who works mostly on overhead tasks all change the pool or the base. Carry those changes into the next estimate, even if the shop is quiet.

Setting the cost before the bills arrive

Often you must set cost before you know what overhead really was. The textbook addresses this timing gap directly: "For example, a company may know it will have a contract to produce 100 custom units long before it knows the utility costs for the next year." A shop faces the same gap. You may know roughly how much stock you will hold long before the utility bill, the insurance true-up, or the repair invoice for the period arrives.

Use the estimate anyway. Record which figures are estimates and which are actual amounts, so you can tell them apart later. When the real bill comes in, compare it with the plan, adjust the next period's pool, and note the difference. Keep the original planning estimate alongside actual costs so you can compare them later. Ask your accountant how any difference should affect your books.

Some shops prefer to wait for actual figures before they finalize a cost. That replaces estimates with actual amounts, but it can delay the costing of your counts. If that delay causes trouble with pricing or with reports for owners, use the estimate. If the delay does not matter, waiting may be cleaner. Pick one approach and keep it, so figures can be compared across periods.

Mistakes that break the figure

Several errors show up again and again when shops first set overhead for each unit. The first is leaving out annual costs. A yearly insurance premium or license fee that lands in one month makes that month look costly and every other month look cheap. Spread it out, as described in figure 1.

The second is double counting. Stock pulled for the shop's own use is a related trap.

The third is changing the base partway through the period. Units one week and labor the next make the numbers meaningless.

The fourth is ignoring staff time. Classify counting and receiving time consistently: include shared staff costs in the pool, and use task hours or labor dollars as the base when appropriate. Leaving shared staff costs out understates the cost of running those tasks.

The fifth is treating the first estimate as final. An overhead figure is a working estimate. Check it regularly against actual costs, and change it when the facts change.

A routine for each count

A simple routine keeps the method manageable. Run it at the start of each count period.

First, update the pool. Pull the planned overhead for the period, spreading any annual costs across the months they cover. Note known changes, such as new rates, a new lease, or a new service provider, so the estimate reflects the shop you are actually running.

Second, confirm the base and the planned volume. Decide whether you are using units or labor, and write down the planned units, labor hours, or labor dollars for the period.

Third, calculate the rate by dividing the pool by the base. Keep the result beside the inputs so anyone checking it can follow the steps.

Fourth, calculate overhead for each unit in each category of stock. If you are using units, the rate is the figure. If you are using labor, multiply the labor figure for each handling category by the rate.

Fifth, add the unit overhead to the purchase cost of each item and record the result on the count sheet. Date the sheet and note the figures used.

Sixth, at the end of the period, compare actual overhead and actual volume with the plan. Note the differences and carry the lessons into the next estimate.

The routine takes some time to set up, but after a few periods it becomes quick. Most of the work happens in the first two runs, when you decide what counts as overhead and which base fits your shop.

When to revisit the method

Revisit the method when something changes in the shop. A new lease, a new service provider, a change in staffing, or a new product category can all shift the pool or the base. Revisit it too when your true-up keeps showing the same gap. A repeating gap is a sign that a driver of overhead is missing from your estimate or that the base is wrong.

Review the whole method once a year, even if nothing obvious has changed. Look at the items that caused the most questions during the year. Check whether the handling categories still reflect how stock moves through the store, and whether the costs in the pool still match the way you run the shop.

Write it down and start with the next count

The four figures are the overhead pool, the activity measure, the rate, and the unit overhead. Each can be checked, explained, and adjusted. When you can show where each number came from, you can defend the cost you set on counted stock, whether the question comes from an owner, a manager, a bookkeeper, or a tax preparer.

This post gives general guidance, not accounting or tax advice. For questions about how overhead should be treated in your books or on your returns, check with a qualified accountant or tax professional who knows your situation.

Start with the next count. Write down the pool, pick a base, calculate the rate, and record the result. The first period is the hardest. After that, the figures start to tell you something useful about your shop.

Sources

Keep reading

See every guide