Question

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: August $122,000 September 153,000 October 223,000 The Accounts Receivable balance on July 31, 2016, was $82,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.

Answer 1

Schedule of cash collection

	August	September	October
Cash Sales	30500	38250	55750
Collection on Credit sales
25% of month sale	22875	28688	41813
75% of previous month sale		68625	86062
Total cash collection	53375	135563	183625