See the attachment.
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 a spreadsheet products, you volunteer to make the modifications for him.
Questions are in the spreadsheet: please show all work thank you.
The solution finds the net present value, return on investment and break even point.