Question

One hundred per cent (100%) of sales made by a firm is sold on credit. Experience...

One hundred per cent (100%) of sales made by a firm is sold on credit. Experience shows the firm collects cash for 30% of credit sales in the month of the sale, 50% in the following month, and the remaining 20% the month after.

The total sales achieved in June and July were $6,000 and $7,000 and the budget for August, September and October are $8,000, $7,500 and $7,500 respectively.

Required:

Produce a Schedule of Receipts showing the expected cash collections for August, September and October.

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Schedule of Receipts

For August, September and October

August September October
Cash collection fron June sales 6,000 x 20% = 1,200 0 0
Cash collection fron July sales 7,000 x 50% = 3,500 7,000 x 20% = 1,400 0
Cash collection fron August sales 8,000 x 30% = 2,400 8,000 x 50% = 4,000 8,000 x 20% = 1,600
Cash collection fron September sales 0 7,500 x 30% = 2,250 7,500 x 50% = 3,750
Cash collection fron October sales 0 0 7,500 x 30% = 2,250
Total cash collection $7,100 $7,650 $7,600
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and...
Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 20% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months of 2016 are as follows: August $122,000...
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August,...
Beech’s managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $280,000, $300,000, $290,000, and $310,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month’s credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at June 30 will be collected in July. 3. Each month’s ending inventory must equal 25%...
ABC Company was organized on August 1 of the current year. Projected sales for the next...
ABC Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August   $250,000 September     200,000 October     275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on account, 30% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections for August, September, and October. ABC Company Schedule of Collections from Sales...
Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units...
Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 4,500 $ 810,000 May (actual) 2,200 396,000 June (budgeted) 7,500 1,350,000 July (budgeted) 5,000 900,000 August (budgeted) 3,600 648,000 All sales are on credit. Recent experience shows that 30% of credit sales is collected in the month of the sale, 40% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible....
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March $43,000 June $47,000 April 49,000 July 55,000 May 38,000 August 57,000 Sales in January and February were $46,000 and $45,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 35 percent are collected in the month of sale, 45 percent are collected in the following month, and 10 percent are collected two months after sale. a. Prepare a...
Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services...
Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services firm. All sales of legal services are billed to the client (there are no cash sales). Kailua expects that, on average, 20% will be paid in the month of billing, 50% will be paid in the month following billing, and 25% will be paid in the second month following billing. For the next five months, the following sales billings are expected: May $84,000 June...
Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services...
Preparing a Schedule of Cash Collections on Accounts Receivable Kailua and Company is a legal services firm. All sales of legal services are billed to the client (there are no cash sales). Kailua expects that, on average, 20% will be paid in the month of billing, 50% will be paid in the month following billing, and 25% will be paid in the second month following billing. For the next 5 months, the following sales billings are expected: May $84,000 June...
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...
Bluebird Ltd has provided the following forecasted items for the months of July through to September...
Bluebird Ltd has provided the following forecasted items for the months of July through to September 2020. July August September $ $ $ Sales 13,000 14,000 15,000 Purchases 9,400 8,000 10,000 Operating expenses 3,600 6,400 5,000 Other Information: • 35% of Sales are cash sales, the remaining 65% of credit sales which are collected as follows: o 30% in the month of the sale o 40% in the month after the sale o 28% in the 2nd month after the...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were...
C. The Sun Pacific Company budgeted the following sales: July​​200,000 August​​210,000 September​190,000 Sales in May were 190,000 and in June 180,000. 60% of sales are cash, 30% of sales are to be collected the next month, and the remaining 10% in 2 months. Budgeted purchases of the required materials for production are: July​​100,000 August​​105,000 September​95,000 Purchases in June were 90,000. 70% of purchases are cash and 30% should be paid the next month. Direct Labor is 35% of purchases Selling...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT