Question

Schedule of Cash Receipts Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an...

Schedule of Cash Receipts

Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an affordable restaurant near campus and several hotels. Rosita accepts cash and checks. Checks are deposited immediately. The bank charges $0.70 per check; the amount per check averages $75. “Bad” checks that Rosita cannot collect make up 4 percent of check revenue.

During a typical month, Rosita's has sales of $44,000. About 80 percent are cash sales. Estimated sales for the next three months are as follows:

April $33,000
May 44,000
June 54,000

Required:

Prepare a schedule of cash receipts for May and June. Round your intermediate computations and final answers to the nearest whole dollar.

Rosita's Mexican Restaurant
Schedule of Cash Receipts
For the Months of May and June
May June
Cash sales: $ $
Checks
Total $ $

Homework Answers

Answer #1
Prepare the schedule of cash receipts for the month of May and June (Amount in $)
Particulars May June
Cash sales [a] 35200 44000*80% 43200 54000*80%
Checks
Amount to be received through bank 8800 44000*20% 10800 54000*20%
Bad debts -352 8800*4% -432 10800*4%
Bank charges -82 8800/75*0.70 -101 10800/75*0.70
Total[b] 8366 10267
Total cash receipts [a]+[b] 43566 53467
Note :
Amount to be received through check is 20% of sales
Bad debt expense is 4% of amount received through check
Bank charges are 0.70 per check value of 75
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
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...
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...
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...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $330,000 June 470,000 July 660,000 All sales are on account. 56 percent of sales are expected to be collected in the month of the sale, 33% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $270,000 June 410,000 July 600,000 All sales are on account. 59 percent of sales are expected to be collected in the month of the sale, 29% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $340,000 June 400,000 July 530,000 All sales are on account. 54 percent of sales are expected to be collected in the month of the sale, 36% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...
1) Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier,...
1) Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $240,000 June 340,000 July 510,000 All sales are on account. 52 percent of sales are expected to be collected in the month of the sale, 37% in the month following the sale, and the remainder in the second month following the sale. Prepare a...
1) Schedule of Cash Payments for a Service Company SafeMark Financial Inc. was organized on February...
1) Schedule of Cash Payments for a Service Company SafeMark Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $165,600 April 152,400 May 138,700 Depreciation, insurance, and property taxes represent $35,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 63% of the remainder of the expenses are...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $190,000 June 270,000 July 350,000 All sales are on account. 51 percent of sales are expected to be collected in the month of the sale, 37% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...