Could you solve this problem? Thank you!!!!!

Exercise 11-2 Dropping or Retaining a Segment (LO11-2] The Regal Cycle Company manufactures three types of bicycles a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow: Dirt Mountain Racing Total Bikes Bikes Bikes $ 917,000 $264,000 $401,000 $ 252,000 477,000 114,000 206,000 157,000 440,000 150,000 195,000 95,000 Sales Variable manufacturing and selling expenses Contribution margin Fixed expenses: Advertising, traceable Depreciation of special equipment Salaries of product-line managers Allocated common fixed expenses Total fixed expenses Net operating income (1088) 70,400 8,900 43,900 20,700 114,600 40,200 183,400 52,800 412,300 122,600 $ 27,700 27,400 40,900 20,600 7,900 15,300 38,800 35,600 80,200 50,400 167,800 121,900 27,200 $(26,900) "Allocated on the basis of sales dollars. Management is concerned about the continued losses shown by the racing bikes and wants a recommendation as to whether or not the line should be discontinued. The special equipment used to produce racing bikes has no resale value and does not wear out. Required: 1. What is the financial advantage (disadvantage) per quarter of discontinuing the racing bikes? 2. Should the production and sale of racing bikes be discontinued? 3. Prepare a properly formatted segmented income statement that would be more useful to management in assessing the long-run profitability of the various product lines. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 What is the financial advantage (disadvantage) per quarter of discontinuing the racing bikes? Required 2 > Required 1 Required 2 Required 3 0 0 Prepare a properly formatted segmented income statement that would be more useful to management in assessing the long- run profitability of the various product lines. Totals Dirt Bikes Mountain Bikes Racing Bikes Sales Variable manufacturing and selling expenses Contribution margin (loss) Traceable fixed expenses: Advertising Depreciation of special equipment Salaries of the product line managers Total traceable fixed expenses Product line segment margin (loss) 0 s 0 $ Common fixed expenses Net operating income (loss) 0 0 0 0 0 $ 0 $ 0