Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Might have to zoom in on your screen to see. begin{tabular}{|l|l|l|} hline multicolumn{1}{|c|}{ Question } hline 1. If Home Depot has an invoice due
Might have to zoom in on your screen to see.
\begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Question } \\ \hline 1. If Home Depot has an invoice due date of 12/2/2021 and today's date is 12/31/2021, what is the number of days past due? & \\ \hline 2. What is the total receivables due in the 130 day A/R aging bucket? Round to 2 decimal places. \\ \hline 3. What is the gross (or total) amount of accounts receivable for this dataset? Round to 2 decimal places. \\ \hline 4. In the detailed 151-180 A/R aging bucket, what is the amount owed by Coca-Cola? Round to 2 decimal places. \\ \hline 5. In the detailed 1-30 A/R aging bucket, what is the amount owed by Canon? Round to 2 decimal places. \\ \hline \end{tabular} Question 1. What is the gross amount of receivables owed? Round to two decimal places. 2. What is the total receivables due in the 61-90 A/R aging bucket? Round to two decimal places. 3. What is the total receivables due in the 121150A/R aging bucket? Round to two decimal places. 4. How many unpaid invoices are listed in the 151180A/R aging bucket? 5. What is the amount of the largest individual invoice in the 1-30 A/R aging bucket? Round to two decimal places. 1. If you wanted to adjust the charts to count the number of unpaid invoices in each aging bucket, for each company, what would you do? 2. If you wanted to adjust the charts to sum the total amount of unpaid invoices in each aging bucket, for each company, what would you do? \begin{tabular}{|lrr|} \hline Customer & Invoice Amount & Due Date \\ \hline Home Depot & 377.6 & 12/2/25 \\ \hline Porsche & 1259.97 & 9/28/25 \\ \hline Burberry & 1476.09 & 8/14/25 \\ \hline AT\&T & 331.8 & 11/24/25 \\ \hline Porsche & 1122.46 & 9/5/25 \\ \hline Porsche & 838.18 & 10/3/25 \\ \hline Beko & 387.23 & 9/6/25 \\ \hline BMW & 1389.2 & 9/10/25 \\ \hline United Parcel Service & 685.1 & 10/31/25 \\ \hline Deere \& Company & 1424.71 & 9/27/25 \\ \hline Beko & 772.14 & 12/8/25 \\ \hline Citigroup & 981.87 & 12/14/25 \\ \hline Samsung Group & 957.07 & 11/29/25 \\ \hline General Electric & 694.29 & 11/15/25 \\ \hline Nokia & 279.42 & 8/21/25 \\ \hline Citigroup & 994.35 & 10/30/25 \\ \hline Xerox & 230.98 & 10/16/25 \\ \hline Starbucks & 415.15 .55 & 8/30/25 \\ \hline Coca-Cola & 419.86 & 10/8/25 \\ \hline SM & 1249.67 & 7/27/25 \\ \hline Intel Corporation & 1469.06 & 11/4/25 \\ \hline Nintendo & 541.26 & 9/6/25 \\ \hline Porsche & 1427.79 & 11/22/25 \\ \hline The Walt Disney & & \\ \hline Company & 893.4 & 9/8/25 \\ \hline KFC & 1093.72 & 10/8/25 \\ \hline MTV & 1031.88 & 11/15/25 \\ \hline Vodafone & 654.88 & 9/6/25 \\ \hline Harley-Davidson & 289.16 & 8/2/25 \\ \hline Moet et Chandon & 392.53 & 8/17/25 \\ \hline Canon & 1447.32 & 12/22/25 \\ \hline Yahoo! & 899.53 & 8/17/25 \\ \hline Avon & 717.65 & 10/12/25 \\ \hline Gap Inc. & 1385.16 & 11/18/25 \\ \hline VISA & 723.94 & 10/10/25 \\ \hline Honda Motor Company & 8/12/25 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline \multicolumn{1}{|c|}{ Question } \\ \hline 1. If Home Depot has an invoice due date of 12/2/2021 and today's date is 12/31/2021, what is the number of days past due? & \\ \hline 2. What is the total receivables due in the 130 day A/R aging bucket? Round to 2 decimal places. \\ \hline 3. What is the gross (or total) amount of accounts receivable for this dataset? Round to 2 decimal places. \\ \hline 4. In the detailed 151-180 A/R aging bucket, what is the amount owed by Coca-Cola? Round to 2 decimal places. \\ \hline 5. In the detailed 1-30 A/R aging bucket, what is the amount owed by Canon? Round to 2 decimal places. \\ \hline \end{tabular} Question 1. What is the gross amount of receivables owed? Round to two decimal places. 2. What is the total receivables due in the 61-90 A/R aging bucket? Round to two decimal places. 3. What is the total receivables due in the 121150A/R aging bucket? Round to two decimal places. 4. How many unpaid invoices are listed in the 151180A/R aging bucket? 5. What is the amount of the largest individual invoice in the 1-30 A/R aging bucket? Round to two decimal places. 1. If you wanted to adjust the charts to count the number of unpaid invoices in each aging bucket, for each company, what would you do? 2. If you wanted to adjust the charts to sum the total amount of unpaid invoices in each aging bucket, for each company, what would you do? \begin{tabular}{|lrr|} \hline Customer & Invoice Amount & Due Date \\ \hline Home Depot & 377.6 & 12/2/25 \\ \hline Porsche & 1259.97 & 9/28/25 \\ \hline Burberry & 1476.09 & 8/14/25 \\ \hline AT\&T & 331.8 & 11/24/25 \\ \hline Porsche & 1122.46 & 9/5/25 \\ \hline Porsche & 838.18 & 10/3/25 \\ \hline Beko & 387.23 & 9/6/25 \\ \hline BMW & 1389.2 & 9/10/25 \\ \hline United Parcel Service & 685.1 & 10/31/25 \\ \hline Deere \& Company & 1424.71 & 9/27/25 \\ \hline Beko & 772.14 & 12/8/25 \\ \hline Citigroup & 981.87 & 12/14/25 \\ \hline Samsung Group & 957.07 & 11/29/25 \\ \hline General Electric & 694.29 & 11/15/25 \\ \hline Nokia & 279.42 & 8/21/25 \\ \hline Citigroup & 994.35 & 10/30/25 \\ \hline Xerox & 230.98 & 10/16/25 \\ \hline Starbucks & 415.15 .55 & 8/30/25 \\ \hline Coca-Cola & 419.86 & 10/8/25 \\ \hline SM & 1249.67 & 7/27/25 \\ \hline Intel Corporation & 1469.06 & 11/4/25 \\ \hline Nintendo & 541.26 & 9/6/25 \\ \hline Porsche & 1427.79 & 11/22/25 \\ \hline The Walt Disney & & \\ \hline Company & 893.4 & 9/8/25 \\ \hline KFC & 1093.72 & 10/8/25 \\ \hline MTV & 1031.88 & 11/15/25 \\ \hline Vodafone & 654.88 & 9/6/25 \\ \hline Harley-Davidson & 289.16 & 8/2/25 \\ \hline Moet et Chandon & 392.53 & 8/17/25 \\ \hline Canon & 1447.32 & 12/22/25 \\ \hline Yahoo! & 899.53 & 8/17/25 \\ \hline Avon & 717.65 & 10/12/25 \\ \hline Gap Inc. & 1385.16 & 11/18/25 \\ \hline VISA & 723.94 & 10/10/25 \\ \hline Honda Motor Company & 8/12/25 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started