Scenario and Summary
You are a business analyst working for a small business that is considering a project to implement a Customer Relationship Management (CRM) system for use by field sales personnel. The system will use the ACT! software application from Sage Software, Inc. Management has asked you to prepare a preliminary economic feasibility analysis for this proposed project.
The company has nine field sales representatives and one sales manager. The sales representatives and the manager already have desktop computers and Blackberry smartphones with cellular data plans, so these items do not have to be considered in your analysis.
STEP 1: Read and analyze the business case
Carefully read the Scenario/Summary given above and identify the benefits, one-time costs, and recurring costs associated with this proposed project. In your review, make notes on each of the following. These notes will not be turned in, but you will use them in completing the remaining steps in this lab.
a. What are the benefits that the company will obtain for each year that the system is in operation?
b. What are the one-time costs that the company must pay before putting the new system into operation?
c. What are the recurring costs that the company must pay each year that the system is in operation?
STEP 2: Research costs
Select a vendor for the application software needed for the project and determine the costs associated with purchasing this software.
a. Do research to identify vendors who supply this application software and their pricing. You may want to do research on the Internet (for example, on the website of the software publisher and other ecommerce sites that sell business software). You may also consider checking with local retailers who sell business software.
b. Select a specific vendor to use for a price quotation. You may select the vendor with the lowest price, or you may choose to select a higher-priced vendor if you decide that other factors (such as reliability or convenience) justify the higher cost.
c. In the One-Time Costs section of the Quotes worksheet, record the name of the software application under Product or Service. Record a description of the application (including the specific version) under Description. Record the vendor that you selected under Vendor. Record the vendor's price per copy under Unit Cost. Record the number of copies needed for the project under Quantity.
d. Notice that a formula in the worksheet automatically calculates the Extended Cost.
STEP 3: Record additional cost and benefit line items
Record all other cost and benefit items associated with the project on the Quotes worksheet of the Excel workbook, as follows.
a. At the top of the worksheet, enter your name for Prepared By and the current date for Date.
b. In the Benefits section of the worksheet, for each expected benefit of the project, enter the Benefit Item, How Determined, and the Annual Value. If the annual value of a benefit item was given in the Scenario/Summary, enter Given in scenario in the How Determined column. If you need to perform any research or calculations to determine the Annual Value, use the How Determined column to briefly describe what you did.
c. In the One-Time Costs section of the worksheet, for each additional one-time cost item for the project, enter the Product or Service, Description, Vendor, Unit Cost, and Quantity (using the rows below the entry for application software that you made in Step 3). If a service is provided by a company employee rather than purchased from an outside vendor, enter In-house in the Vendor column.
d. In the Recurring Costs section of the worksheet, for each recurring cost associated with the project, enter the Cost Item, How Determined, and Annual Value. If the annual value of a cost item was given in the Scenario/Summary, enter Given in scenario in the How Determined column. If you needed to perform any research or calculations to determine the Annual Value, use the How Determined column to briefly describe what you did.
e. Notice that formulas in the worksheet automatically calculate the totals for each section.
STEP 4: Perform the Economic Feasibility Analysis
Enter values in the blue-shaded cells in the Analysis worksheet to calculate the Net Present Value (NPV), Return on Investment (ROI), and break-even point for the project, as follows.
a. Enter a descriptive name for the project in the cell marked [Enter Project Name Here].
b. Enter the discount rate for the project (the discount rate is given in the Scenario/Summary).
c. Take the Total Annual Value of Benefits from the Quotes worksheet and, on the Analysis worksheet, enter this value in the Net Economic Benefit row for each year that the project will be in operation (Year 1 through Year 5). Be sure to enter benefit values as positive numbers.
d. Take the Total of One-Time Costs from the Quotes worksheet and, on the Analysis worksheet, enter this value in the One-Time COSTS row under Year 0. Be sure to enter this cost value as a negative number.
e. Take the Total Annual Value of Recurring Costs from the Quotes worksheet and, on the Analysis worksheet, enter this value in the Recurring Costs row for each year that the project will be in operation (Year 1 through Year 5). Be sure to enter cost values as negative numbers.
f. Notice that formulas in the worksheet automatically calculate the Overall NPV, Overall ROI, and break-even point for the project.