Why Trimming the Fat Requires Smarter Tech

Cutting your product range is a commercial decision. Three conflicting spreadsheets are a weak foundation for making it.

For Singapore retailers, F&B operators and service businesses, a larger catalogue can mean more stock, more preparation and more operational complexity. Some offerings earn their place. Others consume cash or staff time without making a useful contribution. The challenge is knowing which is which before removing a product that customers value. A custom inventory and sales-tracking web app can connect sales, costs and stock movement around the metrics your business actually uses. This article explains how to build that view, test whether a small share of offerings drives most of your contribution profit, and turn the findings into a controlled decision.

Contents

• What the retailer cuts actually show
• Why scattered spreadsheets make cuts risky
• Test the 80/20 pattern instead of assuming it
• Build the profitability view your business needs
• Connect inventory to actual demand
• Apply the same discipline to services
• Make a reduction decision with context
• What a custom dashboard costs and takes
• Common mistakes
• Decision checklist
• FAQ
• Build a dashboard around your business

What the retailer cuts actually show

Fewer offerings can create a clearer commercial focus, but a headline percentage is not a target for your business.

Under Armour's fiscal 2026 annual report says it reduced SKUs by approximately 25% over the preceding two years. The company links fewer products and more concentrated demand to its strategy for healthier economics and clearer brand positioning. A SKU is a stock-keeping unit, often representing a particular product variant rather than an entire product family. Under Armour's fiscal 2026 annual report

Retail Insider reported on 4 September 2026 that Lululemon had reduced store SKUs by approximately 15%, with additional reductions and localised assortments being tested. The report describes a less-dense shopping environment and more focused presentation. That is a different scope from Under Armour's programme. Retail Insider's Lululemon report

Neither example proves that cutting the same percentage will improve a Singapore SME's profit. The relevant question is which offerings justify their stock, space and operating effort in your business.

Why scattered spreadsheets make cuts risky

You need sales, costs and operational context to refer to the same offering and the same period.

One spreadsheet may contain POS sales. Another holds supplier costs. A third tracks stock or staff time. If product codes differ, returns are missing or a cost update has not reached the report, the apparent winner may be wrong.

Common discrepancies include bundles recorded as single items, online and outlet prices mixed together, discounts excluded from sales totals and old material costs applied to current orders.

A custom app can reconcile those inputs around stable product, service, order and outlet identifiers. It should show unmatched records and missing costs explicitly, rather than silently treating them as zero.

Keep the source transaction available for drill-down. A useful dashboard lets a manager trace an unusual result to the sale, return, stock movement or job record that created it.

Spreadsheets remain useful for analysis. The problem is an unmanaged chain of manual copies with no agreed definitions or reconciliation process.

Test the 80/20 pattern instead of assuming it

Treat “20% of offerings generate 80% of profit” as a hypothesis. Calculate the actual distribution from your own records.

First define what you mean by profit. For assortment decisions, a contribution view can be useful: net sales less attributable variable costs. It is not necessarily the same as audited net profit or a fully allocated operating margin.

A proposed calculation is:

Contribution by offering
  = net sales after discounts and returns
    − attributable product or delivery costs
    − attributable variable transaction and fulfilment costs

For services, include relevant variable labour and materials under a consistent policy. Show shared overhead separately or allocate it transparently. Allocating a fixed cost to a product does not mean that cost disappears when you remove the product.

Rank offerings by contribution and calculate their cumulative share. An illustrative Singapore business might find:

In this constructed example, the first group produces 80% of contribution. It is not a benchmark or a Zimozi client result. Your distribution could be quite different.

Show loss-making offerings separately. Negative contributions can make cumulative percentages exceed 100%, and a zero or negative total makes the simple percentage view misleading. Do not force every business into an attractive Pareto chart.

Build the profitability view your business needs

Choose metrics that support a decision, then document how each one is calculated.

For a Singapore retailer operating an outlet and an online channel, a useful view might include:

The dashboard should identify its data cut-off and last successful refresh. When a connector fails, retain the last valid view with a freshness notice. A current-looking number based on a stale extract can encourage the wrong decision.

Separate confirmed, provisional and incomplete results. A product with unknown landed cost should not appear alongside fully costed products without a visible qualification.

