Question

Total sales for April, May, and June are $900,000, $700,000, and $850,000 respectively. Cash sales are...

Total sales for April, May, and June are $900,000, $700,000, and $850,000 respectively.
Cash sales are normally 30% of total sales.
Of the credit sales, 40% are collected in the same month as the sale, 55% are collected during the first month after the sale, and the remaining 5% are eventually not collected because of bad debts. All bad debts are written off by the end of the second month after the sale.

Compute the total amount of cash received during June, and the amount of accounts receivable outstanding at the end of June.

Homework Answers

Answer #1

In June total sales = $850,000

Cash sales = 850,000*30%= $255,000

Credit sales = 850000-$255000= $595000

Cash collected from credit sales of June = $595000*40%= $238000

Cash collected from sale of may = $700,000*70%*55%= $269500

Total cash collected in June = $255000+$238000+$269500= $762500

Accounts receivable outstanding will be 60%of credit sale of June and 5 % of the sales of may. Because bad debts will be written off after second month of sale .

$595000*60%= $357000

700000*70%*5%=24500

Total outstanding will be $357000+24500=$ 381500

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Memphis Company anticipates total sales for April, May, and June of $920,000, $1,020,000, and $1,070,000 respectively....
Memphis Company anticipates total sales for April, May, and June of $920,000, $1,020,000, and $1,070,000 respectively. Cash sales are normally 30% of total sales. Of the credit sales, 30% are collected in the same month as the sale, 65% are collected during the first month after the sale, and the remaining 5% are not collected. Compute the amount of cash received from total sales during the month of May.
Memphis Company anticipates total sales for April, May, and June of $950,000, $1,050,000, and $1,100,000 respectively....
Memphis Company anticipates total sales for April, May, and June of $950,000, $1,050,000, and $1,100,000 respectively. Cash sales are normally 30% of total sales. Of the credit sales, 30% are collected in the same month as the sale, 65% are collected during the first month after the sale, and the remaining 5% are collected in the second month. Compute the amount of accounts receivable reported on the company’s budgeted balance sheet for June 30. Multiple Choice $619,500. $967,750. $539,000. $575,750....
Ellis Sport Shop projects the following sales: April May June $ 65,000 $ 85,000 $ 105,000...
Ellis Sport Shop projects the following sales: April May June $ 65,000 $ 85,000 $ 105,000 Eighty-five percent of Ellis' sales are on credit with 55 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale. February sales were $55,000 and March sales were $65,000. In the past Ellis' bad debt percentage has been 0 and is expected to continue. a) Prepare a monthly schedule of cash...
A company expects that 90% of its sales will be on account and 10% will be...
A company expects that 90% of its sales will be on account and 10% will be in cash. It expects that 60% of its sales on account will be collected in the month of sale, 25% will be collected in the month following the month of sale, and 15% will be collected two months after the month of sale. It expects the following sales. Month Expected sales January $900,000 February $850,000 March $700,000 April $650,000 May $575,000 June $500,000 July...
Beca Retailers expects credit sales in the next quarter as follows: April $79,100 May 84,800 June...
Beca Retailers expects credit sales in the next quarter as follows: April $79,100 May 84,800 June 101,000 Prior experience has shown that 64 percent of a month’s sales are collected in the month of sale, 20 percent are collected in the month following sale, and the remaining 16 percent are collected in the second month following sale. February and March sales were $82,200 and $110,000, respectively. Estimate budgeted cash receipts for April, May, and June. Collection of credit sales April...
Ridgewood Retailers expects credit sales in the next quarter as follows: April $63,300 May 96,200 June...
Ridgewood Retailers expects credit sales in the next quarter as follows: April $63,300 May 96,200 June 113,000 Prior experience has shown that 61 percent of a month’s sales are collected in the month of sale, 18 percent are collected in the month following sale, and the remaining 21 percent are collected in the second month following sale. February and March sales were $82,200 and $107,000, respectively. Estimate budgeted cash receipts for April, May, and June. Collection of credit sales April...
April May June Sales* $264,000 $198,000 $298,800 Cash receipts: From cash sales $132,000 $99,000 $149,400 From...
April May June Sales* $264,000 $198,000 $298,800 Cash receipts: From cash sales $132,000 $99,000 $149,400 From sales on account† 280,500 112,200 Total cash receipts $412,500 $211,200 *Half of each month’s sales are on account. March sales amounted to $198,000. †60% of credit sales is collected in the month of sale; 40% is collected in the following month.
From past experience, the company has learned that 25% of a month’s sales are collected in...
From past experience, the company has learned that 25% of a month’s sales are collected in the month of sale, another 65% are collected in the month following the sale, and the remaining 10% are collected in the second month following the sale. Bad debts are negligible and can be ignored. February sales totalled $380,000, and March sales totalled $360,000. April May Budgeted sales June Total $400,000 $600,000 $300,000 $1,300,000 Required: 1. Prepare a schedule of expected cash collections from...
Logan Township acquired its water system from a private company on June 1. No receivables were...
Logan Township acquired its water system from a private company on June 1. No receivables were acquired with the purchase. Therefore, total accounts receivable on June 1 had a zero balance. Logan plans to bill customers during the month of sale, and 70% of the resulting billings will be collected during the same month. 90% of the remaining balance should be collectable in the next following month. The remaining uncollectible amounts will relate to citizens who have moved away. Such...
in units april may june sales 70000 60000 80000 production 80000 70000 70000 Cash-related production costs...
in units april may june sales 70000 60000 80000 production 80000 70000 70000 Cash-related production costs are budgeted at 8$ per unit produced. Of these production costs, 40% are paid in month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to 150000$ per month. The accounts payable balance on March 31 totals 190000$ which will be paid in April. All units are sold on account for 24$ each. Cash collections...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT