In: Accounting
Milden Company is a merchandiser that plans to sell 25,000 units during the next quarter at a selling price of $52 per unit. The company also gathered the following cost estimates for the next quarter:
Cost | Cost Formula | ||
Cost of good sold | $22 per unit sold | ||
Advertising expense | $172,000 per quarter | ||
Sales commissions | 5% of sales | ||
Shipping expense | $54,000 per quarter + $6.00 per unit sold | ||
Administrative salaries | $82,000 per quarter | ||
Insurance expense | $9,200 per quarter | ||
Depreciation expense | $52,000 per quarter | ||
Required:
1. Prepare a contribution format income statement for the next quarter.
2. Prepare a traditional format income statement for the next quarter.
Prepare a contribution format income statement for the next quarter.
|
|
Sales |
[25000 units x $52] |
$ 13,00,000.00 |
Less: Variable costs |
||
Cost of Goods Sold |
[25000 units x $22] |
$ 5,50,000.00 |
Sales Commission |
[25000 units x $52 x 5%] |
$ 65,000.00 |
Shipping expenses |
[25000 units x $6] |
$ 1,50,000.00 |
Total Variable cost |
$ 7,65,000.00 |
|
Contribution Margin |
$ 5,35,000.00 |
|
Less: Fixed Costs |
||
Advertising expense |
$ 1,72,000.00 |
|
Shipping expenses |
$ 54,000.00 |
|
Administrative salaries |
$ 82,000.00 |
|
Insurance expense |
$ 9,200.00 |
|
Depreciation expense |
$ 52,000.00 |
|
Total Fixed Costs |
$ 3,69,200.00 |
|
Net Income |
$ 1,65,800.00 |
Workings for amount can be seen in Requirement 1
Milden Company |
||
Traditional Format Income Statement |
||
For the Next Quarter |
||
Sales |
$ 13,00,000.00 |
|
Cost of goods sold |
$ 5,50,000.00 |
|
Gross margin |
$ 7,50,000.00 |
|
Selling and administrative expenses: |
||
Advertising expense |
$ 1,72,000.00 |
|
Sales commission |
$ 65,000.00 |
|
Shipping expense |
$ 1,50,000.00 |
|
Administrative salaries |
$ 82,000.00 |
|
Insurance expense |
$ 9,200.00 |
|
Depreciation expense |
$ 52,000.00 |
|
Shipping expense |
$ 54,000.00 |
|
Total selling and administrative expenses |
$ 5,84,200.00 |
|
Net operating income |
$ 1,65,800.00 |