Do not change customer-facing availability automatically because a rank falls below a threshold. Let an authorised person review the evidence and approve the assortment change.

Connect inventory to actual demand

Low sales can indicate weak demand, but they can also indicate a stockout, a seasonal item or an incomplete product range.

For apparel, inspect size and colour variants as well as the parent product. Removing a slow size can undermine an otherwise strong range. For F&B, consider ingredient sharing, preparation waste and menu combinations before judging each item independently.

A multi-outlet dashboard should show transfers, stock availability and demand by outlet. A product may sell poorly at one location and perform well at another. Moving stock may be preferable to discounting it across the whole business.

Track opening stock, receipts, transfers, sales, returns, adjustments and closing stock under agreed rules. Reconcile the result with the operational stock system before using it for replenishment.

For practical coordination across Singapore outlets, see multi-outlet inventory and rostering.

Apply the same discipline to services

A service catalogue can hide operational complexity just as a product catalogue can hide excess stock.

A Singapore maintenance company might compare service packages using actual parts, travel, variable labour and rework. A professional-services firm might examine delivery effort, third-party expenses and repeat revisions under the agreed commercial terms.

Use completed-job records and approved scope changes rather than the quoted hours alone. A package that looks profitable in the price list may consistently require extra work that is never billed.

Also inspect dependencies. A low-contribution introductory service may lead to a valuable recurring contract. The dashboard should expose that relationship where reliable data exists, rather than automatically recommend removing it.

These are proposed analytical approaches, not claims about particular businesses. The cost definitions need to fit the way your operation delivers and records work.

Make a reduction decision with context

Classify the decision as keep, improve, reprice, relocate, reduce purchasing or retire. Cutting is only one available action.

Before retiring an offering, review customer demand, contractual commitments, supplier constraints and whether it supports another sale. Distinguish poor economics from poor execution.

Run a bounded test where possible. Reduce purchases or adjust a particular outlet's assortment, then monitor contribution, availability and related sales. Compare similar periods and account for promotions and seasonal effects.

Keep the decision, rationale and approval in the app. That creates a record of what changed and why, making it easier to review the result without reconstructing old spreadsheets.

A dashboard should help you make a decisive choice with evidence. It should not pretend that a rank alone captures every commercial consequence.

What a custom dashboard costs and takes

The work is usually data integration and metric design as much as visualisation.

Scope the source systems, identifiers, history, cost rules and refresh requirements first. The app may need POS, ecommerce, inventory, purchasing and service-record integrations, depending on the operation.

Include access controls, reconciliation tools, historical corrections and a clear owner for each metric. Keep customer-level information limited to what the decision requires. Product-level analysis often does not need a copy of every customer detail.

A generic tool may be sufficient if it supports your definitions and connectors reliably. A custom web app becomes more useful when bundles, outlet transfers, service costs or approval rules are poorly represented by standard reports.

Compare implementation, hosting, support, connector maintenance and staff effort over the same period. A custom dashboard has ongoing costs; its value comes from better decisions and reduced manual reconciliation, not from being free to operate.

See choosing an ecommerce platform in Singapore for related integration considerations.

Common mistakes

• Assuming high revenue means high profit.
• Cutting 25% because a large retailer did so.
• Forcing an 80/20 result instead of calculating the actual concentration.
• Treating missing costs as zero or mixing inconsistent reporting periods.
• Ignoring stockouts, seasonality, bundles and complementary sales.
• Presenting contribution as net profit without explaining the difference.
• Building a polished dashboard without source reconciliation or refresh status.

Decision checklist

• Product and service identifiers match across the source systems.
• Discounts, returns and relevant variable costs are included consistently.
• Missing costs and unmatched transactions are visible.
• Stock availability, seasonality and commercial dependencies have been reviewed.
• Contribution and shared-overhead definitions are documented.
• An authorised person approves the proposed change.
• The test has a baseline, review period and measures of success.

Build a dashboard around your business

Stop relying on generic reports that cannot represent the way your business sells, stocks or delivers its offerings.

Have Zimozi build a custom inventory and sales-tracking dashboard around your unique metrics, so you can make decisive, data-backed decisions. Bring the three spreadsheets, the source systems and the decisions you need to make. We can scope a connected view of sales, costs and demand, with definitions your team can verify.

Discuss your Singapore inventory and profitability dashboard with Zimozi.