In: Accounting
Solomon Modems, Inc. makes modem cards that are used in notebook
computers. The company completed the following transactions during
year 1. All purchases and sales were made with cash.
Required
Use the following partially completed form to prepare an income statement using the contribution margin format.
Determine the break-even point in units and in dollars.
Assume that next year’s sales are budgeted to be the same as the current year’s sales. Determine the margin of safety expressed as a percentage.
a.
SOLOMON MODEMS INC. Income Statement |
||
Sales (6,400*$190) | $1,216,000 | |
Less: Variable cost: | ||
Direct material (6,400*$54) | $345,600 | |
Direct labor (6,400*$39) | 249,600 | |
Manufacturing supplies (6,400*$18) | 115,200 | |
Sales commission (6,400*$13) | 83,200 | |
Total variable cost | 793,600 | |
Contribution margin | 422,400 | |
Less: Fixed cost: | ||
Depreciation on manufacturing equipment ($340,000-44,000/4) | 74,000 | |
Rent on manufacturing facility | 64,000 | |
Depreciation on administrative offices equipment ($53,000-4,400)/3 | 16,200 | |
Administrative expenses | 80,100 | |
Total fixed cost | 234,300 | |
Net income/(loss) | $188,100 |
b.
Break even points in units = Total fixed cost / Contribution per unit
Contribution margin per unit = $422,400/6,400 = $66
Break even points in units = $234,300 / $66 = 3,550 units
Break even points in dollars = 3,550*$190 = $674,500
c
Margin of safety = Current sales - Break even sales / Current sales * 100
Margin of safety = $1,216,000 - 674,500 / 1,216,000 * 100 = 44.53%