D F G H Question 1: Product line Analysis (23 marks) The owners of Mountain Sports Ltd, are currently reviewing a proposal to adopt a new product line-BMX Bikes. This new product line will be compatible with their existing product line, Mountain Bikes and open a new target market, younger customers. It is anticipated that the BMX line be introduced next spring. Required: Part A Prepare a budgeted CVP income statement (for a one year period) to determine the segment margin for the new BMX Bikes product line. (8 marks) Percentare Management has estimated the following for the BMX Bike product line: Expected sales 1,000 bikes Selling price $ 400.00 per bike Expenses: Advertising $ 10,000 annually Assembly $ 100.00 per bike Cost of Goods Sold $ 200.00 per bike Rent 5% of sales "Salaries $ 5,000 per month Sales commissions 10% of sales The company will need to hire two sales clerks for the BMX line. This sales clerk will only work for six months of the year (May to October), BMX Product Line Budgeted CVP Income Statement For the year anded December 31, 2020 TOTAL Per Bike Number of Bikes 1.000 Sales Revenue Less: Variable costs must be listed alphabetically Assembly Cost of Goods Sold Rent Sales commissions Total Variable Costs Contribution marrin Less: Ford Costs must be listed alohabetically) Advertising Salaries Total Fixed Costs BMX SEGMENT MARGIN calculated in your explanation): Explanation Should the company introduce the BMX Line? Why calculated in your explanation): Explanation Should the company introduce the BMX Line? Why or why not? . When sales are decreasing, would management like to have a high or low degree of operating leverage. Why? 21 22 23 Part C: Pricing (8 marks) Assume management has decided to go ahead with offering the BMX product line. The owners of Mountain Sports are concerned about the ability of BMX to cover its fixed costs and provide a good return on investment (ROI). An investment is required for the necessary fixtures, display racks, and inventory. The owners have provided the minimum return on investment below. Use the cost information and unit sales provided in part A above to answer the questions Helow. 24 25 Required investment in assets $ 200,000 Minimum return on investment 26 159 Part C: Pricing (8 marks) Assume management has decided to go ahead with offering the BMX product line. The owners of Mountain Sports are concerned about the ability of BMX to cover its fixed costs and provide a good return on investment (ROI). An investment is required for the necessary fixtures, display racks, and inventory. The owners have provided the minimum return on investment below. Use the cost information and unit sales provided in part A above to answer the questions below. $ 200,000 15% 5 Required investment in assets 6 Minimum return on investment 7 8 Calculate the following: 29 Unit product cost Selling & Admin cost per bike 30 Desired return on investment per 31 bike (in dollars) Markup percentage using aborption costing 32 Target Selling price using absorption 33 costing 34 35 is the selling price of noted in part A, sufficient to earn the minimsh required return expected by the owners? (Yes or No) Part D: Target Costing (3 marks) Suppose management has determined that the maximum selling price that the market is willing to pay is $300 and they are selling 1,000 units. Assume management wants to earn a 15% return on investment. Maximum selling price $300 Target Cost per Bike (1 marks) What advice would you give to management to help them achieve the target cost you calculated above? (2 marks)