Accounting Erp Enterprise Resource Planning (ERP)- These systems break from the Assets=L+E scheme. ERP systems do not have the preparation of financial statements as their primary goal. Many ERP vendors stress an objective of inputting data only once and using it to generate various views. ERP vendors stress the process focus of their products. The software can span across functional borders, enabling integration of data and information flows. ERP systems can also support a variety of tasks including supply chain management, inventory management, logistics, human resource manganement, finance, accounting, manufacturing planning, sales, and distribution. However, these systems are often inflexible and impose certain rules and processes on the organization. Successfully implementing these systems is often difficult and costly.
Many approaches have been advanced to solve business problems with only limited success. ERP provides some benefit, but has only provided marginal success. As a result, many people are less eager to try something new. They seem convinced that nothing can fix their problems and they resist future changes to protect themselves from further frustration and exhaustion. The basic question in designing ERP is should the organization change the software or the process to match the software? ERP advantages- one vendor solution, viability, broader offering.
Disadvantages- time and diversity. One-vendor solution- this is viewed as a one stop shop approach. It typically allows the user to contact and communicate with just one source. Viability- the traditional ERP firms are more established and score higher on the viability scales. When an anticipated market consoldation occurs, these companies are more likely to bode well through this consolidation.
Broader offering- Many organizations that are buying Ginancials solutions today may have the need for additional products (HR, Procurement, Order Entry, Manufacturing) down the line. Because mergers and acquisitions continue to occur throughout all industries, these companies may not be able to identify all their needs right now. Disadvantages..Time- An integrated ERP approach has traditionally taken longer and creates many “Catch 22” situations. THere are integral decisions in implementing any component of an ERP system that impact other parts of that same system. Diversity- As ERP vendors are broadening their offerings to reflect the needs of the marketplace, they are involved in many strategic directions that are playing out in parallel. Vendors need to determine where future R&D investments will be applied. The concern is that some of these vendors are trying to be “everything” to “everybody.” At some point, there will be a threshold that will cause a breakpoint. A more significant benefit for most companies is the improved use of their information technology. ERP systems present better information in a more timely manner to the people who need it.
Sales reps can check inventory levels and prices before committing to deadlines; managers can check margins before offering special deals. ERP systems can also make employees, whether in customer service or production, more productive. ERP systems can reduce turnaround or order fulfillment time and increase accuracy in fulfilling customer orders. For cash savings, ERP systems can help reduce inventory costs through improved stock tracking. Last year, Walbar, a manufacturer of turbine blades and other parts for airplane engines, replaced its business application system with an ERP system from JD Edwards.
The total cost for the implementation at the Mississauga plant, including the IBM AS/400 computer, servers, new IBM workstations, software, installation and training was about US $1 million. Mammone sees real improvements in improved customer service; quicker and more accurate delivery of customer orders through better materials planning and order tracking. In Mammone’s industry, mistakes are very costly, as there are only about a dozen manufacturers of airplane engines in the world. He says you can’t afford to annoy any of them. One key benefit of ERP systems is the way it integrates a company’s flow of information.
Using an ERP system, the sales, purchasing, production, inventory control and accounting departments all use the same information. One set of data is used throughout the company to make sure customers get what they want when they want it, and that the whole thing is profitable for the company. ERP systems do just what you’d expect a business application to do: record customer orders and purchase orders, keep track of inventory, create invoices, handle all the accounting including sales, accounts payable and receivable, and budgeting. Another important advantage of ERP is that it provides information to support the information manager’s need to manage: things such as performance indicators, and alerts to situations such as shortages or shortfalls from quotas, and bottlenecks. An ERP system is not something that you can pull out of a box or install from a CD-ROM; every implementation is customized to fit the needs of the enterprise.
Any company installing a new ERP system can pick and choose modules, or can phase in the implementation over months or years. For instance, you might want to start with only the core ERP back office functions such as accounting, payments, inventory and sales. Then add human resources planning, strategic procurement or e-commerce as you become used to the new system. You could phase in your ERP solution as your older systems become obsolete, one at a time. Naturally, this approach requires a lot of programming to integrate the new system into the old one.
THE PAYOFFS OF EPR Manufacturers with fully functional ERP systems report the following benefits: Reduced inventories 50% Reduced order-cycle times 43% Increased production capacity 36% Lower total logistics costs 32% Decreased procurement costs 29% Reduced manufacturing waste 29% Lower distribution costs 14% REASONS FOR IMPLEMENTING ERP Manufacturers implement ERP systems primarily to: Get a competitive advantage 71% Help service major customers 71% Replace an older system or eliminate the Y2K problem 57% The system should be complete enough to support both Discrete as well as Process manufacturing scenario’s. The efficiency of an enterprise depends on the quick flow of information across the complete supply chain i.e. from the customer to manufacturers to supplier. This places demands on the ERP system to have rich functionality across all areas like sales, accounts receivable, engineering, planning, Inventory Management, Production, Purchase, accounts payable, quality management, production, distribution planning and external transportation. EDI (Electronic Data Interchange) is an important tool in speeding up communications with trading partners. The amount of inventory required to run a business effectively is always a concern. If you have too much cash flow problems can result, too little and you run the risk of poor customer service. How can you run your business effectively and still maintain a reasonable amount of inventory? The cost of carrying inventory can run 30% or more of the value of the inventory per year.
$10,000,000 of inventory can cost you $3,000,000 per year for the privilege of carrying it. 7 ways to reduce inventory 1. Improve your data accuracy – If you don’t know how much you have or where it is, it’s as if it doesn’t exist. The question What is your inventory accuracy? often gets the answer, I don’t know, Lousy or some low percentage. Its difficult to maintain inventory accuracy without a well designed cycle counting system. Our experience has been that a well designed and implemented cycle counting system pays for itself in a very short time.
This is not merely counting things from time to time. It is a system designed to identify and solve inventory system problems. 2. Reduce your lead time – The longer your lead time, the more inventory you have in your system. A client with a 22 week customer lead time could produce a rush order in one week. The manufacturing process was the same.
The difference was that the rush order didn’t sit on the shop floor in long lines of WIP inventory waiting for something to happen. Don’t put it on the floor unless you intend to do something with it. 3. Increase the velocity of your operation – The amount of inventory you have has little to do with your level of customer service. It has more to do with how fast you can replace it.
If it takes six weeks to replace an item, you must reorder with at least six weeks (plus safety stock and Just in Case inventory) supply or you risk a stock out. If you can replace the same item in one day, a two day supply will give you more than enough to fill any order and a stock out is only for one day, not until the next batch is produced. 4. Eliminate misalignment from your process – Many companies buy raw material in thousands, produce product in hundreds and sell in units. These misalignments create large quantities of inventory that run the risk of slow movement, obsolescence and damage, not to mention tying up valuable cash.
Most companies justify this behavior based on economies of scale. Careful analysis shows that this should be called false economy of scale. Buy just what you need, produce at the rate of customer consumption. Refine your material acquisition process and change your manufacturing process to produce in smaller batches. Just in Time techniques are targeted at eliminating misalignment.
5. Clean your attic – Many companies want to be all things to all people. I’ve had clients tell me, If we don’t carry that item (typically ordered once a year if that often), our customer won’t buy from us. My response is Where else would they go to buy it, no one else carries it! I’ve also heard, Someone will buy it some day, We spent too much money on it to throw it away, and, the best one of all We’ve written it off, so it doesn’t cost us anything. Turn all those mistakes into whatever cash you can. Liquidate, donate, have a sale.
Set an inventory turns target and increase an item’s turns by increasing its velocity or get rid of it. If your customers leave you because you don’t carry some obsolete inventory item, you’ve got bigger problems than this paper can address. 6. Eliminate variation – Erratic vendors, yield problems on the shop floor and other quality problems cause unneeded inventory to pile up because the response is order early, order more than we need, start more than the forecast and increase safety stocks throughout the system. If a product has an 80% yield and you need 100 units, on average you need to start 125 units to average 100 units completed. The trouble is you will only get 100 units 50% of the time! So one quickly learns to start 140, 150 or more to insure a yield of 100 every time! Sometimes this results in 120 units completed and the extras go into inventory, not to mention the extra raw material and capacity required. 7.
Replenish based on market demand – Forecasts are great and necessary but they are no more than educated guesses. And the farther out into the future the forecast the higher the probability that the guess will be very wrong. To use market demand to replenish finished goods keeps the inventory level aligned with what customers are actually buying. Of course you will have to do all of the above six things well to do this effectively, but it’s possible. So there it is.
In these days of ERP systems, information technology and other high tech systems, it almost seems too simple. I can assure you that these things are easier to talk about than to execute, but the payoff is worth it. Part B of question 2.) What Is a Data Warehouse? A data warehouse is a decision support database that is maintained separately from an organization’s operational databases and it usually resides on a dedicated server. This database is designed based on what kind of information a company is seeking (e.g., sales marketing, healthcare membership and providers, etc.) and it adopts a STAR (or SNOWFLAKE) schema design for maximum efficiency in performance. Extracting appropriate data from exi …