Knowledge Varsity

BUSCOM Mini Case 4.2

Welcome to KnowledgeVarsity Forum! This Forum is to answer your queries regarding question text and its instructions for this specific question. Please take a minute before posting a question and see if you can find an answer to your question. If not, please post your question. The Forum moderator will respond very soon!

Step 17: In cell K20 : Using SumProduct and Sum Function compute the Average Selling Price over the period
Note that Average Selling Price is not computed as Average of Price.
Average Selling Price = (Total Sales Amount) / (Total Quantiity Sold)
ANSWER: =SUMPRODUCT(D19:D27,F19:F27)/SUM(D19:D27)
ANSWER: =K18/SUM(D19:D27)

Step 18: In cell K21 : Using SumProduct and Sum Function compute the Average Cost Price over the period
Average Cost Price = (Total Cost Amount) / (Total Quantiity Purchased)
ANSWER: =SUMPRODUCT(E19:E27,G19:G27)/SUM(E19:E27)
ANSWER: =K19/SUM(E19:E27)

** Please grade correct for both answers. We already solved for SUMPRODUCT and therefore can reference it.