Employer Details

Financial analysis before discontinuing a product line: 3 costs

When a product line shows a loss on the monthly report, closing it can look like the obvious fix. A financial analysis before discontinuing a product line tests that instinct by asking what actually changes in cash and profit after the line stops. Three costs decide the answer more often than the report line does, and they are easy to miss in a standard report.

Set up the comparison before you count any cost

Start by writing down the two futures you are comparing. The first is the company that keeps the line for the next twelve months. The second is the company that stops it, with a stated date and a clear list of what happens to each customer, contract, and employee tied to that line. Many weak comparisons skip this step and set the line’s past results against an imagined future with no costs at all.

Choose a review window long enough to show the real effect. A line with seasonal sales or long supplier terms can look fine in one month and weak across a full year, so pick a horizon that covers the whole cycle. Use the same horizon for both futures, and keep the assumptions in one table so the next reader can change a single number and see the result.

Next, separate the figures you have from the figures you are estimating. Revenue and direct cost by product usually come from sales and inventory records. Shared costs, such as a warehouse lease or part of a finance team’s time, often come from allocations. Mark allocations as estimates. A useful test is to ask whether a cost will still be on the books if the line closes tomorrow. If the answer is yes, it does not belong in the savings column.

Build a cash view beside the profit view. Profit answers whether the line earns more than it uses. Cash answers whether the company can pay its bills during the transition. A line can be profitable on paper and still tie up money in inventory that sells slowly. Keeping both views in front of the group stops one number from making the decision for everyone.

Show your working. Write each assumption next to the number it drives, and name the source: the sales report, the purchase orders, or the lease. A reader who disagrees should be able to find the one assumption to challenge without rebuilding the whole model. The same structure can be reused when the next line comes up for review, which saves time and keeps the reasoning consistent.

Decide who signs off on the assumptions before the numbers are final. If the sales lead and the controller see different revenue for the same line, the decision will stall in the meeting instead of being settled at the table. A short written note on who owns each figure prevents most of that delay.

Cost one: the contribution the line stops producing

The first cost is the money the line adds to the business before fixed costs are paid. Analysts call this contribution margin: revenue minus the costs that rise and fall with each unit sold, such as materials, freight, packaging, and sales commissions. When the line closes, that contribution disappears. It is the amount the rest of the business must replace before the line has hurt the company at all.

Consider a hypothetical company with one line that brings in $180,000 of revenue a year. Its variable costs total $120,000, so its contribution is $60,000. That $60,000 is what the rest of the company uses to pay rent, salaries, software, and insurance. Losing it is a real cost, even though it never appears in the accounts as a line called lost sales.

A common mistake is to treat the full revenue of a line as the amount at risk. Revenue overstates the loss when the line carries high variable costs, and it understates the loss when the line sells alongside other products. If some buyers of the line would have bought a second item from you, the lost contribution includes that second sale too. Ask the sales team which customers would move to another product, and how often that has happened before.

Check whether the contribution is stable. A line with a few large customers can lose most of its contribution if one contract ends, and that risk can make the line look better or worse than its average. Look at contribution by month or by quarter across at least one full cycle. A single strong month is weak evidence for keeping a line, and a single weak month is weak evidence for closing it.

Ask what must be true for the line to be worth keeping. You might need prices to rise a small amount, material costs to fall, or volume to grow with the same sales effort. Write those conditions as tests with dates. If they are plausible and can be checked within the review window, the line deserves a trial before it is closed. If they depend on hope, the lost contribution is the honest number to compare against.

Cost two: overhead that stays behind after the line closes

The second cost is the part of shared overhead that does not leave with the line. Most companies carry costs that serve several products at once: the warehouse, the accounting team, the ERP license, the insurance policy, and the account manager who handles several lines. Closing one line rarely removes these costs in full, and sometimes it removes none of them.

The symptom most teams notice first looks like this. After overhead is spread across all lines by sales share or headcount, one line shows a loss, and leadership asks why the company keeps it. The likely cause is that the allocation rule gave the line costs that would stay regardless of the decision. The correction is to separate avoidable costs from unavoidable ones before the line is judged.

Continue the hypothetical example. Suppose the same line carries $75,000 of allocated overhead. On the report, it shows a loss of $15,000: $180,000 of revenue, minus $120,000 of variable costs, minus $75,000 of allocated overhead. Only $15,000 of that overhead is truly avoidable, perhaps a packaging contract and a part-time receiving role. The other $60,000 stays. Closing the line removes $60,000 of contribution and saves $15,000 of overhead, which leaves the company about $45,000 a year worse off.

