MRP vs. ERP: Why Growing Manufacturers Outgrow Spreadsheets

Open on YouTube ↗
Overview

This episode of Manufacturing Happy Hour, sponsored by MRPeasy, is aimed at manufacturers with roughly 10 to 200 employees who still run their businesses on spreadsheets. Host Chris Luecke talks with Shane from MRPeasy and Sarah from Smart Manufacturer, an independent consultancy that implements the software. They cover three questions: how MRP differs from ERP, what problems push small manufacturers to change systems, and what happens after they do. Both guests argue that many small manufacturers who think they need an ERP really need an MRP system, and that the software pays off only when leadership and staff are ready to change how they work.

14 min read

What the two guests do

Chris asked each guest to describe their work as if talking over a pint in a pub. Shane described MRPeasy as manufacturing software that connects the main parts of a manufacturing operation: sales, production, inventory and procurement. All of a business's manufacturing information sits in one place, and a change in one department updates automatically across the system.

Sarah described Smart Manufacturer as an independent manufacturing consultancy and ERP specialist focused on small and mid-sized manufacturers, the same market MRPeasy serves. She put the firm's mission as helping companies "work smarter, not harder." In her view, many small manufacturers try to grow by working ever more hours, and there are only so many hours in a day. Her firm helps them streamline and automate their end-to-end workflows so they can work more efficiently and scale more easily.

The difference between MRP and ERP

Chris asked Shane to explain the difference first, since the terms are often used interchangeably. According to Shane, ERP (enterprise resource planning) covers the whole business. Large organizations typically use it to connect every department, including sales, HR and accounting, plus manufacturing operations if they are a manufacturer. MRP follows the same idea of connecting parts of the business but focuses on manufacturing. In MRPeasy's case that means sales, inventory, production, planning and procurement.

Shane added that the two categories overlap. MRPeasy integrates with accounting platforms and CRMs, so in some ways it can do what ERP software does.

Chris suggested that an MRP system contains the core functionality a small or mid-sized manufacturer would need from an ERP. Shane partly agreed but corrected one point: large businesses also use MRP systems, so MRP is not only for small companies. His main point was that many small manufacturers searching for ERP software probably need MRP software, because what they are really trying to manage is their manufacturing.

The challenges that drive manufacturers to change

Shane said the main problem he sees among companies coming to MRPeasy is that they have outgrown their current systems. He described MRPeasy's ideal customer as a small manufacturer with around 15 employees. The business has started to grow, and the spreadsheets and manual processes it began with no longer work. Staff spend more time on admin and firefighting and less on work that grows the business.

He singled out two kinds of visibility. The first is inventory. Companies don't know what materials they have or whether they have enough to make a product. That leads them to over-promise delivery times, which causes late orders and unhappy customers.

The second is cost. Shane said many small manufacturers don't know what it costs to make their product. An MRP system can show material costs, labor costs and machine hours, which gives a clearer view of true product cost and directly affects profit. His example was a recent MRPeasy case study with a food manufacturer he believed was based in Indiana. When ingredient prices rose or suppliers changed their prices, the company checked its costs in MRPeasy and adjusted its recipes to bring costs down.

Labor shortages and new legislation in the UK

Sarah added challenges from the UK market, starting with access to new workers. She pointed to an aging workforce and said Make UK, which she called the country's largest established trade association for small manufacturers, quotes the average age of people working in small manufacturing at about 52. She said she has seen many companies with employees much older than that. She also described a perception problem: it is hard to get younger people excited about working in UK manufacturing.

She also mentioned new employment rights legislation that, in her view, makes life harder for manufacturing leaders. Sarah said these pressures are pushing even established businesses to manage their operations differently and look at automation. She described MRPeasy as often the first step on a "digital ladder": moving away from manual processes and spreadsheets and getting everyone onto one system that provides what ERP practitioners call a "single version of the truth."

Chris said about 80% of the show's audience is in North America, and that many US manufacturers feel the same pressures. He named navigating policy and, above all, labor shortages as common themes.

Being first to market with cloud-based MRP

Chris asked Shane about MRPeasy's history, noting that Shane was not at the company at the time. Shane said MRPeasy launched in 2014 as the first cloud-based MRP system. As he understands it, nothing on the market then gave small businesses MRP functionality. The larger systems were expensive, and the founders saw a gap for an MRP system that small manufacturers could access and afford.

Being first had a downside. There were no competitors, but many potential customers didn't know such software existed or that a cloud-based MRP system for small manufacturers was even possible. Shane said this caused some hesitation, so building trust early was essential. According to Shane, the company did this by offering a product that worked at very low prices and keeping prices extremely low for several years until it broke even. Only then did it promote MRPeasy more heavily and attract more customers. Today many competitors offer cloud-based MRP. Shane said affordability for small manufacturers remains part of the company's original vision.

Chris noted that running a business in the cloud was seen as risky ten years ago. He also recalled that the company was bootstrapped rather than raising a lot of funding up front, and suggested this gave it flexibility. Shane agreed.

A CNC machining shop on the edge of burnout

Chris asked Sarah for one of the most painful spreadsheet-driven scenarios she had seen. She described a typical CNC machining shop founded in 2017 that served aerospace, defense, medical, and oil and gas. It had two directors. One ran sales, and the other ran everything else on the production and operations side. Sarah noted that both were young, not people in their fifties, which is part of why the case stuck with her.

