Purchase Solution

Total sales of a product.

Not what you're looking for?

Ask Custom Question

Elm Company makes a product that has peak sales in September of each year. The company has prepared a sales budget for the third quarter of 2003, as shown below.
July August September

Budgeted sales $500,000 $600,000 $750,000

The company is in the process of preparing a cash budget for the third quarter and must determine the cash collections by month. Collections on sales are expected to be as follows.

70% in the month of sale
20% in the month following the month of sale
8% in the second month following the month of sale
2% uncollictible

The accounts receivable balance as of June 30 is $195,000, of which $45,000 represents uncollected May sales and $150,000 represents uncollected June sales.

a. What were the total sales for May and June?
b. What are the expected cash collections for each month of the third quarter.

Purchase this Solution
Solution Preview

The question mentions that the uncollected sales proceeds for May are 45,000 so the total sales of May are 100/10 x 45,000 because this is 10% of the total sales. So May sales = $450,000.
The ...

Purchase this Solution
Free BrainMass Quizzes
Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • Managerial Accounting Question

    of variable expenses for each product by dividing the total variable expenses for each product by sales of each product.

  • Mission

    How can your spreadsheet be used to demonstrate the effect of changes in sales price or costs on Mission's decision to sell Product Y at split off or process it further? a.

  • Java Application Code

    Cross-total each row to get the total sales of each product for last month. Cross-total each column to get the total sales by salesperson for last month.

  • ROE

    108093 If the following ratios were computed before the change, what will be the new ROE if the new product is added and sales remain constant? I am considering adding a new product to my firm's existing product line.

  • CVP Analysis for a nonprofit, Mount Company, and Blank Co

    Mount sells two units of Product A for each unit it sells of Product B. Mount faces a tax rate of 30%. Mount desires a net after-tax income of $73,500.What the breakeven point in units would be? 3.Blank Co sells a single product.

  • Solex Company

    Joint processing costs up to the split-off point total $103,000 per year. The company allocates these costs to the joint products on the basis of their total sales value at the split-off point.

  • Number of units that must be sold for breakeven

    Calculate operating income if 5,000 units are sold in a month. Operating Income= Sales -Total cost = (5000*84)- (5000*54)-120000 =$30000 C.

  • Price to Charge for $90,000 Profit

    184123 Price to Charge for $90,000 Profit A company produces and sells 4,000 units of a product that has a contribution margin of $6 per unit. The Co. sells the product for a sales price of $20 per unit. Fixed costs are $18,000.

  • Four Firm Concentration Ratio

    291140 Four Firm Concentration Ratio Ten firms complete in a market to sell product X.

  • Gosnell Company: Cost Volume Profit Analysis

    Multiply that x the mix of each product (use dollar sales as a percentage of total dollar sales at a low level; e.g. the mix is now 3 circle, 5 squares, so the total circle sales is 90 when 5 squares are sold for $250.

View More Related Solutions