Question

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 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 Ans

a).credit sales for May.
$2,90,000*55%=1,59,500$

b) credit sales for June.
$2,80,000*55%=1,54,000$

c) credit sales for July.
$2,95,000*55$=1,62,250$

d) credit sales for August.
$3,00,000*55%=1,65,000$

2 Ans

July

August

Cash sales

2,95,000*45%

3,00,000*45%

$1,32,750

$1,35,000

Payments on account:

From May credit sales:

$ 1,59,500×5 %

$7,975

----

From June credit sales:

$ 1,54,000×68 %

$1,04,720

----

$ 1,54,000×5%

----

$7,700

From July credit sales:

$1,62,250 ×25 %

$40,563

-----

$1,62,250 ×68 %

----

$1,10,330

From August credit sales:

$ 1,65,000×25 %

----

$41,250

Cash receipts

$2,86,008

$2,94,280

:

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 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...
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...
Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services...
Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services firm. All sales of legal services are billed to the client (there are no cash sales). Kailua expects that, on average, 20% will be paid in the month of billing, 50% will be paid in the month following billing, and 25% will be paid in the second month following billing. For the next five months, the following sales billings are expected: May $84,000 June...
Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services...
Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services firm. All sales of legal services are billed to the client (there are no cash sales). Kailua expects that, on average, 20% will be paid in the month of billing, 50% will be paid in the month following billing, and 25% will be paid in the second month following billing. For the next 5 months, the following sales billings are expected: May $84,000 June...