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
Century 21 Accounting General Journal
11th Edition
ISBN:9781337680059
Author:Gilbertson
Publisher:Gilbertson
Chapter2: Analyzing Transactions Into Debit And Credit Parts
Section: Chapter Questions
Problem 1CP
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
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage