Insights and wisdom from an ERP consultant

Earlier this week, I had the opportunity to sit down (technically, via video conference) with an actual business process consultant and discuss how companies migrate to a new ERP system in the real world. Elisa Bertelli (LinkedIn profile) is a Deloitte consultant based in London, UK, and has several years of experience consulting various companies through their ERP migration.

We started off talking about some of the first tasks she usually does with clients during the beginning of a project. “First we look at all of the business functions, all the business departments – sales, finance, production, human resources. And then we interview them on what their daily tasks are. We try to piece together the operational steps involved in the various tasks that they do. Then once we understand the steps, we can then find where the processes can be improved.” So, say if a tasks usually takes ten steps to complete, the consultant may present a new process that only takes four steps. “Because the main goal is to make the tasks take less time, which saves money and resources for the company.”

“After the mapping, we [then] use industry benchmarks as a comparison of how long a certain process should take. Deloitte, and all consultancies, have a repository on industry leading standards and practices, which we refer to in order to make a recommendation of which ERP system is best suited for the client.”

As far as the types of ERP systems used, “sometimes it mainly depends on the industry of the client. Oracle tends to be suited to financial companies while SAP serves manufacturing quite well.” But interestingly, an enterprise can end up using different software for different functions. “For example, a company may use SAP for the back end, while in their front end use a more flexible system – one that is more of a niche system to handle specialized operational needs.”

When it comes to the common challenges or roadblocks when advising clients on a new ERP system, I had expected something along the lines of accurate information gathering during the interviews. Instead, it’s “resistance to change: many people see change as a threat.” The people who usually performs the every day operational tasks are not the ones who decide to switch to a new system. Plus, many have been doing their jobs for a very long time. “In this case, we bring in our Change Management (a dedicated team that helps people with change) to work with the people and reassure them about the new methods and systems.”

 

 

 

 

 

 

Managing security threats for your ERP

Over the course of the quarter, we’ve seen how an EPP system integrates the various departments while maintaining silo walls within an enterprise. Having a successful system in place not only ensures effective data sharing, but also eliminates any inefficiencies in an enterprise’s day-to-day operations. Implementing an ERP system can be quite complicated, and there have been well documented cases of when implementations went over budget, over schedule, or did considerable business damage. One of my earlier blog posts covers some well known disaster stories.

While successfully completing an implementation is certainly a reason to celebrate. The work doesn’t end there. When your entire enterprise relies on the system for your financial and operational functions, how secure the system is becomes a top priority. In fact, a couple of months ago, the U.S. National Counterintelligence and Security announced that it will share classified security threat reports to critical telecommunications, energy, and financial businesses in the U.S. These threats target the supply chain by attempting to hack and manipulate ERP/supply chain software systems in order to disrupt and/or steal enterprise data.

While this piece of news sounds serious enough, there are some basic guidelines that all organizations can follow. Based on ERP Software Blog, below are some risks to watch out for and how to manage:

  • Outdated and unsupported software. Using outdated software can lead to integration and compatibility problems, but not updating software also means that the system is open to software security vulnerabilities. Updating software as soon as new security patches become available makes it harder for hackers to gain entry.
  • Technical personnel has access to make large scales changes to program behavior. Oftentimes, security is focused on external threats and end-user security and permissions. But controls should also be placed on the developers of the ERP software/system so that technical staff cannot make unauthorized changes that can drastically change the behaviors of the system or interfere with the business data.

Nintendo: gaming the demand

A throwback to the good old days that you can fit in the palm of you hand!
A throwback to the good old days that you can fit in the palm of you hand!

Nintendo has done it again. A few days ago, Nintendo released the NES Classic Edition to much anticipation, only to have units sold out within minutes from stores across the country. This certainly hasn’t been the first time the company seemingly fall short in terms of meeting demand with sufficient supply. The Wii console was notoriously difficult to obtain for nearly years after its début, and more recently, Nintendo’s amiibo (a near field communication device in the shape of popular Nintendo characters that lets players store personal gaming information) also experienced supply shortages.

