Click in cell B4, note that you can choose a product from the drop-down list. This allows the company to select which product they wish to perform a CVP for. Ensure all calculations return the correct answers for the selected product (test by changing the selection).

I desperately need help with all these questions, Thank you! It needs a formula that when I change the option it also changes/fixes the answers with it.

Fixed Costs and Pricing for the Year Fixed Cost Items Rent Utilities Admin Costs Insurance $ $ $ $ Strata 56,500.00 $ 13,350.00 $ 26,600.00 $ 12,150.00 $ Rockglider 62,400.00 14,500.00 27,250.00 13,400.00 Unit Sales Price $ 4,365.00 $ 4,615.00 Production Hours per Unit 4 5 Unit Sales Estimate 340 330 This sheet does not require any calculations, but the values will be needed for calculations in other sheets. Cost Volume Profit Analysis for Strata Bikes Strata Product Name Unit Sales Price Unit Sales Estimate Total Fixed Costs Break-Even Analysis Contribution Margin Per Unit Break Even Volume in Units Break Even Sales Value Variable costs per Unit Vary with Unit Costs Direct Labor Direct Material Factory Overhead Other Vary-with-Unit Costs Total Vary with Unit Costs Break Even Variable costs Direct Labor Direct Material Factory Overhead Other Vary-with-Unit Costs Sales Commissions Other Vary-with-Revenue Costs Total Variable Costs $ $ 129.20 55.68 184.88 $ Vary-with-Revenue Costs Sales Commissions Other Vary-with-Revenue Costs Total Vary with Revenue Costs 4.5% 1.5% Contribution Margin Profit Before Tax Fixed Costs and Pricing for the Year Fixed Cost Items Rent Utilities Admin Costs Insurance $ $ $ $ Strata 56,500.00 $ 13,350.00 $ 26,600.00 $ 12,150.00 $ Rockglider 62,400.00 14,500.00 27,250.00 13,400.00 Unit Sales Price $ 4,365.00 $ 4,615.00 Production Hours per Unit 4 5 Unit Sales Estimate 340 330 This sheet does not require any calculations, but the values will be needed for calculations in other sheets. Cost Volume Profit Analysis for Strata Bikes Strata Product Name Unit Sales Price Unit Sales Estimate Total Fixed Costs Break-Even Analysis Contribution Margin Per Unit Break Even Volume in Units Break Even Sales Value Variable costs per Unit Vary with Unit Costs Direct Labor Direct Material Factory Overhead Other Vary-with-Unit Costs Total Vary with Unit Costs Break Even Variable costs Direct Labor Direct Material Factory Overhead Other Vary-with-Unit Costs Sales Commissions Other Vary-with-Revenue Costs Total Variable Costs $ $ 129.20 55.68 184.88 $ Vary-with-Revenue Costs Sales Commissions Other Vary-with-Revenue Costs Total Vary with Revenue Costs 4.5% 1.5% Contribution Margin Profit Before Tax