Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Carter Electronics, a distributor of semiconductors and electrical components, is considering implementing an ERP system. This project will represent a huge investment for Carter and

Carter Electronics, a distributor of semiconductors and electrical components, is considering implementing an ERP system. This project will represent a huge investment for Carter and thus a business case must be developed in order to gain approval for the project. With the help of knowledgeable process owners, a group of individuals who will likely be on the project team, and IT staff, the managerial accountants put together the following total cost of ownership and benefits over a 5 year horizon (the time estimated that the system will be used until a major upgrade). Carters cost of capital is 6%.

1. Based on the information provided, calculate a NPV of this project using 6% cost of capital.

2. Calculate a Return on Investment (ROI).

3. Calculate the Payback Period for the ERP system

4. Is this a good investment based on above calculations?

image text in transcribed

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

ESTIMATED TCO Item One Time Recurring Comments Technology Hardware and infrastructure upgrades $450,000 Costs for serversetwork/wiring/redundancy ERP software contract value $2,000,000 Expected negotiated net price Recurring software maintenance -level 3 support $360,000 18% of software contract value (low end of maintenance) Database and Identity and Access Management Software $225,000 Estimated for MS SQL Server and any of the top 5 IAM systems, which are priced similarly People Internal Project Team $2,100,000 $180,000 Six full-time equivalent people; Center of Excellence - two full time people for 5 years Change Management (consultants) $500,000 $100,000 Includes costs for communication, education, training; ongoing 2 years Project management (consultants) $1,600,000 Integrated project plan, budget etc. Configuration/customization of ERP software (consultants) $1,700,000 Adapting the software to use in the company/filling gaps Contingency - 15% 15% 15% buffer on all one-time costs to avoid surprises. Data Inventory master data accuracy and BOM master data $350,000 This data is in 2 different systems currently. Deemed to have major data duplication issues. Need scrubbing and restructuring into new format. All other master data scrubbing $200,000 Scrubbing customer, vendor, employee Writing interface programs $275,000 Multiple legacy systems will remain (e.g., fixed assets) Recurring data maintenance $140,000 2 full time persons for master data maintenance (ongoing 5 years) Writing data conversion programs $285,000 Convert data to ERP format and migrate ESTIMATED BENEFITS Item Current Level % Improvement Annual Benefits Comments Sales $250,000,000 $3,750,000 Improvement in gross sales due to improved product availability and better service Direct Labor Productivity $15,000,000 10% $1,500,000 Reductions in idle time, overtime, and other HR- related issues related to inefficiency of workforce. 6 Fewer Employees Needed Average loaded $50,000 annual salary $300,000 Reductions in clerical/data entry support and warehouse staff Purchasing costs $1,000,000 20% $200,000 Better planning and information = reduced total purchase costs. Inventory Inventory Item Current Levels % Improvement Annual Benefits Raw Material and WIP $17,000,000 4% $680,000 Comments Annual saving from better forecasting and also implementation of vendor managed inventory Annual saving from better forecasting and also implementation of demand management module Finished Goods $9,000,000 17% $1,530,000 Premium freight $800,000 50% $400,000 Produce and ship on-time reduces shipment cost ESTIMATED TCO Item One Time Recurring Comments Technology Hardware and infrastructure upgrades $450,000 Costs for serversetwork/wiring/redundancy ERP software contract value $2,000,000 Expected negotiated net price Recurring software maintenance -level 3 support $360,000 18% of software contract value (low end of maintenance) Database and Identity and Access Management Software $225,000 Estimated for MS SQL Server and any of the top 5 IAM systems, which are priced similarly People Internal Project Team $2,100,000 $180,000 Six full-time equivalent people; Center of Excellence - two full time people for 5 years Change Management (consultants) $500,000 $100,000 Includes costs for communication, education, training; ongoing 2 years Project management (consultants) $1,600,000 Integrated project plan, budget etc. Configuration/customization of ERP software (consultants) $1,700,000 Adapting the software to use in the company/filling gaps Contingency - 15% 15% 15% buffer on all one-time costs to avoid surprises. Data Inventory master data accuracy and BOM master data $350,000 This data is in 2 different systems currently. Deemed to have major data duplication issues. Need scrubbing and restructuring into new format. All other master data scrubbing $200,000 Scrubbing customer, vendor, employee Writing interface programs $275,000 Multiple legacy systems will remain (e.g., fixed assets) Recurring data maintenance $140,000 2 full time persons for master data maintenance (ongoing 5 years) Writing data conversion programs $285,000 Convert data to ERP format and migrate ESTIMATED BENEFITS Item Current Level % Improvement Annual Benefits Comments Sales $250,000,000 $3,750,000 Improvement in gross sales due to improved product availability and better service Direct Labor Productivity $15,000,000 10% $1,500,000 Reductions in idle time, overtime, and other HR- related issues related to inefficiency of workforce. 6 Fewer Employees Needed Average loaded $50,000 annual salary $300,000 Reductions in clerical/data entry support and warehouse staff Purchasing costs $1,000,000 20% $200,000 Better planning and information = reduced total purchase costs. Inventory Inventory Item Current Levels % Improvement Annual Benefits Raw Material and WIP $17,000,000 4% $680,000 Comments Annual saving from better forecasting and also implementation of vendor managed inventory Annual saving from better forecasting and also implementation of demand management module Finished Goods $9,000,000 17% $1,530,000 Premium freight $800,000 50% $400,000 Produce and ship on-time reduces shipment cost

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Venture Capital And The Finance Of Innovation

Authors: Andrew Metrick

1st Edition

0470074280, 9780470074282

More Books

Students also viewed these Finance questions

Question

List and explain the criteria for vendor rating. AppendixLO1

Answered: 1 week ago

Question

=+ Describe the components. Which month was left out? Why?

Answered: 1 week ago