solve the questions

Sales mix and break-even sales Dragon Sports Inc, manufactures and sells two products, baseball bats and baseball gloves. The foxed costs are $891,000, and the sales mix is 20% bats and 80% gloves. The unit selling price and the unit variable cost for each product are as follows: Products Unit Selling Price Unit Variable cost Bats $90 $40 Gloves 125 70 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your Briswers in the questions below, Open spreadsheet a. Compute the break-even sales (units) for the overall enterprise product, E. units b. How many units of each product, baseball bats and baseball gloves, would be sold at the break-even point? Baseball bats: Units Baseball gloves: Sales mix and break-even sales Dragon Sports Inc. manufactures and sells two products, baseball bats and baseball gloves. The fixed costs, the sales mix, the unit selling price and the unit variable cost for each product are as follows DATA Products Sales Mix Unit Selling Price Unit Variable Cost Bats 20% $90 $40 Gloves 80% 125 70 Fixed costs $891,000 Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the Amount column. Transfer the numeric results for the green entry cells (C15, C17C18) into the appropriate fields in CNOWV2 for grading Amount Formulas a Break-even sales b. Units of baseball bats sold at the break-even point Units of baseball gloves sold at the break-even point