Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Theory And Practice

Authors: Jerry R. Strawser, Robert H. Strawser, Roger H. Hermanson

9th Edition

0873939336, 9780873939331

More Books

Students also viewed these Accounting questions