Question

Schedule of Cash Collections of Accounts Receivable Office World Inc. has "cash and carry" customers and credit customers. Office World 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 of 2016 are as follows: August $129,000 161,000 September October 236,000 The Accounts Receivable balance on July 31, 2016, was $86,000 Prepare a schedule of cash collections from sales for August, September, and October. Round all calculations to the nearest whole dollar. Office World Inc. Schedule of Collections from Sales For the Three Months Ending October 31, 2016 September 0ctober August Receipts from cash sales: Cash sales July sales on account: Collected in August August sales on account: Collected in August Collected in September September sales on account: Collected in September Collected in October October sales on account: Collected in October Total cash receipts

Answer 1

Office world Inc.

Schedule of collection from sales (in $)

for the three months ending October 31, 2016.

	August	September	October
Receipt from Cash sales:
Cash sales	129,000×30% = $ 38,700	161,000×30% = $ 48,300	236,000×30% = $ 70,800
JULY sales on account:
Collected in August	$ 86,000*	0	0
AUGUST sales on account:
Collected in August	129,000×70%×25% = $ 22,575	0	0
Collected in September	0	129,000×70%×75% = $ 67,725	0
SEPTEMBER sales on account:
Collected in September	0	161,000×70%×25% = $ 28,175	0
Collected in October	0	0	161,000×70%×75% = $ 84,525
OCTOBER sales on account:
Collected in October	0	0	236,000×70%×25% = $ 41,300
TOTAL CASH RECEIPT	$ 147,275	$ 144,200	$ 196,625

* total $ 86,000 was collected in August.