Saturday, October 11, 2014

Advantages & Disadvantages of ERP (Enterprise Resource Planning) Systems

In order to understand computer networks better, it would be helpful to have an overview of the applications running on the network. ERP or Enterprise Resource Planning is an important enterprise application that integrates all the individual department functions into a single software application.
ERP Systems make it easier to track the workflow across various departments. They reduce the operational costs involved in manually tracking and (perhaps) duplicating data using individual & disparate systems. In this article, let us have a look at the advantages and dis-advantages of implementing ERP (Enterprise Resource Management) Software Systems.
Advantages of ERP (Enterprise Resource Planning) System:
1. Complete visibility into all the important processes, across various departments of an organization (especially for senior management personnel).
2. Automatic and coherent workflow from one department/function to another, to ensure a smooth transition and quicker completion of processes. This also ensures that all the interdepartmental activities are properly tracked and none of them is ‘missed out’.
3. A unified and single reporting system to analyze the statistics/status etc. in real-time, across all functions/departments.
4. Since same (ERP) software is now used across all departments, individual departments having to buy and maintain their own software systems are no longer necessary.
5. Certain ERP vendors can extend their ERP systems to provide Business Intelligencefunctionalities, that can give overall insights on business processes and identify potential areas of problems/improvements.
6. Advanced e-commerce integration is possible with ERP systems – most of them can handle web-based order tracking/ processing.
7. There are various modules in an ERP system like Finance/Accounts, Human Resource Management, Manufacturing, Marketing/Sales, Supply Chain/Warehouse Management, CRM, Project Management, etc.
8. Since ERP is a modular software system, it's possible to implement either a few modules (or) many modules based on the requirements of an organization. If more modules implemented, the integration between various departments may be better.
9. Since a Database system is implemented in the backend to store all the information required by the ERP system, it enables centralized storage/backup of all enterprise data.
10. ERP systems are more secure as centralized security policies can be applied to them. All the transactions happening via the ERP systems can be tracked.
11. ERP systems provide better company-wide visibility and hence enables better/faster collaboration across all the departments.
12. It is possible to integrate other systems (like bar-code reader, for example) to the ERP system through an API (Application Programing Interface).
13. ERP systems make it easier for order tracking, inventory tracking, revenue tracking, sales forecasting and related activities.
14. ERP systems are especially helpful for managing globally dispersed enterprise companies, better.
Disadvantages of ERP (Enterprise Resource Planning) Systems:
1. The cost of ERP Software, planning, customization, configuration, testing, implementation, etc. is too high.
2. ERP deployments are highly time-consuming – projects may take 1-3 years (or more) to get completed and fully functional.
3. Too little customization may not integrate the ERP system with the business process & too much customization may slow down the project and make it difficult to upgrade.
4. The cost savings/payback may not be realized immediately after the ERP implementation & it is quite difficult to measure the same.
5. The participation of users is very important for successful implementation of ERP projects – hence, exhaustive user training and simple user interface might be critical. But ERP systems are generally difficult to learn (and use).
6. There may be additional indirect costs due to ERP implementation – like new IT infrastructure, upgrading the WAN links, etc.
7. Migration of existing data to the new ERP systems is difficult (or impossible) to achieve.  Integrating ERP systems with other stand alone software systems is equally difficult (if possible). These activities may consume a lot of time, money & resources, if attempted.
8. ERP implementations are difficult to achieve in decentralized organizations with disparate business processes and systems.
9. Once an ERP system is implemented it becomes a single vendor lock-in for further upgrades, customizations, etc. Companies are at the discretion of a single vendor and may not be able to negotiate effectively for their services.

10. Evaluation prior to implementation of ERP system is critical. If this step is not done properly and experienced technical/business resources are not available while evaluating, ERP implementations can (and have) become a failure.

Sunday, September 7, 2014

Bank Interest on Savings (Accumulated Savings Formula & Compound Interest Formula)



BANK OVER DRAFT INTEREST CALCULATION




How to Calculate Bank Over Draft Interest ?
A: Take Closing Day Bank Balance and calculate with Interest Rate  for Example as follows:-
FORMULA : CLOSING AMOUNT * RATE OF INTEREST / 365 DAYS
AJMAL STEEL TUBES & PIPES INDUSTRIES L.L.C.
Statement of O/D 172 Interest Calculation for May 2013
Sr.
Date
Closing
Amount
Rate of
Interest
Interest
Amount
1
01/05/2013
      (2,074,520.05)
10.59%
            (601.61)
2
02/05/2013
      (1,281,772.20)
10.59%
            (371.71)
3
03/05/2013
      (1,689,788.70)
10.59%
            (490.04)
4
04/05/2013
      (2,445,844.35)
10.59%
            (709.29)
5
05/05/2013
      (2,103,340.65)
10.59%
            (609.97)
6
06/05/2013
      (1,063,550.33)
10.59%
            (308.43)
7
07/05/2013
      (1,063,550.33)
10.59%
            (308.43)
8
08/05/2013
      (3,266,462.33)
10.59%
            (947.27)
9
09/05/2013
      (3,296,962.33)
10.59%
            (956.12)
10
10/05/2013
      (3,841,751.33)
10.59%
        (1,114.11)
11
11/05/2013
      (3,978,801.17)
10.59%
        (1,153.85)
12
12/05/2013
      (3,987,103.51)
10.59%
        (1,156.26)
13
13/05/2013
      (3,987,103.51)
10.59%
        (1,156.26)
14
14/05/2013
      (3,976,598.51)
10.59%
        (1,153.21)
15
15/05/2013
      (4,450,407.55)
10.59%
        (1,290.62)
16
16/05/2013
      (4,151,507.20)
10.59%
        (1,203.94)
17
17/05/2013
      (4,273,690.32)
10.59%
        (1,239.37)
18
18/05/2013
          (713,229.97)
10.59%
            (206.84)
19
19/05/2013
          (699,829.97)
10.59%
            (202.95)
20
20/05/2013
          (699,829.97)
10.59%
            (202.95)
21
21/05/2013
          (700,079.97)
10.59%
            (203.02)
22
22/05/2013
          (699,829.97)
10.59%
            (202.95)
23
23/05/2013
      (2,449,878.50)
10.59%
            (710.46)
24
24/05/2013
      (2,372,976.19)
10.59%
            (688.16)
25
25/05/2013
      (2,375,612.43)
10.59%
            (688.93)
26
26/05/2013
      (2,617,843.95)
10.59%
            (759.17)
27
27/05/2013
      (2,617,843.95)
10.59%
            (759.17)
28
28/05/2013
      (2,552,373.95)
10.59%
            (740.19)
29
29/05/2013
      (3,511,857.95)
10.59%
        (1,018.44)
30
30/05/2013
      (2,948,507.70)
10.59%
            (855.07)
31
31/05/2013
      (3,536,945.48)
10.59%
        (1,025.71)






Total Interest
   (2,562,238.53)

   (23,034.52)
As Per BOB
   (23,034.52)
Difference to be check with BOB
                   0.00