FOR MORE INFORMATION
847-766-0990

Why did margin drop? Five questions to a plan

Why did margin drop? Five questions to a plan

Your dashboards answer the questions they were built to answer. The question in front of you on a Friday afternoon usually isn’t one of them.

Revan the Analyst answers the one you have right now. You ask in plain English, against your own governed data, and every analytical answer comes back in four parts: the call, the evidence, the caveat and the next step. Then you follow up, push back and go deeper until you have what you need.

Here is what that looks like when a leader works a familiar question through with Revan. This is an illustrative example. The company and all figures are fictional.

The setup

The CFO of a maker of hydraulic fittings is preparing for Monday’s leadership meeting. Gross margin fell two points last quarter, and the team will want to know why and what to do about it. The company’s ERP data is in the DataMaaS Platform, with its Business Definitions and permissions, built the way we described in Your AI is only as good as your data foundation.

Question 1: What happened?

CFO: Gross margin dropped two points last quarter. What happened?

Revan: About two-thirds of the drop is mix, and the rest is material cost. Sales of the commodity fittings line grew 18% while the engineered line was flat, and commodity fittings carry roughly half the margin. Separately, standard cost on the brass family rose 6% in the second month of the quarter, and prices didn’t move with it. One caveat: your Business Definitions report margin on standard cost. If the standards were updated late, the true cost variance may be larger than this shows. Your controller can confirm.

The call comes in the first line. The evidence follows, with each figure from the company’s own data. The caveat comes straight from the Business Definitions: margin here is reported on standard cost, and Revan says what that basis can hide. The next step is a specific check, with the person who can make it.

Question 2: Who drove it?

CFO: Which customers drove the mix shift?

Revan: Three distributors account for most of the commodity growth. On the other side, your largest OEM customer shipped 30% less engineered product than the prior quarter. Their open orders show those orders were moved into this quarter, not canceled, so it looks like timing rather than lost business. I can see the order book, but not the reason they moved the dates.

Revan keeps what the data shows apart from what it suggests. The order book shows the dates moved. It doesn’t show why, and the answer says so.

Question 3: Timing, or something worse?

CFO: Is the OEM slip just timing, or are we starting to lose them?

Revan: The order data points to timing. Their order intake has been steady for twelve months, and nothing has been canceled. What I can’t see is quoting: quotes aren’t in your governed data, so I can’t tell whether you’re losing their new parts to a competitor. That’s the risk worth checking. Ask sales for the win rate on their last ten quotes before Monday.

This is the answer that matters most in the conversation. Revan says plainly where the data stops, names the risk that sits beyond it, and turns it into one question for the sales team. A confident answer that skipped the quoting gap would have read better and been worth less.

Question 4: Pressure-test the plan

CFO: Here’s what I’m planning to propose: a 4% price increase on the brass family. Pressure-test it.

Revan: It recovers most of the cost increase, but it lands unevenly. Two of the three growing distributors buy almost entirely on price, and brass is a large share of what they buy, so they’re the most likely to move volume elsewhere. Your OEM customers buy brass as part of engineered assemblies and are less likely to switch over a part price. Consider raising OEM pricing first, holding the distributors until next quarter’s cost review, and setting a volume floor that would make you rethink it. The strongest objection is that splitting the increase invites customers to compare notes.

Revan doesn’t just agree with the plan it’s handed. Every analytical answer is reviewed from ten perspectives, so the financial case, the market and competitive response and the customer conversation are all in view. Revan recommends a different sequence and still gives the strongest objection to its own recommendation. The decision stays with the CFO.

Question 5: From answer to action

CFO: Good. Build a dashboard the leadership team can watch monthly, and a one-page summary for Monday.

Revan: Both are ready: a margin bridge dashboard showing mix, material cost and price by month, and a one-page summary in your company’s template. I flagged the standard cost question and the OEM quote check as open items, so nobody reads the summary as settled.

The dashboard lives in the platform, on a page with its own permissions, so the CFO decides who on the leadership team sees it. The summary carries its caveats with it.

Five questions, from “what happened” to a plan the leadership team can act on. Every figure came from the company’s own governed data, and Revan said plainly where the data stopped.

What happens behind each answer

None of this works if the AI can roam through your data. It can’t.

  • Your definitions come first. Revan reads your Business Definitions before anything else, so margin means what your business means by margin.
  • A request, never a query. Revan describes the data it needs and sends that request to the DataMaaS Secure Query Service. It holds no credentials and has no connection to the database.
  • Your permissions, enforced at the database. The Secure Query Service applies the permissions of the person asking, by table, row and column, and runs a read-only query. If a sales manager asked the same first question, they would get only what they’re entitled to see. A rep who can’t get to margin in your systems can’t get it out of Revan either.
  • Read-only, and never used to train AI. Revan can’t change, delete or add anything, and your questions and answers are contractually excluded from AI training.

Questions people ask Revan

The margin conversation is one example. These are others that operating companies bring:

  • Which customers are buying less than they did a year ago?
  • Where are we late on deliveries, and is it getting worse?
  • Which products are we underpricing?
  • How much of our revenue sits with our top ten customers?
  • For managed service providers: which clients take more service hours than their contracts cover?

Getting started

Every subscription includes Revan the Strategist: bring the decisions in front of you, with what you know and the files you add. Governed data from your own systems adds Revan the Analyst. It is scoped with each company, starting with an assessment that proposes the solution, timeline and costs, and DataMaaS builds it with you one source at a time.

See how Revan the Analyst works

What’s the question you’d ask your business first?

Learn more about Revan Analytics

Share on LinkedIn

Related Posts