Question

Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...

Schedule of Cash Collections of Accounts Receivable

OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% 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 are as follows:

October $117,000
November 146,000
December 214,000

The Accounts Receivable balance on September 30 was $78,000.

Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.

OfficeMart Inc.
Schedule of Cash Collections from Sales
For the Three Months Ending December 31
October November December
Receipts from cash sales:
Cash sales $ $ $
September sales on account:
Collected in October
October sales on account:
Collected in October
Collected in November
November sales on account:
Collected in November
Collected in December
December sales on account:
Collected in December
Total cash receipts $ $ $

Homework Answers

Answer #1
OfficeMart Inc.
Schedule of cash collection from sales
For the 3 months ending December 31
October November December
Receipt from cash sales:
Cash sales $35,100 $43,800 $64,200
September sales on account:
Collected in october $78,000
October sales on account:($117,000-$35,100)
Collected in october $16,380
Collected in November $65,520
November sales on account:($146,000-$43,800)
Collected in November $20,440
Collected in December $81,760
December sales on account:($214,000-$64,200)
Collected in December $29,960
Total Cash receipts $1,29,480 $1,29,760 $1,75,920
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% 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 are as follows: October $123,000 November 154,000 December 225,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $107,000 November 134,000 December 196,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 20% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $107,000 November 134,000 December 196,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% 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 are as follows: October $129,000 November 161,000 December 236,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $128,000 November 160,000 December 234,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% 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 are as follows: October $131,000 November 164,000 December 240,000...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit...
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $121,000 November 151,000 December 221,000...
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly...
OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 30% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $129,000 November 161,000 December 236,000 The Accounts Receivable balance on September 30...
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...
2. The treasurer of Yoda Inc. needs to estimate cash collections from accounts receivable for September,...
2. The treasurer of Yoda Inc. needs to estimate cash collections from accounts receivable for September, October, and November 2017. Forty percent of the company’s customer’s pay in cash the rest are credit customers. The collection pattern for the credit customers is 20% in the month of the sale and 80% in the following month. They have zero uncollectible accounts. Estimated total sales are as follows: August $78000 September 80,000 October. 95,000 November 91,000 Q: What is Yoda’s cash collections...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT