View the step-by-step solution to:

uestion: Hello, I am at a completely loss as to what to do for Part V of the assignment Analytics Mindset case studies techwear - can someone help

uestion:Hello,

I am at a completely loss as to what to do for Part V of the assignment Analytics Mindset case studies techwear - can someone help with this?I

It has to do with the following questions:


Required:

1. Make a December 31, 2016, runoff analysis as of May 31, 2017 (demonstrating how the December 31, 2016, balance has "run off," meaning explain what happened to the beginning balance to get to the ending balance, between January 1 and May 31, 2017). Display this at the customer level with the ability to drill down to the transaction (invoice) level.


Document your findings by completing the following table:


Adjusted accounts receivable as of December 31, 2016 $15,118,973.57

Runoff:

Net returns

Net bad debt write-offs

Net cash receipts

Remaining accounts receivable as of May 31, 2017


2.Calculate the 2017 cash receipts on the December 31, 2016, balance by month and provide a

visualization of the trend.


3. Determine what amount of the December 31, 2016, accounts receivable balance you believe is collectible. Include your audit findings and audit adjustments (continue using the previous summary of audit findings document from question #1), which you will present in class. It should be succinct, requiring no more than 10 minutes to present. Continue to use the previous template to present your audit adjustments for the accounts receivable balance, only as provided below (note that you can add or delete items from the table below if you have more/fewer findings and adjustments than listed). Also, use the visualizations that you have prepared to support your presentation.


Summary of audit findings


Accounts receivable As of December 31, 2016 $18,114,802.50

Audit finding/adjustment

Audit finding/adjustment

Audit finding/adjustment

Audit-adjusted balance as of December 31, 2016

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question