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 | $21 per unit sold | |
Advertising expense | $171,000 per quarter | |
Sales commissions | 4% of sales | |
Shipping expense | ? | |
Administrative salaries | $81,000 per quarter | |
Insurance expense | $9,100 per quarter | |
Depreciation expense | $51,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 | 17,000 | $ | 161,000 | |
Second | 19,000 | $ | 176,000 | |
Third | 24,000 | $ | 218,000 | |
Fourth | 20,000 | $ | 181,000 | |
Year 2: | ||||
First | 18,000 | $ | 171,000 | |
Second | 21,000 | $ | 186,000 | |
Third | 27,000 | $ | 231,000 | |
Fourth | 24,000 | $ | 207,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. |
Required: | |
1. | Using the high-low method, estimate a cost formula for shipping expense based on the data for the last eight quarters above. |
2. | In the first quarter of Year 3, the company plans to sell 23,000 units at a selling price of $51 per unit. Prepare a contribution format income statement for the quarter. (Do not round your intermediate calculations.) |
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