Executive Costing Reports & Margin Safeguard Policies

Factory management packs usually report totals: total revenue, total cost, total profit. Totals hide the truth that matters most. A factory can report a healthy average margin while several individual orders lose money, because profitable orders subsidise unprofitable ones in the average. By the time the average itself turns negative, the factory has already accepted months of losing work. Executive costing reports exist to prevent that: they show margin order by order, so that a losing order is visible the month it happens, while renegotiation or cost recovery is still possible.

The dashboard in this lesson shows the pattern clearly. Three orders produce a factory margin of 9.92 percent, just below a 10 percent target. The average looks like a small miss. The detail shows a real problem: Order B earns only 7.00 percent, well below the floor, and drags the average down. Without the order-level view, management would see a 0.08 percentage point miss and shrug. With it, management sees an order that must be fixed or renegotiated. That is the entire purpose of executive costing reports.

A margin dashboard has five columns: order, revenue, cost, margin, and margin percentage. Margin is revenue minus cost. Margin percentage is margin divided by revenue. Work through the three orders. Order A: revenue BDT 30,000,000 minus cost BDT 27,000,000 gives margin BDT 3,000,000, and 3,000,000 divided by 30,000,000 is 10.00 percent. Order B: revenue BDT 18,000,000 minus cost BDT 16,740,000 gives margin BDT 1,260,000, and 1,260,000 divided by 18,000,000 is 7.00 percent. Order C: revenue BDT 24,000,000 minus cost BDT 21,120,000 gives margin BDT 2,880,000, and 2,880,000 divided by 24,000,000 is 12.00 percent. Factory totals are revenue BDT 72,000,000, cost BDT 64,860,000, and margin BDT 7,140,000. Factory margin is 7,140,000 divided by 72,000,000, which is 9.9167 percent, shown as 9.92 percent when rounded.

Two reporting rules matter here. First, use realised figures, not quoted figures. Realised revenue is after buyer claims and deductions. Realised cost is after overruns, rework, and currency effects. A dashboard built on quoted figures reports promises, not performance. Second, do not round margin percentages until the final display, and never round away a gap against the floor. A margin of 9.92 percent is below a 10 percent floor, not equal to it, and the shortfall in taka is exact: target margin on BDT 72,000,000 at 10 percent is BDT 7,200,000, actual margin is BDT 7,140,000, so the shortfall is BDT 60,000. Executives should see both the rounded percentage and the exact taka gap.

A margin floor is the minimum acceptable margin percentage for a quotation, set by factory policy. An illustrative policy used in this lesson sets the floor at 10 percent, with three routes: quotations at 10 percent or above are auto-approved by the costing head; quotations from 8 percent to below 10 percent require written approval from the general manager with a reason and a recovery plan; quotations below 8 percent are rejected unless the managing director signs a written exception stating the reason and an expiry date. The exact percentages are illustrative — each factory must set its own floor — but the structure is what matters: every band has a named approver, and no band is self-approved.

The approval route is what turns a floor from a suggestion into a policy. Without it, commercial teams under pressure to fill lines will accept below-floor orders by default, and the floor will exist only in a policy document nobody enforces. With it, every below-floor order creates a visible decision, a named decision maker, and a record that auditors and owners can review. Verbal approvals must never be accepted: a below-floor approval must be a signed note stating the order, the margin, the reason, and the expiry of the exception.

Even well-costed orders overrun. Fabric prices move, wastage exceeds the standard, and a rush order adds overtime. A contingency buffer absorbs normal overruns before they touch margin. The method is to add a small percentage to the cost base before applying margin. Take the cost base of BDT 654.00 carried from the earlier pricing module. A 3 percent buffer adds 654.00 multiplied by 0.03, which is BDT 19.62, giving a buffered cost of BDT 673.62. Applying a 10 percent margin gives 673.62 multiplied by 1.10, which is BDT 740.982, rounded to BDT 740.98 under half-up money rounding. Compare that with the unbuffered price of 654.00 multiplied by 1.10, which is BDT 719.40. The buffer costs the buyer BDT 21.58 per garment and buys the factory protection against a 3 percent cost overrun with margin intact.

