Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can an actual expert help me answer this problem please and thank you. Borders USA is a retailer selling office-related supplies, furniture, and equipment. They

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Can an actual expert help me answer this problem please and thank you.

Borders USA is a retailer selling office-related supplies, furniture, and equipment. They have three sales channels: storefronts, an ordering website (business-to-consumer), and business-to-business (B2B) ordering. Purchases from storefront locations are paid immediately using cash or credit cards and customers receive their purchase immediately. Purchases from website orders are paid immediately using credit cards and their orders are delivered by mail. B2B orders are invoiced once the order is shipped. Borders USA recognizes revenue when the order has been delivered to the customer. You are an accountant at Borders USA and you have been asked to prepare metrics on sales, revenue, and accounts receivables. You extract the sales order data and accounts receivable data from the ERP system and create the following visualizations: 1) Sales vs Revenue by Quarter in 2022 - This is a clustered bar chart showing sales totals and revenue totals by quarter. Hint: Revenue is recognized if the order has been delivered to the customer. 2) Sales Total vs Sales Counts by Channel in 2022 - This is a clustered bar chart showing the quarterly sales totals by sales channels as a bar chart and the quarterly sales order counts as a line chart. 3) Accounts Receivable Aging as of December 31, 2022 - This is a bar chart showing the totals of outstanding accounts receivables that have not been paid. The age of the accounts receivable is based on the number of days between the delivery date and December 31,2022 . The amounts are grouped by 31 to 60 days, 61 to 90 days, and greater than 90 days. The outstanding accounts receivable amount is based on the sales total amount. The invoice date is the same as the delivery date. 4) Sales Order Aging as of December 31, 2022 - This is a bar chart showing the value of sales orders that have not been delivered. The age of outstanding sales orders is based on the number of days between the sales order date and December 31,2022 . The amounts are grouped by 31 to 60 days, 61 to 90 days, and greater than 90 days. 5) Top 5 Customers by Accounts Receivable Amount Due - This is a stacked bar chart showing the top 5 customers that have the highest value of outstanding accounts receivables. The total values of outstanding accounts receivables are stacked by the age grouping. 6) Top 5 Customers by Outstanding Sales Order Amount - This is a stacked bar chart showing the top 5 customers that have the highest value of outstanding sales orders. The total values of outstanding sales orders are stacked by the age grouping. 4. Based on the results of the Sales Order Aging os of December 31,2022 visualization, what conclusion can be made regarding the outstanding sales orders? a. The sales aging group with the highest value of outstanding sales orders is 90+ days and the sales aging group with the lowest value of outstanding sales orders is 3160 days. b. The 90+ days sales aging group had a value of outstanding sales orders that was twice as much as the 3160 days sales aging group. c. The 61-90 days sales aging group had a value of outstanding sales orders that was twice as much as the 3160 days sales aging group. d. The sales aging group with the highest value of outstanding sales orders is 90+ days and the sales aging group with the lowest value of outstanding sales orders is 6190 days. 5. Using the results of the Top 5 Customers by Accounts Receivable Amount Due and the Top 5 Customers by Outstanding Sales Order Amount visualization, what conclusion can be made regarding the outstanding sales orders? a. The high value of outstanding accounts receivable for Sanders Corp may be directly related to their high value of outstanding sales orders. b. The high value of outstanding accounts receivable for Williams Corp may be directly related to their high value of outstanding sales orders. c. The high value of outstanding sales orders for Roberts Corp has caused them not to pay a large value of invoices. d. Evans Corp has a high value of outstanding accounts receivable and outstanding sales orders

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Principles And Techniques

Authors: Sanjib Kumar Basu, Andrei Alexandrescu

1st Edition

8177581783, 9788177581782

More Books

Students also viewed these Accounting questions

Question

8. Explain the relationship between communication and context.

Answered: 1 week ago

Question

d. How were you expected to contribute to family life?

Answered: 1 week ago