Question
Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning,
Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas:
Cost | Cost Formula | |
Cost of good sold | $26 per unit sold | |
Advertising expense | $183,000 per quarter | |
Sales commissions | 7% of sales | |
Shipping expense | ? | |
Administrative salaries | $93,000 per quarter | |
Insurance expense | $10,300 per quarter | |
Depreciation expense | $63,000 per quarter | |
|
Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters follow:
Quarter | Units Sold | Shipping Expense | ||
Year 1: | ||||
First | 29,000 | $ | 173,000 | |
Second | 31,000 | $ | 188,000 | |
Third | 36,000 | $ | 230,000 | |
Fourth | 32,000 | $ | 193,000 | |
Year 2: | ||||
First | 30,000 | $ | 183,000 | |
Second | 33,000 | $ | 198,000 | |
Third | 47,000 | $ | 245,000 | |
Fourth | 44,000 | $ | 221,000 | |
|
Milden Companys president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter.
2. In the first quarter of Year 3, the company plans to sell 35,000 units at a selling price of $56 per unit. Prepare a contribution format income statement for the quarter. (Do not round your intermediate calculations.)
Milden Company | ||
Budgeted Contribution Format Income Statement | ||
For the First Quarter, Year 3 | ||
Sales | $1,960,000 | |
Variable expenses: | ||
Cost of goods sold | $910,000 | |
Sales commissions | ||
Shipping expense | ||
Total variable expenses | 910,000 | |
Contribution margin | 1,050,000 | |
Fixed expenses: | ||
Total fixed expenses | 0 | |
Net operating income | $1,050,000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started