Business intelligence blog

    Strongdor uses data to future proof operations


    Strongdor is a premier manufacturer of secure steel doors, operating out of two facilities in Lancaster, England, including its 4,500 square meter manufacturing hub.

    A long journey to finding value in data

    When Managing Director Tim Devenish joined the business in April 2012, Strongdor was working on a high growth strategy. The company was trying a lot of different things, and while data was being collected, it was not in a way that could be used to benefit the business or customers.

    Tim brought with him a license to OrderWise, allowing him to build customer, supplier and inventory databases. Unfortunately, putting the businesses’ thousands of manufacturing parts into the database was not easy, and tracking bill of materials was even more difficult.

    In 2015, Strongdor decided to deploy a new ERP system, Microsoft Dynamics Nav, but the company was too small to do it on its own.

    “We gave the order to an ERP provider with the stipulation that the system had to go live in three months,” said Tim. “We were eager to get it completed, as was the ERP provider, however, we underestimated the complexity.”

    After two months, Strongdor moved from Microsoft Dynamics Nav and put everything back in OrderWise.

    "This ability to access and review data sets and trends will help prevent lulls from happening the future. We never had that before."

    Tim Devenish, Managing Director , Strongdor

    Risking the 'biscuit' on Phocas 

    What Tim wanted, and Strongdor needed, was visibility into business performance, including key performance indicators (KPIs) such as gross profit and conversion rates. A manufacturing business is not like a traditional buy-sale company and determining gross profit is more than just the sell price minus product price. With Strongdor, there are parts, labour, time, and other cost considerations the company never had access to.

    “We started building some databases in 2016 to make this happen because we wanted to see profitability, and gross profit by hour, day and week,” said Tim. “We tried everything to make our data usable, including Power BI, but we could never get gross profit.”

    Throughout these challenging times, Phocas kept popping up, and after seeing what it could do for Strongdor, Tim decided to deploy the BI software.

    Endless opportunities 

    The company now has a happy Sales Director, among other users, who can monitor dashboards, look at quotes per day, as well as incoming and outgoing sales. In addition, with a few clicks, they can easily monitor conversion rate and gross profit.

    “In the whole life of Nav, we never had anything like we have now with Phocas, and we are just scratching the surface,” said Tim. “Phocas is true BI, built to provide data analytics, while tools like Power BI are an empty box that requires you to build it yourself. You have to start from scratch, and you need to be an expert in that software.”

    Phocas provides Strongdor endless ways to slice and dice its data so the results can be reviewed by day, week, month, and year, as well as by salesperson and individual order. Phocas also provides access to daily and weekly sales and conversion rates, with the ability to drill down to individual salesperson against target.

     

    Planning for the future

    Phocas is also helping Strongdor with sales projections, which in the past were often based on gut feel rather than hard data.

    “We now have a report running all the time that provides us with what is coming in and going out, so projections is now one of our dials, which means we no longer have to guess.”

    Shortly after deploying Phocas, the Sales Director reported that Strongdor was going to have a bit of a dip in sales in the coming weeks. He identified the dip based on a low number of quotes in the short term, equating to an anticipated lull in the incoming sales. This ability to access and review data sets and trends will help prevent lulls from happening in the future.

    “Again, we never had that before,” said Tim. “And while it’s a significant investment, it is so worthwhile.”

    Each member of the sales team has access to an individual dashboard that shows their own numbers, quotes, sales and conversion rates. Strongdor is planning to provide access to the data to additional departments, including finance and purchasing while providing the executive team with a single, comprehensive operations report.

    Telling a story with data 

    When asked what he would say to someone else considering Phocas, Tim said, “I would ask, ‘What ERP are you working with?’ If they have NAV – the next 80 percent of my answer would be simple. Phocas is worth every penny of implementation.”

    “I would then ask, ‘How many spreadsheets are you working with that are not part of your ERP and what system are you working with?’ We ditched the ineffective system, and we went live with Phocas. The time savings per person, per day was phenomenal.”

    Phocas is helping drive forward more strategic decisions based on the reporting.

    “While we might not have made all the decisions yet,” said Tim. “We are building the data and reporting to tell a story that will ultimately guide our future.”

    For more information about moving away from spreadsheets download this: Stop running your business on spreadsheets alone: 

     

    Written by Phocas Software
    We make people feel good about data
    We make people feel good about data
    6-reasons-businesses-can-not-run-on-spreadsheets-alone-cover
    FEATURED EBOOK

    Future proof your operations

     

     

    Download eBook

    Related posts

    Dynamic vs static financial reporting: key...
    3 MIN

    Managers can no longer afford to wait for weekly or monthly financial reports to review business performance; they...

    5 ways to achieve financial process automation
    4 MIN

     

    Many finance teams are at various stages along the automation journey, and others are yet to fulfil all their...

    Delivery in full on time: Why it matters and how...
    2 MIN

    Delivery in full, on time (DIFOT) is a fundamental measure when analyzing the performance of your supply chain. The...

    Subscribe to our blog

    Sign up to get the latest news and insights from Phocas experts