Question: ONLY ANSWER USING EXCEL. HAND DRAWN ANSWERS WILL BE VOTED DOWN!!!! ONLY USE EXCEL!!! ONLY ANSWER USING EXCEL. HAND DRAWN ANSWERS WILL BE VOTED DOWN!!!!

ONLY ANSWER USING EXCEL. HAND DRAWN ANSWERS WILL BE VOTED DOWN!!!! ONLY USE EXCEL!!!

Question 2: Bike Purchasing a mountain bike Three criteria: price, gear action, weight/durability Three types of bikes: A,B,C Developed pairwise comparison matrices 1,11,111 Ranked the decision criteria based on the pairwise comparison Select the best bike using AHP A B Il-Gear Action B 1 1/3 3 1 7 4 1/7 1/4 1 III-Weight/Durability Bike A B A 1 3 1 B 1/3 1 1/2 2 1 l-Price Criteria Price Gear Weight A B Bike . 6 Price 1 1 3 5 3 B 2 Gear 1/3 1 2 1/3 1/6 1 N Weight 1/5 1/2

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 Accounting Questions!

Show work in excel and by hand. 2. Healthy Choice (35 Points) A school dietitian wants to determine the best blend of meats to use in an order of 500 pounds of ground meat for hamburgers to be used...

Use Excel Goal Seek to answer the following questions and submit your PDF printout / screenshot . Note that this time you only need to submit the numerical answers screenshot ( not the formulas ) ....

I need help in this question. Please do this in excel and show the formulas to how to enter the answers in the box as shows in the picture because i have to put formula in the box to calculate the...

Consider the question: A recent study found that the age of cars on road in 2013 is normally distributed with an average age of 8.3 years and a standard deviation of 2.4 years. Find the percent of...

Tucson Machinery, Inc, manufactures numerically controlled machines, which sell for an average price of $0.5 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit...

WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT: 1) How many units should be produced next year? Record your answer, using excel formulas, here 2) What is the dollar amount...

solve accordingly using data given , i just need 4 answers and their excel formulas Enter Your Name Here BASE DATA: Foundation Data for Solving questions 1, 2 and 3: Budgeted Direct Materials Cost...

Master Budget Data: List Your Product Name Here Custom Exhaust ENTER YOUR INDIVIDUAL CASE NUMBER HERE 35,764 (THIS IS LOCATED IN YOUR GRADEBOOK) First Name Last Name Enter Your Name Here Garrett Rine...

please just provide the 4 answers that go in the blanks Enter Your Name Here BASE DATA: Foundation Data for Solving questions 1, 2 and 3: Budgeted Direct Materials Cost Per UNIT 15.00 10.00 Budgeted...

Please Answer in Excel Format with formulas! Mortgage and Refinance Excel Project Use Excel work sheet to build two Mortgage Amortization Tables. **In the excel sheet, update your data and answers in...

Least Squares in Another Dimension A chemist wishes to estimate the yield Y in a certain process that depends on the temperature T and the pressure P. A linear model for the process is assumed: Y = a...

Create a frequency table for classes of MPG, including frequency and relative frequency for the cars in the sample. Calculate the mean Days in Inventory for the cars in the sample. Also, do the...

Suppose G : K { 0 , 1 } n satisfies msb ( G ( k ) ) = 1 for 1 / 4 of keys in K where msb ( x ) denotes the most significant bit of a string x . Define statistical test A ( x ) as: if [ msb ( x ) = 1...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

6. Are my sources reliable?

How do you feel about the fact that even unintentionally using someone elses words, ideas, or intellectual property is still plagiarism? Does it seem unfair that you might suffer severe consequences...

5. Are my sources compelling?