2 Using Excel Perform an Even Swap Analysis for the online commerce sites below Use the following criteria to make swaps 1) As we raise the defect percent by 1 , we reduce costs by $20 2) If we raise service from Med to Good, this will raise the delivery time by 2 days If we raise the service from Poor to Good, this will raise the delivery time by 5 days 3) If we raise the delivery time by 1 day, this will lower the cost by $7 50 Annual Cost Delivery Time Percent Defective Service Amazon 150 2 3 Good Walmart 70 5 5 Med Ebay 200 6 8 Poor Etsy 90 6 3 Good Letgo 60 7 5 Med Craigslist 75 4 4 Poor 2a If we first rank all objectives in ascending order, we see that is dominated by and 2b If we do an even swap on Annual Cost and Percent Defective and then an even swap on Service and Delivery Time, The only two companies that remain will be and 2c Now do an even swap on Delivery time and Annual Cost The best choice will be

The Answer is in the image, click to view ...

Question: 2. Using Excel. Perform an Even Swap Analysis for the online commerce sites below. Use the following criteria to make swaps 1) As we raise

2. Using Excel. Perform an Even Swap Analysis for the online commerce sites below. Use the following criteria to make swaps 1) As we raise the defect percent by 1%, we reduce costs by $20 2) If we raise service from Med to Good, this will raise the delivery time by 2 days. If we raise the service from Poor to Good, this will raise the delivery time by 5 days 3) If we raise the delivery time by 1 day, this will lower the cost by $7.50

	Annual Cost	Delivery Time	Percent Defective	Service
Amazon	150	2	3	Good
Walmart	70	5	5	Med
Ebay	200	6	8	Poor
Etsy	90	6	3	Good
Letgo	60	7	5	Med
Craigslist	75	4	4	Poor

2a. If we first rank all objectives in ascending order, we see that__________ is dominated by__________________ and ____________________

2b. If we do an even swap on Annual Cost and Percent Defective and then an even swap on Service and Delivery Time,

The only two companies that remain will be ________________ and ________________

2c. Now do an even swap on Delivery time and Annual Cost. The best choice will be________________________

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Perform an Even Swap Analysis for the online commerce sites below. Using the following criteria to make swaps 1) As we raise the defect percent by 1%, we reduce costs by $20 2) If we raise service...

Perform an Even Swap Analysis for the online commerce sites below. Use the following criteria to make swaps 1) As we raise the defect percent by 1%, we reduce costs by $20 2) If we raise service from...

Decision making and Analytics Class Perform an Even Swap Analysis for the online commerce sites below. Use the following criteria to make swaps 1) As we raise the defect percent by 1%, we reduce...

1a) If we first rank all objectives in ascending order, we see that ____ is dominated by ____ and ____. 1b) If we do an even swap on Annual Cost and Percent Defective and then an even swap on Service...

Perform an Even Swap Analysis for the online commerce sites below. Use the following criteria to make swaps As we raise the defect percent by 1 % , we reduce costs by $ 2 0 If we raise service from...

In January 2013, Iris Corporation purchased and placed into service a 1933 building that houses retail businesses. The cost was $300,000, of which $25,000 applied to the land. In modernizing the...

1. What is the ROE (%) for 2012? Note: Just enter the numbers making up the percentage (%) of your answer. e.g. 78 (not 78% or 77.5) 2. What is the EPS for 2012? Note: Just enter the numbers making...

Which of the following job titles is least likely to be involved in cybersecurity efforts? Select answer from the options below Financial statement auditor Treasury governance risk analyst IT audit...

At May 3 1 , 2 0 2 7 , the accounts of Sandhill Company show the following. Your answer is partially correct. Prepare an income statement for May 2 0 2 7 through gross profit. SANDHILL COMPANY (...

13-6 How will MIS help my career?

12-17 Identify and describe three factors that prevent managers from making good decisions.

13-4 What are alternative methods for building information systems?