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...
-
Construct the production possibilities frontier for the economy described in Problem 14. What is the opportunity cost of food in terms of clothing?
-
Identify which production systemanalytic or syntheticapplies to each of the following products: a. logging b. healthcare c. soybean farming d. fishing e. a smart phone
-
Recycling concrete aggregate is an important component of green engineering. The strength of any potential material, expressed in terms of its resilient modulus, must meet standards before it is...
-
The December 31, 2011, balance sheet of Tybee Corporation is provide below (in millions). Transactions during January 2012:Paid $5 for employee wages.Collected $10 cash from customers for work...
-
8 A car is driving along at 13 m/s, and the rain is falling at 7 m/s straight down. What angle (in degrees) does the rain make with respect to the horizontal as observed by the driver?
-
Reba Dixon is a fifth-grade school teacher who earned a salary of $38,000 in 2020. She is 45 years old and has been divorced for four years. She receives $1,200 of alimony payments each month from...
-
(a) (5 marks) Find a DFSA for the language La (that is, L3a complement), where L3a={xy {0, 1} |00 is a substring of x and 11 is a substring of y}. Briefly justify (informally) why your DFSA is...
-
What is the value of Math.abs(-2147483648)?
-
Define the various stages involved in setting prices.
-
What do you think might be the main sources of revenue for the following types of non-profit organisation and what revenue generation problems do you think each faces: (a) a small local charity; (b)...
-
What are the ten criteria that affect customers perceptions of service quality?
-
Design a short questionnaire for assessing the quality of service offered by a local dental practice.
-
The specifications for a plastic liner for a concrete highway project calls for thickness of 5.0 mmplus or minus0.10 mm. The standard deviation of the process is estimated to be 0.02 mm. The upper...
-
Solve for the equilibria of the following discrete-time dynamical systems Pr pt+1 = Pr+2.0(I-Pr)
-
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...
-
Consider the flow of a perfect gas along a Fanno line. Show that the pressure at the * reference state is given by the relation 1/2 m 2RT, P Ayge(y+1)
-
Air flows in an 8-cm-inside diameter pipe that is \(4 \mathrm{~m}\) long. The air enters with a Mach number of 0.45 and a temperature of \(300 \mathrm{~K}\). (a) What friction factor would cause...
-
Air enters a duct with a mass flow rate of \(35 \mathrm{lbm} / \mathrm{sec}\) at \(T_{1}=520^{\circ} \mathrm{R}\) and \(p_{1}=20 \mathrm{psia}\). The duct is square and has an area of \(0.64...
Study smarter with the SolutionInn App