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

    Feb 23, 2013, 12:51 PM
    cash collections budget
    (Budgeted Cash Collections - LO4) ==> Larsen Manufacturing Company needs to know its anticipated cash inflows for the next quarter by month. Cash sales are 20 percent of total sales each month. Historically, sales on account have been collected as follows: 50 percent in the month of the sale, 35 percent in the month after the sale, and the remaining 15 percent two months after the sale. Gross sales for the quarter are projected as follows: January, $20,000; February, $10,000; and March, $30,000. Accounts receivable on December 31 were $15,000. Larsen's expected cash collections for March would be:


    $30,000

    $23,200

    $21,500

    $38,20
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
    		  
    #2

    Feb 23, 2013, 02:19 PM
    What do you need help with? You have to use Jan, Feb, and Mar sales with the appropriate percentages to compute how much cash will be collected in March.
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!

Schedule of Expected Cash Collections; Cash Budget [ 4 Answers ]

Problem 9-23 Schedule of Expected Cash Collections; Cash Budget Herbal Care Corp. a distributor of herb-based sunscreens, is ready to begin its third quarter, in which peak sales occur. The company has requested a $39,000, 90-day loan from its bank to help meet cash requirements during the...

Preparing a cash collections and cash budget - I need advice - thank you! [ 0 Answers ]

I am having difficulty figuring this out. Any help would be appreciated to answer the 3 requirements. I am not certain how to set up these budgets. Thank you. Problem 4-3: You will be required to prepare a December cash budget. You are provided with the following information: a] Cash...

Cash collections budget [ 2 Answers ]

Sales budget January February March Sales in units 6,000 6,500 7,000 Sales in dollars $120,000 $130,000 $140,000 Sales consist of 70% cash and 30% credit. All credit accounts are collected in the month following the sales. Bad debts are negligible and can be ignored. Actual sales for...

Prepare a Budgeted Income Statement, Cash Budget, Sales Budget/Cash Collections, Purc [ 1 Answers ]

The CEO of Kingston Cart Inc. asked the Chief Financial Officer to prepare a Master Budget for the next three months, beginning July 1, 2010. The company's policy is to maintain a minimum cash balance of $6,000 at each month end. Sales are forecasted at an average selling price of $70 per cart....

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

View more questions Search