Question

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 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 he wants you to create the spreadsheet shown in Figure 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 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% and the "vendor architecture" is weighted at 0%? 2. Which alternative is best if the "matches requirements" criterion is weighted at 40%, "vendor architecture" is weighted at 0%, and "cost" is weighted at 30%? 3. Which alternative is best if the "matches requirements" criterion is weighted at 50%. "vendor architecture" is weighted at 0%, and "cost" is weighted at 20%? FIGURE 11-15 Vendor evaluation for Jay's Bikes POS system. 20% 10% 20% vendor 1 Weight 20% POS Vendor#1 POS Vendor #2 Open Source POS 2.7 2.5 2.4 3.2 6 Saa5 for retal 8 Scale: 5 very good, 1 -very poor

Please show work, such as formulas within the excel spreadsheet . thanks

Answer 1