Ask Question
15 August, 01:01

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.

+5
Answers (1)
  1. 15 August, 01:17
    0
    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
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 25% of monthly sales are to cash ...” in 📗 Business if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers