Jay and friends 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 they are operating three retail stores with 18 full-time employees. The stores stock a wide range of bikes and apparel for both casual and professional riders, and they have become gathering points for local bike enthusiasts and tourists alike.

Jay is currently using an old version of point-of-sale (POS) software and wants you to download and manipulate the spreadsheet Ch11Ex01, shown in Figure 11.16, to evaluate the alternatives for a new system. Jay has weighted the selection criteria. 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 here, 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?