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 are as follows:

October $700,000
November $65,000
December $500,000

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

Required:
Prepare a schedule of cash collections from sales for October, November, and December.

                                    Office World Inc.

                                     Cash budget

                                       Amount in $

October                            469,375 .00  

November                        422,187.50

December                        255,312.5 0

Explanation:

The schedule of cash collections for each month will be as spelt out below; 25% of monthly sales, 25% * 75% of the monthly sales and 75% * 75% of the sales in the prior month.

Hence, Cash collection for

October

= 25% * $700,000 + 25% * 75% * $700,000 + 75% * 75% * $290,000

= $469,375

November

= 25% * $65,000 + 25% * 75% * $65,000 + 75% * 75% * $700,000

= $422,187.50

December

= 25% * $500,000 + 25% * 75% * $500,000 + 75% * 75% * $65,000

= $255,312.5 0

1) the stages a new product goes through from beginning to end, i.e., the stages that a product passes through from introduction through growth, maturity, and decline. 2) the time from initial research and development to the time at which sales and support of the product to customers are withdrawn. 3) the period of time during which a product can be produced and marketed profitably.

                                          hope it