need help in all requirements. please add work/steps. thank you.

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 $ 929,880 $270, eee $ 405, eee $ 254,800 471, eee 112,000 284,000 155,000 458,000 158,00 201,000 99,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 (loss) 69,400 8,7ee 40,400 20,300 44,100 20,600 7,900 15,600 114,700 40,300 38,300 36,100 185,800 54, cee 81,000 50,800 414,000 123,600 167,600 122, see $ 44,000 $ 34,400 $ 33,400 $(23,880) "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. "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. 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 assessin profitability of the various product lines Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Should the production and sale of racing bikes be discontinued? Yes No Required 1 Required 3 > 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 Bikes Racing Bikes Contribution margin (loss) Traceable foed expenses Total traceable foed expenses Product line segment margin (los) Net operating income (105)