Assignment Steps: 1. Download data file AT Data Job GP. 2. Double left-click on Tableau icon...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assignment Steps: 1. Download data file AT Data Job GP. 2. Double left-click on Tableau icon to open it. 3. Left-click on Microsoft Excel in the blue Connect pane on left-hand side to show data files. 4. Navigate to the data file you just downloaded and double left-click the data file name: AT Data Job GP. 5. Left-click on orange-shaded Sheet 1 at bottom of screen. 6. Double left-click Sheet 1 at top of blank worksheet. Enter title of worksheet as Gross Profit Ratio; then left-click to center-text; then left-click OK. 7. On the top ribbon (or menu bar on Mac), left-click Analysis and select Create Calculated Field. 8. Name calculated field Cost of Goods Sold. 9. In the calculated field, type [Direct Materials Cost]+[Direct Labor Cost]+[Applied Overhead] and left-click OK. 10. On the top ribbon (or menu bar on Mac), left click Analysis and select Create Calculated Field. 11. Name calculated field Gross Profit. 12. In the calculated field, type [Sales]-[Cost of Goods Sold] and left-click OK. 13. On the top ribbon (or menu bar on Mac), left-click Analysis and select Create Calculated Field. 14. Name calculated field Gross Profit Ratio. 15. In the calculated field, type SUM([Gross Profit])/SUM([Sales]) and left-click OK. 16. Left-click Gross Profit Ratio and drag it from left-hand side Tables pane to the Rows shelf. This creates a bar graph of gross profit ratio. 17. Left-click and hold Gross Profit Ratio and drag it from left-hand side Tables pane to the Label card (located under Marks near middle of screen). This adds a label to the display. Pause and complete Requirement 1. 18. Double-left click Gross Profit Ratio at top of worksheet. Change title of worksheet to Gross Profit Ratio by Job; then left-click OK. 7. On the top ribbon (or menu bar on Mac), left-click Analysis and select Create Calculated Field. 8. Name calculated field Cost of Goods Sold. 9. In the calculated field, type [Direct Materials Cost]+[Direct Labor Cost]+[Applied Overhead] and left-click OK. 10. On the top ribbon (or menu bar on Mac), left click Analysis and select Create Calculated Field. 11. Name calculated field Gross Profit. 12. In the calculated field, type [Sales]-[Cost of Goods Sold] and left-click OK. 13. On the top ribbon (or menu bar on Mac), left-click Analysis and select Create Calculated Field. 14. Name calculated field Gross Profit Ratio. 15. In the calculated field, type SUM([Gross Profit])/SUM([Sales]) and left-click OK. 16. Left-click Gross Profit Ratio and drag it from left-hand side Tables pane to the Rows shelf. This creates a bar graph of gross profit ratio. 17. Left-click and hold Gross Profit Ratio and drag it from left-hand side Tables pane to the Label card (located under Marks near middle of screen). This adds a label to the display. Pause and complete Requirement 1. 18. Double-left click Gross Profit Ratio at top of worksheet. Change title of worksheet to Gross Profit Ratio by Job; then left-click OK. 19. Left-click and hold Job and drag it from left-hand side Tables pane to the Columns shelf (on the upper right). This creates a bar graph of gross profit ratio by job. 20. Sort jobs in descending order of gross profit by selecting sort descending from top ribbon (or menu bar on Mac). Pause and complete Requirement 2. 21. Right-click (or Control-Click on Mac) Sheet 1 on the bottom ribbon and select Duplicate. 22. Double-left click Gross Profit Ratio by Job at top of worksheet. Change title of worksheet to Gross Profit Ratio by Work Shift; then left-click OK. 23. Right-click (or Control-Click on Mac) Job in the Columns pane and click Remove. 24. Left-click and hold Work Shift and drag from left-hand side Tables pane to the Columns shelf (on the upper right). Pause and complete Requirement 3. Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Determine the gross profit ratio. (Round your answer to 2 decimals.) Gross profit ratio % Required 3B Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Required 3B Determine gross profit ratio by job. (Round your answers to 2 decimals.) Job Number Gross Profit Ratio B20 % % % B21 B22 B23 B24 B25 B26 B27 B28 B29 % % % % % % % Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Required 3B Determine gross profit ratio by work shift. (Round your answers to 2 decimals.) Gross Profit Ratio % % Work Shift Day Night Job B20 B21 B22 B23 B24 B25 B26 B27 D B28 1 B29 2 Work Shift Day Day Day Day Day Night Night Night Night Night Direct Materials Cost $680 $540 $360 $510 $790 $530 $510 $380 $590 $500 Direct Labor Cost $800 $640 $640 $920 $1,120 $200 $960 $1,240 $1,040 $600 Applied Overhead $1,280 $1,024 $1,024 $1,472 $1,792 $320 $1,536 $1,984 $1,664 $960 Sales $3,378 $2,805 $3,086 $3,607 $6,638 $1,839 $3,352 $2,903 $4,887 $2,540 Assignment Steps: 1. Download data file AT Data Job GP. 2. Double left-click on Tableau icon to open it. 3. Left-click on Microsoft Excel in the blue Connect pane on left-hand side to show data files. 4. Navigate to the data file you just downloaded and double left-click the data file name: AT Data Job GP. 5. Left-click on orange-shaded Sheet 1 at bottom of screen. 6. Double left-click Sheet 1 at top of blank worksheet. Enter title of worksheet as Gross Profit Ratio; then left-click to center-text; then left-click OK. 7. On the top ribbon (or menu bar on Mac), left-click Analysis and select Create Calculated Field. 8. Name calculated field Cost of Goods Sold. 9. In the calculated field, type [Direct Materials Cost]+[Direct Labor Cost]+[Applied Overhead] and left-click OK. 10. On the top ribbon (or menu bar on Mac), left click Analysis and select Create Calculated Field. 11. Name calculated field Gross Profit. 12. In the calculated field, type [Sales]-[Cost of Goods Sold] and left-click OK. 13. On the top ribbon (or menu bar on Mac), left-click Analysis and select Create Calculated Field. 14. Name calculated field Gross Profit Ratio. 15. In the calculated field, type SUM([Gross Profit])/SUM([Sales]) and left-click OK. 16. Left-click Gross Profit Ratio and drag it from left-hand side Tables pane to the Rows shelf. This creates a bar graph of gross profit ratio. 17. Left-click and hold Gross Profit Ratio and drag it from left-hand side Tables pane to the Label card (located under Marks near middle of screen). This adds a label to the display. Pause and complete Requirement 1. 18. Double-left click Gross Profit Ratio at top of worksheet. Change title of worksheet to Gross Profit Ratio by Job; then left-click OK. 7. On the top ribbon (or menu bar on Mac), left-click Analysis and select Create Calculated Field. 8. Name calculated field Cost of Goods Sold. 9. In the calculated field, type [Direct Materials Cost]+[Direct Labor Cost]+[Applied Overhead] and left-click OK. 10. On the top ribbon (or menu bar on Mac), left click Analysis and select Create Calculated Field. 11. Name calculated field Gross Profit. 12. In the calculated field, type [Sales]-[Cost of Goods Sold] and left-click OK. 13. On the top ribbon (or menu bar on Mac), left-click Analysis and select Create Calculated Field. 14. Name calculated field Gross Profit Ratio. 15. In the calculated field, type SUM([Gross Profit])/SUM([Sales]) and left-click OK. 16. Left-click Gross Profit Ratio and drag it from left-hand side Tables pane to the Rows shelf. This creates a bar graph of gross profit ratio. 17. Left-click and hold Gross Profit Ratio and drag it from left-hand side Tables pane to the Label card (located under Marks near middle of screen). This adds a label to the display. Pause and complete Requirement 1. 18. Double-left click Gross Profit Ratio at top of worksheet. Change title of worksheet to Gross Profit Ratio by Job; then left-click OK. 19. Left-click and hold Job and drag it from left-hand side Tables pane to the Columns shelf (on the upper right). This creates a bar graph of gross profit ratio by job. 20. Sort jobs in descending order of gross profit by selecting sort descending from top ribbon (or menu bar on Mac). Pause and complete Requirement 2. 21. Right-click (or Control-Click on Mac) Sheet 1 on the bottom ribbon and select Duplicate. 22. Double-left click Gross Profit Ratio by Job at top of worksheet. Change title of worksheet to Gross Profit Ratio by Work Shift; then left-click OK. 23. Right-click (or Control-Click on Mac) Job in the Columns pane and click Remove. 24. Left-click and hold Work Shift and drag from left-hand side Tables pane to the Columns shelf (on the upper right). Pause and complete Requirement 3. Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Determine the gross profit ratio. (Round your answer to 2 decimals.) Gross profit ratio % Required 3B Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Required 3B Determine gross profit ratio by job. (Round your answers to 2 decimals.) Job Number Gross Profit Ratio B20 % % % B21 B22 B23 B24 B25 B26 B27 B28 B29 % % % % % % % Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 2A Required 2B Required 3A Required 3B Determine gross profit ratio by work shift. (Round your answers to 2 decimals.) Gross Profit Ratio % % Work Shift Day Night Job B20 B21 B22 B23 B24 B25 B26 B27 D B28 1 B29 2 Work Shift Day Day Day Day Day Night Night Night Night Night Direct Materials Cost $680 $540 $360 $510 $790 $530 $510 $380 $590 $500 Direct Labor Cost $800 $640 $640 $920 $1,120 $200 $960 $1,240 $1,040 $600 Applied Overhead $1,280 $1,024 $1,024 $1,472 $1,792 $320 $1,536 $1,984 $1,664 $960 Sales $3,378 $2,805 $3,086 $3,607 $6,638 $1,839 $3,352 $2,903 $4,887 $2,540
Expert Answer:
Answer rating: 100% (QA)
Here are the stepbystep workings 1 Gross Profit Ratio Create Cost of G... 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
-
Earlyrain Inc.'s 2023 income statement, excluding the earnings per share portion of the statement, was as follows: Revenues Expenses: Depreciation Income taxes Other expenses Profit from continuing...
-
A small consulting company wants to make the switch to QuickBooks Online. All of their expenses are paid at the time they are incurred, so there is no need to track bills in the system. There is only...
-
In the Chapter 3 Data Analytics Case, you applied Tableau to examine a data set and create calculations to compare two companies profitability. For the case in this chapter, you continue in your role...
-
In Exercises 912, use the given conditions to write an equation for each line in point-slope form and general form Passing through (4, -7) and perpendicular to the line whose equation is x - 2y - 3 =...
-
A study of attempted suicide methods was published in the journal Death Studies (Vol. 38, 2014). Data for 59 suicide victims who had previously attempted suicide were collected. The table gives a...
-
Failure to meet price standards is the responsibility of the purchasing officer. Do you agree? Explain.
-
What is the relationship between women's rights and wealth?
-
Do you think the GAO was the best choice for an audit team? Would it have the trust of the project personnel? MINI CASE It was July 2004. John West and Joy Adams had been through a lot since the...
-
Units produced 18,100 3,620 Direct materials cost per unit $ 7 Machine-hours per unit Production runs per quarter 4 144 $ 19 7 72 Production at the plant is automated and any labor cost is included...
-
Goldie and Kurt want advice from your financial advising firm. They have provided the following information. They graduated from university four years ago and they have good jobs, but neither of them...
-
Find the SQL code for the following business question. To help with anticipating the amount needed per employee for the cost of living stipends for those living in other countries, the HR department...
-
Prepare Schedules M-1 and K-1 (for Blake Turin only) for tax year 2019. See attached set of facts and blank tax forms. Please download the tax forms, prepare them manually, then scan and submit the...
-
Ross Stores Advanced Dupont Model 1999 2000 2001 2002 2003 Net Operating Margin 0.061 0.057 0.053 0.057 0.058 Net Operating Asset Turnover 5.391 5.551 5.824 5.321 Return on Net Operating Assets...
-
NoDelay Delivery Corporation included the following disclosure note in an annual report: Stock-Based Compensation (in part) . . .Restricted shares of our common stock are awarded to key employees....
-
Dugway Company's net income for the year was $30,000. During the year, Dugway declared and paid $3,000 in cash dividends on preferred stock and $5,250 in cash dividends on common stock. At December...
-
Brianna's Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Brianna's Boutique uses a periodic inventory system. Date October 1 October 4...
-
Semantic Analysis and SDD a. Given the Syntax-Directed Definition below with the synthesized attribute val. draw the annotated parse tree for the expression (3+4)* (5+6). (Marks 5) Given the...
-
The Heese Restaurant Group manufactures the bags of frozen French fries used at its franchised restaurants. Last week, Heeses purchased and used 101,000 pounds of potatoes at a price of $ 0.70 per...
-
Distinguish between the direct method and the indirect method for reporting the results of operating activities in the statement of cash flows.
-
Ahnberg Corporation had 800,000 shares of common stock issued and outstanding at January 1. No common shares were issued during the year, but on January 1 Ahnberg issued 100,000 shares of convertible...
-
The balance sheet of Consolidated Paper, Inc., included the following shareholders equity accounts at December 31, 2020: During 2021, several events and transactions affected the retained earnings of...
-
What are the elements of a master budget?
-
How would the budget-setting philosophy of a service provider differ from that of a manufacturing business?
-
What are the advantages and disadvantages of a bottom-up approach to budgeting?
Study smarter with the SolutionInn App