Question

Bennett Inc. found that about 25% of its sales during the month were for cash. Bennett...

Bennett Inc. found that about 25% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience:

Percent paid in the month of sale 25
Percent paid in the month after the sale 68
Percent paid in the second month after the sale 5

Bennett's anticipated sales for the next few months are as follows:

April $250,000
May 290,000
June 280,000
July 295,000
August 300,000

Required:

1. Calculate credit sales for May.
$

Calculate credit sales for June.
$

Calculate credit sales for July.
$

Calculate credit sales for August.
$

2. Prepare a schedule of cash receipts for July and August. Round your answers to the nearest whole dollar, if necessary. If an amount box does not require an entry, leave it blank or enter "0". Be sure to enter percentages as whole numbers.

Bennett Inc.
Schedule of Cash Receipts
For July and August
July August
Cash sales $ $
Payments on account:
From May credit sales:
$_____ ×  %______
From June credit sales:
$______ ×  %_______
$ _____×  %_______
From July credit sales:
$_______ ×  %_______
$________ ×  %______
From August credit sales:
$ _____×  %_____
Cash receipts $ $

Homework Answers

Answer #1

1. Cash sales in the month accounts for 25%, therefore 75% is the credit sales in the respective month.

Credit sales for May: 2,90,000 x 75% = 2,17,500

Credit sales for June: 2,80000 x 75% = 2,10,000

Credit sales for July: 2,95,000 x 75% = 2,21,250

Credit sales for August: 3,00,000 x 75% = 2,25,000

2. Schedule of cash reciepts for July and August

Please comment in case of any doubts.

Kindly rate the answer. Thank you :-)

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
Bennett Inc. found that about 45% of its sales during the month were for cash. Bennett...
Bennett Inc. found that about 45% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August 300,000 Required: 1. Calculate credit sales for May. $ Calculate...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 35%...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 35% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 40%...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 40% of its sales during the month were for cash. Bennett has the following accounts receivable payment experience: Percent paid in the month of sale 25 Percent paid in the month after the sale 68 Percent paid in the second month after the sale 5 Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 August...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its...
Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April...
Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment...
Roybal Inc. sells all of its product on account. Roybal has the following accounts receivable payment experience: Percent paid in the month of sale 20 Percent paid in the month after the sale 55 Percent paid in the second month after the sale 23 To encourage payment in the month of sale, Roybal gives a 2% cash discount. Roybal's anticipated sales for the next few months are as follows: April $209,000 May 272,800 June 286,000 July 264,000 August 330,000 Required:...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June...
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding the cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2 percent...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March $43,000 June $47,000 April 49,000 July 55,000 May 38,000 August 57,000 Sales in January and February were $46,000 and $45,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 35 percent are collected in the month of sale, 45 percent are collected in the following month, and 10 percent are collected two months after sale. a. Prepare a...
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and...
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 20% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months of 2016 are as follows: August $122,000...
Month Sales Purchases Cash Expenses Paid May $ 94,000 $ 61,000 $ 18,000 June 116,000 90,000...
Month Sales Purchases Cash Expenses Paid May $ 94,000 $ 61,000 $ 18,000 June 116,000 90,000 26,000 July 135,000 114,000 37,750 August 134,000 70,000 30,800 The majority of Martin’s sales (65 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin’s purchases are on account with 50 percent paid in the month...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT