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 analyst. 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 Woo, he explains that Pine Valley Furniture is currently involved with two important systems development projects, the Customer Tracking System and Web Store. The purpose of the Customer Tracking System is to enable the PVF marketing group to track customer purchase activity and sales trends better. The Web Store project will help move the company into the twenty-first century by facilitating online furniture purchases, with an initial focus on corporate furniture buying. During your meeting with Mr. Woo, 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 a spreadsheet product, you volunteer to make the modifications for him.

A. How were Pine Valley Furniture's projects initiated? What is the focus for each of the new system?
B. Modify the customer tracking system's economic feasibility analysis to reflect the modification mentioned in this problem. Use discount rate of 10 percent. After the changes are made, what are the new overall NPV, ROI and BEP?
C. Modify the workseet created in 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 yourfindings.

Transcribed Image Text:

Formulas: PV Future Cash Flow (1+ Discount Rate)AYear NPV Sum of PV's for all years ROI = N et returns/ Initial investment