Cost Volume Profit Analysis for Rockglider Bikes Fixed Costs and Pricing for the YearPls provide all Excel working out for this. In cell B

$4$

$,$

$$you can choose a product from the drop down list. This allows the company to select which product they want to perform a CVP for. make sure all calculations return the correct answers for the selected product

$($

test by changing; the selection

$)$

$.$

question: in tab B

$7$

$($

total fixed costs

$)$

$$use a formula to retrieve the Total Fixed Costs from the Fixed Costs sheet for strata or rockglider; the product shown in B

$4$

$.$