1. Changing, Matches Requirement to 50%, and vendor architecture to 0%, we have;
Weight | 50% | 20% | 10% | 0% | 20% | |
Alternatives | Matches requirement | Vendor Experience | Vendor References | Vendor Architecture | Cost | Score |
POS Vendor #1 | 5 | 3 | 2 | 1 | 1 | 3.5 |
POS Vendor #2 | 4 | 2 | 3 | 1 | 2 | 3.1 |
Open Source POS | 2 | 1 | 4 | 2 | 4 | 2.4 |
SaaS for retail | 4 | 1 | 4 | 4 | 3 | 3.2 |
In this case, POS Vendor #1 is more suitable.
2. Changing, matches requirement to 40%, vendor architecture to 0% and cot to 30, we have;
Weight | 40% | 20% | 10% | 0% | 30% | |
Alternatives | Matches requirement | Vendor Experience | Vendor References | Vendor Architecture | Cost | Score |
POS Vendor #1 | 5 | 3 | 2 | 1 | 1 | 3.1 |
POS Vendor #2 | 4 | 2 | 3 | 1 | 2 | 2.9 |
Open Source POS | 2 | 1 | 4 | 2 | 4 | 2.6 |
SaaS for retail | 4 | 1 | 4 | 4 | 3 | 3.1 |
In this case POS Vendor #1 and SaaS for retail have same score.
3. This case is similar to case 1. Hence, please refer solution 1.
[Note: the formula for score column used is: =SUMPRODUCT(E7:I7,$E$5:$I$5) Where, E7:17 is the PoS Vendor #1 row and $E$5:$I$5 is weightage row.]
Excel Application: Jay's Bikes Heather and Jay Madera started Jay's Bikes in the family garage. Cycling...
Please show work, such as formulas within the excel spreadsheet . thanks Excel Application: Jay's Bikes Heather and Jay Madera started Jay's Bikes in the family garage. Cycling is their passion! They moved to their bicycle friendly community because of its three great bike trails that were built by the city to promote tourism and strengthen the downtown area. Jay's Bikes business is booming and now Heather and Jay are operating three retail stores with 18 full- time employees. The...