Question
In: Accounting
Exercise 7-1 Schedule of Expected Cash Collections [LO7-2] Silver Company makes a product that is very...
Exercise 7-1 Schedule of Expected Cash Collections [LO7-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: |
| April | May | June | Total | |
| Budgeted sales (all on account) | $410,000 | $610,000 | $210,000 | $1,230,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 remaining 15% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $340,000, and March sales totaled $370,000. |
| Required: | |
| 1. |
Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. |
| 2. |
Assume that the company will prepare a budgeted balance sheet as of June 30. Compute the accounts receivable as of that date. |
Solutions
Expert Solution
Answer:-1)-
| Statement of cash collection from debtors | ||||||
| Particulars | April | May | June | Total | ||
| Sales $ | 410000 | 610000 | 210000 | 1230000 | ||
| Cash Collection | ||||||
| 25% in month of sale | 410000*25% =102500 | 610000*25% =152500 | 210000*25% =52500 | 307500 | ||
| 60% in following month of sale | 370000*60% =222000 | 410000*60% =246000 | 610000*60% =366000 | 834000 | ||
| 15% in the second month following sale | 340000*15% =51000 | 370000*15% =55500 | 410000*15% =61500 | 168000 | ||
| Total collection | 375500 | 454000 | 480000 | 1309500 | ||
Explanation:-
| Statement of cash collection from debtors | ||||||
| Particulars | February | March | April | May | June | Total |
| Sales $ | 340000 | 370000 | 410000 | 610000 | 210000 | 1230000 |
| Cash Collection | ||||||
| 25% in month of sale | 340000*25% =85000 | 370000*25% =92500 | 410000*25% =102500 | 610000*25% =152500 | 210000*25% =52500 | 307500 |
| 60% in following month of sale | 340000*60% =204000 | 370000*60% =222000 | 410000*60% =246000 | 610000*60% =366000 | 834000 | |
| 15% in the second month following sale | 340000*15% =51000 | 370000*15% =55500 | 410000*15% =61500 | 168000 | ||
| Total collection | 85000 | 296500 | 375500 | 454000 | 480000 | 1309500 |
2)-Accounts receivable on June 30:-
May month =$610000*15% =$91500
June month =$210000*75% =$157500
ekkarill92 answered 1 year agoRelated Solutions
Exercise 7-1 Schedule of Expected Cash Collections [LO7-2] Silver Company makes a product that is very...
Exercise 7-1 Schedule of Expected Cash Collections [LO7-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:
April
May
June
Total
Budgeted sales (all
on account)
$370,000
$570,000
$180,000
$1,120,000
From past experience, the company
has learned that 25% of a month’s sales are collected in the month
of sale,...
Exercise 8-1 Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very...
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:
April
May
June
Total
Budgeted sales (all on account)
$450,000
$650,000
$250,000
$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...
Exercise 8-1 Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very...
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:
April
May
June
Total
Budgeted sales (all on account)
$310,000
$510,000
$160,000
$980,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...
EXERCISE 8–1 Schedule of Expected Cash Collections LO8–2 Silver Company makes a product that is very...
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:
April
May
June
Total
Budgeted sales (all on account) . . . . . . . . .
$300,000
$500,000
$200,000
$1,000,000
From past experience, the company has learned that 20% of a
month’s sales are...
Exercise 8-1 Schedule of Expected Cash Collections [LO8-2] Silver Company makes a product that is very...
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:
April
May
June
Total
Budgeted sales (all on account)
$410,000
$610,000
$210,000
$1,230,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...
roblem 7-25A Schedule of Expected Cash Collections; Cash Budget [LO7-2, LO7-8] Herbal Care Corp., a distributor...
roblem 7-25A Schedule of Expected Cash Collections; Cash Budget
[LO7-2, LO7-8] Herbal Care Corp., a distributor of herb-based
sunscreens, is ready to begin its third quarter, in which peak
sales occur. The company has requested a $40,000, 90-day loan from
its bank to help meet cash requirements during the quarter. Since
Herbal Care has experienced difficulty in paying off its loans in
the past, the loan officer at the bank has asked the company to
prepare a cash budget for...
Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet [LO7-2, LO7-4, LO7-9, LO7-10] [The...
Schedules of Expected Cash Collections and Disbursements; Income
Statement; Balance Sheet [LO7-2, LO7-4, LO7-9, LO7-10]
[The following information
applies to the questions displayed below.]
Beech Corporation is a merchandising company that is preparing a
master budget for the third quarter of the calendar year. The
company’s balance sheet as of June 30th is shown below:
Beech Corporation
Balance Sheet
June 30
Assets
Cash
$
74,000
Accounts
receivable
143,000
Inventory
73,500
Plant and equipment,
net of depreciation
224,000
Total assets
$...
Exercise 7-9 Variable and Absorption Costing Unit Product Costs and Income Statements [LO7-1, LO7-2, LO7-3] Walsh...
Exercise 7-9 Variable and Absorption Costing Unit Product Costs
and Income Statements [LO7-1, LO7-2, LO7-3]
Walsh Company manufactures and sells one product. The following
information pertains to each of the company’s first two years of
operations:
Variable costs per unit:
Manufacturing:
Direct materials
$
24
Direct labor
$
11
Variable manufacturing overhead
$
3
Variable selling and administrative
$
2
Fixed costs per year:
Fixed manufacturing overhead
$
320,000
Fixed selling and administrative expenses
$
50,000
During its first year...
Exercise 7-9 Variable and Absorption Costing Unit Product Costs and Income Statements [LO7-1, LO7-2, LO7-3] Walsh...
Exercise 7-9 Variable and Absorption Costing Unit Product Costs
and Income Statements [LO7-1, LO7-2, LO7-3]
Walsh Company manufactures and sells one product. The following
information pertains to each of the company’s first two years of
operations:
Variable costs per unit:
Manufacturing:
Direct materials
$
28
Direct labor
$
13
Variable manufacturing
overhead
$
3
Variable selling and
administrative
$
2
Fixed costs per year:
Fixed manufacturing
overhead
$
320,000
Fixed selling and administrative
expenses
$
100,000
During its first year...
Exercise 7-9 Variable and Absorption Costing Unit Product Costs and Income Statements [LO7-1, LO7-2, LO7-3] Walsh...
Exercise 7-9 Variable and Absorption Costing Unit Product Costs
and Income Statements [LO7-1, LO7-2, LO7-3]
Walsh Company manufactures and sells one product. The following
information pertains to each of the company’s first two years of
operations:
Variable costs per unit:
Manufacturing:
Direct materials
$
25
Direct labor
$
15
Variable manufacturing overhead
$
5
Variable selling and administrative
$
4
Fixed costs per year:
Fixed manufacturing overhead
$
400,000
Fixed selling and administrative expenses
$
70,000
During its first year...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Young and Company claims that its pressurized diving bell will, on average, maintain its integrity to...
- 1) Alternative compiled code sequence using instructions in classes A, B, C. What is the average...
- An asset is purchased on January 1 for $48,700. It is expected to have a useful...
- Do we have any online or offline tool to convert c and cpp programs into MIPS...
- -what is the pH of HCl 0,1M and NaCl 0,1M mixed together solution? -What is the...
- function X=extractDWT(x_train,startS,endS,wStep,wRange) % x_train = input signal % startS = from second % endS = end...
- Do you agree that Social Loafing is similar to Theory X. Give an example to support...
ADVERTISEMENT