Advantage of ERP systems Essay

Advantage of ERP systems
The fundamental advantage of ERP is that integrated countless business processes saves time and expense. Management can make decisions faster and with fewer errors. Data becomes visible across the company. Tasks that benefit from this integration include (Wikipedia, n.d.)
Sales forecasting which allows inventory optimization.
Chronological history of every transaction through relevant data compilation in every area of operation.
Order tracking, from acceptance through fulfillment
Revenue tracking, from invoice through cash receipt
Matching purchase orders (what was ordered), inventory receipts (what arrived), and costing (what the vendor invoiced)
ERP systems centralize business data, which
Clean up the need to same changes between multiple systems-consolidation of finance, marketing, sales, human resource, and manufacturing applications
Brings legality and transparency to each bit of statistical data
Facilitates standard product naming/coding
Provides an overall enterprise view (no "islands of information"), making realtime information available to management anywhere, any time to make proper decisions
Protects sensitive data by consolidating multiple security systems into a single structure
Disadvantage of Ms Excel spreadsheet
The excel file will be attached by the viruses through macros which are mini programs that are written into an Excel spreadsheet. The file size also will cause very big even through only using one file, and the program run very slow. Therefore, you might have to break it into smaller files. To do this, there is an increased risk in Excel data being lost. (onlinesciences, n.d.)
It is still hard to use and might not get the hang of it even through there are training programs. While it is easy to create the formulas, the reference cells, copy and paste the data, and link the worksheets and spreadsheets together as the work gets more multiplex, the spreadsheets become more difficult to change and manage. (onlinesciences, n.d.)
The spreadsheets are ideal for creating one time analysis, they become problematic as the data grows and develop over time. The summary ranges and formulas may need to be modified or new ones created as new rows and columns get added. The data and the formulas are not consistently updated, and these mistakes lead to bad results and decisions. (onlinesciences, n.d.)
The entering the data will be taken longer time into Excel manually especially if there is a lot of data to be entered. This will also cause inefficient work to enter the data and can also lead to boredom which leads to potentially costly inattentiveness. (onlinesciences, n.d.)
The Visual Basic for Applications (VBA) can be used within forms. The utmost user does not have more knowledge of VBA and therefore they will not be able to incorporate the functional forms into their spreadsheets quickly. (onlinesciences, n.d.)
The powerful of Microsoft Excel worksheet this is a big disadvantage. Although, it does offer a good breed of graph capabilities, the customization of the standard formats, and the combination of different data sets and different types of graph is mortified and not intuitive. (onlinesciences, n.d.)