Explore BrainMass

Explore BrainMass

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

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com June 3, 2020, 8:30 pm ad1c9bdddf
    https://brainmass.com/business/quality-management/cost-volume-profit-and-multiple-products-ken-s-bicycle-shop-140697

    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 ...

    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.

    $2.19

    ADVERTISEMENT