Inventory Optimization Pro Back to Get the report Book a free 30 minutes

The business

Northvale Furniture, a maker of chairs, bookcases and cabinets selling to retailers and contract buyers. Eight product lines, one warehouse, month-end done in-house.

What was going wrong

Profit looked fine and cash never did. Reporting landed nearly two weeks after close, by which time the purchasing decisions it should have informed had already been made. Nobody could say which product lines were funding the business and which were quietly consuming it.

CashWorking capitalDead stock

The question it answers

What in this month needs my attention, and what is it worth?

Cash, working capital, dead inventory and cash conversion on one screen, with the exceptions named and ranked instead of left for you to find.

1Where it goes wrong

$264,590 sitting still for 180 days, inside a month that looked fine on the P&L. Found by ranking every exception by what it is worth, not by reading 12 metrics.

2How to fix it

The report opens on the exceptions, every figure traces to the transactions behind it, and it lands days after close instead of 2 weeks.

3The result

Purchasing decisions made on this month's numbers. The dead stock named, priced and on a list with an owner.

It opens on exceptions, not metrics

Most dashboards show you twelve numbers and leave the thinking to you. This one leads with what needs attention this month, and what happens if it is ignored.

Every figure traces back

Each number can be followed to the transactions behind it, so when someone asks where it came from, there is an answer rather than a spreadsheet hunt.

It says what to check next

Each finding carries the next question to ask, which is what turns a report into a decision.

Northvale Furniture CFO Dashboard

v6 keeps the v4 dashboard pages and adds date range, warehouse, and product selectors plus a 36 month forecast horizon on the Forecast tab.
to
Embedded
Executive view
KPI tiles and the executive lists reflect the end of the selected range. Trend charts reflect the full selected range.
Warehouse and product filters affect the Service tab and Forecast tab, plus the forecast and on time items in the executive lists.
Data note
The plan was built on an 8% net margin. The posted books imply for 2025. Both cannot be right, and until that gap is traced, every margin figure on this screen inherits it. This is the kind of thing a close does not catch and a diagnostic does.
Revenue
n/a
Cash
n/a
Working Capital
n/a
Ending Inventory
n/a
Dead Stock 180d
n/a
DIO
n/a

What needs attention

Urgent
    Important
      Risks
        Opportunities

          Drill prompt

          Click a KPI tile to see what questions to ask next.
          Suggested next checks

            Executive trend view

            Cash vs Inventory
            DIO vs Backorders
            Dead Stock vs Carrying Cost
            Production vs Rework Cost
            Cash vs Inventory

            Action plan for the period

            Owner Action Metric Target Due

            Inventory snapshot

            Cash tied up, speed, and loss.
            Turnover and DIO

            Service KPIs

            Warehouse selector changes the trend and the table below.
            On time trend

            Warehouse watchlist

            WarehouseOn timeAvg fulfillment daysCapacity utilizationPick accuracyPack accuracyLocation accuracy

            Forecast summary

            Product selector updates accuracy and the miss list.

            Forecast view

            Forecast accuracy
            Forecast vs actual units
            Units with 36 month horizon
            Forecast accuracy trend

            Top forecast misses

            SKUProductCategoryForecast unitsActual unitsVariance %Bias

            Production and materials

            Trends follow the selected date range.
            Production plan vs actual (units)
            Raw materials coverage vs lead time (days)

            Cash conversion snapshot

            CCC components and liquidity indicators.
            CCC trend