Purchase Solution

Planning and Budgeting for Andre's Hair Styling

Not what you're looking for?

Ask Custom Question

Please help with spread sheet and questions original only please.

Consider the following scenario:

Andre has asked you to evaluate his business, Andre's Hair Styling. Andre has five barbers working for him. (Andre is not one of them.) Each barber is paid $9.90 per hour and works a 40-hour week and a 50-week year, regardless of the number of haircuts. Rent and other fixed expenses are $1,750 per month. Hair shampoo used on all clients is .40 per client. Assume that the only service performed is the giving of haircuts (including shampoo), the unit price of which is $12. Andre has asked you to find the following information.

Find the contribution margin per haircut. Assume that the barbers' compensation is a fixed cost. Show calculations to support your answer.

For this part I need an appropriate explanation.

Determine the annual break-even point, in number of haircuts. Support your answer with an appropriate explanation. Show calculations to support your answer.

What will be the operating income if 20,000 haircuts are performed? Show calculations to support your answer.

Suppose Andre revises the compensation method. The barbers will receive $4 per hour plus $6 for each haircut. What is the new contribution margin per haircut? What is the annual break-even point (in number of haircuts)? Show calculations to support your answer.

Purchase this Solution

Solution Summary

See your computations attached in Excel. Click in cells to see computations. Your discussion is 442 words plus formulas and computations for breakeven, pro-forma profits, and contribution margin for the business.

Solution Preview

See attached file.

Discussion:

The breakeven point is when the contribution margin, sales minus variable costs, is equal to the fixed costs. In other words, fixed costs divided by contribution margin per unit will give you the sales in units needed to cover fixed costs. See the computation to the left. The convention is to round up to the next unit since you cannot sell a part of a unit.

This problem is a bit unusual because hourly wages are usually a variable cost. However, the definition of a variable cost is one that "varies with activity." This appears to vary -- after all -- it is a per hour charge so doesn't it vary with the number ...

Solution provided by:
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
Learning Lean

This quiz will help you understand the basic concepts of Lean.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

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.