find the answers

Sales mix and break even analysis Conley Company has fixed costs of $13,000,000. The unit selling price, variable cost per unit, and contribution margin per unit for the company's two products follow: Product Selling Price Variable Cost per Unit Contribution Margin per Unit Yankee $125 $80 $45 Zoro 225 140 85 The sales mix for products Yankee and Zoro is 50% and 50%, respectively This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Determine the break-even point in units of Yankee and Zoro of the overall (total) product, E. If required, round your answers to the nearest whole number, Product Yankee: units Product Zoro: units Sales mix and break-even sales The unit selling price, variable cost per unit, and contribution margin per unit for the company's two products are provided below. DATA Product Selling price Variable Cost per Unit Contribution Margin per Unit Sales Mix $125 225 140 Fixed costs $13,000,000 $80 Yankee Zoro $45 85 50% 50% Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the Break-Even Sales column. Transfer the numeric results for the green entry cells (815 B16) into the appropriate fields in CNOWV2 for grading Break-Even Sales Formulas Yankee Zoro