Question: Tableau Dashboard Activity 8 - 1 ( Static ) Evaluating Receivables Management in a Tableau Dashboard [ LO 8 - 2 , 8 - 4

Tableau Dashboard Activity 8-1(Static) Evaluating Receivables Management in a Tableau Dashboard [LO 8-2,8-4]
Rare Finds is a national distributor of unusual crafts and home dcor items. It sells merchandise to gift shops and specialty retailers in over twenty states. Management uses interactive maps, like the one below, to analyze the collection of the companys receivables. The map represents more profitable customers with larger dots, and represents average days to collect by color. Green dots represent shorter collection times and red dots represent longer collection times.
Required:
1. According to the map, the average days to collect ranges from 23.83 to 53.88. Which location has the shortest average days to collect? Which location has the longest average days to collect? Is a lower or a higher number of days to collect better for Rare Finds?
2. Customers in Jacksonville, FL have an average number of days to collect of 36.5. Using this rate of collection, calculate the receivables turnover ratio for these customers. If the industry average receivables turnover is 9.5, do customers in Jacksonville, FL pay faster or slower than the industry average?
3. According to the map, does there seem to be a relationship between customer profitability and average days to collect?
4. If the entire receivable balance in Minneapolis, MN is attributable to one company, and management decides to write off the receivable balance because it is judged uncollectible, what effect will the write-off have on Rare Finds Total Assets? On its Net Income?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f