NOTE: Answer should be in MS Word not in excel

The Custom Bike Company has set up a weighted scoring matrix for evaluation of potential projects. Below are five projects under consideration. 1. Using the scoring matrix below, which project would you rate highest? Lowest? 2. If the weight for "Strong Sponsor" is changed from 2.0 to 5.0, will the project selection change? What are the three highest weighted project scores with this new weight? 3. Why is it important that the weights mirror critical strategic factors? 10% of Sale From Criteria Strong Support Business Strategy 15 Urgency New Products Support Weight 2 Project Fill Competition Market Weighted Weighted Total (a) Total (b) Gap 3 ? 4 3 ? 5 LA 2 2 0 N 5 17 2 0 2 Project 3 2 Project 3 Project 6 8 2 3 6 8 2 0 5 5 10 6 Project 3 3 10 10 1 8 0 4. Two new software projects are proposed to a young, start-up company. The Alpha project will cost $150,000 to develop and is expected to have annual net cash flow of $40,000. The Beta project will cost $200,000 to develop and is expected to have annual net cash flow of $50,000. The company is very concerned about their cash flow. Using the payback period, which project is better from a cash flow standpoint? Why