A B C D E 1 Enter titles and accounts in the green cells 2 Enter Numbers in the blue cells 3 Enter your Calculations in the yellow cells 6 Unit 2 Cost Volume Profit 7 Read Chapter 18 https://www.principlesofaccounting.com/managerial 8 Problem 1 Bismark Industries makes a single product that sells for $34 per unit with variable costs being $21 per unit. The company has annual fixed costs are $364,000. 1 Calculate the contribution margin 2 Calculate the contribution margin ratio 3 Calculate the break even in units and in sales $ 4 Prepare a CVP Income Statement Per Unit 3 Break Even in Units Fixed Costs Contribution Margin per unit Units Sales Variable costs Contribution margin 2 Contribution Margin Ratio CM/sales Break even in Sales Fixed Costs Contribution Margin ratio CVP Income Stmt Total # Units Sales $ Variable costs $ Resources Problem 1 Problem 2 Problem 3 Problem 4 + Ready Paste BI ULAA E39 Merge & Center $ % ) Conditional Format Formatting as Table Cet Style J53 X fx Contribution Margin $ Fbxed costs $ Pre-tax income $ Senior Management At Bismark has determined to maintain certain financial ratios that they must earn a pre-tax income The company has annual fixed costs are $364,000. 1 Calculate the contribution margin 2 Calculate the contribution margin ratio 3 Calculate the break even in units and in sales $ 4 Prepare a CVP Income Statement Per Un Break Even in Units Fixed Costs+ desired profit Contribution Margin per unit Units Sales Variable costs Contribution margin Contribution Margin Ratio CM/sales Break even in Sales Fixed Costs+ desired profit Contribution Margin ratio CVP Income Stmt Total # Units Sales $ Variable costs $ Contribution Margin $ Fixed Costs $ Resources Problem 1 Problem 2 52 Problem 3 Problem 4 Ready Excel File Edit View Insert Format Tools Data Window Help AC306 Unit 2 Assignment template Home Formulas Data Review View 8 Wrap Text General B Insert Page Layout Calibri (Body) - 11 B TU BO x v for Center $ % ) 1.6 Paste 164 Conditional Format Formatting as Table Call Style: NOP Per Unit 1 Units Sales Variable Costs Contribution margin Break Even in Units Fixed Costs+ desired profit Contribution Margin per unit 2 Contribution Margin Ratio CM/sales Break even in Sales Fixed Costs+ desired profit Contribution Margin ratio CVP Income Stmt # Units Sales $ Variable costs $ Contribution Margin $ Fixed costs $ Net income $ Resources Problem 1 Problem 2 Problem 3 Ready