An Analysis of Kevin's Bicycle Shop
Not what you're looking for?
Ken's Bicycle Shop sells mountain bikes. For purposes of a cost-volume-profit analysis, the shop owner has divided sales into two categories, as follows:
Product Category Sales Price Invoice Cost Sales Commissions
High quality $700 $375 20% of sales
Medium quality 500 235 20% of sales
The shop anticipates selling 500 bicycles, 300 of which will be medium quality. Annual fixed costs are $80,000. Ignore taxes.
Answer the following:
a. What is the shop's sales mix?
b. What is the shop's break-even sales volume in dollars? (Hint: Find the break-even sales volume first.)
c. How many bicycles of each type must the firm sell to earn a target net income of $50,000?
d. Build your own spreadsheet. Prepare a computer spreadsheet to complete requirements (a)-(c) of this exercise. What if the market for high quality bikes drops 20 percent and Ken maintains market share?
Purchase this Solution
Solution Summary
This solution is comprised of a detailed, step by step analysis which exemplifies how to solve for the shop's sales mix and break-even point. An Excel document is attached which provides the solutions for parts c and d.
Solution Preview
Ken's Bicycle Shop sells mountain bikes. For purposes of a cost-volume-profit analysis, the shop owner has divided sales into two categories, as follows:
Product Category Sales Price Invoice Cost Sales Commissions
High quality $700 $375 20% of sales
Medium quality 500 235 20% of sales
The shop anticipates selling 500 bicycles, 300 of which will be medium quality. Annual fixed costs are $80,000. Ignore ...
Purchase this Solution
Free BrainMass Quizzes
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
Basics of corporate finance
These questions will test you on your knowledge of finance.
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.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations