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

    Apr 23, 2006, 11:36 AM
    projected sales and budget
    1.Trapp Co. was organized on August 1 of the current year. Projected sales for trhe next three months are as follows:
    August $100,000
    September $185,000
    October $225,000

    The company expects to sell 40% of tis merchandise for cash. Of the sales on account, one third are expected to be collected in the month of the sale and the remainder in the following month.
    Prepare a schedule indicating cash collections of accounts receivable for August, September, and October.

    My answer so far:
    100,000+185,000+225,000=560,000
    560,000x40%=224,000

    2. Prepare a monthly flexible selling expense budget for Practer Company for sales volumes of $300,000, $400,000 and 600,000 based on the following data:
    sales commissions 4% of sales
    sales manager's salary $70,000 per month
    Advertising expense $75,000 per month
    Shipping expense 1% of sales
    Miscellaneious selling expense 2100 per month plus 1/2% of sales:
    my answer so far: PLEASE HELP:eek:
    Cost Category 300,000 400,000 600,000
    Budgeted variable
    Overhead
    sales commissions 12,000 16,000 24,000
    sales manager's sal.
    Advertising expense
    Shipping expense 3,000 4,000 6,000
    starman258's Avatar
    starman258 Posts: 1, Reputation: 1
    New Member
     
    #2

    Jul 29, 2008, 10:48 PM
    If this is homework, as I know it is, I get credit.

    1). What is the total expected cash collections for August?

    Total Sales - $100,000
    Cash Sales - $40,000
    Sales on account - $60,000
    Expected Cash Collected - $60,000
    ($40,000 + ($60,000 / 3))

    2. What is the total expected cash collections for September?

    Total Sales - $185,000
    Cash Sales - $74,000
    Sales on account - $111,000
    Expected Cash Collected - $151,000
    ($74,000 + $40,000 from August + (111,000 / 3)

    3. What is the total expected cash collections for October?

    Total Sales - $225,000
    Cash Sales - $90,000
    Sales on account - $135,000
    Expected Cash Collected - $172,000
    ($90,000 + $37,000 from September + (135,000 / 3)

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!

Flexible Budget [ 1 Answers ]

What is its purpose? eliminate cyclical fluctuations in producation reports by ignoring variable costs compare actual and budgeted results at virtually every level of production reduce total time in preparing actual budget I think it is the second one, does a1 disagree?

Flexible Budget/schedule [ 3 Answers ]

1.Prepare a monthly flexible selling expense budget for Practer Company for sales volumes of $300,000, $400,000, and $600,000 based on the following data: Sales commissions 4% Sales manager's salary $70,000 per month Advertising expense $75,000 per...

Which dishwasher to buy? On a budget [ 2 Answers ]

I have an old turn dial dishwasher that doesn't clean dishes very well at all. You practically have to wash the dishes by hand before putting them in for them to be clean (you get where I'm going) I need to purchase a stainless steel unit, Home Depot local to me had a similar type dishwasher to...

Production budget [ 0 Answers ]

Can someone please help me create a production budget using the following information. The sales department of Red Hawk Manufacturing Co. has forecast sales in March to be 20,000 units. Additional information follows: Finished goods inventory, March 1 3000 units Finsihed goods inventory...


View more questions Search