Since Nintendo has always been pretty hush about any internal manufacturing problems, this has lead to a lot of speculation about whether the company’s supply issues have been intentional or if they’re just really bad at demand forecasting. Purposely keeping supply way below demand might seem counter productive when it comes to selling products, but it’s actually a technique that could drive up sales in the long run. For instance, when lots of customers are hoping to buy a product but cannot, then these stories tend to quickly generate quite a bit of hype and attention. It gets more people interested in the product, which usually means more sales once units arrive back in stores.

So what does this mean for Nintendo’s material planning process? Nintendo would need to determine how many units of the console it hopes to sell and over what period of time. Generally, forecasting is done on past sales data coupled with some market analysis, but for new products, this is not always a sure thing. I would imagine that they have a pretty high sales target in mind and have planned out the materials for an initial production plus future production after the first release. The extra public hype generated from the early storages is supposed to bring actual sales closer to the targeted sales goals.

However, there is a risk to releasing a limited number of units during the first round. Nintendo has other competitors in the gaming console market (Xbox, PlayStation) and making customers wait could lead to those customers losing interest and buying another console altogether. If they don’t end up selling as many units of the Classic Edition as planned, then the unsold units means lost sales and a loss write-off.

Making ERPs “smarter”

Machine learning, cognitive computing, artificial intelligence (AI), for the past few years these were some of the most widely discussed buzzwords in high-tech. Tech giants were also quietly devoting resources in developing AI technologies or acquiring smaller companies that specialize in these fields. The idea that AI will increasingly play a bigger role in how businesses function has made many excited about the possibilities of what can be achieved and how to enfold these technologies to be ahead of competitors.

Naturally, AI is also being applied to ERP systems to produce the next wave of innovation. Predictive business intelligence technology has been maturing for the past years and it is quickly being integrated into ERP functionalities. In other words, ERP systems can use past activities and data to predict, calculate, and respond to changes in workflow that can optimize business operations. For instance, whereas an actual person might be in charge of making purchase requests, a “smart” ERP system might automate the process when stock levels fall to a certain level or when a sales prediction technology signals a future growth in demand. This article by Bix Matrix discusses the topic in greater detail.

Furthermore, consulting company, Deloitte, predicts that over 80 of the largest ERP software companies will have integrated cognitive computing technologies into their products by the end of 2016. That number is expected to rise to 95 out of the top 100 by 2020.

In this article by Computer World UK, SAP discusses how they are deploying machine learning capabilities as APIs on its enterprise cloud and embeds them into existing applications. Since the start of their machine learning journey, SAP has “screened over 180 machine learning use cases. The first wave prioritized horizontal apps near [their] core and [they] are currently prioritizing a second layer and all spaces that are of value to [their] customers, such as the Internet of Things (IoT) and analytics, [such as ]predictive capabilities”.

It seems that the AI in the ERP world is well underway, it would be interesting to see where ERP would go in the coming years!

 

ERP Battle Royale: SAP vs Oracle vs Microsoft

When choosing an ERP software, companies have countless options on the market today, both proprietary and open source. But the main ones that most people talk about are the big three: SAP, Oracle, and Microsoft Dynamics. Being unfamiliar with all three I decided to look into what the differences are amongst them.

SAP

For me, SAP is the face of ERP software. They are popular with large enterprises that are global and complex in organization levels. Since SAP primarily built its product from the ground up, the various software components are very much standardized and are known to function well together. However, enterprises will have to rely on third party vendors if they need significant customizations for their business needs. As a result, it can become rather expensive.

Oracle ERP

I actually didn’t know Oracle had an ERP product before looking more into this topic. That’s most likely because Oracle acquired other companies with ERP components rather than building one in-house. This approach lets Oracle reach niche markets by obtaining small software companies that cater to specialized needs. Oracle tends to be favored by mid-sized companies that want a more flexible implementation process (as compared to SAP) and have unique needs. It’s noted that Oracle is rated as the most expensive system.

