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 | $ | $ |
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 |
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 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 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 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 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 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 $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% 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 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 $ 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....