Required: X Download spreadsheet BreakEvenPointCaseData-11852d.xIsx You are to build a spreadsheet that can calculate break-even point. Break-even point is the number of units that a business has to sell to negate costs and begin producing a profit. The calculations will update when you change the costs (fixed or variable) or sales price. -int: The break-even point cannot be calculated with one Excel function. Through this case you will learn how to accomplish a complex task by breaking the problem into smaller steps. This case will guide you through the steps. HINT: STEP-BY-STEP WALKTHROUGH To help you get started, the file already has jacket sales, cost data, and column titles for you to fill out. Complete the following steps: 1. Excel Formula Section: Perform the following calculations using the given data. a. In cell C7, calculate the contribution margin per jacket unit. 2. Data Table Section: Perform the following calculations using the given data. Hint: You need to use absolute references. Note: You must create this data table to be able to graph the break-even point. a. In cell C13, create a formula using the number of units in column B and costs (fixed and variable) to calculate the total cost for producing that many units. For example, in C13, what is the total costs for producing one jacket? Important: Although cost is often thought of as a negative number in accounting, keep your calculations in positive numbers. $ Copy and paste your formula into the remainder of column C. b. In cell D13, create a formula using the number of units in column B and the sales price to calculate the gross revenue for selling that many jackets. For example, in D13, what is the gross revenue for selling one jacket? q Copy and paste your formula for the remainder of column D. 3. Graph: Select the data table you have created in cells C12-D42. Create a line graph for this data. Where the cost and gross revenue lines cross is the break-even point. Choose the correct graph. 2 more Check My Work uses remaining. price to calculate the gross revenue for selling that many jackets. For example, in D13, what is the gross revenue for selling one jacket? \& Copy and paste your formula for the remainder of column D. 3. Graph: Select the data table you have created in cells C12-D42. Create a line graph for this data. Where the cost and gross revenue lines cross is the break-even point. Choose the correct graph. The correct graph is graph A. . 4. Use your spreadsheet to explore how costs and volume interact. What happens to the break-even point if you lower the fixed costs? The break-even point will decrease . What happens to the break-even point if you increase your sales price? The break-even point will What happens to the break-even point if you lower the variable costs? The break-even point will 5. Calculate profits in column E. For example, in E13, what is the profit for producing one jacket? Use a minus sign to enter loss, if any. q 2 more Check My Work uses remaining