Monthly P&L Variance Analysis: Budget vs Actual Costs
Lesson Contents Overview
Learning Objectives
Comprehensive Technical GuidanceTextbook & Training SOP
Monthly P&L Variance Analysis: Budget vs Actual Costs
1. Why the Monthly P&L Comparison Is the Factory Control Panel
At the end of every month, a garment factory produces two numbers that matter more than any other pair: the profit it planned to make, and the profit it actually made. When those two numbers differ, the difference is not bad luck and it is not a mystery. It is a variance, and variance analysis is the method that explains it, line by line, in taka, so that management can act instead of guess.
Without variance analysis, a factory lives on impressions. Sales felt strong, so the month felt good. The bank balance did not rise, but nobody can say why. With variance analysis, the same month becomes a precise story: sales beat budget by BDT 2,500,000, which was favourable, but fabric overspent by BDT 2,350,000, labour by BDT 600,000, and overhead by BDT 250,000, so profit fell by BDT 950,000 despite the strong sales. That story names the problem, sizes it, and points at the department that must fix it.
The monthly profit and loss statement is therefore the factory control panel. The budget column is the plan. The actual column is reality. The variance column is the gap between them, and the favourable-or-adverse label on each variance tells management whether that gap helped or hurt. A factory that reads this panel monthly, and acts on what it shows, learns its true cost behaviour within a quarter. A factory that does not read it keeps repeating the same month with different dates.
2. Building the Budget-Versus-Actual Statement
The statement itself is simple, and its simplicity is a strength. List sales first, then every cost line: fabric, trims, labour, overhead, and commercial costs. Show three columns beside each line: budget, actual, and variance, where variance equals actual minus budget. Add a fourth column for the variance percentage, which is variance divided by budget, and a fifth column for the favourable-or-adverse label. One page, eight lines, five columns, and the whole month is visible.
The budget must be frozen before the month starts. This rule is non-negotiable. A budget that is revised mid-month to match reality will always show zero variance, because the yardstick was moved to meet the measurement. If a buyer changes an order mid-month, record the change as a separate approved revision, keep the original budget visible, and report variances against both. The original budget shows what was planned, the revised budget shows what was re-planned, and the difference between them shows the effect of the buyer change. Hiding that difference inside a rewritten budget destroys the most useful information the report can provide.
Actual figures must come from source records, not from estimates. Sales come from invoices issued. Fabric cost comes from goods-received notes and stores issue records. Labour comes from payroll. Overhead comes from bills paid and accruals booked. A variance report built on estimated actuals is an estimate of an estimate, and no manager should act on it. Close the books properly, even if it takes two extra days, because a late accurate report is worth more than an early invented one.
3. The Labelling Rule That Causes the Most Errors
Variance labelling has one rule, and getting it backwards is the most common error in factory variance reporting. For sales lines, actual above budget is favourable, because more sales mean more profit. For cost lines, actual above budget is adverse, because more spending means less profit. The variance number itself is always actual minus budget, so a cost overspend produces a positive number that must be labelled adverse. A reader who assumes that positive means good will read a bad month as a good month.
Work the rule through the illustrative example used in this lesson. Budgeted sales are BDT 50,000,000 and actual sales are BDT 52,500,000. The variance is plus BDT 2,500,000, and because this is a sales line, it is favourable. Budgeted fabric cost is BDT 26,000,000 and actual fabric cost is BDT 28,350,000. The variance is plus BDT 2,350,000, and because this is a cost line, it is adverse. Same sign, opposite meaning. Every variance report should print the label in words beside every number, because a report that relies on readers remembering the sign convention will eventually be misread by someone important.
The profit variance ties the whole statement together. Actual profit is BDT 1,050,000 and budgeted profit is BDT 2,000,000, so the profit variance is negative BDT 950,000, adverse. The same figure comes from combining the other variances: favourable sales variance of BDT 2,500,000 minus adverse cost variance of BDT 3,450,000 equals negative BDT 950,000. When the two routes to the profit variance agree, the statement cross-foots, and the reader can trust it. When they disagree, an arithmetic error is hiding somewhere, and the report must not be issued until it is found.
4. Percentages Reveal What Absolute Numbers Hide
A variance of BDT 50,000 looks trivial next to a variance of BDT 2,350,000, and a report that shows only absolute amounts will direct all attention to the large lines. Percentages correct that bias. In the example, commercial costs overspent by BDT 50,000 against a budget of BDT 1,000,000, which is 5.00 percent. Fabric overspent by BDT 2,350,000 against a budget of BDT 26,000,000, which is 9.04 percent. Profit fell by BDT 950,000 against a budget of BDT 2,000,000, which is 47.50 percent. The profit percentage is the most alarming number in the report, and it is invisible in absolute terms until you compare profit against its own budget.
Rank adverse variances twice: once by taka amount, to find the largest money leaks, and once by percentage, to find the worst control failures. A small line with a 20 percent overrun may signal theft, waste, or a broken approval control, and it deserves investigation even though its taka amount is modest. A large line with a 2 percent overrun may simply reflect a slightly wrong budget. Investigating only by amount finds the money; investigating by percentage finds the problems. Do both, every month.
5. Splitting Fabric Variance Into Price and Volume
The largest variance in the example is fabric, at BDT 2,350,000 adverse, and stopping there would lead management to blame the purchasing team for paying too much. The price-versus-volume split shows the opposite story. Budgeted production was 80,000 garments at a fabric cost of BDT 325.00 per garment, giving BDT 26,000,000. Actual production was 90,000 garments at BDT 315.00 per garment, giving BDT 28,350,000. The factory actually paid less per garment than budgeted, not more.
The price variance is actual quantity times the price difference: 90,000 times (315.00 minus 325.00), which is 90,000 times negative 10.00, which is negative BDT 900,000, meaning BDT 900,000 favourable. The volume variance is the quantity difference times the budgeted price: 10,000 times 325.00, which is BDT 3,250,000 adverse. Net variance is 3,250,000 adverse minus 900,000 favourable, which is BDT 2,350,000 adverse, matching the total fabric variance exactly. The split proves that the fabric overspend was caused entirely by producing 10,000 extra garments, and that purchasing actually saved money on price.
This changes the management response completely. Blaming purchasing would punish the team that saved BDT 900,000. The correct response is to ask why 10,000 extra garments were produced without a revised budget, and whether those garments were ordered, saleable, or simply built up as finished stock. The split also explains the labour and overhead overspends, because extra production consumes extra labour hours and extra overhead. One split, correctly done, explains three variances at once.
6. A Second Split: Labour Variance and the Efficiency Question
The same splitting logic applies to labour, with one extra layer. Labour cost variance splits into a rate variance, caused by paying a different wage than budgeted, and an efficiency variance, caused by using more or fewer labour hours than the standard for the output achieved. Suppose the factory budgeted CM labour at BDT 95.00 per garment for 10,000 garments, giving BDT 950,000. Actual labour was BDT 102.00 per garment for the same 10,000 garments, giving BDT 1,020,000. The total labour variance is BDT 70,000 adverse, which is 7.37 percent of budget.
If the wage rate was unchanged, the whole BDT 70,000 is an efficiency variance: the factory used more labour minutes per garment than standard, which points to line imbalance, rework, absenteeism cover, or a style harder than the SMV assumed. If the wage rate rose, part of the variance is a rate variance and only the remainder is efficiency. The split matters because the fixes are different: a rate variance is a commercial or HR decision, while an efficiency variance is an IE and production problem. Reporting a single labour variance without asking which part is which leaves management guessing at the remedy.
7. From Report to Action: The Three-Variance Rule
Set an investigation threshold in advance, so that the meeting does not argue about what counts as significant. A workable threshold for a mid-sized factory is any adverse variance above BDT 100,000 or above 5 percent of its budget line, whichever is larger. Below the threshold, note the variance and move on. Above it, investigate. The threshold keeps the meeting focused on the variances that move profit, while the percentage test catches small lines with serious control problems.
8. What Variance Analysis Cannot Do
Variance analysis explains the past, it does not predict the future, and it does not fix anything by itself. A variance report can show that fabric overspent by BDT 2,350,000, but only a merchandiser can change the ordering process, only an IE manager can fix line efficiency, and only the owner can decide whether to accept a lower-margin order. The report is a diagnostic tool, not a treatment. Factories that confuse the two produce beautiful reports and unchanged results.
Variance analysis also depends entirely on the quality of the budget. A budget built on hope will show adverse variances every month, and after a few months nobody will take them seriously. A budget built on planned volumes, current prices, and realistic efficiency will show variances that mean something. Spend as much effort building the budget as analysing the variance, because a bad budget makes the whole exercise theatre.
9. Summary and Checklist
Build the monthly statement with budget, actual, variance, variance percentage, and a favourable-or-adverse label on every line. Label sales and cost lines by opposite rules: higher sales are favourable, higher costs are adverse. Cross-foot the profit variance two ways: actual profit minus budgeted profit, and sales variance minus cost variance. Rank adverse variances by amount and by percentage. Split the largest material variance into price and volume, and the largest labour variance into rate and efficiency. Apply the three-variance rule at every monthly meeting, with a named owner and deadline for each action. A factory that follows this checklist will know, within a quarter, exactly where its profit leaks, and more importantly, exactly who is going to stop each leak.
1. Monthly Budget Versus Actual P&L (all figures illustrative)
| Line | Budget (BDT) | Actual (BDT) | Variance (BDT) | Favourable / Adverse | Variance % |
|---|---|---|---|---|---|
| Sales | 50,000,000 | 52,500,000 | 2,500,000 | Favourable | 5.00% |
| Fabric cost | 26,000,000 | 28,350,000 | 2,350,000 | Adverse | 9.04% |
| Trims cost | 4,000,000 | 4,200,000 | 200,000 | Adverse | 5.00% |
| Labour (CM) cost | 12,000,000 | 12,600,000 | 600,000 | Adverse | 5.00% |
| Overhead | 5,000,000 | 5,250,000 | 250,000 | Adverse | 5.00% |
| Commercial costs | 1,000,000 | 1,050,000 | 50,000 | Adverse | 5.00% |
| Total costs | 48,000,000 | 51,450,000 | 3,450,000 | Adverse | 7.19% |
| Profit | 2,000,000 | 1,050,000 | 950,000 | Adverse | 47.50% |
2. Fabric Price Versus Volume Split (all figures illustrative)
| Element | Budget | Actual | Variance |
|---|---|---|---|
| Garments produced | 80,000 | 90,000 | 10,000 extra |
| Fabric cost per garment (BDT) | 325.00 | 315.00 | 10.00 lower |
| Price variance | (315.00 - 325.00) x 90,000 | BDT 900,000 favourable | |
| Volume variance | (90,000 - 80,000) x 325.00 | BDT 3,250,000 adverse | |
| Net fabric variance | 3,250,000 adverse - 900,000 favourable | BDT 2,350,000 adverse |
Practical Commercial Flow
A woven garment factory budgeted monthly sales of BDT 50,000,000 and total costs of BDT 48,000,000, giving a budgeted profit of BDT 2,000,000. Actual sales were BDT 52,500,000, a favourable variance of BDT 2,500,000. Actual costs were BDT 51,450,000, an adverse variance of BDT 3,450,000, made up of fabric BDT 2,350,000 adverse, trims BDT 200,000 adverse, labour BDT 600,000 adverse, overhead BDT 250,000 adverse, and commercial costs BDT 50,000 adverse. Actual profit was 52,500,000 minus 51,450,000, which is BDT 1,050,000, an adverse profit variance of BDT 950,000. The check is 2,500,000 favourable minus 3,450,000 adverse equals 950,000 adverse.
Factory Real-Life Scenario
Scenario: A knitwear factory in Narayanganj reported a profitable month because sales beat budget by BDT 2,500,000, and the monthly meeting celebrated the sales team. Nobody examined the cost lines until the bank balance failed to rise, and the finance head discovered that fabric, labour, and overhead had all overspent, wiping out the sales gain and cutting profit nearly in half.
Solution: The finance head introduced a one-page budget-versus-actual statement with a variance column and a favourable-or-adverse label on every line, plus a price-versus-volume split for fabric. The split showed fabric prices had actually fallen, and the entire fabric overspend came from producing 10,000 extra garments that had not been budgeted, which also explained the labour and overhead overspends.
Impact: The next budget was built on planned volumes instead of hoped-for volumes, and the monthly meeting changed from celebrating sales alone to reviewing the three largest adverse variances first. Within a quarter, adverse cost variances fell by more than half, because each one now had a named owner and a corrective action.
Commercial Officer Best Practice
Freeze the budget at the start of the month and never revise it mid-month to match reality. A budget that is rewritten to match actual results always shows zero variance and teaches nothing. If the budget was genuinely wrong, note the reason, keep the original for comparison, and fix the next budget instead.
Top Beginner Mistakes to Avoid
- Labelling a cost overspend as favourable because the variance number is positive, which reverses the meaning of the whole report.
- Celebrating a favourable sales variance while ignoring a larger adverse cost variance that wipes it out.
- Revising the budget mid-month to match actual results, which guarantees zero variance and zero learning.
- Reporting only absolute variances, so a small line with a 20 percent overrun hides behind a large line with a 2 percent overrun.
- Producing a variance report that nobody acts on, because no variance has a named owner or a deadline.
Important Commercial & Trade Terminology (5 Terms)
The difference between an actual figure and the budgeted figure for the same line, calculated as actual minus budget.
💡 Note: The number alone means nothing until it is labelled favourable or adverse.A variance that improves profit: actual sales above budget, or actual costs below budget.
💡 Note: On a cost line, a favourable variance means actual spending was lower than budgeted.A variance that reduces profit: actual sales below budget, or actual costs above budget.
💡 Note: On a cost line, any overspend is adverse, even though the variance number is positive.The part of a material cost variance caused by paying a different price per unit than budgeted, calculated as actual quantity times the price difference.
💡 Note: A favourable price variance can hide an adverse volume variance, so always split the two.The part of a material cost variance caused by using a different quantity than budgeted, calculated as the quantity difference times the budgeted price.
💡 Note: Producing extra garments always creates an adverse volume variance on materials, even when the extra output is welcome.Interview Preparation Questions & Answers (4 Questions)
Master these high-frequency interview questions for Commercial Officer, Merchandising, and Export Executive roles.
Profit variance is 1,050,000 minus 2,000,000, which is negative BDT 950,000, so it is an adverse variance of BDT 950,000. Profit below budget is always adverse.
Frequently Asked Questions (4 FAQs)
Clear, beginner-friendly answers to the most common questions about the Commercial Department.
Key Takeaways & Summary Points
Executive Lesson Summary
Monthly variance analysis compares actual profit against budgeted profit, line by line, with every variance labelled favourable or adverse by the correct rule. Sales variances and cost variances have opposite signs for favourability, and the profit variance is the sales variance minus the cost variance. Split the largest material variance into price and volume to find the real cause, rank by both amount and percentage, and turn every significant adverse variance into a named action. A factory that does this monthly learns its true cost behaviour within a quarter.