Tim’s Bicycle Shop sells 21-speed bicycles. For purposes of a cost-volume-profit analysis, the shop owner has divided sales into two categories, as follows: Product TypeSales PriceInvoice CostSales CommissionHigh-quality$1,550 $690 $110 Medium-quality 770 470 100 Three-quarters of the shop’s sales are medium-quality bikes. The shop’s annual fixed expenses are $209,250. (In the following requirements, ignore income taxes.) Required: Compute the unit contribution margin for each product type.What is the shop’s sales mix?Compute the weighted-average unit contribution margin, assuming a constant sales mix.What is the shop’s break-even sales volume in dollars? Assume a constant sales mix.How many bicycles of each type must be sold to earn a target net income of $101,250? Assume a constant sales mix.

Respuesta :

Answer:

What is the shop’s sales mix?  

PRODUCT 1 High 25%  

PRODUCT 2 Medium 75%  

Compute the unit contribution margin for each product type.    

PRODUCT 1 High $ 0,750

PRODUCT 2 Medium $ 0,200  

Compute the weighted-average unit contribution margin, assuming a constant sales mix  

PRODUCT 1 High      25%   weighted-average

                                 1,772  Contributing Margin

 

PRODUCT 2 Medium  75%    weighted-average

                                 5,316  Contributing Margin

What is the shop’s break-even sales volume in dollars?  

BREAK EVEN POINT  

TOTAL     Income Statement

$ 598,300 Total Net Sales

How many bicycles of each type must be sold to earn a target net income of $101,250?  

PRODUCT 1 High       230  

PRODUCT 2 Medium  690  

                                 920  Bicycles

Explanation:

PRODUCT 1 High    

Quantity Unit TOTAL     Income Statement

5  $ 1,550 $ 8,138     Total Net Sales

 -$ 690 -$ 3,623    Cost Sales

-$ 110 -$ 578      Commission Sales

$ 750 $ 3,938     Contributing Margin

           -$ 52,313 Anual Fixed Costs

       -$ 6  -$ 48,375 Segment Margin

PRODUCT 2 Medium    

Quantity  Unit  TOTAL      Income Statement

16            $ 770 $ 12.128    Total Net Sales

                -$ 470 -$ 7.403    Cost Sales

                -$ 100 -$ 1.575    Commission Sales

                $ 200  $ 3.150    Contributing Margin

                          -$ 156.938 Anual Fixed Costs

                 -1268% -$ 153.788 Segment Margin

TOTAL    

Quantity  Unit  TOTAL       Income Statement

21            $ 965 $ 20,265 Total Net Sales

                -$ 525 -$ 11,025  Cost Sale

                -$ 103 -$ 2,153    Commission Sale

                $ 338 $ 7.088     Contributing Margin

                           -$ 209,250 Anual Fixed Costs

                -$ 10 -$ 202,163 Segment Margin

BREAK EVEN POINT    

Quantity  Unit  TOTAL Income Statement

620         $ 965 $ 598.300 Total Net Sales

                -$ 525 -$ 325.500 Variable Cost

                -$ 103 -$ 63.550 Variable Cost

                $ 338 $ 209.250 Contributing Margin

                          -$ 209.250 Anual Fixed Costs

                                0%  $ 0          Segment Margin

TARGET OF SEGMENT MARGIN    

Quantity  Unit  TOTAL Income Statement

920          $ 965 $ 887.800 Total Net Sales

                -$ 525 -$ 483.000 Variable Cost

                -$ 103 -$ 94.300 Variable Cost

                 $ 338 $ 310.500 Contributing Margin

                         -$ 209.250 Anual Fixed Costs

                           11% $ 101.250 Segment Margin