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 $1,000,000, $1,100,000, and $1,150,000 respectively....
Memphis Company anticipates total sales for April, May, and June of $1,000,000, $1,100,000, and $1,150,000 respectively. Cash sales are normally 25% 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 not collected. Compute the amount of cash received from credit sales during the month of May. I know the answer is $742,500 but not sure how they...
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 $960,000, $1,060,000, and $1,110,000 respectively....
Memphis Company anticipates total sales for April, May, and June of $960,000, $1,060,000, and $1,110,000 respectively. Cash sales are normally 20% of total sales. Of the credit sales, 35% are collected in the same month as the sale, 60% are collected during the first month after the sale, and the remaining 5% are not collected. Compute the amount of cash received from credit sales during the month of May. Multiple Choice $719,200. $819,600. $1,041,600. $969,600. $757,600.
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...
Y&Z Co had forecasted sales as follows: -April= $406,000 -May= $452,000 -June= $496,000 Sales are 30%...
Y&Z Co had forecasted sales as follows: -April= $406,000 -May= $452,000 -June= $496,000 Sales are 30% credit and 70% cash 50% of the credit sales are collected in the month of the sale, 30% in the month following the sale, and 20% in the following month. Totals sales for the months of February and March were $900,000 with February having $500,000 credit sales and March $400,000 Prepares a sales budget schedule and a cash collections budget schedule for the months...
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.