Question

XYZ Company usually sells about 40% of its merchandise during a month for cash, 40% collected...

XYZ Company usually sells about 40% of its merchandise during a month for cash, 40% collected in the month after sale, and 10% in two months after the sale – 10% of the sales are never collected. Total budgeted sales for the second quarter are as follows:

April

$200,000

May

100,000

June

150,000

Assume all questions relate to the month of June.

1.

What are the expected receipts in June from accounts receivable for sales made in April?

2.

What are the expected receipts in June from accounts receivable for sales made in May?

3.

What are the total expected cash receipts in June?

Homework Answers

Answer #1
Answer 1
The expected receipts in June from accounts receivable for sales made in April = April sales * 10% = $200000 * 10% = $20,000
Answer 2
The expected receipts in June from accounts receivable for sales made in May = May Sales * 40% = $100000 * 40% = $40,000
Answer 3
The total expected cash receipts in June
April sales collection $20,000
May sales collection $40,000
June sales collection [$150000 * 40%] $60,000
Total expected cash receipts in June $120,000
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
Jasper Company has sales on account and for cash. Specifically, 61% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 61% of its sales are on account and 39% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $519,000 for April, $529,000 for May, and $554,000 for June. The beginning balance of Accounts Receivable is $292,800 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 39% Sales on...
Jasper Company has sales on account and for cash. Specifically, 57% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 57% of its sales are on account and 43% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $532,000 for April, $542,000 for May, and $567,000 for June. The beginning balance of Accounts Receivable is $302,100 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April May June Cash sales 43% Sales on...
Jasper Company has sales on account and for cash. Specifically, 64% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 64% of its sales are on account and 36% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $518,000 for April, $528,000 for May, and $553,000 for June. The beginning balance of Accounts Receivable is $293,500 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June Answer is not complete. April May June Cash...
Exercise 20-18 Budgeted cash receipts LO P2 Jasper Company has sales on account and for cash....
Exercise 20-18 Budgeted cash receipts LO P2 Jasper Company has sales on account and for cash. Specifically, 62% of its sales are on account and 38% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $528,000 for April, $538,000 for May, and $563,000 for June. The beginning balance of Accounts Receivable is $308,900 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June. April...
Jasper Company has sales on account and for cash. Specifically, 60% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 60% of its sales are on account and 40% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $516,000 for April, $526,000 for May, and $551,000 for June. The beginning balance of Accounts Receivable is $295,500 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June.
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 55,000 Accounts receivable 36,000 Inventory 40,000 Buildings and equipment, net of depreciation 100,000 Total assets $ 231,000 Liabilities and Stockholders’ Equity Accounts payable $ 51,300 Common stock 70,000 Retained earnings 109,700 Total liabilities and stockholders’ equity $ 231,000 Budgeted Income Statements April May June Sales $ 100,000 $...
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...
Jasper Company has sales on account and for cash. Specifically, 56% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 56% of its sales are on account and 44% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $519,000 for April, $529,000 for May, and $554,000 for June. The beginning balance of Accounts Receivable is $309,100 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June.
Jasper Company has sales on account and for cash. Specifically, 62% of its sales are on...
Jasper Company has sales on account and for cash. Specifically, 62% of its sales are on account and 38% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $532,000 for April, $542,000 for May, and $567,000 for June. The beginning balance of Accounts Receivable is $308,500 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June.
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer...
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer Prime Products has just approached the company’s bank with a request for a $51,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT