Solution
Schedule of Expected Cash Collections | ||||
April | May | June | Total | |
February Sales | $ 40,000 | $ 40,000 | ||
March Sales | $ 279,500 | $ 43,000 | $ 322,500 | |
April Sales | $ 117,500 | $ 305,500 | $ 47,000 | $ 470,000 |
May Sales | $ 167,500 | $ 435,500 | $ 603,000 | |
June Sales | $ 57,500 | $ 57,500 | ||
Total Cash Collection | $ 437,000 | $ 516,000 | $ 540,000 | $ 1,493,000 |
.
Total Receivables at June 30 | $ 239,500 |
Working
April | May | June | |
February Sales | 400000 x 10% | ||
March Sales | 430000 x 65% | 430000 x 10% | |
April Sales | =470000*25% | =470000*65% | =470000*10% |
May Sales | =670000*25% | =670000*65% | |
June Sales | =230000*25% |
.
Accounts Receivables Balance | ||
Balance of may sales | (10% of sale) | $ 67,000 |
Balance of June Sale | (75% of sale) | $ 172,500 |
Total Receivables at June 30 | $ 239,500 |
HW 5 (Chapter 8) i Saved Help Save & Exit Submit Check my work 1 Silver...
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $330,000 May $530,000 June $210,000 Total $1,070,000 From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the...
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: April $370,000 Мay $570,000 June Total Budgeted sales (al1 on account) $1, 120,000 $180,000 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 sale, and...
Exercise 8-1 Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $450,000 May $650,000 June $250,000 Total $1,350,000 From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are...
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: April $390,000 May $590,000 June $230,000 Total $1,210,000 Budgeted sales (all on account) From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the...
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $440,000 May $640,000 June $220,000 Total $1,300,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the...
exercise 8-1 (two parts) Exerclse 8-1 Schedule of Expected Cash Collections [LO8-21 Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below Total $1,168, e0e April $380, eee May $58e, eee June $200,eee Budgeted sales (all on account) From past experience, the company has learned that 20 % of a month's sales are collected...
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: April $450,000 May $650,000 June $250,000 Total $1,350,000 Budgeted sales (all on account) From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the...
Exercise 8-1 Schedule of Expected Cash Collections (LO8-2) Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $350,000 May $530,000 June $210,000 Total $1,070,000 From past experience, the company has learned that 25% of a month's sales are collected in the month of sale, another 60% are...
I need help wit required 1 and required 2 Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $420,000 May $620,000 June Total $240,000 $1,280,000 From past experience, the company has learned that 20% of a month's sales are collected in the month of sale, another 65%...
Silver Company makes a product that is very popular as a Mother's Day gift. Thus, peak sales occur in May of each year, as shown in the company's sales budget for the second quarter given below: Budgeted sales (all on account) April $360,000 May $560,000 June $220,000 Total $1,140,000 From past experience, the company has learned that 30% of a month's sales are collected in the month of sale, another 60% are collected in the month following sale, and the...