Saturday, November 01, 2008

ERP

Introduction

Enterprise Resource Planning can truly be understood when you read the initials in reverse. ‘Planning & managing Resources for an Enterprise’. ERP is software which binds the business processes of an organization and shares a common database across all departments.

Why ERP?

To understand this concept better we start with an example. Consider a hawker selling take away food. Currently the owner is the whole and sole of the business that he makes. All he has to do is buy raw material from the market. Make food. Sell it. Make profit out of it. All that he does at the end of the day is take out his note book and write the amount of money spent on the items he bought from the market. Amount he got after selling the food. He calculates his profit daily.

Few years down the line when he starts earning a lot of profit. He expands his business by getting more raw materials making more food. His expansion of the business then finds no limits. He hires people to work under him. Then his business turns to a chain of restaurants not only in the city but across the country.

The only problem here is he now cannot have a note book writing amounts spent on raw material and calculating the profits after selling it. But he has to take care of the vast property he owns, salary of employees, managing his assets, inventory for raw material, calculating tax and profitability etc. So all we can do is understand his business process, roles of people and create a system which will have a common database but would keep a track of all documents, will enforce business rules right from hiring employee to his/her retirement, or buying a raw material to dispatching the final product.

Without ERP all an organization would do is have separate department and separate system for each department. Coupling between them was so loose that keeping track of various data was a cumbersome activity. Typical difficulties involved integration of data from potentially different computer manufacturers and systems. For example, the inventory system would typically manage inventory. It will not have any connection with the Accounts department but just a set of data which would flow across. Each system would have to integrate using a predefined set of common data which would be transferred between each computer system. Any deviation from the data format or the integration schedule often resulted in problems.

Hence ERP is software which has a common database across the organization. It enforces business process to be followed without which it doesn’t budge. It can create significant efficiencies in your business, resulting in timely business information, better customer relationships, a more cost-effective supply chain, improved internal process and, ultimately, increased profitability.

History

ERP (Enterprise Resource Planning) is the evolution of Manufacturing Requirements Planning (MRP) II. From business perspective, ERP has expanded from coordination of manufacturing processes to the integration of enterprise-wide backend processes. From technological aspect, ERP has evolved from legacy implementation to more flexible tiered client-server architecture.

The following table summarizes the evolution of ERP from 1960s to 1990s.

      1960s Inventory Management & Control
      1970s Material Requirement Planning (MRP)
      1980s Manufacturing Requirements Planning (MRP II)
      1990s Enterprise Resource Planning (ERP)

Implementation

ERP vendors have created ERP using standard business processes in the market. Most vendors have kept ERP so modular in nature so that it becomes easy to customize according to the business needs. It is generally implemented by a third party vendor since ERP is so complex that to develop in house skills become an expensive affair. For implementing we need to analyze if we have desired hardware. Analyze existing processes. These processes might have to be fine tuned to get inline with ERP. Here there is a glitch. Generally organizations are enforced to use business processes provided by ERP and bend the current rules. This is one of the reasons of failure of ERP implementation. Once a set of things are analyzed we have to go ahead with the implementation.

ERP Involves

  • Project Planning
  • Business and Operational Analysis, including Gap Analysis
  • Business Process Re-engineering
  • Installation & Configuration
  • Project Team Training
  • Business Requirement Mapping to Software
  • Module Configuration
  • Data Conversions
  • Custom Documentation
  • End User Training
  • Acceptance Testing
  • Production
  • Post Implementation Audit

Advantages of ERP

  • Ready made projects needs only customization
  • Documentation is a part of the system.
  • Integration of all functions are already exisit
  • Dependancy on Human Resources is eliminated.
  • Suppliers and customers can be communicated online.
  • Increases Business profitability
  • Clean and Open transaction of business.
  • Managing independence of Complex Bill of Material

Disadvantages of ERP

While advantages usually outweigh disadvantages for most organizations implementing an ERP system, here are some of the most common obstacles experienced:

  • Customization in many situations is limited
  • The need to reengineer business processes
  • ERP systems can be cost prohibitive to install and run
  • Technical support can be shoddy
  • ERP's may be too rigid for specific organizations that are either new or want to move in a new direction in the near future.
  • The blurring of company boundaries can cause problems in accountability, lines of responsibility, and employee morale.
  • Resistance in sharing sensitive internal information between departments can reduce the effectiveness of the software.
  • Some large organizations may have multiple departments with separate, independent resources, missions, chains-of-command, etc, and consolidation into a single enterprise may yield limited benefits.
  • The system may be too complex measured against the actual needs of the customer.

Thursday, July 26, 2007

Fooling the processor

Many a times when we use linux this can be done more easily in windows and vice-versa. So is it possible to run two operating systems together one at a time? Yes using Emulators it is possible. These emulators fools the processor and runs 2 operating systems.

Once upon a time when pen drive is something every person having computer has. And due to falling prices now a days its not even expensive to use a pendrive. So thought of using Qemu along with accelerator kemu and twiking with autorun.inf file, what i made was just inserting a pendrive and then your ubuntu starts without booting the pc.

I don't know much advantages of it. There are many. But memory becomes half the size is the biggest disadvantage.

Saturday, May 12, 2007

Connecting two Computers

