Please answer all of the following questions in parts 1 and 2. Please have detailed explanations and show all calculations.

Vith the efforts of the sub-committee and market analysts, you have gathered the following additional formation: The US Market Sub-Committee has decided to introduce the Touring Bike and Road Bike into the US market CCC's market analysts indicate that every $250 change in the price results in a 100 unit change in the units sold. CCC's market analysts indicate that every $100 change in the price results in a 200 unit change in the units sold. CCC owns a variety of machines for manufacturing. These machines were purchased in 2015 and cost (in total) $3,000,000. These machines have a useful life of 10 years and are depreciated on a straight-line basis. CCC's tax rate is 40% The partial income statement of one of the US competitors: Part 1: Cost-Value-Profit (CVP) Analysis a) The sub-committee wishes to see how CCC stacks up against the current US market. Due to this, you have decided to compare CCC to United Cycles Limited (UCL) at this time of the year. Create a partial income statement for CCC from January 1 to June 30, 2022. Comment on the different cost structures of the two companies. b) The sub-committee believes that profits should be higher than they currently are with the number of units they have sold. Calculate CCC's break-even point in dollars and units sold (round dollars to 2 decimal places and units sold to the nearest whole number). How does this affect CCC's ability to make profit? c) CCC has a target annual operating income of $1,600,000 after tax. Calculate the required sales amount in dollars and units sold. Do you think this is achievable? Explain your reasoning on why it is or is not. d) The sub-committee would like to know how CCC would perform in periods of varying demand compared to its competitors. Determine and compare the degree of operating leverage for CCC and UCL at this time of the year. If the demand for bikes were to increase, who would be better off? Explain your reasoning. Part 2: Sensitivity Analysis a) Perform a sensitivity analysis on the contribution margins for the Touring Bike and Road Bike. [Hint: Use Excel Data Tables] b) Prepare a brief memo to the sub-committee explaining the price(s) you believe CCC should sell their Touring and Road Bikes in the US market at. Justify your decision using your analysis and other case facts that you have gathered. State any assumptions you have made in your analysis. Vith the efforts of the sub-committee and market analysts, you have gathered the following additional formation: The US Market Sub-Committee has decided to introduce the Touring Bike and Road Bike into the US market CCC's market analysts indicate that every $250 change in the price results in a 100 unit change in the units sold. CCC's market analysts indicate that every $100 change in the price results in a 200 unit change in the units sold. CCC owns a variety of machines for manufacturing. These machines were purchased in 2015 and cost (in total) $3,000,000. These machines have a useful life of 10 years and are depreciated on a straight-line basis. CCC's tax rate is 40% The partial income statement of one of the US competitors: Part 1: Cost-Value-Profit (CVP) Analysis a) The sub-committee wishes to see how CCC stacks up against the current US market. Due to this, you have decided to compare CCC to United Cycles Limited (UCL) at this time of the year. Create a partial income statement for CCC from January 1 to June 30, 2022. Comment on the different cost structures of the two companies. b) The sub-committee believes that profits should be higher than they currently are with the number of units they have sold. Calculate CCC's break-even point in dollars and units sold (round dollars to 2 decimal places and units sold to the nearest whole number). How does this affect CCC's ability to make profit? c) CCC has a target annual operating income of $1,600,000 after tax. Calculate the required sales amount in dollars and units sold. Do you think this is achievable? Explain your reasoning on why it is or is not. d) The sub-committee would like to know how CCC would perform in periods of varying demand compared to its competitors. Determine and compare the degree of operating leverage for CCC and UCL at this time of the year. If the demand for bikes were to increase, who would be better off? Explain your reasoning. Part 2: Sensitivity Analysis a) Perform a sensitivity analysis on the contribution margins for the Touring Bike and Road Bike. [Hint: Use Excel Data Tables] b) Prepare a brief memo to the sub-committee explaining the price(s) you believe CCC should sell their Touring and Road Bikes in the US market at. Justify your decision using your analysis and other case facts that you have gathered. State any assumptions you have made in your analysis