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-c9a444.xisx 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? 2. What is the total of Madrid's past-due invoices? 2 What ic the avrorano amnunt af all inveirec iccried in Anril? 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? 2. What is the total of Madrid's past-due invoices? 3. What is the average amount of all invoices issued in April? 4. How many unpaid invoices does Orlando Company in June, July, and August combined? 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. 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-c9a444.xisx 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? 2. What is the total of Madrid's past-due invoices? 2 What ic the avrorano amnunt af all inveirec iccried in Anril? 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? 2. What is the total of Madrid's past-due invoices? 3. What is the average amount of all invoices issued in April? 4. How many unpaid invoices does Orlando Company in June, July, and August combined? 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
