Question

In: Accounting

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 $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 as follows:

April $32,000
May 45,000
June 56,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 $ $

Solutions

Expert Solution

Solution:

Rosita's Mexican Restaurant
Schedule of Cash Receipts
For the Months of May and June
May June
Cash sales: 36000 44800
Checks 8672 10792
Total 44672 55592


Related Solutions

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.60 per check; the amount per check averages $90. “Bad” checks that Rosita cannot collect make up 2 percent of check revenue. During a typical month, Rosita's has sales of $46,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. Checks are deposited immediately. The bank charges $0.60 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 $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. Checks are deposited immediately. The bank charges $0.60 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 $49,000. About 80 percent are cash sales. Estimated sales for the next three months are...
Use the schedule for cash receipts and the schedule for cash payments provided to complete a...
Use the schedule for cash receipts and the schedule for cash payments provided to complete a cash budget for M.K.H.M., Inc. Additional Information: M.K.H.M.’s beginning cash balance is $5,000 and M.K.H.M. desires to maintain a minimum ending cash balance of $5,000. M.K.H.M. borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The interest rates on amounts...
MILESTONE I: Complete the Cash Budget (Cash Receipts Schedule & Cash Payments Schedule) of Archer Electronics...
MILESTONE I: Complete the Cash Budget (Cash Receipts Schedule & Cash Payments Schedule) of Archer Electronics Company Archer Electronics Company's actual sales and purchases for April and May are shown here along with forecast sales and purchases for June through September: The company makes 20 percent of its sales for cash and 80 percent on credit. Of the credit sales, 50 percent are collected in the month after the sale and 50 percent are collected two months later. Archer pays...
The following schedule of cash receipts and payments relates to Yellowstone, Inc. for the year 20X8:...
The following schedule of cash receipts and payments relates to Yellowstone, Inc. for the year 20X8: Cash receipts: From customers $348,000 From issuance of bonds payable 162,000 From sale of delivery truck 9,000 Cash payments: For purchase of equipment $ 70,800 To employees and suppliers 246,000 For interest expense 17,400 To shareholders for dividends 74,400 For purchase of treasury stock 14,400 For income taxes 21,600 Required: What is the cash flow from operations for Yellowstone, Inc. for 20X8?
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...
1. Karl Corp. is preparing a schedule of cash receipts and disbursements for Year 4. Which...
1. Karl Corp. is preparing a schedule of cash receipts and disbursements for Year 4. Which of the following items should be included? I.Borrowing funds from a bank on a note payable taken out in August Year 4 and agreeing co pay the principal and interest in July Year 5 II.Dividends declared in October Year 4 co be paid in January Year 5 co shareholders of record as of December Year 4 (A)I only, (B)II only ,(C)Both I and II,...
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...
Prepare a quarterly schedule of cash receipts budget for PEPSI Company for the year ended December...
Prepare a quarterly schedule of cash receipts budget for PEPSI Company for the year ended December 31, 2021, including the following schedules: Sales Budget (ALREADY DONE) & Schedule of Cash Receipts (NEED HELP WITH THIS) Pepsi Company Sales Budget For Year ended December 31,2021 Q1 Q2 Q3 Q4 Total Budgeted Sales in units 4,500 16,500 6,000 3,000 30,000 Selling Price per unit $290 $290.00 $290.00 $290.00 $290 Total budgeted sales $1,305,000 $4,785,000.00 $1,740,000.00 $870,000.00 $8,700,000 Relevant Info Dougs sales forecast...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT