Refer to the ERP Decision case. Design a spreadsheet that will assist the Board in evaluating the
Fantastic news! We've Found the answer you've been seeking!
Question:
Refer to the ERP Decision case. Design a spreadsheet that will assist the Board in evaluating the net benefits of implementing the ERP system.
Transcribed Image Text:
THE ERP DECISION" During the 1990s, many large companies began to realize that lack of integration among their information systems was leading to serious operational inefficiencies. Further- more, these inefficiencies were beginning to cause many companies to lose ground to other, better-organized firms. At the same time, enterprise resource planning (ERP) software, especially SAP R/3 (http://www.sap.com/), was reaching a high state of maturity as its penetration rate among the Fortune 1000 rose. The decision whether to convert to SAP (or a competing product) was a strategic one for many companies at this time, both because of the common software design, and it shares information as needed with the central database. While converting old systems to ERP is a massive undertaking, once it is accom- plished the firm has one common database, one common definition of business concepts, one central warehouse in which all information resides, and individual modules for each functional area that are compatible but can be upgraded independently. The Situation at Mega Corporation Mega Corporation has for many years been a dominant manufacturer in its industry. As a worldwide firm, it has four main manufacturing sites and sales offices spread across the world. Since most of the growth in the firm occurred in the 1970s and 1980s, before integrated firm- wide software was available, few of the company's infor- mation systems can communicate with each other. This lack of information integration is becoming an increasing burden on the firm. Each of the manufacturing sites has its own hardware and software, and none are linked electro- nically. As a consequence, much of the sharing of infor- mation that goes on among the manufacturing sites is done by telephone, fax, or memo. Each of the main sales offices has purchased and developed its own information systems, and these do not communicate with each other or with manufacturing. Again, this forces the sales offices to use telephone and faxes to share data. The accounting department is centralized at headquarters, but its software system does not interface with the others. Much of their time is spent manually transferring accounting data from the field into their central system. Purchasing is done by each of the manufacturing sites independently, and since their systems do not communicate, the firm cannot keep track of its purchases from single vendors and thus misses out on many discounts. This is just a sample of the problems that Mega suffers due to a lack of information integration. As these problems deepened, and the need for some centralized solution became more and more apparent, a conflict arose between the chief information officer (CIO) and the chief financial officer (CFO). The CIO wanted to install an integrated system immediately despite the costs and risks; the CFO wanted to kill any attempt to install this software. Here is a summary of the pros and cons of this decision, as expressed by the two executives. The Case for ERP The CIO argued that partial fixes to the company's current information systems were becoming more expensive and less effective every year. The conversion to ERP was inevi- table, so why not do it now? Once the system was up and running, the firm could expect to see lower inventories both of finished goods and raw materials. Finished goods inven- tories would be lower because Marketing and Manufactur- ing would be able to share common forecasts; raw materials inventories would be lower because Manufacturing would communicate its needs better to Purchasing, which would not have to maintain large stocks of raw materials to cover unexpected orders. In addition, Purchasing would be able to obtain quantity discounts from more vendors by pooling its orders from the various manufacturing sites. Sales would increase because, with better communication between high costs and risks of cost overruns (many SAP imple- mentations had failed or been far more costly than expected) and because of the high risks of not implement- ing integrated software. This case will allow you to explore the analysis done by one typical company for this decision. What is ERP software? An ERP system is companywide software that links all operations to a central database. ERP software is organized by module, one for each functional area such as Finance, Accounting, Manufacturing, Payroll, Human Resources, and so on. Each of these modules has a Marketing and Manufacturing, there would be fewer canceled orders, fewer late shipments, and more satisfied customers. Software maintenance costs would go down because the company would not have to maintain the old, nonintegrated software, much of which existed simply to allow one system to communicate with another. Decision making would also improve with the ERP system, because such basic information as current production costs at the product level would be available for the first time. Finally, once the basic ERP system was in place it would become possible to install more sophisticated software such as a customer-relationship management or CRM system. A CRM system sits on top of the ERP system, using its database to help answer questions such as "Are we making money selling products to our customers in the Northeast?" and "Is our sales force in East Asia fully productive?" The Case against ERP The case against ERP was made forcefully by the CFO. ERP hardware and software costs are high and must be paid in full before any benefits come in. ERP systems. change almost everyone's job, so the retraining costs are enormous. Some people will even leave the company rather than retrain on the new systems. No one within the company has any experience with ERP, so an expensive group of consultants must be hired over many years. Even after the consultants are gone, the company will have to hire a substantial number of highly trained and highly paid. systems people to maintain the ERP system. Improved decision making sounds valuable, but it is hard to quantify, and besides, if the company has as much difficulty as some firms have had implementing ERP, the "benefits" may well be negative! The only rational way to develop an understanding of the likely costs and benefits of implementing ERP, and perhaps to settle this argument, is to develop a model. You have been asked by the Board to do just that. Your model should be complete in that it accounts for all the possible costs and benefits from both an ERP system and from installing a CRM system on top of the ERP system. The model should be flexible, so that alternative assumptions can easily be tested. It should be robust, in that nonsensical inputs should be rejected. It should also provide insights, so that the Board can use it effectively to decide under what circumstances the ERP/CRM project would make sense. Some of the initial assumptions on which the Board would like the model to be built are described next. Assumptions First, the model should cover 20 years, from 2005-2024. Second, it should account for changes in sales (and reven- ues) from the ERP and CRM systems, as well as changes in inventories. Finally, it should include the costs of hardware, software, consultants, permanent employees, training of nonprogramming staff, and maintenance of old systems. Specific numerical assumptions follow: . Without ERP, sales are expected to hold steady at about $100 million per year over the next 20 years. Sales can be expected to grow about 1 percent/ye an ERP system is fully operational, which will years. 490 THE ERP DECISION" During the 1990s, many large companies began to realize that lack of integration among their information systems was leading to serious operational inefficiencies. Further- more, these inefficiencies were beginning to cause many companies to lose ground to other, better-organized firms. At the same time, enterprise resource planning (ERP) software, especially SAP R/3 (http://www.sap.com/), was reaching a high state of maturity as its penetration rate among the Fortune 1000 rose. The decision whether to convert to SAP (or a competing product) was a strategic one for many companies at this time, both because of the common software design, and it shares information as needed with the central database. While converting old systems to ERP is a massive undertaking, once it is accom- plished the firm has one common database, one common definition of business concepts, one central warehouse in which all information resides, and individual modules for each functional area that are compatible but can be upgraded independently. The Situation at Mega Corporation Mega Corporation has for many years been a dominant manufacturer in its industry. As a worldwide firm, it has four main manufacturing sites and sales offices spread across the world. Since most of the growth in the firm occurred in the 1970s and 1980s, before integrated firm- wide software was available, few of the company's infor- mation systems can communicate with each other. This lack of information integration is becoming an increasing burden on the firm. Each of the manufacturing sites has its own hardware and software, and none are linked electro- nically. As a consequence, much of the sharing of infor- mation that goes on among the manufacturing sites is done by telephone, fax, or memo. Each of the main sales offices has purchased and developed its own information systems, and these do not communicate with each other or with manufacturing. Again, this forces the sales offices to use telephone and faxes to share data. The accounting department is centralized at headquarters, but its software system does not interface with the others. Much of their time is spent manually transferring accounting data from the field into their central system. Purchasing is done by each of the manufacturing sites independently, and since their systems do not communicate, the firm cannot keep track of its purchases from single vendors and thus misses out on many discounts. This is just a sample of the problems that Mega suffers due to a lack of information integration. As these problems deepened, and the need for some centralized solution became more and more apparent, a conflict arose between the chief information officer (CIO) and the chief financial officer (CFO). The CIO wanted to install an integrated system immediately despite the costs and risks; the CFO wanted to kill any attempt to install this software. Here is a summary of the pros and cons of this decision, as expressed by the two executives. The Case for ERP The CIO argued that partial fixes to the company's current information systems were becoming more expensive and less effective every year. The conversion to ERP was inevi- table, so why not do it now? Once the system was up and running, the firm could expect to see lower inventories both of finished goods and raw materials. Finished goods inven- tories would be lower because Marketing and Manufactur- ing would be able to share common forecasts; raw materials inventories would be lower because Manufacturing would communicate its needs better to Purchasing, which would not have to maintain large stocks of raw materials to cover unexpected orders. In addition, Purchasing would be able to obtain quantity discounts from more vendors by pooling its orders from the various manufacturing sites. Sales would increase because, with better communication between high costs and risks of cost overruns (many SAP imple- mentations had failed or been far more costly than expected) and because of the high risks of not implement- ing integrated software. This case will allow you to explore the analysis done by one typical company for this decision. What is ERP software? An ERP system is companywide software that links all operations to a central database. ERP software is organized by module, one for each functional area such as Finance, Accounting, Manufacturing, Payroll, Human Resources, and so on. Each of these modules has a Marketing and Manufacturing, there would be fewer canceled orders, fewer late shipments, and more satisfied customers. Software maintenance costs would go down because the company would not have to maintain the old, nonintegrated software, much of which existed simply to allow one system to communicate with another. Decision making would also improve with the ERP system, because such basic information as current production costs at the product level would be available for the first time. Finally, once the basic ERP system was in place it would become possible to install more sophisticated software such as a customer-relationship management or CRM system. A CRM system sits on top of the ERP system, using its database to help answer questions such as "Are we making money selling products to our customers in the Northeast?" and "Is our sales force in East Asia fully productive?" The Case against ERP The case against ERP was made forcefully by the CFO. ERP hardware and software costs are high and must be paid in full before any benefits come in. ERP systems. change almost everyone's job, so the retraining costs are enormous. Some people will even leave the company rather than retrain on the new systems. No one within the company has any experience with ERP, so an expensive group of consultants must be hired over many years. Even after the consultants are gone, the company will have to hire a substantial number of highly trained and highly paid. systems people to maintain the ERP system. Improved decision making sounds valuable, but it is hard to quantify, and besides, if the company has as much difficulty as some firms have had implementing ERP, the "benefits" may well be negative! The only rational way to develop an understanding of the likely costs and benefits of implementing ERP, and perhaps to settle this argument, is to develop a model. You have been asked by the Board to do just that. Your model should be complete in that it accounts for all the possible costs and benefits from both an ERP system and from installing a CRM system on top of the ERP system. The model should be flexible, so that alternative assumptions can easily be tested. It should be robust, in that nonsensical inputs should be rejected. It should also provide insights, so that the Board can use it effectively to decide under what circumstances the ERP/CRM project would make sense. Some of the initial assumptions on which the Board would like the model to be built are described next. Assumptions First, the model should cover 20 years, from 2005-2024. Second, it should account for changes in sales (and reven- ues) from the ERP and CRM systems, as well as changes in inventories. Finally, it should include the costs of hardware, software, consultants, permanent employees, training of nonprogramming staff, and maintenance of old systems. Specific numerical assumptions follow: . Without ERP, sales are expected to hold steady at about $100 million per year over the next 20 years. Sales can be expected to grow about 1 percent/ye an ERP system is fully operational, which will years. 490
Expert Answer:
Answer rating: 100% (QA)
An ERP system can also provide a standardized HR platform for time reporting expense trackingtrainsk... View the full answer
Related Book For
Business Analytics The Art of Modeling with Spreadsheets
ISBN: 9781119386490
5th edition
Authors: Stephen G. Powell , Kenneth R. Baker.
Posted Date:
Students also viewed these computer network questions
-
Refer to the ERP Decision case. Design a spreadsheet that will assist the Board in evaluating the net benefits of implementing the ERP system. The above exercises refer to the cases in the back of...
-
Refer to the XYZ Company case. Design a spreadsheet that will allow an analyst to predict the month in which the cash balance falls below zero, signaling a need to borrow money. The following...
-
Refer to the Reid's Raisins case. Design a spreadsheet that will allow the firm to project profit for base-case conditions; the open market grape price is $0.30. The following exercises refer to the...
-
Graph the sets of points whose polar coordinates satisfy the equations and inequalitie. 0 /6, r 0
-
a. According to Figure 32.10, about how long does it take for an oil price shock to have its biggest impact on the economy? How long does it take before the oil shocks effects completely go away? b....
-
Evaluate how well Medtronic's performance acceleration system, as it is described here, meets the standards for validity and reliability.
-
A circular loop rotates at constant speed about an axle through the center of the loop. Figure Q25.6 shows an edge view and defines the angle \(\phi\), which increases from \(0^{\circ}\) to...
-
Current assets for two different companies at calendar year- end 2013 are listed here. One is a manufacturer, Salomon Skis Mfg., and the other, Sun Fresh Foods, is a grocery distribution company. (1)...
-
explain accountability, accounting, and the accountability model briefly explain organisational boundaries in the context of accountability and accounting; explain and apply the four parts of the...
-
Fajar has six different meals from a meal delivery service. Three meals include chicken, two meals include beef, and one meal is vegetarian. Fajar will eat one of these meals per day for the next six...
-
Design Patterns Usage: Context The Facade Pattern is used to provide a unified interface to a set of interfaces in a subsystem. The IO component depicted below provides four individual interfaces...
-
Why is it important not to focus only on the family factor (e.g. income, socio-economic status) in determining the reason behind why a child cannot participate/accomplish performance tasks?
-
How is your identity connected to characteristics of global citizenship by discussing a social issue that personally concerns you?
-
1. There was a payroll of $68,100 paid on 3 January; this covered the period of 30 December to 3 January. Write the adjusting entry for this. I know that the debit is to wages expense and the credit...
-
How did the neoclassical movement of the 18th and 19th centuries reinterpret classical motifs and themes in response to the socio-political upheavals of the Enlightenment and the French Revolution,...
-
Is this statement true? Justify. Tautology is a mistake committed by a researcher who has empirical evidence about an association between two or more variables at the level of individual behaviour...
-
Explain What is the current state of CRM? 1. Provide an overview of the client's current CRM strategy (remember Strategic CRM from the beginning of the semester?) and craft the client's value...
-
Draw the appropriate control flow graph of the given pseudocode.Make sure to only use one number for blocks of code which are all sequential and when the first line is executed, all of those lines...
-
Formulate one or more problem statements. The four short cases we have analyzed in this chapter (Retirement Planning, Draft TV Commercials, Icebergs for Kuwait, and Racquetball Racket) are reproduced...
-
Refer to the Retirement Planning case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet for this problem. a. Develop a base case. You may create any data you need for...
-
Draw an influence chart for the problem. The four short cases we have analyzed in this chapter (Retirement Planning, Draft TV Commercials, Icebergs for Kuwait, and Racquetball Racket) are reproduced...
-
Based on the photographs in Figure 26.13, in which segment(s) is the Antp gene normally expressed? Figure 26.13: (a) Normal fly (b) Antennapedia mutant
-
The bush baby, a small African mammal, is a remarkable jumper. Although only about 8 inches long, it can jump, from a standing start, straight up to a height of over 7 feet! Use the particle model to...
-
Your friend Travis claims to have set the new world speed record for riding a unicycle. His top speed, he says, was 55 m/s. Do you believe him? Explain.
Study smarter with the SolutionInn App