Everything

AutoSave OFF 3 Ch 5 Homework Q v Home Insert Draw Page Layout Formulas Data Review View Share Comments A A ab v Conditional Formatting Insert v EV AC Format as Table x Delete v Paste I UV V V A v 27 V $~ % 9 Cell Styles v Format X v Sort & Find & Ideas Sensitivity Filter Select C1 X V fx C D E F G H K L M N Chapter 5 Homework Solution Code Note: There are several ways to complete these problems. Use whatever way you feel most comfortable and SHOW YOUR WORK in a professional manner (meaning, so another person can clearly see how you did your calculations with labels!) and use the CHECK YOURSELF to stay on track. Instructor will provide you 2 with the Solution Code to see how these could be calculated (again, other methods are ok as long as amounts agree). 3 ALWAYS REFER TO PROBLEM INSTRUCTIONS FOR REQUIREMENTS! 4 Exercise E SELF CHECK -may be different than what is required! Contribution Margin per Unit = BE in units Contribution Margin per Unit a 10 CM ratio Breakeven in Sales Dollars 11 12 13 BE in sales 14 15 16 Should Peter buy the company? Why or why not? 17 18 19 20 Problem K SELF CHECK ONLY 21 Current Breakeven in Sales Dollars: Current BE in Sales $ 22 23 24 New Sales Total 25 New Sales Total = New Contribution Margin Ratio = 26 27 New Breakeven w/ Sales Promo: 28 29 30 Analysis: Sheet1 Sheet3 + + 100%AutoSave OFF 3 Ch 5 Homework Q v Home Insert Draw Page Layout Formulas Data Review View Share Comments A A ab v Conditional Formatting Insert v EVAC Format as Table v x Delete v Paste I UV V V Av 27 v $ % 9 Cell Styles v Format v X v Sort & Find & Ideas Sensitivity Filter Select 166 X V fx A B C D E F G H K L M N 30 Analysis: 31 32 33 34 35 Alternate Problem C 36 1 and 2. Current Level Hint? 37 Variable cost per unit = 38 39 Contribution margin per unit CM ratio 40 41 Breakeven in Units = Breakeven in Sales = 42 43 44 45 46 47 3. Earn income of $144,000 SELF CHECK ONLY 48 Units to Reach Target Income 49 50 51 Sales to Reach Target Income 52 53 54 55 4. Sales UNITS required to earn $144,000 if selling price $14.40 56 57 Contribution margin per unit 58 59 60 61 62 63 64 65 66 Sheet1 Sheet3 + + 100%Home Insert Draw Page Layout Formulas v A\" AV ('Av Av Data Review View 1' Conditional Formatting v 2% Format as Table v Q Cell Styles v e '5 Share G Comments Insertv 2:2vvpv g @V E Delete v H Sort 81 Find & Ideas Sensitivity Format v X V Filter Select 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 38 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 q p l a Sheet1 Alternate Problem E 1. Current 1. Earn $100,000 per year Analysis: Sheets + El 'U+ 100