Ask Experts Questions for FREE Help !
Ask
    finmang1's Avatar
    finmang1 Posts: 13, Reputation: 1
    New Member
     
    #1

    Aug 25, 2009, 12:56 PM
    Cash Collections in accounting
    I have the answer but need help with the solution. This is the scenario: Sales on account are collected over a 3 month period 10% collected in the month of sale, 70% collected in the month following sale, and 18% collected in the second month following sale. The remaiining 2% in uncollectible. The company maintains a minium cash balance of 5k. The sales are as followed:

    July August September
    6500.00 5250.00 7400.00 Cash sales

    20,000.00 30,000.00 40,000.00 Sales on acct
    -----------------------------------------
    26,500.00 35250.00 47,400.00 Total sales

    Question: Prepare a schedule of expected cash collections for Sept.
    Answers:
    July 3,600.00 August 21,000.00 Sept 4,000.00
    I am having a difficult time figuring out the acct receivable for July and the equation for the answers. Thanks!:)
    ArcSine's Avatar
    ArcSine Posts: 969, Reputation: 106
    Senior Member
     
    #2

    Aug 25, 2009, 02:28 PM
    Sep's cash collections will be the sum of four amounts...

    Sep's cash sales;
    10% of Sep's credit sales (sales on account);
    70% of Aug's credit sales;
    18% of Jul's credit sales.

    In fact, you've already noted those last three amounts in your question. Can you take it from here?
    finmang1's Avatar
    finmang1 Posts: 13, Reputation: 1
    New Member
     
    #3

    Aug 26, 2009, 10:01 AM
    Quote Originally Posted by ArcSine View Post
    Sep's cash collections will be the sum of four amounts...

    Sep's cash sales;
    10% of Sep's credit sales (sales on account);
    70% of Aug's credit sales;
    18% of Jul's credit sales.

    In fact, you've already noted those last three amounts in your question. Can you take it from here?
    Thank you so much I got it!!
    ArcSine's Avatar
    ArcSine Posts: 969, Reputation: 106
    Senior Member
     
    #4

    Aug 26, 2009, 10:10 AM
    ;)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Cash Collections Budget [ 1 Answers ]

I have been working on this problem for three hours, and for some reason, none of my answers make sense. Could someone please help me find the correct answer? The problem reads: Cash Sales: March $30,000 June $45,000 Sept. $37,500

Expected cash collections-Managerial Accounting [ 1 Answers ]

A homework question is asking to create expected cash collections for September, but it breaks down cash sales and sales on account for July, August, September. July and August numbers are actual and sept are expected. My question is do I ignore the cash sales to prepare the expected cash...

The Cash Collections are given below. Answer the 2 questions [ 1 Answers ]

Cash Collections. The following data are given for Erich From Stores: Sept, Actual Oct, Actual Nov, Actual Dec, Actual Cash Sales $7000 $6000 $8000 $6000 Credit Sales $50000 $48000 $62000 $80000 Total Sales $57000 $54000 ...

Cash collections [ 1 Answers ]

All sales at Meeks Company, a wholesaler, are made on credit. Experience has shown that 70% of the accounts receivable are collected in the month of the sale, 26% are collected in the month following the sale, and the remaining 4% are uncollectible. Actual sales for March and budgeted sales for...


View more questions Search