How to get variable cost using excel formulas and cells.

B D E F G H OWN Selling price per unit $10 Units sold 10,000 Change in units 2 A manufacturer's contribution margin income statement for the year follows 3 4 Sales ($10 per unit * 10,000 units) $100,000 5 Variable costs 60,000 6 Contribution margin 40,000 7 Fixed costs 30,000 8 Income $10,000 9 10 Required: 11 Prepare a contribution margin income statement if the number of units 12 sold (a) increases by 200 units and (b) decreases by 200 units. 13 14 (Use cells A4 to F18 from the given information to complete this question.) 15 16 Contribution Margin Income Statement 17 For Year Ended December 31 18 10,200 units sold 9,800 units sold 19 Sales $102,000 $98,000 20 Variable costs 21 Contribution margin 22 Fixed costs 23 Income 24 200 Units Units sold 10,200 sold 9,800