Purchase Solution

Cost-Volume Profit and Multiple Products: Ken's Bicycle shop

Not what you're looking for?

Ask Custom Question

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.

Required
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 problem explains how to conduct calculate Cost-Volume Profit when we have Multiple Products. Shows the calculations in step-by-step manner for easy understanding.

Solution Preview

See the attached file for complete solution. The text here may not be copied exactly as some of the symbols / tables may not print. Thanks
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 ...

Purchase this Solution


Free BrainMass Quizzes
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.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Organizational Behavior (OB)

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

Introduction to Finance

This quiz test introductory finance topics.