Jay is currently using an old version of point-of-sale (POS) software and he wants you to create the spreadsheet shown in Fig. 11-15 to evaluate the alternatives for a new system. Jay has weighted the selection criteria according to his preferences. Create a formula to calculate the total weighted score for each software alternative. Be sure to include a formula to calculate the total weight of all factors and use absolute cell references where appropriate. Based on the initial evaluation shown below, the best option for Jay’s Bikes is SaaS for retail.
1. Which alternative scores highest if the “matches requirements” criterion is weighted at 50 percent and the “vendor architecture” is weighted at 0 percent?
2. Which alternative is best if the “matches requirements” criterion is weighted at 40 percent, “vendor architecture” is weighted at 0 percent, and “cost” is weighted at 30 percent?
3. Which alternative is best if the “matches requirements” criterion is weighted at 50 percent, “vendor architecture” is weighted at 0 percent, and “cost” is weighted at 20 percent?