A B D E 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) 2 3 Percentage 4 5 BMX Product Line Budgeted CVP Income Statement For the year ended 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 6 7 8 Management has estimated the following for the BMX Bike product line: Expected sales 1,000 bikes Selling price S 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). 9 10 Sales commissions 11 Total Variable Costs 12 13 14 15 16 Contribution margin Less: Fixed Costs (must be listed alphabetically) Advertising Salaries Total Fixed Costs BMX SEGMENT MARGIN 17 10 calculated in your explanation): 6 To BN 17 18 calculated in your explanation): Explanation 19 Should the company introduce the BMX Line? Why or why not? 20 When sales are decreasing, would management like to have a high or low degree of operating leverage. Why? 21 22 2 Drino 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 32 costing Target Selling price using absorption 33 costing 34 35 Is the selling price of noted in part A, sufficient to earn the minimum required return expected by the owners? (Yes or No) 36 37 38 Why or why not? 39 40 41 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. 42 43 Maximum selling price $300 44 Target Cost per Bike (1 marks) 45 What advice would you give to management to help them achieve the target cost you 46 calculated above? (2 marks) III A Final Exam Q1 Q2 03 04 056 Fram Formi