Purchase Solution

Puppet Barn's break-even point, target profit

Not what you're looking for?

Ask Custom Question

Cost-Volume-Profit Analysis
Data related to the expected sales of ventriloquist dummies names Groucho, Daphne, and Tex for the Puppet Barn for December are as follows:

Product Selling Price/per Unit Variable Cost/per Unit Sales Mix

Groucho $45 $35 50%
Daphne $100 $65 30%
Tex $70 $40 20%

Estimated fixed costs for December are $107,500, estimated sales are $500,000, and Puppet Barn wants to realize an operating profit of $64,500.

1.) Develop a worksheet that will compute Puppet Barn's break-even point and the level of sales required to achieve its desired operating profit. The answers should be expressed both in units and in dollar, and they should be computed for the company as a whole and for the individual products, assuming they are sold in the proportions shown in the table.
2.) Make sure to include a section for the above data and reference these in the rest of your worksheet. Use cell references whenever possible, use two decimal places for dollar amounts and three decimal places for your ratio, and adjust column widths.
3.) Next, create a pie chart (on a chart sheet) that shows the sales mix proportion allocated to each product.
4.) Finally, format the worksheet to provide a professional look...something that you would be proud to show a client paying you to create this workbook. Make sure all values are represented by labels, headings, proper dollar signs, lines and double lines are used.

Purchase this Solution
Solution Summary

Your tutorial is attached with a model for the client that permits the client to update the raw data given and have the computations update automatically. A pie chart is shown for the sales mix.

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

View More Free Quizzes
Related BrainMass Solutions

  • Computing Break-even Point and After-tax Target Profit

    This solution illustrates how to compute the break-even point and after-tax target profit of a project.

  • Managerial Accounting: Break-Even Point

    How many units need to be sold in order to break-even? B. Calculate the increase in net income if an additional 1,000 units over the break-even point are sold. C. How many units need to be sold in order to earn a target profit of $600,000?

  • Variable cost / absorption cost/ break even

    TRUE / FALSE 4 The formula for the break-even point is the same as the formula to attain a given target profit for the special case where the target profit is zero.

  • Break Even Point

    This posting helps compute the company's per unit contribution margin and break even point, find the units Gladstone has to sell to produce a target net profit, and selling price a management would charge.

  • Calculating Contribution Margin and Break Even Point

    Fixed Cost=F=$4,000,000 Target Profit=TP=$600,000 Variable costs per member =V= $200 Enrollment fee per member =P= $400 Economic break even point=(F+TP)/(P-V)=(4000000+600000)/(400-200)= 23000 23,000 enrollments are needed for achieve economic

  • Calculating break even point

    383810 Break-Even Point and Target Income Break-Even Point and Target Income Detienne Company manufactures and sells one product for $20 per unit. The unit contribution margin is 40% of the sales price, and fixed costs total $80,000. 1.

  • Contribution margin and breakeven

    and economic break-even point.

  • Operating & Financial Leverage

    How can sales-mix changes impact a company's break-even point? The break-even point is the level of sales at which profit is zero.

  • Breakeven Analysis vs. Operating Leverage

    At this point, no profit is made and no losses are incurred. The break-even point can be expressed in terms of unit sales or dollar sales. That is, the break-even units indicate the level of sales that are required to cover costs.

View More Related Solutions