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 $45,000. About 80 percent are cash sales. Estimated sales for the next three months are as follows:

April $32,000
May 45,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 $ $
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

Rosita's Mexican Restaurant

Schedule of Cash Receipts

For the Months of May and June

Particulars Calculations May Calculations June
Cash sales (45,000*80%) $36,000 (54.000*80%) $43,200
Checks:
Amount to be received (45,000*20%) $9,000 (54,000*20%) $10,800
Bad debts (9,000*4%) ($360) (10,800*4%) ($432)
Bank charges (9,000/75*0.70) ($84) (10,800/75*0.70) ($101)
Total checks $8,556 $10,267
Total cash receipts (Cash sales + Total checks) $44,556 $53,467
Add a comment
Know the answer?
Add Answer to:
Schedule of Cash Receipts Rosita Flores owns Rosita's Mexican Restaurant in Tempe, Arizona. Rosita's is an...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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.50 per check; the amount per check averages $80. "Bad" checks that Rosita cannot collect make up 2 percent of check revenue. During a typical month, Rosita's has sales of $49,000. About 80 percent are cash sales. Estimated sales for the next three months are...

  • 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. Checies are deposited immediately. The bank charges $0.50 per check; the amount per check averages $75. "Bad" checks that Rosita cannot collect make up 3 percent of check revenue. During a typical month, Rosita's has sales of $45,000. About 80 percent are cash sales. Estimated sales for the next three months are...

  • Schedule of Cash Receipts Del Spencer is the owner and founder of Del Spencer's Men's Clothing...

    Schedule of Cash Receipts Del Spencer is the owner and founder of Del Spencer's Men's Clothing Store. Del Spencer's has its own house charge accounts and has found from past experience that 10 percent of its sales are for cash. The remaining 90 percent are on credit. An aging schedule for accounts receivable reveals the following pattern: 15 percent of credit sales are paid in the month of sale. 65 percent of credit sales are paid in the first month...

  • Schedule of Cash Receipts Del Spencer is the owner and founder of Del Spencer's Men's Clothing...

    Schedule of Cash Receipts Del Spencer is the owner and founder of Del Spencer's Men's Clothing Store. Del Spencer's has its own house charge accounts and has found from past experience that 10 percent of its sales are for cash. The remaining 90 percent are on credit. An aging schedule for accounts receivable reveals the following pattern: 15 percent of credit sales are paid in the month of sale. 65 percent of credit sales are paid in the first month...

  • 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...

  • 8 Schedule of Cash Collections on Accounts Receivable and Cash Budget Roybal Inc. sells all of...

    8 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 Percent paid in the month after the sale Percent paid in the second month after the sale 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 $275,500 May...

  • 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 $140,000 June 140,000 July 180,000 August 120,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 1...

  • Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 15%...

    Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 15% 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 30% of its sales...

    Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 30% 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 Percent paid in the second month after the sale Bennett's anticipated sales for the next few months are as follows: April $250,000 May 290,000 June 280,000 July 295,000 300,000 August Required:...

  • Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May...

    Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150.000 June 175,000 July 160,000 August 200.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....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT