Question

In: Accounting

The following credit sales are budgeted by Sheridan Electronics: January $123600 February 120000 March 135600 April...

The following credit sales are budgeted by Sheridan Electronics:

January $123600
February 120000
March 135600
April 141000
May 141300


The company's past experience indicates that 50% of the accounts receivable are collected in the month of sale, 30% in the month following the sale, and 19% in the second month following the sale. 1 percent are uncollectible. How much does the company anticipate as cash receipts for March?

$134244

$127284

$136947

$123564

Solutions

Expert Solution

Solution : The anticipated cash receipts for the month of March is $127,284,

Based on the given information,

a) 50% of the credit sale are collected in the month of sale.

b) 30% of the credit sale are collected in the month following the sale.

c) 19% of the credit sale are collected in the second month following the sale.

Therefore, the anticipated cash collection can be calculated with the help of the below table

All the figures are in $ Month
Jan Feb Mar Apr May
Credit Sales    123,600.00    120,000.00    135,600.00    141,000.00    141,300.00
Cash Collection in March
50% of current sales (i.e. March)      67,800.00
30% of previous month sale (i.e. February)      36,000.00
19% of sale done 2 months before (i.e. January)      23,484.00
Total Cash Receipts (anticipated)    127,284.00

Related Solutions

The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The...
The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The company’s past experience indicates that 60% of the accounts receivable are collected in the month of sale, 40% in the month following the sale. The anticipated cash inflow for the month of March is $247800. $365800. $413000. $401200.
Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900,...
Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900, 11,400, 11,900, and 13,400 units, respectively. The ending finished goods inventory equals 20% of the following month's sales. The ending raw materials inventory equals 40% of the following month’s raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. If 61,000 pounds of raw materials are required for production in March, then the budgeted raw material purchases for February...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted...
Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted Sales $80,000 $100,000 $140,000 Ninety percent of sales are on account and ten percent of sales are cash sales. A month's sales on account are collected as follows: Month of sale 50% First month following sale 40% Second month following sale 9% Uncollectible 1% The company requires a minimum cash balance of $7,000 to start a month. The beginning cash balance in March is...
The following credit sales are budgeted by Roswell Company: $30,000 in January,$50,000 in February and $70,000...
The following credit sales are budgeted by Roswell Company: $30,000 in January,$50,000 in February and $70,000 in March. The company's past experience indicates that 70% of the credit sales are collected in the month of sale and 30% in the month following the sale. The anticipated cash inflow for the month of March is Select one: a. $58,800 b. $44,000 c. $70,000 d. $64,000
The following are budgeted data:   January February March Sales in units 16,600 23,200 19,600 Production...
The following are budgeted data:   January February March Sales in units 16,600 23,200 19,600 Production in units 19,600 20,600 19,300   One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 25% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Garrison 16e Rechecks 2017-10-03 Multiple Choice 20,925 pounds 20,575 pounds 20,275 pounds 18,325 pounds , Depasquale Corporation is...
The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in...
The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in units 18,500 19,500 17,400 One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 30% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Multiple Choice 19,970 pounds 18,630 pounds 18,870 pounds 20,130 pounds
The following are budgeted data: January February March Sales in units 15,200 20,400 18,200 Production in...
The following are budgeted data: January February March Sales in units 15,200 20,400 18,200 Production in units 18,200 19,200 17,100 One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 30% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Multiple Choice 18,630 pounds 19,830 pounds 19,670 pounds 18,570 pounds
the cash sales and credit sales projected for sarahs kitchen are as follows: January february march...
the cash sales and credit sales projected for sarahs kitchen are as follows: January february march april may cash 17,000 19640 16200 15380 17390 credit 40,000 42000 48000 50000 49500 if collections of credit sales are 70% the first month and 30% the second month, what would be the cash receipts for march, april, and may
limerick, Inc: has budgeted total sales for January, February, and March of $800,000, $900,000, and $950,000...
limerick, Inc: has budgeted total sales for January, February, and March of $800,000, $900,000, and $950,000 respectively. Cash sales are normally 25% of total sales. Of the credit sales, 40% are collected in the same month as the sale, and 60% are collected during the first month after the sale. Compute the amount of cash received from sales during the month of February.
Garver Industries has budgeted the following unit sales: 2020 Units January 10,000 February 8,000 March 9,000...
Garver Industries has budgeted the following unit sales: 2020 Units January 10,000 February 8,000 March 9,000 April 11,000 May 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. They also have...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT