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.] Calloway Company is a merchandiser that has provided the following operating results for this year. Sales Variable expenses Contribution margin Fixed expenses Net operating income Average operating assets $2,750,000 2,024,000 726,000 572,000 $ 154,000 $ 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: Sales Variable expenses Fixed expenses Average operating assets Option 1 $ 2,500,000 $ 1,840,000 $ 600,000 $780,000 Option 2 $ 2,887,500 $ 2,125,200 $520,000 $1,850,000 Option 3 $ 3,575,000 $ 2,631,200 $750,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 year's 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 formula that calculates this year's margin and the estimated margin for each of the three investment alternatives. Then prepare a horizontal bar chart that compares the four margins 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 "Calculation!" with "Margin Type in the following formula: (Net operating income)(Sales) This formula is stating that you want the value of the Net operating Income divided by the Sales Double click on "new sheet" at the bottom of the workbook and change the name of the newly created "Sheet 1" to "Margin 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 "Margin" 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 (s This will allow the options to stand out better E 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: 9101 m Le Margin Analysis 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.) ta. Which of the following investment alternatives for next year earns the highest margin? Required information 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.) ha. Which of the following investment alternatives for next year earns the highest margin? Option Option 2 Option 3 b. Which of the following investment alternatives for next year earns the lowest margin? Option 11 Option 2 Option 3 c. Which of the following statements is true? None of the three options eams a higher margin then this year. Only one of the three options earns a higher margin than this year. Two of the three options sem a higher margm than this year All three options eam a higher margin than this year 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 formula that calculates this year's 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 "Calculation!" 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: Tumuver Analys 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 boses eft with a question mark will be automatically graded as incorrect.) Required information 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? Option 1 Option 21 Option 3 2b. Which of the following investment alternatives for next year earns the lowest turnover? Option 1 Option 2 7 Option 3 2c. Which of the following statements is true? None of the three options earns a higher turnover than this year Only one of the three options earns a higher turnover than this year. 7 Two of the three options earn a higher tumover than this year 7 All three options eam a higher turnover than this year 7. WHILE DIE vinywane LAGE Comunay Company II CU steps needed Create a formula that calculates this year's return on investment (ROI) and the estimated ROI for each of the three investment alternatives. Then prepare a vertical bar chart that compares the four ROIs 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 "Return on Investment" Type in the following formula: [Margin] [Turnover) This formula is stating that you want the value of the Margin multiplied by the Turnover Double click on "new sheet" at the bottom of the workbook and change the name of the newly created "Sheet 3" to "ROI Analysis" On the left-hand side under "Dimensions" (sometimes labeled as Tables), click on "Option" and drag and drop it into the "Columns" area. On the left-hand side under "Measures", click on the newly created measure of "Return on Investment" and drag and drop it into the "Rows" area o This should default to a vertical column chart 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 show the data labels as percentages, do the following: Right-click on the Y-axis and choose "Format": In the "Format" pane, click on the "Pane" tab, and in the "Default" section, change the "Numbers" dropdown to "Percentage" and modify the decimal places to "1" 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: forel NO Analysis Required: Olying Tableau-Return on Investment (Ch 11) 0 x.html?_con-con&external_browser=0&launchUrl=https%253A%252F%252Fnewco Saved Required information 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) 3a. Which of the following investment alternatives for next year earns the highest return on investment (ROI)? 7 Option 1 Option 2 Option 3 3b. Which of the following investment alternatives for next year earns the lowest return on investment (ROI)? Option 1 Option 2 Option 3 3c. Which of the following statements is true? None of the three options eams a higher return on investment (ROQ than this year Only one of the three options eams a higher return on investment (ROI) than this year Two of the three options eam a higher return on investment (RO) than this year All three options earn a higher return on investment (ROG than this year, 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: Margin Analysis ROI Analysis M Turnover Analysis 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 eft with a question mark will be automatically graded as incorrect.) 4. Which of the following statements is true? next year the company pursues option 1 and otherwise performs the same as this year, it will increase next year's overall turnovec but decrease its return on investment. next year the company pursues option 1 and otherwise performs the same as this year, it will increase next year's overal turnover and return on investment If next year the compeny pursues option 1 and otherwise performs the same as this year, it will decrease next year's overall turnover and t return on investment ing Tableau - Return on Investment (Ch 11) Required information Required: Saved 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.) 48. Which of the following statements is true? If next year the company pursues option 1 and otherwise performs the same as this year, it will increase next year's overall turnover, but decrease its return on investment. If next year the company pursues option 1 and otherwise performs the same as this year, it will increase next year's overall turnover and return on investment If next year the company pursues option 1 and otherwise performs the same as this year, it will decrease next year's overall turnover and return on investment. If next year the company pursues option 1 and otherwise performs the same as this year, it will decrease next year's overall turnover, but increase its return on investment 4b. Which of the following statements is true? If next year the company pursues option 2 and otherwise performs the same as this year, it will increase next year's overall turnover, but decrease its return on investment If next year the company pursues option 2 and otherwise performs the same as this year it will increase next year's overall turnover and return on investment If next year the company pursues option 2 and otherwise performs the same as this year, it will decrease next year's overall turnover and return on investment. If next year the company pursues option 2 and otherwise performs the same as this year, it will decrease next year's overall turnover, but increase its return on investment c. Which of the following statements is true? If next year the company pursues option 3 and otherwise performs the same as this year, it will increase next year's overall margin, but decrease its retum on investment If next year the company pursues option 3 and otherwise performs the same as this year it will increase next year's overall margin and return on investment If next year the company pursues option 3 and otherwise performs the same as this year, it will decrease next year's overall margin and return on investment If next year the company pursues option 3 and otherwise performs the same as this year, & will decrease next year's overall margin, but Increase as return on investment 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.] Calloway Company is a merchandiser that has provided the following operating results for this year. Sales Variable expenses Contribution margin Fixed expenses Net operating income Average operating assets $2,750,000 2,024,000 726,000 572,000 $ 154,000 $ 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: Sales Variable expenses Fixed expenses Average operating assets Option 1 $ 2,500,000 $ 1,840,000 $600,000 $780,000 Option 2 $2,887,500 $ 2,125,200 $520,000 $1,850,000 Option 3 $3,575,000 $ 2,631,200 $750,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 year's 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 Upload your visualizations to PowerPoint Go to File Export as PowerPoint. Save your new PowerPoint file Upload your PowerPoint file where shown below. 8 < Prev 5 Next Applying Tableau ReturnOninvestment Template (2) Home Insert Draw Page Layout Formulas Data Review View Automate Developer Tell me a 8 Share Comments Calibri (Body) 11 Paste 0 BIU AA A General Conditional Formatting Forman Table Delete $% Editing Cell Styles Format Analyze Serlily Data 11 Cuand Fort Algimant Number Style Cells Sensitivity fx A 1 Option Average operating assets Sales 2 This Year $ 3 Option 1 $ 4 Option 2 $ 5 Option 3 $ 1,306,350 $2,750,000 $1 780,000 $2,500,000 $ 1,850,000 $ 2,887,500 $ 1,200,000 $3,575,000 $ D F H Variable expenses Contribution margin Fixed expenses Net operating income 2,024,000 $ 725,000 $ 572,000 $ 1,840,000 $ 660,000 $ 600,000 $ 154,000 60,000 2,125,200 $ 762,300 $ 520,000 $ 242,300 2,631,200 $1 943,800 $ 750,000 $ 193,800 6 7 8 9 10 11 12 13 14 Calloway Company Ready Accessibility. Good to go 140%