SAMPLE AND DEMONSTRATION ONLY. Illustrative analysis of publicly available information, prepared by BI Consulting Services. Not affiliated with, endorsed by or produced for any company shown.

Demonstration · Illustrative data · BI Consulting Services

D&S

D&S Car Wash Supply × BI Consulting Services

Sales & Distribution board on top of the ERP

Every dollar, bay by bay — from the High Ridge warehouse to the wash tunnel.

Revenue, margin and fill rate by product family, distributor territory and account — the ERP reporting integration you asked about in 2024, shown as a working Power BI-style board. Chemicals, IQ systems, parts, service and WashCard, one screen.

Prepared for MikeVP Sales & Marketing
SEPTEMBER 2026 · v1 DEMO

Period

Territory

Product family

Revenue & gross margin — trailing 24 months

Trend

Monthly revenueOutside selected periodGross margin %

What this board answers

Three questions a sales VP asks the ERP every Monday

Answers

The revenue tunnel — where the dollars flow, stage by stage

Each arch is a product family; arch width = share of revenue in the selected scope, tint = gross margin. A customer drives in with a chemical order and leaves through WashCard.

Signature · product mix

Distributor territories — revenue & margin

Five sales territories served from High Ridge, MO and the Manila, AR plant

Ranking

Inventory turns & fill rate by family

Turns = annualised COGS ÷ average on-hand · fill rate = lines shipped complete from stock

Operations

Top accounts — revenue, reorders, chemical volume

Accounts

Ask the data

Natural-language layer over the same model — typed question, generated answer, chart reference

AI layer · mock

›Which accounts dropped chemical volume >20% vs last year?

Also from BI Consulting Services

Private AI on your own server

The "ask the data" panel above is built to run on a GPU server inside your own network: an open-weight model over your own documents, with every answer citing the file it came from. No per-seat licence, works offline, and nothing leaves the building.

How it sits in your environment

One appliance-class server on your rack or in a secured closet. Your files are indexed where they already live; the model runs locally; answers come back with the source page attached.

What that means in practice

1
Your data only, on your hardwareAn open model over your own documents and exports. No third-party AI processor, no data-transfer agreement to review.
2
Every answer cites its sourceReplies point to the file and page they were drawn from, so people check the answer instead of trusting it blind.
3
No per-seat licenceThe whole team can ask questions. Cost is the server and our build, not a monthly number that grows with headcount.
4
Works offlineIf the internet connection goes down, the answers still come. Nothing depends on a vendor's uptime or pricing changes.