AC306 Unit 2 Assignment template (1) Excel A Bryanna Marie Hardy File Home Insert Page Layout Formulas Data Review Tell me what you want to do View UPDATES AVAILABLE Updates r Office are ready to be installed, but first we need to close some apps. Update now 039 A B C E F G H J L M N C Senior Management At Bismark has determined to maintain certain financial ratios that they must earn a pre-tax income of $130,000 32 B. The company has annual fixed costs are $364,000. 33 Calculate the contribution margin 2 Calculate the contribution margin ratio 34 35 3 Calculate the break even 36 units and in sales $ 4 Prepare a CVP Income Statement 37 38 39 1 Per Unit 40 Break Even in Units Units 1 41 Fixed Costs+ desired profit Sales Contribution Margin per unit 42 Variable Costs Contribution margin 2 Contribution 43 Margin Ratio CM/sales Break even Sales 44 Fixed Costs+ desired profit 45 Contribution Margin ratio 46 4 CVP Income Stmt 7 Total 48 # Units 40 Sales $ s0. Variable Costs $ 51 Problem 4 Problem 3 Problem 1 Problem 2 Resources Reads x hulu Excel AC306 Unit 2 Assignment template (1) Tell me what you want to do View Review Data Formulas Page Layout Insert Home File Update now Updates for Office are ready to be installed, but first we need to close some apps UPDATES AVAILABLE X f 066 M. L J F E C B A Contribution Margin ratio 46 CVP Income Stmt 4 47 Total 48 #Units 49 Sales $ 50 Variable Costs $ 51 52 Contribution Margin $ Fixed Costs $ 53 Net income $ 54 55 56 57 58 59 60 61 62 63 64 65 67 Problem 4 Problem 3 Problem 2 Problem 1 Resources Ready O O D 1/31/2019 AC306 Unit 2 Assignment template (1) – Excel Bryanna Marie Hardy Tell me what you went to do Formulas Data Review View Page Lavout File Home Insert Update now iUPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. 025 C P M 4A 8 E D Cost Volume Profit Unit 2 Read Chapter 18 https://www.priniplespfacrounting.com/managerial-cost-acrounting/ 8 Problem 1 $34 per unit with variable costs being $21 per unit. 9 A Bismark Industries makes a single product that sells f The company has annual fixed costs are $364,000. 10 1 Calculate the contribution margin 11 tio 3 Calculate the break even in units and in sales $ 13 4 Prepare a CVP Income Statement 14 15 Break Even in Units 16 1 Per Unit Fixed Costs Units 17 Contribution Margin per unit Sales 18 2 Contribution Variable Costs 19 Break even in Sales Margin Ratio Contribution margin Fixed Costs CM/sales Contribution Margin ratio CVP Income Stmt Total 23 4 # Units e-lne Froblam 4 Problem a Recources Problem 1 Problem 2 ABryanns Marie Hardy AC306 Unit 2 Assignment template (1) Excel Tell me what you want to do View Data Review Formulas Page Layout Insert Home Fle Update naw Updetes for Office are ready to be installed, but first we need to close some apps. iUPDATES AVAILABLE 04: N H A B C CVP Income Stmt 23 4 Total. 24 # Units 25 Sales $ 26 Variable Costs $ 27 28 Contribution Margin $ Fixed Costs $ 29 Pre-tax income $ 30 31 anagement At Bismark has determined to maintain certain financial ratios that they must earn a pre-tax income of $130.000 The company has annual fixed costs are $364,000. Calculate the contribution margin Calculate the canti and in sales S 34 35 Prepare a CyP Income Statement 2T 38 39 Break Even in Units 3 Per Unit 1 Fixed Costs+ desired profit Contribution Margin per unit Units 41 Sales Problem 1 Problem 2Problem 3 Problem 4 Resources