Question

In: Accounting

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 following the sale.
14 percent of credit sales are paid in the second month following the sale.
6 percent of credit sales are never collected.

Credit sales that have not been paid until the second month following the sale are considered overdue and are subject to a 3 percent late charge.

Del Spencer's has developed the following sales forecast:

May $60,000
June 55,000
July 45,000
August 56,000
September 82,000

Required:

Prepare a schedule of cash receipts for August and September. Round all amounts to the nearest dollar.

Del Spencer's Men's Clothing Store
Schedule of Cash Receipts
For the Months of August and September
August September
Cash sales $ $
Received from sales in:
June:
July:
August:
September:
Total cash receipts $ $

Solutions

Expert Solution

Solution

Del Spencer's Men's Clothing Store
Schedule of Cash Receipts
For the Months of August and September
August September
Cash sales $         5,600.00 $       8,200.00
Received from sales in:
June: $         6,930.00
July: $       26,325.00 $       5,670.00
August: $         7,560.00 $      32,760.00
September: $      11,070.00
Total cash receipts $       46,415.00 $      57,700.00

Working

May June July   August September
Sales $           60,000.00 $          55,000.00 $        45,000.00 $        56,000.00 $ 82,000.00
Cash sales $             6,000.00 $            5,500.00 $           4,500.00 $          5,600.00 $    8,200.00
Credit sales $           54,000.00 $          49,500.00 $        40,500.00 $        50,400.00 $ 73,800.00

Related Solutions

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...
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...
Del Gato Clinic deposits all cash receipts on the day when they are received and it...
Del Gato Clinic deposits all cash receipts on the day when they are received and it makes all cash payments by check. At the close of business on June 30, 2017, its Cash account shows an $12,286 debit balance. Del Gato Clinic’s June 30 bank statement shows $12,524 on deposit in the bank. Outstanding checks as of June 30 total $2,740. The June 30 bank statement lists a $95 service charge. Check No. 919, listed with the canceled checks, was...
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...
Question 3 – Statement of Cash Flows Nick Ltd is the founder and owner of a...
Question 3 – Statement of Cash Flows Nick Ltd is the founder and owner of a health club. His club operates in Toronto, Ontario and has been in the same location since 2014. The health club offers a variety of services to its members (group classes, personal training etc.). The club also will put on special “fitness” events. The fitness facility has everything - free weights, squat racks, cardio machines (treadmills, bikes and ellipticals), yoga mats, stability balls, pull-up bars,...
– Statement of Cash Flows Nick Ltd is the founder and owner of a health club....
– Statement of Cash Flows Nick Ltd is the founder and owner of a health club. His club operates in Toronto, Ontario and has been in the same location since 2014. The health club offers a variety of services to its members (group classes, personal training etc.). The club also will put on special “fitness” events. The fitness facility has everything - free weights, squat racks, cardio machines (treadmills, bikes and ellipticals), yoga mats, stability balls, pull-up bars, etc. Since...
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?
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,...
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...
Kids ’n Caboodle, a children’s clothing store, had the following cash receipts and disbursements for its...
Kids ’n Caboodle, a children’s clothing store, had the following cash receipts and disbursements for its first year of operations: Receipts: Cash sales $155,000 Loan proceeds ___2_1_,_0_0_0_ Total receipts ____1__7__6__,__0__0__0__ Disbursements Merchandise purchases (all sold this year) 84,000 Wages 33,000 Rent and lease payments 22,000 Other operating outlays 7,900 Purchase equipment ___1_0_,_5_0_0_ Total disbursements __1_5_7_,_4_0_0_ Increase in Cash Balance $______1__8__,__6__0__0__ The store has no accounts receivable (it accepts only cash or bank cards for payment). At year-end, an employee had...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT