In this lab, you will: Required: 1. Create the Days Past Due measure. 2. Create the 30-day bins based on the Days Past Due Measure. 3. Detail the receivables from the 151–180 days bucket. Ask the Question: How can we age receivables using Excel pivottables? Master the Data: Apply the same steps as Lab 6-2 in Tableau, this time using the Lab 6-2 Alt Data.xlsx dataset.

 In this lab, you will:

Required:

1. Create the Days Past Due measure.

2. Create the 30-day bins based on the Days Past Due Measure.

3. Detail the receivables from the 151–180 days bucket.

 

Ask the Question: How can we age receivables using Excel pivottables?

 

Master the Data: Apply the same steps as Lab 6-2 in Tableau, this time using the Lab 6-2 Alt Data.xlsx dataset.

 

Software needed

    Tableau
    Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

 
Data: Lab 6-2 Alt Data.xlsx.


Perform the Analysis: Refer to Lab 6-2 Alternate in the text for instructions and Lab 6-2 steps for each the of lab parts.


Share the Story: Now that you have aged the receivables, the company is better able to estimate its allowance for doubtful accounts (the contra receivable accounts that reduces gross accounts receivable into net accounts receivable). As a rule, as accounts receivable age, they are less likely to be collected.

 
Required:

1. What is the total amount One in a Million has due in the 31-60 day bin?

    2000.86
    1523.00
    406.68
    1952.30 

Answer

1952.30

2. In the 31-60 day bin, One in a Million has an invoice that was due on 11/3/2021.  How much was it for?

    487.24
    406.68
    108.87
    684.50 

Answer

 406.68

3. How many open invoices does One in a Million have in the 31-60 day bin?

    5
    2
    3
    4
Answer

5

4. How many invoices are due in the 61-90 bin? (Hint, view the Full Data to see a count of rows)

    37
    47
    40
    1

 Answer

37

5. Which bin has the lowest amount due?

    31-60
    1-30
    91-120
    151-180
    61-90
    121-150
Answer

121-150