Schedule of Cash Collections of Accounts Receivable Office World Inc. has \"cash

Question

Schedule of Cash Collections of Accounts Receivable

Office World Inc. has "cash and carry" customers and credit customers. Office World 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 of 2016 are as follows:

The Accounts Receivable balance on July 31, 2016, was $83,000.

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

For the Three Months Ending October 31, 2016

August September October

Collected in August ______

Explanation / Answer

Office World Inc. Schedule of Collections from Sales For the Three Months Ending October 31, 2016 Particluars Aug-16 Sep-16 Oct-16 Projected Sales $    124,000.00 $    155,000.00 $    227,000.00 Receipts from Cash Sales: Cash sales $      31,000.00 $      38,750.00 $      56,750.00 July Sales on Account: Collected in August $      83,000.00 August Sales on Account: Collected in August $      23,250.00 Collected in September $      69,750.00 September Sales on Account: Collected in September $      29,062.50 Collected in October $      87,187.50 October Sales on Account: Collected in October $      42,562.50 Total Cash Receipts $    137,250.00 $    137,562.50 $    186,500.00

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.