4 - Tableau Assignment i Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to questio 8. Repeat the process one more time by creating a calculated field "Asset Turnover" that consists of "Net sales" divided by "Average total assets." 9. Drag the newly created "Return on Assets" to add it to the Rows shelf. Format it to discrete. Right click on Return on Assets and click Format. On the left, you will see a format bar. Under Default, choose Alignment, then Horizontal Center. Then click on Numbers and choose Percentage. 10. Drag the newly created "Profit Margin on Sales" and "Asset Turnover" to the Rows shelf. Format them both as discrete and center aligned. "Profit Margin on Sales" should be formatted as percentage. "Asset Turnover" should be formatted as Number (Custom) with 2 decimal places. 11. Right-click the "Net income / (loss)," "Net sales," and "Average total assets" on the Rows shelf and un-select" Show header." This will hide these items from view but still allow them to be used in formulas. Saved 12. Double-click the tab at the bottom of the page and type Profitability Ratios to change the name of the sheet. 13. To hide the abc column, which appears when all variables are discrete, click on the Marks Card, and choose Polygon. This will hide the letters. Then click and drag the edge of the column to make it as small as possible. 14. Click on the New Worksheet tab on the lower left ("Sheet 2" should open). Drag "Year" to the Columns shelf and "Return on Assets," "Profit Margin on Sales" and "Asset Turnover" to the Rows shelf. 15. Drag "Company" under Tables to "Color" on the "All" section of the Marks card. You should now see two lines in each of the three graphs. 16. Double-click the tab at the bottom of the page and type Graph of Profitability Ratios to change the name of the sheet. 17. Save your work. Required: Based on the visualization you created, answer the following questions: A. What is the Big Store's return on assets in (a) 2012 and (b) 2021? B. What is the Discount Goods's return on assets in (a) 2012 and (b) 2021? To help determine why the relative profitability of the two companies has shifted over the ten-year period and to get a better company- to-company comparison, drag the second "pill": (Year Dimension) to the left of the "pill": (Company Dimension in the text chart). Req A and B C. The return on assets is a result of the profit margin and the asset turnover. Demonstrate this for Big Store in 2021 by showing that the profit margin times the asset turnover equals return on assets. D. Analyzing the asse turnover ratios over the ten-year period, is Big Store's asset turnover (a) generally increasing, (b) roughly the same, or (c) generally decreasing from year to year? E. Analyzing the asset turnover ratios over the ten-year period, is Discount Goods' turnover (a) generally increasing, (b) roughly the same, or (c) generally decreasing from year to year? F. As of 2021, which company reports a more favorable return on assets and is this primarily attributable to its asset turnover or profit margin? Complete this question by entering your answers in the tabs below. Req C X Answer is complete but not entirely correct. Req D to F Return on Assets for Big Store Return on Assets for Discount Goods Help Save & Exit What is the Big Store and Discount Goods's return on assets in (a) 2012 and (b) 2021? (Round your answers to 2 decimal places.) 2012 7.38 % 8.14 % Reg A and B Sub Prev 2021 7.00 X % 4.29 % 1 of 1 Req C > Next

