Required information

Applying Tableau Analytics 11-01 (Static) Return on Investment [LO11-1]

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.] Calloway Company is a merchandiser that has provided the following operating results for this year.

Sales	$ 2,750,000
Variable expenses	2,024,000
Contribution margin	726,000
Fixed expenses	572,000
Net operating income	$ 154,000
Average operating assets	$ 1,306,350

For next year the company is considering three investment alternatives with the following estimated incremental sales, variable expenses, fixed expenses, and operating assets:

	Option 1	Option 2	Option 3
Sales	$ 2,500,000	$ 2,887,500	$ 3,575,000
Variable expenses	$ 1,840,000	$ 2,125,200	$ 2,631,200
Fixed expenses	$ 600,000	$ 520,000	$ 750,000
Average operating assets	$ 780,000	$ 1,850,000	$ 1,200,000

You have been asked to create some data visualizations that depict the projected margin, turnover, and return on investment (ROI) for the three investment alternatives relative to this years performance. Download the Excel file, which you will use to create the Tableau visualization that aid your explanation.

Upload the Excel file into Tableau by doing the following:

1. Open the Tableau Desktop application.
2. On the left-hand side, under the Connect header and the To a file sub-header, click on Microsoft Excel.
3. Choose the Excel file and click Open.
4. Since the only worksheet in the Excel File is Calloway Company it will default as a selection with no further import steps needed

Applying Tableau Analytics 11-01 (Static) Part 2

Create a formula that calculates this years turnover and the estimated turnover for each of the three investment alternatives. Then prepare a horizontal bar chart that compares the four turnovers for the four scenarios:

• Begin by creating a new calculated field
  • Click on Analysis from the menu dropdowns at the top and choose Create a calculated field
    • Replace the current calculated field name Calculation1 with Turnover
    • Type in the following formula:
      • [Sales]/[Average operating assets]
      • This formula is stating that you want the value of the Sales divided by the Average Operating Assets
• Double click on new sheet at the bottom of the workbook and change the name of the newly created Sheet 2 to Turnover Analysis
• On the left-hand side under Dimensions (sometimes labeled as Tables), double-click on Option
• On the left-hand side under Measures, double click on the newly created measure of Turnover
• In the upper right-hand corner, click on Show Me and choose the Horizontal bars option in the 1st column third row down.
• On the left-hand side under Dimensions (sometimes labeled as Tables), click on Option and drag and drop it onto the Colors Marks card ().
  • This will allow the options to stand out better
• Click on the Label button () at the top of the screen to show the margin values
• 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.) 2a. Which of the following investment alternatives for next year earns the highest turnover?

check all that apply 1

• Option 1unanswered
• Option 2unanswered
• Option 3unanswered

2b. Which of the following investment alternatives for next year earns the lowest turnover?

check all that apply 2

• Option 1unanswered
• Option 2unanswered
• Option 3unanswered

2c. Which of the following statements is true?

check all that apply 3

• None of the three options earns a higher turnover than this year.unanswered
• Only one of the three options earns a higher turnover than this year.unanswered
• Two of the three options earn a higher turnover than this year.unanswered
• All three options earn a higher turnover than this year.

Option	Average operating assets	Sales	Variable expenses	Contribution margin	Fixed expenses	Net operating income
This Year	$ 1,306,350	$ 2,750,000	$ 2,024,000	$ 726,000	$ 572,000	$ 154,000
Option 1	$ 780,000	$ 2,500,000	$ 1,840,000	$ 660,000	$ 600,000	$ 60,000
Option 2	$ 1,850,000	$ 2,887,500	$ 2,125,200	$ 762,300	$ 520,000	$ 242,300
Option 3	$ 1,200,000	$ 3,575,000	$ 2,631,200	$ 943,800	$ 750,000	$ 193,800