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

Create a dashboard that summarizes the Margin, Turnover, and Return on Investment for this year and the three investment alternatives:

• In the top menu area, click on the dropdown for Dashboard and choose New Dashboard
• Double click on new dashboard at the bottom of the workbook and change the name of the newly created Dashboard 1 to ROI Dashboard
• On the left hand side under Sheets, drag and drop Margin Analysis onto the dashboard
• On the left hand side under Sheets, drag and drop Turnover Analysis onto the dashboard to the right of the Margin Analysis
• On the left hand side under Sheets, drag and drop ROI Analysis onto the dashboard underneath both the Margin Analysis and Turnover Analysis
  • You can play around here to find the best fit, for the ROI Analysis work to get the visualization to take up the whole bottom half of the visualization
• Click on the legend in the upper right hand corner and click the X to remove it, as all the colors are consistent across the three visualizations
• 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.) 4a. Which of the following statements is true?

check all that apply 1

• If next year the company pursues option 1 and otherwise performs the same as this year, it will increase next years overall turnover, but decrease its return on investment.unanswered
• If next year the company pursues option 1 and otherwise performs the same as this year, it will increase next years overall turnover and return on investment.unanswered
• If next year the company pursues option 1 and otherwise performs the same as this year, it will decrease next years overall turnover and return on investment.unanswered
• If next year the company pursues option 1 and otherwise performs the same as this year, it will decrease next years overall turnover, but increase its return on investment.unanswered

4b. Which of the following statements is true? check all that apply 2

• If next year the company pursues option 2 and otherwise performs the same as this year, it will increase next years overall turnover, but decrease its return on investment.unanswered
• If next year the company pursues option 2 and otherwise performs the same as this year, it will increase next years overall turnover and return on investment.unanswered
• If next year the company pursues option 2 and otherwise performs the same as this year, it will decrease next years overall turnover and return on investment.unanswered
• If next year the company pursues option 2 and otherwise performs the same as this year, it will decrease next years overall turnover, but increase its return on investment.unanswered

4c. Which of the following statements is true? check all that apply 3

• If next year the company pursues option 3 and otherwise performs the same as this year, it will increase next years overall margin, but decrease its return on investment.unanswered
• If next year the company pursues option 3 and otherwise performs the same as this year, it will increase next years overall margin and return on investment.unanswered
• If next year the company pursues option 3 and otherwise performs the same as this year, it will decrease next years overall margin and return on investment.unanswered
• If next year the company pursues option 3 and otherwise performs the same as this year, it will decrease next years overall margin, but increase its return on investment.