Carlene Johnson is the Accountant in the Finance Department at Fairway Trading Limited who manages the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Carlene Johnson is the Accountant in the Finance Department at Fairway Trading Limited who manages the company Accounts Receivables. She was given the following information by the Finance Manager which was extracted from the debtor's ledger as at December 31, 2022. Terms Category of Total value of Date of Sales Customers Sales To Customer $ Keith Green 180,0000 Karen White 240,000 June Hinds 390,000 John Wayne 380,000 Paul Gayle 346,000 December 16, 2021 December 10, 2021 November 15, 2022 June 26, 2022 August 25, 2022 30 days Percentage provision to be created 60 days 30 days 30 days 30 days Date of Last Payment on A/C January 15, 2022 February 14, 2022 December 20, 2022 October 24, 2022 September 24, 2022 Total Amount Paid to Date on Account $ 90,500 180,000 170,000 295,000 235,000 The Accountant decided that she would age the debt outstanding in the following category and the percentage to be provided for bad debt in the amount stated beside each category accordingly. Aging Category 30-60 Days 60-120 days 120-180 days 180-240 days 240-300 days 300-365 days Over 365 days Requirements: 5% 10% 150% 25% 40% 70% 100 a. With the aid of a spread sheet use the above information to create a debtor's aging schedule with the additional columns if necessary. (35 marks) b. Draft a sample of an appropriate letter which the accountant could sent to Karen White to make payment on his accounts (10 marks) Show the entries for the total amount of provisions for bad debt to be created. (5 marks) C. Carlene Johnson is the Accountant in the Finance Department at Fairway Trading Limited who manages the company Accounts Receivables. She was given the following information by the Finance Manager which was extracted from the debtor's ledger as at December 31, 2022. Terms Category of Total value of Date of Sales Customers Sales To Customer $ Keith Green 180,0000 Karen White 240,000 June Hinds 390,000 John Wayne 380,000 Paul Gayle 346,000 December 16, 2021 December 10, 2021 November 15, 2022 June 26, 2022 August 25, 2022 30 days Percentage provision to be created 60 days 30 days 30 days 30 days Date of Last Payment on A/C January 15, 2022 February 14, 2022 December 20, 2022 October 24, 2022 September 24, 2022 Total Amount Paid to Date on Account $ 90,500 180,000 170,000 295,000 235,000 The Accountant decided that she would age the debt outstanding in the following category and the percentage to be provided for bad debt in the amount stated beside each category accordingly. Aging Category 30-60 Days 60-120 days 120-180 days 180-240 days 240-300 days 300-365 days Over 365 days Requirements: 5% 10% 150% 25% 40% 70% 100 a. With the aid of a spread sheet use the above information to create a debtor's aging schedule with the additional columns if necessary. (35 marks) b. Draft a sample of an appropriate letter which the accountant could sent to Karen White to make payment on his accounts (10 marks) Show the entries for the total amount of provisions for bad debt to be created. (5 marks) C.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Suppose you are given the following set of data with three Boolean input variables a, b, and c, and a single Boolean output variable K. a bc K 1 0 1 1 1 1 1 1 1 1 1 1 1 1 0 01 For parts (a) and (b),...
-
(a) If interest rates rise, will callable or noncallable bonds fall more in price? (b) Sometimes you encounter bonds that can be repaid after a fixed interval at the option of either the issuer or...
-
Using the facts in the previous problem, what is the minimum tax that Pedro should pay to make the tax structure vertically equitable with respect to the amount of tax paid? This would result in what...
-
Having understood the contents of this chapter, you, as the manager of Section A comprising 50 students of MBA 1st year course, are required to form groups of five students each. Include yourself in...
-
Mansard Hotels has five luxury hotels located in Boston, New York, Chicago, San Francisco, and Los Angeles. For internal reporting purposes, each hotel has an income statement showing its revenue and...
-
Use the information below to calculate the machine's depreciation expense Machines initial cost $820 Residual value. $120 The Company started to use the machine on May 1, 2020 The useful fe of the...
-
Problem 3-3B Preparing adjusting entries, adjusted trial balance, and financial statements A1 P1 P2 P3 Following is the unadjusted trial balance for Alonzo Institute as of December 31, 2015, which...
-
An employee earns $4,000 per week. Contributes $150 to their 401(k) plan and $75 to United Way. What is the employee's FICA taxes for the period?
-
What is a product cost? What is a period cost? Why is it important to sort costs into product costs and period costs? What are some product costs related to Dunkin' donuts? What are some period costs...
-
Walgreens is the nation's largest drugstore chain with annual sales of $47.4 billion. It operates 5,584 stores in 47 states and Puerto Rico and plans to have 7,000 stores by 2010. The plan was going...
-
Please answer the questiond below with own words and couple sentences In one or two sentences, explain if a country would rather have a trade surplus or a trade deficit. Then, in two or three...
-
At the time of judy's death, she owned an investment portfolio with a market value of $500,000. How much tax will be payable on the accrued capital gain if we know that her marginal tax rate in the...
-
During 2019, Philips Company's net profit was $550. The tax amount was $200. The amount of interest expense was $65. What is this company's interest coverage ratio? (rounded to nearest whole number)...
-
PART A: BLOOD TYPING 1. Fill out Table 1.1: Table 1:1-ABO-Rh Blood Typing Chart - 16 points (1 point for each block) Blood Type List all antigens present in these List all antibodies present in these...
-
Chicago Company sold merchandise to a customer for $1,500 cash in a state with a 6% sales tax rate. The total amount of cash collected from the customer was $558. $600. $642. $636. Nevada Company...
-
What does the DWC measure? Why is it important?
-
How can government agencies help businesses?
-
Differentiate between average collection period and aging of trade receivables.
-
You lift a book at a constant speed. Which statement is true about the work W done by your hand and the change in the book's gravitational potential energy U g ? A. W> AU>0 B. W < AU <0 C. W=AU>0 D....
-
At a point where the electric potential is 400 V, a positive charge is moving to the left. As the charge continues to move, it slows down, stops, and then begins to move back to the right. Using what...
-
A positively charged particle moves from point I to point 2. As it does, its electric potential energy? A. Increases. B. Decreases. C. Stays the same. 102
Study smarter with the SolutionInn App