How Do You Allocate Overhead to Products? A Guide to Fixed Costs, the Allocation Key, Revenue-Based and Order-Based Shares, Activity-Based Allocation and True Product Profit
How do you allocate overhead to products? Direct contribution, allocation by revenue and by order, activity-based allocation, and true product profit: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is overhead, and how is it separated?
- Lesson 2: Why isn't direct contribution enough?
- Lesson 3: How is overhead allocated by revenue?
- Lesson 4: How is overhead allocated by order?
- Lesson 5: How is overhead allocated by activity?
- Lesson 6: How do you compare the results of the three methods?
- Lesson 7: How do you make pricing and basket decisions based on true net profit?
- Lesson 8: How do you monitor and update overhead allocation?
- What are the most common mistakes when allocating overhead?
- How does NetKasam make product and expense tracking easier?
- Mini quiz: Test what you have learned
- Conclusion: Gather your overhead into a single pool this month
- Frequently Asked Questions About Overhead Allocation
When calculating profitability by product, most businesses deduct product cost, commission, shipping, and packaging and call what remains "profit." Yet overhead such as rent, warehouse and office staff, software subscriptions, and accounting still hasn't been paid, and these expenses end up resting on the products one way or another. Making pricing decisions without knowing how much of this burden each product carries means confusing a profitable product with a loss-making one.
This article is not a narrative but an 8-lesson practical training. We'll answer the question how do you allocate overhead to products using a business that sells three product groups and has ₺150,000 in monthly overhead: what overhead is, why direct contribution isn't enough, allocation by revenue, allocation by order, activity-based allocation, the results of the three methods, pricing and basket decisions, and a monitoring routine. At the end, there is a mini quiz with an answer key. All figures are sample values chosen to illustrate the method; follow the same steps with your own figures.
What will you be able to do by the end of this training?
In short: You will separate overhead, try three allocation keys, find the true net profit of each product group, and make pricing or basket decisions based on that figure.
- 01SeparateSeparate direct expenses from overhead.
- 02PoolGather overhead item by item into a single pool.
- 03ChooseSet a key close to the cause for each item.
- 04AllocateDivide the share among product groups.
- 05CompareSee the results of the methods side by side.
- 06DecideAdjust price and basket based on true profit.
The 8 lessons of this training: (1) what overhead is and how it is separated, (2) why direct contribution isn't enough, (3) allocation by revenue, (4) allocation by order, (5) activity-based allocation, (6) comparing the methods, (7) pricing and basket decisions, (8) monitoring and updating.
Lesson 1: What is overhead, and how is it separated?
In short: A direct expense is one that can be charged to a single product or order; overhead is an expense shared by many products that can't be divided by product.
The sample business sells three product groups: A small accessories, B medium-sized products, C bulky products. Monthly orders, revenue, and direct contribution (what remains after deducting product cost, commission, shipping, and packaging from the sales amount) are as follows:
| Product group | Order | Average basket | Revenue | Direct contribution |
|---|---|---|---|---|
| A: Small accessory | 3.000 | 200 ₺ | 600.000 ₺ | 150.000 ₺ |
| B: Medium-sized product | 1.500 | 500 ₺ | 750.000 ₺ | 180.000 ₺ |
| C: Bulky product | 500 | 1.300 ₺ | 650.000 ₺ | 160.000 ₺ |
| Total | 5.000 | 2.000.000 ₺ | 490.000 ₺ |
Overhead, however, can't be charged to a product: rent and building fees ₺30,000, warehouse and office staff ₺90,000, software and subscriptions ₺12,000, accounting and consulting ₺8,000, electricity, internet, and other ₺10,000. Total ₺150,000.
- Total direct contribution₺490,000
- Warehouse and office staff−₺90,000
- Rent and building fees−₺30,000
- Software, accounting, electricity, and other−₺30,000
- Monthly net profit₺340,000
Prepared with sample values. Total: 490,000 − 90,000 − 30,000 − 30,000 = ₺340,000.
Keeping overhead in a separate pool requires setting up categories in your expense records; for this, see the article how to do an expense analysis, and for planning fixed expenses, see how to create a fixed expense and payment calendar. We explained how to find the share for the staff item in the article how to calculate personnel cost.
Lesson 2: Why isn't direct contribution enough?
In short: Direct contribution shows how much a product contributes to covering overhead; but it doesn't show how much of the overhead each product causes.
All three groups have positive direct contribution; group A brings in ₺150,000, B ₺180,000, and C ₺160,000. Someone looking at this table would consider all three profitable and might want to spend more on advertising for group A. Yet group A's 3,000 orders create the most work for picking, packing, and customer communication in the warehouse; its order count is six times that of C. The contribution looks high, but the shared labor spent to produce that contribution hasn't been taken into account.
Allocating overhead is about finding what remains when that share is subtracted from direct contribution, that is, the product group's net profit. This net profit is much closer than direct contribution to answering the question "should I invest more in this group, or raise the price?" We explained the basics of product-level profitability in the article how to analyze product-level profitability; this article takes that analysis one step further.
Product pageFree Bookkeeping SoftwareLesson 3: How is overhead allocated by revenue?
In short: In allocation by revenue, each group's share equals its share of total revenue. It is the simplest method, but it ignores the order workload of product groups.
Revenue shares: A 600,000 ÷ 2,000,000 = 30%, B 750,000 ÷ 2,000,000 = 37.5%, C 650,000 ÷ 2,000,000 = 32.5%. When ₺150,000 in overhead is divided by these ratios, A gets ₺45,000, B ₺56,250, and C ₺48,750.
| Product group | Direct contribution | Overhead share | Net profit | Net margin |
|---|---|---|---|---|
| A | 150.000 ₺ | 45.000 ₺ | 105.000 ₺ | %17,5 |
| B | 180.000 ₺ | 56.250 ₺ | 123.750 ₺ | %16,5 |
| C | 160.000 ₺ | 48.750 ₺ | 111.250 ₺ | %17,1 |
All three groups come out at roughly a 17% net margin; the method makes everyone look alike. The problem is that allocation by revenue treats "large baskets as expensive and small baskets as cheap": an order in group C takes a large share with ₺1,300 in revenue while creating only one parcel's worth of work in the warehouse, whereas a ₺200 order in group A is much more expensive in terms of packing time.
Lesson 4: How is overhead allocated by order?
In short: In allocation by order, every order carries the same share. When warehouse and office labor is proportional to orders, the method gets closer to reality, but tying rent and software to orders as well is misleading.
Order shares: A 3,000 ÷ 5,000 = 60%, B 1,500 ÷ 5,000 = 30%, C 500 ÷ 5,000 = 10%. With these ratios, the same ₺150,000 gives A ₺90,000, B ₺45,000, and C ₺15,000.
| Product group | Direct contribution | Overhead share | Net profit | Net margin |
|---|---|---|---|---|
| A | 150.000 ₺ | 90.000 ₺ | 60.000 ₺ | %10,0 |
| B | 180.000 ₺ | 45.000 ₺ | 135.000 ₺ | %18,0 |
| C | 160.000 ₺ | 15.000 ₺ | 145.000 ₺ | %22,3 |
Now the picture has changed completely: group A drops to a 10% margin and group C rises to 22.3%. Allocation by order charges ₺30 of overhead to each order (150,000 ÷ 5,000). This key is reasonable for warehouse and office staff, but not for rent and software subscriptions: rent is determined by the space occupied in the warehouse, not by the number of orders.
Lesson 5: How is overhead allocated by activity?
In short: In activity-based allocation, each overhead item is divided according to the activity that drives it: staff by orders, rent by space occupied, and remaining shared expenses by revenue.
For the sample business, the keys were set as follows:
- Warehouse and office staff (₺90,000) by number of orders: A 60% = ₺54,000, B 30% = ₺27,000, C 10% = ₺9,000.
- Rent and building fees (₺30,000) by space occupied in the warehouse; space shares A 20%, B 30%, C 50%: A ₺6,000, B ₺9,000, C ₺15,000.
- Software, accounting, electricity, and other (₺30,000) by revenue: A 30% = ₺9,000, B 37.5% = ₺11,250, C 32.5% = ₺9,750.
- A: Small accessory₺69,00046%
- B: Medium-sized product₺47,25031.5%
- C: Bulky product₺33,75022.5%
Prepared with sample values. A: 54,000 + 6,000 + 9,000; B: 27,000 + 9,000 + 11,250; C: 9,000 + 15,000 + 9,750.
| Product group | Direct contribution | Overhead share | Net profit | Net margin | Share per order |
|---|---|---|---|---|---|
| A | 150.000 ₺ | 69.000 ₺ | 81.000 ₺ | %13,5 | 23,00 ₺ |
| B | 180.000 ₺ | 47.250 ₺ | 132.750 ₺ | %17,7 | 31,50 ₺ |
| C | 160.000 ₺ | 33.750 ₺ | 126.250 ₺ | %19,4 | 67,50 ₺ |
In activity-based allocation, the result falls between the two simple methods: group A 13.5%, B 17.7%, C 19.4%. Total net profit is still ₺340,000; the method doesn't change total profit, only how it is distributed among groups. Because the share is closer to the real cause of the expense, this is the most reliable table for making decisions.
Lesson 6: How do you compare the results of the three methods?
In short: The choice of method changes the result; so before deciding, you need to see the same group under all three methods and understand where the difference comes from.
- Allocation by revenue17.5%
- Allocation by order10.0%
- Activity-based allocation13.5%
Prepared with sample values. Net profit ÷ revenue for the same group A.
| Product group | By revenue | By order | By activity |
|---|---|---|---|
| A | 105.000 ₺ (%17,5) | 60.000 ₺ (%10,0) | 81.000 ₺ (%13,5) |
| B | 123.750 ₺ (%16,5) | 135.000 ₺ (%18,0) | 132.750 ₺ (%17,7) |
| C | 111.250 ₺ (%17,1) | 145.000 ₺ (%22,3) | 126.250 ₺ (%19,4) |
| Total | 340.000 ₺ | 340.000 ₺ | 340.000 ₺ |
In allocation by order and by activity, group A has the lowest margin; in allocation by revenue, B appears lowest. Allocation by revenue makes A look more profitable than it really is, because it hides the load that group A's small orders place on warehouse and office labor. Group A's true share per order is ₺23; the revenue method charges ₺15 (45,000 ÷ 3,000). The difference is ₺8 per order and ₺24,000 per month (69,000 − 45,000).
Which method to choose depends on the structure of your expenses. If personnel costs dominate, order-based keys come to the fore; if rent and warehouse costs dominate, space-based keys do. For most e-commerce businesses, activity-based allocation is the most reliable table; for a simple start, even splitting the staff item by orders and the remaining expenses by revenue is much better than a single revenue key.
Recommended ReadingHow Do You Measure Profitability by Sales Channel?Lesson 7: How do you make pricing and basket decisions based on true net profit?
In short: After overhead is allocated, each group's net margin is compared with the company average; for a group below average, the price, basket, or free shipping threshold is adjusted.
The company average is 340,000 ÷ 2,000,000 = 17%. Under activity-based allocation, group A is below average at 13.5%. The net profit needed to bring group A up to the average is 600,000 × 0.17 = ₺102,000, which is ₺21,000 above today's ₺81,000. Divided across 3,000 orders, this means raising contribution per order from ₺50 to ₺57 (21,000 ÷ 3,000 = ₺7).
| Lever | What happens | Why it works |
|---|---|---|
| Price | Raise the price of group A products enough to add ₺7 of contribution per order | Contribution increases directly |
| Basket | Adjust the free shipping threshold or multi-buy discount to grow the basket | The same order labor is spread over a larger basket |
| Bundling | Offer small products in bundles | The number of orders falls and the warehouse load decreases |
Revenue was held constant in the calculation; since a price increase also raises revenue, the actual margin will come out slightly different. The goal isn't a precise result but direction and magnitude: knowing that group A is short about ₺7 of contribution per order is enough to decide which lever to pull. We explained the effect of the free shipping threshold in the article how to set a free shipping threshold and growing the basket in how to calculate and increase average order value. To avoid discounting at a loss when raising prices, see how to offer discounts without losing money.
Lesson 8: How do you monitor and update overhead allocation?
In short: Keys are reviewed every three months; when the order mix, space usage, or expense amounts change, the share changes too.
| Indicator | How it is calculated | Sample value |
|---|---|---|
| Overhead ratio | Overhead ÷ Revenue | 150.000 ÷ 2.000.000 = %7,5 |
| Overhead per order | Overhead ÷ Orders | 30 ₺ |
| Group net margin | (Direct contribution − Share) ÷ Revenue | %13,5 / %17,7 / %19,4 |
| Company net margin | Net profit ÷ Revenue | %17 |
- ₺150,000monthly overhead pool
- 10% – 17.5%group A's net margin, depending on the method
- ₺23true overhead share per order in group A
- ₺7increase in contribution per order needed to bring group A up to the average
Instead of setting up the method once and forgetting it, rerun it every quarter: a new warehouse, new staff, or a new channel changes the weight of the keys. For a monthly table, see the article how to compare the monthly budget with actuals.
What are the most common mistakes when allocating overhead?
- Not allocating overhead at all. Every product looks profitable, and selling at a loss goes unnoticed.
- Dividing everything with a single key. Dividing staff by revenue and rent by orders gives misleading results.
- Treating allocation as the product decision mechanism. The share is a management tool; instead of ignoring direct contribution, read the two together.
- Never updating the method. The order mix changes and the key becomes outdated.
- Treating chargeable expenses as overhead. Expenses that can be charged directly are charged directly; only shared expenses are allocated.
- Expecting total profit to change. The method only changes how profit is distributed among groups.
How does NetKasam make product and expense tracking easier?
- Expense slip. You record your expenses with an expense slip from the "Expenses" menu (expense management).
- Future-dated expenses and reminders. You create a future-dated expense by setting the payment status to "to be paid"; the system alerts you on the payment date.
- Inventory card. You track product cards and inventory movements in one place (inventory management).
- Orders on a single screen. You see orders in a single panel and filter by product (order management).
- Saved reports. You save expense and sales reports with criteria and export them to Excel (reports).
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If direct contribution is ₺490,000 and overhead is ₺150,000, what is net profit?
- If you split overhead by revenue, what is the share in lira of a group with revenue of ₺600,000 when total revenue is ₺2,000,000?
- In allocation by order, what percentage of 5,000 orders does a group with 3,000 orders carry, and what is its share?
- In activity-based allocation, if group A's share is 54,000 + 6,000 + 9,000, what is the total?
- If group A's direct contribution is ₺150,000, its share is ₺69,000, and its revenue is ₺600,000, what is its net margin?
Answer key:
- 490.000 − 150.000 = 340.000 ₺.
- 600.000 ÷ 2.000.000 = %30; 150.000 × 0,30 = 45.000 ₺.
- %60 (3.000 ÷ 5.000); 150.000 × 0,60 = 90.000 ₺.
- 54.000 + 6.000 + 9.000 = 69.000 ₺.
- (150.000 − 69.000) ÷ 600.000 = 81.000 ÷ 600.000 = %13,5.
Frequently Asked Questions About Overhead Allocation
What is overhead allocation?
It is the distribution of expenses that can't be charged directly to a product, such as rent, shared staff, software, and accounting, across product groups using a reasonable key.
How is overhead allocated to products?
Each expense item is divided according to the activity that drives it: staff by number of orders, rent by floor space used, and shared expenses such as software and accounting can be allocated by revenue.
Why can allocation by revenue be misleading?
It assigns a large share to orders with large baskets and hides the warehouse and office workload of a group with small baskets but many orders. As a result, the small-basket group looks more profitable than it really is.
What is the difference between direct contribution and net profit?
Direct contribution is what remains after deducting product cost, commission, shipping, and packaging from the sales amount. Net profit is the amount remaining after the overhead share is also applied.
Does the allocation method change total profit?
No. Total net profit stays the same; the method only shows how profit is distributed among product groups.
Which allocation method is the most accurate?
In general, activity-based allocation gives the result closest to reality, because it links each expense to its own cause. To start, splitting staff by orders and the rest by revenue may be enough.
How often should allocation keys be updated?
They should be recalculated every three months, or whenever the order mix, space usage, or expense amounts change noticeably.
How do you make pricing decisions based on overhead allocation?
Each group's net margin is compared with the company average. For a group below average, contribution per order is increased by adjusting the price, basket amount, or free shipping threshold.
Conclusion: Gather your overhead into a single pool this month
The most useful thing you can do today is gather last month's rent, staff, software, and accounting expenses into a pool and write down what drives each item: orders, space, or revenue? As a first step, even splitting the staff item by orders and the rest by revenue can reveal surprising differences in the net margins of your product groups. The next step is to make a pricing or basket decision for the lowest-margin group.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.