MSFS 670 Capital Budgeting Analysis (2015)

MSFS 670 Capital Budgeting Analysis

Vendor 1: Suite Solution - System would be Owned by Ramsey

ERP Cost Components

Software $250,000 initial investment includes inventory and demand planning, 100 licenses

Software Maintenance (including updates) $62,500 annual recurring 25% of software purchase price, begins in year 2

Hardware $100,000 initial investment 2 servers and communications infrastructure

Consulting and Training $160,000 initial investment full implementation and training

Implementation Team $75,000 recurring - see note Beginning year 0 through year 5

Vendor 2: NetSuite - System would be Hosted in Cloud by NetSuite

Mid Market Wholesale/distribution version - Hosted Suite $1,599 monthly recurring includes inventory and demand planning

100 Users @ $99 per user per month $9,900 monthly recurring 100 licenses, plus admin bases

Gold level maintenance $3,162 monthly recurring 27.5% of monthly billing

Consulting and Training $140,000 initial investment full implementation and training

Implementation Team $75,000 recurring - see note Drops to $45k in year 1-5

The benefits of the ERP project begin when the system is put into operation. After the initial investment, the following benefits are expected annually over a 5 year period: reduced inventory costs of $215,000, and reduced administrative costs of $105,000. Software and hardware are depreciated straight line over 3 and 5 years, respectively, with no salvage values. Recurring expenses include the software maintenance and implementation team costs, the latter of which reduce to $45,000 annually after year 0 and reflect ongoing team oversight of the ERP. The company's cost of capital is 10%. The company's required rate of return is 12%. The tax rate is 35%.

Note: Assume current capital and operating lease rules apply.

ASSIGNMENT:

You are working on the cost justification:

a. Perform a capital budgeting analysis using 3 methods of measuring return on the project. One method must employ net present value analysis. The other two methods should include methods that consider the time value of money. Upon completing the analysis, your report should include a short explanation of each analysis, comments as to whether the methods support each other, a description of some of the intangibles benefits, not captured in the calculations, and your conclusion regarding the capital budgeting decision for each vendor.