Compare budgeted and actual variable overhead rates by dividing actual variable overhead by actual hours, then checking spending and efficiency separately.
Key takeaways
- Match the cost center, period, and hour basis.
- Keep total and variable overhead rates separate.
- Check recorded hours before explaining a rate difference.
- Compare actual hours with standard hours allowed for actual output.
Why compare budget and actual variable overhead
If you set an hourly overhead rate, you are making a forecast. You estimate how much overhead a job will absorb, divide that amount by the hours you expect to use, and price the work on the result. Then the period ends and the real numbers arrive. Supplies cost more than planned, a machine draws more power than expected, or the crew works slower than the standard assumed. The gap between what you budgeted and what you spent is a variance, and variances tell you where to look next.
Variable overhead is the part of overhead that moves with activity. Indirect materials, consumables used on each job, and power that rises with machine time are typical examples. Because this cost follows activity, the hourly variable rate is the number to watch when you compare an estimate with what actually happened. Fixed overhead, such as rent or insurance, does not follow hours in the same way, so it needs its own analysis.
Terminology matters before you start. In a standard costing system, the overhead rate is often a total rate that combines fixed and variable costs. In the worked example from this OpenStax managerial accounting chapter on overhead variances, the standard overhead rate is the total budgeted overhead of $10,000 divided by the level of activity, which is 2,000 direct labor hours. That is a total rate. This post looks only at the variable piece, so keep the two apart in your spreadsheets and in your bids.
This post uses three rates to walk through the comparison. The first is the rate you planned to pay an hour. The second is the rate you actually paid an hour at one level of activity. The third is an actual rate from a different set of results on the same page. Each one answers a different question, and together they give you a clean way to test any budget against reality.
Set up the data before you calculate
Most bad comparisons start with bad inputs, not bad arithmetic. Before you divide anything, make sure the budget and the actuals describe the same thing. That means the same cost center, the same period, and the same activity measure.
Start with the overhead postings. Pull every variable overhead entry for the period, and confirm that none of them belong to a different cost center or a different month. Late invoices are a common trap. A power bill that arrives after the period closes can distort the actual rate for one month and then the next. Decide on a cutoff rule and apply it to both the budget and the actuals.
Next, pull the hours. If your budget uses direct labor hours, the actual hours must also be direct labor hours. Machine hours, paid hours, and clocked hours are not interchangeable. Paid hours can include breaks and idle time, while worked hours may not. Choose the basis that matches the budget and write it at the top of your comparison sheet.
Finally, record the activity level. A budget is built for a level of activity, often expressed as a percentage of capacity. Different activity levels affect total variable overhead, but do not by themselves require a different hourly variable rate. Note the activity level beside each figure so the comparison is honest from the start.
Rate 1: the standard variable overhead rate
The first rate is set before the work begins. It is the budgeted, or standard, hourly variable overhead rate, and you take it from a flexible budget. A flexible budget shows expected costs at different activity levels, including actual activity for comparison. That makes it the right source for an hourly rate, because it ties the expected cost to the expected hours.
In the worked example, the standard hourly variable overhead rate is $2.00 ($4,000/2,000 hours), taken from the flexible budget at 100% capacity. The logic is simple. The budget allows $4,000 of variable overhead for 2,000 hours, so each hour carries $2.00 of variable overhead.
Capacity is the assumption behind that number. The total overhead rate includes fixed costs spread over the activity level; the variable rate can remain constant. The same example shows that if a company produced at only 90% of capacity, it should expect total overhead of $9,600 and a standard overhead rate of $5.33 (rounded).
Here is a practical tip. Write the hours next to the rate in your estimate. An hourly rate of $2.00 means little if nobody can say whether it assumed 2,000 hours or some other figure. When you pull this rate into a bid or a forecast, pull the activity level that produced it at the same time.
Rate 2: the actual rate at one level of activity
The second rate is what you actually paid an hour. To calculate it, divide the actual variable overhead you spent by the actual hours you worked. Use the same activity basis as the budget. If the budget was built on direct labor hours, the actual rate must also use direct labor hours. Otherwise you are comparing two different measures and calling the difference a cost problem.
In the example, the actual variable overhead rate is $2.80 ($7,000/2,500), taken from the actual results at 100% capacity. The company spent $7,000 on variable overhead across 2,500 hours. Set that against the standard rate of $2.00 and the actual rate is clearly higher. The estimator's first question is simple: why did each hour cost more than planned?
A higher actual rate has several possible causes, and the number alone cannot tell you which one applies. Prices may have risen, so the same supplies or power now cost more for each unit. Usage may have grown, so each hour consumed more of an input than the budget allowed. Both can happen in the same period. Variance analysis is built to separate these effects, so resist the urge to blame the estimate before you look at the inputs behind it.
A rate can also move without any change in spending. Because the rate is spending divided by hours, fewer hours push the rate up even when the total spent stays the same. That is why you should always check the hour count before you conclude that costs got out of hand.
Rate 3: the actual rate from a different set of results
The third rate comes from another set of actual results on the same page. The actual variable overhead rate is $1.75 ($3,500/2,000), taken from the actual results at 100% capacity. This time the company spent $3,500 and worked 2,000 hours. The result sits below the $2.00 standard, so this period ran cheaper an hour than planned.
Put this next to rate 2 and the lesson gets sharper. Both are actual rates, yet they differ widely because the spending and the hours differ. An estimator who relies on a single actual result can be misled. One period of unusually low spending looks like a permanent saving, and one period of unusually high spending looks like a permanent problem. The better habit is to collect several periods or jobs and see whether the actual rate settles near the standard or keeps drifting away from it.
A low actual rate is good news only if it reflects real savings. Check that the lower spend did not come from delayed purchases, which often show up as higher costs in a later period. Check for overstated hours, which can make the calculated rate artificially low; missing hours inflate it.
Put the three rates side by side
A table makes the comparison easier to scan:
Read the table row by row. The standard row is the plan, and each actual row is what happened. When you compare an actual row with the standard, ask two questions. Did the hourly rate move? Did the hours move? Changing hours alone does not explain a variable-rate difference, because variable spending is also expected to change with hours.
Walk through the example from start to finish
Next, take the first set of actual results. The company spent $7,000 on variable overhead and worked 2,500 hours, giving an hourly actual rate of $2.80. The rate is higher than planned, and the hours are higher than the budget's 2,000. More labor hours were used; this does not establish greater output, and both sets of actual results are at 100% capacity. The hourly comparison has to be made on the same basis, not by comparing total spend straight against the budget total.
Then take the second set. The company spent $3,500 over 2,000 hours, giving an hourly actual rate of $1.75. Here the hours match the budget, so the rate difference is not explained by activity. Whatever moved the rate sits in the spending itself. That is a simpler story to investigate, because you can look at prices and usage without wondering whether the activity base changed.
Illustrative example: check an hourly rate
Illustrative figures: budget $100 for 50 hours and spend $150 over 50 hours. Divide each amount by 50: the budget rate is $2 an hour and the actual rate is $3 an hour. With hours unchanged, investigate spending.
Split the difference: rate and efficiency
A rate comparison tells you that the hourly cost moved. It does not tell you whether the hours used were the right hours for the work. For that, you need the efficiency side of the analysis. To determine the variable overhead efficiency variance, you must find both the actual hours worked and the standard hours the work should have taken at 100% capacity, as the worked example shows.
Compare the two figures. If actual hours exceed standard hours, the job used more activity than the plan allowed. If actual hours fall short, the job used less activity than the standard assumed. Either result changes how you read the rate, because variable overhead cost follows the hours.
The two views combine into a clear story:
- The rate comparison tells you whether the hourly cost moved.
- The efficiency comparison tells you whether the hours moved.
Together, they explain most of the gap between budget and actual. In a tidy workbook, keep them as separate lines so a reader can see which side drove the total.
If your operation does not run at 100% capacity, the principle does not change. Use the standard hours allowed for the actual output achieved, and state that output on the sheet.
Talking to managers about the gap
Once you have the numbers, you will need to explain them to someone who does not live in the spreadsheet. A manager usually wants to know three things: whether the estimate was wrong, whether the cost is under control, and what to change next time. Address all three in plain words.
Start with the verdict on the estimate. If the standard rate was built on a reasonable activity level and the actual rate moved for a reason you can name, say so. A clear cause is more useful than a general statement that costs were high. Name the input that changed, the price or usage that moved, and the period where it happened.
Then describe the control question. A higher actual rate is a warning, not a verdict. It tells you to look at suppliers, usage patterns, or scheduling. A lower actual rate is not automatically a success, since it may reflect deferred spending or overstated hours. Say which of these you checked and which you have not yet verified.
Finally, offer a concrete next step. You might recheck the activity basis, review the consumable usage behind the overhead, or test the rate against the next two periods before you change the standard. Avoid promising a fix you cannot yet support. A cautious plan the data can confirm is more credible than a bold plan the next month undoes.
Step-by-step: compare your own numbers
Use this sequence for any cost center and any period:
- Pull the standard variable overhead rate from the flexible budget, and write down the activity level it assumes.
- Total the actual variable overhead for the same cost center and period, applying your cutoff rule.
- Total the actual hours worked on the same activity basis as the budget.
- Divide actual overhead by actual hours to get the hourly actual rate.
- Compare the actual rate with the standard and note the hourly difference.
- Find the standard hours the work should have taken for the actual output achieved.
- Compare actual hours with standard hours and note any difference.
- Write one sentence on the likely cause and one on what you will check next time.
Common mistakes to avoid
Several errors appear again and again in overhead comparisons. The first is mixing total and variable rates. A total overhead rate includes fixed costs, so it will not match a variable-only figure. Keep the two on separate lines and label them clearly.
The second is using different hour bases. A budget built on machine hours cannot be compared directly with actual direct labor hours. If the basis changes, restate the comparison before drawing any conclusion.
The third is forgetting the capacity assumption. The 90% example concerns total overhead containing fixed costs, and does not demonstrate a variable-rate change with volume. Different activity levels alone do not invalidate a variable-rate comparison or establish the cause of a difference.
The fourth is rounding too early. The standard overhead rate in the 90% example appears as $5.33 (rounded). Carry full figures through your calculations and round only in the final presentation, because early rounding can make a small difference look larger or smaller than it is.
The fifth is trusting a single period. One month can mislead in either direction. Several periods give a far more reliable picture of how the actual rate behaves relative to the standard.
What to do with the result
Once the comparison is clear, let it change your behavior. If the actual rate runs above the standard for several periods, investigate the prices and usage of the consumables and utilities behind the overhead. Ask whether supplier terms have changed, whether a machine is running less efficiently, or whether waste has grown. Those answers point to specific fixes.
If hours run consistently above the standard, the labor or machine standard may be too tight, or the process may need attention. A standard the work cannot meet will produce a permanent variance, and pressure on the team will not make it disappear. Revisit the standard with the people who do the work before you blame them.
If the actual rate runs consistently below the standard, confirm that nothing is being deferred or missed before you raise margins on your bids. A saving that reverses later is not a saving. Once you have verified the trend, you can adjust the standard with confidence.
Then revise the estimate. Use the most recent reliable actual rate as a check on the next budget, not as a replacement for it. Keep the activity level with every rate you use, so the next reader knows exactly what the estimate assumed. Review markup and margin rates before changing bid margins.
What to do today
Choose one closed period and run the sequence above. Record the rate difference and the spending entry you will check first. Use the construction estimate audit when carrying the result into a bid.
Common questions
How do you calculate the actual variable overhead rate?
Divide actual variable overhead by actual hours worked on the budget's activity basis.
Does higher activity require a higher variable rate?
No: total variable overhead can rise with hours while the hourly variable rate stays constant.
Which hours belong in an efficiency comparison?
Compare actual hours with standard hours allowed for the actual output achieved.