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

    May 2, 2011, 07:59 AM
    Solution to budgeted income for weller industrial
    Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:
    - Sales are budgeted at $330,000 for November, $300,000 for December, and $320,000 for January.
    - Collections are expected to be 85% in the month of sale, 14% in the month following the sale, and 1% uncollectible.
    - The cost of goods sold is 60% of sales.
    - The company purchases 80% of its merchandise in the month prior to the month of sale and 20% in the month of sale. Payment for merchandise is made in the month following the purchase.
    - Other monthly expenses to be paid in cash are $21,200.
    - Monthly depreciation is $21,000.
    - Ignore taxes.

    Statement of Financial Position
    October 31
    Assets:
    Cash $ 22,000
    Accounts receivable, net of allowance for doubtful accounts 83,000
    Inventory 158,400
    Property, plant and equipment
    Net of $594,000 accumulated depreciation 1,004,000
    Total assets $1,267,400


    Liabilities and Stockholders’ Equity:
    Accounts payable 196,000
    Common Stock 620,000
    Retained earnings 451,400
    Total liabilities and stockholders’ equity $1,267,400




    Required:
    a. Prepare a Schedule of Expected Cash Collections for November and December.
    b. Prepare a Merchandise Purchases Budget for November and December.
    c. Prepare Cash Budgets for November and December.
    d. Prepare Budgeted Income Statements for November and December.
    e. Prepare a Budgeted Balance Sheet for the end of
    smoothy's Avatar
    smoothy Posts: 25,490, Reputation: 2853
    Uber Member
     
    #2

    May 2, 2011, 08:38 AM

    Read this first: Expectations for the Homework Help board

    --------------------------------------------------------------------------------

    Do not simply retype or paste a question from your book or study material

    We won't do your homework questions for you.
    You were given the assignment for you to learn.

    If you come up with your own answer and post it for us to critique that is within reason.

    If you have some SPECIFIC questions that you couldn't find or didn't understand, we may help with that.
    But this is your assignment, so show us you have at least attempted to complete it on your own.

    Thank you.

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!

How to Prepare a budgeted income statement [ 1 Answers ]

I need to discus how to prepare a budgeted income statement. Im not sure how to do this and my book is not explaining it.

Merchandise purchase budget and budgeted income statement [ 1 Answers ]

Question The budget committee of Henning Ltd collects the following data for its melbourne store in preparing budgeted income statements for may and June 2007. 1) sales for may are expected to be $600,000. Sales in June and July are expected to be 10% higher than the preceding month. 2) cost of...

Bad debts in Budgeted Income Statements [ 1 Answers ]

Hi there, I am doing a Budgeted Income Statement. If there is a percentage of credit sales that will not be received therefore bad debts, should this be shown. From my readings, I understand that this will decreased the projected funds coming into the business, so I assume that they would have to...


View more questions Search