Question

The question that I need help solving is the Totals. The formula uses =SumProduct, but I have not been able to figure out the exact formula. The other posts are not making sense, and I am confused. If someone could explain with different examples, say… from the work I have already done, that would be excellent!! A B C D E F G Weight* Alternatives POS Vendor #1 POS Vendor #2 Open Source POS Saas for retail 30% 20% 10% 20% 20% Matches Requirements Vendor Experience Vendor References Vendor Architecture Cost 5 3 2 1 1 4 2 3 1 2 2 1 4 2 4 4 1 4 4 3 100% Total 2.7 2.5 2.4 3.2 Scale: 5 = very good, 1 very poor Weight Alternatives POS Vendor #1 POS Vendor #2 Open Source POS Saas for retail 50% 20% 10% 0% 20% Matches Requirements Vendor Experience Vendor References Vendor Architecture Cost 5 3 2 1 1 4 2 3 1 2 2 1 4 2 4 4 1 4 4 3 100% Total 3.5 3.1 2.4 3.2 POS #1 is more Suitable Weight* Alternatives POS Vendor #1 POS Vendor #2 Open Source POS Saas for retail 40% 20% 10% 0% 30% Matches Requirements Vendor Experience Vendor References Vendor Architecture Cost 5 3 2 1 1 4 2 3 1 2 2 1 4 2 4 4 1 4 4 3 100% Total 3.1 2.9 2.6 3.1 POS #1 and SaaS have the same score

          The question that I need help solving is the Totals. The formula uses =SumProduct, but I have not been able to figure out the exact formula. The other posts are not making sense, and I am confused. If someone could explain with different examples, say… from the work I have already done, that would be excellent!!

A
B
C
D
E
F
G
Weight* Alternatives POS Vendor #1 POS Vendor #2 Open Source POS Saas for retail
30%
20%
10%
20%
20% Matches Requirements Vendor Experience Vendor References Vendor Architecture Cost 5 3 2 1 1 4 2 3 1 2 2 1 4 2 4 4 1 4 4 3
100% Total 2.7 2.5 2.4 3.2
*Scale: 5 = very good, 1 very poor
Weight* Alternatives POS Vendor #1 POS Vendor #2 Open Source POS Saas for retail
50%
20%
10%
0%
20% Matches Requirements Vendor Experience Vendor References Vendor Architecture Cost 5 3 2 1 1 4 2 3 1 2 2 1 4 2 4 4 1 4 4 3
100% Total 3.5 3.1 2.4 3.2
POS #1 is more Suitable
Weight* Alternatives POS Vendor #1 POS Vendor #2 Open Source POS Saas for retail
40%
20%
10%
0%
30% Matches Requirements Vendor Experience Vendor References Vendor Architecture Cost 5 3 2 1 1 4 2 3 1 2 2 1 4 2 4 4 1 4 4 3
100% Total 3.1 2.9 2.6 3.1
POS #1 and SaaS have the same score

Show more…

the question that i need help solving is the totals the formula uses sumproduct but i have not been able to figure out the exact formula the other posts are not making sense and i am confuse 90473

Added by Lisa J.

Horngren’s Cost Accounting

Srikant M. Datar, Madhav V. Rajan 16th Edition

Instant Answer

Solved by Expert Madhur L

08/14/2023

Step 1

In the given data, the weights for each category are as follows: - Matches Requirements: 30% - Vendor Experience: 20% - Vendor References: 10% - Vendor Architecture: 20% - Cost: 20% Show more…

Show all steps

lock

Thanks for your feedback!

The question that I need help solving is the Totals. The formula uses =SumProduct, but I have not been able to figure out the exact formula. The other posts are not making sense, and I am confused. If someone could explain with different examples, say… from the work I have already done, that would be excellent!! A B C D E F G Weight* Alternatives POS Vendor #1 POS Vendor #2 Open Source POS Saas for retail 30% 20% 10% 20% 20% Matches Requirements Vendor Experience Vendor References Vendor Architecture Cost 5 3 2 1 1 4 2 3 1 2 2 1 4 2 4 4 1 4 4 3 100% Total 2.7 2.5 2.4 3.2 *Scale: 5 = very good, 1 very poor Weight* Alternatives POS Vendor #1 POS Vendor #2 Open Source POS Saas for retail 50% 20% 10% 0% 20% Matches Requirements Vendor Experience Vendor References Vendor Architecture Cost 5 3 2 1 1 4 2 3 1 2 2 1 4 2 4 4 1 4 4 3 100% Total 3.5 3.1 2.4 3.2 POS #1 is more Suitable Weight* Alternatives POS Vendor #1 POS Vendor #2 Open Source POS Saas for retail 40% 20% 10% 0% 30% Matches Requirements Vendor Experience Vendor References Vendor Architecture Cost 5 3 2 1 1 4 2 3 1 2 2 1 4 2 4 4 1 4 4 3 100% Total 3.1 2.9 2.6 3.1 POS #1 and SaaS have the same score

Play audio

Feedback

Powered by NumerAI

Madhur L and 98 other subject Principles of Accounting educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Recommended Videos

Recommended Textbooks

Transcript

00:02 Hello students, as the first question is using the formula to calculate the amount that is the amount is equal to quantity into rate.

00:11 So, in cell 2, we enter the formula and then drag there it to down to fill the rest of the cells in cell e.

00:22 So, here we will refer the columns are columns as initially will refer our columns as sr number as a items as b items as b and quantity as the c and the rate as d as well as the amount as e and the grade as f and the grade as f.

01:01 So, using the product formula to calculate the amount, amount is equal to the quantity into rate.

01:14 So, for as the in an answer in the answer in the column e.

01:21 So, now, in cell 2, we enter the as the c2 into d2.

01:30 So, enter the formula and drag this and drag them to down to fill the rest of the cells in a column e.

01:37 So, now, the question 2, the second question is how many items in a list.

01:44 So, items in a list in a cell enter the formula to count as the number of items in the list as there is equal to count of a b2 is to b1 b11.

02:04 Now, as now how many items with the quantity greater than 20 and lesser than 20.

02:11 So, third is quantity greater than 20 and quantity lesser than 20.

02:21 So, for this in a separate cell enter the formula to create to count the items that meet the specific criteria as the count count is count of if c2 to c11 where it is lesser than 20 for a this is for greater than greater than 20...

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later