answer

There are many analytical procedures that can provide persuasive evidence. In this example, we have sales data and commission data. We can determine whether the relationship between commissions and sales makes sense. If it does, that suggests that commissions expense is fairly stated. In your audit procedure, you use visualizations to show the relationship between sales and commissions, show sales versus commissions by salesperson, and show the average commission rate per customer. Clickhereto access a Tableau file, and hereto access a Power Bl file.(The Tableau and Power Bl files contain the same visualizations; you can use either one to answer the questions in this assignment. Your instructor may specify which program they prefer you to use.) How to Access Tableau: You can open the Tableau file in this problem statement with Tableau desktop software. If you do not have Tableau desktop software, you can download the most recent version of Tableau Reader, a free program that allows you to open Tableau visualizations. To get the most recent version, search for \"Tableau Reader\" in your internet browser. How to Access Power Bl: You can open the Power Bl file in this problem statement with Power Bl Desktop. If you do not have it already, you can download PowerBI Desktop here: https://powerbi.microsoft.com/en-us/downloads. (a) See below for the commission policy of the firm. Given the policy, what do you believe about the reasonableness of the commission rate given the visualization of average commission? For sales greater than $75,000, commission is 3.75% For sales greater than $50,000, but less than $75,000, commission is 2.5% For sales greater than $25,000, but less than $50,000, commission is 1.25% For sales less than $25,000, commission is 0.5% O The average commissions and the range of average commission suggest that commissions expense is fairly stated. O Commissions do not span the expected range, so commissions are understated. O Thereis not enough information to make a determination. O Commissions are overstated due to the extremely large values of average commission rate