Avoidable does not mean easy. A cost can be avoidable in principle and still take months to remove, such as a lease with a fixed end date or a service contract with notice terms. List each overhead item with three columns: the amount, the earliest date it can stop, and who has the authority to stop it. A cost that cannot stop before the next review should be treated as a stranded cost for the first year, not as a saving.

Shared staff are the hardest part to judge. A bookkeeper who splits time across three lines does not become free when one line closes. The time moves to the other lines, and the company may need to pay for it differently. Ask the team to estimate hours per line for the last quarter, then compare those hours with what they expect after the change. The difference in hours, not the headcount on the org chart, is the real saving.

Watch the cost of the change itself in shared systems. Removing a product from an inventory module, a price list, or a subscription may require changes in the ERP or the accounting software, such as NetSuite, Sage Intacct, SAP S/4HANA, or QuickBooks. That work takes staff time and sometimes outside help. It belongs in the overhead analysis because it is a cost that stays until someone finishes it.

Cost three: exit costs and cash that arrives late

The third cost is what you pay to stop, and it usually lands in a different month from the savings. Exit costs include inventory write-downs or clearance sales below cost, contract termination fees, return and warranty obligations for products already sold, severance, and the expense of notifying customers and suppliers. Because many of these costs are one-time, they are easy to leave out of an annual view, yet they can be large enough to change the decision.

Take the hypothetical line again. Suppose it holds inventory that cost $20,000 but could sell for only $8,000 in a clearance, which creates a $12,000 write-down. The supplier contract also requires a final order of $10,000 that cannot be cancelled. Together those two items add $22,000 of one-time cost before any severance or outsourced CFO support in Massachusetts fees. The number is small enough to ignore in a strong year and large enough to matter in a tight one.

Cash timing is the second part of this cost. A discontinued line may still have receivables to collect, returns to process, and inventory to sell off over several months. Cash can arrive well after the profit appears on paper, and the company may need to fund the transition from reserves or a credit line. Map expected cash by month for the twelve months after closure, and mark the lowest point, because that is where the risk sits.

Legal and employment notices can change the timeline. The federal WARN Act can require advance notice for certain mass layoffs, and Massachusetts and other states have their own notice rules. Customer and supplier contracts can also set notice periods. These are questions for counsel, and they can decide whether a closure takes one quarter or three.

Revenue timing can also differ when a line is bundled. If the discontinued product was sold with a service plan, a multi-year contract, or a bundle, ASC 606 requires the transaction price to be allocated across the performance obligations. Closing the line may change revenue already recognized or still deferred. Ask the controller how the remaining contracts will be recognized, so the forecast does not show revenue the accounting will not outsourced CFO support in Massachusetts.

Put exit costs in the same table as the other two costs, with dates. A one-time cost in the first month belongs in that month’s cash view, even if the annual profit view that the board prefers leaves it out. That way the decision shows the full effect, and the group can judge whether the first year’s dip is acceptable instead of discovering it later.

Working capital and the cash view after the decision

The symptom to watch after closure is simple: profit improves on the report, but cash feels tighter than expected. The likely cause is working capital, the gap between what the business has tied up in current assets and what it owes in current liabilities. A line’s inventory, receivables, and payables do not stop on the same day, so the cash effect unfolds over several months.

Imagine a line with raw materials that will be used up in a final production run, customers who pay on 30-day terms, and suppliers who expect payment on time. Closing the line frees the inventory once it is sold or written off, but the supplier bills may arrive before the last customer payments do. The gap between those two dates is the working capital need, and it can be larger than the profit change suggests.

A weekly or monthly cash forecast for the next twelve months makes that gap visible. Start with known receipts and payments, then add the expected timing for final sales, returns, collections, and supplier settlements. Compare the forecast with the minimum cash the company needs for payroll and rent. If the forecast dips below that line, the team has time to arrange a credit line or to change the order schedule before the problem arrives.

Check the loan agreements too. Many lenders set borrowing bases tied to receivables and inventory, and closing a line can shrink the collateral that supports a credit facility. A smaller borrowing base can reduce available cash even if the business is performing well. Ask the lender how the change will be treated, and get the answer in writing before the closure date, not after.

Set a decision trigger in advance. For example, the group might agree that if projected cash falls below an internal threshold in any month, the team will delay a supplier order, offer a clearance, or pause the closure step that releases more inventory. The threshold is a company choice, not a standard figure. Writing it down before the change prevents the first tight month from turning into an argument about whether the decision was wise.

