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  | 
|