Required information

To complete this exercise, you will need to download and install Tableau on your computer. Tableau provides free instructor and student licenses as well as free videos and support for utilizing and learning the software. Once you are up and running with Tableau, watch the three "Getting Started" Tableau videos. All of Tableau's short training videos can be found here.

$[$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

Columns

Sales Volume

Rows

Amount

CVP

Description

$60$

$55$

$50$

$45$

$40$

$30$

$25$

$20$

$15$

$10$

Select all that apply

a$.$ The fact that the CVP graph's blue line is horizontal indicates which of the following statements is true?

$?$ The average fixed expense per unit increases as the sales volume increases from $0$ units to $50,000$ units.

$?$ The total fixed expense decreases as the sales volume increases from $0$ units to $50,000$ units

$?$ The total fixed expense increases as the sales volume increases from $0$ units to $50,000$ units.

$?$ The total fixed expense does not change between a sales volume of $0$ units and $50,000$ units.

$1$b$.$ The fact that the CVP graph's turquoise line intersects the Y$-$axis $($the vertical axis$)$ at $$80,000$ and then slants upward as the sales volume increases indicates which of the following statements is true?

$?$ The total expense is a mixed cost that equals $$8\mathrm{.}25$ when the sales volume is $1$ unit.

$?$ The total expense is purely a fixed expense that increases as the sales volume increases.

$?$ The total expense is a mixed cost that includes a fixed component and a variable component.

$?$ The total expense is purely a variable expense that increases as The sales volume increases

$1$c$.$ Which of the following statements is true with respect to the intersection of the red and blue lines?

$?$ It represents the company's break$-$even point, or that point where profits equal zero.

$?$ It represents the sales volume where the company's total sales equal its total fixed expense.

$?$ It represents the sales volume where the company's total sales equal its total variable expense.

It represents the sales volume where the company's total sales equal its total expense.