Microsoft Dynamics ERP

Microsoft is somewhat of a hybrid between SAP and Oracle when it comes to their ERP software creation. Microsoft acquired an accounting system software back in 2000. Since then, they have built on it and turned it into a line of enterprise planning software. MS Dynamics works well for small and mid-sized companies due to its simple implementation and similarity to MS Windows. It also offers lots of customization abilities and integrates well with other MS products. Though, users have mentioned that it can take longer to install and tends to have issues integrating with non-MS products.

Epic failures, ERP style

We all like to hear about success stories. Especially about business applications, where through careful planning, problem solving, and teamwork, Company EFG overcame the odds and achieved greatness. Or how Company LMN did this, this, and this, and became a textbook example of how to do something. How inspirational!

But I think the best stories are the failures: the bigger the disaster, the better the drama. So, I collected some of the best known ERP fails over the years below:

1. U.S. Navy. U.S. Navy began implementing a new ERP system back in 2000 when they tried to integrate their existing subsystems (all 44 of them) into one single system. They tried four different pilot projects (each of them failed), and ended up spending over $1 billion. Nuts. Ultimately, the failure was due to a lack of coordination between project, poor process standards, no transaction standards, and exclusion of enduser for requirements. (Source)

2. HP. HP in 2004, was migrating to a new order-processing and supply chain system in their North America division. Things were going smoothly until a series of small problems snowballed into a massive one that ended up costing the company $160 million in lost revenue. There were three main issues in play: first, the project team had some difficulty working with other parts of the company; second, there were lots of data-integrity issues (Orders fell out between the legacy front-end system and the new system on the back end, which needed significant manual intervention); third, increased demand of products, which put more pressure on the new system. (Source)

