11-19. Excel Application: Jays Bikes

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 Jays Bikes is SaaS for retail.

Students should use the following formulas to complete the spreadsheet:

Weight of criterion 1 + weight of criterion 2 + weight of criterion 3 + weight of criterion 4 + weight of criterion 5 = Total weight of all factors

(Weight of criterion 1 * rating for criterion 1) + (weight of criterion 2 * rating for criterion 2) + (weight of criterion 3 * rating for criterion 3) + (weight of criterion 4 * rating for criterion 4) + (weight of criterion 5 * rating for criterion 5) = Total weighted score for each alternative

Questions

Which alternative scores highest if the matches requirements criterion is weighted at 50 percent and the vendor architecture is weighted at 0 percent?

If matches requirements is weighted at 50 percent and vendor architecture is weighted at 0 percent, POS Vendor #1 has the highest score.

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?

If matches requirements is weighted at 40 percent, vendor architecture is weighted at 0 percent, and cost is weighted at 30 percent, POS Vendor #1 and SaaS for retail have equal highest scores.

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?