For this case, you will create several calculations to produce a bar chart and a map...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For this case, you will create several calculations to produce a bar chart and a map of the gross profit to allow you to compare and contrast a company's inventory measurement. Use the following steps to create the charts you'll need for this case: 1. Download the Excel file "Inventory." 2. Open Tableau and connect to the Excel file. Click on the "Sheet 1" tab, at the bottom of the canvas, to the right of the Data Source at the bottom of the screen. 3. Drag "Region" to the Columns shelf. 4. Drag "Status" to the Filters card. When the Filter window opens, click the "S" so only the sold items will be viewed. Click OK. 5. Click on the "Analysis" tab from the Toolbar at the top of the screen and select "Create Calculated Field." A calculation box will pop up. Name the calculation "Total Sales." Drag "Number" under Tables to the Calculations Editor. Type a multiplication sign beside it, then drag "Selling Price" under Measure Names to the Calculations Editor. Make sure the window says that the calculation is valid and click OK. 6. Repeat the process outlined above and create a calculated field for "Cost of Goods Sold" that consists of "Number" multiplied by "Cost." 7. Repeat the process outlined above and create a calculated field for "Gross Profit" that consists of "Total Sales" minus "Cost of Goods Sold." 8. From the Measure Names section on the middle left side of the canvas, drag "Total Sales," "Cost of Goods Sold," and "Gross Profit" into Rows shelf. 9. Click the "Show Me" box on right side of the toolbar and select the "side-by-side bars." 10. Show the labels by clicking on the Label box on the Marks card and checking "Show mark labels." 11. Change the title of the sheet to be "Total Sales, COGS, and Gross Profit by Region" by double-clicking the tab at the bottom of the page and typing Total Sales, COGS, and Gross Profit by Region. 12. Click on the New Worksheet tab on the lower left ("Sheet 2" should open). 13. Drag "State" to the Columns shelf. 14. Drag "Gross Profit" and "Total Sales" to the Rows shelf. 15. Click on the "Analysis" tab from the Toolbar at the top of the screen and select "Create Calculated Field". Name the calculation field "Gross Profit Ratio by State" by dragging "Sum (Gross Profit)" from the Rows shelf and then dividing by "Sum (Total Sales)" 16. Remove "Sum (Total Sales)" from the Rows shelf by dragging it back over to Tables. 17. In the "Show Me" box on right side of the toolbar, select the "symbol map". You should see a map of the United States with circles appearing in states with data. Click on Show Me again to hide the options. Drag "Gross Profit Ratio by State" from Measure Names to the bottom of the Marks card. Click on the circle symbol beside the "Gross Profit Ratio by State" and select "Color." The dots should now vary in size and color based on the size of the gross profit ratio and gross profit. Enlarge the dots by clicking "Size" on the Marks card and adjusting the slide. You can also change the color variation by clicking "Color" on the Marks card and editing the color. Choose Green-Gold or another multi-color option to make the color differences easier to see. 18. Change the title of the sheet to be "Gross Profit Ratio by State" by double-clicking the tab at the bottom of the page and typing Gross Profit Ratio by State. 19. Save your work. Required: Based upon what you find, answer the following questions: A. Which of the five regions' operations has the highest gross profit? B. Which of the five regions' operations has the lowest gross profit? To help determine the relative profitability of each state's sales, get a better state-by-state comparison by analyzing the "map" chart. Note that the circle size indicates Gross Profit and the color indicates Gross Profit Ratio. It may be easier to answer the questions if you click on the Label box in the marks card and select Show Marks, then select Min/Max. Once the chart is created, move your cursor to hover above various circles within states in the chart. Notice that an information box appears to reveal the pertinent gross profit and gross profit ratios for that state. C. Which state's operations provides the highest gross profit ratio? Note: Round your answer to 1 decimal place. D. Which state's operations provides the lowest gross profit ratio? Note: Round your answer to 1 decimal place. A. The B. The C. D. region's operations has the highest with a gross profit of about region's operations has the lowest with a gross profit of operations has the highest with a gross profit ratio of operations has the lowest with a gross profit ratio of %. %. For this case, you will create several calculations to produce a bar chart and a map of the gross profit to allow you to compare and contrast a company's inventory measurement. Use the following steps to create the charts you'll need for this case: 1. Download the Excel file "Inventory." 2. Open Tableau and connect to the Excel file. Click on the "Sheet 1" tab, at the bottom of the canvas, to the right of the Data Source at the bottom of the screen. 3. Drag "Region" to the Columns shelf. 4. Drag "Status" to the Filters card. When the Filter window opens, click the "S" so only the sold items will be viewed. Click OK. 5. Click on the "Analysis" tab from the Toolbar at the top of the screen and select "Create Calculated Field." A calculation box will pop up. Name the calculation "Total Sales." Drag "Number" under Tables to the Calculations Editor. Type a multiplication sign beside it, then drag "Selling Price" under Measure Names to the Calculations Editor. Make sure the window says that the calculation is valid and click OK. 6. Repeat the process outlined above and create a calculated field for "Cost of Goods Sold" that consists of "Number" multiplied by "Cost." 7. Repeat the process outlined above and create a calculated field for "Gross Profit" that consists of "Total Sales" minus "Cost of Goods Sold." 8. From the Measure Names section on the middle left side of the canvas, drag "Total Sales," "Cost of Goods Sold," and "Gross Profit" into Rows shelf. 9. Click the "Show Me" box on right side of the toolbar and select the "side-by-side bars." 10. Show the labels by clicking on the Label box on the Marks card and checking "Show mark labels." 11. Change the title of the sheet to be "Total Sales, COGS, and Gross Profit by Region" by double-clicking the tab at the bottom of the page and typing Total Sales, COGS, and Gross Profit by Region. 12. Click on the New Worksheet tab on the lower left ("Sheet 2" should open). 13. Drag "State" to the Columns shelf. 14. Drag "Gross Profit" and "Total Sales" to the Rows shelf. 15. Click on the "Analysis" tab from the Toolbar at the top of the screen and select "Create Calculated Field". Name the calculation field "Gross Profit Ratio by State" by dragging "Sum (Gross Profit)" from the Rows shelf and then dividing by "Sum (Total Sales)" 16. Remove "Sum (Total Sales)" from the Rows shelf by dragging it back over to Tables. 17. In the "Show Me" box on right side of the toolbar, select the "symbol map". You should see a map of the United States with circles appearing in states with data. Click on Show Me again to hide the options. Drag "Gross Profit Ratio by State" from Measure Names to the bottom of the Marks card. Click on the circle symbol beside the "Gross Profit Ratio by State" and select "Color." The dots should now vary in size and color based on the size of the gross profit ratio and gross profit. Enlarge the dots by clicking "Size" on the Marks card and adjusting the slide. You can also change the color variation by clicking "Color" on the Marks card and editing the color. Choose Green-Gold or another multi-color option to make the color differences easier to see. 18. Change the title of the sheet to be "Gross Profit Ratio by State" by double-clicking the tab at the bottom of the page and typing Gross Profit Ratio by State. 19. Save your work. Required: Based upon what you find, answer the following questions: A. Which of the five regions' operations has the highest gross profit? B. Which of the five regions' operations has the lowest gross profit? To help determine the relative profitability of each state's sales, get a better state-by-state comparison by analyzing the "map" chart. Note that the circle size indicates Gross Profit and the color indicates Gross Profit Ratio. It may be easier to answer the questions if you click on the Label box in the marks card and select Show Marks, then select Min/Max. Once the chart is created, move your cursor to hover above various circles within states in the chart. Notice that an information box appears to reveal the pertinent gross profit and gross profit ratios for that state. C. Which state's operations provides the highest gross profit ratio? Note: Round your answer to 1 decimal place. D. Which state's operations provides the lowest gross profit ratio? Note: Round your answer to 1 decimal place. A. The B. The C. D. region's operations has the highest with a gross profit of about region's operations has the lowest with a gross profit of operations has the highest with a gross profit ratio of operations has the lowest with a gross profit ratio of %. %.
Expert Answer:
Answer rating: 100% (QA)
Im sorry for the confusion but I cant directly interact with Excel or Tableau to perform data a... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-1260481952
10th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas
Posted Date:
Students also viewed these accounting questions
-
Produce a bar chart (Gantt Chart) based on the ES and EF times from the schedule in item. Early start time(days) Early finish time(days) Activity Estimated Late start Late finish time(days)...
-
Figures 2.1 and 2.3 show a bar chart and a pie chart for how adults pay their monthly bills (see pages 42 and 43). a. Create an exploded pie chart, a doughnut chart, a cone chart, or a pyramid chart...
-
Figures 2.2 and 2.4 show a bar chart and a pie chart for the risk level for the bond fund data (see pages 43 and 44). a. Create an exploded pie chart, a doughnut chart, a cone chart, and a pyramid...
-
Consider the following scenario. Each day, a butcher buys a 200-kilogram pig for $360. The pig can be processed to yield the following three products: Day 1 The butcher buys a pig. The $360 joint...
-
Multiple Choice Questions 1. Bond carrying value equals Bonds Payable a. Minus Premium on Bonds Payable. b. Plus Discount on Bonds Payable. c. Minus Discount on Bonds Payable. d. Plus Premium on...
-
Feng Disc Golf Course was opened on March 1 by Lee Feng. The following selected events and transactions occurred during March (amounts in thousands). Mar. 1 Invested 20,000 cash in the business. 3...
-
Use the pain tolerance ratings after the activity to estimate the difference in mean pain tolerance between those who just completed a high exertion activity and those who completed a low exertion...
-
Information for 2017 follows for Rolling Thunder Corp.: Retained earnings, January 1, 2017 ......................................................... $ 1,980,000 Sales revenue...
-
+ 2 of 3 Required information [The following information applies to the questions displayed below.] Ries, Bax, and Thomas invested $54,000, $70,000, and $78,000, respectively, in a partnership....
-
Veryclear Glassware is a new business owned by Skyler Peoples, the company president. Skyler's first year of operation commenced on January 1, 2022. EIN: 78-7654398 Address: 23051 Old Redwood...
-
How important is price in determining demand for travel? Is price a consideration for all travelers? Who is most likely to be affected by price changes? How can price be used to moderate demand?
-
List your experiences of sloppy digital marketing.
-
Using an approach similar to that in Worked Example 19.1, find all words with exactly one vowel (which might be repeated). What is the longest one? How many such words exist for each length? Data...
-
Why is the collection of the keys of a map a set and not a list?
-
What is the difference between a binary tree and a binary search tree? Give examples of each.
-
Consider an array list implementation with a removeLast method that shrinks the internal array to half of its size when it is at most half full. Give a sequence of addLast and removeLast calls that...
-
The carrying amount of Investment in Ordinary Shares as of December 31, 2020 is misstated by? 2. The effective interest rate on Investment in Bonds is? 3. The carrying amount of Investment in Bonds...
-
You are interested in investing and are considering a portfolio comprised of the following two stocks. Their estimated returns under varying market conditions are provided: (note: it is difficult to...
-
Listed below are 10 causes of temporary differences. For each temporary difference indicate the balance sheet account for which the situation creates a temporary difference. Temporary Difference...
-
Stanley and Jones Lawn Service Company (S&J) maintains its books on a cash basis. However, the company recently borrowed $100,000 from a local bank, and the bank requires S&J to provide annual...
-
On April 1, 2021, John Vaughn purchased appliances from the Acme Appliance Company for $1,200. In order to increase sales, Acme allows customers to pay in installments and will defer any payments for...
-
What is the daughter nucleus of the decay? The Curiosity rover sent to explore the surface of Mars has an electric generator powered by heat from the radioactive decay of \({ }^{238} \mathrm{Pu}\), a...
-
Because the decay products in the above fission reaction are neutron rich, they will likely decay by what process? A. Alpha decay B. Beta decay C. Gamma decay The uranium isotope \({ }^{235}...
-
What statement can be made about the masses of atoms in the above reaction? A. \(m\left({ }_{92}^{235} \mathrm{U} ight)>m\left({ }_{56}^{141} \mathrm{Ba} ight)+m\left({ }_{36}^{92} \mathrm{Kr}...
Study smarter with the SolutionInn App