I’ve indicated that the company has a number of sites in this country as well as several more overseas. The original plan was that we would implement the SAP program and once it was proven to be working, it would then be rolled out to the other sites. There was a slight change to this in that we bought out a company in another country and for a while, it was required that they would be part of the project; that was cancelled, so we are back to just the original sites.
It should be highlighted that each site sells different products – yes there is a commonality, but the difference is sufficient that they use diverse processes. Now in the past, this has caused an issue – it’s been difficult to get any agreement on standardization - this is why we wanted a single ERP system.
When the project was set-up, the consultants suggested that we create a project team made up of managers to represent the key areas within the business. It was decided that our director of operations would head the team and act as project manager from our side; he would liaise with the project manager supplied from the consultants.
So far, so good - however, I queried one thing; most of the project team were from the one site, and there was only one representative for the other 3 sites. The explanation for this was that as we would all use the same processes, the one person plus a single consultant was required due to a specific area which they dealt with and that the other sites didn’t. I understand the idea of this, but I felt that this was not right.
Although we need to try to get some consistency, the nature of the differences in the way that each site works is fundamental and many of the business processes are then affected by this. I was concerned that we would see the system set-up to work one way only and that the other sites would then struggle to use a system that could not handle their particular needs.
After the blueprint phase, I was even more convinced that the one person would not be able to deal with all of the issues on his own. As we moved through the next steps, it became obvious that he was struggling to keep up. About 16 / 17 months ago, it was decided that he needed help and he has had 4 more people helping him, 2 on a temporary basis and 2 permanently. Despite this, I still felt uneasy – they were still concentrating only on certain key steps and ignoring other modules on the basis that the project team would cover those items.
Now over the past 8 / 9 months, the guys and gals from the project team have worked extremely hard to train people from the other sites. During this phase, there have been a number of questions raised by the people being trained about the way that they are to work in future. Some of these questions are not really relevant – we have been able to simplify some processes and things that they used to do are no longer necessary. But unfortunately that’s not so in each case and there are a number of key items that are absolutely required that still have yet to be set-up properly.
And now it gets worse. Our project manager went to one of the other sites 2 days ago to meet with the managers from those other sites. He showed them a PowerPoint Presentation and then ran through a demo of SAP using some data that they would recognize so that they could see that it worked. He told yesterday that the presentation went well and that these managers are now really happy with it and they all feel very positive. The presentation lasted a total of less than two hours.
I queried if these managers had actually used the software themselves – the answer was no. He sort of said that they wouldn’t be the ones to use it, so it wasn’t important that they knew the software, but that they should understand what it could do.
I have to disagree – the people concerned are the site director, who needs to be able to get sales data, the production manager, who needs to know how to schedule and manage the production, the sales support manager who will have a major task in ensuring that products are produced, packed and shipped on time, and one of the senior managers that is involved in ensuring key accounts are dealt with correctly. I know that of these guys, 2 have never logged on to SAP, the others have logged on, but neither has used it in the last 6 months.
Although he has said he is confident that they are happy with things now, that is not what I am hearing from other conversations. I really am concerned that these senior managers are now completely out of the loop – and worse, because they don’t understand, when the staff have problems, these managers will not know what to do or how to find a resolution.
At this stage, we are committed to a go-live date – the CEO has said that we will not delay any further under any circumstances. If it is not ready, it is not ready but we will just have to make do with it in the condition that it is in. (I actually believe that there is now some political pressure from somewhere being applied to force the project forward whatever the cost.) Whatever the truth, I do see that sometimes it is necessary to force the situation, but I am troubled that there are too many pitfalls and things may get ugly. Time to clean up that old fall-out shelter!
Sunday, 28 June 2009
Friday, 19 June 2009
Thru a glass darkly
It occurred to me that when writing these posts, I've fallen in the same trap as a lot of people; I make assumptions that the readers will know certain things about SAP that I don't need to elaborate on. So I thought that I would clarify a few issues.
SAP is an acronym - Systems, Applications & Processing. The title was originally in German, but it works the same in English. It is both the name of the company (SAP GmbH or SAP Inc etc.) and it is also the name of the software product that the company produces. Normally, it is fairly clear which of the two is being referred to, but just occasionally, it can be a bit confusing.
The company is a global player - they operate in almost every market area of the world. Previously, due to the size, complexity and cost of implementing their product, they concentrated on selling to the larger organisations. However, some years ago, they realised that there were a lot more smaller businesses out there than larger ones and so changed their focus somewhat - they now try to sell to all sizes and type of organisations.
The software is a massive product, with many modules covering different areas within a business. It is intended to be a true Enterprise Resource Planning (ERP) product; that is, it allows data from all areas of a business to be handled and processed in order to allow a seamless transition of data and therefore much greater accuracy of processing and transparency of data for analysis. This has previously been of real importance to the larger operations, but is becoming equally important to the smaller ones that wish to compete on a equal footing.
So far, so good. However, now it starts to get a bit more complex. You see, SAP (Inc) don't actually do most of the selling of SAP (product) . Yes they have a massive marketing budget and teams of specialists that help in the selling process, but the majority of the selling is really done by other companies; and these are the ones that also (generally) do the implementation of the product. These can be smaller companies operating in a single country or larger one that operate across a global region - it could also be one the big boys such as the major consultancies. This actually also includes people such HP & IBM who are surprisingly active in this area.
Now there are people out there that will tell you that SAP (the product) can operate "out of the box". I know what they mean, but in fact that is a very simplistic statement and in reality is simply not true in the way that say Microsoft Office would work out of the box. From my experience, I can say with utter certainty that the software installation is not a just case of putting a CD / DVD in the drive (they actually supply a large box full of over 100 discs!). In order to carry out even the most basic of installations successfully, you need to know certain things about the product and your business before you start. Even then, there are a number of factors that could prevent an installation taking place at all.
In order to use the product effectively, it also needs to be set-up - SAP (the company) refer to this as "best practice". What they actually mean is that over the years, they have developed a series of modifications and changes to meet the needs of the larger businesses that they have installed the product in. They have a wide range of these based upon sector and process type; they can select which of these to install on a "mix and match" method. This requires a good knowledge of the product AND of the business - and I would suggest that this one area is responsible for many of the problems that occur during implementation.
Now it gets even murkier. In some of the consultancies, the people that work for them are employees, but many are only on short term contracts - say 18 months to 2 years. These consultancies will hire people for the specific project based upon need and skill. Unfortunately, many of the people hired are of varying quality - and in some cases, they end up working in a module area that they are not particularly skilled in. I've also seen that the consultancy can hire in a person who is in turn a private contractor, and these generally get paid by the day or week. I also understand that in some cases, the larger consultancy contracts out part of the work to a smaller firm. And of course, the smaller firm can then hire in the actual people, who might even be employed by yet another business.
You see, some of these consultancies specialize in specific areas - HR, Accounts, or groups of modules such as those that make up the manufacturing process. The concept is fairly sound - you hire in the expertise in the area that you have the need. This allows you to act as a consultant even if you don't have the required specialization.
But with all of these different people, using different employment methods and structures of reporting, you find communication problems even in the relatively simple projects. From experience, many of the individuals like to work in particular way and use specific methods or practices - in some cases, these clearly don't meet the specific requirements, and I've seen that they often go against the defined goals.
Now, for a lot of people, this will seem a strange way of working - but you have to understand that this is the SAP business model. They are NOT in the business of selling software - they actually want to sell the knowledge and experience of the consultants, either as business consultants, project management, training, education services - basically all of the additional items that are perhaps a bit harder to quantify.
Don't get me wrong, when the software is set-up properly, it seems to work well (if perhaps a bit long winded). However, I would suggest that the way that the product is sold and then managed is almost designed to lead to issues that will then require the hiring of additional outside expertise. The problem then of course is that often people get locked in to the product - no-one (especially in senior management) wants to admit that they might have made a mistake, so they act like the gambler who keeps on playing in the hope that the one big win will cover all his losses.
Our project is one of the less expensive ones - we've spent nearly $2 million so far after 2 years and based upon some of the comments and observations, I expect that we will see an annual expenditure of another $100k to $150k for the next 5 years in addition to any contracted support cost (which was hiked from the beginning of the year). I still have a copy of the original documents - they stated categorically that the total cost over the first 5 years would be $1.06 million and this covered all installation costs, support and consultancy.
In reality, we will probably have spent around 3 times as much by the time that we are finished. I did some basic numbers and to get the return that they suggested, we would have to continue to use the product for around 18-20 years, and that doesn't allow for any subsequent changes or projects. I have to be honest, I cannot see that we will ever actually get a return on our investment - it's just going be a big old money pit.
SAP is an acronym - Systems, Applications & Processing. The title was originally in German, but it works the same in English. It is both the name of the company (SAP GmbH or SAP Inc etc.) and it is also the name of the software product that the company produces. Normally, it is fairly clear which of the two is being referred to, but just occasionally, it can be a bit confusing.
The company is a global player - they operate in almost every market area of the world. Previously, due to the size, complexity and cost of implementing their product, they concentrated on selling to the larger organisations. However, some years ago, they realised that there were a lot more smaller businesses out there than larger ones and so changed their focus somewhat - they now try to sell to all sizes and type of organisations.
The software is a massive product, with many modules covering different areas within a business. It is intended to be a true Enterprise Resource Planning (ERP) product; that is, it allows data from all areas of a business to be handled and processed in order to allow a seamless transition of data and therefore much greater accuracy of processing and transparency of data for analysis. This has previously been of real importance to the larger operations, but is becoming equally important to the smaller ones that wish to compete on a equal footing.
So far, so good. However, now it starts to get a bit more complex. You see, SAP (Inc) don't actually do most of the selling of SAP (product) . Yes they have a massive marketing budget and teams of specialists that help in the selling process, but the majority of the selling is really done by other companies; and these are the ones that also (generally) do the implementation of the product. These can be smaller companies operating in a single country or larger one that operate across a global region - it could also be one the big boys such as the major consultancies. This actually also includes people such HP & IBM who are surprisingly active in this area.
Now there are people out there that will tell you that SAP (the product) can operate "out of the box". I know what they mean, but in fact that is a very simplistic statement and in reality is simply not true in the way that say Microsoft Office would work out of the box. From my experience, I can say with utter certainty that the software installation is not a just case of putting a CD / DVD in the drive (they actually supply a large box full of over 100 discs!). In order to carry out even the most basic of installations successfully, you need to know certain things about the product and your business before you start. Even then, there are a number of factors that could prevent an installation taking place at all.
In order to use the product effectively, it also needs to be set-up - SAP (the company) refer to this as "best practice". What they actually mean is that over the years, they have developed a series of modifications and changes to meet the needs of the larger businesses that they have installed the product in. They have a wide range of these based upon sector and process type; they can select which of these to install on a "mix and match" method. This requires a good knowledge of the product AND of the business - and I would suggest that this one area is responsible for many of the problems that occur during implementation.
Now it gets even murkier. In some of the consultancies, the people that work for them are employees, but many are only on short term contracts - say 18 months to 2 years. These consultancies will hire people for the specific project based upon need and skill. Unfortunately, many of the people hired are of varying quality - and in some cases, they end up working in a module area that they are not particularly skilled in. I've also seen that the consultancy can hire in a person who is in turn a private contractor, and these generally get paid by the day or week. I also understand that in some cases, the larger consultancy contracts out part of the work to a smaller firm. And of course, the smaller firm can then hire in the actual people, who might even be employed by yet another business.
You see, some of these consultancies specialize in specific areas - HR, Accounts, or groups of modules such as those that make up the manufacturing process. The concept is fairly sound - you hire in the expertise in the area that you have the need. This allows you to act as a consultant even if you don't have the required specialization.
But with all of these different people, using different employment methods and structures of reporting, you find communication problems even in the relatively simple projects. From experience, many of the individuals like to work in particular way and use specific methods or practices - in some cases, these clearly don't meet the specific requirements, and I've seen that they often go against the defined goals.
Now, for a lot of people, this will seem a strange way of working - but you have to understand that this is the SAP business model. They are NOT in the business of selling software - they actually want to sell the knowledge and experience of the consultants, either as business consultants, project management, training, education services - basically all of the additional items that are perhaps a bit harder to quantify.
Don't get me wrong, when the software is set-up properly, it seems to work well (if perhaps a bit long winded). However, I would suggest that the way that the product is sold and then managed is almost designed to lead to issues that will then require the hiring of additional outside expertise. The problem then of course is that often people get locked in to the product - no-one (especially in senior management) wants to admit that they might have made a mistake, so they act like the gambler who keeps on playing in the hope that the one big win will cover all his losses.
Our project is one of the less expensive ones - we've spent nearly $2 million so far after 2 years and based upon some of the comments and observations, I expect that we will see an annual expenditure of another $100k to $150k for the next 5 years in addition to any contracted support cost (which was hiked from the beginning of the year). I still have a copy of the original documents - they stated categorically that the total cost over the first 5 years would be $1.06 million and this covered all installation costs, support and consultancy.
In reality, we will probably have spent around 3 times as much by the time that we are finished. I did some basic numbers and to get the return that they suggested, we would have to continue to use the product for around 18-20 years, and that doesn't allow for any subsequent changes or projects. I have to be honest, I cannot see that we will ever actually get a return on our investment - it's just going be a big old money pit.
Sunday, 14 June 2009
It's a lovely day...
....for sitting in the sun, maybe move into the shade a bit later, and share some bread & wine with the family and just generally enjoy a very pleasant weekend. Maybe a barbecue on Sunday?
However, part of the time I've spent doing some SAP related work. I discovered a minor issue on one of the servers - not enough to cause a big problem, but I want to try to eliminate any of these little errors before we go live - I think that we'll have enough to do once we achieve liftoff.
Now the actual SAP global support people are pretty good for the most part - the method of reporting errors is a bit of a pain at times, but once you get someone on the case, they've shown that they can get things done. So far, they've managed to fix almost all of the issues that I've raised - the biggest problem I see is trying to identify the correct function area for the problem to be listed under and they can be a bit sharp with you if you enter the wrong data.
On this occasion, it's actually been passed through 3 different support people - as each one has looked at it, they've suggested that the problem is caused by something different. The last one has asked me to carry out yet another set of upgrades. As has been indicated, my staff and I have had very little real training and the instructions that we received were so vague that they proved to be of little value. I have however been given the email address of a guy in Germany that is prepared to help - he writes / speaks pretty good English (a good job as Ich verstehe nur ein bission Deutche!)
The information that he provided for how to download and carry out the upgrades was not perfect - however, after reading and checking the information carefully, I have been able to use it to work out the correct procedure. I've also been able to create my own training document on how to do this specific task so any of my guys could do it if I'm not available. For me it's important that we don't rely on any single person's knowledge - it's too risky and I've seen companies that suffered because they were stuck when a key employee left them.
So on Friday, I managed to get the test system upgraded to the latest relase of the kernel. I actually am quite surprised that it went so well - prevously, the work was done by one of the basis people from the consultants and we had all sorts of problems both during and after the work was done. On this occasion, the update worked so well, that I just couldn't believe it. I literally spent about an hour trying to find a problem before I was prepared to think that maybe it had completed successfully. I then carried out the upgrade on the other systems after everyone had finished for the day and by late on Friday, it was all done. Subsequently, I carried out a system transport of the use role profiles. Again, it all went quite well, so we can start Monday with a freshly patched system.
Now this may not seem like a big deal - for many people, patching and updates are a pretty simple process and one that most users don't see too much of. Within the company, we run an automated patching solution for all of the PCs and servers that takes care of the OS, the productivity suite, and most of the other software products we use and that has saved time and money over the years. It also ensures that as far as possible, we are protected against malware - an ounce of prevention is better than a pound of cure.
But for me, the ability to be able to this work without having to rely on the outside consultants is a major step forward. I don't think that I can understate just how much better that makes me feel - stupid I know, but having been thru such a long process with so many problems and so many failed areas, this is a real achievement even if it is such a small success. Now this doesn't mean that finally all is well - I wish! But at this point in time, I'm prepared to take anything positive that I can find and use.
So now, the work is done - time to relax and feel good about having finally achieved something positive. Now if we could just get the rest of it working the same way.....
-------------------------
BTW, I see that I have a couple more followers - welcome to you all. I hope that you enjoy reading my comments, and find them of some value. I will keep on writing as things happen; I think that we are now pretty committed to going live later this year (but more on that next time) and I will continue to detail what happens after the big event. So keep watching...
However, part of the time I've spent doing some SAP related work. I discovered a minor issue on one of the servers - not enough to cause a big problem, but I want to try to eliminate any of these little errors before we go live - I think that we'll have enough to do once we achieve liftoff.
Now the actual SAP global support people are pretty good for the most part - the method of reporting errors is a bit of a pain at times, but once you get someone on the case, they've shown that they can get things done. So far, they've managed to fix almost all of the issues that I've raised - the biggest problem I see is trying to identify the correct function area for the problem to be listed under and they can be a bit sharp with you if you enter the wrong data.
On this occasion, it's actually been passed through 3 different support people - as each one has looked at it, they've suggested that the problem is caused by something different. The last one has asked me to carry out yet another set of upgrades. As has been indicated, my staff and I have had very little real training and the instructions that we received were so vague that they proved to be of little value. I have however been given the email address of a guy in Germany that is prepared to help - he writes / speaks pretty good English (a good job as Ich verstehe nur ein bission Deutche!)
The information that he provided for how to download and carry out the upgrades was not perfect - however, after reading and checking the information carefully, I have been able to use it to work out the correct procedure. I've also been able to create my own training document on how to do this specific task so any of my guys could do it if I'm not available. For me it's important that we don't rely on any single person's knowledge - it's too risky and I've seen companies that suffered because they were stuck when a key employee left them.
So on Friday, I managed to get the test system upgraded to the latest relase of the kernel. I actually am quite surprised that it went so well - prevously, the work was done by one of the basis people from the consultants and we had all sorts of problems both during and after the work was done. On this occasion, the update worked so well, that I just couldn't believe it. I literally spent about an hour trying to find a problem before I was prepared to think that maybe it had completed successfully. I then carried out the upgrade on the other systems after everyone had finished for the day and by late on Friday, it was all done. Subsequently, I carried out a system transport of the use role profiles. Again, it all went quite well, so we can start Monday with a freshly patched system.
Now this may not seem like a big deal - for many people, patching and updates are a pretty simple process and one that most users don't see too much of. Within the company, we run an automated patching solution for all of the PCs and servers that takes care of the OS, the productivity suite, and most of the other software products we use and that has saved time and money over the years. It also ensures that as far as possible, we are protected against malware - an ounce of prevention is better than a pound of cure.
But for me, the ability to be able to this work without having to rely on the outside consultants is a major step forward. I don't think that I can understate just how much better that makes me feel - stupid I know, but having been thru such a long process with so many problems and so many failed areas, this is a real achievement even if it is such a small success. Now this doesn't mean that finally all is well - I wish! But at this point in time, I'm prepared to take anything positive that I can find and use.
So now, the work is done - time to relax and feel good about having finally achieved something positive. Now if we could just get the rest of it working the same way.....
-------------------------
BTW, I see that I have a couple more followers - welcome to you all. I hope that you enjoy reading my comments, and find them of some value. I will keep on writing as things happen; I think that we are now pretty committed to going live later this year (but more on that next time) and I will continue to detail what happens after the big event. So keep watching...
Wednesday, 10 June 2009
Another 2 cents worth..
Uhhmmm...
We had another meeting yesterday - the director from the consultants arrived with a new guy in tow. Introduced as our new CRM consultant - however, we did some investigation and it turns out that he last did CRM some 5 years ago with version 4 of the product. Since then, he has acted as PM for most of the project he worked. So he seems like a really sensible choice (not).
During the meeting, the director from the consultants said that the new guy would be spending about 10-12 days on site to get an idea of what our requirements were. Excuse me.... what have they been doing for the last 2 years? Un - believable.
Now we were promised at the previous meeting I referred to, they would carry out a demonstration using a customer's system to show that the product works. (That was actually supposed to have been done about a week ago.) However, that still hasn't happened yet - and in addition, they said that they are now setting up a test system for us to see, and they want to make sure that it is OK before they do the demo so it will be another couple of weeks. Color me crazy, but I would have expected that to happen before we bought the damn product, not two years into the project and certainly not a couple of months before we are due to go live.
I have to say that I think the director from the consultants is so full of BS that he could fertilize the Sahara. If he told me that the sun rose in the East, I would want to get up at midnight to check it out for myself, before I would actually believe him. The funniest bit was his insistence that we are on target - we are now actually well over a year behind, but that doesn't seem to be an issue for him. He also tried to say that it's within budget - but not according to their documents, which I still have a copy of. We are in fact over spent by 3 times the original figure they quoted for a 5 year write off - and we had identified at the time that their figure were incorrect as they didn't include several key expenditures.
When I left the meeting, I just wanted to explode.....
The same consultants are also working on another project and occasionally, they can't get to us because they are on site with the other company. They started this project way before ours - not sure just how much longer it's been running. This other company went live back in the new year - I tried to contact them, but their IT manager wouldn't discuss the project with me (they had been told not to I think from the sound of it). Since then, one of our sales staff spoke to one of theirs - and they got the woman's number for me to call.
She's fairly new in the job as it appears they have lost quite a few sales staff because of the project - and she made it clear that she doesn't want to stay long either. She made some comments that no-one really seems to know how the system is supposed to work and they get all sorts of problems during the day which take ages to resolve (she referred to one problem that took 3 days to fix and they lost a huge sale because of this). Their sales people are really fed up with all the wasted time - and it also appears that they lost a couple of IT staff as well which has made the problem much worse.
I've also had a contact with another company (different consultants) - they have only implemented part of the SAP system so far - sales, purchasing and accounts. One of our people went to see them and talked about how they were getting on - they seemed to be doing OK, so it shows that it can happen. But they have also indicated that they are still getting issues - it appears that they had a problem with getting the invoicing correct. I'm not sure exactly what their problem was, but it sounds as if it was applying the wrong pricing. This is something that can happen to any company and I would suggest that most systems have done that at one stage or another, so it would be unfair to highlight this as if it was just SAP.
But even they said that the process had been painful and they were not entirely happy that they were getting all of the benefits that they expected. Questions have been raised about the cost of the project and it seems unlikely they will realise any actual savings for their investment.
Someone made a comment that bad news travels faster than good news - true and I accept that many big project fail somewhere along the line and I'm sure that there are some SAP projects that are models of success. But for me this has been by far the worst project I have ever been involved in by a long way - I've worked with some really astute business people in the past, and I know that they would have demanded heads to roll for a failure a bad as ours has been. I really can see the ax swinging at some stage - and I'm concerned that my guys and I will suffer as a result.
Oh well, tomorrow is another day...
We had another meeting yesterday - the director from the consultants arrived with a new guy in tow. Introduced as our new CRM consultant - however, we did some investigation and it turns out that he last did CRM some 5 years ago with version 4 of the product. Since then, he has acted as PM for most of the project he worked. So he seems like a really sensible choice (not).
During the meeting, the director from the consultants said that the new guy would be spending about 10-12 days on site to get an idea of what our requirements were. Excuse me.... what have they been doing for the last 2 years? Un - believable.
Now we were promised at the previous meeting I referred to, they would carry out a demonstration using a customer's system to show that the product works. (That was actually supposed to have been done about a week ago.) However, that still hasn't happened yet - and in addition, they said that they are now setting up a test system for us to see, and they want to make sure that it is OK before they do the demo so it will be another couple of weeks. Color me crazy, but I would have expected that to happen before we bought the damn product, not two years into the project and certainly not a couple of months before we are due to go live.
I have to say that I think the director from the consultants is so full of BS that he could fertilize the Sahara. If he told me that the sun rose in the East, I would want to get up at midnight to check it out for myself, before I would actually believe him. The funniest bit was his insistence that we are on target - we are now actually well over a year behind, but that doesn't seem to be an issue for him. He also tried to say that it's within budget - but not according to their documents, which I still have a copy of. We are in fact over spent by 3 times the original figure they quoted for a 5 year write off - and we had identified at the time that their figure were incorrect as they didn't include several key expenditures.
When I left the meeting, I just wanted to explode.....
The same consultants are also working on another project and occasionally, they can't get to us because they are on site with the other company. They started this project way before ours - not sure just how much longer it's been running. This other company went live back in the new year - I tried to contact them, but their IT manager wouldn't discuss the project with me (they had been told not to I think from the sound of it). Since then, one of our sales staff spoke to one of theirs - and they got the woman's number for me to call.
She's fairly new in the job as it appears they have lost quite a few sales staff because of the project - and she made it clear that she doesn't want to stay long either. She made some comments that no-one really seems to know how the system is supposed to work and they get all sorts of problems during the day which take ages to resolve (she referred to one problem that took 3 days to fix and they lost a huge sale because of this). Their sales people are really fed up with all the wasted time - and it also appears that they lost a couple of IT staff as well which has made the problem much worse.
I've also had a contact with another company (different consultants) - they have only implemented part of the SAP system so far - sales, purchasing and accounts. One of our people went to see them and talked about how they were getting on - they seemed to be doing OK, so it shows that it can happen. But they have also indicated that they are still getting issues - it appears that they had a problem with getting the invoicing correct. I'm not sure exactly what their problem was, but it sounds as if it was applying the wrong pricing. This is something that can happen to any company and I would suggest that most systems have done that at one stage or another, so it would be unfair to highlight this as if it was just SAP.
But even they said that the process had been painful and they were not entirely happy that they were getting all of the benefits that they expected. Questions have been raised about the cost of the project and it seems unlikely they will realise any actual savings for their investment.
Someone made a comment that bad news travels faster than good news - true and I accept that many big project fail somewhere along the line and I'm sure that there are some SAP projects that are models of success. But for me this has been by far the worst project I have ever been involved in by a long way - I've worked with some really astute business people in the past, and I know that they would have demanded heads to roll for a failure a bad as ours has been. I really can see the ax swinging at some stage - and I'm concerned that my guys and I will suffer as a result.
Oh well, tomorrow is another day...
Monday, 1 June 2009
Another day, another dollar
We had another meeting today, with just one question – "why are we still no closer to go live than we were before the New Year?" I put forward my list, the same one that I have kept since around last June; of the items listed, only one has actually been resolved. Their project manager spent about 15-20 minutes going thru the points, but at the end the only real answer for all the issues was “it hasn’t been done”. For what it’s worth, my list was actually one of the smallest – there are still over 300 items on the open issues register.
Now I will accept that my list is the only one that hasn’t actually been growing in the last 12 months – all the points I raised have been around since then at least. Of my colleagues, most have discovered more issues as we progress through the various parts of testing and correcting. However, about half of the items have been on the list for at least a year – we know because we recorded the date entered against the item. More than a few had been marked as fixed, only for us to find that they were not, or for other changes to have broken them again.
At the end of the meeting, we had actually achieved very little. Once again, lots of promises, but nothing to back up what they say. People were very quiet coming out of the meeting; in the past, they had grouped together to bitch about the lack of progress but this time, almost everyone just went off back to their departments without a word.
The FD was in one of his moods after the meeting. He wanted to talk to me because a decision has been made that wasn’t discussed. As I’ve indicated we have sites overseas – one of these was supposed to be going live shortly after us. To make that happen, we had planned a lot of changes to provide the infrastructure, most of which are now in place. It appears that this has all been pretty much wasted – the directors have decided that we will continue with the SAP project, but it seems unlikely that we are going to roll it out across the group for at least 3-4 years, and possibly not even then. (But this isn’t generally known just yet)
He showed me a document that detailed the consultant fees for that overseas site (not the same group that we work with, a different company) – just under $180,000. Apparently, the work they did was of no value as it didn’t match the site requirements, our group requirements or meet the needs of our consultants. It appears that we have no possibility of getting our money back – the company that these consultants worked for is in the local equivalent of chapter 11 and it seems probable that they will simply cease to exist.
Now I know that there are people that will say, “$180k is not a great deal for an SAP implementation” – true and I know of a company that spent $30 million, but we couldn’t afford to spend even a small part of that kind of money. To put it in context, our total group profits for the last 10 years was just over $30 million. We have a great product and excellent service - we retain a lot of customers for this reason. But we cannot justify spending that much money unless we get seriously improved efficiencies and I doubt we will see a return that will be even close.
What makes me really mad is that I have a small project I’m working on; it won’t get us any extra sales as such, but we can see the potential for better analysis to make us more labor efficient in one area and that might get a few more sales. The cost of the product? - $2495 plus tax, and this includes a half days training. However, I am having to again justify spending the money even tho’ I put it on my budget before the start of the financial year.
What’s really getting people pissed is the director from the consultants – he turns up having flown to the local airport, takes part in a 2 hour meeting then back to the airport for another flight. He promises much, but so far has delivered zip – everyone calls him the seagull, because he flies in, makes a loud noise, craps on everyone then flies off!
Better sign off – I’m waiting for a response from Global support.
Now I will accept that my list is the only one that hasn’t actually been growing in the last 12 months – all the points I raised have been around since then at least. Of my colleagues, most have discovered more issues as we progress through the various parts of testing and correcting. However, about half of the items have been on the list for at least a year – we know because we recorded the date entered against the item. More than a few had been marked as fixed, only for us to find that they were not, or for other changes to have broken them again.
At the end of the meeting, we had actually achieved very little. Once again, lots of promises, but nothing to back up what they say. People were very quiet coming out of the meeting; in the past, they had grouped together to bitch about the lack of progress but this time, almost everyone just went off back to their departments without a word.
The FD was in one of his moods after the meeting. He wanted to talk to me because a decision has been made that wasn’t discussed. As I’ve indicated we have sites overseas – one of these was supposed to be going live shortly after us. To make that happen, we had planned a lot of changes to provide the infrastructure, most of which are now in place. It appears that this has all been pretty much wasted – the directors have decided that we will continue with the SAP project, but it seems unlikely that we are going to roll it out across the group for at least 3-4 years, and possibly not even then. (But this isn’t generally known just yet)
He showed me a document that detailed the consultant fees for that overseas site (not the same group that we work with, a different company) – just under $180,000. Apparently, the work they did was of no value as it didn’t match the site requirements, our group requirements or meet the needs of our consultants. It appears that we have no possibility of getting our money back – the company that these consultants worked for is in the local equivalent of chapter 11 and it seems probable that they will simply cease to exist.
Now I know that there are people that will say, “$180k is not a great deal for an SAP implementation” – true and I know of a company that spent $30 million, but we couldn’t afford to spend even a small part of that kind of money. To put it in context, our total group profits for the last 10 years was just over $30 million. We have a great product and excellent service - we retain a lot of customers for this reason. But we cannot justify spending that much money unless we get seriously improved efficiencies and I doubt we will see a return that will be even close.
What makes me really mad is that I have a small project I’m working on; it won’t get us any extra sales as such, but we can see the potential for better analysis to make us more labor efficient in one area and that might get a few more sales. The cost of the product? - $2495 plus tax, and this includes a half days training. However, I am having to again justify spending the money even tho’ I put it on my budget before the start of the financial year.
What’s really getting people pissed is the director from the consultants – he turns up having flown to the local airport, takes part in a 2 hour meeting then back to the airport for another flight. He promises much, but so far has delivered zip – everyone calls him the seagull, because he flies in, makes a loud noise, craps on everyone then flies off!
Better sign off – I’m waiting for a response from Global support.
Sunday, 24 May 2009
The sun is shining...
It has been a particularly nice weekend - I've not had to do any SAP work (although I've been checking up on some other IT issues). We went out yesterday for a walk in the country, and it was extremely relaxing. Because of that, I'm in a slightly better mood and decided to write about some parts of the project that have been a bit more positive.
For one thing, we are getting data cleaned up. About 4 years ago, I raised the issue of data integrity and consistency and it has been a topic of conversation many times since. Although people have tried to do this at various stages, we have a large amount of really poor data in the various systems. For example, in the legacy systems we use, the customer / supplier addresses don't match, and not just the wrong zip codes - some of it is far worse. Few of the systems have consistent contact information and many of the details are out of date (people no longer working at the particular company for example). I hate to say it, but there is a similar problem with product information, manufacturing data, accounting information etc as well.
The SAP project has been a good opportunity to address this; and a considerable amount of work has been put in to tidy up the data before migrating it over into the new system. People were tasked with this and a lot has been done - although I think we could have done a better job of explaining what they needed to do as several of them didn't get it right, and we have had to send the data back to them for checking not just once or twice, but many times. A case in point was one of the sales staff dealing with pricing for export - after 3 months, he still hadn't got the right prices against the right products. In the past he had been allowed to get away with asking for changes to be made by the IT staff when errors were found, but not on this occasion.
As a result of all this work, we now have a much better idea of where some of our pricing is wrong, and we can adjust this to ensure that in future it is much better - we know that we have lost potential orders in the past as our pricing was too high, and now I think we can be a bit more competitive.
For many years now, the production team have worked on getting a leaner approach to the job, and they always have a project underway to improve processes. I know that they have used the SAP project to take a good look at some of the specific processes they have not previously covered to see if there is a better way of working. The project team in particular have benefited from this navel gazing - I think that they will need to look again at some of their processes in about a years time though, as I'm not sure that they have achieved what they need to. However, having taken a long hard look at what they do for this project, I hope that it will enable them to do it again.
Although the accounting side is still not working as it should, it has highlighted a big issue relating to reporting - this was not something that we did particularly well in the past. If we can get all of the various reports working correctly, then I expect we have a much better understanding of where our costs are coming from. At a previous company I worked for, they could accurately show what each sale cost, to indicate profit or loss - my current employer only knows that once all of the finances for the year have been finalised.
There is another small project that I am working on for our telesales people and it has highlighted some of the areas where it is clear we could do much better. We had hoped that the CRM would build upon this so that we could streamline the process. That has most definitely not worked, but the principle has been shown to be sound.
These various things have confirmed something - that most people in the business don't actually know what it is they want. Because of this, it is difficult for them to articulate their needs in a way that makes sense in IT terms. To be fair to the consultants, this has been a real problem and made worse as most of them haven't had experience in our paricular sector. However, having to go through these various steps, painful as they have been, has actually been of some benefit. Although they still have a way to go, most of the managers now do appreciate some of the issues relating to poor data, incomplete requirements definition etc. And that can't be a bad thing!
Might even head to the beach this afternoon - it looks as if it will be a great day for swimming.
For one thing, we are getting data cleaned up. About 4 years ago, I raised the issue of data integrity and consistency and it has been a topic of conversation many times since. Although people have tried to do this at various stages, we have a large amount of really poor data in the various systems. For example, in the legacy systems we use, the customer / supplier addresses don't match, and not just the wrong zip codes - some of it is far worse. Few of the systems have consistent contact information and many of the details are out of date (people no longer working at the particular company for example). I hate to say it, but there is a similar problem with product information, manufacturing data, accounting information etc as well.
The SAP project has been a good opportunity to address this; and a considerable amount of work has been put in to tidy up the data before migrating it over into the new system. People were tasked with this and a lot has been done - although I think we could have done a better job of explaining what they needed to do as several of them didn't get it right, and we have had to send the data back to them for checking not just once or twice, but many times. A case in point was one of the sales staff dealing with pricing for export - after 3 months, he still hadn't got the right prices against the right products. In the past he had been allowed to get away with asking for changes to be made by the IT staff when errors were found, but not on this occasion.
As a result of all this work, we now have a much better idea of where some of our pricing is wrong, and we can adjust this to ensure that in future it is much better - we know that we have lost potential orders in the past as our pricing was too high, and now I think we can be a bit more competitive.
For many years now, the production team have worked on getting a leaner approach to the job, and they always have a project underway to improve processes. I know that they have used the SAP project to take a good look at some of the specific processes they have not previously covered to see if there is a better way of working. The project team in particular have benefited from this navel gazing - I think that they will need to look again at some of their processes in about a years time though, as I'm not sure that they have achieved what they need to. However, having taken a long hard look at what they do for this project, I hope that it will enable them to do it again.
Although the accounting side is still not working as it should, it has highlighted a big issue relating to reporting - this was not something that we did particularly well in the past. If we can get all of the various reports working correctly, then I expect we have a much better understanding of where our costs are coming from. At a previous company I worked for, they could accurately show what each sale cost, to indicate profit or loss - my current employer only knows that once all of the finances for the year have been finalised.
There is another small project that I am working on for our telesales people and it has highlighted some of the areas where it is clear we could do much better. We had hoped that the CRM would build upon this so that we could streamline the process. That has most definitely not worked, but the principle has been shown to be sound.
These various things have confirmed something - that most people in the business don't actually know what it is they want. Because of this, it is difficult for them to articulate their needs in a way that makes sense in IT terms. To be fair to the consultants, this has been a real problem and made worse as most of them haven't had experience in our paricular sector. However, having to go through these various steps, painful as they have been, has actually been of some benefit. Although they still have a way to go, most of the managers now do appreciate some of the issues relating to poor data, incomplete requirements definition etc. And that can't be a bad thing!
Might even head to the beach this afternoon - it looks as if it will be a great day for swimming.
Thursday, 14 May 2009
Status Report
The go live is delayed again - it seems appropriate to put together an overview of where we are.
From the previous post, you'll know that the CRM just isn't working - the consultants are squirming like worms on a hot plate, but whatever they say, it is just no good in it's current format. We've tried our best, but at some point we will have to move on.
By department, Marketing probably have the least to worry about - no CRM, and nothing else has been arranged. They will almost certainly not be using SAP at all.
The Sales staff are reasonably happy with their processes in the ERP and can make quotes, place orders etc. fairly well. There is a problem in that it still doesn't price things up correctly; some of the tests have come out with really bad results, up to $100 out on a single item. This is being looked at, but it has been an issue for about 6-8 months now. There were problems with the output documents such as invoices, confirmations etc. but most of these have been rectified. The remaining issues are a nuisance, but wouldn't stop us going live - although we might look a bit stupid with some of the errors.
Purchasing is also working well for the most part - their only problems are back to back ordering and batching of purchase items which have been an issue almost from the beginning. There have also been some concerns over the releasing of purchase orders; we have found occasional glitches. However, these have not been too serious.
Within Manufacturing, most of the processes are also OK, but there has been an issue with goods movement - it still isn't right. About a third of them are having to be corrected by the senior production manager and he has been given much higher access than would normally be the case just so that he can correct these problems. They do have an issue in that some of the workshop documentation they need is still not yet working - and this could cause serious delays in the output as the staff have to wait for production managers to resolve quite simple inquiries.
The Inventory is a big problem - so far, we've not been able to get a valid figure on anything, and some of the errors are so riduculous. Literally thousands of items appear on stock figures instead of 1.
The Project Team are badly affected by this and it has proven to be the biggest failure so far. Transfer of goods between sites generates all sorts of strange anomalies. On top of that, only about 10% of the standard project tests came out even close to being correct - several have generated errors in the 10s of thousands of dollars and in one case almost half a million dollars.
Logistics have managed to work around the few issues that they had - there is a problem with the stock racking, but they can live with it. They have been waiting for their output documentation for months - they finally got it sorted about a month ago, and we've also now managed to get the address labels printing this week. However, there is still an issue with some of the output - addresses don't quite appear correctly. This is not too serious, but we would like to get it right if possible.
The finance though is a mess - the chart of accounts just didn't match what we needed. The consultant that was supposed to be their specialist didn't seem to understand some of the basic requirements. At this stage, we can just about invoice, but there are major discrepancies and no sign of how these can be resolved yet. They also don't have access to a lot of the reports that we were told they would be able to generate. It is still being worked on, but the Accounts staff are not happy at all.
The QA / QC people are also not satisfied - the defect notification aspect appears to be non operational. They have tried several times, but so far the consultants appear to have no one that has even the most basic understanding of this aspect.
There were so many other reports missing, that almost every department was concerned. We have had a specialist on site and he has fixed several of these, but not all of them. This of course is a major reason for buying an ERP system - without it, we will struggle to use it for more than a few months.
Finally, we are supposed to have a Document Management system, and yes it is installed. However, there are serious questions still unanswered about how it will work - it was supposed to automate several processes, but instead they have become more labor intensive. We were given to understand over a year ago that they had a way of scanning incoming paper based files for auto assigment - this was completely incorrect, the consultants just referred us to another company that wanted to sell us new xerox machines at twice the price we paid for the ones we have, and still use a manual system for assignment.
So there we are - the go live date has been pushed back again and is now beginning of 4th quarter 2009. When we first met with the consultants, they promised us a go live of January 2008 - I said at the time that was completely impossible, but they were so confident. The strange thing is that their director insists that they made no such promise despite us showing him the actual letters that he wrote.
Oh well, tomorrow is another day.
From the previous post, you'll know that the CRM just isn't working - the consultants are squirming like worms on a hot plate, but whatever they say, it is just no good in it's current format. We've tried our best, but at some point we will have to move on.
By department, Marketing probably have the least to worry about - no CRM, and nothing else has been arranged. They will almost certainly not be using SAP at all.
The Sales staff are reasonably happy with their processes in the ERP and can make quotes, place orders etc. fairly well. There is a problem in that it still doesn't price things up correctly; some of the tests have come out with really bad results, up to $100 out on a single item. This is being looked at, but it has been an issue for about 6-8 months now. There were problems with the output documents such as invoices, confirmations etc. but most of these have been rectified. The remaining issues are a nuisance, but wouldn't stop us going live - although we might look a bit stupid with some of the errors.
Purchasing is also working well for the most part - their only problems are back to back ordering and batching of purchase items which have been an issue almost from the beginning. There have also been some concerns over the releasing of purchase orders; we have found occasional glitches. However, these have not been too serious.
Within Manufacturing, most of the processes are also OK, but there has been an issue with goods movement - it still isn't right. About a third of them are having to be corrected by the senior production manager and he has been given much higher access than would normally be the case just so that he can correct these problems. They do have an issue in that some of the workshop documentation they need is still not yet working - and this could cause serious delays in the output as the staff have to wait for production managers to resolve quite simple inquiries.
The Inventory is a big problem - so far, we've not been able to get a valid figure on anything, and some of the errors are so riduculous. Literally thousands of items appear on stock figures instead of 1.
The Project Team are badly affected by this and it has proven to be the biggest failure so far. Transfer of goods between sites generates all sorts of strange anomalies. On top of that, only about 10% of the standard project tests came out even close to being correct - several have generated errors in the 10s of thousands of dollars and in one case almost half a million dollars.
Logistics have managed to work around the few issues that they had - there is a problem with the stock racking, but they can live with it. They have been waiting for their output documentation for months - they finally got it sorted about a month ago, and we've also now managed to get the address labels printing this week. However, there is still an issue with some of the output - addresses don't quite appear correctly. This is not too serious, but we would like to get it right if possible.
The finance though is a mess - the chart of accounts just didn't match what we needed. The consultant that was supposed to be their specialist didn't seem to understand some of the basic requirements. At this stage, we can just about invoice, but there are major discrepancies and no sign of how these can be resolved yet. They also don't have access to a lot of the reports that we were told they would be able to generate. It is still being worked on, but the Accounts staff are not happy at all.
The QA / QC people are also not satisfied - the defect notification aspect appears to be non operational. They have tried several times, but so far the consultants appear to have no one that has even the most basic understanding of this aspect.
There were so many other reports missing, that almost every department was concerned. We have had a specialist on site and he has fixed several of these, but not all of them. This of course is a major reason for buying an ERP system - without it, we will struggle to use it for more than a few months.
Finally, we are supposed to have a Document Management system, and yes it is installed. However, there are serious questions still unanswered about how it will work - it was supposed to automate several processes, but instead they have become more labor intensive. We were given to understand over a year ago that they had a way of scanning incoming paper based files for auto assigment - this was completely incorrect, the consultants just referred us to another company that wanted to sell us new xerox machines at twice the price we paid for the ones we have, and still use a manual system for assignment.
So there we are - the go live date has been pushed back again and is now beginning of 4th quarter 2009. When we first met with the consultants, they promised us a go live of January 2008 - I said at the time that was completely impossible, but they were so confident. The strange thing is that their director insists that they made no such promise despite us showing him the actual letters that he wrote.
Oh well, tomorrow is another day.
Subscribe to:
Posts (Atom)