Question

In: Accounting

Meredith Company has budgeted sales for the upcoming months as follows: April $ 458,000 May $...

Meredith Company has budgeted sales for the upcoming months as follows: April $ 458,000 May $ 469,000 June $ 498,000 July $ 517,000 August $ 501,000 September $ 482,000 40% of the sales are credit sales, the remainder are made in cash. Credit sales are collected 50% in the month of sale, 35% in the month following the sale, and 6% in the second month following the sale. a. Compute Meredith Company’s cash receipts for June. (Do not round intermediate calculations.) b. Compute Meredith Company’s cash receipts for July. (Do not round intermediate calculations.) c. Compute Meredith Company’s cash receipts for August. (Do not round intermediate calculations.)

Solutions

Expert Solution

Cash sales(60%) Credit sales(40%)
April (458000*60%)=$274800 (458000*0.4)=$183200
May (469000*60%)=$281400 (469000*0.4)=$187600
June (498000*60%)=$298800 (498000*0.4)=$199200
July (517000*60%)=$310200 (517000*0.4)=$206800
August (501000*60%)=$300600 (501000*0.4)=$200400
September (482000*60%)=$289200 (482000*0.4)=$192800

1.cash receipts for June=Cash receipts for June+(Credit receipts for June*0.5)+(Credit receipts for May*0.35)+(Credit receipts for April*0.06)

=298800+(199200*0.5)+(187600*0.35)+(183200*0.06)

=$475052

2.cash receipts for July=Cash receipts for July+(Credit receipts for July*0.5)+(Credit receipts for June*0.35)+(Credit receipts for May*0.06)

=310200+(206800*0.5)+(199200*0.35)+(187600*0.06)

=$494576

3.cash receipts for August=Cash receipts for August+(Credit receipts for August*0.5)+(Credit receipts for July*0.35)+(Credit receipts for June*0.06)

=300600+(200400*0.5)+(206800*0.35)+(199200*0.06)

=$485132.


Related Solutions

ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 12,000 units April 24,000 units May 35,000 units June 13,000 units July 43,000 units August 69,000 units ABC Company sells its inventory to customers for $25 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 19,000 units April 23,000 units May 34,000 units June 17,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $16 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $269,000 September $52,000 $251,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 8% are collected in the third month following sale, and the remaining...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $251,000 September $52,000 $269,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 9% are collected in the third month following sale, and the remaining...
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July...
ZZ, Inc. has budgeted sales in units for the next six months as follows: Budgeted Sales in Units July 7,700 units August 8,300 units September 5,400 units October 10,200 units November ?????? units December 11,700 units The selling price is $18 per unit. 30% of the company's sales are cash sales and 70% of the company's sales are made on account. The sales on account are collected in the pattern 15% in the month of sale, 20% in the month...
Sales on account for the first two months of the current year are budgeted as follows....
Sales on account for the first two months of the current year are budgeted as follows.    January $ 301,000 February 475,000    All sales are made on terms of 2/10, n/30 (2 percent discount if paid in 10 days, full amount by 30 days); collections on accounts receivable are typically made as follows.    Collections within the month of sale: Within discount period 60 % After discount period 15 Collections within the month following sale: Within discount period 15...
Sales on account for the first two months of the current year are budgeted as follows....
Sales on account for the first two months of the current year are budgeted as follows.    January $ 374,000 February 580,000    All sales are made on terms of 2/10, n/30 (2 percent discount if paid in 10 days, full amount by 30 days); collections on accounts receivable are typically made as follows.    Collections within the month of sale: Within discount period 60 % After discount period 15 Collections within the month following sale: Within discount period 15...
Company budgeted sales in units for the next four months as follows: July 7,000 units August...
Company budgeted sales in units for the next four months as follows: July 7,000 units August 5,000 units September 6,500 units 1. Prepare the sales budget for the company knowing that each unit is sold for $50. (1 pt) 2. Past experience has shown that the ending inventory for each month should be equal to 20% of the next month's sales in units. The inventory in the beginning of July was only 1,000 units, & the inventory on September 30...
The budgeted sales in units for the next four months as follows: July 7,200 units August...
The budgeted sales in units for the next four months as follows: July 7,200 units August 5,400 units September 6,800 units October 7,000 units 1. Prepare the sales budget for the third quarter of the company knowing that each unit is sold for $40. (1.5pt) 2. Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory in the beginning of July was only 600 units....
XYZ Company has budgeted production of Item #123 for April, May, and June of 2,400, 3,200,...
XYZ Company has budgeted production of Item #123 for April, May, and June of 2,400, 3,200, and 2,800 units, respectively. XYZ Company currently pays a standard rate of $3 per foot for raw material A and $5 per sheet for raw material B. Each unit produced requires 4 feet of raw material A and 2 sheets of raw material B. Each unit produced also requires 30 minutes of cutting direct labor time at a standard rate of $16 per hour...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT