Your client is a manufacturer of handheld tools that employs a sales force to market the tools to retail hardware stores. You plan to use substantive analytical procedures to gather persuasive evidence about the reasonableness of commissions expense. The visualization titled Average Commission Rate per Customer has sales and commissions expense data. You can determine whether the relationship between commissions and sales makes sense. If it does, that suggests that commissions expense is fairly stated. The commission policy of the client is as follows: 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% You can open the Tableau file in this problem statement with Tableau Desktop software. If you do not have a version of Tableau Desktop, you can open the file with Tableau Reader. Tableau Reader is a free download that allows you to open visualizations built with Tableau Desktop. To find a free download of Tableau Reader on the Tableau website, search for Tableau Reader in your internet browser, or click here.

Question: Using the visualization titled Sales before Tax and Commissions per Salesperson, which of the following is most likely true:

A. Commissions vary with order size, so the relationship of some commissions higher and some lower than sales on a dual axis makes sense. Commissions expense appears fairly stated.

B. Sales should be much higher than commissions, so there is a material misstatement in the data.

C. We dont have enough information to provide persuasive evidence with respect to commissions expense.

D. Sales commissions and Sales should be identical in height. There is a material misstatement in the data.

Measure Names Sales Before Tax and Commissions per Salesperson Commission Sales before tax 20K 1300K 1.60% $1,198,759 18K 1200K 1100K 1.49% $1,022,440 1.41% $1,029,339 16K 1000K 1.43% $900,395 1.66% $937, 132 14K 900K 1.42% $971,254 1.25% Average Sales per Salesperson $880,698 $264 46 Average commission per sales person $12,603- 1.46% $722,404 1.24% $785,287 800K 12K 1.5196 $677,692 700K Sales before tax 10K Commission $19,192 1.05% $578,504 600K $15,587 8K 500K $15,238 $14,534 $13,823 $12,850 400K 5K $10,784 $10,522 $9,768 $10,238 300K 4K 200K $6,097 2K 100K OK OK A. Lopez B. Wood C. Sandoval D. Russell E. Carr F. Hughes G. Liu H. Park J. Morton M. Nicholls S. Warren Measure Names Sales Before Tax and Commissions per Salesperson Commission Sales before tax 20K 1300K 1.60% $1,198,759 18K 1200K 1100K 1.49% $1,022,440 1.41% $1,029,339 16K 1000K 1.43% $900,395 1.66% $937, 132 14K 900K 1.42% $971,254 1.25% Average Sales per Salesperson $880,698 $264 46 Average commission per sales person $12,603- 1.46% $722,404 1.24% $785,287 800K 12K 1.5196 $677,692 700K Sales before tax 10K Commission $19,192 1.05% $578,504 600K $15,587 8K 500K $15,238 $14,534 $13,823 $12,850 400K 5K $10,784 $10,522 $9,768 $10,238 300K 4K 200K $6,097 2K 100K OK OK A. Lopez B. Wood C. Sandoval D. Russell E. Carr F. Hughes G. Liu H. Park J. Morton M. Nicholls S. Warren