After I upgraded my Desktop computer I was left with 2 lan cards on my Desktop. I always wanted to Connect my laptop with my Desktop. The prime reason to do this was to get internet connection on my laptop without shelling extra bucks on it.

Desktop has dual boot with Ubuntu and XP
Laptop has only XP in it.

eth0 of Desktop goes to Internet Connection and has a static ip with subnet 255.255.255.0 . I got a CAT5 with crossover crimping done. Connected my lappy with Desktop with it. Made Desktop as a Default gateway for Laptop.

So now eth1 on my Desktop had 10.0.0.1/24 as IP Set and eth0 of Laptop had 10.0.0.2/24 as IP.
I thought this can be done only by setting up proxy server SQUID (or anything else) on Ubuntu. But one of my senior helped me out with two small commands to forward internet connection on the private network.

$ echo 1 > /proc/sys/net/ipv4/ip_forward
$ iptables -t nat -A POSTROUTING -j MASQUERADE

But now the problem starts. I tried reversing the ends of the CAT5 wire. Tested it in my college labs but there was no problem in the wire. But both the computers were not able to ping each other. If I diagnosed after going to XP it did show me that all the NIC are working properly they could ping to themselves and
as far as connection is concern it even showed me that the LAN connection is up and running fine which means there was no "Network Cable Unplugged message".

But ping 10.0.0.1 would give me "Request Time Out"
This meant that the packets are going but there is no acknowledgement from the opposite machine. I tried it with all possible ways
  • Switched the connections of wire.
  • Tried with different OS.
  • Upgraded the drivers of NIC. (which was hopeless decision)
  • Tried with various ips like 192.168.0.1/24
  • Then tried changing the subnetmask.
  • Few said it might be because of compatibility problem with all NIC since all were from different companies.
After all these things I tried with changing connection Value of the LAN CARD. From auto-negotiation I made it to 10T Base Full Duplex. Thats it.
"Request Time Out" budge to "Reply from 10.0.0.1............................" message. And then my joy had no happiness.

I rebooted my Desktop to Ubuntu again. Tried with the ip_forwarding commands. Set my options on laptop. Changed the DNS to the same as DNS of laptop and yes. My browser showed some signs of connection and it displayed a website.

Hence there was successful connection between laptop and Desktop.

Monday, December 04, 2006

Making Cartoons

I generally don't design anything since I am not a designer but thought of making a one of my friends cartoon "avtar" to put it on her scrap book. This idea clicked when one of my friend(Kevin Pinto) had done our cartoons for our web technology's project. The one on the right is his creation.

I started with hunting her photograph. Later used photoshop and opened the picture there. By adding transparent layer I traced the outline using a pencil tool. It did look shabby since it was just mouse that I used. But then had no choice. Later on of my friend gave me an idea of using bezier curves. But he used another tool for making such dough I was making it in photoshop. So later I googled for cartoons to see 1000 different creation. Later I started using simple line tool and then giving it different thickness and curves. I eliminated black colour border line and started using the those tones of the actual fill colours as the outer line. It worked the pieace was looking much neater and cool. I wasn't sure about the face looks since I still have to work on it. But the rest is fine I suppose. It was a real good experince in doing this.

Sunday, December 03, 2006

Google Analytics

My final year project is on "Analysing Web Content through Users Clicks/Access Pattern". Once while surfing few fourms I found one intresting thing. What we were doing is analyzing the content of a particular website which would use this system. But Google has something which collects stats of other website also. One has to just use some browser side scripting software like greasemonkey or something like that. For more information please visit
http://blogs.open.ac.uk/Maths/ajh59/008701.html

Google Desktop

Once while surfing I came across another Google's product. "Google Desktop" Just thought of downloading wow....it simply rooocks. It took me nearly 4 hours on AMD64 Athlon with 512 MB RAM for its indexing. But then it gives results as you type the word just like Winamp media center. Like grep command it scans the documents also which has text material in it. I am yet to find out how much memory it eats but as far as my messy comp is concern Google Desktop has really made me lazy. hehe

Sunday, August 13, 2006

TexLive not on Dapper.

I wanted to make few documentation in Latex. So tried figuring out what should I install through Synaptic Manager. I got few packages but then it did not include packages which I wanted to use. It did not serve me for those package which I need. Edgy edition had the texlive package which included all AMS fonts and amssymb package. So what I had to do is just copy Texlive CD. Change install-tl.sh's first line for bash. And run the file thats it it works. So next time if a shell script is not running please check the first line and see if it for the shell which you have.

Saturday, August 05, 2006

Strange Problem (Motherboard chipset and Sata HDD)

While being with CRAVE we discovered a strange problem. For Crave Project AMD64Athlon with ASUS motherboard, SATA hard disk, 1GB RAM were ordered. Now ASUS motherboard had a chipset of VIA. Its southbridge chipset is VT8215 and for this chipset there are no drivers in linux for SATA hard disk. SUSE, Fedora, Debian, Ubuntu none of the Distributions could detect any SATA hard disk during installation. This made us to come in the soup. So now for the time being most of the machines will have a PATA hard disk. Then after recompiling the kernal it is possible to run Ubuntu on SATA hard disk with VT8215 chipset.

I had similar combination but my chipset was VT8237. This worked. I could nicely install along with SATA drives.

On Ubuntu forums few other people also faced similar problem. One guy had made iso of ubuntu for such a system. For time being that will also be installed on one of the machine.