The Handel Company has obtained the following sales forecast data:
July August September October
Cash sales ..... $ 80,000 $ 70,000 $ 50,000 $ 60,000
Credit sales ... $260,000 $220,000 $200,000 $220,000
The regular pattern of collection of credit sales is 20% in the
month of sale, 70% in the month following the month of sale, and
the remainder (10%) in the second month following the month of
sale. There are no bad debts.
The budgeted accounts receivable balance on September 30 is:
| a. |
$196,000 |
|
| b. |
$182,000 |
|
| c. |
$148,000 |
|
| d. |
$126,000 |
The budgeted cash receipts for October are:
| a. |
$206,000 |
|
| b. |
$220,000 |
|
| c. |
$266,000 |
|
| d. |
$280,000 |
The Handel Company has obtained the following sales forecast data: July August September October Cash sales...
Scottsdale Co. has actual sales for July and August and forecast sales for September October, November, and December as follows: $ 98,900 105,200 Actual: July August Forecast September October November December 114,200 94,300 121, 3ee 107,400 Based on past experience, it is estimated that 28% of a month's sales are collected in the month of sale, 49% are collected in the month following the sale, and 6% are collected in the second month following the sale. Required: Calculate the estimated...
Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,300 August 105,300 Forecast: September 114,800 October 94,300 November 122,900 December 106,300 Based on past experience, it is estimated that 29% of a month’s sales are collected in the month of sale, 48% are collected in the month following the sale, and 9% are collected in the second month following the sale. Required: Calculate the estimated cash...
Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,100 August 105,100 Forecast: September 114,200 October 94,500 November 121,900 December 107,000 Based on past experience, it is estimated that 24% of a month’s sales are collected in the month of sale, 46% are collected in the month following the sale, and 5% are collected in the second month following the sale. Required: Calculate the estimated cash...
Wells Company reports the following sales forecast: September, $60,000; October, $75,000; and November, $90,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November. WELLS COMPANY Budgeted Cash Receipts For Month Ended November 30 Cash receipts from November...
Wells Company reports the following sales forecast: September $60.000; October $71000; and November, 57 . A Sores are account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November 11111 00 WELLS COMPANY Budgeted Cash Receipts For Month Ended November 30 Cash recepts...
Question 1 2 pts Crane Company has the following sales data: August September October November December Cash Sales $4000 $5000 $6000 $7000 $16000 Sales on Account $50000 $57,755 $65000 $71,288 $100000 Crane Company's credit customers have the following payment history: 38% in month of sale 59% in month following sale the rest are never collected What are budgeted cash receipts for September?
Meredith Company has budgeted sales for the upcoming months as follows: April May June July August September $451,000 $ 468,000 $ 496,000 $518, 000 $504,000 $481,000 30% 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.) Cash Receipts...
A company has the following budgeted sales: July $200,000 August $300,000 September $250,000 20% of the sales are for cash, and 80% are on credit. 25% of the credit sales are collected in the month of sale, and 75% are collected the next month. What are the total expected cash receipts during September?
A company has the following budgeted sales: July $200,000 August $300,000 September $250,000 20% of the sales are for cash, and 80% are on credit. 25% of the credit sales are collected in the month of sale, and 75% are collected the next month. What are the total expected cash receipts during September?
QS 20-19 Cash receipts LO P2 Music World reports the following sales forecast: August, $130,000; and September, $200,000. Cash sales are normally 50% of total sales and all credit sales are expected to be collected in the month following the date of sale. Prepare a schedule of cash receipts for September MUSIC WORLD Cash Receipts Budget For Month Ended September 30 September cash sales Collection of accounts receivable Total budgeted cash receipts