A. The following data is the analysis of Culture Supplies. Customer A Cut Above Beauty Box...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A. The following data is the analysis of Culture Supplies. Customer A Cut Above Beauty Box Bush Wacker Carl & Swirl Cut Loose Hair Affair Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Due Over 90 Days Due 1.925 S 1,300 $ 475 $ 150 3.880 S 2,930 S 950 5.640 S 2.300 S 1.100 S 1.970 Total S $ $ $ 1.970 S $ 400 $ 1.735 Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Duc Over 90 Days Due Customer A Cut Above Beauty Box Bush Wacker Curl & Swirl Cut Loose Hair Affair Totals 1% 5% 7% 15% 30% Based on past experience, the company estimates the percentage for these uncollectible accounts. Formulal Estimate Percentage Estimate Amount Formula7 480 S Required: (a)Prepare an aging schedule for the company by EXCEL (use SUM formula), determine the amo uncollectible account as of October 31. 14 (b)Use the spaces provided below, write the formulas where requested in the file. (Formulal has t done for you as an example.) Formula2 Formulas Culture Supplies Aging Schedule As of October 31, 2004 Not Yet Due 1-30 Days Duc 31-60 Days Due 61-90 Days Due Over 90 Days Due Totals 5% 1,240 S 325 S Formula3 7% Formula9 1.000 S 700 S Formula 15% Formula 10 400 230 Formula5 Formulall 30% Formula6 Formula12 Formula 1 Formula 2 Formula 3 Formula 4 Formula 5 Formula 6 SUM(B8:B13) Formula 7 Formula 8 Formula 9 at at at at of ? ? ? ? Formula 10 Formula 11. Formula 12 at at af at a 2 2 ? ? ? 2 A. The following data is the analysis of Culture Supplies. Customer A Cut Above Beauty Box Bush Wacker Carl & Swirl Cut Loose Hair Affair Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Due Over 90 Days Due 1.925 S 1,300 $ 475 $ 150 3.880 S 2,930 S 950 5.640 S 2.300 S 1.100 S 1.970 Total S $ $ $ 1.970 S $ 400 $ 1.735 Not Yet Due 1-30 Days Due 31-60 Days Due 61-90 Days Duc Over 90 Days Due Customer A Cut Above Beauty Box Bush Wacker Curl & Swirl Cut Loose Hair Affair Totals 1% 5% 7% 15% 30% Based on past experience, the company estimates the percentage for these uncollectible accounts. Formulal Estimate Percentage Estimate Amount Formula7 480 S Required: (a)Prepare an aging schedule for the company by EXCEL (use SUM formula), determine the amo uncollectible account as of October 31. 14 (b)Use the spaces provided below, write the formulas where requested in the file. (Formulal has t done for you as an example.) Formula2 Formulas Culture Supplies Aging Schedule As of October 31, 2004 Not Yet Due 1-30 Days Duc 31-60 Days Due 61-90 Days Due Over 90 Days Due Totals 5% 1,240 S 325 S Formula3 7% Formula9 1.000 S 700 S Formula 15% Formula 10 400 230 Formula5 Formulall 30% Formula6 Formula12 Formula 1 Formula 2 Formula 3 Formula 4 Formula 5 Formula 6 SUM(B8:B13) Formula 7 Formula 8 Formula 9 at at at at of ? ? ? ? Formula 10 Formula 11. Formula 12 at at af at a 2 2 ? ? ? 2
Expert Answer:
Answer rating: 100% (QA)
Set ANo instructions Set B Formula Please kindly refer to the attached excel document to get the res... View the full answer
Related Book For
College Accounting A Practical Approach
ISBN: 978-0132564441
11th Canadian Edition
Authors: Jeffrey Slater, Brian Zwicker
Posted Date:
Students also viewed these accounting questions
-
The following data is provided for XYZ Company: Beginning Inventory 200 units @ 10...................$ 2,000 Purchase 350 units @ 15.........................................5,250 Purchase 450 units @...
-
The following data is available for Blaine Corporation at December 31, 2015: Common stock, par $10 (authorized 30,000 shares) $250,000 Treasury Stock (at cost $15 per share) 900 Based on the data,...
-
The following data is provided: Monthly returns which include those for three assets classes for? the six-year period to the end of December 2013. The Cape Retirement Fund may only invest in the...
-
Implement the queue data structure using arrays of size 10 with the following functions Enqueue () - add {2,3,4,5,6,7,8} to the queue Dequeue() - remove 2 elements isFull() - check if the queue is...
-
On January 1, 2010, Tuscany Corporation purchased 1,000 shares of treasury stock. Other information regarding Tuscany Corporation is provided below. Compute (a) Return on common stockholders equity...
-
Calculate the average impact force on a steel late by a 1-mm spherical aluminum-oxide abrasive irain, dropped from heights of (a) 1 m, (b) 2 m, and (c) 10 m. Plot the results and comment on your...
-
Among Mintzbergs 10 managerial roles, acting as a figurehead and liaison are examples of ____________ roles. (a) interpersonal (b) informational (c) decisional (d) conceptual
-
Refer to the Real Estate data, which report information on homes sold in Goodyear, Arizona, and the surrounding area. a. Use an appropriate nonparametric test to determine whether there is a...
-
Consider a sample of 48 football games, where 28 of them were won by the home team. Use a 0.05 significance level to test the claim that the probability that the home team wins is greater than...
-
Idexo Corporation is a privately held designer and manufacturer of licensed college apparel in Cincinnati, Ohio. In late 2019, after several years of lackluster performance, the firms owner and...
-
An all-equity company has common and preferred shares. There are 250,000 common shares outstanding with a price of $51.10 per share and with an expectation to continue to provide a dividend of $5.30...
-
Classify the critical points and relative extrema of g(x) = cos (x) - 2 sin(x) on [0,2].
-
What is fair valuation? In general, when would a fund use fair valuation? Give a specific example when fair valuation would be used for all of a fund's holdings in a particular market. Give a...
-
Can you elaborate on the concept of stress corrosion cracking (SCC) and its relation to material properties, residual stresses, and environmental factors, particularly in high-stress applications...
-
This week's reading provides overview of criminal justice as a non-system, law enforcement, judiciary process and corrections. After reviewing the reading for week 7, discuss/debate with your...
-
Setup the integral to calculate the area between the following curves. y = 5x and y = 9x. The limits of integration and the integral to find this would be dx Enter exact results or decimal...
-
The question of value refers to "is a resource currently controlled by only a small number of competing firms?" True False Question 10 0.2 pts The question of Imitability refers to "Do firms without...
-
Explain the term global capital markets. This chapter primarily discusses global equity markets. What other types of financial instruments are traded in these markets? How important are global...
-
Karen Johnson, the accountant of Hoop Co. of Nelson, has appointed Jim Pool as the petty cash custodian. The following transactions occurred in November: Help Jim replenish petty cash on December 3...
-
Jill Martin of Regina opened Martins Catering Service. As her accountant, analyze the transactions listed below and present in proper form: 1. The analysis of the transactions by utilizing the...
-
Record the following transactions in the basic accounting equation: Assets = Liabilities + Owners Equity Treat each transaction separately. a. Ralph invests $8,000 in his company. b. The company buys...
-
What is the value of a call option if the underlying stock price is $20, the strike price is $22, the underlying stock volatility is 50 percent, and the risk-free rate is 4 percent? Assume the option...
-
Assume Polands currency (the zloty) is worth $.17 and the Japanese yen is worth $.008. What is the cross rate of the zloty with respect to yen? That is, how many yen equal a zloty?
-
Utah Banks bid price for Canadian dollars is $.7938 and its ask price is $.81. What is the bid/ask percentage spread?
Study smarter with the SolutionInn App