The buffer must be disclosed internally as a costing assumption, so that the commercial team understands the true margin structure. It must not be presented to the buyer as a separate charge; it is part of the quoted price. And it must not be used to hide poor costing: a buffer that grows every season because standards are wrong is a signal to fix the standards, not to enlarge the buffer.

When a below-floor order is proposed, the usual argument is volume: accepting more work keeps the line busy and spreads overhead. That argument fails when the additional volume earns below the factory average, because it dilutes the average further. Consider the Dhaka factory in the factory example. The commercial director proposes two more orders from the same buyer at the same 7 percent margin to keep the line busy. Each additional taka of 7 percent revenue pulls the factory average further from 10 percent, so the shortfall grows in taka terms even as revenue grows. Volume compensates for low margin only when the additional volume earns above the average, or when it genuinely reduces fixed cost per unit by enough to lift margins elsewhere — a claim that must be evidenced, not asserted.

The correct response to a below-floor repeat order is renegotiation, cost reduction, or a time-limited exception. In the example, cutting waste reduction worth BDT 360,000 in cost savings raises Order B margin from BDT 1,260,000 to BDT 1,620,000, giving 9.00 percent on revenue of BDT 18,000,000 — still below the floor but materially improved — and the repeat order price is renegotiated with cost evidence. That combination of recovery and renegotiation is how a factory climbs back above its floor.

The monthly margin review follows a fixed agenda. First, present the dashboard and flag every order below the floor and every order within one percentage point of it for watchlist monitoring. Second, for each flagged order, present the recovery plan: what cost reduction or price renegotiation is agreed, who owns it, and by when. Third, confirm that every below-floor order accepted in the month carries a signed exception, and that no exception has expired without re-approval. Fourth, record decisions in the meeting minutes, because margin decisions without minutes are forgotten by the next order.

The review must also track whether flagged orders actually recovered. An order flagged in January, promised recovery in February, and still below floor in March indicates that the recovery plan failed or was never implemented. That pattern escalates to the factory head, just as repeating audit variances escalate. The review is a control loop, not a presentation: flag, act, verify, escalate.

Exceptions are necessary — a strategic buyer, a new product trial, or a line-filling order during a slow season can justify a below-floor acceptance. But an exception that never expires is not an exception; it is a quiet abolition of the policy. Every exception must state the order, the margin, the reason, and an expiry date, normally one order or one quarter. When it expires, the order must be re-approved under the current floor, renegotiated, or declined. A factory that grants permanent exceptions to a favoured buyer will eventually discover that its floor applies to everyone except its largest customer, which is usually the customer whose low margins hurt most.

The single most important number in the costing function is the gap between quoted margin and realised margin. Quoted margin is set at order acceptance. Realised margin is what remains after claims, overruns, rework, and currency moves. A factory that quotes 12 percent and realises 8 percent has a 4 percentage point gap, and closing that gap — through better standards, tighter wastage control, disciplined claims, and currency hedging — is worth more than any single price negotiation. The margin dashboard should therefore show both figures side by side for completed orders: quoted margin, realised margin, and the gap, with the largest gaps investigated first.

This lesson connects directly to the rest of the course. Internal cost audits explain the cost side of the gap. Claim management explains the revenue side. Currency hedging explains the conversion side. Executive reporting is where those three disciplines meet in one page that senior management can act on.

Margin protection is a system, not a slogan. Build a one-page dashboard of realised margin by order. Apply a minimum-margin floor with a signed approval route for every band. Price a contingency buffer into quotations so normal overruns do not erase margin. Escalate below-floor orders with evidence, renegotiate or recover, and let exceptions expire. A factory that enforces its floor order by order will protect its margin in every market condition, while a factory that reports averages and accepts volume at any price will discover its margin only when it is already gone.