please answer in same chart format as required 1 and 3 stuck on them

The Regal Cycle Company manufactures three types of bicycles a dirt bike, a mountain bike, and a racing ke Data on sales and expenses for the past quarter follow Mountain Total Dirt Bikes Bikes Hacing Ribes Sales $.930,000 $ 269,000 $40,000 Variable manufacturing and selling expenses 3.799,00 461,000 110,000 30,000 199.000 Contribution margin 469,000 159.000 210,000 100,000 Fixed wxpenses Advertisine traceable 70,300 8,900 10.100 20,900 Depreciation of special equipent 43,700 20.600 7,300 15,00 Salaries of product line managers 114,600 40,700 38,00 M1,500 Allocated common Fixed expenses 136,000 36,40 51,00 Total Fixed expenses 414,400 124.000 16,000 124.400 Net operating income (less) $ 54,60 $ 35,000 $46,000 5 (24,400) "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. H 2 of 7 an 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? financial advantage (disadvantage) per quarter Required 2 > KIRequirnal Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 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 Totals Dirt Bikes Mountain Bike Racing Bikes 0 D Contribution margin (loss) Traceable foed expenses 0 D 0 0 0 os OS 0 $ Total traceable fixed expenses Product line segment margin (loss) $ 0 Net operating income (oss) Red