“Which customers are we letting down on delivery?”
Three customers account for 61% of late lines this quarter. All three order parts that run through the same bottleneck machine.
Industries · Manufacturing
From the shop floor to the board.
Prism joins up your ERP, production, quality and finance data into one live view of delivery, margin and capacity, built by someone who has spent 25 years inside manufacturing businesses.
OTIF by customer and partMargin by product lineOrder book and capacity
Operations overviewIllustrative data
£1.84m+6.3%
96.2%+2.1 pts
37.5%−0.8 pts
Sales by month£k
Ask Prism
What's pulling margin down?
Two customers on legacy price lists: 214 order lines invoiced below the current list price this month, worth £31k in lost margin.
Ask about your numbers…
Ask Prism
The questions operations and finance ask.
Ask Prism answers from your own orders, production, quality and finance data, all joined up.
“What's in the order book we can't make on time?”
£412k of orders due in the next four weeks need more machine hours than are available. Two Saturday shifts would clear it.
“Which products make us the least money?”
Small-batch assemblies earn 18% margin against 37% overall, once set-up time and scrap are counted.
“Why did scrap go up this week?”
Line 2: scrap doubled after Tuesday's tooling change, adding £6.2k of material cost this week.
Illustrative examples
Dashboards included
Built around how manufacturers run.
A starting set of dashboards modelled on manufacturing and engineering businesses, then shaped to your sites, products and customers.
Executive overview
Sales, margin, delivery and cash on one page for the board.
- Sales
- vs budget
- Margin
- trend
Sales and order book
Orders, invoiced sales and the order book by customer and product.
- Order book
- value and age
- Arrears
- by customer
Delivery and OTIF
On time in full by customer, part and site, with the reasons for late lines.
- OTIF
- by customer
- Days late
- average
Production and OEE
Output, availability, performance and quality by line and shift.
- OEE
- by line
- Output
- vs plan
Quality and scrap
Scrap, rework and returns, and what they cost.
- Scrap
- % and £
- Returns
- by cause
Purchasing and materials
Supplier performance, price changes and material availability.
- Supplier OTIF
- %
- Price change
- vs last
Stock and WIP
Raw materials, work in progress and finished goods, with ageing.
- Stock cover
- weeks
- Slow movers
- £
Margin and pricing
Margin by product line and customer, with pricing errors flagged.
- Margin
- by product line
- Below list
- lines
Connects to the systems you already run
ERP and MRPProduction and shop-floor dataQuality systemsPlanning spreadsheetsPurchasingAccounting softwareCRMSQL databases
Automations
Your data already knows the answers. Prism tells you before you think to ask.
Sent from the same reconciled data as the dashboards. Each person only receives the figures they are allowed to see.
Daily production flash
Yesterday's output, delivery and scrap against plan, by site and line.
Late order alerts
Order lines at risk of missing their date, sent to planning and the customer team before they slip.
Site and line scorecards
Each site or line manager gets their own figures: output, OTIF, scrap and overtime against target.
P&L into your template
Your management accounts workbook filled from the ledger and ERP, formulas and formatting untouched.
Results
What changed when they could see it.
Outcomes from Prism BI work with manufacturing and engineering businesses.
Before 36% · After 99%+99%
Customer OTIF
On time in full rose from 36% to over 99%, with average delivery moving from two days late to two days early.
Before 224 days · After 00 days
Aged order book
Aged sales orders reduced from 224 days to zero.
Before 32% · After 40%+8 pts
Gross margin
Margins improved from 32% to 40%.
Before 2.5 · After 1.0−60%
Despatches per order
Average despatches per sales order cut from 2.5 to 1.
Cleared in 3 months20%
Of monthly turnover released
Arrears equal to 20% of monthly turnover reduced to zero in three months.
5-year horizon98%
Forecast accuracy
A five-year sales forecast that proved 98% accurate.
Clients
In their words.
“What I’ve really valued about working with Prism BI is their ability to understand both the data and what the business actually needs from it. It’s about taking complex information and turning it into a visualisation that is clear, accurate and genuinely useful. Joanne brings a huge amount of passion, knowledge and attention to detail to help us deliver digital transformation and operational excellence.”
“Before working with Prism BI, our reporting was all done on manual spreadsheets and bulky default reports. Jo’s extensive knowledge of business analytics has been invaluable and has transformed how we operate at ASL by providing seamless, automated visibility across our entire business, from sales and order book management to purchasing, production planning, quality, and stock. It has become an essential part of our day-to-day operations. Jo has been absolutely brilliant to work with throughout the whole process.”
“What Prism BI were able to do to bring various datasets to life visually has been literally game-changing to our business.”
“Overall, working with Prism BI was a game changer for our company. They brought data to the forefront of our decision-making processes and helped us to become more data-driven in our approach.”
How it works
From scattered systems to one view.
Connect
Read-only links to your ERP, production, quality and accounts data. Nothing to replace.
Model
Customers, parts, sites and dates joined into one model, with every measure defined once and checked against your own figures.
Launch
Your portal, in your branding. Each manager sees their own site or line, the board sees everything.
Ask
Directors question the numbers in plain English, and the daily flash, alerts and board pack send themselves.
Book a demo
See a manufacturing portal in 30 minutes.
We will show you the portal for a manufacturing business, then talk about your sites, systems and the measures your board runs on.