Input cells Information: Number of Units Produced 3500 Number of Units Sold 3500 Revenue per unit $325 per unit Salaries for Administrative Staff $72,000 total o Rent of Office Space $25,000 total 1 Direct materials $53 per unit 12 Direct labor $30 per unit 13 Depreciation of Office Equipment $12,500 total 14 Commission for sales staff $12.50 per unit 15 MOH: Rent on Factory Building $44,000 total 16 MOH: Deprecation on Equipment $32,000 total 17 18 A) Contribution Margin Income Statement 19 (Income Statement using Variable Costing) 20 21 Income Statement 22 Contribution Margin Format 23 24 Sales Revenue 25 Variable costs 26 Contribution Margin 27 Fixed Costs 28 Net Income 29 30 31 Operating leverage 32 of produced & sold units increases by 20% 33 what is the revised Net Income? 34 B) Gross Margin Income Statement Income Statement using Absorption Costing) Income Statement (GAAP Format) Sales Revenue Cost of Goods Sold Gross Margin Operating Expenses Net Income 35 36 g Calculate the following using formulas: 37 Total fixed costs 38 Total variable costs per unit 39 Contribution Margin per unit 40 Breakeven point in units 41 Breakeven point in sales dollars 42 43 Margin of Safety in units 44 Margin of safety in dollars 45 Margin of Safety as percent of current sales 46 47 # of units that must be sold to earn 48 $275,000 49 SO The minimum selling price per unit that 51 must be set to earn $350,000 52 53 54 Input cells B) Gross Margin Income Statement Income Statement using Absorption Costing Income Statement (GAAP Format) Sales Revenue Cost of Goods Sold Gross Margin Operating Expenses Net Income C D 14 5 Laformation: 6 Number of Units Produced 3500 7 Number of Units Sold 3500 8 Revenue per unit $325 per unit 9 Salaries for Administrative Staff $72,000 total 10 Rent of Office Space $25,000 total 11 Direct materials $53 per unit 12 Direct Labor $30 per unit 13 Deprecation of Office Equipment $12.500 total 24 Commission for sales staff $12.50 per unit 15 MOH: Rent on Factory Building $44,000 total 16 MOH: Depredation on Equipment $32,000 total 17 18 A) Contribution Margin Income Statement 19 Income Statement using Variable Costing) 20 21 Income Statement 22 Contribution Margin Format 23 24 Sales Revenue 25 Variable Costs 26 Contribution Margin 27 Ford Costs 28 Net Income 29 30 31 Operating Leverage 32 If produced & sold units increases by 20% 33 what is the revised Net Income? 34 35 36 Calculate the following using formulas: 37 Total fixed costs 38 Total variable costs per unit 39 Contribution Margin per unit 40 Breakeven point in units 41 Breakeven point in sales dollars 42 43 Margin of Safety in units 44 Margin of Safety in dollars 45 Margin of Safety as percent of current sales 46 47 # of units that must be sold to earn 48 $275,000 49 50 The minimum selling price per unit that 51 must be set to earn $350,000 52 53 54 55
