Required information [The following information applies to the questions displayed below.] Required: 1. Create a calculated field to calculate the Days Past Due for each invoice. 2. Summarize the accounts receivable by customer. 3. Get the detailed receivables for the customer "Taste of Thai". Ask the Question: How can we use Tableau on the total detailed late accounts receivables balance to get specific detail on invoices due by customer? Master the Data: To begin, we have a list of 200 receivables that are all past their due date as of today's date of 12/31/2021. This is shown in the Excel file Lab 2-2 Data.xlsx, which will be imported into Tableau. Software needed ⚫ Tableau • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 2-2 Alt Data.xlsx. Perform the Analysis: Refer to Lab 2-2 Alternative in the text for instructions and Lab 2-2 steps for each of the lab parts. Share the Story: Required: 1. What is the grand total amount owed in past due invoices for Brewed Miracles? O 4,805 O 5,078 O 1,393 187 2. How many days late is Grandma's Greasy Spoon's oldest invoice (most days past due)? O 159 O 720 O 419 84 3. How many invoices does Pita Pan have past due? O4 O 10 18 05 4. Which customer has the highest balance past due? O Planet of the Grapes O One in a Million O Pita Pan O Grandma's Greasy Spoon 5. Which customer owes $5,156? O Thai Tap O The Godfather O We Fry it All O Tequila Taste
Required information [The following information applies to the questions displayed below.] Required: 1. Create a calculated field to calculate the Days Past Due for each invoice. 2. Summarize the accounts receivable by customer. 3. Get the detailed receivables for the customer "Taste of Thai". Ask the Question: How can we use Tableau on the total detailed late accounts receivables balance to get specific detail on invoices due by customer? Master the Data: To begin, we have a list of 200 receivables that are all past their due date as of today's date of 12/31/2021. This is shown in the Excel file Lab 2-2 Data.xlsx, which will be imported into Tableau. Software needed ⚫ Tableau • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 2-2 Alt Data.xlsx. Perform the Analysis: Refer to Lab 2-2 Alternative in the text for instructions and Lab 2-2 steps for each of the lab parts. Share the Story: Required: 1. What is the grand total amount owed in past due invoices for Brewed Miracles? O 4,805 O 5,078 O 1,393 187 2. How many days late is Grandma's Greasy Spoon's oldest invoice (most days past due)? O 159 O 720 O 419 84 3. How many invoices does Pita Pan have past due? O4 O 10 18 05 4. Which customer has the highest balance past due? O Planet of the Grapes O One in a Million O Pita Pan O Grandma's Greasy Spoon 5. Which customer owes $5,156? O Thai Tap O The Godfather O We Fry it All O Tequila Taste
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
![Required information
[The following information applies to the questions displayed below.]
Required:
1. Create a calculated field to calculate the Days Past Due for each invoice.
2. Summarize the accounts receivable by customer.
3. Get the detailed receivables for the customer "Taste of Thai".
Ask the Question: How can we use Tableau on the total detailed late accounts receivables balance to get specific detail
on invoices due by customer?
Master the Data: To begin, we have a list of 200 receivables that are all past their due date as of today's date of
12/31/2021. This is shown in the Excel file Lab 2-2 Data.xlsx, which will be imported into Tableau.
Software needed
⚫ Tableau
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)
Data: Excel File Lab 2-2 Alt Data.xlsx.
Perform the Analysis: Refer to Lab 2-2 Alternative in the text for instructions and Lab 2-2 steps for each of the lab parts.
Share the Story:
Required:
1. What is the grand total amount owed in past due invoices for Brewed Miracles?
O 4,805
O 5,078
O 1,393
187
2. How many days late is Grandma's Greasy Spoon's oldest invoice (most days past due)?
O 159
O 720
O 419
84
3. How many invoices does Pita Pan have past due?
O4
O 10
18
05
4. Which customer has the highest balance past due?
O Planet of the Grapes
O One in a Million
O Pita Pan
O Grandma's Greasy Spoon
5. Which customer owes $5,156?
O Thai Tap
O The Godfather
O We Fry it All
O Tequila Taste](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4d59dd3b-adc3-4792-8cac-becbb61a2038%2F5bcae543-cd6d-4ba7-a6c1-a71e6e05fd7a%2Fvlj5166_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Required information
[The following information applies to the questions displayed below.]
Required:
1. Create a calculated field to calculate the Days Past Due for each invoice.
2. Summarize the accounts receivable by customer.
3. Get the detailed receivables for the customer "Taste of Thai".
Ask the Question: How can we use Tableau on the total detailed late accounts receivables balance to get specific detail
on invoices due by customer?
Master the Data: To begin, we have a list of 200 receivables that are all past their due date as of today's date of
12/31/2021. This is shown in the Excel file Lab 2-2 Data.xlsx, which will be imported into Tableau.
Software needed
⚫ Tableau
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)
Data: Excel File Lab 2-2 Alt Data.xlsx.
Perform the Analysis: Refer to Lab 2-2 Alternative in the text for instructions and Lab 2-2 steps for each of the lab parts.
Share the Story:
Required:
1. What is the grand total amount owed in past due invoices for Brewed Miracles?
O 4,805
O 5,078
O 1,393
187
2. How many days late is Grandma's Greasy Spoon's oldest invoice (most days past due)?
O 159
O 720
O 419
84
3. How many invoices does Pita Pan have past due?
O4
O 10
18
05
4. Which customer has the highest balance past due?
O Planet of the Grapes
O One in a Million
O Pita Pan
O Grandma's Greasy Spoon
5. Which customer owes $5,156?
O Thai Tap
O The Godfather
O We Fry it All
O Tequila Taste
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education