In: Finance
Problem 1-25 Traditional and Contribution Format Income Statements [LO1-6] Milden Company is a merchandiser that plans to sell 31,000 units during the next quarter at a selling price of $58 per unit. The company also gathered the following cost estimates for the next quarter: Cost Cost Formula Cost of good sold $28 per unit sold Advertising expense $178,000 per quarter Sales commissions 5% of sales Shipping expense $48,000 per quarter + $5.00 per unit sold Administrative salaries $88,000 per quarter Insurance expense $9,800 per quarter Depreciation expense $58,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.
Solution: | |||
1. | Milden Company | ||
Contribution Format Income Statement | |||
For the Next Quarter | |||
Sales | 1,798,000 | ||
Variable expenses: | |||
Cost of goods sold | 868,000 | ||
Sales commission | 89,900 | ||
Shipping expense | 155,000 | ||
Total variable expenses | 1,112,900 | ||
Contribution margin | 685,100 | ||
Fixed expenses: | |||
Advertising expense | 178,000 | ||
Shipping expense | 48,000 | ||
Administrative salaries | 88,000 | ||
Insurance expense | 9,800 | ||
Depreciation expense | 58,000 | ||
Total fixed expenses | 381,800 | ||
Net operating income | 303,300 | ||
Working Notes: | |||
Milden Company | |||
Contribution Format Income Statement | |||
See Notes: Below | For the Next Quarter | ||
a | Sales | 1,798,000 | |
[31,000 X $58 ] | |||
Variable expenses: | |||
b | Cost of goods sold | 868,000 | |
[31,000 X $28 ] | |||
c | Sales commission | 89,900 | |
[1,798,000 x 5% ] | |||
d | Shipping expense | 155,000 | |
[31000 x 5 ] | |||
e=b+c+d | Total variable expenses | 1,112,900 | |
f =a-e | Contribution margin | 685,100 | |
Fixed expenses: | |||
g | Advertising expense | 178,000 | |
h | Shipping expense | 48,000 | |
i | Administrative salaries | 88,000 | |
j | Insurance expense | 9,800 | |
k | Depreciation expense | 58,000 | |
l=g+h+i+j+k | Total fixed expenses | 381,800 | |
m=f-l | Net operating income | 303,300 | |
2. | Milden Company | ||
Traditional Format Income Statement | |||
For the Next Quarter | |||
Sales | 1,798,000 | ||
Cost of goods sold | 868,000 | ||
Gross margin | 930,000 | ||
Selling and administrative expenses: | |||
Advertising expense | 178,000 | ||
Administrative salaries | 88,000 | ||
Insurance expense | 9,800 | ||
Depreciation expense | 58,000 | ||
Sales commission | 89,900 | ||
Shipping expense | 203,000 | ||
Total Selling and administrative expenses: | 626,700 | ||
Net operating income | 303,300 | ||
Working Notes: | |||
Milden Company | |||
Traditional Format Income Statement | |||
For the Next Quarter | |||
a | Sales | 1,798,000 | |
b | Cost of goods sold | 868,000 | |
c=a-b | Gross margin | 930,000 | |
Selling and administrative expenses: | |||
d | Advertising expense | 178,000 | |
e | Administrative salaries | 88,000 | |
f | Insurance expense | 9,800 | |
g | Depreciation expense | 58,000 | |
h | Sales commission | 89,900 | |
i | Shipping expense | 203,000 | |
[31000 x 5 + 48000] | |||
j=d+e+f+g+h+i | Total Selling and administrative expenses: | 626,700 | |
k=c-j | Net operating income | 303,300 | |
Please feel free to ask if anything about above solution in comment section of the question. |