Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Finance & Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=411)
-   -   Accounting cash budget (https://www.askmehelpdesk.com/showthread.php?t=512886)

  • Oct 2, 2010, 09:52 AM
    angel0772001
    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.
  • Oct 2, 2010, 12:48 PM
    angel0772001

    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

  • All times are GMT -7. The time now is 12:00 PM.