A medical research firm is planning to relocate to one of four cities within the United States. Review the table below and develop a weighted project selection model with a minimum of 5 criteria (one criterion has been provided to get you started) to aid in the selection of the correct city. Assign fictional scores to each criterion for each of the 4 cities, provide a legend, and total the score. Make a recommendation based upon the score. Complete the assignment using Microsoft Excel.

Two new Internet site projects are proposed to a young start-up company. Project A will cost $100,000 to implement and is expected to have an annual net cash flow of $20,000. Project B will cost $400,000 to implement and should generate annual net cash flows of $40,000. The company is very concerned about their cash flow. Using the payback period, which project will return their money the soonest?

Transcribed Image Text:

City Cost to Operate Skilled Worker Availability I lih Low lTirn Low Toronto Medium Boston licghi Low Chicago ligh High