Looking for formula assistance with the below managerial accounting problem.
The Regal Cycle Company manufactures three types of bicyclesa 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 Sales $931,000 $265,000 $407,000 $ 259,000 Variable manufacturing and selling 468,000 113,000 198,000 157,000 expenses Contribution margin 463,000 152,000 209,000 102,000 Fixed expenses: Advertising, traceable 69,500 8,200 40,700 20,600 Depreciation of special equipment 43,600 20,800 7,500 15,300 Salaries of product-line managers 114,400 40,700 38,400 35,300 Allocated common fixed expenses* 186.200 53.000 81.400 51,800 Total fixed expenses 413,700 122,700 168,000 123,000 Net operating income (loss) 5 49.300 5 29.300 5 41.000 $(211000) *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 nancial 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 nancial advantage (disadvantage) per quarter of discontinuing the Racing Bikes? ::| product lines. Prepare a properly formatted segmented income statement that would be more useful to management in assessing the long-run profitability of the various Totals Dirt Bikes Mountain Bikes Racing Bikes Contribution margin (loss) 0 0 0 0 Traceable fixed expenses: Total traceable fixed expenses 0 0 0 0 0 $ 0 $ 0 $ 0 Net operating income (loss) $ 0