Ask Experts Questions for FREE Help !
Ask
    angel0772001's Avatar
    angel0772001 Posts: 233, Reputation: 7
    Full Member
     
    #1

    Oct 2, 2010, 09:52 AM
    Accounting cash budget
    Ok I'm not wanting someone to do my homework for me I just really don't understand this or how I am suppose to put the budget together. To me it seems like there isn't enough information. Ive been stuck on two problems for the past 4 hours. I have an online class so I can't really get much feed back from the teacher. I try to ask her for help but I can't get a reply out of her. If someone could explain this I would really appreciate it. I really want to learn this because this is the profession I've chosen so if I can't understand it how am I suppose to make a career out of it?

    Trapp Co. was organized on August 1 of the current year. Projected sales for the next three months are as follows:

    August $100,000
    September 185,000
    October 225,000

    The company expects to sell 40% of its merchandise for cash. Of the sales on account, one third is expected to be collected in the month of the sale and the remainder in the following month.

    they are wanting me to prepare a schedule indicating cash collections of accounts receivable for August, September, and October.

    and I also have another problem that I have been stuck on.

    On October 31, the end of the first month of operations, Carswell & Co. prepared the following income statement based on absorption costing:

    Carswell & Co.
    Income Statement
    For Month Ended October 31, 20-
    Sales (2,600 units) $104,000
    Cost of goods sold:
    Cost of goods manufactured $85,500
    Less ending inventory (400 units) 11,400
    Cost of goods sold 74,100
    Gross profit $ 29,900
    Selling and administrative expenses 21,500
    Income from operations $ 8,400
    ========

    If the fixed manufacturing costs were $42,000 and the variable selling and administrative expenses were $15,600, prepare an income statement in accordance with the variable costing concept.
    angel0772001's Avatar
    angel0772001 Posts: 233, Reputation: 7
    Full Member
     
    #2

    Oct 2, 2010, 12:48 PM

    OK I think I may have it. Can anyone tell me if this is correct?


    August September October
    receipts from expected cash sales
    cash sales
    100,000 185,000 225,000

    Receipts from sales on account
    collections from current months sales 40,000 74,000 90,000

    collections from next months sales 40,000 24,666 13,600
    total receipts from sales on account 80,000 98,666 103,600



    Sales 104,000.00
    Variable cost of goods sold 32,100.00
    Manufacturing margin 71,900
    Variable selling and administrative expenses 15,600
    contribution margin 56,300
    fixed costs:
    fixed manufacturing costs 42,000
    Fixed selling and administrative expenses 5,900
    Total fixed costs 47,900
    Income from operations 8,400

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...

In a cash budget the cumulative cash balance is equal to? [ 1 Answers ]

a. Cumulative loan balance minus the ending cash balance. B. cumulative loan balance plus the ending cash balance. C. net cash flow minus the beginning cash balance. D. net cash flow plus the beginning cash balance.

Cash Budget/ Cash Disbursements [ 2 Answers ]

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...

Preparing a cash budget example for accounting [ 1 Answers ]

How do you prepare a cash budget? I need to work out a problem in my accounting class and I don't know how to set up the problem? Can anyone help me? This is the question: Schafer Company expects to have a cash balance of 46,000 dollars on Jan. 1, 2007... These are the relevant monthly budget...


View more questions Search