Accounts Receivable Data

Completing this activity will help you learn to:

$1.$ use Excel to determine sales by date, by product, by invoice, by customer, or a combination thereof.

$2.$ explain what can be accomplished when analyzing data.

Case Scenario: You are working at a startup that sells university merchandise online.

The business sells wholesale to six customers: Atlanta, Dakota, Madrid, Orlando, Phoenix, and Venice companies.

It is December $31,$ and you must analyze sales on account from this past year. Accounts receivable data is captured in the attached excel file.

Required:

Download spreadsheet CaseAccountsReceivableData$-$d$838$b$8.$xlsx

Analyze the accounts receivable data in the spreadsheet and enter the answers to the questions for a grade.

HINT: STEP$-$BY$-$STEP WALKTHROUGH

$1.$ How much did Phoenix Company pay on account during the year?

fill in the blank $1$ of $1$

$2.$ What is the total of Madrid's past$-$due invoices?

fill in the blank $1$ of $1$

$3.$ What is the average amount of all invoices issued in April?

fill in the blank $1$ of $1$

$4.$ How many unpaid invoices does Orlando Company in June, July, and August combined?

fill in the blank $1$ of $1$

$5.$ Explain what can be accomplished by analyzing this aging data.

The input in the box below will not be graded, but may be reviewed and considered by your instructor.