Paste Copy Format Painter BIURO A E IMI IMI Merge & Center $ - % 9 68 48 Conditional Formatting as Tat Undo Clipboard Font Alignment Number C15 fx A D E F B 1 Sales mix and break-even sales 2 Dragon Sports Inc. manufactures and sells two products, baseball bats and baseball gloves. The fixed costs, the sales mix, the 3 unit selling price and the unit variable cost for each product are as follows: 4 5 DATA 6 Products Sales Mix Unit Selling Price Unit Variable Cost 7 Bats 80% $80 $40 8 Gloves 20% 100 65 9 10 Fixed costs $351,000 11 Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the Amount 12 column. Transfer the numeric results for the green entry cells (C15, C17:C18) into the appropriate fields in CNOWV2 for grading. 13 14 Amount Formulas 15 a. Break-even sales 16 b. Units of baseball bats sold at 17 the break-even point Units of baseball gloves sold 18 at the break-even point 19 20 21 22 23 24 25 26 27 28 Data + Calculation Mode: Automatic Workbook Statistics eBook Show Me How Office 365 Calculator Sales mix and break-even sales Dragon Sports Inc. manufactures and sells two products, baseball bats and baseball gloves. The fixed costs are $351,000, and the sales mix is 80% bats and 20% gloves. The unit selling price and the unit variable cost for each product are as follows: Products Unit Variable Cost Unit Selling Price $80 Bats $40 Gloves 100 65 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers 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: units Previous Next Check My Work All work saved. Save and Exit Submit Assignment for Grading