The manager asks you to assist her with the data analytics on bad debts expense at...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The manager asks you to assist her with the data analytics on bad debts expense at year-end. To do this, you access the following Tableau Dashboard for your company. Cash 1 Over 90 days past due 61-90 days past due 31-60 days past due 1-30 days past due Not yet due SO Makeup of Current Assets Accounts Receivable Inventory Accounts Receivable by Age $200,000 $400,000 Accounts Receivable (5) $600,000 Supplies $800,000 o Estimated Percent Uncollectible 70% 60% 50% 40% 30% Percent Uncollectible by Age 20% 10% 0% Not yet due tableau 1-30 days past due 31-60 days past due 61-90 days Over 90 days past due past due Makeup of Total Sales Credit Sales Cash Sales Percent Uncollectible by Accounts Credit Sales Accounts Receivable 19 598 1. Identify the amount of credit sales. 2. Identify the amount of accounts receivable. 3. Estimate the balance of the Allowance for Doubtful Accounts using the percent of accounts receivable method. Hint Identify the percent of uncollectible for accounts receivable. The manager asks you to assist her with the data analytics on bad debts expense at year-end. To do this, you access the following Tableau Dashboard for your company. Cash 1 Over 90 days past due 61-90 days past due 31-60 days past due 1-30 days past due Not yet due SO Makeup of Current Assets Accounts Receivable Inventory Accounts Receivable by Age $200,000 $400,000 Accounts Receivable (5) $600,000 Supplies $800,000 o Estimated Percent Uncollectible 70% 60% 50% 40% 30% Percent Uncollectible by Age 20% 10% 0% Not yet due tableau 1-30 days past due 31-60 days past due 61-90 days Over 90 days past due past due Makeup of Total Sales Credit Sales Cash Sales Percent Uncollectible by Accounts Credit Sales Accounts Receivable 19 598 1. Identify the amount of credit sales. 2. Identify the amount of accounts receivable. 3. Estimate the balance of the Allowance for Doubtful Accounts using the percent of accounts receivable method. Hint Identify the percent of uncollectible for accounts receivable.
Expert Answer:
Related Book For
Ethics in Accounting A Decision Making Approach
ISBN: 978-1118928332
1st edition
Authors: Gordon Klein
Posted Date:
Students also viewed these accounting questions
-
The mechanical components division manager asks you to recommend a make/buy decision on a major automotive subassembly that is currently purchased externally for a total of $3.9 million this year....
-
The deputy county manager asks you to create a simple table showing the total cost allocation to each department using the three models you have developed. Prepare a one-page memo to the deputy...
-
A fixed income portfolio manager asks you to analyze a 6-year AA-rated corporate bond with a 5% coupon rate that is trading for $1,025.92. According to Bloomberg, the bond\'s yield to maturity (YTM)...
-
East Corp is a mature company and expects its sales and operating costs to be fixed (or unchanged) in perpetuity. It has sales of $524,000 and operating costs of $272,480. The firm has a tax rate of...
-
Your audit client, Madison, Inc., has a computerized accounts receivable system. There are two master files, a customer data file and an unpaid invoice file. The customer data file contains the...
-
Steam at 320C flows in a stainless steel pipe (k = 15 W/m K) whose inner and outer diameters are 5 cm and 5.5 cm, respectively. The pipe is covered with 3-cm-thick glass wool insulation (k = 0.038...
-
It is proposed that the vibration of the foundation of an internal combustion engine be measured over the speed range \(500 \mathrm{rpm}\) to \(1500 \mathrm{rpm}\) using a vibrometer. The vibration...
-
The Bawl Corporation supplies alloy ball bearings to auto manufacturers In Detroit. Because of its specialized manufacturing process, considerable work-in -process and raw materials are needed. The...
-
The picture shows six different situations of a box with one or two horizontal forces applied. The mass of each box is given, and the strength of each force is specified in terms of F. In each case...
-
Traditionally firms raise capital in the primary market issuing either fixed or floating rate debt. Both bond structures expose the firm to interest rate risk. The financial derivatives market...
-
Purchasing a NEW MACHINE - to be used in the business - for $300,000 -to be paid for over next 10 years in equal installments of $30,000, annually, interest free! - causes calculate what effects at...
-
"Managing Away Bad Habits Team Assignment Organizational Behavior IILeadership Assigned is ashort case from the exercise Managing Away Bad Habits. The task is to develop a turnaround strategy for...
-
A 45-year-old man presents to the Emergency Department with a fever, widespread rash, and confusion. His only past history of note was Sydenham's chorea and a number of recent dental extractions....
-
In a jurisdiction where assisted suicide is illegal, a terminally ill patient with no chance of recovery seeks assistance in ending their life. What legal and ethical considerations come into play,...
-
A multinational corporation is accused of environmental pollution and human rights violations in a foreign country where it operates. What legal challenges arise in holding the corporation...
-
Polly Woodsides is planning to invest her savings of $100,000 into three stocks: ABC, PQR, and XYZ. For each dollar invested, she can expect to get 4%, 6.5%, and 7.5%, respectively. Her investment...
-
The area of square PQRS is 100 ft2, and A, B, C, and D are the midpoints of the sides. Find the area of square ABCD. B A
-
Ryan and Kim are married and commute to and from work together each day. Ryan, a CPA, works in the Project Budgeting Department of Carson Company and his wife Kim works as an engineer in the...
-
While acting as a fiduciary, you recommended that your client buy a particular brand of refueling station to charge her new, electricity-powered car. You told your client that she would be able to...
-
Huang started a small CPA firm several decades ago when he immigrated to the United States. Now, he is the managing partner of the firm, which has grown to have 40 partners and over 90 professional...
-
The steel rod having a diameter of 1 in. is subjected to an internal moment of M = 300lbft. Determine the stress created at points A and B. Also, sketch a three-dimensional view of the stress...
-
The steel beam has the cross-sectional area shown. If w=5 kip/ft, determine the absolute maximum bending stress in the beam. W 8 8 ft- 8 ft W ft- -8 ft- .8 in. 0.30 in. 0.3 in.- 10 in. 0.30 in.
-
The steel beam has the cross sectional area shown. Determine the largest intensity of distributed load w that it can support so that the bending stress does not exceed max = 22 ksi. 8 ft- 8 ft W -8...
Study smarter with the SolutionInn App