Question

In: Accounting

Sales on account for the first two months of the current year are budgeted as follows....

Sales on account for the first two months of the current year are budgeted as follows.

  

January $ 374,000
February 580,000

  

All sales are made on terms of 2/10, n/30 (2 percent discount if paid in 10 days, full amount by 30 days); collections on accounts receivable are typically made as follows.

  

Collections within the month of sale:
Within discount period 60 %
After discount period 15
Collections within the month following sale:
Within discount period 15
After discount period 7
Returns, allowances, and uncollectibles 3
Total 100 %

Compute the estimated cash collections on accounts receivable for the month of February.

Solutions

Expert Solution

Calculation of estimated cash collections on account receivables for the month of February:
January
Collection with the month of sale:
Within discount period $3,74,000 X 60% X 98% = $ 2,19,912
After discount period $3,74,000 X 60% = $ 2,24,400
Collection within the month of following sale:
Within discount period $3,74,000 X 15% X 98% = $     54,978
After discount period $3,74,000 X 7% = $     26,180
Less: Returns, allowances, and Uncollectibles $3,74,000 X 3% = $     11,220
(a) $     69,938
February
Collection with the month of sale:
Within discount period $5,80,000 X 60% X 98% = $ 3,41,040
After discount period $5,80,000 X 60% = $ 3,48,000
(b) $ 6,89,040
Collection within the month of following sale:
Within discount period $5,80,000 X 15% X 98% = $     85,260
After discount period $5,80,000 X 7% = $     40,600
Less: Returns, allowances, and Uncollectibles $5,80,000 X 3% = $     17,400
Estimated cash collections for the month of February (a) + (b) = $ 7,58,978

Related Solutions

Sales on account for the first two months of the current year are budgeted as follows....
Sales on account for the first two months of the current year are budgeted as follows.    January $ 301,000 February 475,000    All sales are made on terms of 2/10, n/30 (2 percent discount if paid in 10 days, full amount by 30 days); collections on accounts receivable are typically made as follows.    Collections within the month of sale: Within discount period 60 % After discount period 15 Collections within the month following sale: Within discount period 15...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 12,000 units April 24,000 units May 35,000 units June 13,000 units July 43,000 units August 69,000 units ABC Company sells its inventory to customers for $25 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 19,000 units April 23,000 units May 34,000 units June 17,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $16 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July...
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July 7,700 units August 8,300 units September 5,400 units October 10,200 units November ?????? units December 11,700 units The selling price is $18 per unit. 30% of the company's sales are cash sales and 70% of the company's sales are made on account. The sales on account are collected in the pattern 15% in the month of sale, 20% in the month...
Blue Company's activity for the first six months of the current year is as follows: (20...
Blue Company's activity for the first six months of the current year is as follows: (20 points) Machine Hours Electrical Cost January 2,000 $3,000 February 3,500 5,500 March 2,400 4,000 April 1,600 2,400 May 1,500 2,500 June 2,100 3,500 INSTRUCTIONS: a) Using the high-low method, what is the variable cost per machine hour? b) Using the high-low method, what is the fixed portion of the electrical cost each month? c) What would be the expected total electrical costs if the...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for the first half of the current year: Cash Sales Credit Sales January $ 40,000 $ 140,000 February $ 45,000 $ 160,000 March $ 39,000 $ 120,000 April $ 34,000 $ 119,000 May $ 44,000 $ 190,000 June $ 70,000 $ 130,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections...
Meredith Company has budgeted sales for the upcoming months as follows: April $ 458,000 May $...
Meredith Company has budgeted sales for the upcoming months as follows: April $ 458,000 May $ 469,000 June $ 498,000 July $ 517,000 August $ 501,000 September $ 482,000 40% of the sales are credit sales, the remainder are made in cash. Credit sales are collected 50% in the month of sale, 35% in the month following the sale, and 6% in the second month following the sale. a. Compute Meredith Company’s cash receipts for June. (Do not round intermediate...
The budgeted sales in units for the next four months as follows: July 7,200 units August...
The budgeted sales in units for the next four months as follows: July 7,200 units August 5,400 units September 6,800 units October 7,000 units 1. Prepare the sales budget for the third quarter of the company knowing that each unit is sold for $40. (1.5pt) 2. Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory in the beginning of July was only 600 units....
Company budgeted sales in units for the next four months as follows: July 7,000 units August...
Company budgeted sales in units for the next four months as follows: July 7,000 units August 5,000 units September 6,500 units 1. Prepare the sales budget for the company knowing that each unit is sold for $50. (1 pt) 2. Past experience has shown that the ending inventory for each month should be equal to 20% of the next month's sales in units. The inventory in the beginning of July was only 1,000 units, & the inventory on September 30...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases...
Nieto Company’s budgeted sales and direct materials purchases are as follows. Budgeted Sales Budgeted D.M. Purchases January $237,000 $33,500 February 230,100 38,900 March 329,800 38,300 Nieto’s sales are 30% cash and 70% credit. Credit sales are collected 10% in the month of sale, 50% in the month following sale, and 36% in the second month following sale; 4% are uncollectible. Nieto’s purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month of purchase,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT