Response to the following problem:
Pine valley furniture recently implemented a new internship program and has begun recruiting interns from nearby university campuses. As part of this program, interns have the opportunity to work alongside a systems analysis. This shadowing opportunity provides invaluable insights into the systems analysis and design process. recently you were selected for a six month internship at pine valley furniture, and Jim Woo has been assigned as your supervisor. At an initial meeting with Jim, he explains that pine valley furniture is currently involved with two important systems development projects, the customer tracking system and webstore. The purpose of the Customer tracking systems is to enable the PVF marketing group to track customer purchase activity and sales trends better. The webstore project will help move the company in to the twenty-first century by facilitating online furniture purchases, with an initial focus on corporate furniture buying. During your meeting with Jim, he reviews the documentation assembled for both systems, Mr. Woo hands you a copy of the Customer Tracking System's economic feasibility analysis. He mentions that he would like to modify the spreadsheet to reflect the information provided in the following table. Because you are familiar with spreadsheet products, you volunteer to make the modifications for him.
Net economic benefit $0 $50,000 $50,000 $50,000 $50,000 $50,000
One-time cost $47,500
Recurring Cost $0 $32,000 $32,000 $32,000 $32,000 $32,000
a- How were pine valley furniture's projects indicated? What is the focus for each of the new systems?
b-Modify the customer tracking systems economic feasibility analysis to reflect the modifications mentioned in this case problem. Use a discount rate of 10 percent. After the changes are made, what are the new overall NPV, ROI, and BEP?
c-Modify the worksheet created in part b using discount rates of 12 and 14 percent. What impact do these values have on the overall NPV, ROI, and BEP?
d-Jim Woo would like to investigate how other online stores are targeting the business furniture market, identify and evaluate two online stores that sell business furniture. Briefly summarize your findings.