3. Nike. In 2000, Nike invested $400 million in updating their ERP and supply chain system… Only to see $100 million in lost revenue and a 20% dip in stock price (not to mention a bunch of class action lawsuits) when they produced too much of one shoe and not enough of another. The new system was suppose to match supply and demand and run a tighter manufacturing cycle. But due to poor software testing and too much faith on the demand forecasting features of their new software, their plans backfired rather spectacularly. (Source

What these cases show is that ERP implementation is very complex and things can go wrong very quickly with significant financial impact. But by keeping disaster stories in mind, you can watch out for common pitfalls.

Etsy: a helping hand for all things handmade

It’s mid-October and Halloween preparations are now in full swing! This year’s costume theme is “The Very Hungry Caterpillar”, the timeless children’s book by Eric Carle. Now that I have two kids, coordinating costumes is a must-do. And since I was feeling particularly ambitious, I’ve decided to DIY it. Which means, instead of browsing on Amazon and countless other online stores, I’ve been spending a hefty amount of time on Esty, hunting for the perfect handmade caterpillar hat.

I’ve been an Etsy user as a buyer for several years now, but I’ve never really thought about my purchases from Etsy’s point of view. It’s always been: add to cart, checkout, make payment, receive confirmation, and get package in mail. Technically, Etsy isn’t a merchant; they just provide a platform for individual sellers to reach buyers looking for specific items, much like eBay and Amazon Marketplace. Therefore, they do not hold inventory, but use sellers as part of their fulfillment and distribution.

The fulfillment process could look something like this:

  1. Purchase order is created once customer clicks “submit order” after filling out the online purchase form.
  2. Etsy generates a sales order and sends a notice to the seller: (Image source)

    Seller’s notification from a purchase order
  3. Customer payment is posted the next business day, Etsy then pay the seller.
  4. Seller packs the item with a packing slip, prints a shipping label provided by Etsy, and ships the package within the specified time frame.

Within their ERP system, it’s apparent that financial documents are being generated, but I think material documents also exist, even though they don’t handle inventory. Each seller and customer is required to open an account and past purchased items are tracked and viewable on the accounts. It would be an easy ways for Etsy to gather lots of data of the types of items sold, what is popular, and how much of a particular item sells. I think this is also a reason why they started Etsy Manufacturing and Etsy Wholesale the aim of helping individual sellers build their production capabilities and connect to large retailers.

Hopefully more about this on a future blog post!

“Cracking” the bullwhip effect

Last week we’ve discussed the procurement process in detail and how a vendor managed inventory model would shape an ERP system. One point I’d like to go in a bit more detail is about the vendor managed inventory (VMI) model when it comes to stock management. This model is effective because it gives suppliers a lot of information about how their products are selling and thus be able to coordinate their orders and shipments accordingly.

In supply chains, particularly forecast driven supply chains, one of the hardest phenomenon to control is the bullwhip effect. This happens when small changes in end customer demand causes larger quantities in order placed as it moves upstream in the supply chain. Each participant along the supply chain reacts to the signals from downstream by ordering larger quantities to build up safety stock in order to protect against stock outs. I should highlight that actual end customer demand is hidden to the upstream participants.

bullwhip

When suppliers have access end customer demand information, they can effectively reduce unnecessary inventory, which leads to lower cost all around. In addition, it allows the supplier to develop much better forecasts for future demand of a certain product.

So how is ERP involved? While researching this online, I’ve found that there are actually several ways to implement this process. For instance, SAP offers three different ways:

  • Standard, non-consigned (customer sends stock/sales data from its ERP system to the vendor).
  • Consigned (vendor maintains and manages its inventory at the customer’s site and handles replenishment planning on behalf of the customer).
  • Parallel consigned and non-consigned (for organizations handling both types at the same time).

The key takeaway to successfully using VMI is that ERP systems allow the data that is transmitted between customer and supplier to be accurate, complete, and in real-time. This lets vendors make informed decisions that lead to reduced costs, better customer service, and improved forecasting.


Image Source

Apples to apples or apples to pears?

Like one of my fellow classmates, I too had wondered if there was any differences between traditional accounting software and the accounting capabilities of ERP systems. Are they the same thing? If I was a new company picking out my software and system needs, how am I to distinguish between the two? Are we comparing apples to apples or apples to pears?

As it turns out, while the two types do cover some accounting functions, they are still technically different. As explained by this article at ERPSoftwareblog.com, accounting software handles typical accounting transactions such as receivables, payables, payroll, and balances. ERP systems handles the financial resources of a company plus the ability to manage intangible assets like work hours, product lifecycles, performance, and customer relationships. Accounting software is only for tasks related to accounting, but ERP systems actually interface to other aspects of business operations/processes.

So accounting software is more like an apple with ERP being the branches of an apple tree. Great.

But since ERP systems can easily take over much of the accounting capabilities, and many ERP packages have full accounting functions already built in (like the Microsoft Dynamics series), what’s the trend for independent accounting software these days? Well, according to the article, that industry is contracting. And this makes sense too. Comprehensive software packages are becoming more in demand and many accounting software companies either get absorbed into larger ones or fade away. Sooner or later, we’d only hear about ERP softwares in place of accounting.

Intro to ERP – Week 1 Takeaway

Last week, we were introduced to the basics of ERP systems and went through an interactive class activity that showed us how information gets passed through various organizational departments with the silo effect in place.

The importance of having an ERP system isn’t just to ensure faster communication between departments, but how the departments can access core data faster and with greater accuracy. Nowadays, incoming data can change rapidly and customers often times expect organizations to respond quickly to their needs. Then add the fact that business is now essentially non-stop and comes from all over the world (such as e-commerce), having a sound ERP system in place helps to keep the everyday operational business processes flowing smoothly.

The insurance industry is one type of business that can really benefit from ERP systems. In order to stay competitive with others offering similar products, an insurance company could offer a more customized policy with better rates for customers through an effective ERP system. It’s also possible to see changing purchasing trends in order to come up with new products or target specific types of people for potential new customers. These are common challenges facing the insurance industry today.