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

April $32,000
May 49,000
June 59,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

Schedule of cash collections May June
Cash sales           39,200           47,200
Checks             9,310           11,210
Total           48,510           58,410
May June
Check amount             9,800           11,800
Total checks                131                157
Bank charge                  98                118
Bad debt                392                472
Check gross amount             9,800           11,800
Less: expenses                490                590
Collection             9,310           11,210

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