This is a excel question I need help with for a project:

The owners of Mountain Sports Ltd. are currently reviewing a proposal to adopt a new product line - BMX Eiicycles. This new product line will be compatible with the Mountain Bikes and open a new target market, younger customers. It is anticipated that the EM): line he introduced next spring. Management has estimated the following: The additional sales clerks required for the EM): line will only work for four months of the year [May to August]. \fThis new EIMX bike product line will create an increase in sales of two departments: Accessories [refer to C12 segmented income statement for department information]. However, dueto thefloor space required for retailing EIMX EIikes, management estimates that sales of Mountain Bikes will decrease [hint: rememberthat variable costs will also change when sales change]. Increase in Accessories Sales Decrease in Mountain Bikes Sales what is the impact to the company's income as a whole if the BMI product line is added {hint consider the segment margin of the EM! product line, and the impact to the other product Iina- Remember that if sala change for a product line, the total variable cosu Iwill also change- Thus, contribution margin should be used in your calculations for the other Increase in EMX Segment Margin Increase in Contribution Margin Accessories - Decrease in Contribution Margin Mountain Bikes [show as negative number] MEI Increase [Decrease] in Dperating Income _ DECISION: Should the company add the EIMX bike product line? 1I'lr'hy or why not? Assume management has decided to go ahead with offering the EM! product line- The owners of Mountain Sports are concerned about the ability of BM! to cover its fixed cosu and provide a good return on invEtment {RDIL An invEtment is required for the necE-zsary fixtur, display racks, and inventory- The owners have provided the minimum return on invEtment below- Use the cost information and unit sala provided in part A above to answer the outions below- Suggested selling price 5 BEIGE Required investment in assets 3 2114,1300 Minimum return on investment Calculate the following: Unit product costcosisincurred togetthe bike - ready for sale] Total selling 3;: administrative costs [costs that help sell the bike or run the business as a whole] _ Markup percentage using absorption costing _ Suggested selling price using absorption costing _ Is the suggEted selling price [noted in part A} sufficient to earn the required return expected by the owners? Are there any other considerations management should take into account before adding the product line