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-0671a2.xlsx

https://docs.google.com/spreadsheets/d/1EKh2fAWLVMDoyF2crdrkEevyfVms-hb7esxXxz6B648/edit?usp=sharing

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

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: X Download spreadsheet CaseAccountsReceivableData-0671a2.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? x 2. What is the total of Madrid's past-due invoices? x 3. What is the average amount of all invoices issued in April? X 4. How many unpaid invoices does Orlando Company in June, July, and August combined? X 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: X Download spreadsheet CaseAccountsReceivableData-0671a2.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? x 2. What is the total of Madrid's past-due invoices? x 3. What is the average amount of all invoices issued in April? X 4. How many unpaid invoices does Orlando Company in June, July, and August combined? X