Reporting and controls that keep the decision honest

After a line is discontinued, the old numbers can keep showing up in unexpected places. The sales team may keep quoting it, the chart of accounts may still carry its cost center, and the inventory system may keep a reorder rule for a product nobody sells. The likely cause is that the decision was made in a meeting but never carried into the systems. The correction is a short closure checklist owned by one named person.

Start with the chart of accounts. Retire or relabel the cost center, reassign any shared costs that now belong to the remaining lines, and set a rule for how new expenses are coded. In QuickBooks, NetSuite, Sage Intacct, or SAP S/4HANA, the setup differs, but the principle is the same: a closed line should not keep attracting new costs by default. Document the change with the date and the reason.

If your operations follow ISO 9001 or a similar set of documented procedures, treat the closure as a controlled change. Record the product removal, the customer notices, the inventory disposal, and the supplier cancellations in one change record. That trail helps auditors, lenders, and future board members understand what happened and why, without relying on memory.

Build internal controls around the closure itself. Write-downs, supplier cancellations, and severance payments should need two approvals, with the amounts and reasons recorded. Clearance prices should be checked against the cost basis before they are offered. These controls are not about distrust. They make sure the one-time costs in the analysis match the costs that actually hit the books.

Plan the board report now, not after the change. Show contribution before and after the decision, the one-time costs by month, the stranded costs, and the cash low point, with estimates marked as estimates. Schedule a review at six and twelve months to compare actual results with the forecast. That review is where you learn whether the analysis was right, and it improves the next decision on a different line.

Questions to bring to the next meeting

A good analysis should make the next question easier to ask. Before the group votes on a closure, bring a short list of questions that anyone at the table can answer. The list below is useful for a business weighing a closure, and it works the same way for a nonprofit that earns revenue from a program line with its own costs.

1. Which costs will still appear on the books in twelve months if the line closes, and who owns each one?
2. What is the contribution margin over a full business cycle, and which customers would buy a different product instead?
3. Which inventory, contract, and lease commitments must be paid or fulfilled before the line can stop?
4. What is the lowest projected cash balance in the twelve months after closure, and what would trigger a new decision?
5. Which notices are required for customers, suppliers, and employees, and when does each one need to go out?
6. How will the closure appear in the chart of accounts, the ERP, and the board report, and who approves the change?
7. When will the team compare actual results with the forecast, and who will report any gap?

Ask the questions in order, and ask for the answer in writing. If a question cannot be answered, mark it as an open item with an owner and a due date. An open item is not a failure. It is a clear sign of what the group still needs to know before deciding, and it prevents the decision from resting on a number nobody checked.

Be careful with the answers that sound confident but rest on a single source. A forecast built only from last year’s sales can miss a supplier price change or a customer who is about to leave. Ask where each figure came from, and whether someone outside the original analysis has looked at it. Fresh eyes often find the cost that everyone assumed was already covered.

Keep the meeting focused on decisions, not on who built the spreadsheet. The purpose of the questions is to test the reasoning. If the answers show that the line is worth keeping under a clear condition, the group should record that condition and set a date to check it. If the answers show that closure is the better path, the group should record the costs it accepts and the cash plan that supports them.

What to confirm with a professional before you decide

This article is written as an independent guide, not as advice from a qualified adviser. Before a product line is discontinued, confirm the key points with the professionals who can take responsibility for them. Their answers may change the numbers in this analysis, sometimes a lot, so treat their input as part of the model rather than a formality at the end.

• How inventory write-downs, clearance sales, and disposal costs are treated for tax purposes in your jurisdiction.
• Whether contract termination terms, minimum purchase commitments, and notice periods are enforceable as written.
• Which federal and Massachusetts employment notice rules apply to any layoffs tied to the closure.
• How lender covenants and the borrowing base change when receivables or inventory shrink.
• How ASC 606 applies to any bundled products, service plans, or multi-year contracts linked to the line.

If you are considering outside finance support for this work, a fractional or interim outsourced CFO support in Massachusetts may help build the analysis and run the cash forecast. Ask for the scope in writing, including the deliverables, the review points, and how the work fits your company’s stage. Ask what the engagement will not cover, and who on your team will own the decisions afterward. Those answers tell you more about fit than any general description of the service can.

Make the final decision only when the three costs are on the table together: the contribution you give up, the overhead that stays, and the exit costs and cash timing that follow. A closure that looks sound on one of those costs can fail on the other two. When the professionals have reviewed the key assumptions and the group has the cash plan in hand, the decision will rest on evidence the whole board can check.