In: Accounting
The PC Supply manufactures memory cards that sell to wholesalers for $2.00 each. Variable and fixed costs are as follows: Variable Costs per card Fixed Costs per Month Manufacturing Direct materials $0.30 Direct labor 0.25 Factory overhead 0.25 0.80 Factory overhead $4,000 Selling and admin. 0.15 Selling and admin. 3,000 Total $0.95 Total $7,000 PC Supply produced and sold 10,000 cards during October 2010. There were no beginning or ending inventories.
a. Prepare a contribution income statement for the month of October.
b. Determine PC Supply’s monthly break-even point in units.
c. Determine the effect on monthly profit of a 1,100 unit increase in monthly sales.
d. If PC Supply is subject to an income tax of 28 percent, determine the dollar sales volume is required to earn a monthly after-tax profit of $22,000.
| a | PC Supply | |||
| Contribution Margin Income Statement | ||||
| For the Month Ended | ||||
| Units | 10,000 | |||
| Sales | $20,000 | |||
| Less: Variable cost of goods sold ($0.30 + $0.25 + $0.25) | $8,000 | |||
| Manufacturing margin | $12,000 | |||
| Variable Selling and administrative expenses | $1,500 | |||
| Contribution margin | $10,500 | |||
| Fixed costs: | ||||
| Fixed factory overhead | $4,000 | |||
| Fixed Selling and administrative expenses | $3,000 | |||
| Total fixed costs | $7,000 | |||
| Operating Income | $3,500 | |||
| b | ||||
| Break even point =Fixed cost/ Contribution margin per unit/components | ||||
| $7,000/$1.05 | ||||
| 6,667 units | ||||
| c | PC Supply | |||
| Contribution Margin Income Statement | ||||
| For the Month Ended | ||||
| Units | 11,100 | |||
| Sales | $22,200 | |||
| Less: Variable cost of goods sold ($0.30 + $0.25 + $0.25) | $8,880 | |||
| Manufacturing margin | $13,320 | |||
| Variable Selling and administrative expenses | $1,665 | |||
| Contribution margin | $11,655 | |||
| Fixed costs: | ||||
| Fixed factory overhead | $4,000 | |||
| Fixed Selling and administrative expenses | $3,000 | |||
| Total fixed costs | $7,000 | |||
| Operating Income | $4,655 | |||
| d | 35,767 units | |||
| Let units of z to require after-tax profit of $22,000, So | ||||
| ($1.05z - $7,000) x (1 - 0.28) = $22,000 | ||||
| $0.756z - $5,040 = $22,000 | ||||
| z = 35,767 | ||||
| PC Supply | ||||
| Contribution Margin Income Statement | ||||
| For the Month Ended | ||||
| Units | 35,767 | |||
| Sales | $71,534 | |||
| Less: Variable cost of goods sold ($0.30 + $0.25 + $0.25) | $28,614 | |||
| Manufacturing margin | $42,920 | |||
| Variable Selling and administrative expenses | $5,365 | |||
| Contribution margin | $37,555 | |||
| Fixed costs: | ||||
| Fixed factory overhead | $4,000 | |||
| Fixed Selling and administrative expenses | $3,000 | |||
| Total fixed costs | $7,000 | |||
| Operating Income before tax | $30,555 | |||
| Less: Tax | $8,555 | |||
| Operating Income After tax | $22,000 | |||