Business intelligence blog

    Data integration helps FB Chain analyze data in new ways



    Leading manufacturer and supplier of leaf chain is equipped with the information they need to make accurate and informed decisions across the whole business.
    FB Chain is a niche provider of chains for the lifting and lumber industries. The company and its 30 employees work out of two locations, 180 miles apart in England. The Letchworth operations focuses on chains for forklifts, trucks, telehandlers and lifting chains. Safety is essential, and FB Chain can tell where every part came from, who made it and even the origin of the steel. In Blackburn, the company focuses on chains for power stations, and biomass and saw mills. While Letchworths’s business makes it simple for customers to put the right chain on the right machine, Blacksburg’s team helps customers’ chains last longer.

    Working to reduce dependence on spreadsheet

    For both operations, the attention is in the details, and data has become increasingly more important over the years, particularly as the FB Chain was looking to kill spreadsheets in the business.

    "Spreadsheets are always out of date, and you can’t manipulate the data,” said Peter Church, managing director with FB Chain.

    Several years ago, FB Chain moved to a Lakeview (now Kerridge LV) system. Integrated within the MRP platform was an early version of Phocas software. Unfortunately, the BI software was not fully integrated into the business processes, so pulling information from Lakeview was difficult and time consuming, which is why spreadsheets began to proliferate the company.

    Jump forward a few years, and a frustration with data analytics led to a call to Phocas to learn more about the latest features and benefits. The new Phocas software checked all the boxes, and within a matter of three weeks, the company went from saying yes, to a complete implementation.

    We had some experience with Phocas, and we wanted to move quickly,” said Peter. “Lakeview contained tons of information, but it wasn’t easy to get information out, especially if we were trying to get information from two different areas of Lakeview.”

    "Spreadsheets are always out of data, and you can't manipulate the data."

    Peter Church,  Managing Director, FB Chain

    Users grasp and adopt Phocas quickly

    Armed with Phocas and the advanced data analytics, Peter can provide his users across the business with the information they need to make informed business decisions:

    • There is a lot of movement currently in pricing, from average costing and trends, and with a few clicks, the purchasing manager can find out what they paid for inventory previously, compare supplier pricing and negotiate better margins.
    • Sales can drill into a customer, see the margins at the customer level, by product group and by part number.
    • Built a dashboard for the Blackburn business so managers can see a quick snapshot of the business, from margin and order intake, to salesperson performance. In a few seconds, they can see a single view of key measures for his business without having to access multiple spreadsheets.
    • Sales team can use customer data to negotiate fair and equitable price adjustments with multi-site customers to ensure profitability across all locations.

    The key to Phocas' success for FB Chain is the live, up-to-date information, and the consistency of the data. Currently, FB Chain is using multiple databases, including financial, age credit, age debt, nominal ledger purchasing ledger, sales, stock and orders, among others.

    "Phocas is so easy to use, and no one has to be a data geek to use it,” added Peter. “Normally, if I asked two or three people in the business for information, they would probably come back to me with different answers because they pulled the data from different points, times or sources. Three different answers from the same system. Now, the data is fully integrated, and everyone is using the same data.”

    Tracking sustainability

    In addition to providing data and reports for internal staff, as part of a Swedish organization, FB Chain’s Swedish parent company asks for a lot of information, and is interested in sustainability. The company wanted to know how FB Chain classifies customers, a report in the past that was laborious to produce. With Phocas, Peter can quickly identify customer classifications and submit the report to the executives.

    "We are also in the process of tracking and recording environmental impact on our operations,” said Peter. "We hope to have a Phocas dashboard exclusively tracking sustainability in the near future."

     

    New ways to use data 

    In the last few years, data management and analysis are critical to FB Chain success, and Peter is hoping the company has just scratched the surface of what it can do with Phocas.

    He added, “We have a massive list we want to do with Phocas, including capacity planning with automated manufacturing. We have six machines, and we plan to use Phocas to identify pinch points on stock and capacity, so we can bring material in earlier, update production orders in the system, and start planning out how many production hours can and should each machine be working.”

    Peter predicts that the next several months of his business will be good as customers bounce back from the COVID-19 pandemic. What worked yesterday, however, is likely not going to work today so he is counting on Phocas to help him track and use data so FB Chain can continue to adjust and succeed in these changing conditions.

    He concluded, “Right now, I feel like I am in a swimming pool, and I am surrounded by all this information. Phocas gives me all the different strokes I need to effectively use the data. We now have a solution that gives us new and different ways to look at the data, and improve the business, and fortunately, we no longer have to rely on someone’s Excel skills.”

    For more information about Building the case for data analytics download this ebook: Harness your business data

     

    Written by Phocas Software
    We make people feel good about data
    We make people feel good about data
    executives_image
    FEATURED EBOOK

    Build the case for data analytics

     

     

    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