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

    Jul 29, 2008, 07:58 AM
    Cash Budget/Cash Receipts
    1) Rushmore Kitchen Supply has forecast credit sales for the fourth quarter of the year as:
    March(actual) $75,000
    Fourth Quarter - projected
    April $80,000
    May $70,000
    June $75,000
    Experience has shown that 30 percent of sales are collected in the month of sale, 60 percent in the following month, and 10 percent are never collected.
    Required:
    Prepare a schedule of cash receipts for Rushmore Kitchen Supply for the first quarter.

    Here is my work... does it look like I am on the right track??

    April May June
    80,000 70,000 75,000
    Collections, 30% in current month 24,000 21,000 22,500
    Collections, 60% in the following month 0 48,000 42,000
    Collections, 10% never collected 2,400 6,900 6,450
    Total Cash receipts 21,600 62,100 58,050
    CliffARobinson's Avatar
    CliffARobinson Posts: 1,416, Reputation: 101
    Ultra Member
     
    #2

    Mar 11, 2012, 05:12 PM
    Your math is accurate. I would suggest using this Cash Flow Forecasting tool to assist you with calculations.

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!

Monthly schedule of cash receipts/balance AR [ 1 Answers ]

Ellis Sport Shop projects the following sales: Ninety percent of Ellis' sales are on credit with 60 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale. February sales were $60,000 and March sales were...

Cash Receipts and Accounts Receivables [ 1 Answers ]

-------------------------------------------------------------------------------- Ellis Sport Shop projects the following sales: Ninety percent of Ellis' sales are on credit with 60 percent of receivables collected in the month after the sale and the rest of receivables collected in the...

Cash receipts journal [ 2 Answers ]

OK.. i.m using a cash reciepts journal.. and the transaction is... "recieved cash on account from wayne miller for chairs purchased may 25on s147 for $157.50, less discount (2%)." OK.. i.m so confused.. where does everything go?? Please help..


View more questions Search