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 =...
-
Three savings and loan institutions (S&Ls) have identical balance sheet compositions: a high concentration of short-term deposits that are used to provide long-term, fixed-rate mortgages. The S&Ls...
-
What is the angle in radians that the Earth sweeps out in its orbit during winter?
-
Top managers of Chase Financial Services are reviewing company per- formance for 2009. The income statement reports a 20% increase in net income over 2008. However, most of the net-income increase...
-
Company A uses the FIFO method to cost inventory, and Company B uses the LIFO method. The two companies are exactly alike except for the difference in inventory costing methods. Costs of inventory...
-
Choice Bank's stock portfolio has a market value of $500 million. The beta of the portfolio approximates the market portfolio, whose standard deviation (s m ) has been estimated at 2.25 per cent....
-
A convenience store is considering changing its layout to encourage impulse buying. The triangular flow matrix below gives the measure of association between different product groups ( e. g., beer,...
-
Surveys involving the most senior levels in organizations indicate that nearly _____ select forward-looking as a requisite leadership quality, while this percentage drops to _____ among people in...
-
ABC constructioneering company is a mid-sized civil engineering company with a focus on residential and commercial construction projects. They have a strong commitment to safety and sustainability...
-
A mouse is chased by a cat running in a straight line toward a hole in the wall at a speed of 4 . 0 m / s . The wall is at 6 m from the mouse. The cat is 4 m behind the mouse and running at 6 . 0 m /...
-
Compound and Continuous Compound Interest 1-Use compound interest formula (1) to find each or the indicated values. P=$5,000;i=0.005;n=36;A=?
-
In the local community hub where you work as a community service worker, your organization also provides a FV crisis service. Mandy says her husband married her because she comes from a wealthy...
-
How do trophic interactions and energy flow regulate the biodiversity and functioning of ecosystems ? Explain
-
What are the accounts included and how do I solve for cash and cash equivalent? The following pertains to Luffy Corporation on December 31, 2020: Currency and coins in a petty cash fund (the company...
-
Prove the following D,(cos x) = - sin x (Hint: Apply the identity cos(A + B) = cos A cos B sin A sin B)
-
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...
-
Show that the period of free vibration of a load weighing \(W\) suspended from two parallel springs, as shown in Figure 2.59, is given by \(T\), \[ T=2 \pi \sqrt{\frac{W}{g\left(k_{1}+k_{2} ight)}}...
-
Derive Equation 2.30, \[ x(t)=B_{1} \cos \omega_{n} t+B_{2} \sin \omega_{n} t \] beginning with the equation of motion.
-
For a body suspended between two springs as in Figure 2.60, show that the period of oscillation is \[ T=2 \pi \sqrt{\frac{W}{g\left(k_{1}+k_{2} ight)}} \] ellel k W ellel k Figure 2.60: Body...
Study smarter with the SolutionInn App