Required information

Skip to question

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 Tableaus 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.50 per unit and incurs variable expenses of $8.25 per unit. Its monthly fixed expense is $80,000. The company currently pays its sales representatives a sales commission of $1.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

Create a cost-volume-profit (CVP) graph based on the companys existing commission-based compensation scheme for its sales representatives:

Double click on new sheet at the bottom of the workbook and change the name of the newly created Sheet 1 to CVP Graph Commissions

On the left-hand side under Measures, double click on Amount

On the left-hand side under Measures, double click on Sales Volume

A scatterplot with one data point will be created. This is because Tableau assumes you want to plot the sums of the two measures.

To show all measures go to the Analysis dropdown at the top menu bar and uncheck the box next to Aggregate measures

Under the Marks card area, click on the drop down that currently says Automatic and modify it to Line

On the left-hand side under Dimensions (sometimes labeled as Tables), click on Description and drag and drop it onto the Colors Marks card ().

We do not need to see the Profit measure at this time, so in the upper right hand Description legend, click on Profit and choose Exclude

Note this will filter out the Profit data

We want to evaluate only Commissions at this point, so on the left-hand side under Dimensions (sometimes labeled as Tables), click on Option and drag and drop it into the Filters box (above the Marks card)

The Filter window will open, check the box next to Commissions only, and click OK

To improve viewing, locate the Standard dropdown option in the menu bar at the top of the screen. Click on that dropdown and choose Entire View.

Your visualization should appear as follows:

Required: (Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce 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.) 1a. The fact that the CVP graphs blue line is horizontal indicates which of the following statements is true?

check all that apply 1

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

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

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

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

1b. The fact that the CVP graphs 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?

check all that apply 2

The total expense is a mixed cost that equals $8.25 when the sales volume is 1 unit.unanswered

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

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

The total expense is purely a variable expense that increases as the sales volume increases.unanswered

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

check all that apply 3

It represents the companys break-even point, or that point where profits equal zero.unanswered

It represents the sales volume where the companys total sales equal its total fixed expense.unanswered

It represents the sales volume where the companys total sales equal its total variable expense.unanswered

It represents the sales volume where the companys total sales equal its total expense.

/Users/johnrodriguez/Library/Containers/com.microsoft.Excel/Data/Downloads/ApplyingTableau_Cost-Volume-ProfitRelationships_Template.xlsx