Handstar Inc.

Teaching Purpose: This case requires students to rank a number of candidate projects using both the NPV approach and the weighted scoring model approach. The case demonstrates how the NPV approach can be combined with the weighted scoring approach in evaluating projects.

1. Which projects would you recommend Handstar pursue based on the NPV approach?
The spreadsheet bellow summarizes the NPV calculations for the six projects assuming the development costs are incurred at the end of year zero and each product has a three-year life. Since the six projects require a total of 13,025 development hours and only 10,000 hours are available, one or more projects will need to be postponed or eliminated from further consideration. If we start with the project with the highest NPV, the Browser project would be selected first requiring 1,875 hours of development time. Next, the Trip Planner would be selected requiring an additional 6,250 hours of development time. The project with the next highest NPV is the Spreadsheet project. However, this project requires 2,500 hours and only 1,875 hours are available after selecting the Browser and Trip Planner projects. The project with the next highest NPV is the Calendar/Email project which requires 1,250 hours of development time leaving 625 hours available. Of the remaining projects, the Portfolio Tracker requires too many hours while the Expense Report project can be completed with the hours available. Thus, Browser, Trip Planner, Calendar/Email, and the Expense Report projects would be selected based on the NPV approach.

2. Assume the founders weigh a project’s NPV twice as much as both obtaining/retaining a leadership position and use of the Internet. Use the weighted factor scoring method to rank these projects. Which projects would you recommend Handstar pursue?

Data is available for the