Excel File Edit View Insert Format Tools Data Window Help 48%. Mon 11:04 PM Q OOO AutoSave OFI CVP-1 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Delele 27 Ideas Sort & Filter TE Format Find & Select Sensitivity DH DI DJ DK Calibr (Body) 11 v AA Wran Text General LE Pssto BIU ara S9 Merge & Center % ) Cell Conditional Format Formatting as Table Styles A3 + x A B D E F G H H DG 1 Name: Mark Hammel Your score: 0% 2 Mark Hammel Company reports the contribution margin income statement for 2021 below. Using this information, compute Mark Hammel Company's 1) break-even point in units, 2) break-even point in sales dollars, 3) unit sales to achieve target pretax income, and 4) dollar sales to achieve target pretax income. 4 5 Units $ per unit Total 6 Sales 2,900 $320 S928,000 7 Variable costs 2,900 240 696,000 8 Contribution margin 232,000 9 Fixed costs 160,000 10 Pretax income $72,000 11 12 13 14 15 16 17 18 19 20 21 1) Compute the break-even point in units 2) Compute the break-even point in sales dollars S120,000 Target pretax income Sales (units) to achieve targeted pretax income of $120,000 Sales (dollars) to achieve targeted pretax income of $120,000 22 23 24 25 26 Instructions CVP + + 140% 15 A W