Current Attempt In Progress The Cheyenne Corp.sells office equipment and supplies to many organizations in the city and surrounding area on contract terms of 2/10, 1/30. In the past, over 75% of the credit customers have taken advantage of the discount by paying within 10 days of the Involce date. However, the number of customers taking the full 30 days to pay has increased within the last year. It now appears that fewer than 60% of the customers are taking the discount. Bad debts as a percentage of gross credit sales have risen from the 1.50% of past years to about 4% In the current year. The controller responded to a request for more information on the deterioration in collections of accounts receivable by preparing the following report: Cheyenne Corp. Finance Committee Report-Accounts Receivable Collections May 31, 2020 The fact that some credit accounts will prove uncollectible is normal. Annual bad debt write ofts have been 1.50% of credit sales over the past five years. During the last fiscal year, this percentage increased to slightly less than 4%. The current Accounts Receivable balance is $1.80 million. The condition of this balance in terms of age and probability of collection is as follows: Proportion of Total (%) Age Categories Probability of Collection (%) not yet due 99 15 less than 30 days past due 95.50 30 to 60 days past due 61 to 120 days past due 2.50 121 to 180 days past due more than 180 days past due Ne 68 8 5 95 90 70 20 1.50 O A 40 ENG 9:40 PM 2020-05-31 DELL D m/courses/45581/assignments/5037683 Probability of Collection (36) 99 95.50 Proportion of Total (%) Age Categories 68 not yet due 15 less than 30 days past due 8 30 to 60 days past due 5 61 to 120 days past due 2.50 121 to 180 days past due 1.50 more than 180 days past due 95 90 70 20 Allowance for Doubtful Accounts had a credit balance of $43,200 on June 1, 2019. The Cheyenne Corp. has provided for a monthly bad debt expense accrual during the current fiscal year based on the assumption that 4% of gross credit sales will be uncollectible. Total gross credit sales for the 2019-20 fiscal year amounted to $4.05 million. Write offs of bad accounts during the year totalled $143,000. (a) Prepare an accounts receivable aging schedule for the Cheyenne Corp. using the age categories identified in the controller's report to the finance committee. Show (1) the amount of accounts receivable outstanding for each age category and in total, and (2) the estimated amount that is uncollectible for each category and in total. (Round proportion and probability answers to 3 decimal places, es. 5.275 and other answers to decimal places, eg. 5,275.) Cheyenne Corp A00) ENG Ne 9:40 PM 2020-05-3 o DELL Current Attempt In Progress The Cheyenne Corp.sells office equipment and supplies to many organizations in the city and surrounding area on contract terms of 2/10, 1/30. In the past, over 75% of the credit customers have taken advantage of the discount by paying within 10 days of the Involce date. However, the number of customers taking the full 30 days to pay has increased within the last year. It now appears that fewer than 60% of the customers are taking the discount. Bad debts as a percentage of gross credit sales have risen from the 1.50% of past years to about 4% In the current year. The controller responded to a request for more information on the deterioration in collections of accounts receivable by preparing the following report: Cheyenne Corp. Finance Committee Report-Accounts Receivable Collections May 31, 2020 The fact that some credit accounts will prove uncollectible is normal. Annual bad debt write ofts have been 1.50% of credit sales over the past five years. During the last fiscal year, this percentage increased to slightly less than 4%. The current Accounts Receivable balance is $1.80 million. The condition of this balance in terms of age and probability of collection is as follows: Proportion of Total (%) Age Categories Probability of Collection (%) not yet due 99 15 less than 30 days past due 95.50 30 to 60 days past due 61 to 120 days past due 2.50 121 to 180 days past due more than 180 days past due Ne 68 8 5 95 90 70 20 1.50 O A 40 ENG 9:40 PM 2020-05-31 DELL D m/courses/45581/assignments/5037683 Probability of Collection (36) 99 95.50 Proportion of Total (%) Age Categories 68 not yet due 15 less than 30 days past due 8 30 to 60 days past due 5 61 to 120 days past due 2.50 121 to 180 days past due 1.50 more than 180 days past due 95 90 70 20 Allowance for Doubtful Accounts had a credit balance of $43,200 on June 1, 2019. The Cheyenne Corp. has provided for a monthly bad debt expense accrual during the current fiscal year based on the assumption that 4% of gross credit sales will be uncollectible. Total gross credit sales for the 2019-20 fiscal year amounted to $4.05 million. Write offs of bad accounts during the year totalled $143,000. (a) Prepare an accounts receivable aging schedule for the Cheyenne Corp. using the age categories identified in the controller's report to the finance committee. Show (1) the amount of accounts receivable outstanding for each age category and in total, and (2) the estimated amount that is uncollectible for each category and in total. (Round proportion and probability answers to 3 decimal places, es. 5.275 and other answers to decimal places, eg. 5,275.) Cheyenne Corp A00) ENG Ne 9:40 PM 2020-05-3 o DELL