8 Repeat the process one more time by cieatng a calculated field "Asset Turnover" that consists of "Wet sai es" chrofed by "Averag tosal aspets: 9. Drag the newly created "Return on Assets" to add it to the Powes shelt Format an to discrete foght chick on Return orn Assets and chick Format. On the lef, you willsee a forinat bar. Under Default, choose Alignment, then Horichtal Center. Then cick on Numbers and choose Prricentatye 10 Brag the newty created "Profit Margan on Sales" and "Asset Turndver" to the Rows shelf. Formatt them both as dascrete and centes aligned. "Profit Margin on Sales" should be formatted as percentage. "Asset furnover" should be formatted as Number (Custorm) with 2 decimal places 11. Right-click the "Nes incomed (Joss). NNet sales, and "Average tokal assels" on the Rows sheit and un-seleat" show header" Fhis Will hide these items from vicw but still aliow them to be used in formalas 12 Dooblectick the tab at the bottorn of the page and type Profitabily Ratics to change the name of the sheet 13 To hide the abe columtn, wilich appears when all variables afe discrete. chick on the Marks Cond. and chogse Polygori This wil. hide the letters. Then click and drog the edpe of the columm to make it as small as possible. 14. Click on the New Worksheet tab on the lower left Pheet 2 " should openy. Drag "Yeat" fo the Colurnas sheif and "Return on Assets," Protit Margin on Sales" and "Asset Turnover" to the Rows shet, 15. Drast "Company" under Tables to "Colot" on the "Air section of the Marks card You should now see tivo kines ah tach of the three graphs 16. Double-lick the tab at the bottom of the page and type Graph of Profitabilfy Ratios to change the name of the shcet 17. Sarve your work Required: Based on the visualization you created. answer the following questions A. What is the Bip Store's fetuin on assets in (a) 2012 and (b)2021 ? B. What is the Dicount Goods's return on assets in (a) 2012 and (b)2021 ? To heip determine wily the relative profiabdify of the fwo companies has shitiod over the tentyear pericid and to gect a bether compuny. to-compary comparison, drag the second "pil? fYeer Dimension) to the ieft of the "pir? gCompony Damension th the teat charti C. The return on assets is a result of the profit wargin arid the assem turtover. Bemonstrate thes foe Big 5 biof e un 20271 by shawing that the profit margin times the asser turnover equals return an assets D. Aaalyzing the asset turnover ratios over the ten-pear period, is Bro Store's asset tumpover (a) generaly increasing (b) foughly til same, or (c) generally decreasing from year to year? E. Aralyzing the asset tumover ratios ovel the tert-ycar period. is Discocint Goods' futnover (a) generahy mareasing. (b) rouphly the sante, or (c) gencrally decteosing fiom yeat to year? F. As of 2021, weich connpany repaits al more favorable return on assets and is ahes primanily attilouthbies to its assect turnover or prolit margin? (3) Answer is comalete bet not entirely correct. Complete this question by entering your answers in the tabs below. placess, 8 Repeat the process one more time by cieatng a calculated field "Asset Turnover" that consists of "Wet sai es" chrofed by "Averag tosal aspets: 9. Drag the newly created "Return on Assets" to add it to the Powes shelt Format an to discrete foght chick on Return orn Assets and chick Format. On the lef, you willsee a forinat bar. Under Default, choose Alignment, then Horichtal Center. Then cick on Numbers and choose Prricentatye 10 Brag the newty created "Profit Margan on Sales" and "Asset Turndver" to the Rows shelf. Formatt them both as dascrete and centes aligned. "Profit Margin on Sales" should be formatted as percentage. "Asset furnover" should be formatted as Number (Custorm) with 2 decimal places 11. Right-click the "Nes incomed (Joss). NNet sales, and "Average tokal assels" on the Rows sheit and un-seleat" show header" Fhis Will hide these items from vicw but still aliow them to be used in formalas 12 Dooblectick the tab at the bottorn of the page and type Profitabily Ratics to change the name of the sheet 13 To hide the abe columtn, wilich appears when all variables afe discrete. chick on the Marks Cond. and chogse Polygori This wil. hide the letters. Then click and drog the edpe of the columm to make it as small as possible. 14. Click on the New Worksheet tab on the lower left Pheet 2 " should openy. Drag "Yeat" fo the Colurnas sheif and "Return on Assets," Protit Margin on Sales" and "Asset Turnover" to the Rows shet, 15. Drast "Company" under Tables to "Colot" on the "Air section of the Marks card You should now see tivo kines ah tach of the three graphs 16. Double-lick the tab at the bottom of the page and type Graph of Profitabilfy Ratios to change the name of the shcet 17. Sarve your work Required: Based on the visualization you created. answer the following questions A. What is the Bip Store's fetuin on assets in (a) 2012 and (b)2021 ? B. What is the Dicount Goods's return on assets in (a) 2012 and (b)2021 ? To heip determine wily the relative profiabdify of the fwo companies has shitiod over the tentyear pericid and to gect a bether compuny. to-compary comparison, drag the second "pil? fYeer Dimension) to the ieft of the "pir? gCompony Damension th the teat charti C. The return on assets is a result of the profit wargin arid the assem turtover. Bemonstrate thes foe Big 5 biof e un 20271 by shawing that the profit margin times the asser turnover equals return an assets D. Aaalyzing the asset turnover ratios over the ten-pear period, is Bro Store's asset tumpover (a) generaly increasing (b) foughly til same, or (c) generally decreasing from year to year? E. Aralyzing the asset tumover ratios ovel the tert-ycar period. is Discocint Goods' futnover (a) generahy mareasing. (b) rouphly the sante, or (c) gencrally decteosing fiom yeat to year? F. As of 2021, weich connpany repaits al more favorable return on assets and is ahes primanily attilouthbies to its assect turnover or prolit margin? (3) Answer is comalete bet not entirely correct. Complete this question by entering your answers in the tabs below. placess