CVP Analysis
Not what you're looking for?
The Fashion Shoe Company operates a chain of women shoe shops around the country. The shops carry many styles of shoes that are all sold at the same price. Sales personnel in the shops are paid a substantial commission on each pair of shoes sold (in addition to a small basic salary) in order to encourage them to be aggressive in their sales efforts.
The following worksheet contains cost and revenue data for Shop 48 is typical of the company's many outlets.
Per Pair of Shoes
Selling price $ 30.00
Variable expenses
Income cost $ 13.50
Sales commission 4.50
Total variable expenses ---------------------------------
$ 18.00
Annual
Fixed expenses:
Advertising $ 30,000
Rent 20,000
salaries 100,000
Total fixed expenses-----------------------------------
$ 150,000
------------------------------------
1. Calculate the annual break-even point in dollar sales and in unit sales for Shop 48.
2. Prepare a CVP graph showing cost and revenue data for Shop 48 from zero shoes up to 17, 000 pairs of shoes sold each year. Clearly indicate the break-even point on the graph.
3. If 12,000 pairs of shoes are sold in a year, what would be Shop 48's net income or loss?
4. The company is considering paying the store manager of Shop an incentive commission of Shop 48 an incentive commission of 75 cents per pair of shoes (in addition to the salesperson's commission). If this change is made, what will be the new break-even point in dollar sales and in unit sales?
5. Refer to the original data. As an alternative to (4) above, the company is considering paying the store manager 50 cents commission on each pair of shoes sold in excess of the break-even point. If this change is made, what will be the shop's net operating income or loss if 15,000 pairs of shoes are sold?
6. Refer to the original data. The company is considering eliminating sales commissions entirely in its shops and increasing fixed salaries by $31,500 annually. If this change is made, what will be the new break-even point in dollar sales and in unit sales for Shop 48? Would you recommend that the change be made?
Purchase this Solution
Solution Summary
Solution describes the steps to calculate BEP in the given cases. It also analyzes the effect of some of the managerial decisions on profitability of the firm.
Solution Preview
Please refer attached file for missing graph.
1. Calculate the annual break-even point in dollar sales and in unit sales for Shop 48.
Fixed Costs=F=$150,000
Variable Cost per pair=V=$18
Selling price=P=$30
BEP in units=F/(P-V)=150000/(30-18)=12500 pairs
BEP in dollars=BEP in units*P=12500*30=$375000
2. Prepare a CVP graph showing cost and revenue data for Shop 48 from zero shoes up to 17, 000 pairs of shoes sold each year. Clearly indicate the break-even point on the graph.
Sales, Q Total Revenue Fixed Cost, F Variable Cost, TVC Total Cost
=P*Q=30*Q V*Q=18Q F+TVC
0 0 150000 0 150000
2500 75000 150000 45000 195000
5000 150000 ...
Education
- BEng (Hons) , Birla Institute of Technology and Science, India
- MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
- "Thank you"
- "Really great step by step solution"
- "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
- "Thanks Again! This is totally a great service!"
- "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Introduction to Finance
This quiz test introductory finance topics.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.