Northline Office Supply: Should the Low-Margin Segment Be Cut?
Northline Office Supply is a regional distributor with $4.2 million in annual revenue and $680,000 in fixed operating costs (warehouse lease, salaried management, insurance, and the ERP subscription). Its 46 employees serve three customer segments. K–12 school districts generate $1.8 million in revenue at a 28% contribution margin; healthcare clinics generate $1.3 million at 35%; small law firms generate $1.1 million at 42%. Contribution margin is calculated after product cost, outbound freight, and sales commissions. K–12 orders average $310, arrive by fax or phone, and carry 62-day days sales outstanding, versus 34 days for the other segments; 1.5% of K–12 receivables are written off. A newly hired sales manager argues that Northline should exit K–12 because it has the lowest margin and the slowest payment, and redeploy the two reps who cover schools. The owner wants a decision before the next fiscal year and has asked for an analysis rather than an opinion.
1. Should Northline exit the K–12 segment? Base your recommendation on segment contribution and avoidable fixed costs, and name the additional information that could reverse your decision.
Read the worked answer
Segment contributions are K–12 $1.8M × 28% = $504,000; clinics $1.3M × 35% = $455,000; law firms $1.1M × 42% = $462,000. Total contribution is $1.421M against $680,000 of fixed costs, so the company earns about $741,000. The $680,000 is largely shared and does not disappear if K–12 exits. The decision therefore turns on avoidable fixed costs. If the two school reps' base salaries and benefits total $150,000 and a dedicated inside support role is $55,000, avoidable costs are $205,000. Exiting would cut operating income by $504,000 − $205,000 = $299,000. Even if freed warehouse space could be subleased for $40,000, the net loss is about $259,000. Recommendation: retain K–12 and fix cost-to-serve rather than exit. Information that could reverse this: a genuine capacity constraint, such as a full warehouse and law-firm demand that could profitably use the space; K–12-specific equipment or inventory that cannot be redeployed; or a credible 12-month plan to replace $1.8M of revenue at a higher margin. Lowest margin is not the same as losing money.
2. The sales manager proposes a 4% K–12 price increase and a $500 minimum order. Estimate how much K–12 revenue Northline could lose before the change reduces contribution below today's level, and identify the non-financial risks.
Read the worked answer
A 4% increase adds $72,000 of revenue if volume holds. Variable costs are 72% of the old price, so at the new price contribution is (1.04 − 0.72) / 1.04 = 30.8% of revenue. To preserve $504,000 of contribution, K–12 revenue must stay at $504,000 / 0.308 = $1.64M. That is a decline of about $162,000, or 9%. The change can therefore absorb roughly a 9% revenue loss before it is worse than today. That sounds like room, but the $500 minimum will push some small districts out entirely, and schools buy on annual bids, so a mid-year increase may not be implementable. Non-financial risks include public procurement rules that require re-bidding, a competitor using the increase as an opening, and reputational damage in the communities where employees live. There is also a possible benefit: districts may consolidate orders through cooperatives, lowering cost-to-serve. A safer path is a 2–3% increase limited to non-bid accounts, paired with the minimum-order pilot, and tracking order size and churn for two quarters before a broader rollout.
3. Quantify the annual cost of K–12 payment terms and bad debt, and recommend a cost-to-serve change that pays for itself.
Read the worked answer
Receivables at 62 days are $1.8M × 62/365 = $305,753; at 34 days they would be $167,671. The incremental investment is $138,082. At an 8% cost of capital, carrying cost is about $11,000 per year. Bad debt is 1.5% × $1.8M = $27,000. The identifiable cost of the current payment pattern is therefore about $38,000, or 7.5% of K–12 contribution and roughly 2% of segment revenue. That does not justify exiting a $504,000-contribution segment, but it does justify changing terms. A 1.5% prompt-pay discount for payment within 10 days would cost at most $27,000 if every district took it, less than the $38,000 current cost. A 1% discount would cost $18,000 and save more. Pair the discount with e-invoicing, purchase-order requirements, and credit limits. Track DSO, write-offs, and discount participation monthly. The point is to price the service level: districts that want 62-day terms should pay for them through price or lose the discount, while districts that pay promptly should not subsidize the rest.