$[$The following information applies to the questions displayed below.$]$

Orton Company distributes one product that sells for $$11\mathrm{.}50$ per unit and incurs variable expenses of $$8\mathrm{.}25$ per unit. Its monthly fixed expense is $$80,000.$ The company currently pays its sales representatives a sales commission of $$1\mathrm{.}75$ per unit sold; however, it is considering replacing these sales commissions with sales salaries of $$70,000$ per month. Orton would like your help in creating a cost$-$volume$-$profit $($CVP$)$ graph and a profit graph for both compensation scenarios up to a sales volume of $50,000$ units.

Download the Excel file, which you will use to create the CVP graphs and profit graphs within Tableau.

Upload the Excel file into Tableau by doing the following:

Open the Tableau Desktop application.

On the left$-$hand side, under the "Connect" header and the $"$To a file" sub$-$header, click on "Microsoft Excel."

Choose the Excel file and click "Open."

Since the only worksheet in the Excel File is "Orton Company" it will default as a selection with no further import steps needed

Iiil Columns

Sales Volume

Salos Volume

Required:

than one answer. Single click the box with the question mark to

Note: Note that for all questions below you may select more than one ans a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer.

Any boxes left with a question mark will be automatically graded as incorrect.

$5$a$.$ If the variable expense per unit decreased and the selling price per unit and total fixed expense remained unchanged, then which of the following statements is true?

$?$

The line shown in the profit graph would shift to a V$-$shape.

The line shown in the profit graph would not change.

The line shown in the profit graph would steepen.

The line shown in the profit graph would flatten out.

$5$b$.$ If the selling price per unit and the variable expense per unit both increased by $$1$ and the total fixed expense remained unchanged, then which of the following statements is true?

The line shown in the profit graph would shift to a V$-$shape.

The line shown in the profit graph would not change.

The line shown in the profit graph would steepen.

The line shown in the profit graph would flatten out.

$5$c$.$ If the total fixed expense decreased and the selling price per unit and the variable expense per unit both remained unchanged, then which of the following statements is true?

The line shown in the profit graph would shift downward but its angle in relation to the $x-$axis $($the horizontal axis$)$ would not change.

The line shown in the profit graph would shift downward and its angle in relation to the $x-$axis $($the horizontal axis$)$ would flatten out.

The line shown in the profit graph would shift downward and its angle in relation to the $x-$axis $($the horizontal axis$)$ would steepen.

The line shown in the profit graph would shift upward and its angle in relation to the $x-$axis $($the horizontal axis$)$ would steepen.