PROBLEM 2 (Version B): The Vice-President from the same corporation in Problem 1, loves your analytical ability. She wants you to evaluate the breakeven point of all the Haircare products they manufacture together EXCEPT "challenger". She asked you, the analyst, to analyze her situation. The data has been given to you for this evaluation in the previous worksheet labeled "Haircare Data". The equipment that is used to produce all the product except "Challenger" is leased for $115,000/year. Using the data, create a pivot table that extracts the marginal costs and revenue for the select products. 1. What is the break-even point? (Ensure answer is in cell C:9) 2. Create a scatter line chart showing the crossover of Revenue and Cost. I have given you the graph range. You need to add revenue and cost values. Label your Chart "Break Even". Do not change X axis values. 3. You are sharing this file with a co-worker. You need to leave at least 2 comments regarding work-flow on this worksheet. PROBLEM 2 (Version B): The Vice-President from the same corporation in Problem 1, loves your analytical ability. She wants you to evaluate the breakeven point of all the Haircare products they manufacture together EXCEPT "challenger". She asked you, the analyst, to analyze her situation. The data has been given to you for this evaluation in the previous worksheet labeled "Haircare Data". The equipment that is used to produce all the product except "Challenger" is leased for $115,000/year. Using the data, create a pivot table that extracts the marginal costs and revenue for the select products. 1. What is the break-even point? (Ensure answer is in cell C:9) 2. Create a scatter line chart showing the crossover of Revenue and Cost. I have given you the graph range. You need to add revenue and cost values. Label your Chart "Break Even". Do not change X axis values. 3. You are sharing this file with a co-worker. You need to leave at least 2 comments regarding work-flow on this worksheet