AutoSave OFF ACG2209-Deliverable-5-Assignment.xlsx - Read-Only Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments Share Calibri (Body) 11 A A Wrap Text General Insert [A Delete Paste BI U A Merge & Center $%9 .000 Cell Conditional Format Formatting as Table Styles Format v v Sort & Filter Find & Select Analyze Data Sensitivity E47 A B 1 Sales mix and breakeven sales D The unit selling price, variable cost per unit, and contribution margin per unit for the company's two products are provided below. DATA Variable Product Selling price Cost par Contribution Margin per Unit Unit Sales Mix Digital TV Digital Stereo $150 220 $70 190 10 Fixed costs 11 $16,800,000 80% 20% Using formulas and cell references, perform the required analysis and input your answers into the green cells in the breakeven Sales column. 12 13 14 Breakeven Units Breakeven Sales Revenue 15 Digital TV 16 Digital Stereo 17 18 19 20 21 2 Sales mix and breakeven sales 22 23 24 25 G js Just Boards Inc. (a fictitious company) manufactures and sells two products, Boogie Boards and Surf Boards. The fixed costs, the sales mix, the unit selling price and the unit variable cost for each product are as follows: 26 Products 27 Boogie Boards 28 Surf Boards 29 30 Fixed costs 31 32 33 DATA Sales Mix Unit Selling Price Unit Variable Cost Contribution Margin per Unit 70% 30% $80 100 $50 BO $326,700 Using formulas and cell references, perform the required analysis and input your answers into the green cells in the Amount column. Module 5 Deliverable Ready Accessibility: Investigate H | J K L M N P Tell me what you want to do 100% AutoSave OFF ACG2209-Deliverable-5-Assignment.xlsx - Read-Only Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments Share G Paste Calibri (Body) 11 A A Wrap Text General Insert [A Delete BI U A Merge & Center $%9 .000 Cell Conditional Format Formatting as Table Styles Format v v Sort & Filter Find & Select Analyze Data Sensitivity E47 32 A B C D Using formulas and cell references, perform the required analysis and input your answers into the green cells in the Amount column. 33 34 35 3. 36 b. 37 breakeven sales Units of Boogie Boards sold at the breakeven point Units of Surf Boards sold at the breakeven point Amount 38 39 40 41 42 43 3 Breakeven sales and sales to realize operating income For the curent year ended March 31, Cosgrove Company expects fixed costs of $442,400, a unit variable cost of $57, and a unit selling price of $85. Compute the anticipated breakeven sales (units). Compute the anticipated breakeven sales (dollars). 44 45 Compute the sales (units) required to realize operating income of $100,800. 46 47 48 Compute the sales (dollars) required to realize operating income of $100,800. 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 Module 5 Deliverable Ready Accessibility: Investigate + G H | J K L M N P Tell me what you want to do 100%