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)
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)
** Please grade correct for both answers. We already solved for SUMPRODUCT and therefore can reference it.