Everything ran on manual spreadsheets, and jobs were scheduled and rescheduled on a whiteboard. The operations director walked Sarah's team through the process:

  1. He created a quote and matched it against a quote tracker.
  2. He sent the quote manually.
  3. He re-keyed the same information into the order.
  4. He cross-checked the order against an order tracker.

Meanwhile, he also had to go onto the shop floor, make sure the team knew which jobs to run that day, and find out why any machines were standing idle.

Sarah said that after only half a day there she felt stressed herself, so she could imagine what he was under. He told her he had no visibility into where jobs were or what they were costing him, so he couldn't use that information to make operational changes. Sarah said she could see physical signs of stress. She believed that unless something changed and a system was put in, he was headed for personal burnout. That combination of business and personal consequences is why the case stays with her.

The hidden costs small manufacturers overlook

Chris asked which operational problems quietly cost small manufacturers the most without their realizing it. Sarah listed three.

Duplicate data entry. Time spent copying and pasting the same information across multiple spreadsheets is a real cost.

Under- and overstocking. Overstocking ties up cash unnecessarily. Understocking, she said, is worse. In several implementations, when her team reviewed how a company managed inventory, the company had not set minimum or maximum stock levels for small parts like screws and washers because they seemed too cheap to matter. Sarah said they are cheap per unit, but if a job starts and those components are missing, the delayed order can be expensive.

Unmeasured scrap and defects. Companies often tell her a defect "occurred in production," but nobody measures it or does root cause analysis. It is treated as something that happens from time to time. Sarah said this leaves open how often it happens and what it costs.

A fire door seal manufacturer after implementation

For a success story, Sarah described a family-run manufacturer of intumescent fire door seals, a niche market. The company started in 2021, but the family had about 30 years of experience in similar businesses. It had about 23 employees at the time.

Before implementation, the company worked very traditionally. It had three separate Excel trackers, two for production and one for packaging, and only one production manager could enter information into them. Paper job sheets went out to the floor. There was no information on what jobs cost. When customers asked where their job was in production, admin staff had to run around the factory to find out. Sarah hesitated to call it chaos but said there was a clear lack of visibility.

The managing director, who has since retired, wanted to leave the business in very different shape. When Sarah introduced MRPeasy, the company was skeptical. She said the MD expected an ERP or MRP system to cost "an arm and a leg" and worried it would be excessive for a business their size. After explaining how MRPeasy differed, the company ran a trial, found it was not what they expected, and went ahead with implementation supported by Smart Manufacturer.

According to Sarah, based partly on a recent case study with the sales director who sponsored the project:

  • One system instead of three trackers. Every function now works from a common set of information in MRPeasy, replacing the Excel trackers and paper work cards.
  • Shop-floor access. Staff use MRPeasy on the floor through desktop systems and rugged mobile devices.
  • Cost and scrap tracking. They capture actual costs and scrap. Scrap was an area the former MD specifically wanted to track so the business could keep improving.
  • No more running around. Nobody has to walk the factory to answer customer questions.
  • Delivery performance. OTIF (on time in full, meaning deliveries go out as planned and complete) is now consistently above 99%.

Sarah called the most striking result the growth. A year after going live, the business had grown by just over 25% while adding only a couple of people. In her view, without MRPeasy it would have had to increase headcount significantly.

Chris said the case showed how much such an investment can change a business, attributing the growth to better visibility, faster throughput, and people understanding what others in the business were doing. He added that the broader lesson goes beyond MRPeasy: taking deliberate action can transform even a manufacturer with 20-some employees.

What successfully scaling manufacturers have in common

Chris asked Sarah what manufacturers that scale well have in common beyond software. She named five traits.

Focus. Instead of doing everything they have always done, only bigger and faster, successful companies identify their most profitable product types, customer segments and possibly geographies, and concentrate on those.

Strong leadership. Leaders need a solid grounding in manufacturing, but also have to communicate effectively and build teams.

An open mindset. Sarah said her consultancy looks for this in deciding where it can make a difference. Rather than fearing that a new system means too much change to lead, good leaders are open to doing things differently. They may not know exactly how, but they believe the right people and technology will get them there.

Investment in people. Technology and streamlined processes are necessary, but Sarah described implementing a system as a change management program. Staff must be engaged from the start and understand how the technology will change both the business and their own roles. She said her consultancy puts a lot of emphasis on bringing people along.

Continuous improvement. Successful companies treat scaling as ongoing, not a one-time destination, and keep looking for new processes and technologies. Sarah said MRPeasy's open API allows it to sit at the core with specialist applications integrated around it.

Self-implementation and the role of partners

To close, Chris asked Shane what he wished they had discussed. Shane chose implementation. He said one of the biggest misconceptions about MRP systems is that they are very expensive to implement, and that this, plus licensing fees, keeps many small manufacturers from considering them at all.

Shane said MRPeasy addresses this in three ways:

  • Low licensing fees.
  • An extensive user manual that lets a small business owner learn everything needed to implement the software alone.
  • An AI chatbot trained on the manual, which answers questions about how the software works, including what it can and cannot do.

There is also a customer success team whose role is to educate users on the software's capabilities. Shane was clear that this team does not go into the business. It explains how the software works and helps customers implement it themselves.

He said self-implementation is central to MRPeasy's approach. Many customers, though, are too busy running their businesses to do it themselves, and for them MRPeasy works with partners like Sarah. The conversation ends there: small manufacturers can set up the system on their own with the tools Shane described, or bring in an implementation partner.